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