/// <summary>
/// 分页查询数据
/// </summary>
/// <typeparam name="T">实体类类型</typeparam>
/// <param name="connection">数据库连接</param>
/// <param name="strSql">查询语句</param>
/// <param name="orderBy">排序</param>
/// <param name="pageIndex">查询页码</param>
/// <param name="pageSize">每页查询条数</param>
/// <param name="param">参数值</param>
/// <param name="transaction"></param>
/// <param name="buffered"></param>
/// <param name="commandTimeout"></param>
/// <param name="commandType"></param>
/// <returns>分页数据</returns>
/// comment by yepeng
//public static PagedList<T> GetPagedListBySqlText<T>(this IDbConnection connection, string strSql, string orderBy, int pageIndex, int pageSize
// , dynamic param = null, IDbTransaction transaction = null, bool buffered = true, int? commandTimeout = null, CommandType? commandType = null) where T : class,new()
//{
// ISqlAdapter adapter = GetFormatter(connection);
// return adapter.GetPagedListBySqlText<T>(connection, strSql, orderBy, pageIndex, pageSize, param as object, transaction, buffered, commandTimeout, commandType);
//}
/// <summary>
/// 查询TOP数据
/// </summary>
/// <typeparam name="T">实体类类型</typeparam>
/// <param name="dins">数据库操作对象</param>
/// <param name="strSql">查询语句</param>
/// <param name="strSql">排序</param>
/// <param name="pageSize">查询条数</param>
/// <returns>数据</returns>
public static IEnumerable <T> GetTopListBySqlText <T>(this IDbConnection connection, string strSql, string orderBy, int QueryCount
, dynamic param = null, IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = null, CommandType?commandType = null)
{
ISqlAdapter adapter = GetFormatter(connection);
return(adapter.GetTopListBySqlText <T>(connection, strSql, orderBy, QueryCount, param as object, transaction, buffered, commandTimeout, commandType));
}