📄 dbview.cs
字号:
TreeNode node6 = new TreeNode(text);
node6.ImageIndex = 2;
node6.SelectedImageIndex = 2;
node6.Tag = "db";
serverNode.Nodes.Add(node6);
this.mainfrm.toolComboBox_DB.Items.Add(text);
this.mainfrm.toolComboBox_DB.SelectedIndex = 0;
DataTable table4 = obj2.GetTabViews(text);
if (table4 != null)
{
this.mainfrm.toolComboBox_Table.Items.Clear();
foreach (DataRow row4 in table4.Rows)
{
string str7 = row4["name"].ToString();
this.mainfrm.toolComboBox_Table.Items.Add(str7);
}
if (this.mainfrm.toolComboBox_Table.Items.Count > 0)
{
this.mainfrm.toolComboBox_Table.SelectedIndex = 0;
}
}
}
serverNode.ExpandAll();
foreach (TreeNode node7 in serverNode.Nodes)
{
string str8 = node7.Text;
this.mainfrm.StatusLabel1.Text = "加载数据库 " + str8 + "...";
SplashScreen.SetStatus(" 加载数据库 " + str8 + "...");
TreeNode node8 = new TreeNode("表");
node8.ImageIndex = 3;
node8.SelectedImageIndex = 4;
node8.Tag = "tableroot";
node7.Nodes.Add(node8);
TreeNode node9 = new TreeNode("视图");
node9.ImageIndex = 3;
node9.SelectedImageIndex = 4;
node9.Tag = "viewroot";
node7.Nodes.Add(node9);
TreeNode node10 = new TreeNode("存储过程");
node10.ImageIndex = 3;
node10.SelectedImageIndex = 4;
node10.Tag = "procroot";
node7.Nodes.Add(node10);
try
{
List<string> tables = obj2.GetTables(str8);
if (tables.Count > 0)
{
foreach (string str9 in tables)
{
SplashScreen.SetStatus(" 加载数据库信息 " + str9);
TreeNode node11 = new TreeNode(str9);
node11.ImageIndex = 5;
node11.SelectedImageIndex = 5;
node11.Tag = "table";
node8.Nodes.Add(node11);
if (!ConnectSimple)
{
List<LTP.CodeHelper.ColumnInfo> columnList = obj2.GetColumnList(str8, str9);
if ((columnList != null) && (columnList.Count > 0))
{
foreach (LTP.CodeHelper.ColumnInfo info in columnList)
{
string columnName = info.ColumnName;
string typeName = info.TypeName;
TreeNode node12 = new TreeNode(columnName + "[" + typeName + "]");
node12.ImageIndex = 7;
node12.SelectedImageIndex = 7;
node12.Tag = "column";
node11.Nodes.Add(node12);
}
continue;
}
}
}
}
}
catch (Exception exception3)
{
LogInfo.WriteLog(exception3);
MessageBox.Show(this, "获取数据库" + str8 + "的表信息失败：" + exception3.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
try
{
DataTable vIEWs = obj2.GetVIEWs(str8);
if (vIEWs != null)
{
foreach (DataRow row5 in vIEWs.Select("", "name ASC"))
{
string str12 = row5["name"].ToString();
SplashScreen.SetStatus("加载数据库信息 " + str12);
TreeNode node13 = new TreeNode(str12);
node13.ImageIndex = 6;
node13.SelectedImageIndex = 6;
node13.Tag = "view";
node9.Nodes.Add(node13);
if (!ConnectSimple)
{
List<LTP.CodeHelper.ColumnInfo> list5 = obj2.GetColumnList(str8, str12);
if ((list5 != null) && (list5.Count > 0))
{
foreach (LTP.CodeHelper.ColumnInfo info2 in list5)
{
string str13 = info2.ColumnName;
string str14 = info2.TypeName;
TreeNode node14 = new TreeNode(str13 + "[" + str14 + "]");
node14.ImageIndex = 7;
node14.SelectedImageIndex = 7;
node14.Tag = "column";
node13.Nodes.Add(node14);
}
}
}
}
}
}
catch (Exception exception4)
{
LogInfo.WriteLog(exception4);
MessageBox.Show(this, "获取数据库" + str8 + "的视图信息失败：" + exception4.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
try
{
DataTable procs = obj2.GetProcs(str8);
if (procs != null)
{
foreach (DataRow row6 in procs.Select("", "name ASC"))
{
string str15 = row6["name"].ToString();
SplashScreen.SetStatus("加载数据库信息 " + str15);
TreeNode node15 = new TreeNode(str15);
node15.ImageIndex = 8;
node15.SelectedImageIndex = 8;
node15.Tag = "proc";
node10.Nodes.Add(node15);
if (!ConnectSimple)
{
List<LTP.CodeHelper.ColumnInfo> list6 = obj2.GetColumnList(str8, str15);
if ((list6 != null) && (list6.Count > 0))
{
foreach (LTP.CodeHelper.ColumnInfo info3 in list6)
{
string str16 = info3.ColumnName;
string str17 = info3.TypeName;
TreeNode node16 = new TreeNode(str16 + "[" + str17 + "]");
node16.ImageIndex = 9;
node16.SelectedImageIndex = 9;
node16.Tag = "column";
node15.Nodes.Add(node16);
}
}
}
}
}
continue;
}
catch (Exception exception5)
{
LogInfo.WriteLog(exception5);
MessageBox.Show(this, "获取数据库" + str8 + "的视图信息失败：" + exception5.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
continue;
}
}
SplashScreen.CloseForm();
foreach (TreeNode node17 in this.serverlistNode.Nodes)
{
if (node17.Text == ServerIp)
{
this.treeView1.SelectedNode = node17;
}
}
this.mainfrm.StatusLabel1.Text = "就绪";
}
private void CreatMenu(string NodeType)
{
this.DbTreeContextMenu.Items.Clear();
switch (NodeType)
{
case "serverlist":
{
ToolStripMenuItem item = new ToolStripMenuItem();
item.Name = "添加服务器Item";
item.Text = "添加服务器";
item.Click += new EventHandler(this.添加服务器Item_Click);
ToolStripMenuItem item2 = new ToolStripMenuItem();
item2.Name = "备份服务器配置Item";
item2.Text = "备份服务器配置";
item2.Click += new EventHandler(this.备份服务器配置Item_Click);
ToolStripMenuItem item3 = new ToolStripMenuItem();
item3.Name = "导入服务器配置Item";
item3.Text = "导入服务器配置";
item3.Click += new EventHandler(this.导入服务器配置Item_Click);
ToolStripMenuItem item4 = new ToolStripMenuItem();
item4.Name = "刷新Item";
item4.Text = "刷新";
item4.Click += new EventHandler(this.刷新Item_Click);
ToolStripMenuItem item5 = new ToolStripMenuItem();
item5.Name = "属性Item";
item5.Text = "属性";
item5.Click += new EventHandler(this.属性Item_Click);
this.DbTreeContextMenu.Items.AddRange(new ToolStripItem[] { item, item2, item3, item4 });
return;
}
case "server":
{
ToolStripMenuItem item6 = new ToolStripMenuItem();
item6.Name = "连接服务器Item";
item6.Text = "连接服务器";
item6.Click += new EventHandler(this.连接服务器Item_Click);
ToolStripMenuItem item7 = new ToolStripMenuItem();
item7.Name = "注销服务器Item";
item7.Text = "注销服务器";
item7.Click += new EventHandler(this.注销服务器Item_Click);
ToolStripMenuItem item8 = new ToolStripMenuItem();
item8.Name = "属性Item";
item8.Text = "刷新";
item8.Click += new EventHandler(this.server属性Item_Click);
this.DbTreeContextMenu.Items.AddRange(new ToolStripItem[] { item6, item7, item8 });
return;
}
case "db":
{
ToolStripMenuItem item9 = new ToolStripMenuItem();
item9.Name = "新建查询Item";
item9.Text = "新建查询";
item9.Click += new EventHandler(this.新建查询Item_Click);
ToolStripSeparator separator = new ToolStripSeparator();
separator.Name = "Separator1";
ToolStripMenuItem item10 = new ToolStripMenuItem();
item10.Name = "生成存储过程Item";
item10.Text = "生成存储过程";
item10.Click += new EventHandler(this.生成存储过程dbItem_Click);
ToolStripMenuItem item11 = new ToolStripMenuItem();
item11.Name = "生成数据脚本Item";
item11.Text = "生成数据脚本";
item11.Click += new EventHandler(this.生成数据脚本dbItem_Click);
ToolStripMenuItem item12 = new ToolStripMenuItem();
item12.Name = "导出文件Item";
item12.Text = "导出文件";
ToolStripMenuItem item13 = new ToolStripMenuItem();
item13.Name = "存储过程Item";
item13.Text = "存储过程";
item13.Click += new EventHandler(this.存储过程dbItem_Click);
ToolStripMenuItem item14 = new ToolStripMenuItem();
item14.Name = "数据脚本Item";
item14.Text = "数据脚本";
item14.Click += new EventHandler(this.数据脚本dbItem_Click);
ToolStripMenuItem item15 = new ToolStripMenuItem();
item15.Name = "表数据Item";
item15.Text = "表数据";
item15.Click += new EventHandler(this.表数据dbItem_Click);
item12.DropDownItems.AddRange(new ToolStripItem[] { item13, item14, item15 });
ToolStripSeparator separator2 = new ToolStripSeparator();
separator.Name = "Separator2";
ToolStripMenuItem item16 = new ToolStripMenuItem();
item16.Name = "父子表代码生成Item";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -