我收到了一个SOAP服务的响应。它看起来像这样:
<ArrayOfPaymentHistory_ST xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/">
<PaymentHistory_ST>
<tTRANSDATE>2015-01-05T08:58:17</tTRANSDATE>
<tPAIDTO>2015-02-01T00:00:00</tPAIDTO>
<dAMOUNT>110</dAMOUNT>
<dBALANCE>0</dBALANCE>
<TRANSKIND>Auto CC Payment</TRANSKIND>
<csUnit>Lee</csUnit>
</PaymentHistory_ST>
<PaymentHistory_ST>
<tTRANSDATE>2015-01-01T08:58:17</tTRANSDATE>
<tPAIDTO>2015-01-01T00:00:00</tPAIDTO>
<dAMOUNT>-110</dAMOUNT>
<dBALANCE>110</dBALANCE>
<TRANSKIND>Rent Posted</TRANSKIND>
<csUnit>Lee</csUnit>
</PaymentHistory_ST>
</ArrayOfPaymentHistory_ST>
我定义了一个模型,如下所示:
public class payment_history
{
public DateTime tTRANSDATE { get; set; }
public DateTime tPAIDTO { get; set; }
public double dAMOUNT { get; set; }
public double dBALANCE { get; set; }
public string TRANSKIND { get; set; }
}
我正在尝试解析这个XML响应,并创建一个payment_history类型的对象列表。然后,我将把这个对象发送到我的标记上,并在表格中显示。我发现很多关于使用XMLReader进行XML解析的帖子。但是我仍然无法找到一个能够优雅地解决这个问题的好方法。
这是我的C#代码。
List<payment_history> ph = new List<payment_history>();
payment_history p = new payment_history();
using (WebResponse response = request.GetResponse())
{
using (StreamReader rd = new StreamReader(response.GetResponseStream()))
{
string soapResult = rd.ReadToEnd();
using (XmlReader reader = XmlReader.Create(new StringReader(soapResult)))
{
#region parseXML
while (reader.Read())
{
foreach (var el in reader.ReadOuterXml())
{
if (reader.IsStartElement())
{
//return only when you have START tag
switch (reader.Name.ToString())
{
case "tTRANSDATE":
p.tTRANSDATE = Convert.ToDateTime(reader.ReadString());
break;
case "tPAIDTO":
p.tPAIDTO = Convert.ToDateTime(reader.ReadString());
break;
case "dAMOUNT":
p.dAMOUNT = Convert.ToDouble(reader.ReadString());
break;
case "dBALANCE":
p.dBALANCE = Convert.ToDouble(reader.ReadString());
break;
case "TRANSKIND":
p.TRANSKIND = reader.ReadString();
break;
}
ph.Add(p);
}
}
}
#endregion
}
}
}
return ph;
有人能指导我如何使这个工作吗?我是c#的新手。任何形式的帮助将不胜感激。
我尝试了遵循LINQ2XML,但没有返回任何东西!!
ph = XDocument.Parse(soapResult)
.Descendants("PaymentHistory_ST")
.Select(g => new payment_history
{
tTRANSDATE = (DateTime)g.Element("tTRANSDATE"),
tPAIDTO = (DateTime)g.Element("tPAIDTO"),
dAMOUNT = (double)g.Element("dAMOUNT"),
dBALANCE = (double)g.Element("dBALANCE"),
TRANSKIND = (string)g.Element("TRANSKIND")
}).ToList();