随着信息时代的来临,计算机离人们的生产生活越来越近,特别是在企业中,计算机已经在潜移默化中促使企业由机械化生产转向信息化时代。一方面,企业规模的扩大,过去那种采用人工来计划生产销售过程的模式已经不能跟上越来越大的信息量要求;另一方面,越来越廉价的计算机硬件设备在一定程度上也促使了企业的计算机普及,于是ERP(Enterprise Resource Planning(企业资源计划))系统也应用而生。
厂房、生产线、加工设备、检测设备、运输工具等都是企业的硬件资源,人力、管理、信誉、融资能力、组织结构、员工的劳动热情等就是企业的软件资源。企业运行发展中,这些资源相互作用,形成企业进行生产活动、完成客户订单、创造社会财富、实现企业价值的基础,反映企业在竞争发展中的地位。ERP系统的管理对象便是上述各种资源及生产要素,通过ERP的使用,使企业的生产过程能及时、高质地完成客户的订单,最大程度地发挥这些资源的作用,并根据客户订单及生产状况做出调整资源的决策。
伴随着计算机硬件的进步,计算机软件高级语言的发展也经历了从早期语言到结构化程序设计语言,从面向过程到非过程化程序语言的过程。相应地,软件的开发也由最初的个体手工作坊式的封闭式生产,发展为产业化、流水线式的工业化生产。80年代初出现的面向对象的程序设计,以c++、Delphi、java为代表为用户提供在模块化的执行方式,提出的对象(Object)的概念,其方法就是软件的集成化,如同硬件的集成电路一样,生产一些通用的、封装紧密的功能模块,称之为软件集成块,它与具体应用无关,但能相互组合,完成具体的应用功能,同时又能重复使用。对使用者来说,只关心它的接口(输入量、输出量)及能实现的功能,至于如何实现的,那是它内部的事,使用者完全不用关心。而同时数据库技术也经过由网状数据库、层次数据库向目前的以Oracle、SqlServer为代表的关系数据库的进化。
本文就以超市库存管理软件为研究对象,使用vc6为开发工具,SqlServer2000为数据源,探讨ERP软件中重要的进销存问题。
关键词:ADO,入库,出库
Along with information age oncoming, the computer is more and more near to people''s production life, specially in the enterprise, the computer already in influenced subtly urges the enterprise to change the informationization time by the mechanized production.At the same time, the enterprise scale expansion, in the past that kind used the artificial planned production sale process the pattern already not to be able to follow the more and more great information content request; On the other hand, the more and more inexpensive computer hardware equipment also has urged enterprise''s computer popularization to a certain extent, therefore ERP (Enterprise Resource Planning (enterprise resources plan))The system also applies lives.
The workshop, the production line, the processing equipment, the check-out facility, the transport means and so on all are enterprise''s hardware resources, the manpower, the management, the prestige, financing ability, the organizational structure, staff''s work enthusiasm and so on are enterprise''s software resources.In the enterprise movement development, these resources affect mutually, form the enterprise to carry on the production activity, to complete the customer order form, the creation public wealth, the realization enterprise value foundation, the reflection enterprise in the competition development status.The ERP system management object then is the above each resources and the element of production, through the ERP use, enables the enterprise the production process prompt, high-grade to complete the customer the order form, the greatest degree displays these resources the function, and makes the adjustment resources according to the customer order form and the production condition the decision-making.
Followed the computer hardware progress, the computer software higher order language development has also been experiencing from the early language to the structurization programming language, from faced the process to the non-proceduring program language process.The software development also by the initial individual manual workshop -like enclosed type production, develops correspondingly for the industrial production, the assembly line -like industrialization production.At the beginning of the 80''s appear the object-oriented programming, take c++, Delphi, java as representative provides for the user in the modular execution way, proposed the object (Object) concept, its method is the software integration, is similar to the hardware the integrated circuit to be same, produces some general, the seal close function module, called it the software integration block, it has nothing to do with with the concrete application, but can the inter-combination, complete the concrete application function, simultaneously can duplicate uses.To the user, only cared about its connection (input value, output) and can realize the function, how as for does realize, that is it internal matter, the user does not use the care completely.But simultaneously the data bank technology also passes through by the netted database, the level database to at present take Oracle, SqlServer as representative''s relational database evolution.
This article on take the supermarket stock management software as the object of study, uses vc6 is the development kit, SqlServer2000 is the data pool, discusses in the ERP software important to enter sells saves the question.
KEYWORD:
目 录
摘 要 2
ABSTRACT 3
1 绪 论 6
1、1 课题背景 6
1.1.1软件建立的背景 6
1.1.2现在人工模式存在的问题分析 7
1.1.3软件的开发方式和目标 7
1.2相关技术介绍 8
1.2.1结构化生命周期法简介 8
1.2.2开发技术——快速原型法简介 9
1.2.3本系统开发方法的选择 9
2 系统分析 10
2.1可行性研究 10
2.1.1经济可行性 10
2.1.2技术可行性 10
2.1.3操作可行性 11
2.2、系统的详细调查 11
2.2.1系统详细设计原理 11
3系统需求分析 13
3.1 任务概述 13
3.2 系统需求 13
3.2.1 MFC简述 13
3.2.2 VC++.net2003 环境介绍 13
3.2.3 ADO技术简介 14
4 系统设计 15
4.1 概要设计 15
4.2数据库结构设计 15
4.3详细设计 19
5 结论 31
5.1软件测试 31
5.2总结 31
致 谢 32
参考文献 32
根据需求不同大体上可分为如下几个方面:
(1) 客户管理功能:客户分为供应商和购货商两种类型,在产品入库时,需要提供供应商的信息:在产品出库退货时,需要提供购货商的信息。客户管理功能具体包括添加,删除和查看客户信息等功能。
(2) 仓库管理功能:仓库信息包括仓库编号,仓库名称和仓库说明等信息。仓库管理功能具体包括添加,删除和查看仓库信息等功能。
(3) 用户管理功能:用户信息包括用户名,密码,员工姓名等信息。用户管理功能具体包括添加,删除和查看用户信息等功能。
(4) 产品管理功能:对产品的信息管理功能包括:1 添加,删除,修改,查看产品类别; 2添加,删除,修改查看产品信息。
(5) 操作管理功能:操作的对象是库存,由仓库管理员执行,就是把产品放入仓库或把产品从仓库中取出的操作,即入库和出库。
1、入库分为采购入库,生产入库,退货入库,退料入库等情况。入库操作需要记录相关的产品信息,仓库信息,客户信息,经办人,涉及金额和入库时间等信息。
2、 出库可以分为销售出库,退货出库,用料出库等情况。出库操作需要记录相关的产品信息,仓库信息,客户信息,经办人,涉及金额和出库时间等信息。
(6) 统计查询管理功能:该功能可以对库存产品进行各种类型的统计和查询,从而使用户能够全面的了解库存状况。
(7) 数量管理功能:该功能是指对库存中的产品进行数量的管理。如果产品数量小于合理数量的下限则称为断线;产品数量大于合理数量的上限成为超储。产品出现这这些情况都需要给出提醒。