📄 lib读者信息.vb
字号:
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("密码")
End Sub
Private Sub InitClass()
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.String), 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.Boolean), 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 Integer
Get
Try
Return CType(Me(Me.table读者信息.证号Column),Integer)
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 Property 已借书数目 As Integer
Get
Try
Return CType(Me(Me.table读者信息.已借书数目Column),Integer)
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 Integer
Get
Try
Return CType(Me(Me.table读者信息.读者类别Column),Integer)
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 Boolean
Get
Try
Return CType(Me(Me.table读者信息.能否借书Column),Boolean)
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
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
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
End Class
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -