dataset1.vb

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

            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.Constraints.Add(New UniqueConstraint("Constraint1", New DataColumn() {Me.column用户编号}, true))
            Me.column用户编号.AllowDBNull = false
            Me.column用户编号.Unique = true
            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
            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
                Return CType(Me(Me.table用户清单.姓名Column),String)
            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
    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
        
        Private column销售价1 As DataColumn
        
        Private column销售价2 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
        
        Friend ReadOnly Property 销售价1Column As DataColumn
            Get
                Return Me.column销售价1
            End Get
        End Property
        
        Friend ReadOnly Property 销售价2Column As DataColumn
            Get
                Return Me.column销售价2
            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 Decimal, ByVal 销售价1 As Decimal, ByVal 销售价2 As Decimal, ByVal 规格 As String, ByVal 产地 As String, ByVal 类别 As String, ByVal 最低售价 As Decimal) As 商品清单Row
            Dim row商品清单Row As 商品清单Row = CType(Me.NewRow,商品清单Row)
            row商品清单Row.ItemArray = New Object() {货号, 条码, 拼音编码, 品名, 单位, 进货价, 销售价1, 销售价2, 规格, 产地, 类别, 最低售价}
            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销售价1 = Me.Columns("销售价1")
            Me.column销售价2 = Me.Columns("销售价2")
            Me.column规格 = Me.Columns("规格")