CCFlow/GPM/SQLScript/InitPublicData.sql · codingstudio/CCFlow

代码拉取完成,页面将自动刷新

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

1 Star 0 Fork 737

codingstudio/CCFlow

forked from 济南驰骋公司/CCFlow

代码 Issues 0 Pull Requests 0 Wiki 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

develop

分支 (3)

管理

develop

forVS2010

ccbpm2021

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 3

标签 0

ccflow

CCFlow

GPM

SQLScript

InitPublicData.sql

InitPublicData.sql 17.72 KB

-- 系统类别;
DELETE FROM GPM_AppSort;
INSERT INTO GPM_AppSort(No,Name,RefMenuNo) VALUES ('01','业务系统','2000');
INSERT INTO GPM_AppSort(No,Name,RefMenuNo) VALUES ('02','办公系统','2001');

-- 系统;
DELETE FROM GPM_App;
INSERT INTO GPM_App(No,Name,AppModel,Url,MyFileName,MyFilePath,MyFileExt,WebPath,FK_AppSort,RefMenuNo) VALUES ('CCOA','驰骋OA',0,'http://www.chichengoa.org/App/login/login.ashx','ccoa.png','Path','GIF','/DataUser/BP.GPM.STem/CCOA.png','01','2002'); /*此处地址被孙战平改动*/

DELETE FROM GPM_Menu;

-- root;
INSERT INTO GPM_Menu(FK_App,No,ParentNo,Name,MenuType,UrlExt,IsEnable) VALUES ('UnitFullName','1000','0','济南驰骋信息技术有限公司',0,'',1);
INSERT INTO GPM_Menu(FK_App,No,ParentNo,Name,MenuType,UrlExt,IsEnable) VALUES ('AppSort','2000','1000','业务系统',1,'',1);
INSERT INTO GPM_Menu(FK_App,No,ParentNo,Name,MenuType,UrlExt,IsEnable) VALUES ('AppSort','2001','1000','办公系统',1,'',1);
INSERT INTO GPM_Menu(FK_App,No,ParentNo,Name,MenuType,UrlExt,IsEnable) VALUES ('CCOA','2002','2000','驰骋OA',2,'',1);

-- 工作流程.;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200', '工作流程', '2002', 0, 3, 'CCOA', '', 0,'icon-home',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200-1', '发起', '200200', 1, 4, 'CCOA', '/WF/Start.htm',0,'icon-plane',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200-2', '待办', '200200', 2, 4, 'CCOA', '/WF/Todolist.htm', 0,'icon-cup',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200-3', '在途', '200200', 3, 4, 'CCOA', '/WF/Runing.htm', 0,'icon-hourglass',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200-4', '查询', '200200', 4, 4, 'CCOA', '/WF/SearchBS.htm', 0,'icon-eyeglass',1);

-- 公告通知;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201', '新闻&公告', '2002', 1, 3, 'CCOA', '',0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201-1', '公告管理', '200201', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Notices',0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201-2', '公告类别', '200201', 2, 4, 'CCOA', '/WF/Comm/Ens.htm?EnsName=BP.OA.NoticeCategorys', 0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201-3', '新闻台帐', '200201', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Newss', 0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201-4', '新闻类别', '200201', 4, 4, 'CCOA', '/WF/Comm/Ens.htm?EnsName=BP.OA.NewsSorts',0,'',1);
 
