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 ""; } |
声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。
