/// <summary>
/// 查找关联关系
/// </summary>
/// <param name="sender">事件发送者</param>
/// <param name="e">事件参数</param>
private void bSearch_Click(object sender, EventArgs e)
{
string fieldValue = searchFieldBox.Text;
if (fieldValue != "")
{
if (keyFieldTree.SelectedNode != null && keyFieldTree.SelectedNode.Level == 1)
{
Hashtable infoTable = new Hashtable();
foreach (Node tableNode in relationTree.Nodes)
{
List <string> fieldList = new List <string>();
foreach (Node fieldNode in tableNode.Nodes)
{
fieldList.Add(GetFieldName(fieldNode.Text));
}
infoTable[tableNode.Text] = fieldList;
}
string displayInfo = string.Format("[{0}] {1}", keyFieldTree.SelectedNode.Parent.Text,
GetFieldName(keyFieldTree.SelectedNode.Text));
FieldRelationSearchForm sForm = new FieldRelationSearchForm(conn, displayInfo, fieldValue, infoTable);
sForm.ShowDialog();
}
else
{
MessageBox.Show("请先选择要查找的字段！", "查找", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("字段值不能为空！", "查找", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 查找关联关系
/// </summary>
/// <param name="sender">事件发送者</param>
/// <param name="e">事件参数</param>
private void bSearch_Click(object sender, EventArgs e)
{
string fieldValue = searchFieldBox.Text;
if (fieldValue != "")
{
if (keyFieldTree.SelectedNode != null && keyFieldTree.SelectedNode.Level == 1)
{
Hashtable infoTable = new Hashtable();
foreach (Node tableNode in relationTree.Nodes)
{
List<string> fieldList = new List<string>();
foreach (Node fieldNode in tableNode.Nodes)
{
fieldList.Add(GetFieldName(fieldNode.Text));
}
infoTable[tableNode.Text] = fieldList;
}
string displayInfo = string.Format("[{0}] {1}", keyFieldTree.SelectedNode.Parent.Text,
GetFieldName(keyFieldTree.SelectedNode.Text));
FieldRelationSearchForm sForm = new FieldRelationSearchForm(conn, displayInfo, fieldValue, infoTable);
sForm.ShowDialog();
}
else
{
MessageBox.Show("请先选择要查找的字段！", "查找", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("字段值不能为空！", "查找", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
