private void button1_Click(object sender, EventArgs e)
{
if (txtPassword.Text != txtPasswordAgain.Text)
{
MessageBox.Show("两次密码输入的不相同哦");
}
else
{
using (SqlConnection SQLConn = new SqlConnection(ConnStr))
{
string SQLStr = $"UPDATE accNum SET password = {txtPassword.Text} WHERE accNumber = '{登录界面.MName}'";
int Resultcount = SQLHelper.SQLExcuteNoQuery(SQLStr);
if (Resultcount > 0)
{
MessageBox.Show("更改成功");
//返回操作界面
操作 operating = new 操作();
this.Hide();
operating.ShowDialog();
this.Dispose();
}
else
{
MessageBox.Show("更改失败");
}
}
}
}
private void btnReturn_Click(object sender, EventArgs e)
{
操作 operating = new 操作();
this.Hide();
operating.ShowDialog();
this.Dispose();
}
private void btnLogIn_Click(object sender, EventArgs e)
{
using (SqlConnection SQLConn = new SqlConnection(ConnStr))
{
string SQLStr = $"select * from accNum where accNumber = '{txtAccountNnumber.Text}'";
using (SqlCommand SQLCmd = new SqlCommand(SQLStr, SQLConn))
{
SQLConn.Open();
int Resultcount = Convert.ToInt32(SQLCmd.ExecuteScalar());
if (Resultcount > 0)
{
//MessageBox.Show("登陆成功");
string SQLStr1 = $"select * from accNum where accNumber = '{txtAccountNnumber.Text}'and password='******'";
using (SqlConnection SQLConn1 = new SqlConnection(ConnStr))
{
using (SqlCommand SQLCmd1 = new SqlCommand(SQLStr1, SQLConn1))
{
SQLConn1.Open();
int Resultcount1 = Convert.ToInt32(SQLCmd1.ExecuteScalar());
if (Resultcount1 > 0)
{
MessageBox.Show("登陆成功");
MName = txtAccountNnumber.Text;
操作 operating = new 操作();
this.Hide();
operating.ShowDialog();
this.Dispose();
}
else
{
MessageBox.Show("密码错误");
}
}
}
}
else
{
MessageBox.Show("账号错误");
}
}
}
}