From d8c0f4088dd1619279f6f894766a28bb0ecfe0a4 Mon Sep 17 00:00:00 2001
From: pengmn <pmn@HanInfo>
Date: 星期五, 04 七月 2025 17:21:12 +0800
Subject: [PATCH] 1
---
HH.WCS.Mobox3.HangYang/wms/LocationHelper.cs | 40 +++++++++++++++-------------------------
1 files changed, 15 insertions(+), 25 deletions(-)
diff --git a/HH.WCS.Mobox3.HangYang/wms/LocationHelper.cs b/HH.WCS.Mobox3.HangYang/wms/LocationHelper.cs
index d5e7524..0a53cb9 100644
--- a/HH.WCS.Mobox3.HangYang/wms/LocationHelper.cs
+++ b/HH.WCS.Mobox3.HangYang/wms/LocationHelper.cs
@@ -319,19 +319,7 @@
}
- /// <summary>
- /// 鏍规嵁璐т綅闆嗗悎鑾峰彇 娌℃湁瀹瑰櫒 娌℃湁閿佺殑璐т綅
- /// </summary>
- /// <param name="loc"></param>
- /// <returns></returns>
- internal static List<Location> GetLocListEmptyFree(List<string> loc)
- {
- //1.0 鏌ヨ揣浣嶅鍣ㄨ〃
- var db = new SqlHelper<object>().GetInstance();
- var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM == 0 && a.S_LOCK_STATE.Trim() == "鏃�).ToList();
- return list;
-
- }
+
/// <summary>
/// 鍏ュ簱閿佸畾缁堢偣锛屽嚭搴撻攣瀹氳捣鐐�@@ -472,15 +460,6 @@
return db.Queryable<ZoneLoc>().Where(a => a.S_LOC_CODE == loc).ToList();
}
-
- internal static void Test()
- {
- //澶氭煡璇竴娆′篃鏄彲浠ョ殑锛屽厛鏌ュ嚭鍙敤鐨勮揣浣嶇粍锛岀劧鍚庨�鎷╄揣浣嶇粍涓垪姣旇緝澶х殑锛屾垨鑰呭垪姣旇緝灏忕殑
- var availableRowGroups = new List<Location>().GroupBy(l => l.N_ROW_GROUP).Where(g => !g.Any(l => l.N_LOCK_STATE != 0)).Select(g => g.Key);
-
- var db = new SqlHelper<object>().GetInstance();
- //db.Queryable<Location>().Where(a => a.S_AREA_CODE == "11").Where(a => SqlFunc.Subqueryable<Location>().Where(b => b.)).GroupBy(z => z.N_ROW_GROUP).ToList();
- }
#region 鏉哀璐т綅甯姪Helper
@@ -505,10 +484,21 @@
}
+ /// <summary>
+ /// 鏍规嵁璐т綅闆嗗悎鑾峰彇 娌℃湁瀹瑰櫒 娌℃湁閿佺殑璐т綅
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <returns></returns>
+ internal static List<Location> GetLocListEmptyFree(List<string> loc)
+ {
+ //1.0 鏌ヨ揣浣嶅鍣ㄨ〃
+ var db = new SqlHelper<object>().GetInstance();
+ var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM == 0 && a.S_LOCK_STATE.Trim() == "鏃�).ToList();
+ return list;
+
+ }
+
-
-
-
#endregion
--
Gitblit v1.9.1