Microsoft Word - cet-01.docx CHEMICAL ENGINEERING TRANSACTIONS VOL. 46, 2015 A publication of The Italian Association of Chemical Engineering Online at www.aidic.it/cet Guest Editors: Peiyu Ren, Yancang Li, Huiping Song Copyright © 2015, AIDIC Servizi S.r.l., ISBN 978-88-95608-37-2; ISSN 2283-9216 Research on Steel Pipe Tracing System Qi-xiang Song College of Information Engineering, Suzhou University, Suzhou, China. sqx1963@163.com For domestic steel companies management lags behind, in the face of increasingly fierce competition in international and domestic markets, the implementation of an effective system of steel queries is necessary and urgent. In order for consumers can check the relevant steel pipe manufacturing information after the purchase, a pipe tracing system is researched and developed in this paper. The system uses the B / S structure, uses ASP to develop prospects interface and uses SQL SERVER 2008 database as a background. Achieve function that steel information can be added and queried, cycles and station information can be queried and added and so on, which supervise and manage the steel pipe from the source. Finally, the system implementation renderings are shown. 1. Introduction Internet technology has been very mature today, which was confirmed by Cheng Wang et al., [Li Yang-jun et al.,Qiuhe Huang et al.,Sucheng Shang.. Using the Internet to develop traceability systems becomes into a hotspot, which was confirmed by M. Krotkiewski et al.,A. R. et al.,Hobbs J E et al.,PettittR G,Mauro Conter et al.,Jevsenik M et al.. As important steel, steel pipe maintains a rapid growth rate in the domestic consumption. Export volume is increasing year by year, which was confirmed by China Steel Harbor, LIU Tao et al. There is a large difference on quality of steel pipe which produced by us and imports. It is because of differences in quality that gives us a huge economic loss, which was confirmed by Gui Ying and Wang Jing-gang. To change this situation, domestic enterprises are standardized managed, constantly improve the quality of steel and establish a sound quality assurance system, which are problems that the enterprise had to face. Therefore, traceability system of steel pipe is developed, from the source to supervise and manage the quality of the steel pipe, improve the quality of steel pipe. 2. Systems Analysis Currently, the network application in all walks of life has gained popularity. This allows business managers to understand operating condition of the business anytime, anywhere, to solve the problem more effective. Query progress according to user’s input, user-friendly for user intuitive understanding of the progress of the pipeline. Use function modular design method, both for system functions in various combinations and modifications, and easy supplement and maintenance by staff not involved in developing. The maintain core process planning of system is shown in Figure 1. Figure 1.Process planning of system DOI: 10.3303/CET1546023 Please cite this article as: Song Q.X., 2015, Research on steel pipe tracing system, Chemical Engineering Transactions, 46, 133-138 DOI:10.3303/CET1546023 133 Pipe traceability system developed in this paper mainly uses in B / S structure, which was confirmed by Chen Changxi, et al, uses asp.net, which was confirmed by Adam Freeman and Aguilar, and three-tier(presentation layer, business logic layer, data access layer) mechanism to develop. The three-tier model is shown in Figure 2. Figure 2 Three-tier structure Figure 3 Data transfer between three-tire The presentation layer provides users with an interactive user interface, business logic layer handles business-critical, responsible for data transfer between presentation layer and data access layer, data access layer achieve the data stored and read operations, which is shown in Figure 3. 3. System Design 3.1 System Components 1) The system includes four functional modules, namely materials information management, user management, cycle management and station management. Material information management module includes material information storage and material information query, which is shown in Figure 4. Figure 4. Material information management module Material Information storage: mainly for the need for traceability of the product to add into the system to facilitate every record there will need to input the information corresponding part number, tube number, weight, width, length, heat number, lot number information . Material Information query: mainly for adding product pipeline management, including import, export functions, user-friendly operation. Import is given according to the user based on excel template and edit the information you want to import, and then imported in bulk, when there is information to excel in the same time will not repeat the import. All information derived materials, to facilitate the user to view, edit and manage. Clear role is to clear all the information (with caution). 2) User management module major includes new users and user queries two functions, which is shown in Figure 5. Figure 5. User management Figure 6. Cycle management New user: users contain an administrator user. Users who added to the system can not log on, only add to the traceability of products flow. When add the user, must choose detect bit belongs to, which in order to easily detect which bit is operated. Adding needs to include the new user name, password, and the station is detected. User query: for users to edit and delete functions. Edit mainly on the existing users to update the information. Delete mainly for existing users select Delete. 3) Cycle management module includes adding cycle, cycle query, which is shown in Figure 6. Add cycle mainly display evening and early morning period of time to convenient record the operation shift of product recording. Information needs to be added are name, start time and end time. Edit mainly on existing information updated. Delete can choose information to delete. 134 4) Stations management module mainly includes process query, add stations, station query process queries, which is shown in Figure 7. Process Query: query by keyword, classes, day, week and month. Export all data inside the pipeline, including all other information pipeline to export all parameters. Clear all information. Station Add: Add station information, the station name, the process sequence need to be input. Station query: displays all information of stations, the selected stations can be updated, delete the existing station information Figure 7. Stations management 3.2 System flow chart The flow chart of system is shown in Figure 8. Figure 8. The flow chart of system 3.3 Database Design This database tables are mainly used in the system as follow. Table1 Code single table No. Column name Data types length Decimal Primary key Explanation 1 ID int 4 0 Yes 2 Partsnumber int 4 0 Part No. 3 Tubingnumber nvarchar 550 0 Pipe No. 4 Weight nvarchar 50 0 Weight 5 Length nvarchar 50 0 Length 6 Heatnumber nvarchar 50 0 Furnace No. 7 Batchnumber nvarchar 50 0 8 CreatTime datetime 8 3 9 CreateUser nvarchar 50 0 10 EditTime datetime 8 3 11 EditUser varchar 50 0 135 Table2 Cycle table No. Column name Data types length Decimal Primary key Explanation 1 Id int 4 0 Yes 2 Period nvarchar 50 0 Cycle name 3 StartTime datetime 8 3 Starting time 4 EndTime datetime 8 3 End time 5 AddUser int 4 0 Add user 6 AddTime datetime 8 3 Add time 7 Z nchar 10 0 Reserved 8 ParentId int 4 0 Check Table 3 Detect bit table No. Column name Data types length Decimal Primary key Explanation 1 ID int 4 0 Yes 2 Name nvarchar 50 0 3 ParentID int 4 0 4 z nchar 10 0 Reserved 5 ParentID int 4 0 Table 4 Operating Table Table 5 user table No. Column name Data types length Decimal Primary key Explanation 1 ID int 4 0 Yes 2 UserName nvarchar 50 0 3 UserPwd nvarchar 50 0 4 Flag int 4 0 5 PeriodID int 4 0 No. Column name Data types length Decimal Primary key Explanation 1 ID int 4 0 Yes Pipe No. 2 Num nvarchar 50 0 3 ActionTime datatime 8 3 4 ActionName nvarchar 50 0 Reserved 5 PeriodID int 4 0 6 UserID int 4 0 7 StationID int 4 0 136 4. System implementation Users first enter the system login screen is shown in Figure 9. Figure 9. Login screen Then enter information query interface to query the information, which is shown in Figure 10. Figure 10. Material information inquiry If you enter an administrator, you can also add material information, which is shown in figure 11. Figure 11 Add interface material The system can also manage users, user management interface shown in Figure 12. Figure 12. User management The cycle management interface shown in Figure 13. 137 Figure 13. Cycle management 5. Conclusion At present, the lack of effective tracking of steel production situation in our country makes the steel pipe companies with low competitiveness. Pipe traceability system developed in this paper solves the problem of supervision of quality steel from the source, to ensure the effective competitiveness of enterprises. The system uses B / S structure to develop. Users can query production information after purchase steel and other information of steel cycle through the system. Therefore, the system developed in this paper has certain significance in traceability of steel work. Acknowledgements The study of our work is supported in part by Young Talents Fund Project in Anhui Province of China (No. 2013SQRL083ZD), Anhui University Provincial Natural Science Research Project (No.KJ2014A247). Reference Aguilar, 2012, ASP. NET SignalR Programming combat, Beijing: Tsinghua University Press. Chen C.X., Zhang H.F., Fei X.J.W., et al, 2010, Design of whole process tracking and traceability platform of broilers safety production, Transactions of the CSAE, 26(9), 263 － 269, doi:10.3969/j.issn.1002- 6819.2010.09.043 Conter M., Zanardi E., Ghidini S., et al, 2008,Consumers’ behaviour toward typical Italian dry sausages, Food Control, 19(6), 609-615. Freeman A., 2014, Proficient in ASP. NET MVC 4, Beijing: People's Posts and Telecommunications Press. Gui Y., 2008, Design on material tracking system based on seamless pipe, Shenyang: Shenyang Institute of Aeronautical Engineering. Hobbs J.E., 2006, Traceability in the agri-food sector: Issues, insight and implications, CAB reviews: Perspectives in Agriculture, Veterinary Science, Nutrition and Natural Resources, 1(29), 1-7. Huang Q.H., Wei L.Y., Huo H.F., 2014,RESEARCH ON INDEPENDENT COLLEGE TEACHERS’ TEACHING ABILITY BASED ON FACTOR ANALYSIS IN SPSS,MATHEMATICAL MODELLING AND ENGINEERING PROBLEMS,1(1), 25-28 Jevsenik M., Hlebec V., Raspor P., 2008, Consumers’ awareness of food safety from shopping to eating, Food Control, 19(8), 737-745. Li Y.J., Peng Q.,Yang J., Huang H.S., 2015, RESEARCH AND DESIGN OF WARD CALLING DEVICE ,REVIEW OF COMPUTER ENGINEER STUDIES, 2(1), 37-40 Liu T., Wang X., Li Z.Z., Liu H.G., 2012, Research on Automation and Information Construction of SAW Pipe Production Line in China, Welded Pipe and Tube, 35(5), 62-65, doi: 1001－3938(2012)05-0062-04 Krotkiewski M., Dabrowski M., 2010, Parallel symmetricsparse matrix-vector product on scalar multi-core CPUs,Parallel Comput., 36(4), 181-198. Mohd Syaifudin A. R., Mukhopadhyay S. C., Yu P. L., 2012, Modelling and fabrication of optimum structure of novel interdigital sensors for food inspection, International Journal of Numerical Modelling: Electronic Networks, Devices and Fields, 25(1), 64-81, DOI: 10.1002/jnm.813 PettittR G., 2001, Traceability in the food animal industry andsupermar-ketchains, Rev Sci Tech of Int Epiz, V20(2), 584-597. Shang S.C., Zhou H., Chang X., Liu M.X., Li N., Shang Q.Q., 2014, STUDY ON FACTORS OF INJECT LARGE VOLUME LIQUID INTO TRUNK. MATHEMATICAL MODELLING OF ENGINEERING PROBLEMS, 1(2):11-14 Wang C., Zhu S.M., 2015, A DESIGN OF FPGA-BASED SYSTEM FOR IMAGE PROCESSING, REVIEW OF COMPUTER ENGINEERING STUDIES, 2(1), 23-28. China Steel Harbor, 2012-10-25, 2012 Chinese seamless pipe market analyzed [EB/OL], www.zgggxxg.cn. Zhu W.J., Li Z.X., Yuan Z.L., 2013, Design and Implementation of Pipe Information Tracking System, Manufacturing Automation, 35(10), 115-119, 10.3969/j.issn.1009-0134.2013.10.34 138