CN110298631A - A kind of Construction of Civil Engineering Project Cost management system - Google Patents
A kind of Construction of Civil Engineering Project Cost management system Download PDFInfo
- Publication number
- CN110298631A CN110298631A CN201910571467.4A CN201910571467A CN110298631A CN 110298631 A CN110298631 A CN 110298631A CN 201910571467 A CN201910571467 A CN 201910571467A CN 110298631 A CN110298631 A CN 110298631A
- Authority
- CN
- China
- Prior art keywords
- user
- management
- information
- materials
- plan
- 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
- 238000010276 construction Methods 0.000 title claims abstract description 23
- 238000007726 management method Methods 0.000 claims abstract description 190
- 238000003860 storage Methods 0.000 claims abstract description 79
- 238000000034 method Methods 0.000 claims abstract description 37
- 230000008569 process Effects 0.000 claims abstract description 13
- 238000013500 data storage Methods 0.000 claims abstract description 4
- 238000012550 audit Methods 0.000 claims description 34
- 238000012790 confirmation Methods 0.000 claims description 8
- 238000013439 planning Methods 0.000 claims description 8
- 238000013461 design Methods 0.000 claims description 6
- 238000004519 manufacturing process Methods 0.000 claims description 5
- 238000012545 processing Methods 0.000 claims description 4
- 238000000151 deposition Methods 0.000 claims description 3
- 230000002452 interceptive effect Effects 0.000 claims description 3
- 230000008520 organization Effects 0.000 claims description 3
- 238000012423 maintenance Methods 0.000 claims description 2
- 238000012546 transfer Methods 0.000 claims description 2
- 238000004321 preservation Methods 0.000 claims 2
- 238000009435 building construction Methods 0.000 claims 1
- 238000007689 inspection Methods 0.000 claims 1
- 230000000875 corresponding effect Effects 0.000 description 13
- 238000005516 engineering process Methods 0.000 description 5
- 238000011161 development Methods 0.000 description 3
- 230000004913 activation Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
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/24—Querying
-
- 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/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- 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/0201—Market modelling; Market analysis; Collecting market data
- G06Q30/0206—Price or cost determination based on market factors
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/08—Construction
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Finance (AREA)
- General Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- Tourism & Hospitality (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Computational Linguistics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Game Theory and Decision Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides a kind of Construction of Civil Engineering Project Cost management systems, and using C/S three-decker and system database, three-decker includes: user's access layer；Using logical layer；And data storage layer；The system database is used to provide basis for system operation and ensure, including database entity and database table.Construction of Civil Engineering Project Cost management system includes six functional modules: 1) module for managing files, including archives kind management, archives and information management, archives dictionary management；2) plan management of materials and quipment module, application, examination & approval and inquiry operation including plan；3) contract management module；4) storehouse management module: storage, outbound process for goods and materials, early warning and ledger management including inventory；5) system management module, including division management, user management, rights management, Role Management；6) decision-making management module is managed report and safeguards, provides data foundation for decision.
Description
Technical field
The present invention relates to a kind of management system technical field, especially a kind of Construction of Civil Engineering Project Cost management system
System.
Background technique
With the fast development of real estate, civil engineering enterprise has obtained unprecedented opportunity to develop, all kinds of engineerings
The number of entry is continuously increased, and the development of informationization technology simultaneously, so that traditional Construction of Civil Engineering Project Cost manages work
It becomes increasingly complex, it is desirable that higher and higher.It is competing between enterprise along with the arrival of global integration and networked information era
It strives and is growing more intense, seize the market share one after another, but it is less to operating cost concern, and in engineering project, enterprise is often paid close attention to
The innovation of bidding quotation and technical aspect has ignored the handling of goods and materials for playing basic role, especially to purchase of goods and materials and makes
Control, and the starting point of enterprise's production and project cost is exactly the correlated activation of goods and materials, the good management of goods and materials can
To reduce purchase cost to greatest extent, it is ensured that enterprise obtains rich profit.
With the fast development of modern science level, the research that computer technology is extended further into, however for object
There are no certain computer technologies for money management aspect to implement the management to material information, to comprehensively manage building work
The Project Cost of journey.
Summary of the invention
To overcome the shortcomings of existing technologies, it is an object of the invention to existing civil engineering work enterprise construction item
On the basis of mesh cost management present situation is analyzed, solve to exist in management at present using advanced computer and network technologies
Deficiency, form more reasonable new departure.
The purpose of the present invention is to provide a kind of Construction of Civil Engineering Project Cost management systems, using C/S three-decker
And system database, the three-decker include:
User's access layer, for providing interactive interface, each secondary unit, supplier, Materials Company, function portion for user
Room passes through user's access layer login system and operates；
Using logical layer, for each functional module and business in processing system, including file administration, contract management,
Storehouse management, planning management, while the middleware communicated with bottom being also provided, as TAM safety certification, technique act on behalf library
Interface, workflow engine；And
Data storage layer, for being stored and processed to all data information in system, to improve the number of system
According to treatment effeciency and the speed of service；
The system database is used to provide basis for system operation and ensure, all data informations all save in system
In the database, including database entity and database table, in which:
1) database entity includes:
Plan monocular entity: the entity is used to store all attributes relevant to goods and materials plan monocular, is specifically included
Attribute has monocular serial number, and material information applies for quantity, unit price and unit；
Plan only head entity: the entity for store it is all with plan only relevant attribute, specifically included
The planned odd numbers of attribute, plan odd numbers title, applicant, date of application, reason for the request, auditor audit the date, supplier,
Apply for arrival date, total amount；
Contract monocular entity: the entity is for storing all attributes relevant to contract monocular, the attribute for specifically being included
There are monocular serial number, material information, monocular quantity, unit price, unit and purposes；
Contract list entity: the entity is all with contract simple correlation attribute for storing, and the attribute for specifically being included has conjunction
With number, contract title, source mode, source-information, the contract term, the means of payment, Signed at signs people, signs day
Phase, auditor audit date and total amount；
Material storage account single head entity: the entity is used to store all attributes relevant to material storage account single head,
The attribute for specifically being included has materiel code, material information, stockpile number and total amount；
Be put in storage single head entity out: the entity is used to store all attributes relevant to storage single head is gone out, and is specifically included
Attribute there is any discrepancy library odd numbers enters and leaves classification, send library or receive, send library or receive the date, send library or receive reason, source, storehouse
Keeping, auditor audit date and total amount；
Be put in storage monocular entity out: the entity is used to store all attributes relevant to storage monocular is gone out, and is specifically included
Attribute is by monocular serial number, material information, monocular quantity, unit price, unit and purposes；
Goods and materials project file entity: the entity is specifically wrapped for storing all attributes relevant to goods and materials project file
The attribute contained has materiel code, goods and materials title, phonetic code, specifications and models, unit, purposes, inventory's lower limit and inventory's upper limit；
Material storage account monocular entity: the entity is used to store all attributes relevant to material storage account monocular,
The attribute for specifically being included has sequence number, material information, unit price, unit, manufacturer, the date of production, asset number and outbound
Odd numbers.
2) database table is for determining that the specific storage organization of database obtains the physics of database by physical Design
Structure, comprising:
Plan monocular table, monocular serial number is the unique identification of the table；
Only head table, plan odd numbers are the unique identification of the table for plan；
Contract monocular table, the unique identification of the monocular serial number table；
Contract list table, contract number are the unique identification of the table；
Material storage account single head table, materiel code are the unique identification of the table；
It is put in storage single head table out, is put in storage the unique identification that odd numbers is the table out；
It is put in storage monocular table, the unique identification of the monocular serial number table out；
Goods and materials project file table, materiel code are the unique identification of the table；
Material storage account monocular table, the unique identification of the Serial No. table.
Preferably, the Construction of Civil Engineering Project Cost management system includes six functional modules:
1) module for managing files: for information relevant to cost to be formed archives and by module for managing files progress
It manages and maintains, including archives kind management, archives and information management, archives dictionary management can by archives kind management
Classify to files of materials and equipment, and carries out the setting and management of classification；By archives and information management, cost can be related to
Goods and materials essential information is managed and safeguards；By archives dictionary management, cost archives can be quickly found out and carry out archives letter
The inquiry of breath；
2) plan management of materials and quipment module: buying and use to goods and materials formulate corresponding plan in advance and pass through goods and materials meter
Management module is drawn to be managed and safeguard, in plan management of materials and quipment module, application, examination & approval and inquiry behaviour including plan
Make, inventory managers need to input the application information of goods and materials plan in systems, then examined by company leader, only
Having can be just performed by the plan of examination & approval, and by planning query function, user enters the goods and materials meter that system searching wants to know about
Draw information；
3) contract management module: after making procurement contract for purchase of goods and materials personnel, being entered into system, is handed over
The audit of contract is carried out by company leader, only could formally be implemented by the procurement plan of audit, in addition, other users
System can be entered to inquire all contract informations；
4) storehouse management module: storage, outbound process for goods and materials, early warning and ledger management including inventory；
5) system management module: the relevant information in system is configured and is safeguarded for system manager.In target
In system, system management module includes division management, user management, rights management, Role Management function, by division management,
Can department's information to enterprise safeguard；By user management, all user basic informations in system can be carried out
Maintenance；By rights management, the operating right of users all in system can be configured；It, can be right by Role Management
The corresponding role of all users is configured in system；
6) decision-making management module: in goal systems, to the buying of goods and materials, storage, outbound, using, scrap work and be related to
It is managed and safeguards to corresponding all kinds of reports, the statistics and inquiry of data are carried out according to report content, to mention for decision
For data foundation.
Preferably, the cost archive management method of the module for managing files are as follows:
(1) after user enters cost module for managing files, new material base letter is inputted in files of materials and equipment administration page
Breath clicks save button, and system can obtain the information of user's input automatically, and carry out non-empty verifying to it, if it exists null value,
Then user is prompted to re-enter；
(2) null value if it does not exist, system will continue to identify cargo number and verify, if there are identical volumes in system
Number, then it prompts user to re-enter, if identical number is not present in system, the upper and lower limits of material storage is tested
The case where card, the upper limit is less than lower limit if it exists, then user is prompted to re-enter；
(3) if the upper limit of confirmation goods and materials is greater than lower limit, system fills the information that the page obtains into goods and materials entity class,
And save the material information that user inputs to background data base table, so far operation terminates.
Preferably, the goods and materials plan application method of the plan management of materials and quipment module includes:
(1) after user enters plan management of materials and quipment module, purchasing plan of materials and equipment is inputted in the goods and materials plan application page
Number, system can obtain the number of user's input automatically and verify at this time, be identically numbered, mention if existing in system
Show that user re-enters；
(2) if identical procurement program number is not present in system, user continues to input procurement plan according to page prompts
Date of application essential information, then input procurement plan material category, goods and materials name information, it is also necessary to input this and adopt
The reason of purchase plan, the procurement method of this procurement plan is then selected in drop-down list, completes the input of all information
Afterwards, submitting button is clicked；
(3) system can prompt the user whether that confirmation is submitted at this time, if user's selection is no, operation terminates, if user selects
It is that system obtains the procurement plan information in the page and is submitted in background data base table, is audited for company leader.
Preferably, the goods and materials plan checking method of the plan management of materials and quipment module includes:
(1) after user logs in plan management of materials and quipment module, into procurement plan original list, as needed most from list
Selection needs the procurement plan audited eventually, and system can find the corresponding number of the procurement plan into background data base at this time, if
The number is not found, then prompts user to re-enter；
(2) if finding the procurement program number, system jumps directly to the detailed audit page of the procurement plan, user
After going through plan application information, according to the audit opinion of application content input procurement plan, submitting button, system are clicked
It can prompt the user whether confirmation msu message, if user's selection is no, operation terminates；
(3) it if user's selection is that the audit opinion that user inputs is saved in background data base by system, so far operates
Terminate.
Preferably, the procurement contract management method of the contract management module includes:
(1) after user enters contract management module, the number of procurement contract is inputted in the contract management page, is at this time
System can obtain the number of user's input automatically and carry out repeated authentication to it, if prompting user there are identical number in system
It re-enters；
(2) if user continues to input procurement plan information, contract according to page prompts there is no number is repeated in system
Essential information, contract terms and payment information, and by the invoice type of drop-down list selection contract, while also to input conjunction
Same handler's information；
(3) after all information inputs, user clicks save button, and whether system prompt user saves conjunction at this time
Together, if user's selection is no, operation terminates, if user's selection is, system continues to carry out non-empty verifying to all information, if depositing
It is empty phenomenon in required item, then prompts user to re-enter, if it does not exist nonempty entry, then obtain page procurement plan information
It saves into background data base, and is committed to system audit, so far all operations terminate.
Preferably, the warehouse basic information management method of the storehouse management module includes:
(1) after user enters storehouse management module, warehouse classification is selected in the warehouse basic information management page, at this time
System can verify the classification that user chooses, if the category is not present in system, the warehouse classification that user inputs is added
It is added in system；
(2) if user selects to obtain the presence of warehouse classification, user continues to input the title in warehouse, and system also can be to this at this time
Title carries out repeated authentication, if the title in the warehouse title and database repeats, user is prompted to re-enter；
(3) if the warehouse title is not repeated with the title in system, user continues to input warehouse location and contact method letter
Breath, clicks save button after completing the input of information, system obtains page info automatically and fills into warehouse entity, then adjusts
Warehouse information is saved into background data base with service logic layer method, and so far all operations terminate.
Preferably, the materials warehousing management process of the storehouse management module includes:
(1) after user enters storehouse management module, the buying for selecting this to be put in storage in materials warehousing administration page is ordered
Single, the purchase order that system can be selected according to user at this time obtains the corresponding material information of the order, while traversing goods and materials list
The state for checking each goods and materials, if there are unqualified phenomenon, end operations for goods and materials；
(2) if the goods and materials are qualified, material information is stored in interim storage set, while verifying whether end time
It goes through, if traversal is not finished, reexamines goods and materials state, if traversal terminates, fill in the essential information of storage bill, simultaneously will
Material information in page info and storage set is saved into database, and so far all operations terminate.
Preferably, the method for managing system of the system management module includes:
(1) after user enters system management module, department's information described in user is selected in the system administration page, this
When system can to user select information verify, the information, then select role-security belonging to user if it does not exist, and
Reselect user's affiliated department information；
(2) if the information village exists, continuing the number for inputting user, system can verify Customs Assigned Number at this time, if
It is repeated with existing in system, then prompts user to re-enter, if not repeating with the number in system, continue to select user institute
The role-security of category；
(3) system can carry out repeated authentication to the role-security belonging to user, repeat if it exists, then prompt user again
Selection, repeats if it does not exist, then inputs other essential informations of address name, after the input for completing all information, clicks to save and press
Button, system can obtain Page user information automatically and be saved into background data base, and so far all operations terminate.
Preferably, the Data Statistics Inquiry Through method of the decision-making management module includes:
(1) after user enters decision-making management module, the data for currently needing to count are selected in the Data Statistics Inquiry Through page
Classification, the classification that system can be selected according to user at this time load the corresponding statistics page；
(2) after loading the statistics page, user can click inquiry button according to the condition of statistics classification input statistics,
System can obtain the statistical condition of user's input automatically, and the splicing of SQL query statement be carried out to condition, while calling data
The method of access layer executes SQL statement；
(3) after completing inquiry operation, system judge statistical query result whether be it is empty, if result is sky, operate knot
Beam, if query result is not sky, the result of statistical query is back to page layer by system, and statistical result is tied to number by the page
According in control, checked for user.
Beneficial effects of the present invention:
For civil engineering work enterprise provide a set of function comparatively perfect and have good stability, scalability, easily
The Information Management System of operability, effectively meets the current project cost work requirements of enterprise, by goal systems in reality
From the point of view of operating status and operational efficiency in the business of border, the Engineering Cost Management to civil engineering work enterprise is brought really
Very big convenience, while effective specification also has been carried out to Construction of Civil Engineering Cost Management business.By new management system with
Current network environment and software and hardware facilities combines, make the Project Cost management system of engineering construction enterprise more rationally, section
It learns and advanced, to the storages of engineering materials all in enterprise, the links such as to transport, allot, distribute and use carry out whole
Management and monitoring, so that it is more unobstructed so that the engineering material of each department is circulated, to reducing, project cost performance is highly important
Effect.
According to the following detailed description of specific embodiments of the present invention in conjunction with the accompanying drawings, those skilled in the art will be more
The above and other objects, advantages and features of the present invention is illustrated.
Detailed description of the invention
Some specific implementations of the invention are described in detail by way of example and not limitation with reference to the accompanying drawings hereinafter
Example.Identical appended drawing reference denotes same or similar part or part in attached drawing.It should be appreciated by those skilled in the art that
The drawings are not necessarily drawn to scale.Target and feature of the invention will more in view of following description taken together with the accompanying drawings
Obviously, in attached drawing:
Attached drawing 1 is the system logic architecture figure according to the embodiment of the present invention；
Attached drawing 2 is the system function module structure chart according to the embodiment of the present invention；
Attached drawing 3 is the cost file administration flow chart according to the embodiment of the present invention；
Attached drawing 4 is the goods and materials plan application flow chart according to the embodiment of the present invention；
Attached drawing 5 is the goods and materials plan auditing flow figure according to the embodiment of the present invention；
Attached drawing 6 is the procurement contract management flow chart according to the embodiment of the present invention；
Attached drawing 7 is the warehouse basic information management flow chart according to the embodiment of the present invention；
Attached drawing 8 is the materials warehousing management flow chart according to the embodiment of the present invention；
Attached drawing 9 is the system administration flow chart according to the embodiment of the present invention；
Attached drawing 10 is the Data Statistics Inquiry Through flow chart according to the embodiment of the present invention；
Attached drawing 11 is to be schemed according to the E-R of the inventory management business of the embodiment of the present invention.
Specific embodiment
The Construction of Civil Engineering Project Cost management system of the present embodiment, using C/S three-decker, C/S framework and BS machine
Structure is framework mode relatively common at present, is referred to as Fat Client mode and thin client mode, the former is primarily due to
All program files are all mounted on the machine of client, so that client and its suffered pressure are greater than server end, institute
Some operations are all operation to be executed by the program in client, and the latter is then that program file is stored in server, institute
Some operations require to be handled by server-side, therefore the pressure of server end is then bigger than client.
The advantages of high reliability framework based on C/S includes:
(1) since under C/S model, the file and business operation of program are handled by client, right in this way
The pressure of remote server is just corresponding to reduce many, to ensure that the stability of remote server；
(2) range of application system usually its application of C/S model exploitation is relatively fixed, and such application software is all pair
Specific business or specific user group, therefore its all correlation comparison is limited, this is to the peace in system operation
Full property, which has, preferably to be ensured；
(3) it is all located in client, is owned using the most program file of application system that C/S model is developed
Operation be essentially all to be executed by client machine, interacted in this way with long-range server it is relatively fewer, to guarantee program
The efficiency of operation, so as to develop the application system of many complicated business requirements.
The system of the present embodiment is designed using C/S three-decker, as shown in Figure 1, comprising:
User's access layer, predominantly user provide interactive interface, each secondary unit, supplier, Materials Company, function portion
Room passes through user's access layer login system and operates；
Using logical layer, each functional module and business in main processing system, including file administration, contract management,
Storehouse management, planning management etc., while the middleware communicated with bottom being also provided, as TAM safety certification, technique are acted on behalf
Bank interface, workflow engine etc.；
Data storage layer mainly stores and processs all data information in system, to improve the number of system
According to treatment effeciency and the speed of service.
The system combination software development technique and data base management system of the present embodiment, for system particular demands pipe
The project cost for managing enterprise, the Cost Management for being conducive to improve enterprise are horizontal.As shown in Fig. 2, mainly including six function moulds
Block:
1, module for managing files
In Cost Management work, all information relevant to cost can form archives and by file administration mould
Block is managed and safeguards, including archives kind management, archives and information management, archives dictionary management etc..Pass through archives kind pipe
Reason, can classify to files of materials and equipment, and carry out the setting and management of classification；It, can be to cost by archives and information management
The goods and materials essential information being related to is managed and safeguards；By archives dictionary management, cost archives can be quickly found out and carried out
The inquiry of archive information.
Referring to Fig. 3, cost file administration flow chart is as shown in figure 3, specific implementation flow is described as follows:
(1) after user enters cost module for managing files, new material base letter is inputted in files of materials and equipment administration page
Breath clicks save button, and system can obtain the information of user's input automatically, and carry out non-empty verifying to it, if it exists null value,
Then user is prompted to re-enter；
(2) null value if it does not exist, system will continue to identify cargo number and verify, if there are identical volumes in system
Number, then it prompts user to re-enter, if identical number is not present in system, the upper and lower limits of material storage is tested
The case where card, the upper limit is less than lower limit if it exists, then user is prompted to re-enter；
(3) if the upper limit of confirmation goods and materials is greater than lower limit, system fills the information that the page obtains into goods and materials entity class,
And save the material information that user inputs to background data base table, so far operation terminates.
2, plan management of materials and quipment module
The buying of either goods and materials still uses, and requires to formulate corresponding plan in advance, these plan informations are ok
It is managed and safeguards by plan management of materials and quipment module.In plan management of materials and quipment module, the main application including plan,
Examination & approval and inquiry operation, inventory managers need to input the application information of goods and materials plan in systems, are then led by company
It leads and is examined, only can be just performed by the plan of examination & approval.By planning query function, user can look into system
Look for the goods and materials plan information wanted to know about.
Goods and materials plan application process is as shown in figure 4, specific implementation flow is described as follows:
(1) after user enters plan management of materials and quipment module, purchasing plan of materials and equipment is inputted in the goods and materials plan application page
Number, system can obtain the number of user's input automatically and verify at this time, be identically numbered, mention if existing in system
Show that user re-enters；
(2) if identical procurement program number is not present in system, user continues to input procurement plan according to page prompts
The essential informations such as date of application, then input the material category of procurement plan, the information such as goods and materials title, it is also necessary to input this
Then the reason of secondary procurement plan, selects the procurement method of this procurement plan in drop-down list, complete the defeated of all information
After entering, submitting button is clicked；
(3) system can prompt the user whether that confirmation is submitted at this time, if user's selection is no, operation terminates, if user selects
It is that system obtains the procurement plan information in the page and is submitted in background data base table, is audited for company leader.
Goods and materials plan auditing flow is as shown in figure 5, specific implementation flow is described as follows:
(1) after user logs in plan management of materials and quipment module, into procurement plan original list, as needed most from list
Selection needs the procurement plan audited eventually, and system can find the corresponding number of the procurement plan into background data base at this time, if
The number is not found, then prompts user to re-enter；
(2) if finding the procurement program number, system jumps directly to the detailed audit page of the procurement plan, user
After going through plan application information, according to the audit opinion of application content input procurement plan, submitting button, system are clicked
It can prompt the user whether confirmation msu message, if user's selection is no, operation terminates；
(3) it if user's selection is that the audit opinion that user inputs is saved in background data base by system, so far operates
Terminate.
3, contract management module
After requisition plan for materials and equipment is by audit, so that it may set about carrying out purchase of goods and materials, need at this time and material supply quotient
Sign the procurement contract of goods and materials.After purchase of goods and materials personnel make procurement contract, it is entered into system, transfers to company
The audit of carry out contract is led, only could formally be implemented by the procurement plan of audit, in addition, other users can also pass through
System inquires all contract informations.
Procurement contract management process is as shown in fig. 6, specific implementation flow is described as follows:
(1) after user enters contract management module, the number of procurement contract is inputted in the contract management page, is at this time
System can obtain the number of user's input automatically and carry out repeated authentication to it, if prompting user there are identical number in system
It re-enters；
(2) if user continues to input procurement plan information, contract according to page prompts there is no number is repeated in system
Essential information, contract terms and payment information, and by the invoice type of drop-down list selection contract, while also to input conjunction
Same handler's information；
(3) after all information inputs, user clicks save button, and whether system prompt user saves conjunction at this time
Together, if user's selection is no, operation terminates, if user's selection is, system continues to carry out non-empty verifying to all information, if depositing
It is empty phenomenon in required item, then prompts user to re-enter, if it does not exist nonempty entry, then obtain page procurement plan information
It saves into background data base, and is committed to system audit, so far all operations terminate.
4, storehouse management module
Since the material information that cost is related to all is stored in warehouse, storehouse management module is extremely important.Goods and materials
Processes, the early warning and ledger management including inventory etc. such as storage, outbound can be operated by storehouse management module.
Warehouse basic information management process is as shown in fig. 7, specific implementation flow is described as follows:
(1) after user enters storehouse management module, warehouse classification is selected in the warehouse basic information management page, at this time
System can verify the classification that user chooses, if the category is not present in system, the warehouse classification that user inputs is added
It is added in system；
(2) if user selects to obtain the presence of warehouse classification, user continues to input the title in warehouse, and system also can be to this at this time
Title carries out repeated authentication, if the title in the warehouse title and database repeats, user is prompted to re-enter；
(3) if the warehouse title is not repeated with the title in system, user continues to input warehouse location and contact method etc.
Information clicks save button after completing the input of information, and system obtains page info automatically and fills into warehouse entity, then
Service logic layer method is called to save warehouse information into background data base, so far all operations terminate.
Materials warehousing management process is as shown in figure 8, specific implementation flow is described as follows:
(1) after user enters storehouse management module, the buying for selecting this to be put in storage in materials warehousing administration page is ordered
Single, the purchase order that system can be selected according to user at this time obtains the corresponding material information of the order, while traversing goods and materials list
The state for checking each goods and materials, if there are unqualified phenomenon, end operations for goods and materials；
(2) if the goods and materials are qualified, material information is stored in interim storage set, while verifying whether end time
It goes through, if traversal is not finished, reexamines goods and materials state, if traversal terminates, fill in the essential information of storage bill, simultaneously will
Material information in page info and storage set is saved into database, and so far all operations terminate.
5, system management module
System management module is configured and safeguards to the relevant information in system for system manager.In target system
In system, system management module mainly includes the functions such as division management, user management, rights management, Role Management, passes through department
Management, can department's information to enterprise safeguard；By user management, all users in system can be believed substantially
Breath is safeguarded；By rights management, the operating right of users all in system can be configured；By Role Management,
The corresponding role of users all in system can be configured.
System administration process is as shown in figure 9, specific implementation flow is described as follows:
(1) after user enters system management module, department's information described in user is selected in the system administration page, this
When system can to user select information verify, the information, then select role-security belonging to user if it does not exist, and
Reselect user's affiliated department information；
(2) if the information village exists, continuing the number for inputting user, system can verify Customs Assigned Number at this time, if
It is repeated with existing in system, then prompts user to re-enter, if not repeating with the number in system, continue to select user institute
The role-security of category；
(3) system can carry out repeated authentication to the role-security belonging to user, repeat if it exists, then prompt user again
Selection, repeats if it does not exist, then inputs other essential informations such as address name, after the input for completing all information, clicks and saves
Button, system can obtain Page user information automatically and be saved into background data base, and so far all operations terminate.
6, decision-making management module
In goal systems, the buyings of goods and materials, storage, outbound, using, the work such as scrap and can all be related to corresponding report
Table preferably could provide data foundation by managing and maintaining to these reports for decision.Therefore, decision pipe ability mould
The groundwork of block is exactly to be managed to all kinds of reports in system and attended operation, is then counted according to report content
According to statistics and inquiry.
Data Statistics Inquiry Through process is as shown in Figure 10, and specific implementation flow is described as follows:
(1) after user enters decision-making management module, the data for currently needing to count are selected in the Data Statistics Inquiry Through page
Classification, the classification that system can be selected according to user at this time load the corresponding statistics page；
(2) after loading the statistics page, user can click inquiry button according to the condition of statistics classification input statistics,
System can obtain the statistical condition of user's input automatically, and the splicing of SQL query statement be carried out to condition, while calling data
The method of access layer executes SQL statement；
(3) after completing inquiry operation, system judge statistical query result whether be it is empty, if result is sky, operate knot
Beam, if query result is not sky, the result of statistical query is back to page layer by system, and statistical result is tied to number by the page
According in control, checked for user.
7, system database
System database provides basis and ensures for program operation, and all data informations are all stored in database in system
In, database design work influences the storage and processing efficiency of data information very big.It mainly include database entity sum number
According to library table.
(1) database entity includes:
Plan monocular entity: the entity is mainly used for storing all attributes relevant to goods and materials plan monocular, is specifically wrapped
The attribute contained has monocular serial number, and material information applies for quantity, unit price and unit；
Plan only head entity: the entity be mainly used for storing it is all with plan only relevant attribute, specifically wrapped
The planned odd numbers of the attribute contained plans odd numbers title, applicant, date of application, reason for the request, auditor, audit date, confession
Quotient is answered, applies for arrival date, total amount；
Contract monocular entity: the entity is mainly used for storing all attributes relevant to contract monocular, is specifically included
Attribute has monocular serial number, material information, monocular quantity, unit price, unit and purposes；
Contract list entity: the entity is mainly used for storing all with contract simple correlation attribute, attribute for specifically being included
There is contract number, contract title, source mode, source-information, the contract term, the means of payment, Signed at is signed people, signed
Date, auditor audit date and total amount；
Material storage account single head entity: the entity is mainly used for storing all relevant to material storage account single head
Attribute, the attribute for specifically being included have materiel code, material information, stockpile number and total amount；
Be put in storage single head entity out: the entity is mainly used for storing all attributes relevant to storage single head is gone out, and is specifically wrapped
The attribute contained there is any discrepancy library odd numbers enters and leaves classification, send library or receive, send library or receive the date, send library or receive reason, source,
Storehouse keeping, auditor audit date and total amount；
Be put in storage monocular entity out: the entity is mainly used for storing all attributes relevant to storage monocular is gone out, and is specifically wrapped
The attribute contained is by monocular serial number, material information, monocular quantity, unit price, unit and purposes；
Goods and materials project file entity: the entity is mainly used for storing all attributes relevant to goods and materials project file, specifically
The attribute for being included has a materiel code, goods and materials title, phonetic code, specifications and models, unit, purposes, on inventory's lower limit and inventory
Limit；
Material storage account monocular entity: the entity is mainly used for storing all relevant to material storage account monocular
Attribute, the attribute for specifically being included have sequence number, material information, unit price, unit, manufacturer, the date of production, asset number
With outbound odd numbers.
Since there are relevances between most of business in systems, can also equally exist between entities this
Relationship, if the E-R of inventory management business in the present embodiment schemes, as shown in figure 11.
(2) database table
Database table is essentially atabase Physical Design, and the main specific storage organization for determining database passes through physics
Design, obtains the physical structure of database, to provide necessary data supporting, the physical Design of database for system operation
It is directly linked with the DBMS of specific choice.
1) plan monocular table, specific structure as shown in table 1 below, all information relevant to goods and materials plan monocular in system
It all saves in the table, in numerous fields, monocular serial number is the unique identification of the table.
Table 1 plans monocular table
| Chinese Fields | English field | Data type | Width | Whether major key |
| Monocular serial number | DM_DMXH | Vanchar | 10 | Yes |
| Material information | DM_WZXX | Varehar | 50 | No |
| Apply for quantity | DM_SQSL | Int | No | |
| Unit price | DM_DJ | Money | No | |
| Unit | DM_DW | Varehar | 10 | No |
2) plan only head table: as shown in table 2, all in system only relevant information is all stored in this to plan
In table, in numerous fields, plan odd numbers is the unique identification of the table.
Table 2 plans only head table
| Chinese Fields | English field | Data type | Width | Whether major key |
| Plan odd numbers | DT_JHDH | Varehar | 10 | Yes |
| Plan odd numbers claims | DT_JHDMC | Varehar | 20 | No |
| Applicant | DT_SQR | Varehar | 10 | No |
| Date of application | DT_SQRQ | DateTime | No | |
| Reason for the request | DT_SQYY | Varehar | 50 | No |
| Auditor | DT_SHR | Varehar | 10 | No |
| Audit the date | DT_SHRQ | DateTime | No | |
| Supplier | DT_GYS | Varehar | 10 | No |
| Apply for arrival date | DT_SQDHRQ | DateTime | No | |
| Total amount | DT_ZJE | Money | No |
3) contract monocular table
Specific structure is as shown in table 3, and all information relevant to contract monocular are all stored in the table in system, numerous
In field, the unique identification of the monocular serial number table.
3 contract monocular table of table
| Chinese Fields | English field | Data type | Width | Whether major key |
| Monocular serial number | HT_DMXH | Varehar | 10 | Yes |
| Material information | HT_WZXX | Varehar | 50 | No |
| Monocular quantity | HT_DMSL | Int | No | |
| Unit price | HT_DJ | Money | No | |
| Unit | HT_DW | Varehar | 20 | No |
| Purposes | HT_YT | Varehar | 50 | No |
4) contract list table
Contract list table specific structure is as shown in table 4, and all essential informations relevant to contract are all stored in the table in system
In, in numerous fields, contract number is the unique identification of the table 4.
4 contract list table of table
| Chinese Fields | English field | Data type | Width | Whether major key |
| Contract coding | HTD_HTBH | Varehar | 10 | Yes |
| Contract title | HTD_HTMC | Varehar | 10 | No |
| Source mode | HTD_LYFS | Int | No | |
| Contract term | HTD_HTQX | Int | No | |
| The means of payment | HTD_ZFFS | Int | No | |
| Signed at | HTD_QDDD | Varehar | 50 | No |
| Sign people | HTD_QDR | Varehar | 10 | No |
| The date | HTD_QDRQ | DateTime | No | |
| Auditor | HTD_SHR | Varehar | 10 | No |
| Audit the date | The core date _ SHRQ | DateTime | No | |
| Total amount | HTD_ZJE | MOney | No |
5) material storage account single head table
The specific structure of material storage account single head table is as shown in table 5, all relevant to material storage account in system
Information all saves and the table, and in numerous fields, materiel code is the unique identification of the table.
5 material storage account single head table of table
| Chinese Fields | English field | Data type | Width | Whether major key |
| Materiel code | TZ_WZBM | Varehar | 10 | Yes |
| Material information | TZ_WZXX | Varehar | 50 | No |
| Stockpile number | TZ_KCSL | Int | No | |
| Total amount | TZ_ZJE | Money | No |
6) go out storage single head table
The specific structure for being put in storage single head table out is as shown in table 6, and all information relevant to storage goods and materials are gone out all are protected in system
It is stored in the table.In numerous fields, it is put in storage the unique identification that odd numbers is the table out.
Table 6 goes out to be put in storage single head table
| Chinese Fields | English field | Data type | Width | Whether major key |
| It is put in storage odd numbers out | KDT_CRKDH | varehar | 10 | Yes |
| Enter and leave classification | KDT_CRLB | Int | No | |
| It send library or receives | KDT_SKLY | Int | No | |
| It send library or receives the date | KDT_RQ | DateTime | No | |
| It send library or receives reason | KDT_YY | varehar | 20 | No |
| Source | KDT_LY | Int | No | |
| Storehouse keeping | KDT_KFBG | Varehar | 10 | No |
| Auditor | KDT_SHR | Varehar | 10 | No |
| Audit the date | KDT_SHRQ | DateTime | No | |
| Total amount | KDT_ZJE | Money | No |
7) go out storage monocular table
The specific structure for being put in storage monocular table out is as shown in table 7, all in system to go out the relevant information of storage monocular with goods and materials
It is all stored in the table, in numerous fields, the unique identification of the monocular serial number table.
Table 7 goes out to be put in storage monocular table
| Chinese Fields | English field | Data type | Width | Whether major key |
| Monocular serial number | KDM_DMXH | Varehar | 10 | Yes |
| Goods and materials serial number | KDM_WZXX | Varehar | 50 | No |
| Monocular quantity | KDM_DMSL | Int | No | |
| Unit price | KDM_DJ | Money | No | |
| Unit | KDM_DW | Varehar | 20 | No |
| Purposes | KDM_YT | Varehar | 20 | No |
8) goods and materials project file table
The specific structure of goods and materials project file table is as shown in table 8, all information relevant to goods and materials project file in system
It all saves in the table, in numerous fields, materiel code is the unique identification of the table.
8 goods and materials project file table of table
| Chinese Fields | English field | Data type | Width | Whether major key |
| Materiel code | DA_WZBM | Varehar | 10 | Yes |
| Goods and materials title | DA_WZMC | Varehar | 10 | No |
| Phonetic code | DA_PYM | Varehar | 10 | No |
| Specifications and models | DA_GGXH | Varehar | 20 | No |
| Unit | DA_DW | Varehar | 20 | No |
| Purposes | DA_YT | Varehar | 20 | No |
| Inventory's lower limit | DA_KCXX | Int | No | |
| On inventory | DA_KCSX | Int | No |
9) material storage account monocular table
Material storage account monocular table structure is as shown in table 9, all letters relevant to material storage account monocular in system
Breath is all stored in the table.In numerous fields, the unique identification of the Serial No. table.
9 material storage account monocular table of table
| Chinese Fields | English field | Data type | Width | Whether major key |
| Sequence serial number | ZDM_XLH | Varchar | 10 | Yes |
| Material information | ZDM_WZXX | Varchar | 50 | No |
| Unit price | ZDM_DJ | Money | No | |
| Unit | ZDM_DW | Varchar | 20 | No |
| Manufacturer | ZDM_CCCJ | Varchar | 20 | No |
| The date of production | ZDM_CCRQ | DateTime | No | |
| Asset number | ZDM_ZCBH | Varchar | 10 | No |
| Outbound is only number | ZDM_CKDDH | Varchar | 10 | No |
The embodiment system provides a set of function comparatively perfect for civil engineering work enterprise and has good stablize
Property, scalability, the Information Management System of ease for operation, effectively meet the current project cost work requirements of enterprise, lead to
It crosses from the point of view of operating status and operational efficiency of the goal systems in practical business, gives the work of civil engineering work enterprise really
Journey Cost Management brings very big convenience, while also having carried out effective specification to Construction of Civil Engineering Cost Management business.
Although the present invention is described by reference to specific illustrative embodiments, these implementations are not will receive
Example restriction and only limited by accessory claim.It should be understood by those skilled in the art that can be without departing from this hair
Change and modification are able to carry out to the embodiment of the present invention in the case where bright protection scope and spirit.
Claims (10)
1. a kind of Construction of Civil Engineering Project Cost management system, it is characterised in that: use C/S three-decker and system data
Library, the three-decker include:
User's access layer, for providing interactive interface for user, each secondary unit, supplier, Materials Company, function portion room pass through
User's access layer login system simultaneously operates；
Using logical layer, for each functional module and business in processing system, including file administration, contract management, warehouse
Management, planning management, while the middleware communicated with bottom being also provided；And
Data storage layer, for being stored and processed to all data information in system, at the data to improve system
Manage efficiency and the speed of service；
The system database is used to provide basis for system operation and ensure, all data informations are all stored in data in system
In library, including database entity and database table, in which:
1) database entity includes:
Plan monocular entity: the entity is for storing all attributes relevant to goods and materials plan monocular, the attribute for specifically being included
There is monocular serial number, material information applies for quantity, unit price and unit；
Plan only head entity: the entity for store it is all with plan only relevant attribute, the attribute for specifically being included
Planned odd numbers plans odd numbers title, applicant, date of application, reason for the request, auditor, audit date, supplier, application
Arrival date, total amount；
Contract monocular entity: for the entity for storing all attributes relevant to contract monocular, the attribute for specifically being included has list
Mesh serial number, material information, monocular quantity, unit price, unit and purposes；
Contract list entity: the entity is all with contract simple correlation attribute for storing, and the attribute for specifically being included has contract volume
Number, contract title, source mode, source-information, the contract term, the means of payment, people, the date, audit are signed in Signed at
People audits date and total amount；
Material storage account single head entity: the entity is for storing all attributes relevant to material storage account single head, specifically
The attribute for being included has materiel code, material information, stockpile number and total amount；
Be put in storage single head entity out: the entity is for storing all attributes relevant to storage single head is gone out, the attribute for specifically being included
There is any discrepancy library odd numbers enters and leaves classification, send library or receive, send library or receive the date, send library or receive reason, source, storehouse keeping,
Auditor audits date and total amount；
Be put in storage monocular entity out: the entity is for storing all attributes relevant to storage monocular is gone out, the attribute for specifically being included
By monocular serial number, material information, monocular quantity, unit price, unit and purposes；
Goods and materials project file entity: the entity is used to store all attributes relevant to goods and materials project file, is specifically included
Attribute has materiel code, goods and materials title, phonetic code, specifications and models, unit, purposes, inventory's lower limit and inventory's upper limit；
Material storage account monocular entity: the entity is for storing all attributes relevant to material storage account monocular, specifically
The attribute for being included has sequence number, material information, unit price, unit, manufacturer, the date of production, asset number and outbound odd numbers.
2) database table is used to determine that the specific storage organization of database obtains the physical structure of database by physical Design,
Include:
Plan monocular table, monocular serial number is the unique identification of the table；
Only head table, plan odd numbers are the unique identification of the table for plan；
Contract monocular table, the unique identification of the monocular serial number table；
Contract list table, contract number are the unique identification of the table；
Material storage account single head table, materiel code are the unique identification of the table；
It is put in storage single head table out, is put in storage the unique identification that odd numbers is the table out；
It is put in storage monocular table, the unique identification of the monocular serial number table out；
Goods and materials project file table, materiel code are the unique identification of the table；
Material storage account monocular table, the unique identification of the Serial No. table.
2. a kind of Construction of Civil Engineering Project Cost management system according to claim 1, it is characterised in that: the building
Construction project cost management system includes six functional modules:
1) module for managing files: for will relevant to cost information form archives and be managed by module for managing files and
Maintenance, including archives kind management, archives and information management, archives dictionary management can be to goods and materials shelves by archives kind management
Case is classified, and carries out the setting and management of classification；By archives and information management, the goods and materials that cost is related to can be believed substantially
Breath is managed and safeguards；By archives dictionary management, cost archives can be quickly found out and carry out the inquiry of archive information；
2) plan management of materials and quipment module: buying to goods and materials and pass through plan management of materials and quipment using corresponding plan is formulated in advance
Module is managed and safeguards, in plan management of materials and quipment module, application, examination & approval and inquiry operation including plan, and goods and materials
Administrative staff need to input the application information of goods and materials plan in systems, are then examined by company leader, only by examining
The plan criticized can be just performed, and by planning query function, user enters the goods and materials plan information that system searching wants to know about；
3) it contract management module: after making procurement contract for purchase of goods and materials personnel, is entered into system, transfers to company
The audit of carry out contract is led, only could formally be implemented by the procurement plan of audit, in addition, other users can also pass through is
System inquires all contract informations；
4) storehouse management module: the processes such as storage, outbound for goods and materials, early warning and ledger management including inventory；
5) system management module: the relevant information in system is configured and is safeguarded for system manager, in goal systems
In, system management module includes that division management, user management, rights management, Role Management function can by division management
Department's information of enterprise is safeguarded；By user management, all user basic informations in system can be safeguarded；
By rights management, the operating right of users all in system can be configured；It, can be in system by Role Management
The corresponding role of all users is configured；
6) decision-making management module: in goal systems, to the buying of goods and materials, storage, outbound, it is related to using, the work scrapped
Corresponding all kinds of reports are managed and safeguard, the statistics and inquiry of data are carried out according to report content, to provide for decision
Data foundation.
3. a kind of Construction of Civil Engineering Project Cost management system according to claim 2, it is characterised in that: the archives
The cost archive management method of management module are as follows:
(1) after user enters cost module for managing files, new material base information, point are inputted in files of materials and equipment administration page
Save button is hit, system can obtain the information of user's input automatically, and carry out non-empty verifying to it, and null value, then prompt if it exists
User re-enters；
(2) null value if it does not exist, system will continue to identify cargo number and verify, if there are identical number in system,
Prompt user re-enters, if identical number is not present in system, verifies to the upper and lower limits of material storage, if depositing
The case where the upper limit is less than lower limit, then user is prompted to re-enter；
(3) if the upper limit of confirmation goods and materials is greater than lower limit, system fills the information that the page obtains into goods and materials entity class, and will use
The material information of family input is saved to background data base table, and so far operation terminates.
4. a kind of Construction of Civil Engineering Project Cost management system according to claim 2, it is characterised in that: the goods and materials
The goods and materials plan application method of planning management module includes:
(1) after user enters plan management of materials and quipment module, the number of purchasing plan of materials and equipment is inputted in the goods and materials plan application page,
System can obtain the number of user's input automatically and verify at this time, be identically numbered if existing in system, prompt user
It re-enters；
(2) if identical procurement program number is not present in system, user continues the Shen that procurement plan is inputted according to page prompts
Please the essential informations such as date, then input the material category of procurement plan, the information such as goods and materials title, it is also necessary to input this buying
Then the reason of plan, selects the procurement method of this procurement plan in drop-down list, after the input for completing all information, point
Hit submitting button；
(3) system can prompt the user whether that confirmation is submitted at this time, if user's selection is no, operation terminates, if user's selection is to be
System obtains the procurement plan information in the page and is submitted in background data base table, audits for company leader.
5. a kind of Construction of Civil Engineering Project Cost management system according to claim 2, it is characterised in that: the goods and materials
The goods and materials plan checking method of planning management module includes:
(1) after user logs in plan management of materials and quipment module, into procurement plan original list, as needed from list final choice
The procurement plan for needing to audit, system can find the corresponding number of the procurement plan into background data base at this time, if not finding
The number, then prompt user to re-enter；
(2) if finding the procurement program number, system jumps directly to the detailed audit page of the procurement plan, and user carefully looks into
After seeing plan application information, according to the audit opinion of application content input procurement plan, submitting button is clicked, system can prompt to use
Whether family confirms msu message, if user's selection is no, operation terminates；
(3) if user's selection is that the audit opinion that user inputs is saved in background data base by system, so far operation terminates.
6. a kind of Construction of Civil Engineering Project Cost management system according to claim 2, it is characterised in that: the contract
The procurement contract management method of management module includes:
(1) after user enters contract management module, the number of procurement contract is inputted in the contract management page, system can be certainly at this time
The dynamic number for obtaining user's input simultaneously carries out repeated authentication to it, if there are identical numbers in system, prompts user again defeated
Enter；
(2) if user continues to be believed substantially according to page prompts input procurement plan information, contract there is no number is repeated in system
Breath, contract terms and payment information, and by the invoice type of drop-down list selection contract, while also to input handling for contract
People's information；
(3) after all information inputs, user clicks save button, and whether system prompt user saves contract at this time, if
User's selection is no, then operation terminates, if user's selection is, system continues to carry out non-empty verifying to all information, must fill out if it exists
It for empty phenomenon, then prompts user to re-enter, if it does not exist nonempty entry, then obtains page procurement plan information preservation to rear
In platform database, and it is committed to system audit, so far all operations terminate.
7. a kind of Construction of Civil Engineering Project Cost management system according to claim 2, it is characterised in that: the warehouse
The warehouse basic information management method of management module includes:
(1) after user enters storehouse management module, warehouse classification, at this time system meeting are selected in the warehouse basic information management page
The classification that user chooses is verified, if the category is not present in system, the warehouse classification that user inputs is added to and is
In system；
(2) if user select to obtain warehouse classification exist, user continue input warehouse title, at this time system also can to the title into
Row repeated authentication prompts user to re-enter if the title in the warehouse title and database repeats；
(3) if the warehouse title is not repeated with the title in system, user continues to input the information such as warehouse location and contact method,
Save button is clicked after completing the input of information, system obtains page info automatically and fills into warehouse entity, then calls industry
Logic layer method preservation warehouse information be engaged in into background data base, so far all operations terminate.
8. a kind of Construction of Civil Engineering Project Cost management system according to claim 2, it is characterised in that: the warehouse
The materials warehousing management process of management module includes:
(1) after user enters storehouse management module, the purchase order for selecting this to be put in storage in materials warehousing administration page, at this time
The purchase order that system can be selected according to user obtains the corresponding material information of the order, while it is each to traverse goods and materials list inspection
The state of goods and materials, if there are unqualified phenomenon, end operations for goods and materials；
(2) if the goods and materials are qualified, material information is stored in interim storage set, while verifying whether to terminate traversal, if
Traversal is not finished, then reexamines goods and materials state, if traversal terminates, fills in the essential information of storage bill, while the page being believed
Material information in breath and storage set is saved into database, and so far all operations terminate.
9. a kind of Construction of Civil Engineering Project Cost management system according to claim 2, it is characterised in that: the system
The method for managing system of management module includes:
(1) after user enters system management module, department's information described in user is selected in the system administration page, at this time system
The information that can be selected user is verified, and the information, then select role-security belonging to user, and reselect if it does not exist
User's affiliated department information；
(2) if the information village exists, continue the number for inputting user, system can verify Customs Assigned Number at this time, if with being
Exist in system and repeat, then prompt user to re-enter, if not repeating with the number in system, continues to select angle belonging to user
Color permission；
(3) system can carry out repeated authentication to the role-security belonging to user, repeat if it exists, then prompt user to reselect,
It repeats if it does not exist, then inputs other essential informations such as address name, after the input for completing all information, click save button,
System can obtain Page user information automatically and be saved into background data base, and so far all operations terminate.
10. a kind of Construction of Civil Engineering Project Cost management system according to claim 2, it is characterised in that: described to determine
The Data Statistics Inquiry Through method of plan management module includes:
(1) after user enters decision-making management module, the data category for currently needing to count is selected in the Data Statistics Inquiry Through page,
The classification that system can be selected according to user at this time loads the corresponding statistics page；
(2) after loading the statistics page, user can click inquiry button, system according to the condition of statistics classification input statistics
The statistical condition of user's input can be obtained automatically, and the splicing of SQL query statement is carried out to condition, while calling data access layer
Method execute SQL statement；
(3) after completing inquiry operation, system judges whether statistical query result is empty, if result is sky, operation terminates, if
Query result is not sky, and the result of statistical query is back to page layer by system, and statistical result is tied to data control by the page
In, it is checked for user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910571467.4A CN110298631A (en) | 2019-06-28 | 2019-06-28 | A kind of Construction of Civil Engineering Project Cost management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910571467.4A CN110298631A (en) | 2019-06-28 | 2019-06-28 | A kind of Construction of Civil Engineering Project Cost management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110298631A true CN110298631A (en) | 2019-10-01 |
Family
ID=68029198
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910571467.4A Pending CN110298631A (en) | 2019-06-28 | 2019-06-28 | A kind of Construction of Civil Engineering Project Cost management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110298631A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110969411A (en) * | 2019-11-25 | 2020-04-07 | 石斌 | Civil engineering construction project cost management system |
-
2019
- 2019-06-28 CN CN201910571467.4A patent/CN110298631A/en active Pending
Non-Patent Citations (1)
| Title |
|---|
| 刘翔宇: ""土木工程物资管理平台的设计与实现"，刘翔宇，中国优秀硕士论文全文数据库信息科技辑（月刊），2016年第03期，第I138-4926页", 《中国优秀硕士论文全文数据库信息科技辑（月刊）》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110969411A (en) * | 2019-11-25 | 2020-04-07 | 石斌 | Civil engineering construction project cost management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107679749B (en) | Authority application approval method and authorization management platform | |
| US7574379B2 (en) | Method and system of using artifacts to identify elements of a component business model | |
| TW535088B (en) | Method and system for facilitating parts procurement and production planning across an extended supply chain | |
| AU2003274987B2 (en) | Deploying multiple enterprise planning models across clusters of applications servers | |
| CA2497742C (en) | Real-time aggregation of data within an enterprise planning environment | |
| JP4609994B2 (en) | Selective deployment of software extensions within an enterprise modeling environment. | |
| US20160034474A1 (en) | Enterprise Data Mining in a Multi-Tenant Database | |
| US20040138942A1 (en) | Node-level modification during execution of an enterprise planning model | |
| WO2011050482A1 (en) | Enterprise data mining in a hosted multi-tenant database | |
| CN112732823B (en) | Method for realizing enterprise material supply whole-process monitoring system | |
| Chuah et al. | Construct an enterprise business intelligence maturity model (EBI2M) using an integration approach: A conceptual framework | |
| US20060041496A1 (en) | Method and system for automating proposals involving direct and indirect sales | |
| US7257612B2 (en) | Inline compression of a network communication within an enterprise planning environment | |
| Waszkowski et al. | Corporate efficiency improvement with business process automation | |
| CN110298631A (en) | A kind of Construction of Civil Engineering Project Cost management system | |
| CN115983947A (en) | Medical institution material acquisition and electricity purchasing commercialization system and method | |
| US20140149186A1 (en) | Method and system of using artifacts to identify elements of a component business model | |
| JPH08147381A (en) | Examination job support system | |
| CN112241858A (en) | Equipment material management system | |
| CN109885609A (en) | Based on combined data area control method, device and storage medium | |
| CN112470175B (en) | Audit support system, audit support server device, audit support terminal, audit support program, and audit support method | |
| CN116303497A (en) | Asset information management method, device, equipment and storage medium | |
| CN112907220A (en) | System, method and device for engineering cost | |
| US20090182571A1 (en) | Automated Execution of Business Processes Using Reverse Nesting | |
| Intelligence | Pro PerformancePoint Server 2007 |
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 |
Application publication date: 20191001 |