documentflow.cs

自动化办公系统

				throw new Exception("文件附件删除出错!",ex);
			}			
		}
		#endregion

		#region 获得公文附件名
		/// <summary>
		/// 获得公文附件名
		/// </summary>
		/// <param name="DocID">文件ID</param>
		public string GetAttachName(long DocID) 
		{		
			
			string AttachName="";

			UDS.Components.Database data = new UDS.Components.Database();	
			SqlDataReader dr = null;
			
			SqlParameter[] prams = {
									   data.MakeInParam("@DocID",  SqlDbType.Int, 20, DocID)
								   };
			try 
			{
				data.RunProc("sp_Flow_GetDocumentAttach", prams,out dr);
				if(dr.Read())
					AttachName = dr["FileVisualPath"].ToString() + dr["FileName"].ToString();
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				throw new Exception("获得文件附出错!",ex);
			}			
			finally
			{
				dr.Close();
				dr	= null;
				data = null;
			}
			return AttachName;
		}
		#endregion

		#region 添加公文批注附件数据库
		/// <summary>
		/// 添加文件批注附件数据库操作
		/// </summary>
		/// <param name="att">DocAttachFile类</param>
		/// <param name="DocID">文件ID</param>
		public void AddPostilAttach(UDS.Components.DocAttachFile att,long PostilID) 
		{		
			
			UDS.Components.Database data = new UDS.Components.Database();	
			SqlParameter[] prams = {
									   data.MakeInParam("@PostilID",  SqlDbType.Int, 20, PostilID),
									   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_AddPostilFile", prams);
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				throw new Exception("文件附件发送出错!",ex);
			}
			
		}
		#endregion

		#region 获得文档的所在项目ID
		/// <summary>
		/// 获得文档的所在项目ID
		/// </summary>
		/// <param name="DocID">文档ID</param>
		public static int GetDocumentProjectID(long DocID)
		{			
			int iReturn=0;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			
			try
			{
				iReturn = mySQL.RunProc("sp_Flow_GetDocumentProjectID",parameters);		

			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				throw new Exception("获得公文的项目ID出错！",e);
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return iReturn;
		}		
		#endregion			

		#region 获得是否按照项目流转
		/// <summary>
		/// 获得是否按照项目流转ID
		/// </summary>
		/// <param name="UserName">用户名</param>
		/// <param name="DocID">文档ID</param>
		public bool IsProject(string UserName,long DocID)
		{			
			bool iReturn = false;
			SqlDataReader dr;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@StaffName",SqlDbType.VarChar,100,UserName),
											mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetPrePostInfo",parameters,out dr);		
				if(dr.Read())
				{
					if(dr["Flow_Rule"].ToString()=="2")
						iReturn = true;
				}

				dr.Close();
				dr = null;

			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				throw new Exception("获得是否按照项目流转出错！",e);
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return iReturn;
		}		
		#endregion			

		/////////////////////////////////////////////
		///				流程自定义表单
		/////////////////////////////////////////////

		#region 添加自定义风格表格
		/// <summary>
		/// 添加自定义风格表格
		/// </summary>
		/// <param name="StyleName">风格名</param>
		/// <param name="StyleRemark">简介ID</param>
		/// <param name="Teamplate">模板路径</param>
		public int AddStyle(string StyleName,string StyleRemark,string Teamplate)
		{

			int iReturn=-1;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@StyleName",SqlDbType.VarChar,100,StyleName),
											mySQL.MakeInParam("@StyleRemark",SqlDbType.VarChar,100,StyleRemark),
											mySQL.MakeInParam("@Teamplate",SqlDbType.VarChar,100,Teamplate)
										};
			try
			{
				iReturn = mySQL.RunProc("sp_Flow_AddStyle",parameters);		
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return iReturn;

		}
		#endregion

		#region 删除自定义风格表格
		/// <summary>
		/// 删除自定义风格表格
		/// </summary>
		/// <param name="StyleID">风格ID</param>
		public int DeleteStyle(long StyleID,string Path)
		{

			int iReturn=-1;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@StyleID",SqlDbType.Int,4,StyleID)
										};
			try
			{
				DeleteTemplate(StyleID,Path);		//删除模板实体
				iReturn = mySQL.RunProc("sp_Flow_DeleteStyle",parameters);						
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return iReturn;

		}
		#endregion

		#region 修改自定义风格表格
		/// <summary>
		/// 修改自定义风格表格
		/// </summary>
		/// <param name="StyleID">风格ID</param>
		/// <param name="StyleName">风格名</param>
		/// <param name="StyleRemark">简介ID</param>
		/// <param name="Teamplate">模板路径</param>
		public int UpdateStyle(long StyleID,string StyleName,string StyleRemark,string Teamplate,string Path)
		{

			int iReturn=-1;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@StyleID",SqlDbType.Int,4,StyleID),
											mySQL.MakeInParam("@StyleName",SqlDbType.VarChar,100,StyleName),
											mySQL.MakeInParam("@StyleRemark",SqlDbType.VarChar,100,StyleRemark),
											mySQL.MakeInParam("@Teamplate",SqlDbType.VarChar,100,Teamplate)
										};
			try
			{
				DeleteTemplate(StyleID,Path);
				iReturn = mySQL.RunProc("sp_Flow_UpdateStyle",parameters);		
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return iReturn;

		}
		#endregion

		#region 添加自定义风格详细定义
		/// <summary>
		/// 添加自定义风格详细定义
		/// </summary>
		/// <param name="StyleID">风格表格ID</param>
		/// <param name="FieldName">帮定字段名</param>
		/// <param name="FieldDescription">字段意义</param>
		/// <param name="Judged">是否作为条件判断字段</param>
		/// <param name="MultiLine">是否多行</param>
		/// <param name="Height">控件高度</param>
		/// <param name="Width">控件宽</param>
		/// <param name="Position">控件在表单中的位置</param>
		/// <param name="Example">填表示例</param>

		public int AddStyleDescription(long StyleID,string FieldName,string FieldDescription,int Judged,int MultiLine,int Height,int Width,int Position,string Example)
		{

			int iReturn=-1;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@StyleID",SqlDbType.Int,4,StyleID),
											mySQL.MakeInParam("@FieldName",SqlDbType.VarChar,100,FieldName),
											mySQL.MakeInParam("@FieldDescription",SqlDbType.VarChar,100,FieldDescription),
											mySQL.MakeInParam("@Judged",SqlDbType.Int,4,Judged),
											mySQL.MakeInParam("@MultiLine",SqlDbType.Int,4,MultiLine),
											mySQL.MakeInParam("@Height",SqlDbType.Int,4,Height),
											mySQL.MakeInParam("@Width",SqlDbType.Int,4,Width),
											mySQL.MakeInParam("@Position",SqlDbType.Int,4,Position),
											mySQL.MakeInParam("@Example",SqlDbType.VarChar,100,Example)

										};
			try
			{
				iReturn = mySQL.RunProc("sp_Flow_AddStyle_Description",parameters);		
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return iReturn;

		}
		#endregion		

		#region 删除自定义风格表格详细定义
		/// <summary>
		/// 删除自定义风格表格详细定义，一行定义表示一个控件
		/// </summary>
		/// <param name="DescriptionID">风格详细定义ID</param>
		public int DeleteStyleDescription(long DescriptionID)
		{

			int iReturn=-1;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DescriptionID",SqlDbType.Int,4,DescriptionID)
										};
			try
			{
				iReturn = mySQL.RunProc("sp_Flow_DeleteStyle_Description",parameters);		
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return iReturn;

		}
		#endregion

		#region 修改自定义风格详细定义
		/// <summary>
		/// 修改自定义风格详细定义
		/// </summary>
		/// <param name="DescriptionID">风格详细定义ID</param>
		/// <param name="StyleID">风格表格ID</param>
		/// <param name="FieldName">帮定字段名</param>
		/// <param name="FieldDescription">字段意义</param>
		/// <param name="Judged">是否作为条件判断字段</param>
		/// <param name="MultiLine">是否多行</param>
		/// <param name="Height">控件高度</param>
		/// <param name="Width">控件宽</param>
		/// <param name="Position">控件在表单中的位置</param>
		/// <param name="Example">填表示例</param>

		public int UpdateStyleDescription(long DescriptionID,long StyleID,string FieldName,string FieldDescription,int Judged,int MultiLine,int Height,int Width,int Position,string Example)
		{

			int iReturn=-1;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DescriptionID",SqlDbType.Int,4,DescriptionID),
											mySQL.MakeInParam("@StyleID",SqlDbType.Int,4,StyleID),
											mySQL.MakeInParam("@FieldName",SqlDbType.VarChar,100,FieldName),
											mySQL.MakeInParam("@FieldDescription",SqlDbType.VarChar,100,FieldDescription),
											mySQL.MakeInParam("@Judged",SqlDbType.Int,4,Judged),
											mySQL.MakeInParam("@MultiLine",SqlDbType.Int,4,MultiLine),
											mySQL.MakeInParam("@Height",SqlDbType.Int,4,Height),
											mySQL.MakeInParam("@Width",SqlDbType.Int,4,Width),
											mySQL.MakeInParam("@Position",SqlDbType.Int,4,Position),
											mySQL.MakeInParam("@Example",SqlDbType.VarChar,100,Example)

										};
			try
			{
				iReturn = mySQL.RunProc("sp_Flow_UpdateStyle_Description",parameters);		
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			return iReturn;

		}
		#endregion

		#region 获得自定义风格表格一条详细定义
		/// <summary>
		/// 获得单一样式描述
		/// </summary>
		/// <param name="StyleID">流程ID</param>
		/// <param name="dr">数据集合</param>
		public int GetDescription(long DescriptionID,out SqlDataReader dr )
		{
			//int iReturn=-1;
			dr = null;
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@DescriptionID",SqlDbType.Int ,4,DescriptionID)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetDescription",parameters,out dr);		
			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				
			}
			finally
			{
				//mySQL.Close();
				//mySQL = null;	
			}
			return 0;
		}		
		#endregion

		#region 通过流程ID得到流程模板名
		/// <summary>
		/// 通过流程ID得到流程模板名
		/// </summary>
		/// <param name="FlowID">流程ID</param>
		public string GetStyleTemplate(long FlowID)
		{
			string str="";
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeOutParam("@Template",SqlDbType.VarChar,100)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetStyleTemplate",parameters);		
				str = parameters[1].Value.ToString();
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				throw new Exception("获得表格模板错误!",e);
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			
			if(str.Length>0)
				return @"Template\" + str;
			else
				return "";
		}
		#endregion

		#region 通过表单ID得到流程模板名
		/// <summary>
		/// 通过表单ID得到流程模板名
		/// </summary>
		/// <param name="FlowID">流程ID</param>
		public string GetStyleTemplateEx(long StyleID)
		{
			string str="";
			UDS.Components.Database mySQL = new UDS.Components.Database();
			SqlParameter[] parameters = {
											mySQL.MakeInParam("@StyleID",SqlDbType.Int ,4,StyleID),
											mySQL.MakeOutParam("@Template",SqlDbType.VarChar,100)
										};
			
			try
			{
				mySQL.RunProc("sp_Flow_GetStyleTemplateEx",parameters);		
				str = parameters[1].Value.ToString();
			}
			catch(Exception e)
			{
				Error.Log(e.ToString());
				throw new Exception("获得表格模板错误!",e);
			}
			finally
			{
				mySQL.Close();
				mySQL = null;	
			}
			
			if(str.Length>0)
				return @"Template\" + str;