public virtual ISqlQuery AddWhereParam(string field, string paramName, object value, ComparisonType comparisonType)
{
WhereCriterion crit = new ParameterWhereCriterion(field, paramName, comparisonType);
MergeWhere(crit, JoinType.And);
AddParameter("@" + paramName, value);
return(this);
}
public virtual ISqlQuery AddWhere(string field, object value, ComparisonType comparisonType)
{
IWhereCriterion crit;
if (value is string &&
((string)value).Substring(0, 1) == "@")
{
crit = new ParameterWhereCriterion(field, ((string)value).Substring(1), comparisonType);
}
else
{
crit = new WhereCriterion(field, value, comparisonType);
}
MergeWhere(crit, JoinType.And);
return(this);
}
public virtual ISqlQuery AddWhereParam(string field, string paramName, object value, ComparisonType comparisonType)
{
WhereCriterion crit = new ParameterWhereCriterion(field, paramName, comparisonType);
MergeWhere(crit, JoinType.And);
AddParameter("@" + paramName, value);
return this;
}
public virtual ISqlQuery AddWhere(string field, object value, ComparisonType comparisonType)
{
IWhereCriterion crit;
if (value is string
&& ((string)value).Substring(0, 1) == "@")
{
crit = new ParameterWhereCriterion(field, ((string)value).Substring(1), comparisonType);
}
else
{
crit = new WhereCriterion(field, value, comparisonType);
}
MergeWhere(crit, JoinType.And);
return this;
}
