出库

Admin

2026-01-26 2046dbcbb6e69a2460c2c37ca9e25b7ffe1d1d29

 ÏîÄ¿´úÂë/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;
@@ -30,6 +32,9 @@
        private readonly IUnitOfWorkManage _unitOfWorkManage;
        private readonly IRepository<Dt_StockInfo> _stockInfoRepository;
        public IRepository<Dt_LocationInfo> Repository => BaseDal;
        private readonly static object _locker = new object();

        public static List<LocationCache> locationCaches = new List<LocationCache>();

        public LocationInfoService(IRepository<Dt_LocationInfo> BaseDal, IUnitOfWorkManage unitOfWorkManage, IRepository<Dt_StockInfo> stockInfoRepository) : base(BaseDal)
        {
@@ -153,5 +158,299 @@
                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 && x.LocationStatus== (int)LocationStatusEnum.Free && x.EnableStatus== (int)EnableStatusEnum.Normal).GroupBy(x => x.RoadwayNo)
            .Select(g => new
            {
                RoadwayNo = g.Key,
                LocationCount = g.Count(),
            }).OrderByDescending(g => g.LocationCount).ToList();

            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";
        }


        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();
        }

        public Dt_LocationInfo? FindStorageLocation(string LocationCode)
        {
            return BaseDal.QueryData(x => x.LocationCode == LocationCode).FirstOrDefault();
        }


        //查找新货位
        public Dt_LocationInfo? GetLocation(string roadway, int Locationtype)
        {
            lock (_locker)
            {
                List<LocationCache> removeItems = locationCaches.Where(x => (DateTime.Now - x.DateTime).TotalMinutes > 5).ToList();//查询添加静态变量超过10分钟的货位
                int count = removeItems.Count;
                for (int i = 0; i < count; i++)
                {
                    locationCaches.Remove(removeItems[i]);//移除查询添加静态变量超过5分钟的货位
                }

                List<string> lockLocations = locationCaches.Select(x => x.LocationCode).ToList();

                List<Dt_LocationInfo> locationInfos = null;
                locationInfos = BaseDal.QueryData(x => x.RoadwayNo == roadway && x.LocationType == Locationtype && x.EnableStatus == (int)EnableStatusEnum.Normal);


                List<Dt_LocationInfo> emptyLocations = locationInfos.Where(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && !lockLocations.Contains(x.LocationCode)).OrderBy(x => x.Layer).ThenBy(x => x.Column).ThenByDescending(x => x.Depth).ThenBy(x => x.Row).ToList();//查询空货位信息并排除20分钟内分配的货位,根据层、列、深度、行排序


                for (int i = 0; i < emptyLocations.Count; i++)
                {
                    if (emptyLocations[i].Depth == 1)//判断是否1深货位
                    {
                        //查询深库位
                        //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())
                        {
                            locationCaches.Add(new LocationCache { DateTime = DateTime.Now, LocationCode = sencondDepthLocationShen.LocationCode });
                            return sencondDepthLocationShen;//1深货位及2深货位都为空的情况下,优先分配2深货位
                        }
                        else
                        {
                            Dt_LocationInfo? sencondDepthLo = locationInfos.FirstOrDefault(x => x.Row == emprow && x.Layer == emptyLocations[i].Layer && x.Column == emptyLocations[i].Column);
                            if (sencondDepthLo != null && sencondDepthLo.LocationStatus != LocationStatusEnum.Lock.ObjToInt() && sencondDepthLo.LocationStatus == LocationStatusEnum.InStock.ObjToInt() && !lockLocations.Contains(sencondDepthLo.LocationCode))
                            {
                                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 = 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())
                        {
                            locationCaches.Add(new LocationCache { DateTime = DateTime.Now, LocationCode = emptyLocations[i].LocationCode });
                            return emptyLocations[i];
                        }
                    }
                }
                return null;
            }
        }

        public 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; }

            public DateTime DateTime { get; set; }
        }



        public WebResponseContent GetArea()
        {
            // WarehouseId分组，然后是RoadwayNo
            var result = BaseDal.QueryData()
                .GroupBy(x => x.WarehouseId)
                .Select(g => new {
                    WarehouseId = g.Key,
                    RoadwayNo = g.Select(x => x.RoadwayNo).Distinct().ToList()
                })
                .ToList();
            return WebResponseContent.Instance.OK("成功", result);
        }

        public WebResponseContent GetLocationStatus(int WarehouseId, string RoadwayNo)
        {
            // æ ¼å¼{层,{这一层的列数据}}
            var locations = BaseDal.QueryData(x => x.WarehouseId == WarehouseId && x.RoadwayNo == RoadwayNo)
                .Select(x => new
                {
                    x.RoadwayNo,
                    x.LocationCode,
                    x.WarehouseId,
                    x.Row,
                    x.Column,
                    x.Layer,
                    x.Depth,
                    x.LocationType,
                    x.LocationStatus,
                    x.EnableStatus
                })
                .ToList();

            // å¦‚果没有找到数据，返回空列表而不是null
            if (locations == null || !locations.Any())
            {
                return WebResponseContent.Instance.OK("未找到对应巷道的货位数据", new List<object>());
            }

            // ä¿®æ”¹ä¸ºå±‚下面放所有列的信息
            var result = locations
                .GroupBy(x => x.Layer)  // æŒ‰å±‚分组
                .Select(layerGroup => new
                {
                    layer = layerGroup.Key,
                    columns = layerGroup.GroupBy(x => x.Column)  // æ¯å±‚中按列分组
                                       .Select(columnGroup => new
                                       {
                                           column = columnGroup.Key,
                                           depths = columnGroup.Select(d => new
                                           {
                                               row = d.Row,
                                               LocationCode = d.LocationCode,
                                               depth = d.Depth,
                                               locationType = d.LocationType,
                                               locationStatus = d.LocationStatus,
                                               enableStatus = d.EnableStatus
                                           }).ToList()
                                       }).ToList()
                }).ToList();

            return WebResponseContent.Instance.OK("成功", result);
        }

        public WebResponseContent GetWarehouseCapacity()
        {
            // æŸ¥è¯¢æ‰€æœ‰ä»“库的货位数据
            var allLocations = BaseDal.QueryData()
                .Select(x => new
                {
                    x.WarehouseId,
                    x.LocationStatus
                })
                .ToList();

            // å¦‚果没有数据，返回空列表
            if (allLocations == null || !allLocations.Any())
            {
                return WebResponseContent.Instance.OK("未找到任何货位数据", new List<object>());
            }

            // è®¡ç®—每个仓库的容量使用情况
            var result = allLocations
                .GroupBy(x => x.WarehouseId)
                .Select(g => new
                {
                    WarehouseId = g.Key,
                    FreeLocations = g.Count(x => x.LocationStatus == 0),
                    RemainingCapacityPercentage = (int)Math.Round((double)g.Count(x => x.LocationStatus == 0) / g.Count() * 100)
                })
                .ToList();

            return WebResponseContent.Instance.OK("成功", result);
        }

        /// <summary>
        /// ä¸€é”®å¯ç”¨å··é“所有货位
        /// </summary>
        /// <param name="warehouseId">仓库ID</param>
        /// <param name="roadwayNo">巷道编号</param>
        /// <returns></returns>
        public WebResponseContent EnableAllLocationsInRoadway(string roadwayNo)
        {
            if (string.IsNullOrEmpty(roadwayNo))
                return WebResponseContent.Instance.Error("巷道编号不能为空");

            var locations = Repository.QueryData(x =>
                x.RoadwayNo == roadwayNo &&
                x.EnableStatus != EnableStatusEnum.Normal.ObjToInt());

            if (locations == null || locations.Count == 0)
                return WebResponseContent.Instance.OK("该巷道没有需要启用的货位");

            locations.ForEach(x => x.EnableStatus = EnableStatusEnum.Normal.ObjToInt());
            Repository.UpdateData(locations);

            return WebResponseContent.Instance.OK($"成功启用巷道[{roadwayNo}]的{locations.Count}个货位");
        }

        /// <summary>
        /// ä¸€é”®ç¦ç”¨å··é“所有货位
        /// </summary>
        /// <param name="warehouseId">仓库ID</param>
        /// <param name="roadwayNo">巷道编号</param>
        /// <returns></returns>
        public WebResponseContent DisableAllLocationsInRoadway(string roadwayNo)
        {
            if (string.IsNullOrEmpty(roadwayNo))
                return WebResponseContent.Instance.Error("巷道编号不能为空");
            var locations = Repository.QueryData(x =>
                x.RoadwayNo == roadwayNo &&
                x.EnableStatus != EnableStatusEnum.Disable.ObjToInt());
            if (locations == null || locations.Count == 0)
                return WebResponseContent.Instance.OK("该巷道没有需要禁用的货位");
            // æ£€æŸ¥è´§ä½æ˜¯å¦æœ‰åº“å­˜
            var locationIds = locations.Select(x => x.Id).ToList();
            locations.ForEach(x => x.EnableStatus = EnableStatusEnum.Disable.ObjToInt());
            Repository.UpdateData(locations);
            return WebResponseContent.Instance.OK($"成功禁用巷道[{roadwayNo}]的{locations.Count}个货位");
        }
    }
}