主题：流水账中如何区分产品和型号两种类别设计？

做个表达式列，合并产品和型号一起到这个表达式列。

修改代码：

Select Case e.DataCol.Name
    Case "产品","型号","入库","出库"
        Dim dr As DataRow
        Dim mr As DataRow = e.DataRow
        Dim drs As List(of DataRow)
        dr = e.DataTable.Find("[_SortKey] < " & mr("_SortKey") & " And [表达式列] = '" & mr("表达式列") & "'", "[_SortKey] Desc")
        If dr Is Nothing Then
            mr("库存") = mr("入库") - mr("出库")
            dr = mr
        End If
        drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [表达式列] = '" & dr("表达式列") & "'", "[_SortKey]")
        For i As Integer = 1 To drs.Count - 1
            drs(i)("库存") = drs(i-1)("库存") + drs(i)("入库") - drs(i)("出库")
        Next
        If e.DataCol.Name = "表达式列" AndAlso e.OldValue IsNot Nothing AndAlso e.OldValue <> e.NewValue Then
            dr = e.DataTable.Find("[_SortKey] < " & mr("_SortKey") & " And [表达式列] = '" & e.OldValue & "'", "[_SortKey] Desc")
            If dr Is Nothing Then
                dr = e.DataTable.Find("[表达式列] = '" & e.OldValue & "'", "[_SortKey]")
                If dr IsNot Nothing Then
                    dr("库存") = dr("入库") - dr("出库")
                End If
            End If
            If dr IsNot Nothing Then
                drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [表达式列] = '" & dr("表达式列") & "'", "[_SortKey]")
                For i As Integer = 1 To drs.Count - 1
                    drs(i)("库存") = drs(i-1)("库存") + drs(i)("入库") - drs(i)("出库")
                Next
            End If
        End If
End Select

1、增加一个全局变量。

2、菜单加一个按钮：

全局变量= not 全局变量

DataTables("表名").DataCols("入库").RaiseDataColChanged

3、DataColChanged事件代码改为：

If 全局变量 = True Then
    Select Case e.DataCol.Name
        Case "品名","入库","出库"
            Dim dr As DataRow
            Dim mr As DataRow = e.DataRow
            Dim drs As List(of DataRow)
            dr = e.DataTable.Find("[_SortKey] < " & mr("_SortKey") & " And [品名] = '" & mr("品名") & "'", "[_SortKey] Desc")
            If dr Is Nothing Then
                mr("库存") = mr("入库") - mr("出库")
                dr = mr
            End If
            drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [品名] = '" & dr("品名") & "'", "[_SortKey]")
            For i As Integer = 1 To drs.Count - 1
                drs(i)("库存") = drs(i-1)("库存") + drs(i)("入库") - drs(i)("出库")
            Next
            If e.DataCol.Name = "品名" AndAlso e.OldValue IsNot Nothing AndAlso e.OldValue <> e.NewValue Then
                dr = e.DataTable.Find("[_SortKey] < " & mr("_SortKey") & " And [品名] = '" & e.OldValue & "'", "[_SortKey] Desc")
                If dr Is Nothing Then
                    dr = e.DataTable.Find("[品名] = '" & e.OldValue & "'", "[_SortKey]")
                    If dr IsNot Nothing Then
                        dr("库存") = dr("入库") - dr("出库")
                    End If
                End If
                If dr IsNot Nothing Then
                    drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [品名] = '" & dr("品名") & "'", "[_SortKey]")
                    For i As Integer = 1 To drs.Count - 1
                        drs(i)("库存") = drs(i-1)("库存") + drs(i)("入库") - drs(i)("出库")
                    Next
                End If
            End If
    End Select
Else
    Select Case e.DataCol.Name
        Case "规格","入库","出库"
            Dim dr As DataRow
            Dim mr As DataRow = e.DataRow
            Dim drs As List(of DataRow)
            dr = e.DataTable.Find("[_SortKey] < " & mr("_SortKey") & " And [规格] = '" & mr("规格") & "'", "[_SortKey] Desc")
            If dr Is Nothing Then
                mr("库存") = mr("入库") - mr("出库")
                dr = mr
            End If
            drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [规格] = '" & dr("规格") & "'", "[_SortKey]")
            For i As Integer = 1 To drs.Count - 1
                drs(i)("库存") = drs(i-1)("库存") + drs(i)("入库") - drs(i)("出库")
            Next
            If e.DataCol.Name = "规格" AndAlso e.OldValue IsNot Nothing AndAlso e.OldValue <> e.NewValue Then
                dr = e.DataTable.Find("[_SortKey] < " & mr("_SortKey") & " And [规格] = '" & e.OldValue & "'", "[_SortKey] Desc")
                If dr Is Nothing Then
                    dr = e.DataTable.Find("[规格] = '" & e.OldValue & "'", "[_SortKey]")
                    If dr IsNot Nothing Then
                        dr("库存") = dr("入库") - dr("出库")
                    End If
                End If
                If dr IsNot Nothing Then
                    drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [规格] = '" & dr("规格") & "'", "[_SortKey]")
                    For i As Integer = 1 To drs.Count - 1
                        drs(i)("库存") = drs(i-1)("库存") + drs(i)("入库") - drs(i)("出库")
                    Next
                End If
            End If
    End Select
End If

全局变量改为整数型，0、1、2分别表示大类、中类、小类

看看：

http://www.foxtable.com/help/topics/2381.htm