Пример #1
0
            /// <summary>
            /// 得到一个对象实体 by SQLpara
            /// </summary>
            public Lebi_User_Answer GetModel(SQLPara para)
            {
                StringBuilder strSql = new StringBuilder();

                strSql.Append("select top 1 * from [Lebi_User_Answer] ");
                if (para.Where != "")
                {
                    strSql.Append(" where " + para.Where + "");
                }
                Lebi_User_Answer model = new Lebi_User_Answer();
                DataSet          ds    = SqlUtils.SqlUtilsInstance.TextExecuteDataset(strSql.ToString(), para.Para);

                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());
                    }
                    model.Answer = ds.Tables[0].Rows[0]["Answer"].ToString();
                    if (ds.Tables[0].Rows[0]["User_Question_id"].ToString() != "")
                    {
                        model.User_Question_id = int.Parse(ds.Tables[0].Rows[0]["User_Question_id"].ToString());
                    }
                    if (ds.Tables[0].Rows[0]["User_id"].ToString() != "")
                    {
                        model.User_id = int.Parse(ds.Tables[0].Rows[0]["User_id"].ToString());
                    }
                    return(model);
                }
                else
                {
                    return(null);
                }
            }
Пример #2
0
        /// <summary>
        /// 修改支付密码
        /// </summary>
        public void SetPayPassword()
        {
            string PWD  = RequestTool.RequestSafeString("Pay_Password");
            string PWD1 = RequestTool.RequestSafeString("Pay_Password1");
            string PWD2 = RequestTool.RequestSafeString("Pay_Password2");

            PWD = EX_User.MD5(PWD);
            if (PWD != CurrentUser.Pay_Password && CurrentUser.Pay_Password != "")
            {
                Response.Write("{\"msg\":\"" + Tag("原始密码错误") + "\"}");
                return;
            }
            else
            {
                Lebi_User_Answer user_answer = B_Lebi_User_Answer.GetModel("User_id= " + CurrentUser.id);
                if (user_answer == null)
                {
                    Response.Write("{\"msg\":\"" + Tag("请先设置安全问题") + "\"}");
                    return;
                }
            }
            CurrentUser.Pay_Password = EX_User.MD5(PWD1);
            B_Lebi_User.Update(CurrentUser);
            Response.Write("{\"msg\":\"OK\"}");
        }
Пример #3
0
            /// <summary>
            /// 增加一条数据
            /// </summary>
            public int Add(Lebi_User_Answer model)
            {
                StringBuilder strSql = new StringBuilder();

                strSql.Append("insert into [Lebi_User_Answer](");
                strSql.Append("Answer,User_Question_id,User_id)");
                strSql.Append(" values (");
                strSql.Append("@Answer,@User_Question_id,@User_id)");
                strSql.Append(";select @@IDENTITY");
                SqlParameter[] parameters =
                {
                    new SqlParameter("@Answer",           model.Answer),
                    new SqlParameter("@User_Question_id", model.User_Question_id),
                    new SqlParameter("@User_id",          model.User_id)
                };

                object obj = SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);

                if (obj == null)
                {
                    return(1);
                }
                else
                {
                    return(Convert.ToInt32(obj));
                }
            }
Пример #4
0
 /// <summary>
 /// 安全方式绑定对象表单
 /// </summary>
 public Lebi_User_Answer SafeBindForm(Lebi_User_Answer model)
 {
     if (HttpContext.Current.Request["Answer"] != null)
     {
         model.Answer = Shop.Tools.RequestTool.RequestSafeString("Answer");
     }
     if (HttpContext.Current.Request["User_Question_id"] != null)
     {
         model.User_Question_id = Shop.Tools.RequestTool.RequestInt("User_Question_id", 0);
     }
     if (HttpContext.Current.Request["User_id"] != null)
     {
         model.User_id = Shop.Tools.RequestTool.RequestInt("User_id", 0);
     }
     return(model);
 }
