CN103294680A - XML (extensive makeup language)-based Web data report generation method under NET framework - Google Patents

Abstract

The invention provides an XML-based Web data report generation method under an NET framework. The XML-based Web data report generation method is based on a general report engine of the XML and can be used for generating various flexible and professional enterprise reporting remotely in an internet environment, and the whole report engine is a critical section of a database system. The development process and the utilization technology of the report engine such as NETFramework, XML, OfficeWebComponent, ActiveX and the like are elaborated, and the utilization process of the report engine is displayed, and powerful functions of the engine can be seen therefrom.

Description

The Web datagram table generating method of basic XML under a kind of NET framework

Technical field

The present invention relates under a kind of NET framework the Web datagram table generating method based on XML, particularly be based on the method that the data sheet in the XML language dynamically generates under the .NETT framework.

Background technology

When the commercial intelligent processing system of exploitation, except will being provided, Method and kit fors such as various analysis optimization decision trees assist every management decision, also need there be the complete database that includes to connect the form solution that the Report Form Design data are handled functions such as print preview, must the woman and often ignored a back part in current numerous disposal system, in complete business intelligence disposal system one very part and parcel be exactly form solution how to utilize the data of system to define form this paper introduction of working out out all kinds pattern be under the .NET framework, based on XML, the long-range support that provides multiple patterns such as chart (2D 3D) crosstab multidimensional analysis cubes is on the net carried out problems such as data processing inventory design printing thereby solved the connection database preferably.

Summary of the invention

Under a kind of NET framework based on the Web datagram table generating method of XML: mainly formed by four parts;

1. at first be the exchange architecture of form; Its whole Report Engine can be divided into two parts: Report Form Design part and report display part Report Form Design part (Design.time) are traditional window applications, can allow the user design and make a needed form, comprise the selection data source, the design report style, (Run-time) then is web application for report display such as design chart parts, can obtain final data and insert the form that the back forms, and the core of printable Report Engine has adopted the framework based on XML, when designed a form at Design-time after, in fact engine has generated an XML file mouth of describing this report messages when the user watches form, Run-time takes out the XML file of this form and resolves, and reads the information of form; Read the needed data of this form from database then, generate data XML file; Pattern by form generates pattern XML file; At last these two XML files are made up, form a final form.

2. the assembly that relates in the Report Engine design; Owing to be based on the form under the .NET framework, so must need its .NET assembly, then its assembly formation is divided into;

(1) .NET Framework assembly, design is that the .NET Framework that is based upon on the .NET platform is the programming model of .NET platform, being used for making up and running application uses the agreement that is independent of platform (as XML SDAP and HTTP) the .NET Framework of standards to be made up of two major parts with these assemblies of XML web services: CLR and a unified class libraries collection, comprise for the ASP.NETE of web application and XML Web services intoxicated, be used for the Windows forms of smart client application and be used for the ADO.NET. of loose coupling data access

(2) .The XML assembly; The core of whole Report engine is based on XML's.

XML is a kind of SGML of describing type.Its advantage be both can be in this text structured data, also can store unstructured data H therein---that is to say that it can comprise and describe " coarse " document data, just as its describe " regular " list data.All information of form all are stored in the XML document, resolve during for the generation form.

(3). Ofice WebComponent assembly; Chart control in the Report Engine adopts Microsoft Ofice web Component to realize.Microsoft Ofice Web Component is for set from the ActiveX control of electrical form, chart and data processing function to the Web page or leaf that add.

Because OficeWebComponent is programmable fully, thereby in a lot of design environments, all can use these assemblies to set up complicated, mutual and based on the solution of Web.Have three kinds of Ofice Web Component; Spreadsheet assembly, Chart assembly and PivotTable assembly.What the chart control of this paper used is the Chart assembly.After the Chart assembly is placed on user's forms, if can't when design, add data, only need right-click Chart assembly, click " attribute facility case " order in the shortcut menu then, namely can carry out the part to the form of Chart assembly and revise.After the Chart assembly was used in user's forms, all data and the most attribute of a configuration all must arrange by programming.When operation, use the SetData method to come really data to be write the Chart assembly.

(4). the ActiveX assembly; When realizing the printing function of Report Engine, can both printing reports in order to allow each can browse to the client of form, just need to remove to revise the registration table of client with program by webpage, used the ActiveX component technology like this.

The applet of ActiveX control and JAVA is very similar from the teeth outwards, can both allow the network development merchant place some little application programs in their network address, but in fact ActiveX control and JAVA applet have diverse intension.Unique difference of the application program of ActiveX control and other types just is: ActiveX control can not depend on itself and exist.That is to say that the ActiveX control can not be as the direct operation of other application programs, it must be as the part of application program, such as the part as the carrier program of the ActiveX of Web page or leaf or other types.In fact, one of principal character of ActiveX control is that it can join in the application program of supporting COM (The Component Object Model, Component ObjectMode1) easily.ActiveX control is actually in the more additional functions in the basis of OLE control and forms.The same with OLE, ActiveX control is described those parts that can share equally in application program.Different with OLE is that ActiveX control can be shared at Internet.In addition, ActiveX can support the OLE characteristic in network environment.That is to say that in case OLE shares assembly to the application program system of packing into, ActiveX just can allow application program share assembly at Internet so.The developer of Interact still can add ActiveX control at their Web page or leaf.If control is registered in custom system, it will be automatically be presented on user's the Web browser as the part of webpage.If the ActiveX control on the webpage is registered in system, this control will download on the user's computer automatically, and registration also is presented on the webpage automatically automatically.In this respect, ActiveX control is the spitting image of the JAVA application program, and they can both provide the programming content for webpage.ActiveX control and JAVA application program can both be used as the applet of embedded web page.Webpage no longer is restricted to static content.Therefore adopt the ActiveX technology, we can revise the registration table of client by webpage.

