主题：列累加

没有哪位肯帮忙呀

 

 

你自己看看日期列的变量写法,而且老大的例子在的,多加一些条件就可以了.

如果现在能能写出来，就不需要找师傅呀，只能边用边学。

 

看看有什么错误提示?

 

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 班次 ='" & mr("班次") & "' And 日期 = # " & mr("日期") & "#", "[_SortKey] Desc")
        If dr Is Nothing Then
            mr("本班合计") = mr("应加工数")
            dr = mr
        End If
        drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [组长] = '" & dr("组长") & "'And 班次 ='" & dr("班次") & "' And 日期 = # " & dr("日期") & "#", "[_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.OldValue & "' And 日期 = # " & e.OldValue & "#", "[_SortKey] Desc")
            If dr Is Nothing Then
                dr = e.DataTable.Find("[组长] = '" & e.OldValue & "' And 班次 ='" & e.OldValue & "' 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 班次 ='" & dr("班次") & "' And 日期 = # " & dr("日期") & "#", "[_SortKey]"), "[_SortKey]")
                For i As Integer = 1 To drs.Count - 1
                    drs(i)("本班合计") = drs(i-1)("本班合计") + drs(i)("应加工数")
                Next
            End If
        End If
End Select

师傅你好：

有错误：应为语句结束

错误代码：drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [组长] = '" & dr("组长") & "'And 班次 ='" & dr("班次") & "' And 日期 = # " & dr("日期") & "#", "[_SortKey]"), "[_SortKey]")

师傅你好

14楼代码有一个“产品”是错误的

"[_SortKey]")
  多了个这个,删除掉.

If e.DataCol.Name = "产品"   改成你自己的列名

师傅你好：

本班合计列只显示0

各位师傅好：烦请帮助整理一下,谢谢！

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 班次 ='" & mr("班次") & "' And 日期 = # " & mr("日期") & "#", "[_SortKey] Desc")
        If dr Is Nothing Then
            mr("本班合计") = mr("应加工数")
            dr = mr
        End If
        drs = e.DataTable.Select("[_SortKey] >= " & dr("_SortKey") & " And [组长] = '" & dr("组长") & "'And 班次 ='" & dr("班次") & "' And 日期 = # " & dr("日期") & "#", "[_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.OldValue & "' And 日期 = # " & e.OldValue & "#", "[_SortKey] Desc")
            If dr Is Nothing Then
                dr = e.DataTable.Find("[组长] = '" & e.OldValue & "' And 班次 ='" & e.OldValue & "' 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 班次 ='" & dr("班次") & "' And 日期 = # " & dr("日期") & "#", "[_SortKey]")
                For i As Integer = 1 To drs.Count - 1
                    drs(i)("本班合计") = drs(i-1)("本班合计") + drs(i)("应加工数")
                Next
            End If
        End If
End Select