public void selectAllIsId(int id) { string sql1 = "select * from wage_info where id=@id "; Dictionary <string, Object> dic = new Dictionary <string, Object>(); dic.Add("@id", wa.getId()); ArrayList al = new ArrayList(); al = sqlHelper.SelectInfo(sql1, dic); if (al != null && al.Count > 0) //判断是有该数据 { foreach (Object[] obj in al) { //得到几行数据就能产生多少个对象 wa.setId((int)obj[0]); wa.setStaff_id((int)obj[1]); wa.setBasis((int)obj[2]); wa.setAttendance((int)obj[3]); wa.setPeformance((int)obj[4]); wa.setOther((int)obj[5]); wa.setReason((string)obj[6]); wa.setTotal((int)obj[7]); wa.setTime((DateTime)obj[8]); } comboBox1.Text = Convert.ToString(wa.getId()); textBox2.Text = Convert.ToString(wa.getAttendance()); textBox3.Text = Convert.ToString(wa.getPeformance()); textBox4.Text = Convert.ToString(wa.getOther()); textBox6.Text = Convert.ToString(wa.getReason()); label10.Text = Convert.ToString(wa.getTotal()); label9.Text = wa.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 wage_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(); comboBox2.Items.Clear(); } }
private void button1_Click(object sender, EventArgs e) { Staff sta = new Staff(); MyDB sqlHelper = new MyDB(); string sql1 = "select * from staff_info where name=@name "; string sql2 = "select * from staff_info where name=@name and password=@password "; string sql3 = "select * from wage_info where staff_id=@staff_id"; Dictionary <string, Object> dic = new Dictionary <string, Object>(); dic.Add("@name", texta.Text); dic.Add("@password", textb.Text); ArrayList al = new ArrayList(); al = sqlHelper.SelectInfo(sql1, dic); if (al != null && al.Count > 0)//判断是否有用户名 { al = sqlHelper.SelectInfo(sql2, dic); if (al != null && al.Count > 0) { foreach (Object[] obj in al) { //得到几行数据就能产生多少个对象 sta.setId((int)obj[0]); //强转成你需要的数据,强转很容易发生异常,所以数据库的约束性要强,对象类时要认真检查数据类型,多用try...catch sta.setName((string)obj[1]); sta.setPassword((string)obj[3]); sta.setDepartment_id((int)obj[2]); sta.setSex((string)obj[4]); sta.setAge((int)obj[5]); sta.setTime((DateTime)obj[6]); sta.setPost((string)obj[7]); } dic.Add("@staff_id", sta.getId()); al = sqlHelper.SelectInfo(sql3, dic); if (al != null && al.Count > 0) { Wage wage = new Wage(); foreach (Object[] obj in al) { //得到几行数据就能产生多少个对象 wage.setId((int)obj[0]); wage.setStaff_id((int)obj[1]); wage.setBasis((int)obj[2]); wage.setAttendance((int)obj[3]); wage.setPeformance((int)obj[4]); wage.setOther((int)obj[5]); wage.setReason((string)obj[6]); wage.setTotal((int)obj[7]); wage.setTime((DateTime)obj[8]); } MessageBox.Show("用户" + sta.getName() + "您好,\n您最新的工资为:" + wage.getTotal() + "\n详细信息:\n\t基础工资:" + wage.getBasis() + "\n\t考勤工资:" + wage.getAttendance() + "\n\t效绩工资:" + wage.getPeformance() + "\n\t其他工资:" + wage.getOther() + "\n\t原因:" + wage.getReason() + "\n更新时间" + wage.getTime(), "工资条"); } else { MessageBox.Show(sta.getName() + "您好,您还没有工资哦!\n请继续努力吧!"); } } else { label2.Text = "密码错误"; } } else { label2.Text = "请检查用户名"; } }