dostatus.aspx.cs

很不错的公文流转系统

/***********************************************
 * Author:吴高发
 * Date:04-2-6
 * ********************************************/
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 OI.PersonSend
{
	/// <summary>
	/// DoStatus 的摘要说明。
	/// </summary>
	public class DoStatus : OI.PageBase 
	{
		protected System.Web.UI.WebControls.Table TableInDo;
		protected System.Web.UI.WebControls.Table TableOutDo;
		private OI.DatabaseOper .DatabaseConnect dc;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			if(!this.IsPostBack )
			{
				this.BindDataNew1 ();
			}
		}
//		private void BindDataNew()
//		{
//			if (Session["userid"]==null)
//			{
//				Response.Write  ("<script>top.location.href='../userpass.aspx'</script>");
//				return;
//			}
//			int id=Convert.ToInt32 (Request.Params ["id"].ToString ());
//			dc=new OI.DatabaseOper.DatabaseConnect ();
//			string sql="select UserName from datumPersonAccept,Accounts_Users "+
//				"where datumPersonAccept.DatumID='"+id+"'"+
//				"AND datumPersonAccept.IsAccept=0 and datumPersonAccept.UserID=Accounts_Users.UserID";
//			DataSet ds=dc.getBinding (sql,"t1");	
//			DataGridIN.DataSource =ds.Tables ["t1"].DefaultView ;
//			DataGridIN.DataBind ();
//			sql="select UserName,AcceptDate from datumPersonAccept,Accounts_Users "+
//				"where datumPersonAccept.DatumID='"+id+"'"+
//				"AND datumPersonAccept.IsAccept=1 and datumPersonAccept.UserID=Accounts_Users.UserID";
//			ds=dc.getBinding (sql,"t2");
//			DataGridOUT.DataSource =ds.Tables ["t2"].DefaultView ;
//			DataGridOUT.DataBind ();
//		}
		private void BindDataNew1()
		{		
			if (Session["userid"]==null)
			{
				Response.Write  ("<script>top.location.href='../userpass.aspx'</script>");
				return;
			}
			int id=Convert.ToInt32 (Request.Params ["id"].ToString ());
			TableRow tabelR;
			TableCell tableC;
			string sql="select UserName from datumPersonAccept,Accounts_Users "+
				"where datumPersonAccept.DatumID='"+id+"'"+
				"AND datumPersonAccept.IsAccept=0 and datumPersonAccept.UserID=Accounts_Users.UserID";
			dc=new OI.DatabaseOper.DatabaseConnect ();
			ArrayList alNew=dc.getData (sql);
			for(int x=0;x<alNew.Count ;x++)
			{
				tabelR=new TableRow ();
				tableC=new TableCell ();
				tableC.Controls.Add (new LiteralControl(alNew[x].ToString ()));
				tabelR.Cells .Add (tableC);				
				TableInDo.Rows .Add (tabelR);
			}
			sql="select UserName,AcceptDate,disalow from datumPersonAccept,Accounts_Users "+
				"where datumPersonAccept.DatumID='"+id+"'"+
				"AND datumPersonAccept.IsAccept=1 and datumPersonAccept.UserID=Accounts_Users.UserID" +
				" order by disalow ,AcceptDate ";
			alNew=dc.getData (sql);
			DataSet ds=new DataSet ();
			ds=dc.getBinding (sql,"t");
			foreach (DataRow dr in ds.Tables[0].Rows )
			{
				TableRow tr=new TableRow ();
				TableCell tc=new TableCell ();
				tc.Text = dr["username"].ToString ();
				if (dr["disalow"].ToString ()=="True")
				{
					tc.Text +="<font color=red> (拒签)</font>";
				}
				tr.Cells .Add (tc);
				tc=new TableCell ();
				tc.Text =dr["AcceptDate"].ToString ();
				tr.Cells .Add (tc);
                TableOutDo.Rows .Add (tr);
			}
//			for(int x=0;x<alNew.Count ;x+=2)
//			{
//				tabelR=new TableRow ();
//				tableC=new TableCell ();
//				tableC.Controls.Add (new LiteralControl(alNew[x].ToString ()));
//				tableC.Width=160;
//				tabelR.Cells .Add (tableC);	
//				tableC=new TableCell ();
//				tableC.Controls.Add (new LiteralControl(alNew[x+1].ToString ()));
//				tabelR.Cells .Add (tableC);				
//				TableOutDo.Rows .Add (tabelR);
//
//			}
		}

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

		}
		#endregion
	}
}