1using System;
 2using System.Collections;
 3using System.ComponentModel;
 4using System.Data;
 5using System.Data.SqlClient;
 6using System.Drawing;
 7using System.Web;
 8using System.Web.SessionState;
 9using System.Web.UI;
10using System.Web.UI.WebControls;
11using System.Web.UI.HtmlControls;
12using System.Configuration;
13
14namespace STGROUP
15...{
16    /**//// <summary>
17    /// ST_default 的摘要说明。
18    /// </summary>
19    public class ST_default : System.Web.UI.Page
20    ...{
21        protected System.Web.UI.WebControls.Button st_btn_enter;
22        protected System.Web.UI.WebControls.TextBox st_tbx_userid;
23        protected System.Web.UI.WebControls.TextBox st_tbx_userpwd;
24        protected System.Web.UI.WebControls.Label st_lbl_note;
25    
26        private void Page_Load(object sender, System.EventArgs e)
27        ...{
28            // 在此处放置用户代码以初始化页面
29        }
30
31        Web Form Designer generated code#region Web Form Designer generated code
32        override protected void OnInit(EventArgs e)
33        ...{
34            //
35            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
36            //
37            InitializeComponent();
38            base.OnInit(e);
39        }
40        
41        /**//// <summary>
42        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
43        /// 此方法的内容。
44        /// </summary>
45        private void InitializeComponent()
46        ...{    
47            this.st_btn_enter.Click += new System.EventHandler(this.st_btn_enter_Click);
48            this.Load += new System.EventHandler(this.Page_Load);
49
50        }
51        #endregion
52
53        private void st_btn_enter_Click(object sender, System.EventArgs e)
54        ...{
55            string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
56            SqlConnection st_conn=new SqlConnection(st_connstr);    
57            st_conn.Open();
58            string st_sqlstr="select * from ST_users where ST_User_id='"+st_tbx_userid.Text+"'and ST_User_password='"+st_tbx_userpwd.Text+"'";
59            SqlCommand st_comm=new SqlCommand(st_sqlstr,st_conn);
60            SqlDataReader st_dreader=st_comm.ExecuteReader();
61            if(st_dreader.Read())
62            ...{   Session["User_id"]=st_dreader["ST_User_id"];
63                Session["user_power"]=st_dreader["ST_User_power"];            
64                if((int)Session["User_power"]==0)
65                ...{
66                    Response.Redirect("ST_query.aspx");
67                }
68                else 
69                ...{
70                    Response.Redirect("ST_student.aspx");
71                }
72            }
73            else
74            ...{
75                    st_lbl_note.Text="登录失败！";
76              }
77            st_conn.Close();
78        }
79
80        
81    }
82}
83