-- CCOA 菜单;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200202', '我的工具', '2002',3, 3, 'CCOA', '', 0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200202-1', '我的通讯录', '200202', 2, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.ALEmps', 0,'',1);
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('253', '科学计算器', '252', 9, 4, 'CCOA', '/App/SmallTools/ComputingCounter.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('254', '万年历', '252', 10, 4, 'CCOA', '/App/SmallTools/Calendar.htm',0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('255', '记事便签', '252', 7, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Notepaper.Notepapers', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('1011', '我的计划', '252', 6, 4, 'CCOA', '/App/PrivPlan/MyPlan.htm',0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('1037', '我的日程', '252', 5, 4, 'CCOA', '/App/Calendar/MyCalendar.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('2010', '发送短消息', '252', 8, 4, 'CCOA', '/Main/Sys/SendShortMsg.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('250', '发起投票', '252', 3, 4, 'CCOA', '/App/Vote/CreateVote.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('251', '我的投票', '252', 4, 4, 'CCOA', '/App/Vote/VoteList.htm', 0,'');

-- 文档中心;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('106', '文档中心(重构中)', '2002', 10, 3, 'CCOA', '', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('107', '知识树', '106', 1, 4, 'CCOA', '/App/KM/Sort.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('147', '我的文档', '106', 2, 4, 'CCOA', '/App/Km/MyDoc.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('160', '知识管理', '106', 5, 4, 'CCOA', '/App/KM/Main.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('186', '最新文档', '106', 4, 4, 'CCOA', '/App/KM/NewlyDoc.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('256', '同事共享', '106', 3, 4, 'CCOA', '/App/KM/EmpsShare.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('262', '知识共享', '106', 6, 4, 'CCOA', '/App/KM/CompanyDoc.htm', 0,'');

-- 车辆管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('145', '车辆管理', '2002', 12, 3, 'CCOA', '', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('146', '驾驶员信息', '145', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Car.Drivers', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('185', '指标管理', '145', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Car.ZhiBiaos',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('261', '车辆信息', '145', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Car.CarInfos', 0,'');

-- 办公用品;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('198', '办公用品', '2002', 15, 3, 'CCOA', '',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('199', '库存台账', '198', 2, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.DS.DSMains', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('200', '购买台账', '198', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.DS.DSBuys', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('204', '领取台账', '198', 4, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.DS.DSTakes', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('263', '用品类别', '198', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.DS.DSSorts', 0,'');

-- 人力资源;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('201', '人力资源', '2002', 16, 3, 'CCOA','', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('202', '员工档案', '201', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.HRRecords', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('203', '合同签订信息', '201', 4, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.HRContracts', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('214', '合同解除信息', '201', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.HRContractRemoves', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('228', '调动记录', '201', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HRTransfers', 0,'');
-- INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('230', '发起人员调动流程', '201', 0, 4, 'CCOA', '/WF/MyFlow.htm?FK_Flow=Transfer', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('217', '公积金台账', '201', 6, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.GongJiJins', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('219', '社保与福利台账', '201', 7, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.FuLis', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('259', '合同变更台帐', '201', 5, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.HRContractModifys', 0,'');

-- 固定资产管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('196', '固定资产', '2002', 14, 3, 'CCOA', '', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('243', '所属大类', '196', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.FixAssBigCatagorys', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('244', '所属小类', '196', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.FixAssBigCatSons', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('246', '资产领用', '196', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.GetUses', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('248', '资产报修', '196', 5, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.Repairs', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('249', '资产报废', '196', 6, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.GetBads', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('197', '资产登记', '196', 2, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.FixMans', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('257', '资产归还', '196', 4, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.GiveBacks', 0,'');

-- 会议管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('265', '会议管理(重构中)', '2002', 11, 3, 'CCOA', '', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('267', '会议类型', '265', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Meeting.MeetingTypes', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('268', '会议室资源维护', '265', 4, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Meeting.RoomResources', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('269', '会议室列表', '265', 3, 4, 'CCOA', '/App/Meeting/RoomListEUI.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('270', '会议室预订', '265', 2, 4, 'CCOA', '/App/Meeting/OrdingEUI.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('271', '我的会议', '265', 0, 4, 'CCOA', '/App/Meeting/MyMeetingEUI.htm', 0,'');

-- 快捷入口;
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('297', '快捷入口', '2002', 0, 3, 'CCOA', '', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('299', '待办', '297', 0, 4, 'CCOA', '/WF/Todolist.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('300', '在途', '297', 0, 4, 'CCOA', '/WF/Runing.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('301', '发起', '297', 0, 4, 'CCOA', '/WF/Start.htm ', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('302', '我的邮件', '297', 0, 4, 'CCOA', '/App/Message/InBox.htm ', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('303', '我的公告', '297', 0, 4, 'CCOA', '/App/Notice/MyNoticeList.htm ', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('305', '我的会议', '297', 0, 4, 'CCOA', '/App/Meeting/MyMeetingEUI.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('304', '我的新闻', '297', 0, 4, 'CCOA', '/App/News/MyNewsList.htm', 0,'');

/*
-- 日常办公;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('187', '日常办公', '2002', 1, 3, 'CCOA', '/Main/DeskTop2.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('188', '我的工作台', '187', 1, 4, 'CCOA', '/Main/DeskTop2.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('189', '所有资讯', '187', 2, 4, 'CCOA', '/App/Notice/NoticeList.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('191', '我的日程', '187', 4, 4, 'CCOA', '/App/Calendar/MyCalendar.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('192', '我的文档', '187', 5, 4, 'CCOA', '/App/Km/MyDoc.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('193', '信息块维护', '187', 6, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Desktop.DesktopPanels', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('264', '知识库', '187', 6, 4, 'CCOA', '/App/KM/CompanyDoc.htm', 0,'');
*/

-- 论坛;
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('272', '我的论坛', '2002', 13, 3, 'CCOA','', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('273', '论坛板块', '272', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.BBS.BBSClasss', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('274', '论坛首页', '272', 2, 4, 'CCOA', '/App/BBS/Default.htm?fid=0', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('195', '参数设置', '272', 3, 4, 'CCOA', '/App/BBS/SysAdmin/Config.htm',0,'');

-- 权限管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('900', '系统管理', '2002', 99, 3, 'CCOA','', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('961', '流程设计器', '900', 1, 4, 'CCOA', '/WF/Admin/CCBPMDesigner/Default.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('962', '组织结构', '900', 2, 4, 'CCOA', '/GPM/Organization.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('964', '岗位类型', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.Port.StationTypes',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('966', '岗位', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.Port.Stations',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('967', '人员台帐', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.GPM.Emps',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('968', '系统类别', '900', 3, 4, 'CCOA', '/WF/Comm/Ens.htm?EnsName=BP.GPM.AppSorts',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('969', '系统台帐', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.GPM.Apps',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('970', '权限组', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.GPM.Groups',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('971', '岗位菜单', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.Port.StationExts',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('972', '人员菜单', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.GPM.GPMEmps',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('973', '菜单树', '900', 3, 4, 'CCOA', '/WF/Comm/Tree.htm?EnsName=BP.GPM.Menus',0,'');

UPDATE GPM_Menu SET IsEnable=1;

一键复制编辑原始数据按行查看历史

驰骋BPM 提交于 2020年04月20日 10:04 +08:00 . 升级集团版本的二级管理员.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138

-- 系统类别;
DELETE FROM GPM_AppSort;
INSERT INTO GPM_AppSort(No,Name,RefMenuNo) VALUES ('01','业务系统','2000');
INSERT INTO GPM_AppSort(No,Name,RefMenuNo) VALUES ('02','办公系统','2001');

-- 系统;
DELETE FROM GPM_App;
INSERT INTO GPM_App(No,Name,AppModel,Url,MyFileName,MyFilePath,MyFileExt,WebPath,FK_AppSort,RefMenuNo) VALUES ('CCOA','驰骋OA',0,'http://www.chichengoa.org/App/login/login.ashx','ccoa.png','Path','GIF','/DataUser/BP.GPM.STem/CCOA.png','01','2002'); /*此处地址被孙战平改动*/

DELETE FROM GPM_Menu;

-- root;
INSERT INTO GPM_Menu(FK_App,No,ParentNo,Name,MenuType,UrlExt,IsEnable) VALUES ('UnitFullName','1000','0','济南驰骋信息技术有限公司',0,'',1);
INSERT INTO GPM_Menu(FK_App,No,ParentNo,Name,MenuType,UrlExt,IsEnable) VALUES ('AppSort','2000','1000','业务系统',1,'',1);
INSERT INTO GPM_Menu(FK_App,No,ParentNo,Name,MenuType,UrlExt,IsEnable) VALUES ('AppSort','2001','1000','办公系统',1,'',1);
INSERT INTO GPM_Menu(FK_App,No,ParentNo,Name,MenuType,UrlExt,IsEnable) VALUES ('CCOA','2002','2000','驰骋OA',2,'',1);


-- 工作流程.;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200', '工作流程', '2002', 0, 3, 'CCOA', '', 0,'icon-home',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200-1', '发起', '200200', 1, 4, 'CCOA', '/WF/Start.htm',0,'icon-plane',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200-2', '待办', '200200', 2, 4, 'CCOA', '/WF/Todolist.htm', 0,'icon-cup',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200-3', '在途', '200200', 3, 4, 'CCOA', '/WF/Runing.htm', 0,'icon-hourglass',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200200-4', '查询', '200200', 4, 4, 'CCOA', '/WF/SearchBS.htm', 0,'icon-eyeglass',1);

-- 公告通知;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201', '新闻&公告', '2002', 1, 3, 'CCOA', '',0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201-1', '公告管理', '200201', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Notices',0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201-2', '公告类别', '200201', 2, 4, 'CCOA', '/WF/Comm/Ens.htm?EnsName=BP.OA.NoticeCategorys', 0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201-3', '新闻台帐', '200201', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Newss', 0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200201-4', '新闻类别', '200201', 4, 4, 'CCOA', '/WF/Comm/Ens.htm?EnsName=BP.OA.NewsSorts',0,'',1);
 
-- CCOA 菜单;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200202', '我的工具', '2002',3, 3, 'CCOA', '', 0,'',1);
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon,MenuCtrlWay) VALUES ('200202-1', '我的通讯录', '200202', 2, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.ALEmps', 0,'',1);
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('253', '科学计算器', '252', 9, 4, 'CCOA', '/App/SmallTools/ComputingCounter.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('254', '万年历', '252', 10, 4, 'CCOA', '/App/SmallTools/Calendar.htm',0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('255', '记事便签', '252', 7, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Notepaper.Notepapers', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('1011', '我的计划', '252', 6, 4, 'CCOA', '/App/PrivPlan/MyPlan.htm',0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('1037', '我的日程', '252', 5, 4, 'CCOA', '/App/Calendar/MyCalendar.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('2010', '发送短消息', '252', 8, 4, 'CCOA', '/Main/Sys/SendShortMsg.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('250', '发起投票', '252', 3, 4, 'CCOA', '/App/Vote/CreateVote.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('251', '我的投票', '252', 4, 4, 'CCOA', '/App/Vote/VoteList.htm', 0,'');

-- 文档中心;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('106', '文档中心(重构中)', '2002', 10, 3, 'CCOA', '', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('107', '知识树', '106', 1, 4, 'CCOA', '/App/KM/Sort.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('147', '我的文档', '106', 2, 4, 'CCOA', '/App/Km/MyDoc.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('160', '知识管理', '106', 5, 4, 'CCOA', '/App/KM/Main.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('186', '最新文档', '106', 4, 4, 'CCOA', '/App/KM/NewlyDoc.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('256', '同事共享', '106', 3, 4, 'CCOA', '/App/KM/EmpsShare.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('262', '知识共享', '106', 6, 4, 'CCOA', '/App/KM/CompanyDoc.htm', 0,'');

-- 车辆管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('145', '车辆管理', '2002', 12, 3, 'CCOA', '', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('146', '驾驶员信息', '145', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Car.Drivers', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('185', '指标管理', '145', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Car.ZhiBiaos',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('261', '车辆信息', '145', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Car.CarInfos', 0,'');

-- 办公用品;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('198', '办公用品', '2002', 15, 3, 'CCOA', '',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('199', '库存台账', '198', 2, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.DS.DSMains', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('200', '购买台账', '198', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.DS.DSBuys', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('204', '领取台账', '198', 4, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.DS.DSTakes', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('263', '用品类别', '198', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.DS.DSSorts', 0,'');

-- 人力资源;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('201', '人力资源', '2002', 16, 3, 'CCOA','', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('202', '员工档案', '201', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.HRRecords', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('203', '合同签订信息', '201', 4, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.HRContracts', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('214', '合同解除信息', '201', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.HRContractRemoves', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('228', '调动记录', '201', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HRTransfers', 0,'');
-- INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('230', '发起人员调动流程', '201', 0, 4, 'CCOA', '/WF/MyFlow.htm?FK_Flow=Transfer', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('217', '公积金台账', '201', 6, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.GongJiJins', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('219', '社保与福利台账', '201', 7, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.FuLis', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('259', '合同变更台帐', '201', 5, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.HR.HRContractModifys', 0,'');

-- 固定资产管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('196', '固定资产', '2002', 14, 3, 'CCOA', '', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('243', '所属大类', '196', 0, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.FixAssBigCatagorys', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('244', '所属小类', '196', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.FixAssBigCatSons', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('246', '资产领用', '196', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.GetUses', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('248', '资产报修', '196', 5, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.Repairs', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('249', '资产报废', '196', 6, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.GetBads', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('197', '资产登记', '196', 2, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.FixMans', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('257', '资产归还', '196', 4, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.FixAss.GiveBacks', 0,'');

-- 会议管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('265', '会议管理(重构中)', '2002', 11, 3, 'CCOA', '', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('267', '会议类型', '265', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Meeting.MeetingTypes', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('268', '会议室资源维护', '265', 4, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Meeting.RoomResources', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('269', '会议室列表', '265', 3, 4, 'CCOA', '/App/Meeting/RoomListEUI.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('270', '会议室预订', '265', 2, 4, 'CCOA', '/App/Meeting/OrdingEUI.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('271', '我的会议', '265', 0, 4, 'CCOA', '/App/Meeting/MyMeetingEUI.htm', 0,'');

-- 快捷入口;
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('297', '快捷入口', '2002', 0, 3, 'CCOA', '', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('299', '待办', '297', 0, 4, 'CCOA', '/WF/Todolist.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('300', '在途', '297', 0, 4, 'CCOA', '/WF/Runing.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('301', '发起', '297', 0, 4, 'CCOA', '/WF/Start.htm ', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('302', '我的邮件', '297', 0, 4, 'CCOA', '/App/Message/InBox.htm ', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('303', '我的公告', '297', 0, 4, 'CCOA', '/App/Notice/MyNoticeList.htm ', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('305', '我的会议', '297', 0, 4, 'CCOA', '/App/Meeting/MyMeetingEUI.htm', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('304', '我的新闻', '297', 0, 4, 'CCOA', '/App/News/MyNewsList.htm', 0,'');

/*
-- 日常办公;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('187', '日常办公', '2002', 1, 3, 'CCOA', '/Main/DeskTop2.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('188', '我的工作台', '187', 1, 4, 'CCOA', '/Main/DeskTop2.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('189', '所有资讯', '187', 2, 4, 'CCOA', '/App/Notice/NoticeList.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('191', '我的日程', '187', 4, 4, 'CCOA', '/App/Calendar/MyCalendar.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('192', '我的文档', '187', 5, 4, 'CCOA', '/App/Km/MyDoc.htm',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('193', '信息块维护', '187', 6, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.Desktop.DesktopPanels', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('264', '知识库', '187', 6, 4, 'CCOA', '/App/KM/CompanyDoc.htm', 0,'');
*/

-- 论坛;
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('272', '我的论坛', '2002', 13, 3, 'CCOA','', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('273', '论坛板块', '272', 1, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.OA.BBS.BBSClasss', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('274', '论坛首页', '272', 2, 4, 'CCOA', '/App/BBS/Default.htm?fid=0', 0,'');
--INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('195', '参数设置', '272', 3, 4, 'CCOA', '/App/BBS/SysAdmin/Config.htm',0,'');

-- 权限管理;
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('900', '系统管理', '2002', 99, 3, 'CCOA','', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('961', '流程设计器', '900', 1, 4, 'CCOA', '/WF/Admin/CCBPMDesigner/Default.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('962', '组织结构', '900', 2, 4, 'CCOA', '/GPM/Organization.htm', 0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('964', '岗位类型', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.Port.StationTypes',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('966', '岗位', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.Port.Stations',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('967', '人员台帐', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.GPM.Emps',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('968', '系统类别', '900', 3, 4, 'CCOA', '/WF/Comm/Ens.htm?EnsName=BP.GPM.AppSorts',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('969', '系统台帐', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.GPM.Apps',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('970', '权限组', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.GPM.Groups',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('971', '岗位菜单', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.Port.StationExts',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('972', '人员菜单', '900', 3, 4, 'CCOA', '/WF/Comm/Search.htm?EnsName=BP.GPM.GPMEmps',0,'');
INSERT INTO GPM_Menu (No, Name, ParentNo, Idx, MenuType, FK_App, UrlExt, OpenWay,Icon) VALUES ('973', '菜单树', '900', 3, 4, 'CCOA', '/WF/Comm/Tree.htm?EnsName=BP.GPM.Menus',0,'');

UPDATE GPM_Menu SET IsEnable=1;