/// <summary>
/// 根据具体房子信息查询
/// </summary>
/// <param name="byHouseInfoSearchResidentViewModel"></param>
/// <returns></returns>
#region
public List <ByHouseInfoSearchResidentMiddle> getByHouseInfoSearchResident(ByHouseInfoSearchResidentViewModel byHouseInfoSearchResidentViewModel)
{
var predicate = ByHouseInfoSearchResidentWhere(byHouseInfoSearchResidentViewModel);
var result = DbSet.Include(a => a.InfoRelationShips).ThenInclude(b => b.HouseInfo)
.Include(a => a.ResidentRelationShips).ThenInclude(b => b.ResidentIdentity)
.Where(predicate)
//.FromSql("", addIdentitySearchResidentViewModel.IdentityName)
.Select(
p => new ByHouseInfoSearchResidentMiddle()
{
Id = p.Id,
Name = p.Name,
Phone = p.Phone,
Minority = p.Minority,
Gender = p.Gender,
Married = p.Married,
Politics = p.Politics,
IdNumber = p.IdNumber,
Company = p.Company,
Address = p.Address,
Province = p.Province,
City = p.City,
County = p.County,
Register = p.Register,
Education = p.Education,
ReligiousBelief = p.ReligiousBelief,
Job = p.Job,
PhotoId = p.PhotoId,
InfoRelationShipId = p.InfoRelationShips.Id,
RelationWithHousehold = p.InfoRelationShips.RelationWithHousehold,
// HouseHolderIdNo = p.InfoRelationShips.ResidentInfo.IdNumber,
HouseHolderIdNo = p.InfoRelationShips.HouseInfo.HouseHolderIdNo,
Area = p.InfoRelationShips.HouseInfo.Area,
BuildingNo = p.InfoRelationShips.HouseInfo.BuildingNo,
UnitNo = p.InfoRelationShips.HouseInfo.UnitNo,
HouseNo = p.InfoRelationShips.HouseInfo.HouseNo
}
)
.ToList();
return(result);
}
private Expression <Func <ResidentInfo, bool> > ByHouseInfoSearchResidentWhere(ByHouseInfoSearchResidentViewModel byHouseInfoSearchResidentViewModel)
{
var predicate = WhereExtension.True <ResidentInfo>();//初始化where表达式
//小区
predicate = predicate.And(p => p.InfoRelationShips.HouseInfo.Area.Equals(byHouseInfoSearchResidentViewModel.Area));
//楼号
predicate = predicate.And(p => p.InfoRelationShips.HouseInfo.BuildingNo.Equals(byHouseInfoSearchResidentViewModel.BuildingNo));
//单元号
predicate = predicate.And(p => p.InfoRelationShips.HouseInfo.UnitNo.Equals(byHouseInfoSearchResidentViewModel.UnitNo));
//门牌号
predicate = predicate.And(p => p.InfoRelationShips.HouseInfo.HouseNo.Equals(byHouseInfoSearchResidentViewModel.HouseNo));
predicate = predicate.And(p => p.Status == "1");
return(predicate);
}
/// <summary>
/// 根据具体房子信息查询
/// </summary>
/// <param name="byHouseInfoSearchResidentViewModel"></param>
/// <returns></returns>
public List<ByHouseInfoSearchResidentMiddle> getByHouseInfoSearchResident(ByHouseInfoSearchResidentViewModel byHouseInfoSearchResidentViewModel)
{
return _baseInfoInhabitantsRepository.getByHouseInfoSearchResident(byHouseInfoSearchResidentViewModel);
}
public ActionResult <ByHouseInfoSearchResidentResViewModel> ByHouseInfoSearchResident_OpinionInfo_Search(ByHouseInfoSearchResidentViewModel byHouseInfoSearchResidentViewModel)
{
var SearchResult = _baseInfoInhabitantsService.getByHouseInfoSearchResident(byHouseInfoSearchResidentViewModel);
var Actionresult = _inhabitantFactory.GetByHouseInfoSearchResidentResViewModel();
Actionresult.baseViewModel.IsSuccess = true;
Actionresult.Data = SearchResult;
Actionresult.baseViewModel.Message = "查询信息成功";
Actionresult.baseViewModel.ResponseCode = 200;
_ILogger.Information("查询信息成功");
return(Ok(Actionresult));
}
