物資采購(gòu)系統(tǒng)


頁(yè)數(shù)：10 字?jǐn)?shù)：2945

目 錄

摘 要 1
Abstract 2
第1章 緒論 1
1.1企業(yè)物資采購(gòu)管理系統(tǒng)概述 1
1.1.1企業(yè)物資采購(gòu)管理的概念 1
1.1.2傳統(tǒng)企業(yè)物資采購(gòu)的弊端 1
1.1.3企業(yè)物資采購(gòu)中常遇的問(wèn)題 2
1.2企業(yè)物資采購(gòu)管理系統(tǒng)的展望 2
第2章 PowerBuilder基礎(chǔ) 4
2.1應(yīng)用程序設(shè)計(jì) 4
2.1.1客戶/服務(wù)器應(yīng)用程序 4
2.1.2應(yīng)用程序開(kāi)發(fā)步驟簡(jiǎn)述 5
2.2 PB開(kāi)發(fā)規(guī)范 7
2.2.1 PB開(kāi)發(fā)標(biāo)準(zhǔn)與命名約定 7
2.2.2 PB開(kāi)發(fā)界面規(guī)范 11
2.3嵌入SQL語(yǔ)句 13
第3章 采購(gòu)管理系統(tǒng)總體設(shè)計(jì) 21
3.1項(xiàng)目概述 21
3.2業(yè)務(wù)可行性分析 22
3.3系統(tǒng)開(kāi)發(fā)環(huán)境 23
3.3.1硬件環(huán)境 23
3.3.2軟件環(huán)境 24
3.4數(shù)據(jù)庫(kù)訪問(wèn)模式 28
3.5系統(tǒng)設(shè)計(jì)概述 29
3.6采購(gòu)流程圖 32
第4章 子系統(tǒng)設(shè)計(jì)及其實(shí)現(xiàn) 33
4.1系統(tǒng)結(jié)構(gòu) 33
4.2數(shù)據(jù)庫(kù)設(shè)計(jì) 35
4.2.1管理ODBC數(shù)據(jù)源 35
4.2.2系統(tǒng)數(shù)據(jù)庫(kù)表格設(shè)計(jì) 37
4.3系統(tǒng)菜單的設(shè)計(jì) 41
4.4登陸窗口設(shè)計(jì) 45
4.5主窗口設(shè)計(jì) 48
4.6用戶管理 49
4.7系統(tǒng)日志管理 50
4.8修改密碼窗口設(shè)計(jì) 52
4.9供應(yīng)商信息管理 54
4.10員工信息管理 55
4.11訂單管理 56
第5章 安裝與發(fā)布 57
5.1 Wise Installer介紹 57
5.2 數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序及ODBC數(shù)據(jù)庫(kù)接口文件 57
結(jié)束語(yǔ) 59
致 謝 60
參考文獻(xiàn) 61
摘 要
隨著信息技術(shù)的發(fā)展及ERP系統(tǒng)的日益普及，計(jì)算機(jī)在企業(yè)管理中的作用越來(lái)越不容忽視。企業(yè)之間通過(guò)網(wǎng)絡(luò)交易的趨勢(shì)越來(lái)越明顯。在這種環(huán)境中，采購(gòu)作為企業(yè)生產(chǎn)經(jīng)營(yíng)的一個(gè)重要環(huán)節(jié)應(yīng)加強(qiáng)管理，充分利用外部環(huán)境條件，逐步實(shí)現(xiàn)企業(yè)物資采購(gòu)的網(wǎng)絡(luò)化管理。企業(yè)物資采購(gòu)網(wǎng)絡(luò)管理系統(tǒng)是針對(duì)企業(yè)內(nèi)部而設(shè)計(jì)的，應(yīng)用于企業(yè)的局域網(wǎng)，這樣可以使得企業(yè)內(nèi)部管理更有效的聯(lián)系起來(lái)。
本課題就是針對(duì)企業(yè)的采購(gòu)管理，開(kāi)發(fā)一個(gè)基于C/S（Client/Server）構(gòu)架的管理系統(tǒng)，我采用了目前流行的Powerbuilder做開(kāi)發(fā)工具，后臺(tái)采用SQL Server數(shù)據(jù)庫(kù)。其中系統(tǒng)涉及系統(tǒng)管理、基礎(chǔ)數(shù)據(jù)、單據(jù)錄入三大模塊。系統(tǒng)管理模塊包括：用戶管理、日志管理、修改密碼、注銷、退出系統(tǒng)。基礎(chǔ)數(shù)據(jù)模塊包括：產(chǎn)品編碼、供應(yīng)商信息、員工信息、倉(cāng)庫(kù)信息、商品信息。單據(jù)錄入模塊包括：訂單管理、外銷清單、內(nèi)銷清單、入庫(kù)單、出庫(kù)單。論文首先全面而系統(tǒng)地研究了構(gòu)建一個(gè)企業(yè)物資采購(gòu)網(wǎng)絡(luò)管理系統(tǒng)所必備的各種知識(shí)和技術(shù)手段，進(jìn)行系統(tǒng)可行性分析，介紹系統(tǒng)開(kāi)發(fā)環(huán)境，設(shè)計(jì)系統(tǒng)數(shù)據(jù)庫(kù)，規(guī)劃企業(yè)物資采購(gòu)流程，接下來(lái)進(jìn)行系統(tǒng)總體設(shè)計(jì)，子系統(tǒng)的開(kāi)發(fā)與實(shí)現(xiàn)，最后是測(cè)試、安裝與發(fā)布的說(shuō)明。
論文在撰寫過(guò)程中，力求將理論與實(shí)踐結(jié)合起來(lái)，在對(duì)企業(yè)物資采購(gòu)理論進(jìn)行闡述的同時(shí)，配合模擬系統(tǒng)從實(shí)際應(yīng)用和操作技巧上加以說(shuō)明，以達(dá)到對(duì)企業(yè)物資采購(gòu)管理系統(tǒng)更深層次的理解和認(rèn)識(shí)。

關(guān)鍵詞：C/S；PowerBuilder；SQL Server；企業(yè)物資采購(gòu)
Abstract
With the development of the information technology and the prevalence of the ERP system, it is hardly to ignore the play of the computer in enterprise management. It is more apparent that many commercial actions among many enterprises are taking place in the network. Under the circumstances, purchasing management, which is an important link of enterprise operation, must be strengthened firstly. Then, purchasing management will be put into execution with the good condition, which the outer circumstances provide. Aiming at the management in enterprise, the system, which will be put into execution with LAN, will make the management in enterprise better.
The thesis aims at the purchasing management in enterprise, which is based on C/S(Client/Server) structure. I choose the prevalent PowerBuilder as development tool, and SQL Server as background database. The system includes three modules: system management, basal data, enter bill of document. system management module includes: users management, log file management, amending password, logout, exit. basal data module includes: production coding, supplier information, employee information, storage information, commodity information. enter bill of document module includes: order form management, export bill, sale in domestic market, bill of enter and out of storage. Starting with conceiving an application system of purchasing management in enterprise, we need to investigate the knowledge and the technique, then analyse the feasibility of the system, introduce the develop environment, design database and the flow of the purchasing management. The following is that whole-design, developing subsystem, the instruction of testing, installation and issuance.
During the course of writing this article, the author strives to integrate theory and practice. While expatiating the theory of purchasing management in enterprise, the author illuminates the application and operation skill combining the system so as to make a better understanding to purchasing management in enterprise.

Keywords: C/S; PowerBuilder; SQL Server; purchasing managem