From 62c5a7fad29fa380874f6cf81bb4074ce5f488e7 Mon Sep 17 00:00:00 2001
From: 海波 张 <2956280567@qq.com>
Date: 星期五, 30 五月 2025 17:32:06 +0800
Subject: [PATCH] 优先级修改
---
wms/TaskHelper.cs | 55 +++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 45 insertions(+), 10 deletions(-)
diff --git a/wms/TaskHelper.cs b/wms/TaskHelper.cs
index 57a8127..bf4aba1 100644
--- a/wms/TaskHelper.cs
+++ b/wms/TaskHelper.cs
@@ -58,6 +58,13 @@
}
+ internal static WmsWork GetWmsWork(string no) {
+ var db = new SqlHelper<WmsWork>().GetInstance();
+ return db.Queryable<WmsWork>().Where(it => it.S_CODE == no).First();
+ }
+
+
+
internal static WMSTask GetTaskByCntrCode(string cntrCode)
{
var db = new SqlHelper<WMSTask>().GetInstance();
@@ -552,6 +559,7 @@
var db = new SqlHelper<WmsTaskAction>().GetInstance();
var action = new WmsTaskAction() {
S_ACTION = state.ToString(),
+ N_ACTION_CODE = state,
S_TASK_CODE = no,
S_EQ_CODE = forkliftNo,
S_EQ_TYPE = "agv",
@@ -596,6 +604,7 @@
var action = new WmsTaskAction()
{
S_ACTION = state.ToString(),
+ N_ACTION_CODE = int.Parse(state),
S_TASK_CODE = no,
S_EQ_CODE = forkliftNo,
S_EQ_TYPE = "wcs",
@@ -714,15 +723,15 @@
LocationHelper.LockLoc(task.S_END_LOC, "鍑哄簱閿�, 2);
}
- if (task.S_TYPE.Contains("鍑哄簱")&&task.S_SCHEDULE_TYPE.Contains("agv") )
- {
- var location = db.Queryable<Location>().Where(a => a.S_CODE == task.S_END_LOC).First();
- location.N_CURRENT_NUM = 0;
- db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM}).ExecuteCommand();
- db.Deleteable<Container>().Where(it => it.S_CODE == task.S_CNTR_CODE).ExecuteCommand();
- db.Deleteable<LocCntrRel>().Where(it => it.S_CNTR_CODE == task.S_CNTR_CODE).ExecuteCommand();
- db.Deleteable<CntrItemRel>().Where(it => it.S_CNTR_CODE == task.S_CNTR_CODE).ExecuteCommand();
- }
+ //if (task.S_TYPE.Contains("鍑哄簱")&&task.S_SCHEDULE_TYPE.Contains("agv") )
+ //{
+ // var location = db.Queryable<Location>().Where(a => a.S_CODE == task.S_END_LOC).First();
+ // location.N_CURRENT_NUM = 0;
+ // db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM}).ExecuteCommand();
+ // db.Deleteable<Container>().Where(it => it.S_CODE == task.S_CNTR_CODE).ExecuteCommand();
+ // db.Deleteable<LocCntrRel>().Where(it => it.S_CNTR_CODE == task.S_CNTR_CODE).ExecuteCommand();
+ // db.Deleteable<CntrItemRel>().Where(it => it.S_CNTR_CODE == task.S_CNTR_CODE).ExecuteCommand();
+ //}
}
@@ -869,6 +878,32 @@
}
}
-
+ internal static MesKtTask GetMesKtTask(string end)
+ {
+
+ var db = new SqlHelper<object>().GetInstance();
+
+ return db.Queryable<MesKtTask>().Where(a => a.Location_To==end && a.Status=="N").First();
+ }
+
+ internal static bool ChangeMesKtTask(MesKtTask kt)
+ {
+
+ var db = new SqlHelper<object>().GetInstance();
+ kt.Status = "Y";
+ return db.Updateable(kt).UpdateColumns(it => new {
+ it.Status
+ }).ExecuteCommand()>0;
+
+
+ }
+
+ internal static List<UnlimitedLoc> GetMesKtLoc()
+ {
+
+ var db = new SqlHelper<object>().GetInstance();
+
+ return db.Queryable<UnlimitedLoc>().ToList();
+ }
}
}
--
Gitblit v1.9.1