以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  [求助]关于不同用户分组使用不同按钮的问题  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=66596)
--  作者：JK362223
--  发布时间：2015/4/10 9:47:00
--  [求助]关于不同用户分组使用不同按钮的问题
假设某个窗口中有“挂号收费”按钮1、“门诊部”按钮2、“住院部病历”按钮3、“财务部”按钮4、“财务部门诊报销”按钮5、“财务部住院报销”按钮6，现在职员A隶属“医疗部”，B隶属“财务部”，C隶属“行政办”，D隶属“药房部”。我现在想要的效果是：A打开窗口时，只显示按钮2和3，B只显示4、5和6，,D只显示1，而C全部按钮都显示。代码如下：
窗口AfterLoad事件：
If User.Group <> "医疗部" Then
    e.Form.Controls("Button2").Enabled = False
    e.Form.Controls("Button3").Enabled = False
    
End If

If User.Group <> "药房部" Then
    e.Form.Controls("Button1").Enabled = False
End If


If User.Group <> "财务部" Then
    e.Form.Controls("Button4").Enabled = False
    e.Form.Controls("Button5").Enabled = False
    e.Form.Controls("Button6").Enabled = False
End If


If User.Group <> "行政办" Then
    e.Form.Controls("Button1").Enabled = False
    e.Form.Controls("Button2").Enabled = False
    e.Form.Controls("Button3").Enabled = False
    e.Form.Controls("Button4").Enabled = False
    e.Form.Controls("Button5").Enabled = False
    e.Form.Controls("Button6").Enabled = False
End If

因为有穿插使用的原因，所以该代码达不到预想效果，还请老师帮忙修改下，谢谢！
--  作者：Bin
--  发布时间：2015/4/10 9:49:00
--  
比如医疗部  可用 按钮 23  禁用按钮 45

If User.Group <> "医疗部" Then
    e.Form.Controls("Button2").Enabled = True
    e.Form.Controls("Button3").Enabled = True
    e.Form.Controls("Button4").Enabled = False
    e.Form.Controls("Button5").Enabled = False
End If
--  作者：jk362223
--  发布时间：2015/4/10 11:30:00
--  
回楼上，依此代码格式还是不行，例子如下：
 下载信息  [文件大小：   下载次数： ]
图片点击可在新窗口打开查看点击浏览该文件:管理项目4.foxdb.zip

烦劳修改下。
--  作者：Bin
--  发布时间：2015/4/10 11:39:00
--  
代码不可能有问题,你要是禁用还是要隐藏
--  作者：JK362223
--  发布时间：2015/4/10 14:35:00
--  
是禁用。比如医疗部，按钮23可用，1456禁用；而行政办，按钮123456都可用。
--  作者：Bin
--  发布时间：2015/4/10 14:51:00
--  
如果你用IF 就要改为

if
else if 

else if 

否则你每个IF条件都进入,就会打乱效果

你也可以考虑用 Select Case 
--  作者：JK362223
--  发布时间：2015/4/10 15:25:00
--  
额，可以劳烦举下例子吗？新手，刚接触狐表，还是没有尝试成功。麻烦老师了！
--  作者：Bin
--  发布时间：2015/4/10 15:27:00
--  
If User.Group <> "医疗部" Then
    e.Form.Controls("Button2").Enabled = False
    e.Form.Controls("Button3").Enabled = False
     e.Form.Controls("Button4").Enabled = True
    e.Form.Controls("Button5").Enabled = True
Else if User.Group <> "药房部" Then
     e.Form.Controls("Button2").Enabled = True
    e.Form.Controls("Button3").Enabled = True
     e.Form.Controls("Button4").Enabled = False
    e.Form.Controls("Button5").Enabled = False
End If
--  作者：JK362223
--  发布时间：2015/4/10 16:06:00
--  
你看如下的代码哪里出错了呢，在窗口AfterLoad事件中填写，登陆不同用户界面显示的按钮还是没有达到预期的效果。

其中医疗部只显示按钮2、8、11、02，药房部只显示按钮1、07，实验室检查部只显示13、15，财务部显示3、14、08，门诊财务部显示14，住院财务部只显示08，护理部只显示02、09、03、04，后勤部只显示3、05、06、12，行政办显示全部的按钮。

If User.Group <> "医疗部" Then
    e.Form.Controls("Button1").Enabled = True
    e.Form.Controls("Button07").Enabled = True
    e.Form.Controls("Button7").Enabled = True
    e.Form.Controls("Button09").Enabled = True
    e.Form.Controls("Button03").Enabled = True
    e.Form.Controls("Button04").Enabled = True
    e.Form.Controls("Button13").Enabled = True
    e.Form.Controls("Button15").Enabled = True
    e.Form.Controls("Button14").Enabled = True
    e.Form.Controls("Button3").Enabled = True
    e.Form.Controls("Button08").Enabled = True
    e.Form.Controls("Button05").Enabled = True
    e.Form.Controls("Button06").Enabled = True
    e.Form.Controls("Button12").Enabled = True
    e.Form.Controls("Button2").Enabled = False    
    e.Form.Controls("Button8").Enabled = False   
    e.Form.Controls("Button11").Enabled = False   
    e.Form.Controls("Button02").Enabled = False


