From b7308bba3d7ffad271ce7fc7a93c8c45d76be87d Mon Sep 17 00:00:00 2001
From: 杨前锦 <1010338399@qq.com>
Date: 星期五, 13 六月 2025 17:21:03 +0800
Subject: [PATCH] 优化印尼佳通-硫化胚胎出入库逻辑策略优化
---
HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/LocationHelper.cs | 25 +++++++++++++++++++++++--
1 files changed, 23 insertions(+), 2 deletions(-)
diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/LocationHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/LocationHelper.cs
index 5ad847a..b5f0207 100644
--- a/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/LocationHelper.cs
+++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/LocationHelper.cs
@@ -112,6 +112,19 @@
return db.Queryable<Location>().Where(a => a.S_AREA_CODE.Trim() == areaCode && a.N_CURRENT_NUM == 0 && a.N_LOCK_STATE == 0 && a.C_ENABLE == "Y").First();
}
+ internal static bool checkAreaExistCntr(List<string> areaCodes ,string cntrCode)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<Location>()
+ .LeftJoin<LocCntrRel>((a,b) => a.S_CODE == b.S_LOC_CODE)
+ .Where((a, b) => areaCodes.Contains(a.S_AREA_CODE.Trim())
+ && a.N_CURRENT_NUM == 0
+ && a.N_LOCK_STATE == 0
+ && a.C_ENABLE == "Y"
+ && b.S_CNTR_CODE == cntrCode
+ ).Count() > 0;
+ }
+
/// <summary>
///鑾峰彇鎵�湁璐т綅鎵╁睍淇℃伅
/// </summary>
@@ -150,8 +163,16 @@
});
}
return result;
-
}
+
+ internal static LocCntrRel GetLocCntrByCntr(string cntrCode)
+ {
+ var result = new List<LocCntrRel>();
+ //1.0 鏌ヨ揣浣嶅鍣ㄨ〃
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<LocCntrRel>().Where(a => a.S_CNTR_CODE.Trim() == cntrCode).OrderBy(a => a.T_CREATE).First();
+ }
+
internal static List<LocCntrRel> GetLocCntrRel(string loc) {
//1.0 鏌ヨ揣浣嶅鍣ㄨ〃
var db = new SqlHelper<object>().GetInstance();
@@ -293,7 +314,7 @@
try
{
db.BeginTran();
- var count = db.Deleteable<LocCntrRel>().Where(it => it.S_LOC_CODE.Trim() == loc).ExecuteCommand();
+ db.Deleteable<LocCntrRel>().Where(it => it.S_LOC_CODE.Trim() == loc).ExecuteCommand();
location.N_CURRENT_NUM = 0;
location.N_LOCK_STATE = 0;
location.S_LOCK_STATE = Location.GetLockStateStr(location.N_LOCK_STATE);
--
Gitblit v1.9.1