代码拉取完成,页面将自动刷新
using ComponentFactory.Krypton.Toolkit;
using MJTop.Data;
using System;
using System.Windows.Forms;
namespace DBCHM
{
public partial class GridFormMgr : KryptonForm
{
public GridFormMgr()
{
InitializeComponent();
//为KeyDown能应用到所有控件上 注册 KeyDown 事件
foreach (Control control in this.Controls)
{
control.KeyDown += control_KeyDown;
}
}
void control_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
this.Close();
}
}
DBForm dbForm = null;
private void linkAdd_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
dbForm = new DBForm(OPType.新建);
var dia = dbForm.ShowDialog();
if (dia == DialogResult.OK)
{
RefreshListView();
}
}
private void linkEdit_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (GV_DBConfigs.SelectedRows.Count <= 0)
{
MessageBox.Show("请选择连接!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int Id = Convert.ToInt32(GV_DBConfigs.SelectedRows[0].Cells[0].Value);
DBForm dbForm = new DBForm(OPType.编辑, Id);
var diaResult = dbForm.ShowDialog();
if (diaResult == DialogResult.OK)
{
RefreshListView();
}
}
private void linkRemove_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (GV_DBConfigs.SelectedRows.Count <= 0)
{
MessageBox.Show("请选择连接!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBox.Show("确定要删除该连接吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation) == DialogResult.OK)
{
int Id = Convert.ToInt32(GV_DBConfigs.SelectedRows[0].Cells[0].Value);
ConfigUtils.Delete(Id);
RefreshListView();
}
}
private void linkClone_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (GV_DBConfigs.SelectedRows.Count <= 0)
{
MessageBox.Show("请选择连接!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int Id = Convert.ToInt32(GV_DBConfigs.SelectedRows[0].Cells[0].Value);
DBForm dbForm = new DBForm(OPType.克隆, Id);
var diaResult = dbForm.ShowDialog(this);
if (diaResult == DialogResult.OK)
{
RefreshListView();
}
}
private void btnConnect_Click(object sender, EventArgs e)
{
if (GV_DBConfigs.SelectedRows.Count <= 0)
{
MessageBox.Show("请选择连接!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int Id = Convert.ToInt32(GV_DBConfigs.SelectedRows[0].Cells[0].Value);
DBCHMConfig config = ConfigUtils.Get(Id);
if ((DBType)Enum.Parse(typeof(DBType), config.DBType) == DBType.SqlServer
&& !GV_DBConfigs.SelectedRows[0].Cells[6].Value.ToString().Equals("sa", StringComparison.OrdinalIgnoreCase))
{
var dia = MessageBox.Show("非超级管理员的账号,可能因权限不足,查询不出表结构信息,确定要继续吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dia == DialogResult.Cancel)
{
return;
}
}
FormUtils.ShowProcessing("正在查询表结构信息,请稍等......", this, arg =>
{
try
{
DBUtils.Instance = DBMgr.UseDB((DBType)Enum.Parse(typeof(DBType), config.DBType), config.ConnString, 300);
ConfigUtils.UpLastModified(Id);
}
catch (Exception ex)
{
LogUtils.LogError("连接数据库失败", Developer.SysDefault, ex, config);
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}, null);
}
private void btnCancel_Click(object sender, EventArgs e)
{
this.Close();
}
private void GridFormMgr_Load(object sender, EventArgs e)
{
RefreshListView();
}
/// <summary>
/// 刷新列表
/// </summary>
private void RefreshListView()
{
var data = ConfigUtils.SelectAll();
if (data != null)
{
GV_DBConfigs.DataSource = data;
if (data.Count > 0)
{
GV_DBConfigs.Columns[0].Visible = false;
GV_DBConfigs.Columns[1].Width = 150;
}
}
}
private void GV_DBConfigs_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
btnConnect_Click(sender, e);
//代表已经正常选中
FormUtils.IsOK_Close = true;
this.Close();
}
private void GV_DBConfigs_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == 7)
{
if (GV_DBConfigs.Columns[e.ColumnIndex].DataPropertyName == "Pwd")
{
string str = e.Value.ToString();
string strEncrypt = string.Empty;
for (int j = 0; j < str.Length; j++)
{
strEncrypt += "*";
}
e.Value = strEncrypt;
}
}
}
/// <summary>
/// 关于我们
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
AboutBox aboutForm = new AboutBox();
aboutForm.ShowDialog();
}
}
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。