perf: 优化任务均衡巷道和1206虚拟站台

xiazhengtongxue

2026-03-27 49e6ac0d3b52f19ead1a055bba9aaa99929686b7

 ÏîÄ¿´úÂë/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/LocationInfoService.cs

@@ -22,6 +22,7 @@
using WIDESEA_Core.Seed;
using WIDESEA_Core.Utilities;
using WIDESEA_DTO.Basic;
using WIDESEA_DTO.Task;
using WIDESEA_IBasicService;
using WIDESEA_Model.Models;

@@ -160,40 +161,69 @@
        }


        public string AccessingTunnel(int WarehouseId, int LocationType, int taskCount)
        public string AccessingTunnel(int WarehouseId, int LocationType, List<RoadwayTaskCount> roadwayTaskCounts)
        {
            List<Dt_LocationInfo> locationData = BaseDal.QueryData(x => x.WarehouseId == WarehouseId);
            var roadwayGroups = locationData.Where(x => x.LocationType == LocationType && x.LocationStatus== (int)LocationStatusEnum.Free && x.EnableStatus== (int)EnableStatusEnum.Normal).GroupBy(x => x.RoadwayNo)
            .Select(g => new
            {
                RoadwayNo = g.Key,
                LocationCount = g.Count() - taskCount,
            }).OrderByDescending(g => g.LocationCount).ToList();

            // å°† roadwayTaskCounts è½¬æ¢ä¸ºå­—典，便于快速查找
            var taskCountDict = roadwayTaskCounts?.ToDictionary(x => x.Roadway, x => x.TaskCount) ?? new Dictionary<string, int>();

            var roadwayGroups = locationData.Where(x => x.LocationType == LocationType && x.LocationStatus == (int)LocationStatusEnum.Free && x.EnableStatus == (int)EnableStatusEnum.Normal)
                .GroupBy(x => x.RoadwayNo)
                .Select(g => new
                {
                    RoadwayNo = g.Key,
                    FreeCount = g.Count(),
                    TaskCount = taskCountDict.ContainsKey(g.Key) ? taskCountDict[g.Key] : 0,
                    AvailableCount = g.Count() - (taskCountDict.ContainsKey(g.Key) ? taskCountDict[g.Key] : 0)
                })
                .Where(g => g.AvailableCount > 0)
                .ToList();

            int minRequired = 3;
            if(WarehouseId== (int)WarehouseEnum.YMYL)

            if (WarehouseId == (int)WarehouseEnum.YMYL)
            {
                if (LocationType == 2) minRequired = 2;

                var selectedRoadway = roadwayGroups.FirstOrDefault(g => g.LocationCount >= minRequired);
                if(selectedRoadway!=null) return selectedRoadway.RoadwayNo;
                // è¿™é‡Œé€‰æ‹©å··é“1或者2，先找任务最少的，如果一样，选择库存在多的
                var targetRoadways = roadwayGroups
                    .Where(g => (g.RoadwayNo == "1" || g.RoadwayNo == "2") && g.AvailableCount >= minRequired)
                    .OrderBy(g => g.TaskCount)           // å…ˆæŒ‰ä»»åŠ¡æ•°å‡åºï¼ˆä»»åŠ¡å°‘的优先）
                    .ThenByDescending(g => g.FreeCount)  // ä»»åŠ¡ç›¸åŒæ—¶æŒ‰ç©ºé—²æ•°é™åºï¼ˆåº“存多的优先）
                    .ToList();

                var selectedRoadway = targetRoadways.FirstOrDefault();
                if (selectedRoadway != null)
                    return selectedRoadway.RoadwayNo;
            }
            else
            {
                var selectedRoadway = roadwayGroups.FirstOrDefault(g => g.LocationCount >= minRequired);
                if(selectedRoadway == null)
                {
                    selectedRoadway = roadwayGroups.FirstOrDefault(g => g.RoadwayNo == "5" && g.LocationCount != 0);
                // è¿™é‡Œé€‰æ‹©å··é“3或者4或者5，先找任务最少的，如果一样，选择库存在多的
                var targetRoadways = roadwayGroups
                    .Where(g => (g.RoadwayNo == "3" || g.RoadwayNo == "4" || g.RoadwayNo == "5") && g.AvailableCount >= minRequired)
                    .OrderBy(g => g.TaskCount)           // å…ˆæŒ‰ä»»åŠ¡æ•°å‡åºï¼ˆä»»åŠ¡å°‘的优先）
                    .ThenByDescending(g => g.FreeCount)  // ä»»åŠ¡ç›¸åŒæ—¶æŒ‰ç©ºé—²æ•°é™åºï¼ˆåº“存多的优先）
                    .ToList();

                var selectedRoadway = targetRoadways.FirstOrDefault();
                if (selectedRoadway == null)
                {
                    // å¦‚果没有满足最低要求的，尝试选择巷道5（只要有可用库位就行）
                    selectedRoadway = roadwayGroups
                        .Where(g => g.RoadwayNo == "5" && g.AvailableCount > 0)
                        .FirstOrDefault();
                }
                if(selectedRoadway != null) return selectedRoadway.RoadwayNo;

                if (selectedRoadway != null)
                    return selectedRoadway.RoadwayNo;
            }

            return "0";
        }



        public Dt_LocationInfo? ShallowGetLocation(string roadway, int Locationtype,int row ,int Layer, int Column)
        {
            return BaseDal.QueryData(x => x.RoadwayNo == roadway && x.LocationType == Locationtype && x.Row==row && x.Layer== Layer && x.Column== Column).FirstOrDefault();