textreport.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 TextReport
	{
		private string		_employeeName;
		private string		_employeeNotes;
		private string		_employeeTitle;
		private string		_employeeExt;
		private string		_employeeAddress;
		private string		_employeeCity;
		private string		_employeeState;
		private string		_employeeZip;

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

		public string EmployeeNotes
		{
			get { return _employeeNotes; }
			set { _employeeNotes = value; }
		}

		public string EmployeeTitle
		{
			get { return _employeeTitle; }
			set { _employeeTitle = value; }
		}

		public string EmployeeExt
		{
			get { return _employeeExt; }
			set { _employeeExt = value; }
		}

		public string EmployeeAddress
		{
			get { return _employeeAddress; }
			set { _employeeAddress = value; }
		}

		public string EmployeeCity
		{
			get { return _employeeCity; }
			set { _employeeCity = value; }
		}

		public string EmployeeState
		{
			get { return _employeeState; }
			set { _employeeState = value; }
		}

		public string EmployeeZip
		{
			get { return _employeeZip; }
			set { _employeeZip = value; }
		}

		//*********************************************************************
		//
		// GetEmployees()
		//
		// This function calls the "GetEmployees" stored procedure, and for 
		// every row in the resulting DataSet, inserts an item into the 
		// thin class TextReportCollection.  TextReportCollection is simply
		// an ArrayList holding the public property values "EmployeeName", 
		// "EmployeeNotes", "EmployeeTitle", "EmployeeExt", "EmployeeAddress",
		// "EmployeeCity", "EmployeeState", and "EmployeeZip".
		//
		//*********************************************************************

		public static TextReportCollection GetEmployees()
		{
			DataSet dsData = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings[Global.CfgKeyConnString], "Reports_GetEmployees");
			TextReportCollection items = new TextReportCollection();

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				TextReport item = new TextReport();
				item.EmployeeName = row["EmployeeName"].ToString();
				item.EmployeeNotes = row["EmployeeNotes"].ToString();
				item.EmployeeTitle = row["EmployeeTitle"].ToString();
				item.EmployeeExt = row["EmployeeExt"].ToString();
				item.EmployeeAddress = row["EmployeeAddress"].ToString();
				item.EmployeeCity = row["EmployeeCity"].ToString();
				item.EmployeeState = row["EmployeeState"].ToString();
				item.EmployeeZip = row["EmployeeZip"].ToString();

				items.Add(item);
			}

			return items;
		}
	}
}