Research And Implementation Of Examination Management System Of Worker Technology In Jilin Province

Technical worker of government departments and institutions examination investigates the work of promote the technique grade, the policy is strong, involving to face widely, the mission is very heavy, the difficulty is very big.A perfect examination management system of worker technology can be good to guarantee each unit at examine to register, the examination arrangement, the result importation, personnel admits each link not each it is, don't break the policy, not disorderly charges, this will promote my province organization business unit technique worker the examination investigate the management of automation level, the norm register, examine, train, investigate, the title assess, promotion management etc. workflow, the exaltation handle affairs the efficiency, avoiding the interference of the artificial factor, etc. all have the important meaning.Currently the technical worker of government departments and institutions examination all takes province as an unit, each province launches independently. Each province all has own policy provision at the time of obeying the national personnel subordinate' s documents. So the technical worker of government departments and institutions examination is developing all by oneself. The technique of each province worker technique of examination management system is different, some is the C/ S system of the tradition development tool the Visual FoxPro( or other development tool), and some is the B/ S system adopting ASP, ASP.net or JSP. The examination management system of worker technology in Jilin province adopts the single machine version procedure of the Visual FoxPro development in Windows 98 system originally, each unit organizes the work of registering and recording and carries on first step's examination. The registering software of each unit adopting demands the data putted into the softdisk, then adopting the artificial deliver method to send to data the local worker test office in order to carry on data's gathered and further examined. Furthermore, the procedure of the old system picture scanning is development in Windows 98 system, it already can't be used under the system of Windows XP. The management software of work tests everywhere also exists many problems. For example, because the software adopts single database of FoxBase, it makes the software can't operate a multiuser proceeing. Because of the number of registering increasing year by year, the length of people' s name codes of old system adopting is short, it usually appears the heavy code phenomenon after gathering. Great changes have taken place in the worker test policy, many parts of the old system are not adapting the new policy. Therefore, the version upgrade of the work test software is urgent and the utmost urgency.According to the concrete business request of the worker examination office and on the foundation of full exchanges and investigation up, the text puts forward a set of solution of examination management system of worker technology in Jilin province.In consideration of the concrete condition difference of each unit of Jilin province compare greatly, the new and old system may have a period of time to keep the both circumstance. Through the analysis and comparisons of characteristics of the two kinds of networks of Browser/ Server and Client/ Server,finally we select the Client/ Server to be system structure currently, upgrading gradually the C/ S structure and B/ S structure coexisting.The project adopts VB.net development, the server adopts the database of SQL Server, the client adopts the database of Access.The new system has the following characteristics:(1)Raising the convenient operation. The data recording adopts the choice method of the mouse to click bottom to pull the frame as far as possible, the legitimacy of the exaltation data. If we need the keyboard to record, we also adopt the intelligence method that it decreases the operator' s shot key times as far as possible, for example, if a man' s ID card of register is already recorded, then the date of birth, sex...etc. be auto analyzed, not to be recorded again.(2)Along with the website establishment of the worker examination office, the server adopts the database of SQL Server, providing the service of the data gathering and searching from everyplace worker examination office .(3)Along with the development of the calculator network, the net reporting name becomes a kind of simple and fast way. Because the circumstance difference of each unit inside the province compare greatly, the on- Line qualifications still has difficulty, therefore, the net reporting name is not broken through now, the province's worker examination office can only carry on on- line data's gathering and qualifications from everyplace worker examination office. The reporting name facing to the net of each unit inside the province will become realization. (4)Adopt the VB.net development terrace replacing the original language of Visual FoxPro. The VB.net terrace is suited to the network function enlargement in future, possessing various databases operation engine, is a kind of distance language developing the C/ S system or the B/ S system, thus the system temporarily adopts originally structure of C/ S, being convenient to convert to the B/ S system in the future. (5) Orientation development of the new work tests policy. In the last years the policy of the province work tests varies greatly, adopting the way of patching up before, increasing some additionally small procedures to originally the database of FoxBase to reply these varieties, the system became very miscellaneous and disorder,it was hard to control, only a person specially assigned to be responsible for it, the others can't work it , this takes extreme inconvenience to the work test management. The new system will resolve these problems completely, and for the part that usually change, such as the statement format, the time limit provision that qualifications examine etc. adopts the more vivid processing method, make these the variety needs to re- establish the software parameter but dose not need to revise the source code.This stationery body completed several research works of:1)Through the full exchanges with people of the worker examination office , the thorough investigation to the request of the worker examine, the management way and the workflow ,put forward to the technique solution setting up the new worker examination management system. Through the analysis and comparisons of characteristics of the two kinds of networks of Browser/ Server and Client/ Server, according to the characteristics of the management system and request, adopt the structure of C/ S currently, hereafter combine together the conversion toward B/ S and C/ S gradually.2) On the foundation of full analysis problem of the old system, induce and re- design to the database, the server is upgraded from the FoxBase to the SQL Server, abandoning many temporary database of old system.3) Reading completely the source code of the old system, according to the concrete request of the worker examination office, carry on the new total design and detailed designs to the new system.4) The whole system includes the design of the register management, the foundation database management, the training management, the practical examination management, the theoretical examination management, the statement statistical management and the result records management etc., this text mainly completes the training management, the practical management and the theoretical examination management. According to the design principle and targets of the examination management system of worker, carry on the design and analysis to the function, mold piece, the system process...etc. of the system. In development of the examination manage system, the point and the difficulty of this system is the method of the arrange training and examination room by the ADO.net technique.5) Carrying out the technical fusion of the .NET technique, the database technique and the crystal report technique, being advantageous to the software upgrade and function enlargements in future.6) Carrying out the copyright protection of the software, only guarantee legal customer can use the software correctly.On the say, this text mainly discusses the total structure of the technique examination management system of worker in Jilin province and the related technique of the usage, and carries out the training management, the practical examination management and the theoretical examination management. Its total target is to design and carry out a examination management system that matches the current worker examination situation, with simple operation and higher function.The thesis has studied the method and frames of the examination management system of worker technique , doing some foundation works for the topic, completing some of functions of the system.The future research can include the following several aspects:1) Need to make the interface of the system beautiful further;2) For the sake of the safety of the exaltation database, consider to change the database completely to the SQL Server;3) The register part of the system can be changed from the C/ S structure to the B/ S structure gradually.