private void vip_get_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
VIP a = new VIP();
ds = a.display(user_ifms.ID);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "client_VIP natural join merchant_vip";
}
private void vip_mtf_Load(object sender, EventArgs e)
{
VIP a = new VIP();
DataSet ds = new DataSet();
ds = a.check_merchantgrade(user_ifms.ID);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "merchant_vip";
}
private void button1_Click(object sender, EventArgs e)
{
VIP a = new VIP();
DataSet ds = new DataSet();
ds = a.check_discount(user_ifms.ID, textBox1.Text, textBox2.Text);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "client_VIP natural join merchant_vip";
}
private void button2_Click(object sender, EventArgs e)
{
VIP a = new VIP();
if (a.update_discount(user_ifms.ID, textBox3.Text, textBox4.Text))
{
MessageBox.Show("修改成功");
DataSet ds = new DataSet();
ds = a.check_merchantgrade(user_ifms.ID);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "merchant_vip";
}
}
private void button3_Click(object sender, EventArgs e)
{
VIP a = new VIP();
if (a.update_grade(user_ifms.ID, textBox5.Text, textBox6.Text, textBox7.Text))
{
MessageBox.Show("修改成功");
DataSet ds = new DataSet();
ds = a.check_discount(user_ifms.ID, textBox5.Text, textBox6.Text);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "client_VIP natural join merchant_vip";
}
else
{
MessageBox.Show("输入信息有误，请重新输入");
}
}