Select Case e.DataCol.Name
Case"年月","员工" ',"交单"
If e.DataRow.IsNull("年月") OrElse e.DataRow.IsNull("员工") Then
e.DataRow("金额") =Nothing
Else
Dim Filter As String = "[年月] = '" & e.DataRow("年月") & "' And [交单] = true and ',' + 员工 + ',' like '%," & e.DataRow("员工") & ",%'"
e.DataRow("金额") = DataTables("派单").SQLCompute("Sum(人均值)", Filter)
End If
End Select
增加一个判定条件:统计表里的数据是通过派单表计算出来的,例如:统计表增加一列,【审批】,如果已审批,统计表的数据,就不重新计算了。该怎么修改代码呢?