1 <?xml version="1.0" standalone="yes"?>
2 <xs:schema id=
"NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
3   <xs:element name=
"NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
4     <xs:complexType>
5       <xs:choice minOccurs=
"0" maxOccurs="unbounded">
6         <xs:element name=
"Stock">
7           <xs:complexType>
8             <xs:sequence>
9               <xs:element name=
"ST_ID" type="xs:int" minOccurs="0" />
10               <xs:element name=
"Stock_ID" type="xs:string" minOccurs="0" />
11               <xs:element name=
"Date" type="xs:dateTime" minOccurs="0" />
12               <xs:element name=
"SupplierID" type="xs:int" minOccurs="0" />
13               <xs:element name=
"GrandTotal" type="xs:decimal" minOccurs="0" />
14               <xs:element name=
"TotalPayment" type="xs:decimal" minOccurs="0" />
15               <xs:element name=
"PaymentDue" type="xs:decimal" minOccurs="0" />
16               <xs:element name=
"Remarks" type="xs:string" minOccurs="0" />
17               <xs:element name=
"SP_ID" type="xs:int" minOccurs="0" />
18               <xs:element name=
"StockID" type="xs:int" minOccurs="0" />
19               <xs:element name=
"ProductID" type="xs:int" minOccurs="0" />
20               <xs:element name=
"Qty" type="xs:int" minOccurs="0" />
21               <xs:element name=
"Price" type="xs:decimal" minOccurs="0" />
22               <xs:element name=
"TotalAmount" type="xs:decimal" minOccurs="0" />
23               <xs:element name=
"ID" type="xs:int" minOccurs="0" />
24               <xs:element name=
"Expr1" type="xs:string" minOccurs="0" />
25               <xs:element name=
"Name" type="xs:string" minOccurs="0" />
26               <xs:element name=
"Address" type="xs:string" minOccurs="0" />
27               <xs:element name=
"City" type="xs:string" minOccurs="0" />
28               <xs:element name=
"State" type="xs:string" minOccurs="0" />
29               <xs:element name=
"ZipCode" type="xs:string" minOccurs="0" />
30               <xs:element name=
"ContactNo" type="xs:string" minOccurs="0" />
31               <xs:element name=
"EmailID" type="xs:string" minOccurs="0" />
32               <xs:element name=
"Expr2" type="xs:string" minOccurs="0" />
33               <xs:element name=
"PID" type="xs:int" minOccurs="0" />
34               <xs:element name=
"ProductCode" type="xs:string" minOccurs="0" />
35               <xs:element name=
"ProductName" type="xs:string" minOccurs="0" />
36               <xs:element name=
"SubCategoryID" type="xs:int" minOccurs="0" />
37               <xs:element name=
"Description" type="xs:string" minOccurs="0" />
38               <xs:element name=
"CostPrice" type="xs:decimal" minOccurs="0" />
39               <xs:element name=
"SellingPrice" type="xs:decimal" minOccurs="0" />
40               <xs:element name=
"Discount" type="xs:decimal" minOccurs="0" />
41               <xs:element name=
"VAT" type="xs:decimal" minOccurs="0" />
42               <xs:element name=
"ReorderPoint" type="xs:int" minOccurs="0" />
43             </xs:sequence>
44           </xs:complexType>
45         </xs:element>
46         <xs:element name=
"Stock_Product">
47           <xs:complexType>
48             <xs:sequence>
49               <xs:element name=
"ST_ID" type="xs:int" minOccurs="0" />
50               <xs:element name=
"Stock_ID" type="xs:string" minOccurs="0" />
51               <xs:element name=
"Date" type="xs:dateTime" minOccurs="0" />
52               <xs:element name=
"SupplierID" type="xs:int" minOccurs="0" />
53               <xs:element name=
"GrandTotal" type="xs:decimal" minOccurs="0" />
54               <xs:element name=
"TotalPayment" type="xs:decimal" minOccurs="0" />
55               <xs:element name=
"PaymentDue" type="xs:decimal" minOccurs="0" />
56               <xs:element name=
"Remarks" type="xs:string" minOccurs="0" />
57               <xs:element name=
"SP_ID" type="xs:int" minOccurs="0" />
58               <xs:element name=
"StockID" type="xs:int" minOccurs="0" />
59               <xs:element name=
"ProductID" type="xs:int" minOccurs="0" />
60               <xs:element name=
"Qty" type="xs:int" minOccurs="0" />
61               <xs:element name=
"Price" type="xs:decimal" minOccurs="0" />
62               <xs:element name=
"TotalAmount" type="xs:decimal" minOccurs="0" />
63               <xs:element name=
"ID" type="xs:int" minOccurs="0" />
64               <xs:element name=
"Expr1" type="xs:string" minOccurs="0" />
65               <xs:element name=
"Name" type="xs:string" minOccurs="0" />
66               <xs:element name=
"Address" type="xs:string" minOccurs="0" />
67               <xs:element name=
"City" type="xs:string" minOccurs="0" />
68               <xs:element name=
"State" type="xs:string" minOccurs="0" />
69               <xs:element name=
"ZipCode" type="xs:string" minOccurs="0" />
70               <xs:element name=
"ContactNo" type="xs:string" minOccurs="0" />
71               <xs:element name=
"EmailID" type="xs:string" minOccurs="0" />
72               <xs:element name=
"Expr2" type="xs:string" minOccurs="0" />
73               <xs:element name=
"PID" type="xs:int" minOccurs="0" />
74               <xs:element name=
"ProductCode" type="xs:string" minOccurs="0" />
75               <xs:element name=
"ProductName" type="xs:string" minOccurs="0" />
76               <xs:element name=
"SubCategoryID" type="xs:int" minOccurs="0" />
77               <xs:element name=
"Description" type="xs:string" minOccurs="0" />
78               <xs:element name=
"CostPrice" type="xs:decimal" minOccurs="0" />
79               <xs:element name=
"SellingPrice" type="xs:decimal" minOccurs="0" />
80               <xs:element name=
"Discount" type="xs:decimal" minOccurs="0" />
81               <xs:element name=
"VAT" type="xs:decimal" minOccurs="0" />
82               <xs:element name=
"ReorderPoint" type="xs:int" minOccurs="0" />
83             </xs:sequence>
84           </xs:complexType>
85         </xs:element>
86         <xs:element name=
"Product">
87           <xs:complexType>
88             <xs:sequence>
89               <xs:element name=
"ST_ID" type="xs:int" minOccurs="0" />
90               <xs:element name=
"Stock_ID" type="xs:string" minOccurs="0" />
91               <xs:element name=
"Date" type="xs:dateTime" minOccurs="0" />
92               <xs:element name=
"SupplierID" type="xs:int" minOccurs="0" />
93               <xs:element name=
"GrandTotal" type="xs:decimal" minOccurs="0" />
94               <xs:element name=
"TotalPayment" type="xs:decimal" minOccurs="0" />
95               <xs:element name=
"PaymentDue" type="xs:decimal" minOccurs="0" />
96               <xs:element name=
"Remarks" type="xs:string" minOccurs="0" />
97               <xs:element name=
"SP_ID" type="xs:int" minOccurs="0" />
98               <xs:element name=
"StockID" type="xs:int" minOccurs="0" />
99               <xs:element name=
"ProductID" type="xs:int" minOccurs="0" />
100               <xs:element name=
"Qty" type="xs:int" minOccurs="0" />
101               <xs:element name=
"Price" type="xs:decimal" minOccurs="0" />
102               <xs:element name=
"TotalAmount" type="xs:decimal" minOccurs="0" />
103               <xs:element name=
"ID" type="xs:int" minOccurs="0" />
104               <xs:element name=
"Expr1" type="xs:string" minOccurs="0" />
105               <xs:element name=
"Name" type="xs:string" minOccurs="0" />
106               <xs:element name=
"Address" type="xs:string" minOccurs="0" />
107               <xs:element name=
"City" type="xs:string" minOccurs="0" />
108               <xs:element name=
"State" type="xs:string" minOccurs="0" />
109               <xs:element name=
"ZipCode" type="xs:string" minOccurs="0" />
110               <xs:element name=
"ContactNo" type="xs:string" minOccurs="0" />
111               <xs:element name=
"EmailID" type="xs:string" minOccurs="0" />
112               <xs:element name=
"Expr2" type="xs:string" minOccurs="0" />
113               <xs:element name=
"PID" type="xs:int" minOccurs="0" />
114               <xs:element name=
"ProductCode" type="xs:string" minOccurs="0" />
115               <xs:element name=
"ProductName" type="xs:string" minOccurs="0" />
116               <xs:element name=
"SubCategoryID" type="xs:int" minOccurs="0" />
117               <xs:element name=
"Description" type="xs:string" minOccurs="0" />
118               <xs:element name=
"CostPrice" type="xs:decimal" minOccurs="0" />
119               <xs:element name=
"SellingPrice" type="xs:decimal" minOccurs="0" />
120               <xs:element name=
"Discount" type="xs:decimal" minOccurs="0" />
121               <xs:element name=
"VAT" type="xs:decimal" minOccurs="0" />
122               <xs:element name=
"ReorderPoint" type="xs:int" minOccurs="0" />
123             </xs:sequence>
124           </xs:complexType>
125         </xs:element>
126         <xs:element name=
"Supplier">
127           <xs:complexType>
128             <xs:sequence>
129               <xs:element name=
"ST_ID" type="xs:int" minOccurs="0" />
130               <xs:element name=
"Stock_ID" type="xs:string" minOccurs="0" />
131               <xs:element name=
"Date" type="xs:dateTime" minOccurs="0" />
132               <xs:element name=
"SupplierID" type="xs:int" minOccurs="0" />
133               <xs:element name=
"GrandTotal" type="xs:decimal" minOccurs="0" />
134               <xs:element name=
"TotalPayment" type="xs:decimal" minOccurs="0" />
135               <xs:element name=
"PaymentDue" type="xs:decimal" minOccurs="0" />
136               <xs:element name=
"Remarks" type="xs:string" minOccurs="0" />
137               <xs:element name=
"SP_ID" type="xs:int" minOccurs="0" />
138               <xs:element name=
"StockID" type="xs:int" minOccurs="0" />
139               <xs:element name=
"ProductID" type="xs:int" minOccurs="0" />
140               <xs:element name=
"Qty" type="xs:int" minOccurs="0" />
141               <xs:element name=
"Price" type="xs:decimal" minOccurs="0" />
142               <xs:element name=
"TotalAmount" type="xs:decimal" minOccurs="0" />
143               <xs:element name=
"ID" type="xs:int" minOccurs="0" />
144               <xs:element name=
"Expr1" type="xs:string" minOccurs="0" />
145               <xs:element name=
"Name" type="xs:string" minOccurs="0" />
146               <xs:element name=
"Address" type="xs:string" minOccurs="0" />
147               <xs:element name=
"City" type="xs:string" minOccurs="0" />
148               <xs:element name=
"State" type="xs:string" minOccurs="0" />
149               <xs:element name=
"ZipCode" type="xs:string" minOccurs="0" />
150               <xs:element name=
"ContactNo" type="xs:string" minOccurs="0" />
151               <xs:element name=
"EmailID" type="xs:string" minOccurs="0" />
152               <xs:element name=
"Expr2" type="xs:string" minOccurs="0" />
153               <xs:element name=
"PID" type="xs:int" minOccurs="0" />
154               <xs:element name=
"ProductCode" type="xs:string" minOccurs="0" />
155               <xs:element name=
"ProductName" type="xs:string" minOccurs="0" />
156               <xs:element name=
"SubCategoryID" type="xs:int" minOccurs="0" />
157               <xs:element name=
"Description" type="xs:string" minOccurs="0" />
158               <xs:element name=
"CostPrice" type="xs:decimal" minOccurs="0" />
159               <xs:element name=
"SellingPrice" type="xs:decimal" minOccurs="0" />
160               <xs:element name=
"Discount" type="xs:decimal" minOccurs="0" />
161               <xs:element name=
"VAT" type="xs:decimal" minOccurs="0" />
162               <xs:element name=
"ReorderPoint" type="xs:int" minOccurs="0" />
163             </xs:sequence>
164           </xs:complexType>
165         </xs:element>
166         <xs:element name=
"Table1">
167           <xs:complexType>
168             <xs:sequence>
169               <xs:element name=
"Year" type="xs:string" minOccurs="0" />
170               <xs:element name=
"GrandTotal" type="xs:decimal" minOccurs="0" />
171             </xs:sequence>
172           </xs:complexType>
173         </xs:element>
174       </xs:choice>
175     </xs:complexType>
176   </xs:element>
177 </xs:schema>


Gõ tìm kiếm nhanh...