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 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);
}
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);
}
