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("不存在该部门！");
}
}
}
private void btnHistoryQuery_Click(object sender, EventArgs e)
{
FrmSalaryHistory frmEmployeeSalaryHistory = new FrmSalaryHistory();
string EmployeeId = grdSalaryList.SelectedRows[0].Cells["employeeId"].Value.ToString();//选择的当前行employeeId列的值，员工编号
frmEmployeeSalaryHistory.employeeId = EmployeeId;
frmEmployeeSalaryHistory.EmployeeSH = true;
frmEmployeeSalaryHistory.ShowDialog();
}
