| | |
| | | for (int i = 1; i <= 2; i++) |
| | | { |
| | | var iStr = i.ToString(); |
| | | locate = allotLocate.GetSuiTableLocate(houseNo, areaList, "", iStr); |
| | | try |
| | | { |
| | | locate = allotLocate.GetSuiTableLocate(houseNo, areaList, "", iStr); |
| | | } |
| | | catch (Exception e) |
| | | { } |
| | | if (locate != null) |
| | | { |
| | | break; |
| | |
| | | var roadStr = Db.Queryable<SysStorageRoadway>().Where(m => m.IsDel == "0" && m.Status == "0").Select(m=>m.RoadwayNo).ToList(); |
| | | //巷道组信息 |
| | | var roadList = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.WareHouseNo == houseNo && areaList.Contains(m.AreaNo) && !string.IsNullOrWhiteSpace(m.RoadwayNo) && roadStr.Contains(m.RoadwayNo)) |
| | | .GroupBy(m => m.RoadwayNo).OrderBy(m => m.RoadwayNo).Select(m => m.RoadwayNo).ToList(); |
| | | .GroupBy(m => m.RoadwayNo) |
| | | .Select(m => m.RoadwayNo) |
| | | .ToList() |
| | | .OrderBy(roadwayNo => |
| | | { |
| | | // 移除所有非数字字符,只保留数字 |
| | | var numbersOnly = new string(roadwayNo.Where(char.IsDigit).ToArray()); |
| | | return int.TryParse(numbersOnly, out int result) ? result : 0; |
| | | }).ToList(); |
| | | |
| | | #endregion |
| | | |