using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Common.CommonEnum;
|
using WIDESEA_Common.LocationEnum;
|
using WIDESEA_Core.BaseServices;
|
using WIDESEA_Core.Helper;
|
using WIDESEA_IBasicRepository;
|
using WIDESEA_IBasicService;
|
using WIDESEA_Model.Models;
|
|
namespace WIDESEA_BasicService
|
{
|
public partial class LocationInfoService
|
{
|
|
double weightValue_GM = 0.25;
|
|
private readonly static object _locker_GM = new object();
|
static List<LocationCache> locationCaches_GM = new List<LocationCache>();
|
|
/// <summary>
|
/// 干膜仓货位分配
|
/// </summary>
|
/// <param name="roadwayNo">巷道号</param>
|
/// <param name="palletType">
|
/// 托盘类型
|
/// </param>
|
/// <returns></returns>
|
public Dt_LocationInfo? AssignLocation_GM(string roadwayNo, int palletType, Dt_PalletTypeInfo palletTypeInfo, string beRelocationCode = "")
|
{
|
lock (_locker_GM)
|
{
|
List<LocationCache> removeItems = locationCaches_GM.Where(x => (DateTime.Now - x.DateTime).TotalMinutes > 5).ToList();
|
int count = removeItems.Count;
|
for (int i = 0; i < count; i++)
|
{
|
locationCaches_GM.Remove(removeItems[i]);
|
}
|
|
List<string> lockLocationCodes = locationCaches_GM.Select(x => x.LocationCode).ToList();
|
|
List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => x.RoadwayNo == roadwayNo);
|
//获取所有货位数据
|
List<Dt_LocationInfo> locationInfoDepth = Repository.QueryData(x => x.RoadwayNo == roadwayNo);
|
if (locationInfos == null || locationInfos.Count == 0)
|
{
|
throw new Exception($"未找到该巷道的货位信息,巷道号:{roadwayNo}");
|
}
|
|
if (!string.IsNullOrEmpty(beRelocationCode))
|
{
|
Dt_LocationInfo? beRelocation = locationInfos.FirstOrDefault(x => x.LocationCode == beRelocationCode);
|
if (beRelocation == null)
|
{
|
throw new Exception($"未找到货位信息");
|
}
|
int maxDepth = locationInfos.Max(x => x.Depth);
|
int mathCurrentRow = beRelocation.Row - Convert.ToInt32(Math.Ceiling(beRelocation.Row / maxDepth / 2.0)) * maxDepth * 2;
|
if (mathCurrentRow <= maxDepth)
|
{
|
locationInfos = locationInfos.Where(x => x.Row - Convert.ToInt32(Math.Ceiling(x.Row / maxDepth / 2.0)) * maxDepth * 2 <= maxDepth).ToList();
|
if (beRelocation.Row> maxDepth)
|
{
|
locationInfos = locationInfos.Where(x=>x.Row>maxDepth).ToList();
|
}
|
}
|
else
|
{
|
locationInfos = locationInfos.Where(x => x.Row - Convert.ToInt32(Math.Ceiling(x.Row / maxDepth / 2.0)) * maxDepth * 2 > maxDepth).ToList();
|
if (beRelocation.Row <= maxDepth)
|
{
|
locationInfos = locationInfos.Where(x => x.Row <= maxDepth).ToList();
|
}
|
}
|
}
|
|
//已定义货位类型的货位
|
List<Dt_LocationInfo> definedTypeLocations = locationInfos.Where(x => x.LocationType == palletType.ObjToInt()).ToList();
|
|
//未定义类型的空货位
|
List<Dt_LocationInfo> 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.Column).ThenBy(x => x.Row).ToList();
|
|
List<Dt_LocationInfo> 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.Column).ThenBy(x => x.Row).ToList();
|
|
if (definedTypeEmptyLocations.Any())
|
{
|
for (int i = 0; i < definedTypeEmptyLocations.Count; i++)
|
{
|
Dt_LocationInfo definedTypeEmptyLocation = definedTypeEmptyLocations[i];
|
Dt_LocationInfo? locationInfo = GetUsableLocation_GM(locationInfos, definedTypeEmptyLocation, palletType, palletTypeInfo);
|
if (locationInfo != null)
|
{
|
if (locationInfo.Depth<locationInfoDepth.Max(x=>x.Depth))
|
{
|
Dt_LocationInfo? locationInfoExist = null;
|
int Column = locationInfo.Column;
|
if (Column % 2 == 0)
|
{
|
Column -= 1;
|
}
|
if (locationInfo.Row - locationInfo.Depth == locationInfo.Depth)
|
{
|
locationInfoExist = locationInfoDepth.FirstOrDefault(x => x.Row == (locationInfo.Row-1) && x.Column== Column && x.Layer==locationInfo.Layer);
|
}
|
else
|
{
|
locationInfoExist = locationInfoDepth.FirstOrDefault(x => x.Row == (locationInfo.Row + 1) && x.Column == Column && x.Layer == locationInfo.Layer);
|
}
|
//获取深位货位类型
|
if (locationInfoExist==null)
|
{
|
continue;
|
}
|
Dt_PalletTypeInfo palletTypeInfoDepth = _basicRepository.PalletTypeInfoRepository.QueryFirst(x => x.WarehouseId == locationInfoExist.WarehouseId && x.PalletType == locationInfoExist.LocationType);
|
if (palletTypeInfoDepth != null && palletTypeInfoDepth.LocaitonCount != palletTypeInfo.LocaitonCount)
|
{
|
continue;
|
}
|
}
|
else
|
{
|
Dt_LocationInfo? locationInfoExist = null;
|
int Column = locationInfo.Column;
|
if (Column % 2 == 0)
|
{
|
Column -= 1;
|
}
|
if (locationInfo.Row % 2 == 0)
|
{
|
locationInfoExist = locationInfoDepth.FirstOrDefault(x => x.Row == (locationInfo.Row - 1) && x.Column == Column && x.Layer == locationInfo.Layer);
|
}
|
else
|
{
|
locationInfoExist = locationInfoDepth.FirstOrDefault(x => x.Row == (locationInfo.Row + 1) && x.Column == Column && x.Layer == locationInfo.Layer);
|
}
|
//获取深位货位类型
|
if (locationInfoExist == null)
|
{
|
continue;
|
}
|
Dt_PalletTypeInfo palletTypeInfoDepth = _basicRepository.PalletTypeInfoRepository.QueryFirst(x => x.WarehouseId == locationInfoExist.WarehouseId && x.PalletType == locationInfoExist.LocationType);
|
if (palletTypeInfoDepth != null && palletTypeInfoDepth.LocaitonCount != palletTypeInfo.LocaitonCount)
|
{
|
continue;
|
}
|
if (locationInfoExist.LocationStatus!=LocationStatusEnum.Free.ObjToInt() || locationInfoExist.EnableStatus!= EnableStatusEnum.Normal.ObjToInt())
|
{
|
continue;
|
}
|
}
|
locationCaches_GM.Add(new LocationCache { LocationCode = locationInfo.LocationCode, DateTime = DateTime.Now });
|
return locationInfo;
|
}
|
}
|
}
|
if ((locationInfos.Count * weightValue_GM >= definedTypeLocations.Count && undefinedTypeEmptyLocations.Any()) || !definedTypeEmptyLocations.Any())//如果已定义类型货位未超过比例，且有未定义类型的货位
|
{
|
if (palletTypeInfo.LocaitonCount == 2)
|
{
|
if (palletTypeInfo.IsOdd)
|
undefinedTypeEmptyLocations = undefinedTypeEmptyLocations.Where(x => x.Column % 2 == 1).ToList();
|
else
|
undefinedTypeEmptyLocations = undefinedTypeEmptyLocations.Where(x => x.Column % 2 == 0).ToList();
|
}
|
for (int i = 0; i < undefinedTypeEmptyLocations.Count; i++)
|
{
|
Dt_LocationInfo undefinedTypeEmptyLocation = undefinedTypeEmptyLocations[i];
|
Dt_LocationInfo? locationInfo = GetUsableLocation_GM(locationInfos, undefinedTypeEmptyLocation, palletType, palletTypeInfo);
|
if (locationInfo != null)
|
{
|
if (locationInfo.Depth < locationInfoDepth.Max(x => x.Depth))
|
{
|
Dt_LocationInfo? locationInfoExist = null;
|
int Column = locationInfo.Column;
|
if (Column % 2 == 0)
|
{
|
Column -= 1;
|
}
|
if (locationInfo.Row - locationInfo.Depth == locationInfo.Depth)
|
{
|
locationInfoExist = locationInfoDepth.FirstOrDefault(x => x.Row == (locationInfo.Row - 1) && x.Column == Column && x.Layer == locationInfo.Layer);
|
}
|
else
|
{
|
locationInfoExist = locationInfoDepth.FirstOrDefault(x => x.Row == (locationInfo.Row + 1) && x.Column == Column && x.Layer == locationInfo.Layer);
|
}
|
//获取深位货位类型
|
if (locationInfoExist == null)
|
{
|
continue;
|
}
|
Dt_PalletTypeInfo palletTypeInfoDepth = _basicRepository.PalletTypeInfoRepository.QueryFirst(x => x.WarehouseId == locationInfoExist.WarehouseId && x.PalletType == locationInfoExist.LocationType);
|
if (palletTypeInfoDepth != null && palletTypeInfoDepth.LocaitonCount != palletTypeInfo.LocaitonCount)
|
{
|
continue;
|
}
|
}
|
else
|
{
|
Dt_LocationInfo? locationInfoExist = null;
|
int Column = locationInfo.Column;
|
if (Column % 2 == 0)
|
{
|
Column -= 1;
|
}
|
if (locationInfo.Row % 2 == 0)
|
{
|
locationInfoExist = locationInfoDepth.FirstOrDefault(x => x.Row == (locationInfo.Row - 1) && x.Column == Column && x.Layer == locationInfo.Layer);
|
}
|
else
|
{
|
locationInfoExist = locationInfoDepth.FirstOrDefault(x => x.Row == (locationInfo.Row + 1) && x.Column == Column && x.Layer == locationInfo.Layer);
|
}
|
//获取深位货位类型
|
if (locationInfoExist == null)
|
{
|
continue;
|
}
|
Dt_PalletTypeInfo palletTypeInfoDepth = _basicRepository.PalletTypeInfoRepository.QueryFirst(x => x.WarehouseId == locationInfoExist.WarehouseId && x.PalletType == locationInfoExist.LocationType);
|
if (palletTypeInfoDepth != null && palletTypeInfoDepth.LocaitonCount != palletTypeInfo.LocaitonCount)
|
{
|
continue;
|
}
|
if (locationInfoExist.LocationStatus != LocationStatusEnum.Free.ObjToInt() || locationInfoExist.EnableStatus != EnableStatusEnum.Normal.ObjToInt())
|
{
|
continue;
|
}
|
}
|
locationCaches_GM.Add(new LocationCache { LocationCode = locationInfo.LocationCode, DateTime = DateTime.Now });
|
return locationInfo;
|
}
|
}
|
}
|
////判断如果已定义货位类型的货位和未定义类型的空货位都为空释放满足条件的货位
|
//if (!definedTypeEmptyLocations.Any() && !undefinedTypeEmptyLocations.Any())
|
//{
|
|
//}
|
return null;
|
}
|
}
|
|
/// <summary>
|
/// 获取可用货位(测试架仓)
|
/// </summary>
|
/// <param name="locationInfos"></param>
|
/// <param name="emptyLocation"></param>
|
/// <param name="palletType"></param>
|
/// <returns></returns>
|
private Dt_LocationInfo? GetUsableLocation_GM(List<Dt_LocationInfo> locationInfos, Dt_LocationInfo emptyLocation, int palletType, Dt_PalletTypeInfo palletTypeInfo)
|
{
|
if (palletTypeInfo.LocaitonCount == 2)
|
{
|
if (palletTypeInfo.IsOdd && emptyLocation.Column % 2 != 1 || !palletTypeInfo.IsOdd && emptyLocation.Column % 2 != 0)
|
return null;
|
|
Dt_LocationInfo? nearLocation = locationInfos.FirstOrDefault(x => x.Row == emptyLocation.Row && x.Layer == emptyLocation.Layer && x.Depth == emptyLocation.Depth && x.Column == emptyLocation.Column + 1);
|
if (nearLocation != null && DepthLocationIsEmpty_BC(locationInfos, nearLocation) != null)
|
{
|
Dt_LocationInfo? locationInfo = DepthLocationIsEmpty_BC(locationInfos, emptyLocation);
|
if (locationInfo != null)
|
{
|
return locationInfo;
|
}
|
}
|
}
|
else
|
{
|
Dt_LocationInfo? locationInfo = DepthLocationIsEmpty_BC(locationInfos, emptyLocation);
|
if (locationInfo != null)
|
{
|
return locationInfo;
|
}
|
}
|
return null;
|
}
|
|
|
/// <summary>
|
/// 判断不同深度的同组货位状态是否为空闲空位(测试架仓)
|
/// </summary>
|
/// <param name="locationInfos"></param>
|
/// <param name="emptyLocation"></param>
|
/// <returns></returns>
|
private Dt_LocationInfo? DepthLocationIsEmpty_GM(List<Dt_LocationInfo> locationInfos, Dt_LocationInfo emptyLocation)
|
{
|
List<Dt_LocationInfo> locations = GetGroupLocations(locationInfos, emptyLocation);
|
|
bool moreDepthFlag = false;
|
bool littleDepthFlag = false;
|
|
if (emptyLocation.LocationType == 0)
|
{
|
List<Dt_LocationInfo> moreDepth = locations.Where(x => x.Depth > emptyLocation.Depth).ToList();
|
moreDepthFlag = moreDepth.FirstOrDefault(x => x.LocationStatus != LocationStatusEnum.InStock.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.LocationType != 0) == null;//查询大于当前货位深度的集合里是否有状态不为有货的货位，如果是true，则表示深货位有未被使用的情况
|
|
List<Dt_LocationInfo> littleDepth = locations.Where(x => x.Depth <= emptyLocation.Depth).ToList();
|
littleDepthFlag = littleDepth.FirstOrDefault(x => x.LocationStatus != LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.LocationType != 0) == null; //查询小于当前货位深度的集合里是否有状态不为空，且禁用状态不为禁用以及只入的货位，如果是true，则表示浅货位被使用或者被禁用的情况
|
}
|
else
|
{
|
List<Dt_LocationInfo> moreDepth = locations.Where(x => x.Depth > emptyLocation.Depth).ToList();
|
moreDepthFlag = moreDepth.FirstOrDefault(x => x.LocationStatus != LocationStatusEnum.InStock.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.LocationType != emptyLocation.LocationType) == null;//查询大于当前货位深度的集合里是否有状态不为有货的货位，如果是true，则表示深货位有未被使用的情况
|
|
List<Dt_LocationInfo> littleDepth = locations.Where(x => x.Depth <= emptyLocation.Depth).ToList();
|
littleDepthFlag = littleDepth.FirstOrDefault(x => x.LocationStatus != LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.LocationType != emptyLocation.LocationType) == null; //查询小于当前货位深度的集合里是否有状态不为空，且禁用状态不为禁用以及只入的货位，如果是true，则表示浅货位被使用或者被禁用的情况
|
}
|
|
if (moreDepthFlag && littleDepthFlag)
|
{
|
return emptyLocation;
|
}
|
|
return null;
|
}
|
}
|
}
|