Пример #5
0
            /// <summary>
            /// 更新一条数据
            /// </summary>
            public void Update(Lebi_User_Answer model)
            {
                StringBuilder strSql = new StringBuilder();

                strSql.Append("update [Lebi_User_Answer] set ");
                strSql.Append("[Answer]=@Answer,");
                strSql.Append("[User_Question_id]=@User_Question_id,");
                strSql.Append("[User_id]=@User_id");
                strSql.Append(" where id=" + model.id);
                OleDbParameter[] parameters =
                {
                    new OleDbParameter("@Answer",           model.Answer),
                    new OleDbParameter("@User_Question_id", model.User_Question_id),
                    new OleDbParameter("@User_id",          model.User_id)
                };

                AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
            }
Пример #6
0
            /// <summary>
            /// 增加一条数据
            /// </summary>
            public int Add(Lebi_User_Answer model)
            {
                StringBuilder strSql = new StringBuilder();

                strSql.Append("insert into [Lebi_User_Answer](");
                strSql.Append("[Answer],[User_Question_id],[User_id])");
                strSql.Append(" values (");
                strSql.Append("@Answer,@User_Question_id,@User_id)");
                OleDbParameter[] parameters =
                {
                    new OleDbParameter("@Answer",           model.Answer),
                    new OleDbParameter("@User_Question_id", model.User_Question_id),
                    new OleDbParameter("@User_id",          model.User_id)
                };

                AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
                return(1);
            }
Пример #7
0
        /// <summary>
        /// 编辑安全问题
        /// </summary>
        public void Question_Edit()
        {
            if (!EX_Admin.Power("user_edit", "编辑会员"))
            {
                AjaxNoPower();
            }
            int    id           = RequestTool.RequestInt("id", 0);
            int    Question_id1 = RequestTool.RequestInt("Question_id1", 0);
            int    Question_id2 = RequestTool.RequestInt("Question_id2", 0);
            string Answer1      = EX_User.MD5(RequestTool.RequestSafeString("Answer1"));
            string Answer2      = EX_User.MD5(RequestTool.RequestSafeString("Answer2"));

            if (Question_id1 == Question_id2)
            {
                Response.Write("{\"msg\":\"" + Tag("请选择两个不同的问题") + "\"}");
                return;
            }
            if (Answer1 == "" || Answer2 == "")
            {
                Response.Write("{\"msg\":\"" + Tag("请填写问题答案") + "\"}");
                return;
            }
            Lebi_User_Answer model = B_Lebi_User_Answer.GetModel("User_id = " + id + "");

            if (model == null)
            {
                model = new Lebi_User_Answer();
                model.User_Question_id = Question_id1;
                model.Answer           = Answer1;
                model.User_id          = id;
                B_Lebi_User_Answer.Add(model);
                model.User_Question_id = Question_id2;
                model.Answer           = Answer2;
                model.User_id          = id;
                B_Lebi_User_Answer.Add(model);
                Log.Add("添加安全问题", "User_Answer", id.ToString(), CurrentAdmin, id.ToString());
            }
            Response.Write("{\"msg\":\"OK\"}");
        }
Пример #8
0
            /// <summary>
            /// 对象实体绑定数据
            /// </summary>
            public Lebi_User_Answer ReaderBind(IDataReader dataReader)
            {
                Lebi_User_Answer model = new Lebi_User_Answer();
                object           ojb;

                ojb = dataReader["id"];
                if (ojb != null && ojb != DBNull.Value)
                {
                    model.id = (int)ojb;
                }
                model.Answer = dataReader["Answer"].ToString();
                ojb          = dataReader["User_Question_id"];
                if (ojb != null && ojb != DBNull.Value)
                {
                    model.User_Question_id = (int)ojb;
                }
                ojb = dataReader["User_id"];
                if (ojb != null && ojb != DBNull.Value)
                {
                    model.User_id = (int)ojb;
                }
                return(model);
            }
