using System;
|
using System.Data.OracleClient;
|
using System.Net;
|
using System.Net.Mail;
|
|
namespace CCSTrace.CCS.Function
|
{
|
public class MailService
|
{
|
private SmtpClient _smtpClient;
|
private string _smtpIp;
|
private int _smtpPort;
|
private string _eMailAddr;
|
private string _eMailPass;
|
private string _toEMail;
|
|
public MailService(OracleConnection conn)
|
{
|
InitialSmtpClient(conn);
|
}
|
|
public void InitialSmtpClient(OracleConnection conn)
|
{
|
GetMailSetting(conn);
|
_smtpClient = new SmtpClient(_smtpIp, _smtpPort)
|
{
|
Credentials = new NetworkCredential(_eMailAddr, _eMailPass),
|
EnableSsl = false
|
};
|
}
|
|
public bool SendMail(string ccsid)
|
{
|
Attachment objAttFle = new Attachment(GlobalVariable.CcsListPath + ccsid + ".txt");
|
MailMessage objMail = new MailMessage();
|
|
try
|
{
|
objMail.From = new MailAddress(_eMailAddr);
|
objMail.To.Add(_toEMail);
|
|
objMail.BodyEncoding = System.Text.Encoding.UTF8;
|
objMail.Subject = "CCS事故案件追蹤失敗";
|
//objMail.Body = "測試收件者";
|
objMail.IsBodyHtml = true;
|
|
if (objAttFle != null)
|
objMail.Attachments.Add(objAttFle);
|
|
_smtpClient.Send(objMail);
|
return true;
|
}
|
catch
|
{
|
return false;
|
}
|
}
|
|
private void GetMailSetting(OracleConnection conn)
|
{
|
var 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();
|
|
try
|
{
|
if (reader.Read())
|
{
|
_smtpIp = reader["MAIL_HOST"].ToString();
|
_smtpPort = Convert.ToInt32(reader["MAIL_PORT"].ToString());
|
_eMailAddr = reader["MAIL_ACCOUNT"].ToString();
|
_eMailPass = reader["MAIL_PASSWORD"].ToString();
|
_toEMail = reader["CCS_MAIL"].ToString();
|
}
|
}
|
catch (Exception e)
|
{
|
Console.WriteLine(e.Message);
|
Console.WriteLine(e.StackTrace);
|
}
|
finally
|
{
|
reader.Close();
|
command.Dispose();
|
}
|
}
|
}
|
}
|
