DoorFrameWelder.mdb part_no description no_hinges base_offset p1_dim p2_dim p3_dim jb_width 846030 ST2-HNG JB XXXXXXXXXX' 5 3/4 L 3 10.375 31.938 63.875 0.0 5.75 846031 ST2-HNG JB XXXXXXXXXX' 5 3/4 R...

VB.Net programming assignment



DoorFrameWelder.mdb part_nodescriptionno_hingesbase_offsetp1_dimp2_dimp3_dimjb_width 846030ST2-HNG JB (7-0) 10' 5 3/4 L310.37531.93863.8750.05.75 846031ST2-HNG JB (7-0) 10' 5 3/4 R310.37531.93863.8750.05.75 846080ST4-STR JB 10' 5 3/4 L140.3130.00.00.05.75 846081ST4-STR JB 10' 5 3/4 R140.3130.00.00.05.75 6036110DW-HJ-16-4-68-4 1/2-LH310.37529.93859.8750.04.5 6036111DW-HJ-16-4-68-4 1/2-RH310.37529.93859.8750.04.5 6036114DW-HJ-16-4-70-4 1/2-LH310.37531.93863.8750.04.5 6036115DW-HJ-16-4-70-4 1/2-RH310.37531.93863.8750.04.5 6036210DW-SJ-16-4-68-4 1/2-LH140.3130.00.00.04.5 6036211DW-SJ-16-4-68-4 1/2-RH140.3130.00.00.04.5 6036214DW-SJ-16-4-70-4 1/2-LH140.3130.00.00.04.5 6036215DW-SJ-16-4-70-4 1/2-RH140.3130.00.00.04.5 6045110DW-HJ-16-4-68-5 5/8-LH310.37529.93859.8750.05.625 6045111DW-HJ-16-4-68-5 5/8-RH310.37529.93859.8750.05.625 6045114DW-HJ-16-4-70-5 5/8-LH310.37531.93863.8750.05.625 6045115DW-HJ-16-4-70-5 5/8-RH310.37531.93863.8750.05.625 6045210DW-SJ-16-4-68-5 5/8-LH140.3130.00.00.05.625 6045211DW-SJ-16-4-68-5 5/8-RH140.3130.00.00.05.625 6045214DW-SJ-16-4-70-5 5/8-LH140.3130.00.00.05.625 6045215DW-SJ-16-4-70-5 5/8-RH140.3130.00.00.05.625 6047110DW-HJ-16-4-68-5 7/8-LH310.37529.93859.8750.05.875 6047111DW-HJ-16-4-68-5 7/8-RH310.37529.93859.8750.05.875 6047114DW-HJ-16-4-70-5 7/8-LH310.37531.93863.8750.05.875 6047115DW-HJ-16-4-70-5 7/8-RH310.37531.93863.8750.05.875 6047126DW-HJ-16-4-80-5 7/8-LH410.35925.29750.59475.8915.875 6047127DW-HJ-16-4-80-5 7/8-RH410.35925.29750.59475.8915.875 6047210DW-SJ-16-4-68-5 7/8-LH140.3130.00.00.05.875 6047211DW-SJ-16-4-68-5 7/8-RH140.3130.00.00.05.875 6047214DW-SJ-16-4-70-5 7/8-LH140.3130.00.00.05.875 6047215DW-SJ-16-4-70-5 7/8-RH140.3130.00.00.05.875 6047226DW-SJ-16-4-80-5 7/8-LH140.3130.00.00.05.875 6047227DW-SJ-16-4-80-5 7/8-RH140.3130.00.00.05.875 6050110DW-HJ-16-4-68-6 1/4-LH310.37529.93859.8750.06.25 6050111DW-HJ-16-4-68-6 1/4-RH310.37529.93859.8750.06.25 6050210DW-SJ-16-4-68-6 1/4-LH140.3130.00.00.06.25 6050211DW-SJ-16-4-68-6 1/4-RH140.3130.00.00.06.25 6057110DW-HJ-16-4-68-7 1/8-LH310.37529.93859.8750.07.125 6057111DW-HJ-16-4-68-7 1/8-RH310.37529.93859.8750.07.125 6057114DW-HJ-16-4-70-7 1/8-LH310.37531.93863.8750.07.125 6057115DW-HJ-16-4-70-7 1/8-RH310.37531.93863.8750.07.125 6057210DW-SJ-16-4-68-7 1/8-LH140.3130.00.00.07.125 6057211DW-SJ-16-4-68-7 1/8-RH140.3130.00.00.07.125 6057214DW-SJ-16-4-70-7 1/8-LH140.3130.00.00.07.125 6057215DW-SJ-16-4-70-7 1/8-RH140.3130.00.00.07.125 6066110DW-HJ-16-4-68-8 1/4-LH310.37529.93859.8750.08.25 6066111DW-HJ-16-4-68-8 1/4-RH310.37529.93859.8750.08.25 6066114DW-HJ-16-4-70-8 1/4-LH310.37531.93863.8750.08.25 6066115DW-HJ-16-4-70-8 1/4-RH310.37531.93863.8750.08.25 6066210DW-SJ-16-4-68-8 1/4-LH140.3130.00.00.08.25 6066211DW-SJ-16-4-68-8 1/4-RH140.3130.00.00.08.25 6066214DW-SJ-16-4-70-8 1/4-LH140.3130.00.00.08.25 6066215DW-SJ-16-4-70-8 1/4-RH140.3130.00.00.08.25 6745110DW-HJ-18-4-68-5 5/8-LH310.37529.93859.8750.05.625 6745111DW-HJ-18-4-68-5 5/8-RH310.37529.93859.8750.05.625 6745114DW-HJ-18-4-70-5 5/8-LH310.37531.93863.8750.05.625 6745115DW-HJ-18-4-70-5 5/8-RH310.37531.93863.8750.05.625 6745210DW-SJ-18-4-68-5 5/8-LH140.3130.00.00.05.625 6745211DW-SJ-18-4-68-5 5/8-RH140.3130.00.00.05.625 6745214DW-SJ-18-4-70-5 5/8-LH140.3130.00.00.05.625 6745215DW-SJ-18-4-70-5 5/8-RH140.3130.00.00.05.625 7038110HJ-16-4-68-4 3/4-LH310.37529.93859.8750.04.75 7038111HJ-16-4-68-4 3/4-RH310.37529.93859.8750.04.75 7038114HJ-16-4-70-4 3/4-LH310.37531.93863.8750.04.75 7038115HJ-16-4-70-4 3/4-RH310.37531.93863.8750.04.75 7038210SJ-16-4-68-4 3/4-LH140.3130.00.00.04.75 7038211SJ-16-4-68-4 3/4-RH140.3130.00.00.04.75 7038214SJ-16-4-70-4 3/4-LH140.3130.00.00.04.75 7038215SJ-16-4-70-4 3/4-RH140.3130.00.00.04.75 7046110HJ-16-4-68-5 3/4-LH310.37529.93859.8750.05.75 7046111HJ-16-4-68-5 3/4-RH310.37529.93859.8750.05.75 7046114HJ-16-4-70-5 3/4-LH310.37531.93863.8750.05.75 7046115HJ-16-4-70-5 3/4-RH310.37531.93863.8750.05.75 7046126HJ-16-4-80-5 3/4-LH410.35925.29750.59475.8915.75 7046127HJ-16-4-80-5 3/4-RH410.35925.29750.59475.8915.75 7046210SJ-16-4-68-5 3/4-LH140.3130.00.00.05.75 7046211SJ-16-4-68-5 3/4-RH140.3130.00.00.05.75 7046214SJ-16-4-70-5 3/4-LH140.3130.00.00.05.75 7046215SJ-16-4-70-5 3/4-RH140.3130.00.00.05.75 7046226SJ-16-4-80-5 3/4-LH140.3130.00.00.05.75 7046227SJ-16-4-80-5 3/4-RH140.3130.00.00.05.75 7054110HJ-16-4-68-6 3/4-LH310.37529.93859.8750.06.75 7054111HJ-16-4-68-6 3/4-RH310.37529.93859.8750.06.75 7054114HJ-16-4-70-6 3/4-LH310.37531.93863.8750.06.75 7054115HJ-16-4-70-6 3/4-RH310.37531.93863.8750.06.75 7054210SJ-16-4-68-6 3/4-LH140.3130.00.00.06.75 7054211SJ-16-4-68-6 3/4-RH140.3130.00.00.06.75 7054214SJ-16-4-70-6 3/4-LH140.3130.00.00.06.75 7054215SJ-16-4-70-6 3/4-RH140.3130.00.00.06.75 7062110HJ-16-4-68-7 3/4-LH310.37529.93859.8750.07.75 7062111HJ-16-4-68-7 3/4-RH310.37529.93859.8750.07.75 7062114HJ-16-4-70-7 3/4-LH310.37531.93863.8750.07.75 7062115HJ-16-4-70-7 3/4-RH310.37531.93863.8750.07.75 7062210SJ-16-4-68-7 3/4-LH140.3130.00.00.07.75 7062211SJ-16-4-68-7 3/4-RH140.3130.00.00.07.75 7062214SJ-16-4-70-7 3/4-LH140.3130.00.00.07.75 7062215SJ-16-4-70-7 3/4-RH140.3130.00.00.07.75 7070110HJ-16-4-68-8 3/4-LH310.37529.93859.8750.08.75 7070111HJ-16-4-68-8 3/4-RH310.37529.93859.8750.08.75 7070114HJ-16-4-70-8 3/4-LH310.37531.93863.8750.08.75 7070115HJ-16-4-70-8 3/4-RH310.37531.93863.8750.08.75 7070210SJ-16-4-68-8 3/4-LH140.3130.00.00.08.75 7070211SJ-16-4-68-8 3/4-RH140.3130.00.00.08.75 7070214SJ-16-4-70-8 3/4-LH140.3130.00.00.08.75 7070215SJ-16-4-70-8 3/4-RH140.3130.00.00.08.75 A5 Video.mp4 Lesson Plan Title: Advanced Programming Assignment 5 DoorWelder.docx Page 1 of 5 Assignment 5 – Door Hinge Welder Overview: In this assignment, you will use an existing table in an Access database (show below). The table contains production information for a door hinge welding machine that welds hinges onto metal door frames. Fields in the table part_no – is a number that contains the unique part number and is the primary key for the table. description – is text data that describes the part. no_hinges – is a number that indicates the number of hinges that will be on the door. base_offset – is a number that gives the distance from base datum to the 1st hinge. p1_dim – is a number that gives the distance from the 1st hinge to the 2nd. p2_dim – is a number that gives the distance from the 2nd hinge to the 3rd. Advanced Programming Assignment 5 DoorWelder.docx Page 2 of 5 p3_dim – is a number that gives the distance from the 3rd hinge to the 4th. jb_width – is a number that give the width (depth) of the jamb. All dimensions are in inches. You will also create a second table in the database. This table is used to co-ordinate communications between different devices that are used in a production cell. It will be up to you to decide how to design this table. The Devices There are two devices that make up the cell. One is a robot that loads/unloads a door frame. The other is a hard automation device that is controlled by a PLC. It places the hinges on the frame, and welds them. The Programs 1. A program to create the communications table. This needs to be run only once. The program should be able to delete and recreate the communications table. 2. An HMI that will allow an operator to order a production run. The operator will be able to enter a part number and the number of units to make. It should keep track of the number of parts that have been made. 3. A program that monitors the database and communicates with the robot. When a production run has started, it tells the robot to load/unload the frames as needed. Advanced Programming Assignment 5 DoorWelder.docx Page 3 of 5 4. A program that monitors the database and communicates with the welder to place and weld the hinges. It will tell the welder how many hinges to weld, and the distances to move for each hinge. Each production program runs independently of the other programs. There is no communication between them. Each program monitors the database (the second table you added) to see if there is a job for it to do. Once it finds a job, it will update the database to indicate it has started the job, and when the job is complete, it will update the database to indicate it has completed the job. For example, the operator requests 10 door frames of a part number. This information will be put into the database and production started. For each of the door frames in the production order, the following will happen. 1. When the robot detects there is an order placed, it will load the frame and update the database to indicate a frame is ready. 2. When the welder program detects there is a frame loaded, it will place the hinges and do the welding. When done, it will update the database to indicate the welding has been done. 3. When the robot program detects a frame has been welded, it will unload the frame and update the database to indicate the frame has been unloaded. After 10 door frames have been processed, the order is complete. The robot and welder programs will have to periodically query the database to see if there is anything for them to do. Advanced Programming Assignment 5 DoorWelder.docx Page 4 of 5 Programming Tips The production programs will have to query the database periodically. You could use a timer for this so a query is sent every time the timer expires. The robot and welder do not have to do anything special, just indicate on the form that they are working or waiting. You could use another timer to simulate the time it takes to do the work. Setup Requirements: Download the DoorFrameWelder.mdb database file from eConestoga. Put the file in the root directory of drive C: Deposit: 1. A Word doc with an explanation on how the programs co-ordinate using the database during a production run. 2. .txt file of your code for each program. 3. PDF rubric page. 4. Pictures of all forms 5. Follow the usual instructions for submission of this assignment Advanced Programming Assignment 5 DoorWelder.docx Page 5 of 5 Assignment Evaluation Category Rating Weighting Factor Mark Comms Table Design Explanation 0 1 2 3 4 5 2 Comms Table Program 0 1 2 3 4 5 2 HMI 0 1 2 3 4 5 3 Robot 0 1 2 3 4 5 2 Welder 0 1 2 3 4 5 2 Production Run 0 1 2 3 4 5 3 Error Handling 0 1 2 3 4 5 2 Coding Techniques 0 1 2 3 4 5 4 Missing Options 0 -10 1 Assignment Mark