/// <summary>
///
/// </summary>
/// <param name="sql"></param>
/// <param name="parameterValues"></param>
/// <param name="pagination"></param>
/// <returns></returns>
public static DataTable ExecutePaginationTable(SqlWrap sql, IDictionary <string, object> parameterValues, Pagination pagination)
{
return(ExecutePaginationTable(sql, parameterValues, pagination, null));
}
/// <summary>
/// 通过指定SqlWrap，执行后返回查询数据
/// </summary>
/// <param name="sql"></param>
/// <param name="parameterValues"></param>
/// <param name="pagination"></param>
/// <param name="partitionValues">分区字段值列表</param>
/// <returns></returns>
public static DataTable ExecutePaginationTable(SqlWrap sql, IDictionary <string, object> parameterValues, Pagination pagination, string partitionValues)
{
ArgumentAssertion.IsNotNull(sql, "sql");
var dbProvider = GetDatabaseProvider(sql, partitionValues);
try
{
var dataset = dbProvider.ExecutePaginationTable(sql, parameterValues, pagination);
return(dataset);
}
catch (Exception ex)
{
throw BuildSqlWrapException(ex, sql, parameterValues);
}
}
/// <summary>
///
/// </summary>
/// <param name="sqlName"></param>
/// <param name="parameterValues"></param>
/// <param name="pagination"></param>
/// <param name="partitionValues"></param>
/// <returns></returns>
public static DataTable ExecutePaginationTable(string sqlName, IDictionary <string, object> parameterValues, Pagination pagination, string partitionValues)
{
var sqlWrap = SqlMapping.GetSqlWrap(sqlName);
return(ExecutePaginationTable(sqlWrap, parameterValues, pagination, partitionValues));
}
