//根据条件查询用户
private Expression <Func <VolunteerActivity, bool> > SearchVAWhere(VolunteerActivitySearchViewModel VSearchViewModel)
{
var predicate = WhereExtension.True <VolunteerActivity>();//初始化where表达式
if (!String.IsNullOrEmpty(VSearchViewModel.ID))
{
predicate = predicate.And(p => p.ID.Contains(VSearchViewModel.ID));
}
if (!String.IsNullOrEmpty(VSearchViewModel.Title))
{
predicate = predicate.And(p => p.Title.Contains(VSearchViewModel.Title));
}
if (!String.IsNullOrEmpty(VSearchViewModel.CommunityID))
{
predicate = predicate.And(p => p.CommunityID.Contains(VSearchViewModel.CommunityID));
}
if (!String.IsNullOrEmpty(VSearchViewModel.Address))
{
predicate = predicate.And(p => p.Address.Contains(VSearchViewModel.Address));
}
if (!String.IsNullOrEmpty(VSearchViewModel.TypeIDs))
{
predicate = predicate.And(p => p.TypeIDs.Contains(VSearchViewModel.TypeIDs));
}
return(predicate);
}
public List <VolunteerActivityMidModel> SearchList(VolunteerActivitySearchViewModel searchViewModel)
{
List <VolunteerActivity> model = _volunteerActivityRepository.SearchInfoByWhere(searchViewModel);
List <VolunteerActivityMidModel> searchModelList = new List <VolunteerActivityMidModel>();
foreach (var item in model)
{
var searchModel = _IMapper.Map <VolunteerActivity, VolunteerActivityMidModel>(item);
searchModelList.Add(searchModel);
}
return(searchModelList);
}
//根据条件查询
public List <VolunteerActivity> SearchInfoByWhere(VolunteerActivitySearchViewModel VSearchViewModel)
{
int SkipNum = VSearchViewModel.pageViewModel.CurrentPageNum * VSearchViewModel.pageViewModel.PageSize;
//查询条件
var predicate = SearchVolunteerWhere(VSearchViewModel);
var result = DbSet.Where(predicate)
.Skip(SkipNum)
.Take(VSearchViewModel.pageViewModel.PageSize)
.OrderBy(o => o.CreateDate).ToList();
return(result);
}
//根据条件查询用户
private Expression <Func <VolunteerActivity, bool> > SearchVolunteerWhere(VolunteerActivitySearchViewModel VSearchViewModel)
{
var predicate = WhereExtension.True <VolunteerActivity>();//初始化where表达式
predicate = predicate.And(p => p.Status.Equals("1"));
if (VSearchViewModel.Title != "")
{
predicate = predicate.And(p => p.Title.Contains(VSearchViewModel.Title));
}
if (VSearchViewModel.Content != "")
{
predicate = predicate.And(p => p.Content.Contains(VSearchViewModel.Content));
}
if (VSearchViewModel.Type != "")
{
predicate = predicate.And(p => p.Type.Contains(VSearchViewModel.Type));
}
if (VSearchViewModel.CommunityID != "")
{
predicate = predicate.And(p => p.CommunityID.Equals(VSearchViewModel.CommunityID));
}
return(predicate);
}
public int GetAllCount(VolunteerActivitySearchViewModel searchModel)
{
int result = _volunteerActivityRepository.GetVolunteerAll(searchModel).Count();
return(result);
}
public IQueryable <VolunteerActivity> GetAll(VolunteerActivitySearchViewModel VSearchViewModel)
{
var predicate = SearchVolunteerWhere(VSearchViewModel);
return(DbSet.Where(predicate));
}
public ActionResult <VolunteerActivitySearchResModel> Manage_VolunteerActivity_Search(VolunteerActivitySearchViewModel searchModel)
{
VolunteerActivitySearchResModel returnModel = new VolunteerActivitySearchResModel();
var midModel = _volunteerActivityService.SearchList(searchModel);
var totalNum = _volunteerActivityService.GetAllCount(searchModel);
returnModel.IsSuccess = true;
returnModel.TotalNum = totalNum;
returnModel.Activity = midModel;
returnModel.baseViewModel.Message = "查询成功";
returnModel.baseViewModel.ResponseCode = 200;
//_ILogger.Information("查询活动信息成功");
return(Ok(returnModel));
}