The Design And Realization Of Occupational Health Checkup Management System Based On .NET

Occupational health checkup (OHC) is the obligation of enterprises with environmental factors which may invoke occupational diseases. At present, the OHC organizations run inefficiently because of low-level information systems. This paper aims to construct a management system for OHC organizations to improve their work efficiency and supply individual services to their patients. In addition, it not only enables enterprises to preview their employees' checkup reports via network, but also permits occupational health regulation organizations to collect occupational disease cases, which is significant to prevent occupational diseases and make relevant policies.Analyzing the web application development methods based on .NET framework and N-ties architecture technology, a solution of management system for OHC organizations is conceived to meet the function needs of OHC organizations, using the technologies such as DHTML, database, network, AJAX etc. Its focal point is to conceive the systematic architecture and accomplish the division and realization of subsystems. While designing user interfaces of subsystems, user controls are used to keep the pages tidy and improve the commonality and code reuse of the system. In the process of database design, concept design, logic design and physical design are carried out, according to the dataflow of business.Comparing the three methods to generate Word document in web application, a method which codes using Word object according to word templates by coding in .NET, is chosen to generate inflexible format reports. Considering of the varied templates of OHC organizations, some tables which store the correspondence between bookmakers of a word document and fields of tables in database are added to database. As a result, a SQL procedure can select the very data which is needed by any word template and a total format report completes automatically, which greatly improves the work efficiency of OHC organizations.This paper also solves several crucial problems, such as creating barcode, realizing AJAX functions and solving the problem of system security. At present, the functions of OHC organizations management system are implemented basically. The system has come into use and runs well, which proves that the systematical design is reasonable and the solution is feasible.