WCSCachelinelocService.cs 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. using Mapster;
  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 WMS.BZModels.Dto.KLHC.WCSCachelineDtos;
  9. using WMS.BZModels.Models.KLHC;
  10. using WMS.BZSqlSugar;
  11. namespace WMS.BZServices.KLHC
  12. {
  13. public class WCSCachelinelocService
  14. {
  15. private readonly Repository<WCS_CacheLineLoc> _WCSCachelinelocRepository;
  16. public WCSCachelinelocService(Repository<WCS_CacheLineLoc> wCSCachelinelocRepository)
  17. {
  18. _WCSCachelinelocRepository = wCSCachelinelocRepository;
  19. }
  20. /// <summary>
  21. ///
  22. /// </summary>
  23. /// <param name="ParentTaskCode">缓存id</param>xd
  24. /// <returns></returns>
  25. public IList<WCSCachelinelocDto> GetDtlById(int CacheLineId )
  26. {
  27. var predicate = Expressionable.Create<WCS_CacheLineLoc>();
  28. predicate = predicate.And(m => m.CacheLineId.Equals(CacheLineId));
  29. var query = _WCSCachelinelocRepository.Queryable().Where(predicate.ToExpression()) ;
  30. var lists = query.OrderBy(o => o.XYNo, OrderByType.Asc).ToList().Adapt<List<WCSCachelinelocDto>>();
  31. return lists;
  32. }
  33. }
  34. }