using Furion.DatabaseAccessor;
|
using Furion.DependencyInjection;
|
using Furion.DynamicApiController;
|
using Furion.FriendlyException;
|
using Mapster;
|
using Microsoft.AspNetCore.Mvc;
|
using Microsoft.EntityFrameworkCore;
|
using System.Linq.Dynamic.Core;
|
using Admin.NET.Core;
|
|
namespace Admin.NET.Application
|
{
|
/// <summary>
|
/// 库存信息服务
|
/// </summary>
|
[ApiDescriptionSettings("仓库作业", Name = "WmsMaterialStock", Order = 106)]
|
[Route("api/[Controller]")]
|
public class MaterialStockService : IDynamicApiController, ITransient
|
{
|
private readonly IRepository<WmsMaterialStock, MasterDbContextLocator> _wmsMaterialStockRep;
|
private readonly IRepository<WmsArea> _wmsAreaRep;
|
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
public MaterialStockService(
|
IRepository<WmsArea> wmsAreaRep,
|
IRepository<WmsMaterialStock, MasterDbContextLocator> wmsMaterialStockRep
|
)
|
{
|
_wmsAreaRep = wmsAreaRep;
|
_wmsMaterialStockRep = wmsMaterialStockRep;
|
}
|
|
/// <summary>
|
/// 分页查询库存表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("page")]
|
public async Task<PageResult<MaterialStockOutput>> Page([FromQuery] WmsMaterialStockSearch input)
|
{
|
var wmsMaterialStocks = await _wmsMaterialStockRep.DetachedEntities
|
.Where(!string.IsNullOrEmpty(input.MaterialNo), u => EF.Functions.Like(u.MaterialNo, $"%{input.MaterialNo.Trim()}%"))
|
.Where(input.MaterialType != null, u => u.MaterialType == input.MaterialType)
|
.Where(!string.IsNullOrEmpty(input.MaterialBatch), u => EF.Functions.Like(u.MaterialBatch, $"%{input.MaterialBatch.Trim()}%"))
|
.Where(!string.IsNullOrEmpty(input.MaterialName), u => EF.Functions.Like(u.MaterialName, $"%{input.MaterialName.Trim()}%"))
|
.Where(!string.IsNullOrEmpty(input.MaterialSpec), u => EF.Functions.Like(u.MaterialSpec, $"%{input.MaterialSpec.Trim()}%"))
|
.Where(!string.IsNullOrEmpty(input.MaterialDensity), u => EF.Functions.Like(u.MaterialDensity, $"%{input.MaterialDensity.Trim()}%"))
|
.Where(u => u.StockNumber != 0)
|
.Where(!string.IsNullOrEmpty(input.PlaceCode), u => EF.Functions.Like(u.PlaceCode, $"%{input.PlaceCode.Trim()}%"))
|
.Where(!string.IsNullOrEmpty(input.ContainerCode), u => EF.Functions.Like(u.ContainerCode, $"%{input.ContainerCode.Trim()}%"))
|
.Where(input.AreaId > 0, u => u.AreaId == input.AreaId)
|
.Where(input.SearchBeginTime != null && input.SearchEndTime != null, u => u.CreatedTime >= DateTime.Parse(input.SearchBeginTime.Trim()) &&
|
u.CreatedTime <= DateTime.Parse(input.SearchEndTime.Trim()))
|
.OrderBy(PageInputOrder.OrderBuilder<WmsMaterialStockSearch>(input))
|
.ProjectToType<MaterialStockOutput>()
|
.ToADPagedListAsync(input.PageNo, input.PageSize);
|
//根据id获取名称
|
foreach (var item in wmsMaterialStocks.Rows)
|
{
|
//根据库区id获取库区名称
|
var data = await _wmsAreaRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == item.AreaId);
|
if (data != null) item.AreaName = data.AreaName;
|
}
|
return wmsMaterialStocks;
|
}
|
|
/// <summary>
|
/// 增加库存表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("add")]
|
public async Task Add(AddMaterialStockInput input)
|
{
|
var wmsMaterialStock = input.Adapt<WmsMaterialStock>();
|
await _wmsMaterialStockRep.InsertAsync(wmsMaterialStock);
|
}
|
|
/// <summary>
|
/// 删除库存表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("delete")]
|
public async Task Delete(DeleteMaterialStockInput input)
|
{
|
var wmsMaterialStock = await _wmsMaterialStockRep.FirstOrDefaultAsync(u => u.Id == input.Id);
|
await _wmsMaterialStockRep.DeleteAsync(wmsMaterialStock);
|
}
|
|
/// <summary>
|
/// 更新库存表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("edit")]
|
public async Task Update(UpdateMaterialStockInput input)
|
{
|
var isExist = await _wmsMaterialStockRep.AnyAsync(u => u.Id == input.Id, false);
|
if (!isExist) throw Oops.Oh(ErrorCode.D3000);
|
|
var wmsMaterialStock = input.Adapt<WmsMaterialStock>();
|
await _wmsMaterialStockRep.UpdateAsync(wmsMaterialStock, ignoreNullValues: true);
|
}
|
|
/// <summary>
|
/// 获取库存表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("detail")]
|
public async Task<MaterialStockOutput> Get([FromQuery] QueryeMaterialStockInput input)
|
{
|
return (await _wmsMaterialStockRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<MaterialStockOutput>();
|
}
|
|
/// <summary>
|
/// 获取库存表列表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("list")]
|
public async Task<List<MaterialStockOutput>> List([FromQuery] MaterialStockInput input)
|
{
|
return await _wmsMaterialStockRep.DetachedEntities.ProjectToType<MaterialStockOutput>().ToListAsync();
|
}
|
|
/// <summary>
|
/// 获取WmsArea列表
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet("WmsArea")]
|
public async Task<dynamic> FkWmsAreaList()
|
{
|
var list = await _wmsAreaRep.DetachedEntities.ToListAsync();
|
return list.Select(e => new { Code = e.Id, Name = e.AreaName });
|
}
|
}
|
}
|
