[c#]代码库
public static void SendMailLocalhost(string MailType,XmlOpseae Opseae)
{
System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage();
//首先获取发件人 发件公司 发件邮箱(委托方) // 收件人 收件公司 收件邮箱（承运方）
var strSql = new StringBuilder();
strSql.Append(" select case AUDITOR WHEN '' then ");
strSql.Append(" (select email from userinfo where userid in (select userid from login where companyID=FORWARDER) and departmentID='CompanyMaster') ");
strSql.Append(" else (select email from userinfo where userid=AUDITOR) end ReceiverEmail ");
strSql.Append(" ,case AUDITOR WHEN '' then ");
strSql.Append(" (select username from userinfo where userid in (select userid from login where companyID=FORWARDER) and departmentID='CompanyMaster') ");
strSql.Append(" else (select username from userinfo where userid=AUDITOR) end Receivername ");
strSql.Append(" ,u.username sendername,u.email senderEmail ");
strSql.Append(" ,(select fullname from company where companyid=bcs.forwarder) receiverCompany ");
strSql.Append(" ,(select fullname from company where companyid=bcs.companyid) sendercompany ");
strSql.Append(" ,(select Mobile from userinfo where userid=bcs.inputby) senderMobile ");
strSql.Append(" ,(select Mobile from userinfo where userid=bcs.Auditor) receiverMobile ");
strSql.Append(" ,bcs.* ");
strSql.Append(" from BookingCargoSpace bcs ");
strSql.Append(" left join userinfo U on u.userid = bcs.inputby ");
strSql.Append(" where bsno='" + Opseae.BSNO + "' ");
DataSet ds = new DataSet();
Database db = DatabaseFactory.CreateDatabase();
var SenderName = "";
var SenderEmail = "";
var SenderCompany = "";
var SenderMobile = "";
var ReceiverName = "";
var ReceiverEmail = "";
var ReceiverCompany = "";
var ReceiverMobile = "";
var EmailText = new StringBuilder();
var EmailTitle = new StringBuilder();
try
{
using (IDataReader reader = db.ExecuteReader(CommandType.Text, strSql.ToString()) )
{
while (reader.Read())
{
SenderName = Convert.ToString(reader["SenderName"]);
SenderEmail = Convert.ToString(reader["SenderEmail"]);
SenderCompany = Convert.ToString(reader["SenderCompany"]);
SenderMobile = Convert.ToString(reader["SenderMobile"]);
ReceiverName = Convert.ToString(reader["ReceiverName"]);
ReceiverEmail = Convert.ToString(reader["ReceiverEmail"]);
ReceiverCompany = Convert.ToString(reader["ReceiverCompany"]);
ReceiverMobile = Convert.ToString(reader["ReceiverMobile"]);
EmailTitle.Clear();
EmailTitle.Append("");
}
reader.Close();
}
}
catch (Exception)
{
}
finally
{
}
if (MailType == "拒绝订舱" || MailType == "待定" || MailType == "拒绝提单确认")
{
msg.To.Add( SenderEmail);
msg.From = new MailAddress(ReceiverEmail, ReceiverName, System.Text.Encoding.UTF8);
}
else {
msg.To.Add(ReceiverEmail);
msg.From = new MailAddress(SenderEmail, SenderName, System.Text.Encoding.UTF8);
}
/* 上面3个参数分别是发件人地址（可以随便写），发件人姓名，编码*/
var Subject = "";
var Body = new StringBuilder();
if (MailType == "订舱") {
Subject = " 订舱:From "+SenderCompany;
if (Opseae.ETD!="")
Subject = Subject+" 船期"+Opseae.ETD;
if (Opseae.CNTR != "")
Subject = Subject + " 箱型箱量" + Opseae.CNTR;
if (Opseae.DESTINATION != "")
Subject = Subject + " 目的地" + Opseae.DESTINATION;
//Body.Append(Subject);
Body.Append("<html> <Body>订舱公司：" + SenderCompany);
Body.Append("<br />订舱人：" + SenderName + " 电话:" + SenderMobile + " 邮箱:" + SenderEmail);
if (Opseae.CNTR != "")
Body.Append("<br />箱型箱量：" + Opseae.CNTR);
if (Opseae.ETD != "")
Body.Append("<br />船期：" + Opseae.ETD);
if (Opseae.CNTR != "")
Body.Append("<br />目的地：" + Opseae.DESTINATION);
if (Opseae.BOOKINGDESCRIPTION != "")
Body.Append("<br />订舱说明：" + Opseae.BOOKINGDESCRIPTION);
}
if (MailType == "退舱")
{
Subject = " 退舱申请:From " + SenderCompany;
if (Opseae.ETD != "")
Subject = Subject + " 船期" + Opseae.ETD;
if (Opseae.CNTR != "")
Subject = Subject + " 箱型箱量" + Opseae.CNTR;
if (Opseae.DESTINATION != "")
Subject = Subject + " 目的地" + Opseae.DESTINATION;
Body.Append("<html> <Body>");
Body.Append("<br />您好，我公司希望撤回通过ShippingBox所订的此条业务，原因如下：<br />" + REHH(Opseae.PendingReason));
Body.Append("<br />订舱公司:" + SenderCompany);
Body.Append("<br />订舱人：" + SenderName + " 电话:" + SenderMobile + " 邮箱:" + SenderEmail);
if (Opseae.CNTR != "")
Body.Append("<br />箱型箱量：" + Opseae.CNTR);
if (Opseae.ETD != "")
Body.Append("<br />船期：" + Opseae.ETD);
if (Opseae.CNTR != "")
Body.Append("<br />目的地：" + Opseae.DESTINATION);
if (Opseae.BOOKINGDESCRIPTION != "")
Body.Append("<br />订舱说明：" + Opseae.BOOKINGDESCRIPTION);
}
if (MailType == "拒绝订舱")
{
Subject = " 拒绝订舱提醒:From " + ReceiverCompany;
if (Opseae.ETD != "")
Subject = Subject + " 船期" + Opseae.ETD;
if (Opseae.CNTR != "")
Subject = Subject + " 箱型箱量" + Opseae.CNTR;
if (Opseae.DESTINATION != "")
Subject = Subject + " 目的地" + Opseae.DESTINATION;
Body.Append("<html> <Body>");
Body.Append("<br />您好，您通过ShippingBox所订业务被拒绝，理由如下：<br />" + REHH(Opseae.PendingReason));
Body.Append("<br />订舱代理公司：" + ReceiverCompany);
Body.Append("<br />操作人：" + ReceiverName + " 电话:" + ReceiverMobile + " 邮箱:" + ReceiverEmail);
if (Opseae.CNTR != "")
Body.Append("<br />箱型箱量：" + Opseae.CNTR);
if (Opseae.ETD != "")
Body.Append("<br />船期：" + Opseae.ETD);
if (Opseae.CNTR != "")
Body.Append("<br />目的地：" + Opseae.DESTINATION);
if (Opseae.BOOKINGDESCRIPTION != "")
Body.Append("<br />订舱说明：" + Opseae.BOOKINGDESCRIPTION);
}
if (MailType == "待定")
{
Subject = " 订舱被待定:From " + SenderCompany;
if (Opseae.ETD != "")
Subject = Subject + " 船期" + Opseae.ETD;
if (Opseae.CNTR != "")
Subject = Subject + " 箱型箱量" + Opseae.CNTR;
if (Opseae.DESTINATION != "")
Subject = Subject + " 目的地" + Opseae.DESTINATION;
//Body.Append(Subject);
Body.Append("<html> <Body>接收订舱公司：" + SenderCompany);
Body.Append("<br />操作人：" + SenderName + " 电话:" + SenderMobile + " 邮箱:" + SenderEmail);
if (Opseae.CNTR != "")
Body.Append("<br />箱型箱量：" + Opseae.CNTR);
if (Opseae.ETD != "")
Body.Append("<br />船期：" + Opseae.ETD);
if (Opseae.CNTR != "")
Body.Append("<br />目的地：" + Opseae.DESTINATION);
if (Opseae.BOOKINGDESCRIPTION != "")
Body.Append("<br />订舱说明：" + Opseae.BOOKINGDESCRIPTION);
if (Opseae.PendingReason != "")
Body.Append("<br />待定理由：" + REHH(Opseae.PendingReason));
}
if (MailType == "拒绝提单确认")
{
Subject = " 拒绝提单确认:From " + ReceiverCompany;
if (Opseae.ETD != "")
Subject = Subject + " 船期" + Opseae.ETD;
if (Opseae.CNTR != "")
Subject = Subject + " 箱型箱量" + Opseae.CNTR;
if (Opseae.DESTINATION != "")
Subject = Subject + " 目的地" + Opseae.DESTINATION;
Body.Append("<html> <Body>");
Body.Append("<br />您好，您通过ShippingBox所提交提单确认被拒绝，理由如下：<br />" + REHH(Opseae.PendingReason));
Body.Append("<br />订舱代理公司：" + ReceiverCompany);
Body.Append("<br />操作人：" + ReceiverName + " 电话:" + ReceiverMobile + " 邮箱:" + ReceiverEmail);
if (Opseae.CNTR != "")
Body.Append("<br />箱型箱量：" + Opseae.CNTR);
if (Opseae.ETD != "")
Body.Append("<br />船期：" + Opseae.ETD);
if (Opseae.CNTR != "")
Body.Append("<br />目的地：" + Opseae.DESTINATION);
if (Opseae.BOOKINGDESCRIPTION != "")
Body.Append("<br />订舱说明：" + Opseae.BOOKINGDESCRIPTION);
}
Body = SetBottom(Body, Opseae.BSNO);
msg.Subject = Subject;//邮件标题
msg.SubjectEncoding = System.Text.Encoding.UTF8;//邮件标题编码
msg.Body = Body.ToString();//邮件内容
msg.BodyEncoding = System.Text.Encoding.UTF8;//邮件内容编码
msg.IsBodyHtml = true;//是否是HTML邮件
msg.Priority = MailPriority.High;//邮件优先级
var content = "";
AlternateView htmlBody = AlternateView.CreateAlternateViewFromString(content, null, "text/html");
/*
LinkedResource lrImage = new LinkedResource(@"D:\DSWebservice\a.jpg", "image/gif");
lrImage.ContentId = "Email001";
htmlBody.LinkedResources.Add(lrImage);
msg.AlternateViews.Add(htmlBody);*/
SmtpClient client = new SmtpClient();
client.Credentials = new System.Net.NetworkCredential("admin@dongshengsoft.com", "ds!@#)(*");
//在71info.com注册的邮箱和密码
client.Host = "smtpcom.263xmail.com";
object userState = msg;
var Result = "";
try
{
//client.SendAsync(msg, userState);
//简单一点儿可以
client.Send(msg);
//MessageBox.Show("发送成功");
}
catch (System.Net.Mail.SmtpException ex)
{
Result = ex.Message;
}
}
public static void SendMSGMail ( XmlMSGInfo Mail )
{
System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage();
//首先获取发件人 发件公司 发件邮箱(委托方) // 收件人 收件公司 收件邮箱（承运方）
var strSql = new StringBuilder();
strSql.Append(" select M.*,S.userName S_userName,S.mobile S_mobile,S.email S_email,S.fullName S_Company ");
strSql.Append(" ,r.userName R_userName,r.mobile R_mobile,r.email R_email,R.fullName R_Company from BookingMSG m ");
strSql.Append(" left join vw_user S on s.userID=m.SENDERID ");
strSql.Append(" left join vw_user R on R.userID=m.RECEIVERID ");
strSql.Append(" where BSNO='" + Mail.BSNO + "' and MSGDate='" + Mail.MSGDate + "' ");
DataSet ds = new DataSet();
Database db = DatabaseFactory.CreateDatabase();
var SenderName = "";
var SenderEmail = "";
var SenderCompany = "";
var SenderMobile = "";
var ReceiverName = "";
var ReceiverEmail = "";
var ReceiverCompany = "";
var ReceiverMobile = "";
var BSNO = "";
var EmailText = new StringBuilder();
var EmailTitle = new StringBuilder();
try
{
using (IDataReader reader = db.ExecuteReader(CommandType.Text, strSql.ToString()))
{
while (reader.Read())
{
SenderName = Convert.ToString(reader["S_userName"]);
SenderEmail = Convert.ToString(reader["S_email"]);
SenderCompany = Convert.ToString(reader["S_Company"]);
SenderMobile = Convert.ToString(reader["S_mobile"]);
ReceiverName = Convert.ToString(reader["R_userName"]);
ReceiverEmail = Convert.ToString(reader["R_email"]);
ReceiverCompany = Convert.ToString(reader["R_Company"]);
ReceiverMobile = Convert.ToString(reader["R_mobile"]);
BSNO = Convert.ToString(reader["BSNO"]);
EmailTitle.Clear();
EmailTitle.Append("");
}
reader.Close();
}
}
catch (Exception)
{
}
finally
{
}
msg.To.Add(ReceiverEmail);
msg.From = new MailAddress(SenderEmail, SenderName, System.Text.Encoding.UTF8);
var Subject = "";
var Body = new StringBuilder();
var Opseae = GetBookingCargoSpace(BSNO);
Subject = " 沟通消息: " + SenderCompany;
if (Opseae.VESSEL != "")
Subject = Subject + "--" + Opseae.VESSEL;
if (Opseae.VOYNO != "")
Subject = Subject + "--" + Opseae.VOYNO;
if (Opseae.MBLNO != "")
Subject = Subject + "--" + Opseae.MBLNO;
if (Opseae.ETD != "")
Subject = Subject + "--" + Opseae.ETD;
if (Opseae.CNTR != "")
Subject = Subject + "--" + Opseae.CNTR;
if (Opseae.DESTINATION != "")
Subject = Subject + "--" + Opseae.DESTINATION;
//Body.Append(Subject);
Body.Append("<html> <Body>关于 ");
if (Opseae.VESSEL != "")
Body.Append("--" + Opseae.VESSEL);
if (Opseae.VOYNO != "")
Body.Append( "--" + Opseae.VOYNO);
if (Opseae.MBLNO != "")
Body.Append( "--" + Opseae.MBLNO);
if (Opseae.ETD != "")
Body.Append( "--" + Opseae.ETD);
if (Opseae.CNTR != "")
Body.Append( "--" + Opseae.CNTR);
if (Opseae.DESTINATION != "")
Body.Append( "--" + Opseae.DESTINATION);
Body.Append("：<br />" + REHH( Mail.FieldValue));
Body.Append("<br /><br />联系人：" + SenderName + " 电话:" + SenderMobile + " 邮箱:" + SenderEmail);
Body = SetBottom(Body, Opseae.BSNO);
msg.Subject = Subject;//邮件标题
msg.SubjectEncoding = System.Text.Encoding.UTF8;//邮件标题编码
msg.Body = Body.ToString();//邮件内容
msg.BodyEncoding = System.Text.Encoding.UTF8;//邮件内容编码
msg.IsBodyHtml = true;//是否是HTML邮件
msg.Priority = MailPriority.High;//邮件优先级
var content = "";
AlternateView htmlBody = AlternateView.CreateAlternateViewFromString(content, null, "text/html");
SmtpClient client = new SmtpClient();
client.Credentials = new System.Net.NetworkCredential("admin@dongshengsoft.com", "ds!@#)(*");
//在71info.com注册的邮箱和密码
client.Host = "smtpcom.263xmail.com";
object userState = msg;
var Result = "";
try
{
//client.SendAsync(msg, userState);
//简单一点儿可以
client.Send(msg);
//MessageBox.Show("发送成功");
}
catch (System.Net.Mail.SmtpException ex)
{
Result = ex.Message;
}
}
会python真的可以为所欲为0(回)
3天前
这里还有人吗1(回)
188天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
413天前
鸽子
0(回)
497天前
by: 发表于：2017-12-18 09:39:32 顶(0) | 踩(0) 回复
？？
回复评论