DataService
单击此处,获取完整的操作列表。
GetDataFromDatabase
Select rowsets from database
测试
测试窗体只能用于使用基元类型作为参数的方法。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/GetDataFromDatabase" <?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> <GetDataFromDatabase xmlns="http://www.techexcel.com/txwebservice/"> <Username>string</Username> <Password>string</Password> <sqlcmdbytes>base64Binary</sqlcmdbytes> <PageSize>int</PageSize> <CurrentPage>int</CurrentPage> <NeedCompress>int</NeedCompress> </GetDataFromDatabase> </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> <GetDataFromDatabaseResponse xmlns="http://www.techexcel.com/txwebservice/"> <GetDataFromDatabaseResult> <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> </GetDataFromDatabaseResult> </GetDataFromDatabaseResponse> </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:Body> <GetDataFromDatabase xmlns="http://www.techexcel.com/txwebservice/"> <Username>string</Username> <Password>string</Password> <sqlcmdbytes>base64Binary</sqlcmdbytes> <PageSize>int</PageSize> <CurrentPage>int</CurrentPage> <NeedCompress>int</NeedCompress> </GetDataFromDatabase> </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> <GetDataFromDatabaseResponse xmlns="http://www.techexcel.com/txwebservice/"> <GetDataFromDatabaseResult> <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> </GetDataFromDatabaseResult> </GetDataFromDatabaseResponse> </soap12:Body> </soap12:Envelope>
HTTP GET
以下是 HTTP GET 请求和响应示例。所显示的占位符需替换为实际值。
GET /DevSuiteAdminService/DataService.asmx/GetDataFromDatabase?Username=string&Password=string&sqlcmdbytes=string&sqlcmdbytes=string&PageSize=string&CurrentPage=string&NeedCompress=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/GetDataFromDatabase HTTP/1.1 Host: bestbuy.devsuite.cn Content-Type: application/x-www-form-urlencoded Content-Length: length Username=string&Password=string&sqlcmdbytes=string&sqlcmdbytes=string&PageSize=string&CurrentPage=string&NeedCompress=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>