예제 #1
0
        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();
            }
        }
예제 #2
0
        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();
            }
        }