WebService
单击此处,获取完整的操作列表。
QueryScalar
执行查询SQL,仅返回第一行第一列值
测试
测试窗体只能用于来自本地计算机的请求。SOAP 1.1
以下是 SOAP 1.2 请求和响应示例。所显示的占位符需替换为实际值。
POST /Mbm.Web/WebService.asmx HTTP/1.1
Host: erp.thefaithmind.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://fafa.com.cn/QueryScalar"
<?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>
<QueryScalar xmlns="http://fafa.com.cn/">
<SqlText>string</SqlText>
<Params>
<anyType />
<anyType />
</Params>
<DbType>string</DbType>
<DbConn>string</DbConn>
</QueryScalar>
</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>
<QueryScalarResponse xmlns="http://fafa.com.cn/">
<QueryScalarResult>string</QueryScalarResult>
</QueryScalarResponse>
</soap:Body>
</soap:Envelope>
SOAP 1.2
以下是 SOAP 1.2 请求和响应示例。所显示的占位符需替换为实际值。
POST /Mbm.Web/WebService.asmx HTTP/1.1
Host: erp.thefaithmind.com
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>
<QueryScalar xmlns="http://fafa.com.cn/">
<SqlText>string</SqlText>
<Params>
<anyType />
<anyType />
</Params>
<DbType>string</DbType>
<DbConn>string</DbConn>
</QueryScalar>
</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>
<QueryScalarResponse xmlns="http://fafa.com.cn/">
<QueryScalarResult>string</QueryScalarResult>
</QueryScalarResponse>
</soap12:Body>
</soap12:Envelope>