moas1105.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>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class MOAS1105 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Table Table1;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Table Table2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			SetSessionUserid();　
			 ShowDatagrid();
		}

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

		}
		#endregion
		private void SetSessionUserid()
		{
			//get session
			string strGetSession=Session["strTransUseridFrom1104"].ToString ();
			//get sql string
			strGetSession="'"+strGetSession+"'";
			string  m_Sql="SELECT a.ID, a.NAME, a.PASSWORD, a.ID_CARD, b.VALUE AS aaa, c.VALUE AS bbb, a.TEL, a.MAIL, a.IP, a.MOBILE, a.HOMETEL, a.HOMEMAIL, a.STATUS, a.START_TIME, a.END_TIME FROM USERS a INNER JOIN CODEMASTER c ON a.JOB_ID = c.NO INNER JOIN CODEMASTER b ON a.DEP_ID = b.NO 	WHERE (b.ID = 'C002') AND (c.ID = 'C009')and(a.ID="+strGetSession+")";
			CCoSearchFromDatabase m_Search=new CCoSearchFromDatabase ();
			//string[,] m_Array=new string[255 ,255 ] ;
			//m_Array=m_Search.getList(m_Sql);
			
			string[] strGetArry=new string [16];

			for(int i=0;i<15;i++)
			{
				strGetArry[i]=((string[,])m_Search.getList(m_Sql))[0,i];
			}
			Session.Add ("user_Id",strGetArry);
			
		}
		private void ShowDatagrid()
		{
			//get session
			string strGetSession=Session["strTransUseridFrom1104"].ToString ();
			//get sql string
			strGetSession="'"+strGetSession+"'";
			string m_Sql="SELECT NO, USER_ID, TYPE, START_DATE, END_DATE, BIKOU FROM UKISAKI where user_id="+strGetSession+"";
			//instance CCoSearchFromDatabase to get dataset
			CCoSearchFromDatabase m_Search=new CCoSearchFromDatabase ();
			System.Data .DataSet m_DataSet=new DataSet ();
			m_DataSet=m_Search.getDataSet (m_Sql);
			//DataGrid1 databind
			DataGrid1.DataSource=m_DataSet;
			DataGrid1.DataBind ();
			m_DataSet.Dispose();
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			Response.Redirect ("MOAS1104.aspx",false);
		}
	}
}