HdBindRecordService.cs 3.3 KB

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