DAL层
public static Administrator A_login(string id = null, string pwd = null)
{
var sql = $"select * from Administrator where Aid='{id}' and Password='{pwd}'";
var dt = DBHelper.ExcuteTable(sql);
if (dt == null || dt.Rows.Count < 1)
{
return null;
}
var row = dt.Rows[0];
Administrator admin = new Administrator()
{
Aid = Convert.ToInt32(row["Aid"]),
Aname= Convert.ToString(row["Aname"]),
Password = Convert.ToString(row["Password"]),
UserID = Convert.ToInt32(row["UserID"])
};
return admin;
}
BLL层
public static Administrator A_login(string id = null, string pwd = null)
{
return AdministratorDAL.A_login(id, pwd);
}
UI层
protected void btn_login_Click(object sender, EventArgs e)
{
if (this.tb_id.Text == "")
{
Response.Write("<script>alert('请输入账号!')</script>");
return;
}if (this.tb_pwd.Text == "")
{
Response.Write("<script>alert('请输入密码!')</script>");
return;
}
string id = this.tb_id.Text;
string pwd = this.tb_pwd.Text;
Administrator dt = AdministratorBLL.A_login(id, pwd);
if (dt != null && ddl_user.SelectedValue==Convert.ToString(dt.UserID))
{
Response.Redirect("Admin/Admin.aspx?id=" + dt.Aid);
}
else
{
Response.Write("<script>alert('登录失败')</script>");
}
}
跳转页面根据id查询
UI层
string id = Request.QueryString["id"];
Administrator dt = AdministratorBLL.getlist(id);
this.lb_id.Text =Convert.ToString(dt.Aid);
this.lb_name.Text = Convert.ToString(dt.Aname);
this.lb_user.Text = Convert.ToString(dt.UserName);
bll层
public static Administrator getlist(string id = null)
{
return AdministratorDAL.getlist(id);
}
dal层
public static Administrator getlist(string id = null)
{
var sql = $"select * from Administrator a inner join UserRole b on a.UserID=b.UserID where Aid='{id}'";
DataTable dt = DBHelper.ExcuteTable(sql);
if (dt.Rows.Count > 0)
{
Administrator model = new Administrator();
model.Aid = Convert.ToInt32(dt.Rows[0]["Aid"]);
model.Aname = dt.Rows[0]["Aname"].ToString();
model.Password = dt.Rows[0]["Password"].ToString();
model.UserID = Convert.ToInt32(dt.Rows[0]["UserID"]);
model.UserName = dt.Rows[0]["UserName"].ToString();
return model;
}
return null;
}