/// <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();
}
}
