HdDepositRecordService.cs 3.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  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(IHdDepositRecordService), ServiceLifetime = LifeTime.Transient)]
  14. public class HdDepositRecordService : BaseService<HdDepositRecord>, IHdDepositRecordService
  15. {
  16. /// <summary>
  17. /// 好哒押金记录-列表
  18. /// </summary>
  19. /// <param name="param">参数请求体</param>
  20. /// <param name="page">分页参数</param>
  21. /// <returns>列表</returns>
  22. public PagedInfo<GetHdDepositRecordListVo> getHdDepositRecordList([FromQuery] PagerInfo page, [FromQuery] HdDepositRecord param)
  23. {
  24. //拼装查询条件
  25. var predicate = Expressionable.Create<HdDepositRecord>();
  26. predicate = predicate.AndIF(!string.IsNullOrEmpty(param.effectiveTime), m => m.effectiveTime.Contains(param.effectiveTime));
  27. predicate = predicate.AndIF(!string.IsNullOrEmpty(param.settleType), m => m.settleType.Contains(param.settleType));
  28. predicate = predicate.AndIF(!string.IsNullOrEmpty(param.channelKind), m => m.channelKind.Contains(param.channelKind));
  29. predicate = predicate.AndIF(!string.IsNullOrEmpty(param.snNo), m => m.snNo.Contains(param.snNo));
  30. predicate = predicate.AndIF(!string.IsNullOrEmpty(param.depositAmount), m => m.depositAmount.Contains(param.depositAmount));
  31. predicate = predicate.AndIF(!string.IsNullOrEmpty(param.activityId), m => m.activityId.Contains(param.activityId));
  32. predicate = predicate.AndIF(!string.IsNullOrEmpty(param.mchtNm), m => m.mchtNm.Contains(param.mchtNm));
  33. predicate = predicate.AndIF(!string.IsNullOrEmpty(param.mchtNo), m => m.mchtNo.Contains(param.mchtNo));
  34. var response = Queryable()
  35. .Where(predicate.ToExpression())
  36. .SplitTable(DateTime.Now.AddMonths(-3), DateTime.Now)
  37. .OrderByDescending(m => m.id)
  38. .ToPage<HdDepositRecord, GetHdDepositRecordListVo>(page);
  39. return response;
  40. }
  41. /// <summary>
  42. /// 好哒押金记录-详情
  43. /// </summary>
  44. /// <param name="id">ID</param>
  45. /// <returns>详情</returns>
  46. public HdDepositRecord getHdDepositRecordQuery(long id)
  47. {
  48. //拼装查询条件
  49. var predicate = Expressionable.Create<HdDepositRecord>();
  50. predicate = predicate.AndIF(id > 0, m => m.id == id);
  51. var response = Queryable()
  52. .Where(predicate.ToExpression())
  53. .SplitTable(DateTime.Now.AddMonths(-3), DateTime.Now)
  54. .First();
  55. return response;
  56. }
  57. /// <summary>
  58. /// 好哒押金记录-添加
  59. /// </summary>
  60. /// <param name="param">参数请求体</param>
  61. /// <returns>添加</returns>
  62. public long addHdDepositRecord([FromBody] HdDepositRecord param)
  63. {
  64. return Insertable(param).SplitTable().ExecuteReturnSnowflakeId();
  65. }
  66. /// <summary>
  67. /// 好哒押金记录-修改
  68. /// </summary>
  69. /// <param name="param">参数请求体</param>
  70. /// <returns>修改</returns>
  71. public long updateHdDepositRecord([FromBody] HdDepositRecord param)
  72. {
  73. return Context.Updateable(param).SplitTable().ExecuteCommand();
  74. }
  75. /// <summary>
  76. /// 好哒押金记录-删除
  77. /// </summary>
  78. /// <param name="id">ID</param>
  79. /// <returns>删除</returns>
  80. public long deleteHdDepositRecord(long id)
  81. {
  82. return Context.Deleteable<HdDepositRecord>(id).SplitTable().ExecuteCommand();
  83. }
  84. }
  85. }