Else If User.Group <> "药房部" Then
    e.Form.Controls("Button2").Enabled = True
    e.Form.Controls("Button7").Enabled = True
    e.Form.Controls("Button8").Enabled = True
    e.Form.Controls("Button11").Enabled = True
    e.Form.Controls("Button02").Enabled = True
    e.Form.Controls("Button09").Enabled = True
    e.Form.Controls("Button03").Enabled = True
    e.Form.Controls("Button04").Enabled = True
    e.Form.Controls("Button13").Enabled = True
    e.Form.Controls("Button15").Enabled = True
    e.Form.Controls("Button14").Enabled = True
    e.Form.Controls("Button3").Enabled = True
    e.Form.Controls("Button08").Enabled = True
    e.Form.Controls("Button05").Enabled = True
    e.Form.Controls("Button06").Enabled = True
    e.Form.Controls("Button12").Enabled = True
    e.Form.Controls("Button1").Enabled = False    
    e.Form.Controls("Button07").Enabled = False  


Else If User.Group <> "实验室检查部" Then
    e.Form.Controls("Button1").Enabled = True
    e.Form.Controls("Button2").Enabled = True
    e.Form.Controls("Button07").Enabled = True
    e.Form.Controls("Button7").Enabled = True
    e.Form.Controls("Button8").Enabled = True
    e.Form.Controls("Button11").Enabled = True
    e.Form.Controls("Button02").Enabled = True
    e.Form.Controls("Button09").Enabled = True
    e.Form.Controls("Button03").Enabled = True
    e.Form.Controls("Button04").Enabled = True
    e.Form.Controls("Button14").Enabled = True
    e.Form.Controls("Button3").Enabled = True
    e.Form.Controls("Button08").Enabled = True
    e.Form.Controls("Button05").Enabled = True
    e.Form.Controls("Button06").Enabled = True
    e.Form.Controls("Button12").Enabled = True
    e.Form.Controls("Button13").Enabled = False    
    e.Form.Controls("Button15").Enabled = False    


Else If User.Group <> "财务部" Then
    e.Form.Controls("Button13").Enabled = True
    e.Form.Controls("Button15").Enabled = True
    e.Form.Controls("Button08").Enabled = True
     e.Form.Controls("Button1").Enabled = True
    e.Form.Controls("Button2").Enabled = True
    e.Form.Controls("Button07").Enabled = True
    e.Form.Controls("Button7").Enabled = True
    e.Form.Controls("Button8").Enabled = True
    e.Form.Controls("Button11").Enabled = True
    e.Form.Controls("Button02").Enabled = True
    e.Form.Controls("Button09").Enabled = True
    e.Form.Controls("Button03").Enabled = True
    e.Form.Controls("Button04").Enabled = True
    e.Form.Controls("Button05").Enabled = True
    e.Form.Controls("Button06").Enabled = True
    e.Form.Controls("Button12").Enabled = True
    e.Form.Controls("Button3").Enabled = False     
    e.Form.Controls("Button14").Enabled = False 
    e.Form.Controls("Button08").Enabled = False     


Else If User.Group <> "门诊财务部" Then
    e.Form.Controls("Button3").Enabled = True
    e.Form.Controls("Button13").Enabled = True
    e.Form.Controls("Button15").Enabled = True
    e.Form.Controls("Button08").Enabled = True
     e.Form.Controls("Button1").Enabled = True
    e.Form.Controls("Button2").Enabled = True
    e.Form.Controls("Button07").Enabled = True
    e.Form.Controls("Button7").Enabled = True
    e.Form.Controls("Button8").Enabled = True
    e.Form.Controls("Button11").Enabled = True
    e.Form.Controls("Button02").Enabled = True
    e.Form.Controls("Button09").Enabled = True
    e.Form.Controls("Button03").Enabled = True
    e.Form.Controls("Button04").Enabled = True
    e.Form.Controls("Button05").Enabled = True
    e.Form.Controls("Button06").Enabled = True
    e.Form.Controls("Button12").Enabled = True
    e.Form.Controls("Button14").Enabled = False 


