From 35e3dae48db445e66c9614ee55dba062659e33d7 Mon Sep 17 00:00:00 2001
From: zhaowc <526854230@qq.com>
Date: 星期二, 16 十二月 2025 08:27:23 +0800
Subject: [PATCH] 程序修改
---
Wms/WMS.BLL/DataServer/StockDetailServer.cs | 17 ++++++++++++++++-
1 files changed, 16 insertions(+), 1 deletions(-)
diff --git a/Wms/WMS.BLL/DataServer/StockDetailServer.cs b/Wms/WMS.BLL/DataServer/StockDetailServer.cs
index f2f2563..09e77ee 100644
--- a/Wms/WMS.BLL/DataServer/StockDetailServer.cs
+++ b/Wms/WMS.BLL/DataServer/StockDetailServer.cs
@@ -38,7 +38,7 @@
/// <param name="bitBoxMark">闆剁鏍囪</param>
/// <param name="inspectStatus">璐ㄩ噺鐘舵��</param>
/// <returns></returns>
- public List<StockDetailDto> GetBindList(string wareHouseName, string areaName, string locatNo, string palletNo, string lotNo)
+ public List<StockDetailDto> GetBindList(string wareHouseName, string areaName, string locatNo, string palletNo, string lotNo,string palletStatus)
{
string str = $@"select
detail.*,
@@ -76,9 +76,24 @@
{
str += $" and detail.LotNo like '%{lotNo}%'";
}
+ if (!string.IsNullOrEmpty(palletStatus))
+ {
+ str += $" and detail.PalletStatus like '%{palletStatus}%'";
+ }
//鎺掑簭
str += " order by PalletNo";
List<StockDetailDto> boxInforList = Db.Ado.SqlQuery<StockDetailDto>(str).ToList();
+ foreach (var item in boxInforList)
+ {
+ if (item.LocatNo == "1004" || item.LocatNo == "1002")
+ {
+ item.PalletStatus = "0";
+ }
+ if (item.LocatNo == "1001" || item.LocatNo == "1003")
+ {
+ item.PalletStatus = "3";
+ }
+ }
return boxInforList;
}
--
Gitblit v1.8.0