From d471478f1b3373a9001ab9ebc4eb7f52384a4ec3 Mon Sep 17 00:00:00 2001 From: Tjiny <Tjinyu23@163.com> Date: 星期四, 29 五月 2025 17:11:37 +0800 Subject: [PATCH] 2025/5/29提交 --- HH.WCS.Mobox3.RiDong/generalMethod/LocationMethod.cs | 26 ++++++++++++++++++++++++-- 1 files changed, 24 insertions(+), 2 deletions(-) diff --git a/HH.WCS.Mobox3.RiDong/generalMethod/LocationMethod.cs b/HH.WCS.Mobox3.RiDong/generalMethod/LocationMethod.cs index 77d4303..52c1f39 100644 --- a/HH.WCS.Mobox3.RiDong/generalMethod/LocationMethod.cs +++ b/HH.WCS.Mobox3.RiDong/generalMethod/LocationMethod.cs @@ -173,7 +173,28 @@ // 鏌ヨ鍑烘墍鏈夎浼樺厛绾х殑鍙敤璐т綅 var locations = sqlSugarClient.Queryable<Location>() .Where(p => p.N_PRIORITY == priority && p.N_CURRENT_NUM == 0 && p.N_LOCK_STATE == 0 && p.N_PURPOSE == 1).ToList(); - + + // 浼樺厛鏌ヨ浠婃棩浠戒换鍔′腑鏈畬鎴愮殑锛堢瓑寰咃紝鎵ц涓級 + var notQueryList = AdoSqlMethod<Operation>.QueryList(p=>p.N_B_STATE < 2 && p.T_CREATE.Date == DateTime.Today); + + if (notQueryList.Count > 0) + { + var groupBy = notQueryList.GroupBy(p=>p.N_ROADWAY); + + foreach (var item in groupBy) + { + if (item.Key == 1 || item.Key == 2 || item.Key == 3 || + item.Key == 4) + { + locations = locations.Where(p=>p.N_ROADWAY != item.Key).ToList(); + } + else if (item.Key == 5 && item.ToList().Count >= 3) + { + locations = locations.Where(p=>p.N_ROADWAY != item.Key).ToList(); + } + } + } + // 瀛樺湪璇ヤ紭鍏堢骇鐨勫彲鐢ㄨ揣浣� if (locations.Count > 0) { @@ -199,7 +220,8 @@ .Where(p => p.N_PRIORITY == i && p.N_CURRENT_NUM == 0 && p.N_LOCK_STATE == 0 && p.N_PURPOSE == 1).ToList(); // 浼樺厛鏌ヨ浠婃棩浠戒换鍔′腑鏈畬鎴愮殑锛堢瓑寰咃紝鎵ц涓級 - var notQueryList = AdoSqlMethod<Operation>.QueryList(p=>p.N_B_STATE < 2 && p.T_CREATE.Date == DateTime.Today); + var notQueryList = AdoSqlMethod<Operation> + .QueryList(p=>p.N_B_STATE < 2 && p.T_CREATE.Date == DateTime.Today && (p.N_TYPE == 1 || p.N_TYPE == 3)); if (notQueryList.Count > 0) { -- Gitblit v1.9.1