private string TextoEnvioAlertaVacaciones()
        {
            IEnumerator enumerator;
            string      str = "<html>";

            str = ((((((((str + "<body><center> " + "<div style='font-size:11px; font-family:Arial; text-align:left; padding:10px; width:650px;'>") +
                         "<br><div style='padding-left:30px; padding-right:30px; text-align:justify'><strong>Estimado(a) usuario(a):</strong>" +
                         "<br>El listado presentado a continuacion son los que deben ser corroborado en ERP SPRING, en las Vacaciones del TRABAJADOR.") +
                        "</div><br>" + "<div style='font-size:11px; font-family:Arial;background-color:#E8EAEE; padding:20px'>") + "<table width='730'  cellpadding='7'>" +
                       "<tr><td colspan='2'>") + "<hr /> </td></tr>" + "<tr><td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>CODIGO</td>") +
                     "<td width='230' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>NOMBRE</td>" +
                     "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>PERIODO</td>") +
                    "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>DERECHO</td>" +
                    "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>UTILIZADO</td>") +
                   "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>PENDIENTE</td>" +
                   "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>USUARIO</td>") +
                  "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>MAQUINA</td>" +
                  "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>FECHA</td></tr>";
            try
            {
                enumerator = ((IEnumerable)BL_ObjControl_Auditoria_Vacaciones_Personal.PoblarAuditoria_Vacaciones_PersonalSelAll()).GetEnumerator();
                while (enumerator.MoveNext())
                {
                    BE_Auditoria_Vacaciones_Personal current = (BE_Auditoria_Vacaciones_Personal)enumerator.Current;
                    str = str + "<tr><td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Codigo + "</td>";
                    str = str + "<td width='230' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.Nombre + "</td>";
                    str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.Periodo + "</td>";
                    str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.Derecho + "</td>";
                    str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.Utilizado + "</td>";
                    str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.Pendiente + "</td>";
                    str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.CodUser + "</td>";
                    str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.IP + "</td>";
                    str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Fecha + "</td></tr>";
                }
            }
            finally
            {
                //if (enumerator is IDisposable)
                //{
                //    (enumerator as IDisposable).Dispose();
                //}
            }
            return(((str + "</table>" + "</div>") + "<hr /><div style='font-size:10px; padding-left:30px; padding-right:30px'>" +
                    "<strong><em>QLABSP Investors</em></strong><br><br>") +
                   //"<strong><em>Nexos Comerciales S.A</em></strong><br><br>") +
                   "<strong>P.D:</strong> Este correo es solo para confirmar el estado de recepcion. Agradeceremos no responderlo.</div> </div>" +
                   "</center></body></html>");
        }
        private void Actualizar_Dato_Vacaciones()
        {
            IEnumerator enumerator;

            try
            {
                enumerator = ((IEnumerable)BL_ObjControl_Auditoria_Vacaciones_Personal.PoblarAuditoria_Vacaciones_PersonalSelAll()).GetEnumerator();
                while (enumerator.MoveNext())
                {
                    BE_Auditoria_Vacaciones_Personal current = (BE_Auditoria_Vacaciones_Personal)enumerator.Current;
                    BL_ObjControl_Auditoria_Vacaciones_Personal.ActualizarAuditoria_Vacaciones_PersonalSelAll(current.IdItem);
                }
            }
            finally
            {
                //if (enumerator is IDisposable)
                //{
                //    (enumerator as IDisposable).Dispose();
                //}
            }
        }
        private void Frm_Auditoria_Vacaciones_Personal_Load(object sender, EventArgs e)
        {
            BE_Auditoria_Vacaciones_Personals controls = (BE_Auditoria_Vacaciones_Personals)BL_ObjControl_Auditoria_Vacaciones_Personal.PoblarAuditoria_Vacaciones_PersonalSelAll();

            if (controls.Count > 0)
            {
                this.EnvioAlertaAuditoriaVacaciones();
                this.Actualizar_Dato_Vacaciones();
            }

            this.Dispose();
        }