改密码
1. dal cardinfo changePwd
public bool changePwd(string CardID, string oldPwd, string newPwd)
{
string sql = "update cardinfo set pass='"+ newPwd + "' where cardID='" + CardID + "' and pass='"+oldPwd+ "' and IsReportLoss=0";
int n = DbHelperSQL.ExecuteSql(sql);
if (n >= 1)
{
return true;
}
else
{ return false; }
}
2. bll- cardinfo changePwd
public bool changePwd(string CardID, string oldPwd, string newPwd)
{
return dal.changePwd(CardID, oldPwd,newPwd);
}
3. winf- ChangePWD
!)增加卡号字段
public string CardID;
2)编写按钮点击事件
private void button1_Click(object sender, EventArgs e)
{
label4.Text = "";
if (textBox2.Text != textBox3.Text)
{ label4.Text = "两次新密码不一致,请重输!"; }
else
{
BLL.cardinfo bll = new BLL.cardinfo();
bool isOK= bll.changePwd(CardID, textBox1.Text, textBox3.Text);
if (isOK) {
MessageBox.Show("密码修改成功,请重新登录!","成功");
this.DialogResult = DialogResult.OK;
}
else { label4.Text = "密码修改失败,请重试!"; }
}
}
4. winf-main-菜单
private void 改密码ToolStripMenuItem_Click(object sender, EventArgs e)
{
ChangePWD cp = new ChangePWD();
cp.CardID = CardID;
DialogResult OK=cp.ShowDialog();
if (OK == DialogResult.OK) {
退出账户toolStripMenuItem_Click(null, null);
}
}