using Admin.NET.Core.Service; using Microsoft.AspNetCore.SignalR; namespace WCS.Application; /// /// 报警信息表服务 /// [ApiDescriptionSettings(ApplicationConst.GroupName, Order = 100)] public class WcsAlarmInfoService : IDynamicApiController, ITransient { private readonly SqlSugarRepository _wcsAlarmInfoRep; private readonly IHubContext _plcHubContext; private readonly SysDictDataService _dictDataService; public WcsAlarmInfoService(SqlSugarRepository wcsAlarmInfoRep, IHubContext plcHubContext, SysDictDataService dictDataService) { _wcsAlarmInfoRep = wcsAlarmInfoRep; _plcHubContext = plcHubContext; _dictDataService = dictDataService; } /// /// 分页查询报警信息表 /// /// /// [HttpPost] [ApiDescriptionSettings(Name = "Page")] [DisplayName("分页查询报警信息表")] public async Task> Page(PageWcsAlarmInfoInput input) { input.SearchKey = input.SearchKey?.Trim(); var query = _wcsAlarmInfoRep.AsQueryable() .WhereIF(!string.IsNullOrEmpty(input.SearchKey), u => u.StationNum.Contains(input.SearchKey) ) .WhereIF(!string.IsNullOrWhiteSpace(input.PlcIP), u => u.PlcIP.Contains(input.PlcIP.Trim())) .WhereIF(input.Status.HasValue, u => u.Status == input.Status) .WhereIF(input.Type.HasValue, u => u.Type == input.Type) .Select(); return await query.OrderBuilder(input).ToPagedListAsync(input.Page, input.PageSize); } /// /// 增加报警信息表 /// /// /// [HttpPost] [ApiDescriptionSettings(Name = "Add")] [DisplayName("增加报警信息表")] public async Task Add(AddWcsAlarmInfoInput input) { var entity = input.Adapt(); entity.Status = YesNoEnum.N; await _wcsAlarmInfoRep.InsertAsync(entity); return entity.Id; } /// /// 删除报警信息表 /// /// /// [HttpPost] [ApiDescriptionSettings(Name = "Delete")] [DisplayName("删除报警信息表")] public async Task Delete(DeleteWcsAlarmInfoInput input) { var entity = await _wcsAlarmInfoRep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002); await _wcsAlarmInfoRep.FakeDeleteAsync(entity); //假删除 //await _wcsAlarmInfoRep.DeleteAsync(entity); //真删除 } /// /// 更新报警信息表 /// /// /// [HttpPost] [ApiDescriptionSettings(Name = "Update")] [DisplayName("更新报警信息表")] public async Task Update(UpdateWcsAlarmInfoInput input) { var entity = input.Adapt(); await _wcsAlarmInfoRep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync(); } /// /// 获取报警信息表 /// /// /// [HttpGet] [ApiDescriptionSettings(Name = "Detail")] [DisplayName("获取报警信息表")] public async Task Detail([FromQuery] QueryByIdWcsAlarmInfoInput input) { return await _wcsAlarmInfoRep.GetFirstAsync(u => u.Id == input.Id); } /// /// 获取报警信息表列表 /// /// /// [HttpGet] [ApiDescriptionSettings(Name = "List")] [DisplayName("获取报警信息表列表")] public async Task> List([FromQuery] PageWcsAlarmInfoInput input) { return await _wcsAlarmInfoRep.AsQueryable() .WhereIF(!input.Status.IsNullOrEmpty(), s => s.Status == input.Status) .Select().ToListAsync(); } /// /// 复位报警 /// /// /// [HttpPost] [ApiDescriptionSettings(Name = "Reset")] [DisplayName("复位报警")] public async Task Reset(ResetInput input) { //测试推数据用的 //await _plcHubContext.Clients.All.PublicAlarm(new List() { new WcsAlarmInfo() { Id = 100, StationNum = "260", AlarmCode = "MB102", AlarmName = "有物品遮挡", AlarmTime = DateTime.Now, Status = YesNoEnum.Y } }); //await _plcHubContext.Clients.All.PublicAlarm(new WcsAlarmInfo() { Id = 100, StationNum = "260", AlarmCode = "MB102", AlarmName = "有物品遮挡", AlarmTime = DateTime.Now, Status = YesNoEnum.Y }); var modPlc = await _wcsAlarmInfoRep.Context.Queryable().Where(s => s.Type == PLCTypeEnum.ConveyorLine && s.Text == (input.layer.ToString() + "层托盘输送线")).FirstAsync(); if (modPlc == null) throw Oops.Bah("未找到输送线PLC"); var listDict = await _dictDataService.GetDataList("reset_alarm"); var value = listDict.FirstOrDefault(s => s.Code == input.layer.ToString()); if (value == null) throw Oops.Bah("未找到复位地址,请在字典管理中设置"); PLCUtil modUtil = new PLCUtil(modPlc); switch (input.layer) { case 1: break; case 2: { modUtil.SetPlcDBValue(PLCDataTypeEnum.Bit, value.Value, "1"); } break; case 3: break; default: break; } modUtil.Close(); } }