/// <summary>
/// 搜索活动
/// </summary>
/// <returns></returns>
public ActionResult SearchActivities(ActivityPageOption option)
{
var data = _activityRespository.QueryActivityByPage(option);
return(Json(new DataResult()
{
Data = data,
Status = true,
Notify = "获取成功"
}));
// return Json(new { total=data.DataCount,rows=data.DataSource});
}
public PageInfo <List <Activity> > QueryActivityByPage(ActivityPageOption option)
{
string sqlFilter = option.GetFilterStr;
sqlFilter = string.IsNullOrEmpty(sqlFilter) ? "" : " where " + sqlFilter;
string dataSql = $@"select *
from(
select *,
row_number() over({option.BuildOrderByStr()}) num
from Activity {sqlFilter}
) as tb where {option.BuildRangeStr("num")}";
string countSql = $"select count(*) from Activity {sqlFilter}";
var data = DapperHelper.Instance.Page <Activity>(DbConfig.DbConnStr, $"{dataSql};{countSql}");
return(new PageInfo <List <Activity> >()
{
Total = data.Total,
Rows = data.Data.ToList(),
PageIndex = option.PageIndex,
PageSize = option.PageSize
});
}
