目 录
摘 要 1
Abstract 2
引 言 3
1 信息管理系统概述 4
1.1 管理信息系统概述 4
1.2 管理信息系统的开发 4
2 需求分析 8
2.1 系统需求 8
2.2 功能需求 9
3 系统设计与分析 10
3.1 系统开发的软硬件环境要求 10
3.2 系统流程分析 10
3.3 功能模块划分 11
4 数据库设计 12
4.1 数据库管理系统 12
4.2 创建数据库 13
4.3 DELPHI数据库访问方法与数据库组件介绍 14
5 系统功能模块设计 15
5.1 登录模块的设计 15
5.2 系统体设计 18
5.2.1 增添记录 18
5.2.2 编辑记录 24
5.2.3 查询信息 26
5.2.4 打印数据 28
5.2.5 管理功能 29
6 系统测试 31
7 小 结 32
致 谢 33
参考文献 34
英文文献 35
文献翻译 39
ERP系统中财务模块的分析与设计
摘 要:本程序设计的是财务模块中一个小型商店每天记的流水帐管理程序,没有具体到销售的每一样商品,只是记载了每一笔的收入和支出情况。经过简单扩充就可以成为一个完整的商店销售管理系统。下面来说一下本程序的各个模块的功能及数据库的结构。
关键字:流水帐管理、delphi 7、access2000
ERP system in the financial module of
the Analysis and Design
Abstract: This procedure is designed to store a small daily in mind Liushui Zhang management procedures, not specific to each of the same merchandise for sale, only a record of each of the income and expenditure. After a simple expansion can become a complete shop sales management system. Below, some of the procedures of the various modules of the function and structure of the database.
Keyword: Liu Shuizhang management, delphi 7, access2000
引 言
财务管理信息系统的出现可以使人更合理高效准确管理企业的资金周转,同时提高工作效率,简化繁琐的手工统计和信息汇总的人工工作。财务管理系统是每一个单位管理财务收入和支出的不可缺少的一个管理信息系统,它的内容对企业财务计划,财务控制,财务监督,财务运用等方面都起着巨大的作用。如何发挥财务管理的作用关系到一个企业的命脉。
因此,开发这样一套管理软件成为很有必要的事情,对于我们即将计算机专业毕业的学生来说,也是一次将计算机应用于现实管理的一次很有意义的实践活动。
网络经济时代,由于经济活动的数字化、网络化,出现了许多新的媒体空间,如虚拟市场、虚拟银行。许多传统的商业运作方式将随之消失,而代之以电子支付、电子采购和电子定单,商业活动将主要以电子商务的形式在互联网上进行,使企业购销活动更便捷,费用更低廉,对存货的量化监控更精确。这种特殊的商业模式,使得企业传统的财务管理已不能适应基于互联网的商业交易结算。
1 信息管理系统概述
1.1 管理信息系统概述
管理信息系统(MIS)的概念是1961年美国人J。D。GALLAGHER首先提出来的,是一门新兴的、集管理科学、信息科学、系统科学及计算机科学为一体的综合性学科,研究的是企业中信息管理活动的全过程,以便有效的管理信息,提供各类管理决策信息,辅助企业进行现代化管理。
管理信息系统是企业的信息系统,它具备数据处理、计划、控制、预测和辅助决策功能,具体作用如下:
(1) 用统一标准处理和提供信息,排除使用前后矛盾的不完整的数据。
(2) 完整、及时提供在管理及决策中需要的数据。
(3) 利用指定的数据关系式分析数据,客观预测未来。
(4) 向各级管理机构提供不同详细程度的报告,缩短分析和解释时间。
(5) 用最低的费用最短的时间提供尽可能精确、可靠的信息,以便使决策者选择最佳的实施方案,以提高企业的经济效益。
1.2 管理信息系统的开发
管理信息系统的开发是一项大的系统工程性质的工作,一般的系统工程均要有三个成功要素,这就是:①合理确定系统目标;②组织系统性队伍;③遵循系统工程的开发步骤。所有这些要素均要在坚强的领导下才能完成。
首先是领导问题。由于信息系统耗资巨大,历时相当长,并且是涉及到管理方式变革的一项任务,因而必须主要领导亲自抓才能成功。美国的经验是信息系统之所以失败,原因是主要管理者不是参加者,而是旁观者。我国这几年的实践也证实了这一点。因而可以说主要领导者参与是管理信息系统开发的先决条件。因为主要领导者最清楚自己企业的问题,最能合理地确定系统目标,他拥有实现目标的人权、财权、指挥权,他能够决定投资、调整机构、确定计算机化水平等,这是任何其他人都不能替代的。现在我国许多企业领导还缺乏管理信息系统的知识。
作为领导人员怎样领导管理信息系统的开发工作呢?首先领导人员应有一些管理信息系统的基本知识,能大概地知道计算机原理和其功能,以及它包括的主要设备;其次,领导人员最主要的应有提高自己企业管理水平的设想和运用现代管理科学的设想;再次,领导人员要懂得管理信息系统的开发步骤和每步的主要工作;最后,领导者要会用人,会组织队伍。
领导者推动管理信息系统的第一步是建立一个信息系统委员会,信息系统委员会是领导者的主要咨询机构,又是信息系统开发的最高决策机构,其人员包括对信息系统要求较多的各级管理组织的主要负责人,如财务科、计划科、销售科等。还包括一些有经验的管理专家,例如掌握预测技术和计划技术的专家。还应包括信息系统的系统分析员。信息系统委员会的主要工作是确定系统目标,审核和批准系统方案,验收和鉴定系统以及组建各种开发组织。
组成队伍后,如果是进行全厂信息系统开发,则应首先进行全系统的规划,系统规划是全面的长期的计划,在规划的指导下就可以进行一个个项目的开发,见下图,它画出了系统开发的各个步骤。Directory
Summary 1
Abstract 2
Introduction 3
An Information Management System Overview 4
1.1 Management Information System Overview 4
1.2 Management Information System 4
2 Requirements Analysis 8
2.1 System Requirements 8
2.2 Functional Requirements 9
3 System Design and Analysis 10
3.1 System hardware and software environment requirements 10
3.2 System Flow Analysis of 10
3.3 Function module division 11
4 Database Design 12
4.1 Database Management System 12
4.2 Creating a database 13
4.3 DELPHI database access methods and database components introduced 14
5 System Function Module 15
5.1 Log Module 15
5.2 System Design 18 Body
5.2.1 adds record 18
5.2.2 Edit Record 24
5.2.3 query information 26
5.2.4 Print Data 28
5.2.5 management functions 29
6 System Test 31
7 Summary 32
Thanks 33
References 34
English Literature 35
Literature Translation 39
ERP Systems Analysis and Design of the financial module
Abstract: The program design is the financial module in a small store a day to remember running account management procedures, there is no specific as to the sale of each commodity, but a record of every income and expenditures. After a simple extension can become a full stores management system. Here is what this program features the various modules and database structure.
Keywords: running account management, delphi 7, access2000
ERP system in the financial module of
the Analysis and Design
Abstract: This procedure is designed to store a small daily in mind Liushui Zhang management procedures, not specific to each of the same merchandise for sale, only a record of each of the income and expenditure. After a simple expansion can become a complete shop sales management system. Below, some of the procedures of the various modules of the function and structure of the database.
Keyword: Liu Shuizhang management, delphi 7, access2000
Introduction
The emergence of financial management information system can give people a more rational and efficient and accurate management of business cash flow, while improving work efficiency and simplify the tedious manual labor statistics and information summary of work. Financial management system for every one unit of financial management of income and expenditure as an indispensable management information system, which the contents of corporate financial planning, financial control, financial control, financial and other aspects of the use plays a huge role. How to play the role of financial management related to the lifeblood of an enterprise.
Therefore, developing such a management software as necessary thing, for we are about computer science graduate students, but also a reality of management of the computer used in a meaningful practical activities.
Network economy, due to the economic activity in digital networks, there have been many new media space, such as virtual markets, virtual bank. Many of the traditional business mode of operation will subsequently disappear, replaced by electronic payments, e-procurement and electronic orders, business activity will be mainly in the form of e-commerce on the Internet to enable enterprises to buying and selling activities more convenient and more affordable, to more accurate quantitative monitoring of inventory. This particular business model, allows businesses the traditional Internet-based financial management can not meet the settlement of commercial transactions.
An Information Management System Overview
1.1 Management Information System Overview
Management Information System (MIS) concept in 1961 American J. D. GALLAGHER first proposed, is a new, set of management science, information science, systems science and computer science as an integrated discipline, is the study of enterprise information management activities in the whole process so that effective management information, provide various types of management decision-making information to support modern management of enterprises.
Management Information System is the enterprise information system, which has data processing, planning, control, forecasting and decision support functions, specific roles are as follows:
(1) with a unified standard processing and provision of information, excluding the use of inconsistent and incomplete data.
(2), complete, timely decision-making in the management and the required data.
(3) using the specified data relationship analysis of data, objective and predict the future.
(4) to all levels of management to provide different levels of detail of the report, shortening the analysis and interpretation of the time.
(5) with the shortest possible time at minimal cost to provide the most accurate and reliable information so that decision makers select the best implementation plan to improve the economic efficiency of enterprises.
1.2 Management Information System
Management information system development is a major engineering work of this nature, the general systems engineering have to have three success factors, that is: ① reasonably determine system objectives; ② the ranks of organized systematic; ③ follow the steps in the development of systems engineering. All these elements have to be in a strong leadership to complete.
The first is leadership. As information systems costly and lasted very long, and is related to management changes in a task, and must be major leaders personally attend to be successful. The U.S. experience is the reason why information systems fail, because the manager is not the main participants, but bystanders. The practice of the past few years China has also confirmed this point. And thus can be said that the main leaders involved in the management of information systems development prerequisites. Because the main leaders of the most aware of their business problems, it can reasonably determine system objectives, he has to achieve its objectives of human rights, financial authority, command, he can decide to invest, restructure institutions and to determine the level of computerization, it is any other person can not be replaced. Now many of our business leaders is also a lack of management information systems of knowledge.
As leaders how to lead the development of management information system work? First of all leaders should have some basic knowledge of management information systems, can probably know the computer theory and its functions and which includes the major equipment; Secondly, the leaders of the most important to improve their management level should have the vision and the idea of modern management science; again, leaders must know how to manage information systems development steps and each step of the main work; Finally, leaders must be servants, will organize teams.
Leaders to promote the first step in management information system is to establish an Information Systems Committee, the Information Systems Committee is the principal advisory body to the leader, but also the highest development of information systems decision-making body, its personnel, including system requirements for more information at all levels of management principal responsible persons of the organization, such as Finance, Planning Section, Sales Branch. Also includes a number of experienced management experts, such as forecasting techniques and master plan for the technology experts. It should also include information systems systems analyst. Information Systems Committee''s main task is to determine the system objectives, review and approval of system solutions, inspection and identification systems, and the formation of a variety of development organizations.
The composition of team, if it is plant-wide information systems development, they should first conduct a system-wide planning, system planning is a comprehensive long-term plans in the planning can be carried out under the guidance of a project''s development, see below, it depict the various steps of system development