public void SendEmail(EmailInfo emailInfo)
{
if (emailInfo == null)
{
emailInfo = GetEntityFromXml();
if (emailInfo == null)
{
string err = "emailInfo is null";
_log.Fatal(err);
}
}
try
{
_sqlHelper.BeginTran();
#region 额外由数据库表生成的附件
var attList = _sqlHelper.Reader<AttachmentInfo>(@"select ID,storenum,childName,childGender,childAge,parentPhone,reachAddress,curriculumName
from tmpDTTalentAcademy where ISNULL(IsSendEmail,0)<>1");
_sqlHelper.ExecuteNonQuery("update tmpDTTalentAcademy set IsSendEmail=1");
if (attList.Count > 0)
{
string attFileRemark = _currentPath + "说明.txt";
string attFile = _currentPath + "CustomerCallBack.xlsx";
//ExcelHelper.SaveDataToExcel<AttachmentInfo>(attList, attFile);
ExcelAsposeHelper.OutFileToDisk<AttachmentInfo>(attList, "客户反馈", attFile);
System.Threading.Thread.Sleep(200);
emailInfo.AttachmentList.Add(attFileRemark);
emailInfo.AttachmentList.Add(attFile);
}
#endregion
EmailHelper emailHelper = new EmailHelper(emailInfo.SendServer, emailInfo.UserName, emailInfo.Password,
emailInfo.DisplayName, emailInfo.ToName, emailInfo.ToEmail, emailInfo.ToSubject, emailInfo.AttachmentList, emailInfo.ToBody);
_log.Info(emailInfo.ToEmail);
emailHelper.SendEmail();
_sqlHelper.CommitTran();
_log.Info("邮件发送成功！");
}
catch (Exception ex)
{
_log.Fatal(ex);
_sqlHelper.RollBackTran();
}
}
public void SendEmail(EmailInfo emailInfo)
{
if (emailInfo == null)
{
emailInfo = GetEntityFromXml();
if (emailInfo == null)
{
string err = "emailInfo is null";
_log.Fatal(err);
}
}
try
{
_sqlHelper.BeginTran();
#region 额外由数据库表生成的附件
var attList = _sqlHelper.Reader<AttachmentInfo>(@"select a.ID ,storeno.name as storenum ,a.childName ,a.childGender ,a.childAge ,a.parentPhone ,
a.reachAddress ,a.curriculumName,a.distance,a.submittime
from tmpDTTalentAcademy a left join storeno on a.storenum= storeno.number where ISNULL(IsSendEmail,0)<>1");
List<string> colNameList = new List<string>();
colNameList.Add("序号");
colNameList.Add("填写门店");
colNameList.Add("宝贝姓氏");
colNameList.Add("宝贝性别");
colNameList.Add("宝贝年龄");
colNameList.Add("家长手机号码");
colNameList.Add("可到门店");
colNameList.Add("课程");
colNameList.Add("距离门店");
colNameList.Add("填写时间");
_sqlHelper.ExecuteNonQuery("update tmpDTTalentAcademy set IsSendEmail=1");
if (attList.Count > 0)
{
string attFileRemark = _currentPath + "说明.txt";
string attFile = _currentPath + "客户资料.xlsx";
//ExcelHelper.SaveDataToExcel<AttachmentInfo>(attList, "客户反馈",attFile);
//ExcelAsposeHelper.OutFileToDisk<AttachmentInfo>(attList, "客户反馈", attFile);
ExcelEPPHelper.SaveDataToExcel<AttachmentInfo>(attList, "客户资料", attFile, colNameList);
System.Threading.Thread.Sleep(200);
//emailInfo.AttachmentList.Add(attFileRemark);
emailInfo.AttachmentList.Add(attFile);
}
#endregion
EmailHelper emailHelper = new EmailHelper(emailInfo.SendServer, emailInfo.UserName, emailInfo.Password,
emailInfo.DisplayName, emailInfo.ToName, emailInfo.ToEmail, emailInfo.ToSubject, emailInfo.AttachmentList, emailInfo.ToBody,emailInfo.ToNoDataBody);
_log.Info(emailInfo.ToEmail);
emailHelper.SendEmail();
_sqlHelper.CommitTran();
_log.Info("邮件发送成功！");
}
catch (Exception ex)
{
_log.Fatal(ex);
_sqlHelper.RollBackTran();
}
}