以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.net/bbs/index.asp)
--  专家坐堂  (http://foxtable.net/bbs/list.asp?boardid=2)
----  代码求助  (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=147089)

--  作者:段虎成
--  发布时间:2020/3/9 18:13:00
--  代码求助

老师您好,下面这段代码,其中第三行 like (客户信息_行业类别)链接符我应该怎么写?谢谢。

\'设置数据加载条件
Dim nms() As String = {"DateTimePicker1","DateTimePicker2","ComboBox1","ComboBox3","TextBox1","ComboBox2","TextBox2"}
Dim sps() As String = {"\'","\'","\'","\'","\'","\'","\'","\'"}
Dim bjf() As String = {" >= "," <= "," = "," = "," like "," = "," = "}
Dim fds() As String = {"认证日期","认证日期","客户区域_省或直辖市","客服分配_分配状态","客户信息_行业类别","客服分配_客服小组","客服分配_客服人员"}
Dim Filter As String
For i As Integer = 0 To nms.length - 1
    If e.Form.Controls(nms(i)).Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " and "
        End If
        Filter = Filter & fds(i) & bjf(i) & sps(i) & e.Form.Controls(nms(i)).value & sps(i)
    End If
Next


--  作者:有点蓝
--  发布时间:2020/3/9 20:38:00
--  
like单独拿出来处理。有时候不是所有的功能都能合并到一起使用的。该分开处理的就要分开
--  作者:段虎成
--  发布时间:2020/3/9 21:18:00
--  
好的老师谢谢!