超市零售管理系统

沈阳理工大学课程设计实践论文I摘要21世纪，超市的竞争也进入到了一个全新的领域，竞争已不再是规模的竞争，而是技术的竞争、管理的竞争、人才的竞争。技术的提升和管理的升级是超市业的竞争核心。零售领域目前呈多元发展趋势，多种业态：超市、仓储店、便利店、特许加盟店、专卖店、货仓等相互并存。如何在激烈的竞争中扩大销售额、降低经营成本、扩大经营规模，成为超市营业者努力追求的目标。此次我使用VisualFoxPro6.0编程，实现了一个简易的超市零售管理系统。本系统通过对超市零售管理系统进行需求分析和设计逐步将该系统的实现过程呈现出来。该系统可以对超市商品的入库和出库进行登记，同时还能对商品信息和价格进行查询。关键词：数据库；VisualFoxPro6.0；零售；查询沈阳理工大学课程设计实践论文II目录1前言································································································11.1作业背景·····················································································11.2选题说明·····················································································11.2.1基本思路···············································································11.2.2作业目标···············································································11.3工作业绩·····················································································21.3.1主要收获················································································21.3.2自我评定···············································································22系统总体设计····················································································32.1系统结构图·················································································32.2数据库总体设计············································································32.3需求分析·····················································································32.4所需的数据表···············································································42.4.1所需的数据表结构·································································42.5建立项目·····················································································53建立数据库和数据库表········································································73.1建立数据库··················································································73.2建立数据表··················································································74表单的设计·······················································································84.1登录表单设计···············································································84.2商品入库出库输入表单设计·····························································84.2.1商品入库表单设计····································································84.2.2商品出库输入表单设计····························································104.3商品价格查询表单设计·································································124.3.1查询表单设计········································································124.3.2信息修改表单········································································194.4销售表单设计···········································································254.4.1销售价格信息表单设计····························································25沈阳理工大学课程设计实践论文III4.4.2表单销售汇总表设计·······························································275主程序和系统连编············································································305.1主程序设计················································································305.2系统连编···················································································31结束语································································································32参考文献·····························································································33沈阳理工大学课程设计实践论文11前言1.1作业背景本文根据《数据库应用与开发》课程要求而做。课程作业要求如下：用数据库管理系统开发工具（VisualFoxPro）开发一个实用的小型管理信息系统。根据课程设计时间选择适当规模大小的设计题目，按照系统开发的流程及方法，踏实地开展课程设计活动。课程设计活动中，撰写相关技术文档。最后提交详细的课程设计报告。开发出可上机运行的管理信息系统，通过上机检查。1.2选题说明要在有限的两周时间设计出一个小型的超市零售管理系统，考虑到我们知识面和视野以及信息系统的价值性，我决定设计一个日常生活中比较常见的超市零售管理系统。这个系统能够对大学生成绩进行查询和管理，比较贴近我们大学生的实际，具有较强的可行性、实践性和价值性。1.2.1基本思路设计该系统时，采用自底向上的设计方法。首先设计数据结构，然后设计表单、菜单、报表，最后设计主程序。1.2.2作业目标要实现对超市商品信息和销售价格的管理，应该有库存管理和价格查询功能。要退出系统，需要有退出功能。如果想打印价格表，应该提供打印功能。所以超市使用本系统，可以迅速提升超市的管理水平，降低经营成本，提高效益，增强超市扩张力，提供有效的技术保障。沈阳理工大学课程设计实践论文21.3工作业绩1.3.1主要收获通过这学期对数据库这门课的学习，我对数据库有了基本的了解。学会了怎样制作表单，菜单等内容，这对以后的学习工作有了很重大的帮助。我通过这两周的课程设计：课程设计的选题，构思，讨论，分配任务，设计程序等工作，其中遇到了很多的困难，但是没有放弃，解决问题，排除困难，这才一步步完成每个任务，还使我掌握了使用各种关系数据库为后台数据库设计一个信息管理系统。总之，这次课程设计受益匪浅，不仅锻炼了我做事坚持不懈的心态，也慢慢地培养了我不懂就查书的好习惯，我的自学能力也有了一定的提高，我更明白了搞计算机程序设计，要学到真正的技术完全要靠自己，在课堂上只能学到最基本的东西，但这最基本的东西也一定要学好。1.3.2自我评定□优□良□中□及格□不及格沈阳理工大学课程设计实践论文32系统总体设计2.1系统结构图开发该系统前，先要有一个清晰的系统总体功能图。在超市零售管理系统中，由项目管理器统一管理系统中的表单、数据表、程序、报表以及主菜单。系统的整体结构是先运行主程序。表单和报表中的数据来自数据表中的数据。如图2.1图2.1该系统应包括如下几个功能模块，功能模块结构如下图所示(1）输入单据：出库、入库、产成品清单(2）查询：出库查询、入库查询、产成品查询(3）销售：销售费用、销售退款、进/退货(4）打印报表：入库报表、出库报表。2.2数据库总体设计进行数据库总体设计首先要进行需求分析，由需求确定系统所需要的数据表，然后确定表所需的字段，最后确定各个表之间的关联。2.3需求分析超市销售管理系统主要包括商品入库出库情况登记、商品信息及价格查询和销售业绩汇总等功能。每个功能都要通过表单和报表来操作数据表中的数据，沈阳理工大学课程设计实践论文4每个数据表存储了本系统所需要的数据信息。所以在进行数据库设计之前，要分析出系统所需要的数据表。2.4所需的数据表分析超市零售管理系统的情况，首先需要了解商品的基本信息，即需要基本状况表。用户需要查询商品的生产厂商和价格等信息，所以需要的数据表有商品入库表、商品厂商信息表和销售表等。2.4.1所需的数据表结构表1：入库单字段名数据类型长度（字节）备注入库编号文本20主键商品型号文本20计量单位文本8单价货币16数量数字16金额货币16生产厂商文本50外键出厂日期日期16仓管员文本20外键表2：厂商信息表字段名数据类型长度（字节）备注厂商编号文本20主键厂商名称文本50厂商地址文本50联系电话数字20法人地表文本20表3：销售单字段名数据类型长度（字节）备注单据编号文本20主键商品型号文本20沈阳理工大学课程设计实践论文5