// Admin.NET 项目的版æƒã€å•†æ ‡ã€ä¸“利和其他相关æƒåˆ©å‡å—ç›¸åº”æ³•å¾‹æ³•è§„çš„ä¿æŠ¤ã€‚ä½¿ç”¨æœ¬é¡¹ç›®åº”éµå®ˆç›¸å…³æ³•律法规和许å¯è¯çš„è¦æ±‚。
//
// 本项目主è¦éµå¾ª MIT 许å¯è¯å’Œ Apache 许å¯è¯ï¼ˆç‰ˆæœ¬ 2.0)进行分å‘和使用。许å¯è¯ä½äºŽæºä»£ç æ ‘æ ¹ç›®å½•ä¸çš„ LICENSE-MIT å’Œ LICENSE-APACHE 文件。
//
// ä¸å¾—利用本项目从事å±å®³å›½å®¶å®‰å…¨ã€æ‰°ä¹±ç¤¾ä¼šç§©åºã€ä¾µçŠ¯ä»–äººåˆæ³•æƒç›Šç‰æ³•å¾‹æ³•è§„ç¦æ¢çš„æ´»åЍï¼ä»»ä½•基于本项目二次开å‘è€Œäº§ç”Ÿçš„ä¸€åˆ‡æ³•å¾‹çº çº·å’Œè´£ä»»ï¼Œæˆ‘ä»¬ä¸æ‰¿æ‹…任何责任ï¼
namespace Admin.NET.Core.Service;
/// <summary>
/// 系统æ“作日志æœåŠ¡ 🧩
/// </summary>
[ApiDescriptionSettings(Order = 360)]
public class SysLogOpService : IDynamicApiController, ITransient
{
private readonly SqlSugarRepository<SysLogOp> _sysLogOpRep;
public SysLogOpService(SqlSugarRepository<SysLogOp> sysLogOpRep)
{
_sysLogOpRep = sysLogOpRep;
}
/// <summary>
/// èŽ·å–æ“作日志分页列表 🔖
/// </summary>
/// <returns></returns>
[SuppressMonitor]
[DisplayName("èŽ·å–æ“作日志分页列表")]
public async Task<SqlSugarPagedList<SysLogOp>> Page(PageOpLogInput input)
{
return await _sysLogOpRep.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.RemoteIp), u => u.RemoteIp == input.RemoteIp)
.WhereIF(!string.IsNullOrWhiteSpace(input.ControllerName), u => u.ControllerName == input.ControllerName)
.WhereIF(!string.IsNullOrWhiteSpace(input.ActionName), u => u.ActionName == input.ActionName)
.WhereIF(!string.IsNullOrWhiteSpace(input.Elapsed.ToString()), u => u.Elapsed >= input.Elapsed)
//.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<SysLogOp> GetDetail(long id)
{
return await _sysLogOpRep.GetFirstAsync(u => u.Id == id);
}
/// <summary>
/// 清空æ“作日志 🔖
/// </summary>
/// <returns></returns>
[ApiDescriptionSettings(Name = "Clear"), HttpPost]
[DisplayName("清空æ“作日志")]
public void Clear()
{
_sysLogOpRep.AsSugarClient().DbMaintenance.TruncateTable<SysLogOp>();
}
/// <summary>
/// 导出æ“作日志 🔖
/// </summary>
/// <returns></returns>
[ApiDescriptionSettings(Name = "Export"), NonUnify]
[DisplayName("导出æ“作日志")]
public async Task<IActionResult> ExportLogOp(LogInput input)
{
var logOpList = await _sysLogOpRep.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(logOpList);
return new FileStreamResult(new MemoryStream(res), "application/octet-stream") { FileDownloadName = DateTime.Now.ToString("yyyyMMddHHmm") + "æ“作日志.xlsx" };
}
}