internal static void ExecuteSql2(string Statement)
{
rs2 = new ADORecordSetHelper("");
rs2.Open(Statement, CurrentConnection, LockTypeEnum.adLockPessimistic);
}
/// <summary>
/// Creates a new ADORecordsetHelper using the provided parameters.
/// </summary>
/// <param name="command"></param>
/// <param name="recordsAffected"></param>
/// <param name="factoryName"></param>
/// <returns></returns>
public static ADORecordSetHelper Open(DbCommand command, out long recordsAffected, string factoryName)
{
ADORecordSetHelper recordSet = new ADORecordSetHelper(factoryName);
recordSet.Open(command);
recordsAffected = recordSet.RecordCount;
return recordSet;
}
/// <summary>
/// Returns a new recordset according to the compound statement on the current recordset
/// </summary>
/// <returns>A new open recordset</returns>
public ADORecordSetHelper NextRecordSet()
{
ADORecordSetHelper result = null;
if (commands.Count > 0)
{
result = new ADORecordSetHelper();
result.ProviderFactory = ProviderFactory;
result.DatabaseType = DatabaseType;
result.Open(commands.Dequeue());
result.commands = commands;
}
return result;
}
/// <summary>
/// Creates a new ADORecordsetHelper using the provided parameters.
/// </summary>
/// <param name="SQLstr">The string containing the SQL query to be loaded into this ADORecodsetHelper object.</param>
/// <param name="connection">Connection object to be use by this ADORecordsetHelper.</param>
/// <param name="recordsAffected">Out parameter indicating the amount of records affected by the execution of the “SQLstr” query.</param>
/// <param name="factoryName">The name of the factory to by use by this ADORecordsetHelper object (the name most exist on the configuration xml file).</param>
/// <returns>The new ADORecordsetHelper object.</returns>
public static ADORecordSetHelper Open(String SQLstr, DbConnection connection, out long recordsAffected, String factoryName)
{
ADORecordSetHelper result = new ADORecordSetHelper(factoryName);
result.Open(SQLstr, connection);
recordsAffected = result.RecordCount;
return result;
}