bklLiudl
2024-03-14 a7cd7313b07c7bf4c6ed5ad79d15fdf3223d2eee
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
                {
@@ -696,7 +701,8 @@
                else if (storageLocat.Status == "2")
                {
                    //托盘绑定信息
                    List<BllPalletBind> palletBindList = Db.Queryable<BllPalletBind>().Where(w => w.LocatNo == locatNo && w.IsDel == "0").ToList();
                    List<BllPalletBind> palletBindList = Db.Queryable<BllPalletBind>()
                        .Where(w => w.LocatNo == locatNo && w.IsDel == "0" && w.Status == "1").ToList();
                    if (palletBindList == null || palletBindList.Count <= 0)
                    {
                        throw new Exception("未找到对应的托盘绑定信息");