//确定按钮点击事件 private void confirm_btn_Click(object sender, EventArgs e) { //设置备注的默认值并确保必填项不为空 if (remarks_txb.Text == "") { remarks_txb.Text = LoadForm.TextList[56]; } if (name_txb.Text == "" || tel_txb.Text == "") { MessageBox.Show(LoadForm.TextList[57]); return; } //更新数据库user表 string sql = "update user set name = '" + name_txb.Text + "',sex = '" + sex_cbb.Text + "',tel = '" + tel_txb.Text + "',user_rank = '" + user_rank_cbb.Text + "',user_status = '" + user_status_cbb.Text + "',expired_time = '" + expired_time_dtp.Value + "',remarks = '" + remarks_txb.Text + "' where id = '" + id + "'"; cmd = new MySqlCommand(sql, conn); cmd.ExecuteScalar(); MessageBox.Show(LoadForm.TextList[80]); //调用父窗口的查询方法,刷新会员列表 sql = "select * from user "; UserList userList = (UserList)this.Owner; userList.user_list_ltv.Items.Clear(); userList.SelectUser(sql); userList.Show(); this.Dispose(); }
//查询按钮点击事件 private void select_btn_Click(object sender, EventArgs e) { string sql = "select * from user "; switch (time_cbb.SelectedIndex) { //按注册时间查询 case 0: sql += "where register_time between '" + time1_dtp.Value.ToString() + "' and '" + time2_dtp.Value.ToString() + "'"; break; //按过期时间查询 case 1: sql += "where expired_time between '" + time1_dtp.Value.ToString() + "' and '" + time2_dtp.Value.ToString() + "'"; break; } //调用父窗口的方法,根据查询结果刷新会员列表 UserList userList = (UserList)this.Owner; userList.user_list_ltv.Items.Clear(); userList.SelectUser(sql); userList.Show(); this.Dispose(); }
//删除会员按钮点击事件 private void delete_btn_Click(object sender, EventArgs e) { //弹出确认删除对话框 MessageBoxButtons messbutton = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show(LoadForm.TextList[81], LoadForm.TextList[63], messbutton); if (dr == DialogResult.OK) { string sql = ("delete from user where id = '" + id + "'"); cmd = new MySqlCommand(sql, conn); cmd.ExecuteScalar(); MessageBox.Show(LoadForm.TextList[82]); //设置user表自增的主键id从0开始(实际值为当前最大值加1) sql = ("alter table user auto_increment = 0"); cmd = new MySqlCommand(sql, conn); cmd.ExecuteScalar(); //调用父窗口的查询方法,刷新会员列表 sql = "select * from user "; UserList userList = (UserList)this.Owner; userList.user_list_ltv.Items.Clear(); userList.SelectUser(sql); userList.Show(); this.Dispose(); } }
//充值按钮点击事件 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(); }