开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > WEB源码(ASP,PHP,...) > 查看源码
Book Sell.dsv
资源名称：BookSellAnalysis.rar　[点击查看]
上传用户：abcs8778
上传日期：2022-08-03
资源大小：2093k
文件大小：23k
源码类别：

WEB源码(ASP,PHP,...)

开发平台：

SQL

Book Sell.dsv：源码内容
  1. <DataSourceView xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="a4c6b0cd-f639-458a-bdf7-e0b616988786" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  2.   <ID>Book Sell</ID>
  3.   <Name>Book Sell</Name>
  4.   <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
  5.   <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
  6.   <Annotations>
  7.     <Annotation>
  8.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>
  9.       <Value>true</Value>
  10.     </Annotation>
  11.     <Annotation>
  12.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CurrentLayout</Name>
  13.       <Value>_ALL_TABLES_</Value>
  14.     </Annotation>
  15.     <Annotation>
  16.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:NameMatchingCriteria</Name>
  17.       <Value>3</Value>
  18.     </Annotation>
  19.     <Annotation>
  20.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:SchemaRestriction</Name>
  21.     </Annotation>
  22.     <Annotation>
  23.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:RetrieveRelationships</Name>
  24.       <Value>true</Value>
  25.     </Annotation>
  26.     <Annotation>
  27.       <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:Layouts</Name>
  28.       <Value>
  29.         <Layouts xmlns="">
  30.           <Diagram>
  31.             <Name>_ALL_TABLES_</Name>
  32.             <DiagramLayout>
  33.               <dds>
  34.                 <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="12" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-210" scrolltop="-244" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="13732" y="16536" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
  35.                   <font>
  36.                     <ddsxmlobjectstreamwrapper binary="018600009001905f010004cbcecce5" />
  37.                   </font>
  38.                   <mouseicon>
  39.                     <ddsxmlobjectstreamwrapper binary="6c74000000000000" />
  40.                   </mouseicon>
  41.                 </diagram>
  42.                 <layoutmanager>
  43.                   <ddsxmlobj />
  44.                 </layoutmanager>
  45.                 <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Customer (dbo.Customer)" left="0" top="0" logicalid="6" controlid="1" masterid="0" hint1="0" hint2="0" width="4324" height="7276" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
  46.                   <control>
  47.                     <ddsxmlobjectstreaminitwrapper binary="00080000e41000006c1c0000" />
  48.                   </control>
  49.                   <layoutobject>
  50.                     <ddsxmlobj>
  51.                       <property name="LogicalObject" value="dbo_Customer" vartype="8" />
  52.                     </ddsxmlobj>
  53.                   </layoutobject>
  54.                   <shape groupshapeid="0" groupnode="0" />
  55.                 </ddscontrol>
  56.                 <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_BookSell (dbo.V_BookSell)" left="4904" top="38" logicalid="7" controlid="2" masterid="0" hint1="0" hint2="0" width="3000" height="5000" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
  57.                   <control>
  58.                     <ddsxmlobjectstreaminitwrapper binary="00080000b80b000088130000" />
  59.                   </control>
  60.                   <layoutobject>
  61.                     <ddsxmlobj>
  62.                       <property name="LogicalObject" value="dbo_V_BookSell" vartype="8" />
  63.                     </ddsxmlobj>
  64.                   </layoutobject>
  65.                   <shape groupshapeid="0" groupnode="0" />
  66.                 </ddscontrol>
  67.                 <ddscontrol controlprogid="MSDDS.Polyline" left="4024" top="-61" logicalid="8" controlid="3" masterid="0" hint1="0" hint2="0" width="1180" 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">
  68.                   <control>
  69.                     <ddsxmlobj>
  70.                       <polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
  71.                     </ddsxmlobj>
  72.                   </control>
  73.                   <layoutobject>
  74.                     <ddsxmlobj>
  75.                       <property name="LogicalObject" value="dataSet.Relations[V_BookSell-Customer]" vartype="8" />
  76.                       <property name="Virtual" value="0" vartype="11" />
  77.                       <property name="VisibleAP" value="0" vartype="3" />
  78.                     </ddsxmlobj>
  79.                   </layoutobject>
  80.                   <connector lineroutestyle="MSDDS.Rectilinear" sourceid="1" destid="2" sourceattachpoint="15" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">
  81.                     <point x="4324" y="338" />
  82.                     <point x="4724" y="338" />
  83.                     <point x="4724" y="338" />
  84.                     <point x="4504" y="338" />
  85.                     <point x="4504" y="338" />
  86.                     <point x="4904" y="338" />
  87.                   </connector>
  88.                 </ddscontrol>
  89.                 <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_Book (dbo.V_Book)" left="31" top="7736" logicalid="9" controlid="4" masterid="0" hint1="0" hint2="0" width="3000" height="5979" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
  90.                   <control>
  91.                     <ddsxmlobjectstreaminitwrapper binary="00080000b80b00005b170000" />
  92.                   </control>
  93.                   <layoutobject>
  94.                     <ddsxmlobj>
  95.                       <property name="LogicalObject" value="dbo_V_Book" vartype="8" />
  96.                     </ddsxmlobj>
  97.                   </layoutobject>
  98.                   <shape groupshapeid="0" groupnode="0" />
  99.                 </ddscontrol>
  100.                 <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="V_WeekSell (dbo.V_WeekSell)" left="5156" top="6873" logicalid="10" controlid="5" masterid="0" hint1="0" hint2="0" width="3000" height="2302" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
  101.                   <control>
  102.                     <ddsxmlobjectstreaminitwrapper binary="00080000b80b0000fe080000" />
  103.                   </control>
  104.                   <layoutobject>
  105.                     <ddsxmlobj>
  106.                       <property name="LogicalObject" value="dbo_V_WeekSell" vartype="8" />
  107.                     </ddsxmlobj>
  108.                   </layoutobject>
  109.                   <shape groupshapeid="0" groupnode="0" />
  110.                 </ddscontrol>
  111.               </dds>
  112. </DiagramLayout>
  113.             <ShowRelationshipNames>False</ShowRelationshipNames>
  114.             <UseDiagramDefaultLayout>True</UseDiagramDefaultLayout>
  115.             <DiagramViewPortLeft>-210</DiagramViewPortLeft>
  116.             <DiagramViewPortTop>-244</DiagramViewPortTop>
  117.             <DiagramBoundingLeft>0</DiagramBoundingLeft>
  118.             <DiagramBoundingTop>0</DiagramBoundingTop>
  119.             <DiagramZoom>100</DiagramZoom>
  120.           </Diagram>
  121.         </Layouts>
  122.       </Value>
  123.     </Annotation>
  124.   </Annotations>
  125.   <DataSourceID>Book Sell</DataSourceID>
  126.   <Schema>
  127.     <xs:schema id="Book_x0020_Sell" 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">
  128.       <xs:element name="Book_x0020_Sell" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:design-time-name="6e08c3d7-89ee-4554-bca5-406b0363c270">
  129.         <xs:complexType>
  130.           <xs:choice minOccurs="0" maxOccurs="unbounded">
  131.             <xs:element name="dbo_Customer" msprop:FriendlyName="Customer" msprop:DbSchemaName="dbo" msprop:DbTableName="Customer" msprop:design-time-name="ac3a4c67-a932-40e6-98e7-29e125e94776" msprop:TableType="Table">
  132.               <xs:complexType>
  133.                 <xs:sequence>
  134.                   <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:FriendlyName="ID" msprop:DbColumnName="ID" msprop:design-time-name="d5dd3520-0b06-4d6b-887a-b7f94d8caa47" type="xs:int" />
  135.                   <xs:element name="Name" msprop:FriendlyName="Name" msprop:DbColumnName="Name" msprop:design-time-name="53169317-d2e6-4ee7-9342-545ff589bf02">
  136.                     <xs:simpleType>
  137.                       <xs:restriction base="xs:string">
  138.                         <xs:maxLength value="20" />
  139.                       </xs:restriction>
  140.                     </xs:simpleType>
  141.                   </xs:element>
  142.                   <xs:element name="Levels" msprop:FriendlyName="Levels" msprop:DbColumnName="Levels" msprop:design-time-name="4358b429-46fb-4d46-972f-ed42bade6b90" type="xs:short" minOccurs="0" />
  143.                   <xs:element name="Gender" msprop:FriendlyName="Gender" msprop:DbColumnName="Gender" msprop:design-time-name="e5942f5a-f213-4967-8fea-c9bdc1f12cf7" type="xs:boolean" minOccurs="0" />
  144.                   <xs:element name="Birthday" msprop:FriendlyName="Birthday" msprop:DbColumnName="Birthday" msprop:design-time-name="0369b46d-3be9-4ead-a7a6-a52a0d4487f7" type="xs:dateTime" minOccurs="0" />
  145.                   <xs:element name="Degree" msprop:FriendlyName="Degree" msprop:DbColumnName="Degree" msprop:design-time-name="d819b248-cc7d-4915-962a-fea8262f3f7c" minOccurs="0">
  146.                     <xs:simpleType>
  147.                       <xs:restriction base="xs:string">
  148.                         <xs:maxLength value="20" />
  149.                       </xs:restriction>
  150.                     </xs:simpleType>
  151.                   </xs:element>
  152.                   <xs:element name="Area" msprop:FriendlyName="Area" msprop:DbColumnName="Area" msprop:design-time-name="c7e2931c-0f78-4f54-945f-9df4d35eb569" minOccurs="0">
  153.                     <xs:simpleType>
  154.                       <xs:restriction base="xs:string">
  155.                         <xs:maxLength value="20" />
  156.                       </xs:restriction>
  157.                     </xs:simpleType>
  158.                   </xs:element>
  159.                   <xs:element name="Address" msprop:FriendlyName="Address" msprop:DbColumnName="Address" msprop:design-time-name="10b9a9d6-bce6-4a7c-864b-d3d69380423e" minOccurs="0">
  160.                     <xs:simpleType>
  161.                       <xs:restriction base="xs:string">
  162.                         <xs:maxLength value="256" />
  163.                       </xs:restriction>
  164.                     </xs:simpleType>
  165.                   </xs:element>
  166.                   <xs:element name="Telephone" msprop:FriendlyName="Telephone" msprop:DbColumnName="Telephone" msprop:design-time-name="f17a9dfd-b6eb-4b9f-976d-cf262ff33c84" minOccurs="0">
  167.                     <xs:simpleType>
  168.                       <xs:restriction base="xs:string">
  169.                         <xs:maxLength value="50" />
  170.                       </xs:restriction>
  171.                     </xs:simpleType>
  172.                   </xs:element>
  173.                   <xs:element name="Email" msprop:FriendlyName="Email" msprop:DbColumnName="Email" msprop:design-time-name="b4c1997f-4d6f-49b6-8ae6-48b3b18dd922" minOccurs="0">
  174.                     <xs:simpleType>
  175.                       <xs:restriction base="xs:string">
  176.                         <xs:maxLength value="50" />
  177.                       </xs:restriction>
  178.                     </xs:simpleType>
  179.                   </xs:element>
  180.                   <xs:element name="Score" msprop:FriendlyName="Score" msprop:DbColumnName="Score" msprop:design-time-name="81cb67d5-4b1b-4cf3-bc05-3c7950211408" type="xs:int" minOccurs="0" />
  181.                   <xs:element name="Age" msdata:ReadOnly="true" msprop:design-time-name="3bf61c90-0dbb-4098-9e1d-e0abb47e897e" msprop:DbColumnName="Age" msprop:ComputedColumnExpression="YEAR(GETDATE()) - YEAR(dbo.Customer.Birthday)" msprop:Description="" msprop:IsLogical="True" type="xs:int" minOccurs="0" />
  182.                   <xs:element name="RegTime" msprop:design-time-name="fd67be7e-0b33-4688-9bd5-5551f699cc97" msprop:DbColumnName="RegTime" type="xs:dateTime" minOccurs="0" />
  183.                   <xs:element name="DayConsume" msdata:ReadOnly="true" msprop:design-time-name="f9c25530-4f81-4df1-a357-b2a567c05b3b" msprop:DbColumnName="DayConsume" msprop:ComputedColumnExpression="CAST (Score AS Decimal) / DATEDIFF(DAY,RegTime,GETDATE())" msprop:Description="" msprop:IsLogical="True" type="xs:decimal" minOccurs="0" />
  184.                 </xs:sequence>
  185.               </xs:complexType>
  186.             </xs:element>
  187.             <xs:element name="dbo_V_BookSell" msprop:FriendlyName="V_BookSell" msprop:DbSchemaName="dbo" msprop:DbTableName="V_BookSell" msprop:design-time-name="2fb48511-2075-46ff-b759-85197d20655e" msprop:TableType="View">
  188.               <xs:complexType>
  189.                 <xs:sequence>
  190.                   <xs:element name="ID" msprop:FriendlyName="ID" msprop:DbColumnName="ID" msprop:design-time-name="4466e450-be2c-46d9-900f-0fbf26fb45b6" type="xs:int" />
  191.                   <xs:element name="SellID" msprop:FriendlyName="SellID" msprop:DbColumnName="SellID" msprop:design-time-name="12e4cac6-ccca-4db1-9a71-32bb82d50ea7" type="xs:int" />
  192.                   <xs:element name="CustomerID" msprop:FriendlyName="CustomerID" msprop:DbColumnName="CustomerID" msprop:design-time-name="3f134563-5a36-4de1-b1ab-82fff1caef2e" type="xs:int" minOccurs="0" />
  193.                   <xs:element name="Time" msprop:FriendlyName="Time" msprop:DbColumnName="Time" msprop:design-time-name="f5bf9047-f20b-406d-b925-03154e55b5b8" type="xs:dateTime" />
  194.                   <xs:element name="BookID" msprop:FriendlyName="BookID" msprop:DbColumnName="BookID" msprop:design-time-name="c4a300b4-a4a5-42f5-89f3-5e59a6d510e4" type="xs:int" />
  195.                   <xs:element name="ISBN" msprop:FriendlyName="ISBN" msprop:DbColumnName="ISBN" msprop:design-time-name="9ebff113-36dc-4666-8f76-66fc045e6d11">
  196.                     <xs:simpleType>
  197.                       <xs:restriction base="xs:string">
  198.                         <xs:maxLength value="10" />
  199.                       </xs:restriction>
  200.                     </xs:simpleType>
  201.                   </xs:element>
  202.                   <xs:element name="Name" msprop:FriendlyName="Name" msprop:DbColumnName="Name" msprop:design-time-name="bcf90945-6345-4e68-abfb-96f922164e64">
  203.                     <xs:simpleType>
  204.                       <xs:restriction base="xs:string">
  205.                         <xs:maxLength value="256" />
  206.                       </xs:restriction>
  207.                     </xs:simpleType>
  208.                   </xs:element>
  209.                   <xs:element name="Press" msprop:FriendlyName="Press" msprop:DbColumnName="Press" msprop:design-time-name="5ca1fe6f-4299-4a8b-8f17-0701876e7415" minOccurs="0">
  210.                     <xs:simpleType>
  211.                       <xs:restriction base="xs:string">
  212.                         <xs:maxLength value="50" />
  213.                       </xs:restriction>
  214.                     </xs:simpleType>
  215.                   </xs:element>
  216.                   <xs:element name="Price" msprop:FriendlyName="Price" msprop:DbColumnName="Price" msprop:design-time-name="a25d7919-fa9d-4d30-9a71-00cc5dd6f5fa" type="xs:decimal" />
  217.                   <xs:element name="Number" msprop:FriendlyName="Number" msprop:DbColumnName="Number" msprop:design-time-name="6ecbba82-3d52-459d-9550-c7b5f25f4ab6" type="xs:int" />
  218.                   <xs:element name="Discount" msprop:FriendlyName="Discount" msprop:DbColumnName="Discount" msprop:design-time-name="0ce0b48a-ab8b-485d-a17d-70b7beead3b2" type="xs:double" minOccurs="0" />
  219.                   <xs:element name="Sum" msprop:FriendlyName="Sum" msprop:DbColumnName="Sum" msprop:design-time-name="3b77ff34-57d9-42dc-b7f3-72bfb753ee03" type="xs:decimal" minOccurs="0" />
  220.                 </xs:sequence>
  221.               </xs:complexType>
  222.             </xs:element>
  223.             <xs:element name="dbo_V_Book" msprop:FriendlyName="V_Book" msprop:DbSchemaName="dbo" msprop:DbTableName="V_Book" msprop:design-time-name="c7cca7cb-6081-47a8-b9ba-9b96992c6ca5" msprop:TableType="View">
  224.               <xs:complexType>
  225.                 <xs:sequence>
  226.                   <xs:element name="ID" msprop:FriendlyName="ID" msprop:DbColumnName="ID" msprop:design-time-name="4d39e741-35a7-4a1d-919d-0627057d36c1" type="xs:int" />
  227.                   <xs:element name="Name" msprop:FriendlyName="Name" msprop:DbColumnName="Name" msprop:design-time-name="544a48d4-4318-4682-8e5f-b0678d17ef46">
  228.                     <xs:simpleType>
  229.                       <xs:restriction base="xs:string">
  230.                         <xs:maxLength value="256" />
  231.                       </xs:restriction>
  232.                     </xs:simpleType>
  233.                   </xs:element>
  234.                   <xs:element name="Category" msprop:FriendlyName="Category" msprop:DbColumnName="Category" msprop:design-time-name="2807ceaa-3e79-4f6f-9b1f-21f5cc9b60a0">
  235.                     <xs:simpleType>
  236.                       <xs:restriction base="xs:string">
  237.                         <xs:maxLength value="20" />
  238.                       </xs:restriction>
  239.                     </xs:simpleType>
  240.                   </xs:element>
  241.                   <xs:element name="Press" msprop:FriendlyName="Press" msprop:DbColumnName="Press" msprop:design-time-name="40df5c9d-f49c-4ad9-86c9-7a004fd3b342" minOccurs="0">
  242.                     <xs:simpleType>
  243.                       <xs:restriction base="xs:string">
  244.                         <xs:maxLength value="50" />
  245.                       </xs:restriction>
  246.                     </xs:simpleType>
  247.                   </xs:element>
  248.                   <xs:element name="Price" msprop:FriendlyName="Price" msprop:DbColumnName="Price" msprop:design-time-name="7ef66ed9-f19d-48cf-9f65-b66c82fddfa9" type="xs:decimal" />
  249.                   <xs:element name="Pages" msprop:FriendlyName="Pages" msprop:DbColumnName="Pages" msprop:design-time-name="ca10d9e3-8ee1-45c6-98f8-18d86af14df1" type="xs:short" minOccurs="0" />
  250.                   <xs:element name="CD" msprop:FriendlyName="CD" msprop:DbColumnName="CD" msprop:design-time-name="ad141bbf-db75-425e-ae84-099e648e2b2e" type="xs:boolean" minOccurs="0" />
  251.                   <xs:element name="SellNumber" msdata:ReadOnly="true" msprop:FriendlyName="SellNumber" msprop:DbColumnName="SellNumber" msprop:design-time-name="c98490ee-1872-48a8-b88c-92c129dac59c" type="xs:int" minOccurs="0" />
  252.                   <xs:element name="SellSum" msdata:ReadOnly="true" msprop:FriendlyName="SellSum" msprop:DbColumnName="SellSum" msprop:design-time-name="008b65ad-d2d3-4c4e-951b-7552e053b0ea" type="xs:decimal" minOccurs="0" />
  253.                   <xs:element name="ShelfDate" msprop:FriendlyName="ShelfDate" msprop:DbColumnName="ShelfDate" msprop:design-time-name="e28d8269-aaba-4dae-90eb-5cfcf460d081" type="xs:dateTime" minOccurs="0" />
  254.                   <xs:element name="DaySellNumber" msdata:ReadOnly="true" msprop:design-time-name="b16018db-0763-46d9-b68e-8ab04b20bdd9" msprop:DbColumnName="DaySellNumber" msprop:ComputedColumnExpression="SellNumber/DATEDIFF(DAY, ShelfDate, '2007-4-1')" msprop:Description="日均销量" msprop:IsLogical="True" type="xs:int" minOccurs="0" />
  255.                   <xs:element name="DaySellSum" msdata:ReadOnly="true" msprop:design-time-name="e3dd0813-8a63-46f8-9d08-548c55e7bc8f" msprop:DbColumnName="DaySellSum" msprop:ComputedColumnExpression="SellSum/DATEDIFF(DAY, ShelfDate, '2007-4-1')" msprop:Description="日均销售额" msprop:IsLogical="True" type="xs:decimal" minOccurs="0" />
  256.                 </xs:sequence>
  257.               </xs:complexType>
  258.             </xs:element>
  259.             <xs:element name="dbo_V_WeekSell" msprop:FriendlyName="V_WeekSell" msprop:DbSchemaName="dbo" msprop:DbTableName="V_WeekSell" msprop:design-time-name="1205ed08-174b-4bca-853f-1c8d70f7492f" msprop:TableType="View">
  260.               <xs:complexType>
  261.                 <xs:sequence>
  262.                   <xs:element name="Week" msdata:ReadOnly="true" msprop:FriendlyName="Week" msprop:DbColumnName="Week" msprop:design-time-name="05f7b7ba-2e66-4fb8-83ca-9f842e5eb23e" type="xs:int" minOccurs="0" />
  263.                   <xs:element name="ID" msprop:FriendlyName="ID" msprop:DbColumnName="ID" msprop:design-time-name="0717fc54-ce3f-48cc-8cb1-9cb26667de4e" type="xs:int" />
  264.                   <xs:element name="SellSum" msdata:ReadOnly="true" msprop:FriendlyName="SellSum" msprop:DbColumnName="SellSum" msprop:design-time-name="25bae63c-9119-49b9-8eb3-5fa3a6e4fccb" type="xs:decimal" minOccurs="0" />
  265.                 </xs:sequence>
  266.               </xs:complexType>
  267.             </xs:element>
  268.           </xs:choice>
  269.         </xs:complexType>
  270.         <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  271.           <xs:selector xpath=".//dbo_Customer" />
  272.           <xs:field xpath="ID" />
  273.         </xs:unique>
  274.         <xs:unique name="dbo_V_BookSell_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  275.           <xs:selector xpath=".//dbo_V_BookSell" />
  276.           <xs:field xpath="ID" />
  277.           <xs:field xpath="SellID" />
  278.         </xs:unique>
  279.         <xs:unique name="dbo_V_Book_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  280.           <xs:selector xpath=".//dbo_V_Book" />
  281.           <xs:field xpath="ID" />
  282.         </xs:unique>
  283.         <xs:unique name="dbo_V_WeekSell_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  284.           <xs:selector xpath=".//dbo_V_WeekSell" />
  285.           <xs:field xpath="ID" />
  286.         </xs:unique>
  287.       </xs:element>
  288.       <xs:annotation>
  289.         <xs:appinfo>
  290.           <msdata:Relationship name="V_BookSell-Customer" msdata:parent="dbo_Customer" msdata:child="dbo_V_BookSell" msdata:parentkey="ID" msdata:childkey="CustomerID" msprop:Description="" msprop:IsLogical="True" />
  291.         </xs:appinfo>
  292.       </xs:annotation>
  293.     </xs:schema>
  294.     <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" />
  295.   </Schema>
  296. </DataSourceView>