officeserver.aspx.cs

很不错的公文流转系统

			mReader=mCommand.ExecuteReader(CommandBehavior.CloseConnection);
			if (mReader.Read())
			{
				mFileBody=mReader.GetSqlBinary(0).Value; 
				mResult=true;
				mReader.Close();
			}
			else
			{
				mResult=false;
				mReader.Close();
			}			
			
			return (mResult);
		}

		//保存版本，将该版本文件存盘，并将说明信息也保存起来
		private bool SaveVersion()
		{
			bool mResult=false;
			SqlCommand nCommand;
			string strInsertCmd;

			strInsertCmd="insert into Document_File (RecordID,FileName,FileType,FileSize,FileDate,FileBody,FilePath,UserName,Descript) values (@RecordID,@FileName,@FileType,@FileSize,@FileDate,@FileBody,@FilePath,@UserName,@Descript)";
			nCommand = new SqlCommand(strInsertCmd, DBAobj.GetConn());//更改
			
			nCommand.Parameters.Add(new SqlParameter("@RecordID", SqlDbType.VarChar,16)); 
			nCommand.Parameters["@RecordID"].Value = mRecordID;

				
			nCommand.Parameters.Add(new SqlParameter("@FileName",SqlDbType.VarChar,64)); 
			nCommand.Parameters["@FileName"].Value = mFileName;

				
			nCommand.Parameters.Add(new SqlParameter("@FileType",SqlDbType.VarChar,4)); 
			nCommand.Parameters["@FileType"].Value = mFileType;
				
				
			nCommand.Parameters.Add(new SqlParameter("@FileSize",SqlDbType.Int)); 
			nCommand.Parameters["@FileSize"].Value = mFileSize;
				
				
			nCommand.Parameters.Add(new SqlParameter("@FileDate",SqlDbType.DateTime)); 
			nCommand.Parameters["@FileDate"].Value = mFileDate;
				
				
			nCommand.Parameters.Add(new SqlParameter("@FileBody",SqlDbType.Image)); 
			nCommand.Parameters["@FileBody"].Value = mFileBody;
				
				
			nCommand.Parameters.Add(new SqlParameter("@FilePath",SqlDbType.VarChar,64)); 
			nCommand.Parameters["@FilePath"].Value = mFilePath;
				
				
			nCommand.Parameters.Add(new SqlParameter("@UserName",SqlDbType.VarChar,32)); 
			nCommand.Parameters["@UserName"].Value = mUserName;
				
				
			nCommand.Parameters.Add(new SqlParameter("@Descript",SqlDbType.VarChar,64)); 
			nCommand.Parameters["@Descript"].Value = mDescript;
			if (nCommand.ExecuteNonQuery()==1)
			{
				mResult=true;
				DBAobj.DataBaseClose();
			}
			else
			{
				mResult=false;
				DBAobj.DataBaseClose();
			}
			return (mResult);
		}

		//取得书签列表
		private bool ListBookmarks()
		{
			bool mResult=false;
			mBookmark="";
			mDescript="";
			SqlDataReader mReader ;
			
			string strSelectCmd= "SELECT * FROM Bookmarks ";
			SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
			mReader = mCommand.ExecuteReader(CommandBehavior.CloseConnection);
			if (mReader.FieldCount>0)
			{
				while(mReader.Read())
				{
					mBookmark+=mReader["BookMarkName"]+"\r\n";                              //用户名列表
					mDescript+=mReader["BookMarkDesc"]+"\r\n";                             //如果说明信息里有回车，则将回车变成>符号
				}
				
				mResult=true;
				mReader.Close();
			}
		
			else
			{
				mResult=false;
				mReader.Close();
			}
			return (mResult);
		}


		//装入书签
		private bool LoadBookMarks()
		{
			bool mResult=false;
			SqlDataReader mReader ;
			
			string strSelectCmd = "select b.BookMarkName,b.BookMarkText from Template_BookMarks a,BookMarks b where a.BookMarkname=b.BookMarkName and a.RecordID='"+ mTemplate +"'";
			SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
			mReader = mCommand.ExecuteReader(CommandBehavior.CloseConnection);
			if(mReader.Read())
			{
				//说明：我们测试程序把SQL语句直接写到替换标签内容
				//实际使用中，这个标签内容是通过Sql语句得到的。
				//生成SQL查询语句  result.getString("BookMarkText") & "条件"
				//当前纪录号位 mRecordID
				//BookMarkValue=生成SQL运行结果
				string mBookMarkName=mReader["BookMarkName"].ToString() ;
				string mBookMarkValue=mReader["BookMarkText"].ToString() ;
				MsgObj.SetMsgByName(mBookMarkName,mBookMarkValue);
				mResult=true;
				mReader.Close();
			}
				
			else
			{
				mResult=false;
				mReader.Close();
			}
			
			return (mResult);
		}

		//保存书签
		private bool SaveBookMarks()
		{
			bool mResult=false;

			string mBookMarkName;
			int mIndex;
			
				string strDeleteCmd = "DELETE FROM Template_BookMarks Where RecordID='"+ mTemplate+"'";
				SqlCommand nCommand = new SqlCommand(strDeleteCmd,DBAobj.GetConn());//更改
				nCommand.ExecuteNonQuery();
			    DBAobj.DataBaseClose();

			    ArrayList al =new ArrayList();
			for (mIndex=6;mIndex<=MsgObj.GetFieldCount()-1;mIndex++)
			{
					
				mBookMarkName=MsgObj.GetFieldName(mIndex);
				string strInsertCmd = "insert into Template_BookMarks (RecordId,BookMarkName) values ('"+ mTemplate +"','"+ mBookMarkName +"')";
				al.Add(strInsertCmd);
			}
			if (DBAobj.ExecuteTransaction(al))
			{
				//					SqlCommand mCommand = new SqlCommand(strInsertCmd,DBAobj.GetConn());//更改
				//					mCommand.ExecuteNonQuery(); 
	
				mResult=true;
			}
			
			else
			{
				mResult=false;
			}
			return (mResult);
		}

		//取得签名列表
		private bool LoadMarkList()
		{
			bool mResult=false;
			SqlDataReader mReader;
			
			mMarkList="";
			string strSelectCmd = "SELECT MarkName FROM Signature";
			SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
			mReader = mCommand.ExecuteReader(CommandBehavior.CloseConnection);
			if(mReader.FieldCount>0)
			{
				while(mReader.Read())
				{
					mMarkList+=mReader["MarkName"].ToString() +"\r\n";
				}
				
				mResult=true;
				mReader.Close();
			}
			
				
			else
			{
				mResult=false;
				mReader.Close();
			}
		
			
			return (mResult);
		
		}

		//调入签名纪录
		private bool LoadMarkImage(string vMarkName,string vPassWord)
		{
			bool mResult=false;
			
			string strSelectCmd="SELECT MarkBody,MarkType FROM Signature WHERE MarkName='" + vMarkName + "' and PassWord='" + vPassWord + "'";
			SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
			SqlDataReader mReader;
			mReader = mCommand.ExecuteReader(CommandBehavior.CloseConnection);
			if (mReader.Read())
			{
				mFileBody=mReader.GetSqlBinary(0).Value; 
				mFileType=mReader.GetString(1).ToString();  
				mResult=true;
				mReader.Close();
			}
			else
			{
				mResult=false;
				mReader.Close();
			}
			return (mResult);
		}

		//保存签名
		private bool SaveSignature()
		{
			bool mResult=false;
			SqlCommand nCommand;
			string strInsertCmd;

			strInsertCmd="insert into Document_Signature ([RecordID],[MarkName],[UserName],[DateTime],[HostName],[MarkGuid]) values (@RecordID,@MarkName,@UserName,@DateTime,@HostName,@MarkGuid) ";
			nCommand = new SqlCommand(strInsertCmd, DBAobj.GetConn());//更改

			
			nCommand.Parameters.Add(new SqlParameter("@RecordID", SqlDbType.VarChar,16)); 
			nCommand.Parameters["@RecordID"].Value = mRecordID;

				
			nCommand.Parameters.Add(new SqlParameter("@MarkName",SqlDbType.VarChar,64)); 
			nCommand.Parameters["@MarkName"].Value = mMarkName;

				
			nCommand.Parameters.Add(new SqlParameter("@UserName",SqlDbType.VarChar,32)); 
			nCommand.Parameters["@UserName"].Value = mUserName;
				
				
			nCommand.Parameters.Add(new SqlParameter("@DateTime",SqlDbType.DateTime)); 
			nCommand.Parameters["@DateTime"].Value = mDateTime;
				
				
			nCommand.Parameters.Add(new SqlParameter("@HostName",SqlDbType.VarChar,64)); 
			nCommand.Parameters["@HostName"].Value = mHostName;
				
				
			nCommand.Parameters.Add(new SqlParameter("@MarkGuid",SqlDbType.VarChar,64)); 
			nCommand.Parameters["@MarkGuid"].Value = mMarkGuid;
			if(	nCommand.ExecuteNonQuery()==1)
			{
				DBAobj.DataBaseClose();
				mResult=true;
			}
			else
			{
				DBAobj.DataBaseClose();
				mResult=false;
			}
			return (mResult);
		}


		//列出所有签名
		private bool LoadSignature()
		{
			bool mResult=false;

			
			mMarkName="印章名称\r\n";
			mUserName="签名人\r\n";
			mDateTime="签章时间\r\n";
			mHostName="客户端IP\r\n";
			mMarkGuid="序列号\r\n";

			string strSelectCmd="SELECT [MarkName],[UserName],[DateTime],[HostName],[MarkGuid] FROM Document_Signature WHERE RecordID='" + mRecordID + "'";
			SqlCommand mCommand = new SqlCommand(strSelectCmd,DBAobj.GetConn());//更改
			SqlDataReader mReader ;
			
			mReader=mCommand.ExecuteReader(CommandBehavior.CloseConnection);
			if(mReader.FieldCount>0)
			{
				while(mReader.Read())
				{
					mMarkName+=mReader["MarkName"].ToString()+"\r\n";                  		     //文件号列表
					mUserName+=mReader["UserName"].ToString()+"\r\n";                           //日期列表
					mDateTime+=mReader.GetDateTime(2).ToString("yyyy-MM-dd HH:mm:ss")+"\r\n";                           //用户名列表
					mHostName+=mReader["HostName"].ToString()+"\r\n";                           //如果说明信息里有回车，则将回车变成>符号
					mMarkGuid+=mReader["MarkGuid"].ToString()+"\r\n";
				}	
			mReader.Close();
				mResult=true;
			}
	
			else
			{
				mResult=false;
				mReader.Close();
			}
			return (mResult);
		}

		//调出所对应的文本 
		private bool LoadContent()
		{
			bool mResult=false;
			//打开数据库
			//根据 mRecordID 或 mFileName 等信息
			//提取文本信息付给mContent即可。
			//本演示假设取得的文本信息如下：

			mContent="";
			mContent+="本文的纪录号："+mRecordID+"\n";
			mContent+="本文的文件名："+mFileName+"\n";
			mContent+="    这个部分请自己加入，和你们的数据库结合起来就可以了\n";
			mResult=true;
			return (mResult);
		}

		//保存所对应的文本 
		private bool SaveContent()
		{
			bool mResult=false;
			//打开数据库
			//根据 mRecordID 或 mFileName 等信息
			//插入文本信息 mContent里的文本到数据库中即可。
			mResult=true;
			return (mResult);
		}

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