document.cs

很不错的公文流转系统

		}
		/// <summary>
		/// 从项目中获取数据
		/// </summary>
		/// <returns>成功/失败</returns>
		public void GetData()
		{   
			if(oDataSet !=null)				
				oDataSet.Clear();	
			string sqlFilter=this.GenSqlFilter();
			string calculateCmdString="SELECT count(DocumentID) FROM VIEW_DOCUMENT"+sqlFilter;
			string sql="SELECT DocumentID, SecretGreadID, DocumentTypeID, ExigenceDegreeID, "+
				"DocumentHead, DocumentNumber, Title, MainSendComp, CopySendComp, "+
				"DraftDepartment, SendDepartment, TopicWord, Content, Range, CurrentStepID, "+
				"CurrentStepName, CompleteSign, UserID, SendDate, StreamID, StapleSign, "+
				"DeleteSign, ExigenceDegreeName, UserName, DocumentTypeName, "+
				"SecretGreadName, IshaveAccessories "+
				"FROM VIEW_DOCUMENT"+sqlFilter;//在此写入Sql查询语句
			try
			{
				oDataSet=this.RunCommand(calculateCmdString,sql,"Document");//在此写入表名
			}
			catch(System.Data.SqlClient.SqlException e)
			{
				if(this.Connection.State==System.Data.ConnectionState.Open)
					this.Connection.Close();
				throw new AppException("执行下列语句出错：\n\r"+sql,e);
			}         
		}
		/// <summary>
		/// 查询关键字
		///在以下项目中查询:d
		///文头、文号、标题、主送单位、抄送单位、拟稿单位、发文单位、主题词、
		/// </summary>
		public string SearchKey
		{
			get
			{
				return cSearchKey;
			}
			set
			{
				cSearchKey=OI.Modules.String.GenSafeChars(value);
			}
		}
		/// <summary>
		/// 获取查询后的数据XML格式字符串
		/// </summary>
		/// <returns>成功或失败</returns>
		public string GetDataXml()
		{
			if(this.oDataSet==null)
				GetData();
			return oDataSet.GetXml() ;
		}
		
		/// <summary>
		/// 增加
		/// </summary>
		/// <returns></returns>
		public bool AddDocument(int Range,int UserID,int StreamID,int ExigenceDegreeID,int CurrentStepID,int SecretGreadID,int DocumentTypeID,string Content,string SendDepartment,string TopicWord,string CurrentStepName,string MainSendComp,string CopySendComp,string DraftDepartment,string DocumentHead,string DocumentNumber,string Title) 
		{

			//Range=OI.Modules.String.GenSafeChars(Range);
			//Range:是否更新在外网：0－－内网     1－－外网

			Content=OI.Modules.String.GenSafeChars(Content);
			SendDepartment=OI.Modules.String.GenSafeChars(SendDepartment);
			TopicWord=OI.Modules.String.GenSafeChars(TopicWord);
			CurrentStepName=OI.Modules.String.GenSafeChars(CurrentStepName);
			MainSendComp=OI.Modules.String.GenSafeChars(MainSendComp);
			CopySendComp=OI.Modules.String.GenSafeChars(CopySendComp);
			DraftDepartment=OI.Modules.String.GenSafeChars(DraftDepartment);
			DocumentHead=OI.Modules.String.GenSafeChars(DocumentHead);
			DocumentNumber=OI.Modules.String.GenSafeChars(DocumentNumber);
			Title=OI.Modules.String.GenSafeChars(Title);
			
			
			string sql="INSERT INTO Document(SecretGreadID,DocumentTypeID,ExigenceDegreeID,DocumentHead,DocumentNumber,Title,MainSendComp,CopySendComp,DraftDepartment,SendDepartment,TopicWord,Content,"+
				"Range,CurrentStepID,CurrentStepName,UserID,SendDate,StreamID)"+
				" VALUES('"+SecretGreadID+"','"+DocumentTypeID+"','"+ExigenceDegreeID+"','"+DocumentHead+
				"','"+DocumentNumber+"','"+Title+"','"+MainSendComp+"','"+CopySendComp+"','"+DraftDepartment+
				"','"+SendDepartment+"','"+TopicWord+"','"+Content+"','"+Range+"','"+CurrentStepID+"','"+CurrentStepName+
				"','"+UserID+"','"+DateTime.Now +"','"+StreamID+"')";
			int i=0;
			try
			{
				this.RunCommand(sql,out i);
			}
			catch(System.Data.SqlClient.SqlException e)
			{
				if(this.Connection.State==System.Data.ConnectionState.Open)
					this.Connection.Close();
				throw new AppException("执行下列Sql语句出错\n\r"+sql,e);
			}
			if(i>0)
				return true;
			return false;
		}
		/// <summary>
		/// 修改
		/// </summary>
		/// <returns></returns>
		public bool EditDocument()
		{
			return true;
		}
		/// <summary>
		/// 删除
		/// </summary>
		/// <returns></returns>
		public bool DeleteDocument()
		{


			return true;
		}
		/// <summary>
		/// 获取当前的元素
		/// </summary>
		/// <returns>返回元素类</returns>
		public IEnumerator GetEnumerator()
		{
			return new Document(this);
		}
		public bool Disponse()
		{
			if(this.oDataSet!=null)
			{
				this.oDataSet.Clear();
				this.oDataSet.Dispose();  
			}

			return true;
		}
		
		//内含的类
		/// <summary>
		/// 内含的类
		/// </summary>
		public class Document:OI.Data.DbObject,IEnumerator
		{



			//============================以下代码为类:Document的属性变量

			int nDocumentID;

			int nSecretGreadID;

			int nDocumentTypeID;

			int nExigenceDegreeID;

			string cDocumentHead;

			string cDocumentNumber;

			string cTitle;

			string cMainSendComp;

			string cCopySendComp;

			string cDraftDepartment;

			string cSendDepartment;

			string cTopicWord;

			string cContent;

			bool range;

			int nCurrentStepID;

			string cCurrentStepName;

			int nCompleteSign;

			int nUserID;

			DateTime dSendDate;

			int nStreamID;

			bool stapleSign;

			bool deleteSign;

			string exigenceDegreeName, userName, documentTypeName, secretGreadName;
			bool ishaveAccessories;

			//以下代码为类:Document的属性变量
			public string ExigenceDegreeName
			{
				get
				{
					return this.exigenceDegreeName;
				}
				set
				{
					this.exigenceDegreeName=value;
				}
			}
			public string  UserName
			{
				get
				{
					return this.userName;
				}
				set
				{
					this.userName=value;
				}
			}
			public string  DocumentTypeName
			{
				get
				{
					return this.documentTypeName;
				}
				set
				{
					this.documentTypeName=value;
				}
			}
			public string  SecretGreadName
			{
				get
				{
					return this.secretGreadName;
				}
				set
				{
					this.secretGreadName=value;
				}
			}
			public bool IshaveAccessories
			{
				get
				{
					return this.ishaveAccessories;
				}
				set
				{
					this.ishaveAccessories=value;
				}
			}
			/// <summary>
			/// 属性:文档ID
			/// </summary>
			public int DocumentID
			{
				get
				{
					return nDocumentID;
				}
				set
				{
					nDocumentID=value;
				}
			}
			/// <summary>
			/// 属性:秘密等级
			/// </summary>
			public int SecretGreadID
			{
				get
				{
					return nSecretGreadID;
				}
				set
				{
					nSecretGreadID=value;
				}
			}
			/// <summary>
			/// 属性:公文类别
			/// </summary>
			public int DocumentTypeID
			{
				get
				{
					return nDocumentTypeID;
				}
				set
				{
					nDocumentTypeID=value;
				}
			}
			/// <summary>
			/// 属性:紧急程度
			/// </summary>
			public int ExigenceDegreeID
			{
				get
				{
					return nExigenceDegreeID;
				}
				set
				{
					nExigenceDegreeID=value;
				}
			}
			/// <summary>
			/// 属性:文头
			/// </summary>
			public string DocumentHead
			{
				get
				{
					return cDocumentHead;
				}
				set
				{
					cDocumentHead=value;
				}
			}
			/// <summary>
			/// 属性:文号
			/// </summary>
			public string DocumentNumber
			{
				get
				{
					return cDocumentNumber;
				}
				set
				{
					cDocumentNumber=value;
				}
			}
			/// <summary>
			/// 属性:标题
			/// </summary>
			public string Title
			{
				get
				{
					return cTitle;
				}
				set
				{
					cTitle=value;
				}
			}
			/// <summary>
			/// 属性:主送单位
			/// </summary>
			public string MainSendComp
			{
				get
				{
					return cMainSendComp;
				}
				set
				{
					cMainSendComp=value;
				}
			}
			/// <summary>
			/// 属性:抄送单位
			/// </summary>
			public string CopySendComp
			{
				get
				{
					return cCopySendComp;
				}
				set
				{
					cCopySendComp=value;
				}
			}
			/// <summary>
			/// 属性:拟稿单位
			/// </summary>
			public string DraftDepartment
			{
				get
				{
					return cDraftDepartment;
				}
				set
				{
					cDraftDepartment=value;
				}
			}
			/// <summary>
			/// 属性:发文单位
			/// </summary>
			public string SendDepartment
			{
				get
				{
					return cSendDepartment;
				}
				set
				{
					cSendDepartment=value;
				}
			}
			/// <summary>
			/// 属性:主题词
			/// </summary>
			public string TopicWord
			{
				get
				{
					return cTopicWord;
				}
				set
				{
					cTopicWord=value;
				}
			}
			/// <summary>
			/// 属性:正文
			/// </summary>
			public string Content
			{
				get
				{
					return cContent;
				}
				set
				{
					cContent=value;
				}
			}
			/// <summary>
			/// 属性:范围标识
			/// </summary>
			public bool Range
			{
				get
				{
					return range;
				}
				set
				{
					range=value;
				}
			}
			/// <summary>
			/// 属性:当前节点ID
			/// </summary>
			public int CurrentStepID
			{
				get
				{
					return nCurrentStepID;
				}
				set
				{
					nCurrentStepID=value;
				}
			}
			/// <summary>
			/// 属性:当前节点名称
			/// </summary>
			public string CurrentStepName
			{
				get
				{
					return cCurrentStepName;
				}
				set
				{
					cCurrentStepName=value;
				}
			}
			/// <summary>
			/// 属性:流程结束标识，0为进行中，1为完成
			/// </summary>
			public int CompleteSign
			{
				get
				{
					return nCompleteSign;
				}
				set
				{
					nCompleteSign=value;
				}
			}
			/// <summary>
			/// 属性:用户ID
			/// </summary>
			public int UserID
			{
				get
				{
					return nUserID;
				}
				set
				{
					nUserID=value;
				}
			}
			/// <summary>
			/// 属性:提交日期
			/// </summary>
			public System.DateTime SendDate
			{
				get
				{
					return dSendDate;
				}
				set
				{
					dSendDate=value;
				}
			}
			/// <summary>
			/// 属性:流程ID
			/// </summary>
			public int StreamID
			{
				get
				{
					return nStreamID;
				}
				set
				{
					nStreamID=value;
				}
			}
			/// <summary>
			/// 属性:归档标识
			/// </summary>
			public bool StapleSign
			{
				get