using WCS.Application.Service.WcsTaskMonitor.Dto;
namespace WCS.Application;
///
/// 任务明细监控表服务
///
[ApiDescriptionSettings(ApplicationConst.GroupName, Order = 100)]
public class WcsTaskMonitorService : IDynamicApiController, ITransient
{
private readonly SqlSugarRepository _wcsTaskMonitorRep;
public WcsTaskMonitorService(SqlSugarRepository wcsTaskMonitorRep)
{
_wcsTaskMonitorRep = wcsTaskMonitorRep;
}
///
/// 分页查询任务明细监控表
///
///
///
[HttpPost]
[ApiDescriptionSettings(Name = "Page")]
[DisplayName("分页查询任务明细监控表")]
public async Task> Page(PageWcsTaskMonitorInput input)
{
input.SearchKey = input.SearchKey?.Trim();
var query = _wcsTaskMonitorRep.AsQueryable()
.WhereIF(!string.IsNullOrEmpty(input.SearchKey), u =>
u.TaskNo.Contains(input.SearchKey)
)
.WhereIF(!string.IsNullOrWhiteSpace(input.TaskNo), u => u.TaskNo.Contains(input.TaskNo.Trim()))
.LeftJoin((u, plcid) => u.PlcId == plcid.Id)
.Select((u, plcid) => new WcsTaskMonitorOutput2
{
Id = u.Id,
TaskNo = u.TaskNo,
PlcName = plcid.StationNum + "工位," + plcid.Text,
InteractiveMsg = u.InteractiveMsg,
CreateTime = u.CreateTime
})
.OrderByDescending(u=>u.CreateTime);
return await query.OrderBuilder(input,"","").ToPagedListAsync(input.Page, input.PageSize);
}
///
/// 增加任务明细监控表
///
///
///
[HttpPost]
[ApiDescriptionSettings(Name = "Add")]
[DisplayName("增加任务明细监控表")]
public async Task Add(AddWcsTaskMonitorInput input)
{
var entity = input.Adapt();
await _wcsTaskMonitorRep.InsertAsync(entity);
return entity.Id;
}
///
/// 删除任务明细监控表
///
///
///
[HttpPost]
[ApiDescriptionSettings(Name = "Delete")]
[DisplayName("删除任务明细监控表")]
public async Task Delete(DeleteWcsTaskMonitorInput input)
{
var entity = await _wcsTaskMonitorRep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
await _wcsTaskMonitorRep.FakeDeleteAsync(entity); //假删除
//await _wcsTaskMonitorRep.DeleteAsync(entity); //真删除
}
///
/// 更新任务明细监控表
///
///
///
[HttpPost]
[ApiDescriptionSettings(Name = "Update")]
[DisplayName("更新任务明细监控表")]
public async Task Update(UpdateWcsTaskMonitorInput input)
{
var entity = input.Adapt();
await _wcsTaskMonitorRep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
}
///
/// 获取任务明细监控表
///
///
///
[HttpGet]
[ApiDescriptionSettings(Name = "Detail")]
[DisplayName("获取任务明细监控表")]
public async Task Detail([FromQuery] QueryByIdWcsTaskMonitorInput input)
{
return await _wcsTaskMonitorRep.GetFirstAsync(u => u.Id == input.Id);
}
///
/// 获取任务明细监控表列表
///
///
///
[HttpGet]
[ApiDescriptionSettings(Name = "List")]
[DisplayName("获取任务明细监控表列表")]
public async Task> List([FromQuery] PageWcsTaskMonitorInput input)
{
return await _wcsTaskMonitorRep.AsQueryable().Select().ToListAsync();
}
}