福建佳通-流程优化

杨前锦

2025-07-01 a93b0e99036c24b9bd58c79bf5e7364b1ba28bae

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

@@ -30,6 +30,15 @@
            db.Updateable(task).UpdateColumns(it => new {it.N_B_STATE, it.S_B_STATE,it.T_MODIFY ,it.S_EQ_NO }).ExecuteCommand();
            return res;
        }

        public static bool updateTaskEnd(WCSTask task) 
        {
            var res = false;
            var db = new SqlHelper<WCSTask>().GetInstance();
            res = db.Updateable(task).UpdateColumns(it => new { it.S_END_LOC, it.S_END_AREA, it.T_MODIFY}).ExecuteCommand() > 0;
            return res;
        }

        internal static bool UpdateInfo(WCSTask task, string sourceNo, string endBit, string status) {
            var res = false;
            var db = new SqlHelper<WCSTask>().GetInstance();
@@ -54,6 +63,11 @@
            var db = new SqlHelper<WCSTask>().GetInstance();
            var task = db.Queryable<WCSTask>().Where(a => a.S_EQ_NO == eqNo).OrderByDescending(a => a.T_CREATE).First();
            return task;
        }
        internal static List<WCSTask> GetTaskListByEqNo(string eqNo)
        {
            var db = new SqlHelper<WCSTask>().GetInstance();
            return db.Queryable<WCSTask>().Where(a => a.S_EQ_NO == eqNo).OrderByDescending(a => a.T_CREATE).ToList();
        }

        internal static List<WCSTask> GetTaskByStart(string bit) {
@@ -95,9 +109,6 @@
                N_SCHEDULE_TYPE=1,
                S_B_STATE = "等待",
                S_CNTR_CODE = cntrInfo,
                N_START_LAYER = startLayer,
                N_END_LAYER = endLayer,
                N_CNTR_COUNT = cntrCount

            };

@@ -169,12 +180,16 @@
            if (task != null)
            {
                task.N_B_STATE = 4;
                if (WCSHelper.CheckActionRecordExist(task.S_CODE, 4))
                WCSHelper.UpdateStatus(task, "取消");

                var mst = WMSHelper.GetWmsTask(task.S_OP_CODE);
                if (mst != null) 
                {
                    WCSHelper.UpdateStatus(task, "强制完成");
                }
                else {
                    WCSHelper.UpdateStatus(task, "取消");
                    LocationHelper.UnLockLoc(mst.S_END_LOC);

                    mst.N_B_STATE = 3;
                    mst.S_B_STATE = "取消";
                    WMSHelper.UpdateTaskState(mst);
                }
            } 
        }