62,041
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ad_name"] == null)
{
Panel2.Visible = false;//如果没有登录则panel隐藏
}
}
protected void Button1_Click(object sender, EventArgs e)
{
admin a = new admin();
admininfo ai = new admininfo();
if (ai.Login(TextBox1.Text, TextBox2.Text))
{
Session["ad_name"] = TextBox1.Text.Trim();
Label1.Text = "this.TextBox1.Text";
Panel1.Visible = false;
Panel2.Visible = true;
if (rblselect.SelectedItem.Text.Equals("管理员"))
{
}
else if (rblselect.SelectedItem.Text.Equals("教师"))
{
}
else if (rblselect.SelectedItem.Text.Equals("学生"))
{
}
else
{
}
}
else
{
Response.Write("<script>alert('用户名或密码错误!')</script>");
}
}
}
public bool Login(string name, string number)//登录的验证
{
string sql = " select ad_number from admin where ad_name!=''and type=!''";
SqlDataReader dr = DBOperate.getReader(sql);
bool flag = false;
if (dr.Read())
{
if (dr["ad_number"].ToString().Trim().Equals(number))
{
flag = true;
}
}
return flag;
}
}
SELECT A.* FROM [UserInfo] A INNER JOIN [RoleInfo] B ON A.RoleId = B.RoleId WHERE A.UserName = @UserName AND A.Password = @Password AND B.RoleId = @RoleId
上面语句中表名、字段名用实际名字替换