private string GetCompareTypeString(SqlCompareType type)
{
switch (type)
{
case SqlCompareType.Equals:
return(" =@{0} ");
case SqlCompareType.NotEquals:
return(" <>@{0} ");
case SqlCompareType.GreaterThan:
return(" >@{0} ");
case SqlCompareType.LessThan:
return(" <@{0} ");
case SqlCompareType.GreaterThanOrEquals:
return(" >=@{0} ");
case SqlCompareType.LessThanOrEquals:
return(" <=@{0} ");
case SqlCompareType.Contains:
return(" LIKE '%'+@{0}+'%' ");
case SqlCompareType.StartsWith:
return(" LIKE @{0}+'%' ");
case SqlCompareType.EndsWith:
return(" LIKE '%'+@{0} ");
case SqlCompareType.In:
return(" IN ({0}) ");
case SqlCompareType.NotIn:
return(" NOT IN ({0}) ");
default:
return("");
}
}
public SqlWhereAttribute()
{
CompareType = SqlCompareType.Equal;
}
