private void BtnQuerybyEmp_Click(object sender, EventArgs e)
{
//创建窗口对象
FrmQuerybyEmp frmQuerybyEmp = new FrmQuerybyEmp();
//打开窗口
frmQuerybyEmp.ShowDialog();
//判断员工查询窗体是否按了确定按钮
if (frmQuerybyEmp.DialogResult == DialogResult.OK)
{
//定义查询语句
string sqlSelect = string.Format("select applyId,employeeName,submitTime,overtimeReason,applyConditions,overtimeName from tblOvertime inner join tblEmployee on tblOvertime.employeeId=tblEmployee.employeeId inner join tblOvertimeType on tblOvertime.overtimeType=tblOvertimeType.overtimeType inner join tblDepartment on tblDepartment.departmentId = tblEmployee.departmentId WHERE employeeName like '%{0}%' and employeeEmail like '%{1}%' and departmentName like '%{2}%'", frmQuerybyEmp.EmpName, frmQuerybyEmp.EmpEmail, frmQuerybyEmp.DeptName);
//提交sql语句，根据返回结果显示相应信息
SqlDataReader dr = SqlHelper.ExecuteDataReader(sqlSelect);
if (dr.HasRows)
{
//载入查询结果
DataLoad(sqlSelect);
//关闭数据阅读器
dr.Close();
}
else
{
//弹出消息框提示
MessageBox.Show("未查到符合条件的员工！");
}
}
}
private void btnQueryEmployee_Click(object sender, EventArgs e)
{
//创建窗口对象
FrmQuerybyEmp employeequery = new FrmQuerybyEmp();
employeequery.ShowDialog();
//判断员工查询窗体是否按了确定按钮
if (employeequery.DialogResult == DialogResult.OK)
{
//定义查询语句
string sqlSelect = "select * from tblEmployee where 1=1";
if (employeequery.EmpName != "")
{
sqlSelect += string.Format("and employeeName like '%" + employeequery.EmpName + "%'");
}
if (employeequery.EmpEmail != "")
{
sqlSelect += string.Format("and employeeEmail like '%" + employeequery.EmpEmail + "%'");
}
if (employeequery.DeptName != "")
{
string DepartmentIdlookup = @"select departmentId from tblDepartment where departmentName ='" + employeequery.DeptName + "'";
int departmentid = (Int32)SqlHelper.ExecuteScalar(DepartmentIdlookup);//将employeequery.DeptName部门名称转化为部门编号
sqlSelect += string.Format("and departmentId = '" + departmentid + "'");
}
//提交sql语句，根据返回结果显示相应信息
SqlDataReader dr = SqlHelper.ExecuteDataReader(sqlSelect);
if (dr.HasRows)
{
//载入查询结果
DataLoad(sqlSelect);
//关闭数据阅读器
dr.Close();
}
else
{
//弹出消息框提示
MessageBox.Show("未查到符合条件的员工！");
}
}
}