Xml使用二三事： 小事2：做一个XML文件存储数据的知识整理工具UrlMgr。
由于最近忙别的事情，所以没来的写文章。先登记一下，稍后时间将介绍该工具的实现和我自己写的
一个通用的xml文件存储数据的机制和代码（任意字符，均可存入，如'<','&'等xml的特殊字符）。
愿与大家分享知识，共同进步。
未来改善目标:
1、如何将多线程的机制，加入到xml文件存储机制。
2、解决不同xml数据表文件中，实现外键链接查询
以下是程序界面和效果
程序可以设置默认显示栏目：
新建大的功能分类和树形深度，没有数目限制。
新建功能栏目
收藏网页，可以添加备注无文字数目限制。
欢迎大家，测试和修改，并且能够发我一份（tiandong19860806@126.com）
核心代码如下：
为了安全起见取消下载，我先重装系统杀毒，之后在把代码打包发上来。
Action.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Collections;
namespace UrlMgr
{
public class Action : BaseClass
{
#region 常用函数
#region Catalog
/// <summary>
/// 查询分类方式
/// </summary>
/// <returns></returns>
public List<Catalog> GetAllCatalog()
{
DataTable dt = null;
List<Catalog> list = null;
string[] relations = new string[]
{
"contains"
};
string[] fields = new string[]
{
MySettings.Catalog_ID
};
string[] values = new string[]
{
null
};
string[] types = new string[]
{
typeof(string).ToString().ToString()
};
dt = this.GetXmlRow(MySettings.CatalogXmlFpath, relations, fields, values, types);
if (dt != null)
{
list = new List<Catalog>();
foreach (DataRow dr in dt.Rows)
{
Catalog item = new Catalog()
{
ID = dr[MySettings.Catalog_ID].ToString().Trim(),
Title = dr[MySettings.Catalog_Title].ToString().Trim(),
Desc = dr[MySettings.Catalog_Desc].ToString().Trim(),
Creator = dr[MySettings.Catalog_Creator].ToString().Trim(),
CreateTime = DateTime.Parse(dr[MySettings.Catalog_CreateTime].ToString().Trim()),
Editor = dr[MySettings.Catalog_Editor].ToString().Trim()
};
if(dr[MySettings.Catalog_EditTime].ToString().Trim() != "")
{
item.EditTime = DateTime.Parse(dr[MySettings.Catalog_EditTime].ToString().Trim());
}
list.Add(item);
}
// 升序排序
list.Sort(delegate(Catalog x, Catalog y)
{
return Comparer<string>.Default.Compare(x.Title, y.Title);
});
}
dt = null;
relations = fields = values = null;
return list;
}
/// <summary>
/// 查询分类方式
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public List<Catalog> GetCatalog(Catalog obj)
{
if (obj == null)
{
obj = new Catalog();
}
DataTable dt = null;
List<Catalog> list = null;
string[] relations = new string[]
{
"=",
"contains",
"contains" ,
"contains" ,
">=",
"contains" ,
"<="
};
string[] fields = new string[]
{
MySettings.Catalog_ID,
MySettings.Catalog_Title,
MySettings.Catalog_Desc,
MySettings.Catalog_Creator,
MySettings.Catalog_CreateTime,
MySettings.Catalog_Editor,
MySettings.Catalog_EditTime
};
string[] values = new string[]
{
obj.ID,
obj.Title,
obj.Desc,
obj.Creator,
obj.CreateTime == DateTime.MinValue ? null : obj.CreateTime.ToString(MySettings.TimeLong24HHFormat),
obj.Editor,
obj.EditTime == DateTime.MinValue ? null : obj.EditTime.ToString(MySettings.TimeLong24HHFormat)
};
string[] types = new string[]
{
typeof(String).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(DateTime).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(DateTime).ToString().ToLower(),
};
dt = this.GetXmlRow(MySettings.CatalogXmlFpath, relations, fields, values, types);
if (dt != null)
{
list = new List<Catalog>();
foreach (DataRow dr in dt.Rows)
{
Catalog item = new Catalog()
{
ID = dr[MySettings.Catalog_ID].ToString().Trim(),
Title = dr[MySettings.Catalog_Title].ToString().Trim(),
Desc = dr[MySettings.Catalog_Desc].ToString().Trim(),
Creator = dr[MySettings.Catalog_Creator].ToString().Trim(),
CreateTime = DateTime.Parse(dr[MySettings.Catalog_CreateTime].ToString().Trim()),
Editor = dr[MySettings.Catalog_Editor].ToString().Trim(),
};
if (dr[MySettings.Catalog_EditTime].ToString().Trim() != "")
{
item.EditTime = DateTime.Parse(dr[MySettings.Catalog_EditTime].ToString().Trim());
}
list.Add(item);
}
// 升序排序
list.Sort(delegate(Catalog x, Catalog y)
{
return Comparer<string>.Default.Compare(x.Title, y.Title);
});
}
dt = null;
relations = fields = values = null;
return list;
}
/// <summary>
/// 添加分类方式
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int AddCatalog(Catalog obj)
{
int flag = 0;
string[] fields = null;
List<Dictionary<string, string>> values = null;
try
{
fields = new string[] {
MySettings.Catalog_ID,
MySettings.Catalog_Title,
MySettings.Catalog_Desc,
MySettings.Catalog_Creator,
MySettings.Catalog_CreateTime,
MySettings.Catalog_Editor,
MySettings.Catalog_EditTime
};
values = new List<Dictionary<string, string>>();
values.Add(new Dictionary<string, string>());
values[0].Add(MySettings.Catalog_ID, obj.ID);
values[0].Add(MySettings.Catalog_Title, obj.Title);
values[0].Add(MySettings.Catalog_Desc, obj.Desc);
values[0].Add(MySettings.Catalog_Creator, obj.Creator);
values[0].Add(MySettings.Catalog_CreateTime, obj.CreateTime.ToString(MySettings.TimeLong24HHFormat));
flag = this.NewXmlRow(
MySettings.CatalogXmlFpath,
fields,
values,
true
);
}
catch (Exception ex)
{
throw ex;
}
finally
{
fields = null;
values = null;
}
return flag;
}
/// <summary>
/// 修改分类方式
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int SetCatalog(Catalog obj)
{
int flag = 0;
string[] primaryKeys = null;
string[] primaryValues = null;
string[] fields = null;
string[] values = null;
try
{
primaryKeys = new string[] { MySettings.Catalog_ID };
primaryValues = new string[] { obj.ID };
fields = new string[] {
MySettings.Catalog_Title,
MySettings.Catalog_Desc,
MySettings.Catalog_Editor,
MySettings.Catalog_EditTime
};
values = new string[] {
obj.Title,
obj.Desc,
obj.Editor,
obj.EditTime.ToString(MySettings.TimeLong24HHFormat)
};
flag = this.UpdateXmlRow(
MySettings.CatalogXmlFpath,
primaryKeys,
primaryValues,
fields,
values
);
}
catch (Exception ex)
{
throw ex;
}
finally
{
primaryKeys = null;
primaryValues = null;
fields = null;
values = null;
}
return flag;
}
/// <summary>
/// 删除分类方式
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int DelCatalog(Catalog obj)
{
int flag = 0;
string[] primaryKeys = null;
string[] primaryValues = null;
try
{
primaryKeys = new string[] { MySettings.Catalog_ID };
primaryValues = new string[] {
obj.ID
};
flag = this.DeleteXmlRow(
MySettings.CatalogXmlFpath,
primaryKeys,
primaryValues
);
}
catch (Exception ex)
{
throw ex;
}
finally
{
primaryKeys = null;
primaryValues = null;
}
return flag;
}
#endregion
#region UrlNode
/// <summary>
/// 查询链接信息
/// </summary>
/// <returns></returns>
public List<UrlNode> GetAllUrlNode()
{
DataTable dt = null;
List<UrlNode> list = null;
string[] relations = new string[]
{
"contains"
};
string[] fields = new string[]
{
MySettings.UrlNode_ID
};
string[] values = new string[]
{
null
};
string[] types = new string[]
{
typeof(String).ToString().ToLower()
};
dt = this.GetXmlRow(MySettings.UrlNodeXmlFpath, relations, fields, values, types);
if (dt != null)
{
list = new List<UrlNode>();
foreach (DataRow dr in dt.Rows)
{
UrlNode item = new UrlNode()
{
ID = dr[MySettings.UrlNode_ID].ToString().Trim(),
ParentID = dr[MySettings.UrlNode_ParentID].ToString().Trim(),
SortCode = dr[MySettings.UrlNode_SortCode].ToString().Trim(),
Title = dr[MySettings.UrlNode_Title].ToString().Trim(),
Desc = dr[MySettings.UrlNode_Desc].ToString().Trim(),
Url = dr[MySettings.UrlNode_Url].ToString().Trim(),
Creator = dr[MySettings.UrlNode_Creator].ToString().Trim(),
CreateTime = DateTime.Parse(dr[MySettings.UrlNode_CreateTime].ToString().Trim()),
Editor = dr[MySettings.UrlNode_Editor].ToString().Trim(),
Demo = dr[MySettings.UrlNode_Demo].ToString().Trim()
};
if (dr[MySettings.UrlNode_EditTime].ToString().Trim() != "")
{
item.EditTime = DateTime.Parse(dr[MySettings.UrlNode_EditTime].ToString().Trim());
}
list.Add(item);
}
// 升序排序
list.Sort(delegate(UrlNode x, UrlNode y)
{
return Comparer<string>.Default.Compare(x.Title, y.Title);
});
}
dt = null;
relations = fields = values = null;
return list;
}
/// <summary>
/// 查询链接信息
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public List<UrlNode> GetUrlNode(UrlNode obj)
{
DataTable dt = null;
List<UrlNode> list = null;
string[] relations = new string[]
{
"=",
"contains",
"=",
"contains",
"contains",
"contains" ,
"contains",
">=",
"<="
};
string[] fields = new string[]
{
MySettings.UrlNode_ID,
MySettings.UrlNode_CatalogID,
MySettings.UrlNode_ParentID,
MySettings.UrlNode_SortCode,
MySettings.UrlNode_Title,
MySettings.UrlNode_Desc,
MySettings.UrlNode_Url,
MySettings.Catalog_CreateTime,
MySettings.Catalog_CreateTime
};
string[] values = new string[]
{
obj.ID,
obj.CatalogID,
obj.ParentID,
obj.SortCode,
obj.Title,
obj.Desc,
obj.Url,
obj.BeginTime.ToString(MySettings.TimeLong24HHFormat),
obj.EndTime.ToString(MySettings.TimeLong24HHFormat)
};
string[] types = new string[]
{
typeof(String).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(String).ToString().ToLower(),
typeof(DateTime).ToString().ToLower(),
typeof(DateTime).ToString().ToLower(),
};
dt = this.GetXmlRow(MySettings.UrlNodeXmlFpath, relations, fields, values, types);
if (dt != null)
{
list = new List<UrlNode>();
foreach (DataRow dr in dt.Rows)
{
UrlNode item = new UrlNode()
{
ID = dr[MySettings.UrlNode_ID].ToString().Trim(),
CatalogID = dr[MySettings.UrlNode_CatalogID].ToString().Trim(),
ParentID = dr[MySettings.UrlNode_ParentID].ToString().Trim(),
SortCode = dr[MySettings.UrlNode_SortCode].ToString().Trim(),
Title = dr[MySettings.UrlNode_Title].ToString().Trim(),
Desc = dr[MySettings.UrlNode_Desc].ToString().Trim(),
Url = dr[MySettings.UrlNode_Url].ToString().Trim(),
Creator = dr[MySettings.UrlNode_Creator].ToString().Trim(),
CreateTime = DateTime.Parse(dr[MySettings.UrlNode_CreateTime].ToString().Trim()),
Editor = dr[MySettings.UrlNode_Editor].ToString().Trim(),
Demo = dr[MySettings.UrlNode_Demo].ToString().Trim()
};
if (dr[MySettings.UrlNode_EditTime].ToString().Trim() != "")
{
item.EditTime = DateTime.Parse(dr[MySettings.UrlNode_EditTime].ToString().Trim());
}
list.Add(item);
}
// 升序排序
list.Sort(delegate(UrlNode x, UrlNode y)
{
return Comparer<string>.Default.Compare(x.ParentID, y.ParentID);
});
}
dt = null;
relations = fields = values = null;
return list;
}
/// <summary>
/// 添加链接信息
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int AddUrlNode(UrlNode obj)
{
int flag = 0;
string[] fields = null;
List<Dictionary<string, string>> values = null;
try
{
fields = new string[] {
MySettings.UrlNode_ID,
MySettings.UrlNode_CatalogID,
MySettings.UrlNode_ParentID,
MySettings.UrlNode_SortCode,
MySettings.UrlNode_Title,
MySettings.UrlNode_Desc,
MySettings.UrlNode_Url,
MySettings.UrlNode_Creator,
MySettings.UrlNode_CreateTime,
MySettings.UrlNode_Editor,
MySettings.UrlNode_EditTime,
MySettings.UrlNode_Demo
};
values = new List<Dictionary<string, string>>();
values.Add(new Dictionary<string, string>());
values[0].Add(MySettings.UrlNode_ID, obj.ID);
values[0].Add(MySettings.UrlNode_CatalogID, obj.CatalogID);
values[0].Add(MySettings.UrlNode_ParentID, obj.ParentID);
values[0].Add(MySettings.UrlNode_SortCode, obj.SortCode);
values[0].Add(MySettings.UrlNode_Title, obj.Title);
values[0].Add(MySettings.UrlNode_Desc, obj.Desc);
values[0].Add(MySettings.UrlNode_Url, obj.Url);
values[0].Add(MySettings.UrlNode_Creator, obj.Creator);
values[0].Add(MySettings.UrlNode_CreateTime, obj.CreateTime.ToString(MySettings.TimeLong24HHFormat));
values[0].Add(MySettings.UrlNode_Demo, obj.Demo);
flag = this.NewXmlRow(
MySettings.UrlNodeXmlFpath,
fields,
values,
true
);
}
catch (Exception ex)
{
throw ex;
}
finally
{
fields = null;
values = null;
}
return flag;
}
/// <summary>
/// 修改链接信息
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int SetUrlNode(UrlNode obj)
{
int flag = 0;
string[] primaryKeys = null;
string[] primaryValues = null;
string[] fields = null;
string[] values = null;
try
{
primaryKeys = new string[] { MySettings.UrlNode_ID };
primaryValues = new string[] { obj.ID };
fields = new string[] {
MySettings.UrlNode_ParentID,
MySettings.UrlNode_SortCode,
MySettings.UrlNode_Title,
MySettings.UrlNode_Desc,
MySettings.UrlNode_Url,
MySettings.UrlNode_Editor,
MySettings.UrlNode_EditTime,
MySettings.UrlNode_Demo
};
values = new string[] {
obj.ParentID,
obj.SortCode,
obj.Title,
obj.Desc,
obj.Url,
obj.Editor,
obj.EditTime.ToString(MySettings.TimeLong24HHFormat),
obj.Demo
};
flag = this.UpdateXmlRow(
MySettings.UrlNodeXmlFpath,
primaryKeys,
primaryValues,
fields,
values
);
}
catch (Exception ex)
{
throw ex;
}
finally
{
primaryKeys = null;
primaryValues = null;
fields = null;
values = null;
}
return flag;
}
/// <summary>
/// 删除链接信息
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int DelUrlNode(UrlNode obj)
{
int flag = 0;
string[] primaryKeys = null;
string[] primaryValues = null;
try
{
primaryKeys = new string[] { MySettings.UrlNode_ID };
primaryValues = new string[] {
obj.ID
};
flag = this.DeleteXmlRow(
MySettings.UrlNodeXmlFpath,
primaryKeys,
primaryValues
);
}
catch (Exception ex)
{
throw ex;
}
finally
{
primaryKeys = null;
primaryValues = null;
}
return flag;
}
#endregion
#endregion
#region xml数据管理
/// <summary>
/// 新建xml记录
/// </summary>
/// <param name="fpath"></param>
/// <param name="fields"></param>
/// <param name="values"></param>
/// <param name="isCreateNew"></param>
/// <returns></returns>
public int NewXmlRow(
string fpath,
string[] fields,
List<Dictionary<string, string>> values,
bool isCreateNew
)
{
XmlHelper xmlHelper = null;
int result = 0;
try
{
xmlHelper = new XmlHelper();
result = xmlHelper.NewXmlRow(fpath, fields, values, isCreateNew);
}
catch (Exception ex)
{
throw ex;
}
finally
{
xmlHelper.Dispose();
}
return result;
}
/// <summary>
/// 删除xml记录
/// </summary>
/// <param name="fpath"></param>
/// <param name="primaryKeys"></param>
/// <param name="primaryValues"></param>
/// <param name="fields"></param>
/// <param name="values"></param>
/// <returns></returns>
public int DeleteXmlRow(
string fpath,
string[] primaryKeys,
string[] primaryValues
)
{
XmlHelper xmlHelper = null;
int result = 0;
try
{
xmlHelper = new XmlHelper();
result = xmlHelper.DeleteXmlRow(fpath, primaryKeys, primaryValues);
}
catch (Exception ex)
{
throw ex;
}
finally
{
xmlHelper.Dispose();
}
return result;
}
/// <summary>
/// 修改xml记录
/// </summary>
/// <param name="fpath"></param>
/// <param name="primaryKeys"></param>
/// <param name="primaryValues"></param>
/// <param name="fields"></param>
/// <param name="values"></param>
/// <returns></returns>
public int UpdateXmlRow(
string fpath,
string[] primaryKeys,
string[] primaryValues,
string[] fields,
string[] values)
{
XmlHelper xmlHelper = null;
int result = 0;
try
{
xmlHelper = new XmlHelper();
result = xmlHelper.UpdateXmlRow(fpath, primaryKeys, primaryValues, fields, values);
}
catch (Exception ex)
{
throw ex;
}
finally
{
xmlHelper.Dispose();
}
return result;
}
/// <summary>
/// 查询xml记录
/// </summary>
/// <param name="fpath"></param>
/// <param name="relation"></param>
/// <param name="fields"></param>
/// <param name="values"></param>
/// <returns></returns>
public DataTable GetXmlRow(string fpath, string[] relation, string[] fields, string[] values, string[] types)
{
XmlHelper xmlHelper = null;
DataTable result = null;
try
{
xmlHelper = new XmlHelper();
result = xmlHelper.GetXmlRow(fpath, relation, fields, values, types);
}
catch (Exception ex)
{
throw ex;
}
finally
{
xmlHelper.Dispose();
}
return result;
}
#endregion
}
public class XmlHelper : BaseClass
{
public bool Exsist(string fpath)
{
if(System.IO.File.Exists(fpath))
{
return true;
}
return false;
}
public bool CreatXmlDoc(string fpath, string[] keys)
{
if (this.Exsist(fpath))
{
throw new Exception(string.Format("{0} is exsist!", fpath));
}
System.IO.File.Create(fpath).Dispose();
return true;
}
/// <summary>
/// 新建若干xml记录
/// </summary>
/// <param name="fpath"></param>
/// <param name="fields"></param>
/// <param name="values"></param>
/// <param name="isCreateNew"></param>
/// <returns></returns>
public int NewXmlRow(
string fpath,
string[] fields,
List<Dictionary<string,string>> values ,
bool isCreateNew
)
{
int result = 0;
System.Xml.XmlDocument xdoc = null;
System.Xml.XmlNode xFields = null;
System.Xml.XmlNode xDataInfo = null;
System.Xml.XmlNode xTmpNode = null;
System.Xml.XmlNode xTmpSubNode = null;
List<string> currentKey = null;
string[] keys = null;
string xml = "";
string tmp = "";
if (fields == null && fields.Length == 0)
{
throw new Exception("fields is null or empty");
}
if (values == null && values.Count == 0)
{
throw new Exception("values is null or empty");
}
try
{
EncodeXmlFields(ref fields);
EncodeXmlFields(ref values);
xdoc = new System.Xml.XmlDocument();
try
{
xdoc.Load(fpath);
}
catch (Exception ex)
{
if (isCreateNew)
{
System.IO.File.Create(fpath).Dispose();
}
else
{
throw new Exception("XmlDocument is not exsist!");
}
}
if (xdoc == null || xdoc.ChildNodes == null
|| xdoc.ChildNodes.Count == 0
|| xdoc.ChildNodes[0].ChildNodes == null
|| xdoc.ChildNodes[0].ChildNodes.Count != 2
|| xdoc.ChildNodes[0].ChildNodes[0].Name != "ColNames"
|| xdoc.ChildNodes[0].ChildNodes[1].Name != "DataInfo"
)
{
// fpath的Xml文档，不存在或不正确，需要重建
if (isCreateNew)
{
// Init ColNames Node
foreach (string field in fields)
{
tmp += string.Format("<Row><![CDATA[{0}]]></Row>", field);
}
xml += string.Format("<ColNames>{0}</ColNames>", tmp);
// Init DataInfo Node
tmp = "<DataInfo></DataInfo>";
xml += tmp ;
// Init XmlDoc
xml = string.Format("<XmlDoc>{0}</XmlDoc>", xml);
xdoc.InnerXml = xml;
xdoc.Save(fpath);
}
else
{
throw new Exception("XmlDocument is error format!");
}
}
// 重新打开Xml文档，并且写入DataInfo记录
xdoc.Load(fpath);
xFields = xdoc.ChildNodes[0].ChildNodes[0];
// 判断Xml文件中的栏位和录入数据的栏位是否相同
currentKey = new List<string>();
foreach (System.Xml.XmlNode node in xFields.ChildNodes)
{
currentKey.Add(node.InnerText);
}
if (fields.Length > currentKey.Count)
{
throw new Exception("Parameter fields lent is bigger than XmlDocument ColNames define!");
}
foreach (string s in fields)
{
if (!currentKey.Contains(s))
{
throw new Exception(String.Format("XmlDocument ColNames don't contains colname = '{0}'!", s));
}
}
xDataInfo = xdoc.ChildNodes[0].ChildNodes[1];
foreach (Dictionary<string, string> list in values)
{
// DataInfo节点每新增一笔数据记录
keys = list.Keys.ToArray<string>();
if (list != null && list.Count > 0)
{
xTmpNode = xdoc.CreateElement("Row");
foreach (string key in keys)
{
xTmpSubNode = xdoc.CreateElement(key);
xTmpSubNode.InnerXml = string.Format("<![CDATA[{0}]]>", list[key]);
xTmpNode.AppendChild(xTmpSubNode);
}
if (xTmpNode.ChildNodes != null && xTmpNode.ChildNodes.Count > 0)
{
xDataInfo.AppendChild(xTmpNode);
}
}
}
//
xdoc.Save(fpath);
result = values.Count;
}
catch (Exception ex)
{
throw ex;
}
finally
{
xdoc = null;
xFields = null;
xDataInfo = null;
xTmpNode = null;
xTmpSubNode = null;
currentKey = null;
keys = null;
xml = null;
tmp = null;
}
return result;
}
/// <summary>
/// 删除xml记录
/// </summary>
/// <param name="fpath"></param>
/// <param name="primaryKeys"></param>
/// <param name="primaryValues"></param>
/// <param name="fields"></param>
/// <param name="values"></param>
/// <returns></returns>
public int DeleteXmlRow(
string fpath,
string[] primaryKeys,
string[] primaryValues
)
{
int result = 0;
System.Xml.XmlDocument xdoc = null;
System.Xml.XmlNode xFields = null;
System.Xml.XmlNode xDataInfo = null;
List<string> currentKey = null;
if (primaryKeys == null && primaryKeys.Length == 0)
{
throw new Exception("fields is null or empty");
}
if (primaryValues == null && primaryValues.Length == 0)
{
throw new Exception("values is null or empty");
}
try
{
EncodeXmlFields(ref primaryKeys);
EncodeXmlFields(ref primaryValues);
xdoc = new System.Xml.XmlDocument();
xdoc.Load(fpath);
if (xdoc == null || xdoc.ChildNodes == null
|| xdoc.ChildNodes.Count == 0
|| xdoc.ChildNodes[0].ChildNodes == null
|| xdoc.ChildNodes[0].ChildNodes.Count != 2
|| xdoc.ChildNodes[0].ChildNodes[0].Name != "ColNames"
|| xdoc.ChildNodes[0].ChildNodes[1].Name != "DataInfo"
)
{
// fpath的Xml文档，不存在或不正确，需要重建
throw new Exception("XmlDocument is error format");
}
// 删除DataInfo某些记录
xFields = xdoc.ChildNodes[0].ChildNodes[0];
// 判断Xml文件中的栏位和录入数据的栏位是否相同
currentKey = new List<string>();
foreach (System.Xml.XmlNode node in xFields.ChildNodes)
{
currentKey.Add(node.InnerText);
}
if (primaryKeys.Length > currentKey.Count)
{
throw new Exception("Parameter primaryKeys lent is bigger than XmlDocument ColNames define!");
}
foreach (string s in primaryKeys)
{
if (!currentKey.Contains(s))
{
throw new Exception(String.Format("XmlDocument ColNames don't contains colname = '{0}'!", s));
}
}
xDataInfo = xdoc.ChildNodes[0].ChildNodes[1];
string filter = "";
for (int i = 0; i < primaryKeys.Length; i++)
{
filter += string.Format("{0} {1} '{2}'and ", primaryKeys[i], "=", primaryValues[i]);
}
if(filter != "" && filter.Length > 4)
{
filter = filter.Substring(0, filter.Length -4);
}
string select = string.Format("descendant::{0}[{1}]", "Row", filter);
System.Xml.XmlNodeList nodelist = xDataInfo.SelectNodes(select);
if (nodelist != null && nodelist.Count == 1)
{
for (int i = 0; i < nodelist.Count; i++)
{
xDataInfo.RemoveChild(nodelist[i]);
}
//
xdoc.Save(fpath);
result = 1;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
xdoc = null;
xFields = null;
xDataInfo = null;
currentKey = null;
}
return result;
}
/// <summary>
/// 修改xml记录
/// </summary>
/// <param name="fpath"></param>
/// <param name="primaryKeys"></param>
/// <param name="primaryValues"></param>
/// <param name="fields"></param>
/// <param name="values"></param>
/// <returns></returns>
public int UpdateXmlRow(
string fpath,
string[] primaryKeys,
string[] primaryValues,
string[] fields,
string[] values)
{
int result = 0;
System.Xml.XmlDocument xdoc = null;
System.Xml.XmlNode xFields = null;
System.Xml.XmlNode xDataInfo = null;
System.Xml.XmlNodeList nodelist = null;
List<string> currentKey = null;
if (fields == null && fields.Length == 0)
{
throw new Exception("fields is null or empty");
}
if (values == null && values.Length == 0)
{
throw new Exception("values is null or empty");
}
try
{
EncodeXmlFields(ref primaryKeys);
EncodeXmlFields(ref primaryValues);
EncodeXmlFields(ref fields);
EncodeXmlFields(ref values);
xdoc = new System.Xml.XmlDocument();
xdoc.Load(fpath);
if (xdoc == null || xdoc.ChildNodes == null
|| xdoc.ChildNodes.Count == 0
|| xdoc.ChildNodes[0].ChildNodes == null
|| xdoc.ChildNodes[0].ChildNodes.Count != 2
|| xdoc.ChildNodes[0].ChildNodes[0].Name != "ColNames"
|| xdoc.ChildNodes[0].ChildNodes[1].Name != "DataInfo"
)
{
// fpath的Xml文档，不存在或不正确，需要重建
throw new Exception("XmlDocument is error format!");
}
// 删除DataInfo某些记录
xFields = xdoc.ChildNodes[0].ChildNodes[0];
// 判断Xml文件中的栏位和录入数据的栏位是否相同
currentKey = new List<string>();
foreach (System.Xml.XmlNode node in xFields.ChildNodes)
{
currentKey.Add(node.InnerText);
}
if (fields.Length > currentKey.Count)
{
throw new Exception("Parameter fields lent is bigger than XmlDocument ColNames define!");
}
foreach (string s in fields)
{
if (!currentKey.Contains(s))
{
throw new Exception(String.Format("XmlDocument ColNames don't contains colname = '{0}'!", s));
}
}
xDataInfo = xdoc.ChildNodes[0].ChildNodes[1];
string filter = "";
for (int i = 0; i < primaryKeys.Length; i++)
{
filter += string.Format("{0} {1} '{2}'and ", primaryKeys[i], "=", primaryValues[i]);
}
if (filter != "" && filter.Length > 4)
{
filter = filter.Substring(0, filter.Length - 4);
}
string select = string.Format("descendant::{0}[{1}]", "Row", filter);
nodelist = xDataInfo.SelectNodes(select);
if (nodelist != null && nodelist.Count == 1)
{
//for (int i = 0; i < fields.Length; i++)
//{
// nodelist[0].SelectSingleNode(string.Format("descendant::{0}", fields[i])).InnerXml = values[i];
//}
for (int i = 0; i < nodelist.Count; i++)
{
for (int j = 0; j < fields.Length; j++)
{
if (nodelist[0].SelectSingleNode(string.Format("descendant::{0}", fields[j])) == null)
{
System.Xml.XmlElement newNode = xdoc.CreateElement(fields[j]);
newNode.InnerXml = string.Format("<![CDATA[{0}]]>", values[j]);
nodelist[0].AppendChild(newNode);
}
else
{
nodelist[0].SelectSingleNode(string.Format("descendant::{0}", fields[j])).InnerXml = values[j];
}
}
}
xdoc.Save(fpath);
result = 1;
}
else
{
result = 0;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
xdoc = null;
xFields = null;
xDataInfo = null;
nodelist = null;
currentKey = null;
}
return result;
}
/// <summary>
/// 查询xml记录
/// </summary>
/// <param name="fpath"></param>
/// <param name="relation"></param>
/// <param name="fields"></param>
/// <param name="values"></param>
/// <returns></returns>
public DataTable GetXmlRow(string fpath, string[] relation, string[] fields, string[] values, string[] types)
{
DataTable result = null;
System.Xml.XmlDocument xdoc = null;
System.Xml.XmlNode xFields = null;
System.Xml.XmlNode xDataInfo = null;
System.Xml.XmlNodeList nodelist = null;
List<string> currentKey = null;
if (fields == null && fields.Length == 0)
{
throw new Exception("fields is null or empty");
}
if (values == null && values.Length == 0)
{
throw new Exception("values is null or empty");
}
try
{
EncodeXmlFields(ref fields);
EncodeXmlFields(ref values);
if (!System.IO.File.Exists(fpath))
{
throw new System.IO.FileNotFoundException(string.Format("{0} is not exsist!", fpath));
}
xdoc = new System.Xml.XmlDocument();
xdoc.Load(fpath);
if (xdoc == null || xdoc.ChildNodes == null
|| xdoc.ChildNodes.Count == 0
|| xdoc.ChildNodes[0].ChildNodes == null
|| xdoc.ChildNodes[0].ChildNodes.Count != 2
|| xdoc.ChildNodes[0].ChildNodes[0].Name != "ColNames"
|| xdoc.ChildNodes[0].ChildNodes[1].Name != "DataInfo"
)
{
// fpath的Xml文档，不存在或不正确，需要重建
throw new Exception("XmlDocument is error format!");
}
// 删除DataInfo某些记录
xFields = xdoc.ChildNodes[0].ChildNodes[0];
// 判断Xml文件中的栏位和录入数据的栏位是否相同
currentKey = new List<string>();
foreach (System.Xml.XmlNode node in xFields.ChildNodes)
{
currentKey.Add(node.InnerText);
}
#region 2011/08/14 田东 修改原因：增加对时间栏位查询的功能，所以注释该部分代码
//if (fields.Length > currentKey.Count)
//{
// throw new Exception("Parameter fields lent is bigger than XmlDocument ColNames define!");
//}
#endregion
foreach (string s in fields)
{
if (!currentKey.Contains(s))
{
throw new Exception(String.Format("XmlDocument ColNames don't contains colname = '{0}'!", s));
}
}
xDataInfo = xdoc.ChildNodes[0].ChildNodes[1];
string filter = "";
for (int i = 0; i < fields.Length; i++)
{
if (values[i] == null)
{
continue;
}
if (values[i] == System.Xml.XmlConvert.EncodeName("0001-01-01 00:00:00") && types[i] == typeof(DateTime).ToString().ToLower())
{
continue;
}
switch (relation[i].ToLower())
{
case "=":
case "eq":
case "ieq":
{
filter += string.Format("{0} {1} '{2}' and ", fields[i], relation[i], values[i]);
break;
}
case "!=":
case "ne":
case "ine":
{
filter += string.Format("{0} {1} '{2}' and ", fields[i], relation[i], values[i]);
break;
}
case "<":
case "lt":
case "ilt":
{
filter += string.Format("{0} {1} '{2}' and ", fields[i], relation[i], values[i]);
break;
}
case "<=":
case "le":
case "ile":
{
filter += string.Format("{0} {1} '{2}' and ", fields[i], relation[i], values[i]);
break;
}
case ">":
case "gt":
case "igt":
{
filter += string.Format("{0} {1} '{2}' and ", fields[i], relation[i], values[i]);
break;
}
case ">=":
case "ge":
case "ige":
{
filter += string.Format("{0} {1} '{2}' and ", fields[i], relation[i], values[i]);
break;
}
case "contains":
{
filter += string.Format("contains({0} ,'{1}') and ", fields[i], values[i]);
break;
}
}
}
if (filter != "" && filter.Length > 4)
{
filter = filter.Trim().Substring(0, filter.Length - 4);
}
if (filter.Length == 0)
{// 当一个查询条件都不存在
filter = string.Format("contains({0} ,'{1}')", fields[0], "");
}
//string select = string.Format("descendant::{0}[{1}]", "Row", filter);
string select = string.Format("//XmlDoc/DataInfo/Row[{0}]",filter);
nodelist = xDataInfo.SelectNodes(select);
if (nodelist != null && nodelist.Count > 0)
{
result = new DataTable();
foreach (System.Xml.XmlNode item in xFields.ChildNodes)
{
result.Columns.Add(item.InnerText, typeof(string));
}
foreach (System.Xml.XmlNode item in nodelist)
{
DataRow row = result.NewRow();
if (item.ChildNodes != null && item.ChildNodes.Count > 0)
{
foreach (System.Xml.XmlNode i in item.ChildNodes)
{
row[i.Name] = System.Xml.XmlConvert.DecodeName(i.InnerText);
}
}
result.Rows.Add(row);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
xdoc = null;
xFields = null;
xDataInfo = null;
nodelist = null;
currentKey = null;
}
return result;
}
/// <summary>
/// 将字段名称进行编码
/// </summary>
/// <param name="arr"></param>
public static void EncodeXmlFields(ref string[] arr)
{
if (arr != null && arr.Length > 0)
{
for (int i = 0; i < arr.Length; i++)
{
arr[i] = System.Xml.XmlConvert.EncodeName(arr[i]);
}
}
}
public static void EncodeXmlFields(ref List<Dictionary<string, string>> list)
{
if (list != null && list.Count > 0)
{
for(int i = 0; i < list.Count;i++)
{
string[] keys = list[i].Keys.ToArray<string>();
foreach(string key in keys)
{
list[i][key] = System.Xml.XmlConvert.EncodeName(list[i][key]);
}
}
}
}
}
public class Common : BaseClass
{
}
}
