📄 lib综合查询.vb
字号:
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
<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_E_mail 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 _E_mailColumn As DataColumn
Get
Return Me.column_E_mail
End Get
End Property
Public Default ReadOnly Property Item(ByVal index As Integer) As 出版社信息Row
Get
Return CType(Me.Rows(index),出版社信息Row)
End Get
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -