modify.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>
	/// modify 的摘要说明。
	/// </summary>
	public class modify : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DropDownList ddBigType;
		protected System.Web.UI.WebControls.DropDownList ddSmallType;
		protected System.Web.UI.WebControls.TextBox tbTitle;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox tbIntro;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.CheckBox chkAllowShow;
		protected System.Web.UI.WebControls.CheckBox chkAllowComment;
		protected System.Web.UI.WebControls.Button Button1;
		protected FreeTextBoxControls.FreeTextBox ftbContent;
		private int postID;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面

			postID=Convert.ToInt32(Request.QueryString["postID"]);

			if (!Page.IsPostBack)
			{
				DataTable dt = DbProvider.Instance().GetModifyContent(postID);
				
				DataTable dtBigType = DbProvider.Instance().GetBigTypeList();
				ddBigType.DataSource = dtBigType;
				ddBigType.DataTextField = "bigtypename";
				ddBigType.DataValueField = "bigtypeid";
				ddBigType.SelectedValue = dt.Rows[0]["bigtypeid"].ToString();
				ddBigType.DataBind();

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

				DataTable dtSmallType = DbProvider.Instance().GetSmallTypeList(Convert.ToInt32(ddBigType.SelectedValue));
				ddSmallType.DataSource = dtSmallType;
				ddSmallType.DataTextField = "smalltypename";
				ddSmallType.DataValueField = "smalltypeid";
				ddSmallType.SelectedValue = dt.Rows[0]["smalltypeid"].ToString();
				ddSmallType.DataBind();

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

				tbTitle.Text = dt.Rows[0]["title"].ToString();
				tbIntro.Text = dt.Rows[0]["intro"].ToString();
				ftbContent.Text = dt.Rows[0]["content"].ToString();
				chkAllowShow.Checked = Convert.ToBoolean(dt.Rows[0]["AllowShow"]);
				chkAllowComment.Checked = Convert.ToBoolean(dt.Rows[0]["AllowComment"]);

				dt.Clear();
				dt.Dispose();
			}
		}

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

		}
		#endregion

		private void ddBigType_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			DataTable dtSmallType = DbProvider.Instance().GetSmallTypeList(Convert.ToInt32(ddBigType.SelectedValue));
			ddSmallType.DataSource = dtSmallType;
			ddSmallType.DataTextField = "smalltypename";
			ddSmallType.DataValueField = "smalltypeid";
			ddSmallType.DataBind();

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

		private void Button1_Click(object sender, System.EventArgs e)
		{
			DbProvider.Instance().ModifyContent(postID,Convert.ToInt32(ddBigType.SelectedValue),Convert.ToInt32(ddSmallType.SelectedValue),tbTitle.Text,tbIntro.Text,ftbContent.Text,chkAllowShow.Checked,chkAllowComment.Checked);
			Response.Redirect ("list.aspx");
		}
	}
}