reportpicker.aspx.cs

基于sqlserver2k,reporting service的扩展(auth,render,deliver==)应用（mssql,RS,AS,BI）

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using System.Diagnostics;
using System.Text;
using AWC.Reporter.Web.RS;

namespace AWC.Reporter.Web
{
	/// <summary>
	/// Summary description for ReportPicker.
	/// </summary>
	public class ReportPicker : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblSalesOrderNumber;
		protected System.Web.UI.WebControls.DataGrid grdParams;
		protected System.Web.UI.WebControls.DropDownList drpReports;
		protected System.Web.UI.WebControls.DropDownList drpExport;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (!this.IsPostBack)
			{
				LoadExportFormats();
				LoadReports();
				if (drpReports.Items.Count>0) LoadParameters(drpReports.SelectedItem.Value);
				
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.drpReports.SelectedIndexChanged += new System.EventHandler(this.drpReports_SelectedIndexChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		/// <summary>
		/// Load the reports from the report catalog
		/// </summary>
		private void LoadReports()
		{
			ReportingService rs = RsHelpers.Proxy;
			CatalogItem[] items = null;

			try
			{
				items = rs.ListChildren(ConfigurationSettings.AppSettings[Constants.CONFIG_REPORT_FOLDER], false);
			}
			
			catch (System.Exception ex)
			{
				throw ex;
			}
			// enumerate through the catalog items and filter out the reports only
			foreach (CatalogItem item in items)
			{
				if (item.Type == ItemTypeEnum.Report) drpReports.Items.Add (new ListItem(item.Name,item.Path));
			}

		}
		
		/// <summary>
		/// Load the Export Formats
		/// </summary>
		private void LoadExportFormats()
		{
			ReportingService rs = RsHelpers.Proxy;
			Extension[] extensions = null;

			// Retrieve a list of all supported rendering extensions. 
			try
			{
				extensions = rs.ListExtensions(ExtensionTypeEnum.Render);

				if (extensions != null)
				{
					foreach (Extension extension in extensions)
					{
						if (extension.Name.ToLower()!="null") drpExport.Items.Add(new ListItem(extension.Name));
					}
					drpExport.Items.FindByText("HTML4.0").Selected = true;
				}
			}

			catch (System.Exception ex)
			{
				throw ex;
			}

		}
		private void LoadParameters (string reportPath)
		{
			ReportingService rs = RsHelpers.Proxy;
			ReportParameter[] parameters = null;
			DataTable tableParameters = new DataTable();
			tableParameters.Columns.Add("Name");
			tableParameters.Columns.Add("Value");
			
			try
			{
				parameters = rs.GetReportParameters(reportPath, null, false,  null, null);
				
			}
			catch
			{
				throw;
			}
			// enumerate through the report parameters and load them in the ListView
			foreach (ReportParameter parameter in parameters)
			{
				if (parameter.PromptUserSpecified && parameter.PromptUser) 
				{
					tableParameters.Rows.Add(new object[]{parameter.Name, parameter.DefaultValues!=null?(object)parameter.DefaultValues[0]: (object)System.DBNull.Value});
					
				}
			}
			tableParameters.AcceptChanges();
			grdParams.DataSource = tableParameters;
			grdParams.DataBind();
		}

		private void drpReports_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			DropDownList dropDown = (DropDownList)sender;
			LoadParameters(dropDown.Items[dropDown.SelectedIndex].Value);
		}
	}
}