private ErrorInfo SaveSumAttendanceData(List <SummaryAttendanceData> list, IWorkbook workbook_old, out IWorkbook workbook)
{
workbook = workbook_old;
var errorinfo = new ErrorInfo();
var otime = new OverTime();
try
{
var sheet = workbook.CreateSheet("Master");
int rowcount = list.Count;
this.GetHeaderAttendanceData_Master(sheet);
for (int i = 0; i < rowcount; i++)
{
var record = new DailyAttendanceData();
IRow row = sheet.CreateRow(i + 1);
ICell cell_GetudoYYYYMM = row.CreateCell(0);
cell_GetudoYYYYMM.SetCellValue(list[i].GetudoYYYYMM);
ICell cell_OverTime = row.CreateCell(1);
string overtime = otime.ConvertOverTimeToString(list[i].OverTime);
cell_OverTime.SetCellValue(overtime);
ICell cell_IS45Over = row.CreateCell(2);
cell_IS45Over.SetCellValue(list[i].Is45Over);
ICell cell_IS80Over = row.CreateCell(3);
cell_IS80Over.SetCellValue(list[i].Is80Over);
}
}
catch (Exception ex)
{
errorinfo.HasError = true;
errorinfo.ErrorReason = ex.Message;
}
return(errorinfo);
}
private ErrorInfo GetHasRecordGetudoYYYYMM(IWorkbook workbook, out List <SummaryAttendanceData> GetudoYYYYMMArray)
{
GetudoYYYYMMArray = new List <SummaryAttendanceData>();
var errorinfo = new ErrorInfo();
try
{
var sheet = workbook.GetSheet("Master");
int lastRow = sheet.LastRowNum;
var list = new List <int>();
for (int i = 1; i <= lastRow; i++)
{
var record = new SummaryAttendanceData();
var otime = new OverTime();
IRow row = sheet.GetRow(i);
ICell cell = row == null ? null : row.GetCell(0);
int intyyyymm = cell == null ? 0 : (int)cell.NumericCellValue;
if (intyyyymm != 0)
{
record.GetudoYYYYMM = intyyyymm;
ICell cell_overtime = row == null ? null : row.GetCell(1);
string string_overtime = cell_overtime == null ? string.Empty : cell_overtime.StringCellValue;
record.OverTime = otime.ConvertOverTime(string_overtime);
ICell cell_is45over = row == null ? null : row.GetCell(2);
bool bool_is45over = cell_is45over == null ? false : cell_is45over.BooleanCellValue;
record.Is45Over = bool_is45over;
ICell cell_is80over = row == null ? null : row.GetCell(3);
bool bool_is80over = cell_is80over == null ? false : cell_is80over.BooleanCellValue;
record.Is80Over = bool_is80over;
GetudoYYYYMMArray.Add(record);
}
}
}
catch (Exception ex)
{
errorinfo.HasError = true;
errorinfo.ErrorReason = ex.Message;
}
return(errorinfo);
}
