protected void Search_Click(object sender, EventArgs e) { IDBCondition c1 = null; IDBCondition c2 = null; if (TitleFilter.Text.IsNotNull()) { c1 = new CompareCondition( new PropertyCondition("Title"), new ValueCondition("%" + TitleFilter.Text + "%"), COMPARE_KIND.LIKE); } if (ContentFilter.Text.IsNotNull()) { c2 = new CompareCondition( new PropertyCondition("Contents"), new ValueCondition("%" + ContentFilter.Text + "%"), COMPARE_KIND.LIKE); } if (c1 == null && c2 != null) { c1 = c2; c2 = null; } IDBCondition sc = c2 != null ? new AndCondtion(c1, c2) : c1; var news = ServerModel.DB.Query <TblNews>(sc); NewsSearchGrid.DataSource = news; NewsSearchGrid.DataBind(); NewsSearchGrid.Visible = true; }
//((DateSince IS NULL) OR (DateSince <= @TargetDate)) AND ((DateTill IS NULL) OR (DateTill >= @TargetDate)) public DateTimeBetweenCondition(IDBCondition <DateTime> operand, IDBCondition <DateTime> lowBound, IDBCondition <DateTime> hiBound) : base ( new OrCondtion( new IsNullCondition <DateTime>(lowBound), new CompareCondition <DateTime>(lowBound, operand, COMPARE_KIND.NOT_MORE) ), new OrCondtion( new IsNullCondition <DateTime>(hiBound), new CompareCondition <DateTime>(operand, hiBound, COMPARE_KIND.NOT_MORE) ) ) { }
public PropertyAssignement([NotNull] IDBPropertyCondition <TValue> prop, [NotNull] IDBCondition <TValue> value) { _Property = prop; _Value = value; }
public IsNotNullCondition(IDBCondition <TValue> value) { _Value = value; }
public InCondition(IDBCondition <TValue> arg, ISubSelectCondition subSelect, IN_CONDITION_KIND kind) { Arg = arg; SubSelect = subSelect; Kind = kind; }
public InCondition(IDBCondition <TValue> arg, ISubSelectCondition subSelect) : this(arg, subSelect, IN_CONDITION_KIND.IN) { }
public CompareCondition(IDBCondition <TComparisionType> a, IDBCondition <TComparisionType> b, COMPARE_KIND kind) { A = a; B = b; Kind = kind; }
public BetweenCondition(IDBCondition <TValue> operand, IDBCondition <TValue> lowBound, IDBCondition <TValue> hiBound) { _Operand = operand; _LowBound = lowBound; _HiBound = hiBound; }