【正文】 of market demanddesignated sales plans and objectives of management purposes. The system has two modules: one reception, including sales personnel log about to sell items to add to the sales table and print the date and time the small ticket。 本系統(tǒng)主要有兩個模塊：一是前臺，主要包括售貨人員的登錄， 對即將 要賣出的商品添加到銷售表中并根據(jù)當(dāng)時的日期和時間打印小票；二是后臺，主要是對商品信息、管 理人員、數(shù)據(jù)庫等的維護，具體是分為六個小模塊：基本信息的維護包括商品信息、員工信息、供應(yīng)商信息的維護，銷售管理包括銷售退貨、銷售查詢、銷售退貨查詢，倉庫管理包括入庫登記、入庫退貨、庫存信息、退貨查詢，財務(wù)管理包括日結(jié)查詢、月結(jié)查詢，數(shù)據(jù)庫管理包括數(shù)據(jù)庫的備份、數(shù)據(jù)庫的還原、數(shù)據(jù)庫的初始化，系統(tǒng)管理包括用戶管理、幫助文檔等功能。 畢業(yè)設(shè)計報告 (論文 ) 報告 (論文 )題目： 基于 B/S結(jié)構(gòu)的企業(yè)進銷存 管理系統(tǒng) 作者所在系部： 計算機科學(xué)與工程系 作者所在專業(yè)： 計算機科學(xué)與技術(shù) 作者所在班級： B09512 作 者 姓 名 ： 作 者 學(xué) 號 ： 指導(dǎo)教師姓名： 完 成 時 間 ： 2021328 北華航天工業(yè)學(xué)院教務(wù)處制 摘 要 隨著社會的發(fā)展，企業(yè)進銷存管理系統(tǒng)已成為當(dāng)前典型的信息管理系統(tǒng)，本系統(tǒng)是在分析了現(xiàn)行的商品管理中存在的問題的基礎(chǔ)上，結(jié)合企業(yè)信息管理系統(tǒng)開發(fā)的概念、結(jié)構(gòu)以及系統(tǒng)開發(fā)的基本原理和方法，開發(fā)的 一套企業(yè)信息管理系統(tǒng)。在當(dāng)前的市場經(jīng)濟體制下，企業(yè)要提高市場的競爭力，不但要有好的產(chǎn)品，也要有好的銷售服務(wù)，對于企業(yè)本身而言，企業(yè)若想較好的發(fā)展，就必須得到很好的管理，為此，擁有一套完善的并且適合企業(yè)自身特點的信息化管理系統(tǒng)已經(jīng)迫在眉睫，同時，以實現(xiàn)更好的降低成本、及時反饋市場信息、完善服務(wù)質(zhì)量、提高經(jīng)濟效益、分析市場需求，指定銷售計劃和目標(biāo)等的管理目的 。 關(guān)鍵詞： 系統(tǒng)設(shè)計 數(shù)據(jù)庫 信息 進銷存 Abstract With the development of society, the enterprise inventory management system has bee the typical information management system, the system is on the basis of analysis of the existing problems in the current modity management, bined with the development of the concept of enterprise information management systems, structure andthe basic principles and methods of system development, the development of an enterprise information management system,under current market economic system, enterprises should improve the petitiveness of the market, not only have a good product, but also have a good sales and service for the enterprise itself, if you want a good development, it is necessary to get a goodmanagement, this has a prehensive information management system for the enterprise39。 second is the background, mainly on the product information management, database maintenance, concrete is divided into six modules: the maintenance of basic information, including product information, employee information, supplier information maintenance, sales management, including sales returns, sales inquiries, sales returns query warehouse management including warehousing registration, warehousing returns, inventory information, return query, financial management, including dayend query, monthly queries, database management, including database backup, database restore, database initialization, system management, including user management , help documentation functions. Keyword: system design database information stock sale and storage 目 錄 摘 要 .................................................................................................................................... I Abstract .................................................................................................................................II 第 1 章 緒 論 ................................................................................................................... 1 課題研究現(xiàn)狀分析 ............................................................................................... 1 本領(lǐng)域內(nèi)已開展的研究工作 ..................................................................... 1 已經(jīng)取得的研究成果 ................................................................................. 2 選題的目的及意義 ............................................................................................... 2 設(shè)計目的 ...................................................................................................... 2 設(shè)計意義 ...................................................................................................... 3 課 題研究的主要內(nèi)容 ........................................................................................... 3 第 2 章 系統(tǒng)需求分析 ....................................................................................................... 4 問題的提出 ........................................................................................................... 4 開發(fā)運行環(huán)境 ....................................................................................................... 4 開發(fā)環(huán)境 ..................................................................................................... 4 數(shù)據(jù)庫 ......................................................................................................... 4 系統(tǒng)的設(shè)計目標(biāo) ................................................................................................... 5 第 3 章 系統(tǒng)總體設(shè)計及思路 ........................................................................................... 6 系統(tǒng)層次模塊圖 .................................................................................................... 6 數(shù)據(jù)庫設(shè)計 ............................................................................................................ 6 庫中各個表的設(shè)計 ............................................................................................... 7 用戶表 .......................................................................................................... 7 商品表 ......................................................................................................... 7 商品銷售表 ................................................................................................. 8 供應(yīng)商信息表 ............................................................................................. 8 銷售退貨表 ................................................................................................. 8 商品入庫信息表 ......................................................................................... 9 倉庫商品退貨表 ..............................