protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { SRCom srCom = new SRCom(); int userIdentity = Convert.ToInt32(Request.Form["user_identity"]); string userName = user_name.Text.Trim();//Request.Form[this.user_name.ClientID]; string userMail = user_mail.Text.Trim().ToLower(); string userNumber = user_school_num.Text.Trim(); string userPassword =user_password.Text.Trim(); userPassword = srCom.HashPassword(userPassword); string userPasswordCompare =user_password_compare.Text.Trim(); string userMobile = user_mobile.Text.Trim(); string userCollege = user_college.Text.Trim(); string userMajor =user_major.Text.Trim(); string userPhoto = Request.Form["userPhoto"]; string userIntro = Request.Form["userIntro"]; int avatar_x = (int)Convert.ToDouble(Request.Form["avatar_x"]); int avatar_y = (int)Convert.ToDouble(Request.Form["avatar_y"]); int avatar_w = (int)Convert.ToDouble(Request.Form["avatar_w"]); int avatar_h = (int)Convert.ToDouble(Request.Form["avatar_h"]); string img = Request.Form["img"].ToString(); string oldImg = Request.Form["old_img"].ToString(); string avatarMini = ""; string avatar = ""; string avataOriginal = ""; if (avatar_w > 0) { SRCutImage sweet_cutimg = new SRCutImage(avatar_x, avatar_y, avatar_w, avatar_h, 120, 120); sweet_cutimg.imgSaveFolder = @"/slip/Sources/Portraits/Mini/"; avatarMini = sweet_cutimg.Sweet_Cut(img); avatar = srCom.MoveFile(img, @"/slip/Sources/Portraits/"); avataOriginal = srCom.MoveFile(oldImg, @"/slip/Sources/Portraits/Original/"); } string postTime = DateTime.Now.ToString(); SRSql srSql = new SRSql(); srSql.conn.Open(); srSql.cmd.CommandText = "insert into userTB " + "( userName, userMail, userNumber, userIdentity, userPWD, userMobile, userCollege, userMajor, PostTime,avatarMini,avatar,avataOriginal) VALUES " + "(@userName,@userMail,@userNumber,@userIdentity,@userPWD,@userMobile,@userCollege,@userMajor,@PostTime,@avatarMini,@avatar,@avataOriginal) "; srSql.cmd.Parameters.AddWithValue("@userName", userName == null ? "" : userName); srSql.cmd.Parameters.AddWithValue("@userMail", userMail == null ? "" : userMail); srSql.cmd.Parameters.AddWithValue("@userNumber", userNumber == null ? "" : userNumber); srSql.cmd.Parameters.AddWithValue("@userIdentity", userIdentity); srSql.cmd.Parameters.AddWithValue("@userPWD", userPassword == null ? "" : userPassword); srSql.cmd.Parameters.AddWithValue("@userMobile", userMobile == null ? "" : userMobile); srSql.cmd.Parameters.AddWithValue("@userCollege", userCollege == null ? "" : userCollege); srSql.cmd.Parameters.AddWithValue("@userMajor", userMajor == null ? "" : userMajor); srSql.cmd.Parameters.AddWithValue("@PostTime", postTime); srSql.cmd.Parameters.AddWithValue("@avatarMini", avatarMini == null ? "" : avatarMini); srSql.cmd.Parameters.AddWithValue("@avatar", avatar == null ? "" : avatar); srSql.cmd.Parameters.AddWithValue("@avataOriginal", avataOriginal == null ? "" : avataOriginal); srSql.cmd.ExecuteNonQuery(); srSql.conn.Close(); Response.Redirect("logOn.aspx?f=new_register"); } }
protected void Page_Load(object sender, EventArgs e) { if ( Session["userID"] != null) { Response.Redirect("Profile"); } if (Request.QueryString["f"] == "new_register") { LabelNewUserTip.Text = "您已经注册成功,请登陆!"; } if (Request.QueryString["f"] == "unlogin") { LabelNewUserTip.Text = "您未登录,请登陆!"; } #region 处理提交数据 if (IsPostBack) { string returnUrl = Request.QueryString["reurl"]; SRCom srCom = new SRCom(); string userAccount = user_account.Text.Trim(); string userPWD = srCom.HashPassword(user_password.Text.Trim()); SRSql srSql = new SRSql(); srSql.conn.Open(); srSql.cmd.CommandText = "select * from userTB where (userMail=@userMail or userNumber=@userNumber or userMobile=@userMobile) order by userID"; srSql.cmd.Parameters.AddWithValue("@userMail", userAccount); srSql.cmd.Parameters.AddWithValue("@userNumber", userAccount); srSql.cmd.Parameters.AddWithValue("@userMobile", userAccount); srSql.da.Fill(srSql.ds, "tb_login_user"); srSql.conn.Close(); int userAmount = 0; int userAccountAmount = srSql.ds.Tables["tb_login_user"].Rows.Count; foreach (DataRow dataRow in srSql.ds.Tables["tb_login_user"].Rows) { if (dataRow["userPWD"].ToString() == userPWD) { userAmount++; Session["userID"] = dataRow["userID"].ToString(); Session["userName"] = dataRow["userName"].ToString(); Session["userIdentity"] = dataRow["userIdentity"].ToString(); Session["userAvatar"] = dataRow["avatarMini"].ToString(); Session.Timeout = 100; } } if (userAmount > 1) { this.LabelLoginUserTip.Text = "该账号存在两个,请更换帐号登陆!"; Session.Abandon(); } else { if (userAccountAmount == 0) { this.LabelLoginUserTip.Text = "该账号不存在!"; Session.Abandon(); } else { if (userAmount < 1) { this.LabelLoginUserTip.Text = "密码错误!"; Session.Abandon(); } else { if (returnUrl == "" || returnUrl == null) { Response.Redirect("Profile"); } else { Response.Redirect(returnUrl); } } } } } #endregion }