/// <summary> /// 刪除一筆 UDTAccess 紀錄 /// </summary> /// <param name="club"></param> public static void Delete(UDTTeacherWords healthy) { List<ActiveRecord> healthys = new List<ActiveRecord>(); healthys.Add(healthy); udtHelper.DeletedValues(healthys); if (ItemChanged != null) ItemChanged(null, EventArgs.Empty); }
private void TeacherWord_SaveButtonClick(object sender, EventArgs e) { //dataGridView1.EndEdit(); //dataGridView1.CancelEdit(); _Source.SaveAll(); // 先清再加 // delete all if (_Source.Count > 0) { foreach (var var_Source in _Source) { UDTAccess.Delete(var_Source); } } // add one record UDTTeacherWords teacherWord = new UDTTeacherWords(); teacherWord.ClassID = PrimaryKey; teacherWord.TeacherWord = this.richTextBox1.Text; teacherWord.Heading = this.textBox1.Text.Equals("") ? "親愛的孩子" : this.textBox1.Text; // 取班導師姓名 classRecords = accessHelper.ClassHelper.GetClass(new string[] { PrimaryKey }); if (this.textBox2.Text.Equals("") && classRecords.Count > 0) { teacherWord.TeacherName = classRecords[0].RefTeacher.TeacherName; } else { teacherWord.TeacherName = this.textBox2.Text; } UDTAccess.Insert(teacherWord); OnPrimaryKeyChanged(new EventArgs()); ShowButton(false); }
static void Program_Click(object sender_, EventArgs e_) { ConfigForm form = new ConfigForm(); string whereClause; //aaron // BMK UDT UDTTeacherWords teacherWord = new UDTTeacherWords(); //UDTAccess.Insert(teacherWord); //string whereClause = string.Format("班級編號='{0}'", "ClassID"); //List<UDTTeacherWords> healthys = UDTAccess.Select(whereClause); //UDTTeacherWords whereClauseRecord; //if (healthys.Count > 0) //{ //whereClauseRecord = healthys[0]; //UDTAccess.Delete(whereClauseRecord); //} if (form.ShowDialog() == DialogResult.OK) { AccessHelper accessHelper = new AccessHelper(); //return; List<StudentRecord> overflowRecords = new List<StudentRecord>(); // 不參與排名的學生 List<StudentRecord> deleteRecords = new List<StudentRecord>(); List<StudentRecord> deletePreRecords = new List<StudentRecord>(); List<StudentRecord> deleteSelectedRecords = new List<StudentRecord>(); //取得列印設定 //2222 Configure conf = form.Configure; // 2013-01-23 aaron 拉到全域變數 //建立測試的選取學生(先期不管怎麼選就是印這些人) //List<string> selectedStudents = K12.Presentation.NLDPanels.Student.SelectedSource; // BMK 建立合併欄位總表 DataTable table = new DataTable(); #region 所有的合併欄位 table.Columns.Add("學校名稱"); table.Columns.Add("學校地址"); table.Columns.Add("學校電話"); table.Columns.Add("收件人地址"); //«通訊地址»«通訊地址郵遞區號»«通訊地址內容» //«戶籍地址»«戶籍地址郵遞區號»«戶籍地址內容» //«監護人»«父親»«母親»«科別名稱» table.Columns.Add("通訊地址"); table.Columns.Add("通訊地址郵遞區號"); table.Columns.Add("通訊地址內容"); table.Columns.Add("戶籍地址"); table.Columns.Add("戶籍地址郵遞區號"); table.Columns.Add("戶籍地址內容"); table.Columns.Add("監護人"); table.Columns.Add("父親"); table.Columns.Add("母親"); table.Columns.Add("科別名稱"); table.Columns.Add("試別"); table.Columns.Add("收件人"); table.Columns.Add("學年度"); table.Columns.Add("學期"); table.Columns.Add("班級科別名稱"); table.Columns.Add("班級"); table.Columns.Add("班導師"); table.Columns.Add("座號"); table.Columns.Add("學號"); table.Columns.Add("姓名"); table.Columns.Add("定期評量"); for (int subjectIndex = 1; subjectIndex <= conf.SubjectLimit; subjectIndex++) { table.Columns.Add("科目名稱" + subjectIndex); table.Columns.Add("學分數" + subjectIndex); table.Columns.Add("前次成績" + subjectIndex); table.Columns.Add("科目成績" + subjectIndex); table.Columns.Add("班排名" + subjectIndex); table.Columns.Add("班排名母數" + subjectIndex); table.Columns.Add("科排名" + subjectIndex); table.Columns.Add("科排名母數" + subjectIndex); table.Columns.Add("類別1排名" + subjectIndex); table.Columns.Add("類別1排名母數" + subjectIndex); table.Columns.Add("類別2排名" + subjectIndex); table.Columns.Add("類別2排名母數" + subjectIndex); table.Columns.Add("全校排名" + subjectIndex); table.Columns.Add("全校排名母數" + subjectIndex); // aaron table.Columns.Add("選修" + subjectIndex); table.Columns.Add("PR" + subjectIndex); table.Columns.Add("PrePR" + subjectIndex); table.Columns.Add("前次班排名" + subjectIndex); table.Columns.Add("前次班排名母數" + subjectIndex); #region 瘋狂的組距及分析 table.Columns.Add("班高標" + subjectIndex); table.Columns.Add("科高標" + subjectIndex); table.Columns.Add("校高標" + subjectIndex); table.Columns.Add("類1高標" + subjectIndex); table.Columns.Add("類2高標" + subjectIndex); table.Columns.Add("班均標" + subjectIndex); table.Columns.Add("科均標" + subjectIndex); table.Columns.Add("校均標" + subjectIndex); table.Columns.Add("類1均標" + subjectIndex); table.Columns.Add("類2均標" + subjectIndex); table.Columns.Add("班低標" + subjectIndex); table.Columns.Add("科低標" + subjectIndex); table.Columns.Add("校低標" + subjectIndex); table.Columns.Add("類1低標" + subjectIndex); table.Columns.Add("類2低標" + subjectIndex); table.Columns.Add("班標準差" + subjectIndex); table.Columns.Add("科標準差" + subjectIndex); table.Columns.Add("校標準差" + subjectIndex); table.Columns.Add("類1標準差" + subjectIndex); table.Columns.Add("類2標準差" + subjectIndex); table.Columns.Add("班組距" + subjectIndex + "count90"); table.Columns.Add("科組距" + subjectIndex + "count90"); table.Columns.Add("校組距" + subjectIndex + "count90"); table.Columns.Add("類1組距" + subjectIndex + "count90"); table.Columns.Add("類2組距" + subjectIndex + "count90"); table.Columns.Add("班組距" + subjectIndex + "count80"); table.Columns.Add("科組距" + subjectIndex + "count80"); table.Columns.Add("校組距" + subjectIndex + "count80"); table.Columns.Add("類1組距" + subjectIndex + "count80"); table.Columns.Add("類2組距" + subjectIndex + "count80"); table.Columns.Add("班組距" + subjectIndex + "count70"); table.Columns.Add("科組距" + subjectIndex + "count70"); table.Columns.Add("校組距" + subjectIndex + "count70"); table.Columns.Add("類1組距" + subjectIndex + "count70"); table.Columns.Add("類2組距" + subjectIndex + "count70"); table.Columns.Add("班組距" + subjectIndex + "count60"); table.Columns.Add("科組距" + subjectIndex + "count60"); table.Columns.Add("校組距" + subjectIndex + "count60"); table.Columns.Add("類1組距" + subjectIndex + "count60"); table.Columns.Add("類2組距" + subjectIndex + "count60"); table.Columns.Add("班組距" + subjectIndex + "count50"); table.Columns.Add("科組距" + subjectIndex + "count50"); table.Columns.Add("校組距" + subjectIndex + "count50"); table.Columns.Add("類1組距" + subjectIndex + "count50"); table.Columns.Add("類2組距" + subjectIndex + "count50"); table.Columns.Add("班組距" + subjectIndex + "count40"); table.Columns.Add("科組距" + subjectIndex + "count40"); table.Columns.Add("校組距" + subjectIndex + "count40"); table.Columns.Add("類1組距" + subjectIndex + "count40"); table.Columns.Add("類2組距" + subjectIndex + "count40"); table.Columns.Add("班組距" + subjectIndex + "count30"); table.Columns.Add("科組距" + subjectIndex + "count30"); table.Columns.Add("校組距" + subjectIndex + "count30"); table.Columns.Add("類1組距" + subjectIndex + "count30"); table.Columns.Add("類2組距" + subjectIndex + "count30"); table.Columns.Add("班組距" + subjectIndex + "count20"); table.Columns.Add("科組距" + subjectIndex + "count20"); table.Columns.Add("校組距" + subjectIndex + "count20"); table.Columns.Add("類1組距" + subjectIndex + "count20"); table.Columns.Add("類2組距" + subjectIndex + "count20"); table.Columns.Add("班組距" + subjectIndex + "count10"); table.Columns.Add("科組距" + subjectIndex + "count10"); table.Columns.Add("校組距" + subjectIndex + "count10"); table.Columns.Add("類1組距" + subjectIndex + "count10"); table.Columns.Add("類2組距" + subjectIndex + "count10"); table.Columns.Add("班組距" + subjectIndex + "count100Up"); table.Columns.Add("科組距" + subjectIndex + "count100Up"); table.Columns.Add("校組距" + subjectIndex + "count100Up"); table.Columns.Add("類1組距" + subjectIndex + "count100Up"); table.Columns.Add("類2組距" + subjectIndex + "count100Up"); table.Columns.Add("班組距" + subjectIndex + "count90Up"); table.Columns.Add("科組距" + subjectIndex + "count90Up"); table.Columns.Add("校組距" + subjectIndex + "count90Up"); table.Columns.Add("類1組距" + subjectIndex + "count90Up"); table.Columns.Add("類2組距" + subjectIndex + "count90Up"); table.Columns.Add("班組距" + subjectIndex + "count80Up"); table.Columns.Add("科組距" + subjectIndex + "count80Up"); table.Columns.Add("校組距" + subjectIndex + "count80Up"); table.Columns.Add("類1組距" + subjectIndex + "count80Up"); table.Columns.Add("類2組距" + subjectIndex + "count80Up"); table.Columns.Add("班組距" + subjectIndex + "count70Up"); table.Columns.Add("科組距" + subjectIndex + "count70Up"); table.Columns.Add("校組距" + subjectIndex + "count70Up"); table.Columns.Add("類1組距" + subjectIndex + "count70Up"); table.Columns.Add("類2組距" + subjectIndex + "count70Up"); table.Columns.Add("班組距" + subjectIndex + "count60Up"); table.Columns.Add("科組距" + subjectIndex + "count60Up"); table.Columns.Add("校組距" + subjectIndex + "count60Up"); table.Columns.Add("類1組距" + subjectIndex + "count60Up"); table.Columns.Add("類2組距" + subjectIndex + "count60Up"); table.Columns.Add("班組距" + subjectIndex + "count50Up"); table.Columns.Add("科組距" + subjectIndex + "count50Up"); table.Columns.Add("校組距" + subjectIndex + "count50Up"); table.Columns.Add("類1組距" + subjectIndex + "count50Up"); table.Columns.Add("類2組距" + subjectIndex + "count50Up"); table.Columns.Add("班組距" + subjectIndex + "count40Up"); table.Columns.Add("科組距" + subjectIndex + "count40Up"); table.Columns.Add("校組距" + subjectIndex + "count40Up"); table.Columns.Add("類1組距" + subjectIndex + "count40Up"); table.Columns.Add("類2組距" + subjectIndex + "count40Up"); table.Columns.Add("班組距" + subjectIndex + "count30Up"); table.Columns.Add("科組距" + subjectIndex + "count30Up"); table.Columns.Add("校組距" + subjectIndex + "count30Up"); table.Columns.Add("類1組距" + subjectIndex + "count30Up"); table.Columns.Add("類2組距" + subjectIndex + "count30Up"); table.Columns.Add("班組距" + subjectIndex + "count20Up"); table.Columns.Add("科組距" + subjectIndex + "count20Up"); table.Columns.Add("校組距" + subjectIndex + "count20Up"); table.Columns.Add("類1組距" + subjectIndex + "count20Up"); table.Columns.Add("類2組距" + subjectIndex + "count20Up"); table.Columns.Add("班組距" + subjectIndex + "count10Up"); table.Columns.Add("科組距" + subjectIndex + "count10Up"); table.Columns.Add("校組距" + subjectIndex + "count10Up"); table.Columns.Add("類1組距" + subjectIndex + "count10Up"); table.Columns.Add("類2組距" + subjectIndex + "count10Up"); table.Columns.Add("班組距" + subjectIndex + "count90Down"); table.Columns.Add("科組距" + subjectIndex + "count90Down"); table.Columns.Add("校組距" + subjectIndex + "count90Down"); table.Columns.Add("類1組距" + subjectIndex + "count90Down"); table.Columns.Add("類2組距" + subjectIndex + "count90Down"); table.Columns.Add("班組距" + subjectIndex + "count80Down"); table.Columns.Add("科組距" + subjectIndex + "count80Down"); table.Columns.Add("校組距" + subjectIndex + "count80Down"); table.Columns.Add("類1組距" + subjectIndex + "count80Down"); table.Columns.Add("類2組距" + subjectIndex + "count80Down"); table.Columns.Add("班組距" + subjectIndex + "count70Down"); table.Columns.Add("科組距" + subjectIndex + "count70Down"); table.Columns.Add("校組距" + subjectIndex + "count70Down"); table.Columns.Add("類1組距" + subjectIndex + "count70Down"); table.Columns.Add("類2組距" + subjectIndex + "count70Down"); table.Columns.Add("班組距" + subjectIndex + "count60Down"); table.Columns.Add("科組距" + subjectIndex + "count60Down"); table.Columns.Add("校組距" + subjectIndex + "count60Down"); table.Columns.Add("類1組距" + subjectIndex + "count60Down"); table.Columns.Add("類2組距" + subjectIndex + "count60Down"); table.Columns.Add("班組距" + subjectIndex + "count50Down"); table.Columns.Add("科組距" + subjectIndex + "count50Down"); table.Columns.Add("校組距" + subjectIndex + "count50Down"); table.Columns.Add("類1組距" + subjectIndex + "count50Down"); table.Columns.Add("類2組距" + subjectIndex + "count50Down"); table.Columns.Add("班組距" + subjectIndex + "count40Down"); table.Columns.Add("科組距" + subjectIndex + "count40Down"); table.Columns.Add("校組距" + subjectIndex + "count40Down"); table.Columns.Add("類1組距" + subjectIndex + "count40Down"); table.Columns.Add("類2組距" + subjectIndex + "count40Down"); table.Columns.Add("班組距" + subjectIndex + "count30Down"); table.Columns.Add("科組距" + subjectIndex + "count30Down"); table.Columns.Add("校組距" + subjectIndex + "count30Down"); table.Columns.Add("類1組距" + subjectIndex + "count30Down"); table.Columns.Add("類2組距" + subjectIndex + "count30Down"); table.Columns.Add("班組距" + subjectIndex + "count20Down"); table.Columns.Add("科組距" + subjectIndex + "count20Down"); table.Columns.Add("校組距" + subjectIndex + "count20Down"); table.Columns.Add("類1組距" + subjectIndex + "count20Down"); table.Columns.Add("類2組距" + subjectIndex + "count20Down"); table.Columns.Add("班組距" + subjectIndex + "count10Down"); table.Columns.Add("科組距" + subjectIndex + "count10Down"); table.Columns.Add("校組距" + subjectIndex + "count10Down"); table.Columns.Add("類1組距" + subjectIndex + "count10Down"); table.Columns.Add("類2組距" + subjectIndex + "count10Down"); #endregion } table.Columns.Add("總分"); table.Columns.Add("總分班排名"); table.Columns.Add("總分班排名母數"); table.Columns.Add("總分科排名"); table.Columns.Add("總分科排名母數"); table.Columns.Add("總分全校排名"); table.Columns.Add("總分全校排名母數"); table.Columns.Add("平均"); table.Columns.Add("平均班排名"); table.Columns.Add("平均班排名母數"); table.Columns.Add("平均科排名"); table.Columns.Add("平均科排名母數"); table.Columns.Add("平均全校排名"); table.Columns.Add("平均全校排名母數"); table.Columns.Add("加權總分"); table.Columns.Add("加權總分班排名"); table.Columns.Add("加權總分班排名母數"); table.Columns.Add("加權總分科排名"); table.Columns.Add("加權總分科排名母數"); table.Columns.Add("加權總分全校排名"); table.Columns.Add("加權總分全校排名母數"); table.Columns.Add("加權平均"); table.Columns.Add("加權平均班排名"); table.Columns.Add("加權平均班排名母數"); table.Columns.Add("加權平均科排名"); table.Columns.Add("加權平均科排名母數"); table.Columns.Add("加權平均全校排名"); table.Columns.Add("加權平均全校排名母數"); // aaron table.Columns.Add("所修學分"); table.Columns.Add("親愛的孩子"); table.Columns.Add("導師的話"); table.Columns.Add("導師"); table.Columns.Add("類別排名1"); table.Columns.Add("類別1總分"); table.Columns.Add("類別1總分排名"); table.Columns.Add("類別1總分排名母數"); table.Columns.Add("類別1平均"); table.Columns.Add("類別1平均排名"); table.Columns.Add("類別1平均排名母數"); table.Columns.Add("類別1加權總分"); table.Columns.Add("類別1加權總分排名"); table.Columns.Add("類別1加權總分排名母數"); table.Columns.Add("類別1加權平均"); table.Columns.Add("類別1加權平均排名"); table.Columns.Add("類別1加權平均排名母數"); //aaron table.Columns.Add("類別1所修學分"); table.Columns.Add("類別排名2"); table.Columns.Add("類別2總分"); table.Columns.Add("類別2總分排名"); table.Columns.Add("類別2總分排名母數"); table.Columns.Add("類別2平均"); table.Columns.Add("類別2平均排名"); table.Columns.Add("類別2平均排名母數"); table.Columns.Add("類別2加權總分"); table.Columns.Add("類別2加權總分排名"); table.Columns.Add("類別2加權總分排名母數"); table.Columns.Add("類別2加權平均"); table.Columns.Add("類別2加權平均排名"); table.Columns.Add("類別2加權平均排名母數"); // 獎懲統計 -- table.Columns.Add("大功統計"); table.Columns.Add("小功統計"); table.Columns.Add("嘉獎統計"); table.Columns.Add("大過統計"); table.Columns.Add("小過統計"); table.Columns.Add("警告統計"); table.Columns.Add("留校察看"); #region 瘋狂的組距及分析 table.Columns.Add("總分班高標"); table.Columns.Add("總分科高標"); table.Columns.Add("總分校高標"); table.Columns.Add("平均班高標"); table.Columns.Add("平均科高標"); table.Columns.Add("平均校高標"); table.Columns.Add("加權總分班高標"); table.Columns.Add("加權總分科高標"); table.Columns.Add("加權總分校高標"); table.Columns.Add("加權平均班高標"); table.Columns.Add("加權平均科高標"); table.Columns.Add("加權平均校高標"); table.Columns.Add("類1總分高標"); table.Columns.Add("類1平均高標"); table.Columns.Add("類1加權總分高標"); table.Columns.Add("類1加權平均高標"); table.Columns.Add("類2總分高標"); table.Columns.Add("類2平均高標"); table.Columns.Add("類2加權總分高標"); table.Columns.Add("類2加權平均高標"); table.Columns.Add("總分班均標"); table.Columns.Add("總分科均標"); table.Columns.Add("總分校均標"); table.Columns.Add("平均班均標"); table.Columns.Add("平均科均標"); table.Columns.Add("平均校均標"); table.Columns.Add("加權總分班均標"); table.Columns.Add("加權總分科均標"); table.Columns.Add("加權總分校均標"); table.Columns.Add("加權平均班均標"); table.Columns.Add("加權平均科均標"); table.Columns.Add("加權平均校均標"); table.Columns.Add("類1總分均標"); table.Columns.Add("類1平均均標"); table.Columns.Add("類1加權總分均標"); table.Columns.Add("類1加權平均均標"); table.Columns.Add("類2總分均標"); table.Columns.Add("類2平均均標"); table.Columns.Add("類2加權總分均標"); table.Columns.Add("類2加權平均均標"); table.Columns.Add("總分班低標"); table.Columns.Add("總分科低標"); table.Columns.Add("總分校低標"); table.Columns.Add("平均班低標"); table.Columns.Add("平均科低標"); table.Columns.Add("平均校低標"); table.Columns.Add("加權總分班低標"); table.Columns.Add("加權總分科低標"); table.Columns.Add("加權總分校低標"); table.Columns.Add("加權平均班低標"); table.Columns.Add("加權平均科低標"); table.Columns.Add("加權平均校低標"); table.Columns.Add("類1總分低標"); table.Columns.Add("類1平均低標"); table.Columns.Add("類1加權總分低標"); table.Columns.Add("類1加權平均低標"); table.Columns.Add("類2總分低標"); table.Columns.Add("類2平均低標"); table.Columns.Add("類2加權總分低標"); table.Columns.Add("類2加權平均低標"); table.Columns.Add("總分班標準差"); table.Columns.Add("總分科標準差"); table.Columns.Add("總分校標準差"); table.Columns.Add("平均班標準差"); table.Columns.Add("平均科標準差"); table.Columns.Add("平均校標準差"); table.Columns.Add("加權總分班標準差"); table.Columns.Add("加權總分科標準差"); table.Columns.Add("加權總分校標準差"); table.Columns.Add("加權平均班標準差"); table.Columns.Add("加權平均科標準差"); table.Columns.Add("加權平均校標準差"); table.Columns.Add("類1總分標準差"); table.Columns.Add("類1平均標準差"); table.Columns.Add("類1加權總分標準差"); table.Columns.Add("類1加權平均標準差"); table.Columns.Add("類2總分標準差"); table.Columns.Add("類2平均標準差"); table.Columns.Add("類2加權總分標準差"); table.Columns.Add("類2加權平均標準差"); table.Columns.Add("總分班組距count90"); table.Columns.Add("總分科組距count90"); table.Columns.Add("總分校組距count90"); table.Columns.Add("平均班組距count90"); table.Columns.Add("平均科組距count90"); table.Columns.Add("平均校組距count90"); table.Columns.Add("加權總分班組距count90"); table.Columns.Add("加權總分科組距count90"); table.Columns.Add("加權總分校組距count90"); table.Columns.Add("加權平均班組距count90"); table.Columns.Add("加權平均科組距count90"); table.Columns.Add("加權平均校組距count90"); table.Columns.Add("類1總分組距count90"); table.Columns.Add("類1平均組距count90"); table.Columns.Add("類1加權總分組距count90"); table.Columns.Add("類1加權平均組距count90"); table.Columns.Add("類2總分組距count90"); table.Columns.Add("類2平均組距count90"); table.Columns.Add("類2加權總分組距count90"); table.Columns.Add("類2加權平均組距count90"); table.Columns.Add("總分班組距count80"); table.Columns.Add("總分科組距count80"); table.Columns.Add("總分校組距count80"); table.Columns.Add("平均班組距count80"); table.Columns.Add("平均科組距count80"); table.Columns.Add("平均校組距count80"); table.Columns.Add("加權總分班組距count80"); table.Columns.Add("加權總分科組距count80"); table.Columns.Add("加權總分校組距count80"); table.Columns.Add("加權平均班組距count80"); table.Columns.Add("加權平均科組距count80"); table.Columns.Add("加權平均校組距count80"); table.Columns.Add("類1總分組距count80"); table.Columns.Add("類1平均組距count80"); table.Columns.Add("類1加權總分組距count80"); table.Columns.Add("類1加權平均組距count80"); table.Columns.Add("類2總分組距count80"); table.Columns.Add("類2平均組距count80"); table.Columns.Add("類2加權總分組距count80"); table.Columns.Add("類2加權平均組距count80"); table.Columns.Add("總分班組距count70"); table.Columns.Add("總分科組距count70"); table.Columns.Add("總分校組距count70"); table.Columns.Add("平均班組距count70"); table.Columns.Add("平均科組距count70"); table.Columns.Add("平均校組距count70"); table.Columns.Add("加權總分班組距count70"); table.Columns.Add("加權總分科組距count70"); table.Columns.Add("加權總分校組距count70"); table.Columns.Add("加權平均班組距count70"); table.Columns.Add("加權平均科組距count70"); table.Columns.Add("加權平均校組距count70"); table.Columns.Add("類1總分組距count70"); table.Columns.Add("類1平均組距count70"); table.Columns.Add("類1加權總分組距count70"); table.Columns.Add("類1加權平均組距count70"); table.Columns.Add("類2總分組距count70"); table.Columns.Add("類2平均組距count70"); table.Columns.Add("類2加權總分組距count70"); table.Columns.Add("類2加權平均組距count70"); table.Columns.Add("總分班組距count60"); table.Columns.Add("總分科組距count60"); table.Columns.Add("總分校組距count60"); table.Columns.Add("平均班組距count60"); table.Columns.Add("平均科組距count60"); table.Columns.Add("平均校組距count60"); table.Columns.Add("加權總分班組距count60"); table.Columns.Add("加權總分科組距count60"); table.Columns.Add("加權總分校組距count60"); table.Columns.Add("加權平均班組距count60"); table.Columns.Add("加權平均科組距count60"); table.Columns.Add("加權平均校組距count60"); table.Columns.Add("類1總分組距count60"); table.Columns.Add("類1平均組距count60"); table.Columns.Add("類1加權總分組距count60"); table.Columns.Add("類1加權平均組距count60"); table.Columns.Add("類2總分組距count60"); table.Columns.Add("類2平均組距count60"); table.Columns.Add("類2加權總分組距count60"); table.Columns.Add("類2加權平均組距count60"); table.Columns.Add("總分班組距count50"); table.Columns.Add("總分科組距count50"); table.Columns.Add("總分校組距count50"); table.Columns.Add("平均班組距count50"); table.Columns.Add("平均科組距count50"); table.Columns.Add("平均校組距count50"); table.Columns.Add("加權總分班組距count50"); table.Columns.Add("加權總分科組距count50"); table.Columns.Add("加權總分校組距count50"); table.Columns.Add("加權平均班組距count50"); table.Columns.Add("加權平均科組距count50"); table.Columns.Add("加權平均校組距count50"); table.Columns.Add("類1總分組距count50"); table.Columns.Add("類1平均組距count50"); table.Columns.Add("類1加權總分組距count50"); table.Columns.Add("類1加權平均組距count50"); table.Columns.Add("類2總分組距count50"); table.Columns.Add("類2平均組距count50"); table.Columns.Add("類2加權總分組距count50"); table.Columns.Add("類2加權平均組距count50"); table.Columns.Add("總分班組距count40"); table.Columns.Add("總分科組距count40"); table.Columns.Add("總分校組距count40"); table.Columns.Add("平均班組距count40"); table.Columns.Add("平均科組距count40"); table.Columns.Add("平均校組距count40"); table.Columns.Add("加權總分班組距count40"); table.Columns.Add("加權總分科組距count40"); table.Columns.Add("加權總分校組距count40"); table.Columns.Add("加權平均班組距count40"); table.Columns.Add("加權平均科組距count40"); table.Columns.Add("加權平均校組距count40"); table.Columns.Add("類1總分組距count40"); table.Columns.Add("類1平均組距count40"); table.Columns.Add("類1加權總分組距count40"); table.Columns.Add("類1加權平均組距count40"); table.Columns.Add("類2總分組距count40"); table.Columns.Add("類2平均組距count40"); table.Columns.Add("類2加權總分組距count40"); table.Columns.Add("類2加權平均組距count40"); table.Columns.Add("總分班組距count30"); table.Columns.Add("總分科組距count30"); table.Columns.Add("總分校組距count30"); table.Columns.Add("平均班組距count30"); table.Columns.Add("平均科組距count30"); table.Columns.Add("平均校組距count30"); table.Columns.Add("加權總分班組距count30"); table.Columns.Add("加權總分科組距count30"); table.Columns.Add("加權總分校組距count30"); table.Columns.Add("加權平均班組距count30"); table.Columns.Add("加權平均科組距count30"); table.Columns.Add("加權平均校組距count30"); table.Columns.Add("類1總分組距count30"); table.Columns.Add("類1平均組距count30"); table.Columns.Add("類1加權總分組距count30"); table.Columns.Add("類1加權平均組距count30"); table.Columns.Add("類2總分組距count30"); table.Columns.Add("類2平均組距count30"); table.Columns.Add("類2加權總分組距count30"); table.Columns.Add("類2加權平均組距count30"); table.Columns.Add("總分班組距count20"); table.Columns.Add("總分科組距count20"); table.Columns.Add("總分校組距count20"); table.Columns.Add("平均班組距count20"); table.Columns.Add("平均科組距count20"); table.Columns.Add("平均校組距count20"); table.Columns.Add("加權總分班組距count20"); table.Columns.Add("加權總分科組距count20"); table.Columns.Add("加權總分校組距count20"); table.Columns.Add("加權平均班組距count20"); table.Columns.Add("加權平均科組距count20"); table.Columns.Add("加權平均校組距count20"); table.Columns.Add("類1總分組距count20"); table.Columns.Add("類1平均組距count20"); table.Columns.Add("類1加權總分組距count20"); table.Columns.Add("類1加權平均組距count20"); table.Columns.Add("類2總分組距count20"); table.Columns.Add("類2平均組距count20"); table.Columns.Add("類2加權總分組距count20"); table.Columns.Add("類2加權平均組距count20"); table.Columns.Add("總分班組距count10"); table.Columns.Add("總分科組距count10"); table.Columns.Add("總分校組距count10"); table.Columns.Add("平均班組距count10"); table.Columns.Add("平均科組距count10"); table.Columns.Add("平均校組距count10"); table.Columns.Add("加權總分班組距count10"); table.Columns.Add("加權總分科組距count10"); table.Columns.Add("加權總分校組距count10"); table.Columns.Add("加權平均班組距count10"); table.Columns.Add("加權平均科組距count10"); table.Columns.Add("加權平均校組距count10"); table.Columns.Add("類1總分組距count10"); table.Columns.Add("類1平均組距count10"); table.Columns.Add("類1加權總分組距count10"); table.Columns.Add("類1加權平均組距count10"); table.Columns.Add("類2總分組距count10"); table.Columns.Add("類2平均組距count10"); table.Columns.Add("類2加權總分組距count10"); table.Columns.Add("類2加權平均組距count10"); table.Columns.Add("總分班組距count100Up"); table.Columns.Add("總分科組距count100Up"); table.Columns.Add("總分校組距count100Up"); table.Columns.Add("平均班組距count100Up"); table.Columns.Add("平均科組距count100Up"); table.Columns.Add("平均校組距count100Up"); table.Columns.Add("加權總分班組距count100Up"); table.Columns.Add("加權總分科組距count100Up"); table.Columns.Add("加權總分校組距count100Up"); table.Columns.Add("加權平均班組距count100Up"); table.Columns.Add("加權平均科組距count100Up"); table.Columns.Add("加權平均校組距count100Up"); table.Columns.Add("類1總分組距count100Up"); table.Columns.Add("類1平均組距count100Up"); table.Columns.Add("類1加權總分組距count100Up"); table.Columns.Add("類1加權平均組距count100Up"); table.Columns.Add("類2總分組距count100Up"); table.Columns.Add("類2平均組距count100Up"); table.Columns.Add("類2加權總分組距count100Up"); table.Columns.Add("類2加權平均組距count100Up"); table.Columns.Add("總分班組距count90Up"); table.Columns.Add("總分科組距count90Up"); table.Columns.Add("總分校組距count90Up"); table.Columns.Add("平均班組距count90Up"); table.Columns.Add("平均科組距count90Up"); table.Columns.Add("平均校組距count90Up"); table.Columns.Add("加權總分班組距count90Up"); table.Columns.Add("加權總分科組距count90Up"); table.Columns.Add("加權總分校組距count90Up"); table.Columns.Add("加權平均班組距count90Up"); table.Columns.Add("加權平均科組距count90Up"); table.Columns.Add("加權平均校組距count90Up"); table.Columns.Add("類1總分組距count90Up"); table.Columns.Add("類1平均組距count90Up"); table.Columns.Add("類1加權總分組距count90Up"); table.Columns.Add("類1加權平均組距count90Up"); table.Columns.Add("類2總分組距count90Up"); table.Columns.Add("類2平均組距count90Up"); table.Columns.Add("類2加權總分組距count90Up"); table.Columns.Add("類2加權平均組距count90Up"); table.Columns.Add("總分班組距count80Up"); table.Columns.Add("總分科組距count80Up"); table.Columns.Add("總分校組距count80Up"); table.Columns.Add("平均班組距count80Up"); table.Columns.Add("平均科組距count80Up"); table.Columns.Add("平均校組距count80Up"); table.Columns.Add("加權總分班組距count80Up"); table.Columns.Add("加權總分科組距count80Up"); table.Columns.Add("加權總分校組距count80Up"); table.Columns.Add("加權平均班組距count80Up"); table.Columns.Add("加權平均科組距count80Up"); table.Columns.Add("加權平均校組距count80Up"); table.Columns.Add("類1總分組距count80Up"); table.Columns.Add("類1平均組距count80Up"); table.Columns.Add("類1加權總分組距count80Up"); table.Columns.Add("類1加權平均組距count80Up"); table.Columns.Add("類2總分組距count80Up"); table.Columns.Add("類2平均組距count80Up"); table.Columns.Add("類2加權總分組距count80Up"); table.Columns.Add("類2加權平均組距count80Up"); table.Columns.Add("總分班組距count70Up"); table.Columns.Add("總分科組距count70Up"); table.Columns.Add("總分校組距count70Up"); table.Columns.Add("平均班組距count70Up"); table.Columns.Add("平均科組距count70Up"); table.Columns.Add("平均校組距count70Up"); table.Columns.Add("加權總分班組距count70Up"); table.Columns.Add("加權總分科組距count70Up"); table.Columns.Add("加權總分校組距count70Up"); table.Columns.Add("加權平均班組距count70Up"); table.Columns.Add("加權平均科組距count70Up"); table.Columns.Add("加權平均校組距count70Up"); table.Columns.Add("類1總分組距count70Up"); table.Columns.Add("類1平均組距count70Up"); table.Columns.Add("類1加權總分組距count70Up"); table.Columns.Add("類1加權平均組距count70Up"); table.Columns.Add("類2總分組距count70Up"); table.Columns.Add("類2平均組距count70Up"); table.Columns.Add("類2加權總分組距count70Up"); table.Columns.Add("類2加權平均組距count70Up"); table.Columns.Add("總分班組距count60Up"); table.Columns.Add("總分科組距count60Up"); table.Columns.Add("總分校組距count60Up"); table.Columns.Add("平均班組距count60Up"); table.Columns.Add("平均科組距count60Up"); table.Columns.Add("平均校組距count60Up"); table.Columns.Add("加權總分班組距count60Up"); table.Columns.Add("加權總分科組距count60Up"); table.Columns.Add("加權總分校組距count60Up"); table.Columns.Add("加權平均班組距count60Up"); table.Columns.Add("加權平均科組距count60Up"); table.Columns.Add("加權平均校組距count60Up"); table.Columns.Add("類1總分組距count60Up"); table.Columns.Add("類1平均組距count60Up"); table.Columns.Add("類1加權總分組距count60Up"); table.Columns.Add("類1加權平均組距count60Up"); table.Columns.Add("類2總分組距count60Up"); table.Columns.Add("類2平均組距count60Up"); table.Columns.Add("類2加權總分組距count60Up"); table.Columns.Add("類2加權平均組距count60Up"); table.Columns.Add("總分班組距count50Up"); table.Columns.Add("總分科組距count50Up"); table.Columns.Add("總分校組距count50Up"); table.Columns.Add("平均班組距count50Up"); table.Columns.Add("平均科組距count50Up"); table.Columns.Add("平均校組距count50Up"); table.Columns.Add("加權總分班組距count50Up"); table.Columns.Add("加權總分科組距count50Up"); table.Columns.Add("加權總分校組距count50Up"); table.Columns.Add("加權平均班組距count50Up"); table.Columns.Add("加權平均科組距count50Up"); table.Columns.Add("加權平均校組距count50Up"); table.Columns.Add("類1總分組距count50Up"); table.Columns.Add("類1平均組距count50Up"); table.Columns.Add("類1加權總分組距count50Up"); table.Columns.Add("類1加權平均組距count50Up"); table.Columns.Add("類2總分組距count50Up"); table.Columns.Add("類2平均組距count50Up"); table.Columns.Add("類2加權總分組距count50Up"); table.Columns.Add("類2加權平均組距count50Up"); table.Columns.Add("總分班組距count40Up"); table.Columns.Add("總分科組距count40Up"); table.Columns.Add("總分校組距count40Up"); table.Columns.Add("平均班組距count40Up"); table.Columns.Add("平均科組距count40Up"); table.Columns.Add("平均校組距count40Up"); table.Columns.Add("加權總分班組距count40Up"); table.Columns.Add("加權總分科組距count40Up"); table.Columns.Add("加權總分校組距count40Up"); table.Columns.Add("加權平均班組距count40Up"); table.Columns.Add("加權平均科組距count40Up"); table.Columns.Add("加權平均校組距count40Up"); table.Columns.Add("類1總分組距count40Up"); table.Columns.Add("類1平均組距count40Up"); table.Columns.Add("類1加權總分組距count40Up"); table.Columns.Add("類1加權平均組距count40Up"); table.Columns.Add("類2總分組距count40Up"); table.Columns.Add("類2平均組距count40Up"); table.Columns.Add("類2加權總分組距count40Up"); table.Columns.Add("類2加權平均組距count40Up"); table.Columns.Add("總分班組距count30Up"); table.Columns.Add("總分科組距count30Up"); table.Columns.Add("總分校組距count30Up"); table.Columns.Add("平均班組距count30Up"); table.Columns.Add("平均科組距count30Up"); table.Columns.Add("平均校組距count30Up"); table.Columns.Add("加權總分班組距count30Up"); table.Columns.Add("加權總分科組距count30Up"); table.Columns.Add("加權總分校組距count30Up"); table.Columns.Add("加權平均班組距count30Up"); table.Columns.Add("加權平均科組距count30Up"); table.Columns.Add("加權平均校組距count30Up"); table.Columns.Add("類1總分組距count30Up"); table.Columns.Add("類1平均組距count30Up"); table.Columns.Add("類1加權總分組距count30Up"); table.Columns.Add("類1加權平均組距count30Up"); table.Columns.Add("類2總分組距count30Up"); table.Columns.Add("類2平均組距count30Up"); table.Columns.Add("類2加權總分組距count30Up"); table.Columns.Add("類2加權平均組距count30Up"); table.Columns.Add("總分班組距count20Up"); table.Columns.Add("總分科組距count20Up"); table.Columns.Add("總分校組距count20Up"); table.Columns.Add("平均班組距count20Up"); table.Columns.Add("平均科組距count20Up"); table.Columns.Add("平均校組距count20Up"); table.Columns.Add("加權總分班組距count20Up"); table.Columns.Add("加權總分科組距count20Up"); table.Columns.Add("加權總分校組距count20Up"); table.Columns.Add("加權平均班組距count20Up"); table.Columns.Add("加權平均科組距count20Up"); table.Columns.Add("加權平均校組距count20Up"); table.Columns.Add("類1總分組距count20Up"); table.Columns.Add("類1平均組距count20Up"); table.Columns.Add("類1加權總分組距count20Up"); table.Columns.Add("類1加權平均組距count20Up"); table.Columns.Add("類2總分組距count20Up"); table.Columns.Add("類2平均組距count20Up"); table.Columns.Add("類2加權總分組距count20Up"); table.Columns.Add("類2加權平均組距count20Up"); table.Columns.Add("總分班組距count10Up"); table.Columns.Add("總分科組距count10Up"); table.Columns.Add("總分校組距count10Up"); table.Columns.Add("平均班組距count10Up"); table.Columns.Add("平均科組距count10Up"); table.Columns.Add("平均校組距count10Up"); table.Columns.Add("加權總分班組距count10Up"); table.Columns.Add("加權總分科組距count10Up"); table.Columns.Add("加權總分校組距count10Up"); table.Columns.Add("加權平均班組距count10Up"); table.Columns.Add("加權平均科組距count10Up"); table.Columns.Add("加權平均校組距count10Up"); table.Columns.Add("類1總分組距count10Up"); table.Columns.Add("類1平均組距count10Up"); table.Columns.Add("類1加權總分組距count10Up"); table.Columns.Add("類1加權平均組距count10Up"); table.Columns.Add("類2總分組距count10Up"); table.Columns.Add("類2平均組距count10Up"); table.Columns.Add("類2加權總分組距count10Up"); table.Columns.Add("類2加權平均組距count10Up"); table.Columns.Add("總分班組距count90Down"); table.Columns.Add("總分科組距count90Down"); table.Columns.Add("總分校組距count90Down"); table.Columns.Add("平均班組距count90Down"); table.Columns.Add("平均科組距count90Down"); table.Columns.Add("平均校組距count90Down"); table.Columns.Add("加權總分班組距count90Down"); table.Columns.Add("加權總分科組距count90Down"); table.Columns.Add("加權總分校組距count90Down"); table.Columns.Add("加權平均班組距count90Down"); table.Columns.Add("加權平均科組距count90Down"); table.Columns.Add("加權平均校組距count90Down"); table.Columns.Add("類1總分組距count90Down"); table.Columns.Add("類1平均組距count90Down"); table.Columns.Add("類1加權總分組距count90Down"); table.Columns.Add("類1加權平均組距count90Down"); table.Columns.Add("類2總分組距count90Down"); table.Columns.Add("類2平均組距count90Down"); table.Columns.Add("類2加權總分組距count90Down"); table.Columns.Add("類2加權平均組距count90Down"); table.Columns.Add("總分班組距count80Down"); table.Columns.Add("總分科組距count80Down"); table.Columns.Add("總分校組距count80Down"); table.Columns.Add("平均班組距count80Down"); table.Columns.Add("平均科組距count80Down"); table.Columns.Add("平均校組距count80Down"); table.Columns.Add("加權總分班組距count80Down"); table.Columns.Add("加權總分科組距count80Down"); table.Columns.Add("加權總分校組距count80Down"); table.Columns.Add("加權平均班組距count80Down"); table.Columns.Add("加權平均科組距count80Down"); table.Columns.Add("加權平均校組距count80Down"); table.Columns.Add("類1總分組距count80Down"); table.Columns.Add("類1平均組距count80Down"); table.Columns.Add("類1加權總分組距count80Down"); table.Columns.Add("類1加權平均組距count80Down"); table.Columns.Add("類2總分組距count80Down"); table.Columns.Add("類2平均組距count80Down"); table.Columns.Add("類2加權總分組距count80Down"); table.Columns.Add("類2加權平均組距count80Down"); table.Columns.Add("總分班組距count70Down"); table.Columns.Add("總分科組距count70Down"); table.Columns.Add("總分校組距count70Down"); table.Columns.Add("平均班組距count70Down"); table.Columns.Add("平均科組距count70Down"); table.Columns.Add("平均校組距count70Down"); table.Columns.Add("加權總分班組距count70Down"); table.Columns.Add("加權總分科組距count70Down"); table.Columns.Add("加權總分校組距count70Down"); table.Columns.Add("加權平均班組距count70Down"); table.Columns.Add("加權平均科組距count70Down"); table.Columns.Add("加權平均校組距count70Down"); table.Columns.Add("類1總分組距count70Down"); table.Columns.Add("類1平均組距count70Down"); table.Columns.Add("類1加權總分組距count70Down"); table.Columns.Add("類1加權平均組距count70Down"); table.Columns.Add("類2總分組距count70Down"); table.Columns.Add("類2平均組距count70Down"); table.Columns.Add("類2加權總分組距count70Down"); table.Columns.Add("類2加權平均組距count70Down"); table.Columns.Add("總分班組距count60Down"); table.Columns.Add("總分科組距count60Down"); table.Columns.Add("總分校組距count60Down"); table.Columns.Add("平均班組距count60Down"); table.Columns.Add("平均科組距count60Down"); table.Columns.Add("平均校組距count60Down"); table.Columns.Add("加權總分班組距count60Down"); table.Columns.Add("加權總分科組距count60Down"); table.Columns.Add("加權總分校組距count60Down"); table.Columns.Add("加權平均班組距count60Down"); table.Columns.Add("加權平均科組距count60Down"); table.Columns.Add("加權平均校組距count60Down"); table.Columns.Add("類1總分組距count60Down"); table.Columns.Add("類1平均組距count60Down"); table.Columns.Add("類1加權總分組距count60Down"); table.Columns.Add("類1加權平均組距count60Down"); table.Columns.Add("類2總分組距count60Down"); table.Columns.Add("類2平均組距count60Down"); table.Columns.Add("類2加權總分組距count60Down"); table.Columns.Add("類2加權平均組距count60Down"); table.Columns.Add("總分班組距count50Down"); table.Columns.Add("總分科組距count50Down"); table.Columns.Add("總分校組距count50Down"); table.Columns.Add("平均班組距count50Down"); table.Columns.Add("平均科組距count50Down"); table.Columns.Add("平均校組距count50Down"); table.Columns.Add("加權總分班組距count50Down"); table.Columns.Add("加權總分科組距count50Down"); table.Columns.Add("加權總分校組距count50Down"); table.Columns.Add("加權平均班組距count50Down"); table.Columns.Add("加權平均科組距count50Down"); table.Columns.Add("加權平均校組距count50Down"); table.Columns.Add("類1總分組距count50Down"); table.Columns.Add("類1平均組距count50Down"); table.Columns.Add("類1加權總分組距count50Down"); table.Columns.Add("類1加權平均組距count50Down"); table.Columns.Add("類2總分組距count50Down"); table.Columns.Add("類2平均組距count50Down"); table.Columns.Add("類2加權總分組距count50Down"); table.Columns.Add("類2加權平均組距count50Down"); table.Columns.Add("總分班組距count40Down"); table.Columns.Add("總分科組距count40Down"); table.Columns.Add("總分校組距count40Down"); table.Columns.Add("平均班組距count40Down"); table.Columns.Add("平均科組距count40Down"); table.Columns.Add("平均校組距count40Down"); table.Columns.Add("加權總分班組距count40Down"); table.Columns.Add("加權總分科組距count40Down"); table.Columns.Add("加權總分校組距count40Down"); table.Columns.Add("加權平均班組距count40Down"); table.Columns.Add("加權平均科組距count40Down"); table.Columns.Add("加權平均校組距count40Down"); table.Columns.Add("類1總分組距count40Down"); table.Columns.Add("類1平均組距count40Down"); table.Columns.Add("類1加權總分組距count40Down"); table.Columns.Add("類1加權平均組距count40Down"); table.Columns.Add("類2總分組距count40Down"); table.Columns.Add("類2平均組距count40Down"); table.Columns.Add("類2加權總分組距count40Down"); table.Columns.Add("類2加權平均組距count40Down"); table.Columns.Add("總分班組距count30Down"); table.Columns.Add("總分科組距count30Down"); table.Columns.Add("總分校組距count30Down"); table.Columns.Add("平均班組距count30Down"); table.Columns.Add("平均科組距count30Down"); table.Columns.Add("平均校組距count30Down"); table.Columns.Add("加權總分班組距count30Down"); table.Columns.Add("加權總分科組距count30Down"); table.Columns.Add("加權總分校組距count30Down"); table.Columns.Add("加權平均班組距count30Down"); table.Columns.Add("加權平均科組距count30Down"); table.Columns.Add("加權平均校組距count30Down"); table.Columns.Add("類1總分組距count30Down"); table.Columns.Add("類1平均組距count30Down"); table.Columns.Add("類1加權總分組距count30Down"); table.Columns.Add("類1加權平均組距count30Down"); table.Columns.Add("類2總分組距count30Down"); table.Columns.Add("類2平均組距count30Down"); table.Columns.Add("類2加權總分組距count30Down"); table.Columns.Add("類2加權平均組距count30Down"); table.Columns.Add("總分班組距count20Down"); table.Columns.Add("總分科組距count20Down"); table.Columns.Add("總分校組距count20Down"); table.Columns.Add("平均班組距count20Down"); table.Columns.Add("平均科組距count20Down"); table.Columns.Add("平均校組距count20Down"); table.Columns.Add("加權總分班組距count20Down"); table.Columns.Add("加權總分科組距count20Down"); table.Columns.Add("加權總分校組距count20Down"); table.Columns.Add("加權平均班組距count20Down"); table.Columns.Add("加權平均科組距count20Down"); table.Columns.Add("加權平均校組距count20Down"); table.Columns.Add("類1總分組距count20Down"); table.Columns.Add("類1平均組距count20Down"); table.Columns.Add("類1加權總分組距count20Down"); table.Columns.Add("類1加權平均組距count20Down"); table.Columns.Add("類2總分組距count20Down"); table.Columns.Add("類2平均組距count20Down"); table.Columns.Add("類2加權總分組距count20Down"); table.Columns.Add("類2加權平均組距count20Down"); table.Columns.Add("總分班組距count10Down"); table.Columns.Add("總分科組距count10Down"); table.Columns.Add("總分校組距count10Down"); table.Columns.Add("平均班組距count10Down"); table.Columns.Add("平均科組距count10Down"); table.Columns.Add("平均校組距count10Down"); table.Columns.Add("加權總分班組距count10Down"); table.Columns.Add("加權總分科組距count10Down"); table.Columns.Add("加權總分校組距count10Down"); table.Columns.Add("加權平均班組距count10Down"); table.Columns.Add("加權平均科組距count10Down"); table.Columns.Add("加權平均校組距count10Down"); table.Columns.Add("類1總分組距count10Down"); table.Columns.Add("類1平均組距count10Down"); table.Columns.Add("類1加權總分組距count10Down"); table.Columns.Add("類1加權平均組距count10Down"); table.Columns.Add("類2總分組距count10Down"); table.Columns.Add("類2平均組距count10Down"); table.Columns.Add("類2加權總分組距count10Down"); table.Columns.Add("類2加權平均組距count10Down"); #endregion #endregion //宣告產生的報表 Aspose.Words.Document document = new Aspose.Words.Document(); //用一個BackgroundWorker包起來 System.ComponentModel.BackgroundWorker bkw = new System.ComponentModel.BackgroundWorker(); bkw.WorkerReportsProgress = true; System.Diagnostics.Trace.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " 個人評量成績單產生 S"); bkw.ProgressChanged += delegate(object sender, System.ComponentModel.ProgressChangedEventArgs e) { FISCA.Presentation.MotherForm.SetStatusBarMessage("個人評量成績單產生中", e.ProgressPercentage); System.Diagnostics.Trace.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " 個人評量成績單產生 " + e.ProgressPercentage); }; Exception exc = null; bkw.RunWorkerCompleted += delegate { System.Diagnostics.Trace.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " 個人評量成績單產生 E"); string err = "下列學生因成績項目超過樣板支援上限,\n超出部分科目成績無法印出,建議調整樣板內容。"; if (overflowRecords.Count > 0) { foreach (var stuRec in overflowRecords) { err += "\n" + (stuRec.RefClass == null ? "" : (stuRec.RefClass.ClassName + "班" + stuRec.SeatNo + "號")) + "[" + stuRec.StudentNumber + "]" + stuRec.StudentName; } } #region 儲存檔案 string inputReportName = "個人評量成績單"; string reportName = inputReportName; string path = Path.Combine(System.Windows.Forms.Application.StartupPath, "Reports"); if (!Directory.Exists(path)) Directory.CreateDirectory(path); path = Path.Combine(path, reportName + ".doc"); if (File.Exists(path)) { int i = 1; while (true) { string newPath = Path.GetDirectoryName(path) + "\\" + Path.GetFileNameWithoutExtension(path) + (i++) + Path.GetExtension(path); if (!File.Exists(newPath)) { path = newPath; break; } } } try { document.Save(path, Aspose.Words.SaveFormat.Doc); System.Diagnostics.Process.Start(path); } catch { System.Windows.Forms.SaveFileDialog sd = new System.Windows.Forms.SaveFileDialog(); sd.Title = "另存新檔"; sd.FileName = reportName + ".doc"; sd.Filter = "Excel檔案 (*.doc)|*.doc|所有檔案 (*.*)|*.*"; if (sd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { document.Save(sd.FileName, Aspose.Words.SaveFormat.Doc); } catch { FISCA.Presentation.Controls.MsgBox.Show("指定路徑無法存取。", "建立檔案失敗", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); return; } } } #endregion FISCA.Presentation.MotherForm.SetStatusBarMessage("個人評量成績單產生完成。", 100); if (overflowRecords.Count > 0) MessageBox.Show(err); // //BMK ---- deleteSelectedRecords if (deleteSelectedRecords.Count > 0) { String deleteStr = ""; foreach (var varDel in deleteSelectedRecords) { deleteStr += varDel.StudentName + ","; } MessageBox.Show("未排名學生: " + deleteStr); } if (exc != null) { // BMK Exception //throw new Exception("產生期末成績單發生錯誤", exc); } }; bkw.DoWork += delegate(object sender, System.ComponentModel.DoWorkEventArgs e) { var studentRecords = accessHelper.StudentHelper.GetStudents(selectedStudents); Dictionary<string, Dictionary<string, Dictionary<string, ExamScoreInfo>>> studentExamSores = new Dictionary<string, Dictionary<string, Dictionary<string, ExamScoreInfo>>>(); Dictionary<string, Dictionary<string, Dictionary<string, ExamScoreInfo>>> studentRefExamSores = new Dictionary<string, Dictionary<string, Dictionary<string, ExamScoreInfo>>>(); //Dictionary<string, Dictionary<string, ExamScoreInfo>> studentRefExamSores = new Dictionary<string, Dictionary<string, ExamScoreInfo>>(); ManualResetEvent scoreReady = new ManualResetEvent(false); ManualResetEvent elseReady = new ManualResetEvent(false); #region 偷跑取得考試成績 new Thread(new ThreadStart(delegate { // 取得學生學期科目成績 int sSchoolYear, sSemester; int.TryParse(conf.SchoolYear, out sSchoolYear); int.TryParse(conf.Semester, out sSemester); #region 整理學生定期評量成績 #region 篩選課程學年度、學期、科目取得有可能有需要的資料 List<CourseRecord> targetCourseList = new List<CourseRecord>(); try { foreach (var courseRecord in accessHelper.CourseHelper.GetAllCourse(sSchoolYear, sSemester)) { //用科目濾出可能有用到的課程 if (conf.PrintSubjectList.Contains(courseRecord.Subject) || conf.TagRank1SubjectList.Contains(courseRecord.Subject) || conf.TagRank2SubjectList.Contains(courseRecord.Subject)) targetCourseList.Add(courseRecord); } } catch (Exception exception) { exc = exception; } #endregion try { if (conf.ExamRecord != null || conf.RefenceExamRecord != null) { accessHelper.CourseHelper.FillExam(targetCourseList); var tcList = new List<CourseRecord>(); var totalList = new List<CourseRecord>(); foreach (var courseRec in targetCourseList) { // 過濾包含 本次第n次段考 if (conf.ExamRecord != null && courseRec.ExamList.Contains(conf.ExamRecord.Name)) { tcList.Add(courseRec); totalList.Add(courseRec); } if (tcList.Count == 180) { accessHelper.CourseHelper.FillStudentAttend(tcList); accessHelper.CourseHelper.FillExamScore(tcList); tcList.Clear(); } } accessHelper.CourseHelper.FillStudentAttend(tcList); accessHelper.CourseHelper.FillExamScore(tcList); foreach (var courseRecord in totalList) { // BMK 本次成績 #region 整理本次定期評量成績 if (conf.ExamRecord != null && courseRecord.ExamList.Contains(conf.ExamRecord.Name)) { //修課學生資料 foreach (var attendStudent in courseRecord.StudentAttendList) { if (!studentExamSores.ContainsKey(attendStudent.StudentID)) studentExamSores.Add(attendStudent.StudentID, new Dictionary<string, Dictionary<string, ExamScoreInfo>>()); if (!studentExamSores[attendStudent.StudentID].ContainsKey(courseRecord.Subject)) studentExamSores[attendStudent.StudentID].Add(courseRecord.Subject, new Dictionary<string, ExamScoreInfo>()); studentExamSores[attendStudent.StudentID][courseRecord.Subject].Add("" + attendStudent.CourseID, null); } //修課學生成績 foreach (var examScoreRec in courseRecord.ExamScoreList) { // 過濾包含 本次第n次段考 if (examScoreRec.ExamName == conf.ExamRecord.Name) { studentExamSores[examScoreRec.StudentID][courseRecord.Subject]["" + examScoreRec.CourseID] = examScoreRec; } } } // bmk ---- Remove 只要考試其一科沒有成績 就不參與排名 也就沒有成績單 foreach ( var studentId in studentExamSores.Keys ) { foreach (var varSubject in studentExamSores[studentId].Keys) { foreach (var varCourseID in studentExamSores[studentId][varSubject].Keys) { if (studentExamSores[studentId][varSubject][varCourseID] == null) { StudentRecord stuRecord = accessHelper.StudentHelper.GetStudent(studentId); // 只要考試其一科沒有成績 就不參與排名 也就沒有成績單 if (!deleteRecords.Contains(stuRecord)) { deleteRecords.Add(stuRecord); //studentExamSores[studentId][varSubject].Remove(varCourseID); //studentExamSores[studentId].Remove(varSubject); //studentExamSores.Remove(studentId); } // 選擇的學生 不參與排名 if (studentRecords.Contains(stuRecord)) { if (!deleteSelectedRecords.Contains(stuRecord)) { deleteSelectedRecords.Add(stuRecord); } } } } } } #endregion // BMK 前次成績 #region 整理前次定期評量成績 // BMK------ 前次定期評量成績 if (conf.RefenceExamRecord != null && courseRecord.ExamList.Contains(conf.RefenceExamRecord.Name)) { //修課學生資料 foreach (var attendStudent in courseRecord.StudentAttendList) { if (!studentRefExamSores.ContainsKey(attendStudent.StudentID)) studentRefExamSores.Add(attendStudent.StudentID, new Dictionary<string, Dictionary<string, ExamScoreInfo>>()); if (!studentRefExamSores[attendStudent.StudentID].ContainsKey(courseRecord.Subject)) studentRefExamSores[attendStudent.StudentID].Add(courseRecord.Subject, new Dictionary<string, ExamScoreInfo>()); studentRefExamSores[attendStudent.StudentID][courseRecord.Subject].Add("" + attendStudent.CourseID, null); } //修課學生成績 foreach (var examScoreRec in courseRecord.ExamScoreList) { // 過濾包含 前次第n次段考 if (examScoreRec.ExamName == conf.RefenceExamRecord.Name) { studentRefExamSores[examScoreRec.StudentID][courseRecord.Subject]["" + examScoreRec.CourseID] = examScoreRec; } } } foreach (var studentId in studentRefExamSores.Keys) { foreach (var varSubject in studentRefExamSores[studentId].Keys) { foreach (var varCourseID in studentRefExamSores[studentId][varSubject].Keys) { if (studentRefExamSores[studentId][varSubject][varCourseID] == null) { if (!deletePreRecords.Contains(accessHelper.StudentHelper.GetStudent(studentId))) { deletePreRecords.Add(accessHelper.StudentHelper.GetStudent(studentId)); } } } } } // ---- old /* if (conf.RefenceExamRecord != null && courseRecord.ExamList.Contains(conf.RefenceExamRecord.Name)) { foreach (var examScoreRec in courseRecord.ExamScoreList) { if (examScoreRec.ExamName == conf.RefenceExamRecord.Name) { if (!studentRefExamSores.ContainsKey(examScoreRec.StudentID)) studentRefExamSores.Add(examScoreRec.StudentID, new Dictionary<string, ExamScoreInfo>()); studentRefExamSores[examScoreRec.StudentID].Add("" + examScoreRec.CourseID, examScoreRec); } } } */ #endregion } } } catch (Exception exception) { exc = exception; } finally { scoreReady.Set(); } #endregion #region 整理學生學期、學年成績 try { accessHelper.StudentHelper.FillAttendance(studentRecords); accessHelper.StudentHelper.FillReward(studentRecords); } catch (Exception exception) { exc = exception; } finally { elseReady.Set(); } #endregion })).Start(); #endregion try { string key = ""; bkw.ReportProgress(0); #region 缺曠對照表 List<K12.Data.PeriodMappingInfo> periodMappingInfos = K12.Data.PeriodMapping.SelectAll(); Dictionary<string, string> dicPeriodMappingType = new Dictionary<string, string>(); List<string> periodTypes = new List<string>(); foreach (K12.Data.PeriodMappingInfo periodMappingInfo in periodMappingInfos) { if (!dicPeriodMappingType.ContainsKey(periodMappingInfo.Name)) dicPeriodMappingType.Add(periodMappingInfo.Name, periodMappingInfo.Type); if (!periodTypes.Contains(periodMappingInfo.Type)) periodTypes.Add(periodMappingInfo.Type); } foreach (var absence in K12.Data.AbsenceMapping.SelectAll()) { foreach (var pt in periodTypes) { string attendanceKey = pt + "_" + absence.Name; if (!table.Columns.Contains(attendanceKey)) { table.Columns.Add(attendanceKey); } } } #endregion bkw.ReportProgress(3); #region 整理學生住址 accessHelper.StudentHelper.FillContactInfo(studentRecords); #endregion #region 整理學生父母及監護人 accessHelper.StudentHelper.FillParentInfo(studentRecords); #endregion bkw.ReportProgress(10); #region 整理同年級學生 //整理選取學生的年級 Dictionary<string, List<StudentRecord>> gradeyearStudents = new Dictionary<string, List<StudentRecord>>(); foreach (var studentRec in studentRecords) { string grade = ""; if (studentRec.RefClass != null) grade = "" + studentRec.RefClass.GradeYear; if (!gradeyearStudents.ContainsKey(grade)) gradeyearStudents.Add(grade, new List<StudentRecord>()); gradeyearStudents[grade].Add(studentRec); } foreach (var classRec in accessHelper.ClassHelper.GetAllClass()) { if (gradeyearStudents.ContainsKey("" + classRec.GradeYear)) { //用班級去取出可能有相關的學生 foreach (var studentRec in classRec.Students) { string grade = ""; if (studentRec.RefClass != null) grade = "" + studentRec.RefClass.GradeYear; if (!gradeyearStudents[grade].Contains(studentRec)) gradeyearStudents[grade].Add(studentRec); } } } #endregion bkw.ReportProgress(15); #region 取得學生類別 Dictionary<string, List<K12.Data.StudentTagRecord>> studentTags = new Dictionary<string, List<K12.Data.StudentTagRecord>>(); List<string> list = new List<string>(); foreach (var sRecs in gradeyearStudents.Values) { foreach (var stuRec in sRecs) { list.Add(stuRec.StudentID); } } foreach (var tag in K12.Data.StudentTag.SelectByStudentIDs(list)) { if (!studentTags.ContainsKey(tag.RefStudentID)) studentTags.Add(tag.RefStudentID, new List<K12.Data.StudentTagRecord>()); studentTags[tag.RefStudentID].Add(tag); } #endregion bkw.ReportProgress(20); //等到成績載完 scoreReady.WaitOne(); bkw.ReportProgress(35); int progressCount = 0; #region 計算總分及各項目排名 Dictionary<string, string> studentTag1Group = new Dictionary<string, string>(); Dictionary<string, string> studentTag2Group = new Dictionary<string, string>(); // 本次 前次 排名 Dictionary<string, List<decimal>> ranks = new Dictionary<string, List<decimal>>(); Dictionary<string, List<string>> rankStudents = new Dictionary<string, List<string>>(); Dictionary<string, decimal> studentPrintSubjectSum = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentTag1SubjectSum = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentTag2SubjectSum = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentPrintSubjectAvg = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentTag1SubjectAvg = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentTag2SubjectAvg = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentPrintSubjectSumW = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentTag1SubjectSumW = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentTag2SubjectSumW = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentPrintSubjectAvgW = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentTag1SubjectAvgW = new Dictionary<string, decimal>(); Dictionary<string, decimal> studentTag2SubjectAvgW = new Dictionary<string, decimal>(); Dictionary<string, decimal> analytics = new Dictionary<string, decimal>(); int total = 0; //aaron //int tag1SubjectCreditSum = 0; Dictionary<string, decimal> tag1SubjectCreditSumList = new Dictionary<string, decimal>(); //printSubjectCreditSum = 0; Dictionary<string, decimal> subjectCreditSumList = new Dictionary<string, decimal>(); // aaron 普通科 有分 自然組 或 社會組 string classNatureSocietyStr = ""; foreach (var gss in gradeyearStudents.Values) { total += gss.Count; } bkw.ReportProgress(40); foreach (string gradeyear in gradeyearStudents.Keys) { // //找出全年級學生 // foreach (var studentRec in gradeyearStudents[gradeyear]) { string studentID = studentRec.StudentID; bool rank = true; bool rankPre = true; string tag1ID = ""; string tag2ID = ""; #region 分析學生所屬類別 if (studentTags.ContainsKey(studentID)) { foreach (var tag in studentTags[studentID]) { #region 判斷學生是否屬於不排名類別 if (conf.RankFilterTagList.Contains(tag.RefTagID)) { rank = false; rankPre = false; } #endregion #region 判斷學生在類別排名1中所屬的類別 if (tag1ID == "" && conf.TagRank1TagList.Contains(tag.RefTagID)) { tag1ID = tag.RefTagID; studentTag1Group.Add(studentID, tag1ID); } #endregion #region 判斷學生在類別排名2中所屬的類別 if (tag2ID == "" && conf.TagRank2TagList.Contains(tag.RefTagID)) { tag2ID = tag.RefTagID; studentTag2Group.Add(studentID, tag2ID); } #endregion } } // aaron if (deleteRecords.Contains(studentRec)) { rank = false; } if (deletePreRecords.Contains(studentRec)) { rankPre = false; } #endregion bool summaryRank = true; bool tag1SummaryRank = true; bool tag2SummaryRank = true; if (studentExamSores.ContainsKey(studentID)) { decimal printSubjectSum = 0; int printSubjectCount = 0; decimal tag1SubjectSum = 0; int tag1SubjectCount = 0; decimal tag2SubjectSum = 0; int tag2SubjectCount = 0; decimal printSubjectSumW = 0; int printSubjectCreditSum = 0; decimal tag1SubjectSumW = 0; int tag1SubjectCreditSum = 0; decimal tag2SubjectSumW = 0; int tag2SubjectCreditSum = 0; // // 單一學生考試成績 // foreach (var subjectName in studentExamSores[studentID].Keys) { if (conf.PrintSubjectList.Contains(subjectName)) { #region 是列印科目 foreach (var sceTakeRecord in studentExamSores[studentID][subjectName].Values) { if (sceTakeRecord != null && sceTakeRecord.SpecialCase == "") { printSubjectSum += sceTakeRecord.ExamScore;//計算總分 printSubjectCount++; //計算加權總分 printSubjectSumW += sceTakeRecord.ExamScore * decimal.ToInt16((decimal)sceTakeRecord.Credit); // BMK 一般 學分加總 printSubjectCreditSum += decimal.ToInt16((decimal)sceTakeRecord.Credit); if (rank && sceTakeRecord.Status == "一般")//不在過濾名單且為一般生才做排名 { if (sceTakeRecord.RefClass != null) { //各科目班排名 key = "班排名" + sceTakeRecord.RefClass.ClassID + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(sceTakeRecord.ExamScore); rankStudents[key].Add(studentID); } if (sceTakeRecord.Department != "") { // 普通科 有分 自然組 或 社會組 classNatureSocietyStr = ""; if (studentRec.RefClass.ClassName.IndexOf("普") > -1) { classNatureSocietyStr = decideNatureSociety(studentRec.RefClass.ClassName); } //BMK 各科目科排名 key = "科排名" + sceTakeRecord.Department + classNatureSocietyStr + "^^^" + gradeyear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(sceTakeRecord.ExamScore); rankStudents[key].Add(studentID); } //各科目全校排名 key = "全校排名" + gradeyear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(sceTakeRecord.ExamScore); rankStudents[key].Add(studentID); } } else { summaryRank = false; } } #endregion // BMK --- 前次考試各科排名 // aaron 前次考試各科排名 #region 前次考試各科排名 foreach (var sceTakeRecord in studentRefExamSores[studentID][subjectName].Values) { if (sceTakeRecord != null && sceTakeRecord.SpecialCase == "") { if (rankPre && sceTakeRecord.Status == "一般")//不在過濾名單且為一般生才做排名 { if (sceTakeRecord.RefClass != null) { //前次考試 各科目 班排名 key = "前次班排名" + sceTakeRecord.RefClass.ClassID + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(sceTakeRecord.ExamScore); rankStudents[key].Add(studentID); } if (sceTakeRecord.Department != "") { // 普通科 有分 自然組 或 社會組 classNatureSocietyStr = ""; if (studentRec.RefClass.ClassName.IndexOf("普") > -1) { classNatureSocietyStr = decideNatureSociety(studentRec.RefClass.ClassName); } //前次考試 各科目 科排名 key = "前次科排名" + sceTakeRecord.Department + classNatureSocietyStr + "^^^" + gradeyear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(sceTakeRecord.ExamScore); rankStudents[key].Add(studentID); } //前次考試 各科目 全校排名 key = "前次全校排名" + gradeyear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(sceTakeRecord.ExamScore); rankStudents[key].Add(studentID); } } else { //summaryRank = false; } } #endregion } // BMK Tag1 計算總分 if (tag1ID != "" && conf.TagRank1SubjectList.Contains(subjectName)) { #region 有Tag1且是排名科目 foreach (var sceTakeRecord in studentExamSores[studentID][subjectName].Values) { if (sceTakeRecord != null && sceTakeRecord.SpecialCase == "") { tag1SubjectSum += sceTakeRecord.ExamScore;//計算總分 tag1SubjectCount++; //計算加權總分 tag1SubjectSumW += sceTakeRecord.ExamScore * decimal.ToInt16((decimal)sceTakeRecord.Credit); // BMK Tag1 學分 tag1SubjectCreditSum += decimal.ToInt16((decimal)sceTakeRecord.Credit); //各科目類別1排名 if (rank && sceTakeRecord.Status == "一般")//不在過濾名單且為一般生才做排名 { if (conf.PrintSubjectList.Contains(subjectName))//是列印科目才算科目排名 { key = "類別1排名" + tag1ID + "^^^" + gradeyear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(sceTakeRecord.ExamScore); rankStudents[key].Add(studentID); } } } else { tag1SummaryRank = false; } } #endregion } if (tag2ID != "" && conf.TagRank2SubjectList.Contains(subjectName)) { #region 有Tag2且是排名科目 foreach (var sceTakeRecord in studentExamSores[studentID][subjectName].Values) { if (sceTakeRecord != null && sceTakeRecord.SpecialCase == "") { tag2SubjectSum += sceTakeRecord.ExamScore;//計算總分 tag2SubjectCount++; //計算加權總分 tag2SubjectSumW += sceTakeRecord.ExamScore * decimal.ToInt16((decimal)sceTakeRecord.Credit); tag2SubjectCreditSum += decimal.ToInt16((decimal)sceTakeRecord.Credit); //各科目類別2排名 if (rank && sceTakeRecord.Status == "一般")//不在過濾名單且為一般生才做排名 { if (conf.PrintSubjectList.Contains(subjectName))//是列印科目才算科目排名 { key = "類別2排名" + tag2ID + "^^^" + gradeyear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(sceTakeRecord.ExamScore); rankStudents[key].Add(studentID); } } } else { tag2SummaryRank = false; } } #endregion } }// 單一學生考試成績 if (printSubjectCount > 0) { #region 有列印科目處理加總成績 //總分 studentPrintSubjectSum.Add(studentID, printSubjectSum); //平均四捨五入至小數點第二位 studentPrintSubjectAvg.Add(studentID, Math.Round(printSubjectSum / printSubjectCount, 2, MidpointRounding.AwayFromZero)); if (rank && studentRec.Status == "一般" && summaryRank == true)//不在過濾名單且沒有特殊成績狀況且為一般生才做排名 { // // BMK 排名 // //總分班排名 key = "總分班排名" + studentRec.RefClass.ClassID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(printSubjectSum); rankStudents[key].Add(studentID); // 普通科 有分 自然組 或 社會組 classNatureSocietyStr = ""; if (studentRec.RefClass.ClassName.IndexOf("普") > -1) { classNatureSocietyStr = decideNatureSociety(studentRec.RefClass.ClassName); } //總分科排名 key = "總分科排名" + studentRec.Department + classNatureSocietyStr + "^^^" + gradeyear; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(printSubjectSum); rankStudents[key].Add(studentID); //總分全校排名 key = "總分全校排名" + gradeyear; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(printSubjectSum); rankStudents[key].Add(studentID); //平均班排名 key = "平均班排名" + studentRec.RefClass.ClassID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(printSubjectSum / printSubjectCount, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); //平均科排名 // aaron key = "平均科排名" + studentRec.Department + classNatureSocietyStr + "^^^" + gradeyear; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(printSubjectSum / printSubjectCount, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); //平均全校排名 key = "平均全校排名" + gradeyear; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(printSubjectSum / printSubjectCount, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); } #endregion if (printSubjectCreditSum > 0) { #region 有總學分數處理加總 // BMK 學分數加總 subjectCreditSumList.Add(studentID, printSubjectCreditSum); //加權總分 studentPrintSubjectSumW.Add(studentID, printSubjectSumW); //加權平均四捨五入至小數點第二位 studentPrintSubjectAvgW.Add(studentID, Math.Round(printSubjectSumW / printSubjectCreditSum, 2, MidpointRounding.AwayFromZero)); if (rank && studentRec.Status == "一般" && summaryRank == true)//不在過濾名單且為一般生才做排名 { // // BMK 加權排名 // //加權總分班排名 key = "加權總分班排名" + studentRec.RefClass.ClassID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(printSubjectSumW); rankStudents[key].Add(studentID); // 普通科 有分 自然組 或 社會組 classNatureSocietyStr = ""; if (studentRec.RefClass.ClassName.IndexOf("普") > -1) { classNatureSocietyStr = decideNatureSociety(studentRec.RefClass.ClassName); } //加權總分科排名 key = "加權總分科排名" + studentRec.Department + classNatureSocietyStr + "^^^" + gradeyear; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(printSubjectSumW); rankStudents[key].Add(studentID); //加權總分全校排名 key = "加權總分全校排名" + gradeyear; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(printSubjectSumW); rankStudents[key].Add(studentID); //加權平均班排名 key = "加權平均班排名" + studentRec.RefClass.ClassID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(printSubjectSumW / printSubjectCreditSum, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); //加權平均科排名 key = "加權平均科排名" + studentRec.Department + classNatureSocietyStr + "^^^" + gradeyear; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(printSubjectSumW / printSubjectCreditSum, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); //加權平均全校排名 key = "加權平均全校排名" + gradeyear; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(printSubjectSumW / printSubjectCreditSum, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); } #endregion } } //類別1總分平均排名 if (tag1SubjectCount > 0) { // aaron 類別1 tag1 學分數加總 tag1SubjectCreditSumList.Add(studentID, tag1SubjectCreditSum); //總分 studentTag1SubjectSum.Add(studentID, tag1SubjectSum); //平均四捨五入至小數點第二位 studentTag1SubjectAvg.Add(studentID, Math.Round(tag1SubjectSum / tag1SubjectCount, 2, MidpointRounding.AwayFromZero)); if (rank && studentRec.Status == "一般" && tag1SummaryRank == true)//不在過濾名單且為一般生才做排名 { key = "類別1總分排名" + "^^^" + gradeyear + "^^^" + tag1ID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(tag1SubjectSum); rankStudents[key].Add(studentID); key = "類別1平均排名" + "^^^" + gradeyear + "^^^" + tag1ID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(tag1SubjectSum / tag1SubjectCount, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); } //類別1加權總分平均排名 if (tag1SubjectCreditSum > 0) { studentTag1SubjectSumW.Add(studentID, tag1SubjectSumW); studentTag1SubjectAvgW.Add(studentID, Math.Round(tag1SubjectSumW / tag1SubjectCreditSum, 2, MidpointRounding.AwayFromZero)); if (rank && studentRec.Status == "一般" && tag1SummaryRank == true)//不在過濾名單且為一般生才做排名 { key = "類別1加權總分排名" + "^^^" + gradeyear + "^^^" + tag1ID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(tag1SubjectSumW); rankStudents[key].Add(studentID); key = "類別1加權平均排名" + "^^^" + gradeyear + "^^^" + tag1ID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(tag1SubjectSumW / tag1SubjectCreditSum, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); } } } //類別2總分平均排名 if (tag2SubjectCount > 0) { //總分 studentTag2SubjectSum.Add(studentID, tag2SubjectSum); //平均四捨五入至小數點第二位 studentTag2SubjectAvg.Add(studentID, Math.Round(tag2SubjectSum / tag2SubjectCount, 2, MidpointRounding.AwayFromZero)); if (rank && studentRec.Status == "一般" && tag2SummaryRank == true)//不在過濾名單且為一般生才做排名 { key = "類別2總分排名" + "^^^" + gradeyear + "^^^" + tag2ID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(tag2SubjectSum); rankStudents[key].Add(studentID); key = "類別2平均排名" + "^^^" + gradeyear + "^^^" + tag2ID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(tag2SubjectSum / tag2SubjectCount, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); } //類別2加權總分平均排名 if (tag2SubjectCreditSum > 0) { studentTag2SubjectSumW.Add(studentID, tag2SubjectSumW); studentTag2SubjectAvgW.Add(studentID, Math.Round(tag2SubjectSumW / tag2SubjectCreditSum, 2, MidpointRounding.AwayFromZero)); if (rank && studentRec.Status == "一般" && tag2SummaryRank == true)//不在過濾名單且為一般生才做排名 { key = "類別2加權總分排名" + "^^^" + gradeyear + "^^^" + tag2ID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(tag2SubjectSumW); rankStudents[key].Add(studentID); key = "類別2加權平均排名" + "^^^" + gradeyear + "^^^" + tag2ID; if (!ranks.ContainsKey(key)) ranks.Add(key, new List<decimal>()); if (!rankStudents.ContainsKey(key)) rankStudents.Add(key, new List<string>()); ranks[key].Add(Math.Round(tag2SubjectSumW / tag2SubjectCreditSum, 2, MidpointRounding.AwayFromZero)); rankStudents[key].Add(studentID); } } } } progressCount++; bkw.ReportProgress(40 + progressCount * 30 / total); }//找出全年級學生 } foreach (var k in ranks.Keys) { var rankscores = ranks[k]; //排序 rankscores.Sort(); rankscores.Reverse(); //高均標、組距 if (rankscores.Count > 0) { #region 算高標的中點 int middleIndex = 0; int count = 1; var score = rankscores[0]; while (rankscores.Count > middleIndex) { if (score != rankscores[middleIndex]) { if (count * 2 >= rankscores.Count) break; score = rankscores[middleIndex]; } middleIndex++; count++; } if (rankscores.Count == middleIndex) { middleIndex--; count--; } #endregion analytics.Add(k + "^^^高標", Math.Round(rankscores.GetRange(0, count).Average(), 2, MidpointRounding.AwayFromZero)); analytics.Add(k + "^^^均標", Math.Round(rankscores.Average(), 2, MidpointRounding.AwayFromZero)); #region 算低標的中點 middleIndex = rankscores.Count - 1; count = 1; score = rankscores[middleIndex]; while (middleIndex >= 0) { if (score != rankscores[middleIndex]) { if (count * 2 >= rankscores.Count) break; score = rankscores[middleIndex]; } middleIndex--; count++; } if (middleIndex < 0) { middleIndex++; count--; } #endregion analytics.Add(k + "^^^低標", Math.Round(rankscores.GetRange(middleIndex, count).Average(), 2, MidpointRounding.AwayFromZero)); //Compute the Average var avg = (double)rankscores.Average(); //Perform the Sum of (value-avg)_2_2 var sum = (double)rankscores.Sum(d => Math.Pow((double)d - avg, 2)); //Put it all together analytics.Add(k + "^^^標準差", Math.Round((decimal)Math.Sqrt((sum) / rankscores.Count()), 2, MidpointRounding.AwayFromZero)); } #region 計算級距 int count90 = 0, count80 = 0, count70 = 0, count60 = 0, count50 = 0, count40 = 0, count30 = 0, count20 = 0, count10 = 0; int count100Up = 0, count90Up = 0, count80Up = 0, count70Up = 0, count60Up = 0, count50Up = 0, count40Up = 0, count30Up = 0, count20Up = 0, count10Up = 0; int count90Down = 0, count80Down = 0, count70Down = 0, count60Down = 0, count50Down = 0, count40Down = 0, count30Down = 0, count20Down = 0, count10Down = 0; foreach (var score in rankscores) { if (score >= 100) count100Up++; else if (score >= 90) count90++; else if (score >= 80) count80++; else if (score >= 70) count70++; else if (score >= 60) count60++; else if (score >= 50) count50++; else if (score >= 40) count40++; else if (score >= 30) count30++; else if (score >= 20) count20++; else if (score >= 10) count10++; else count10Down++; } count90Up = count100Up + count90; count80Up = count90Up + count80; count70Up = count80Up + count70; count60Up = count70Up + count60; count50Up = count60Up + count50; count40Up = count50Up + count40; count30Up = count40Up + count30; count20Up = count30Up + count20; count10Up = count20Up + count10; count20Down = count10Down + count10; count30Down = count20Down + count20; count40Down = count30Down + count30; count50Down = count40Down + count40; count60Down = count50Down + count50; count70Down = count60Down + count60; count80Down = count70Down + count70; count90Down = count80Down + count80; analytics.Add(k + "^^^count90", count90); analytics.Add(k + "^^^count80", count80); analytics.Add(k + "^^^count70", count70); analytics.Add(k + "^^^count60", count60); analytics.Add(k + "^^^count50", count50); analytics.Add(k + "^^^count40", count40); analytics.Add(k + "^^^count30", count30); analytics.Add(k + "^^^count20", count20); analytics.Add(k + "^^^count10", count10); analytics.Add(k + "^^^count100Up", count100Up); analytics.Add(k + "^^^count90Up", count90Up); analytics.Add(k + "^^^count80Up", count80Up); analytics.Add(k + "^^^count70Up", count70Up); analytics.Add(k + "^^^count60Up", count60Up); analytics.Add(k + "^^^count50Up", count50Up); analytics.Add(k + "^^^count40Up", count40Up); analytics.Add(k + "^^^count30Up", count30Up); analytics.Add(k + "^^^count20Up", count20Up); analytics.Add(k + "^^^count10Up", count10Up); analytics.Add(k + "^^^count90Down", count90Down); analytics.Add(k + "^^^count80Down", count80Down); analytics.Add(k + "^^^count70Down", count70Down); analytics.Add(k + "^^^count60Down", count60Down); analytics.Add(k + "^^^count50Down", count50Down); analytics.Add(k + "^^^count40Down", count40Down); analytics.Add(k + "^^^count30Down", count30Down); analytics.Add(k + "^^^count20Down", count20Down); analytics.Add(k + "^^^count10Down", count10Down); #endregion } #endregion bkw.ReportProgress(70); elseReady.WaitOne(); progressCount = 0; // BMK 填入資料表 #region 填入資料表 // 頁面所選的學生 foreach (var stuRec in studentRecords) { //BMK -- 只要考試其一科沒有成績 就不參與排名 也就沒有成績單 if (deleteSelectedRecords.Contains(stuRec) == true) continue; //bkw.ReportProgress(50); string studentID = stuRec.StudentID; string gradeYear = (stuRec.RefClass == null ? "" : "" + stuRec.RefClass.GradeYear); // BMK DataRow 開始 基本資料 DataRow row = table.NewRow(); #region 基本資料 row["學校名稱"] = SmartSchool.Customization.Data.SystemInformation.SchoolChineseName; row["學校地址"] = SmartSchool.Customization.Data.SystemInformation.Address; row["學校電話"] = SmartSchool.Customization.Data.SystemInformation.Telephone; row["收件人地址"] = stuRec.ContactInfo.MailingAddress.FullAddress != "" ? stuRec.ContactInfo.MailingAddress.FullAddress : stuRec.ContactInfo.PermanentAddress.FullAddress; row["收件人"] = stuRec.ParentInfo.CustodianName != "" ? stuRec.ParentInfo.CustodianName : (stuRec.ParentInfo.FatherName != "" ? stuRec.ParentInfo.FatherName : (stuRec.ParentInfo.FatherName != "" ? stuRec.ParentInfo.MotherName : stuRec.StudentName)); //«通訊地址»«通訊地址郵遞區號»«通訊地址內容» //«戶籍地址»«戶籍地址郵遞區號»«戶籍地址內容» //«監護人»«父親»«母親»«科別名稱» row["通訊地址"] = stuRec.ContactInfo.MailingAddress.FullAddress; row["通訊地址郵遞區號"] = stuRec.ContactInfo.MailingAddress.ZipCode; row["通訊地址內容"] = stuRec.ContactInfo.MailingAddress.County + stuRec.ContactInfo.MailingAddress.Town + stuRec.ContactInfo.MailingAddress.DetailAddress; row["戶籍地址"] = stuRec.ContactInfo.PermanentAddress.FullAddress; row["戶籍地址郵遞區號"] = stuRec.ContactInfo.PermanentAddress.ZipCode; row["戶籍地址內容"] = stuRec.ContactInfo.PermanentAddress.County + stuRec.ContactInfo.PermanentAddress.Town + stuRec.ContactInfo.PermanentAddress.DetailAddress; row["監護人"] = stuRec.ParentInfo.CustodianName; row["父親"] = stuRec.ParentInfo.FatherName; row["母親"] = stuRec.ParentInfo.MotherName; row["科別名稱"] = stuRec.Department; row["試別"] = conf.ExamRecord.Name; row["學年度"] = conf.SchoolYear; row["學期"] = conf.Semester; row["班級科別名稱"] = stuRec.RefClass == null ? "" : stuRec.RefClass.Department; row["班級"] = stuRec.RefClass == null ? "" : stuRec.RefClass.ClassName; row["班導師"] = (stuRec.RefClass == null || stuRec.RefClass.RefTeacher == null) ? "" : stuRec.RefClass.RefTeacher.TeacherName; row["座號"] = stuRec.SeatNo; row["學號"] = stuRec.StudentNumber; row["姓名"] = stuRec.StudentName; row["定期評量"] = conf.ExamRecord.Name; // aaron // BMK 導師的話 // whereClause = string.Format("班級編號='{0}'", stuRec.RefClass.ClassID); List<UDTTeacherWords> words = UDTAccess.Select(whereClause); if ( words.Count > 0 ) { teacherWord = words[0]; row["親愛的孩子"] = teacherWord.Heading; row["導師的話"] = teacherWord.TeacherWord; row["導師"] = teacherWord.TeacherName; } #endregion #region 成績資料 #region 各科成績資料 #region 整理科目順序 List<string> subjectNameList = new List<string>(); if (studentExamSores.ContainsKey(stuRec.StudentID)) { foreach (var subjectName in studentExamSores[studentID].Keys) { foreach (var courseID in studentExamSores[studentID][subjectName].Keys) { if (conf.PrintSubjectList.Contains(subjectName)) { subjectNameList.Add(subjectName); } } } } subjectNameList.Sort(new StringComparer("國文" , "英文" , "數學" , "理化" , "生物" , "社會" , "物理" , "化學" , "歷史" , "地理" , "公民")); #endregion int subjectIndex = 1; // 學期科目與定期評量 foreach (string subjectName in subjectNameList) { if (subjectIndex <= conf.SubjectLimit) { decimal? subjectNumber = null; // 檢查畫面上定期評量列印科目 if (conf.PrintSubjectList.Contains(subjectName)) { if (studentExamSores.ContainsKey(studentID)) { if (studentExamSores[studentID].ContainsKey(subjectName)) { foreach (var courseID in studentExamSores[studentID][subjectName].Keys) { // BMK row 評量成績 #region 評量成績 // 本次評量成績 var sceTakeRecord = studentExamSores[studentID][subjectName][courseID]; // aaron 前次評量成績 var PreSceTakeRecord = studentRefExamSores[studentID][subjectName][courseID]; if (PreSceTakeRecord != null && stuRec.RefClass != null) { // aaron 科目 前次班排名 key = "前次班排名" + stuRec.RefClass.ClassID + "^^^" + PreSceTakeRecord.Subject + "^^^" + PreSceTakeRecord.SubjectLevel; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["前次班排名" + subjectIndex] = ranks[key].IndexOf(PreSceTakeRecord.ExamScore) + 1; row["前次班排名母數" + subjectIndex] = ranks[key].Count; double rankPR = (((double)ranks[key].Count - (double)(ranks[key].IndexOf(PreSceTakeRecord.ExamScore) + 1)) / (double)ranks[key].Count * 100.0); row["PrePR" + subjectIndex] = Math.Round(rankPR, 0, MidpointRounding.AwayFromZero); } } if (sceTakeRecord != null) { //有輸入 decimal level; subjectNumber = decimal.TryParse(sceTakeRecord.SubjectLevel, out level) ? (decimal?)level : null; row["科目名稱" + subjectIndex] = sceTakeRecord.Subject + GetNumber(subjectNumber); row["學分數" + subjectIndex] = sceTakeRecord.Credit; row["科目成績" + subjectIndex] = sceTakeRecord.SpecialCase == "" ? ("" + sceTakeRecord.ExamScore) : sceTakeRecord.SpecialCase; // aaron CourseRecord //row["選修" + subjectIndex] = (sceTakeRecord.CourseID ).Required == true ? "必" : "選"; row["選修" + subjectIndex] = (accessHelper.CourseHelper.GetCourse(new string[] { sceTakeRecord.CourseID.ToString() }))[0].Required == true ? "必" : "選"; #region 班排名及落點分析 if (stuRec.RefClass != null) { // aaron 科目 班排名 key = "班排名" + stuRec.RefClass.ClassID + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["班排名" + subjectIndex] = ranks[key].IndexOf(sceTakeRecord.ExamScore) + 1; row["班排名母數" + subjectIndex] = ranks[key].Count; // aaron //row["PR" + subjectIndex] = (ranks[key].Count / 100) * (ranks[key].IndexOf(sceTakeRecord.ExamScore) + 1) * 100; //row["PR" + subjectIndex] = (100 / ranks[key].Count) * (ranks[key].IndexOf(sceTakeRecord.ExamScore) + 1); double rankPR = (((double)ranks[key].Count - (double)(ranks[key].IndexOf(sceTakeRecord.ExamScore) + 1)) / (double)ranks[key].Count * 100.0); row["PR" + subjectIndex] = Math.Round(rankPR, 0, MidpointRounding.AwayFromZero); } if (rankStudents.ContainsKey(key)) { row["班高標" + subjectIndex] = analytics[key + "^^^高標"]; row["班均標" + subjectIndex] = analytics[key + "^^^均標"]; row["班低標" + subjectIndex] = analytics[key + "^^^低標"]; row["班標準差" + subjectIndex] = analytics[key + "^^^標準差"]; row["班組距" + subjectIndex + "count90"] = analytics[key + "^^^count90"]; row["班組距" + subjectIndex + "count80"] = analytics[key + "^^^count80"]; row["班組距" + subjectIndex + "count70"] = analytics[key + "^^^count70"]; row["班組距" + subjectIndex + "count60"] = analytics[key + "^^^count60"]; row["班組距" + subjectIndex + "count50"] = analytics[key + "^^^count50"]; row["班組距" + subjectIndex + "count40"] = analytics[key + "^^^count40"]; row["班組距" + subjectIndex + "count30"] = analytics[key + "^^^count30"]; row["班組距" + subjectIndex + "count20"] = analytics[key + "^^^count20"]; row["班組距" + subjectIndex + "count10"] = analytics[key + "^^^count10"]; row["班組距" + subjectIndex + "count100Up"] = analytics[key + "^^^count100Up"]; row["班組距" + subjectIndex + "count90Up"] = analytics[key + "^^^count90Up"]; row["班組距" + subjectIndex + "count80Up"] = analytics[key + "^^^count80Up"]; row["班組距" + subjectIndex + "count70Up"] = analytics[key + "^^^count70Up"]; row["班組距" + subjectIndex + "count60Up"] = analytics[key + "^^^count60Up"]; row["班組距" + subjectIndex + "count50Up"] = analytics[key + "^^^count50Up"]; row["班組距" + subjectIndex + "count40Up"] = analytics[key + "^^^count40Up"]; row["班組距" + subjectIndex + "count30Up"] = analytics[key + "^^^count30Up"]; row["班組距" + subjectIndex + "count20Up"] = analytics[key + "^^^count20Up"]; row["班組距" + subjectIndex + "count10Up"] = analytics[key + "^^^count10Up"]; row["班組距" + subjectIndex + "count90Down"] = analytics[key + "^^^count90Down"]; row["班組距" + subjectIndex + "count80Down"] = analytics[key + "^^^count80Down"]; row["班組距" + subjectIndex + "count70Down"] = analytics[key + "^^^count70Down"]; row["班組距" + subjectIndex + "count60Down"] = analytics[key + "^^^count60Down"]; row["班組距" + subjectIndex + "count50Down"] = analytics[key + "^^^count50Down"]; row["班組距" + subjectIndex + "count40Down"] = analytics[key + "^^^count40Down"]; row["班組距" + subjectIndex + "count30Down"] = analytics[key + "^^^count30Down"]; row["班組距" + subjectIndex + "count20Down"] = analytics[key + "^^^count20Down"]; row["班組距" + subjectIndex + "count10Down"] = analytics[key + "^^^count10Down"]; } } #endregion #region 科排名及落點分析 if (stuRec.Department != "") { //aaron // 普通科 有分 自然組 或 社會組 classNatureSocietyStr = ""; if (stuRec.RefClass.ClassName.IndexOf("普") > -1) { classNatureSocietyStr = decideNatureSociety(stuRec.RefClass.ClassName); } // 各科目 科排名 key = "科排名" + stuRec.Department + classNatureSocietyStr + "^^^" + gradeYear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["科排名" + subjectIndex] = ranks[key].IndexOf(sceTakeRecord.ExamScore) + 1; row["科排名母數" + subjectIndex] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["科高標" + subjectIndex] = analytics[key + "^^^高標"]; row["科均標" + subjectIndex] = analytics[key + "^^^均標"]; row["科低標" + subjectIndex] = analytics[key + "^^^低標"]; row["科標準差" + subjectIndex] = analytics[key + "^^^標準差"]; row["科組距" + subjectIndex + "count90"] = analytics[key + "^^^count90"]; row["科組距" + subjectIndex + "count80"] = analytics[key + "^^^count80"]; row["科組距" + subjectIndex + "count70"] = analytics[key + "^^^count70"]; row["科組距" + subjectIndex + "count60"] = analytics[key + "^^^count60"]; row["科組距" + subjectIndex + "count50"] = analytics[key + "^^^count50"]; row["科組距" + subjectIndex + "count40"] = analytics[key + "^^^count40"]; row["科組距" + subjectIndex + "count30"] = analytics[key + "^^^count30"]; row["科組距" + subjectIndex + "count20"] = analytics[key + "^^^count20"]; row["科組距" + subjectIndex + "count10"] = analytics[key + "^^^count10"]; row["科組距" + subjectIndex + "count100Up"] = analytics[key + "^^^count100Up"]; row["科組距" + subjectIndex + "count90Up"] = analytics[key + "^^^count90Up"]; row["科組距" + subjectIndex + "count80Up"] = analytics[key + "^^^count80Up"]; row["科組距" + subjectIndex + "count70Up"] = analytics[key + "^^^count70Up"]; row["科組距" + subjectIndex + "count60Up"] = analytics[key + "^^^count60Up"]; row["科組距" + subjectIndex + "count50Up"] = analytics[key + "^^^count50Up"]; row["科組距" + subjectIndex + "count40Up"] = analytics[key + "^^^count40Up"]; row["科組距" + subjectIndex + "count30Up"] = analytics[key + "^^^count30Up"]; row["科組距" + subjectIndex + "count20Up"] = analytics[key + "^^^count20Up"]; row["科組距" + subjectIndex + "count10Up"] = analytics[key + "^^^count10Up"]; row["科組距" + subjectIndex + "count90Down"] = analytics[key + "^^^count90Down"]; row["科組距" + subjectIndex + "count80Down"] = analytics[key + "^^^count80Down"]; row["科組距" + subjectIndex + "count70Down"] = analytics[key + "^^^count70Down"]; row["科組距" + subjectIndex + "count60Down"] = analytics[key + "^^^count60Down"]; row["科組距" + subjectIndex + "count50Down"] = analytics[key + "^^^count50Down"]; row["科組距" + subjectIndex + "count40Down"] = analytics[key + "^^^count40Down"]; row["科組距" + subjectIndex + "count30Down"] = analytics[key + "^^^count30Down"]; row["科組距" + subjectIndex + "count20Down"] = analytics[key + "^^^count20Down"]; row["科組距" + subjectIndex + "count10Down"] = analytics[key + "^^^count10Down"]; } } #endregion #region 全校排名及落點分析 key = "全校排名" + gradeYear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["全校排名" + subjectIndex] = ranks[key].IndexOf(sceTakeRecord.ExamScore) + 1; row["全校排名母數" + subjectIndex] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["校高標" + subjectIndex] = analytics[key + "^^^高標"]; row["校均標" + subjectIndex] = analytics[key + "^^^均標"]; row["校低標" + subjectIndex] = analytics[key + "^^^低標"]; row["校標準差" + subjectIndex] = analytics[key + "^^^標準差"]; row["校組距" + subjectIndex + "count90"] = analytics[key + "^^^count90"]; row["校組距" + subjectIndex + "count80"] = analytics[key + "^^^count80"]; row["校組距" + subjectIndex + "count70"] = analytics[key + "^^^count70"]; row["校組距" + subjectIndex + "count60"] = analytics[key + "^^^count60"]; row["校組距" + subjectIndex + "count50"] = analytics[key + "^^^count50"]; row["校組距" + subjectIndex + "count40"] = analytics[key + "^^^count40"]; row["校組距" + subjectIndex + "count30"] = analytics[key + "^^^count30"]; row["校組距" + subjectIndex + "count20"] = analytics[key + "^^^count20"]; row["校組距" + subjectIndex + "count10"] = analytics[key + "^^^count10"]; row["校組距" + subjectIndex + "count100Up"] = analytics[key + "^^^count100Up"]; row["校組距" + subjectIndex + "count90Up"] = analytics[key + "^^^count90Up"]; row["校組距" + subjectIndex + "count80Up"] = analytics[key + "^^^count80Up"]; row["校組距" + subjectIndex + "count70Up"] = analytics[key + "^^^count70Up"]; row["校組距" + subjectIndex + "count60Up"] = analytics[key + "^^^count60Up"]; row["校組距" + subjectIndex + "count50Up"] = analytics[key + "^^^count50Up"]; row["校組距" + subjectIndex + "count40Up"] = analytics[key + "^^^count40Up"]; row["校組距" + subjectIndex + "count30Up"] = analytics[key + "^^^count30Up"]; row["校組距" + subjectIndex + "count20Up"] = analytics[key + "^^^count20Up"]; row["校組距" + subjectIndex + "count10Up"] = analytics[key + "^^^count10Up"]; row["校組距" + subjectIndex + "count90Down"] = analytics[key + "^^^count90Down"]; row["校組距" + subjectIndex + "count80Down"] = analytics[key + "^^^count80Down"]; row["校組距" + subjectIndex + "count70Down"] = analytics[key + "^^^count70Down"]; row["校組距" + subjectIndex + "count60Down"] = analytics[key + "^^^count60Down"]; row["校組距" + subjectIndex + "count50Down"] = analytics[key + "^^^count50Down"]; row["校組距" + subjectIndex + "count40Down"] = analytics[key + "^^^count40Down"]; row["校組距" + subjectIndex + "count30Down"] = analytics[key + "^^^count30Down"]; row["校組距" + subjectIndex + "count20Down"] = analytics[key + "^^^count20Down"]; row["校組距" + subjectIndex + "count10Down"] = analytics[key + "^^^count10Down"]; } #endregion #region 類別1排名及落點分析 if (studentTag1Group.ContainsKey(studentID) && conf.TagRank1SubjectList.Contains(subjectName)) { key = "類別1排名" + studentTag1Group[studentID] + "^^^" + gradeYear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["類別1排名" + subjectIndex] = ranks[key].IndexOf(sceTakeRecord.ExamScore) + 1; row["類別1排名母數" + subjectIndex] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類1高標" + subjectIndex] = analytics[key + "^^^高標"]; row["類1均標" + subjectIndex] = analytics[key + "^^^均標"]; row["類1低標" + subjectIndex] = analytics[key + "^^^低標"]; row["類1標準差" + subjectIndex] = analytics[key + "^^^標準差"]; row["類1組距" + subjectIndex + "count90"] = analytics[key + "^^^count90"]; row["類1組距" + subjectIndex + "count80"] = analytics[key + "^^^count80"]; row["類1組距" + subjectIndex + "count70"] = analytics[key + "^^^count70"]; row["類1組距" + subjectIndex + "count60"] = analytics[key + "^^^count60"]; row["類1組距" + subjectIndex + "count50"] = analytics[key + "^^^count50"]; row["類1組距" + subjectIndex + "count40"] = analytics[key + "^^^count40"]; row["類1組距" + subjectIndex + "count30"] = analytics[key + "^^^count30"]; row["類1組距" + subjectIndex + "count20"] = analytics[key + "^^^count20"]; row["類1組距" + subjectIndex + "count10"] = analytics[key + "^^^count10"]; row["類1組距" + subjectIndex + "count100Up"] = analytics[key + "^^^count100Up"]; row["類1組距" + subjectIndex + "count90Up"] = analytics[key + "^^^count90Up"]; row["類1組距" + subjectIndex + "count80Up"] = analytics[key + "^^^count80Up"]; row["類1組距" + subjectIndex + "count70Up"] = analytics[key + "^^^count70Up"]; row["類1組距" + subjectIndex + "count60Up"] = analytics[key + "^^^count60Up"]; row["類1組距" + subjectIndex + "count50Up"] = analytics[key + "^^^count50Up"]; row["類1組距" + subjectIndex + "count40Up"] = analytics[key + "^^^count40Up"]; row["類1組距" + subjectIndex + "count30Up"] = analytics[key + "^^^count30Up"]; row["類1組距" + subjectIndex + "count20Up"] = analytics[key + "^^^count20Up"]; row["類1組距" + subjectIndex + "count10Up"] = analytics[key + "^^^count10Up"]; row["類1組距" + subjectIndex + "count90Down"] = analytics[key + "^^^count90Down"]; row["類1組距" + subjectIndex + "count80Down"] = analytics[key + "^^^count80Down"]; row["類1組距" + subjectIndex + "count70Down"] = analytics[key + "^^^count70Down"]; row["類1組距" + subjectIndex + "count60Down"] = analytics[key + "^^^count60Down"]; row["類1組距" + subjectIndex + "count50Down"] = analytics[key + "^^^count50Down"]; row["類1組距" + subjectIndex + "count40Down"] = analytics[key + "^^^count40Down"]; row["類1組距" + subjectIndex + "count30Down"] = analytics[key + "^^^count30Down"]; row["類1組距" + subjectIndex + "count20Down"] = analytics[key + "^^^count20Down"]; row["類1組距" + subjectIndex + "count10Down"] = analytics[key + "^^^count10Down"]; } } #endregion #region 類別2排名及落點分析 if (studentTag2Group.ContainsKey(studentID) && conf.TagRank2SubjectList.Contains(subjectName)) { key = "類別2排名" + studentTag2Group[studentID] + "^^^" + gradeYear + "^^^" + sceTakeRecord.Subject + "^^^" + sceTakeRecord.SubjectLevel; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["類別2排名" + subjectIndex] = ranks[key].IndexOf(sceTakeRecord.ExamScore) + 1; row["類別2排名母數" + subjectIndex] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類2高標" + subjectIndex] = analytics[key + "^^^高標"]; row["類2均標" + subjectIndex] = analytics[key + "^^^均標"]; row["類2低標" + subjectIndex] = analytics[key + "^^^低標"]; row["類2標準差" + subjectIndex] = analytics[key + "^^^標準差"]; row["類2組距" + subjectIndex + "count90"] = analytics[key + "^^^count90"]; row["類2組距" + subjectIndex + "count80"] = analytics[key + "^^^count80"]; row["類2組距" + subjectIndex + "count70"] = analytics[key + "^^^count70"]; row["類2組距" + subjectIndex + "count60"] = analytics[key + "^^^count60"]; row["類2組距" + subjectIndex + "count50"] = analytics[key + "^^^count50"]; row["類2組距" + subjectIndex + "count40"] = analytics[key + "^^^count40"]; row["類2組距" + subjectIndex + "count30"] = analytics[key + "^^^count30"]; row["類2組距" + subjectIndex + "count20"] = analytics[key + "^^^count20"]; row["類2組距" + subjectIndex + "count10"] = analytics[key + "^^^count10"]; row["類2組距" + subjectIndex + "count100Up"] = analytics[key + "^^^count100Up"]; row["類2組距" + subjectIndex + "count90Up"] = analytics[key + "^^^count90Up"]; row["類2組距" + subjectIndex + "count80Up"] = analytics[key + "^^^count80Up"]; row["類2組距" + subjectIndex + "count70Up"] = analytics[key + "^^^count70Up"]; row["類2組距" + subjectIndex + "count60Up"] = analytics[key + "^^^count60Up"]; row["類2組距" + subjectIndex + "count50Up"] = analytics[key + "^^^count50Up"]; row["類2組距" + subjectIndex + "count40Up"] = analytics[key + "^^^count40Up"]; row["類2組距" + subjectIndex + "count30Up"] = analytics[key + "^^^count30Up"]; row["類2組距" + subjectIndex + "count20Up"] = analytics[key + "^^^count20Up"]; row["類2組距" + subjectIndex + "count10Up"] = analytics[key + "^^^count10Up"]; row["類2組距" + subjectIndex + "count90Down"] = analytics[key + "^^^count90Down"]; row["類2組距" + subjectIndex + "count80Down"] = analytics[key + "^^^count80Down"]; row["類2組距" + subjectIndex + "count70Down"] = analytics[key + "^^^count70Down"]; row["類2組距" + subjectIndex + "count60Down"] = analytics[key + "^^^count60Down"]; row["類2組距" + subjectIndex + "count50Down"] = analytics[key + "^^^count50Down"]; row["類2組距" + subjectIndex + "count40Down"] = analytics[key + "^^^count40Down"]; row["類2組距" + subjectIndex + "count30Down"] = analytics[key + "^^^count30Down"]; row["類2組距" + subjectIndex + "count20Down"] = analytics[key + "^^^count20Down"]; row["類2組距" + subjectIndex + "count10Down"] = analytics[key + "^^^count10Down"]; } } #endregion } else {//修課有該考試但沒有成績資料 var courseRecs = accessHelper.CourseHelper.GetCourse(courseID); if (courseRecs.Count > 0) { var courseRec = courseRecs[0]; decimal level; subjectNumber = decimal.TryParse(courseRec.SubjectLevel, out level) ? (decimal?)level : null; row["科目名稱" + subjectIndex] = courseRec.Subject + GetNumber(subjectNumber); row["學分數" + subjectIndex] = courseRec.Credit; row["科目成績" + subjectIndex] = "未輸入"; } } #endregion // BMK ---- 參考成績 /* #region 參考成績 if (studentRefExamSores.ContainsKey(studentID) && studentRefExamSores[studentID].ContainsKey(courseID)) { row["前次成績" + subjectIndex] = studentRefExamSores[studentID][courseID].SpecialCase == "" ? ("" + studentRefExamSores[studentID][courseID].ExamScore) : studentRefExamSores[studentID][courseID].SpecialCase; } #endregion */ studentExamSores[studentID][subjectName].Remove(courseID); break; } } } } subjectIndex++; } else { //重要!!發現資料在樣板中印不下時一定要記錄起來,否則使用者自己不會去發現的 if (!overflowRecords.Contains(stuRec)) overflowRecords.Add(stuRec); } } #endregion // BMK 一般 綜合成績 總分 #region 總分 if (studentPrintSubjectSum.ContainsKey(studentID)) { //aaron if (subjectCreditSumList.ContainsKey(studentID)) { //row["所修學分"] = tag1SubjectCreditSum; //row["所修學分"] = tag1SubjectCreditSumList[studentID]; row["所修學分"] = subjectCreditSumList[studentID]; } row["總分"] = studentPrintSubjectSum[studentID]; //BMK 總分班排名 key = "總分班排名" + stuRec.RefClass.ClassID; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["總分班排名"] = ranks[key].IndexOf(studentPrintSubjectSum[studentID]) + 1; row["總分班排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["總分班高標"] = analytics[key + "^^^高標"]; row["總分班均標"] = analytics[key + "^^^均標"]; row["總分班低標"] = analytics[key + "^^^低標"]; row["總分班標準差"] = analytics[key + "^^^標準差"]; row["總分班組距count90"] = analytics[key + "^^^count90"]; row["總分班組距count80"] = analytics[key + "^^^count80"]; row["總分班組距count70"] = analytics[key + "^^^count70"]; row["總分班組距count60"] = analytics[key + "^^^count60"]; row["總分班組距count50"] = analytics[key + "^^^count50"]; row["總分班組距count40"] = analytics[key + "^^^count40"]; row["總分班組距count30"] = analytics[key + "^^^count30"]; row["總分班組距count20"] = analytics[key + "^^^count20"]; row["總分班組距count10"] = analytics[key + "^^^count10"]; row["總分班組距count100Up"] = analytics[key + "^^^count100Up"]; row["總分班組距count90Up"] = analytics[key + "^^^count90Up"]; row["總分班組距count80Up"] = analytics[key + "^^^count80Up"]; row["總分班組距count70Up"] = analytics[key + "^^^count70Up"]; row["總分班組距count60Up"] = analytics[key + "^^^count60Up"]; row["總分班組距count50Up"] = analytics[key + "^^^count50Up"]; row["總分班組距count40Up"] = analytics[key + "^^^count40Up"]; row["總分班組距count30Up"] = analytics[key + "^^^count30Up"]; row["總分班組距count20Up"] = analytics[key + "^^^count20Up"]; row["總分班組距count10Up"] = analytics[key + "^^^count10Up"]; row["總分班組距count90Down"] = analytics[key + "^^^count90Down"]; row["總分班組距count80Down"] = analytics[key + "^^^count80Down"]; row["總分班組距count70Down"] = analytics[key + "^^^count70Down"]; row["總分班組距count60Down"] = analytics[key + "^^^count60Down"]; row["總分班組距count50Down"] = analytics[key + "^^^count50Down"]; row["總分班組距count40Down"] = analytics[key + "^^^count40Down"]; row["總分班組距count30Down"] = analytics[key + "^^^count30Down"]; row["總分班組距count20Down"] = analytics[key + "^^^count20Down"]; row["總分班組距count10Down"] = analytics[key + "^^^count10Down"]; } // 普通科 有分 自然組 或 社會組 classNatureSocietyStr = ""; if (stuRec.RefClass.ClassName.IndexOf("普") > -1) { classNatureSocietyStr = decideNatureSociety(stuRec.RefClass.ClassName); } //總分科排名 key = "總分科排名" + stuRec.Department + classNatureSocietyStr + "^^^" + gradeYear; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["總分科排名"] = ranks[key].IndexOf(studentPrintSubjectSum[studentID]) + 1; row["總分科排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["總分科高標"] = analytics[key + "^^^高標"]; row["總分科均標"] = analytics[key + "^^^均標"]; row["總分科低標"] = analytics[key + "^^^低標"]; row["總分科標準差"] = analytics[key + "^^^標準差"]; row["總分科組距count90"] = analytics[key + "^^^count90"]; row["總分科組距count80"] = analytics[key + "^^^count80"]; row["總分科組距count70"] = analytics[key + "^^^count70"]; row["總分科組距count60"] = analytics[key + "^^^count60"]; row["總分科組距count50"] = analytics[key + "^^^count50"]; row["總分科組距count40"] = analytics[key + "^^^count40"]; row["總分科組距count30"] = analytics[key + "^^^count30"]; row["總分科組距count20"] = analytics[key + "^^^count20"]; row["總分科組距count10"] = analytics[key + "^^^count10"]; row["總分科組距count100Up"] = analytics[key + "^^^count100Up"]; row["總分科組距count90Up"] = analytics[key + "^^^count90Up"]; row["總分科組距count80Up"] = analytics[key + "^^^count80Up"]; row["總分科組距count70Up"] = analytics[key + "^^^count70Up"]; row["總分科組距count60Up"] = analytics[key + "^^^count60Up"]; row["總分科組距count50Up"] = analytics[key + "^^^count50Up"]; row["總分科組距count40Up"] = analytics[key + "^^^count40Up"]; row["總分科組距count30Up"] = analytics[key + "^^^count30Up"]; row["總分科組距count20Up"] = analytics[key + "^^^count20Up"]; row["總分科組距count10Up"] = analytics[key + "^^^count10Up"]; row["總分科組距count90Down"] = analytics[key + "^^^count90Down"]; row["總分科組距count80Down"] = analytics[key + "^^^count80Down"]; row["總分科組距count70Down"] = analytics[key + "^^^count70Down"]; row["總分科組距count60Down"] = analytics[key + "^^^count60Down"]; row["總分科組距count50Down"] = analytics[key + "^^^count50Down"]; row["總分科組距count40Down"] = analytics[key + "^^^count40Down"]; row["總分科組距count30Down"] = analytics[key + "^^^count30Down"]; row["總分科組距count20Down"] = analytics[key + "^^^count20Down"]; row["總分科組距count10Down"] = analytics[key + "^^^count10Down"]; } //總分全校排名 key = "總分全校排名" + gradeYear; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["總分全校排名"] = ranks[key].IndexOf(studentPrintSubjectSum[studentID]) + 1; row["總分全校排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["總分校高標"] = analytics[key + "^^^高標"]; row["總分校均標"] = analytics[key + "^^^均標"]; row["總分校低標"] = analytics[key + "^^^低標"]; row["總分校標準差"] = analytics[key + "^^^標準差"]; row["總分校組距count90"] = analytics[key + "^^^count90"]; row["總分校組距count80"] = analytics[key + "^^^count80"]; row["總分校組距count70"] = analytics[key + "^^^count70"]; row["總分校組距count60"] = analytics[key + "^^^count60"]; row["總分校組距count50"] = analytics[key + "^^^count50"]; row["總分校組距count40"] = analytics[key + "^^^count40"]; row["總分校組距count30"] = analytics[key + "^^^count30"]; row["總分校組距count20"] = analytics[key + "^^^count20"]; row["總分校組距count10"] = analytics[key + "^^^count10"]; row["總分校組距count100Up"] = analytics[key + "^^^count100Up"]; row["總分校組距count90Up"] = analytics[key + "^^^count90Up"]; row["總分校組距count80Up"] = analytics[key + "^^^count80Up"]; row["總分校組距count70Up"] = analytics[key + "^^^count70Up"]; row["總分校組距count60Up"] = analytics[key + "^^^count60Up"]; row["總分校組距count50Up"] = analytics[key + "^^^count50Up"]; row["總分校組距count40Up"] = analytics[key + "^^^count40Up"]; row["總分校組距count30Up"] = analytics[key + "^^^count30Up"]; row["總分校組距count20Up"] = analytics[key + "^^^count20Up"]; row["總分校組距count10Up"] = analytics[key + "^^^count10Up"]; row["總分校組距count90Down"] = analytics[key + "^^^count90Down"]; row["總分校組距count80Down"] = analytics[key + "^^^count80Down"]; row["總分校組距count70Down"] = analytics[key + "^^^count70Down"]; row["總分校組距count60Down"] = analytics[key + "^^^count60Down"]; row["總分校組距count50Down"] = analytics[key + "^^^count50Down"]; row["總分校組距count40Down"] = analytics[key + "^^^count40Down"]; row["總分校組距count30Down"] = analytics[key + "^^^count30Down"]; row["總分校組距count20Down"] = analytics[key + "^^^count20Down"]; row["總分校組距count10Down"] = analytics[key + "^^^count10Down"]; } } #endregion #region 平均 if (studentPrintSubjectAvg.ContainsKey(studentID)) { row["平均"] = studentPrintSubjectAvg[studentID]; key = "平均班排名" + stuRec.RefClass.ClassID; //明確判斷學生是否參與排名 if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID) ) { row["平均班排名"] = ranks[key].IndexOf(studentPrintSubjectAvg[studentID]) + 1; row["平均班排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["平均班高標"] = analytics[key + "^^^高標"]; row["平均班均標"] = analytics[key + "^^^均標"]; row["平均班低標"] = analytics[key + "^^^低標"]; row["平均班標準差"] = analytics[key + "^^^標準差"]; row["平均班組距count90"] = analytics[key + "^^^count90"]; row["平均班組距count80"] = analytics[key + "^^^count80"]; row["平均班組距count70"] = analytics[key + "^^^count70"]; row["平均班組距count60"] = analytics[key + "^^^count60"]; row["平均班組距count50"] = analytics[key + "^^^count50"]; row["平均班組距count40"] = analytics[key + "^^^count40"]; row["平均班組距count30"] = analytics[key + "^^^count30"]; row["平均班組距count20"] = analytics[key + "^^^count20"]; row["平均班組距count10"] = analytics[key + "^^^count10"]; row["平均班組距count100Up"] = analytics[key + "^^^count100Up"]; row["平均班組距count90Up"] = analytics[key + "^^^count90Up"]; row["平均班組距count80Up"] = analytics[key + "^^^count80Up"]; row["平均班組距count70Up"] = analytics[key + "^^^count70Up"]; row["平均班組距count60Up"] = analytics[key + "^^^count60Up"]; row["平均班組距count50Up"] = analytics[key + "^^^count50Up"]; row["平均班組距count40Up"] = analytics[key + "^^^count40Up"]; row["平均班組距count30Up"] = analytics[key + "^^^count30Up"]; row["平均班組距count20Up"] = analytics[key + "^^^count20Up"]; row["平均班組距count10Up"] = analytics[key + "^^^count10Up"]; row["平均班組距count90Down"] = analytics[key + "^^^count90Down"]; row["平均班組距count80Down"] = analytics[key + "^^^count80Down"]; row["平均班組距count70Down"] = analytics[key + "^^^count70Down"]; row["平均班組距count60Down"] = analytics[key + "^^^count60Down"]; row["平均班組距count50Down"] = analytics[key + "^^^count50Down"]; row["平均班組距count40Down"] = analytics[key + "^^^count40Down"]; row["平均班組距count30Down"] = analytics[key + "^^^count30Down"]; row["平均班組距count20Down"] = analytics[key + "^^^count20Down"]; row["平均班組距count10Down"] = analytics[key + "^^^count10Down"]; } // 普通科 有分 自然組 或 社會組 classNatureSocietyStr = ""; if (stuRec.RefClass.ClassName.IndexOf("普") > -1) { classNatureSocietyStr = decideNatureSociety(stuRec.RefClass.ClassName); } key = "平均科排名" + stuRec.Department + classNatureSocietyStr + "^^^" + gradeYear; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["平均科排名"] = ranks[key].IndexOf(studentPrintSubjectAvg[studentID]) + 1; row["平均科排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["平均科高標"] = analytics[key + "^^^高標"]; row["平均科均標"] = analytics[key + "^^^均標"]; row["平均科低標"] = analytics[key + "^^^低標"]; row["平均科標準差"] = analytics[key + "^^^標準差"]; row["平均科組距count90"] = analytics[key + "^^^count90"]; row["平均科組距count80"] = analytics[key + "^^^count80"]; row["平均科組距count70"] = analytics[key + "^^^count70"]; row["平均科組距count60"] = analytics[key + "^^^count60"]; row["平均科組距count50"] = analytics[key + "^^^count50"]; row["平均科組距count40"] = analytics[key + "^^^count40"]; row["平均科組距count30"] = analytics[key + "^^^count30"]; row["平均科組距count20"] = analytics[key + "^^^count20"]; row["平均科組距count10"] = analytics[key + "^^^count10"]; row["平均科組距count100Up"] = analytics[key + "^^^count100Up"]; row["平均科組距count90Up"] = analytics[key + "^^^count90Up"]; row["平均科組距count80Up"] = analytics[key + "^^^count80Up"]; row["平均科組距count70Up"] = analytics[key + "^^^count70Up"]; row["平均科組距count60Up"] = analytics[key + "^^^count60Up"]; row["平均科組距count50Up"] = analytics[key + "^^^count50Up"]; row["平均科組距count40Up"] = analytics[key + "^^^count40Up"]; row["平均科組距count30Up"] = analytics[key + "^^^count30Up"]; row["平均科組距count20Up"] = analytics[key + "^^^count20Up"]; row["平均科組距count10Up"] = analytics[key + "^^^count10Up"]; row["平均科組距count90Down"] = analytics[key + "^^^count90Down"]; row["平均科組距count80Down"] = analytics[key + "^^^count80Down"]; row["平均科組距count70Down"] = analytics[key + "^^^count70Down"]; row["平均科組距count60Down"] = analytics[key + "^^^count60Down"]; row["平均科組距count50Down"] = analytics[key + "^^^count50Down"]; row["平均科組距count40Down"] = analytics[key + "^^^count40Down"]; row["平均科組距count30Down"] = analytics[key + "^^^count30Down"]; row["平均科組距count20Down"] = analytics[key + "^^^count20Down"]; row["平均科組距count10Down"] = analytics[key + "^^^count10Down"]; } key = "平均全校排名" + gradeYear; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["平均全校排名"] = ranks[key].IndexOf(studentPrintSubjectAvg[studentID]) + 1; row["平均全校排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["平均校高標"] = analytics[key + "^^^高標"]; row["平均校均標"] = analytics[key + "^^^均標"]; row["平均校低標"] = analytics[key + "^^^低標"]; row["平均校標準差"] = analytics[key + "^^^標準差"]; row["平均校組距count90"] = analytics[key + "^^^count90"]; row["平均校組距count80"] = analytics[key + "^^^count80"]; row["平均校組距count70"] = analytics[key + "^^^count70"]; row["平均校組距count60"] = analytics[key + "^^^count60"]; row["平均校組距count50"] = analytics[key + "^^^count50"]; row["平均校組距count40"] = analytics[key + "^^^count40"]; row["平均校組距count30"] = analytics[key + "^^^count30"]; row["平均校組距count20"] = analytics[key + "^^^count20"]; row["平均校組距count10"] = analytics[key + "^^^count10"]; row["平均校組距count100Up"] = analytics[key + "^^^count100Up"]; row["平均校組距count90Up"] = analytics[key + "^^^count90Up"]; row["平均校組距count80Up"] = analytics[key + "^^^count80Up"]; row["平均校組距count70Up"] = analytics[key + "^^^count70Up"]; row["平均校組距count60Up"] = analytics[key + "^^^count60Up"]; row["平均校組距count50Up"] = analytics[key + "^^^count50Up"]; row["平均校組距count40Up"] = analytics[key + "^^^count40Up"]; row["平均校組距count30Up"] = analytics[key + "^^^count30Up"]; row["平均校組距count20Up"] = analytics[key + "^^^count20Up"]; row["平均校組距count10Up"] = analytics[key + "^^^count10Up"]; row["平均校組距count90Down"] = analytics[key + "^^^count90Down"]; row["平均校組距count80Down"] = analytics[key + "^^^count80Down"]; row["平均校組距count70Down"] = analytics[key + "^^^count70Down"]; row["平均校組距count60Down"] = analytics[key + "^^^count60Down"]; row["平均校組距count50Down"] = analytics[key + "^^^count50Down"]; row["平均校組距count40Down"] = analytics[key + "^^^count40Down"]; row["平均校組距count30Down"] = analytics[key + "^^^count30Down"]; row["平均校組距count20Down"] = analytics[key + "^^^count20Down"]; row["平均校組距count10Down"] = analytics[key + "^^^count10Down"]; } } #endregion #region 加權總分 if (studentPrintSubjectSumW.ContainsKey(studentID)) { row["加權總分"] = studentPrintSubjectSumW[studentID]; key = "加權總分班排名" + stuRec.RefClass.ClassID; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["加權總分班排名"] = ranks[key].IndexOf(studentPrintSubjectSumW[studentID]) + 1; row["加權總分班排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["加權總分班高標"] = analytics[key + "^^^高標"]; row["加權總分班均標"] = analytics[key + "^^^均標"]; row["加權總分班低標"] = analytics[key + "^^^低標"]; row["加權總分班標準差"] = analytics[key + "^^^標準差"]; row["加權總分班組距count90"] = analytics[key + "^^^count90"]; row["加權總分班組距count80"] = analytics[key + "^^^count80"]; row["加權總分班組距count70"] = analytics[key + "^^^count70"]; row["加權總分班組距count60"] = analytics[key + "^^^count60"]; row["加權總分班組距count50"] = analytics[key + "^^^count50"]; row["加權總分班組距count40"] = analytics[key + "^^^count40"]; row["加權總分班組距count30"] = analytics[key + "^^^count30"]; row["加權總分班組距count20"] = analytics[key + "^^^count20"]; row["加權總分班組距count10"] = analytics[key + "^^^count10"]; row["加權總分班組距count100Up"] = analytics[key + "^^^count100Up"]; row["加權總分班組距count90Up"] = analytics[key + "^^^count90Up"]; row["加權總分班組距count80Up"] = analytics[key + "^^^count80Up"]; row["加權總分班組距count70Up"] = analytics[key + "^^^count70Up"]; row["加權總分班組距count60Up"] = analytics[key + "^^^count60Up"]; row["加權總分班組距count50Up"] = analytics[key + "^^^count50Up"]; row["加權總分班組距count40Up"] = analytics[key + "^^^count40Up"]; row["加權總分班組距count30Up"] = analytics[key + "^^^count30Up"]; row["加權總分班組距count20Up"] = analytics[key + "^^^count20Up"]; row["加權總分班組距count10Up"] = analytics[key + "^^^count10Up"]; row["加權總分班組距count90Down"] = analytics[key + "^^^count90Down"]; row["加權總分班組距count80Down"] = analytics[key + "^^^count80Down"]; row["加權總分班組距count70Down"] = analytics[key + "^^^count70Down"]; row["加權總分班組距count60Down"] = analytics[key + "^^^count60Down"]; row["加權總分班組距count50Down"] = analytics[key + "^^^count50Down"]; row["加權總分班組距count40Down"] = analytics[key + "^^^count40Down"]; row["加權總分班組距count30Down"] = analytics[key + "^^^count30Down"]; row["加權總分班組距count20Down"] = analytics[key + "^^^count20Down"]; row["加權總分班組距count10Down"] = analytics[key + "^^^count10Down"]; } // 普通科 有分 自然組 或 社會組 classNatureSocietyStr = ""; if (stuRec.RefClass.ClassName.IndexOf("普") > -1) { classNatureSocietyStr = decideNatureSociety(stuRec.RefClass.ClassName); } key = "加權總分科排名" + stuRec.Department + classNatureSocietyStr + "^^^" + gradeYear; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["加權總分科排名"] = ranks[key].IndexOf(studentPrintSubjectSumW[studentID]) + 1; row["加權總分科排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["加權總分科高標"] = analytics[key + "^^^高標"]; row["加權總分科均標"] = analytics[key + "^^^均標"]; row["加權總分科低標"] = analytics[key + "^^^低標"]; row["加權總分科標準差"] = analytics[key + "^^^標準差"]; row["加權總分科組距count90"] = analytics[key + "^^^count90"]; row["加權總分科組距count80"] = analytics[key + "^^^count80"]; row["加權總分科組距count70"] = analytics[key + "^^^count70"]; row["加權總分科組距count60"] = analytics[key + "^^^count60"]; row["加權總分科組距count50"] = analytics[key + "^^^count50"]; row["加權總分科組距count40"] = analytics[key + "^^^count40"]; row["加權總分科組距count30"] = analytics[key + "^^^count30"]; row["加權總分科組距count20"] = analytics[key + "^^^count20"]; row["加權總分科組距count10"] = analytics[key + "^^^count10"]; row["加權總分科組距count100Up"] = analytics[key + "^^^count100Up"]; row["加權總分科組距count90Up"] = analytics[key + "^^^count90Up"]; row["加權總分科組距count80Up"] = analytics[key + "^^^count80Up"]; row["加權總分科組距count70Up"] = analytics[key + "^^^count70Up"]; row["加權總分科組距count60Up"] = analytics[key + "^^^count60Up"]; row["加權總分科組距count50Up"] = analytics[key + "^^^count50Up"]; row["加權總分科組距count40Up"] = analytics[key + "^^^count40Up"]; row["加權總分科組距count30Up"] = analytics[key + "^^^count30Up"]; row["加權總分科組距count20Up"] = analytics[key + "^^^count20Up"]; row["加權總分科組距count10Up"] = analytics[key + "^^^count10Up"]; row["加權總分科組距count90Down"] = analytics[key + "^^^count90Down"]; row["加權總分科組距count80Down"] = analytics[key + "^^^count80Down"]; row["加權總分科組距count70Down"] = analytics[key + "^^^count70Down"]; row["加權總分科組距count60Down"] = analytics[key + "^^^count60Down"]; row["加權總分科組距count50Down"] = analytics[key + "^^^count50Down"]; row["加權總分科組距count40Down"] = analytics[key + "^^^count40Down"]; row["加權總分科組距count30Down"] = analytics[key + "^^^count30Down"]; row["加權總分科組距count20Down"] = analytics[key + "^^^count20Down"]; row["加權總分科組距count10Down"] = analytics[key + "^^^count10Down"]; } key = "加權總分全校排名" + gradeYear; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["加權總分全校排名"] = ranks[key].IndexOf(studentPrintSubjectSumW[studentID]) + 1; row["加權總分全校排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["加權總分校高標"] = analytics[key + "^^^高標"]; row["加權總分校均標"] = analytics[key + "^^^均標"]; row["加權總分校低標"] = analytics[key + "^^^低標"]; row["加權總分校標準差"] = analytics[key + "^^^標準差"]; row["加權總分校組距count90"] = analytics[key + "^^^count90"]; row["加權總分校組距count80"] = analytics[key + "^^^count80"]; row["加權總分校組距count70"] = analytics[key + "^^^count70"]; row["加權總分校組距count60"] = analytics[key + "^^^count60"]; row["加權總分校組距count50"] = analytics[key + "^^^count50"]; row["加權總分校組距count40"] = analytics[key + "^^^count40"]; row["加權總分校組距count30"] = analytics[key + "^^^count30"]; row["加權總分校組距count20"] = analytics[key + "^^^count20"]; row["加權總分校組距count10"] = analytics[key + "^^^count10"]; row["加權總分校組距count100Up"] = analytics[key + "^^^count100Up"]; row["加權總分校組距count90Up"] = analytics[key + "^^^count90Up"]; row["加權總分校組距count80Up"] = analytics[key + "^^^count80Up"]; row["加權總分校組距count70Up"] = analytics[key + "^^^count70Up"]; row["加權總分校組距count60Up"] = analytics[key + "^^^count60Up"]; row["加權總分校組距count50Up"] = analytics[key + "^^^count50Up"]; row["加權總分校組距count40Up"] = analytics[key + "^^^count40Up"]; row["加權總分校組距count30Up"] = analytics[key + "^^^count30Up"]; row["加權總分校組距count20Up"] = analytics[key + "^^^count20Up"]; row["加權總分校組距count10Up"] = analytics[key + "^^^count10Up"]; row["加權總分校組距count90Down"] = analytics[key + "^^^count90Down"]; row["加權總分校組距count80Down"] = analytics[key + "^^^count80Down"]; row["加權總分校組距count70Down"] = analytics[key + "^^^count70Down"]; row["加權總分校組距count60Down"] = analytics[key + "^^^count60Down"]; row["加權總分校組距count50Down"] = analytics[key + "^^^count50Down"]; row["加權總分校組距count40Down"] = analytics[key + "^^^count40Down"]; row["加權總分校組距count30Down"] = analytics[key + "^^^count30Down"]; row["加權總分校組距count20Down"] = analytics[key + "^^^count20Down"]; row["加權總分校組距count10Down"] = analytics[key + "^^^count10Down"]; } } #endregion #region 加權平均 if (studentPrintSubjectAvgW.ContainsKey(studentID)) { row["加權平均"] = studentPrintSubjectAvgW[studentID]; key = "加權平均班排名" + stuRec.RefClass.ClassID; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["加權平均班排名"] = ranks[key].IndexOf(studentPrintSubjectAvgW[studentID]) + 1; row["加權平均班排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["加權平均班高標"] = analytics[key + "^^^高標"]; row["加權平均班均標"] = analytics[key + "^^^均標"]; row["加權平均班低標"] = analytics[key + "^^^低標"]; row["加權平均班標準差"] = analytics[key + "^^^標準差"]; row["加權平均班組距count90"] = analytics[key + "^^^count90"]; row["加權平均班組距count80"] = analytics[key + "^^^count80"]; row["加權平均班組距count70"] = analytics[key + "^^^count70"]; row["加權平均班組距count60"] = analytics[key + "^^^count60"]; row["加權平均班組距count50"] = analytics[key + "^^^count50"]; row["加權平均班組距count40"] = analytics[key + "^^^count40"]; row["加權平均班組距count30"] = analytics[key + "^^^count30"]; row["加權平均班組距count20"] = analytics[key + "^^^count20"]; row["加權平均班組距count10"] = analytics[key + "^^^count10"]; row["加權平均班組距count100Up"] = analytics[key + "^^^count100Up"]; row["加權平均班組距count90Up"] = analytics[key + "^^^count90Up"]; row["加權平均班組距count80Up"] = analytics[key + "^^^count80Up"]; row["加權平均班組距count70Up"] = analytics[key + "^^^count70Up"]; row["加權平均班組距count60Up"] = analytics[key + "^^^count60Up"]; row["加權平均班組距count50Up"] = analytics[key + "^^^count50Up"]; row["加權平均班組距count40Up"] = analytics[key + "^^^count40Up"]; row["加權平均班組距count30Up"] = analytics[key + "^^^count30Up"]; row["加權平均班組距count20Up"] = analytics[key + "^^^count20Up"]; row["加權平均班組距count10Up"] = analytics[key + "^^^count10Up"]; row["加權平均班組距count90Down"] = analytics[key + "^^^count90Down"]; row["加權平均班組距count80Down"] = analytics[key + "^^^count80Down"]; row["加權平均班組距count70Down"] = analytics[key + "^^^count70Down"]; row["加權平均班組距count60Down"] = analytics[key + "^^^count60Down"]; row["加權平均班組距count50Down"] = analytics[key + "^^^count50Down"]; row["加權平均班組距count40Down"] = analytics[key + "^^^count40Down"]; row["加權平均班組距count30Down"] = analytics[key + "^^^count30Down"]; row["加權平均班組距count20Down"] = analytics[key + "^^^count20Down"]; row["加權平均班組距count10Down"] = analytics[key + "^^^count10Down"]; } // 普通科 有分 自然組 或 社會組 classNatureSocietyStr = ""; if (stuRec.RefClass.ClassName.IndexOf("普") > -1) { classNatureSocietyStr = decideNatureSociety(stuRec.RefClass.ClassName); } key = "加權平均科排名" + stuRec.Department + classNatureSocietyStr + "^^^" + gradeYear; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["加權平均科排名"] = ranks[key].IndexOf(studentPrintSubjectAvgW[studentID]) + 1; row["加權平均科排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["加權平均科高標"] = analytics[key + "^^^高標"]; row["加權平均科均標"] = analytics[key + "^^^均標"]; row["加權平均科低標"] = analytics[key + "^^^低標"]; row["加權平均科標準差"] = analytics[key + "^^^標準差"]; row["加權平均科組距count90"] = analytics[key + "^^^count90"]; row["加權平均科組距count80"] = analytics[key + "^^^count80"]; row["加權平均科組距count70"] = analytics[key + "^^^count70"]; row["加權平均科組距count60"] = analytics[key + "^^^count60"]; row["加權平均科組距count50"] = analytics[key + "^^^count50"]; row["加權平均科組距count40"] = analytics[key + "^^^count40"]; row["加權平均科組距count30"] = analytics[key + "^^^count30"]; row["加權平均科組距count20"] = analytics[key + "^^^count20"]; row["加權平均科組距count10"] = analytics[key + "^^^count10"]; row["加權平均科組距count100Up"] = analytics[key + "^^^count100Up"]; row["加權平均科組距count90Up"] = analytics[key + "^^^count90Up"]; row["加權平均科組距count80Up"] = analytics[key + "^^^count80Up"]; row["加權平均科組距count70Up"] = analytics[key + "^^^count70Up"]; row["加權平均科組距count60Up"] = analytics[key + "^^^count60Up"]; row["加權平均科組距count50Up"] = analytics[key + "^^^count50Up"]; row["加權平均科組距count40Up"] = analytics[key + "^^^count40Up"]; row["加權平均科組距count30Up"] = analytics[key + "^^^count30Up"]; row["加權平均科組距count20Up"] = analytics[key + "^^^count20Up"]; row["加權平均科組距count10Up"] = analytics[key + "^^^count10Up"]; row["加權平均科組距count90Down"] = analytics[key + "^^^count90Down"]; row["加權平均科組距count80Down"] = analytics[key + "^^^count80Down"]; row["加權平均科組距count70Down"] = analytics[key + "^^^count70Down"]; row["加權平均科組距count60Down"] = analytics[key + "^^^count60Down"]; row["加權平均科組距count50Down"] = analytics[key + "^^^count50Down"]; row["加權平均科組距count40Down"] = analytics[key + "^^^count40Down"]; row["加權平均科組距count30Down"] = analytics[key + "^^^count30Down"]; row["加權平均科組距count20Down"] = analytics[key + "^^^count20Down"]; row["加權平均科組距count10Down"] = analytics[key + "^^^count10Down"]; } key = "加權平均全校排名" + gradeYear; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID))//明確判斷學生是否參與排名 { row["加權平均全校排名"] = ranks[key].IndexOf(studentPrintSubjectAvgW[studentID]) + 1; row["加權平均全校排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["加權平均校高標"] = analytics[key + "^^^高標"]; row["加權平均校均標"] = analytics[key + "^^^均標"]; row["加權平均校低標"] = analytics[key + "^^^低標"]; row["加權平均校標準差"] = analytics[key + "^^^標準差"]; row["加權平均校組距count90"] = analytics[key + "^^^count90"]; row["加權平均校組距count80"] = analytics[key + "^^^count80"]; row["加權平均校組距count70"] = analytics[key + "^^^count70"]; row["加權平均校組距count60"] = analytics[key + "^^^count60"]; row["加權平均校組距count50"] = analytics[key + "^^^count50"]; row["加權平均校組距count40"] = analytics[key + "^^^count40"]; row["加權平均校組距count30"] = analytics[key + "^^^count30"]; row["加權平均校組距count20"] = analytics[key + "^^^count20"]; row["加權平均校組距count10"] = analytics[key + "^^^count10"]; row["加權平均校組距count100Up"] = analytics[key + "^^^count100Up"]; row["加權平均校組距count90Up"] = analytics[key + "^^^count90Up"]; row["加權平均校組距count80Up"] = analytics[key + "^^^count80Up"]; row["加權平均校組距count70Up"] = analytics[key + "^^^count70Up"]; row["加權平均校組距count60Up"] = analytics[key + "^^^count60Up"]; row["加權平均校組距count50Up"] = analytics[key + "^^^count50Up"]; row["加權平均校組距count40Up"] = analytics[key + "^^^count40Up"]; row["加權平均校組距count30Up"] = analytics[key + "^^^count30Up"]; row["加權平均校組距count20Up"] = analytics[key + "^^^count20Up"]; row["加權平均校組距count10Up"] = analytics[key + "^^^count10Up"]; row["加權平均校組距count90Down"] = analytics[key + "^^^count90Down"]; row["加權平均校組距count80Down"] = analytics[key + "^^^count80Down"]; row["加權平均校組距count70Down"] = analytics[key + "^^^count70Down"]; row["加權平均校組距count60Down"] = analytics[key + "^^^count60Down"]; row["加權平均校組距count50Down"] = analytics[key + "^^^count50Down"]; row["加權平均校組距count40Down"] = analytics[key + "^^^count40Down"]; row["加權平均校組距count30Down"] = analytics[key + "^^^count30Down"]; row["加權平均校組距count20Down"] = analytics[key + "^^^count20Down"]; row["加權平均校組距count10Down"] = analytics[key + "^^^count10Down"]; } } #endregion // BMk 類別1綜合成績 #region 類別1綜合成績 if (studentTag1Group.ContainsKey(studentID)) { foreach (var tag in studentTags[studentID]) { if (tag.RefTagID == studentTag1Group[studentID]) { row["類別排名1"] = tag.Name; } } if (studentTag1SubjectSum.ContainsKey(studentID)) { //aaron if (tag1SubjectCreditSumList.ContainsKey(studentID)) { row["類別1所修學分"] = tag1SubjectCreditSumList[studentID]; } row["類別1總分"] = studentTag1SubjectSum[studentID]; key = "類別1總分排名" + "^^^" + gradeYear + "^^^" + studentTag1Group[studentID]; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID)) { row["類別1總分排名"] = ranks[key].IndexOf(studentTag1SubjectSum[studentID]) + 1; row["類別1總分排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類1總分高標"] = analytics[key + "^^^高標"]; row["類1總分均標"] = analytics[key + "^^^均標"]; row["類1總分低標"] = analytics[key + "^^^低標"]; row["類1總分標準差"] = analytics[key + "^^^標準差"]; row["類1總分組距count90"] = analytics[key + "^^^count90"]; row["類1總分組距count80"] = analytics[key + "^^^count80"]; row["類1總分組距count70"] = analytics[key + "^^^count70"]; row["類1總分組距count60"] = analytics[key + "^^^count60"]; row["類1總分組距count50"] = analytics[key + "^^^count50"]; row["類1總分組距count40"] = analytics[key + "^^^count40"]; row["類1總分組距count30"] = analytics[key + "^^^count30"]; row["類1總分組距count20"] = analytics[key + "^^^count20"]; row["類1總分組距count10"] = analytics[key + "^^^count10"]; row["類1總分組距count100Up"] = analytics[key + "^^^count100Up"]; row["類1總分組距count90Up"] = analytics[key + "^^^count90Up"]; row["類1總分組距count80Up"] = analytics[key + "^^^count80Up"]; row["類1總分組距count70Up"] = analytics[key + "^^^count70Up"]; row["類1總分組距count60Up"] = analytics[key + "^^^count60Up"]; row["類1總分組距count50Up"] = analytics[key + "^^^count50Up"]; row["類1總分組距count40Up"] = analytics[key + "^^^count40Up"]; row["類1總分組距count30Up"] = analytics[key + "^^^count30Up"]; row["類1總分組距count20Up"] = analytics[key + "^^^count20Up"]; row["類1總分組距count10Up"] = analytics[key + "^^^count10Up"]; row["類1總分組距count90Down"] = analytics[key + "^^^count90Down"]; row["類1總分組距count80Down"] = analytics[key + "^^^count80Down"]; row["類1總分組距count70Down"] = analytics[key + "^^^count70Down"]; row["類1總分組距count60Down"] = analytics[key + "^^^count60Down"]; row["類1總分組距count50Down"] = analytics[key + "^^^count50Down"]; row["類1總分組距count40Down"] = analytics[key + "^^^count40Down"]; row["類1總分組距count30Down"] = analytics[key + "^^^count30Down"]; row["類1總分組距count20Down"] = analytics[key + "^^^count20Down"]; row["類1總分組距count10Down"] = analytics[key + "^^^count10Down"]; } } if (studentTag1SubjectAvg.ContainsKey(studentID)) { row["類別1平均"] = studentTag1SubjectAvg[studentID]; key = "類別1平均排名" + "^^^" + gradeYear + "^^^" + studentTag1Group[studentID]; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID)) { row["類別1平均排名"] = ranks[key].IndexOf(studentTag1SubjectAvg[studentID]) + 1; ; row["類別1平均排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類1平均高標"] = analytics[key + "^^^高標"]; row["類1平均均標"] = analytics[key + "^^^均標"]; row["類1平均低標"] = analytics[key + "^^^低標"]; row["類1平均標準差"] = analytics[key + "^^^標準差"]; row["類1平均組距count90"] = analytics[key + "^^^count90"]; row["類1平均組距count80"] = analytics[key + "^^^count80"]; row["類1平均組距count70"] = analytics[key + "^^^count70"]; row["類1平均組距count60"] = analytics[key + "^^^count60"]; row["類1平均組距count50"] = analytics[key + "^^^count50"]; row["類1平均組距count40"] = analytics[key + "^^^count40"]; row["類1平均組距count30"] = analytics[key + "^^^count30"]; row["類1平均組距count20"] = analytics[key + "^^^count20"]; row["類1平均組距count10"] = analytics[key + "^^^count10"]; row["類1平均組距count100Up"] = analytics[key + "^^^count100Up"]; row["類1平均組距count90Up"] = analytics[key + "^^^count90Up"]; row["類1平均組距count80Up"] = analytics[key + "^^^count80Up"]; row["類1平均組距count70Up"] = analytics[key + "^^^count70Up"]; row["類1平均組距count60Up"] = analytics[key + "^^^count60Up"]; row["類1平均組距count50Up"] = analytics[key + "^^^count50Up"]; row["類1平均組距count40Up"] = analytics[key + "^^^count40Up"]; row["類1平均組距count30Up"] = analytics[key + "^^^count30Up"]; row["類1平均組距count20Up"] = analytics[key + "^^^count20Up"]; row["類1平均組距count10Up"] = analytics[key + "^^^count10Up"]; row["類1平均組距count90Down"] = analytics[key + "^^^count90Down"]; row["類1平均組距count80Down"] = analytics[key + "^^^count80Down"]; row["類1平均組距count70Down"] = analytics[key + "^^^count70Down"]; row["類1平均組距count60Down"] = analytics[key + "^^^count60Down"]; row["類1平均組距count50Down"] = analytics[key + "^^^count50Down"]; row["類1平均組距count40Down"] = analytics[key + "^^^count40Down"]; row["類1平均組距count30Down"] = analytics[key + "^^^count30Down"]; row["類1平均組距count20Down"] = analytics[key + "^^^count20Down"]; row["類1平均組距count10Down"] = analytics[key + "^^^count10Down"]; } } if (studentTag1SubjectSumW.ContainsKey(studentID)) { row["類別1加權總分"] = studentTag1SubjectSumW[studentID]; key = "類別1加權總分排名" + "^^^" + gradeYear + "^^^" + studentTag1Group[studentID]; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID)) { row["類別1加權總分排名"] = ranks[key].IndexOf(studentTag1SubjectSumW[studentID]) + 1; ; row["類別1加權總分排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類1加權總分高標"] = analytics[key + "^^^高標"]; row["類1加權總分均標"] = analytics[key + "^^^均標"]; row["類1加權總分低標"] = analytics[key + "^^^低標"]; row["類1加權總分標準差"] = analytics[key + "^^^標準差"]; row["類1加權總分組距count90"] = analytics[key + "^^^count90"]; row["類1加權總分組距count80"] = analytics[key + "^^^count80"]; row["類1加權總分組距count70"] = analytics[key + "^^^count70"]; row["類1加權總分組距count60"] = analytics[key + "^^^count60"]; row["類1加權總分組距count50"] = analytics[key + "^^^count50"]; row["類1加權總分組距count40"] = analytics[key + "^^^count40"]; row["類1加權總分組距count30"] = analytics[key + "^^^count30"]; row["類1加權總分組距count20"] = analytics[key + "^^^count20"]; row["類1加權總分組距count10"] = analytics[key + "^^^count10"]; row["類1加權總分組距count100Up"] = analytics[key + "^^^count100Up"]; row["類1加權總分組距count90Up"] = analytics[key + "^^^count90Up"]; row["類1加權總分組距count80Up"] = analytics[key + "^^^count80Up"]; row["類1加權總分組距count70Up"] = analytics[key + "^^^count70Up"]; row["類1加權總分組距count60Up"] = analytics[key + "^^^count60Up"]; row["類1加權總分組距count50Up"] = analytics[key + "^^^count50Up"]; row["類1加權總分組距count40Up"] = analytics[key + "^^^count40Up"]; row["類1加權總分組距count30Up"] = analytics[key + "^^^count30Up"]; row["類1加權總分組距count20Up"] = analytics[key + "^^^count20Up"]; row["類1加權總分組距count10Up"] = analytics[key + "^^^count10Up"]; row["類1加權總分組距count90Down"] = analytics[key + "^^^count90Down"]; row["類1加權總分組距count80Down"] = analytics[key + "^^^count80Down"]; row["類1加權總分組距count70Down"] = analytics[key + "^^^count70Down"]; row["類1加權總分組距count60Down"] = analytics[key + "^^^count60Down"]; row["類1加權總分組距count50Down"] = analytics[key + "^^^count50Down"]; row["類1加權總分組距count40Down"] = analytics[key + "^^^count40Down"]; row["類1加權總分組距count30Down"] = analytics[key + "^^^count30Down"]; row["類1加權總分組距count20Down"] = analytics[key + "^^^count20Down"]; row["類1加權總分組距count10Down"] = analytics[key + "^^^count10Down"]; } } if (studentTag1SubjectAvgW.ContainsKey(studentID)) { row["類別1加權平均"] = studentTag1SubjectAvgW[studentID]; key = "類別1加權平均排名" + "^^^" + gradeYear + "^^^" + studentTag1Group[studentID]; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID)) { row["類別1加權平均排名"] = ranks[key].IndexOf(studentTag1SubjectAvgW[studentID]) + 1; ; row["類別1加權平均排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類1加權平均高標"] = analytics[key + "^^^高標"]; row["類1加權平均均標"] = analytics[key + "^^^均標"]; row["類1加權平均低標"] = analytics[key + "^^^低標"]; row["類1加權平均標準差"] = analytics[key + "^^^標準差"]; row["類1加權平均組距count90"] = analytics[key + "^^^count90"]; row["類1加權平均組距count80"] = analytics[key + "^^^count80"]; row["類1加權平均組距count70"] = analytics[key + "^^^count70"]; row["類1加權平均組距count60"] = analytics[key + "^^^count60"]; row["類1加權平均組距count50"] = analytics[key + "^^^count50"]; row["類1加權平均組距count40"] = analytics[key + "^^^count40"]; row["類1加權平均組距count30"] = analytics[key + "^^^count30"]; row["類1加權平均組距count20"] = analytics[key + "^^^count20"]; row["類1加權平均組距count10"] = analytics[key + "^^^count10"]; row["類1加權平均組距count100Up"] = analytics[key + "^^^count100Up"]; row["類1加權平均組距count90Up"] = analytics[key + "^^^count90Up"]; row["類1加權平均組距count80Up"] = analytics[key + "^^^count80Up"]; row["類1加權平均組距count70Up"] = analytics[key + "^^^count70Up"]; row["類1加權平均組距count60Up"] = analytics[key + "^^^count60Up"]; row["類1加權平均組距count50Up"] = analytics[key + "^^^count50Up"]; row["類1加權平均組距count40Up"] = analytics[key + "^^^count40Up"]; row["類1加權平均組距count30Up"] = analytics[key + "^^^count30Up"]; row["類1加權平均組距count20Up"] = analytics[key + "^^^count20Up"]; row["類1加權平均組距count10Up"] = analytics[key + "^^^count10Up"]; row["類1加權平均組距count90Down"] = analytics[key + "^^^count90Down"]; row["類1加權平均組距count80Down"] = analytics[key + "^^^count80Down"]; row["類1加權平均組距count70Down"] = analytics[key + "^^^count70Down"]; row["類1加權平均組距count60Down"] = analytics[key + "^^^count60Down"]; row["類1加權平均組距count50Down"] = analytics[key + "^^^count50Down"]; row["類1加權平均組距count40Down"] = analytics[key + "^^^count40Down"]; row["類1加權平均組距count30Down"] = analytics[key + "^^^count30Down"]; row["類1加權平均組距count20Down"] = analytics[key + "^^^count20Down"]; row["類1加權平均組距count10Down"] = analytics[key + "^^^count10Down"]; } } } #endregion #region 類別2綜合成績 if (studentTag2Group.ContainsKey(studentID)) { foreach (var tag in studentTags[studentID]) { if (tag.RefTagID == studentTag2Group[studentID]) { row["類別排名2"] = tag.Name; } } if (studentTag2SubjectSum.ContainsKey(studentID)) { row["類別2總分"] = studentTag2SubjectSum[studentID]; key = "類別2總分排名" + "^^^" + gradeYear + "^^^" + studentTag2Group[studentID]; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID)) { row["類別2總分排名"] = ranks[key].IndexOf(studentTag2SubjectSum[studentID]) + 1; row["類別2總分排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類2總分高標"] = analytics[key + "^^^高標"]; row["類2總分均標"] = analytics[key + "^^^均標"]; row["類2總分低標"] = analytics[key + "^^^低標"]; row["類2總分標準差"] = analytics[key + "^^^標準差"]; row["類2總分組距count90"] = analytics[key + "^^^count90"]; row["類2總分組距count80"] = analytics[key + "^^^count80"]; row["類2總分組距count70"] = analytics[key + "^^^count70"]; row["類2總分組距count60"] = analytics[key + "^^^count60"]; row["類2總分組距count50"] = analytics[key + "^^^count50"]; row["類2總分組距count40"] = analytics[key + "^^^count40"]; row["類2總分組距count30"] = analytics[key + "^^^count30"]; row["類2總分組距count20"] = analytics[key + "^^^count20"]; row["類2總分組距count10"] = analytics[key + "^^^count10"]; row["類2總分組距count100Up"] = analytics[key + "^^^count100Up"]; row["類2總分組距count90Up"] = analytics[key + "^^^count90Up"]; row["類2總分組距count80Up"] = analytics[key + "^^^count80Up"]; row["類2總分組距count70Up"] = analytics[key + "^^^count70Up"]; row["類2總分組距count60Up"] = analytics[key + "^^^count60Up"]; row["類2總分組距count50Up"] = analytics[key + "^^^count50Up"]; row["類2總分組距count40Up"] = analytics[key + "^^^count40Up"]; row["類2總分組距count30Up"] = analytics[key + "^^^count30Up"]; row["類2總分組距count20Up"] = analytics[key + "^^^count20Up"]; row["類2總分組距count10Up"] = analytics[key + "^^^count10Up"]; row["類2總分組距count90Down"] = analytics[key + "^^^count90Down"]; row["類2總分組距count80Down"] = analytics[key + "^^^count80Down"]; row["類2總分組距count70Down"] = analytics[key + "^^^count70Down"]; row["類2總分組距count60Down"] = analytics[key + "^^^count60Down"]; row["類2總分組距count50Down"] = analytics[key + "^^^count50Down"]; row["類2總分組距count40Down"] = analytics[key + "^^^count40Down"]; row["類2總分組距count30Down"] = analytics[key + "^^^count30Down"]; row["類2總分組距count20Down"] = analytics[key + "^^^count20Down"]; row["類2總分組距count10Down"] = analytics[key + "^^^count10Down"]; } } if (studentTag2SubjectAvg.ContainsKey(studentID)) { row["類別2平均"] = studentTag2SubjectAvg[studentID]; key = "類別2平均排名" + "^^^" + gradeYear + "^^^" + studentTag2Group[studentID]; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID)) { row["類別2平均排名"] = ranks[key].IndexOf(studentTag2SubjectAvg[studentID]) + 1; ; row["類別2平均排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類2平均高標"] = analytics[key + "^^^高標"]; row["類2平均均標"] = analytics[key + "^^^均標"]; row["類2平均低標"] = analytics[key + "^^^低標"]; row["類2平均標準差"] = analytics[key + "^^^標準差"]; row["類2平均組距count90"] = analytics[key + "^^^count90"]; row["類2平均組距count80"] = analytics[key + "^^^count80"]; row["類2平均組距count70"] = analytics[key + "^^^count70"]; row["類2平均組距count60"] = analytics[key + "^^^count60"]; row["類2平均組距count50"] = analytics[key + "^^^count50"]; row["類2平均組距count40"] = analytics[key + "^^^count40"]; row["類2平均組距count30"] = analytics[key + "^^^count30"]; row["類2平均組距count20"] = analytics[key + "^^^count20"]; row["類2平均組距count10"] = analytics[key + "^^^count10"]; row["類2平均組距count100Up"] = analytics[key + "^^^count100Up"]; row["類2平均組距count90Up"] = analytics[key + "^^^count90Up"]; row["類2平均組距count80Up"] = analytics[key + "^^^count80Up"]; row["類2平均組距count70Up"] = analytics[key + "^^^count70Up"]; row["類2平均組距count60Up"] = analytics[key + "^^^count60Up"]; row["類2平均組距count50Up"] = analytics[key + "^^^count50Up"]; row["類2平均組距count40Up"] = analytics[key + "^^^count40Up"]; row["類2平均組距count30Up"] = analytics[key + "^^^count30Up"]; row["類2平均組距count20Up"] = analytics[key + "^^^count20Up"]; row["類2平均組距count10Up"] = analytics[key + "^^^count10Up"]; row["類2平均組距count90Down"] = analytics[key + "^^^count90Down"]; row["類2平均組距count80Down"] = analytics[key + "^^^count80Down"]; row["類2平均組距count70Down"] = analytics[key + "^^^count70Down"]; row["類2平均組距count60Down"] = analytics[key + "^^^count60Down"]; row["類2平均組距count50Down"] = analytics[key + "^^^count50Down"]; row["類2平均組距count40Down"] = analytics[key + "^^^count40Down"]; row["類2平均組距count30Down"] = analytics[key + "^^^count30Down"]; row["類2平均組距count20Down"] = analytics[key + "^^^count20Down"]; row["類2平均組距count10Down"] = analytics[key + "^^^count10Down"]; } } if (studentTag2SubjectSumW.ContainsKey(studentID)) { row["類別2加權總分"] = studentTag2SubjectSumW[studentID]; key = "類別2加權總分排名" + "^^^" + gradeYear + "^^^" + studentTag2Group[studentID]; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID)) { row["類別2加權總分排名"] = ranks[key].IndexOf(studentTag2SubjectSumW[studentID]) + 1; ; row["類別2加權總分排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類2加權總分高標"] = analytics[key + "^^^高標"]; row["類2加權總分均標"] = analytics[key + "^^^均標"]; row["類2加權總分低標"] = analytics[key + "^^^低標"]; row["類2加權總分標準差"] = analytics[key + "^^^標準差"]; row["類2加權總分組距count90"] = analytics[key + "^^^count90"]; row["類2加權總分組距count80"] = analytics[key + "^^^count80"]; row["類2加權總分組距count70"] = analytics[key + "^^^count70"]; row["類2加權總分組距count60"] = analytics[key + "^^^count60"]; row["類2加權總分組距count50"] = analytics[key + "^^^count50"]; row["類2加權總分組距count40"] = analytics[key + "^^^count40"]; row["類2加權總分組距count30"] = analytics[key + "^^^count30"]; row["類2加權總分組距count20"] = analytics[key + "^^^count20"]; row["類2加權總分組距count10"] = analytics[key + "^^^count10"]; row["類2加權總分組距count100Up"] = analytics[key + "^^^count100Up"]; row["類2加權總分組距count90Up"] = analytics[key + "^^^count90Up"]; row["類2加權總分組距count80Up"] = analytics[key + "^^^count80Up"]; row["類2加權總分組距count70Up"] = analytics[key + "^^^count70Up"]; row["類2加權總分組距count60Up"] = analytics[key + "^^^count60Up"]; row["類2加權總分組距count50Up"] = analytics[key + "^^^count50Up"]; row["類2加權總分組距count40Up"] = analytics[key + "^^^count40Up"]; row["類2加權總分組距count30Up"] = analytics[key + "^^^count30Up"]; row["類2加權總分組距count20Up"] = analytics[key + "^^^count20Up"]; row["類2加權總分組距count10Up"] = analytics[key + "^^^count10Up"]; row["類2加權總分組距count90Down"] = analytics[key + "^^^count90Down"]; row["類2加權總分組距count80Down"] = analytics[key + "^^^count80Down"]; row["類2加權總分組距count70Down"] = analytics[key + "^^^count70Down"]; row["類2加權總分組距count60Down"] = analytics[key + "^^^count60Down"]; row["類2加權總分組距count50Down"] = analytics[key + "^^^count50Down"]; row["類2加權總分組距count40Down"] = analytics[key + "^^^count40Down"]; row["類2加權總分組距count30Down"] = analytics[key + "^^^count30Down"]; row["類2加權總分組距count20Down"] = analytics[key + "^^^count20Down"]; row["類2加權總分組距count10Down"] = analytics[key + "^^^count10Down"]; } } if (studentTag2SubjectAvgW.ContainsKey(studentID)) { row["類別2加權平均"] = studentTag2SubjectAvgW[studentID]; key = "類別2加權平均排名" + "^^^" + gradeYear + "^^^" + studentTag2Group[studentID]; if (rankStudents.ContainsKey(key) && rankStudents[key].Contains(studentID)) { row["類別2加權平均排名"] = ranks[key].IndexOf(studentTag2SubjectAvgW[studentID]) + 1; ; row["類別2加權平均排名母數"] = ranks[key].Count; } if (rankStudents.ContainsKey(key)) { row["類2加權平均高標"] = analytics[key + "^^^高標"]; row["類2加權平均均標"] = analytics[key + "^^^均標"]; row["類2加權平均低標"] = analytics[key + "^^^低標"]; row["類2加權平均標準差"] = analytics[key + "^^^標準差"]; row["類2加權平均組距count90"] = analytics[key + "^^^count90"]; row["類2加權平均組距count80"] = analytics[key + "^^^count80"]; row["類2加權平均組距count70"] = analytics[key + "^^^count70"]; row["類2加權平均組距count60"] = analytics[key + "^^^count60"]; row["類2加權平均組距count50"] = analytics[key + "^^^count50"]; row["類2加權平均組距count40"] = analytics[key + "^^^count40"]; row["類2加權平均組距count30"] = analytics[key + "^^^count30"]; row["類2加權平均組距count20"] = analytics[key + "^^^count20"]; row["類2加權平均組距count10"] = analytics[key + "^^^count10"]; row["類2加權平均組距count100Up"] = analytics[key + "^^^count100Up"]; row["類2加權平均組距count90Up"] = analytics[key + "^^^count90Up"]; row["類2加權平均組距count80Up"] = analytics[key + "^^^count80Up"]; row["類2加權平均組距count70Up"] = analytics[key + "^^^count70Up"]; row["類2加權平均組距count60Up"] = analytics[key + "^^^count60Up"]; row["類2加權平均組距count50Up"] = analytics[key + "^^^count50Up"]; row["類2加權平均組距count40Up"] = analytics[key + "^^^count40Up"]; row["類2加權平均組距count30Up"] = analytics[key + "^^^count30Up"]; row["類2加權平均組距count20Up"] = analytics[key + "^^^count20Up"]; row["類2加權平均組距count10Up"] = analytics[key + "^^^count10Up"]; row["類2加權平均組距count90Down"] = analytics[key + "^^^count90Down"]; row["類2加權平均組距count80Down"] = analytics[key + "^^^count80Down"]; row["類2加權平均組距count70Down"] = analytics[key + "^^^count70Down"]; row["類2加權平均組距count60Down"] = analytics[key + "^^^count60Down"]; row["類2加權平均組距count50Down"] = analytics[key + "^^^count50Down"]; row["類2加權平均組距count40Down"] = analytics[key + "^^^count40Down"]; row["類2加權平均組距count30Down"] = analytics[key + "^^^count30Down"]; row["類2加權平均組距count20Down"] = analytics[key + "^^^count20Down"]; row["類2加權平均組距count10Down"] = analytics[key + "^^^count10Down"]; } } } #endregion #endregion #region 學務資料 #region 獎懲統計 int 大功 = 0; int 小功 = 0; int 嘉獎 = 0; int 大過 = 0; int 小過 = 0; int 警告 = 0; bool 留校察看 = false; foreach (RewardInfo info in stuRec.RewardList) { if (("" + info.Semester) == conf.Semester && ("" + info.SchoolYear) == conf.SchoolYear) { 大功 += info.AwardA; 小功 += info.AwardB; 嘉獎 += info.AwardC; if (!info.Cleared) { 大過 += info.FaultA; 小過 += info.FaultB; 警告 += info.FaultC; } if (info.UltimateAdmonition) 留校察看 = true; } } row["大功統計"] = 大功 == 0 ? "" : ("" + 大功); row["小功統計"] = 小功 == 0 ? "" : ("" + 小功); row["嘉獎統計"] = 嘉獎 == 0 ? "" : ("" + 嘉獎); row["大過統計"] = 大過 == 0 ? "" : ("" + 大過); row["小過統計"] = 小過 == 0 ? "" : ("" + 小過); row["警告統計"] = 警告 == 0 ? "" : ("" + 警告); row["留校察看"] = 留校察看 ? "是" : ""; #endregion #region 缺曠統計 Dictionary<string, int> 缺曠項目統計 = new Dictionary<string, int>(); foreach (AttendanceInfo info in stuRec.AttendanceList) { if (("" + info.Semester) == conf.Semester && ("" + info.SchoolYear) == conf.SchoolYear) { string infoType = ""; if (dicPeriodMappingType.ContainsKey(info.Period)) infoType = dicPeriodMappingType[info.Period]; else infoType = ""; string attendanceKey = "" + infoType + "_" + info.Absence; if (!缺曠項目統計.ContainsKey(attendanceKey)) 缺曠項目統計.Add(attendanceKey, 0); 缺曠項目統計[attendanceKey]++; } } foreach (string attendanceKey in 缺曠項目統計.Keys) { row[attendanceKey] = 缺曠項目統計[attendanceKey] == 0 ? "" : ("" + 缺曠項目統計[attendanceKey]); } #endregion #endregion table.Rows.Add(row); progressCount++; bkw.ReportProgress(70 + progressCount * 20 / selectedStudents.Count); }// 頁面所選的學生 #endregion bkw.ReportProgress(90); document = conf.Template; document.MailMerge.Execute(table); } catch (Exception exception) { exc = exception; } };//DoWork bkw.RunWorkerAsync(); } }