public L_UserAccountInfo LoginUser(string LoginName, string userPwd, int userType, string userIP) { SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@nickName", LoginName); param[1] = new SqlParameter("@loginPassWord", userPwd); param[2] = new SqlParameter("@lastLoginIP", userIP); param[3] = new SqlParameter("@userType", userType); param[4] = new SqlParameter("@error", SqlDbType.VarChar, 50); param[4].Direction = ParameterDirection.Output; DataSet set = SqlHelper.ExecuteDateSet(CommandType.StoredProcedure, "p_UserLogin", param); L_UserAccountInfo userinfo = new L_UserAccountInfo(); if (set.Tables.Count == 2) { if (set.Tables[1].Rows.Count > 0) { DataRow drv = set.Tables[1].Rows[0]; userinfo.Userid = Convert.ToInt32(drv["userID"]); if (userType == 1) { userinfo.Username = drv["nickName"].ToString(); } else { userinfo.Username = drv["email"].ToString(); } userinfo.Usertype = Convert.ToInt32(drv["userType"]); } } userinfo.Message = param[4].Value.ToString(); return(userinfo); }
public static string GetUserLogin(string LoginName, string userPwd, int userType, string userIP) { userInfo user = new userInfo(); L_UserAccountInfo userinfo = user.LoginUser(LoginName, userPwd, userType, userIP); if (userinfo == null) { return("用户不存在!!"); } else { if (string.IsNullOrEmpty(userinfo.Message)) { HttpContext.Current.Session["shop8517User"] = userinfo.Userid.ToString(); HttpCookie newcookie = new HttpCookie("shop8517User"); newcookie.Values["userID"] = userinfo.Userid.ToString(); newcookie.Values["userName"] = HttpContext.Current.Server.UrlEncode(userinfo.Username); newcookie.Values["email"] = userinfo.Email; newcookie.Values["userType"] = userinfo.Usertype.ToString(); newcookie.Values["userCartNum"] = ""; //订单编号 newcookie.Path = "/"; HttpContext.Current.Response.AppendCookie(newcookie); return(""); } else { return(userinfo.Message); } } }
/// <summary> /// 实现用户注册信息 /// </summary> /// <param name="userinfo"></param> /// <returns>返回所添加的字符差u那个</returns> public string RegisterUser(L_UserAccountInfo userinfo) { SqlParameter[] para = new SqlParameter[14]; para[0] = new SqlParameter("@nickName", userinfo.Username); para[1] = new SqlParameter("@loginPassWord", userinfo.Password); para[2] = new SqlParameter("@faceID", userinfo.Headid); para[3] = new SqlParameter("@sex", userinfo.Sex); para[4] = new SqlParameter("@age", userinfo.Age); para[5] = new SqlParameter("@country", userinfo.Country); para[6] = new SqlParameter("@provicnce", userinfo.Province); para[7] = new SqlParameter("@phone", userinfo.Phone); para[8] = new SqlParameter("@mobile", userinfo.Mobile); para[9] = new SqlParameter("@email", userinfo.Email); para[10] = new SqlParameter("@qq", userinfo.QQ); para[11] = new SqlParameter("@note", userinfo.Note); para[12] = new SqlParameter("@userID", SqlDbType.Int); para[12].Direction = ParameterDirection.Output; para[13] = new SqlParameter("@error", SqlDbType.Int); para[13].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "p_RegisterUserLogin", para); if (para[13].Value.ToString() == "0") { return(userinfo.Username.ToString()); } else { return(string.Empty); } }
protected void btnreg_Click(object sender, EventArgs e) { string validateNumCode = this.txtCode.Text.Trim().ToLower(); if (Session["validateNum"].ToString().ToLower() == validateNumCode) { if (cbAccept.Checked == true) { L_UserAccountInfo userinfo = new L_UserAccountInfo(); userinfo.Username = txtUserName.Text.Trim(); userinfo.Password = Stringhelp.MD5String(txtPassword.Text.Trim()); userinfo.Headid = 0; userinfo.Sex = ""; userinfo.Age = ""; userinfo.Country = ""; userinfo.Province = ""; userinfo.Phone = ""; userinfo.Mobile = ""; userinfo.Email = txtEmail.Text.Trim(); userinfo.QQ = ""; userinfo.Note = ""; longyuan_userInfo user = new longyuan_userInfo(); string userID = ""; userID = user.RegNewUser(userinfo); Response.Redirect("../proscenium/Index.aspx?userID=" + userID, true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('只有接受陇原网上商城协议用户才能注册');</script>"); } } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('验证码输入错误,请检查!');</script>"); } txtCode.Text = ""; }
public string RegNewUser(L_UserAccountInfo userinfo) { return(user.RegisterUser(userinfo)); }