public int ExecuteNonQuery(string sqlText)
{
if (DBStatus != DBStatusENum.Opening)
{
return(-1);
}
int iRecordsAffected = -1;
try
{
switch (Config.ServerType)
{
case DbServerType.SqlServer:
if (SqlExecute == null)
{
SqlExecute = new DbExecute <SqlConnection, SqlCommand, SqlDataAdapter, SqlDataReader>(Config.ConnectionString);
}
iRecordsAffected = SqlExecute.ExecuteNonQuery(sqlText);
break;
case DbServerType.SqlServerCe:
if (SqlCeExecute == null)
{
SqlCeExecute = new DbExecute <SqlCeConnection, SqlCeCommand, SqlCeDataAdapter, SqlCeDataReader>(Config.ConnectionString);
}
iRecordsAffected = SqlCeExecute.ExecuteNonQuery(sqlText);
break;
case DbServerType.MySql:
if (MySqlExecute == null)
{
MySqlExecute = new DbExecute <MySqlConnection, MySqlCommand, MySqlDataAdapter, MySqlDataReader>(Config.ConnectionString);
}
iRecordsAffected = MySqlExecute.ExecuteNonQuery(sqlText);
break;
case DbServerType.Oracle:
if (OracleExecute == null)
{
OracleExecute = new DbExecute <OracleConnection, OracleCommand, OracleDataAdapter, OracleDataReader>(Config.ConnectionString);
}
iRecordsAffected = OracleExecute.ExecuteNonQuery(sqlText);
break;
default:
break;
}
}
catch (Exception ex)
{
throw (new Exception(ex.Message));
}
finally
{
}
return(iRecordsAffected);
}
public bool Open()
{
if (DBStatus == DBStatusENum.Opening)
{
return(true);
}
bool bSuccessOpened = false;
try
{
switch (Config.ServerType)
{
case DbServerType.SqlServer:
if (SqlExecute == null)
{
SqlExecute = new DbExecute <SqlConnection, SqlCommand, SqlDataAdapter, SqlDataReader>();
}
SqlExecute.dbConnection.ConnectionString = Config.ConnectionString;
SqlExecute.dbConnection.Open();
bSuccessOpened = true;
break;
case DbServerType.SqlServerCe:
if (SqlCeExecute == null)
{
SqlCeExecute = new DbExecute <SqlCeConnection, SqlCeCommand, SqlCeDataAdapter, SqlCeDataReader>();
}
SqlCeExecute.dbConnection.ConnectionString = Config.ConnectionString;
SqlCeExecute.dbConnection.Open();
bSuccessOpened = true;
break;
case DbServerType.MySql:
if (MySqlExecute == null)
{
MySqlExecute = new DbExecute <MySqlConnection, MySqlCommand, MySqlDataAdapter, MySqlDataReader>();
}
MySqlExecute.dbConnection.ConnectionString = Config.ConnectionString;
MySqlExecute.dbConnection.Open();
bSuccessOpened = true;
break;
case DbServerType.Oracle:
if (OracleExecute == null)
{
OracleExecute = new DbExecute <OracleConnection, OracleCommand, OracleDataAdapter, OracleDataReader>();
}
OracleExecute.dbConnection.ConnectionString = Config.ConnectionString;
OracleExecute.dbConnection.Open();
bSuccessOpened = true;
break;
default:
break;
}
}
catch (Exception ex)
{
throw (new Exception(ex.Message));
}
finally
{
}
return(bSuccessOpened);
}
public bool ExecuteDataSet(string sqlText)
{
if (DBStatus != DBStatusENum.Opening)
{
return(false);
}
bool bSuccessExecuted = false;
try
{
switch (Config.ServerType)
{
case DbServerType.SqlServer:
if (SqlExecute == null)
{
SqlExecute = new DbExecute <SqlConnection, SqlCommand, SqlDataAdapter, SqlDataReader>(Config.ConnectionString);
}
bSuccessExecuted = SqlExecute.ExecuteDataSet(sqlText);
if (bSuccessExecuted)
{
dataSet = SqlExecute.dataSet;
}
break;
case DbServerType.SqlServerCe:
if (SqlCeExecute == null)
{
SqlCeExecute = new DbExecute <SqlCeConnection, SqlCeCommand, SqlCeDataAdapter, SqlCeDataReader>(Config.ConnectionString);
}
bSuccessExecuted = SqlCeExecute.ExecuteDataSet(sqlText);
if (bSuccessExecuted)
{
dataSet = SqlCeExecute.dataSet;
}
break;
case DbServerType.MySql:
if (MySqlExecute == null)
{
MySqlExecute = new DbExecute <MySqlConnection, MySqlCommand, MySqlDataAdapter, MySqlDataReader>(Config.ConnectionString);
}
bSuccessExecuted = MySqlExecute.ExecuteDataSet(sqlText);
if (bSuccessExecuted)
{
dataSet = MySqlExecute.dataSet;
}
break;
case DbServerType.Oracle:
if (OracleExecute == null)
{
OracleExecute = new DbExecute <OracleConnection, OracleCommand, OracleDataAdapter, OracleDataReader>(Config.ConnectionString);
}
bSuccessExecuted = OracleExecute.ExecuteDataSet(sqlText);
if (bSuccessExecuted)
{
dataSet = OracleExecute.dataSet;
}
break;
default:
break;
}
}
catch (Exception ex)
{
throw (new Exception(ex.Message));
}
finally
{
}
return(bSuccessExecuted);
}