00.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;

namespace sys_3
{
	/// <summary>
	/// _00 的摘要说明。
	/// </summary>
	public class _00 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Image Image2;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Button Button4;
		protected System.Web.UI.WebControls.Button Button3;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Panel Panel2;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.Button Button5;
		protected System.Web.UI.WebControls.TextBox tbID;
		protected System.Web.UI.WebControls.TextBox tbPWD;
		protected System.Web.UI.WebControls.TextBox tbPWD2;
		protected System.Web.UI.WebControls.Panel Panel4;
		protected System.Web.UI.WebControls.Button Button6;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.TextBox TextBox4;
		protected System.Web.UI.WebControls.DropDownList DDL1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.Panel Panel3;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!this.IsPostBack)
			{
				string flag=Request.QueryString["cc"];

				if(flag=="1")// 
				{
					this.Panel1.Visible=true;
					this.Panel4.Visible=false;
					Load_dd(this.DDL1,"select * from bpuser ",c.conSTR,"uName","uName");
	
				}
				if(flag=="2")// 
				{
					this.Panel1.Visible=false;
					this.Panel4.Visible=true;
				}
			}
		}

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

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
	          Response.Redirect("1.aspx");

		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
		     Response.Redirect("1.aspx");
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
		      Response.Redirect("1.aspx");
		}

		private void Load_dd(System.Web.UI.WebControls.DropDownList Dd,string cmdTxt,string connStr,string tf,string vf)
		{
			Dd.DataTextField=tf;
			Dd.DataValueField=vf;
			DataTable data= c.exeQuery(cmdTxt,connStr);
			Dd.DataSource=data;
			Dd.DataBind();
			Dd.Visible=true;
		}

		private void Button6_Click(object sender, System.EventArgs e)
		{
            //检查用户名和密码
			if(c.ExecuteSql2("select count(*) from bpuser where uID='"+this.TextBox1.Text.Trim()+"' and uPwd='"+this.TextBox2.Text.Trim()+"'")>0)
			{
				//检查是不是可以做
				if(c.ExecuteSql3("select zy from bpuser where uID='"+this.TextBox1.Text.Trim()+"' ").Trim()=="a")//用户名只可以注册一次！！！s a两种状态！！
				{
					//前面要加入验证控件
					c.ExecuteSql("update bpuser set uPwd= '"+this.TextBox3.Text.Trim()+"' where uID='"+this.TextBox1.Text.Trim()+"'");
					Label3.Text="修改成功！";
				   	Response.Redirect("1.aspx");
				}
				else
				{
					//这个纯属多余 没办法 不想改了
					Label3.Text="你还没有注册!";
				}
			}
			else
			{
				Label3.Text="你的用户名和密码的组合不对";
			}
		}

		private void Button5_Click(object sender, System.EventArgs e)
		{
			//检查是不是可以...
			if(c.ExecuteSql3("select zy from bpuser where uName = '"+this.DDL1.SelectedValue.ToString().Trim()+"'").Trim()=="s" )
			{
				//检查ID是不是已经被注册了
				if(c.ExecuteSql2("select count(*) from bpuser where uID = '"+this.tbID.Text.Trim()+"'")==0)
				{
					c.ExecuteSql("update bpuser set uID='"+this.tbID.Text.Trim()+"', uPwd= '"+this.tbPWD.Text.Trim()+"', zy='a' where uName = '"+this.DDL1.SelectedValue.ToString().Trim()+"'");
				    Label4.Text="你的注册名成功！";
					Response.Redirect("1.aspx");
				}
				else
				{
					// 提示你的注册名已经被占用！
					Label2.Text="你的注册名已经被占用！";
				}
			}
			else
			{
				Label4.Text="用户名已经被占用或者申请已经提交而没有批示";
			}
		}
	}
}