人事资料数据库

中国人事信息管理系统讲义（CNHR 3.3版2009年升级版）讲义（二○○九年十二月十一日）完成2009年年度的干部人事统计。

完善各单位人事数据库的建立。

完成2010年的工资的年度晋升。

一、机器硬件的要求外设：打印机操作系统：Windows 98SE或Windows 2000或Windows XP（举荐）或Windows 2003二、中国人事信息治理系统的安装①插入软件光盘→②自动启动安装界面（或双击“Setup.exe”启动）→③检测并安装IE6、MDAC2.7或2.8、.NET Framework→④设置目标文件夹开始安装→⑤提示安装完毕，需重新启动运算机，不需要重新启动→⑥点击“开始”菜单“中国人事信息治理系统”程序组中“数据库安装”，建立系统运行数据库→⑦插入USB加密狗本软件不需要进行注册只需将加密狗插入USB接口即可。

加密狗的正确安装方法：插入后加密狗就能够自动的显示出来，选择安装的路径（人事信息治理系统安装的路径，一样为c:/ gmisinfo3.3）三、机构治理3.1 机构树与单位信息（在“机构治理”模块中完成）3.1.1 机构树机构是报表统计与综合（汇总）的实体，机构树的建立必须严格按照统计与综合（汇总）关系进行。

所有要求填报基层统计表的单位，必须建立实单位；二级机构，也确实是建库软件中的部门不产生任何报表。

部门主管单位作为本部门报表综合，同时也须要统计机关本身基层报表，但因为两套表储备在数据库不同的表中，并不冲突。

因此，也应建立实单位。

3.1.2 单位信息机构树上的单位直截了当作为人员信息与报表信息的储备节点，同时也是人员与报表分类查询、统计、综合治理的实体，单位信息必须满足各类报表自动生成。

单位法人代码（组织机构代码）是数据库中匹配关键字，不得为空，必须严格按《组织机构代码证》上的代码如实填写，个不无证单位请到所在地统计局申请临时赋码。

单位所在地（实为行政区划码），直截了当体现报表汇总层次，不得为空，同时必须按照统计软件要求落实到区（县），也确实是讲满足6位，在建库软件中录入到最底层。

消费 电子
２ ０ １ ３年 １ 月 下
Ｃ ｏ ｎ ｓ ｕ ｍｅ ｒ Ｂ ｌ ｃ ｅ ｔ ｒ ｏ ｎ ｉ ｃ ｓ Ｍａ ｇ ａ ｚ ｉ ｎ ｅ
计算机科学
基于Ｎ ｅ ｔ ａ ｐ ｐ 与Ｏ ｒ ａ ｃ ｌ ｅ 数据库企业人事信息管理系统的构建
曾亚楠 ，胡 炯 ，陆文佳 （ 上海航天局 ，上海 ２ ０ １ １ ０ ０ ） 摘要 ：本文根 据 中小企业人 事管理 需求和现 实发展特点 ，采用 Ｏｒ ａ ｃ ｌ ｅ 数据库和 Ｎｅ ￣ ｐ ｐ存储 结构， 提 出了二 ＿ ． 套 企
企业人事信 息管理 系统建设意义 随着社会 改革开放和信 息技术 的不 断进步 ， 我国中小企业 发展状况普遍 良好， 但 是在企业人事管理方面仍然存在诸多 问 题， 包括 员工 绩效考核主观化严重 、 薪酬发放缺乏激励 性等 等， 造成 了很多中小企业人事管理繁杂混乱、 效率极低 。 本文基于 以上 问题 ， 设计 了一套针 对中小企 业的人事信息管理系统 ， 利 用信息技术提高企业人事管理的工作效 率， 管理企业人事信息 资源 ， 为企业领导层决策提供 有力支持 ， 形成完善 的企业人才 储备库 ，为企业发展奠定 良好基础。 二 、企业人事信息管理系统的总体设计 （ 一 ）系统架构设计 本文设计的企业人事信息管理系统 白去 Ｂ ／ ｓ 三层架构， 真正 实现高内聚、低耦合 。系统三层架构包括数据访问层、业务逻辑 层和用户表示层，每个层面分工 明确 ，通过相互配合、协同工作 保证系统正常稳定地运行 。 一旦数据库信息发生变化， 只需要对 数据访问层进行修改 。 系统基于三层架构模式， 将实体层与其他 层次独立 出来， 不但减少人工编程， 还能够使得企业人事信息管 理系统框架清晰可见 ，方便 日后对系统的维护和升级扩展 。 （ １ ）用户表示层 。用户表示层主要是与系统用户完成交 互过程， 执 行系统用户提 出的要求 。由系统应用程序提供访 问 接 口，用户通过接 口可 以实现各种功能操 作。 （ ２ ）业务逻辑层。业务逻辑层主要负责根据具体问题，对 数据访 问层进行相关操作，实现用户表示层提出的功能需求。 （ ３ ）数据访问层 。数 据访 问层 主要 负责直接操作系统后 台数据库 ，实现与数据库 的交 互，完成添加、删 除和修改数据 库信 息等功 能。

