public ActionResult <RightAgeSearchResViewModel> RightAge_OpinionInfo_Search(RightAgeSearchViewModel rightAgeSearchViewModel)
{
var SearchResult = _inhabitantService.RightAgeSearch(rightAgeSearchViewModel);
var Actionresult = _inhabitantFactory.GetRightAgeSearchResViewModel();
Actionresult.baseViewModel.IsSuccess = true;
Actionresult.Data = SearchResult;
Actionresult.baseViewModel.Message = "查询信息成功";
Actionresult.baseViewModel.ResponseCode = 200;
_ILogger.Information("查询信息成功");
return(Ok(Actionresult));
}
/// <summary>
///查询适龄人员
/// </summary>
/// <param name="underAgerSearchViewModel"></param>
/// <returns></returns>
public List <RightAgeSearchMiddle> GetRightAgeSearch(RightAgeSearchViewModel rightAgeSearchViewModel)
{
int SkipNum = rightAgeSearchViewModel.pageViewModel.CurrentPageNum * rightAgeSearchViewModel.pageViewModel.PageSize;
var predicate = SearchRightAgeWhere(rightAgeSearchViewModel);
var predicate1 = SearchRightAgeWhere1(rightAgeSearchViewModel);
var result = DbSet.Include(a => a.InfoRelationShips).ThenInclude(b => b.HouseInfo)
.Where(predicate)
.Select(
p => new RightAgeSearchMiddle()
{
Id = p.Id,
Name = p.Name,
IdNumber = p.IdNumber,
Age = Convert.ToInt32(DateTime.Now.Year.ToString()) - Convert.ToInt32(p.IdNumber.Substring(6, 4)),
Phone = p.Phone,
Area = p.InfoRelationShips.HouseInfo.Area,
BuildingNo = p.InfoRelationShips.HouseInfo.BuildingNo,
UnitNo = p.InfoRelationShips.HouseInfo.UnitNo,
HouseNo = p.InfoRelationShips.HouseInfo.HouseNo
}
)
.ToList();
var result1 = DbSet.Include(a => a.InfoRelationShips).ThenInclude(b => b.HouseInfo)
.Where(predicate1)
.Select(
p => new RightAgeSearchMiddle()
{
Id = p.Id,
Name = p.Name,
IdNumber = p.IdNumber,
Age = Convert.ToInt32(DateTime.Now.Year.ToString()) - Convert.ToInt32(p.IdNumber.Substring(6, 4)),
Phone = p.Phone,
Area = p.InfoRelationShips.HouseInfo.Area,
BuildingNo = p.InfoRelationShips.HouseInfo.BuildingNo,
UnitNo = p.InfoRelationShips.HouseInfo.UnitNo,
HouseNo = p.InfoRelationShips.HouseInfo.HouseNo
}
)
.ToList();
var eee = result.Union(result1).ToList()
.Skip(SkipNum)
.Take(rightAgeSearchViewModel.pageViewModel.PageSize).ToList();
return(eee);
}
private Expression <Func <ResidentInfo, bool> > SearchRightAgeWhere1(RightAgeSearchViewModel rightAgeSearchViewModel)
{
var predicate = WhereExtension.True <ResidentInfo>();//初始化where表达式
if (rightAgeSearchViewModel.Area != "")
{
predicate = predicate.And(p => p.InfoRelationShips.HouseInfo.Area.Equals(rightAgeSearchViewModel.Area));
}
if (rightAgeSearchViewModel.Name != "")
{
predicate = predicate.And(p => p.Name.Equals(rightAgeSearchViewModel.Name));
}
////根据入学年龄查询
predicate = predicate.And(p => (Convert.ToInt32(DateTime.Now.Year.ToString()) - Convert.ToInt32(p.IdNumber.Substring(6, 4))) == 6);
predicate = predicate.And(p => p.Status == "1");
return(predicate);
}
public List <RightAgeSearchMiddle> RightAgeSearch(RightAgeSearchViewModel rightAgeSearchViewModel)
{
return(_inhabitantRepository.GetRightAgeSearch(rightAgeSearchViewModel));
}
