From 265fbfa342cc03991c79934b162f26c0a6699f95 Mon Sep 17 00:00:00 2001
From: 海波 张 <2956280567@qq.com>
Date: 星期五, 25 七月 2025 17:31:20 +0800
Subject: [PATCH] 0725
---
wms/TaskHelper.cs | 52 +++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 51 insertions(+), 1 deletions(-)
diff --git a/wms/TaskHelper.cs b/wms/TaskHelper.cs
index 12578b6..a4dd619 100644
--- a/wms/TaskHelper.cs
+++ b/wms/TaskHelper.cs
@@ -1,4 +1,5 @@
锘縰sing HH.WCS.ZhongCeJinTan.api;
+using HH.WCS.ZhongCeJinTan.core;
using HH.WCS.ZhongCeJinTan.device;
using HH.WCS.ZhongCeJinTan.dispatch;
using HH.WCS.ZhongCeJinTan.util;
@@ -12,6 +13,7 @@
using System.Threading.Tasks;
using System.Web.Services.Description;
using System.Xml.Linq;
+using Top.Api;
using static HH.WCS.ZhongCeJinTan.util.Settings;
using static HH.WCS.ZhongCeJinTan.wms.WcsModel;
@@ -52,6 +54,21 @@
var task = db.Queryable<WMSTask>().Where(a => a.S_CODE.Trim() == no).First();
return task;
}
+ internal static WMSTask GetTaskByNoType(string no, string type)
+ {
+ var db = new SqlHelper<WMSTask>().GetInstance();
+ var task = db.Queryable<WMSTask>().Where(a => a.S_CODE == no && a.S_SCHEDULE_TYPE == type).First();
+ return task;
+ }
+
+ internal static List<WMSTask> GetTaskByNoTypeList(string no, string type)
+ {
+ var db = new SqlHelper<WMSTask>().GetInstance();
+ var task = db.Queryable<WMSTask>().Where(a => a.S_CODE == no && a.S_SCHEDULE_TYPE == type).ToList();
+ return task;
+ }
+
+
//鏌ユ壘WCS绔嬪簱浠诲姟 鍙傛暟浣滀笟缂栫爜,璋冨害绫诲瀷 agv/wcs
internal static WMSTask GetTaskByWorkNo(string no,string type)
@@ -64,7 +81,7 @@
internal static WmsWork GetWmsWork(string no) {
var db = new SqlHelper<WmsWork>().GetInstance();
- return db.Queryable<WmsWork>().Where(it => it.S_CODE == no).First();
+ return db.Queryable<WmsWork>().Where(it => it.S_CODE == no).OrderByDescending(b=>b.T_CREATE).First();
}
@@ -239,6 +256,10 @@
break;
case 12:
CreateOneTask(operation);
+ break;
+ case 99:
+ //澶栧舰妫�祴鍑哄簱涓ゆ浠诲姟
+ CreateOutTowTask(operation);
break;
case 20:
CreateOneTask(operation);
@@ -682,6 +703,17 @@
return ac;
}
+ internal static WcsSafety GetWcsSafety(string taskNo, string action)
+ {
+ var db = new SqlHelper<WcsSafety>().GetInstance();
+
+ var ac = db.Queryable<WcsSafety>().Where(a => a.TaskNo == taskNo && a.Sign.ToString() == action).First();
+
+ return ac;
+ }
+
+
+
/// <summary>
/// 浠诲姟鎷︽埅
@@ -874,6 +906,14 @@
internal static bool CreateTask(WMSTask wmsTask) {
var db = new SqlHelper<WMSTask>().GetInstance();
+
+ var task = db.Queryable<WMSTask>().Where(a => a.S_CODE == wmsTask.S_CODE).First();
+
+ if (task!=null)
+ {
+ return false;
+ }
+
return db.Insertable(wmsTask).ExecuteCommand() > 0;
}
@@ -923,6 +963,8 @@
return db.Queryable<WorkFlow>().Where(a => a.FLOWCODE == flowCode && a.TOOLSTYPE == type).First();
}
+
+
//鏍规嵁娴佺▼缂栧彿鍜岃捣鐐瑰簱鍖烘煡鎵句綔涓氭祦绋� public static WorkFlow selectWorkFlowByStratArea(string flowCode, string startArea)
{
@@ -930,6 +972,14 @@
return db.Queryable<WorkFlow>().Where(a => a.FLOWCODE == flowCode && a.STARTAREA==startArea).First();
}
+ //鏍规嵁娴佺▼缂栧彿鍜岀粓鐐瑰簱鍖烘煡鎵句綔涓氭祦绋�+ public static WorkFlow selectWorkFlowByEndArea(string flowCode, string endArea)
+ {
+ var db = new SqlHelper<WorkFlow>().GetInstance();
+ return db.Queryable<WorkFlow>().Where(a => a.FLOWCODE == flowCode && a.ENDAREA == endArea).First();
+ }
+
+
/// <summary>
/// 鏍规嵁浠诲姟鐘舵�鑾峰彇agv浠诲姟
/// </summary>
--
Gitblit v1.9.1