Пример #1
0
        /// <summary>
        /// 注册限制
        /// </summary>
        /// <returns></returns>
        public static bool RegLimit()
        {
            bool           b    = true;
            List <dbParam> list = new List <dbParam>()
            {
                new dbParam()
                {
                    ParamName = "@ClientIP", ParamValue = WebHelp.GetIP()
                },
            };

            #region  一IP,同一当前日期(年月日),可以确定当天注册次数。
            List <User> uList       = UserDal.m_UserDal.GetList(" ClientIP=@ClientIP", list);
            int         count       = 0;
            string      DateCurrent = string.Format("{0:D}", DateTime.Now);//设置当前日期(年-月-日)
            foreach (var u in uList)
            {
                if (DateCurrent == string.Format("{0:D}", u.CreatedTime))
                {
                    count++;
                }
            }
            #endregion
            if (count >= 3)
            {
                b = false;
            }
            return(b);
        }
Пример #2
0
        /// <summary>
        /// 添加图书评论的回复2
        /// </summary>
        /// <returns></returns>
        public string AddBookCommentReplyAgain()
        {
            int BookRemarkReplyId = int.Parse(context.Request.Form["iBookRemarkReplyId"].ToString());
            //对哪条回复的回复
            BookRemarkReply ReplyTo  = BookDetailsDAL.m_BookRemarkReplyDal.GetModel(BookRemarkReplyId);
            int             UserId   = ReplyTo.UserId;
            string          UserName = "******" + ReplyTo.UserName;
            string          sBookRemarksReplyAgain = context.Request.Form["sBookRemarksReplyAgain"].ToString();

            rm.Success = true;
            try
            {
                BookRemarkReply bookRemarkReply = new BookRemarkReply();
                bookRemarkReply.BookRemarkId     = ReplyTo.BookRemarkId;
                bookRemarkReply.BookId           = ReplyTo.BookId;
                bookRemarkReply.UserId           = UserId;
                bookRemarkReply.BookRemarksReply = sBookRemarksReplyAgain;
                bookRemarkReply.UserName         = UserName;
                bookRemarkReply.ClientIP         = WebHelp.GetIP();
                bookRemarkReply.CreatedTime      = DateTime.Now;
                if (CRegex.FilterHTML(bookRemarkReply.BookRemarksReply) == "")
                {
                    rm.Info = "内容不能为空";
                    return(jss.Serialize(rm));
                }
                int iBookRemarkReplyId = BookDetailsDAL.m_BookRemarkReplyDal.Add(bookRemarkReply);
            }
            catch (Exception)
            {
                rm.Success = false;
                rm.Info    = "未知错误";
            }
            return(jss.Serialize(rm));
        }
Пример #3
0
        /// <summary>
        /// 添加图书评论
        /// </summary>
        /// <returns></returns>
        public string AddBookComment()
        {
            int    BookId      = int.Parse(context.Request.Form["iBookId"].ToString());
            User   u           = UserDal.CurrentUser();
            int    UserId      = u.UserId;
            string UserName    = u.UserName;
            string BookRemarks = context.Request.Form["sBookRemarks"].ToString();

            rm.Success = true;
            try
            {
                BookRemark bookRemark = new BookRemark();
                bookRemark.BookId      = BookId;
                bookRemark.UserId      = UserId;
                bookRemark.BookRemarks = BookRemarks;
                bookRemark.UserName    = UserName;
                bookRemark.ClientIP    = WebHelp.GetIP();
                bookRemark.CreatedTime = DateTime.Now;
                if (CRegex.FilterHTML(bookRemark.BookRemarks) == "")
                {
                    rm.Info = "内容不能为空";
                    return(jss.Serialize(rm));
                }
                int iBookRemarkId = BookDetailsDAL.m_BookRemarkDal.Add(bookRemark);
            }
            catch (Exception)
            {
                rm.Success = false;
                rm.Info    = "未知错误";
            }
            return(jss.Serialize(rm));
        }
