コード例 #1
0
 public SemesterDomainScore(DomainScore score)
 {
     RawScore = score;
     Effort   = score.Effort;
     Text     = score.Text;
     Period   = score.Period;
     Value    = score.Score;
     Weight   = score.Credit;
 }
コード例 #2
0
        private static DomainScore GetJHDomainScore(string strDomain, SemesterDomainScore scDomain)
        {
            DomainScore domain = scDomain.RawScore;

            if (domain == null)
            {
                domain        = new DomainScore();
                domain.Domain = strDomain;
            }

            return(domain);
        }
コード例 #3
0
        public static void FillDomainScore(this List <StudentExcess> students)
        {
            //資料表:ischool_student_fitness
            if (students == null || students.Count <= 0)
            {
                return;
            }

            string sql = @"select ref_student_id,school_year,semester,score_info
                                        from sems_subj_score
                                        where ref_student_id in({0})
                                        order by school_year, semester";

            sql = string.Format(sql, students.ToPrimaryKeyStringList());
            DataTable table = Utility.Q.Select(sql);

            //  Dictionary<string, StudentExcess> StudentLookup = students.ToDictionary(x => x.StudentID);

            Dictionary <string, StudentExcess> StudentLookup = new Dictionary <string, StudentExcess>();

            foreach (StudentExcess data in students)
            {
                if (!StudentLookup.ContainsKey(data.StudentID))
                {
                    StudentLookup.Add(data.StudentID, data);
                }
            }

            foreach (DataRow row in table.Rows)
            {
                string id          = row["ref_student_id"] + "";
                int    school_year = int.Parse(row["school_year"] + "");
                int    semester    = int.Parse(row["semester"] + "");
                string score_info  = row["score_info"] + "";

                if (!StudentLookup.ContainsKey(id))
                {
                    continue;
                }

                StudentExcess stu = StudentLookup[id];
                SemesterData  sd  = new SemesterData(0, school_year, semester);
                DomainScore   ds  = ParseDomainScore(score_info);

                stu.DomainScore[sd] = ds;
            }
        }
コード例 #4
0
        private static Dictionary <string, DomainScore> ToDomains(SemesterDomainScoreCollection semesterDomainScoreCollection)
        {
            Dictionary <string, DomainScore> dictDomainScore = new Dictionary <string, DomainScore>();

            foreach (string key in semesterDomainScoreCollection)
            {
                SemesterDomainScore score       = semesterDomainScoreCollection[key];
                DomainScore         domainScore = new DomainScore();
                domainScore.Domain = key;
                domainScore.Period = score.Period;
                domainScore.Credit = score.Weight;
                domainScore.Score  = score.Value;
                dictDomainScore.Add(domainScore.Domain, domainScore);
            }

            return(dictDomainScore);
        }
コード例 #5
0
        private static DomainScore ParseDomainScore(string rawData)
        {
            DomainScore objDS     = new DomainScore();
            string      xmlString = string.Format("<root>{0}</root>", rawData);
            XElement    xmlDom    = XElement.Parse(xmlString);

            foreach (XElement ds in xmlDom.XPathSelectElements("Domains/Domain"))
            {
                if (string.IsNullOrWhiteSpace(ds.Attribute("成績").Value))
                {
                    continue;
                }

                string  name  = ds.Attribute("領域").Value;
                decimal score = decimal.Parse(ds.Attribute("成績").Value);

                objDS[name] = score;
            }

            //解析領域成績。
            return(objDS);
        }
コード例 #6
0
ファイル: Export.cs プロジェクト: ischoolinc/JHEvaluation
 /// <summary>
 /// 取得各領域成績
 /// </summary>
 /// <param name="sem"></param>
 /// <returns></returns>
 public List <decimal?> GetScoreList(SemesterData sem)
 {
     if (_scores.ContainsKey(sem))
     {
         List <decimal?> scoreList = new List <decimal?>();
         foreach (string domain in Global.GetDomains())
         {
             decimal?score = null;
             if (_scores[sem].Domains.ContainsKey(domain))
             {
                 DomainScore domainScore = _scores[sem].Domains[domain];
                 score = domainScore.Score;
             }
             scoreList.Add(score);
         }
         return(scoreList);
     }
     else
     {
         return(new List <decimal?>());
     }
 }
