生成csv文件存到MemoryStream中
读取MemoryStream发送邮件,不进行文件本地保存直接发送.
使用outlook邮箱发送代码,其他邮箱跟换smtp 和 port即可
public static bool SendEmailSmtp(string email,string content, string sender, string title,string file, Attachment data1=null) { try { MailMessage mailMsg = new MailMessage();//实例化对象 mailMsg.From = new MailAddress(emailAddress, sender);//源邮件地址和发件人 mailMsg.To.Add(new MailAddress(email));//收件人地址 mailMsg.Subject = title;//发送邮件的标题 "比率测试邮件-发送小票信息" StringBuilder sb = new StringBuilder(); sb.Append(content); mailMsg.Body = sb.ToString();//发送邮件的内容 mailMsg.BodyEncoding = System.Text.Encoding.UTF8;//邮件内容编码 mailMsg.IsBodyHtml = true;//是否是HTML邮件 //指定smtp服务地址（根据发件人邮箱指定对应SMTP服务器地址） SmtpClient client = new SmtpClient();//格式：smtp.126.com smtp.164.com client.Host = "smtp-mail.outlook.com";//smtp.qq.com //要用587端口 client.Port = 587;//端口 587 client.EnableSsl = true; //通过email 和password验证发件人身份 client.Credentials = new NetworkCredential(emailAddress, "123456789"); if (!string.IsNullOrEmpty(file)) { //add file Attachment data = new Attachment(file); mailMsg.Attachments.Add(data); } if (data1 != null) { mailMsg.Attachments.Add(data1); } try { client.Send(mailMsg); } catch (SmtpException ex) { return false; } return true; } catch (Exception ex) { return false; } }
csv存文件流代码:
/// <summary> /// create csv file stream and send email /// </summary> /// <typeparam name="T">数据model</typeparam> /// <param name="fileName">文件名称</param> /// <param name="listModel"></param> /// <param name="email">多邮箱处理</param> /// <returns></returns> public static bool SaveAsCSV<T>(string fileName, List<T> listModel, string[] email) where T : class, new() { bool sendemail = false; try { StringBuilder sb = new StringBuilder(); //通过反射 显示要显示的列 BindingFlags bf = BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.Static;//反射标识 Type objType = typeof(T); PropertyInfo[] propInfoArr = objType.GetProperties(bf); #region csv heard string header = string.Empty; List<string> listPropertys = new List<string>(); foreach (PropertyInfo info in propInfoArr) { if (string.Compare(info.Name.ToUpper(), "ID") != 0) //不考虑自增长的id或者自动生成的guid等 { if (!listPropertys.Contains(info.Name)) { listPropertys.Add(info.Name); } header += info.Name + ","; } } sb.AppendLine(header.Trim(‘,‘)); UnicodeEncoding uniEncoding = new UnicodeEncoding(); byte[] firstString = uniEncoding.GetBytes(sb.ToString()); MemoryStream stream = new MemoryStream(); stream.Write(firstString, 0, firstString.Length); #endregion #region csv content StringBuilder sb2 = new StringBuilder(); foreach (T model in listModel) { string strModel = string.Empty; foreach (string strProp in listPropertys) { foreach (PropertyInfo propInfo in propInfoArr) { if (string.Compare(propInfo.Name.ToUpper(), strProp.ToUpper()) == 0) { PropertyInfo modelProperty = model.GetType().GetProperty(propInfo.Name); if (modelProperty != null) { object objResult = modelProperty.GetValue(model, null); string result = ((objResult == null) ? string.Empty : objResult).ToString().Trim(); if (result.IndexOf(‘,‘) != -1) { result = "\"" + result.Replace("\"", "\"\"") + "\""; //特殊字符处理 ？ } if (!string.IsNullOrEmpty(result)) { Type valueType = modelProperty.PropertyType; if (valueType.Equals(typeof(Nullable<decimal>)) || valueType.Equals(typeof(decimal))) { result = decimal.Parse(result).ToString("F2"); } else if (valueType.Equals(typeof(Nullable<double>)) || valueType.Equals(typeof(double))) { result = double.Parse(result).ToString("G"); } else if (valueType.Equals(typeof(Nullable<float>)) || valueType.Equals(typeof(float))) { result = float.Parse(result).ToString("G"); } } strModel += result + ","; } else { strModel += ","; } break; } } } strModel = strModel.Substring(0, strModel.Length - 1); sb2.AppendLine(strModel); } byte[] secondString = uniEncoding.GetBytes(sb2.ToString()); int count = 0; while (count < secondString.Length) { stream.WriteByte(secondString[count++]); } #endregion //Set the position to the beginning of the stream. stream.Seek(0, SeekOrigin.Begin); Attachment data = new Attachment(stream, fileName); foreach (var item in email) { sendemail =SendEmailSmtp(item, "Please check the report today", "test", "report test", "", data); } } catch (Exception ex) { sendemail = false; } return sendemail; }
原文：https://www.cnblogs.com/lindajia/p/14850876.html
