/// <summary>
/// 获取列表
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sql">不带条件</param>
/// <param name="page"></param>
/// <returns></returns>
public static Model.Paging GetList <T>(string sql, Model.Paging page)
{
IDbConnection conn = GetConnection();
page.TotalCount = conn.Query <int>(string.Format("select count(1) from ({0}) t", sql)).First();
var list = conn.Query <T>(string.Format("{0} {1} limit {2},{3}", sql, page.Sort, page.StartItemIndex - 1, page.PageSize)).ToList();
page.List = list;
return(page);
}
public static IEnumerable <T> GetList2 <T>(string sql, Model.Paging page)
{
IDbConnection conn = GetConnection();
return(conn.Query <T>(string.Format(sql, page.Sort, page.Sort, page.StartItemIndex, page.PageSize)).ToList());
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="where">条件</param>
/// <param name="page">分页</param>
/// <returns></returns>
public static Model.Paging GetList <T>(string table, string select, string where, Model.Paging page)
{
IDbConnection conn = GetConnection();
page.TotalCount = conn.Query <int>("select count(1) from " + table + " where " + where).First();
var list = conn.Query <T>(string.Format("select {0} from {1} where {2} {3} limit {4},{5}", select, table, where, page.Sort, page.StartItemIndex - 1, page.PageSize)).ToList();
page.List = list;
return(page);
}
