/// <summary>
/// 根据SQLXML文件路径获取SQL实体
/// </summary>
/// <param name="_Path">SQLXML路径</param>
/// <returns>SQLXML实体</returns>
public static SQLCodeEntity GetSQLCodeEntityByPath(String _Path)
{
SQLCodeEntity _SQLCodeEntity = null;
try
{
if (!File.Exists(_Path))
{
return(null);
}
//实例化XML文件操作类
XmlOperate _XmlOperate = new XmlOperate();
//判断配置文件是否只读
FileInfo fi = new FileInfo(_Path);
//如果只读则修改为普通
fi.Attributes = FileAttributes.Normal;
//实例化文件操作类
DirectoryFileOperate _DirectoryFileOperate = new DirectoryFileOperate();
//根据指定路径读取文件
string _XmlContent = _DirectoryFileOperate.ShareReadFile(_Path);
//把xml转换成对象
_SQLCodeEntity = _XmlOperate.SimpleXmlToObject <SQLCodeEntity>(_XmlContent);
}
catch (Exception ex)
{
return(null);
}
return(_SQLCodeEntity);
}
/// <summary>
/// 获取指定路径下所有xml文件列表
/// </summary>
/// <param name="_Path">目标完全路径</param>
/// <returns>xml文件路径列表</returns>
private List <string> GetAllXmlFilelist(string _Path)
{
DirectoryFileOperate df = new DirectoryFileOperate();
List <string> _XmlPathlist = new List <string>();
_XmlPathlist = df.GetSubfolderlist(_Path);
for (int i = 0; i < _XmlPathlist.Count; i++)
{
//移除目录中非xml文件
if (!_XmlPathlist[i].ToString().EndsWith(".xml"))
{
_XmlPathlist.RemoveAt(i);
}
}
return(_XmlPathlist);
}
/// <summary>
/// 保存SQLXML文件
/// </summary>
/// <param name="_XmlString">保存xml字符串</param>
/// <param name="_configPath">SQLXML文件地址</param>
/// <returns>执行结果</returns>
private bool SaveXml(string _XmlString, string _configPath)
{
try
{
//判断路径是否为空
if (string.IsNullOrEmpty(_XmlString) || string.IsNullOrEmpty(_configPath))
{
return(false);
}
//获取文件存储文件夹路径
iUtility.iTools.DirectoryFileOperate _DirectoryFileOperate = new DirectoryFileOperate();
//string DirPath = _DirectoryFileOperate.FileSubToPath(_configPath);
//string FileName = Guid.NewGuid().ToString();
//string temppath = Path.Combine(DirPath, FileName + ".xml.bak");
////生成临时文件
//File.WriteAllText(temppath, _XmlString);
////判断配置文件是否只读
//FileInfo fi = new FileInfo(_configPath);
////如果只读则修改为普通
//if (fi.Attributes.ToString().IndexOf("ReadOnly") != -1)
//{
// fi.Attributes = FileAttributes.Normal;
//}
////重命名
//File.Copy(temppath, _configPath, true);
////删除临时文件
//File.Delete(temppath);
File.WriteAllText(_configPath, _XmlString);
}
catch (Exception)
{
return(false);
}
return(true);
}
