CN101261584A - Presentation layer middleware system based on Office document - Google Patents

Presentation layer middleware system based on Office document Download PDF

Info

Publication number
CN101261584A
CN101261584A CNA2008100939620A CN200810093962A CN101261584A CN 101261584 A CN101261584 A CN 101261584A CN A2008100939620 A CNA2008100939620 A CN A2008100939620A CN 200810093962 A CN200810093962 A CN 200810093962A CN 101261584 A CN101261584 A CN 101261584A
Authority
CN
China
Prior art keywords
office
middleware
software
client
presentation layer
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CNA2008100939620A
Other languages
Chinese (zh)
Inventor
谢继承
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
BEIJING KEHAN SOFTWARE Co Ltd
Original Assignee
BEIJING KEHAN SOFTWARE Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by BEIJING KEHAN SOFTWARE Co Ltd filed Critical BEIJING KEHAN SOFTWARE Co Ltd
Priority to CNA2008100939620A priority Critical patent/CN101261584A/en
Publication of CN101261584A publication Critical patent/CN101261584A/en
Pending legal-status Critical Current

Links

Landscapes

  • Stored Programmes (AREA)

Abstract

The invention relates to a presentation layer middleware software system on the basis of the Office document development, which is applied in the software development field. The presentation layer middleware software system makes full use of powerful functions which are provided by the Office software, pioneeringly and directly uses the Office software as a user interface design tool and a user interface presentation tool and further provides an innovative software system presentation layer programming design architecture, so the presentation layer middleware software system is an advanced software system presentation layer rapid development platform proposal which integrates entry, output and design. The presentation layer middleware software system is mainly applied in various management information systems which are based on B/S architecture and C/S structure, thus greatly saving the work loads for the programming development of the presentation layer user interface and providing the entry of user notes, the display of statements and other functions which are more powerful, complicated and flexible to the presentation layer of the system.

Description

