public void Playpin(string sql)
{
ExecuteSql es = new ExecuteSql();
es.GetTable(sql);
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binary"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="sqlDb"></param>
/// <param name="binary"></param>
/// <param name="executeOptions"></param>
public SqlScript(string sqlDb, Binary binary, ExecuteSql executeOptions)
: this(binary, executeOptions)
{
SqlDb = sqlDb;
}
/// <summary>
/// Creates an instance of SqlString from <paramref name="sql"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="sql"></param>
/// <param name="executeOptions"></param>
public SqlString(string sql, ExecuteSql executeOptions)
: this(sql)
{
SetExecutionOptions(executeOptions);
}
/// <summary>
/// Creates an instance of SqlString from <paramref name="sql"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="feature"></param>
/// <param name="sql"></param>
/// <param name="executeOptions"></param>
public SqlString(Feature feature, string sql, ExecuteSql executeOptions)
: this(sql, executeOptions)
{
Feature = feature;
}
/// <summary>
/// Creates an instance of SqlString from <paramref name="sql"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="id"></param>
/// <param name="feature"></param>
/// <param name="sql"></param>
/// <param name="executeOptions"></param>
public SqlString(Id id, Feature feature, string sql, ExecuteSql executeOptions)
: this(sql, executeOptions)
{
Id = id;
Feature = feature;
}
/// <summary>
/// Creates an instance of SqlString from <paramref name="sql"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="sqlDb"></param>
/// <param name="sql"></param>
/// <param name="executeOptions"></param>
public SqlString(SqlDatabase sqlDb, string sql, ExecuteSql executeOptions)
: this(sql, executeOptions)
{
SqlDb = sqlDb.Id;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binary"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="feature"></param>
/// <param name="binary"></param>
/// <param name="executeOptions"></param>
public SqlScript(Feature feature, Binary binary, ExecuteSql executeOptions)
: this(binary, executeOptions)
{
Feature = feature;
}
/// <summary>
/// Creates an instance of SqlString from <paramref name="sql"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="sqlDb"></param>
/// <param name="feature"></param>
/// <param name="sql"></param>
/// <param name="executeOptions"></param>
public SqlString(string sqlDb, Feature feature, string sql, ExecuteSql executeOptions)
: this(sql, executeOptions)
{
SqlDb = sqlDb;
Feature = feature;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binary"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="id"></param>
/// <param name="sqlDb"></param>
/// <param name="binary"></param>
/// <param name="executeOptions"></param>
public SqlScript(Id id, SqlDatabase sqlDb, Binary binary, ExecuteSql executeOptions)
: this(binary, executeOptions)
{
Id = id;
SqlDb = sqlDb.Id;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binaryKey"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="feature"></param>
/// <param name="binaryKey"></param>
/// <param name="executeOptions"></param>
public SqlScript(Feature feature, string binaryKey, ExecuteSql executeOptions)
: this(binaryKey, executeOptions)
{
Feature = feature;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binary"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="id"></param>
/// <param name="sqlDb"></param>
/// <param name="binary"></param>
/// <param name="executeOptions"></param>
public SqlScript(Id id, string sqlDb, Binary binary, ExecuteSql executeOptions)
: this(binary, executeOptions)
{
Id = id;
SqlDb = sqlDb;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binary"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="id"></param>
/// <param name="binary"></param>
/// <param name="executeOptions"></param>
public SqlScript(Id id, Binary binary, ExecuteSql executeOptions)
: this(binary, executeOptions)
{
Id = id;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binaryKey"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="id"></param>
/// <param name="binaryKey"></param>
/// <param name="executeOptions"></param>
public SqlScript(Id id, string binaryKey, ExecuteSql executeOptions)
: this(binaryKey, executeOptions)
{
Id = id;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binaryKey"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="sqlDb"></param>
/// <param name="binaryKey"></param>
/// <param name="executeOptions"></param>
public SqlScript(SqlDatabase sqlDb, string binaryKey, ExecuteSql executeOptions)
: this(binaryKey, executeOptions)
{
SqlDb = sqlDb.Id;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binary"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="sqlDb"></param>
/// <param name="feature"></param>
/// <param name="binary"></param>
/// <param name="executeOptions"></param>
public SqlScript(string sqlDb, Feature feature, Binary binary, ExecuteSql executeOptions)
: this(binary, executeOptions)
{
SqlDb = sqlDb;
Feature = feature;
}
/// <summary>
/// 初始化数据库环境、实例化子类中，所有Set属性
/// </summary>
public void Initializer()
{
if (IsInitializer) { return; }
// 数据库提供者
DbProvider = AbsDbProvider.CreateInstance(ContextConnection.DbType, ContextConnection.DataVer);
// 默认SQL执行者
Executeor = new ExecuteSql(new DbExecutor(ContextConnection.ConnectionString, ContextConnection.DbType, ContextConnection.CommandTimeout, !IsUnitOfWork && DbProvider.IsSupportTransaction ? IsolationLevel.RepeatableRead : IsolationLevel.Unspecified), this);
// 代理SQL记录
if (SystemConfigs.ConfigEntity.IsWriteSqlRunLog) { Executeor = new ExecuteSqlLogProxy(Executeor); }
// 代理异常记录
if (SystemConfigs.ConfigEntity.IsWriteSqlErrorLog) { Executeor = new ExecuteSqlExceptionLogProxy(Executeor); }
// 队列管理者
QueueManger = new QueueManger(this);
// 手动编写SQL
ManualSql = new ManualSql(this);
// 上下文映射关系
this.ContextMap = new ContextDataMap(ContextType);
IsInitializer = true;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binary"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="sqlDb"></param>
/// <param name="feature"></param>
/// <param name="binary"></param>
/// <param name="executeOptions"></param>
public SqlScript(SqlDatabase sqlDb, Feature feature, Binary binary, ExecuteSql executeOptions)
: this(binary, executeOptions)
{
SqlDb = sqlDb.Id;
Feature = feature;
}
/// <summary>
/// Creates an instance of SqlString from <paramref name="sql"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="sqlDb"></param>
/// <param name="feature"></param>
/// <param name="sql"></param>
/// <param name="executeOptions"></param>
public SqlString(SqlDatabase sqlDb, Feature feature, string sql, ExecuteSql executeOptions)
: this(sql, executeOptions)
{
SqlDb = sqlDb.Id;
Feature = feature;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binary"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="id"></param>
/// <param name="feature"></param>
/// <param name="binary"></param>
/// <param name="executeOptions"></param>
public SqlScript(Id id, Feature feature, Binary binary, ExecuteSql executeOptions)
: this(binary, executeOptions)
{
Id = id;
Feature = feature;
}
/// <summary>
/// Creates an instance of SqlString from <paramref name="sql"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="sqlDb"></param>
/// <param name="sql"></param>
/// <param name="executeOptions"></param>
public SqlString(string sqlDb, string sql, ExecuteSql executeOptions)
: this(sql, executeOptions)
{
SqlDb = sqlDb;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binaryKey"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="id"></param>
/// <param name="sqlDb"></param>
/// <param name="feature"></param>
/// <param name="binaryKey"></param>
/// <param name="executeOptions"></param>
public SqlScript(Id id, SqlDatabase sqlDb, Feature feature, string binaryKey, ExecuteSql executeOptions)
: this(binaryKey, executeOptions)
{
Id = id;
SqlDb = sqlDb.Id;
Feature = feature;
}
/// <summary>
/// Creates an instance of SqlString from <paramref name="sql"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="id"></param>
/// <param name="sqlDb"></param>
/// <param name="sql"></param>
/// <param name="executeOptions"></param>
public SqlString(Id id, SqlDatabase sqlDb, string sql, ExecuteSql executeOptions)
: this(sql, executeOptions)
{
Id = id;
SqlDb = sqlDb.Id;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binaryKey"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="binaryKey"></param>
/// <param name="executeOptions"></param>
public SqlScript(string binaryKey, ExecuteSql executeOptions)
: this(binaryKey)
{
SetExecutionOptions(executeOptions);
}
/// <summary>
/// Creates an instance of SqlString from <paramref name="sql"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="id"></param>
/// <param name="sql"></param>
/// <param name="executeOptions"></param>
public SqlString(Id id, string sql, ExecuteSql executeOptions)
: this(sql, executeOptions)
{
Id = id;
}
/// <summary>
/// Creates an instance of SqlScript for <paramref name="binary"/> to be execute according to <paramref name="executeOptions"/>
/// </summary>
/// <param name="binary"></param>
/// <param name="executeOptions"></param>
public SqlScript(Binary binary, ExecuteSql executeOptions)
: this(binary)
{
SetExecutionOptions(executeOptions);
}
/// <summary>
/// 初始化数据库环境、实例化子类中，所有Set属性
/// </summary>
public void Initializer()
{
if (IsInitializer) { return; }
// 默认SQL执行者
Executeor = new ExecuteSql(new DbExecutor(_contextConnection.ConnectionString, _contextConnection.DbType, _contextConnection.CommandTimeout, IsMergeCommand ? IsolationLevel.Serializable : IsolationLevel.Unspecified), this);
// 代理SQL记录
if (SystemConfigs.ConfigEntity.IsWriteDbLog) { Executeor = new ExecuteSqlLogProxy(Executeor); }
// 代理异常记录
if (SystemConfigs.ConfigEntity.IsWriteDbExceptionLog) { Executeor = new ExecuteSqlExceptionLogProxy(Executeor); }
// 数据库提供者
DbProvider = AbsDbProvider.CreateInstance(Executeor.DataBase.DataType, _contextConnection.DataVer);
// 队列管理者
QueueManger = new QueueManger(this);
// 手动编写SQL
ManualSql = new ManualSql(this);
// 上下文映射关系
this.ContextMap = new ContextDataMap(ContextType);
IsInitializer = true;
}
public void ExecStoredProc(string sql)
{
ExecuteSql es = new ExecuteSql();
es.GetTable(sql);
}