[求助]列授权 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

老师，我想在列名列的行里同时勾选多列进行授权，下面的代码只能一行授权一列。

For Each t As Table In Tables '显示所有表和列
    t.Visible = True
    t.AllowEdit = True
    For Each c As Col In t.Cols
        c.Visible = True
        c.AllowEdit = True
    Next
Next
'Tables("授权表").Visible = (User.Type <> UserTypeEnum.User )
If User.Type <> UserTypeEnum.User Then
    Return
End If
For Each dr As DataRow In DataTables("授权表").Select("(',' + Name + ',' like '%," & User.Name & ",%' or ',' + Config + ',' like '%," & User.group & ",%')")
    If dr.IsNull("列名") Then
        For Each t As Table In Tables
            If t.DataTable.Name = dr("表名") Then
                t.Visible = Not dr("不可见")
                t.AllowEdit = Not dr("不可编辑")
            End If
        Next
    Else
        For Each t As Table In Tables
            If t.DataTable.Name = dr("表名") Then
                For Each c As Col In t.Cols
                    If c.Name = dr("列名") Then
                        c.Visible = Not dr("不可见")
                        c.AllowEdit = Not dr("不可编辑")
                    End If
                Next
            End If
        Next
    End If
Next

图片点击可在新窗口打开查看此主题相关图片如下：图像 13.png

For Each dr As DataRow In DataTables("授权表").Select("(',' + Name + ',' like '%," & User.Name & ",%' or ',' + Config + ',' like '%," & User.group & ",%')")

If dr.IsNull("列名") Then

For Each t As Table In Tables

If t.DataTable.Name = dr("表名") Then

t.Visible = Not dr("不可见")

t.AllowEdit = Not dr("不可编辑")

End If

Else

For Each t As Table In Tables

If t.DataTable.Name = dr("表名") Then

Dim cls() As String = dr("列名").split(",")

For Each c As String In cls

If t.Cols.Contains(c) Then

t.Cols(c).Visible = Not dr("不可见")

t.Cols(c).AllowEdit = Not dr("不可编辑")

End If

上面代码是放到项目事件LoadUserSetting中，如果列视图里面有跟可见性相矛盾的，以哪个为准？

以下是引用new4w在2018/4/17 10:10:00的发言：
上面代码是放到项目事件LoadUserSetting中，如果列视图里面有跟可见性相矛盾的，以哪个为准？

看谁先执行。如果先执行隐藏，再执行显示，列自然是显示的。反之，就是隐藏的。

主题：[求助]列授权