| 12345678910111213141516171819202122232425262728293031323334353637383940 |
- using Attribute;
- using Model;
- using Model.Base;
- using Repository;
- using Service;
- using Microsoft.AspNetCore.Mvc;
- using Vo.Admin;
- namespace Services
- {
- /// <summary>
- /// 数据库操作日志Service业务层处理
- /// </summary>
- [AppService(ServiceType = typeof(IDatabaseOperateLogService), ServiceLifetime = LifeTime.Transient)]
- public class DatabaseOperateLogService : BaseService<DatabaseOperateLog>, IDatabaseOperateLogService
- {
- /// <summary>
- /// 数据库操作日志-列表
- /// </summary>
- /// <param name="param">参数请求体</param>
- /// <param name="page">分页参数</param>
- /// <returns>列表</returns>
- public PagedInfo<GetDatabaseOperateLogListVo> getDatabaseOperateLogList([FromQuery] PagerInfo page, [FromQuery] DatabaseOperateLog param)
- {
- //拼装查询条件
- var predicate = Expressionable.Create<DatabaseOperateLog>();
- predicate = predicate.AndIF(param.makeId > 0, m => m.makeId == param.makeId);
- var response = Queryable()
- .Where(predicate.ToExpression())
- .SplitTable(DateTime.Now.AddMonths(-3), DateTime.Now)
- .OrderByDescending(m => m.id)
- .ToPage<DatabaseOperateLog, GetDatabaseOperateLogListVo>(page);
- return response;
- }
- }
- }
|