Пример #4
0
        /// <summary>
        /// 用户注册
        /// </summary>
        /// <returns></returns>
        public string RegUser()
        {
            string username  = context.Request.Form["username"].ToString();
            string pwd       = context.Request.Form["pwd"].ToString();
            string email     = context.Request.Form["email"].ToString();
            string phonenum  = context.Request.Form["phonenum"].ToString();
            string qq        = context.Request.Form["qq"].ToString();
            string checkcode = context.Request.Form["checkcode"].ToString();

            if (checkcode != context.Session["CheckCode"].ToString())//Session["CheckCode"] = rand;在image.aspx页面设置
            {
                rm.Success = false;
                rm.Info    = "验证码输入不正确";
            }
            else
            {
                try
                {
                    User user = new User();
                    user.UserName    = username;
                    user.Pwd         = pwd;
                    user.Gender      = "男";//默认为男,可在个人中心更改
                    user.Email       = email;
                    user.Tel         = phonenum;
                    user.QQ          = qq;
                    user.Type        = 0;               //1管理员 0普通用户
                    user.ClientIP    = WebHelp.GetIP(); //获取到访问者的IP
                    user.CreatedTime = DateTime.Now;
                    user.HeadPic     = "man.GIF";
                    if (!UserDal.RegLimit())
                    {
                        rm.Info = "sorry,一天最多只能注册三次";
                    }
                    else
                    {
                        int userid = UserDal.m_UserDal.Add(user);
                        //存储注册者的 ip/用户id/密码 并加密
                        cookieHelper.SetCookie("CLoginUser", cookieHelper.EncryptCookie(string.Format("{0}/{1}/{2}", WebHelp.GetIP(), userid, pwd)), 20);
                        rm.Success = true;
                        rm.Info    = "恭喜您,注册成功,3秒后返回首页...";
                    }
                }
                catch
                {
                    rm.Info = "未知错误";
                }
            }

            return(jss.Serialize(rm));
        }
Пример #5
0
        public static bool RegLimit()
        {
            bool           b    = true;
            List <dbParam> list = new List <dbParam>()
            {
                new dbParam()
                {
                    ParamName = "@ClientIP", ParamValue = WebHelp.GetIP()
                },
                new dbParam()
                {
                    ParamName = "@Time", ParamValue = DateTime.Now.ToString("yyyy-MM-dd")
                }
            };
            int count = m_UserInforDAL.GetCount(" RegIP=@ClientIP and CONVERT(varchar(100), CreatedTime, 23)=@Time", list);

            if (count >= 3)
            {
                b = false;
            }
            return(b);
        }
Пример #6
0
        /// <summary>
        /// 获取当前用户
        /// </summary>
        /// <returns></returns>
        public static User CurrentUser()
        {
            User user = null;

            if (System.Web.HttpContext.Current.Request.Cookies["CLoginUser"] == null || System.Web.HttpContext.Current.Request.Cookies["CLoginUser"].Value == "")
            {
                return(user);
            }
            else
            {
                //获取当前用户的Cookies并解密
                string   strLoginUser = cookieHelper.DecryptCookie(System.Web.HttpContext.Current.Request.Cookies["CLoginUser"].Value);
                string[] aLoginUser   = strLoginUser.Split('/');
                if (aLoginUser.Length != 3)
                {
                    user = null;
                }
                if (WebHelp.GetIP() != aLoginUser[0])
                {
                    user = null;
                }
                else
                {
                    user = UserDal.m_UserDal.GetModel("UserId=@UserId", new List <dbParam>()
                    {
                        new dbParam()
                        {
                            ParamName = "@UserId", ParamValue = Convert.ToInt32(Convert.ToInt32(aLoginUser[1]))
                        }
                    });
                    if (user.Pwd != aLoginUser[2])
                    {
                        user = null;
                    }
                }
            }
            return(user);
        }
Пример #7
0
        public static UserInfor CurrentUser()
        {
            UserInfor user = null;

            if (System.Web.HttpContext.Current.Request.Cookies["CLoginUser"] == null || System.Web.HttpContext.Current.Request.Cookies["CLoginUser"].Value == "")
            {
                return(user);
            }
            else
            {
                string   strLoginUser = cookieHelper.DecryptCookie(System.Web.HttpContext.Current.Request.Cookies["CLoginUser"].Value);
                string[] aLoginUser   = strLoginUser.Split('/');
                if (aLoginUser.Length != 3)
                {
                    user = null;
                }
                if (WebHelp.GetIP() != aLoginUser[0])
                {
                    user = null;
                }
                else
                {
                    user = m_UserInforDAL.GetModel("Xuehao=@xuehao", new List <dbParam>()
                    {
                        new dbParam()
                        {
                            ParamName = "@xuehao", ParamValue = aLoginUser[1].ToString()
                        }
                    });
                    if (user.password != aLoginUser[2])
                    {
                        user = null;
                    }
                }
            }
            return(user);
        }
Пример #8
0
        /// <summary>
        /// 用户登录
        /// </summary>
        /// <returns></returns>
        public string UserLogin()
        {
            string username = context.Request.Form["username"].ToString();
            string pwd      = context.Request.Form["pwd"].ToString();

            try
            {
                List <dbParam> list = new List <dbParam>()
                {
                    new dbParam()
                    {
                        ParamName = "@UserName", ParamValue = username
                    },
                    new dbParam()
                    {
                        ParamName = "@Pwd", ParamValue = pwd
                    }
                };
                User user = UserDal.m_UserDal.GetModel("UserName=@UserName and Pwd=@Pwd", list);
                //保存UserId,为后面的页面使用;比如购物车页面。
                //HttpContext.Current.Session["UserId"] = user.UserId;
                cookieHelper.SetCookie("UserId", user.UserId.ToString(), 3600);
                if (user != null)
                {
                    //存储登录者的 ip/用户id/密码 并加密
                    cookieHelper.SetCookie("CLoginUser", cookieHelper.EncryptCookie(string.Format("{0}/{1}/{2}", WebHelp.GetIP(), user.UserId, user.Pwd)), 60);
                    rm.Success = true;
                }
                else
                {
                    rm.Info = "用户名或密码错误";
                }
            }
            catch
            {
                rm.Info = "未知错误";
            }

            return(jss.Serialize(rm));
        }
Пример #9
0
        public string AddComment()
        {
            string title = context.Request.Form["title"].ToString();
            string text  = context.Request.Form["text"].ToString();

            //过滤html标签再判断是否为空
            if (CRegex.FilterHTML(text) == "")
            {
                rm.Info = "内容不能为空";
                return(jss.Serialize(rm));
            }
            else if (CRegex.FilterHTML(text).Length > 500 || CRegex.FilterHTML(text).Length < 6)
            {
                rm.Info = "问题内容长度在6~500之间";
                return(jss.Serialize(rm));
            }
            else
            {
                string         strIP = WebHelp.GetIP();
                User           user  = UserDal.CurrentUser();//获取当前登陆用户
                List <dbParam> list  = new List <dbParam>()
                {
                    new dbParam()
                    {
                        ParamName = "@ClientIP", ParamValue = strIP
                    },
                    new dbParam()
                    {
                        ParamName = "@UserId", ParamValue = user.UserId
                    }
                };
                #region  一IP,同一当前日期(年月日),可以确定当天评论次数。
                List <WebComment> wList = WebCommentDAL.m_WebCommentDal.GetList(" ClientIP=@ClientIP and UserId=@UserId", list);
                int count = 0;
                if (wList.Count == 0)
                {
                    count = 0;
                }
                else
                {
                    string DateCurrent = string.Format("{0:D}", DateTime.Now);//设置当前日期(年-月-日)
                    foreach (var w in wList)
                    {
                        if (DateCurrent == string.Format("{0:D}", w.CreatedTime))
                        {
                            count++;
                        }
                    }
                }
                #endregion
                //同一用户不能一天超过三次留言
                if (count >= 3)
                {
                    rm.Info = "一天最多只能发帖三次";
                    jss.Serialize(rm);
                }
                else
                {
                    if (user.Type < 0)
                    {
                        rm.Info = "只有已登录用户才能发帖";
                        jss.Serialize(rm);
                    }
                    else
                    {
                        WebComment webCom = new WebComment();
                        webCom.CommentTitle = title;
                        webCom.CommentText  = text;
                        webCom.CreatedTime  = DateTime.Now;
                        webCom.ClientIP     = WebHelp.GetIP();
                        webCom.UserId       = user.UserId;
                        WebCommentDAL.m_WebCommentDal.Add(webCom);

                        rm.Success = true;
                        rm.Info    = "提交成功";
                    }
                }
            }
            return(jss.Serialize(rm));
        }