A kind of presentation layer middleware system based on the Office document
1, affiliated technical field: software development technique
The present invention relates to a kind of presentation layer middleware software system, be applied to field of software development based on the exploitation of Office document.
2, background of invention:
Along with the continuous development of Internet technology with deeply popularize, present most management information system (MIS), for example: synergetic office work system, electronic government affairs system, e-commerce system, online year check system etc. all are based on the exploitation of B/S framework.Under the B/S framework, client is exactly a browser.What move in the browser is the HTML SGML, for security consideration, client script programming Control ability in the HTML SGML a little less than, can only show some simple form and content of text usually, can't reach demonstration and the edit effect identical with the Office document.In the actual office, use Office software can produce the needed most official documents format of user, electrical form, chart, structural drawing, project figure, PowerPoint etc., these documents have become the working contents of the daily processing of user, also are the most familiar software the most on top of of user.Discover, the Web page with user interactions in the mis system mainly contains the data typing, shows the page of two kinds of function types of output, these two kinds of content of pages and form can be made of Office software, and express more lively directly perceived, and can also directly utilize functions such as Print Preview that Office software carries, printing, so not only can save a large amount of user interface programing work amounts, and the user can easier grasp and accept the user interface of the Office software development be familiar with.But Office software is generally all as the unit running software, even part of O ffice software self can be configured to the network access document, but also can't provide interface freely to control for the software developer as middleware calls, therefore can't be applied in the software development technique.In order to reach above-mentioned Office software application effect, the present invention proposes a complete Technical Architecture and implementation: based on the presentation layer middleware software system of Office document, be not only applicable to the software systems of B/S framework, be applicable to the software systems of C/S framework yet.
3, goal of the invention:
The objective of the invention is at deficiency of the prior art and defective, make full use of the power that Office software provides, ground-breaking Office software directly as user-interface design instrument and user interface presentation instrument, thereby a kind of software systems presentation layer programmed framework of innovation is provided, a kind of advanced person collect and compile into, export, design software systems presentation layer quick development platform scheme in one.
The present invention is mainly used in the various management information system based on B/S framework, C/S framework, a large amount of presentation layer user interface programming development workloads of saving, and provide more powerful, complicated, functions such as the typing of user's bill, report display flexibly for system's presentation layer.
4, summary of the invention:
The present invention is an a kind of middleware software system, for software developer's integration calling, is used for developing the application software towards the final user.
Easy for narrating, the presentation layer middleware software system based on the Office document of the present invention abbreviates middleware system hereinafter as." client software system " hereinafter is meant the software systems of integrated middleware system.The middleware client of mentioning in the literary composition refers to the client part in this middleware system.The Office that mentions in the literary composition refers to the office software that the MS Office of Microsoft commonly used, Kingsoft WPS Office etc. support the OLE technology.Wherein also comprise Visio, Project among the MS of the Microsoft Office.
The system integration among the present invention is meant that the developer is applied to process in the client software system by calling this middle unit development interface with this middleware system.
Middleware system know-why of the present invention is as follows:
Use Office software design software systems user interface content and form, the Office document storing that obtains at server end, the middleware client is by access to netwoks Office document, and corresponding Office software is opened this Office document on the startup client computer, next the middleware client has two kinds of working methods: mode one is logging data, the middleware client reads the program command of server end, but set the editing area in the Office document and forbid editing area, treat the user after but editing area input data are finished, the middleware client is submitted the data of user's input to and is saved in server end; Mode two is output datas, and the middleware client is obtained the server end data and is filled into the specified location of Office document, is used for showing to the user data of specified format.
Powerful editting function itself that utilize Office software to have is made user interface, especially comprises the user interface of bill, form, thereby replaces traditional user interface programmed method.This middleware system directly utilizes Office software as the typing of custom system, the user interface of demonstration, has strengthened the function and the dirigibility of user interface on the one hand greatly, has also saved certain customers' interface programming work on the other hand.
Middleware system framework of the present invention is as follows:
System is divided into server end and two parts of client.The programming personnel mainly reaches the purpose of controlling client Office software by calling the middleware server end interface, so this middleware system server end need not to install Office software.
Server end is to provide for the kit form that programming language calls, for statement conveniently is referred to as server component.The server component basis is called the difference of language, is write by the corresponding programming language that is fit to form.Therefore this middleware system is supported various server software platforms.
The middleware client is a kind of ActiveX control that operates on the Microsoft Windows platform.Adopt the OLE technology to be embedded in Office software in the control window middleware client control, the Office running software is in middleware client control.Middleware client control is embedded in the Web browser page or in the application window by the programming personnel is integrated.
Two kinds of working methods of middleware system of the present invention are as follows:
The logging data working method of this middleware system is: the programming personnel only needs simple invoking server assembly simulation to the control of Office software, the zone that the editing area that needs submission is set and need forbids editing, and set the Office format file that to open, generate a series of call instructions by server component according to calling then to Office software, send to the middleware client, the middleware client is explained and is carried out this group call instruction.The middleware client is the Office user interface document of Download Server end appointment at first, starts corresponding Office software and opens this document, calls the embedded Office software that has started then and carries out this group call instruction.Treat the user after but editing area input data are finished, the middleware client is submitted to the server end server component according to the submission zone that is provided with user input data and control command.The programming personnel obtains data and the control command that the user submits to by the simple calling interface of server component.
The output data working method of this middleware system is: the programming personnel only needs control, the padding data of simple invoking server assembly simulation to Office software, and set the Office user interface document that to open, generate a series of call instructions by server component according to calling then to Office software, send to the middleware client, the middleware client is explained and is carried out this group call instruction.The middleware client is the Office document of Download Server end appointment at first, starts corresponding Office software and opens this document, calls the embedded Office software that has started then and carries out this group call instruction.
" simulation of invoking server assembly is to the control of Office software " mentioned in this literary composition refers to server component simulation Office provides similar automation interface to call for the developer, allow the developer feel just as calling Office software at server end, thereby allow the developer that more energy is placed in the programming of server end service logic.
Middleware system of the present invention is as follows to the meaning of software development:
(1) originally needs the user's input interface and the report display interface of developer's programmed, only need now to use suitable Office software to design, this class work even can give common office administrative personnel and finish.Therefore this middleware system can significantly be saved the software development workload and shorten the construction cycle, and this provides solution for quick exploitation presentation layer.
(2) since the user interface of bill, form by the Office file design, after the client software system pays, the final user can also be according to these Office interface documents of modifications of business demand, thereby easily revise the certain customers interface under the situation that is not recompilating issue client software system.Therefore this middleware system can be protected final user's software investment to greatest extent, has also significantly reduced the developer to the client
The later maintenance cost of software systems.
(3) this middleware system utilizes powerful Office software, can make to show complicated arbitrarily data sheet, chart, can make the bill typing user interface of any complexity, and this is that other imitative Office softwares can't be accomplished at present.
(4) this middleware system adopts server end simulation control Office software, the technology of middleware client working control Office software, make server end not limited by operating system restriction, the restriction of web server platform, web programming language, realized that the Java technology platform also can freely control the technical goal of the Office of Microsoft software.
(5) this middleware system provides the total solution of typing, output and the design of presentation layer, therefore possesses the characteristics of software platform.
5, embodiment
Below in conjunction with the present invention's application in practice, provide examples of implementation that the present invention is carried out simple declaration.With the Excel in the Office software is example, and concrete implementation process is as follows:
Suppose that service logic is: the user needs the typing sales order, statistical service person's accumulative total sales volume; Suppose that the client software system is based on the system of B/S framework, Web server is Tom Cat, and that dynamic page adopts is JSP.The embodiment of typing sales order:
(1) opens Excel software, a newly-built Excel document.Make a bill that is used for the typing sales order according to the form of user's appointment, preserve and copy under the virtual directory of Web server.
(2) the newly-built sales order typing JSP page, in server-side code, call the server component of this middleware, setting middleware document to be opened is sales order Excel document, and the commit unit the edited lattice in the document are set, and other cell zones of document are set to forbid editor.In client code, quote the client control of this middleware.
(3) newly-built sales order data are preserved the JSP page, and the server component that calls this middleware in server-side code obtains the data of user's typing, then data is saved in database.
(4) user moves the client software system, opens this sales order webpage and can finish data typing work.
The embodiment of statistical service person's accumulative total sales volume:
(1) opens Excel software, a newly-built Excel document.Make a form that is used for display business person's accumulative total sales volume according to the form of user's appointment, preserve and copy under the virtual directory of Web server.
(2) the newly-built statistical report form JSP page, in server-side code, call the server component of this middleware, setting middleware document to be opened is form Excel document, obtain the data of statistical report form by Query Database, the cell of appointment in the report documents given the digital simulation assignment by the invoking server assembly.In client code, quote the client control of this middleware.
(3) user moves the client software system, and opening this statistical report form webpage can display business person's accumulative total sales volume form.
The summary of the invention that the middleware function of how detailed complexity, logic please refer to this patent is described.

