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