/// <summary> /// 透過異動名冊ID取得異動名冊內學生異動資料List /// </summary> /// <param name="ID"></param> /// <returns></returns> public static List <StudUpdateRecDoc> StudUpdateRecDocListByID(string ID) { List <StudUpdateRecDoc> retVal = new List <StudUpdateRecDoc>(); StudUpdateRecBatchRec surbr = DAL.DALTransfer.GetStudUpdateRecBatchRec(ID); retVal = surbr.StudUpdateRecDocList; return(retVal); }
public ReportSelector(StudUpdateRecBatchRec BRec) { _BRec = BRec; if (_BRec == null) { return; } }
/// <summary> /// 產生報表 /// </summary> public void Print() { // 取得異動名冊畫面上所選擇異動名冊ID _SelectBRecID = UpdateRecordModule_SH_N.BL.Get.UpdateBatchSelectID(); // 透過異動名冊ID取得異動名冊 _SelectBRec = UpdateRecordModule_SH_N.BL.Get.StudUpdateRecBatchRecByID(_SelectBRecID); try { BackgroundWorker _bwN; #region 進校名冊呼叫 progressBarX1.Value = 0; pnlReport.Visible = true; _bwN = new BackgroundWorker(); _bwN.DoWork += new DoWorkEventHandler(_bwN_DoWork); _bwN.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_bwN_RunWorkerCompleted); _bwN.ProgressChanged += new ProgressChangedEventHandler(_bwN_ProgressChanged); _bwN.WorkerReportsProgress = true; for (int i = 0; i <= 100; i++) { _bwN.ReportProgress(i); } _bwN.RunWorkerAsync(); #endregion // 產生異動名冊的過程,系統佔用之記憶體,回收之 GC.Collect(); GC.WaitForPendingFinalizers(); GC.Collect(); } catch (Exception ex) { FISCA.Presentation.Controls.MsgBox.Show("產生電子報表失敗." + ex.Message); } }
public SH_N_All_List(UpdateRecordModule_SH_N.BL.StudUpdateRecBatchRec SelectBRec) { _SelectBRec = SelectBRec; if (_SelectBRec == null) { return; } // 取得國中所在地代碼與名稱對照 Dictionary <string, string> SchoolLocationCodeNameDict = Util.GetJHSchooLocationNameDict(); // 讀取異動名冊內學生異動資料 Dictionary <string, List <UpdateRecordModule_SH_N.BL.StudUpdateRecDoc> > UpdateBook = new Dictionary <string, List <UpdateRecordModule_SH_N.BL.StudUpdateRecDoc> >(); foreach (UpdateRecordModule_SH_N.BL.StudUpdateRecDoc rec in _SelectBRec.StudUpdateRecDocList) { if (UpdateBook.ContainsKey(rec.DeptCode + "_" + rec.GradeYear)) { UpdateBook[rec.DeptCode + "_" + rec.GradeYear].Add(rec); } else { UpdateBook.Add(rec.DeptCode + "_" + rec.GradeYear, new List <UpdateRecordModule_SH_N.BL.StudUpdateRecDoc>()); UpdateBook[rec.DeptCode + "_" + rec.GradeYear].Add(rec); } } System.Data.DataSet UpdateBookRecord = new DataSet("DataSection"); Dictionary <string, List <DataSet> > UpdateBookSet = new Dictionary <string, List <DataSet> >(); UpdateBookSet.Add("名冊", new List <DataSet>()); foreach (string DeptCode_Year in UpdateBook.Keys) { int rowCount = 1; int TotalPeople = 0; DataTable dataTable = new DataTable(); DataRow row = dataTable.NewRow(); foreach (UpdateRecordModule_SH_N.BL.StudUpdateRecDoc rec in UpdateBook[DeptCode_Year]) { //名冊內容 //表頭 if (rowCount == 1) { // 校名 dataTable = new DataTable("校名"); dataTable.Columns.Add("校名"); row = dataTable.NewRow(); row["校名"] = _SelectBRec.SchoolName; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); //學年度 dataTable = new DataTable("學年度"); dataTable.Columns.Add("學年度"); row = dataTable.NewRow(); row["學年度"] = _SelectBRec.SchoolYear; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); //學年期 dataTable = new DataTable("學期"); dataTable.Columns.Add("學期"); row = dataTable.NewRow(); row["學期"] = _SelectBRec.Semester; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); //代碼 dataTable = new DataTable("代碼"); dataTable.Columns.Add("代碼"); row = dataTable.NewRow(); row["代碼"] = _SelectBRec.SchoolCode + "-" + UpdateBook[DeptCode_Year][0].DeptCode; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); if (_SelectBRec.UpdateType == "學籍異動名冊" || _SelectBRec.UpdateType == "轉入學生名冊") { //年級 dataTable = new DataTable("年級"); dataTable.Columns.Add("年級"); row = dataTable.NewRow(); row["年級"] = UpdateBook[DeptCode_Year][0].GradeYear; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); } //科別 dataTable = new DataTable("科別"); dataTable.Columns.Add("科別"); row = dataTable.NewRow(); row["科別"] = UpdateBook[DeptCode_Year][0].Department; //rec.Department; // dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); dataTable = new DataTable("名冊內容"); UpdateBookRecord.Tables.Add(dataTable); switch (_SelectBRec.UpdateType) { case "學籍異動名冊": dataTable.Columns.Add("原學號"); dataTable.Columns.Add("姓名"); dataTable.Columns.Add("身份證字號"); dataTable.Columns.Add("學籍異動年月文號"); dataTable.Columns.Add("代號"); dataTable.Columns.Add("原因或事項"); dataTable.Columns.Add("異動日期"); dataTable.Columns.Add("備註"); break; case "畢業名冊": dataTable.Columns.Add("學號姓名"); dataTable.Columns.Add("性別1"); dataTable.Columns.Add("性别2"); dataTable.Columns.Add("出生年月日身份證字號"); dataTable.Columns.Add("代號"); dataTable.Columns.Add("學籍異動年月文號"); dataTable.Columns.Add("畢業證書字號"); dataTable.Columns.Add("備註"); break; case "新生名冊": dataTable.Columns.Add("學號"); dataTable.Columns.Add("姓名"); dataTable.Columns.Add("身份證字號"); dataTable.Columns.Add("性別1"); dataTable.Columns.Add("性别2"); dataTable.Columns.Add("出年年月日"); dataTable.Columns.Add("入學資格代碼"); dataTable.Columns.Add("入學資格"); dataTable.Columns.Add("備註"); break; case "轉入學生名冊": dataTable.Columns.Add("新學號姓名"); dataTable.Columns.Add("身份證字號"); dataTable.Columns.Add("性別1"); dataTable.Columns.Add("性別2"); dataTable.Columns.Add("出年年月日"); dataTable.Columns.Add("學校"); dataTable.Columns.Add("科別代號"); dataTable.Columns.Add("學籍異動"); dataTable.Columns.Add("年級"); dataTable.Columns.Add("代號"); dataTable.Columns.Add("原因"); dataTable.Columns.Add("年月日"); break; } } //DataTable dataTable = new DataTable(); switch (_SelectBRec.UpdateType) { case "學籍異動名冊": row = dataTable.NewRow(); row["原學號"] = rec.StudentNumber; row["姓名"] = rec.StudentName; row["身份證字號"] = rec.IDNumber; row["學籍異動年月文號"] = Util.ConvertDateStr2(rec.LastADDate) + "\n" + rec.LastADNumber; row["代號"] = rec.UpdateCode; row["原因或事項"] = rec.UpdateDescription; row["異動日期"] = Util.ConvertDateStr2(rec.UpdateDate); row["備註"] = rec.Comment; UpdateBookRecord.Tables["名冊內容"].Rows.Add(row); break; case "畢業名冊": row = dataTable.NewRow(); row["學號姓名"] = rec.StudentNumber + "\n" + rec.StudentName; row["性別1"] = rec.GenderCode; row["性别2"] = rec.Gender; row["出生年月日身份證字號"] = Util.ConvertDateStr2(rec.Birthday) + "\n" + rec.IDNumber; row["代號"] = rec.LastUpdateCode; row["學籍異動年月文號"] = Util.ConvertDateStr2(rec.LastADDate) + "\n" + rec.LastADNumber; row["畢業證書字號"] = rec.GraduateCertificateNumber; row["備註"] = rec.Comment; UpdateBookRecord.Tables["名冊內容"].Rows.Add(row); break; case "新生名冊": row = dataTable.NewRow(); row["學號"] = rec.StudentNumber; row["姓名"] = rec.StudentName; row["身份證字號"] = rec.IDNumber; row["性別1"] = rec.GenderCode; row["性别2"] = rec.Gender; row["出年年月日"] = Util.ConvertDateStr2(rec.Birthday); row["入學資格代碼"] = rec.GraduateSchoolLocationCode + "\n" + rec.UpdateCode; string strGradeType = " 畢"; if (rec.UpdateCode == "003") { strGradeType = " 修"; } if (rec.UpdateCode == "004") { strGradeType = " 結"; } if (string.IsNullOrEmpty(rec.GraduateSchool)) { strGradeType = ""; } if (SchoolLocationCodeNameDict.ContainsKey(rec.GraduateSchoolLocationCode)) { row["入學資格"] = SchoolLocationCodeNameDict[rec.GraduateSchoolLocationCode] + rec.GraduateSchool + strGradeType + "\n"; } else { row["入學資格"] = rec.GraduateSchool + strGradeType + "\n"; } row["備註"] = rec.Comment;; UpdateBookRecord.Tables["名冊內容"].Rows.Add(row); break; case "轉入學生名冊": row = dataTable.NewRow(); row["新學號姓名"] = rec.StudentNumber + "\n" + rec.StudentName; row["身份證字號"] = rec.IDNumber; row["性別1"] = rec.GenderCode; row["性別2"] = rec.Gender; row["出年年月日"] = Util.ConvertDateStr2(rec.Birthday); row["學校"] = rec.PreviousSchool; row["科別代號"] = rec.OldDepartmentCode + "\n" + rec.PreviousDepartment; row["學籍異動"] = Util.ConvertDateStr2(rec.LastADDate) + "\n" + rec.LastADNumber; string strSem = ""; if (!string.IsNullOrEmpty(rec.PreviousSemester)) { int i; if (int.TryParse(rec.PreviousSemester, out i)) { if (i == 1) { strSem = "上"; } else { strSem = "下"; } } else { strSem = rec.PreviousSemester; } } row["年級"] = rec.PreviousGradeYear + "\n" + strSem; row["代號"] = rec.UpdateCode; row["原因"] = rec.UpdateDescription; row["年月日"] = Util.ConvertDateStr2(rec.UpdateDate); UpdateBookRecord.Tables["名冊內容"].Rows.Add(row); break; } TotalPeople++; rowCount++; if (rowCount > 16) { UpdateBookSet["名冊"].Add(UpdateBookRecord); UpdateBookRecord = new DataSet("DataSection"); rowCount = 1; } } ////名冊內容 ////表頭 if (rowCount == 1) { // 校名 dataTable = new DataTable("校名"); dataTable.Columns.Add("校名"); row = dataTable.NewRow(); row["校名"] = _SelectBRec.SchoolName; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); //學年度 dataTable = new DataTable("學年度"); dataTable.Columns.Add("學年度"); row = dataTable.NewRow(); row["學年度"] = _SelectBRec.SchoolYear; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); //學年期 dataTable = new DataTable("學期"); dataTable.Columns.Add("學期"); row = dataTable.NewRow(); row["學期"] = _SelectBRec.Semester; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); //代碼 dataTable = new DataTable("代碼"); dataTable.Columns.Add("代碼"); row = dataTable.NewRow(); row["代碼"] = _SelectBRec.SchoolCode + "-" + UpdateBook[DeptCode_Year][0].DeptCode; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); if (_SelectBRec.UpdateType == "學籍異動名冊" || _SelectBRec.UpdateType == "轉入學生名冊") { //年級 dataTable = new DataTable("年級"); dataTable.Columns.Add("年級"); row = dataTable.NewRow(); row["年級"] = UpdateBook[DeptCode_Year][0].GradeYear; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); } //科別 dataTable = new DataTable("科別"); dataTable.Columns.Add("科別"); row = dataTable.NewRow(); row["科別"] = UpdateBook[DeptCode_Year][0].Department; dataTable.Rows.Add(row); UpdateBookRecord.Tables.Add(dataTable); dataTable = new DataTable("名冊內容"); UpdateBookRecord.Tables.Add(dataTable); switch (_SelectBRec.UpdateType) { case "學籍異動名冊": dataTable.Columns.Add("原學號"); dataTable.Columns.Add("姓名"); dataTable.Columns.Add("身份證字號"); dataTable.Columns.Add("學籍異動年月文號"); dataTable.Columns.Add("代號"); dataTable.Columns.Add("原因或事項"); dataTable.Columns.Add("異動日期"); dataTable.Columns.Add("備註"); break; case "畢業名冊": dataTable.Columns.Add("學號姓名"); dataTable.Columns.Add("性別1"); dataTable.Columns.Add("性别2"); dataTable.Columns.Add("出生年月日身份證字號"); dataTable.Columns.Add("學籍異動年月文號"); dataTable.Columns.Add("代號"); dataTable.Columns.Add("畢業證書字號"); dataTable.Columns.Add("備註"); break; case "新生名冊": dataTable.Columns.Add("學號"); dataTable.Columns.Add("姓名"); dataTable.Columns.Add("身份證字號"); dataTable.Columns.Add("性別1"); dataTable.Columns.Add("性别2"); dataTable.Columns.Add("出年年月日"); dataTable.Columns.Add("入學資格代碼"); dataTable.Columns.Add("入學資格"); dataTable.Columns.Add("備註"); break; case "轉入學生名冊": dataTable.Columns.Add("新學號姓名"); dataTable.Columns.Add("身份證字號"); dataTable.Columns.Add("性別1"); dataTable.Columns.Add("性別2"); dataTable.Columns.Add("學校"); dataTable.Columns.Add("科別代號"); dataTable.Columns.Add("學籍異動"); dataTable.Columns.Add("年級"); dataTable.Columns.Add("代號"); dataTable.Columns.Add("原因"); dataTable.Columns.Add("年月日"); break; } } switch (_SelectBRec.UpdateType) { case "學籍異動名冊": row = dataTable.NewRow(); row["原學號"] = "合計"; row["姓名"] = TotalPeople + "名"; UpdateBookRecord.Tables["名冊內容"].Rows.Add(row); break; case "畢業名冊": row = dataTable.NewRow(); row["學號姓名"] = "合計"; row["性別1"] = TotalPeople + "名"; UpdateBookRecord.Tables["名冊內容"].Rows.Add(row); break; case "新生名冊": row = dataTable.NewRow(); row["學號"] = "合計"; row["姓名"] = TotalPeople + "名"; UpdateBookRecord.Tables["名冊內容"].Rows.Add(row); break; case "轉入學生名冊": row = dataTable.NewRow(); row["新學號姓名"] = "合計"; row["身份證字號"] = TotalPeople + "名"; UpdateBookRecord.Tables["名冊內容"].Rows.Add(row); break; } UpdateBookSet["名冊"].Add(UpdateBookRecord); UpdateBookRecord = new DataSet("DataSection"); } //產生異動名冊 MemoryStream _defaultTemplate = new MemoryStream(); ReportTemplate _Template; string workSheetName = "上傳電子檔"; // 以下這樣寫電子檔是因為ReportHelper寫法無法支援,所以使用原來 Aspose.Cell 寫法先讀取樣板將電子檔寫好,再傳給用ReportHelper使用。 switch (_SelectBRec.UpdateType) { case "學籍異動名冊": Workbook wb1 = new Workbook(); wb1.Open(new MemoryStream(Properties.Resources.異動學生名冊_進校)); try { Worksheet wst1 = wb1.Worksheets[workSheetName]; // 異動名冊電子檔 int row = 1; foreach (UpdateRecordModule_SH_N.BL.StudUpdateRecDoc rec in _SelectBRec.StudUpdateRecDocList) { // 班別 wst1.Cells[row, 0].PutValue(rec.ClassType); // 科別代碼 wst1.Cells[row, 1].PutValue(rec.DeptCode); // 學號 wst1.Cells[row, 2].PutValue(rec.StudentNumber); // 姓名 wst1.Cells[row, 3].PutValue(rec.StudentName); // 身份證字號 wst1.Cells[row, 4].PutValue(rec.IDNumber); // 註1 wst1.Cells[row, 5].PutValue(rec.IDNumberComment); // 性別代碼 wst1.Cells[row, 6].PutValue(rec.GenderCode); // 出生日期 wst1.Cells[row, 7].PutValue(Util.ConvertDate1(rec.Birthday)); // 特殊身份代碼 wst1.Cells[row, 8].PutValue(rec.SpecialStatus); // 年級 wst1.Cells[row, 9].PutValue(rec.GradeYear); // 異動原因代碼 wst1.Cells[row, 10].PutValue(rec.UpdateCode); // 異動日期 wst1.Cells[row, 11].PutValue(Util.ConvertDate1(rec.UpdateDate)); // 原備查日期 wst1.Cells[row, 12].PutValue(Util.ConvertDate1(rec.LastADDate)); // 原備查文字 wst1.Cells[row, 13].PutValue(Util.GetDocNo_Doc(rec.LastADNumber)); // 原備查文號 wst1.Cells[row, 14].PutValue(Util.GetDocNo_No(rec.LastADNumber)); // 舊班別 wst1.Cells[row, 15].PutValue(rec.OldClassType); // 舊科別代碼 wst1.Cells[row, 16].PutValue(rec.OldDepartmentCode); // 更正後資料 wst1.Cells[row, 17].PutValue(rec.NewData); // 備註說明 wst1.Cells[row, 18].PutValue(rec.Comment); row++; } _defaultTemplate = wb1.SaveToStream(); //_Template = new ReportTemplate(_defaultTemplate.ToArray(), DocumentType.Excel); ReportSaveExcel(ReportHelper.Report.Produce(UpdateBookSet, _defaultTemplate), _SelectBRec.UpdateType); //Report.Produce(UpdateBookSet, true, @_SelectBRec.UpdateType + ".xls", _Template, false); } catch (Exception ex) { FISCA.Presentation.Controls.MsgBox.Show(ex.Message); } break; case "畢業名冊": Workbook wb2 = new Workbook(); wb2.Open(new MemoryStream(Properties.Resources.畢業學生名冊_進校)); try { Worksheet wst2 = wb2.Worksheets[workSheetName]; // 畢業名冊電子檔 int row = 1; foreach (UpdateRecordModule_SH_N.BL.StudUpdateRecDoc rec in _SelectBRec.StudUpdateRecDocList) { // 班別 wst2.Cells[row, 0].PutValue(rec.ClassType); // 科別代碼 wst2.Cells[row, 1].PutValue(rec.DeptCode); // 學號 wst2.Cells[row, 2].PutValue(rec.StudentNumber); // 姓名 wst2.Cells[row, 3].PutValue(rec.StudentName); // 身份證字號 wst2.Cells[row, 4].PutValue(rec.IDNumber); // 註1 wst2.Cells[row, 5].PutValue(rec.IDNumberComment); // 性別代碼 wst2.Cells[row, 6].PutValue(rec.GenderCode); // 出生日期 wst2.Cells[row, 7].PutValue(Util.ConvertDate1(rec.Birthday)); // 畢業證書字號 wst2.Cells[row, 8].PutValue(rec.GraduateCertificateNumber); // 備註說明 wst2.Cells[row, 9].PutValue(rec.Comment); // 最後一次異動代碼 wst2.Cells[row, 10].PutValue(rec.LastUpdateCode); // 最後通過文字號 wst2.Cells[row, 11].PutValue(rec.LastADNumber); // 中辦審核通過公文日期 wst2.Cells[row, 12].PutValue(Util.ConvertDate1(rec.LastADDate)); row++; } _defaultTemplate = wb2.SaveToStream(); //_Template = new ReportTemplate(_defaultTemplate.ToArray(), DocumentType.Excel); ReportSaveExcel(ReportHelper.Report.Produce(UpdateBookSet, _defaultTemplate), _SelectBRec.UpdateType); } catch (Exception ex) { FISCA.Presentation.Controls.MsgBox.Show(ex.Message); } break; case "新生名冊": Workbook wb3 = new Workbook(); wb3.Open(new MemoryStream(Properties.Resources.新生學生名冊_進校)); try { Worksheet wst3 = wb3.Worksheets[workSheetName]; // 新生名冊電子檔 int row = 1; foreach (UpdateRecordModule_SH_N.BL.StudUpdateRecDoc rec in _SelectBRec.StudUpdateRecDocList) { // 班別 wst3.Cells[row, 0].PutValue(rec.ClassType); // 科別代碼 wst3.Cells[row, 1].PutValue(rec.DeptCode); // 學號 wst3.Cells[row, 2].PutValue(rec.StudentNumber); // 姓名 wst3.Cells[row, 3].PutValue(rec.StudentName); // 身份證字號 wst3.Cells[row, 4].PutValue(rec.IDNumber); // 註1 wst3.Cells[row, 5].PutValue(rec.IDNumberComment); // 性別代碼 wst3.Cells[row, 6].PutValue(rec.GenderCode); // 出生日期 wst3.Cells[row, 7].PutValue(Util.ConvertDate1(rec.Birthday)); // 特殊身份代碼 wst3.Cells[row, 8].PutValue(rec.SpecialStatus); // 資格代碼 wst3.Cells[row, 9].PutValue(rec.UpdateCode); // 入學資格(學校名稱) if (SchoolLocationCodeNameDict.ContainsKey(rec.GraduateSchoolLocationCode)) { wst3.Cells[row, 10].PutValue(SchoolLocationCodeNameDict[rec.GraduateSchoolLocationCode] + rec.GraduateSchool); } else { wst3.Cells[row, 10].PutValue(rec.GraduateSchool); } // 註2 wst3.Cells[row, 11].PutValue(rec.GraduateComment); // 國中畢業年度 wst3.Cells[row, 12].PutValue(rec.GraduateSchoolYear); // 備註說明 wst3.Cells[row, 13].PutValue(rec.Comment); row++; } _defaultTemplate = wb3.SaveToStream(); //_Template = new ReportTemplate(_defaultTemplate.ToArray(), DocumentType.Excel); ReportSaveExcel(ReportHelper.Report.Produce(UpdateBookSet, _defaultTemplate), _SelectBRec.UpdateType); } catch (Exception ex) { FISCA.Presentation.Controls.MsgBox.Show(ex.Message); } break; case "轉入學生名冊": Workbook wb4 = new Workbook(); wb4.Open(new MemoryStream(Properties.Resources.轉入學生名冊_進校)); try { Worksheet wst4 = wb4.Worksheets[workSheetName]; // 轉入名冊電子檔 int row = 1; foreach (UpdateRecordModule_SH_N.BL.StudUpdateRecDoc rec in _SelectBRec.StudUpdateRecDocList) { // 班別 wst4.Cells[row, 0].PutValue(rec.ClassType); // 科別代碼 wst4.Cells[row, 1].PutValue(rec.DeptCode); // 學號 wst4.Cells[row, 2].PutValue(rec.StudentNumber); // 姓名 wst4.Cells[row, 3].PutValue(rec.StudentName); // 身份證字號 wst4.Cells[row, 4].PutValue(rec.IDNumber); // 註1 wst4.Cells[row, 5].PutValue(rec.IDNumberComment); // 性別代碼 wst4.Cells[row, 6].PutValue(rec.GenderCode); // 出生日期 wst4.Cells[row, 7].PutValue(Util.ConvertDate1(rec.Birthday)); // 特殊身份代碼 wst4.Cells[row, 8].PutValue(rec.SpecialStatus); // 年級 wst4.Cells[row, 9].PutValue(rec.GradeYear); // 異動原因代碼 wst4.Cells[row, 10].PutValue(rec.UpdateCode); // 轉入日期 wst4.Cells[row, 11].PutValue(Util.ConvertDate1(rec.UpdateDate)); // 原備查日期 wst4.Cells[row, 12].PutValue(Util.ConvertDate1(rec.PreviousSchoolLastADDate)); // 原備查文字 wst4.Cells[row, 13].PutValue(Util.GetDocNo_Doc(rec.PreviousSchoolLastADNumber)); // 原備查文號 wst4.Cells[row, 14].PutValue(Util.GetDocNo_No(rec.PreviousSchoolLastADNumber)); // 原學校代碼 wst4.Cells[row, 15].PutValue(rec.PreviousSchool); // 原科別代碼 wst4.Cells[row, 16].PutValue(rec.PreviousDepartment); // 原學號 wst4.Cells[row, 17].PutValue(rec.PreviousStudentNumber); // 原年級 wst4.Cells[row, 18].PutValue(rec.PreviousGradeYear); // 原學期 wst4.Cells[row, 19].PutValue(rec.PreviousSemester); // 備註說明 wst4.Cells[row, 20].PutValue(rec.Comment); row++; } _defaultTemplate = wb4.SaveToStream(); // _Template = new ReportTemplate(_defaultTemplate.ToArray(), DocumentType.Excel); ReportSaveExcel(ReportHelper.Report.Produce(UpdateBookSet, _defaultTemplate), _SelectBRec.UpdateType); } catch (Exception ex) { FISCA.Presentation.Controls.MsgBox.Show(ex.Message); } break; } }