CN101634944A - Interface method for ERP referencing WMS warehousing - Google Patents
Interface method for ERP referencing WMS warehousing Download PDFInfo
- Publication number
- CN101634944A CN101634944A CN200910017917A CN200910017917A CN101634944A CN 101634944 A CN101634944 A CN 101634944A CN 200910017917 A CN200910017917 A CN 200910017917A CN 200910017917 A CN200910017917 A CN 200910017917A CN 101634944 A CN101634944 A CN 101634944A
- Authority
- CN
- China
- Prior art keywords
- erp
- interface
- data
- wms
- program
- 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
- Stored Programmes (AREA)
Abstract
The invention discloses an interface method for ERP referencing WMS warehousing. The method comprises the following steps: creating a program extension mechanism, identifying the interface content of the current ERP operation by an external program, performing legal judgment on the interface, guaranteeing the legality for calling the external program, acquiring the data provided by WMS by an intermediate table in the external program, forming an information format required by ERP in a combined manner, and further calling the method in ERP to realize entry of data information and guidance of WMS data into an ERP system. The ERP system is not related to the external program so that the ERP system can realize irrelevance with an interface program, and the external program is realized by adopting the method for directly calling the internal standard event in the ERP system, which can skillfully evade the work of interface program modification resulted from maintenance or upgrade of ERP software, and maintain stability.
Description
Technical field
The present invention relates to a kind of Computer Applied Technology, can finish and introduce the WMS data in the ERP system, reach the loose lotus root splice grafting mouth between two systems, good realization data mode is adjusted and concurrent control.
Background technology
Carry out when integrated with the WMS system in ERP system at present, all need in two systems, make more modification to coordinate the integrated operation of two systems, modification to original system will cause may changing or go wrong of original system function on the one hand, software maintenance and the upgrading of ERP in the future of influence in the future on the other hand.In addition in the integrated application of ERP and WMS, how to guarantee consistance, the control multi-user concurrent of data mode, the numerous rope of processing of data fineness bore aspect, do not form clear disposal route efficiently.The lotus root that focuses between the reduction system of present technique is right, improves the integrality that data are handled simultaneously, comprises the processing aspect of concurrent, state consistency, data fineness bore differentiation.
Summary of the invention
The interface method that the objective of the invention is a kind of ERP referencing WMS warehousing, this method is to set up a kind of program extension mechanism, identify the interface content of current ERP operation by external program, and the interface carried out legal judgement, guarantee the legitimacy that external program calls, externally obtain the data that WMS provides by middle table in the program then, be combined to form the information format that ERP needs, the step of going forward side by side realizes the typing of data message with the method for the inside among the ERP, realize that the WMS data importing is to ERP system, because ERP system is not related with external program, so ERP system realizes the independence with interface routine, because adopted the method for directly calling ERP system internal standard incident, evade the modification of the interface routine that causes because of ERP software maintenance or upgrading in the realization of external program, kept the stable of interface; Specifically comprise following content:
1) by in current ERP product is realized, setting up mechanism and the method that external program calls, function is adjusted at the interface of using among the ERP, increase is to the support of button method, permission can be quoted outside overall situation function function through the document interface of the ERP that INTERFACE DESIGN goes out, can reach by quoting of function external program is quoted the into purpose of current software runtime environment;
2) set up overall situation function, realize the processing of interface procedure.In function, by environment measuring, obtain the information of current software runtime environment, judge whether the place of quoting is legal program source, legally the data mode that current WMS transmits middle table into then be set show the data list of being introduced by warehouse-in for reading, merging, obtain the data that user's multiselect returns after, call the rule of warehouse-in interface data typing among the ERP, realize data introducing ERP warehouse-in interface;
3) content of checking before the mode by expansion increases data and preserves judges in the inspection whether the data that are introduced into are consistent with the data of current interface operation, and the short time of realizing tables of data simultaneously is locked to data processing and finishes;
4) method by expansion increases the processing after data are preserved back, deletion, at first removes the associated data message of former warehouse-in in the processing, numbers with the warehouse-in of data according to the mode related update data mode that material adds batch;
The specific implementation step is as follows:
A) on existing ERP basis, set up a kind of external program call method of label form, externally in the program, by environment measuring, obtain the information of current software runtime environment, judge simultaneously whether the place of quoting is legal program source, legal, then externally proceed the Processing Interface content in the program;
B) by the interface data table, quote and lock the WMS data in the scope of quoting, final result is directed into ERP in-stockroom operation interface by the form by material and batch merging, and call ERP interface data processing rule, ERP finally finishes the preservation of data in database, by extendible data check of configuration and contents processing, realize that the state of interface table data upgrades and concurrent access control during preservation;
C) the indicated external function of additional information by element in the dynamic resolution interface, reflect then and call, be implemented in the pattern of carrying out the external code compatibility in the ERP software of curing with the cost of minimum, be implemented on original ERP basis by external code visit ERP internal program assembly and call the WMS system data;
D) set up the interface code that is independent of former ERP system, in the interface of finishing ERP system and WMS system, effectively guarantee the integrality and maintenance upgrade of original ERP system, make fast according to multiple WMS system again simultaneously and adjusting that the lotus root that reduces by two systems that interface causes is right.
Of the present invention have function and beneficial effect is as follows:
1. the present invention can obviously reduce the difficulty that integrated WMS system among the existing ERP is arranged, and has realized the Song Ouhe between system, has reduced the difficulty of ERP system upgrading after the system integration.
2. the present invention has realized among the ERP warehouse-in being quoted the process of WMS operation, the integrity issue of data processing when having solved the system integration fully clearly.
The invention solves among the WMS data fineness than problem thin among the ERP, avoided after the system integration the excessive problem of data volume among the ERP, help to improve the efficiency of management of enterprise.
Description of drawings
Fig. 1 is the interface process flow diagram;
Fig. 2 is that ERP is with reference to WPS data loading table.
Embodiment
Method of the present invention main in have:
1) by set up mechanism and the method that external program calls in current ERP product is realized, function is adjusted at the interface of using among the ERP, increases the support to the button method, and permission can be quoted outside overall situation function function through the document interface of the ERP that INTERFACE DESIGN goes out.Can reach by quoting of function external program is quoted the into purpose of current software runtime environment.
2) set up overall situation function, realize the processing of interface procedure.In function, by environment measuring, obtain the information of current software runtime environment, judge whether the place of quoting is legal program source,, current WMS is set transmits the data mode of middle table into for reading if be legal, merge and show the data list of not introduced by warehouse-in, after obtaining the data that user's multiselect returns, call the rule of warehouse-in interface data typing among the ERP, realize that data introduce ERP warehouse-in interface.
3) content of checking before the mode by expansion increases data and preserves judges in the inspection whether the data that are introduced into are consistent with the data of current interface operation, and the short time of realizing tables of data simultaneously is locked to data processing and finishes.
4) method by expansion increases the processing after data are preserved back, deletion, at first removes the associated data message of former warehouse-in in the processing, numbers with the warehouse-in of data according to the mode related update data mode that material adds batch.
Concrete steps are as follows:
E) on existing ERP basis, set up a kind of external program call method of label form, externally in the program, by environment measuring, obtain the information of current software runtime environment, judge simultaneously whether the place of quoting is legal program source, legal, then externally proceed the Processing Interface content in the program;
F) by the interface data table, quote and lock the WMS data in the scope of quoting, final result is directed into ERP in-stockroom operation interface by the form by material and batch merging, and call ERP interface data processing rule, ERP finally finishes the preservation of data in database, by extendible data check of configuration and contents processing, realize that the state of interface table data upgrades and concurrent access control during preservation;
G) the indicated external function of additional information by element in the dynamic resolution interface, reflect then and call, be implemented in the pattern of carrying out the external code compatibility in the ERP software of curing with the cost of minimum, be implemented on original ERP basis by external code visit ERP internal program assembly and call the WMS system data;
H) set up the interface code that is independent of former ERP system, in the interface of finishing ERP system and WMS system, effectively guarantee the integrality and maintenance upgrade of original ERP system, make fast according to multiple WMS system again simultaneously and adjusting that the lotus root that reduces by two systems that interface causes is right.
Embodiment
1. set up the database environment of running software.
2. the software user of service adjusts the adjustment that function is finished interface button by original interface among the ERP, quotes corresponding overall situation function in button.
3. the in-stockroom operation personnel use software to quote the WMS data to go into library management.
The main program assembly:
1, outside overall situation function call function: f_wd_do_dw_clicked
2, WMS data read and referencing function: f_hrerp_wms_gen_rkd
Software runtime environment information when obtaining this function operation judges whether environment is legal.
According to material with batch for statistics according to showing the not data message of warehouse-in, and the data content that the user is selected is introduced into ERP in-stockroom operation interface.Middle table HRERP_WMS_RKINFO content (as shown in Figure 2)
The program code segments of handling the WMS data-interface is as follows:
String?ls_ckbh，ls_ret，ls_lsbh
String?ls_sql，ls_text
String?ls_wlbh，ls_ph，s
Decimal ld_sl
Long ll_count＝0，C，R，r2，i
window?w
w_jxc_dj_scrkd?aw
w＝gwmdi.getact?ivesheet()
if?lower(w.classname())＝’w_jxc_dj_scrkd’then
aw＝w
else
This function of messagebox (' information ', ' only is supported to produce under the storage bill and is used! ')
return-1
end?if
The legitimacy of // inspection parameter
if?aw.ib_protect?then
This function of messagebox (' information ', ' is only available under the data modification state! ')
return-1
end?if
R＝AW.Dw_master.getrow()
if?isnull(r)or?r＜1then
Messagebox (' information ', ' please increases document earlier! ')
return-1
end?if
ls_ckbh＝aw.dw_master.getitemstring(r，’kcrkdl_ckbh’)
if?isnull(ls_ckbh)or?trim(ls_ckbh)＝”then
Messagebox (' information ', ' please first typing warehouse! ')
return-1
end?if
// check whether be the interior warehouse of range of management
IF?GIF_EXISTS(’HRERP_WMS_CKZD’，″CK＝’″+LS?CKBH+″’″)＜1THEN
This warehouse of messagebox (' information ', ' does not carry out the WMS task management, can not use this function! ')
return-1
END?IF
ls_lsbh＝aw.dw?master.getitemstring(r，’kcrkdl?lsbh’)
if?isnull(ls_lsbh)or?trim(ls_lsbh)＝”then?ls_lsbh＝’！！！！！！’
// synchrodata, if the failure would return-1
if?f_hrerp_wms_syn_data()＝-1?then
return?-1
end?if
// renewal was 0 data mode originally, in case WMS writes the collision problem of fashionable operation
update?HRERP_WMS_RKINFO?set?F_STATE＝’1’WHERE?F_STATE＝’0’；
commit；
// select content corresponding
ls_sql＝″select?F_WLBH+’..’+F_PH?as?id，MAX(F_WLMC)AS?WLMC，MAX(F_GGXH)
as?gg，SUM(F_SL)as?sl ″
ls_sql+＝″from?HRERP_WMS_RKINFO?where?F_CKBH＝’″+ls_ckbh+″’AND(F_STATE＝
’1’or?F_RKDID＝’″+ls_lsbh+″’)group?by?F_WLBH，F_PH″
Ls_text=" product .. lot number, name of product, specification, number of packages "
openwithparm(w_pub_select_more，ls_sql+’％*％’+ls_text)
ls_ret＝message.stringparm
IF?ls_ret＞”then
r2＝aw.dw_detail.rowcount()
for?i＝r2?to?1?step-1
if?trim(aw.dw_detail.getitemstring(i，’kcrkd2_wlbh’))＞’’then
aw.dw_detail.scrolltorow(i)
aw.event?ue_detail_delete()
end?if
next
end?if
do?while?ls_ret＞’’
ll_count++
S＝get_token(ls_ret，’，’)
ls_wlbh＝get_token(s，’..’)
ls_ph ＝s
select?sum(F_SL)INTO:LD_SL?from?HRERP_WMS_RKINFO?where?F_CKBH＝:LS_CKBH?ANDF_WLBH＝:LS_WLBH?AND?F_PH＝:LS_PH?AND(F_STATE＝’1’OR?F_RKDID＝:LS_LSBH)；
// on the entry of storage bill, handle.Adopt self-defining term 5 write down warehouse-in number
do?whi?le?AW.DW_DETAIL.rowcount()＜ll_count
aw.event?ue_detail_append()
loop
AW.DW_DETAIL.SCROLLTOROW(LL_COUNT)
AW.DW_DETAIL.SETCOLUMN(″kcrkd2_wlbh″)
AW.DW_DETAIL.SETTEXT(LS_WLBH)
AW.DW_DETAIL.SETCOLUMN(″kcrkd2_pch″)
AW.DW_DETAIL.SETTEXT(LS_PH)
AW.DW_DETAIL.SETCOLUMN(″kcrkd2_fsssl1″)
AW.DW_DETAIL.SETTEXT(STRING(LD_SL))
AW.DW_DETAIL.ACCEPTTEXT()
loop
return?ll_count
Method of the present invention successfully has been used for tide ERP-PS pharmacy version, and the standard to outside WMS interface is provided, and uses successfully in the tiered warehouse facility management of pharmacy corporation.
Application by present technique, can under the mode of not revising the ERP code fully, realize the interface of ERP system with WMS, effectively guaranteed the subsequent upgrade of ERP system, because adopt and to call the mode of ERP interface data typing, carry out the upgrading of little version in ERP system after the corresponding interface program do not need to make amendment.
This technology can continue on for solving the processing of the WMS of each producer interface among the ERP, and can further be applied to the interface processing of ERP with other related systems.
When the application by present technique had effectively solved the multisystem operation, it was big to influence each other between system, the difficult problem that can't carry out software upgrading smoothly.
The utilization of present technique can realize the interface with the WMS system on the basis of not revising the ERP internal processes, and can be implemented under the situation of the little edition upgrading of ERP, the interface content does not need to make amendment, this technology can effectively change in the past by revising the in house software coding and realizes the interface mode of ERP with outside WMS system, has solved because the ERP internal processes is revised the software upgrading that is associated, the maintenance problems that brings.
Claims (1)
1, the interface method of ERP referencing WMS warehousing, it is characterized in that, set up a kind of program extension mechanism, identify the interface content of current ERP operation by external program, and the interface carried out legal judgement, guarantee the legitimacy that external program calls, externally obtain the data that WMS provides by middle table in the program then, be combined to form the information format that ERP needs, the step of going forward side by side realizes the typing of data message with the method for the inside among the ERP, realize that the WMS data importing is to ERP system, because ERP system is not related with external program, so ERP system realizes the independence with interface routine, in the realization of external program because adopted the method for directly calling ERP system internal standard incident, evade the modification of the interface routine that causes because of ERP software maintenance or upgrading, kept the stable of interface; Specifically comprise following content:
1) by in current ERP product is realized, setting up mechanism and the method that external program calls, function is adjusted at the interface of using among the ERP, increase is to the support of button method, permission can be quoted outside overall situation function function through the document interface of the ERP that INTERFACE DESIGN goes out, can reach by quoting of function external program is quoted the into purpose of current software runtime environment;
2) set up overall situation function, realize the processing of interface procedure.In function, by environment measuring, obtain the information of current software runtime environment, judge whether the place of quoting is legal program source, legally the data mode that current WMS transmits middle table into then be set show the data list of being introduced by warehouse-in for reading, merging, obtain the data that user's multiselect returns after, call the rule of warehouse-in interface data typing among the ERP, realize data introducing ERP warehouse-in interface;
3) content of checking before the mode by expansion increases data and preserves judges in the inspection whether the data that are introduced into are consistent with the data of current interface operation, and the short time of realizing tables of data simultaneously is locked to data processing and finishes;
4) method by expansion increases the processing after data are preserved back, deletion, at first removes the associated data message of former warehouse-in in the processing, numbers with the warehouse-in of data according to the mode related update data mode that material adds batch;
The specific implementation step is as follows:
A) on existing ERP basis, set up a kind of external program call method of label form, externally in the program, by environment measuring, obtain the information of current software runtime environment, judge simultaneously whether the place of quoting is legal program source, legal, then externally proceed the Processing Interface content in the program;
B) by the interface data table, quote and lock the WMS data in the scope of quoting, final result is directed into ERP in-stockroom operation interface by the form by material and batch merging, and call ERP interface data processing rule, ERP finally finishes the preservation of data in database, by extendible data check of configuration and contents processing, realize that the state of interface table data upgrades and concurrent access control during preservation;
C) the indicated external function of additional information by element in the dynamic resolution interface, reflect then and call, be implemented in the pattern of carrying out the external code compatibility in the ERP software of curing with the cost of minimum, be implemented on original ERP basis by external code visit ERP internal program assembly and call the WMS system data;
D) set up the interface code that is independent of former ERP system, in the interface of finishing ERP system and WMS system, effectively guarantee the integrality and maintenance upgrade of original ERP system, make fast according to multiple WMS system again simultaneously and adjusting that the lotus root that reduces by two systems that interface causes is right.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910017917A CN101634944A (en) | 2009-08-17 | 2009-08-17 | Interface method for ERP referencing WMS warehousing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910017917A CN101634944A (en) | 2009-08-17 | 2009-08-17 | Interface method for ERP referencing WMS warehousing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101634944A true CN101634944A (en) | 2010-01-27 |
Family
ID=41594141
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910017917A Pending CN101634944A (en) | 2009-08-17 | 2009-08-17 | Interface method for ERP referencing WMS warehousing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101634944A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106484778A (en) * | 2016-09-14 | 2017-03-08 | 深圳中兴网信科技有限公司 | Material distribution method and material dispensing device based on SOA |
| WO2018000622A1 (en) * | 2016-06-28 | 2018-01-04 | 乐视控股（北京）有限公司 | Wms system and erp system synchronization method and system |
-
2009
- 2009-08-17 CN CN200910017917A patent/CN101634944A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2018000622A1 (en) * | 2016-06-28 | 2018-01-04 | 乐视控股（北京）有限公司 | Wms system and erp system synchronization method and system |
| CN106484778A (en) * | 2016-09-14 | 2017-03-08 | 深圳中兴网信科技有限公司 | Material distribution method and material dispensing device based on SOA |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102939612B (en) | The method and system of the amendment to user interface components is merged in the user-defined situation of protection | |
| CN110603554A (en) | Method and system for offline data transfer via machine-readable code | |
| US8689231B2 (en) | System and method for ordering tasks with complex interrelationships | |
| CN101101649B (en) | Method and system for managing data in a workflow process | |
| EP1868087B1 (en) | System and method for configuration application programs | |
| CN101772764B (en) | Multi-threaded business programming library | |
| Zimmermann | Architectural decisions as reusable design assets | |
| US9146735B2 (en) | Associating workflows with code sections in a document control system | |
| US9063711B2 (en) | Software engineering system and method for self-adaptive dynamic software components | |
| EP2650783A1 (en) | On-demand database service system, method, and computer program product for verifying that a developed application will operate properly with at least one other application | |
| CN105022628B (en) | A kind of expansible software application platform | |
| CN102609279A (en) | Application execution in a restricted application execution environment | |
| CN103019718A (en) | Use of distributed source control in centralized source control environment | |
| CN110457666B (en) | Report generation method, system, electronic equipment and storage medium | |
| CN1755620A (en) | Workflow schedule authoring tool | |
| CN102810057A (en) | Log recording method | |
| CN102402451A (en) | Compile-time bounds checking for user-defined types | |
| US20170351506A1 (en) | Automating feature graduation | |
| US8566780B2 (en) | Object model based mapping | |
| US20160352707A1 (en) | Content Protection for Extract, Transform, Load (ETL) Scripts | |
| CN101634944A (en) | Interface method for ERP referencing WMS warehousing | |
| US20090024424A1 (en) | System and method for dynamic linking of business processes | |
| CN104731765A (en) | Resolving Content Editing Conflicts Arising From Concurrent Drafts | |
| CN104662573A (en) | Bidirectional synchronization of communications and CRM applications | |
| US8312013B1 (en) | On-demand service system, method and computer program product for linking a custom share row cause to a sharing record associated with a custom object |
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 |
Open date: 20100127 |