From 4cb9b15a80cb7ce9979c659e394f1eeffbfa18ae Mon Sep 17 00:00:00 2001
From: admin <qiutairan163@163.com>
Date: 星期六, 29 十一月 2025 10:38:17 +0800
Subject: [PATCH] 获取托盘明细GetBindList增加储位地址筛选
---
Wms/WMS.BLL/DataServer/StockDetailServer.cs | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/Wms/WMS.BLL/DataServer/StockDetailServer.cs b/Wms/WMS.BLL/DataServer/StockDetailServer.cs
index edaa9b0..e3eae2b 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 skuNo, string skuName, string palletNo, string lotNo, string boxNo, string status, string inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus, string ownerNo, string ownerName, string startTime, string endTime, string WareHouseNo, string AreaNo)
+ public List<StockDetailDto> GetBindList(string skuNo, string skuName, string palletNo, string lotNo, string boxNo, string status, string inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus, string ownerNo, string ownerName, string startTime, string endTime, string WareHouseNo, string AreaNo,string locatNo)
{
string str = $@"select detail.*,house.WareHouseNo+'-'+house.WareHouseName as WareHouseName,roadway.RoadwayNo+'-'+roadway.RoadwayName as RoadwayName,area.AreaNo+'-'+area.AreaName as AreaName
from DataStockDetail detail
@@ -103,6 +103,10 @@
{
str += $" and detail.AreaNo='{AreaNo}'";
}
+ if (!string.IsNullOrEmpty(locatNo))
+ {
+ str += $" and detail.LocatNo='{locatNo}'";
+ }
int i = 0;
//鍦ㄧ鐮佹槑缁嗕腑鑾峰彇鐩稿簲鏁版嵁
--
Gitblit v1.8.0