Foxtable(狐表)用户栏目专家坐堂 → [求助]模糊查询


  共有2051人关注过本帖树形打印复制链接

主题:[求助]模糊查询

帅哥哟,离线,有人找我吗?
foxtable-im
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:婴狐 帖子:25 积分:263 威望:0 精华:0 注册:2016/2/14 14:45:00
[求助]模糊查询  发帖心情 Post By:2016/4/7 18:08:00 [显示全部帖子]


图片点击可在新窗口打开查看此主题相关图片如下:查询.png
图片点击可在新窗口打开查看
客户输入框内怎么实现模糊查询

Dim nms() As String = {"ComboBox1","ComboBox2","ComboBox3","ComboBox4","DateTimePicker1","DateTimePicker2"}
Dim sps() As String = {"'","'","'","'","#","#"}
Dim bjf() As String = {" = "," = "," = "," = "," >= "," <= "}
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
Tables("固网客户信息").filter = filter


 回到顶部
帅哥哟,离线,有人找我吗?
foxtable-im
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:婴狐 帖子:25 积分:263 威望:0 精华:0 注册:2016/2/14 14:45:00
  发帖心情 Post By:2016/4/7 19:51:00 [显示全部帖子]

还是不会,请帮忙修改,谢谢!


 回到顶部
帅哥哟,离线,有人找我吗?
foxtable-im
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:婴狐 帖子:25 积分:263 威望:0 精华:0 注册:2016/2/14 14:45:00
  发帖心情 Post By:2016/4/7 21:51:00 [显示全部帖子]

客户栏处可以模糊查询了,但会弹出窗体,是否可以取消掉这个弹出框。


图片点击可在新窗口打开查看此主题相关图片如下:窗体.png
图片点击可在新窗口打开查看

 回到顶部