private void button1_Click(object sender, EventArgs e)
{
SFact sFact = new SFact();
SOperate s1 = sFact.Select();
if (s1._Select("*", "staff", "sta_num", textBox1.Text).Tables[0].Rows.Count == 0)
{
if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox5.Text != "" && textBox6.Text != "" &&
textBox7.Text != "")
{
SOperate s = sFact.Add();
s._Add("staff(sta_name,sta_pwd,sta_num,sta_sex,sta_age,pos_id,sta_startime)",
textBox2.Text, textBox7.Text, textBox1.Text, textBox5.Text, textBox3.Text, comboBox1.Text, textBox6.Text);
ClearInfo();
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("存在输入信息为空。！");
}
}
else
{
MessageBox.Show("该员工账号已存在！");
}
}
private void button3_Click(object sender, EventArgs e)
{
SFact sFact = new SFact();
SOperate s = sFact.Add();
s._Add("position", textBox9.Text, textBox8.Text);
}
private void button1_Click(object sender, EventArgs e)
{
SFact sFact = new SFact();
SOperate s1 = sFact.Select();
if (s1._Select("*", "vip", "vip_num", textBox1.Text).Tables[0].Rows.Count == 0)
{
if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox5.Text != "" && textBox6.Text != "" &&
textBox7.Text != "")
{
SOperate s = sFact.Add();
s._Add("vip(vip_num,vip_name,vip_sex,vip_age,vip_money,vip_pwd,vip_phone)", "'" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" +
textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "' ");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
}
else
{
MessageBox.Show("存在输入信息为空。！");
}
}
else
{
MessageBox.Show("该员工账号已存在！");
}
}