product sales.dsv

来自「< SQL Server2005程序设计>」· DSV 代码 · 共 515 行 · 第 1/4 页

                  </control>
                  <layoutobject>
                    <ddsxmlobj>
                      <property name="LogicalObject" value="dataSet.Relations[FK_SalesOrderHeader_SalesTerritory_TerritoryID]" vartype="8" />
                      <property name="Virtual" value="0" vartype="11" />
                      <property name="VisibleAP" value="0" vartype="3" />
                    </ddsxmlobj>
                  </layoutobject>
                  <connector lineroutestyle="MSDDS.Rectilinear" sourceid="6" destid="4" sourceattachpoint="6" destattachpoint="7" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
                    <point x="2142" y="7400" />
                    <point x="2142" y="6200" />
                    <point x="2143" y="6200" />
                    <point x="2143" y="5000" />
                  </connector>
                </ddscontrol>
                <ddscontrol controlprogid="MSDDS.Polyline" left="13281" top="-4338" logicalid="20" controlid="9" masterid="0" hint1="0" hint2="0" width="799" height="2776" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
                  <control>
                    <ddsxmlobj>
                      <polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
                    </ddsxmlobj>
                  </control>
                  <layoutobject>
                    <ddsxmlobj>
                      <property name="LogicalObject" value="dataSet.Relations[FK_ProductSubcategory_ProductCategory_ProductCategoryID]" vartype="8" />
                      <property name="Virtual" value="0" vartype="11" />
                      <property name="VisibleAP" value="0" vartype="3" />
                    </ddsxmlobj>
                  </layoutobject>
                  <connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="3" sourceattachpoint="0" destattachpoint="3" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
                    <point x="13680" y="-2062" />
                    <point x="13680" y="-2979" />
                    <point x="13701" y="-2979" />
                    <point x="13701" y="-4038" />
                  </connector>
                </ddscontrol>
                <ddscontrol controlprogid="MSDDS.Polyline" left="10640" top="-7112" logicalid="21" controlid="10" masterid="0" hint1="0" hint2="0" width="2424" height="799" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
                  <control>
                    <ddsxmlobj>
                      <polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
                    </ddsxmlobj>
                  </control>
                  <layoutobject>
                    <ddsxmlobj>
                      <property name="LogicalObject" value="dataSet.Relations[FK_Product_ProductSubcategory_ProductSubcategoryID]" vartype="8" />
                      <property name="Virtual" value="0" vartype="11" />
                      <property name="VisibleAP" value="0" vartype="3" />
                    </ddsxmlobj>
                  </layoutobject>
                  <connector lineroutestyle="MSDDS.Rectilinear" sourceid="3" destid="1" sourceattachpoint="14" destattachpoint="19" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
                    <point x="12764" y="-6713" />
                    <point x="11852" y="-6713" />
                    <point x="11852" y="-6712" />
                    <point x="10940" y="-6712" />
                  </connector>
                </ddscontrol>
                <ddscontrol controlprogid="MSDDS.Polyline" left="6708" top="-3611" logicalid="22" controlid="11" masterid="0" hint1="0" hint2="0" width="799" height="3911" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
                  <control>
                    <ddsxmlobj>
                      <polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
                    </ddsxmlobj>
                  </control>
                  <layoutobject>
                    <ddsxmlobj>
                      <property name="LogicalObject" value="dataSet.Relations[SalesOrderDetail-Product]" vartype="8" />
                      <property name="Virtual" value="0" vartype="11" />
                      <property name="VisibleAP" value="0" vartype="3" />
                    </ddsxmlobj>
                  </layoutobject>
                  <connector lineroutestyle="MSDDS.Rectilinear" sourceid="1" destid="5" sourceattachpoint="1" destattachpoint="0" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
                    <point x="7107" y="-3112" />
                    <point x="7107" y="-1504" />
                    <point x="7086" y="-1504" />
                    <point x="7086" y="0" />
                  </connector>
                </ddscontrol>
              </dds>
