gwselecturl.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 OI.DatabaseOper;
namespace OI.Manage
{
	/// <summary>
	/// gwselecturl 的摘要说明。
	/// </summary>
	public class gwselecturl : OI.PageBase 
	{
		private DatabaseConnect dc=new DatabaseConnect();

		private void Page_Load(object sender, System.EventArgs e)
		{
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			int countt;
			int DocumentID=Convert.ToInt32(Request.Params ["DocumentID"]);
			dc=new DatabaseConnect();
			DataSet ds=new DataSet();
			string sql31="select * from receivewait where  DocumentID="+DocumentID;
			ds=dc.getBinding(sql31,"receivewait");
			countt=System.Convert.ToInt32(dc.GetValueBySql(sql31));
			if (countt!=0)
			{
				Page.Response.Redirect("../archives/ArchiveDetail.aspx?documentid="+DocumentID);
				return;
			}
			string sql21="select * from documentsendr where DocumentID="+DocumentID;
			ds=dc.getBinding(sql21,"documentsendr");	
			countt=System.Convert.ToInt32(dc.GetValueBySql(sql21));
			if (countt!=0)
			{
				Page.Response.Redirect("../archives/ArchiveDetail.aspx?documentid="+DocumentID);
				return;
			}
			string sql11="select * from DocumentTransact where TransactSign=2 and  DocumentID="+DocumentID;
			ds=dc.getBinding(sql11,"DocumentTransact");	
			countt=System.Convert.ToInt32(dc.GetValueBySql(sql11));
			if (countt!=0)
			{
				Page.Response.Redirect("../archives/ArchiveDetail.aspx?documentid="+DocumentID);
				return;
			}
			string sql51="select * from DocumentTransact where TransactSign=0 and  DocumentID="+DocumentID;
			ds=dc.getBinding(sql11,"DocumentTransact");	
			countt=System.Convert.ToInt32(dc.GetValueBySql(sql51));
			if (countt!=0)
			{
				Page.Response.Redirect("../Document/dispTransact.aspx?documentid="+DocumentID);
				return;
			}
//TransactSign=0
			string sql="select * from Document where DocumentID="+DocumentID+"";
			ds=dc.getBinding(sql,"Document");	
            countt=System.Convert.ToInt32(dc.GetValueBySql(sql));
			if (countt!=0)
			{
				Page.Response.Redirect("../DraftOut/DraftStart.aspx?DocumentID="+DocumentID);
				return;
			}
			// 在此处放置用户代码以初始化页面
		}

		#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
	}
}