Example #1
0
    protected void btnCommit_Click(object sender, EventArgs e)
    {
        if (Textarea1.Value.Length == 0)
        {
            Javascript.GoHistory(-1, "请填写回复内容!", Page);
            return;
        }
        int lastPostId = 0;

        DalOperationAboutBbs dalOperationAboutBbs = new DalOperationAboutBbs();
        UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
        BbsPosts post = new BbsPosts
        {
            topicId = topicId,
            postContent = CommonUtility.JavascriptStringFilterAll(Textarea1.Value),
            postUserName = (UserCookiesInfo.userType != 3) ? UserCookiesInfo.userName : UserCookiesInfo.userNo + "  " + UserCookiesInfo.userName,
            updateTime = DateTime.Now,
            attachmentIds = hidAttachmentId.Value,
            postUserNo = UserCookiesInfo.userNo,
            postUserType = UserCookiesInfo.userType,
            courseNo = forumId
        };
        lastPostId = dalOperationAboutBbs.AddPostByTopicId(post);
        PageDataBinds();
        hidAttachmentId.Value = string.Empty;
        Textarea1.Value = string.Empty;
        Javascript.JavaScriptLocationHref("#post" + lastPostId.ToString(), Page);
    }
Example #2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!hasControls(course))
     {
         CommonUtility.RedirectLoginUrl();
         return;
     }
     if (!IsPostBack)
     {
         int topicId=0;
         if (CommonUtility.SafeCheckByParams<string>(Request["topicId"], ref topicId))
         {
             DalOperationAboutBbs dal = new DalOperationAboutBbs();
             DataSet ds = dal.GetTopicAndPostsByTopicId(topicId);
             txtTitle.Text = ds.Tables["1"].Rows[0]["topicTitle"].ToString().Trim();
             Textarea1.Value = ds.Tables["1"].Rows[0]["topicContent"].ToString().Trim();
             hidAttachmentId.Value = ds.Tables["1"].Rows[0]["attachmentIds"].ToString().Trim();
             if ( ds.Tables["1"].Rows[0]["attachmentIds"].ToString().Length > 0)
             {
                 DalOperationAttachments dalOperationAttachments = new DalOperationAttachments();
                 ltlAttachment.Text = dalOperationAttachments.GetAttachmentsList(ds.Tables["1"].Rows[0]["attachmentIds"].ToString(), ref iframeCount, true,string.Empty);
             }
         }
         else
         {
             Javascript.GoHistory(-1, Page);
         }
     }
 }
Example #3
0
    protected void DataResultTopic()
    {
        DalOperationAboutBbs DalOperationAboutBbs = new DalOperationAboutBbs();
        DataSet ds = DalOperationAboutBbs.SearchTopic(txtSearchString.Text, forumId+classID+termTag);
        dv = ds.Tables[0].DefaultView;

        dlsttopicresult.DataSource = dv;
        dlsttopicresult.DataBind();
    }
Example #4
0
    protected void DataResultPost()
    {
        DalOperationAboutBbs DalOperationAboutBbs = new DalOperationAboutBbs();
        DataSet ds = DalOperationAboutBbs.SearchPost(txtSearchString.Text, forumId);

        dv = ds.Tables[0].DefaultView;

        //dlstpostresult.DataSource = dv;
        //dlstpostresult.DataBind();
    }
Example #5
0
    protected void btnsearch_Click(object sender, EventArgs e)
    {
        dlsttopicresult.DataSource = null;
        dlsttopicresult.DataBind();
        //dlstpostresult.DataSource = null;
        //dlstpostresult.DataBind();
        DalOperationAboutBbs DalOperationAboutBbs = new DalOperationAboutBbs();
        DataSet ds = new DataSet();

            //dlsttopicresult.Visible = true;

            //dlstpostresult.Visible = false;

            DataResultTopic();
    }
Example #6
0
    protected void DataResultPost()
    {
        DalOperationAboutBbs DalOperationAboutBbs = new DalOperationAboutBbs();
        DataSet ds = DalOperationAboutBbs.SearchPost(txtSearchString.Text);

        DataView dv = ds.Tables[0].DefaultView;

        this.AspNetPager3.RecordCount = dv.Count;

        PagedDataSource pds = new PagedDataSource();    //定义一个PagedDataSource类来执行分页功
        pds.DataSource = dv;
        pds.AllowPaging = true;

        pds.CurrentPageIndex = AspNetPager3.CurrentPageIndex - 1;
        pds.PageSize = AspNetPager3.PageSize;
        dlstpostresult.DataSource = pds;
        dlstpostresult.DataBind();
    }
Example #7
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Master.ShowLiControl(this.Page, "liFragment2");
        DalOperationAboutBbs dalOperationAboutBbs = new DalOperationAboutBbs();
        DataSet dsCourses = dalOperationAboutBbs.GetAllForumsList();
        foreach (DataRow dr0 in dsCourses.Tables["3"].Rows)
        {

            ht0.Add(dr0["courseNo"].ToString().Trim(), dr0["topicsCount"].ToString());
        }

        foreach (DataRow dr1 in dsCourses.Tables["4"].Rows)
        {

            ht1.Add(dr1["courseNo"].ToString().Trim(), dr1["postIdCount"].ToString());
        }

        foreach (DataRow dr2 in dsCourses.Tables["5"].Rows)
        {
            ht2.Add(dr2["courseNo"].ToString().Trim(), dr2["postUserName"].ToString());
            ht3.Add(dr2["courseNo"].ToString().Trim(), dr2["updateTime"].ToString());
        }

        foreach (DataRow dr3 in dsCourses.Tables["6"].Rows)
        {
            ht4.Add(dr3["courseNo"].ToString().Trim(), dr3["todayTopicsCount"].ToString());
        }

        foreach (DataRow dr4 in dsCourses.Tables["7"].Rows)
        {
            ht5.Add(dr4["courseNo"].ToString().Trim(), dr4["todayPostsCount"].ToString());
        }

        foreach (DataRow dr6 in dsCourses.Tables["8"].Rows)
        {
            ht6.Add(dr6["courseNo"].ToString().Trim(), dr6["updateTime"].ToString().Trim());
        }

        this.dlstpic.DataSource = dsCourses.Tables["2"];

        this.dlstpic.DataBind();
    }
Example #8
0
    protected void btnCommit_Click(object sender, EventArgs e)
    {
        if (txtTilte.Text.Length == 0)
        {
            Javascript.GoHistory(-1, "请填写标题!", Page);
            return;
        }

        if (Textarea1.Value.Length == 0)
        {
            Javascript.GoHistory(-1, "请填写内容!", Page);
            return;
        }

        DalOperationAboutBbs dalOperationAboutBbs = new DalOperationAboutBbs();
        UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
        BbsTopics topic = new BbsTopics
        {
            courseNo = Request["forumId"],
            topicTitle = CommonUtility.JavascriptStringFilterAll(txtTilte.Text),
            topicContent = CommonUtility.JavascriptStringFilterAll(Textarea1.Value),
            topicUserName = (UserCookiesInfo.userType != 3) ? UserCookiesInfo.userName : UserCookiesInfo.userNo + "  " + UserCookiesInfo.userName,
            updateTime = DateTime.Now,
            topicUserNo = UserCookiesInfo.userNo,
            topicUserType = UserCookiesInfo.userType,
            isbigTop=1
        };
        if (hidAttachmentId.Value.CompareTo(string.Empty) != 0)
        {
            topic.attachmentIds = hidAttachmentId.Value;
        }
        if (hasControls(Request["forumId"]))
        {
            dalOperationAboutBbs.AddTopicByForumId(topic);//添加新话题
        }
        else
        {
            Javascript.GoHistory(-1, "您没有权限!", Page);
        }
        Javascript.RefreshParentWindow("BBSTopicList.aspx?tagName=" + Request["tagName"] + "&tag=2&forumId=" + Request["forumId"], Page);
    }
Example #9
0
    // /// <summary>
    ///// 提交话题标签功能代码
    // /// </summary>
    // /// <param name="sender"></param>
    // /// <param name="e"></param>
    protected void btnCommit_Click(object sender, EventArgs e)
    {
        if (txtTilte.Text.Length == 0)
        {
            Javascript.GoHistory(-1, "请填写标题!", Page);
            return;
        }

        if (Textarea1.Value.Length == 0)
        {
            Javascript.GoHistory(-1, "请填写回复内容!", Page);
            return;
        }
        string tag = Request["tag"];
        if (tag == "1")
        {
            forumId = Request["forumId"].Trim() + Server.UrlDecode(Request["classID"].Trim()) + Request["termtag"].Trim();
        }
        DalOperationAboutBbs dalOperationAboutBbs = new DalOperationAboutBbs();
        UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
        BbsTopics topic = new BbsTopics
        {
            courseNo = forumId,
            topicTitle = CommonUtility.JavascriptStringFilterAll(txtTilte.Text),
            topicContent = CommonUtility.JavascriptStringFilterAll(Textarea1.Value),
            topicUserName = (UserCookiesInfo.userType != 3) ? UserCookiesInfo.userName : UserCookiesInfo.userNo + "  " + UserCookiesInfo.userName,
            updateTime = DateTime.Now,
            topicUserNo = UserCookiesInfo.userNo,
            topicUserType = UserCookiesInfo.userType
        };
        if (hidAttachmentId.Value.CompareTo(string.Empty) != 0)
        {
            topic.attachmentIds = hidAttachmentId.Value;
        }
        dalOperationAboutBbs.AddTopicByForumId(topic);//添加新话题
        Javascript.AlertAndRedirect("添加主题成功!", "BBSTopicList.aspx?forumId=" + Request["forumId"] + "&classID=" + Server.UrlDecode(Request["classID"]) + "&termTag=" + Request["termTag"] + "&tag=" + tag, Page);
    }
Example #10
0
    protected void DataListBind()
    {
        DalOperationAboutBbs dalOperationAboutBbs = new DalOperationAboutBbs();
        DataSet ds = dalOperationAboutBbs.GetAllTopicsByForumId(forumId);
        DataSet ds1 = dalOperationAboutBbs.GetTopicsTopByForumId(forumId);
        dlstTopTopic.DataSource = ds1.Tables[0];
        dlstTopTopic.DataBind();

        //填充HASHTABLE
        DataSet ds2 = dalOperationAboutBbs.GetLastPost();

        DataTable dt0 = ds2.Tables["0"];

        DataTable dt1 = ds2.Tables["1"];

        foreach (DataRow dr0 in dt0.Rows)
        {
            ht0.Add(dr0["topicId"].ToString(), dr0["postsCount"].ToString());
        }

        foreach (DataRow dr1 in dt1.Rows)
        {
            ht1.Add(dr1["topicId"].ToString(), dr1["postUserName"].ToString());
            ht2.Add(dr1["topicId"].ToString(), dr1["updateTime"].ToString());
        }

        DalOperationPatch dal = new DalOperationPatch();
        DataSet dsNew = dal.GetLatestTopic();
        DataSet dsTopicList = dal.GetLatestTopicAndPostsUpdateTime();
        foreach (DataRow dr2 in dsTopicList.Tables[0].Rows)
        {
            ht3.Add(dr2["topicId"].ToString().Trim(), dr2["updateTime"].ToString().Trim());
        }

        dlsttopics.DataSource = ds.Tables[0];
        dlsttopics.DataBind();
    }
Example #11
0
 /// <summary>
 /// 设置置顶
 /// </summary>
 /// <param name="topicId"></param>
 private void setTop(int topicId)
 {
     DalOperationAboutBbs dalOperationAboutBbs = new DalOperationAboutBbs();
     dalOperationAboutBbs.SetTopicOnTop(topicId);
 }
Example #12
0
 /// <summary>
 /// 取消置顶
 /// </summary>
 /// <param name="topicId"></param>
 private void cancelTop(int topicId)
 {
     DalOperationAboutBbs dalOperationAboutBbs = new DalOperationAboutBbs();
     dalOperationAboutBbs.CancelTopicOnTop(topicId);
 }
Example #13
0
    protected void Page_Load(object sender, EventArgs e)
    {
        switch (Request["tag"])
        {
            case "1": Master.ShowLiControl(this.Page, "liFragment1");
                if (Request["forumId"] == null || Request["classID"] == null || Request["termtag"] == null)
                {
                    Javascript.Alert("参数错误", Page);
                    Javascript.GoHistory(-1, Page);
                    return;
                }
                break;
            case "2": Master.ShowLiControl(this.Page, "liFragment2");
                break;
            case "3": Master.ShowLiControl(this.Page, "liFragment3");
                break;
            default: break;
        }
        //控制Tab的显示
        hasControl = hasControls(forumId);
        if (!IsPostBack)
        {
            ///删除话题
            int topicId = 0;
            if (hasControl && CommonUtility.SafeCheckByParams<string>(Request["topicId"], ref topicId) && Request["del"] == "true")
            {

                deltopic(topicId);
                Javascript.Alert("删除成功!", Page);
                // Javascript.AlertAndRedirect("删除成功!", "BBSTopicList.aspx?forumId=" + Request["forumId"] + "&tag=" + tag, Page);

            }

            /// 设置置顶
            if (hasControl && CommonUtility.SafeCheckByParams<string>(Request["toTopId"], ref topicId))
            {
                setTop(topicId);
            }

            /// 取消置顶
            int canceltopId = 0;
            if (hasControl && CommonUtility.SafeCheckByParams<string>(Request["cancelTopId"], ref canceltopId))
            {
                cancelTop(canceltopId);
            }
        }
        if (Request["tag"] != null && Request["forumId"] != null)
        {
            string tag = Request["tag"];
            if (tag == "1")
            {

                DalOperationAboutCourses dal1 = new DalOperationAboutCourses();
                forumId = Request["forumId"].Trim() + Server.UrlDecode(Request["classID"].Trim()) + Request["termtag"].Trim();
                tagName = dal1.GetCoursesByNo(Request["forumId"].Trim(), Server.UrlDecode(Request["classID"].Trim()), Request["termtag"].Trim()).courseName;
            }
            else
            {
                DalOperationAboutBbsManage dal3 = new DalOperationAboutBbsManage();
                DalOperationAboutBbs dal2 = new DalOperationAboutBbs();
                tagName = dal3.GetForumById(Request["forumId"]).forumTitle;
            }
        }
        DataListBind();
    }
Example #14
0
    protected void PageDataBinds()
    {
        if (CommonUtility.SafeCheckByParams<string>(Request["topicId"], ref topicId))
        {
            DalOperationAboutBbs dal = new DalOperationAboutBbs();
            dal.AddTopicHits(topicId.ToString());
            DataSet ds = dal.GetTopicAndPostsByTopicId(topicId);

            if (ds.Tables["1"].Rows.Count > 0 && ds.Tables["1"].Rows.Count > 0)
            {
                courseNo = ds.Tables["1"].Rows[0]["courseNo"].ToString();
                topicName = ds.Tables["1"].Rows[0]["topicTitle"].ToString();
            }

            if (Request["tag"] != null)
            {
                if (tag == "1")
                {
                    courseNo = Request["courseNo"];
                    DalOperationAboutCourses dal1 = new DalOperationAboutCourses();
                    tagName = dal1.GetCoursesByNo(Request["courseNo"],Server.UrlDecode(Request["classID"]),Request["termtag"]).courseName;
                }
                else
                {
                    DalOperationAboutBbsManage dal3 = new DalOperationAboutBbsManage();

                    BbsForum f = dal3.GetForumById(courseNo);
                    tagName = f.forumTitle;
                }
            }

            hascontrol = this.hasControl(courseNo);

            if (Request["del"] == "true")
            {
                int postId = 0;
                if (hascontrol && CommonUtility.SafeCheckByParams<string>(Request["postId"], ref postId))
                {
                    delpost(postId);
                    Javascript.AlertAndRedirect("删除成功!", "BBSViewTopic.aspx?tag=" + tag + "&topicId=" + Request["topicId"], Page);
                    return;
                }
                int topicd = 0;
                if (hascontrol && CommonUtility.SafeCheckByParams<string>(Request["topicId"], ref topicd) && Request["postId"] == null)
                {

                    //deltopic(topicd);
                    //Javascript.AlertAndRedirect("删除成功!", "BBSTopicList.aspx?forumId=" + courseNo +"&classID="+Server.UrlDecode(Request["classID"])+"termtag="+Request["termtag"]+ "&tag=" + tag, Page);
                    // Javascript.JavaScriptLocationHref("BBSTopicList.aspx?del=true&forumId=" + courseNo + "&classID=" + Server.UrlDecode(Request["classID"]) + "&termtag="+Request["termtag"]+"&topicId=166&tag=1", Page);
                    return;
                }
                else
                {
                    Javascript.Alert("不能删除!", Page);
                    return;
                }
            }

            dlsttopic.DataSource = ds.Tables["1"];
            dlsttopic.DataBind();
            dlstposts.DataSource = ds.Tables["0"];
            dlstposts.DataBind();
        }
    }
Example #15
0
    protected void DatalistBind(string term)
    {
        DalOperationAboutBbs dalOperationAboutBbs = new DalOperationAboutBbs();
        DataSet dsCourses = new DataSet();

        if ("当前学期" == term)
        {
            tags = "当前学期";
            dsCourses = dalOperationAboutBbs.GetAllForumsList();
        }
        else
        {
            //Response.Write(term);
           // Response.End();
            tags = CommonUtility.ChangeTermToString(term);
            dsCourses = dalOperationAboutBbs.GetAllForumsList(term);
        }
        //if (fragmentFlag.Equals("1"))
        //{

            foreach (DataRow dr0 in dsCourses.Tables["3"].Rows)
            {

                ht0.Add(dr0["courseNo"].ToString().Trim(), dr0["topicsCount"].ToString());
            }

            foreach (DataRow dr1 in dsCourses.Tables["4"].Rows)
            {

                ht1.Add(dr1["courseNo"].ToString().Trim(), dr1["postIdCount"].ToString());
            }

            foreach (DataRow dr2 in dsCourses.Tables["5"].Rows)
            {
                ht2.Add(dr2["courseNo"].ToString().Trim(), dr2["postUserName"].ToString());
                ht3.Add(dr2["courseNo"].ToString().Trim(), dr2["updateTime"].ToString());
            }

            foreach (DataRow dr3 in dsCourses.Tables["6"].Rows)
            {
                ht4.Add(dr3["courseNo"].ToString().Trim(), dr3["todayTopicsCount"].ToString());
            }

            foreach (DataRow dr4 in dsCourses.Tables["7"].Rows)
            {
                ht5.Add(dr4["courseNo"].ToString().Trim(), dr4["todayPostsCount"].ToString());
            }

            foreach (DataRow dr6 in dsCourses.Tables["8"].Rows)
            {
                ht6.Add(dr6["courseNo"].ToString().Trim(), dr6["updateTime"].ToString().Trim());
            }

            this.dlstAboutCourses.DataSource = dsCourses.Tables[0];
            this.dlstAboutCourses.DataBind();

        //}
        /**
        if (fragmentFlag.Equals("2"))
        {
            this.dlstpic.DataSource = dsCourses.Tables["2"];

            this.dlstpic.DataBind();
        }
        if (fragmentFlag.Equals("3"))
        {
            this.dlstAboutOther.DataSource = dsCourses.Tables[1];
            this.dlstAboutOther.DataBind();
        }
        if (fragmentFlag.Equals("4"))
        {
            DalOperationPatch dalpa = new DalOperationPatch();

            UserCookiesInfo user = BllOperationAboutUser.GetUserCookiesInfo();
            string src = dalpa.GetAvatar(user.userNo, user.userType);
            ltavatar.Text = "<img src=\"" + src + "\">";
        }*/
    }
Example #16
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Request["tag"] != null && Request["forumId"] != null)
     {
         string tag = Request["tag"];
         if (tag == "1")
         {
             DalOperationAboutCourses dal1 = new DalOperationAboutCourses();
             tagName = dal1.GetCoursesByNo(Request["forumId"], Server.UrlDecode(Request["classID"]), Request["termtag"]).courseName;
         }
         else
         {
             DalOperationAboutBbsManage dal3 = new DalOperationAboutBbsManage();
             DalOperationAboutBbs dal2 = new DalOperationAboutBbs();
             tagName = dal3.GetForumById(Request["forumId"]).forumTitle;
         }
     }
     else
     {
         Javascript.GoHistory(-1, Page);
     }
 }