//最好這程式有人能維護的了....... private void MailMerge_MergeField(object sender, MergeFieldEventArgs e) { //不是 Fix 開頭的合併欄位不處理。 if (!e.FieldName.ToUpper().StartsWith("Fix".ToUpper())) { return; } DocumentBuilder builder = new DocumentBuilder(e.Document); ReportStudent student = e.FieldValue as ReportStudent; //如果合併值不是 ReportStudent 就跳過...意思是有問題...。 if (student == null) { return; } builder.MoveToField(e.Field, true); e.Field.Remove(); if (e.FieldName == "Fix:科目資訊") { #region 列印年級學期資訊(有點複雜)。 SemesterDataCollection semses = student.SHistory.GetGradeYearSemester(); //Row SemesterRow = builder.CurrentParagraph.ParentNode.ParentNode.NextSibling as Row; //下一個 Row。 //Paragraph originParagraph = builder.CurrentParagraph; int count = 0;//, offset = 1; foreach (SemesterData each in semses) { //string currentGradeyear = Util.GetGradeyearString(each.GradeYear.ToString()); ////如果沒有年級,就跳過。 //if (string.IsNullOrEmpty(currentGradeyear)) continue; //builder.Write(currentGradeyear + "年級"); Paragraph nextPh = Util.NextCell(builder.CurrentParagraph); if (nextPh == null) { break; //沒有下一個 Cell ,就不印資料了。 } builder.MoveTo(nextPh); //Paragraph resetParagraph = builder.CurrentParagraph; //SemesterRow.Cells[count + offset].Write(builder, GetSemesterString(each)); SemesterData semester = new SemesterData(0, each.SchoolYear, each.Semester); if (!student.HeaderList.ContainsKey(semester)) { student.HeaderList.AddRaw(each, count); //不要懷疑,這是對的。 } //builder.MoveTo(resetParagraph); count++; } //builder.MoveTo(originParagraph); //Paragraph nextParagrap = originParagraph; //string previousGradeyear = GetText(originParagraph); //while ((nextParagrap = Util.NextCell(nextParagrap)) != null) //{ // if (GetText(nextParagrap) == previousGradeyear) // (nextParagrap.ParentNode as Cell).CellFormat.HorizontalMerge = CellMerge.Previous; // previousGradeyear = GetText(nextParagrap); //} #endregion #region 列印科目資料(爆炸複雜) Row template = builder.CurrentParagraph.ParentNode.ParentNode as Row; Table table = template.ParentNode as Table; if (PrintSetting.ListMethod == ListMethod.DomainOnly) { PrintDomainOnly(builder, student, template, table); } else { PrintSubjectOnly(builder, student, template, table); } //設定表格下方線寬。 double borderWidth = (template.NextSibling as Row).Cells[0].CellFormat.Borders.Bottom.LineWidth; foreach (Cell each in (template.PreviousSibling as Row).Cells) { each.CellFormat.Borders.Bottom.LineWidth = borderWidth; } template.NextSibling.Remove(); template.Remove(); #endregion } if (e.FieldName == "Fix:照片") { if (student.GraduatePhoto != null) { Shape photo = builder.InsertImage(student.GraduatePhoto); Cell cell = builder.CurrentParagraph.ParentNode as Cell; Row row = cell.ParentRow; double rectHeight = row.RowFormat.Height, rectWidth = cell.CellFormat.Width; double heightRate = (rectHeight / photo.Height); double widthRate = (rectWidth / photo.Width); double rate = 0; if (heightRate < widthRate) { rate = heightRate; } else { rate = widthRate; } photo.Width = photo.Width * rate; photo.Height = photo.Height * rate; } } }
private void MasterWorker_DoWork(object sender, DoWorkEventArgs e) { StudentScore.SetClassMapping(); PrintStudents = StudentIDs.ToReportStudent(); List <ReportStudent> AllStudents = Util.GetAllStudents(); AllStudents.ToSC().ReadSemesterScore(this); AllStudents.ToSC().ReadSemesterHistory(this); if (Preference.PrintRank || Preference.PrintRankPercentage || Preference.FilterRankScope) { #region 如果要排名。 List <ReportStudent> RatingStudents = Util.GetRatingStudents(AllStudents); List <IScoreParser <ReportStudent> > parsers = new List <IScoreParser <ReportStudent> >(); parsers.Add(new LearningDomainParser(Preference.PrintSemesters)); parsers.Add(new SLearningDomainParser(1, 1)); parsers.Add(new SLearningDomainParser(1, 2)); parsers.Add(new SLearningDomainParser(2, 1)); parsers.Add(new SLearningDomainParser(2, 2)); parsers.Add(new SLearningDomainParser(3, 1)); parsers.Add(new SLearningDomainParser(3, 2)); parsers.Add(new SLearningDomainParser(7, 1)); parsers.Add(new SLearningDomainParser(7, 2)); parsers.Add(new SLearningDomainParser(8, 1)); parsers.Add(new SLearningDomainParser(8, 2)); parsers.Add(new SLearningDomainParser(9, 1)); parsers.Add(new SLearningDomainParser(9, 2)); List <RatingScope <ReportStudent> > scopes = RatingStudents.ToGradeYearScopes(); foreach (RatingScope <ReportStudent> each in scopes) { foreach (IScoreParser <ReportStudent> parser in parsers) { each.Rank(parser, PlaceOptions.Unsequence); } } Dictionary <string, StudentScore> DicPrintStudents = PrintStudents.ToSC().ToDictionary(); foreach (ReportStudent each in AllStudents) { if (DicPrintStudents.ContainsKey(each.Id)) { DicPrintStudents[each.Id] = each; } } if (Preference.FilterRankScope) { List <ReportStudent> filteredStudent = new List <ReportStudent>(); foreach (ReportStudent each in DicPrintStudents.Values.ToSS()) { //看是否有「學習領域」的年排名。 if (each.Places.NS("年排名").Contains(LearningDomainParser.PlaceName)) { Place place = each.Places.NS("年排名")[LearningDomainParser.PlaceName]; if (place.Level >= Preference.RankStart && place.Level <= Preference.RankEnd) { filteredStudent.Add(each); } } } PrintStudents = filteredStudent; } else { PrintStudents = new List <ReportStudent>(DicPrintStudents.Values.ToSS()); } #endregion } else { Dictionary <string, StudentScore> DicPrintStudents = PrintStudents.ToSC().ToDictionary(); foreach (ReportStudent each in AllStudents) { if (DicPrintStudents.ContainsKey(each.Id)) { DicPrintStudents[each.Id] = each; } } PrintStudents = new List <ReportStudent>(DicPrintStudents.Values.ToSS()); } if (PrintStudents.Count <= 0) { Feedback("", -1); //把 Status bar Reset... throw new ArgumentException("沒有任何學生資料可列印。"); } List <StudentScore> CalcStudents = PrintStudents.ToSC(); CalcStudents.ReadCalculationRule(this); //讀取成績計算規則。 #region 讀取缺曠獎懲。 //List<JHMoralScoreRecord> jhmorals = JHSchool.Data.JHMoralScore.SelectByStudentIDs(StudentIDs); List <AutoSummaryRecord> jhsummary = AutoSummary.Select(StudentIDs, null); Dictionary <string, ReportStudent> DicStudents = PrintStudents.ToDictionary(); //foreach (JHMoralScoreRecord each in jhmorals) foreach (AutoSummaryRecord each in jhsummary) { if (!DicStudents.ContainsKey(each.RefStudentID)) { continue; } SemesterData semester = new SemesterData(0, each.SchoolYear, each.Semester); ReportStudent student = DicStudents[each.RefStudentID]; if (!student.Summaries.ContainsKey(semester)) { student.Summaries.Add(semester, each.AutoSummary); } } #endregion PrintStudents.ReadUpdateRecordDate(this); e.Result = new Report(PrintStudents, Preference).Print(); e_For_ConvertToPDF_Worker = e; Feedback("列印完成", -1); }
public bool GetValue(string fieldName, out object fieldValue) { fieldValue = string.Empty; ReportStudent student = Students[Index]; if (fieldName.ToUpper().StartsWith("Fix:".ToUpper())) { fieldValue = student; return(true); } switch (fieldName) { case "學號": fieldValue = student.StudentNumber; break; //case "班級": // fieldValue = student.ClassName; // break; //case "座號": // fieldValue = student.SeatNo; // break; case "姓名": fieldValue = student.Name; break; case "英文姓名": fieldValue = student.EnglishName; break; case "身分證號": fieldValue = student.IDNumber; break; //case "性別": // fieldValue = student.Gender; // break; case "生日": DateTime dtBirthday; if (DateTime.TryParse(student.Birthday, out dtBirthday)) { fieldValue = dtBirthday.ToString(Util.EnglishFormat, Util.USCulture); } else { fieldValue = string.Empty; } break; case "列印日期": DateTime dtPrintDate; if (DateTime.TryParse(PrintDate, out dtPrintDate)) { fieldValue = dtPrintDate.ToString(Util.EnglishFormat, Util.USCulture); } else { fieldValue = string.Empty; } break; case "學校名稱": fieldValue = K12.Data.School.ChineseName; break; case "英文學校名稱": fieldValue = K12.Data.School.EnglishName; break; case "入學日期": if (string.IsNullOrEmpty(Preference.EntranceDate)) { fieldValue = student.EngEntranceDate; } else { DateTime engdt; if (DateTime.TryParse(Preference.EntranceDate, out engdt)) { fieldValue = engdt.ToString(Util.EnglishFormat, Util.USCulture); } else { fieldValue = Preference.EntranceDate; } } break; case "畢業日期": if (string.IsNullOrEmpty(Preference.GraduateDate)) { fieldValue = student.EngGraduateDate; } else { DateTime engdt; if (DateTime.TryParse(Preference.GraduateDate, out engdt)) { fieldValue = engdt.ToString(Util.EnglishFormat, Util.USCulture); } else { fieldValue = Preference.GraduateDate; } } break; } return(true); }
private void PrintDomainOnly(DocumentBuilder builder, ReportStudent student, Row template, Table table) { #region 列印領域 UniqueSet <RowHeader> RowIndexs = new UniqueSet <RowHeader>(); #region 列印 RowHeader foreach (SemesterData semester in student.SHistory.GetGradeYearSemester()) { SemesterData sysems = new SemesterData(0, semester.SchoolYear, semester.Semester); //如果不包含該學期成績資料,就跳過。 if (!student.SemestersScore.Contains(sysems)) { continue; } SemesterScore semsscore = student.SemestersScore[sysems]; //準備彈性課程的科目(要詳列出來)。 foreach (string strSubject in semsscore.Subject) { SemesterSubjectScore subject = semsscore.Subject[strSubject]; if (DetailDomain.Contains(subject.Domain)) { RowHeader header = new RowHeader(subject.Domain, strSubject); header.IsDomain = false; if (!RowIndexs.Contains(header)) { RowIndexs.Add(header); } } } //準備領域資料。 foreach (string strDomain in semsscore.Domain) { if (!Subj.Domains.Contains(strDomain)) { continue; } SemesterDomainScore domain = semsscore.Domain[strDomain]; if (!DetailDomain.Contains(strDomain)) { RowHeader header = new RowHeader(strDomain, string.Empty); header.IsDomain = true; if (!RowIndexs.Contains(header)) { RowIndexs.Add(header); } } } } List <RowHeader> sortedHeaders = SortHeader(RowIndexs.ToList()); //產生 Row。 List <RowHeader> indexHeaders = new List <RowHeader>(); Row current = template; int rowIndex = 0; foreach (RowHeader header in sortedHeaders) { RowHeader indexH = header; indexH.Index = rowIndex++; indexHeaders.Add(indexH); bool hasGroup = !string.IsNullOrEmpty(Subj.GetDomainGroup(header.Domain)); string groupName = Subj.GetDomainGroup(header.Domain); Row datarow = table.InsertBefore(template.Clone(true), current) as Row; if (header.IsDomain) { string domainCName = header.Domain; //string domainEName = Subj.GetDomainEnglish(header.Domain); string domainEName = _SubjDomainEngNameMapping.GetDomainEngName(header.Domain); string domainString = domainCName + (string.IsNullOrEmpty(domainEName) ? "" : domainEName); if (hasGroup) { string gn = groupName; if (groupName == "語文") { gn = "語文\nLanguage"; } datarow.Cells[0].Write(builder, gn); datarow.Cells[1].Write(builder, domainString); } else { datarow.Cells[0].Write(builder, domainString); } } else { string gn = ""; //Additional Classes if (IsFlexible(header.Domain)) { gn = "彈性課程\nAdditional Classes"; } else { gn = header.Domain; } string subjCName = header.Subject; //string subjEName = Subj.GetSubjectEnglish(header.Subject); string subjEName = _SubjDomainEngNameMapping.GetSubjectEngName(header.Subject); string subjString = header.Subject + (string.IsNullOrEmpty(subjEName) ? "" : "\n" + subjEName); //把空白的領域當成「彈性課程」。 string domain = gn; string domainEName = _SubjDomainEngNameMapping.GetDomainEngName(domain); domain += string.IsNullOrWhiteSpace(domainEName) ? "" : "\n" + domainEName; datarow.Cells[0].Write(builder, domain); datarow.Cells[1].Write(builder, subjString); } } #endregion #region 填資料 //Row RatingRow = null; foreach (RowHeader header in indexHeaders) { SemesterDataCollection semesters = new SemesterDataCollection(); Row row = table.Rows[header.Index + DataRowOffset]; foreach (SemesterData semester in student.SHistory.GetGradeYearSemester()) { SemesterData sysems = new SemesterData(0, semester.SchoolYear, semester.Semester); semesters.Add(sysems); if (!student.SemestersScore.Contains(sysems)) { continue; } if (!student.HeaderList.ContainsKey(sysems)) { continue; } int columnIndex = student.HeaderList[sysems]; SemesterScore semsscore = student.SemestersScore[sysems]; decimal?score = null; decimal?weight = null; if (header.IsDomain) { if (semsscore.Domain.Contains(header.Domain)) { score = semsscore.Domain[header.Domain].Value; weight = semsscore.Domain[header.Domain].Weight; } } else { if (semsscore.Subject.Contains(header.Subject)) { score = semsscore.Subject[header.Subject].Value; weight = semsscore.Subject[header.Subject].Weight; } } if (!score.HasValue) { continue; } if (!weight.HasValue) { weight = 0; } //if (PrintScore) // row.Cells[columnIndex + 2].Write(builder, score.Value + ""); //else // row.Cells[columnIndex + 2].Write(builder, Util.GetDegreeEnglish(score.Value)); if (PrintScore) { if (Global.ShowCredit) { row.Cells[columnIndex * 2 + 2].Write(builder, score.Value + ""); row.Cells[columnIndex * 2 + 3].Write(builder, weight.Value + ""); } else { row.Cells[columnIndex + 2].Write(builder, score.Value + ""); } } else { if (Global.ShowCredit) { row.Cells[columnIndex * 2 + 2].Write(builder, Util.GetDegreeEnglish(score.Value)); row.Cells[columnIndex * 2 + 3].Write(builder, weight.Value + ""); } else { row.Cells[columnIndex + 2].Write(builder, Util.GetDegreeEnglish(score.Value)); } } } } #endregion #region 合併相關欄位。 string previousCellDomain = string.Empty; foreach (RowHeader header in indexHeaders) { bool hasGroup = !string.IsNullOrEmpty(Subj.GetDomainGroup(header.Domain)); string groupName = Subj.GetDomainGroup(header.Domain); Row row = table.Rows[header.Index + DataRowOffset]; if (previousCellDomain == row.Cells[0].ToTxt()) { row.Cells[0].CellFormat.VerticalMerge = CellMerge.Previous; } else { row.Cells[0].CellFormat.VerticalMerge = CellMerge.First; } if (header.IsDomain) { if (!hasGroup) { row.Cells[0].CellFormat.HorizontalMerge = CellMerge.First; row.Cells[1].CellFormat.HorizontalMerge = CellMerge.Previous; } } previousCellDomain = row.Cells[0].ToTxt(); } #endregion #endregion }
private void PrintSubjectOnly(DocumentBuilder builder, ReportStudent student, Row template, Table table) { #region 列印科目 UniqueSet <RowHeader> RowIndexs = new UniqueSet <RowHeader>(); #region 列印 RowHeader Dictionary <string, string> subjToDomain = new Dictionary <string, string>(); foreach (SemesterData semester in student.SHistory.GetGradeYearSemester()) { SemesterData sysems = new SemesterData(0, semester.SchoolYear, semester.Semester); if (!student.SemestersScore.Contains(sysems)) { continue; } SemesterScore semsscore = student.SemestersScore[sysems]; foreach (string strSubject in semsscore.Subject) { SemesterSubjectScore subject = semsscore.Subject[strSubject]; if (!subjToDomain.ContainsKey(strSubject)) { subjToDomain.Add(strSubject, subject.Domain); } RowHeader header = new RowHeader(subjToDomain[strSubject], strSubject); header.IsDomain = false; if (!RowIndexs.Contains(header)) { RowIndexs.Add(header); } } } List <RowHeader> sortedHeaders = RowIndexs.ToList(); sortedHeaders.Sort(delegate(RowHeader x, RowHeader y) { Subj xx = new JHSchool.Evaluation.Subject(x.Subject, x.Domain); Subj yy = new JHSchool.Evaluation.Subject(y.Subject, y.Domain); return(xx.CompareTo(yy)); }); //產生 Row。 List <RowHeader> indexHeaders = new List <RowHeader>(); Row current = template; int rowIndex = 0; foreach (RowHeader header in sortedHeaders) { RowHeader indexH = header; indexH.Index = rowIndex++; indexHeaders.Add(indexH); Row datarow = table.InsertBefore(template.Clone(true), current) as Row; string gn = ""; //Additional Classes string subjCName = header.Subject; //string subjEName = Subj.GetSubjectEnglish(header.Subject); string subjEName = _SubjDomainEngNameMapping.GetSubjectEngName(header.Subject); string subjString = header.Subject + (string.IsNullOrEmpty(subjEName) ? "" : " " + subjEName); datarow.Cells[0].Write(builder, subjString); //if (IsFlexible(header.Domain)) //{ // gn = "彈性課程\nAdditional Classes"; // //把空白的領域當成「彈性課程」。 // datarow.Cells[0].Write(builder, gn); // datarow.Cells[1].Write(builder, subjString); //} //else //{ //} } #endregion #region 填資料 //填資料 foreach (RowHeader header in indexHeaders) { SemesterDataCollection semesters = new SemesterDataCollection(); Row row = table.Rows[header.Index + DataRowOffset]; foreach (SemesterData semester in student.SHistory.GetGradeYearSemester()) { SemesterData sysems = new SemesterData(0, semester.SchoolYear, semester.Semester); semesters.Add(sysems); if (!student.SemestersScore.Contains(sysems)) { continue; } if (!student.HeaderList.ContainsKey(sysems)) { continue; } int columnIndex = student.HeaderList[sysems]; SemesterScore semsscore = student.SemestersScore[sysems]; decimal?score = null; decimal?weight = null; //if (header.IsDomain) //{ // if (semsscore.Domain.Contains(header.Domain)) // { // score = semsscore.Domain[header.Domain].Value; // weight = semsscore.Domain[header.Domain].Weight; // } //} //else //{ if (semsscore.Subject.Contains(header.Subject)) { score = semsscore.Subject[header.Subject].Value; weight = semsscore.Subject[header.Subject].Weight; } //} if (!score.HasValue) { continue; } if (!weight.HasValue) { weight = 0; } //if (PrintScore) // row.Cells[columnIndex + 2].Write(builder, score.Value + ""); //else // row.Cells[columnIndex + 2].Write(builder, Util.GetDegreeEnglish(score.Value)); if (PrintScore) { if (Global.ShowCredit) { row.Cells[columnIndex * 2 + 2].Write(builder, score.Value + ""); row.Cells[columnIndex * 2 + 3].Write(builder, weight.Value + ""); } else { row.Cells[columnIndex + 2].Write(builder, score.Value + ""); } } else { if (Global.ShowCredit) { row.Cells[columnIndex * 2 + 2].Write(builder, Util.GetDegreeEnglish(score.Value)); row.Cells[columnIndex * 2 + 3].Write(builder, weight.Value + ""); } else { row.Cells[columnIndex + 2].Write(builder, Util.GetDegreeEnglish(score.Value)); } } } } #endregion #region 合併相關欄位。 string previousCellDomain = string.Empty; foreach (RowHeader header in indexHeaders) { Row row = table.Rows[header.Index + DataRowOffset]; //if (IsFlexible(header.Domain)) //{ // if (previousCellDomain == row.Cells[0].ToTxt()) // row.Cells[0].CellFormat.VerticalMerge = CellMerge.Previous; // else // row.Cells[0].CellFormat.VerticalMerge = CellMerge.First; //} //else { row.Cells[0].CellFormat.HorizontalMerge = CellMerge.First; row.Cells[1].CellFormat.HorizontalMerge = CellMerge.Previous; } previousCellDomain = row.Cells[0].ToTxt(); } #endregion #endregion }
public static void ReadUpdateRecordDate(this IEnumerable <ReportStudent> students, IStatusReporter reporter) { int t1 = Environment.TickCount; Dictionary <string, ReportStudent> dicstudents = students.ToDictionary(); List <string> keys = students.ToSC().ToKeys(); Campus.FunctionSpliter <string, JHUpdateRecordRecord> selectData = new Campus.FunctionSpliter <string, JHUpdateRecordRecord>(500, 5); selectData.Function = delegate(List <string> ps) { return(JHUpdateRecord.SelectByStudentIDs(ps)); }; List <JHUpdateRecordRecord> updaterecords = selectData.Execute(keys); Dictionary <string, List <JHUpdateRecordRecord> > dicupdaterecords = new Dictionary <string, List <JHUpdateRecordRecord> >(); string ValidCodes = "1:2"; //新生:1 轉入:3 復學:6,畢業:2 foreach (JHUpdateRecordRecord each in updaterecords) { //不是要處理的代碼,就跳過。 if (ValidCodes.IndexOf(each.UpdateCode) < 0) { continue; } if (!dicupdaterecords.ContainsKey(each.StudentID)) { dicupdaterecords.Add(each.StudentID, new List <JHUpdateRecordRecord>()); } dicupdaterecords[each.StudentID].Add(each); } foreach (KeyValuePair <string, List <JHUpdateRecordRecord> > each in dicupdaterecords) { each.Value.Sort(delegate(JHUpdateRecordRecord x, JHUpdateRecordRecord y) { DateTime xx, yy; if (!DateTime.TryParse(x.UpdateDate, out xx)) { xx = DateTime.MinValue; } if (!DateTime.TryParse(y.UpdateDate, out yy)) { yy = DateTime.MinValue; } return(xx.CompareTo(yy)); }); } string ECodes = "1"; //入學 string GCodes = "2"; //畢業 foreach (KeyValuePair <string, List <JHUpdateRecordRecord> > each in dicupdaterecords) { if (!dicstudents.ContainsKey(each.Key)) { continue; } ReportStudent student = dicstudents[each.Key]; JHUpdateRecordRecord e = each.Value[0]; JHUpdateRecordRecord g = each.Value[each.Value.Count - 1]; if (ECodes.IndexOf(e.UpdateCode) >= 0) { DateTime dt; if (DateTime.TryParse(e.UpdateDate, out dt)) { student.EntranceDate = string.Format("{0}/{1}/{2}", dt.Year - 1911, dt.Month, dt.Day); student.EngEntranceDate = dt.ToString(Util.EnglishFormat, Util.USCulture); } } if (GCodes.IndexOf(g.UpdateCode) >= 0) { DateTime dt; if (DateTime.TryParse(g.UpdateDate, out dt)) { student.GraduateDate = string.Format("{0}/{1}/{2}", dt.Year - 1911, dt.Month, dt.Day); student.EngGraduateDate = dt.ToString(Util.EnglishFormat, Util.USCulture); } } } Console.WriteLine(Environment.TickCount - t1); }
public bool GetValue(string fieldName, out object fieldValue) { fieldValue = string.Empty; ReportStudent student = Students[Index]; if (fieldName.ToUpper().StartsWith("Fix:".ToUpper())) { fieldValue = student; return(true); } switch (fieldName) { //case "學號": // fieldValue = student.StudentNumber; // break; //case "班級": // fieldValue = student.ClassName; // break; //case "座號": // fieldValue = student.SeatNo; // break; case "姓名": fieldValue = student.Name; break; case "英文姓名": fieldValue = student.EnglishName; break; case "身分證號": fieldValue = student.IDNumber; break; //case "性別": // fieldValue = student.Gender; // break; case "生日": DateTime dtBirthday; if (DateTime.TryParse(student.Birthday, out dtBirthday)) { fieldValue = dtBirthday.ToString(Util.EnglishFormat, Util.USCulture); } else { fieldValue = string.Empty; } break; case "列印日期": DateTime dtPrintDate; if (DateTime.TryParse(PrintDate, out dtPrintDate)) { fieldValue = dtPrintDate.ToString(Util.EnglishFormat, Util.USCulture); } else { fieldValue = string.Empty; } break; case "學校名稱": fieldValue = K12.Data.School.ChineseName; break; case "英文學校名稱": fieldValue = K12.Data.School.EnglishName; break; case "入學日期": if (string.IsNullOrEmpty(Preference.EntranceDate)) { fieldValue = student.EngEntranceDate; } else { DateTime engdt; if (DateTime.TryParse(Preference.EntranceDate, out engdt)) { fieldValue = engdt.ToString(Util.EnglishFormat, Util.USCulture); } else { fieldValue = Preference.EntranceDate; } } break; case "畢業日期": if (string.IsNullOrEmpty(Preference.GraduateDate)) { fieldValue = student.EngGraduateDate; } else { DateTime engdt; if (DateTime.TryParse(Preference.GraduateDate, out engdt)) { fieldValue = engdt.ToString(Util.EnglishFormat, Util.USCulture); } else { fieldValue = Preference.GraduateDate; } } break; case "國籍一": fieldValue = student.nationality1; break; case "國籍一護照名": fieldValue = student.passport_name1; break; case "國籍二": fieldValue = student.nationality2; break; case "國籍二護照名": fieldValue = student.passport_name2; break; case "國籍一英文": fieldValue = student.Enationality1; break; case "國籍二英文": fieldValue = student.Enationality2; break; case "校長": fieldValue = K12.Data.School.Configuration["學校資訊"].PreviousData.SelectSingleNode("ChancellorChineseName").InnerText; break; case "校長英文": fieldValue = K12.Data.School.Configuration["學校資訊"].PreviousData.SelectSingleNode("ChancellorEnglishName").InnerText; break; case "教務主任": fieldValue = K12.Data.School.Configuration["學校資訊"].PreviousData.SelectSingleNode("EduDirectorName").InnerText; break; } return(true); }