📄 dsproduct.vb
字号:
'------------------------------------------------------------------------------
' <autogenerated>
' This code was generated by a tool.
' Runtime Version: 1.0.3705.0
'
' 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
Imports System.Data
Imports System.Runtime.Serialization
Imports System.Xml
<Serializable(), _
System.ComponentModel.DesignerCategoryAttribute("code"), _
System.Diagnostics.DebuggerStepThrough(), _
System.ComponentModel.ToolboxItem(true)> _
Public Class dsProduct
Inherits DataSet
Private tableProducts As ProductsDataTable
Public Sub New()
MyBase.New
Me.InitClass
Dim schemaChangedHandler As System.ComponentModel.CollectionChangeEventHandler = AddressOf Me.SchemaChanged
AddHandler Me.Tables.CollectionChanged, schemaChangedHandler
AddHandler Me.Relations.CollectionChanged, schemaChangedHandler
End Sub
Protected Sub New(ByVal info As SerializationInfo, ByVal context As StreamingContext)
MyBase.New
Dim strSchema As String = CType(info.GetValue("XmlSchema", GetType(System.String)),String)
If (Not (strSchema) Is Nothing) Then
Dim ds As DataSet = New DataSet
ds.ReadXmlSchema(New XmlTextReader(New System.IO.StringReader(strSchema)))
If (Not (ds.Tables("Products")) Is Nothing) Then
Me.Tables.Add(New ProductsDataTable(ds.Tables("Products")))
End If
Me.DataSetName = ds.DataSetName
Me.Prefix = ds.Prefix
Me.Namespace = ds.Namespace
Me.Locale = ds.Locale
Me.CaseSensitive = ds.CaseSensitive
Me.EnforceConstraints = ds.EnforceConstraints
Me.Merge(ds, false, System.Data.MissingSchemaAction.Add)
Me.InitVars
Else
Me.InitClass
End If
Me.GetSerializationData(info, context)
Dim schemaChangedHandler As System.ComponentModel.CollectionChangeEventHandler = AddressOf Me.SchemaChanged
AddHandler Me.Tables.CollectionChanged, schemaChangedHandler
AddHandler Me.Relations.CollectionChanged, schemaChangedHandler
End Sub
<System.ComponentModel.Browsable(false), _
System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)> _
Public ReadOnly Property Products As ProductsDataTable
Get
Return Me.tableProducts
End Get
End Property
Public Overrides Function Clone() As DataSet
Dim cln As dsProduct = CType(MyBase.Clone,dsProduct)
cln.InitVars
Return cln
End Function
Protected Overrides Function ShouldSerializeTables() As Boolean
Return false
End Function
Protected Overrides Function ShouldSerializeRelations() As Boolean
Return false
End Function
Protected Overrides Sub ReadXmlSerializable(ByVal reader As XmlReader)
Me.Reset
Dim ds As DataSet = New DataSet
ds.ReadXml(reader)
If (Not (ds.Tables("Products")) Is Nothing) Then
Me.Tables.Add(New ProductsDataTable(ds.Tables("Products")))
End If
Me.DataSetName = ds.DataSetName
Me.Prefix = ds.Prefix
Me.Namespace = ds.Namespace
Me.Locale = ds.Locale
Me.CaseSensitive = ds.CaseSensitive
Me.EnforceConstraints = ds.EnforceConstraints
Me.Merge(ds, false, System.Data.MissingSchemaAction.Add)
Me.InitVars
End Sub
Protected Overrides Function GetSchemaSerializable() As System.Xml.Schema.XmlSchema
Dim stream As System.IO.MemoryStream = New System.IO.MemoryStream
Me.WriteXmlSchema(New XmlTextWriter(stream, Nothing))
stream.Position = 0
Return System.Xml.Schema.XmlSchema.Read(New XmlTextReader(stream), Nothing)
End Function
Friend Sub InitVars()
Me.tableProducts = CType(Me.Tables("Products"),ProductsDataTable)
If (Not (Me.tableProducts) Is Nothing) Then
Me.tableProducts.InitVars
End If
End Sub
Private Sub InitClass()
Me.DataSetName = "dsProduct"
Me.Prefix = ""
Me.Namespace = "http://tempuri.org/dsProduct.xsd"
Me.Locale = New System.Globalization.CultureInfo("en-US")
Me.CaseSensitive = false
Me.EnforceConstraints = true
Me.tableProducts = New ProductsDataTable
Me.Tables.Add(Me.tableProducts)
End Sub
Private Function ShouldSerializeProducts() As Boolean
Return false
End Function
Private Sub SchemaChanged(ByVal sender As Object, ByVal e As System.ComponentModel.CollectionChangeEventArgs)
If (e.Action = System.ComponentModel.CollectionChangeAction.Remove) Then
Me.InitVars
End If
End Sub
Public Delegate Sub ProductsRowChangeEventHandler(ByVal sender As Object, ByVal e As ProductsRowChangeEvent)
<System.Diagnostics.DebuggerStepThrough()> _
Public Class ProductsDataTable
Inherits DataTable
Implements System.Collections.IEnumerable
Private columnProductID As DataColumn
Private columnSKU As DataColumn
Private columnProductType As DataColumn
Private columnProductDate As DataColumn
Private columnProductName As DataColumn
Private columnDescription As DataColumn
Private columnProductSize As DataColumn
Private columnImageURL As DataColumn
Private columnUnitPrice As DataColumn
Private columnOnSale As DataColumn
Friend Sub New()
MyBase.New("Products")
Me.InitClass
End Sub
Friend Sub New(ByVal table As DataTable)
MyBase.New(table.TableName)
If (table.CaseSensitive <> table.DataSet.CaseSensitive) Then
Me.CaseSensitive = table.CaseSensitive
End If
If (table.Locale.ToString <> table.DataSet.Locale.ToString) Then
Me.Locale = table.Locale
End If
If (table.Namespace <> table.DataSet.Namespace) Then
Me.Namespace = table.Namespace
End If
Me.Prefix = table.Prefix
Me.MinimumCapacity = table.MinimumCapacity
Me.DisplayExpression = table.DisplayExpression
End Sub
<System.ComponentModel.Browsable(false)> _
Public ReadOnly Property Count As Integer
Get
Return Me.Rows.Count
End Get
End Property
Friend ReadOnly Property ProductIDColumn As DataColumn
Get
Return Me.columnProductID
End Get
End Property
Friend ReadOnly Property SKUColumn As DataColumn
Get
Return Me.columnSKU
End Get
End Property
Friend ReadOnly Property ProductTypeColumn As DataColumn
Get
Return Me.columnProductType
End Get
End Property
Friend ReadOnly Property ProductDateColumn As DataColumn
Get
Return Me.columnProductDate
End Get
End Property
Friend ReadOnly Property ProductNameColumn As DataColumn
Get
Return Me.columnProductName
End Get
End Property
Friend ReadOnly Property DescriptionColumn As DataColumn
Get
Return Me.columnDescription
End Get
End Property
Friend ReadOnly Property ProductSizeColumn As DataColumn
Get
Return Me.columnProductSize
End Get
End Property
Friend ReadOnly Property ImageURLColumn As DataColumn
Get
Return Me.columnImageURL
End Get
End Property
Friend ReadOnly Property UnitPriceColumn As DataColumn
Get
Return Me.columnUnitPrice
End Get
End Property
Friend ReadOnly Property OnSaleColumn As DataColumn
Get
Return Me.columnOnSale
End Get
End Property
Public Default ReadOnly Property Item(ByVal index As Integer) As ProductsRow
Get
Return CType(Me.Rows(index),ProductsRow)
End Get
End Property
Public Event ProductsRowChanged As ProductsRowChangeEventHandler
Public Event ProductsRowChanging As ProductsRowChangeEventHandler
Public Event ProductsRowDeleted As ProductsRowChangeEventHandler
Public Event ProductsRowDeleting As ProductsRowChangeEventHandler
Public Overloads Sub AddProductsRow(ByVal row As ProductsRow)
Me.Rows.Add(row)
End Sub
Public Overloads Function AddProductsRow(ByVal ProductID As System.Guid, ByVal SKU As String, ByVal ProductType As String, ByVal ProductDate As Date, ByVal ProductName As String, ByVal Description As String, ByVal ProductSize As String, ByVal ImageURL As String, ByVal UnitPrice As Decimal, ByVal OnSale As Boolean) As ProductsRow
Dim rowProductsRow As ProductsRow = CType(Me.NewRow,ProductsRow)
rowProductsRow.ItemArray = New Object() {ProductID, SKU, ProductType, ProductDate, ProductName, Description, ProductSize, ImageURL, UnitPrice, OnSale}
Me.Rows.Add(rowProductsRow)
Return rowProductsRow
End Function
Public Function GetEnumerator() As System.Collections.IEnumerator Implements System.Collections.IEnumerable.GetEnumerator
Return Me.Rows.GetEnumerator
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -