using Microsoft.AspNetCore.Mvc.RazorPages;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Core;
|
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_IBasicService;
|
using WIDESEA_Model.Models;
|
|
namespace WIDESEA_BasicService
|
{
|
public partial class LocationInfoService : ServiceBase<Dt_LocationInfo, ILocationInfoRepository>, ILocationInfoService
|
{
|
|
|
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 },
|
};
|
/// <summary>
|
/// 根据货位编号获取货位信息
|
/// </summary>
|
/// <param name="LocationCode"></param>
|
/// <returns></returns>
|
public Dt_LocationInfo GetLocation(string LocationCode)
|
{
|
return BaseDal.QueryData(x => x.LocationCode == LocationCode).FirstOrDefault();
|
}
|
public WebResponseContent UpdateStatus(List<string> locationCodes, int Statu)
|
{
|
WebResponseContent content = new WebResponseContent().OK();
|
try
|
{
|
List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => locationCodes.Contains(x.LocationCode));
|
foreach (var locationCode in locationCodes.GroupBy(x => x))
|
{
|
if (locationCode.Count() > 2) throw new Exception("货位绑定柜号过多");
|
if (locationCode.Count() > 1)
|
{
|
var location = locationInfos.Where(x => x.LocationCode == locationCode.Key).FirstOrDefault();
|
if (location != null && location.LocationStatus == Statu) throw new Exception("货位绑定柜号过多");
|
if(locationCode.Count() == 2) location.EnableStatus = EnableStatusEnum.OnlyOut.ObjToInt();
|
}
|
//else
|
//{
|
// throw new Exception("货位绑定柜号过多");
|
//}
|
}
|
locationInfos.ForEach(x =>
|
{
|
if (x.MaxQty == 12 || x.LocationStatus == Statu) x.EnableStatus = EnableStatusEnum.OnlyOut.ObjToInt();
|
x.LocationStatus = Statu;//LocationStatusEnum.PalletLock.ObjToInt()
|
});
|
content = UpdateData(locationInfos);
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
/// <summary>
|
/// 分配货位
|
/// </summary>
|
/// <param name="stockInfo">组盘信息</param>
|
/// <param name="inboundOrder">入库单</param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public Dt_LocationInfo AssignLocation(int inboundOrderCount)
|
{
|
Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.MaxQty == (inboundOrderCount > 1 ? 24 : 12), _emptyAssignOrderBy);
|
|
if (locationInfo == null) locationInfo = BaseDal.QueryFirst(x => (x.LocationStatus == LocationStatusEnum.Free.ObjToInt() || x.LocationStatus == LocationStatusEnum.InStock.ObjToInt() || x.LocationStatus == LocationStatusEnum.Inbounding.ObjToInt()) && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()), _emptyAssignOrderBy);
|
|
return locationInfo;
|
}
|
|
|
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;
|
}
|
|
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)
|
{
|
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.LocationStatus == LocationStatusEnum.InStock.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 WebResponseContent GetPosition(string position)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationCode == position);
|
if (locationInfo == null) throw new Exception("未找到货位信息");
|
//分配穿梭车移库地址
|
var locationInfos = BaseDal.QueryData(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && x.EnableStatus != EnableStatusEnum.Disable.ObjToInt() && x.LocationCode != locationInfo.LocationCode);//需根据入库逻辑改动
|
var location = locationInfos.OrderBy(x => x.Layer).ThenBy(x => x.Column).ThenBy(x => x.Row).FirstOrDefault();
|
//if (location != null) content.OK(message: location.LocationCode, data: location);
|
if (location != null) content.OK(location.LocationCode);
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
}
|
}
|
