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 | 420 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 420 insertions(+), 0 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
new file mode 100644
index 0000000..b5f0207
--- /dev/null
+++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/LocationHelper.cs
@@ -0,0 +1,420 @@
+锘縰sing HH.WCS.Mobox3.FJJT.util;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace HH.WCS.Mobox3.FJJT.wms {
+ internal class LocationHelper {
+ public class LocationExt {
+ public string S_PICKUP_POINT { get; internal set; }
+ public string S_LOC_CODE { get; internal set; }
+ public string S_AGV_SITE { get; internal set; }
+ }
+ private static Dictionary<string, Location> Locations = null;
+ private static Dictionary<string, LocationExt> LocationExts = null;
+
+ static LocationHelper() {
+ try {
+ //鍒濆鍖朙ocation鍔犲叆鍒板瓧鍏哥紦瀛�+ Locations = new Dictionary<string, Location>();
+ var list = GetAllLocList();
+ if (list.Count > 0) {
+ list.ForEach(a => {
+ if (!Locations.ContainsKey(a.S_CODE)) {
+ Locations.Add(a.S_CODE, a);
+ }
+ });
+ }
+ //鍒濆鍖朙ocationExt鍔犲叆鍒伴泦鍚堢紦瀛�+ //LocationExts = new Dictionary<string, LocationExt>();
+ //var exts = GetAllLocExtList();
+ //if (exts.Count > 0) {
+ // exts.ForEach(a => {
+ // LocationExts.Add($"{a.S_LOC_CODE.Trim()}_{a.S_PICKUP_POINT.Trim()}", a);
+ // });
+ //}
+ }
+ catch (Exception ex) {
+ Console.WriteLine(ex.Message);
+ }
+ }
+
+ internal static bool CheckExist(string loc) {
+ return Locations.Keys.Contains(loc);
+ }
+ internal static Location GetLocation(string loc) {
+ if (CheckExist(loc.Trim())) {
+ return Locations[loc.Trim()];
+ }
+ return null;
+ }
+ internal static List<FunctionArea> GetFunctionAreas(string masterCls, string msterCode) {
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<FunctionArea>().Where(a => a.S_MASTER_CLS == masterCls && a.S_MASTER_CODE == msterCode).ToList();
+ }
+ internal static List<FunctionArea> GetFunctionAreas(string masterCls, string msterCode, int nType) {
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<FunctionArea>().Where(a => a.S_MASTER_CLS == masterCls && a.S_MASTER_CODE == msterCode && a.N_TYPE == nType).ToList();
+ }
+ internal static FunctionArea GetFunctionAreaByCode(string faCode, int faType, int nType) {
+ var db = new SqlHelper<object>().GetInstance();
+ // && a.N_FA_TYPE == faType
+ return db.Queryable<FunctionArea>().Where(a => a.S_FA_CODE == faCode && a.N_TYPE == nType).First();
+ }
+ /// <summary>
+ /// 鑾峰彇璐т綅绔欑偣淇℃伅
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <returns></returns>
+ internal static string GetAgvSite(string loc) {
+ var site = "0";
+ if (Locations.Keys.Contains(loc.Trim())) {
+ var Location = Locations[loc.Trim()];
+ site = Location.S_AGV_SITE;
+ }
+ else {
+ var Location = GetLoc(loc.Trim());
+ if (Location != null) {
+ Locations.Add(loc.Trim(), Location);
+ site = Location.S_AGV_SITE;
+ }
+ }
+ return site;
+ }
+
+ internal static int GetAgvSite(string loc, string actionType) {
+ var site = 0;
+ var key = $"{loc.Trim()}_{actionType.Trim()}";
+ if (LocationExts.Keys.Contains(loc.Trim())) {
+ var Location = LocationExts[loc.Trim()];
+ site = int.Parse(Location.S_AGV_SITE);
+ }
+ return site;
+ }
+
+ /// <summary>
+ /// 鑾峰彇鎵�湁璐т綅淇℃伅
+ /// </summary>
+ /// <returns></returns>
+ internal static List<Location> GetAllLocList() {
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<Location>().ToList();
+ }
+ internal static Location GetLoc(string code) {
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<Location>().Where(a => a.S_CODE.Trim() == code).First();
+ }
+ internal static Location GetEmptyLoc(string areaCode)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+ 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>
+ /// <returns></returns>
+ internal static List<LocationExt> GetAllLocExtList() {
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<LocationExt>().ToList();
+ }
+
+ /// <summary>
+ /// 鍒ゆ柇娌℃湁鍏ュ簱閿佸拰鍑哄簱閿�+ /// </summary>
+ /// <param name="code"></param>
+ /// <returns></returns>
+ internal static bool CheckLocFree(string code) {
+ var result = false;
+ var loc = GetLoc(code);
+ if (loc != null) {
+ result = loc.N_LOCK_STATE == 0;
+ }
+ return result;
+ }
+ internal static List<LocCntrRel> GetLocCntr(string loc) {
+ var result = new List<LocCntrRel>();
+ //1.0 鏌ヨ揣浣嶅鍣ㄨ〃
+ var db = new SqlHelper<object>().GetInstance();
+ var list = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE.Trim() == loc).OrderBy(a => a.T_CREATE).ToList();
+ if (list.Count > 0) {
+ list.ForEach(a => {
+ //鑾峰彇瀹瑰櫒淇℃伅
+ var cntr = db.Queryable<Container>().Where(b => b.S_CODE.Trim() == a.S_CNTR_CODE).First();
+ if (cntr != null) {
+ a.Container = cntr;
+ result.Add(a);
+ }
+ });
+ }
+ 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();
+ var result = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE == loc.Trim()).ToList();
+ return result;
+
+ }
+
+ /// <summary>
+ /// 鏍规嵁璐т綅闆嗗悎鑾峰彇鏈夊鍣ㄧ殑璐т綅
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <returns></returns>
+ internal static List<Location> GetLocList(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).ToList();
+ return list;
+
+ }
+
+ /// <summary>
+ /// 鏍规嵁璐т綅缂栫爜鑾峰彇璐т綅淇℃伅锛屼笉绠℃湁娌℃湁瀹瑰櫒
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <returns></returns>
+ internal static List<Location> GetLocListAny(List<string> loc) {
+ //1.0 鏌ヨ揣浣嶅鍣ㄨ〃
+ var db = new SqlHelper<object>().GetInstance();
+ var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE)).ToList();
+ return list;
+
+ }
+
+ /// <summary>
+ /// 鏍规嵁璐т綅闆嗗悎鑾峰彇鏈夊鍣�娌℃湁閿佺殑璐т綅
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <returns></returns>
+ internal static List<Location> GetLocListFree(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.N_LOCK_STATE == 0).ToList();
+ return list;
+
+ }
+
+ /// <summary>
+ /// 鑾峰彇鍥哄畾鏁伴噺瀹瑰櫒 娌℃湁閿佺殑璐т綅
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <param name="current"></param>
+ /// <returns></returns>
+ internal static List<Location> GetLocListFree(List<string> loc, int current) {
+ //1.0 鏌ヨ揣浣嶅鍣ㄨ〃
+ var db = new SqlHelper<object>().GetInstance();
+ var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM == current && a.N_LOCK_STATE == 0).ToList();
+ return list;
+
+ }
+
+ /// <summary>
+ /// 鑾峰彇鏁伴噺澶т簬绛変簬鍥哄畾鏁伴噺瀹瑰櫒 娌℃湁閿佺殑璐т綅
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <param name="current"></param>
+ /// <returns></returns>
+ internal static List<Location> GetLocList(List<string> loc, int current) {
+ //1.0 鏌ヨ揣浣嶅鍣ㄨ〃
+ var db = new SqlHelper<object>().GetInstance();
+ var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM >= current && a.N_LOCK_STATE == 0).ToList();
+ return list;
+
+ }
+
+ /// <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.N_LOCK_STATE == 0).ToList();
+ return list;
+
+ }
+
+ /// <summary>
+ /// 鍏ュ簱閿佸畾缁堢偣锛屽嚭搴撻攣瀹氳捣鐐�+ /// </summary>
+ /// <param name="loc"></param>
+ /// <param name="lockState">1:鍏ュ簱閿併�2:鍑哄簱閿併�2:鍏跺畠閿�/param>
+ /// <returns></returns>
+ public static bool LockLoc(string loc, int lockState) {
+ var res = false;
+ var db = new SqlHelper<object>().GetInstance();
+ var model = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == loc).First();
+ if (model != null && model.N_LOCK_STATE == 0) {
+ model.N_LOCK_STATE = lockState;
+ model.S_LOCK_STATE = Location.GetLockStateStr(lockState);
+ res = db.Updateable(model).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand() > 0;
+ }
+ return res;
+ }
+
+ /// <summary>
+ /// 鍙栬揣瀹岃В閿佽捣鐐癸紝鍗歌揣瀹岃В閿佺粓鐐癸紝鍙楠岄攣鐨勬潵婧愶紝涔熷彲浠ヤ笉鏍￠獙
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <returns></returns>
+ public static bool UnLockLoc(string loc) {
+ LogHelper.Info("UnLockLoc:" + loc);
+ var res = false;
+ var db = new SqlHelper<object>().GetInstance();
+ var model = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == loc).First();
+ if (model != null) {
+ model.N_LOCK_STATE = 0;
+ model.S_LOCK_STATE = Location.GetLockStateStr(model.N_LOCK_STATE);
+ res = db.Updateable(model).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand() > 0;
+ LogHelper.Info("UnLockLoc:瑙ｉ攣缁撴灉" + res);
+ }
+ else {
+ LogHelper.Info("UnLockLoc 澶辫触");
+ }
+ return res;
+ }
+
+ /// <summary>
+ /// 鍒犻櫎璐т綅瀹瑰櫒琛ㄨ褰�淇敼璐т綅瀹瑰櫒鏁伴噺
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <returns></returns>
+ public static bool UnBindingLoc(string loc)
+ {
+ var res = false;
+ var db = new SqlHelper<object>().GetInstance();
+ var location = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == loc).First();
+ try
+ {
+ db.BeginTran();
+ 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);
+ db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM, it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand();
+ db.CommitTran();
+ res = true;
+ }
+ catch (Exception ex)
+ {
+ db.RollbackTran();
+ }
+ return res;
+ }
+
+ /// <summary>
+ /// 鍒犻櫎璐т綅瀹瑰櫒琛ㄨ褰�淇敼璐т綅瀹瑰櫒鏁伴噺
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <param name="cntrs"></param>
+ /// <returns></returns>
+ public static bool UnBindingLoc(string loc, List<string> cntrs) {
+ var res = false;
+ var db = new SqlHelper<object>().GetInstance();
+ var location = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == loc).First();
+ try {
+ db.BeginTran();
+ var lcrList = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE.Trim() == loc).ToList();
+ if (lcrList.Count > 0) {
+ var count = db.Deleteable<LocCntrRel>().Where(it => cntrs.Contains(it.S_CNTR_CODE.Trim()) && it.S_LOC_CODE.Trim() == loc).ExecuteCommand();
+ location.N_CURRENT_NUM = lcrList.Count - count;
+ location.N_LOCK_STATE = 0;
+ location.S_LOCK_STATE = Location.GetLockStateStr(location.N_LOCK_STATE);
+ db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM, it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand();
+ }
+ db.CommitTran();
+ res = true;
+ }
+ catch (Exception ex) {
+ db.RollbackTran();
+ }
+ return res;
+ }
+ /// <summary>
+ /// 璐т綅缁戝畾瀹瑰櫒
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <param name="cntrs"></param>
+ /// <returns></returns>
+ public static bool BindingLoc(string loc, List<string> cntrs) {
+ var res = false;
+ var db = new SqlHelper<object>().GetInstance();
+ var location = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == loc).First();
+ try {
+ var lcrList = db.Queryable<LocCntrRel>().Includes(a => a.Container).Where(a => a.S_LOC_CODE.Trim() == loc).ToList();
+ db.BeginTran();
+ int count = 0;
+ cntrs.ForEach(a => {
+ if (lcrList.Count(b => b.S_CNTR_CODE.Trim() == a) == 0) {
+ db.Insertable<LocCntrRel>(new LocCntrRel { S_LOC_CODE = loc, S_CNTR_CODE = a }).ExecuteCommand();
+ count++;
+ }
+ });
+ location.N_CURRENT_NUM = lcrList.Count + count;
+ location.N_LOCK_STATE = 0;
+ location.S_LOCK_STATE = Location.GetLockStateStr(location.N_LOCK_STATE);
+
+ res = db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM, it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand() > 0;
+ db.CommitTran();
+ res = true;
+ }
+ catch (Exception ex) {
+ Console.WriteLine(ex.Message);
+ db.RollbackTran();
+ }
+ return res;
+ }
+
+ /// <summary>
+ /// 鍒ゆ柇閫昏緫搴撳尯鏄惁鏈夊彲鐢ㄨ揣浣�+ /// </summary>
+ /// <param name="zone"></param>
+ /// <exception cref="NotImplementedException"></exception>
+ internal static bool CheckZoneFree(string zone) {
+ var db = new SqlHelper<object>().GetInstance();
+ var count = db.Queryable<ZoneLoc>().Includes(a => a.Loc).Where(a => a.S_ZONE_CODE == zone && a.Loc.N_LOCK_STATE == 0).Count();
+ return count > 0;
+ }
+ internal static ZoneLoc GetZoneLoc(string zone) {
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<ZoneLoc>().Includes(a => a.Loc).Where(a => a.S_ZONE_CODE == zone && a.Loc.N_LOCK_STATE == 0 && a.Loc.N_CURRENT_NUM == 0).First();
+
+ }
+ internal static List<ZoneLoc> GetZoneByLoc(string loc) {
+ var db = new SqlHelper<object>().GetInstance();
+ return db.Queryable<ZoneLoc>().Where(a => a.S_LOC_CODE == loc).ToList();
+
+ }
+
+ internal static object GetFunctionCodeByArea(string v1, int v2, int v3) {
+ throw new NotImplementedException();
+ }
+ }
+}
--
Gitblit v1.9.1