mycom.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;

public partial class user_info_mycom : NetCMS.Web.UI.UserPage
{
    Ghistory inf = new Ghistory();
    Mycom my = new Mycom();
    NetCMS.Content.Common.rootPublic pd = new NetCMS.Content.Common.rootPublic();
    protected void Page_Init(object sernder, EventArgs e)
    {
        #region   初始化
        string UserNum = NetCMS.Global.Current.UserNum;
        this.PageNavigator1.OnPageChange += new PageChangeHandler(PageNavigator1_PageChange);
        Response.CacheControl = "no-cache";

        string sel_GroupNumber = inf.sel_sysUser(UserNum, 0).Rows[0]["UserGroupNumber"].ToString();
        DataTable dt1 = inf.sel_sysUser(sel_GroupNumber,3);
        int TopTitle = int.Parse(dt1.Rows[0]["TopTitle"].ToString());
        int GoodTitle = int.Parse(dt1.Rows[0]["GoodTitle"].ToString());
        int CheckTtile = int.Parse(dt1.Rows[0]["CheckTtile"].ToString());
        int OCTF = int.Parse(dt1.Rows[0]["OCTF"].ToString());

        if (TopTitle == 1)
        {
            string ctr1 = "<td><asp:Button ID=\"TopTitle1\" runat=\"server\" Text=\"固顶\" CssClass=\"form\" Width=\"80px\"/></td><td><asp:Button ID=\"TopTitle12\" runat=\"server\" Text=\"解固\"  CssClass=\"form\" Width=\"80px\"/></td>";
            Control ctrl1 = Page.ParseControl(ctr1);
            PlaceHolder1.Controls.Add(ctrl1);
            Button bt1 = (Button)Page.FindControl("TopTitle1");
            bt1.Command += new CommandEventHandler(this.TopTitle);
            Button bt2 = (Button)Page.FindControl("TopTitle12");
            bt2.Command += new CommandEventHandler(this.TopTitlej);
        }
        if (GoodTitle == 1)
        {
            string ctr1 = "<td><asp:Button ID=\"GoodTitle\" runat=\"server\" Text=\"精华\" CssClass=\"form\" Width=\"80px\"/></td> ";
            Control ctrl1 = Page.ParseControl(ctr1);
            PlaceHolder1.Controls.Add(ctrl1);
            Button bt3 = (Button)Page.FindControl("GoodTitle");
            bt3.Command += new CommandEventHandler(this.GoodTitle);
        }
        if (CheckTtile == 1)
        {
            string ctr1 = "<td><asp:Button ID=\"CheckTtile\" runat=\"server\" Text=\"审核\" CssClass=\"form\" Width=\"80px\"/></td> ";
            Control ctrl1 = Page.ParseControl(ctr1);
            PlaceHolder1.Controls.Add(ctrl1);
            Button bt4 = (Button)Page.FindControl("CheckTtile");
            bt4.Command += new CommandEventHandler(this.isCheck);
        }
        if (OCTF == 1)
        {
            string ctr1 = "<td><asp:Button ID=\"OCTF1\" runat=\"server\" Text=\"锁定\" CssClass=\"form\" Width=\"80px\"/></td><td><asp:Button ID=\"OCTF2\" runat=\"server\" Text=\"解锁\" CssClass=\"form\" Width=\"80px\"/></td>";
            Control ctrl1 = Page.ParseControl(ctr1);
            PlaceHolder1.Controls.Add(ctrl1);
            Button bt5 = (Button)Page.FindControl("OCTF1");
            bt5.Command += new CommandEventHandler(this.islock);
            Button bt6 = (Button)Page.FindControl("OCTF2");
            bt6.Command += new CommandEventHandler(this.islocks);
        }
        if (!IsPostBack)
        {
            StartLoad(1, "", "", "", "", "", "");
        }

        string Type = Request.QueryString["Type"];  //取得操作类型
        string ID = "";
        if (Request.QueryString["ID"] != null && Request.QueryString["ID"] != "")
        {
            ID = Request.QueryString["ID"];  //取得需要操作的稿件ID
        }

        switch (Type)
        {
            case "del":          //删除
                del(ID);
                break;
            case "PDel":            //批量删除
                PDel();
                break;
            default:
                break;
        }
        #endregion
    }

