private void button1_Click(object sender, EventArgs e) { gl.myclos(); sql2 = null; comboBox1.Items.Clear(); comboBox2.Items.Clear(); textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = textBox6.Text = ""; }
private void setDepartment() { string sql1 = "select * from department_info where id=@id "; Dictionary <string, Object> dic = new Dictionary <string, Object>(); dic.Add("@id", de.getId()); ArrayList al = new ArrayList(); al = sqlHelper.SelectInfo(sql1, dic); if (al != null && al.Count > 0)//判断是有该数据 { foreach (Object[] obj in al) { //得到几行数据就能产生多少个对象 de.setId((int)obj[0]); de.setName((string)obj[1]); de.setBasis((int)obj[2]); } comboBox1.Text = Convert.ToString(de.getId()); textBox1.Text = de.getName(); textBox2.Text = Convert.ToString(de.getBasis()); if (sql2 == null) { sql2 = "select id from department_info "; al = sqlHelper.SelectInfo(sql2, dic); if (al != null && al.Count > 0) { foreach (Object[] obj in al) { //得到几行数据就能产生多少个对象 comboBox1.Items.Add((int)obj[0]); } } else { MessageBox.Show("没有数据,请添加!", "提示"); } } } else { MessageBox.Show("该部门可能已被删除!", "提示"); gl.myclos(); sql2 = null; comboBox1.Items.Clear(); } }
private void button1_Click(object sender, EventArgs e)//关闭 { gl.myclos(); setzt(); }
private void button2_Click(object sender, EventArgs e) { guanli.myclos(); }
private void setDepartment() { // string sql1 = "select * from staff_info where id=@id "; Dictionary <string, Object> dic = new Dictionary <string, Object>(); dic.Add("@id", st.getId()); ArrayList al = new ArrayList(); al = sqlHelper.SelectInfo(sql1, dic); if (al != null && al.Count > 0) //判断是有该数据 { foreach (Object[] obj in al) { //得到几行数据就能产生多少个对象 st.setId((int)obj[0]); st.setName((string)obj[1]); st.setDepartment_id((int)obj[2]); st.setPassword((String)obj[3]); st.setSex((string)obj[4]); st.setAge((int)obj[5]); st.setTime((DateTime)obj[6]); st.setPost((string)obj[7]); } comboBox1.Text = Convert.ToString(st.getId()); textBox1.Text = st.getName(); textBox2.Text = st.getPassword(); textBox3.Text = Convert.ToString(st.getAge()); textBox4.Text = st.getPost(); comboBox3.Text = st.getSex(); label9.Text = st.getTime(); foreach (ComboxItem c in comboBox2.Items) { if (c.Values == st.getDepartment_id()) { comboBox2.Text = c.Text; break; } } if (sql2 == null) { sql2 = "select id from staff_info "; al = sqlHelper.SelectInfo(sql2, dic); if (al != null && al.Count > 0) { foreach (Object[] obj in al) { //得到几行数据就能产生多少个对象 comboBox1.Items.Add((int)obj[0]); } } else { MessageBox.Show("没有数据,请添加!", "提示"); } } } else { MessageBox.Show("该员工可能已被删除!", "提示"); gl.myclos(); sql2 = null; comboBox1.Items.Clear(); } }