CN105653334B - MIS system rapid development framework based on SAAS mode - Google Patents
MIS system rapid development framework based on SAAS mode Download PDFInfo
- Publication number
- CN105653334B CN105653334B CN201511027295.2A CN201511027295A CN105653334B CN 105653334 B CN105653334 B CN 105653334B CN 201511027295 A CN201511027295 A CN 201511027295A CN 105653334 B CN105653334 B CN 105653334B
- Authority
- CN
- China
- Prior art keywords
- client
- server
- layer
- interface
- realizing
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44521—Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
- G06F9/44526—Plug-ins; Add-ons
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a rapid development framework of an MIS system based on an SAAS mode. The frame includes: the operation framework layer is used for realizing the main interface of the program operation, the management of the plug-in and the loading of basic data; the communication layer is used for realizing the communication between the client and the server; the service application layer is used for realizing the processing of the service and the flow control distribution of the service; the data access layer is used for realizing the access to the database and supporting various databases; and the plug-in interface layer is used for defining a basic interface for the system to run the plug-in. The invention has the characteristics of improving the development efficiency, shortening the development period, reducing the development cost and reducing the development difficulty.
Description
Technical Field
The invention relates to a development platform, in particular to a rapid development framework of an MIS system based on an SAAS mode.
Background
SAAS is Software-as-a-service. The nomenclature of SAAS in the industry is software operation, or soft-camp. The method is an application mode for providing software services based on the Internet. A completely innovative software application mode beginning to rise in the 21 st century with the development of internet technology and the maturity of application software is the latest trend of software technology development. The SAAS provider builds all network infrastructures, software and hardware operation platforms required by informatization for enterprises, and is responsible for a series of services such as implementation in the early stage and maintenance in the later stage, and the enterprises can use the information system through the Internet without purchasing software and hardware, building a machine room and recruiting IT personnel. However, the current development using the SAAS mode mainly has the following disadvantages: when a developer develops each service, the developer usually needs to start from the underlying services such as data communication, database access and the like, so that the workload of developing the service is increased, the development efficiency is reduced, the development difficulty is increased, and the requirement on the skills of the development technicians is correspondingly increased.
Disclosure of Invention
The invention aims to provide a MIS system rapid development framework based on an SAAS mode. The invention has the characteristics of improving the development efficiency, shortening the development period, reducing the development cost and reducing the development difficulty.
The technical scheme of the invention is as follows: MIS system rapid development framework based on SAAS mode, and the framework
The method comprises the following steps:
the operation framework layer is used for realizing the main interface of the program operation, the management of the plug-in and the loading of basic data;
the communication layer is used for realizing the communication between the client and the server;
the service application layer is used for realizing the processing of the service and the flow control distribution of the service;
the data access layer is used for realizing the access to the database and supporting various databases;
and the plug-in interface layer is used for defining a basic interface for the system to run the plug-in.
The MIS system rapid development framework based on the SAAS mode further comprises an interface control layer, and the interface control layer is used for expanding basic controls of a client.
The MIS system rapid development framework based on the SAAS mode works according to the following steps:
a. after loading basic data, the operation framework layer defines a corresponding client plug-in interface through the plug-in interface layer, and the client can be loaded;
b. after the client is loaded, the client accesses the server through the communication layer, and at the moment, the service application layer distributes the access request of the client to the corresponding server;
c. and the server accesses the corresponding database through the data access layer according to the access request of the server, and feeds back the accessed data to the client after the access.
In the aforementioned MIS system rapid development framework based on the SAAS model, the server can access the database of the corresponding type through the corresponding implementation class.
In the aforementioned quick development framework of the MIS system based on the SAAS mode, the client first implements the client interface specification under the plug-in interface layer before being loaded, the generated dynamic library is placed in the plugin directory of the main program, and the client can be automatically loaded when the main program runs.
In the aforementioned quick development framework of the MIS system based on the SAAS mode, when the client accesses the server through the communication layer, the client accesses the server through a static method under the communication layer.
In the aforementioned quick development framework of the MIS system based on the SAAS mode, when the client accesses the server through the static method, the static method operates the server and then returns an information object ServiceMsg.
In the aforementioned quick development framework of the MIS system based on the SAAS mode, when the server is accessed by the client, the server is invoked by the client according to the access request of the client by implementing the server interface specification.
In the aforementioned MIS system rapid development framework based on the SAAS mode, the server accesses the database by using Dao object and DaoTool object under the data access layer.
Compared with the prior art, the client side of the invention firstly realizes the interface specification of the client side before being loaded, the generated dynamic library is put into the plugins directory of the main program, the client side can be automatically loaded when the main program runs, and through the mode, when the developer develops the client side again, the developer does not need to perform bottom development, namely, the developer does not need to perform secondary development on the interface of the plug-in of the client side, and only needs the relation service logic development, thereby improving the development efficiency. Meanwhile, the communication between the client and the server is realized through the Ytclient.dll (namely a communication layer), during the communication, the Ytservice.dll (namely a service application layer) of the server distributes the service to be accessed to the corresponding server, and the server calls the corresponding type of database through the YITian.dll (namely a data access layer) according to the access of the client, so that the client can call the service of the corresponding server at the moment; through the development framework, the bottom layer framework (such as a plug-in interface and database access) required to be developed by a developer at the early stage of developing the business is embedded into the development framework, so that the developer does not need to spend time and energy to repeatedly develop, the development efficiency is effectively improved, and the development period is shortened; moreover, the development difficulty is reduced, developers only need to concentrate on the realization of business logic and do not need to care about the realization of underlying businesses such as data communication, database access and the like, so that the technical requirements of developers are greatly reduced, and the business management system based on the cloud data center can be quickly realized only by the developers being familiar with programming knowledge of performance layers such as WinForm, ASP.
Drawings
FIG. 1 is a system architecture diagram of the present invention.
Detailed Description
The invention is further illustrated by the following figures and examples, which are not to be construed as limiting the invention.
Example 1. A rapid development framework of MIS system based on SAAS model, as shown in fig. 1, the framework includes:
the operation framework layer is a YtMain.dll program set and is used for realizing the management of a main interface and a plug-in unit during the operation of a program and the loading of basic data;
the communication layer, namely a YtClient.dll assembly, is used for realizing the communication between the client and the server;
the service application layer, namely a YtService. dll program set, is used for realizing the processing of the service and the flow control distribution of the service;
a data access layer, namely a YITian.dll assembly, which is used for realizing the access to the database and supporting various databases;
the system comprises a plug-in interface layer, a system operation plug-in interface layer and a database interface layer, wherein the plug-in interface layer is a YtPlugin.dll program set and is used for defining a basic interface for a system to operate a plug-in, and a client interface specification, a server interface specification and a database interface specification are integrated in the plug-in interface layer; the client interface specification is used for realizing the loading of the client by the main program; the server interface specification is used for realizing the communication between the client and the server; the database interface specification is used for realizing the communication between the server and the database.
The rapid development framework further comprises an interface control layer, namely a ytwinContrl. dll program set, wherein the interface control layer is used for realizing the extension of the basic control of the client.
The aforementioned rapid development framework works as follows:
a. after loading basic data, the operation framework layer defines a corresponding client plug-in interface through the plug-in interface layer, so that the client can be loaded, and the client can be loaded by the main program only when the client interface specification is realized;
b. after the client is loaded, the client accesses the server through the communication layer, and at the moment, the service application layer distributes the access request of the client to the corresponding server;
c. the server accesses the corresponding database through the data access layer according to the access request of the server, during access, the server accesses the corresponding database through the corresponding implementation class, and the server feeds back the accessed data to the client after access.
The server can access different types of databases; the types of the database comprise MSSQL, ORACLE, DB2 and the like. During access, the service end accesses the MSSQL database through the MSSQL implementation class, accesses the ORACLE database through the ORACLE implementation class, accesses the DB2 database through the DB2 implementation class, and accesses other corresponding relational databases through other corresponding implementation classes. When the aforementioned implementation class accesses the database, the database interface specification must be implemented. Through the database interface specification, the server side unifies the database interface and the query standard, different databases support unified query grammar, and the various implementation classes are embedded into a rapid development framework, so that a developer does not need to care about different grammars of the different databases, and the difficulty of database development is reduced.
Before the client is loaded, the client interface specification under the plug-in interface layer is realized, the generated dynamic library is put into the plugins directory of the main program, and the client can be automatically loaded when the main program runs. By the method, when the developer develops the client again, the developer does not need to perform bottom development, namely, secondary development is not needed to be performed on the interface of the client plug-in, and the developer only needs to develop the relation business logic, so that rapid development is realized. The dynamic library of the main program comprises YITian.dll, YtClient.dll, YtDict.dll (basic dictionary synchronous library), YtJsEngine.dll (JS script application library), YTMain.dll, YtPlugin.dll, YtSys.dll (system initialization library), YtUtil.dll (public function class library) and YtWinContrl.dll. Each module of the client comprises YITian.dll, YtClient.dll, YtDict.dll, YtPlugin.dll, YtSys.dll, YtUtil.dll and YtWinContrl.dll.
When the client accesses the server through the communication layer, the client accesses the server through a static method under the communication layer. Fast access can be achieved by static methods.
The client accesses the server by the LData, and the LData provides access to the server and comprises query, execution, data saving and the like; some of which are provided by the SvrParam object.
The method of LData object is:
1.DataTable LoadDataTable(string key,params object[]pa)
key corresponds to server configuration ID
Pa is a parameter required by the query
Acquiring the default query interface of the server for querying DataTable of the server as Find
2.DataTable LoadDataTable(string key,string DbConn,params object[]pa)
DbConn data connection
3.string Exe(string key,string DbConn,params object[]pa)
Executing server side query and returning first row and first column
The default inquiry interface of the server is Find
Equivalent to string Es (string key, string DbConn, params object [ ] pa)
Static bolt Do (string key, object > param) executes the server operation
OPT configuration ID of Key server
Param parameter set
Executing the operation of the server, true success, false failure
5.static bool Do(string key,string DbConn,Dictionary<string,object>param)
DbConn data connection
6.static bool Do(SvrParam svr)
Method for executing appointed service end parameter object SvrParam
The ServiceMsg Exe (SvrParam svr) executes the operation to return the server information.
When the client accesses the server through the static method, the static method operates the server and then returns an information object ServiceMsg, namely, the information returned by the server is provided. The running condition of the server can be known in time through the information object ServiceMsg. The ServiceMsg can be a simple data type or a two-dimensional table data set.
The attributes of the ServiceMsg object are:
whether the execution of the pool Success server side is successful or not;
information prompted by a string Msg server;
the method of the ServiceMsg object comprises the following steps:
1.DataTable GetDataTable()
obtaining data returned by the server and converting the data into DataTable
2.DataTable GetDataTable(int index)
Obtaining data returned by the server side according to the parameter index, converting the data into data Table customer service side, and returning a plurality of parameters in an array mode;
3.string GetValue()
obtaining data returned by the server and converting the data into String;
4.string GetValue(int index)
and obtaining data returned by the server side according to the parameter index and converting the data into String.
When the server is accessed by the client, the server needs to realize the server interface specification and can be called by the client according to the access request of the client. Through the interface specification of the unified server, a developer does not need to develop from the interface of the bottom layer when developing services, and only needs to care about the development of service logic, so that the development work is simpler, the development workload is greatly reduced, the development efficiency is improved, and the rapid development is realized.
The parameter object of the client accessing the server is SvrParam;
the instantiation method of the SvrParam object comprises the following steps:
1.SvrParam(string Action,string DbConn)
business object access of implementation IEx of Action access server side comprises namespace and class name
Database access of DbConn access server is normally provided for multi-database access for default connection if database connection of DbConn access server is empty
2.SvrParam(string Action,string DbConn,string sql)
The Sql configures the id of the OPT for the XML of the server or the control classification defined by the Sql is acquired through the Sql attribute of the data of the server.
The method of the SvrParam object is as follows:
SvrParam Add (string k, object obj) Add server parameters
Value corresponding to the parameter name obj corresponding to K
Add parameter in bulk (Dictionary < string, object > a)
SvrParam AddParam (params object [ ] pa) sets the parameters of the implicit query of the server.
The aforementioned server side accesses the database by using Dao object or DaoTool object under the data access layer. The DaoTool is an extension of Dao, and can access the database through a database operation configuration file, such as query, save, update, delete, and the like. The Dao object realizes basic operation on different databases; the DaoTool object provides a series of basic methods for rapidly accessing the database through XML configuration;
the Dao object is instantiated by a method that,
1.Dao(string className,string connStr)
className implementation class, where namespace + assembly name
connStr connection string
2.Dao(string appkey)
The corresponding key of appkey in appConfig is paired with the connection string [ key ] and [ key _ Conn ]
The method of the Dao object is that,
1. return first row and first column of query
object ExecuteScalar(string SelectStr)
Equivalent to object Es (string SelectStr)
object execute scalar (string SelectStr, object [ ] param) with parameter Note that the parameters are uniform in sql "? "number match, such as dao. executive scalar (" select from where id;
equivalent to object Es (string SelectStr, object [ ] param)
2. Returning affected number of rows
int ExecuteNonQuery(string SelectStr)
Equivalent to int En (string SelectStr)
int ExecuteNonQuery (string SelectStr, object [ ] param) with parameters
Equivalent to int En (string SelectStr, object [ ] param)
3. DataTable for returning query
DataTable Find(string SelectStr)
Equivalent to DataTable Fd (string SelectStr)
DataTable Find (string SelectStr, object [ ] param) with parameters
Equivalent to DataTable Fd (string SelectStr, object [ ] param).
The database XML operation configuration is illustrated as follows:
the configuration file for accessing the database is composed of a plurality of operation configurations, wherein the ID of the operation configuration is unique in the whole configuration.
The operation configuration comprises inquiry, addition, update, deletion and the like of data.
The configured xml file may be multiple but must be located under the server's bin \ conxml \ directory, and the operation must be contained in the < ops > node;
the configuration of the query is as follows:
the above configuration is used to execute a query, and the query configuration includes an implicit parameter mode and an explicit parameter mode, such as:
wherein "? "represents the parameter required for query, and the parameter has the AddParam method setting of the SvrParam object at the customer service end, which is the implicit parameter mode query;
such as:
wherein "? "left to right and Pa parameters are set by Add method of SvrParam object of customer service end one by one from top to bottom, which is explicit parameter mode query.
The configuration of the database storage is as follows:
the above-mentioned saved configuration is used for saving data or updating data, where "key" is a primary key of a table, a plurality of primary keys are used "," separated "," table "is a name of the table," Pa "is a field of a corresponding database," name "is a field name of a corresponding database, and" update "is whether to update the field, and the default is true.
The method provided by the DaoTool object is a static method, and the method specifically comprises the following steps:
method for long Seq (Dao, string sequence name) sequence acquisition in general for Oracle database
Int Save (Dao, string key, OptData) saves data by configuring ID, wherein key is the configuration ID operated in XML, and data is the parameter set transmitted from customer service end to service end
int Save (Dao Dao, string key, object > param) is as above, except that the parameters are provided by a Dictionary < string, object > object
Updating database information by configuration ID for int Update (Dao, string key, OptData data)
int Update(Dao dao,string key,Dictionary<string,object>param)
Int ExecuteNonQuery (Dao Dao, string op, OptData data) performs the return of the affected line by configuring the ID
int ExecuteNonQuery(Dao dao,string key,Dictionary<string,object>param)
ObjItem ExecuteScharDao dao, string op, OptData data) performs a return of the head column by configuration ID, and the returned ObjItem object can be converted into other primitive types
ObjItem ExecuteScalar(Dao dao,string key,Dictionary<string,object>param)
Other methods are similar, with major and minor differences returning DataTable and Dictionary < string, object >.
The built-in services in fig. 1 include login, report, and right assignment services.
Claims (6)
1. A MIS system rapid development framework based on SAAS mode is characterized in that the framework comprises:
the operation framework layer is used for realizing the main interface of the program operation, the management of the plug-in and the loading of basic data;
the communication layer is used for realizing the communication between the client and the server;
the service application layer is used for realizing the processing of the service and the flow control distribution of the service;
the data access layer is used for realizing the access to the database and supporting various databases;
the plug-in interface layer is used for defining a basic interface of the system operation plug-in;
the framework also comprises an interface control layer, wherein the interface control layer is used for realizing the expansion of the basic control of the client;
the frame works as follows:
a. after loading basic data, the operation framework layer defines a corresponding client plug-in interface through the plug-in interface layer, and the client can be loaded;
b. after the client is loaded, the client accesses the server through the communication layer, and at the moment, the service application layer distributes the access request of the client to the corresponding server;
c. the server accesses the corresponding database through the data access layer according to the access request of the server, and feeds back the accessed data to the client after the access;
before the client is loaded, the client interface specification under the plug-in interface layer is realized, the generated dynamic library is placed under the plugins directory of the main program, and the client can be automatically loaded when the main program runs.
2. The SAAS-based MIS system rapid development framework of claim 1, wherein: the server can access the database with the corresponding type through the corresponding implementation class.
3. The SAAS-based MIS system rapid development framework of claim 1, wherein: and when the client accesses the server through the communication layer, the client accesses the server through a static method under the communication layer.
4. The SAAS-based MIS system rapid development framework of claim 3, wherein: when the client accesses the server through the static method, the static method returns an information object ServiceMsg after operating the server.
5. The SAAS-based MIS system rapid development framework of claim 1, wherein: when the server is accessed by the client, the server is called by the client according to the access request of the client by realizing the interface specification of the server.
6. The SAAS-based MIS system rapid development framework of claim 1, wherein: the server side accesses the database by using a Dao object and a DaoTool object under a data access layer.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511027295.2A CN105653334B (en) | 2015-12-31 | 2015-12-31 | MIS system rapid development framework based on SAAS mode |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511027295.2A CN105653334B (en) | 2015-12-31 | 2015-12-31 | MIS system rapid development framework based on SAAS mode |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105653334A CN105653334A (en) | 2016-06-08 |
| CN105653334B true CN105653334B (en) | 2020-02-18 |
Family
ID=56490125
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201511027295.2A Active CN105653334B (en) | 2015-12-31 | 2015-12-31 | MIS system rapid development framework based on SAAS mode |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105653334B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110633163B (en) * | 2019-09-26 | 2022-12-09 | 深圳市七星石科技有限公司 | Development method for preventing application program from crashing based on multi-process server |
| CN111399943B (en) * | 2020-03-12 | 2022-11-22 | 网易（杭州）网络有限公司 | Data processing method, device, storage medium and electronic device |
| CN112860346B (en) * | 2021-03-05 | 2023-04-28 | 成都云隆科技有限公司 | Plug-in desktop client system and access method thereof |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103002034A (en) * | 2012-12-03 | 2013-03-27 | 华中科技大学 | Application QoS (Quality of Service) management system based on cloud service bus and operation method thereof |
| CN104866976A (en) * | 2015-06-01 | 2015-08-26 | 北京圆通慧达管理软件开发有限公司 | Multi-tenant-oriented information managing system |
| CN104991760A (en) * | 2014-12-23 | 2015-10-21 | 广州亦云信息技术有限公司 | PaaS platform service management system based on distributed modular technology and realization method |
-
2015
- 2015-12-31 CN CN201511027295.2A patent/CN105653334B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103002034A (en) * | 2012-12-03 | 2013-03-27 | 华中科技大学 | Application QoS (Quality of Service) management system based on cloud service bus and operation method thereof |
| CN104991760A (en) * | 2014-12-23 | 2015-10-21 | 广州亦云信息技术有限公司 | PaaS platform service management system based on distributed modular technology and realization method |
| CN104866976A (en) * | 2015-06-01 | 2015-08-26 | 北京圆通慧达管理软件开发有限公司 | Multi-tenant-oriented information managing system |
Non-Patent Citations (2)
| Title |
|---|
| 基于SaaS平台及通用数据交换的业务协同售后配件管理系统设计与实现;张燕妮;《中国优秀硕士学位论文全文数据库 信息科技辑》;20121031;I138-2124 * |
| 面向SAAS应用的多租户数据管理系统研究与实现;罗日新;《中国优秀硕士学位论文全文数据库 信息科技辑》;20140430;I139-106 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105653334A (en) | 2016-06-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11068245B2 (en) | Containerized deployment of microservices based on monolithic legacy applications | |
| KR102370568B1 (en) | Containerized deployment of microservices based on monolithic legacy applications | |
| JP6113693B2 (en) | Background format optimization for enhanced SQL-like queries in Hadoop | |
| KR101621137B1 (en) | Low latency query engine for apache hadoop | |
| US11061895B2 (en) | Adaptive granule generation for parallel queries with run-time data pruning | |
| US8244780B1 (en) | Parameter oriented automated database command | |
| US20140143284A1 (en) | Zero downtime schema evolution | |
| US20120158453A1 (en) | Workflow processing system for supporting multi-tenant, and method thereof | |
| US11762639B2 (en) | Containerized deployment of microservices based on monolithic legacy applications | |
| CN109408493A (en) | A kind of moving method and system of data source | |
| CN105653334B (en) | MIS system rapid development framework based on SAAS mode | |
| US9063753B2 (en) | Scripting framework for business objects | |
| US20220138195A1 (en) | User defined functions for database query languages based on call-back functions | |
| US9207956B2 (en) | Class loading device for a java runtime environment, cluster system and method of executing a function | |
| US20230004563A1 (en) | Method and system for providing a context-sensitive, non-intrusive data processing optimization framework | |
| US20210182284A1 (en) | System and method for data ingestion and workflow generation | |
| Valkov | Innovative concept of open source enterprise resource planning (erp) system | |
| CN113778642B (en) | Scheduling method and device for network service, intelligent terminal and storage medium | |
| JP7316591B2 (en) | Containerized deployment of microservices based on monolithic legacy applications | |
| JP2023109980A (en) | Containerized deployment of microservices based on monolithic legacy application | |
| WO2023091418A1 (en) | Privacy preserving federated query engine | |
| Harrison et al. | Languages and programming interfaces |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |