/// <summary> /// 菜单添加数据库 /// </summary> private void QueryData() { try { dal = new DbLink(); IList <DbLinkInfo> ilist = dal.DbLinkGetList(); tv_Db.Nodes.Clear(); TreeNode tn = new TreeNode(); tn.Text = "服务器"; TreeNode tnode = null; foreach (DbLinkInfo info in ilist) { tnode = new TreeNode(); tnode.Text = string.IsNullOrEmpty(info.DbAbbreviation) ? info.DbName : info.DbName + "(" + info.DbAbbreviation + ")"; DbDataInfo ServerInfo = new DbDataInfo(); ServerInfo.DbLinkID = info.ID; ServerInfo.DbName = info.DbName; ServerInfo.NameType = (int)DbDataTypeEnum.数据库; ServerInfo.Name = info.DbName; tnode.Tag = ServerInfo; tn.Nodes.Add(tnode); } tn.ExpandAll(); tv_Db.Nodes.Add(tn); } catch (Exception ex) { MessageBox.Show("获取数据库失败," + ex.Message); } }
private void LinkToolScriptBtn_Click(object sender, EventArgs e) { try { dal = new DbLink(); ToolStripButton tbtn = sender as ToolStripButton; string title = tbtn.Text; if (title == "刷新") { QueryData(); return; } DbDataInfo dinfo = tv_Db.SelectedNode.Tag as DbDataInfo; if (dinfo == null) { MessageBox.Show("请选择服务器。"); return; } DbDataTypeEnum ddt = DbDataType.GetDbDataType(dinfo.NameType); if (ddt != DbDataTypeEnum.数据库) { MessageBox.Show("请选择服务器。"); return; } switch (title) { case "连接": GetdbData(dinfo); break; case "断开": tv_Db.SelectedNode.Nodes.Clear(); break; case "重连接": GetdbData(dinfo); break; case "注销": if (dal.DbLink_Del(dinfo.DbLinkID) == 1) { tv_Db.Nodes.Remove(tv_Db.SelectedNode); } break; } } catch (Exception ex) { MessageBox.Show("获取数据库失败," + ex.Message); } }
private DataBaseInfo GetDbInfo(int ID) { dal = new DbLink(); DbLinkInfo dlinfo = dal.DbLinkGetInfo(ID); IDataBase dbDal = new CurrencyDal.CodeMaker.DataBase(); string rstmsg = ""; List <string> tableNameList = new List <string>(); DataBaseInfo dbinfo = dbDal.DataBaseGetInfo(dlinfo, tableNameList, out rstmsg); //DataBaseInfo dbinfo = new DataBaseInfo(); //DataBaseInfo2 info = new DataBaseInfo2(); //try //{ // switch (dlinfo.DbType) // { // case 1: // System.Data.Common.DbConnection connSql = new System.Data.SqlClient.SqlConnection(); // connSql.ConnectionString = "Data Source=" + dlinfo.DataSource + ";Initial Catalog=" + dlinfo.DbName + ";User ID=" + dlinfo.UserName + ";Password="******"Data Source=" + dlinfo.DbName + ";User ID=" + dlinfo.UserName + ";Password="******""; // info.GetOracleDb(connOracle); // break; // case 3: // string ConnString = dlinfo.DataSource; // info.LoadFromAccess2000(ConnString); // break; // } //} //catch (Exception ex) //{ // MessageBox.Show("操作失败。" + ex.Message); //} return(dbinfo); }
private void MenuClicked(object sender, EventArgs e) { dal = new DbLink(); string MenuName = (sender as ToolStripMenuItem).Text; ToolStripMenuItem tmi = sender as ToolStripMenuItem; DbDataInfo dinfo = tmi.Tag as DbDataInfo; Model.EventInfo einfo = new Model.EventInfo(); switch (MenuName) { case "连接": GetdbData(dinfo); break; case "断开": tv_Db.SelectedNode.Nodes.Clear(); break; case "重连接": GetdbData(dinfo); break; case "注销": if (dal.DbLink_Del(dinfo.DbLinkID) == 1) { tv_Db.Nodes.Remove(tv_Db.SelectedNode); } break; case "浏览表结构": if (FindDocument("表结构查询") == null) { FormTableQuery sm = new FormTableQuery(); sm.Show(DockPanel); } else { Form f = FindDocument("表结构查询") as Form; f.Focus(); } einfo.Title = "表结构查询"; Common.MidModule.SendData(this, dinfo, einfo); //发送参数值 break; case "浏览视图结构": if (FindDocument("表结构查询") == null) { FormTableQuery sm = new FormTableQuery(); sm.Show(DockPanel); } else { Form f = FindDocument("表结构查询") as Form; f.Focus(); } einfo.Title = "表结构查询"; Common.MidModule.SendData(this, dinfo, einfo); //发送参数值 break; case "导入数据": if (FindDocument("数据导入") == null) { FormImportData sm = new FormImportData(); sm.Show(DockPanel); } else { Form f = FindDocument("数据导入") as Form; f.Focus(); } einfo.Title = "数据导入"; Common.MidModule.SendData(this, dinfo, einfo); //发送参数值 break; case "修改字段数据": if (FindDocument("修改字段数据") == null) { FormFieldData sm = new FormFieldData(); sm.Show(DockPanel); } else { Form f = FindDocument("修改字段数据") as Form; f.Focus(); } einfo.Title = "修改字段数据"; Common.MidModule.SendData(this, dinfo, einfo); //发送参数值 break; case "表单代码生成器": if (FindDocument("表单代码生成器") == null) { FormCreater sm = new FormCreater(); sm.Show(DockPanel); } else { Form f = FindDocument("表单代码生成器") as Form; f.Focus(); } einfo.Title = "表单代码生成器"; Common.MidModule.SendData(this, dinfo, einfo); //发送参数值 break; } }