dataset1.xsd

用vb.net写的基于c/s结构的进销存程序设计源代码

<?xml version="1.0" standalone="yes"?>
<xs:schema id="DataSet1" targetNamespace="http://www.tempuri.org/DataSet1.xsd" xmlns:mstns="http://www.tempuri.org/DataSet1.xsd" xmlns="http://www.tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
    <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:Locale="zh-TW">
        <xs:complexType>
            <xs:choice maxOccurs="unbounded">
                <xs:element name="Customer">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element name="CustomerID" type="xs:string" />
                            <xs:element name="AttribName" type="xs:string" />
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
                <xs:element name="OrderDetails">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element name="OrderID" type="xs:string" />
                            <xs:element name="ProductID" type="xs:string" />
                            <xs:element name="Quantity" type="xs:int" />
                            <xs:element name="UnitPrice" type="xs:int" />
                            <xs:element name="DetailAmount" type="xs:int" minOccurs="0" />
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
                <xs:element name="Orders">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element name="OrderID" type="xs:string" />
                            <xs:element name="OrderDate" type="xs:dateTime" />
                            <xs:element name="CustomerID" type="xs:string" minOccurs="0" />
                            <xs:element name="SubTotal" type="xs:int" minOccurs="0" />
                            <xs:element name="Tax" type="xs:int" minOccurs="0" />
                            <xs:element name="Amount" type="xs:int" 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="OrderDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
            <xs:selector xpath=".//mstns:OrderDetails" />
            <xs:field xpath="mstns:OrderID" />
            <xs:field xpath="mstns:ProductID" />
        </xs:unique>
        <xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
            <xs:selector xpath=".//mstns:Orders" />
            <xs:field xpath="mstns:OrderID" />
        </xs:unique>
        <xs:keyref name="OrdersOrderDetails" refer="mstns:Orders_Constraint1" msdata:DeleteRule="Cascade" msdata:UpdateRule="Cascade">
            <xs:selector xpath=".//mstns:OrderDetails" />
            <xs:field xpath="mstns:OrderID" />
        </xs:keyref>
    </xs:element>
</xs:schema>