WIXLIB

School of Mathematics and Systems EngineeringReports from MSI - Rapporter från MSIBuild an Inventory Tracking SystemHanzheng ZouSep2007MSIVäxjö UniversitySE-351 95 VÄXJÖReport 07109ISSN 1650-2647ISRN VXU/MSI/DA/E/--07109/--SE

Build an Inventory Tracking SystemHanzheng ZouSchool of Mathematics and Systems EngineeringVaxjo University

Abstract:This thesis paper introduces you about the process of how to build an inventory trackingsystem in a local Swedish company. The related project is to support the thesis paper,and is also for the company’ using. The software product of this project is an applicationthat works for managing various types’ instruments in the company of SWECO-Vaxjo.It will play an important role in the further management work of the company.In this thesis paper, the candidate techniques and theories for implementing thissystem are discussed. And in the end a good solution for this problem will be presentedin the paper.Keywords: Database, Microsoft Access, ODBC, Visual studio 2005, VC , MFC,UPEDU，DBMS.ii

Acknowledge:First I should say thank you to my supervisor Jesper Andersson. I am very happy that Iget a so practical project from him, and then I can do the interesting work, do a lot ofresearch about this topic and use it as my thesis paper. I can use my knowledge aboutUPEDU and C programming to do a real job. And I get many suggestions andadvices from Jesper when I am doing the project. When I started to write my thesis, hegave me much idea but how the structure should be and help me to get start. He spent alot of time on reading and correcting my thesis. Without his help, I can’t finish mythesis on time.Then I will give my regards to Andreas Petersson and Daniel Ottosson who are fromthe Swedish company. We had a nice communication and free talking, help me tounderstand the requirements and build the system for them. They are good men andeven some times come to the University to talk about the project with me. They reallydid a lot and help me a lot for this project.About writing a thesis paper, I didn’t have much experience. Mathias Hedenbog gaveme a lot of useful suggestions about writing a paper. I am appreciated that he spent a lotof time to read my paper. My paper opponent Francisco also helps me a lot to correctthe mistakes in the paper.iii

Table of ContentsTABLE OF CONTENTS . VLIST OF FIGURES.VIILIST OF TABLES . VIII1 INTRODUCTION .11.1 INTRODUCE THE PROJECT .11.2 SWECO COMPANY BACKGROUND .11.3 Research on the problem .21.3.1 General Research.21.3.2 Constraints & Delimitations .21.4 GOALS AND MOTIVATIONS .21.5 OUTLINES .32. THEORY (RELATED WORK).42.1 POSSIBLE TECHNIQUES.42.1.1 Database .42.1.2 Database Connection Technique.62.2 TOOLS AND PROGRAM LANGUAGES FOR DOING THE PROJECT .82.2.1 Java & Eclipse .82.2.2 C & Visual studio .82.2.3 Visual Basic .92.3 CANDIDATE SYSTEM SOLUTIONS.92.3.1 Client- Sever System.92.3.2 System running in Server Machine.92.4 METHOD AND PLANNING OF THE PROJECT .102.4.1 Method of dong the project .102.4.2 Planning of the project. 113. SOLUTION OF THE PROJECT.123.1 REQUIREMENT.123.1.1 Requirement Elicitation.133.1.2 Software Requirement Specification.153.2 SELECT METHOD AND TECHNIQUE .173.3ARCHITECTURE .183.4DESIGN .203.4.1 Analysis Class .213.4.2 Database Connection .233.4.3 Add Data .243.4.4 Search Data.253.4.5 Service Dealing .263.4.6 Booking .263.4.7 Report.27iv

3.5 ACCESS DATABASE DESIGN .273.6 IMPLEMENTATION .283.6.1 Add instrument to database.283.6.2 Search.293.6.3 Print .294. EVALUTATION AND RESULT .304.1 PROBLEMS IN THE PROJECT .314.2 EVALUATION .314.2 RESULT AND DELIVERY .325. DISCUSSION & CONCLUSION .335.1 CONCLUSION .335.2 FUTURE WORK.336. REFERENCES .35APPENDIX .361. WORKFLOW OF THE COMPANY .362. SOURCE CODE OF HOW TO ADDING DATA USING ODBC & MFC.373. SNAP OF THE SOFTWARE PRODUCT.38v

List of FiguresFIGURE 3.1 NETWORK ARCHITECTURE IN THE COMPANY . 13FIGURE 3.2 USE CASE DIAGRAM OF THE PROJECT . 14FIGURE 3.3 ARCHITECTURE OF THE SYSTEM . 15FIGURE 3.4 SYSTEM DESIGN DIAGRAM . 16FIGURE 3.5 ANALYSIS CLASSES DIAGRAM . 17FIGURE 3.6 CLASS DIAGRAM OF DATABASE CONNECTION PACKAGE . 19FIGURE 3.7 CLASS DIAGRAM OF ADD DATA PACKAGE. 20FIGURE 3.8 CLASS DIAGRAM OF SEARCH DATA PACKAGE . 21FIGURE 3.9 CLASS DIAGRAM OF SERVICE DEALING PACKAGE . 22FIGURE 3.10 CLASS DIAGRAM OF REPORT CREATING PACKAGE . 23FIGURE 3.11 DATABASE CONNECTION DIAGRAM . 24vi

