所以我的输出写入CSV文件时遇到问题。写入CSV文件时,此代码的输出格式正确,但仅在文件中输入一行。应该还有更多。约150条线。当前输出为:


  (859.85 7N830127 185)


哪个是正确的,但应该有更多这些。在我看来,它只是写入已解析EDI文件的第一行,然后停止。我需要找到一种方法来确保它写入所有正在解析的数据,任何人都可以帮助我吗?

static void Main(string[] args)
{
    StreamReader sr = new StreamReader("edifile.txt");

    string[] ediMapTemp = sr.ReadLine().Split('|');
    List<string[]> ediMap = new List<string[]>();
    List<object[]> outputMatrix = new List<object[]>();

    foreach (var line in ediMapTemp)
    {
        ediMap.Add(line.Split('~'));
    }

    DetailNode node = new DetailNode(0, null, 0);
    int hierarchicalDepth = 0;
    int hierarchicalIdNumber;
    int hierarchicalParentIdNumber;
    int hierarchicalLevelCode;
    int hierarchicalChildCode = 0;
    for (int i = 0; i < ediMap.Count; i++)
    {
        string segmentHeader = ediMap[i][0];
        if (segmentHeader == "HL")
        {
            hierarchicalIdNumber = Convert.ToInt32(ediMap[i][1]);
            hierarchicalParentIdNumber = Convert.ToInt32(ediMap[i][2]);
            hierarchicalLevelCode = Convert.ToInt32(ediMap[i][3]);
            hierarchicalChildCode = Convert.ToInt32(ediMap[i][4]);

            List<string[]> levelDetails = new List<string[]>();
            for (int v = i + 1; v < ediMap.Count; v++)
            {
                if (ediMap[v][0] == "HL") break;
                levelDetails.Add(ediMap[v]);
            }
            DetailNode getNode = node.Find(node, hierarchicalParentIdNumber);
            getNode.headList.Add(new DetailNode(hierarchicalIdNumber, levelDetails, getNode.depth + 1));
        }
    }
    node.Traversal(new VID(), node);
    foreach (var vid in VIDList.vidList)

        using (StreamWriter writer = new StreamWriter("Import.csv"))
        {
            //probably a loop here
            writer.WriteLine(String.Join(",", vid.totalCurrentCharges, vid.assetId, vid.componentName, vid.recurringCharge));
        }
}

最佳答案

快速检查,代码应如下:

using (StreamWriter writer = new StreamWriter("Import.csv"))
{
    //a loop here
    foreach (var vid in VIDList.vidList)
    {
        writer.WriteLine(String.Join(",", vid.totalCurrentCharges, vid.assetId, vid.componentName, vid.recurringCharge));
    }
}


您将打开文件一次,然后循环遍历您的集合,并编写每个集合。

08-26 14:31
查看更多