From 5b6a0b390fc0ca7a5519ad6fb9a27bbca80e3cad Mon Sep 17 00:00:00 2001
From: 海波 张 <2956280567@qq.com>
Date: 星期四, 29 五月 2025 17:29:28 +0800
Subject: [PATCH] 空托修改
---
wms/TaskHelper.cs | 43 ++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 42 insertions(+), 1 deletions(-)
diff --git a/wms/TaskHelper.cs b/wms/TaskHelper.cs
index 5dddfea..bd314c6 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();
@@ -243,6 +250,8 @@
{
var tasks = new List<Task>();
+
+
// 浠诲姟1
var task1 = new WMSTask()
{
@@ -278,6 +287,10 @@
N_PRIORITY = operation.N_PRIORITY,
//宸ヨ绫诲瀷
TOOLSTYPE = operation.TOOLSTYPE,
+
+
+
+
};
try
@@ -546,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",
@@ -590,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",
@@ -863,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