friend_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;
using NetCMS.Content.Common;


public partial class manage_Friend_Friend_List : NetCMS.Web.UI.ManagePage
{
    public manage_Friend_Friend_List()
    {
        Authority_Code = "S014";
    }
    FrindLink fl = new FrindLink();
    public DataTable dt_class;
    rootPublic log = new rootPublic();
    protected void Page_Load(object sender, EventArgs e)
    {
        this.PageNavigator1.OnPageChange += new PageChangeHandler(PageNavigator1_PageChange);
        this.PageNavigator2.OnPageChange += new PageChangeHandler(PageNavigator2_PageChange);
        Response.CacheControl = "no-cache"; //清除缓存
        if (!IsPostBack) //判断页面是否重载
        {
            //判断用户是否登录
            copyright.InnerHtml = CopyRight; //获取版权信息
            ParamStartLoad(); //载入初始参数设置页面数据
            FriendClassManage(1); //初始分页数据
            FriendLinkManage(1);//初始分页数据
            StartUser();

            #region 参数
            string type = Request.QueryString["type"];
            if (type != null && type != "")
            {
                switch (type.ToString())
                {
                    case "edit_class"://修改
                        this.Authority_Code = "S015";
                        this.CheckAdminAuthority();
                        EditClass_Start();
                        break;
                    case "edit_link":
                        this.Authority_Code = "S015";
                        this.CheckAdminAuthority();
                        Edit_Link_Start();
                        break;
                    case "delone_class"://删除单个
                        this.Authority_Code = "S015";
                        this.CheckAdminAuthority();
                        DelOne_Class();
                        break;
                    case "delone_link":
                        this.Authority_Code = "S015";
                        this.CheckAdminAuthority();
                        DelOne_Link();
                        break;
                    case "suo":
                        this.Authority_Code = "S015";
                        this.CheckAdminAuthority();
                        Suo();
                        break;
                    case "unsuo":
                        this.Authority_Code = "S015";
                        this.CheckAdminAuthority();
                        Unsuo();
                        break;
                }
            }
            #endregion
        }
        #region
        SelectClass.Items.Clear();
        getClassInfo();
        #endregion
        GetParentValue();  //父类编号
        ShowNavi.InnerHtml = ShowNaviFunc(); //显示功能导航菜单
    }

    /// <summary>
    /// 取栏目信息
    /// </summary>

    #region
    protected void getClassInfo()
    {
        dt_class = fl.GetClass();
        if (dt_class != null)
        {
            ClassRender("0", 0);
        }
        dt_class.Clear();
        dt_class.Dispose();
    }
    #endregion

    /// <summary>
    /// 递归
    /// </summary>
    /// <param name="PID"></param>
    /// <param name="Layer"></param>

    #region
    private void ClassRender(string PID, int Layer)
    {
        DataRow[] row = dt_class.Select("ParentID='" + PID + "'");
        if (row.Length < 1)
            return;
        else
        {
            foreach (DataRow r in row)
            {
                ListItem it = new ListItem();
                it.Value = r["ClassID"].ToString();
                string stxt = "┝";
                for (int i = 0; i < Layer; i++)
                {
                    stxt += "┉";
                }
                it.Text = stxt + r["ClassCName"].ToString();
                this.SelectClass.Items.Add(it);
                ClassRender(r["ClassID"].ToString(), Layer + 1);
            }
        }
    }
    #endregion

    #region 分页
    protected void PageNavigator1_PageChange(object sender, int PageIndex)
    {
        FriendClassManage(PageIndex);//管理页面分页查询
    }
    protected void PageNavigator2_PageChange(object sender, int PageIndex)
    {
        FriendLinkManage(PageIndex);//管理页面分页查询
    }
    #endregion

    /// <summary>
    /// 显示功能菜单
    /// </summary>
    /// <returns></returns>
    ///code by chenzhaohui 

    #region 显示功能菜单
    string ShowNaviFunc()
    {
        string strlist = "";
        string strlist1 = "";
        strlist += "<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"5\" cellspacing=\"1\" class=\"Navitable\">\n";
        strlist += "<tr class=\"list_link\"><td height=\"18\" style=\"width: 45%\" colspan=\"2\" style=\"padding-left:14px;\">\n";
        string _tmplet = "";
        if (SiteID == "0")
        {
            _tmplet = "<a href=\"Friend_List.aspx?type=pram\" class=\"list_link\"><a href=\"?type=pram\" class=\"list_link\">参数设置</a>&nbsp;┊&nbsp;";
        }
        strlist += _tmplet + "<a href=\"?type=class\" class=\"menulist\">分类管理</a>\n";
        strlist1 += "┆&nbsp;<a href=\"?type=link\" class=\"menulist\">连接管理</a>\n";
        strlist += strlist1;
        strlist += "</td></tr></table> \n";
        return strlist;

    }
    #endregion

