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 | 25 +++++++++++++++++++++++++
1 files changed, 25 insertions(+), 0 deletions(-)
diff --git a/wms/TaskHelper.cs b/wms/TaskHelper.cs
index 91c3bb2..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();
@@ -877,8 +884,26 @@
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