OutAssembleRecordService.cs 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  1. using System;
  2. using SqlSugar;
  3. using Infrastructure.Attribute;
  4. using ZR.Model;
  5. using ZR.Model.Dto;
  6. using ZR.Model.Models;
  7. using ZR.Repository;
  8. using ZR.Service.Business.IBusinessService;
  9. using System.Linq;
  10. using Infrastructure;
  11. namespace ZR.Service.Business
  12. {
  13. /// <summary>
  14. /// 出库管理/装配记录表Service业务层处理
  15. ///
  16. /// @author admin
  17. /// @date 2023-04-14
  18. /// </summary>
  19. [AppService(ServiceType = typeof(IOutAssembleRecordService), ServiceLifetime = LifeTime.Transient)]
  20. public class OutAssembleRecordService : BaseService<OutAssembleRecord>, IOutAssembleRecordService
  21. {
  22. #region 业务逻辑代码
  23. /// <summary>
  24. /// 查询出库管理/装配记录表列表
  25. /// </summary>
  26. /// <param name="parm"></param>
  27. /// <returns></returns>
  28. public PagedInfo<OutAssembleRecordDto> GetList(OutAssembleRecordQueryDto parm)
  29. {
  30. //开始拼装查询条件
  31. var predicate = Expressionable.Create<OutAssembleRecord>();
  32. if (parm.BeginTime != null && parm.EndTime != null)
  33. {
  34. parm.BeginTime = DateTimeHelper.GetBeginTime(parm.BeginTime, -1);
  35. parm.EndTime = DateTimeHelper.GetBeginTime(parm.EndTime, 1);
  36. predicate.And(it => it.CreateTime >= parm.BeginTime && it.CreateTime <= parm.EndTime);
  37. }
  38. predicate.AndIF(!string.IsNullOrEmpty(parm.BomNo), it => it.BomNo.Contains(parm.BomNo));
  39. predicate.AndIF(!string.IsNullOrEmpty(parm.MaterialCode), it => it.MaterialCode.Contains(parm.MaterialCode));
  40. predicate.AndIF(!string.IsNullOrEmpty(parm.MaterialName), it => it.MaterialName.Contains(parm.MaterialName));
  41. predicate.AndIF(!string.IsNullOrEmpty(parm.MaterialSpec), it => it.MaterialSpec.Contains(parm.MaterialSpec));
  42. predicate.AndIF(!string.IsNullOrEmpty(parm.BnSnCode), it => it.BnSnCode.Contains(parm.BnSnCode));
  43. predicate.AndIF(!string.IsNullOrEmpty(parm.Category), it => it.Category == parm.Category);
  44. predicate.AndIF(parm.KeyFlag != null, it => it.KeyFlag == parm.KeyFlag);
  45. predicate.AndIF(parm.Result != null, it => it.Result == parm.Result);
  46. //搜索条件查询语法参考Sqlsugar
  47. var response = Queryable()
  48. .Where(predicate.ToExpression())
  49. .ToPage<OutAssembleRecord, OutAssembleRecordDto>(parm);
  50. return response;
  51. }
  52. /// <summary>
  53. /// 添加出库管理/装配记录表
  54. /// </summary>
  55. /// <param name="model"></param>
  56. /// <returns></returns>
  57. public int AddOutAssembleRecord(OutAssembleRecord model)
  58. {
  59. return Add(model, true);
  60. }
  61. /// <summary>
  62. /// 修改出库管理/装配记录表
  63. /// </summary>
  64. /// <param name="model"></param>
  65. /// <returns></returns>
  66. public int UpdateOutAssembleRecord(OutAssembleRecord model)
  67. {
  68. //var response = Update(w => w.AssembleId == model.AssembleId, it => new OutAssembleRecord()
  69. //{
  70. // BomNo = model.BomNo,
  71. // MaterialCode = model.MaterialCode,
  72. // MaterialName = model.MaterialName,
  73. // MaterialSpec = model.MaterialSpec,
  74. // Category = model.Category,
  75. // KeyFlag = model.KeyFlag,
  76. // AssembleQty = model.AssembleQty,
  77. // Picture = model.Picture,
  78. // Result = model.Result,
  79. // UpdateBy = model.UpdateBy,
  80. // UpdateTime = model.UpdateTime,
  81. // Remark = model.Remark,
  82. // BnSnCode = model.BnSnCode,
  83. //});
  84. //return response;
  85. return Update(model, true);
  86. }
  87. /// <summary>
  88. /// 清空出库管理/装配记录表
  89. /// </summary>
  90. /// <returns></returns>
  91. public void TruncateOutAssembleRecord()
  92. {
  93. Truncate();
  94. }
  95. #endregion
  96. }
  97. }