channel_class_change.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 Shop.Web.UI;
namespace YXShop.Web.Admin.Article
{
    public partial class Channel_Class_Change : System.Web.UI.Page
    {
       
        private string _classID = "";
        private string _channelID = "";
        public string channelBar = "";
        private string ClassID
        {
            get { return _classID; }
        }
        private string ChannelID
        {
            get { return _channelID; }
        }
        BasePage bp = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!PowerTree.PowerPass.isPass("012002007", PowerTree.PowerPanel.PowerType.other))
            {
                bp = new BasePage();
                bp.PageError("对不起，你没有移动频道分类的权限！", "../index.aspx");
            }
            if ((Request["Class_ID"] != "") && (Request["channelID"] != ""))
            {
                this._classID = Request["Class_ID"].ToString();
                this._channelID = Request["channelID"].ToString();             
            }
            else
            {
                YXShop.Common.alert.show("发现异常！参数传递错误！");
            }
            if (!Page.IsPostBack)
            {
                BindChannelClass(this.ClassID, this.ChannelID, this.ClassList);
                changeBtn.Attributes.Add("onclick", "javascript:return confirm('你确认要执行此操作吗？')");
            }
        }

        #region 绑定可以转换的分类
        public void BindChannelClass(string classId, string channelId,System.Web.UI.WebControls.ListBox listbox )
        {
            BLL.YixiangChannel bll = new BLL.YixiangChannel();
            listbox.Items.Clear();
            channelBar = bll.ChannelNavigation(channelId);
            SqlDataReader dr = YXShop.DBUtility.SqlHelper.ExecuteReader(YXShop.DBUtility.SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, "SELECT  Class_ID,Class_Name,Class_Depth FROM YXShop_Class WHERE Channel_ID=" + channelId + " AND CHARINDEX('|" + YXShop.Common.WebUtility.InputText(classId, classId.Length) + "|','|'+Class_Path+'|',0)=0  ORDER BY Class_Order ");
            listbox.Items.Add(new ListItem("→转换成顶级类别","0"));
            while (dr.Read())
            {
                string tempText = "";
                string spaceStr = "";
                
                for (int i = 1; i < Convert.ToInt32(dr["Class_Depth"]); i++)
                {
                    spaceStr += "";
                }
                tempText = spaceStr + "→"+dr[1].ToString();
              listbox.Items.Add(new ListItem(tempText, dr[0].ToString()));
            }

            dr.Close();
        }
        #endregion

        #region 转换事件
        protected void changeBtn_Click(object sender, ImageClickEventArgs e)
        {
            if (ClassList.SelectedIndex == -1)
            {
                YXShop.Common.alert.show("请选择一个你所要转换至的类别！");
             }
            else
            {
                int result = Update_Class(this.ClassID, ClassList.SelectedValue.ToString(), this._channelID);
                if (result == 0)
                {
                    YXShop.Common.alert.showAndGo("转换成功！", "Channel_Class_Manage.aspx?channelID="+this.ChannelID+"");
                }
                else
                { 
                 YXShop.Common.alert.showAndGo("发生异常！转换失败！", "Channel_Class_Manage.aspx?channelID="+this.ChannelID+"");                
                }
            }
        }
        #endregion

        #region 执行转换
        public int Update_Class(string Class_ID, string Parent_ID,string Channel_ID)
        {
            YXShop.BLL.YixiangChannelClass bll = new YXShop.BLL.YixiangChannelClass();
            return bll.UpdateChannelClassSimple(Class_ID, Parent_ID, Channel_ID);
        }
        #endregion

        #region 取消转换事件
        protected void changeResetBtn_Click(object sender, ImageClickEventArgs e)
        {
            YXShop.Common.alert.GoHref("Channel_Class_Manage.aspx?channelID="+this.ChannelID+"");
        }
        #endregion
    }
}