streamsuperviset.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 ZHENGYI;
using System.Data .SqlClient ;
namespace OI.DraftOut
{
	/// <summary>
	/// streamSuperviseT 的摘要说明。
	/// </summary>
	public class streamSuperviseT : OI.PageBase
	{
		protected System.Web.UI.WebControls.Label Lbl_Title;
		protected System.Web.UI.WebControls.DataGrid dg;
		DataSet ds=new DataSet ();
		OI.cs.readStream Rs=new OI.cs.readStream ();
		
		protected OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		protected System.Web.UI.WebControls.ImageButton imge_cb;
		protected DataGridNavigation  divepage ;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			SetDivePage();
			if(!Page.IsPostBack )
			{
				ViewState["documentid"]=Request.Params["id"].ToString ();

				Lbl_Title.Text =Dbc.GetObjectBySql("select title from document where documentid="+ViewState["documentid"]).ToString (); 
			 dataBind();
			}

		}
		private void CreateDataSource()
		{
			string sql="(select d.documentid, dt.stepid, '己处理'as 'istransact',dt.userid,au.username, d.title,dt.idea,dt.transtype,dt.transactdate,dt.transactlimitdate  ";
                   sql +=" from document d,documenttransact dt  ,accounts_users au";
                   sql +=" where d.documentid=dt.documentid and d.documentid="+ViewState["documentid"] ;
//                   sql +=" and dt.backstate=(select max(backstate) from documentTransact where documentid=d.documentid) ";
                   sql +=" and dt.userid=au.userid) union  ";
				   sql +="  (select d.documentid,ts.stepid,  '<font color=red>未处理</red>'as 'istransact',ts.userid ,au.username ,'' ,'' ,'','9999-12-12',null  ";
			       sql +=" from document d, transactusers ts,accounts_users au";
			       sql +=" where d.documentid=ts.documentid ";
			       sql +=" and d.documentid="+ViewState["documentid"] ;
			       sql +=" and d.CurrentStepID=ts.stepID ";
			       sql +=" and ts.userid=au.userid )";
//			       sql +=" and ts.userid not in (select  userid from documenttransact where documentid=d.documentid and stepid=ts.stepid and backstate=(select max(backstate) from documentTransact where documentid=d.documentid )) )" ;
		           sql +=" union (select d.documentid, 3, '末处理'as 'istransact',au.userid,au.username, ";
                   sql +=" d.title,'','回退起草'as transtype ,'9999-12-12',null ";
                   sql +=" from document d,accounts_users au where  d.UserID=au.userid and d.documentid="+ ViewState["documentid"] +" and d.CurrentStepID=0) ";
			
			sql +=" order by dt.transactdate ";
			try
			{
				ds=Dbc.getBinding (sql,"nnnn");
			}
			catch
			{

			}

			
		}
		private void SetDivePage()
		{
			dg.AllowPaging =true; 
			dg.PageSize =15; 
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (dataBind);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(dg,f,15);
		}
		private void dataBind()
		{
			CreateDataSource();
			dg.DataSource =ds.Tables[0];
			dg.DataBind ();
		}

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

		}
		#endregion

		private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if (e.Item.ItemType ==ListItemType.Item ||e.Item.ItemType ==ListItemType.AlternatingItem)
			{
				
				Rs.doucmentID =int.Parse (e.Item .Cells[0].Text ) ;
				e.Item .Cells[3].Text =Rs.GetTimeByNodeID (e.Item .Cells[1].Text ) +"天";
				e.Item.Cells[1].Text=Rs.GetNodeTypeByID(e.Item.Cells[1].Text );
				CheckBox Ckb_press=(CheckBox) e.Item .FindControl ("Ckb_press");
				if(e.Item.Cells[4].Text.Trim () !="己处理")
				{
					
					Ckb_press.Visible =true;
				}
				else
				{
					Ckb_press.Visible =false;
				}
				if(e.Item.Cells[1].Text.Trim ()=="公文起草" && e.Item .Cells [5].Text .Trim() !="回退起草")
				{
                   e.Item .Cells [5].Text ="起草";
				}
				if (e.Item .Cells [7].Text.Trim ().Substring (0,4) =="9999")
				{
					e.Item .Cells [7].Text ="";
				}
			}
		}

//		private void Button1_Click(object sender, System.EventArgs e)
//		{
//			foreach (TableRow tr in dg.Items  )
//			{
//				CheckBox Ckb_press=(CheckBox)tr.FindControl ("Ckb_press");
//				if(Ckb_press.Checked )
//				
//				{
//					string sql=" insert message (senduserid,receiveuserid,documentid,FileTable,messagecontent) ";
//                           sql +=" values (" +Session["userid"] +","+tr.Cells[8].Text +"," + ViewState["documentid"] +",'document', '请你尽快处理公文<<"+Lbl_Title.Text +">>')"  ;
//					Dbc.ExecuteSQL (sql);
//					
//				}
//			}
//			Page.RegisterStartupScript ("","<script>alert('己成功完成催办');window.location.href='streamSuperviseF.aspx';</script>");
//		}

		private void imge_cb_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			foreach (TableRow tr in dg.Items  )
			{
				CheckBox Ckb_press=(CheckBox)tr.FindControl ("Ckb_press");
				if(Ckb_press.Checked )
				
				{
//					string sql=" insert message (senduserid,receiveuserid,documentid,FileTable,messagecontent) ";
//					sql +=" values (" +Session["userid"] +","+tr.Cells[8].Text +"," + ViewState["documentid"] +",'document', '请你尽快处理公文<<"+Lbl_Title.Text +">>')"  ;
//					Dbc.ExecuteSQL (sql);
					OI.cs.Message message=new OI.cs.Message ();
					message.MessageContent="请你尽快处理公文<<"+Lbl_Title.Text +">>";
					message.SendUserID =int.Parse (Session["userid"].ToString ());
					message.ReceiveUserID =int.Parse (tr.Cells[9].Text );
					message.messageType  = OI.cs.Message .MessageType .MessageOnly ;
					message.SendTime =System.DateTime .Now ;
				    message.AddMessageOnly ();
					
				}
			}
			Page.RegisterStartupScript ("","<script>alert('成功催办！');</script>");
		}
	}
}