【正文】 中文題目： XXXX管道公司物料流通管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 外文題目： THE DESIGN AND IMPLEMENTATION OFMATERIALS CIRCULATION MANAGEMENT SYSTEM FOR XX(XX) COMPANY 畢業(yè)設(shè)計(jì)（論文）共 頁(yè)（其中：外文文獻(xiàn)及譯文 頁(yè)） 完成日期 2020年 6月 答辯日期 2020年 6月 I 摘要 物料相關(guān)數(shù)據(jù)的統(tǒng)計(jì)對(duì)生產(chǎn)型公司的發(fā)展及決策起著重要的作用?？蛻魴n案的，物料基礎(chǔ)信息，庫(kù)存，銷售，進(jìn)貨等一系列的 管理的自動(dòng)化能夠大幅度提高企業(yè)的管理效率?，F(xiàn)有物料管理系統(tǒng)已實(shí)現(xiàn)了商品銷售，原材料進(jìn)貨，庫(kù)存管理數(shù)據(jù)等各種統(tǒng)計(jì)數(shù)據(jù)，從而大大減少了數(shù)據(jù)的流通環(huán)節(jié)，增強(qiáng)了數(shù)據(jù)的可靠性。此系統(tǒng)是一個(gè)單機(jī)版的信息管理系統(tǒng)。前臺(tái)應(yīng)用程序界面采用 Eclipse 開發(fā)，系統(tǒng)的后臺(tái)數(shù)據(jù)庫(kù)選用 SQL 2020 作為開發(fā)工具。系統(tǒng)的主要功能是對(duì)原材料的進(jìn)貨、產(chǎn)品銷售和庫(kù)存進(jìn)行監(jiān)控、調(diào)配和管理，以實(shí)現(xiàn)公司物料流通管理的信息化、自動(dòng)化和科學(xué)化。通過企業(yè)物料流通管理系統(tǒng)，利用信息化的手段把先進(jìn)的管理方法引入企業(yè)，為企業(yè)的管理改革提供切實(shí)可行的途徑 。 關(guān)鍵詞： 企業(yè)物料流通管理系統(tǒng) ； C/S； Eclipse； SQL 2020 數(shù)據(jù)庫(kù) II ABSTRACT The material data for the development of productionoriented enterprises is very important. Basic information management, inventory management, sales management, purchasing management and a series of activities automation improve the efficiency of enterprise management greatly. The material circulation management system already have able to achieve goods saling, raw materials purchasing, inventory data management, thus greatly reducing the data circulation, enhances the reliability of data. This system is a standalone version of the information management system. Reception application interface using Eclipse development, the choice of SQL 2020 database background as a development tool. The main function of the system is monitoring, deployment and management for raw materials purchasing, product saling and inventory. to achieve the enterprises 39。 material circulation management, automation and scientific. Through the enterprise material circulation, using information technology ways to introduce the advanced methods of management of enterprises to provide practical ways for enterprise management reform Key Words : Enterprise material circulating management system。 C/S。 Eclipse。 SQL 2020 database 目錄 引言 ....................................................................................................................... 1 1 項(xiàng)目概述 ........................................................................................................... 2 公司簡(jiǎn)介 ......................................................................................................... 2 組織機(jī)構(gòu)及業(yè)務(wù)范圍 ...................................................................................... 3 業(yè)務(wù)流程描述 ................................................................................................. 4 現(xiàn)系統(tǒng)存在的問題及薄弱環(huán)節(jié)分析 .............................................................. 6 2 需求分析 ........................................................................................................... 7 總體目標(biāo) ......................................................................................................... 7 具體目標(biāo) ......................................................................................................... 7 系統(tǒng)功能建模 ................................................................................................. 8 系統(tǒng)數(shù)據(jù)流程圖 .......................................................................................... 8 數(shù)據(jù)字典 .....................................................................................................11 系 統(tǒng)數(shù)據(jù)模型 ................................................................................................16 3 概要設(shè)計(jì) ..........................................................................................................20 體系結(jié)構(gòu)設(shè)計(jì) ................................................................................................20 代碼設(shè)計(jì) ........................................................................................................21 數(shù)據(jù)庫(kù)設(shè)計(jì) ....................................................................................................23 關(guān)系模式設(shè)計(jì) .............................................................................................23 物理設(shè)計(jì) .....................................................................................................24 輸入輸出設(shè)計(jì) ................................................................................................27 輸入設(shè)計(jì) .....................................................................................................27 輸出設(shè)計(jì) .....................................................................................................28 4 詳細(xì)設(shè)計(jì) ..........................................................................................................30 系統(tǒng)管理 ........................................................................................................30 模塊定義 .....................................................................................................30 輸入項(xiàng)目 .....................................................................................................30 輸出項(xiàng)目 .....................................................................................................30 程序邏輯 .....................................................................................................30 基礎(chǔ)信息管理 ................................................................................................32 模塊定義 .....................................................................................................32 輸入項(xiàng)目 .....................................................................................................32 輸出項(xiàng)目 .....................................................................................................32 程序邏輯 .....................................................................................................32 查詢統(tǒng)計(jì) ........................................................................................................33 模塊定義 .....................................................................................................33 輸入項(xiàng)目 ..............................................................