protected void sub_btn_ServerClick(object sender, EventArgs e)
{
//获取用户名和密码
string username = UserName.Value;
string pwd = Pwd.Value;
bool tag = true;
if (username == "")
{
Response.Write("<script>alert('用户名不能为空！！！')</script>");
tag = false;
}
else if (pwd == "")
{
Response.Write("<script>alert('密码不能为空！！！')</script>");
tag = false;
}
if (tag)
{
AdminBLL admin = new AdminBLL();
Adminor a1 = admin.Login(username, pwd);
if (a1 != null)
{
Response.Redirect("index.aspx");
}
else
{
Response.Write("<script>alert('用户名不存在或者密码错误！！！')</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//接收参数
int id = int.Parse(Request["id"]);
if (id > 0)
{
admin = bll.adminsel(id);
if (!IsPostBack)
{
txtUserName.Value = admin.UserName;
}
}
}
//用户查询 按id查询
public Adminor adminsel(int id)
{
string sql = "select * from Admin where Id=@id";
SqlParameter[] sps =
{
new SqlParameter("@Id", id)
};
DataTable dt = SqlHelper.ExeDataTable(sql, sps);
Adminor model = null;
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
model = DataRowToModel(dr);
}
return(model);
}
public Adminor Login(string username, string pwd)
{
string sql = "select * from Admin where username=@username and password=@pwd";
SqlParameter[] sps =
{
new SqlParameter("@username", username),
new SqlParameter("@pwd", pwd)
};
DataTable dt = SqlHelper.ExeDataTable(sql, sps);
Adminor model = null;
//如果查询后的这个结果表里面有值 说明登陆成功
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
model = DataRowToModel(dr);
}
return(model);
}
public Adminor DataRowToModel(DataRow dr)
{
Adminor model = new Adminor();
if (dr["Id"] != DBNull.Value)
{
model.Id = Convert.ToInt32(dr["Id"]);
}
if (dr["username"] != DBNull.Value)
{
model.UserName = dr["username"].ToString();
}
if (dr["password"] != DBNull.Value)
{
model.PassWord = dr["password"].ToString();
}
if (dr["state"] != DBNull.Value)
{
model.State = Convert.ToInt32(dr["state"]);
}
return(model);
}
