Display_D_HP/TeamAAS-VM/Data/DataTableHelper.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using TeamAAS_VP.Models;

namespace TeamAAS_VM.Data
{
    /// <summary>
    /// 将DataTable导出到本地文件中
    /// </summary>
    public static class DataTableHelper
    {
        /// <summary>
        /// 将DataTable导出到csv文件中
        /// </summary>
        /// <param name="dataTable"></param>
        /// <param name="filePath"></param>
        public static void ExportToCsv(System.Data.DataTable dataTable, string filePath)
        {
            StringBuilder sb = new StringBuilder();
            //添加列名
            foreach (System.Data.DataColumn column in dataTable.Columns)
            {
                sb.Append(column.ColumnName + ",");
            }
            sb.AppendLine();
            //添加数据
            foreach (System.Data.DataRow row in dataTable.Rows)
            {
                foreach (var item in row.ItemArray)
                {
                    sb.Append(item.ToString() + ",");
                }
                sb.AppendLine();
            }
            System.IO.File.WriteAllText(filePath, sb.ToString());
        }

        public static System.Data.DataTable ToDataTable(IEnumerable<AlarmRecord> alarmRecords)
        {
            System.Data.DataTable dt = new System.Data.DataTable();
            dt.Columns.Add("Id", typeof(int));
            dt.Columns.Add("Code", typeof(string));
            dt.Columns.Add("Message", typeof(string));
            dt.Columns.Add("Source", typeof(string));
            dt.Columns.Add("Time", typeof(DateTime));
            foreach (var alarmRecord in alarmRecords)
            {
                //添加数据行
                dt.Rows.Add(alarmRecord.Id, alarmRecord.Code, alarmRecord.Message, alarmRecord.Source, alarmRecord.Time);
            }
            return dt;
        }
    }
}