/// <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;
}
}
