salesreport.cs

来自「ASP.NET 建立和发布可自定义 Web 报表的指南」· CS 代码 · 共 59 行

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

namespace ASPNET.StarterKit.Reports.Components
{
	//*********************************************************************
	//
	// SalesReport Class
	//
	// The SalesReport class is used to represent a data item for Visual
	// Report.
	//
	//*********************************************************************

	public class SalesReport
	{
		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 SalesReportCollection
		// custom colletion before returning it to the calling function
		//
		//*********************************************************************

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

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