private int SortStudent(StudRecord x, StudRecord y)
{
//年級
string studentA = x.GradeYear.PadLeft(3, '0');
string studentB = y.GradeYear.PadLeft(3, '0');
//排序
studentA += x.ClassNumber.PadLeft(3, '0');
studentB += y.ClassNumber.PadLeft(3, '0');
//名稱
studentA += x.ClassName.PadLeft(10, '0');
studentB += y.ClassName.PadLeft(10, '0');
studentA += x.SeatNo.PadLeft(2, '0');
studentB += y.SeatNo.PadLeft(2, '0');
studentA += x.StudentName.PadLeft(10, '0');
studentB += y.StudentName.PadLeft(10, '0');
return(studentA.CompareTo(studentB));
}
private void SetWorksheets(Workbook book, StudRecord SR, int sheetIndex, int rowIndex)
{
book.Worksheets[sheetIndex].Cells.CreateRange(rowIndex, 1, false).CopyStyle(RangeRow);
book.Worksheets[sheetIndex].Cells.CreateRange(rowIndex, 1, false).CopyValue(RangeRow);
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["班級"]].PutValue(SR.ClassName);
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["學號"]].PutValue(SR.StudentNumber);
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["座號"]].PutValue(SR.SeatNo);
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["姓名"]].PutValue(SR.StudentName);
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["本期大功"]].PutValue(CByZero(SR.本期大功));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["本期小功"]].PutValue(CByZero(SR.本期小功));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["本期嘉獎"]].PutValue(CByZero(SR.本期嘉獎));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["本期大過"]].PutValue(CByZero(SR.本期大過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["本期小過"]].PutValue(CByZero(SR.本期小過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["本期警告"]].PutValue(CByZero(SR.本期警告));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年大功"]].PutValue(CByZero(SR.歷年大功));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年小功"]].PutValue(CByZero(SR.歷年小功));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年嘉獎"]].PutValue(CByZero(SR.歷年嘉獎));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年大過"]].PutValue(CByZero(SR.歷年大過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年小過"]].PutValue(CByZero(SR.歷年小過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年警告"]].PutValue(CByZero(SR.歷年警告));
if (_IsAtoB換算)
{
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過換算大功"]].PutValue(CByZero(SR.歷年功過換算大功));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過換算小功"]].PutValue(CByZero(SR.歷年功過換算小功));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過換算嘉獎"]].PutValue(CByZero(SR.歷年功過換算嘉獎));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過換算大過"]].PutValue(CByZero(SR.歷年功過換算大過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過換算小過"]].PutValue(CByZero(SR.歷年功過換算小過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過換算警告"]].PutValue(CByZero(SR.歷年功過換算警告));
}
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年銷過大過"]].PutValue(CByZero(SR.歷年銷過大過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年銷過小過"]].PutValue(CByZero(SR.歷年銷過小過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年銷過警告"]].PutValue(CByZero(SR.歷年銷過警告));
if (_IsAtoB相抵)
{
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過相抵大功"]].PutValue(CByZero(SR.歷年功過相抵大功));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過相抵小功"]].PutValue(CByZero(SR.歷年功過相抵小功));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過相抵嘉獎"]].PutValue(CByZero(SR.歷年功過相抵嘉獎));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過相抵大過"]].PutValue(CByZero(SR.歷年功過相抵大過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過相抵小過"]].PutValue(CByZero(SR.歷年功過相抵小過));
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["歷年功過相抵警告"]].PutValue(CByZero(SR.歷年功過相抵警告));
}
foreach (string att in SR.AttendanceDic.Keys)
{
if (ColumnInTitleIndex.ContainsKey(att))
{
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex[att]].PutValue(SR.AttendanceDic[att]);
}
}
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["是否留查"]].PutValue(SR.是否留查 ? "是" : "");
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["是否全勤"]].PutValue(SR.是否全勤 ? "是" : "");
//本筆資料的確定源
book.Worksheets[sheetIndex].Cells[rowIndex, ColumnInTitleIndex["備註"]].PutValue(string.Join(",\n", SR.RemarkList));
}
