drilldownreport.cs

ASP.NET 建立和发布可自定义 Web 报表的指南

using System;
using System.Data;
using System.Configuration;
using ASPNET.StarterKit.Reports.DataAccessLayer;
using System.Collections;

namespace ASPNET.StarterKit.Reports.Components
{
	public class DrillDownReport
	{
		private string		_customerID;
		private string		_companyName;
		private string		_contactName;
		private string		_shipAddress;
		private string		_shipCity;
		private string		_shipCountry;
		private string		_shipPostalCode;
		private DateTime	_orderDate;
		private int			_orderID;
		private DateTime	_shippedDate;
		private int			_productID;
		private string		_productName;
		private decimal		_unitPrice;
		private int 		_quantity;

		public string CustomerID
		{
			get { return _customerID; }
			set { _customerID = value; }
		}

		public string CompanyName
		{
			get { return _companyName; }
			set { _companyName = value; }
		}

		public string ContactName
		{
			get { return _contactName; }
			set { _contactName = value; }
		}

		public string ShipAddress
		{
			get { return _shipAddress; }
			set { _shipAddress = value; }
		}

		public string ShipCity
		{
			get { return _shipCity; }
			set { _shipCity = value; }
		}

		public string ShipCountry
		{
			get { return _shipCountry; }
			set { _shipCountry = value; }
		}

		public string ShipPostalCode
		{
			get { return _shipPostalCode; }
			set { _shipPostalCode = value; }
		}

		public DateTime OrderDate
		{
			get { return _orderDate; }
			set { _orderDate = value; }
		}

		public int OrderID
		{
			get { return _orderID; }
			set { _orderID = value; }
		}

		public DateTime ShippedDate
		{
			get { return _shippedDate; }
			set { _shippedDate = value; }
		}

		public int ProductID
		{
			get { return _productID; }
			set { _productID = value; }
		}

		public string ProductName
		{
			get { return _productName; }
			set { _productName = value; }
		}

		public decimal UnitPrice
		{
			get { return _unitPrice; }
			set { _unitPrice = value; }
		}

		public int Quantity
		{
			get { return _quantity; }
			set { _quantity = value; }
		}

		//*********************************************************************
		//
		// GetCustomers method
		//
		// The GetCustomers method retrieves all customers in the Reports database 
		//
		//*********************************************************************

		public static DrillDownReportCollection GetCustomers()
		{
			DataSet dsData = SqlHelper.ExecuteDataset(
				ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetAllCustomers");
			DrillDownReportCollection items = new DrillDownReportCollection();

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				DrillDownReport item = new DrillDownReport();
				item.CustomerID = row["CustomerID"].ToString();
				item.CompanyName = row["CompanyName"].ToString();
				item.ContactName = row["ContactName"].ToString();
				items.Add(item);
			}

			return items;
		}

		//*********************************************************************
		//
		// GetOrders method
		//
		// The GetOrders method retrieves all orders shipped for a particular customer.
		//
		//*********************************************************************

		public static DrillDownReportCollection GetOrders(string customerID)
		{
			DataSet dsData = SqlHelper.ExecuteDataset(
				ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetOrders", customerID);
			DrillDownReportCollection items = new DrillDownReportCollection();

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				DrillDownReport item = new DrillDownReport();
				item.OrderID = Convert.ToInt32(row["OrderID"]);
				item.OrderDate = Convert.ToDateTime(row["OrderDate"]);
				item.ShippedDate = Convert.ToDateTime(row["ShippedDate"]);
				item.ShipAddress = row["ShipAddress"].ToString();
				item.ShipCity = row["ShipCity"].ToString();
				item.ShipCountry = row["ShipCountry"].ToString();
				item.ShipPostalCode = row["ShipPostalCode"].ToString();
				items.Add(item);
			}

			return items;
		}

		//*********************************************************************
		//
		// GetOrderDetails method
		//
		// The GetOrderDetails method retrieves the order info for order with orderID.
		//
		//*********************************************************************

		public static DrillDownReportCollection GetOrderDetails(int orderID)
		{

			DataSet dsData = SqlHelper.ExecuteDataset(
				ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetOrderDetails", orderID);
			DrillDownReportCollection items = new DrillDownReportCollection();

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				DrillDownReport item = new DrillDownReport();
				item.ProductID = Convert.ToInt32(row["ProductID"]);
				item.ProductName = row["ProductName"].ToString();
				item.UnitPrice = Convert.ToDecimal(row["UnitPrice"]);
				item.Quantity = Convert.ToInt32(row["Quantity"]);
				items.Add(item);
			}

			return items;
		}
	}
}