我有一些包含付款信息的 XML，其中包括付款所應(yīng)用的發(fā)票的詳細(xì)信息。例如，我想使用 LINQ to XML 僅收集適用于某些發(fā)票 (111,222,333) 的付款。如果是 SQL，我可以使用 IN (111,222,333) 關(guān)鍵字，但我不確定如何在 LINQ 中執(zhí)行相同的操作。<Payment> <PaymentId>1</PaymentId> <Total>50</Total> <Invoice> <Id>111</Id> <Amount>20</Amount> </Invoice> <Invoice> <Id>555</Id> <Amount>30</Amount> </Invoice></Payment><Payment> <PaymentId>2</PaymentId> <Total>20</Total> <Invoice> <Id>222</Id> <Amount>20</Amount> </Invoice></Payment><Payment> <PaymentId>3</PaymentId> <Total>80</Total> <Invoice> <Id>888</Id> <Amount>80</Amount> </Invoice></Payment>LINQvar result = xml.Select(x => x.Element("Payment")) Where(x => x.Element("Id").Value.Contains("111","222","333"))在此示例中，我想選擇“PaymentId 1”和“PaymentId 2”，因?yàn)樗鼈冞m用于 ID 匹配 111、222 或 333 的發(fā)票。
1 回答
肥皂起泡泡
TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超6個(gè)贊
您可以對(duì)這些知名 ID 的列表進(jìn)行匹配/相交。
List<string> ids = new List<string> { "111", "222", "333" };
var result = xml
.Elements("Payment")
.Where(p => {
var invoiceIds = p.Elements("Invoice").Elements("Id").Select(o => o.Value);
return ids.Intersect(invoiceIds).Any();
}
);
完整代碼和NetFiddle。
const string XML = @"
<root>
<Payment>
<PaymentId>1</PaymentId>
<Total>50</Total>
<Invoice>
<Id>555</Id>
<Amount>30</Amount>
</Invoice>
<Invoice>
<Id>111</Id>
<Amount>30</Amount>
</Invoice>
</Payment>
<Payment>
<PaymentId>2</PaymentId>
<Total>20</Total>
<Invoice>
<Id>222</Id>
<Amount>20</Amount>
</Invoice>
</Payment>
<Payment>
<PaymentId>3</PaymentId>
<Total>80</Total>
<Invoice>
<Id>888</Id>
<Amount>80</Amount>
</Invoice>
</Payment>
</root>
";
XElement xml = XElement.Parse(XML);
List<string> ids = new List<string> { "111", "222", "333" };
var result = xml
.Elements("Payment")
.Where(p => {
var invoiceIds = p.Elements("Invoice").Elements("Id").Select(o => o.Value);
return ids.Intersect(invoiceIds).Any();
}
);
foreach (var item in result)
{
Console.WriteLine("PaymentId: {0}", (string)item.Element("PaymentId"));
}
- 1 回答
- 0 關(guān)注
- 133 瀏覽
添加回答
舉報(bào)
0/150
提交
取消