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