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;
|
|
namespace WIDESEA_BasicService
|
{
|
public partial class LocationInfoService : ServiceBase<Dt_LocationInfo, ILocationInfoRepository>, ILocationInfoService
|
{
|
private readonly IRecordService _recordService;
|
public LocationInfoService(ILocationInfoRepository BaseDal, IBasicRepository basicRepository, IRecordService recordService) : base(BaseDal)
|
{
|
_basicRepository = basicRepository;
|
_recordService = recordService;
|
}
|
private Dictionary<string, OrderByType> _emptyAssignOrderBy = new Dictionary<string, OrderByType>()
|
{
|
{ nameof(Dt_LocationInfo.Depth), OrderByType.Desc },
|
{ nameof(Dt_LocationInfo.Layer), OrderByType.Asc },
|
{ nameof(Dt_LocationInfo.Column), OrderByType.Asc },
|
{ nameof(Dt_LocationInfo.Row), OrderByType.Asc },
|
};
|
|
public virtual Dt_LocationInfo? AssignLocation(string stationCode, int inboundType)
|
{
|
try
|
{
|
Dt_RoadwayInfo roadwayInfo = _basicRepository.RoadwayInfoRepository.QueryFirst(x => x.InStationCode == stationCode) ?? throw new Exception("未找到该站台对应的巷道，请检查基础配置信息");
|
if (roadwayInfo.EnableStatus != EnableStatusEnum.Normal.ObjToInt() && roadwayInfo.EnableStatus != EnableStatusEnum.OnlyIn.ObjToInt())
|
{
|
throw new Exception("该巷道不可入库，请检查巷道禁用信息");
|
}
|
if (roadwayInfo.AreaId > 0)
|
{
|
Dt_AreaInfo areaInfo = _basicRepository.AreaInfoRepository.QueryFirst(x => x.Id == roadwayInfo.AreaId);
|
if (areaInfo != null && areaInfo.AreaStatus == EnableEnum.Disable.ObjToInt())
|
{
|
throw new Exception("区域被禁用，不可入库");
|
}
|
}
|
if (inboundType == TaskTypeEnum.PalletInbound.ObjToInt())//空盘入库分配逻辑
|
{
|
return EmptyAssignLocation(roadwayInfo.RoadwayNo);
|
}
|
else if (inboundType == TaskTypeEnum.Inbound.ObjToInt())
|
{
|
return StoredAssignLocation(roadwayInfo.RoadwayNo);
|
}
|
}
|
catch (Exception ex)
|
{
|
|
}
|
|
return null;
|
}
|
public virtual Dt_LocationInfo? AssignLocation(string RoadwayNo)
|
{
|
return StoredAssignLocation(RoadwayNo);
|
}
|
|
private Dt_LocationInfo EmptyAssignLocation(string roadway)
|
{
|
List<LocationGroupDTO> locationGroups = BaseDal.GetLocationGroups(roadway, LocationStatusEnum.Free, LocationStatusEnum.Pallet);
|
if (locationGroups != null && locationGroups.Count > 0)
|
{
|
LocationGroupDTO? locationGroup = locationGroups.FirstOrDefault(x => x.EnableStatusA == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatusA == EnableStatusEnum.Normal.ObjToInt());
|
int id = locationGroup?.IdA ?? 0;
|
return BaseDal.QueryFirst(x => x.Id == id);
|
}
|
locationGroups = BaseDal.GetLocationGroups(roadway, LocationStatusEnum.Free, LocationStatusEnum.Free);
|
if (locationGroups != null && locationGroups.Count > 0)
|
{
|
LocationGroupDTO? locationGroup = locationGroups.FirstOrDefault(x => x.EnableStatusB == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatusB == EnableStatusEnum.Normal.ObjToInt());
|
int id = locationGroup?.IdB ?? 0;
|
return BaseDal.QueryFirst(x => x.Id == id);
|
}
|
|
return BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.RoadwayNo == roadway), _emptyAssignOrderBy);
|
}
|
|
private Dt_LocationInfo StoredAssignLocation(string roadway)
|
{
|
List<LocationGroupDTO> locationGroups = BaseDal.GetLocationGroups(roadway, LocationStatusEnum.Free, LocationStatusEnum.InStock);
|
if (locationGroups != null && locationGroups.Count > 0)
|
{
|
LocationGroupDTO? locationGroup = locationGroups.FirstOrDefault(x => x.EnableStatusA == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatusA == EnableStatusEnum.Normal.ObjToInt());
|
int id = locationGroup?.IdA ?? 0;
|
return BaseDal.QueryFirst(x => x.Id == id);
|
}
|
locationGroups = BaseDal.GetLocationGroups(roadway, LocationStatusEnum.Free, LocationStatusEnum.Free);
|
if (locationGroups != null && locationGroups.Count > 0)
|
{
|
LocationGroupDTO? locationGroup = locationGroups.FirstOrDefault(x => x.EnableStatusB == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatusB == EnableStatusEnum.Normal.ObjToInt());
|
int id = locationGroup?.IdB ?? 0;
|
return BaseDal.QueryFirst(x => x.Id == id);
|
}
|
|
return BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.RoadwayNo == roadway), _emptyAssignOrderBy);
|
}
|
|
public Dt_LocationInfo AdjacentDepthLocation(string locationCode)
|
{
|
Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationCode == locationCode);
|
return AdjacentDepthLocation(locationInfo);
|
}
|
|
public Dt_LocationInfo AdjacentDepthLocation(Dt_LocationInfo locationInfo)
|
{
|
return BaseDal.QueryFirst(x => x.RoadwayNo == locationInfo.RoadwayNo && x.Column == locationInfo.Column && x.Layer == locationInfo.Layer && x.Depth != locationInfo.Depth && x.Row != locationInfo.Row && (SqlFunc.Abs(x.Row - locationInfo.Row) == 1));
|
}
|
public void UpdateLocationLock(Dt_LocationInfo locations, int TaskNum,int changType,bool black)
|
{
|
try
|
{
|
if (black)
|
{
|
(Dt_LocationInfo?, int?) result = isDepth(locations);
|
if (result.Item1 != null && (result.Item2 == LocationStatusEnum.Free.ObjToInt()|| result.Item2 == LocationStatusEnum.Lock.ObjToInt()))
|
{
|
int beforeStatusEnd = result.Item1.LocationStatus;
|
|
result.Item1.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
|
|
BaseDal.UpdateData(result.Item1);
|
|
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(result.Item1, beforeStatusEnd, changType, "", TaskNum);
|
}
|
}
|
else
|
{
|
(Dt_LocationInfo?, int?) result = isDepth(locations);
|
if (result.Item1 != null && result.Item2 == LocationStatusEnum.Free.ObjToInt())
|
{
|
int beforeStatusEnd = result.Item1.LocationStatus;
|
|
result.Item1.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
|
|
BaseDal.UpdateData(result.Item1);
|
|
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(result.Item1, beforeStatusEnd, changType, "", TaskNum);
|
}
|
}
|
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
|
}
|
public void UpdateLocationFree(Dt_LocationInfo locations, int TaskNum, int changType,bool black)
|
{
|
try
|
{
|
(Dt_LocationInfo?, int?) result = isDepth(locations);
|
if (result.Item1 != null)
|
{
|
int beforeStatusEnd = result.Item1.LocationStatus;
|
|
result.Item1.LocationStatus = LocationStatusEnum.Free.ObjToInt();
|
|
BaseDal.UpdateData(result.Item1);
|
|
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(result.Item1, beforeStatusEnd, changType, "", TaskNum);
|
}
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
|
}
|
public (Dt_LocationInfo?,int?) isDepth(Dt_LocationInfo locationInfo)
|
{
|
if (locationInfo.Depth == 2)
|
{
|
if (locationInfo.Row == 1 || locationInfo.Row == 5)
|
{
|
Dt_LocationInfo dt_LocationInfo = BaseDal.QueryFirst(x => x.Row == locationInfo.Row + 1 && x.Layer == locationInfo.Layer && x.Column == locationInfo.Column && x.RoadwayNo == locationInfo.RoadwayNo);
|
|
if (dt_LocationInfo != null&& dt_LocationInfo.LocationStatus==LocationStatusEnum.InStock.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.InStock.ObjToInt());
|
}
|
if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Free.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.Free.ObjToInt());
|
}
|
if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Lock.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.Lock.ObjToInt());
|
}
|
if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.PalletLock.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.PalletLock.ObjToInt());
|
}
|
if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.Pallet.ObjToInt());
|
}
|
}
|
else if (locationInfo.Row == 4 || locationInfo.Row == 8)
|
{
|
Dt_LocationInfo dt_LocationInfo = BaseDal.QueryFirst(x => x.Row == locationInfo.Row + 1 && x.Layer == locationInfo.Layer && x.Column == locationInfo.Column && x.RoadwayNo == locationInfo.RoadwayNo);
|
|
if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.InStock.ObjToInt());
|
}
|
if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Free.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.Free.ObjToInt());
|
}
|
if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Lock.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.Lock.ObjToInt());
|
}
|
if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.PalletLock.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.PalletLock.ObjToInt());
|
}
|
if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
|
{
|
return (dt_LocationInfo, LocationStatusEnum.Pallet.ObjToInt());
|
}
|
}
|
}
|
return (null, LocationStatusEnum.Free.ObjToInt());
|
}
|
public void RelocationLock(Dt_LocationInfo locationInfo, Dt_LocationInfo locationInfos, int TaskNum)
|
{
|
int beforeStartStatus = locationInfo.LocationStatus;
|
int beforeEndStatus = locationInfos.LocationStatus;
|
|
locationInfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
|
|
if (locationInfos.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
|
{
|
locationInfos.LocationStatus = LocationStatusEnum.PalletLock.ObjToInt();
|
}
|
else
|
{
|
locationInfos.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
|
}
|
|
BaseDal.UpdateData(locationInfo);
|
BaseDal.UpdateData(locationInfos);
|
|
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStartStatus, StockChangeType.Relocation.ObjToInt(), "", TaskNum);
|
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfos, beforeEndStatus, StockChangeType.Relocation.ObjToInt(), "", TaskNum);
|
}
|
public void RelocationFree(Dt_LocationInfo locations, int TaskNum)
|
{
|
int beforeEndStatus = locations.LocationStatus;
|
|
locations.LocationStatus = LocationStatusEnum.InStock.ObjToInt();
|
|
BaseDal.UpdateData(locations);
|
|
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locations, beforeEndStatus, StockChangeType.Relocation.ObjToInt(), "", TaskNum);
|
}
|
}
|
}
|
