productsstore.cs

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

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

namespace VinciDataAccess.DataAccess
{
     public class ProductsStore
    {
        private ProductsDataContext _productsDataContext = null;

        public ProductsStore()
        {
            _productsDataContext = new ProductsDataContext();
        }
        /// <summary>
        /// Define Method ProductsObjectToEntity
        /// Retrun ProductsEntity
        /// </summary>
        /// <param name="product"></param>
        /// <returns></returns>
        private ProductsEntity ProductsObjectToEntity(Products product)
        {
            ProductsEntity productEntity = new ProductsEntity();
            productEntity.ProductID = product.ProductID;
            productEntity.ProductName = product.ProductName;
            productEntity.SupplierID = product.SupplierID;
            productEntity.CategoryID = product.CategoryID;
            productEntity.QuantityPerUnit = product.QuantityPerUnit;
            productEntity.UnitPrice = product.UnitPrice;
            productEntity.UnitsInStorck = product.UnitsInStock;
            productEntity.UnitsOnOrder = product.UnitsOnOrder;
            productEntity.ReorderLevel = product.ReorderLevel;
            productEntity.IsActive = product.IsActive;
            return productEntity;
        }
        /// <summary>
        /// Get List Of Products
        /// </summary>
        /// <returns></returns>
        public ProductsCollection GetProductsList()
        {
            ProductsCollection productsList = new ProductsCollection();
            IEnumerable<Products> products = from product in this._productsDataContext.Products
                                             orderby product.ProductID
                                             select product;
            foreach (Products product in products)
            {                
                productsList.Add(this.ProductsObjectToEntity(product));
            }
            return productsList;
        }
        /// <summary>
        /// Get Single Product Information
        /// Select It By ProdcutID
        /// </summary>
        /// <param name="productID"></param>
        /// <returns></returns>
        public ProductsEntity GetProdcutInfo(int productID)
        {
            ProductsEntity productsEntity = new ProductsEntity();
            IEnumerable<Products> products = from product in this._productsDataContext.Products
                                             where product.ProductID ==productID
                                             orderby product.ProductID
                                             select product;
            foreach (Products product in products)
            {
                productsEntity = this.ProductsObjectToEntity(product);
            }
            return productsEntity;
        }
        public ProductsCollection GetProductInfo(int productID)//Coder:Tom
        {
            ProductsCollection productsList = new ProductsCollection();
            IEnumerable<Products> products = from product in this._productsDataContext.Products
                                             where product.ProductID == productID
                                             orderby product.ProductID
                                             select product;
            foreach (Products product in products)
            {
                productsList.Add(this.ProductsObjectToEntity(product));
            }
            return productsList;
        }
         //由商品类别ID 返回一个产品数据集
        public ProductsCollection GetPrdListByCagryID(int catagroyID)
        {
            ProductsCollection productsList = new ProductsCollection();
            IEnumerable<Products> products = from product in this._productsDataContext.Products
                                             where product.CategoryID == catagroyID
                                             orderby product.ProductID 
                                             select product;
            foreach (Products product in products)
            {
                productsList.Add(this.ProductsObjectToEntity(product));
            }
            return productsList;
        }

         
    }
}