SRPS EN 287-1:2008
Dusan JOVANIC, Zeljko EREMIC, Milos JOVANOVIC
Technical Colllege of Appied Sciences in Zrenjanin, Dj. Stratimirovica 23, Zrenjanin, Serbia
Technical Colllege of Appied Sciences in Zrenjanin, Dj. Stratimirovica 23, Zrenjanin, Serbia
Welding Institute of Slovenia, Ptujska 19, Ljubljana, Slovenia
, ,
Abstract: Database of qualified welders provides improvement of the quality of welding process and meeting the requirements of the standard ISO 3834 – Quality requirementsfor fusionweldingof metallic materials, regarding keeping and systematic updating of the appropriate documentation.
The qualified welders database was designed by means of the Visual Studio 2008 and MS SQL Server 2008 Express as DBMS.
The appearance and the contents of the output document, i.e. the welder qualification entirely meet the requirements of the SRPS EN 287-1:2008 - Qualification test of welders- fusion welding, part 1: Steels.
Key words: welding management, welder qualification, database.
1 Name of the author, title, company, address and e-mail.
2 Name of the author, title, company, address and e-mail.
1. INTRODUCTION
According to the ISO Standard 3834 – Quality requirementsfor fusionweldingof metallic materials, a manufacturer must have a sufficient number of competent staff available in order to plan, perform, monitor and research welding production to meet the said requirements.
All welders must have a valid certificate - Qualification test of welders in accordance with the standard SRPS EN 287-1:2008.
The database of certified welders provides manufacturers with electronic data processing and management, which offers an accurate and fast insight regarding number, validity and range of qualification of welders.
2. PREREQUISITES FOR APPLICATION DEVELOPMENT
Prior to development of application to support training and certification of welders in Banat, it is necessary to provide environment for its development. Visual Studio 2008 environment was used to develop this application while Microsoft SQL Server 2008 Express was used as a database management system and Crystal Reports to create reports.
3. DESCRIPTION OF THE APPLICATION
The application contains a system for working with user accounts which requires users to log in to be able to work on the system. If a user wants to log in for working on the system, he must type in the account name and password. There are two types of users: administrators, who have access to all menu options, and ordinary users (operators) who cannot view the menu option “Administration”. The observed application will be analyzed in this paper through menu options it offers.
Fig.1. System login form and login form in the background
3.1. File
The menu bar button “File” contains two options: Log out (to log out actual user account, but without exiting the application) and exit (to close up the application). If a user is logged out of his account, it is possible to access the system again by entering any valid user account name and password.
3.2. Action
Action is a menu bar button used for direct work with certificates and it contains the following options:
· Certificate
· Certificate database
Certificate is used to open the basic form for a new certificate entry and it is called “Certificate”.
Fig.2. Form for a new certificate entry
TextBox components are used for textual data entry (which are in some cases, like for JMBG-personal identification number, limited to numbers only), DateTimePicker components are used for date entry, ComboBox lists, which are linked to appropriate data from the database, are used for data entry from a certain domain, while CheckBox control is used for logical data types entry.
In a part of the form which refers to data of ``test piece’’ automatic updating of values in provided at the moment of its change. For example, if a chosen value is in the field “material group 1.1“ in the column “range of qualification”, the value „1.1, 1.2, 1.4“ is immediately updated as well, etc. Similarly to value controls, the field ``Designation` is automatically updated as well.
Certificate database contains a list of recently entered certificates which is in the list on the right-hand side of the form. Changes in a selected certificate can be done by selecting the appropriate item in the list which opens form with identical interface as the interface used for entering a new certificate and its fields are loadedwith the data about the selected certificate previouslystored in the appropriate database tables. For the purpose of a more effective work, this form offers filtration of the list of existing certificates by the following criteria:
· certificate ID
· welder’s name
· welder’s company
· period of certificate validity
A click on the reset button enables to return the list of all recorded certificates.
Fig.3. Certificate database form
3.3. Administration
Administration is an item which is can be viewed only by the users having a status of administrator and it contains the following items:
· Settings
· Dictionary
· Range of qualification
· Account management
The form “Settings” controls settings of connection string used for connecting with the existing database. SqlConnection is a sub-class of ADO.NET class called Connection. It is designed to handle connections with databases of “SQL Server” [1]. If connecting with database fails when application is started, a new form shows up where a user may enter a correct connection string. Certificate template is a path leading to the report template. The application supports possibility to print the same data in different ways provided that there are several report templates. This form is also a place where application interface language can be changed.
Fig.4. Settings form
The item “Dictionary” opens a form which enables adjusting of those attributes which use values from a domain. An appropriate codebook should be selected first and then it is possible to add new items or modify and delete the existing items of a selected codebook. Codebook values are usually used in ComboBox lists of the form for certificate manipulation.
Fig.5. Dictionary form
Range of qualification is the item which opens a form for connecting independent values from used values section with dependent values from range of qualification section. Like in the case of the previous form, a codebook whose elements are used to create dependency links is selected. In the list on the left-hand side there are independent elements of the codebook and on the right-hand side there are potentially dependent codebook elements. Dependency links of selected independent element, if any, are given in the bottom field. In this form, new dependency links may be created or the existing ones modified.
Fig.5. Range of qualification form
Accounts management is a form which provides adding new accounts or managing the existing ones. Only administrators have access to this form because it is found within the item Administration.
Fig.6. Accounts management form
3.4. Assistance (Help)
This item contains items “About us” and short assistance (help) guidelines for using this system.
4. DATABASE
Application database contains several tables with stored data. The table “dictionary_type” contains a list of codebooks used in the system which even the administrator cannot access because it is received completed after installation and its content is unchangeable. The table “dictionary” which contains the codebook elements is linked to it. Each codebook element must be linked to its codebook through values in the field “type_id“. The table “dependency“ contains codebook element pairs, one of them being dependant, the other independent. Data are stored in this table through range of qualification form. The table “welder“ contains information about the welder who is awarded the certificate. The table “weldingcertificate“ is linked to the appropriate row in the table “welder“ through the field “welder_id“ and it contains information about the certificate awarded to a welder it is linked to. The data about the users who can log in for the work on the system (their username, password, and type of account – administrator or user, operator) can be found in the table “user“.
Certain fields in the tables “welder“ and “weldingcertificate“ contain codes of elements from the table “dictionary”. Those are the fields in the form “certificate” realized by using ComboBox list. This is an advantage in the situations when a codebook element changes its name because this change is automatically updated and in all linked certificates and welders. If, for example, a company entered into the codebook changed its name, it would be enough to change its name only in the codebook to have it changed with all recorded welders of that company.
Fig.7. Database diagram
5. DATA OPTIMIZATION AND SYNCHRONIZATION
Optimization and synchronization of the application is done by using DataSet collection of data and Propertiesnamespace. DataSet object memorizes the changes made to syllables stored in it. Owing to that, DataSet object can be used to update syllabus in the database. The main principle is very simple: at the beginning DataSet object will be filled in with data and than the changes will be entered in one or more syllables. After that the changes should be transferred into the database by means of DataAdapter object [2].
When the application is started the required information from the database is loaded in DataSet which is in operating memory. After that, the application communicates during operation with the data in DataSet collection which is in operating memory; DataSet synchronization in the databases is done occasionally and with the application at the end of the operation. Thus the interaction with the database in minimized which positively affects the application performances.
Setting of application parameters from the Settings form are saved between two application startups by using ’’Propertiesnamespace’’. ’’Connection string’’ is imported from this ’’namespace’’ when the application is started and then the link to the base is established and the data sending from the base in DataSet could start.
6. CONCLUSION
Database of qualified welders provides a fast and simple browse and selection of the most adequate staff for welding activities and hence, the quality of products is improved.
Besides, a database of qualified welders is created in accordance with the requirements prescribed by the standard SRPS EN 287-1 Qualification test of welders- fusion welding, part 1: Steels in the area of report appearance, and in accordance with standard ISO 3834 for creating and systematic updating of documentation.
REFERENCES
[1] John Sharp, “Microsoft Visual C# 2008: Korak po korak”, CET Computer Equipment and Trade ; Beograd, Sr.; Novembar 2009.
[2] Matthew MacDonald, „ASP.NET 3.5 sa C# 2008 od pocetnika do profesionalca“, Kompjuter biblioteka ; Cacak, Sr.; Juni 2009.
[3] SRPS EN 287-1:2008- Qualification test of welders- fusion welding, part 1: Steels.
ACKNOWLEDGEMENTS