房地产销售管理系统VB

摘 要

随着社会主义市场经济的建立与发展，我国房地产行业迅速崛起。房地产业的兴旺发达促进了相关行业的极大繁荣，如建材、建筑设计、施工、房地产销售、市场营销、律师业等。但是在房地产销售中也出现了一些问题。如资料管理手段落后，销售工作不规范等。这些问题导致了房地产销售行业的效率低下。在日趋激烈的市场竞争环境中，需要运用先进的IT信息技术和现代管理思想来提高房地产行业的管理水平、工作效率和服务质量。进一步降低运营成本、提高经济效益，最终提升房地产销售公司的市场竞争力。

计算机被广泛应用于信息管理系统的环境。计算机的最大好处在于利用它能够进行信息管理。使用计算机进行信息控制，不仅提高了工作效率，而且大大的提高了其安全性。尤其对于像学生这样复杂的信息管理，计算机能够充分发挥它的优越性。

房地产销售管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。经过分析,我使用 Microsoft公司的Visual Basic开发工具,利用其提供的各种面向对象的开发工具,尤其是数据窗口这能方便而简洁操纵数据库的智能化对象,首先在短时间内建立系统应用原型,然后,对初始原型系统进行需求迭代,不断修正和改进,直到形成用户满意的可行系统，再结合学生信息管理的要求，对SQL Server 2000数据库管理系统、SQL语言原理、Visual Basic应用程序设计，Visual Basic数据库技术进行了较深入的学习和应用，主要完成对房地产销售管理系统的需求分析、功能模块划分、数据库模式分析，并由此设计了数据库结构和应用程序。

本论文主要包括概述，总体设计，数据库设计，详细设计和系统测试与开发结果共五章内容及开发本系统其它有关信息。第1章主要介绍本系统的特点、开发背景、开发目的、开发目标以及开发本系统所需要的开发工具等。第2章主要介绍本系统开发的前期工作，包括需求分析、可行性分析以及本系统的功能设计等。第3章第1节主要进行数据库的设计，包括数据库的需求设计、概念设计和逻辑设计。第2节和第3节主要介绍数据库的实现及数据库的约束性，并在数据库的实现中对Server SQL 2000和Visual Basic进行设置和对数据库的创建。第4章在前两章的前期工作的基础上进行详细设计。第1节主要对各个功能模块进行流程设计，第2节主要对各个功能模块的窗体进行设计。第5章主要介绍对系统测试和开发结果的介绍。

为此，本文开发了房地产销售管理信息系统。本系统的应用对于规范房地产市场运作和管理具有一定的现实意义。。

关键词 控件，窗体，域，数据库，SQL语言， Visual Basic

i

Abstract

With the establishment and development of the socialist market economy, China's real estate industry is rapidly emerging. The prosperity of the real estate industry to promote the great prosperity of the related industries, such as building materials, architectural design, construction, real estate sales, marketing, lawyers industry. But in the real estate sales, there have been some problems. Behind such as data management tools, sales are not standardized. These problems lead to inefficiencies of the real estate sales industry. In the increasingly fierce market competition environment, the need to use advanced IT information technology and modern management thinking to improve the management level of the real estate industry, working efficiency and quality of service. To further reduce operating costs, improve economic efficiency, and ultimately enhance the market competitiveness of the real estate sales company.

The computer is widely used in environmental information management system. The greatest advantage of the computer is to use it to information management. The use of computers for control of information, not only to improve the work efficiency, and greatly improve its security. Especially for such a complex as student information management, the computer can give full play to its advantage.

Real estate sales management system is a typical management information system (MIS), includes the development of the back-end database establishment and maintenance of the front-end application development aspects. For the former requirement to establish data consistency and integrity, data security, a good library. For the latter requires the application fully functional, easy to use features. After analysis, I use Microsoft's Visual Basic development tool, its use of the various object-oriented development tools, especially the intelligent object data window which can be simple and easy to manipulate the database system applications, the first in a short time demand iterative prototype, and then, the initial prototype system, constantly revised and improved, until the formation of a viable system of customer satisfaction, combined with the student information management requirements of SQL Server 2000 database management system, the principle of the SQL language, Visual Basic application Programming Visual Basic database technology more in-depth learning and application, mainly to complete the student information management system needs analysis, division of function modules, database schema analysis and design of database structure and application.

This dissertation includes an overview of the overall design, database design, detailed design and system testing and development results in five chapters the content and development of the system other relevant information. Chapter 1 introduces the characteristics of the system development background, the purpose of development, development objectives and the development of the system development tools. Chapter 2 introduces the development of the system of preliminary work, including requirements analysis, feasibility analysis, and the functions of the system design. Chapter 3, a database design, including requirements for the database design, conceptual design and logical design. 2 and 3 introduces the database implementation and database constraints, and the realization of the database in Server SQL 2000 and Visual Basic to set up and create the database. Chapter 4 of the first two chapters of the preliminary work on the basis of the detailed design. 1, the various functional modules, process design, the two main design the form of various functional modules. Chapter 5 introduces the introduction of the results of system testing and development.

