//充值按钮点击事件 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(); }