public DbCriteria Add(string table, string fieldname, DbSelectStatement select_clause, DbExpression.SqlCondition condition, ConcatMode mode) { if (mode == ConcatMode.AND) { And(CreateExpression(table, fieldname, select_clause, condition)); } else if (mode == ConcatMode.OR) { Or(CreateExpression(table, fieldname, select_clause, condition)); } return(this); }
public DbExpression(DbColumn column, DbSelectStatement select_clause, SqlCondition condition) { mColumn = column; mFieldvalue = select_clause; mCondition = condition; this[SqlCondition.IsEqual] = "="; this[SqlCondition.IsLessEqual] = "<="; this[SqlCondition.IsGreaterEqual] = ">="; this[SqlCondition.IsLess] = "<"; this[SqlCondition.IsGreater] = ">"; this[SqlCondition.Like] = "LIKE"; }
public virtual DbExpression CreateExpression(string table, string fieldname, DbSelectStatement select_clause, DbExpression.SqlCondition condition) { return(DbMgr.CreateExpression(DbMgr.CreateColumn(table, fieldname), select_clause, condition)); }
public DbCriteria IsEqual(string table, string fieldname, DbSelectStatement select_clause) { return(Add(table, fieldname, select_clause, DbExpression.SqlCondition.IsEqual, ConcatMode.AND)); }