private void ProcessDailyLifeRecommend()
        {
            _builder.MoveToMergeField("綜合評語");
            _cell = _builder.CurrentParagraph.ParentNode as Cell;

            TextScoreItemRow itemRow = new TextScoreItemRow("");

            foreach (AutoSummaryRecord asRecord in _list)
            {
                if (asRecord.MoralScore == null)
                {
                    continue;
                }
                JHMoralScoreRecord record   = asRecord.MoralScore;
                SemesterData       semester = new SemesterData("" + record.SchoolYear, "" + record.Semester);

                XmlElement textscore = record.TextScore;
                if (textscore != null)
                {
                    XmlElement item = (XmlElement)textscore.SelectSingleNode("DailyLifeRecommend");
                    if (item != null)
                    {
                        itemRow.Add(semester, item.GetAttribute("Description"));
                    }
                }
            }

            WriteTextScoreItemRow(_cell, itemRow);
        }
        private void ProcessDailyBehavior()
        {
            _builder.MoveToMergeField("日常行為");
            _cell = _builder.CurrentParagraph.ParentNode as Cell;

            Dictionary <string, TextScoreItemRow> items = new Dictionary <string, TextScoreItemRow>();

            foreach (AutoSummaryRecord asRecord in _list)
            {
                if (asRecord.MoralScore == null)
                {
                    continue;
                }
                JHMoralScoreRecord record = asRecord.MoralScore;

                SemesterData semester = new SemesterData("" + record.SchoolYear, "" + record.Semester);

                XmlElement textscore = record.TextScore;
                if (textscore != null)
                {
                    foreach (string name in _sortOrder)
                    {
                        XmlElement item = (XmlElement)textscore.SelectSingleNode("DailyBehavior/Item[@Name='" + name + "']");
                        if (item != null)
                        {
                            if (!items.ContainsKey(name))
                            {
                                items.Add(name, new TextScoreItemRow(name));
                            }
                            items[name].Add(semester, item.GetAttribute("Degree"));
                        }
                    }
                }
            }

            Cell itemCell = _cell;

            foreach (string name in _sortOrder)
            {
                if (items.ContainsKey(name))
                {
                    WriteTextScoreItemRow(itemCell, items[name]);
                }
                itemCell = WordHelper.GetMoveDownCell(itemCell, 1);
                if (itemCell == null)
                {
                    break;
                }
            }
        }
