channel_class_manage.aspx.cs

易想商城系统

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.Data.SqlClient;
using System.Text;
using Shop.Web.UI;
namespace YXShop.Web.Admin.Article
{
    public partial class test : System.Web.UI.Page
    {
        public string channelID = "";
        public string allstr = "";
        public string channelBar = "";
        BasePage bp = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!PowerTree.PowerPass.isPass("012002000", PowerTree.PowerPanel.PowerType.look))
            {
                bp = new BasePage();
                bp.PageError("对不起，你没有查看该页面的权限！", "../index.aspx");
            }
            if (Request["channelID"] != "")
            {
                channelID = Request["channelID"].ToString();
            }
            else
            {
                YXShop.Common.alert.show("提供的频道ID有误！");
            }
            if (!Page.IsPostBack)
            {
                InitBindData(channelID);
            }
        }

        #region 初始化具体频道的文章分类
        public void InitBindData(string channelId)
        {
            int ispower = 1;
            if (!PowerTree.PowerPass.isPass("012002003", PowerTree.PowerPanel.PowerType.del))
            {
                ispower = 0;
            }
            BLL.YixiangChannel bll = new BLL.YixiangChannel();
            channelBar = bll.ChannelNavigation(channelId);
            SqlDataReader dr = YXShop.DBUtility.SqlHelper.ExecuteReader(YXShop.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, "SELECT Class_ID,Class_Name,Class_Depth,Class_Path,Parent_ID,Channel_ID FROM YXShop_Class WHERE Channel_ID=" + int.Parse(channelId) + "  ORDER BY Class_Order ");
            StringBuilder strMenu = new StringBuilder();
            strMenu.Append("<table width='100%' border='1' bordercolor='#DEE7F6'  style=' border-collapse:collapse'  cellpadding='1' cellspacing='2'    id='classdrag'><tbody><tr id='0' title='0'  name='0'  bgcolor='#ABCCED'><td width='60%'   height=20><b>类别名称</b></td><td colspan='2' align='center'><b>操作</b></td></tr><tr id='0' title='0' name='0'   ><td height=10 collspan='3'><!--<font color='#6BC5E7'>作为顶级</font>--></td></tr>");
            while (dr.Read())
            {
                strMenu.Append("<tr id='" + dr[0].ToString() + "'  channelId='" + dr["Channel_ID"].ToString() + "'    title='" + dr["Parent_ID"].ToString() + "'    name='" + dr["Class_Path"].ToString() + "'   ><td height=20    style='cursor:hand' >");
                for (int i = 1; i < Convert.ToInt32(dr["Class_Depth"]); i++)
                {
                    strMenu.Append("&nbsp;&nbsp;&nbsp;&nbsp;");
                }
                string tempStr = "";
                if (dr["Class_Depth"].ToString() == "1")
                {
                    tempStr = "<img src='../images/more.gif'>";
                }
                else
                {
                    tempStr = "<img src='../images/less.gif'>";
                }
                strMenu.Append(tempStr + dr[1].ToString() + "&nbsp;</td><td align='center'><a href='Channel_Class_Modify.aspx?Class_ID=" + dr[0].ToString() + "' title='修改类别名称和描述'>修改</a>&nbsp;<font color='#4C799D'>|</font>&nbsp;<a href='Channel_Class_Change.aspx?Class_ID=" + dr[0].ToString() + "&channelID=" + dr["Channel_ID"].ToString() + "' title='移动该类别'>移动</a>&nbsp;<font color='#4C799D'>|</font>&nbsp;<a href='Add_Article.aspx?Class_ID=" + dr[0].ToString() + "&channelID=" + dr["Channel_ID"].ToString() + "' title='添加属于该类别的文章'>添加文章</a>&nbsp;<font color='#4C799D'>|</font>&nbsp;<a href='Article_Manage.aspx?Class_ID=" + dr[0].ToString() + "&channelID=" + dr["Channel_ID"].ToString() + "'  title='管理属于该类别的文章'>文章管理</a><td  align='center'>&nbsp;<a href='Channel_Class_Del.ashx?Class_ID=" + dr[0].ToString() + "&action=del&ispower=" + ispower + "'  onclick='javascript:if(confirm(\"你确定要删除吗？此操作将删除属于该分类的所有文章！此操作不可恢复！\"))return true;else return false;'>删除</a></td></tr>");
            }
            strMenu.Append("</tbody></table>");
            allstr = strMenu.ToString();
            dr.Close();
        }
        #endregion

    }
}