using HslCommunication.WebSocket;
|
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_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_DTO.Location;
|
using WIDESEA_IBasicService;
|
using WIDESEA_Model.Models;
|
using WIDESEA_Model.Models.Stock;
|
|
namespace WIDESEA_BasicService
|
{
|
public partial class LocationInfoService : ServiceBase<Dt_LocationInfo, IRepository<Dt_LocationInfo>>, ILocationInfoService
|
{
|
private readonly IRepository<Sys_User> _userRepository;
|
private readonly IUnitOfWorkManage _unitOfWorkManage;
|
public IRepository<Dt_LocationInfo> Repository => BaseDal;
|
|
public LocationInfoService(IRepository<Dt_LocationInfo> BaseDal, IUnitOfWorkManage unitOfWorkManage, IRepository<Sys_User> userRepository) : base(BaseDal)
|
{
|
_unitOfWorkManage = unitOfWorkManage;
|
_userRepository = userRepository;
|
}
|
|
/// <summary>
|
/// 获取用户列表（注入使用示例）
|
/// </summary>
|
/// <returns></returns>
|
public List<Sys_User> GetUsers()
|
{
|
return _userRepository.QueryData();
|
}
|
|
/// <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);
|
|
List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>();
|
for (int i = 0; i < initializationLocationDTO.MaxRow; i++)
|
{
|
for (int j = 0; j < initializationLocationDTO.MaxColumn; j++)
|
{
|
for (int k = 0; k < initializationLocationDTO.MaxLayer; k++)
|
{
|
Dt_LocationInfo locationInfo = new Dt_LocationInfo()
|
{
|
Column = j + 1,
|
EnableStatus = EnableStatusEnum.Normal.ObjToInt(),
|
Layer = k + 1,
|
LocationStatus = LocationStatusEnum.Free.ObjToInt(),
|
RoadwayNo = $"{initializationLocationDTO.Roadway.ToString()}",
|
Row = i + 1,
|
};
|
locationInfo.LocationCode = $"{locationInfo.RoadwayNo}-{locationInfo.Row.ToString().PadLeft(3, '0')}-{locationInfo.Column.ToString().PadLeft(3, '0')}-{locationInfo.Layer.ToString().PadLeft(3, '0')}";
|
locationInfo.LocationName = $"{locationInfo.RoadwayNo}巷道{locationInfo.Row.ToString().PadLeft(3, '0')}行{locationInfo.Column.ToString().PadLeft(3, '0')}列{locationInfo.Layer.ToString().PadLeft(3, '0')}层";
|
locationInfos.Add(locationInfo);
|
}
|
}
|
}
|
BaseDal.AddData(locationInfos);
|
return WebResponseContent.Instance.OK();
|
}
|
catch (Exception ex)
|
{
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
//入库分配货位
|
public Dt_LocationInfo AllotLocationInfo(int k)
|
{
|
Dt_LocationInfo locationInfo = new Dt_LocationInfo();
|
//空桶分配
|
if (k == 1)
|
{
|
locationInfo = BaseDal.QueryData(x => x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationStatus == (int)LocationStatusEnum.Free).OrderBy(x => x.Column).OrderBy(x => x.Layer).First();
|
}
|
//食品区分配
|
else if(k == 2)
|
{
|
locationInfo = BaseDal.QueryData(x => x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationStatus == (int)LocationStatusEnum.Free && x.LocationType == (int)LocationTypeEnum.Food).OrderBy(x=>x.Column).OrderBy(x => x.Layer).First();
|
}
|
//工业区分配
|
else if(k == 3){
|
locationInfo = BaseDal.QueryData(x => x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationStatus == (int)LocationStatusEnum.Free && x.LocationType == (int)LocationTypeEnum.Industry).OrderBy(x=>x.Column).OrderBy(x => x.Layer).First();
|
}
|
return locationInfo;
|
}
|
|
//出库分配物料
|
//1:空桶，2：满桶
|
public Dt_LocationInfo AllotStock(int k)
|
{
|
Dt_LocationInfo locationInfo = new Dt_LocationInfo();
|
if (k == 1)
|
{
|
locationInfo = BaseDal.QueryFirst(x => x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationStatus == (int)LocationStatusEnum.EmptyBarrel);
|
}
|
else if(k == 2)
|
{
|
|
}
|
return locationInfo;
|
}
|
|
//根据多条物料查询对应的货位并修改为锁定
|
public List<Dt_LocationInfo> StockLockLocation(List<Dt_StockInfo> StockInfo)
|
{
|
List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>();
|
int k = StockInfo.Count() - 1;
|
for(int i = 0; i <= k; i++)
|
{
|
Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationCode == StockInfo[i].LocationCode);
|
locationInfo.LocationStatus = (int)LocationStatusEnum.Lock;
|
locationInfos.Add(locationInfo);
|
}
|
return locationInfos;
|
}
|
|
//前端页面图片显示
|
public List<Dt_LocationInfo> getLocation()
|
{
|
List<Dt_LocationInfo> LocationInfo = BaseDal.QueryData(x => true);
|
return LocationInfo;
|
}
|
|
//修改库位类型
|
public WebResponseContent UpdateLocationType(int k)
|
{
|
WebResponseContent content = new WebResponseContent();
|
List<Dt_LocationInfo> location = BaseDal.QueryData(x => x.Column == k);
|
int s = 0;
|
if (location[0].LocationType == (int)LocationTypeEnum.Food)
|
{
|
s = (int)LocationTypeEnum.Industry;
|
}
|
else if(location[0].LocationType == (int)LocationTypeEnum.Industry)
|
{
|
s = (int)LocationTypeEnum.Food;
|
}
|
|
location.ForEach(x => x.LocationType = s);
|
content.OK(s.ToString());
|
BaseDal.UpdateData(location);
|
return content;
|
}
|
|
public Location LocationNum()
|
{
|
Location location = new Location();
|
|
List<Dt_LocationInfo> LocationInfo1 = BaseDal.QueryData(x => x.LocationStatus == (int)LocationStatusEnum.Free);
|
List<Dt_LocationInfo> LocationInfo2 = BaseDal.QueryData(x => x.LocationStatus == (int)LocationStatusEnum.InStock);
|
List<Dt_LocationInfo> LocationInfo3 = BaseDal.QueryData(x => x.LocationStatus == (int)LocationStatusEnum.EmptyBarrel);
|
|
location.Vacancy = LocationInfo1.Count();
|
location.Available = LocationInfo2.Count();
|
location.Empty = LocationInfo3.Count();
|
return location;
|
}
|
}
|
}
|
