/// <summary> /// 添加关联字段 /// </summary> /// <param name="sender">事件发送者</param> /// <param name="e">事件参数</param> private void bAddField_Click(object sender, EventArgs e) { string tableName = ""; List <string> fieldNameList = new List <string>(); Node currentNode = keyFieldTree.SelectedNode; if (currentNode != null) { if (currentNode.Level == 1) { tableName = currentNode.Parent.Text; } else { tableName = currentNode.Text; } } AddFieldRelationForm aForm = new AddFieldRelationForm(conn, tableName, fieldNameList, metaDataTable); if (aForm.ShowDialog() == DialogResult.OK) { tableName = aForm.TableName; foreach (string fieldName in aForm.FieldNameList) { Node tableNode = null; foreach (Node node in keyFieldTree.Nodes) { if (node.Text == tableName) { tableNode = node; break; } } if (tableNode == null) { tableNode = new Node(); tableNode.Text = tableName; tableNode.Tag = tableName; keyFieldTree.Nodes.Add(tableNode); } Node fieldNode = null; foreach (Node node in tableNode.Nodes) { if (node.Text == fieldName) { fieldNode = node; break; } } if (fieldNode == null) { string sqlString = string.Format("INSERT INTO sys_field_relation (TableName, KeyField) VALUES ('{0}', '{1}')", tableName, GetFieldName(fieldName)); Helper.ExecuteCommand("sys_field_relation", sqlString, conn); //ExecuteSqlCommand(sqlString); fieldNode = new Node(); fieldNode.Text = fieldName; fieldNode.Tag = ""; tableNode.Nodes.Add(fieldNode); tableNode.Expand(); } else { MessageBox.Show("当前关联字段已经存在!", "添加关联字段", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }
/// <summary> /// 添加关联字段 /// </summary> /// <param name="sender">事件发送者</param> /// <param name="e">事件参数</param> private void bAddField_Click(object sender, EventArgs e) { string tableName = ""; List<string> fieldNameList = new List<string>(); Node currentNode = keyFieldTree.SelectedNode; if (currentNode != null) { if (currentNode.Level == 1) { tableName = currentNode.Parent.Text; } else { tableName = currentNode.Text; } } AddFieldRelationForm aForm = new AddFieldRelationForm(conn, tableName, fieldNameList, metaDataTable); if (aForm.ShowDialog() == DialogResult.OK) { tableName = aForm.TableName; foreach (string fieldName in aForm.FieldNameList) { Node tableNode = null; foreach (Node node in keyFieldTree.Nodes) { if (node.Text == tableName) { tableNode = node; break; } } if (tableNode == null) { tableNode = new Node(); tableNode.Text = tableName; tableNode.Tag = tableName; keyFieldTree.Nodes.Add(tableNode); } Node fieldNode = null; foreach (Node node in tableNode.Nodes) { if (node.Text == fieldName) { fieldNode = node; break; } } if (fieldNode == null) { string sqlString = string.Format("INSERT INTO sys_field_relation (TableName, KeyField) VALUES ('{0}', '{1}')", tableName, GetFieldName(fieldName)); Helper.ExecuteCommand("sys_field_relation", sqlString, conn); //ExecuteSqlCommand(sqlString); fieldNode = new Node(); fieldNode.Text = fieldName; fieldNode.Tag = ""; tableNode.Nodes.Add(fieldNode); tableNode.Expand(); } else { MessageBox.Show("当前关联字段已经存在!", "添加关联字段", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }
/// <summary> /// 添加关联关系 /// </summary> /// <param name="sender">事件发送者</param> /// <param name="e">事件参数</param> private void bAddRelation_Click(object sender, EventArgs e) { Node keyFieldNode = keyFieldTree.SelectedNode; if (keyFieldNode != null && keyFieldNode.Level == 1) { string tableName = ""; List <string> fieldNameList = new List <string>(); Node tableNode = relationTree.SelectedNode; if (tableNode != null) { if (tableNode.Level == 1) { tableNode = tableNode.Parent; } tableName = tableNode.Text; foreach (Node fieldNode in tableNode.Nodes) { fieldNameList.Add(fieldNode.Text); } } AddFieldRelationForm aForm = new AddFieldRelationForm(conn, tableName, fieldNameList, metaDataTable); if (aForm.ShowDialog() == DialogResult.OK) { tableNode = null; foreach (Node node in relationTree.Nodes) { if (node.Text == aForm.TableName) { tableNode = node; break; } } if (tableNode == null) { tableNode = new Node(); tableNode.Text = aForm.TableName; tableNode.Tag = aForm.TableName; relationTree.Nodes.Add(tableNode); } foreach (string s in aForm.FieldNameList) { bool exist = false; foreach (Node node in tableNode.Nodes) { if (node.Text == s) { exist = true; break; } } if (!exist) { Node fieldNode = new Node(); fieldNode.Text = s; fieldNode.Tag = s; tableNode.Nodes.Add(fieldNode); } } tableNode.Expand(); string relationData = GetRelationData(); UpdateFieldRelationData(relationData); } } else { MessageBox.Show("请先选择要添加关联关系的字段!", "添加关联关系", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// 添加关联关系 /// </summary> /// <param name="sender">事件发送者</param> /// <param name="e">事件参数</param> private void bAddRelation_Click(object sender, EventArgs e) { Node keyFieldNode = keyFieldTree.SelectedNode; if (keyFieldNode != null && keyFieldNode.Level == 1) { string tableName = ""; List<string> fieldNameList = new List<string>(); Node tableNode = relationTree.SelectedNode; if (tableNode != null) { if (tableNode.Level == 1) { tableNode = tableNode.Parent; } tableName = tableNode.Text; foreach (Node fieldNode in tableNode.Nodes) { fieldNameList.Add(fieldNode.Text); } } AddFieldRelationForm aForm = new AddFieldRelationForm(conn, tableName, fieldNameList, metaDataTable); if (aForm.ShowDialog() == DialogResult.OK) { tableNode = null; foreach (Node node in relationTree.Nodes) { if (node.Text == aForm.TableName) { tableNode = node; break; } } if (tableNode == null) { tableNode = new Node(); tableNode.Text = aForm.TableName; tableNode.Tag = aForm.TableName; relationTree.Nodes.Add(tableNode); } foreach (string s in aForm.FieldNameList) { bool exist = false; foreach (Node node in tableNode.Nodes) { if (node.Text == s) { exist = true; break; } } if (!exist) { Node fieldNode = new Node(); fieldNode.Text = s; fieldNode.Tag = s; tableNode.Nodes.Add(fieldNode); } } tableNode.Expand(); string relationData = GetRelationData(); UpdateFieldRelationData(relationData); } } else { MessageBox.Show("请先选择要添加关联关系的字段!", "添加关联关系", MessageBoxButtons.OK, MessageBoxIcon.Information); } }