//保存连接-1:修改配置文件信息;2、存入日志 数据库历史信息中 private void btn_Save_Click(object sender, EventArgs e) { ConfDataBaseInfo info = new ConfDataBaseInfo(); if (comboBox_DB.Text == "") { MessageBox.Show("请选择数据库名", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } info.IP = txt_IP.Text; info.User = txt_UserName.Text; info.Password = txt_Password.Text; info.ServerName = comboBox_DB.Text; if (config.UpdateDBInfo(info, out string errMsg)) { if (config.SaveDBInfo(info, out errMsg)) { MessageBox.Show("保存连接成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); ReadDBHistory(); } else { MessageBox.Show("保存连接历史信息失败!," + errMsg, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("保存连接信息失败!," + errMsg, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//快速切换数据库配置 / 删除 private void DGV_History_CellClick(object sender, DataGridViewCellEventArgs e) { ConfDataBaseInfo info = new ConfDataBaseInfo(); int curIndex = e.RowIndex; DGV_History.Rows[curIndex].Selected = true; info.IP = Convert.ToString(DGV_History.Rows[curIndex].Cells["HostName"].Value); info.ServerName = Convert.ToString(DGV_History.Rows[curIndex].Cells["DBName"].Value); info.User = Convert.ToString(DGV_History.Rows[curIndex].Cells["UserName"].Value); info.Password = Convert.ToString(DGV_History.Rows[curIndex].Cells["PassWord"].Value); txt_IP.Text = info.IP; txt_UserName.Text = info.User; txt_Password.Text = info.Password; comboBox_DB.Text = info.ServerName; if (e.ColumnIndex == 6) { if (config.DeleteSignleDBHistory(info, out string errMsg)) { MessageBox.Show("清除历史成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); DGV_History.Rows.RemoveAt(curIndex); } else { MessageBox.Show("清除历史失败!," + errMsg, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
//数据库下拉列表 private void comboBox_DB_DropDown(object sender, EventArgs e) { ConfDataBaseInfo info = new ConfDataBaseInfo(); if (string.IsNullOrWhiteSpace(txt_IP.Text)) { MessageBox.Show("请输入服务器名!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (string.IsNullOrWhiteSpace(txt_UserName.Text)) { MessageBox.Show("请输入登录名!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (string.IsNullOrWhiteSpace(txt_Password.Text)) { MessageBox.Show("请输入密码!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } info.IP = txt_IP.Text; info.User = txt_UserName.Text; info.Password = txt_Password.Text; List <string> list = config.GetDBList(info, out string errMsg); if (!string.IsNullOrWhiteSpace(errMsg)) { MessageBox.Show("获取数据库列表失败!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { comboBox_DB.Items.Clear(); foreach (string name in list) { comboBox_DB.Items.Add(name); } comboBox_DB.SelectedItem = Config.envConfigInfo.confProjectInfo.ServerName; } }
//测试连接 private void btn_Test_Click(object sender, EventArgs e) { ConfDataBaseInfo info = new ConfDataBaseInfo(); if (comboBox_DB.Text == "") { MessageBox.Show("请选择数据库名", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } info.IP = txt_IP.Text; info.User = txt_UserName.Text; info.Password = txt_Password.Text; info.ServerName = comboBox_DB.Text; if (config.CheckDBConnect(info, out string errMsg)) { MessageBox.Show("测试连接成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("测试连接失败!," + errMsg, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }