protected void LoadData() { CreateWaitDialog("正在查询...", "请稍等"); plan_list_a = ManagementTraineeSalaryPlan.GeneratePlanList(division, grade, type, "A"); plan_list_b = ManagementTraineeSalaryPlan.GeneratePlanList(division, grade, type, "B"); plan_list_c = ManagementTraineeSalaryPlan.GeneratePlanList(division, grade, type, "C"); string years = "五"; if (plan_list_a.Count == 24) { years = "六"; } if (plan_list_a.Count == 28) { years = "七"; } UpStepType ust = ManagementTraineePayStandard.GetUpStepType(division, grade, type); string p = ""; switch (ust) { case UpStepType.五年两段三类: p = "52"; break; case UpStepType.五年两段四类: p = "51"; break; case UpStepType.五年三段四类: p = "53"; break; case UpStepType.七年两段五类: p = "71"; break; case UpStepType.七年三段五类: p = "72"; break; } lbl标题.Text = division + " 届定职人员(" + grade + ")【" + type + "】" + years + "年薪酬计划表"; //加载模板 string filename = Path.Combine(Application.StartupPath, "ReportTemplates\\" + p + "YearSalaryPlan.tab"); spreadsheetControl1.LoadDocument(filename); sheet = spreadsheetControl1.ActiveWorksheet; columns = sheet.Columns; rows = sheet.Rows; cells = sheet.Cells; SetWaitDialogCaption("正在加载数据..."); FillTable(); sheet.ScrollToColumn(0);//焦点切回开始位置 CloseWaitDialog(); }
protected void LoadData() { CreateWaitDialog("正在查询...", "请稍等"); salary_standard_items = ManagementTraineePayStandard.GetManagementTraineePayStandards(trainee.员工编号); division = trainee.届别; grade = trainee.岗位级别; type = trainee.岗位级别 == "一级" ? trainee.岗位类型 : trainee.专业属性; lbl姓名.Text = "姓名:" + trainee.姓名; lbl届别.Text = "届别:" + trainee.届别; lbl类别.Text = trainee.岗位级别 == "一级" ? "岗位类型:" + type : "专业属性:" + type; UpStepType ust = ManagementTraineePayStandard.GetUpStepType(division, grade, type); switch (ust) { case UpStepType.五年两段三类: case UpStepType.五年两段四类: year_count = 5; break; case UpStepType.五年三段四类: year_count = 6; break; case UpStepType.七年两段五类: case UpStepType.七年三段五类: year_count = 7; break; } lbl标题.Text = "定职人员(" + grade + ")【" + type + "】" + trainee.姓名 + "个人年度评定结果及提资表"; //加载模板 string filename = Path.Combine(Application.StartupPath, "ReportTemplates\\" + year_count + "-YearSalaryList.tab"); spreadsheetControl1.LoadDocument(filename); sheet = spreadsheetControl1.ActiveWorksheet; columns = sheet.Columns; rows = sheet.Rows; cells = sheet.Cells; SetWaitDialogCaption("正在加载数据..."); FillTable(); sheet.ScrollToColumn(0); //焦点切回开始位置 CloseWaitDialog(); }
private void ShowRiseRateInputForm(bool isCheck) { UpStepType ust = ManagementTraineePayStandard.GetUpStepType(division, grade, type); switch (ust) { case UpStepType.五年两段三类: RiseRate52InputForm riseRate52InputForm = new RiseRate52InputForm(division, grade, type, isCheck); riseRate52InputForm.Owner = this; riseRate52InputForm.ShowDialog(); break; case UpStepType.五年两段四类: RiseRate51InputForm riseRate51InputForm = new RiseRate51InputForm(division, grade, type, isCheck); riseRate51InputForm.Owner = this; riseRate51InputForm.ShowDialog(); break; case UpStepType.五年三段四类: RiseRate53InputForm riseRate62InputForm = new RiseRate53InputForm(division, grade, type, isCheck); riseRate62InputForm.Owner = this; riseRate62InputForm.ShowDialog(); break; case UpStepType.七年两段五类: RiseRate71InputForm riseRate71InputForm = new RiseRate71InputForm(division, grade, type, isCheck); riseRate71InputForm.Owner = this; riseRate71InputForm.ShowDialog(); break; case UpStepType.七年三段五类: RiseRate72InputForm riseRate72InputForm = new RiseRate72InputForm(division, grade, type, isCheck); riseRate72InputForm.Owner = this; riseRate72InputForm.ShowDialog(); break; } }