以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 关于按一组文本筛选后按再按该文本排序 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=170890) |
-- 作者:wangglby -- 发布时间:2021/8/10 16:09:00 -- 关于按一组文本筛选后按再按该文本排序 用以下代码用TEXTBOX1的多行数值,在表A里筛选并加载多行数据,希望加载后的数据按TEXTBOX中的文本顺序进行排序,应该怎么改下代码?
Dim s11 As String
Dim lst1 As new List(of String)
Dim filter2 As String = "1=2"
With Forms("窗口1").Controls("textbox1")
For i1 As Integer = 0 To .Lines.Length - 1
s11 = .Lines(i1)
lst1.add(s11)
Next
End With
If s11 IsNot Nothing Then
Dim filter1 As String = "编码 in (\'" & String.join("\',\'",lst1) & "\')"
Dim dra As List(Of DataRow) = DataTables("表A").SQLSelect( filter1)
Dim lst As new List(of String)
If dra.Count > 0 Then
For i As Integer = 0 To dra.Count-1
Dim a As String =dra(i)("编码")
lst.add(a)
Next
End If
Dim s1() As String = lst.ToArray
Dim filter As String = "1=2"
For Each s As String In s1
filter = filter & " or 编码 like \'" & s & "%\'"
Next
DataTables("表A").loadFilter = filter
DataTables("表A").load
End If
|
-- 作者:有点蓝 -- 发布时间:2021/8/10 16:21:00 -- 这个没有办法 |