public object ExecScalar(HSQL sql)
{
this.LastSQL = sql;
object obj;
try
{
DbCommand dbCommand = this.PrepareCommand(sql);
bool flag = !this.Connected;
if (flag)
{
this.OpenConnection();
}
obj = dbCommand.ExecuteScalar();
bool flag2 = !this.InTransaction;
if (flag2)
{
this.CloseConnection();
}
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
public DataSet OpenDataSet(HSQL sql)
{
DataSet dataSet = new DataSet();
this.LastSQL = sql;
try
{
DbCommand dbCommand = this.PrepareCommand(sql);
bool flag = !this.Connected;
if (flag)
{
this.OpenConnection();
}
DbDataAdapter dataAdapter = this.m_dbProviderFactory.CreateDataAdapter();
dataAdapter.SelectCommand = dbCommand;
dataAdapter.Fill(dataSet);
bool flag2 = !this.m_inTransaction;
if (flag2)
{
this.CloseConnection();
}
}
catch (Exception ex)
{
throw ex;
}
return(dataSet);
}
public int ExecSQL(HSQL sql)
{
this.LastSQL = sql;
int num;
try
{
DbCommand dbCommand = this.PrepareCommand(sql);
bool flag = !this.Connected;
if (flag)
{
this.OpenConnection();
}
num = dbCommand.ExecuteNonQuery();
bool flag2 = !this.InTransaction;
if (flag2)
{
this.CloseConnection();
}
}
catch (Exception ex)
{
throw ex;
}
return(num);
}
public int OpenDataSet(HSQL sql, DataTable dt, DataTable seDt, int startRecord, int maxRecords)
{
int num = 0;
DbCommand cmd;
using (DbDataReader dbDataReader = this.OpenReader(sql, out cmd))
{
for (int ordinal = 0; ordinal < dbDataReader.FieldCount; ordinal++)
{
bool flag = !dt.Columns.Contains(dbDataReader.GetName(ordinal));
if (flag)
{
dt.Columns.Add(dbDataReader.GetName(ordinal));
}
bool flag2 = !seDt.Columns.Contains(dbDataReader.GetName(ordinal));
if (flag2)
{
seDt.Columns.Add(dbDataReader.GetName(ordinal));
}
}
while (dbDataReader.Read())
{
num++;
bool flag3 = !(num < startRecord + 1 | num >= startRecord + maxRecords + 1);
if (flag3)
{
DataRow row = dt.NewRow();
DataRow row2 = seDt.NewRow();
for (int ordinal2 = 0; ordinal2 < dbDataReader.FieldCount; ordinal2++)
{
bool flag4 = dt.Columns.Contains(dbDataReader.GetName(ordinal2));
if (flag4)
{
row[dbDataReader.GetName(ordinal2)] = dbDataReader[ordinal2];
row2[dbDataReader.GetName(ordinal2)] = dbDataReader[ordinal2];
}
}
dt.Rows.Add(row);
seDt.Rows.Add(row2);
}
}
bool flag5 = cmd != null;
if (flag5)
{
cmd.Cancel();
}
}
return(num);
}
protected virtual DbCommand PrepareCommand(HSQL sql)
{
DbCommand command = this.m_dbProviderFactory.CreateCommand();
command.CommandTimeout = 180;
command.Connection = this.m_connection;
bool inTransaction = this.m_inTransaction;
if (inTransaction)
{
command.Transaction = this.m_transaction;
}
command.CommandType = CommandType.Text;
command.CommandText = sql.ToString();
for (int index = 0; index < sql.Params.Count; index++)
{
DbParameter parameter = this.CreateParameter("@" + sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
command.Parameters.Add(parameter);
}
return(command);
}
public DbDataReader OpenReader(HSQL sql, out DbCommand cmd)
{
this.LastSQL = sql;
DbDataReader dbDataReader;
try
{
cmd = this.PrepareCommand(sql);
bool flag = !this.Connected;
if (flag)
{
this.OpenConnection();
}
dbDataReader = ((!this.m_inTransaction) ? cmd.ExecuteReader(CommandBehavior.CloseConnection) : cmd.ExecuteReader());
}
catch (Exception ex)
{
throw ex;
}
return(dbDataReader);
}
public virtual DbDataAdapter OpenAdapter(HSQL sql)
{
this.LastSQL = sql;
DbCommand dbCommand = this.PrepareCommand(sql);
bool flag = !this.Connected;
if (flag)
{
this.OpenConnection();
}
DbDataAdapter dataAdapter = this.m_dbProviderFactory.CreateDataAdapter();
dataAdapter.SelectCommand = dbCommand;
bool flag2 = !this.m_inTransaction;
if (flag2)
{
this.CloseConnection();
}
return(dataAdapter);
}
protected override DbCommand PrepareCommand(HSQL sql)
{
DbCommand command = base.DbProviderFactory.CreateCommand();
((OracleCommand)command).BindByName = true;
command.CommandTimeout = 180;
command.Connection = this.m_connection;
bool inTransaction = base.InTransaction;
if (inTransaction)
{
command.Transaction = base.Transaction;
}
command.CommandType = CommandType.Text;
command.CommandText = sql.ToString();
for (int index = 0; index < sql.Params.Count; index++)
{
bool flag = sql.ParamByName(sql.Params[index].ToString()).ParamterType == TimDbType.Long;
if (flag)
{
OracleParameter oracleParameter = new OracleParameter(sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
oracleParameter.OracleDbType = OracleDbType.Long;
bool flag2 = sql.ParamByName(sql.Params[index].ToString()).Size != 0;
if (flag2)
{
oracleParameter.Size = sql.ParamByName(sql.Params[index].ToString()).Size;
}
bool flag3 = !string.IsNullOrEmpty(sql.ParamByName(sql.Params[index].ToString()).SourceColumn);
if (flag3)
{
oracleParameter.SourceColumn = sql.ParamByName(sql.Params[index].ToString()).SourceColumn;
}
command.Parameters.Add(oracleParameter);
}
else
{
bool flag4 = sql.ParamByName(sql.Params[index].ToString()).ParamterType == TimDbType.LongRaw;
if (flag4)
{
OracleParameter oracleParameter2 = new OracleParameter(sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
oracleParameter2.OracleDbType = OracleDbType.LongRaw;
bool flag5 = sql.ParamByName(sql.Params[index].ToString()).Size != 0;
if (flag5)
{
oracleParameter2.Size = sql.ParamByName(sql.Params[index].ToString()).Size;
}
bool flag6 = !string.IsNullOrEmpty(sql.ParamByName(sql.Params[index].ToString()).SourceColumn);
if (flag6)
{
oracleParameter2.SourceColumn = sql.ParamByName(sql.Params[index].ToString()).SourceColumn;
}
command.Parameters.Add(oracleParameter2);
}
else
{
bool flag7 = sql.ParamByName(sql.Params[index].ToString()).ParamterType == TimDbType.Text;
if (flag7)
{
OracleParameter oracleParameter3 = new OracleParameter(sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
oracleParameter3.OracleDbType = OracleDbType.Varchar2;
bool flag8 = sql.ParamByName(sql.Params[index].ToString()).Size != 0;
if (flag8)
{
oracleParameter3.Size = sql.ParamByName(sql.Params[index].ToString()).Size;
}
else
{
oracleParameter3.Size = 4000;
}
bool flag9 = !string.IsNullOrEmpty(sql.ParamByName(sql.Params[index].ToString()).SourceColumn);
if (flag9)
{
oracleParameter3.SourceColumn = sql.ParamByName(sql.Params[index].ToString()).SourceColumn;
}
command.Parameters.Add(oracleParameter3);
}
else
{
bool flag10 = sql.ParamByName(sql.Params[index].ToString()).ParamterType == TimDbType.NVarChar;
if (flag10)
{
OracleParameter oracleParameter4 = new OracleParameter(sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
oracleParameter4.OracleDbType = OracleDbType.NVarchar2;
bool flag11 = sql.ParamByName(sql.Params[index].ToString()).Size != 0;
if (flag11)
{
oracleParameter4.Size = sql.ParamByName(sql.Params[index].ToString()).Size;
}
bool flag12 = !string.IsNullOrEmpty(sql.ParamByName(sql.Params[index].ToString()).SourceColumn);
if (flag12)
{
oracleParameter4.SourceColumn = sql.ParamByName(sql.Params[index].ToString()).SourceColumn;
}
command.Parameters.Add(oracleParameter4);
}
else
{
DbParameter parameter = base.CreateParameter(sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
bool flag13 = parameter.DbType == DbType.String;
if (flag13)
{
parameter.DbType = DbType.AnsiString;
}
else
{
switch (sql.ParamByName(sql.Params[index].ToString()).ParamterType)
{
case TimDbType.Null:
{
bool flag14 = sql.ParamByName(sql.Params[index].ToString()).Value is DateTime;
if (flag14)
{
parameter.DbType = DbType.Date;
}
break;
}
case TimDbType.VarChar:
parameter.DbType = DbType.String;
break;
case TimDbType.DateTime:
parameter.DbType = DbType.Date;
break;
case TimDbType.Float:
parameter.DbType = DbType.Double;
break;
}
}
bool flag15 = sql.ParamByName(sql.Params[index].ToString()).Size != 0;
if (flag15)
{
parameter.Size = sql.ParamByName(sql.Params[index].ToString()).Size;
}
bool flag16 = !string.IsNullOrEmpty(sql.ParamByName(sql.Params[index].ToString()).SourceColumn);
if (flag16)
{
parameter.SourceColumn = sql.ParamByName(sql.Params[index].ToString()).SourceColumn;
}
command.Parameters.Add(parameter);
}
}
}
}
}
return(command);
}
protected override DbCommand PrepareCommand(HSQL sql)
{
DbCommand command = base.DbProviderFactory.CreateCommand();
command.CommandTimeout = 180;
command.Connection = this.m_connection;
bool inTransaction = base.InTransaction;
if (inTransaction)
{
command.Transaction = base.Transaction;
}
command.CommandType = CommandType.Text;
command.CommandText = sql.ToString();
for (int index = 0; index < sql.Params.Count; index++)
{
bool flag = sql.ParamByName(sql.Params[index].ToString()).ParamterType == TimDbType.Text || sql.ParamByName(sql.Params[index].ToString()).ParamterType == TimDbType.Long;
if (flag)
{
SqlParameter sqlParameter = new SqlParameter("@" + sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
sqlParameter.SqlDbType = SqlDbType.Text;
bool flag2 = !string.IsNullOrEmpty(sql.ParamByName(sql.Params[index].ToString()).SourceColumn);
if (flag2)
{
sqlParameter.SourceColumn = sql.ParamByName(sql.Params[index].ToString()).SourceColumn;
}
command.Parameters.Add(sqlParameter);
}
else
{
bool flag3 = sql.ParamByName(sql.Params[index].ToString()).ParamterType == TimDbType.LongRaw;
if (flag3)
{
SqlParameter sqlParameter2 = new SqlParameter("@" + sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
sqlParameter2.SqlDbType = SqlDbType.Image;
bool flag4 = !string.IsNullOrEmpty(sql.ParamByName(sql.Params[index].ToString()).SourceColumn);
if (flag4)
{
sqlParameter2.SourceColumn = sql.ParamByName(sql.Params[index].ToString()).SourceColumn;
}
command.Parameters.Add(sqlParameter2);
}
else
{
bool flag5 = sql.ParamByName(sql.Params[index].ToString()).ParamterType == TimDbType.NVarChar;
if (flag5)
{
SqlParameter sqlParameter3 = new SqlParameter("@" + sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
sqlParameter3.SqlDbType = SqlDbType.NVarChar;
bool flag6 = sql.ParamByName(sql.Params[index].ToString()).Size != 0;
if (flag6)
{
sqlParameter3.Size = sql.ParamByName(sql.Params[index].ToString()).Size;
}
bool flag7 = !string.IsNullOrEmpty(sql.ParamByName(sql.Params[index].ToString()).SourceColumn);
if (flag7)
{
sqlParameter3.SourceColumn = sql.ParamByName(sql.Params[index].ToString()).SourceColumn;
}
command.Parameters.Add(sqlParameter3);
}
else
{
DbParameter parameter = base.CreateParameter("@" + sql.Params[index].ToString(), sql.ParamByName(sql.Params[index].ToString()).Value);
bool flag8 = parameter.DbType == DbType.String;
if (flag8)
{
parameter.DbType = DbType.AnsiString;
}
else
{
switch (sql.ParamByName(sql.Params[index].ToString()).ParamterType)
{
case TimDbType.VarChar:
parameter.DbType = DbType.String;
break;
case TimDbType.DateTime:
parameter.DbType = DbType.DateTime;
break;
case TimDbType.Float:
parameter.DbType = DbType.Double;
break;
}
}
bool flag9 = sql.ParamByName(sql.Params[index].ToString()).Size != 0 && sql.ParamByName(sql.Params[index].ToString()).ParamterType != TimDbType.Float;
if (flag9)
{
parameter.Size = sql.ParamByName(sql.Params[index].ToString()).Size;
}
bool flag10 = !string.IsNullOrEmpty(sql.ParamByName(sql.Params[index].ToString()).SourceColumn);
if (flag10)
{
parameter.SourceColumn = sql.ParamByName(sql.Params[index].ToString()).SourceColumn;
}
command.Parameters.Add(parameter);
}
}
}
}
return(command);
}
