dataset1.vb

数据库课程设计。

        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
        
        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
        
        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 String,  _
                    ByVal 性别 As String,  _
                    ByVal 类型 As String,  _
                    ByVal 有效证件 As String,  _
                    ByVal 证件号码 As String,  _
                    ByVal 联系方式 As String,  _
                    ByVal 登记日期 As Date,  _
                    ByVal 有限期至 As Date,  _
                    ByVal 是否挂失 As Boolean,  _
                    ByVal 图书借阅次数 As Integer,  _
                    ByVal 期刊借阅次数 As Integer,  _
                    ByVal 操作员 As String,  _
                    ByVal 出生日期 As Date,  _
                    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 FindBy编号(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("姓名")
            Me.column性别 = Me.Columns("性别")
            Me.column类型 = Me.Columns("类型")
            Me.column有效证件 = Me.Columns("有效证件")
            Me.column证件号码 = Me.Columns("证件号码")
            Me.column联系方式 = Me.Columns("联系方式")
            Me.column登记日期 = Me.Columns("登记日期")
            Me.column有限期至 = Me.Columns("有限期至")
            Me.column是否挂失 = Me.Columns("是否挂失")
            Me.column图书借阅次数 = Me.Columns("图书借阅次数")
            Me.column期刊借阅次数 = Me.Columns("期刊借阅次数")
            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姓名)
            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.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.DateTime), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column登记日期)
            Me.column有限期至 = New DataColumn("有限期至", GetType(System.DateTime), 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.column图书借阅次数 = New DataColumn("图书借阅次数", GetType(System.Int32), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column图书借阅次数)
            Me.column期刊借阅次数 = New DataColumn("期刊借阅次数", GetType(System.Int32), 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.DateTime), 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
                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
                Return CType(Me(Me.table读者信息.编号Column),String)
            End Get
            Set
                Me(Me.table读者信息.编号Column) = value
            End Set
        End Property
        
        Public Property 姓名 As String