/// <summary>
/// 添加SQLXML文件
/// </summary>
/// <param name="parameters">页面传递的参数</param>
/// <returns>true：成功，false：失败</returns>
public object AddSql(Dictionary <String, String> parameters)
{
try
{
////XML存储路径
//string _XmlOutPath = Path.Combine(WorkDir, SQLPath);
//if (!Directory.Exists(_XmlOutPath))//如果路径不存在
//{
// //创建路径
// Directory.CreateDirectory(_XmlOutPath);
//}
//检查SQLXML路径是否存在
CheckPath();
JsonOperate _JsonOperate = new JsonOperate();
//获取SQL序号
string _SqlNum = parameters.ContainsKey("SqlNum") ? _JsonOperate.FromJsonString <string>(parameters["SqlNum"]) : "";
//获取SQL说明
string _SqlDescription = parameters.ContainsKey("SqlDescription") ? _JsonOperate.FromJsonString <string>(parameters["SqlDescription"]) : "";
//获取SQL语句
string _SQLString = parameters.ContainsKey("SQLString") ? _JsonOperate.FromJsonString <string>(parameters["SQLString"]) : "";
//SQL语句所在xml文件路径
string xmlPath = Path.Combine(SQLPath, _SqlNum + ".xml");
if (File.Exists(xmlPath))//如果存在文件，返回false
{
return(new { Methods = false });
}
if (string.IsNullOrEmpty(_SqlNum) || string.IsNullOrEmpty(_SqlDescription) || string.IsNullOrEmpty(_SQLString))
{
return(new { Methods = false });
}
//实例化XML文件操作类
XmlOperate _XmlOperate = new XmlOperate();
//实例化SQL实体类
SQLCodeEntity _SQLCodeEntity = new SQLCodeEntity();
_SQLCodeEntity.SqlNum = _SqlNum;
_SQLCodeEntity.SqlDescription = _SqlDescription;
_SQLCodeEntity.SQLString = _SQLString;
//转换成xml字符串
string _XmlString = _XmlOperate.ObjectToSimpleXml(_SQLCodeEntity);
//生成SQLXML文件
File.WriteAllText(xmlPath, _XmlString);
return(new { Methods = true });
}
catch
{
return(new { Methods = false });
}
}
/// <summary>
/// 根据SQL序号修改SQL文件
/// </summary>
/// <param name="parameters">页面传递的参数</param>
/// <returns>true：成功，false：失败</returns>
public object EditSql(Dictionary <String, String> parameters)
{
try
{
JsonOperate _JsonOperate = new JsonOperate();
//获取SQL序号
string _SqlNum = parameters.ContainsKey("SqlNum") ? _JsonOperate.FromJsonString <string>(parameters["SqlNum"]) : "";
//获取SQL说明
string _SqlDescription = parameters.ContainsKey("SqlDescription") ? _JsonOperate.FromJsonString <string>(parameters["SqlDescription"]) : "";
//获取SQL语句
string _SQLString = parameters.ContainsKey("SQLString") ? _JsonOperate.FromJsonString <string>(parameters["SQLString"]) : "";
//SQL语句所在xml文件路径
string xmlPath = Path.Combine(SQLPath, _SqlNum + ".xml");
if (!File.Exists(xmlPath))
{
return(new { Methods = false });
}
//实例化XML文件操作类
XmlOperate _XmlOperate = new XmlOperate();
//实例化SQL实体类
SQLCodeEntity _SQLCodeEntity = new SQLCodeEntity();
_SQLCodeEntity.SqlNum = _SqlNum;
_SQLCodeEntity.SqlDescription = _SqlDescription;
_SQLCodeEntity.SQLString = _SQLString;
//转换成xml字符串
string _Xmlstring = _XmlOperate.ObjectToSimpleXml(_SQLCodeEntity);
bool _IsSuccess = SaveXml(_Xmlstring, xmlPath);
return(new { Methods = _IsSuccess });
}
catch
{
return(new { Methods = false });
}
}
