1、小型出入库系统的设计与实现Design and Implementation of the Small Loading and Unloading System摘 要随着信息技术的发展，传统的统计方式在处理庞大的信息量时显得极不适应，因此，人们对于运用计算机来辅助协调和管理自身工作的需求正在逐步提高。近来，国内外兴起了一股办公自动化的热潮，希望能借助相关的计算机技术实现对企业办公过程的自动化管理。目前，办公自动化正朝着多功能，复合化和系统化的方向发展，如何有效的实现作业流程的自动化已经提到日程上来。这样对信息流的有效组织和管理便日益成为衡量一个办公自动化系统优劣的重要标志。好用库管小型出入库系
2、统就是一个由人、计算机硬件、软件和数据资源组成的，目的在于及时、正确、准确地收集、加工、存储、传送和提供决策信息的微型管理信息系统。该系统主要是为了减轻工作量、降低工作误差、提高工作效率而开发、编制的。希望通过使用本系统，为小型仓库管理带来便捷！开发后的库存管理系统，是基于原有的管理模式上弥补人工操作繁琐、查询效果不理想、效率较低的问题。经过编译和调试，本系统能基本解决上述问题。主要用到了一些出入库时的操作信息，还有原料的一些基本信息。简单易懂的操作方式、友好的用户界面以及清晰简洁的数据处理流程，使得本系统能够很快被接受和掌握，较快地取代原有的全人工操作方式。在数据输入上，本系统主要有出入库数
3、据输入和原料基本资料输入两方面。出入库数据的输入主要有出入库原料的资料、出入库原料的数量等；原料的基本资料主要有编号、名称、价格等。当进行数据查询时，采用相关字段排序法。当有原料登记出库或者入库时，在库存总数据库里的相应数据会及时更新，所以，从本系统获得的数据资料都是最新的。这对于库存的管理、数据的查询来说，是非常有利的。好用库管小型出入库系统在对原有管理模式不进行很大改变的基础上将大大提高工作效率，弥补了现有人工系统的缺陷，其可行性是显而易见的。关键词：出入库系统；库存管理；数据输入；数据查询；管理信息系统- I -Design and Implementation of the Small
4、 Loading and Unloading SystemAbstractAlong 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 peopl
5、e work in demand. Recently, it is very popular to use office automation system software at home and aboard, and with the computers 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 mu
6、lti-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 syst
7、em is good or not. Haoyong Inventory Management Systema 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,
8、 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 effec
9、tive 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 interf
10、ace 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 mat
11、erial 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 or
12、der 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 I
13、nventory Management Systema small data input/output inventory system has been improved with only a few changes to original system at the workers efficiency, and the existing manual system deficiencies, it is obvious to see its feasibility of this system.Key Words：Loading and Unloading System；Invento
14、ry Management; Data Input；Data Inquiry；Information Management System- V -目 录摘 要IAbstractII引 言11系统和开发工具介绍21.1系统介绍21.1.1系统名称21.1.2模拟说明21.1.3系统功能21.1.4系统运行条件21.2开发工具介绍31.2.1 Microsoft Visual Basic 6.031.2.2 SQL Server 200032 系统分析42.1现有状况分析42.1.1 现有业务流程分析42.1.2存在的问题52.2系统可行性分析53 系统设计73.1总体设计73.1.1系统设计目标
15、73.1.2系统基本功能73.1.3数据库规划73.1.4系统数据流程图93.2程序模块设计及说明113.2.1用户登录模块113.2.2主窗体模块133.2.3操作员维护模块143.2.4原料基本信息维护模块163.2.5入库模块183.2.6出库模块203.2.7查询模块213.2.8盘点模块263.2.9备份恢复模块284 系统测试324.1总体测试324.1.1测试用的数据和条件324.1.2非法数据测试324.2白盒测试334.3黑盒测试355 系统的技术特点375.1使用ADO控件来访问数据库375.2使用ADO对象模型来访问数据库37结 论40参 考 文 献43附录A原代码清单44附录B英译汉63攻读硕士学位期间发表学术论文情况70致 谢71大连理工大学学位论文版权使用授权书72引 言今天，人类已经步入21世纪！这是一个变化难测的世纪，一个催人奋进的时代。科学技术飞速发展，知识更替日新月异。回眸走过的20世纪，20世纪可以说是人类历史上的又一个转折点，第一台计算机的诞生直到今天在各行各业中的应用，计算机的出现使得人们的生活、工作发生了质的变化！随着信息技术的发展，传统的统计方式在处理庞大的信息量时显得极不适应，因此，人们对于运用计算机来辅助协调和管理自身工作的需求正在逐步