参考02.基于tcp协议的zebra和ebs集成方案开发指导

1、系统集成方案基于TCP/IP协议的Zebra与EBS集成开发指导文档Author:Creation Date: Last Updated:Fuliang.liuNovember 13, 2012November 13, 2012Ref:Ver:Approvals: November 13, 2012ControlChange RecordReviewersDistributionNote To Holders:If you receive an electronic copy of thisand prit out, please write yourname on the equivalen

2、t of the covage, forcontrol pures.If you receive acover, forof thiscontrol pur, please write your name on the frontes.Companyne tnroall usiei onlyCopy No.NameLocation1234NameitionDateAuthorVerChange Reference13 Nov 12Fuliang.liuDraft 1aNo PreviousNovember 13, 2012ContentsControlii简介11.开发准备22.1.开发工具2

3、开发流程32.3.开发例子(Item Label打印)4Zebra设计4PL/SQL开发8并发定义9打印测试94.5.Open and Closed Ies for this Deliverable10Open IClosed Ies10es10Companyretrrnoal l uisiei only1.简介本文档用于指导基于TCP/IP协议的Zebra集成开发。首次开发需要按照” 安装配置.doc”配置开发环境。November 13, 20122.开发准备2.1.开发工具2.1.1.ZebraDesignerurl:htdesigner.html/us/en/products-serv

4、i/software/design-software/zebra-2.1.2.PL/SQL Developer略发Fo准rCompanyern2aol fu1s3e onlyNovember 13, 20123.开发流程发Fo流rern3aol fu1s3e onlyCompanyZebra与Oracle集成开发流程November 13, 20124.开发例子(Item Label打印)4.1.Zebra设计4.1.1.量取纸的规格4.1.2.打开Zebra设计器略4.1.3.设置Step1Comp开an发ybeFl打orern4aol fu1s3e only参数值属性ZDesigner Z

5、M400 300 dpi (ZPL)规格值Width10CMHeight5CMNovember 13, 2012Step2Step3Comp开an发ybeFl打orern5aol fu1s3e only参数值宽度10高度5November 13, 2012Step4Step54.1.4.设计1. 使用设计器的, 设计样式Comp开an发ybeFl打orern6aol fu1s3e onlyNovember 13, 20122. 动态字段用&FILEDX&预留起来, 方便后续进行替换打印为ZPL语言4.1.5.Comp开an发ybeFl打orern7aol fu1s3e onlyNovember

6、 13, 20124.1.6.查看打印结果将红框部分的内容删除后备份起来给PL/SQL使用4.2.PL/SQL开发4.2.1.创建PKG(cux zbr item label prpkg)使用汉得框架程序创建Concurrent Package: cux zbritem label prpkg4.2.2.创建Procedure(creaabel page)able page 过程将所有的动态数据作为参数输入crea同时将生成ZPL作为CLOB变量输出4.2.3.创建Procedure(Prlabel)将CLOB作为参数调用本框架提供的API, 将打印内容传递给Zebraheb tcp pub.

7、send request(p init msg list = fnd api.g false,p commit= fnd api.g false, xx xreturn sus = x return sus,msg count= x msg count,msg data= x msg data,p function code = p function code,p req bod clob = p req bod clob, x resp bod clob = x resp bod clob, x req inst id = x req inst id,x resp inst id = x r

8、esp inst id);heb pub.raise error(x return sus);4.2.4.创建Procedure(Pr2zbr)将待打印的数据整理起来, 按业务数据将每张分别调用 creaabel page来创建页Comp开an发ybeFl打orern8aol fu1s3e onlyNovember 13, 20124.2.5.参考代码.codeZBR 004 Item Labelpackagecux zbr item label prpkg.pck4.3.并发定义4.3.1.定义可执行将cux zbr item label prpkg.MAIN定义为可执行4.3.2.定义程序

9、定义程序, 可执行选选择4.3.1中定义的代码4.4.打印测试输入参数, 提交请求, 听到嘟嘟, 查看格式和数据是否和预期一致Comp开an发ybeFl打orern9aol fu1s3e only最佳实践November 13, 20125.Open and Closed Ies for this DeliverableAdd open iest you identify while writing or reviewing thisto thees sectionopen ies section. As you resolve ies, move them to the closed ian

10、d keep the ie ID the same. Include an explanation of the resolution.When this deliverable is complete, any open ies should be transferred to theproject- or pros-level Risk and Ie Log (PJM.CR.040) and managed using aproject level Risk and Ie Form (PJM.CR.040). In addition, the open items shouldremainhe open ies section of this deliverable, but flaggedhe resolutioncolumn as being transf