Abstract:
To analyze, design and develop a sales system for steel processing business with electronic commerce system. Sale process and data from Bangkok Coil Center Company Limited are used as a case study. Researcher studies the theory of electronic commerce, data mining, system development life cycle, database management, design and development of web application. This research also investigates the sales system for steel processing business and condition of sales system. Researcher analyzed and designed the system which were master data maintenance, customer registration, customer ordering, customer order verification, order status inquiry, order changing, order canceling, raw materials purchasing and summary and analytical report system. Researcher developed the system based on the relational data model using Microsoft SQL Server 2000 for data storing and manipulating. Researcher used Microsoft Visual Basic 6.0 and Microsoft Visual Interdev 6.0 for application development tools. The developed system is Windows-based system compatible. After the completion of system development, researcher tested the system and found that it achieved the system objectives. This research will be signifacantly useful for steel processing business and other similar business. It can improve the effectiveness and efficiency of sales system, and it also helps to facilitate working process for customers and relevant departments so as to gain convenience, acceleration and accuracy