C#自訂處理xml資料類執行個體

標籤：base   gpo   更新   cat   else   c#   single   pad   trim   

本文執行個體講述了C#自訂處理xml資料類。分享給大家供大家參考。具體分析如下：

這個C#類專門使用者處理xml資料，可以大大簡化xml的操作，類中封裝了常用的xml操作，包括開啟、讀取xml資料，讀取、寫入節點資料，通過xpath讀取節點資料，匯出節點資料等等，還可以根據需要自己擴充類的功能。

using System;using System.Data;using System.IO;using System.Xml;namespace DotNet.Utilities{  public class XMLProcess  {    #region 建構函式    public XMLProcess()    { }    public XMLProcess(string strPath)    {      this._XMLPath = strPath;    }    #endregion    #region 公有屬性    private string _XMLPath;    public string XMLPath    {      get { return this._XMLPath; }    }    #endregion    #region 私人方法    /// <summary>    /// 匯入XML檔案    /// </summary>    /// <param name="XMLPath">XML檔案路徑</param>    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>    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="strPath">Xml的路徑</param>    private static string GetXmlFullPath(string strPath)    {      if (strPath.IndexOf(":") > 0)      {        return strPath;      }      else      {        return System.Web.HttpContext.Current.Server.MapPath(strPath);      }    }    #endregion    #region 讀取資料    /// <summary>    /// 讀取指定節點的資料    /// </summary>    /// <param name="node">節點</param>    /// 使用示列:    /// 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>    /// 使用示列:    /// 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>    /// 使用示列:    /// 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>    public string[] ReadAllChildallValue(string node)    {      int i = 0;      string[] str = { };      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>    public XmlNodeList ReadAllChild(string node)    {      XmlDocument doc = XMLLoad();      XmlNode xn = doc.SelectSingleNode(node);      XmlNodeList nodelist = xn.ChildNodes; //得到該節點的子節點      return nodelist;    }    /// <summary>    /// 讀取XML返回經排序或篩選後的DataView    /// </summary>    /// <param name="strWhere">篩選條件，如:"name=‘kgdiwss‘"</param>    /// <param name="strSort"> 排序條件，如:"Id desc"</param>    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 dv = new DataView(ds.Tables[0]); //建立DataView來完成排序或篩選操作        if (strSort != null)        {          dv.Sort = strSort; //對DataView中的記錄進行排序        }        if (strWhere != null)        {          dv.RowFilter = strWhere; //對DataView中的記錄進行篩選，找到我們想要的記錄        }        return dv;      }      catch (Exception)      {        return null;      }    }    /// <summary>    /// 讀取XML返回DataSet    /// </summary>    /// <param name="strXmlPath">XML檔案相對路徑</param>    public DataSet GetDataSetByXml(string strXmlPath)    {      try      {        DataSet ds = new DataSet();        ds.ReadXml(GetXmlFullPath(strXmlPath));        if (ds.Tables.Count > 0)        {          return ds;        }        return null;      }      catch (Exception)      {        return null;      }    }    #endregion    #region 插入資料    /// <summary>    /// 插入資料    /// </summary>    /// <param name="path">路徑</param>    /// <param name="node">節點</param>    /// <param name="element">元素名，非空時插入新元素，否則在該元素中插入屬性</param>    /// <param name="attribute">屬性名稱，非空時插入該元素屬性值，否則插入元素值</param>    /// <param name="value">值</param>    /// 使用示列:    /// 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">由XML屬性名稱和值組成的二維數組</param>    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="strXmlPath">XML檔案相對路徑</param>    /// <param name="Columns">要插入行的列名數組，如：string[] Columns = {"name","IsMarried"};</param>    /// <param name="ColumnValue">要插入行每列的值數組，如：string[] ColumnValue={"XML大全","false"};</param>    /// <returns>成功返回true,否則返回false</returns>    public static bool WriteXmlByDataSet(string strXmlPath, string[] Columns, string[] ColumnValue)    {      try      {        //根據傳入的XML路徑得到.XSD的路徑，兩個檔案放在同一個目錄下        string strXsdPath = strXmlPath.Substring(0, strXmlPath.IndexOf(".")) + ".xsd";        DataSet ds = new DataSet();        ds.ReadXmlSchema(GetXmlFullPath(strXsdPath)); //讀XML架構，關係到列的資料類型        ds.ReadXml(GetXmlFullPath(strXmlPath));        DataTable dt = ds.Tables[0];        DataRow newRow = dt.NewRow(); //在原來的表格基礎上建立新行        for (int i = 0; i < Columns.Length; i++) //迴圈給一行中的各個列賦值        {          newRow[Columns[i]] = ColumnValue[i];        }        dt.Rows.Add(newRow);        dt.AcceptChanges();        ds.AcceptChanges();        ds.WriteXml(GetXmlFullPath(strXmlPath));        return true;      }      catch (Exception)      {        return false;      }    }    #endregion    #region 修改資料    /// <summary>    /// 修改指定節點的資料    /// </summary>    /// <param name="node">節點</param>    /// <param name="value">值</param>    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>    /// 使用示列:    /// 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>    /// 使用示列:    /// 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="strXmlPath">XML檔案路徑</param>    /// <param name="Columns">列名數組</param>    /// <param name="ColumnValue">列值數組</param>    /// <param name="strWhereColumnName">條件列名</param>    /// <param name="strWhereColumnValue">條件列值</param>    public static bool UpdateXmlRow(string strXmlPath, string[] Columns, string[] ColumnValue, string strWhereColumnName, string strWhereColumnValue)    {      try      {        string strXsdPath = strXmlPath.Substring(0, strXmlPath.IndexOf(".")) + ".xsd";        DataSet ds = new DataSet();        ds.ReadXmlSchema(GetXmlFullPath(strXsdPath));//讀XML架構，關係到列的資料類型        ds.ReadXml(GetXmlFullPath(strXmlPath));        //先判斷行數        if (ds.Tables[0].Rows.Count > 0)        {          for (int i = 0; i < ds.Tables[0].Rows.Count; i++)          {            //如果目前記錄為符合Where條件的記錄            if (ds.Tables[0].Rows[i][strWhereColumnName].ToString().Trim().Equals(strWhereColumnValue))            {              //迴圈給找到行的各列賦新值              for (int j = 0; j < Columns.Length; j++)              {                ds.Tables[0].Rows[i][Columns[j]] = ColumnValue[j];              }              ds.AcceptChanges();           //更新DataSet              ds.WriteXml(GetXmlFullPath(strXmlPath));//重新寫入XML檔案              return true;            }          }        }        return false;      }      catch (Exception)      {        return false;      }    }    #endregion    #region 刪除資料    /// <summary>    /// 刪除節點值    /// </summary>    /// <param name="path">路徑</param>    /// <param name="node">節點</param>    /// <param name="attribute">屬性名稱，非空時刪除該節點屬性值，否則刪除節點值</param>    /// <param name="value">值</param>    /// 使用示列:    /// 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);        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>    /// 使用示列:    /// 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>    /// 刪除所有行    /// </summary>    /// <param name="strXmlPath">XML路徑</param>    public static bool DeleteXmlAllRows(string strXmlPath)    {      try      {        DataSet ds = new DataSet();        ds.ReadXml(GetXmlFullPath(strXmlPath));        if (ds.Tables[0].Rows.Count > 0)        {          ds.Tables[0].Rows.Clear();        }        ds.WriteXml(GetXmlFullPath(strXmlPath));        return true;      }      catch (Exception)      {        return false;      }    }    /// <summary>    /// 通過刪除DataSet中指定索引行，重寫XML以實現刪除指定行    /// </summary>    /// <param name="iDeleteRow">要刪除的行在DataSet中的Index值</param>    public static bool DeleteXmlRowByIndex(string strXmlPath, int iDeleteRow)    {      try      {        DataSet ds = new DataSet();        ds.ReadXml(GetXmlFullPath(strXmlPath));        if (ds.Tables[0].Rows.Count > 0)        {          ds.Tables[0].Rows[iDeleteRow].Delete();        }        ds.WriteXml(GetXmlFullPath(strXmlPath));        return true;      }      catch (Exception)      {        return false;      }    }    /// <summary>    /// 刪除指定列中指定值的行    /// </summary>    /// <param name="strXmlPath">XML相對路徑</param>    /// <param name="strColumn">列名</param>    /// <param name="ColumnValue">指定值</param>    public static bool DeleteXmlRows(string strXmlPath, string strColumn, string[] ColumnValue)    {      try      {        DataSet ds = new DataSet();        ds.ReadXml(GetXmlFullPath(strXmlPath));        if (ds.Tables[0].Rows.Count > 0)        {          //判斷行多還是刪除的值多，多的for迴圈放在裡面          if (ColumnValue.Length > ds.Tables[0].Rows.Count)          {            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)            {              for (int j = 0; j < ColumnValue.Length; j++)              {                if (ds.Tables[0].Rows[i][strColumn].ToString().Trim().Equals(ColumnValue[j]))                {                  ds.Tables[0].Rows[i].Delete();                }              }            }          }          else          {            for (int j = 0; j < ColumnValue.Length; j++)            {              for (int i = 0; i < ds.Tables[0].Rows.Count; i++)              {                if (ds.Tables[0].Rows[i][strColumn].ToString().Trim().Equals(ColumnValue[j]))                {                  ds.Tables[0].Rows[i].Delete();                }              }            }          }          ds.WriteXml(GetXmlFullPath(strXmlPath));        }        return true;      }      catch (Exception)      {        return false;      }    }    #endregion  }}

希望本文所述對大家的C#程式設計有所協助。

除聲明外， 跑步客文章均為原創，轉載請以連結形式標明本文地址
  C#自訂處理xml資料類執行個體

本文地址:  http://www.paobuke.com/develop/c-develop/pbk23070.html

相關內容C# 檔案上傳下載(Excel匯入,多線程下載)功能的實現代碼Mongodb在CSharp裡實現Aggregate執行個體winform c#中子表單關閉重新整理父表單的執行個體protobuf對象二進位序列化儲存(詳解)
C#6.0中10大新特性的應用和總結C#播放鈴聲最簡單實現方法C#將jpg轉換為pdf的方法DevExpress擷取節點下可視地區子節點集合的實現方法

C#自訂處理xml資料類執行個體