SapBomRecordService.cs 2.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192
  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. namespace ZR.Service.Business
  11. {
  12. /// <summary>
  13. /// 接口管理/SAP关键件清单记录表Service业务层处理
  14. ///
  15. /// @author admin
  16. /// @date 2023-05-05
  17. /// </summary>
  18. [AppService(ServiceType = typeof(ISapBomRecordService), ServiceLifetime = LifeTime.Transient)]
  19. public class SapBomRecordService : BaseService<SapBomRecord>, ISapBomRecordService
  20. {
  21. #region 业务逻辑代码
  22. /// <summary>
  23. /// 查询接口管理/SAP关键件清单记录表列表
  24. /// </summary>
  25. /// <param name="parm"></param>
  26. /// <returns></returns>
  27. public PagedInfo<SapBomRecordDto> GetList(SapBomRecordQueryDto parm)
  28. {
  29. //开始拼装查询条件
  30. var predicate = Expressionable.Create<SapBomRecord>();
  31. //搜索条件查询语法参考Sqlsugar
  32. var response = Queryable()
  33. .Where(predicate.ToExpression())
  34. .ToPage<SapBomRecord, SapBomRecordDto>(parm);
  35. return response;
  36. }
  37. /// <summary>
  38. /// 添加接口管理/SAP关键件清单记录表
  39. /// </summary>
  40. /// <param name="model"></param>
  41. /// <returns></returns>
  42. public int AddSapBomRecord(SapBomRecord model)
  43. {
  44. return Add(model, true);
  45. }
  46. /// <summary>
  47. /// 修改接口管理/SAP关键件清单记录表
  48. /// </summary>
  49. /// <param name="model"></param>
  50. /// <returns></returns>
  51. public int UpdateSapBomRecord(SapBomRecord model)
  52. {
  53. //var response = Update(w => w.Id == model.Id, it => new SapBomRecord()
  54. //{
  55. // BomNo = model.BomNo,
  56. // EquipmentName = model.EquipmentName,
  57. // MakeBy = model.MakeBy,
  58. // MakeTime = model.MakeTime,
  59. // Category = model.Category,
  60. // MaterialCode = model.MaterialCode,
  61. // MaterialName = model.MaterialName,
  62. // MaterialSpec = model.MaterialSpec,
  63. // KeyFlag = model.KeyFlag,
  64. // Qty = model.Qty,
  65. // AssembleQty = model.AssembleQty,
  66. // Result = model.Result,
  67. // UpdateBy = model.UpdateBy,
  68. // UpdateTime = model.UpdateTime,
  69. // Remark = model.Remark,
  70. //});
  71. //return response;
  72. return Update(model, true);
  73. }
  74. /// <summary>
  75. /// 清空接口管理/SAP关键件清单记录表
  76. /// </summary>
  77. /// <returns></returns>
  78. public void TruncateSapBomRecord()
  79. {
  80. Truncate();
  81. }
  82. #endregion
  83. }
  84. }