【正文】 ........................................... 2 企業(yè)采購管理系統(tǒng)的展望 ......................................................................... 2 第 2章 PowerBuilder 基礎 ............................................................................. 4 應用程序設計 ............................................................................................. 4 客戶 /服務器應用程序 .................................................................... 4 應用程序開發(fā)步驟簡述 .................................................................. 5 PB 開發(fā)規(guī)范 ............................................................................................... 7 PB 開發(fā)標準與命名約定 ................................................................ 7 PB 開發(fā)界面規(guī)范 ...........................................................................11 嵌入 SQL 語句 ........................................................................................... 13 第 3章 采購管理系統(tǒng)總體設計 .................................................................... 21 項目概述 ................................................................................................... 21 業(yè)務可行性分析 ....................................................................................... 22 系統(tǒng)開發(fā)環(huán)境 ........................................................................................... 23 硬件環(huán)境 ........................................................................................ 23 軟件環(huán)境 ........................................................................................ 24 數(shù)據庫訪問模式 ....................................................................................... 28 系統(tǒng)設計概述 ........................................................................................... 29 采購流程圖 ............................................................................................... 32 第 4章 子系統(tǒng)設計及其實現(xiàn) ........................................................................ 33 系統(tǒng)結構 ................................................................................................... 33 數(shù)據庫設計 ............................................................................................... 35 管理 ODBC 數(shù)據源 .......................................................................... 35 系 統(tǒng)數(shù)據庫表格設計 .................................................................... 37 系統(tǒng)菜單的設計 ....................................................................................... 41 登陸窗口設計 ........................................................................................... 45 主窗口設計 ............................................................................................... 48 目 錄 2 用戶管理 ................................................................................................... 49 系統(tǒng)日志管理 ........................................................................................... 50 修改密碼窗口設計 ................................................................................... 53 供應商信息管理 ....................................................................................... 55 員工信息管理 ......................................................................................... 56 訂單管理 ................................................................................................. 57 第 5章 安裝與發(fā)布 ........................................................................................ 58 Wise Installer 介紹 ............................................................................. 58 數(shù)據庫驅動程序及 ODBC 數(shù)據庫接口文件 ............................................ 58 結束語 ..................................................................................................................... 60 致 謝 ..................................................................................................................... 61 參考文獻 ................................................................................................................. 62 摘 要 1 摘 要 隨著信息技術的發(fā)展及 ERP 系統(tǒng)的日益普及，計算機在企業(yè)管理中的作用越來越不容忽視。 企業(yè)之間 通過網絡 交易的趨勢越來越明顯。 企業(yè)采購網絡管理系統(tǒng)是針對企業(yè)內部而設計的，應用于企業(yè)的局域網，這樣可以使得企業(yè)內部管理更有效的聯(lián)系起來。其中系統(tǒng)涉及系統(tǒng)管理、基礎數(shù)據、單據錄入三大模塊?；A數(shù)據模塊包括：產品編碼、供應商信息、員工信息、倉庫信息、商品 信息。論文首先全面而系統(tǒng)地研究了構建一個企業(yè)采購網絡管理系統(tǒng)所必備的各種知識和技術手段，進行系統(tǒng)可行性分析，介紹系統(tǒng)開發(fā)環(huán)境，設計系統(tǒng)數(shù)據庫，規(guī)劃企業(yè)采購流程，接下來進行系統(tǒng)總體設計，子系統(tǒng)的開發(fā)與實現(xiàn)，最后是測試、安裝與發(fā)布的說明。 關鍵詞： C/S； PowerBuilder； SQL Server；企業(yè)采購 摘 要 2 Abstract With the development of the information technology and the prevalence of the ERP system, it is hardly to ignore the play of the puter in enterprise management. It is more apparent that many mercial actions among many enterprises are taking place in the work. 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, modity 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