📄 archivedetail.aspx.cs

📁 很不错的公文流转系统
💻 CS
字号:
/******************************************************************
*  Source File Name  : ArchiveDetail                              *
*  Project Name:   OI.csproj				                      *
*  Engineer:  黎斌                                                *
*  Date Generated: 2003/12/17                                     *
*  Last Revision Date :											  *
*  Brief Description  : 存档公文详细信息						  *
******************************************************************/
using System; 
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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.Archives
{
	/// <summary>
	/// ArchiveDetail 的摘要说明。
	/// </summary>
	public class ArchiveDetail : OI.PageBase   //OI.PageBase
	{
		// 在此处放置用户代码以初始化页面
		

		public string mSubject;
		public string mStatus;
		public string mAuthor;
		public string mFileName;
		public string mFileDate;
		public string mHTMLPath;
        
		public string mDisabled;

		public string mHttpUrl;
		public string mScriptName;
		public string mServerName;
		public string mClientName;
		public string mServerUrl;
		public string mClientUrl;


		public string mRecordID;
		public string mTemplate;
		public string mFileType;
		public string mEditType;
		public string mUserName;
		//
		public string  PTitle;
		public string PSendDate;
		public string Psecretgreadname;
		public string Pdocumenttypename ;
		public string Pexigencedegreename ;
		public string PDocumentID;

		public string Lbl_Content;
		
		public string mWord;
		public string mExcel;
		protected System.Web.UI.WebControls.Panel Panel1;

		//******************************************************************  add by 黎斌
		protected System.Web.UI.WebControls.Label Lbl_DraftDepartment;		
		protected System.Web.UI.WebControls.Label Lbl_DocumentType;
		protected System.Web.UI.WebControls.Label Lbl_DocumentTypeName;
		protected System.Web.UI.WebControls.Label Lbl_SecretGreadName;
		protected System.Web.UI.WebControls.Label Lbl_ExigenceDegreeName;
		protected System.Web.UI.WebControls.Label Lbl_MainSendComp;
		protected System.Web.UI.WebControls.Label Lbl_CopySendComp;
		protected System.Web.UI.WebControls.Label Lbl_StreamName;
		protected System.Web.UI.WebControls.Label Lbl_Title;
		
		protected System.Web.UI.WebControls.Label Lbl_Time;
	
		protected OI.DatabaseOper.DatabaseConnect oConn = new OI.DatabaseOper.DatabaseConnect();
		private System.Data.DataSet dsDocument;
		private OI.cs.readStream oReadStream = new OI.cs.readStream();
		private string szSql;
//		private string szNodeName;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		private int nDoc;
//		private string userid;
		//*****************************************************************

		public int NDoc 
		{
			set
			{
				nDoc=value;
			}
			get
			{
				return nDoc;
			}
		}

		
		private void Page_Load(object sender, System.EventArgs e)
		{
			//******************************************  modified by 黎斌
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			　
			//****************************************************************

			//********************************************************************************************* modified by 黎斌
			//get the document's detail infomation
			szSql = "select * from VIEWdocument where DocumentID=" + Request.QueryString["DocumentID"].ToString();
			dsDocument = oConn.getBinding(szSql,"Temp");
			if ( dsDocument.Tables ["Temp"].Rows .Count <=0)
			{
				return ;
			}
			Lbl_DraftDepartment.Text	 = dsDocument.Tables["Temp"].Rows[0]["DrawMan"].ToString();			
			Lbl_DocumentType.Text		 = dsDocument.Tables["Temp"].Rows[0]["DocumentTypeDescription"].ToString();
			Lbl_DocumentTypeName.Text	 = dsDocument.Tables["Temp"].Rows[0]["DocumentTypeName"].ToString();
			Lbl_SecretGreadName.Text	 = dsDocument.Tables["Temp"].Rows[0]["SecretGreadName"].ToString();
			Lbl_ExigenceDegreeName.Text	 = dsDocument.Tables["Temp"].Rows[0]["ExigenceDegreeName"].ToString();
			Lbl_StreamName.Text			 = dsDocument.Tables["Temp"].Rows[0]["StreamName"].ToString();
			Lbl_Title.Text				 = dsDocument.Tables["Temp"].Rows[0]["Title"].ToString();			
			Lbl_Time.Text				 = dsDocument.Tables["Temp"].Rows[0]["FileDate"].ToString();
			

			 nDoc=int.Parse (Request.QueryString["DocumentID"].ToString());
			szSql = "select v.stepID,a.userid,a.username, v.idea,v.ManageID ,departmentname from VIEWDocumentTransact v inner join accounts_Users a on v.username=a.username where DocumentID='" +nDoc+"'" ;
			dsDocument = oConn.getBinding(szSql,"Temp");
			
		

			OI.cs.readStream oReadStream = new OI.cs.readStream();
			oReadStream.doucmentID = nDoc;//appoint stream by the document ID
	
			string szNodeName="";
			foreach (DataRow dr in dsDocument.Tables["Temp"].Rows)
			{
				szNodeName = oReadStream.GetNodeTypeByID(dr["StepID"].ToString());
				string userid=dr["userid"].ToString();
				
				OI.cs.personalSign sign=new OI.cs.personalSign ();
				sign.UserID =int.Parse (userid);
				string displaySign=sign.Displayimg(true);
				string departmentname=dr["departmentname"].ToString ();
 
				if (true)//dr["Idea"].ToString().Trim() != "" && dr["Idea"] != null)
				{
					
					Lbl_Content += "<tr align=left>";
					Lbl_Content += "<td   width='20%' align=right>工作流节点名称：</td>";
					Lbl_Content += "<td width='15%'>&nbsp;" + szNodeName + "</td>";
					Lbl_Content += "<td   width='15%' align=right >处理人：</td>";
					if(szNodeName.Trim ()=="公文起草" ) 
					{
						Lbl_Content += "<td width='20%'>&nbsp;" + Lbl_DraftDepartment.Text + "</Td><td width=30%>部门:"+departmentname  +"</td>";	
						Lbl_Content += "</tr>";
					}
					else
					{
						if ( szNodeName.Trim ()=="公文中转")
						{

							Lbl_Content += "<td width='20%'>&nbsp;" + dr["username"].ToString () + "</Td><td width=30%>部门:"+departmentname  +"</td>";	
							Lbl_Content += "</tr>";
						}
						else 
						{
							Lbl_Content += "<td width='20%'>&nbsp;" + displaySign +  "</Td><td width=30%>部门:"+departmentname  +"</td>";
					 
							//				Lbl_Content += "<td></td>";
							Lbl_Content += "</tr>";

							Lbl_Content += "<tr bgcolor=#fffaf0>";
					

							Lbl_Content += "<td align=right >处理意见：</td>";
							Lbl_Content += "<td >&nbsp;" + dr["Idea"].ToString().Replace("\r\n","<br>")+ "</td>";

							string doType="";
							if(dr["ManageID"].ToString ().Trim ()=="1")
								doType="同意";
							else
							{
								if(dr["ManageID"].ToString ().Trim ()=="4")
								{
									doType="中转";
								}
								else
								{
									doType="退回";
								}
							}
							Lbl_Content +="<td colspan=2 align=right >处理类型：</td>";
							Lbl_Content +="<td >&nbsp;"+doType+"</td>";
					
							Lbl_Content += "</tr>";
						}
					}
				}
			}
			//************************************************************************************************************

			// 在此处放置用户代码以初始化页面
			

			mHTMLPath="";
			mDisabled="";
			mScriptName="ArchiveDetail.aspx";
			mServerName="webdocserver.aspx";
			mClientName="../FairyWebOfficeOcx.ocx";			
			mHttpUrl="http://" + Request.ServerVariables["HTTP_HOST"] + Request.ServerVariables["SCRIPT_NAME"];
			mHttpUrl=mHttpUrl.Substring(0,mHttpUrl.Length -mScriptName.Length);
			if(System.Web.HttpRuntime.AppDomainAppVirtualPath=="")
				mServerUrl="http://"+Request.ServerVariables["HTTP_HOST"] +"/DocTemplate/" + mServerName;
			else
				mServerUrl="http://"+Request.ServerVariables["HTTP_HOST"] +System.Web.HttpRuntime.AppDomainAppVirtualPath+"/DocTemplate/" + mServerName;
			mClientUrl=mHttpUrl + mClientName;
	        
			

			mTemplate=Request.QueryString["Template"];
			mFileType=Request.QueryString["FileType"];
			mEditType=Request.QueryString["EditType"];
			mUserName=Session["UserName"].ToString();

			//取得编号
			if ( mRecordID==null)
			{
				mRecordID="";	//编号为空
			}
			//取得模式
			if ( mEditType==null)
			{
				mEditType="0";		// 0 只读
			}
			if((mEditType=="0") || (mEditType=="1"))
			{
				Panel1.Visible=false;//在起草和显示时不显示左边的工具栏　
			}
			//取得类型
			if ( mFileType==null)
			{
				mFileType=".doc";	// 默认为.doc文档
			}
			//取得用户名
			if (mUserName==null)
			{
				mUserName="成都派尔科技有限公司";
			}
			
			

			//取得模板
			if ( mTemplate==null)
			{
				mTemplate="";	// 默认没有模板
			}

			//打开数据库
			string strSelectCmd="Select * From view_document Where documentid="+ nDoc ;//:pf modify here by  2003.12.11 11:05
			//string strSelectCmd="Select * From Document Where RecordID='"+ mRecordID + "'";
			SqlCommand mCommand = new SqlCommand(strSelectCmd,oConn.GetConn());//更改
			SqlDataReader mReader = mCommand.ExecuteReader(CommandBehavior.CloseConnection);
			
			if (mReader.Read())
			{
				mRecordID=mReader["RecordID"].ToString();
				mTemplate=mReader["Template"].ToString() ;
				mSubject=mReader["Subject"].ToString();
				mAuthor=mReader["drawman"].ToString();
				mFileDate=mReader["FileDate"].ToString();
				mStatus=mReader["Status"].ToString();
				mFileType=mReader["FileType"].ToString();
				mHTMLPath=mReader["HTMLPath"].ToString() ;
				PTitle=mReader["Title"].ToString() ;
				PSendDate=mReader["SendDate"].ToString() ;
				Psecretgreadname=mReader["secretgreadname"].ToString() ;
				Pdocumenttypename=mReader["documenttypename"].ToString() ;
				Pexigencedegreename=mReader["exigencedegreename"].ToString() ;
				mReader.Close();
			}
			else
			{
				mReader.Close();
			
				System.DateTime SystemTime;
				SystemTime=DateTime.Now;

				mRecordID=SystemTime.ToString("yyyyMMddhhmmss");
				mTemplate=mTemplate;
				mSubject="请输入标题";
				mAuthor=mUserName;
				mFileDate=oConn.GetDateTime();
				mStatus="DERF";
				mFileType=mFileType;
				mHTMLPath="";
			}
			

			if ( mStatus.CompareTo("EDIT")==0 ) mEditType="0";	//	0 显示
			if ( mStatus.CompareTo("READ")==0 ) mEditType=mEditType; 	// 	
			if ( mStatus.CompareTo("DERF")==0 ) mEditType="1" ;	//	1 起草

			//mEditType = "0";//modified by 黎斌
			if ( mEditType.CompareTo("0")==0)
			{
				mDisabled="disabled";
			}
			else
			{
				mDisabled="";
			}

			mFileName=mRecordID + mFileType;
			if (mFileType==".doc")
			{
				mWord="";
				mExcel="disabled";
			}
			else
			{
				mWord="disabled";
				mExcel="";
			}

		}


		#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

//		private void LB_Stream_Click(object sender, System.EventArgs e)
//		{
//			Response.Redirect("../desktop/StreamDetail.aspx",true);
//		}
	}
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -