DAL层
public static userinfo select(string name,string pwd)
{
//构建查询语句 = 不能like
var sql=$"select * from userinfo where name={name} and pwd={pwd}";
var dt=DBHelper.Query(sql);
//如果没有数据 null
if (dt == null || dt.Rows.Count<1)
{
return null;
}
//如果有数据,取第一行,转换为对象
var row=dt.Rows[0];
UserInfo user = new UserInfo()
{
Id = Convert. ToInt32 (row["Id"]),
Name = Convert. ToString (row[’Name"]),
Role = Convert. ToInt32 (row["Role"])
};
return user;
BLL层
public static userinfo select(string name,string pwd)
{
return userinfoDAL.select(name,pwd);
}
UI层
protected void btnLogin_Click(object sender, EventArgs e)
{
var user=userinfoBLL.Select(tb_name.Text,tb_pwd.Text);
if(user==null)
{
Response.Write(“<script>alert('账号或密码不正确')</script>”)
}
else if(user.Role==0)
{
//用户
}
else if(user.Role==1)
{
//管理员
}
}
web页面
<connectionStrings>
<add name="sql" connectionString="Data Source=.;Iitial Catalog=Test;Integrated Security=true" providerName=""/>
</connectionStrings>