namespace WCS.Application; /// /// PLC服务 /// [ApiDescriptionSettings(ApplicationConst.GroupName, Order = 100)] public class WcsPlcService : IDynamicApiController, ITransient { private readonly SqlSugarRepository _wcsPlcRep; public WcsPlcService(SqlSugarRepository wcsPlcRep) { _wcsPlcRep = wcsPlcRep; } /// /// 分页查询PLC /// /// /// [HttpPost] [ApiDescriptionSettings(Name = "Page")] [DisplayName("分页查询PLC")] public async Task> Page(PageWcsPlcInput input) { input.SearchKey = input.SearchKey?.Trim(); var query = _wcsPlcRep.AsQueryable() .WhereIF(!string.IsNullOrEmpty(input.SearchKey), u => u.IP.Contains(input.SearchKey) ) .WhereIF(input.PLCType.HasValue, u => u.PLCType == input.PLCType) .WhereIF(!string.IsNullOrWhiteSpace(input.IP), u => u.IP.Contains(input.IP.Trim())) .WhereIF(input.Type.HasValue, u => u.Type == input.Type) .Select(); return await query.OrderBuilder(input).ToPagedListAsync(input.Page, input.PageSize); } /// /// 增加PLC /// /// /// [HttpPost] [ApiDescriptionSettings(Name = "Add")] [DisplayName("增加PLC")] public async Task Add(AddWcsPlcInput input) { var entity = input.Adapt(); await _wcsPlcRep.InsertAsync(entity); return entity.Id; } /// /// 删除PLC /// /// /// [HttpPost] [ApiDescriptionSettings(Name = "Delete")] [DisplayName("删除PLC")] public async Task Delete(DeleteWcsPlcInput input) { var entity = await _wcsPlcRep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002); await _wcsPlcRep.FakeDeleteAsync(entity); //假删除 //await _wcsPlcRep.DeleteAsync(entity); //真删除 } /// /// 更新PLC /// /// /// [HttpPost] [ApiDescriptionSettings(Name = "Update")] [DisplayName("更新PLC")] public async Task Update(UpdateWcsPlcInput input) { var entity = input.Adapt(); await _wcsPlcRep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync(); } /// /// 获取PLC /// /// /// [HttpGet] [ApiDescriptionSettings(Name = "Detail")] [DisplayName("获取PLC")] public async Task Detail([FromQuery] QueryByIdWcsPlcInput input) { return await _wcsPlcRep.GetFirstAsync(u => u.Id == input.Id); } /// /// 获取PLC列表 /// /// /// [HttpGet] [ApiDescriptionSettings(Name = "List")] [DisplayName("获取PLC列表")] public async Task> List([FromQuery] PageWcsPlcInput input) { return await _wcsPlcRep.AsQueryable().Select().ToListAsync(); } }