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