Datacolchanged事件代码
If e.DataCol.Name = "保洁员" Then
Dim cns() As String = {"一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月"}
If e.NewValue = Nothing Then
For Each cn As String In cns
e.DataRow(cn) = Nothing
Next
Else
Dim filter As String = "(保洁员 = '" & e.DataRow("保洁员") & "' or 保洁员 like '%," & e.DataRow("保洁员") & "' or 保洁员 like '%," & e.DataRow("保洁员") & ",%' or 保洁员 like '" & e.DataRow("保洁员") & ",%')"
For i As Integer = 0 To cns.Length - 1
Dim d As Date = new Date(Date.Today.Year, i+1, 1)
e.DataRow(cns(i)) = DataTables("派工表").compute("sum(人均价)", filter & " and 日期 >= #" & d & "# and 日期 < #" & d.AddMonths(1) & "#")
Next
End If
End If