コード例 #7
0
        public void Writer(Document doc)
        {
            DocumentBuilder builder = new DocumentBuilder(doc);

            _warned = false;
            _domainText.Clear();

            if (SemesterScoreRecord == null)
            {
                builder.MoveToMergeField("成績_start");
                builder.MoveToMergeField("成績_end");
                builder.MoveToMergeField("文字描述");
                return;
            }

            builder.MoveToMergeField("成績_start");
            Cell startCell = builder.CurrentParagraph.ParentNode as Cell;

            builder.MoveToMergeField("成績_end");
            Cell endCell = builder.CurrentParagraph.ParentNode as Cell;

            Table table    = startCell.ParentRow.ParentTable;
            int   rowCount = table.IndexOf(endCell.ParentRow) - table.IndexOf(startCell.ParentRow) + 1;
            Font  font     = builder.Font;

            #region 填入學習領域總成績
            if (_printLearnDomain)
            {
                rowCount--;
                WordHelper.MergeHorizontalCell(endCell, 2);
                Cell scoreCell = endCell.NextSibling.NextSibling as Cell;
                WordHelper.MergeHorizontalCell(scoreCell, 2);

                WordHelper.Write(endCell, font, "學習領域總成績");
                WordHelper.Write(scoreCell, font, SemesterScoreRecord.LearnDomainScore.HasValue ? _degreeMapper.GetDegreeByScore(SemesterScoreRecord.LearnDomainScore.Value) : "");
            }
            #endregion

            #region 整理成 Domain -> List<Subject>
            Dictionary <string, List <SubjectScore> > domainSubjects = new Dictionary <string, List <SubjectScore> >();

            foreach (var subject in SemesterScoreRecord.Subjects.Values)
            {
                if (!domainSubjects.ContainsKey(subject.Domain))
                {
                    domainSubjects.Add(subject.Domain, new List <SubjectScore>());
                }
                domainSubjects[subject.Domain].Add(subject);
            }

            string printsocre = _config.GetString("領域科目設定", "Domain");
            if (printsocre == "Domain")
            {
                // 沒有科目成績只有領域成績時加入領域名稱(轉學生用到)
                foreach (DomainScore domin in SemesterScoreRecord.Domains.Values)
                {
                    if (!domainSubjects.ContainsKey(domin.Domain))
                    {
                        domainSubjects.Add(domin.Domain, new List <SubjectScore>());
                    }

                    // 處理新竹語文呈現
                    if (domin.Domain == "語文")
                    {
                        int co = 0;
                        foreach (SubjectScore ss in SemesterScoreRecord.Subjects.Values)
                        {
                            if (ss.Domain == "語文")
                            {
                                co++;
                            }
                        }
                        if (co == 0)
                        {
                            if (!_domainsWithoutDetail.Contains(domin.Domain))
                            {
                                _domainsWithoutDetail.Add(domin.Domain);
                            }
                        }
                    }
                }
            }

            foreach (List <SubjectScore> subjectScoreList in domainSubjects.Values)
            {
                subjectScoreList.Sort(delegate(SubjectScore x, SubjectScore y)
                {
                    return(JHSchool.Evaluation.Subject.CompareSubjectOrdinal(x.Subject, y.Subject));
                });
            }
            #endregion

            #region 檢查成績項目是否超出可列印行數
            int count = 0;
            foreach (string domain in Global.GetDomainList())
            {
                if (_domainsWithoutDetail.Contains(domain))
                {
                    count++;
                }
                else if (domainSubjects.ContainsKey(domain))
                {
                    count += domainSubjects[domain].Count;
                }
            }

            if (count > rowCount && _warned == false)
            {
                MsgBox.Show("成績項目超出可列印行數,部分成績將不會列在報表上。");
                _warned = true;
            }
            #endregion

            #region 填學期成績
            Cell          currentCell = startCell;
            List <string> list        = new List <string>(domainSubjects.Keys);

            // 當只有領域成績
            if (list.Count == 0)
            {
                foreach (var domain in SemesterScoreRecord.Domains.Values)
                {
                    list.Add(domain.Domain);
                }
            }


            list.Sort(JHSchool.Evaluation.Subject.CompareDomainOrdinal);
            foreach (string domain in list)
            {
                if (_domainsWithoutDetail.Contains(domain))
                {
                    #region 只列印領域成績
                    if (!SemesterScoreRecord.Domains.ContainsKey(domain))
                    {
                        continue;
                    }
                    rowCount--;

                    DomainScore domainScore = SemesterScoreRecord.Domains[domain];

                    string group = JHSchool.Evaluation.Subject.GetDomainGroup(domain);
                    if (Global.Params["Mode"] == "KaoHsiung" &&
                        !string.IsNullOrEmpty(group))
                    {
                        currentCell.CellFormat.VerticalMerge = CellMerge.First;
                        WordHelper.Write(currentCell, font, group);
                        WordHelper.Write(currentCell.NextSibling as Cell, font, domain);
                    }
                    else
                    {
                        WordHelper.MergeHorizontalCell(currentCell, 2);
                        WordHelper.Write(currentCell, font, domain);
                    }

                    Cell scoreCell = currentCell.NextSibling.NextSibling as Cell;

                    WordHelper.Write(scoreCell, font, GetPeriodCredit(domainScore.Period, domainScore.Credit));
                    //scoreCell = scoreCell.NextSibling as Cell;
                    //WordHelper.Write(scoreCell, font, "" + domainScore.Score);
                    scoreCell = scoreCell.NextSibling as Cell;
                    WordHelper.Write(scoreCell, font, (domainScore.Score.HasValue ? _degreeMapper.GetDegreeByScore(domainScore.Score.Value) : ""));

                    if (!_domainText.ContainsKey(domain))
                    {
                        _domainText.Add(domain, domainScore.Text);
                    }

                    if (rowCount <= 0)
                    {
                        break;
                    }
                    currentCell = WordHelper.GetMoveDownCell(currentCell, 1);

                    #endregion
                }
                else
                {
                    #region 詳列科目成績
                    if (!domainSubjects.ContainsKey(domain))
                    {
                        continue;
                    }

                    Cell subjectCell  = currentCell;
                    int  subjectCount = 0;
                    foreach (SubjectScore subjectScore in domainSubjects[domain])
                    {
                        rowCount--;
                        subjectCount++;

                        Cell temp = subjectCell.NextSibling as Cell;
                        WordHelper.Write(temp, font, subjectScore.Subject);
                        temp = temp.NextSibling as Cell;
                        WordHelper.Write(temp, font, GetPeriodCredit(subjectScore.Period, subjectScore.Credit));
                        //temp = temp.NextSibling as Cell;
                        //WordHelper.Write(temp, font, "" + subjectScore.Score);
                        temp = temp.NextSibling as Cell;
                        WordHelper.Write(temp, font, (subjectScore.Score.HasValue ? _degreeMapper.GetDegreeByScore(subjectScore.Score.Value) : ""));

                        if (!_domainText.ContainsKey(subjectScore.Subject))
                        {
                            _domainText.Add(subjectScore.Subject, subjectScore.Text);
                        }

                        if (rowCount <= 0)
                        {
                            break;
                        }
                        subjectCell = WordHelper.GetMoveDownCell(subjectCell, 1);
                    }
                    if (subjectCount > 1)
                    {
                        WordHelper.MergeVerticalCell(currentCell, subjectCount);
                    }
                    WordHelper.Write(currentCell, font, string.IsNullOrEmpty(domain) ? "彈性課程" : domain);

                    if (rowCount <= 0)
                    {
                        break;
                    }
                    currentCell = WordHelper.GetMoveDownCell(currentCell, subjectCount);
                    #endregion
                }
            }

            currentCell = startCell;
            string lastGroup = string.Empty;
            while (currentCell != endCell)
            {
                string currentGroup = currentCell.ToTxt().Replace("\r\n", "");
                if (currentGroup == lastGroup && !string.IsNullOrEmpty(lastGroup))
                {
                    currentCell.CellFormat.VerticalMerge = CellMerge.Previous;
                }
                lastGroup   = currentGroup;
                currentCell = WordHelper.GetMoveDownCell(currentCell, 1);
                if (currentCell == null)
                {
                    break;
                }
            }
            #endregion

            #region 填學習領域文字描述
            builder.MoveToMergeField("文字描述");
            Cell      textCell = builder.CurrentParagraph.ParentNode as Cell;
            Paragraph para     = (Paragraph)textCell.GetChild(NodeType.Paragraph, 0, true);
            font = para.ParagraphBreakFont;
            textCell.Paragraphs.Clear();
            foreach (string header in _domainText.Keys)
            {
                if (string.IsNullOrEmpty(_domainText[header]))
                {
                    continue;
                }

                textCell.Paragraphs.Add(new Paragraph(doc));

                Run run1 = new Run(doc);
                run1.Font.Name = font.Name;
                run1.Font.Size = font.Size;
                run1.Font.Bold = true;
                run1.Text      = header + ":";
                Run run2 = new Run(doc);
                run2.Font.Name = font.Name;
                run2.Font.Size = font.Size;
                run2.Text      = _domainText[header];

                textCell.LastParagraph.Runs.Add(run1);
                textCell.LastParagraph.Runs.Add(run2);
            }
            #endregion
        }
