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

public partial class Admin_EmployeeManage : System.Web.UI.Page
{
	protected void Page_Load(object sender,EventArgs e)
	{	///判断用户是否登录
		UserSessionValue usv = (UserSessionValue)SessionKeyValue.GetUserSession(Session);
		if(usv == null)
		{   ///返回到上一个页面
			Response.Write("<script>history.back()</script>");
			///跳转到登录页面
			Server.Transfer("~/Common/UserLogin.aspx");
			return;
		}   ///显示员工和员工的信息
		if(!Page.IsPostBack)
		{
			BindDepartmentData();
			if(ddlDepartment.Items.Count > 0)
			{   ///显示员工的信息
				ddlDepartment.SelectedIndex = 0;
				BindEmployeeData(Int32.Parse(ddlDepartment.SelectedValue));
			}
		}
	}

	private void BindDepartmentData()
	{   ///获取数据
		Department department = new Department();
		SqlDataReader dr = department.GetDepartments();
		///绑定控件的数据，并显示数据
		ddlDepartment.DataSource = dr;
		ddlDepartment.DataTextField = "Name";
		ddlDepartment.DataValueField = "ID";
		ddlDepartment.DataBind();
		dr.Close();
	}

	private void BindEmployeeData(int departmentID)
	{   ///获取数据
		Employee employee = new Employee();
		SqlDataReader dr = employee.GetEmployeeByDepartment(departmentID);
		///绑定控件的数据，并显示数据
		gvEmployee.DataSource = dr;
		gvEmployee.DataBind();
		dr.Close();
	}

	protected string FormatSex(bool sex)
	{
		return (sex ? "男" : "女");
	}

	protected void btnAdd_Click(object sender,EventArgs e)
	{   ///跳转到添加页面
		Server.Transfer("~/Admin/AddEmployee.aspx");
	}

	protected void gvEmployee_RowDataBound(object sender,GridViewRowEventArgs e)
	{   ///添加删除按钮的确认对话框
		ImageButton deleteBtn = (ImageButton)e.Row.FindControl("DeleteBtn");
		if(deleteBtn != null)
		{
			deleteBtn.Attributes.Add("onclick","return confirm('你确定要删除所选择的员工吗?');");
		}
	}
	protected void gvEmployee_RowCommand(object sender,GridViewCommandEventArgs e)
	{
		if(e.CommandName == "update")
		{   ///跳转到修改页面
			Server.Transfer("~/Admin/UpdateEmployee.aspx?EmployeeID="
				+ e.CommandArgument.ToString());
		}
		if(e.CommandName == "delete")
		{   ///执行删除操作
			Employee employee = new Employee();
			employee.DeleteEmployee(Int32.Parse(e.CommandArgument.ToString()));
			///重新绑定数据
			BindEmployeeData(Int32.Parse(ddlDepartment.SelectedValue));
		}
	}
	protected void gvEmployee_RowDeleting(object sender,GridViewDeleteEventArgs e)
	{
		///
	}
	protected void ddlDepartment_SelectedIndexChanged(object sender,EventArgs e)
	{   ///重新绑定控件的数据
		BindEmployeeData(Int32.Parse(ddlDepartment.SelectedValue));
	}
}