.NETCORE使用CsvHelper组件类从数据库写入到CSV文件

1.添加CsvHelper组件类

2.添加类

	public class StorageInfo
	{

		/// <summary>
		/// 一条连接的记录
		/// </summary>
		public string SIGNED { get; set; }

	}

3.主要部分

        private string CreateCSV(DataRow row, DataTable StorageData)
        {
            //创建目录和文件名
            string pathName = CommonMgr.CreateDirectory(row["extern_storer"].ToString());
            pathName = pathName  + row["partner"].ToString() + "-" + row["loc"].ToString() +"INV"+"-"+"A"+ "-" + DateTime.Now.ToString("MMddyyyy-hhmmss")+".csv";

            //添加数据库记录到LIST
			List<StorageInfo> Storage = new List<StorageInfo>();
			foreach (DataRow record in StorageData.Rows)
                        {
				string SIGNED = record["SIGNED"].ToString();
				Storage.Add(new StorageInfo { SIGNED = SIGNED });
			}

			CsvConfiguration config = new CsvConfiguration(CultureInfo.InvariantCulture)
			{
				HasHeaderRecord = false     //不显示标头
			};
            //开始生成CSV文件
	    using var writer = new StreamWriter(pathName, false, Encoding.UTF8);   //编码
            using var csvWriter = new CsvWriter(writer, config);
            csvWriter.WriteRecords(Storage);

            return "";
        }

 

https://www.88531.cn/?p=44930

• 本文来源链接地址： https://www.npspro.cn/38937.html