从XML获取数据:NetSuite Web服务

Question

我想从 NetSuite WebService获取数据。这就是我的代码的样子：

public class HomeController : Controller
{
    WebServiceGenesisSoapClient service;
    public HomeController()
    {
        var aa = WebServiceGenesisSoapClient.EndpointConfiguration.WebServiceGenesisSoap;
        service = new WebServiceGenesisSoapClient(aa);
    }
    public async Task<IActionResult> Index()
    {
        WebServiceGenesisSoapClient client = new WebServiceGenesisSoapClient(aa, "http://82.71.28.125/WebServiceGenesis/WebServiceGenesis.asmx");
        GetStockQuantityArrayRequest getStockQuantityArrayRequest = new GetStockQuantityArrayRequest();
        var stocklist = client.GetStockQuantityArrayAsync(getStockQuantityArrayRequest).Result;
        ArrayOfXElement res = stocklist.GetStockQuantityArrayResult;
    }
}

res变量中存在两个节点。这就是第一个节点的样子：

<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="StockQuantityArray">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Colour" type="xs:string" minOccurs="0" />
              <xs:element name="Quantity1" type="xs:int" minOccurs="0" />
              <xs:element name="Quantity2" type="xs:int" minOccurs="0" />
              <xs:element name="Quantity3" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>

这就是我的第二个节点的样子：

<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" />

如果响应中存在数据，则它们以第二个节点存在。如果不存在数据，我想在第一个节点的xs:sequence元素内获取name属性的值。

编辑1：如果存在数据，则第一个节点看起来像：

<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Departments">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" type="xs:string" minOccurs="0" />
              <xs:element name="Description" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>

和第二个节点看起来像：

<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
  <NewDataSet xmlns="">
    <Departments diffgr:id="Departments1" msdata:rowOrder="0">
      <Code>ALL</Code>
      <Description>ALL</Description>
    </Departments>
    <Departments diffgr:id="Departments2" msdata:rowOrder="1">
      <Code>BABY</Code>
      <Description>BABY</Description>
    </Departments>
    <Departments diffgr:id="Departments3" msdata:rowOrder="2">
      <Code>CHIL</Code>
      <Description>CHILD</Description>
    </Departments>
    <Departments diffgr:id="Departments4" msdata:rowOrder="3">
      <Code>TEEN</Code>
      <Description>TEEN</Description>
    </Departments>
    <Departments diffgr:id="Departments5" msdata:rowOrder="4">
      <Code>WM</Code>
      <Description>WOMAN</Description>
    </Departments>
  </NewDataSet>
</diffgr:diffgram>

Answer 1

请尝试此

        XmlNode secondNode = getSecondNode();// read the second node from the res
        if (secondNode != null)
        {
            XmlNodeList xnList = secondNode.SelectNodes("//NewDataSet//Departments");
            foreach (XmlNode xn in xnList)
            {
                string code = xn.SelectSingleNode("Code") != null ? xn.SelectSingleNode("Code").Value : "";
                string Description = xn.SelectSingleNode("Description") != null ? xn.SelectSingleNode("Description").Value : "";
            }
        }
        else
        {
            XmlNamespaceManager nsmgr = new XmlNamespaceManager(doc.NameTable);
            nsmgr.AddNamespace("bk", "http://www.w3.org/2001/XMLSchema");
            XmlNode firstNode = getFirstNode();// read the first node from the res
            XmlNodeList xnList = firstNode.SelectNodes("//bk:sequence//bk:element", nsmgr);
            foreach (XmlNode xn in xnList)
            {
                string value = ((System.Xml.XmlElement)xn).Attributes["name"].Value;
            }
        }

Answer 2

尝试按照XML Linq：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
using System.Xml.Linq;
namespace ConsoleApplication122
{
    class Program
    {
        const string FILENAME = @"c:temptest.xml";
        static void Main(string[] args)
        {
            XDocument doc = XDocument.Load(FILENAME);
            XElement root = doc.Root;
            XNamespace ns = root.GetDefaultNamespace();
            XNamespace nsDiffgr = root.GetNamespaceOfPrefix("diffgr");
            XNamespace nsData = root.GetNamespaceOfPrefix("msdata");
            List<Department> deparments = doc.Descendants(ns + "Departments").Select(x => new Department()
            {
                id = (string)x.Attribute(nsDiffgr + "id"),
                code = (string)x.Element(ns + "Code"),
                description = (string)x.Element(ns + "Description"),
                rowOrder = (int)x.Attribute(nsData + "rowOrder")
            }).ToList();
            Dictionary<string, Department> dict = deparments
                .GroupBy(x => x.id, y => y)
                .ToDictionary(x => x.Key, y => y.FirstOrDefault());
        }
    }
    public class Department
    {
        public string id { get; set; }
        public string code { get; set; }
        public string description { get; set; }
        public int rowOrder { get;set;}
    }
}