• Linq to XML遍历


     

     

    XML实例文档
      1 XML文档 <?xml version="1.0" encoding="utf-8"?>
      2 <fenxiao_orders_get_response>
      3   <purchase_orders list="true">
      4     <purchase_order>
      5       <id>258429315086973</id>
      6       <buyer_payment>378.00</buyer_payment>
      7       <distributor_from>taobao</distributor_from>
      8       <distributor_username>小公主精品坊</distributor_username>
      9       <distributor_payment>347.36</distributor_payment>
     10       <receiver>
     11         <address>埤城镇菜市场大门向北50米 华硕联想专卖 XXXX)</address>
     12         <district>丹阳市</district>
     13         <city>镇江市</city>
     14         <name>XXX</name>
     15         <mobile_phone>158061014444</mobile_phone>
     16         <phone></phone>
     17         <zip>212311</zip>
     18         <state>江苏省</state>
     19       </receiver>
     20       <fenxiao_id>1321177225990</fenxiao_id>
     21       <created>2013-05-13 12:26:54</created>
     22       <modified>2013-05-13 12:27:23</modified>
     23       <memo></memo>
     24       <status>WAIT_SELLER_SEND_GOODS</status>
     25       <alipay_no>2013051300001000140005672268</alipay_no>
     26       <pay_time>2013-05-13 12:27:21</pay_time>
     27       <pay_type>ALIPAY_SURETY</pay_type>
     28       <post_fee>0.00</post_fee>
     29       <shipping>SELLER</shipping>
     30       <sub_purchase_orders list="true">
     31         <sub_purchase_order>
     32           <item_id>342150555073</item_id>
     33           <item_outer_id>SS32S5657Y-5</item_outer_id>
     34           <auction_price>501.00</auction_price>
     35           <sku_outer_id>02230</sku_outer_id>
     36           <sku_id>1626255255073</sku_id>
     37           <bill_fee>378.00</bill_fee>
     38           <num>1</num>
     39           <buyer_payment>378.00</buyer_payment>
     40           <distributor_payment>347.36</distributor_payment>
     41           <total_fee>347.36</total_fee>
     42           <fenxiao_id>1321177225990</fenxiao_id>
     43           <created>2013-05-13 12:26:54</created>
     44           <old_sku_properties>颜色分类:02黄色,尺码:36</old_sku_properties>
     45           <order_200_status>WAIT_SELLER_SEND_GOODS</order_200_status>
     46           <price>347.36</price>
     47           <refund_fee>0.00</refund_fee>
     48           <sc_item_id>0</sc_item_id>
     49           <sku_properties>颜色分类:02黄色,尺码:36</sku_properties>
     50           <snapshot_url>http://gongxiao.tmall.com/product/product_snapshot.htm?subOrderId=1321177225990</snapshot_url>
     51           <status>WAIT_SELLER_SEND_GOODS</status>
     52           <id>258429315086973</id>
     53           <tc_order_id>218773986530992</tc_order_id>
     54           <title>星期六2013新款夏款羊皮高跟撞色拼坡跟细带凉鞋女鞋子SS32S5657Y</title>
     55         </sub_purchase_order>
     56       </sub_purchase_orders>
     57       <supplier_flag>0</supplier_flag>
     58       <supplier_from>taobao</supplier_from>
     59       <supplier_memo></supplier_memo>
     60       <supplier_username>淘趣女鞋专营店</supplier_username>
     61       <tc_order_id>218773986530992</tc_order_id>
     62       <total_fee>347.36</total_fee>
     63       <trade_type>AGENT</trade_type>
     64     </purchase_order>
     65     <purchase_order>
     66       <id>345350203660933</id>
     67       <buyer_payment>465.00</buyer_payment>
     68       <distributor_from>taobao</distributor_from>
     69       <distributor_username>kuuki小铺</distributor_username>
     70       <distributor_payment>427.38</distributor_payment>
     71       <receiver>
     72         <address>清城南区2号楼1单元702</address>
     73         <district>大兴区</district>
     74         <city>北京市</city>
     75         <name>XXX</name>
     76         <mobile_phone>15901107928</mobile_phone>
     77         <phone></phone>
     78         <zip>102600</zip>
     79         <state>北京</state>
     80       </receiver>
     81       <fenxiao_id>1321068151888</fenxiao_id>
     82       <created>2013-05-13 11:59:53</created>
     83       <modified>2013-05-13 13:00:33</modified>
     84       <memo>分销商kuuki小铺(2013-05-13 13:00:33)(已付款,未发货) :发中通!。</memo>
     85       <order_messages list="true">
     86         <order_message>
     87           <message_title>分销商留言</message_title>
     88           <message_content>发中通!</message_content>
     89           <message_time>2013-05-13 13:00:33</message_time>
     90           <pic_url>null</pic_url>
     91         </order_message>
     92       </order_messages>
     93       <status>WAIT_SELLER_SEND_GOODS</status>
     94       <alipay_no>2013051300001000320005717495</alipay_no>
     95       <pay_time>2013-05-13 12:59:11</pay_time>
     96       <pay_type>ALIPAY_SURETY</pay_type>
     97       <post_fee>0.00</post_fee>
     98       <shipping>SELLER</shipping>
     99       <sub_purchase_orders list="true">
    100         <sub_purchase_order>
    101           <item_id>331727105073</item_id>
    102           <item_outer_id>310045107-5</item_outer_id>
    103           <auction_price>628.50</auction_price>
    104           <sku_outer_id>0017225</sku_outer_id>
    105           <sku_id>1554103375073</sku_id>
    106           <bill_fee>465.00</bill_fee>
    107           <num>1</num>
    108           <buyer_payment>465.00</buyer_payment>
    109           <distributor_payment>427.38</distributor_payment>
    110           <total_fee>427.38</total_fee>
    111           <fenxiao_id>1321068151289</fenxiao_id>
    112           <created>2013-05-13 11:59:53</created>
    113           <old_sku_properties>颜色分类:0017黑+金,尺码:35</old_sku_properties>
    114           <order_200_status>WAIT_SELLER_SEND_GOODS</order_200_status>
    115           <price>427.38</price>
    116           <refund_fee>0.00</refund_fee>
    117           <sc_item_id>0</sc_item_id>
    118           <sku_properties>颜色分类:0017黑+金,尺码:35</sku_properties>
    119           <snapshot_url>http://gongxiao.tmall.com/product/product_snapshot.htm?subOrderId=1321068151289</snapshot_url>
    120           <status>WAIT_SELLER_SEND_GOODS</status>
    121           <id>345350203660933</id>
    122           <tc_order_id>258417910438629</tc_order_id>
    123           <title>迪芙斯2013新品高跟牛皮撞色拼粗带金属凉鞋女鞋子5107-0017</title>
    124         </sub_purchase_order>
    125       </sub_purchase_orders>
    126       <supplier_flag>0</supplier_flag>
    127       <supplier_from>taobao</supplier_from>
    128       <supplier_memo></supplier_memo>
    129       <supplier_username>淘趣女鞋专营店</supplier_username>
    130       <tc_order_id>258417910438629</tc_order_id>
    131       <total_fee>427.38</total_fee>
    132       <trade_type>AGENT</trade_type>
    133     </purchase_order>
    134       <total_results>47</total_results>
    135 </fenxiao_orders_get_response>
    136 <!--top164198.cm3-->

     

     1 string pp = xml.OuterXml;
     2             XElement xele = XElement.Parse(pp).Element("purchase_orders");
     3             XElement ll = XElement.Parse(pp);
     4 
     5            //查询出buyer_payment大于400的节点
     6             IEnumerable<XElement> order = from mmmm in xele.Elements("purchase_order") where Convert .ToDouble(mmmm.Element("buyer_payment").Value)>400 select mmmm;
     7 
     8             //或者IEnumerable<XElement> order = xele.Elements("purchase_order");
     9             foreach (XElement p in order)
    10             {
    11                 string aa = p.Element("buyer_payment").Value;
    12                 IEnumerable<XElement> receiver = p.Elements("receiver");
    13                 foreach (XElement a in receiver)
    14                 {
    15                     string address = a.Element("address").Value;
    16                 }
    17                 IEnumerable<XElement> sub_purchase_orders = p.Element("sub_purchase_orders").Elements("sub_purchase_order");
    18                 foreach (XElement b in sub_purchase_orders)
    19                 {
    20                     string jkljk=b.Element("item_outer_id").Value;
    21                 }
    22             }
  • 相关阅读:
    a==null和a.equals("null")的区别
    PHP_EOL换行符
    mysql 重启
    异或的用法
    so easy(并查集+unordered_map)
    牛客练习赛51 C 勾股定理
    Period II
    Simpsons’ Hidden Talents
    POJ-1961 Period
    poj-2406 Power Strings
  • 原文地址:https://www.cnblogs.com/xiaofengfeng/p/3075626.html
Copyright © 2020-2023  润新知