/// <summary>
/// 确认按钮点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_OK_Click(object sender, EventArgs e)
{
if (textBox_old_pwd.Text == "")
{
MessageBox.Show("原密码输入框不能为空！", "警告");
return;
}
if (textBox_new_pwd.Text == "")
{
MessageBox.Show("新密码输入框不能为空！", "警告");
return;
}
AccessDB adb = new AccessDB();
string sql = "SELECT * FROM BASE_USERS WHERE USER_ID = '" + uid + "'";
DataSet ds = adb.SQLQuery(sql);
DataTable dt = ds.Tables[0];
DataRow dr = dt.Rows[0];
if (textBox_old_pwd.Text != dr["USER_PWD"].ToString() && dr["USER_PWD"] != null)
{
MessageBox.Show("原密码输入错误！", "警告");
return;
}
if (textBox_new_pwd.Text == textBox_old_pwd.Text)
{
MessageBox.Show("新密码请不要与旧密码重复", "警告");
return;
}
if (textBox_new_pwd.Text != textBox_pwd_confirm.Text)
{
MessageBox.Show("两次输入密码不一致！", "警告");
return;
}
sql = "UPDATE BASE_USERS SET USER_PWD = '" + textBox_new_pwd.Text + "' WHERE USER_ID = '" + uid + "'";
if (adb.SQLExecute(sql))
{
MessageBox.Show("密码修改成功！", "消息");
this.Close();
}
}