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