crosstabreport.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
{
	//*********************************************************************
	//
	// CrossTabReport Class
	//
	// The CrossTabReport class is used to represent a data item for CrossTab Report
	// and is mainly used to retrieve data from the database.
	//
	//*********************************************************************

	public class CrossTabReport
	{
		private decimal	_eastern;
		private int		_monthOfSales;
		private DateTime _orderDate;
		private decimal	_northern;	
		private int		_quarter;
		private decimal _sales;
		private decimal	_southern;
		private decimal	_western;


		public decimal Eastern
		{
			get { return _eastern; }
			set { _eastern = value; }
		}

		public int MonthOfSales 
		{
			get { return _monthOfSales; }
			set { _monthOfSales = value; }
		}

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

		public int Quarter 
		{
			get { return _quarter; }
			set { _quarter = value; }
		}

		public decimal Northern
		{
			get { return _northern; }
			set { _northern = value; }
		}

		public decimal Sales
		{
			get { return _sales; }
			set { _sales = value; }
		}

		public decimal Southern
		{
			get { return _southern; }
			set { _southern = value; }
		}

		public decimal Western
		{
			get { return _western; }
			set { _western = value; }
		}

		//*********************************************************************
		//
		// GetRegionSales method retrieves all the necessary monthly regional sales
		// from the database and transforms the result to a CrossTabReportCollection
		// custom collection before returning it to the calling function
		//
		//*********************************************************************

		public static CrossTabReportCollection GetRegionSales(int quarter, int year)
		{
			DataSet dsData = SqlHelper.ExecuteDataset(
				ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetSalesByRegion", year, quarter);
			CrossTabReportCollection items = new CrossTabReportCollection();

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				CrossTabReport item = new CrossTabReport();
				item.MonthOfSales = Convert.ToInt32(row["MonthOfSales"]);
				item.OrderDate = new DateTime(year, item.MonthOfSales, 1);
				item.Eastern = Convert.ToDecimal(row["Eastern"]);
				item.Western = Convert.ToDecimal(row["Western"]);
				item.Northern = Convert.ToDecimal(row["Northern"]);
				item.Southern = Convert.ToDecimal(row["Southern"]);
				item.Sales = Convert.ToDecimal(row["TotalMonth"]);

				items.Add(item);
			}
			return items;
		}
	}
}