nodetype.cs

很不错的公文流转系统

//设计人:陈仕欣     日期:2003-11-27
//v1.0     修改日期:2003-11-27
 /// <summary>
 /// 枚举类：NodeTypes
 /// 集合元素类：NodeType
 /// </summary>
 /// <example>
 /// <code>
 /// NodeTypes oFileList=new NodeTypes()
 /// foreach(NodeTypes.NodeType in oFileList)
 /// {
 /// }
 /// </code>
 /// <code>
 /// NodeTypes.NodeType  oFileList=new
 /// </code>
 /// </example> 
 using System; 
 using System.Collections;
 using OI.Modules;
 namespace OI.Data
 {
	 public class NodeTypes :OI.Data.DbObject,IEnumerable
	 {
     
		 private int nCurrentRecordNum;
		 private string cSearchKey;


		 private string cNodeTypeID="";
		 private string cNodeTypeName="";

		 /// <summary>
		 /// 设置过滤条件:
		 /// </summary>
		 public string NodeTypeID
		 {
			 get
			 {
				 return cNodeTypeID;
			 }
			 set
			 {
				 cNodeTypeID=OI.Modules.String.GenSafeChars(value);;
			 }
		 }
		 /// <summary>
		 /// 设置过滤条件:
		 /// </summary>
		 public string NodeTypeName
		 {
			 get
			 {
				 return cNodeTypeName;
			 }
			 set
			 {
				 cNodeTypeName=OI.Modules.String.GenSafeChars(value);;
			 }
		 }
		 System.Data.DataSet oDataSet;
	
		 /// <summary>
		 /// 当前的记录
		 /// </summary>
		 public int CurrentRecordNum
		 {
			 get
			 {
				 return nCurrentRecordNum;
			 }
			 set
			 {
				 nCurrentRecordNum=value;
			 }
		 }

       
		 /// <summary>
		 /// 组织查询条件
		 /// </summary>
		 /// <returns>查询字符串</returns>
		 private string GenSqlFilter()
		 {
			 string cSql="";
			 if(this.cNodeTypeID!="")
			 {
				 if(cSql!="")
					 cSql=cSql+" and NodeTypeID ='"+this.cNodeTypeID+"' " ;
				 else
					 cSql=cSql+" where NodeTypeID ='"+this.cNodeTypeID+"' " ;
			 }
			 if(this.cNodeTypeName!="")
			 {
				 if(cSql!="")
					 cSql=cSql+" and NodeTypeName ='"+this.cNodeTypeName+"' " ;
				 else
					 cSql=cSql+" where NodeTypeName ='"+this.cNodeTypeName+"' " ;
			 }
		
			 if(cSearchKey!=null&&cSearchKey!="")  
			 {
				 if(cSql!="")
					 cSql=cSql+" And ( NodeTypeName  like '%"+cSearchKey+"%')";
				 else
					 cSql=cSql+" Where ( NodeTypeName  like '%"+cSearchKey+"%')";
			 }
			 return cSql;       }
		 public void GetData()
		 {   
			 if(oDataSet !=null)				
				 oDataSet.Clear();	
			 string sqlFilter=this.GenSqlFilter();
			 string calculateCmdString="Select  count(NodeTypeID) From NodeType"+sqlFilter;//在此写入查询总记录数Sql查询语句
			 string sql="Select  NodeTypeID,NodeTypeName,Description From NodeType"+sqlFilter;//在此写入Sql查询语句
			 try
			 {
				 oDataSet=this.RunCommand(calculateCmdString,sql,"NodeType");//在此写入表名
			 }
			 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>
		 /// 查询关键字
		 ///在以下项目中查询:
		 ///、
		 /// </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>
		 public NodeTypes()
		 {
		
		 }
		 /// <summary>
		 /// 构造函数
		 /// </summary>
		 /// <param name="Share_Sql_Connection">共享的数据库连接</param>
		 public NodeTypes(string newConnectionString):base( newConnectionString)
		 {
		
		 }
		 /// <summary>
		 /// 增加
		 /// </summary>
		 /// <returns></returns>
		 public bool AddNodeType()
		 {
			 return true;
		 }
		 /// <summary>
		 /// 修改
		 /// </summary>
		 /// <returns></returns>
		 public bool EditNodeType()
		 {

			 return true;
		 }
		 /// <summary>
		 /// 删除
		 /// </summary>
		 /// <returns></returns>
		 public bool DeleteNodeType()
		 {

			 return true;
		 }
		 /// <summary>
		 /// 获取当前的元素
		 /// </summary>
		 /// <returns>返回元素类</returns>
		 public IEnumerator GetEnumerator()
		 {
			 return new NodeType(this);
		 }
		 public bool Disponse()
		 {
			 if(this.oDataSet!=null)
			 {
				 this.oDataSet.Clear();
				 this.oDataSet.Dispose();  
			 }
		
			 return true;
		 }
	
		 //内含的类
		 /// <summary>
		 /// 内含的类
		 /// </summary>
		 public class NodeType:OI.Data.DbObject,IEnumerator
		 {
		
		
		

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

			 int nNodeTypeID;

			 string cNodeTypeName;

			 string cDescription;

			 //以下代码为类:NodeType的属性变量
			 /// <summary>
			 /// 属性:
			 /// </summary>
			 public int NodeTypeID
			 {
				 get
				 {
					 return nNodeTypeID;
				 }
				 set
				 {
					 nNodeTypeID=value;
				 }
			 }
			 /// <summary>
			 /// 属性:
			 /// </summary>
			 public string NodeTypeName
			 {
				 get
				 {
					 return cNodeTypeName;
				 }
				 set
				 {
					 cNodeTypeName=value;
				 }
			 }
			 /// <summary>
			 /// 属性:
			 /// </summary>
			 public string Description
			 {
				 get
				 {
					 return cDescription;
				 }
				 set
				 {
					 cDescription=value;
				 }
			 }
			 /// <summary>
			 /// 获取数据集
			 /// </summary>
			 /// <returns>成功或失败</returns>
			 private void SetData()
			 {
				 this.oobjs.GetData();
			 }
			 /// <summary>
			 /// 根据索引字段查询单一的元素，不能与foreach共同使用
			 /// </summary>
			 /// <param name="id"></param>
			 /// <returns>查到/没有查到</returns>
			 public bool Search(int NodeTypeID)
			 {
			
				 string sql="Select  NodeTypeID,NodeTypeName,Description From NodeType where NodeTypeID='"+NodeTypeID.ToString()+"'";//在此填写你的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())
				 {
					 //以下代码为类:NodeType的属性变量
					 if (!oDataReader.IsDBNull(0))
					 {
						 nNodeTypeID=oDataReader.GetInt32(0);
					 }
					 if (!oDataReader.IsDBNull(1))
					 {
						 cNodeTypeName=oDataReader.GetString(1);
					 }
					 if (!oDataReader.IsDBNull(2))
					 {
						 cDescription=oDataReader.GetString(2);
					 }
					 oDataReader.Close();
					 return true;
				 }
				 else
				 {
					 oDataReader.Close();
					 return false;
				 }
			 }
			 private NodeTypes oobjs;       //构造函数
			 /// <summary>
			 /// 从容器类中构造
			 /// </summary>
			 /// <param name="toobjs"></param>
			 public NodeType(NodeTypes toobjs)
			 {
				 oobjs=toobjs;
             
			 }
			 /// <summary>
			 /// 单独使用类
			 /// </summary>
			 public NodeType()
			 {
			
			 }
			 /// <summary>
			 /// 单独使用，用已有的数据库连接
			 /// </summary>
			 public NodeType(string newConnectionString) :base( newConnectionString)
			 {
			
			 }
			 /// <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;
					 }
				 }
				 //以下代码为类:NodeType的属性变量
				 try
				 {
					 nNodeTypeID=System.Convert.ToInt32(oobjs.oDataSet.Tables["NodeType"].Rows[oobjs.nCurrentRecordNum][0]);
				 }
				 catch(System.Exception ErrorExcept_Property_0)
				 {

					 ErrorLog.WriteLog(ErrorExcept_Property_0.Message);
					 nNodeTypeID=0;
				 }
				 try
				 {
					 cNodeTypeName=System.Convert.ToString(oobjs.oDataSet.Tables["NodeType"].Rows[oobjs.nCurrentRecordNum][1]);
				 }
				 catch(System.Exception ErrorExcept_Property_1)
				 {

					 ErrorLog.WriteLog(ErrorExcept_Property_1.Message);
					 cNodeTypeName="";
				 }
				 try
				 {
					 cDescription=System.Convert.ToString(oobjs.oDataSet.Tables["NodeType"].Rows[oobjs.nCurrentRecordNum][2]);
				 }
				 catch(System.Exception ErrorExcept_Property_2)
				 {

					 ErrorLog.WriteLog(ErrorExcept_Property_2.Message);
					 cDescription="";
				 }
				 oobjs.nCurrentRecordNum++;
				 return true;
			 }
			 /// <summary>
			 /// 复位
			 /// </summary>
			 public  void Reset()
			 {
			 }
		
		
		 }
	 }
 }