Пример #10
0
        public ReturnMessage Login(string a, string b)
        {
            try
            {
                UserInfor      user = null;
                List <dbParam> list = new List <dbParam>()
                {
                    new dbParam()
                    {
                        ParamName = "@xuehao", ParamValue = a
                    },
                    new dbParam()
                    {
                        ParamName = "@pwd", ParamValue = b
                    }
                };

                user = UserInforDAL.m_UserInforDAL.GetModel("Xuehao=@xuehao and Password=@pwd", list);

                if (user != null)
                {
                    cookieHelper.SetCookie("CLoginUser", cookieHelper.EncryptCookie(string.Format("{0}/{1}/{2}", WebHelp.GetIP(), user.Xuehao, user.password)), 60);
                    rm.Success = true;
                    rm.Info    = user.Uavatar;
                }
                else
                {
                    rm.Success = false;
                }
                return(rm);
            }
            catch (Exception em)
            {
                throw;
            }
        }
        /// <summary>
        /// 回复当前用户的评论
        /// </summary>
        /// <returns></returns>
        public string AddReplyComment()
        {
            int    webCommentId = Convert.ToInt32(context.Request.Form["webCommentId"].ToString());
            string text         = context.Request.Form["text"].ToString();

            if (CRegex.FilterHTML(text) == "")
            {
                rm.Info = "内容不能为空";
                return(jss.Serialize(rm));
            }
            else if (CRegex.FilterHTML(text).Length > 500 || CRegex.FilterHTML(text).Length < 6)
            {
                rm.Info = "回复内容长度在6~500之间";
                return(jss.Serialize(rm));
            }
            else
            {
                string         strIP = WebHelp.GetIP();
                User           user  = UserDal.CurrentUser();//获取当前登陆用户
                List <dbParam> list  = new List <dbParam>()
                {
                    new dbParam()
                    {
                        ParamName = "@ClientIP", ParamValue = strIP
                    },
                    new dbParam()
                    {
                        ParamName = "@UserId", ParamValue = user.UserId
                    }
                };
                #region  一IP,同一当前日期(年月日),可以确定当天回复次数。
                List <WebCommentReply> wcrList = CommentReplyDAL.m_WebCommentReplyDAL.GetList(" ClientIP=@ClientIP and UserId=@UserId", list);
                int count = 0;
                if (wcrList.Count == 0)
                {
                    count = 0;
                }
                else
                {
                    string DateCurrent = string.Format("{0:D}", DateTime.Now);//设置当前日期(年-月-日)
                    foreach (var wcr in wcrList)
                    {
                        if (DateCurrent == string.Format("{0:D}", wcr.CreatedTime))
                        {
                            count++;
                        }
                    }
                }
                #endregion
                //同一用户不能一天超过三次留言
                if (count >= 3)
                {
                    rm.Info = "一天最多只能回复三次";
                    jss.Serialize(rm);
                }
                else
                {
                    if (user.Type < 0)
                    {
                        rm.Info = "只有已登录用户用户才能评论";
                        jss.Serialize(rm);
                    }
                    else
                    {
                        WebCommentReply webComReply = new WebCommentReply();
                        webComReply.WebCommentId     = webCommentId;
                        webComReply.UserId           = user.UserId;
                        webComReply.CommentReplyText = text;
                        webComReply.CreatedTime      = DateTime.Now;
                        webComReply.ClientIP         = WebHelp.GetIP();
                        CommentReplyDAL.m_WebCommentReplyDAL.Add(webComReply);

                        rm.Success = true;
                        rm.Info    = "评论成功";
                    }
                }
            }

            return(jss.Serialize(rm));
        }
Пример #12
0
        public void ProcessRequest(HttpContext context)
        {
            //context.Response.ContentType = "text/plain";
            //context.Response.Write("Hello World");
            string xuehao     = context.Request.Form["xuehao"];
            string realname   = context.Request.Form["realname"];
            string email      = context.Request.Form["email"];
            string pwd        = context.Request.Form["pwd"];
            int    sex        = int.Parse(context.Request.Form["sex"]);
            string invitecode = context.Request.Form["invitecode"];
            string avatar     = "default.png";

            if (xuehao == "" || realname == "" || email == "" || pwd == "" || sex == 0)
            {
                context.Response.Write("empty");
            }
            else
            {
                List <dbParam> list = new List <dbParam>()
                {
                    new dbParam {
                        ParamName = "@xuehao", ParamValue = xuehao
                    },
                    new dbParam {
                        ParamName = "@realname", ParamValue = realname
                    },
                    new dbParam {
                        ParamName = "@email", ParamValue = email
                    }
                };
                if (UserInforDAL.m_UserInforDAL.Exists("Xuehao=@xuehao and Realname=@realname and Uemail=@email", list))
                {
                    context.Response.Write("same");
                }
                else
                {
                    UserInfor user = new UserInfor();
                    user.Xuehao   = xuehao;
                    user.Realname = realname;
                    user.Nickname = null;
                    user.Uemail   = email;
                    user.password = pwd;
                    user.Sex      = sex;
                    string NowYear  = DateTime.Now.ToString("yyyy");
                    string NowMouth = DateTime.Now.ToString("MM");
                    string NowDay   = DateTime.Now.ToString("dd");
                    if (NowMouth.Length == 1)
                    {
                        NowMouth = "0" + NowMouth;
                    }
                    if (NowDay.Length == 1)
                    {
                        NowDay = "0" + NowDay;
                    }
                    string NowTime = NowYear + "年" + NowMouth + "月" + NowDay + "日";
                    user.CreatedTime = NowTime;
                    user.Uavatar     = avatar;
                    user.UIdentity   = "2";
                    user.Ucash       = 0;
                    user.RegIP       = WebHelp.GetIP();
                    user.LoginIP     = WebHelp.GetIP();
                    if (UserInforDAL.m_UserInforDAL.Add(user) > 0)
                    {
                        context.Response.Write("ok");
                    }
                    else
                    {
                        context.Response.Write("no");
                    }
                }
            }
        }