Exemplo n.º 1
0
        public IEnumerable<Order> FindAllCustomersOrdersWithInOrderDateBy(Guid customerId, DateTime orderDate)
        {
            IEnumerable<Order> customerOrders = new List<Order>();

            Query query = new Query();
            query.Add(new Criterion("CustomerId", customerId, CriteriaOperator.Equal));
            query.QueryOperator = QueryOperator.And;
            query.Add(new Criterion("OrderDate", orderDate, CriteriaOperator.LessThanOrEqual));
            query.OrderByProperty = new OrderByClause("OrderDate", true);
            customerOrders = _orderRepository.FindBy(query);

            return customerOrders;
        }
Exemplo n.º 2
0
        public IEnumerable<Order> FindAllCustomersOrdersBy(Guid customerId)
        {
            IEnumerable<Order> customerOrders = new List<Order>();

            Query query = new Query();

            //字符串
            //query.Add(new Criterion("CustomerId", customerId, CriteriaOperator.Equal));

            //Lambda
            query.Add(Criterion.Createe<Order>(o => o.CustomerId, customerId, CriteriaOperator.Equal));

            query.OrderByProperty = new OrderByClause("CustomerId", true);

            customerOrders = _orderRepository.FindBy(query);

            return customerOrders;
        }