| | |
| | | /// <param name="wareHouseNo">仓库</param> |
| | | /// <param name="row">排</param> |
| | | /// <returns></returns> |
| | | public List<SysStorageLocat> GetFlatLibraryLegend(string wareHouseNo, string row) |
| | | public List<LocatDto> GetFlatLibraryLegend(string row) |
| | | { |
| | | try |
| | | { |
| | | var area = Db.Queryable<SysStorageArea>().Where(m => m.IsDel == "0" && m.Status == "0" && m.WareHouseNo == wareHouseNo).ToList(); |
| | | var area = Db.Queryable<SysStorageArea>().Where(m => m.IsDel == "0" && m.Status == "0" ).ToList(); |
| | | |
| | | var areaStr = new List<string>(); |
| | | if (row == "3") |
| | |
| | | { |
| | | areaStr = area.Where(m => m.AreaName.Contains("4楼")).Select(m => m.AreaNo).ToList(); |
| | | } |
| | | |
| | | var list = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.WareHouseNo == wareHouseNo && areaStr.Contains(m.AreaNo)).ToList(); |
| | | |
| | | var list = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && areaStr.Contains(m.AreaNo)).Select(m => new LocatDto() |
| | | { |
| | | AreaNo2 =m.LocatNo.Substring(0,3), |
| | | LocatNo = m.LocatNo |
| | | |
| | | }, true).ToList(); |
| | | |
| | | return list; |
| | | } |