Пример #3
0
        private void ProcessMoralScore(List <AutoSummaryRecord> autoSummaryList)
        {
            Dictionary <string, MoralItemRow> items = new Dictionary <string, MoralItemRow>();

            //團體活動
            MoralItemRow groupActivityRow = null;

            //公共服務
            MoralItemRow publicServiceRow = null;

            //校內外特殊表現
            MoralItemRow schoolSpecialRow = null;
            //具體建議
            MoralItemRow recommendRow = null;

            #region 建立適合列印的資料結構
            foreach (AutoSummaryRecord asRecord in autoSummaryList)
            {
                if (asRecord.MoralScore == null)
                {
                    continue;
                }
                JHMoralScoreRecord record   = asRecord.MoralScore;
                SemesterData       semester = new SemesterData("" + record.SchoolYear, "" + record.Semester);

                XmlElement dailyBehavior = (XmlElement)record.TextScore.SelectSingleNode("DailyBehavior");
                if (dailyBehavior != null)
                {
                    foreach (XmlElement item in dailyBehavior.SelectNodes("Item"))
                    {
                        string name   = item.GetAttribute("Name");
                        string index  = item.GetAttribute("Index");
                        string degree = item.GetAttribute("Degree");

                        string[] lines = index.Split(new string[] { ";", ";" }, StringSplitOptions.RemoveEmptyEntries);

                        if (!items.ContainsKey(name))
                        {
                            items.Add(name, new MoralItemRow(lines));
                        }

                        items[name].Add(semester, degree);
                    }
                }

                XmlElement dailyLifeRecommend = (XmlElement)record.TextScore.SelectSingleNode("DailyLifeRecommend");
                if (dailyLifeRecommend != null)
                {
                    string GroupName = "";
                    if (Utility.MorItemDict.ContainsKey("DailyLifeRecommend"))
                    {
                        GroupName = Utility.MorItemDict["DailyLifeRecommend"];
                    }

                    if (recommendRow == null)
                    {
                        recommendRow = new MoralItemRow(new string[] { GroupName });
                    }
                    recommendRow.Add(semester, dailyLifeRecommend.GetAttribute("Description"));
                }

                // 團體活動
                XmlElement groupActivity = (XmlElement)record.TextScore.SelectSingleNode("GroupActivity");
                if (groupActivity != null)
                {
                    string GroupName = "";
                    if (Utility.MorItemDict.ContainsKey("GroupActivity"))
                    {
                        GroupName = Utility.MorItemDict["GroupActivity"];
                    }

                    if (groupActivityRow == null)
                    {
                        groupActivityRow = new MoralItemRow(new string[] { GroupName });
                    }

                    string text = string.Empty;

                    foreach (XmlElement item in groupActivity.SelectNodes("Item"))
                    {
                        string degree = item.GetAttribute("Degree");
                        string desc   = item.GetAttribute("Description");
                        string name   = item.GetAttribute("Name");

                        if (string.IsNullOrEmpty(degree) && string.IsNullOrEmpty(desc))
                        {
                            continue;
                        }

                        string line = name + ":" + (string.IsNullOrEmpty(degree) ? "" : degree + "/") + (string.IsNullOrEmpty(desc) ? "" : desc);
                        if (line.EndsWith("/"))
                        {
                            line = line.Substring(0, line.Length - 1);
                        }
                        text += line;
                    }

                    // 加入社團
                    if (_assnScoreCache.ContainsKey(record.RefStudentID))
                    {
                        string sc = record.SchoolYear.ToString();
                        string ss = record.Semester.ToString();
                        foreach (AssnScore asc in _assnScoreCache[record.RefStudentID])
                        {
                            if (asc.SchoolYear == sc && asc.Semester == ss)
                            {
                                text += "社團活動:" + asc.Score + "," + asc.Effort + "/" + asc.Text;
                            }
                        }
                    }
                    groupActivityRow.Add(semester, text);
                }



                XmlElement publicService = (XmlElement)record.TextScore.SelectSingleNode("PublicService");
                if (publicService != null)
                {
                    string GroupName = "";
                    if (Utility.MorItemDict.ContainsKey("PublicService"))
                    {
                        GroupName = Utility.MorItemDict["PublicService"];
                    }

                    if (publicServiceRow == null)
                    {
                        publicServiceRow = new MoralItemRow(new string[] { GroupName });
                    }

                    string text = string.Empty;

                    foreach (XmlElement item in publicService.SelectNodes("Item"))
                    {
                        string degree = item.GetAttribute("Degree");
                        string desc   = item.GetAttribute("Description");
                        string name   = item.GetAttribute("Name");

                        if (string.IsNullOrEmpty(degree) && string.IsNullOrEmpty(desc))
                        {
                            continue;
                        }

                        string line = name + ":" + (string.IsNullOrEmpty(degree) ? "" : degree + "/") + (string.IsNullOrEmpty(desc) ? "" : desc);
                        if (line.EndsWith("/"))
                        {
                            line = line.Substring(0, line.Length - 1);
                        }
                        text += line;
                    }

                    publicServiceRow.Add(semester, text);
                }

                XmlElement schoolSpecial = (XmlElement)record.TextScore.SelectSingleNode("SchoolSpecial");
                if (schoolSpecial != null)
                {
                    string GroupName = "";
                    if (Utility.MorItemDict.ContainsKey("SchoolSpecial"))
                    {
                        GroupName = Utility.MorItemDict["SchoolSpecial"];
                    }

                    if (schoolSpecialRow == null)
                    {
                        schoolSpecialRow = new MoralItemRow(new string[] { GroupName });
                    }

                    string text = string.Empty;

                    foreach (XmlElement item in schoolSpecial.SelectNodes("Item"))
                    {
                        string degree = item.GetAttribute("Degree");
                        string desc   = item.GetAttribute("Description");
                        string name   = item.GetAttribute("Name");

                        if (string.IsNullOrEmpty(degree) && string.IsNullOrEmpty(desc))
                        {
                            continue;
                        }

                        string line = name + ":" + (string.IsNullOrEmpty(degree) ? "" : degree + "/") + (string.IsNullOrEmpty(desc) ? "" : desc);
                        if (line.EndsWith("/"))
                        {
                            line = line.Substring(0, line.Length - 1);
                        }
                        text += line;
                    }

                    schoolSpecialRow.Add(semester, text);
                }
            }
            #endregion

            #region 定位,產生Row
            _builder.MoveToMergeField("日常行為表現");
            Cell  currentCell = _builder.CurrentParagraph.ParentNode as Cell;
            Row   currentRow  = currentCell.ParentRow;
            Table table       = currentRow.ParentTable;

            int rowCount    = items.Count;
            int insertIndex = table.Rows.IndexOf(currentRow) + 1;
            for (int i = 1; i < rowCount; i++)
            {
                table.Rows.Insert(insertIndex, currentRow.Clone(true));
            }
            #endregion

            #region 寫入日常行為表現
            Cell cell = currentCell;

            foreach (string key in items.Keys)
            {
                WordHelper.Write(cell, key, _builder);

                Cell indexCell = WordHelper.GetMoveRightCell(cell, 1);
                WriteMoralItemRow(indexCell, items[key]);

                cell = WordHelper.GetMoveDownCell(cell, 1);
            }
            #endregion

            #region 寫入團體活動表現
            _builder.MoveToMergeField("團體活動");
            if (groupActivityRow != null && groupActivityRow.Items.Count > 0)
            {
                currentCell = _builder.CurrentParagraph.ParentNode as Cell;
                WriteMoralItemRow(currentCell, groupActivityRow);
                if (currentCell.Paragraphs.Count > 0)
                {
                    currentCell.Paragraphs[0].ParagraphFormat.Alignment = ParagraphAlignment.Center;
                }
            }
            else
            {
                (_builder.CurrentParagraph.ParentNode as Cell).ParentRow.Remove();
            }
            #endregion

            #region 寫入公共服務表現
            _builder.MoveToMergeField("公共服務");
            if (publicServiceRow != null && publicServiceRow.Items.Count > 0)
            {
                currentCell = _builder.CurrentParagraph.ParentNode as Cell;
                WriteMoralItemRow(currentCell, publicServiceRow);
                if (currentCell.Paragraphs.Count > 0)
                {
                    currentCell.Paragraphs[0].ParagraphFormat.Alignment = ParagraphAlignment.Center;
                }
            }
            else
            {
                (_builder.CurrentParagraph.ParentNode as Cell).ParentRow.Remove();
            }
            #endregion

            #region 寫入校內外特殊表現
            _builder.MoveToMergeField("校內外特殊");
            if (schoolSpecialRow != null && schoolSpecialRow.Items.Count > 0)
            {
                currentCell = _builder.CurrentParagraph.ParentNode as Cell;
                WriteMoralItemRow(currentCell, schoolSpecialRow);
                if (currentCell.Paragraphs.Count > 0)
                {
                    currentCell.Paragraphs[0].ParagraphFormat.Alignment = ParagraphAlignment.Center;
                }
            }
            else
            {
                (_builder.CurrentParagraph.ParentNode as Cell).ParentRow.Remove();
            }
            #endregion

            #region 寫入具體建議
            _builder.MoveToMergeField("具體建議");
            if (recommendRow != null && recommendRow.Items.Count > 0)
            {
                currentCell = _builder.CurrentParagraph.ParentNode as Cell;
                WriteMoralItemRow(currentCell, recommendRow);
                if (currentCell.Paragraphs.Count > 0)
                {
                    currentCell.Paragraphs[0].ParagraphFormat.Alignment = ParagraphAlignment.Center;
                }
            }
            else
            {
                (_builder.CurrentParagraph.ParentNode as Cell).ParentRow.Remove();
            }
            #endregion
        }
        private void ProcessMoralScore(List <AutoSummaryRecord> autoSummaryList)
        {
            Dictionary <string, MoralItemRow> items = new Dictionary <string, MoralItemRow>();
            string recommendName = string.Empty, OtherRecommendName = string.Empty;

            // 綜合評語使用
            MoralItemRow recommendRow = new MoralItemRow(new string[] { });
            // 其他評語使用
            MoralItemRow OtherrecommendRow = new MoralItemRow(new string[] { });

            foreach (AutoSummaryRecord asRecord in autoSummaryList)
            {
                if (asRecord.MoralScore == null)
                {
                    continue;
                }
                JHMoralScoreRecord record   = asRecord.MoralScore;
                SemesterData       semester = new SemesterData("" + record.SchoolYear, "" + record.Semester);

                XmlElement dailyBehavior = (XmlElement)record.TextScore.SelectSingleNode("DailyBehavior");
                if (dailyBehavior != null)
                {
                    foreach (XmlElement item in dailyBehavior.SelectNodes("Item"))
                    {
                        string name   = item.GetAttribute("Name");
                        string index  = item.GetAttribute("Index");
                        string degree = item.GetAttribute("Degree");

                        string[] lines = index.Split(new string[] { ";", ";" }, StringSplitOptions.RemoveEmptyEntries);

                        if (!items.ContainsKey(name))
                        {
                            items.Add(name, new MoralItemRow(lines));
                        }

                        items[name].Add(semester, degree);
                    }
                }

                // 綜和評語
                XmlElement dailyLifeRecommend = (XmlElement)record.TextScore.SelectSingleNode("DailyLifeRecommend");
                // 使用系統設定
                recommendName = GetDLString("綜合評語");
                if (dailyLifeRecommend != null)
                {
                    if (string.IsNullOrEmpty(recommendName))
                    {
                        recommendName = dailyLifeRecommend.GetAttribute("Name");
                    }
                    recommendRow.Add(semester, dailyLifeRecommend.GetAttribute("Description"));
                }



                // 其他
                XmlElement OtherRecommend = (XmlElement)record.TextScore.SelectSingleNode("OtherRecommend");
                // 使用系統設定
                OtherRecommendName = GetDLString("其它表現");
                if (OtherRecommend != null)
                {
                    if (string.IsNullOrEmpty(OtherRecommendName))
                    {
                        OtherRecommendName = OtherRecommend.GetAttribute("Name");
                    }
                    OtherrecommendRow.Add(semester, OtherRecommend.GetAttribute("Description"));
                }
            }

            Cell cell       = _current;
            int  totalCount = 0;

            foreach (string key in items.Keys)
            {
                Write(cell, key);
                int lineCount = items[key].LineCount;

                if (lineCount > 0)
                {
                    MergeVerticalCell(cell, lineCount);

                    Cell otherCell = GetMoveRightCell(cell, 1);
                    MergeVerticalCell(otherCell, lineCount);
                    for (int i = 0; i < 6; i++)
                    {
                        otherCell = GetMoveRightCell(otherCell, 1);
                        if (otherCell == null)
                        {
                            break;
                        }
                        MergeVerticalCell(otherCell, lineCount);
                    }
                }
                else
                {
                    lineCount = 1;
                }

                totalCount += lineCount;

                Cell indexCell = GetMoveRightCell(cell, 1);
                WriteMoralItemRow(indexCell, items[key]);

                cell = GetMoveDownCell(cell, lineCount);
            }

            cell.CellFormat.HorizontalMerge = CellMerge.First;
            GetMoveRightCell(cell, 1).CellFormat.HorizontalMerge = CellMerge.Previous;

            // 綜合評語
            Write(cell, recommendName);

            if (cell != null)
            {
                Row row   = cell.ParentRow;
                int shift = row.IndexOf(cell) + 2;

                foreach (SemesterData sems in recommendRow.Items.Keys)
                {
                    string text  = recommendRow.Items[sems];
                    int    index = -1;
                    if (_map.SemesterMapping.ContainsKey(sems))
                    {
                        index = _map.SemesterMapping[sems];
                    }

                    if (index < 0)
                    {
                        continue;
                    }

                    index = index + shift;
                    Write(row.Cells[index], text);
                }
            }
            // 往下走一格
            cell = GetMoveDownCell(cell, 1);

            int current_row_index = _current.ParentRow.ParentTable.IndexOf(_current.ParentRow);

            current_row_index += totalCount;
            int count = TotalRow + FirstRowIndex - current_row_index;

            Cell tempCell = cell;

            //MergeVerticalCell(tempCell, count);
            //tempCell = GetMoveRightCell(tempCell, 1);
            //MergeVerticalCell(tempCell, count);
            //for (int i = 0; i < 6; i++)
            //{
            //    tempCell = GetMoveRightCell(tempCell, 1);
            //    MergeVerticalCell(tempCell, count);
            //}

            tempCell = cell;
            for (int i = 0; i < count; i++)
            {
                tempCell.CellFormat.HorizontalMerge = CellMerge.First;
                GetMoveRightCell(tempCell, 1).CellFormat.HorizontalMerge = CellMerge.Previous;
                tempCell = GetMoveDownCell(tempCell, 1);
                if (tempCell == null)
                {
                    break;
                }
            }

            // 其他
            Write(cell, OtherRecommendName);

            if (cell != null)
            {
                Row row   = cell.ParentRow;
                int shift = row.IndexOf(cell) + 2;

                foreach (SemesterData sems in OtherrecommendRow.Items.Keys)
                {
                    string text  = OtherrecommendRow.Items[sems];
                    int    index = -1;
                    if (_map.SemesterMapping.ContainsKey(sems))
                    {
                        index = _map.SemesterMapping[sems];
                    }

                    if (index < 0)
                    {
                        continue;
                    }

                    index = index + shift;
                    Write(row.Cells[index], text);
                }
            }

            //int current_row_index = _current.ParentRow.ParentTable.IndexOf(_current.ParentRow);
            //current_row_index += totalCount;
            //int count = TotalRow + FirstRowIndex - current_row_index;

            //Cell tempCell = cell;
            //MergeVerticalCell(tempCell, count);
            //tempCell = GetMoveRightCell(tempCell, 1);
            //MergeVerticalCell(tempCell, count);
            //for (int i = 0; i < 6; i++)
            //{
            //    tempCell = GetMoveRightCell(tempCell, 1);
            //    MergeVerticalCell(tempCell, count);
            //}

            //tempCell = cell;
            //for (int i = 0; i < count; i++)
            //{
            //    tempCell.CellFormat.HorizontalMerge = CellMerge.First;
            //    GetMoveRightCell(tempCell, 1).CellFormat.HorizontalMerge = CellMerge.Previous;
            //    tempCell = GetMoveDownCell(tempCell, 1);
            //    if (tempCell == null) break;
            //}



            _current = cell;
        }
