Foxtable(狐表)用户栏目专家坐堂 → 纠结啊 父表与子表同步加载 代码执行一直出现错误


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

主题:纠结啊 父表与子表同步加载 代码执行一直出现错误

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


加好友 发短信 一级勋章
等级:超级版主 帖子:7235 积分:40556 威望:0 精华:16 注册:2008/8/31 23:23:00
  发帖心情 Post By:2013/1/21 0:52:00 [显示全部帖子]

If DataTables("业务表").DataRows.Count = 0 Then
    DataTables("诉讼表").LoadFilter = "[业务编号] Is Null"

    DataTables("非诉表").LoadFilter = "[业务编号] Is Null"
    DataTables("费用表").LoadFilter = "[业务编号] Is Null"

    DataTables("fa piao表").LoadFilter = "[业务编号] Is Null"
    DataTables("日程表").LoadFilter = "[业务编号] Is Null"

Else 
    Dim ids As String = "'"
    For Each dr As DataRow In DataTables("业务表").DataRows
         ids = ids & "','" & dr("业务编号") & "'"
    Next
    DataTables("诉讼表").LoadFilter = "[业务编号] In (" & ids & ")"
    DataTables("非诉表").LoadFilter = "[业务编号] In (" & ids & ")"
    DataTables("费用表").LoadFilter = "[业务编号] In (" & ids & ")"
    DataTables("fa piao表").LoadFilter = "[业务编号] In (" & ids & ")"
    DataTables("日程表").LoadFilter = "[业务编号] In (" & ids & ")"
End If

DataTables("诉讼表").Load()
DataTables("非诉表").Load()
DataTables("费用表").Load()
DataTables("fa piao表").Load()
DataTables("日程表").Load()


 回到顶部