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

public partial class manage_advertisement_list : NetCMS.Web.UI.ManagePage
{
    public string str_dirMana =NetCMS.Config.UIConfig.dirDumm;//获取用户虚拟路径
    protected void Page_Load(object sender, EventArgs e)
    {
        Response.CacheControl = "no-cache";                        //设置页面无缓存

        if (str_dirMana != "" && str_dirMana != null && str_dirMana != string.Empty)
            str_dirMana = "//" + str_dirMana;

        if (!IsPostBack)
        {
            
            copyright.InnerHtml = CopyRight;        //获取版权信息
        }
        string str_Type = Request.QueryString["Type"];
        if (str_Type != "" && str_Type != null)
            GetList(str_Type);
    }

    /// <summary>
    /// 获得功能菜单
    /// </summary>
    /// <param name="type">要显示的类型,分别为Ads,Class,Stat</param>
    /// <returns>获得功能菜单</returns>
    /// Code By DengXi

    protected string GetMenu(string type)
    {
        string temp_Str = "";

        switch (type)
        {
            case "Ads":
                temp_Str += "<table border=\"0\" width=\"98%\"><tr><td width=\"75%\" align=\"left\">" + GetShowType() + "</td>"+
                            "<td align=\"right\"><a href=\"ads_add.aspx\" class=\"list_link\">添加广告</a>&nbsp;┊&nbsp;" +
                            "<a href=\"javascript:DelAll('" + type + "');\" class=\"list_link\">全部删除</a>&nbsp;┊&nbsp;" +
                            "<a href=\"javascript:Del('" + type + "');\" class=\"list_link\">批量删除</a></td></tr></table>";
                break;
            case "Class":
                temp_Str += getSiteList();
                temp_Str += "  <a href=\"adsclass_add.aspx\" class=\"list_link\">添加分类</a>&nbsp;┊&nbsp;" +
                            "<a href=\"javascript:DelAll('" + type + "');\" class=\"list_link\">全部删除</a>&nbsp;┊&nbsp; " +
                            "<a href=\"javascript:Del('" + type + "');\" class=\"list_link\">批量删除</a>";
                break;
            case "Stat":
                temp_Str += getSiteList();
                temp_Str += "  <a href=\"javascript:DelAll('" + type + "');\" class=\"list_link\">全部重置</a>&nbsp;┊&nbsp;" +
                            "<a href=\"javascript:Del('" + type + "');\" class=\"list_link\">批量重置</a>";
                temp_Str += "";
                break;
        }
        string str_TempStr = "<table width=\"100%\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\" align=\"center\">\r";
        str_TempStr += "<tr>\r";
        str_TempStr += "<td style=\"padding-right:15px;\" align=\"right\">\r";
        str_TempStr += temp_Str + "\r";
        str_TempStr += "</td>\r</tr>\r";
        str_TempStr += "</table>\r";
        return str_TempStr;
    }


    /// <summary>
    /// 判断ID是否合法
    /// </summary>
    /// <param name="idlist">要检测的编号</param>
    /// <returns>判断ID是否合法</returns>
    /// Code By DengXi

    protected string CheckID(string idlist)
    {
        idlist = NetCMS.Common.Input.Losestr(idlist);
        if(idlist=="IsNull")
            PageError("请选择要批量操作的内容!", "");
        idlist = NetCMS.Common.Input.CutComma(idlist);
        return idlist;
    }


    /// <summary>
    /// 获得列表
    /// </summary>
    /// <param name="type">要显示列表的类型</param>
    /// <returns>获得列表</returns>
    /// Code By DengXi

    protected void GetList(string type)
    {
        string str_OpType = Request.QueryString["OpType"];
        if (str_OpType != "" && str_OpType != null && str_OpType != string.Empty)
        {
            string str_ID = Request.QueryString["ID"];
            switch (str_OpType)
            { 
                case "adsLock":
                    adsLock(str_ID);
                    break;
                case "adsUnLock":
                    adsUnLock(str_ID);
                    break;
                case "adsDel":
                    adsDel(CheckID(str_ID));
                    break;
                case "adsDelAll":
                    adsDelAll();
                    break;
                case "classDel":
                    classDel(CheckID(str_ID));
                    break;
                case "classDelAll":
                    classDelAll();
                    break;
                case "statDel":
                    statDel(CheckID(str_ID));
                    break;
                case "statDelAll":
                    statDelAll();
                    break;
            }
        }

        string curPage = Request.QueryString["page"];    //当前页码
        string str_TempStr = GetMenu(type);
        int pageSize = 15, page = 0;                     //每页显示数

        if (curPage == "" || curPage == null || curPage == string.Empty) { page = 1; }
        else
        {
            try { page = int.Parse(curPage); }
            catch (Exception e)
            {
                PageError("参数错误！"+e.ToString()+"", "");
            }
        }
        DataTable dt = GetSql(type);
        if (dt != null)
        {
            int Cnt = dt.Rows.Count;

            //获得当前分页数
            int pageCount = Cnt / pageSize;
            if (Cnt % pageSize != 0) { pageCount++; }

            if (page > pageCount) { page = pageCount; }
            if (page < 1) { page = 1; }

            switch (type)
            {
                case "Ads":
                    str_TempStr = str_TempStr + GetPageInfo(dt, page, pageSize, Cnt, pageCount, type);
                    break;
                case "Class":
                    str_TempStr = str_TempStr + GetPageInfo(dt, page, pageSize, Cnt, pageCount, type);
                    break;
                case "Stat":
                    str_TempStr = str_TempStr + GetPageInfo(dt, page, pageSize, Cnt, pageCount, type);
                    break;
            }
            dt.Clear();
            dt.Dispose();
        }
        Response.Write(str_TempStr);
        Response.End();
    }

    /// <summary>
    /// 构造SQL语句
    /// </summary>
    /// <param name="type">要构造SQL语句的类型</param>
    /// <returns>返回SQL语句</returns>
    /// Code By DengXi

    protected DataTable GetSql(string type)
    {
        NetCMS.Model.AdsListInfo ali = new NetCMS.Model.AdsListInfo();

        ali.type = type;
        if (Request.QueryString["SiteID"] != null && Request.QueryString["SiteID"]!=string.Empty)
        {
            ali.showSiteID = Request.QueryString["SiteID"];
        }
        ali.showAdsType = Request.QueryString["showadstype"];
        if (Request.QueryString["adsType"] != null && Request.QueryString["adsType"] != string.Empty)
        {
            ali.adsType =Request.QueryString["adsType"];
        }

        ali.searchType = Request.QueryString["searchType"];
        if (Request.QueryString["SearchKey"] != null && Request.QueryString["SearchKey"] != string.Empty)
        {
            ali.SearchKey =Request.QueryString["SearchKey"];
        }
        NetCMS.Content.Ads.Ads ac = new NetCMS.Content.Ads.Ads();
        DataTable dt = ac.list(ali);
        return dt;
    }


    /// <summary>
    /// 取得分页
    /// </summary>
    /// <param name="page">当前页数</param>
    /// <param name="pageSize">每页显示多少条</param>
    /// <param name="Cnt">总记录数</param>
    /// <param name="url">链接地址</param>
    /// <param name="pageCount">分页总数</param>
    /// <param name="type">要显示的类型</param>
    /// <returns>返回分页</returns>
    /// Code By DengXi