'手动上传'

Admin

2026-01-21 00e64cba66377cb75c9c947908627fe9f631746e

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

@@ -1,4 +1,5 @@
using HslCommunication.WebSocket;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Math;
using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
using SqlSugar;
@@ -10,6 +11,7 @@
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;
@@ -156,24 +158,39 @@
                return WebResponseContent.Instance.Error(ex.Message);
            }
        }
    
        


        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)
                .Select(g => new
                {
                    RoadwayNo = g.Key,
                    LocationCount = g.Count(),
                    AllLocations = g.ToList()
                })
                .OrderByDescending(g => g.LocationCount)  // æ”¹ä¸ºé™åºæŽ’序
                .FirstOrDefault();  // å–第一个（数量最多的）
            var roadwayGroups = locationData.Where(x => x.LocationType == LocationType && x.EnableStatus== (int)EnableStatusEnum.Normal).GroupBy(x => x.RoadwayNo)
            .Select(g => new
            {
                RoadwayNo = g.Key,
                LocationCount = g.Count(),
            }).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);
                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);

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

            return "0";
        }


@@ -209,7 +226,8 @@
                    if (emptyLocations[i].Depth == 1)//判断是否1深货位
                    {
                        //查询深库位
                        int emprow = emptyLocations[i].Row == 2 ? 1 : 4;
                        //int emprow = emptyLocations[i].Row == 2 ? 1 : 4;
                        int emprow = judgmentRow(emptyLocations[i].RoadwayNo,emptyLocations[i].Row);

                        Dt_LocationInfo? sencondDepthLocationShen = emptyLocations.FirstOrDefault(x => x.Row == emprow && x.Layer == emptyLocations[i].Layer && x.Column == emptyLocations[i].Column);
                        if (sencondDepthLocationShen != null && sencondDepthLocationShen.LocationStatus == LocationStatusEnum.Free.ObjToInt())
@@ -224,13 +242,18 @@
                            {
                                locationCaches.Add(new LocationCache { DateTime = DateTime.Now, LocationCode = emptyLocations[i].LocationCode });
                                return emptyLocations[i];
                            }else if (emptyLocations[i].RoadwayNo=="5" && emptyLocations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
                            {
                                locationCaches.Add(new LocationCache { DateTime = DateTime.Now, LocationCode = emptyLocations[i].LocationCode });
                                return emptyLocations[i];
                            }
                        }
                    }
                    else
                    {
                        //查询2深货位对应的1深货位是否为空
                        int emprow = emptyLocations[i].Row == 4 ? 3 : 2;
                        //int emprow = emptyLocations[i].Row == 4 ? 3 : 2;
                        int emprow = judgmentRow(emptyLocations[i].RoadwayNo, emptyLocations[i].Row);

                        Dt_LocationInfo? sencondDepthLocationQian = emptyLocations.FirstOrDefault(x => x.Row == emprow && x.Layer == emptyLocations[i].Layer && x.Column == emptyLocations[i].Column);
                        if (sencondDepthLocationQian != null && sencondDepthLocationQian.LocationStatus == LocationStatusEnum.Free.ObjToInt())
@@ -244,6 +267,38 @@
            }
        }

        private int judgmentRow(string RoadwayNo, int locrow)
        {
            if (RoadwayNo == "1" || RoadwayNo == "3")
            {
                if(locrow==1 || locrow == 4)
                {
                    return locrow == 1 ? 2 : 3;
                }
                else
                {
                    return locrow == 2 ? 1 : 4;
                }
               
            }
            else if (RoadwayNo == "2" || RoadwayNo == "4")
            {
                if (locrow == 5 || locrow == 8)
                {
                    return locrow == 5 ? 6 : 7;
                }
                else
                {
                    return locrow == 6 ? 5 : 8;
                }
                    
            }
            else
            {
                return 0;
            }
        }

        public class LocationCache
        {
            public string LocationCode { get; set; }