using Microsoft.AspNetCore.Mvc;
|
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>
|
/// <returns></returns>
|
public Dt_LocationInfo AssignLocation()
|
{
|
Dt_LocationInfo? locationInfo = null;
|
string CarChargingStation = AppSettings.Configuration[nameof(CarChargingStation)];//获取穿梭车充电位置
|
var ChargingStations = CarChargingStation.Split(",");
|
locationInfo = BaseDal.QueryFirst(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.Row == 3, _emptyAssignOrderBy);
|
|
if (locationInfo == null)
|
locationInfo = BaseDal.QueryFirst(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.Row == 1), _emptyAssignOrderBy);
|
if (locationInfo == null)
|
locationInfo = BaseDal.QueryFirst(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.Row == 2), _emptyAssignOrderBy);
|
return locationInfo;
|
}
|
|
public Dt_LocationInfo AssignLocation(string[] Stations)
|
{
|
Dt_LocationInfo? locationInfo = null;
|
var locationInfos = BaseDal.QueryData(x => Stations.Contains(x.LocationCode) && x.CurrentQty < x.MaxQty - 1, _emptyAssignOrderBy);
|
if (locationInfos != null && locationInfos.Count > 0)
|
locationInfo = locationInfos[0];
|
return locationInfo;
|
}
|
/// <summary>
|
/// 分配货位
|
/// </summary>
|
/// <param name="stockInfo">组盘信息</param>
|
/// <param name="inboundOrder">入库单</param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public Dt_LocationInfo AssignLocation(int inboundOrderCount)
|
{
|
string CarChargingStation = AppSettings.Configuration[nameof(CarChargingStation)];//获取穿梭车充电位置
|
var ChargingStations = CarChargingStation.Split(",");
|
Dt_LocationInfo? locationInfo = null;
|
var locationInfos = BaseDal.QueryData(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.CurrentQty < 1 && x.Row == (inboundOrderCount > 1 ? 1 : 3), _emptyAssignOrderBy);
|
if (locationInfos.Count > 1 && locationInfos != null) locationInfo = locationInfos[0];
|
|
if (locationInfo == null)
|
{
|
locationInfos = BaseDal.QueryData(x => !ChargingStations.Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.CurrentQty < 1), _emptyAssignOrderBy);
|
if (locationInfos.Count > 1 && locationInfos != null) locationInfo = locationInfos[0];//需预留一个货位移库
|
}
|
|
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, string position1)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
Dt_LocationInfo? locationInfo = null;
|
//Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && (x.Row == 1 || x.Row == 3), _emptyAssignOrderBy);
|
string position2 = string.Empty;
|
string[] Codes = position1.Split("-");
|
var row = Convert.ToInt16(Codes[0]);
|
if (row < 3)
|
{
|
position2 = row == 1 ? "002" + "-" + Codes[1] + "-" + Codes[2] : "001" + "-" + Codes[1] + "-" + Codes[2];
|
}
|
if (string.IsNullOrEmpty(position2))
|
{
|
locationInfo = BaseDal.QueryFirst(x => x.CurrentQty < x.MaxQty && x.LocationCode != position && x.LocationCode != position1, _emptyAssignOrderBy);
|
}
|
else
|
{
|
locationInfo = BaseDal.QueryFirst(x => x.CurrentQty < x.MaxQty && x.LocationCode != position && x.LocationCode != position1 && x.LocationCode != position2, _emptyAssignOrderBy);
|
}
|
if (locationInfo != null) content.OK(locationInfo.LocationCode);
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
/// <summary>
|
/// 获取货位信息
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public WebResponseContent GetLocationInfo(SaveModel model)
|
{
|
WebResponseContent response = new WebResponseContent();
|
try
|
{
|
List<Dt_LocationInfo> locationInfos = BaseDal.QueryData(x => true);
|
var Freelocations = locationInfos.Where(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt()).ToList();
|
var Palletlocations = locationInfos.Where(x => x.LocationStatus == LocationStatusEnum.Pallet.ObjToInt()).ToList();
|
var InStocklocations = locationInfos.Where(x => x.LocationStatus != LocationStatusEnum.Free.ObjToInt() && x.LocationStatus != LocationStatusEnum.Pallet.ObjToInt()).ToList();
|
//Dictionary<string, object> keyValuePairs = new Dictionary<string, object>();
|
//keyValuePairs.Add("空货位", Freelocations.Count);
|
//keyValuePairs.Add("空托盘", Palletlocations.Count);
|
//keyValuePairs.Add("有货", InStocklocations.Count);
|
response.OK(data: new
|
{
|
FreeQty = Freelocations.Count,
|
PalletQty = Palletlocations.Count,
|
InStockQty = InStocklocations.Count,
|
});
|
}
|
catch (Exception ex)
|
{
|
response.Error(ex.Message);
|
}
|
return response;
|
}
|
}
|
}
|
