view.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 System.ComponentModel;
using System.Drawing;
using System.Web.SessionState;
using NetCMS.Content;
using NetCMS.Content.Common;
using NetCMS.Model;

public partial class Manage_Stat_View : NetCMS.Web.UI.ManagePage
{
    public Manage_Stat_View()
    {
        Authority_Code = "S001";
    }
    Stat sta = new Stat();
    rootPublic rd = new rootPublic();
    #region 定义全局变量
    public static DataView dv;//公用视图dv
    public string strtheurl;//当前地址
    public string statid;//编号
    #endregion

    #region 取得服务器变量集合
    System.Collections.Specialized.NameValueCollection ServerVariables = System.Web.HttpContext.Current.Request.ServerVariables;
    #endregion

    public string isDataBase = "";//是否是独立的数据库
    public string OnlyBaseConn = "";//独立数据库连接路径

    protected void Page_Load(object sender, EventArgs e)
    {
        #region 在此处放置用户代码以初始化页面

        #region 分页调用函数
        this.PageNavigator1.OnPageChange += new PageChangeHandler(PageNavigator1_PageChange);
        this.PageNavigator2.OnPageChange += new PageChangeHandler(PageNavigator2_PageChange);
        #endregion

        #region 查询方法返回视图
        DataTable tb = sta.sel();
        dv = tb.DefaultView;
        #endregion

        Response.CacheControl = "no-cache";//设置页面无缓存

        string act = Request.QueryString["act"];
        statmethod.InnerHtml = StatMehtodd();                                   //功能菜单
        if (!IsPostBack)
        {

            copyright.InnerHtml = CopyRight;
            ParamStartLoad();//载入初始参数设置页面数据
            StatList(1);    //分页初始化
            ClassList(1);    //分页初始化
            ZongHeStat();   //综合统计页面数据
            switch (act)
            {
                case "edit":
                    this.Authority_Code = "S003";
                    this.CheckAdminAuthority();
                    EditClass();//修改
                    break;
                case "delone":
                    this.Authority_Code = "S003";
                    this.CheckAdminAuthority();
                    DelOne();//单个删除
                    break;
            }
        }
        ShowNavi.InnerHtml = ShowNaviFunc();                            //功能菜单
        CodeUseTable.InnerHtml = GetCodeUse();                          //代码调用页面
        #endregion
    }
    /// <summary>
    /// 分页
    /// </summary>
    /// <returns>取得分页信息</returns>
    /// Code By ChenZhaohui

    protected void PageNavigator1_PageChange(object sender, int PageIndex)
    {
        StatList(PageIndex);//管理页面分页查询
    }
    protected void PageNavigator2_PageChange(object sender, int PageIndex)
    {
        ClassList(PageIndex);//类别页面分页查询
    }

    /// <summary>
    /// 初始分类
    /// </summary>
    /// <returns>取得分类信息</returns>
    /// Code By ChenZhaohui

    void EditClass()
    {
        string id = Request.QueryString["id"];
        #region 从统计分类设置表中读出数据并初始化赋值
        classnameEdit.Text = sta.sel_statInfoById(id);
        #endregion
    }

    /// <summary>
    /// 显示功能菜单
    /// </summary>
    /// <returns>返回功能菜单</returns>
    ///  Code By ChenZhaohui


    #region 显示功能菜单
    string ShowNaviFunc()
    {
        string typ = Request.QueryString["type"];
        string strlist = "";
        if (typ != "zonghe" && typ != "all" && typ != "hour" && typ != "day" && typ != "week" && typ != "month" && typ != "page" && typ != "ip" && typ != "cs" && typ != "area" && typ != "come" && typ != "code")
        {
            strlist += "<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"5\" cellspacing=\"1\" class=\"Navitable\">\n";
            strlist += "<tr class=\"menulist\"><td height=\"18\" style=\"width: 45%\" colspan=\"2\" >\n";
            string _tmplet = "";
            if (NetCMS.Global.Current.SiteID == "0")
            {
                _tmplet = "<a href=\"View.aspx?type=pram\" class=\"menulist\">参数设置</a>&nbsp;┊&nbsp; ";
            }
            strlist += _tmplet + "<a href=\"?type=class\" class=\"menulist\">分类管理</a>\n";
            strlist += "</td></tr></table> \n";
        }
        return strlist;

    }
    #endregion

    /// <summary>
    /// 删除单个分类数据
    /// </summary>
    ///code by chenzhaohui 

    #region 删除单个分类数据
    void DelOne()
    {
        string ID = Request.QueryString["ID"];
        if (ID == null)
        {
            rd.SaveUserAdminLogs(1, 1, UserNum, "统计分类删除单个类别", "参数错误");
            PageError("错误的参数传递!", "View.aspx?type=class");
        }
        else
        {

            bool s1 = sta.del_statSql(ID,0);
            bool s2 = sta.del_statSql(ID,1);
            bool s3 = sta.del_statSql(ID,2);
            if (s1 && s2 && s3)
            {
                rd.SaveUserAdminLogs(1, 1, UserNum, "统计分类删除单个类别", "删除成功");
                PageRight("删除成功。", "View.aspx?type=class");
            }
            else
            {
                rd.SaveUserAdminLogs(1, 1, UserNum, "统计分类删除单个类别", "意外错误");
                PageError("意外错误：未知错误", "shortcut_list.aspx");
            }
        }
    }
    #endregion

