channelmanage.aspx.cs

易想商城系统

#region =====using=====

using System;
using System.Data;
using System.Web.UI.WebControls;
using YXShop.DBUtility;
using System.IO;
using Shop.Web.UI;

#endregion
namespace YXShop.Web.Admin.Article.InforChannel
{
    public partial class ChannelManage : System.Web.UI.Page
    {
        #region =====页面加载=====
        BasePage bp = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!PowerTree.PowerPass.isPass("009004000", PowerTree.PowerPanel.PowerType.look)) 
            {
                bp = new BasePage();
                bp.PageError("对不起，你没有查看该页面的权限！","../index.aspx");
            }
            ((Label)(Master.FindControl("lblName"))).Text = "频道管理&nbsp;&nbsp;<a href='ChannelAnd.aspx'>[添加频道]</a>";
            if (!IsPostBack)
            {
                fillContent();
            }

        }

        #endregion

        #region 填充数据
        protected void fillContent()
        {
            string strSql = "Select * from YX_InforChannel";
            try
            {
                rptChannel.DataSource = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, strSql, null);
                rptChannel.DataBind();
            }
            catch { }
        }
        #endregion

        #region =====批量操作=====

        protected void BatchOperation_OnClick(object sender, EventArgs e)
        {
            #region 文件夹删除
            try
            {
                string type = ((Button)sender).CommandName;
                if (type == "DelAll")
                {
                    string[] idList = valuelist.Value.Split(',');
                    foreach (string id in idList)
                    {
                        if (id == "") break;
                        string strSql = "Select YX_DirName from YX_InforChannel where YX_ID=" + id;
                        string path = Server.MapPath("~/" + SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, strSql, null).ToString());
                        Directory.Delete(path, true);
                        Del(id);
                    }
                }
            }
            catch { }

            #endregion
            YXShop.DBUtility.BatchOperation.Operation(valuelist, sender, "YX_InforChannel");                     
            Response.Redirect(Request.Url.AbsoluteUri);
        }

        #endregion
        #region =====操作=====

        protected void Operate_OnClick(object sender, EventArgs e)
        {
            string type = ((LinkButton)sender).CommandName;
            string id = ((LinkButton)sender).CommandArgument;
            try
            {
                switch (type)
                {
                    case "Del":
                        if (!PowerTree.PowerPass.isPass("009004003", PowerTree.PowerPanel.PowerType.del))
                        {
                            bp = new BasePage();
                            bp.PageError("对不起，你没有删除该项的权限！", "../index.aspx");
                        }
                        else
                        {
                            string[] value = id.Split(',');
                            if (Del(value[0]))
                            {
                                #region 文件夹删除

                                string path = Server.MapPath("~/" + value[1]);
                                Directory.Delete(path, true);

                                #endregion
                                ClientScript.RegisterStartupScript(GetType(), "OK", "alert('删除成功');location.href='ChannelManage.aspx'", true);
                                this.fillContent();
                            }
                            else { ClientScript.RegisterStartupScript(GetType(), "OK", "alert('删除失败');", true); }
                        }
                        break;
                    case "Use":
                        if (!PowerTree.PowerPass.isPass("009004006", PowerTree.PowerPanel.PowerType.other))
                        {
                            bp = new BasePage();
                            bp.PageError("对不起，你没有修改使用状态的权限！", "../index.aspx");
                        }
                        else
                        {
                            if (Use(id))
                            {
                                ClientScript.RegisterStartupScript(GetType(), "OK", "alert('设置成功');location.href='ChannelManage.aspx'", true);
                                this.fillContent();
                            }
                            else { ClientScript.RegisterStartupScript(GetType(), "OK", "alert('设置失败');", true); }
                        }
                        break;
                }
            }
            catch  (Exception ex)
            {
                ClientScript.RegisterStartupScript(GetType(), "OK", "alert('"+ex.ToString()+"');", true);
            }

        }

        bool Del(string id)
        {
            
            string strSql = "Delete YX_InforChannel where YX_ID=" + int.Parse(id);
            //string strSql2 = "Delete Class where Channel_ID=" + int.Parse(id);
            string strSql3 = "Delete Yixiang_Article where channelID=" + int.Parse(id);
            //try
            //{
            //    SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, strSql2, null);
            //}
            //catch { }
            try
            {
                SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, strSql3, null);
            }
            catch { }
            try
            {
                return SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, strSql, null) > 0 ? true : false;
            }
            catch { return false; }
        }

        bool Use(string id)
        {
            string strSql = string.Format("Update {0} set IsUse=(Select case IsUse when 1 then 0 when 0 then 1 end from {0} where YX_ID={1}) where YX_ID={1}",
                "YX_InforChannel",int.Parse(id));
            try
            {
                return SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, strSql, null) > 0 ? true : false;
            }
            catch { return false; }
        }

        #endregion
    }
}