ordersstore.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using VinciDataAccess.Linq;
using VinciDataAccess.Entity;
using System.Collections;


namespace VinciDataAccess.DataAccess
{
    public class OrdersStore
    {
        ProductsDataContext _ordersDataContext = new ProductsDataContext();
        //此静态变量只在GetAllOrdersInfoByEmployeeID()中用到



        public static OrdersCollection staticOrdersList = null;
        public OrdersStore()
        {
            staticOrdersList = new OrdersCollection();
            _ordersDataContext = new ProductsDataContext();
        }
        /// <summary>
        /// Define Method OrdersObjectToEntity
        /// Return OrdersEntity
        /// </summary>
        /// <param name="order"></param>
        /// <returns></returns>
        private OrdersEntity OrdersObjectToEntity(Orders order)
        {
            OrdersEntity ordersEntity = new OrdersEntity();
            ordersEntity.OrderID = order.OrderID;
            ordersEntity.CustomerID = order.CustomerID;
            ordersEntity.EmployeeID = order.EmployeeID;
            ordersEntity.OrderDate = order.OrderDate;
            ordersEntity.RequiredDate = order.RequireDate;
            ordersEntity.OrderNote = order.OrderNote;
            ordersEntity.OrderCreaterID = order.OrderCreaterID;
            ordersEntity.StorehouseAccepterID = order.StorehouseAccepterID;
            ordersEntity.StorehouseNote = order.StorehouseNote;
            ordersEntity.StorehouseReadyDate = order.StorehouseReadyDate;
            ordersEntity.Carrier = order.Carrier;
            ordersEntity.TransportDate = order.TransportDate;
            ordersEntity.TransportInfoInputerID = order.TransportInfoInputerID;
            ordersEntity.TransportNote = order.TransportNote;
            ordersEntity.TransportOrderID = order.TransportOrderID;
            ordersEntity.ArrivalDate = order.ArrivalDate;
            ordersEntity.ReceiveInfoInputerID = order.ReceiveInfoInputerID;
            ordersEntity.ReceiveNote = order.ReceiveNote;
            ordersEntity.Receiver = order.Receiver;
            ordersEntity.OrderCloseDate = order.OrderCloseDate;
            ordersEntity.OrderCloseAccepterID = order.OrderCloseAccepterID;
            ordersEntity.OrgID = order.OrgID;
            return ordersEntity;
        }
        /// <summary>
        /// Get List Of Orders
        /// </summary>
        /// <returns></returns>
        public OrdersCollection GetOrdersList()
        {
            OrdersCollection ordersList = new OrdersCollection();
            IEnumerable<Orders> orders = from order in this._ordersDataContext.Orders
                                         orderby order.OrderID
                                         select order;
            foreach (Orders order in orders)
            {
                ordersList.Add(this.OrdersObjectToEntity(order));
            }
            return ordersList;
        }
        /// <summary>
        /// Select the Top  Orders View
        /// </summary>
        /// <returns></returns>
        public OrdersCollection GetTopOrdersList(int count)
        {
            OrdersCollection ordersList = new OrdersCollection();
            IEnumerable<Orders> orders = (from order in this._ordersDataContext.Orders
                                          orderby order.OrderDate
                                          select order).Take(count);
            foreach (Orders order in orders)
            {
                ordersList.Add(this.OrdersObjectToEntity(order));
            }
            return ordersList;
        }
        /// <summary>
        /// Get Single Order Infomation
        /// Select It By OrderID
        /// </summary>
        /// <param name="orderID"></param>
        /// <returns></returns>
        public OrdersEntity GetOrderInfo(int orderID)
        {
            OrdersEntity ordersEntity = new OrdersEntity();
            IEnumerable<Orders> orders = from order in this._ordersDataContext.Orders
                                         where order.OrderID == orderID
                                         select order;
            foreach (Orders order in orders)
            {
                ordersEntity = this.OrdersObjectToEntity(order);
            }
            return ordersEntity;
        }
        public OrdersCollection GetOrderInfoCollection(int orderID)//Coder:Tom
        {
            OrdersCollection ordersList = new OrdersCollection();
            IEnumerable<Orders> orders = from order in this._ordersDataContext.Orders
                                         where order.OrderID == orderID
                                         select order;
            foreach (Orders order in orders)
            {
                ordersList.Add(this.OrdersObjectToEntity(order));
            }
            return ordersList;
        }
        /// <summary>
        /// Add New Orders
        /// </summary>
        /// <param name="ordersEntity"></param>
        public void AddOrders(OrdersEntity ordersEntity)
        {
            #region

            #region  测试代码

            //            _ordersDataContext.ExecuteCommand(@"Insert into Orders (CustomerID,
            //                                                                    EmployeeID,
            //                                                                    OrderDate,
            //                                                                    RequireDate,
            //                                                                    OrderNote,
            //                                                                    OrderCreaterID, 
            //                                                                    StorehouseReadyDate,
            //                                                                    StorehouseAccepterID,
            //                                                                    StorehouseNote,
            //                                                                    Carrier,
            //                                                                    TransportOrderID,
            //                                                                    TransportDate,
            //                                                                    TransportNote,
            //                                                                    TransportInfoInputerID,                                                                    
            //                                                                    ArrivalDate,
            //                                                                    Receiver,
            //                                                                    ReceiveNote,
            //                                                                    ReceiveInfoInputerID,
            //                                                                    OrderCloseDate,
            //                                                                    OrderCloseAccepterID,                                                                    
            //                                                                    OrgID) 
            //                                                                    values ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},
            //                                                                    {12},{13},{14},{15},{16},{17},{18},{19}, {20})",
            //                                                                    ordersEntity.CustomerID,
            //                                                                    ordersEntity.EmployeeID,
            //                                                                    ordersEntity.OrderDate,
            //                                                                    ordersEntity.RequiredDate,
            //                                                                    ordersEntity.OrderNote,
            //                                                                    ordersEntity.OrderCreaterID,
            //                                                                    ordersEntity.StorehouseReadyDate,
            //                                                                    ordersEntity.StorehouseAccepterID,
            //                                                                    ordersEntity.StorehouseNote,
            //                                                                    ordersEntity.Carrier,
            //                                                                    ordersEntity.TransportOrderID,
            //                                                                    ordersEntity.TransportDate,
            //                                                                    ordersEntity.TransportNote,
            //                                                                    ordersEntity.TransportInfoInputerID,
            //                                                                    ordersEntity.ArrivalDate,
            //                                                                    ordersEntity.Receiver,
            //                                                                    ordersEntity.ReceiveNote,
            //                                                                    ordersEntity.ReceiveInfoInputerID,
            //                                                                    ordersEntity.OrderCloseDate,
            //                                                                    ordersEntity.OrderCloseAccepterID,
            //                                                                    ordersEntity.OrgID
            //                                                                  );
            #endregion
            _ordersDataContext.ExecuteCommand(@"Insert into Orders (CustomerID,
                                                                    EmployeeID,
                                                                    OrderDate,
                                                                    RequireDate,
                                                                    OrderNote,
                                                                    OrderCreaterID,                                                                         
                                                                    OrgID) 
                                                                    values ({0},{1},{2},{3},{4},{5},{6})",
                                                                   ordersEntity.CustomerID,
                                                                   ordersEntity.EmployeeID,
                                                                   ordersEntity.OrderDate,
                                                                   ordersEntity.RequiredDate,
                                                                   ordersEntity.OrderNote,
                                                                   ordersEntity.OrderCreaterID,
                                                                   ordersEntity.OrgID
                                                                 );



