RDLC报表(一)

 一，效果如下：

二，开始实现

1，新建一个空的ASP.NET WEBFORM项目，命名NorthwindReports

2，在项目中创建一个DAL的空文件夹

3，在DAL文件夹上创建一个ADO.NET 实体数据模型叫做Northwind

 

4，在DAL文件夹上右键添加如下代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace NorthwindReports.DAL
{
    public class ProductViewModel
    {
        public int? ProductID { get; set; }
        public string ProductName { get; set; }
        public System.Nullable<decimal> UnitPrice { get; set; }
        public string CategoryName { get; set; }
        public int? CategoryID { get; set; }
        public int? SupplierID { get; set; }
        public bool Discontinued { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace NorthwindReports.DAL
{
    public class CategoryViewModel
    {
        public string CategoryName { get; set; }
        public int CategoryID { get; set; }
    }
}

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace NorthwindReports.DAL
{
    interface IProductRepository
    {
        IQueryable<Product> GetProducts();
        IQueryable<ProductViewModel> GetProductsProjected(int? supplierID, int? categoryID);
        IQueryable<SupplierViewModel> GetSuppliers();
        IQueryable<CategoryViewModel> GetCategories();
    }
}

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace NorthwindReports.DAL
{
    public class ProductRepository : IProductRepository
    {
        /// <summary>
        /// IQueryable of all Products
        /// </summary>
        /// <returns></returns>
        public IQueryable<Product> GetProducts()
        {
            var dataContext = new NorthwindEntities();
            var products = from p in dataContext.Products
                           select p;
            return products;
        }

        /// <summary>
        /// IQueryable of Projects projected 
        /// into the ProductViewModel class
        /// </summary>
        /// <returns></returns>
        public IQueryable<ProductViewModel> GetProductsProjected(int? supplierID, int? categoryID)
        {
            var projectedProducts = from p in GetProducts()
                                    select new ProductViewModel
                                    {
                                        ProductID = p.ProductID,
                                        ProductName = p.ProductName,
                                        UnitPrice = p.UnitPrice,
                                        CategoryName = p.Category.CategoryName,
                                        CategoryID = p.CategoryID,
                                        SupplierID = p.SupplierID,
                                        Discontinued = p.Discontinued
                                    };
            // Filter on SupplierID 
            if (supplierID.HasValue)
            {
                projectedProducts = projectedProducts.Where(a => a.SupplierID == supplierID);
            }

            // Filter on CategoryID 
            if (categoryID.HasValue)
            {
                projectedProducts = projectedProducts.Where(a => a.CategoryID == categoryID);
            }

            return projectedProducts;
        }


        public IQueryable<SupplierViewModel> GetSuppliers()
        {
            var dataContext = new NorthwindEntities();
            var suppliers = from s in dataContext.Suppliers
                            select new SupplierViewModel
                            {
                                SupplierID = s.SupplierID,
                                CompanyName = s.CompanyName
                            };
            return suppliers;
        }

        public IQueryable<CategoryViewModel> GetCategories()
        {
            var dataContext = new NorthwindEntities();
            var categories = from c in dataContext.Categories
                             select new CategoryViewModel
                             {
                                 CategoryID = c.CategoryID,
                                 CategoryName = c.CategoryName
                             };
            return categories;
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace NorthwindReports.DAL
{
    public class SupplierViewModel
    {
        public string CompanyName { get; set; }
        public int SupplierID { get; set; }
    }
}

 

5，到此您的解决方案资源管理器类似如下：