From 9202f45578fced1005ba7795552ce76a4de9c056 Mon Sep 17 00:00:00 2001
From: chengsc <Demo@DESKTOP-CPA90BF>
Date: 星期日, 22 九月 2024 09:06:47 +0800
Subject: [PATCH] 修改申请巷道问题

---
 Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs |   18 +++++++++++++++---
 1 files changed, 15 insertions(+), 3 deletions(-)

diff --git a/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs b/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs
index a17bec6..807f202 100644
--- a/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs
+++ b/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs
@@ -1333,8 +1333,10 @@
                             break;
                     }
                 }
-                var roadList = Db.Queryable<SysStorageLocat>().Where(m => m.WareHouseNo == houseNo && areaList.Contains(m.AreaNo))
-                    .GroupBy(m => m.RoadwayNo).OrderBy(m => m.RoadwayNo).Select(m => m.RoadwayNo).ToList();
+
+                var road = Db.Queryable<SysStorageRoadway>().Where(m => m.IsDel == "0" && m.Status == "0").Select(m => m.RoadwayNo).ToList();
+
+                var roadList = Db.Queryable<SysStorageLocat>().Where(m => m.WareHouseNo == houseNo && areaList.Contains(m.AreaNo) && road.Contains(m.RoadwayNo)).GroupBy(m => m.RoadwayNo).OrderBy(m => m.RoadwayNo).Select(m => m.RoadwayNo).ToList();
 
                 SysRoadwayUseLog useLog = Db.Queryable<SysRoadwayUseLog>().Where(m => m.IsDel == "0" && roadList.Contains(m.RoadwayNo)).OrderByDescending(l => l.Id).First(); //宸烽亾鏈�鍚庝竴娆′娇鐢ㄨ褰�
                 #endregion
@@ -1368,12 +1370,18 @@
                     }
                     roadList2.AddRange(roadLarge);
                     roadList2.AddRange(roadSmall);
+
                 }
                 else
                 {
                     roadList2 = roadList;
                 }
                 roadList = roadList2;
+
+                if (roadList.Count == 0)
+                {
+                    throw new Exception("鏈煡璇㈠埌鍙兘浣跨敤鐨勫贩閬�");
+                }
                 #endregion
 
 
@@ -1679,9 +1687,13 @@
                 }
 
                 roadList = roadList2;
+                if (roadList.Count == 0)
+                {
+                    throw new Exception("鏈煡璇㈠埌鍙兘浣跨敤鐨勫贩閬�");
+                }
                 #endregion
 
-                
+
                 var roadNo = "";
                 if (laneAllot == 0)//璺冲贩閬撳钩鍧囧垎閰�
                 {

--
Gitblit v1.8.0