dsFrmIndentBillOnNet.xsd 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <xs:schema id="dsFrmIndentBillOnNet" targetNamespace="http://tempuri.org/dsFrmIndentBillOnNet.xsd" xmlns:mstns="http://tempuri.org/dsFrmIndentBillOnNet.xsd" xmlns="http://tempuri.org/dsFrmIndentBillOnNet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  3. <xs:annotation>
  4. <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
  5. <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6. <Connections>
  7. <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Properties.Settings.GlobalReference.Default.sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString" Provider="System.Data.SqlClient" />
  8. </Connections>
  9. <Tables>
  10. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IndentBillOnNetTableAdapter" GeneratorDataComponentClassName="IndentBillOnNetTableAdapter" Name="IndentBillOnNet" UserDataComponentName="IndentBillOnNetTableAdapter">
  11. <MainSource>
  12. <DbSource ConnectionRef="sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
  13. <SelectCommand>
  14. <DbCommand CommandType="Text" ModifiedByUser="true">
  15. <CommandText>
  16. SELECT IndentBillOnNet.*, Customer.No_Customer, Customer.Name_Customer, Customer.ShortName_Customer, Customer.Type_Customer,
  17. Customer.LastDiscount_Customer, Customer.PostalCode_Customer, ISNULL(b.Name_User, '') AS Name_Assessor, Customer.ID_Creator As CustomerCreator
  18. FROM IndentBillOnNet
  19. LEFT JOIN Customer ON Customer.ID_Customer = IndentBillOnNet.ID_Customer
  20. LEFT JOIN AppUser b ON b.ID_User = IndentBillOnNet.ID_Assessor
  21. WHERE No_IndentBillOnNet &gt;= (case DataLength('IBN201904010003') When 0 Then No_IndentBillOnNet Else 'IBN201904010003' End) And No_IndentBillOnNet &lt;= (case DataLength('IBN201904010003') When 0 Then No_IndentBillOnNet Else 'IBN201904010003' End)</CommandText>
  22. <Parameters />
  23. </DbCommand>
  24. </SelectCommand>
  25. </DbSource>
  26. </MainSource>
  27. <Mappings>
  28. <Mapping SourceColumn="ID_IndentBillOnNet" DataSetColumn="ID_IndentBillOnNet" />
  29. <Mapping SourceColumn="No_IndentBillOnNet" DataSetColumn="No_IndentBillOnNet" />
  30. <Mapping SourceColumn="Date_IndentBillOnNet" DataSetColumn="Date_IndentBillOnNet" />
  31. <Mapping SourceColumn="ID_Customer" DataSetColumn="ID_Customer" />
  32. <Mapping SourceColumn="GetMethod_IndentBillOnNet" DataSetColumn="GetMethod_IndentBillOnNet" />
  33. <Mapping SourceColumn="Name_Linkman" DataSetColumn="Name_Linkman" />
  34. <Mapping SourceColumn="Tel_IndentBillOnNet" DataSetColumn="Tel_IndentBillOnNet" />
  35. <Mapping SourceColumn="Fax_IndentBillOnNet" DataSetColumn="Fax_IndentBillOnNet" />
  36. <Mapping SourceColumn="SendAddr_IndentBillOnNet" DataSetColumn="SendAddr_IndentBillOnNet" />
  37. <Mapping SourceColumn="InvoiceAddress_Company" DataSetColumn="InvoiceAddress_Company" />
  38. <Mapping SourceColumn="InvoiceTitle_Company" DataSetColumn="InvoiceTitle_Company" />
  39. <Mapping SourceColumn="TaxCurrency_IndentBillOnNet" DataSetColumn="TaxCurrency_IndentBillOnNet" />
  40. <Mapping SourceColumn="Currency_IndentBillOnNet" DataSetColumn="Currency_IndentBillOnNet" />
  41. <Mapping SourceColumn="Disable_IndentBillOnNet" DataSetColumn="Disable_IndentBillOnNet" />
  42. <Mapping SourceColumn="Amount_IndentBillOnNet" DataSetColumn="Amount_IndentBillOnNet" />
  43. <Mapping SourceColumn="GoodsAmount_IndentBillOnNet" DataSetColumn="GoodsAmount_IndentBillOnNet" />
  44. <Mapping SourceColumn="TaxAmount_IndentBillOnNet" DataSetColumn="TaxAmount_IndentBillOnNet" />
  45. <Mapping SourceColumn="Comment_IndentBillOnNet" DataSetColumn="Comment_IndentBillOnNet" />
  46. <Mapping SourceColumn="CreateDate_IndentBillOnNet" DataSetColumn="CreateDate_IndentBillOnNet" />
  47. <Mapping SourceColumn="ID_Assessor" DataSetColumn="ID_Assessor" />
  48. <Mapping SourceColumn="AssessDate_IndentBillOnNet" DataSetColumn="AssessDate_IndentBillOnNet" />
  49. <Mapping SourceColumn="LastModUser_IndentBillOnNet" DataSetColumn="LastModUser_IndentBillOnNet" />
  50. <Mapping SourceColumn="LastModDate_IndentBillOnNet" DataSetColumn="LastModDate_IndentBillOnNet" />
  51. <Mapping SourceColumn="DeleteUser_IndentBillOnNet" DataSetColumn="DeleteUser_IndentBillOnNet" />
  52. <Mapping SourceColumn="DeleteDate_IndentBillOnNet" DataSetColumn="DeleteDate_IndentBillOnNet" />
  53. <Mapping SourceColumn="FeedbackComment_IndentBillOnNet" DataSetColumn="FeedbackComment_IndentBillOnNet" />
  54. <Mapping SourceColumn="Name_CustomerAccount" DataSetColumn="Name_CustomerAccount" />
  55. <Mapping SourceColumn="Postcode_IndentBillOnNet" DataSetColumn="Postcode_IndentBillOnNet" />
  56. <Mapping SourceColumn="No_Customer" DataSetColumn="No_Customer" />
  57. <Mapping SourceColumn="Name_Customer" DataSetColumn="Name_Customer" />
  58. <Mapping SourceColumn="ShortName_Customer" DataSetColumn="ShortName_Customer" />
  59. <Mapping SourceColumn="Type_Customer" DataSetColumn="Type_Customer" />
  60. <Mapping SourceColumn="LastDiscount_Customer" DataSetColumn="LastDiscount_Customer" />
  61. <Mapping SourceColumn="PostalCode_Customer" DataSetColumn="PostalCode_Customer" />
  62. <Mapping SourceColumn="Name_Assessor" DataSetColumn="Name_Assessor" />
  63. <Mapping SourceColumn="CustomerCreator" DataSetColumn="CustomerCreator" />
  64. </Mappings>
  65. <Sources />
  66. </TableAdapter>
  67. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IndentBillOnNetProductTableAdapter" GeneratorDataComponentClassName="IndentBillOnNetProductTableAdapter" Name="IndentBillOnNetProduct" UserDataComponentName="IndentBillOnNetProductTableAdapter">
  68. <MainSource>
  69. <DbSource ConnectionRef="sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
  70. <SelectCommand>
  71. <DbCommand CommandType="Text" ModifiedByUser="true">
  72. <CommandText> SELECT IndentBillOnNetProduct.*,No_IndentBillOnNet,Product.No_Product, Product.Name_Product, Product.Unit_Product,
  73. (IndentBillOnNetProduct.Quantity_IndentBillOnNetProduct * IndentBillOnNetProduct.UnitPrice_IndentBillOnNetProduct) AS Amount_IndentBillOnNetProduct ,No_IndentBillOnNet
  74. FROM IndentBillOnNetProduct
  75. LEFT JOIN Product ON Product.ID_Product = IndentBillOnNetProduct.ID_Product
  76. Left Join IndentBillOnNet On IndentBillOnNet.ID_IndentBillOnNet = IndentBillOnNetProduct.ID_IndentBillOnNet
  77. WHERE No_IndentBillOnNet &gt;= (case DataLength('IBN201904010003') When 0 Then No_IndentBillOnNet Else 'IBN201904010003' End) And No_IndentBillOnNet &lt;= (case DataLength('IBN201904010003') When 0 Then No_IndentBillOnNet Else 'IBN201904010003' End)
  78. </CommandText>
  79. <Parameters />
  80. </DbCommand>
  81. </SelectCommand>
  82. </DbSource>
  83. </MainSource>
  84. <Mappings>
  85. <Mapping SourceColumn="ID_IndentBillOnNetProduct" DataSetColumn="ID_IndentBillOnNetProduct" />
  86. <Mapping SourceColumn="No_IndentBillOnNetProduct" DataSetColumn="No_IndentBillOnNetProduct" />
  87. <Mapping SourceColumn="ID_IndentBillOnNet" DataSetColumn="ID_IndentBillOnNet" />
  88. <Mapping SourceColumn="ID_Product" DataSetColumn="ID_Product" />
  89. <Mapping SourceColumn="Quantity_IndentBillOnNetProduct" DataSetColumn="Quantity_IndentBillOnNetProduct" />
  90. <Mapping SourceColumn="UnitPrice_IndentBillOnNetProduct" DataSetColumn="UnitPrice_IndentBillOnNetProduct" />
  91. <Mapping SourceColumn="Comment_IndentBillOnNetProduct" DataSetColumn="Comment_IndentBillOnNetProduct" />
  92. <Mapping SourceColumn="Amount_SaleBill" DataSetColumn="Amount_SaleBill" />
  93. <Mapping SourceColumn="No_IndentBillOnNet" DataSetColumn="No_IndentBillOnNet" />
  94. <Mapping SourceColumn="No_Product" DataSetColumn="No_Product" />
  95. <Mapping SourceColumn="Name_Product" DataSetColumn="Name_Product" />
  96. <Mapping SourceColumn="Unit_Product" DataSetColumn="Unit_Product" />
  97. <Mapping SourceColumn="Amount_IndentBillOnNetProduct" DataSetColumn="Amount_IndentBillOnNetProduct" />
  98. <Mapping SourceColumn="No_IndentBillOnNet1" DataSetColumn="No_IndentBillOnNet1" />
  99. </Mappings>
  100. <Sources />
  101. </TableAdapter>
  102. </Tables>
  103. <Sources />
  104. </DataSource>
  105. </xs:appinfo>
  106. </xs:annotation>
  107. <xs:element name="dsFrmIndentBillOnNet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsFrmIndentBillOnNet" msprop:Generator_UserDSName="dsFrmIndentBillOnNet">
  108. <xs:complexType>
  109. <xs:choice minOccurs="0" maxOccurs="unbounded">
  110. <xs:element name="IndentBillOnNet" msprop:Generator_TableClassName="IndentBillOnNetDataTable" msprop:Generator_TableVarName="tableIndentBillOnNet" msprop:Generator_TablePropName="IndentBillOnNet" msprop:Generator_RowDeletingName="IndentBillOnNetRowDeleting" msprop:Generator_RowChangingName="IndentBillOnNetRowChanging" msprop:Generator_RowEvHandlerName="IndentBillOnNetRowChangeEventHandler" msprop:Generator_RowDeletedName="IndentBillOnNetRowDeleted" msprop:Generator_UserTableName="IndentBillOnNet" msprop:Generator_RowChangedName="IndentBillOnNetRowChanged" msprop:Generator_RowEvArgName="IndentBillOnNetRowChangeEvent" msprop:Generator_RowClassName="IndentBillOnNetRow">
  111. <xs:complexType>
  112. <xs:sequence>
  113. <xs:element name="ID_IndentBillOnNet" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="ID_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="ID_IndentBillOnNetColumn" msprop:Generator_UserColumnName="ID_IndentBillOnNet" type="xs:string" />
  114. <xs:element name="No_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnNo_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="No_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="No_IndentBillOnNetColumn" msprop:Generator_UserColumnName="No_IndentBillOnNet">
  115. <xs:simpleType>
  116. <xs:restriction base="xs:string">
  117. <xs:maxLength value="64" />
  118. </xs:restriction>
  119. </xs:simpleType>
  120. </xs:element>
  121. <xs:element name="Date_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Date_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Date_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Date_IndentBillOnNet" type="xs:dateTime" />
  122. <xs:element name="ID_Customer" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_Customer" msprop:Generator_ColumnPropNameInRow="ID_Customer" msprop:Generator_ColumnPropNameInTable="ID_CustomerColumn" msprop:Generator_UserColumnName="ID_Customer" type="xs:string" />
  123. <xs:element name="GetMethod_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnGetMethod_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="GetMethod_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="GetMethod_IndentBillOnNetColumn" msprop:Generator_UserColumnName="GetMethod_IndentBillOnNet" minOccurs="0">
  124. <xs:simpleType>
  125. <xs:restriction base="xs:string">
  126. <xs:maxLength value="64" />
  127. </xs:restriction>
  128. </xs:simpleType>
  129. </xs:element>
  130. <xs:element name="Name_Linkman" msprop:Generator_ColumnVarNameInTable="columnName_Linkman" msprop:Generator_ColumnPropNameInRow="Name_Linkman" msprop:Generator_ColumnPropNameInTable="Name_LinkmanColumn" msprop:Generator_UserColumnName="Name_Linkman" minOccurs="0">
  131. <xs:simpleType>
  132. <xs:restriction base="xs:string">
  133. <xs:maxLength value="64" />
  134. </xs:restriction>
  135. </xs:simpleType>
  136. </xs:element>
  137. <xs:element name="Tel_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnTel_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Tel_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Tel_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Tel_IndentBillOnNet" minOccurs="0">
  138. <xs:simpleType>
  139. <xs:restriction base="xs:string">
  140. <xs:maxLength value="128" />
  141. </xs:restriction>
  142. </xs:simpleType>
  143. </xs:element>
  144. <xs:element name="Fax_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnFax_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Fax_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Fax_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Fax_IndentBillOnNet" minOccurs="0">
  145. <xs:simpleType>
  146. <xs:restriction base="xs:string">
  147. <xs:maxLength value="128" />
  148. </xs:restriction>
  149. </xs:simpleType>
  150. </xs:element>
  151. <xs:element name="SendAddr_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnSendAddr_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="SendAddr_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="SendAddr_IndentBillOnNetColumn" msprop:Generator_UserColumnName="SendAddr_IndentBillOnNet" minOccurs="0">
  152. <xs:simpleType>
  153. <xs:restriction base="xs:string">
  154. <xs:maxLength value="256" />
  155. </xs:restriction>
  156. </xs:simpleType>
  157. </xs:element>
  158. <xs:element name="InvoiceAddress_Company" msprop:Generator_ColumnVarNameInTable="columnInvoiceAddress_Company" msprop:Generator_ColumnPropNameInRow="InvoiceAddress_Company" msprop:Generator_ColumnPropNameInTable="InvoiceAddress_CompanyColumn" msprop:Generator_UserColumnName="InvoiceAddress_Company" minOccurs="0">
  159. <xs:simpleType>
  160. <xs:restriction base="xs:string">
  161. <xs:maxLength value="256" />
  162. </xs:restriction>
  163. </xs:simpleType>
  164. </xs:element>
  165. <xs:element name="InvoiceTitle_Company" msprop:Generator_ColumnVarNameInTable="columnInvoiceTitle_Company" msprop:Generator_ColumnPropNameInRow="InvoiceTitle_Company" msprop:Generator_ColumnPropNameInTable="InvoiceTitle_CompanyColumn" msprop:Generator_UserColumnName="InvoiceTitle_Company" minOccurs="0">
  166. <xs:simpleType>
  167. <xs:restriction base="xs:string">
  168. <xs:maxLength value="64" />
  169. </xs:restriction>
  170. </xs:simpleType>
  171. </xs:element>
  172. <xs:element name="TaxCurrency_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnTaxCurrency_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="TaxCurrency_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="TaxCurrency_IndentBillOnNetColumn" msprop:Generator_UserColumnName="TaxCurrency_IndentBillOnNet" minOccurs="0">
  173. <xs:simpleType>
  174. <xs:restriction base="xs:string">
  175. <xs:maxLength value="64" />
  176. </xs:restriction>
  177. </xs:simpleType>
  178. </xs:element>
  179. <xs:element name="Currency_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnCurrency_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Currency_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Currency_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Currency_IndentBillOnNet" minOccurs="0">
  180. <xs:simpleType>
  181. <xs:restriction base="xs:string">
  182. <xs:maxLength value="64" />
  183. </xs:restriction>
  184. </xs:simpleType>
  185. </xs:element>
  186. <xs:element name="Disable_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnDisable_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Disable_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Disable_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Disable_IndentBillOnNet" type="xs:boolean" minOccurs="0" />
  187. <xs:element name="Amount_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Amount_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Amount_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Amount_IndentBillOnNet" type="xs:decimal" />
  188. <xs:element name="GoodsAmount_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnGoodsAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="GoodsAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="GoodsAmount_IndentBillOnNetColumn" msprop:Generator_UserColumnName="GoodsAmount_IndentBillOnNet" type="xs:decimal" />
  189. <xs:element name="TaxAmount_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnTaxAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="TaxAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="TaxAmount_IndentBillOnNetColumn" msprop:Generator_UserColumnName="TaxAmount_IndentBillOnNet" type="xs:decimal" />
  190. <xs:element name="Comment_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnComment_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Comment_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Comment_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Comment_IndentBillOnNet" minOccurs="0">
  191. <xs:simpleType>
  192. <xs:restriction base="xs:string">
  193. <xs:maxLength value="256" />
  194. </xs:restriction>
  195. </xs:simpleType>
  196. </xs:element>
  197. <xs:element name="CreateDate_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnCreateDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="CreateDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="CreateDate_IndentBillOnNetColumn" msprop:Generator_UserColumnName="CreateDate_IndentBillOnNet" type="xs:dateTime" />
  198. <xs:element name="ID_Assessor" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_Assessor" msprop:Generator_ColumnPropNameInRow="ID_Assessor" msprop:Generator_ColumnPropNameInTable="ID_AssessorColumn" msprop:Generator_UserColumnName="ID_Assessor" type="xs:string" minOccurs="0" />
  199. <xs:element name="AssessDate_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnAssessDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="AssessDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="AssessDate_IndentBillOnNetColumn" msprop:Generator_UserColumnName="AssessDate_IndentBillOnNet" type="xs:dateTime" minOccurs="0" />
  200. <xs:element name="LastModUser_IndentBillOnNet" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnLastModUser_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="LastModUser_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="LastModUser_IndentBillOnNetColumn" msprop:Generator_UserColumnName="LastModUser_IndentBillOnNet" type="xs:string" minOccurs="0" />
  201. <xs:element name="LastModDate_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnLastModDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="LastModDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="LastModDate_IndentBillOnNetColumn" msprop:Generator_UserColumnName="LastModDate_IndentBillOnNet" type="xs:dateTime" minOccurs="0" />
  202. <xs:element name="DeleteUser_IndentBillOnNet" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnDeleteUser_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="DeleteUser_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="DeleteUser_IndentBillOnNetColumn" msprop:Generator_UserColumnName="DeleteUser_IndentBillOnNet" type="xs:string" minOccurs="0" />
  203. <xs:element name="DeleteDate_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnDeleteDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="DeleteDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="DeleteDate_IndentBillOnNetColumn" msprop:Generator_UserColumnName="DeleteDate_IndentBillOnNet" type="xs:dateTime" minOccurs="0" />
  204. <xs:element name="FeedbackComment_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnFeedbackComment_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="FeedbackComment_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="FeedbackComment_IndentBillOnNetColumn" msprop:Generator_UserColumnName="FeedbackComment_IndentBillOnNet" minOccurs="0">
  205. <xs:simpleType>
  206. <xs:restriction base="xs:string">
  207. <xs:maxLength value="256" />
  208. </xs:restriction>
  209. </xs:simpleType>
  210. </xs:element>
  211. <xs:element name="Name_CustomerAccount" msprop:Generator_ColumnVarNameInTable="columnName_CustomerAccount" msprop:Generator_ColumnPropNameInRow="Name_CustomerAccount" msprop:Generator_ColumnPropNameInTable="Name_CustomerAccountColumn" msprop:Generator_UserColumnName="Name_CustomerAccount" minOccurs="0">
  212. <xs:simpleType>
  213. <xs:restriction base="xs:string">
  214. <xs:maxLength value="64" />
  215. </xs:restriction>
  216. </xs:simpleType>
  217. </xs:element>
  218. <xs:element name="Postcode_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnPostcode_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Postcode_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Postcode_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Postcode_IndentBillOnNet" minOccurs="0">
  219. <xs:simpleType>
  220. <xs:restriction base="xs:string">
  221. <xs:maxLength value="64" />
  222. </xs:restriction>
  223. </xs:simpleType>
  224. </xs:element>
  225. <xs:element name="No_Customer" msprop:Generator_ColumnVarNameInTable="columnNo_Customer" msprop:Generator_ColumnPropNameInRow="No_Customer" msprop:Generator_ColumnPropNameInTable="No_CustomerColumn" msprop:Generator_UserColumnName="No_Customer" minOccurs="0">
  226. <xs:simpleType>
  227. <xs:restriction base="xs:string">
  228. <xs:maxLength value="64" />
  229. </xs:restriction>
  230. </xs:simpleType>
  231. </xs:element>
  232. <xs:element name="Name_Customer" msprop:Generator_ColumnVarNameInTable="columnName_Customer" msprop:Generator_ColumnPropNameInRow="Name_Customer" msprop:Generator_ColumnPropNameInTable="Name_CustomerColumn" msprop:Generator_UserColumnName="Name_Customer" minOccurs="0">
  233. <xs:simpleType>
  234. <xs:restriction base="xs:string">
  235. <xs:maxLength value="64" />
  236. </xs:restriction>
  237. </xs:simpleType>
  238. </xs:element>
  239. <xs:element name="ShortName_Customer" msprop:Generator_ColumnVarNameInTable="columnShortName_Customer" msprop:Generator_ColumnPropNameInRow="ShortName_Customer" msprop:Generator_ColumnPropNameInTable="ShortName_CustomerColumn" msprop:Generator_UserColumnName="ShortName_Customer" minOccurs="0">
  240. <xs:simpleType>
  241. <xs:restriction base="xs:string">
  242. <xs:maxLength value="16" />
  243. </xs:restriction>
  244. </xs:simpleType>
  245. </xs:element>
  246. <xs:element name="Type_Customer" msprop:Generator_ColumnVarNameInTable="columnType_Customer" msprop:Generator_ColumnPropNameInRow="Type_Customer" msprop:Generator_ColumnPropNameInTable="Type_CustomerColumn" msprop:Generator_UserColumnName="Type_Customer" minOccurs="0">
  247. <xs:simpleType>
  248. <xs:restriction base="xs:string">
  249. <xs:maxLength value="64" />
  250. </xs:restriction>
  251. </xs:simpleType>
  252. </xs:element>
  253. <xs:element name="LastDiscount_Customer" msprop:Generator_ColumnVarNameInTable="columnLastDiscount_Customer" msprop:Generator_ColumnPropNameInRow="LastDiscount_Customer" msprop:Generator_ColumnPropNameInTable="LastDiscount_CustomerColumn" msprop:Generator_UserColumnName="LastDiscount_Customer" type="xs:decimal" minOccurs="0" />
  254. <xs:element name="PostalCode_Customer" msprop:Generator_ColumnVarNameInTable="columnPostalCode_Customer" msprop:Generator_ColumnPropNameInRow="PostalCode_Customer" msprop:Generator_ColumnPropNameInTable="PostalCode_CustomerColumn" msprop:Generator_UserColumnName="PostalCode_Customer" minOccurs="0">
  255. <xs:simpleType>
  256. <xs:restriction base="xs:string">
  257. <xs:maxLength value="32" />
  258. </xs:restriction>
  259. </xs:simpleType>
  260. </xs:element>
  261. <xs:element name="Name_Assessor" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnName_Assessor" msprop:Generator_ColumnPropNameInRow="Name_Assessor" msprop:Generator_ColumnPropNameInTable="Name_AssessorColumn" msprop:Generator_UserColumnName="Name_Assessor" minOccurs="0">
  262. <xs:simpleType>
  263. <xs:restriction base="xs:string">
  264. <xs:maxLength value="64" />
  265. </xs:restriction>
  266. </xs:simpleType>
  267. </xs:element>
  268. <xs:element name="CustomerCreator" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCustomerCreator" msprop:Generator_ColumnPropNameInRow="CustomerCreator" msprop:Generator_ColumnPropNameInTable="CustomerCreatorColumn" msprop:Generator_UserColumnName="CustomerCreator" type="xs:string" minOccurs="0" />
  269. </xs:sequence>
  270. </xs:complexType>
  271. </xs:element>
  272. <xs:element name="IndentBillOnNetProduct" msprop:Generator_TableClassName="IndentBillOnNetProductDataTable" msprop:Generator_TableVarName="tableIndentBillOnNetProduct" msprop:Generator_TablePropName="IndentBillOnNetProduct" msprop:Generator_RowDeletingName="IndentBillOnNetProductRowDeleting" msprop:Generator_RowChangingName="IndentBillOnNetProductRowChanging" msprop:Generator_RowEvHandlerName="IndentBillOnNetProductRowChangeEventHandler" msprop:Generator_RowDeletedName="IndentBillOnNetProductRowDeleted" msprop:Generator_UserTableName="IndentBillOnNetProduct" msprop:Generator_RowChangedName="IndentBillOnNetProductRowChanged" msprop:Generator_RowEvArgName="IndentBillOnNetProductRowChangeEvent" msprop:Generator_RowClassName="IndentBillOnNetProductRow">
  273. <xs:complexType>
  274. <xs:sequence>
  275. <xs:element name="ID_IndentBillOnNetProduct" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="ID_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="ID_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="ID_IndentBillOnNetProduct" type="xs:string" />
  276. <xs:element name="No_IndentBillOnNetProduct" msprop:Generator_ColumnVarNameInTable="columnNo_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="No_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="No_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="No_IndentBillOnNetProduct">
  277. <xs:simpleType>
  278. <xs:restriction base="xs:string">
  279. <xs:maxLength value="64" />
  280. </xs:restriction>
  281. </xs:simpleType>
  282. </xs:element>
  283. <xs:element name="ID_IndentBillOnNet" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="ID_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="ID_IndentBillOnNetColumn" msprop:Generator_UserColumnName="ID_IndentBillOnNet" type="xs:string" />
  284. <xs:element name="ID_Product" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_Product" msprop:Generator_ColumnPropNameInRow="ID_Product" msprop:Generator_ColumnPropNameInTable="ID_ProductColumn" msprop:Generator_UserColumnName="ID_Product" type="xs:string" />
  285. <xs:element name="Quantity_IndentBillOnNetProduct" msprop:Generator_ColumnVarNameInTable="columnQuantity_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="Quantity_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="Quantity_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="Quantity_IndentBillOnNetProduct" type="xs:decimal" />
  286. <xs:element name="UnitPrice_IndentBillOnNetProduct" msprop:Generator_ColumnVarNameInTable="columnUnitPrice_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="UnitPrice_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="UnitPrice_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="UnitPrice_IndentBillOnNetProduct" type="xs:decimal" />
  287. <xs:element name="Comment_IndentBillOnNetProduct" msprop:Generator_ColumnVarNameInTable="columnComment_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="Comment_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="Comment_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="Comment_IndentBillOnNetProduct" minOccurs="0">
  288. <xs:simpleType>
  289. <xs:restriction base="xs:string">
  290. <xs:maxLength value="256" />
  291. </xs:restriction>
  292. </xs:simpleType>
  293. </xs:element>
  294. <xs:element name="Amount_SaleBill" msprop:Generator_ColumnVarNameInTable="columnAmount_SaleBill" msprop:Generator_ColumnPropNameInRow="Amount_SaleBill" msprop:Generator_ColumnPropNameInTable="Amount_SaleBillColumn" msprop:Generator_UserColumnName="Amount_SaleBill" type="xs:decimal" />
  295. <xs:element name="No_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnNo_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="No_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="No_IndentBillOnNetColumn" msprop:Generator_UserColumnName="No_IndentBillOnNet" minOccurs="0">
  296. <xs:simpleType>
  297. <xs:restriction base="xs:string">
  298. <xs:maxLength value="64" />
  299. </xs:restriction>
  300. </xs:simpleType>
  301. </xs:element>
  302. <xs:element name="No_Product" msprop:Generator_ColumnVarNameInTable="columnNo_Product" msprop:Generator_ColumnPropNameInRow="No_Product" msprop:Generator_ColumnPropNameInTable="No_ProductColumn" msprop:Generator_UserColumnName="No_Product" minOccurs="0">
  303. <xs:simpleType>
  304. <xs:restriction base="xs:string">
  305. <xs:maxLength value="64" />
  306. </xs:restriction>
  307. </xs:simpleType>
  308. </xs:element>
  309. <xs:element name="Name_Product" msprop:Generator_ColumnVarNameInTable="columnName_Product" msprop:Generator_ColumnPropNameInRow="Name_Product" msprop:Generator_ColumnPropNameInTable="Name_ProductColumn" msprop:Generator_UserColumnName="Name_Product" minOccurs="0">
  310. <xs:simpleType>
  311. <xs:restriction base="xs:string">
  312. <xs:maxLength value="64" />
  313. </xs:restriction>
  314. </xs:simpleType>
  315. </xs:element>
  316. <xs:element name="Unit_Product" msprop:Generator_ColumnVarNameInTable="columnUnit_Product" msprop:Generator_ColumnPropNameInRow="Unit_Product" msprop:Generator_ColumnPropNameInTable="Unit_ProductColumn" msprop:Generator_UserColumnName="Unit_Product" minOccurs="0">
  317. <xs:simpleType>
  318. <xs:restriction base="xs:string">
  319. <xs:maxLength value="64" />
  320. </xs:restriction>
  321. </xs:simpleType>
  322. </xs:element>
  323. <xs:element name="Amount_IndentBillOnNetProduct" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAmount_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="Amount_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="Amount_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="Amount_IndentBillOnNetProduct" type="xs:decimal" minOccurs="0" />
  324. <xs:element name="No_IndentBillOnNet1" msprop:Generator_ColumnVarNameInTable="columnNo_IndentBillOnNet1" msprop:Generator_ColumnPropNameInRow="No_IndentBillOnNet1" msprop:Generator_ColumnPropNameInTable="No_IndentBillOnNet1Column" msprop:Generator_UserColumnName="No_IndentBillOnNet1" minOccurs="0">
  325. <xs:simpleType>
  326. <xs:restriction base="xs:string">
  327. <xs:maxLength value="64" />
  328. </xs:restriction>
  329. </xs:simpleType>
  330. </xs:element>
  331. </xs:sequence>
  332. </xs:complexType>
  333. </xs:element>
  334. <xs:element name="AppendInfo" msprop:Generator_TableClassName="AppendInfoDataTable" msprop:Generator_TableVarName="tableAppendInfo" msprop:Generator_TablePropName="AppendInfo" msprop:Generator_RowDeletingName="AppendInfoRowDeleting" msprop:Generator_RowChangingName="AppendInfoRowChanging" msprop:Generator_RowEvHandlerName="AppendInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="AppendInfoRowDeleted" msprop:Generator_UserTableName="AppendInfo" msprop:Generator_RowChangedName="AppendInfoRowChanged" msprop:Generator_RowEvArgName="AppendInfoRowChangeEvent" msprop:Generator_RowClassName="AppendInfoRow">
  335. <xs:complexType>
  336. <xs:sequence>
  337. <xs:element name="CurrentCompany" msprop:Generator_ColumnVarNameInTable="columnCurrentCompany" msprop:Generator_ColumnPropNameInRow="CurrentCompany" msprop:Generator_ColumnPropNameInTable="CurrentCompanyColumn" msprop:Generator_UserColumnName="CurrentCompany" type="xs:string" minOccurs="0" />
  338. <xs:element name="CurrentUser" msprop:Generator_ColumnVarNameInTable="columnCurrentUser" msprop:Generator_ColumnPropNameInRow="CurrentUser" msprop:Generator_ColumnPropNameInTable="CurrentUserColumn" msprop:Generator_UserColumnName="CurrentUser" type="xs:string" minOccurs="0" />
  339. </xs:sequence>
  340. </xs:complexType>
  341. </xs:element>
  342. </xs:choice>
  343. </xs:complexType>
  344. <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  345. <xs:selector xpath=".//mstns:IndentBillOnNet" />
  346. <xs:field xpath="mstns:ID_IndentBillOnNet" />
  347. </xs:unique>
  348. <xs:unique name="IndentBillOnNetProduct_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  349. <xs:selector xpath=".//mstns:IndentBillOnNetProduct" />
  350. <xs:field xpath="mstns:ID_IndentBillOnNetProduct" />
  351. </xs:unique>
  352. </xs:element>
  353. </xs:schema>