    /// <summary>
    /// 载入初始参数设置数据
    /// </summary>
    /// code by chenzhaohui

    #region 载入初始参数设置数据
    void ParamStartLoad()
    {
        DataTable dt = fl.ParamStart();
        if (dt.Rows.Count > 0)
        {
            #region 参数设置
            if (dt.Rows[0]["IsOpen"].ToString() == "1")
            {
                IsOpen.Checked = true;
            }
            else
            {
                IsOpen.Checked = false;
            }
            if (dt.Rows[0]["IsRegister"].ToString() == "1")
            {
                IsRegister.Checked = true;
            }
            else
            {
                IsRegister.Checked = false;
            }
            ArrSize.Text = dt.Rows[0]["ArrSize"].ToString();
            Content.Value = NetCMS.Common.Input.ToTxt(dt.Rows[0]["Content"].ToString());
            if (dt.Rows[0]["isLock"].ToString() == "1")
            {
                isLock.Checked = true;
            }
            else
            {
                isLock.Checked = false;
            }
            #endregion
        }
    }
    #endregion

    /// <summary>
    /// 保存参数设置
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    /// code by chenzhaohui

    #region 保存参数设置
    protected void SavePram_ServerClick(object sender, EventArgs e)
    {
        if (SiteID != "0")
        {
            PageError("你没有此项的操作权限。", "");
        }
        if (Page.IsValid)//判断页面是否通过验证
        {
            #region 取得投票参数设置添加中的表单信息
            int open = 0, IsReg = 0, isLok = 0;
            if (IsOpen.Checked == true)
            {
                open = 1;
            }
            if (IsRegister.Checked == true)
            {
                IsReg = 1;
            }
            if (isLock.Checked == true)
            {
                isLok = 1;
            }
            string Str_ArrSize = this.ArrSize.Text.Trim();//图片尺寸
            string Str_Content = this.Content.Value.Trim();//注册须知;
            #endregion

            #region 向数据库中写入添加的参数设置信息
            int up_pram = fl.Update_Pram(open, IsReg, isLok, Str_ArrSize, Str_Content);
            #endregion

            #region 载入数据-刷新页面
            if (up_pram != 0)
            {
                log.SaveUserAdminLogs(1, 1, UserNum, "友情连接参数设置", "友情连接参数设置成功！");
                PageRight("友情连接参数设置成功", "Friend_List.aspx?type=pram");
            }
            else
            {
                PageError("意外错误：未知错误<br />", "shortcut_list.aspx");
            }
            #endregion
        }
    }
    #endregion

    /// <summary>
    /// 分类管理页
    /// </summary>
    /// <param name="PageIndex"></param>
    /// code by chenzhaohui

    #region 分类管理页
    protected void FriendClassManage(int PageIndex)//显示类别管理页面
    {
        int i, j;
        DataTable dt = NetCMS.Content.Pagination.GetPage("manage_Friend_Friend_List_1_aspx", PageIndex, PAGESIZE, out i, out j, null);
        this.PageNavigator1.PageCount = j;
        this.PageNavigator1.PageIndex = PageIndex;
        this.PageNavigator1.RecordCount = i;
        try
        {
            if (dt != null)//判断如果dt里面没有内容，将不会显示
            {
                if (dt.Rows.Count > 0)
                {
                    //添加列
                    dt.Columns.Add("oPerate", typeof(String));//操作
                    dt.Columns.Add("Colum", typeof(String));

                    for (int k = 0; k < dt.Rows.Count; k++)
                    {
                        String strchar = null;
                        string id = dt.Rows[k]["ClassID"].ToString();
                        dt.Rows[k]["ClassCName"] = "<a href='Friend_List.aspx?type=edit_class&id=" + id + "' class='list_link' title='点击查看详情或修改'>" + dt.Rows[k]["ClassCName"].ToString() + "</a>";
                        dt.Rows[k]["oPerate"] = "<a href=\"Friend_List.aspx?type=edit_class&id=" + id + "\"  class=\"list_link\" title=\"修改此项\"><img src=\"../../sysImages/" + NetCMS.Config.UIConfig.CssPath() + "/sysico/edit.gif\" border=\"0\" alt=\"修改此项\" /></a><a href=\"Friend_List.aspx?type=delone_class&id=" + id + "\"  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=\"Friend_List.aspx?type=add_class&parentid=" + id + "\" class=\"list_link\" title=\"添加子类\"><img src=\"../../sysImages/" + NetCMS.Config.UIConfig.CssPath() + "/sysico/addclass.gif\" border=\"0\" alt=\"添加子类\" /></a><input type='checkbox' name='friend_checkbox' id='friend_checkbox' value=\"" + id + "\"/>";
                        strchar += "<tr class=\"TR_BG_list\">";
                        strchar += "<td  align=\"left\" valign=\"middle\" >" + dt.Rows[k]["ClassCName"] + "</td>";
                        strchar += "<td  align=\"center\" valign=\"middle\" >" + dt.Rows[k]["Content"] + "</td>";
                        strchar += "<td  align=\"center\" valign=\"middle\" >" + dt.Rows[k]["oPerate"] + "</td>";
                        strchar += "</tr>";
                        strchar += GetChildList(dt.Rows[k]["ClassID"].ToString(), "┝");
                        dt.Rows[k]["Colum"] = strchar;
                    }
                }
                else
                {
                    NoContent.InnerHtml = Show_NoContent();
                    this.PageNavigator1.Visible = false;
                }
            }
            else
            {
                NoContent.InnerHtml = Show_NoContent();
                this.PageNavigator1.Visible = false;
            }
        }
        catch { }
        DataList1.DataSource = dt;
        DataList1.DataBind();
    }
    #endregion

