eosmenu_data.sql

软件维护单管理系统, 软件维护单管理系统

INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_EDIT', '编辑', NULL, '编辑', NULL, 'N', 1, 'FDFRAME_EDIT', '0', 2, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_Authority', '定义', NULL, '定义', NULL, 'N', 1, 'FDFRAME_Authority', '0'
, 1, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_SetFuncAuthority', '设置展现校验', 'ROLE.pr_automata.ROLE_P_FunctionCheckMain.do'
, '设置展现校验', NULL, 'Y', 2, 'FDFRAME_FuncAuthority', 'FDFRAME_FuncAuthority', 2
, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_Busi_Busi', '功能', 'ROLE.pr_automata.ROLE_P_ShowAllFunction.do', '功能'
, NULL, 'Y', 2, 'FDFRAME_Authority', 'FDFRAME_Authority', 3, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_OperatorMain', '用户', 'BNOM.pr_automata.BNOM_P_ShowEmpMain.do', '用户', NULL
, 'Y', 2, 'FDFRAME_Authority', 'FDFRAME_Authority', 1, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_ManageRole', '角色树', 'ROLE.pr_automata.ROLE_P_ManageRole.do', '角色树'
, NULL, 'Y', 2, 'FDFRAME_EDIT', 'FDFRAME_EDIT', 2, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_Org', '机构树', 'null', '机构树', NULL, 'N', 2, 'FDFRAME_Org', 'FDFRAME_EDIT'
, 3, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_BizOrg', '业务机构', 'BNOM.pr_automata.BNOM_P_ShowBizOrgMain.do', '业务机构'
, NULL, 'Y', 3, 'FDFRAME_Org', 'FDFRAME_Org', 1, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_Orgjigou', '组织机构', 'BNOM.pr_automata.BNOM_P_ShowOrgMain.do', '组织机构'
, NULL, 'Y', 3, 'FDFRAME_Org', 'FDFRAME_Org', 2, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_ChangePass', '修改密码', 'ROLE.pr_automata.ROLE_P_OperatorModPwd.do', '修改密码'
, NULL, 'Y', 2, 'FDFRAME_FuncAuthority', 'FDFRAME_FuncAuthority', 2, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_Menu_Menu', '菜单树', 'ROLE.pr_automata.ROLE_P_ManageMenu.do', '菜单树', NULL
, 'Y', 2, 'FDFRAME_EDIT', 'FDFRAME_EDIT', 4, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_FuncAuthority', '工具', NULL, '工具', NULL, 'N', 1, '0', '0', 3, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_DataAuthority', '数据权限', 'ROLE.pr_automata.ROLE_P_MenuDataAuthority', '数据权限'
, NULL, 'Y', 2, 'FDFRAME_Authority', 'FDFRAME_Authority', 5, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FDFRAME_System_BNDict', '业务数据字典', 'BNDICT.pr_automata.BNDICT_P_DictQuery.do'
, '业务数据字典', NULL, 'Y', 2, 'FDFRAME_FuncAuthority', 'FDFRAME_FuncAuthority', 5
, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FBFILE_Manager', '上传文件管理', NULL, '上传文件管理', NULL, 'N', 1, NULL, '0', 5
, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'FBFILE_Manager1', '上传文件管理', 'fbfile.pr.prFbfile_T_FilePreQuery.do', '上传文件管理'
, NULL, 'Y', 2, NULL, 'FBFILE_Manager', 1, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'WF5_002', '工作流客户端', NULL, '工作流客户端', NULL, 'N', 1, NULL, '0', 96, NULL
, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'WF5_002_001', '我的任务', 'WFCLIENT.pr_automata.WFCLIENT_P_MyTask.do', '我的任务'
, NULL, 'Y', 2, NULL, 'WF5_002', 1, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'WF5_002_002', '我的流程', 'WFCLIENT.pr_automata.WFCLIENT_P_MyProcessInst.do', '我的流程'
, NULL, 'Y', 2, NULL, 'WF5_002', 2, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'WF5_002_003', '启动流程', 'WFCLIENT.pr_automata.WFCLIENT_P_queryStartProcessByPerson.do'
, '启动流程', NULL, 'Y', 2, NULL, 'WF5_002', 3, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'WF5_003', '工作流监控与管理', NULL, '工作流监控与管理', NULL, 'N', 1, NULL, '0', 97
, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'WF5_003_001', '业务流程调整', 'WFCOMMON.pr_automata.next.do?nextPage=/internet/WFDEFMGR/frame_independent.jsp'
, '业务流程调整', NULL, 'Y', 2, NULL, 'WF5_003', 1, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'WF5_003_002', '流程实例管理', 'WFCOMMON.pr_automata.next.do?nextPage=/internet/WFINSTMGR/frame_independent.jsp'
, '流程实例管理', NULL, 'Y', 2, NULL, 'WF5_003', 2, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'WF5_003_003', '高级查询', 'WFCOMMON.pr_automata.next.do?nextPage=/internet/WFINSTMGR/WFINSTMGR_WFAdvancedMGR_independent.jsp'
, '高级查询', NULL, 'Y', 2, NULL, 'WF5_003', 3, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'WF5_003_004', '审计监控', 'WFCOMMON.pr_automata.next.do?nextPage=/internet/WFINSTMGR/WFINSTMGR_AuditLogQueryList_independent.jsp'
, '审计监控', NULL, 'Y', 2, NULL, 'WF5_003', 4, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'softwar_main_query', '维护单查询', 'njds.pr.prNJDS_SOFTWARE_MAINQueryInput.do', '维护单查询'
, NULL, 'Y', 2, NULL, 'software_main', 1, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'software_main', '软件维护', NULL, '软件维护', NULL, 'N', 1, NULL, '0', 0, NULL, NULL); 
INSERT INTO EOSMENU ( MENUID, MENUNAME, MENUACTION, MENULABEL, MENUVIEW, ISLEAF, MENULEVEL, ROOTID,
PARENTSID, DISPLAYORDER, INPUTVALUE, INPUTKEY ) VALUES ( 
'11', '输入数据', 'njds.pr.prInputData.do', '输入数据', NULL, 'Y', 2, NULL, 'software_main'
, 0, NULL, NULL); 
commit;