物資采購系統(tǒng)


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

目 錄

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

關(guān)鍵詞：C/S；PowerBuilder；SQL Server；企業(yè)物資采購
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