employeemanage.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 EmployeeManage : System.Web.UI.Page
{
	public int nEmployeeID = -1;
	private static string EmployeeName = "";

	private void Page_Load(object sender, System.EventArgs e)
	{
		if (Request.Params["EmployeeID"] != null)
		{
			nEmployeeID = Int32.Parse(Request.Params["EmployeeID"].ToString());
		}
		if (!Page.IsPostBack)
		{
			///绑定控件的数据
			BindEmployeeData();

			///设置员工的选择项
			ASPNET2System.SetListBoxItem(EmployeeList, nEmployeeID.ToString());

			if (nEmployeeID > -1)
			{   ///显示操作前的信息
				BindEmployeeData(nEmployeeID);
				CurrentEmployeeName.Text = EmployeeName;
			}
			else
			{
				///显示当前选择项的信息				
				if (EmployeeList.SelectedIndex > -1)
				{
					///显示信息
					BindEmployeeData(Int32.Parse(EmployeeList.SelectedValue));
					CurrentEmployeeName.Text = EmployeeList.SelectedItem.Text;
				}
				else
				{
					if (EmployeeList.Items.Count > 0)
					{	///显示第一项的信息
						BindEmployeeData(Int32.Parse(EmployeeList.Items[0].Value));
						CurrentEmployeeName.Text = EmployeeList.Items[0].Text;
						EmployeeList.SelectedIndex = 0;
					}
				}
			}
		}

		///设置按钮的可用性
		UpdateBtn.Enabled = DeleteBtn.Enabled = (EmployeeList.Items.Count <= 0) ? false : true;
		topUpdateBtn.Enabled = UpdateBtn.Enabled;
		topDeleteBtn.Enabled = DeleteBtn.Enabled;

		///添加删除确认对话框
		DeleteBtn.Attributes.Add("onclick", "return confirm('" + ASPNET2System.OPERATIONDELETEMESSAGE + "');");
		topDeleteBtn.Attributes.Add("onclick", "return confirm('" + ASPNET2System.OPERATIONDELETEMESSAGE + "');");
	}

	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 BindEmployeeData(int nEmployeeID)
	{
		///绑定所属部门的信息
		BindDepartmentData();

		///定义获取数据的类
		Employee employ = new Employee();
		SqlDataReader rece = employ.GetSingleEmployee(nEmployeeID);

		///从获取的数据中读取数据
		if (rece.Read())
		{
			///设置列表控件的选择值
			ASPNET2System.SetListBoxItem(SexList, rece["Sex"].ToString());
			ASPNET2System.SetListBoxItem(Maritallist, rece["Marital"].ToString());
			ASPNET2System.SetListBoxItem(StateList, rece["State"].ToString());
			ASPNET2System.SetListBoxItem(DepartmentList, rece["DepartmentID"].ToString());

			EmployName.Text = rece["EmployName"].ToString();
			EmployNo.Text = rece["EmployNo"].ToString();
			Nationality.Text = rece["Nationality"].ToString();
			Birthday.Text = (Convert.ToDateTime(rece["Birthday"].ToString())).ToShortDateString();
			Political.Text = rece["Political"].ToString();
			MisCulture.Text = rece["Culture"].ToString();
			FamilyPlace.Text = rece["FamilyPlace"].ToString();
			IdentityCard.Text = rece["IdentityCard"].ToString();
			Phone.Text = rece["Phone"].ToString();
			Mobile.Text = rece["Mobile"].ToString();
			HireDate.Text = (Convert.ToDateTime(rece["HireDate"].ToString())).ToShortDateString();
			Position.Text = rece["Position"].ToString();
			BankName.Text = rece["BankName"].ToString();
			AccountNo.Text = rece["AccountNo"].ToString();
			PubName.Text = rece["PubName"].ToString();
			Remark.Text = rece["Remark"].ToString();
		}
		///关闭数据读取器和数据库的连接
		rece.Close();
	}

	protected void AddBtn_Click(object sender, System.EventArgs e)
	{
		///跳转到添加页面
		Response.Redirect("~/DesktopModules/Employee/AddEmployee.aspx?EmployeeID="
			+ ((EmployeeList.SelectedIndex > -1) ? EmployeeList.SelectedValue : "-1"));
	}

	protected void DeleteBtn_Click(object sender, System.EventArgs e)
	{
		if (EmployeeList.SelectedIndex > -1)
		{
			///定义类
			Employee employ = new Employee();

			try
			{
				///删除操作
				employ.DeleteEmployee(Int32.Parse(EmployeeList.SelectedValue));

				///重新显示员工的信息
				BindEmployeeData();
				if (EmployeeList.Items.Count > 0)
				{
					BindEmployeeData(Int32.Parse(EmployeeList.Items[0].Value));
					EmployeeList.SelectedIndex = 0;
				}

				///显示操作结果信息
				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", " "));
			}
		}
		else
		{
			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
		}
	}

	protected void UpdateBtn_Click(object sender, System.EventArgs e)
	{
		if (Page.IsValid == true)
		{
			if (EmployeeList.SelectedIndex > -1)
			{
				///定义类
				Employee employ = new Employee();

				try
				{
					int nCurrentEmployeeID = Int32.Parse(EmployeeList.SelectedValue);
					int nCurrentIndex = EmployeeList.SelectedIndex;
					///修改操作
					employ.UpdateEmployee(Int32.Parse(EmployeeList.SelectedValue),
						EmployName.Text.Trim(), EmployNo.Text.Trim(),
						Int32.Parse(SexList.SelectedValue), Nationality.Text.Trim(),
						Convert.ToDateTime(Birthday.Text.Trim()), Political.Text,
						MisCulture.Text.Trim(), Int32.Parse(Maritallist.SelectedValue),
						FamilyPlace.Text, IdentityCard.Text.Trim(), Phone.Text.Trim(),
						Mobile.Text, Convert.ToDateTime(HireDate.Text.Trim()), Position.Text,
						Int32.Parse(StateList.SelectedValue), BankName.Text,
						AccountNo.Text, PubName.Text, Int32.Parse(DepartmentList.SelectedValue),
						Remark.Text);

					///重新显示员工的信息
					BindEmployeeData();
					BindEmployeeData(nCurrentEmployeeID);
					EmployeeList.SelectedIndex = nCurrentIndex;

					///显示操作结果信息
					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", " "));
				}
			}
			else
			{
				///显示操作结果信息
				Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
			}
		}
	}

	protected void EmployeeList_SelectedIndexChanged(object sender, System.EventArgs e)
	{
		if (EmployeeList.SelectedIndex > -1)
		{
			///显示员工的信息
			BindEmployeeData(Int32.Parse(EmployeeList.SelectedValue));
			EmployeeName = EmployeeList.SelectedItem.Text;
			CurrentEmployeeName.Text = EmployeeList.SelectedItem.Text;
			nEmployeeID = Int32.Parse(EmployeeList.SelectedValue);

			///设置按钮的可用性
			UpdateBtn.Enabled = topUpdateBtn.Enabled = DeleteBtn.Enabled = topDeleteBtn.Enabled = true;
		}
		else
		{
			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
		}

	}

}