checklvreq.aspx.cs

该管理系统的主要功能是管理员工资料、管理员工考勤、计算员工薪资和业绩评定等。大部分涉及对敏感数据修改的工作都仅由人事部完成

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 DBUtils;

namespace BlueHill.CheckLeave
{
	/// <summary>
	/// CheckLvReq 的摘要说明。
	/// </summary>
	public class CheckLvReq : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtDenyReason;
		protected System.Web.UI.WebControls.Button btnOK;
		protected System.Web.UI.WebControls.Button btnCancel;
		protected System.Web.UI.WebControls.Panel pnlReason;
		protected System.Web.UI.WebControls.TextBox txtReason;
		protected System.Web.UI.WebControls.Label lblMsg;
		protected System.Web.UI.WebControls.Panel pnlDeny;
		protected System.Web.UI.WebControls.Label lblReason;
		protected System.Web.UI.WebControls.Label lblDenyReason;
		protected System.Web.UI.WebControls.Label lblLeaveID;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.DataGrid grdResult;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			
			if(!this.Page.IsPostBack)
			{
				//获取员工编号信息和员工其他信息
				int iEmpID = Convert.ToInt32(Session["EmployeeID"]);
				Employee employee = new Employee();

				//查询员工信息,并返回查询是否成功
				int iSuccess = Employee.GetEmployeeInfo(iEmpID,ref employee);

				if(iSuccess == (int)DBResult.Success)
				{
					//数据库操作成功

			　　    //判断当前登录者是否有权限查看此页
					if(employee.IsManager )
					{
						//登录者是经理，可以查看此网

						//初使化页面
						this.lblMsg.Visible = false;
						this.pnlDeny.Visible = false;
						this.pnlReason.Visible =false;
						this.grdResult.Visible = true;
						this.RefreshPage();
					}
					else
					{
						//登录者是一般员工，不可查看此网页
						this.lblMsg.Text = "对不起，该网页属经理专用，请退出！";
						this.lblMsg.Visible = true;
						this.pnlDeny.Visible = false;
						this.pnlReason.Visible =false;
						this.grdResult.Visible = false;
					}
				}
				else
				{
					//数据库操作失败
					this.lblMsg.Text = "对不起，数据库操作失败，请重试";
					this.lblMsg.Visible = true;
					this.pnlDeny.Visible = false;
					this.pnlReason.Visible =false;
					this.grdResult.Visible = false;
				}
			}
		}



		/// <summary>
		/// 在数据库中查找登录者要审核的所有请假记录,并以 DataGrid 的形式来显示返回结果
		/// </summary>
		private void RefreshPage()
		{
			//该过程调用 CheckLvReq.QuerySubmittedReq(iApproverID, dsResult) 函数
			
			//获取经理的编号
			int iApproverID = Convert.ToInt32(Session["EmployeeID"]);

			//创建 DataSet 对象，用来保存查询结果
			DataSet dsResult = new DataSet();
			int iSuccess = DBUtils.CheckLvReq.QuerySubmittedReq(iApproverID,ref dsResult);
			if(iSuccess == (int)DBResult.Success)
			{
				//数据库查询成功

				//将查询到的数据集结果绑定页面
				this.grdResult.DataSource = dsResult.Tables[0].DefaultView;
				this.grdResult.DataBind();
			}
			else
			{
				//数据库查询失败
				this.lblMsg.Visible = true;
				this.lblMsg.Text = "数据库查询失败";
			}
		}

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

		}
		#endregion

		private void grdResult_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//获取要执行的操作名称 Select表示"详细情况"\ Edit表示"批准"\ Delete表示"否决"
			string strCommandType = e.CommandName;
			
			if(strCommandType == "Select")
			{
				//单击"详细情况"时响应
				
				//显示请假事由界面
				this.pnlReason.Visible = true; 
				this.lblReason.Visible = true;
				this.txtReason.Visible = true;
				this.pnlDeny.Visible = false;

				//获取请假事由
				this.txtReason.Text = e.Item.Cells[1].Text.Trim();
			}
			else
			{
				if(strCommandType == "Edit")
				{
					//单击"批准"时响应

					//获取申请请假者的编号
					int iLeaveID = Convert.ToInt32( e.Item.Cells[0].Text.Trim());

					//修改请假记录的状态,并返回操作是否执行成功
					int iSuccess = DBUtils.CheckLvReq.ChangeLeaveStatus(iLeaveID,"已批准","");
					if(iSuccess ==(int)DBResult.Failed)
					{
						//批准操作失败
						this.lblMsg.Text = "数据库操作失败,请重试";
						this.lblMsg.Visible = true;
					}
					else
					{
						//批准操作成功
						this.pnlDeny.Visible = false;
						this.pnlReason.Visible = false;
						this.lblMsg.Visible = false;

						//通知当前登录者操作成功
						string strEmpName = e.Item.Cells[2].Text.Trim();
						Response.Write("<script>alert('您已经成功批准了 "+ strEmpName +" 的请假申请')</script>");
						//重新绑定要审核的所有请假记录
						this.RefreshPage();
					}
				}
				else
				{
					//单击"否决"时响应
					
					//显示请假事由界面及否决理由界面
					this.pnlReason.Visible = true;
					this.pnlDeny.Visible = true;
					this.lblDenyReason.Visible = true;
					this.txtDenyReason.Visible = true;
					this.btnOK.Visible = true;
					this.btnCancel.Visible = true;
					this.lblReason.Visible = true;
					this.txtReason.Visible = true;

					//获取请假申请者的编号
					this.lblLeaveID.Text = e.Item.Cells[0].Text.Trim();
					this.lblLeaveID.Visible = false;

					//获取请假事由
					this.txtReason.Text = e.Item.Cells[1].Text.Trim();
				}
			}
		}

		private void grdResult_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			//当用户选中 DataGrid 中的其他记录时，该方法将隐藏请假详细信息区域和否决理由区域
		}

		
		//当用户单击“确定”按钮时
		private void btnOK_Click(object sender, System.EventArgs e)
		{
			//在数据库中更改请假记录的状态并保存否决理由
			
			//获取申请请假者的编号
			int iLeaveID = Convert.ToInt32(this.lblLeaveID.Text.Trim());

			//获取否决理由
			string strDenyReason = this.txtDenyReason.Text.Trim();

			//修改请假记录的状态,并返回操作是否执行成功
			int iSuccess = DBUtils.CheckLvReq.ChangeLeaveStatus(iLeaveID, "已否决", strDenyReason) ;
			
			if(iSuccess == (int)DBResult.Success)
			{
				//否决操作成功
				this.pnlDeny.Visible = false;
				this.pnlReason.Visible = false;
				this.lblMsg.Visible = false;

				//通知当前登录者操作成功	
				Response.Write("<script>alert('您已经成功否决了一个请假申请')</script>");
				//重新绑定要审核的所有请假记录
				this.RefreshPage();
			}
			else
			{
				//否决操作失败
				this.lblMsg.Text = "数据库操作失败,请重试";
				this.lblMsg.Visible = true;
			}
		}

		
		//用户单击“取消”按钮时
		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			//该方法将隐藏否决理由区域
			this.txtDenyReason.Text = "";
			this.pnlDeny.Visible = false;
		}
	}
}