// Admin.NET 项目的版æƒã€å•†æ ‡ã€ä¸“利和其他相关æƒåˆ©å‡å—ç›¸åº”æ³•å¾‹æ³•è§„çš„ä¿æŠ¤ã€‚ä½¿ç”¨æœ¬é¡¹ç›®åº”éµå®ˆç›¸å…³æ³•律法规和许å¯è¯çš„è¦æ±‚。 // // 本项目主è¦éµå¾ª MIT 许å¯è¯å’Œ Apache 许å¯è¯ï¼ˆç‰ˆæœ¬ 2.0)进行分å‘和使用。许å¯è¯ä½äºŽæºä»£ç æ ‘æ ¹ç›®å½•ä¸çš„ LICENSE-MIT å’Œ LICENSE-APACHE 文件。 // // ä¸å¾—利用本项目从事å±å®³å›½å®¶å®‰å…¨ã€æ‰°ä¹±ç¤¾ä¼šç§©åºã€ä¾µçŠ¯ä»–äººåˆæ³•æƒç›Šç‰æ³•å¾‹æ³•è§„ç¦æ¢çš„æ´»åЍï¼ä»»ä½•基于本项目二次开å‘è€Œäº§ç”Ÿçš„ä¸€åˆ‡æ³•å¾‹çº çº·å’Œè´£ä»»ï¼Œæˆ‘ä»¬ä¸æ‰¿æ‹…ä»»ä½•è´£ä»»ï¼ namespace Admin.NET.Core.Service; /// <summary> /// 系统异常日志æœåŠ¡ 🧩 /// </summary> [ApiDescriptionSettings(Order = 350)] public class SysLogExService : IDynamicApiController, ITransient { private readonly SqlSugarRepository<SysLogEx> _sysLogExRep; public SysLogExService(SqlSugarRepository<SysLogEx> sysLogExRep) { _sysLogExRep = sysLogExRep; } /// <summary> /// 获å–异常日志分页列表 🔖 /// </summary> /// <returns></returns> [SuppressMonitor] [DisplayName("获å–异常日志分页列表")] public async Task<SqlSugarPagedList<SysLogEx>> Page(PageExLogInput input) { return await _sysLogExRep.AsQueryable() .WhereIF(!string.IsNullOrWhiteSpace(input.StartTime.ToString()), u => u.CreateTime >= input.StartTime) .WhereIF(!string.IsNullOrWhiteSpace(input.EndTime.ToString()), u => u.CreateTime <= input.EndTime) .WhereIF(!string.IsNullOrWhiteSpace(input.Account), u => u.Account == input.Account) .WhereIF(!string.IsNullOrWhiteSpace(input.ControllerName), u => u.ControllerName == input.ControllerName) .WhereIF(!string.IsNullOrWhiteSpace(input.ActionName), u => u.ActionName == input.ActionName) .WhereIF(!string.IsNullOrWhiteSpace(input.RemoteIp), u => u.RemoteIp == input.RemoteIp) .WhereIF(!string.IsNullOrWhiteSpace(input.Elapsed.ToString()), u => u.Elapsed >= input.Elapsed) .WhereIF(!string.IsNullOrWhiteSpace(input.Status) && input.Status == "200", u => u.Status == input.Status) .WhereIF(!string.IsNullOrWhiteSpace(input.Status) && input.Status != "200", u => u.Status != input.Status) //.OrderBy(u => u.CreateTime, OrderByType.Desc) .IgnoreColumns(u => new { u.RequestParam, u.ReturnResult, u.Message }) .OrderBuilder(input) .ToPagedListAsync(input.Page, input.PageSize); } /// <summary> /// 获å–异常日志详情 🔖 /// </summary> /// <returns></returns> [SuppressMonitor] [DisplayName("获å–异常日志详情")] public async Task<SysLogEx> GetDetail(long id) { return await _sysLogExRep.GetFirstAsync(u => u.Id == id); } /// <summary> /// 清空异常日志 🔖 /// </summary> /// <returns></returns> [ApiDescriptionSettings(Name = "Clear"), HttpPost] [DisplayName("清空异常日志")] public void Clear() { _sysLogExRep.AsSugarClient().DbMaintenance.TruncateTable<SysLogEx>(); } /// <summary> /// 导出异常日志 🔖 /// </summary> /// <returns></returns> [ApiDescriptionSettings(Name = "Export"), NonUnify] [DisplayName("导出异常日志")] public async Task<IActionResult> ExportLogEx(LogInput input) { var logExList = await _sysLogExRep.AsQueryable() .WhereIF(!string.IsNullOrWhiteSpace(input.StartTime.ToString()) && !string.IsNullOrWhiteSpace(input.EndTime.ToString()), u => u.CreateTime >= input.StartTime && u.CreateTime <= input.EndTime) .OrderBy(u => u.CreateTime, OrderByType.Desc) .Select<ExportLogDto>().ToListAsync(); IExcelExporter excelExporter = new ExcelExporter(); var res = await excelExporter.ExportAsByteArray(logExList); return new FileStreamResult(new MemoryStream(res), "application/octet-stream") { FileDownloadName = DateTime.Now.ToString("yyyyMMddHHmm") + "异常日志.xlsx" }; } }