110,533
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="utf-16"?>
<items>
<totalResults>404</totalResults>
<Rows>
<orderCode>SC12031900028</orderCode>
<orderCode_item>
<Item>
<treasuryCoding>5</treasuryCoding>
<orderCode>SC12031900028</orderCode>
<consignmentBrand>999999</consignmentBrand>
<productId>LE-42S35FW</productId>
<productName>Pangoo42寸LED 3D电视LE-42S35FW-含挂架</productName>
<specification>42寸 3D</specification>
<orderQuantity>1</orderQuantity>
<shipmentsIn>1</shipmentsIn>
<isCancel />
<isScheduled />
<salesPrice>0.0000</salesPrice>
<itemStats>10</itemStats>
<date>2012/3/19 0:00:00</date>
<returnNum />
<purchasePrice>3117.0000</purchasePrice>
<returnsNum>0</returnsNum>
<returnsNum_Arr>0</returnsNum_Arr>
<weight>19.50</weight>
<timeInventory>0</timeInventory>
<inspection_Num />
<barcode>06949791500716</barcode>
<barcode1 />
<refundRecord />
<unitPrice>0.0000</unitPrice>
<totalPrice>0.0000</totalPrice>
<gifts_Num />
<totalFifoCost />
<digitalAndLibrary />
</Item>
<Item>
<treasuryCoding>5</treasuryCoding>
<orderCode>SC12031900028</orderCode>
<consignmentBrand>999999</consignmentBrand>
<productId>SU12030900019</productId>
<productName>42S35一年延保</productName>
<specification>42S35一年延保</specification>
<orderQuantity>1</orderQuantity>
<shipmentsIn>1</shipmentsIn>
<isCancel />
<isScheduled />
<salesPrice>0.0000</salesPrice>
<itemStats>10</itemStats>
<date>2012/3/19 0:00:00</date>
<returnNum />
<purchasePrice>0.0000</purchasePrice>
<returnsNum>0</returnsNum>
<returnsNum_Arr>0</returnsNum_Arr>
<weight>0.00</weight>
<timeInventory>0</timeInventory>
<inspection_Num />
<barcode>TM12030900019</barcode>
<barcode1 />
<refundRecord />
<unitPrice>0.0000</unitPrice>
<totalPrice>0.0000</totalPrice>
<gifts_Num />
<totalFifoCost />
<digitalAndLibrary />
</Item>
</orderCode_item>
</Rows>
</items>
foreach (XmlNode node in xml.ChildNodes)
{
if (node.Name == "items")
{
foreach (XmlNode node1 in node.ChildNodes)
{
if (node1.Name == "Rows")
{
foreach (XmlNode node2 in node1.ChildNodes)
{
if (node2.Name == "orderCode_item")
{
foreach (XmlNode node3 in node2.ChildNodes)
{
if (node3.Name == "Item")
{
foreach (XmlNode node4 in node3.ChildNodes)
{
switch (node4.Name)
{
case "orderCode":
orderCode = node4.InnerText;
break;
case "productId":
productId = node4.InnerText;
break;
case "productName":
productName = node4.InnerText;
break;
case "orderQuantity":
orderQuantity=node4.InnerText;
break;
case "totalPrice":
totalPrice = node4.InnerText;
break;
}
}
}
}
}
}
<?xml version="1.0" encoding="utf-16"?>
<items>
<totalResults>404</totalResults>
<Rows>
<invoiceIsPrint>False</invoiceIsPrint>
<totalMoney>965597.32</totalMoney>
<totNum>716</totNum>
<orderCode_item>
<Item>
<treasuryCoding>5</treasuryCoding>
<orderCode>SC12031900028</orderCode>
<digitalAndLibrary />
</Item>
<Item>
<treasuryCoding>5</treasuryCoding>
<orderCode>SC12031900028</orderCode>
<digitalAndLibrary />
</Item>
</orderCode_item>
</Rows>
</items>
foreach (XmlNode node in xml.ChildNodes)
{
if (node.Name == "items")
{
foreach (XmlNode node1 in node.ChildNodes)
{
if (node1.Name == "Rows")
{
foreach (XmlNode node2 in node1.ChildNodes)
{
if (node2.Name == "orderCode_item")
{
foreach (XmlNode node3 in node2.ChildNodes)
{
if (node3.Name == "Item")
{
foreach (XmlNode node4 in node3.ChildNodes)
{
switch (node4.Name)
{
case "orderCode":
orderCode = node4.InnerText;
break;
case "productId":
productId = node4.InnerText;
break;
case "productName":
productName = node4.InnerText;
break;
case "orderQuantity":
orderQuantity=node4.InnerText;
break;
case "totalPrice":
totalPrice = node4.InnerText;
break;
}
}
}
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
namespace TestXml
{
class Program
{
static void Main(string[] args)
{
XmlElement theBook = null;
XmlElement theElement = null;
XmlElement root = null;
XmlDocument xmlDoc = new XmlDocument();
try
{
xmlDoc.Load("book.xml");
//xmlDoc.LoadXml("<item><name>wrench</name></item>");
root = xmlDoc.DocumentElement;
// ---新建一本书开始 ----
theBook = xmlDoc.CreateElement("book");
theBook.SetAttribute("id", "B01");
theElement = xmlDoc.CreateElement("name");
theElement.InnerText = "新书";
theBook.AppendChild(theElement);
theElement = xmlDoc.CreateElement("price");
theElement.InnerText = "20";
theBook.AppendChild(theElement);
theElement = xmlDoc.CreateElement("memo");
theElement.InnerText = "新书更好看...";
theBook.AppendChild(theElement);
root.AppendChild(theBook);
Console.Out.WriteLine("---新建一本书开始---");
Console.Out.WriteLine(xmlDoc.OuterXml);
//下面对 三国演义做一些修改
//查询找 《三国演义》 --
theBook = (XmlElement)root.SelectSingleNode("/books/book[name='三国演义']") ;
Console.Out.WriteLine("--- 查找《三国演义》 ----");
Console.Out.WriteLine(theBook.OuterXml);
//修改这本书的 属性
theBook.GetElementsByTagName("price").Item(0).InnerText = "90";//getElementsByTagName返回的是NodeList,所以要跟上item(0)
// 根据节点属性删除节点
theBook = (XmlElement)root.SelectSingleNode("/books/book[@id='B06']");
if (theBook != null)
{
Console.Out.WriteLine("---删除id 为 B06的书籍---");
Console.Out.WriteLine(theBook.OuterXml);
theBook.ParentNode.RemoveChild(theBook);
}
else {
Console.Out.WriteLine("未查找到指定的节点...");
}
/*
//---将价格低于20的书籍删除掉---
XmlNodeList someBooks = root.SelectNodes("/books/book[price<20]");
Console.Out.WriteLine("删除所有价格低于20的书籍.");
Console.Out.WriteLine("---符合条件的书籍有 " + someBooks.Count + " 本。---") ;
for (int i = 0; i < someBooks.Count; i++) {
someBooks.Item(i).ParentNode.RemoveChild(someBooks.Item(i));
}
Console.Out.WriteLine("---删除后的XML---");
Console.Out.WriteLine(xmlDoc.OuterXml);
//---将名字=777---
XmlNodeList someBooks1 = root.SelectNodes("/books/book[name='777']");
Console.Out.WriteLine("删除名字为777的书籍.");
Console.Out.WriteLine("---符合条件的书籍有 " + someBooks1.Count + " 本。---");
for (int i = 0; i < someBooks1.Count; i++)
{
someBooks1.Item(i).ParentNode.RemoveChild(someBooks1.Item(i));
}
Console.Out.WriteLine("---删除后的XML---");
Console.Out.WriteLine(xmlDoc.OuterXml);
*/
XmlNodeList someBooks = root.SelectNodes("/books/book[contains(name,'77')]");
Console.Out.WriteLine("---符合条件的书籍有 " + someBooks.Count + " 条. ---");
xmlDoc.Save("book.xml");
Console.In.Read();
}catch (Exception e) {
Console.Out.Write(e.Message);
Console.In.Read();
}
}
}
}