</DiagramLayout>
            <ShowRelationshipNames>False</ShowRelationshipNames>
            <UseDiagramDefaultLayout>True</UseDiagramDefaultLayout>
            <DiagramViewPortLeft>-1114</DiagramViewPortLeft>
            <DiagramViewPortTop>-13007</DiagramViewPortTop>
            <DiagramBoundingLeft>0</DiagramBoundingLeft>
            <DiagramBoundingTop>0</DiagramBoundingTop>
            <DiagramZoom>75</DiagramZoom>
          </Diagram>
        </Layouts>
      </Value>
    </Annotation>
  </Annotations>
  <DataSourceID>AdventureWorksModel</DataSourceID>
  <Schema>
    <xs:schema id="Adventure_x0020_Works" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
      <xs:element name="Adventure_x0020_Works" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:design-time-name="521eb7ab-8a29-43f8-afc5-8712df71a1e8" msprop:CompareInfo="&lt;CompareInfo&gt;&lt;Culture&gt;en-US&lt;/Culture&gt;&lt;IgnoreCase&gt;true&lt;/IgnoreCase&gt;&lt;IgnoreKanaType&gt;true&lt;/IgnoreKanaType&gt;&lt;IgnoreWidth&gt;true&lt;/IgnoreWidth&gt;&lt;/CompareInfo&gt;">
        <xs:complexType>
          <xs:choice minOccurs="0" maxOccurs="unbounded">
            <xs:element name="Production_Product" msprop:FriendlyName="Product" msprop:DbSchemaName="Production" msprop:DbTableName="Product" msprop:design-time-name="b51dc8fa-6cd1-48dd-a2c7-612190dd67f5" msprop:TableType="Table" msprop:stats_RowCount="504">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0.177642" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ProductID" msprop:design-time-name="664f8d81-c02f-4c87-b97e-4145545674b4" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="504" msprop:stats_AvgWidth="2.984127" msprop:DbColumnName="ProductID" type="xs:int" />
                  <xs:element name="Name" msprop:stats_StDevWidth="6.291431" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="Name" msprop:design-time-name="aa440385-2490-440b-857b-31e78671b803" msprop:stats_MaxWidth="32" msprop:stats_UniqueValueCount="504" msprop:stats_AvgWidth="18.40873" msprop:DbColumnName="Name">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ProductNumber" msprop:stats_StDevWidth="1.420913" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ProductNumber" msprop:design-time-name="97d42ce2-525e-42bb-be86-c5c7d23c2d8a" msprop:stats_MaxWidth="10" msprop:stats_UniqueValueCount="504" msprop:stats_AvgWidth="8.196428" msprop:DbColumnName="ProductNumber">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="25" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="MakeFlag" msprop:stats_UniqueValuePercent="0" msprop:DbColumnName="MakeFlag" msprop:design-time-name="d4abde57-86d7-4df8-a62e-1e4233b90867" msprop:FriendlyName="MakeFlag" msprop:stats_UniqueValueCount="2" type="xs:boolean" />
                  <xs:element name="FinishedGoodsFlag" msprop:stats_UniqueValuePercent="0" msprop:DbColumnName="FinishedGoodsFlag" msprop:design-time-name="55a43ad3-3c9f-4700-bd4c-7b4e8c98c8bc" msprop:FriendlyName="FinishedGoodsFlag" msprop:stats_UniqueValueCount="2" type="xs:boolean" />
                  <xs:element name="Color" msprop:stats_StDevWidth="1.532086" msprop:stats_UniqueValuePercent="3" msprop:FriendlyName="Color" msprop:design-time-name="e35e2906-ba7d-4c66-91ed-49157e45f0b3" msprop:stats_MaxWidth="12" msprop:stats_UniqueValueCount="9" msprop:stats_AvgWidth="5.097656" msprop:DbColumnName="Color" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="SafetyStockLevel" msprop:stats_StDevWidth="0.8615158" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="SafetyStockLevel" msprop:design-time-name="dab32949-a7d3-4680-a067-d1371c9b19da" msprop:stats_MaxWidth="4" msprop:stats_UniqueValueCount="6" msprop:stats_AvgWidth="3.085317" msprop:DbColumnName="SafetyStockLevel" type="xs:short" />
                  <xs:element name="ReorderPoint" msprop:stats_StDevWidth="0.676942" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="ReorderPoint" msprop:design-time-name="2326dddf-3686-45df-b44e-db6fc85353bc" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="6" msprop:stats_AvgWidth="2.583333" msprop:DbColumnName="ReorderPoint" type="xs:short" />
                  <xs:element name="StandardCost" msprop:stats_StDevWidth="1.034936" msprop:stats_AvgScale="1.142857" msprop:stats_UniqueValuePercent="22" msprop:FriendlyName="StandardCost" msprop:design-time-name="9bcae4a3-191d-46c4-a345-bc95e7d2a232" msprop:stats_StDevScale="0.958082" msprop:stats_MaxWidth="7" msprop:stats_UniqueValueCount="114" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="5.021825" msprop:DbColumnName="StandardCost" type="xs:decimal" />
                  <xs:element name="ListPrice" msprop:stats_StDevWidth="1.154111" msprop:stats_AvgScale="1.075397" msprop:stats_UniqueValuePercent="20" msprop:FriendlyName="ListPrice" msprop:design-time-name="b5222759-6f54-414f-ae16-8765c68a481e" msprop:stats_StDevScale="0.9407232" msprop:stats_MaxWidth="7" msprop:stats_UniqueValueCount="103" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="5.172619" msprop:DbColumnName="ListPrice" type="xs:decimal" />
                  <xs:element name="Size" msprop:stats_StDevWidth="0.3548675" msprop:stats_UniqueValuePercent="8" msprop:FriendlyName="Size" msprop:design-time-name="3a0812a0-8d76-4d1b-8411-61cfbcfd3832" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="18" msprop:stats_AvgWidth="1.853081" msprop:DbColumnName="Size" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">