addproceedinginformation.aspx.cs

天津行政许可管理中心管理系统. VISUAL STUDIO .NET 2003 ASP.NET 实现 已获得验收,投入使用

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

namespace AdministrationSystem
{
	/// <summary>
	/// AddProceedingInformation 的摘要说明。
	/// </summary>
	public class AddProceedingInformation : System.Web.UI.Page
	{
		protected WebControlLibrary.InputCalendar txtInputDate;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox txtDistrictName;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.DropDownList ddlProceedingSort;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.TextBox txtCharge;
		protected System.Web.UI.WebControls.DataGrid dgResult;
		protected System.Web.UI.WebControls.DropDownList ddlProceedingName;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.TextBox txtAcceptionNum;
		protected System.Web.UI.WebControls.TextBox txtComplishmentNum;
		protected System.Web.UI.WebControls.TextBox txtDealNum;
		protected System.Web.UI.WebControls.TextBox txtKeepFilesNum;
		protected System.Web.UI.WebControls.Button btnOK;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{
			    
				txtInputDate.Text=Convert.ToString(DateTime.Today.ToShortDateString());
				txtDistrictName.Text=GetDisrtictName(Convert.ToInt32(Session["UserID"].ToString()));
				txtDistrictName.Enabled=false;
				ddlProceedingSortDataBind();
				ddlProceedingNameDataBind(-1);

			}
		}
		private void dgResultDataBind()
		{
			
			BusinessDAL myBusiness=new BusinessDAL();
			SqlDataReader dr=myBusiness.GetToDayAddResult(GetDistrictID(Convert.ToInt32(Session["UserID"])),Convert.ToDateTime(txtInputDate.Text));
			dgResult.DataSource=dr;
			dgResult.DataBind();

			

		    
		

		}
		private void ddlProceedingSortDataBind()
		{
		
			BusinessDAL myBusiness=new BusinessDAL();
			SqlDataReader dr=myBusiness.GetProceedSorts();
			ddlProceedingSort.DataTextField="SortName";
			ddlProceedingSort.DataValueField="SortID";
			ddlProceedingSort.DataSource=dr;
			ddlProceedingSort.DataBind();
			ListItem ltm=new ListItem();
			ltm.Text="（空）";
			ltm.Value="NoProceedingSort";
			ddlProceedingSort.Items.Insert(0,ltm);
		}
		private void ddlProceedingNameDataBind(int SortID)
		{
		
			BusinessDAL myBusiness=new BusinessDAL();
			SqlDataReader dr=myBusiness.GetGivenProceedName(SortID);
			ddlProceedingName.DataTextField="ProceedingName";
			ddlProceedingName.DataValueField="ProceedingID";
			ddlProceedingName.DataSource=dr;
			ddlProceedingName.DataBind();
			ListItem ltm=new ListItem();
			ltm.Text="（空）";
			ltm.Value="ProceedingName";
			ddlProceedingName.Items.Insert(0,ltm);


		}
		private int GetDistrictID(int UserID)
		{
		
			UserDAL user=new UserDAL();
			int DistrictID=0;
			SqlDataReader dr=user.GetSingleUser(UserID);
			while (dr.Read())
			{
			
				DistrictID=Convert.ToInt32(dr["DistrictID"]);

			}
			return DistrictID;

		}
		private int GetDistrictSortID(int UserID)
		{
		
			UserDAL user=new UserDAL();
			int DistrictSortID=0;
			SqlDataReader dr=user.GetSingleUser(UserID);
			while (dr.Read())
			{
			
				DistrictSortID=Convert.ToInt32(dr["DistrictSortID"]);

			}
			return DistrictSortID;

		}
		private string GetDisrtictName( int UserID)
		{
		
			UserDAL user=new UserDAL();
			string DistrictName=null;
			SqlDataReader dr=user.GetSingleUser(UserID);
			while (dr.Read())
			{
			
				DistrictName=dr["DistrictName"].ToString();

			}
			return DistrictName;
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ddlProceedingSort.SelectedIndexChanged += new System.EventHandler(this.ddlProceedingSort_SelectedIndexChanged);
			this.btnOK.Click += new System.EventHandler(this.btnOK_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnOK_Click(object sender, System.EventArgs e)
		{
			
			BusinessDAL myBusiness=new BusinessDAL();
			
			myBusiness.AddFact(Convert.ToInt32(ddlProceedingSort.SelectedItem.Value.ToString()),
				               Convert.ToInt32(ddlProceedingName.SelectedValue.ToString()),
				               Convert.ToInt32(txtAcceptionNum.Text),
				               Convert.ToInt32(txtDealNum.Text),
				               Convert.ToInt32(txtComplishmentNum.Text),
				               Convert.ToInt32(txtKeepFilesNum.Text),
				               Convert.ToDecimal(txtCharge.Text),
				               Convert.ToDateTime(txtInputDate.Text),
				               GetDistrictID(Convert.ToInt32((Session["UserID"]))),
				               GetDistrictSortID(Convert.ToInt32((Session["UserID"]))));
			
			dgResultDataBind();
			ClearText();
			                   
      


			
		
		}
		private void ClearText()
		{
			 txtAcceptionNum.Text="";
			 txtDealNum.Text="";
			 txtComplishmentNum.Text="";
			 txtKeepFilesNum.Text="";
			 txtCharge.Text="";
		}

		private void ddlProceedingSort_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			
			ddlProceedingNameDataBind(Convert.ToInt32(ddlProceedingSort.SelectedValue));
			
		
		}
	}
}