从C#LINQ到XML的国家气象服务SOAP服务解析XML

时间:2022-12-01 11:09:16

I'm a junior C# programmer that's trying to develop a library that will allow me to encapsulate the nasty details of parsing the XML returned from the NWS, and returning a collection representing the data.

我是一名初级C#程序员,正在尝试开发一个库,它允许我封装解析从NWS返回的XML的令人讨厌的细节,并返回表示数据的集合。

My SOAP request would return an XML document in this form:

我的SOAP请求将以这种形式返回XML文档:

<?xml version="1.0" encoding="UTF-8"?>
<dwml version="1.0" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.nws.noaa.gov/forecasts/xml/DWMLgen/schema/DWML.xsd">
  <head>
    <product srsName="WGS 1984" concise-name="time-series" operational-mode="official">
      <title>NOAA's National Weather Service Forecast Data</title>
      <field>meteorological</field>
      <category>forecast</category>
      <creation-date refresh-frequency="PT1H">2009-02-04T20:01:00Z</creation-date>
    </product>
    <source>
      <more-information>http://www.nws.noaa.gov/forecasts/xml/</more-information>
      <production-center>Meteorological Development Laboratory<sub-center>Product Generation Branch</sub-center></production-center>
      <disclaimer>http://www.nws.noaa.gov/disclaimer.html</disclaimer>
      <credit>http://www.weather.gov/</credit>
      <credit-logo>http://www.weather.gov/images/xml_logo.gif</credit-logo>
      <feedback>http://www.weather.gov/feedback.php</feedback>
    </source>
  </head>
  <data>
    <location>
      <location-key>point1</location-key>
      <point latitude="42.23" longitude="-83.27"/>
    </location>
    <moreWeatherInformation applicable-location="point1">http://forecast.weather.gov/MapClick.php?textField1=42.23&amp;textField2=-83.27</moreWeatherInformation>
    <time-layout time-coordinate="local" summarization="none">
      <layout-key>k-p24h-n7-1</layout-key>
      <start-valid-time>2009-02-04T07:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-04T19:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-05T07:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-05T19:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-06T07:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-06T19:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-07T07:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-07T19:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-08T07:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-08T19:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-09T07:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-09T19:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-10T07:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-10T19:00:00-05:00</end-valid-time>
    </time-layout>
    <time-layout time-coordinate="local" summarization="none">
      <layout-key>k-p24h-n6-2</layout-key>
      <start-valid-time>2009-02-04T19:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-05T08:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-05T19:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-06T08:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-06T19:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-07T08:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-07T19:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-08T08:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-08T19:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-09T08:00:00-05:00</end-valid-time>
      <start-valid-time>2009-02-09T19:00:00-05:00</start-valid-time>
      <end-valid-time>2009-02-10T08:00:00-05:00</end-valid-time>
    </time-layout>
    <parameters applicable-location="point1">
      <temperature type="maximum" units="Fahrenheit" time-layout="k-p24h-n7-1">
        <name>Daily Maximum Temperature</name>
        <value>15</value>
        <value>19</value>
        <value>33</value>
        <value>46</value>
        <value>41</value>
        <value>43</value>
        <value>44</value>
      </temperature>
      <temperature type="minimum" units="Fahrenheit" time-layout="k-p24h-n6-2">
        <name>Daily Minimum Temperature</name>
        <value>-2</value>
        <value>16</value>
        <value>29</value>
        <value>32</value>
        <value>27</value>
        <value>32</value>
      </temperature>
    </parameters>
  </data>
</dwml>

I'm trying to put the maximum and minimum temps that are inside this XML in separate collections of strings while ignoring the "name" elements using LINQ.

我试图将这个XML中的最大和最小临时值放在单独的字符串集合中,而忽略使用LINQ的“name”元素。

Edit: This is the code I use to get the XML from the Web Reference:

编辑:这是我用来从Web Reference获取XML的代码:

    WeatherNWS.ndfdXML client = new TestNWS.WeatherNWS.ndfdXML();

    string XMLZip = client.LatLonListZipCode("48180");

    XElement myElement = XElement.Parse(XMLZip);
    string[] myString = myElement.Value.Split(',');

    decimal lat = Convert.ToDecimal(myString[0]);
    decimal lon = Convert.ToDecimal(myString[1]);

    weatherParametersType parameters = new weatherParametersType();

    parameters.maxt = true;
    parameters.mint = true;

    string XML = client.NDFDgen(lat, lon, productType.timeseries, DateTime.Now, DateTime.Now.AddDays(7), parameters);

2 个解决方案

#1


This should be able to get the maximum temperatures for you, you would just have to change the where filter to get the minimums

这应该能够为您获得最高温度,您只需要更改where过滤器以获得最小值

 using System.Xml.Linq;
 \\...

 XDocument xmlDoc = XDocument.Load("YourXml.xml");
 var maximums = from tempvalue in xmlDoc.Descendants("temperature").Elements("value")
                           where tempvalue.Parent.Attribute("type").Value == "maximum"
                           select (string)tempvalue;

List<string> returnme = maximums.ToList<string>();
return returnme;

Hope this help.

希望这有帮助。

Note: I'm a bit rusty with my Linq to Xml in C# so it may not be the most elegant solution.

注意:我在C#中使用Linq to Xml有点生疏,所以它可能不是最优雅的解决方案。

#2


You'll probably need to parse the xml you get back with xpath to pull out the data you want. There's a brief example here.

您可能需要解析使用xpath返回的xml来提取所需的数据。这里有一个简短的例子。

Alternatively you could create a class structure that mirrors the xml structure and use the XmlSerializer to deserialize the xml into objects, but that's probably more trouble than it's worth in this case.

或者,您可以创建一个镜像xml结构的类结构,并使用XmlSerializer将xml反序列化为对象,但在这种情况下,这可能比它的价值更麻烦。

#1


This should be able to get the maximum temperatures for you, you would just have to change the where filter to get the minimums

这应该能够为您获得最高温度,您只需要更改where过滤器以获得最小值

 using System.Xml.Linq;
 \\...

 XDocument xmlDoc = XDocument.Load("YourXml.xml");
 var maximums = from tempvalue in xmlDoc.Descendants("temperature").Elements("value")
                           where tempvalue.Parent.Attribute("type").Value == "maximum"
                           select (string)tempvalue;

List<string> returnme = maximums.ToList<string>();
return returnme;

Hope this help.

希望这有帮助。

Note: I'm a bit rusty with my Linq to Xml in C# so it may not be the most elegant solution.

注意:我在C#中使用Linq to Xml有点生疏,所以它可能不是最优雅的解决方案。

#2


You'll probably need to parse the xml you get back with xpath to pull out the data you want. There's a brief example here.

您可能需要解析使用xpath返回的xml来提取所需的数据。这里有一个简短的例子。

Alternatively you could create a class structure that mirrors the xml structure and use the XmlSerializer to deserialize the xml into objects, but that's probably more trouble than it's worth in this case.

或者,您可以创建一个镜像xml结构的类结构,并使用XmlSerializer将xml反序列化为对象,但在这种情况下,这可能比它的价值更麻烦。