Exemple #1
0
        /// <summary>
        /// 装载帖子列表
        /// </summary>
        /// <param name="postpramsInfo">参数对象</param>
        /// <param name="reader"></param>
        /// <returns></returns>
        public static List <ShowtopicPagePostInfo> LoadPostList(PostpramsInfo postpramsInfo, IDataReader reader)
        {
            List <ShowtopicPagePostInfo> postList = new List <ShowtopicPagePostInfo>();

            //序号(楼层)的初值
            int id = (postpramsInfo.Pageindex - 1) * postpramsInfo.Pagesize;

            while (reader.Read())
            {
                //当帖子中的posterid字段为0时, 表示该数据出现异常
                if (TypeConverter.ObjectToInt(reader["posterid"]) == 0)
                {
                    continue;
                }

                ShowtopicPagePostInfo postInfo = LoadSingleShowtopicPagePostInfo(reader);
                //扩展属性
                id++;

                postInfo.Id = id;

                postList.Add(postInfo);
            }
            reader.Close();

            return(postList);
        }
Exemple #2
0
        /// <summary>
        /// 获取ShowtopicPagePostInfo对象与ShowtopicPageAttachmentInfo对象列表
        /// </summary>
        /// <param name="postPramsInfo">参数对象</param>
        /// <param name="attachmentList">输出附件列表</param>
        /// <returns></returns>
        public static ShowtopicPagePostInfo GetPostInfoWithAttachments(PostpramsInfo postPramsInfo, out List <ShowtopicPageAttachmentInfo> attachmentList)
        {
            attachmentList = new List <ShowtopicPageAttachmentInfo>();
            //得到帖子对应主题的所有附件,因为ACCESS不支持存储过程,故此方法在ACCESS版中做了特殊处理
            IDataReader attachmentReader;
            IDataReader reader = DatabaseProvider.GetInstance().GetSinglePost(out attachmentReader, postPramsInfo, PostTables.GetPostTableId(postPramsInfo.Tid));
            //Access版运行此处逻辑
            bool isAccess = false;

            if (attachmentReader == null)
            {
                attachmentReader = reader;
            }
            else
            {
                isAccess = true;
            }

            while (attachmentReader.Read())
            {
                attachmentList.Add(Attachments.LoadSingleAttachmentInfo(attachmentReader));
            }
            //bool next = false;
            //Access版运行此处逻辑
            if (!isAccess)
            {
                reader.NextResult();
            }
            ShowtopicPagePostInfo postInfo = null;

            if (reader.Read())
            {
                postInfo = LoadSingleShowtopicPagePostInfo(reader);
            }

            reader.Close();

            if (!attachmentReader.IsClosed)
            {
                attachmentReader.Close();
            }

            return(postInfo);
        }
Exemple #3
0
        /// <summary>
        /// 获取帖子参数信息(PostPramsInfo)
        /// </summary>
        /// <param name="price"></param>
        /// <returns></returns>
        public PostpramsInfo GetPostPramsInfo(int price)
        {
            //获取当前页主题列表
            PostpramsInfo postpramsInfo = new PostpramsInfo();

            postpramsInfo.Fid                    = forum.Fid;
            postpramsInfo.Tid                    = topicid;
            postpramsInfo.Jammer                 = forum.Jammer;
            postpramsInfo.Pagesize               = pagesize; // 得到Ppp设置
            postpramsInfo.Pageindex              = pageid;
            postpramsInfo.Getattachperm          = forum.Getattachperm;
            postpramsInfo.Usergroupid            = usergroupid;
            postpramsInfo.Attachimgpost          = config.Attachimgpost;
            postpramsInfo.Showattachmentpath     = config.Showattachmentpath;
            postpramsInfo.Price                  = price;
            postpramsInfo.Usergroupreadaccess    = (ismoder == 1) ? int.MaxValue : usergroupinfo.Readaccess;
            postpramsInfo.CurrentUserid          = userid;
            postpramsInfo.Showimages             = forum.Allowimgcode;
            postpramsInfo.Smiliesinfo            = Smilies.GetSmiliesListWithInfo();
            postpramsInfo.Customeditorbuttoninfo = Editors.GetCustomEditButtonListWithInfo();
            postpramsInfo.Smiliesmax             = config.Smiliesmax;
            postpramsInfo.Bbcodemode             = config.Bbcodemode;
            postpramsInfo.CurrentUserGroup       = usergroupinfo;
            postpramsInfo.Topicinfo              = topic;
            postpramsInfo.Condition              = Posts.GetPostPramsInfoCondition(onlyauthor, topicid, topic.Posterid);

            //判断是否为回复可见帖, hide=0为不解析[hide]标签, hide>0解析为回复可见字样, hide=-1解析为以下内容回复可见字样显示真实内容
            //将逻辑判断放入取列表的循环中处理,此处只做是否为回复人的判断,主题作者也该可见
            postpramsInfo.Hide = (topic.Hide == 1 && (Posts.IsReplier(topicid, userid) || ismoder == 1)) ? -1 : 1;
            postpramsInfo.Pid  = Posts.GetFirstPostId(topic.Tid);
            UserInfo userInfo = Users.GetUserInfo(userid);

            postpramsInfo.Usercredits = userInfo == null ? 0 : userInfo.Credits;
            debatepost        = Posts.GetSinglePost(postpramsInfo, out attachmentlist, ismoder == 1);
            postpramsInfo.Pid = 0;

            return(postpramsInfo);
        }