コード例 #8
0
        public static void SaveSemesterScoreRecordEditor(IEnumerable <JHSchool.Evaluation.Editor.SemesterScoreRecordEditor> editors)
        {
            Dictionary <string, List <JHSchool.Evaluation.Editor.SemesterScoreRecordEditor> > grouped = new Dictionary <string, List <JHSchool.Evaluation.Editor.SemesterScoreRecordEditor> >();

            foreach (var editor in editors)
            {
                if (!grouped.ContainsKey(editor.RefStudentID))
                {
                    grouped.Add(editor.RefStudentID, new List <JHSchool.Evaluation.Editor.SemesterScoreRecordEditor>());
                }
                grouped[editor.RefStudentID].Add(editor);
            }
            SemesterScore.Instance.SyncData(grouped.Keys);

            DSXmlHelper insertHelper = new DSXmlHelper("InsertRequest");
            DSXmlHelper updateHelper = new DSXmlHelper("UpdateRequest");
            DSXmlHelper deleteHelper = new DSXmlHelper("DeleteRequest");

            bool          do_insert = false, do_update = false, do_delete = false;
            List <string> synclist = new List <string>();

            foreach (var editor in editors)
            {
                if (editor.EditorStatus == JHSchool.Editor.EditorStatus.NoChanged)
                {
                    continue;
                }

                if (editor.EditorStatus == JHSchool.Editor.EditorStatus.Insert)
                {
                    DSXmlHelper partialInsertHelper = new DSXmlHelper("SemesterSubjectScore");
                    partialInsertHelper.AddElement(".", "RefStudentId", editor.RefStudentID);
                    partialInsertHelper.AddElement(".", "SchoolYear", "" + editor.SchoolYear);
                    partialInsertHelper.AddElement(".", "Semester", "" + editor.Semester);
                    partialInsertHelper.AddElement(".", "GradeYear", "" + editor.GradeYear);
                    partialInsertHelper.AddElement(".", "ScoreInfo");

                    partialInsertHelper.AddElement("ScoreInfo", "SemesterSubjectScoreInfo");
                    foreach (var subjectKey in editor.Subjects.Keys)
                    {
                        SubjectScore subject = editor.Subjects[subjectKey];
                        XmlElement   element = partialInsertHelper.AddElement("ScoreInfo/SemesterSubjectScoreInfo", "Subject");
                        element.SetAttribute("領域", subject.Domain);
                        element.SetAttribute("科目", subjectKey);
                        element.SetAttribute("節數", "" + subject.Period);
                        element.SetAttribute("權數", "" + subject.Credit);
                        element.SetAttribute("成績", "" + subject.Score);
                        element.SetAttribute("努力程度", "" + subject.Effort);
                        element.SetAttribute("文字描述", "" + subject.Text);
                        element.SetAttribute("註記", "" + subject.Comment);
                    }

                    partialInsertHelper.AddElement("ScoreInfo", "Domains");
                    foreach (var domainKey in editor.Domains.Keys)
                    {
                        DomainScore domain  = editor.Domains[domainKey];
                        XmlElement  element = partialInsertHelper.AddElement("ScoreInfo/Domains", "Domain");
                        element.SetAttribute("領域", domainKey);
                        element.SetAttribute("節數", "" + domain.Period);
                        element.SetAttribute("權數", "" + domain.Credit);
                        element.SetAttribute("成績", "" + domain.Score);
                        element.SetAttribute("努力程度", "" + domain.Effort);
                        element.SetAttribute("文字描述", "" + domain.Text);
                        element.SetAttribute("註記", "" + domain.Comment);
                    }

                    partialInsertHelper.AddElement("ScoreInfo", "LearnDomainScore", "" + editor.LearnDomainScore);
                    partialInsertHelper.AddElement("ScoreInfo", "CourseLearnScore", "" + editor.CourseLearnScore);

                    insertHelper.AddElement(".", partialInsertHelper.BaseElement);

                    do_insert = true;
                }
                else if (editor.EditorStatus == JHSchool.Editor.EditorStatus.Update)
                {
                    DSXmlHelper partialUpdateHelper = new DSXmlHelper("SemesterSubjectScore");
                    partialUpdateHelper.AddElement("Field");
                    partialUpdateHelper.AddElement("Field", "RefStudentId", editor.RefStudentID);
                    partialUpdateHelper.AddElement("Field", "SchoolYear", "" + editor.SchoolYear);
                    partialUpdateHelper.AddElement("Field", "Semester", "" + editor.Semester);
                    partialUpdateHelper.AddElement("Field", "GradeYear", "" + editor.GradeYear);
                    partialUpdateHelper.AddElement("Field", "ScoreInfo");

                    partialUpdateHelper.AddElement("Field/ScoreInfo", "SemesterSubjectScoreInfo");
                    foreach (var subjectKey in editor.Subjects.Keys)
                    {
                        SubjectScore subject = editor.Subjects[subjectKey];
                        XmlElement   element = partialUpdateHelper.AddElement("Field/ScoreInfo/SemesterSubjectScoreInfo", "Subject");
                        element.SetAttribute("領域", subject.Domain);
                        element.SetAttribute("科目", subjectKey);
                        element.SetAttribute("節數", "" + subject.Period);
                        element.SetAttribute("權數", "" + subject.Credit);
                        element.SetAttribute("成績", "" + subject.Score);
                        element.SetAttribute("努力程度", "" + subject.Effort);
                        element.SetAttribute("文字描述", "" + subject.Text);
                        element.SetAttribute("註記", "" + subject.Comment);
                    }

                    partialUpdateHelper.AddElement("Field/ScoreInfo", "Domains");
                    foreach (var domainKey in editor.Domains.Keys)
                    {
                        DomainScore domain  = editor.Domains[domainKey];
                        XmlElement  element = partialUpdateHelper.AddElement("Field/ScoreInfo/Domains", "Domain");
                        element.SetAttribute("領域", domainKey);
                        element.SetAttribute("節數", "" + domain.Period);
                        element.SetAttribute("權數", "" + domain.Credit);
                        element.SetAttribute("成績", "" + domain.Score);
                        element.SetAttribute("努力程度", "" + domain.Effort);
                        element.SetAttribute("文字描述", "" + domain.Text);
                        element.SetAttribute("註記", "" + domain.Comment);
                    }

                    partialUpdateHelper.AddElement("Field/ScoreInfo", "LearnDomainScore", "" + editor.LearnDomainScore);
                    partialUpdateHelper.AddElement("Field/ScoreInfo", "CourseLearnScore", "" + editor.CourseLearnScore);

                    partialUpdateHelper.AddElement("Condition");
                    partialUpdateHelper.AddElement("Condition", "ID", editor.ID);

                    updateHelper.AddElement(".", partialUpdateHelper.BaseElement);

                    do_update = true;
                    synclist.Add(editor.ID);
                }
                else
                {
                    deleteHelper.AddElement("SemesterSubjectScore");
                    deleteHelper.AddElement("SemesterSubjectScore", "ID", editor.ID);

                    do_delete = true;
                    synclist.Add(editor.ID);
                }
            }

            if (do_insert)
            {
                DSXmlHelper response = FISCA.Authentication.DSAServices.CallService("SmartSchool.Score.InsertSemesterSubjectScore", new DSRequest(insertHelper)).GetContent();
                foreach (XmlElement each in response.GetElements("NewID"))
                {
                    synclist.Add(each.InnerText);
                }
            }

            if (do_update)
            {
                FISCA.Authentication.DSAServices.CallService("SmartSchool.Score.UpdateSemesterSubjectScore", new DSRequest(updateHelper));
            }

            if (do_delete)
            {
                FISCA.Authentication.DSAServices.CallService("SmartSchool.Score.DeleteSemesterSubjectScore", new DSRequest(deleteHelper));
            }

            SemesterScore.Instance.SyncDataBackground(synclist.ToArray());
        }
