/// <summary>
/// 将XML转为MODEL
/// </summary>
/// <param name="file"></param>
/// <param name="xpath">"appconfig/message";</param>
/// <returns></returns>
private List <DtXml> ModelFromMessage(string file, string xpath)
{
XmlDocument doc = new XmlDocument();
List <DtXml> ls = new List <DtXml>();
doc.Load(file);
XmlNodeList list = doc.SelectNodes(xpath);
foreach (XmlNode xmlNode in list)
{
DtXml model = new DtXml();
model.key = xmlNode.Attributes["key"].Value;
model.value = xmlNode.Attributes["value"].Value;
string[] name = model.key.Split('.');
if (name.Count() < 3)
{
continue;
}
model.TableName = name[1];
model.ColumnName = name[2];
ls.Add(model);
}
return(ls);
}
private List <DtXml> AddTableRemark()
{
List <DtXml> entity = new List <DtXml>();
string filePath = System.Web.HttpContext.Current.Server.MapPath(IFilePath);
string[] fileNames = Directory.GetFiles(filePath, "*.xml", SearchOption.AllDirectories);
foreach (string filename in fileNames)
{
XmlDocument doc = new XmlDocument();
doc.Load(filename);
string xpath = "appconfig/message";
XmlNodeList list = doc.SelectNodes(xpath);
foreach (XmlNode xmlNode in list)
{
DtXml model = new DtXml();
model.key = xmlNode.Attributes["key"].Value;
model.value = xmlNode.Attributes["value"].Value;
string[] name = model.key.Split('.');
if (name.Count() < 3)
{
continue;
}
model.TableName = name[1];
model.ColumnName = name[2];
entity.Add(model);
}
}
return(entity);
}
/// <summary>
/// 将XML转为MODEL
/// </summary>
/// <param name="file"></param>
/// <param name="xpath">"appconfig/message";</param>
/// <returns></returns>
private List <DtXml> ModelFromTable(string file, string xpath)
{
XmlDocument doc = new XmlDocument();
List <DtXml> ls = new List <DtXml>();
string currTable = "";
doc.Load(file);
XmlNodeList list = doc.SelectNodes(xpath);
foreach (XmlNode xmlNode in list)
{
currTable = xmlNode.Attributes["name"].Value;
XmlNodeList tableList = xmlNode.SelectNodes("columns/column");
foreach (XmlNode tableNode in tableList)
{
DtXml model = new DtXml();
model.TableName = currTable;
model.ColumnName = tableNode.Attributes["name"].Value;
model.value = tableNode.Attributes["text"].Value;
model.DDL = tableNode.Attributes["ddlb"].Value;
ls.Add(model);
}
}
return(ls);
}
