private void AvoidSummaryData(string overtime, double?getudoyyyymm) { if (getudoyyyymm == null) { return; } var o = new OverTime(); var timespan_overtime = o.ConvertDispOverTime(overtime); int i = 0; if (int.TryParse(overtime.Replace(":", ""), out i)) { i = i / 100; } foreach (var item in this.SummaryAttendance) { if (item.GetudoYYYYMM == (int)getudoyyyymm) { item.OverTime = timespan_overtime; item.Is45Over = i >= 45; item.Is80Over = i >= 80; return; } } var record = new SummaryAttendanceData(); record.GetudoYYYYMM = (int)getudoyyyymm; record.OverTime = timespan_overtime; record.Is45Over = i >= 45; record.Is80Over = i >= 80; return; }
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); }