某公司库存管理系统的设计与实现

论文字数:19705,页数:54  有开题报告，任务书
摘要

    随着现代工业的发展，企业信息管理系统越来越受到企业重视。为了适应新形势下企业库存管理的需要,降低成本,提高经济效益,非常有必要制定合理的库存策略、从而有效的控制和降低企业高量库存,减少和消除库存报废的风险。当今企业竞争范围的扩大，要求在企业的各个方面加强管理，并要求企业有更高的信息化集成，要求对企业的整体资源进行集成管理，而不仅仅对制造资源进行集成管理。本文根据库存管理系统的现状及未来的发展方向结合有关的实践信息设计了企业库存管理系统。
本文设计、实现了某公司库存管理系统，从而克服了原来的手工输入效率低、容易出错的缺点，对企业的发展有一定的帮助。本文介绍了C++ builder编程环境和Access数据库管理系统的功能特点、表单的制作过程、程序的编写和编译过程，给出了系统的需求分析、设计与实现，从入出库、查询、打印、设置等多方面对系统做了设计与分析。经测试，系统运行稳定，能基本满足公司对系统在功能和性能上的需求。
 
关键词：库存，库存管理，数据库

The design and implementation of some company’s warehouse management system

Abstract
Following the development of the modern industry, the Enterprise Resource Management (ERP) system has been thought much by enterprises. In order to accommodate the warehouse management system requirements under new environment, increasing the economic benefit, it is necessary to establish a reasonable warehouse control policy. This can easily control and reduce the tremendous warehouse overstock, limited the risk of store-reject. The increasing competition among companies required the corporation itself enhance its own management, and need more information integration. The companies not only need to make well management for their manufacture but for there whole resource. This paper designed a new enterprise warehouse management system depends on its actuality and future works.
This paper designed and realized a company’s warehouse management system. This WMS overcome the demerit, such as low efficiency or tendency to mistakes, when using the manual way, can provide a certain assist to the company. This paper has introduced C++ Builder tool and Access database management system, give out there functional character, table setup procedure, program encoding and also the project compile process. Pointed out the requirements analysis, system design and realization. Analyses based on in/out warehouse, query, print, configuration, etc. also been complemented. After a well quality assessing, the warehouse management system which the paper provided can run smoothly and fulfill the requirements on both function and performance

Keywords: warehouse, the storehouse management system, database

目  录
1 绪论 1
1.1 课题背景及研究意义 1
1.2 课题研究现状及存在问题 1
1.3 国内外同类管理软件的研究现状与发展趋势 3
1.4 本人主要工作 5
1.5 课题研究方法 5
1.6 论文结构及研究内容 5
2 库存管理系统的开发环境 7
2.1 硬件环境 7
2.2 软件环境 7
2.2.1 操作系统 7
2.2.2 开发语言 7
2.2.3 数据库 7
3 系统需求与功能说明 9
3.1 系统需求 9
3.2 功能说明 9
3.2.1 系统初始 9
3.2.2 机器管理 9
3.2.3 基本信息管理 14
3.2.4 帐户管理 18
3.2.5 退出 20
4 系统的设计与实现 21
4.1 概要设计 21
4.2 数据库设计 21
4.2.1 数据库介绍 21
4.2.2 数据库的特点 22
4.2.3 数据库技术 23
4.2.4 管理员信息表 24
4.2.5 仓库信息表 24
4.2.6 提货单信息表 25
4.2.7 商品入库信息表 25
4.2.8 货品信息记录表 26
4.2.9 供货商信息表 27
4.2.10 提货信息表 28
4.2.11 员工信息记录表 29
4.2.12 系统信息表 29
4.3 数据精度 29
4.4 机器管理模块的详细设计与实现 30
4.4.1 入库单管理信息模块 30
4.4.2 出库单管理信息模块 34
4.4.3 提货单管理模块 35
4.4.4 整机信息管理模块 38
5 测试 41
5.1 测试方法 41
5.2 测试环境 41
5.3 测试计划 41
5.4 测试用例 41
5.5 测试结果 44
5.6 测试结论 44
6 总结与展望 45
6.1 总结 45
6.2 展望 45
致谢  47
参考文献 48