masterdetailreport.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 MasterDetailReport
	{
		private DateTime	_orderDate;
		private int			_orderID;
		private int			_ordersShipped;
		private int			_quarter;
		private decimal		_sales;

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

		public int OrderID
		{
			get { return _orderID; }
			set { _orderID = value; }
		}

		public int OrdersShipped
		{
			get { return _ordersShipped; }
			set { _ordersShipped = value; }
		}

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

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


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

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				MasterDetailReport item = new MasterDetailReport();
				item.Quarter = Convert.ToInt32(row["Quarter"]);
				item.OrdersShipped = Convert.ToInt32(row["OrdersShipped"]);
				item.Sales = Convert.ToDecimal(row["Sales"]);
				items.Add(item);
			}
			return items;
		}

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

			foreach(DataRow row in dsData.Tables[0].Rows)
			{
				MasterDetailReport item = new MasterDetailReport();
				item.OrderID = Convert.ToInt32(row["OrderID"]);
				item.OrderDate = Convert.ToDateTime(row["OrderDate"]);
				item.Sales = Convert.ToDecimal(row["Sales"]);
				items.Add(item);
			}
			return items;
		}
	}
}