/// <summary>
/// 使用比较字符串构造本类
/// </summary>
/// <param name="filedName">字段名</param>
/// <param name="compareTypeString">比较字符串，比如=，like，is 等SQL比较符号</param>
/// <param name="fieldValue">要比较的值</param>
public QueryParameter(string filedName, string compareTypeString, object fieldValue)
{
this.FieldName = filedName;
this.FieldValue = fieldValue;
switch (compareTypeString.Trim())
{
case "=": this.CompareType = enumCompare.Equal; break;
case "<>": this.CompareType = enumCompare.NotEqual; break;
case ">": this.CompareType = enumCompare.Greater; break;
case "<": this.CompareType = enumCompare.Smaller; break;
case ">=": this.CompareType = enumCompare.NoSmaller; break;
case "<=": this.CompareType = enumCompare.NoGreater; break;
case "like":
case "LIKE":
this.CompareType = enumCompare.Like; break;
case "is null":
case "IS NULL":
this.CompareType = enumCompare.IsNull; break;
case "is not null":
case "IS NOT NULL":
this.CompareType = enumCompare.IsNotNull; break;
default:
this.CompareType = enumCompare.Equal; break;
}
}
/// <summary>
/// 使用比较字符串构造本类
/// </summary>
/// <param name="filedName">字段名</param>
/// <param name="compareTypeString">比较字符串，比如=，like，is 等SQL比较符号</param>
/// <param name="fieldValue">要比较的值</param>
public QueryParameter(string filedName, string compareTypeString, object fieldValue)
{
this.FieldName = filedName;
this.FieldValue = fieldValue;
switch (compareTypeString.Trim ())
{
case "=": this.CompareType = enumCompare.Equal; break;
case "<>": this.CompareType = enumCompare.NotEqual; break;
case ">": this.CompareType = enumCompare.Greater; break;
case "<": this.CompareType = enumCompare.Smaller ; break;
case ">=": this.CompareType = enumCompare.NoSmaller ; break;
case "<=": this.CompareType = enumCompare.NoGreater ; break;
case "like":
case "LIKE":
this.CompareType = enumCompare.Like ; break;
case "is null":
case "IS NULL":
this.CompareType = enumCompare.IsNull ; break;
case "is not null":
case "IS NOT NULL":
this.CompareType = enumCompare.IsNotNull ; break;
default :
this.CompareType = enumCompare.Equal; break;
}
}
/// <summary>
/// 使用参数构造本类
/// </summary>
/// <param name="filedName">字段名</param>
/// <param name="compareType">比较类型</param>
/// <param name="fieldValue">字段值</param>
public QueryParameter(string filedName, enumCompare compareType, object fieldValue)
{
this.FieldName = filedName;
this.FieldValue = fieldValue;
this.CompareType = compareType;
}
/// <summary>
/// 使用参数构造本类
/// </summary>
/// <param name="filedName">字段名</param>
/// <param name="compareType">比较类型</param>
/// <param name="fieldValue">字段值</param>
public QueryParameter(string filedName, enumCompare compareType, object fieldValue)
{
this.FieldName = filedName;
this.FieldValue = fieldValue;
this.CompareType = compareType;
}
