代码生成Excel导入模版

代码自从生成模版，不用在指定路径下存储模版。更简洁，更方便。

性能消耗可以忽略不计！

private void CreateComment()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("产品编号", typeof(string));
            dt.Columns.Add("排序编号", typeof(string));
            CreateCsv(dt);
        }

/// <summary>

        /// 输出Csv格式文件
        /// </summary>
        /// <param name="dt"></param>
        public static void CreateCsv(DataTable dt)
        {
            StringWriter sw = new StringWriter();
            string column = "";
            foreach (DataColumn item in dt.Columns)
            {
                column += item + ",";
            }
            column = column.Trim(',');
            sw.WriteLine(column);//添加行s

            foreach (DataRow row in dt.Rows)
            {
                string rows = "";
                foreach (DataColumn col in dt.Columns)
                {
                    rows += row[col] + ",";//添加列
                }
                rows = rows.Trim(',');
                sw.WriteLine(rows);
            }
            sw.Close();
            System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=TidebuyCsv" + DateTime.Now.ToShortTimeString() + ".csv");
            System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";
            System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            System.Web.HttpContext.Current.Response.Write(sw);
            System.Web.HttpContext.Current.Response.End();
        }