private void bind_colmnames(TreeNode node)
{
string tablename = getTableName(node.Text);
DataTable dt = OP_DBClient.GetDbColmData(tablename);
TreeNode[] nodes = new TreeNode[dt.Rows.Count];
for (int i = 0; i < nodes.Length; i++)
{
nodes[i] = new TreeNode(dt.Rows[i][0].ToString() + " （" + dt.Rows[i][1].ToString() + "|" + dt.Rows[i][2].ToString() + "）");
nodes[i].ImageIndex = 24;
}
node.Nodes.AddRange(nodes);
}
private void bind_dbnames(TreeNode[] hismz)
{
DataTable[] tableArray = new DataTable[6];
try
{
tableArray[0] = OP_DBClient.GetDbData(DataTypeName.表);
tableArray[1] = OP_DBClient.GetDbData(DataTypeName.视图);
tableArray[2] = OP_DBClient.GetDbData(DataTypeName.存储过程);
tableArray[3] = OP_DBClient.GetDbData(DataTypeName.索引);
tableArray[4] = OP_DBClient.GetDbData(DataTypeName.函数);
tableArray[5] = OP_DBClient.GetDbData(DataTypeName.触发器);
TreeNode[] nodes = new TreeNode[tableArray[0].Rows.Count];
for (int i = 0; i < nodes.Length; i++)
{
nodes[i] = new TreeNode(tableArray[0].Rows[i][1].ToString());
nodes[i].Tag = 4;
nodes[i].ImageIndex = 22;
bind_colmnames(nodes[i]);
}
hismz[0].ImageIndex = 23;
hismz[0].Nodes.AddRange(nodes);
TreeNode[] nodeArray2 = new TreeNode[tableArray[1].Rows.Count];
for (int j = 0; j < nodeArray2.Length; j++)
{
nodeArray2[j] = new TreeNode(tableArray[1].Rows[j][1].ToString());
nodeArray2[j].Tag = 1;
nodeArray2[j].ImageIndex = 22;
bind_colmnames(nodeArray2[j]);
}
hismz[1].ImageIndex = 23;
hismz[1].Nodes.AddRange(nodeArray2);
TreeNode[] nodeArray3 = new TreeNode[tableArray[2].Rows.Count];
for (int k = 0; k < nodeArray3.Length; k++)
{
nodeArray3[k] = new TreeNode(tableArray[2].Rows[k][1].ToString());
nodeArray3[k].Tag = 2;
nodeArray3[k].ImageIndex = 22;
}
hismz[2].ImageIndex = 23;
hismz[2].Nodes.AddRange(nodeArray3);
TreeNode[] nodeArray4 = new TreeNode[tableArray[3].Rows.Count];
for (int m = 0; m < nodeArray4.Length; m++)
{
nodeArray4[m] = new TreeNode(tableArray[3].Rows[m][1].ToString());
nodeArray4[m].ImageIndex = 22;
}
hismz[3].ImageIndex = 23;
hismz[3].Nodes.AddRange(nodeArray4);
TreeNode[] nodeArray5 = new TreeNode[tableArray[4].Rows.Count];
for (int n = 0; n < nodeArray5.Length; n++)
{
nodeArray5[n] = new TreeNode(tableArray[4].Rows[n][1].ToString());
nodeArray5[n].Tag = 3;
nodeArray5[n].ImageIndex = 22;
}
hismz[4].ImageIndex = 23;
hismz[4].Nodes.AddRange(nodeArray5);
TreeNode[] nodeArray6 = new TreeNode[tableArray[5].Rows.Count];
for (int num6 = 0; num6 < nodeArray6.Length; num6++)
{
nodeArray6[num6] = new TreeNode(tableArray[5].Rows[num6][0].ToString());
nodeArray6[num6].ImageIndex = 22;
}
hismz[5].ImageIndex = 23;
hismz[5].Nodes.AddRange(nodeArray6);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "连接数据库配置不正确", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
