private void dgv_DbLink_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
int rowindex = e.RowIndex;
int columnindex = e.ColumnIndex;
string id = dgv_DbLink.Rows[rowindex].Cells["ID"].Value.ToString();
if (columnindex == 0) //编辑
{
var info = dal.DbLinkGetInfo(int.Parse(id));
tb_DbName.Text = info.DbName;
tb_UserName.Text = info.UserName;
tb_Password.Text = info.PassWord;
tb_DataSource.Text = info.DataSource;
var DbTypeName = Enum.GetName(typeof(DataBaseTypeEnum), info.DbType);
cob_DbType.SelectedText = DbTypeName;
cob_DbType.Text = DbTypeName;
tb_DbAbbreviation.Text = info.DbAbbreviation;
tb_Port.Text = info.Port;
tb_ID.Text = info.ID.ToString();
}
else if (columnindex == 1) //删除
{
MessageBoxButtons mess = MessageBoxButtons.OKCancel;
DialogResult dr = MessageBox.Show("是否删除", "提示", mess);
if (dr != DialogResult.OK)
{
return;
}
var rst = dal.DbLink_Del(int.Parse(id));
if (rst > 0)
{
Initdgv_DbLink();
tb_Clear_Click(null, null);
MessageBox.Show("删除成功。");
return;
}
else
{
MessageBox.Show("删除失败。");
return;
}
}
}
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);
}
