From 3a3c5f5711a57439f34e772313fcbb18ba7885bc Mon Sep 17 00:00:00 2001
From: hudong <Administrator@PC-20250329JZUF>
Date: 星期一, 14 七月 2025 10:31:15 +0800
Subject: [PATCH] 优化
---
wms/WCSHelper.cs | 25 +++++++++++++++++++++++--
1 files changed, 23 insertions(+), 2 deletions(-)
diff --git a/wms/WCSHelper.cs b/wms/WCSHelper.cs
index 3a7a53c..2c9b1e3 100644
--- a/wms/WCSHelper.cs
+++ b/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($"淇敼鐘舵�涓� ");
+ 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()
--
Gitblit v1.9.1