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