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 partial class LocationInfoService
|
{
|
public Dt_LocationInfo? AssignLocation(string roadwayNo, PalletTypeEnum palletType, int warehouseId)
|
{
|
Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseId == warehouseId);
|
if (warehouse == null)
|
{
|
throw new Exception($"未找到仓库信息");
|
}
|
|
return warehouse.WarehouseName switch
|
{
|
"板材仓" => AssignLocation_BC(roadwayNo, palletType),
|
"PP仓" => AssignLocation_PP(roadwayNo, palletType),
|
"干膜仓" => AssignLocation_GM(roadwayNo, palletType),
|
"测试架仓" => AssignLocation_CSJ(roadwayNo, palletType),
|
"阻焊仓" => AssignLocation_ZH(roadwayNo, palletType),
|
"油墨仓" => AssignLocation(roadwayNo),
|
"成品仓" => AssignLocation(roadwayNo),
|
"辅料仓" => AssignLocation(roadwayNo),
|
_ => throw new Exception($"未找到仓库货位分配方法")
|
};
|
}
|
|
public bool LittleDepthLocationIsEmpty(Dt_LocationInfo locationInfo, PalletTypeEnum palletType)
|
{
|
Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseId == locationInfo.WarehouseId);
|
if (warehouse == null)
|
{
|
throw new Exception($"未找到仓库信息");
|
}
|
|
return warehouse.WarehouseName switch
|
{
|
"板材仓" => false,
|
"PP仓" => false,
|
"干膜仓" => false,
|
"测试架仓" => LittleDepthLocationIsEmpty_CSJ(locationInfo, palletType),
|
"阻焊仓" => false,
|
"油墨仓" => true,
|
"成品仓" => true,
|
"辅料仓" => true,
|
_ => throw new Exception($"未找到仓库货位分配方法")
|
};
|
}
|
|
private readonly static object _locker = new object();
|
private static List<LocationCache> locationCaches = new List<LocationCache>();
|
/// <summary>
|
///
|
/// </summary>
|
/// <param name="roadwayNo"></param>
|
/// <returns></returns>
|
public Dt_LocationInfo? AssignLocation(string roadwayNo)
|
{
|
lock (_locker)
|
{
|
List<LocationCache> removeItems = locationCaches.Where(x => (DateTime.Now - x.DateTime).TotalMinutes > 5).ToList();//查询添加静态变量超过5分钟的货位
|
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 = BaseDal.QueryData(x => x.RoadwayNo == roadwayNo);//查询巷道所有货位信息
|
|
Dictionary<string, OrderByType> orderBy = new Dictionary<string, OrderByType>()
|
{
|
{ nameof(Dt_LocationInfo.Layer),OrderByType.Asc },
|
{ nameof(Dt_LocationInfo.Column),OrderByType.Asc },
|
{ nameof(Dt_LocationInfo.Depth),OrderByType.Desc },
|
{ nameof(Dt_LocationInfo.Row),OrderByType.Asc }
|
};
|
|
return BaseDal.QueryFirst(x => x.RoadwayNo == roadwayNo && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && !lockLocations.Contains(x.LocationCode), orderBy);//查询空货位信息并排除5分钟内分配的货位,根据层、列、深度、行排序
|
}
|
}
|
|
/// <summary>
|
/// 修改货位状态及类型
|
/// </summary>
|
/// <param name="locationCode">货位编号</param>
|
/// <param name="palletType">托盘类型</param>
|
/// <param name="locationStatus">货位状态</param>
|
public void UpdateLocationStatus(string locationCode, PalletTypeEnum palletType, LocationStatusEnum locationStatus, int warehousId)
|
{
|
Dt_LocationInfo location = Repository.QueryFirst(x => x.LocationCode == locationCode);
|
if (location == null)
|
{
|
throw new Exception($"未找到货位信息,{locationCode}");
|
}
|
UpdateLocationStatus(location, palletType, locationStatus, warehousId);
|
}
|
|
/// <summary>
|
/// 修改货位状态及类型
|
/// </summary>
|
/// <param name="location">货位对象</param>
|
/// <param name="palletType">托盘类型</param>
|
/// <param name="locationStatus">货位状态</param>
|
public void UpdateLocationStatus(Dt_LocationInfo location, PalletTypeEnum palletType, LocationStatusEnum locationStatus, int warehousId)
|
{
|
List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => x.RoadwayNo == location.RoadwayNo);
|
|
List<Dt_LocationInfo> 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<Dt_LocationInfo> 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);
|
}
|
|
/// <summary>
|
/// 获取不同深度的同组货位信息
|
/// </summary>
|
/// <param name="locationInfos"></param>
|
/// <param name="location"></param>
|
/// <returns></returns>
|
public List<Dt_LocationInfo> GetGroupLocations(List<Dt_LocationInfo> locationInfos, Dt_LocationInfo location)
|
{
|
List<Dt_LocationInfo> groupLocations = new List<Dt_LocationInfo>() { 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;
|
}
|
|
/// <summary>
|
/// 获取不同深度的同组货位信息
|
/// </summary>
|
/// <param name="location"></param>
|
/// <returns></returns>
|
public List<Dt_LocationInfo> GetGroupLocations(Dt_LocationInfo location)
|
{
|
List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => x.RoadwayNo == location.RoadwayNo && x.WarehouseId == location.WarehouseId);
|
|
List<Dt_LocationInfo> groupLocations = new List<Dt_LocationInfo>() { 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;
|
}
|
}
|
|
}
|
