会计电算化系统的设计与实现——财务管理子系统
摘 要
本系统是以会计学的基本理论为基础,我国会计电算化的管理体制为约束,结合中小企业的财务管理需求进行开发的。为实现会计电算化业务中的财务管理功能,系统采用了典型的信息管理系统(MIS)模式。本系统主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面,系统为 C/S架构。系统的后台数据库采用SQL Server 2000建立,其提供了强大而稳定的企业级数据库开发平台,实现了数据一致性、完整性及安全性上的要求。并且SQL Server的存储过程特性,为本系统业务功能的实现提供了解决方案。系统的前台应用程序采用DELPHI 7.0进行开发。DELPHI的ADO组件提供了强大而快捷的数据库控件,能方便而简洁操纵数据库的智能化对象,实现了短期内开发出用户满意的可行系统。本系统的会计业务功能是通过调用存储过程实现,满足了功能的稳定性和安全性要求。
关键词: 会计电算化;财务管理;凭证;存储过程;ADO SQL;DLL; QuikRep
Design and Realization of Computerized Accounting System- - Financial Management Subsystem
Abstract
This system is based on the principles of accountancy, constrained by Chinese accounting by EDP, combined with the financial management requirement of middle & small enterprises to develop. To implement the financial management function in accounting by EDP, system applies typical MIS model. The establishment & maintenance of background database as well as the front-end application development are included with this system, system is the C/S structure. System's background database is established by SQL Server 2000, which provides powerful & stable enterprise database development platform to realize data consistency, integrality and security. Moreover, the storage process feature of SQL Server provides solution for this system business function. System's front-side application is developed by DELPHI 7.0, whose ADO components offer powerful & quick database control, to operate database's intelligentized objective conveniently & quickly and develop the application system to meet clients' requirement within short period. The accountancy business function of this system is realized by saving process, to meet the functional stability & security requirement.