예제 #1
0
        private ErrorInfo GetHolidays(string ExcelPath)
        {
            FileStream file;
            ErrorInfo  errorinfo = new ErrorInfo();

            errorinfo = ExcelOperation.OpenExcelFile(ExcelPath, out file);
            if (errorinfo.HasError)
            {
                return(errorinfo);
            }
            errorinfo = GetHolidayList(file, out HolidayList);
            if (errorinfo.HasError)
            {
                return(errorinfo);
            }
            errorinfo = ExcelOperation.ReleaseExcelFile(file);
            return(errorinfo);
        }
예제 #2
0
        public ErrorInfo GetInitAttendanceData(MasterGetudo getudorecord, out List <List <DailyAttendanceData> > attendanceDataBox, out List <SummaryAttendanceData> summaryAttendanceList)
        {
            attendanceDataBox     = new List <List <DailyAttendanceData> >();
            summaryAttendanceList = new List <SummaryAttendanceData>();
            var errorinfo = new ErrorInfo();

            if (getudorecord.GetudoYYYYMM == 0)
            {
                errorinfo.HasError    = true;
                errorinfo.ErrorReason = "月度の値が不正です。";
                return(errorinfo);
            }

            FileStream file;

            errorinfo = ExcelOperation.OpenExcelFile(ExcelPath, out file);
            if (errorinfo.HasError)
            {
                return(errorinfo);
            }
            errorinfo = GetAttendanceDataList(file, out attendanceDataBox, out summaryAttendanceList);
            if (errorinfo.HasError)
            {
                return(errorinfo);
            }
            errorinfo = ExcelOperation.ReleaseExcelFile(file);

            if (!attendanceDataBox.Any() ||
                attendanceDataBox.Count(x => x.Count(r => r.GetudoYYYYMM == getudorecord.GetudoYYYYMM) != 0) == 0)
            {
                var list = new List <DailyAttendanceData>();
                errorinfo = GetInitMonthlyData(getudorecord, out list);
                attendanceDataBox.Add(list);
            }

            return(errorinfo);
        }