|
using AngleSharp.Dom;
|
using Furion.DatabaseAccessor;
|
using Microsoft.AspNetCore.SignalR;
|
|
namespace WCS.Application;
|
|
/// <summary>
|
/// 任务表服务
|
/// </summary>
|
[ApiDescriptionSettings(ApplicationConst.GroupName, Order = 100)]
|
public class WcsTaskService : IDynamicApiController, ITransient
|
{
|
private readonly SqlSugarRepository<WcsTask> _wcsTaskRep;
|
private readonly IHubContext<TaskLogHub, ITaskLogHub> _taskLogHubContext;
|
|
public WcsTaskService(SqlSugarRepository<WcsTask> wcsTaskRep, IHubContext<TaskLogHub, ITaskLogHub> taskLogHubContext)
|
{
|
_wcsTaskRep = wcsTaskRep;
|
_taskLogHubContext = taskLogHubContext;
|
}
|
|
/// <summary>
|
/// 分页查询任务表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "Page")]
|
[DisplayName("分页查询任务表")]
|
public async Task<SqlSugarPagedList<WcsTaskOutput>> Page(PageWcsTaskInput input)
|
{
|
input.SearchKey = input.SearchKey?.Trim();
|
var query = _wcsTaskRep.AsQueryable()
|
.WhereIF(!string.IsNullOrEmpty(input.SearchKey), u =>
|
u.TaskNo.Contains(input.SearchKey)
|
)
|
.WhereIF(!string.IsNullOrWhiteSpace(input.TaskNo), u => u.TaskNo.Contains(input.TaskNo.Trim()))
|
.WhereIF(input.TaskType.HasValue, u => u.TaskType == input.TaskType)
|
.WhereIF(input.Status.HasValue, u => u.Status == input.Status)
|
.Select<WcsTaskOutput>();
|
return await query.OrderBuilder(input).ToPagedListAsync(input.Page, input.PageSize);
|
}
|
|
/// <summary>
|
/// 增加任务表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "Add")]
|
[DisplayName("增加任务表")]
|
public async Task<long> Add(AddWcsTaskInput input)
|
{
|
if(await _wcsTaskRep.AsQueryable().AnyAsync(s => s.TaskNo == input.TaskNo))
|
{
|
throw Oops.Bah("任务号重复");
|
}
|
var entity = input.Adapt<WcsTask>();
|
entity.Origin = "WCS";
|
await _wcsTaskRep.InsertAsync(entity);
|
return entity.Id;
|
}
|
|
/// <summary>
|
/// 删除任务表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "Delete")]
|
[DisplayName("删除任务表")]
|
public async Task Delete(DeleteWcsTaskInput input)
|
{
|
var entity = await _wcsTaskRep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
|
await _wcsTaskRep.FakeDeleteAsync(entity); //假删除
|
//await _wcsTaskRep.DeleteAsync(entity); //真删除
|
}
|
|
/// <summary>
|
/// 更新任务表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "Update")]
|
[DisplayName("更新任务表")]
|
public async Task Update(UpdateWcsTaskInput input)
|
{
|
var entity = input.Adapt<WcsTask>();
|
await _wcsTaskRep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
|
}
|
|
/// <summary>
|
/// 获取任务表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet]
|
[ApiDescriptionSettings(Name = "Detail")]
|
[DisplayName("获取任务表")]
|
public async Task<WcsTask> Detail([FromQuery] QueryByIdWcsTaskInput input)
|
{
|
return await _wcsTaskRep.GetFirstAsync(u => u.Id == input.Id);
|
}
|
|
/// <summary>
|
/// 获取任务表列表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet]
|
[ApiDescriptionSettings(Name = "List")]
|
[DisplayName("获取任务表列表")]
|
public async Task<List<WcsTaskOutput>> List([FromQuery] PageWcsTaskInput input)
|
{
|
return await _wcsTaskRep.AsQueryable().Select<WcsTaskOutput>().ToListAsync();
|
}
|
|
/// <summary>
|
/// 完成/取消任务表
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpPost]
|
[ApiDescriptionSettings(Name = "Finsh")]
|
[DisplayName("完成/取消任务表")]
|
[UnitOfWork]
|
public async Task Finsh(UpdateWcsTaskInput input)
|
{
|
if (input.Status == TaskStatusEnum.Complete || input.Status == TaskStatusEnum.Cancell)
|
{
|
var modTask = await _wcsTaskRep.GetByIdAsync(input.Id);
|
if (modTask.Status > TaskStatusEnum.Doing)
|
throw Oops.Oh("任务状态异常");
|
if (input.Status == TaskStatusEnum.Complete)
|
modTask.IsSuccess = TaskSuccessEnum.Success;
|
else
|
modTask.IsSuccess = TaskSuccessEnum.Fail;
|
modTask.FinishDate = DateTime.Now;
|
modTask.Status = input.Status;
|
await _wcsTaskRep.Context.Updateable(modTask).UpdateColumns(s => new { s.Status, s.IsSuccess, s.FinishDate, s.UpdateTime,s.UpdateUserId,s.UpdateUserName }).ExecuteCommandAsync();
|
//写入任务明细表
|
WcsTaskMonitor modTaskMonitor = new WcsTaskMonitor()
|
{
|
TaskNo = modTask.TaskNo,
|
PlcId = 0,
|
PlcName = "",
|
Status = TaskStatusEnum.Complete,
|
StartLocat = modTask.StartLocate,
|
EndLocat = modTask.EndLocate,
|
InteractiveMsg = input.Status == TaskStatusEnum.Complete ? "任务已手动完成" : "任务已手动取消",
|
PalletNo = modTask.PalletNo
|
};
|
await _wcsTaskRep.Context.Insertable(modTaskMonitor).ExecuteCommandAsync();
|
//await _taskLogHubContext.Clients.All.PublicTask(modTask.Adapt<WcsTaskOutput>());
|
//await _taskLogHubContext.Clients.All.PublicTaskMonitor(modTaskMonitor.Adapt<WcsTaskMonitorOutput>());
|
}
|
else
|
{
|
throw Oops.Oh("任务状态异常");
|
}
|
}
|
|
|
|
}
|
