|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/87401a0c/944f02a0/ |
?#pragma checksum "D:\wwwroot\cnhbclw\wwwroot\App_Code\SqlHelper\XMLProcess.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "B3652F054F469C07A1F9E0F1D8B88FB5"
#line 1 "D:\wwwroot\cnhbclw\wwwroot\App_Code\SqlHelper\XMLProcess.cs"
using System;
using System.Data;
using System.IO;
using System.Xml;
namespace Base
{
/// <summary>
/// XML文件处置类
/// </summary>
public class XMLProcess
{
public XMLProcess()
{
}
public XMLProcess(string strPath)
{
this._XMLPath = strPath;
}
private string _XMLPath;
public string XMLPath
{
get { return this._XMLPath; }
}
/// <summary>
/// 导入XML文件
/// </summary>
/// <param name="XMLPath">XML文件蹊径</param>
/// <returns></returns>
private XmlDocument XMLLoad()
{
string XMLFile = XMLPath;
XmlDocument xmldoc = new XmlDocument();
try
{
string filename = AppDomain.CurrentDomain.BaseDirectory.ToString() + XMLFile;
if (File.Exists(filename))
xmldoc.Load(filename);
}
catch (Exception e)
{ }
return xmldoc;
}
/// <summary>
/// 导入XML文件
/// </summary>
/// <param name="XMLPath">XML文件蹊径</param>
/// <returns></returns>
private static XmlDocument XMLLoad(string strPath)
{
XmlDocument xmldoc = new XmlDocument();
try
{
string filename = AppDomain.CurrentDomain.BaseDirectory.ToString() + strPath;
if (File.Exists(filename))
xmldoc.Load(filename);
}
catch (Exception e)
{ }
return xmldoc;
}
/// <summary>
/// 读取指定节点的数据
/// </summary>
/// <param name="node">节点</param>
/// <returns>string</returns>
/**************************************************
* 使用示列:
* XMLProsess.Read("/Node", "")
* XMLProsess.Read("/Node/Element[@Attribute='Name']")
************************************************/
public string Read(string node)
{
string value = "";
try
{
XmlDocument doc = XMLLoad();
XmlNode xn = doc.SelectSingleNode(node);
value = xn.InnerText;
}
catch { }
return value;
}
/// <summary>
/// 读取指定蹊径和节点的串联值
/// </summary>
/// <param name="path">蹊径</param>
/// <param name="node">节点</param>
/// <param name="attribute">属性名，非空时返回该属性值，不然返回串联值</param>
/// <returns>string</returns>
/**************************************************
* 使用示列:
* XMLProsess.Read(path, "/Node", "")
* XMLProsess.Read(path, "/Node/Element[@Attribute='Name']")
************************************************/
public static string Read(string path, string node)
{
string value = "";
try
{
XmlDocument doc = XMLLoad(path);
XmlNode xn = doc.SelectSingleNode(node);
value = xn.InnerText;
}
catch { }
return value;
}
/// <summary>
/// 读取指定蹊径和节点的属性值
/// </summary>
/// <param name="path">蹊径</param>
/// <param name="node">节点</param>
/// <param name="attribute">属性名，非空时返回该属性值，不然返回串联值</param>
/// <returns>string</returns>
/**************************************************
* 使用示列:
* XMLProsess.Read(path, "/Node", "")
* XMLProsess.Read(path, "/Node/Element[@Attribute='Name']", "Attribute")
************************************************/
public static string Read(string path, string node, string attribute)
{
string value = "";
try
{
XmlDocument doc = XMLLoad(path);
XmlNode xn = doc.SelectSingleNode(node);
value = (attribute.Equals("") ? xn.InnerText : xn.Attributes[attribute].Value);
}
catch { }
return value;
}
/// <summary>
/// 获取某一节点的所有孩子节点的值
/// </summary>
/// <param name="node">要查问的节点</param>
/// <returns></returns>
public string[] ReadAllChildallValue(string node)
{
string[] str ={ };
int i = 0;
XmlDocument doc = XMLLoad();
XmlNode xn = doc.SelectSingleNode(node);
//得到该节点的子节点
XmlNodeList nodelist = xn.ChildNodes;
if (nodelist.Count > 0)
{
str = new string[nodelist.Count];
foreach (XmlElement el in nodelist)//读元素值
{
str[i] = el.Value;
i++;
}
}
return str;
}
/// <summary>
/// 获取某一节点的所有孩子节点的值
/// </summary>
/// <param name="node">要查问的节点</param>
/// <returns></returns>
public XmlNodeList ReadAllChild(string node)
{
XmlDocument doc = XMLLoad();
XmlNode xn = doc.SelectSingleNode(node);
//得到该节点的子节点
XmlNodeList nodelist = xn.ChildNodes;
return nodelist;
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="path">蹊径</param>
/// <param name="node">节点</param>
/// <param name="element">元素名，非空时插入新元素，不然在该元素中插入属性</param>
/// <param name="attribute">属性名，非空时插入该元素属性值，不然插入元素值</param>
/// <param name="value">值</param>
/// <returns></returns>
/**************************************************
* 使用示列:
* XMLProsess.Insert(path, "/Node", "Element", "", "Value")
* XMLProsess.Insert(path, "/Node", "Element", "Attribute", "Value")
* XMLProsess.Insert(path, "/Node", "", "Attribute", "Value")
************************************************/
public static void Insert(string path, string node, string element, string attribute, string value)
{
try
{
XmlDocument doc = new XmlDocument();
doc.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + path);
XmlNode xn = doc.SelectSingleNode(node);
if (element.Equals(""))
{
if (!attribute.Equals(""))
{
XmlElement xe = (XmlElement)xn;
xe.SetAttribute(attribute, value);
}
}
else
{
XmlElement xe = doc.CreateElement(element);
if (attribute.Equals(""))
xe.InnerText = value;
else
xe.SetAttribute(attribute, value);
xn.AppendChild(xe);
}
doc.Save(AppDomain.CurrentDomain.BaseDirectory.ToString() + path);
}
catch { }
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="path">蹊径</param>
/// <param name="node">节点</param>
/// <param name="element">元素名，非空时插入新元素，不然在该元素中插入属性</param>
/// <param name="strList">strList是一个二维数组，它的值是由xml属性名和值组成的</param>
/// <returns></returns>
public static void Insert(string path, string node, string element, string[][] strList)
{
try
{
XmlDocument doc = new XmlDocument();
doc.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + path);
XmlNode xn = doc.SelectSingleNode(node);
XmlElement xe = doc.CreateElement(element);
string strAttribute="";
string strValue="";
for (int i = 0; i < strList.Length; i++)
{
for (int j = 0; j < strList[i].Length; j++)
{
if (j == 0)
strAttribute = strList[i][j];
else
strValue=strList[i][j];
}
if (strAttribute.Equals(""))
xe.InnerText = strValue;
else
xe.SetAttribute(strAttribute,strValue);
}
xn.AppendChild(xe);
doc.Save(AppDomain.CurrentDomain.BaseDirectory.ToString() + path);
}
catch { }
}
/// <summary>
/// 批改指定节点的数据（）
/// </summary>
/// <param name="node">节点</param>
/// <param name="value">值</param>
/// <returns></returns>
public void Update(string node, string value)
{
try
{
XmlDocument doc = XMLLoad();
XmlNode xn = doc.SelectSingleNode(node);
xn.InnerText = value;
doc.Save(AppDomain.CurrentDomain.BaseDirectory.ToString() + XMLPath);
}
catch { }
}
/// <summary>
/// 批改指定节点的数据
/// </summary>
/// <param name="path">蹊径</param>
/// <param name="node">节点</param>
/// <param name="value">值</param>
/// <returns></returns>
/**************************************************
* 使用示列:
* XMLProsess.Insert(path, "/Node","Value")
* XMLProsess.Insert(path, "/Node","Value")
************************************************/
public static void Update(string path, string node, string value)
{
try
{
XmlDocument doc = XMLLoad(path);
XmlNode xn = doc.SelectSingleNode(node);
xn.InnerText = value;
doc.Save(AppDomain.CurrentDomain.BaseDirectory.ToString() + path);
}
catch { }
}
/// <summary>
/// 批改指定节点的属性值(静态)
/// </summary>
/// <param name="path">蹊径</param>
/// <param name="node">节点</param>
/// <param name="attribute">属性名，非空时批改该节点属性值，不然批改节点值</param>
/// <param name="value">值</param>
/// <returns></returns>
/**************************************************
* 使用示列:
* XMLProsess.Insert(path, "/Node", "", "Value")
* XMLProsess.Insert(path, "/Node", "Attribute", "Value")
************************************************/
public static void Update(string path, string node, string attribute, string value)
{
try
{
XmlDocument doc = XMLLoad(path);
XmlNode xn = doc.SelectSingleNode(node);
XmlElement xe = (XmlElement)xn;
if (attribute.Equals(""))
xe.InnerText = value;
else
xe.SetAttribute(attribute, value);
doc.Save(AppDomain.CurrentDomain.BaseDirectory.ToString() + path);
}
catch { }
}
/// <summary>
/// 删除节点值
/// </summary>
/// <param name="path">蹊径</param>
/// <param name="node">节点</param>
/// <param name="attribute">属性名，非空时删除该节点属性值，不然删除节点值</param>
/// <param name="value">值</param>
/// <returns></returns>
/**************************************************
* 使用示列:
* XMLProsess.Delete(path, "/Node", "")
* XMLProsess.Delete(path, "/Node", "Attribute")
************************************************/
public static void Delete(string path, string node)
{
try
{
XmlDocument doc = XMLLoad(path);
XmlNode xn = doc.SelectSingleNode(node);
XmlElement xe = (XmlElement)xn;
xn.ParentNode.RemoveChild(xn);
doc.Save(AppDomain.CurrentDomain.BaseDirectory.ToString() + path);
}
catch { }
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="path">蹊径</param>
/// <param name="node">节点</param>
/// <param name="attribute">属性名，非空时删除该节点属性值，不然删除节点值</param>
/// <param name="value">值</param>
/// <returns></returns>
/**************************************************
* 使用示列:
* XMLProsess.Delete(path, "/Node", "")
* XMLProsess.Delete(path, "/Node", "Attribute")
************************************************/
public static void Delete(string path, string node, string attribute)
{
try
{
XmlDocument doc = XMLLoad(path);
XmlNode xn = doc.SelectSingleNode(node);
XmlElement xe = (XmlElement)xn;
if (attribute.Equals(""))
xn.ParentNode.RemoveChild(xn);
else
xe.RemoveAttribute(attribute);
doc.Save(AppDomain.CurrentDomain.BaseDirectory.ToString() + path);
}
catch { }
}
/// <summary> 读取Xml返回一个经排序或筛选后的DataView</summary>
/// <param name="strXmlPath"></param>
/// <param name="strWhere">筛选前提，如："name = 'kgdiwss'"</param>
/// <param name="strSort">排序前提，如："Id desc"</param>
/// <returns<〈/returns>
public DataView GetDataViewByXml(string strWhere, string strSort)
{
try
{
string XMLFile = this.XMLPath;
string filename = AppDomain.CurrentDomain.BaseDirectory.ToString() + XMLFile;
DataSet ds = new DataSet();
ds.ReadXml(filename);
//创建DataView来实现排序或筛选操作
DataView dv = new DataView(ds.Tables[0]);
if (strSort != null)
{
//对DataView中的纪录进行排序
dv.Sort = strSort;
}
if (strWhere != null)
{
//对DataView中的纪录进行筛选，找到我们想要的纪录
dv.RowFilter = strWhere;
}
return dv;
}
catch (Exception)
{
return null;
}
}
}
}
#line default
#line hidden