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(); } }