private void ExportItemInfoItem(XWPFTable tb) { int i = 0; decimal totalScore = 0; ExportItemByItemType(tb, ref i, ref totalScore); _ItemCount = _ItemCount > 0 ? _ItemCount : 1; SetParagraph(tb.GetRow(_ItemCount + 3 - 1).GetCell(2 - 1), decimal.Round(totalScore, 2).ToString()); SetParagraph(tb.GetRow(_ItemCount + 4 - 1).GetCell(2 - 1), ExportAnnualAssessForm.GetAns(totalScore)); }
private void ExportALLInfo(DataTable dt) { int i; for (i = 0; i < _AssessActivityList.Count; i++) { DataRow dr = dt.NewRow(); dt.Rows.Add(dr); ExportNormalInfo(i, dr); int submintInfoManageIndex = -1; int submintInfoHrIndex = -1; int submintInfoSelfIndex = -1; int submintInfoCeoIndex = -1; GetIndex(_AssessActivityList[i], ref submintInfoSelfIndex, ref submintInfoManageIndex, ref submintInfoHrIndex, ref submintInfoCeoIndex); if (submintInfoCeoIndex != -1) { //建议工资 dr[6] = _AssessActivityList[i].ItsAssessActivityPaper.SubmitInfoes[submintInfoCeoIndex].SalaryChange. ToString(); } if (submintInfoSelfIndex != -1) { //个人评分 dr[7] = CalculateScore( _AssessActivityList[i].ItsAssessActivityPaper.SubmitInfoes[submintInfoSelfIndex]. ItsAssessActivityItems); } if (submintInfoManageIndex != -1) { //主管评分 dr[8] = CalculateScore( _AssessActivityList[i].ItsAssessActivityPaper.SubmitInfoes[submintInfoManageIndex]. ItsAssessActivityItems); dr[_TotalScoreLocation + 3] = _AssessActivityList[i].ItsAssessActivityPaper.SubmitInfoes[submintInfoManageIndex].Comment; //主管总评 } if (submintInfoHrIndex != -1) { //目前工资 dr[5] = _AssessActivityList[i].ItsAssessActivityPaper.SubmitInfoes[submintInfoHrIndex].SalaryNow. ToString(); //导出人事项 for (int t = 0; t < _HrmisQuestion.Count; t++) { foreach ( AssessActivityItem item in _AssessActivityList[i].ItsAssessActivityPaper.SubmitInfoes[submintInfoHrIndex]. ItsAssessActivityItems) { if (item.Question == _HrmisQuestion[t]) { dr[12 + t - 1] = item.Grade * item.Weight; break; } } } } decimal totlescore = _AssessActivityList[i].ItsAssessActivityPaper.Score; dr[_TotalScoreLocation - 1] = totlescore; //年度总评分 dr[_TotalScoreLocation] = ExportAnnualAssessForm.GetAns(totlescore); //综合评价 //360 if (submintInfoSelfIndex != -1) { //导出360项 for (int t = 0; t < _360Question.Count; t++) { foreach ( AssessActivityItem item in _AssessActivityList[i].ItsAssessActivityPaper.SubmitInfoes[submintInfoSelfIndex]. ItsAssessActivityItems) { if (item.Question == _360Question[t]) { dr[_TotalScoreLocation + 5 + t - 1] = item.AssessTemplateItemType == AssessTemplateItemType.Open ? item.Note : item.Grade.ToString(); break; } } } } } ////设置边框和列宽 //Range range = excel.get_Range(excel.Cells[1, 1], excel.Cells[i + 1, _TotalScoreLocation + 4 + _360Question.Count]); //range.Cells.Borders.LineStyle = 1; //range.EntireColumn.AutoFit(); }