/// <summary> /// 品搜用户自动注册名录宝用户 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-23</remarks> public int Pinsou_AutoRegister(E_PinsouUser data) { SqlParameter[] parms = { new SqlParameter("@pinsou_UserID", SqlDbType.BigInt), new SqlParameter("@Email", SqlDbType.VarChar, 128), new SqlParameter("@UserType", SqlDbType.TinyInt), new SqlParameter("@Status", SqlDbType.TinyInt), new SqlParameter("@Password", SqlDbType.VarChar, 128), new SqlParameter("@Mobile", SqlDbType.VarChar, 11), new SqlParameter("@Fax", SqlDbType.VarChar, 64), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@PersonalID", SqlDbType.Int) }; parms[0].Value = data.Pinsou_UserID; parms[1].Value = data.Email; parms[2].Value = UserType.个人用户; parms[3].Value = MLMGC.DataEntity.User.UserStatus.启用; parms[4].Value = data.Password; parms[5].Value = data.Mobile; parms[6].Value = data.Fax; parms[7].Direction = ParameterDirection.Output; parms[8].Direction = ParameterDirection.Output; int ReturnValue; DbHelperSQL.RunProcedures("Pinsou_UserInfo_AutoRegister", parms, out ReturnValue); data.mlb_UserID = Convert.ToInt32(parms[7].Value); data.PersonalID = Convert.ToInt32(parms[8].Value); return(ReturnValue); }
protected void Page_Load(object sender, EventArgs e) { //获取品搜数据 long id = Requests.GetQueryLong("id", 0); long userid = Requests.GetQueryLong("userid", 0); string username = Requests.GetQueryString("username"); E_PinsouUser data = new E_PinsouUser(); data.ID = id; data.Pinsou_UserID = userid; data.UserName = username; //查询登录信息 DataTable dt = new T_User().Pinsou_AutoLogin(data); if (dt != null && dt.Rows.Count == 1)//验证通过 { string name = dt.Rows[0]["Email"].ToString(); string pwd = dt.Rows[0]["password"].ToString(); Login(name, pwd); } else //验证失败 { Jscript.ShowMsg("信息错误无法登录!", this); return; } }
protected void Page_Load(object sender, EventArgs e) { //获取品搜用户数据 long userid = Requests.GetQueryLong("userid", 0); string username = Requests.GetQueryString("username"); E_PinsouUser data = new E_PinsouUser(); data.Pinsou_UserID = userid; data.UserName = username; //去品搜数据库验证用户编号和用户名是否正确 DataTable dt = new T_User().Pinsou_Verification(data); //判断用户编号和用户名是否正确 if (dt != null && dt.Rows.Count == 1) { DataRow row = dt.Rows[0]; string email = row["Email"].ToString(); //再判断邮箱是否存在 if (string.IsNullOrEmpty(email)) { Jscript.ShowMsg("邮箱不存在,无法注册!", this); return; } //验证通过后,继续注册 data.Pinsou_UserID = Convert.ToInt32(row["userid"]); data.Email = email; data.Password = EncryptString.EncryptPassword(row["password"].ToString()); data.Mobile = row["mobile"].ToString(); data.Fax = row["fax"].ToString(); int result = new T_User().Pinsou_AutoRegister(data); if (result == -1)//邮箱已存在 { Jscript.ShowMsg("邮箱不存在,无法注册!", this); return; } else if (result == 0) //注册失败 { Jscript.ShowMsg("注册失败!", this); return; } else //注册成功直接跳转 { E_PersonalUser dataPU = new E_PersonalUser(); dataPU.UserID = data.mlb_UserID; dataPU.PersonalID = data.PersonalID; dataPU.UserName = data.Email; dataPU.Password = data.Password; new MLMGC.Security.PersonalPage().Login(dataPU); Jscript.AlertAndRedirect(this, "注册成功", "../Personal/Default.aspx"); } } else { Jscript.ShowMsg("用户编号和用户名错误!", this); return; } }
/// <summary> /// 验证品搜用户是否正确 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-23</remarks> public DataTable Pinsou_Verification(E_PinsouUser data) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.BigInt), new SqlParameter("@UserName", SqlDbType.VarChar, 128) }; parms[0].Value = data.Pinsou_UserID; parms[1].Value = data.UserName; return(DbHelperSQL.RunProcedureTable("Pinsou_UserInfo_Verification", parms)); }
/// <summary> /// 品搜用户自动登录 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-23</remarks> public DataTable Pinsou_AutoLogin(E_PinsouUser data) { return(dal.Pinsou_AutoLogin(data)); }
/// <summary> /// 品搜用户自动注册名录宝用户 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-23</remarks> public int Pinsou_AutoRegister(E_PinsouUser data) { return(dal.Pinsou_AutoRegister(data)); }
/// <summary> /// 验证品搜用户是否正确 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-02-23</remarks> public DataTable Pinsou_Verification(E_PinsouUser data) { return(dal.Pinsou_Verification(data)); }