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"); }