PdaAutoUpdateService.cs 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. using Infrastructure.Attribute;
  2. using SqlSugar;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Linq;
  6. using System.Text;
  7. using System.Threading.Tasks;
  8. using ZR.Model;
  9. using ZR.Model.Dto;
  10. using ZR.Model.Models.Inspect;
  11. using ZR.Model.System;
  12. using ZR.Repository;
  13. using ZR.Service.System.IService;
  14. namespace ZR.Service.System
  15. {
  16. [AppService(ServiceType = typeof(IPdaAutoUpdateService), ServiceLifetime = LifeTime.Transient)]
  17. public class PdaAutoUpdateService : BaseService<PdaAutoUpdate>, IPdaAutoUpdateService
  18. {
  19. #region 依赖注入
  20. public PdaAutoUpdateService()
  21. {
  22. }
  23. #endregion
  24. #region 业务逻辑代码
  25. public int AddPdaAutoUpdate(PdaAutoUpdate model)
  26. {
  27. model.PublishTime = DateTime.Now;
  28. return Add(model, true);
  29. }
  30. public PdaAutoUpdate GetPdaLatestmsg()
  31. {
  32. var response = Queryable()
  33. .OrderByDescending(x => x.Id).First();
  34. return response;
  35. }
  36. #region 2024年3月18日 赵亚雄
  37. /// <summary>
  38. /// 查询列表
  39. /// </summary>
  40. /// <param name="parm"></param>
  41. /// <returns></returns>
  42. public PagedInfo<PdaAutoUpdateDto> GetList(PdaAutoUpdateQueryDto parm)
  43. {
  44. //开始拼装查询条件
  45. var predicate = Expressionable.Create<PdaAutoUpdate>();
  46. predicate.AndIF(parm.BeginTime != null && parm.EndTime != null, q => q.PublishTime > parm.BeginTime && q.PublishTime < parm.EndTime);
  47. predicate.AndIF(!string.IsNullOrEmpty(parm.PackageName), q => q.PackageName.Contains(parm.PackageName));
  48. predicate.AndIF(parm.VersionNo != null, q => q.VersionNo == parm.VersionNo);
  49. predicate.AndIF(!string.IsNullOrEmpty(parm.VersionName), q => q.VersionName.Contains(parm.VersionName));
  50. predicate.AndIF(!string.IsNullOrEmpty(parm.UpdateDetails), q => q.UpdateDetails.Contains(parm.UpdateDetails));
  51. //搜索条件查询语法参考Sqlsugar
  52. var response = Queryable()
  53. .Where(predicate.ToExpression())
  54. .ToPage<PdaAutoUpdate, PdaAutoUpdateDto>(parm);
  55. return response;
  56. }
  57. /// <summary>
  58. /// 修改
  59. /// </summary>
  60. /// <param name="model"></param>
  61. /// <returns></returns>
  62. public int UpdatePdaAutoUpdate(PdaAutoUpdate model)
  63. {
  64. //var response = Update(w => w.Id == model.Id, it => new PdaAutoUpdate()
  65. //{
  66. // PackageName = model.PackageName,
  67. // VersionNo = model.VersionNo,
  68. // VersionName = model.VersionName,
  69. // PublishTime = model.PublishTime,
  70. // UpdateDetails = model.UpdateDetails,
  71. // Remark = model.Remark,
  72. //});
  73. //return response;
  74. return Update(model, true);
  75. }
  76. #endregion
  77. #endregion
  78. }
  79. }