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));
}
