public DataParameter(string Name, object Value, Type Type, System.Data.ParameterDirection Direction)
{
_name = Name;
_value = Value;
_type = Type;
_direction = Direction;
}
internal SqlParameter(Type clrType, ProviderType sqlType, string name, Expression sourceExpression)
: base(SqlNodeType.Parameter, clrType, sqlType, sourceExpression) {
if (name == null)
throw Error.ArgumentNull("name");
if (typeof(Type).IsAssignableFrom(clrType))
throw Error.ArgumentWrongValue("clrType");
this.name = name;
this.direction = System.Data.ParameterDirection.Input;
}
} // End Function AddParameter
// [System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.AggressiveInlining)]
public virtual System.Data.IDbDataParameter AddParameter(System.Data.IDbCommand command, string strParameterName, object objValue, System.Data.ParameterDirection pad)
{
if (objValue == null)
{
//throw new ArgumentNullException("objValue");
objValue = System.DBNull.Value;
} // End if (objValue == null)
System.Type tDataType = objValue.GetType();
System.Data.DbType dbType = GetDbType(tDataType);
return(AddParameter(command, strParameterName, objValue, pad, dbType));
} // End Function AddParameter
public OraParamDateTime(string name, System.Data.ParameterDirection direction, DateTime?value) : base(name, DbType.DateTime, direction, value, 0)
{
}
public SqlParameter CreateParamater(string name, System.Data.DbType type, int size, System.Data.ParameterDirection direction)
{
return(new SqlParameter
{
ParameterName = name,
DbType = type,
Size = size,
Direction = direction
});
}
public SqliteParameter(string parameterName, System.Data.DbType parameterType, int parameterSize, System.Data.ParameterDirection direction, byte precision, byte scale, string sourceColumn, System.Data.DataRowVersion rowVersion, bool sourceColumnNullMapping, object value)
{
}
public OleDbParameter(string parameterName, System.Data.OleDb.OleDbType dbType, int size, System.Data.ParameterDirection direction, byte precision, byte scale, string sourceColumn, System.Data.DataRowVersion sourceVersion, bool sourceColumnNullMapping, object value)
{
}
public OraParamCLOB(string name, System.Data.ParameterDirection direction, string value) : base(name, DbType.CLOB, direction, value, 0)
{
}
public DataAccessParameter(string parameterName, object parameterValue, System.Data.ParameterDirection direction)
{
InitData(parameterName, parameterValue, direction);
}
public OdbcParameter(string?parameterName, System.Data.Odbc.OdbcType odbcType, int size, System.Data.ParameterDirection parameterDirection, byte precision, byte scale, string?sourceColumn, System.Data.DataRowVersion sourceVersion, bool sourceColumnNullMapping, object?value)
{
}
public DeleteProcedureParameter(string field, string name, DataType dataType, object defaultValue = null, System.Data.ParameterDirection direction = System.Data.ParameterDirection.Input, int size = 0)
: base(DefaultProceduresKeys.DELETE.ToString(), field, name, dataType, defaultValue, direction, size)
{
}
public DB2Parameter(string parameterName, IBM.Data.DB2.DB2Type db2Type, int size, System.Data.ParameterDirection parameterDirection, bool isNullable, byte precision, byte scale, string srcColumn, System.Data.DataRowVersion srcVersion, object value)
{
}
} // End Function AddParameter
public static System.Data.IDbDataParameter AddParameter(System.Data.IDbCommand command, string strParameterName, object objValue, System.Data.ParameterDirection pad, System.Data.DbType dbType)
{
System.Data.IDbDataParameter parameter = command.CreateParameter();
if (!strParameterName.StartsWith("@"))
{
strParameterName = "@" + strParameterName;
} // End if (!strParameterName.StartsWith("@"))
parameter.ParameterName = strParameterName;
parameter.DbType = dbType;
parameter.Direction = pad;
// Es ist keine Zuordnung von DbType UInt64 zu einem bekannten SqlDbType vorhanden.
// No association DbType UInt64 to a known SqlDbType
SetParameter(parameter, objValue);
command.Parameters.Add(parameter);
return(parameter);
} // End Function AddParameter
public OraParamRefCursor(string name, System.Data.ParameterDirection direction)
: base(name, DbType.RefCursor, direction, null, 0)
{
ParamValue = new System.Data.DataTable();
}
public OraParamBLOB(string name, System.Data.ParameterDirection direction, byte[] value)
: base(name, DbType.BLOB, direction, value, 0)
{
ParamSize = value == null? 0 : value.Length;
}
public override DbParameter AddParameter(DbCommand cmd, String name, String value, SqlParamterTypes type, int size, System.Data.ParameterDirection direction)
{
SqlParameter param = new SqlParameter();
SqlCommand command = (SqlCommand)cmd;
param.ParameterName = name;
param.Value = value;
param.Direction = direction;
param.Size = size;
param.DbType = (System.Data.DbType)Enum.Parse(typeof(System.Data.DbType), type.ToString());
command.Parameters.Add(param);
return(param);
}
public FunctionParameterModel(ParameterModel parameter, System.Data.ParameterDirection direction)
{
Parameter = parameter;
Direction = direction;
}
public OdbcParameter(string?parameterName, System.Data.Odbc.OdbcType odbcType, int size, System.Data.ParameterDirection parameterDirection, bool isNullable, byte precision, byte scale, string srcColumn, System.Data.DataRowVersion srcVersion, object?value)
{
}
private void CreateParameter(MySqlCommand sqlCmd, object parmaValue, string strName, MySqlDbType dbType, System.Data.ParameterDirection paramDirect)
{
MySqlParameter param = null;
if (!sqlCmd.Parameters.Contains(strName))
{
param = sqlCmd.CreateParameter();
param.ParameterName = strName;
sqlCmd.Parameters.Add(param);
}
else
{
param = sqlCmd.Parameters[strName];
}
param.DbType = (System.Data.DbType)dbType;
param.Value = parmaValue;
param.Direction = paramDirect;
}
public OleDbParameter(string parameterName, System.Data.OleDb.OleDbType dbType, int size, System.Data.ParameterDirection direction, bool isNullable, byte precision, byte scale, string srcColumn, System.Data.DataRowVersion srcVersion, object value)
{
}
public SqlParameter(string parameterName, System.Data.ParameterDirection direction, object value)
{
this.ParameterName = parameterName;
this.Direction = direction;
this.Value = value;
}
public static System.Data.SqlClient.SqlParameter CreateParameter(string ParameterName, System.Data.ParameterDirection Direction,
System.Data.SqlDbType SqlDbType, Object Value)
{
var SqlParameter = new System.Data.SqlClient.SqlParameter
{
ParameterName = string.Concat("@", ParameterName),
Direction = Direction,
SqlDbType = SqlDbType,
Value = Value
};
return(SqlParameter);
}
public OraParamString(string name, System.Data.ParameterDirection direction, string value, int size) : base(name, DbType.String, direction, value, size)
{
}
/// <summary>
/// 传入参数生成一个MySQLParameter
/// </summary>
/// <param name="strParamName">存储过程名称</param>
/// <param name="dataType">参数类型</param>
/// <param name="size">参数大小</param>
/// <param name="objValue">参数值</param>
/// <param name="direction">参数方向</param>
/// <returns>新的MySQLParameter对象</returns>
public MySqlParameter CreateParameter(string strParamName, MySqlDbType dataType, int size, System.Data.ParameterDirection direction, object objValue)
{
MySqlParameter sqlParameter;
if (size > 0)
{
sqlParameter = new MySqlParameter(strParamName, dataType, size);
}
else
{
sqlParameter = new MySqlParameter(strParamName, dataType);
}
sqlParameter.Direction = direction;
if (objValue != null && sqlParameter.Direction != System.Data.ParameterDirection.Output)
{
sqlParameter.Value = objValue;
}
return(sqlParameter);
}
public override System.Data.IDataParameter CreateProcParameter(string name, object value, System.Data.ParameterDirection direction)
{
System.Data.IDataParameter dp = base.CreateProcParameter(name, value, direction);
if (direction == System.Data.ParameterDirection.Output)
{
if (value != null && value.GetType() == typeof(OracleProcCursor))
{
OracleParameter op = (OracleParameter)dp;
op.OracleType = OracleType.Cursor;
op.Value = DBNull.Value;
}
}
return(dp);
}
private static void GenerateSqlParameter(CodeStringBuilder code, String valueExpression, String localParameterName, String sqlParameterName, System.Data.SqlDbType sqlDbType, bool is_nullable, System.Data.ParameterDirection parameterDirection, long max_length)
{
if (IsVariableLength(sqlDbType))
{
code.AppendLineFormat("System.Data.SqlClient.SqlParameter {0} = command.Parameters.Add(\"{1}\", System.Data.SqlDbType.{2}, {3});", localParameterName, sqlParameterName, sqlDbType.ToString(), max_length);
}
else
{
code.AppendLineFormat("System.Data.SqlClient.SqlParameter {0} = command.Parameters.Add(\"{1}\", System.Data.SqlDbType.{2});", localParameterName, sqlParameterName, sqlDbType.ToString(), max_length);
}
if (parameterDirection == System.Data.ParameterDirection.Output)
{
code.AppendLineFormat("{0}.Direction = System.Data.ParameterDirection.Output;", localParameterName);
}
else
{
if (parameterDirection == System.Data.ParameterDirection.InputOutput)
{
code.AppendLineFormat("{0}.Direction = System.Data.ParameterDirection.InputOutput;", localParameterName);
}
if (is_nullable)
{
code.CodeBlockBegin("if ({0} == null)", valueExpression);
code.AppendLineFormat("{0}.Value = System.DBNull.Value;", localParameterName);
code.CodeBlockEnd();
code.CodeBlockBegin("else");
code.AppendLineFormat("{0}.Value = {1};", localParameterName, valueExpression);
code.CodeBlockEnd();
}
else
{
code.AppendLineFormat("{0}.Value = {1};", localParameterName, valueExpression);
}
}
}
System.Data.IDbDataParameter IptBaseDb.CreateParam(string paramName, object paramValue, System.Data.ParameterDirection paraDirect)
{
throw new NotImplementedException();
}
public virtual DbParameter AddParameter(DbCommand cmd, String name, String value, SqlParamterTypes type, int size, System.Data.ParameterDirection direction)
{
Logger?.Invoke("AddParameter", @"Unknown database type. Can not create parameter.");
return(null);
}
// Constructors
public DesignerDataParameter(string name, System.Data.DbType dataType, System.Data.ParameterDirection direction)
{
}
public ProcedureParameter(string procedureKey, string field, string name, DataType dataType, object defaultValue = null, System.Data.ParameterDirection direction = System.Data.ParameterDirection.Input, int size = 0)
{
ProcedureKey = procedureKey;
Field = field;
Name = name;
DataType = dataType;
DefaultValue = defaultValue;
Direction = direction;
Size = size;
}
private static DataParameter getDataParameter(IPropertyMapper propertyMapper, object value, System.Data.ParameterDirection pd)
{
return(new DataParameter(propertyMapper.ColumnName, value, propertyMapper.DbType, propertyMapper.Size, pd));
}
private void InitData(string parameterName, object parameterValue, System.Data.ParameterDirection direction)
{
this.ParameterName = parameterName;
this.ParameterValue = parameterValue ?? DBNull.Value;
this.Direction = direction;
//this.DbType = System.Data.DbType.String;
//TODO: DBType
}
public override DbParameter AddParameter(DbCommand cmd, String name, String value, SqlParamterTypes type, int size, System.Data.ParameterDirection direction)
{
OracleParameter param = new OracleParameter();
OracleCommand command = (OracleCommand)cmd;
param.ParameterName = name;
param.Direction = direction;
param.Value = value;
param.Size = size;
int enumValue = (int)type;
if (enumValue >= 100)
{
param.OracleDbType = (OracleDbType)Enum.Parse(typeof(OracleDbType), type.ToString());
}
else
{
param.DbType = (System.Data.DbType)Enum.Parse(typeof(System.Data.DbType), type.ToString());
}
// For Oracle Functions, ReturnValue Must Be First Parameter
if (param.Direction == System.Data.ParameterDirection.ReturnValue)
{
command.Parameters.Insert(0, param);
}
else
{
command.Parameters.Add(param);
}
return(param);
}
