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