/// <summary>
/// 測試AbstractWHEREStatement
/// </summary>
static void TestWHEREStatement()
{
IDataBase db = new MSSQLDataBase("User Id=bpi;Password=yuantacps;Data Source=TS03");
// 基本用法
AbstractWHEREStatement where = new AbstractWHEREStatement("TxDate", RelationEnum.Equal, new DateTime(2011, 3, 3));
string s = where.ToString(db);
Console.WriteLine(s);
where.AddCondition(ConditionEnum.AND,
"TID", RelationEnum.Equal, 1008);
where.AddCondition(ConditionEnum.AND,
"AID", RelationEnum.GreatThan, 104);
s = where.ToString(db);
Console.WriteLine(s);
// 組成between
where.Clear();
where.AddCondition("TxDate", RelationEnum.Equal, new DateTime(2012, 3, 3));
where.AddUnaryOperator(ConditionEnum.AND);
where.AddUnaryOperator(BraketEnum.OpenBraket);
where.AddCondition("TID", RelationEnum.Equal, 1008);
where.AddCondition(ConditionEnum.OR, "TID", RelationEnum.Equal, 1026);
where.AddUnaryOperator(BraketEnum.CloseBraket);
// order by
where.AddOrderBy("TxDate", SortEnum.DESC);
where.AddOrderBy("TID", SortEnum.ASC);
s = where.ToString(db);
Console.WriteLine(s);
// 在AbstractWHEREStatement中再加入其它AbstractWHEREStatement
AbstractWHEREStatement whereOut = new AbstractWHEREStatement();
whereOut.AddCondition(where);
s = whereOut.ToString(db);
Console.WriteLine(s);
}
