public List <NornalOndutySearchMiddlecs> NormalizationSeachService(NormalSearchViewModel normalSearchViewModel) { var result = _INormalizationInfoRepository.NormalizationSearch(normalSearchViewModel); var searchresult = _IMapper.Map <List <Normalization_Info>, List <NornalOndutySearchMiddlecs> >(result); return(searchresult); }
public List <Normalization_Info> NormalizationSearch(NormalSearchViewModel normalSearchViewModel) { var preciate = SearchVAWhere(normalSearchViewModel); var result = DbSet.AsQueryable().Where(preciate).ToList(); return(result); }
/// <summary> /// 查询常态化信息 /// </summary> /// <param name="normalSearchViewModel"></param> /// <returns></returns> public ActionResult <NormalClaimsSearhResViewModel> NormalIzationSearch(NormalSearchViewModel normalSearchViewModel) { NormalClaimsSearhResViewModel normalClaimsSearhViewModel = new NormalClaimsSearhResViewModel(); normalClaimsSearhViewModel.nornalOndutySearchMiddlecs = normalizationInfoService.NormalizationSeachService(normalSearchViewModel); normalClaimsSearhViewModel.isSuccess = true; normalClaimsSearhViewModel.baseViewModel.Message = "查询成功"; normalClaimsSearhViewModel.baseViewModel.ResponseCode = 200; normalClaimsSearhViewModel.TotalNum = normalizationInfoService.NormalizationSeachService(normalSearchViewModel).Count(); return(Ok(normalClaimsSearhViewModel)); }
//根据条件查询用户 private Expression <Func <Normalization_Info, bool> > SearchVAWhere(NormalSearchViewModel normalSearchViewModel) { var predicate = WhereExtension.True <Normalization_Info>();//初始化where表达式 // 不显示 已删除的信息 status=3 20191111 ,不显示 居民发布未审核的信息 status=9;审核不通过信息 status=8 (20191120) //predicate = predicate.And(p => p.title.Contains(normalSearchViewModel.title)); predicate = predicate.And(p => p.CommunityNameCode.Contains(normalSearchViewModel.CommunityNameCode)); //predicate = predicate.And(p => p.XiaoCommunityName.Contains(normalSearchViewModel.XiaoCommunityName)); //predicate = predicate.And(p => p.status.Contains(normalSearchViewModel.status)); //predicate = predicate.And(p => p.CheckInTime.Contains(normalSearchViewModel.CheckInTime)); //predicate = predicate.And(p => p.CheckOutTime.Contains(normalSearchViewModel.CheckOutTime)); //predicate = predicate.And(p => p.DutyStartTime.Value.ToString().Contains(normalSearchViewModel.DutyStartTime)); //predicate = predicate.And(p => p.DutyEndTime.Value.ToString().Contains(normalSearchViewModel.DutyEndTime)); return(predicate); }