private void BgWorkerExport_DoWork(object sender, DoWorkEventArgs e)
{
bgWorkerExport.ReportProgress(1);
try
{
// 取得預設樣板
Workbook wb = new Workbook(new MemoryStream(Properties.Resources.Template));
Worksheet wst = wb.Worksheets[0];
// 取得學生基本資料
List <StudentInfo> StudentInfoList = QueryData.GetStudentInfoList3();
List <string> StudentIDList = new List <string>();
foreach (StudentInfo si in StudentInfoList)
{
StudentIDList.Add(si.StudentID);
}
// 取得地址資訊
Dictionary <string, JHAddressRecord> AddressDict = new Dictionary <string, JHAddressRecord>();
List <JHAddressRecord> tmpAddress = JHAddress.SelectByStudentIDs(StudentIDList);
foreach (JHAddressRecord rec in tmpAddress)
{
if (!AddressDict.ContainsKey(rec.RefStudentID))
{
AddressDict.Add(rec.RefStudentID, rec);
}
}
// 取得電話資料
Dictionary <string, JHPhoneRecord> PhoneDict = new Dictionary <string, JHPhoneRecord>();
List <JHPhoneRecord> tmpPhone = JHPhone.SelectByStudentIDs(StudentIDList);
foreach (JHPhoneRecord rec in tmpPhone)
{
if (!PhoneDict.ContainsKey(rec.RefStudentID))
{
PhoneDict.Add(rec.RefStudentID, rec);
}
}
bgWorkerExport.ReportProgress(20);
// 取得監護人父母資訊
Dictionary <string, JHParentRecord> ParentDict = new Dictionary <string, JHParentRecord>();
List <JHParentRecord> tmpParent = JHParent.SelectByStudentIDs(StudentIDList);
foreach (JHParentRecord rec in tmpParent)
{
if (!ParentDict.ContainsKey(rec.RefStudentID))
{
ParentDict.Add(rec.RefStudentID, rec);
}
}
// 轉換各項類別對照值
Dictionary <string, string> MappingTag1 = new Dictionary <string, string>();
Dictionary <string, string> MappingTag2 = new Dictionary <string, string>();
Dictionary <string, string> MappingTag3 = new Dictionary <string, string>();
Dictionary <string, string> MappingTag4 = new Dictionary <string, string>();
// 取得學生類別
Dictionary <string, List <string> > StudentTagDict = QueryData.GetStudentTagName(StudentIDList);
// 解析對照設定
XElement elmRoot = XElement.Parse(_Configure.MappingContent);
if (elmRoot != null)
{
foreach (XElement elm in elmRoot.Elements("Group"))
{
string gpName = elm.Attribute("Name").Value;
if (gpName == "學生身分")
{
foreach (XElement elm1 in elm.Elements("Item"))
{
string tagName = elm1.Attribute("TagName").Value;
if (!MappingTag1.ContainsKey(tagName) && tagName.Length > 0)
{
MappingTag1.Add(tagName, elm1.Attribute("Code").Value);
}
}
}
if (gpName == "身心障礙")
{
foreach (XElement elm1 in elm.Elements("Item"))
{
string tagName = elm1.Attribute("TagName").Value;
if (!MappingTag2.ContainsKey(tagName) && tagName.Length > 0)
{
MappingTag2.Add(tagName, elm1.Attribute("Code").Value);
}
}
}
if (gpName == "學生報名身分設定")
{
foreach (XElement elm1 in elm.Elements("Item"))
{
string tagName = elm1.Attribute("TagName").Value;
if (!MappingTag3.ContainsKey(tagName) && tagName.Length > 0)
{
MappingTag3.Add(tagName, elm1.Attribute("Code").Value);
}
}
}
if (gpName == "失業勞工子女")
{
foreach (XElement elm1 in elm.Elements("Item"))
{
string tagName = elm1.Attribute("TagName").Value;
if (!MappingTag4.ContainsKey(tagName) && tagName.Length > 0)
{
MappingTag4.Add(tagName, elm1.Attribute("Code").Value);
}
}
}
}
}
bgWorkerExport.ReportProgress(40);
// 取得成績相關資料
Dictionary <string, List <JHSemesterScoreRecord> > SemesterScoreRecordDict = new Dictionary <string, List <JHSemesterScoreRecord> >();
List <JHSemesterScoreRecord> tmpSemsScore = JHSemesterScore.SelectByStudentIDs(StudentIDList);
foreach (JHSemesterScoreRecord rec in tmpSemsScore)
{
if (!SemesterScoreRecordDict.ContainsKey(rec.RefStudentID))
{
SemesterScoreRecordDict.Add(rec.RefStudentID, new List <JHSemesterScoreRecord>());
}
SemesterScoreRecordDict[rec.RefStudentID].Add(rec);
}
// 取得功過紀錄
// 功過對照表
JHMeritDemeritReduceRecord DemeritReduceRecord = JHMeritDemeritReduce.Select();
// 懲
Dictionary <string, List <JHDemeritRecord> > DemeritRecordDict = new Dictionary <string, List <JHDemeritRecord> >();
List <JHDemeritRecord> tmpDemeritRecord = JHDemerit.SelectByStudentIDs(StudentIDList);
foreach (JHDemeritRecord rec in tmpDemeritRecord)
{
if (rec.Cleared == "是")
{
continue;
}
if (rec.OccurDate > _Configure.EndDate)
{
continue;
}
else
{
if (!DemeritRecordDict.ContainsKey(rec.RefStudentID))
{
DemeritRecordDict.Add(rec.RefStudentID, new List <JHDemeritRecord>());
}
DemeritRecordDict[rec.RefStudentID].Add(rec);
}
}
// 獎
Dictionary <string, List <JHMeritRecord> > MeritRecordDict = new Dictionary <string, List <JHMeritRecord> >();
List <JHMeritRecord> tmpMeritRecord = JHMerit.SelectByStudentIDs(StudentIDList);
foreach (JHMeritRecord rec in tmpMeritRecord)
{
if (rec.OccurDate > _Configure.EndDate)
{
continue;
}
else
{
if (!MeritRecordDict.ContainsKey(rec.RefStudentID))
{
MeritRecordDict.Add(rec.RefStudentID, new List <JHMeritRecord>());
}
MeritRecordDict[rec.RefStudentID].Add(rec);
}
}
// 取得服務學習時數
StudentInfoList = QueryData.FillServiceLearn(StudentIDList, StudentInfoList, _Configure.EndDate);
// 填入中低收入戶
StudentInfoList = QueryData.FillIncomeType(StudentIDList, StudentInfoList);
// 取得學生體適能資料並填入,嘉義版不卡日期，日期傳入不會限制
StudentInfoList = QueryData.FillStudentFitness(StudentIDList, StudentInfoList, _Configure.EndDate);
// 取得競賽總積分並填入學生資料
StudentInfoList = QueryData.FillStudentCompetitionPerformanceSum(StudentIDList, StudentInfoList);
// 填入 Excel 資料
int wstRIdx = 1;
bgWorkerExport.ReportProgress(70);
foreach (StudentInfo si in StudentInfoList)
{
// 考區代碼 0,嘉義區 10
wst.Cells[wstRIdx, 0].PutValue(10);
// 集報單位代碼 1
wst.Cells[wstRIdx, 1].PutValue(K12.Data.School.Code);
// 序號 2
wst.Cells[wstRIdx, 2].PutValue(wstRIdx);
// 學號 3
wst.Cells[wstRIdx, 3].PutValue(si.StudentNumber);
// 班級 4
wst.Cells[wstRIdx, 4].PutValue(si.ClassName);
// 座號 5
wst.Cells[wstRIdx, 5].PutValue(si.SeatNo);
// 學生姓名 6 // 2021-12-27 有些學校會為了整齊把學生的名字+空白，這裡濾掉
wst.Cells[wstRIdx, 6].PutValue(si.StudentName.Replace(" ", "").Replace(" ", ""));
// 身分證統一編號 7
wst.Cells[wstRIdx, 7].PutValue(si.IDNumber);
// 非中華民國身分證號 8
if (si.isTaiwanID)
{
wst.Cells[wstRIdx, 8].PutValue("");
}
else
{
wst.Cells[wstRIdx, 8].PutValue("V");
}
// 性別 9
wst.Cells[wstRIdx, 9].PutValue(si.GenderCode);
// 出生年(民國年) 10
wst.Cells[wstRIdx, 10].PutValue(si.BirthYear);
// 出生月 11
wst.Cells[wstRIdx, 11].PutValue(si.BirthMonth);
// 出生日 12
wst.Cells[wstRIdx, 12].PutValue(si.BirthDay);
// 畢業學校代碼 13
wst.Cells[wstRIdx, 13].PutValue(K12.Data.School.Code);
// 畢業年(民國年) 14
int gyear;
if (int.TryParse(K12.Data.School.DefaultSchoolYear, out gyear))
{
wst.Cells[wstRIdx, 14].PutValue(gyear + 1);
}
// 畢肄業 15
wst.Cells[wstRIdx, 15].PutValue(1);
wst.Cells[wstRIdx, 16].PutValue(0);
wst.Cells[wstRIdx, 17].PutValue(0);
wst.Cells[wstRIdx, 18].PutValue(0);
wst.Cells[wstRIdx, 22].PutValue(0);
if (StudentTagDict.ContainsKey(si.StudentID))
{
foreach (string tagName in StudentTagDict[si.StudentID])
{
if (MappingTag1.ContainsKey(tagName))
{
// 學生身分 16
wst.Cells[wstRIdx, 16].PutValue(MappingTag1[tagName]);
}
if (MappingTag2.ContainsKey(tagName))
{
si.isSpecial = true;
// 身心障礙 18
wst.Cells[wstRIdx, 18].PutValue(MappingTag2[tagName]);
}
if (MappingTag3.ContainsKey(tagName))
{
// 學生報名身分 17
wst.Cells[wstRIdx, 17].PutValue(MappingTag3[tagName]);
}
if (MappingTag4.ContainsKey(tagName))
{
// 失業勞工子女 22
wst.Cells[wstRIdx, 22].PutValue(MappingTag4[tagName]);
}
}
}
// 就學區 19,不處理
// 低收入戶 20
if (si.incomeType1)
{
wst.Cells[wstRIdx, 20].PutValue(1);
}
else
{
wst.Cells[wstRIdx, 20].PutValue(0);
}
// 中低收入戶 21
if (si.incomeType2)
{
wst.Cells[wstRIdx, 21].PutValue(1);
}
else
{
wst.Cells[wstRIdx, 21].PutValue(0);
}
// 資料授權 23
wst.Cells[wstRIdx, 23].PutValue(0);
string parentName = "";
// 家長姓名 24
if (ParentDict.ContainsKey(si.StudentID))
{
if (!string.IsNullOrWhiteSpace(ParentDict[si.StudentID].CustodianName))
{
parentName = ParentDict[si.StudentID].CustodianName;
}
else if (!string.IsNullOrWhiteSpace(ParentDict[si.StudentID].FatherName))
{
parentName = ParentDict[si.StudentID].FatherName;
}
else if (!string.IsNullOrWhiteSpace(ParentDict[si.StudentID].MotherName))
{
parentName = ParentDict[si.StudentID].MotherName;
}
else
{
}
wst.Cells[wstRIdx, 24].PutValue(parentName);
}
// 市內電話 25
// 市內電話分機 26
// 行動電話 27
if (PhoneDict.ContainsKey(si.StudentID))
{
wst.Cells[wstRIdx, 25].PutValue(PhoneDict[si.StudentID].Contact.Replace("-", "").Replace(")", "").Replace("(", ""));
wst.Cells[wstRIdx, 27].PutValue(PhoneDict[si.StudentID].Cell.Replace("-", "").Replace(")", "").Replace("(", ""));
}
// 郵遞區號 28
if (AddressDict.ContainsKey(si.StudentID))
{
if (AddressDict[si.StudentID].MailingZipCode != null)
{
string zipCode = AddressDict[si.StudentID].MailingZipCode;
if (zipCode.Length >= 3)
{
zipCode = zipCode.Substring(0, 3);
}
wst.Cells[wstRIdx, 28].PutValue(zipCode);
}
// 通訊地址 29
wst.Cells[wstRIdx, 29].PutValue(AddressDict[si.StudentID].MailingCounty + AddressDict[si.StudentID].MailingTown + AddressDict[si.StudentID].MailingDistrict + AddressDict[si.StudentID].MailingArea + AddressDict[si.StudentID].MailingDetail);
}
// 計算分數
if (SemesterScoreRecordDict.ContainsKey(si.StudentID))
{
si.CalcSemsScore5(SemesterScoreRecordDict[si.StudentID]);
}
// 健康與體育 30
if (si.isDomainHelPass)
{
wst.Cells[wstRIdx, 30].PutValue(1);
}
else
{
wst.Cells[wstRIdx, 30].PutValue(0);
}
// 藝術 31
if (si.isDoaminArtPass)
{
wst.Cells[wstRIdx, 31].PutValue(1);
}
else
{
wst.Cells[wstRIdx, 31].PutValue(0);
}
// 綜合活動 32
if (si.isDomainActPass)
{
wst.Cells[wstRIdx, 32].PutValue(1);
}
else
{
wst.Cells[wstRIdx, 32].PutValue(0);
}
// 品德表現 33
List <JHDemeritRecord> recD;
List <JHMeritRecord> recM;
if (DemeritRecordDict.ContainsKey(si.StudentID))
{
recD = DemeritRecordDict[si.StudentID];
}
else
{
recD = new List <JHDemeritRecord>();
}
if (MeritRecordDict.ContainsKey(si.StudentID))
{
recM = MeritRecordDict[si.StudentID];
}
else
{
recM = new List <JHMeritRecord>();
}
si.CalcDemeritMemeritScore(recD, recM, DemeritReduceRecord);
wst.Cells[wstRIdx, 33].PutValue(si.MeritDemeritScore);
// 服務學習 34
wst.Cells[wstRIdx, 34].PutValue(si.ServiceLearnScore);
// 體適能 35
si.CalcFitnessScore();
wst.Cells[wstRIdx, 35].PutValue(si.FitnessScore);
// 競賽表現 36,使用者自行處理
if (si.CompPerfSum.HasValue)
{
wst.Cells[wstRIdx, 36].PutValue(si.CompPerfSum.Value);
}
else // 2021-12-27 嘉義協同國中 見安老師要求預設值 0
{
wst.Cells[wstRIdx, 36].PutValue("0");
}
// 2021-12-27 嘉義協同國中 見安老師要求預設值全部填1
// https://3.basecamp.com/4399967/buckets/15765350/todos/4475736499#__recording_4477516175
// 家長意見_高中 37
wst.Cells[wstRIdx, 37].PutValue("1");
// 家長意見_高職 38
wst.Cells[wstRIdx, 38].PutValue("1");
// 導師意見_高中 39
wst.Cells[wstRIdx, 39].PutValue("1");
// 導師意見_高職 40
wst.Cells[wstRIdx, 40].PutValue("1");
// 輔導教師意見_高中 41
wst.Cells[wstRIdx, 41].PutValue("1");
// 輔導教師意見_高職 42
wst.Cells[wstRIdx, 42].PutValue("1");
wstRIdx++;
}
bgWorkerExport.ReportProgress(100);
e.Result = wb;
}
catch (Exception ex)
{
throw ex;
}
}
private void BgWorkerExport_DoWork(object sender, DoWorkEventArgs e)
{
bgWorkerExport.ReportProgress(1);
try
{
// 取得預設樣板
Workbook wb = new Workbook(new MemoryStream(Properties.Resources.Template));
Worksheet wst = wb.Worksheets[0];
// 取得學生基本資料
List <StudentInfo> StudentInfoList = QueryData.GetStudentInfoList3();
List <string> StudentIDList = new List <string>();
foreach (StudentInfo si in StudentInfoList)
{
StudentIDList.Add(si.StudentID);
}
// 取得地址資訊
Dictionary <string, JHAddressRecord> AddressDict = new Dictionary <string, JHAddressRecord>();
List <JHAddressRecord> tmpAddress = JHAddress.SelectByStudentIDs(StudentIDList);
foreach (JHAddressRecord rec in tmpAddress)
{
if (!AddressDict.ContainsKey(rec.RefStudentID))
{
AddressDict.Add(rec.RefStudentID, rec);
}
}
// 取得電話資料
Dictionary <string, JHPhoneRecord> PhoneDict = new Dictionary <string, JHPhoneRecord>();
List <JHPhoneRecord> tmpPhone = JHPhone.SelectByStudentIDs(StudentIDList);
foreach (JHPhoneRecord rec in tmpPhone)
{
if (!PhoneDict.ContainsKey(rec.RefStudentID))
{
PhoneDict.Add(rec.RefStudentID, rec);
}
}
bgWorkerExport.ReportProgress(20);
// 取得監護人父母資訊
Dictionary <string, JHParentRecord> ParentDict = new Dictionary <string, JHParentRecord>();
List <JHParentRecord> tmpParent = JHParent.SelectByStudentIDs(StudentIDList);
foreach (JHParentRecord rec in tmpParent)
{
if (!ParentDict.ContainsKey(rec.RefStudentID))
{
ParentDict.Add(rec.RefStudentID, rec);
}
}
// 轉換各項類別對照值
Dictionary <string, string> MappingTag1 = new Dictionary <string, string>();
Dictionary <string, string> MappingTag2 = new Dictionary <string, string>();
Dictionary <string, string> MappingTag3 = new Dictionary <string, string>();
Dictionary <string, string> MappingTag4 = new Dictionary <string, string>();
// 取得學生類別
Dictionary <string, List <string> > StudentTagDict = QueryData.GetStudentTagName(StudentIDList);
// 解析對照設定
XElement elmRoot = XElement.Parse(_Configure.MappingContent);
if (elmRoot != null)
{
foreach (XElement elm in elmRoot.Elements("Group"))
{
string gpName = elm.Attribute("Name").Value;
if (gpName == "學生身分")
{
foreach (XElement elm1 in elm.Elements("Item"))
{
string tagName = elm1.Attribute("TagName").Value;
if (!MappingTag1.ContainsKey(tagName) && tagName.Length > 0)
{
MappingTag1.Add(tagName, elm1.Attribute("Code").Value);
}
}
}
if (gpName == "身心障礙")
{
foreach (XElement elm1 in elm.Elements("Item"))
{
string tagName = elm1.Attribute("TagName").Value;
if (!MappingTag2.ContainsKey(tagName) && tagName.Length > 0)
{
MappingTag2.Add(tagName, elm1.Attribute("Code").Value);
}
}
}
if (gpName == "學生報名身分設定")
{
foreach (XElement elm1 in elm.Elements("Item"))
{
string tagName = elm1.Attribute("TagName").Value;
if (!MappingTag3.ContainsKey(tagName) && tagName.Length > 0)
{
MappingTag3.Add(tagName, elm1.Attribute("Code").Value);
}
}
}
if (gpName == "失業勞工子女")
{
foreach (XElement elm1 in elm.Elements("Item"))
{
string tagName = elm1.Attribute("TagName").Value;
if (!MappingTag4.ContainsKey(tagName) && tagName.Length > 0)
{
MappingTag4.Add(tagName, elm1.Attribute("Code").Value);
}
}
}
}
}
// 取得語言認證學生id
List <string> hasLanguageCertificateIDList = QueryData.GetLanguageCertificate(StudentIDList);
bgWorkerExport.ReportProgress(40);
// 取得成績相關資料
Dictionary <string, List <JHSemesterScoreRecord> > SemesterScoreRecordDict = new Dictionary <string, List <JHSemesterScoreRecord> >();
List <JHSemesterScoreRecord> tmpSemsScore = JHSemesterScore.SelectByStudentIDs(StudentIDList);
foreach (JHSemesterScoreRecord rec in tmpSemsScore)
{
if (!SemesterScoreRecordDict.ContainsKey(rec.RefStudentID))
{
SemesterScoreRecordDict.Add(rec.RefStudentID, new List <JHSemesterScoreRecord>());
}
SemesterScoreRecordDict[rec.RefStudentID].Add(rec);
}
// 取得功過紀錄
// 功過對照表
JHMeritDemeritReduceRecord DemeritReduceRecord = JHMeritDemeritReduce.Select();
// 懲
Dictionary <string, List <JHDemeritRecord> > DemeritRecordDict = new Dictionary <string, List <JHDemeritRecord> >();
List <JHDemeritRecord> tmpDemeritRecord = JHDemerit.SelectByStudentIDs(StudentIDList);
foreach (JHDemeritRecord rec in tmpDemeritRecord)
{
if (rec.Cleared == "是")
{
continue;
}
if (rec.OccurDate > _Configure.EndDate)
{
continue;
}
else
{
if (!DemeritRecordDict.ContainsKey(rec.RefStudentID))
{
DemeritRecordDict.Add(rec.RefStudentID, new List <JHDemeritRecord>());
}
DemeritRecordDict[rec.RefStudentID].Add(rec);
}
}
// 獎
Dictionary <string, List <JHMeritRecord> > MeritRecordDict = new Dictionary <string, List <JHMeritRecord> >();
List <JHMeritRecord> tmpMeritRecord = JHMerit.SelectByStudentIDs(StudentIDList);
foreach (JHMeritRecord rec in tmpMeritRecord)
{
if (rec.OccurDate > _Configure.EndDate)
{
continue;
}
else
{
if (!MeritRecordDict.ContainsKey(rec.RefStudentID))
{
MeritRecordDict.Add(rec.RefStudentID, new List <JHMeritRecord>());
}
MeritRecordDict[rec.RefStudentID].Add(rec);
}
}
// 填入幹部資料
StudentInfoList = QueryData.FillCad(StudentIDList, StudentInfoList);
// 填入中低收入戶
StudentInfoList = QueryData.FillIncomeType(StudentIDList, StudentInfoList);
// 填入競賽成績
StudentInfoList = QueryData.FillStudentCompetitionScore(StudentIDList, StudentInfoList, _Configure.EndDate);
// 取得學生體適能資料並填入
StudentInfoList = QueryData.FillStudentFitness(StudentIDList, StudentInfoList, _Configure.EndDate);
// 填入 Excel 資料
int wstRIdx = 1;
bgWorkerExport.ReportProgress(70);
// 幹部限制
List <string> CadreName1 = _Configure.LoadCareNames();
foreach (StudentInfo si in StudentInfoList)
{
// 考區代碼 0， 12/屏東考區
wst.Cells[wstRIdx, 0].PutValue(12);
// 集報單位代碼 1,學校代碼
wst.Cells[wstRIdx, 1].PutValue(K12.Data.School.Code);
// 序號 2
wst.Cells[wstRIdx, 2].PutValue(wstRIdx);
// 學號 3
wst.Cells[wstRIdx, 3].PutValue(si.StudentNumber);
// 班級 4
wst.Cells[wstRIdx, 4].PutValue(si.ClassName);
// 座號 5
wst.Cells[wstRIdx, 5].PutValue(si.SeatNo);
// 學生姓名 6
wst.Cells[wstRIdx, 6].PutValue(si.StudentName);
// 身分證統一編號 7
wst.Cells[wstRIdx, 7].PutValue(si.IDNumber);
// 性別 8
wst.Cells[wstRIdx, 8].PutValue(si.GenderCode);
// 出生年(民國年) 9
wst.Cells[wstRIdx, 9].PutValue(si.BirthYear);
// 出生月 10
wst.Cells[wstRIdx, 10].PutValue(si.BirthMonth);
// 出生日 11
wst.Cells[wstRIdx, 11].PutValue(si.BirthDay);
// 畢業學校代碼 12
wst.Cells[wstRIdx, 12].PutValue(K12.Data.School.Code);
// 畢業年(民國年) 13
int gyear;
if (int.TryParse(K12.Data.School.DefaultSchoolYear, out gyear))
{
wst.Cells[wstRIdx, 13].PutValue(gyear + 1);
}
// 畢肄業 14
wst.Cells[wstRIdx, 14].PutValue(1);
// 就學區 17
// 低收入戶 18
if (si.incomeType1)
{
wst.Cells[wstRIdx, 18].PutValue(1);
}
else
{
wst.Cells[wstRIdx, 18].PutValue(0);
}
// 中低收入戶 19
if (si.incomeType2)
{
wst.Cells[wstRIdx, 19].PutValue(1);
}
else
{
wst.Cells[wstRIdx, 19].PutValue(0);
}
wst.Cells[wstRIdx, 15].PutValue("0");
wst.Cells[wstRIdx, 16].PutValue("0");
wst.Cells[wstRIdx, 20].PutValue("0");
wst.Cells[wstRIdx, 28].PutValue("0");
if (StudentTagDict.ContainsKey(si.StudentID))
{
foreach (string tagName in StudentTagDict[si.StudentID])
{
if (MappingTag1.ContainsKey(tagName))
{
// 學生身分 15
wst.Cells[wstRIdx, 15].PutValue(MappingTag1[tagName]);
}
if (MappingTag2.ContainsKey(tagName))
{
si.isSpecial = true;
// 身心障礙 16
wst.Cells[wstRIdx, 16].PutValue(MappingTag2[tagName]);
}
if (MappingTag3.ContainsKey(tagName))
{
// 學生報名身分 28
wst.Cells[wstRIdx, 28].PutValue(MappingTag3[tagName]);
}
if (MappingTag4.ContainsKey(tagName))
{
// 失業勞工子女 20
wst.Cells[wstRIdx, 20].PutValue(MappingTag4[tagName]);
}
}
}
// 資料授權 21
wst.Cells[wstRIdx, 21].PutValue(0);
string parentName = "";
// 家長姓名 22
if (ParentDict.ContainsKey(si.StudentID))
{
if (!string.IsNullOrWhiteSpace(ParentDict[si.StudentID].CustodianName))
{
parentName = ParentDict[si.StudentID].CustodianName;
}
else if (!string.IsNullOrWhiteSpace(ParentDict[si.StudentID].FatherName))
{
parentName = ParentDict[si.StudentID].FatherName;
}
else if (!string.IsNullOrWhiteSpace(ParentDict[si.StudentID].MotherName))
{
parentName = ParentDict[si.StudentID].MotherName;
}
else
{
}
wst.Cells[wstRIdx, 22].PutValue(parentName);
}
// 市內電話 23
// 行動電話 24
if (PhoneDict.ContainsKey(si.StudentID))
{
wst.Cells[wstRIdx, 23].PutValue(PhoneDict[si.StudentID].Contact.Replace("-", "").Replace(")", "").Replace("(", ""));
wst.Cells[wstRIdx, 24].PutValue(PhoneDict[si.StudentID].Cell.Replace("-", "").Replace(")", "").Replace("(", ""));
}
// 郵遞區號 25
if (AddressDict.ContainsKey(si.StudentID))
{
string zipCode = "";
if (AddressDict[si.StudentID].MailingZipCode != null)
{
zipCode = AddressDict[si.StudentID].MailingZipCode;
}
if (zipCode.Length >= 3)
{
zipCode = zipCode.Substring(0, 3);
}
wst.Cells[wstRIdx, 25].PutValue(zipCode);
// 通訊地址 26
wst.Cells[wstRIdx, 26].PutValue(AddressDict[si.StudentID].MailingCounty + AddressDict[si.StudentID].MailingTown + AddressDict[si.StudentID].MailingDistrict + AddressDict[si.StudentID].MailingArea + AddressDict[si.StudentID].MailingDetail);
}
// 非中華民國身分證號 27
if (si.isTaiwanID)
{
wst.Cells[wstRIdx, 27].PutValue("");
}
else
{
wst.Cells[wstRIdx, 27].PutValue("V");
}
// 市內電話分機 29
// 均衡學習 30
// 計算分數
if (SemesterScoreRecordDict.ContainsKey(si.StudentID))
{
si.CalcSemsScore5(SemesterScoreRecordDict[si.StudentID]);
// 成績滿5學期才顯示
if (si.hasSemester5Score)
{
wst.Cells[wstRIdx, 30].PutValue(si.Semester5Score);
}
}
// 服務表現 31
si.CalcCadreScore(CadreName1);
wst.Cells[wstRIdx, 31].PutValue(si.ServiceScore);
// 品德表現 32
if (DemeritRecordDict.ContainsKey(si.StudentID))
{
if (MeritRecordDict.ContainsKey(si.StudentID))
{
si.CalcDemeritMemeritScore(DemeritRecordDict[si.StudentID], MeritRecordDict[si.StudentID], DemeritReduceRecord);
}
else
{
si.CalcDemeritMemeritScore(DemeritRecordDict[si.StudentID], new List <JHMeritRecord>(), DemeritReduceRecord);
}
wst.Cells[wstRIdx, 32].PutValue(si.MeritDemeritScore);
}
else
{
// 沒有懲戒
wst.Cells[wstRIdx, 32].PutValue(10);
}
// 競賽表現 33
si.CalcCompetitionScore();
wst.Cells[wstRIdx, 33].PutValue(si.CompetitionScore);
// 體適能 34
// 計算並填入
si.CalcFitnessScore();
wst.Cells[wstRIdx, 34].PutValue(si.FitnessScore);
// 本土語言認證 35
if (hasLanguageCertificateIDList.Contains(si.StudentID))
{
wst.Cells[wstRIdx, 35].PutValue(2);
}
else
{
wst.Cells[wstRIdx, 35].PutValue(0);
}
// 36~39 系統無法提供先空
// 適性發展_高中 36
// 適性發展_高職 37
// 適性發展_綜合高中 38
// 適性發展_五專 39
wstRIdx++;
}
bgWorkerExport.ReportProgress(100);
e.Result = wb;
}
catch (Exception ex)
{
throw ex;
}
}
private void Worker_DoWork(object sender, DoWorkEventArgs e)
{
double total = _config.Students.Count;
double count = 0;
_worker.ReportProgress(0);
List <string> student_ids = new List <string>();
foreach (JHStudentRecord item in _config.Students)
{
student_ids.Add(item.ID);
}
#region 快取資料
//獎勵
Dictionary <string, List <JHMeritRecord> > meritCache = new Dictionary <string, List <JHMeritRecord> >();
foreach (JHMeritRecord record in JHMerit.SelectByStudentIDs(student_ids))
{
if (record.OccurDate < _config.StartDate)
{
continue;
}
if (record.OccurDate > _config.EndDate)
{
continue;
}
if (!meritCache.ContainsKey(record.RefStudentID))
{
meritCache.Add(record.RefStudentID, new List <JHMeritRecord>());
}
meritCache[record.RefStudentID].Add(record);
}
//懲戒
Dictionary <string, List <JHDemeritRecord> > demeritCache = new Dictionary <string, List <JHDemeritRecord> >();
foreach (JHDemeritRecord record in JHDemerit.SelectByStudentIDs(student_ids))
{
if (record.OccurDate < _config.StartDate)
{
continue;
}
if (record.OccurDate > _config.EndDate)
{
continue;
}
if (!demeritCache.ContainsKey(record.RefStudentID))
{
demeritCache.Add(record.RefStudentID, new List <JHDemeritRecord>());
}
demeritCache[record.RefStudentID].Add(record);
}
//缺曠
Dictionary <string, List <JHAttendanceRecord> > attendanceCache = new Dictionary <string, List <JHAttendanceRecord> >();
foreach (JHAttendanceRecord record in JHAttendance.SelectByStudentIDs(student_ids))
{
if (record.OccurDate < _config.StartDate)
{
continue;
}
if (record.OccurDate > _config.EndDate)
{
continue;
}
if (!attendanceCache.ContainsKey(record.RefStudentID))
{
attendanceCache.Add(record.RefStudentID, new List <JHAttendanceRecord>());
}
attendanceCache[record.RefStudentID].Add(record);
}
List <string> course_ids = new List <string>();
foreach (JHSCAttendRecord record in JHSCAttend.SelectByStudentIDs(student_ids))
{
if (!course_ids.Contains(record.RefCourseID))
{
course_ids.Add(record.RefCourseID);
}
}
//課程
JHCourse.RemoveAll();
int schoolYear = _config.SchoolYear;
int semester = _config.Semester;
Dictionary <string, JHCourseRecord> courseCache = new Dictionary <string, JHCourseRecord>();
foreach (JHCourseRecord record in JHCourse.SelectByIDs(course_ids))
{
if ("" + record.SchoolYear != "" + schoolYear)
{
continue;
}
if ("" + record.Semester != "" + semester)
{
continue;
}
// 過濾使用者所選課程才放入
if (Global._selectCourseIDList.Contains(record.ID))
{
if (!courseCache.ContainsKey(record.ID))
{
courseCache.Add(record.ID, record);
}
}
}
//修課記錄
Dictionary <string, List <string> > scCache = new Dictionary <string, List <string> >();
//foreach (JHSCAttendRecord sc in JHSCAttend.Select(student_ids, course_ids, new string[] { }, "" + _config.SchoolYear, "" + _config.Semester))
foreach (JHSCAttendRecord sc in JHSCAttend.SelectByStudentIDAndCourseID(student_ids, course_ids))
{
if (!courseCache.ContainsKey(sc.RefCourseID))
{
continue;
}
if (!scCache.ContainsKey(sc.RefStudentID))
{
scCache.Add(sc.RefStudentID, new List <string>());
}
// 過濾使用者不選
if (Global._selectCourseIDList.Contains(sc.RefCourseID))
{
scCache[sc.RefStudentID].Add(sc.RefCourseID);
}
}
//評量成績
Dictionary <string, List <HC.JHSCETakeRecord> > sceScoreCache = new Dictionary <string, List <HC.JHSCETakeRecord> >();
foreach (JHSCETakeRecord record in JHSCETake.SelectByStudentAndCourse(student_ids, course_ids))
{
if (record.RefExamID != _config.Exam.ID)
{
continue;
}
if (!sceScoreCache.ContainsKey(record.RefStudentID))
{
sceScoreCache.Add(record.RefStudentID, new List <HC.JHSCETakeRecord>());
}
sceScoreCache[record.RefStudentID].Add(new HC.JHSCETakeRecord(record));
}
//學期歷程
Dictionary <string, K12.Data.SemesterHistoryItem> historyCache = new Dictionary <string, K12.Data.SemesterHistoryItem>();
foreach (JHSemesterHistoryRecord record in JHSemesterHistory.SelectByStudentIDs(student_ids))
{
foreach (K12.Data.SemesterHistoryItem item in record.SemesterHistoryItems)
{
if ("" + item.SchoolYear != K12.Data.School.DefaultSchoolYear)
{
continue;
}
if ("" + item.Semester != K12.Data.School.DefaultSemester)
{
continue;
}
if (!historyCache.ContainsKey(record.RefStudentID))
{
historyCache.Add(record.RefStudentID, item);
}
}
}
//取得所有教師，為了Cache下來
JHTeacher.SelectAll();
#endregion
#region 建立節次對照及假別列表
Dictionary <string, string> periodMapping = new Dictionary <string, string>();
foreach (JHPeriodMappingInfo info in JHPeriodMapping.SelectAll())
{
if (!periodMapping.ContainsKey(info.Name))
{
periodMapping.Add(info.Name, info.Type);
}
}
List <string> absenceList = new List <string>();
foreach (JHAbsenceMappingInfo info in JHAbsenceMapping.SelectAll())
{
absenceList.Add(info.Name);
}
#endregion
#region 判斷要列印的領域科目
Dictionary <string, bool> domains = new Dictionary <string, bool>();
Dictionary <string, List <string> > subjects = new Dictionary <string, List <string> >();
List <JHCourseRecord> courseList = new List <JHCourseRecord>(courseCache.Values);
courseList.Sort(delegate(JHCourseRecord x, JHCourseRecord y)
{
return(JHSchool.Evaluation.Subject.CompareSubjectOrdinal(x.Subject, y.Subject));
//List<string> list = new List<string>(new string[] { "國語文", "國文", "英文", "英語", "數學", "歷史", "地理", "公民", "理化", "生物" });
//int ix = list.IndexOf(x.Subject);
//int iy = list.IndexOf(y.Subject);
//if (ix >= 0 && iy >= 0)
// return ix.CompareTo(iy);
//else if (ix >= 0)
// return -1;
//else if (iy >= 0)
// return 1;
//else
// return x.Subject.CompareTo(y.Subject);
});
string domainSubjectSetup = _rc.GetString("領域科目設定", "Domain");
_config.DomainSubjectSetup = domainSubjectSetup;
if (domainSubjectSetup == "Domain")
{
foreach (var domain in JHSchool.Evaluation.Subject.Domains)
{
domains.Add(domain, true);
}
//domains.Add("彈性課程", false);
if (domains.ContainsKey("語文"))
{
domains["語文"] = false;
}
if (!domains.ContainsKey(""))
{
domains.Add("", false);
}
}
else if (domainSubjectSetup == "Subject")
{
foreach (var domain in JHSchool.Evaluation.Subject.Domains)
{
domains.Add(domain, false);
}
//domains.Add("彈性課程", false);
if (!domains.ContainsKey(""))
{
domains.Add("", false);
}
}
else
{
throw new Exception("請重新儲存一次列印設定");
}
foreach (var domain in JHSchool.Evaluation.Subject.Domains)
{
subjects.Add(domain, new List <string>());
}
//subjects.Add("彈性課程", new List<string>());
subjects.Add("", new List <string>());
//foreach (JHCourseRecord course in courseList)
//{
// if (!domains.ContainsKey(course.Domain)) continue;
// if (!subjects.ContainsKey(course.Domain))
// subjects.Add(course.Domain, new List<string>());
// //很怪
// if (domains[course.Domain] == true) continue;
// if (!subjects[course.Domain].Contains(course.Subject))
// subjects[course.Domain].Add(course.Subject);
//}
_config.SetPrintDomains(domains);
_config.SetPrintSubjects(subjects);
#endregion
DocumentBuilder templateBuilder = new DocumentBuilder(_template);
#region 判斷是否列印文字評語
templateBuilder.MoveToMergeField("文字評語");
if (_rc.GetBoolean("列印文字評語", true))
{
templateBuilder.Write("文字評語");
}
else
{
Cell first = templateBuilder.CurrentParagraph.ParentNode as Cell;
double width = first.CellFormat.Width;
Table table = first.ParentRow.ParentTable;
foreach (Row row in table.Rows)
{
if (row.ChildNodes.Count == 1)
{
break;
}
row.RemoveChild(row.LastCell);
int lastIndex = row.ChildNodes.Count - 1;
row.Cells[lastIndex--].CellFormat.Width += (width / 3f);
row.Cells[lastIndex--].CellFormat.Width += (width / 3f);
row.Cells[lastIndex].CellFormat.Width += (width / 3f);
}
}
#endregion
#region 依節權數設定，在畫面上顯示
string pcDisplay = string.Empty;
bool p = _rc.GetBoolean("列印節數", false);
bool c = _rc.GetBoolean("列印權數", false);
if (p && c)
{
pcDisplay = "節/權數";
}
else if (p)
{
pcDisplay = "節數";
}
else if (c)
{
pcDisplay = "權數";
}
while (templateBuilder.MoveToMergeField("節權數"))
{
templateBuilder.Write(pcDisplay);
}
#endregion
#region 如果使用者不印定期評量，從畫面上將欄位拿掉
templateBuilder.MoveToMergeField("定期評量");
if (_rc.GetBoolean("列印定期評量", false) == false)
{
Cell assignmentCell = templateBuilder.CurrentParagraph.ParentNode as Cell;
double width = assignmentCell.CellFormat.Width;
bool hasText = false;
if (assignmentCell.NextSibling != null)
{
hasText = true;
}
Table scoreTable = assignmentCell.ParentRow.ParentTable;
foreach (Row eachRow in scoreTable.Rows)
{
if (eachRow.Cells.Count == 1)
{
break;
}
int lastIndex = 0;
if (hasText)
{
eachRow.RemoveChild(eachRow.Cells[eachRow.Count - 3]);
lastIndex = eachRow.ChildNodes.Count - 3;
}
else
{
eachRow.RemoveChild(eachRow.LastCell);
lastIndex = eachRow.ChildNodes.Count - 1;
}
eachRow.Cells[lastIndex--].CellFormat.Width += (width / 2f);
eachRow.Cells[lastIndex].CellFormat.Width += (width / 2f);
}
}
else
{
templateBuilder.Write("定期評量");
}
#endregion
#region 如果使用者不印平時評量，從畫面上將欄位拿掉
templateBuilder.MoveToMergeField("平時評量");
if (_rc.GetBoolean("列印平時評量", false) == false)
{
Cell assignmentCell = templateBuilder.CurrentParagraph.ParentNode as Cell;
double width = assignmentCell.CellFormat.Width;
bool hasText = false;
if (assignmentCell.NextSibling != null)
{
hasText = true;
}
Table scoreTable = assignmentCell.ParentRow.ParentTable;
foreach (Row eachRow in scoreTable.Rows)
{
if (eachRow.Cells.Count == 1)
{
break;
}
int lastIndex = 0;
if (hasText)
{
eachRow.RemoveChild(eachRow.Cells[eachRow.Count - 2]);
lastIndex = eachRow.ChildNodes.Count - 2;
}
else
{
eachRow.RemoveChild(eachRow.LastCell);
lastIndex = eachRow.ChildNodes.Count - 1;
}
eachRow.Cells[lastIndex--].CellFormat.Width += (width / 2f);
eachRow.Cells[lastIndex].CellFormat.Width += (width / 2f);
}
}
else
{
templateBuilder.Write("平時評量");
}
#endregion
#region 如果使用者不印定期學習評量總成績，從畫面上將欄位拿掉
templateBuilder.MoveToMergeField("定期學習評量總成績");
if (_rc.GetBoolean("列印定期學習評量總成績", false) == false)
{
Cell assignmentCell = templateBuilder.CurrentParagraph.ParentNode as Cell;
double width = assignmentCell.CellFormat.Width;
bool hasText = false;
if (assignmentCell.NextSibling != null)
{
hasText = true;
}
Table scoreTable = assignmentCell.ParentRow.ParentTable;
foreach (Row eachRow in scoreTable.Rows)
{
if (eachRow.Cells.Count == 1)
{
break;
}
int lastIndex = 0;
if (hasText)
{
eachRow.RemoveChild(eachRow.Cells[eachRow.Count - 2]);
lastIndex = eachRow.ChildNodes.Count - 2;
}
else
{
eachRow.RemoveChild(eachRow.LastCell);
lastIndex = eachRow.ChildNodes.Count - 1;
}
eachRow.Cells[lastIndex--].CellFormat.Width += (width / 2f);
eachRow.Cells[lastIndex].CellFormat.Width += (width / 2f);
}
}
else
{
templateBuilder.Write("定期學習評量總成績");
}
#endregion
#region 取得學生成績計算規則
ScoreCalculator defaultScoreCalculator = new ScoreCalculator(null);
//key: ScoreCalcRuleID
Dictionary <string, ScoreCalculator> calcCache = new Dictionary <string, ScoreCalculator>();
//key: StudentID, val: ScoreCalcRuleID
Dictionary <string, string> calcIDCache = new Dictionary <string, string>();
List <string> scoreCalcRuleIDList = new List <string>();
foreach (JHStudentRecord student in _config.Students)
{
//calcCache.Add(student.ID, new ScoreCalculator(student.ScoreCalcRule));
string calcID = string.Empty;
if (!string.IsNullOrEmpty(student.OverrideScoreCalcRuleID))
{
calcID = student.OverrideScoreCalcRuleID;
}
else if (student.Class != null && !string.IsNullOrEmpty(student.Class.RefScoreCalcRuleID))
{
calcID = student.Class.RefScoreCalcRuleID;
}
if (!string.IsNullOrEmpty(calcID))
{
calcIDCache.Add(student.ID, calcID);
}
}
foreach (JHScoreCalcRuleRecord record in JHScoreCalcRule.SelectByIDs(calcIDCache.Values))
{
if (!calcCache.ContainsKey(record.ID))
{
calcCache.Add(record.ID, new ScoreCalculator(record));
}
}
//MsgBox.Show("" + (Environment.TickCount - t));
#endregion
#region 檢查學生成績是否超出可列印行數
foreach (JHStudentRecord student in _config.Students)
{
if (scCache.ContainsKey(student.ID))
{
int checkCount = 0;
if (_config.DomainSubjectSetup == "Subject")
{
checkCount = scCache[student.ID].Count;
}
else
{
List <string> checkDomains = new List <string>();
foreach (string courseID in scCache[student.ID])
{
JHCourseRecord course = courseCache[courseID];
if (string.IsNullOrEmpty(course.Domain))
{
checkCount++;
}
else if (!checkDomains.Contains(course.Domain))
{
checkDomains.Add(course.Domain);
}
}
checkCount += checkDomains.Count;
}
if (checkCount > _rowCount)
{
_overStudentList.Add(student.ID);
}
}
}
//有學生資料超出範圍
if (_overStudentList.Count > 0)
{
//K12.Presentation.NLDPanels.Student.AddToTemp(overStudentList);
System.Windows.Forms.DialogResult result = MsgBox.Show("有 " + _overStudentList.Count + " 位學生評量成績資料超出範本可列印範圍，已將學生加入待處理。\n是否繼續列印？", System.Windows.Forms.MessageBoxButtons.YesNo);
if (result == System.Windows.Forms.DialogResult.No)
{
e.Result = "Cancel";
}
}
#endregion
// 取得學生課程ID對照
Dictionary <string, List <string> > studCourseID = new Dictionary <string, List <string> >();
List <string> sid = (from stud in _config.Students select stud.ID).ToList();
foreach (JHSCAttendRecord attend in JHSCAttend.SelectByStudentIDs(sid))
{
if (attend.Course.SchoolYear.HasValue && attend.Course.Semester.HasValue)
{
if (attend.Course.SchoolYear == _config.SchoolYear && attend.Course.Semester == _config.Semester)
{
if (studCourseID.ContainsKey(attend.RefStudentID))
{
studCourseID[attend.RefStudentID].Add(attend.RefCourseID);
}
else
{
List <string> coid = new List <string>();
coid.Add(attend.RefCourseID);
studCourseID.Add(attend.RefStudentID, coid);
}
}
}
}
// 取得學期歷程
Config._StudSemesterHistoryItemDict.Clear();
List <JHSemesterHistoryRecord> semHisRec = JHSemesterHistory.SelectByStudents(_config.Students);
// 當畫面學期歷程內的學年度學期與畫面上設定相同，加入
foreach (JHSemesterHistoryRecord rec in semHisRec)
{
foreach (K12.Data.SemesterHistoryItem shi in rec.SemesterHistoryItems)
{
if (shi.SchoolYear == _config.SchoolYear && shi.Semester == _config.Semester)
{
if (!Config._StudSemesterHistoryItemDict.ContainsKey(shi.RefStudentID))
{
Config._StudSemesterHistoryItemDict.Add(shi.RefStudentID, shi);
}
}
}
}
// 取得評量比例
Utility.ScorePercentageHSDict.Clear();
Utility.ScorePercentageHSDict = Utility.GetScorePercentageHS();
#region 產生
foreach (JHStudentRecord student in _config.Students)
{
count++;
if (_overStudentList.Contains(student.ID))
{
continue;
}
Document each = (Document)_template.Clone(true);
DocumentBuilder builder = new DocumentBuilder(each);
#region 學生基本資料
StudentBasicInfo basicInfo = new StudentBasicInfo(builder);
basicInfo.SetStudent(student);
#endregion
#region 班導師
builder.MoveToMergeField("班導師");
if (historyCache.ContainsKey(student.ID))
{
builder.Write(historyCache[student.ID].Teacher);
}
else
{
builder.Write(string.Empty);
}
#endregion
#region 成績
List <HC.JHSCETakeRecord> sceScoreList = null;
if (sceScoreCache.ContainsKey(student.ID))
{
sceScoreList = sceScoreCache[student.ID];
}
else
{
sceScoreList = new List <HC.JHSCETakeRecord>();
}
ScoreCalculator studentCalculator = defaultScoreCalculator;
if (calcIDCache.ContainsKey(student.ID) && calcCache.ContainsKey(calcIDCache[student.ID]))
{
studentCalculator = calcCache[calcIDCache[student.ID]];
}
// 過濾 courseCache studid
Dictionary <string, JHCourseRecord> courseCache1 = new Dictionary <string, JHCourseRecord>();
foreach (KeyValuePair <string, JHCourseRecord> val in courseCache)
{
// 從學生修課來對應到課程
if (studCourseID.ContainsKey(student.ID))
{
if (studCourseID[student.ID].Contains(val.Value.ID))
{
courseCache1.Add(val.Key, val.Value);
}
}
}
StudentExamScore examScore = new StudentExamScore(builder, _config, courseCache1);
examScore.PrintPeriod = _rc.GetBoolean("列印節數", false);
examScore.PrintCredit = _rc.GetBoolean("列印權數", false);
examScore.PrintText = _rc.GetBoolean("列印文字評語", true);
examScore.PrintScore = _rc.GetBoolean("列印定期評量", true);
examScore.PrintAssScore = _rc.GetBoolean("列印平時評量", true);
examScore.PrintTotalScore = _rc.GetBoolean("列印定期學習評量總成績", true);
examScore.SetScoreCalculator(studentCalculator);
if (scCache.ContainsKey(student.ID))
{
examScore.SetSubjects(scCache[student.ID]);
}
examScore.SetData(sceScoreList);
#endregion
if (_config.DomainSubjectSetup == "Subject")
{
// 科目定期評量加權平均
if (builder.MoveToMergeField("加權平均") || builder.MoveToMergeField("定期評量加權平均"))
{
if (examScore.SubjAvgScore > 0)
{
builder.Write(examScore.SubjAvgScore.ToString());
}
else
{
builder.Write("");
}
}
// 科目平時評量加權平均
if (builder.MoveToMergeField("平時評量加權平均"))
{
if (examScore.SubjAvgAssignmentScore > 0)
{
builder.Write(examScore.SubjAvgAssignmentScore.ToString());
}
else
{
builder.Write("");
}
}
// 科目學習總分加權平均
if (builder.MoveToMergeField("定期學習評量總成績加權平均"))
{
if (examScore.SubjAvgFinalScore > 0)
{
builder.Write(examScore.SubjAvgFinalScore.ToString());
}
else
{
builder.Write("");
}
}
}
else
{
// 領域定期評量加權平均
if (builder.MoveToMergeField("加權平均") || builder.MoveToMergeField("定期評量加權平均"))
{
if (examScore.DomainAvgScore > 0)
{
builder.Write(examScore.DomainAvgScore.ToString());
}
else
{
builder.Write("");
}
}
// 領域平時評量加權平均
if (builder.MoveToMergeField("平時評量加權平均"))
{
if (examScore.DomainAvgAssignmentScore > 0)
{
builder.Write(examScore.DomainAvgAssignmentScore.ToString());
}
else
{
builder.Write("");
}
}
// 領域學習總分加權平均
if (builder.MoveToMergeField("定期學習評量總成績加權平均"))
{
if (examScore.DomainAvgFinalScore > 0)
{
builder.Write(examScore.DomainAvgFinalScore.ToString());
}
else
{
builder.Write("");
}
}
}
#region 日常表現
List <JHMeritRecord> meritList = null;
List <JHDemeritRecord> demeritList = null;
List <JHAttendanceRecord> attendanceList = null;
meritList = (meritCache.ContainsKey(student.ID)) ? meritCache[student.ID] : new List <JHMeritRecord>();
demeritList = (demeritCache.ContainsKey(student.ID)) ? demeritCache[student.ID] : new List <JHDemeritRecord>();
attendanceList = (attendanceCache.ContainsKey(student.ID)) ? attendanceCache[student.ID] : new List <JHAttendanceRecord>();
StudentMoralScore moral = new StudentMoralScore(builder, _config, periodMapping, absenceList);
moral.SetData(meritList, demeritList, attendanceList);
#endregion
foreach (Section sec in each.Sections)
{
_doc.Sections.Add(_doc.ImportNode(sec, true));
}
//回報進度
_worker.ReportProgress((int)(count * 100.0 / total));
}
List <string> globalFieldName = new List <string>();
List <object> globalFieldValue = new List <object>();
globalFieldName.Add("學校名稱");
globalFieldValue.Add(K12.Data.School.ChineseName);
globalFieldName.Add("學年度");
globalFieldValue.Add(_config.SchoolYear);
globalFieldName.Add("學期");
globalFieldValue.Add(_config.Semester);
globalFieldName.Add("評量名稱");
globalFieldValue.Add(_config.Exam.Name);
globalFieldName.Add("統計期間");
globalFieldValue.Add(_config.StartDate.ToShortDateString() + " ~ " + _config.EndDate.ToShortDateString());
globalFieldName.Add("列印日期");
globalFieldValue.Add(DateConvert.CDate(DateTime.Now.ToString("yyyy/MM/dd")) + " " + DateTime.Now.ToString("HH:mm:ss"));
string chancellor, eduDirector, stuDirector;
chancellor = eduDirector = stuDirector = string.Empty;
XmlElement schoolInfo = K12.Data.School.Configuration["學校資訊"].PreviousData;
XmlElement chancellorElement = (XmlElement)schoolInfo.SelectSingleNode("ChancellorChineseName");
XmlElement eduDirectorElement = (XmlElement)schoolInfo.SelectSingleNode("EduDirectorName");
if (chancellorElement != null)
{
chancellor = chancellorElement.InnerText;
}
if (eduDirectorElement != null)
{
eduDirector = eduDirectorElement.InnerText;
}
globalFieldName.Add("教務主任");
globalFieldValue.Add(eduDirector);
globalFieldName.Add("校長");
globalFieldValue.Add(chancellor);
globalFieldName.Add("成績校正日期");
globalFieldValue.Add(_rc.GetString("成績校正日期", string.Empty));
if (_config.Students.Count > _overStudentList.Count)
{
_doc.MailMerge.Execute(globalFieldName.ToArray(), globalFieldValue.ToArray());
}
#endregion
}