企业库存管理系统

简介：摘要时间行进到21世纪，以计算机技术为主体的高新技术群体已经深入到我国经济的方方面面。在市场经济的大环境下，越来越多的人士逐渐认识到用计算机技术进行各类管理、交流的便捷。自行车制造库存管理系统是典型的信息管理系统,其开发主要包括后台数...

请与管理员联系购买资料 QQ:5739126

摘要

时间行进到21世纪，以计算机技术为主体的高新技术群体已经深入到我国经济的方方面面。在市场经济的大环境下，越来越多的人士逐渐认识到用计算机技术进行各类管理、交流的便捷。

自行车制造库存管理系统是典型的信息管理系统,其开发主要包括后台数据库的建立以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。

首先学习了具体的开发工具VB6.0，对其数据库组件，SQL语言在VB中的应用等。分析了库存管理系统的应用需求，给出了系统需求说明书、局部ER图、全局ER图、系统关系模式，子模式，利用SQL Server2000建立了数据库进行具体的程序设计，实现了记录的添加、删除和修改，报表的生成，实现了多条件查询，实现了主从表操作，实现了密码维护功能。

设计时充分利用VB6.0、SQL Server2000数据库技术的强大力量，提高了编程效率和可靠性。

关键词：库存管理系统，数据库组件，需求说明书。

ENTERPRISE RESOURCE PROJECT SYSTEM OF SPORTSMAN CO. LIMITED

STOCKING MANAGEMENT SYSTEM

Abstract

It advances to 21st century, taking technology of the computer as subject Hi-Tech technology colony has already gone deep into every aspect in our country. Under great environment of market economy, more and more personage is that it carries on name kinds of management with computer technology to realize gradually, the ones that exchanged are convenient.

It is a typical information management system that the bicycle makes the administrative system of stock, and it develops two respects of main development including setting-up of backstage supporter's database and front application program. Demand to set up the consistency of the data and integrality the storehouse of strong, data with good security to the former. Require to the latter the function of the application program is completed, apt characteristic of using etc…

Study concrete developing instrument VB6.0 at first, to its database package, application in VB of SQL language, etc… Analyze the application demand for the administrative system of the stock, provide systematic demand manual, some ER picture, overall ER picture, system and concern the mode, sub mode, utilize SQL Server2000 to set up the database and carry on concrete design program, realize addition, deletion and revising that is written down, formulation of report form, realize a lot of condition inquire, realize principal and subordinate form operate, and realize the maintenance function of the password.

Fully utilize strong strength of VB6.0, SQL Server2000 database technology at the time of the design, has improved programming efficiency and dependability.

Keywords: The management system of the stock, Package of the database, and Require with the manual.