一,DAL
public static Admin GetUser(string username,string pwd)
{
string sql = $“select *from Admin where A_name=@username and password=@pwd”;
SqlParameter[] sqlParameter =
{
new SqlParameter("@username",username),
new SqlParameter("@pwd",pwd)
};
DataTable dt = DBHelper.ExcuteTable(sql, sqlParameter);
//判断数据是否为空
if (dt.Rows.Count > 0)
{
//对用户名和密码,角色进行检查
Admin model = new Admin();
model.A_name = Convert.ToString(dt.Rows[0][“A_name”]);
model.password = Convert.ToString(dt.Rows[0][“password”]);
return model;
}
return null;
}
二,BLL
public static Admin GetUser(string username, string pwd)
{
return AdminDAL.GetUser(username, pwd);
}
三,UI
protected void btn_login_Click(object sender, EventArgs e)
{
var username = tb_username.Text;
var pwd = tb_pwd.Text;
Admin model = AdminBLL.GetUser(username, pwd);
if (model==null)
{
Response.Write(“”);
Response.Redirect(“index.aspx”);
}