/// <summary> /// 1.点击确定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLogin_Click(object sender, EventArgs e) { #region //使用类封装 string sql = "select * from UserInfo Where UserName='******'and UserPwd='" + txtPassWord.Text.Trim() + "' "; if (OprateDB.ExecuteReader(sql)) { //写上用户名 username = txtUserName.Text.Trim().ToLower(); frmOperate frm = new frmOperate(); frm.Show(); this.Hide(); } else { i++; if (i == 1) { MessageBox.Show("用户名或密码错误,您还有二次机会"); MessageBox.Show("用户名或密码错误", "出错了", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (i == 2) { MessageBox.Show("用户名或密码错误,您还有一次机会"); MessageBox.Show("用户名或密码错误", "出错了", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (i == 3) { MessageBox.Show("用户名或密码错误,您还有0次机会"); MessageBox.Show("卡已被锁定", "请30分钟再试!", MessageBoxButtons.OK, MessageBoxIcon.Error); i = 0; } } #endregion }
private void btnok_Click(object sender, EventArgs e) { //1.先判断两次新密码是否输入一致 if (txtNewPassWord1.Text.Trim() == txtNewPassWord2.Text.Trim()) { #region//使用类封装 string sqlCheckPwd = "select * from UserInfo Where UserName='******'and UserPwd='" + txtOldPassWord.Text.Trim() + "' "; if (OprateDB.ExecuteReader(sqlCheckPwd)) { //更新语句--更新数据库 string sql = "update UserInfo set UserPwd='" + txtNewPassWord1.Text.Trim() + "'where UserName='******' "; if (OprateDB.ExecuteNonQuery(sql) == 1) { MessageBox.Show("密码修改成功!"); } else { MessageBox.Show("密码修改失败!"); } } else { MessageBox.Show("旧密码不正确!"); } #endregion } else { MessageBox.Show("两次密码输入不一致,请重新输入!"); } }