Home Explore Help
Register Sign In
Demish
/
c_kon
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
c_kon
/
KokursTest2
/
konkursDataSet.xsd

konkursDataSet.xsd 14 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145 
  1. <?xml version="1.0" encoding="utf-8"?>
    2. 

  2. <xs:schema id="konkursDataSet" targetNamespace="http://tempuri.org/konkursDataSet.xsd" xmlns:mstns="http://tempuri.org/konkursDataSet.xsd" xmlns="http://tempuri.org/konkursDataSet.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. 

  3.   <xs:annotation>
    4. 

  4.     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
    5. 

  5.       <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
    6. 

  6.         <Connections>
    7. 

  7.           <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="konkursConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="konkursConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KokursTest2.Properties.Settings.GlobalReference.Default.konkursConnectionString" Provider="System.Data.SqlClient" />
    8. 

  8.         </Connections>
    9. 

  9.         <Tables>
    10. 

  10.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="bronirovaniTableAdapter" GeneratorDataComponentClassName="bronirovaniTableAdapter" Name="bronirovani" UserDataComponentName="bronirovaniTableAdapter">
    11. 

  11.             <MainSource>
    12. 

  12.               <DbSource ConnectionRef="konkursConnectionString (Settings)" DbObjectName="konkurs.dbo.bronirovani" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    13. 

  13.                 <InsertCommand>
    14. 

  14.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    15. 

  15.                     <CommandText>INSERT INTO [dbo].[bronirovani] ([date_bronirovania], [col_days]) VALUES (@date_bronirovania, @col_days)</CommandText>
    16. 

  16.                     <Parameters>
    17. 

  17.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_bronirovania" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_bronirovania" SourceColumnNullMapping="false" SourceVersion="Current" />
    18. 

  18.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@col_days" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="col_days" SourceColumnNullMapping="false" SourceVersion="Current" />
    19. 

  19.                     </Parameters>
    20. 

  20.                   </DbCommand>
    21. 

  21.                 </InsertCommand>
    22. 

  22.                 <SelectCommand>
    23. 

  23.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    24. 

  24.                     <CommandText>SELECT date_bronirovania, col_days FROM dbo.bronirovani</CommandText>
    25. 

  25.                     <Parameters />
    26. 

  26.                   </DbCommand>
    27. 

  27.                 </SelectCommand>
    28. 

  28.               </DbSource>
    29. 

  29.             </MainSource>
    30. 

  30.             <Mappings>
    31. 

  31.               <Mapping SourceColumn="date_bronirovania" DataSetColumn="date_bronirovania" />
    32. 

  32.               <Mapping SourceColumn="col_days" DataSetColumn="col_days" />
    33. 

  33.             </Mappings>
    34. 

  34.             <Sources />
    35. 

  35.           </TableAdapter>
    36. 

  36.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="comfortTableAdapter" GeneratorDataComponentClassName="comfortTableAdapter" Name="comfort" UserDataComponentName="comfortTableAdapter">
    37. 

  37.             <MainSource>
    38. 

  38.               <DbSource ConnectionRef="konkursConnectionString (Settings)" DbObjectName="konkurs.dbo.comfort" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    39. 

  39.                 <InsertCommand>
    40. 

  40.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    41. 

  41.                     <CommandText>INSERT INTO [dbo].[comfort] ([price_broni], [price_projiv]) VALUES (@price_broni, @price_projiv)</CommandText>
    42. 

  42.                     <Parameters>
    43. 

  43.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@price_broni" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="price_broni" SourceColumnNullMapping="false" SourceVersion="Current" />
    44. 

  44.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@price_projiv" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="price_projiv" SourceColumnNullMapping="false" SourceVersion="Current" />
    45. 

  45.                     </Parameters>
    46. 

  46.                   </DbCommand>
    47. 

  47.                 </InsertCommand>
    48. 

  48.                 <SelectCommand>
    49. 

  49.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    50. 

  50.                     <CommandText>SELECT lvl_comfort, price_broni, price_projiv FROM dbo.comfort</CommandText>
    51. 

  51.                     <Parameters />
    52. 

  52.                   </DbCommand>
    53. 

  53.                 </SelectCommand>
    54. 

  54.               </DbSource>
    55. 

  55.             </MainSource>
    56. 

  56.             <Mappings>
    57. 

  57.               <Mapping SourceColumn="lvl_comfort" DataSetColumn="lvl_comfort" />
    58. 

  58.               <Mapping SourceColumn="price_broni" DataSetColumn="price_broni" />
    59. 

  59.               <Mapping SourceColumn="price_projiv" DataSetColumn="price_projiv" />
    60. 

  60.             </Mappings>
    61. 

  61.             <Sources />
    62. 

  62.           </TableAdapter>
    63. 

  63.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="nomerTableAdapter" GeneratorDataComponentClassName="nomerTableAdapter" Name="nomer" UserDataComponentName="nomerTableAdapter">
    64. 

  64.             <MainSource>
    65. 

  65.               <DbSource ConnectionRef="konkursConnectionString (Settings)" DbObjectName="konkurs.dbo.nomer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    66. 

  66.                 <DeleteCommand>
    67. 

  67.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    68. 

  68.                     <CommandText>DELETE FROM [dbo].[nomer] WHERE (([nomer_comnat] = @Original_nomer_comnat))</CommandText>
    69. 

  69.                     <Parameters>
    70. 

  70.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nomer_comnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomer_comnat" SourceColumnNullMapping="false" SourceVersion="Original" />
    71. 

  71.                     </Parameters>
    72. 

  72.                   </DbCommand>
    73. 

  73.                 </DeleteCommand>
    74. 

  74.                 <InsertCommand>
    75. 

  75.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    76. 

  76.                     <CommandText>INSERT INTO [dbo].[nomer] DEFAULT VALUES;
    77. 

  77. SELECT nomer_comnat FROM nomer WHERE (nomer_comnat = SCOPE_IDENTITY())</CommandText>
    78. 

  78.                     <Parameters />
    79. 

  79.                   </DbCommand>
    80. 

  80.                 </InsertCommand>
    81. 

  81.                 <SelectCommand>
    82. 

  82.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    83. 

  83.                     <CommandText>SELECT nomer_comnat FROM dbo.nomer</CommandText>
    84. 

  84.                     <Parameters />
    85. 

  85.                   </DbCommand>
    86. 

  86.                 </SelectCommand>
    87. 

  87.               </DbSource>
    88. 

  88.             </MainSource>
    89. 

  89.             <Mappings>
    90. 

  90.               <Mapping SourceColumn="nomer_comnat" DataSetColumn="nomer_comnat" />
    91. 

  91.             </Mappings>
    92. 

  92.             <Sources />
    93. 

  93.           </TableAdapter>
    94. 

  94.         </Tables>
    95. 

  95.         <Sources />
    96. 

  96.       </DataSource>
    97. 

  97.     </xs:appinfo>
    98. 

  98.   </xs:annotation>
    99. 

  99.   <xs:element name="konkursDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="konkursDataSet" msprop:Generator_UserDSName="konkursDataSet">
    100. 

  100.     <xs:complexType>
    101. 

  101.       <xs:choice minOccurs="0" maxOccurs="unbounded">
    102. 

  102.         <xs:element name="bronirovani" msprop:Generator_TableClassName="bronirovaniDataTable" msprop:Generator_TableVarName="tablebronirovani" msprop:Generator_TablePropName="bronirovani" msprop:Generator_RowDeletingName="bronirovaniRowDeleting" msprop:Generator_RowChangingName="bronirovaniRowChanging" msprop:Generator_RowEvHandlerName="bronirovaniRowChangeEventHandler" msprop:Generator_RowDeletedName="bronirovaniRowDeleted" msprop:Generator_UserTableName="bronirovani" msprop:Generator_RowChangedName="bronirovaniRowChanged" msprop:Generator_RowEvArgName="bronirovaniRowChangeEvent" msprop:Generator_RowClassName="bronirovaniRow">
    103. 

  103.           <xs:complexType>
    104. 

  104.             <xs:sequence>
    105. 

  105.               <xs:element name="date_bronirovania" msprop:Generator_ColumnVarNameInTable="columndate_bronirovania" msprop:Generator_ColumnPropNameInRow="date_bronirovania" msprop:Generator_ColumnPropNameInTable="date_bronirovaniaColumn" msprop:Generator_UserColumnName="date_bronirovania" type="xs:dateTime" minOccurs="0" />
    106. 

  106.               <xs:element name="col_days" msprop:Generator_ColumnVarNameInTable="columncol_days" msprop:Generator_ColumnPropNameInRow="col_days" msprop:Generator_ColumnPropNameInTable="col_daysColumn" msprop:Generator_UserColumnName="col_days" type="xs:int" minOccurs="0" />
    107. 

  107.             </xs:sequence>
    108. 

  108.           </xs:complexType>
    109. 

  109.         </xs:element>
    110. 

  110.         <xs:element name="comfort" msprop:Generator_TableClassName="comfortDataTable" msprop:Generator_TableVarName="tablecomfort" msprop:Generator_TablePropName="comfort" msprop:Generator_RowDeletingName="comfortRowDeleting" msprop:Generator_RowChangingName="comfortRowChanging" msprop:Generator_RowEvHandlerName="comfortRowChangeEventHandler" msprop:Generator_RowDeletedName="comfortRowDeleted" msprop:Generator_UserTableName="comfort" msprop:Generator_RowChangedName="comfortRowChanged" msprop:Generator_RowEvArgName="comfortRowChangeEvent" msprop:Generator_RowClassName="comfortRow">
    111. 

  111.           <xs:complexType>
    112. 

  112.             <xs:sequence>
    113. 

  113.               <xs:element name="lvl_comfort" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnlvl_comfort" msprop:Generator_ColumnPropNameInRow="lvl_comfort" msprop:Generator_ColumnPropNameInTable="lvl_comfortColumn" msprop:Generator_UserColumnName="lvl_comfort" type="xs:int" />
    114. 

  114.               <xs:element name="price_broni" msprop:Generator_ColumnVarNameInTable="columnprice_broni" msprop:Generator_ColumnPropNameInRow="price_broni" msprop:Generator_ColumnPropNameInTable="price_broniColumn" msprop:Generator_UserColumnName="price_broni" minOccurs="0">
    115. 

  115.                 <xs:simpleType>
    116. 

  116.                   <xs:restriction base="xs:string">
    117. 

  117.                     <xs:maxLength value="10" />
    118. 

  118.                   </xs:restriction>
    119. 

  119.                 </xs:simpleType>
    120. 

  120.               </xs:element>
    121. 

  121.               <xs:element name="price_projiv" msprop:Generator_ColumnVarNameInTable="columnprice_projiv" msprop:Generator_ColumnPropNameInRow="price_projiv" msprop:Generator_ColumnPropNameInTable="price_projivColumn" msprop:Generator_UserColumnName="price_projiv" minOccurs="0">
    122. 

  122.                 <xs:simpleType>
    123. 

  123.                   <xs:restriction base="xs:string">
    124. 

  124.                     <xs:maxLength value="10" />
    125. 

  125.                   </xs:restriction>
    126. 

  126.                 </xs:simpleType>
    127. 

  127.               </xs:element>
    128. 

  128.             </xs:sequence>
    129. 

  129.           </xs:complexType>
    130. 

  130.         </xs:element>
    131. 

  131.         <xs:element name="nomer" msprop:Generator_TableClassName="nomerDataTable" msprop:Generator_TableVarName="tablenomer" msprop:Generator_TablePropName="nomer" msprop:Generator_RowDeletingName="nomerRowDeleting" msprop:Generator_RowChangingName="nomerRowChanging" msprop:Generator_RowEvHandlerName="nomerRowChangeEventHandler" msprop:Generator_RowDeletedName="nomerRowDeleted" msprop:Generator_UserTableName="nomer" msprop:Generator_RowChangedName="nomerRowChanged" msprop:Generator_RowEvArgName="nomerRowChangeEvent" msprop:Generator_RowClassName="nomerRow">
    132. 

  132.           <xs:complexType>
    133. 

  133.             <xs:sequence>
    134. 

  134.               <xs:element name="nomer_comnat" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnomer_comnat" msprop:Generator_ColumnPropNameInRow="nomer_comnat" msprop:Generator_ColumnPropNameInTable="nomer_comnatColumn" msprop:Generator_UserColumnName="nomer_comnat" type="xs:int" />
    135. 

  135.             </xs:sequence>
    136. 

  136.           </xs:complexType>
    137. 

  137.         </xs:element>
    138. 

  138.       </xs:choice>
    139. 

  139.     </xs:complexType>
    140. 

  140.     <xs:unique name="Constraint1" msdata:PrimaryKey="true">
    141. 

  141.       <xs:selector xpath=".//mstns:nomer" />
    142. 

  142.       <xs:field xpath="mstns:nomer_comnat" />
    143. 

  143.     </xs:unique>
    144. 

  144.   </xs:element>
    145. 

  145. </xs:schema>
    146.