private void button1_Click(object sender, EventArgs e)
{
//取钱预处理
string connString = @" Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\ATM.mdf;Integrated Security=True";
string sqlck = "select UserMoney from StudengInfomation where UserName1='" + frmLogin.username + "' ";
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand command = new SqlCommand(sqlck, conn);
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
if (this.txtqukuan.Text == "")
{
MessageBox.Show("取款金额不能为空");
txtqukuan.Focus();
}
else if (int.Parse(this.txtqukuan.Text) <= 0)
{
MessageBox.Show("金额大于0！");
this.txtqukuan.Text = "";
txtqukuan.Focus();
}
else if (float.Parse(this.txtqukuan.Text) > float.Parse(dr["UserMoney"].ToString().Trim()))
{
MessageBox.Show("您的账户余额不足！");
this.txtqukuan.Text = "";
txtqukuan.Focus();
}
else if (int.Parse(this.txtqukuan.Text) % 50 != 0)
{
MessageBox.Show("金额必须为50的倍数！");
this.txtqukuan.Text = "";
txtqukuan.Focus();
}
else
{
//取钱处理
decimal a = Convert.ToDecimal(txtqukuan.Text.Trim());
string sql = "update StudengInfomation set UserMoney=UserMoney-'" + a + "' where UserName1='" + frmLogin.username + "' ";
if (OprateDB.ExecuteNonQuery(sql) == 1)
{
MessageBox.Show("取款成功！");
}
else
{
MessageBox.Show("取款款失败！");
}
} //大else结尾
} //if结尾\
conn.Close();
dr.Close();
}
/// <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("两次密码输入不一致，请重新输入！");
}
}
