Merge remote-tracking branch 'origin/usestp'

ulysseskao

2016-05-05 540014a7702a9bae7a3b9c00098671a132e869e8

 CCSTrace/CCS/Function/MailService.cs

@@ -17,9 +17,8 @@
        private string _eMailPass;

        private string _toEMail;



        public MailService(OracleConnection conn)

        public MailService()

        {

            InitialSmtpClient(conn);

        }



        public void InitialSmtpClient(OracleConnection conn)

@@ -47,8 +46,7 @@
                //objMail.Body = "測試收件者";

                objMail.IsBodyHtml = true;



                if (objAttFle != null)

                    objMail.Attachments.Add(objAttFle);

                objMail.Attachments.Add(objAttFle);



                _smtpClient.Send(objMail);

                return true;

@@ -61,7 +59,7 @@


        private void GetMailSetting(OracleConnection conn)

        {

            var sqlStmt = "SELECT MAIL_ACCOUNT,MAIL_PASSWORD,MAIL_HOST,MAIL_PORT,WOS_MAIL FROM USRADMIN.SYS_MAIL";

            const string sqlStmt = "SELECT MAIL_ACCOUNT,MAIL_PASSWORD,MAIL_HOST,MAIL_PORT,WOS_MAIL FROM USRADMIN.SYS_MAIL";



            OracleCommand command = new OracleCommand(sqlStmt, conn);

            OracleDataReader reader = command.ExecuteReader();