dsba220.xsd

通用进销存-visual basic编写

<?xml version="1.0" standalone="yes"?>
<xs:schema id="dsBA220" targetNamespace="http://www.tempuri.org/dsBA220.xsd" xmlns:mstns="http://www.tempuri.org/dsBA220.xsd" xmlns="http://www.tempuri.org/dsBA220.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:element name="dsBA220" msdata:IsDataSet="true">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded">
        <xs:element name="Customer">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerID" type="xs:string" />
              <xs:element name="CustomerAttribName" type="xs:string" />
              <xs:element name="CustomerName" type="xs:string" minOccurs="0" />
              <xs:element name="InvoiceNo" type="xs:string" minOccurs="0" />
              <xs:element name="Owner" type="xs:string" minOccurs="0" />
              <xs:element name="RocID" type="xs:string" minOccurs="0" />
              <xs:element name="ContactMan1" type="xs:string" minOccurs="0" />
              <xs:element name="ContactMan2" type="xs:string" minOccurs="0" />
              <xs:element name="ContactPhone1" type="xs:string" minOccurs="0" />
              <xs:element name="ContactPhone2" type="xs:string" minOccurs="0" />
              <xs:element name="Fax" type="xs:string" minOccurs="0" />
              <xs:element name="SalesManID" type="xs:string" />
              <xs:element name="CustomerAddress" type="xs:string" minOccurs="0" />
              <xs:element name="DeliveryAddress" type="xs:string" minOccurs="0" />
              <xs:element name="InvoiceAddress" type="xs:string" minOccurs="0" />
              <xs:element name="PayDays" type="xs:decimal" />
              <xs:element name="CreditLine" type="xs:decimal" />
              <xs:element name="CreditBalance" type="xs:decimal" minOccurs="0" />
              <xs:element name="LastDeliveryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Advance" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SalesMan">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SalesManID" type="xs:string" />
              <xs:element name="ChineseName" type="xs:string" />
              <xs:element name="EnglishName" type="xs:string" minOccurs="0" />
              <xs:element name="ContactPhone" type="xs:string" minOccurs="0" />
              <xs:element name="MobilePhone" type="xs:string" minOccurs="0" />
              <xs:element name="ContactAddress" type="xs:string" minOccurs="0" />
              <xs:element name="EMail" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customer" />
      <xs:field xpath="mstns:CustomerID" />
    </xs:unique>
    <xs:unique name="SalesMan_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SalesMan" />
      <xs:field xpath="mstns:SalesManID" />
    </xs:unique>
  </xs:element>
</xs:schema>