public IPagedList <MSDS_Substance_ExposureLimit> Search(Substance_ExposureLimitSearchModel searchModel)
{
var query = _context.MSDS_Substance_ExposureLimit.Where(x =>
(string.IsNullOrEmpty(searchModel.CASCode) || x.CASCode.ToLower().Contains(searchModel.CASCode.ToLower())) &&
(string.IsNullOrEmpty(searchModel.Substance_Name) || x.Substance_Name.ToLower().Contains(searchModel.Substance_Name.ToLower())) &&
(string.IsNullOrEmpty(searchModel.Substance_CN_Name) || x.Substance_CN_Name.Contains(searchModel.Substance_CN_Name))
)
.OrderBy(x => x.Substance_Name);
var count = query.Count();
var result = query.Skip((searchModel.PageIndex - 1) * searchModel.PageSize).Take(searchModel.PageSize).ToList();
return(new PagedList <MSDS_Substance_ExposureLimit>(result, searchModel.PageIndex, searchModel.PageSize, count));
}
public IPagedList <MSDS_Substance_ExposureLimit> Search(Substance_ExposureLimitSearchModel searchModel)
{
return(_repository.Search(searchModel));
}
