updatedepartment.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 OfficeAutomatization;
using System.Data.SqlClient;

public partial class UpdateDepartment : System.Web.UI.Page
{
	private int nDepartmentID = -1;

	private void Page_Load(object sender, System.EventArgs e)
	{		
		if (Request.Params["DepartmentID"] != null)
		{
			nDepartmentID = Int32.Parse(Request.Params["DepartmentID"].ToString());
		}

		if (!Page.IsPostBack)
		{
			///绑定控件的数据
			BindDepartmentData();

			///绑定所有的数据
			if (nDepartmentID > -1)
			{
				BindDepartmentData(nDepartmentID);
			}
		}
	}

	private void BindDepartmentData()
	{
		///定义获取数据的类
		Department depart = new Department();
		SqlDataReader recd = depart.GetDepartments();

		///设定控件的数据源
		DepartmentList.DataSource = recd;

		///设定控件的Text属性和Value属性
		DepartmentList.DataTextField = "Name";
		DepartmentList.DataValueField = "DepartmentID";

		///绑定控件的数据
		DepartmentList.DataBind();

		///关闭数据读取器和数据库的连接
		recd.Close();
	}

	private void BindDepartmentData(int nDepartmentID)
	{
		///定义获取数据的类
		Department depart = new Department();
		SqlDataReader recd = depart.GetSingleDepartment(nDepartmentID);

		///从获取的数据中读取数据
		if (recd.Read())
		{			
			Name.Text = recd["Name"].ToString();
			Desn.Text = recd["Desn"].ToString();
			Phone.Text = recd["Phone"].ToString();
			Remark.Text = recd["Remark"].ToString();

			///设置上级部门
			ASPNET2System.SetListBoxItem(DepartmentList, recd["ParentID"].ToString());
		}
		///关闭数据读取器和数据库的连接
		recd.Close();
	}

	protected void ReturnBtn_Click(object sender, System.EventArgs e)
	{
		///跳转到管理页面
		Response.Redirect("~/DesktopModules/Department/DepartmentManage.aspx");
	}

	protected void UpdateBtn_Click(object sender, System.EventArgs e)
	{
		if (Page.IsValid == true)
		{
			///定义类User
			Department depart = new Department();
			try
			{
				///添加新用户
				depart.UpdateDepartment(nDepartmentID,Name.Text,Desn.Text,
					Phone.Text.Trim(),
					DepartmentList.SelectedIndex > -1 ? Int32.Parse(DepartmentList.SelectedValue) : -1,
					Remark.Text);

				///显示操作结果信息
				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", " "));
			}
		}
	}
}