writeback.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.Data.SqlClient;
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;

namespace AWC.Reporter.Web
{
	/// <summary>
	/// Summary description for Writeback.
	/// </summary>
	public class Writeback : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblSalesOrderNumber;
		protected System.Web.UI.WebControls.TextBox txtOrderDate;
		protected System.Web.UI.WebControls.RequiredFieldValidator requiredFieldValidator;
		protected System.Web.UI.WebControls.DropDownList drpReports;
		protected System.Web.UI.WebControls.Label lblResults;
		protected System.Web.UI.WebControls.DropDownList drpSalesPerson;
		protected System.Web.UI.WebControls.LinkButton lnkUpdate;
		protected System.Web.UI.WebControls.RangeValidator rangeValidator;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (!this.IsPostBack)
			{
				string salesOrderNumber = Request["SO"];
				if (salesOrderNumber==null) 
				{
					lblResults.Text = "This page must be requested from the Sales Order Writeback report";
					return;
				}
				// load the list of employees
				LoadEmployees();
				// load the order details
				LoadOrder(salesOrderNumber);
			}

		}
		/// <summary>
		/// Loads all salespeople in the dropdown
		/// </summary>
		private void LoadEmployees()
		{
			SqlConnection connection = new SqlConnection();
			SqlDataReader reader = null;
			try 
			{
				string sql = "SELECT EmployeeID, LastName + N' ' + FirstName AS Employee FROM  Employee INNER JOIN SalesPerson ON EmployeeID = SalesPersonID ORDER BY LastName, FirstName";
				connection.ConnectionString = ConfigurationSettings.AppSettings[Constants.CONFIG_CONNECT_STRING];
				SqlCommand sqlCmd = new SqlCommand(sql, connection);
				sqlCmd.Connection.Open();
				reader = sqlCmd.ExecuteReader();
				drpSalesPerson.DataSource = reader;
				drpSalesPerson.DataBind();
			}
			catch (System.Exception ex)
			{
				reader.Close();
				connection.Close();
				throw ex;
			}
		}
		/// <summary>
		/// Get the order details.
		/// </summary>
		/// <param name="salesOrderNumber">The Order Number passed as a query string</param>
		private void LoadOrder(string salesOrderNumber)
		{
			SqlConnection connection = new SqlConnection();
			SqlDataReader reader = null;
			try 
			{
				string sql = "SELECT OrderDate, SalesOrderNumber, SalesPersonID FROM SalesOrderHeader WHERE SalesOrderNumber = @SalesOrderNumber";
				connection.ConnectionString = ConfigurationSettings.AppSettings[Constants.CONFIG_CONNECT_STRING];
				SqlCommand sqlCmd = new SqlCommand(sql, connection);
				sqlCmd.Parameters.Add("@SalesOrderNumber", SqlDbType.NVarChar, 25).Value = salesOrderNumber;

				sqlCmd.Connection.Open();
				reader = sqlCmd.ExecuteReader();

				// we expect exactly one record
				reader.Read();
				lblSalesOrderNumber.Text = salesOrderNumber;
				
				// synchronize the dropdown with the salesperson id from the order details
				drpSalesPerson.Items.FindByValue(reader["SalesPersonID"].ToString()).Selected=true;
				txtOrderDate.Text = reader.GetDateTime(0).ToShortDateString();
				
			}
			catch (System.Exception ex)
			{
				reader.Close();
				connection.Close();
				throw ex;
			}			
		}

		#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.lnkUpdate.Click += new System.EventHandler(this.lnkUpdate_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void lnkUpdate_Click(object sender, System.EventArgs e)
		{
			StringBuilder sb = new StringBuilder();
			sb.Append ("Order Updated<br>");
			sb.Append (String.Format("Sales Order Number: {0}<br>", lblSalesOrderNumber.Text));
			sb.Append (String.Format("Order Date: {0}<br>", txtOrderDate.Text));
			sb.Append (String.Format("Sales Person: {0}<br>", drpSalesPerson.SelectedItem.Text));
			lblResults.Text = sb.ToString();
		}
	}
}