b_unit_info.cs

很不错的公文流转系统

				for(int i=0;i<oSqlParameter.Length;i++)
				{
					msg+="参数名:"+oSqlParameter[i].ParameterName+" 参数类型:"+oSqlParameter[i].DbType.ToString()+" 参数值:"+oSqlParameter[i].Value+" 参数方向:"+oSqlParameter[i].Direction.ToString()+"\n\r";
				}
				throw new AppException("执行下列存储过程出错：Addb_unit_info,传递的参数如下：\n\r"+msg,e);
			}
			
			if(returnvalue!=0)
				return false;
			UnitID=oSqlParameter[9].Value.ToString();
			return true;
		}
		/// <summary>
		/// 修改
		/// </summary>
		/// <returns></returns>
		public bool Editb_unit_info(string Linkphone  ,string Operateman  ,string UnitRank,string UnitAddress  ,string UnitManager   ,string UnitLinkman   ,string UnitName ,string ShortName  ,string UnitID)
		{
			UnitID=OI.Modules.String.GenSafeChars(UnitID);
			Linkphone=OI.Modules.String.GenSafeChars(Linkphone);
			Operateman=OI.Modules.String.GenSafeChars(Operateman);
			UnitRank=OI.Modules.String.GenSafeChars(UnitRank);
			UnitAddress=OI.Modules.String.GenSafeChars(UnitAddress);
			UnitManager=OI.Modules.String.GenSafeChars(UnitManager);
			UnitLinkman=OI.Modules.String.GenSafeChars(UnitLinkman);
			UnitName=OI.Modules.String.GenSafeChars(UnitName);
			ShortName=OI.Modules.String.GenSafeChars(ShortName);


			string sql="update b_unit_info set "+
				"Linkphone='"+Linkphone+"'"+
				",Operateman='"+Operateman+"'"+
				",UnitRank='"+UnitRank+"'"+
				",UnitAddress='"+UnitAddress+"'"+
				",UnitManager='"+UnitManager+"'"+
				",UnitLinkman='"+UnitLinkman+"'"+
				",UnitName='"+UnitName+"'"+
				",ShortName='"+ShortName+"'"+
				" where UnitID='"+UnitID+"'";		
			int rowsAffected;
			try
			{
				this.RunCommand(sql,out rowsAffected);
			}
			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(rowsAffected<1)
				return false;
			return true;
		}
		/// <summary>
		/// 删除单位信息
		/// </summary>
		/// <param name="UnitID">单位ID</param>
		/// <returns>成功或失败</returns>
		public bool Deleteb_unit_info(string UnitID)
		{

			UnitID=OI.Modules.String.GenSafeChars(UnitID);
			string sql="delete from b_unit_info  "+				
				" where UnitID='"+UnitID+"'";		
			int rowsAffected;
			try
			{
				this.RunCommand(sql,out rowsAffected);
			}
			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(rowsAffected<1)
				return false;
			return true;
		}
		/// <summary>
		/// 获取当前的元素
		/// </summary>
		/// <returns>返回元素类</returns>
		public IEnumerator GetEnumerator()
		{
			return new b_unit_info(this);
		}


		public bool Disponse()
		{
			if(this.oDataSet!=null)
			{
				this.oDataSet.Clear();
				this.oDataSet.Dispose();  
			}
			
			return true;
		}
		
		//内含的类
		/// <summary>
		/// 内含的类
		/// </summary>
		public class b_unit_info:OI.Data.DbObject,IEnumerator
		{

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

			string cUnitID;

			string cUnitName;

			string cShortName;

			string cUnitAddress;

			string cUnitManager;

			string cUnitLinkman;

			string cLinkphone;

			string cOperateman;

			string cUnitRank;

			//以下代码为类:b_unit_info的属性变量
			/// <summary>
			/// 属性:
			/// </summary>
			public string UnitID
			{
				get
				{
					return cUnitID;
				}
				set
				{
					cUnitID=value;
				}
			}
			/// <summary>
			/// 属性:
			/// </summary>
			public string UnitName
			{
				get
				{
					return cUnitName;
				}
				set
				{
					cUnitName=value;
				}
			}
			/// <summary>
			/// 属性:
			/// </summary>
			public string ShortName
			{
				get
				{
					return cShortName;
				}
				set
				{
					cShortName=value;
				}
			}
			/// <summary>
			/// 属性:
			/// </summary>
			public string UnitAddress
			{
				get
				{
					return cUnitAddress;
				}
				set
				{
					cUnitAddress=value;
				}
			}
			/// <summary>
			/// 属性:
			/// </summary>
			public string UnitManager
			{
				get
				{
					return cUnitManager;
				}
				set
				{
					cUnitManager=value;
				}
			}
			/// <summary>
			/// 属性:
			/// </summary>
			public string UnitLinkman
			{
				get
				{
					return cUnitLinkman;
				}
				set
				{
					cUnitLinkman=value;
				}
			}
			/// <summary>
			/// 属性:
			/// </summary>
			public string Linkphone
			{
				get
				{
					return cLinkphone;
				}
				set
				{
					cLinkphone=value;
				}
			}
			/// <summary>
			/// 属性:
			/// </summary>
			public string Operateman
			{
				get
				{
					return cOperateman;
				}
				set
				{
					cOperateman=value;
				}
			}
			/// <summary>
			/// 属性:
			/// </summary>
			public string UnitRank
			{
				get
				{
					return cUnitRank;
				}
				set
				{
					cUnitRank=value;
				}
			}
			/// <summary>
			/// 获取数据集
			/// </summary>
			/// <returns>成功或失败</returns>
			private void SetData()
			{
				this.oobjs.GetData();
			}
			/// <summary>
			/// 根据索引字段查询单一的元素，不能与foreach共同使用
			/// </summary>
			/// <param name="UnitID"></param>
			/// <returns>查到/没有查到</returns>
			public bool Search(string UnitID)
			{
				UnitID=OI.Modules.String.GenSafeChars(UnitID);
				string sql="Select  UnitID,UnitName,ShortName,UnitAddress,UnitManager,UnitLinkman,Linkphone,Operateman,UnitRank From b_unit_info where UnitID='"+UnitID.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())
				{
					//以下代码为类:b_unit_info的属性变量
					if (!oDataReader.IsDBNull(0))
					{
						cUnitID=oDataReader.GetString(0);
					}
					if (!oDataReader.IsDBNull(1))
					{
						cUnitName=oDataReader.GetString(1);
					}
					if (!oDataReader.IsDBNull(2))
					{
						cShortName=oDataReader.GetString(2);
					}
					if (!oDataReader.IsDBNull(3))
					{
						cUnitAddress=oDataReader.GetString(3);
					}
					if (!oDataReader.IsDBNull(4))
					{
						cUnitManager=oDataReader.GetString(4);
					}
					if (!oDataReader.IsDBNull(5))
					{
						cUnitLinkman=oDataReader.GetString(5);
					}
					if (!oDataReader.IsDBNull(6))
					{
						cLinkphone=oDataReader.GetString(6);
					}
					if (!oDataReader.IsDBNull(7))
					{
						cOperateman=oDataReader.GetString(7);
					}
					if (!oDataReader.IsDBNull(8))
					{
						cUnitRank=oDataReader.GetString(8);
					}
					oDataReader.Close();
					if(this.Connection.State==System.Data.ConnectionState.Open)
						this.Connection.Close();
					return true;
				}
				else
				{
					oDataReader.Close();
					if(this.Connection.State==System.Data.ConnectionState.Open)
						this.Connection.Close();
					return false;
				}
			}
			private b_unit_infos oobjs;       //构造函数
			/// <summary>
			/// 从容器类中构造
			/// </summary>
			/// <param name="toobjs"></param>
			public b_unit_info(b_unit_infos toobjs)
			{
				oobjs=toobjs;
             
			}
			/// <summary>
			/// 单独使用类
			/// </summary>
			public b_unit_info()
			{
				
			}
		
			/// <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;
					}
				}
				//以下代码为类:b_unit_info的属性变量
				try
				{
					cUnitID=System.Convert.ToString(oobjs.oDataSet.Tables["b_unit_info"].Rows[oobjs.nCurrentRecordNum][0]);
				}
				catch
				{

					
					cUnitID="";
				}
				try
				{
					cUnitName=System.Convert.ToString(oobjs.oDataSet.Tables["b_unit_info"].Rows[oobjs.nCurrentRecordNum][1]);
				}
				catch
				{

					
					cUnitName="";
				}
				try
				{
					cShortName=System.Convert.ToString(oobjs.oDataSet.Tables["b_unit_info"].Rows[oobjs.nCurrentRecordNum][2]);
				}
				catch
				{

					
					cShortName="";
				}
				try
				{
					cUnitAddress=System.Convert.ToString(oobjs.oDataSet.Tables["b_unit_info"].Rows[oobjs.nCurrentRecordNum][3]);
				}
				catch
				{

					
					cUnitAddress="";
				}
				try
				{
					cUnitManager=System.Convert.ToString(oobjs.oDataSet.Tables["b_unit_info"].Rows[oobjs.nCurrentRecordNum][4]);
				}
				catch
				{

					
					cUnitManager="";
				}
				try
				{
					cUnitLinkman=System.Convert.ToString(oobjs.oDataSet.Tables["b_unit_info"].Rows[oobjs.nCurrentRecordNum][5]);
				}
				catch
				{

					
					cUnitLinkman="";
				}
				try
				{
					cLinkphone=System.Convert.ToString(oobjs.oDataSet.Tables["b_unit_info"].Rows[oobjs.nCurrentRecordNum][6]);
				}
				catch
				{

					
					cLinkphone="";
				}
				try
				{
					cOperateman=System.Convert.ToString(oobjs.oDataSet.Tables["b_unit_info"].Rows[oobjs.nCurrentRecordNum][7]);
				}
				catch
				{

					
					cOperateman="";
				}
				try
				{
					cUnitRank=System.Convert.ToString(oobjs.oDataSet.Tables["b_unit_info"].Rows[oobjs.nCurrentRecordNum][8]);
				}
				catch
				{

					
					cUnitRank="";
				}
				oobjs.nCurrentRecordNum++;
				return true;
			}
			/// <summary>
			/// 复位
			/// </summary>
			public  void Reset()
			{
			}

		
		}
	}

}