viewtransact.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 System.Data .SqlClient ;
using System.Text .RegularExpressions ;
namespace OI.ReceivDocument
{
	/// <summary>
	/// viewTransact 的摘要说明。
	/// </summary>
	public class viewTransact : OI.PageBase
	{
		
		protected System.Web.UI.WebControls.Label SendDepartment;
		protected System.Web.UI.WebControls.Label ReceiveFileNumber;
		protected System.Web.UI.WebControls.Label SecretGreadID;
		protected System.Web.UI.WebControls.Label ReceiveDate;
		protected System.Web.UI.WebControls.Label DocumentTitle;
		protected System.Web.UI.WebControls.Label Ldyj;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Receivedeclare;
		protected System.Web.UI.WebControls.Label ExigenceDegreeID;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected OI.DatabaseOper .DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect();
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面if (Session["userid"]==null)
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}

			if (!Page.IsPostBack )
			{
				ViewState["url"]=Request.Params ["path"].ToString ();
				try
				{
					ViewState["transactid"]=int .Parse (Request.Params ["id"].ToString ()).ToString ();
					
				}
				catch
				{  
					try
					{
						ViewState["ReDocumentID"]=int.Parse (Request.Params ["Rid"].ToString ()).ToString ();
					}
					catch
					{
						return;
					}

				}
				
				
			}
			Display();
			//transdetail.ReDocumentID  =int.Parse (ViewState["reDocumentID"].ToString ());
			//transdetail.IsView =true;
			
		}
		/// <summary>
		/// 显示初始化值.
		/// </summary>
		private void Display( ) 
		{
			string str="";
			if (ViewState["transactid"] !=null)
			{
				str=" select  r.*,a.username,s.SecretGreadName,e.ExigenceDegreeName from documentMitTransaction d,accounts_users a, ReceiveDocument r,secretgread s,exigencedegree e";
				str +=" where r.SecretGreadID=s.SecretGreadID and r.ExigenceDegreeID=e.ExigenceDegreeID and d.userid=a.userid and d.ReDocumentID=r.ReDocumentID and d.transactid= "+ViewState["transactid"].ToString ();
			}
			if (ViewState["ReDocumentID"] !=null)
			{
				str="select * from ReceiveDocument r,secretgread s,exigencedegree e  where r.ExigenceDegreeID=e.ExigenceDegreeID and  r.SecretGreadID=s.SecretGreadID and  ReDocumentID="+ViewState["ReDocumentID"].ToString ();
			}
			try
			{
				DataSet ds= new DataSet ();
				ds= Dbc.getBinding (str,"t");
				if (ds.Tables[0].Rows.Count >0)
				{
					SendDepartment.Text=ds.Tables[0].Rows[0]["SendDepartment"].ToString ();
					DocumentTitle.Text=ds.Tables[0].Rows[0]["DocumentTitle"].ToString ();
					ReceiveFileNumber.Text=ds.Tables[0].Rows[0]["ReceiveFileNumber"].ToString ();
					SecretGreadID.Text=ds.Tables[0].Rows[0]["SecretGreadName"].ToString ();
                   
					//ReceiveDate.Text=ds.Tables[0].Rows[0]["ReceiveDate"].ToString ();
					ReceiveDate.Text = System.DateTime .Parse (ds.Tables[0].Rows[0]["ReceiveDate"].ToString ()).ToShortDateString();
					//Receivedeclare.Text=ds.Tables[0].Rows[0]["Receivedeclare"].ToString(); 
					Receivedeclare.Text=Server.HtmlEncode (ds.Tables[0].Rows[0]["Receivedeclare"].ToString()).Replace ("\r\n","<br/>").Replace (" " ,"&nbsp");

					ExigenceDegreeID.Text=ds.Tables[0].Rows[0]["ExigenceDegreeName"].ToString(); 
				
					//lbl_title.Text =ds.Tables[0].Rows[0]["documentTitle"].ToString ();
					ViewState["reDocumentID"]=ds.Tables[0].Rows[0]["ReDocumentID"].ToString ();
				}
			}
			catch(Exception er)
			{
		
				Response.Write (er.Message );
				Response.End ();
			}
			string sql2="select *from documentmittransaction where redocumentid="+ViewState["reDocumentID"]+" order by transactid desc";
			try
			{
				DataSet ds2=Dbc.getBinding(sql2,"tt1");
				if(ds2.Tables["tt1"].Rows.Count>0)
				{
					Session["IsldID"]=ds2.Tables["tt1"].Rows[0]["IsldID"].ToString();
				}
			}
			catch(Exception ere)
			{
				Response.Write (ere.Message );
				Response.End ();
			}
			OI.SendMessage.printTransactPaper pT=new OI.SendMessage.printTransactPaper();
			string   sql1="select d.*,a.username,a.userid from documentMitTransaction d,accounts_users a where d.userid=a.userid  and  ReDocumentID="+ ViewState["reDocumentID"];
            
			
			//else
			//{
			//	sql1="select d.*,a.username from documentMitTransaction d,accounts_users a where d.userid=a.userid and IsldID=1 and  ReDocumentID="+ ViewState["reDocumentID"];
			//}
			DataSet ds1=Dbc.getBinding(sql1,"t1");
	       
			DataTable dt=ds1.Tables [0];
			printTransactMans print=new printTransactMans ();
			Table tab=print. CreatePrintTable(dt,6);
			Panel1.Controls .Add (tab);
   




			int countt=System.Convert.ToInt32(Dbc.GetValueBySql(sql1));
			if(countt!=0)
			{
			
				foreach(DataRow dr in ds1.Tables["t1"].Rows)
				{
					if(Convert.ToBoolean(dr["Istransact"].ToString()))
					{
						if(Convert.ToBoolean(dr["IsldID"].ToString()))
						{
							string idea=dr["Idea"].ToString().Replace ("-","－—");
							idea=idea.Replace ("\r\n","－");
							Regex reg=new Regex (@"[－]*$");
							idea=reg.Replace (idea,"");
							string []contents= idea.Split (char.Parse ("－"));
							if (contents.Length >1)
							{
							
								Ldyj.Text +=Server.HtmlEncode (idea).Replace  ("－","<br/>").Replace (" " ,"&nbsp");
								Ldyj.Text +="<br>";
								for(int i=0;i<contents[contents.Length-1 ].Length ;i++)
								{
									Ldyj.Text +="&nbsp;&nbsp;&nbsp;";
								}
								Ldyj.Text +=pT.getPersonSign(dr["userid"].ToString())+"<br>";
							}
							else
							{
								Ldyj.Text +=Server.HtmlEncode (idea).Replace  ("－","<br/>").Replace (" " ,"&nbsp");
								Ldyj.Text +="<br>";
								for(int i=0;i<idea.Length+1 ;i++)
								{
									Ldyj.Text +="&nbsp;&nbsp;&nbsp;";
								}
								Ldyj.Text +=pT.getPersonSign(dr["userid"].ToString())+"<br>";
							}

							//Ldyj.Text+=Server.HtmlEncode (dr["Idea"].ToString()).Replace ("\r\n","<br/>").Replace (" " ,"&nbsp")+"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"+pT.getPersonSign(dr["userid"].ToString())+"<br>&nbsp;&nbsp;";//领导签字
						}
						else
						{
							Label5.Text+=Server.HtmlEncode (dr["Idea"].ToString()).Replace ("\r\n","<br/>").Replace (" " ,"&nbsp")+"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"+pT.getPersonSign(dr["userid"].ToString())+"<br>&nbsp;&nbsp;";//意见
						}
					}
					//					Label6.Text+="<td>"+dr["username"].ToString()+"</td>";
					//			
					//					Label7.Text+="<td>"+dr["SendDate"].ToString()+"</td>";
					//					
					//					if(dr["TransactDate"].ToString().Trim()=="")
					//					{
					//						Label8.Text+="<td>还没有退件</td>";
					//					}
					//					else
					//					{
					//						Label8.Text+="<td>"+dr["TransactDate"].ToString()+"</td>";
					//					}
				}
			}
           


		}
		

		#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


	}
}