protected void rptFriends_ItemCommand(object source, RepeaterCommandEventArgs e)
{
myClass myclass = new myClass();
int id = Convert.ToInt32(Session["id"].ToString());
if (e.CommandName == "Add")
{
int _id = Convert.ToInt32(e.CommandArgument.ToString());
string sql1 = "select * from Friends where me='" + id + "' and friends = '" + _id + "'";
int count = myclass.JudgeAcc(sql1);
if (count > 0)
{
Response.Write("<script>alert('好友已存在！')</script>");
}
else
{
string name = myclass.RerdName(id);
string _name = myclass.RerdName(_id);
string sql = "insert into Friends (me,friends,myname,friendname) values('" + id + "','" + _id + "','" + name + "','" + _name + "')";
string _sql = "insert into Friends (me,friends,myname,friendname) values('" + _id + "','" + id + "','" + _name + "','" + name + "')";
int flag = myclass.DataSQL(sql);
int _flag = myclass.DataSQL(_sql);
if (flag == 1 && _flag == 1)
{
Response.Write("<script>alert('添加成功！')</script>");
}
else
{
Response.Write("<script>alert('添加失败！')</script>");
}
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
myClass myclass = new myClass();
string id = userid.Text;
string pwd = userpwd.Text;
if (id.Length == 0 || pwd.Length == 0 || id.Length >= 12)
{
Response.Write("<script>alert('请正确输入用户信息！')</script>");
}
else
{
pwd = MD5(pwd);
string sql = "select * from UserList where id='" + id + "'and pwd='" + pwd + "'";
int count = myclass.JudgeAcc(sql);
if (Session["CheckCode"] != null)
{
string checkcode = Session["CheckCode"].ToString();
if (TextBox1.Text != checkcode)
{
Response.Write("<script>alert('验证码错误！')</script>");
}
else if (count <= 0)
{
Response.Write("<script>alert('登陆错误！')</script>");
}
else
{
Response.Write("<script>alert('登陆成功！');location='Home.aspx'</script>");
Session["id"] = id;
}
}
}
}
protected void btnRegister_Click1(object sender, EventArgs e)
{
myClass myclass = new myClass();
string pwd = NewPwd.Text;
string repwd = reNewPwd.Text;
string email = Email.Text;
string phone = Phone.Text;
string name = Name.Text;
string sculpture = "Album/picture/timg.jpg";
string sex = rdlSex.SelectedValue;
//string province =
if (pwd.Length == 0 || repwd.Length == 0 || email.Length == 0 || phone.Length == 0 || name.Length == 0 || sex.Length == 0)
{
Response.Write("<script>alert('输入不能为空！')</script>");
}
else
{
string sql1 = "select * from UserList where phone='" + phone + "'";
string sql2 = "select * from UserList where email='" + email + "'";
string sql4 = "select * from UserList where phone='" + phone + "'";
int count1 = (myclass.JudgeIor(sql1)).Rows.Count;
int count2 = (myclass.JudgeIor(sql2)).Rows.Count;
if (Session["CheckCode"] != null)
{
string checkcode = Session["CheckCode"].ToString();
if (TextBox1.Text != checkcode)
{
Response.Write("<script>alert('验证码错误！')</script>");
}
else if (String.Compare(pwd, repwd) != 0)
{
Response.Write("<script>alert('前面密码两次错误！')</script>");
}
else if (count1 > 0)
{
Response.Write("<script>alert('手机号码已被绑定！')</script>");
}
else if (count2 > 0)
{
Response.Write("<script>alert('邮箱已被验证！')</script>");
}
else
{
pwd = MD5(pwd);
int count = 1, rad = 0;
while (count > 0)
{
Int32 x = 1000000;
Random Random = new System.Random();
rad = Random.Next(x, x * 10);
string sql = "select * from UserList where id = '" + rad + "'";
count = myclass.JudgeAcc(sql);
}
string sql3 = "insert into UserList (id,name,pwd,email,phone,sculpture,sex) values('" + rad + "','" + name + "','" + pwd + "','" + email + "','" + phone + "','" + sculpture + "','" + sex + "')";
int flag = myclass.DataSQL(sql3);
if (flag != 1)
{
Response.Write("<script>alert('注册失败！')</script>");
}
else
{
DataTable dt = new DataTable();
dt = myclass.JudgeIor(sql4);
string id = dt.Rows[0][0].ToString();
string sql = "insert into LogClass (classfyname,logowner) values('默认分类','" + id + "')";
myclass.DataSQL(sql);
Session["id"] = id;
Session["name"] = name;
Response.Write("<script>alert('注册成功！');location='Register/RegisterSuccess.aspx'</script>");
}
}
}
}
}