Foxtable(狐表)用户栏目专家坐堂 → [求助]为何没有根据后台数据操作


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

主题:[求助]为何没有根据后台数据操作

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


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/9/19 10:46:00 [显示全部帖子]

没看懂你要表达什么,报错?

 

Dim str0 As New List (Of String)
Dim str1 As New List (Of String)
Dim id0,id1,flt,celltext As String

For Each dr As DataRow In DataTables("表B").dataRows
    If dr("任务").StartsWith("#") =True Then
        Dim mc = System.Text.RegularExpressions.Regex.Matches(dr("任务"), "[#0-9]+")
       
        celltext=Nothing
        'For i As Integer = 0 To Lmst.Length-1
        celltext = mc(0).value
        'Next
        If str0.Contains(celltext) =False Then
            id0 + = dr("_Identify") & ","
        Else
            str1.Add(celltext)
        End If
        str0.Add(celltext)
    End If
Next
msgbox(id0)
'++++++++++++++++++++++++++++++++
For Each dr As DataRow In DataTables("表B").dataRows
    If dr("任务").StartsWith("#") =True Then
        Dim mc = System.Text.RegularExpressions.Regex.Matches(dr("任务"), "[#0-9]+")
        celltext=Nothing
        'For i As Integer = 0 To Lmst.Length-1
        celltext= mc(0).value
        'Next
       
        If str1.Contains(celltext) Then
            id1 + = dr("_Identify") & ","
        End If
    End If
Next
msgbox(id1)
'+++++++++++++++++++++++++++++++++
If id1 > "" Then
    id1 = id1.Trim(",")
    flt = "[_Identify] In (" & id1 & ")"
End If

msgbox(flt)
DataTables("表B").loadFilter = flt
DataTables("表B").load()


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


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/9/19 11:21:00 [显示全部帖子]

Dim str0 As New List (Of String)
Dim str1 As New List (Of String)
Dim id0,id1,flt,celltext As String
Dim drs = DataTables("表B").sqlselect("")
For Each dr As DataRow In drs
    If dr("任务").StartsWith("#") =True Then
        Dim mc = System.Text.RegularExpressions.Regex.Matches(dr("任务"), "[#0-9]+")
       
        celltext=Nothing
        'For i As Integer = 0 To Lmst.Length-1
        celltext = mc(0).value
        'Next
        If str0.Contains(celltext) =False Then
            id0 + = dr("_Identify") & ","
        Else
            str1.Add(celltext)
        End If
        str0.Add(celltext)
    End If
Next
msgbox(id0)
'++++++++++++++++++++++++++++++++
For Each dr As DataRow In drs
    If dr("任务").StartsWith("#") =True Then
        Dim mc = System.Text.RegularExpressions.Regex.Matches(dr("任务"), "[#0-9]+")
        celltext=Nothing
        'For i As Integer = 0 To Lmst.Length-1
        celltext= mc(0).value
        'Next
       
        If str1.Contains(celltext) Then
            id1 + = dr("_Identify") & ","
        End If
    End If
Next
msgbox(id1)
'+++++++++++++++++++++++++++++++++
If id1 > "" Then
    id1 = id1.Trim(",")
     flt = "[_Identify] In (" & id1 & ")"
End If

msgbox(flt)
DataTables("表B").LoadTop = ""
DataTables("表B").loadFilter = flt
DataTables("表B").load()


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


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/9/19 14:59:00 [显示全部帖子]

1、进度条是无法做到的。load数据的时候,无法获取进度。

 

2、建议直接用文字提示,如 http://www.foxtable.com/webhelp/scr/1476.htm

 


 回到顶部