企业人事管理系统的分析与设计4-15

1摘要人事管理系统是九十年代才出现的新兴的信息系统，它属于人力资源管理系统的一个小的分支，是管理科学和计算机技术紧密结合的产物。随着计算机技术的迅速发展，特别是软件开发技术和开发工具的不断进步，人事管理系统的开发逐步呈现出多方位，全面的开发模式:在开发模型的系统结构方面在沿着主机/终端模型到B/S模型到多层的B/S模式、再到C/S模式，相应地系统应用体系结构也由单层结构发展到二层结构再到三层结构以至多层;面向对象技术的得到广泛应用，组件技术的出现解决了传统的软件开发在分布性和重用性的一些问题，提高了软件开发的效率和质量本论文是从现代企业管理中的人事管理现状出发，针对人事管理的复杂程序，经过详细的系统调查，开发出的操作简单而且方便实用的一个人事管理系统。人事系统是一套通用性极强的人事管理系统。提供了完备的人事档案管理，包括人事档案分类管理（户口状况、家庭情况、政治面貌、生理状况、学习及工作经历状况）；人事变动（新进员工登记、员工离职登记、人事变更记录）；考核（奖惩、领导和人事部门意见及评价）；考勤（上班考勤情况管理、病事假情况管理）。人事档案资料完备，打印灵活。提供人事综合查询系统，可以按日期和姓名两种查询条件查询到用户所需资料。各种人事资料可方便的打印。本系统的前端开发工具是VisualBasic6.0，后台数据库引擎选用数据库软件MicrosoftSQL2000。关键词：查询，人事管理，数据库2AbstractPersonnelManagementInformationSystemisakindofMISwhichcomeforthin90's.Itcombinesmanagementwiththecomputerscience.Withthedevelopmentofcomputerscience.especiallythedevelopmentoftechnologyandtoolsinsoftware.ThePersonnelManagementInformationSystemgraduallypresentinmanyways:Inthesystemconstructionofthedevelopmentmodel.Ithasdevelopedfromclient/servicemodeltotheB/Smodeltomulti-tiersB/SmodeluntilnowofC/Smodel;Toadapttothedevelopmentofsituation,theWebApplicationSystemofmulti-tierapplicationarchitecturecameintobeing,whichhasbeenoneofthefastestcomputerapplicationsystemssincetheInternet/Intranettechnologywasemployedandhasgraduallybeenthemainmodelofcomputerapplicationsystems.Meantime,Object-orientedtechnologyhasalsomadearapidprogress,whichledtotheDistributedObjectComputingtechnologyandthetechnologyarchitectureofmulti-tiersapplicationarchitecturebasedoncomponent.Thisthesisisasimple,convenientandpracticalpersonneladministrativeoperationsystemdeveloped,proceedingfromcurrentpersonnelmanagementsituationinmodernbusinessadministration,aimingtothecomplicatedprocedureofpersonnelmanagement,investigatedthroughthedetailedsystem.Thepersonnelsystemisasetofpersonneladministrativesystemswithextremelystrongcommonability.Ithaveofferedcompletepersonnelfileadministration,includingtheclassifiedpersonalfilemanagement(Registeredpermanentresidencestate,politicalbackground,physiologicalstate,themanagementofthecontract,theassurancesituation),workovertimeandgoonbusinesstomanageinattendance,changeofpersonnel(newstaffregister,theregistrationofstafftoleaveoffice,therecordofnewlypersonnelchange),examinerewardsandpunishments,staffstrained,endowmentinsurance,etc.operation.Thepersonalfilematerialsarecompleteandflexibletotype.Offerthecomprehensiveinquirysystemofthepersonnel.Youcaninquireuser'snecessarymaterialsaccordingtovariouskindsofthecondition.Variouskindsofpersonnelmaterialscanbeconvenienttotypeintheformwaythatyoufreelyestablish.Frontinstrumentofthisdevelopedsystemis6.0VisualBasic;thedatabasesoftwareselectedbybackstagesupporterdatabaseengineisMicrosoftSQL2000foruse.Keywords:Inquiry,Employmentmanaging,Databases.3目录摘要Abstract前言.........................................................1第一章绪论.................................................21.1信息管理系统产生的背景.......................................................21.2信息管理系统的分类.............................................................21.3本文所作工作........................................................................5第二章相关工具简介...........................................62.1前端开发工具VISUALBASIC6.0介绍.....................................62.1.1VisualBasic6.0概述..................................62.1.2VisualBasic6.0的优点................................62.1.3数据访问控件介绍........................................72.2数据库MICROSOFTSQL2000介绍...........................................82.2.1MSSQLServer简述......................................82.2.2SQL语句................................................82.2.3SQL语言在VB中的应用...................................9第三章需求分析.............................................103.1调查分析.............................................................................1043.1.1系统目标...............................................103.1.2应用现状调查...........................................103.2系统功能调查......................................................................103.2.1员工信息管理功能.......................................103.2.2员工工资管理功能.......................................103.2.3员工工作考评管理功能...................................113.2.4员工考勤管理功能.......................................113.2.5系统维护功能...........................................113.3数据库需求分析...................................................................11第四章概要设计............................................134.1概要设计.............................................................................134.2数据库设计..........................................................................144.2.1数据库逻辑结构设计.....................................144.2.2部门表Department_table.................................144.2.3员工基本信息表employees_table.......................154.2.4员工工作考评表Evalution_table........................164.2.5用户信息表users......................................164.3系统功能模块图.................................................................174.3.1企业人事管理系统功能模块...............................174.3.2企业人事管理系统功能模块之间的关系.....................174.3.3系统流程...............................................