hierarchicalreport.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 HierarchicalReport
	{
		private string		_territoryDescription;
		private decimal		_salesTotals;
		private int			_employeeID;
		private string		_employeeName;
		private string		_employeeTitle;
		private string		_employeeAddress;
		private string		_employeeCity;
		private string		_employeeRegion;
		private string		_employeePostalCode;
		private string		_employeeCountry;
		private string		_employeePhone;

		public string TerritoryDescription
		{
			get { return _territoryDescription; }
			set { _territoryDescription = value; }
		}

		public decimal SalesTotals
		{
			get { return _salesTotals; }
			set { _salesTotals = value; }
		}

		public int EmployeeID
		{
			get { return _employeeID; }
			set { _employeeID = value; }
		}

		public string EmployeeName
		{
			get { return _employeeName; }
			set { _employeeName = value; }
		}

		public string EmployeeTitle
		{
			get { return _employeeTitle; }
			set { _employeeTitle = value; }
		}
		
		public string EmployeeAddress
		{
			get { return _employeeAddress; }
			set { _employeeAddress = value; }
		}
		
		public string EmployeeCity
		{
			get { return _employeeCity; }
			set { _employeeCity = value; }
		}
		
		public string EmployeeRegion
		{
			get { return _employeeRegion; }
			set { _employeeRegion = value; }
		}
		
		public string EmployeePostalCode
		{
			get { return _employeePostalCode; }
			set { _employeePostalCode = value; }
		}

		public string EmployeeCountry
		{
			get { return _employeeCountry; }
			set { _employeeCountry = value; }
		}

		public string EmployeePhone
		{
			get { return _employeePhone; }
			set { _employeePhone = value; }
		}

		//*********************************************************************
		//
		// GetSalesByTerritory()
		//
		// This function calls the "GetSalesByTerritory" which retrieves the
		// sales totals for 1996, 1997, and 1998, grouped by Territory.
		// The items are added to the Array List and returned in the custom
		// thin class HierarchicalReportCollection.
		//
		//*********************************************************************

		public static HierarchicalReportCollection GetSalesByTerritory(int year)
		{
			DataSet dsData = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetSalesByTerritory", year);
			HierarchicalReportCollection items = new HierarchicalReportCollection();

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				HierarchicalReport item = new HierarchicalReport();
				item.TerritoryDescription = row["TerritoryDescription"].ToString();

				// Check for nulls, as they may not have any sales for this period
				if(row["SalesTotals"] != System.DBNull.Value)
					item.SalesTotals = Convert.ToDecimal(row["SalesTotals"]);

				items.Add(item);
			}

			return items;
		}
		
		//*********************************************************************
		//
		// GetEmployeeSalesByTerritory()
		//
		// This function calls the "GetSalesByTerritory" which retrieves the
		// sales totals for 1996, 1997, and 1998, grouped by Employee, for
		// a particular Territory.
		//
		// The items are added to the Array List and returned in the custom
		// thin class HierarchicalReportCollection.
		//
		//*********************************************************************

		public static HierarchicalReportCollection GetEmployeeSalesByTerritory(string TerritoryName, int year)
		{
			DataSet dsData = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetEmployeeSalesByTerritory", TerritoryName, year);
			HierarchicalReportCollection items = new HierarchicalReportCollection();

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				HierarchicalReport item = new HierarchicalReport();
				item.EmployeeID = Convert.ToInt32(row["EmployeeID"]);
				item.EmployeeName = row["EmployeeName"].ToString();

				// Check for nulls, as they may not have any sales for this period
				if(row["SalesTotals"] != System.DBNull.Value)
					item.SalesTotals = Convert.ToDecimal(row["SalesTotals"]);

				items.Add(item);
			}

			return items;
		}

		//*********************************************************************
		//
		// GetEmployeeInfo()
		//
		// This function calls the "GetSalesByTerritory" which retrieves the
		// sales totals for 1996, 1997, and 1998, grouped by Employee, for
		// a particular Territory.
		//
		// The items are added to the Array List and returned in the custom
		// thin class HierarchicalReportCollection.
		//
		//*********************************************************************

		public static HierarchicalReportCollection GetEmployeeInfo(int employeeID)
		{
			DataSet dsData = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetEmployeeByID", employeeID);
			HierarchicalReportCollection items = new HierarchicalReportCollection();

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				HierarchicalReport item = new HierarchicalReport();
				item.EmployeeID = Convert.ToInt32(row["EmployeeID"]);
				item.EmployeeTitle = row["Title"].ToString();
				item.EmployeeAddress = row["Address"].ToString();
				item.EmployeeCity = row["City"].ToString();
				item.EmployeeRegion = row["Region"].ToString();
				item.EmployeePostalCode = row["PostalCode"].ToString();
				item.EmployeeCountry = row["Country"].ToString();
				item.EmployeePhone = row["HomePhone"].ToString();

				items.Add(item);
			}

			return items;
		}
	}
}