From 1c7cb41e75dece1ec91039625fcc434776df3821 Mon Sep 17 00:00:00 2001 From: 杨张扬 <634643841@qq.com> Date: 星期二, 01 七月 2025 17:33:22 +0800 Subject: [PATCH] 满托入库按照第一层先入 --- core/Monitor.cs | 9 ++++++--- 1 files changed, 6 insertions(+), 3 deletions(-) diff --git a/core/Monitor.cs b/core/Monitor.cs index 769c3f2..f79b8a9 100644 --- a/core/Monitor.cs +++ b/core/Monitor.cs @@ -137,7 +137,7 @@ && c.N_LOCK_STATE == 0 && c.N_CURRENT_NUM == 0 && SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == c.S_CODE).NotAny()//涓嶈兘鏈夎揣 && c.C_ENABLE == "Y"). - OrderBy(o => o.T_MODIFY, OrderByType.Asc).First();//鏌ヨ鍚堥�鐨勭粓鐐硅揣浣嶏紝鐩存帴鍒ゆ柇褰撳墠鏁伴噺涓�鍗冲彲 + OrderBy(o => o.N_LAYER, OrderByType.Asc).First();//鏌ヨ鍚堥�鐨勭粓鐐硅揣浣嶏紝鐩存帴鍒ゆ柇褰撳墠鏁伴噺涓�鍗冲彲 if (endLoc != null) { @@ -370,7 +370,9 @@ return; } - var endLoc = db.Queryable<TN_Location>().First(a => a.S_AREA_CODE == Settings.Areas[1] + var endLoc = db.Queryable<TN_Location>() + .OrderBy(a => a.N_LAYER, OrderByType.Asc) + .First(a => a.S_AREA_CODE == Settings.Areas[1] && a.N_CURRENT_NUM == 0 && a.N_LOCK_STATE == 0 && a.S_LOCK_STATE == "鏃� && SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == a.S_CODE).NotAny()//涓嶈兘鏈夎揣 ); @@ -483,7 +485,8 @@ var endLoc_2 = db.Queryable<TN_Location>() .Where(o => o.S_AREA_CODE == Settings.Areas[2] && SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == o.S_CODE).NotAny()//涓嶈兘鏈夎揣 - && o.N_CURRENT_NUM == 0 && o.N_LOCK_STATE == 0 && o.S_LOCK_STATE == "鏃�).First(); + && o.N_CURRENT_NUM == 0 && o.N_LOCK_STATE == 0 && o.S_LOCK_STATE == "鏃�) + .First(); if (endLoc_2 != null) { -- Gitblit v1.9.1