-I-
摘要
随着加入 WTO，市场竞争越来越激烈，对制造企业来说，为了能够
在竞争中立于不败，降低成本是不得不面临的问题，而确保生产车间
较高的生产能力和效率，是当务之急。此外，有效的调度方法已经成
为先进制造技术实践的基础和关键，所以对车间生产调度的研究具有
重要的理论和实用价值。
车间生产调度管理系统的设计与实现是采用 Visual Basic 6.0 开
发的一个数据库管理系统。本文主要讲述了 Visual Basic 6.0 的基本
功能及设计方法。紧接着以本系统为例，逐一介绍开发本系统的步骤：
系统分析、系统设计、系统实现、系统维护。在系统分析中先后用数
据流图、数据字典、系统的功能结构图分析了系统所需的各种数据。
在系统的设计中，详细的展现了系统的各个功能模块。所需的数据库
表及表字段。菜单的设计等。在系统的实现中，给出了实现窗体中相
应的功能控件的事件及代码。以及菜单实现的方法。文章的最后则给
出了本系统的主要功能源代码。
本系统具有信息查询、添加、修改、删除，数据存储，作业调度，
票据的制表和打印等功能。系统的界面简单易懂，系统功能全面，用
户操作方便是本设计的特点。
关键词：数据库，管理，调度，信息查询
-II-
Abstract
Along with join the WTO, the market competition is more and
more vigorous, to the manufacturing business enterprise, for the
sake of can at compete the neutral in not losing , decline low
cost is the problem that have to face, but insure to produce the
car higher production ability and efficiency, is an urgent matter
of the moment. In addition, adjust effectively one degree method
have already become the forerunner the manufacturing technique
practice of foundation and key, so have the important theories
and practical values to a research that adjusts the degree.
The car adjusts one degree management system is a database
management system that adopts 6.0 developments of the Visual
Basic. This text mainly related the Visual Basic 6.0 of basic
function and the design method. The morrow is to take this system
as an example, introducing the development one by one originally
the step of the system: System analysis, the system design,
system realization, system maintenance. In system analyze
successively with the function structure diagram that the data
flows the diagram, data dictionary, system analyzed the system
need of various data. In the design of the system, emerged each
function mold piece of the system detailed . The database form
and watch word segments need. Design etc. of the menu .In the
realization of the system, give carry out the window body to
-III-
control the affairs and the code of the piece in the homologous
function. And the method of the menu realization. The end of
the article then gives the main function source code of this
system.
This system has the information search and increase, modify,
deletes, the data is saving, the homework adjusts the degree,
the note system form and print etc. function. The interface of
the system understands in brief and easily, the system function
is overall, the customer operation the convenience is the
characteristics of this design.
Keywords: Database, Manage, Dispatch, The information search
-IV-
目录
摘要 .......................................................I
ABSTRACT ..................................................II
第 1 章 绪论 ...............................................1
1.1 项目开发背景 ..........................................1
1.2 项目开发目的 ..........................................1
1.3 项目开发的目标 ........................................2
1.4 项目提出的意义 ........................................3
1.5 系统的开发方法 ........................................3
第 2 章 可行性研究 ..........................................4
2.1 研究车间生产调度管理系统 ..............................4
2.2 完成新系统的可行性 ....................................6
第 3 章 系统分析 ...........................................7
3.1 系统的设计思想 ........................................7
3.2 需求分析 ..............................................7
3.2.1 功能需求 ..........................................7
3.3 系统的运行环境和开发平台 ..............................8
3.3.1 开发工具简介 ......................................8
3.3.2 开发环境简介 .....................................10
3.3.3 硬件设备及操作系统 ...............................10
3.3.4 系统开发平台 .....................................11
3.4 数据分析 .............................................11
3.5 数据流图 .............................................11
3.6 数据字典 .............................................12
第 4 章 系统设计 ..........................................14
4.1 系统设计的总体方案 ...................................14
4.2 功能模块设计 .........................................14
4.3 数据库设计 ...........................................15
4.3.1 数据库概念结构设计 ...............................15
4.3.2 数据库的逻辑结构设计 .............................15
第 5 章 车间生产调度管理系统功能实现 ......................30
-V-
5.1 用户登录界面设计 .....................................30
5.2 系统界面的设计 .......................................30
5.3 作业计划窗体的设计 ...................................31
5.4 作业拆解窗体的设计 ...................................32
5.5 任务排序及分配的设计 .................................33
5.6 系统主菜单的设计 .....................................35
第 6 章 系统的编译与维护 ..................................37
6.1 系统的编译发行 .......................................37
6.2 系统的维护 ...........................................37
6.2.1 系统维护的内容 ...................................37
6.2.2 系统维护的类型 ...................................38
6.2.3 系统维护的组织与管理 .............................38
第 7 章 结论 ...............................................39
致谢 ......................................................40
参考文献 ..................................................41
英文资料 ..................................................42
英文翻译 ..................................................47
