nwordersws.wsdl

来自「wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重」· WSDL 代码 · 共 465 行 · 第 1/2 页

<?xml version="1.0" encoding="utf-8"?>
<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://oakleaf.ws/webservices/nwordersws" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" targetNamespace="http://oakleaf.ws/webservices/nwordersws" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
  <wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">This demonstration XML Web service connects to a local Northwind SQL Server database and has Web methods for retrieving and creating or updating Orders and Order Details records with stored procedures. It also has methods for creating Microsoft Office InfoPath 2003 secondary data sources to populate drop-down lists. Examples in "Introducing Microsoft Office InfoPath 2003" (Microsoft Press, ISBN 0-7356-1952-2, published 6/9/2004) show you how to design InfoPath forms that consume NWOrdersWS's Web methods. You can read more about this Web service at http://www.oakleaf.ws/infopath/nworders.aspx. You can also use the MSDE 2000 NorthwindCS database or a Northwind sample database that runs under SQL Server 2005 or SQL Server Express.</wsdl:documentation>
  <wsdl:types>
    <s:schema elementFormDefault="qualified" targetNamespace="http://oakleaf.ws/webservices/nwordersws">
      <s:element name="GetOrderSP">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="1" maxOccurs="1" name="intOrderID" type="s:int" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:element name="GetOrderSPResponse">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="0" maxOccurs="1" name="GetOrderSPResult" type="tns:clsOrder" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:complexType name="clsOrder">
        <s:sequence>
          <s:element minOccurs="1" maxOccurs="1" name="OrderID" type="s:int" />
          <s:element minOccurs="0" maxOccurs="1" name="CustomerID" type="s:string" />
          <s:element minOccurs="1" maxOccurs="1" name="EmployeeID" type="s:int" />
          <s:element minOccurs="1" maxOccurs="1" name="OrderDate" type="s:dateTime" />
          <s:element minOccurs="1" maxOccurs="1" name="RequiredDate" type="s:dateTime" />
          <s:element minOccurs="1" maxOccurs="1" name="ShippedDate" type="s:dateTime" />
          <s:element minOccurs="1" maxOccurs="1" name="ShipVia" type="s:int" />
          <s:element minOccurs="1" maxOccurs="1" name="Freight" type="s:decimal" />
          <s:element minOccurs="0" maxOccurs="1" name="ShipName" type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="ShipAddress" type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="ShipCity" type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="ShipRegion" type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="ShipPostalCode" type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="ShipCountry" type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="OrderDetails" type="tns:ArrayOfOrderDetail" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="ArrayOfOrderDetail">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="unbounded" name="OrderDetail" nillable="true" type="tns:OrderDetail" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="OrderDetail">
        <s:sequence>
          <s:element minOccurs="1" maxOccurs="1" name="OrderID" type="s:int" />
          <s:element minOccurs="1" maxOccurs="1" name="ProductID" type="s:int" />
          <s:element minOccurs="1" maxOccurs="1" name="UnitPrice" type="s:decimal" />
          <s:element minOccurs="1" maxOccurs="1" name="Quantity" type="s:short" />
          <s:element minOccurs="1" maxOccurs="1" name="Discount" type="s:decimal" />
        </s:sequence>
      </s:complexType>
      <s:element name="UpdateOrInsertOrderSP">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="0" maxOccurs="1" name="objOrder" type="tns:clsOrder" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:element name="UpdateOrInsertOrderSPResponse">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="1" maxOccurs="1" name="UpdateOrInsertOrderSPResult" type="s:int" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:element name="GetLast10Orders">
        <s:complexType />
      </s:element>
      <s:element name="GetLast10OrdersResponse">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="0" maxOccurs="1" name="GetLast10OrdersResult" type="tns:ArrayOfInt" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:complexType name="ArrayOfInt">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="unbounded" name="int" type="s:int" />
        </s:sequence>
      </s:complexType>
      <s:element name="GetEmployees">
        <s:complexType />
      </s:element>
      <s:element name="GetEmployeesResponse">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="0" maxOccurs="1" name="GetEmployeesResult" type="tns:empLookup" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:complexType name="empLookup">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="1" name="employees" type="tns:ArrayOfEmployee" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="ArrayOfEmployee">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="unbounded" name="employee" nillable="true" type="tns:employee" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="employee">
        <s:sequence>
          <s:element minOccurs="1" maxOccurs="1" name="emplID" type="s:int" />
          <s:element minOccurs="0" maxOccurs="1" name="emplName" type="s:string" />
        </s:sequence>
      </s:complexType>
      <s:element name="GetShippers">
        <s:complexType />
      </s:element>
      <s:element name="GetShippersResponse">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="0" maxOccurs="1" name="GetShippersResult" type="tns:shipLookup" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:complexType name="shipLookup">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="1" name="shippers" type="tns:ArrayOfShipper" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="ArrayOfShipper">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="unbounded" name="shipper" nillable="true" type="tns:shipper" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="shipper">
        <s:sequence>
          <s:element minOccurs="1" maxOccurs="1" name="shipID" type="s:int" />
          <s:element minOccurs="0" maxOccurs="1" name="shipName" type="s:string" />
        </s:sequence>
      </s:complexType>
      <s:element name="GetProducts">
        <s:complexType />
      </s:element>
      <s:element name="GetProductsResponse">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="0" maxOccurs="1" name="GetProductsResult" type="tns:prodLookup" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:complexType name="prodLookup">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="1" name="products" type="tns:ArrayOfProduct" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="ArrayOfProduct">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="unbounded" name="product" nillable="true" type="tns:product" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="product">
        <s:sequence>
          <s:element minOccurs="1" maxOccurs="1" name="prodID" type="s:int" />
          <s:element minOccurs="0" maxOccurs="1" name="prodName" type="s:string" />
        </s:sequence>
      </s:complexType>
      <s:element name="GetProductsDetailed">
        <s:complexType />
      </s:element>
      <s:element name="GetProductsDetailedResponse">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="0" maxOccurs="1" name="GetProductsDetailedResult" type="tns:prodLookupDtl" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:complexType name="prodLookupDtl">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="1" name="productsDtl" type="tns:ArrayOfProductDtl" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="ArrayOfProductDtl">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="unbounded" name="productDtl" nillable="true" type="tns:productDtl" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="productDtl">
        <s:sequence>
          <s:element minOccurs="1" maxOccurs="1" name="prodID" type="s:int" />
          <s:element minOccurs="0" maxOccurs="1" name="prodName" type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="prodSKU" type="s:string" />
          <s:element minOccurs="1" maxOccurs="1" name="prodPrice" type="s:double" />
        </s:sequence>
      </s:complexType>
      <s:element name="GetCustomers">
        <s:complexType />
      </s:element>
      <s:element name="GetCustomersResponse">
        <s:complexType>
          <s:sequence>
            <s:element minOccurs="0" maxOccurs="1" name="GetCustomersResult" type="tns:custLookup" />
          </s:sequence>
        </s:complexType>
      </s:element>
      <s:complexType name="custLookup">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="1" name="customers" type="tns:ArrayOfCustomer" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="ArrayOfCustomer">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="unbounded" name="customer" nillable="true" type="tns:customer" />
        </s:sequence>
      </s:complexType>
      <s:complexType name="customer">
        <s:sequence>
          <s:element minOccurs="0" maxOccurs="1" name="custID" type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="custName" type="s:string" />
        </s:sequence>
      </s:complexType>
    </s:schema>
  </wsdl:types>
  <wsdl:message name="GetOrderSPSoapIn">
    <wsdl:part name="parameters" element="tns:GetOrderSP" />
  </wsdl:message>
  <wsdl:message name="GetOrderSPSoapOut">
    <wsdl:part name="parameters" element="tns:GetOrderSPResponse" />
  </wsdl:message>
  <wsdl:message name="UpdateOrInsertOrderSPSoapIn">
    <wsdl:part name="parameters" element="tns:UpdateOrInsertOrderSP" />
  </wsdl:message>
  <wsdl:message name="UpdateOrInsertOrderSPSoapOut">
    <wsdl:part name="parameters" element="tns:UpdateOrInsertOrderSPResponse" />
  </wsdl:message>
  <wsdl:message name="GetLast10OrdersSoapIn">
    <wsdl:part name="parameters" element="tns:GetLast10Orders" />
  </wsdl:message>
  <wsdl:message name="GetLast10OrdersSoapOut">
    <wsdl:part name="parameters" element="tns:GetLast10OrdersResponse" />
  </wsdl:message>