using AutoMapper;
|
using MailKit.Search;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Common.StockEnum;
|
using WIDESEA_Core;
|
using WIDESEA_Core.BaseRepository;
|
using WIDESEA_Core.BaseServices;
|
using WIDESEA_Core.Enums;
|
using WIDESEA_Core.Helper;
|
using WIDESEA_DTO.Basic;
|
using WIDESEA_DTO.Stock;
|
using WIDESEA_IBasicRepository;
|
using WIDESEA_IRecordRepository;
|
using WIDESEA_IRecordService;
|
using WIDESEA_IStockRepository;
|
using WIDESEA_IStockService;
|
using WIDESEA_Model.Models;
|
using WIDESEA_StockRepository;
|
|
namespace WIDESEA_StockService
|
{
|
public partial class StockInfoService : ServiceBase<Dt_StockInfo, IStockInfoRepository>, IStockInfoService
|
{
|
private readonly IMapper _mapper;
|
private readonly IBasicRepository _basicRepository;
|
private readonly IUnitOfWorkManage _unitOfWorkManage;
|
public IStockInfoRepository Repository => BaseDal;
|
|
public StockInfoService(IStockInfoRepository BaseDal, IMapper mapper, IBasicRepository basicRepository, IUnitOfWorkManage unitOfWorkManage) : base(BaseDal)
|
{
|
_mapper = mapper;
|
_basicRepository = basicRepository;
|
_unitOfWorkManage = unitOfWorkManage;
|
}
|
|
|
|
|
public WebResponseContent StockQueryData(SaveModel saveModel)
|
{
|
try
|
{
|
var barcode = saveModel.MainData["barcode"].ToString();
|
var warehouseId = saveModel.MainData["warehouseId"].ObjToInt();
|
Dt_StockInfo stockInfo = BaseDal.Db.Queryable<Dt_StockInfo>().Where(x => x.PalletCode == barcode && x.WarehouseId == warehouseId).First();
|
if (stockInfo == null) throw new Exception("未找到托盘信息");
|
return WebResponseContent.Instance.OK(data: stockInfo);
|
}
|
catch (Exception ex)
|
{
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
public WebResponseContent ManualMaterielGroup(SaveModel saveModel)
|
{
|
WebResponseContent content=new WebResponseContent();
|
try
|
{
|
var barcode = saveModel.MainData["palletCode"].ToString();
|
var warehouseId = saveModel.MainData["warehouseId"].ObjToInt();
|
var materSn = saveModel.MainData["materSn"];
|
//直径
|
var thickness = saveModel.MainData["thickness"].ObjToInt();
|
var weight = saveModel.MainData["weight"].ObjToInt();
|
//幅宽
|
var wide = saveModel.MainData["wide"].ObjToInt();
|
Dt_MaterielInfo? materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x => x.MaterielCode == materSn);
|
if (materielInfo==null)
|
{
|
return content.Error("未找到物料信息");
|
}
|
Dt_StockInfo stockInfoOld = BaseDal.QueryFirst(x=>x.PalletCode== barcode);
|
if (stockInfoOld != null)
|
{
|
return content.Error("托盘信息已存在");
|
}
|
//生成库存组盘信息
|
Dt_StockInfo stockInfo = new Dt_StockInfo()
|
{
|
MaterielInvOrgId=materielInfo.MaterielInvOrgId,
|
PalletCode= barcode,
|
LocationCode="",
|
PalletType = 1,
|
WarehouseId=warehouseId,
|
StockAttribute= materielInfo.MaterielSourceType,
|
StockStatus= StockStatusEmun.手动组盘暂存.ObjToInt(),
|
MaterielSpec=materielInfo.MaterielSpec,
|
Unit=materielInfo.MaterielUnit,
|
MaterielThickness=thickness,
|
MaterielWide=wide,
|
MaterielWeight=weight,
|
MaterielCode = materielInfo.MaterielCode,
|
MaterielName=materielInfo.MaterielName,
|
};
|
if (wide>1200)
|
{
|
stockInfo.PalletType = 2;
|
}
|
BaseDal.AddData(stockInfo);
|
content.OK("组盘成功");
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
|
public List<Dt_StockInfo> GetUseableStocks(int materielId,decimal width, int warehoseId)
|
{
|
List<string> locationCodes = _basicRepository.LocationInfoRepository.GetCanOutLocationCodes(warehoseId);
|
|
return BaseDal.GetStockInfos(materielId,width, locationCodes);
|
}
|
|
/// <summary>
|
/// 分配实际库存
|
/// </summary>
|
/// <returns></returns>
|
public List<Dt_StockInfo> GetOutboundStocks(List<Dt_StockInfo> stockInfos, decimal needQuantity)
|
{
|
List<Dt_StockInfo> outStocks = new List<Dt_StockInfo>();
|
//获取库存可用数量
|
decimal stockTotalQuantity = stockInfos.Sum(x => x.StockLength-x.StockOutLength);
|
if (stockTotalQuantity >= needQuantity)//库存够
|
{
|
int index = 0;
|
while (needQuantity > 0)
|
{
|
Dt_StockInfo stockInfo = stockInfos[index];
|
decimal useableStockQuantity = stockInfo.StockLength-stockInfo.StockOutLength;
|
if (useableStockQuantity < needQuantity && useableStockQuantity > 0)
|
{
|
stockInfo.StockOutLength=stockInfo.StockLength;
|
needQuantity -= useableStockQuantity;
|
}
|
else
|
{
|
stockInfo.StockOutLength += needQuantity;
|
needQuantity = 0;
|
}
|
outStocks.Add(stockInfo);
|
index++;
|
}
|
}
|
else
|
{
|
throw new Exception("库存不足");
|
}
|
return outStocks;
|
}
|
}
|
}
|
