分类添加代码 - 王德田

分类添加代码

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

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;

namespace domain.UI.images.News
{
    public partial class TypeEdit : domain.BLL.AdminPage
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            this.BtDel.Attributes["onclick"] = "window.close()";
            if (!Page.IsPostBack)
            {
               //Power(this.U_Account, this.MIDS[Convert.ToInt32(domain.BLL.ModelList.系统设置)]);
                BindUpdate();
            }
        }

        public void BindUpdate()
        {
            string action = this.GetRequest("action");
            if (action == "upd")
            {
                string sql = string.Format("select * from [newssort] where column_id='{0}'", this.GetRequest("id"));
                DataTable dt = this.Db.GetTable(sql);
                if (dt != null)
                {
                    this.TbName.Text = Convert.ToString(dt.Rows[0]["column_name"]);
                    this.TbIntro.Text = Convert.ToString(dt.Rows[0]["column_intro"]);
                }
            }
        }
        protected void BtVerfly_Click(object sender, EventArgs e)
        {
            string action = this.GetRequest("action");
            string name = this.TbName.Text.Trim();
            string intro = this.TbIntro.Text.Trim();
            string parentid = this.GetRequest("parentid");
            parentid = parentid.Length < 1 ? ("0") : (parentid);
            string depth = this.GetRequest("depth");

            string message = "";
            string sql = "";
            switch (action)
            {
                case "add":
                    message = "添加";
                    int depthint = Convert.ToInt32(depth) + 1;
                    if (depthint >= 4)
                    {
                        this.ShowMessage("该类没有子类", "");
                        return;
                    }
                    sql = string.Format("insert into newssort([column_id],[column_name],[parent_id],[column_depth],[Column_Order],[column_intro]) select '{0}','{1}','{2}',{3},max(column_order)+1,'{4}' from newssort", System.Guid.NewGuid().ToString().Replace("-", "").ToUpper().Substring(1, 6), name, parentid, depthint, intro);
                    break;
                case "upd":
                    message = "修改";
                    sql = string.Format("update [newssort] set Column_Name='{0}',Column_Intro='{1}' where [column_ID]='{2}'", name, intro, this.GetRequest("id"));
                    break;
                default:
                    break;
            }
            if (this.Db.GetState(sql))
            {
                this.ShowMessage("成功" + message, "window.opener.location.reload()");
            }
            else
            {
                this.ShowMessage("操作失败请联系管理员！！！", "");
            }

}

        protected void BtDel_Click(object sender, EventArgs e)
        {
            // Response.Write(this.Script());
        }
    }
}

posted on 2009-06-03 15:07 王德田阅读(146) 评论(0) 编辑收藏举报