南阳理工学院本科生毕业设计(论文)学院(系):软件学院专业:软件工程学生:金振涛指导教师:詹英李海波完成日期2012年04月南阳理工学院本科生毕业设计(论文)学校在岗人员工资核算系统的设计与实现DesignandImplementationofschool-staff’swagesaccountingsystem总计:毕业设计(论文)26页表格:8个图片:25个学校在岗人员工资核算系统的设计与实现南阳理工学院本科毕业设计(论文)学校在岗人员工资核算系统的设计与实现DesignandImplementationofschool-staff’swagesaccountingsystem学院(系):软件学院专业:软件工程学生姓名:金振涛学号:068108093指导教师(职称):詹英(副教授)李海波(助教)评阅教师:王豫峰完成日期:2012年04月10日南阳理工学院NanyangInstituteofTechnology学校在岗人员工资核算系统的设计与实现学校在岗人员工资核算系统的设计与实现软件工程金振涛[摘要]学校在岗人员工资核算系统是典型的信息管理系统,其开发主要包括后台数据库的建立和维护以及前台应用程序的开发两个方面。对于数据库要求数据一致性和完整性。而对于前台应用程序则要求功能完备,易使用。本系统把Microsoftvisualstudio2010作为开发工具,以SQLServer2008为数据库,实现了对员工签到请假、工资自动核算等相关功能。系统的开发步骤有系统分析、系统设计和系统实现。在系统的分析中,用数据流图、用例图分析了系统所需的各种数据。在系统的设计中,详细说明了系统的各个功能模块和数据库表。在系统的实现中,给出了系统功能的相应流程图、核心代码和运行界面。该系统能满足学校员工工资管理方面的基本要求。[关键词]员工工资;自动核算;签到学校在岗人员工资核算系统的设计与实现DesignandImplementationofschool-staff’swagesaccountingsystemSoftwareEngineeringMajorJinZhenTaoAbstract:DesignandImplementationofschool-staff‘swagesaccountingsystemisatypicalinformationmanagementsystem,whichmainlyincludesbuildingupthebackstagedatabaseanddevelopingtheForegroundapplication.Asthebackstagedatabaserequiresthedata'sconsistencyandintegralityTheForegroundapplicationshouldmakethefunctionpowerfulandeasilyused.ThissystemmaketheMicrosoftVisualstudio2010asthedeveloptoolsandSQLServer2008asthedatabase,cometruethestaff'sattendance,absenceandwagesautomatedaccountingfunctions.Thesystemdevelopmentprocessincludesystemsanalysis,systemdesignandsystemimplementation.Insystemanalysis,dataflowdiagramsandcasediagramcananalysiseverydatawhichthesystemisneeded.Insystemdesign,eachfunctionmoduleanddatabasetablesofthesystemcanbediscribedexplicitly.Inthesystemimplementation,thesystemfunctionofthecorrespondingflowchart,thecorecodeandruntheinterfacecanbegived.Thesystemcansatisfythebasicrequirementsinschool-staff’swagesmanagement.Keywords:staffsalary;automatedaccounting;signin学校在岗人员工资核算系统的设计与实现目录1.绪论.......................................................................................................................................11.1系统开发背景..............................................................................................................11.2工资管理的应用现状..................................................................................................11.3系统开发意义..............................................................................................................12.系统分析...............................................................................................................................22.1可行性分析..................................................................................................................22.2需求分析......................................................................................................................22.2.1功能需求............................................................................................................22.2.2非需求性分析....................................................................................................32.3系统用例图分析..........................................................................................................32.4数据流图......................................................................................................................52.5数据字典......................................................................................................................63.系统设计...............................................................................................................................83.1系统功能设计..............................................................................................................83.2系统数据库设计..........................................................................................................93.2.1数据概念结构设计............................................................................................93.2.2数据库表设计..................................................................................................114.系统实现与运行.................................................................................................................134.1系统登录的实现与运行............................................................................................134.2管理员操作的实现与运行........................................................................................134.2.1管理员查询操作的实现与运行......................................................................144.2.2员工职务调动的实现与运行..........................................................................154.2.3员工信息添加修改的实现与运行..................................................................164.2.4员工工资调整的实现与运行.............................................错误!未定义书签。4.2.5员工账号密码设置的实现与运行..................................................................174.3员工操作的实现与运行............................................................................................184.4员工工资核算的实现................................................................................................195.系统测试...........................................................