1.添加CsvHelper组件类
2.添加类
|
1 2 3 4 5 6 7 8 9 |
public class StorageInfo { /// <summary> /// 一条连接的记录 /// </summary> public string SIGNED { get; set; } } |
3.主要部分
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
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 ""; } |
