【正文】 超市進銷存管理系統(tǒng)的設計 1 摘要 超市急需現(xiàn)代計算機管理技術，本文主要設計并部分實現(xiàn)了超市進銷存系統(tǒng)，主要從以下五大部分論述了論文設計及具體的實現(xiàn)方法。第一部分簡要敘述了該系統(tǒng)的應用背景，提出傳統(tǒng)的進銷存軟件存在的問題，首先進行問題定義，解決目標問題，其次進行可行性研究，并從技術可行性，經(jīng)濟可行性和操作可行性進行詳細分析。第二部分敘述開發(fā)此系統(tǒng)的工具情況，簡述數(shù)據(jù)庫的設計原則，以及 Visual C++ 如何對數(shù)據(jù)庫的訪問。第三、四部分從數(shù)據(jù)庫的設計開始，進行了庫總體設計和界面詳細設計，闡述了如何設計各個模塊的流程和界面，以及具 體功能的設計。第五部分提出了設計的優(yōu)點及不足。 本設計運用計算機管理信息技術，建立數(shù)據(jù)庫，對超市的進銷存過程進行詳細的分析 ,實現(xiàn)了對超市的進貨、銷售和庫存的科學管理。 本系統(tǒng)主要包括以下幾大模塊： 基本信息：商品、部門、員工、用戶的信息的基本設置； 銷售：銷售訂貨 /退貨、銷售財務、銷售統(tǒng)計； 采購：采購訂貨 /退貨、商品報價與價格統(tǒng)計、財務、采購統(tǒng)計； 庫存：出入庫、庫存盤點、倉庫信息、庫存統(tǒng)計。 關鍵字 ：管理信息系統(tǒng)、數(shù)據(jù)庫、 SQL、 Visual C++、超市進銷存 超市進銷存管理系統(tǒng)的設計 2 ABSTRACT Supermarket is in urgent need of modern puter management technology ，This paper designs and realizes partially mainly supermarket enter to sell store system, major from following 5 most of have discussed paper design and specific realization method. The first minute the application that has narrated this system briefly background, put forward tradition enter to sell the problem of storing the existence of software , first, carry out problem definition , solve goal problem , carry out feasibility research secondly , and carry out detailed analysis from technical feasibility, economic feasibility and operating feasibility. It is second and partial to narrate the design principle that develops the tool condition of this system and summarizes database , as well as Visual C + + how to for database visit. The 4 minutes of 3th have carried out storehouse overall design and interface detailed design from the design of database, have elaborated how to design interface and the process of every modular, as well as the design of specific function. The 5th has put forward the advantage of design partially and is below. This system uses the information technology of puter management, set up the database , sell the course of storing to carry on detailed analysis to the entering of the supermarket, have realized the purchase , sale and cientific management held in store to the supermarket. This system includes following few big modulars mainly: Basic information: The basic installation of merchandise, department and the information of employee and user。 Sales: Sell order / to return goods , sales finance and sales statistics。 It is buying: Buy order / to return goods , merchandise quotation and price statistical, financial, buying statistics。 It is in stock: Come in and go out storehouse and stock to check inventory , storehouse information and statistics in stock. The keyword : Management information system、 Database、 SQL 、 Visual C + + 、 Supermarket enter to sell store 超市進銷存管理系統(tǒng)的設計 3 目錄 第一章 系統(tǒng)需求分析 ................................................................. 6 系統(tǒng)應用背景 .......................................................................... 6 進銷存系統(tǒng)需求分析 .......................................................... 6 計算機管理系統(tǒng)的優(yōu)勢 ..................................................... 7 系統(tǒng)可行性分析 ..................................................................... 8 技術可行性 ........................................................................ 8 經(jīng)濟可行性 ........................................................................ 8 系統(tǒng)功能需求簡介 ................................................................. 9 第二章 開發(fā)工具的選擇和介紹 ........................................... 10 VISUAL C++概述 ..................................................................10 Visual C++簡介 ............................................................10 Visual C++特點 ............................................................10 Visual C+++數(shù)據(jù)庫訪問控件 ...................................... 11 SQL SERVER 2021 概述 .......................................................... 11 數(shù)據(jù)庫簡介 ..................................................................... 11 數(shù)據(jù)庫系統(tǒng)的設計選擇原則 ..........................................12 SQL Server 2021 的特征 .................................................13 Visual C+++訪問 SQL Server 數(shù)據(jù)庫 .............................13 超市進銷存管理系統(tǒng)的設計 4 第三章 數(shù)據(jù)庫的設計 .......................................................... 15 系統(tǒng)功能設計 ..........................................................................15 數(shù)據(jù)庫的設計 ........................................................................15 數(shù)據(jù)表結構清單 ................................................................16 各數(shù)據(jù)表的關系 ................................................................22 數(shù)據(jù)字典 ..................................................................................23 第四章 系統(tǒng)的設計 ................................................................. 24 系統(tǒng)基本模塊介紹 ..................................................................24 登錄窗口的設計和實現(xiàn) ..........................................................25 系統(tǒng)主窗口的設計 ..................................................................27 菜單欄的設計 ..........................................................................28 基本信息管理設計 ..................................................................28 商品基本信息的設計 .........................................................29 部門和員工基本信息的設計 .............................................31 用戶基本信息的設計 .........................................................33 銷售管理的設計 ......................................................................35 商品銷售管理的設計與實現(xiàn) .............................................35 商品銷售財務的設計 .........................................................37 商品銷售統(tǒng)計的設計 .........................................................40 采購管理的設計 ......................................................................42 采購訂貨、退貨的設計 .....................................................42 超市進銷存管理系統(tǒng)的設計 5 商品報價管理與統(tǒng)計的設計 .............................................45 商品采購財務的設計 ..............