    protected void PageNavigator1_PageChange(object sender, int PageIndex)
    {
        StartLoad(PageIndex, null, null, null, null, null, null);
    }
    #region  数据绑定
    protected void StartLoad(int PageIndex,string title,string Um, string dtm1,string dtm2, string isCheck, string islock)
    {
        string UserNum = "";
        if (Request.QueryString["UserNum"] != null && Request.QueryString["UserNum"] != "")
        {
            string getName = pd.getUserName(UserNum);
            UserNum = Request.QueryString["UserNum"];
            if (getName != NetCMS.Global.Current.UserName)
            {
                UserNum = NetCMS.Global.Current.UserName;
            }
            else
            {
                UserNum = getName;
            }
        }
        else
        {
            UserNum = NetCMS.Global.Current.UserName;
        }
        string UserNums1 = NetCMS.Global.Current.UserNum;
        DataTable dt4 = inf.sel_sysUser(UserNums1,0);
        DataTable dt2 = inf.sel_sysUser(dt4.Rows[0]["UserGroupNumber"].ToString(),3);
        int DelSelfTitle = int.Parse(dt2.Rows[0]["DelSelfTitle"].ToString());
        int DelOTitle = int.Parse(dt2.Rows[0]["DelOTitle"].ToString());
        int EditSelfTitle = int.Parse(dt2.Rows[0]["EditSelfTitle"].ToString());
        int EditOtitle = int.Parse(dt2.Rows[0]["EditOtitle"].ToString());
        int ReadTitle = int.Parse(dt2.Rows[0]["ReadTitle"].ToString());
        string SiteID = dt4.Rows[0]["SiteID"].ToString();
        int i, j;
        DataTable dt = inf.GetPage(title, Um, dtm1, dtm2, isCheck, islock, SiteID, UserNum, DelOTitle, EditOtitle, PageIndex, 10, out i, out j, null);

        this.PageNavigator1.PageCount = j;
        this.PageNavigator1.PageIndex = PageIndex;
        this.PageNavigator1.RecordCount = i;
        no.InnerHtml = "";
        if (dt != null && dt.Rows.Count > 0)
        {
            dt.Columns.Add("GoodTitles", typeof(string));
            dt.Columns.Add("OrderIDs", typeof(string));
            dt.Columns.Add("islocks", typeof(string));
            dt.Columns.Add("InfoTitle", typeof(string));
            dt.Columns.Add("APIIDTitle", typeof(string));
            dt.Columns.Add("Operation", typeof(string));
            dt.Columns.Add("isChecks", typeof(string));
            dt.Columns.Add("Titles", typeof(string));
            foreach (DataRow h in dt.Rows)
            {
                if (h["GoodTitle"].ToString() == "1")
                {
                    h["GoodTitles"] = "<img src=\"../../sysImages/normal/best.jpg\" border=\"0\" alt=\"精华帖\" />";
                }
                else
                {
                    h["GoodTitles"] = "";
                }
                if (h["OrderID"].ToString() == "2")
                {
                    h["OrderIDs"] = "<img src=\"../../sysImages/folder/news_top.gif\" border=\"0\" alt=\"固顶\" />";
                }
                else
                {
                    h["OrderIDs"] = "<img src=\"../../sysImages/folder/news_common.gif\" border=\"0\"/>";
                }
                if (h["islock"].ToString() == "0")
                {
                    h["islocks"] = "否";
                }
                else 
                {
                    h["islocks"] = "是";
                }
                if(h["APIID"].ToString()=="0")
                {
                    h["InfoTitle"] = my.sel_newsClass(h["InfoID"].ToString(), h["DataLib"].ToString());
                    h["APIIDTitle"]="新闻";
                }
                if (h["isCheck"].ToString() == "0")
                {
                    h["isChecks"] = "未通过";
                }
                else 
                {
                    h["isChecks"] = "已通过";
                }
                string del1=null;
                string Edit=null;
                string delEdit = null;

                h["Titles"] = "<a href=\"mycom_Look.aspx?Commid=" + h["Commid"].ToString() + "\" class=\"list_link\">" + h["Content"].ToString() + "</a>";

                Edit="<a href=\"mycom_up.aspx?Commid=" + h["Commid"].ToString() + "\" class=\"list_link\">编辑</a>┆<input name=\"Checkbox1\" type=\"checkbox\" value=" + h["Commid"].ToString() + "  runat=\"server\" />";
                del1="<a href=\"#\" onclick=\"javascript:del('" + h["Commid"].ToString() + "');\" class=\"list_link\">删除</a>┆<input name=\"Checkbox1\" type=\"checkbox\" value=" + h["Commid"].ToString() + "  runat=\"server\" />";
                delEdit = "<a href=\"mycom_up.aspx?Commid=" + h["Commid"].ToString() + "\" class=\"list_link\">编辑</a>┆<a href=\"#\" onclick=\"javascript:del('" + h["Commid"].ToString() + "');\" class=\"list_link\">删除</a>┆<input name=\"Checkbox1\" type=\"checkbox\" value=" + h["Commid"].ToString() + "  runat=\"server\" />";

                if ((h["UserNum"].ToString() == NetCMS.Global.Current.UserName))
                {
                    if (EditSelfTitle == 1 && DelSelfTitle != 1)
                    {
                        h["Operation"] = Edit;
                    }
                    if (DelSelfTitle == 1 && EditSelfTitle != 1)
                    {
                        h["Operation"] = del1;
                    }
                    if (DelSelfTitle == 1 && EditSelfTitle == 1)
                    {
                        h["Operation"] = delEdit;
                    }
                }
                else
                {
                    if (EditOtitle == 1 && DelOTitle != 1)
                    {
                        h["Operation"] = Edit;
                    }
                    if (EditOtitle != 1 && DelOTitle == 1)
                    {
                        h["Operation"] = del1;
                    }
                    if (EditOtitle == 1 && DelOTitle == 1)
                    {
                        h["Operation"] = del1;
                    }
                }
                    
            }             
            DataList1.Visible = true;
            DataList1.DataSource = dt;
            DataList1.DataBind();
            DataList1.Dispose();
            sc.InnerHtml = Show_scs();
        }      
        else
        {
            string UserNums = NetCMS.Global.Current.UserNum;
            string sel_GroupNumberp = inf.sel_sysUser(UserNums,0).Rows[0]["UserGroupNumber"].ToString();
            DataTable dts1 = inf.sel_sysUser(sel_GroupNumberp,3);
            int TopTitles = int.Parse(dts1.Rows[0]["TopTitle"].ToString());
            int GoodTitles = int.Parse(dts1.Rows[0]["GoodTitle"].ToString());
            int CheckTtiles = int.Parse(dts1.Rows[0]["CheckTtile"].ToString());
            int OCTFs = int.Parse(dts1.Rows[0]["OCTF"].ToString());
            if (TopTitles == 1)
            {
                Button bt11 = (Button)Page.FindControl("TopTitle1");
                bt11.Visible = false;
                Button bt12 = (Button)Page.FindControl("TopTitle12");
                bt12.Visible = false;
            }
            if (GoodTitles == 1)
            {
                Button bt13 = (Button)Page.FindControl("GoodTitle");
                bt13.Visible = false;
            }
            if (CheckTtiles == 1)
            {
                Button bt14 = (Button)Page.FindControl("CheckTtile");
                bt14.Visible = false;
            }
            if (OCTFs == 1)
            { 
                Button bt15 = (Button)Page.FindControl("OCTF1");
                bt15.Visible = false;
                Button bt16 = (Button)Page.FindControl("OCTF2");
                bt16.Visible = false;                
            }
            no.InnerHtml = show_no();
            sc.InnerHtml = Show_sc();
            this.PageNavigator1.Visible = false;
        }
    }
    #endregion
    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'>";
        nos = nos + "<td class='navi_link'>没有数据</td>";
        nos = nos + "</tr>";
        nos = nos + "</table>";
        DataList1.Visible = false;