private void Dbutton1_Click(object sender, EventArgs e)
{
hidePanel();
double plus = Convert.ToDouble(DtextBox.Text);
string constr = "server=localhost;User Id=root;password=919881;Database=atm";
MySqlConnection mycon = new MySqlConnection(constr);
mycon.Open();
MySqlCommand mycmd = new MySqlCommand("SELECT Abalance FROM account WHERE Anum = '" + Number + "'", mycon);
MySqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
if (reader.HasRows)
{
plus = (double)reader["Abalance"] + plus;
}
}
reader.Close();
mycmd = new MySqlCommand("UPDATE account SET Abalance = '" + plus + "'WHERE Anum = '" + Number + "'", mycon);
mycmd.ExecuteNonQuery();
mycon.Close();
Qpanel.Show();
QLabel.Text = "存款成功";
}
public void hidePanel()
{
Qpanel.Hide();
Tpanel.Hide();
Cpanel.Hide();
Dpanel.Hide();
Wpanel.Hide();
}
private void Tbutton1_Click(object sender, EventArgs e)
{
hidePanel();
string toID = TtextBox1.Text;
double reduce = Convert.ToDouble(TtextBox2.Text);
double balance1 = 0;
double balance2 = 0;
string constr = "server=localhost;User Id=root;password=919881;Database=atm";
MySqlConnection mycon = new MySqlConnection(constr);
mycon.Open();
MySqlCommand mycmd = new MySqlCommand("SELECT Abalance FROM account WHERE Anum = '" + Number + "'", mycon);
MySqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
if (reader.HasRows)
{
balance1 = (double)reader["Abalance"] - reduce;
}
}
if (balance1 < 0)
{
reader.Close();
mycon.Close();
Qpanel.Show();
QLabel.Text = "余额不足";
}
else
{
reader.Close();
mycmd = new MySqlCommand("UPDATE account SET Abalance = '" + balance1 + "'WHERE Anum = '" + Number + "'", mycon);
mycmd.ExecuteNonQuery();
mycmd = new MySqlCommand("SELECT Abalance FROM account WHERE Anum = '" + toID + "'", mycon);
reader = mycmd.ExecuteReader();
if (reader.Read())
{
if (reader.HasRows)
{
balance2 = (double)reader["Abalance"] + reduce;
}
}
reader.Close();
mycmd = new MySqlCommand("UPDATE account SET Abalance = '" + balance2 + "'WHERE Anum = '" + toID + "'", mycon);
mycmd.ExecuteNonQuery();
mycon.Close();
Qpanel.Show();
QLabel.Text = "转账成功";
}
}
private void PButton1_Click(object sender, EventArgs e)
{
hidePanel();
string newPIN = CtextBox.Text;
string constr = "server=localhost;User Id=root;password=919881;Database=atm";
MySqlConnection mycon = new MySqlConnection(constr);
mycon.Open();
MySqlCommand mycmd = new MySqlCommand("UPDATE account SET Apin = '" + newPIN + "'WHERE Anum = '" + Number + "'", mycon);
mycmd.ExecuteNonQuery();
mycon.Close();
Qpanel.Show();
QLabel.Text = "修改成功";
}
private void queryButton_Click(object sender, EventArgs e) //查询余额
{
double temp;
Qpanel.Show();
hideButton();
string constr = "server=localhost;User Id=root;password=919881;Database=atm";
MySqlConnection mycon = new MySqlConnection(constr);
mycon.Open();
MySqlCommand mycmd = new MySqlCommand("SELECT Abalance FROM account WHERE account.Anum = " + Number, mycon);
MySqlDataReader reader = mycmd.ExecuteReader();
if (reader.Read())
{
if (reader.HasRows)
{
temp = (double)reader["Abalance"];
QLabel.Text = "余额：" + temp;
}
}
reader.Close();
mycon.Close();
}