| | |
| | | /// <param name="areaNo"></param> |
| | | /// <returns></returns> |
| | | /// <exception cref="Exception"></exception> |
| | | public List<string> GetLocatByArea(string areaNo) |
| | | public List<SysStorageLocatDto> GetLocatByArea(string areaNo) |
| | | { |
| | | try |
| | | { |
| | |
| | | { |
| | | throw new Exception("请选择区域"); |
| | | } |
| | | var _list = Db.Queryable<SysStorageLocat>().Where(w => w.IsDel == "0" && w.AreaNo == areaNo && w.WareHouseNo == "W04").Select(s => s.LocatNo).ToList(); |
| | | var _list = Db.Queryable<SysStorageLocat>().Where(w => w.IsDel == "0" && w.AreaNo == areaNo && w.WareHouseNo == "W04").Select(s => new SysStorageLocatDto() |
| | | { |
| | | LocatNo = s.LocatNo, |
| | | Remark = s.Remark |
| | | }).ToList(); |
| | | |
| | | return _list; |
| | | } |