documentflow.cs

自动化办公系统

			/// 获得用户所有的项目
			/// </summary>
			/// <param name="UserName">用户名</param>
			/// <param name="dt">返回表格</param>
			public int GetProject(string UserName,out SqlDataReader dr )
			{
				//int iReturn=0;
				dr = null;
				UDS.Components.Database mySQL = new UDS.Components.Database();
				SqlParameter[] parameters = {
												mySQL.MakeInParam("@UserName",SqlDbType.VarChar ,300,UserName)
											};
			
				try
				{
					mySQL.RunProc("sp_GetTaskClass",parameters,out dr);							
				}
				catch(Exception e)
				{
					Error.Log(e.ToString());					
				}
				finally
				{
					//mySQL.Close();
					//mySQL = null;	
				}
				return 0;
			}		
		#endregion

		#region 获得文档的批注,返回记录集
		/// <summary>
		/// 获得流程的表格样式描述
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dr">返回表格</param>
		public int GetDocumentPostil(long DocID,out SqlDataReader dr )
		{
			//int iReturn=-1;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetDocumentPostil",parameters,out dr);		
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				dr = null;
			}
			finally
			{
				//mySQL.Close();
				//mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 获得文档的批注,返回表格
		/// <summary>
		/// 获得流程的表格样式描述
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dt">返回表格</param>
		public int GetDocumentPostil(long DocID,out DataTable dt )
		{
			//int iReturn=-1;
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetDocumentPostil",parameters,out dr);		
				dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				dt = null;
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 获得文档的信息实体,返回记录集
		/// <summary>
		/// 获得流程的表格样式描述
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dr">返回记录集</param>
		public int GetDocumentInfo(long DocID,out SqlDataReader dr )
		{
			//int iReturn=-1;
			//SqlDataReader dd;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			try
			{
				mySQL.RunProc("sp_Flow_GetDocumentInfo",parameters,out dr);						
			}
			catch(Exception e)
			{
				dr = null;
				Error.Log(e.ToString());
			}
			finally
			{
				//mySQL.Close();
				//mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 获得文档的信息实体,返回表格
		/// <summary>
		/// 获得流程的表格样式描述
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dr">返回表格</param>
		public int GetDocumentInfo(long DocID,out DataTable dt )
		{
			//int iReturn=-1;
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			try
			{
				mySQL.RunProc("sp_Flow_GetDocumentInfo",parameters,out dr);						
				dt =UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
			}
			catch(Exception e)
			{
				dt = null;
				Error.Log(e.ToString());
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return 0;
		}		
		#endregion

		

		#region 获得步骤成员,返回表格
		/// <summary>
		/// 获得环节成员,返回表格
		/// </summary>
		/// <param name="FlowID">流程ID</param>
		/// <param name="StepID">步骤ID</param>
		/// <param name="dt">返回表格</param>
		public int GetStaffInStep(long FlowID,long StepID,out DataTable dt )
		{
			//int iReturn=-1;
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)											
											
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetStaffInStep",parameters,out dr);		
				dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				dt = null;
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 获得步骤成员,返回表格
		/// <summary>
		/// 获得环节成员,返回表格
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dt">返回表格</param>
		public int GetStaffInStep(long DocID,out DataTable dt )
		{
			//int iReturn=-1;
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)																						
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetStaffInStep_Ex",parameters,out dr);		
				dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				dt = null;
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 获得步骤接受人员,返回表格
		/// <summary>
		/// 获得步骤接受人员,返回表格
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dt">返回表格</param>
		public int GetReceiver(long DocID,out DataTable dt )
		{
			//int iReturn=-1;
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetReceiver",parameters,out dr);		
				dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				dt = null;
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 获得步骤已经签收人员,返回表格
		/// <summary>
		/// 获得步骤已经签收人员,返回表格
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dt">返回表格</param>
		public int GetSignIner(long DocID,out DataTable dt )
		{
			//int iReturn=-1;
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetSignIner",parameters,out dr);		
				dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				dt = null;
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 获得步骤未签收人员,返回表格
		/// <summary>
		/// 获得步骤未签收人员,返回表格
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dt">返回表格</param>
		public int GetUnSignIner(long DocID,out DataTable dt )
		{
			//int iReturn=-1;
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetUnSignIner",parameters,out dr);		
				dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				dt = null;
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 获得步骤已经批阅人员,返回表格
		/// <summary>
		/// 获得步骤已经批阅人员,返回表格
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dt">返回表格</param>
		public int GetPostiler(long DocID,out DataTable dt )
		{
			//int iReturn=-1;
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetPostiler",parameters,out dr);		
				dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				dt = null;
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 获得流程头信息,返回表格
		/// <summary获得流程头信息
		/// 获得环节已经批阅人员,返回表格
		/// </summary>
		/// <param name="FlowID">流程ID</param>
		/// <param name="dt">返回表格</param>
		public string GetStyleHeadline(long FlowID)
		{
			string str="";
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetStyleHead",parameters,out dr);		
				if(dr.Read())
				{
					str = dr["Flow_Name"].ToString() + "(流水号:" + string.Format(dr["Times"].ToString(),"03d") + ")";
				}
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return str;
		}		
		#endregion			

		#region 获得文档的附件,返回表格
		/// <summary>
		/// 获得文档的附件,返回表格
		/// </summary>
		/// <param name="DocID">文档ID</param>
		/// <param name="dt">返回表格</param>
		public int GetDocumentAttach(long DocID,out DataTable dt)
		{			
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetDocumentAttach",parameters,out dr);		

				dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				throw new Exception("获得公文的附件出错！",e);
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return 0;
		}		
		#endregion			

		#region 添加公文附件数据库
		/// <summary>
		/// 添加文件附件数据库操作
		/// </summary>
		/// <param name="att">DocAttachFile类</param>
		/// <param name="DocID">文件ID</param>
		public void AddAttach(UDS.Components.DocAttachFile att,long DocID) 
		{		
			
			UDS.Components.Database data = new UDS.Components.Database();	
			SqlParameter[] prams = {
									   data.MakeInParam("@DocID",  SqlDbType.Int, 20, DocID),
									   data.MakeInParam("@FileName",  SqlDbType.VarChar, 300, att.FileName),
									   data.MakeInParam("@FileSize",  SqlDbType.Int, 20, att.FileSize),
									   data.MakeInParam("@FileAttribute",  SqlDbType.SmallInt,20, att.FileAttribute),
									   data.MakeInParam("@FileVisualPath",  SqlDbType.NVarChar, 200, att.FileVisualPath),
									   data.MakeInParam("@FileAuthor",  SqlDbType.NVarChar, 50, att.FileAuthor),
									   data.MakeInParam("@FileCatlog",  SqlDbType.NVarChar, 20, att.FileCatlog),
									   data.MakeInParam("@FileAddedDate", SqlDbType.DateTime, 30, DateTime.Parse(att.FileAddedDate))
								   };
			try 
			{
				data.RunProc("sp_Flow_AddFile", prams);
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				throw new Exception("文件附件发送出错!",ex);
			}
			
		}
		#endregion

		#region 删除公文附件数据库
		/// <summary>
		/// 删除文件附件数据库操作
		/// </summary>
		/// <param name="DocID">文件ID</param>
		public void DeleteAttach(long DocID) 
		{		
			
			UDS.Components.Database data = new UDS.Components.Database();	
			SqlParameter[] prams = {
									   data.MakeInParam("@DocID",  SqlDbType.Int, 20, DocID)
								   };
			try 
			{
				data.RunProc("sp_Flow_DeleteFile", prams);
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());