            #endregion
        }
        /// <summary>
        /// Delete  Order 
        /// Select It By OrderID
        /// </summary>
        /// 
        /// <param name="ordersEntity"></param>
        public void DeleteOrder(OrdersEntity ordersEntity)
        {
            _ordersDataContext.ExecuteCommand(@"delete from Orders where OrderID={0}", ordersEntity.OrderID);
        }
        /// <summary>
        /// Update Order Information 
        /// Select It By OrderID
        /// </summary>
        /// <param name="ordersEntity"></param>
        #region 订单表数据更新

        public void UpdateOrder(OrdersEntity ordersEntity)
        {
            
            _ordersDataContext.ExecuteCommand(@"Update  Orders set (CustomerID={0},
                                                                    EmployeeID={1},
                                                                    OrderDate={2},
                                                                    RequireDate={3},
                                                                    OrderNote={4},
                                                                    OrderCreaterID={5},
                                                                    StorehouseAccepterID={6}
                                                                    StorehouseNote={7},
                                                                    StorehouseReadyDate={8},
                                                                    Carrier={9},
                                                                    TransportDate={10},
                                                                    TrasportInfoInputerID={11},
                                                                    TransportNote={12},
                                                                    TransportOrderID={13},
                                                                    ArrivalDate={14},
                                                                    ReceiveInfoInputerID={15},
                                                                    ReceiveNote={16},
                                                                    Receiver={17},
                                                                    OrderCloseDate={18},
                                                                    OrderCloseAccepterID={19},
                                                                    OrgID={20}) where OrderID={21} ",
                                                                    ordersEntity.CustomerID,
                                                                    ordersEntity.EmployeeID,
                                                                    ordersEntity.OrderDate, 
                                                                    ordersEntity.RequiredDate,
                                                                    ordersEntity.OrderNote,
                                                                    ordersEntity.OrderCreaterID,
                                                                    ordersEntity.StorehouseAccepterID,
                                                                    ordersEntity.StorehouseNote,
                                                                    ordersEntity.StorehouseReadyDate,
                                                                    ordersEntity.Carrier,
                                                                    ordersEntity.TransportDate,
                                                                    ordersEntity.TransportInfoInputerID,
                                                                    ordersEntity.TransportNote,
                                                                    ordersEntity.TransportOrderID,
                                                                    ordersEntity.ArrivalDate,
                                                                    ordersEntity.ReceiveInfoInputerID,
                                                                    ordersEntity.ReceiveNote,
                                                                    ordersEntity.Receiver,
                                                                    ordersEntity.OrderCloseDate,
                                                                    ordersEntity.OrderCloseAccepterID,
                                                                    ordersEntity.OrgID,
                                                                    ordersEntity.OrderID);