コード例 #9
0
        public void Save()
        {
            List <JHSemesterScoreRecord> addSemsScore      = new List <JHSemesterScoreRecord>();
            List <JHSemesterScoreRecord> updateSemsScore   = new List <JHSemesterScoreRecord>();
            SubjectScoreLogFormater      subjLogFormater   = new SubjectScoreLogFormater();
            DomainScoreLogFormater       domainLogFormater = new DomainScoreLogFormater();

            foreach (StudentScore student in Students)
            {
                #region 決定要新增還是更新。
                JHSemesterScoreRecord JHScore = GetJHSemesterScore(student.Id, student.SemestersScore[SemesterData.Empty]);
                SCSemsScore           SCScore = student.SemestersScore[SemesterData.Empty];

                if (string.IsNullOrEmpty(JHScore.ID))
                {
                    addSemsScore.Add(JHScore);
                }
                else
                {
                    updateSemsScore.Add(JHScore);
                }
                #endregion

                #region 產生科目資料。
                JHScore.Subjects.Clear();
                foreach (string strSubject in SCScore.Subject)
                {
                    SemesterSubjectScore objSCSubject = SCScore.Subject[strSubject];
                    SubjectScore         objJHSubject = GetJHSubjectScore(strSubject, objSCSubject);
                    LogData subjLog = new LogData(strSubject);
                    subjLog.Formater = subjLogFormater;

                    decimal?score = objSCSubject.Value.HasValue ? (decimal?)(double)objSCSubject.Value : null;

                    //記錄 Log
                    subjLog.Add(new LogData("成績", objJHSubject.Score + "", score.ToString()));
                    subjLog.Add(new LogData("權重", objJHSubject.Credit + "", objSCSubject.Weight + ""));
                    subjLog.Add(new LogData("節數", objJHSubject.Period + "", objSCSubject.Period + ""));
                    if (Program.Mode == ModuleMode.KaoHsiung)
                    {
                        subjLog.Add(new LogData("努力程度", objJHSubject.Effort + "", objSCSubject.Effort + ""));
                    }
                    subjLog.Add(new LogData("文字評量", objJHSubject.Text + "", objSCSubject.Text));
                    subjLog.Add(new LogData("領域", objJHSubject.Domain + "", objSCSubject.Domain));
                    SCScore.Subject.Log.Add(subjLog);

                    objJHSubject.Score  = score;
                    objJHSubject.Credit = objSCSubject.Weight;
                    objJHSubject.Period = objSCSubject.Period;
                    objJHSubject.Effort = objSCSubject.Effort;
                    objJHSubject.Text   = objSCSubject.Text;
                    objJHSubject.Domain = objSCSubject.Domain;

                    JHScore.Subjects.Add(strSubject, objJHSubject);
                }

                //排序科目名稱。
                Dictionary <string, SubjectScore> orderSubject = new Dictionary <string, SubjectScore>(JHScore.Subjects);
                JHScore.Subjects.Clear();
                foreach (string subjName in Util.SortSubjectDomain(orderSubject.Keys))
                {
                    JHScore.Subjects.Add(subjName, orderSubject[subjName]);
                }
                #endregion

                #region 產生領域資料。
                JHScore.Domains.Clear();
                foreach (string strDomain in SCScore.Domain)
                {
                    //彈性課程不記錄領域領域。
                    if (Util.IsVariableDomain(strDomain))
                    {
                        continue;
                    }

                    SemesterDomainScore objSCDomain = SCScore.Domain[strDomain];
                    DomainScore         objJHDomain = GetJHDomainScore(strDomain, objSCDomain);
                    LogData             domainLog   = new LogData(strDomain);
                    domainLog.Formater = subjLogFormater;

                    decimal?score = objSCDomain.Value.HasValue ? (decimal?)(double)objSCDomain.Value : null;

                    //記錄 Log
                    domainLog.Add(new LogData("成績", objJHDomain.Score + "", score + ""));
                    domainLog.Add(new LogData("權重", objJHDomain.Credit + "", objSCDomain.Weight + ""));
                    domainLog.Add(new LogData("節數", objJHDomain.Period + "", objSCDomain.Period + ""));
                    if (Program.Mode == ModuleMode.KaoHsiung)
                    {
                        domainLog.Add(new LogData("努力程度", objJHDomain.Effort + "", objSCDomain.Effort + ""));
                    }
                    domainLog.Add(new LogData("文字評量", objJHDomain.Text + "", objSCDomain.Text));
                    SCScore.Domain.Log.Add(domainLog);

                    objJHDomain.Score  = score;
                    objJHDomain.Credit = objSCDomain.Weight;
                    objJHDomain.Period = objSCDomain.Period;
                    objJHDomain.Effort = objSCDomain.Effort;
                    objJHDomain.Text   = objSCDomain.Text;

                    JHScore.Domains.Add(strDomain, objJHDomain);
                }

                //記錄 Log
                SCScore.LearningLog.Formater    = domainLogFormater;
                SCScore.LearningLog.OriginValue = JHScore.CourseLearnScore + "";
                SCScore.LearningLog.NewValue    = SCScore.LearnDomainScore + "";
                SCScore.CourseLog.Formater      = domainLogFormater;
                SCScore.CourseLog.OriginValue   = JHScore.CourseLearnScore + "";
                SCScore.CourseLog.NewValue      = SCScore.CourseLearnScore + "";

                JHScore.LearnDomainScore = SCScore.LearnDomainScore;
                JHScore.CourseLearnScore = SCScore.CourseLearnScore;

                //排序領域名稱。
                Dictionary <string, DomainScore> orderDomain = new Dictionary <string, DomainScore>(JHScore.Domains);
                JHScore.Domains.Clear();
                foreach (string domainName in Util.SortSubjectDomain(orderDomain.Keys))
                {
                    JHScore.Domains.Add(domainName, orderDomain[domainName]);
                }
                #endregion
            }

            #region 新增科目成績
            FunctionSpliter <JHSemesterScoreRecord, JHSemesterScoreRecord> addSpliter =
                new FunctionSpliter <JHSemesterScoreRecord, JHSemesterScoreRecord>(500, 5);
            addSpliter.Function = delegate(List <JHSemesterScoreRecord> part)
            {
                // 加入檢查當科目與領域成績筆數0不新增
                List <JHSemesterScoreRecord> insertPart = new List <JHSemesterScoreRecord> ();

                foreach (JHSemesterScoreRecord rec in part)
                {
                    // 沒有任何領域或科目成績
                    if (rec.Domains.Count == 0 && rec.Subjects.Count == 0)
                    {
                        continue;
                    }

                    insertPart.Add(rec);
                }

                if (insertPart.Count > 0)
                {
                    JHSemesterScore.Insert(insertPart);
                }

                return(new List <JHSemesterScoreRecord>());
            };
            addSpliter.ProgressChange = delegate(int progress)
            {
                Reporter.Feedback("新增科目成績...", Util.CalculatePercentage(addSemsScore.Count, progress));
            };
            addSpliter.Execute(addSemsScore);
            #endregion

            #region 更新科目成績
            FunctionSpliter <JHSemesterScoreRecord, JHSemesterScoreRecord> updateSpliter =
                new FunctionSpliter <JHSemesterScoreRecord, JHSemesterScoreRecord>(500, 5);
            updateSpliter.Function = delegate(List <JHSemesterScoreRecord> part)
            {
                JHSemesterScore.Update(part);
                return(new List <JHSemesterScoreRecord>());
            };
            updateSpliter.ProgressChange = delegate(int progress)
            {
                Reporter.Feedback("更新科目成績...", Util.CalculatePercentage(updateSemsScore.Count, progress));
            };
            updateSpliter.Execute(updateSemsScore);
            #endregion
        }
