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