商場管理系統

論文字數:19149,頁數:85

摘要

商場管理系統是典型的信息管理系統(MIS),其開發主要包括后臺數據庫的建立和維護以及前端應用程序的開發兩個方面。對于前者要求建立起數據一致性和完整性強、數據安全性好的庫。而對于后者則要求應用程序功能完備,易使用等特點。 經過分析,我們使用 MICROSOFT公司的 VISUAL BASIC開發工具,利用其提供的各種面向對象的開發工具,尤其是數據窗口這一能方便而簡潔操縱數據庫的智能化對象,首先在短時間內建立系統應用原型,然后,對初始原型系統進行需求迭代,不斷修正和改進,直到形成用戶滿意的可行系統。
本系統主要完成對商場的管理，包括進貨管理，銷售管理，庫存管理和員工管理四個方面。系統可以完成對各類信息的瀏覽、查詢、添加、刪除、修改等功能。 系統的核心是銷售、庫存查詢和進貨管理三者之間的聯系，每一個表的修改都將聯動的影響其它的表，當完成銷售或進貨操作時系統會自動地完成相對應信息的修改。查詢功能也是系統的核心之一，在系統中主要根據商品編號和商品名稱等進行查詢，其目的都是為了方便用戶使用，以求更快的查找到各個物料和產品品質的基本信息。系統有完整的用戶添加、刪除和密碼修改功能，系統采用Microsoft Office中的Access 2000來設計數據庫，并使用當前優秀的開發工具—VB 6.0 ，它有著最為靈活的數據庫結構，對數據庫應用有著良好的支持。 論文主要介紹了本課題的開發背景，所要完成的功能和開發的過程。重點的說明了系統設計的重點、設計思想、難點技術和解決方案。

[英文摘要]
Summary
This system chiefly accomplishes the stock management to the storehouse,
includes being put in storage, goes out the warehouse and stocks, and staff’s information, six aspects such as supplier's information as well as cryptogram management etc. What the system can accomplish to various kind the information glances over and the function such as inquires about, adds, deletes andmodification etc.
The systematic nucleus is is put in storage, stocks and goes out the contact between the warehouse, and when accomplishes being put in storage or going out a warehouse, the system can accomplish voluntarily the modification of stock to other table of influence that the modification of every table all will be linkageed when operating. Inquiring about the function also is one of systematic nucleus, namely having the wallscroll spare to inquire about and inquires about with many conditions in the system, also having accurately the query to inquire about with bluring, not only there is the condition query of static state in the system, also having the condition query of trends formations, his purpose all is using for convenient user. The system has completeuser to add, deletes and the cipher modification function, and has the reportform and
prints the function.
The Access 2000 that the system adopted among Microsoft Office comes
the design data warehouse, and use before one zorch development tool - VB6.0, it has the most nimble data base structure, and the application has the
good support to the data warehouses.
The development background of this the subject, course of function and the development that will be accomplished were chiefly introduced to thesis.
The emphatic explanation focal point of systems design, design thought and difficult point technology and settlement scheme.
The keyword: the data base, SQL's language, vb6.0,'s data base package, the
Warehouse management.
關鍵字：控件、窗體、數據庫，visual basic語言，商場，商品

目錄
引言.......................................................1
Visual basic 6.0 簡介......................................... 2
1.1 Visual basic 6.0 簡介..........................2
1.2  ACCESS數據庫介紹........................................... 3
1.3  ADO技術................................................... 3
1.4  SQL語言....................................................4
第二章 商場管理系統................................... ......... 6
2.1系統分析.........................................6
2.2 數據庫設計...........................................7
2.3系統功能介紹...........................................9
2．4  流程圖和E-R圖設計……………………………………………………..10
2.5系統演示.......................................... .........14
第三章 系統測試.......................................... .......20
結束語.......... .......................................... ....24
參考文獻........ .......................................... ....25
代碼清單..... .......................................... .......27
附圖