Dim idx As String = "-1,"
Dim idx_temp As String = ""
Dim pdr As DataRow = Nothing
Dim count As Integer = 0
Dim cs As String = "产品信息"
For Each dr As DataRow In DataTables("成品库存动态表").Select("", cs & " desc ")
Dim flag As Boolean = False
If pdr IsNot Nothing Then
If pdr(cs).length >= 8 AndAlso dr(cs).length >= 8 AndAlso pdr(cs).substring(8) <> dr(cs).substring(8) Then
flag = True
End If
End If
If flag Then
If count > 1 Then
idx &= idx_temp
End If
count = 1
idx_temp = ""
Else
count += 1
idx_temp &= dr("_Identify") & ","
End If
pdr = dr
Next
If count > 1 Then
idx &= idx_temp
End If
Tables("成品库存动态表").filter = "_Identify not in (" & idx.trim(",") & ")"