private void AppendTableByTableName(string TableName, bool IsReferencedTable)
{
if (!HaveTableDiagram(TableName))
{
TableDefineInfo TableDefineInfo = DepositoryTableDefineInfo.GetTableDefineInfo(TableName);
int TableHeight = tableFlow1.FieldHeight;
foreach (FieldDefineInfo fieldInfo in TableDefineInfo.FieldInfos)
{
if (!ColumnRegular.JudgeColumnName(fieldInfo.Description))
{
TableHeight = TableHeight + tableFlow1.FieldHeight;
}
}
Node tableNode = tableFlow1.AddTable(TableDefineInfo.Description, TableLeft, TableTop, TableWidth, TableHeight);
tableNode.Properties["Name"].Value = TableDefineInfo.Name;
tableNode.Properties["Text"].Value = TableDefineInfo.Description;
foreach (FieldDefineInfo fieldInfo in TableDefineInfo.FieldInfos)
{
if (!ColumnRegular.JudgeColumnName(fieldInfo.Description))
{
Node FieldNode = tableFlow1.AddField(tableNode, fieldInfo.Description + "(" + fieldInfo.FieldType.DisplayType + ")", !IsReferencedTable, IsReferencedTable, Color.Transparent);
FieldNode.Properties["Name"].Value = fieldInfo.FieldName;
FieldNode.Properties["Text"].Value = fieldInfo.Description;
FieldNode.Properties["DispType"].Value = fieldInfo.FieldType.DisplayType;
}
}
}
}
private void ReferenceFilterDialog_Load(object sender, EventArgs e)
{
SheetfilterControl.InitializeControls();
ComboBox ComboBoxColumns = SheetfilterControl.ComboBoxColumns;
TableDefineInfo TableInfo = DepositoryTableDefineInfo.GetTableDefineInfo(TableName);
if (TableInfo != null)
{
foreach (FieldDefineInfo Field in TableInfo.FieldInfos)
{
if (!ColumnRegular.JudgeColumnName(Field.Description))
{
ComboBoxColumns.Items.Add(Field);
}
}
}
TreeView filterView = SheetfilterControl.tViewFilters;
filterView.Nodes.Clear();
foreach (DataFilterItem Item in dataFilterCondition.Items)
{
TreeNode Node = new TreeNode();
Node.Text = string.Format("{0} {1}", Item.ConditionalOperator, Item.ToString());
Node.Tag = Item;
filterView.Nodes.Add(Node);
if (Node.Index == 0)
{
Node.Text = Item.ToString();
}
}
SheetfilterControl.Button_Add.Click += new EventHandler(Button_Add_Click);
SheetfilterControl.Button_Delete.Click += new EventHandler(Button_Delete_Click);
}
