For Each dr55 As DataRow In DataTables("表权限").sqlSelect("','+角色用户+',' like '%," & _userGroup & ",%' " )
If dr55.Isnull("表名") AndAlso dr55.Isnull("列名") Then
For Each t As Table In Tables
t.Visible = Not dr55("权限表不可见")
t.AllowEdit = Not dr55("权限表不可编缉")
Next
Else If dr55.isnull("列名") Then
Tables(dr55("表名")).Visible = Not dr55("权限表不可见")
For Each c As Col In Tables(dr55("表名")).Cols
c.Visible = Not dr55("权限表不可见")
c.AllowEdit = Not dr55("权限表不可编缉")
Next
Else
Tables(dr55("表名")).Visible = Not dr55("权限表不可见")
For Each c As Col In Tables(dr55("表名")).Cols
If dr55("列名") = c.name OrElse dr55("列名") Like c.name & ",*" OrElse dr55("列名") Like "*," & c.name & ",*" OrElse dr55("列名") Like "*," & c.name Then
c.Visible = Not dr55("权限表不可见")
c.AllowEdit = Not dr55("权限表不可编缉")
End If
Next
End If
Next
此主题相关图片如下:qq浏览器截图20210630105510.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2021-6/202163010561336587.png)
不可见列名里有内容,表什么不可见了,不是应该是列不可见吗