apply_view.aspx.cs

人力资源管理系统 读者须安装好IIS和Microsoft Visual Stutio.NET相关开发环境

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 HRAdmin.BLL ;
using HRAdmin.COMMON ;

namespace HRAdmin.USL
{
	/// <summary>
	/// Apply_View 的摘要说明。
	/// </summary>
	public class Apply_View : System.Web.UI.Page
	{
		#region 控件
		protected System.Web.UI.WebControls.Button bSearch;
		protected System.Web.UI.WebControls.Button bClear;
		protected System.Web.UI.WebControls.DataGrid dg;
		protected System.Web.UI.WebControls.Button bModify;
		protected System.Web.UI.WebControls.Button bDelete;
		protected System.Web.UI.WebControls.TextBox tb_StartDate;
		protected System.Web.UI.WebControls.TextBox tb_EndDate;
		protected System.Web.UI.HtmlControls.HtmlInputHidden APPLYID;
		protected System.Web.UI.HtmlControls.HtmlImage iTo;
		protected System.Web.UI.HtmlControls.HtmlImage Img1;
		protected System.Web.UI.WebControls.DropDownList ddl_Type;
		protected System.Web.UI.WebControls.DropDownList STATUS;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Button b_Add;
		private PersonnelInfo pi = null ;
		#endregion
	
		#region Page_Load
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			pi = HRAdminGlobals.LoginUsr ;
			if(pi == null)
			{
				//页面重定向到登录页面
				CommHandler.ReDirURL(Page) ;
			}

			if(!IsPostBack)
			{
				//初始化下拉框
				InitDDL() ;
				//初始化界面
				InitData() ;
				CommHandler.AddConfirm(this.bDelete,"您确定删除该记录吗？") ;				
			}
		}

		/// <summary>
		/// 界面初始化
		/// </summary>
		private void InitData()
		{
			//日期默认为当天
			this.tb_EndDate.Text = CommHandler.Today() ;
			this.tb_StartDate.Text = CommHandler.Today() ;

			//表格
			DataTable dt = new DataTable() ;
			this.dg.DataSource = dt ;
			this.dg.DataBind() ;
		}
		
		/// <summary>
		/// 初始化下拉框
		/// </summary>
		private void InitDDL()
		{
			//申请类型
			CommHandler.DDL_Init(this.ddl_Type,"APPLYTYPE",false) ;
			//申请状态
			CommHandler.DDL_Init(this.STATUS,"APPLYSTATUS",false) ;
		}
		#endregion

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.bSearch.Click += new System.EventHandler(this.bSearch_Click);
			this.bClear.Click += new System.EventHandler(this.bClear_Click);
			this.dg.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dg_ItemCommand);
			this.dg.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dg_ItemDataBound);
			this.b_Add.Click += new System.EventHandler(this.b_Add_Click);
			this.bModify.Click += new System.EventHandler(this.bModify_Click);
			this.bDelete.Click += new System.EventHandler(this.bDelete_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		#region 查询
		private void bSearch_Click(object sender, System.EventArgs e)
		{
			//查询
			Search() ;		
		}

		private void Search()
		{
			//查询条件 申请类型、开始时间、结束时间
			string type = this.ddl_Type.SelectedValue ;
			DateTime start = CommHandler.StringToDateTime(this.tb_StartDate.Text.Trim()) ;
			DateTime end = CommHandler.StringToDateTime(this.tb_EndDate.Text.Trim()) ;
			//取员工ID
			int pid = pi.PersonnelID ;
			//调用BLL中查询申请_员工的方法
			DataTable dt = ApplyInfo.GetApplyInfo_Psn(type,start,end,pid) ;

			//为表格绑定数据
			BindDg(dt) ;
		}

		/// <summary>
		/// 为表格绑定数据
		/// </summary>
		/// <param name="dt"></param>
		private void BindDg(DataTable dt) 
		{
			//如果dt为null，实例一个
			if(dt == null)
			{
				dt = new DataTable() ;
			}

			this.dg.DataSource = dt ;
			this.dg.DataBind() ;
		}
		#endregion

		#region 清空
		private void bClear_Click(object sender, System.EventArgs e)
		{
			//清空
			Clear() ;
		}

		/// <summary>
		/// 清空函数
		/// </summary>
		private void Clear()
		{
			//清空类型、结束日期、开始日期
			this.ddl_Type.SelectedIndex = 0 ;
			this.tb_EndDate.Text = CommHandler.Today() ;
			this.tb_StartDate.Text = CommHandler.Today() ;
		}
		#endregion

		#region 修改
		private void bModify_Click(object sender, System.EventArgs e)
		{			
			string applyid = this.APPLYID.Value.Trim() ;
			string status = this.STATUS.SelectedValue ;
			//申请编号为空时，提示
			if(applyid == "")
			{				
				CommHandler.Alert(Page,"请在表格中选择需要修改的申请！") ;
				return ;
			}

			//只能修改提交状态的申请
			if(status != "1")
			{
				CommHandler.Alert(Page,"对不起，您只能修改提交状态的申请记录！") ;
				return ;
			}

			string url = ".\\Apply_Edit.aspx?APPLYID="+applyid ;

			//将页面定向到修改申请页面			
			Page.Response.Redirect(url) ;
		
		}
		#endregion

		#region 删除
		private void bDelete_Click(object sender, System.EventArgs e)
		{
			string applyid = this.APPLYID.Value.Trim() ;
			string status = this.STATUS.SelectedValue ;

			//申请编号为空时，提示
			if(applyid == "")
			{				
				CommHandler.Alert(Page,"请在表格中选择需要删除的申请！") ;
				return ;
			}

			//只能删除提交状态的申请
			if(status != "1")
			{
				CommHandler.Alert(Page,"对不起，您只能删除提交状态的申请记录！") ;
			}

			//调用删除申请的方法
			int i = ApplyInfo.DeleteApply(applyid) ;
			
			//删除成功
			if(i>0)
			{
				CommHandler.Alert(Page,"申请记录删除成功！") ;
			}
		
		}
		#endregion

		#region 表格的选中行处理
		private void dg_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//选中的行
			int i = e.Item.ItemIndex ; 

			//申请记录ID
			string id = dg.Items[i].Cells[1].Text ;

			//申请状态
			string status = dg.Items[i].Cells[5].Text ;

			//替换字符串中的空字符&nbsp
			id = CommHandler.FormatNullString(id) ;
			status = CommHandler.FormatNullString(status) ;

			//将ID记入Hidden
			this.APPLYID.Value = id ;
			CommHandler.DDL_ShowItem(STATUS,status) ;
		}
		#endregion

		#region 表格的数据绑定事件
		private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			//获取选中的行
			DataGridItem dgi = e.Item ;

			//页眉页脚不处理
			if(dgi.ItemType == ListItemType.Header 
				||dgi.ItemType == ListItemType.Footer)
			{
				return ;
			}

			//状态
			dgi.Cells[3].Text = CommHandler.DDL_ValueToText(this.STATUS,dgi.Cells[8].Text) ;

			//类型
			dgi.Cells[2].Text = CommHandler.DDL_ValueToText(this.ddl_Type,dgi.Cells[7].Text) ;
		}
		#endregion

		private void b_Add_Click(object sender, System.EventArgs e)
		{
			string url = ".\\Apply_Add.aspx" ;

			//将页面定向到修改申请页面			
			Page.Response.Redirect(url) ;	
		}
	}
}