摘 要
隨著計算機技術的普及應用,現代城市中的居民小區也廣泛地引入了信息管理機制。本文以Visual Basic 6.0和SQL Server 2000作為開發工具,設計了一套針對現代小區物業管理的信息化平臺,主要實現了業主信息管理、物管費用管理、業主投訴管理和小區設備的運維管理等模塊。
對所選課題的背景進行了簡單的介紹,提出對本課題的研究方法。對Visual Basic 6.0和SQL Server 2000進行簡單的介紹。提出設計的架構,定出4個功能模塊,畫出系統流程圖和系統功能結構圖。根據上述2圖,進行數據庫的設計,添加一個系統用戶信息表,共設計5張表。再根據5張表,進行界面設計,寫出代碼和界面的截圖。完成設計并進行系統測試。
關鍵詞:數據庫;物業管理;信息管理;Visual Basic6.0;SQL server 2000
The Design and Implementation of the Estate Management System
Abstract
Along with the popularization application of the computer technology, the information management mechanism has been widely introduced into the inhabitant plot of modern city. The paper takes Visual Basic 6.0 and SQL Server 2000 as the development tool, designs a set of estate management system. This platform is in the view of the modern plot, it mainly realizes the modules of the owner information management, the service fare management, the complaining management and the community equipment information management and so on.
The paper makes a simple introduction for the background of the task which has been chosen, and then puts forward the way of research for the paper. It also makes a simple intro of the Visual Basic 6.0 and SQL Server 2000. Then the paper put forward the configuration of the design, aim to decide to design 4 function modules and paint the pictures of system flow and system function configuration., and design the database based on the 2 pictures, add a datasheet which named the sheet of system user information, and the total number of the sheet is 5. Then it designs the interface base on the 5 sheet, write the code and put the pictures which has been intercepted on the paper. This system has been debugged when the project finished.
Key words: database; Estate management; information management; Visual Basic6.0; SQL server 2000