/// <summary>
/// 返回字符串列表
/// </summary>
/// <param name="path">文件名</param>
/// <param name="xmlNode">结点</param>
/// <returns></returns>
public static bool GetXmlList(string path, string xmlNode,
ref List <string> key, ref List <string> sql, ref Dictionary <string, object> db,
ref Dictionary <string, object> type, ref Dictionary <string, object> check,
ref Dictionary <string, object> param, ref Dictionary <string, object> name,
ref Dictionary <string, object> parameName, ConfigModel config, string xml = null)
{
try
{
var result = true;
var tempKey = "";
//变量
var xmlDoc = new XmlDocument();
//载入xml
if (config.IsEncrypt)
{
var temp = BaseSymmetric.DecodeGB2312(File.ReadAllText(path));
if (temp != "")
{
xmlDoc.LoadXml(temp);
}
else
{
xmlDoc.Load(path);
}
}
else if (!string.IsNullOrEmpty(xml))
{
xmlDoc.LoadXml(xml);
}
else
{
xmlDoc.Load(path);
}
//结点
var nodelList = xmlDoc.SelectNodes(xmlNode);
var list = new List <string>();
foreach (XmlNode item in nodelList)
{
foreach (XmlNode temp in item.ChildNodes)
{
var foreachCount = 1;
var i = 0;
if (temp is XmlElement)
{
var tempParam = new List <string>();
#region XmlElement
tempKey = temp.Attributes["id"].Value.ToLower();
//节点数
if (Array.Exists(key.ToArray(), element => element == tempKey))
{
result = false;
Task.Run(() => { BaseLog.SaveLog(string.Format("xml文件:{0},存在相同键:{1}", path, tempKey), "MapKeyExists"); });
}
key.Add(tempKey);
sql.Add(temp.ChildNodes.Count.ToString());
//name
if (temp.Attributes["name"] != null)
{
name.Add(string.Format("{0}.remark", tempKey), temp.Attributes["name"].Value);
}
foreach (XmlNode node in temp.ChildNodes)
{
#region XmlText
if (node is XmlText)
{
key.Add(string.Format("{0}.{1}", tempKey, i));
sql.Add(node.InnerText.Replace("<", "<").Replace(">", ">"));
}
#endregion
#region XmlElement 动态条件
if (node is XmlElement)
{
if (node.Attributes["prepend"] != null)
{
key.Add(string.Format("{0}.format.{1}", tempKey, i));
sql.Add(node.Attributes["prepend"].Value.ToLower());
}
//foreach
if (node.Name.ToLower() == "foreach")
{
//type
if (node.Attributes["type"] != null)
{
key.Add(string.Format("{0}.foreach.type.{1}", tempKey, foreachCount));
sql.Add(node.Attributes["type"].Value);
}
//result name
key.Add(string.Format("{0}.foreach.name.{1}", tempKey, foreachCount));
if (node.Attributes["name"] != null)
{
sql.Add(node.Attributes["name"].Value.ToLower());
}
else
{
sql.Add("data");
}
//field
if (node.Attributes["field"] != null)
{
key.Add(string.Format("{0}.foreach.field.{1}", tempKey, foreachCount));
sql.Add(node.Attributes["field"].Value.ToLower());
}
//sql
if (node.ChildNodes[0] is XmlText)
{
key.Add(string.Format("{0}.foreach.sql.{1}", tempKey, foreachCount));
sql.Add(node.ChildNodes[0].InnerText.Replace("<", "<").Replace(">", ">"));
}
foreachCount++;
}
foreach (XmlNode dyn in node.ChildNodes)
{
if (dyn is XmlText)
{
continue;
}
//check required
if (dyn.Attributes["required"] != null)
{
check.Add(string.Format("{0}.{1}.required", tempKey, dyn.Attributes["property"].Value.ToLower()), dyn.Attributes["required"].Value.ToStr());
}
//check maxlength
if (dyn.Attributes["maxlength"] != null)
{
check.Add(string.Format("{0}.{1}.maxlength", tempKey, dyn.Attributes["property"].Value.ToLower()), dyn.Attributes["maxlength"].Value.ToStr());
}
//check existsmap
if (dyn.Attributes["existsmap"] != null)
{
check.Add(string.Format("{0}.{1}.existsmap", tempKey, dyn.Attributes["property"].Value.ToLower()), dyn.Attributes["existsmap"].Value.ToStr());
}
//check checkmap
if (dyn.Attributes["checkmap"] != null)
{
check.Add(string.Format("{0}.{1}.checkmap", tempKey, dyn.Attributes["property"].Value.ToLower()), dyn.Attributes["checkmap"].Value.ToStr());
}
//check date
if (dyn.Attributes["date"] != null)
{
check.Add(string.Format("{0}.{1}.date", tempKey, dyn.Attributes["property"].Value.ToLower()), dyn.Attributes["date"].Value.ToStr());
}
//参数
tempParam.Add(dyn.Attributes["property"].Value);
//param name
if (dyn.Attributes["name"] != null)
{
parameName.Add(string.Format("{0}.{1}.remark", tempKey, dyn.Attributes["property"].Value.ToLower()), dyn.Attributes["name"].Value);
}
if (dyn.Name.ToLower() == "ispropertyavailable")
{
//属性和值
key.Add(string.Format("{0}.{1}.{2}", tempKey, dyn.Attributes["property"].Value.ToLower(), i));
sql.Add(string.Format("{0}{1}", dyn.Attributes["prepend"].Value.ToLower(), dyn.InnerText));
}
else if (dyn.Name.ToLower() != "choose")
{
//属性和值
key.Add(string.Format("{0}.{1}.{2}", tempKey, dyn.Attributes["property"].Value.ToLower(), i));
sql.Add(string.Format("{0}{1}", dyn.Attributes["prepend"].Value.ToLower(), dyn.InnerText));
//条件类型
key.Add(string.Format("{0}.{1}.condition.{2}", tempKey, dyn.Attributes["property"].Value.ToLower(), i));
sql.Add(dyn.Name);
//判断条件内容
if (dyn.Attributes["condition"] != null)
{
key.Add(string.Format("{0}.{1}.condition.value.{2}", tempKey, dyn.Attributes["property"].Value.ToLower(), i));
sql.Add(dyn.Attributes["condition"].Value);
}
//比较条件值
if (dyn.Attributes["compareValue"] != null)
{
key.Add(string.Format("{0}.{1}.condition.value.{2}", tempKey, dyn.Attributes["property"].Value.ToLower(), i));
sql.Add(dyn.Attributes["compareValue"].Value.ToLower());
}
}
else
{
//条件类型
key.Add(string.Format("{0}.{1}.condition.{2}", tempKey, dyn.Attributes["property"].Value.ToLower(), i));
sql.Add(dyn.Name);
if (dyn is XmlElement)
{
var count = 0;
key.Add(string.Format("{0}.{1}.{2}", tempKey, dyn.Attributes["property"].Value.ToLower(), i));
sql.Add(dyn.ChildNodes.Count.ToStr());
foreach (XmlNode child in dyn.ChildNodes)
{
//条件
key.Add(string.Format("{0}.{1}.{2}.choose.condition.{3}", tempKey, dyn.Attributes["property"].Value.ToLower(), i, count));
sql.Add(child.Attributes["property"].Value);
//内容
key.Add(string.Format("{0}.{1}.{2}.choose.{3}", tempKey, dyn.Attributes["property"].Value.ToLower(), i, count));
sql.Add(string.Format("{0}{1}", child.Attributes["prepend"].Value.ToLower(), child.InnerText));
count++;
}
}
}
}
}
#endregion
i++;
}
//db
if (temp.Attributes["db"] != null)
{
db.Add(tempKey, temp.Attributes["db"].Value.ToStr());
}
//type
if (temp.Attributes["type"] != null)
{
type.Add(tempKey, temp.Attributes["type"].Value.ToStr());
}
//foreach count
key.Add(string.Format("{0}.foreach", tempKey));
sql.Add((foreachCount - 1).ToStr());
param.Add(tempKey, tempParam);
#endregion
}
else if (temp is XmlText)
{
#region XmlText
key.Add(string.Format("{0}.{1}", item.Attributes["id"].Value.ToLower(), i));
sql.Add(temp.InnerText.Replace("<", "<").Replace(">", ">"));
key.Add(item.Attributes["id"].Value.ToLower());
sql.Add("0");
#endregion
}
}
}
return(result);
}
catch (Exception ex)
{
Task.Run(() =>
{
if (config.SqlErrorType == SqlErrorType.Db)
{
DbLogTable.LogException(config, ex, "InstanceMap", "GetXmlList");
}
else
{
DbLog.LogException(true, "InstanceMap", ex, "GetXmlList", "");
}
});
return(false);
}
}
/// <summary>
/// map xml 存数据库
/// </summary>
/// <param name="dbKey"></param>
/// <param name="key"></param>
/// <param name="info"></param>
public static bool SaveXml(string dbKey, string key, FileInfo info, ConfigModel config, DataContext db)
{
if (config.IsMapSave)
{
//加密
var enContent = File.ReadAllText(info.FullName);
//明文
var deContent = "";
if (config.IsEncrypt)
{
deContent = BaseSymmetric.DecodeGB2312(deContent);
if (deContent == "")
{
deContent = enContent;
}
}
else
{
deContent = enContent;
}
if (config.DbType == DataDbType.MySql)
{
var model = new DataModel.MySql.Data_MapFile();
model.MapId = key;
var query = FastRead.Query <DataModel.MySql.Data_MapFile>(a => a.MapId == key, null, dbKey);
if (query.ToCount() == 0)
{
model.FileName = info.Name;
model.FilePath = info.FullName;
model.LastTime = info.LastWriteTime;
model.EnFileContent = enContent;
model.DeFileContent = deContent;
return(db.Add(model).writeReturn.IsSuccess);
}
else
{
return(db.Update <DataModel.MySql.Data_MapFile>(model, a => a.MapId == model.MapId, a => new { a.LastTime, a.EnFileContent, a.DeFileContent }).writeReturn.IsSuccess);
}
}
if (config.DbType == DataDbType.Oracle)
{
var model = new DataModel.Oracle.Data_MapFile();
model.MapId = key;
var query = FastRead.Query <DataModel.Oracle.Data_MapFile>(a => a.MapId == key, null, dbKey);
if (query.ToCount() == 0)
{
model.FileName = info.Name;
model.FilePath = info.FullName;
model.LastTime = info.LastWriteTime;
model.EnFileContent = enContent;
model.DeFileContent = deContent;
return(db.Add(model).writeReturn.IsSuccess);
}
else
{
return(db.Update <DataModel.Oracle.Data_MapFile>(model, a => a.MapId == model.MapId, a => new { a.LastTime, a.EnFileContent, a.DeFileContent }).writeReturn.IsSuccess);
}
}
if (config.DbType == DataDbType.SqlServer)
{
var model = new DataModel.SqlServer.Data_MapFile();
model.MapId = key;
var query = FastRead.Query <DataModel.SqlServer.Data_MapFile>(a => a.MapId == key, null, dbKey);
if (query.ToCount() == 0)
{
model.FileName = info.Name;
model.FilePath = info.FullName;
model.LastTime = info.LastWriteTime;
model.EnFileContent = enContent;
model.DeFileContent = deContent;
return(db.Add(model).writeReturn.IsSuccess);
}
else
{
return(db.Update <DataModel.SqlServer.Data_MapFile>(model, a => a.MapId == model.MapId, a => new { a.LastTime, a.EnFileContent, a.DeFileContent }).writeReturn.IsSuccess);
}
}
}
return(true);
}