using AutoMapper; using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using WIDESEA_Core; using WIDESEA_Core.BaseRepository; using WIDESEA_Core.BaseServices; using WIDESEA_Core.Enums; using WIDESEA_Core.Helper; using WIDESEA_Core.Utilities; using WIDESEA_DTO.Basic; using WIDESEA_IBasicRepository; using WIDESEA_IRecordService; using WIDESEA_IBasicService; using WIDESEA_Model.Models; using WIDESEA_Common.CommonEnum; using WIDESEA_Common.LocationEnum; namespace WIDESEA_BasicService { public class LocationInfoService_Old { private readonly ILocationInfoRepository Repository; public LocationInfoService_Old(ILocationInfoRepository repository) { Repository = repository; } double weightValue = 0.5; private readonly static object _locker = new object(); static List locationCaches = new List(); /// /// 货位分配逻辑 /// /// 巷道号 /// 托盘类型 /// public Dt_LocationInfo? AssignLocation(string roadwayNo, PalletTypeEnum palletType) { lock (_locker) { List removeItems = locationCaches.Where(x => (DateTime.Now - x.DateTime).TotalMinutes > 5).ToList(); int count = removeItems.Count; for (int i = 0; i < count; i++) { locationCaches.Remove(removeItems[i]); } List lockLocationCodes = locationCaches.Select(x => x.LocationCode).ToList(); List locationInfos = Repository.QueryData(x => x.RoadwayNo == roadwayNo); //已定义货位类型的货位 List definedTypeLocations = locationInfos.Where(x => x.LocationType == palletType.ObjToInt()).ToList(); //未定义类型的空货位 List undefinedTypeEmptyLocations = locationInfos.Where(x => (x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() || x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt()) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && x.LocationType == LocationTypeEnum.Undefined.ObjToInt() && !lockLocationCodes.Contains(x.LocationCode)).OrderByDescending(x => x.Depth).ThenBy(x => x.Layer).ThenBy(x => x.Row).ThenBy(x => x.Column).ToList(); if (locationInfos.Count * weightValue >= definedTypeLocations.Count && undefinedTypeEmptyLocations.Count > 0)//如果已定义类型货位未超过比例,且有未定义类型的货位 { if (palletType == PalletTypeEnum.LargePallet) { undefinedTypeEmptyLocations = undefinedTypeEmptyLocations.Where(x => x.Column % 2 == 1).ToList(); } for (int i = 0; i < undefinedTypeEmptyLocations.Count; i++) { Dt_LocationInfo undefinedTypeEmptyLocation = undefinedTypeEmptyLocations[i]; Dt_LocationInfo? locationInfo = GetUsableLocation(locationInfos, undefinedTypeEmptyLocation, palletType); if (locationInfo != null) { //UpdateLocationStatus(locationInfo.LocationCode, palletType, LocationStatusEnum.Lock); locationCaches.Add(new LocationCache { LocationCode = locationInfo.LocationCode, DateTime = DateTime.Now }); return locationInfo; } } } else { List definedTypeEmptyLocations = locationInfos.Where(x => (x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() || x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt()) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && x.LocationType == palletType.ObjToInt() && !lockLocationCodes.Contains(x.LocationCode)).OrderByDescending(x => x.Depth).ThenBy(x => x.Layer).ThenBy(x => x.Row).ThenBy(x => x.Column).ToList(); for (int i = 0; i < definedTypeEmptyLocations.Count; i++) { Dt_LocationInfo definedTypeEmptyLocation = definedTypeEmptyLocations[i]; Dt_LocationInfo? locationInfo = GetUsableLocation(locationInfos, definedTypeEmptyLocation, palletType); if (locationInfo != null) { //UpdateLocationStatus(locationInfo.LocationCode, palletType, LocationStatusEnum.Lock); locationCaches.Add(new LocationCache { LocationCode = locationInfo.LocationCode, DateTime = DateTime.Now }); return locationInfo; } } } return null; } } public Dt_LocationInfo? GetUsableLocation(List locationInfos, Dt_LocationInfo undefinedTypeEmptyLocation, PalletTypeEnum palletType) { switch (palletType) { case PalletTypeEnum.LargePallet: { Dt_LocationInfo? nearLocation = locationInfos.FirstOrDefault(x => x.Row == undefinedTypeEmptyLocation.Row && x.Layer == undefinedTypeEmptyLocation.Layer && x.Depth == undefinedTypeEmptyLocation.Depth && x.Column == undefinedTypeEmptyLocation.Column + 1); if (nearLocation != null && nearLocation.LocationStatus == LocationStatusEnum.Free.ObjToInt() && DepthLocationIsEmpty(locationInfos, undefinedTypeEmptyLocation) != null) { Dt_LocationInfo? locationInfo = DepthLocationIsEmpty(locationInfos, undefinedTypeEmptyLocation); if (locationInfo != null) { return locationInfo; } } } break; case PalletTypeEnum.SmallPallet: { Dt_LocationInfo? locationInfo = DepthLocationIsEmpty(locationInfos, undefinedTypeEmptyLocation); if (locationInfo != null) { return locationInfo; } } break; } return null; } private Dt_LocationInfo? DepthLocationIsEmpty(List locationInfos, Dt_LocationInfo undefinedTypeEmptyLocation) { int maxDepth = locationInfos.Max(x => x.Depth); if (undefinedTypeEmptyLocation.Depth == 1 && maxDepth == 1) { return undefinedTypeEmptyLocation; } else { List locations = GetGroupLocations(locationInfos, undefinedTypeEmptyLocation); List moreDepth = locations.Where(x => x.Depth > undefinedTypeEmptyLocation.Depth).ToList(); bool moreDepthFlag = moreDepth.FirstOrDefault(x => x.LocationStatus != LocationStatusEnum.InStock.ObjToInt()) == null;//查询大于当前货位深度的集合里是否有状态不为有货的货位,如果是true,则表示深货位有未被使用的情况 List littleDepth = locations.Where(x => x.Depth <= undefinedTypeEmptyLocation.Depth).ToList(); bool littleDepthFlag = littleDepth.FirstOrDefault(x => x.LocationStatus != LocationStatusEnum.Free.ObjToInt() && x.EnableStatus != EnableStatusEnum.OnlyIn.ObjToInt() && x.EnableStatus != EnableStatusEnum.Normal.ObjToInt()) == null; //查询小于当前货位深度的集合里是否有状态不为空,且禁用状态不为禁用以及只入的货位,如果是true,则表示浅货位被使用或者被禁用的情况 if (moreDepthFlag && littleDepthFlag) { return undefinedTypeEmptyLocation; } } return null; } /// /// 修改货位状态及类型 /// /// 货位编号 /// 托盘类型 /// 货位状态 public void UpdateLocationStatus(string locationCode, PalletTypeEnum palletType, LocationStatusEnum locationStatus) { Dt_LocationInfo location = Repository.QueryFirst(x => x.LocationCode == locationCode); List locationInfos = Repository.QueryData(x => x.RoadwayNo == location.RoadwayNo); List locations = GetGroupLocations(locationInfos, location); if (locationInfos.Max(x => x.Depth) < 3) { for (int i = 0; i < locations.Count; i++) { locations[i].LocationStatus = locationStatus.ObjToInt(); locations[i].LocationType = palletType.ObjToInt(); } Dt_LocationInfo? nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column + 1); if (nearLocation != null) { List nearLocations = GetGroupLocations(locationInfos, nearLocation); for (int i = 0; i < nearLocations.Count; i++) { nearLocations[i].LocationType = palletType.ObjToInt(); if (palletType == PalletTypeEnum.LargePallet) { nearLocations[i].LocationStatus = locationStatus.ObjToInt(); } } locations.AddRange(nearLocations); } } else { for (int i = 0; i < locations.Count; i++) { locations[i].LocationStatus = locationStatus.ObjToInt(); locations[i].LocationType = palletType.ObjToInt(); } } Repository.UpdateData(locations); } /// /// 修改货位状态及类型 /// /// 货位对象 /// 托盘类型 /// 货位状态 public void UpdateLocationStatus(Dt_LocationInfo location, PalletTypeEnum palletType, LocationStatusEnum locationStatus) { List locationInfos = Repository.QueryData(x => x.RoadwayNo == location.RoadwayNo); List locations = GetGroupLocations(locationInfos, location); if (locationInfos.Max(x => x.Depth) < 3) { for (int i = 0; i < locations.Count; i++) { locations[i].LocationStatus = locationStatus.ObjToInt(); locations[i].LocationType = palletType.ObjToInt(); } Dt_LocationInfo? nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column + 1); if (nearLocation != null) { List nearLocations = GetGroupLocations(locationInfos, nearLocation); for (int i = 0; i < nearLocations.Count; i++) { nearLocations[i].LocationType = palletType.ObjToInt(); if (palletType == PalletTypeEnum.LargePallet) { nearLocations[i].LocationStatus = locationStatus.ObjToInt(); } } locations.AddRange(nearLocations); } } else { for (int i = 0; i < locations.Count; i++) { locations[i].LocationStatus = locationStatus.ObjToInt(); locations[i].LocationType = palletType.ObjToInt(); } } Repository.UpdateData(locations); } private List GetGroupLocations(List locationInfos, Dt_LocationInfo location) { List groupLocations = new List() { location }; int maxDepth = locationInfos.Max(x => x.Depth); for (int j = location.Depth + 1; j <= maxDepth; j++) { Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer); if (locationInfo != null) { groupLocations.Add(locationInfo); } } for (int j = location.Depth - 1; j >= 1; j--) { Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer); if (locationInfo != null) { groupLocations.Add(locationInfo); } } return groupLocations; } } public class LocationCache { public string LocationCode { get; set; } public DateTime DateTime { get; set; } } }