using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.SqlClient;

public?partial?class?_Default?:?System.Web.UI.Page?
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{

????}
????protected?void?imgbtnLogin_Click（object?sender?EventArgs?e）
????{
????????///接收用戶輸入的參數
????????string?userName?=?txtUserName.Text.ToString（）.Trim（）;
????????string?userPwd?=?txtPwd.Text.ToString（）.Trim（）;
????????string?userRole?=?rblClass.SelectedValue.Trim（）;
????????string?selectStr?=?““;
????????switch?（userRole）
????????{
????????????case?“0“:???????????????????????//身份為教師時??????????????
????????????????selectStr?=?“Select?*?from?Teacher?where?Tname?=?‘“?+?userName?+?“‘“;
????????????????break;
????????????case?“1“:???????????????????????//身份為學生時
????????????????selectStr?=?“Select?*?from?Student?where?Sname?=?‘“?+?userName?+?“‘“;
????????????????break;
????????????case?“2“:???????????????????????//身份為管理員時
????????????????selectStr?=?“Select?*?from?Admin?where?Aname=?‘“?+?userName?+?“‘“;
????????????????break;
????????????case?“3“:???????????????????????//身份為管理員時
????????????????selectStr?=?“Select?*?from?XAdmin?where?XAname=?‘“?+?userName?+?“‘“;
????????????????break;
????????}
????????SqlConnection?conn?=?new?SqlConnection（）;
????????string?strconn?=?“Data?Source=localhost;Initial?Catalog=教務系統;integrated?security=SSPI“;
????????conn.ConnectionString?=?strconn;
????????conn.Open（）;??//打開連接
????????SqlCommand?cmd?=?new?SqlCommand（）;
????????cmd.CommandType?=?CommandType.Text;
????????cmd.Connection?=?conn;
????????cmd.CommandText?=?selectStr;
????????
????????try
????????{
????????????SqlDataReader?sdr?=?cmd.ExecuteReader（）;?//執行查詢
????????????if?（sdr.Read（））?????????????????//如果該用戶存在
????????????{
????????????????if?（sdr.GetString（2）?==?userPwd）?//密碼正確
????????????????{
????????????????????Session[“userName“]?=?txtUserName.Text;
????????????????????Session[“userRole“]?=?rblClass.SelectedItem;
????????????????????
???????????????????
????????????????????switch?（userRole）
????????????????????{
????????????????????????case?“0“:???????????//身份為教師時??????????????
????????????????????????????Response.Write（“ript?language=‘javascript‘>alert（‘登錄成功歡迎使用本教務系統‘）;location.href=‘teacher/TeacherIndex.aspx‘ript>“）;
????????????????????????????break;
????????????????????????case?“1“:???????????//身份為學生時
????????????????????????????Response.Write（“ript?language=‘javascript‘>alert（‘登錄成功歡迎使用本教務系統‘）;location.href=‘student/StudentIndex.aspx‘ript>“）;
????????????????????????????break;
????????????????????????case?“2“:???????????//身份為各部門管理員時
????????????????????????????Response.Write（“ript?language=‘javascript‘>alert（‘登錄成功歡迎使用本教務系統‘）;location.href=‘Admin/Index.aspx‘