有点蓝老师现在同一个数据行之间的问题OK了
不同数据行之间 现在运行貌似 如果没有相同的数据 就会提示如图错误 【麻烦老师继续指导下 谢谢!】
![dvubb 图片点击可在新窗口打开查看](skins/default/filetype/png.gif)
此主题相关图片如下:1.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2021-10/202110251655057750.png)
当前不同行数据的确定筛选代码如下:
Dim s As String
Dim l As WinForm.CheckedListBox = e.Form.Controls("CheckedListBox1")
For Each Index As Integer In l.CheckedIndices
s = s & "," & l.Items(Index)
Next
s = s.trim(",")
Dim cs As String = s
Dim idx As String = ""
Dim lst As new List(of String)
Dim flag As Boolean
Dim drs As List(Of DataRow) = DataTables("表A").Select("第一列 is not null", cs)
Dim pdr As DataRow = drs(0)
Dim dr As DataRow
For i As Integer = 1 To drs.count - 1
dr = drs(i)
flag = False
For Each c As String In cs.split(",")
If pdr(c) <> dr(c) Then
flag = True
Exit For
End If
Next
If flag = False Then
If lst.Contains(pdr("_Identify")) = False
lst.add( pdr("_Identify") )
End If
lst.add( dr("_Identify") )
End If
pdr = dr
Next
If lst.count > 0 Then
idx = String.Join(",",lst.ToArray)
End If
Tables("表A").filter = "第一列 is not null and _Identify not in (" & idx.trim(",") & ") "