public APIResult GetListForMe([FromBody] GetListForMeArgsModel args) { var memberId = GetMemberId(); var query = db.Query <ShopBooking>() .Where(m => !m.IsDel) .Where(m => m.MemberId == memberId); if (!string.IsNullOrEmpty(args.ShopFlag)) { query = query.Where(m => m.Shop.Flag == args.ShopFlag); } if (args.Status.HasValue) { query = query.Where(m => m.Status == args.Status.Value); } if (args.IsUsed.HasValue) { query = query.Where(m => m.IsUsed == args.IsUsed.Value); } var items = query .Select(m => new RowItem { AddTime = m.AddTime, DinnerTime = m.DinnerTime, IsUsed = m.IsUsed, Id = m.Id, Nickname = m.Nickname, Phone = m.Phone, RefuseReason = m.RefuseReason, Remark = m.Remark, Status = m.Status, Users = m.Users, ShopName = m.Shop.Name }) .ToList(); return(Success(new GetListForMeModel() { Items = items })); }
public APIResult GetListForMe([FromBody] GetListForMeArgsModel args) { var memberId = GetMemberId(); var query = db.Query <ShopCallingQueue>() .Where(m => !m.IsDel) .Where(m => m.MemberId == memberId); if (!string.IsNullOrEmpty(args.ShopFlag)) { query = query.Where(m => m.Shop.Flag == args.ShopFlag); } if (args.Status.HasValue) { query = query.Where(m => m.Status == args.Status.Value); } if (args.IsUsed.HasValue) { query = query.Where(m => m.IsUsed == args.IsUsed.Value); } var items = query .Select(m => new RowItem { AddTime = m.AddTime, IsUsed = m.IsUsed, Id = m.Id, RefuseReason = m.RefuseReason, Remark = m.Remark, Status = m.Status, ShopName = m.Shop.Name, CanShareTable = m.CanShareTable, QueueIndex = m.QueueIndex, QueueNumber = m.QueueNumber, Title = m.Title }) .ToList(); return(Success(new GetListForMeModel() { Items = items })); }
public APIResult GetListForMe([FromBody] GetListForMeArgsModel args) { var memberId = GetMemberId(); var query = db.Query <ShopOrder>() .Where(m => !m.IsDel) .Where(m => m.MemberId == memberId); if (args.orderType.Equals(OrderTypeF.外卖订单)) { query = query.Where(m => m.IsTakeOut); } else { query = query.Where(m => !m.IsTakeOut); } if (!string.IsNullOrEmpty(args.ShopFlag)) { query = query.Where(m => m.Shop.Flag == args.ShopFlag); } var items = query .OrderByDescending(m => m.Id) .Select(m => new RowItem { AddTime = m.AddTime, Id = m.Id, OrderNumber = m.OrderNumber, Phone = m.Phone, Remark = m.Remark, ShopName = m.Shop.Name, AddUser = m.AddUser, FinishTime = m.FinishTime, Flag = m.Flag, PayTime = m.PayTime, Payment = m.Payment, Amount = m.Amount, ShopPartId = m.ShopPartId, IsTakeOut = m.IsTakeOut, ShopPartTitle = m.ShopPart.Title, Cover = m.Shop.Cover, OrderStatus = ExOrderStatus.ExOrderStatusAction(m.Status), Status = m.Status, takeDistributionType = m.takeDistributionType }) .ToPagedList(args.PageIndex, args.PageSize); //获取订单状态 //items.ForEach(m => //{ // if (m.IsTakeOut) // m.OrderStatus = db.Query<ShopOrderTakeout>() // .Where(x => !x.IsDel && x.ShopOrderId == m.Id) // .FirstOrDefault()?.Status.ToString(); // else // m.OrderStatus = m.Status.ToString(); //}); return(Success(new GetListForMeModel() { Items = items })); }