コード例 #10
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++;
                    }
                }
            }
        }
コード例 #11
0
        public static void CalcDomainScore(this List <StudentExcess> students)
        {
            //得分項目。
            HashSet <string> lookup = new HashSet <string>(new string[] {
                "健康與體育",
                "藝術與人文", //藝術與人文
                "綜合活動"
            });

            foreach (StudentExcess student in students) //所有學生。
            {
                SemesterDataCollection allSems = student.FiveSemester.ToSemesterOnly();
                Dictionary <string, DomainAvgCalculator> calculate = new Dictionary <string, DomainAvgCalculator>();

                foreach (SemesterData sems in allSems) //所有學期
                {
                    if (!student.DomainScore.ContainsKey(sems))
                    {
                        continue;
                    }

                    DomainScore ds = student.DomainScore[sems];

                    foreach (string dn in ds.Keys) //所有領域成績
                    {
                        string name = dn.Trim();

                        if (!lookup.Contains(name)) //非需要的領域不處理。
                        {
                            continue;
                        }

                        if (!calculate.ContainsKey(name))
                        {
                            calculate[dn] = new DomainAvgCalculator();
                        }

                        //將指定領域的成績加入到計算機中。
                        calculate[name].AddScore(ds[name]);
                    }
                }

                int passCount = 0;
                foreach (DomainAvgCalculator avg in calculate.Values)
                {
                    if (avg.IsPassed)
                    {
                        passCount++;
                    }
                }

                decimal score = 0;

                switch (passCount)
                {
                case 1:
                    score = 3;
                    break;

                case 2:
                    score = 6;
                    break;

                case 3:
                    score = 10;
                    break;
                }

                student.DomainScoreFinal = score;
            }
        }
