session.createQuery("select new list(o.customer.name,o.tradeDate,o.status,o.amount) "
+ "from Order o where o.tradeDate between '"+from+"' and '"+to+"' and o.status='已付款' or o.status='已发货' "
+ "and o.amount>1000 order by o.status asc,o.tradeDate desc,o.amount desc");
