主题：计算工时的难题，同一天多次出工，只计算一次。附例子

此主题相关图片如下：tongji1.jpg

呵呵 和我遇到的问题一样,就是如何按姓名统计的问题, 如图: 按姓名应该是1人,统计得出的却是2人, n =dt.Compute("count(参与员工)",s1) 只能得到人次 ,我也想知道答案.

相当复杂:

Dim dic As New Dictionary(of Date,List(of String))
Dim dic2 As new Dictionary(of String,Integer)
For Each dr As DataRow In DataTables("表A").DataRows
    Dim dt As Date = dr("工程时间")
    Dim lst As List(of String)
    If dic.ContainsKey(dt) = False
        lst = new List(of String)
        dic.add(dt,lst)
    Else
        lst = dic(dt)
    End If
    Dim nms() As String = dr("参与员工").Split(",")
    For Each nm As String In nms
        If lst.Contains(nm) = False Then
            lst.Add(nm)
        End If
    Next
Next
For Each lst As List(of String) In dic.Values
    For Each nm As String In lst
        If dic2.ContainsKey(nm) = False Then
            dic2.Add(nm,1)
        Else
            dic2(nm) = dic2(nm) + 1
        End If
    Next
Next
For Each nm As String In dic2.Keys
    output.show(nm & ":" & dic2(nm))
Next