OA办公系统项目权限设计.doc

项目权限设计A. 公司组织结构图校长副校长组织部宣传部财务部招生就业处综合办公室员工员工员工员工员工B. 项目功能模块表模块名称模块代号下属子模块个人办公M1模块名称模块代号文件传送M1_1个人文件柜M1_2工作日程安排M1_3个人通信录管理M1_4信息发布M2可以发布通知和公共信息公文流转M3发文，收文邮件M4收邮件、发邮件等邮件功能即时通信M5员工及部门管理M6权限设置M7用户登录M8根据公司的组织结构图和项目功能模块表对系统设计如下权限表：编号角色备注1系统管理员系统管理员是公司的特殊员工仅在对系统的维护方面有最高权限。2总经理3副总经理4研发部经理5市场营销部经理6财务部经理7人力资源部经理8综合办公室经理9员工1文件柜/PandaStarOA/jsp/folder.jsp通信录个人通讯录/PandaStarOA/jsp/priAddressMain.jsp?first=true公共通讯录/PandaStarOA/pubAddressMain.do2信息发布2.1显示公告/PandaStarOA/showBulletin.do?method=startView2.2添加公告/PandaStarOA/jsp/addBulletin.jsp2.3公告管理/PandaStarOA/managerBulletin.do?method=startView3即时通信window.open(/PandaStarOA/jsp/message.jsp,null,height=600,width=175,status=yes,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=no)4员工管理查询员工/PandaStarOA/jsp/queryEmp.jsp设置员工/PandaStarOA/jsp/updateAndDeleteEmp.jsp(在这个页面上进行更新和删除操作)添加员工/PandaStarOA/jsp/addEmp.jsp5部门管理查询部门/PandaStarOA/jsp/queryDept.jsp设置部门/PandaStarOA/jsp/updateDeptMain.jsp(更新和删除部门)添加部门/PandaStarOA/jsp/addDept.jsp6权限管理/PandaStarOA/jsp/power.jsp7公文流转发文收文8日程管理显示日程/PandaStarOA/jsp/CalendarView.jsp添加日程/PandaStarOA/jsp/addCalendar.jsp9邮件发件箱/PandaStarOA/jsp/sendEmail.jsp9.2收件箱/PandaStarOA/managerEmail.do?foldername=inbox&method=go9.3垃圾箱/PandaStarOA/managerEmail.do?foldername=trash&method=go9.4已发送/PandaStarOA/managerEmail.do?foldername=sendbox&method=go9.5草稿箱/PandaStarOA/managerEmail.do?foldername=draft&method=go权限设计#插入员工角色表insert into employeerole VALUE(2,1);insert into employeerole VALUE(3,2);insert into employeerole VALUE(7,3);#给权限表添加数据insert into power value(default,查询员工,/PandaStarOA/jsp/queryEmp.jsp,1);insert into power value(default,添加员工,/PandaStarOA/jsp/addEmp.jsp ,1);insert into power value(default,设置员工,/PandaStarOA/jsp/updateAndDeleteEmp.jsp,1);insert into power value(default,查询部门,/PandaStarOA/jsp/queryDept.jsp,2);insert into power value(default,设置部门,/PandaStarOA/jsp/updateDeptMain.jsp,2);insert into power value(default,添加部门,/PandaStarOA/jsp/addDept.jsp,2);insert into power value(default,显示公告,/PandaStarOA/showBulletin.do?method=startView,4);insert into power value(default,添加公告,/PandaStarOA/jsp/addBulletin.jsp,4);insert into power value(default,公告管理,/PandaStarOA/managerBulletin.do?method=startView,4);insert into power value(default,发件箱,/PandaStarOA/jsp/sendEmail.jsp,5);insert into power value(default,收件箱,/PandaStarOA/managerEmail.do?foldername=inbox&method=go,5);insert into power value(default,垃圾箱,/PandaStarOA/managerEmail.do?foldername=trash&method=go,5);insert into power value(default,已发送,/PandaStarOA/managerEmail.do?foldername=sendbox&method=go,5);insert into power value(default,草稿箱,/PandaStarOA/managerEmail.do?foldername=draft&method=go,5);insert into power value(default,个人通讯录,/PandaStarOA/jsp/priAddressMain.jsp?first=true,6);insert into power value(default,公共通讯录,/PandaStarOA/pubAddressMain.do,6);