非管理员用户:
'''''''''加载树
Dim cmd As New SQLCommand
Dim dt As DataTable
Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1")
cmd.C
If User.Type = UserTypeEnum.Administrator Or User.Type = UserTypeEnum.Developer Then
cmd.CommandText = "S*LECT DISTINCT Year(创建时间) as 年,分类2 From {订单信息}"
Else
msgbox("S*lect DISTINCT Year(创建时间) As 年,分类2 From {订单信息} where [分类2] In ('" & user.roles.replace(",","','") & "')")
cmd.CommandText = "S*LECT DISTINCT Year(创建时间) As 年,分类2 From {订单信息} where [分类2] in ('" & user.roles.replace(",","','") & "')"
msgbox(2) -----显示:2
End If
msgbox(3) ------显示:3
dt = cmd.ExecuteReader()
msgbox(4) ------出现错误 ‘(’ 附近有语法错误。
trv.BuildTree(dt,"年|分类2")
msgbox(5) ------显示5
trv.Nodes.Insert("所有订单",0) ------未将对象引用到对象的实例
而采用“管理员”,或者“开发者”登录是没有问题的。