using HslCommunication.WebSocket;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.Math;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Common.CommonEnum;
|
using WIDESEA_Common.LocationEnum;
|
using WIDESEA_Common.StockEnum;
|
using WIDESEA_Common.WareHouseEnum;
|
using WIDESEA_Core;
|
using WIDESEA_Core.BaseRepository;
|
using WIDESEA_Core.BaseServices;
|
using WIDESEA_Core.Const;
|
using WIDESEA_Core.DB;
|
using WIDESEA_Core.Enums;
|
using WIDESEA_Core.Helper;
|
using WIDESEA_Core.Seed;
|
using WIDESEA_Core.Utilities;
|
using WIDESEA_DTO.Basic;
|
using WIDESEA_IBasicService;
|
using WIDESEA_Model.Models;
|
|
namespace WIDESEA_BasicService
|
{
|
public partial class LocationInfoService : ServiceBase<Dt_LocationInfo, IRepository<Dt_LocationInfo>>, ILocationInfoService
|
{
|
private readonly IUnitOfWorkManage _unitOfWorkManage;
|
private readonly IRepository<Dt_StockInfo> _stockInfoRepository;
|
public IRepository<Dt_LocationInfo> Repository => BaseDal;
|
private readonly static object _locker = new object();
|
|
public static List<LocationCache> locationCaches = new List<LocationCache>();
|
|
public LocationInfoService(IRepository<Dt_LocationInfo> BaseDal, IUnitOfWorkManage unitOfWorkManage, IRepository<Dt_StockInfo> stockInfoRepository) : base(BaseDal)
|
{
|
_unitOfWorkManage = unitOfWorkManage;
|
_stockInfoRepository = stockInfoRepository;
|
}
|
|
/// <summary>
|
/// 批量启用货位
|
/// </summary>
|
/// <param name="keys">货位主键数组</param>
|
/// <returns></returns>
|
public WebResponseContent LocationEnableStatus(int[] keys)
|
{
|
List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => keys.Contains(x.Id));
|
locationInfos.ForEach(x =>
|
{
|
x.EnableStatus = EnableStatusEnum.Normal.ObjToInt();
|
});
|
Repository.UpdateData(locationInfos);
|
|
return WebResponseContent.Instance.OK();
|
}
|
|
/// <summary>
|
/// 批量禁用货位
|
/// </summary>
|
/// <param name="keys">货位主键数组</param>
|
/// <returns></returns>
|
public WebResponseContent LocationDisableStatus(int[] keys)
|
{
|
List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => keys.Contains(x.Id));
|
locationInfos.ForEach(x =>
|
{
|
x.EnableStatus = EnableStatusEnum.Disable.ObjToInt();
|
});
|
Repository.UpdateData(locationInfos);
|
|
return WebResponseContent.Instance.OK();
|
}
|
|
/// <summary>
|
/// 单个启用货位
|
/// </summary>
|
/// <param name="key">货位主键</param>
|
/// <returns></returns>
|
public WebResponseContent LocationEnableStatus(int key)
|
{
|
return LocationEnableStatus(new int[] { key });
|
}
|
|
/// <summary>
|
/// 单个禁用货位
|
/// </summary>
|
/// <param name="key">货位主键</param>
|
/// <returns></returns>
|
public WebResponseContent LocationDisableStatus(int key)
|
{
|
return LocationDisableStatus(new int[] { key });
|
}
|
|
/// <summary>
|
/// 初始化货位
|
/// </summary>
|
/// <param name="initializationLocationDTO"></param>
|
/// <returns></returns>
|
public WebResponseContent InitializationLocation(InitializationLocationDTO initializationLocationDTO)
|
{
|
try
|
{
|
(bool, string, object?) result = ModelValidate.ValidateModelData(initializationLocationDTO);
|
if (!result.Item1) return WebResponseContent.Instance.Error(result.Item2);
|
|
int depth = initializationLocationDTO.Depth;
|
List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>();
|
for (int i = 0; i < initializationLocationDTO.MaxRow; i++)
|
{
|
if ((i + 1) % initializationLocationDTO.MaxRow == 1)
|
{
|
depth = initializationLocationDTO.Depth;
|
}
|
else if ((i + 1) % initializationLocationDTO.MaxRow == initializationLocationDTO.Depth + 1)
|
{
|
depth = 1;
|
}
|
else if ((i + 1) % initializationLocationDTO.MaxRow > 1 && (i + 1) % initializationLocationDTO.MaxRow <= initializationLocationDTO.Depth)
|
{
|
depth -= 1;
|
}
|
else
|
{
|
depth += 1;
|
}
|
for (int j = 0; j < initializationLocationDTO.MaxColumn; j++)
|
{
|
for (int k = 0; k < initializationLocationDTO.MaxLayer; k++)
|
{
|
Dt_LocationInfo locationInfo = new Dt_LocationInfo()
|
{
|
WarehouseId = 0,
|
Column = j + 1,
|
EnableStatus = EnableStatusEnum.Normal.ObjToInt(),
|
Layer = k + 1,
|
LocationStatus = LocationStatusEnum.Free.ObjToInt(),
|
LocationType = LocationTypeEnum.Undefined.ObjToInt(),
|
RoadwayNo = $"{initializationLocationDTO.Roadway.ToString()}",
|
Row = i + 1,
|
Depth = depth,
|
};
|
locationInfo.LocationCode = $"{locationInfo.RoadwayNo}-{locationInfo.Row.ToString().PadLeft(3, '0')}-{locationInfo.Column.ToString().PadLeft(3, '0')}-{locationInfo.Layer.ToString().PadLeft(3, '0')}-{locationInfo.Depth.ToString().PadLeft(2, '0')}";
|
locationInfo.LocationName = $"{locationInfo.RoadwayNo}巷道{locationInfo.Row.ToString().PadLeft(3, '0')}行{locationInfo.Column.ToString().PadLeft(3, '0')}列{locationInfo.Layer.ToString().PadLeft(3, '0')}层{locationInfo.Depth.ToString().PadLeft(2, '0')}深";
|
locationInfos.Add(locationInfo);
|
}
|
}
|
}
|
BaseDal.AddData(locationInfos);
|
return WebResponseContent.Instance.OK();
|
}
|
catch (Exception ex)
|
{
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
|
public string AccessingTunnel(int WarehouseId, int LocationType, int taskCount)
|
{
|
List<Dt_LocationInfo> locationData = BaseDal.QueryData(x => x.WarehouseId == WarehouseId);
|
var roadwayGroups = locationData.Where(x => x.LocationType == LocationType && x.LocationStatus== (int)LocationStatusEnum.Free && x.EnableStatus== (int)EnableStatusEnum.Normal).GroupBy(x => x.RoadwayNo)
|
.Select(g => new
|
{
|
RoadwayNo = g.Key,
|
LocationCount = g.Count() - taskCount,
|
}).OrderByDescending(g => g.LocationCount).ToList();
|
|
int minRequired = 3;
|
if(WarehouseId== (int)WarehouseEnum.YMYL)
|
{
|
if (LocationType == 2) minRequired = 2;
|
|
var selectedRoadway = roadwayGroups.FirstOrDefault(g => g.LocationCount >= minRequired);
|
if(selectedRoadway!=null) return selectedRoadway.RoadwayNo;
|
|
}
|
else
|
{
|
var selectedRoadway = roadwayGroups.FirstOrDefault(g => g.LocationCount >= minRequired);
|
if(selectedRoadway == null)
|
{
|
selectedRoadway = roadwayGroups.FirstOrDefault(g => g.RoadwayNo == "5" && g.LocationCount != 0);
|
|
}
|
if(selectedRoadway != null) return selectedRoadway.RoadwayNo;
|
}
|
|
return "0";
|
}
|
|
|
public Dt_LocationInfo? ShallowGetLocation(string roadway, int Locationtype,int row ,int Layer, int Column)
|
{
|
return BaseDal.QueryData(x => x.RoadwayNo == roadway && x.LocationType == Locationtype && x.Row==row && x.Layer== Layer && x.Column== Column).FirstOrDefault();
|
}
|
|
public Dt_LocationInfo? FindStorageLocation(string LocationCode)
|
{
|
return BaseDal.QueryData(x => x.LocationCode == LocationCode).FirstOrDefault();
|
}
|
|
|
//查找新货位
|
public Dt_LocationInfo? GetLocation(string roadway, int Locationtype)
|
{
|
lock (_locker)
|
{
|
List<LocationCache> removeItems = locationCaches.Where(x => (DateTime.Now - x.DateTime).TotalMinutes > 5).ToList();//查询添加静态变量超过10分钟的货位
|
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 = null;
|
locationInfos = BaseDal.QueryData(x => x.RoadwayNo == roadway && x.LocationType == Locationtype && x.EnableStatus == (int)EnableStatusEnum.Normal);
|
|
|
List<Dt_LocationInfo> emptyLocations = locationInfos.Where(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && !lockLocations.Contains(x.LocationCode)).OrderBy(x => x.Layer).ThenBy(x => x.Column).ThenByDescending(x => x.Depth).ThenBy(x => x.Row).ToList();//查询空货位信息并排除20分钟内分配的货位,根据层、列、深度、行排序
|
|
|
for (int i = 0; i < emptyLocations.Count; i++)
|
{
|
if (emptyLocations[i].Depth == 1)//判断是否1深货位
|
{
|
//查询深库位
|
//int emprow = emptyLocations[i].Row == 2 ? 1 : 4;
|
int emprow = judgmentRow(emptyLocations[i].RoadwayNo,emptyLocations[i].Row);
|
|
Dt_LocationInfo? sencondDepthLocationShen = emptyLocations.FirstOrDefault(x => x.Row == emprow && x.Layer == emptyLocations[i].Layer && x.Column == emptyLocations[i].Column);
|
if (sencondDepthLocationShen != null && sencondDepthLocationShen.LocationStatus == LocationStatusEnum.Free.ObjToInt())
|
{
|
locationCaches.Add(new LocationCache { DateTime = DateTime.Now, LocationCode = sencondDepthLocationShen.LocationCode });
|
return sencondDepthLocationShen;//1深货位及2深货位都为空的情况下,优先分配2深货位
|
}
|
else
|
{
|
Dt_LocationInfo? sencondDepthLo = locationInfos.FirstOrDefault(x => x.Row == emprow && x.Layer == emptyLocations[i].Layer && x.Column == emptyLocations[i].Column);
|
if (sencondDepthLo != null && sencondDepthLo.LocationStatus != LocationStatusEnum.Lock.ObjToInt() && sencondDepthLo.LocationStatus == LocationStatusEnum.InStock.ObjToInt() && !lockLocations.Contains(sencondDepthLo.LocationCode))
|
{
|
locationCaches.Add(new LocationCache { DateTime = DateTime.Now, LocationCode = emptyLocations[i].LocationCode });
|
return emptyLocations[i];
|
}else if (emptyLocations[i].RoadwayNo=="5" && emptyLocations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
|
{
|
locationCaches.Add(new LocationCache { DateTime = DateTime.Now, LocationCode = emptyLocations[i].LocationCode });
|
return emptyLocations[i];
|
}
|
}
|
}
|
else
|
{
|
//查询2深货位对应的1深货位是否为空
|
//int emprow = emptyLocations[i].Row == 4 ? 3 : 2;
|
int emprow = judgmentRow(emptyLocations[i].RoadwayNo, emptyLocations[i].Row);
|
|
Dt_LocationInfo? sencondDepthLocationQian = emptyLocations.FirstOrDefault(x => x.Row == emprow && x.Layer == emptyLocations[i].Layer && x.Column == emptyLocations[i].Column);
|
if (sencondDepthLocationQian != null && sencondDepthLocationQian.LocationStatus == LocationStatusEnum.Free.ObjToInt())
|
{
|
locationCaches.Add(new LocationCache { DateTime = DateTime.Now, LocationCode = emptyLocations[i].LocationCode });
|
return emptyLocations[i];
|
}
|
}
|
}
|
return null;
|
}
|
}
|
|
public int judgmentRow(string RoadwayNo, int locrow)
|
{
|
if (RoadwayNo == "1" || RoadwayNo == "3")
|
{
|
if(locrow==1 || locrow == 4)
|
{
|
return locrow == 1 ? 2 : 3;
|
}
|
else
|
{
|
return locrow == 2 ? 1 : 4;
|
}
|
|
}
|
else if (RoadwayNo == "2" || RoadwayNo == "4")
|
{
|
if (locrow == 5 || locrow == 8)
|
{
|
return locrow == 5 ? 6 : 7;
|
}
|
else
|
{
|
return locrow == 6 ? 5 : 8;
|
}
|
|
}
|
else
|
{
|
return 0;
|
}
|
}
|
|
public class LocationCache
|
{
|
public string LocationCode { get; set; }
|
|
public DateTime DateTime { get; set; }
|
}
|
|
|
|
public WebResponseContent GetArea()
|
{
|
// WarehouseId分组，然后是RoadwayNo
|
var result = BaseDal.QueryData()
|
.GroupBy(x => x.WarehouseId)
|
.Select(g => new {
|
WarehouseId = g.Key,
|
RoadwayNo = g.Select(x => x.RoadwayNo).Distinct().ToList()
|
})
|
.ToList();
|
return WebResponseContent.Instance.OK("成功", result);
|
}
|
|
public WebResponseContent GetLocationStatus(int WarehouseId, string RoadwayNo)
|
{
|
// 格式{层,{这一层的列数据}}
|
var locations = BaseDal.QueryData(x => x.WarehouseId == WarehouseId && x.RoadwayNo == RoadwayNo)
|
.Select(x => new
|
{
|
x.RoadwayNo,
|
x.LocationCode,
|
x.WarehouseId,
|
x.Row,
|
x.Column,
|
x.Layer,
|
x.Depth,
|
x.LocationType,
|
x.LocationStatus,
|
x.EnableStatus
|
})
|
.ToList();
|
|
// 如果没有找到数据，返回空列表而不是null
|
if (locations == null || !locations.Any())
|
{
|
return WebResponseContent.Instance.OK("未找到对应巷道的货位数据", new List<object>());
|
}
|
|
// 修改为层下面放所有列的信息
|
var result = locations
|
.GroupBy(x => x.Layer) // 按层分组
|
.Select(layerGroup => new
|
{
|
layer = layerGroup.Key,
|
columns = layerGroup.GroupBy(x => x.Column) // 每层中按列分组
|
.Select(columnGroup => new
|
{
|
column = columnGroup.Key,
|
depths = columnGroup.Select(d => new
|
{
|
row = d.Row,
|
LocationCode = d.LocationCode,
|
depth = d.Depth,
|
locationType = d.LocationType,
|
locationStatus = d.LocationStatus,
|
enableStatus = d.EnableStatus
|
}).ToList()
|
}).ToList()
|
}).ToList();
|
|
return WebResponseContent.Instance.OK("成功", result);
|
}
|
// 继续分，WarehouseId =1，有两个不同的货物，LocationType =1和2
|
public WebResponseContent GetWarehouseCapacity()
|
{
|
// 查询所有仓库的货位数据，包含货位类型
|
var allLocations = BaseDal.QueryData()
|
.Select(x => new
|
{
|
x.WarehouseId,
|
x.LocationStatus,
|
x.LocationType // 添加货位类型
|
})
|
.ToList();
|
|
// 如果没有数据，返回空列表
|
if (allLocations == null || !allLocations.Any())
|
{
|
return WebResponseContent.Instance.OK("未找到任何货位数据", new List<object>());
|
}
|
|
// 按仓库和货位类型分组统计
|
var result = allLocations
|
.GroupBy(x => new { x.WarehouseId, x.LocationType })
|
.Select(g => new
|
{
|
WarehouseId = g.Key.WarehouseId,
|
LocationType = g.Key.LocationType,
|
TotalLocations = g.Count(),
|
FreeLocations = g.Count(x => x.LocationStatus == 0),
|
UsedLocations = g.Count(x => x.LocationStatus == 1),
|
OccupancyRate = (int)Math.Round((double)g.Count(x => x.LocationStatus == 1) / g.Count() * 100),
|
RemainingCapacityPercentage = (int)Math.Round((double)g.Count(x => x.LocationStatus == 0) / g.Count() * 100)
|
})
|
.OrderBy(x => x.WarehouseId)
|
.ThenBy(x => x.LocationType)
|
.ToList();
|
|
return WebResponseContent.Instance.OK("成功", result);
|
}
|
|
/// <summary>
|
/// 一键启用巷道所有货位
|
/// </summary>
|
/// <param name="warehouseId">仓库ID</param>
|
/// <param name="roadwayNo">巷道编号</param>
|
/// <returns></returns>
|
public WebResponseContent EnableAllLocationsInRoadway(string roadwayNo)
|
{
|
if (string.IsNullOrEmpty(roadwayNo))
|
return WebResponseContent.Instance.Error("巷道编号不能为空");
|
|
var locations = Repository.QueryData(x =>
|
x.RoadwayNo == roadwayNo &&
|
x.EnableStatus != EnableStatusEnum.Normal.ObjToInt());
|
|
if (locations == null || locations.Count == 0)
|
return WebResponseContent.Instance.OK("该巷道没有需要启用的货位");
|
|
locations.ForEach(x => x.EnableStatus = EnableStatusEnum.Normal.ObjToInt());
|
Repository.UpdateData(locations);
|
|
return WebResponseContent.Instance.OK($"成功启用巷道[{roadwayNo}]的{locations.Count}个货位");
|
}
|
|
/// <summary>
|
/// 一键禁用巷道所有货位
|
/// </summary>
|
/// <param name="warehouseId">仓库ID</param>
|
/// <param name="roadwayNo">巷道编号</param>
|
/// <returns></returns>
|
public WebResponseContent DisableAllLocationsInRoadway(string roadwayNo)
|
{
|
if (string.IsNullOrEmpty(roadwayNo))
|
return WebResponseContent.Instance.Error("巷道编号不能为空");
|
var locations = Repository.QueryData(x =>
|
x.RoadwayNo == roadwayNo &&
|
x.EnableStatus != EnableStatusEnum.Disable.ObjToInt());
|
if (locations == null || locations.Count == 0)
|
return WebResponseContent.Instance.OK("该巷道没有需要禁用的货位");
|
// 检查货位是否有库存
|
var locationIds = locations.Select(x => x.Id).ToList();
|
locations.ForEach(x => x.EnableStatus = EnableStatusEnum.Disable.ObjToInt());
|
Repository.UpdateData(locations);
|
return WebResponseContent.Instance.OK($"成功禁用巷道[{roadwayNo}]的{locations.Count}个货位");
|
}
|
}
|
}
|
