/// <summary>
/// 根据id查询党员的居民信息
/// </summary>
/// <param name="partyResidentByIdSearchViewModel"></param>
/// <returns></returns>
public PartyResidentByIdSearchMiddle getPartResidentByIdSearch(PartyResidentByIdSearchViewModel partyResidentByIdSearchViewModel)
{
var predicate = SearchPartResidentByIdWhere(partyResidentByIdSearchViewModel);
var result = DbSet
//.Include(a => a.InfoRelationShips).ThenInclude(b => b.HouseInfo)
//.Include(a => a.ResidentRelationShips).ThenInclude(b => b.ResidentIdentity)
.Where(predicate)
.Join(DbSet1, a => a.Id, b => b.ResidentId, (a, b) => new PartyResidentByIdSearchMiddle //inner join
{
Id = a.Id,
Name = a.Name,
Politics = a.Politics,
Gender = a.Gender,
IdNumber = a.IdNumber,
Education = a.Education,
Phone = a.Phone,
Minority = a.Minority,
PartId = b.Id,
JoinPartyTime = b.JoinPartyTime,
PartyJob = b.PartyJob,
Comment = b.Comment
})
.FirstOrDefault();
return(result);
}
private Expression <Func <ResidentInfo, bool> > SearchPartResidentByIdWhere(PartyResidentByIdSearchViewModel partyResidentByIdSearchViewModel)
{
var predicate = WhereExtension.True <ResidentInfo>();//初始化where表达式
if (partyResidentByIdSearchViewModel.Id != null)
{
predicate = predicate.And(p => p.Id.Equals(partyResidentByIdSearchViewModel.Id));
}
predicate = predicate.And(p => p.Status == "1");
return(predicate);
}
/// <summary>
/// 根据id查询党员的居民信息
/// </summary>
/// <param name="partyResidentByIdSearchViewModel"></param>
/// <returns></returns>
public PartyResidentByIdSearchMiddle getPartResidentByIdSearch(PartyResidentByIdSearchViewModel partyResidentByIdSearchViewModel)
{
return(_inhabitantRepository.getPartResidentByIdSearch(partyResidentByIdSearchViewModel));
}
public ActionResult <PartyResidentByIdSearchResViewModel> ByIDSearchResident_OpinionInfo_Search(PartyResidentByIdSearchViewModel partyResidentByIdSearchViewModel)
{
var SearchResult = _inhabitantService.getPartResidentByIdSearch(partyResidentByIdSearchViewModel);
var Actionresult = _inhabitantFactory.GetPartyResidentByIdSearchResViewModel();
Actionresult.baseViewModel.IsSuccess = true;
Actionresult.Data = SearchResult;
Actionresult.baseViewModel.Message = "查询信息成功";
Actionresult.baseViewModel.ResponseCode = 200;
_ILogger.Information("查询信息成功");
return(Ok(Actionresult));
}