//---------------------------------------------------------------------
        #endregion

        #region --------------ChangeOrderStatus--------------
        //---------------------------------------------------------------------
        //ChangeOrderStatus
        //---------------------------------------------------------------------
        public bool ChangeOrderStatus(int orderID, EnumOrderStatus orderStatusID, float totalPaied, string adminNote)
        {
            bool savestats = false;

            try
            {
                //[dbo].[Order_ChangeOrderStatus]
                string sp = "[dbo].[Order_ChangeOrderStatus]";
                CustomDbParameterList customParameters = new CustomDbParameterList();
                //----------------------------------------------------------------
                customParameters.Add("@OrderID", orderID);
                customParameters.Add("@OrderStatusID", orderStatusID);
                customParameters.Add("@TotalPaied", totalPaied);
                customParameters.Add("@AdminNote", adminNote);
                //----------------------------------------------------------------
                SqlDataHelper.ExecuteStoredProcedure(sp, customParameters);
                //----------------------------------------------------------------
                savestats = true;
            }
            catch (Exception ex)
            {
                savestats = false;
            }
            return(savestats);
        }
Exemple #2
0
        public List <AgentOrderEntity> GetAgentOrders(string searchagentid, EnumOrderStatus status, EnumSendStatus sendstatus, EnumReturnStatus returnstatus, string keywords, string begintime, string endtime, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string agentid, string clientid)
        {
            DataSet ds = AgentOrderDAL.BaseProvider.GetAgentOrders(searchagentid, (int)status, (int)sendstatus, (int)returnstatus, keywords, begintime, endtime, pageSize, pageIndex, ref totalCount, ref pageCount, agentid, clientid);

            List <AgentOrderEntity> list = new List <AgentOrderEntity>();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                AgentOrderEntity model = new AgentOrderEntity();
                model.FillData(dr);

                model.StatusStr = CommonBusiness.GetEnumDesc((EnumOrderStatus)model.Status);

                model.SendStatusStr = CommonBusiness.GetEnumDesc((EnumSendStatus)model.SendStatus);

                model.ExpressTypeStr = CommonBusiness.GetEnumDesc((EnumExpressType)model.ExpressType);

                if (!string.IsNullOrEmpty(model.ExpressID))
                {
                    model.ExpressCompany = Manage.ExpressCompanyBusiness.GetExpressCompanyDetail(model.ExpressID);
                }

                model.City = CommonBusiness.GetCityByCode(model.CityCode);
                if (model.City != null)
                {
                    model.Address = model.City.Province + model.City.City + model.City.Counties + model.Address;
                }

                list.Add(model);
            }
            return(list);
        }
        public List<AgentOrderEntity> GetAgentOrders(string searchagentid, EnumOrderStatus status, EnumOutStatus outStatus, EnumSendStatus sendstatus, EnumReturnStatus returnstatus, string keywords, string begintime, string endtime, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string agentid, string clientid)
        {
            DataSet ds = AgentOrderDAL.BaseProvider.GetAgentOrders(searchagentid, (int)status, (int)outStatus, (int)sendstatus, (int)returnstatus, keywords, begintime, endtime, pageSize, pageIndex, ref totalCount, ref pageCount, agentid, clientid);

            List<AgentOrderEntity> list = new List<AgentOrderEntity>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                AgentOrderEntity model = new AgentOrderEntity();
                model.FillData(dr);

                model.StatusStr = CommonBusiness.GetEnumDesc((EnumOrderStatus)model.Status);

                model.SendStatusStr = CommonBusiness.GetEnumDesc((EnumSendStatus)model.SendStatus);

                model.ExpressTypeStr = CommonBusiness.GetEnumDesc((EnumExpressType)model.ExpressType);

                if(!string.IsNullOrEmpty(model.ExpressID))
                {
                    model.ExpressCompany = Manage.ExpressCompanyBusiness.GetExpressCompanyDetail(model.ExpressID);
                }

                model.City = CommonBusiness.GetCityByCode(model.CityCode);
                if (model.City != null) 
                {
                    model.Address = model.City.Province + model.City.City + model.City.Counties + model.Address;
                }

                list.Add(model);
            }
            return list;
        }
