private void button1_Click(object sender, EventArgs e) { #region 旧方法 /*string sql = "select *from staffmessage where jobID='" + textBox9.Text + "'and name='" + textBox8.Text + "'"; * Dao dao = new Dao(); * IDataReader dr = dao.read(sql); * if (dr.Read()) * { * string a, b, c, d,f,g; * * a = dr["gender"].ToString(); * b = dr["age"].ToString(); * c = dr["hireyear"].ToString(); * d = dr["post"].ToString(); * f = dr["seniorty"].ToString(); * g = dr["password"].ToString(); * textBox1.Text = c; * textBox3.Text = a; * textBox4.Text = b; * textBox5.Text = d; * textBox6.Text = f; * textBox7.Text = g; * } * else * { * MessageBox.Show("未查询到该员工,请重试!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); * }*/ #endregion if (sm.CheckStaffIsExistsByJobIDandName(textBox1.Text.Trim(), textBox2.Text.Trim())) { textBox3.Text = sm.GetStaffmessageByJobID(textBox1.Text.Trim()).Age.ToString(); textBox4.Text = sm.GetStaffmessageByJobID(textBox1.Text.Trim()).Gender.ToString(); textBox5.Text = sm.GetStaffmessageByJobID(textBox1.Text.Trim()).Post.ToString(); textBox6.Text = sm.GetStaffmessageByJobID(textBox1.Text.Trim()).Seniorty.ToString(); textBox7.Text = sm.GetStaffmessageByJobID(textBox1.Text.Trim()).Password.ToString(); textBox8.Text = sm.GetStaffmessageByJobID(textBox1.Text.Trim()).Hireyear.ToString(); } else { MessageBox.Show("未查询到该员工,请重试!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void button1_Click(object sender, EventArgs e) { #region 旧方法 /* * jobid = textBox2.Text; * string sql = "select * from staffmessage where name='"+textBox1.Text+"'and jobID='"+textBox2.Text +"'"; * Dao dao = new Dao(); * IDataReader dr = dao.read(sql); * if (dr.Read()) * { * Form4_2 form4_2 = new Form4_2(jobid); * form4_2.Show(); * this.Hide(); * } * * else * { * MessageBox.Show("未查询到该员工,请重新确认工号和姓名!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); * textBox1.Text = null; * textBox2.Text = null; * }*/ #endregion jobid = textBox2.Text; if (sm.CheckStaffIsExistsByJobIDandName(textBox2.Text.Trim(), textBox1.Text.Trim())) { Form4_2 form4_2 = new Form4_2(jobid); form4_2.Show(); this.Hide(); } else { MessageBox.Show("未查询到该员工,请重新确认工号和姓名!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); textBox1.Text = null; textBox2.Text = null; } }