/// <summary> /// 前台分页参数 /// </summary> /// <param name="strFieldName">列名</param> /// <param name="param">参数类型</param> /// <param name="paramType">列类型</param> /// <param name="strFieldValue">列值</param> /// <param name="strFieldValue2">列值2</param> public PageParams(string strFieldName, PageParam param, SqlParamType paramType, string strFieldValue, string strFieldValue2) { this.strFieldName = strFieldName; this.param = param; this.strFieldValue = strFieldValue; this.strFieldValue2 = strFieldValue2; this.paramType = paramType; }
/// <summary> /// Ctor /// </summary> /// <param name="name">Name of the parameter (without rollmop)</param> /// <param name="value">Value of the parameter</param> /// <param name="direction">Direction of the parameter</param> /// <param name="sqlType">Sql type of the parametr</param> /// <param name="size">Size of the sql type</param> public SqlParam(string name, object value, SqlParamType sqlType, int?size = null, ParameterDirection direction = ParameterDirection.Input) { if (string.IsNullOrEmpty(name)) { throw new ArgumentException("Sql parameter must have a name!", nameof(name)); } Name = name.TrimStart('@'); Value = value; Direction = direction; SqlType = sqlType; Size = size; }
/// <summary> /// Converts unified sql db type to MS-SQL Db type /// </summary> /// <param name="unitedType">Unified db type</param> /// <returns>MS-SQL Db type</returns> private static SqlDbType ConvertDatabaseType(SqlParamType unitedType) { switch (unitedType) { case SqlParamType.Decimal: return(SqlDbType.Decimal); case SqlParamType.Int16: return(SqlDbType.SmallInt); case SqlParamType.Int32: return(SqlDbType.Int); case SqlParamType.Int64: return(SqlDbType.BigInt); case SqlParamType.StringUtf8: return(SqlDbType.NVarChar); case SqlParamType.StringAnsi: return(SqlDbType.VarChar); case SqlParamType.DateTime: return(SqlDbType.DateTime); case SqlParamType.Date: return(SqlDbType.Date); case SqlParamType.Time: return(SqlDbType.Time); case SqlParamType.Bool: return(SqlDbType.Bit); default: throw new EnumValueNotImplementedException(unitedType); } }
public SqlParam(object value, SqlParamType dataType) { Value = value; DataType = dataType; }
public SqlParam(SqlParam ToCopy) { Value = ToCopy.Value; DataType = ToCopy.DataType; }
public static HqlParameter CreateInstance(string name, SqlParamType type, object value) { return new HqlParameter(name, type, value); }
private HqlParameter(string name, SqlParamType type, object value) { this.Name = name; this.Type = type; this.Value = value; }