smalltype_manage.aspx.cs

具有一般blog的相册、文章、作品等功能程序结构也比较清晰采用三层结构开发（利用了SQLHelper.cs（源码））采用了UrlReWrite技术后台采用FTB(FreeTextBox)编辑器

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using liuwei.FrameWork.DB;

namespace liuwei.admin
{
	/// <summary>
	/// add_smalltype 的摘要说明。
	/// </summary>
	public class smalltype_manage : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DropDownList ddBigType;
		protected System.Web.UI.WebControls.TextBox tbSmallType;
		protected System.Web.UI.WebControls.DropDownList ddSmallType;
		protected System.Web.UI.WebControls.Button btnModify;
		protected System.Web.UI.WebControls.Button btnRemove;
		protected System.Web.UI.WebControls.TextBox tbNewTypeName;
		protected System.Web.UI.WebControls.DropDownList ddBigType1;
		protected System.Web.UI.WebControls.Button Button1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面

			btnRemove.Attributes.Add("onclick","confirm('are you sure to remove it?')");

			if (!Page.IsPostBack)
			{
				DataTable dtBigType = DbProvider.Instance().GetBigTypeList();

				ddBigType.DataSource = dtBigType;
				ddBigType.DataTextField = "bigtypename";
				ddBigType.DataValueField = "bigtypeid";
				ddBigType.DataBind();

				ddBigType1.DataSource = dtBigType;
				ddBigType1.DataTextField = "bigtypename";
				ddBigType1.DataValueField = "bigtypeid";
				ddBigType1.DataBind();

				dtBigType.Clear();
				dtBigType.Dispose();

				DataTable dtSmallType = DbProvider.Instance().GetSmallTypeListAll();
				ddSmallType.DataSource = dtSmallType;
				ddSmallType.DataTextField = "smalltypename";
				ddSmallType.DataValueField = "smalltypeid";
				ddSmallType.DataBind();

				dtSmallType.Clear();
				dtSmallType.Dispose();
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.btnModify.Click += new System.EventHandler(this.btnModify_Click);
			this.btnRemove.Click += new System.EventHandler(this.btnRemove_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			DbProvider.Instance().AddSmallType(Convert.ToInt32(ddBigType.SelectedValue),tbSmallType.Text);
			Response.Write ("<script>alert('Add it OK');location.href('smalltype_manage.aspx');</script>");
			//Response.Redirect ("smalltype_manage.aspx");
		}

		private void btnRemove_Click(object sender, System.EventArgs e)
		{
			DbProvider.Instance().DelSmallType(Convert.ToInt32(ddSmallType.SelectedValue));
			Response.Write ("<script>alert('Remove it OK');location.href('smalltype_manage.aspx');</script>");
		}

		private void btnModify_Click(object sender, System.EventArgs e)
		{
			DbProvider.Instance().ModifySmallType(Convert.ToInt32(ddSmallType.SelectedValue),Convert.ToInt32(ddBigType1.SelectedValue),tbNewTypeName.Text);
			Response.Write ("<script>alert('Modify it OK');location.href('smalltype_manage.aspx');</script>");
		}

	}
}