User:Chen Qing
Hello everyone, welcome to my home page. I am a 2008 cosc427 student.
Design Study
Recently I have built a “quick and dirty” MS Access based VBA application for a friend. The application is for helping a small printing company to maintain their job records, organize their job flow and providing some reporting function etc. I thought this is a good case to exercises what we have learned through the cosc427 lectures (and also past courses), so I reworked on this application and will build it within an object-oriented environment.
The starting point for this application is simple. We need a printing company which can produces some of its print products. The application should be able to handle various types of print products from simple one page business card to complex multi page/sheet book and NCR booklet. We want the application to be able to use as a front end for a database to create, retrieve and manage the work the company has. The overview of the application class structure is diagramed in Figure 1.
PrintCompany class is the main class used to represent the printing company. The company holds references to its customers, employees, external contractors (this is quite often used for some design works), and departments. The print company also has a job queue which is used to track all the jobs. Object PrintJob is used to represents each individual print job (their orders). For each individual print job, it could have one or more final print products. Also for each print job, there is a state associated with (i.e. in quoting state, in designing state and in pressing state etc.). The design details for print job and print products are illustrated in Figure 2.
