| | |
| | | { |
| | | 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 |
| | | { |
| | |
| | | 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("未找到对应的托盘绑定信息"); |