/// <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;
}
}
}
