DataService


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

ExecuteSQL

Excute any sql commands,return affected line count.

测试

测试窗体只能用于使用基元类型作为参数的方法。

SOAP 1.1

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

POST /DevSuiteAdminService/DataService.asmx HTTP/1.1
Host: bestbuy.devsuite.cn
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.techexcel.com/txwebservice/ExecuteSQL"

<?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:Header>
    <SoapHeaderDatas xmlns="http://www.techexcel.com/txwebservice/">
      <IsAdmin>int</IsAdmin>
      <IsCheckOut>int</IsCheckOut>
      <EnableStaging>int</EnableStaging>
      <IsStaging>int</IsStaging>
      <StrExt>string</StrExt>
      <UserName>string</UserName>
      <Password>string</Password>
      <EnableCompression>int</EnableCompression>
      <ProductType>int</ProductType>
      <IsHosting>int</IsHosting>
      <PersonID>int</PersonID>
      <ProjectID>int</ProjectID>
      <PageID>int</PageID>
      <CustomerID>string</CustomerID>
    </SoapHeaderDatas>
  </soap:Header>
  <soap:Body>
    <ExecuteSQL xmlns="http://www.techexcel.com/txwebservice/">
      <Username>string</Username>
      <Password>string</Password>
      <sqlcmd>base64Binary</sqlcmd>
    </ExecuteSQL>
  </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>
    <ExecuteSQLResponse xmlns="http://www.techexcel.com/txwebservice/">
      <ExecuteSQLResult>
        <ErrorType>int</ErrorType>
        <ErrorID>int</ErrorID>
        <ReturnMessage>string</ReturnMessage>
        <XMLData>base64Binary</XMLData>
        <XMLSchema>base64Binary</XMLSchema>
        <TableName>string</TableName>
        <IsDataCompressed>int</IsDataCompressed>
        <IsSchemaCompressed>int</IsSchemaCompressed>
        <SqlCommand>string</SqlCommand>
      </ExecuteSQLResult>
    </ExecuteSQLResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

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

POST /DevSuiteAdminService/DataService.asmx HTTP/1.1
Host: bestbuy.devsuite.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:Header>
    <SoapHeaderDatas xmlns="http://www.techexcel.com/txwebservice/">
      <IsAdmin>int</IsAdmin>
      <IsCheckOut>int</IsCheckOut>
      <EnableStaging>int</EnableStaging>
      <IsStaging>int</IsStaging>
      <StrExt>string</StrExt>
      <UserName>string</UserName>
      <Password>string</Password>
      <EnableCompression>int</EnableCompression>
      <ProductType>int</ProductType>
      <IsHosting>int</IsHosting>
      <PersonID>int</PersonID>
      <ProjectID>int</ProjectID>
      <PageID>int</PageID>
      <CustomerID>string</CustomerID>
    </SoapHeaderDatas>
  </soap12:Header>
  <soap12:Body>
    <ExecuteSQL xmlns="http://www.techexcel.com/txwebservice/">
      <Username>string</Username>
      <Password>string</Password>
      <sqlcmd>base64Binary</sqlcmd>
    </ExecuteSQL>
  </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>
    <ExecuteSQLResponse xmlns="http://www.techexcel.com/txwebservice/">
      <ExecuteSQLResult>
        <ErrorType>int</ErrorType>
        <ErrorID>int</ErrorID>
        <ReturnMessage>string</ReturnMessage>
        <XMLData>base64Binary</XMLData>
        <XMLSchema>base64Binary</XMLSchema>
        <TableName>string</TableName>
        <IsDataCompressed>int</IsDataCompressed>
        <IsSchemaCompressed>int</IsSchemaCompressed>
        <SqlCommand>string</SqlCommand>
      </ExecuteSQLResult>
    </ExecuteSQLResponse>
  </soap12:Body>
</soap12:Envelope>

HTTP GET

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

GET /DevSuiteAdminService/DataService.asmx/ExecuteSQL?Username=string&Password=string&sqlcmd=string&sqlcmd=string HTTP/1.1
Host: bestbuy.devsuite.cn
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<RetStruct xmlns="http://www.techexcel.com/txwebservice/">
  <ErrorType>int</ErrorType>
  <ErrorID>int</ErrorID>
  <ReturnMessage>string</ReturnMessage>
  <XMLData>base64Binary</XMLData>
  <XMLSchema>base64Binary</XMLSchema>
  <TableName>string</TableName>
  <IsDataCompressed>int</IsDataCompressed>
  <IsSchemaCompressed>int</IsSchemaCompressed>
  <SqlCommand>string</SqlCommand>
</RetStruct>

HTTP POST

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

POST /DevSuiteAdminService/DataService.asmx/ExecuteSQL HTTP/1.1
Host: bestbuy.devsuite.cn
Content-Type: application/x-www-form-urlencoded
Content-Length: length

Username=string&Password=string&sqlcmd=string&sqlcmd=string
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<RetStruct xmlns="http://www.techexcel.com/txwebservice/">
  <ErrorType>int</ErrorType>
  <ErrorID>int</ErrorID>
  <ReturnMessage>string</ReturnMessage>
  <XMLData>base64Binary</XMLData>
  <XMLSchema>base64Binary</XMLSchema>
  <TableName>string</TableName>
  <IsDataCompressed>int</IsDataCompressed>
  <IsSchemaCompressed>int</IsSchemaCompressed>
  <SqlCommand>string</SqlCommand>
</RetStruct>