/// <summary>
/// 测试连接中心
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void TestConn_Click(object parameter)
{
PasswordBox passwordBox = parameter as PasswordBox;
//PasswordBox的Password属性因为安全原因不支持直接绑定
this.CenterDbPwd = PasswordBoxHelper.GetPassword(passwordBox);
DbConnectString = $"Data Source={CenterIp};port={CenterDbPort};User ID={CenterDbUser};Password={CenterDbPwd};Initial Catalog={CenterDb};";
try
{
MySqlHelper.ExecuteDataset(DbConnectString, "select * from sys_user limit 1");
ShowMessage("中心数据库连接成功！");
//存储中心连接字符串
SaveCenterDbConfig();
CheckBoxConnStr();
if (dictBoxConnStr.Count > 0)
{
IsEnable0 = false;
IsEnable1 = true;
}
else
{
ShowMessage("没有获取到任何盒子的连接信息！");
}
}
catch (Exception ex)
{
string str = ex.ToString();
MessageBox.Show("数据库连接失败！");
}
}
private static void OnPasswordChanged(object sender, RoutedEventArgs e)
{
var passwordBox = sender as PasswordBox;
var password = PasswordBoxHelper.GetPassword(passwordBox);
if (passwordBox != null && passwordBox.Password != password)
{
PasswordBoxHelper.SetPassword(passwordBox, passwordBox.Password);
}
}
private void TestMySqlConn(object parameter)
{
PasswordBox passwordBox = parameter as PasswordBox;
//PasswordBox的Password属性因为安全原因不支持直接绑定
this.CenterDbPwd = PasswordBoxHelper.GetPassword(passwordBox);
string mySqlConnStr = GetConnStr();
if (string.IsNullOrEmpty(mySqlConnStr))
{
MessageBoxHelper.MessageBoxShowWarning("请输入完整的数据库连接信息");
return;
}
TestMySql(mySqlConnStr);
}
