CN106408355A - Method for automatically carrying out formula computing - Google Patents
Method for automatically carrying out formula computing Download PDFInfo
- Publication number
- CN106408355A CN106408355A CN201610978021.XA CN201610978021A CN106408355A CN 106408355 A CN106408355 A CN 106408355A CN 201610978021 A CN201610978021 A CN 201610978021A CN 106408355 A CN106408355 A CN 106408355A
- Authority
- CN
- China
- Prior art keywords
- formula
- carrying
- expression
- defining
- dynamic
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0283—Price estimation or determination
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0605—Supply or demand aggregation
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Game Theory and Decision Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for automatically carrying out formula computing, and belongs to the service algorithm field. The method is characterized by, according to dynamic parameter values, automatically matching formula sections and carrying out corresponding calculating and writing back. The method comprises defining calculating range and expressions of all sections comprising number axis, defining an execution result expression meeting formula conditions, pre-defining variable correspondence relation of a formula expression and the result expression, carrying out system automatic cycle on a numerical interval of a result value and carrying out formula computing automatically. The method comprises the specific implementation steps: defining dynamic indexes; defining formula of the dynamic indexes; carrying out dynamic index and formula computing; and applying the output result to the business logic level for processing. Through flexible policy definition, system data collection and nested price algorithms, the method helps enterprises realize complex settlement pricing procedure.
Description
Technical field
The present invention relates to business algorithmic technique field, specifically a kind of method automatically carrying out formula calculating.
Background technology
With the growth of enterprise, purchase the increase of raw material, supplier increases, and for the buying of raw material, often wants root
According to raw material with the fixed weight of matter price, enterprise needs to carry out the clearing price of complexity.Need exploitation a kind of fixed by flexibly strategy
The Price Algorithm of justice, the purpose data classifying of system and nesting.
Content of the invention
The technical assignment of the present invention is for above weak point, provides a kind of method automatically carrying out formula calculating, leads to
Cross the Price Algorithm of flexible policy definition, the purpose data classifying of system and nesting, help the clearing that enterprise achieves complexity to determine
Valency process.
The technical solution adopted for the present invention to solve the technical problems is：
A kind of method automatically carrying out formula calculating, according to dynamic parameter value, Auto-matching formula is interval, and makes mutually accrued
Calculate and write-back, the method includes defining the scope calculating and comprises all interval expression formulas of number axis, and definition meets formula bar
Implementing result expression formula after part, the variable corresponding relation of predefined formula expression and result expression, system Automatic Cycle
Numerical intervals residing for judged result value, carry out formula calculating automatically；Specific implementation step is：
Define dynamic indicator；
Need to define all of dynamic indicator, by follow-up definition process logic.
Define the formula of dynamic indicator；
Define the detailed Rule of judgment of dynamic indicator, and reach the output formula after this condition；
Identical index can define multirow, represents multiple conditions respectively interval；System can be automatically converted to expression formula, and recorded
In data base.
Dynamic indicator and formula calculate；
Obtain the value of all dynamic variables first,
Then, in formula table, obtain qualified formula row, qualified formula row group match is complete public affairs
Formula,
Again, the actual value of dynamic indicator is replaced the self-defined@of variable@dynamic indicator@,@,
According to sentence formula and dynamic indicator, output result.
By output result, it is used in service logic aspect and processes.
Compared to the prior art a kind of method automatically carrying out formula calculating of the present invention, has the advantages that：
Use towards professional and technical personnel, can be realized in software by this technology, according to dynamic parameter value, Auto-matching
Formula is interval, and makes corresponding calculating and write-back.Be particularly suitable for being carried out according to some index end values the price of material or
The business demand that person reduces.The simplification to complicated business logic can be realized, manually configurable formula algorithm, can make flexibly
Changeable business is easier to adjust, and accomplishes on-demand；
This content effectively increases the data computing capability of enterprise, decreases substantial amounts of workload and puts into, turn avoid people simultaneously
For mistake, create preferable effect.
Specific embodiment
With reference to specific embodiment, the invention will be further described.
A kind of method automatically carrying out formula calculating, according to dynamic parameter value, Auto-matching formula is interval, and makes phase
Should calculate and write-back, the method includes defining the scope calculating and comprises all interval expression formulas of number axis, and definition meets public
Implementing result expression formula after formula condition, the variable corresponding relation of predefined formula expression and result expression, system is automatic
Numerical intervals residing for cycle criterion end value, carry out formula calculating automatically；Specific implementation step is：
Define dynamic indicator；
Need to define all of dynamic indicator, by follow-up definition process logic.
Define the formula of dynamic indicator；
Define the detailed Rule of judgment of dynamic indicator, and reach the output formula after this condition；
Identical index can define multirow, represents multiple conditions respectively interval；System can be automatically converted to expression formula, and recorded
In data base.
Dynamic indicator and formula calculate；
Obtain the value of all dynamic variables first,
Then, in formula table, obtain qualified formula row, qualified formula row group match is complete public affairs
Formula,
Again, the actual value of dynamic indicator is replaced the self-defined@of variable@dynamic indicator@,@,
According to sentence formula and dynamic indicator, output result.
By output result, it is used in service logic aspect and processes.
The present invention is mainly integrated with the matching algorithm of formula data, is realized by allocation list and storing process.
1st, dynamic indicator definition
| Field | Explanation |
| QM_JYXM_NM | Index subjet ISN |
| QM_JYXM_BH | Index subjet is numbered |
| QM_JYXM_MC | Index subjet title |
| QM_JYXM_TY | Not-in-use sign |
Need to define the index of all uses, can support that multi objective meets calculating.
2nd, Index Formula definition
| Field | Explanation |
| QM_KZKJGSDY_MX_JYXM | Index subjet |
| QM_KZKJGSDY_MX_KJFS | Reduce mode |
| QM_KZKJGSDY_MX_ZBJF | Left comparison operators |
| QM_KZKJGSDY_MX_XXZ | Lower limit |
| QM_KZKJGSDY_MX_YBJF | Right comparison operators |
| QM_KZKJGSDY_MX_SXZ | Higher limit |
| QM_KZKJGSDY_MX_JSGS | Computing formula |
Define the formula corresponding to each index and output.
3rd, according to dynamic indicator matching formula, automatically calculated, returning result.
Storing process：ERP_QM_YLJSD_casevalue
| Parameter | Explanation |
| p_ZBBH | Index number |
| p_VALUE | Desired value |
| p_returned | Return success or not |
Storing process：ERP_QM_YLJSD_casevalue
1) the qualified Index Formula set of first-selected taking-up,
insert into #JYJG(kjfs,sqlhz)
select QM_KZKJGSDY_MX_KJFS, QM_KZKJGSDY_MX_SQLHZ from QM_KZKJGSDY_MXwhere
QM_KZKJGSDY_MX_JYXM = @jyxm ；
2) multiple interval formula of an index are combined, form aggregation formulas,
select @kzgs = @kzgs + sqlhz + ' ' from #JYJG；
3) it is that the formula collecting increases grammer prefix and suffix, the variable in replacement formula simultaneously；Comprise：Desired value, output valve
Deng,
@kzgs=' case '+REPLACE (REPLACE (@kzgs, '@index subjet@' ,@value), '@makes by oneself
Adopted@' ,@yz)+' end '
4) according to business logic processing formula algorithm and export.
exec ('update #JYXM set kz = ' + @kzgs + ' where lsbh = ''' + @bdbh +
''' and jyxm = ''' + @jyxm + ''' ')
By specific embodiment above, described those skilled in the art can readily realize the present invention.But should manage
Solution, the present invention is not limited to above-mentioned specific embodiment.On the basis of disclosed embodiment, the skill of described technical field
Art personnel can the different technical characteristic of combination in any, thus realizing different technical schemes.
In addition to technical characteristic described in except description, it is the known technology of those skilled in the art.
Claims (1)
1. a kind of method automatically carrying out formula calculating is it is characterised in that according to dynamic parameter value, Auto-matching formula is interval, and
And make corresponding calculating and write-back, the method includes defining the scope calculating and comprises all interval expression formulas of number axis, fixed
Justice meet formula condition after implementing result expression formula, the variable corresponding relation of predefined formula expression and result expression,
Numerical intervals residing for system Automatic Cycle judged result value, carry out formula calculating automatically；Specific implementation step is：
Define dynamic indicator；
Define the formula of dynamic indicator；
Dynamic indicator and formula calculate；
By output result, it is used in service logic aspect and processes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610978021.XA CN106408355A (en) | 2016-11-08 | 2016-11-08 | Method for automatically carrying out formula computing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610978021.XA CN106408355A (en) | 2016-11-08 | 2016-11-08 | Method for automatically carrying out formula computing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106408355A true CN106408355A (en) | 2017-02-15 |
Family
ID=58015135
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610978021.XA Pending CN106408355A (en) | 2016-11-08 | 2016-11-08 | Method for automatically carrying out formula computing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106408355A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108198066A (en) * | 2017-11-29 | 2018-06-22 | 南京农纷期电子商务有限公司 | A kind of financial industry automates charge system |
-
2016
- 2016-11-08 CN CN201610978021.XA patent/CN106408355A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108198066A (en) * | 2017-11-29 | 2018-06-22 | 南京农纷期电子商务有限公司 | A kind of financial industry automates charge system |
| CN108198066B (en) * | 2017-11-29 | 2021-10-15 | 南京农纷期电子商务有限公司 | Automatic charging system of financial industry |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Malinvaud | Decentralized procedures for planning | |
| Gaballa | Minimum cost allocation of tenders | |
| CN106600356B (en) | Multi-platform e-commerce information aggregation method and system | |
| CN103077070B (en) | Cloud computing management system and management method for cloud computing systems | |
| CN108280538A (en) | Based on distributed logistics inventory's optimization method under cloud computing environment | |
| Sadeghi et al. | A comprehensive method for the centralized resource allocation in DEA | |
| CN106408355A (en) | Method for automatically carrying out formula computing | |
| CN108052542A (en) | A kind of analysis method of the multidimensional data of the data based on presto | |
| Dunn | The equilibrium of land-use patterns in agriculture | |
| Arbabian et al. | Capacity expansions with bundled supplies of attributes: An application to server procurement in cloud computing | |
| Hirapara et al. | A comparative study of data mining techniques for agriculture crop price prediction | |
| CN108433167A (en) | A kind of cigar coating tobacco leaf method for sorting | |
| Zhang | An Approach to Multi-attribute Group Decision Making and Its Application to Project Risk Assessment. | |
| Grygorkiv et al. | Analysis for the National Economies Based on Aggregated Input-Output Models | |
| Li | Research on the application of big data in logistics management | |
| CN109754265A (en) | A kind of data processing method and device | |
| Chen et al. | Research of innovation in Retail based on CiteSpace Knowledge Spectrum | |
| Bowers et al. | Cluster analysis to minimize sequence dependent changeover times | |
| Juliana et al. | Penerapan Metode MOORA Dalam Pemilihan Produk Unggulan Daerah Pada Dinas Ketenagakerjaan dan Perindustrian Kota Binjai | |
| Ruan et al. | The multiple attribute decision model of grey targets based on grey potential degree | |
| Gustavo Paz | The agroecology in dispute: A sight from capital and political economy | |
| Zohoori et al. | Relationship between Cleaner Production, Environmental Management, and Sustainable Product on Performance | |
| Drabenko | VA Drabenko, DV Drabenko | |
| Wang et al. | Research on Integration of PDM and ERP System | |
| Borisova et al. | Application of the Aggregated Approach to the Development of the Strategy of Technical Re-equipment of the Machine and Tractor Fleet of an Agricultural Enterprise |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170215 |
|
| WD01 | Invention patent application deemed withdrawn after publication |