clscustomersds.vb

wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载

'------------------------------------------------------------------------------
' <autogenerated>
'     This code was generated by a tool.
'     Runtime Version:2.0.40607.42
'
'     Changes to this file may cause incorrect behavior and will be lost if
'     the code is regenerated.
' </autogenerated>
'------------------------------------------------------------------------------

Option Strict Off
Option Explicit On

Imports System.Xml.Serialization
'
'This source code was auto-generated by xsd, Version=2.0.40607.42.
'

'''<remarks/>
<System.SerializableAttribute(), _
 System.Xml.Serialization.XmlRootAttribute([Namespace]:="", IsNullable:=False)> _
Public Class Customers

	Private itemsField() As CustomersCustomer

	'''<remarks/>
	<System.Xml.Serialization.XmlElementAttribute("Customer", Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)> _
	Public Property Customers() As CustomersCustomer()
		'Property name was 'Items'
		Get
			Return Me.itemsField
		End Get
		Set(ByVal value As CustomersCustomer())
			Me.itemsField = value
		End Set
	End Property
End Class

'''<remarks/>
<System.SerializableAttribute()>  _
Public Class CustomersCustomer
    
    Private customerIDField As String
    
    Private companyNameField As String
    
    Private contactNameField As String
    
    Private contactTitleField As String
    
    Private addressField As String
    
    Private cityField As String
    
    Private regionField As String
    
    Private postalCodeField As String
    
    Private countryField As String
    
    Private phoneField As String
    
    Private faxField As String
    
    Private ordersField() As CustomersCustomerOrder
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property CustomerID() As String
        Get
            Return Me.customerIDField
        End Get
        Set
            Me.customerIDField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property CompanyName() As String
        Get
            Return Me.companyNameField
        End Get
        Set
            Me.companyNameField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ContactName() As String
        Get
            Return Me.contactNameField
        End Get
        Set
            Me.contactNameField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ContactTitle() As String
        Get
            Return Me.contactTitleField
        End Get
        Set
            Me.contactTitleField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property Address() As String
        Get
            Return Me.addressField
        End Get
        Set
            Me.addressField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property City() As String
        Get
            Return Me.cityField
        End Get
        Set
            Me.cityField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property Region() As String
        Get
            Return Me.regionField
        End Get
        Set
            Me.regionField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property PostalCode() As String
        Get
            Return Me.postalCodeField
        End Get
        Set
            Me.postalCodeField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property Country() As String
        Get
            Return Me.countryField
        End Get
        Set
            Me.countryField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property Phone() As String
        Get
            Return Me.phoneField
        End Get
        Set
            Me.phoneField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property Fax() As String
        Get
            Return Me.faxField
        End Get
        Set
            Me.faxField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlArrayAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified),  _
     System.Xml.Serialization.XmlArrayItemAttribute("Order", Form:=System.Xml.Schema.XmlSchemaForm.Unqualified, IsNullable:=false)>  _
    Public Property Orders() As CustomersCustomerOrder()
        Get
            Return Me.ordersField
        End Get
        Set
            Me.ordersField = value
        End Set
    End Property
End Class

'''<remarks/>
<System.SerializableAttribute()>  _
Public Class CustomersCustomerOrder
    
    Private orderIDField As Integer
    
    Private customerIDField As String
    
    Private employeeIDField As Integer
    
    Private orderDateField As Date
    
    Private requiredDateField As Date
    
    Private requiredDateFieldSpecified As Boolean
    
    Private shippedDateField As Date
    
    Private shippedDateFieldSpecified As Boolean
    
    Private shipViaField As Integer
    
    Private freightField As Decimal
    
    Private freightFieldSpecified As Boolean
    
    Private shipNameField As String
    
    Private shipAddressField As String
    
    Private shipCityField As String
    
    Private shipRegionField As String
    
    Private shipPostalCodeField As String
    
    Private shipCountryField As String
    
    Private order_DetailsField() As CustomersCustomerOrderOrder_Detail
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property OrderID() As Integer
        Get
            Return Me.orderIDField
        End Get
        Set
            Me.orderIDField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property CustomerID() As String
        Get
            Return Me.customerIDField
        End Get
        Set
            Me.customerIDField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property EmployeeID() As Integer
        Get
            Return Me.employeeIDField
        End Get
        Set
            Me.employeeIDField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property OrderDate() As Date
        Get
            Return Me.orderDateField
        End Get
        Set
            Me.orderDateField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property RequiredDate() As Date
        Get
            Return Me.requiredDateField
        End Get
        Set
            Me.requiredDateField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlIgnoreAttribute()>  _
    Public Property RequiredDateSpecified() As Boolean
        Get
            Return Me.requiredDateFieldSpecified
        End Get
        Set
            Me.requiredDateFieldSpecified = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ShippedDate() As Date
        Get
            Return Me.shippedDateField
        End Get
        Set
            Me.shippedDateField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlIgnoreAttribute()>  _
    Public Property ShippedDateSpecified() As Boolean
        Get
            Return Me.shippedDateFieldSpecified
        End Get
        Set
            Me.shippedDateFieldSpecified = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ShipVia() As Integer
        Get
            Return Me.shipViaField
        End Get
        Set
            Me.shipViaField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property Freight() As Decimal
        Get
            Return Me.freightField
        End Get
        Set
            Me.freightField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlIgnoreAttribute()>  _
    Public Property FreightSpecified() As Boolean
        Get
            Return Me.freightFieldSpecified
        End Get
        Set
            Me.freightFieldSpecified = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ShipName() As String
        Get
            Return Me.shipNameField
        End Get
        Set
            Me.shipNameField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ShipAddress() As String
        Get
            Return Me.shipAddressField
        End Get
        Set
            Me.shipAddressField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ShipCity() As String
        Get
            Return Me.shipCityField
        End Get
        Set
            Me.shipCityField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ShipRegion() As String
        Get
            Return Me.shipRegionField
        End Get
        Set
            Me.shipRegionField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ShipPostalCode() As String
        Get
            Return Me.shipPostalCodeField
        End Get
        Set
            Me.shipPostalCodeField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ShipCountry() As String
        Get
            Return Me.shipCountryField
        End Get
        Set
            Me.shipCountryField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlArrayAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified),  _
     System.Xml.Serialization.XmlArrayItemAttribute("Order_Detail", Form:=System.Xml.Schema.XmlSchemaForm.Unqualified, IsNullable:=false)>  _
    Public Property Order_Details() As CustomersCustomerOrderOrder_Detail()
        Get
            Return Me.order_DetailsField
        End Get
        Set
            Me.order_DetailsField = value
        End Set
    End Property
End Class

'''<remarks/>
<System.SerializableAttribute()>  _
Public Class CustomersCustomerOrderOrder_Detail
    
    Private orderIDField As Integer
    
    Private productIDField As Integer
    
    Private unitPriceField As Decimal
    
    Private quantityField As Short
    
    Private discountField As Decimal
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property OrderID() As Integer
        Get
            Return Me.orderIDField
        End Get
        Set
            Me.orderIDField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property ProductID() As Integer
        Get
            Return Me.productIDField
        End Get
        Set
            Me.productIDField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property UnitPrice() As Decimal
        Get
            Return Me.unitPriceField
        End Get
        Set
            Me.unitPriceField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property Quantity() As Short
        Get
            Return Me.quantityField
        End Get
        Set
            Me.quantityField = value
        End Set
    End Property
    
    '''<remarks/>
    <System.Xml.Serialization.XmlElementAttribute(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>  _
    Public Property Discount() As Decimal
        Get
            Return Me.discountField
        End Get
        Set
            Me.discountField = value
        End Set
    End Property
End Class