CN102243737A - Material management system and material management method of mine workpiece - Google Patents
Material management system and material management method of mine workpiece Download PDFInfo
- Publication number
- CN102243737A CN102243737A CN2011101935949A CN201110193594A CN102243737A CN 102243737 A CN102243737 A CN 102243737A CN 2011101935949 A CN2011101935949 A CN 2011101935949A CN 201110193594 A CN201110193594 A CN 201110193594A CN 102243737 A CN102243737 A CN 102243737A
- Authority
- CN
- China
- Prior art keywords
- workpiece
- unit
- materials
- goods
- warehouse
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a material management system and a material management method of a mine workpiece. In order to overcome the defects that the material management system of the mine workpiece in the prior art is disperse and independent and does not contribute to data interconnection and interoperability, the invention provides the material management system, which is integrated and contributes to the data interconnection and interoperability, of the mine workpiece, and provides the material management method of the mine workpiece. The system mainly comprises a price-making and warehouse-establishing module, a workpiece warehousing/ex-warehousing management and detail query module, a workpiece warehousing material detail query module and a workpiece ex-warehousing material detail query module, wherein all modules and a data analysis module of an application server carry out data request and corresponding processing; and the data analysis module and a database carry out data exchange, so functions of increasing, deleting, modifying, querying and exporting data are realized, submission of a data electronic flow is realized on a flow, and data association between different modules is established.
Description
Technical field
The present invention relates to the producer goods management system, relate to a kind of mine workpiece material Management System and method in particular.
Background technology
Office document management apparatus account, spare part and instrument are used in the material management in some present mines usually, system originally disperses and independence, the actual data that are mutually related, information are independently handled respectively between the platform mutually a plurality of, be easy to generate the situation of data, information contradiction, form the unfavorable result of information island.And the interface is varied, is unfavorable for that the slip-stick artist grasps the using method of system in proper order, and the query manipulation more complicated, and Query Result shows clear inadequately and convenient.
Summary of the invention
The technical scheme that the technical problem to be solved in the present invention is taked is to disperse independent at the mine workpiece material Management System of prior art, the defective that is unfavorable for the interconnected mutual usefulness of data provides a kind of mine workpiece material Management System and method of incorporate, the interconnected mutual usefulness that is beneficial to data.
The present invention solves the technical scheme that technical scheme that its technical matters takes takes, construct a kind of mine workpiece material Management System, comprising: module, workpiece in-out-storehouse management and detailed enquiry module, the detailed enquiry module of workpiece warehouse-in goods and materials and the detailed enquiry module of workpiece outbound goods and materials are set up in the formulation of price and warehouse; The data analysis module of each module and application server carries out the request and the respective handling of data, and data analysis module and database carry out exchanges data.
The formulation of described price and warehouse are set up module and comprised: workpiece imports the unit in batches, is used to workpiece to set the unit of setting up that coding imports in batches, workpiece is given tacit consent to warehouse-in unit setup unit, goods and materials price setting module and workpiece warehouse;
Workpiece setting coding imports the unit in batches and mainly comprises three importings in batches, and first is that the workpiece materiel code imports in batches, is used to import the workpiece comprehensive quota, comprises materiel code, goods and materials title, specifications and models, rapidoprint type, warehouse content; Second is that workpiece coding material specification imports in batches, is used to import the material specification of workpiece quota, and concrete material specification classification is made a report on according to the pricing practice-materials classification of secondary market; The 3rd is that the workpiece warehouse-in imports in batches, is used for the library management of going into of workpiece goods and materials, comprises materiel code, goods and materials title, specifications and models, rapidoprint type, warehouse, warehousing quantity, unit price, shelf content.
Workpiece acquiescence warehouse-in unit is used for making a report on workpiece acquiescence warehouse-in unit, during the workpiece warehouse-in directly acquiescence go in the storehouse of the unit of regulation, during outbound from being calculated as the income of the unit of regulation.
Workpiece goods and materials price unit is used for making a report on the workpiece comprehensive quota, specifically comprises materiel code, goods and materials title, specifications and models, rapidoprint type, warehouse, warehousing quantity, unit price, shelf content.Also can import comprehensive quota from batch imports, can inquire about, revise, delete in workpiece goods and materials price after the importing, comprehensive quota comprises wage, material, three cost elements of electric power.
The unit of setting up in workpiece warehouse is used for defining the workpiece warehouse, and different warehouses can define different income coefficients and outlay coefficient, and income coefficient is to be used for the income of calculating processing part management unit, and outlay coefficient is used for calculating the expenditure of applying unit; Old warehouse whether, selection is need make a report on recovery unit during warehouse-in.
Described workpiece in-out-storehouse management and detailed enquiry module comprise: workpiece warehouse-in unit, and be used to make a report on workpiece and go into library information, also can from import in batches, import corresponding information; The monthly unit budget of workpiece unit is used for assigning monthly processing budget to individual applying unit, can get workpiece in budget amount, can't get when excessing budget the amount of money; The workpiece goods and materials go out library unit, are used to make a report on workpiece and go out library information, and print receipt; Workpiece goods and materials outbound query unit is used for the constituent parts inquiry and receives the workpiece goods and materials, and prints the outbound detail list; Workpiece stock-taking unit is used for the stock-taking of workpiece goods and materials at the end of month.Two kinds of modes of making an inventory of mode A and mode B are arranged, and wherein mode A is that single goods and materials are made an inventory, and mode B is that a plurality of goods and materials are made an inventory;
The detailed enquiry module of described workpiece warehouse-in goods and materials comprises that workpiece stock in storage message unit is used for inquiring about workpiece goods and materials inventory information, and the type slug font code; Workpiece stock in storage information lead-out unit is used for inquiring about workpiece goods and materials inventory information, and prints the stock in storage detail list.
The detailed enquiry module of described workpiece outbound goods and materials is used for the detailed inquiry of workpiece outbound goods and materials clearing.During every workpiece goods and materials outbound, multiply by the outlay coefficient of corresponding warehouse goods and materials according to total charge after, count the processing expenditure of applying unit, count during form-processing examination monthly magazine-processing pays; Simultaneously, after each amount of money of itemizing multiply by the income coefficient of corresponding warehouse goods and materials, count the production imcome of workpiece management unit, wherein wage counts in form-wage income monthly magazine-production imcome, material counts in form-materials classification examination monthly magazine-detail-material income-production imcome, and electric power counts in form-electric power examination monthly magazine-electric power income-production imcome.
Mine of the present invention workpiece goods and material handling method is further comprising the steps of:
Import unit typing spare part information in batches by workpiece, with workpiece materiel code information and workpiece information opening relationships;
Import workpiece material specification by norm in batches by workpiece coding material specification, and with workpiece coded message and workpiece information opening relationships;
Because the application of technique scheme, the present invention compared with prior art has following advantage:
The formulation and the warehouse of price are set up, the workpiece in-out-storehouse management concentrates on a plateform system, be very easy to statistics, query processing work, and each intermodule foundation is related, and data are organically combined, and has stopped problem of detached island of information, guaranteed data consistency, strengthen the information friendliness, and solved the problem of the loaded down with trivial details aspect of query manipulation, greatly improved work efficiency.
Description of drawings
Describe embodiments of the present invention in detail below in conjunction with accompanying drawing, in the accompanying drawing:
Accompanying drawing 1 is the relational structure synoptic diagram of mine of the present invention workpiece material Management System.
Embodiment
The invention will be further described below in conjunction with drawings and Examples:
As shown in Figure 1, be an embodiment of mine of the present invention workpiece material Management System and method, adapt to newly-built mine and carry out the foundation of goods and materials account data, the work that workpiece finish message Report Operations administrative institute needs, this system comprises that mainly the formulation of price and warehouse set up module 201, workpiece in-out-storehouse management and detailed enquiry module 202, the detailed enquiry module 203 of workpiece warehouse-in goods and materials, and the detailed enquiry module 204 of workpiece outbound goods and materials, the data analysis module 102 of each module and application server 101 carries out the request and the respective handling of data, data analysis module 102 and database 103 carry out exchanges data, realized the increase of data, deletion, revise, inquiry, the data export function, and on flow process, realized the submission of data electron streams, set up the data association between the disparate modules.
The formulation of price and warehouse are set up module 201 and comprised: workpiece imports unit 301 in batches, and what this unit was used to that workpiece sets that coding imports unit 301, workpiece acquiescence warehouse-in unit setup unit 302, goods and materials price setup unit 303, workpiece warehouse in batches sets up unit 304;
Further, workpiece setting coding imports unit 301 in batches and mainly comprises three importings in batches, first is that the workpiece materiel code imports in batches, is used to import the workpiece comprehensive quota, comprises materiel code, goods and materials title, specifications and models, rapidoprint type, warehouse; Second is that workpiece coding material specification imports in batches, is used to import the material specification of workpiece quota, and concrete material specification classification is made a report on according to the pricing practice-materials classification of secondary market; The 3rd is that workpiece warehouse-in imports in batches, is used for the library management of going into of workpiece goods and materials, comprises materiel code, goods and materials title, specifications and models, rapidoprint type, warehouse, warehousing quantity, unit price, shelf number.
Further, workpiece acquiescence warehouse-in unit 302 is used for making a report on workpiece acquiescence warehouse-in unit, during the workpiece warehouse-in directly acquiescence go in the storehouse of the unit of regulation, during outbound from being calculated as the income of the unit of regulation.
Further, workpiece goods and materials price unit 303 is used for making a report on the workpiece comprehensive quota, specifically comprises materiel code, goods and materials title, specifications and models, rapidoprint type, warehouse, warehousing quantity, unit price, shelf content.Also can from batch imports, import comprehensive quota, can in workpiece goods and materials price, inquire about, revise, delete after the importing.Comprehensive quota comprises wage, material, three cost elements of electric power.
Further, the unit 304 of setting up in workpiece warehouse is used for defining the workpiece warehouse, different warehouses can define different income coefficients and outlay coefficient, and income coefficient is to be used for the income of calculating processing part management unit, and outlay coefficient is used for calculating the expenditure of applying unit.
Workpiece in-out-storehouse management and detailed enquiry module 202 comprise: workpiece warehouse-in unit 305, and the monthly unit budget of workpiece unit 306, the workpiece goods and materials go out library unit 307, workpiece goods and materials outbound query unit 308, workpiece stock-taking unit 309;
Further, workpiece warehouse-in unit 305 is used to make a report on workpiece and goes into library information, also can import corresponding information from import in batches;
Further, the monthly unit budget of workpiece unit 306 is used for assigning monthly processing budget to individual applying unit, can get workpiece in budget amount, can't get when excessing budget the amount of money;
Further, the workpiece goods and materials go out library unit 307, are used to make a report on workpiece and go out library information, and print receipt;
Further, workpiece goods and materials outbound query unit 308 is used for the constituent parts inquiry and receives the workpiece goods and materials, and prints the outbound detail list;
Further, workpiece stock-taking unit 309 is used for the stock-taking of workpiece goods and materials at the end of month.Two kinds of modes of making an inventory of mode A and mode B are arranged, and wherein mode A is that single goods and materials are made an inventory, and mode B is that a plurality of goods and materials are made an inventory;
The detailed enquiry module 203 of described workpiece warehouse-in goods and materials comprises workpiece stock in storage message unit, workpiece stock in storage information lead-out unit;
Further, workpiece stock in storage message unit 310 is used for inquiring about workpiece goods and materials inventory information, the type slug font code;
Further, workpiece stock in storage information lead-out unit 311 is used for inquiring about workpiece goods and materials inventory information, and prints the stock in storage detail list.
The detailed enquiry module 204 of described workpiece outbound goods and materials is used for the detailed inquiry of workpiece outbound goods and materials clearing.During every workpiece goods and materials outbound, multiply by the outlay coefficient of corresponding warehouse goods and materials according to total charge after, count the processing expenditure of applying unit, count during form-processing examination monthly magazine-processing pays; Simultaneously, after each amount of money of itemizing multiply by the income coefficient of corresponding warehouse goods and materials, count the production imcome of workpiece management unit, wherein wage counts in form-wage income monthly magazine-production imcome, material counts in form-materials classification examination monthly magazine-detail-material income-production imcome, and electric power counts in form-electric power examination monthly magazine-electric power income-production imcome.
The present invention also provides the method for a kind of mine workpiece material management, it is characterized in that, may further comprise the steps:
Import unit typing spare part information in batches by workpiece, and with workpiece materiel code information and workpiece information opening relationships;
Import workpiece material specification by norm in batches by workpiece coding material specification, and with workpiece coded message and workpiece information opening relationships;
The foregoing description only is explanation technical conceive of the present invention and characteristics, its objective is to allow the personage who is familiar with this technology can understand content of the present invention and enforcement according to this, can not therefore limit protection scope of the present invention.All effects that spirit is done according to the present invention change or modify, and all are encompassed within protection scope of the present invention.
Claims (6)
1. mine workpiece material Management System and method, it is characterized in that this system comprises that mainly module 201, workpiece in-out-storehouse management and detailed enquiry module 202 are set up in the formulation of price and warehouse, workpiece is put detailed enquiry module 203 of goods and materials and the detailed enquiry module 204 of workpiece outbound goods and materials in storage, the data analysis module 102 of each module and application server 101 carries out the request and the respective handling of data, and data analysis module 102 and database 103 carry out exchanges data.
2. mine according to claim 1 workpiece material Management System, it is characterized in that the formulation of price and warehouse set up module 201 and comprise: workpiece imports unit 301 in batches, and what this unit was used to that workpiece sets that coding imports unit 301, workpiece acquiescence warehouse-in unit setup unit 302, goods and materials price setting module 303, workpiece warehouse in batches sets up unit 304;
Described workpiece setting coding imports unit 301 in batches and mainly comprises three importings in batches, first is that the workpiece materiel code imports in batches, be used to import the workpiece comprehensive quota, comprise materiel code, goods and materials title, specifications and models, rapidoprint type, warehouse content; Second is that workpiece coding material specification imports in batches, is used to import the material specification of workpiece quota, and concrete material specification classification is made a report on according to the pricing practice-materials classification of secondary market; The 3rd is that the workpiece warehouse-in imports in batches, is used for the library management of going into of workpiece goods and materials, comprises materiel code, goods and materials title, specifications and models, rapidoprint type, warehouse, warehousing quantity, unit price, shelf content;
Described workpiece acquiescence warehouse-in unit 302 is used for making a report on workpiece acquiescence warehouse-in unit, during the workpiece warehouse-in directly acquiescence go in the storehouse of the unit of regulation, during outbound from being calculated as the income of the unit of regulation;
Described workpiece goods and materials price unit 303 is used for making a report on the workpiece comprehensive quota, specifically comprise materiel code, goods and materials title, specifications and models, rapidoprint type, warehouse, warehousing quantity, unit price, shelf content, also can from import in batches, import comprehensive quota, can inquire about, revise, delete in workpiece goods and materials price after the importing, comprehensive quota comprises wage, material, three cost elements of electric power;
The unit 304 of setting up in described workpiece warehouse is used for defining the workpiece warehouse, and different warehouses can define different income coefficients and outlay coefficient, and income coefficient is to be used for the income of calculating processing part management unit, and outlay coefficient is used for calculating the expenditure of applying unit.
3. mine according to claim 1 workpiece material Management System, it is characterized in that workpiece in-out-storehouse management and detailed enquiry module 202 comprise: workpiece warehouse-in unit 305, the monthly unit budget of workpiece unit 306, the workpiece goods and materials go out library unit 307, workpiece goods and materials outbound query unit 308, workpiece stock-taking unit 309;
Described workpiece warehouse-in unit 305 is used to make a report on workpiece and goes into library information, also can import corresponding information from import in batches;
The monthly unit budget of described workpiece unit 306 is used for assigning monthly processing budget to individual applying unit, can get workpiece in budget amount, can't get when excessing budget the amount of money;
Described workpiece goods and materials go out library unit 307, are used to make a report on workpiece and go out library information, and print receipt;
Described workpiece goods and materials outbound query unit 308 is used for the constituent parts inquiry and receives the workpiece goods and materials, and prints the outbound detail list;
Described workpiece stock-taking unit 309 is used for the stock-taking of workpiece goods and materials at the end of month, and two kinds of modes of making an inventory of mode A and mode B are arranged, and wherein mode A is that single goods and materials are made an inventory, and mode B is that a plurality of goods and materials are made an inventory.
4. mine according to claim 1 workpiece material Management System is characterized in that the detailed enquiry module 203 of described described workpiece warehouse-in goods and materials, comprises workpiece stock in storage message unit, workpiece stock in storage information lead-out unit;
Described workpiece stock in storage message unit is used for inquiring about workpiece goods and materials inventory information, and the type slug font code;
Described workpiece stock in storage information lead-out unit is used for inquiring about workpiece goods and materials inventory information, and prints the stock in storage detail list.
5. mine according to claim 1 workpiece material Management System, it is characterized in that the detailed enquiry module 204 of described workpiece outbound goods and materials, be used for the detailed inquiry of workpiece outbound goods and materials clearing, during every workpiece goods and materials outbound, multiply by the outlay coefficient of corresponding warehouse goods and materials according to total charge after, count the processing expenditure of applying unit, count in form-processing examination monthly magazine-processing expenditure; Simultaneously, after each amount of money of itemizing multiply by the income coefficient of corresponding warehouse goods and materials, count the production imcome of workpiece management unit, wherein wage counts in form-wage income monthly magazine-production imcome, material counts in form-materials classification examination monthly magazine-detail-material income-production imcome, and electric power counts in form-electric power examination monthly magazine-electric power income-production imcome.
6. the method for a mine workpiece material management is characterized in that, may further comprise the steps
Import unit typing spare part information in batches by workpiece, and with workpiece materiel code information and workpiece information opening relationships;
Import workpiece material specification by norm in batches by workpiece coding material specification, and with workpiece coded message and workpiece information opening relationships.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101935949A CN102243737A (en) | 2011-07-01 | 2011-07-01 | Material management system and material management method of mine workpiece |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101935949A CN102243737A (en) | 2011-07-01 | 2011-07-01 | Material management system and material management method of mine workpiece |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102243737A true CN102243737A (en) | 2011-11-16 |
Family
ID=44961781
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011101935949A Pending CN102243737A (en) | 2011-07-01 | 2011-07-01 | Material management system and material management method of mine workpiece |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102243737A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103295115A (en) * | 2013-05-13 | 2013-09-11 | 苏州才子佳人文化传播有限公司 | Movable shopping mall and supermarket warehouse management system |
| CN103310318A (en) * | 2013-05-11 | 2013-09-18 | 苏州才子佳人文化传播有限公司 | Mobile mall logistics management system cargo management module |
| CN104182858A (en) * | 2014-08-18 | 2014-12-03 | 四川航天系统工程研究所 | Material life cycle tracing method |
| CN104732324A (en) * | 2014-12-18 | 2015-06-24 | 深圳市燃气集团股份有限公司 | Fuel gas equipment and material picking data processing method and system thereof |
| CN104915818A (en) * | 2015-05-31 | 2015-09-16 | 镇江东软信息技术有限公司 | Warehouse cargo management system |
| CN105631684A (en) * | 2014-11-03 | 2016-06-01 | 东方钢铁电子商务有限公司 | Data analysis system used for electronic platform |
| CN108846682A (en) * | 2018-06-15 | 2018-11-20 | 合肥齐信信息技术有限公司 | A kind of automobile raw material and spare and accessory parts intelligent tracing system |
| CN109967381A (en) * | 2019-03-14 | 2019-07-05 | 天津丰通金属制品有限公司 | A kind of environment friendly intelligent metal working process |
-
2011
- 2011-07-01 CN CN2011101935949A patent/CN102243737A/en active Pending
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103310318A (en) * | 2013-05-11 | 2013-09-18 | 苏州才子佳人文化传播有限公司 | Mobile mall logistics management system cargo management module |
| CN103295115A (en) * | 2013-05-13 | 2013-09-11 | 苏州才子佳人文化传播有限公司 | Movable shopping mall and supermarket warehouse management system |
| CN104182858A (en) * | 2014-08-18 | 2014-12-03 | 四川航天系统工程研究所 | Material life cycle tracing method |
| CN104182858B (en) * | 2014-08-18 | 2017-12-12 | 四川航天系统工程研究所 | A kind of retroactive method of goods and materials Life cycle |
| CN105631684A (en) * | 2014-11-03 | 2016-06-01 | 东方钢铁电子商务有限公司 | Data analysis system used for electronic platform |
| CN104732324A (en) * | 2014-12-18 | 2015-06-24 | 深圳市燃气集团股份有限公司 | Fuel gas equipment and material picking data processing method and system thereof |
| CN104915818A (en) * | 2015-05-31 | 2015-09-16 | 镇江东软信息技术有限公司 | Warehouse cargo management system |
| CN108846682A (en) * | 2018-06-15 | 2018-11-20 | 合肥齐信信息技术有限公司 | A kind of automobile raw material and spare and accessory parts intelligent tracing system |
| CN109967381A (en) * | 2019-03-14 | 2019-07-05 | 天津丰通金属制品有限公司 | A kind of environment friendly intelligent metal working process |
| CN109967381B (en) * | 2019-03-14 | 2021-08-03 | 天津恒兴机械设备有限公司 | Environment-friendly intelligent metal processing system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102243737A (en) | Material management system and material management method of mine workpiece | |
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN103678648B (en) | A kind of BOM table sort aggregation system and method thereof | |
| EP1544765A1 (en) | Method and system for planning demand for a configurable product in a managed supply chain | |
| CN101702651A (en) | Process system for supporting multi party service settlement based on rule and method thereof | |
| CN104572688A (en) | Information push method and device | |
| CN102034194A (en) | Logistics billing method based on rule | |
| CN103020806A (en) | Information management system and information management method based on specific user supply chain coordination | |
| CN103116832A (en) | Method and device for grouping collecting and generating business documents | |
| CN107944804A (en) | The application Warehouse Management System of multi-functional big data integrated management | |
| CN110288361A (en) | A kind of have furniture made to order information tracking method and system based on Life cycle | |
| CN102222285B (en) | Multi-dimensional data linkage computing device and multi-dimensional data linkage computing method | |
| CN111507686A (en) | Automatic budget system and method for engineering design change | |
| CN103164573A (en) | Product data management (PDM) design system | |
| CN106600326A (en) | Airport toll administration method and system | |
| CN111651968A (en) | Automatic EXCEL report generation method and system and information data processing terminal | |
| CN111784099A (en) | Airplane guarantee equipment project delivery management system and method | |
| CN107301595A (en) | A kind of electronic invoice account checking method and system | |
| CN107730374B (en) | Electronic accounting platform system and automatic checking method for accounting and link times of invoice data buyer | |
| CN104636805A (en) | Report data management server, report data management program, and report data management device | |
| CN103095469B (en) | A kind of communication cost closes account method and apparatus | |
| CN115147009A (en) | Method for realizing one-key generation of delivery note by using automation technology | |
| CN110490461A (en) | Door and window enterprise resource planning | |
| CN106599203B (en) | Data quality improvement method for asset full life cycle | |
| CN104715421A (en) | Method and device for processing electric charge data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20111116 |