//充值按钮点击事件
private void charge_btn_Click(object sender, EventArgs e)
{
//按输入的充值金额，充值消费次数更新数据库user表
string sql = "update user set ";
if (charge_balance_txb.Text != "" && charge_num_txb.Text != "")
{
sql += "balance = balance + '" + Double.Parse(charge_balance_txb.Text) + "',total_num = total_num + '" + charge_num_txb.Text + "'";
}
else if (charge_balance_txb.Text != "")
{
sql += "balance = balance + '" + Double.Parse(charge_balance_txb.Text) + "' ";
}
else if (charge_num_txb.Text != "")
{
sql += "total_num = total_num + '" + charge_num_txb.Text + "' ";
}
else
{
MessageBox.Show(LoadForm.TextList[83]);
return;
}
sql += " where id = '" + int.Parse(id_txb.Text.ToString()) + "'";
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteScalar();
MessageBox.Show(LoadForm.TextList[84]);
//调用父窗口的查询方法，刷新会员列表
sql = "select * from user";
UserList userList = (UserList)this.Owner;
userList.user_list_ltv.Items.Clear();
userList.SelectUser(sql);
userList.Show();
this.Dispose();
}
