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 = "WmsMaterial", Order = 100)]
|
[Route("api/[Controller]")]
|
public class WmsMaterialService : IDynamicApiController, ITransient
|
{
|
private readonly IRepository<WmsMaterial, MasterDbContextLocator> _wmsMaterialRep;
|
private readonly IRepository<WmsArea, MasterDbContextLocator> _wmsAreaRep;
|
private readonly IRepository<LesStation, MasterDbContextLocator> _lesStationRep;
|
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
public WmsMaterialService(
|
IRepository<WmsMaterial, MasterDbContextLocator> wmsMaterialRep,
|
IRepository<WmsArea, MasterDbContextLocator> wmsAreaRep,
|
IRepository<LesStation, MasterDbContextLocator> lesStationRep
|
)
|
{
|
_wmsMaterialRep = wmsMaterialRep;
|
_wmsAreaRep = wmsAreaRep;
|
_lesStationRep = lesStationRep;
|
}
|
|
/// <summary>
|
/// 分页查询物料信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("page")]
|
public async Task<PageResult<WmsMaterialOutput>> Page([FromQuery] WmsMaterialSearch input)
|
{
|
var wmsMaterials = await _wmsMaterialRep.DetachedEntities
|
.Where(!string.IsNullOrEmpty(input.MaterialName), u => EF.Functions.Like(u.MaterialName, $"%{input.MaterialName.Trim()}%"))
|
.Where(input.MaterialType != null, u => u.MaterialType == input.MaterialType)
|
.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(input.IsMaturation != null, u => u.IsMaturation == input.IsMaturation)
|
.OrderBy(PageInputOrder.OrderBuilder<WmsMaterialSearch>(input))
|
.ProjectToType<WmsMaterialOutput>()
|
.ToADPagedListAsync(input.PageNo, input.PageSize);
|
return wmsMaterials;
|
}
|
|
/// <summary>
|
/// 增加物料信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("add")]
|
public async Task Add(AddWmsMaterialInput input)
|
{
|
var wmsMaterial = input.Adapt<WmsMaterial>();
|
await _wmsMaterialRep.InsertAsync(wmsMaterial);
|
}
|
|
/// <summary>
|
/// 删除物料信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("delete")]
|
public async Task Delete(DeleteWmsMaterialInput input)
|
{
|
var wmsMaterial = await _wmsMaterialRep.FirstOrDefaultAsync(u => u.Id == input.Id);
|
await _wmsMaterialRep.DeleteAsync(wmsMaterial);
|
}
|
|
/// <summary>
|
/// 更新物料信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("edit")]
|
public async Task Update(UpdateWmsMaterialInput input)
|
{
|
var isExist = await _wmsMaterialRep.AnyAsync(u => u.Id == input.Id, false);
|
if (!isExist) throw Oops.Oh(ErrorCode.D3000);
|
|
var wmsMaterial = input.Adapt<WmsMaterial>();
|
await _wmsMaterialRep.UpdateAsync(wmsMaterial, ignoreNullValues: true);
|
}
|
|
/// <summary>
|
/// 获取物料信息
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("detail")]
|
public async Task<WmsMaterialOutput> Get([FromQuery] QueryeWmsMaterialInput input)
|
{
|
return (await _wmsMaterialRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<WmsMaterialOutput>();
|
}
|
|
/// <summary>
|
/// 获取物料信息列表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("list")]
|
public async Task<List<WmsMaterialOutput>> List([FromQuery] WmsMaterialInput input)
|
{
|
return await _wmsMaterialRep.DetachedEntities.ProjectToType<WmsMaterialOutput>().ToListAsync();
|
}
|
|
/// <summary>
|
/// 库区下拉框
|
/// </summary>
|
/// <returns></returns>
|
[HttpGet("GetAreaList")]
|
public async Task<List<AreaListOutput>> GetAreaList()
|
{
|
var data = await _wmsAreaRep.DetachedEntities.ProjectToType<WmsAreaOutput>().ToListAsync();
|
List<AreaListOutput> areaListOutputLists = new List<AreaListOutput>();
|
foreach (var item in data)
|
{
|
AreaListOutput areaListOutputList = new AreaListOutput();
|
areaListOutputList.AreaId = item.Id.ToString();
|
areaListOutputList.AreaName = item.AreaName;
|
areaListOutputLists.Add(areaListOutputList);
|
}
|
return areaListOutputLists;
|
}
|
|
/// <summary>
|
/// 工作区（工位）下拉框
|
/// </summary>
|
/// <returns></returns>
|
//[HttpGet("GetStationList")]
|
//public async Task<List<StationListOutput>> GetStationList()
|
//{
|
// var data = await _lesStationRep.DetachedEntities.ProjectToType<LesStationOutput>().ToListAsync();
|
// List<StationListOutput> stationListOutputLists = new List<StationListOutput>();
|
// foreach (var item in data)
|
// {
|
// StationListOutput stationListOutputList = new StationListOutput();
|
// stationListOutputList.StationId = item.Id.ToString();
|
// stationListOutputList.StationName = item.Name;
|
// stationListOutputLists.Add(stationListOutputList);
|
// }
|
// return stationListOutputLists;
|
//}
|
}
|
}
|
