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(); }