From af42a9904d1d3939da7fa0a00c3a7a2ced78258e Mon Sep 17 00:00:00 2001
From: lss <Lss@HanInfo>
Date: 星期三, 21 五月 2025 17:26:18 +0800
Subject: [PATCH] 佳通问题优化
---
HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs | 12 +++++++++---
1 files changed, 9 insertions(+), 3 deletions(-)
diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs
index c6c002d..e543e7e 100644
--- a/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs
+++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/WCSHelper.cs
@@ -1,6 +1,7 @@
锘縰sing HH.WCS.JiaTong.util;
using System;
using System.Collections.Generic;
+using System.IdentityModel.Protocols.WSTrust;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
@@ -56,11 +57,16 @@
var task = db.Queryable<WCSTask>().Where(a => a.S_CODE.Trim() == no).First();
return task;
}
-
+ /// <summary>
+ /// 鏍规嵁璧风偣璐т綅鏈畬鎴愮殑浠诲姟
+ /// </summary>
+ /// <param name="loc"></param>
+ /// <returns></returns>
internal static WCSTask GetTaskByStartloc(string loc)
{
var db = new SqlHelper<WCSTask>().GetInstance();
- var task = db.Queryable<WCSTask>().Where(a => a.S_START_LOC.Trim() == loc && a.S_B_STATE.Trim() != "瀹屾垚").First();
+ string[] statue = new string[] { "瀹屾垚", "鍙栨秷", "閿欒" };
+ var task = db.Queryable<WCSTask>().Where(a => a.S_START_LOC.Trim() == loc && !statue.Contains(a.S_B_STATE.Trim())).First();
return task;
}
/// <summary>
@@ -71,7 +77,7 @@
internal static List<WCSTask> GetTaskBycntrcode(string no)
{
var db = new SqlHelper<WCSTask>().GetInstance();
- var task = db.Queryable<WCSTask>().Where(a => a.S_CNTR_CODE.Trim() == no && a.S_B_STATE.Trim() == "瀹屾垚" ).ToList();
+ var task = db.Queryable<WCSTask>().Where(a => a.S_CNTR_CODE.Trim() == no && a.S_B_STATE.Trim() == "瀹屾垚").ToList();
return task;
}
internal static WCSTask GetTaskBySrcNo(string no)
--
Gitblit v1.9.1