From fb41d03f44fb4778d92d72d36eed4e3937828b85 Mon Sep 17 00:00:00 2001 From: lss <2538410689@qq.com> Date: 星期三, 02 七月 2025 17:30:31 +0800 Subject: [PATCH] 优化 --- HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs | 24 ++++++++++++++++++++---- 1 files changed, 20 insertions(+), 4 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 1e23009..d0cffe9 100644 --- a/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs +++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs @@ -20,9 +20,10 @@ { var res = false; var db = new SqlHelper<WCSTask>().GetInstance(); + task.S_B_STATE = status; - task.T_START_TIME = DateTime.Now; - 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) @@ -173,7 +174,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, @@ -200,11 +201,26 @@ 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.S_WORKSHOP_NO }).ExecuteCommand(); + db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.S_WORKSHOP_NO }).ExecuteCommand(); } } } + + 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(); -- Gitblit v1.9.1