From 071a7efe34469cbfc0f5401291c6e3ba21f31b19 Mon Sep 17 00:00:00 2001
From: 18256738414 <634643841@qq.com>
Date: 星期四, 24 七月 2025 21:29:16 +0800
Subject: [PATCH] 双钱，空托自动上线优先空托货架区
---
core/Monitor.cs | 135 ++++++++++++++++++++++++++++++++++++++++----
1 files changed, 122 insertions(+), 13 deletions(-)
diff --git a/core/Monitor.cs b/core/Monitor.cs
index f15790e..42f7747 100644
--- a/core/Monitor.cs
+++ b/core/Monitor.cs
@@ -351,11 +351,103 @@
}
/// <summary>
+ /// 妫�祴鍘熸潗鏂欎骇绾夸笅绾块檮杩戞槸鍚︽湁绌轰綅
+ /// </summary>
+ internal static void CheckEmptyLoc_YclOutLineArea()
+ {
+ try
+ {
+ var db = new SqlHelper<object>().GetInstance();
+
+ var endLoc = db.Queryable<TN_Location>().
+ Where(o => o.S_AREA_CODE == Settings.Areas[15]
+ && o.N_LOCK_STATE == 0
+ && o.S_LOCK_STATE == "鏃�
+ && o.C_ENABLE == "Y"
+ && o.N_CURRENT_NUM == 0
+ && SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == o.S_CODE).NotAny()
+ ).//鍘熸潗鏂欎骇绾块檮杩戠┖鎵樺簱鍖�+ First();
+
+ if (endLoc == null)
+ {
+ LogHelper.Info($"鍘熸潗鏂欎骇绾块檮杩戠┖鎵樺簱鍖簕Settings.Areas[15]}锛屽凡婊★紝鏃犻渶鍐嶅叆绌烘墭");
+ return;
+ }
+
+ var startLoc = db.Queryable<TN_Location>().
+ Where(o => o.S_AREA_CODE == Settings.Areas[3]
+ && o.N_LOCK_STATE == 0
+ && o.S_LOCK_STATE == "鏃�
+ && o.C_ENABLE == "Y"
+ && o.N_CURRENT_NUM == o.N_CAPACITY
+ && SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == o.S_CODE).Any()
+ ).ToList().//绌烘墭鍫嗗彔搴撳尯
+ FirstOrDefault();
+
+ if (startLoc == null)
+ {
+ startLoc = db.Queryable<TN_Location>().
+ Where(o => o.S_AREA_CODE == Settings.Areas[16]
+ && o.N_LOCK_STATE == 0
+ && o.S_LOCK_STATE == "鏃�
+ && o.C_ENABLE == "Y"
+ && o.N_CURRENT_NUM == o.N_CAPACITY
+ && SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == o.S_CODE).Any()
+ ).ToList().//绌烘墭璐ф灦搴撳尯
+ FirstOrDefault();
+ }
+
+ if (startLoc == null)
+ {
+ LogHelper.Info($"妫�祴鍘熸潗鏂欎骇绾夸笅绾块檮杩戞槸鍚︽湁绌轰綅,璧风偣娌℃湁鎵惧埌鍚堥�鐨勭┖鎵樿揣浣嶏紝瑕佹眰鏈夎揣");
+ return;
+ }
+
+ var cntrList = db.Queryable<TN_Loc_Container>().Where(a => a.S_LOC_CODE == startLoc.S_CODE).OrderBy(a => a.T_CREATE, OrderByType.Asc).ToList();
+
+ if (cntrList.Count < 1)
+ {
+ LogHelper.Info($"妫�祴鍘熸潗鏂欎骇绾夸笅绾块檮杩戞槸鍚︽湁绌轰綅,璧风偣{startLoc.S_CODE}鏈壘鍒拌揣浣嶅鍣ㄥ叧绯讳俊鎭�);
+ return;
+ }
+
+ string cntrString = "";
+ for (int i = 0; i < cntrList.Count; i++)
+ {
+ if (i == cntrList.Count - 1)//鏈�悗涓�釜瀛楃涓茶繛鎺ヤ笉鍔犻�鍙�+ {
+ cntrString += cntrList[i].S_CNTR_CODE;
+ }
+ else
+ {
+ cntrString += cntrList[i].S_CNTR_CODE + ",";
+ }
+ }
+
+ if (WCSHelper.CreateTask(startLoc.S_CODE, endLoc.S_CODE, "绌烘墭鑷姩涓婄嚎", 3, cntrString))//鍒涘缓鎼�浠诲姟锛岃捣鐐圭粓鐐瑰鍣�+ {
+ LocationHelper.LockLoc(startLoc.S_CODE, 2);//璧风偣鍑哄簱閿侊紝
+ LocationHelper.LockLoc(endLoc.S_CODE, 1);//缁堢偣鍏ュ簱閿�+
+ LogHelper.Info($"妫�祴鍘熸潗鏂欎骇绾夸笅绾块檮杩戞槸鍚︽湁绌轰綅,鐢熸垚绌烘墭鑷姩涓婄嚎浠诲姟鎴愬姛锛屽鍣細{cntrString}锛岃捣鐐癸細{startLoc.S_CODE}");
+ }
+ else
+ {
+ LogHelper.Info($"妫�祴鍘熸潗鏂欎骇绾夸笅绾块檮杩戞槸鍚︽湁绌轰綅,鐢熸垚绌烘墭鑷姩涓婄嚎浠诲姟澶辫触锛屽鍣細{cntrString}锛岃捣鐐癸細{startLoc.S_CODE}");
+ }
+ }
+ catch (Exception ex)
+ {
+ LogHelper.Error(ex.Message, ex);
+ }
+ }
+
+ /// <summary>
/// 绾胯竟婊℃墭璐т綅鑷姩瑙ｇ粦
/// </summary>
internal static void XBChekcFull()
{
- var db = new SqlHelper<object>().GetInstance();
try
{
@@ -709,14 +801,14 @@
}
else
{
- LogHelper.Info("閲嶉噺鐩哥瓑锛屽悓姝N_DayProDetail璺宠繃");
+ //LogHelper.Info("閲嶉噺鐩哥瓑锛屽悓姝N_DayProDetail璺宠繃");
}
}
}
}
else
{
- LogHelper.Info("褰撳ぉ鐨勮揣鍝佽鏍煎垪琛ㄤ负0锛屽悓姝N_DayProDetail璺宠繃");
+ //LogHelper.Info("褰撳ぉ鐨勮揣鍝佽鏍煎垪琛ㄤ负0锛屽悓姝N_DayProDetail璺宠繃");
}
// 鍚屾 TN_WeekProSpcDetail
@@ -747,14 +839,14 @@
}
else
{
- LogHelper.Info("閲嶉噺鐩哥瓑锛屽悓姝N_WeekProSpcDetail璺宠繃");
+ //LogHelper.Info("閲嶉噺鐩哥瓑锛屽悓姝N_WeekProSpcDetail璺宠繃");
}
}
}
}
else
{
- LogHelper.Info("褰撳懆鐨勮揣鍝佽鏍煎垪琛ㄤ负0锛屽悓姝N_WeekProSpcDetail璺宠繃");
+ //LogHelper.Info("褰撳懆鐨勮揣鍝佽鏍煎垪琛ㄤ负0锛屽悓姝N_WeekProSpcDetail璺宠繃");
}
// 鍚屾 TN_MonthProSpcDetail
@@ -785,14 +877,14 @@
}
else
{
- LogHelper.Info("閲嶉噺鐩哥瓑锛屽悓姝N_MonthProSpcDetail璺宠繃");
+ //LogHelper.Info("閲嶉噺鐩哥瓑锛屽悓姝N_MonthProSpcDetail璺宠繃");
}
}
}
}
else
{
- LogHelper.Info("褰撴湀鐨勮揣鍝佽鏍煎垪琛ㄤ负0锛屽悓姝N_MonthProSpcDetail璺宠繃");
+ //LogHelper.Info("褰撴湀鐨勮揣鍝佽鏍煎垪琛ㄤ负0锛屽悓姝N_MonthProSpcDetail璺宠繃");
}
// 鍚屾 TN_YearProSpcDetail
@@ -824,14 +916,14 @@
}
else
{
- LogHelper.Info("閲嶉噺鐩哥瓑锛屽悓姝N_YearProSpcDetail璺宠繃");
+ //LogHelper.Info("閲嶉噺鐩哥瓑锛屽悓姝N_YearProSpcDetail璺宠繃");
}
}
}
}
else
{
- LogHelper.Info("褰撳勾鐨勮揣鍝佽鏍煎垪琛ㄤ负0锛屽悓姝N_YearProSpcDetail璺宠繃");
+ //LogHelper.Info("褰撳勾鐨勮揣鍝佽鏍煎垪琛ㄤ负0锛屽悓姝N_YearProSpcDetail璺宠繃");
}
}
catch (Exception ex)
@@ -991,12 +1083,29 @@
}
var endLoc = db.Queryable<TN_Location>().
- Where(a => a.S_AREA_CODE == Settings.Areas[4] && a.N_LOCK_STATE == 0
+ Where(a => a.S_AREA_CODE == Settings.Areas[15] && a.N_LOCK_STATE == 0
&& a.S_LOCK_STATE == "鏃� && a.C_ENABLE == "Y" && a.N_CURRENT_NUM == 0
&& SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == a.S_CODE).NotAny()
- ).
- OrderBy(a => a.N_CURRENT_NUM, OrderByType.Asc).
- First();
+ ).First();//鍏堟壘 鍘熸潗鏂欎骇绾块檮杩戠┖鎵樺簱鍖�+
+ if (endLoc == null)
+ {
+ endLoc = db.Queryable<TN_Location>().
+ Where(a => a.S_AREA_CODE == Settings.Areas[16] && a.N_LOCK_STATE == 0
+ && a.S_LOCK_STATE == "鏃� && a.C_ENABLE == "Y" && a.N_CURRENT_NUM == 0
+ && SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == a.S_CODE).NotAny()
+ ).First();
+ }// 鍐嶆壘 绌烘墭璐ф灦搴撳尯
+
+ if (endLoc == null)
+ {
+ endLoc = db.Queryable<TN_Location>().
+ Where(a => a.S_AREA_CODE == Settings.Areas[4] && a.N_LOCK_STATE == 0
+ && a.S_LOCK_STATE == "鏃� && a.C_ENABLE == "Y" && a.N_CURRENT_NUM == 0
+ && SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == a.S_CODE).NotAny()
+ ).First();
+ }// 鏈�悗鎵�绌烘墭缂撳瓨搴撳尯
+
if (endLoc == null)
{
--
Gitblit v1.9.1