From e4b92180e4336d777ac323c0395a043bde1285d3 Mon Sep 17 00:00:00 2001
From: 杨前锦 <1010338399@qq.com>
Date: 星期五, 30 五月 2025 17:18:13 +0800
Subject: [PATCH] 印尼佳通-胚胎到硫化的出入库功能开发
---
HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_BZP/wms/WCSHelper.cs | 26 ++++++++++++++++++++++----
1 files changed, 22 insertions(+), 4 deletions(-)
diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_BZP/wms/WCSHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_BZP/wms/WCSHelper.cs
index 4228571..9d7c258 100644
--- a/HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_BZP/wms/WCSHelper.cs
+++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.YNJT_BZP/wms/WCSHelper.cs
@@ -58,6 +58,12 @@
var task = db.Queryable<WCSTask>().Where(a => a.S_OP_CODE== no).First();
return task;
}
+ internal static WCSTask GetTaskBySrcNoAndScheduleType(string no ,string scheduleType)
+ {
+ var db = new SqlHelper<WCSTask>().GetInstance();
+ var task = db.Queryable<WCSTask>().Where(a => a.S_OP_CODE == no && a.S_SCHEDULE_TYPE == scheduleType).First();
+ return task;
+ }
internal static List<WCSTask> GetTaskListBySrcNo(string no)
{
var db = new SqlHelper<WCSTask>().GetInstance();
@@ -89,14 +95,14 @@
return task;
}
- internal static List<WCSTask> GetTaskByStart(string bit) {
+ internal static WCSTask GetTaskByStart(string bit) {
var db = new SqlHelper<WCSTask>().GetInstance();
- var task = db.Queryable<WCSTask>().Where(a => a.S_START_LOC == bit.Trim()).ToList();
+ var task = db.Queryable<WCSTask>().Where(a => a.S_START_LOC == bit.Trim() && a.N_B_STATE < 3).First();
return task;
}
- internal static List<WCSTask> GetTaskByEnd(string bit) {
+ internal static WCSTask GetTaskByEnd(string bit) {
var db = new SqlHelper<WCSTask>().GetInstance();
- var task = db.Queryable<WCSTask>().Where(a => a.S_END_LOC.Trim() == bit.Trim()).ToList();
+ var task = db.Queryable<WCSTask>().Where(a => a.S_END_LOC.Trim() == bit.Trim() && a.N_B_STATE < 3).First();
return task;
}
@@ -153,6 +159,18 @@
var db = new SqlHelper<TaskAction>().GetInstance();
return db.Queryable<TaskAction>().Count(a => a.S_TASK_CODE == no.Trim() && a.N_ACTION_CODE == code) > 0;
}
+ internal static TaskAction getActionRecord(string no, int code)
+ {
+ var db = new SqlHelper<TaskAction>().GetInstance();
+ return db.Queryable<TaskAction>().Where(a => a.S_TASK_CODE == no.Trim() && a.N_ACTION_CODE == code).First();
+ }
+
+ internal static bool updateActionRecord(TaskAction taskAction)
+ {
+ var db = new SqlHelper<TaskAction>().GetInstance();
+ return db.Updateable(taskAction).ExecuteCommand() > 0;
+ }
+
internal static void Begin(WCSTask task) {
var db = new SqlHelper<WCSTask>().GetInstance();
if (task != null) {
--
Gitblit v1.9.1