From 8361a150d223eb6d4935b5e2e97811055b35d9c2 Mon Sep 17 00:00:00 2001
From: 海波 张 <2956280567@qq.com>
Date: 星期一, 16 六月 2025 17:33:13 +0800
Subject: [PATCH] 创建任务修改
---
wms/LocationHelper.cs | 14 ++++++++++++--
1 files changed, 12 insertions(+), 2 deletions(-)
diff --git a/wms/LocationHelper.cs b/wms/LocationHelper.cs
index 850923e..1ea748e 100644
--- a/wms/LocationHelper.cs
+++ b/wms/LocationHelper.cs
@@ -112,7 +112,7 @@
foreach (var item in locList)
{
var ConnectionList = 0;
- ConnectionList = db.Queryable<WMSTask>().Where(a => (a.S_END_LOC.Contains(item) || a.S_START_LOC.Contains(item)) && a.S_B_STATE != "瀹屾垚" && a.S_B_STATE != "鍙栨秷" && a.S_B_STATE != "閿欒").ToList().Count();
+ ConnectionList = db.Queryable<WMSTask>().Where(a => (a.S_END_LOC.Contains(item) || a.S_START_LOC.Contains(item)) && a.S_B_STATE != "瀹屾垚" && a.S_B_STATE != "鍙栨秷" && a.S_B_STATE != "澶辫触" && a.S_B_STATE != "宸插畬鎴� && a.S_B_STATE != "鏈墽琛�).ToList().Count();
var re = new connectionBalance();
var con = LocationHelper.GetLoc(item);
re.loc = con;
@@ -122,7 +122,17 @@
return result.OrderBy(a => a.taskCount).ToList();
}
-
+ /// <summary>
+ /// 杩斿洖褰撳墠鎺ラ┏浣嶆墽琛屼换鍔℃暟閲�+ /// </summary>
+ internal static int GetConnectionTaskCount(string connection)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+
+ var ConnectionList = 0;
+ ConnectionList = db.Queryable<WMSTask>().Where(a => (a.S_END_LOC.Contains(connection) || a.S_START_LOC.Contains(connection)) && a.S_B_STATE != "瀹屾垚" && a.S_B_STATE != "鍙栨秷" && a.S_B_STATE != "澶辫触" && a.S_B_STATE != "宸插畬鎴� && a.S_B_STATE != "鏈墽琛�).ToList().Count();
+ return ConnectionList;
+ }
/// <summary>
--
Gitblit v1.9.1