哈尔滨工业大学成人高等教育毕业设计(论文)
摘 要
计算机管理信息系统是一项系统工程，综合了计算机、网络、数据库、通
讯技术，也包括了企业管理科学和众多丰富实践经验的总结。它是先进科学技
术和现代企业经营管理结合的范例。它的产生和运行是企业经营管理发展到一
定阶段、一定规模及特定经济环境下的必然要求。
目前，全球药品市场竞争日益激烈，超市企业要想获得持续性的赢利取决
于 其 是 否 能 够 赢 得 和 保 持 相 当 的 客 户 的 满 意 度 。 经 过 分 析 ， 我 们 使 用
MICROSOFT 公司的 VISUAL BASIC 开发工具，利用其提供的各种面向对象的开发
工具，尤其是数据窗口这一能方便而简洁操纵数据库的智能化对象，首先在短
时间内建立系统应用原型，然后，对初始原型系统进行需求迭代，不断修正和
改进，直到形成用户满意的可行系统。
关键词：窗体,域,数据库。
哈尔滨工业大学成人高等教育毕业设计(论文)
Abstract
The calculator management information system is a system
engineering, synthesizing the calculator, network, database, the
communication technique, also including the business enterprise
management science and numerous abundant empirical summary of
fulfillment.It is the example that the advanced science technique
combines with the modern business enterprise management. Its
creation and movement is the business enterprise management
management develops the certain stage, inevitable request of certain
scale and particular and economic environmentses are. Currently, the
global drugs` market competition is increasingly vigorous, the
companies medicine enterprise wants to be keep on the win the
benefit to be decided by whether it can win and keep the
satisfaction of the equal customers or not.Through analysis, we use
the VISUAL BASIC development tool of the company of MICROSOFT,
making use of various development tool that faces to the object of
what it provide, particularly is this ability of the data window way
is convenient and simple and direct to manipulate the database of
intelligence turn the object, build up the system application
prototype in the in a short time first, then, start the prototype
system to carry on the need generation to the beginning, revise and
improve continuously, until formation the customer is satisfied and
can go the system.
Keywords: window body area database.
哈尔滨工业大学成人高等教育毕业设计(论文)
目 录
摘 要.............................................................................................................................I
ABSTRACT ...............................................................................................................II
第 1 章 绪论 ................................................................................................................1
1.1 课题背景...........................................................................................................1
第 2 章 用户需求分析 ................................................................................................2
2.1 功能需求...........................................................................................................2
2.2 实现目标...........................................................................................................2
第 3 章 相关技术介绍及系统数据库介绍 ................................................................3
3.1 前台开发工具语言...........................................................................................3
3.1.1 Visual Basic 语言的特点： .......................................................................3
3.2 数据库简介.......................................................................................................7
3.2.1 关系型数据库的实现 ...................................................................................7
3.3 二者的结合(DBA).............................................................................................8
3.3.1 使用 Microsoft Access 2000 创建数据库 ...............................................8
3.3.2 修改已建的数据库 ..................................................................................8
3.4 软件的运行环境设计.......................................................................................8
3.4.1 软件环境： ................................................................................................9
3.4.2 硬件环境： ................................................................................................9
第 4 章 系统模块设计 ..............................................................................................10
4.1 超市进销存管理系统结构图.........................................................................10
4.2 数据库需求分析.............................................................................................11
第 5 章 系统设计与数据库实现 ..............................................................................12
5.1 库的结构.........................................................................................................12
5.1.1 供应商基础信息表 gys............................................................................12
5.1.2 库存表 kc..................................................................................................13
5.1.3 密码表 ma ................................................................................................14
5.1.4 客户基础信息表 kh .................................................................................14
5.1.5 入库表 rkd ................................................................................................15
5.1.6 入库退单表 rktd.......................................................................................16
哈尔滨工业大学成人高等教育毕业设计(论文)
5.1.7 销售表 xsd................................................................................................17
5.1.8 销售退单表 xstd.......................................................................................18
5.2 系统主界面设计.............................................................................................19
5.3 日常业务设计.................................................................................................21
5.3.1 入库单模块设计 ......................................................................................21
5.3.2 销售单模块设计 ......................................................................................22
5.3.3 销售退单模块设计 ..................................................................................22
5.4 库存管理设计.................................................................................................23
5.4.1 库存查询模块设计 ..................................................................................23
5.4.2 库存盘点模块设计 ..................................................................................24
5.4.3 价格管理模块设计 ..................................................................................25
5.5 查询统计设计.................................................................................................25
5.5.1 入库查询模块设计 ..................................................................................25
5.5.2 销售查询模块设计 ..................................................................................26
5.5.3 销售退货查询模块设计 ..........................................................................27
5.6 基础信息管理设计.........................................................................................28
5.6.1 供应商管理模块设计 ..............................................................................28
5.6.2 客户管理模块设计 ..................................................................................28
5.7 系统设置设计.................................................................................................29
5.7.1 初期建帐模块设计 ..................................................................................29
5.7.2 密码设置模块设计 ..................................................................................29
结 论 ..........................................................................................................................31
致 谢 ..........................................................................................................................32
参考文献 ....................................................................................................................33
附录 1 .........................................................................................................................34
附录 2 .........................................................................................................................36
附录 3 .........................................................................................................................38
哈尔滨工业大学成人高等教育毕业设计(论文)
