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(); } }