using Furion.DatabaseAccessor;
|
using Furion.DependencyInjection;
|
using Furion.DynamicApiController;
|
using Furion.FriendlyException;
|
using Mapster;
|
using Microsoft.AspNetCore.Http;
|
using Microsoft.AspNetCore.Mvc;
|
using Microsoft.EntityFrameworkCore;
|
using System.Linq.Dynamic.Core;
|
using System.Text;
|
using System.Web;
|
using Admin.NET.Core;
|
using Yitter.IdGenerator;
|
using StackExchange.Redis;
|
|
namespace Admin.NET.Application
|
{
|
/// <summary>
|
/// 任务管理服务
|
/// </summary>
|
[ApiDescriptionSettings("仓库作业", Name = "WmsTask", Order = 102)]
|
[Route("api/[Controller]")]
|
public class WmsTaskService : IDynamicApiController, ITransient
|
{
|
private readonly IRepository<SysDictType, MasterDbContextLocator> _sysDictTypeRep;
|
private readonly IRepository<SysDictData, MasterDbContextLocator> _sysDictDataRep;
|
private readonly IRepository<WmsTask, MasterDbContextLocator> _wmsTaskRep;
|
private readonly IRepository<WmsWarehouseEntrance, MasterDbContextLocator> _wmsWarehouseEntranceRep;
|
private readonly IRepository<WmsPlace, MasterDbContextLocator> _wmsPlaceRep;
|
private readonly IRepository<WmsOrder, MasterDbContextLocator> _wmsOrderRep;
|
private readonly IRepository<WmsOrderDetails, MasterDbContextLocator> _wmsOrderDetailsRep;
|
private readonly IRepository<WmsContainerPlace, MasterDbContextLocator> _wmsContainerPlaceRep;
|
private readonly IRepository<WmsMaterialStock, MasterDbContextLocator> _wmsMaterialStockRep;
|
private readonly IRepository<WmsContainer, MasterDbContextLocator> _wmsContainerRep;
|
private readonly IRepository<WmsMaterialContainer, MasterDbContextLocator> _wmsMaterialContainerRep;
|
private readonly IRepository<WmsArea, MasterDbContextLocator> _wmsAreaRep;
|
private readonly ISysExcelTemplateService _sysExcelTemplateService;
|
private readonly static object _lock = new();
|
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
public WmsTaskService(
|
IRepository<SysDictType, MasterDbContextLocator> sysDictTypeRep,
|
IRepository<SysDictData, MasterDbContextLocator> sysDictDataRep,
|
IRepository<WmsTask, MasterDbContextLocator> wmsTaskRep,
|
IRepository<WmsWarehouseEntrance, MasterDbContextLocator> wmsWarehouseEntranceRep,
|
IRepository<WmsOrder, MasterDbContextLocator> wmsOrderRep,
|
IRepository<WmsOrderDetails, MasterDbContextLocator> wmsOrderDetailsRep,
|
IRepository<WmsPlace, MasterDbContextLocator> wmsPlaceRep,
|
IRepository<WmsContainerPlace, MasterDbContextLocator> wmsContainerPlaceRep,
|
IRepository<WmsMaterialStock, MasterDbContextLocator> wmsMaterialStockRep,
|
IRepository<WmsContainer, MasterDbContextLocator> wmsContainerRep,
|
IRepository<WmsMaterialContainer, MasterDbContextLocator> wmsMaterialContainerRep,
|
IRepository<WmsArea, MasterDbContextLocator> wmsAreaRep,
|
ISysExcelTemplateService sysExcelTemplateService
|
)
|
{
|
_sysDictTypeRep = sysDictTypeRep;
|
_sysDictDataRep = sysDictDataRep;
|
_wmsTaskRep = wmsTaskRep;
|
_wmsWarehouseEntranceRep = wmsWarehouseEntranceRep;
|
_wmsOrderRep = wmsOrderRep;
|
_wmsOrderDetailsRep = wmsOrderDetailsRep;
|
_wmsPlaceRep = wmsPlaceRep;
|
_wmsContainerPlaceRep = wmsContainerPlaceRep;
|
_wmsMaterialStockRep = wmsMaterialStockRep;
|
_wmsContainerRep = wmsContainerRep;
|
_wmsMaterialContainerRep = wmsMaterialContainerRep;
|
_wmsAreaRep= wmsAreaRep;
|
_sysExcelTemplateService = sysExcelTemplateService;
|
}
|
|
/// <summary>
|
/// 分页查询出入库任务管理
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("page")]
|
public async Task<PageResult<TaskOutput>> Page([FromQuery] WmsTaskSearch input)
|
{
|
var wmsTasks = await _wmsTaskRep.DetachedEntities
|
.Where(u => u.AreaName.Contains("绝缘立库"))
|
.Where(!string.IsNullOrEmpty(input.TaskNo), u => EF.Functions.Like(u.TaskNo, $"%{input.TaskNo.Trim()}%"))
|
.Where(input.TaskModel != null, u => u.TaskModel == input.TaskModel)
|
.Where(input.TaskType != null, u => u.TaskType == input.TaskType)
|
.Where(input.TaskStatus != null, u => u.TaskStatus == input.TaskStatus)
|
.Where(!string.IsNullOrEmpty(input.ContainerCode), u => EF.Functions.Like(u.ContainerCode, $"%{input.ContainerCode.Trim()}%"))
|
.Where(!string.IsNullOrEmpty(input.AreaName), u => u.AreaName == input.AreaName)
|
.Where(!string.IsNullOrEmpty(input.OrderNo), u => EF.Functions.Like(u.OrderNo, $"%{input.OrderNo.Trim()}%"))
|
.Where(!string.IsNullOrEmpty(input.SourcePlace), u => EF.Functions.Like(u.SourcePlace, $"%{input.SourcePlace.Trim()}%"))
|
.Where(!string.IsNullOrEmpty(input.ToPlace), u => EF.Functions.Like(u.ToPlace, $"%{input.ToPlace.Trim()}%"))
|
.Where(input.Aisle != null, u => u.Aisle == input.Aisle)
|
.OrderBy(PageInputOrder.OrderBuilder(input))
|
.ProjectToType<TaskOutput>()
|
.ToADPagedListAsync(input.PageNo, input.PageSize);
|
return wmsTasks;
|
}
|
|
/// <summary>
|
/// 不分页查询出入库任务管理列表
|
/// </summary>
|
/// <param name="input">出入库任务管理查询参数</param>
|
/// <returns>(出入库任务管理)实例列表</returns>
|
[HttpGet("listNonPage")]
|
public async Task<List<TaskOutput>> ListNonPageAsync([FromQuery] WmsTaskSearchNonPage input)
|
{
|
var pTaskNo = input.TaskNo?.Trim() ?? "";
|
var pTaskModel = input.TaskModel;
|
var pTaskType = input.TaskType;
|
var pTaskLevel = input.TaskLevel;
|
var pTaskStatus = input.TaskStatus;
|
var pIsRead = input.IsRead;
|
var pContainerCode = input.ContainerCode?.Trim() ?? "";
|
var pAreaName = input.AreaName?.Trim() ?? "";
|
var pOrderNo = input.OrderNo?.Trim() ?? "";
|
var pTaskDodeviceStatus = input.TaskDodeviceStatus;
|
var wmsTasks = await _wmsTaskRep.DetachedEntities
|
.Where(!string.IsNullOrEmpty(pTaskNo), u => EF.Functions.Like(u.TaskNo, $"%{pTaskNo}%"))
|
.Where(pTaskModel != null, u => u.TaskModel == pTaskModel)
|
.Where(pTaskType != null, u => u.TaskType == pTaskType)
|
.Where(pTaskLevel != null, u => u.TaskLevel == pTaskLevel)
|
.Where(pTaskStatus != null, u => u.TaskStatus == pTaskStatus)
|
.Where(pIsRead != null, u => u.IsRead == pIsRead)
|
.Where(!string.IsNullOrEmpty(pContainerCode), u => EF.Functions.Like(u.ContainerCode, $"%{pContainerCode}%"))
|
.Where(!string.IsNullOrEmpty(pAreaName), u => u.AreaName == pAreaName)
|
.Where(!string.IsNullOrEmpty(pOrderNo), u => EF.Functions.Like(u.OrderNo, $"%{pOrderNo}%"))
|
.Where(pTaskDodeviceStatus != null, u => u.TaskDodeviceStatus == pTaskDodeviceStatus)
|
.OrderBy(PageInputOrder.OrderNonPageBuilder(input))
|
.ProjectToType<TaskOutput>()
|
.ToListAsync();
|
return wmsTasks;
|
}
|
|
/// <summary>
|
/// 增加出入库任务管理
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("add")]
|
[NonAction]
|
public async Task Add(AddWmsTaskInput input)
|
{
|
var wmsTask = input.Adapt<WmsTask>();
|
await _wmsTaskRep.InsertAsync(wmsTask);
|
}
|
|
/// <summary>
|
/// 删除出入库任务管理
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("delete")]
|
public async Task Delete(DeleteWmsTaskInput input)
|
{
|
var wmsTask = await _wmsTaskRep.FirstOrDefaultAsync(u => u.Id == input.Id);
|
await _wmsTaskRep.DeleteAsync(wmsTask);
|
}
|
|
/// <summary>
|
/// 更新出入库任务管理
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("edit")]
|
public async Task Update(UpdateWmsTaskInput input)
|
{
|
var isExist = await _wmsTaskRep.AnyAsync(u => u.Id == input.Id, false);
|
if (!isExist) throw Oops.Oh(ErrorCode.D3000);
|
|
var wmsTask = input.Adapt<WmsTask>();
|
await _wmsTaskRep.UpdateAsync(wmsTask, ignoreNullValues: true);
|
}
|
|
/// <summary>
|
/// 强制完成
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost("finish")]
|
[UnitOfWork]
|
public async Task Finish([FromBody] WmsTaskFinishInput input)
|
{
|
//查询任务
|
var wmsTask = await _wmsTaskRep.FirstOrDefaultAsync(u => u.Id == input.Id);
|
if (wmsTask == null) throw Oops.Oh("任务不存在！");
|
|
// 查询混合料库区信息
|
var wmsArea = await _wmsAreaRep.FirstOrDefaultAsync(u => u.AreaName.Contains("绝缘立库"));
|
if (wmsArea == null) throw Oops.Oh("库区不存在！");
|
|
// 查询托盘信息,呼救AGV时会进行组盘操作
|
var wmsContainer = await _wmsContainerRep.FirstOrDefaultAsync(z => z.ContainerCode == wmsTask.ContainerCode);
|
if (wmsContainer == null) throw Oops.Oh("托盘不存在！");
|
|
var statusList = new List<TaskStatusEnum> { TaskStatusEnum.WEIZHIXING, TaskStatusEnum.ZHIXINGZHONG , TaskStatusEnum .DAIZHIXING};
|
if (!statusList.Contains(wmsTask.TaskStatus)) throw Oops.Oh("只有未执行和执行中的任务才能强制完成！");
|
|
if (wmsTask.TaskType == TaskType.RUKU) // 入库任务
|
{
|
// 查询库位信息 随机分配库位
|
var wmsPlace = new WmsPlace();
|
if (string.IsNullOrEmpty(wmsTask.ToPlace))
|
wmsPlace = await _wmsPlaceRep.FirstOrDefaultAsync(u => u.AreaId == wmsArea.Id && u.Islock == YesOrNot.N && u.PlaceStatus == PlaceStatus.KONGXIAN);
|
else
|
wmsPlace = await _wmsPlaceRep.FirstOrDefaultAsync(u => u.AreaId == wmsArea.Id && u.PlaceCode == wmsTask.ToPlace);
|
if (wmsPlace == null) throw Oops.Oh("库位不存在!");
|
if (wmsPlace.Islock == YesOrNot.Y) throw Oops.Oh("库位被锁定!");
|
if (wmsPlace.PlaceStatus != PlaceStatus.KONGXIAN) throw Oops.Oh("库位已存货!");
|
// 更新库位状态为“存货”
|
wmsPlace.PlaceStatus = PlaceStatus.CUNHUO;
|
if (wmsTask.Description == "空托") wmsPlace.EmptyContainer = YesOrNot.Y; //是否空托
|
else wmsPlace.EmptyContainer = YesOrNot.N;
|
|
// 创建托盘号库位关系表
|
var wmsContainerPlaceModel = new WmsContainerPlace()
|
{
|
PlaceId = wmsPlace.Id,
|
PlaceCode = wmsPlace.PlaceCode,
|
ContainerId = wmsContainer.Id,
|
ContainerCode = wmsContainer.ContainerCode,
|
ContainerPlaceStatus = CommonStatus.ENABLE
|
};
|
await _wmsContainerPlaceRep.InsertAsync(wmsContainerPlaceModel);
|
|
// 更新库存
|
var wmsMaterialContainerList = await _wmsMaterialContainerRep.DetachedEntities
|
.Where(p => p.OrderNo ==wmsTask.OrderNo && p.BindStatus == CommonStatus.ENABLE).ProjectToType<WmsMaterialContainer>().ToListAsync();
|
|
foreach (var item in wmsMaterialContainerList)
|
{
|
var wmsMaterialStock = await _wmsMaterialStockRep.FirstOrDefaultAsync(p => p.ContainerCode == wmsContainer.ContainerCode
|
&& p.MaterialBatch == item.MaterialBatch);
|
if (wmsMaterialStock != null)
|
{
|
wmsMaterialStock.Source = RuKuSourceEnum.KONGTUO;
|
wmsMaterialStock.AreaId = wmsPlace.AreaId;
|
wmsMaterialStock.PlaceCode = wmsPlace.PlaceCode;
|
wmsMaterialStock.StockNumber += item.BindQuantity;
|
await _wmsMaterialStockRep.UpdateAsync(wmsMaterialStock);
|
}
|
else
|
{
|
wmsMaterialStock = new WmsMaterialStock()
|
{
|
InspectionMethod = MaterialInspection.MIANJIAN,
|
UnitType = UnitType.ZHONGLIANG,
|
UnitNo = UnitNoType.T,
|
MaterialNo = item.MaterialNo,
|
MaterialType = MaterialType.CHENGPING,
|
MaterialName = item.MaterialName,
|
MaterialSpec = item.MaterialSpec,
|
MaterialBatch = item.MaterialBatch,
|
MaterialDensity = item.MaterialDensity,
|
StockNumber = 1,
|
PlaceCode = wmsPlace.PlaceCode,
|
ContainerId = wmsContainer.Id,
|
ContainerCode = wmsContainer.ContainerCode,
|
AreaId = wmsPlace.AreaId,
|
Source = RuKuSourceEnum.KONGTUO,
|
};
|
await _wmsMaterialStockRep.InsertAsync(wmsMaterialStock);
|
}
|
}
|
// 空料箱入库
|
if (wmsTask.OrderNo == "N/A")
|
{
|
var wmsMaterialStock = new WmsMaterialStock()
|
{
|
InspectionMethod = MaterialInspection.MIANJIAN,
|
UnitType = UnitType.ZHONGLIANG,
|
UnitNo = UnitNoType.T,
|
MaterialNo = "N/A",
|
MaterialType = MaterialType.KONGTUO,
|
MaterialName = "N/A",
|
MaterialSpec = "N/A",
|
MaterialBatch = "N/A",
|
MaterialDensity = "N/A",
|
StockNumber = 0,
|
PlaceCode = wmsPlace.PlaceCode,
|
ContainerId = wmsContainer.Id,
|
ContainerCode = wmsContainer.ContainerCode,
|
AreaId = wmsPlace.AreaId,
|
Source = RuKuSourceEnum.KONGTUO,
|
};
|
await _wmsMaterialStockRep.InsertAsync(wmsMaterialStock);
|
}
|
// 更新任务状态、设备任务状态、托盘编号、目标位置、库区名称
|
wmsTask.TaskStatus = TaskStatusEnum.WANCHENG;
|
wmsTask.TaskDodeviceStatus = TaskDodeviceStatusEnum.W;
|
wmsTask.ContainerCode = wmsContainer.ContainerCode;
|
wmsTask.ToPlace = wmsPlace.PlaceCode;
|
wmsTask.AreaName = wmsPlace.WmsArea.AreaName;
|
wmsTask.IsRead = true;
|
|
// 更新库位状态为存货
|
wmsPlace.PlaceStatus = PlaceStatus.CUNHUO;
|
await _wmsPlaceRep.UpdateAsync(wmsPlace);
|
|
// 更新托盘状态为“库位”
|
wmsContainer.ContainerStatus = ContainerStatus.KUWEI;
|
await _wmsContainerRep.UpdateAsync(wmsContainer);
|
}
|
else if (wmsTask.TaskType == TaskType.CHUKU) //出库任务
|
{
|
var wmsMaterialContainerList = new List<WmsMaterialContainer>();
|
// 查询库位信息
|
var wmsPlace = await _wmsPlaceRep.FirstOrDefaultAsync(u => u.PlaceCode == wmsTask.SourcePlace);
|
if (wmsPlace == null) throw Oops.Oh("库位信息不存在!");
|
if (wmsPlace.Islock == YesOrNot.Y) throw Oops.Oh("库位被锁定!");
|
//if (wmsPlace != null && wmsPlace.PlaceStatus != PlaceStatus.DAICHU) throw Oops.Oh("库位异常货!");
|
|
// 查询是否已存在托盘与库位的关系
|
var wmsContainerPlace = await _wmsContainerPlaceRep.FirstOrDefaultAsync(z => z.PlaceId == wmsPlace.Id && z.PlaceCode == wmsPlace.PlaceCode
|
&& z.ContainerCode == wmsTask.ContainerCode && z.ContainerPlaceStatus == CommonStatus.ENABLE);
|
if (wmsContainerPlace == null) throw Oops.Oh("库位容器关系不存在!");
|
|
// 不是空托才会有组盘关系
|
if (wmsPlace.EmptyContainer == YesOrNot.N)
|
{
|
// 检查物料与空托号关系
|
wmsMaterialContainerList = await _wmsMaterialContainerRep.Where(p => p.ContainerCode == wmsContainer.ContainerCode && p.BindStatus == CommonStatus.ENABLE).ToListAsync();
|
if (wmsMaterialContainerList.Count <= 0) throw Oops.Oh("托盘号与物料关系不存在!");
|
|
}
|
else
|
{
|
// 更新空料箱库存
|
var wmsMaterialStock = await _wmsMaterialStockRep.FirstOrDefaultAsync(u => u.ContainerCode == wmsContainer.ContainerCode);
|
if (wmsMaterialStock.Source == RuKuSourceEnum.KONGTUO)
|
{
|
await _wmsMaterialStockRep.DeleteAsync(wmsMaterialStock);
|
}
|
}
|
|
//构建出库物料和周转箱号关系
|
var orderNo = "N/A";
|
if (wmsMaterialContainerList.Count > 0) orderNo = YitIdHelper.NextId().ToString();
|
|
foreach (var wmsMaterialContaine in wmsMaterialContainerList)
|
{
|
//更新状态为”删除“
|
wmsMaterialContaine.BindStatus = CommonStatus.DELETED;
|
await _wmsMaterialContainerRep.UpdateNowAsync(wmsMaterialContaine);
|
|
//新增组盘绑定记录 正常
|
var addWmsMaterialContainer = wmsMaterialContaine;
|
addWmsMaterialContainer.Id = YitIdHelper.NextId();
|
addWmsMaterialContainer.OrderNo = orderNo;
|
addWmsMaterialContainer.BindStatus = CommonStatus.ENABLE;
|
await _wmsMaterialContainerRep.InsertNowAsync(addWmsMaterialContainer);
|
// 这里没有分拣操作直接更新库存信息
|
var wmsMaterialStock = await _wmsMaterialStockRep.FirstOrDefaultAsync(u => u.ContainerCode == wmsMaterialContaine.ContainerCode);
|
wmsMaterialStock.PlaceCode = "N/A";
|
wmsMaterialStock.StockNumber -= wmsMaterialContaine.BindQuantity;
|
await _wmsMaterialStockRep.UpdateAsync(wmsMaterialStock);
|
}
|
|
//更新任务状态
|
wmsTask.TaskStatus = TaskStatusEnum.WANCHENG;
|
wmsTask.TaskDodeviceStatus = TaskDodeviceStatusEnum.W;
|
wmsTask.IsRead = true;
|
|
// 禁用托盘库位关系
|
wmsContainerPlace.ContainerPlaceStatus = CommonStatus.DELETED;
|
await _wmsContainerPlaceRep.UpdateAsync(wmsContainerPlace);
|
|
// 更新库位状态为“空闲”
|
wmsPlace.PlaceStatus = PlaceStatus.KONGXIAN;
|
await _wmsPlaceRep.UpdateAsync(wmsPlace);
|
|
// 更新托盘状态为“空闲”
|
wmsContainer.ContainerStatus = ContainerStatus.KOUXIAN;
|
await _wmsContainerRep.UpdateAsync(wmsContainer);
|
}
|
else //移库任务
|
{
|
|
}
|
await _wmsTaskRep.UpdateAsync(wmsTask);
|
}
|
|
/// <summary>
|
/// 更新优先级(向上)
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost("upwardTaskLevel")]
|
public async Task UpwardTaskLevel([FromBody] UpdateTaskLevelInput input)
|
{
|
var wmsTask = await _wmsTaskRep.FirstOrDefaultAsync(u => u.Id == input.Id);
|
if (wmsTask == null) throw Oops.Oh("任务不存在！");
|
if (wmsTask.TaskStatus != TaskStatusEnum.WEIZHIXING) throw Oops.Oh("只有未执行的任务才能更新任务优先级！");
|
if(wmsTask.TaskLevel==5) throw Oops.Oh("任务已为最高级别！");
|
wmsTask.TaskLevel += 1;
|
await _wmsTaskRep.UpdateAsync(wmsTask);
|
}
|
|
/// <summary>
|
/// 更新优先级(向下)
|
/// </summary>
|
/// <returns></returns>
|
[HttpPost("downTaskLevel")]
|
public async Task DownTaskLevel([FromBody] UpdateTaskLevelInput input)
|
{
|
var wmsTask = await _wmsTaskRep.FirstOrDefaultAsync(u => u.Id == input.Id);
|
if (wmsTask == null) throw Oops.Oh("任务不存在！");
|
if (wmsTask.TaskStatus != TaskStatusEnum.WEIZHIXING) throw Oops.Oh("只有未执行的任务才能更新任务优先级！");
|
if (wmsTask.TaskLevel == 1) throw Oops.Oh("任务已为最低级别！");
|
wmsTask.TaskLevel -= 1;
|
await _wmsTaskRep.UpdateAsync(wmsTask);
|
}
|
|
/// <summary>
|
/// 取消
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("CancelTask")]
|
public async Task CancelTask([FromBody] CancelInput input)
|
{
|
var wmsTask = await _wmsTaskRep.FirstOrDefaultAsync(u => u.Id == input.Id);
|
if (wmsTask == null) throw Oops.Oh("任务不存在！");
|
|
if (wmsTask.TaskStatus != TaskStatusEnum.WEIZHIXING) throw Oops.Oh("只有未执行的任务才能取消任务！");
|
|
wmsTask.TaskStatus = TaskStatusEnum.QUXIAO;
|
wmsTask.IsRead=true;
|
await _wmsTaskRep.UpdateAsync(wmsTask);
|
}
|
|
|
/// <summary>
|
/// 批量取消
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("batchCancel")]
|
public async Task BatchCancel([FromBody] BatchCancelInput input)
|
{
|
int length = input.Id.Count;
|
for (int i = 0; i < length; i++)
|
{
|
long Id = input.Id[i];
|
var wmsTask = await _wmsTaskRep.FirstOrDefaultAsync(u => u.Id == Id);
|
if (wmsTask == null) throw Oops.Oh("任务不存在！");
|
|
if (wmsTask.TaskStatus != TaskStatusEnum.WEIZHIXING) throw Oops.Oh("只有未执行的任务才能取消任务！");
|
|
wmsTask.TaskStatus = TaskStatusEnum.QUXIAO;
|
await _wmsTaskRep.UpdateAsync(wmsTask);
|
}
|
}
|
|
/// <summary>
|
/// 批量暂停
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("batchBreak")]
|
public async Task BatchBreak([FromBody] BatchBreakInput input)
|
{
|
int length = input.Id.Count;
|
for (int i = 0; i < length; i++)
|
{
|
long Id = input.Id[i];
|
var wmsTask = await _wmsTaskRep.FirstOrDefaultAsync(u => u.Id == Id);
|
if (wmsTask == null) throw Oops.Oh("任务不存在！");
|
|
if (wmsTask.TaskStatus != TaskStatusEnum.WEIZHIXING) throw Oops.Oh("只有未执行的任务才能暂停任务！");
|
|
wmsTask.TaskStatus = TaskStatusEnum.ZANTING;
|
await _wmsTaskRep.UpdateAsync(wmsTask);
|
}
|
}
|
|
/// <summary>
|
/// 批量继续
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost("batchContinue")]
|
public async Task BatchContinue([FromBody] BatchContinueInput input)
|
{
|
int length = input.Id.Count;
|
for (int i = 0; i < length; i++)
|
{
|
long Id = input.Id[i];
|
var wmsTask = await _wmsTaskRep.FirstOrDefaultAsync(u => u.Id == Id);
|
if (wmsTask == null) throw Oops.Oh("任务不存在！");
|
|
if (wmsTask.TaskStatus != TaskStatusEnum.ZANTING) throw Oops.Oh("只有暂停的任务才能继续任务！");
|
|
wmsTask.TaskStatus = TaskStatusEnum.WEIZHIXING;
|
await _wmsTaskRep.UpdateAsync(wmsTask);
|
}
|
}
|
|
/// <summary>
|
/// 获取出入库任务管理
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("detail")]
|
public async Task<TaskOutput> Get([FromQuery] QueryeWmsTaskInput input)
|
{
|
return (await _wmsTaskRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<TaskOutput>();
|
}
|
|
/// <summary>
|
/// 获取出入库任务管理列表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet("list")]
|
public async Task<List<TaskOutput>> List([FromQuery] TaskInput input)
|
{
|
return await _wmsTaskRep.DetachedEntities.ProjectToType<TaskOutput>().ToListAsync();
|
}
|
|
/// <summary>
|
/// Excel模板导入出入库任务管理功能
|
/// </summary>
|
/// <param name="file">Excel模板文件</param>
|
/// <param name="importExcelType">Excel导入方式</param>
|
/// <returns>导入的记录数</returns>
|
[HttpPost("fromExcel")]
|
public async Task<int> FromExcelAsync(IFormFile file, [FromQuery] ImportExcelType importExcelType)
|
{
|
int size = 200;
|
var excelTemplate = await _sysExcelTemplateService.GetByAppNameAndClassNameAndVersionAsync("WmsTask", "v2");
|
if (excelTemplate == null) throw Oops.Oh(ErrorCode.Excel002);
|
var keys = excelTemplate.UnionUniqueFields.Split(",") ?? Array.Empty<string>();
|
for (var i = 0; i < keys.Length; i++)
|
{
|
keys[i] = keys[i]?.Trim() ?? string.Empty;
|
}
|
ExcelUtil.FromExcel(file, excelTemplate.HeadStartLine, excelTemplate.DataStartLine, out List<string> headers, out List<List<object?>> data, out string sheetName);
|
List<TaskOutput> wmsTaskList = DataConvertUtil.ToObjectList(headers, data, sheetName, keys, excelTemplate?.DataStartLine ?? 2, out Dictionary<string, TaskOutput> dict);
|
List<Dictionary<string, object>> uniqueKeyValueDictList = wmsTaskList.ParseUniqueKeyValueDictList(keys.ToList(), excelTemplate?.DataStartLine ?? 2, sheetName);
|
var filters = DataConvertUtil.GetExpressionListByUniqueDict<WmsTask>(keys.ToList(), uniqueKeyValueDictList, size);
|
var selectKeys = keys.ToList();
|
if (!selectKeys.Contains("Id")) selectKeys.Add("Id");
|
var selector = DataConvertUtil.GetSelectExpressionListByUniqueDict<WmsTask, TaskOutput>(selectKeys);
|
List<WmsTask> updates = new();
|
List<WmsTask> adds = new();
|
|
lock (_lock)
|
{
|
foreach (var filter in filters)
|
{
|
var wmsTaskExistSubList = _wmsTaskRep.Where(filter).Select(selector).ToList();
|
wmsTaskExistSubList.ForEach(x =>
|
{
|
var k = DataConvertUtil.GetKey(x, keys);
|
if (dict.ContainsKey(k)) dict[k].Id = x.Id;
|
});
|
}
|
|
foreach (var wmsTask in wmsTaskList)
|
{
|
if (wmsTask.Id > 0)
|
{
|
if (importExcelType == ImportExcelType.ADD_AND_UPDATE) updates.Add(wmsTask.Adapt<WmsTask>());
|
}
|
else
|
{
|
adds.Add(wmsTask.Adapt<WmsTask>());
|
}
|
}
|
|
if (importExcelType == ImportExcelType.ADD_AND_UPDATE) updates.ForEach(x => _wmsTaskRep.Update(x));
|
|
var maxId = _wmsTaskRep.DetachedEntities.OrderByDescending(x => x.Id).Select(x => x.Id).FirstOrDefault();
|
adds.ForEach(x => x.Id = ++maxId);
|
Db.GetDbContext().Set<WmsTask>().AddRange(adds);
|
Db.GetDbContext().SaveChanges();
|
}
|
|
await Task.CompletedTask;
|
return adds.Count;
|
}
|
|
/// <summary>
|
/// 根据版本下载出入库任务管理的Excel导入模板
|
/// </summary>
|
/// <param name="version">模板版本</param>
|
/// <returns>下载的模板文件</returns>
|
[HttpGet("downloadExcelTemplate")]
|
public async Task<IActionResult> DownloadExcelTemplate([FromQuery] string version)
|
{
|
var excelTemplate = await _sysExcelTemplateService.GetByAppNameAndClassNameAndVersionAsync("WmsTask", version);
|
if (excelTemplate == null) throw Oops.Oh(ErrorCode.Excel002);
|
var path = Path.Combine(@"\", excelTemplate.TemplateFileName);
|
Stream ms = FileUtil.Download(path, excelTemplate.TemplateFileName);
|
var fileName = HttpUtility.UrlEncode($"{excelTemplate.Name}导入模板.xlsx", Encoding.GetEncoding("UTF-8"));
|
return new FileStreamResult(ms, "application/octet-stream") { FileDownloadName = fileName };
|
}
|
|
/// <summary>
|
/// 根据出入库任务管理查询参数导出Excel
|
/// </summary>
|
/// <param name="input">出入库任务管理（熟化库）查询参数</param>
|
/// <returns>导出的Excel文件</returns>
|
[HttpGet("toExcel")]
|
public async Task<IActionResult> ToExcelAsync([FromQuery] WmsTaskSearchNonPage input)
|
{
|
var wmsTaskList = await ListNonPageAsync(input);
|
MemoryStream ms = new();
|
DataConvertUtil.ToExcelData(wmsTaskList, _sysDictTypeRep, _sysDictDataRep, out List<string> headers,
|
out List<List<object>> data, out string sheetName);
|
var excelTemplate = await _sysExcelTemplateService.GetByAppNameAndClassNameAndVersionAsync("WmsTask", "v1");
|
if (excelTemplate != null)
|
{
|
ExcelUtil.ToExcel(excelTemplate.TemplateFileName, headers, data, sheetName, excelTemplate.HeadStartLine, excelTemplate.DataStartLine, ms);
|
}
|
else
|
{
|
ExcelUtil.ToExcel(headers, data, sheetName, ms);
|
}
|
ms.Position = 0;
|
var fileName = HttpUtility.UrlEncode($"{sheetName}[{DateTimeOffset.Now:yyyy-MM-dd}].xlsx", Encoding.GetEncoding("UTF-8"));
|
return new FileStreamResult(ms, "application/octet-stream") { FileDownloadName = fileName };
|
}
|
}
|
}
|
