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，到此您的解决方案资源管理器类似如下：