private void Frm_OC_SIn_Aprobar_Load(object sender, EventArgs e)
        {
            BE_OC_SIn_Aprobars controls = (BE_OC_SIn_Aprobars)BL_ObjControl_OC_SIn_Aprobar.PoblarOC_SIn_AprobarSelAll();

            if (controls.Count > 0)
            {
                this.EnvioAlertaOCSinAprobar2();
            }
            this.Dispose();
        }
        private string TextoEnvioAlertaOCSinAprobar()
        {
            IEnumerator enumerator;
            string      str = "<html>";

            str = ((((((((((((((str + "<body><center> " + "<div style='font-size:11px; font-family:Arial; text-align:left; padding:10px; width:850px;'>") +
                               "<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 S10.") + "</div><br>" +
                              "<div style='font-size:11px; font-family:Arial;background-color:#E8EAEE; padding:20px'>") + "<table width='1300'  cellpadding='3'>" +
                             "<tr><td colspan='2'>") + "<hr /> </td></tr>" +
                            "<tr><td width='400' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>PROYECTO</td>") +
                           "<td width='30' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>NRO_ORDEN</td>" +
                           "<td width='90' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>TIPO</td>") +
                          "<td width='50' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>FORMA_PAGO</td>" +
                          "<td width='40' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>MONEDA</td>") +
                         "<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>VALOR_NETO</td>" +
                         "<td width='180' valign='top' style='text-align:center;background-color:#FF5733;font-size:8px; font-family:Arial'>ESTADO_OC/S</td>") +
                        "<td width='40' valign='top' style='text-align:center;background-color:#DDDDDD; font-size:8px; font-family:Arial'>RUC_PROVEEDOR</td>" +
                        "<td width='40' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>PROVEEDOR</td>") +
                       "<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>LUGAR_ENTREGA</td>" +
                       "<td width='180' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>FECHA_ORDEN</td>") +
                      "<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>FECHA_ENTREGA</td>" +
                      "<td width='180' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>PROCEDENCIA</td>") +
                     "<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>CENTRO_COMPRA</td>" +
                     "<td width='180' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>USUARIO_CREADOR</td>") +
                    "<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>USUARIO_ACTUALIZADOR</td>" +
                    "<td width='180' valign='top' style='text-align:center;background-color:#FF5733;font-size:8px; font-family:Arial'>FECHA_ENVIO_APROBACIÓN</td>") +
                   "<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>USUARIO_APROBADOR</td>" +
                   "<td width='180' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>COMPRADOR</td>") +
                  "<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>OBSERVACION</td></tr>";
            try
            {
                enumerator = ((IEnumerable)BL_ObjControl_OC_SIn_Aprobar.PoblarOC_SIn_AprobarSelAll()).GetEnumerator();
                while (enumerator.MoveNext())
                {
                    BE_OC_SIn_Aprobar current = (BE_OC_SIn_Aprobar)enumerator.Current;
                    str = str + "<tr><td width='400' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'>" + current.Proyecto + "</td>";
                    str = str + "<td width='30' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.NroOrden + "</td>";
                    str = str + "<td width='90' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Tipo + "</td>";
                    str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.FormaPago + "</td>";
                    str = str + "<td width='40' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'>" + current.Moneda + "</td>";
                    str = str + "<td width='70' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.ValorNeto + "</td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'> " + current.EstadoOC + "</td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.ProveedorRUC + "</td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Proveedor + "</td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.LugarEntrega + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.FechaOrden + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.FechaEntrega + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Procedencia + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.CentroCompra + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.CreacionUsuario + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.ActualizacionUsuario + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'> " + current.FechaEnvioAprobacion + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.UsuarioAprobador + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Comprador + " </td>";
                    str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Observacion + " </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>");
        }