lib综合查询.vb

本页只为图象处理爱好者交流之用, 未经本人同意, 请勿下载. 另,本书及所附source已于1999年由清华大学出版社出版,请支持正版书籍及软件,谢谢.

        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 String) 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 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.String), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column权限)
        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
                Try 
                    Return CType(Me(Me.table管理者信息.用户名称Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.table管理者信息.用户名称Column) = value
            End Set
        End Property
        
        Public Property 密码 As String
            Get
                Try 
                    Return CType(Me(Me.table管理者信息.密码Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.table管理者信息.密码Column) = value
            End Set
        End Property
        
        Public Property 权限 As String
            Get
                Try 
                    Return CType(Me(Me.table管理者信息.权限Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.table管理者信息.权限Column) = value
            End Set
        End Property
        
        Public Function Is用户名称Null() As Boolean
            Return Me.IsNull(Me.table管理者信息.用户名称Column)
        End Function
        
        Public Sub Set用户名称Null()
            Me(Me.table管理者信息.用户名称Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is密码Null() As Boolean
            Return Me.IsNull(Me.table管理者信息.密码Column)
        End Function
        
        Public Sub Set密码Null()
            Me(Me.table管理者信息.密码Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is权限Null() As Boolean
            Return Me.IsNull(Me.table管理者信息.权限Column)
        End Function
        
        Public Sub Set权限Null()
            Me(Me.table管理者信息.权限Column) = System.Convert.DBNull
        End Sub
    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
        
        Private column已借书数目 As DataColumn
        
        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
        
        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
        
        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 Integer, ByVal 姓名 As String, ByVal 联系方式 As String, ByVal 已借书数目 As Integer, ByVal 读者类别 As Integer, ByVal 能否借书 As Boolean, ByVal 密码 As String) 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 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("联系方式")
            Me.column已借书数目 = Me.Columns("已借书数目")
            Me.column读者类别 = Me.Columns("读者类别")