DatabaseMakeLogService.cs 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. using Attribute;
  2. using Model;
  3. using Model.Base;
  4. using Repository;
  5. using Service;
  6. using Microsoft.AspNetCore.Mvc;
  7. using Vo.Admin;
  8. namespace Services
  9. {
  10. /// <summary>
  11. /// 数据库生成日志Service业务层处理
  12. /// </summary>
  13. [AppService(ServiceType = typeof(IDatabaseMakeLogService), ServiceLifetime = LifeTime.Transient)]
  14. public class DatabaseMakeLogService : BaseService<DatabaseMakeLog>, IDatabaseMakeLogService
  15. {
  16. /// <summary>
  17. /// 数据库生成日志-列表
  18. /// </summary>
  19. /// <param name="param">参数请求体</param>
  20. /// <param name="page">分页参数</param>
  21. /// <returns>列表</returns>
  22. public PagedInfo<GetDatabaseMakeLogListVo> getDatabaseMakeLogList([FromQuery] PagerInfo page, [FromQuery] DatabaseMakeLog param)
  23. {
  24. //拼装查询条件
  25. var predicate = Expressionable.Create<DatabaseMakeLog>();
  26. predicate = predicate.AndIF(param.makeObject > 0, m => m.makeObject == param.makeObject);
  27. predicate = predicate.AndIF(param.makeObjectId > 0, m => m.makeObjectId == param.makeObjectId);
  28. var response = Queryable()
  29. .Where(predicate.ToExpression())
  30. .SplitTable(DateTime.Now.AddMonths(-3), DateTime.Now)
  31. .OrderByDescending(m => m.id)
  32. .ToPage<DatabaseMakeLog, GetDatabaseMakeLogListVo>(page);
  33. return response;
  34. }
  35. /// <summary>
  36. /// 数据库生成日志-详情
  37. /// </summary>
  38. /// <param name="param">参数请求体</param>
  39. /// <returns>详情</returns>
  40. public DatabaseMakeLog getDatabaseMakeLogQuery([FromQuery] DatabaseMakeLog param)
  41. {
  42. //拼装查询条件
  43. var predicate = Expressionable.Create<DatabaseMakeLog>();
  44. predicate = predicate.AndIF(param.id > 0, m => m.id == param.id);
  45. var response = Queryable()
  46. .Where(predicate.ToExpression())
  47. .SplitTable(DateTime.Now.AddMonths(-3), DateTime.Now)
  48. .First();
  49. return response;
  50. }
  51. }
  52. }