public object GetList([FromBody] XPagination page)
{
var whereSql = $"WHERE {(page.IsBackAdmin ? "" : "IsPublished = 1 AND")} IsDeleted=0 AND {page.WhereTags} AND {page.WhereCategory} AND {page.WhereTitle}";
var selectSql = $@"select * from VM_BlogArticle {whereSql}
ORDER BY Id DESC
LIMIT {(page.Page - 1) * page.RowsPerPage},{page.RowsPerPage}";
var countSql = $"SELECT COUNT(1) AS count FROM BlogArticle {whereSql}";
var list = XDataHelper.ExcuteReader <BlogArticle>(selectSql).ToList();
var count = XDataHelper.ExcuteScalar <int>(countSql);
var result = new XResult();
result.Data = new
{
Content = list,
Count = count
};
return(result);
}
public object GetList([FromBody] XPagination page)
{
var whereSql = $"WHERE IsDeleted=0 AND {page.WhereTags} AND {page.WhereCategory}";
var selectSql = $@"SELECT * FROM BlogArticle {whereSql}
ORDER BY Id DESC
LIMIT {page.Index * page.Size},{page.Size}";
var countSql = $"SELECT COUNT(1) AS count FROM BlogArticle {whereSql}";
var list = XDataHelper.ExcuteReader <BlogArticle>(selectSql).ToList();
var count = XDataHelper.ExcuteScalar <int>(countSql);
var result = new XResult();
//C#匿名对象
result.Data = new
{
Content = list,
Count = count
};
return(result);
}
