📄 dbview.cs
字号:
item16.Text = "父子表代码生成(事务)";
item16.Click += new EventHandler(this.父子表代码生成dbItem_Click);
ToolStripMenuItem item17 = new ToolStripMenuItem();
item17.Name = "代码批量生成dbItem";
item17.Text = "代码批量生成";
item17.Click += new EventHandler(this.代码批量生成dbItem_Click);
ToolStripSeparator separator3 = new ToolStripSeparator();
separator.Name = "Separatordb2";
ToolStripMenuItem item18 = new ToolStripMenuItem();
item18.Name = "刷新Item";
item18.Text = "刷新";
item18.Click += new EventHandler(this.刷新dbItem_Click);
this.DbTreeContextMenu.Items.AddRange(new ToolStripItem[] { item9, separator, item10, item11, item12, separator2, item16, item17, separator3, item18 });
return;
}
case "tableroot":
case "viewroot":
case "procroot":
case "column":
break;
case "table":
{
ToolStripMenuItem item19 = new ToolStripMenuItem();
item19.Name = "生成SQL语句Item";
item19.Text = "生成SQL语句到";
ToolStripMenuItem item20 = new ToolStripMenuItem();
item20.Name = "SELECTItem";
item20.Text = "SELECT(&S)";
item20.Click += new EventHandler(this.SELECTItem_Click);
ToolStripMenuItem item21 = new ToolStripMenuItem();
item21.Name = "UPDATEItem";
item21.Text = "UPDATE(&U)";
item21.Click += new EventHandler(this.UPDATEItem_Click);
ToolStripMenuItem item22 = new ToolStripMenuItem();
item22.Name = "DELETEItem";
item22.Text = "DELETE(&D)";
item22.Click += new EventHandler(this.DELETEItem_Click);
ToolStripMenuItem item23 = new ToolStripMenuItem();
item23.Name = "INSERTItem";
item23.Text = "INSERT(&I)";
item23.Click += new EventHandler(this.INSERTItem_Click);
item19.DropDownItems.AddRange(new ToolStripItem[] { item20, item21, item22, item23 });
ToolStripMenuItem item24 = new ToolStripMenuItem();
item24.Name = "查看表数据tabItem";
item24.Text = "浏览表数据";
item24.Click += new EventHandler(this.查看表数据tabItem_Click);
ToolStripMenuItem item25 = new ToolStripMenuItem();
item25.Name = "生成数据脚本tabItem";
item25.Text = "生成数据脚本";
item25.Click += new EventHandler(this.生成数据脚本tabItem_Click);
ToolStripMenuItem item26 = new ToolStripMenuItem();
item26.Name = "生成存储过程tabItem";
item26.Text = "生成存储过程";
item26.Click += new EventHandler(this.生成存储过程tabItem_Click);
ToolStripMenuItem item27 = new ToolStripMenuItem();
item27.Name = "导出文件tabItem";
item27.Text = "导出文件";
ToolStripMenuItem item28 = new ToolStripMenuItem();
item28.Name = "存储过程tabItem";
item28.Text = "存储过程";
item28.Click += new EventHandler(this.存储过程tabItem_Click);
ToolStripMenuItem item29 = new ToolStripMenuItem();
item29.Name = "数据脚本tabItem";
item29.Text = "数据脚本";
item29.Click += new EventHandler(this.数据脚本tabItem_Click);
ToolStripMenuItem item30 = new ToolStripMenuItem();
item30.Name = "表数据tabItem";
item30.Text = "表数据";
item30.Click += new EventHandler(this.表数据tabItem_Click);
item27.DropDownItems.AddRange(new ToolStripItem[] { item28, item29, item30 });
ToolStripSeparator separator4 = new ToolStripSeparator();
separator4.Name = "Separator1";
ToolStripMenuItem item31 = new ToolStripMenuItem();
item31.Name = "代码生成Item";
item31.Text = "代码生成器";
item31.Click += new EventHandler(this.代码生成Item_Click);
ToolStripMenuItem item32 = new ToolStripMenuItem();
item32.Name = "模版代码生成Item";
item32.Text = "模版代码生成";
item32.Click += new EventHandler(this.模版代码生成Item_Click);
ToolStripMenuItem item33 = new ToolStripMenuItem();
item33.Name = "生成单类结构Item";
item33.Text = "生成单类结构";
item33.Click += new EventHandler(this.生成单类结构Items_Click);
ToolStripMenuItem item34 = new ToolStripMenuItem();
item34.Name = "生成ModelItem";
item34.Text = "生成Model";
item34.Click += new EventHandler(this.生成ModelItem_Click);
ToolStripSeparator separator5 = new ToolStripSeparator();
separator5.Name = "Separator3";
ToolStripMenuItem item35 = new ToolStripMenuItem();
item35.Name = "简单三层Item";
item35.Text = "简单三层";
ToolStripMenuItem item36 = new ToolStripMenuItem();
item36.Name = "生成DALS3Item";
item36.Text = "生成DAL";
item36.Click += new EventHandler(this.生成DALS3Item_Click);
ToolStripMenuItem item37 = new ToolStripMenuItem();
item37.Name = "生成BLLS3Item";
item37.Text = "生成BLL";
item37.Click += new EventHandler(this.生成BLLS3Item_Click);
ToolStripMenuItem item38 = new ToolStripMenuItem();
item38.Name = "生成全部S3";
item38.Text = "生成全部";
item38.Click += new EventHandler(this.生成全部S3Item_Click);
item35.DropDownItems.AddRange(new ToolStripItem[] { item36, item37, item38 });
ToolStripMenuItem item39 = new ToolStripMenuItem();
item39.Name = "工厂模式三层Item";
item39.Text = "工厂模式三层";
ToolStripMenuItem item40 = new ToolStripMenuItem();
item40.Name = "生成DALF3Item";
item40.Text = "生成DAL";
item40.Click += new EventHandler(this.生成DALF3Item_Click);
ToolStripMenuItem item41 = new ToolStripMenuItem();
item41.Name = "生成IDALItem";
item41.Text = "生成DAL";
item41.Click += new EventHandler(this.生成IDALItem_Click);
ToolStripMenuItem item42 = new ToolStripMenuItem();
item42.Name = "生成DALFactoryItem";
item42.Text = "生成DALFactory";
item42.Click += new EventHandler(this.生成DALFactoryItem_Click);
ToolStripMenuItem item43 = new ToolStripMenuItem();
item43.Name = "生成BLLF3Item";
item43.Text = "生成BLL";
item43.Click += new EventHandler(this.生成BLLF3Item_Click);
ToolStripMenuItem item44 = new ToolStripMenuItem();
item44.Name = "生成全部F3Item";
item44.Text = "生成全部";
item44.Click += new EventHandler(this.生成全部F3Item_Click);
item39.DropDownItems.AddRange(new ToolStripItem[] { item40, item41, item42, item43, item44 });
ToolStripSeparator separator6 = new ToolStripSeparator();
separator6.Name = "Separator5";
ToolStripMenuItem item45 = new ToolStripMenuItem();
item45.Name = "生成页面Item";
item45.Text = "生成页面";
item45.Click += new EventHandler(this.生成页面Item_Click);
ToolStripSeparator separator7 = new ToolStripSeparator();
separator7.Name = "Separator2";
ToolStripMenuItem item46 = new ToolStripMenuItem();
item46.Name = "父子表代码生成Item";
item46.Text = "父子表代码生成(事务)";
item46.Click += new EventHandler(this.父子表代码生成Item_Click);
ToolStripMenuItem item47 = new ToolStripMenuItem();
item47.Name = "代码批量生成";
item47.Text = "代码批量生成";
item47.Click += new EventHandler(this.代码批量生成Item_Click);
ToolStripSeparator separator8 = new ToolStripSeparator();
separator8.Name = "Separator4";
ToolStripMenuItem item48 = new ToolStripMenuItem();
item48.Name = "重命名tabItem";
item48.Text = "重命名";
item48.Click += new EventHandler(this.重命名tabItem_Click);
ToolStripMenuItem item49 = new ToolStripMenuItem();
item49.Name = "删除tabItem";
item49.Text = "删除";
item49.Click += new EventHandler(this.删除tabItem_Click);
this.DbTreeContextMenu.Items.AddRange(new ToolStripItem[] { item19, item24, item25, item26, item27, separator4, item31, item46, item47, item32, separator8, item48, item49 });
return;
}
case "view":
{
ToolStripMenuItem item50 = new ToolStripMenuItem();
item50.Name = "脚本Item";
item50.Text = "脚本";
ToolStripMenuItem item51 = new ToolStripMenuItem();
item51.Name = "SELECTItem";
item51.Text = "SELECT(&S)";
ToolStripMenuItem item52 = new ToolStripMenuItem();
item52.Name = "AlterItem";
item52.Text = "ALTER(&U)";
ToolStripMenuItem item53 = new ToolStripMenuItem();
item53.Name = "DropItem";
item53.Text = "DROP(&D)";
item50.DropDownItems.AddRange(new ToolStripItem[] { item51, item52, item53 });
ToolStripMenuItem item54 = new ToolStripMenuItem();
item54.Name = "对象定义Item";
item54.Text = "对象定义";
item54.Click += new EventHandler(this.对象定义Item_Click);
ToolStripMenuItem item55 = new ToolStripMenuItem();
item55.Name = "查看表数据tabItem";
item55.Text = "浏览表数据";
item55.Click += new EventHandler(this.查看表数据tabItem_Click);
ToolStripSeparator separator9 = new ToolStripSeparator();
separator9.Name = "Separatorv1";
ToolStripMenuItem item56 = new ToolStripMenuItem();
item56.Name = "代码生成Item";
item56.Text = "代码生成器";
item56.Click += new EventHandler(this.代码生成Item_Click);
this.DbTreeContextMenu.Items.AddRange(new ToolStripItem[] { item50, item54, item55, separator9, item56 });
return;
}
case "proc":
{
ToolStripMenuItem item57 = new ToolStripMenuItem();
item57.Name = "脚本Item";
item57.Text = "脚本";
ToolStripMenuItem item58 = new ToolStripMenuItem();
item58.Name = "AlterItem";
item58.Text = "ALTER(&U)";
ToolStripMenuItem item59 = new ToolStripMenuItem();
item59.Name = "DropItem";
item59.Text = "DROP(&D)";
ToolStripMenuItem item60 = new ToolStripMenuItem();
item60.Name = "EXECItem";
item60.Text = "EXEC(&I)";
item57.DropDownItems.AddRange(new ToolStripItem[] { item58, item59, item60 });
ToolStripMenuItem item61 = new ToolStripMenuItem();
item61.Name = "对象定义Item";
item61.Text = "对象定义";
item61.Click += new EventHandler(this.对象定义Item_Click);
this.DbTreeContextMenu.Items.AddRange(new ToolStripItem[] { item57, item61 });
break;
}
default:
return;
}
}
private void CreatTree(string dbtype, string ServerIp, string constr, string Dbname)
{
this.dbobj = DBOMaker.CreateDbObj(dbtype);
TreeNode node = new TreeNode(this.GetserverNodeText(ServerIp, dbtype, Dbname));
node.Tag = "server";
this.serverlistNode.Nodes.Add(node);
node.ImageIndex = 1;
node.SelectedImageIndex = 1;
this.treeView1.SelectedNode = node;
this.mainfrm.StatusLabel1.Text = "加载数据库树...";
SplashScreen.SetStatus("加载数据库树...");
this.dbobj.DbConnectStr = constr;
if ((dbtype == "SQL2000") || (dbtype == "SQL2005"))
{
try
{
if ((this.logo.dbname == "master") || (this.logo.dbname == ""))
{
List<string> dBList = this.dbobj.GetDBList();
if ((dBList != null) && (dBList.Count > 0))
{
this.mainfrm.toolComboBox_DB.Items.Clear();
foreach (string str in dBList)
{
TreeNode node2 = new TreeNode(str);
node2.ImageIndex = 2;
node2.SelectedImageIndex = 2;
node2.Tag = "db";
node.Nodes.Add(node2);
this.mainfrm.toolComboBox_DB.Items.Add(str);
}
if (this.mainfrm.toolComboBox_DB.Items.Count > 0)
{
this.mainfrm.toolComboBox_DB.SelectedIndex = 0;
}
}
}
else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -