private Expression <Func <StudentRegisterHeath_Info, bool> > SearchLineWhere(HealthInfoSearchViewModel healthInfoSearchViewModel) { var aa = DateTime.Now; var aaaaaaa = aa.ToString(); var predicate = WhereExtension.True <StudentRegisterHeath_Info>();//初始化where表达式 predicate = predicate.And(p => p.Idnumber.Trim().Contains(healthInfoSearchViewModel.Idnumber.Trim() == ""?"":Dtol.Helper.MD5.Md5Hash(healthInfoSearchViewModel.Idnumber.Trim()))); predicate = predicate.And(p => p.IsleaveJin.Contains(healthInfoSearchViewModel.IsleaveJin)); predicate = predicate.And(p => p.IsPassHubei.Contains(healthInfoSearchViewModel.IsPassHubei)); predicate = predicate.And(p => p.PassHubeiDetail.Contains(healthInfoSearchViewModel.IsPassHubei)); predicate = predicate.And(p => p.Peers.Contains(healthInfoSearchViewModel.IsPassHubei)); predicate = predicate.And(p => p.PeersTelephone.Contains(healthInfoSearchViewModel.IsPassHubei)); predicate = predicate.And(p => p.Residencetemporary.Contains(healthInfoSearchViewModel.IsPassHubei)); predicate = predicate.And(p => p.Telephone.Contains(healthInfoSearchViewModel.Telephone)); predicate = predicate.And(p => p.Temperature.Contains(healthInfoSearchViewModel.Temperature)); predicate = predicate.And(p => p.Traffic.Contains(healthInfoSearchViewModel.Traffic)); predicate = predicate.And(p => p.BackJinDate.ToString().Contains(healthInfoSearchViewModel.BackJinDate == null? "": healthInfoSearchViewModel.BackJinDate.Value.ToString("yyyy-MM-dd"))); predicate = predicate.And(p => p.BeforeTianjin.Contains(healthInfoSearchViewModel.Traffic)); predicate = predicate.And(p => p.Guardian.Contains(healthInfoSearchViewModel.Guardian)); predicate = predicate.And(p => p.Destination.Contains(healthInfoSearchViewModel.Destination)); predicate = predicate.And(p => p.ForteenDaysExcepting.Contains(healthInfoSearchViewModel.ForteenDaysExcepting)); predicate = predicate.And(p => p.CreateDate.ToString().Contains(healthInfoSearchViewModel.CreateDate == null ? "" : healthInfoSearchViewModel.CreateDate.Value.ToString("yyyy-MM-dd"))); // predicate = predicate.And(p => p.Id==lineSearchViewModel.Id); return(predicate); }
/// <summary> /// 查询登记健康信息 /// </summary> /// <param name="healthInfoSearchViewModel"></param> /// <returns></returns> public List <HealthInfoSearchMiddle> SearchHealthRegisterInfo(HealthInfoSearchViewModel healthInfoSearchViewModel) { var searchResult = healthRegisterRepository.searchHealthInfo(healthInfoSearchViewModel); var searchresult = _IMapper.Map <List <StudentRegisterHeath_Info>, List <HealthInfoSearchMiddle> >(searchResult); return(searchresult); }
public List <StudentRegisterHeath_Info> searchHealthInfo(HealthInfoSearchViewModel healthInfoSearchViewModel) { int SkipNum = healthInfoSearchViewModel.pageViewModel.CurrentPageNum * healthInfoSearchViewModel.pageViewModel.PageSize; var preciate = SearchLineWhere(healthInfoSearchViewModel); return(DbSet.Where(preciate) .Skip(SkipNum) .Take(healthInfoSearchViewModel.pageViewModel.PageSize) .OrderByDescending(o => o.CreateDate).ToList()); }
// GET: HealthInfo/Details/5 public ActionResult <HealthInfoSearchResModel> SearchHealthRegister(HealthInfoSearchViewModel healthInfoSearchViewModel) { HealthInfoSearchResModel healthInfoSearchResModel = new HealthInfoSearchResModel(); var result = healthRegisterService.SearchHealthRegisterInfo(healthInfoSearchViewModel); healthInfoSearchResModel.healthInfoSearchMiddles = result; healthInfoSearchResModel.TotalNum = result.Count(); healthInfoSearchResModel.IsSuccess = true; healthInfoSearchResModel.baseViewModel.Message = "查询成功"; healthInfoSearchResModel.baseViewModel.ResponseCode = 200; return(Ok(healthInfoSearchResModel)); }