Design And Implementation Of Expert Database System For Material Plan Examination

With the continuous development of the management level of the China State Grid Corp, the intensive management of goods and materials continues to advance, which Henan Province, the company’s material management level has been put forward higher requirements. At present, the State Grid Corporation of material requirement planning is centralized management review, but of materials experts to review the information management is or artificial way,so that the expert’s information management, expert selection, expert in place statistics and some material plan data check and aspects of the work may be more complicated. This needs to improve the management method. The use of computer software to realize the material plan review expert database system,can make the management more convenient and orderly. In addition, it is helpful to improve the efficiency of material plan review by integrating some handy tools in the software.The system server operating system use Windows Server 2008, database using SQL Server 2008, in the framework of use based on WebService three-tier technology, aim to distinguish the level of that in order to "high cohesion and low coupling" idea of WebService including business logic layer, data access layer, client use WinForm programming technology based on devexpress interface library, devexpress has many excellent assortment and child controls, devexpress is very rich and is simple to use, interface skin is also very beautiful, very suitable for for WinForm application development. The Client Deployment uses InnoSetup packaging tools to make the installation package, and integrated.NetFrameWork4.0, when the program to upgrade, the client automatically detects and uses the HTTP protocol to download and update.In order to be compatible with the XP operating system, the.NETFramework framework uses 4 versions. In the deployment of a web server, the client can by any one can access the server and program updates, only on the server side to put newer files, version number can be modified, auxiliary tool is written using VC + + 2008, can be faster to access data and operation of local table data processing, in order to facilitate the expert attendance by ID card reader and fingerprint recognition, can choose two ways of authenticating sign in verification.After the project entered the field investigation, database design andinterface, interface design using devexpress, repeatedly because control attributes to strange, but did not reach the desired effect, many times but after the experiment, devexpress for the actual function of complete or a,after the completion of the interface design, project to realize the function for the preparation of the package, in devexpress call is very convenient.