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, ILocationInfoService { private readonly IRecordService _recordService; public LocationInfoService(ILocationInfoRepository BaseDal, IBasicRepository basicRepository, IRecordService recordService) : base(BaseDal) { _basicRepository = basicRepository; _recordService = recordService; } private Dictionary _emptyAssignOrderBy = new Dictionary() { { 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.InSCStationCode == 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 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 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); } } }