/// <summary> /// Remark:获取List列表系列重载方法 /// </summary> #region 获取分页系列重载方法 public static List <T> PageList <T>(int page, int pageSize, string sql, out int recordCount) { int pageIndex = page; using (var db = new PetaDbContext()) { var result = db.Page <T>(pageIndex, pageSize, sql); recordCount = (int)result.TotalItems; return(result.Items); } }
public static List <T> PageList <T>(int page, int pageSize, string sql, out int recordCount, params object[] args) { int pageIndex = page; using (var db = new PetaDbContext()) { //PetaPoco框架自带分页 var result = db.Page <T>(pageIndex, pageSize, sql, args); recordCount = (int)result.TotalItems; return(result.Items); } }