含代碼
摘要
隨著計(jì)算機(jī)技術(shù)的迅猛發(fā)展，計(jì)算機(jī)給人們帶來(lái)了很多便利，人們借助于計(jì)算機(jī)進(jìn)行生產(chǎn)勞動(dòng)管理更加方便。百貨商場(chǎng)管理系統(tǒng)是現(xiàn)代百貨商場(chǎng)對(duì)商業(yè)進(jìn)行管理、查詢和記錄的信息管理系統(tǒng)。它能實(shí)現(xiàn)縱觀整個(gè)百貨商場(chǎng)的商業(yè)動(dòng)態(tài)、分類查看等精細(xì)化管理。通過對(duì)商品,客戶,商品進(jìn)貨,銷售,人事等細(xì)化管理,及時(shí)了解商業(yè)動(dòng)態(tài)，便于決策部門正確的作出商業(yè)業(yè)規(guī)劃，最大限度的提高百貨商場(chǎng)的競(jìng)爭(zhēng)力和管理效率。
本文通過對(duì)現(xiàn)代企業(yè)信息化管理進(jìn)行分析，根據(jù)百貨商場(chǎng)信息化管理的實(shí)際需求，設(shè)計(jì)并實(shí)現(xiàn)了一個(gè)基于WEB技術(shù)的百貨商場(chǎng)管理系統(tǒng)。該系統(tǒng)由七個(gè)功能模塊組成，即：用戶管理模塊、商品信息管理模塊、客戶信息管理模塊、商品進(jìn)貨管理模塊、商品銷售管理模塊、人事信息管理模塊、數(shù)據(jù)報(bào)表模塊和系統(tǒng)配置模塊。
本文不僅敘述了該商場(chǎng)管理系統(tǒng)的設(shè)計(jì)過程，包括需求分析，系統(tǒng)架構(gòu)的設(shè)計(jì)，以及功能模塊的劃分等，而且詳盡敘述了各個(gè)功能模塊的具體實(shí)現(xiàn)方法，包括如何在服務(wù)器端響應(yīng)客戶請(qǐng)求，如何進(jìn)行相應(yīng)的數(shù)據(jù)庫(kù)訪問、以及如何進(jìn)行用戶權(quán)限分配等。系統(tǒng)的開發(fā)采用了ASP技術(shù)，以SQL Server 2000作為后臺(tái)數(shù)據(jù)庫(kù)，WEB服務(wù)器使用IIS，并且采用B/S模式，實(shí)現(xiàn)系統(tǒng)的高效運(yùn)行，并且安裝方便，配置簡(jiǎn)易。

關(guān)鍵詞：百貨商場(chǎng)管理；商品；信息管理;ASP;數(shù)據(jù)庫(kù);B/S;高效

Abstract
With the rapid development of computer technology, the computer has brought people a lot of convenience, people with the help of computer production management to be more convenient. shopping malls management system is a modern shopping malls in business management, query and records information management system. It can realize the throughout the department store business dynamics, classification view and other fine management. Through to commodity, customers, commodity purchase, sales, personnel management, timely understanding business dynamics, the decision-making department can correct to make business planning, the maximum increase of shopping malls ' competitive ability and management efficiency.
In this thesis, the shopping malls management system based on WEB is designed and realized by analysis of the modern enterprise information management and according to its actual requirement. This system is composed of seven function modules, which includes commodity information management module, customer information management module, commodity purchase management module, the commodity sales management module, the personnel information management module, report module and system configuration module.
This thesis not only describes procedures of designing the shopping malls management system which includes requirement analysis, design of system frame and division of function module, but also describes in detail about development methods of every functional module, which includes how to respond the customers' request at the server, how to access database and how to assign of user authority and etc. This system is based on the popular B/S mode, mainly uses ASP technolgy as a development language, uses SQL Server 2000 to design the database on the backstage, the Web server use IIS. It realizes the convenient install, running effectively and simple configuration.
Key words: Shopping Malls Management；Commodity；Information Management；ASP;Database;B/S; Efficiency