中国人事信息管理系统（CNHR 3.0湖南版）培训资料湖南省人事编制信息中心二○○六年十一月- 0 -中国人事信息管理系统培训资料前言·············································································································- 4 -第一章我省人事人才数据库建设工作思路 ······························································- 5 -1.1 历史回顾与软件整合 ·················································································- 5 -1.2 建库内容及工作任务 ·················································································- 5 -1.3 实施步骤 ································································································- 6 -1.4 总体架构 ································································································- 7 -第二章软件安装 ·······························································································- 9 -2.1安装包 ···································································································- 9 -2.2安装环境 ································································································- 9 -2.3初次安装 ································································································- 9 -2.3.1 主程序安装 ··························································································- 9 -2.3.2 数据库安装 ··························································································- 9 -2.3.3 加密狗安装 ························································································ - 10 -2.3.4 安装特别注意事项 ··············································································· - 10 -2.4“2006年1月25日升级包”安装 ······························································ - 11 -2.5“2006年11月升级包”安装 ···································································· - 13 -2.5数据库备份和数据库恢复 ········································································· - 17 -第三章建库与统计························································································· - 18 -3.1 建库与统计工作流程 ··············································································· - 18 -3.2 信息采集表及填报说明 ············································································ - 19 -3.3 机构信息录入 ························································································ - 19 -3.3.1 机构树的建立 ····················································································· - 19 -3.3.2 机构信息的录入及应用 ········································································· - 20 -3.4 人员信息录入 ························································································ - 23 -3.4.1 人员类别 ··························································································· - 23 -3.4.2 录入模板操作 ····················································································· - 24 -3.4.3 默认值的设定 ····················································································· - 24 -3.4.4．设置列的显示 ····················································································· - 25 -3.4.5冻结列 ································································································ - 25 -3.4.6人员信息的删除及还原 ··········································································· - 25 -- 1 -中国人事信息管理系统培训资料3.5信息校验 ································································································ - 26 -3.6信息更新 ································································································ - 27 -3.6.1信息更新模版操作 ················································································· - 28 -3.6.2信息的批量处理 ···················································································· - 30 -3.6.3 人员的批量快速移················································································· - 32 -3.7 生成统计报表·························································································· - 33 -3.7.1 人才基层报表的自动生成········································································ - 34 -3.7.2人才综合报表的汇总 ·············································································· - 39 -3.7.3工资报表的自动生成 ·············································································· - 40 -3.7.4数据上报 ····························································································· - 42 -3.7.5打印报表 ····························································································· - 43 -第四章工资管理 ····························································································· - 44 -4.1核对工资套改结果···················································································· - 44 -4.2日常工资调整·························································································· - 46 -4.2.1进入业务补充信息 ················································································· - 46 -4.2.2工资调整 ····························································································· - 47 -4.3工资调整操作范例···················································································· - 48 -4.4工资审批································································································ - 50 -4.4.1呈报数据接收 ······················································································· - 50 -4.4.2复算核定 ····························································································· - 51 -4.4.3审批数据接收 ······················································································· - 52 -4.5工资推演································································································ - 52 -第五章公务员登记 ·························································································· - 55 -5.1机构信息的录入: ······················································································ - 55 -5.2人员信息的录入 ······················································································· - 56 -- 2 -。

