C#讀取XML的CDATA節(jié)點內容實例詳解

2020-01-24 00:02:37

字體：大中小

來源：轉載

供稿：網(wǎng)友

首先看實例代碼：

昨天讀取了以下XML, 之前沒有讀取過類似的格式,用一種比較笨的方法讀取的,記錄下<?xml version="1.0"?><response><srvver>1.0</srvver><srvcode>000</srvcode><payload><param type="XML" key="data"><![CDATA[<Response> <Execution>  <Status code="0" sql_code="0" description="執(zhí)行成功！"/> </Execution> <ResponseContent>  <Parameter/>  <Document>   <RecordSet id="1">    <Master name="M" node_id="1">     <Record>      <Field name="MTRL_ID" value="51722500H031"/>      <Field name="IS_MAIN" value="Y"/>      <Field name="MAIN_ID" value="51722500H031"/>      <Field name="DOSAGE" value="1.0"/>      <Field name="NN_QTY" value="1000.0"/>      <Field name="TN_QTY" value="1000.0"/>      <Field name="SEQ" value="70.0"/>      <Field name="POINT_STR" value=""/>     </Record>    </Master>   </RecordSet>   <RecordSet id="2">    <Master name="M" node_id="2">     <Record>      <Field name="MTRL_ID" value="51820590H001"/>      <Field name="IS_MAIN" value="N"/>      <Field name="MAIN_ID" value="51820590H001"/>      <Field name="DOSAGE" value="1.0"/>      <Field name="NN_QTY" value="1000.0"/>      <Field name="TN_QTY" value="500.0"/>      <Field name="SEQ" value="30.0"/>      <Field name="POINT_STR" value=""/>     </Record>    </Master>   </RecordSet>   <RecordSet id="3">    <Master name="M" node_id="3">     <Record>      <Field name="MTRL_ID" value="51820710H002"/>      <Field name="IS_MAIN" value="N"/>      <Field name="MAIN_ID" value="51820510H002"/>      <Field name="DOSAGE" value="0.0"/>      <Field name="NN_QTY" value="0.0"/>      <Field name="TN_QTY" value="1000.0"/>      <Field name="SEQ" value="20.0"/>      <Field name="POINT_STR" value=""/>     </Record>    </Master>   </RecordSet>    </Document> </ResponseContent></Response>]]></param></payload></response>

以下是讀取xml節(jié)點的過程

我的目的是想要讀取CDATA里面的 <RecordSet></RecordSet> 包裹的數(shù)據(jù)

1.我先建立了一個類

public class ReadXml  {    public string RecordSet;    public string MTRL_ID;    public string IS_MAIN;    public string MAIN_ID;    public string DOSAGE;    public string NN_QTY;    public string TN_QTY;    public string SEQ;    public string POINT_STR;  }

2. 接著我把CDATA里面的內容提出來

XmlDocument doc = new XmlDocument();      doc.LoadXml(strFile); var cdata = (XmlCDataSection)doc.SelectSingleNode("/response/payload/param/text()");

3. 然后用XElement的Linq方法找到 RecordSet 節(jié)點集合, 循環(huán)節(jié)點集合,賦值,以下是實現(xiàn)代碼:

XElement xe = XElement.Parse(cdata.InnerText);  IEnumerable<XElement> elements = from ele in xe.Elements("ResponseContent").Elements("Document").Elements("RecordSet") select ele;          List<ReadXml> xmlNodeList = new List<ReadXml>();      foreach (var ele in elements)      {        ReadXml xmlNode= new ReadXml();        model.RecordSet = ele.Attribute("id").Value;        var subeles = ele.Elements("Master").Elements("Record").Elements("Field");        foreach (var item in subeles)        {          if (item.Attribute("name").Value == "MTRL_ID")          {            xmlNode.MTRL_ID = item.Attribute("name").NextAttribute.Value;          }          if (item.Attribute("name").Value == "IS_MAIN")          {            xmlNode.IS_MAIN = item.Attribute("name").NextAttribute.Value;          }          if (item.Attribute("name").Value == "MAIN_ID")          {            xmlNode.MAIN_ID = item.Attribute("name").NextAttribute.Value;          }          if (item.Attribute("name").Value == "DOSAGE")          {            xmlNode.DOSAGE = item.Attribute("name").NextAttribute.Value;          }          if (item.Attribute("name").Value == "NN_QTY")          {            xmlNode.NN_QTY = item.Attribute("name").NextAttribute.Value;          }          if (item.Attribute("name").Value == "TN_QTY")          {            xmlNode.TN_QTY = item.Attribute("name").NextAttribute.Value;          }          if (item.Attribute("name").Value == "SEQ")          {            xmlNode.SEQ = item.Attribute("name").NextAttribute.Value;          }          if (item.Attribute("name").Value == "POINT_STR")          {            xmlNode.POINT_STR=item.Attribute("name").NextAttribute.Value;          }                  }        xmlNodeList.Add(xmlNode);      }