目錄
1 引言 1
1.1 系統(tǒng)設(shè)計(jì)目的及意義 1
1.2 系統(tǒng)特色 2
2系統(tǒng)開發(fā)環(huán)境和選擇工具 3
2.1 ASP簡(jiǎn)介 3
2.1.1 ASP 運(yùn)行環(huán)境（IIS） 4
2.1.2 ASP 提供了6個(gè)內(nèi)置的全局對(duì)象 4
2.1.3 ASP 技術(shù) 4
2.2 Dreamwever簡(jiǎn)介 5
2.3數(shù)據(jù)庫(kù)SQL SERVER 2000 簡(jiǎn)介 5
3 系統(tǒng)設(shè)計(jì) 6
3.1 需求分析 6
3.1.1 系統(tǒng)功能分析 6
3.2總體設(shè)計(jì) 7
3.2.1核心模塊：商品管理模塊 7
3.2.2管理信息發(fā)布模塊 8
3.2.3客戶管理模塊 9
3.2.4員工管理模塊 9
3.2.5管理交流模塊 9
3.2.6系統(tǒng)配置模塊 9
4 詳細(xì)設(shè)計(jì) 11
4.1商品管理模塊 11
4.1.1 商品信息管理模塊 11
4.1.2 貨品管理模塊 12
4.1.3 商品銷售管理 14
4.1.4 商品數(shù)據(jù)報(bào)表 14
4.2管理信息發(fā)布模塊 14
4.3客戶管理與員工管理 16
4.4管理交流模塊 17
4.5系統(tǒng)配置模塊 18
4.5.1用戶管理模塊 18
4.5.2修改密碼模塊 18
4.5.3退出系統(tǒng)模塊 18
5 系統(tǒng)的實(shí)現(xiàn) 19
5.1系統(tǒng)的主界面實(shí)現(xiàn) 19
5.2 ASP訪問數(shù)據(jù)庫(kù)的實(shí)現(xiàn) 20
5.3 用戶登錄模塊的實(shí)現(xiàn) 20

5.4 添加功能模塊的實(shí)現(xiàn) 24
5.5修改功能模塊實(shí)現(xiàn) 30
5.6刪除功能模塊實(shí)現(xiàn) 31
5.7查詢功能模塊實(shí)現(xiàn) 31
5.8留言板功能模塊實(shí)現(xiàn) 33
5.9郵件發(fā)送功能模塊實(shí)現(xiàn) 35
5.10銷售排名，銷售警示，銷售榜樣功能模塊實(shí)現(xiàn) 37
5.11報(bào)表打印，打印預(yù)覽 39
6.結(jié)論 40
7.致謝 41
8.參考文獻(xiàn) 42

8.參考文獻(xiàn)
[1] 鄧文淵.ASP與網(wǎng)絡(luò)數(shù)據(jù)庫(kù)技術(shù)[M].北京：中國(guó)鐵道出版社,2005。
[2] 梁喜超,盧山.ASP后臺(tái)數(shù)據(jù)庫(kù)實(shí)例經(jīng)典[M].北京：冶金工業(yè)出版社,2001。
[3] Greg Buczek.ASP應(yīng)用開發(fā)指南[M].北京：科學(xué)出版社,2000。
[4] 方睿,吳四九.網(wǎng)絡(luò)數(shù)據(jù)庫(kù)原理及應(yīng)用[M].四川：四川大學(xué)出版社,2005。
[5] 張莉,王強(qiáng).SQL Server數(shù)據(jù)庫(kù)原理及應(yīng)用[M].北京：清華大學(xué)出版社,2003。
[6] 陳明.實(shí)用軟件工程基礎(chǔ)[M].北京：清華大學(xué)出版社,2002。
[7] 屈喜龍,朱杰. ASP+SQL Server開發(fā)動(dòng)態(tài)網(wǎng)站實(shí)例薈萃[M].北京：機(jī)械工業(yè)出版社,2006。