ordersstore.cs

简单的cI真的是很简单 你想要就下载吧

        }
        #endregion
        /// <summary>
        /// Query CreateOrders Top Five's Information
        /// </summary>
        /// <param name="employeeID"></param>
        /// <returns></returns>       
        public OrdersCollection GetCreateOrderList(int employeeID)
        {
            OrdersCollection createOrderList = new OrdersCollection();
            IEnumerable<Orders> createOrders = (from Order in this._ordersDataContext.Orders
                                                where Order.EmployeeID == employeeID
                                                orderby Order.OrderDate descending
                                                select Order).Skip<Orders>(0).Take<Orders>(5);
            foreach (Orders Order in createOrders)
            {
                createOrderList.Add(this.OrdersObjectToEntity(Order));
            }
            return createOrderList;

        }
        public OrdersCollection GetStorehouseOrdersList(int _orgID)  //By Abel
        {
            OrdersCollection storeHouseOrdersList = new OrdersCollection();
            IEnumerable<Orders> storeHouseOrders = from Order in this._ordersDataContext.Orders
                                                   where Order.OrderCreaterID != null && Order.StorehouseAccepterID == null && Order.OrgID == _orgID
                                                   orderby Order.StorehouseReadyDate descending
                                                   select Order;
            foreach (Orders storeHouseOrder in storeHouseOrders)
            {
                storeHouseOrdersList.Add(this.OrdersObjectToEntity(storeHouseOrder));
            }
            return storeHouseOrdersList;
        }
        public OrdersCollection GetTransportOrdersInfo(int _orgID)  //By Abel
        {
            OrdersCollection _ordersCollection = new OrdersCollection();
            IEnumerable<Orders> _transportOrders = from Order in this._ordersDataContext.Orders
                                                   where Order.TransportOrderID == null && Order.StorehouseAccepterID != null && Order.OrgID == _orgID
                                                   orderby Order.TransportDate descending
                                                   select Order;
            foreach (Orders transportOrders in _transportOrders)
            {
                _ordersCollection.Add(this.OrdersObjectToEntity(transportOrders));
            }
            return _ordersCollection;

        }
        /// <summary>
        ///  Return Current Surely Orders
        /// </summary>
        /// <returns></returns>
        public OrdersCollection GetCurrentSurelyOrders(int _orgID)  //By Abel
        {
            OrdersCollection currentSurelyOrders = new OrdersCollection();
            IEnumerable<Orders> currentOrders = from order in this._ordersDataContext.Orders
                                                where order.ReceiveInfoInputerID == null && order.TransportInfoInputerID != null && order.OrgID == _orgID
                                                orderby order.OrderID
                                                select order;
            foreach (Orders order in currentOrders)
            {
                currentSurelyOrders.Add(this.OrdersObjectToEntity(order));
            }
            return currentSurelyOrders;
        }
        /// <summary>
        /// Return need close orders
        /// </summary>
        /// <returns></returns>
        public OrdersCollection GetNeedCloseOrder(int orderID)
        {
            OrdersCollection createOrderList = new OrdersCollection();
            IEnumerable<Orders> orderData = from Order in this._ordersDataContext.Orders
                                            where Order.OrderCloseAccepterID == null
                                           && Order.ReceiveInfoInputerID != null
                                            orderby Order.OrderID
                                            select Order;
            foreach (Orders Order in orderData)
            {
                createOrderList.Add(this.OrdersObjectToEntity(Order));
            }
            return createOrderList;
        }
        /// <summary>
        /// Query AllowOrders Top Five's Information
        /// </summary>
        /// <param name="employeeID"></param>
        /// <returns></returns>
        public OrdersCollection GetAllowOrderList()
        {
            OrdersCollection allowOrderList = new OrdersCollection();
            IEnumerable<Orders> allowOrders = (from Order in this._ordersDataContext.Orders
                                               where Order.OrderCreaterID != null && Order.StorehouseAccepterID == null
                                               orderby Order.OrderDate descending
                                               select Order).Skip<Orders>(0).Take<Orders>(5);
            foreach (Orders Order in allowOrders)
            {
                allowOrderList.Add(this.OrdersObjectToEntity(Order));
            }
            return allowOrderList;
        }
        /// <summary>
        /// Query OutOrders Top Five's Information
        /// </summary>
        /// <param name="employeeID"></param>
        /// <returns></returns>
        public OrdersCollection GetOutOrderList()
        {
            OrdersCollection outOrderList = new OrdersCollection();
            IEnumerable<Orders> outOrders = (from Order in this._ordersDataContext.Orders
                                             where Order.TransportInfoInputerID == null && Order.StorehouseAccepterID != null
                                             orderby Order.StorehouseReadyDate descending
                                             select Order).Skip<Orders>(0).Take<Orders>(5);
            foreach (Orders Order in outOrders)
            {
                outOrderList.Add(this.OrdersObjectToEntity(Order));
            }
            return outOrderList;


        }
        /// <summary>
        /// Query ConfirmOrders Top Five's Information
        /// </summary>
        /// <param name="employeeID"></param>
        /// <returns></returns>
        public OrdersCollection GetConfirmOrderList()
        {
            OrdersCollection confirmOrderList = new OrdersCollection();
            IEnumerable<Orders> confirmOrders = (from Order in this._ordersDataContext.Orders
                                                 where Order.ReceiveInfoInputerID == null && Order.TransportInfoInputerID != null
                                                 orderby Order.ArrivalDate descending
                                                 select Order).Skip<Orders>(0).Take<Orders>(5);
            foreach (Orders Order in confirmOrders)
            {
                confirmOrderList.Add(this.OrdersObjectToEntity(Order));
            }
            return confirmOrderList;


        }
        /// <summary>
        /// Query CloseOrders Top Five's Information
        /// </summary>
        /// <param name="employeeID"></param>
        /// <returns></returns>
        public OrdersCollection GetCloseOrderList()
        {
            OrdersCollection closeOrderList = new OrdersCollection();
            IEnumerable<Orders> closeOrders = (from Order in this._ordersDataContext.Orders
                                               where Order.ReceiveInfoInputerID != null && Order.OrderCloseAccepterID == null
                                               select Order).Skip<Orders>(0).Take<Orders>(5);
            foreach (Orders Order in closeOrders)
            {
                closeOrderList.Add(this.OrdersObjectToEntity(Order));
            }
            return closeOrderList;

        }
        #region//待备贷订单一览画面用到方法







        //得到所有待备贷订单信息
        public OrdersCollection GetStorehouseOrdersList()
        {
            OrdersCollection storeHouseOrdersList = new OrdersCollection();
            IEnumerable<Orders> storeHouseOrders = from Order in this._ordersDataContext.Orders
                                                   where Order.OrderCreaterID != null && Order.StorehouseAccepterID == null
                                                   orderby Order.OrderCreaterID descending
                                                   select Order;
            foreach (Orders storeHouseOrder in storeHouseOrders)
            {
                storeHouseOrdersList.Add(this.OrdersObjectToEntity(storeHouseOrder));
            }
            return storeHouseOrdersList;
        }
        //得到前5条待备贷订单信息
        public OrdersCollection GetTopFiveStorehouseOrdersList()
        {
            OrdersCollection storehouseOrdersList = new OrdersCollection();
            IEnumerable<Orders> storeHouseOrders = (from Order in this._ordersDataContext.Orders
                                                    where Order.OrderCreaterID != null && Order.StorehouseAccepterID == null
                                                    orderby Order.StorehouseReadyDate descending
                                                    select Order).Skip<Orders>(0).Take<Orders>(5);
            foreach (Orders storeHouseOrder in storeHouseOrders)
            {
                storehouseOrdersList.Add(this.OrdersObjectToEntity(storeHouseOrder));
            }
            return storehouseOrdersList;
        }
        #endregion
        public int sums(int monthName, int yearName)
        {
            var mp = from O in _ordersDataContext.Orders
                     join OD in _ordersDataContext.Order_Details
                     on O.OrderID equals OD.OrderID
                     where Convert.ToDateTime(O.OrderCloseDate).Month == monthName && Convert.ToDateTime(O.OrderCloseDate).Year == yearName
                     select new { Monthprice = OD.Quantity * OD.UnitPrice };
            int i = 0;
            int getNumber;
            foreach (var m in mp)
            {

                getNumber = Convert.ToInt32(m.Monthprice);
                i += getNumber;

            }
            return i;
        }
        /// <summary>
        /// Search the Orders Method
        /// </summary>
        /// <param name="sqlStr"></param>
        /// <returns></returns>
        public OrdersCollection SearchOrders(string sqlStr)
        {
            OrdersCollection _orderCollection = new OrdersCollection();
            IEnumerable<Orders> _orderList = _ordersDataContext.ExecuteQuery<Orders>(sqlStr);
            foreach (Orders order in _orderList)
            {
                _orderCollection.Add(this.OrdersObjectToEntity(order));
            }
            return _orderCollection;
        }
        /// <summary>
        /// 根据EmployeeID值查出相应的Order订单
        /// </summary>
        /// <param name="employeesIDList"></param>
        /// <returns></returns>
        public OrdersCollection GetOrdersInfoByEmployeeID(int[] employeesIDList)
        {
            for (int i = 0; i < employeesIDList.Length; i++)
            {
                IEnumerable<Orders> orders = from order in this._ordersDataContext.Orders
                                             where order.EmployeeID == Convert.ToInt32(employeesIDList[i])
                                             select order;
                foreach (Orders order in orders)
                {
                    staticOrdersList.Add(this.OrdersObjectToEntity(order));
                }
            }
            return staticOrdersList;
        }

        #region   Chark 返回Order表最大的OrderID
        public int getOrderID()
        {
            var _OrderID = _ordersDataContext.Orders.Select(p => p.OrderID).Max();
            int ordID = (int)_OrderID;
            return ordID;
        }
        #endregion
    }
}