Claims (7)

1, a kind of presentation layer middleware software system based on the Office document, a kind of software systems presentation layer programmed framework of innovation is provided, a kind of advanced person's software systems presentation layer quick development platform scheme, it is characterized in that, use Office software design software systems user interface content and form, the Office document storing that obtains at server end, the middleware client is by access to netwoks Office document, and corresponding Office software is opened this Office document on the startup client computer, next the middleware client has two kinds of working methods: mode one is logging data, the middleware client reads the program command of server end, but set the editing area in the Office document and forbid editing area, treat the user after but editing area input data are finished, the middleware client is submitted the data of user's input to and is saved in server end; Mode two is output datas, the middleware client is obtained the server end data and is filled into the specified location of Office document, be used for showing the data of specified format to the user, the middleware client of mentioning in this literary composition refers to the client part in this presentation layer middleware software system, " simulation of invoking server assembly is to the control of Office software " mentioned in this literary composition refers to server component simulation Office provides similar automation interface to call for the developer, allow the developer feel just as calling Office software at server end, thereby allow the developer that more energy is placed in the programming of server end service logic.
2, being characterized as based on the Office document of presentation layer middleware system according to claim 1: powerful editting function itself that utilize Office software to have is made user interface, especially comprise bill, the user interface of form, thereby replace traditional user interface programmed method, this middleware system directly utilizes the typing of Office software as custom system, the user interface that shows, the function and the dirigibility of user interface have been strengthened on the one hand greatly, also saved certain customers' interface programming work on the other hand, the Office that mentions in this literary composition refers to the MS Office of Microsoft commonly used, Kingsoft WPS Office etc. support the office software of OLE technology.Wherein also comprise Visio, Pro ject among the MS of the Microsoft Office.
3, the architectural features of presentation layer middleware system according to claim 1 is: system is divided into server end and two parts of client, the programming personnel mainly reaches the purpose of controlling client Office software by calling the middleware server end interface, so this middleware system server end need not to install Office software.
4, the server end of presentation layer middleware system according to claim 1 is characterized as: server end is to provide for the kit form that programming language calls, for statement conveniently is referred to as server component, server component is according to the difference of calling language, write by the corresponding programming language that is fit to and to form, so this middleware system is supported various server software platforms.
5, the client features of presentation layer middleware system according to claim 1 is: the middleware client is a kind of ActiveX control that operates on the Microsoft Windows platform, in middleware client control, adopt the OLE technology to be embedded in Office software at the control window, the Office running software is in middleware client control, and middleware client control is embedded in the Web browser page or in the application window by the programming personnel is integrated.
6, the logging data working method of presentation layer middleware system according to claim 1 is characterized as: the programming personnel only needs the control of simple invoking server assembly simulation to Office software, the zone that needs the editing area of submitting to and need forbid editing is set, and set the Office format file that to open, generate a series of call instructions by server component according to calling then to Office software, send to the middleware client, the middleware client is explained and is carried out this group call instruction, the middleware client is the Office user interface document of Download Server end appointment at first, start corresponding Office software and open this document, call the embedded Office software that has started then and carry out this group call instruction, treat that the user is after but editing area input data are finished, the middleware client is submitted to the server end server component according to the submission zone that is provided with user input data and control command, and the programming personnel obtains data and the control command that the user submits to by the simple calling interface of server component.
7, the output data working method of presentation layer middleware system according to claim 1 is characterized as: the programming personnel only needs the control of simple invoking server assembly simulation to Office software, padding data, and set the Office user interface document that to open, generate a series of call instructions by server component according to calling then to Office software, send to the middleware client, the middleware client is explained and is carried out this group call instruction, the middleware client is the Office document of Download Server end appointment at first, start corresponding Office software and open this document, call the embedded Office software that has started then and carry out this group call instruction.
CNA2008100939620A 2008-04-24 2008-04-24 Presentation layer middleware system based on Office document Pending CN101261584A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNA2008100939620A CN101261584A (en) 2008-04-24 2008-04-24 Presentation layer middleware system based on Office document

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNA2008100939620A CN101261584A (en) 2008-04-24 2008-04-24 Presentation layer middleware system based on Office document

