using Infrastructure; using Infrastructure.Attribute; using Infrastructure.Constant; using Infrastructure.Enums; using Infrastructure.Model; using Mapster; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.SignalR; using SqlSugar; using ZR.Admin.WebApi.Extensions; using ZR.Admin.WebApi.Filters; using ZR.Admin.WebApi.Hubs; using ZR.Common; using ZR.Model.System; using ZR.Model.System.Dto; using ZR.Service.System.IService; namespace ZR.Admin.WebApi.Controllers.System { /// /// 系统通知 /// [Verify] [Route("system/notice")] public class SysNoticeController : BaseController { /// /// 通知公告表接口 /// private readonly ISysNoticeService _SysNoticeService; private readonly IHubContext _hubContext; public SysNoticeController(ISysNoticeService SysNoticeService, IHubContext hubContext) { _SysNoticeService = SysNoticeService; _hubContext = hubContext; } /// /// 查询通知公告表列表 /// /// [HttpGet("queryNotice")] public IActionResult QueryNotice([FromQuery] SysNoticeQueryDto parm) { var predicate = Expressionable.Create(); predicate = predicate.And(m => m.Status == "0"); var response = _SysNoticeService.GetPages(predicate.ToExpression(), parm); return SUCCESS(response); } /// /// 查询通知公告表列表 /// /// [HttpGet("list")] [ActionPermissionFilter(Permission = "system:notice:list")] public IActionResult QuerySysNotice([FromQuery] SysNoticeQueryDto parm) { var predicate = Expressionable.Create(); predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.NoticeTitle), m => m.NoticeTitle.Contains(parm.NoticeTitle)); predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.NoticeType), m => m.NoticeType == parm.NoticeType); predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.CreateBy), m => m.Create_by.Contains(parm.CreateBy) || m.Update_by.Contains(parm.CreateBy)); predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.Status), m => m.Status == parm.Status); var response = _SysNoticeService.GetPages(predicate.ToExpression(), parm); return SUCCESS(response); } /// /// 查询通知公告表详情 /// /// /// [HttpGet("{NoticeId}")] [ActionPermissionFilter(Permission = "system:notice:query")] public IActionResult GetSysNotice(int NoticeId) { var response = _SysNoticeService.GetFirst(x => x.NoticeId == NoticeId); return SUCCESS(response); } /// /// 添加通知公告表 /// /// [HttpPost] [ActionPermissionFilter(Permission = "system:notice:add")] [Log(Title = "通知公告表", BusinessType = BusinessType.INSERT)] public IActionResult AddSysNotice([FromBody] SysNoticeDto parm) { if (parm == null) { throw new CustomException("请求参数错误"); } //从 Dto 映射到 实体 var modal = parm.Adapt().ToCreate(HttpContext); modal.Create_by = HttpContext.GetName(); modal.Create_time = DateTime.Now; int result = _SysNoticeService.Insert(modal, it => new { it.NoticeTitle, it.NoticeType, it.NoticeContent, it.Status, it.Remark, it.Create_by, it.Create_time }); return SUCCESS(result); } /// /// 更新通知公告表 /// /// [HttpPut] [ActionPermissionFilter(Permission = "system:notice:update")] [Log(Title = "通知公告表", BusinessType = BusinessType.UPDATE)] public IActionResult UpdateSysNotice([FromBody] SysNoticeDto parm) { if (parm == null) { throw new CustomException("请求实体不能为空"); } //从 Dto 映射到 实体 var model = parm.Adapt().ToUpdate(HttpContext); var response = _SysNoticeService.Update(w => w.NoticeId == model.NoticeId, it => new SysNotice() { //Update 字段映射 NoticeTitle = model.NoticeTitle, NoticeType = model.NoticeType, NoticeContent = model.NoticeContent, Status = model.Status, Remark = model.Remark, Update_by = HttpContext.GetName(), Update_time = DateTime.Now }); return SUCCESS(response); } /// /// 发送通知公告表 /// /// [HttpPut("send/{NoticeId}")] [ActionPermissionFilter(Permission = "system:notice:update")] [Log(Title = "通知公告表", BusinessType = BusinessType.OTHER)] public IActionResult SendNotice(int NoticeId = 0) { if (NoticeId <= 0) { throw new CustomException("请求实体不能为空"); } var response = _SysNoticeService.GetFirst(x => x.NoticeId == NoticeId); if (response != null && response.Status == "0") { _hubContext.Clients.All.SendAsync(HubsConstant.ReceiveNotice, response.NoticeTitle, response.NoticeContent); } return SUCCESS(response); } /// /// 删除通知公告表 /// /// [HttpDelete("{ids}")] [ActionPermissionFilter(Permission = "system:notice:delete")] [Log(Title = "通知公告表", BusinessType = BusinessType.DELETE)] public IActionResult DeleteSysNotice(string ids) { int[] idsArr = Tools.SpitIntArrary(ids); if (idsArr.Length <= 0) { return ToResponse(ApiResult.Error($"删除失败Id 不能为空")); } var response = _SysNoticeService.Delete(idsArr); return SUCCESS(response); } /// /// 通知公告表导出 /// /// [Log(BusinessType = BusinessType.EXPORT, IsSaveResponseData = false, Title = "通知公告表")] [HttpGet("export")] [ActionPermissionFilter(Permission = "system:notice:export")] public IActionResult Export() { var list = _SysNoticeService.GetAll(); string sFileName = ExportExcel(list, "SysNotice", "通知公告表"); return SUCCESS(new { path = "/export/" + sFileName, fileName = sFileName }); } } }