categorymanage.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 BookShop;
using System.Data.SqlClient;

public partial class CategoryManage : System.Web.UI.Page
{
	protected void Page_Load(object sender, EventArgs e)
	{
		if (!Page.IsPostBack)
		{
			BindCategoryData();
			///显示选择结点的文本
			if (CategoryView.SelectedNode != null)
			{
				BindCategoryData(Int32.Parse(CategoryView.SelectedValue));
			}
		}
		///设置按钮的可用性
		AddBtn.Enabled = UpBtn.Enabled = DownBtn.Enabled = UpdateBtn.Enabled = DeleteBtn.Enabled
			= CategoryView.SelectedNode == null ? false : true;

		///添加删除确认对话框
		DeleteBtn.Attributes.Add("onclick", "return confirm('" + ASPNET2System.OPERATIONDELETEMESSAGE + "');");
	}

    private void BindCategoryData()
    {
        Category category = new Category();
        category.BindCategoryTreeView(CategoryView, true, "-1");
    }

	private void BindCategoryData(int nCategoryID)
	{		
		Category category = new Category();
		SqlDataReader recc = category.GetSingleCategory(nCategoryID);
		if (recc.Read())
		{
			Category.Text = recc["Desn"].ToString();
			Remark.Text = recc["Remark"].ToString();
		}
		recc.Close();
	}

    protected void AddBtn_Click(object sender, EventArgs e)
    {
        ///如果页面输入内容合法
        if (Page.IsValid == true)
        {
            if (CategoryView.SelectedNode == null)
            {
                Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
                return;
            }

            ///定义类
            Category category = new Category();
            try
            {
                ///添加新数据
                category.AddCategory(Category.Text.Trim(),
					Int32.Parse(CategoryView.SelectedNode.Value),
					CategoryView.SelectedNode.ChildNodes.Count + 1,
					Remark.Text);
                BindCategoryData();

                ///显示操作结果信息
                Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONADDSUCCESSMESSAGE + "')</script>");
            }
            catch (Exception ex)
            {
                ///显示添加操作中的失败、错误信息
                Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
                    + ASPNET2System.RedirectErrorUrl(Request.RawUrl)
                    + "&ErrorMessage=" + ex.Message.Replace("\n", " "));
            }
        }
    }

    protected void UpDownBtn_Click(object sender, EventArgs e)
    {
        string sCommandName = ((Button)sender).CommandName;

        ///验证是否选择修改的数据
        if (CategoryView.SelectedNode == null)
        {
            Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
            return;
        }

        ///定义类
        Category category = new Category();
        try
        {
            ///添加新数据
            category.UpdateCategoryOrder(Int32.Parse(CategoryView.SelectedNode.Value),sCommandName);
            BindCategoryData();

            ///显示操作结果信息
            Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONUPDATESUCCESSMESSAGE + "')</script>");
        }
        catch (Exception ex)
        {
            ///显示修改操作中的失败、错误信息
            Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
                + ASPNET2System.RedirectErrorUrl(Request.RawUrl)
                + "&ErrorMessage=" + ex.Message.Replace("\n", " "));
        }
    }

    protected void UpdateBtn_Click(object sender, EventArgs e)
    {
         ///如果页面输入内容合法
        if (Page.IsValid == true)
        {
            ///验证是否选择修改的数据
            if (CategoryView.SelectedNode == null)
            {
                Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
                return;
            }

            ///定义类
            Category category = new Category();
            try
            {
                ///添加新数据
                category.UpdateCategory(Int32.Parse(CategoryView.SelectedNode.Value),
					Category.Text.Trim(),
					Remark.Text);
                BindCategoryData();
               
                ///显示操作结果信息
                Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONUPDATESUCCESSMESSAGE + "')</script>");
            }
            catch (Exception ex)
            {
                ///显示修改操作中的失败、错误信息
                Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
                    + ASPNET2System.RedirectErrorUrl(Request.RawUrl)
                    + "&ErrorMessage=" + ex.Message.Replace("\n", " "));
            }
        }
    }

    protected void DeleteBtn_Click(object sender, EventArgs e)
    {
        ///验证是否选择修改的数据
        if (CategoryView.SelectedNode == null)
        {
            Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
            return;
        }

        ///验证选择结点的孩子结点是否为空
        if (CategoryView.SelectedNode.ChildNodes.Count > 0)
        {
            Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONCHILADRENDATANOTNULL + "')</script>");
            return;
        }

        ///定义类
        Category category = new Category();
        try
        {
            ///添加新数据
            category.DeleteCategory(Int32.Parse(CategoryView.SelectedNode.Value));
            BindCategoryData();

            ///显示操作结果信息
            Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONDELETESUCCESSMESSAGE + "')</script>");
        }
        catch (Exception ex)
        {
            ///显示修改操作中的失败、错误信息
            Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
                + ASPNET2System.RedirectErrorUrl(Request.RawUrl)
                + "&ErrorMessage=" + ex.Message.Replace("\n", " "));
        }
    }

    protected void CategoryView_SelectedNodeChanged(object sender, EventArgs e)
    {
        ///设置按钮的可用性
        AddBtn.Enabled = UpBtn.Enabled = DownBtn.Enabled = UpdateBtn.Enabled = DeleteBtn.Enabled
            = CategoryView.SelectedNode == null ? false : true;
        
        ///显示选择结点的文本
        if (CategoryView.SelectedNode != null)
        {
            BindCategoryData(Int32.Parse(CategoryView.SelectedValue));
        }
    }
}