叠盘机优化

lss

昨天 1319cb7072623dff12369a889af766db2d166def

 HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs

@@ -20,9 +20,10 @@
        {
            var res = false;
            var db = new SqlHelper<WCSTask>().GetInstance();
           
            task.S_B_STATE = status;
            task.T_START_TIME = DateTime.Now;
            db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE,it.T_START_TIME }).ExecuteCommand();

            db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE }).ExecuteCommand();
            return res;
        }
        internal static bool UpdateStatus(WCSTask task)
@@ -170,19 +171,23 @@
            }
            return res;
        }
        public static object _add;
        internal static bool AddActionRecord(string no, int state, string forkliftNo, string extData)
        {
            var db = new SqlHelper<TaskAction>().GetInstance();
         
            var action = new TaskAction()
            {
                N_ACTION_CODE = state,
                S_TASK_CODE = no,
                S_EQ_CODE = forkliftNo,
                S_EQ_TYPE = "agv",
                S_DATA = extData
            };
            return db.Insertable(action).ExecuteCommand() > 0;
           
                var db = new SqlHelper<TaskAction>().GetInstance();

                var action = new TaskAction()
                {
                    N_ACTION_CODE = state,
                    S_TASK_CODE = no,
                    S_EQ_CODE = forkliftNo,
                    S_EQ_TYPE = "agv",
                    S_DATA = extData
                };
                return db.Insertable(action).ExecuteCommand() > 0;
            
          
        }
        internal static bool CheckActionRecordExist(string no, int code)
        {
@@ -200,11 +205,26 @@
                    task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE);
                    task.T_START_TIME = DateTime.Now;
                    task.S_WORKSHOP_NO = agvno;
                    db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE,  it.S_WORKSHOP_NO }).ExecuteCommand();
                    db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.S_WORKSHOP_NO }).ExecuteCommand();
                }

            }
        }

        internal static void UpdateAgvNo(WCSTask task, string agvno)
        {
            var db = new SqlHelper<WCSTask>().GetInstance();
            if (task != null)
            {

     
                task.T_START_TIME = DateTime.Now;
                task.S_WORKSHOP_NO = agvno;
                db.Updateable(task).UpdateColumns(it => new { it.T_START_TIME, it.S_WORKSHOP_NO }).ExecuteCommand();


            }
        }
        internal static void End(WCSTask task)
        {
            var db = new SqlHelper<WCSTask>().GetInstance();