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 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) { 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(); } }