/// <summary>
/// DB連接對象
/// </summary>
/// <param name="DBConntionConfigName">連接配置名稱</param>
/// <param name="ReadXMLConfig">是否從XML配置檔讀取連接字符串</param>
public OleExec(string DBConntionConfigName, bool ReadXMLConfig)
{
if (Pool != null && !Pool.TestBorrow(this))
{
throw new Exception("OleExec havn't borrow from DBPool!");
}
if (ReadXMLConfig)
{
ConnectionManager.Init();
_connStr = ConnectionManager.GetConnString(DBConntionConfigName);
}
else
{
_connStr = ConfigurationManager.AppSettings[DBConntionConfigName];
}
//_conn = new OleDbConnection(_connStr);
//_conn.Open();
//_comm = new OleDbCommand();
//_adp = new OleDbDataAdapter(_comm);
db = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = _connStr,
DbType = SqlSugar.DbType.Oracle,
IsAutoCloseConnection = false,
InitKeyType = InitKeyType.Attribute
});
}
/// <summary>
/// DB連接對象
/// </summary>
/// <param name="DBConntionConfigName">連接配置名稱</param>
/// <param name="ReadXMLConfig">是否從XML配置檔讀取連接字符串</param>
public OleExec(string DBConntionConfigName, bool ReadXMLConfig)
{
if (Pool != null && !Pool.TestBorrow(this))
{
throw new Exception("OleExec havn't borrow from DBPool!");
}
if (ReadXMLConfig)
{
ConnectionManager.Init();
_connStr = ConnectionManager.GetConnString(DBConntionConfigName);
}
else
{
_connStr = ConfigurationManager.AppSettings[DBConntionConfigName];
}
_conn = new OleDbConnection(_connStr);
_conn.Open();
_comm = new OleDbCommand();
_adp = new OleDbDataAdapter(_comm);
}
