住房公积金会计账务系统的分析、设计与实现

【作者】 王立强；

【导师】 李庆忠；

【作者基本信息】 山东大学 ， 计算机技术， 2005， 硕士

【摘要】 随着住房制度的改革,全国各地都集中了数目较大的住房资金,如住房公积金、住房补贴、售房款以及城市住房基金等,这些资金关系到国家、集体及职工个人的利益。如何采用现代化的管理手段管理好这部分资金,充分发挥它在住房改革中的作用,已成为亟待解决的问题。而现有的商品化财务电算化软件由于其设计开发时主要是站在通用性、一般性的角度来完成的,因而不能够完全适应住房公积金财务管理的要求,所以开发一套住房公积金财务电算化软件,使其能够针对住房公积金财务管理又具有一般财务软件的功能,成为一个非常迫切,非常必要的课题。 本课题围绕住房公积金财务管理进行了大量的调研,在大量调研的基础上明确了住房公积金财务管理的内容。运用面向对象软件开发技术及统一软件开发过程思想对住房公积金财务会计系统进行需求分析、系统建模、体系设计、数据库设计及编程实现,所做的主要工作和取得的主要成果如下: 1.账务需求分析 采用面向对象技术对公积金账务系统软件进行了需求分析,建立了系统的“系统管理与初始化建账”用例,给出了系统的“会计账务子系统”用例,并对此进行了用例分析。由此明确了住房公积金会计账务系统软件的需求目标。 2.账务系统建模 运用UML(统一建模语言)对系统进行了静态建模及动态建模,建立了系统的总体功能结构设计;建立了系统初始化类图、凭证类图及系统的其他静态类图。建立了系统的动态视图即系统总体流程活动图、系统凭证处理顺序图、系统账簿活动图。 3.会计账务体系结构及数据库设计 对系统的体系结构进行了分析设计,明确了系统前台编程语言采用面向对象的Visual Basic 6,系统后台数据库选用Microsoft SQL2000数据库。对用到的数据表进行了范式设计,给出了全部的数据表设计。 4.编程实现及“凭证自动生成”问题的探讨与实现 运用面向对象的编程语言VB6对全部的分析设计予以实现。特别对于“凭证自动生成”问题进行了初步的探讨,给出了它的用例图,对其进行了用例分析及流程分析,并对其编程实现。更多还原

【Abstract】 With the housing system reform, a great variety of housing funds have emerged across China, including housing accumulation funds (HAF), housing allowances, proceeds of housing sales and urban housing funds. All these funds concern the interests at different levels of nation, collectives and individual workers. Therefore, how to manage these funds through modern management means so as to play their full role in the housing system reform has called for an exigency to deal with. Since the existing kinds of commercialized financial computerization software were designed for general and universal purposes, they cannot appropriately meet the needs of managing the HAF. To develop a purpose-specific software has become a necessity and an urgency to cater to the needs of managing HAF, in addition to the common functions of existing kinds of financial software.This project made lots of research on the financial management on housing accumulation funds. On the basis of research, the contents of financial management on housing accumulation funds are defmitized. By using of object-oriented software developing technology and the idea of unified software development process, we analyze the requirement, system modeling, architecture designing, database designing, and program on Housing Accumulation Funds’ Accounting System(HAFAS). The main research work and achievements include:1. Financial Requirement AnalysisBy using of object oriented technology, we make requirements analysis on HAFAS, set up the use cases diagram on "system management & accounting initialization" and "sub-accounting financial system". Besides, we analyze some use-cases. Therefore, the requirement and objective of HAFAS is clarified.2. Modeling on Financial SystemBy using of unified modeling language, we make static modeling and dynamic modeling on the system, design the whole functional structure, set up system initialize class diagram, vouchers class diagram and other static diagram on the system. The dynamic diagram of the system viz. systematic general process activity diagram, systematic vouchers processing sequence diagram and system account book activity diagram are set up.3. Accounting Architecture and Database DesigningWe analyze and design the system structure, adopt object-orient Visual Basic 6 as system foreground programming language, choose Microsoft SQL2000 as background database platform. The database tables where used are designed by normal form, and the all database tables are designed.4. The Discussion and Realization on the Issue of Programming Realization and Automatically Generated VouchersThe all analysis and design are realized by exerting object-orient programmed language VB6. Especially, the pilot research on automatically generated vouchers is carried out, and the use cases diagram is given out. Additionally, analysis on use-cases, process flow and programming are realized.The innovation of this project is that the "Automatically Generated Vouchers" and the "Interest Calculate and Process on HAFAS" are thoroughly realized.The HAF system has been practised for seven or eight years in China, but the development and application of HAF—specific software are still at its earlier stage. This paper focuses such a specific software development and application by means of analysis and overview. This academic effort is hoped to promote the HAF-specific software development and application, and contribute to the on-going housing system reform.更多还原