Foxtable(狐表)用户栏目专家坐堂 → 关于项目打开不加载数据


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

主题:关于项目打开不加载数据

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


加好友 发短信
等级:三尾狐 帖子:660 积分:3965 威望:0 精华:0 注册:2014/3/16 20:34:00
关于项目打开不加载数据  发帖心情 Post By:2014/5/1 7:58:00 [显示全部帖子]

我的项目打开我希望不加载任何数据,以下是我的所有表,我在BeforeLoadOuterTable,写的代码~~~~~~~~~~~~~~~~~~~~这样是可行了,但我感觉有一点累赘,是否有更好的更简单的代码??


Select Case e.DataTableName
     Case "订单" 
            e.SelectString = "Select * From {订单} Where [_Identify] Is Null"
     Case "人员" 
            e.SelectString = "Select * From {人员} Where [_Identify] Is Null"
     Case "经销商信息" 
            e.SelectString = "Select * From {经销商信息} Where [_Identify] Is Null"
     Case "专卖店目标" 
            e.SelectString = "Select * From {专卖店目标} Where [_Identify] Is Null"
     Case "专卖店签约" 
            e.SelectString = "Select * From {专卖店签约} Where [_Identify] Is Null"
     Case "产品VLOOKUP" 
            e.SelectString = "Select * From {产品VLOOKUP} Where [_Identify] Is Null"
     Case "文具领用" 
            e.SelectString = "Select * From {文具领用} Where [_Identify] Is Null"
     Case "目标" 
            e.SelectString = "Select * From {目标} Where [_Identify] Is Null"
     Case "个案申请" 
            e.SelectString = "Select * From {个案申请} Where [_Identify] Is Null"
     Case "文件管理" 
            e.SelectString = "Select * From {文件管理} Where [_Identify] Is Null"
     Case "文具明细" 
            e.SelectString = "Select * From {文具明细} Where [_Identify] Is Null"
     Case "行政区域" 
            e.SelectString = "Select * From {行政区域} Where [_Identify] Is Null"
     Case "企业信息" 
            e.SelectString = "Select * From {企业信息} Where [_Identify] Is Null"
End Select

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


加好友 发短信
等级:三尾狐 帖子:660 积分:3965 威望:0 精华:0 注册:2014/3/16 20:34:00
  发帖心情 Post By:2014/5/1 8:28:00 [显示全部帖子]

谢谢各位,已经解决了~~FOXTABEL真好~

 回到顶部