From 7c75f7a0fdd157c5cb13f286a9ef5f92a95ec1ce Mon Sep 17 00:00:00 2001 From: Administrator <Administrator@DESKTOP-5BIMHQ3> Date: 星期二, 05 三月 2024 10:10:28 +0800 Subject: [PATCH] 成品出库拆垛方式逻辑优化 --- Wms/WMS.BLL/SysServer/StorageLocatServer.cs | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/Wms/WMS.BLL/SysServer/StorageLocatServer.cs b/Wms/WMS.BLL/SysServer/StorageLocatServer.cs index f722153..c8826e5 100644 --- a/Wms/WMS.BLL/SysServer/StorageLocatServer.cs +++ b/Wms/WMS.BLL/SysServer/StorageLocatServer.cs @@ -635,7 +635,12 @@ { try { - string str = "select RoadwayNo,RoadwayName,WareHouseNo from SysStorageRoadway where IsDel = @isdel and WareHouseNo = @warehouseno"; + string str = "select RoadwayNo,RoadwayName,WareHouseNo from SysStorageRoadway where IsDel = @isdel"; + + if (!string.IsNullOrWhiteSpace(wareHouseNo)) + { + str += " and WareHouseNo = @warehouseno"; + } List<RoadwayDto> roadway = Db.Ado.SqlQuery<RoadwayDto>(str, new { -- Gitblit v1.8.0