//用户登录
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>");
}
}
