进销存管理系统
初步分析了当前业务公司管理方面存在的问题,联系实际情况设计实现了一个以控制物流为主的管理软件。该系统实现了部分ERP的功能,尽力做到降低实施成本,减少实施风险 ,加快实施进度 ,增加投资回报。
企业的物资供应管理往往是很复杂,繁琐的,由于掌握的物资种类众多,订货,管理,发放的渠道各有差异,各个企业之间的管理体制不尽相同,各类统计计划报表繁多,因此物资管理必须实现计算机化,而且必须根据企业的具体情况制定便提高工作效率。
根据当前的企业管理体制,一般物资供应管理系统,总是根据所掌握的物资类别,相应分成几个科室进行物资的计划,订货,核对入库,根据企业各个部门的需要来发送物资设备,并随时近期进行库存盘点,作台帐,根据企业领导和自身管理的需要按月,季,年进行统计分析,产生相应报表,为了加强关键物资,设备的管理,要定期掌握其储备消耗情况,根据计划定额和实际消耗定额的比较,进行定额管理。所以一个完整的企业物资供应管理系统应包括计划管理,合同托收管理,仓库管理,定额管理,统计管理,财务管理等到模块。其中仓库管理是整个物资供应管理系统的核心。
使用Microsoft Visual Basic 6.0及Microsoft Office Access 2003作为开发工具,利用面向对象的结构和自上而下的程序设计方法,基本实现了仓库的日常管理和进货出货的查询。
关键字:企业资源计划,存货,数据库,面向对象
Abstract
The first step analyzes the current business company to manage the problem of the aspect existence, contact actual circumstance the design carried out a take controling the logistics as lord of management software.That system carried out the function of parts of ERPs, making an effort to attain to lower the implement cost, reducing to carry out the risk, speeding implement degree of progress, increasing the investment repay.
The supplies supply management of the business enterprise is usually very complex, tedious, because the supplies category that control is numerous, order, manage, the outlet that issue is each to have the difference, the management system between each business enterprise does not fulfil same alike, each kind of covariance plan statement is numerous.
According to the current business enterprise management system, the general supplies supply management system, always according to the supplies category control, correspond to be divided into the plan that a few section rooms carry on the supplies, order, check to store in warehouse, according to the demand of the business enterprise each section to send out the supplies equipments, and at any time in the near future carry on the stock stocktaking, make the pedestal debt, according to the business enterprise leads to manage with oneself of demand is by the month, quarter, the year carry on statisticsing the analysis, the creation correspond the statement, for strengthenning the key supplies, the management of the equipments, want to periodically control it store the depletion circumstance, settling the sum according to the plan and consuming to settle the sum physically of comparison, carry on settling the sum to manage.So an integrity of the business enterprise supplies supply management the system should include the plan management, the contract collection management, warehouse management, settle sum management, statistics the management, finance management wait until the mold piece.Among them, the warehouse management is the core of the whole supplies supply management system.
Use the Microsoft Visual Basic 6.0 and the Microsoft Office Access 2003 conduct and actionses development tool, make use of the structure of face to the object and from top to bottom of program design method, basic carried out the usual management of the warehouse and enter the search of the goods shipment.
Keywords: ERP, Stock, Database, Face to the object
目 录
摘 要... I
Abstract II
1 续言... 1
2 系统分析
2.1 问题的提出... 4
2.2 分析问题... 4
2.3 系统设计目标... 5
2.3.1 系统设计的长远目标:实现ERP系统... 5
2.3.2 系统设计近期... 6
3 系统总体设计
3.1 数据流图... 7
3.2 部分数据字典... 11
3.3 E-R图... 12
3.4 功能模块... 14
3.4.1 程序层次... 14
3.4.2 模块功能说明... 15
3.4.3 系统数据表... 15
4 系统详细设计... 17
5 编码实现与测试
5.1 编码摘要... 21
5.2 程序界面... 28
6 总结与展望
6.1 总结... 34
6.2 心得体会... 35
致 谢... 37
参考文献... 38
1 续言
根据指导老师、公司和客户的要求,本次毕业设计的题目是进销存管理系统,要求利用Visual Basic完成管理平台设计,构造所用的类库;使用Access数据库存储数据,限单机使用。
企业的物资供应管理往往是很复杂,繁琐的,由于掌握的物资种类众多,订货,管理,发放的渠道各有差异,各个企业之间的管理体制不尽相同,各类统计计划报表繁多,因此物资管理必须实现计算机化,而且必须根据企业的具体情况制定便提高工作效率,
根据当前的企业管理体制,一般物资供应管理系统,总是根据所掌握的物资类别,相应分成几个科室进行物资的计划,订货,核对入库,根据企业各个部门的需要来发送物资设备,并随时近期进行库存盘点,作台帐,根据企业领导和自身管理的需要按月,季,年进行统计分析,产生相应报表,为了加强关键物资,设备的管理,要定期掌握其储备消耗情况,根据计划定额和实际消耗定额的比较,进行定额管理。