//查询身份时 查是该身份的居民
#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));
}
