/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(FindPwd model)
{
try
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@uid", SqlDbType.Int, 4),
new SqlParameter("@username", SqlDbType.VarChar, 50),
new SqlParameter("@oldpwd", SqlDbType.VarChar, 100),
new SqlParameter("@newpwd", SqlDbType.VarChar, 100),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@addtimer", SqlDbType.DateTime)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.uid;
parameters[2].Value = model.username;
parameters[3].Value = model.oldpwd;
parameters[4].Value = model.newpwd;
parameters[5].Value = model.status;
parameters[6].Value = model.addtimer;
rowsAffected = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_findpwd_add", parameters);
return((int)parameters[0].Value);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(0);
}
}
public void SelEmail()
{
string username = HttpUtility.HtmlDecode(Request.QueryString["name"].ToString());
string email = HttpUtility.HtmlDecode(Request.QueryString["email"].ToString());
if (!ValidateValidateCode())
{
Response.Write("验证码错误，请重新输入");
return;
}
else
{
int i = SetMail.FindPwdByEmail(username, email, out Msg);
if (i == 0)
{
string[] str = FindPwd.SelPwdByEmailandName(username, email, out Msg);
string Pwd = CryptographyUtil.Decrypt(str[1].ToString());
string CustId = str[0].ToString();
int y = SetMail.InsertEmailSendMassage(CustId, "2", "您的密码是:" + Pwd, "", 1, email, DateTime.Now, "找回密码", "中国电信号码百事通：找回密码", 0, out Msg);
Response.Write(y);
}
else
{
Response.Write(Msg);
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool FindSucess(FindPwd model)
{
try
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@uid", SqlDbType.Int, 4),
new SqlParameter("@newpwd", SqlDbType.VarChar, 100),
new SqlParameter("@status", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.uid;
parameters[2].Value = model.newpwd;
parameters[3].Value = model.status;
rowsAffected = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_findpwd_success", parameters);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(false);
}
}
protected void SetAuthenPhoneBtn_Click(object sender, EventArgs e)
{
LoginPassword = Request["LoginPassword"];
Phone = Request["Phone"];
AuthenCode = Request["AuthenCode"];
CheckCode = Request["CheckCode"];
// 校验LoginPassword
try
{
if (!CommonUtility.ValidateValidateCode(HttpUtility.HtmlDecode(CheckCode), this.Context))
{
errorHint.InnerHtml = "<script type='text/javascript'>showError('验证码校验未通过！')</script>";
return;
}
else
{
string webpwd = CryptographyUtil.Encrypt(LoginPassword);
int i = FindPwd.SelState(CustID, webpwd, out ErrMsg);
if (i != 0)
{
errorHint.InnerHtml = "<script type='text/javascript'> $('#LoginPassword').attr('value','" + LoginPassword + "');$('#Phone').attr('value','" + Phone + "');$('#AuthenCode').attr('value','" + AuthenCode + "');$('#CheckCode').attr('value','" + CheckCode + "');showError('登录密码输入错误，请重新输入！')</script>";
return;
}
else
{
Result = PhoneBO.SelSendSMSMassage(CustID, Phone, AuthenCode, out ErrMsg); // 校验手机验证码
if (Result == 0)
{
Result = PhoneBO.PhoneSetV2(SPID, CustID, Phone, "2", "2", out ErrMsg);
if (Result == 0)
{
//跳转
errorHint.InnerHtml = "<script type='text/javascript'>showError('认证手机设置成功！')</script>";
//Response.Redirect("m.114yg.cn",true);
return;
}
else
{
errorHint.InnerHtml = "<script type='text/javascript'>showError('" + ErrMsg + "！')</script>";
return;
}
}
else
{
errorHint.InnerHtml = "<script type='text/javascript'>showError('" + ErrMsg + "！')</script>";
return;
}
}
}
}
catch (Exception exp)
{
errorHint.InnerHtml = "<script type='text/javascript'>showError('" + exp.ToString() + "！')</script>";
return;
}
}
public void findpwd()
{
List <string> list = new List <string>();
string massage = null;
int type = Convert.ToInt32(HttpUtility.HtmlDecode(Request.QueryString["type"].ToString()));
string phone = HttpUtility.HtmlDecode(Request.QueryString["phone"].ToString());
string SPID = HttpUtility.HtmlDecode(Request.QueryString["spid"].ToString());
string IP = HttpUtility.HtmlDecode(Request.QueryString["ip"].ToString());
if (!ValidateValidateCode())
{
Response.Write("验证码错误，请重新输入");
return;
}
else
{
list = FindPwd.SelTypeFindPassWord(type, phone, out Msg);
if (list[0].ToString() == "-30009")
{
Response.Write("voicePassword.aspx");
return;
}
if (list[0].ToString() == "0")
{
string y = list[2].ToString();
if (type == 1)
{
massage = "您的语音密码为：" + y;
return;
}
else if (type == 2)
{
massage = "您的Web密码为：" + y;
}
FindPwd.InsertFindPwdLog(list[1].ToString(), list[3].ToString(), Convert.ToString(type), "2", phone, 0, SPID, IP, "...", out Msg);
//CommonBizRules.SendMessage(phone, massage, SPID);
CommonBizRules.SendMessageV3(phone, massage, SPID);
Response.Write("0");
}
else
{
Response.Write(list[4].ToString());
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static FindPwd GetModel(int id)
{
try
{
SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) };
parameters[0].Value = id;
FindPwd model = new FindPwd();
DataSet ds = DataBase.ExecuteDataset(CommandType.StoredProcedure, "proc_findpwd_GetModel", parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["uid"].ToString() != "")
{
model.uid = int.Parse(ds.Tables[0].Rows[0]["uid"].ToString());
}
model.username = ds.Tables[0].Rows[0]["username"].ToString();
model.oldpwd = ds.Tables[0].Rows[0]["oldpwd"].ToString();
model.newpwd = ds.Tables[0].Rows[0]["newpwd"].ToString();
if (ds.Tables[0].Rows[0]["status"].ToString() != "")
{
model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
}
if (ds.Tables[0].Rows[0]["addtimer"].ToString() != "")
{
model.addtimer = DateTime.Parse(ds.Tables[0].Rows[0]["addtimer"].ToString());
}
return(model);
}
else
{
return(null);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(null);
}
}
public void selEmail()
{
string msg = "";
string Email = HttpUtility.HtmlDecode(Request.QueryString["email"].ToString());
string CustId = HttpUtility.HtmlDecode(Request.QueryString["custid"].ToString());
string Spid = HttpUtility.HtmlDecode(Request.QueryString["SPID"].ToString());
string Pwd = HttpUtility.HtmlDecode(Request.QueryString["pwd"].ToString());
string webpwd = CryptographyUtil.Encrypt(Pwd);
int i = FindPwd.SelState(CustId, webpwd, out msg);
if (!ValidateValidateCode())
{
Response.Write("验证码错误，请重新输入");
return;
}
else
{
if (i != 0)
{
Response.Write("登录密码输入错误，请重新输入");
return;
}
else
{
k = SetMail.EmailSel(CustId, Email, Spid, out msg);
if (k == 0)
{
string a = CommonBizRules.EncryptEmailURl(CustId, Email, HttpContext.Current);
string url = "点击完成认证:<a href='" + a + "'>" + a + "</a>";
Random random = new Random();
string AuthenCode = random.Next(111111, 999999).ToString();
y = SetMail.InsertEmailSendMassage(CustId, "2", url, AuthenCode, 1, Email, DateTime.Now, "描述", "中国电信号码百事通：激活邮箱", 0, out msg);
Response.Write(y);
}
else
{
Response.Write(msg);
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FindPwd model)
{
try
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@uid", SqlDbType.Int, 4),
new SqlParameter("@username", SqlDbType.VarChar, 50),
new SqlParameter("@oldpwd", SqlDbType.VarChar, 100),
new SqlParameter("@newpwd", SqlDbType.VarChar, 100),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@addtimer", SqlDbType.DateTime)
};
parameters[0].Value = model.id;
parameters[1].Value = model.uid;
parameters[2].Value = model.username;
parameters[3].Value = model.oldpwd;
parameters[4].Value = model.newpwd;
parameters[5].Value = model.status;
parameters[6].Value = model.addtimer;
rowsAffected = DataBase.ExecuteNonQuery("proc_findpwd_Update", parameters);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(false);
}
}
/// <summary>
/// 作者：赵锐
/// 日期：2009年8月15日
/// </summary>
public void setMobile()
{
string ErrMsg = "";
string mnum = HttpUtility.HtmlDecode(Request.QueryString["mnum"].ToString());
string auth = HttpUtility.HtmlDecode(Request.QueryString["auth"].ToString());
string custid = HttpUtility.HtmlDecode(Request.QueryString["custid"].ToString());
string spid = HttpUtility.HtmlDecode(Request.QueryString["spid"].ToString());
string pwd = HttpUtility.HtmlDecode(Request.QueryString["pwd"].ToString());
string webpwd = CryptographyUtil.Encrypt(pwd);
int i = FindPwd.SelState(custid, webpwd, out ErrMsg); // 根据custid和webpwd 校验客户身份是否合法性
if (!ValidateValidateCode()) //校验页面验证码
{
Response.Write("验证码错误，请重新输入");
return;
}
else
{
if (i != 0)
{
Response.Write("登录密码输入错误，请重新输入");
return;
}
else
{
k = PhoneBO.SelSendSMSMassage(custid, mnum, auth, out msg); // 校验手机验证码
if (k == 0)
{
//int y = PhoneBO.PhoneSet(spid, custid, mnum, "2", "2", out msg);
int y = PhoneBO.PhoneSetV2(spid, custid, mnum, "2", "2", out msg);
Response.Write(k);
}
else
{
Response.Write(msg);
}
}
}
}
public void bbb()
{
string CustID = HttpUtility.HtmlDecode(Request.QueryString["custID"].ToString());
string AuthenNumber = HttpUtility.HtmlDecode(Request.QueryString["name"].ToString());
string CustType = HttpUtility.HtmlDecode(Request.QueryString["custType"].ToString());
string Pwd = HttpUtility.HtmlDecode(Request.QueryString["pwd"].ToString());
string PwdType = "2";
string SPID = "35000000";
int Result1 = 0;
int Result2 = 0;
string ErrorDescription = "";
string ExtendField = "";
string ErrMsg = "";
string IPAddress = "";
try
{
//数据合法性判断
if (CommonUtility.IsEmpty(CustID))
{
Result1 = ErrorDefinition.BT_IError_Result_InValidCustID_Code;
ErrorDescription = ErrorDefinition.BT_IError_Result_InValidCustID_Msg + "不能为空";
}
if (CustID.Length > ConstDefinition.Length_CustID)
{
Result1 = ErrorDefinition.BT_IError_Result_InValidCustID_Code;
ErrorDescription = ErrorDefinition.BT_IError_Result_InValidCustID_Msg + "长度有误";
}
if (CommonUtility.IsEmpty(Pwd))
{
Result1 = ErrorDefinition.BT_IError_Result_InValidProvinceID_Code;
ErrorDescription = ErrorDefinition.BT_IError_Result_InValidProvinceID_Msg;
}
//数据库操作
Result1 = PassWordBO.SetPassword(SPID, CustID, Pwd, PwdType, ExtendField, out ErrorDescription);
}
catch (Exception e)
{
Result1 = ErrorDefinition.IError_Result_System_UnknowError_Code;
ErrorDescription = ErrorDefinition.IError_Result_System_UnknowError_Msg + e.Message;
}
try
{
if (Context.Request.ServerVariables["HTTP_VIA"] != null) // using proxy
{
IPAddress = Context.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString(); // Return real client IP.
}
else// not using proxy or can't get the Client IP
{
IPAddress = Context.Request.ServerVariables["REMOTE_ADDR"].ToString(); //While it can't get the Client IP, it will return proxy IP.
}
Result2 = FindPwd.InsertFindPwdLog(CustID, CustType, "0", "1", AuthenNumber, Result1, SPID, IPAddress, "", out ErrMsg);
}
catch (Exception e)
{
Result2 = ErrorDefinition.IError_Result_System_UnknowError_Code;
ErrorDescription = ErrorDefinition.IError_Result_System_UnknowError_Msg + e.Message;
}
Response.Write(Result1);
}
private void BtnForgetPwd_Click(object sender, EventArgs e)
{
FindPwd.Show();
}
/// <summary>
/// 通过邮箱找回密码
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public String FindPwdByEmail(String SPID, String Email)
{
StringBuilder ResponseMsg = new StringBuilder();
Int32 Result = ErrorDefinition.BT_IError_Result_UnknowError_Code;
String ErrMsg = ErrorDefinition.BT_IError_Result_UnknowError_Msg;
String CustID = String.Empty;
if (CommonUtility.IsEmpty(SPID))
{
// 返回错误信息
ResponseMsg.Length = 0;
if ("json".Equals(wt))
{
ResponseMsg.Append("{");
ResponseMsg.AppendFormat("\"errcode\":\"{0}\",", "995");
ResponseMsg.AppendFormat("\"errmsg\":\"{0}\"", "SPID不能为空！");
ResponseMsg.Append("}");
}
else
{
ResponseMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
ResponseMsg.Append("<PayPlatRequestParameter>");
ResponseMsg.Append("<PARAMETERS>");
ResponseMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "995");
ResponseMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", "SPID不能为空！");
ResponseMsg.Append("</PARAMETERS>");
ResponseMsg.Append("</PayPlatRequestParameter>");
}
return(ResponseMsg.ToString());
}
if (CommonUtility.IsEmpty(Email))
{
// 返回错误信息
ResponseMsg.Length = 0;
if ("json".Equals(wt))
{
ResponseMsg.Append("{");
ResponseMsg.AppendFormat("\"errcode\":\"{0}\",", "996");
ResponseMsg.AppendFormat("\"errmsg\":\"{0}\"", "Email不能为空！");
ResponseMsg.Append("}");
}
else
{
ResponseMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
ResponseMsg.Append("<PayPlatRequestParameter>");
ResponseMsg.Append("<PARAMETERS>");
ResponseMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "996");
ResponseMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", "Email不能为空！");
ResponseMsg.Append("</PARAMETERS>");
ResponseMsg.Append("</PayPlatRequestParameter>");
}
return(ResponseMsg.ToString());
}
try
{
Result = SetMail.EmailSel(Email, out CustID, out ErrMsg);
if (Result != 0)
{
ResponseMsg.Length = 0;
if ("json".Equals(wt))
{
ResponseMsg.Append("{");
ResponseMsg.AppendFormat("\"errcode\":\"{0}\",", "997");
ResponseMsg.AppendFormat("\"errmsg\":\"{0}\"", "认证邮箱有误！");
ResponseMsg.Append("}");
}
else
{
ResponseMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
ResponseMsg.Append("<PayPlatRequestParameter>");
ResponseMsg.Append("<PARAMETERS>");
ResponseMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "997");
ResponseMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", "认证邮箱有误！");
ResponseMsg.Append("</PARAMETERS>");
ResponseMsg.Append("</PayPlatRequestParameter>");
}
return(ResponseMsg.ToString());
}
else
{
string encryptPwd = "";
string Pwd = "";
Result = FindPwd.SelPwdByEmailV2(Email, out encryptPwd, out ErrMsg);
if (Result == 0)
{
Pwd = CryptographyUtil.Decrypt(encryptPwd);
Result = SetMail.InsertEmailSendMassage(CustID, "2", "您的密码是:" + Pwd, "", 1, Email, DateTime.Now, "找回密码", "中国电信号码百事通：找回密码", 0, out ErrMsg);
if (Result == 0)
{
ResponseMsg.Length = 0;
if ("json".Equals(wt))
{
ResponseMsg.Append("{");
ResponseMsg.AppendFormat("\"errcode\":\"{0}\",", "0");
ResponseMsg.AppendFormat("\"errmsg\":\"{0}\"", "邮件发送成功！");
ResponseMsg.Append("}");
}
else
{
ResponseMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
ResponseMsg.Append("<PayPlatRequestParameter>");
ResponseMsg.Append("<PARAMETERS>");
ResponseMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "0");
ResponseMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", "邮件发送成功！");
ResponseMsg.Append("</PARAMETERS>");
ResponseMsg.Append("</PayPlatRequestParameter>");
}
return(ResponseMsg.ToString());
}
else
{
ResponseMsg.Length = 0;
if ("json".Equals(wt))
{
ResponseMsg.Append("{");
ResponseMsg.AppendFormat("\"errcode\":\"{0}\",", "-930");
ResponseMsg.AppendFormat("\"errmsg\":\"{0}\"", ErrMsg);
ResponseMsg.Append("}");
}
else
{
ResponseMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
ResponseMsg.Append("<PayPlatRequestParameter>");
ResponseMsg.Append("<PARAMETERS>");
ResponseMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "-930");
ResponseMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", ErrMsg);
ResponseMsg.Append("</PARAMETERS>");
ResponseMsg.Append("</PayPlatRequestParameter>");
}
return(ResponseMsg.ToString());
}
}
else
{
//密码找回失败
ResponseMsg.Length = 0;
if ("json".Equals(wt))
{
ResponseMsg.Append("{");
ResponseMsg.AppendFormat("\"errcode\":\"{0}\",", "-940");
ResponseMsg.AppendFormat("\"errmsg\":\"{0}\"", ErrMsg);
ResponseMsg.Append("}");
}
else
{
ResponseMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
ResponseMsg.Append("<PayPlatRequestParameter>");
ResponseMsg.Append("<PARAMETERS>");
ResponseMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "-940");
ResponseMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", ErrMsg);
ResponseMsg.Append("</PARAMETERS>");
ResponseMsg.Append("</PayPlatRequestParameter>");
}
return(ResponseMsg.ToString());
}
}
}
catch (Exception exp)
{
ResponseMsg.Length = 0;
if ("json".Equals(wt))
{
ResponseMsg.Append("{");
ResponseMsg.AppendFormat("\"errcode\":\"{0}\",", "-950");
ResponseMsg.AppendFormat("\"errmsg\":\"{0}\"", exp.ToString());
ResponseMsg.Append("}");
}
else
{
ResponseMsg.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
ResponseMsg.Append("<PayPlatRequestParameter>");
ResponseMsg.Append("<PARAMETERS>");
ResponseMsg.AppendFormat("<ErrCode>{0}</ErrCode>", "-950");
ResponseMsg.AppendFormat("<ErrMsg>{0}</ErrMsg>", exp.ToString());
ResponseMsg.Append("</PARAMETERS>");
ResponseMsg.Append("</PayPlatRequestParameter>");
}
return(ResponseMsg.ToString());
}
return(ResponseMsg.ToString());
}
//更新个人信息
private void InformationUpdate_Click(object sender, EventArgs e)
{
FindPwd.Show();
FindPwd.SetText(u.UserName);
}