public void Dispose()
{
if (_connection != null)
{
_connection.Dispose();
}
}
/// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
if (Conn != null)
{
Conn.Close();
Conn.Dispose();
}
}
private DataTable RunSQLReturnTable(string sql, System.Data.Common.DbConnection conn, string dsn, CommandType cmdType)
{
if (conn is System.Data.SqlClient.SqlConnection)
{
return(BP.DA.DBAccess.RunSQLReturnTable(sql, (System.Data.SqlClient.SqlConnection)conn, dsn, cmdType));
}
if (conn is System.Data.OleDb.OleDbConnection)
{
return(BP.DA.DBAccess.RunSQLReturnTable(sql, (System.Data.OleDb.OleDbConnection)conn, cmdType));
}
if (conn is System.Data.OracleClient.OracleConnection)
{
return(BP.DA.DBAccess.RunSQLReturnTable(sql, (System.Data.OracleClient.OracleConnection)conn, cmdType, dsn));
}
if (conn is MySqlConnection)
{
var mySqlConn = (MySqlConnection)conn;
if (mySqlConn.State != ConnectionState.Open)
{
mySqlConn.Open();
}
var ada = new MySqlDataAdapter(sql, mySqlConn);
ada.SelectCommand.CommandType = CommandType.Text;
try
{
DataTable oratb = new DataTable("otb");
ada.Fill(oratb);
ada.Dispose();
conn.Close();
conn.Dispose();
return(oratb);
}
catch (Exception ex)
{
ada.Dispose();
conn.Close();
throw new Exception("SQL=" + sql + " Exception=" + ex.Message);
}
}
throw new Exception("没有涉及到的连接测试类型...");
return(null);
}
/// <summary>
/// Cleanup.
/// </summary>
public void Clear()
{
_connection.Close();
_connection.Dispose();
}