u8集成看不到菜单，搜索能看到，单击提示无权限

王耀东 发表于 2021-10-20 16:23
use UFSystem

-----配置插入权限配置，根据需要增加

老板，与U8集成是咱的内部资料，您是已购客户吗，如果是的话请提供购买的公司名称，
我这边联系对应的技术人员协助您

您好，您是根据哪个教程配置的U8集成呢，看这个报错像是菜单权限的配置的不正确呀

use UFSystem

-----配置插入权限配置，根据需要增加
--select *from ua_subsys_base where csub_id='GC'
delete ua_subsys_base where csub_id='GC'
go
insert into ua_subsys_base
(cSub_Id,cSub_Name,iTasks,bInstalled,iVersion,cObjCreate,dStart,nType,cEntType,localeid,iOrder)
values('GC','现存量关联查询',0,'0',8.72,'CreateCom',Null,64,Null,'en-US',65)
insert into ua_subsys_base
(cSub_Id,cSub_Name,iTasks,bInstalled,iVersion,cObjCreate,dStart,nType,cEntType,localeid,iOrder)
values('GC','现存量关联查询',0,'0',8.72,'CreateCom',Null,64,Null,'zh-CN',65)
insert into ua_subsys_base
(cSub_Id,cSub_Name,iTasks,bInstalled,iVersion,cObjCreate,dStart,nType,cEntType,localeid,iOrder)
values('GC','现存量关联查询',0,'0',8.72,'CreateCom',Null,64,Null,'zh-TW',65)


-----预制前台菜单，首先查看前面预制的上级目录

if exists (select * from ua_menu where cmenu_id like 'GC%')  -----'GC%'和前面对应

delete from ua_menu where cmenu_id like 'GC%'
insert into ua_menu
(cmenu_id,cmenu_name,igrade,csupmenu_id,bendgrade,iorder,iimgindex,cAuth_id)
values('GC','现存量关联查询',1,'#1',0,100,2,NULL)
insert into ua_menu
(cmenu_id,cmenu_name,igrade,csupmenu_id,bendgrade,iorder,iimgindex,cAuth_id)
values('GC01','现存量关联查询',2,'GC',0,110,2,NULL)
insert into ua_menu
(cmenu_id,cmenu_name,igrade,csupmenu_id,bendgrade,iorder,iimgindex,cAuth_id)
values('GC0101','现存量关联查询',3,'GC01',1,120,4,NULL)

-------预置权限数据，csub_id对应前面子系统id，每一级都要与前面对应

INSERT INTO

[UA_Auth]([cAuth_Id],[cAuth_Name],[cSub_Id],[iGrade],[cSupAuth_Id],[bEndGrade],[iOrder],[cAcc_Id],[cAuthType],[cAllSupAuths]) VALUES ('GC01','基础设置
','GC',1,NULL,0,10,NULL,NULL,NULL)

INSERT INTO
[UA_Auth]([cAuth_Id],[cAuth_Name],[cSub_Id],[iGrade],[cSupAuth_Id],[bEndGrade],[iOrder],[cAcc_Id],[cAuthType],[cAllSupAuths]) VALUES ('GCQX0101','现存量关联查询设置
','GC',2,'GC01',1,20,NULL,NULL,NULL)



----预置接口，每一个末级菜单都需要插入
--delete ua_idt where id='GC0101'
---select *from ua_idt
Insert into ua_idt(id,assembly,catalogtype,type,class,entrypoint,parameter,reserved)
values('GC0101','.\Portal\Forguncy.U8UserControl.dll',0,2,'Forguncy.U8UserControl.ForguncyLoginable',
null,null,null)
Insert into ua_idt(id,assembly,catalogtype,type,class,entrypoint,parameter,reserved)
values('GC','.\Portal\Forguncy.U8UserControl.dll',0,2,'Forguncy.U8UserControl.ForguncyLoginable',
null,null,null)
Insert into ua_idt(id,assembly,catalogtype,type,class,entrypoint,parameter,reserved)
values('GC01','.\Portal\Forguncy.U8UserControl.dll',0,2,'Forguncy.U8UserControl.ForguncyLoginable',
null,null,null)


----预置菜单属性，首先去获取单点登录密码
----delete GC_MENU
Insert into GC_MENU (cMenu_Type, cMenu_Id, cMenu_Url, SSO_Password,
DefaultTargetWindow,cAuth_Id) values ('FGC','','http://u8ser:8012/demo-di', 'RJb4IYN5THWc',
'CurrentWindow', '')
----CurrentWindow为页面打开方式，弹出窗口则为popup
----GC0101为控制权限，不控制可以为空

--delete GC_MENU_Option
-----预置菜单自定义属性
Insert into GC_MENU_Option (cMenu_Id, cUser_Id, TargetWindow)
values('GC0101','demo', 'CurrentWindow')
Insert into GC_MENU_Option (cMenu_Id, cUser_Id, TargetWindow)

values('GC01','demo', 'CurrentWindow')
Insert into GC_MENU_Option (cMenu_Id, cUser_Id, TargetWindow)
values('GC','demo', 'CurrentWindow')
----cMenu_Id菜单id对应预置菜单id, cUser_Id同u8用户id, TargetWindow打开方式