collections.cs

客户关系管理系统ASP.NET+VB.NET编程完整程序！

//------------------------------------------------------------------------------
// <autogenerated>
//     This code was generated by a tool.
//
//     Changes to this file may cause incorrect behavior and will be lost if 
//     the code is regenerated.
// </autogenerated>
//------------------------------------------------------------------------------
using System;
using System.Collections;
using System.Reflection;
using System.Data.SqlTypes;
using System.Globalization;
using System.ComponentModel;

using OrmLib;

namespace ORMBiz
{

		/// <summary>
		///	Holds a collection of Columns that can be searched and enumerated.
		/// </summary>
		[OrmLib.TypedCollection(typeof(Column))]
		public abstract class ColumnCollectionOrmTemplate : CollectionTemplate
		{
			public ColumnCollectionOrmTemplate() : base(typeof(Column)){}

			public Column this[int index]
			{
				get
				{
					return (Column)List[index];
				}
				set
				{
					throw new NotSupportedException("Please use the Add() method."); 
				} 
			}	

			/// <summary>
			/// Filter by the provided property name
			/// </summary>
			/// <param name="property">The property to filter on</param>
			/// <param name="searchValue">The value to search for</param>
			/// <returns>A collection of Columns</returns>
			public ColumnCollection FilterBy( string property, object searchValue )
			{
				return FilterBy(property, searchValue, CompareType.Exact);
			}

			/// <summary>
			/// Filter by the provided property name
			/// </summary>
			/// <param name="property">The property to filter on</param>
			/// <param name="searchValue">The value to search for</param>
			/// <param name="comparer">How to compare the property to the search value</param>
			/// <returns>A collection of Columns</returns>
			public ColumnCollection FilterBy( string property, object searchValue, CompareType comparer )
			{
				ColumnCollection retCollection = new ColumnCollection();
				
				foreach( Column _Column in List)
				{
					if ( Match(comparer,_Column[property] , searchValue) ) 
						retCollection.Add( _Column );
				}
			
				return retCollection;
			}

			/// <summary>
			/// Returns a sorted collection based on the supplied property name.
			/// </summary>
			/// <param name="property">The property to sort by</param>
			/// <returns></returns>
			public ColumnCollection SortBy( string property )
			{
				return SortBy( property, SortDirection.Ascending );
			}

			/// <summary>
			/// Returns a sorted collection based on the supplied property name.
			/// </summary>
			/// <param name="property">The property to sort by</param>
			/// <param name="sortDirection"></param>
			/// <returns></returns>
			public ColumnCollection SortBy( string property, SortDirection sortDirection )
			{
				InnerList.Sort( new OrmLib.ObjectPropertyComparer(property));
				if (sortDirection == SortDirection.Descending) InnerList.Reverse();
				return (ColumnCollection)this;
			}

		
			/// <summary>
			/// Find the first in the collection, based on the
			/// supplied property.
			/// </summary>
			/// <param name="property">The property to find by</param>
			/// <param name="searchValue"></param>
			/// <returns></returns>
			public Column FindBy( string property, object searchValue )
			{
				return FindBy(property, searchValue, CompareType.Exact);
			}

			/// <summary>
			/// Find the first in the collection, based on the
			/// supplied property.
			/// </summary>
			/// <param name="property">The property to find by</param>
			/// <param name="searchValue"></param>
			/// <param name="comparer"></param>
			/// <returns></returns>
			public Column FindBy( string property, object searchValue, CompareType comparer )
			{				
				foreach( Column _Column in List)
				{
					if ( Match(comparer,_Column[property] , searchValue) ) 
						return _Column;
				}
			
				return null;
			}
			
			/// <summary>
			/// Adds a Column to the collection.
			/// </summary>
			/// <param name="newColumn">Adds a Column to the collection</param>
			public int Add( Column newColumn)
			{
				return List.Add( newColumn );
			}

		/// <summary>
		/// Find a Column by the property ID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByID( System.Int32 searchValue )
		{
			return FindByID( searchValue, CompareType.Exact );
		}
		
		/// <summary>
		/// Find a Column by the property ID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <param name="comparer">What sort of comparison should be made</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByID( System.Int32 searchValue, CompareType comparer )
		{
			foreach( Column _Column in List)
			{
				if ( Match(comparer,_Column.ID , searchValue) ) 
					return _Column;
			}
			
			return null;
		}


		/// <summary>
		/// Find a Column by the property ID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByID( string searchValue )
		{
			return FindByID( System.Int32.Parse(searchValue), CompareType.Exact );
		}
		
		/// <summary>
		/// Find a Column by the property ID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <param name="comparer">What sort of comparison should be made</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByID( string searchValue, CompareType comparer )
		{
			return FindByID( System.Int32.Parse(searchValue),comparer );
		}		/// <summary>
		/// Find a Column by the property FKTableID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByFKTableID( System.Data.SqlTypes.SqlInt32 searchValue )
		{
			return FindByFKTableID( searchValue, CompareType.Exact );
		}
		
		/// <summary>
		/// Find a Column by the property FKTableID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <param name="comparer">What sort of comparison should be made</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByFKTableID( System.Data.SqlTypes.SqlInt32 searchValue, CompareType comparer )
		{
			foreach( Column _Column in List)
			{
				if ( Match(comparer,_Column.FKTableID , searchValue) ) 
					return _Column;
			}
			
			return null;
		}


		/// <summary>
		/// Find a Column by the property FKTableID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByFKTableID( string searchValue )
		{
			return FindByFKTableID( System.Data.SqlTypes.SqlInt32.Parse(searchValue), CompareType.Exact );
		}
		
		/// <summary>
		/// Find a Column by the property FKTableID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <param name="comparer">What sort of comparison should be made</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByFKTableID( string searchValue, CompareType comparer )
		{
			return FindByFKTableID( System.Data.SqlTypes.SqlInt32.Parse(searchValue),comparer );
		}		/// <summary>
		/// Find a Column by the property Name.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByName( System.String searchValue )
		{
			return FindByName( searchValue, CompareType.Exact );
		}
		
		/// <summary>
		/// Find a Column by the property Name.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <param name="comparer">What sort of comparison should be made</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByName( System.String searchValue, CompareType comparer )
		{
			foreach( Column _Column in List)
			{
				if ( Match(comparer,_Column.Name , searchValue) ) 
					return _Column;
			}
			
			return null;
		}
		/// <summary>
		/// Find a Column by the property FKDataTypeID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByFKDataTypeID( System.Data.SqlTypes.SqlInt32 searchValue )
		{
			return FindByFKDataTypeID( searchValue, CompareType.Exact );
		}
		
		/// <summary>
		/// Find a Column by the property FKDataTypeID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <param name="comparer">What sort of comparison should be made</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByFKDataTypeID( System.Data.SqlTypes.SqlInt32 searchValue, CompareType comparer )
		{
			foreach( Column _Column in List)
			{
				if ( Match(comparer,_Column.FKDataTypeID , searchValue) ) 
					return _Column;
			}
			
			return null;
		}


		/// <summary>
		/// Find a Column by the property FKDataTypeID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByFKDataTypeID( string searchValue )
		{
			return FindByFKDataTypeID( System.Data.SqlTypes.SqlInt32.Parse(searchValue), CompareType.Exact );
		}
		
		/// <summary>
		/// Find a Column by the property FKDataTypeID.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <param name="comparer">What sort of comparison should be made</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByFKDataTypeID( string searchValue, CompareType comparer )
		{
			return FindByFKDataTypeID( System.Data.SqlTypes.SqlInt32.Parse(searchValue),comparer );
		}		/// <summary>
		/// Find a Column by the property Length.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByLength( System.Data.SqlTypes.SqlInt32 searchValue )
		{
			return FindByLength( searchValue, CompareType.Exact );
		}
		
		/// <summary>
		/// Find a Column by the property Length.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <param name="comparer">What sort of comparison should be made</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByLength( System.Data.SqlTypes.SqlInt32 searchValue, CompareType comparer )
		{
			foreach( Column _Column in List)
			{
				if ( Match(comparer,_Column.Length , searchValue) ) 
					return _Column;
			}
			
			return null;
		}


		/// <summary>
		/// Find a Column by the property Length.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByLength( string searchValue )
		{
			return FindByLength( System.Data.SqlTypes.SqlInt32.Parse(searchValue), CompareType.Exact );
		}
		
		/// <summary>
		/// Find a Column by the property Length.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <param name="comparer">What sort of comparison should be made</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByLength( string searchValue, CompareType comparer )
		{
			return FindByLength( System.Data.SqlTypes.SqlInt32.Parse(searchValue),comparer );
		}		/// <summary>
		/// Find a Column by the property PrimaryKey.
		/// returns null if not found.
		/// </summary>
		/// <param name="searchValue">The value to search for</param>
		/// <returns>An Column if found, or null</returns>
		public	Column	FindByPrimaryKey( System.String searchValue )
		{
			return FindByPrimaryKey( searchValue, CompareType.Exact );
		}
		
		/// <summary>