public DBParameter(string name, object value, DBParameterType paramType, string sourceColumn) { _paramName = name; _paramValue = value; _paramType = paramType; _sourceColumn = sourceColumn; }
private static OracleDbType GetParameterType(DBParameterType parameterType, object value) { OracleDbType type; if (parameterType.IsDbType) { return(DbTypeToOracleDbType((DbType)parameterType.Code)); } else if (TryGetOracleDbType(parameterType.Name, out type)) { return(type); } throw new ArgumentException("Can not convert parameter to OracleParameter:" + parameterType); }
public static void AddOutputParam(SqlCommand cmd, string strName, DBParameterType paramType) { SqlParameter p = null; switch (paramType) { case DBParameterType.IntParamOutput: p = new SqlParameter(strName, SqlDbType.Int); break; case DBParameterType.StringParamOutput: p = new SqlParameter(strName, SqlDbType.VarChar, 8000); break; } p.Direction = ParameterDirection.Output; cmd.Parameters.Add(p); }
private void AddDBParam(SqlCommand cmd, DBParameter dbParam) { if (dbParam.ParamValue == null) { AddDBParamNoValue(cmd, dbParam); return; } try { DBParameterType paramType = dbParam.ParamType; switch (paramType) { case DBParameterType.BoolParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (bool)dbParam.ParamValue); break; case DBParameterType.DateTimeParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (DateTime)dbParam.ParamValue); break; case DBParameterType.DoubleParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (double)dbParam.ParamValue); break; case DBParameterType.IntParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (int)dbParam.ParamValue); break; case DBParameterType.NullableIntParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (int?)dbParam.ParamValue); break; case DBParameterType.StringParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (string)dbParam.ParamValue); break; case DBParameterType.TextParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (string)dbParam.ParamValue, true); break; case DBParameterType.XmlParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (string)dbParam.ParamValue, false, true); break; case DBParameterType.BytesParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (byte[])dbParam.ParamValue); break; case DBParameterType.NcharParam: SqlUtil.AddParam(cmd, dbParam.ParamName, dbParam.ParamValue == null ? new char[0] : ((string)dbParam.ParamValue).ToCharArray()); break; case DBParameterType.IntParamOutput: SqlUtil.AddOutputParam(cmd, dbParam.ParamName, paramType); ParameterNames.Add(dbParam.ParamName); break; case DBParameterType.StringParamOutput: SqlUtil.AddOutputParam(cmd, dbParam.ParamName, paramType); ParameterNames.Add(dbParam.ParamName); break; case DBParameterType.ByteParam: SqlUtil.AddParam(cmd, dbParam.ParamName, (byte)dbParam.ParamValue); break; } } #pragma warning disable 168 catch (System.InvalidCastException whoops) { // bad data, treat as null... AddDBParamNoValue(cmd, dbParam); } #pragma warning restore 168 }