Logistics Management System Design Of FAW JIEFANG CO.

The 21st century are the information time, the tertiary industry unceasingly rise in the various countries' proportion,in the global information is under the influence which the situation drives, the various countries' electronic commerce unceasing improvement and the consummation, the electronic commerce is a focal point which each country and each big company capture. And, along with the whole world electronic commerce swift and violent development, the electronic commerce scale expands day by day, if US in 2000 the electronic commerce amounts to 488.7 billion US dollars, Japanese 31.9 billion US dollars, German 20.6 billion US dollars.But in our country, the computer and the network technology popularization and the development, the electronic commerce rapidly rises, the multitudinous information technology enterprise, the venture capital company, the production circulation enterprise develops the electronic commerce in abundance. at the same time, the majority enterprise quite takes to the information construction, generally will favor the electronic commerce the future, the enterprise internal information construction has made the positive progress, was surmounting by the information isolated island to the information integration; The establishment has also made the certain progress in the network application foundation electronic commerce construction, some enterprises already through network information system managed supply chain. for example,the association group already has at present completed the supply chain link information, foundationally completed the development electronic commerce completely to work.This text has mainly introduced the development course of logistics Management System of FAW JIEFANG CO, have introduced the centralized purchasing of data integration,management of orders in detail . From the demand, to the design, reach code realize and then, core business logic of centralized purchasing adopts PL/SQL to realize,the system is based on Oracle 11i E-business Fundation.PL/SQL advantages as follows : PL/SQL is a high-performance processing of language-based services can operate in any Oracle environment, support all data-processing orders. PL/SQL dealing with SQL data definition and data control elements by means of modules.PL/SQL support all types and all SQL function, and support all types of Objects that Oracle has.PL/SQL pieces can be named and stored in the Oracle server, but also but also can be called by other procedures or SQL PL/SQL orders,and any client / server tool can visit PL/SQL procedure,so it has greate ability for reproduced.Oracle data tools can be userd to manage the security of procedures PL/SQL stored in oracle server.Other databases may authorize or revoke users which can visit PL/SQL procedure.PL/SQL code can use any ASCII text editor to prepare,it is convenient for any operating system oracle server can runs on.For SQL,ORACLE must at the same time addressing each SQL statements in the network environment, which means that for every independent functioning must be oracle server processing, which occupies a lot of time servers, and to network congestion. Is the expression of PL/SQL pieces to server, which reduces network congestion.This article is consist of five chapter.Chapter one is introduction. Chapter two is requirement analyse.Chapter three is system design.Chapter Four is system realization.Chapter five is summary.In the development course of this system,I took charge on requirement analyse and system design, the first problem what I met was data integration.How did distill data from other system to SCM system safely accurately stability duly ? Due to the difference of multiplicity,distance of transfer,real time in data transfer,I considered the request of schedule and cost,chose a casual solution.The solution is establishing many inhomogeneous interface.Then I researched the department,progress,habit of JieFang CO and read many books and articles about supply chain management, wrote document of requirement analyse. To place emphasis on design of system,I amended arithmetic of BOM spread and order build time after time.Finally,I accomplished the realizer,training,deploy of this system with my colleague.Since 2006,Supply Chain Management System of FAW JIEFANG CO began run formally, total amount of order was over 0.3 billion CNY. The anticipative aim is realized. We started actualizing and got favorable results immediately.