C# DataTable生成excel并将excel添加附件发送邮件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.IO;

namespace SendMailDemo
{
    public class Conn
    {
        public static string StrConn
        {
            get
            {
                //读取文本文件（txt）
                //return Conn.getValue（@“C:UsersBramblingDesktopDemoSendMailSendMailDB_ConfigDB_Config.txt“ “StrConn“）;

                //读取配置文件
                //return ConfigurationManager.ConnectionStrings[“StrConn“].ToString（）;
                //return ConfigurationManager.AppSettings[“Conn“].ToString（）;

                //直接返回数据库连接字符串
                return “Data Source=.;Initial Catalog=TC_MES_WEB_ADMIN;User ID=sa;Pwd=jm123!@#;Enlist=true;Pooling=true;Max Pool Size=300;Min Pool Size=0;Connection Lifetime=300;packet size=1000“;
            }
        }

        public static SqlConnection SqlConn
        {
            get
            {
                return new SqlConnection（StrConn）;
            }
        }

        private static string getValue（string path string name）
        {
            string[] str = File.ReadAllLines（path）;
            for （int i = 0; i < str.Length; i++）
            {
                if （str[i].StartsWith（name））
                {
                    return str[i].Replace（name + “=“ ““）;
                }
            }
            return ““;
        }
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2018-04-18 16:21  SendMailDemo
     目录           0  2018-04-18 16:21  SendMailDemo.vs
     目录           0  2018-04-18 16:21  SendMailDemo.vsSendMailDemo
     目录           0  2018-04-18 16:21  SendMailDemo.vsSendMailDemov14
     文件       43008  2018-04-18 21:18  SendMailDemo.vsSendMailDemov14.suo
     目录           0  2018-04-18 22:11  SendMailDemoSendMailDemo
     文件        1003  2018-04-18 16:21  SendMailDemoSendMailDemo.sln
     文件         189  2018-04-18 16:21  SendMailDemoSendMailDemoApp.config
     目录           0  2018-04-18 16:21  SendMailDemoSendMailDemoin
     目录           0  2018-04-18 21:16  SendMailDemoSendMailDemoinDebug
     文件     1602560  2014-06-26 06:40  SendMailDemoSendMailDemoinDebugNPOI.dll
     文件      419840  2014-06-27 15:44  SendMailDemoSendMailDemoinDebugNPOI.OOxml.dll
     文件      422053  2014-06-27 15:44  SendMailDemoSendMailDemoinDebugNPOI.OOxml.xml
     文件       85504  2014-06-27 15:44  SendMailDemoSendMailDemoinDebugNPOI.Openxml4Net.dll
     文件      153211  2014-06-27 15:44  SendMailDemoSendMailDemoinDebugNPOI.Openxml4Net.xml
     文件     1869824  2014-06-27 15:44  SendMailDemoSendMailDemoinDebugNPOI.OpenxmlFormats.dll
     文件       17408  2018-04-18 22:09  SendMailDemoSendMailDemoinDebugSendMailDemo.exe
     文件         189  2018-04-18 16:21  SendMailDemoSendMailDemoinDebugSendMailDemo.exe.config
     文件       32256  2018-04-18 22:09  SendMailDemoSendMailDemoinDebugSendMailDemo.pdb
     文件       22696  2018-04-18 22:11  SendMailDemoSendMailDemoinDebugSendMailDemo.vshost.exe
     文件         189  2018-04-18 16:21  SendMailDemoSendMailDemoinDebugSendMailDemo.vshost.exe.config
     文件         490  2015-10-22 09:54  SendMailDemoSendMailDemoinDebugSendMailDemo.vshost.exe.manifest
     文件        1547  2018-04-18 16:52  SendMailDemoSendMailDemoConn.cs
     文件       19026  2018-04-18 22:11  SendMailDemoSendMailDemoForm1.cs
     文件        2032  2018-04-18 16:23  SendMailDemoSendMailDemoForm1.Designer.cs
     文件        5817  2018-04-18 16:23  SendMailDemoSendMailDemoForm1.resx
     目录           0  2018-04-18 16:21  SendMailDemoSendMailDemoobj
     目录           0  2018-04-18 21:28  SendMailDemoSendMailDemoobjDebug
     文件        1464  2018-04-18 20:43  SendMailDemoSendMailDemoobjDebugDesignTimeResolveAssemblyReferences.cache
     文件        7525  2018-04-18 21:16  SendMailDemoSendMailDemoobjDebugDesignTimeResolveAssemblyReferencesInput.cache
     文件         965  2018-04-18 22:11  SendMailDemoSendMailDemoobjDebugSendMailDemo.csproj.FileListAbsolute.txt
............此处省略19个文件信息