Based On MVC Design Pattern OA System's Database Stored Procedure Research And Application

This dissertation is mainly for the research and application about the OA'sdatabase Stored Procedure which based on MVC design pattern. The MVC designpattern is an excellent design pattern because it can separate the system to threeparts—model,view and controller. The three levels are independent. That ispropitious for maintenance and update of program, and better for readability. OAsystem (office automation system) means that through a combination of managementscience, behavioral science and so on using computer technology, networktransmission, realize a system which can assist office and accelerate the officeproductivity by coding. With the progress of the current society, various kinds ofenterprises in China are faced the times request of informationization. More and morecompanies continuously import office automation systems (OA system) to assistthemselves with data process, improving the business efficiency. What is called officeautomation is that through the internet and information technology to realizedissemination and processing data in high speed. Now most of the systems are basedon B/S pattern. Clients can use the system without installation through B/S pattern. Itfacilitate the use of the system, client can achieve access to the system at anytimeanywhere through the internet. The most popular develop pattern is MVC architecture,because it is very easy to realize the resource codes'reuse, and is convenient tomaintain and update.This paper's research object comes from *** Enterprises Group Corporation'sgrind-coal system's automation systems which is in connection with office operation.The paper's investigative object is how to complete an Online OA system whichbased on MVC architecture. Furthermore, in the database area, it is mainly aboutusing the Store Procedure to realize the operations of the data. Systems mainly functions are: 1.System login and user management: login, register, add and deleteusers, assign privilege for users, change the users'privilege. 2.Common informationmanagement:common information mainly includes announcements, regulations,work plans,organizations,news of the company and so on. Basically to manage thepublic information that can be seen by all the stuff. 3.Office operation management:We can use this part through choose the departments that we want to enter, includingdocument management, meeting management,document sending and receiving,filesending and process, and the department information management and so on.4.Personal information management: blog management,document managementpersonal information management and so on. 5. System management: look over errorblog and so on. System's developing is based on Microsoft.Net platform. The IDE isvisual studio 2005, the database is SQL server 2005 and the service protocol is IIS.This dissertation's research work is aimed at the design and implementation ofMVC design pattern and through the Stored Procedures to deal with the data. We needto divide the system into three main parts by Model-View-Controller structure. Thefirst is the view displayed with the users. It is implemented by ASP. Net's .aspx files.By using Web Form programmed pattern that means we use the templates in visualstudio to developing the web page. We call some of the widgets to implement thedisplay to the users. Controller layer mainly implements the logical processingfunctions. This part is mainly reflected in the file .aspx.cs and the function classes wedesigned. The former can realize some simple logic to determine and then call thelatter to achieve a specific complex logic processing, because a lot of widgets havefunctions which are bound to the .aspx.cs files. We can easily through users'input tocall the appropriate processing. Model is mainly reflected in that the data we neededto deal with are independent of logic process parts. The same logic process functioncan deal with many different data, which is good for reuse. Data processing partmainly refers to stored procedures. Stored Procedures forms of flow control and SQLsentences. it is written in the database service and is compiled already, upper levelwill call the stored procedures according to its name and the input parameter. All the data operation that this system refers to is done by stored procedures. How to call thestored procedures one by one level is an important part of this article.It took several months from the requirement analysis to the final design. The firstpart of this article introduces some background knowledge, as well as the source ofthe subject. The second part of this article introduces the requirement analysis of thesystem as well as the system design. The third part introduces the detail design of thissystem, including related technology and the function module design of the system.The fourth part of the article introduces the database design and implementation,including the tables and fields design in the database. The fifth part mainly introduceshow the Stored Procedures are used in the real project. Specifically describes thestored procedure from coding to how to call in the upper level. The sixth part mainlyintroduces how the functions of the system are implemented and some test cases. Thelast part is a summary and prospect of the thesis, mainly reviews the problems duringthe system development and some areas could be improved.In short, this article mainly studies and implements an office automation systembased on MVC module using stored procedures.