/// <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 }); } }