主题：高效流水账问题

 加入工序名称条件即可

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("产品") & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey] Desc")
        If dr Is Nothing Then
            mr("累计完成") = mr("生产数量")
            dr = mr
        End If
        drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [产品] = '" & dr("产品") & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey]")
        For i As Integer = 1 To drs.Count - 1
            drs(i)("累计完成") = drs(i-1)("累计完成") + 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 & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey] Desc")
            If dr Is Nothing Then
                dr = e.DataTable.Find("[产品] = '" & e.OldValue & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey]")
                If dr IsNot Nothing Then
                    dr("累计完成") = dr("生产数量")
                End If
            End If
            If dr IsNot Nothing Then
                drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [产品] = '" & dr("产品") & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey]")
                For i As Integer = 1 To drs.Count - 1
                    drs(i)("累计完成") = drs(i-1)("累计完成") + drs(i)("生产数量")      
          Next
            End If
        End If
End Select

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("产品") & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey] Desc")
        If dr Is Nothing Then
            mr("累计完成") = mr("生产数量")
            dr = mr
        End If
        drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [产品] = '" & dr("产品") & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey]")
        For i As Integer = 1 To drs.Count - 1
            drs(i)("累计完成") = drs(i-1)("累计完成") + 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 & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey] Desc")
            If dr Is Nothing Then
                dr = e.DataTable.Find("[产品] = '" & e.OldValue & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey]")
                If dr IsNot Nothing Then
                    dr("累计完成") = dr("生产数量")
                End If
            End If
            If dr IsNot Nothing Then
                drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [产品] = '" & dr("产品") & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey]")
                For i As Integer = 1 To drs.Count - 1
                    drs(i)("累计完成") = drs(i-1)("累计完成") + drs(i)("生产数量")
                Next
            End If
        End If
    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("产品") & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey] Desc")
        If dr Is Nothing Then
            mr("累计完成") = mr("生产数量")
            dr = mr
        End If
        drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [产品] = '" & dr("产品") & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey]")
        For i As Integer = 1 To drs.Count - 1
            drs(i)("累计完成") = drs(i-1)("累计完成") + 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.DataRow("产品") & "' and 工序名称 = '" & e.OldValue & "'", "[_SortKey] Desc")
            If dr Is Nothing Then
                dr = e.DataTable.Find("[产品] = '" & e.DataRow("产品") & "' and 工序名称 = '" & e.OldValue & "'", "[_SortKey]")
                If dr IsNot Nothing Then
                    dr("累计完成") = dr("生产数量")
                End If
            End If
            If dr IsNot Nothing Then
                drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [产品] = '" & dr("产品") & "' and 工序名称 = '" & e.DataRow("工序名称") & "'", "[_SortKey]")
                For i As Integer = 1 To drs.Count - 1
                    drs(i)("累计完成") = drs(i-1)("累计完成") + drs(i)("生产数量")
                Next
            End If
        End If
       
End Select