orderlist.vb

vfp开发的进销存管理系统,运行相应系统的Setup安装程序

            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.String), Nothing, System.Data.MappingType.Element)
            Me.Columns.Add(Me.column进货日期)
        End Sub
        
        Public Function NewOrderRow() As OrderRow
            Return CType(Me.NewRow,OrderRow)
        End Function
        
        Protected Overrides Function NewRowFromBuilder(ByVal builder As DataRowBuilder) As DataRow
            Return New OrderRow(builder)
        End Function
        
        Protected Overrides Function GetRowType() As System.Type
            Return GetType(OrderRow)
        End Function
        
        Protected Overrides Sub OnRowChanged(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowChanged(e)
            If (Not (Me.OrderRowChangedEvent) Is Nothing) Then
                RaiseEvent OrderRowChanged(Me, New OrderRowChangeEvent(CType(e.Row,OrderRow), e.Action))
            End If
        End Sub
        
        Protected Overrides Sub OnRowChanging(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowChanging(e)
            If (Not (Me.OrderRowChangingEvent) Is Nothing) Then
                RaiseEvent OrderRowChanging(Me, New OrderRowChangeEvent(CType(e.Row,OrderRow), e.Action))
            End If
        End Sub
        
        Protected Overrides Sub OnRowDeleted(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowDeleted(e)
            If (Not (Me.OrderRowDeletedEvent) Is Nothing) Then
                RaiseEvent OrderRowDeleted(Me, New OrderRowChangeEvent(CType(e.Row,OrderRow), e.Action))
            End If
        End Sub
        
        Protected Overrides Sub OnRowDeleting(ByVal e As DataRowChangeEventArgs)
            MyBase.OnRowDeleting(e)
            If (Not (Me.OrderRowDeletingEvent) Is Nothing) Then
                RaiseEvent OrderRowDeleting(Me, New OrderRowChangeEvent(CType(e.Row,OrderRow), e.Action))
            End If
        End Sub
        
        Public Sub RemoveOrderRow(ByVal row As OrderRow)
            Me.Rows.Remove(row)
        End Sub
    End Class
    
    <System.Diagnostics.DebuggerStepThrough()>  _
    Public Class OrderRow
        Inherits DataRow
        
        Private tableOrder As OrderDataTable
        
        Friend Sub New(ByVal rb As DataRowBuilder)
            MyBase.New(rb)
            Me.tableOrder = CType(Me.Table,OrderDataTable)
        End Sub
        
        Public Property 名称 As String
            Get
                Try 
                    Return CType(Me(Me.tableOrder.名称Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.tableOrder.名称Column) = value
            End Set
        End Property
        
        Public Property 品名 As String
            Get
                Try 
                    Return CType(Me(Me.tableOrder.品名Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.tableOrder.品名Column) = value
            End Set
        End Property
        
        Public Property 进货数 As String
            Get
                Try 
                    Return CType(Me(Me.tableOrder.进货数Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.tableOrder.进货数Column) = value
            End Set
        End Property
        
        Public Property 仓库 As String
            Get
                Try 
                    Return CType(Me(Me.tableOrder.仓库Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.tableOrder.仓库Column) = value
            End Set
        End Property
        
        Public Property 不含税 As String
            Get
                Try 
                    Return CType(Me(Me.tableOrder.不含税Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.tableOrder.不含税Column) = value
            End Set
        End Property
        
        Public Property 税额 As String
            Get
                Try 
                    Return CType(Me(Me.tableOrder.税额Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.tableOrder.税额Column) = value
            End Set
        End Property
        
        Public Property 税价合计 As String
            Get
                Try 
                    Return CType(Me(Me.tableOrder.税价合计Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.tableOrder.税价合计Column) = value
            End Set
        End Property
        
        Public Property 单位 As String
            Get
                Try 
                    Return CType(Me(Me.tableOrder.单位Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.tableOrder.单位Column) = value
            End Set
        End Property
        
        Public Property 进货日期 As String
            Get
                Try 
                    Return CType(Me(Me.tableOrder.进货日期Column),String)
                Catch e As InvalidCastException
                    Throw New StrongTypingException("无法获取值，因为它是 DBNull。", e)
                End Try
            End Get
            Set
                Me(Me.tableOrder.进货日期Column) = value
            End Set
        End Property
        
        Public Function Is名称Null() As Boolean
            Return Me.IsNull(Me.tableOrder.名称Column)
        End Function
        
        Public Sub Set名称Null()
            Me(Me.tableOrder.名称Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is品名Null() As Boolean
            Return Me.IsNull(Me.tableOrder.品名Column)
        End Function
        
        Public Sub Set品名Null()
            Me(Me.tableOrder.品名Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is进货数Null() As Boolean
            Return Me.IsNull(Me.tableOrder.进货数Column)
        End Function
        
        Public Sub Set进货数Null()
            Me(Me.tableOrder.进货数Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is仓库Null() As Boolean
            Return Me.IsNull(Me.tableOrder.仓库Column)
        End Function
        
        Public Sub Set仓库Null()
            Me(Me.tableOrder.仓库Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is不含税Null() As Boolean
            Return Me.IsNull(Me.tableOrder.不含税Column)
        End Function
        
        Public Sub Set不含税Null()
            Me(Me.tableOrder.不含税Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is税额Null() As Boolean
            Return Me.IsNull(Me.tableOrder.税额Column)
        End Function
        
        Public Sub Set税额Null()
            Me(Me.tableOrder.税额Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is税价合计Null() As Boolean
            Return Me.IsNull(Me.tableOrder.税价合计Column)
        End Function
        
        Public Sub Set税价合计Null()
            Me(Me.tableOrder.税价合计Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is单位Null() As Boolean
            Return Me.IsNull(Me.tableOrder.单位Column)
        End Function
        
        Public Sub Set单位Null()
            Me(Me.tableOrder.单位Column) = System.Convert.DBNull
        End Sub
        
        Public Function Is进货日期Null() As Boolean
            Return Me.IsNull(Me.tableOrder.进货日期Column)
        End Function
        
        Public Sub Set进货日期Null()
            Me(Me.tableOrder.进货日期Column) = System.Convert.DBNull
        End Sub
    End Class
    
    <System.Diagnostics.DebuggerStepThrough()>  _
    Public Class OrderRowChangeEvent
        Inherits EventArgs
        
        Private eventRow As OrderRow
        
        Private eventAction As DataRowAction
        
        Public Sub New(ByVal row As OrderRow, ByVal action As DataRowAction)
            MyBase.New
            Me.eventRow = row
            Me.eventAction = action
        End Sub
        
        Public ReadOnly Property Row As OrderRow
            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