private static Common.DbConfigInfo Read()
{
if (zeroConfigInfo == null)
{
lock (_lock)
{
if (zeroConfigInfo == null)
{
Common.DbConfigInfo temp = ReadFile();
if (temp != null)
{
zeroConfigInfo = temp;
}
}
}
}
return(zeroConfigInfo);
}
private static Common.DbConfigInfo ReadFile()
{
Common.DbConfigInfo temp = new Common.DbConfigInfo();
if (string.IsNullOrEmpty(filePath))
{
var dir = AppDomain.CurrentDomain.BaseDirectory;
System.IO.DirectoryInfo directoryInfo = new System.IO.DirectoryInfo(dir);
System.IO.FileInfo[] files = directoryInfo.GetFiles(fileName, System.IO.SearchOption.AllDirectories);
if (files == null || files.Length < 1)
{
//throw new Exception("缺少配置文件ZeroDbConfig.xml");
return(temp);
}
filePath = files[0].FullName;
}
System.IO.FileInfo fileInfo = new System.IO.FileInfo(filePath);
if (!fileInfo.Exists)
{
//throw new Exception("配置文件ZeroDbConfig.xml不存在");
return(temp);
}
try
{
System.Xml.XmlDocument xmlDocument = new System.Xml.XmlDocument();
xmlDocument.Load(filePath);
System.Xml.XmlNodeList xmlNodeList = xmlDocument.SelectNodes(@"/zero/dbs/db");//GetElementsByTagName("db");
if (xmlNodeList == null || xmlNodeList.Count < 1)
{
throw new Exception("缺少db配置");
}
temp.Dbs = new List <Common.DbConfigDatabaseInfo>();
foreach (System.Xml.XmlNode node in xmlNodeList)
{
System.Xml.XmlAttribute dbKey = node.Attributes["dbKey"];
System.Xml.XmlAttribute dbConnectionString = node.Attributes["dbConnectionString"];
System.Xml.XmlAttribute dbType = node.Attributes["dbType"];
if (dbKey == null || dbConnectionString == null || dbType == null)
{
continue;
}
string key = dbKey.Value;
string conn = dbConnectionString.Value;
string type = dbType.Value;
if (string.IsNullOrEmpty(key) || string.IsNullOrEmpty(conn) || string.IsNullOrEmpty(type))
{
continue;
}
type = type.Trim();
if (string.Equals(type, "SqlServer", StringComparison.OrdinalIgnoreCase))
{
type = "SqlServer";
}
else if (string.Equals(type, "MySql", StringComparison.OrdinalIgnoreCase))
{
type = "MySql";
}
else if (string.Equals(type, "Sqlite", StringComparison.OrdinalIgnoreCase))
{
type = "Sqlite";
}
else
{
continue;
}
key = key.Trim();
conn = conn.Trim();
if (temp.Dbs.Find(o => string.Equals(o.dbKey, key, StringComparison.OrdinalIgnoreCase)) != null)
{
continue;
}
temp.Dbs.Add(new Common.DbConfigDatabaseInfo
{
dbConnectionString = conn,
dbKey = key,
dbType = type
});
}
if (temp.Dbs.Count < 1)
{
return(null);
}
xmlNodeList = xmlDocument.SelectNodes(@"/zero/dvs/dv");
temp.Dvs = new List <Common.DbConfigDataviewInfo>();
if (xmlNodeList == null || xmlNodeList.Count < 1)
{
return(temp);
}
foreach (System.Xml.XmlNode node in xmlNodeList)
{
System.Xml.XmlAttribute dbKey = node.Attributes["dbKey"];
System.Xml.XmlAttribute tableName = node.Attributes["tableName"];
System.Xml.XmlAttribute entityKey = node.Attributes["entityKey"];
if (dbKey == null || tableName == null || entityKey == null)
{
continue;
}
string key = dbKey.Value;
string name = tableName.Value;
string entity = entityKey.Value;
if (string.IsNullOrEmpty(key) || string.IsNullOrEmpty(name) || string.IsNullOrEmpty(entity))
{
continue;
}
key = key.Trim();
name = name.Trim();
entity = entity.Trim();
if (temp.Dbs.Find(o => string.Equals(o.dbKey, key, StringComparison.OrdinalIgnoreCase)) == null)
{
continue;
}
if (temp.Dvs.Find(o => string.Equals(o.entityKey, entity, StringComparison.OrdinalIgnoreCase)) != null)
{
continue;
}
temp.Dvs.Add(new Common.DbConfigDataviewInfo
{
dbKey = key,
tableName = name,
entityKey = entity,
isStandardMapping = true
});
}
}
catch {
temp = null;
}
return(temp);
}
