📄 dssy210.vb
字号:
'------------------------------------------------------------------------------
' <autogenerated>
' This code was generated by a tool.
' Runtime Version: 1.0.3608.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 dsSY210
Inherits DataSet
Private tableUsers As UsersDataTable
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("Users")) Is Nothing) Then
Me.Tables.Add(New UsersDataTable(ds.Tables("Users")))
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 Users As UsersDataTable
Get
Return Me.tableUsers
End Get
End Property
Public Overrides Function Clone() As DataSet
Dim cln As dsSY210 = CType(MyBase.Clone,dsSY210)
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("Users")) Is Nothing) Then
Me.Tables.Add(New UsersDataTable(ds.Tables("Users")))
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.tableUsers = CType(Me.Tables("Users"),UsersDataTable)
If (Not (Me.tableUsers) Is Nothing) Then
Me.tableUsers.InitVars
End If
End Sub
Private Sub InitClass()
Me.DataSetName = "dsSY210"
Me.Prefix = ""
Me.Namespace = "http://www.tempuri.org/dsSY210.xsd"
Me.Locale = New System.Globalization.CultureInfo("en-US")
Me.CaseSensitive = false
Me.EnforceConstraints = true
Me.tableUsers = New UsersDataTable
Me.Tables.Add(Me.tableUsers)
End Sub
Private Function ShouldSerializeUsers() 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 UsersRowChangeEventHandler(ByVal sender As Object, ByVal e As UsersRowChangeEvent)
<System.Diagnostics.DebuggerStepThrough()> _
Public Class UsersDataTable
Inherits DataTable
Implements System.Collections.IEnumerable
Private columnUserID As DataColumn
Private columnUserName As DataColumn
Private columnPasswordCode As DataColumn
Friend Sub New()
MyBase.New("Users")
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 UserIDColumn As DataColumn
Get
Return Me.columnUserID
End Get
End Property
Friend ReadOnly Property UserNameColumn As DataColumn
Get
Return Me.columnUserName
End Get
End Property
Friend ReadOnly Property PasswordCodeColumn As DataColumn
Get
Return Me.columnPasswordCode
End Get
End Property
Public Default ReadOnly Property Item(ByVal index As Integer) As UsersRow
Get
Return CType(Me.Rows(index),UsersRow)
End Get
End Property
Public Event UsersRowChanged As UsersRowChangeEventHandler
Public Event UsersRowChanging As UsersRowChangeEventHandler
Public Event UsersRowDeleted As UsersRowChangeEventHandler
Public Event UsersRowDeleting As UsersRowChangeEventHandler
Public Overloads Sub AddUsersRow(ByVal row As UsersRow)
Me.Rows.Add(row)
End Sub
Public Overloads Function AddUsersRow(ByVal UserID As String, ByVal UserName As String, ByVal PasswordCode As String) As UsersRow
Dim rowUsersRow As UsersRow = CType(Me.NewRow,UsersRow)
rowUsersRow.ItemArray = New Object() {UserID, UserName, PasswordCode}
Me.Rows.Add(rowUsersRow)
Return rowUsersRow
End Function
Public Function FindByUserID(ByVal UserID As String) As UsersRow
Return CType(Me.Rows.Find(New Object() {UserID}),UsersRow)
End Function
Public Function GetEnumerator() As System.Collections.IEnumerator Implements System.Collections.IEnumerable.GetEnumerator
Return Me.Rows.GetEnumerator
End Function
Public Overrides Function Clone() As DataTable
Dim cln As UsersDataTable = CType(MyBase.Clone,UsersDataTable)
cln.InitVars
Return cln
End Function
Friend Sub InitVars()
Me.columnUserID = Me.Columns("UserID")
Me.columnUserName = Me.Columns("UserName")
Me.columnPasswordCode = Me.Columns("PasswordCode")
End Sub
Private Sub InitClass()
Me.columnUserID = New DataColumn("UserID", GetType(System.String), Nothing, System.Data.MappingType.Element)
Me.Columns.Add(Me.columnUserID)
Me.columnUserName = New DataColumn("UserName", GetType(System.String), Nothing, System.Data.MappingType.Element)
Me.Columns.Add(Me.columnUserName)
Me.columnPasswordCode = New DataColumn("PasswordCode", GetType(System.String), Nothing, System.Data.MappingType.Element)
Me.Columns.Add(Me.columnPasswordCode)
Me.Constraints.Add(New UniqueConstraint("Constraint1", New DataColumn() {Me.columnUserID}, true))
Me.columnUserID.AllowDBNull = false
Me.columnUserID.Unique = true
Me.columnUserName.AllowDBNull = false
Me.columnPasswordCode.AllowDBNull = false
End Sub
Public Function NewUsersRow() As UsersRow
Return CType(Me.NewRow,UsersRow)
End Function
Protected Overrides Function NewRowFromBuilder(ByVal builder As DataRowBuilder) As DataRow
Return New UsersRow(builder)
End Function
Protected Overrides Function GetRowType() As System.Type
Return GetType(UsersRow)
End Function
Protected Overrides Sub OnRowChanged(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowChanged(e)
If (Not (Me.UsersRowChangedEvent) Is Nothing) Then
RaiseEvent UsersRowChanged(Me, New UsersRowChangeEvent(CType(e.Row,UsersRow), e.Action))
End If
End Sub
Protected Overrides Sub OnRowChanging(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowChanging(e)
If (Not (Me.UsersRowChangingEvent) Is Nothing) Then
RaiseEvent UsersRowChanging(Me, New UsersRowChangeEvent(CType(e.Row,UsersRow), e.Action))
End If
End Sub
Protected Overrides Sub OnRowDeleted(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowDeleted(e)
If (Not (Me.UsersRowDeletedEvent) Is Nothing) Then
RaiseEvent UsersRowDeleted(Me, New UsersRowChangeEvent(CType(e.Row,UsersRow), e.Action))
End If
End Sub
Protected Overrides Sub OnRowDeleting(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowDeleting(e)
If (Not (Me.UsersRowDeletingEvent) Is Nothing) Then
RaiseEvent UsersRowDeleting(Me, New UsersRowChangeEvent(CType(e.Row,UsersRow), e.Action))
End If
End Sub
Public Sub RemoveUsersRow(ByVal row As UsersRow)
Me.Rows.Remove(row)
End Sub
End Class
<System.Diagnostics.DebuggerStepThrough()> _
Public Class UsersRow
Inherits DataRow
Private tableUsers As UsersDataTable
Friend Sub New(ByVal rb As DataRowBuilder)
MyBase.New(rb)
Me.tableUsers = CType(Me.Table,UsersDataTable)
End Sub
Public Property UserID As String
Get
Return CType(Me(Me.tableUsers.UserIDColumn),String)
End Get
Set
Me(Me.tableUsers.UserIDColumn) = value
End Set
End Property
Public Property UserName As String
Get
Return CType(Me(Me.tableUsers.UserNameColumn),String)
End Get
Set
Me(Me.tableUsers.UserNameColumn) = value
End Set
End Property
Public Property PasswordCode As String
Get
Return CType(Me(Me.tableUsers.PasswordCodeColumn),String)
End Get
Set
Me(Me.tableUsers.PasswordCodeColumn) = value
End Set
End Property
End Class
<System.Diagnostics.DebuggerStepThrough()> _
Public Class UsersRowChangeEvent
Inherits EventArgs
Private eventRow As UsersRow
Private eventAction As DataRowAction
Public Sub New(ByVal row As UsersRow, ByVal action As DataRowAction)
MyBase.New
Me.eventRow = row
Me.eventAction = action
End Sub
Public ReadOnly Property Row As UsersRow
Get
Return Me.eventRow
End Get
End Property
Public ReadOnly Property Action As DataRowAction
Get
Return Me.eventAction
End Get
End Property
End Class
End Class
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -