Design and Implementation of Auto Parts Data Management System Based on BOM

Article Preview

Abstract:

According to the current actual situation of informatization in Commercial Vehicle Company of DF Motor Co., Ltd. , there exists such a problem as the incomplete parts data of S-BOM, which fails to provide complete parts data of the department of procurement and sales. In order to solve the problem, this paper designs and develops the parts of DF Motor Co., Ltd. Data Management System. The system uses Delphi 7.0 as the development tools and Oracle 9i as the back-end database,which implements the function of centralized management, maintenance and query of S-BOM parts data by means of parts state management, structured data management, parts data query and other function modules. The system meets Commercial Vehicle Company's requirements of centralized procurement by addressing some of the key issues in the original parts management. Fund Project: Key Projects of Science and Technology Research of Hubei Department of Education (No. D200723003 ); Projects of National Natural Science Foundation, 2010(No. 51006132)

You might also be interested in these eBooks

Info:

Periodical:

Pages:

42-47

Citation:

Online since:

October 2011

Export:

Price:

Permissions CCC:

Permissions PLS:

Сopyright:

© 2012 Trans Tech Publications Ltd. All Rights Reserved

Share:

Citation:

[1] Hong Luo, Zhongmin Wang. The Principle Design and Practice of ERP[M]. Beijing: Publishing House of electronics industry, (2003).

Google Scholar

[2] Haoqiu Cheng, Shaomei Fei, Shuyou Zhang. Research on Product's BOM Model Construction and Solution Method Based on Dynamic Orders [J]. China Mechanical Engineering, 2010, 21(13).

Google Scholar

[3] Yuan Pingpeng, Chen Gang, Dong Jinxiang. Consistency Maintenance of BOM [J]. Journal of Computer Aided Design & Computer Graphics, 2002, 14(1).

Google Scholar

[4] WANG Wei-guo, YAN Guang-rong, LEI Yi. Novel storage model of manufacturing BOM [J]. Computer Integrated Manufacturing Systems, 2010, ` 16(3).

Google Scholar

[5] WANG Zhi-he, ZHANG Qiang, LIU Xue-yan. Design and implementation of automatic telescopic component on Dehpil report forms [J]. Journal of Northwest Normal University(Natural Science Edition), 2002(2): 38-40.

Google Scholar

[6] Lawrence Linnemeyer, Bradley Brown. Oracle HTML DB handbook[M]. McGraw-Hill/Osborne, (2007).

Google Scholar