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);
}
这将给出您期望的输出:-
select new
{
ScanCode = (string)order.Element("ScanCode")
}
你已经有了order
引用变量,它保存了Item
集合。不需要再往上走,你可以使用order
本身。
根据您当前的代码,您正试图在Transaction
集合中找到元素item
,因此它只是找到第一个。