private void BtnQuerybyDept_Click(object sender, EventArgs e)
{
//创建窗体对象
FrmDeptSummary frmDeptSummary = new FrmDeptSummary();
//打开窗体
frmDeptSummary.ShowDialog();
//判断部门查询窗体是否按了确定按钮
if (frmDeptSummary.DialogResult == DialogResult.OK)
{
//定义SQL的查询语句
string sqlSelect = string.Format("select * from View_ShowOvertimeInformation where employeeName in (select employeeName from tblEmployee where departmentId = (select departmentId from tblDepartment where departmentName like '%{0}%' ))", frmDeptSummary.DeptName);
//提交sql查询语句，根据返回结果显示相应信息
SqlDataReader dr = SqlHelper.ExecuteDataReader(sqlSelect);
if (dr.HasRows)
{
//载入数据
DataLoad(sqlSelect);
//关闭数据阅读器
dr.Close();
}
else
{
//弹出消息框提示
MessageBox.Show("未查询到记录！");
}
}
}
private void btnGroupbyDept_Click(object sender, EventArgs e)
{
//创建窗体对象
FrmDeptSummary frmDeptSummary = new FrmDeptSummary();
//打开窗体
frmDeptSummary.ShowDialog();
//判断员工查询窗体是否按了确定按钮
if (frmDeptSummary.DialogResult == DialogResult.OK)
{
try
{
string DepartmentIdlookup = string.Format("select departmentId from tblDepartment where departmentName like '{0}'", frmDeptSummary.DeptName);
string DepartmentId = SqlHelper.ExecuteScalar(DepartmentIdlookup).ToString();//根据employeequery.DeptName部门名称查询部门编号
FrmSalaryHistory frmDepartmentSalaryHistory = new FrmSalaryHistory();
frmDepartmentSalaryHistory.departmentId = DepartmentId;
frmDepartmentSalaryHistory.EmployeeSH = false;
frmDepartmentSalaryHistory.ShowDialog();
}
catch
{
MessageBox.Show("不存在该部门！");
}
}
}
