WEBUI/WMS.BZServices/CP/WeighingResultService.cs

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<BaseWeighingResult> _sysconrepository;

        public WeighingResultService(Repository<BaseWeighingResult> sysconrepository)
        {
            _sysconrepository = sysconrepository;
        }

        public PagedInfo<BaseWeighingResult> GetPageList(Pagination pagination, WeighingResultQueryDto sysconQueryDto)
        {
            var predicate = Expressionable.Create<BaseWeighingResult>();
            //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<BaseWeighingResult, BaseWeighingResult>(pagination);

            return list;
        }
    }
}