From c7cc6a7851eb8c3caa697d3a8382a1ff09db2586 Mon Sep 17 00:00:00 2001
From: pulg <plg@Haninfo>
Date: 星期四, 26 六月 2025 18:55:08 +0800
Subject: [PATCH] 1
---
HH.WCS.QingXiNongfu/wms/TaskHelper.cs | 83 +++++++++++++++++++++++++++++++++++++----
1 files changed, 74 insertions(+), 9 deletions(-)
diff --git a/HH.WCS.QingXiNongfu/wms/TaskHelper.cs b/HH.WCS.QingXiNongfu/wms/TaskHelper.cs
index 39e81ec..c314fd7 100644
--- a/HH.WCS.QingXiNongfu/wms/TaskHelper.cs
+++ b/HH.WCS.QingXiNongfu/wms/TaskHelper.cs
@@ -1,4 +1,5 @@
-锘縰sing HH.WCS.QingXigongchang.util;
+锘縰sing HH.WCS.QingXigongchang.process;
+using HH.WCS.QingXigongchang.util;
using Newtonsoft.Json;
using SqlSugar;
using System;
@@ -81,18 +82,34 @@
var db = new SqlHelper<WMSTask>().GetInstance();
return db.Queryable<WMSTask>().Where(a => a.S_TYPE.Trim() == taskType).ToList();
}
- internal static bool CreateTask(string no, string from, string to, string taskType, int pri, string cntrInfo, int cntrCount = 1, int startLayer = 1, int endLayer = 1, string note = "", bool lockLoc = false)
+ internal static bool CreateTask(string no, string from, string to, string taskType, int pri, string cntrInfo, int cntrCount = 1, int startLayer = 1, int endLayer = 1, string note = "", bool lockLoc = false, string TwoEndLoc = "")
{
var fromLoc = LocationHelper.GetLoc(from);
var endLoc = LocationHelper.GetLoc(to);
+ var chi = new SqlHelper<object>().GetInstance();
+ var newDb = chi.CopyNew();
+ //NDCHelper.ChangeParam(taskNo, agvsite, 2);
+ //NDCHelper.ChangeParam(taskNo, 2, 6);
+
if (fromLoc.S_AREA_CODE == "YWLRGDD")
{
//鏌ヨ浠诲姟琛� 瑕佹眰鏄彧鑳界敓鎴愪袱涓换鍔�璧风偣搴撳尯涓篩WLRGDD hh_plg 2025骞�鏈�鏃�
+
+ var TaskListNum = newDb.Queryable<Location>().Where(l => l.S_AREA_CODE == "YWLRGDD" && l.S_LOCK_STATE == "鍑哄簱閿�).ToList();
+ if (TaskListNum.Count() >= 3)
+ {
+ LogHelper.Info($"CreateTransport- CreateTask Error" + $"璧风偣搴撳尯涓篩WLRGDD 鍒欐渶澶氬彧鑳界敓鎴愪笁涓换鍔�);
+ return false;
+ }
+ }
+ else if (endLoc.S_AREA_CODE == "YWLWJJB")
+ {
+ //鏌ヨ浠诲姟琛� 瑕佹眰鏄彧鑳界敓鎴愪袱涓换鍔�璧风偣搴撳尯涓篩WLWJJB hh_plg 2025骞�鏈�鏃�
List<string> TaskState = new List<string>() { "瀹屾垚", "鍙栨秷" };
- var TaskListNum = LocationHelper.GetList<WMSTask>(x => x.S_START_LAREA == "YWLRGDD" && !TaskState.Contains(x.S_B_STATE));
+ var TaskListNum = LocationHelper.GetList<WMSTask>(x => x.S_END_LAREA == "YWLWJJB" && !TaskState.Contains(x.S_B_STATE));
if (TaskListNum.Count() >= 2)
{
- LogHelper.Info($"CreateTransport- CreateTask Error" + $"璧风偣搴撳尯涓篩WLRGDD 鍒欐渶澶氬彧鑳界敓鎴愪袱涓换鍔�);
+ LogHelper.Info($"CreateTransport- CreateTask Error" + $"缁堢偣搴撳尯涓篩WLWJJB 鍒欐渶澶氬彧鑳界敓鎴愪袱涓换鍔�);
return false;
}
}
@@ -103,11 +120,20 @@
LogHelper.Info($"CreateTransport- CreateTask Error" + $"璧风偣鎴栫粓鐐硅揣浣嶆暟鎹畁ull");
return false;
}
- if (fromLoc.S_LOCK_STATE.Trim() != "鏃� || endLoc.S_LOCK_STATE.Trim() != "鏃�)
+ if (fromLoc.S_AREA_CODE != "YWLWJJB")
{
- LogHelper.Info($"CreateTransport- CreateTask Error" + $"璧风偣 {fromLoc.S_LOCK_STATE}鎴栫粓鐐箋endLoc.S_LOCK_STATE}鐘舵�涓嶄负 鏃�");
- return false;
+ if (fromLoc.S_LOCK_STATE.Trim() != "鏃� || endLoc.S_LOCK_STATE.Trim() != "鏃�)
+ {
+ LogHelper.Info($"CreateTransport- CreateTask Error" + $"璧风偣 {fromLoc.S_LOCK_STATE}鎴栫粓鐐箋endLoc.S_LOCK_STATE}鐘舵�涓嶄负 鏃�");
+ return false;
+ }
}
+ if (!taskType.Contains("鎴愬搧婊℃-鍏ュ簱"))
+ if (endLoc.N_CURRENT_NUM >= endLayer || fromLoc.N_CURRENT_NUM < startLayer)
+ {
+ LogHelper.Info($"CreateTransport- CreateTask Error" + $"璧风偣鏁伴噺{fromLoc.N_CURRENT_NUM}<{startLayer}鎴栬�{endLoc.N_CURRENT_NUM}>={endLayer} ");
+ return false;
+ }
}
WMSTask wmsTask = new WMSTask()
{
@@ -121,6 +147,7 @@
S_SRC_NO = no,
N_PRIORITY = pri,
S_NOTE = note,
+ S_TWO_END_LOC = TwoEndLoc,
S_WORK_MODE = "agv",
S_B_STATE = "鏈墽琛�,
S_CNTRS = cntrInfo,
@@ -130,6 +157,8 @@
};
LogHelper.Info($"CreateTransport- CreateTask" + $"{JsonConvert.SerializeObject(wmsTask)}");
+ LogHelper.Info($"CreateTransport- CreateTask {wmsTask.S_TASK_NO} 璧风偣:{JsonConvert.SerializeObject(from)}");
+ LogHelper.Info($"CreateTransport- CreateTask {wmsTask.S_TASK_NO} 缁堢偣:{JsonConvert.SerializeObject(to)}");
return CreateTask(wmsTask, lockLoc);
}
internal static string GetDeptName(string taskType)
@@ -211,6 +240,42 @@
internal static void End(WMSTask task)
{
var db = new SqlHelper<WMSTask>().GetInstance();
+
+
+ //plg 2025骞�鏈�3鏃�10:42:24
+ if (task.S_END_LAREA == "YWLWJJB" && task.S_START_LAREA != "YWLRGDD" && !string.IsNullOrEmpty(task.S_TWO_END_LOC))
+ {
+ var model = db.Queryable<Location>().Where(a => a.S_LOC_CODE == task.S_TWO_END_LOC).First();
+ if (model != null)
+ {
+ //鍏堣В閿佺粓鐐�鍦ㄩ攣瀹�+ db.Ado.BeginTran();
+ try
+ {
+ model.S_LOCK_STATE = "鏃�;
+ var res = db.Updateable(model).UpdateColumns(it => new { it.S_LOCK_STATE }).ExecuteCommand() > 0;
+ LogHelper.Info(task.S_TWO_END_LOC + "LockLoc:閿佺粨鏋� + res);
+ db.Ado.CommitTran();
+ }
+ catch (Exception ex)
+ {
+ db.Ado.RollbackTran();
+ LogHelper.Info("CreateTask 澶辫触 " + ex.Message);
+ }
+
+ LogHelper.Info(task.S_TWO_END_LOC + "浜屾浠诲姟 寮�銆�");
+ var b = TaskProcess.CreateTransport(task.S_SRC_NO, task.S_END_LOC, task.S_TWO_END_LOC, "鍘熺墿鏂欐惉杩�绾哥", task.S_CNTRS.Split(',').ToList(), task.N_START_LAYER, 1, task.N_CNTR_COUNT, task.N_PRIORITY);
+ //if (b)
+ //{
+ // if (task != null)
+ // {
+ // task.S_B_STATE = "瀹屾垚";
+ // task.T_END_TIME = DateTime.Now;
+ // db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE, it.T_END_TIME }).ExecuteCommand();
+ // }
+ //}
+ }
+ }
if (task != null)
{
task.S_B_STATE = "瀹屾垚";
@@ -264,10 +329,10 @@
LogHelper.Info(wmsTask.S_START_LOC + "LockLoc:閿佺粨鏋� + res);
model = db.Queryable<Location>().Where(a => a.S_LOC_CODE == wmsTask.S_END_LOC).First();
-
model.S_LOCK_STATE = "鍏ュ簱閿�;
res = db.Updateable(model).UpdateColumns(it => new { it.S_LOCK_STATE }).ExecuteCommand() > 0;
LogHelper.Info(wmsTask.S_END_LOC + "LockLoc:閿佺粨鏋� + res);
+
}
db.Insertable(wmsTask).ExecuteCommand();
db.Ado.CommitTran();
@@ -292,7 +357,7 @@
{
var db = new SqlHelper<object>().GetInstance();
//LogHelper.Info(DateTime.Now.ToLongTimeString() + "=====" + ShuiGaiTask.ToString());
- return db.Queryable<WMSTask>().OrderBy(" N_PRIORITY DESC ").Where(a => a.S_B_STATE.Trim() == state).Take(10).ToList();
+ return db.Queryable<WMSTask>().OrderBy(" N_PRIORITY DESC ").Where(a => a.S_B_STATE.Trim() == state).ToList();
}
--
Gitblit v1.9.1