62,046
社区成员
发帖
与我相关
我的任务
分享
Session["Status"] = sdr["Status"].ToString();
if (Session["Status"]!= null)
{
ArrayList list = (ArrayList)Session["Status"];
if (list.Contains("1"))
{
Permission = false;
Response.Redirect("Default.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=StudentManager;Integrated Security=True");
SqlCommand cmd = new SqlCommand("select * from Userss where UserName='" + UserName.Text + "'", conn); //创建查询用户名是否存在数据对象
try
{
conn.Open(); //打开连接
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read()) //如果用户名输入正确
{
if (sdr["UserPassword"].ToString() ==PassWord.Text)//密码正确
{
conn.Close();
Session["UserName"] = UserName.Text.Trim();//存储用户名
bool Permission = true;
if (Session["Status"] != null)
{
ArrayList list = (ArrayList)Session["Status"];
if (list.Contains("1"))
{
Permission = false;
Response.Redirect("Default.aspx");
}
}
if (Permission)
{
Response.Clear();
Response.Write("<script language=\"javascript\">alert(\"对不起你没有权限进入\");history.go(-1);</script>");
Response.End();
}
//Response.Redirect("Default.aspx"); //进入系统
}
else
{
Response.Write("<script language=javascript>alert('您输入的密码错误!')</script>");
}
}
else
{
Response.Write("<script language=javascript>alert('您输入的用户名错误或该用户名不存在!')</script>");
}
}
catch (System.Exception ee)
{
Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
}
finally
{
conn.Close();
}
}
}
//权限角色表检查
if(Session["log"]==null)
{
//添加权限
ArrayList list = new xxxx(Name);//得到权限列表,naem为用户名
Session["log"] = list;
}
#region 权限检查
bool Permission = true;
if (Session["log"] != null)
{
ArrayList list = (ArrayList)Session["log"];
if (list.Contains("1")//本页需要权限1才可以进入)
{
Permission = false;
}
}
if (Permission)
{
Response.Clear();
Response.Write("<script language=\"javascript\">alert(\"对不起你没有权限进入\");history.go(-1);</script>");
Response.End();
}
#endregion