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