updateproject.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 UpdateProject : System.Web.UI.Page
{
	int nProjectID = -1;
	protected void Page_Load(object sender, EventArgs e)
	{
		if (Request.Params["ProjectID"] != null)
		{
			nProjectID = Int32.Parse(Request.Params["ProjectID"].ToString());
		}

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

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

	private void BindEmployeeData()
	{
		///定义获取数据的类
		Employee employee = new Employee();
		SqlDataReader recu = employee.GetEmployees();

		///设定控件的数据源
		EmployeeList.DataSource = recu;

		///设定控件的Text属性和Value属性
		EmployeeList.DataTextField = "EmployName";
		EmployeeList.DataValueField = "EmployeeID";

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

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

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

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

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

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

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

	private void BindProjectData(int nProjectID)
	{
		///定义获取数据的类
		Project project = new Project();
		SqlDataReader recp = project.GetSingleProject(nProjectID);

		///从获取的数据中读取数据
		if (recp.Read())
		{
			Name.Text = recp["DepartName"].ToString();
			Desn.Text = recp["DepartDesn"].ToString();
			CreateDate.Text = DateTime.Parse(recp["CreateDate"].ToString()).ToShortDateString();
			StartDate.Text = DateTime.Parse(recp["StartDate"].ToString()).ToShortDateString();
			EndDate.Text = DateTime.Parse(recp["EndDate"].ToString()).ToShortDateString();			

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

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

	protected void UpdateBtn_Click(object sender, System.EventArgs e)
	{
		if (Page.IsValid == true)
		{
			///定义类User
			///定义类
			Project project = new Project();
			try
			{
				///添加操作
				project.UpdateProject(nProjectID,Name.Text.Trim(),Desn.Text,
					Int32.Parse(EmployeeList.SelectedValue),					
					DateTime.Parse(StartDate.Text.Trim()),
					DateTime.Parse(EndDate.Text.Trim()),
					Int32.Parse(DepartmentList.SelectedValue),
					Int32.Parse(StateList.SelectedValue));

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