special_list.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.Model;

public partial class manage_news_Special_List : NetCMS.Web.UI.ManagePage
{
    public manage_news_Special_List()
    {
        Authority_Code = "C038";
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        Response.CacheControl = "no-cache";                        //设置页面无缓存
        if (!IsPostBack)
        {
            
            copyright.InnerHtml = CopyRight;            //获取版权信息
            StartLoad(1);
        }
        string Type = Request.QueryString["Type"];  //取得操作类型
        string ID = Request.QueryString["ID"];  //取得需要操作的专题ID
        string Mode = Request.QueryString["Mode"];
        switch (Type)
        {
            case "Lock":            //锁定专题
                Lock(NetCMS.Common.Input.checkID(ID));
                break;
            case "UnLock":          //解锁专题
                UnLock(NetCMS.Common.Input.checkID(ID));
                break;
            case "PDel":            //批量删除专题
                this.Authority_Code = "C037";
                this.CheckAdminAuthority();
                PDel(Mode);
                break;
            case "PUnlock":         //批量解锁专题
                this.Authority_Code = "C041";
                this.CheckAdminAuthority();
                PUnlock();
                break;
            case "Plock":           //批量锁定专题
                this.Authority_Code = "C041";
                this.CheckAdminAuthority();
                Plock();
                break;
            case "Publish":
                Publish();
                break;
            default:
                break;
        }
        if (SiteID == "0")
        {
            string getSiteID = Request.QueryString["SiteID"];
            if (getSiteID != null && getSiteID != "")
            {
                channelList.InnerHtml = "  " + SiteList(getSiteID);
            }
            else
            {
                channelList.InnerHtml = "  " + SiteList(SiteID);
            }
        }
        this.PageNavigator1.OnPageChange += new PageChangeHandler(PageNavigator1_PageChange);
    }


    string SiteList(string SessionSiteID)
    {
        NetCMS.Content.UserMisc ud = new NetCMS.Content.UserMisc();
        string siteStr = "<select class=\"form\" name=\"SiteID\" id=\"SiteID\" onChange=\"getchanelInfo(this)\">\r";
        DataTable crs = ud.getSiteList();
        if (crs != null)
        {
            for (int i = 0; i < crs.Rows.Count; i++)
            {
                string getSiteID = SessionSiteID;
                string SiteID1 = crs.Rows[i]["ChannelID"].ToString();
                if (getSiteID != SiteID1)
                {
                    siteStr += "<option value=\"" + crs.Rows[i]["ChannelID"] + "\">==" + crs.Rows[i]["CName"] + "==</option>\r";
                }
                else
                {
                    siteStr += "<option value=\"" + crs.Rows[i]["ChannelID"] + "\"  selected=\"selected\">==" + crs.Rows[i]["CName"] + "==</option>\r";
                }
            }
        }
        //}
        siteStr += "</select>\r";
        return siteStr;
    }

    /// <summary>
    /// 分页
    /// </summary>
    /// <returns>分页</returns>
    /// Code By DengXi

