CSV文件读写功能

/// <summary>
/// .csv是工业开发中用来保存检测记录的一种格式，类似于 Excel表格的形式
/// </summary>
/// <param name="data">数据</param>
/// <param name="result">内容追加</param>
public void WriteCSV(string data, string result)
{
    string path =Directory.GetCurrentDirectory()+"\\Data";
    if (!Directory.Exists(path))
    {
        Directory.CreateDirectory(path);
    }
    //文件:这里保存成csv格式就代表以纯文本形式存储表格数据。
    string fileName = $"{path}\\测试-{DateTime.Now.ToString("yyyy-MM-dd")}.csv";
    //有表头,第一次创建文件的时候可以先给表头配置好
    if (!File.Exists(fileName)) { 
        //创建文件配置表头
        FileStream fs = new FileStream(fileName,FileMode.Create,FileAccess.Write);
        StringBuilder sb = new StringBuilder();
        //模拟质检的数据格式
        sb.Append("时间:").Append(",").Append("检测状态:").Append(",").Append("数据分析:").Append(",").Append("结果:");
        //写入
        StreamWriter sw =new StreamWriter(fs,Encoding.Default);
        sw.WriteLine(sb);
        sw.Close();
        sw.Dispose();
        fs.Close();
        fs.Dispose();
    }
    else
    {
        //追加
        StreamWriter sw = new StreamWriter(fileName,true, Encoding.Default);
        StringBuilder sb = new StringBuilder();
        //模拟质检的数据格式
        sb.Append(DateTime.Now.ToString("yyyy-MM-ss")).Append(",").Append("NG").Append(",").Append(data).Append(",").Append(result);
        sw.WriteLine(sb);
        sw.Close();
        sw.Dispose();
                
    }
}

public string ReadFileData()
{

    string path = Directory.GetCurrentDirectory() + "\\Data";
    //文件这里，将来可以拓展成目录性质。。。
    string fileName = $"{path}\\测试-2026-06-09.csv";
    StreamReader sr = new StreamReader(fileName, Encoding.Default);
    StringBuilder stringBuilder = new StringBuilder(sr.ReadLine());
    return stringBuilder.ToString();
}