Foxtable(狐表)用户栏目专家坐堂 → 条件加载数据


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

主题:条件加载数据

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


加好友 发短信
等级:二尾狐 帖子:496 积分:4055 威望:0 精华:0 注册:2017/7/5 16:15:00
条件加载数据  发帖心情 Post By:2018/5/16 15:13:00 [只看该作者]

只要输入一个条件
以下代码怎么不加载数据。

空白时,会加载所有数据的。

Dim nms() As String = {"S材料名称","S产品名称","S调配人","S调制墨名称","S机台编码","S机台名称","S墨桶编号"}
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

DataTables("调制墨信息").LoadFilter = filter
DataTables("调制墨信息").Load()

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


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/5/16 15:16:00 [只看该作者]


Dim nms() As String = {"S材料名称","S产品名称","S调配人","S调制墨名称","S机台编码","S机台名称","S墨桶编号"}
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)).text <> 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
msgbox(filter)
DataTables("调制墨信息").LoadFilter = filter
DataTables("调制墨信息").Load()

 回到顶部