From e888bfb15f44a57f4fd61182c00bad066f093ee9 Mon Sep 17 00:00:00 2001 From: lss <2538410689@qq.com> Date: 星期四, 03 七月 2025 22:56:51 +0800 Subject: [PATCH] 111 --- 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