Dim dr As DataRow = e.DataRow
Dim dt As Table = Tables("证书编号表")
If e.DataCol.Name = "申报鉴定工种" Then
dr("取得证书人数_初级工") = dt.Compute("Count(姓名)", "鉴定等级 = '初级工' and 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
dr("取得证书人数_中级工") = dt.Compute("Count(姓名)", "鉴定等级 = '中级工' and 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
dr("取得证书人数_高级工") = dt.Compute("Count(姓名)", "鉴定等级 = '高级工' And 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
dr("取得证书人数_技师") = dt.Compute("Count(姓名)", "鉴定等级 = '技师' and 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
dr("取得证书人数_高级技师") = dt.Compute("Count(姓名)", "鉴定等级 = '高级技师' And 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
End If
Dim dr As DataRow = e.DataRow
Dim dt As Table = Tables("报名登记表")
If e.DataCol.Name = "申报鉴定工种" Then
dr("鉴定考核人数_初级工") = dt.Compute("Count(姓名)", "鉴定等级 = '初级工' and 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
dr("鉴定考核人数_中级工") = dt.Compute("Count(姓名)", "鉴定等级 = '中级工' and 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
dr("鉴定考核人数_高级工") = dt.Compute("Count(姓名)", "鉴定等级 = '高级工' And 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
dr("鉴定考核人数_技师") = dt.Compute("Count(姓名)", "鉴定等级 = '技师' and 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
dr("鉴定考核人数_高级技师") = dt.Compute("Count(姓名)", "鉴定等级 = '高级技师' And 申报鉴定工种 = '" & dr("申报鉴定工种") & "'" )
End If
End If
甜版,简单加代码报错,是不是还要加代码?