我有一个XML文件,希望能够提取出订单号、商品、数量和商品价格(原价、税费等)。以下是XML文件。我遇到的问题是商品价格。在其中,你可以看到0到多个价格组件,如税费、原价等。如何将它们提取为单行输出?
目前,我可以获取订单号、商品编号、数量,但当我提取价格时,我会得到一行税费和原价。
另外一个问题是,如果某些情况下没有税费怎么办?我会得到一个空引用,对吗?我想尝试处理这些并替换为0。任何建议都非常感谢。
XML:
目前,我可以获取订单号、商品编号、数量,但当我提取价格时,我会得到一行税费和原价。
另外一个问题是,如果某些情况下没有税费怎么办?我会得到一个空引用,对吗?我想尝试处理这些并替换为0。任何建议都非常感谢。
XML:
<?xml version="1.0" encoding="UTF-8"?>
<SettlementReport>
<Order>
<AmazonOrderID>105-6982537-6258888</AmazonOrderID>
<ShipmentID>MyShipmentIDTest1234</ShipmentID>
<MarketplaceName>Amazon.com</MarketplaceName>
<Fulfillment>
<MerchantFulfillmentID>MyTestFulFillID12345</MerchantFulfillmentID>
<PostedDate>2008-12-15T19:33:04+00:00</PostedDate>
<Item>
<AmazonOrderItemCode>13350774331938</AmazonOrderItemCode>
<SKU>U1409</SKU>
<Quantity>1</Quantity>
<ItemPrice>
<Component>
<Type>Principal</Type>
<Amount currency="USD">0.15</Amount>
</Component>
<Component>
<Type>Tax</Type>
<Amount currency="USD">0.02</Amount>
</Component>
</ItemPrice>
</Item>
<Item>
<AmazonOrderItemCode>13350774331939</AmazonOrderItemCode>
<SKU>U14010</SKU>
<Quantity>2</Quantity>
<ItemPrice>
<Component>
<Type>Principal</Type>
<Amount currency="USD">0.30</Amount>
</Component>
<Component>
<Type>Tax</Type>
<Amount currency="USD">0.04</Amount>
</Component>
</ItemPrice>
</Item>
</Fulfillment>
</Order>
</SettlementReport>
我的代码:
XDocument customer = XDocument.Load(@"C:\LinqToXML.xml");
var orders = from amznorders in customer.Root.Elements("Order")
from amznfulfill in amznorders.Elements("Fulfillment")
from amznitems in amznfulfill.Elements("Item")
from amznitemprc in amznitems.Elements("ItemPrice").Elements("Component")
select new
{
OrderNumber = (string)amznorders.Element("AmazonOrderID"),
ItemNumber = (string)amznitems.Element("AmazonOrderItemCode"),
QTY = (string)amznitems.Element("Quantity"),
//This is where I need help...if type = Principal set PriceAmount else Set PriceTax?//
PriceAmount = (string)amznitemprc.Element("Amount")
//Address1 = (string)address1.Element("Address1")
};
foreach (var order in orders)
{
Console.WriteLine("Order: {0} ItemNumber: {1} QTY: {2} PriceAmount: {3} ", order.OrderNumber, order.ItemNumber, order.QTY, order.PriceAmount);
}