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打开方式
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图