Publications (1)

Publication Number Publication Date
CN101261584A true CN101261584A (en) 2008-09-10

Family

ID=39962056

Family Applications (1)

Application Number Title Priority Date Filing Date
CNA2008100939620A Pending CN101261584A (en) 2008-04-24 2008-04-24 Presentation layer middleware system based on Office document

Country Status (1)

Country Link
CN (1) CN101261584A (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102043769A (en) * 2010-12-27 2011-05-04 畅捷通软件有限公司 Method and device for editing documents
CN102137060A (en) * 2010-01-21 2011-07-27 金蝶软件(中国)有限公司 Method and device for processing events under client/server model
CN102629222A (en) * 2011-11-28 2012-08-08 江苏奇异点网络有限公司 Editable-document self-adaptive backup method based on type definability
CN103034488A (en) * 2012-12-03 2013-04-10 深圳市浩科电子有限公司 User interface generation method
CN103309678A (en) * 2013-07-01 2013-09-18 汇丰软件开发(广东)有限公司 Method for processing data in combined environment of IBM mainframe
CN104572040A (en) * 2013-10-15 2015-04-29 镇江雅迅软件有限责任公司 On-line text processing method based on JSP and ActiveX control
CN107977389A (en) * 2016-10-25 2018-05-01 航天信息软件技术有限公司 Method for processing report data based on browser
CN112269671A (en) * 2020-11-14 2021-01-26 江西金格科技股份有限公司 Method for using Office programming interface in webpage

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102137060A (en) * 2010-01-21 2011-07-27 金蝶软件(中国)有限公司 Method and device for processing events under client/server model
CN102137060B (en) * 2010-01-21 2013-08-21 金蝶软件(中国)有限公司 Method and device for processing events under client/server model
CN102043769A (en) * 2010-12-27 2011-05-04 畅捷通软件有限公司 Method and device for editing documents
CN102629222A (en) * 2011-11-28 2012-08-08 江苏奇异点网络有限公司 Editable-document self-adaptive backup method based on type definability
CN103034488A (en) * 2012-12-03 2013-04-10 深圳市浩科电子有限公司 User interface generation method
CN103034488B (en) * 2012-12-03 2016-08-03 深圳市浩科电子有限公司 User interface creating method
CN103309678A (en) * 2013-07-01 2013-09-18 汇丰软件开发(广东)有限公司 Method for processing data in combined environment of IBM mainframe
CN103309678B (en) * 2013-07-01 2016-06-15 汇丰软件开发(广东)有限公司 A kind of data processing method in the mixed structure environment of the big-and-middle-sized machine of IBM
CN104572040A (en) * 2013-10-15 2015-04-29 镇江雅迅软件有限责任公司 On-line text processing method based on JSP and ActiveX control
CN107977389A (en) * 2016-10-25 2018-05-01 航天信息软件技术有限公司 Method for processing report data based on browser
CN112269671A (en) * 2020-11-14 2021-01-26 江西金格科技股份有限公司 Method for using Office programming interface in webpage
CN112269671B (en) * 2020-11-14 2023-07-07 江西金格科技有限公司 Method for using Office programming interface in webpage

Similar Documents

Publication Publication Date Title
CN101261584A (en) Presentation layer middleware system based on Office document
CN103383645B (en) Code generating method and system
CN100487645C (en) Automatically generating method based on data driving interface
US8020103B2 (en) Using templates for ensuring visual consistency among portlets
CN101135989A (en) Automatization test method and device for Web applied system
CN110069246A (en) The plateform system and its application that a kind of Java Web application is quickly developed
KR101275871B1 (en) System and method for producing homepage in SaaS ENVIRONMENT, A computer-readable storage medium therefor
JP2006260390A (en) Test case generating program and method
WO2003036472A9 (en) Internationalization of computer programs employing graphical user interface
CN107329748A (en) API development managements method and system and server and computer-readable recording medium
US7689903B2 (en) Unified markup language processing
US7636912B2 (en) Custom assembly to extend a wizard
US20120179711A1 (en) System and Method for Accessing a Database Including Data Abstraction Layer and Request Table Processing
Wagner Professional flash mobile development: Creating android and iphone applications
Cysneiros et al. Traceability and completeness checking for agent-oriented systems
CA2696406A1 (en) System, device and method for providing interactive content on an computing device
CN111736833A (en) Method and system for generating popup component, electronic device and storage medium
Freudenstein et al. A workflow-driven approach for the efficient integration of web services in portals
Xiang et al. Web portal and markup language for collaborative environmental research
US20050076329A1 (en) Method and apparatus for supporting configuration of a web application in a web presentation architecture
Wiriyakul et al. A visual editor for language-independent scripting for BPMN modeling
McGregor Attached Processes.
Fritsch et al. Four mechanisms for adaptable systems: A meta-level approach to building a software product line
KR20220122246A (en) System and method for producing homepage in SaaS ENVIRONMENT
US20090157763A1 (en) Content validation system and method

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
DD01 Delivery of document by public notice

Addressee: Beijing Kehan Software Co., Ltd.

Document name: Notification of before Expiration of Request of Examination as to Substance

DD01 Delivery of document by public notice

Addressee: Xu Tianping

Document name: Notification that Application Deemed to be Withdrawn

C02 Deemed withdrawal of patent application after publication (patent law 2001)
WD01 Invention patent application deemed withdrawn after publication

Open date: 20080910