public List <Health_Info> SearchHealthEveryRegisterInfo(HealthEverySearchViewModel healthEverySearchViewModel) { int SkipNum = healthEverySearchViewModel.pageViewModel.CurrentPageNum * healthEverySearchViewModel.pageViewModel.PageSize; var preciate = SearchLineWhere(healthEverySearchViewModel); return(DbSet.Where(preciate) .Skip(SkipNum) .Take(healthEverySearchViewModel.pageViewModel.PageSize) .OrderByDescending(o => o.Createdate).ToList()); }
public List <HealthEverySearchMiddleModel> SearchHealthEveryRegisterInfo(HealthEverySearchViewModel healthEverySearchViewModel) { var result = healthRepository.SearchHealthEveryRegisterInfo(healthEverySearchViewModel); if (result == null) { return(null); } var searchresult = _IMapper.Map <List <Health_Info>, List <HealthEverySearchMiddleModel> >(result); return(searchresult); }
private Expression <Func <Health_Info, bool> > SearchLineWhere(HealthEverySearchViewModel healthEverySearchViewModel) { var predicate = WhereExtension.True <Health_Info>();//初始化where表达式 predicate = predicate.And(p => p.IdNumber.Trim().Contains(healthEverySearchViewModel.IdNumber.Trim() == "" ? "" : Dtol.Helper.MD5.Md5Hash(healthEverySearchViewModel.IdNumber.Trim()))); predicate = predicate.And(p => p.IsFamilyHot.Contains(healthEverySearchViewModel.IsFamilyHot)); predicate = predicate.And(p => p.IsFamilyThroat.Contains(healthEverySearchViewModel.IsFamilyThroat)); predicate = predicate.And(p => p.IsFamilyWeakt.Contains(healthEverySearchViewModel.IsFamilyWeakt)); predicate = predicate.And(p => p.IsHot.Contains(healthEverySearchViewModel.IsHot)); predicate = predicate.And(p => p.IsThroat.Contains(healthEverySearchViewModel.IsThroat)); predicate = predicate.And(p => p.IsWeak.Contains(healthEverySearchViewModel.IsWeak)); predicate = predicate.And(p => p.IsComeSchool.Contains(healthEverySearchViewModel.IsComeSchool)); predicate = predicate.And(p => p.IsTouch.Contains(healthEverySearchViewModel.IsTouch)); predicate = predicate.And(p => p.Name.Contains(healthEverySearchViewModel.Name)); predicate = predicate.And(p => p.CheckType.Contains(healthEverySearchViewModel.CheckType)); predicate = predicate.And(p => p.Createdate.ToString().Contains(healthEverySearchViewModel.Createdate == null ? "" : healthEverySearchViewModel.Createdate.Value.ToString("yyyy-MM-dd"))); // predicate = predicate.And(p => p.Id==lineSearchViewModel.Id); return(predicate); }
// GET: HealthInfo/Details/5 public ActionResult <HealthInfoEverySearchResModel> SearchHealthRegister(HealthEverySearchViewModel healthInfoSearchViewModel) { HealthInfoEverySearchResModel healthInfoSearchResModel = new HealthInfoEverySearchResModel(); if (healthInfoSearchViewModel.IdNumber.Equals("") || healthInfoSearchViewModel.IdNumber.Equals(null)) { healthInfoSearchResModel.TotalNum = 0; healthInfoSearchResModel.IsSuccess = false; healthInfoSearchResModel.baseViewModel.Message = "参数为空"; healthInfoSearchResModel.baseViewModel.ResponseCode = 210; } else { var result = healthService.SearchHealthEveryRegisterInfo(healthInfoSearchViewModel); healthInfoSearchResModel.healthEverySearchMiddleModels = result; healthInfoSearchResModel.TotalNum = result.Count(); healthInfoSearchResModel.IsSuccess = true; healthInfoSearchResModel.baseViewModel.Message = "查询成功"; healthInfoSearchResModel.baseViewModel.ResponseCode = 200; } return(Ok(healthInfoSearchResModel)); }