老师,下面代码的“年度合计”列的结果总是要重置列后才能有计算的数据。
Dim dr As DataRow = e.DataRow
Select Case e.DataCol.Name
Case "M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12"
If dr.IsNull("M1") OrElse dr.IsNull("M2") OrElse dr.IsNull("M3") OrElse dr.IsNull("M4") OrElse dr.IsNull("M5") OrElse dr.IsNull("M6") OrElse dr.IsNull("M7") OrElse dr.IsNull("M8") OrElse dr.IsNull("M9") OrElse dr.IsNull("M10") OrElse dr.IsNull("M11") OrElse dr.IsNull("M12") Then
dr("年度合计") = Nothing
Else
dr("年度合计") = dr("M1") + dr("M2") + dr("M3") + dr("M4") + dr("M5") + dr("M6") + dr("M7") + dr("M8") + dr("M9") + dr("M10") + dr("M11") + dr("M12")
End If
End Select