public class CSVHelper    {        System.Windows.Forms.SaveFileDialog saveFileDialog1;//保存        private string header = string.Empty;//标题        /// 
        /// 初始化打印设置        /// 
        ///         protected void InitExportController(Dictionary
     
       addition)        {            saveFileDialog1 = new System.Windows.Forms.SaveFileDialog();            saveFileDialog1.Filter = "导出CSV (*.csv)|*.csv";            saveFileDialog1.FilterIndex = 1;            saveFileDialog1.RestoreDirectory = true;            saveFileDialog1.CreatePrompt = false;            saveFileDialog1.Title = "导出文件保存路径";            saveFileDialog1.RestoreDirectory = true;//保存对话框是否记忆上次打开的目录             header = addition["HeardTitle"].ToString();            saveFileDialog1.FileName = header;        }        /// 
      
        /// 导出        /// 
        /// 
      表格        /// 
      路径        public bool Export(Dictionary
      
        addition, System.Data.DataTable dt)        {            if (!object.Equals(dt, null))            {                InitExportController(addition);                try                {                    if (saveFileDialog1.ShowDialog() == DialogResult.OK)                    {                        string filename = saveFileDialog1.FileName;                        return ExportToSvc(addition, dt, filename);                    }                }                catch                {                    saveFileDialog1.FileName = "请输入文件名称";                    if (saveFileDialog1.ShowDialog() == DialogResult.OK)                    {                        string filename = saveFileDialog1.FileName;                        return ExportToSvc(addition, dt, filename);                    }                }            }            return false;        }        /// 
       
        /// 导出        /// 
        /// 
       内容        /// 
       路径        public bool Export(Dictionary
       
         addition, DataGridView gv)        {            if (gv.Rows.Count > 0)            {                InitExportController(addition);                try                {                    if (saveFileDialog1.ShowDialog() == DialogResult.OK)                    {                        string filename = saveFileDialog1.FileName;                        return ExportToSvc(addition, gv, filename);                    }                }                catch                {                    saveFileDialog1.FileName = "请输入文件名称";                    if (saveFileDialog1.ShowDialog() == DialogResult.OK)                    {                        string filename = saveFileDialog1.FileName;                        return ExportToSvc(addition, gv, filename);                    }                }            }            return false;        }        /// 
        
        /// 导出为svc文件,strFileName为要导出的csv格式文件的路径和文件名        /// 
        /// 
        头部信息        /// 
        表格        /// 
        路径        protected bool ExportToSvc(Dictionary
        
          addition, System.Data.DataTable dt, string strFileName)        {            string strPath = strFileName;            if (File.Exists(strPath))            {                File.Delete(strPath);            }            //先打印标头            StringBuilder strColu = new StringBuilder();            StringBuilder strValue = new StringBuilder();            int i = 0;            try            {                StreamWriter sw = new StreamWriter(new FileStream(strPath, FileMode.CreateNew), Encoding.GetEncoding("GB2312"));                if (addition.ContainsKey("HeardTitle"))                {                    sw.WriteLine(addition["HeardTitle"].ToString());                }                if (addition.ContainsKey("Content"))                {                    sw.WriteLine(addition["Content"].ToString());                    sw.WriteLine();                }                for (i = 0; i <= dt.Columns.Count - 1; i++)                {                    if (addition.ContainsKey(dt.Columns[i].ColumnName))                    {                        strColu.Append(addition[dt.Columns[i].ColumnName].ToString().Trim());                    }                    else                    {                        strColu.Append(dt.Columns[i].ColumnName);                    }                    strColu.Append(",");                }                strColu.Remove(strColu.Length - 1, 1);//移出掉最后一个,字符                sw.WriteLine(strColu);                foreach (DataRow dr in dt.Rows)                {                    strValue.Remove(0, strValue.Length);//移出                    for (i = 0; i <= dt.Columns.Count - 1; i++)                    {                        strValue.Append(dr[i].ToString());                        strValue.Append(",");                    }                    strValue.Remove(strValue.Length - 1, 1);//移出掉最后一个,字符                    sw.WriteLine(strValue);                }                if (addition.ContainsKey("Foot"))                {                    sw.WriteLine();                    sw.WriteLine(addition["Foot"].ToString());                }                sw.Close();                return true;            }            catch (Exception ex)            {                throw ex;            }        }        /// 
         
        /// 导出为svc文件,strFileName为要导出的csv格式文件的路径和文件名        /// 
        ///  
         头部信息        /// 
         DataGridView控件        /// 
                 protected bool ExportToSvc(Dictionary
         
           addition, DataGridView gv, string strFileName)        {            string strPath = strFileName;            if (File.Exists(strPath))            {                File.Delete(strPath);            }            //先打印标头            StringBuilder strColu = new StringBuilder();            StringBuilder strValue = new StringBuilder();            int i = 0;            try            {                StreamWriter sw = new StreamWriter(new FileStream(strPath, FileMode.CreateNew), Encoding.GetEncoding("GB2312"));                if (addition.ContainsKey("HeardTitle"))                {                    sw.WriteLine(addition["HeardTitle"].ToString());                }                if (addition.ContainsKey("Content"))                {                    sw.WriteLine(addition["Content"].ToString());                    sw.WriteLine();                }                for (i = 0; i <= gv.Columns.Count - 1; i++)                {                    if (gv.Columns[i].Visible == true)                    {
    //可见的列导出，隐藏的列过滤                        strColu.Append(gv.Columns[i].HeaderText.Trim());                        strColu.Append(",");                    }                }                strColu.Remove(strColu.Length - 1, 1);//移出掉最后一个,字符                sw.WriteLine(strColu);                foreach (DataGridViewRow dr in gv.Rows)                {                    strValue.Remove(0, strValue.Length);//移出                    for (i = 0; i <= gv.Columns.Count - 1; i++)                    {                        if (gv.Columns[i].Visible == true)                        {
    //可见的导出                            strValue.Append(dr.Cells[i].Value.ToString());                            strValue.Append(",");                        }                    }                    strValue.Remove(strValue.Length - 1, 1);//移出掉最后一个,字符                    sw.WriteLine(strValue);                }                if (addition.ContainsKey("Foot"))                {                    sw.WriteLine();                    sw.WriteLine(addition["Foot"].ToString());                }                sw.Close();                return true;            }            catch (Exception ex)            {                throw ex;            }        }        /// 
          
 /// 导出CSV /// 
        /// 
          显示标题        /// 
          文件名        /// 
          一至多个表源        /// 
                  public bool Export(string title, string name, params DataTable[] dts)        {            bool result = false;            if (dts != null && dts.Length > 0)            {                var dict = new Dictionary
          
           (); dict["HeardTitle"] = name; InitExportController(dict); if (saveFileDialog1.ShowDialog() == DialogResult.OK) { try { using (StreamWriter sw = new StreamWriter(new FileStream(saveFileDialog1.FileName, FileMode.CreateNew), Encoding.GetEncoding("GB2312"))) { sw.WriteLine(title); foreach (DataTable dt in dts) { StringBuilder strValue = new StringBuilder(); StringBuilder strColu = new StringBuilder(); for (int i = 0; i <= dt.Columns.Count - 1; i++) { strColu.Append(dt.Columns[i].ColumnName); strColu.Append(","); } strColu.Remove(strColu.Length - 1, 1);//移出掉最后一个,字符 sw.WriteLine(strColu); foreach (DataRow dr in dt.Rows) { strValue.Remove(0, strValue.Length);//移出 for (int i = 0; i <= dt.Columns.Count - 1; i++) { strValue.Append(dr[i].ToString()); strValue.Append(","); } strValue.Remove(strValue.Length - 1, 1);//移出掉最后一个,字符 sw.WriteLine(strValue); } sw.WriteLine(); } } result = true; } catch (Exception exc) { Console.WriteLine(exc.Message); } } } return result; } /// 
           
 /// 导出CSV /// 
 /// 
           显示标题 /// 
           文件名 /// 
           一至多个表源 /// 
            public bool Export(string title, string name, DataSet ds) { bool result = false; if (ds != null && ds.Tables.Count > 0) { var dict = new Dictionary
           
            (); dict["HeardTitle"] = name; InitExportController(dict); if (saveFileDialog1.ShowDialog() == DialogResult.OK) { try { using (StreamWriter sw = new StreamWriter(new FileStream(saveFileDialog1.FileName, FileMode.CreateNew), Encoding.GetEncoding("GB2312"))) { sw.WriteLine(title); foreach (DataTable dt in ds.Tables) { StringBuilder strValue = new StringBuilder(); StringBuilder strColu = new StringBuilder(); for (int i = 0; i <= dt.Columns.Count - 1; i++) { strColu.Append(dt.Columns[i].ColumnName); strColu.Append(","); } strColu.Remove(strColu.Length - 1, 1);//移出掉最后一个,字符 sw.WriteLine(strColu); foreach (DataRow dr in dt.Rows) { strValue.Remove(0, strValue.Length);//移出 for (int i = 0; i <= dt.Columns.Count - 1; i++) { strValue.Append(dr[i].ToString()); strValue.Append(","); } strValue.Remove(strValue.Length - 1, 1);//移出掉最后一个,字符 sw.WriteLine(strValue); } sw.WriteLine(); } } result = true; } catch (Exception exc) { Console.WriteLine(exc.Message); } } } return result; } }