Exemple #4
0
 /// <summary>
 /// Hủy Order
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnCancel_Click(object sender, EventArgs e)
 {
     try
     {
         if (oBL.CheckSendKitchenOrder(OrderID))
         {
             MessageBoxCommon.ShowExclamation("Order đã gửi bếp không thể hủy");
             return;
         }
         int    result            = 1;
         string cancelDescription = "";
         {
             if (MessageBoxCommon.ShowYesNoQuestion_Cancel(EnumCancelAction.Booking, out cancelDescription) == DialogResult.Yes)
             {
                 DictionaryDataSet.OrderRow drObjectChange = (DictionaryDataSet.OrderRow)ShareDictionary.DsDictionary.Order.FindByOrderID(OrderID);
                 if (drObjectChange != null)
                 {
                     drObjectChange.CancelReason     = cancelDescription;
                     drObjectChange.CancelEmployeeID = Session.UserLogin.EmployeeID;
                     drObjectChange.OrderStatus      = (int)EnumOrderStatus.Cancel;
                     result = oBL.InsertUpdateObject(QuizBit.Contract.CommonFunction.GetItem <Order>(drObjectChange));
                     if (result > 0)
                     {
                         OrderStatus = EnumOrderStatus.Cancel;
                     }
                 }
             }
         }
     }
     catch (Exception ex)
     {
         MessageBoxCommon.ShowException(ex);
     }
 }
Exemple #5
0
 /// <summary>
 /// Yêu cầu thanh toán
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnPayment_Click(object sender, EventArgs e)
 {
     try
     {
         if (!oBL.CheckSendKitchenOrder(OrderID))
         {
             MessageBoxCommon.ShowExclamation("Order chưa được phục vụ món ăn nào nên không thể thanh toán");
             return;
         }
         using (var frm = new FrmInvoice())
         {
             frm.FormActionMode = ActionMode.AddNew;
             frm.OrderID        = OrderID;
             frm.SAInvoiceID    = OrderID;
             if (frm.ShowDialog() == DialogResult.OK)
             {
                 this.OrderStatus = EnumOrderStatus.Done;
                 this.OnClick(e);
             }
         }
     }
     catch (Exception ex)
     {
         MessageBoxCommon.ShowException(ex);
     }
 }
        protected override void Seed(IEP.Data.dbContextManager.ApplicationDbContext context)
        {
            //  This method will be called after migrating to the latest version.

            //  You can use the DbSet<T>.AddOrUpdate() helper extension method
            //  to avoid creating duplicate seed data.
            //context.Set<Order>().AddOrUpdate(new Order() { Price = 200, OrderStatusId = 1 });

            if (!context.Set <AuctionStatus>().Any())
            {
                foreach (EnAuctionStatuses EnAuctionStatus in Enum.GetValues(typeof(EnAuctionStatuses)))
                {
                    context.Set <AuctionStatus>().AddOrUpdate(new AuctionStatus()
                    {
                        Id = (int)EnAuctionStatus, Name = EnAuctionStatus.ToString()
                    });
                }
            }
            if (!context.Set <OrderStatus>().Any())
            {
                foreach (EnumOrderStatuses EnumOrderStatus in Enum.GetValues(typeof(EnumOrderStatuses)))
                {
                    context.Set <OrderStatus>().AddOrUpdate(new OrderStatus()
                    {
                        Id = (int)EnumOrderStatus, Name = EnumOrderStatus.ToString()
                    });
                }
            }

            if (!context.Set <Currency>().Any())
            {
                context.Set <Currency>().AddOrUpdate(new Currency()
                {
                    Id = 1, Name = "RSD"
                });
                context.Set <Currency>().AddOrUpdate(new Currency()
                {
                    Id = 2, Name = "USD"
                });
                context.Set <Currency>().AddOrUpdate(new Currency()
                {
                    Id = 3, Name = "EUR"
                });
            }

            if (!context.Set <ApplicationSettings>().Any())
            {
                context.Set <ApplicationSettings>().AddOrUpdate(new ApplicationSettings()
                {
                    Id = Guid.NewGuid().ToString(), AuctionItems = 10, AuctionDuration = 36000, SilverPackageTokens = 100, GoldPackageTokens = 200, PlatinumPackageTokens = 200, TokenValue = 1, CurrencyId = 1
                });
            }
        }