Else If User.Group <> "住院财务部" Then
    e.Form.Controls("Button3").Enabled = True
    e.Form.Controls("Button13").Enabled = True
    e.Form.Controls("Button15").Enabled = True
    e.Form.Controls("Button14").Enabled = True
     e.Form.Controls("Button1").Enabled = True
    e.Form.Controls("Button2").Enabled = True
    e.Form.Controls("Button07").Enabled = True
    e.Form.Controls("Button7").Enabled = True
    e.Form.Controls("Button8").Enabled = True
    e.Form.Controls("Button11").Enabled = True
    e.Form.Controls("Button02").Enabled = True
    e.Form.Controls("Button09").Enabled = True
    e.Form.Controls("Button03").Enabled = True
    e.Form.Controls("Button04").Enabled = True
    e.Form.Controls("Button05").Enabled = True
    e.Form.Controls("Button06").Enabled = True
    e.Form.Controls("Button12").Enabled = True
    e.Form.Controls("Button08").Enabled = False  


Else If User.Group <> "护理部" Then
    e.Form.Controls("Button13").Enabled = True
    e.Form.Controls("Button15").Enabled = True
    e.Form.Controls("Button08").Enabled = True
     e.Form.Controls("Button1").Enabled = True
    e.Form.Controls("Button2").Enabled = True
    e.Form.Controls("Button07").Enabled = True
    e.Form.Controls("Button7").Enabled = True
    e.Form.Controls("Button8").Enabled = True
    e.Form.Controls("Button11").Enabled = True
    e.Form.Controls("Button3").Enabled = True
    e.Form.Controls("Button14").Enabled = True
    e.Form.Controls("Button05").Enabled = True
    e.Form.Controls("Button06").Enabled = True
    e.Form.Controls("Button12").Enabled = True
    e.Form.Controls("Button02").Enabled = False   
    e.Form.Controls("Button09").Enabled = False
    e.Form.Controls("Button03").Enabled = False
    e.Form.Controls("Button04").Enabled = False 


Else If User.Group <> "后勤部" Then
    e.Form.Controls("Button02").Enabled = True
    e.Form.Controls("Button09").Enabled = True
    e.Form.Controls("Button03").Enabled = True
    e.Form.Controls("Button04").Enabled = True
    e.Form.Controls("Button13").Enabled = True
    e.Form.Controls("Button15").Enabled = True
    e.Form.Controls("Button08").Enabled = True
     e.Form.Controls("Button1").Enabled = True
    e.Form.Controls("Button2").Enabled = True
    e.Form.Controls("Button07").Enabled = True
    e.Form.Controls("Button7").Enabled = True
    e.Form.Controls("Button8").Enabled = True
    e.Form.Controls("Button11").Enabled = True
    e.Form.Controls("Button3").Enabled = True
    e.Form.Controls("Button14").Enabled = True
    e.Form.Controls("Button05").Enabled = False   
    e.Form.Controls("Button06").Enabled = False
    e.Form.Controls("Button12").Enabled = False
    e.Form.Controls("Button3").Enabled = False


Else If User.Group <> "行政办" Then
    e.Form.Controls("Button1").Enabled = False    
    e.Form.Controls("Button2").Enabled = False   
    e.Form.Controls("Button07").Enabled = False   
    e.Form.Controls("Button7").Enabled = False
    e.Form.Controls("Button8").Enabled = False
    e.Form.Controls("Button11").Enabled = False
    e.Form.Controls("Button02").Enabled = False
    e.Form.Controls("Button09").Enabled = False
    e.Form.Controls("Button03").Enabled = False
    e.Form.Controls("Button04").Enabled = False
    e.Form.Controls("Button13").Enabled = False
    e.Form.Controls("Button15").Enabled = False
    e.Form.Controls("Button3").Enabled = False
    e.Form.Controls("Button14").Enabled = False
    e.Form.Controls("Button08").Enabled = False
    e.Form.Controls("Button05").Enabled = False
    e.Form.Controls("Button06").Enabled = False
    e.Form.Controls("Button12").Enabled = False
End If
--  作者：Bin
--  发布时间：2015/4/10 16:10:00
--  
其中医疗部只显示按钮2、8、11、02，


If User.Group <> "医疗部" Then
    e.Form.Controls("Button1").Enabled = True
    e.Form.Controls("Button07").Enabled = True
    e.Form.Controls("Button7").Enabled = True
    e.Form.Controls("Button09").Enabled = True
    e.Form.Controls("Button03").Enabled = True
    e.Form.Controls("Button04").Enabled = True
    e.Form.Controls("Button13").Enabled = True
    e.Form.Controls("Button15").Enabled = True
    e.Form.Controls("Button14").Enabled = True
    e.Form.Controls("Button3").Enabled = True
    e.Form.Controls("Button08").Enabled = True
    e.Form.Controls("Button05").Enabled = True
    e.Form.Controls("Button06").Enabled = True
    e.Form.Controls("Button12").Enabled = True
    e.Form.Controls("Button2").Enabled = False    
    e.Form.Controls("Button8").Enabled = False   
    e.Form.Controls("Button11").Enabled = False   
    e.Form.Controls("Button02").Enabled = False


你自己写的代码就和你描述的情况不对应,那当然不是应有的效果.  这不是刚好反过来了吗?

[此贴子已经被作者于2015/4/10 16:10:28编辑过]