enter.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.Odbc;
using System.Configuration;

namespace AssetMngSystem
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class LoginWeb : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlForm LoginForm;
		protected System.Data.Odbc.OdbcConnection oCn_UserEnter;
		protected System.Web.UI.WebControls.TextBox TB_UserName;
		protected System.Web.UI.WebControls.TextBox TB_PWD;
		protected System.Web.UI.WebControls.ImageButton IBtn_Reset;
		protected System.Web.UI.WebControls.ImageButton IBtn_Enter;
		protected System.Web.UI.WebControls.Image Image1;
		protected System.Web.UI.WebControls.HyperLink HL_Link;
		protected System.Data.Odbc.OdbcCommand oCmd_UserEnter;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			//设置连接字符串
            oCn_UserEnter.ConnectionString=ConfigurationSettings.AppSettings["oCn_Str"];
			//该变量指示下一页面的初始状态，在下一页面将用此变量指示DataGrid控件所处的状态
			Session["InitFlag"]="TRUE";
		    //获取系统时间和在线人数
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.oCn_UserEnter = new System.Data.Odbc.OdbcConnection();
			this.oCmd_UserEnter = new System.Data.Odbc.OdbcCommand();
			this.IBtn_Enter.Click += new System.Web.UI.ImageClickEventHandler(this.IBtn_Enter_Click);
			this.IBtn_Reset.Click += new System.Web.UI.ImageClickEventHandler(this.IBtn_Reset_Click);
			// 
			// oCn_UserEnter
			// 
			this.oCn_UserEnter.ConnectionString = "DSN=RoomMngSystem;UID=sa;DATABASE=Room_mng;APP=Microsoft® Visual Studio .NET;WSID" +
				"=ROCK;PWD=SQLServer;Description=房屋管理系统";
			// 
			// oCmd_UserEnter
			// 
			this.oCmd_UserEnter.Connection = this.oCn_UserEnter;
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void IBtn_Enter_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if(TB_UserName.Text=="")    Response.Write("<script language='JavaScript'>alert('用户名不能为空！');window.location='Enter.aspx';</script>");
			else
			{
				//调用存储过程，依用户名查询
				oCmd_UserEnter.CommandText="select PW,name,type from UserInfo where ID='"+TB_UserName.Text+"'";
				oCmd_UserEnter.CommandType=CommandType.Text;
				oCn_UserEnter.Open();
				OdbcDataReader UserReader=oCmd_UserEnter.ExecuteReader();
				if(UserReader.Read())
				{
					if(UserReader.GetString(0)==TB_PWD.Text)
					{
						//保存用户名
						Session["UserName"]=UserReader.GetString(1);
						Session["ID"]=TB_UserName.Text;
						//根据不同的权限跳转至不同页面
						if(UserReader.GetBoolean(2)==false)      Response.Redirect("Operator\\RoomDataMng.aspx");//    Response.Redirect("Operator\\??.aspx");
						else if(UserReader.GetBoolean(2)==true)    Response.Redirect("Manager\\QuaryForm.aspx");
					}
					else	Response.Write("<script language='JavaScript'>alert('密码错误！');window.location='Enter.aspx';</script>");
				}
				else	Response.Write("<script language='JavaScript'>alert('用户名错误！');window.location='Enter.aspx';</script>");
				UserReader.Close();
			}
			oCn_UserEnter.Close();
		}

		private void IBtn_Reset_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			//清空文本框
			TB_UserName.Text="";
			TB_PWD.Text="";
		}
	}
}