/// <summary> /// 数据集节点上的右键菜单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void contextMenuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { LibTreeNode curentNode = (LibTreeNode)this.treeView1.SelectedNode; switch (e.ClickedItem.Name) { case "CreateDefineTable": //新建自定义表 #region LibTreeNode defTBNode = new LibTreeNode(); defTBNode.NodeId = Guid.NewGuid().ToString(); defTBNode.Name = string.Format("DefineTable{0}", _ds.DefTables.Count + 1); defTBNode.Text = defTBNode.Name; defTBNode.NodeType = NodeType.DefindTable; curentNode.Nodes.Add(defTBNode); DefTBProperty deftbp = new DefTBProperty(defTBNode.NodeId); deftbp.Dock = DockStyle.Fill; this._defTBPropertylst.Add(deftbp); this.splitContainer1.Panel2.Controls.Add(deftbp); LibDefineTable definetb = new LibDefineTable(); definetb.ID = defTBNode.NodeId; definetb.TableName = defTBNode.Name; definetb.DisplayName = defTBNode.Text; _ds.DefTables.Add(definetb); deftbp.SetPropertyValue(definetb, defTBNode); #endregion break; } }
/// <summary>字段节点上的右键菜单</summary> /// <param name="sender"></param> /// <param name="e"></param> private void contextMenuStrip4_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { LibTreeNode curentNode = (LibTreeNode)this.treeView1.SelectedNode; LibDefineTable defineTB = _ds.DefTables.FindFirst("ID", ((LibTreeNode)curentNode.Parent.Parent).NodeId); LibDataTableStruct currentTBStruct = defineTB.TableStruct.FindFirst("ID", ((LibTreeNode)curentNode.Parent).NodeId); switch (e.ClickedItem.Name) { case "deleteField": //删除字段节点 //LibField f= currentTBStruct.Fields.FindFirst("ID", curentNode.NodeId); //currentTBStruct.Fields.Remove(f); currentTBStruct.Fields.Remove("ID", curentNode.NodeId); DefFieldProperty fp = this._fieldPropertylst.FirstOrDefault(i => i.Name == curentNode.NodeId); if (fp != null) { this._fieldPropertylst.Remove(fp); } this.treeView1.Nodes.Remove(curentNode); UpdateTabPageText(); break; } }
/// <summary>自定义表节点上的右键菜单</summary> /// <param name="sender"></param> /// <param name="e"></param> private void contextMenuStrip2_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { LibTreeNode curentNode = (LibTreeNode)this.treeView1.SelectedNode; LibDefineTable currentDefTB = _ds.DefTables.FindFirst("ID", curentNode.NodeId); if (currentDefTB.TableStruct == null) { currentDefTB.TableStruct = new LibCollection <LibDataTableStruct>(); } switch (e.ClickedItem.Name) { case "CreateTableStruct": //新建表结构 #region LibTreeNode tablestruc = new LibTreeNode(); tablestruc.NodeId = Guid.NewGuid().ToString(); tablestruc.Name = string.Format("{0}_TableStruct{1}", currentDefTB.TableName, currentDefTB.TableStruct.Count + 1); tablestruc.Text = tablestruc.Name; tablestruc.NodeType = NodeType.TableStruct; curentNode.Nodes.Add(tablestruc); TBStructProperty tbstructP = new TBStructProperty(tablestruc.NodeId); tbstructP.Dock = DockStyle.Fill; this._tbStructPropertylst.Add(tbstructP); this.splitContainer1.Panel2.Controls.Add(tbstructP); LibDataTableStruct tbstruct = new LibDataTableStruct(); tbstruct.ID = tablestruc.NodeId; tbstruct.Name = tablestruc.Name; tbstruct.DisplayName = tablestruc.Text; tbstruct.Ignore = true; currentDefTB.TableStruct.Add(tbstruct); tbstructP.SetPropertyValue(tbstruct, tablestruc); #endregion break; } }
private void DataSourceControl_Load(object sender, EventArgs e) { _ds = ModelDesignProject.GetDataSourceById(_funNode.Name); //数据集节点 LibTreeNode dsNode = new LibTreeNode(); dsNode.Name = _funNode.Name; dsNode.Text = ReSourceManage.GetResource(NodeType.DefDataSet); dsNode.NodeType = NodeType.DefDataSet; if (_ds.DefTables == null) { _ds.DefTables = new LibCollection <LibDefineTable>(); //自定义表节点 #region LibTreeNode defTBNode = new LibTreeNode(); defTBNode.NodeId = Guid.NewGuid().ToString(); defTBNode.Name = string.Format("{0}", _funNode.Name); defTBNode.Text = string.Format("{0}({1})", _funNode.Text, defTBNode.Name); defTBNode.NodeType = NodeType.DefindTable; dsNode.Nodes.Add(defTBNode); //this._defTBPropertylst = new List<DefTBProperty>(); DefTBProperty deftbp = new DefTBProperty(defTBNode.NodeId); deftbp.Dock = DockStyle.Fill; this._defTBPropertylst.Add(deftbp); this.splitContainer1.Panel2.Controls.Add(deftbp); LibDefineTable definetb = new LibDefineTable(); definetb.ID = defTBNode.NodeId; definetb.TableName = defTBNode.Name; definetb.DisplayName = defTBNode.Text; _ds.DefTables.Add(definetb); deftbp.SetPropertyValue(definetb, defTBNode); #endregion //数据结构表 #region LibTreeNode tablestruc = new LibTreeNode(); tablestruc.NodeId = Guid.NewGuid().ToString(); tablestruc.Name = string.Format("{0}", _funNode.Name); tablestruc.Text = string.Format("{0}-{1}", "数据表", _funNode.Name); tablestruc.NodeType = NodeType.TableStruct; defTBNode.Nodes.Add(tablestruc); //this._tbStructPropertylst = new List<TBStructProperty>(); TBStructProperty tbstructP = new TBStructProperty(tablestruc.NodeId); tbstructP.Dock = DockStyle.Fill; this._tbStructPropertylst.Add(tbstructP); this.splitContainer1.Panel2.Controls.Add(tbstructP); LibDataTableStruct tbstruct = new LibDataTableStruct(); tbstruct.ID = tablestruc.NodeId; tbstruct.Name = tablestruc.Name; tbstruct.DisplayName = tablestruc.Text; definetb.TableStruct = new LibCollection <LibDataTableStruct>(); definetb.TableStruct.Add(tbstruct); tbstructP.SetPropertyValue(tbstruct, tablestruc); #endregion } else { LibTreeNode node = null; LibTreeNode dtstructNode = null; LibTreeNode fieldNode = null; foreach (LibDefineTable item in _ds.DefTables) { node = new LibTreeNode(); node.NodeId = item.ID; node.Name = item.TableName; node.Text = string.Format("{0}({1})", item.DisplayName, item.TableName); node.NodeType = NodeType.DefindTable; dsNode.Nodes.Add(node); if (item.TableStruct != null) { foreach (LibDataTableStruct dtstruct in item.TableStruct) { #region 添加表结构节点 dtstructNode = new LibTreeNode(); dtstructNode.NodeId = dtstruct.ID; dtstructNode.Name = dtstruct.Name; dtstructNode.Text = string.Format("{0}-{1}", "数据表", dtstruct.Name); dtstructNode.NodeType = NodeType.TableStruct; node.Nodes.Add(dtstructNode); #endregion if (dtstruct.Fields != null) { foreach (LibField field in dtstruct.Fields) { #region 添加字段节点 fieldNode = new LibTreeNode(); fieldNode.NodeId = field.ID; fieldNode.Name = field.Name; fieldNode.Text = string.Format("{0}({1})", field.Name, field.DisplayName); fieldNode.NodeType = NodeType.Field; dtstructNode.Nodes.Add(fieldNode); #endregion } } } } } } this.treeView1.Nodes.Add(dsNode); this.treeView1.SelectedNode = dsNode; }
/// <summary> 表结构节点上的右键菜单</summary> /// <param name="sender"></param> /// <param name="e"></param> private void contextMenuStrip3_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { LibTreeNode curentNode = (LibTreeNode)this.treeView1.SelectedNode; LibDefineTable defineTB = _ds.DefTables.FindFirst("ID", ((LibTreeNode)curentNode.Parent).NodeId); LibDataTableStruct currentTBStruct = defineTB.TableStruct.FindFirst("ID", curentNode.NodeId); if (currentTBStruct.Fields == null) { currentTBStruct.Fields = new LibCollection <LibField>(); } switch (e.ClickedItem.Name) { case "CreateField": //新建字段 #region //LibTreeNode fieldNode = new LibTreeNode(); //fieldNode.NodeId = Guid.NewGuid().ToString(); //fieldNode.Name = string.Format("{0}_Field{1}", currentTBStruct.Name, currentTBStruct.Fields.Count + 1); //fieldNode.Text = fieldNode.Name; //fieldNode.NodeType = NodeType.Field; //curentNode.Nodes.Add(fieldNode); //DefFieldProperty fieldP = new DefFieldProperty(fieldNode.NodeId); //fieldP.Dock = DockStyle.Fill; //this._fieldPropertylst.Add(fieldP); //this.splitContainer1.Panel2.Controls.Add(fieldP); //LibField field = new LibField(); //field.ID = fieldNode.NodeId; //field.Name = fieldNode.Name; //field.DisplayName = fieldNode.Text; //currentTBStruct.Fields.Add(field); //fieldP.SetPropertyValue(field, fieldNode); string fieldnm = string.Format("Field{0}", currentTBStruct.Fields.Count + 1); DoCreateField(fieldnm, fieldnm, null, curentNode, currentTBStruct); UpdateTabPageText(); break; #endregion case "CreatesysFields": //添加系统字段 Panel p = new Panel(); p.Dock = DockStyle.Fill; p.Name = "pfieldcollection"; p.AutoScroll = true; ListBox listBox = new ListBox(); listBox.Dock = DockStyle.Fill; listBox.SelectionMode = SelectionMode.MultiExtended; p.Controls.Add(listBox); foreach (LibSysField sysfld in ModelManager.Sysfields) { listBox.Items.Add(sysfld); } FieldCollectionForm fielsform = new FieldCollectionForm(p); DialogResult dialog = fielsform.ShowDialog(this); if (dialog == DialogResult.OK) { foreach (LibSysField item in listBox.SelectedItems) { DoCreateField(string.Empty, string.Empty, item, curentNode, currentTBStruct); } UpdateTabPageText(); } break; } }
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { LibTreeNode libnode = (LibTreeNode)e.Node; if (libnode == null) { return; } bool exists = false; switch (libnode.NodeType) { case NodeType.DefDataSet: if (this._dsProperty == null) { _dsProperty = new DataSourceProperty(); this.splitContainer1.Panel2.Controls.Add(_dsProperty); } SetPanel2ControlsVisible(_dsProperty); _ds.DataSourceName = string.IsNullOrEmpty(_ds.DataSourceName) ? _funNode.Text : _ds.DataSourceName; _ds.Package = string.IsNullOrEmpty(_ds.Package) ? _funNode.Package : _ds.Package; _dsProperty.SetPropertyValue(_ds, libnode); break; case NodeType.DefindTable: if (this._defTBPropertylst != null) { foreach (DefTBProperty item in _defTBPropertylst) { if (string.Compare(item.Name, libnode.NodeId) == 0) { SetPanel2ControlsVisible(item); exists = true; break; } } if (!exists) //还未创建对应的控件 { DefTBProperty deftbp = new DefTBProperty(libnode.NodeId); deftbp.Dock = DockStyle.Fill; this._defTBPropertylst.Add(deftbp); this.splitContainer1.Panel2.Controls.Add(deftbp); deftbp.SetPropertyValue(_ds.DefTables.FindFirst("ID", libnode.NodeId), libnode); SetPanel2ControlsVisible(deftbp); } } break; case NodeType.TableStruct: if (this._tbStructPropertylst != null) { foreach (TBStructProperty item in _tbStructPropertylst) { if (string.Compare(item.Name, libnode.NodeId) == 0) { SetPanel2ControlsVisible(item); exists = true; break; } } if (!exists) //还未创建对应的控件 { TBStructProperty tbstrucp = new TBStructProperty(libnode.NodeId); tbstrucp.Dock = DockStyle.Fill; this._tbStructPropertylst.Add(tbstrucp); this.splitContainer1.Panel2.Controls.Add(tbstrucp); LibDefineTable deftb = _ds.DefTables.FindFirst("ID", ((LibTreeNode)libnode.Parent).NodeId); tbstrucp.SetPropertyValue(deftb.TableStruct.FindFirst("ID", libnode.NodeId), libnode); SetPanel2ControlsVisible(tbstrucp); } } break; case NodeType.Field: if (this._fieldPropertylst != null) { foreach (DefFieldProperty item in _fieldPropertylst) { if (string.Compare(item.Name, libnode.NodeId) == 0) { SetPanel2ControlsVisible(item); exists = true; break; } } if (!exists) //还未创建对应的控件 { DefFieldProperty fieldp = new DefFieldProperty(libnode.NodeId); fieldp.Dock = DockStyle.Fill; this._fieldPropertylst.Add(fieldp); this.splitContainer1.Panel2.Controls.Add(fieldp); LibDefineTable deftb = _ds.DefTables.FindFirst("ID", ((LibTreeNode)libnode.Parent.Parent).NodeId); LibDataTableStruct dtstruct = deftb.TableStruct.FindFirst("ID", ((LibTreeNode)libnode.Parent).NodeId); fieldp.SetPropertyValue(dtstruct.Fields.FindFirst("ID", libnode.NodeId), libnode); SetPanel2ControlsVisible(fieldp); } } break; } }
public override void TextAndBotton_Click(object sender, EventArgs e) { Control ctl = sender as Control; string ctrNm = ctl.Name.Replace(SysConstManage.BtnCtrlNmPrefix, ""); Panel p = new Panel(); p.Dock = DockStyle.Fill; p.Name = "pfieldcollection"; p.AutoScroll = true; ListBox listBox = new ListBox(); listBox.Dock = DockStyle.Fill; p.Controls.Add(listBox); if (string.Compare(ctrNm, "fsfield_FromDataSource") == 0)//来源数据源 { string[] dsarray = ModelManager.GetAllDataSourceNm(string.Empty); if (dsarray != null && dsarray.Length > 0) { foreach (string item in dsarray) { listBox.Items.Add(item); } } FieldCollectionForm fielsform = new FieldCollectionForm(p); DialogResult dialog = fielsform.ShowDialog(this); if (dialog == DialogResult.OK) { if (this.Controls[ctrNm].Text.Trim() != listBox.SelectedItem.ToString()) { foreach (Control c in this.Controls) { if (c.GetType().Equals(typeof(TextBox))) { c.Text = string.Empty; } } this.Controls[ctrNm].Text = listBox.SelectedItem.ToString(); this.entity.FromDataSource = listBox.SelectedItem.ToString(); //this.Controls["fsfield_FromDefindTableNm"].Text = string.Empty; //this.Controls["fsfield_FromStructTableNm"].Text = string.Empty; //this.Controls["fsfield_FromFieldNm"].Text = string.Empty; } } } else if (string.Compare(ctrNm, "fsfield_FromDefindTableNm") == 0)//来源自定义表名 { if (!string.IsNullOrEmpty(this.Controls["fsfield_FromDataSource"].Text)) { this._ds = ModelManager.GetDataSource(this.Controls["fsfield_FromDataSource"].Text); if (this._ds != null && this._ds.DefTables != null) { foreach (LibDefineTable deftb in this._ds.DefTables) { listBox.Items.Add(deftb.TableName); } } } FieldCollectionForm fielsform = new FieldCollectionForm(p); DialogResult dialog = fielsform.ShowDialog(this); if (dialog == DialogResult.OK) { this.Controls[ctrNm].Text = listBox.SelectedItem.ToString(); this.entity.FromDefindTableNm = listBox.SelectedItem.ToString(); } } else if (string.Compare(ctrNm, "fsfield_FromStructTableNm") == 0)//来源数据表名 { if (!string.IsNullOrEmpty(this.Controls["fsfield_FromDefindTableNm"].Text)) { if (_ds == null) { _ds = ModelManager.GetDataSource(this.Controls["fsfield_FromDataSource"].Text); } LibDefineTable deftb = this._ds.DefTables.FindFirst("TableName", this.Controls["fsfield_FromDefindTableNm"].Text.Trim()); if (deftb != null) { foreach (LibDataTableStruct dt in deftb.TableStruct) { listBox.Items.Add(dt.Name); } } } FieldCollectionForm fielsform = new FieldCollectionForm(p); DialogResult dialog = fielsform.ShowDialog(this); if (dialog == DialogResult.OK) { this.Controls[ctrNm].Text = listBox.SelectedItem.ToString(); this.entity.FromStructTableNm = listBox.SelectedItem.ToString(); //foreach (LibDataTableStruct item in ) } } else if (string.Compare(ctrNm, "fsfield_FromFieldNm") == 0 || string.Compare(ctrNm, "fsfield_FromFieldDesc") == 0)//来源字段 { if (!string.IsNullOrEmpty(this.Controls["fsfield_FromStructTableNm"].Text)) { if (_ds == null) { _ds = ModelManager.GetDataSource(this.Controls["fsfield_FromDataSource"].Text); } LibDefineTable deftb = this._ds.DefTables.FindFirst("TableName", this.Controls["fsfield_FromDefindTableNm"].Text.Trim()); LibDataTableStruct dtstruct = deftb.TableStruct.FindFirst("Name", this.Controls["fsfield_FromStructTableNm"].Text.Trim()); if (dtstruct != null) { foreach (LibField f in dtstruct.Fields) { listBox.Items.Add(f.Name); } } } FieldCollectionForm fielsform = new FieldCollectionForm(p); DialogResult dialog = fielsform.ShowDialog(this); if (dialog == DialogResult.OK) { this.Controls[ctrNm].Text = listBox.SelectedItem.ToString(); if (string.Compare(ctrNm, "fsfield_FromFieldNm") == 0) { this.entity.FromFieldNm = listBox.SelectedItem.ToString(); } else { this.entity.FromFieldDesc = listBox.SelectedItem.ToString(); } } } else if (string.Compare(ctrNm, "fsfield_RelateFieldNm") == 0)//关联字段 { Panel p2 = new Panel(); p2.AutoScroll = true; LibDataTableStruct dtstruct = null; List <LibDataTableStruct> list = new List <LibDataTableStruct>(); //List<LibField> fields = new List<LibField>(); if (!string.IsNullOrEmpty(this.Controls["fsfield_FromStructTableNm"].Text)) { if (_ds == null) { _ds = ModelManager.GetDataSource(this.Controls["fsfield_FromDataSource"].Text); } List <int> indexs = null; foreach (LibDefineTable def in _ds.DefTables) { if (def.TableStruct == null) { continue; } list.AddRange(def.TableStruct.ToArray()); } LibDefineTable deftb = this._ds.DefTables.FindFirst("TableName", this.Controls["fsfield_FromDefindTableNm"].Text.Trim()); dtstruct = deftb.TableStruct.FindFirst("Name", this.Controls["fsfield_FromStructTableNm"].Text.Trim()); if (dtstruct != null) { listBox.SelectionMode = SelectionMode.MultiExtended; foreach (LibField f in dtstruct.Fields) { if (this.entity.RelateFieldNm == null || (this.entity.RelateFieldNm != null && this.entity.RelateFieldNm.FirstOrDefault(i => i.FromTableIndex == dtstruct.TableIndex && i.FieldNm == f.Name) == null)) { listBox.Items.Add(string.Format("{0}{2}{1}", dtstruct.Name, f.Name, SysConstManage.Point)); } } var relatetbs = list.Where(i => i.JoinTableIndex == dtstruct.TableIndex && i.TableIndex != dtstruct.TableIndex && i.Ignore).ToList(); while (relatetbs != null && relatetbs.Count > 0) { indexs = new List <int>(); foreach (LibDataTableStruct tb in relatetbs) { indexs.Add(tb.TableIndex); foreach (LibField f in tb.Fields) { if (this.entity.RelateFieldNm == null || (this.entity.RelateFieldNm != null && this.entity.RelateFieldNm.FirstOrDefault(i => i.FromTableIndex == tb.TableIndex && i.FieldNm == f.Name) == null)) { listBox.Items.Add(string.Format("{0}{2}{1}", tb.Name, f.Name, SysConstManage.Point)); } } } relatetbs = list.Where(i => indexs.Contains(i.JoinTableIndex) && i.TableIndex != i.JoinTableIndex && i.Ignore).ToList(); } } } if (this.entity.RelateFieldNm == null) { this.entity.RelateFieldNm = new List <LibRelateField>(); } RelateFieldControl relateFieldControl = new RelateFieldControl(listBox, list, this.entity.RelateFieldNm); relateFieldControl.Dock = DockStyle.Fill; p2.Controls.Add(relateFieldControl); DialogForm dialogForm = new DialogForm(p2); DialogResult dialog = dialogForm.ShowDialog(this); //FieldCollectionForm fielsform = new FieldCollectionForm(p); //DialogResult dialog = fielsform.ShowDialog(this); if (dialog == DialogResult.OK) { string text = string.Empty; SplitContainer ctr = relateFieldControl.Controls["splitContainer1"] as SplitContainer; foreach (Control c in ctr.Panel2.Controls) { RelateFieldProperty prop = c as RelateFieldProperty; prop.GetControlsValue(); } foreach (LibRelateField field in this.entity.RelateFieldNm) { if (text.Length > 0) { text += SysConstManage.Comma; } text += field.FieldNm; } //if (this.entity.RelateFieldNm == null) this.entity.RelateFieldNm = new List<LibRelateField>(); //this.entity.RelateFieldNm.Clear(); //LibRelateField relateField = null; //string text = string.Empty; //string tablenm = string.Empty; //string fldnm = string.Empty; //string[] array; //foreach (var item in listBox.SelectedItems) //{ // array = item.ToString().Split(SysConstManage.Point); // tablenm = array[0]; // LibDataTableStruct tableStruct = list.FirstOrDefault(i => i.Name == tablenm); // LibField field = tableStruct.Fields.FindFirst("Name", array[1]); // relateField = new LibRelateField(); // relateField.ID = Guid.NewGuid().ToString(); // relateField.FieldNm = field.Name; // relateField.DisplayNm = field.DisplayName; // relateField.AliasName = field.AliasName; // relateField.FieldType = field.FieldType; // relateField.FromTableIndex = tableStruct.TableIndex; // this.entity.RelateFieldNm.Add(relateField); // if (text.Length > 0) { text += SysConstManage.Comma; } // text += field.Name; //} this.Controls[ctrNm].Text = text; } } }