摘 要
本系統是以會計學的基本理論為基礎,我國會計電算化的管理體制為約束,結合中小企業的財務管理需求進行開發的。為實現會計電算化業務中的財務管理功能,系統采用了典型的信息管理系統(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.