using Admin.NET.Core.Helper.ExcelHelper;
|
using Furion.DatabaseAccessor;
|
using Furion.DatabaseAccessor.Extensions;
|
using Furion.DependencyInjection;
|
using Furion.DynamicApiController;
|
using Furion.FriendlyException;
|
using iWare.Wms.Core;
|
using Mapster;
|
using Microsoft.AspNetCore.Authorization;
|
using Microsoft.AspNetCore.Mvc;
|
using Microsoft.AspNetCore.Mvc.ModelBinding.Validation;
|
using Microsoft.EntityFrameworkCore;
|
using Minio.DataModel;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
|
using System.Linq.Dynamic.Core;
|
|
namespace iWare.Wms.Application
|
{
|
/// <summary>
|
/// 托盘信息
|
/// </summary>
|
[ApiDescriptionSettings("基础信息", Name = "WmsContainer", Order = 100)]
|
[Route("api/[Controller]")]
|
public class WmsContainerService : ControllerBase, IWmsContainerService, IDynamicApiController, ITransient
|
{
|
private readonly IRepository<WmsContainer,MasterDbContextLocator> _wmsContainerRep;
|
private readonly IRepository<WmsContainerType, MasterDbContextLocator> _wmsContainerType;
|
private readonly IRepository<WmsMaterial, MasterDbContextLocator> _wmsMaterial;
|
private readonly IRepository<WareContainerVsMaterial, MasterDbContextLocator> _wareContainerVsMaterial;
|
private readonly IRepository<WareLocationVsContainer, MasterDbContextLocator> _wareLocationVsContainer;
|
private readonly IRepository<WmsPart, MasterDbContextLocator> _wmsPart;
|
public WmsContainerService(
|
IRepository<WmsContainer,MasterDbContextLocator> wmsContainerRep,
|
IRepository<WmsContainerType, MasterDbContextLocator> wmsContainerType,
|
IRepository<WmsMaterial, MasterDbContextLocator> wmsMaterial,
|
IRepository<WareContainerVsMaterial, MasterDbContextLocator> wareContainerVsMaterial,
|
IRepository<WareLocationVsContainer, MasterDbContextLocator> wareLocationVsContainer,
|
IRepository<WmsPart, MasterDbContextLocator> wmsPart
|
)
|
{
|
_wmsContainerRep = wmsContainerRep;
|
_wmsContainerType = wmsContainerType;
|
_wmsMaterial = wmsMaterial;
|
_wareContainerVsMaterial = wareContainerVsMaterial;
|
_wareLocationVsContainer = wareLocationVsContainer;
|
_wmsPart = wmsPart;
|
}
|
|
/// <summary>
|
/// 分页查询托盘信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("page")]
|
public async Task<PageResult<WmsContainerOutput>> Page([FromQuery] WmsContainerSearch input)
|
{
|
var wmsContainers = await _wmsContainerRep.DetachedEntities
|
.Where(!string.IsNullOrEmpty(input.Containercode), u => EF.Functions.Like(u.ContainerCode, $"%{input.Containercode.Trim()}%"))
|
.Where(input.ContainerTypeCode != null, u => u.ContainerTypeCode == input.ContainerTypeCode)
|
.Where(input.Containerstatus != null, u => u.ContainerStatus == input.Containerstatus)
|
//.OrderBy(PageInputOrder.OrderBuilder<WmsContainerSearch>(input))
|
.OrderBy(u => u.ContainerCode)
|
|
.ProjectToType<WmsContainerOutput>()
|
|
.ToADPagedListAsync(input.PageNo, input.PageSize);
|
|
return wmsContainers;
|
}
|
|
/// <summary>
|
/// 增加托盘信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("add")]
|
public async Task Add([FromBody] AddWmsContainerInput input)
|
{
|
List<WmsMaterial> wmsMaterials = new List<WmsMaterial>();
|
|
if (input.RealLocationCode == "0")
|
{
|
input.RealLocationCode = "";
|
}
|
|
var isExit = await _wmsContainerRep.AnyAsync(n => n.ContainerCode == input.Containercode);
|
if (isExit) throw Oops.Oh("存在的相同的小车编号！");
|
|
//查找托盘类型
|
var containerType = await _wmsContainerType.DetachedEntities.Where(u => u.WareContainerTypeCode == input.ContainerTypeCode).FirstOrDefaultAsync();
|
if (containerType == null)
|
{
|
throw Oops.Oh("托盘类型不存在");
|
}
|
input.Speclength = containerType.Length;
|
input.Specheight = containerType.Height;
|
input.Specwidth = containerType.Width;
|
|
WareContainerVsMaterial cvm = null;
|
if (!string.IsNullOrEmpty(input.MaterialCode) && input.MaterialCode != "0")
|
{
|
var material = await _wmsMaterial.DetachedEntities.Where(u => u.MaterialNo == input.MaterialCode).FirstOrDefaultAsync();
|
if (material == null)
|
{
|
throw Oops.Oh("端拾器基础信息不存在");
|
//material = new WmsMaterial()
|
//{
|
// MaterialNo = input.Containercode,
|
// MaterialName = input.Containercode,
|
// Length = input.Speclength,
|
// Width = input.Specwidth,
|
// Height = input.Specheight,
|
// Remark = "根据小车自动创建"
|
//};
|
//wmsMaterials.Add(material);
|
}
|
else
|
{
|
var cvmExist = await _wareContainerVsMaterial.DetachedEntities.AnyAsync(u => u.WareMaterialCode == material.MaterialNo);
|
if (cvmExist)
|
{
|
throw Oops.Oh("该端拾器已经绑定小车");
|
}
|
}
|
cvm = new WareContainerVsMaterial()
|
{
|
OrdersNo = Yitter.IdGenerator.YitIdHelper.NextId().ToString(),
|
WareContainerCode = input.Containercode,
|
WareMaterialName = material.MaterialName,
|
WareMaterialCode = material.MaterialNo,
|
Quantity = 1,
|
Status = 0,
|
Remarks = "新增小车组盘",
|
StockStatus = StockStatusEnum.新建,
|
};
|
}
|
else
|
{
|
var material = await _wmsMaterial.DetachedEntities.Where(u => u.MaterialNo == input.Containercode).FirstOrDefaultAsync();
|
if (material == null)
|
{
|
//throw Oops.Oh("端拾器基础信息不存在");
|
material = new WmsMaterial()
|
{
|
MaterialNo = input.Containercode,
|
MaterialName = input.Containercode,
|
Length = input.Speclength,
|
Width = input.Specwidth,
|
Height = input.Specheight,
|
Remark = "根据小车自动创建"
|
};
|
wmsMaterials.Add(material);
|
}
|
var cvmExist = await _wareContainerVsMaterial.DetachedEntities.AnyAsync(u => u.WareContainerCode == input.Containercode);
|
if (!cvmExist)
|
{
|
cvm = new WareContainerVsMaterial()
|
{
|
OrdersNo = Yitter.IdGenerator.YitIdHelper.NextId().ToString(),
|
WareContainerCode = input.Containercode,
|
WareMaterialName = material.MaterialName,
|
WareMaterialCode = material.MaterialNo,
|
Quantity = 1,
|
Status = 0,
|
Remarks = "新增小车组盘",
|
StockStatus = StockStatusEnum.新建,
|
};
|
}
|
}
|
|
var wmsContainer = input.Adapt<WmsContainer>();
|
wmsContainer.ContainerStatus = Core.Enum.ContainerStatus.KOUXIAN;
|
|
using (var tran = await _wmsContainerRep.Database.BeginTransactionAsync())
|
{
|
try
|
{
|
await _wmsContainerRep.InsertAsync(wmsContainer);
|
if (cvm != null)
|
{
|
await _wareContainerVsMaterial.InsertAsync(cvm);
|
}
|
if (wmsMaterials != null && wmsMaterials.Count > 0)
|
{
|
await _wmsMaterial.InsertAsync(wmsMaterials);
|
}
|
await tran.CommitAsync();
|
}
|
catch
|
{
|
await tran.RollbackAsync();
|
}
|
}
|
|
}
|
|
/// <summary>
|
/// 删除托盘信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("delete")]
|
public async Task Delete([FromBody] DeleteWmsContainerInput input)
|
{
|
var wmsContainer = await _wmsContainerRep.FirstOrDefaultAsync(u => u.Id == input.Id);
|
if(wmsContainer.ContainerStatus!=Core.Enum.ContainerStatus.KOUXIAN) throw Oops.Oh("托盘被使用不可删除");
|
var isexist = await _wareLocationVsContainer.DetachedEntities.AnyAsync(u => u.WareContainerCode == wmsContainer.ContainerCode);
|
if (isexist)
|
{
|
throw Oops.Oh("托盘被使用不可删除");
|
}
|
isexist = await _wmsPart.DetachedEntities.AnyAsync(u => u.MaterialCode == wmsContainer.ContainerCode);
|
if (isexist)
|
{
|
throw Oops.Oh("托盘被使用不可删除");
|
}
|
var cvm = await _wareContainerVsMaterial.Where(u => u.WareMaterialCode == wmsContainer.ContainerCode).FirstOrDefaultAsync();
|
if (cvm != null)
|
{
|
await _wareContainerVsMaterial.DeleteAsync(cvm);
|
}
|
var material = await _wmsMaterial.Where(u => u.MaterialNo == wmsContainer.ContainerCode).FirstOrDefaultAsync();
|
if (material != null)
|
{
|
await _wmsMaterial.DeleteAsync(material);
|
}
|
await _wmsContainerRep.DeleteAsync(wmsContainer);
|
}
|
|
/// <summary>
|
/// 更新托盘信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("edit")]
|
public async Task Update([FromBody] UpdateWmsContainerInput input)
|
{
|
var isExist = await _wmsContainerRep.AnyAsync(u => u.Id == input.Id, false);
|
if (!isExist) throw Oops.Oh(ErrorCode.D3000);
|
|
//查找托盘类型
|
var containerType = await _wmsContainerType.Where(u => u.WareContainerTypeCode == input.ContainerTypeCode).FirstOrDefaultAsync();
|
if (containerType == null)
|
{
|
throw Oops.Oh("托盘类型不存在");
|
}
|
input.Speclength = containerType.Length;
|
input.Specheight = containerType.Height;
|
input.Specwidth = containerType.Width;
|
|
var material = await _wmsMaterial.Where(u => u.MaterialNo == input.Containercode).FirstOrDefaultAsync();
|
if(material != null)
|
{
|
material.Length = input.Speclength;
|
material.Width = input.Specwidth;
|
material.Height = input.Specheight;
|
}
|
|
var wmsContainer = input.Adapt<WmsContainer>();
|
await _wmsContainerRep.UpdateAsync(wmsContainer,ignoreNullValues:true);
|
if (material != null)
|
{
|
await _wmsMaterial.UpdateAsync(material);
|
}
|
}
|
|
/// <summary>
|
/// 获取托盘信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("detail")]
|
public async Task<WmsContainerOutput> Get([FromQuery] QueryeWmsContainerInput input)
|
{
|
return (await _wmsContainerRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<WmsContainerOutput>();
|
}
|
|
/// <summary>
|
/// 获取托盘信息列表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("list")]
|
public async Task<dynamic> List([FromQuery] WmsContainerInput input)
|
{
|
var cvms = await _wareContainerVsMaterial.DetachedEntities.AsQueryable().Select(u => u.WareContainerCode).Distinct().ToListAsync();
|
|
return await _wmsContainerRep.DetachedEntities.Where(u => !cvms.Contains(u.ContainerCode)).Select(u => new { code = u.ContainerCode}).ToListAsync();
|
}
|
|
|
/// <summary>
|
/// 获取端拾器列表
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet("fkWmsContainer")]
|
public async Task<dynamic> FkWmsContainerList()
|
{
|
var list = await _wmsContainerRep.DetachedEntities.ToListAsync();
|
return list.Select(e => new { Code = e.ContainerCode});
|
}
|
|
/// <summary>
|
/// 获取端拾器列表
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost("jblocation")]
|
public async Task<int> JBLocation([FromBody] UpdateWmsContainerInput input)
|
{
|
var isExist = await _wmsContainerRep.Where(u => u.Id == input.Id).FirstOrDefaultAsync();
|
if (isExist == null) throw Oops.Oh(ErrorCode.D3000);
|
isExist.RealLocationCode = "";
|
await _wmsContainerRep.UpdateAsync(isExist);
|
|
return 1;
|
}
|
|
/// <summary>
|
/// 导出Excel
|
/// </summary>
|
/// <param name="input">筛选条件</param>
|
/// <returns></returns>
|
[HttpPost("download")]
|
[AllowAnonymous]
|
public async Task<ActionResult> Download([FromBody] WmsContainerSearch input)
|
{
|
var dataRecords = await _wmsContainerRep.DetachedEntities
|
.Where(!string.IsNullOrEmpty(input.Containercode), u => EF.Functions.Like(u.ContainerCode, $"%{input.Containercode.Trim()}%"))
|
.Where(input.ContainerTypeCode != null, u => u.ContainerTypeCode == input.ContainerTypeCode)
|
.Where(input.Containerstatus != null, u => u.ContainerStatus == input.Containerstatus)
|
//.OrderBy(PageInputOrder.OrderBuilder<WmsContainerSearch>(input))
|
.OrderBy(u => u.ContainerCode)
|
.ProjectToType<WmsContainerExcel>().ToListAsync();
|
|
var excelBaseResult = new Excel2003Result<WmsContainerExcel>(dataRecords, "小车信息" + DateTime.Now.ToString("yyyyMMdd"), false, "生产记录");
|
return File(excelBaseResult.GetExcelStream(), "application/vnd.ms-excel");
|
}
|
}
|
}
|
