Foxtable(狐表)用户栏目专家坐堂 → 求助关于窗口加载数据的权限设置问题


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

主题:求助关于窗口加载数据的权限设置问题

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


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

这段,改成

 

f Filter > "" Then

    DataTables("佣金明细").LoadFilter = Filter
    DataTables("佣金明细").Load
End If
 
改成
 
If Filter > "" Then
    If User.Group = "行政部" Then
        filter = filter
    ElseIf User.Group = "一片区" Then
        filter = filter & " and 所属区域 = '" & User.Group & "'"
    ElseIf User.Group = "二片区" Then
        filter = filter & " and 所属区域 = '" & User.Group & "'"
    ElseIf User.Group = "三片区" Then
        filter = filter & " and 所属区域 = '" & User.Group & "'"
    ElseIf User.Group = "店面经理" Then
        filter = filter & " and 店面经理 = '" & User.Name & "'"
    ElseIf User.Name = "开发者" Then
        filter = filter
    Else
        filter = filter & " and 置业顾问 = '" & User.Name & "'"
    End If
    DataTables("佣金明细").LoadTop = 20
    DataTables("佣金明细").LoadPage = 0
   
   
    DataTables("佣金明细").LoadFilter = Filter
    DataTables("佣金明细").Load
End If

 回到顶部