出库审核逻辑修改

hudong

2025-07-04 67c7f0449f57933c26d785c277ddcd539c899b25

 wms/WCSHelper.cs

@@ -156,17 +156,30 @@
                    task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE);
                    task.T_START_TIME = DateTime.Now;
                    db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME }).ExecuteCommand();

                    var wmstask = db.Queryable<WMSTask>().Where(s => s.S_CODE == task.S_OP_CODE).First();
                    wmstask.N_B_STATE = 2;
                    wmstask.S_B_STATE = WCSTask.GetStateStr(wmstask.N_B_STATE);
                    wmstask.T_START_TIME = DateTime.Now;
                    db.Updateable(wmstask).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME }).ExecuteCommand();
                }

            }
        }
        internal static void End(WCSTask task) {
            LogHelper.Info($"修改状态 ");
            var db = new SqlHelper<WCSTask>().GetInstance();
            if (task != null) {
                task.N_B_STATE = 3;
                task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE);
                task.T_END_TIME = DateTime.Now;
                db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand();
                LogHelper.Info($"修改状态为3 ");
                var wmstask = db.Queryable<WMSTask>().Where(s => s.S_CODE == task.S_OP_CODE).First();
                wmstask.N_B_STATE = 3;
                wmstask.S_B_STATE = WCSTask.GetStateStr(wmstask.N_B_STATE);
                wmstask.T_END_TIME = DateTime.Now;
                db.Updateable(wmstask).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand();
            }
        }
        internal static void Fail(WCSTask task) {
@@ -175,7 +188,15 @@
                //判断有没有取货完成，没有就变成失败。有取货完成默认完成了（跟据项目而定，有些项目人工拉走了也没有放到终点）。
                task.N_B_STATE = 5;
                task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE);
                db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE }).ExecuteCommand();
                task.T_END_TIME = DateTime.Now;
                db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand();


                var wmstask = db.Queryable<WMSTask>().Where(s => s.S_CODE == task.S_OP_CODE).First();
                wmstask.N_B_STATE = 5;
                wmstask.S_B_STATE = WCSTask.GetStateStr(wmstask.N_B_STATE);
                wmstask.T_END_TIME = DateTime.Now;
                db.Updateable(wmstask).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand();
            }
        }
        internal static bool CreateTask(WCSTask TN_Task) {
@@ -207,7 +228,7 @@
        }
        internal static List<WCSTask> GetWaitingTaskList() {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<WCSTask>().Where(a => a.N_B_STATE == 0).ToList();
            return db.Queryable<WCSTask>().Where(a => a.N_B_STATE == 0).OrderByDescending(s=>s.N_PRIORITY).ToList();
        }
        //前移车执行中任务 
        internal static List<WCSTask> GetWaitingTaskGoList()