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