摘要
作为制造业的ERP软件 ,物料需求计划 (MRP)模块是必不可少的。模块的基础数据之一的物料单层次码的计算 ,对于该类ERP软件的成功编制是一个很重要的环节。介绍了层次码算法 ,采用了递归的设计思想 ,充分利用现代关系数据库所提供的强大查询、计算功能 ,将其设计为一个存储过程。设计符合现代软件工程思想 ,即将用户界面、商务逻辑、数据相分离的原则 ,以便于维护、移植。由于存储过程是在服务器端运行 ,也使得算法具有较高的执行效率。
As a ERP software of manufacturing industry, generally speaking, Material Requirement Planning (MRP) module is necessary. So as a basic data module, the computing of BOM level code is an important part to make the ERP software successfully. Here, the algorithm adopts recursion ideology and makes full use of the powerful querying and computing functions of modern relation database system. The algorithm performs as a store procedure, so it meets modern software engineering, that is, separating the GUI, business logic and data in order to maintain and transplant. Since store procedure runs at server side, it also makes the algorithm has a high executing efficiency.
出处
《控制工程》
CSCD
2003年第1期53-55,共3页
Control Engineering of China
基金
国家自然科学基金资助项目 (70 1710 5 6)
