/// <summary> /// 发送邮件 /// </summary> /// <param name="dataTable"></param> private void SendMail(List <ProductSaleInfo> entities) { string dateString = DateTime.Now.Date.Year.ToString() + "-" + DateTime.Now.Date.Month.ToString() + "-" + DateTime.Now.Date.Day.ToString(); MailInfo mail = new MailInfo(); ExcelManage excelm = new ExcelManage(); string filePath = excelm.WriteToFile(entities); mail.FromName = Settings.EmailFrom; mail.ToName = Settings.EmailAddress; mail.Subject = Settings.MailSubject + DateTime.Now.Date.ToShortDateString(); mail.Body = Settings.MailBody; mail.IsHtmlType = false; mail.Attachments = new List <string>(); mail.Attachments.Add(filePath); mail.IsAsync = false; mail.IsInternal = true; try { MailHelper.SendEmail(mail); MailDA.SendEmail(mail.ToName, mail.Subject, mail.Body, 1); } catch { MailDA.SendEmail(mail.ToName, mail.Subject, mail.Body, -1); } }
public void SendCustomeReport() { CustomerInfoDal dal = new CustomerInfoDal(); List <CustomerInfo> list = dal.GetCustomerInfo(); ExcelManage excel = new ExcelManage(); string excelFile = excel.WriteExcel(list); MailInfo mailInfo = new MailInfo { FromName = Settings.EmailFrom, ToName = Settings.EmailAddress, CCName = Settings.MailCC, Subject = Settings.MailSubject, Body = Settings.MailBody, IsAsync = false, IsInternal = true, Attachments = new List <string>() }; mailInfo.Attachments.Add(excelFile); bool isuccess = MailHelper.SendEmail(mailInfo); if (isuccess) { MailDA.SendEmail(Settings.EmailAddress, Settings.MailSubject, Settings.MailBody, 1); } else { MailDA.SendEmail(Settings.EmailAddress, Settings.MailSubject, Settings.MailBody, -1); } }
public static bool SendMail(string payTypeDesc, int SOSysNo, decimal so, decimal ar, decimal invoice) { string subject = Settings.MailSubject + "-" + SOSysNo.ToString(); string mailBody = GetMailBody(payTypeDesc, SOSysNo, so, ar, invoice); string address = Settings.EmailAddress; return(MailDA.SendEmail(SOSysNo, address, subject, mailBody)); }
public static void SendMail(string subject, string mailBody, int status) { MailDA.SendEmail(Settings.EmailAddress, subject, mailBody, status); }
private static void SendEmailForData(ZeroConfirmSOIncomeJobResp response) { if (response == null) { return; } DateTime nowTime = DateTime.Now; string emailModelPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, Settings.EmailModel); string emailBody = ReadFile(emailModelPath); emailBody = emailBody.Replace("#DateTime#", nowTime.ToString("yyyy-MM-dd HH:mm:ss")); List <ConfirmEntity> emailList = new List <ConfirmEntity>(); response.Result.ForEach(x => { var s = AutoConfirm.GetEmailData(Convert.ToInt32(x.SysNo)); var confirmInfo = "确认成功"; if (x.ErrorDescription != null) { confirmInfo = x.ErrorDescription; } string confirmedID = Settings.UserLoginName; emailList.Add(new ConfirmEntity { SoSysNo = s.SoSysNo, PayTerms = s.PayTerms, OrderAmt = s.OrderAmt, IncomeAmt = s.IncomeAmt, PrepayAmt = s.PrepayAmt, PointPayAmt = s.PointPayAmt, GiftCardPayAmt = s.GiftCardPayAmt, ConfirmedDate = s.ConfirmedDate, ConfirmedInfo = confirmInfo, CofirmedID = confirmedID }); }); MailInfo mail = new MailInfo(); string fileName = "ZeroAutoConfirm" + nowTime.ToString(Settings.ShortDateFormat) + ".xls"; string filePath = new ExcelSend().WriteToFile(emailList, fileName, nowTime); mail.FromName = Settings.EmailFrom; mail.ToName = Settings.EmailAddress; mail.Subject = string.Format(Settings.EmailSubject, nowTime.ToString(Settings.ShortDateFormat)); mail.Body = emailBody; mail.IsHtmlType = false; mail.Attachments = new List <string>(); mail.Attachments.Add(filePath); mail.IsAsync = false; mail.IsInternal = true; try { MailHelper.SendEmail(mail); MailDA.SendEmail(mail.ToName, mail.Subject, mail.Body, 1); OnShowInfo("邮件发送成功"); } catch { MailDA.SendEmail(mail.ToName, mail.Subject, mail.Body, -1); OnShowInfo("邮件发送失败"); } }
public static void SendMail(string mailto, string subject, string mailBody, int status) { MailDA.SendEmail(mailto, subject, mailBody, status); }
private static void CreateData(XmlDocument xmlResult, string AttachInfo2) { var zfbDA = new ZFBDA(); var entityList = new List <ZFBDataEntity>(); var now = DateTime.Now; XmlNodeList nodeList = xmlResult.GetElementsByTagName("csv_data"); if (nodeList.Count == 0) { throw new Exception("获取数据失败"); } string strResult = nodeList[0].InnerXml; XmlNodeList nodeList01 = xmlResult.GetElementsByTagName("is_success"); string flag = nodeList01[0].InnerXml; XmlNodeList nodeList02 = xmlResult.GetElementsByTagName("count"); int countList = int.Parse(nodeList02[0].InnerXml); if (flag == "F") { throw new Exception("获取失败,is_success标识为F"); } if (countList <= 0) { throw new Exception("当天没有交易记录"); } //去掉左右冗余符号 strResult = strResult.Replace("<![CDATA[", "").Replace("]]>", "").Replace("\n", "").Trim(); string[] resultArray = strResult.Split(','); const int coulmnCount = 14; int rowCount = resultArray.Count() / coulmnCount - 1; DataTable table = new DataTable(); DataColumn column; DataRow row; //加列头 for (int i = 0; i < coulmnCount; i++) { column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = resultArray[i]; table.Columns.Add(column); } //加行 int index = coulmnCount; for (int j = 0; j < rowCount; j++) { row = table.NewRow(); for (int i = 0; i < coulmnCount; i++) { row[i] = resultArray[index++]; } table.Rows.Add(row); } foreach (DataRow rowData in table.Rows) { try { var soSysNo = Convert.ToInt32(rowData[0]); var getPayTypeResult = zfbDA.GetPayType(soSysNo); if (getPayTypeResult == null || getPayTypeResult.Count == 0) { throw new Exception("SO_Master中查找不到该订单信息"); } PayTypeEntity paytypeEntity = getPayTypeResult[0]; entityList.Add(new ZFBDataEntity { SoSysNo = soSysNo, PayTermsNo = paytypeEntity.PayTermsNo, PayTerms = paytypeEntity.PayTerms, PayedDate = Convert.ToDateTime(rowData[2]), PayedAmt = Convert.ToDecimal(rowData[8]), SerialNumber = rowData[3].ToString(), OutOrderNo = rowData[4].ToString(), PayedUserTag = rowData[5].ToString(), PayedUserName = rowData[6].ToString(), PayedUserNo = rowData[7].ToString(), PartnerName = "支付宝", TradeType = rowData[12].ToString(), AttachInfo = rowData[11].ToString(), AttachInfo2 = AttachInfo2, InUser = "******", InDate = now }); } catch (Exception ex) { string[] strArray = rowData.ItemArray.Select(x => { return(x == null ? string.Empty : x.ToString()); }).ToArray <string>(); string details = string.Format("异常订单信息 SoSysNo:{0},InDate:{1},Error:{2},ErrorInfoSource:{3}", rowData[0].ToString(), rowData[2].ToString(), ex.Message, string.Join(",", strArray)); OnShowInfo(details); SendMail("支付宝对账异常", details); if (rowData[0].ToString().Length >= 9) { var longInfo = string.Format("支付宝过长订单号信息提醒 SoSysNo:{0},InDate:{1},ErrorInfoSource:{2}", rowData[0].ToString(), rowData[2].ToString(), string.Join(",", strArray)); MailDA.SendEmail(Settings.LongOrderSysNoAlert, "支付宝过长订单号信息提醒", longInfo); } else if (ex.Message.Contains("SO_Master中查找不到该订单信息")) { var longInfo = string.Format("无法确认支付宝订单提醒 SoSysNo:{0},InDate:{1},ErrorInfoSource:{2}", rowData[0].ToString(), rowData[2].ToString(), string.Join(",", strArray)); MailDA.SendEmail(Settings.LongOrderSysNoAlert, "无法确认支付宝订单提醒", longInfo); } } } if (lastInfo != null && lastInfo.Count > 0) { entityList = entityList.Except(lastInfo, new ZFBEntityComparer()).ToList(); } if (entityList == null || entityList.Count == 0) { throw new Exception("不存在可导入记录"); } OnShowInfo("开始导入数据"); try { //每一百条数据导入一次 var entityMiddle = new List <ZFBDataEntity>(); for (int i = 0; i < entityList.Count; i++) { entityMiddle.Add(entityList[i]); if ((i != 0 && (i + 1) % 100 == 0) || (i + 1) == entityList.Count) { zfbDA.CreateData(entityMiddle); OnShowInfo(string.Format("导入了{0}条记录", (i + 1).ToString())); entityMiddle.Clear(); } } } catch (Exception ex) { OnShowInfo(string.Format("导入失败:{0}", ex.Message)); } OnShowInfo("导入完毕"); }
public static void SendEmail(string mailSubject, string mailBody) { MailDA.SendEmail(Settings.MailAddress, mailSubject, mailBody); }