通过 XMLReader 获取 XML 标签 x 的值并添加到 LinkedList C#

Question

我是编程新手，遇到了严重的问题并且无法摆脱它。

我有 5 个 XML URL。例如 http://www.shopandmiles.com/xml/3_119_3.xml

这是一个 XML URL，我必须获取值并将其写入相关列中的数据库。 我的列名称和 XML 标记名称确实匹配。

当我编写下面的代码时，阅读器元素缺少 null xml 值。有些标签内部没有价值。我必须将它们添加到链接列表中，因为在该代码之后，我将遍历链接列表，但如果我无法为 null xml 值添加值，则顺序不匹配。所以列名和里面的数据不匹配。我失去了订单。我的所有代码都在这里，您也可以查看代码中的注释是否有帮助。谢谢大家。

public void WebServiceShopMilesCampaignsXMLRead(string URL)
    {
        XmlReader reader = XmlReader.Create(URL);
        LinkedList<string> linkedList = new LinkedList<string>();

        List<ShopAndMilesCampaigns> shopMileCampaigns = new List<ShopAndMilesCampaigns>();

        try
        {
            while (reader.Read())
            {
                switch (reader.NodeType)
                {
                    case XmlNodeType.Text:
                        linkedList.AddLast(reader.Value);
                        break;
                }
            }
        }

        catch (XmlException exception)
        {
            Console.WriteLine("XML okurken bir sorun oluştu, hata detayı --> " + exception.Message);
        }

        LinkedListNode<string> node = linkedList.First;

        while (node != null)
        {
            ShopAndMilesCampaigns shopMilesCampaign = new ShopAndMilesCampaigns();

            shopMilesCampaign.Name = node.Value; // Null values mixes up the order because i cant add as null with reader.read above
            node = node.Next;
            shopMilesCampaign.Summary = node.Value;
            node = node.Next;
            shopMilesCampaign.AccountName = node.Value;
            node = node.Next;
            shopMilesCampaign.Category = node.Value;
            node = node.Next;
            shopMilesCampaign.Sector = node.Value;
            node = node.Next;
            shopMilesCampaign.Details = node.Value;
            node = node.Next;
            shopMilesCampaign.Image = node.Value;
            node = node.Next;
            shopMilesCampaign.Status = 1;
            node = node.Next;

            shopMileCampaigns.Add(shopMilesCampaign);
        }

        foreach (ShopAndMilesCampaigns shopMileCampaign in shopMileCampaigns)
        {
            shopMileCampaign.Insert();
        }
    }

Answer 1

我找到了答案。在此，特意向您通报一下。

如果 XmlNodeType 等于 Element，则循环继续从 XML 数据中读取并查找 XML 标记的 Whitesapces 和结束 Element。下面的代码给出了 XML 标签的确切值，即使它是空的。

public LinkedList<string> AddToLinkedList(XmlReader reader)
    {

        LinkedList<string> linkedList = new LinkedList<string>();

        try
        {
            while (reader.Read())
            {
                switch (reader.NodeType)
                {
                    case XmlNodeType.Element:
                        reader.Read();
                    Start:
                        if (reader.NodeType == XmlNodeType.Whitespace || reader.NodeType == XmlNodeType.Element)
                        {
                            reader.Read();
                            goto Start;
                        }
                        else if (reader.NodeType == XmlNodeType.EndElement)
                        {
                            linkedList.AddLast("");
                        }
                        else
                        {
                            linkedList.AddLast(reader.Value);
                        }
                        break;
                }
            }
        }