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 ASPNET2BBS;
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.SelectedNode.Value));
            }
        }

        ///设置按钮的可用性
        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())
		{
			Desn.Text = recc["Desn"].ToString();
			EnDesn.Text = recc["EnDesn"].ToString();
			Url.Text = recc["Url"].ToString();
			ASPNET2System.SetListBoxItem(IsDirList, recc["IsDir"].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(Desn.Text.Trim(),EnDesn.Text.Trim(),
					Url.Text.Trim(),
					Int32.Parse(CategoryView.SelectedNode.Value),
					CategoryView.SelectedNode.ChildNodes.Count + 1,
					Int32.Parse(IsDirList.SelectedValue));
				
				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),
					Desn.Text.Trim(),EnDesn.Text.Trim(),
					Url.Text.Trim(),
					Int32.Parse(IsDirList.SelectedValue));
                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.SelectedNode.Value));
        }
    }
}