    /// <summary>
    /// 递归
    /// </summary>
    /// <param name="Classid"></param>
    /// <param name="sign"></param>
    /// <returns></returns>

    #region 递归
    string GetChildList(string Classid, string sign)
    {
        String strchar = null;
        DataTable _dt = fl.GetChildClassList(Classid);
        sign += "┄";
        _dt.Columns.Add("oPerate", typeof(String));
        for (int pi = 0; pi < _dt.Rows.Count; pi++)
        {
            string id = _dt.Rows[pi]["ClassID"].ToString();
            _dt.Rows[pi]["ClassCName"] = "<a href='Friend_List.aspx?type=edit_class&id=" + id + "' class='list_link' title='点击查看详情或修改'>" + _dt.Rows[pi]["ClassCName"].ToString() + "</a>";
            //操作
            _dt.Rows[pi]["oPerate"] = "<a href=\"Friend_List.aspx?type=edit_class&id=" + id + "\"  class=\"list_link\" title=\"修改此项\"><img src=\"../../sysImages/folder/re.gif\" border=\"0\" alt=\"修改此项\" /></a><a href=\"Friend_List.aspx?type=delone_class&id=" + id + "\"  class=\"list_link\" title=\"删除此项\" onclick=\"{if(confirm('确认删除吗？')){return true;}return false;}\"><img src=\"../../sysImages/folder/del.gif\" border=\"0\" alt=\"删除此项\" /></a><a href=\"Friend_List.aspx?type=add_class&parentid=" + id + "\" class=\"list_link\" title=\"添加子类\"><img src=\"../../sysImages/folder/new.gif\" border=\"0\" alt=\"添加子类\" /></a><input type='checkbox' name='friend_checkbox' id='friend_checkbox' value=\"" + id + "\"/>";
            strchar += "<tr class=\"TR_BG_list\">";
            strchar += "<td  align=\"left\" valign=\"middle\" >" + sign + _dt.Rows[pi]["ClassCName"] + "</td>";
            strchar += "<td  align=\"center\" valign=\"middle\" >" + _dt.Rows[pi]["Content"] + "</td>";
            strchar += "<td  align=\"center\" valign=\"middle\" >" + _dt.Rows[pi]["oPerate"] + "</td>";
            strchar += "</tr>";
            strchar += GetChildList(_dt.Rows[pi]["ClassID"].ToString(), sign);
        }
        return strchar;

    }
    #endregion

    /// <summary>
    /// 连接管理页
    /// </summary>
    /// <param name="PageIndex"></param>
    /// code by chenzhaohui

    #region 连接管理页
    protected void FriendLinkManage(int PageIndex)//显示连接管理页面
    {
        int i, j;
        DataTable dt = NetCMS.Content.Pagination.GetPage("manage_Friend_Friend_List_2_aspx", PageIndex, PAGESIZE, out i, out j, null);
        this.PageNavigator2.PageCount = j;
        this.PageNavigator2.PageIndex = PageIndex;
        this.PageNavigator2.RecordCount = i;
        try
        {
            if (dt != null)//判断如果dt里面没有内容，将不会显示
            {
                if (dt.Rows.Count > 0)
                {
                    //添加列
                    dt.Columns.Add("class", typeof(String));//类别
                    dt.Columns.Add("type", typeof(String));//类型
                    dt.Columns.Add("author", typeof(String));//作者
                    dt.Columns.Add("lock", typeof(String));//锁定
                    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 LinkUrl = dt.Rows[k]["Url"].ToString();
                        string siteName = dt.Rows[k]["Name"].ToString();
                        string ClassID = dt.Rows[k]["ClassID"].ToString();