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)); }