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("*", "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.Delete();
s._Del("staff", "id", id);
ClearInfo();
}
private void button4_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
SFact s = new SFact();
SOperate select = s.Select();
ds = select._Select("pos_id as ID,pos_name as 职位", "position");
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
private void button5_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
SFact sFact = new SFact();
SOperate s = sFact.Select();
ds = s._Select("id,sta_num as 账号,sta_name as 姓名,sta_age as 年龄,sta_sex as 性别,pos_name as 职位,sta_startime as 入职时间", "staff,position where staff.pos_id= position.pos_id "); //查询全部工人信息
dataGridView2.DataSource = ds.Tables[0].DefaultView;
}
public void ShowInfo()
{
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
SFact sFact = new SFact();
SOperate s = sFact.Select();
ds = s._Select("id,sta_num as 账号,sta_name as 姓名,sta_age as 年龄,sta_sex as 性别,pos_name as 职位,sta_startime as 入职时间",
"staff,position where staff.pos_id= position.pos_id "); //查询全部工人信息
ds1 = s._Select("pos_id", "position");
dataGridView2.DataSource = ds.Tables[0].DefaultView;
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
{
comboBox1.Items.Add(ds1.Tables[0].Rows[i][0].ToString().Trim());
}
comboBox1.DisplayMember = "shang";
comboBox1.ValueMember = "id";
}
private void button2_Click(object sender, EventArgs e)
{
if (num == textBox1.Text)
{
SFact sFact = new SFact();
SOperate s = sFact.Update();
string pos_id = textBox2.Text;
string sta_name = textBox3.Text;
string sta_age = textBox4.Text;
string sta_sex = textBox5.Text;
string sta_startime = textBox6.Text;
string sta_pwd = textBox7.Text;
s._Update("staff", "pos_id = " + pos_id + ",sta_name= '" + sta_name + "',sta_age=" + sta_age + ",sta_sex= '" + sta_sex + "',sta_startime='" + sta_startime + "',sta_pwd='" + sta_pwd + "'", "id", id);
}
else
{
MessageBox.Show("会员号不可更改");
}
}
private void button2_Click(object sender, EventArgs e)
{
SFact sFact = new SFact();
SOperate s = sFact.Select();
DataSet ds = new DataSet();
if (comboBox1.Text.Equals("All"))
{
ds = s._Select("id,sta_num as 账号,sta_name as 姓名,sta_age as 年龄,sta_sex as 性别,pos_name as 职位,sta_startime as 入职时间", "staff,position where staff.pos_id= position.pos_id");
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
else if (comboBox1.Text.Equals("员工号"))
{
ds = s._Select("", "staff", "sta_id", textBox1.Text);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
else if (comboBox1.Text.Equals("职位"))
{
ds = s._Select("*", "staff", "pos_id", textBox1.Text);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
else if (comboBox1.Text.Equals("姓名"))
{
ds = s._Select("*", "staff", "sta_name", textBox1.Text);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
else if (comboBox1.Text.Equals("年龄"))
{
ds = s._Select("*", "staff", "sta_age", textBox1.Text);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
else if (comboBox1.Text.Equals("性别"))
{
ds = s._Select("*", "staff", "sta_sex", textBox1.Text);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
else if (comboBox1.Text.Equals("入职时间"))
{
ds = s._Select("*", "staff", "sta_startime", textBox1.Text);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
}
private void button4_Click(object sender, EventArgs e)
{
num = textBox1.Text;
SFact sFact = new SFact();
SOperate s = sFact.Select();
DataSet d = s._Select("*", "staff", "sta_num", textBox1.Text);
if (d.Tables[0].Rows.Count == 0 && d.Tables.Count == 1)//判断是否有数据
{
MessageBox.Show("该职工号不存在");
ClearInfo();
}
else
{
id = d.Tables[0].Rows[0][0].ToString();
textBox2.Text = d.Tables[0].Rows[0][6].ToString();
textBox3.Text = d.Tables[0].Rows[0][1].ToString();
textBox4.Text = d.Tables[0].Rows[0][5].ToString();
textBox5.Text = d.Tables[0].Rows[0][4].ToString();
textBox6.Text = d.Tables[0].Rows[0][7].ToString();
textBox7.Text = d.Tables[0].Rows[0][2].ToString();
}
}
