public DatabaseRetrieveQuery(DatabaseConnectionString dbString, string tableName)
{
base.dbString = dbString;
this.tableName = tableName;
SelectColumn = new ArrayList();
Restrictions = new ArrayList();
}
public DatabaseInsertQuery(DatabaseConnectionString dbString, string tableName)
{
base.dbString = dbString;
this.tableName = tableName;
InsertColName = new ArrayList();
InsertData = new ArrayList();
}
public DatabaseUpdateQuery(DatabaseConnectionString dbString, string tableName, string restriction)
{
base.dbString = dbString;
this.tableName = tableName;
UpdateData = new ArrayList();
this.restriction = restriction;
}
public DatabaseDeleteQuery(string tableName, string restriction)
{
DatabaseHelperSettings settings = new DatabaseHelperSettings();
DatabaseConnectionString dbString = new DatabaseConnectionString(settings.dbHost, settings.dbUsername, settings.dbPassword, settings.dbName);
base.dbString = dbString;
this.tableName = tableName;
this.restriction = base.RealEscapeString(restriction);
}
public DatabaseRetriveQuery(string tableName)
{
DatabaseHelperSettings settings = new DatabaseHelperSettings();
DatabaseConnectionString dbString = new DatabaseConnectionString(settings.dbHost, settings.dbUsername, settings.dbPassword, settings.dbName);
base.dbString = dbString;
this.tableName = tableName;
SelectColumn = new ArrayList();
Restrictions = new ArrayList();
}
public DatabaseInsertQuery(string tableName)
{
DatabaseHelperSettings settings = new DatabaseHelperSettings();
DatabaseConnectionString dbString = new DatabaseConnectionString(settings.dbHost, settings.dbUsername, settings.dbPassword, settings.dbName);
base.dbString = dbString;
this.tableName = tableName;
InsertColName = new ArrayList();
InsertData = new ArrayList();
}
public DatabaseUpdateQuery(string tableName, string restriction)
{
DatabaseHelperSettings settings = new DatabaseHelperSettings();
DatabaseConnectionString dbString = new DatabaseConnectionString(settings.dbHost, settings.dbUsername, settings.dbPassword, settings.dbName);
base.dbString = dbString;
this.tableName = tableName;
UpdateData = new ArrayList();
this.restriction = restriction;
}
public DatabaseDeleteQuery(DatabaseConnectionString dbString, string tableName, string restriction)
{
base.dbString = dbString;
this.tableName = tableName;
this.restriction = base.RealEscapeString(restriction);
}