Exemple #7
0
 public void ChangeStatus(EnumOrderStatus status)
 {
     if (this.OrderStatus != status)
     {
         var s = this.OrderStatus;
         this.OrderStatus = status;
         //引发订单状态改变的事件
         DomainEvents.Raise(new OrderStatusChangedEvent()
         {
             Order = this, OldStatus = s, NewStatus = status
         });
     }
 }
Exemple #8
0
        /// <summary>
        /// 修改订单状态
        /// 新建的
        /// 已付款
        /// 送货中
        /// 已收货
        /// 已取消
        /// 已完成
        /// <param name="orderId"></param>
        /// <param name="orderStatus"></param>
        /// <returns></returns>
        public bool UpdataOrderByOrderId(int orderId, EnumOrderStatus orderStatus)
        {
            OrderEntity OE = _OrderService.GetOrderById(orderId);

            OE.Status = orderStatus;
            try
            {
                _OrderService.Update(OE);
                return(true);
            }
            catch (Exception e)
            {
                return(false);
            }
        }
Exemple #9
0
        public string GetStatusDescByStatus(EnumOrderStatus status)
        {
            switch (status)
            {
            case EnumOrderStatus.PendingPay:
                return("待付款");

            case EnumOrderStatus.Pending:
                return("待审核");

            case EnumOrderStatus.PendingService:
                return("待服务");

            case EnumOrderStatus.Stocking:
                return("备货中");

            case EnumOrderStatus.PendingDelivery:
                return("待发货");

            case EnumOrderStatus.PendingShip:
                return("待发货");

            case EnumOrderStatus.Serviced:
                return("已服务");

            case EnumOrderStatus.Picked:
                return("已提货");

            case EnumOrderStatus.Shipped:
                return("已发货");

            case EnumOrderStatus.Done:
                return("交易完成");

            case EnumOrderStatus.Refunding:
                return("退款中");

            case EnumOrderStatus.RefundDone:
                return("退款完成");

            default:
                return("错误");
            }
        }
Exemple #10
0
 public OrderStateAttribute(EnumOrderStatus orderState)
 {
     this.OrderState = orderState;
 }
Exemple #11
0
 /// <summary>
 /// �޸Ķ���״̬
 /// �½���
 /// �Ѹ���
 /// �ͻ���
 /// ���ջ�
 /// ��ȡ��
 /// �����
 /// <param name="orderId"></param>
 /// <param name="orderStatus"></param>
 /// <returns></returns>
 public bool UpdataOrderByOrderId(int orderId, EnumOrderStatus orderStatus)
 {
     OrderEntity OE=_OrderService.GetOrderById(orderId);
     OE.Status = orderStatus;
     try
     {
         _OrderService.Update(OE);
         return true;
     }
     catch (Exception e)
     {
         return false;
     }
 }