数据库课程设计人事管理系统一．课程设计计划 1.设计概述设计名称：人事管理系统使用语言：Access+Visual Basic 6.0 硬件要求：PⅢ 900MHz以上处理器，最低128M内存，30 0M以上硬盘剩余空间。

运行环境： Windows XP 2.实施计划 1任务安排： xx：安排各个功能模块分工，编写文档，系统实现，界面设计及数据库设计。

xx.xx.xx.xx：人事信息维护模块，包括人事信息的录入，修改，删除操作 xx.xx.xx.xx：人事信息查询模块，包括按姓名查询，按员工号查询等功能 xx.xx.xx：需求分析及数据库概念设计和E-R图绘制 xx.x x：数据字典编写，系统流程图绘制 2进度：前一周半完成概要设计，再用半周时间完成详细设计，代码设计不超过一周，最后进行系统测试以及试运行。

3.完成时间最迟完成日期：2006年6月12日。

二．需求分析 1 设计简介 1编写目的在现实世界和设计人员间架起沟通的桥梁，使实际使用者和软件设计人员双方一起来充分地理解使用者的要求，并开发出一个能够反映要完成工作的新系统的逻辑模型。

2系统要求：本系统是商丘师范学院计算机科学系计算机科学与技术03级的数据库课程设计题目，由陈树平老师提出，由本组成员联合开发，实现的是管理系统中关于人事资源管理的功能。

3参考资料 1．数据库系统概论高等教育出版社 2．VB数据库系统开发人民邮电出版社 3．Access+Visual Basi c数据库系统开发电子工业出版社 2 任务概述 1目标提供企业高效率完成劳动人事管理的日程业务，包括新员工的加入时人事档案的建立，包括员工基本信息、配偶信息、员工学历信息等，对基本信息的查询，员工调入信息，老员工转出，辞职，退休等，以及各种查询的打印输出。

将人事管理系统划分为两个子系统：前台操作界面和后台数据库。

3数据字典系统中的数据元素 1) 数据流名：员工档案描述：员工个人的基本信息组成：员工编号、员工姓名、性别、籍贯、出生年月、学历、专业、身份证号、婚姻状况、政治面貌、电话号码、邮政编码、电子邮箱、家庭住址、进入公司时间、起薪时间、所在部门、调入部门时间、职称、职称时间、原身份、原职务、原工作单位、参加工作时间、工作经验、其它备注； 2）数据流名：部门信息描述：部门信息组成：部门名称 3）数据流名：调动信息描述：员工的部门间调动信息组成：员工编号、员工姓名、原部门名称、新部门名称、原职务、新职务、调出时间、调入时间、备注； 4）数据流名：员工职务描述：公司职位信息组成：职务名称 5）数据流名：管理用户描述：系统管理员信息组成：用户名称、用户口令、用户权限 6）数据流名：查询输入：查询内容；输出：查询结果；逻辑关系：根据查询信息在相关数据库中查找符合符合条件的信息； 7）数据流名：修改；输入：原始数据；输出：更新数据；逻辑关系：按照要求对员工相关信息进行修改； 8）数据流名：删除；输入：原始数据库；输出：更新后的数据库；逻辑关系：按照要求对员工相关信息进行修改； .4功能需求增加：员工各种信息的输入，包括员工基本信息，学历信息，职称等。