private void button5_Click(object sender, EventArgs e)
{
ForeignExchange foreignExchange = new ForeignExchange();
foreignExchange.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
if (excToRmbBtn.Checked)
{
double excToRmb;
try
{
excToRmb = double.Parse(excNum.Text);
double sellprice3 = double.Parse(sellPrice.Text);
//double exc_excToRmb = (excToRmb / sellprice3) * 100;
//因为用户输入的是人民币，这里把人民币换成对应货币在比较是否会发生"您拥有的货币量不足"
string excKey = currencyChoose.Text;
//int nowexc = 0; //需要数据库提供数据（当前币种拥有的货币量）（币种：excKey)
double nowrmb;
string sql = "Select * from foreignexchange where 手机号='" + phonenumber + "'AND 货币种类='" + excKey + "'";
string sql2 = "Select * from debitcardinfo where 手机号='" + phonenumber + "'";
DB.MySqlDataBase mdb = new DB.MySqlDataBase();
MySqlDataReader rd = mdb.read(sql);
MySqlDataReader rd2 = mdb.read(sql2);
rd.Read();
string a;
a = rd["货币持有量"].ToString();
nowExc = double.Parse(a);
rd2.Read();
string b;
b = rd2["活期存款余额"].ToString(); //读出此时储蓄卡的余额到string型变量b
nowrmb = double.Parse(b);
rd.Close(); //关闭连接
rd2.Close();
if (excToRmb > nowExc)
{
MessageBox.Show("您拥有的货币量不足");
}
else if (excToRmb <= 0)
{
MessageBox.Show("兑换数量应大于0！");
excNum.Text = "";
}
else
{
//更新数据库(减少该种货币量以及增加人民币储蓄)
//返回上一界面
double newexc, newrmb; //兑换后的外币和人民币
//double sellprice3 = double.Parse(sellPrice.Text);
//计算公式
newexc = nowExc - excToRmb;
newrmb = nowrmb + double.Parse(textBox1.Text);
string sql3 = "UPDATE debitcardinfo SET 活期存款余额 = '" + newrmb + "' where 手机号='" + phonenumber + "'";
string sql4 = "UPDATE foreignexchange SET 货币持有量 = '" + newexc + "' where 手机号='" + phonenumber + "'AND 货币种类='" + excKey + "'";
DB.MySqlDataBase db3 = new DB.MySqlDataBase();
int ext3 = mdb.Excute(sql3);
int ext4 = mdb.Excute(sql4);
if (ext4 > 0)
{
MessageBox.Show("兑换成功！");
ForeignExchange insert = new ForeignExchange();
insert.Show();
this.Close();
//更新界面
}
//更新数据库(减少该种货币量以及增加人民币储蓄)
}
}
catch
{
if (currencyChoose.Text == "")
{
MessageBox.Show("未选择交易币种");
}
else
{
MessageBox.Show("请输入兑换金额");
}
}
}
else if (rmbToExcBtn.Checked)
{
double rmbToExc;
try
{
rmbToExc = double.Parse(textBox1.Text);
//int rmbToExc = int.Parse(excNum.Text);
string excKey = currencyChoose.Text;
//int nowrmb = 0; //需要数据库提供数据（人民币储蓄）（币种：excKey）
double nowrmb;
string sql = "Select * from foreignexchange where 手机号='" + phonenumber + "'AND 货币种类='" + excKey + "'";
string sql2 = "Select * from debitcardinfo where 手机号='" + phonenumber + "'";
DB.MySqlDataBase mdb = new DB.MySqlDataBase();
MySqlDataReader rd = mdb.read(sql);
MySqlDataReader rd2 = mdb.read(sql2);
rd.Read();
string a;
a = rd["货币持有量"].ToString();
nowExc = double.Parse(a);
rd2.Read();
string b;
b = rd2["活期存款余额"].ToString(); //读出此时储蓄卡的余额到string型变量b
nowrmb = double.Parse(b);
rd.Close(); //关闭连接
if (rmbToExc > nowrmb)
{
MessageBox.Show("您的人民币储蓄不足");
}
else if (rmbToExc <= 0)
{
MessageBox.Show("兑换数量应大于0！");
excNum.Text = "";
}
else
{
//更新数据库(减少人民币储蓄以及增加该种货币量)（币种：excKey）
//返回上一界面
double newexc, newrmb; //兑换后的外币和人民币
double buyprice4 = double.Parse(buyPrice.Text);
//计算公式
newexc = nowExc + double.Parse(excNum.Text);
newrmb = nowrmb - double.Parse(textBox1.Text);
string sql3 = "UPDATE debitcardinfo SET 活期存款余额 = '" + newrmb + "' where 手机号='" + phonenumber + "'";
string sql4 = "UPDATE foreignexchange SET 货币持有量 = '" + newexc + "' where 手机号='" + phonenumber + "'AND 货币种类='" + excKey + "'";
//更新数据库(减少人民币储蓄以及增加该种货币量)（币种：excKey）
DB.MySqlDataBase db3 = new DB.MySqlDataBase();
int ext3 = mdb.Excute(sql3);
int ext4 = mdb.Excute(sql4);
if (ext4 > 0)
{
MessageBox.Show("兑换成功！");
ForeignExchange insert = new ForeignExchange();
insert.Show();
this.Close();
//更新此界面
}
}
}
catch
{
if (currencyChoose.Text == "")
{
MessageBox.Show("未选择交易币种");
}
else
{
MessageBox.Show("请输入兑换金额");
}
}
}
else
{
MessageBox.Show("请选择交易类型");
}
}