小型超市进存销管理系统—毕业设计.doc

基于Delphi的小型超市进存销管理系统 摘 要 在市场经济中，销售是企业运作的重要环节，为了更好地推动销售，不少企业建立分公司代理，通过分公司或代理把产品推向最终用户。这些分公司或代理商大多分布在全国各地，甚至是在国外，远距离频繁的业务信息交流构成了这些企业业务活动的主要特点。在传统方式上，公司之间通常采用电传、电报、电话等方式传递发货、到货、压货、换货、退货等信息，并且对进货、销售、库存等信息进行手工存档，工作效率极其低下。 本毕业设计针对传统的进存销系统的一些弊端,根据进存销系统的基本流程，实现了一个小型超市的进存销管理系统。本系统主要包含有资料管理、进货管理、销售管理、库存查询、系统管理、历史查询、账目查询等进存销管理的基本功能。其中，资料管理包括有商品资料、供货商资料、客户资料的添加、删除、修改、查询等操作。本系统采用C/S模式，由 Delphi 7.0开发，数据库设计使用MS SQL Server2000。 关键词：SQL Server 2000；进存销管理系统 The Stocking Selling and Storing Management System of Small Supermarket Based on Delphi Abstract Salesmanship is an important part of operation of enterprises in the market economy. In order to promote the sales of the produces, many enterprises establish the agencies of branch, push products to the terminal customers through these agencies. Many agencies or branches are distributed all over the country, even abroad, so that the main feature of these business activities is remote frequent exchange of operational information. In the traditional way, the company usually exchange messages about the transmission, arrival, storage, change, return of goods by telex, telegraph, telephone and store the data of Purchase, Sale, Storage by manual. The working efficiency is extremely low. According to the basic process of the Stocking Selling and Storing Management , the author realized a Stocking Selling and Storing Management System of small supermarket. The basic functions of this system include data management, inventory management, sales management, storage inquiry, system management, history inquiry, account inquiry. The data management which include add, delete, modify and inquire the data about goods, data about supplier and data about customer. The system uses C/S model and has been developed by Delphi 7.0. Database design use SQL Server 2000. Key words: C/S model; Delphi; SQL Server 2000; Stocking Selling and Storing 目 录 1引言 1 1.1 课题背景与开发目的 1 1.2 开发环境 1 1.3 硬件需求 1 ２系统总体设计 2 2.1 功能概述 2 2.2 数据库设计 3 2.2.1 数据库概念模型 3 2.2.2 数据库各表设计