vs实现用户注册登录_用户注册和登录的实现

 public static UserInfo GetUser(string name, string pwd)
        {
        //填写搜索姓名和密码的sql语句
            string sql = string.Format("select * from UserInfo where LoginName='{0}' and Password='{1}'", name, pwd);
            DataTable dt = DBHelper.ExcuteTable(sql);
            //判断数据是否为空
            if (dt.Rows.Count > 0)
            {
            对用户名和密码，角色进行检查
                UserInfo model = new UserInfo();
                model.UserID = Convert.ToInt32(dt.Rows[0]["UserID"]);
                model.LoginName = Convert.ToString(dt.Rows[0]["LoginName"]);
                model.Password = Convert.ToString(dt.Rows[0]["Password"]);
                model.UserRole = Convert.ToInt32(dt.Rows[0]["UserRole"]);

                return model;
            }
            return null;
        }

 public static UserInfo GetUser(string name, string pwd)
        {
            return UserInfoDAL.GetUser(name, pwd);
        }

//登录按钮的单击事件
//根据用户名和密码查出的角色进行分类
 protected void btn_login_Click(object sender, EventArgs e)
        {
            string uname = this.tb_name.Text;
            string pwd = this.tb_pwd.Text;
            UserInfo model = UserInfoBLL.GetUser(uname, pwd);
            if (model != null)
            {
                if (model.UserRole == 1)
                {
                    Response.Redirect("LeaveList.aspx");

                }
                else
                {
                    Response.Redirect("LeaveApply.aspx?uid="+model.UserID);

                }
            }
            else
            {
                Response.Write("<script>alert('登陆失败')</script>");
            }
        }