moas1104.1.aspx.cs

很具有学习参考价值的OA办公自动化系统,完整源码.ＯＡｄｅ

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;

namespace MOAS
{
	/// <summary>
	/// MOAS1104_1 的摘要说明。
	/// </summary>
	public class MOAS1104_1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label lblPageCount;
		protected System.Web.UI.WebControls.Label lblCurrentIndex;
		protected System.Web.UI.WebControls.LinkButton btnFirst;
		protected System.Web.UI.WebControls.LinkButton btnPrev;
		protected System.Web.UI.WebControls.LinkButton btnNext;
		protected System.Web.UI.WebControls.LinkButton btnLast;
		protected System.Web.UI.WebControls.LinkButton Linkbutton1;
		protected System.Web.UI.WebControls.LinkButton Linkbutton2;
		protected System.Web.UI.WebControls.DataGrid MyDataGrid;
		protected System.Web.UI.WebControls.Label Label1;

//		string page="";
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			
			if(!Page.IsPostBack)
			{
					BindGrid();
			
			}

		}
		public void PagerButtonClick(object sender, EventArgs e)
		{
			string arg = ((LinkButton)sender).CommandArgument.ToString();
			switch(arg)
			{
				case "next":
					if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
					{
						MyDataGrid.CurrentPageIndex += 1;
					}
					break;
				case "prev":
					if (MyDataGrid.CurrentPageIndex > 0)
					{
						MyDataGrid.CurrentPageIndex -= 1;
					}
					break;
				case "last":
					MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
					break;
				default:
					MyDataGrid.CurrentPageIndex = System.Convert.ToInt32(arg);
					break;
			}
			BindGrid();
		}
		public void MyDataGrid_Page(object sender, DataGridPageChangedEventArgs e)
		{
			int startIndex ;
			startIndex = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize;
			MyDataGrid.CurrentPageIndex = e.NewPageIndex;
			MyDataGrid.SelectedIndex=0;
			BindGrid();
			ShowStats();
		}
		private void ShowStats()
		{
			if(MyDataGrid.CurrentPageIndex==-1)
			{
				lblCurrentIndex.Text = "第 1 页";
				lblPageCount.Text = "总共 " + MyDataGrid.PageCount.ToString() + " 页";
			}
			else
			{
				
				lblCurrentIndex.Text = "第 " + (MyDataGrid.CurrentPageIndex + 1).ToString() + " 页";
				lblPageCount.Text = "总共 " + MyDataGrid.PageCount.ToString() + " 页";
			
			}
		}
		public void BindGrid()
		{
			ExcuteSql();
			if(MyDataGrid.Items.Count!=0)
			{
				MyDataGrid.SelectedIndex=0;
			}
			else
			{
			MyDataGrid.SelectedIndex=-1;
			}
				ShowStats();
		}
		public void ExcuteSql()
		{	
			string select="";
			string aa=Request.QueryString["status"];
			
			switch(aa)
			{
				case "0":
					select="select a.name 姓名,a.id 职员ID,b.value 所属部门,c.value 职务,a.mail Email from users  a, codemaster b,codemaster c where (a.job_id=c.no and c.id='C009')and(a.dep_id=b.no and b.id='C002')";
				    break;
				case "1":
                    select="select a.name 姓名,a.id 职员ID,b.value 所属部门,c.value 职务,a.mail Email from users  a, codemaster b,codemaster c where (a.job_id=c.no and c.id='C009')and(a.dep_id=b.no and b.id='C002')and(a.status='1')";
				    break;
				case "2":
					select="select a.name 姓名,a.id 职员ID,b.value 所属部门,c.value 职务,a.mail Email from users  a, codemaster b,codemaster c where (a.job_id=c.no and c.id='C009')and(a.dep_id=b.no and b.id='C002')and(a.status='0')";
		            break;
				default:
					select="select a.name 姓名,a.id 职员ID,b.value 所属部门,c.value 职务,a.mail Email from users  a, codemaster b,codemaster c where (a.job_id=c.no and c.id='C009')and(a.dep_id=b.no and b.id='C002')and(a.status='1')";
					break;
			}
			try
			{
				CCoSearchFromDatabase dsc1=new CCoSearchFromDatabase();
				MyDataGrid.DataSource=dsc1.getDataSet(select);
				MyDataGrid.DataBind();
			}
			catch(Exception ex)
			{
				HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+"");  //有异常.抛出异常画面.
			}
		}
		private void Linkbutton2_Click(object sender, System.EventArgs e)
		{
			if(Session["strTransHuanmianId"].ToString()!="")
			{
				if(Session["strTransHuanmianId"].ToString()=="1103")
				{
					Response.Redirect("MOAS1103.aspx");
				}
				else
				{
					Response.Redirect("MOAS1202.aspx");
				}
			}
		}
		private void Linkbutton1_Click(object sender, System.EventArgs e)
		{
			
			if(Session["strTransHuanmianId"].ToString()!="" && MyDataGrid.SelectedIndex!=-1)
			{
				if(Session["strTransHuanmianId"].ToString()=="1103")
				{
					Session.Add("strTransUseridFrom11041",MyDataGrid.Items[MyDataGrid.SelectedIndex].Cells[2].Text);
					Response.Redirect("MOAS1103.aspx");
				}
				else
				{
					Session.Add("strTransUseridFrom11041",MyDataGrid.Items[MyDataGrid.SelectedIndex].Cells[2].Text);
					Response.Redirect("MOAS1202.aspx");
				}
			}
			
		}
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnLast.Click += new System.EventHandler(this.btnLast_Click);
			this.Linkbutton1.Click += new System.EventHandler(this.Linkbutton1_Click);
			this.Linkbutton2.Click += new System.EventHandler(this.Linkbutton2_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void MyDataGrid_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void btnLast_Click(object sender, System.EventArgs e)
		{
		
		}
	}
}