From c8f338feee0b6003d8f069b1d37fd9b90dd1b7f4 Mon Sep 17 00:00:00 2001
From: 杨前锦 <1010338399@qq.com>
Date: 星期一, 07 七月 2025 17:31:38 +0800
Subject: [PATCH] 印尼佳通优化
---
HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/WCSHelper.cs | 13 ++++++++++---
1 files changed, 10 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..9d9103f 100644
--- a/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/WCSHelper.cs
+++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/WCSHelper.cs
@@ -25,6 +25,7 @@
{
var res = false;
var db = new SqlHelper<WCSTask>().GetInstance();
+ task.T_MODIFY = DateTime.Now;
res = db.Updateable(task).ExecuteCommand() > 0;
return res;
}
@@ -65,14 +66,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 +90,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 +234,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