☰

企业官网建设流程全解析

首页 / 建站日记 / 企业官网建设流程全解析
08.06.01.tiptop webserver接口篇（收集接口:查询接口）
2026/7/12 21:10:38 网站建设 项目流程
  • 1、EF OA的接口
    • 测试区：http://erp2.waichi.com/web/ws/r/aws_efsrv_toptest?wsdl
    • 正式区：http://erp2.waichi.com/web/ws/r/aws_efsrv?wsdl
  • 2、ERP日常接口
    • 测试区：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 正式区：http://erp.waichi.com/web/ws/r/aws_ttsrv2?wsdl
  • 3、字段说明
    • user：erp账号
    • password：erp的密码
    • application：呼叫端系統代號
      • 后台代码：g_access.application 可以获取
    • source：呼叫端來源 IP or Host
    • Organization: 填写ERP运营中心代号
    • language：zh_tw(繁體) / zh_cn(簡體) / en_us(英文)

本页目录：

  • 1、单表查询
    • 1.1、ima_file
    • 1.2、smy_file
    • 1.3、pmc_file
    • 1.4、gen_file
    • 1.5、gem_file
    • 1.6、gec_file
    • 1.7、azi_file
    • 1.8、mse_file
  • 2、多表查询
    • pja_file(一) 对 pjb_file（多）
  • 3、自定义查询

单表查询

  • 使用Apipost工具进行http接口访问

ima_file

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • GetItemData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_item_data.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetItemDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="ima01 = 'FFB-WS8762NNN-05'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetItemDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

smy_file

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • GetMFGDocument接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_mfg_document.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetMFGDocumentRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="1=1"/><Fieldname="sys"value="asf"/><Fieldname="kind"value="1"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetMFGDocumentRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

pmc_file

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • GetSupplierData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_supplier_data.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetSupplierDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="pmc01 LIKE 'WC-%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetSupplierDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

gen_file

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • GetEmployeeData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_employee_data.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetEmployeeDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="gen01 LIKE 'BL076%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetEmployeeDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

gem_file

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • GetEmployeeData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_department_data.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetDepartmentDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="gem01 LIKE 'NFC%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetDepartmentDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

gec_file

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • GetTaxTypeData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_tax_type_data.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetTaxTypeDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="gec01 LIKE 'T1%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetTaxTypeDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

azi_file

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • GetCurrencyData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_currency_data.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetCurrencyDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="azi01 LIKE '%B%'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetCurrencyDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

mse_file

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • GetBrandData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_brand_data.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetBrandDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="mse01 LIKE '%' "/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetBrandDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

多表查询

pja_file(一) 对 pjb_file（多）

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • GetProjectWBSData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_get_project_wbs_data.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:GetProjectWBSDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="condition"value="pja01='2015ITEM06' AND pjb02='0043-0001-0002'"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:GetProjectWBSDataRequest></soapenv:Body></soapenv:Envelope>

‵说明：Field标签key是condition的value可模糊查询 value=“xxx LIKE ‘xxx%’” `

自定义查询

  • 源代码：
    • 注册服务接口案例：/u1/topprod/tiptop/aws/4gl/aws_ttsrv2_service.4gl
    • CustomizeQueryData接口案例代码：/u1/topprod/tiptop/aws/4gl/aws_customize_query_data.4gl
  • 请求参数
    • url：http://erp2.waichi.com/web/ws/r/aws_ttsrv2_toptest?wsdl
    • 请求方式：POST
    • Header
Content-Type:text/xml;charset=UTF-8 SOAPAction:""
- Body - raw 选xml
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:tip="http://www.dsc.com.tw/tiptop/TIPTOPServiceGateWay"><soapenv:Header/><soapenv:Body><tip:CustomizeQueryDataRequest><tip:request><![CDATA[<Request><Access><Authenticationuser="xxx"password="xxxx"/><Connectionapplication="tiptop"source="erp2.waichi.com"/><Organizationname="BLPROD"/><Localelanguage="zh_tw"/></Access><RequestContent><Parameter><Record><Fieldname="setFields"value="pmn33,pmn01,pmn02,pmn09,pmn37,pmnud10"/><Fieldname="setSql"value="SELECT pmn33,pmn01,pmn02,pmn09,pmn37,pmnud10 FROM pmn_file WHERE pmn01 ='VFU22-22100017' AND pmn02 IN ('1','2','3') "/><Fieldname="setType"value="Single"/></Record></Parameter><Document /></RequestContent></Request>]]></tip:request></tip:CustomizeQueryDataRequest></soapenv:Body></soapenv:Envelope>
标签： 网站建设 企业官网 项目流程 UI设计 前端开发

热门文章

文章分类

标签云

网站建设 响应式设计 用户体验 SEO优化 前端开发 小程序 电商平台 性能优化

相关文章

您可能感兴趣的其他内容

需要专业的网站建设服务？

联系我们获取免费的网站建设咨询和方案报价，让我们帮助您实现业务目标

立即咨询