解析MapQuest XML响应
本文关键字:响应 XML MapQuest 解析 | 更新日期: 2023-09-27 18:08:39
返回的XML:
<IncidentsResponse>
<Incidents>
<Incident>
<id>920959670</id>
<type>1</type>
<severity>3</severity>
<eventCode>701</eventCode>
<lat>35.91411</lat>
<lng>-86.82417</lng>
<startTime>2014-03-01T01:00:00.000-05:00</startTime>
<endTime>2016-06-16T00:59:00.000-04:00</endTime>
<shortDesc>
I-65 : Maintenance work between Exit 59 TN-840 and Exit 65 TN-96
</shortDesc>
<fullDesc>
Intermittent lane closures due to maintenance work on I-65 both ways between Exit 59 TN-840 and Exit 65 TN-96.
</fullDesc>
<delayFromTypical>0.0</delayFromTypical>
<delayFromFreeFlow>0.0</delayFromFreeFlow>
<distance>12.09</distance>
<iconURL>https://api.mqcdn.com/mqtraffic/const_mod.png</iconURL>
</Incident>
</Incidents>
</IncidentsResponse>
我想将其提取为两个简短的描述符,分别从shortDesc和severity中获得。以下是我到目前为止的c#尝试:
string[] incidentsDscrp = { };
string[] severity = { };
int count = 0;
XDocument doc = XDocument.Parse(traffData);
foreach (var incidents in doc.Descendants("Incident"))
{
incidentsDscrp[count] = incidents.Element("shortDesc").Value;
severity[count] = incidents.Element("severity").Value;
count++;
}
trafficLabel.Text = "";
for (int a = 0; a < incidentsDscrp.Length; a++)
{
trafficLabel.Text += incidentsDscrp[a];
trafficLabel.Text += severity[a];
}
基本上,我想将事件描述存储在incidentsDscrp数组中,并将严重性级别存储在严重性数组中,然后将它们作为文本添加到winforms标签中。
编辑:我的错误是索引超出了数组在
的边界severity[count] = incidents.Element("severity").value;
行
很抱歉,你做错了。
首先,像这样存储数据(在并行集合中)是一个非常糟糕的主意。你应该看看Jon Skeet的博客文章:反模式:并行集合。
现在,解决你的问题。下面是一个LINQ到XML的小查询,它允许您从XML文档中获得所需的所有内容:
var items = from i in xDoc.Root.Element("Incidents").Elements("Incident")
select new
{
ShortDescription = (string)i.Element("shortDesc"),
Severity = (int)i.Element("severity")
};
您可以使用String.Join
:
var text = String.Join(",", items.Select(x => string.Format("{0}: {1}", x.ShortDescription.Trim(), x.Severity.ToString())));
对于示例文档,text
的值为:
I-65: 59号出口TN-840和65号出口TN-96之间的维修工作:3
更改格式字符串的分隔符以获得所需的结果。现在你可以把它赋值给标签:
trafficLabel.Text = text;
使用下列代码解析并创建标签-
from c in trafficData.Descendants("Incident")
select new
{
ShortDescription = c.Element("shortDesc").Value,
Severity = c.Element("severity").Value
}).Aggregate((a,b) => a.ShortDescription +": " + a.Severity +", "
+ b.ShortDescription +": " + b.Severity);