铸造ERP智能化物料需求计划的研究与开发
|
摘要
企业资源计划的出现,给传统铸造业的企业管理带来了新的生机。铸造企业管理信息系统是计算机技术在铸造行业应用的一个重要方面。随着市场竞争的日益激烈和技术的进步,铸造企业管理技术也在不断地发展,传统的ERP软件将其主要精力集中于各模块的设计,当各个模块都越来越趋向于成熟,将各个模块中数据的集成和分析无疑是一个必然的趋势。而把各模块集成的前提,就是要拥有一个准确的物料需求计划系统。正是基于这个原因,本课题研究开发了智能化铸造ERP的物料需求计划系统。
本文首先阐述了企业信息化和ERP的概念,分析了国内外铸造企业ERP的研究现状,指出了传统ERP的一些不足之处,并在此基础上提出了为系统开发智能化物料需求计划的解决方案。
通过对企业的调研,详细研究了中小型铸造企业的生产特点和业务流程,制作了详细的业务流程图和数据流程图。对和物料需求计划相关的经营管理,生产管理,仓库管理和财务管理等几项业务进行详细的分析。在此基础上设计了物料需求计划的逻辑流程。
文中重点介绍了物料需求计划系统的设计和实现。结合实际情况,选取PowerBuilder11.5和MS SQL server2000为开发平台,结合铸造企业的实际业务流程和生产情况对整个系统进行设计实现,包括物料清单的设计实现,数据库的设计实现,功能模块的设计实现,系统的算法设计实现和系统的界面设计实现。
最后,本文以智能化华铸ERP在宣城新瑞公司的实施应用为例,介绍了物料需求计划系统在企业中的实际使用情况。
The emergence of Enterprise Resources Planning (ERP) brings a totally new life for the management of the traditional casting companies. Foundry management information system is one of the most important applications of computer in foundry field. With the fierce competition in market and development of technology, the management technology for casting companies is developing all the way. The traditional ERP software has mainly focused on the design of the module, but when each module became more and more mature. It is an inevitable trend to analyze the integrated data of each module. However, before the integration, an accurate MRP system is needed. And just for this reason, this research studied and developed a MRP system for the smart casting ERP.
In this paper, the concept of management and ERP was described firstly. Meanwhile the actualities of the ERP research in foundry at home and abroad are analyzed. The traditional ERP gaps had been pointed out. According to the present situation, this paper carried out the MRP system development solutions.
Through the research of enterprises, the paper made a detailed demonstration about the business processes of small casting enterprises. Combining with the business flow diagrams and data flow diagrams, this paper gives a detailed analyze on the production management, warehouse management, financial management, and other businesses relating with the MRP system. Then we made an analysis of the logic flow of material requirements planning process.
In this paper, the design and implementation of the MRP system is detailed introduced. According to the present situation, the research chooses PowerBuilder11.5 and MS SQLserver2000 as the developing tools. By relating to the real business flow and production conditions, the whole system is designed and realized, including the design of BOM, enterprise database, function modules, and implementation of the system algorithm and interface.
At last, with the application of this smart casting ERP in the Xuancheng Xinrui company, the actual usage situation of the MRP system is introduced.
本文首先阐述了企业信息化和ERP的概念,分析了国内外铸造企业ERP的研究现状,指出了传统ERP的一些不足之处,并在此基础上提出了为系统开发智能化物料需求计划的解决方案。
通过对企业的调研,详细研究了中小型铸造企业的生产特点和业务流程,制作了详细的业务流程图和数据流程图。对和物料需求计划相关的经营管理,生产管理,仓库管理和财务管理等几项业务进行详细的分析。在此基础上设计了物料需求计划的逻辑流程。
文中重点介绍了物料需求计划系统的设计和实现。结合实际情况,选取PowerBuilder11.5和MS SQL server2000为开发平台,结合铸造企业的实际业务流程和生产情况对整个系统进行设计实现,包括物料清单的设计实现,数据库的设计实现,功能模块的设计实现,系统的算法设计实现和系统的界面设计实现。
最后,本文以智能化华铸ERP在宣城新瑞公司的实施应用为例,介绍了物料需求计划系统在企业中的实际使用情况。
The emergence of Enterprise Resources Planning (ERP) brings a totally new life for the management of the traditional casting companies. Foundry management information system is one of the most important applications of computer in foundry field. With the fierce competition in market and development of technology, the management technology for casting companies is developing all the way. The traditional ERP software has mainly focused on the design of the module, but when each module became more and more mature. It is an inevitable trend to analyze the integrated data of each module. However, before the integration, an accurate MRP system is needed. And just for this reason, this research studied and developed a MRP system for the smart casting ERP.
In this paper, the concept of management and ERP was described firstly. Meanwhile the actualities of the ERP research in foundry at home and abroad are analyzed. The traditional ERP gaps had been pointed out. According to the present situation, this paper carried out the MRP system development solutions.
Through the research of enterprises, the paper made a detailed demonstration about the business processes of small casting enterprises. Combining with the business flow diagrams and data flow diagrams, this paper gives a detailed analyze on the production management, warehouse management, financial management, and other businesses relating with the MRP system. Then we made an analysis of the logic flow of material requirements planning process.
In this paper, the design and implementation of the MRP system is detailed introduced. According to the present situation, the research chooses PowerBuilder11.5 and MS SQLserver2000 as the developing tools. By relating to the real business flow and production conditions, the whole system is designed and realized, including the design of BOM, enterprise database, function modules, and implementation of the system algorithm and interface.
At last, with the application of this smart casting ERP in the Xuancheng Xinrui company, the actual usage situation of the MRP system is introduced.
引文
[1]戎晨阳,陈小华,刘云鹏.关于中国铸造业现状的思考[J].现代铸铁,2007(1):78~80
[2]张李波,葛晨光,田世光.关于我国铸造业走自主创新道路的思考[J].铸造,2006,55 (5):429~432
[3]张宏伟.企业信息系统建设策略及选择:[硕士学位论文].吉林:吉林大学,2005.
[4]陈启申.ERP—从内部集成起步[M].北京:电子工业出版社,2005(5):3~10
[5] Scott Hamilton,Maximizing your ERP system: a practical guide for managers,N.Y. McGraw~Hil,2003.
[6] Gray A.Langenwalter, Enterprise Resources Planning and Beyond,Integrating your Entire Organization , The St.Lucie Press/APICS Series On Resource Management,2000.
[7]李波.铸造企业管理信息系统:[硕士学位论文].太原:中北大学,2005.
[8]瞿超.铸造企业ERP中产品管理系统的设计与研究:[硕士学位论文].辽宁:辽宁科技大学,2007.
[9]金长久,王春鸽.铸造企业管理信息系统的开发和应用[J].现代铸铁,2004(5):20~22
[10]张晓萍,康进武,材料加工企业管理信息系统[M].北京:机械工业出版社,2000.
[11]袁忠华.通用铸造信息管理系统框架的研究和开发:[硕士学位论文].武汉:华中科技大学,2004.
[12]王宏军.铸造企业管理信息系统研究与开发:[硕士学位论文].武汉:华中科技大学,2003.
[13]唐有智,康进武,黄天佑,等.铸造企业管理信息系统的开发与应用[J].中国铸造装备与技术,2000(6):17~20
[14]陈曦初,康进武,胡艳梅,等.铸造企业生产管理信息系统[J].铸造,2000(10):791~794
[15]王俊强,康进武,黄天佑,等.铸造企业技术管理信息系统的研究开发[J].铸造,2001(10):621~624
[16]陈曦初,康进武,黄天佑,等.铸造企业生产管理信息系统的研究开发[J].中国机械工程,2001(5):148~150
[17]王宏军,刘瑞祥,李巧玉,等.铸造企业如何构建适合自己的管理信息系统[J].铸造技术,2003(1):60~61
[18]秦高,周建新,陈立亮,等.铸造企业产品质量管理信息系统的开发[J].铸造技术,2006(2):185~187
[19]王红楼,周建新,刘瑞祥,等.基于分布式模型的铸造企业ERP系统开发[J].铸造技术,2005(2):152~154
[20]卢建新,周建新,刘瑞祥,等.基于ASP.NET的熔模铸造企业ERP系统的开发[J].中国铸造装备与技术,2006(1):58~62
[21]葛红洲,周建新,陈立亮,等.熔模铸造企业ERP系统的开发与应用[J].特种铸造及有色合金,2007(7):511~514
[22]冯春亮,周建新,陈立亮,等.华铸ERP系统的研究与开发[J].中国机械工程,2006(10):274~278
[23]杨锐锐,周建新,陈立亮,等.熔模铸造企业ERP系统订单与销售模块的开发[J].中国铸造装备与技术,2007(4):59~61
[24]刘飞.基于智能客户端的铸造企业管理信息化解决方案的研究:[硕士学位论文].武汉:华中科技大学,2008.
[25]霍真.单件小批量类型铸造企业ERP系统的研究与开发:[硕士学位论文].武汉:华中科技大学,2008.
[26]鲍丽.MRPⅡ系统在企业间的应用浅析[J].科教文汇(下旬刊),2008 (5):151~152
[27] Spathis,Charalambos,Constantinides,Sylvia.The usefulness of ERP systems foreffective management.Industrial Management and Data Systems.2003, 103(8):677~685
[28] Guang Jin,Vince Thomson,A new framework for mrp systems to be effective in engineered-to-order environments, Robotics and Computer Integrated Manufacturing,19(2003):533~541
[29]米娜.MRPⅡ在中国的应用[J].科技管理研究,2000 (1):9~11
[30] Alistair R.Clark,Optimization approximations for capacity constrained material requirements planning,International Journal of Production Economics 84(2003):115~131
[31]陈启申.MRPⅡ制造资源基础[M].北京:企业管理出版社,1997.
[32] Landvater DV,Gray C D.MRP-II standard system[M].John Wiley&Sons,Inc.1989.
[33]余长国.物料需求原理[J].经济师,2000(11):212~213
[34] WALTEROROM, JOSEPHR MUSCATELLO.MRP in a job shop environment using a resource constrained project scheduling model.Journal of Database Management, 2002,30(4):175~180
[35] ROBERT GRUBBSTR.Planning and replanning the master production schedule under demand uncertainty.International Journal of Production Economics, 2002, 78(3):123~130
[36] Marcel Dissel.Lessons from four Chinese manufacturers.International Journal of Manufacturing Technology and Management,2008,14(4):231~233
[37]冯志波.业务流程图与数据流程图的比较[J].科技信息.2007(1):111~112
[38] SQL Server 2000 Product Overview http://www.microsoft.com/hk/sql/evaluation/overview/default.mspx
[39] Sybase PowerBuilder 11.5 http://pb.besoft.com.cn/PRODUCT/
[40]杨锐锐.基于C/S模式的铸造企业ERP系统的开发应用:[硕士学位论文].武汉:华中科技大学,2007.
[41]尹斐.MRP系统中的物料清单和物料需求计划研究:[硕士学位论文].西安:西安理工大学,2007.
[42] Thomas H.Davenport . Putting the enterprise into the enterprise system [M].Harvard Business Review,1998.
[43] David C.Yen.A synergic analysis for web-based enterrise resources planning system [M].Computer Standards,2002.
[44] MESA Internationa I.MES explained:A High Level Vision[M].Whitepaper,Pittsburgh:Manufacturing Execution Systems Assoc,1997.
[45]陈启申.从ERP应用谈BOM[J].CAD/CAM与制造业信息化,2005年Z1期:33~36
[46]张志檩.浅谈产品物料编码[J].数字石油和化工,2008 (7):15~20
[47]辛慧高,吴建华,游刚.企业信息化集成的基础与关键—物料编码[J].今日工程机械,2006(5):2~3
[48]王渭彪.物料编码—企业信息化的基础和保障[J].科技信息(学术研究), 2007,23:256
[49] Microsoft OLE DB http://msdn.microsoft.com/en-us/library/ms722784(VS.85). aspx
[50] Microsoft Open Database Connectivity (ODBC) http://msdn.microsoft.com/en-us/library/ms710252(VS.85).aspx
[51]萨师煊,王珊.数据库系统概论.(第四版).北京:高等教育出版社,2006.
[52]宣城新瑞机械有限公司http://www.xcxrjx.com/About.asp
[2]张李波,葛晨光,田世光.关于我国铸造业走自主创新道路的思考[J].铸造,2006,55 (5):429~432
[3]张宏伟.企业信息系统建设策略及选择:[硕士学位论文].吉林:吉林大学,2005.
[4]陈启申.ERP—从内部集成起步[M].北京:电子工业出版社,2005(5):3~10
[5] Scott Hamilton,Maximizing your ERP system: a practical guide for managers,N.Y. McGraw~Hil,2003.
[6] Gray A.Langenwalter, Enterprise Resources Planning and Beyond,Integrating your Entire Organization , The St.Lucie Press/APICS Series On Resource Management,2000.
[7]李波.铸造企业管理信息系统:[硕士学位论文].太原:中北大学,2005.
[8]瞿超.铸造企业ERP中产品管理系统的设计与研究:[硕士学位论文].辽宁:辽宁科技大学,2007.
[9]金长久,王春鸽.铸造企业管理信息系统的开发和应用[J].现代铸铁,2004(5):20~22
[10]张晓萍,康进武,材料加工企业管理信息系统[M].北京:机械工业出版社,2000.
[11]袁忠华.通用铸造信息管理系统框架的研究和开发:[硕士学位论文].武汉:华中科技大学,2004.
[12]王宏军.铸造企业管理信息系统研究与开发:[硕士学位论文].武汉:华中科技大学,2003.
[13]唐有智,康进武,黄天佑,等.铸造企业管理信息系统的开发与应用[J].中国铸造装备与技术,2000(6):17~20
[14]陈曦初,康进武,胡艳梅,等.铸造企业生产管理信息系统[J].铸造,2000(10):791~794
[15]王俊强,康进武,黄天佑,等.铸造企业技术管理信息系统的研究开发[J].铸造,2001(10):621~624
[16]陈曦初,康进武,黄天佑,等.铸造企业生产管理信息系统的研究开发[J].中国机械工程,2001(5):148~150
[17]王宏军,刘瑞祥,李巧玉,等.铸造企业如何构建适合自己的管理信息系统[J].铸造技术,2003(1):60~61
[18]秦高,周建新,陈立亮,等.铸造企业产品质量管理信息系统的开发[J].铸造技术,2006(2):185~187
[19]王红楼,周建新,刘瑞祥,等.基于分布式模型的铸造企业ERP系统开发[J].铸造技术,2005(2):152~154
[20]卢建新,周建新,刘瑞祥,等.基于ASP.NET的熔模铸造企业ERP系统的开发[J].中国铸造装备与技术,2006(1):58~62
[21]葛红洲,周建新,陈立亮,等.熔模铸造企业ERP系统的开发与应用[J].特种铸造及有色合金,2007(7):511~514
[22]冯春亮,周建新,陈立亮,等.华铸ERP系统的研究与开发[J].中国机械工程,2006(10):274~278
[23]杨锐锐,周建新,陈立亮,等.熔模铸造企业ERP系统订单与销售模块的开发[J].中国铸造装备与技术,2007(4):59~61
[24]刘飞.基于智能客户端的铸造企业管理信息化解决方案的研究:[硕士学位论文].武汉:华中科技大学,2008.
[25]霍真.单件小批量类型铸造企业ERP系统的研究与开发:[硕士学位论文].武汉:华中科技大学,2008.
[26]鲍丽.MRPⅡ系统在企业间的应用浅析[J].科教文汇(下旬刊),2008 (5):151~152
[27] Spathis,Charalambos,Constantinides,Sylvia.The usefulness of ERP systems foreffective management.Industrial Management and Data Systems.2003, 103(8):677~685
[28] Guang Jin,Vince Thomson,A new framework for mrp systems to be effective in engineered-to-order environments, Robotics and Computer Integrated Manufacturing,19(2003):533~541
[29]米娜.MRPⅡ在中国的应用[J].科技管理研究,2000 (1):9~11
[30] Alistair R.Clark,Optimization approximations for capacity constrained material requirements planning,International Journal of Production Economics 84(2003):115~131
[31]陈启申.MRPⅡ制造资源基础[M].北京:企业管理出版社,1997.
[32] Landvater DV,Gray C D.MRP-II standard system[M].John Wiley&Sons,Inc.1989.
[33]余长国.物料需求原理[J].经济师,2000(11):212~213
[34] WALTEROROM, JOSEPHR MUSCATELLO.MRP in a job shop environment using a resource constrained project scheduling model.Journal of Database Management, 2002,30(4):175~180
[35] ROBERT GRUBBSTR.Planning and replanning the master production schedule under demand uncertainty.International Journal of Production Economics, 2002, 78(3):123~130
[36] Marcel Dissel.Lessons from four Chinese manufacturers.International Journal of Manufacturing Technology and Management,2008,14(4):231~233
[37]冯志波.业务流程图与数据流程图的比较[J].科技信息.2007(1):111~112
[38] SQL Server 2000 Product Overview http://www.microsoft.com/hk/sql/evaluation/overview/default.mspx
[39] Sybase PowerBuilder 11.5 http://pb.besoft.com.cn/PRODUCT/
[40]杨锐锐.基于C/S模式的铸造企业ERP系统的开发应用:[硕士学位论文].武汉:华中科技大学,2007.
[41]尹斐.MRP系统中的物料清单和物料需求计划研究:[硕士学位论文].西安:西安理工大学,2007.
[42] Thomas H.Davenport . Putting the enterprise into the enterprise system [M].Harvard Business Review,1998.
[43] David C.Yen.A synergic analysis for web-based enterrise resources planning system [M].Computer Standards,2002.
[44] MESA Internationa I.MES explained:A High Level Vision[M].Whitepaper,Pittsburgh:Manufacturing Execution Systems Assoc,1997.
[45]陈启申.从ERP应用谈BOM[J].CAD/CAM与制造业信息化,2005年Z1期:33~36
[46]张志檩.浅谈产品物料编码[J].数字石油和化工,2008 (7):15~20
[47]辛慧高,吴建华,游刚.企业信息化集成的基础与关键—物料编码[J].今日工程机械,2006(5):2~3
[48]王渭彪.物料编码—企业信息化的基础和保障[J].科技信息(学术研究), 2007,23:256
[49] Microsoft OLE DB http://msdn.microsoft.com/en-us/library/ms722784(VS.85). aspx
[50] Microsoft Open Database Connectivity (ODBC) http://msdn.microsoft.com/en-us/library/ms710252(VS.85).aspx
[51]萨师煊,王珊.数据库系统概论.(第四版).北京:高等教育出版社,2006.
[52]宣城新瑞机械有限公司http://www.xcxrjx.com/About.asp