Пример #9
0
            /// <summary>
            /// 更新一条数据
            /// </summary>
            public void Update(Lebi_User_Answer model)
            {
                StringBuilder strSql = new StringBuilder();

                strSql.Append("update [Lebi_User_Answer] set ");
                strSql.Append("Answer= @Answer,");
                strSql.Append("User_Question_id= @User_Question_id,");
                strSql.Append("User_id= @User_id");
                strSql.Append(" where id=@id");
                SqlParameter[] parameters =
                {
                    new SqlParameter("@id",               SqlDbType.Int,       4),
                    new SqlParameter("@Answer",           SqlDbType.NVarChar, 50),
                    new SqlParameter("@User_Question_id", SqlDbType.Int,       4),
                    new SqlParameter("@User_id",          SqlDbType.Int, 4)
                };
                parameters[0].Value = model.id;
                parameters[1].Value = model.Answer;
                parameters[2].Value = model.User_Question_id;
                parameters[3].Value = model.User_id;

                SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
            }
Пример #10
0
            /// <summary>
            /// 得到一个对象实体 by id
            /// </summary>
            public Lebi_User_Answer GetModel(int id)
            {
                StringBuilder strSql = new StringBuilder();

                strSql.Append("select  top 1  * from [Lebi_User_Answer] ");
                strSql.Append(" where id=@id");
                SqlParameter[] parameters =
                {
                    new SqlParameter("@id", SqlDbType.Int, 4)
                };
                parameters[0].Value = id;

                Lebi_User_Answer model = new Lebi_User_Answer();
                DataSet          ds    = SqlUtils.SqlUtilsInstance.TextExecuteDataset(strSql.ToString(), 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());
                    }
                    model.Answer = ds.Tables[0].Rows[0]["Answer"].ToString();
                    if (ds.Tables[0].Rows[0]["User_Question_id"].ToString() != "")
                    {
                        model.User_Question_id = int.Parse(ds.Tables[0].Rows[0]["User_Question_id"].ToString());
                    }
                    if (ds.Tables[0].Rows[0]["User_id"].ToString() != "")
                    {
                        model.User_id = int.Parse(ds.Tables[0].Rows[0]["User_id"].ToString());
                    }
                    return(model);
                }
                else
                {
                    return(null);
                }
            }
Пример #11
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public static void Update(Lebi_User_Answer model)
 {
     D_Lebi_User_Answer.Instance.Update(model);
 }
Пример #12
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public static int Add(Lebi_User_Answer model)
 {
     return(D_Lebi_User_Answer.Instance.Add(model));
 }
Пример #13
0
 /// <summary>
 /// 安全方式绑定表单数据
 /// </summary>
 public static Lebi_User_Answer SafeBindForm(Lebi_User_Answer model)
 {
     return(D_Lebi_User_Answer.Instance.SafeBindForm(model));
 }
Пример #14
0
        /// <summary>
        /// 编辑安全问题
        /// </summary>
        public void Question_Edit()
        {
            int    type         = RequestTool.RequestInt("type", 0);
            int    Question_id1 = RequestTool.RequestInt("Question_id1", 0);
            int    Question_id2 = RequestTool.RequestInt("Question_id2", 0);
            string Answer1      = EX_User.MD5(RequestTool.RequestSafeString("Answer1"));
            string Answer2      = EX_User.MD5(RequestTool.RequestSafeString("Answer2"));

            if (Question_id1 == Question_id2)
            {
                Response.Write("{\"msg\":\"" + Tag("请选择两个不同的问题") + "\"}");
                return;
            }
            if (Answer1 == "" || Answer2 == "")
            {
                Response.Write("{\"msg\":\"" + Tag("请填写问题答案") + "\"}");
                return;
            }
            bool             addflag = false;
            Lebi_User_Answer model   = B_Lebi_User_Answer.GetModel("User_id = " + CurrentUser.id + "");

            if (model == null)
            {
                addflag = true;
                model   = new Lebi_User_Answer();
            }
            if (addflag)
            {
                model.User_Question_id = Question_id1;
                model.Answer           = Answer1;
                model.User_id          = CurrentUser.id;
                B_Lebi_User_Answer.Add(model);
                model.User_Question_id = Question_id2;
                model.Answer           = Answer2;
                model.User_id          = CurrentUser.id;
                B_Lebi_User_Answer.Add(model);
            }
            else
            {
                int i = 0;
                List <Lebi_User_Answer> modellists = B_Lebi_User_Answer.GetList("User_id = " + CurrentUser.id + "", "id asc");
                foreach (Lebi_User_Answer modellist in modellists)
                {
                    if (i == 0 && modellist.Answer != Answer1)
                    {
                        Response.Write("{\"msg\":\"" + Tag("问题答案回答不正确") + "\"}");
                        return;
                    }
                    if (i == 1 && modellist.Answer != Answer2)
                    {
                        Response.Write("{\"msg\":\"" + Tag("问题答案回答不正确") + "\"}");
                        return;
                    }
                    i++;
                }
                if (type == 1)
                {
                    CurrentUser.Pay_Password = "";
                    B_Lebi_User.Update(CurrentUser);
                    Response.Write("{\"msg\":\"OK\",\"type\":\"1\",\"url\":\"" + URL("P_UserChangePassword", "") + "\"}");
                    return;
                }
                else
                {
                    B_Lebi_User_Answer.Delete("User_id = " + CurrentUser.id + "");
                }
            }
            Response.Write("{\"msg\":\"OK\",\"type\":\"0\"}");
        }
