private void Frm_Auditoria_Planilla_P_Load(object sender, EventArgs e)
        {
            BE_Auditoria_Planilla_Ps controls = (BE_Auditoria_Planilla_Ps)BL_ObjControl_Auditoria_Planilla_P.PoblarAuditoria_Planilla_PSelAll();

            if (controls.Count > 0)
            {
                this.EnvioAlertaAuditoriaPlanilla();
                this.Actualizar_Dato_Planilla();
            }

            this.Dispose();
        }
        private string TextoEnvioAlertaPlanilla()
        {
            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 el SUELDO DEL TRABAJADOR.")
                         + "</div><br>" + "<div style='font-size:11px; font-family:Arial;background-color:#E8EAEE; padding:20px'>") + "<table width='610'  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'>MONTO ACTUAL</td>")
                     + "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>MONTO ANTERIOR</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>")
                   + "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>PUESTO</td>"
                   + "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>CENTROCOSTO</td>")
                  + "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>GERENCIA</td>"
                  + "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>AREA</td></tr>";
            try
            {
                enumerator = ((IEnumerable)BL_ObjControl_Auditoria_Planilla_P.PoblarAuditoria_Planilla_PSelAll()).GetEnumerator();
                while (enumerator.MoveNext())
                {
                    BE_Auditoria_Planilla_P current = (BE_Auditoria_Planilla_P)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.MontoLocal + "</td>";
                    str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.MontoLocalA + "</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>";
                    str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Cargo + "</td>";
                    str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.CentroC + "</td>";
                    str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Gerencia + "</td>";
                    str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Area + "</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_Planilla()
        {
            IEnumerator enumerator;

            try
            {
                enumerator = ((IEnumerable)BL_ObjControl_Auditoria_Planilla_P.PoblarAuditoria_Planilla_PSelAll()).GetEnumerator();
                while (enumerator.MoveNext())
                {
                    BE_Auditoria_Planilla_P current = (BE_Auditoria_Planilla_P)enumerator.Current;
                    BL_ObjControl_Auditoria_Planilla_P.ActualizarAuditoria_Planilla_PSelAll(current.IdItem);
                }
            }
            finally
            {
                //if (enumerator is IDisposable)
                //{
                //    (enumerator as IDisposable).Dispose();
                //}
            }
        }