Exemplo n.º 1
0
        /// <summary>
        /// 增加一条数据,内部已经处理分表回贴,版块统计,属归作者表,积分
        /// </summary>
        public int Add(Model.Forum_Topic model, out int _subTable_id, out int _post_id)
        {
            Forum_PostSubTable bllSubTable = new Forum_PostSubTable();
            Forum_Board        bllBoard    = new Forum_Board();

            Model.Forum_PostSubTable modelSubTable = bllSubTable.GetModel("Avail=1");

            //分表ID
            _subTable_id = modelSubTable.Id;

            model.PostSubTable = _subTable_id;

            //主题表ID
            int _topic_id = dal.Add(model);

            //回复表ID
            _post_id = new Forum_PostId().Add(new Model.Forum_PostId {
                TopicId = _topic_id
            });

            new Forum_Post(_subTable_id).Add(model, new Model.Forum_Post
            {
                BoardId      = model.BoardId,
                Message      = model.Message,
                Title        = model.Title,
                PostDateTime = model.PostDatetime,
                PostNickname = model.PostNickname,
                PostUsername = model.PostUsername,
                PostUserId   = model.PostUserId,
                Id           = _post_id,
                TopicId      = _topic_id,
                First        = 1
            });

            //版块包括父级版块的统计、标记最后发贴

            string strValue = "[TodayTopicCount]=[TodayTopicCount]+1,[TopicCount]=[TopicCount]+1,[LastPostUserId]=" + model.PostUserId + ",[LastPostUsername]='" + model.PostUsername.Replace("'", "") + "',[LastPostNickname]='" + model.PostNickname.Replace("'", "") + "',[LastTopicId]=" + _topic_id + ",[LastTopicTitle]='" + model.Title.Replace("'", "") + "'";

            Model.Forum_Board modelBoard = bllBoard.GetModel(model.BoardId);

            bllBoard.UpdateField(" Id in (0" + modelBoard.ClassList + "0) ", strValue);

            //文章归属
            new Forum_MyTopic().Add(new Model.Forum_MyTopic {
                TopicId = _topic_id, UserId = model.PostUserId
            });

            //获得实际积分
            int _point = new BLL.Forum_BoardActionPoint().GetRealPoint(model.BoardId, 1);

            new Forum_UserExtended().UpdateField(model.PostUserId, " TopicCount=TopicCount+1 ,Credit=Credit+" + _point);

            modelSubTable.TopicCount += 1;

            bllSubTable.Update(modelSubTable);

            return(_topic_id);
        }
Exemplo n.º 2
0
        public static void BoardTodayTopicCount(bool bol = false)
        {
            //没有统计过
            if (HttpContext.Current.Application["BoardTodayTopicTime"] == null)
            {
                bol = true;

                HttpContext.Current.Application["BoardTodayTopicTime"] = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd 00:00:01"));
            }


            DateTime dtTime = Convert.ToDateTime(HttpContext.Current.Application["BoardTodayTopicTime"]);

            TimeSpan ts = System.DateTime.Now - dtTime;


            //时间已经超过了24小时
            if (ts.TotalSeconds > 86400.0)
            {
                bol = true;
            }


            if (bol)
            {
                BLL.Forum_Board bll = new BLL.Forum_Board();

                bll.UpdateField(" 1=1 ", "TodayTopicCount=0");

                List <Model.Forum_Board> list = bll.GetModelList(" 1=1 ");

                //所有版块重新统计

                foreach (Model.Forum_Board modelBoard in list)
                {
                    int _total = new BLL.Forum_Topic().GetTotal(" BoardId=" + modelBoard.Id + " and PostDatetime>'" + System.DateTime.Now.ToString("yyyy-MM-dd 00:00:01") + "' ");

                    string strValue = "[TodayTopicCount]=[TodayTopicCount]+" + _total + "";

                    bll.UpdateField(" Id in (0" + modelBoard.ClassList + "0) ", strValue);
                }

                HttpContext.Current.Application["BoardTodayTopicTime"] = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd 00:00:01"));
            }
        }