private ISQLHelper GetSQLHelper(SqlAnalyModel model) { if (model == null || string.IsNullOrWhiteSpace(model.SqlConnStringName)) { throw new Exception(string.Format("数据库连接配置不正确")); } ISQLHelper sqlHelper = null; switch (model.DBType.ToLower()) { case "mysql": sqlHelper = new MySqlHelper(); break; case "sqlserver": sqlHelper = new SqlServerHelper(); break; default: throw new Exception("暂不支持" + model.DBType + "数据库"); } if (!ConnectionStringsDic.ContainsKey(model.SqlConnStringName)) { ConnectionStringsDic[model.SqlConnStringName] = System.Configuration.ConfigurationManager.ConnectionStrings[model.SqlConnStringName].ConnectionString; } sqlHelper.ConnectionString = ConnectionStringsDic[model.SqlConnStringName]; if (string.IsNullOrWhiteSpace(sqlHelper.ConnectionString)) { throw new Exception(string.Format("数据库连接地址【{0}】不正确", model.SqlConnStringName)); } return(sqlHelper); }
public SqlAnalyModel SqlAnaly(Dictionary <string, object> keyValue) { SqlAnalyModel model = new SqlAnalyModel(); GetAllParseItem(keyValue); model.SqlText = SqlCommand; if (keyValue != null && keyValue.ContainsKey("ConnectionPrefix")) { model.SqlConnStringName = keyValue["ConnectionPrefix"] + SqlConnStringName; } else { model.SqlConnStringName = SqlConnStringName; } //model.SqlConnStringName = SqlConnStringName; model.DBType = SqlDBType; model.Assembly = Assembly; model.ModelClassName = ModelClassName; model.Timeout = Timeout; if (this.ParentSqlDefinition != null) { var parentModel = this.ParentSqlDefinition.SqlAnaly(keyValue); if (parentModel.SqlText.Trim().LastIndexOf(';') == parentModel.SqlText.Trim().Length - 1) { model.SqlText = parentModel.SqlText + model.SqlText; } else { //最后位置找不到 ; 则自动补齐 model.SqlText = parentModel.SqlText + ";" + model.SqlText; } } return(model); }
public SqlAnalyModel SqlAnaly(Dictionary <string, object> keyValue) { SqlAnalyModel model = new SqlAnalyModel(); GetAllParseItem(_sql, keyValue); model.SqlText = SqlCommand; model.SqlConnStringName = SqlConnStringName; model.DBType = SqlDBType; return(model); }
public SqlDefinition(SqlAnalyModel sqlAnaly) { this.SqlCommand = sqlAnaly.SqlText; this.SqlDBType = sqlAnaly.DBType; this.SqlConnStringName = sqlAnaly.SqlConnStringName; this.Assembly = sqlAnaly.Assembly; this.ModelClassName = sqlAnaly.ModelClassName; this.CanEmptyMC = sqlAnaly.CanEmptyMC; this.ReplaceMC = sqlAnaly.ReplaceMC; this.ParamMC = sqlAnaly.ParamMC; }
private ISQLHelper GetSQLHelper(SqlAnalyModel model) { if (model == null) { throw new Exception(string.Format("数据库连接配置不正确")); } ISQLHelper sqlHelper = null; if (string.IsNullOrWhiteSpace(model.DBType)) { model.DBType = "mysql"; } sqlHelper = new AllHelper(); //switch (model.DBType.ToLower()) //{ // case "mysql": // sqlHelper = new MySqlHelper(); // break; // case "sqlserver": // sqlHelper = new SqlServerHelper(); // break; // default: // sqlHelper = new AllHelper(); // break; //} sqlHelper.DBType = model.DBType; if (!string.IsNullOrWhiteSpace(model.SqlConnStringName)) { if (!ConnectionStringsDic.ContainsKey(model.SqlConnStringName)) { ConnectionStringsDic[model.SqlConnStringName] = System.Configuration.ConfigurationManager.ConnectionStrings[model.SqlConnStringName].ConnectionString; } sqlHelper.ConnectionString = ConnectionStringsDic[model.SqlConnStringName]; } if (string.IsNullOrWhiteSpace(sqlHelper.ConnectionString)) { if (string.IsNullOrWhiteSpace(DefaultConnectionStrings)) { throw new Exception(string.Format("数据库连接配置不正确")); } sqlHelper.ConnectionString = DefaultConnectionStrings; } if (model.Timeout >= 0) { sqlHelper.Timeout = model.Timeout; } return(sqlHelper); }
public SqlDefinition(SqlAnalyModel sqlAnaly) { if (sqlAnaly.ParentAnaly != null) { this.ParentSqlDefinition = new SqlDefinition(sqlAnaly.ParentAnaly); } this.SqlCommand = sqlAnaly.SqlText; this.SqlDBType = sqlAnaly.DBType; this.SqlConnStringName = sqlAnaly.SqlConnStringName; this.Assembly = sqlAnaly.Assembly; this.ModelClassName = sqlAnaly.ModelClassName; this.CanEmptyMC = sqlAnaly.CanEmptyMC; this.ReplaceMC = sqlAnaly.ReplaceMC; this.ParamMC = sqlAnaly.ParamMC; this.ParentKey = sqlAnaly.ParentKey; this.Timeout = sqlAnaly.Timeout; }
private ISQLHelper GetSQLHelper(SqlAnalyModel model) { ISQLHelper sqlHelper = null; switch (model.DBType.ToLower()) { case "mysql": sqlHelper = new MySqlHelper(model.SqlConnStringName); break; case "sqlserver": sqlHelper = new SqlServerHelper(model.SqlConnStringName); break; default: throw new Exception("暂不支持" + model.DBType + "数据库"); } return(sqlHelper); }
public SqlAnalyModel SqlAnaly(Dictionary <string, object> keyValue) { SqlAnalyModel model = new SqlAnalyModel(); GetAllParseItem(keyValue); model.SqlText = SqlCommand; if (keyValue != null && keyValue.ContainsKey("ConnectionPrefix")) { model.SqlConnStringName = keyValue["ConnectionPrefix"] + SqlConnStringName; } else { model.SqlConnStringName = SqlConnStringName; } //model.SqlConnStringName = SqlConnStringName; model.DBType = SqlDBType; model.Assembly = Assembly; model.ModelClassName = ModelClassName; return(model); }
private void GetXml(FileInfo file) { IConfigRefresher refresher = new FileInfoConfigRefresher(file.FullName); if (!refresher.IsLatest) { refresher.Refresh(() => { try { XmlDocument doc = new XmlDocument(); doc.Load(file.FullName); foreach (XmlNode nodeChild in doc.DocumentElement.ChildNodes) { if (nodeChild.NodeType != XmlNodeType.Element && nodeChild.Name.ToLower() != "data") { continue; } if (nodeChild.Attributes["name"] == null) { continue; } var key = XmlUtility.getNodeAttributeStringValue(nodeChild, "name").ToLower(); lock (_SqlLock) { _sqlDic[key] = nodeChild["SqlDefinition"]; _sqlAnalyModelDic[key] = SqlAnalyModel.XmlToSqlAnalyModel(nodeChild["SqlDefinition"]); if (!string.IsNullOrWhiteSpace(_sqlAnalyModelDic[key].ParentKey)) { KeyParentDic[key] = _sqlAnalyModelDic[key].ParentKey; } } } } catch (Exception ex) { throw ex; } }); } }