Example #1
0
        public ActionResult Desk_EditData(DXInfo.Models.Desks desk)
        {
            var gridModel = new DeskGridModel();

            SetupDeskGridModel(gridModel);
            return(ajaxCallBack <DXInfo.Models.Desks>(gridModel.DeskGrid, desk, addDesk, editDesk, delDesk));
        }
Example #2
0
        private void delDesk(DXInfo.Models.Desks desk)
        {
            var oldDesk = Uow.Desks.GetById(g => g.Id == desk.Id);

            if (oldDesk != null)
            {
                Uow.Desks.Delete(oldDesk);
                Uow.Commit();
            }
        }
Example #3
0
        private void addDesk(DXInfo.Models.Desks desk)
        {
            var d = Uow.Desks.GetAll().Where(w => w.Code == desk.Code);

            if (d.Count() > 0)
            {
                throw new DXInfo.Models.BusinessException("桌号不能重复");
            }
            Uow.Desks.Add(desk);
            Uow.Commit();
        }
Example #4
0
        private void editDesk(DXInfo.Models.Desks desk)
        {
            var oldDesk = Uow.Desks.GetById(g => g.Id == desk.Id);

            oldDesk.Comment = desk.Comment;
            oldDesk.Code    = desk.Code;
            oldDesk.Name    = desk.Name;
            oldDesk.Status  = desk.Status;
            oldDesk.Size    = desk.Size;
            Uow.Desks.Update(oldDesk);
            Uow.Commit();
        }
Example #5
0
        private List <DXInfo.Models.OrderDishes> getOrder(string deskNo, DateTime beginDate, DateTime endDate)
        {
            //DXInfo.Models.FairiesMemberManage db = new DXInfo.Models.FairiesMemberManage();
            DXInfo.Models.Desks desk = uow.Desks.GetAll().Where(w => w.Code == deskNo).FirstOrDefault();
            if (desk == null)
            {
                MessageBox.Show("未找到桌台");
                return(new List <DXInfo.Models.OrderDishes>());
            }

            var q = (from d in uow.OrderDeskes.GetAll()
                     join o in uow.OrderDishes.GetAll() on d.OrderId equals o.Id
                     where d.DeskId == desk.Id && o.CreateDate >= beginDate && o.CreateDate <= endDate
                     select o).Distinct().ToList();

            return(q);
        }
Example #6
0
        public OrderInfo GetOrder(string userName, string passwd, string deskNo)
        {
            OrderInfo orderInfo = new OrderInfo();

            if (!LogOn(userName, passwd))
            {
                return(null);
            }
            DXInfo.Models.aspnet_Users user = (from d in uow.aspnet_Users.GetAll() where d.UserName == userName select d).FirstOrDefault();
            if (user == null)
            {
                throw new WebFaultException <string>("无“" + userName + "”操作员信息", HttpStatusCode.MethodNotAllowed);
            }
            orderInfo.OrderDesk.UserId = user.UserId;
            DXInfo.Models.aspnet_CustomProfile userProfile = uow.aspnet_CustomProfile.GetById(g => g.UserId == user.UserId);
            if (userProfile == null)
            {
                throw new WebFaultException <string>("无“" + userName + "”操作员信息", HttpStatusCode.MethodNotAllowed);
            }
            orderInfo.OrderDesk.UserName = user.UserName;
            orderInfo.OrderDesk.FullName = userProfile.FullName;
            //判断桌台是否可用
            DXInfo.Models.Desks curdesk = uow.Desks.GetAll().Where(w => w.Code == deskNo).FirstOrDefault();
            if (curdesk == null)
            {
                //throw new Exception("桌台错误");
                throw new WebFaultException <string>(deskNo + "无此桌台", HttpStatusCode.MethodNotAllowed);
            }
            if (curdesk.Status != 1)
            {
                //throw new Exception("桌台不在用");
                throw new WebFaultException <string>(deskNo + "不在用", HttpStatusCode.MethodNotAllowed);
            }
            orderInfo.OrderDesk.DeskId = curdesk.Id;
            orderInfo.OrderDesk.DeskNo = deskNo;

            //判断桌台是否使用
            DXInfo.Models.OrderDeskes od = (from d in uow.OrderDeskes.GetAll() where d.DeskId == curdesk.Id && d.Status == 0 select d).FirstOrDefault();
            if (od == null)
            {
                //throw new Exception("订单错误");
                throw new WebFaultException <string>(deskNo + "未开台", HttpStatusCode.MethodNotAllowed);
            }
            orderInfo.OrderDesk.OrderDeskId = od.Id;

            DXInfo.Models.OrderDishes orderDish = (from d in uow.OrderDishes.GetAll() where d.Id == od.OrderId select d).FirstOrDefault();
            if (orderDish == null)
            {
                throw new WebFaultException <string>("无此订单", HttpStatusCode.MethodNotAllowed);
            }
            if (!(orderDish.Status == 0 || orderDish.Status == 3))
            {
                throw new WebFaultException <string>("已结账或已撤销", HttpStatusCode.MethodNotAllowed);
            }
            orderInfo.OrderDesk.OrderDishId = orderDish.Id;

            var q = from d in uow.OrderMenus.GetAll()
                    where d.OrderId == od.OrderId && !(d.Status == 1 || d.Status == 7)
                    join i in uow.Inventory.GetAll() on d.InventoryId equals i.Id into di
                    from dis in di.DefaultIfEmpty()

                    join p in uow.OrderPackages.GetAll() on d.PackageId equals p.Id into dp
                    from dps in dp.DefaultIfEmpty()
                    orderby d.Id
                    select new OrderMenuInfo()
            {
                OrderMenuId = d.Id,
                InvId       = d.InventoryId,
                InvCode     = dis.Code,
                InvName     = dis.Name,
                Amount      = d.Amount,
                Quantity    = d.Quantity,
                SalePrice   = d.Price,
                EnglishName = dis.EnglishName,
                Comment     = d.Comment,
                IsAdd       = false,
                IsDelete    = false,
                IsPackage   = d.IsPackage,
                PackageId   = d.PackageId,
                PackageSn   = d.PackageSn,
                Status      = d.Status,
            };

            orderInfo.lOrderMenu = q.ToList();

            List <DXInfo.Models.MenuStatus> lLackMenu = (from d in uow.MenuStatus.GetAll()
                                                         where d.Dept == localDeptId &&
                                                         d.Status == (int)DXInfo.Models.OrderMenuStatus.Lack
                                                         select d).ToList();

            orderInfo.lLackMenu = lLackMenu;

            return(orderInfo);
        }
