/// <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);
}
