//查询身份时 查是该身份的居民 #region public List <IdentitySearchResidentMiddle> getIdentitySearchResident(IdentitySearchResidentViewModel identitySearchResidentViewModel) { int SkipNum = identitySearchResidentViewModel.pageViewModel.CurrentPageNum * identitySearchResidentViewModel.pageViewModel.PageSize; var predicate = IdentitySearchResidentWhere(identitySearchResidentViewModel); var result = DbSet.Include(a => a.InfoRelationShips).ThenInclude(b => b.HouseInfo) .Include(a => a.ResidentRelationShips).ThenInclude(b => b.ResidentIdentity) .Where(predicate) .OrderBy(a => a.AddTime) .Select( p => new IdentitySearchResidentMiddle() { Id = p.Id, Name = p.Name, Phone = p.Phone, IdNumber = p.IdNumber, ResidentRelationShipId = p.ResidentRelationShips.Id } ) .ToList() .GroupBy(a => a.Id).Select(a => a.First()).ToList() .Skip(SkipNum) .Take(identitySearchResidentViewModel.pageViewModel.PageSize).ToList(); return(result); }
private Expression <Func <ResidentInfo, bool> > IdentitySearchResidentWhere(IdentitySearchResidentViewModel identitySearchResidentViewModel) { var predicate = WhereExtension.True <ResidentInfo>();//初始化where表达式 if (identitySearchResidentViewModel.IdentityName != "") { predicate = predicate.And(p => p.ResidentRelationShips.ResidentIdentity.IdentityName.Equals(identitySearchResidentViewModel.IdentityName)); } if (identitySearchResidentViewModel.Area != "") { predicate = predicate.And(p => p.InfoRelationShips.HouseInfo.Area.Equals(identitySearchResidentViewModel.Area)); } if (identitySearchResidentViewModel.Name != "") { predicate = predicate.And(p => p.Name.Equals(identitySearchResidentViewModel.Name)); } return(predicate); }
public int getIdentitySearchResidentCount(IdentitySearchResidentViewModel identitySearchResidentViewModel) { var predicate = IdentitySearchResidentWhere(identitySearchResidentViewModel); var result = DbSet.Include(a => a.InfoRelationShips).ThenInclude(b => b.HouseInfo) .Include(a => a.ResidentRelationShips).ThenInclude(b => b.ResidentIdentity) .Where(predicate) .Select( p => new IdentitySearchResidentMiddle() { Id = p.Id, Name = p.Name, Phone = p.Phone, IdNumber = p.IdNumber, ResidentRelationShipId = p.ResidentRelationShips.Id } ) .ToList() .GroupBy(a => a.Id).Select(a => a.First()).ToList() .Count(); return(result); }
public int getIdentitySearchResidentCount(IdentitySearchResidentViewModel identitySearchResidentViewModel) { return _baseInfoInhabitantsRepository.getIdentitySearchResidentCount(identitySearchResidentViewModel); }
/// <summary> /// 查询身份时 查询是该身份的居民 /// </summary> /// <param name="identitySearchResidentViewModel"></param> /// <returns></returns> public List<IdentitySearchResidentMiddle> getIdentitySearchResident(IdentitySearchResidentViewModel identitySearchResidentViewModel) { return _baseInfoInhabitantsRepository.getIdentitySearchResident(identitySearchResidentViewModel); }
public ActionResult <IdentitySearchResidentResViewModel> Identity_OpinionInfo_Search(IdentitySearchResidentViewModel identitySearchResidentViewModel) { var SearchResult = _baseInfoInhabitantsService.getIdentitySearchResident(identitySearchResidentViewModel); int toatal = _baseInfoInhabitantsService.getIdentitySearchResidentCount(identitySearchResidentViewModel); var Actionresult = _inhabitantFactory.GetIdentitySearchResidentResViewModel(); Actionresult.baseViewModel.IsSuccess = true; Actionresult.Data = SearchResult; Actionresult.TotalCount = toatal; Actionresult.baseViewModel.Message = "查询信息成功"; Actionresult.baseViewModel.ResponseCode = 200; _ILogger.Information("查询信息成功"); return(Ok(Actionresult)); }