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(); }
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("两次密码输入不一致,请重新输入!"); } }