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.Application.Service.WmsCount.WareTaskBak.Dto;
|
using iWare.Wms.Core;
|
using Mapster;
|
using Microsoft.AspNetCore.Authorization;
|
using Microsoft.AspNetCore.Mvc;
|
using Microsoft.EntityFrameworkCore;
|
using System.Linq.Dynamic.Core;
|
|
namespace iWare.Wms.Application
|
{
|
/// <summary>
|
/// 历史任务记录服务
|
/// </summary>
|
[ApiDescriptionSettings("统计查询", Name = "WareTaskBak", Order = 100)]
|
[Route("api/[Controller]")]
|
public class WareTaskBakService : ControllerBase, IWareTaskBakService, IDynamicApiController, ITransient
|
{
|
private readonly IRepository<WareTaskBak, MasterDbContextLocator> _wareTaskBakRep;
|
private readonly IRepository<WareTaskSubBak, MasterDbContextLocator> _wareTaskSubBak;
|
|
public WareTaskBakService(
|
IRepository<WareTaskBak, MasterDbContextLocator> wareTaskBakRep,
|
IRepository<WareTaskSubBak, MasterDbContextLocator> wareTaskSubBak
|
)
|
{
|
_wareTaskBakRep = wareTaskBakRep;
|
_wareTaskSubBak = wareTaskSubBak;
|
}
|
|
/// <summary>
|
/// 分页查询历史任务记录
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("page")]
|
public async Task<PageResult<WareTaskBakOutput>> Page([FromQuery] WareTaskBakSearch input)
|
{
|
if (input.ToLocationCode == "A线")
|
{
|
input.ToLocationCode = "A01";
|
}
|
if (input.ToLocationCode == "B线")
|
{
|
input.ToLocationCode = "B01";
|
}
|
if (input.ToLocationCode == "C线")
|
{
|
input.ToLocationCode = "C01";
|
}
|
if (input.FromLocationCode == "A线")
|
{
|
input.FromLocationCode = "A01";
|
}
|
if (input.FromLocationCode == "B线")
|
{
|
input.FromLocationCode = "B01";
|
}
|
if (input.FromLocationCode == "C线")
|
{
|
input.FromLocationCode = "C01";
|
}
|
|
|
var wareTaskBaks = await _wareTaskBakRep.DetachedEntities
|
.Where(!string.IsNullOrEmpty(input.OrderNo), u => u.OrderNo == input.OrderNo)
|
.Where(!string.IsNullOrEmpty(input.TaskNo), u => u.TaskNo == input.TaskNo)
|
.Where(!string.IsNullOrEmpty(input.TaskName), u => u.TaskName == input.TaskName)
|
.Where(input.TaskCategory != null, u => u.TaskCategory == input.TaskCategory)
|
.Where(input.TaskType != null, u => u.TaskType == input.TaskType)
|
.Where(input.TaskState != null, u => u.TaskState == input.TaskState)
|
.Where(!string.IsNullOrEmpty(input.TaskDescribe), u => u.TaskDescribe == input.TaskDescribe)
|
.Where(input.TaskPriority != null, u => u.TaskPriority == input.TaskPriority)
|
.Where(!string.IsNullOrEmpty(input.ContainerCode), u => u.ContainerCode == input.ContainerCode)
|
.Where(!string.IsNullOrEmpty(input.FromLocationCode), u => u.FromLocationCode == input.FromLocationCode)
|
.Where(!string.IsNullOrEmpty(input.ToLocationCode), u => u.ToLocationCode == input.ToLocationCode)
|
.Where(input.FinishedTime != null, u => u.FinishedTime == input.FinishedTime)
|
.Where(input.Lane != null, u => u.Lane == input.Lane)
|
.Where(input.MoveFlag != null, u => u.MoveFlag == input.MoveFlag)
|
.Where(!string.IsNullOrEmpty(input.MoveFromLocation), u => u.MoveFromLocation == input.MoveFromLocation)
|
.Where(!string.IsNullOrEmpty(input.MoveToLocation), u => u.MoveToLocation == input.MoveToLocation)
|
.Where(!string.IsNullOrEmpty(input.MoveContainerCode), u => u.MoveContainerCode == input.MoveContainerCode)
|
.Where(input.ContainerType != null, u => u.ContainerType == input.ContainerType)
|
.Where(!string.IsNullOrEmpty(input.OperationRemark), u => u.OperationRemark == input.OperationRemark)
|
.OrderBy(PageInputOrder.OrderBuilder<WareTaskBakSearch>(input))
|
.ProjectToType<WareTaskBakOutput>()
|
.ToADPagedListAsync(input.PageNo, input.PageSize);
|
foreach (var item in wareTaskBaks.Rows)
|
{
|
if (item.ToLocationCode.StartsWith("A"))
|
{
|
item.ToLocationCode = "A线";
|
}
|
if (item.ToLocationCode.StartsWith("B"))
|
{
|
item.ToLocationCode = "B线";
|
}
|
if (item.ToLocationCode.StartsWith("C"))
|
{
|
item.ToLocationCode = "C线";
|
}
|
if (item.FromLocationCode.StartsWith("A"))
|
{
|
item.FromLocationCode = "A线";
|
}
|
if (item.FromLocationCode.StartsWith("B"))
|
{
|
item.FromLocationCode = "B线";
|
}
|
if (item.FromLocationCode.StartsWith("C"))
|
{
|
item.FromLocationCode = "C线";
|
}
|
}
|
|
return wareTaskBaks;
|
}
|
|
/// <summary>
|
/// 增加历史任务记录
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("add")]
|
public async Task Add(AddWareTaskBakInput input)
|
{
|
var wareTaskBak = input.Adapt<WareTaskBak>();
|
await _wareTaskBakRep.InsertAsync(wareTaskBak);
|
}
|
|
/// <summary>
|
/// 删除历史任务记录
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("delete")]
|
public async Task Delete(DeleteWareTaskBakInput input)
|
{
|
var wareTaskBak = await _wareTaskBakRep.FirstOrDefaultAsync(u => u.Id == input.Id);
|
await _wareTaskBakRep.DeleteAsync(wareTaskBak);
|
}
|
|
/// <summary>
|
/// 更新历史任务记录
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("edit")]
|
public async Task Update(UpdateWareTaskBakInput input)
|
{
|
var isExist = await _wareTaskBakRep.AnyAsync(u => u.Id == input.Id, false);
|
if (!isExist) throw Oops.Oh(ErrorCode.D3000);
|
|
var wareTaskBak = input.Adapt<WareTaskBak>();
|
await _wareTaskBakRep.UpdateAsync(wareTaskBak, ignoreNullValues: true);
|
}
|
|
/// <summary>
|
/// 获取历史任务记录
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("detail")]
|
public async Task<WareTaskBakOutput> Get([FromQuery] QueryeWareTaskBakInput input)
|
{
|
return (await _wareTaskBakRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<WareTaskBakOutput>();
|
}
|
|
/// <summary>
|
/// 获取历史任务记录列表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("list")]
|
public async Task<List<WareTaskBakOutput>> List([FromQuery] WareTaskBakInput input)
|
{
|
return await _wareTaskBakRep.DetachedEntities.ProjectToType<WareTaskBakOutput>().ToListAsync();
|
}
|
|
/// <summary>
|
/// 查看详情
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("details")]
|
public async Task<List<WareTaskSubBak>> ManualWare([FromQuery] WmsTaskDetailSearch input)
|
{
|
return await _wareTaskSubBak.Where(n => n.TaskId == input.Id).ToListAsync();
|
}
|
|
|
/// <summary>
|
/// 导出Excel
|
/// </summary>
|
/// <param name="input">筛选条件</param>
|
/// <returns></returns>
|
[HttpPost("download")]
|
[AllowAnonymous]
|
public async Task<ActionResult> Download([FromBody] WareTaskBakSearch input)
|
{
|
if (input.ToLocationCode == "A线")
|
{
|
input.ToLocationCode = "A01";
|
}
|
if (input.ToLocationCode == "B线")
|
{
|
input.ToLocationCode = "B01";
|
}
|
if (input.ToLocationCode == "C线")
|
{
|
input.ToLocationCode = "C01";
|
}
|
if (input.FromLocationCode == "A线")
|
{
|
input.FromLocationCode = "A01";
|
}
|
if (input.FromLocationCode == "B线")
|
{
|
input.FromLocationCode = "B01";
|
}
|
if (input.FromLocationCode == "C线")
|
{
|
input.FromLocationCode = "C01";
|
}
|
|
var dataRecords = await _wareTaskBakRep.DetachedEntities
|
.Where(!string.IsNullOrEmpty(input.OrderNo), u => u.OrderNo == input.OrderNo)
|
.Where(!string.IsNullOrEmpty(input.TaskNo), u => u.TaskNo == input.TaskNo)
|
.Where(!string.IsNullOrEmpty(input.TaskName), u => u.TaskName == input.TaskName)
|
.Where(input.TaskCategory != null, u => u.TaskCategory == input.TaskCategory)
|
.Where(input.TaskType != null, u => u.TaskType == input.TaskType)
|
.Where(input.TaskState != null, u => u.TaskState == input.TaskState)
|
.Where(!string.IsNullOrEmpty(input.TaskDescribe), u => u.TaskDescribe == input.TaskDescribe)
|
.Where(input.TaskPriority != null, u => u.TaskPriority == input.TaskPriority)
|
.Where(!string.IsNullOrEmpty(input.ContainerCode), u => u.ContainerCode == input.ContainerCode)
|
.Where(!string.IsNullOrEmpty(input.FromLocationCode), u => u.FromLocationCode == input.FromLocationCode)
|
.Where(!string.IsNullOrEmpty(input.ToLocationCode), u => u.ToLocationCode == input.ToLocationCode)
|
.Where(input.FinishedTime != null, u => u.FinishedTime == input.FinishedTime)
|
.Where(input.Lane != null, u => u.Lane == input.Lane)
|
.Where(input.MoveFlag != null, u => u.MoveFlag == input.MoveFlag)
|
.Where(!string.IsNullOrEmpty(input.MoveFromLocation), u => u.MoveFromLocation == input.MoveFromLocation)
|
.Where(!string.IsNullOrEmpty(input.MoveToLocation), u => u.MoveToLocation == input.MoveToLocation)
|
.Where(!string.IsNullOrEmpty(input.MoveContainerCode), u => u.MoveContainerCode == input.MoveContainerCode)
|
.Where(input.ContainerType != null, u => u.ContainerType == input.ContainerType)
|
.Where(!string.IsNullOrEmpty(input.OperationRemark), u => u.OperationRemark == input.OperationRemark)
|
.OrderBy(PageInputOrder.OrderBuilder<WareTaskBakSearch>(input))
|
.ProjectToType<WareTaskBakExcel>().ToListAsync();
|
|
var excelBaseResult = new Excel2003Result<WareTaskBakExcel>(dataRecords, "库位表格" + DateTime.Now.ToString("yyyyMMdd"), false, "生产记录");
|
return File(excelBaseResult.GetExcelStream(), "application/vnd.ms-excel");
|
}
|
}
|
}
|
