XML的基本操作--

XML的增删改查，后台逻辑代码已给出，至于前台数据录入有兴趣可以试试（简单三层）！

XML转化为DataTable

StudentInfo.xml文件内容：

<?xml version="1.0" encoding="GB2312"?><students>  <student c_id="1" c_code="2101224101" c_name="One" c_remark="c_remark" c_type="2010" c_status="0" /></students>

CmdInfoDAL类:

public class CmdInfoDAL{public static DbBase db = new DbBase();#region XML的基本操作/// <summary>/// 新增/// </summary>/// <param name="entity"></param>/// <param name="xmlName">StudentInfo</param>/// <param name="nodeDir">students/student</param>public void AddCmdInfo(CmdInfo entity,string xmlName,string nodeDir){string xmlrootDir = db.xmlrootDir;XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load(xmlrootDir + "\\" + xmlName);XmlNode root = xmlDoc.SelectSingleNode("students");//查找XmlNodeList studentNodeList = xmlDoc.SelectNodes(nodeDir);if (studentNodeList != null){int cloumnCounts = studentNodeList[0].Attributes.Count;string[] nodeAttributesName = new string[cloumnCounts];for (int i = 0; i < cloumnCounts; i++){nodeAttributesName[i] = studentNodeList[0].Attributes[i].Name;}string nodeName = nodeDir.Substring(nodeDir.LastIndexOf("/") + 1);//获取结点名字XmlElement xeItem = xmlDoc.CreateElement(nodeName);//创建一个名为nodeName的结点xeItem.SetAttributeNode(nodeAttributesName[0], (studentNodeList.Count + 1).ToString());//设置节点的“c_id属性”值，在已有的基础上Counts+1//然后绑定entity实例root.AppendChild(xeItem);//将节点加上父目录xmlDoc.Save(xmlrootDir + "\\" + xmlName);}}/// <summary>///删除XML指定目录下column/// </summary>/// <param name="macroType"></param>/// <param name="xmlName"></param>/// <param name="nodeXml"></param>/// <returns></returns>public int DeleteXmlCmdInfoByType(string Type, string xmlName, string nodeDir){int delCounts = 0;string xmlrootDir = db.xmlrootDir;XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load(xmlrootDir + "\\" + xmlName);//XmlNode root = xmlDoc.SelectSingleNode("students");//查找XmlNodeList studentNodeList = xmlDoc.SelectNodes(nodeDir);if (studentNodeList != null){foreach (XmlNode studentNode in studentNodeList){if (studentNode.Attributes["c_type"].Value == Type && studentNode.Attributes["c_status"].Value == "0"){studentNode.Attributes["c_status"].Value = "1";delCounts++;}}xmlDoc.Save(xmlrootDir + "\\" + xmlName);}return delCounts;}/// <summary>/// 删除指定目录下column的值为“Id”的行/// </summary>/// <param name="Id"></param>/// <param name="xmlName"></param>/// <param name="nodeDir"></param>/// <returns></returns>public int DeleteXmlCmdInfoById(int Id, string xmlName, string nodeDir){int delCounts = 0;string xmlrootDir = db.xmlrootDir;XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load(xmlrootDir + "\\" + xmlName);//XmlNode root = xmlDoc.SelectSingleNode("students");//查找XmlNodeList studentNodeList = xmlDoc.SelectNodes(nodeDir);if (studentNodeList != null){foreach (XmlNode studentNode in studentNodeList){if (studentNode.Attributes[0].Value == Id.ToString() && studentNode.Attributes["c_status"].Value == "0"){//假删除studentNode.Attributes["c_status"].Value = "1";//真删除//xmlDoc.RemoveChild(studentNode);delCounts++;}}xmlDoc.Save(xmlrootDir + "\\" + xmlName);}return delCounts;}/// <summary>/// 修改指定目录下column值为“entity.Id”的行/// </summary>/// <param name="entity"></param>/// <param name="xmlName"></param>/// <param name="nodeDir"></param>/// <returns></returns>public void UpdateXmlCmdInfoById(CmdInfo entity, string xmlName, string nodeDir){string xmlrootDir = db.xmlrootDir;XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load(xmlrootDir + "\\" + xmlName);//XmlNode root = xmlDoc.SelectSingleNode("students");//查找XmlNodeList studentNodeList = xmlDoc.SelectNodes(nodeDir);if (studentNodeList != null){foreach (XmlNode studentNode in studentNodeList){if (studentNode.Attributes[0].Value == entity.c_id.ToString() && studentNode.Attributes["c_status"].Value == "0"){studentNode.Attributes["c_code"].Value = entity.c_code;studentNode.Attributes["c_name"].Value = entity.c_name;studentNode.Attributes["c_remark"].Value = entity.c_remark;studentNode.Attributes["c_type"].Value = entity.c_type;break;//不是循环更新}}xmlDoc.Save(xmlrootDir + "\\" + xmlName);}}/// <summary>/// 获取实例By主键Id/// </summary>/// <param name="Id"></param>/// <param name="xmlName"></param>/// <param name="nodeDir"></param>/// <returns></returns>public CmdInfo GetXmlCmdInfoModel(int Id, string xmlName, string nodeDir){string xmlrootDir = db.xmlrootDir;XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load(xmlrootDir + "\\" + xmlName);//XmlNode root = xmlDoc.SelectSingleNode("students");//查找XmlNodeList studentNodeList = xmlDoc.SelectNodes(nodeDir);CmdInfo entity = null;if (studentNodeList != null){foreach (XmlNode studentNode in studentNodeList){if (studentNode.Attributes[0].Value == Id.ToString() && studentNode.Attributes["c_status"].Value == "0"){entity.c_code = studentNode.Attributes["c_code"].Value;entity.c_name = studentNode.Attributes["c_name"].Value;entity.c_remark = studentNode.Attributes["c_remark"].Value;entity.c_type = studentNode.Attributes["c_type"].Value;break;}}}return entity;}/// <summary>/// 获取文件名为xmlName的目录为nodeDir的所有数量/// </summary>/// <param name="xmlName"></param>/// <param name="nodeDir"></param>/// <returns></returns>public int GetXmlCmdInfoCounts(string xmlName, string nodeDir){string xmlrootDir = db.xmlrootDir;XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load(xmlrootDir + "\\" + xmlName);//XmlNode root = xmlDoc.SelectSingleNode("students");//查找XmlNodeList studentNodeList = xmlDoc.SelectNodes(nodeDir);int rowCounts = 0;if (studentNodeList != null){foreach (XmlNode studentNode in studentNodeList){rowCounts++;}}return rowCounts;}/// <summary>/// 将Xml指定column值为columnValue的行转化为DataTable/// </summary>/// <param name="xmlName">指定目录下文件名</param>/// <param name="columnName">查询column字段</param>/// <param name="columnValue">查询column值满足的值</param>/// <param name="nodeDir">在Xml文件内字节路径</param>/// <returns></returns>public DataTable XmlToDataTable(string xmlName, string columnName, string columnValue, string nodeDir){string xmlrootDir = db.xmlrootDir;XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load(xmlrootDir + "\\" + xmlName);//XmlNode root = xmlDoc.SelectSingleNode("students");//查找XmlNodeList studentNodeList = xmlDoc.SelectNodes(nodeDir);DataTable dt = new DataTable();if (studentNodeList != null){dt.Columns.Clear();int columnCounts = studentNodeList[0].Attributes.Count;for (int i = 0; i < columnCounts; i++){dt.Columns.Add(studentNodeList[0].Attributes[i].Value);}foreach (XmlNode studentNode in studentNodeList){if (studentNode.Attributes[columnName].Value == columnValue && studentNode.Attributes["c_status"].Value == "0"){DataRow dr =dt.NewRow();for (int i = 0; i < columnCounts; i++){dr[i] = studentNode.Attributes[i].Value;}dt.Rows.Add(dr);}}}return dt;}/// <summary>/// 将Xml文件转化为DataTable/// </summary>/// <param name="xmlName"></param>/// <param name="nodeDir"></param>/// <returns></returns>public DataTable XmlToDataTable(string xmlName,string nodeDir){string xmlrootDir = db.xmlrootDir;XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load(xmlrootDir + "\\" + xmlName);//XmlNode root = xmlDoc.SelectSingleNode("students");//查找XmlNodeList studentNodeList = xmlDoc.SelectNodes(nodeDir);DataTable dt = new DataTable();if (studentNodeList != null){dt.Columns.Clear();int columnCounts = studentNodeList[0].Attributes.Count;for (int i = 0; i < columnCounts; i++){dt.Columns.Add(studentNodeList[0].Attributes[i].Value);}foreach (XmlNode studentNode in studentNodeList){if (studentNode.Attributes["c_status"].Value == "0"){DataRow dr = dt.NewRow();for (int i = 0; i < columnCounts; i++){dr[i] = studentNode.Attributes[i].Value;}dt.Rows.Add(dr);}}}return dt;}public DataTable XmlToDataTable(string xmlName,string columnName,string[] columnValueArry, string nodeDir){string xmlrootDir = db.xmlrootDir;XmlDocument xmlDoc = new XmlDocument();xmlDoc.Load(xmlrootDir + "\\" + xmlName);//XmlNode root = xmlDoc.SelectSingleNode("students");//查找XmlNodeList studentNodeList = xmlDoc.SelectNodes(nodeDir);DataTable dt = new DataTable();if (studentNodeList != null){dt.Columns.Clear();int columnCounts = studentNodeList[0].Attributes.Count;for (int i = 0; i < columnCounts; i++){dt.Columns.Add(studentNodeList[0].Attributes[i].Value);}foreach (XmlNode studentNode in studentNodeList){foreach (string columnValue in columnValueArry){if (studentNode.Attributes[columnName].Value == columnValue && studentNode.Attributes["c_status"].Value == "0"){DataRow dr = dt.NewRow();for (int i = 0; i < columnCounts; i++){dr[i] = studentNode.Attributes[i].Value;}dt.Rows.Add(dr);}}}}return dt;}#endregion}

CmdInfo类：

public class CmdInfo{public CmdInfo(){ }private string _c_id;private string _c_code;private string _c_name;private string _c_remark;private string _c_type;private string _c_status;/// <summary>/// /// </summary>public string c_id{set { _c_id = value; }get { return _c_id; }}public string c_code{set { _c_code = value; }get { return _c_code; }}public string c_name{set { _c_name = value; }get { return _c_name; }}public string c_remark{set { _c_remark = value; }get { return _c_remark; }}public string c_type{set { _c_type = value; }get { return _c_type; }}public string c_status{set { _c_status = value; }get { return _c_status; }}}

DbBase类：

public class DbBase{public static string xmlrootDirStr = Directory.GetCurrentDirectory();public string xmlrootDir{get {string rootDirStr = xmlrootDirStr.ToString();rootDirStr = rootDirStr.Substring(0,rootDirStr.LastIndexOf("\\"));rootDirStr = rootDirStr.Substring(0, rootDirStr.LastIndexOf("\\"));return rootDirStr + @"\XmlFile";}}}