public void Init(TablePerspective per, ITableStructure table, IDatabaseSource db)
{
per.Select.Columns.NormalizeBaseTables();
cbxReferencedTable.Items.Clear();
m_per = per;
m_db = db;
m_table = table;
foreach (var tbl in AllTables)
{
cbxReferencedTable.Items.Add(tbl);
}
m_filter = per.Conditions.CloneUsingXml();
objectFilterFrame1.Filter = m_filter;
//tbxDatabase.Text = m_per.Conditions.Database;
//chbDatabase.Checked = m_per.Conditions.DatabaseChecked;
//chbDatabaseRegex.Checked = m_per.Conditions.SchemaRegex;
//tbxServer.Text = m_per.Conditions.Server;
//chbServer.Checked = m_per.Conditions.ServerChecked;
//chbServerRegex.Checked = m_per.Conditions.ServerRegex;
//tbxSchema.Text = m_per.Conditions.Schema;
//chbSchema.Checked = m_per.Conditions.SchemaChecked;
//chbSchemaRegex.Checked = m_per.Conditions.SchemaRegex;
//tbxTable.Text = m_per.Conditions.Table;
//chbTable.Checked = m_per.Conditions.TableChecked;
//chbTableRegex.Checked = m_per.Conditions.TableRegex;
//chbColumns.Checked = m_per.Conditions.ColumnsChecked;
//tbxColumns.Text = "";
//if (m_per.Conditions.Columns != null)
//{
// tbxColumns.Text = m_per.Conditions.Columns.CreateDelimitedText("\r\n");
//}
foreach (var rel in m_per.Select.From.Relations)
{
AddRelation(rel);
}
FillAvailableColSources();
var cd = m_per.Select.GetColumnDisplay();
foreach (var col in cd)
{
dataGridViewColumns.Rows.Add(col.ValueRef.Alias ?? "", col.ValueRef.SafeToString(), col.LookupRef.SafeToString());
}
LoadCurrentRelation();
}
public void LoadParts(XmlElement xml, bool select, bool conditions, bool dockpanel)
{
if (conditions)
{
Conditions = new TablePerspectiveConditions();
Conditions.LoadFromXml(xml.FindElement("Conditions"));
}
if (select)
{
Select = new DmlfSelect();
Select.LoadFromXml(xml.FindElement("Select"));
}
if (dockpanel && xml.FindElement("DockPanel") != null)
{
DockPanelDesign = new ReferencesDockPanelDesign();
DockPanelDesign.LoadFromXml(xml.FindElement("DockPanel"));
}
}
private void Initialize()
{
Conditions = new TablePerspectiveConditions();
}
