Dim lst As New List(Of String)
dim a as string
For Each s As String In DataTables("进货退货201609").SQLGetComboListString("对账品名", "[对账品名] <>'" & dr("对账品名") & "' And 店名= '" & dr("店名") & "'").Replace(",", "|").split("|")
If lst.count = 0 Then
lst.add("[" & dr("对账品名") & "]")
a = dr("对账品名")
Else
If lst.contains(s) = False Then
lst.add(s)
End If
End If
Next
.AddSelect("对账品名", "对账品名", String.join("|", lst.toarray)).Attribute = """
.AddSelect("对账品类", "对账品类", DataTables("进货退货201609").SQLGetComboListString("对账品类", "[对账品名] ='" & a & "' And 店名= '" & dr("店名") & "'"))
End With