コード例 #12
0
ファイル: Export.cs プロジェクト: ischoolinc/JHEvaluation
            /// <summary>
            /// 取得五學期領域成績平均
            /// </summary>
            /// <param name="sems"></param>
            /// <returns></returns>
            public decimal?GetAverage(SemesterDataCollection sems)
            {
                decimal sum, count;

                Dictionary <SemesterData, decimal?> semScores = new Dictionary <SemesterData, decimal?>();

                foreach (SemesterData sem in sems)
                {
                    sum = count = decimal.Zero;

                    if (!_scores.ContainsKey(sem))
                    {
                        continue;
                    }
                    foreach (string domain in Global.GetDomains())
                    {
                        if (!_scores[sem].Domains.ContainsKey(domain))
                        {
                            continue;
                        }

                        DomainScore domainScore = _scores[sem].Domains[domain];
                        if (!domainScore.Score.HasValue)
                        {
                            continue;
                        }
                        if (!domainScore.Credit.HasValue)
                        {
                            continue;
                        }
                        sum   += domainScore.Score.Value * domainScore.Credit.Value;
                        count += domainScore.Credit.Value;
                    }
                    if (count > 0)
                    {
                        semScores.Add(sem, sum / count);
                    }
                    else
                    {
                        semScores.Add(sem, null);
                    }
                }

                sum = count = decimal.Zero;
                foreach (decimal?score in semScores.Values)
                {
                    if (!score.HasValue)
                    {
                        continue;
                    }
                    sum += score.Value;
                    count++;
                }

                if (count > 0)
                {
                    return(sum / count);
                }
                else
                {
                    return(null);
                }
            }