_orders.vb

EasyObjects 是ORM的典型应用的例子是学习研究的很好的范例

'===============================================================================
'  Generated From - VbNet_EasyObject_BusinessEntity.vbgen
' 
'  ** IMPORTANT  ** 
'  
'  This object is 'MustInherit' which means you need to inherit from it to be able
'  to instantiate it.  This is very easily done. You can override properties and
'  methods in your derived class, this allows you to regenerate this class at any
'  time and not worry about overwriting custom code. 
'
'  NEVER EDIT THIS FILE.
'
'  Public Class YourObject 
'      Inherits _YourObject
'
'  End Class
'
'===============================================================================

' Generated by MyGeneration Version # (1.2.0.2)

Imports System
Imports System.Data
Imports System.Data.Common
Imports System.Configuration
Imports System.Collections
Imports System.Collections.Specialized
Imports System.Xml
Imports System.IO

Imports Microsoft.Practices.EnterpriseLibrary.Data
Imports NCI.EasyObjects


#Region " Schema "

Public Class OrdersSchema
	Inherits NCI.EasyObjects.Schema

    Private Shared _entries As ArrayList
	Public Shared OrderID As New SchemaItem("OrderID", DbType.Int32, True, False, False, True, True, False)
	Public Shared CustomerID As New SchemaItem("CustomerID", DbType.StringFixedLength, SchemaItemJustify.None, 5, True, False, True, False)
	Public Shared EmployeeID As New SchemaItem("EmployeeID", DbType.Int32, False, True, False, False, True, False)
	Public Shared OrderDate As New SchemaItem("OrderDate", DbType.DateTime, False, True, False, False, False, False)
	Public Shared RequiredDate As New SchemaItem("RequiredDate", DbType.DateTime, False, True, False, False, False, False)
	Public Shared ShippedDate As New SchemaItem("ShippedDate", DbType.DateTime, False, True, False, False, False, False)
	Public Shared ShipVia As New SchemaItem("ShipVia", DbType.Int32, False, True, False, False, True, False)
	Public Shared Freight As New SchemaItem("Freight", DbType.Currency, False, True, False, False, False, True)
	Public Shared ShipName As New SchemaItem("ShipName", DbType.String, SchemaItemJustify.None, 40, True, False, False, False)
	Public Shared ShipAddress As New SchemaItem("ShipAddress", DbType.String, SchemaItemJustify.None, 60, True, False, False, False)
	Public Shared ShipCity As New SchemaItem("ShipCity", DbType.String, SchemaItemJustify.None, 15, True, False, False, False)
	Public Shared ShipRegion As New SchemaItem("ShipRegion", DbType.String, SchemaItemJustify.None, 15, True, False, False, False)
	Public Shared ShipPostalCode As New SchemaItem("ShipPostalCode", DbType.String, SchemaItemJustify.None, 10, True, False, False, False)
	Public Shared ShipCountry As New SchemaItem("ShipCountry", DbType.String, SchemaItemJustify.None, 15, True, False, False, False)

    Public Overrides ReadOnly Property SchemaEntries() As ArrayList
        Get
            If _entries Is Nothing Then
                _entries = New ArrayList()
				_entries.Add(OrdersSchema.OrderID)
				_entries.Add(OrdersSchema.CustomerID)
				_entries.Add(OrdersSchema.EmployeeID)
				_entries.Add(OrdersSchema.OrderDate)
				_entries.Add(OrdersSchema.RequiredDate)
				_entries.Add(OrdersSchema.ShippedDate)
				_entries.Add(OrdersSchema.ShipVia)
				_entries.Add(OrdersSchema.Freight)
				_entries.Add(OrdersSchema.ShipName)
				_entries.Add(OrdersSchema.ShipAddress)
				_entries.Add(OrdersSchema.ShipCity)
				_entries.Add(OrdersSchema.ShipRegion)
				_entries.Add(OrdersSchema.ShipPostalCode)
				_entries.Add(OrdersSchema.ShipCountry)
			End If
            Return _entries
        End Get
    End Property

	Public Shared ReadOnly Property HasAutoKey() As Boolean
        Get
            Return True
        End Get
    End Property

    Public Shared ReadOnly Property HasRowID() As Boolean
        Get
            Return False
        End Get
    End Property

