Ejemplo n.º 1
0
        public static ExpressionStarter <ReturnOrder> GetPredicate(this QReturnOrder query)
        {
            var predicate = PredicateBuilder.New <ReturnOrder>(true);



            return(predicate);
        }
Ejemplo n.º 2
0
        public async Task <PagedResult <PTCStore.RanderModels.RReturnOrder> > ReturnOrders(PTCStore.QueryModels.QReturnOrder query, int page, int pageSize = 10)
        {
            var rs = _context.ReturnOrders.Where(query.GetPredicate()).Select(o => new RReturnOrder
            {
                ApplyNumber       = o.ApplyNumber,
                ReturnOrderId     = o.ReturnOrderId,
                ReturnDate        = o.ReturnDate,
                CustomerName      = o.Customer.Name,
                CustomerConnecter = o.Customer.Connecter,
                OrgPrice          = o.ReturnOrderSubs.Select(x => x.Barcode.Purchase.PurchasePrice / (x.Barcode.Purchase.Formate.DoTimes ? x.Barcode.Purchase.Formate.SetCount : 1)).Sum(),
                ReturnPrice       = o.ReturnOrderSubs.Select(r => r.ReturnPrice).Sum(),
                SalePrice         = o.ReturnOrderSubs.Select(r => r.SalePrice).Sum(),
                ItemCount         = o.ReturnOrderSubs.Count(),
            });


            return(await rs.GetPagedAsync(pageSize, page, query.Sort));
        }