public DbAdapter(DbDriverType driverType, IDbConnectionInfo connectionInfo)
{
Driver = DbDriverFactory.GetInstance(driverType);
ConnectionInfo = connectionInfo;
Connection = Driver.BuildConnection(ConnectionInfo);
OpenConnection();
}
public DbAdapter(DbDriverType driverType, IDbConnectionInfo connectionInfo)
{
Driver = DbDriverFactory.GetInstance(driverType);
ConnectionInfo = connectionInfo;
Connection = Driver.BuildConnection(ConnectionInfo);
OpenConnection();
}
/// <summary>
/// 注册根据配置连接及指定驱动类型注册全局数据区厂对象，以便工厂直接创建数据库上下文
/// 连接字符串已加密
/// </summary>
/// <param name="ConnectionStringKey">配置数据链接字符串健值，如果有多屋，则应如下：db:ConnStr</param>
/// <param name="dbDriverType">指定驱动类型</param>
/// <param name="Key">加密的密钥</param>
/// <returns>返回应用注册对象，以便继续进行注册</returns>
public IAppRegister RegGlobalDbContextForDecrypt(string ConnectionStringKey, DbDriverType dbDriverType, string Key = "")
{
string connstr = config.GetAppSetting(ConnectionStringKey).ToStringValue();
Global.DbContextFactory = DbContextFactory.CreateFactory(connstr, dbDriverType);
return(this);
}
/// <summary>
/// 注册日志组件，采用数据库保存方式
/// </summary>
/// <param name="type">日志类型</param>
/// <param name="SqlConnectstring">数据库链接</param>
/// <param name="LogTableName">日志保存表名</param>
public static void RegisLogger(LogType type, string SqlConnectstring, string LogTableName, DbDriverType dbType = DbDriverType.SQLServer)
{
logType = type;
LogSaveType = 1;
SqlConnectStr = SqlConnectstring;
logTable = LogTableName;
DBType = dbType;
}
/// <summary>
/// 注册根据配置连接及指定驱动类型注册全局数据区厂对象，以便工厂直接创建数据库上下文
/// 连接字符串未加密
/// </summary>
/// <param name="ConnectionStringKey">配置数据链接字符串健值，如果有多屋，则应如下：db:ConnStr</param>
/// <param name="DbDriverTypeKey">指定驱动类型的配置键值</param>
/// <returns>返回应用注册对象，以便继续进行注册</returns>
public IAppRegister RegGlobalDbContext(string ConnectionStringKey, string DbDriverTypeKey)
{
string connstr = config.GetAppSetting(ConnectionStringKey).ToStringValue();
DbDriverType dbDriverType = (DbDriverType)config.GetAppSetting(DbDriverTypeKey).ToInt();
Global.DbContextFactory = DbContextFactory.CreateFactory(connstr, dbDriverType);
return(this);
}
public static IDbDriver GetInstance(DbDriverType driverType)
{
switch (driverType)
{
case DbDriverType.Postgres:
return(new PostgresDriver());
default:
throw new ArgumentException(String.Format("Invalid DB Driver Type '{0}' specified!", driverType));
}
}
public static IDbDriver GetInstance(DbDriverType driverType)
{
switch (driverType)
{
case DbDriverType.Postgres:
return new PostgresDriver();
default:
throw new ArgumentException(String.Format("Invalid DB Driver Type '{0}' specified!", driverType));
}
}
public static string ToCreateTableScript(DbDriverType dbType, TableSchema tableSchema)
{
string result = "";
if (dbType == DbDriverType.Mysql)
{
result = new MySqlDriver(null, "", "").ToCreateTableScript(tableSchema);
}
else if (dbType == DbDriverType.Oracle)
{
result = new OracleDriver(null, "", "").ToCreateTableScript(tableSchema);
}
else if (dbType == DbDriverType.Sqlite)
{
result = new SqliteDriver(null, "", "").ToCreateTableScript(tableSchema);
}
else
{
result = new SqlServer2000Driver(null, "", "").ToCreateTableScript(tableSchema);
}
return(result);
}
public DataTableDbWriter(DbDriverType driverType, IDbConnectionInfo connectionInfo, DbTableInitializationOptions tableInitializationOptions = default(DbTableInitializationOptions))
{
Adapter = new DbAdapter(driverType, connectionInfo);
this.tableInitializationOptions = tableInitializationOptions;
}
public DataTableDbWriter(DbDriverType driverType, IDbConnectionInfo connectionInfo, DbTableInitializationOptions tableInitializationOptions = default(DbTableInitializationOptions))
{
Adapter = new DbAdapter(driverType, connectionInfo);
this.tableInitializationOptions = tableInitializationOptions;
}
/// <summary>
/// 根据链接字符串和数据驱动类型创建数据工厂
/// </summary>
/// <param name="connStr">链接字符串</param>
/// <param name="type">驱动类型</param>
/// <returns>返回新建的工厂</returns>
public static DbContextFactory CreateFactory(string connStr, DbDriverType type)
{
return(new DbContextFactory(connStr, type));
}
/// <summary>
/// 构造函数:创建系统指定驱动的数据访问对象信息
/// </summary>
/// <param name="connStr">数据库联接字符</param>
/// <param name="type">数据库类型</param>
private DbContextFactory(string connStr, DbDriverType type)
{
ConnectionString = connStr;
DbDriverType = type;
}
/// <summary>
/// 注册系统日志的类型
/// </summary>
/// <param name="TypeConfigKey"></param>
/// <param name="SqlConnectstring"></param>
/// <param name="LogTableName"></param>
/// <param name="dbType"></param>
/// <returns></returns>
public IAppRegister RegDbLogger(string TypeConfigKey, string SqlConnectstring, string LogTableName, DbDriverType dbType = DbDriverType.SQLServer)
{
Loger.RegisLogger(LibHelper.GetAppSetting(TypeConfigKey), SqlConnectstring, LogTableName, dbType);
return(this);
}
/// <summary>
/// 注册系统日志的类型
/// </summary>
/// <param name="type"></param>
/// <param name="SqlConnectstring"></param>
/// <param name="LogTableName"></param>
/// <param name="dbType"></param>
/// <returns></returns>
public IAppRegister RegDbLogger(LogType type, string SqlConnectstring, string LogTableName, DbDriverType dbType = DbDriverType.SQLServer)
{
Loger.RegisLogger(type, SqlConnectstring, LogTableName, dbType);
return(this);
}
public static void RegisLogger(string TypeExp, string SqlConnectstring, string LogTableName, DbDriverType dbType = DbDriverType.SQLServer)
{
if (TypeExp.IsWhiteSpace())
{
logType = LogType.Error;
}
else if (TypeExp.ToUpper().Equals("ERROR"))
{
logType = LogType.Error;
}
else if (TypeExp.ToUpper().Equals("INFO"))
{
logType = LogType.Info;
}
else if (TypeExp.ToUpper().Equals("DEBUG"))
{
logType = LogType.Debug;
}
else if (TypeExp.ToUpper().Equals("WARN"))
{
logType = LogType.Warn;
}
else if (TypeExp.ToUpper().Equals("TRACE"))
{
logType = LogType.Trace;
}
else
{
logType = LogType.Error;
}
RegisLogger(logType, SqlConnectstring, LogTableName, dbType);
}
public static void RegisLogger(string TypeExp, string SqlConnectstring, string LogTableName, DbDriverType dbType = DbDriverType.SQLServer)
{
Loger.RegisLogger(TypeExp, SqlConnectstring, LogTableName, dbType);
}
/// <summary>
/// 创建数据访问对象实例
/// </summary>
/// <returns></returns>
public static IDbContext CreateDbUtil(string ConnectionString, DbDriverType type)
{
return(DbContextFactory.CreateFactory(ConnectionString, type).CreateContext());
}