Exemple #4
0
        /// <summary>
        /// 根据附件加载帖子内容
        /// </summary>
        /// <param name="postpramsInfo">参数对象</param>
        /// <param name="attachList">附件列表</param>
        /// <param name="isModer">是否是管理人员</param>
        /// <param name="allowGetAttach">是否允许获取附件</param>
        /// <param name="originalHideStatus">帖子原始Hide属性</param>
        /// <param name="postInfo">帖子信息 </param>
        private static void LoadPostMessage(PostpramsInfo postpramsInfo, List <ShowtopicPageAttachmentInfo> attachList, bool isModer, int allowGetAttach, int originalHideStatus, ShowtopicPagePostInfo postInfo)
        {
            UserGroupInfo tmpGroupInfo;

            if (!Utils.InArray(postInfo.Groupid.ToString(), "4,5,6"))
            {
                //处理帖子内容
                postpramsInfo.Smileyoff   = postInfo.Smileyoff;
                postpramsInfo.Bbcodeoff   = postInfo.Bbcodeoff;
                postpramsInfo.Parseurloff = postInfo.Parseurloff;
                postpramsInfo.Allowhtml   = postInfo.Htmlon;
                postpramsInfo.Sdetail     = postInfo.Message;
                postpramsInfo.Pid         = postInfo.Pid;
                //校正hide处理
                tmpGroupInfo = UserGroups.GetUserGroupInfo(postInfo.Groupid);
                if (tmpGroupInfo.Allowhidecode == 0)
                {
                    postpramsInfo.Hide = 0;
                }

                //先简单判断是否是动网兼容模式
                if (!postpramsInfo.Ubbmode)
                {
                    postInfo.Message = UBB.UBBToHTML(postpramsInfo);
                }
                else
                {
                    postInfo.Message = Utils.HtmlEncode(postInfo.Message);
                }

                if (postpramsInfo.Jammer == 1)
                {
                    postInfo.Message = ForumUtils.AddJammer(postInfo.Message);
                }

                string message = postInfo.Message;
                if (postInfo.Attachment > 0 || regexAttach.IsMatch(message) || regexAttachImg.IsMatch(message))
                {
                    //获取在[hide]标签中的附件id
                    string[] attHidArray = Posts.GetHiddenAttachIdList(postpramsInfo.Sdetail, postpramsInfo.Hide);
                    List <ShowtopicPageAttachmentInfo> attachDeleteList = new List <ShowtopicPageAttachmentInfo>();
                    foreach (ShowtopicPageAttachmentInfo attach in attachList)
                    {
                        message = Attachments.GetMessageWithAttachInfo(postpramsInfo, allowGetAttach, attHidArray, postInfo, attach, message);
                        if ((postpramsInfo.CurrentUserGroup.Radminid == 1 || attach.Uid == postpramsInfo.CurrentUserid || attach.Attachprice <= 0 || attach.Isbought == 1) ||//当为发帖人或不为收费附件或已购买该收费附件时
                            Utils.InArray(attach.Aid.ToString(), attHidArray))
                        {
                            ;
                        }
                        else
                        {
                            attachDeleteList.Add(attach);
                        }
                    }

                    foreach (ShowtopicPageAttachmentInfo attach in attachDeleteList)
                    {
                        attachList.Remove(attach);
                    }
                    postInfo.Message = message;
                }

                //恢复hide初值
                postpramsInfo.Hide = originalHideStatus;
            }
            else//发帖人已经被禁止发言
            {
                if (isModer)
                {
                    postInfo.Message = "<div class='hintinfo'>该用户帖子内容已被屏蔽, 您拥有管理权限, 以下是帖子内容</div>" + postInfo.Message;
                }
                else
                {
                    postInfo.Message = "该用户帖子内容已被屏蔽";
                    List <ShowtopicPageAttachmentInfo> delattlist = new List <ShowtopicPageAttachmentInfo>();
                    foreach (ShowtopicPageAttachmentInfo attach in attachList)
                    {
                        if (attach.Pid == postInfo.Pid)
                        {
                            delattlist.Add(attach);
                        }
                    }

                    foreach (ShowtopicPageAttachmentInfo attach in delattlist)
                    {
                        attachList.Remove(attach);
                    }
                }
            }
        }
