此代码主要用来示范如何使用XElement.Element()方法获取指定名称的子元素,此方法只会返回一个子元素。
在代码中首先获取所有名为Item的元素,然后在LINQ to XML查询中,通过调用XElement.Element()方法获取名为Quantity和USPrice的子元素,然后据此返回大于100美元的订购项,最后将其打印到控制台上。
代码中用到的XML:
<?xml version="1.0"?>
<PurchaseOrder PurchaseOrderNumber="99503" OrderDate="1999-10-20">
<Address Type="Shipping">
<Name>Ellen Adams</Name>
<Street>123 Maple Street</Street>
<City>Mill Valley</City>
<State>CA</State>
<Zip>10999</Zip>
<Country>USA</Country>
</Address>
<Address Type="Billing">
<Name>Tai Yee</Name>
<Street>8 Oak Avenue</Street>
<City>Old Town</City>
<State>PA</State>
<Zip>95819</Zip>
<Country>USA</Country>
</Address>
<DeliveryNotes>Please leave packages in shed by driveway.</DeliveryNotes>
<Items>
<Item PartNumber="872-AA">
<ProductName>Lawnmower</ProductName>
<Quantity>1</Quantity>
<USPrice>148.95</USPrice>
<Comment>Confirm this is electric</Comment>
</Item>
<Item PartNumber="926-AA">
<ProductName>Baby Monitor</ProductName>
<Quantity>2</Quantity>
<USPrice>39.98</USPrice>
<ShipDate>1999-05-21</ShipDate>
</Item>
</Items>
</PurchaseOrder>
示例代码:
XDocument PurchaseOrderDocument =
XDocument.Load(@"C:/LINQ/PurchaseOrder.xml");
IEnumerable<XElement> ItemElements =
PurchaseOrderDocument.Descendants("Item");
IEnumerable<XElement> Items =
from Item in ItemElements
where (int)Item.Element("Quantity") * (decimal)Item.Element("USPrice") > 100
orderby Item.Attribute("PartNumber").ToString()
select Item;
foreach (XElement Item in Items)
{
Console.WriteLine(Item.ToString());
}