From 011d17bc8df981ba31e895873ab0e4a17da8288f Mon Sep 17 00:00:00 2001 From: lss <2538410689@qq.com> Date: 星期四, 26 六月 2025 17:46:13 +0800 Subject: [PATCH] 优化 --- HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs | 20 +++++++++++++++++++- 1 files changed, 19 insertions(+), 1 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..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,7 +20,9 @@ { var res = false; var db = new SqlHelper<WCSTask>().GetInstance(); + task.S_B_STATE = status; + db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE }).ExecuteCommand(); return res; } @@ -172,6 +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, @@ -198,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.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(); } } } + + 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