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.FJJT/wms/WCSHelper.cs | 12 +++++++++---
1 files changed, 9 insertions(+), 3 deletions(-)
diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/WCSHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/WCSHelper.cs
index 4d19c85..02fa96c 100644
--- a/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/WCSHelper.cs
+++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/WCSHelper.cs
@@ -65,14 +65,14 @@
Where(a => a.S_OP_CODE.Trim() == wmsTaskNo
&& a.N_B_STATE == -1
);
- if (anomaly == 1)
+ /*if (anomaly == 1)
{
updateable = updateable.Where(a => a.S_TYPE.Contains("銆愬紓甯搞�"));
}
else
{
updateable = updateable.Where(a => !a.S_TYPE.Contains("銆愬紓甯搞�"));
- }
+ }*/
return updateable.ExecuteCommand() > 0;
}
@@ -89,6 +89,12 @@
internal static WCSTask GetTask(string no) {
var db = new SqlHelper<WCSTask>().GetInstance();
var task = db.Queryable<WCSTask>().Where(a => a.S_CODE.Trim() == no).First();
+ return task;
+ }
+ internal static WCSTask GetTaskByEq(string eq)
+ {
+ var db = new SqlHelper<WCSTask>().GetInstance();
+ var task = db.Queryable<WCSTask>().Where(a => a.S_EQ_NO.Trim() == eq && a.N_B_STATE < 3).OrderByDescending(a => a.T_CREATE).First();
return task;
}
internal static WCSTask GetTaskBySrcNo(string no) {
@@ -227,7 +233,7 @@
}
internal static List<WCSTask> GetWaitingTaskList() {
var db = new SqlHelper<object>().GetInstance();
- return db.Queryable<WCSTask>().Where(a => a.N_B_STATE == 0).ToList();
+ return db.Queryable<WCSTask>().Where(a => a.N_B_STATE == 0).OrderByDescending(a => a.N_PRIORITY).ToList();
}
}
}
--
Gitblit v1.9.1