PosWebService Web 服务

PosWebService

单击此处，获取完整的操作列表。

ExecSQL

Exec sql语句返回json: 适用于一个SQL语句 1成功　0不成功 msg　影响行数

测试

若要使用 HTTP POST 协议对操作进行测试，请单击“调用”按钮。

SOAP 1.1

以下是 SOAP 1.2 请求和响应示例。所显示的占位符需替换为实际值。

POST /PosWebService.asmx HTTP/1.1
Host: www.dxqyvip.cn
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://tempuri.org/ExecSQL"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <ExecSQL xmlns="http://tempuri.org/">
      <checktxt>string</checktxt>
      <sSQL>string</sSQL>
      <sDBNAME>string</sDBNAME>
    </ExecSQL>
  </soap:Body>
</soap:Envelope>

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <ExecSQLResponse xmlns="http://tempuri.org/">
      <ExecSQLResult>string</ExecSQLResult>
    </ExecSQLResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

以下是 SOAP 1.2 请求和响应示例。所显示的占位符需替换为实际值。

POST /PosWebService.asmx HTTP/1.1
Host: www.dxqyvip.cn
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <ExecSQL xmlns="http://tempuri.org/">
      <checktxt>string</checktxt>
      <sSQL>string</sSQL>
      <sDBNAME>string</sDBNAME>
    </ExecSQL>
  </soap12:Body>
</soap12:Envelope>

HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <ExecSQLResponse xmlns="http://tempuri.org/">
      <ExecSQLResult>string</ExecSQLResult>
    </ExecSQLResponse>
  </soap12:Body>
</soap12:Envelope>

HTTP GET

以下是 HTTP GET 请求和响应示例。所显示的占位符需替换为实际值。

GET /PosWebService.asmx/ExecSQL?checktxt=string&sSQL=string&sDBNAME=string HTTP/1.1
Host: www.dxqyvip.cn

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<string xmlns="http://tempuri.org/">string</string>

HTTP POST

以下是 HTTP POST 请求和响应示例。所显示的占位符需替换为实际值。

POST /PosWebService.asmx/ExecSQL HTTP/1.1
Host: www.dxqyvip.cn
Content-Type: application/x-www-form-urlencoded
Content-Length: length

checktxt=string&sSQL=string&sDBNAME=string

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<string xmlns="http://tempuri.org/">string</string>

参数	值
checktxt:
sSQL:
sDBNAME: