discusstopi_commentary.aspx.cs

最好用的站点内容管理系统 全部源代码都有

//======================================================
//==     (c)2008 aspxcms inc by NeTCMS v1.0              ==
//==          Forum:bbs.aspxcms.com                   ==
//==         Website:www.aspxcms.com                  ==
//======================================================
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using NetCMS.Content;
using NetCMS.Content.Common;
using NetCMS.Model;

public partial class user_discuss_discussTopi_commentary : NetCMS.Web.UI.UserPage
{
    Discuss dis = new Discuss();
    rootPublic pd = new rootPublic();
    protected void Page_Load(object sender, EventArgs e)
    {
        Response.CacheControl = "no-cache";
        
        string DisIDs = Request.QueryString["DisID"];
        string Dtd = Request.QueryString["DtID"];
        if ((DisIDs != "") && (Dtd != ""))
        {
            DisIDs =DisIDs.ToString();
            Dtd = Dtd.ToString();
        }
        else
        {
            PageError("错误的参数", "");
        }
        sc.InnerHtml = Show_sc(DisIDs);
        this.PageNavigator1.OnPageChange += new PageChangeHandler(PageNavigator1_PageChange);
        if (!Page.IsPostBack)
        {
            ///************************************************************************************************************
            ///**********检查主题是否是投票********************************************************************************
            ///************************************************************************************************************
            DataTable dt_VoteTF = dis.sel_discussInfo(Dtd,12);
            int VoteTFIDs = int.Parse(dt_VoteTF.Rows[0]["VoteTF"].ToString());
            DateTime voteTime = DateTime.Parse(dt_VoteTF.Rows[0]["voteTime"].ToString());
            DateTime tms=DateTime.Now;
            if (VoteTFIDs == 1)
            {
                if (voteTime > tms)
                {
                    VoteTF.InnerHtml = Show_VoteTF(Dtd);
                }
            }
            ///************************************************************************************************************
            Show_cjlist(1);
            DataTable dt_sel_dis = dis.sel_discussInfo(DisIDs,4);
            int cut_sel_dis = dt_sel_dis.Rows.Count;
            if (cut_sel_dis == 0)
            {
                PageError("错误", "discussTopi_list.aspx?DisID=" + DisIDs + "");
            }
            string[] Authority = dt_sel_dis.Rows[0]["Authority"].ToString().Split('|');
            int Authority1 = int.Parse(Authority[2].ToString());
            DataTable dt_sel_diss = dis.sel_discussInfo(Dtd,12);
            int cut_sel_diss = dt_sel_diss.Rows.Count;
            if (cut_sel_diss == 0)
            {
                PageError("错误", "discussTopi_list.aspx?DisID=" + DisIDs + "");
            }
            DateTime Cutofftime1 = DateTime.Parse(dt_sel_diss.Rows[0]["voteTime"].ToString());
            DateTime dtm = DateTime.Now;
            int vtf = int.Parse(dt_VoteTF.Rows[0]["VoteTF"].ToString());
            if (Authority1 != 0 )
            {
                if (Cutofftime1 > dtm)
                {
                    if (vtf == 1)
                    {
                        this.Panel1.Visible = true;
                    }
                    cmment.InnerHtml = Show_cmm();
                    cmment1.InnerHtml = Show_cmm();
                }
            }

       }
        sc.InnerHtml = Show_sc(DisIDs);
    }
    protected void PageNavigator1_PageChange(object sender, int PageIndex1)
    {
        Show_cjlist(PageIndex1);
    }
    protected void Show_cjlist(int PageIndex1)
    {
        string DtIDs =Request.QueryString["DtID"];
        int ib, jb;

        SQLConditionInfo sts = new SQLConditionInfo("@DtIDs", DtIDs);
        DataTable cjlistdts = NetCMS.Content.Pagination.GetPage(this.GetType().Name, PageIndex1, 20, out ib, out jb, sts);
        this.PageNavigator1.PageCount = jb;
        this.PageNavigator1.PageIndex = PageIndex1;
        this.PageNavigator1.RecordCount = ib;
        if (cjlistdts.Rows.Count > 0)
        {
            cjlistdts.Columns.Add("UserName", typeof(string));
            cjlistdts.Columns.Add("iPoint", typeof(string));
            cjlistdts.Columns.Add("aPoint", typeof(string));
            cjlistdts.Columns.Add("cPoint", typeof(string));
            cjlistdts.Columns.Add("gPoint", typeof(string));
            cjlistdts.Columns.Add("ePoint", typeof(string));
            cjlistdts.Columns.Add("RegTime", typeof(string));
            cjlistdts.Columns.Add("Content", typeof(string));
            cjlistdts.Columns.Add("chars", typeof(string));
            cjlistdts.Columns.Add("infos", typeof(string));
            cjlistdts.Columns.Add("userfaces", typeof(string));
            foreach (DataRow s in cjlistdts.Rows)
            {
                DataTable dt2 = dis.sel_discussInfo(s["UserNum"].ToString(),0);
                s["chars"] = pd.getUserChar(s["UserNum"].ToString());
                s["infos"] = "<a href=\"../message/message_write.aspx?uid=" + pd.getUserName(s["UserNum"].ToString()) + "\" title=\"给他发短消息\" class=\"list_link\">消息</a>&nbsp;&nbsp;&nbsp;<a href=\"../friend/friend_add.aspx?uid=" + pd.getUserName(s["UserNum"].ToString()) + "\" title=\"加他为好友\" class=\"list_link\">好友</a>";
                int cut = dt2.Rows.Count;
                if (cut != 0)
                {
                    string userflag = pd.getGroupNameFlag(s["UserNum"].ToString());
                    string _Tmpls = dt2.Rows[0]["UserName"].ToString();
                    if (userflag.IndexOf("|") != -1)
                    {
                        string[] userflagARR = userflag.Split('|');
                        _Tmpls = userflagARR[0] + _Tmpls + userflagARR[1];
                    }
                    else
                    {
                        _Tmpls = userflag + _Tmpls;
                    }
                    s["UserName"] = "<a href=\"../../" + NetCMS.Config.UIConfig.dirUser + "/ShowUser.aspx?uid=" + dt2.Rows[0]["UserName"].ToString() + "\" target=\"_blank\" class=\"list_link\" title=\"点击查看" + dt2.Rows[0]["UserName"].ToString() + "的资料.\">" + _Tmpls + "</a>";//用户名
                    s["iPoint"] = dt2.Rows[0]["iPoint"].ToString();
                    s["aPoint"] = dt2.Rows[0]["aPoint"].ToString();
                    s["cPoint"] = dt2.Rows[0]["cPoint"].ToString();
                    s["gPoint"] = dt2.Rows[0]["gPoint"].ToString();
                    s["ePoint"] = dt2.Rows[0]["ePoint"].ToString();
                    s["RegTime"] = DateTime.Parse(dt2.Rows[0]["RegTime"].ToString()).ToShortDateString();
                    string _userface = dt2.Rows[0]["UserFace"].ToString();
                    string _userfacesize = "100|100";
                    if (dt2.Rows[0]["userFacesize"].ToString() != null || dt2.Rows[0]["userFacesize"].ToString() != "")
                    {
                        if (dt2.Rows[0]["userFacesize"].ToString().IndexOf("|") == -1)
                        {
                            _userfacesize = "100|100";
                        }
                        else
                        {
                            _userfacesize = dt2.Rows[0]["userFacesize"].ToString();
                        }
                    }
                    string[] tmpsize = _userfacesize.Split('|');
                    string _height = tmpsize[1];
                    string _width = tmpsize[0];
                    s["userfaces"] = "<img src=\"" + _userface.ToLower().Replace("{@userdirfile}", NetCMS.Config.UIConfig.UserdirFile) + "\" border=\"0\" style=\"width:" + _width + "px;height:" + _height + ";\" title=\"用户未设置头像\" />";
                }
                else 
                {
                    s["UserName"] = "--";
                    s["iPoint"] = "0";
                    s["aPoint"] = "0";
                    s["cPoint"] = "0";
                    s["gPoint"] = "0";
                    s["ePoint"] = "0";
                    s["RegTime"] = "--";
                    s["userfaces"] = "<img src=\"../../sysImages/user/noHeadpic.gif\" border=\"0\" title=\"用户未设置头像\" />";
                }
                DataTable dt = dis.sel_discussInfo(s["DtID"].ToString(),12);
                string _str = "";
                if (dt != null)
                {
                    if (dt.Rows.Count > 0)
                    {
                        string editTF = "";
                        if ((dt.Rows[0]["UserNum"].ToString()).ToUpper() == (NetCMS.Global.Current.UserNum).ToUpper())
                        {
                            editTF = "<a href=\"discussTopi_commentaryEdit.aspx?DtID=" + dt.Rows[0]["DtID"].ToString() + "&DisID=" + Request.QueryString["DisID"] + "\" class=\"list_link\"><img src=\"../../sysImages/folder/re.gif\" border=\"0\"></a>&nbsp;&nbsp;";
                        }
                        if ((dt.Rows[0]["title"].ToString()).Trim() != "")
                        {
                            _str = "<div style=\"width:98%\" align=\"right\">" + editTF + "<span style=\"font-size:10px;\">(" + dt.Rows[0]["creatTime"].ToString() + ")</span>&nbsp;&nbsp;</div><div style=\"height:25px;\"><strong>" + dt.Rows[0]["title"].ToString() + "</strong></div>\r<div>" + dt.Rows[0]["Content"].ToString() + "</div>";
                        }
                        else
                        {
                            _str = "<div style=\"width:98%\" align=\"right\">" + editTF + "<span style=\"font-size:10px;\">(" + dt.Rows[0]["creatTime"].ToString() + ")</span>&nbsp;&nbsp;</div><div>" + dt.Rows[0]["Content"].ToString() + "</div>";
                        }
                    }
                    dt.Clear(); dt.Dispose();
                }
                s["Content"] = _str;
            }
        }
        else 
        {
            no.InnerHtml = Show_no();
            this.PageNavigator1.Visible = false;
        }
        DataList1.DataSource = cjlistdts;
        DataList1.DataBind();
    }

    protected string Show_no()
    {
        string nos = "<table border=0 width=\"98%\" align=\"center\" cellpadding=\"5\" cellspacing=\"1\" class=\"table\">";
        nos = nos + "<tr class=\"TR_BG_list\">";