From 242bc8c88eb5476316c0d511b00286ca21d3341a Mon Sep 17 00:00:00 2001
From: yuyou_x <2336760928@qq.com>
Date: 星期四, 22 二月 2024 09:32:47 +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