叠盘机优化

lss

昨天 1319cb7072623dff12369a889af766db2d166def

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

@@ -20,13 +20,10 @@
        {
            var res = false;
            var db = new SqlHelper<WCSTask>().GetInstance();
            if (status == "取货完成")
            {
                task.T_START_TIME = DateTime.Now;
            }
           
            task.S_B_STATE = status;

            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)
@@ -174,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 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 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)
        {
@@ -209,6 +210,21 @@

            }
        }

        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();