ds1.vb

一个功能强大的学生公寓管理系统 界面非常友好 十分强大

        
        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 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 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 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
        
        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
        
        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) 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("时间")
            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.Constraints.Add(New UniqueConstraint("Constraint1", New DataColumn() {Me.column学号, Me.column时间}, 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