using SqlSugar; using WMS.BZModels; using WMS.BZModels.Dto.CP.WeighingResult; using WMS.BZModels.Models.CP; using WMS.BZSqlSugar; using WMS.Info; namespace WMS.BZServices.CP { public class WeighingResultService { private readonly Repository _sysconrepository; public WeighingResultService(Repository sysconrepository) { _sysconrepository = sysconrepository; } public PagedInfo GetPageList(Pagination pagination, WeighingResultQueryDto sysconQueryDto) { var predicate = Expressionable.Create(); //predicate = predicate.AndIF(!string.IsNullOrEmpty(sysconQueryDto?.KeyWord), m => m.Code.Contains(sysconQueryDto.KeyWord) || m.Name.Contains(sysconQueryDto.KeyWord) || m.SContent.Contains(sysconQueryDto.KeyWord) //|| m.SType.Contains(sysconQueryDto.KeyWord)); predicate = predicate.AndIF(sysconQueryDto.IsOutOfTolerance == 1, m => m.IsOutOfTolerance); predicate = predicate.AndIF(sysconQueryDto.IsOutOfTolerance == 2, m => !m.IsOutOfTolerance); //predicate = predicate.AndIF(!string.IsNullOrEmpty(sysconQueryDto?.Name), m => m.Name.Contains(sysconQueryDto.Name)); //predicate = predicate.And(m => m.SType != "PalletizingType"); var list = _sysconrepository.Queryable().Where(predicate.ToExpression()) .ToPage(pagination); return list; } } }