小型出入库系统的设计与实现 电气自动化专业.doc

小型出入库系统的设计与实现 Design and Implementation of the Small Loading and Unloading System 摘 要 随着信息技术的发展，传统的统计方式在处理庞大的信息量时显得极不适应，因此，人们对于运用计算机来辅助协调和管理自身工作的需求正在逐步提高。近来，国内外兴起了一股办公自动化的热潮，希望能借助相关的计算机技术实现对企业办公过程的自动化管理。目前，办公自动化正朝着多功能，复合化和系统化的方向发展，如何有效的实现作业流程的自动化已经提到日程上来。这样对信息流的有效组织和管理便日益成为衡量一个办公自动化系统优劣的重要标志。 《好用库管》小型出入库系统就是一个由人、计算机硬件、软件和数据资源组成的，目的在于及时、正确、准确地收集、加工、存储、传送和提供决策信息的微型管理信息系统。该系统主要是为了减轻工作量、降低工作误差、提高工作效率而开发、编制的。希望通过使用本系统，为小型仓库管理带来便捷！ 开发后的库存管理系统，是基于原有的管理模式上弥补人工操作繁琐、查询效果不理想、效率较低的问题。经过编译和调试，本系统能基本解决上述问题。主要用到了一些出入库时的操作信息，还有原料的一些基本信息。简单易懂的操作方式、友好的用户界面以及清晰简洁的数据处理流程，使得本系统能够很快被接受和掌握，较快地取代原有的全人工操作方式。 在数据输入上，本系统主要有出入库数据输入和原料基本资料输入两方面。出入库数据的输入主要有出入库原料的资料、出入库原料的数量等；原料的基本资料主要有编号、名称、价格等。当进行数据查询时，采用相关字段排序法。当有原料登记出库或者入库时，在库存总数据库里的相应数据会及时更新，所以，从本系统获得的数据资料都是最新的。这对于库存的管理、数据的查询来说，是非常有利的。 《好用库管》小型出入库系统在对原有管理模式不进行很大改变的基础上将大大提高工作效率，弥补了现有人工系统的缺陷，其可行性是显而易见的。 关键词：出入库系统；库存管理；数据输入；数据查询；管理信息系统 - I - Design and Implementation of the Small Loading and Unloading System Abstract Along with the rapid development of computer vision technology, the traditional statistics methods can not meet the need of large amount of information processing day by day, so more and more people are interested in computer technology to assist and manage people’ work in demand. Recently, it is very popular to use office automation system software at home and aboard, and with the computer’s helps, people hope it can put the enterprise office automation system management into realization. At present, the office automation system has been moving forward to multi-function, complicated operations and systematic directions, how to achieve effective automatically operational procedures more effective has been put into agenda. The effective information flow organization and management has gradually been an important signs to measure an office automation system is good or not. 《Haoyong Inventory Management System》a small data input/output inventory system consists of people, computer hardware, software and data resources, it is a micro-information management system with the objective of decision information collecting、processing、storing、delivering timely, correctly and accurately. This system is developed to reduce the workload and errors, makes the work more effective, and hope it can bring convenience to your job! This inventory management system is developed without original management model problems of too complicated manual operation, not effective inquiries results, and after compiling and debugging of the program, this system can solve above 2 problems. Some information such as inventory operation information and raw material information has been developed for this system. Simple and easily used operation interface, friendly user interface and simple data processing programs, have made the user quickly to familiar and master with this system, and forget the existing artificial manner of operation. When doing the data input, this system is mainly including two functions such as inventory database information inputs and basic raw material information inputs. Database information input mainly includes raw material information, raw material quantities and etc; the basic information of the raw material includes serial number, description, pricing, materials and etc. When doing the data inquiries, the related data will be put in order by related field method. And the related information in the database of this inventory system will be updated once there are new inputs/outputs, this will make sure the data collected from this system up to date and it would be much beneficial to inventory management and data inquiries. 《Haoyong Inventory Management System》a small data input/output inventory system has been improved with only a few changes to original system at the worker’s efficiency, and the existing manual system deficiencies, it is obvious to see its feasibility of this system. Key Words：Loading and Unloading System；Inventory Management; Data Input；Data Inquiry；Information Management System - V - 目 录 摘 要 I Abstract II 引 言 1 1系统和开发工具介绍 2 1.1系统介绍 2 1.1.1系统名称 2 1.1.2模拟说明 2 1.1.3系统功能 2 1.1.4系统运行条件 2 1.2开发工具介绍 3 1.2.1 Microsoft Visual Basic 6.0 3 1.2.2 SQL Server 2000 3 2 系统分析 4 2.1现有状况分析 4 2.1.1 现有业务流程分析 4 2.1.2存在的问题 5 2.2系统可行性分析 5 3 系统设计 7 3.1总体设计 7 3.1.1系统设计目标 7 3.1.2系统基本功能 7 3.1.3数据库规划 7 3.1.4系统数据流程图 9 3.2程序模块设计及说明 11 3.2.1用户登录模块 11 3.2.2主窗体模块 13 3.2.3操作员维护模块 14 3.2.4原料基本信息维护模块 16 3.2.5入库模块 18 3.2.6出库模块 20 3.2.7查询模块 21 3.2.8盘点模块 26 3.2.9备份恢复模块 28 4 系统测试 32 4.1总体测试 32 4.1.1测试用的数据和条件 32 4.1.2非法数据测试 32 4.2白盒测试 33 4.3黑盒测试 35 5 系统的技术特点 37 5.1使用ADO控件来访问数据库 37 5.2使用ADO对象模型来访问数据库 37 结 论 40 参 考 文 献 43 附录A原代码清单 44 附录B英译汉 63 攻读硕士学位期间发表学术论文情况 70 致 谢 71 大连理工大学学位论文版权使用授权书 72 引 言 今天，人类已经步入21世纪！这是一个变化难测的世纪，一个催人奋进的时代。科学技术飞速发展，知识更替日新月异。 回眸走过的20世纪，20世纪可以说是人类历史上的又一个转折点，第一台计算机的诞生直到今天在各行各业中的应用，计算机的出现使得人们的生活、工作发生了质的变化！ 随着信息技术的发展，传统的统计方式在处理庞大的信息量时显得极不适应，因此，人们对于运用计算机来辅助协调和管理自身工作的需求正在逐步