Exemple #1
0
        //根据条件查询订单
        private Expression <Func <Bus_Payment_Order, bool> > SearchBusPaymentWhere(Bus_OrderIsPassSearchViewModel bus_OrderIsPassSearchViewModel)
        {
            var predicate = WhereExtension.True <Bus_Payment_Order>();//初始化where表达式

            if (bus_OrderIsPassSearchViewModel.User_InfoId != null)
            {
                predicate = predicate.And(a => a.createUser == bus_OrderIsPassSearchViewModel.User_InfoId);
            }
            predicate = predicate.And(a => a.paymentStatus != "0");
            //  predicate = predicate.And(a => a.Repair_Info.isEnd== bus_OrderIsPassSearchViewModel.isPass);
            predicate = predicate.And(a => a.isDelete == "0");
            return(predicate);
        }
Exemple #2
0
        public List <Bus_Payment_Order> SearchInfoByUserIdWhere(Bus_OrderIsPassSearchViewModel bus_OrderIsPassSearchViewModel)
        {
            int SkipNum = bus_OrderIsPassSearchViewModel.pageViewModel.CurrentPageNum * bus_OrderIsPassSearchViewModel.pageViewModel.PageSize;

            var predicate = SearchBusPaymentWhere(bus_OrderIsPassSearchViewModel);


            var result = DbSet.Where(predicate)
                         .OrderByDescending(o => o.AddDate)
                         .Skip(SkipNum)
                         .Take(bus_OrderIsPassSearchViewModel.pageViewModel.PageSize)
                         .ToList();

            return(result);
        }