3. from database, read data and convert the algorithm of specific format XML document to; Because the data of reading from database are to exist in the Data Table object, and Report Engine needs be one by the corresponding tree construction shape XML object of grouping, therefore need an algorithm realize this conversion.Because the grouping situation is indefinite, sum also can change, so we realize seeking the upward function of some position of the corresponding tree of data by a recursive function Find Node.After all data were all inserted in the corresponding tree node, whole conversion had also just been finished.Be exactly the structure of this algorithm below:

public?XmlNode?FindNode(XmlNode?root，DataRow?dr,int?groupindex)

{if(groupindex==this．_alGroup．Count)

return?root；

string?groupname：this．_alGroup[groupindex]．ToString0；

string?groupvalue=””;

try{

groupvalue=dr[groupname]．ToString0；}

catch{)

foreach{XmlNode?xn?in?root．ChildNodes)

(if(groupvalue==XMLTools．FindAttribute(xn，DataXMLConst．da_Group_GroupValue))

{retum?FindNode(xn，dr,++groupindex)；

}}

XmlNode?node=XMLTools．AddXmlChild(root，groupname)；

XMLTools．AddAttribute(node，DataXMLConst．da_Group_GroupValue，groupvalue)；

retum?FindNode(node，dr,++groupindex)；

4. the use of Report Engine; A newly-built form in report item at first.Its page is divided into two parts, accounting for the most left side is the zone that specifically makes form, and the right is a solution browser (Solution Explorer), be similar to Visual Studio.NET, listed all items in the current solution, and the All Files in the project, select editor for the user.Form is divided into following components:

Report heading (Report Header): the beginning part of form;

Header (Page Header): the header that form is every page:

Form content (Details): the detailed content of form, for example data form etc.:

Report footing (Report Footer): the ending of form;

Footer (Page Footer): the footer that form is every page.

When adding the control of form to design section, only need simply from the tool box (ToolBox) lining to drag the control of wanting and just can to appointed positions

With.Can have following several for the control that form is selected:

Line (Line): the lines in the form, but individualism, also can form form;

Static text (ConstText): changeless literal in the form, as statement heading etc.;

Picture (Image): the picture in the form, as house mark, Logo etc. on the form;

Statistical items (Aggregation): the statistical value in the form, as sum, summation, mean value etc.:

Chart (Chart): the chart in the form, such as histogram, pie chart etc. are generated by actual numerical value.

Each control can be specified its attribute (Property), can set its position, size, font, color, pattern etc. such as text.

Among chart setting and the Office chart arrange closely similar.Select the kind of chart earlier, the chart that Office supports is nearly all support in this Report Engine, as histogram (Column), and bar graph (Bar), line chart (Line), pie chart (Pie), block diagram (Area) etc.After whole form finished, just can be in browser form result through compiling.

Claims (9)

1. Under the NET framework based on the Web datagram table generating method of XML: this method mainly is to utilize under the .NET framework based on XML and utilize the OFFICE assembly and the ACTIVEX control.
2. According under the .NET framework of claim 1 based on the Web datagram table generating method of XML, the method mainly is divided into four parts: the assembly that relates in exchange architecture, the engine design, read data and convert the algorithm of specific format XML document, the use of Report Engine to from database.
3. 3. ask for the exchange architecture of asking in 2 the method major part according to right; It is characterized by: Report Form Design part and report display part; A. Report Form Design part (Design.time) is traditional window application, can allow the user design and make a needed form, comprises the selection data source, design report style, design chart; B. (Run-time) then is web application, can obtain final data and insert the form that the back forms, and printable for report display part.
4. 4. ask for the assembly that relates in the engine design of asking in 2 the method major part according to right; It is characterized by: comprise .NET Framework, XML, office Web Component, ActiveX assembly.
5. 5.a. design is that the .NET Framework that is based upon on the .NET platform is the programming model of .NET platform, is used for making up and runs application using the agreement that is independent of platform (as XML SDAP and HTTP) of standards with these assemblies of XML web services; B XML is a kind of SGML of describing type.
6. 6. all information of form all are stored in the XML document, separate during for the generation form.
7. 7.C. Office Web Component, Microsoft Office Web Component are for set from the ActiveX control of electrical form, chart and data processing function to the Web page or leaf that add.
8. 8.d. one of principal character of ActiveX control is that it can join in the application program of supporting COM (The Component Object Model, Component Object Mode1) easily.
9. 9. ask for according to right and ask from database, reading data and converting the algorithm of specific format XML document in 2 the method major part.