/// <summary>
/// 查询
/// </summary>
/// <param name="activitySearchViewModel"></param>
/// <returns></returns>
public List <ActivitySearchMiddle> Activity_Search(ActivitySearchViewModel activitySearchViewModel)
{
var ActivitySearchResult = _activityRepository.ActivitySerachByWhere(activitySearchViewModel);
var ActivitySearchResultModel = _IMapper.Map <List <Activity>, List <ActivitySearchMiddle> >(ActivitySearchResult);
return(ActivitySearchResultModel);
}
//根据条件活动
private Expression <Func <Activity, bool> > SearchActivityWhere(ActivitySearchViewModel activitySearchViewModel)
{
var predicate = WhereExtension.True <Activity>();//初始化where表达式
//predicate = predicate.And(p => p.Name.ToString().Contains(buildingSearchViewModel.Name.ToString()));
if (activitySearchViewModel.Title != "")
{
predicate = predicate.And(p => p.Title.Contains(activitySearchViewModel.Title));
}
if (activitySearchViewModel.StartTime != null)
{
predicate = predicate.And(p => activitySearchViewModel.StartTime < p.StartTime);
}
if (activitySearchViewModel.EndTime != null)
{
predicate = predicate.And(p => p.StartTime < activitySearchViewModel.EndTime);
}
if (activitySearchViewModel.Recorder != "")
{
predicate = predicate.And(p => p.Recorder.Contains(activitySearchViewModel.Recorder));
}
//predicate = predicate.And(p => p.ConstructionTime.ToString().c);
predicate = predicate.And(p => p.Status == "1");
return(predicate);
}
public int ActivitySerachByWhereCount(ActivitySearchViewModel activitySearchViewModel)
{
var predicate = SearchActivityWhere(activitySearchViewModel);
var result = DbSet.Where(predicate).Count();
return(result);
}
public ActivitySearchPage()
{
InitializeComponent();
BindingContext = _viewModel = new ActivitySearchViewModel()
{
Navigation = Navigation
};
}
public List <Activity> ActivitySerachByWhere(ActivitySearchViewModel activitySearchViewModel)
{
//查询条件
int SkipNum = activitySearchViewModel.pageViewModel.CurrentPageNum * activitySearchViewModel.pageViewModel.PageSize;
var predicate = SearchActivityWhere(activitySearchViewModel);
var result = DbSet.Where(predicate).ToList()
.Skip(SkipNum)
.Take(activitySearchViewModel.pageViewModel.PageSize)
.OrderBy(o => o.AddTime).ToList();
return(result);
}
public async Task <IActionResult> Index(string keyword, int pageIndex = 1)
{
var pageSize = 20;
var model = new ActivitySearchViewModel
{
Keyword = keyword,
PageIndex = pageIndex,
PageSize = pageSize,
Count = await _activityService.CountAsync(keyword),
Activities = await _activityService.SearchAsync(keyword, pageIndex, pageSize)
};
return(View(model));
}
public ActionResult <ActivitySearchResViewModel> Manage_OpinionInfo_Search(ActivitySearchViewModel activitySearchViewModel)
{
var SearchResult = _activityService.Activity_Search(activitySearchViewModel);
int total = _activityService.Activity_SearchCount(activitySearchViewModel);
var Actionresult = _activityFactory.GetActivitySearchResViewModel();
Actionresult.baseViewModel.IsSuccess = true;
Actionresult.Data = SearchResult;
Actionresult.TotalCount = total;
Actionresult.baseViewModel.Message = "查询信息成功";
Actionresult.baseViewModel.ResponseCode = 200;
_ILogger.Information("查询信息成功");
return(Ok(Actionresult));
}
public int Activity_SearchCount(ActivitySearchViewModel activitySearchViewModel)
{
return(_activityRepository.ActivitySerachByWhereCount(activitySearchViewModel));
}