Example #7
0
        public OrderInfo OpenBookDesk(string userName, string passwd, int quantity,
                                      OrderBookDeskInfo orderBookDesk)
        {
            if (quantity == 0)
            {
                throw new WebFaultException <string>("请输入人数", HttpStatusCode.MethodNotAllowed);
            }
            if (!LogOn(userName, passwd))
            {
                return(null);
            }

            DXInfo.Models.aspnet_Users user = uow.aspnet_Users.GetAll().Where(w => w.UserName == userName).FirstOrDefault();
            if (user == null)
            {
                throw new WebFaultException <string>("无“" + userName + "”操作员信息", HttpStatusCode.MethodNotAllowed);
            }
            Guid userId = user.UserId;

            DXInfo.Models.aspnet_CustomProfile userProfile = uow.aspnet_CustomProfile.GetById(g => g.UserId == userId);
            if (userProfile == null)
            {
                throw new WebFaultException <string>("无“" + userName + "”操作员信息", HttpStatusCode.MethodNotAllowed);
            }
            //判断桌台是否可用
            DXInfo.Models.Desks curdesk = uow.Desks.GetAll().Where(w => w.Id == orderBookDesk.DeskId &&
                                                                   w.Status == (int)DXInfo.Models.DeskStatus.InUse).FirstOrDefault();
            if (curdesk == null)
            {
                throw new WebFaultException <string>("桌台不可用", HttpStatusCode.MethodNotAllowed);
            }
            if (localDeptId == Guid.Empty)
            {
                throw new WebFaultException <string>("未获得本地部门信息", HttpStatusCode.MethodNotAllowed);
            }

            DXInfo.Restaurant.DeskManageFacade dmf = new DXInfo.Restaurant.DeskManageFacade(uow, localDeptId, userId);
            DateTime dtOperDate = DateTime.Now;

            dmf.dtOperDate = dtOperDate;
            DXInfo.Models.OrderDishes orderDish = new Models.OrderDishes();
            DXInfo.Models.OrderDeskes orderDesk = new Models.OrderDeskes();
            OrderInfo oi = new OrderInfo();

            try
            {
                dmf.OpenBook(orderBookDesk.OrderBookId, orderBookDesk.DeskId, quantity, true, ref orderDish, ref orderDesk);
                oi.OrderDesk.OrderDishId = orderDish.Id;
                oi.OrderDesk.OrderDeskId = orderDesk.Id;
                oi.OrderDesk.DeskNo      = orderBookDesk.DeskNo;
                oi.OrderDesk.DeskId      = orderBookDesk.DeskId;
                oi.OrderDesk.UserId      = userId;
                oi.OrderDesk.UserName    = userName;
                oi.OrderDesk.FullName    = userProfile.FullName;
                List <DXInfo.Models.MenuStatus> lLackMenu = (from d in uow.MenuStatus.GetAll()
                                                             where d.Dept == localDeptId &&
                                                             d.Status == (int)DXInfo.Models.OrderMenuStatus.Lack
                                                             select d).ToList();
                oi.lLackMenu = lLackMenu;
            }
            catch (Exception ex)
            {
                throw new WebFaultException <string>(ex.Message, HttpStatusCode.MethodNotAllowed);
            }
            return(oi);
        }