//用户登录 public Modeluser signin(string email, string password) { Modeluser user = new Modeluser(); DataSet data = daluser.queryUserbyEmail(email); if (data.Tables[0].Rows.Count == 0) { Modeluser empty = new Modeluser(); empty.Id = 0; return(empty); } if (0 == (int)data.Tables[0].Rows[0].ItemArray[4]) { Modeluser empty = new Modeluser(); empty.Id = -1; return(empty); } user.Id = (int)data.Tables[0].Rows[0].ItemArray[0]; user.userName = data.Tables[0].Rows[0].ItemArray[1].ToString(); user.userPwd = data.Tables[0].Rows[0].ItemArray[2].ToString(); user.userEmail = data.Tables[0].Rows[0].ItemArray[3].ToString(); if (user.userPwd.Equals(password)) { //密码验证成功,返回user对象 return(user); } else { return(null); } }
//删除用户 public int deleteuser(Modeluser user) { conn.Open(); string sql = "delete from tbuser where user_id=" + user.Id; SqlCommand cmd = new SqlCommand(sql, conn); int temp = cmd.ExecuteNonQuery(); conn.Close(); return(temp); }
//加入用户 public int insertuser(Modeluser user) { conn.Open(); string sql = "insert into tbuser (user_name,user_pwd,user_email)values('" + user.userName + "','" + user.userPwd + "','" + user.userEmail + "')"; SqlCommand cmd = new SqlCommand(sql, conn); int temp = cmd.ExecuteNonQuery(); conn.Close(); return(temp); }
static SqlConnection conn = Conn.getconn();//获取数据库连接 //更新用户 public int updateuser(Modeluser user) { conn.Open(); string sql = "update tbuser SET user_name='" + user.userName + "',user_pwd='" + user.userPwd + "',user_email='" + user.userEmail + "' where user_id=" + user.Id; SqlCommand cmd = new SqlCommand(sql, conn); int temp = cmd.ExecuteNonQuery(); conn.Close(); return(temp); }
//点击注册按钮 protected void sign_up_Click(object sender, EventArgs e) { Modeluser user = new Modeluser(); Blluser blluser = new Blluser(); //判断是否选中了复选框同意条款 if (!this.CheckBox1.Checked) { Response.Write("<script>alert('请同意并勾选隐私条款');</script>"); } else { //获取Textbox中的值 user.userName = this.name.Text; user.userPwd = this.Password.Text; user.userEmail = this.Email.Text; if (user.userName.Equals("") || user.userPwd.Equals("") || user.userEmail.Equals("")) { this.name.Focus(); Response.Write("<script>alert('注册信息不能存在空值');</script>"); } else if (!IsEmail(user.userEmail)) { this.Email.Focus(); Response.Write("<script>alert('请输入有效的邮箱');</script>"); } else if (!Iscan(user.userPwd)) { this.Password.Focus(); Response.Write("<script>alert('密码只能由数字字母和下划线组成');</script>"); } else if (user.userName.Length > 12) { this.name.Focus(); Response.Write("<script>alert('用户名过长');</script>"); } else { //注册该用户 if (!blluser.signup(user))//用户已经注册过 { Response.Write("<script>alert('该邮箱已注册,您可以使用该邮箱登录');</script>"); } else { //跳转到添加个人信息页面 user.Id = blluser.queryUserIdByEmail(user.userEmail); Session.Add("id", user.Id); Response.Redirect("inputuserinfo.aspx"); } } } }
//分页查询用户 public List <Modeluser> pageQueryuser(int offset, int rows) { List <Modeluser> list = new List <Modeluser>(); DataSet set = daluser.pageQueryuser(offset, rows); int num = set.Tables[0].Rows.Count; for (int i = 0; i < num; i++) { Modeluser user = new Modeluser(); user.Id = (int)set.Tables[0].Rows[i].ItemArray[1]; user.userName = set.Tables[0].Rows[i].ItemArray[2].ToString(); user.userEmail = set.Tables[0].Rows[i].ItemArray[4].ToString(); user.userValid = (int)set.Tables[0].Rows[i].ItemArray[5]; list.Add(user); } return(list); }
//用户注册 public bool signup(Modeluser user) { //判断该用户是否已经注册 if (daluser.is_signout(user.userEmail)) { return(false); } else { daluser.insertuser(user); //查询用户注册后的id int userid = daluser.queryUserIdByEmail(user.userEmail); //根据id插入userinfo,favoriteinfo和recommend bllfavorite.insertFavoriteinfo(userid); Modeluserinfo userinfo = new Modeluserinfo(); userinfo.userId = userid; blluserinfo.insertUserInfo(userinfo); bllrecommend.insertline(userid); return(true); } }
protected void signin_Click(object sender, EventArgs e) { //用户登录并跳转到首页 Modeluser user = new Modeluser(); Blluser blluser = new Blluser(); if (IsEmail(this.email.Text) == true) { user = blluser.signin(this.email.Text, this.password.Text); if (user == null) { Response.Write("<script>alert('邮箱或密码错误');</script>"); } else { if (user.Id == 0) { Response.Write("<script>alert('没有该用户,请检查输入是否正确');</script>"); } else if (user.Id == -1) { Response.Write("<script>alert('该用户被封禁,请联系客服人员。');</script>"); } else { Session.Add("userid", user.Id); Session.Add("username", user.userName); Session.Add("userpwd", user.userPwd); Session.Add("useremail", user.userEmail); Response.Redirect("default.aspx"); } } } else { Response.Write("<script>alert('请输入有效的邮箱');</script>"); } }