public void TestCondition()
{
var c = Conditions.ConditionGroup().Add(
Conditions.ConditionGroup().Add(Conditions.Eq("Name", "Phoenix")).
Add(Conditions.BetweenAnd("Coding", 10, 30))).
Add(Conditions.ConditionGroup(LogicalOperator.Or).Add(Conditions.Eq("Name", "Fox")).Add(
Conditions.In(LogicalOperator.And, true, "Name", "2", "3")).Add(Conditions.Like("Name", "PH")));
var hql = c.ToHql();
var query = sessionFactory.OpenSession().CreateQuery("From Code where " + c.ToHql());
Console.WriteLine(query.QueryString);
var ps = c.Parameters;
var ns = query.NamedParameters;
foreach (var p in ps)
{
Console.WriteLine(p);
}
Console.WriteLine("===================================");
foreach (var n in ns)
{
Console.WriteLine(n);
}
//for (int i = 0; i < ps.Length; i ++ )
//{
// var p = ps[i];
// if (p is IList)
// {
// query.SetParameterList(query.NamedParameters[i], p as IList);
// }
// else
// {
// query.SetParameter(query.NamedParameters[i], p);
// }
//}
//Console.WriteLine(query.List<Code>().Count);
}
public void ConditionTest()
{
var c = Conditions.ConditionGroup().Add(Conditions.ConditionGroup().Add(Conditions.Eq("Name", "Phoenix")).Add(Conditions.BetweenAnd("Age", 10, 30))).
Add(Conditions.ConditionGroup(LogicalOperator.Or).Add(Conditions.Eq("Name", "Fox")).Add(Conditions.In(LogicalOperator.And, true, "Depart.ID", 1, 2, 3, 4)));
Console.WriteLine(c.ToHql());
foreach (var o in c.Parameters)
{
Console.WriteLine(o);
}
}