| | |
| | | using HslCommunication.WebSocket; |
| | | using OfficeOpenXml.FormulaParsing.Excel.Functions.Math; |
| | | using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup; |
| | | using OfficeOpenXml.FormulaParsing.Excel.Functions.Text; |
| | | using SqlSugar; |
| | |
| | | using WIDESEA_Common.CommonEnum; |
| | | using WIDESEA_Common.LocationEnum; |
| | | using WIDESEA_Common.StockEnum; |
| | | using WIDESEA_Common.WareHouseEnum; |
| | | using WIDESEA_Core; |
| | | using WIDESEA_Core.BaseRepository; |
| | | using WIDESEA_Core.BaseServices; |
| | |
| | | public string AccessingTunnel(int WarehouseId, int LocationType) |
| | | { |
| | | List<Dt_LocationInfo> locationData = BaseDal.QueryData(x => x.WarehouseId == WarehouseId); |
| | | var roadwayGroups = locationData |
| | | .Where(x => x.LocationType == LocationType) |
| | | .GroupBy(x => x.RoadwayNo) |
| | | var roadwayGroups = locationData.Where(x => x.LocationType == LocationType).GroupBy(x => x.RoadwayNo) |
| | | .Select(g => new |
| | | { |
| | | RoadwayNo = g.Key, |
| | | LocationCount = g.Count(), |
| | | AllLocations = g.ToList() |
| | | }) |
| | | .OrderByDescending(g => g.LocationCount) // æ¹ä¸ºéåºæåº |
| | | .FirstOrDefault(); // å第ä¸ä¸ªï¼æ°éæå¤çï¼ |
| | | }).OrderByDescending(g => g.LocationCount).ToList(); |
| | | |
| | | return roadwayGroups.RoadwayNo; |
| | | int minRequired = 15; |
| | | if(WarehouseId== (int)WarehouseEnum.YMYL) |
| | | { |
| | | if (LocationType == 2) minRequired = 6; |
| | | |
| | | var selectedRoadway = roadwayGroups.FirstOrDefault(g => g.LocationCount >= minRequired); |
| | | return selectedRoadway.RoadwayNo; |
| | | } |
| | | else |
| | | { |
| | | var selectedRoadway = roadwayGroups.FirstOrDefault(g => g.LocationCount >= minRequired); |
| | | if(selectedRoadway != null) |
| | | { |
| | | return selectedRoadway.RoadwayNo; |
| | | |
| | | } |
| | | else |
| | | { |
| | | selectedRoadway = roadwayGroups.FirstOrDefault(g => g.RoadwayNo =="5" && g.LocationCount != 0); |
| | | } |
| | | return selectedRoadway.RoadwayNo; |
| | | } |
| | | } |
| | | |
| | | |