登录
//dal
public static UserInfo Select(string name, string pwd)
{
var sql = $“select * from UserInfo where name=’{name}’ and pwd=’{pwd}’”;
var table = DB.select(sql);
if (table == null || table.Rows.Count < 1)
{
return null;
}
var row = table.Rows[0];
UserInfo user = new UserInfo()
{
Id = Convert.ToInt32(row[“Id”]),
Name = Convert.ToString(row[“Name”]),
Role = Convert.ToInt32(row[“Role”])
};
return user;
}
//点击登录
protected void btnLogin_Click(object sender, EventArgs e)
{
var user = UserInfobll.Select(txtName.Text, txtPwd.Text);
if (user == null)
{
Response.Write(“”);
}
else if (user.Role == 0)
{
//用户
Response.Redirect(“list.aspx”);
}
else if (user.Role == 1)
{
//管理员
Response.Redirect(“add.aspx”);
}
}