If e.DataCol.Name = "款类" Then Dim nms() As String = { "开胚","跟形","跟重","网底","手工序","通花","瓜子耳","跟电雕" } Dim dt As DataRow= e.DataRow Dim LVS As String = dt("级別") If e.NewValue Is Nothing Then dt("A") = Nothing Else dt("A") = Nothing For Each nm As String In nms Dim col As String = dt(nm) dt("A") = dt("A") + DataTables("工价1").Compute( "sum(" & nm & LVS & ")*" & col ,"[款类] = '" & e.NewValue & "'") Next dt("A") = dt("A") + dt("加收_工值") End If End If