visualreport.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
{
	//*********************************************************************
	//
	// VisualReport Class
	//
	// The VisualReport class is used to represent a data item for Visual
	// Report.
	//
	//*********************************************************************

	public class VisualReport
	{
		private string	_categoryName;
		private decimal _sales;

		public string CategoryName
		{
			get { return _categoryName; }
			set { _categoryName = value; }
		}

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

		//*********************************************************************
		//
		// GetCategorySales method retrieves the total of all category sales
		// from the database and transforms the result to a VisualReportCollection
		// custom colletion before returning it to the calling function
		//
		//*********************************************************************

		public static VisualReportCollection GetCategorySales()
		{
			DataSet dsData = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetCategorySales");
			VisualReportCollection items = new VisualReportCollection();

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				VisualReport item = new VisualReport();
				item.CategoryName = row["CategoryName"].ToString();
				item.Sales = Convert.ToDecimal(row["Sales"]);
				items.Add(item);
			}
			return items;
		}	
	}
}