摘 要
随着企业规模的不断扩大，对固定资产的管理是企业管理中一个重要部分，通过计算机软件来进行管理是当今时代的一个趋势。固定资产管理系统就为适应大多数中小企业的需求而设计的，其系统开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于数据库要求建立起数据一致性和完整性强、数据安全性好的库。而对于前端应用程序则要求应用程序功能完备,易使用，界面友好等特点。
本文主要论述了固定资产管理系统的开发流程与设计过程。首先，介绍开发环境包括数据库知识、开发工具和用到的相关技术；其次对系统进行分析，主要功能分为八个功能模块：系统登录、系统功能、资源申请、浏览信息、资产管理、查询与统计、日志查询、系统帮助；再次进行系统设计分为概要设计和详细设计，这部分主要介绍数据库设计；最后是系统实现，主要是资产申请模块和数据库连接。
本系统采用VC 6.0结合SQL Server 2000数据库管理系统作为基本的开发工具。本系统于其他同类产品的最大区别：资产申请模块是基于流程设计的，在使用上力求操作容易，界面美观，具有较高的扩展性和可维护性。
关键词：固定资产，管理，数据库.
Abstract
Along with the expansion of the enterprise’s scale, the fixed asset management has been an important part in the enterprise management, the management through the computer software has been a present tendency. The fixed asset management system is design for the most enterprise, the system development of which mainly includes the establishment and the maintenance of the backstage database as well as the application procedure development of the front end two aspects. For the database, the establishment of the data uniformity, the integrity and the data security are strongly requested. While the front end application procedure regard the application procedure function to be complete, easy usage, contact surface friendly and so on characteristics.
This article mainly elaborated the development flow and the design process of the fixed asset management system. First, introducing the development environment which including the database knowledge development kit and the relat无忧论文 【http://www.uklunwen.com】ed technology; Second, taking the analysis to the system, the main function is divided into eight function modules: the system registers, the system function, the resources application, the browsing information, the property management, the inquiry and the statistics, the diary inquiry, the system help; Third, the system design is divided into the outline design and the detailed design once more, this part mainly introduce database design; the Final is the system realization, which mainly include the property application module and the database connection.
This system takes VC 6.0, unifying SQL the Server 2000 database management system, as the basic development kit. This system has the biggest difference to other similar product: The property application module is based on the flow design, making every effort to make the operation in the use be easy, the contact surface is artistic, having the high extension and the maintainability.
Keywords: Fixed asset, Management, Database.
目录
1 前 言 1
2 开发环境概述 3
2.1 数据库应用系统开发简介 3
2.2 数据库理论基础 3
2.2.1 数据库设计及范式分析 3
2.2.2 SQL语言介绍 6
2.3 VC6.0 开发系统简介 7
2.3.1 VC6.0开发数据库技术的特点 7
2.3.2 ADO技术介绍 8
3 系统分析 10
3.1 系统简介 10
3.2 系统应用对象 10
3.3 系统中的角色 10
3.4 系统功能性需求 11
3.4.1 功能性需求分类 11
3.4.2 资产申请 13
3.4.3 其它 16
3.5 产品非功能性需求 17
3.5.1 用户界面需求 17
3.5.2 软硬件环境需求 17
3.5.3 系统质量需求 18
4 系统设计 19
4.1 概要设计 19
4.1.1 总体设计 19
4.1.2 接口设计 20
4.1.3 运行设计 21
4.1.4 出错处理设计及安全保密设计 21
4.1.5 界面设计 21
4.2 详细设计 24
4.2.1 数据库设计 24
4.2.2 主要模块 35
5 系统实现 |
|
支付方式咨询：357500023@qq.com