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