/// <summary>
/// constructor for the DataRetriever (used for loading and caching data in DGV VirtualMode)
/// </summary>
/// <param name="DBCon">used DBConnector</param>
/// <param name="m_BaseTableName">name of the table with the base structure</param>
/// <param name="m_DataStatement">sql-statement for loading the data</param>
/// <param name="SortByColumn">column for sorting (must be existingClassification in the base table (m_BaseTableName) and in the 'DataStement')</param>
/// <param name="SortOrder">sort oder</param>
/// <param name="SortOrder">optional blueprint for typed tables</param>
public DataRetriever(SQL.DBConnector DBCon, string BaseTableName, String DataStatement, String SortByColumn, DBConnector.SQLSortOrder SortOrder, DataTable TypeTable = null)
{
m_Command = ((MySqlConnection)DBCon.Connection).CreateCommand();
m_BaseTableName = BaseTableName;
m_DataStatement = DataStatement;
m_ColumnToSortBy = SortByColumn;
m_ColumnSortOrder = SortOrder;
m_PrimaryKey = DBCon.getPrimaryKey(this.m_BaseTableName);
m_TableType = TypeTable;
m_DBCon = DBCon;
if(this.m_PrimaryKey.Count != 1)
throw new Exception("Length of primary key is not '1' (table '" + BaseTableName + "')");
m_MemoryCache = new DataRetrieverCache(this, 50);
}
/// <summary>
/// constructor for the DataRetriever (used for loading and caching data in DGV VirtualMode)
/// </summary>
/// <param name="DBCon">used DBConnector</param>
/// <param name="m_BaseTableName">name of the table with the base structure</param>
/// <param name="m_DataStatement">sql-statement for loading the data</param>
/// <param name="SortByColumn">column for sorting (must be existingClassification in the base table (m_BaseTableName) and in the 'DataStement')</param>
/// <param name="SortOrder">sort oder</param>
/// <param name="SortOrder">optional blueprint for typed tables</param>
public DataRetriever(SQL.DBConnector DBCon, string BaseTableName, string columnStatement, String baseStatement, String SortByColumn, DBConnector.SQLSortOrder SortOrder, System.Windows.Forms.BindingNavigator bindingNavigator, DataTable TypeTable = null)
{
m_Command = ((MySqlConnection)DBCon.Connection).CreateCommand();
m_BaseTableName = BaseTableName;
m_ColumnStatement = columnStatement;
m_BaseStatement = baseStatement;
m_ColumnToSortBy = SortByColumn;
m_ColumnSortOrder = SortOrder;
m_PrimaryKey = DBCon.getPrimaryKey(this.m_BaseTableName);
m_TableType = TypeTable;
m_DBCon = DBCon;
m_BindingNavigator = bindingNavigator;
if (this.m_PrimaryKey.Count != 1)
{
throw new Exception("Length of primary key is not '1' (table '" + BaseTableName + "')");
}
m_MemoryCache = new DataRetrieverCache(this, 50);
}