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