    /// <summary>
    /// 初始化参数设置页面
    /// </summary>
    ///code by chenzhaohui 

    #region 初始化参数设置页面
    void ParamStartLoad()
    {
        #region 从统计参数设置表中读出数据并初始化赋值
        DataTable dt = sta.sel();
        if (dt != null)
        {
            if (dt.Rows.Count > 0)
            {
                #region 统计参数设置
                SystemName.Text = dt.Rows[0]["SystemName"].ToString();
                SystemNameE.Text = dt.Rows[0]["SystemNameE"].ToString();
                ipCheck.Text = dt.Rows[0]["ipCheck"].ToString();
                ipTime.Text = dt.Rows[0]["ipTime"].ToString();
                isOnlinestat.Text = dt.Rows[0]["isOnlinestat"].ToString();
                pageNum.Text = dt.Rows[0]["pageNum"].ToString();
                cookies.Text = dt.Rows[0]["cookies"].ToString();
                pointNum.Text = dt.Rows[0]["pointNum"].ToString();
                #endregion
            }
        }
        #endregion
    }
    #endregion

    /// <summary>
    /// 保存参数设置事件函数
    /// </summary>
    /// <returns>保存参数设置事件函数</returns>
    /// Code By ChenZhaohui

    protected void savePram_ServerClick(object sender, EventArgs e)
    {
        if (Page.IsValid)//判断页面是否通过验证
        {
            if (SiteID != "0")
            {
                PageError("没有权限", "");
            }
            string Str_SystemNameE =this.SystemNameE.Text;//统计系统英文名称
            if (Str_SystemNameE == null || Str_SystemNameE == string.Empty)
            {
                PageError("对不起，系统英文名称不能为空", "View.aspx?type=pram");
            }
            StatParamInfo sp = new StatParamInfo();
            sp.SystemName = this.SystemName.Text;
            sp.SystemNameE = Str_SystemNameE;
            sp.ipCheck = int.Parse(this.ipCheck.Text);
            sp.ipTime = int.Parse(this.ipTime.Text);
            sp.isOnlinestat = int.Parse(this.isOnlinestat.Text);
            sp.pageNum = int.Parse(this.pageNum.Text);
            sp.pointNum = int.Parse(this.pointNum.Text);
            sp.SiteID = SiteID;
            sp.cookies = this.cookies.Text;
            #region 向数据库中写入添加的统计参数设置信息
            #endregion

            #region 载入数据-刷新页面
            sta.Str_InSql(sp);
            PageRight("统计系统参数设置成功", "View.aspx?type=pram");
            #endregion
        }
    }

    /// <summary>
    /// 统计分类列表
    /// </summary>
    /// <returns>取得分类管理页</returns>
    /// Code By ChenZhaohui

    protected void ClassList(int PageIndex)//显示详细记录
    {
        int i, j;
        int num = sta.Stat_Sql(); ;//从参数设置里取得每页显示记录的条数
        if (num == 0)
        {
            num = 20;
        }
        DataTable dt = NetCMS.Content.Pagination.GetPage("Manage_Stat_View_1_aspx", PageIndex, num, out i, out j, null);

        this.PageNavigator2.PageCount = j;
        this.PageNavigator2.PageIndex = PageIndex;
        this.PageNavigator2.RecordCount = i;
        if (dt != null)//判断如果dt里面没有内容，将不会显示
        {
            if (dt.Rows.Count > 0)
            {
                //添加列
                dt.Columns.Add("oPerate", typeof(String));//操作
                for (int k = 0; k < dt.Rows.Count; k++)
                {
                    int id = int.Parse(dt.Rows[k]["id"].ToString());
                    string classid = dt.Rows[k]["id"].ToString();
                    string statid = dt.Rows[k]["statid"].ToString();

                    dt.Rows[k]["ClassName"] = "<a href=\"View.aspx?act=edit&id=" + statid + "\"  class=\"list_link\" title=\"点击查看详情或修改\">" + dt.Rows[k]["ClassName"].ToString() + "</a>";
                    dt.Rows[k]["oPerate"] = "<a href=\"View.aspx?act=edit&id=" + statid + "\"  class=\"list_link\" title=\"点击查看详情或修改\"><img src=\"../../sysImages/" + NetCMS.Config.UIConfig.CssPath() + "/sysico/edit.gif\" border=\"0\" alt=\"修改此类\" /></a><a href=\"View.aspx?act=delone&id=" + statid + "\"  class=\"list_link\" title=\"点击删除此项\" onclick=\"{if(confirm('确认删除吗？')){return true;}return false;}\"><img src=\"../../sysImages/" + NetCMS.Config.UIConfig.CssPath() + "/sysico/del.gif\" border=\"0\" alt=\"删除此类\" /></a><a href=\"View.aspx?type=zonghe&Navi=view&id=" + statid + "\" class=\"list_link\" title=\"查看该分类下统计信息\"><img src=\"../../sysImages/" + NetCMS.Config.UIConfig.CssPath() + "/sysico/review1.gif\" border=\"0\" alt=\"查看该分类下统计信息\" /></a><input type='checkbox' name='stat_checkbox' id='stat_checkbox' value=\"" + statid + "\"/>";

                }
            }
            else
            {
                NoContent.InnerHtml = Show_NoContent();
                this.PageNavigator2.Visible = false;
            }
        }
        else
        {
            NoContent.InnerHtml = Show_NoContent();