Csharp 如何在c#中foreach以下xml

发布于03月31日

我有以下的XML结果

<?xml version="1.0" encoding="windows-1254" ?>
<RESPONSE>
  <VALIDATION>1</VALIDATION>
  <QUERY1 searched="12345">0</QUERY1>
  <QUERY2 searched="aaaaa">2</QUERY2>
  <QUERY3 searched="44444">2</QUERY3>
  <QUERY4 searched="99999">0</QUERY4>
  <QUERY5 searched="number">0</QUERY5>
  <QUERY6 searched="bar">0</QUERY6>
  <QUERY7 searched="foo">1</QUERY7>
</RESPONSE>
</xml>

我有下面的课

public class Result{
 public string SearchValue {get;set;}
 public string SearchResult {get;set;}
}

而这段代码

...
List<Result> r = new List<Result>();
XDocument doc = XDocument.Parse(xmlResult);
foreach( var item in doc.Descendants("RESPONSE")){
 r.Add(new Result{
   SearchValue = item.Attribute("searched").Value,
   SearchResult = item.Element("QUERY?").Value
 });
}
...

如何获取所有搜索关键字和搜索结果到列表对象？

推荐答案

您可以将其转换为json对象并使用Linq

    XmlDocument xmlDoc = new XmlDocument();
    xmlDoc.LoadXml(xmlResult);
    var jObj = JObject.Parse(JsonConvert.SerializeXmlNode(xmlDoc));

    List<Result> results = ((JObject)jObj["RESPONSE"]).Properties()
               .Where(v => v.Name.StartsWith("QUERY"))
               .Select(v => new Result
               {
                   SearchValue = (string)v.Value["@searched"],
                   SearchResult = (string)v.Value["#text"]
               }).ToList();