webdocserver.aspx.cs

很不错的公文流转系统

		/// </summary>
		/// <param name="x"></param>
		/// <param name="mClass1"></param>
		public void SaveMarkImage(byte[] x,OfficeServer mClass1)
		{
			string mMarkName=mClass1.GetFieldData("IMAGENAME");		//'取得文档名    
			string  mPassword=mClass1.GetFieldData("PASSWORD");
			string  mFileType=mClass1.GetFieldData("FileType");
			SqlConnection Conn = new SqlConnection(myConnectionString);			
			Conn.Open();			
			string Sql= "SELECT * FROM Signature WHERE MarkName='" + mMarkName + "' "+" and Departmentid="+Session["departmentidSignernature"];
			DataSet ds=new DataSet();
			 
			ds=dc.getBinding(Sql,"d");
			if (ds.Tables[0].Rows.Count>0) 
			{
				SqlCommand addEmp = new SqlCommand("UPDATE Signature set PassWord=@PassWord,MarkName=@MarkName,MarkType=@MarkType,"+
					"MarkSize=@MarkSize,MarkDate=getdate(),MarkBody=@MarkBody,MarkPath=@MarkPath,UserName=@UserName where MarkName='" + mMarkName + "' ",Conn);
				addEmp.Parameters.Add("@PassWord",SqlDbType.VarChar, 16).Value = mClass1.GetFieldData("PASSWORD");
				addEmp.Parameters.Add("@MarkName",SqlDbType.VarChar, 254).Value = mClass1.GetFieldData("IMAGENAME");
				addEmp.Parameters.Add("@MarkType",SqlDbType.VarChar, 4).Value = mClass1.GetFieldData("FileType");
				addEmp.Parameters.Add("@MarkSize",SqlDbType.Int).Value = x.Length;
				addEmp.Parameters.Add("@MarkBody",SqlDbType.Image, x.Length).Value = x;
				addEmp.Parameters.Add("@MarkPath",SqlDbType.VarChar, 128).Value =mClass1.GetFieldData("FilePath");
				addEmp.Parameters.Add("@UserName",SqlDbType.VarChar,64).Value = mClass1.GetFieldData("UserName");								
				addEmp.ExecuteNonQuery();			
			}
			else
			{
				SqlCommand addEmp = new SqlCommand("INSERT INTO Signature (PassWord,MarkName,MarkType,MarkSize,MarkDate,MarkBody,MarkPath,UserName,Departmentid) " +
					"Values(@PassWord,@MarkName,@MarkType,@MarkSize,getdate(),@MarkBody,@MarkPath,@UserName,@Departmentid)", Conn);		
				addEmp.Parameters.Add("@PassWord",SqlDbType.VarChar, 16).Value = mClass1.GetFieldData("PASSWORD");
				addEmp.Parameters.Add("@MarkName",SqlDbType.VarChar, 254).Value = mClass1.GetFieldData("IMAGENAME");
				addEmp.Parameters.Add("@MarkType",SqlDbType.VarChar, 4).Value = mClass1.GetFieldData("FileType");
				addEmp.Parameters.Add("@MarkSize",SqlDbType.Int).Value = x.Length;
				addEmp.Parameters.Add("@MarkBody",SqlDbType.Image, x.Length).Value = x;
				addEmp.Parameters.Add("@MarkPath",SqlDbType.VarChar, 128).Value =mClass1.GetFieldData("FilePath");
				addEmp.Parameters.Add("@UserName",SqlDbType.VarChar,64).Value = Session["userid"];
				addEmp.Parameters.Add("@Departmentid",SqlDbType.Int).Value = Session["departmentidSignernature"];
				
				//mClass1.GetFieldData("UserName");										
				addEmp.ExecuteNonQuery();

			}
			Conn.Close();

		}
		/// <summary>
		/// 保存文档版本
		/// </summary>
		/// <param name="x"></param>
		/// <param name="mClass1"></param>
		public void SaveVersion(byte[] x,OfficeServer mClass1)
		{
			string mRecordID=mClass1.GetFieldData("RECORDID");		//取得文档编号
			SqlConnection Conn = new SqlConnection(myConnectionString);
			
			Conn.Open();			
			SqlCommand addEmp = new SqlCommand("INSERT INTO Document_File (RECORDID,FileName,FileType,FileSize,FileDate,FileBody,FilePath,UserName,Descript) " +
				"Values(@RECORDID,@FileName,@FileType,@FileSize,getdate(),@FileBody,@FilePath,@UserName,@Descript)", Conn);		
			addEmp.Parameters.Add("@RECORDID",SqlDbType.VarChar, 16).Value = mClass1.GetFieldData("RECORDID");
			addEmp.Parameters.Add("@FileName",SqlDbType.VarChar, 254).Value = mClass1.GetFieldData("FileName");
			addEmp.Parameters.Add("@FileType",SqlDbType.VarChar, 4).Value = mClass1.GetFieldData("FileType");
			addEmp.Parameters.Add("@FileSize",SqlDbType.Int).Value = x.Length;
			addEmp.Parameters.Add("@FileBody",SqlDbType.Image, x.Length).Value = x;
			addEmp.Parameters.Add("@FilePath",SqlDbType.VarChar, 128).Value =mClass1.GetFieldData("FilePath");
			addEmp.Parameters.Add("@UserName",SqlDbType.VarChar,64).Value = mClass1.GetFieldData("UserName");
			addEmp.Parameters.Add("@Descript",SqlDbType.VarChar, 255).Value = mClass1.GetFieldData("Descript");							
			addEmp.ExecuteNonQuery();
			Conn.Close();
		}
		/// <summary>
		/// 文档版本列表
		/// </summary>
		/// <param name="mClass1"></param>
		public void ListVersion(OfficeServer mClass1)
		{
			string mRecordID=mClass1.GetFieldData("RECORDID");		//取得文档编号
			string Sql= "SELECT FileID,FileDate,UserName,Descript FROM Document_File WHERE RecordID='" + mRecordID + "'";
			DataSet ds=new DataSet();
			 
			ds=dc.getBinding(Sql,"d");
			mClass1.ClearFields();
			for (int i=0;i<ds.Tables[0].Rows.Count;i++)
			{
				string mFileID =ds.Tables[0].Rows[i]["FileID"].ToString();			//文档号列表
				string mDateTime =ds.Tables[0].Rows[i]["FileDate"].ToString();			//'日期列表
				string mUserName = ds.Tables[0].Rows[i]["UserName"].ToString();				//'用户名列表
				string mDescript =ds.Tables[0].Rows[i]["Descript"].ToString();//'				
				mClass1.setfield( "FILEID"+i.ToString(), mFileID)  ;
				mClass1.setfield( "DATETIME"+i.ToString(), mDateTime);
				mClass1.setfield( "USERNAME"+i.ToString(),mUserName );
				mClass1.setfield("DESCRIPT"+i.ToString(), mDescript );
			}
			mClass1.setfield("ROWCOUNT", ds.Tables[0].Rows.Count.ToString() );
		}
		/// <summary>
		/// 打开文档版本
		/// </summary>
		/// <param name="mClass1"></param>
		public void loadVersion(OfficeServer mClass1)
		{
			string mRecordID=mClass1.GetFieldData("RECORDID");		//取得文档编号
			string mFileID=mClass1.GetFieldData("FILEID");			//取得版本文档号
			
			SqlConnection conn=new SqlConnection();
			conn.ConnectionString=myConnectionString;
			conn.Open();	
			SqlDataReader sdr;
			SqlCommand comm=new SqlCommand("select filebody,filesize from Document_File where FileID=" + mFileID ,conn);
			sdr=comm.ExecuteReader();
			sdr.Read();
			int m=(int)sdr.GetValue(1);
			byte[] x=new byte[m];
			sdr.GetBytes(0,0,x,0,m);
			sdr.Close();
			mClass1.SetObj(x);
			conn.Close();

		}
		/// <summary>
		/// 打开文档
		/// </summary>
		/// <param name="mClass1"></param>
		public void LoadFile(OfficeServer mClass1)
		{
			
			string mRecordID=mClass1.GetFieldData("RECORDID");		//取得文档编号
			SqlConnection conn=new SqlConnection();
			conn.ConnectionString=myConnectionString;
			conn.Open();						
			SqlDataReader sdr;
			SqlCommand comm=new SqlCommand("select filebody,filesize from Document_File where RecordID='" + mRecordID + "'",conn);
			sdr=comm.ExecuteReader();
			if (sdr.Read())
			{
				int m=(int)sdr.GetValue(1);
				byte[] x=new byte[m];
				sdr.GetBytes(0,0,x,0,m);
				mClass1.SetObj(x);
			}
			sdr.Close();
			conn.Close();
			
		}
		/// <summary>
		/// 保存文档
		/// </summary>
		/// <param name="x"></param>
		/// <param name="mClass1"></param>
		public void SaveFile(byte[] x,OfficeServer mClass1)
		{
			string mRecordID=mClass1.GetFieldData("RECORDID");		//取得文档编号
			SqlConnection Conn = new SqlConnection(myConnectionString);
			string Sql= "SELECT * FROM Document_File WHERE RecordID='" + mRecordID + "'";
			Conn.Open();
			SqlDataAdapter sda=new SqlDataAdapter(Sql,Conn);
			SqlCommandBuilder scb=new SqlCommandBuilder(sda);
			DataTable  dt=new DataTable();
			sda.Fill(dt);
			
			if (dt.Rows.Count>0)
			{
				SqlCommand addEmp = new SqlCommand("UPDATE Document_File set RECORDID=@RECORDID,FileName=@FileName,FileType=@FileType,"+
					"FileSize=@FileSize,FileDate=getdate(),FileBody=@FileBody,FilePath=@FilePath,UserName=@UserName,Descript=@Descript where RecordID='" + mRecordID + "' ",Conn);
				addEmp.Parameters.Add("@RECORDID",SqlDbType.VarChar, 16).Value = mClass1.GetFieldData("RECORDID");
				addEmp.Parameters.Add("@FileName",SqlDbType.VarChar, 254).Value = mClass1.GetFieldData("FileName");
				addEmp.Parameters.Add("@FileType",SqlDbType.VarChar, 4).Value = mClass1.GetFieldData("FileType");
				addEmp.Parameters.Add("@FileSize",SqlDbType.Int).Value = x.Length;
				addEmp.Parameters.Add("@FileBody",SqlDbType.Image, x.Length).Value = x;
				addEmp.Parameters.Add("@FilePath",SqlDbType.VarChar, 128).Value =mClass1.GetFieldData("FilePath");
				addEmp.Parameters.Add("@UserName",SqlDbType.VarChar,64).Value = mClass1.GetFieldData("UserName");
				addEmp.Parameters.Add("@Descript",SqlDbType.VarChar, 255).Value = mClass1.GetFieldData("Descript");							
				addEmp.ExecuteNonQuery();			
			}
			else
			{
				SqlCommand addEmp = new SqlCommand("INSERT INTO Document_File (RECORDID,FileName,FileType,FileSize,FileDate,FileBody,FilePath,UserName,Descript) " +
					"Values(@RECORDID,@FileName,@FileType,@FileSize,getdate(),@FileBody,@FilePath,@UserName,@Descript)", Conn);		
				addEmp.Parameters.Add("@RECORDID",SqlDbType.VarChar, 16).Value = mClass1.GetFieldData("RECORDID");
				addEmp.Parameters.Add("@FileName",SqlDbType.VarChar, 254).Value = mClass1.GetFieldData("FileName");
				addEmp.Parameters.Add("@FileType",SqlDbType.VarChar, 4).Value = mClass1.GetFieldData("FileType");
				addEmp.Parameters.Add("@FileSize",SqlDbType.Int).Value = x.Length;
				addEmp.Parameters.Add("@FileBody",SqlDbType.Image, x.Length).Value = x;
				addEmp.Parameters.Add("@FilePath",SqlDbType.VarChar, 128).Value =mClass1.GetFieldData("FilePath");
				addEmp.Parameters.Add("@UserName",SqlDbType.VarChar,64).Value = mClass1.GetFieldData("UserName");
				addEmp.Parameters.Add("@Descript",SqlDbType.VarChar, 255).Value = mClass1.GetFieldData("Descript");							
				addEmp.ExecuteNonQuery();

			}			
		
			Conn.Close();
			
			
			
		}

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