documenttransacts.cs

很不错的公文流转系统

		/// 获取当前的元素
		/// </summary>
		/// <returns>返回元素类</returns>
		public IEnumerator GetEnumerator()
		{
			return new DocumentTransact(this);
		}

		public bool Disponse()
		{
			if(this.oDataSet!=null)
			{
				this.oDataSet.Clear();
				this.oDataSet.Dispose();  
			}			
			return true;
		}
		
		//内含的类
		/// <summary>
		/// 内含的类
		/// </summary>
		public class DocumentTransact:OI.Data.DbObject,IEnumerator
		{
		
			//============================以下代码为类:DocumentTransact的属性变量

			int nStepID;

			int nManageID;

			int nDocumentID;

			int nUserID;

			int nTransactSign;

			string cIdea;

			DateTime dReadDate;

			DateTime dTransactDate;

			DateTime dTransactLimitDate;

			//以下代码为类:DocumentTransact的属性变量
			/// <summary>
			/// 属性:工作流节点ID
			/// </summary>
			public int StepID
			{
				get
				{
					return nStepID;
				}
				set
				{
					nStepID=value;
				}
			}
			/// <summary>
			/// 属性:操作类型ID,如同意，不同意等
			/// </summary>
			public int ManageID
			{
				get
				{
					return nManageID;
				}
				set
				{
					nManageID=value;
				}
			}
			/// <summary>
			/// 属性:文档ID
			/// </summary>
			public int DocumentID
			{
				get
				{
					return nDocumentID;
				}
				set
				{
					nDocumentID=value;
				}
			}
			/// <summary>
			/// 属性:用户ID
			/// </summary>
			public int UserID
			{
				get
				{
					return nUserID;
				}
				set
				{
					nUserID=value;
				}
			}
			/// <summary>
			/// 属性:办理标识,0为未阅，1为已阅，2为已办
			/// </summary>
			public int TransactSign
			{
				get
				{
					return nTransactSign;
				}
				set
				{
					nTransactSign=value;
				}
			}
			/// <summary>
			/// 属性:意见
			/// </summary>
			public string Idea
			{
				get
				{
					return cIdea;
				}
				set
				{
					cIdea=value;
				}
			}
			/// <summary>
			/// 属性:阅读日期
			/// </summary>
			public System.DateTime ReadDate
			{
				get
				{
					return dReadDate;
				}
				set
				{
					dReadDate=value;
				}
			}
			/// <summary>
			/// 属性:办理日期
			/// </summary>
			public System.DateTime TransactDate
			{
				get
				{
					return dTransactDate;
				}
				set
				{
					dTransactDate=value;
				}
			}
			/// <summary>
			/// 属性:办理期限
			/// </summary>
			public System.DateTime TransactLimitDate
			{
				get
				{
					return dTransactLimitDate;
				}
				set
				{
					dTransactLimitDate=value;
				}
			}
			/// <summary>
			/// 获取数据集
			/// </summary>
			/// <returns>成功或失败</returns>
			private void SetData()
			{
				this.oobjs.GetData();
			}
			/// <summary>
			/// 根据索引字段查询单一的元素，不能与foreach共同使用
			/// </summary>
			/// <param name="id"></param>
			/// <returns>查到/没有查到</returns>
			public bool Search(string cId)
			{
				cId=OI.Modules.String.GenSafeChars(cId);
				string sql="select * from ddd where id='"+cId+"'";//在此填写你的Sql语句
				System.Data.SqlClient.SqlDataReader oDataReader;
				try
				{
					oDataReader=this.RunCommand(sql);
				}
				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(oDataReader.Read())
				{
					//以下代码为类:DocumentTransact的属性变量
					if (!oDataReader.IsDBNull(0))
					{
						nStepID=oDataReader.GetInt32(0);
					}
					if (!oDataReader.IsDBNull(1))
					{
						nManageID=oDataReader.GetInt32(1);
					}
					if (!oDataReader.IsDBNull(2))
					{
						nDocumentID=oDataReader.GetInt32(2);
					}
					if (!oDataReader.IsDBNull(3))
					{
						nUserID=oDataReader.GetInt32(3);
					}
					if (!oDataReader.IsDBNull(4))
					{
						nTransactSign=oDataReader.GetInt32(4);
					}
					if (!oDataReader.IsDBNull(5))
					{
						cIdea=oDataReader.GetString(5);
					}
					if (!oDataReader.IsDBNull(6))
					{
						dReadDate=oDataReader.GetDateTime(6);
					}
					if (!oDataReader.IsDBNull(7))
					{
						dTransactDate=oDataReader.GetDateTime(7);
					}
					if (!oDataReader.IsDBNull(8))
					{
						dTransactLimitDate=oDataReader.GetDateTime(8);
					}
					oDataReader.Close();
					return true;
				}
				else
				{
					oDataReader.Close();
					return false;
				}
			}
			private DocumentTransacts oobjs;       //构造函数
			/// <summary>
			/// 从容器类中构造
			/// </summary>
			/// <param name="toobjs"></param>
			public DocumentTransact(DocumentTransacts toobjs)
			{
				oobjs=toobjs;
             
			}
			/// <summary>
			/// 单独使用类
			/// </summary>
			public DocumentTransact()
			{				
			}
			/// <summary>
			/// 单独使用，用已有的数据库连接
			/// </summary>
			public DocumentTransact(string strConnection):base(strConnection)
			{				
			}
			/// <summary>
			/// 获取当前的对象
			/// </summary>
			object IEnumerator.Current
			{
				get
				{
					return this;
				}
			}
			/// <summary>
			/// 下一个对象
			/// </summary>
			/// <returns>有或无</returns>
			public bool MoveNext()
			{
				if(oobjs.oDataSet==null)
				{
					SetData();
					if(oobjs.nCurrentRecordNum<0)
						oobjs.nCurrentRecordNum=0;
				}
				if(oobjs.PageSize>0) 
				{
					if(oobjs.nCurrentRecordNum+(oobjs.PageNum-1)*oobjs.PageSize>=oobjs.RecordCount||oobjs.CurrentRecordNum>oobjs.PageSize-1)
					{
						this.oobjs.CurrentRecordNum=0; 
						return false;
					}
				}
				else
				{
					if(oobjs.nCurrentRecordNum>=oobjs.RecordCount)
					{
						this.oobjs.CurrentRecordNum=0; 
						return false;
					}
				}
				//以下代码为类:DocumentTransact的属性变量
				try
				{
					nStepID=System.Convert.ToInt32(oobjs.oDataSet.Tables["DocumentTransact"].Rows[oobjs.nCurrentRecordNum][0]);
				}
				catch(System.Exception ErrorExcept_Property_0)
				{

					ErrorLog.WriteLog(ErrorExcept_Property_0.Message);
					nStepID=0;
				}
				try
				{
					nManageID=System.Convert.ToInt32(oobjs.oDataSet.Tables["DocumentTransact"].Rows[oobjs.nCurrentRecordNum][1]);
				}
				catch(System.Exception ErrorExcept_Property_1)
				{

					ErrorLog.WriteLog(ErrorExcept_Property_1.Message);
					nManageID=0;
				}
				try
				{
					nDocumentID=System.Convert.ToInt32(oobjs.oDataSet.Tables["DocumentTransact"].Rows[oobjs.nCurrentRecordNum][2]);
				}
				catch(System.Exception ErrorExcept_Property_2)
				{

					ErrorLog.WriteLog(ErrorExcept_Property_2.Message);
					nDocumentID=0;
				}
				try
				{
					nUserID=System.Convert.ToInt32(oobjs.oDataSet.Tables["DocumentTransact"].Rows[oobjs.nCurrentRecordNum][3]);
				}
				catch(System.Exception ErrorExcept_Property_3)
				{

					ErrorLog.WriteLog(ErrorExcept_Property_3.Message);
					nUserID=0;
				}
				try
				{
					nTransactSign=System.Convert.ToInt32(oobjs.oDataSet.Tables["DocumentTransact"].Rows[oobjs.nCurrentRecordNum][4]);
				}
				catch(System.Exception ErrorExcept_Property_4)
				{

					ErrorLog.WriteLog(ErrorExcept_Property_4.Message);
					nTransactSign=0;
				}
				try
				{
					cIdea=System.Convert.ToString(oobjs.oDataSet.Tables["DocumentTransact"].Rows[oobjs.nCurrentRecordNum][5]);
				}
				catch(System.Exception ErrorExcept_Property_5)
				{

					ErrorLog.WriteLog(ErrorExcept_Property_5.Message);
					cIdea="";
				}
				try
				{
					dReadDate=System.Convert.ToDateTime(oobjs.oDataSet.Tables["DocumentTransact"].Rows[oobjs.nCurrentRecordNum][6]);
				}
				catch(System.Exception ErrorExcept_Property_6)
				{

					ErrorLog.WriteLog(ErrorExcept_Property_6.Message);
					dReadDate=DateTime.MinValue ;
				}
				try
				{
					dTransactDate=System.Convert.ToDateTime(oobjs.oDataSet.Tables["DocumentTransact"].Rows[oobjs.nCurrentRecordNum][7]);
				}
				catch(System.Exception ErrorExcept_Property_7)
				{

					ErrorLog.WriteLog(ErrorExcept_Property_7.Message);
					dTransactDate=DateTime.MinValue ;
				}
				try
				{
					dTransactLimitDate=System.Convert.ToDateTime(oobjs.oDataSet.Tables["DocumentTransact"].Rows[oobjs.nCurrentRecordNum][8]);
				}
				catch(System.Exception ErrorExcept_Property_8)
				{

					ErrorLog.WriteLog(ErrorExcept_Property_8.Message);
					dTransactLimitDate=DateTime.MinValue ;
				}
				oobjs.nCurrentRecordNum++;
				return true;
			}
			/// <summary>
			/// 复位
			/// </summary>
			public  void Reset()
			{
			}			
		}
	}
}