channeltemplates.aspx.cs

易想商城系统

using System;
using System.Collections;
using System.Configuration;
using System.Data;
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 YXShop.DBUtility;
using Shop.Web.UI;

namespace YXShop.Web.Admin.Article.InforChannel
{
    public partial class ChannelTemplates : System.Web.UI.Page
    {
        BasePage bp = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            ((Label)(Master.FindControl("lblName"))).Text = "频道模板管理&nbsp;&nbsp;&nbsp;<a href='CTAdd.aspx'>[添加频道模板]</a>";
            if (!PowerTree.PowerPass.isPass("009005000", PowerTree.PowerPanel.PowerType.look))
            {
                bp = new BasePage();
                bp.PageError("对不起，你没有查看该页面的权限！", "../index.aspx");
            }
            if (!IsPostBack)
            {
                try
                {
                    if (string.IsNullOrEmpty(Request.QueryString["id"]))
                        Response.Redirect("ChannelManage.aspx");
                    string sqlSelectAll = "Select * from YX_ChannelTemplates where ChannelID=" + int.Parse(Request.QueryString["id"]);

                    rptChannelT.DataSource = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, sqlSelectAll, null);
                    rptChannelT.DataBind();
                }
                catch { }
            }
        }
        protected void Operate_OnClick(object sender, EventArgs e)
        {
            try
            {
                string type = ((LinkButton)sender).CommandName;
                string id = ((LinkButton)sender).CommandArgument;

                switch (type)
                {
                    case "Del":
                        if (!PowerTree.PowerPass.isPass("009004003", PowerTree.PowerPanel.PowerType.del))
                        {
                            bp = new BasePage();
                            bp.PageError("对不起，你没有删除频道模板的权限！", "../index.aspx");
                        }
                        else
                        {
                            if (Del(id))
                            {
                                ClientScript.RegisterStartupScript(GetType(), "OK", "alert('删除成功');location.href='" + Request.Url.AbsoluteUri + "'", true);
                            }
                            else { ClientScript.RegisterStartupScript(GetType(), "OK", "alert('删除成功');", true); }
                        }
                        break;
                    case "Use":
                        if (!PowerTree.PowerPass.isPass("009005006", PowerTree.PowerPanel.PowerType.other))
                        {
                            bp = new BasePage();
                            bp.PageError("对不起，你没有修改頻道模板使用状态的权限！", "../index.aspx");
                        }
                        else
                        {
                            if (Use(id))
                            {
                                ClientScript.RegisterStartupScript(GetType(), "OK", "alert('设置成功');location.href='" + Request.Url.AbsoluteUri + "'", true);
                            }
                            else { ClientScript.RegisterStartupScript(GetType(), "OK", "alert('设置失败');", true); }
                        }
                        break;
                }
            }
            catch { }
        }

        protected void BatchOperation_OnClick(object sender, EventArgs e)
        {
            try
            {
                YXShop.DBUtility.BatchOperation.Operation(valuelist, sender, "YX_ChannelTemplates");
                Response.Redirect(Request.Url.AbsoluteUri);
            }
            catch { }
        }

        protected string TypeName(string value)
        {
            switch (value)
            {
                case "1":
                    return "首页";
                case "2": return "列表页";
                case "3": return "详细页";
                case "4": return "单页";
            }
            return "";
        }

        bool Del(string id)
        {
            try
            {
                string strSql = "Delete YX_ChannelTemplates where YX_ID=" + int.Parse(id);
                return SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, strSql, null) > 0 ? true : false;
            }
            catch { return false; }
        }
        bool Use(string list) {
            try
            {
                string[] value = list.Split(',');
                string strSql = string.Format("Update YX_ChannelTemplates set IsUse=0 where ChannelID={0} and type={1};" +
                "Update YX_ChannelTemplates set IsUse=1 where ChannelID={0} and type={1} and YX_ID={2}",
                int.Parse(Request.QueryString["id"]), value[1], int.Parse(value[0]));
                return SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, strSql, null) > 0 ? true : false;
            }
            catch { return false; }
        }
    }
}