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