protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
check ck = new check();
data_conn cn = new data_conn();
string sql = "";
sql = sql + "select * ";
sql = sql + "from TB_User ";
sql = sql + "where UserName = '******'";
DataSet ds = new DataSet();
ds = cn.mdb_ds(sql, "T_User");
if (ds.Tables["T_User"].Rows.Count > 0)
{
MessageBox("opfail", "用户名已有人使用");
return;
}
else if (UserPassword.Value.Length < 6 || UserPassword.Value.Length > 15)
{
MessageBox("opfail", "密码长度必须在6～15个字符之间");
return;
}
else if (Company.Value == "" || RealName.Value == "" || Phone.Value == "" || UserEmail.Value == "")
{
MessageBox("opfail", "必填项不能为空");
return;
}
else if (!isEmail(UserEmail.Value))
{
MessageBox("opfail", "邮箱格式不正确");
return;
}
else if (UserPassword.Value != UserPassword2.Value)
{
MessageBox("opfail", "2次密码不一致");
return;
}
else if (!Checkbox1.Checked)
{
MessageBox("opfail", "请仔细阅读并同意服务条款");
return;
}
string recommendUserID;
if (this.Request.Cookies["recommendUserID"] == null)
{
recommendUserID = "0";
}
else
{
if (this.Request.Cookies["recommendUserID"].Value == "")
{
recommendUserID = "0";
}
else
{
recommendUserID = Request.Cookies["recommendUserID"].Value;
}
}
if (this.Request.Cookies["UID"] == null)
{
}
else
{
if (Request.Cookies["UID"].Value == "")
{
}
else
{
data_conn Uidcn = new data_conn();
DataSet Uidds = Uidcn.mdb_ds("select UserID from TB_User where UCenterHomeUid=" + Request.Cookies["UID"].Value, "uid");
if (Uidds.Tables["uid"].Rows.Count == 1)
{
recommendUserID = Uidds.Tables["uid"].Rows[0][0].ToString();
mysqldata_conn mycn = new mysqldata_conn();
mycn.mdb_exe("update uchome_space set credit=credit+10 where uid=" + Request.Cookies["UID"].Value);
}
}
}
sql = "";
sql += "INSERT INTO ";
sql += "TB_User ";
sql += "(";
sql += "UserName, ";
sql += "UserPassword, ";
sql += "UserEmail, ";
sql += "UserPoint, ";
sql += "RealName, ";
sql += "IfPass, ";
sql += "ifvip, ";
sql += "ifmanage, ";
sql += "CompanyName, ";
sql += "Phone, ";
sql += "Regtime)";
sql += "VALUES ";
sql += "(";
sql += "'" + ck.CheckInput(UserName.Value.ToString()) + "', ";
sql += "'" + ck.CheckInput(UserPassword.Value.ToString()) + "', ";
sql += "'" + ck.CheckInput(UserEmail.Value.ToString()) + "', ";
sql += "0, ";
sql += "'" + ck.CheckInput(RealName.Value.ToString()) + "', ";
sql += "1, ";
sql += "1, ";
sql += "0, ";
sql += "'" + ck.CheckInput(Company.Value.ToString()) + "', ";
sql += "'" + ck.CheckInput(Phone.Value.ToString()) + "', ";
sql += "'" + ck.CheckInput(DateTime.Now.ToString()) + "' ";
sql += ")";
cn.mdb_exe(sql);
sql = "SELECT * FROM TB_User WHERE UserName = '******'";
ds = cn.mdb_ds(sql, "user");
string sql_account = "insert into TB_ORDER_ACCOUNT (userid) VALUES (" + ds.Tables["user"].Rows[0]["UserID"].ToString() + ")";
cn.mdb_exe(sql_account);
//增加账户信息
AllinOrder AllinOrder1 = new AllinOrder();
AllinOrder1.SetOrderTry(ds.Tables["user"].Rows[0]["UserID"].ToString());
if (ds.Tables["user"].Rows.Count != 0)
{
try
{
points p = new points();
p.AddNewPoints(ds.Tables["user"].Rows[0]["UserID"].ToString());
}
catch (Exception ex)
{
}
string userid = ds.Tables["user"].Rows[0]["UserID"].ToString();
string usernm = ds.Tables["user"].Rows[0]["UserName"].ToString();
string ifvip = ds.Tables["user"].Rows[0]["ifvip"].ToString();
string ifmanage = ds.Tables["user"].Rows[0]["ifmanage"].ToString();
string realname = ds.Tables["user"].Rows[0]["realname"].ToString();
string useremail = ds.Tables["user"].Rows[0]["useremail"].ToString();
Response.Cookies["user_id"].Value = userid;
Response.Cookies["user_name"].Value = Server.UrlEncode(usernm);
Response.Cookies["ifvip"].Value = ifvip;
Response.Cookies["ifmanage"].Value = ifmanage;
Response.Cookies["user_id"].Expires = DateTime.Now.AddDays(365);
Response.Cookies["user_name"].Expires = DateTime.Now.AddDays(365);
Response.Cookies["ifvip"].Expires = DateTime.Now.AddDays(365);
Response.Cookies["ifmanage"].Expires = DateTime.Now.AddDays(365);
Response.Cookies["realname"].Value = Server.UrlEncode(realname);
Response.Cookies["useremail"].Value = Server.UrlEncode(useremail);
Response.Cookies["realname"].Expires = DateTime.Now.AddDays(365);
Response.Cookies["useremail"].Expires = DateTime.Now.AddDays(365);
if (recommendUserID != "0")
{
cn.mdb_exe("insert into T_FRIEND (UID,FID) values (" + userid + "," + recommendUserID + ")");
cn.mdb_exe("insert into T_FRIEND (UID,FID) values (" + recommendUserID + "," + userid + ")");
Mark mark = new Mark();
mark.MarkOperate(Convert.ToInt32(recommendUserID), 10, "推荐会员", Convert.ToInt32(userid));
}
mysqldata_conn mysqlcn = new mysqldata_conn();
DataSet dscount = mysqlcn.mdb_ds("select * from uc_members where username='******'", "ucenter");
if (dscount.Tables["ucenter"].Rows.Count == 0)
{
Random r = new Random();
string salt = r.Next().ToString().Substring(0, 6);
string username = usernm;
string password = MD5(MD5(ds.Tables["user"].Rows[0]["UserPassword"].ToString()) + salt);
string email = ds.Tables["user"].Rows[0]["UserEmail"].ToString();
string myid = "";
string myidkey = "";
string regip = Page.Request.UserHostAddress;
string regdate = UnixTimestamp();
string lastloginip = "0";
string lastlogintime = "0";
string id = this.insert(username, "8fc24ae194289b94e36272a5f9882611", email, myid, myidkey, regip, regdate, lastloginip, lastlogintime, "594882");
if (id != "")
{
mysqlcn.mdb_exe("insert into uchome_member (uid,username,password) values (" + id + ",'','" + MD5(id + "|" + UnixTimestamp()) + "')");
mysqlcn.mdb_exe("insert into uc_memberfields (uid,blacklist) values (" + id + ",'')");
string myemail;
string qq;
string msn;
if (ds.Tables["user"].Rows[0]["UserEmail"].ToString() != "")
{
myemail = ds.Tables["user"].Rows[0]["UserEmail"].ToString();
}
else
{
myemail = "";
}
qq = "";
msn = "";
mysqlcn.mdb_exe("insert into uchome_spacefield (uid,email,qq,msn,blood,birthprovince,birthcity,resideprovince,residecity,note,spacenote,authstr,theme,css,privacy,friend,feedfriend,sendmail) values (" + id + ",'" + myemail + "','" + qq + "','" + msn + "','','','','','','','','','','','','','','')");
//插入实名
string namestatus = "0";
//实名
mysqlcn.mdb_exe("insert into uchome_space (uid,groupid,username,name,namestatus,domain,dateline,ip) values (" + id + ",5,'" + username + "',''," + namestatus + ",''," + UnixTimestamp() + ",'" + Page.Request.UserHostAddress + "')");
cn.mdb_exe("update TB_User set UCenterHomeUid=" + id + " where UserId=" + userid);
//在ucenter中添加推荐好友
if (Request.Cookies["UID"] == null)
{
}
else
{
if (Request.Cookies["UID"].Value == "")
{
}
else
{
string gid = "0";
if (this.Request.Cookies["g"] == null)
{
}
else
{
if (Request.Cookies["g"].Value == "")
{
}
else
{
gid = Request.Cookies["g"].Value;
try
{
int g = Convert.ToInt32(gid);
if (g > 0 && g < 8)
{
gid = g.ToString();
}
else
{
gid = "0";
}
}
catch (Exception ex)
{
gid = "0";
}
}
}
DataSet myUidds = mysqlcn.mdb_ds("select username from uc_members where uid=" + Request.Cookies["UID"].Value, "uid");
mysqlcn.mdb_exe("insert into uchome_friend (uid,fuid,fusername,status,gid,note,dateline) values (" + id + "," + Request.Cookies["UID"].Value + ",'" + myUidds.Tables["uid"].Rows[0][0].ToString() + "',1,0,''," + UnixTimestamp() + ")");
mysqlcn.mdb_exe("insert into uchome_friend (uid,fuid,fusername,status,gid,note,dateline) values (" + Request.Cookies["UID"].Value + "," + id + ",'" + username + "',1," + gid + ",''," + UnixTimestamp() + ")");
mysqlcn.mdb_exe("insert into uc_friends (uid,friendid,direction,comment) values (" + id + "," + Request.Cookies["UID"].Value + ",3,'')");
mysqlcn.mdb_exe("insert into uc_friends (uid,friendid,direction,comment) values (" + Request.Cookies["UID"].Value + "," + id + ",3,'')");
}
}
}
}
Response.Cookies["useremail"].Value = UserEmail.Value.ToString();
try
{
SendEmail(UserName.Value.ToString(), UserPassword.Value.ToString(), UserEmail.Value.ToString(), "GB");
}
catch (Exception ex)
{
Response.Redirect("trysuccess.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
AllinOrder AllinOrder1 = new AllinOrder();
GetRequest GetRequest1 = new GetRequest();
string u = GetRequest1.GetRequestCookies("user_id", "0");
if (u == "0")
{
}
else
{
if (AllinOrder1.GetOrderTry(u) == "success")
{
Response.Redirect("tryalready.aspx");
}
else
{
AllinOrder1.SetOrderTry(u);
Response.Redirect("trysuccess.aspx");
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
check ck = new check();
string username = ck.CheckInput(txtUsername.Value);
string password = ck.CheckInput(txtPassword.Value);
string autologin = "******";
if (chkAutoLogin.Checked == true)
{
autologin = "******";
}
else
{
autologin = "******";
}
if (username == "" && password == "")
{
MessageBox("opfail", "未填写用户名和密码");
}
else
{
if (username == "")
{
MessageBox("opfail", "未填写用户名");
}
if (password == "")
{
MessageBox("opfail", "未填写密码");
}
}
data_conn cn = new data_conn();
DataSet ds = new DataSet();
string sql = "";
sql = sql + "SELECT ";
sql = sql + "UserID,UserName,ifvip,ifmanage ";
sql = sql + "FROM ";
sql = sql + "TB_User ";
sql = sql + "WHERE ";
sql = sql + "UserName = '******' ";
sql = sql + "AND UserPassword = '******' ";
ds = cn.mdb_ds(sql, "user");
if (ds.Tables["user"].Rows.Count > 0)
{
string userid = ds.Tables["user"].Rows[0][0].ToString();
string usernm = ds.Tables["user"].Rows[0][1].ToString();
string ifvip = ds.Tables["user"].Rows[0]["ifvip"].ToString();
string ifmanage = ds.Tables["user"].Rows[0]["ifmanage"].ToString();
Response.Cookies["user_id"].Value = userid;
Response.Cookies["user_name"].Value = Server.UrlEncode(usernm);
Response.Cookies["user_password"].Value = password;
Response.Cookies["ifvip"].Value = ifvip;
Response.Cookies["ifmanage"].Value = ifmanage;
if (autologin == "1")
{
Response.Cookies["user_id"].Expires = DateTime.Now.AddDays(365);
Response.Cookies["user_name"].Expires = DateTime.Now.AddDays(365);
Response.Cookies["user_password"].Expires = DateTime.Now.AddDays(365);
Response.Cookies["ifvip"].Expires = DateTime.Now.AddDays(365);
Response.Cookies["ifmanage"].Expires = DateTime.Now.AddDays(365);
}
AllinOrder AllinOrder1 = new AllinOrder();
GetRequest GetRequest1 = new GetRequest();
string u = GetRequest1.GetRequestCookies("user_id", "0");
if (AllinOrder1.GetOrderTry(u) == "success")
{
Response.Redirect("tryalready.aspx");
}
else
{
AllinOrder1.SetOrderTry(u);
Response.Redirect("trysuccess.aspx");
}
}
else
{
MessageBox("opfail", "用户名或密码填写错误");
}
}
