public void Leave_Attendance_Cal(string EMP_ID, DateTime date1, DateTime date2, SqlConnection con) { //Tạm thời chỉ tính cho Primacy, Bowker //if (PublicFunction.CUS_ID == "99" || PublicFunction.CUS_ID == "100") { DateTime date = date1; while (date <= date2 && date <= DateTime.Today) { AttendanceHelper.Attendance_Calc(EMP_ID, date.ToString("yyyy/MM/dd"), con, "TBLDETAILSATTENDANCE"); date = date.AddDays(1); } } }
public void Leave_Attendance_Cal(string EMP_ID, DateTime dtO1, DateTime dtO2, DateTime dtN1, DateTime dtN2, SqlConnection con) { DateTime dtMin = dtO1, dtMax = dtO1; if (dtMin > dtO2) { dtMin = dtO2; } if (dtMin > dtN1) { dtMin = dtN1; } if (dtMin > dtN2) { dtMin = dtN2; } if (dtMax < dtO2) { dtMax = dtO2; } if (dtMax < dtN1) { dtMax = dtN1; } if (dtMax < dtN2) { dtMax = dtN2; } DateTime date = dtMin; while (date <= dtMax && date <= DateTime.Today) { if (date >= dtO1 && date <= dtO2 || date >= dtN1 && date <= dtN2) { AttendanceHelper.Attendance_Calc(EMP_ID, date.ToString("yyyy/MM/dd"), con, "TBLDETAILSATTENDANCE"); } date = date.AddDays(1); } }