List of TablesTABLE 2.1 TIME SCHEDULE OF THE PROJECT .11TABLE 3.1 DETAILED DESCRIPTION OF SYSTEM DESIGN DIAGRAM . 16TABLE 3.2 DETAILED DESCRIPTION OF ANALYSIS CLASSES DIAGRAM . 18TABLE 3.3 DETAILED DESCRIPTION OF DATABASE CONNECTION PACKAGE . 19TABLE 3.4 DETAILED DESCRIPTION OF ADD DATA PACKAGE . 20TABLE 3.5 DESCRIPTION OF SEARCH DATA PACKAGE . 21TABLE 3.6 DESCRIPTION OF SERVICE DEALING PACKAGE . 22TABLE 3.7 DETAILED DESCRIPTION OF REPORT CREATING PACKAGE . 23TABLE 4.1 SYSTEM FUNCTION REALIZATION . 27vii

1 IntroductionThe paper showing researches about how to build an inventory tracking system for aSwedish company. It introduces you the process of implement database managementsoftware, and in the end I give you the solution using Microsoft Access and VC areproved to be good one. Also there may be other techniques to realize this project. Thisthesis paper will based on a database project for a local company, then we can see howto design and realize a project for a company’s using. We will see some other relatedtechniques that can realize the project, discuss the advantages and disadvantages of eachtechnique, and you can also see why we choose Access and VC to implement thisproject.In the end of the project, you can see the software product that comes from thecombination of Access and VC . This will also be an achievement of a Chinesetrainee and a Swedish Company.1.1 Introduce the ProjectThis is a bachelor degree paper discussing about how to use Microsoft Access as thedatabase and use VC to do the GUI stuff.The Project is for this thesis topic. It is for SWECO VIAK which is Swedish localcompany. And the product of the project will be used by the worker of the company formanaging the instruments, and the instruments are brought from other distributors andwill be sold or leased to some of the other customers. Then the software will help thework of the people in the company a lot in their regular works. The software can keepthe records of all the instruments for their buying, leasing, selling or repair, and help thepeople in the company do some planned service in certain time.During the project, the developer and the company will follow the RUP process, tomake it efficient to finish the work.1.2 SWECO Company BackgroundSWECO is the Nordic region leading Consult Company with gathered knowledge intechnique, environment and architecture. With 4000 employees the company activelyparticipate in the process of develop a persevering society and an effective industry. Thecompany’s fellow worker supply solutions that give the functional and culturalbuildings and facilities, cost effective energy systems, better environment and efficientand profitable production.The SWECO company’ market is the Nordic region but acomprehensive foreign operation manages round the world.SWECO VIAK in Växjö isthe central supply of instruments for measure water, waste water and rain. The companyboth lease and sell instruments. They lease to other SWECO office, other externalcompanies and to social communities through internal assignments. Each instrument hasa unique identification number based on the type of instrument and if it’s a leasing or aninstrument for sale.1

The company has a quality system for maintaining the accuracy of each instrument.In periodically controls of people in the company will test different sensors to makesure that they fulfill the accurateness between different measure intervals.1.3 Research on the problemThis section wills discuss about the general problem of the project. You will see someconstraints and delimitations that possible to happen when building this project.1.3.1 General ResearchIn the company, there is a Microsoft Access instruments database in using. The databaseis built a while ago and there a few people who have worked with it. The problem oftoday’s database is that there is no built in function for several functions. Then theproblem is to add some new functions to the old system, use new techniques to realize anew system that designed for the company.There are several new functions need to be implement, such as Set Current Status,Traceable history of an instrument, Booking function, Alarm function etc. Our goal is tosolve the problems and build a stable system for the company.The company needs the application to be a Service-side application. That means thisapplication will be run in a local network. And the database in the server side can bevisited by different user using different computer. Then we should also consider aboutthe local network condition.1.3.2 Constraints & DelimitationsHere we will discuss two possible Constraints and Delimitations in implementing theproject. One is local network, the other one is server machine.z Local NetworkThis system should be run in the server and the client visit the database through thelocal network. Then the local network should be always working. The system workingproperly depends on the local network working fine.z Server Machine overloadThere are several applications running in the server machine, and the clients PC alwaysvisit the server machine through the network. Then the server machine may possible beoverload some time.1.4 Goals and MotivationsHere we will discuss about the goals and Motivations about the thesis and the relatedreal project.The main goal of this thesis paper is how to use Microsoft Access and VC to dorealize a software product. This means we will use Access play as the database and useVC to draw the GUI. Then in the paper we will discuss a lot of things about databasetechniques, and think about which one is better for the current requirements.The other goal is learning to use RUP process to solve the software problem. Thismeans think a way to solve the problem, adapt the RUP process to the current condition.2

This is also a good chance that the product can benefit the company workers a lot intheir regular work.1.5 OutlinesHere I will introduce the structure of the thesis paper.The Chapter 1 is introduction part, the background of the project and some problemsare discussed here.The Chapter 2 is something about the Theory and some related work and techniques.In this chapter, we discuss about some other candidate databases and techniques that canalso realize the project. We also discuss something about the UPEDU process andschedule of the project.The Chapter 3 gives the solution for the project. You can see the requirement, designand implementation detail in this chapter. The Database design can be also seen here.The Chapter 4 you will see the result of the thesis project. Then you can know howwell the design and implementation fulfill the requirements.The Chapter 5 discusses about the conclusion of the thesis.3