Foxtable(狐表)用户栏目专家坐堂 → filter 最近10条记录


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

主题:filter 最近10条记录

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


加好友 发短信
等级:超级版主 帖子:13837 积分:69650 威望:0 精华:0 注册:2016/11/1 14:42:00
  发帖心情 Post By:2017/3/9 16:55:00 [显示全部帖子]

Dim ezch As WinForm.TextBox = e.Form.Controls("账车号")
Dim drs As List(Of DataRow)
Dim filter As String
drs = DataTables("明细").Select("车号 ='" & ezch.Value & "'", "日期 desc")
Dim count As Integer = 0
For Each dr As DataRow In drs
    If count >= 10 Then
        Exit For
    End If
    count += 1
    If filter = "" Then
        filter = "_Identify=" & dr("_Identify") & ""
    End If
    filter = filter & " Or " & "_Identify='" & dr("_Identify") & "'"
Next
Tables("查询_查询表").filter= filter

 回到顶部