1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using System.Data.SqlClient;
 11//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
 12
 13public partial class _Default : System.Web.UI.Page 
 14...{
 15     Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 16        override protected void OnInit(EventArgs e)
 17        ...{
 18            //
 19            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 20            //
 21            InitializeComponent();
 22            base.OnInit(e);
 23        }
 24
 25        /**//// <summary>
 26        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 27        /// 此方法的内容。
 28        /// </summary>
 29        private void InitializeComponent()
 30        ...{
 31            
 32
 33
 34        }
 35        #endregion
 36    protected void Page_Load(object sender, EventArgs e)
 37    ...{
 38
 39    }
 40    protected void Btn_Login_Click(object sender, EventArgs e)
 41    ...{
 42
 43        if (TxtUser.Text.Trim() == "")
 44        ...{
 45            Response.Write("<script>alert('登录名不能为空')</script>");
 46            return;
 47        }
 48        user userLogin = new user();
 49        bool isok = false;
 50       
 51        if (rb_admin.Checked)
 52        ...{     
 53            string sql = "select * from Tb_User_Login where isnull(userName,'')='" + TxtUser.Text.Trim() + "' and isnull(userPass,'')='" + TxtPwd.Text.Trim() + "'and isnull(userRole,'')='" + rb_admin.Text+ "'";
 54            SqlDataReader myReader = userLogin.Login(sql);
 55            if (myReader.Read())
 56            ...{
 57                Session["Name"] = myReader["userName"].ToString().Trim();//保存用户名称
 58                Session["Pass"] = myReader["userPass"].ToString().Trim();//保存用户密码
 59                Session["Role"] = myReader["userRole"].ToString().Trim();//保存用户权限.        
 60                isok = true;
 61            }
 62            myReader.Close();
 63        }
 64       else
 65        ...{ 
 66            string sql = "select * from Tb_User_Login where isnull(userName,'')='" + TxtUser.Text.Trim() + "' and isnull(userPass,'')='" + TxtPwd.Text.Trim() + "'and isnull(userRole,'')='" + rb_user.Text+ "'";
 67            SqlDataReader myReader = userLogin.Login(sql);
 68            if (myReader.Read())
 69            ...{
 70                Session["Name"] = myReader["userName"].ToString().Trim();//保存用户名称
 71                Session["Pass"] = myReader["userPass"].ToString().Trim();//保存用户密码
 72                Session["Role"] = myReader["userRole"].ToString().Trim();//保存用户权限.        
 73                isok = true;
 74            }     
 75            myReader.Close();
 76        }
 77
 78
 79
 80           if (!isok)
 81         ...{
 82             lbMessage.Text = "用户名称或密码错误，登陆失败!";
 83              return;
 84         }
 85           else
 86           ...{
 87             Response.Redirect("Index.aspx");
 88          }
 89    }
 90    protected void Btn_Cancel_Click(object sender, EventArgs e)
 91    ...{
 92        TxtUser.Text = "";
 93        TxtPwd.Text = "";
 94        lbMessage.Text = "";
 95    }
 96    
 97}
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117