CN112307018A - Method for storing unit price data of mine excavation engineering - Google Patents
Method for storing unit price data of mine excavation engineering Download PDFInfo
- Publication number
- CN112307018A CN112307018A CN202011045305.6A CN202011045305A CN112307018A CN 112307018 A CN112307018 A CN 112307018A CN 202011045305 A CN202011045305 A CN 202011045305A CN 112307018 A CN112307018 A CN 112307018A
- Authority
- CN
- China
- Prior art keywords
- unit price
- price
- type
- parameter
- specific value
- 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
- 238000009412 basement excavation Methods 0.000 title claims abstract description 18
- 238000000034 method Methods 0.000 title claims abstract description 15
- 230000014509 gene expression Effects 0.000 claims abstract description 19
- 238000013500 data storage Methods 0.000 claims abstract description 5
- 230000001419 dependent effect Effects 0.000 claims abstract description 4
- 238000012423 maintenance Methods 0.000 abstract description 6
- 238000004364 calculation method Methods 0.000 abstract description 5
- 230000005641 tunneling Effects 0.000 description 3
- 238000005065 mining Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
Images
Classifications
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/02—Agriculture; Fishing; Forestry; Mining
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Development Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- Finance (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Game Theory and Decision Science (AREA)
- Life Sciences & Earth Sciences (AREA)
- Agronomy & Crop Science (AREA)
- Animal Husbandry (AREA)
- Marine Sciences & Fisheries (AREA)
- Mining & Mineral Resources (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for storing unit price data of a mine excavation project, which is used for solving the problems that the unit price types of the mine excavation project are multiple and the processing by a computer is difficult. Specifically, the method comprises the following steps: the price is classified according to the calculation form of unit price, the price is directly stored and output without relation to the parameter, and the specific price is further calculated by the function expression with relation to the price and the parameter. The invoicing mode is thus no longer program dependent, but only function expressions. The invention establishes a mine excavation project unit price system with a data storage structure characterized by stepped prices, provides a basis for an excavation project price system management program and an excavation project management program, and greatly improves the maintenance efficiency of the price system and the project settlement work efficiency.
Description
Technical Field
The invention relates to a method for storing engineering unit price data.
Background
The unit price system of the mine excavation project is complex, and the unit price system has unit price types related to technical parameters and unit price types unrelated to the technical parameters. In the project unit prices related to the technical parameters, a sectional pricing mode is mostly adopted, for example, the tunneling unit price is related to the section area, and different unit prices are adopted in different section area ranges.
The conventional unit price management method is to combine a project name and corresponding parameters into a project name, such as 'tunneling (cross-sectional area 6-8)', unit price is 105.43 yuan/t, so that the problems caused by the fact that unit price items are numerous, a unit price system is unstable, unit price maintenance is difficult, unit price selection in project accounting is inefficient, the effect of the parameters in the unit price system cannot be fully utilized, system efficiency is poor, the intelligent degree is high, and errors are prone to occurring.
Disclosure of Invention
The invention provides a method for storing unit price data of mine excavation engineering, which aims to: the maintenance of a unit price system in the excavation project and the selection and calculation of unit prices in the excavation project accounting are simplified, and the working efficiency is improved.
The technical scheme of the invention is as follows:
a method for storing unit price data of mine excavation engineering comprises the following steps:
step 1, dividing excavation engineering articles into two types: type A with unit price independent of technical parameters, type B with unit price dependent on technical parameters;
step 2, uniformly coding the type A and the type B, and storing the type A and the type B in a database table X, wherein the unit price of the type A is a specific value, and the unit price of the type B is a preset specific value;
and 3, storing a unit price model with the piecewise function characteristics of the type B in a database table Y, wherein the unit price model comprises the following fields:
(1) point to the uniform coded foreign key in database table X;
(2) a piecewise function expression;
(3) a parameter starting point of the function expression;
(4) parameter end points of the function expression.
As a further improvement of the invention: when inquiring the price, firstly selecting an article from a database table X; if the unit price of the article in the data table is not a preset specific value, directly outputting the price inquired in the data table X; if the unit price of the article in the data table is a preset specific value, prompting to further input a parameter value, and substituting the parameter value into a corresponding function expression in the data table Y to calculate the unit price.
As a further improvement of the invention: the preset specific value is-1.
Compared with the prior art, the invention has the following beneficial effects: the method designs a data storage structure for storing the unit price storage and calculation method of the mining engineering, which is characterized by stepped price, and classifies the unit price according to the calculation form of the unit price, and directly stores and outputs the price irrelevant to the price and the parameter, and calculates the specific price through a function expression for the price relevant to the parameter, so that the pricing mode is not relevant to the program any more and is only relevant to the function expression, thereby simplifying the entry and calculation process of the price, reducing the maintenance workload and greatly improving the working efficiency.
Drawings
FIG. 1 is a flow chart of the method.
Detailed Description
The technical scheme of the invention is explained in detail in the following with the accompanying drawings:
as shown in fig. 1, a method for storing unit price data of mining engineering includes the steps:
step 1, dividing excavation engineering articles into two types: type A with unit price independent of technical parameters, type B with unit price dependent on technical parameters;
step 2, uniformly coding the type A and the type B, and storing the type A and the type B in a database table X, wherein the unit price of the type A is a specific value, and the unit price of the type B is a preset specific value which is-1 in the embodiment;
step 3, establishing a database table Y, wherein the database table Y is called a sub-table of the database table X; saving a univalent model with piecewise-functional features of type B in a database table Y, the univalent model comprising the following fields:
(1) point to the uniform coded foreign key in database table X;
(2) a piecewise function expression;
(3) a parameter starting point of the function expression;
(4) parameter end points of the function expression.
For example, at the maintenance interface of the "Specification sublist" (database table Y), the following model is entered:
(1) the unit price of the tunneling project with the cross section area of less than 6 square meters is 109.85 yuan/cubic meter.
(2) The parameter x of the trackless transport equipment is the distance, the expression '10.25 + (x-1000)/500 x 2.85' indicates that when the distance is larger than 1000m, the unit price is increased by 2.85 yuan/t every time the distance is increased by 500m, and the transport symbol '/' indicates integer division operation. By this expression, the number of segments charged for a segment can be simplified.
When inquiring the price, firstly selecting an article from a database table X; if the unit price of the article in the data table is not a preset specific value, directly outputting the price inquired in the data table X; if the unit price of the article in the data table is a preset specific value, the system intelligently matches an applicable unit price expression, prompts further input of a parameter value, substitutes the parameter value into a corresponding function expression in the data table Y, and automatically calculates the unit price without selecting a specific unit price by a user.
In the maintenance process, the sectional pricing mode of the type B can be adjusted at will, the application program automatically adapts, and the program code does not need to be modified.
Claims (3)
1. A mine excavation project unit price data storage method is characterized by comprising the following steps:
step 1, dividing excavation engineering articles into two types: type A with unit price independent of technical parameters, type B with unit price dependent on technical parameters;
step 2, uniformly coding the type A and the type B, and storing the type A and the type B in a database table X, wherein the unit price of the type A is a specific value, and the unit price of the type B is a preset specific value;
and 3, storing a unit price model with the piecewise function characteristics of the type B in a database table Y, wherein the unit price model comprises the following fields:
(1) point to the uniform coded foreign key in database table X;
(2) a piecewise function expression;
(3) a parameter starting point of the function expression;
(4) parameter end points of the function expression.
2. The mine excavation project unit price data storage method according to claim 1, characterized in that: when inquiring the price, firstly selecting an article from a database table X; if the unit price of the article in the data table is not a preset specific value, directly outputting the price inquired in the data table X; if the unit price of the article in the data table is a preset specific value, prompting to further input a parameter value, and substituting the parameter value into a corresponding function expression in the data table Y to calculate the unit price.
3. The mine excavation project unit price data storage method according to claim 1 or 2, characterized in that: the preset specific value is-1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011045305.6A CN112307018A (en) | 2020-09-29 | 2020-09-29 | Method for storing unit price data of mine excavation engineering |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011045305.6A CN112307018A (en) | 2020-09-29 | 2020-09-29 | Method for storing unit price data of mine excavation engineering |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112307018A true CN112307018A (en) | 2021-02-02 |
Family
ID=74488178
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011045305.6A Pending CN112307018A (en) | 2020-09-29 | 2020-09-29 | Method for storing unit price data of mine excavation engineering |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112307018A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103366288A (en) * | 2012-03-28 | 2013-10-23 | 上海商派网络科技有限公司 | Distribution cost calculation method of online sales |
| CN105069727A (en) * | 2015-07-18 | 2015-11-18 | 深圳市前海安测信息技术有限公司 | Medicine automatic delivery method based on electronic prescription in O2O mode and network hospital platform |
| CN105139222A (en) * | 2015-07-30 | 2015-12-09 | 武汉大学 | Self adaptive electric vehicle charging service rate floating calculation system and method |
| CN107292653A (en) * | 2016-04-12 | 2017-10-24 | 北京京东尚科信息技术有限公司 | One kind retail warehoused cargo calculation of price method and device |
| CN110533389A (en) * | 2019-08-27 | 2019-12-03 | 中交水运规划设计院有限公司 | The determination method and device of Project Cost |
| KR20200004183A (en) * | 2018-07-03 | 2020-01-13 | 주식회사 데이타솔루션 | Systema and method for predicting price using article search |
-
2020
- 2020-09-29 CN CN202011045305.6A patent/CN112307018A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103366288A (en) * | 2012-03-28 | 2013-10-23 | 上海商派网络科技有限公司 | Distribution cost calculation method of online sales |
| CN105069727A (en) * | 2015-07-18 | 2015-11-18 | 深圳市前海安测信息技术有限公司 | Medicine automatic delivery method based on electronic prescription in O2O mode and network hospital platform |
| CN105139222A (en) * | 2015-07-30 | 2015-12-09 | 武汉大学 | Self adaptive electric vehicle charging service rate floating calculation system and method |
| CN107292653A (en) * | 2016-04-12 | 2017-10-24 | 北京京东尚科信息技术有限公司 | One kind retail warehoused cargo calculation of price method and device |
| KR20200004183A (en) * | 2018-07-03 | 2020-01-13 | 주식회사 데이타솔루션 | Systema and method for predicting price using article search |
| CN110533389A (en) * | 2019-08-27 | 2019-12-03 | 中交水运规划设计院有限公司 | The determination method and device of Project Cost |
Non-Patent Citations (1)
| Title |
|---|
| 王建国等: "《计算机科学与技术导论》", 31 March 2012 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111612412B (en) | Intelligent processing method device and system for reinforcing steel bar | |
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN104268428A (en) | Visual configuration method for index calculation | |
| CN102708249B (en) | Method and system for product modular configuration | |
| CN112036953A (en) | Power transmission and transformation project cost calculation system and cost calculation method based on three-dimensional model | |
| CN107067170A (en) | A kind of cost accounting and quotation system based on assembling decomposition texture | |
| CN111861247A (en) | Building engineering construction scheme comparison and selection method based on carbon emission | |
| CN104679858A (en) | Method and device for inquiring data | |
| CN115203290A (en) | Fault diagnosis method based on multi-dimensional prefix span algorithm | |
| CN112307018A (en) | Method for storing unit price data of mine excavation engineering | |
| CN110909408A (en) | Revit + Dynamo-based curb modeling method | |
| CN114239960A (en) | Distribution network project group progress management method and system based on dynamic resource optimization | |
| CN110486261A (en) | Air-compressor set mixing system and method based on multipoint pressure trajectory predictions | |
| CN106168793A (en) | A kind of method automatically generating control equipment and system | |
| Federgruen et al. | Fast solution and detection of minimal forecast horizons in dynamic programs with a single indicator of the future: applications to dynamic lot-sizing models | |
| CN111782820A (en) | Knowledge graph creating method and device, readable storage medium and electronic equipment | |
| CN112396332B (en) | Data synchronization method, device, equipment and medium based on multi-vehicle type part change | |
| Zhao et al. | Modeling and analysis of a mixed‐model assembly line with stochastic operation times | |
| CN102270111A (en) | Command decoding method and command set simulation device | |
| CN115307810A (en) | Temperature compensation method and device of temperature and pressure sensor | |
| CN110532597B (en) | Air compressor set adjusting and assembling system and method based on pressure track prediction and time nodes | |
| CN114168653A (en) | Power utilization data processing method, device, equipment and storage medium | |
| CN108270548A (en) | A kind of method of discrimination of Grain types stream cipher | |
| CN107133281A (en) | A kind of packet-based global multi-query optimization method | |
| CN101477370A (en) | Manufacturing system production schedule extraction method based on complex network |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210202 |