Production Material Supply And Purchasing Management System For Aiyin Company

With the fast changing market and clients’ diverse requirements, Aiyin company needs to address the production material purchasing, supply management based on advanced information techniques to support the enterprise’s multiple varieties and small batch products strategy. This means the information system to solve the problems of purchasing batches computing and orders creating which in detail are the scientific decision of what components to purchases, how many to order and when to order.Focusing on the above key problem, this thesis discusses design and implementation of the purchasing and supply system from the view of software developing. First, it outlined introduces the system’s developing theory and technology foundation, including product management, supply chain management and company database technology. Then, it gives the system’s function analysis, including components demand computing function, order generating function, supplier and logistic information management function, order transaction processing function, and components inventory control function. It also gives the above functions’corresponding user cases. This system’s design structure is a distributed system with multiple structures. The thesis also systematically discusses the software structure, database design scenario and the system’s internal main processing process, and gives the system’s programming implementation.This system is developed based on multiple layer structure. The applied server programming uses Java, the background database platform programming uses SQL and the database system is implemented by Oracle enterprise database. The system has been finished testing and test run inspection, and reaches its anticipated developing target.