register.aspx.cs

毕业设计时做的,一个管理关于污染管理的, 源代码,呵呵 想想当时还真厉害,可以实现污染检测

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 System.Configuration;
using gyit.Data;
using System.Web.Security;

namespace itcrm
{
	/// <summary>
	/// register 的摘要说明。
	/// </summary>
	public class register : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button btnReturn;
		protected System.Web.UI.WebControls.Button btnEdit;
		protected System.Web.UI.WebControls.Button btnAdd;
		protected System.Web.UI.WebControls.TextBox txtTime;
		protected System.Web.UI.WebControls.DropDownList ddlSex;
		protected System.Web.UI.WebControls.TextBox txtTel;
		protected System.Web.UI.WebControls.TextBox txtJob;
		protected System.Web.UI.WebControls.TextBox txtAge;
		protected System.Web.UI.WebControls.TextBox txtPassword1;
		protected System.Web.UI.WebControls.TextBox txtUserName;
		protected System.Web.UI.WebControls.TextBox txtPassword2;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		DBOperator db;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			db =DBOperator.CreateObject((string)ConfigurationSettings.AppSettings["DSN"]);
			
				
		}

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

		}
		#endregion

/// <summary>
/// //****  提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void btnAdd_Click(object sender, System.EventArgs e)
		{
		   
				string[] strPara =new string[7];
				object[] strValues=new object[7];
				// string hashpwd=FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword1.Text,"SHA1");
				txtTime.Text=System.DateTime.Now.ToShortDateString();
				strPara[0]="@UserName";
				strPara[1]="@Password";			
				strPara[2]="@Age";
				strPara[3]="@Job";
				strPara[4]="@Tel";
				strPara[5]="@Sex";
				strPara[6]="@Time";
			
				strValues[0]=txtUserName.Text;
				strValues[1]=txtPassword1.Text;			
				strValues[2]=txtAge.Text;
				strValues[3]=txtJob.Text;
				strValues[4]=txtTel.Text;
				strValues[5]=ddlSex.SelectedItem.Text;
				strValues[6]=txtTime.Text;
			    string strSql="select UserName from Admin where UserName='"+txtUserName.Text+"'";
			    DataSet ds=null;
			try
			{
				db.Open();
				ds=db.exeSqlForDataSet(strSql);
				db.Close();
				if(ds.Tables[0].Rows.Count>0)
				{
                   Page.RegisterStartupScript("script","<script>alert('该用户名已存在，请从新选择！')</script>");
				}
				else
				{
					if(txtUserName.Text!="")
					{
						if(txtPassword1.Text!="")
						{
							if(txtPassword1.Text==txtPassword2.Text)
							{
								db.Open();
								db.exeProc("Add_Admin",strPara,strValues);
								db.Close();
								Page.RegisterStartupScript("script","<script>alert('注册成功！')</script>");
							}
							else{Page.RegisterStartupScript("script","<script>alert('两次密码输入不相等，请从新输入！')</script>");}
						}
						else{Page.RegisterStartupScript("script","<script>alert('请输入密码！')</script>");}
					}
					else{Page.RegisterStartupScript("script","<script>alert('请输入用户名！')</script>");}
				}
			}
			catch(System.Exception ee)
			{
				Page.RegisterStartupScript("script","<script>alert('"+ee.Message+"！')</script>");
			}
		}
/// <summary>
/// //***  清除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void btnEdit_Click(object sender, System.EventArgs e)
		{
			txtUserName.Text="";
			txtPassword1.Text="";
			txtTime.Text="";
			txtAge.Text="";
			txtJob.Text="";
			txtTel.Text="";
			
		}
/// <summary>
/// //***返回
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void btnReturn_Click(object sender, System.EventArgs e)
		{
		    Response.Redirect("default.aspx");
			
		}
	}
}