From 71129e21a35a2d4be75ee0f1e96e2c51ced5f23b Mon Sep 17 00:00:00 2001 From: lss <Lss@HanInfo> Date: 星期四, 05 六月 2025 17:25:46 +0800 Subject: [PATCH] 大洋原材料库开发 --- HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/WCSHelper.cs | 10 ++++++++-- 1 files changed, 8 insertions(+), 2 deletions(-) diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/WCSHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/WCSHelper.cs index f0d1e7a..ec5bcdb 100644 --- a/HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/WCSHelper.cs +++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/wms/WCSHelper.cs @@ -145,7 +145,7 @@ } return res; } - internal static bool AddActionRecord(string no, int state, string forkliftNo, string extData,string Type) + internal static bool AddActionRecord(string no, int state, string forkliftNo, string extData, string Type) { var db = new SqlHelper<TaskAction>().GetInstance(); var action = new TaskAction() @@ -236,7 +236,7 @@ internal static List<WCSTask> GetTaskbyType(string type) { var db = new SqlHelper<object>().GetInstance(); - string[] statue = new string[] { "瀹屾垚", "鍙栨秷", "閿欒","绛夊緟" }; + string[] statue = new string[] { "瀹屾垚", "鍙栨秷", "閿欒", "绛夊緟" }; return db.Queryable<WCSTask>().Where(a => a.S_TYPE == type && !statue.Contains(a.S_B_STATE)).ToList(); } @@ -245,6 +245,12 @@ var db = new SqlHelper<object>().GetInstance(); return db.Queryable<WCSTask>().Where(a => a.N_B_STATE == state).ToList(); } + + internal static WCSTask GetTaskByOpName(string opCode, int state) + { + var db = new SqlHelper<object>().GetInstance(); + return db.Queryable<WCSTask>().Where(a => a.S_OP_CODE == opCode && a.N_B_STATE == state).First(); + } internal static List<WCSTask> GetWaitingTaskList() { var db = new SqlHelper<object>().GetInstance(); -- Gitblit v1.9.1