dataset1.vb

来自「酒店管理系统,可以用户与酒店的管理,客房登记、结帐、预定」· VB 代码 · 共 887 行 · 第 1/3 页

            Me.column用户真名 = Me.Columns("用户真名")
            Me.column密码 = Me.Columns("密码")
        End Sub
        
        Private Sub InitClass()
            Me.column用户名 = New DataColumn("用户名", GetType(System.String), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column用户名)
            Me.column用户真名 = New DataColumn("用户真名", GetType(System.String), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column用户真名)
            Me.column密码 = New DataColumn("密码", GetType(System.String), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column密码)
            Me.Constraints.Add(New UniqueConstraint("Constraint1", New DataColumn() {Me.column用户名}, true))
            Me.column用户名.AllowDBNull = false
            Me.column用户名.Unique = true
            Me.column用户真名.AllowDBNull = false
            Me.column密码.AllowDBNull = false
        End Sub
        
        Public Function New用户表Row() As 用户表Row
            Return CType(Me.NewRow,用户表Row)
        End Function
        
        Protected Overrides Function NewRowFromBuilder(ByVal builder As DataRowBuilder) As DataRow
            Return New 用户表Row(builder)
        End Function
        
        Protected Overrides Function GetRowType() As System.Type
            Return GetType(用户表Row)
        End Function
        
        Protected Overrides Sub OnRowChanged(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowChanged(e)
            If (Not (Me.用户表RowChangedEvent) Is Nothing) Then
                RaiseEvent 用户表RowChanged(Me, New 用户表RowChangeEvent(CType(e.Row,用户表Row), e.Action))
            End If
        End Sub
        
        Protected Overrides Sub OnRowChanging(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowChanging(e)
            If (Not (Me.用户表RowChangingEvent) Is Nothing) Then
                RaiseEvent 用户表RowChanging(Me, New 用户表RowChangeEvent(CType(e.Row,用户表Row), e.Action))
            End If
        End Sub
        
        Protected Overrides Sub OnRowDeleted(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowDeleted(e)
            If (Not (Me.用户表RowDeletedEvent) Is Nothing) Then
                RaiseEvent 用户表RowDeleted(Me, New 用户表RowChangeEvent(CType(e.Row,用户表Row), e.Action))
            End If
        End Sub
        
        Protected Overrides Sub OnRowDeleting(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowDeleting(e)
            If (Not (Me.用户表RowDeletingEvent) Is Nothing) Then
                RaiseEvent 用户表RowDeleting(Me, New 用户表RowChangeEvent(CType(e.Row,用户表Row), e.Action))
            End If
        End Sub
        
        Public Sub Remove用户表Row(ByVal row As 用户表Row)
            Me.Rows.Remove(row)
        End Sub
    End Class
    
    <System.Diagnostics.DebuggerStepThrough()>  _
    Public Class 用户表Row
        Inherits DataRow
        
        Private table用户表 As 用户表DataTable
        
        Friend Sub New(ByVal rb As DataRowBuilder)
            MyBase.New(rb)
            Me.table用户表 = CType(Me.Table,用户表DataTable)
        End Sub
        
        Public Property 用户名 As String
            Get
                Return CType(Me(Me.table用户表.用户名Column),String)
            End Get
            Set
                Me(Me.table用户表.用户名Column) = value
            End Set
        End Property
        
        Public Property 用户真名 As String
            Get
                Return CType(Me(Me.table用户表.用户真名Column),String)
            End Get
            Set
                Me(Me.table用户表.用户真名Column) = value
            End Set
        End Property
        
        Public Property 密码 As String
            Get
                Return CType(Me(Me.table用户表.密码Column),String)
            End Get
            Set
                Me(Me.table用户表.密码Column) = value
            End Set
        End Property
    End Class
    
    <System.Diagnostics.DebuggerStepThrough()>  _
    Public Class 用户表RowChangeEvent
        Inherits EventArgs
        
        Private eventRow As 用户表Row
        
        Private eventAction As DataRowAction
        
        Public Sub New(ByVal row As 用户表Row, ByVal action As DataRowAction)
            MyBase.New
            Me.eventRow = row
            Me.eventAction = action
        End Sub
        
        Public ReadOnly Property Row As 用户表Row
            Get
                Return Me.eventRow
            End Get
        End Property
        
        Public ReadOnly Property Action As DataRowAction
            Get
                Return Me.eventAction
            End Get
        End Property
    End Class
    
    <System.Diagnostics.DebuggerStepThrough()>  _
    Public Class 用户权限DataTable
        Inherits DataTable
        Implements System.Collections.IEnumerable
        
        Private column用户名 As DataColumn
        
        Private column程序名 As DataColumn
        
        Private column运行权限 As DataColumn
        
        Friend Sub New()
            MyBase.New("用户权限")
            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 用户名Column As DataColumn
            Get
                Return Me.column用户名
            End Get
        End Property
        
        Friend ReadOnly Property 程序名Column As DataColumn
            Get
                Return Me.column程序名
            End Get
        End Property
        
        Friend ReadOnly Property 运行权限Column As DataColumn
            Get
                Return Me.column运行权限
            End Get
        End Property
        
        Public Default ReadOnly Property Item(ByVal index As Integer) As 用户权限Row
            Get
                Return CType(Me.Rows(index),用户权限Row)
            End Get
        End Property
        
        Public Event 用户权限RowChanged As 用户权限RowChangeEventHandler
        
        Public Event 用户权限RowChanging As 用户权限RowChangeEventHandler
        
        Public Event 用户权限RowDeleted As 用户权限RowChangeEventHandler
        
        Public Event 用户权限RowDeleting As 用户权限RowChangeEventHandler
        
        Public Overloads Sub Add用户权限Row(ByVal row As 用户权限Row)
            Me.Rows.Add(row)
        End Sub
        
        Public Overloads Function Add用户权限Row(ByVal 用户名 As String, ByVal 程序名 As String, ByVal 运行权限 As Boolean) As 用户权限Row
            Dim row用户权限Row As 用户权限Row = CType(Me.NewRow,用户权限Row)
            row用户权限Row.ItemArray = New Object() {用户名, 程序名, 运行权限}
            Me.Rows.Add(row用户权限Row)
            Return row用户权限Row
        End Function
        
        Public Function FindBy用户名程序名(ByVal 用户名 As String, ByVal 程序名 As String) As 用户权限Row
            Return CType(Me.Rows.Find(New Object() {用户名, 程序名}),用户权限Row)
        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 用户权限DataTable = CType(MyBase.Clone,用户权限DataTable)
            cln.InitVars
            Return cln
        End Function
        
        Protected Overrides Function CreateInstance() As DataTable
            Return New 用户权限DataTable
        End Function
        
        Friend Sub InitVars()
            Me.column用户名 = Me.Columns("用户名")
            Me.column程序名 = Me.Columns("程序名")
            Me.column运行权限 = Me.Columns("运行权限")
        End Sub
        
        Private Sub InitClass()
            Me.column用户名 = New DataColumn("用户名", GetType(System.String), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column用户名)
            Me.column程序名 = New DataColumn("程序名", GetType(System.String), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column程序名)
            Me.column运行权限 = New DataColumn("运行权限", GetType(System.Boolean), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column运行权限)
            Me.Constraints.Add(New UniqueConstraint("Constraint1", New DataColumn() {Me.column用户名, Me.column程序名}, true))
            Me.column用户名.AllowDBNull = false
            Me.column程序名.AllowDBNull = false
            Me.column运行权限.AllowDBNull = false
        End Sub
        
        Public Function New用户权限Row() As 用户权限Row
            Return CType(Me.NewRow,用户权限Row)
        End Function
        
        Protected Overrides Function NewRowFromBuilder(ByVal builder As DataRowBuilder) As DataRow
            Return New 用户权限Row(builder)
        End Function
        
        Protected Overrides Function GetRowType() As System.Type
            Return GetType(用户权限Row)
        End Function
        
        Protected Overrides Sub OnRowChanged(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowChanged(e)
            If (Not (Me.用户权限RowChangedEvent) Is Nothing) Then
                RaiseEvent 用户权限RowChanged(Me, New 用户权限RowChangeEvent(CType(e.Row,用户权限Row), e.Action))
            End If
        End Sub
        
        Protected Overrides Sub OnRowChanging(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowChanging(e)
            If (Not (Me.用户权限RowChangingEvent) Is Nothing) Then
                RaiseEvent 用户权限RowChanging(Me, New 用户权限RowChangeEvent(CType(e.Row,用户权限Row), e.Action))
            End If
        End Sub
        
        Protected Overrides Sub OnRowDeleted(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowDeleted(e)
            If (Not (Me.用户权限RowDeletedEvent) Is Nothing) Then
                RaiseEvent 用户权限RowDeleted(Me, New 用户权限RowChangeEvent(CType(e.Row,用户权限Row), e.Action))
            End If
        End Sub
        
        Protected Overrides Sub OnRowDeleting(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowDeleting(e)
            If (Not (Me.用户权限RowDeletingEvent) Is Nothing) Then
                RaiseEvent 用户权限RowDeleting(Me, New 用户权限RowChangeEvent(CType(e.Row,用户权限Row), e.Action))
            End If
        End Sub
        
        Public Sub Remove用户权限Row(ByVal row As 用户权限Row)
            Me.Rows.Remove(row)
        End Sub
    End Class
    
    <System.Diagnostics.DebuggerStepThrough()>  _
    Public Class 用户权限Row
        Inherits DataRow