End Class

#End Region

Public MustInherit Class _Orders
    Inherits EasyObject

    Sub New()
        Dim _schema As New OrdersSchema()
        Me.SchemaEntries = _schema.SchemaEntries
		Me.SchemaGlobal = "dbo"
    End Sub

	Public Overrides Sub FlushData()
		Me._whereClause = Nothing
		Me._aggregateClause = Nothing
		MyBase.FlushData()
	End Sub
		
	''' <summary>
	''' Loads the business object with info from the database, based on the requested primary key.
	''' </summary>
	''' <param name="OrderID"></param>
	''' <returns>A Boolean indicating success or failure of the query</returns>
	Public Function LoadByPrimaryKey(ByVal OrderID As Integer) As Boolean
		
		Select Case Me.DefaultCommandType
			Case CommandType.StoredProcedure
				Dim parameters As ListDictionary = New ListDictionary

				' Add in parameters
				parameters.Add(OrdersSchema.OrderID.FieldName, OrderID)

				Return MyBase.LoadFromSql(Me.SchemaStoredProcedureWithSeparator & "daab_GetOrders", parameters, CommandType.StoredProcedure)
				
			Case CommandType.Text
                Me.Query.ClearAll()
                Me.Where.WhereClauseReset()
				Me.Where.OrderID.Value = OrderID
				Return Me.Query.Load()

			Case Else
				Throw New ArgumentException("Invalid CommandType", "commandType")
				
		End Select
		
	End Function

    ''' <summary>
    ''' Loads all records from the table.
    ''' </summary>
    ''' <returns>A Boolean indicating success or failure of the query</returns>
    Public Function LoadAll() As Boolean
	
		Select Case Me.DefaultCommandType
		
			Case CommandType.StoredProcedure
				Dim parameters As ListDictionary = Nothing
				Return MyBase.LoadFromSql(Me.SchemaStoredProcedureWithSeparator & "daab_GetAllOrders", parameters, CommandType.StoredProcedure)
				
			Case CommandType.Text
                Me.Query.ClearAll()
                Me.Where.WhereClauseReset()
				Return Me.Query.Load()
			
			Case Else
				Throw New ArgumentException("Invalid CommandType", "commandType")
				
		End Select

    End Function

    ''' <summary>
    ''' Adds a new record to the internal table.
    ''' </summary>
	Public Overrides Sub AddNew()
		MyBase.AddNew()
		Me.ApplyDefaults()
	End Sub

	''' <summary>
	''' Apply any default values to columns
	''' </summary>
	Protected Overrides Sub ApplyDefaults()
		Me.Freight = 0
	End Sub

    Protected Overrides Function GetInsertCommand(commandType As CommandType) As DbCommand
	
		Dim dbCommand As DbCommand
		
        ' Create the Database object, using the default database service. The
        ' default database service is determined through configuration.
        Dim db As Database = GetDatabase()
	
		Select Case commandType
		
			Case CommandType.StoredProcedure
				Dim sqlCommand As String = Me.SchemaStoredProcedureWithSeparator & "daab_AddOrders"
				dbCommand = db.GetStoredProcCommand(sqlCommand)
				
				db.AddParameter(dbCommand, "OrderID", DbType.Int32, 0, ParameterDirection.Output, True, 0, 0, "OrderID", DataRowVersion.Default, Convert.DBNull)
				CreateParameters(db, dbCommand)

			Case CommandType.Text
                Me.Query.ClearAll()
				Me.Where.WhereClauseReset()
				For Each item As SchemaItem In Me.SchemaEntries
                    If Not item.IsComputed Then
                        If (item.IsAutoKey AndAlso Me.IdentityInsert) OrElse Not item.IsAutoKey Then
                            Me.Query.AddInsertColumn(item)
                        End If
                    End If
				Next
				dbCommand = Me.Query.GetInsertCommandWrapper()

				dbCommand.Parameters.Clear()
				If Me.IdentityInsert Then
					db.AddInParameter(dbCommand, "OrderID", DbType.Int32, "OrderID", DataRowVersion.Default)
				Else
					db.AddParameter(dbCommand, "OrderID", DbType.Int32, 0, ParameterDirection.Output, True, 0, 0, "OrderID", DataRowVersion.Default, Convert.DBNull)
				End If

				CreateParameters(db, dbCommand)

			Case Else
				Throw New ArgumentException("Invalid CommandType", "commandType")
				
		End Select

        Return dbCommand

    End Function

    Protected Overrides Function GetUpdateCommand(commandType As CommandType) As DbCommand
	
		Dim dbCommand As DbCommand

        ' Create the Database object, using the default database service. The
        ' default database service is determined through configuration.
        Dim db As Database = GetDatabase()
	
		Select Case commandType
		
			Case CommandType.StoredProcedure
				Dim sqlCommand As String = Me.SchemaStoredProcedureWithSeparator & "daab_UpdateOrders"
				dbCommand = db.GetStoredProcCommand(sqlCommand)
		
				db.AddInParameter(dbCommand, "OrderID", DbType.Int32, "OrderID", DataRowVersion.Current)
				CreateParameters(db, dbCommand)

			Case CommandType.Text
                Me.Query.ClearAll()
				For Each item As SchemaItem In Me.SchemaEntries
					If Not (item.IsAutoKey OrElse item.IsComputed)
						Me.Query.AddUpdateColumn(item)
					End If
				Next

				Me.Where.WhereClauseReset()
				Me.Where.OrderID.Operator = WhereParameter.Operand.Equal
				dbCommand = Me.Query.GetUpdateCommandWrapper()

				dbCommand.Parameters.Clear()
				CreateParameters(db, dbCommand)
				db.AddInParameter(dbCommand, "OrderID", DbType.Int32, "OrderID", DataRowVersion.Current)

			Case Else
				Throw New ArgumentException("Invalid CommandType", "commandType")
				
		End Select

        Return dbCommand

    End Function

    Protected Overrides Function GetDeleteCommand(commandType As CommandType) As DbCommand
	
		Dim dbCommand As DbCommand

        ' Create the Database object, using the default database service. The
        ' default database service is determined through configuration.
        Dim db As Database = GetDatabase()
	
		Select Case commandType
		
			Case CommandType.StoredProcedure
				Dim sqlCommand As String = Me.SchemaStoredProcedureWithSeparator & "daab_DeleteOrders"
				dbCommand = db.GetStoredProcCommand(sqlCommand)
		
				' Add primary key parameters
				db.AddInParameter(dbCommand, "OrderID", DbType.Int32, "OrderID", DataRowVersion.Current)

			Case CommandType.Text
                Me.Query.ClearAll()
				Me.Where.WhereClauseReset()
				Me.Where.OrderID.Operator = WhereParameter.Operand.Equal
				dbCommand = Me.Query.GetDeleteCommandWrapper()

				dbCommand.Parameters.Clear()
				db.AddInParameter(dbCommand, "OrderID", DbType.Int32, "OrderID", DataRowVersion.Current)

			Case Else
				Throw New ArgumentException("Invalid CommandType", "commandType")
				
		End Select

        Return dbCommand

    End Function

    Private Sub CreateParameters(ByVal db As Database, ByVal dbCommand As DbCommand)
		
		db.AddInParameter(dbCommand, "CustomerID", DbType.StringFixedLength, "CustomerID", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "EmployeeID", DbType.Int32, "EmployeeID", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "OrderDate", DbType.DateTime, "OrderDate", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "RequiredDate", DbType.DateTime, "RequiredDate", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "ShippedDate", DbType.DateTime, "ShippedDate", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "ShipVia", DbType.Int32, "ShipVia", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "Freight", DbType.Currency, "Freight", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "ShipName", DbType.String, "ShipName", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "ShipAddress", DbType.String, "ShipAddress", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "ShipCity", DbType.String, "ShipCity", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "ShipRegion", DbType.String, "ShipRegion", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "ShipPostalCode", DbType.String, "ShipPostalCode", DataRowVersion.Current)
		db.AddInParameter(dbCommand, "ShipCountry", DbType.String, "ShipCountry", DataRowVersion.Current)

    End Sub

#Region " Properties "

	Public Overridable Property OrderID() As Integer
        Get
			Return Me.GetInteger(OrdersSchema.OrderID.FieldName)
      End Get
        Set(ByVal Value As Integer)
			Me.SetInteger(OrdersSchema.OrderID.FieldName, Value)
      End Set
    End Property

	Public Overridable Property CustomerID() As String
        Get
			Return Me.GetString(OrdersSchema.CustomerID.FieldName)
      End Get
        Set(ByVal Value As String)
			Me.SetString(OrdersSchema.CustomerID.FieldName, Value)
      End Set
    End Property

	Public Overridable Property EmployeeID() As Integer
        Get
			Return Me.GetInteger(OrdersSchema.EmployeeID.FieldName)
      End Get
        Set(ByVal Value As Integer)
			Me.SetInteger(OrdersSchema.EmployeeID.FieldName, Value)
      End Set
    End Property

	Public Overridable Property OrderDate() As DateTime
        Get
			Return Me.GetDateTime(OrdersSchema.OrderDate.FieldName)
      End Get
        Set(ByVal Value As DateTime)
			Me.SetDateTime(OrdersSchema.OrderDate.FieldName, Value)
      End Set
    End Property

	Public Overridable Property RequiredDate() As DateTime
        Get
			Return Me.GetDateTime(OrdersSchema.RequiredDate.FieldName)
      End Get
        Set(ByVal Value As DateTime)
			Me.SetDateTime(OrdersSchema.RequiredDate.FieldName, Value)
      End Set
    End Property

	Public Overridable Property ShippedDate() As DateTime
        Get
			Return Me.GetDateTime(OrdersSchema.ShippedDate.FieldName)
      End Get
        Set(ByVal Value As DateTime)
			Me.SetDateTime(OrdersSchema.ShippedDate.FieldName, Value)
      End Set
    End Property

	Public Overridable Property ShipVia() As Integer
        Get
			Return Me.GetInteger(OrdersSchema.ShipVia.FieldName)
      End Get
        Set(ByVal Value As Integer)
			Me.SetInteger(OrdersSchema.ShipVia.FieldName, Value)
      End Set
    End Property

	Public Overridable Property Freight() As Decimal
        Get
			Return Me.GetDecimal(OrdersSchema.Freight.FieldName)
      End Get
        Set(ByVal Value As Decimal)
			Me.SetDecimal(OrdersSchema.Freight.FieldName, Value)
      End Set
    End Property

	Public Overridable Property ShipName() As String
        Get
			Return Me.GetString(OrdersSchema.ShipName.FieldName)
      End Get
        Set(ByVal Value As String)
			Me.SetString(OrdersSchema.ShipName.FieldName, Value)
      End Set
    End Property

	Public Overridable Property ShipAddress() As String
        Get
			Return Me.GetString(OrdersSchema.ShipAddress.FieldName)
      End Get
        Set(ByVal Value As String)
			Me.SetString(OrdersSchema.ShipAddress.FieldName, Value)
      End Set
    End Property

	Public Overridable Property ShipCity() As String
        Get
			Return Me.GetString(OrdersSchema.ShipCity.FieldName)
      End Get
        Set(ByVal Value As String)
			Me.SetString(OrdersSchema.ShipCity.FieldName, Value)
      End Set
    End Property

	Public Overridable Property ShipRegion() As String
        Get
			Return Me.GetString(OrdersSchema.ShipRegion.FieldName)
      End Get
        Set(ByVal Value As String)
			Me.SetString(OrdersSchema.ShipRegion.FieldName, Value)
      End Set
    End Property

	Public Overridable Property ShipPostalCode() As String
        Get
			Return Me.GetString(OrdersSchema.ShipPostalCode.FieldName)
      End Get
        Set(ByVal Value As String)
			Me.SetString(OrdersSchema.ShipPostalCode.FieldName, Value)
      End Set
    End Property

	Public Overridable Property ShipCountry() As String
        Get
			Return Me.GetString(OrdersSchema.ShipCountry.FieldName)
      End Get
        Set(ByVal Value As String)
			Me.SetString(OrdersSchema.ShipCountry.FieldName, Value)
      End Set
    End Property

    Public Overrides ReadOnly Property TableName() As String
        Get
            Return "Orders"
        End Get
    End Property

#End Region

#Region " String Properties "
		Public Overridable Property s_OrderID As String