Research And Implementation Of OA System Based On ASP.NET

Office Automation (OA for short) has already become an important approach of management modernization in modern enterprises. It can greatly improve the working efficiency. The system introduced in this treatise is a complete practical case without any platform base. The treatise works from the very beginning, introduces the construction designing idea, the business analyzing process, the database designment, and the programming implementation in the end. The system this treatise talks about includes several modules such as personnel managing system, file managing system, intramural mail system and agendum managing system.And This treatise is to research and implement the OA system of quality inspection institute,so we introduce in a special Quality Inspection module.This treatise introduces how to develop an Office Automation System using Microsoft ASP.NET. ASP.NET is a developing tool which is very easy to master. The reason is that it provides a great deal of simple controls, powerful class libraries, and excellent code structures. But it is still not an easy job to develop a good practical application system. This treatise makes a good use of the character of ASP.NET on developing WEB application programs, extracts experiences from practices, and thoroughly describes the process of a complete OA development.The case used in this treatise is the OAS of a quality inspection institute on special equipments in Hubei. Except usual office functional modules, this system includes a quality inspection module according to the requirement. The quality inspection system contains the following functions: the input and analysis of the inspecting data, the automatic formation of testing reports, and the management of inspecting reports.To deal with the storage and processing such large number of archive data,many solution uses either archive database to store the whole archive,or relational database to store every data of a archive in a table field.This treatise introduces a solution based on SQL Server,XML and WORD templates,greatly improves the accessing efficiency to the database, optimizes the structure of database designing.The main techniques involved are Xml, MSO (Microsoft Office), etc.The OAS introduced in this treatise uses MS SqlServer as the database.Through thorough research and application of SQL Server ,this treatise summarizes several advantages of SQL Server.