ctadd.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 System.Data.SqlClient;
using Shop.Web.UI;

namespace YXShop.Web.Admin.Article.InforChannel
{
    public partial class CTAdd : System.Web.UI.Page
    {
        BasePage bp = null;
        protected void Page_Load(object sender, EventArgs e)
        {            
            if (!IsPostBack)
            {
                string title = "频道模板添加";
                ChannelTBind();
                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    if (!PowerTree.PowerPass.isPass("009005004", PowerTree.PowerPanel.PowerType.update))
                    {
                        bp = new BasePage();
                        bp.PageError("对不起，你没有修改频道模板的权限！", "../index.aspx");
                    }
                    title = "频道模板修改";
                    BindData();
                }
                else 
                {
                    if (!PowerTree.PowerPass.isPass("009005002", PowerTree.PowerPanel.PowerType.add))
                    {
                        bp = new BasePage();
                        bp.PageError("对不起，你没有添加频道模板的权限！", "../index.aspx");
                    }
                }

                Title = title;
                ((Label)(Master.FindControl("lblName"))).Text = title;
            }
        }

        void BindData()
        {
            try
            {
                int id = 0;
                try
                {
                    id = int.Parse(Request.QueryString["id"]);
                }
                catch { ClientScript.RegisterClientScriptBlock(GetType(), "OK", "alert('参数不正确');", true); }
                string strSql = "Select * from YX_ChannelTemplates where YX_ID=" + id;
                SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, strSql, null);
                if (dr.Read())
                {
                    ddlChannelName.Text = dr["ChannelID"].ToString();
                    ddlType.Text = dr["type"].ToString();
                    txtContent.Text = YXShop.Common.WebUtility.HtmlToString(dr["Content"].ToString());
                }
                dr.Close();
            }
            catch { }
        }

        void ChannelTBind()
        {
            try
            {
                ddlChannelName.DataSource = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text,
                    "Select YX_Name,YX_ID from YX_InforChannel", null);
                ddlChannelName.DataTextField = "YX_Name";
                ddlChannelName.DataValueField = "YX_ID";
                ddlChannelName.DataBind();
            }
            catch { }
        }

        protected void submit_Click(object sender, EventArgs e)
        {
            string ChannelID = ddlChannelName.Text;
            string Type = ddlType.Text;
            string Content = YXShop.Common.WebUtility.StringToHtml1(txtContent.Text);

            if (!string.IsNullOrEmpty(Request.QueryString["id"]))
            {
                string sqlUpdate = string.Format("Update YX_ChannelTemplates set ChannelID='{0}',type='{1}',Content='{2}'  where YX_ID={3}",
                ChannelID, Type, Content, int.Parse(Request.QueryString["id"]));
                try
                {
                    if (SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, sqlUpdate, null) > 0)
                        ClientScript.RegisterStartupScript(GetType(), "OK", "alert('修改频道模板成功');location.href='ChannelTemplates.aspx?id=" + ChannelID + "';", true);
                    else ClientScript.RegisterStartupScript(GetType(), "OK", "alert('修改频道模板失败');", true);
                }
                catch { }
            }
            else { 

                string sqlInsert = string.Format("Insert YX_ChannelTemplates(ChannelID,type,Content) Values('{0}','{1}','{2}')",
                    ChannelID, Type, Content);
                if (SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, sqlInsert, null) > 0)
                    ClientScript.RegisterStartupScript(GetType(), "OK", "alert('添加频道模板成功');location.href='ChannelTemplates.aspx?id=" + ChannelID + "';", true);
                else ClientScript.RegisterStartupScript(GetType(), "OK", "alert('添加频道模板失败');", true);
            }
        }
    }

}