| | |
| | | var data = LocatRst.GetAllByOrderPageAsync(item, limit, page,out int counts) |
| | | .Includes(x => x.WareHouseInfo) |
| | | .Includes(x => x.AreaInfo) |
| | | .Includes(x => x.RoadwayInfo) |
| | | .Includes(x => x.TemperatureInfo) |
| | | .Includes(x => x.CreateUserInfo) |
| | | .Includes(x => x.UpdateUserInfo).ToList(); |
| | |
| | | { |
| | | Id = m.Id, |
| | | LocatNo = m.LocatNo, |
| | | WareHouseNo = m.WareHouseNo, |
| | | WareHouseName = m.WareHouseInfo == null ? "" : m.WareHouseInfo.WareHouseName, |
| | | RoadwayNo = m.RoadwayNo, |
| | | RoadwayName = m.RoadwayInfo == null ? "" : m.RoadwayInfo.RoadwayName, |
| | | AreaNo = m.AreaNo, |
| | | AreaName = m.AreaInfo == null ? "" : m.AreaInfo.AreaName, |
| | | Status = m.Status, |
| | | StatusName = GetStatus(m.Status), |
| | |
| | | { |
| | | try |
| | | { |
| | | string str = "select RoadwayNo,RoadwayName from SysStorageRoadway where IsDel = @isdel and WareHouseNo = @warehouseno"; |
| | | string str = "select RoadwayNo,RoadwayName,WareHouseNo from SysStorageRoadway where IsDel = @isdel and WareHouseNo = @warehouseno"; |
| | | |
| | | List<RoadwayDto> roadway = Db.Ado.SqlQuery<RoadwayDto>(str, new |
| | | { |