To this end, we developed a real estate sales management information system. The application of this system for the specification of the operation and management of the real estate market has some practical significance. .

Keywords： control, form, domain, database, SQL language, the Visual Basic

ii

目 录

摘 要 ............................................................................................................................................... i Abstract .............................................................................................................................................ii 目 录 ..............................................................................................................................................ii 第1章 概述 ..................................................................................................................................... 1

1.1 开发背景 ............................................................................................................................ 1 1.2 开发目的 ............................................................................................................................ 1 1.3 系统特点 ............................................................................................................................ 1 1.4 项目开发的目标 ................................................................................................................ 2 1.5 开发的要求 ........................................................................................................................ 2 1.6 开发环境 ............................................................................................................................ 2

1.6.1 Visual Basic简介 ..................................................................................................... 2 1.6.2 Server SQL 2000 简介 ............................................................................................ 4

第2章 总体设计 ............................................................................................................................. 8

2.1 设计方案 ............................................................................................................................ 8

2.1.1 需求分析 ................................................................................................................. 8 2.1.2 设计原则 ................................................................................................................. 8 2.1.3 界面风格的设计 ..................................................................................................... 8 2.1.4 操作界面: ................................................................................................................ 9 2.1.5 应用目标 ................................................................................................................. 9 2.1.6 作用及范围 ............................................................................................................. 9 2.1.7 出错处理 ................................................................................................................. 9 2.1.8 安全保密设计 ......................................................................................................... 9 2.2 系统的可行性研究 ............................................................................................................ 9

2.1.1 技术可行性 ............................................................................................................. 9 2.1.2 经济可行性 ........................................................................................................... 10 2.2.3 时机可行性 ........................................................................................................... 10 2.2.4 操作可行性 ........................................................................................................... 10 2.2.5 管理上的可行性 ................................................................................................... 10 2.3 房地产销售管理系统结构流程设计 .............................................................................. 10

2.3.1 功能需求 ............................................................................................................... 11 2.3.2 系统功能分析 ....................................................................................................... 11 2.3.3 系统功能模块设计 ............................................................................................... 11

第3章 数据库设计 ....................................................................................................................... 13

3.1 数据库具体设计 .............................................................................................................. 13

3.1.1 数据库需求设计 ................................................................................................... 13 3.1.2 数据库概念设计 ................................................................................................... 14 3.1.3 数据库逻辑结构设计 ........................................................................................... 15 3.2 数据库结构的实现 .......................................................................................................... 18

3.2.1 SQL Server 2000设置 ........................................................................................... 18 3.2.2 Visual Basic设置及创建数据库 ........................................................................... 19 3.3 数据库的完整性约束 ...................................................................................................... 19

ii

3.3.1 实体完整性 ........................................................................................................... 19 3.3.2 参照完整性 ........................................................................................................... 19 3.3.3 用户定义完整性 ................................................................................................... 19

第4章 详细设计 ........................................................................................................................... 20

4.1功能流程设计 ................................................................................................................... 20

4.1.1 登录系统流程图 ................................................................................................... 20 4.1.2 添加用户功能流程图 ........................................................................................... 20 4.1.3 修改密码功能流程图 ........................................................................................... 21 4.1.4 楼盘设置功能流程图 ........................................................................................... 22 4.2 房地产销售管理系统各个功能模块的实现 ................................................................ 23

4.2.1创建工程项目—房地产销售管理系统.vbp ......................................................... 23 4.2.2 创建房地产销售管理系统的主窗体 ................................................................... 23 4.2.3 创建主窗体的菜单 ............................................................................................... 25 4.2.4 创建公用模块 ....................................................................................................... 25 4.2.5 系统用户管理模块的创建 ................................................................................... 25 4.2.6 数据管理模块的创建 ........................................................................................... 26

第5章 系统测试与开发结果 ....................................................................................................... 28

5.1 系统测试 .......................................................................................................................... 28

5.1.1 测试方案 ............................................................................................................... 28 5.1.2 测试项目 ............................................................................................................... 28 5.1.3 测试评价 ............................................................................................................... 28 5.2 开发结果 .......................................................................................................................... 28

5.2.1 产品 ....................................................................................................................... 28 5.2.2 主要功能及性能 ................................................................................................... 29 5.2.3 所用工时 ............................................................................................................... 29 5.2.4 运行环境 ............................................................................................................... 29

总 结......................................................................................................................................... 30 致 谢......................................................................................................................................... 31 参考资料......................................................................................................................................... 32

iii