看看有什么错误提示?
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