use CCVisitingBook;
-- 系统;
DELETE FROM GPM_App WHERE No='AdminSys' ;
INSERT INTO GPM_App(No,Name,AppModel,MyFileName,MyFilePath,MyFileExt,WebPath,FK_AppSort,RefMenuNo) VALUES ('AdminSys','极简访客',0,'ccoa.png','Path','GIF','/DataUser/BP.GPM.STem/CCOA.png','01','2002');

-- 删除所有的菜单.
DELETE FROM GPM_Menu WHERE FK_App='AdminSys';

-- root;
INSERT INTO GPM_Menu(FK_App,No,ParentNo,Name,MenuType,UrlExt,IsEnable) VALUES('AdminSys','2000','0','极简访客',1,'',1);
 
-- AdminSys 流程管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('HD01', '组织管理', '2000',1, 3, 'AdminSys', '', 0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('HD0101', '组织台账', 'HD01', 1, 4, 'AdminSys', '/WF/Comm/Search.htm?EnsName=BP.VB.Orgs',  0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('HD0102', '销售人员', 'HD01', 1, 4, 'AdminSys', '/WF/Comm/Search.htm?EnsName=BP.VB.Sellers',  0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('HD0103', '人员台账', 'HD01', 1, 4, 'AdminSys', '/WF/Comm/Search.htm?EnsName=BP.VB.Emps',  0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('HD0104', '访客台账', 'HD01', 1, 4, 'AdminSys', '/WF/Comm/Search.htm?EnsName=BP.VB.Books',  0,'',1);
  
-- AdminSys 流程管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('HD02', '模版数据管理', '2000',1, 3, 'AdminSys', '', 0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('HD0201', '通用字典表', 'HD02', 1, 4, 'AdminSys', '/WF/Admin/FoolFormDesigner/SFList.htm',  0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('HD0202', '通用枚举', 'HD02', 1, 4, 'AdminSys',   '/WF/Admin/FoolFormDesigner/SysEnumListSAAS.htm?EnsName=BP.Cloud.OrgExts',  0,'',1);

--SELECT * from Sys_Enum where EnumKey='MenuCtrlWay';
 
UPDATE GPM_Menu SET IsEnable=1;

 
-- SELECT * FROM App_Book