using Admin.NET.Plugin.AiDOP.Dto.S0.Manufacturing; using Admin.NET.Plugin.AiDOP.Dto.S0.Sales; using Admin.NET.Plugin.AiDOP.Entity.S0.Manufacturing; using Admin.NET.Plugin.AiDOP.Infrastructure; namespace Admin.NET.Plugin.AiDOP.Controllers.S0.Manufacturing; [ApiController] [Route("api/s0/manufacturing/element-params")] [AllowAnonymous] [NonUnify] public class AdoS0MfgElementParamsController : ControllerBase { private readonly SqlSugarRepository _rep; public AdoS0MfgElementParamsController(SqlSugarRepository rep) { _rep = rep; } [HttpGet] public async Task GetPagedAsync([FromQuery] AdoS0MfgElementParamQueryDto q) { var page = q.EffectivePage; var pageSize = q.PageSize; (page, pageSize) = PagingGuard.Normalize(page, pageSize); var query = _rep.AsQueryable() .WhereIF(q.CompanyRefId.HasValue, x => x.CompanyRefId == q.CompanyRefId!.Value) .WhereIF(q.FactoryRefId.HasValue, x => x.FactoryRefId == q.FactoryRefId!.Value) .WhereIF(!string.IsNullOrWhiteSpace(q.Keyword), x => x.Code.Contains(q.Keyword!) || x.Name.Contains(q.Keyword!) || (x.ElementCode != null && x.ElementCode.Contains(q.Keyword!)) || (x.ElementName != null && x.ElementName.Contains(q.Keyword!))) .WhereIF(!string.IsNullOrWhiteSpace(q.ElementCategory), x => x.ElementCategory == q.ElementCategory) .WhereIF(q.IsEnabled.HasValue, x => x.IsEnabled == q.IsEnabled!.Value); var total = await query.CountAsync(); var list = await query .OrderByDescending(x => x.CreatedAt) .Skip((page - 1) * pageSize) .Take(pageSize) .ToListAsync(); return Ok(new { total, page, pageSize, list }); } [HttpGet("{id:long}")] public async Task GetAsync(long id) { var item = await _rep.GetByIdAsync(id); return item == null ? NotFound() : Ok(item); } [HttpPost] public async Task CreateAsync([FromBody] AdoS0MfgElementParamUpsertDto dto) { var entity = new AdoS0MfgElementParam { CompanyRefId = dto.CompanyRefId, FactoryRefId = dto.FactoryRefId, ElementCode = dto.ElementCode, ElementName = dto.ElementName, ElementCategory = dto.ElementCategory, Code = dto.Code, Name = dto.Name, ParamType = dto.ParamType, Unit = dto.Unit, StdValue = dto.StdValue, UpperLimit = dto.UpperLimit, LowerLimit = dto.LowerLimit, EnumOptions = dto.EnumOptions, Remark = dto.Remark, IsEnabled = dto.IsEnabled, CreatedAt = DateTime.Now }; await _rep.AsInsertable(entity).ExecuteReturnEntityAsync(); return Ok(entity); } [HttpPut("{id:long}")] public async Task UpdateAsync(long id, [FromBody] AdoS0MfgElementParamUpsertDto dto) { var entity = await _rep.GetByIdAsync(id); if (entity == null) return NotFound(); entity.CompanyRefId = dto.CompanyRefId; entity.FactoryRefId = dto.FactoryRefId; entity.ElementCode = dto.ElementCode; entity.ElementName = dto.ElementName; entity.ElementCategory = dto.ElementCategory; entity.Code = dto.Code; entity.Name = dto.Name; entity.ParamType = dto.ParamType; entity.Unit = dto.Unit; entity.StdValue = dto.StdValue; entity.UpperLimit = dto.UpperLimit; entity.LowerLimit = dto.LowerLimit; entity.EnumOptions = dto.EnumOptions; entity.Remark = dto.Remark; entity.IsEnabled = dto.IsEnabled; entity.UpdatedAt = DateTime.Now; await _rep.AsUpdateable(entity).ExecuteCommandAsync(); return Ok(entity); } [HttpPatch("{id:long}/toggle-enabled")] public async Task ToggleEnabledAsync(long id, [FromBody] AdoS0ToggleEnabledDto dto) { var entity = await _rep.GetByIdAsync(id); if (entity == null) return NotFound(); entity.IsEnabled = dto.IsEnabled; entity.UpdatedAt = DateTime.Now; await _rep.AsUpdateable(entity).ExecuteCommandAsync(); return Ok(entity); } [HttpDelete("{id:long}")] public async Task DeleteAsync(long id) { var item = await _rep.GetByIdAsync(id); if (item == null) return NotFound(); await _rep.DeleteAsync(item); return Ok(new { message = "删除成功" }); } }