From 279721980221a604d6e3dffa48d13ee9dbd0134a Mon Sep 17 00:00:00 2001 From: lss <Lss@HanInfo> Date: 星期一, 16 六月 2025 18:21:48 +0800 Subject: [PATCH] 优化 --- HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs | 10 ++++++++-- 1 files changed, 8 insertions(+), 2 deletions(-) diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs index 8ffeb37..35b3f3a 100644 --- a/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs +++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs @@ -20,8 +20,13 @@ { 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 }).ExecuteCommand(); + + db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE, it.T_START_TIME }).ExecuteCommand(); return res; } internal static bool UpdateStatus(WCSTask task) @@ -172,6 +177,7 @@ 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, @@ -198,7 +204,7 @@ 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.T_START_TIME, it.S_WORKSHOP_NO }).ExecuteCommand(); + db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.S_WORKSHOP_NO }).ExecuteCommand(); } } -- Gitblit v1.9.1