XML查询只返回第一个元素

本文关键字:第一个 元素 返回 查询 XML | 更新日期: 2023-09-27 18:18:01

我需要在这个XML中返回3个scancode items元素,而不是返回第一个元素3次。我对LINQ XML做得不多。我看了网站上的其他帖子,都有点不同。

### Expected Output ###
10/14/2015
05:00
044000031910
044000031912
044000031913
10/15/2015
06:00
044000031920
044000031922
044000031923
### Current Output ###
10/14/2015
05:00
044000031910
044000031910
044000031910
10/15/2015
06:00
044000031920
044000031920
044000031920

XML示例
<Orders>
<Transaction>
    <TransDate>10/14/2015</TransDate>
    <TransTime>05:00</TransTime>
    <Item>
        <SequenceNumber>1</SequenceNumber>
        <ScanCode>044000031910</ScanCode>
    </Item>
    <Item>
        <SequenceNumber>2</SequenceNumber>
        <ScanCode>858310004011</ScanCode>
    </Item>
    <Item>
        <SequenceNumber>3</SequenceNumber>
        <ScanCode>092657011712</ScanCode>
    </Item>
</Transaction>
<Transaction>
    <TransDate>10/15/2015</TransDate>
    <TransTime>06:00</TransTime>
    <Item>
        <SequenceNumber>1</SequenceNumber>
        <ScanCode>044000031920</ScanCode>
    </Item>
    <Item>
        <SequenceNumber>2</SequenceNumber> 
        <ScanCode>858310004021</ScanCode>
    </Item>
    <Item>
        <SequenceNumber>3</SequenceNumber>
        <ScanCode>092657011722</ScanCode>
    </Item>
</Transaction>

c#示例

 var doc = XDocument.Load("Data.xml");
        var data = from item in doc.Descendants("Transaction")
                   select new
                   {
                       TransDate = (string)item.Element("TransDate"),
                       TransTime = (string)item.Element("TransTime"),
                       items = from order in item.Elements("Item")
                               select new
                               {
                                   ScanCode = (string)item.Element("Item").Element("ScanCode")
                               }
                   };
        foreach (var Item in data)
        {
            textBox1.AppendText(Item.TransDate + Environment.NewLine);
            textBox1.AppendText(Item.TransTime + Environment.NewLine);
            foreach (var item in Item.items)
            {
                textBox1.AppendText(item.ScanCode + Environment.NewLine);
            }
            textBox1.AppendText(Environment.NewLine);
        }

XML查询只返回第一个元素

这将给出您期望的输出:-

 select new
     {
         ScanCode = (string)order.Element("ScanCode")
     }

你已经有了order引用变量,它保存了Item集合。不需要再往上走,你可以使用order本身。

根据您当前的代码,您正试图在Transaction集合中找到元素item,因此它只是找到第一个。