From 5cd857c91bd49e276274f6df6b9a126febfbf978 Mon Sep 17 00:00:00 2001
From: bklLiudl <673013083@qq.com>
Date: 星期五, 27 六月 2025 17:04:17 +0800
Subject: [PATCH] 托盘明细增加所属仓库、区域查询条件
---
Wms/WMS.BLL/DataServer/StockDetailServer.cs | 15 ++++++++++++++-
1 files changed, 14 insertions(+), 1 deletions(-)
diff --git a/Wms/WMS.BLL/DataServer/StockDetailServer.cs b/Wms/WMS.BLL/DataServer/StockDetailServer.cs
index e8699c6..3d94e2f 100644
--- a/Wms/WMS.BLL/DataServer/StockDetailServer.cs
+++ b/Wms/WMS.BLL/DataServer/StockDetailServer.cs
@@ -38,7 +38,8 @@
/// <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 inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus, string ownerNo, string ownerName,
+ string startTime, string endTime, string WareHouseNo, string AreaNo)
{
string str = "select detail.*,house.WareHouseNo + '-' + house.WareHouseName as WareHouseName,roadway.RoadwayNo + '-' + roadway.RoadwayName as RoadwayName," +
"area.AreaNo + '-' + area.AreaName as AreaName " +
@@ -91,6 +92,18 @@
endTime = Convert.ToDateTime(endTime).AddDays(1).ToString();
str += $" and detail.CompleteTime < '{endTime}'";
}
+ if (!string.IsNullOrEmpty(WareHouseNo))
+ {
+ str += $" and detail.WareHouseNo = '{WareHouseNo}'";
+ }
+ if (!string.IsNullOrEmpty(WareHouseNo))
+ {
+ str += $" and detail.WareHouseNo = '{WareHouseNo}'";
+ }
+ if (!string.IsNullOrEmpty(AreaNo))
+ {
+ str += $" and detail.AreaNo = '{AreaNo}'";
+ }
int i = 0;
//鍦ㄧ鐮佹槑缁嗕腑鑾峰彇鐩稿簲鏁版嵁
--
Gitblit v1.8.0