public IEnumerable <T> PagerList <T>(string sql, int pageindex, out int count, string defaultsort = "", IDbDataParameter[] paramters = null) { StringBuilder sqlcountbuilder = new StringBuilder(sql); StringBuilder sqlrownumbuilder = new StringBuilder(sql); SqlHelper.Driver = this; SqlHelper.AddCounter(sqlcountbuilder); SqlHelper.AddPager(pageindex, pagesize, sqlrownumbuilder, defaultsort); if (OrderByName != null) { SqlHelper.AddOrderBy(OrderByName, OrderByOrder == OrderBy.Asc ? true : false, defaultsort, sqlrownumbuilder); } count = Int32.Parse(ExecuteScalar(sqlcountbuilder.ToString(), paramters).ToString()); return(FindAll <T>(sqlrownumbuilder.ToString(), paramters)); }