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);
}
/// <summary>
///加载模板中所有表单的数据项值
/// </summary>
/// <param name="Schemas"></param>
public void InitDataItems()
{
foreach (SheetConfiguration Sheet in Module.Sheets)
{
DataTableSchema DataTable = Sheet.DataTableSchema;
TreeView treeView = WriteToTable_Value_Editor.DropDownControl;
treeView.Nodes.Clear();
if (DataTable.Schema != null)
{
TableDefineInfo TableInfo = DataTable.Schema;
DropDownNode Node = new DropDownNode(TableInfo.GetHashCode(), TableInfo.Description);
Node.Name = TableInfo.Name;
treeView.Nodes.Add(Node);
#region 时间戳字段
DropDownNode SubNode = new DropDownNode((int)DateTime.Now.Ticks, "时间戳");
SubNode.Name = "scts";
FieldInfo fieldInfo = new FieldInfo();
fieldInfo.Name = "scts";
fieldInfo.Text = "时间戳";
SubNode.Tag = fieldInfo;
Node.Nodes.Add(SubNode);
#endregion 时间戳字段
foreach (FieldDefineInfo FieldInfo in TableInfo.FieldInfos)
{
if (!ColumnRegular.JudgeColumnName(FieldInfo.Description))
{
SubNode = new DropDownNode(FieldInfo.GetHashCode(), FieldInfo.Description);
SubNode.Name = FieldInfo.FieldName;
fieldInfo = new FieldInfo();
fieldInfo.Name = FieldInfo.FieldName;
fieldInfo.Text = FieldInfo.Description;
SubNode.Tag = fieldInfo;
Node.Nodes.Add(SubNode);
}
}
}
treeView.ExpandAll();
treeView = ModificationValue_Editor.DropDownControl;
treeView.Nodes.Clear();
if (DataTable.Schema != null)
{
TableDefineInfo TableInfo = DataTable.Schema;
DropDownNode Node = new DropDownNode(TableInfo.GetHashCode(), TableInfo.Description);
Node.Name = TableInfo.Name;
treeView.Nodes.Add(Node);
#region 时间戳字段
DropDownNode SubNode = new DropDownNode((int)DateTime.Now.Ticks, "时间戳");
SubNode.Name = "scts";
FieldInfo fieldInfo = new FieldInfo();
fieldInfo.Name = "scts";
fieldInfo.Text = "时间戳";
SubNode.Tag = fieldInfo;
Node.Nodes.Add(SubNode);
#endregion 时间戳字段
foreach (FieldDefineInfo FieldInfo in TableInfo.FieldInfos)
{
if (!ColumnRegular.JudgeColumnName(FieldInfo.Description))
{
SubNode = new DropDownNode(FieldInfo.GetHashCode(), FieldInfo.Description);
SubNode.Name = FieldInfo.FieldName;
fieldInfo = new FieldInfo();
fieldInfo.Name = FieldInfo.FieldName;
fieldInfo.Text = FieldInfo.Description;
SubNode.Tag = fieldInfo;
Node.Nodes.Add(SubNode);
}
}
}
treeView.ExpandAll();
}
}