Пример #15
0
        /// <summary>
        /// 忘记密码的处理
        /// </summary>
        public void User_forgetpwd()
        {
            int    type       = RequestTool.RequestInt("type", 0);
            string Email_     = RequestTool.RequestSafeString("Email");
            string UserName   = RequestTool.RequestSafeString("UserName");
            string verifycode = RequestTool.RequestString("verifycode");

            if (SYS.Verifycode_ForgetPassword == "1")
            {
                if (CurrentCheckCode != verifycode)
                {
                    Response.Write("{\"msg\":\"" + Tag("验证码错误") + "\"}");
                    return;
                }
            }
            if (type == 0)
            {
                //发送邮件
                Lebi_User user = B_Lebi_User.GetModel("Email=lbsql{'" + Email_ + "'}");
                if (user == null)
                {
                    Response.Write("{\"msg\":\"" + Tag("用户不存在") + "\"}");
                    return;
                }
                try
                {
                    //发送邮件
                    Email.SendEmail_forgetpwd(user, CurrentTheme);
                    //发送短信
                    SMS.SendSMS_forgetpwd(user);
                }
                catch (Exception ex)
                {
                    Response.Write("{\"msg\":\"" + ex.Message + "\"}");
                }
                Response.Write("{\"msg\":\"OK\"}");
            }
            else if (type == 1)
            {
                Lebi_User user = B_Lebi_User.GetModel("UserName=lbsql{'" + UserName + "'}");
                if (user == null)
                {
                    Response.Write("{\"msg\":\"" + Tag("用户不存在") + "\"}");
                    return;
                }
                Lebi_User_Answer user_answer = B_Lebi_User_Answer.GetModel("User_id= " + user.id);
                if (user_answer == null)
                {
                    Response.Write("{\"msg\":\"" + Tag("未设置安全问题") + "\"}");
                    return;
                }
                BaseConfig conf = ShopCache.GetBaseConfig();
                user.CheckCode = EX_User.MD5(System.DateTime.Now.ToString() + conf.InstallCode);
                B_Lebi_User.Update(user);
                Response.Write("{\"msg\":\"OK\",\"url\":\"" + ThemeUrl.GetURL("P_FindPassword", "", "", user.Language) + "?id=" + user.id + "&v=" + user.CheckCode + "&type=1\"}");
            }
            else if (type == 2)
            {
                Lebi_User user = B_Lebi_User.GetModel("UserName=lbsql{'" + UserName + "'}");
                if (user == null)
                {
                    Response.Write("{\"msg\":\"" + Tag("用户不存在") + "\"}");
                    return;
                }
                if (user.MobilePhone == "")
                {
                    Response.Write("{\"msg\":\"" + Tag("未设置手机号码") + "\"}");
                    return;
                }
                Random Random  = new Random();
                int    RandNum = Random.Next(100000, 999999);
                user.Password = EX_User.MD5(RandNum.ToString());
                B_Lebi_User.Update(user);
                //发送短信
                SMS.SendSMS_newpwd(user, RandNum.ToString());
                Response.Write("{\"msg\":\"OK\",\"url\":\"" + ThemeUrl.GetURL("P_Login", "", "", user.Language) + "\"}");
            }
        }