- Foxtable(狐表) (http://foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2)
---- 关键字筛选 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=172233)
-- 发布时间：2021/9/30 14:38:00
-- 关键字筛选
Dim txt As String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("主控窗口_Table2")
If txt = "" Then
tbl.Filter = ""
Else
txt = "\'%" & txt & "%\'"
tbl.Filter = "店铺名称 Like " & txt & " Or 单号 Like " & txt & " Or 处理人 Like " & txt & " Or 发货仓库 Like" & txt & " Or 物流公司 Like" & txt & " Or 赠送SKU Like" & txt & " Or 客户姓名 Like" & txt & " Or 系统单号 Like" & txt & " Or 产品类别 Like " & txt & " Or 配件SKU Like " & txt & " Or 产品SKU Like " & txt & " Or 联系方式 Like " & txt & " Or 追踪号 Like " & txt & " Or 处理方式 Like " & txt & " Or 备注 Like " & txt & " Or 回访 Like" & txt & " Or 状态 Like" & txt & " Or 寄送地址 Like " & txt & " Or [状况描述 原因] Like " & txt
End If
-- 发布时间：2021/9/30 14:40:00
--
老师您好，我想咨询一下关键字筛选的一个小问题，就是如果我有多个关键字要在TextBox1的框里筛选嘛，能不能就是已，隔开筛选得出结果
-- 发布时间：2021/9/30 14:43:00
--
使用Split拆分，然后遍历：http://www.foxtable.com/webhelp/topics/0245.htm
-- 发布时间：2021/9/30 14:49:00
--
emmm遍历了就可以or组合在一起吗
-- 发布时间：2021/9/30 14:54:00
--
测试咯，有问题再说
-- 发布时间：2021/9/30 15:09:00
--
Dim txt1 As String = e.Form.Controls("TextBox1").Text
Dim Values() As String
Values = txt1.split(",")
For Index As Integer = 0 To Values.Length - 1
Dim txt As String =Values(Index)
Dim tbl As Table = Tables("主控窗口_Table2")
If txt = "" Then
tbl.Filter = ""
Else
txt = "\'%" & txt & "%\'"
tbl.Filter = "店铺名称 Like " & txt & " Or 单号 Like " & txt & " Or 处理人 Like " & txt & " Or 发货仓库 Like" & txt & " Or 物流公司 Like" & txt & " Or 赠送SKU Like" & txt & " Or 客户姓名 Like" & txt & " Or 系统单号 Like" & txt & " Or 产品类别 Like " & txt & " Or 配件SKU Like " & txt & " Or 产品SKU Like " & txt & " Or 联系方式 Like " & txt & " Or 追踪号 Like " & txt & " Or 处理方式 Like " & txt & " Or 备注 Like " & txt & " Or 回访 Like" & txt & " Or 状态 Like" & txt & " Or 寄送地址 Like " & txt & " Or [状况描述 原因] Like " & txt
End If
Next
-- 发布时间：2021/9/30 15:10:00
--
两个条件在关键字筛选不出
-- 发布时间：2021/9/30 15:22:00
--
Dim txt1 As String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("主控窗口_Table2")
If txt1 = "" Then
tbl.Filter = ""
Else
Dim Values() As String
Values = txt1.split(",")
dim f as string
For Index As Integer = 0 To Values.Length - 1
if f > "" then f = f & " or "
Dim txt As String =Values(Index)
txt = "\'%" & txt & "%\'"
f = f & "店铺名称 Like " & txt & " Or 单号 Like " & txt & " Or 处理人 Like " & txt & " Or 发货仓库 Like" & txt & " Or 物流公司 Like" & txt & " Or 赠送SKU Like" & txt & " Or 客户姓名 Like" & txt & " Or 系统单号 Like" & txt & " Or 产品类别 Like " & txt & " Or 配件SKU Like " & txt & " Or 产品SKU Like " & txt & " Or 联系方式 Like " & txt & " Or 追踪号 Like " & txt & " Or 处理方式 Like " & txt & " Or 备注 Like " & txt & " Or 回访 Like" & txt & " Or 状态 Like" & txt & " Or 寄送地址 Like " & txt & " Or [状况描述 原因] Like " & txt
Next
End If
msgbox(f)
tbl.Filter = f
-- 发布时间：2021/9/30 15:32:00
--
这个是不是改个变量
此主题相关图片如下：112.jpg
-- 发布时间：2021/9/30 15:38:00
--
Dim txt1 As String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("主控窗口_Table2")
If txt1 = "" Then
tbl.Filter = ""
Else
Dim Values() As String
Values = txt1.split(",")
Dim f As String
For Index As Integer = 0 To Values.Length - 1
If f > "" Then f = f & " or "
Dim txt As String =Values(Index)
txt = "\'%" & txt & "%\'"
f = f & "店铺名称 Like " & txt & " Or 单号 Like " & txt & " Or 处理人 Like " & txt & " Or 发货仓库 Like" & txt & " Or 物流公司 Like" & txt & " Or 赠送SKU Like" & txt & " Or 客户姓名 Like" & txt & " Or 系统单号 Like" & txt & " Or 产品类别 Like " & txt & " Or 配件SKU Like " & txt & " Or 产品SKU Like " & txt & " Or 联系方式 Like " & txt & " Or 追踪号 Like " & txt & " Or 处理方式 Like " & txt & " Or 备注 Like " & txt & " Or 回访 Like" & txt & " Or 状态 Like" & txt & " Or 寄送地址 Like " & txt & " Or [状况描述 原因] Like " & txt
Next
msgbox(f)
tbl.Filter = f
End If