Пример #5
0
        /// <summary>
        /// 填寫DataTable的資料
        /// </summary>
        /// <param name="dt"></param>
        private static void FillData(DataTable dt)
        {
            string printDateTime = SelectTime();
            string schoolName    = K12.Data.School.ChineseName;
            string 校長            = K12.Data.School.Configuration["學校資訊"].PreviousData.SelectSingleNode("ChancellorChineseName").InnerText;
            string 教務主任          = K12.Data.School.Configuration["學校資訊"].PreviousData.SelectSingleNode("EduDirectorName").InnerText;

            //假別設定
            Dictionary <string, List <string> > allowAbsentDic = new Dictionary <string, List <string> >();

            foreach (AbsentSetting abs in _A.Select <AbsentSetting>())
            {
                string target = abs.Target;
                string source = abs.Source;

                if (!allowAbsentDic.ContainsKey(target))
                {
                    allowAbsentDic.Add(target, new List <string>());
                }

                allowAbsentDic[target].Add(source);
            }

            List <string> classIDs   = _students.Select(x => x.RefClassID).Distinct().ToList();
            List <string> studentIDs = _students.Select(x => x.ID).ToList();

            //學生ID字串
            string id_str = string.Join("','", studentIDs);

            id_str = "'" + id_str + "'";

            //班級 catch
            Dictionary <string, ClassRecord> classDic = new Dictionary <string, ClassRecord>();

            foreach (ClassRecord cr in K12.Data.Class.SelectByIDs(classIDs))
            {
                if (!classDic.ContainsKey(cr.ID))
                {
                    classDic.Add(cr.ID, cr);
                }
            }

            //基本資料
            foreach (StudentRecord student in _students)
            {
                DataRow       row       = dt.NewRow();
                ClassRecord   myClass   = classDic.ContainsKey(student.RefClassID) ? classDic[student.RefClassID] : new ClassRecord();
                TeacherRecord myTeacher = myClass.Teacher != null ? myClass.Teacher : new TeacherRecord();

                row["列印日期"] = printDateTime;
                row["學校名稱"] = schoolName;
                row["學年度"]  = _schoolYear;
                row["學期"]   = _semester;
                row["姓名"]   = student.Name;
                row["班級"]   = myClass.Name + "";
                row["班導師"]  = myTeacher.Name + "";
                row["座號"]   = student.SeatNo + "";
                row["學號"]   = student.StudentNumber;

                row["校長"]   = 校長;
                row["教務主任"] = 教務主任;

                //filedName是 "列印假別1~20"
                foreach (string filedName in allowAbsentDic.Keys)
                {
                    row[filedName] = 0;
                }

                dt.Rows.Add(row);

                _RowCatchs.Add(student.ID, row);
            }

            //上課天數
            foreach (SemesterHistoryRecord shr in K12.Data.SemesterHistory.SelectByStudents(_students))
            {
                DataRow row = _RowCatchs[shr.RefStudentID];

                foreach (SemesterHistoryItem shi in shr.SemesterHistoryItems)
                {
                    if (shi.SchoolYear == _schoolYear && shi.Semester == _semester)
                    {
                        row["上課天數"] = shi.SchoolDayCount + "";
                    }
                }
            }

            //學期科目及領域成績
            foreach (JHSemesterScoreRecord jsr in JHSchool.Data.JHSemesterScore.SelectBySchoolYearAndSemester(studentIDs, _schoolYear, _semester))
            {
                DataRow row = _RowCatchs[jsr.RefStudentID];
                _文字描述.Clear();

                //學習領域成績
                if (_UserSelScoreType == "原始成績")
                {
                    row["學習領域成績"] = jsr.LearnDomainScoreOrigin.HasValue ? jsr.LearnDomainScoreOrigin.Value + "" : string.Empty;
                    row["課程學習成績"] = jsr.CourseLearnScoreOrigin.HasValue ? jsr.CourseLearnScoreOrigin.Value + "" : string.Empty;
                }
                else
                {
                    row["學習領域成績"] = jsr.LearnDomainScore.HasValue ? jsr.LearnDomainScore.Value + "" : string.Empty;
                    row["課程學習成績"] = jsr.CourseLearnScore.HasValue ? jsr.CourseLearnScore.Value + "" : string.Empty;
                }


                row["學習領域原始成績"] = jsr.LearnDomainScoreOrigin.HasValue ? jsr.LearnDomainScoreOrigin.Value + "" : string.Empty;
                row["課程學習原始成績"] = jsr.CourseLearnScoreOrigin.HasValue ? jsr.CourseLearnScoreOrigin.Value + "" : string.Empty;

                // 收集領域科目成績給領域科目對照時使用
                Dictionary <string, DomainScore>          DomainScoreDict     = new Dictionary <string, DomainScore>();
                Dictionary <string, List <SubjectScore> > DomainSubjScoreDict = new Dictionary <string, List <SubjectScore> >();



                #region 科目成績照領域排序
                var jsSubjects = new List <SubjectScore>(jsr.Subjects.Values);
                var domainList = new Dictionary <string, int>();
                domainList.Add("語文", 9000);
                domainList.Add("國語文", 8000);
                domainList.Add("英語", 7000);
                domainList.Add("數學", 6000);
                domainList.Add("社會", 5000);
                domainList.Add("自然科學", 4500);
                domainList.Add("自然與生活科技", 4000);
                domainList.Add("藝術", 3500);
                domainList.Add("藝術與人文", 3000);
                domainList.Add("健康與體育", 2000);
                domainList.Add("綜合活動", 1000);
                domainList.Add("彈性課程", 0900);
                jsSubjects.Sort(delegate(SubjectScore r1, SubjectScore r2)
                {
                    decimal rank1 = 0;
                    decimal rank2 = 0;

                    if (r1.Credit != null)
                    {
                        rank1 += r1.Credit.Value;
                    }
                    if (r2.Credit != null)
                    {
                        rank2 += r2.Credit.Value;
                    }

                    if (domainList.ContainsKey(r1.Domain))
                    {
                        rank1 += domainList[r1.Domain];
                    }
                    if (domainList.ContainsKey(r2.Domain))
                    {
                        rank2 += domainList[r2.Domain];
                    }

                    if (rank1 == rank2)
                    {
                        return(r2.Subject.CompareTo(r1.Subject));
                    }
                    else
                    {
                        return(rank2.CompareTo(rank1));
                    }
                });
                #endregion
                //科目成績
                int count = 0;
                foreach (SubjectScore subj in jsSubjects)
                {
                    string ssNmae = subj.Domain;
                    if (string.IsNullOrEmpty(ssNmae))
                    {
                        ssNmae = "彈性課程";
                    }
                    if (!DomainSubjScoreDict.ContainsKey(ssNmae))
                    {
                        DomainSubjScoreDict.Add(ssNmae, new List <SubjectScore>());
                    }

                    DomainSubjScoreDict[ssNmae].Add(subj);

                    count++;

                    //超過就讓它爆炸
                    if (count > Global.SupportSubjectCount)
                    {
                        throw new Exception("超過支援列印科目數量: " + Global.SupportSubjectCount);
                    }

                    row["S科目" + count]   = subj.Subject;
                    row["S領域" + count]   = string.IsNullOrWhiteSpace(subj.Domain) ? "彈性課程" : subj.Domain;
                    row["S節數" + count]   = subj.Period + "";
                    row["S權數" + count]   = subj.Credit + "";
                    row["S成績" + count]   = GetScoreString(subj.Score, subj.ScoreOrigin, subj.ScoreMakeup);
                    row["S等第" + count]   = GetScoreDegreeString(subj.Score, subj.ScoreOrigin);//subj.Score.HasValue ? _degreeMapper.GetDegreeByScore(subj.Score.Value) : string.Empty;
                    row["S原始成績" + count] = subj.ScoreOrigin.HasValue ? subj.ScoreOrigin.Value + "" : string.Empty;
                    row["S補考成績" + count] = subj.ScoreMakeup.HasValue ? subj.ScoreMakeup.Value + "" : string.Empty;
                }


                // 處理領域科目並列
                foreach (string dName in Global.PriDomainNameList())
                {
                    if (DomainSubjScoreDict.ContainsKey(dName))
                    {
                        int si = 1;
                        foreach (SubjectScore ss in DomainSubjScoreDict[dName])
                        {
                            row[dName + "科目" + si] = ss.Subject;
                            row[dName + "領域" + si] = ss.Domain;
                            row[dName + "節數" + si] = ss.Period + "";
                            row[dName + "權數" + si] = ss.Credit + "";

                            row[dName + "等第" + si]   = GetScoreDegreeString(ss.Score, ss.ScoreOrigin);//ss.Score.HasValue ? _degreeMapper.GetDegreeByScore(ss.Score.Value) : string.Empty;
                            row[dName + "成績" + si]   = GetScoreString(ss.Score, ss.ScoreOrigin, ss.ScoreMakeup);
                            row[dName + "原始成績" + si] = ss.ScoreOrigin.HasValue ? ss.ScoreOrigin.Value + "" : string.Empty;
                            row[dName + "補考成績" + si] = ss.ScoreMakeup.HasValue ? ss.ScoreMakeup.Value + "" : string.Empty;
                            si++;
                        }
                    }
                }


                count = 0;
                foreach (DomainScore domain in jsr.Domains.Values)
                {
                    if (!DomainScoreDict.ContainsKey(domain.Domain))
                    {
                        DomainScoreDict.Add(domain.Domain, domain);
                    }

                    count++;

                    //超過就讓它爆炸
                    if (count > Global.SupportDomainCount)
                    {
                        throw new Exception("超過支援列印領域數量: " + Global.SupportDomainCount);
                    }

                    row["D領域" + count] = domain.Domain;
                    row["D節數" + count] = domain.Period + "";
                    row["D權數" + count] = domain.Credit + "";

                    //row["D成績" + count] = domain.Score.HasValue ? domain.Score.Value + "" : string.Empty;
                    row["D成績" + count] = GetScoreString(domain.Score, domain.ScoreOrigin, domain.ScoreMakeup);

                    row["D等第" + count]   = GetScoreDegreeString(domain.Score, domain.ScoreOrigin);//domain.Score.HasValue ? _degreeMapper.GetDegreeByScore(domain.Score.Value) : string.Empty;
                    row["D原始成績" + count] = domain.ScoreOrigin.HasValue ? domain.ScoreOrigin.Value + "" : string.Empty;
                    row["D補考成績" + count] = domain.ScoreMakeup.HasValue ? domain.ScoreMakeup.Value + "" : string.Empty;

                    if (!string.IsNullOrWhiteSpace(domain.Text))
                    {
                        _文字描述.Add(domain.Domain + " : " + domain.Text);
                    }
                }

                // 處理指定領域
                foreach (string dName in Global.PriDomainNameList())
                {
                    if (DomainScoreDict.ContainsKey(dName))
                    {
                        DomainScore domain = DomainScoreDict[dName];
                        row[dName + "領域"]   = domain.Domain;
                        row[dName + "節數"]   = domain.Period + "";
                        row[dName + "權數"]   = domain.Credit + "";
                        row[dName + "成績"]   = GetScoreString(domain.Score, domain.ScoreOrigin, domain.ScoreMakeup);
                        row[dName + "等第"]   = GetScoreDegreeString(domain.Score, domain.ScoreOrigin);//domain.Score.HasValue ? _degreeMapper.GetDegreeByScore(domain.Score.Value) : string.Empty;
                        row[dName + "原始成績"] = domain.ScoreOrigin.HasValue ? domain.ScoreOrigin.Value + "" : string.Empty;
                        row[dName + "補考成績"] = domain.ScoreMakeup.HasValue ? domain.ScoreMakeup.Value + "" : string.Empty;
                    }
                }


                row["文字描述"] = string.Join(Environment.NewLine, _文字描述);
            }

            //預設學年度學期物件
            JHSchool.Behavior.BusinessLogic.SchoolYearSemester sysm = new JHSchool.Behavior.BusinessLogic.SchoolYearSemester(_schoolYear, _semester);

            //AutoSummary
            foreach (AutoSummaryRecord asr in AutoSummary.Select(_students.Select(x => x.ID), new JHSchool.Behavior.BusinessLogic.SchoolYearSemester[] { sysm }))
            {
                DataRow row = _RowCatchs[asr.RefStudentID];

                //缺曠
                foreach (AbsenceCountRecord acr in asr.AbsenceCounts)
                {
                    string key = Global.GetKey(acr.PeriodType, acr.Name);

                    //filedName是 "列印假別1~20"
                    foreach (string filedName in allowAbsentDic.Keys)
                    {
                        foreach (string item in allowAbsentDic[filedName])
                        {
                            if (key == item)
                            {
                                int count = 0;
                                int.TryParse(row[filedName] + "", out count);

                                count         += acr.Count;
                                row[filedName] = count;
                            }
                        }
                    }
                }

                //獎懲
                row["大功"] = asr.MeritA;
                row["小功"] = asr.MeritB;
                row["嘉獎"] = asr.MeritC;
                row["大過"] = asr.DemeritA;
                row["小過"] = asr.DemeritB;
                row["警告"] = asr.DemeritC;

                //日常生活表現
                JHMoralScoreRecord msr       = asr.MoralScore;
                XmlElement         textScore = (msr != null && msr.TextScore != null) ? msr.TextScore : K12.Data.XmlHelper.LoadXml("<TextScore/>");

                foreach (string key in Global.DLBehaviorRef.Keys)
                {
                    SetDLBehaviorData(key, Global.DLBehaviorRef[key], textScore, row);
                }
            }

            //社團成績
            string          condition = string.Format("SchoolYear='{0}' and Semester='{1}' and studentid in ({2})", _schoolYear, _semester, id_str);
            List <AssnCode> list      = _A.Select <AssnCode>(condition);

            foreach (string id in studentIDs)
            {
                int     count = 0;
                DataRow row   = _RowCatchs[id];

                foreach (AssnCode ac in list.FindAll(x => x.StudentID == id))
                {
                    XmlElement scores = K12.Data.XmlHelper.LoadXml(ac.Scores);

                    foreach (XmlElement item in scores.SelectNodes("Item"))
                    {
                        count++;

                        //超過就讓它爆炸
                        if (count > Global.SupportClubCount)
                        {
                            throw new Exception("超過支援列印社團數量: " + Global.SupportClubCount);
                        }

                        string name   = item.GetAttribute("AssociationName");
                        string score  = item.GetAttribute("Score");
                        string effort = item.GetAttribute("Effort");
                        string text   = item.GetAttribute("Text");

                        row["社團Name" + count]   = name;
                        row["社團Score" + count]  = score;
                        row["社團Effort" + count] = effort;
                        row["社團Text" + count]   = text;
                    }
                }
            }

            //服務學習時數
            string    query = string.Format("select ref_student_id,occur_date,reason,hours from $k12.service.learning.record where school_year={0} and semester={1} and ref_student_id in ({2})", _schoolYear, _semester, id_str);
            DataTable table = _Q.Select(query);
            foreach (DataRow dr in table.Rows)
            {
                string sid = dr["ref_student_id"] + "";

                DataRow row = _RowCatchs[sid];

                decimal new_hr = 0;
                decimal.TryParse(dr["hours"] + "", out new_hr);

                decimal old_hr = 0;
                decimal.TryParse(row["服務學習時數"] + "", out old_hr);

                decimal hr = old_hr + new_hr;
                row["服務學習時數"] = hr;
            }

            // 取得體適能資料
            Dictionary <string, List <StudentFitnessRecord_C> > StudentFitnessRecord_CDict = new Dictionary <string, List <StudentFitnessRecord_C> >();

            string       qry       = "ref_student_id in('" + string.Join("','", studentIDs.ToArray()) + "') and school_year=" + _schoolYear;
            AccessHelper accHelper = new AccessHelper();
            List <StudentFitnessRecord_C> StudentFitnessRecord_CList = accHelper.Select <StudentFitnessRecord_C>(qry);

            // 依測驗日期排序
            StudentFitnessRecord_CList = (from data in StudentFitnessRecord_CList orderby data.TestDate ascending select data).ToList();

            foreach (StudentFitnessRecord_C rec in StudentFitnessRecord_CList)
            {
                if (!StudentFitnessRecord_CDict.ContainsKey(rec.StudentID))
                {
                    StudentFitnessRecord_CDict.Add(rec.StudentID, new List <StudentFitnessRecord_C>());
                }

                StudentFitnessRecord_CDict[rec.StudentID].Add(rec);
            }

            foreach (string sid in StudentFitnessRecord_CDict.Keys)
            {
                if (_RowCatchs.ContainsKey(sid))
                {
                    DataRow row = _RowCatchs[sid];
                    int     cot = 1;
                    foreach (StudentFitnessRecord_C rec in StudentFitnessRecord_CDict[sid])
                    {
                        row["身高" + cot]      = rec.Height;
                        row["體重" + cot]      = rec.Weight;
                        row["坐姿體前彎" + cot]   = rec.SitAndReach;
                        row["坐姿體前彎常模" + cot] = rec.SitAndReachDegree;
                        row["立定跳遠" + cot]    = rec.StandingLongJump;
                        row["立定跳遠常模" + cot]  = rec.StandingLongJumpDegree;
                        row["仰臥起坐" + cot]    = rec.SitUp;
                        row["仰臥起坐常模" + cot]  = rec.SitUpDegree;
                        row["心肺適能" + cot]    = rec.Cardiorespiratory;
                        row["心肺適能常模" + cot]  = rec.CardiorespiratoryDegree;
                        cot++;
                    }
                }
            }
        }