以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 按照treeview的结果进行筛选 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=116361) |
-- 作者:lur320 -- 发布时间:2018/3/23 11:37:00 -- 按照treeview的结果进行筛选 Dim times As new List(of Date) Dim tr As WinForm.TreeView=e.Form.Controls("TreeView1") For Each nd As WinForm.TreeNode In tr.AllNodes If nd.Level=1 AndAlso nd.Checked=True Then times.Add(CDate(nd.name)) End If Next ‘’将treeview的选择的日期组成一列 问题在于最后一行,怎么在当前列筛选出日期等于treeview选中的那些行? CurrentTable.filter="\'" & CurrentTable.Cols(CurrentTable.ColSel) & "In" & times & "\'"
|
-- 作者:有点甜 -- 发布时间:2018/3/23 11:47:00 -- Dim tr As WinForm.TreeView=e.Form.Controls("TreeView1") Dim str As String = "1=2" Dim name As String = CurrentTable.Cols(CurrentTable.ColSel).name For Each nd As WinForm.TreeNode In tr.AllNodes If nd.Level=1 AndAlso nd.Checked=True Then str &= " or " & name & " = #" & CDate(nd.name) & "#" End If Next msgbox(str) CurrentTable.filter=str |
-- 作者:lur320 -- 发布时间:2018/3/23 11:49:00 -- 好吧,组成一个超长的string判断语句。。。。 |