private Expression <Func <Volunteer_Info, bool> > SearchVolunteerForBGWhere(VolunteerInfoSearchViewModel VSearchViewModel) { var predicate = WhereExtension.True <Volunteer_Info>();//初始化where表达式 if (VSearchViewModel.VNO != "") { predicate = predicate.And(p => p.VNO.Equals(VSearchViewModel.VNO)); } if (VSearchViewModel.Name != "") { predicate = predicate.And(p => p.Name.Contains(VSearchViewModel.Name)); } if (VSearchViewModel.CommunityID != "") { predicate = predicate.And(p => p.CommunityID.Equals(VSearchViewModel.CommunityID)); } if (VSearchViewModel.Gender != "") { predicate = predicate.And(p => p.Gender.Contains(VSearchViewModel.Gender)); } if (VSearchViewModel.Political != "") { predicate = predicate.And(p => p.Political.Contains(VSearchViewModel.Political)); } return(predicate); }
public List <Volunteer_Info> SearchInfoByWhereForBackGround(VolunteerInfoSearchViewModel VSearchViewModel) { #region 未使用 //var dtValue = DbSet.Where(t => 1 == 1); //if (VSearchViewModel.VNO != "") // dtValue = dtValue.Where(t => t.VNO.Equals(VSearchViewModel.VNO)); //if (VSearchViewModel.Name != "") // dtValue = dtValue.Where(t => t.Name.Contains(VSearchViewModel.Name)); //if (VSearchViewModel.CommunityID != "") // dtValue = dtValue.Where(t => t.CommunityID.Equals(VSearchViewModel.CommunityID)); //if (VSearchViewModel.Gender != "") // dtValue = dtValue.Where(t => t.Gender.Equals(VSearchViewModel.Gender)); //if (VSearchViewModel.Political != "") // dtValue = dtValue.Where(t => t.Political.Contains(VSearchViewModel.Political)); ////test.OrderBy(o => o.CreateDate).ToList(); ////var predicate = SearchVolunteerForBGWhere(VSearchViewModel); //var result = dtValue.OrderBy(o => o.CreateDate).ToList(); #endregion int SkipNum = VSearchViewModel.pageViewModel.CurrentPageNum * VSearchViewModel.pageViewModel.PageSize; //查询条件 var predicate = SearchVolunteerForBGWhere(VSearchViewModel); var result = DbSet.Where(predicate) .Skip(SkipNum) .Take(VSearchViewModel.pageViewModel.PageSize) .OrderBy(o => o.CreateDate).ToList(); return(result); }
public ActionResult <VolunteerSearchResModel> Manage_GetVolunteerInfoList(VolunteerInfoSearchViewModel volunteer_SearchModel) { VolunteerSearchResModel v_ResModle = new VolunteerSearchResModel(); var searchMidModel = _volunteerService.Volunteer_SearchForBG(volunteer_SearchModel); var totalNum = _volunteerService.GetAllCount(volunteer_SearchModel); v_ResModle.Volunteer_Infos = searchMidModel; v_ResModle.isSuccess = true; v_ResModle.baseViewModel.Message = "查询成功"; v_ResModle.baseViewModel.ResponseCode = 200; v_ResModle.TotalNum = totalNum; return(Ok(v_ResModle)); }
public List <VolunteerSearchMiddle> Volunteer_SearchForBG(VolunteerInfoSearchViewModel VSearchViewModel) { List <Volunteer_Info> user_Infos = _IVolunteerInfoRepository.SearchInfoByWhereForBackGround(VSearchViewModel); List <VolunteerSearchMiddle> userSearches = new List <VolunteerSearchMiddle>(); foreach (var item in user_Infos) { var UserSearchMiddlecs = _IMapper.Map <Volunteer_Info, VolunteerSearchMiddle>(item); userSearches.Add(UserSearchMiddlecs); } return(userSearches.Count > 0 ? userSearches : null); }
public IQueryable <Volunteer_Info> GetVolunteerAll(VolunteerInfoSearchViewModel VSearchViewModel) { var predicate = SearchVolunteerForBGWhere(VSearchViewModel); return(DbSet.Where(predicate)); }
public int GetAllCount(VolunteerInfoSearchViewModel searchModel) { int result = _IVolunteerInfoRepository.GetVolunteerAll(searchModel).Count(); return(result); }