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 GetAttendanceData(IWorkbook workbook, int item, out List <DailyAttendanceData> attendanceDataList)
{
var errorinfo = new ErrorInfo();
attendanceDataList = new List <DailyAttendanceData>();
try
{
var sheet = workbook.GetSheet(item.ToString());
if (sheet == null)
{
return(errorinfo);
}
int lastRow = sheet.LastRowNum;
for (int i = 1; i <= lastRow; i++)
{
var record = new DailyAttendanceData();
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_date = row == null ? null : row.GetCell(1);
string string_date = cell_date == null ? string.Empty : cell_date.DateCellValue.ToShortDateString();
DateTime date;
DateTime.TryParse(string_date, out date);
record.Day = date;
ICell cell_daykbn = row == null ? null : row.GetCell(2);
double daykbn = cell_daykbn == null ? 0 : cell_daykbn.NumericCellValue;
record.DayKBN = (EnumManager.DayKBN)((int)daykbn);
ICell cell_PlanMMSS_Start = row == null ? null : row.GetCell(3);
string plammmss_st = cell_PlanMMSS_Start == null ? null : cell_PlanMMSS_Start.StringCellValue;
record.PlanMMSS_Start = string.IsNullOrEmpty(plammmss_st) ? (int?)null : int.Parse(plammmss_st);
ICell cell_PlanMMSS_End = row == null ? null : row.GetCell(4);
string plammmss_end = cell_PlanMMSS_End == null ? null : cell_PlanMMSS_End.StringCellValue;
record.PlanMMSS_END = string.IsNullOrEmpty(plammmss_end) ? (int?)null : int.Parse(plammmss_end);
ICell cell_ResultMMSS_Start = row == null ? null : row.GetCell(5);
string resultmmss_st = cell_ResultMMSS_Start == null ? null : cell_ResultMMSS_Start.StringCellValue;
record.ResultMMSS_Start = string.IsNullOrEmpty(resultmmss_st) ? (int?)null : int.Parse(resultmmss_st);
ICell cell_ResultMMSS_End = row == null ? null : row.GetCell(6);
string resultmmss_end = cell_ResultMMSS_End == null ? null : cell_ResultMMSS_End.StringCellValue;
record.ResultMMSS_END = string.IsNullOrEmpty(resultmmss_end) ? (int?)null : int.Parse(resultmmss_end);
ICell cell_Bikou = row == null ? null : row.GetCell(7);
record.Bikou = cell_Bikou == null ? string.Empty : cell_Bikou.StringCellValue;
attendanceDataList.Add(record);
}
}
}
catch (Exception ex)
{
errorinfo.HasError = true;
errorinfo.ErrorReason = ex.Message;
}
return(errorinfo);
}
private void AvoidanceAttendanceData(List <DispDailyAttendanceData> displist)
{
var list = new List <DailyAttendanceData>();
foreach (var item in displist)
{
var record = new DailyAttendanceData();
record.ConvertToData(item);
list.Add(record);
}
this.AttendanceDataBox.Add(list);
}
public List <DispDailyAttendanceData> RefrectionBackNumberCell(List <DispDailyAttendanceData> list)
{
foreach (var item in list)
{
var sub = new DailyAttendanceData();
sub.ConvertToData(item);
item.PlanMMSS_Start = sub.PlanMMSS_Start;
item.PlanMMSS_END = sub.PlanMMSS_END;
item.ResultMMSS_Start = sub.ResultMMSS_Start;
item.ResultMMSS_END = sub.ResultMMSS_END;
}
return(list);
}
public ErrorInfo GetInitMonthlyData(MasterGetudo getudorecord, out List <DailyAttendanceData> monthlyattendancelist)
{
monthlyattendancelist = new List <DailyAttendanceData>();
var errorinfo = new ErrorInfo();
if (getudorecord.GetudoYYYYMM == 0)
{
errorinfo.HasError = true;
errorinfo.ErrorReason = "月度の値が不正です。";
return(errorinfo);
}
//祝日マスタの読み込み
var holidaylist = new List <MasterHoliday>();
var holidays = new Holidays();
holidays.ExcelPath = ExcelPath_Holidays;
errorinfo = holidays.GetHolidaysByGetudoRecord(getudorecord, out holidaylist);
if (errorinfo.HasError)
{
return(errorinfo);
}
for (DateTime date = getudorecord.StartDate; date <= getudorecord.EndDate; date = date.AddDays(1))
{
var attendancerecord = new DailyAttendanceData();
attendancerecord.GetudoYYYYMM = getudorecord.GetudoYYYYMM;
attendancerecord.Day = date;
var holiday = holidaylist.Find(x => x.Day == date);
if (holiday != null)
{
attendancerecord.DayKBN = EnumManager.DayKBN.HolyDay;
attendancerecord.Bikou = holiday.HolidayName;
}
else
{
attendancerecord.DayKBN = this.GetDayKBN(date);
}
monthlyattendancelist.Add(attendancerecord);
}
return(errorinfo);
}
private ErrorInfo SaveExcelSheet(int getudoyyyymm, List <DailyAttendanceData> item, IWorkbook workbook_old, out IWorkbook workbook)
{
workbook = workbook_old;
var errorinfo = new ErrorInfo();
try
{
var sheet = workbook.CreateSheet(getudoyyyymm.ToString());
int rowcount = item.Count;
this.GetHeaderAttendanceData(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(item[i].GetudoYYYYMM);
ICell cell_Day = row.CreateCell(1);
cell_Day.SetCellValue(item[i].Day);
ICell cell_DayKBN = row.CreateCell(2);
cell_DayKBN.SetCellValue((int)item[i].DayKBN);
ICell cell_PlanMMSS_Start = row.CreateCell(3);
cell_PlanMMSS_Start.SetCellValue(item[i].PlanMMSS_Start.ToString());
ICell cell_PlanMMSS_END = row.CreateCell(4);
cell_PlanMMSS_END.SetCellValue(item[i].PlanMMSS_END.ToString());
ICell cell_ResultMMSS_Start = row.CreateCell(5);
cell_ResultMMSS_Start.SetCellValue(item[i].ResultMMSS_Start.ToString());
ICell cell_ResultMMSS_END = row.CreateCell(6);
cell_ResultMMSS_END.SetCellValue(item[i].ResultMMSS_END.ToString());
ICell cell_Bikou = row.CreateCell(7);
cell_Bikou.SetCellValue(item[i].Bikou);
}
}
catch (Exception ex)
{
errorinfo.HasError = true;
errorinfo.ErrorReason = ex.Message;
}
return(errorinfo);
}