Exemple #12
0
 public HttpResponseMessage GetCount(int? page = 1,
     int? pageCount = 10,
     string ids = "",
     bool isDescending = false,
     string orderNum = "",
     EnumOrderStatus? status = null,
     string deliveryAddress = "",
     bool? isPrint = null,
     string phoneNumber = "",
     EnumOrderType? type = null,
     EnumPayType? payType = null,
     decimal? locationX = null,
     decimal? locationY = null,
     DateTime? addTimeBegin = null,
     DateTime? addTimeEnd = null,
     EnumOrderSearchOrderBy orderBy = EnumOrderSearchOrderBy.OrderById)
 {
     var condition = new OrderSearchCondition
     {
         AddTimeBegin = addTimeBegin,
         AddTimeEnd = addTimeEnd,
         DeliveryAddress = deliveryAddress,
         Ids = string.IsNullOrEmpty(ids) ? null : ids.Split(',').Select(int.Parse).ToArray(),
         IsDescending = isDescending,
         IsPrint = isPrint,
         LocationX = locationX,
         LocationY = locationY,
         OrderBy = orderBy,
         OrderNum = orderNum,
         Page = page,
         PageCount = pageCount,
         PayType = payType,
         PhoneNumber = phoneNumber,
         Type = type,
         Status = status
     };
     var count = _OrderService.GetOrderCount(condition);
     return PageHelper.toJson(new { TotalCount = count, Condition = condition });
 }
Exemple #13
0
        public HttpResponseMessage GetByCondition(int? page = 1,
                                                    int? pageCount = 10,
                                                    string ids ="",
                                                    bool isDescending = false,
                                                    string orderNum = "",
                                                    EnumOrderStatus? status = null,
                                                    string deliveryAddress = "",
                                                    bool? isPrint = null,
                                                    string phoneNumber = "",
                                                    EnumOrderType? type = null,
                                                    EnumPayType? payType = null,
                                                    decimal? locationX = null,
                                                    decimal? locationY = null,
                                                    DateTime? addTimeBegin = null,
                                                    DateTime? addTimeEnd = null,
                                                    EnumOrderSearchOrderBy orderBy = EnumOrderSearchOrderBy.OrderById)
        {
            var condition = new OrderSearchCondition
            {
                AddTimeBegin = addTimeBegin,
                AddTimeEnd = addTimeEnd,
                DeliveryAddress = deliveryAddress,
                Ids = string.IsNullOrEmpty(ids)?null:ids.Split(',').Select(int.Parse).ToArray(),
                IsDescending = isDescending,
                IsPrint = isPrint,
                LocationX = locationX,
                LocationY = locationY,
                OrderBy = orderBy,
                OrderNum = orderNum,
                Page = page,
                PageCount = pageCount,
                PayType = payType,
                PhoneNumber = phoneNumber,
                Type = type,
                Status = status
            };
            var model = _OrderService.GetOrdersByCondition(condition).Select(c => new OrderModel
            {

                Id = c.Id,

                OrderNum = c.OrderNum,

                TotalPrice = c.TotalPrice,

                TransCost = c.TransCost,

                ProductCost = c.ProductCost,

                Discount = c.Discount,

                Status = c.Status,

                DeliveryAddress = c.DeliveryAddress,

                IsPrint = c.IsPrint,

                PhoneNumber = c.PhoneNumber,

                Adduser = new UserModel{Id = c.Adduser.Id,UserName = c.Adduser.UserName},

                Addtime = c.Addtime,

                Upduser = new UserModel { Id = c.Upduser.Id, UserName = c.Upduser.UserName },

                Updtime = c.Updtime,

                //				Details = c.Details,

                //				Coupon = c.Coupon,

                Type = c.Type,

                PayType = c.PayType,

                LocationX = c.LocationX,

                LocationY = c.LocationY,
                Details = c.Details.Select(d => new OrderDetailModel()
                {
                    Count = d.Count,
                    Id = d.Id,
                    ProductId = d.Product.Id,
                    ProductName = d.Product.Name,
                    TotalPrice = d.TotalPrice,
                    UnitPrice = d.Product.Price,
                    Remark=d.Remark
                }).ToList()

            }).ToList();
            return PageHelper.toJson(new { List = model });
        }