物资管理系统设计.doc
约35页DOC格式手机打开展开
物资管理系统设计,页数：35字数：9296摘要众所周知，物资的管理种类繁多，进出频繁，作为物资管理者，希望能对物资的整个流程状态、库存状况了如指掌，并为决策管理提供科学依据；作为工作人员则希望能够避免繁琐的手工操作，甩掉陈旧的手工记账方式，达到事半功倍的效果。物资管理应用软件不仅使以上的希望都变成了现实，而且能间接减少库...
内容介绍
此文档由会员 cnlula 发布
物资管理系统设计
页数：35 字数：9296
摘 要
众所周知，物资的管理种类繁多，进出频繁，作为物资管理者，希望能对物资的整个流程状态、库存状况了如指掌，并为决策管理提供科学依据；作为工作人员则希望能够避免繁琐的手工操作，甩掉陈旧的手工记账方式，达到事半功倍的效果。物资管理应用软件不仅使以上的希望都变成了现实，而且能间接减少库存的无谓积压，提高企业的经济效益。
所谓物资管理系统就是通过物资申请计划、采购、运输、仓储、保管、领用等活动，解决物资供需之间存在的时间、空间、数量、品种、规格以及价格和质量等方面的矛盾，衔接企业运作中的各个环节，确保日常事务处理的顺利进行。物资管理系统是企业管理中不可缺少的一环，物资已成为企业中很重要的一个管理对象，它对企业的经营活动有着直接影响，物资管理水平的高低直接影响着整个企业的成本。此外，物流和资金流直接相关，一方面，采购价格决定着采购成本的高低，另一方面，运输、仓储、装卸、库房管理直接影响着企业的运营成本。
目前，社会已进入到信息社会， 信息已成为企业的一个重要资源，向 信息和管理要效益也是大势所趋，这就要求在物资管理的思想和手段上有一些新的突破，而低水平的管理靠“感觉”和“经验”，高水平的管理靠“数据”，电脑是将“定性分析”提高到“定量分析”的最好工具，此外，计算机还具有运算速度快、精度高、存储出信息容量大、检索效率高的特性。因而，采用计算机技术实现物资管理电算化，是提高物资管理水平的很有效的途径。
关键词： 物资管理；数据库；Delphi；InterBase；SQL Explorer
Abstract
Know to all, and the supplies's management category is numerous, and pass in and out in each section multifarious, conduct and actions supplies governor, would like to to the supplies's whole process appearance, stock the condition is clearly, and manage to provide science for decision basis;The conduct and actions worker then hopeses and can avoid the operation of tedious handicraft, and fling off the old handicraft to record the method, and attain the half effort and double results's result.The supplies management not only made the above hope all becamed the actualitied, but also applies the software can the indirectly reduce the stock meaningless to put off, and increase the business enterprise's economic performance.
The system of so-called supplies management is to pass the supplies application the plan, purchase, conveyance, warehouse, take care of, get to use to wait the activity, the each link for antinomy for time, space, quantity, species, specification for exsitting and price with quantity waiting the aspect, docking the business enterprise operation the inside of of the supplies supply and demand of solution, insure the usual business to handle smoothly progress.Supplies management the system is a business enterprise management inside indispensability of a the wreath, supplies have become the business enterprise inside very important a management object, it to operating of business enterprise the activity have got the direct influence, supplies the management level of high and low directly affecting the cost of whole business enterprise.In addition, logistics is with the funds directly related, on the other hand, purchase the price decide the purchasing cost high and low, on the other hand, conveyance, warehouse, pack to unload, building management directly affect the business enterprise's the cost.
Now, the society have already entered the information society, information to have become the business enterprise's an important resources, and face the information with manage to want the performance is also best tool for management for management,this will begging there are some new breakthroughs on the supplies the thought that manage with the meaning, but lowly level depending" feeling the " with" the experience", highly level
depending" data", computer" qualitative analysis" increasing the " quantitative analysis", in addition, the calculator still have to calculate the speed quick, the
accuracy is high, theouts the information have great capacity, inspect the high characteristic of efficiency.Because of but, adoption the calculator technique realizes the supplies manage machine-readable,increase the supplies management level of very valid path.
Keywords: supplies management;DataBase; Delphi;InterBase;SQL Explorer
目 录
1 绪论 1
2 系统开发环境 2
2.1 硬件需求 2
2.2 软件需求 2
2.3 Delphi开发工具简介 2
2.3.1 用Delphi进行数据库应用程序的开发 3
2.3.2 InterBase 数据库管理 3
2.3.3 用Delphi的SQL Explorer连接和管理数据库 4
3 物资管理系统的整体分析 5
3.1 物资管理的应用现状 5
3.2 系统可行性分析 6
4 物资管理系统的实现 7
4.1 系统设计 7
4.1.1 系统功能分析 7
4.1.2 系统功能模块的设计 7
4.1.3 与其他系统的管理 8
4.1.4 系统的数据流程图 8
4.2 数据库设计 8
4.2.1 数据库需求分析 8
4.2.2 数据库概念结构设计 9
4.2.3 数据库逻辑结构设计 9
4.3 数据库结构的实现 11
4.3.1 创建商家信息表 11
4.3.2 创建零件产品信息表 11
4.3.3 创建出入库单信息表 11
4.3.4 创建出入库明细表 12
4.3.5 创建购销合同信息表 12
4.3.6 创建合同明细表 12
4.3.7 创建合同状态代码表 12
4.3.8 创建外部关键字和约束 13
4.3.9 数据库用户权限限制 13
4.4 各个功能模块的创建 14
4.4.1 帮助文件的创建和引用 14
4.4.2 登录窗体的创建 16
4.4.3 主窗体的创建 17
4.4.4 采购合同管理窗体的创建 19
4.4.5 销售合同管理窗体的创建 22
4.4.6 库存管理窗体的创建 23
4.4.7 系统维护管理窗体的创建 26
4．5 系统的实现 27
5 小结 28
参考文献 29
页数：35 字数：9296
摘 要
众所周知，物资的管理种类繁多，进出频繁，作为物资管理者，希望能对物资的整个流程状态、库存状况了如指掌，并为决策管理提供科学依据；作为工作人员则希望能够避免繁琐的手工操作，甩掉陈旧的手工记账方式，达到事半功倍的效果。物资管理应用软件不仅使以上的希望都变成了现实，而且能间接减少库存的无谓积压，提高企业的经济效益。
所谓物资管理系统就是通过物资申请计划、采购、运输、仓储、保管、领用等活动，解决物资供需之间存在的时间、空间、数量、品种、规格以及价格和质量等方面的矛盾，衔接企业运作中的各个环节，确保日常事务处理的顺利进行。物资管理系统是企业管理中不可缺少的一环，物资已成为企业中很重要的一个管理对象，它对企业的经营活动有着直接影响，物资管理水平的高低直接影响着整个企业的成本。此外，物流和资金流直接相关，一方面，采购价格决定着采购成本的高低，另一方面，运输、仓储、装卸、库房管理直接影响着企业的运营成本。
目前，社会已进入到信息社会， 信息已成为企业的一个重要资源，向 信息和管理要效益也是大势所趋，这就要求在物资管理的思想和手段上有一些新的突破，而低水平的管理靠“感觉”和“经验”，高水平的管理靠“数据”，电脑是将“定性分析”提高到“定量分析”的最好工具，此外，计算机还具有运算速度快、精度高、存储出信息容量大、检索效率高的特性。因而，采用计算机技术实现物资管理电算化，是提高物资管理水平的很有效的途径。
关键词： 物资管理；数据库；Delphi；InterBase；SQL Explorer
Abstract
Know to all, and the supplies's management category is numerous, and pass in and out in each section multifarious, conduct and actions supplies governor, would like to to the supplies's whole process appearance, stock the condition is clearly, and manage to provide science for decision basis;The conduct and actions worker then hopeses and can avoid the operation of tedious handicraft, and fling off the old handicraft to record the method, and attain the half effort and double results's result.The supplies management not only made the above hope all becamed the actualitied, but also applies the software can the indirectly reduce the stock meaningless to put off, and increase the business enterprise's economic performance.
The system of so-called supplies management is to pass the supplies application the plan, purchase, conveyance, warehouse, take care of, get to use to wait the activity, the each link for antinomy for time, space, quantity, species, specification for exsitting and price with quantity waiting the aspect, docking the business enterprise operation the inside of of the supplies supply and demand of solution, insure the usual business to handle smoothly progress.Supplies management the system is a business enterprise management inside indispensability of a the wreath, supplies have become the business enterprise inside very important a management object, it to operating of business enterprise the activity have got the direct influence, supplies the management level of high and low directly affecting the cost of whole business enterprise.In addition, logistics is with the funds directly related, on the other hand, purchase the price decide the purchasing cost high and low, on the other hand, conveyance, warehouse, pack to unload, building management directly affect the business enterprise's the cost.
Now, the society have already entered the information society, information to have become the business enterprise's an important resources, and face the information with manage to want the performance is also best tool for management for management,this will begging there are some new breakthroughs on the supplies the thought that manage with the meaning, but lowly level depending" feeling the " with" the experience", highly level
depending" data", computer" qualitative analysis" increasing the " quantitative analysis", in addition, the calculator still have to calculate the speed quick, the
accuracy is high, theouts the information have great capacity, inspect the high characteristic of efficiency.Because of but, adoption the calculator technique realizes the supplies manage machine-readable,increase the supplies management level of very valid path.
Keywords: supplies management;DataBase; Delphi;InterBase;SQL Explorer
目 录
1 绪论 1
2 系统开发环境 2
2.1 硬件需求 2
2.2 软件需求 2
2.3 Delphi开发工具简介 2
2.3.1 用Delphi进行数据库应用程序的开发 3
2.3.2 InterBase 数据库管理 3
2.3.3 用Delphi的SQL Explorer连接和管理数据库 4
3 物资管理系统的整体分析 5
3.1 物资管理的应用现状 5
3.2 系统可行性分析 6
4 物资管理系统的实现 7
4.1 系统设计 7
4.1.1 系统功能分析 7
4.1.2 系统功能模块的设计 7
4.1.3 与其他系统的管理 8
4.1.4 系统的数据流程图 8
4.2 数据库设计 8
4.2.1 数据库需求分析 8
4.2.2 数据库概念结构设计 9
4.2.3 数据库逻辑结构设计 9
4.3 数据库结构的实现 11
4.3.1 创建商家信息表 11
4.3.2 创建零件产品信息表 11
4.3.3 创建出入库单信息表 11
4.3.4 创建出入库明细表 12
4.3.5 创建购销合同信息表 12
4.3.6 创建合同明细表 12
4.3.7 创建合同状态代码表 12
4.3.8 创建外部关键字和约束 13
4.3.9 数据库用户权限限制 13
4.4 各个功能模块的创建 14
4.4.1 帮助文件的创建和引用 14
4.4.2 登录窗体的创建 16
4.4.3 主窗体的创建 17
4.4.4 采购合同管理窗体的创建 19
4.4.5 销售合同管理窗体的创建 22
4.4.6 库存管理窗体的创建 23
4.4.7 系统维护管理窗体的创建 26
4．5 系统的实现 27
5 小结 28
参考文献 29
