The Design And Development Of Finance System Aimed To Medium-sized Hospital

ERP-based Finance Management Information System(briefly named EFMIS) is an instance of the development of finance software to management information system and is an effective tool to improve management level, which can make an entire management of human resource, material, finance in the hospital and its subordinates. As the most difficulty integrated system to most enterprises, EFMIS is not mature yet. Especially to hospital as a special kind of enterprise, the problems of organization structure and Finance Regulation is more obvious, therefore, the design and development of EFMIS is very important for Hospital Information System (HIS).The composing of finance data flow of hospital and the different requirement from different users are analyzed. And the relation between EFMIS and other related subordinates is confirmed. According to ERP thought, the module and structure of the system are designed. And the designing ideas and aims of EFMIS are confirmed, system structure is selected, tables of relation database are designed, which mainly focuses on the mutual relation of each parts and the realization scheme. At last the system is finally developed. To the problem that former FMIS received computed data not original data passively, we introduce new design scheme, that is to say EFMIS no longer received data from other modules passively but takes data on its own initiative and avoids receiving anamorphic data. So that real-time control management is promised.The system is developed with SQL Server 2000 and C# on the flat of .NET. During the development, stored procedure is adopted to solve the problem of big data so as to decrease data transmission between clients and servers, job is used to order data disposal so as to lighten the burden of servers, views and Crystal Report are used to display finance reports so as to perfect man-machine conversation.Through the test between EFMIS and other related branches, data is collected successfully and computed correctly. And information integration and real-time control to related human resource, material and finance are realized. The aim of the design and development of EFMIS is achieved successfully.