From 00b6105b34870f6f5a33551534d0088f3f741906 Mon Sep 17 00:00:00 2001
From: 海波 张 <2956280567@qq.com>
Date: 星期一, 07 七月 2025 17:33:53 +0800
Subject: [PATCH] 退库修改
---
wms/LocationHelper.cs | 265 ++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 211 insertions(+), 54 deletions(-)
diff --git a/wms/LocationHelper.cs b/wms/LocationHelper.cs
index 531baa1..9c7c0df 100644
--- a/wms/LocationHelper.cs
+++ b/wms/LocationHelper.cs
@@ -15,6 +15,7 @@
using static HH.WCS.ZhongCeJinTan.api.ApiModel;
using static HH.WCS.ZhongCeJinTan.util.Settings;
using static HH.WCS.ZhongCeJinTan.wms.WcsModel;
+using static ICSharpCode.SharpZipLib.Zip.ExtendedUnixData;
namespace HH.WCS.ZhongCeJinTan.wms
{
@@ -94,6 +95,21 @@
{
var db = new SqlHelper<object>().GetInstance();
var ConnectionList = db.Queryable<Location>().Where(s => s.S_AREA_CODE == S_AREA_CODE && s.C_ENABLE == "Y").OrderBy(a => a.N_ROW).OrderBy(a => a.N_COL).ToList();
+ List<string> result = new List<string>();
+ foreach (var item in ConnectionList)
+ {
+ result.Add(item.S_CODE);
+ }
+ return result;
+ }
+
+ /// <summary>
+ /// 鑾峰彇璐т綅淇℃伅,鍙傛暟搴撳尯缂栧彿
+ /// </summary>
+ internal static List<string> GetConnectionListByN(string S_AREA_CODE)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+ var ConnectionList = db.Queryable<Location>().Where(s => s.S_AREA_CODE == S_AREA_CODE && s.C_ENABLE == "N").OrderBy(a => a.N_ROW).OrderBy(a => a.N_COL).ToList();
List<string> result = new List<string>();
foreach (var item in ConnectionList)
{
@@ -501,6 +517,93 @@
/// <summary>
+ /// 鐗╂枡鍧囪
+ /// </summary>
+ /// <param name="lstTrueLocation"></param>
+ /// <returns></returns>
+ public static List<Location> RoadWayBalance1ByItem(List<Location> lstTrueLocation, string itemCode)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+
+
+ //鎸囧畾璁＄畻鍚庤繑鍥炵殑瀹炰綋
+ List<Location> location_roadray = new List<Location>();
+
+
+ List<connectionBalance> result = new List<connectionBalance>();
+
+ var newlstTrueLocation = lstTrueLocation.GroupBy(c => c.N_ROADWAY)
+ .Select(g => g.First()) // 鎴栬� g.FirstOrDefault()
+ .ToList();
+
+ foreach (var item in newlstTrueLocation)
+ {
+ var ConnectionList = 0;
+
+ var loclist = lstTrueLocation.Where(o => o.N_ROADWAY == item.N_ROADWAY && o.N_CURRENT_NUM>0).OrderBy(b => b.N_ROW).OrderBy(b => b.N_COL).ToList();
+ foreach (var item1 in loclist)
+ {
+ var tp = db.Queryable<LocCntrRel>().Where(s => s.S_LOC_CODE == item1.S_CODE).First();
+
+ // LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣璐т綅瀹瑰櫒淇℃伅" + JsonConvert.SerializeObject(tp), "Mes浠诲姟涓嬪彂");
+ if (tp != null && item1.S_LOCK_STATE == "鏃�)
+ {
+ var tp1 = db.Queryable<CntrItemRel>().Where(s => s.S_CNTR_CODE == tp.S_CNTR_CODE).First();
+ //LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣瀹瑰櫒鐗╂枡淇℃伅" + JsonConvert.SerializeObject(tp1), "Mes浠诲姟涓嬪彂");
+
+ if (tp1 != null && tp1.S_ITEM_CODE == itemCode)
+ {
+ ConnectionList += 1;
+ }
+ }
+ }
+
+ var re = new connectionBalance();
+
+ var con = LocationHelper.GetLoc(item.S_CODE);
+ re.loc = con;
+ re.taskCount = ConnectionList;
+ result.Add(re);
+ }
+
+
+
+ result = result.OrderBy(a=>a.taskCount).ToList();
+
+ foreach (var item in result)
+ {
+ location_roadray.Add(item.loc);
+ }
+
+
+ return location_roadray;
+ }
+
+
+
+ /// <summary>
+ /// 杩斿洖鍧囪 鐨勬帴椹充綅闆嗗悎
+ /// </summary>
+ internal static List<connectionBalance> GetBalanceConnectionList3(List<string> locList)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+
+ List<connectionBalance> result = new List<connectionBalance>();
+
+ foreach (var item in locList)
+ {
+ var ConnectionList = 0;
+ ConnectionList = db.Queryable<WMSTask>().Where(a => (a.S_END_LOC.Contains(item) || a.S_START_LOC.Contains(item)) && a.S_B_STATE != "瀹屾垚" && a.S_B_STATE != "鍙栨秷" && a.S_B_STATE != "澶辫触" && a.S_B_STATE != "宸插畬鎴� && a.S_B_STATE != "鏈墽琛�).ToList().Count();
+ var re = new connectionBalance();
+ var con = LocationHelper.GetLoc(item);
+ re.loc = con;
+ re.taskCount = ConnectionList;
+ result.Add(re);
+ }
+ return result.OrderBy(a => a.taskCount).ToList();
+ }
+
+ /// <summary>
/// 鎵剧粓鐐瑰彲鐢ㄧ┖璐т綅鎺掗櫎涓嶅彲鐢ㄥ贩閬� /// </summary>
/// <param name="locations"></param>
@@ -681,10 +784,17 @@
/// </summary>
/// <param name="locations"></param>
/// <returns></returns>
- internal static Location FindStartcolByLoclistAndcntr(List<Location> locations,string startArea) {
+ internal static Location FindStartcolByLoclistAndcntr(List<Location> locations,string startArea, string CONNECTION = "") {
var db = new SqlHelper<object>().GetInstance();
try
{
+
+
+ var connectionList = LocationHelper.GetConnectionList(CONNECTION);
+
+
+ var balanceConnectionList = LocationHelper.GetConnectionListByst(connectionList);
+
Location start = null;
var rowsStart = locations.Select(a => a.N_ROW).Distinct().ToList();
@@ -698,6 +808,8 @@
var flag = false;
+ var flag2 = false;
+
foreach (var item in rowdwa)
{
if (rowList.Count(a => a.N_ROADWAY.ToString() == item.roadWay) > 0)
@@ -707,7 +819,17 @@
}
}
- if (flag)
+ foreach (var item2 in balanceConnectionList)
+ {
+ if (rowList.Count(a => a.N_ROADWAY != item2.CONNEC_ROADWAY) > 0)
+ {
+ flag2 = true;
+ break;
+ }
+ }
+
+
+ if (flag || flag2)
{
continue;
}
@@ -916,13 +1038,21 @@
/// </summary>
/// <param name="locations"></param>
/// <returns></returns>
- internal static Location FindStartcolByLoclistAndItem(List<Location> locations,string itemCode,string endArea,string rodway="")
+ internal static Location FindStartcolByLoclistAndItem(List<Location> locations,string itemCode,string endArea,string rodway="",string CONNECTION="")
{
var db = new SqlHelper<object>().GetInstance();
try
{
Location start = null;
var rowsStart = locations.Select(a => a.N_ROW).Distinct().ToList();
+
+
+ var connectionList = LocationHelper.GetConnectionListByN(CONNECTION);
+
+
+ var balanceConnectionList = LocationHelper.GetConnectionListByst(connectionList);
+
+
LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟鎺掗櫎涓嶅彲鐢ㄥ贩閬撳紑濮�, "Mes浠诲姟涓嬪彂");
//浣滀笟娴佺▼鐨勫贩閬�@@ -937,7 +1067,7 @@
}
else
{
- //鏌ユ壘鍙敤宸烽亾
+ //鏌ユ壘涓嶅彲鐢ㄥ贩閬� rowdwa = db.Queryable<RoadWayEnable>().Where(x => x.areaCode == endArea && x.status == "0").ToList();
}
@@ -946,7 +1076,7 @@
// LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟璧风偣搴撳尯{endArea}鎵句笉鍒板彲鐢ㄥ贩閬�, "Mes浠诲姟涓嬪彂");
// return null;
//}
-
+
for (int i = 0; i < rowsStart.Count; i++)
{
@@ -954,6 +1084,7 @@
var flag = false;
var flag1 = false;
+ var flag2 = false;
foreach (var item in rowdwa)
{
@@ -972,59 +1103,69 @@
}
}
- if (flag1 || flag)
+ foreach (var item2 in balanceConnectionList)
{
- locations.RemoveAll(a => a.N_ROW == rowsStart[i]);
- }
-
- //rowList.Count(a => a.S_LOCK_STATE.Trim() != "鏃�) > 0 ||
- //褰撳墠鎺掓湁閿佸苟涓旀病鏈夋弧璐т綅锛屾帓闄�- if ( rowList.Count(a => a.N_CURRENT_NUM == 1) == 0)
- {
- locations.RemoveAll(a => a.N_ROW == rowsStart[i]);
- }
- }
-
- DateTime date = DateTime.Now;
- List<CntrItemRel> startList = new List<CntrItemRel>(); ;
-
- LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟鎺掗櫎涓嶅彲鐢ㄥ贩閬撳畬鎴�, "Mes浠诲姟涓嬪彂");
-
- foreach (var item in locations) {
- if (item.N_CURRENT_NUM==0)
- {
- continue;
- }
-
- var tp = db.Queryable<LocCntrRel>().Where(s => s.S_LOC_CODE == item.S_CODE).First();
-
- LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣璐т綅瀹瑰櫒淇℃伅" + JsonConvert.SerializeObject(tp), "Mes浠诲姟涓嬪彂");
- if (tp != null && item.S_LOCK_STATE == "鏃�)
- {
- var tp1 = db.Queryable<CntrItemRel>().Where(s => s.S_CNTR_CODE == tp.S_CNTR_CODE).First();
- LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣瀹瑰櫒鐗╂枡淇℃伅" + JsonConvert.SerializeObject(tp1), "Mes浠诲姟涓嬪彂");
-
- if (tp1 != null && tp1.S_ITEM_CODE== itemCode&& tp1.S_ITEM_STATE == "鍚堟牸" && tp1.takeEffectTime < date && tp1.expireTime > date)
+ if (rowList.Count(a => a.N_ROADWAY == item2.CONNEC_ROADWAY) > 0)
{
- LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣鍚堟牸瀹瑰櫒鐗╂枡锛屽鍣ㄥ彿{tp1.S_CNTR_CODE}", "Mes浠诲姟涓嬪彂");
- startList.Add(tp1);
+ flag2 = true;
+ break;
}
}
- }
- LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣鍚堟牸鐗╂枡鏁伴噺{startList.Count}", "Mes浠诲姟涓嬪彂");
- var startItem = startList.OrderBy(a => a.PRODUCTIONDATE).FirstOrDefault();
+ if (flag1 || flag || flag2)
+ {
+ locations.RemoveAll(a => a.N_ROW == rowsStart[i]);
+ }
- LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣鎸夌敓浜ф椂闂存帓搴忕墿鏂欎俊鎭� + JsonConvert.SerializeObject(startItem), "Mes浠诲姟涓嬪彂");
- if (startItem!=null)
- {
-
+ //rowList.Count(a => a.S_LOCK_STATE.Trim() != "鏃�) > 0 ||
+ //褰撳墠鎺掓湁閿佸苟涓旀病鏈夋弧璐т綅锛屾帓闄�+ if (rowList.Count(a => a.N_CURRENT_NUM == 1) == 0)
+ {
+ locations.RemoveAll(a => a.N_ROW == rowsStart[i]);
+ }
+ }
- var tp = db.Queryable<LocCntrRel>().Where(s => s.S_CNTR_CODE == startItem.S_CNTR_CODE).First();
- start = LocationHelper.GetLocOne(tp.S_LOC_CODE);
- LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣璐т綅淇℃伅" + JsonConvert.SerializeObject(start), "Mes浠诲姟涓嬪彂");
- }
- return start;
+ DateTime date = DateTime.Now;
+ List<CntrItemRel> startList = new List<CntrItemRel>(); ;
+
+ LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟鎺掗櫎涓嶅彲鐢ㄥ贩閬撳畬鎴�, "Mes浠诲姟涓嬪彂");
+
+ LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟鎺掗櫎瀹屾垚璐т綅鏁伴噺{locations.Count}", "Mes浠诲姟涓嬪彂");
+
+ foreach (var item in locations)
+ {
+ if (item.N_CURRENT_NUM == 0)
+ {
+ continue;
+ }
+
+ var tp = db.Queryable<LocCntrRel>().Where(s => s.S_LOC_CODE == item.S_CODE).First();
+
+ LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣璐т綅瀹瑰櫒淇℃伅" + JsonConvert.SerializeObject(tp), "Mes浠诲姟涓嬪彂");
+ if (tp != null && item.S_LOCK_STATE == "鏃�)
+ {
+ var tp1 = db.Queryable<CntrItemRel>().Where(s => s.S_CNTR_CODE == tp.S_CNTR_CODE).First();
+ LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣瀹瑰櫒鐗╂枡淇℃伅" + JsonConvert.SerializeObject(tp1), "Mes浠诲姟涓嬪彂");
+
+ if (tp1 != null && tp1.S_ITEM_CODE == itemCode && tp1.S_ITEM_STATE == "鍚堟牸" && tp1.takeEffectTime < date && tp1.expireTime > date)
+ {
+ LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣鍚堟牸瀹瑰櫒鐗╂枡锛屽鍣ㄥ彿{tp1.S_CNTR_CODE}", "Mes浠诲姟涓嬪彂");
+ startList.Add(tp1);
+ }
+ }
+ }
+
+ LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣鍚堟牸鐗╂枡鏁伴噺{startList.Count}", "Mes浠诲姟涓嬪彂");
+ var startItem = startList.OrderBy(a => a.PRODUCTIONDATE).FirstOrDefault();
+
+ LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣鎸夌敓浜ф椂闂存帓搴忕墿鏂欎俊鎭� + JsonConvert.SerializeObject(startItem), "Mes浠诲姟涓嬪彂");
+ if (startItem != null)
+ {
+ var tp = db.Queryable<LocCntrRel>().Where(s => s.S_CNTR_CODE == startItem.S_CNTR_CODE).First();
+ start = LocationHelper.GetLocOne(tp.S_LOC_CODE);
+ LogHelper.Info($"ZCSendTask鍑哄簱浠诲姟涓嬪彂璧风偣璐т綅淇℃伅" + JsonConvert.SerializeObject(start), "Mes浠诲姟涓嬪彂");
+ }
+ return start;
}
catch (Exception)
{
@@ -1104,9 +1245,6 @@
for (int i = 0; i < rowsStart.Count; i++)
{
var rowList = locations.Where(r => r.N_ROW == rowsStart[i]).ToList().OrderByDescending(a => a.N_COL);
-
-
-
//rowList.Count(a => a.S_LOCK_STATE.Trim() != "鏃�) > 0 ||
//褰撳墠鎺掓湁閿佸苟涓旀病鏈夋弧璐т綅锛屾帓闄�@@ -1427,6 +1565,25 @@
}
/// <summary>
+ /// 鑾峰彇寮傚父搴撳尯
+ /// </summary>
+ /// <returns></returns>
+ internal static bool GetErroArea(string area)
+ {
+ var db = new SqlHelper<object>().GetInstance();
+ var erroArea = db.Queryable<Area>().Where(a => a.S_NAME.Contains("寮傚父") && a.S_CODE.Contains(area)).First();
+
+ if (erroArea == null)
+ {
+ return false;
+ }
+ else {
+ return true;
+ }
+ }
+
+
+ /// <summary>
/// 鍏ュ簱閿佸畾缁堢偣锛屽嚭搴撻攣瀹氳捣鐐� /// </summary>
/// <param name="loc"></param>
--
Gitblit v1.9.1