From d42ad8b01195def2a9309930e14f90ff13ad47b1 Mon Sep 17 00:00:00 2001
From: 杨前锦 <1010338399@qq.com>
Date: 星期四, 19 六月 2025 17:24:28 +0800
Subject: [PATCH] 印尼佳通出入库策略优化
---
HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_PT/wms/WCSHelper.cs | 17 ++++++++++++++---
1 files changed, 14 insertions(+), 3 deletions(-)
diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_PT/wms/WCSHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_PT/wms/WCSHelper.cs
index b321ef3..d04f74e 100644
--- a/HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_PT/wms/WCSHelper.cs
+++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_PT/wms/WCSHelper.cs
@@ -30,6 +30,15 @@
db.Updateable(task).UpdateColumns(it => new {it.N_B_STATE, it.S_B_STATE,it.T_MODIFY ,it.S_EQ_NO }).ExecuteCommand();
return res;
}
+
+ public static bool updateTaskEnd(WCSTask task)
+ {
+ var res = false;
+ var db = new SqlHelper<WCSTask>().GetInstance();
+ res = db.Updateable(task).UpdateColumns(it => new { it.S_END_LOC, it.S_END_AREA, it.T_MODIFY}).ExecuteCommand() > 0;
+ return res;
+ }
+
internal static bool UpdateInfo(WCSTask task, string sourceNo, string endBit, string status) {
var res = false;
var db = new SqlHelper<WCSTask>().GetInstance();
@@ -54,6 +63,11 @@
var db = new SqlHelper<WCSTask>().GetInstance();
var task = db.Queryable<WCSTask>().Where(a => a.S_EQ_NO == eqNo).OrderByDescending(a => a.T_CREATE).First();
return task;
+ }
+ internal static List<WCSTask> GetTaskListByEqNo(string eqNo)
+ {
+ var db = new SqlHelper<WCSTask>().GetInstance();
+ return db.Queryable<WCSTask>().Where(a => a.S_EQ_NO == eqNo).OrderByDescending(a => a.T_CREATE).ToList();
}
internal static List<WCSTask> GetTaskByStart(string bit) {
@@ -95,9 +109,6 @@
N_SCHEDULE_TYPE=1,
S_B_STATE = "绛夊緟",
S_CNTR_CODE = cntrInfo,
- N_START_LAYER = startLayer,
- N_END_LAYER = endLayer,
- N_CNTR_COUNT = cntrCount
};
--
Gitblit v1.9.1