    protected void PageNavigator1_PageChange(object sender, int PageIndex)
    {
        StartLoad(PageIndex);
    }
    protected void StartLoad(int PageIndex)
    {
        int i, j;
        string site = Request.QueryString["SiteID"];
        if (site != "" && site != null)
        {
            site = Request.QueryString["SiteID"];
        }
        else
        {
            if (SiteID != "0")
            {
                site = SiteID;
            }
            else
            {
                site = "0";
            }
        }
        SQLConditionInfo st = new SQLConditionInfo("@SiteID", site);
        DataTable dt = NetCMS.Content.Pagination.GetPage(this.GetType().Name, PageIndex, 20, out i, out j, st);

        this.PageNavigator1.PageCount = j;
        this.PageNavigator1.PageIndex = PageIndex;
        this.PageNavigator1.RecordCount = i;
        if (dt != null)
        {
            dt.Columns.Add("Op", typeof(string));
            dt.Columns.Add("Look", typeof(string));
            dt.Columns.Add("Lock", typeof(string));
            dt.Columns.Add("Colum", typeof(string));
            for (int k = 0; k < dt.Rows.Count; k++)
            {
                string strchar = null;
                //取出子类
                dt.Rows[k]["Op"] = "<a href=\"javascript:Update('" + dt.Rows[k]["SpecialID"] + "');\" class=\"list_link\">"+
                                   "<img src=\"../../sysImages/"+NetCMS.Config.UIConfig.CssPath()+"/sysico/edit.gif\" border=\"0\" alt=\"修改此专题\" /></a>"+
                                   "<a href=\"javascript:Lock('" + dt.Rows[k]["SpecialID"] + "');\" class=\"list_link\">"+
                                   "<img src=\"../../sysImages/"+NetCMS.Config.UIConfig.CssPath()+"/sysico/lock.gif\" border=\"0\" alt=\"锁定此专题\" /></a>"+
                                   "<a href=\"javascript:UnLock('" + dt.Rows[k]["SpecialID"] + "');\" class=\"list_link\">"+
                                   "<img src=\"../../sysImages/"+NetCMS.Config.UIConfig.CssPath()+"/sysico/unlock.gif\" border=\"0\" alt=\"解锁此专题\" /></a>"+
                                   "<a href=\"javascript:AddChild('" + dt.Rows[k]["SpecialID"] + "');\" class=\"list_link\">"+
                                   //"<img src=\"../../sysImages/"+NetCMS.Config.UIConfig.CssPath()+"/sysico/addclass.gif\" border=\"0\" alt=\"添加子专题\" /></a>"+
                                   // "<a href=\"news_review.aspx?ID=" + dt.Rows[k]["SpecialID"] + "&type=special\" target=\"_blank\" class=\"list_link\">" +
                                   // "<img src=\"../../sysImages/" + NetCMS.Config.UIConfig.CssPath() + "/sysico/review.gif\" border=\"0\" alt=\"添加子专题\" /></a>" +
                                   "<input type=\"checkbox\" value=\"'" + dt.Rows[k]["SpecialID"] + "'\" id=\"S_ID\" name=\"S_ID\" />";
                strchar += "<tr class=\"TR_BG_list\" onmouseover=\"javascript:overColor(this);\" onmouseout=\"javascript:outColor(this);\">";
                strchar += "<td align=\"left\" valign=\"middle\" title=\"专题ID：" + dt.Rows[k]["SpecialID"] + "\">" + dt.Rows[k]["SpecialCName"] + "</td>";
                strchar += "<td align=\"left\" valign=\"middle\" >" + dt.Rows[k]["CreatTime"] + "</td>";
                if (dt.Rows[k]["isLock"].ToString() == "1")
                    dt.Rows[k]["Lock"] = "<font color=\"red\">锁定</a>";
                else
                    dt.Rows[k]["Lock"] = "正常";
                strchar += "<td align=\"left\" valign=\"middle\" >" + dt.Rows[k]["Lock"] + "</td>";
                dt.Rows[k]["Look"] = "<a href=\"news_list.aspx?specialID=" + dt.Rows[k]["SpecialID"] + "\" class=\"list_link\">"+
                                     "<img src=\"../../sysImages/folder/review.gif\" border=\"0\" alt=\"查看所属此专题的所有新闻\" /></a>"+
                                     "(" + GetSpicaelNewsNum(dt.Rows[k]["SpecialID"].ToString()) + ")";
                strchar += "<td align=\"left\" valign=\"middle\" >" + dt.Rows[k]["Look"] + "</td>";
                strchar += "<td align=\"left\" valign=\"middle\" >" + dt.Rows[k]["Op"] + "</td>";
                strchar += "</tr>";
                strchar += ChileList(dt.Rows[k]["SpecialID"].ToString(), "├");
                dt.Rows[k]["Colum"] = strchar;
            }
            DataList1.DataSource = dt;
            DataList1.DataBind();
            dt.Clear();
            dt.Dispose();
        }
    }

    //递归
    protected string ChileList(string Classid, string sign)
    {
        string strchar = null;
        NetCMS.Content.Special sc = new NetCMS.Content.Special();
        DataTable dv = sc.getChildList(Classid);
        sign += "─";
        if (dv != null)
        {
            dv.Columns.Add("Op", typeof(string));
            dv.Columns.Add("Look", typeof(string));