Exemple #5
0
        /// <summary>
        /// 装载ShowtopicPagePostInfo对象
        /// </summary>
        /// <param name="reader"></param>
        /// <returns></returns>
        private static ShowtopicPagePostInfo LoadSingleShowtopicPagePostInfo(IDataReader reader)
        {
            ShowtopicPagePostInfo postInfo = new ShowtopicPagePostInfo();

            postInfo.Pid          = Int32.Parse(reader["pid"].ToString());
            postInfo.Attachment   = Int32.Parse(reader["attachment"].ToString());
            postInfo.Fid          = TypeConverter.ObjectToInt(reader["fid"]);
            postInfo.Title        = reader["title"].ToString().Trim();
            postInfo.Layer        = Int32.Parse(reader["layer"].ToString());
            postInfo.Message      = reader["message"].ToString().TrimEnd();
            postInfo.Lastedit     = reader["lastedit"].ToString().Trim();
            postInfo.Postdatetime = reader["postdatetime"].ToString().Trim();

            postInfo.Poster      = reader["poster"].ToString().Trim();
            postInfo.Posterid    = Int32.Parse(reader["posterid"].ToString());
            postInfo.Invisible   = Int32.Parse(reader["invisible"].ToString());
            postInfo.Usesig      = Int32.Parse(reader["usesig"].ToString());
            postInfo.Htmlon      = Int32.Parse(reader["htmlon"].ToString());
            postInfo.Smileyoff   = Int32.Parse(reader["smileyoff"].ToString());
            postInfo.Parseurloff = Int32.Parse(reader["parseurloff"].ToString());
            postInfo.Bbcodeoff   = Int32.Parse(reader["bbcodeoff"].ToString());
            postInfo.Rate        = Int32.Parse(reader["rate"].ToString());
            postInfo.Ratetimes   = Int32.Parse(reader["ratetimes"].ToString());
            postInfo.Ubbmessage  = reader["message"].ToString().TrimEnd();
            if (postInfo.Posterid > 0)
            {
                postInfo.Oltime        = reader["oltime"].ToString().Trim();
                postInfo.Lastvisit     = reader["lastvisit"].ToString().Trim();
                postInfo.Nickname      = reader["nickname"].ToString().Trim();
                postInfo.Username      = reader["username"].ToString().Trim();
                postInfo.Groupid       = Utils.StrToInt(reader["groupid"], 0);
                postInfo.Spaceid       = Utils.StrToInt(reader["spaceid"], 0);
                postInfo.Gender        = Utils.StrToInt(reader["gender"], 2);
                postInfo.Bday          = reader["bday"].ToString().Trim();
                postInfo.Showemail     = Utils.StrToInt(reader["showemail"], 0);
                postInfo.Digestposts   = Utils.StrToInt(reader["digestposts"], 0);
                postInfo.Credits       = Utils.StrToInt(reader["credits"], 0);
                postInfo.Extcredits1   = TypeConverter.StrToFloat(reader["extcredits1"].ToString());
                postInfo.Extcredits2   = TypeConverter.StrToFloat(reader["extcredits2"].ToString());
                postInfo.Extcredits3   = TypeConverter.StrToFloat(reader["extcredits3"].ToString());
                postInfo.Extcredits4   = TypeConverter.StrToFloat(reader["extcredits4"].ToString());
                postInfo.Extcredits5   = TypeConverter.StrToFloat(reader["extcredits5"].ToString());
                postInfo.Extcredits6   = TypeConverter.StrToFloat(reader["extcredits6"].ToString());
                postInfo.Extcredits7   = TypeConverter.StrToFloat(reader["extcredits7"].ToString());
                postInfo.Extcredits8   = TypeConverter.StrToFloat(reader["extcredits8"].ToString());
                postInfo.Posts         = Utils.StrToInt(reader["posts"], 0);
                postInfo.Joindate      = reader["joindate"].ToString().Trim();
                postInfo.Lastactivity  = reader["lastactivity"].ToString().Trim();
                postInfo.Userinvisible = Int32.Parse(reader["invisible"].ToString());
                postInfo.Avatar        = reader["avatar"].ToString();
                postInfo.Avatarwidth   = Utils.StrToInt(reader["avatarwidth"], 0);
                postInfo.Avatarheight  = Utils.StrToInt(reader["avatarheight"], 0);
                postInfo.Medals        = reader["medals"].ToString();
                postInfo.Signature     = reader["signature"].ToString();
                postInfo.Location      = reader["location"].ToString();
                postInfo.Customstatus  = reader["customstatus"].ToString();
                postInfo.Website       = reader["website"].ToString();
                postInfo.Icq           = reader["icq"].ToString();
                postInfo.Qq            = reader["qq"].ToString();
                postInfo.Msn           = reader["msn"].ToString();
                postInfo.Yahoo         = reader["yahoo"].ToString();
                postInfo.Skype         = reader["skype"].ToString();

                //部分属性需要根据不同情况来赋值

                //根据用户自己的设置决定是否显示邮箱地址
                if (postInfo.Showemail == 0)
                {
                    postInfo.Email = "";
                }
                else
                {
                    postInfo.Email = reader["email"].ToString().Trim();
                }

                // 最后活动时间50分钟内的为在线, 否则不在线
                if (Utils.StrDateDiffMinutes(postInfo.Lastactivity, 50) < 0)
                {
                    postInfo.Onlinestate = 1;
                }
                else
                {
                    postInfo.Onlinestate = 0;
                }

                //作者ID为-1即表明作者为游客, 为了区分会直接公开显示游客发帖时的IP, 这里将IP最后一位修改为*
                postInfo.Ip = reader["ip"].ToString().Trim();
            }
            else
            {
                postInfo.Nickname      = "游客";
                postInfo.Username      = "******";
                postInfo.Groupid       = 7;
                postInfo.Showemail     = 0;
                postInfo.Digestposts   = 0;
                postInfo.Credits       = 0;
                postInfo.Extcredits1   = 0;
                postInfo.Extcredits2   = 0;
                postInfo.Extcredits3   = 0;
                postInfo.Extcredits4   = 0;
                postInfo.Extcredits5   = 0;
                postInfo.Extcredits6   = 0;
                postInfo.Extcredits7   = 0;
                postInfo.Extcredits8   = 0;
                postInfo.Posts         = 0;
                postInfo.Joindate      = "2006-9-1 1:1:1";
                postInfo.Lastactivity  = "2006-9-1 1:1:1";;
                postInfo.Userinvisible = 0;
                postInfo.Avatar        = "";
                postInfo.Avatarwidth   = 0;
                postInfo.Avatarheight  = 0;
                postInfo.Medals        = "";
                postInfo.Signature     = "";
                postInfo.Location      = "";
                postInfo.Customstatus  = "";
                postInfo.Website       = "";
                postInfo.Icq           = "";
                postInfo.Qq            = "";
                postInfo.Msn           = "";
                postInfo.Yahoo         = "";
                postInfo.Skype         = "";
                //部分属性需要根据不同情况来赋值
                postInfo.Email       = "";
                postInfo.Onlinestate = 1;
                postInfo.Medals      = "";

                postInfo.Ip = reader["ip"].ToString().Trim();
                if (postInfo.Ip.IndexOf('.') > -1)
                {
                    postInfo.Ip = postInfo.Ip.Substring(0, postInfo.Ip.LastIndexOf(".") + 1) + "*";
                }
            }
            return(postInfo);
        }