private string GetCompareCondition(string name, DbConditionCompare compare, string relation)
{
switch (compare)
{
case DbConditionCompare.LT:
return("<");
case DbConditionCompare.LTOrEqual:
return("<=");
case DbConditionCompare.GT:
return(">");
case DbConditionCompare.GTOrEqual:
return(">=");
case DbConditionCompare.Equal:
return("=");
case DbConditionCompare.Unequal:
return("!=");
case DbConditionCompare.IsNull:
this.Add(string.Format("{0} IS NULL", this.DbHelper.QuoteIdentifier(name)), relation);
return(string.Empty);
case DbConditionCompare.IsNotNull:
this.Add(string.Format("{0} IS NOT NULL", this.DbHelper.QuoteIdentifier(name)), relation);
return(string.Empty);
}
return(string.Empty);
}
public void AddCompareCriteria <T>(string name, DbConditionCompare compare, T?value, string relation) where T : struct
{
string str = this.GetCompareCondition(name, compare, relation);
if (!string.IsNullOrEmpty(str) && value.HasValue)
{
string str2 = this.DbHelper.CreateSeqParameterName();
this.Add(string.Format("{0}{1}{2}", this.DbHelper.QuoteIdentifier(name), str, this.DbHelper.GetDbParameterName(str2)), relation, new DbParameter[] { this.DbHelper.CreateDbParameter(str2, typeof(T).GetDbType(), value.Value) });
}
}
public void AddCompareCriteria(string name, DbConditionCompare compare, string value, int length, string relation)
{
string str = this.GetCompareCondition(name, compare, relation);
if (!string.IsNullOrEmpty(str) && (value != null))
{
string str2 = this.DbHelper.CreateSeqParameterName();
this.Add(string.Format("{0}{1}{2}", this.DbHelper.QuoteIdentifier(name), str, this.DbHelper.GetDbParameterName(str2)), relation, new DbParameter[] { this.DbHelper.CreateDbParameter(str2, DbType.String, length, value) });
}
}
public void AddCompareCriteria(string name, DbConditionCompare compare, string value, int length)
{
this.AddCompareCriteria(name, compare, value, length, "AND");
}
public void AddCompareCriteria(string name, DbConditionCompare compare, string value)
{
this.AddCompareCriteria(name, compare, value, 0x7fffffff, "AND");
}
public void AddCompareCriteria <T>(string name, DbConditionCompare compare, T?value) where T : struct
{
this.AddCompareCriteria <T>(name, compare, value, "AND");
}
