Пример #1
0
        public void MontarEmail(string Assunto, string texto)
        {
            DataSet ListaEmail = new DataSet();

            ListaEmail = Controle.ConsultaTabela("SELECT USUARIO,EMAIL FROM USUARIOS WHERE EMAILALTPRD=1 AND RTRIM(EMAIL)<>''");
            if (ListaEmail.Tables[0].Rows.Count > 0)
            {
                Controles.EnviarEmail Enviar = new Controles.EnviarEmail();
                string    Destino            = ListaEmail.Tables[0].Rows[0]["Email"].ToString();
                ArrayList ComCopia           = new ArrayList();
                for (int I = 1; I <= ListaEmail.Tables[0].Rows.Count - 1; I++)
                {
                    ComCopia.Add(ListaEmail.Tables[0].Rows[I]["Email"].ToString());
                }
                Enviar_Email(Assunto, Destino, ComCopia, texto);
            }
        }
Пример #2
0
        public void MontarEmailDist(string Assunto, string texto)
        {
            DataSet ListaEmail = new DataSet();

            ListaEmail = Controle.ConsultaTabela("SELECT RAZAOSOCIAL,EMAIL FROM PESSOAS WHERE NOTIFICAALTPRC=1 AND RTRIM(EMAIL)<>''");
            if (ListaEmail.Tables[0].Rows.Count > 0)
            {
                Controles.EnviarEmail Enviar = new Controles.EnviarEmail();
                //string Destino = "*****@*****.**";
                string    Destino  = ListaEmail.Tables[0].Rows[0]["Email"].ToString();
                ArrayList ComCopia = new ArrayList();
                for (int I = 1; I <= ListaEmail.Tables[0].Rows.Count - 1; I++)
                {
                    ComCopia.Add(ListaEmail.Tables[0].Rows[I]["Email"].ToString());
                }
                Enviar_Email(Assunto, Destino, ComCopia, texto);
            }
        }