Prokatavto06DataSet.xsd 90 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <xs:schema id="Prokatavto06DataSet" targetNamespace="http://tempuri.org/Prokatavto06DataSet.xsd" xmlns:mstns="http://tempuri.org/Prokatavto06DataSet.xsd" xmlns="http://tempuri.org/Prokatavto06DataSet.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" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6. <Connections>
  7. <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Prokatavto06ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Prokatavto06ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.avtoprokatvel.Properties.Settings.GlobalReference.Default.Prokatavto06ConnectionString" Provider="System.Data.SqlClient" />
  8. </Connections>
  9. <Tables>
  10. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AvtoTableAdapter" GeneratorDataComponentClassName="AvtoTableAdapter" Name="Avto" UserDataComponentName="AvtoTableAdapter">
  11. <MainSource>
  12. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.Avto" 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. <DeleteCommand>
  14. <DbCommand CommandType="Text" ModifiedByUser="false">
  15. <CommandText>DELETE FROM [dbo].[Avto] WHERE (([Kod avto] = @Original_Kod_avto) AND ([Model avto] = @Original_Model_avto) AND ([Cvet avto] = @Original_Cvet_avto) AND ([God vipyska avto] = @Original_God_vipyska_avto) AND ([Gos nomer avto] = @Original_Gos_nomer_avto) AND ([strahovaya stoimost avto] = @Original_strahovaya_stoimost_avto) AND ((@IsNull_Kod_strahovki = 1 AND [Kod strahovki] IS NULL) OR ([Kod strahovki] = @Original_Kod_strahovki)))</CommandText>
  16. <Parameters>
  17. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_avto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  18. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Model_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Model avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  19. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cvet_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cvet avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  20. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_God_vipyska_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="God vipyska avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  21. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gos_nomer_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gos nomer avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  22. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_strahovaya_stoimost_avto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="strahovaya stoimost avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  23. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kod_strahovki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod strahovki" SourceColumnNullMapping="true" SourceVersion="Original" />
  24. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_strahovki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod strahovki" SourceColumnNullMapping="false" SourceVersion="Original" />
  25. </Parameters>
  26. </DbCommand>
  27. </DeleteCommand>
  28. <InsertCommand>
  29. <DbCommand CommandType="Text" ModifiedByUser="false">
  30. <CommandText>INSERT INTO [dbo].[Avto] ([Model avto], [Cvet avto], [God vipyska avto], [Gos nomer avto], [strahovaya stoimost avto], [Kod strahovki]) VALUES (@Model_avto, @Cvet_avto, @God_vipyska_avto, @Gos_nomer_avto, @strahovaya_stoimost_avto, @Kod_strahovki);
  31. SELECT [Kod avto], [Model avto], [Cvet avto], [God vipyska avto], [Gos nomer avto], [strahovaya stoimost avto], [Kod strahovki] FROM Avto WHERE ([Kod avto] = SCOPE_IDENTITY())</CommandText>
  32. <Parameters>
  33. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Model_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Model avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  34. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cvet_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cvet avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  35. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@God_vipyska_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="God vipyska avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  36. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gos_nomer_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gos nomer avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  37. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@strahovaya_stoimost_avto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="strahovaya stoimost avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  38. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Kod_strahovki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod strahovki" SourceColumnNullMapping="false" SourceVersion="Current" />
  39. </Parameters>
  40. </DbCommand>
  41. </InsertCommand>
  42. <SelectCommand>
  43. <DbCommand CommandType="Text" ModifiedByUser="false">
  44. <CommandText>SELECT [Kod avto], [Model avto], [Cvet avto], [God vipyska avto], [Gos nomer avto], [strahovaya stoimost avto], [Kod strahovki] FROM dbo.Avto</CommandText>
  45. <Parameters />
  46. </DbCommand>
  47. </SelectCommand>
  48. <UpdateCommand>
  49. <DbCommand CommandType="Text" ModifiedByUser="false">
  50. <CommandText>UPDATE [dbo].[Avto] SET [Model avto] = @Model_avto, [Cvet avto] = @Cvet_avto, [God vipyska avto] = @God_vipyska_avto, [Gos nomer avto] = @Gos_nomer_avto, [strahovaya stoimost avto] = @strahovaya_stoimost_avto, [Kod strahovki] = @Kod_strahovki WHERE (([Kod avto] = @Original_Kod_avto) AND ([Model avto] = @Original_Model_avto) AND ([Cvet avto] = @Original_Cvet_avto) AND ([God vipyska avto] = @Original_God_vipyska_avto) AND ([Gos nomer avto] = @Original_Gos_nomer_avto) AND ([strahovaya stoimost avto] = @Original_strahovaya_stoimost_avto) AND ((@IsNull_Kod_strahovki = 1 AND [Kod strahovki] IS NULL) OR ([Kod strahovki] = @Original_Kod_strahovki)));
  51. SELECT [Kod avto], [Model avto], [Cvet avto], [God vipyska avto], [Gos nomer avto], [strahovaya stoimost avto], [Kod strahovki] FROM Avto WHERE ([Kod avto] = @Kod_avto)</CommandText>
  52. <Parameters>
  53. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Model_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Model avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  54. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Cvet_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cvet avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  55. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@God_vipyska_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="God vipyska avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  56. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gos_nomer_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gos nomer avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  57. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@strahovaya_stoimost_avto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="strahovaya stoimost avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  58. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Kod_strahovki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod strahovki" SourceColumnNullMapping="false" SourceVersion="Current" />
  59. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_avto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  60. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Model_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Model avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  61. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Cvet_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Cvet avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  62. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_God_vipyska_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="God vipyska avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  63. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gos_nomer_avto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gos nomer avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  64. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_strahovaya_stoimost_avto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="strahovaya stoimost avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  65. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kod_strahovki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod strahovki" SourceColumnNullMapping="true" SourceVersion="Original" />
  66. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_strahovki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod strahovki" SourceColumnNullMapping="false" SourceVersion="Original" />
  67. <Parameter AllowDbNull="false" AutogeneratedName="Kod_avto" ColumnName="Kod avto" DataSourceName="Prokatavto06.dbo.Avto" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Kod_avto" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Kod avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  68. </Parameters>
  69. </DbCommand>
  70. </UpdateCommand>
  71. </DbSource>
  72. </MainSource>
  73. <Mappings>
  74. <Mapping SourceColumn="Kod avto" DataSetColumn="Kod avto" />
  75. <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
  76. <Mapping SourceColumn="Cvet avto" DataSetColumn="Cvet avto" />
  77. <Mapping SourceColumn="God vipyska avto" DataSetColumn="God vipyska avto" />
  78. <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
  79. <Mapping SourceColumn="strahovaya stoimost avto" DataSetColumn="strahovaya stoimost avto" />
  80. <Mapping SourceColumn="Kod strahovki" DataSetColumn="Kod strahovki" />
  81. </Mappings>
  82. <Sources />
  83. </TableAdapter>
  84. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="KlientTableAdapter" GeneratorDataComponentClassName="KlientTableAdapter" Name="Klient" UserDataComponentName="KlientTableAdapter">
  85. <MainSource>
  86. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.Klient" 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">
  87. <DeleteCommand>
  88. <DbCommand CommandType="Text" ModifiedByUser="false">
  89. <CommandText>DELETE FROM [dbo].[Klient] WHERE (([Kod klienta] = @Original_Kod_klienta) AND ([FIO klienta] = @Original_FIO_klienta) AND ([Seria pasporta] = @Original_Seria_pasporta) AND ([Nomer pasporta] = @Original_Nomer_pasporta))</CommandText>
  90. <Parameters>
  91. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
  92. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FIO_klienta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
  93. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Seria_pasporta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Seria pasporta" SourceColumnNullMapping="false" SourceVersion="Original" />
  94. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nomer_pasporta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nomer pasporta" SourceColumnNullMapping="false" SourceVersion="Original" />
  95. </Parameters>
  96. </DbCommand>
  97. </DeleteCommand>
  98. <InsertCommand>
  99. <DbCommand CommandType="Text" ModifiedByUser="false">
  100. <CommandText>INSERT INTO [dbo].[Klient] ([FIO klienta], [Seria pasporta], [Nomer pasporta]) VALUES (@FIO_klienta, @Seria_pasporta, @Nomer_pasporta);
  101. SELECT [Kod klienta], [FIO klienta], [Seria pasporta], [Nomer pasporta] FROM Klient WHERE ([Kod klienta] = SCOPE_IDENTITY())</CommandText>
  102. <Parameters>
  103. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FIO_klienta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
  104. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Seria_pasporta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Seria pasporta" SourceColumnNullMapping="false" SourceVersion="Current" />
  105. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nomer_pasporta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nomer pasporta" SourceColumnNullMapping="false" SourceVersion="Current" />
  106. </Parameters>
  107. </DbCommand>
  108. </InsertCommand>
  109. <SelectCommand>
  110. <DbCommand CommandType="Text" ModifiedByUser="false">
  111. <CommandText>SELECT [Kod klienta], [FIO klienta], [Seria pasporta], [Nomer pasporta] FROM dbo.Klient</CommandText>
  112. <Parameters />
  113. </DbCommand>
  114. </SelectCommand>
  115. <UpdateCommand>
  116. <DbCommand CommandType="Text" ModifiedByUser="false">
  117. <CommandText>UPDATE [dbo].[Klient] SET [FIO klienta] = @FIO_klienta, [Seria pasporta] = @Seria_pasporta, [Nomer pasporta] = @Nomer_pasporta WHERE (([Kod klienta] = @Original_Kod_klienta) AND ([FIO klienta] = @Original_FIO_klienta) AND ([Seria pasporta] = @Original_Seria_pasporta) AND ([Nomer pasporta] = @Original_Nomer_pasporta));
  118. SELECT [Kod klienta], [FIO klienta], [Seria pasporta], [Nomer pasporta] FROM Klient WHERE ([Kod klienta] = @Kod_klienta)</CommandText>
  119. <Parameters>
  120. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FIO_klienta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
  121. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Seria_pasporta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Seria pasporta" SourceColumnNullMapping="false" SourceVersion="Current" />
  122. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nomer_pasporta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nomer pasporta" SourceColumnNullMapping="false" SourceVersion="Current" />
  123. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
  124. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FIO_klienta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
  125. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Seria_pasporta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Seria pasporta" SourceColumnNullMapping="false" SourceVersion="Original" />
  126. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nomer_pasporta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nomer pasporta" SourceColumnNullMapping="false" SourceVersion="Original" />
  127. <Parameter AllowDbNull="false" AutogeneratedName="Kod_klienta" ColumnName="Kod klienta" DataSourceName="Prokatavto06.dbo.Klient" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Kod_klienta" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Kod klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
  128. </Parameters>
  129. </DbCommand>
  130. </UpdateCommand>
  131. </DbSource>
  132. </MainSource>
  133. <Mappings>
  134. <Mapping SourceColumn="Kod klienta" DataSetColumn="Kod klienta" />
  135. <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
  136. <Mapping SourceColumn="Seria pasporta" DataSetColumn="Seria pasporta" />
  137. <Mapping SourceColumn="Nomer pasporta" DataSetColumn="Nomer pasporta" />
  138. </Mappings>
  139. <Sources />
  140. </TableAdapter>
  141. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProkatTableAdapter" GeneratorDataComponentClassName="ProkatTableAdapter" Name="Prokat" UserDataComponentName="ProkatTableAdapter">
  142. <MainSource>
  143. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.Prokat" 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">
  144. <DeleteCommand>
  145. <DbCommand CommandType="Text" ModifiedByUser="false">
  146. <CommandText>DELETE FROM [dbo].[Prokat] WHERE (([Kod prokata] = @Original_Kod_prokata) AND ([Stoimost odnogo dnya prokata] = @Original_Stoimost_odnogo_dnya_prokata) AND ([Data nachala prokata] = @Original_Data_nachala_prokata) AND ([Kolichestvo dnei prokata] = @Original_Kolichestvo_dnei_prokata) AND ([Kod klienta] = @Original_Kod_klienta) AND ([Kod avto] = @Original_Kod_avto))</CommandText>
  147. <Parameters>
  148. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_prokata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod prokata" SourceColumnNullMapping="false" SourceVersion="Original" />
  149. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Stoimost_odnogo_dnya_prokata" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Stoimost odnogo dnya prokata" SourceColumnNullMapping="false" SourceVersion="Original" />
  150. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_nachala_prokata" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data nachala prokata" SourceColumnNullMapping="false" SourceVersion="Original" />
  151. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Kolichestvo_dnei_prokata" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Kolichestvo dnei prokata" SourceColumnNullMapping="false" SourceVersion="Original" />
  152. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
  153. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_avto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  154. </Parameters>
  155. </DbCommand>
  156. </DeleteCommand>
  157. <InsertCommand>
  158. <DbCommand CommandType="Text" ModifiedByUser="false">
  159. <CommandText>INSERT INTO [dbo].[Prokat] ([Stoimost odnogo dnya prokata], [Data nachala prokata], [Kolichestvo dnei prokata], [Kod klienta], [Kod avto]) VALUES (@Stoimost_odnogo_dnya_prokata, @Data_nachala_prokata, @Kolichestvo_dnei_prokata, @Kod_klienta, @Kod_avto);
  160. SELECT [Kod prokata], [Stoimost odnogo dnya prokata], [Data nachala prokata], [Kolichestvo dnei prokata], [Kod klienta], [Kod avto] FROM Prokat WHERE ([Kod prokata] = SCOPE_IDENTITY())</CommandText>
  161. <Parameters>
  162. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Stoimost_odnogo_dnya_prokata" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Stoimost odnogo dnya prokata" SourceColumnNullMapping="false" SourceVersion="Current" />
  163. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_nachala_prokata" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data nachala prokata" SourceColumnNullMapping="false" SourceVersion="Current" />
  164. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Kolichestvo_dnei_prokata" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Kolichestvo dnei prokata" SourceColumnNullMapping="false" SourceVersion="Current" />
  165. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Kod_klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
  166. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Kod_avto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  167. </Parameters>
  168. </DbCommand>
  169. </InsertCommand>
  170. <SelectCommand>
  171. <DbCommand CommandType="Text" ModifiedByUser="false">
  172. <CommandText>SELECT [Kod prokata], [Stoimost odnogo dnya prokata], [Data nachala prokata], [Kolichestvo dnei prokata], [Kod klienta], [Kod avto] FROM dbo.Prokat</CommandText>
  173. <Parameters />
  174. </DbCommand>
  175. </SelectCommand>
  176. <UpdateCommand>
  177. <DbCommand CommandType="Text" ModifiedByUser="false">
  178. <CommandText>UPDATE [dbo].[Prokat] SET [Stoimost odnogo dnya prokata] = @Stoimost_odnogo_dnya_prokata, [Data nachala prokata] = @Data_nachala_prokata, [Kolichestvo dnei prokata] = @Kolichestvo_dnei_prokata, [Kod klienta] = @Kod_klienta, [Kod avto] = @Kod_avto WHERE (([Kod prokata] = @Original_Kod_prokata) AND ([Stoimost odnogo dnya prokata] = @Original_Stoimost_odnogo_dnya_prokata) AND ([Data nachala prokata] = @Original_Data_nachala_prokata) AND ([Kolichestvo dnei prokata] = @Original_Kolichestvo_dnei_prokata) AND ([Kod klienta] = @Original_Kod_klienta) AND ([Kod avto] = @Original_Kod_avto));
  179. SELECT [Kod prokata], [Stoimost odnogo dnya prokata], [Data nachala prokata], [Kolichestvo dnei prokata], [Kod klienta], [Kod avto] FROM Prokat WHERE ([Kod prokata] = @Kod_prokata)</CommandText>
  180. <Parameters>
  181. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Stoimost_odnogo_dnya_prokata" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Stoimost odnogo dnya prokata" SourceColumnNullMapping="false" SourceVersion="Current" />
  182. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_nachala_prokata" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data nachala prokata" SourceColumnNullMapping="false" SourceVersion="Current" />
  183. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Kolichestvo_dnei_prokata" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Kolichestvo dnei prokata" SourceColumnNullMapping="false" SourceVersion="Current" />
  184. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Kod_klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
  185. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Kod_avto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod avto" SourceColumnNullMapping="false" SourceVersion="Current" />
  186. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_prokata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod prokata" SourceColumnNullMapping="false" SourceVersion="Original" />
  187. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Stoimost_odnogo_dnya_prokata" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Stoimost odnogo dnya prokata" SourceColumnNullMapping="false" SourceVersion="Original" />
  188. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_nachala_prokata" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data nachala prokata" SourceColumnNullMapping="false" SourceVersion="Original" />
  189. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Kolichestvo_dnei_prokata" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Kolichestvo dnei prokata" SourceColumnNullMapping="false" SourceVersion="Original" />
  190. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
  191. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_avto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod avto" SourceColumnNullMapping="false" SourceVersion="Original" />
  192. <Parameter AllowDbNull="false" AutogeneratedName="Kod_prokata" ColumnName="Kod prokata" DataSourceName="Prokatavto06.dbo.Prokat" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Kod_prokata" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Kod prokata" SourceColumnNullMapping="false" SourceVersion="Current" />
  193. </Parameters>
  194. </DbCommand>
  195. </UpdateCommand>
  196. </DbSource>
  197. </MainSource>
  198. <Mappings>
  199. <Mapping SourceColumn="Kod prokata" DataSetColumn="Kod prokata" />
  200. <Mapping SourceColumn="Stoimost odnogo dnya prokata" DataSetColumn="Stoimost odnogo dnya prokata" />
  201. <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
  202. <Mapping SourceColumn="Kolichestvo dnei prokata" DataSetColumn="Kolichestvo dnei prokata" />
  203. <Mapping SourceColumn="Kod klienta" DataSetColumn="Kod klienta" />
  204. <Mapping SourceColumn="Kod avto" DataSetColumn="Kod avto" />
  205. </Mappings>
  206. <Sources />
  207. </TableAdapter>
  208. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StrahovkaTableAdapter" GeneratorDataComponentClassName="StrahovkaTableAdapter" Name="Strahovka" UserDataComponentName="StrahovkaTableAdapter">
  209. <MainSource>
  210. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.Strahovka" 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">
  211. <DeleteCommand>
  212. <DbCommand CommandType="Text" ModifiedByUser="false">
  213. <CommandText>DELETE FROM [dbo].[Strahovka] WHERE (([Kod strahovki] = @Original_Kod_strahovki) AND ([Strahovoi vznos] = @Original_Strahovoi_vznos))</CommandText>
  214. <Parameters>
  215. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_strahovki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod strahovki" SourceColumnNullMapping="false" SourceVersion="Original" />
  216. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Strahovoi_vznos" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Strahovoi vznos" SourceColumnNullMapping="false" SourceVersion="Original" />
  217. </Parameters>
  218. </DbCommand>
  219. </DeleteCommand>
  220. <InsertCommand>
  221. <DbCommand CommandType="Text" ModifiedByUser="false">
  222. <CommandText>INSERT INTO [dbo].[Strahovka] ([Strahovoi vznos]) VALUES (@Strahovoi_vznos);
  223. SELECT [Kod strahovki], [Strahovoi vznos] FROM Strahovka WHERE ([Kod strahovki] = SCOPE_IDENTITY())</CommandText>
  224. <Parameters>
  225. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Strahovoi_vznos" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Strahovoi vznos" SourceColumnNullMapping="false" SourceVersion="Current" />
  226. </Parameters>
  227. </DbCommand>
  228. </InsertCommand>
  229. <SelectCommand>
  230. <DbCommand CommandType="Text" ModifiedByUser="false">
  231. <CommandText>SELECT [Kod strahovki], [Strahovoi vznos] FROM dbo.Strahovka</CommandText>
  232. <Parameters />
  233. </DbCommand>
  234. </SelectCommand>
  235. <UpdateCommand>
  236. <DbCommand CommandType="Text" ModifiedByUser="false">
  237. <CommandText>UPDATE [dbo].[Strahovka] SET [Strahovoi vznos] = @Strahovoi_vznos WHERE (([Kod strahovki] = @Original_Kod_strahovki) AND ([Strahovoi vznos] = @Original_Strahovoi_vznos));
  238. SELECT [Kod strahovki], [Strahovoi vznos] FROM Strahovka WHERE ([Kod strahovki] = @Kod_strahovki)</CommandText>
  239. <Parameters>
  240. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Strahovoi_vznos" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Strahovoi vznos" SourceColumnNullMapping="false" SourceVersion="Current" />
  241. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kod_strahovki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kod strahovki" SourceColumnNullMapping="false" SourceVersion="Original" />
  242. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Strahovoi_vznos" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Strahovoi vznos" SourceColumnNullMapping="false" SourceVersion="Original" />
  243. <Parameter AllowDbNull="false" AutogeneratedName="Kod_strahovki" ColumnName="Kod strahovki" DataSourceName="Prokatavto06.dbo.Strahovka" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Kod_strahovki" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Kod strahovki" SourceColumnNullMapping="false" SourceVersion="Current" />
  244. </Parameters>
  245. </DbCommand>
  246. </UpdateCommand>
  247. </DbSource>
  248. </MainSource>
  249. <Mappings>
  250. <Mapping SourceColumn="Kod strahovki" DataSetColumn="Kod strahovki" />
  251. <Mapping SourceColumn="Strahovoi vznos" DataSetColumn="Strahovoi vznos" />
  252. </Mappings>
  253. <Sources />
  254. </TableAdapter>
  255. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ПредставлениеПрокатTableAdapter" GeneratorDataComponentClassName="ПредставлениеПрокатTableAdapter" Name="ПредставлениеПрокат" UserDataComponentName="ПредставлениеПрокатTableAdapter">
  256. <MainSource>
  257. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.ПредставлениеПрокат" DbObjectType="View" 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="true" UserGetMethodName="GetData" UserSourceName="Fill">
  258. <SelectCommand>
  259. <DbCommand CommandType="Text" ModifiedByUser="false">
  260. <CommandText>SELECT [Model avto], [Gos nomer avto], [FIO klienta], [Seria pasporta], [Nomer pasporta], [Stoimost odnogo dnya prokata], [Data nachala prokata], [Kolichestvo dnei prokata], [Дата окончания проката] FROM dbo.ПредставлениеПрокат</CommandText>
  261. <Parameters />
  262. </DbCommand>
  263. </SelectCommand>
  264. </DbSource>
  265. </MainSource>
  266. <Mappings>
  267. <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
  268. <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
  269. <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
  270. <Mapping SourceColumn="Seria pasporta" DataSetColumn="Seria pasporta" />
  271. <Mapping SourceColumn="Nomer pasporta" DataSetColumn="Nomer pasporta" />
  272. <Mapping SourceColumn="Stoimost odnogo dnya prokata" DataSetColumn="Stoimost odnogo dnya prokata" />
  273. <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
  274. <Mapping SourceColumn="Kolichestvo dnei prokata" DataSetColumn="Kolichestvo dnei prokata" />
  275. <Mapping SourceColumn="Дата окончания проката" DataSetColumn="Дата окончания проката" />
  276. </Mappings>
  277. <Sources />
  278. </TableAdapter>
  279. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOLTableAdapter" GeneratorDataComponentClassName="LOLTableAdapter" Name="LOL" UserDataComponentName="LOLTableAdapter">
  280. <MainSource>
  281. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.LOL" DbObjectType="StoredProcedure" 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">
  282. <SelectCommand>
  283. <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
  284. <CommandText>dbo.LOL</CommandText>
  285. <Parameters>
  286. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
  287. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
  288. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
  289. </Parameters>
  290. </DbCommand>
  291. </SelectCommand>
  292. </DbSource>
  293. </MainSource>
  294. <Mappings>
  295. <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
  296. <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
  297. <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
  298. <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
  299. </Mappings>
  300. <Sources />
  301. </TableAdapter>
  302. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOL123TableAdapter" GeneratorDataComponentClassName="LOL123TableAdapter" Name="LOL123" UserDataComponentName="LOL123TableAdapter">
  303. <MainSource>
  304. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.LOL123" DbObjectType="StoredProcedure" 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">
  305. <SelectCommand>
  306. <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
  307. <CommandText>dbo.LOL123</CommandText>
  308. <Parameters>
  309. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
  310. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@StartDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
  311. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@EndDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
  312. </Parameters>
  313. </DbCommand>
  314. </SelectCommand>
  315. </DbSource>
  316. </MainSource>
  317. <Mappings>
  318. <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
  319. <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
  320. <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
  321. <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
  322. </Mappings>
  323. <Sources />
  324. </TableAdapter>
  325. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOL1234TableAdapter" GeneratorDataComponentClassName="LOL1234TableAdapter" Name="LOL1234" UserDataComponentName="LOL1234TableAdapter">
  326. <MainSource>
  327. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.LOL1234" DbObjectType="StoredProcedure" 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">
  328. <SelectCommand>
  329. <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
  330. <CommandText>dbo.LOL1234</CommandText>
  331. <Parameters>
  332. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
  333. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@StartDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
  334. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@EndDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
  335. </Parameters>
  336. </DbCommand>
  337. </SelectCommand>
  338. </DbSource>
  339. </MainSource>
  340. <Mappings>
  341. <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
  342. <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
  343. <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
  344. <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
  345. </Mappings>
  346. <Sources />
  347. </TableAdapter>
  348. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOL12345TableAdapter" GeneratorDataComponentClassName="LOL12345TableAdapter" Name="LOL12345" UserDataComponentName="LOL12345TableAdapter">
  349. <MainSource>
  350. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.LOL12345" DbObjectType="StoredProcedure" 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">
  351. <SelectCommand>
  352. <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
  353. <CommandText>dbo.LOL12345</CommandText>
  354. <Parameters>
  355. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
  356. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@StartDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
  357. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@EndDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
  358. </Parameters>
  359. </DbCommand>
  360. </SelectCommand>
  361. </DbSource>
  362. </MainSource>
  363. <Mappings>
  364. <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
  365. <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
  366. <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
  367. <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
  368. </Mappings>
  369. <Sources />
  370. </TableAdapter>
  371. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOL123456TableAdapter" GeneratorDataComponentClassName="LOL123456TableAdapter" Name="LOL123456" UserDataComponentName="LOL123456TableAdapter">
  372. <MainSource>
  373. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.LOL123456" DbObjectType="StoredProcedure" 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">
  374. <SelectCommand>
  375. <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
  376. <CommandText>dbo.LOL123456</CommandText>
  377. <Parameters>
  378. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
  379. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@StartDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
  380. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@EndDate" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
  381. </Parameters>
  382. </DbCommand>
  383. </SelectCommand>
  384. </DbSource>
  385. </MainSource>
  386. <Mappings>
  387. <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
  388. <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
  389. <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
  390. </Mappings>
  391. <Sources />
  392. </TableAdapter>
  393. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PoiskTableAdapter" GeneratorDataComponentClassName="PoiskTableAdapter" Name="Poisk" UserDataComponentName="PoiskTableAdapter">
  394. <MainSource>
  395. <DbSource ConnectionRef="Prokatavto06ConnectionString (Settings)" DbObjectName="Prokatavto06.dbo.Poisk" DbObjectType="StoredProcedure" 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">
  396. <SelectCommand>
  397. <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
  398. <CommandText>dbo.Poisk</CommandText>
  399. <Parameters>
  400. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
  401. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Value1" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
  402. </Parameters>
  403. </DbCommand>
  404. </SelectCommand>
  405. </DbSource>
  406. </MainSource>
  407. <Mappings>
  408. <Mapping SourceColumn="Kod avto" DataSetColumn="Kod avto" />
  409. <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
  410. <Mapping SourceColumn="Cvet avto" DataSetColumn="Cvet avto" />
  411. <Mapping SourceColumn="God vipyska avto" DataSetColumn="God vipyska avto" />
  412. <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
  413. <Mapping SourceColumn="strahovaya stoimost avto" DataSetColumn="strahovaya stoimost avto" />
  414. <Mapping SourceColumn="Kod strahovki" DataSetColumn="Kod strahovki" />
  415. </Mappings>
  416. <Sources />
  417. </TableAdapter>
  418. </Tables>
  419. <Sources />
  420. </DataSource>
  421. </xs:appinfo>
  422. </xs:annotation>
  423. <xs:element name="Prokatavto06DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Prokatavto06DataSet" msprop:Generator_UserDSName="Prokatavto06DataSet">
  424. <xs:complexType>
  425. <xs:choice minOccurs="0" maxOccurs="unbounded">
  426. <xs:element name="Avto" msprop:Generator_TableClassName="AvtoDataTable" msprop:Generator_TableVarName="tableAvto" msprop:Generator_TablePropName="Avto" msprop:Generator_RowDeletingName="AvtoRowDeleting" msprop:Generator_RowChangingName="AvtoRowChanging" msprop:Generator_RowEvHandlerName="AvtoRowChangeEventHandler" msprop:Generator_RowDeletedName="AvtoRowDeleted" msprop:Generator_UserTableName="Avto" msprop:Generator_RowChangedName="AvtoRowChanged" msprop:Generator_RowEvArgName="AvtoRowChangeEvent" msprop:Generator_RowClassName="AvtoRow">
  427. <xs:complexType>
  428. <xs:sequence>
  429. <xs:element name="Kod_x0020_avto" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnKod_avto" msprop:Generator_ColumnPropNameInRow="Kod_avto" msprop:Generator_ColumnPropNameInTable="Kod_avtoColumn" msprop:Generator_UserColumnName="Kod avto" type="xs:int" />
  430. <xs:element name="Model_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnModel_avto" msprop:Generator_ColumnPropNameInRow="Model_avto" msprop:Generator_ColumnPropNameInTable="Model_avtoColumn" msprop:Generator_UserColumnName="Model avto">
  431. <xs:simpleType>
  432. <xs:restriction base="xs:string">
  433. <xs:maxLength value="50" />
  434. </xs:restriction>
  435. </xs:simpleType>
  436. </xs:element>
  437. <xs:element name="Cvet_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnCvet_avto" msprop:Generator_ColumnPropNameInRow="Cvet_avto" msprop:Generator_ColumnPropNameInTable="Cvet_avtoColumn" msprop:Generator_UserColumnName="Cvet avto">
  438. <xs:simpleType>
  439. <xs:restriction base="xs:string">
  440. <xs:maxLength value="50" />
  441. </xs:restriction>
  442. </xs:simpleType>
  443. </xs:element>
  444. <xs:element name="God_x0020_vipyska_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGod_vipyska_avto" msprop:Generator_ColumnPropNameInRow="God_vipyska_avto" msprop:Generator_ColumnPropNameInTable="God_vipyska_avtoColumn" msprop:Generator_UserColumnName="God vipyska avto">
  445. <xs:simpleType>
  446. <xs:restriction base="xs:string">
  447. <xs:maxLength value="50" />
  448. </xs:restriction>
  449. </xs:simpleType>
  450. </xs:element>
  451. <xs:element name="Gos_x0020_nomer_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGos_nomer_avto" msprop:Generator_ColumnPropNameInRow="Gos_nomer_avto" msprop:Generator_ColumnPropNameInTable="Gos_nomer_avtoColumn" msprop:Generator_UserColumnName="Gos nomer avto">
  452. <xs:simpleType>
  453. <xs:restriction base="xs:string">
  454. <xs:maxLength value="50" />
  455. </xs:restriction>
  456. </xs:simpleType>
  457. </xs:element>
  458. <xs:element name="strahovaya_x0020_stoimost_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnstrahovaya_stoimost_avto" msprop:Generator_ColumnPropNameInRow="strahovaya_stoimost_avto" msprop:Generator_ColumnPropNameInTable="strahovaya_stoimost_avtoColumn" msprop:Generator_UserColumnName="strahovaya stoimost avto" type="xs:decimal" />
  459. <xs:element name="Kod_x0020_strahovki" msprop:Generator_ColumnVarNameInTable="columnKod_strahovki" msprop:Generator_ColumnPropNameInRow="Kod_strahovki" msprop:Generator_ColumnPropNameInTable="Kod_strahovkiColumn" msprop:Generator_UserColumnName="Kod strahovki" type="xs:int" minOccurs="0" />
  460. </xs:sequence>
  461. </xs:complexType>
  462. </xs:element>
  463. <xs:element name="Klient" msprop:Generator_TableClassName="KlientDataTable" msprop:Generator_TableVarName="tableKlient" msprop:Generator_TablePropName="Klient" msprop:Generator_RowDeletingName="KlientRowDeleting" msprop:Generator_RowChangingName="KlientRowChanging" msprop:Generator_RowEvHandlerName="KlientRowChangeEventHandler" msprop:Generator_RowDeletedName="KlientRowDeleted" msprop:Generator_UserTableName="Klient" msprop:Generator_RowChangedName="KlientRowChanged" msprop:Generator_RowEvArgName="KlientRowChangeEvent" msprop:Generator_RowClassName="KlientRow">
  464. <xs:complexType>
  465. <xs:sequence>
  466. <xs:element name="Kod_x0020_klienta" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnKod_klienta" msprop:Generator_ColumnPropNameInRow="Kod_klienta" msprop:Generator_ColumnPropNameInTable="Kod_klientaColumn" msprop:Generator_UserColumnName="Kod klienta" type="xs:int" />
  467. <xs:element name="FIO_x0020_klienta" msprop:Generator_ColumnVarNameInTable="columnFIO_klienta" msprop:Generator_ColumnPropNameInRow="FIO_klienta" msprop:Generator_ColumnPropNameInTable="FIO_klientaColumn" msprop:Generator_UserColumnName="FIO klienta">
  468. <xs:simpleType>
  469. <xs:restriction base="xs:string">
  470. <xs:maxLength value="50" />
  471. </xs:restriction>
  472. </xs:simpleType>
  473. </xs:element>
  474. <xs:element name="Seria_x0020_pasporta" msprop:Generator_ColumnVarNameInTable="columnSeria_pasporta" msprop:Generator_ColumnPropNameInRow="Seria_pasporta" msprop:Generator_ColumnPropNameInTable="Seria_pasportaColumn" msprop:Generator_UserColumnName="Seria pasporta">
  475. <xs:simpleType>
  476. <xs:restriction base="xs:string">
  477. <xs:maxLength value="50" />
  478. </xs:restriction>
  479. </xs:simpleType>
  480. </xs:element>
  481. <xs:element name="Nomer_x0020_pasporta" msprop:Generator_ColumnVarNameInTable="columnNomer_pasporta" msprop:Generator_ColumnPropNameInRow="Nomer_pasporta" msprop:Generator_ColumnPropNameInTable="Nomer_pasportaColumn" msprop:Generator_UserColumnName="Nomer pasporta">
  482. <xs:simpleType>
  483. <xs:restriction base="xs:string">
  484. <xs:maxLength value="50" />
  485. </xs:restriction>
  486. </xs:simpleType>
  487. </xs:element>
  488. </xs:sequence>
  489. </xs:complexType>
  490. </xs:element>
  491. <xs:element name="Prokat" msprop:Generator_TableClassName="ProkatDataTable" msprop:Generator_TableVarName="tableProkat" msprop:Generator_TablePropName="Prokat" msprop:Generator_RowDeletingName="ProkatRowDeleting" msprop:Generator_RowChangingName="ProkatRowChanging" msprop:Generator_RowEvHandlerName="ProkatRowChangeEventHandler" msprop:Generator_RowDeletedName="ProkatRowDeleted" msprop:Generator_UserTableName="Prokat" msprop:Generator_RowChangedName="ProkatRowChanged" msprop:Generator_RowEvArgName="ProkatRowChangeEvent" msprop:Generator_RowClassName="ProkatRow">
  492. <xs:complexType>
  493. <xs:sequence>
  494. <xs:element name="Kod_x0020_prokata" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnKod_prokata" msprop:Generator_ColumnPropNameInRow="Kod_prokata" msprop:Generator_ColumnPropNameInTable="Kod_prokataColumn" msprop:Generator_UserColumnName="Kod prokata" type="xs:int" />
  495. <xs:element name="Stoimost_x0020_odnogo_x0020_dnya_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnStoimost_odnogo_dnya_prokata" msprop:Generator_ColumnPropNameInRow="Stoimost_odnogo_dnya_prokata" msprop:Generator_ColumnPropNameInTable="Stoimost_odnogo_dnya_prokataColumn" msprop:Generator_UserColumnName="Stoimost odnogo dnya prokata" type="xs:decimal" />
  496. <xs:element name="Data_x0020_nachala_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnData_nachala_prokata" msprop:Generator_ColumnPropNameInRow="Data_nachala_prokata" msprop:Generator_ColumnPropNameInTable="Data_nachala_prokataColumn" msprop:Generator_UserColumnName="Data nachala prokata" type="xs:dateTime" />
  497. <xs:element name="Kolichestvo_x0020_dnei_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnKolichestvo_dnei_prokata" msprop:Generator_ColumnPropNameInRow="Kolichestvo_dnei_prokata" msprop:Generator_ColumnPropNameInTable="Kolichestvo_dnei_prokataColumn" msprop:Generator_UserColumnName="Kolichestvo dnei prokata">
  498. <xs:simpleType>
  499. <xs:restriction base="xs:string">
  500. <xs:maxLength value="50" />
  501. </xs:restriction>
  502. </xs:simpleType>
  503. </xs:element>
  504. <xs:element name="Kod_x0020_klienta" msprop:Generator_ColumnVarNameInTable="columnKod_klienta" msprop:Generator_ColumnPropNameInRow="Kod_klienta" msprop:Generator_ColumnPropNameInTable="Kod_klientaColumn" msprop:Generator_UserColumnName="Kod klienta" type="xs:int" />
  505. <xs:element name="Kod_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnKod_avto" msprop:Generator_ColumnPropNameInRow="Kod_avto" msprop:Generator_ColumnPropNameInTable="Kod_avtoColumn" msprop:Generator_UserColumnName="Kod avto" type="xs:int" />
  506. </xs:sequence>
  507. </xs:complexType>
  508. </xs:element>
  509. <xs:element name="Strahovka" msprop:Generator_TableClassName="StrahovkaDataTable" msprop:Generator_TableVarName="tableStrahovka" msprop:Generator_TablePropName="Strahovka" msprop:Generator_RowDeletingName="StrahovkaRowDeleting" msprop:Generator_RowChangingName="StrahovkaRowChanging" msprop:Generator_RowEvHandlerName="StrahovkaRowChangeEventHandler" msprop:Generator_RowDeletedName="StrahovkaRowDeleted" msprop:Generator_UserTableName="Strahovka" msprop:Generator_RowChangedName="StrahovkaRowChanged" msprop:Generator_RowEvArgName="StrahovkaRowChangeEvent" msprop:Generator_RowClassName="StrahovkaRow">
  510. <xs:complexType>
  511. <xs:sequence>
  512. <xs:element name="Kod_x0020_strahovki" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnKod_strahovki" msprop:Generator_ColumnPropNameInRow="Kod_strahovki" msprop:Generator_ColumnPropNameInTable="Kod_strahovkiColumn" msprop:Generator_UserColumnName="Kod strahovki" type="xs:int" />
  513. <xs:element name="Strahovoi_x0020_vznos" msprop:Generator_ColumnVarNameInTable="columnStrahovoi_vznos" msprop:Generator_ColumnPropNameInRow="Strahovoi_vznos" msprop:Generator_ColumnPropNameInTable="Strahovoi_vznosColumn" msprop:Generator_UserColumnName="Strahovoi vznos" type="xs:decimal" />
  514. </xs:sequence>
  515. </xs:complexType>
  516. </xs:element>
  517. <xs:element name="ПредставлениеПрокат" msprop:Generator_TableClassName="ПредставлениеПрокатDataTable" msprop:Generator_TableVarName="tableПредставлениеПрокат" msprop:Generator_TablePropName="ПредставлениеПрокат" msprop:Generator_RowDeletingName="ПредставлениеПрокатRowDeleting" msprop:Generator_RowChangingName="ПредставлениеПрокатRowChanging" msprop:Generator_RowEvHandlerName="ПредставлениеПрокатRowChangeEventHandler" msprop:Generator_RowDeletedName="ПредставлениеПрокатRowDeleted" msprop:Generator_UserTableName="ПредставлениеПрокат" msprop:Generator_RowChangedName="ПредставлениеПрокатRowChanged" msprop:Generator_RowEvArgName="ПредставлениеПрокатRowChangeEvent" msprop:Generator_RowClassName="ПредставлениеПрокатRow">
  518. <xs:complexType>
  519. <xs:sequence>
  520. <xs:element name="Model_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnModel_avto" msprop:Generator_ColumnPropNameInRow="Model_avto" msprop:Generator_ColumnPropNameInTable="Model_avtoColumn" msprop:Generator_UserColumnName="Model avto">
  521. <xs:simpleType>
  522. <xs:restriction base="xs:string">
  523. <xs:maxLength value="50" />
  524. </xs:restriction>
  525. </xs:simpleType>
  526. </xs:element>
  527. <xs:element name="Gos_x0020_nomer_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGos_nomer_avto" msprop:Generator_ColumnPropNameInRow="Gos_nomer_avto" msprop:Generator_ColumnPropNameInTable="Gos_nomer_avtoColumn" msprop:Generator_UserColumnName="Gos nomer avto">
  528. <xs:simpleType>
  529. <xs:restriction base="xs:string">
  530. <xs:maxLength value="50" />
  531. </xs:restriction>
  532. </xs:simpleType>
  533. </xs:element>
  534. <xs:element name="FIO_x0020_klienta" msprop:Generator_ColumnVarNameInTable="columnFIO_klienta" msprop:Generator_ColumnPropNameInRow="FIO_klienta" msprop:Generator_ColumnPropNameInTable="FIO_klientaColumn" msprop:Generator_UserColumnName="FIO klienta">
  535. <xs:simpleType>
  536. <xs:restriction base="xs:string">
  537. <xs:maxLength value="50" />
  538. </xs:restriction>
  539. </xs:simpleType>
  540. </xs:element>
  541. <xs:element name="Seria_x0020_pasporta" msprop:Generator_ColumnVarNameInTable="columnSeria_pasporta" msprop:Generator_ColumnPropNameInRow="Seria_pasporta" msprop:Generator_ColumnPropNameInTable="Seria_pasportaColumn" msprop:Generator_UserColumnName="Seria pasporta">
  542. <xs:simpleType>
  543. <xs:restriction base="xs:string">
  544. <xs:maxLength value="50" />
  545. </xs:restriction>
  546. </xs:simpleType>
  547. </xs:element>
  548. <xs:element name="Nomer_x0020_pasporta" msprop:Generator_ColumnVarNameInTable="columnNomer_pasporta" msprop:Generator_ColumnPropNameInRow="Nomer_pasporta" msprop:Generator_ColumnPropNameInTable="Nomer_pasportaColumn" msprop:Generator_UserColumnName="Nomer pasporta">
  549. <xs:simpleType>
  550. <xs:restriction base="xs:string">
  551. <xs:maxLength value="50" />
  552. </xs:restriction>
  553. </xs:simpleType>
  554. </xs:element>
  555. <xs:element name="Stoimost_x0020_odnogo_x0020_dnya_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnStoimost_odnogo_dnya_prokata" msprop:Generator_ColumnPropNameInRow="Stoimost_odnogo_dnya_prokata" msprop:Generator_ColumnPropNameInTable="Stoimost_odnogo_dnya_prokataColumn" msprop:Generator_UserColumnName="Stoimost odnogo dnya prokata" type="xs:decimal" />
  556. <xs:element name="Data_x0020_nachala_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnData_nachala_prokata" msprop:Generator_ColumnPropNameInRow="Data_nachala_prokata" msprop:Generator_ColumnPropNameInTable="Data_nachala_prokataColumn" msprop:Generator_UserColumnName="Data nachala prokata" type="xs:dateTime" />
  557. <xs:element name="Kolichestvo_x0020_dnei_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnKolichestvo_dnei_prokata" msprop:Generator_ColumnPropNameInRow="Kolichestvo_dnei_prokata" msprop:Generator_ColumnPropNameInTable="Kolichestvo_dnei_prokataColumn" msprop:Generator_UserColumnName="Kolichestvo dnei prokata">
  558. <xs:simpleType>
  559. <xs:restriction base="xs:string">
  560. <xs:maxLength value="50" />
  561. </xs:restriction>
  562. </xs:simpleType>
  563. </xs:element>
  564. <xs:element name="Дата_x0020_окончания_x0020_проката" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnДата_окончания_проката" msprop:Generator_ColumnPropNameInRow="Дата_окончания_проката" msprop:Generator_ColumnPropNameInTable="Дата_окончания_прокатаColumn" msprop:Generator_UserColumnName="Дата окончания проката" minOccurs="0">
  565. <xs:simpleType>
  566. <xs:restriction base="xs:string">
  567. <xs:maxLength value="13" />
  568. </xs:restriction>
  569. </xs:simpleType>
  570. </xs:element>
  571. </xs:sequence>
  572. </xs:complexType>
  573. </xs:element>
  574. <xs:element name="LOL" msprop:Generator_TableClassName="LOLDataTable" msprop:Generator_TableVarName="tableLOL" msprop:Generator_TablePropName="LOL" msprop:Generator_RowDeletingName="LOLRowDeleting" msprop:Generator_RowChangingName="LOLRowChanging" msprop:Generator_RowEvHandlerName="LOLRowChangeEventHandler" msprop:Generator_RowDeletedName="LOLRowDeleted" msprop:Generator_UserTableName="LOL" msprop:Generator_RowChangedName="LOLRowChanged" msprop:Generator_RowEvArgName="LOLRowChangeEvent" msprop:Generator_RowClassName="LOLRow">
  575. <xs:complexType>
  576. <xs:sequence>
  577. <xs:element name="FIO_x0020_klienta" msprop:Generator_ColumnVarNameInTable="columnFIO_klienta" msprop:Generator_ColumnPropNameInRow="FIO_klienta" msprop:Generator_ColumnPropNameInTable="FIO_klientaColumn" msprop:Generator_UserColumnName="FIO klienta">
  578. <xs:simpleType>
  579. <xs:restriction base="xs:string">
  580. <xs:maxLength value="50" />
  581. </xs:restriction>
  582. </xs:simpleType>
  583. </xs:element>
  584. <xs:element name="Model_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnModel_avto" msprop:Generator_ColumnPropNameInRow="Model_avto" msprop:Generator_ColumnPropNameInTable="Model_avtoColumn" msprop:Generator_UserColumnName="Model avto">
  585. <xs:simpleType>
  586. <xs:restriction base="xs:string">
  587. <xs:maxLength value="50" />
  588. </xs:restriction>
  589. </xs:simpleType>
  590. </xs:element>
  591. <xs:element name="Gos_x0020_nomer_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGos_nomer_avto" msprop:Generator_ColumnPropNameInRow="Gos_nomer_avto" msprop:Generator_ColumnPropNameInTable="Gos_nomer_avtoColumn" msprop:Generator_UserColumnName="Gos nomer avto">
  592. <xs:simpleType>
  593. <xs:restriction base="xs:string">
  594. <xs:maxLength value="50" />
  595. </xs:restriction>
  596. </xs:simpleType>
  597. </xs:element>
  598. <xs:element name="Data_x0020_nachala_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnData_nachala_prokata" msprop:Generator_ColumnPropNameInRow="Data_nachala_prokata" msprop:Generator_ColumnPropNameInTable="Data_nachala_prokataColumn" msprop:Generator_UserColumnName="Data nachala prokata" type="xs:dateTime" />
  599. </xs:sequence>
  600. </xs:complexType>
  601. </xs:element>
  602. <xs:element name="LOL123" msprop:Generator_TableClassName="LOL123DataTable" msprop:Generator_TableVarName="tableLOL123" msprop:Generator_TablePropName="LOL123" msprop:Generator_RowDeletingName="LOL123RowDeleting" msprop:Generator_RowChangingName="LOL123RowChanging" msprop:Generator_RowEvHandlerName="LOL123RowChangeEventHandler" msprop:Generator_RowDeletedName="LOL123RowDeleted" msprop:Generator_UserTableName="LOL123" msprop:Generator_RowChangedName="LOL123RowChanged" msprop:Generator_RowEvArgName="LOL123RowChangeEvent" msprop:Generator_RowClassName="LOL123Row">
  603. <xs:complexType>
  604. <xs:sequence>
  605. <xs:element name="FIO_x0020_klienta" msprop:Generator_ColumnVarNameInTable="columnFIO_klienta" msprop:Generator_ColumnPropNameInRow="FIO_klienta" msprop:Generator_ColumnPropNameInTable="FIO_klientaColumn" msprop:Generator_UserColumnName="FIO klienta">
  606. <xs:simpleType>
  607. <xs:restriction base="xs:string">
  608. <xs:maxLength value="50" />
  609. </xs:restriction>
  610. </xs:simpleType>
  611. </xs:element>
  612. <xs:element name="Model_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnModel_avto" msprop:Generator_ColumnPropNameInRow="Model_avto" msprop:Generator_ColumnPropNameInTable="Model_avtoColumn" msprop:Generator_UserColumnName="Model avto">
  613. <xs:simpleType>
  614. <xs:restriction base="xs:string">
  615. <xs:maxLength value="50" />
  616. </xs:restriction>
  617. </xs:simpleType>
  618. </xs:element>
  619. <xs:element name="Gos_x0020_nomer_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGos_nomer_avto" msprop:Generator_ColumnPropNameInRow="Gos_nomer_avto" msprop:Generator_ColumnPropNameInTable="Gos_nomer_avtoColumn" msprop:Generator_UserColumnName="Gos nomer avto">
  620. <xs:simpleType>
  621. <xs:restriction base="xs:string">
  622. <xs:maxLength value="50" />
  623. </xs:restriction>
  624. </xs:simpleType>
  625. </xs:element>
  626. <xs:element name="Data_x0020_nachala_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnData_nachala_prokata" msprop:Generator_ColumnPropNameInRow="Data_nachala_prokata" msprop:Generator_ColumnPropNameInTable="Data_nachala_prokataColumn" msprop:Generator_UserColumnName="Data nachala prokata" type="xs:dateTime" />
  627. </xs:sequence>
  628. </xs:complexType>
  629. </xs:element>
  630. <xs:element name="LOL1234" msprop:Generator_TableClassName="LOL1234DataTable" msprop:Generator_TableVarName="tableLOL1234" msprop:Generator_TablePropName="LOL1234" msprop:Generator_RowDeletingName="LOL1234RowDeleting" msprop:Generator_RowChangingName="LOL1234RowChanging" msprop:Generator_RowEvHandlerName="LOL1234RowChangeEventHandler" msprop:Generator_RowDeletedName="LOL1234RowDeleted" msprop:Generator_UserTableName="LOL1234" msprop:Generator_RowChangedName="LOL1234RowChanged" msprop:Generator_RowEvArgName="LOL1234RowChangeEvent" msprop:Generator_RowClassName="LOL1234Row">
  631. <xs:complexType>
  632. <xs:sequence>
  633. <xs:element name="FIO_x0020_klienta" msprop:Generator_ColumnVarNameInTable="columnFIO_klienta" msprop:Generator_ColumnPropNameInRow="FIO_klienta" msprop:Generator_ColumnPropNameInTable="FIO_klientaColumn" msprop:Generator_UserColumnName="FIO klienta">
  634. <xs:simpleType>
  635. <xs:restriction base="xs:string">
  636. <xs:maxLength value="50" />
  637. </xs:restriction>
  638. </xs:simpleType>
  639. </xs:element>
  640. <xs:element name="Model_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnModel_avto" msprop:Generator_ColumnPropNameInRow="Model_avto" msprop:Generator_ColumnPropNameInTable="Model_avtoColumn" msprop:Generator_UserColumnName="Model avto">
  641. <xs:simpleType>
  642. <xs:restriction base="xs:string">
  643. <xs:maxLength value="50" />
  644. </xs:restriction>
  645. </xs:simpleType>
  646. </xs:element>
  647. <xs:element name="Gos_x0020_nomer_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGos_nomer_avto" msprop:Generator_ColumnPropNameInRow="Gos_nomer_avto" msprop:Generator_ColumnPropNameInTable="Gos_nomer_avtoColumn" msprop:Generator_UserColumnName="Gos nomer avto">
  648. <xs:simpleType>
  649. <xs:restriction base="xs:string">
  650. <xs:maxLength value="50" />
  651. </xs:restriction>
  652. </xs:simpleType>
  653. </xs:element>
  654. <xs:element name="Data_x0020_nachala_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnData_nachala_prokata" msprop:Generator_ColumnPropNameInRow="Data_nachala_prokata" msprop:Generator_ColumnPropNameInTable="Data_nachala_prokataColumn" msprop:Generator_UserColumnName="Data nachala prokata" type="xs:dateTime" />
  655. </xs:sequence>
  656. </xs:complexType>
  657. </xs:element>
  658. <xs:element name="LOL12345" msprop:Generator_TableClassName="LOL12345DataTable" msprop:Generator_TableVarName="tableLOL12345" msprop:Generator_TablePropName="LOL12345" msprop:Generator_RowDeletingName="LOL12345RowDeleting" msprop:Generator_RowChangingName="LOL12345RowChanging" msprop:Generator_RowEvHandlerName="LOL12345RowChangeEventHandler" msprop:Generator_RowDeletedName="LOL12345RowDeleted" msprop:Generator_UserTableName="LOL12345" msprop:Generator_RowChangedName="LOL12345RowChanged" msprop:Generator_RowEvArgName="LOL12345RowChangeEvent" msprop:Generator_RowClassName="LOL12345Row">
  659. <xs:complexType>
  660. <xs:sequence>
  661. <xs:element name="FIO_x0020_klienta" msprop:Generator_ColumnVarNameInTable="columnFIO_klienta" msprop:Generator_ColumnPropNameInRow="FIO_klienta" msprop:Generator_ColumnPropNameInTable="FIO_klientaColumn" msprop:Generator_UserColumnName="FIO klienta">
  662. <xs:simpleType>
  663. <xs:restriction base="xs:string">
  664. <xs:maxLength value="50" />
  665. </xs:restriction>
  666. </xs:simpleType>
  667. </xs:element>
  668. <xs:element name="Model_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnModel_avto" msprop:Generator_ColumnPropNameInRow="Model_avto" msprop:Generator_ColumnPropNameInTable="Model_avtoColumn" msprop:Generator_UserColumnName="Model avto">
  669. <xs:simpleType>
  670. <xs:restriction base="xs:string">
  671. <xs:maxLength value="50" />
  672. </xs:restriction>
  673. </xs:simpleType>
  674. </xs:element>
  675. <xs:element name="Gos_x0020_nomer_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGos_nomer_avto" msprop:Generator_ColumnPropNameInRow="Gos_nomer_avto" msprop:Generator_ColumnPropNameInTable="Gos_nomer_avtoColumn" msprop:Generator_UserColumnName="Gos nomer avto">
  676. <xs:simpleType>
  677. <xs:restriction base="xs:string">
  678. <xs:maxLength value="50" />
  679. </xs:restriction>
  680. </xs:simpleType>
  681. </xs:element>
  682. <xs:element name="Data_x0020_nachala_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnData_nachala_prokata" msprop:Generator_ColumnPropNameInRow="Data_nachala_prokata" msprop:Generator_ColumnPropNameInTable="Data_nachala_prokataColumn" msprop:Generator_UserColumnName="Data nachala prokata" type="xs:dateTime" />
  683. </xs:sequence>
  684. </xs:complexType>
  685. </xs:element>
  686. <xs:element name="LOL123456" msprop:Generator_TableClassName="LOL123456DataTable" msprop:Generator_TableVarName="tableLOL123456" msprop:Generator_TablePropName="LOL123456" msprop:Generator_RowDeletingName="LOL123456RowDeleting" msprop:Generator_RowChangingName="LOL123456RowChanging" msprop:Generator_RowEvHandlerName="LOL123456RowChangeEventHandler" msprop:Generator_RowDeletedName="LOL123456RowDeleted" msprop:Generator_UserTableName="LOL123456" msprop:Generator_RowChangedName="LOL123456RowChanged" msprop:Generator_RowEvArgName="LOL123456RowChangeEvent" msprop:Generator_RowClassName="LOL123456Row">
  687. <xs:complexType>
  688. <xs:sequence>
  689. <xs:element name="Model_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnModel_avto" msprop:Generator_ColumnPropNameInRow="Model_avto" msprop:Generator_ColumnPropNameInTable="Model_avtoColumn" msprop:Generator_UserColumnName="Model avto">
  690. <xs:simpleType>
  691. <xs:restriction base="xs:string">
  692. <xs:maxLength value="50" />
  693. </xs:restriction>
  694. </xs:simpleType>
  695. </xs:element>
  696. <xs:element name="Gos_x0020_nomer_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGos_nomer_avto" msprop:Generator_ColumnPropNameInRow="Gos_nomer_avto" msprop:Generator_ColumnPropNameInTable="Gos_nomer_avtoColumn" msprop:Generator_UserColumnName="Gos nomer avto">
  697. <xs:simpleType>
  698. <xs:restriction base="xs:string">
  699. <xs:maxLength value="50" />
  700. </xs:restriction>
  701. </xs:simpleType>
  702. </xs:element>
  703. <xs:element name="Data_x0020_nachala_x0020_prokata" msprop:Generator_ColumnVarNameInTable="columnData_nachala_prokata" msprop:Generator_ColumnPropNameInRow="Data_nachala_prokata" msprop:Generator_ColumnPropNameInTable="Data_nachala_prokataColumn" msprop:Generator_UserColumnName="Data nachala prokata" type="xs:dateTime" />
  704. </xs:sequence>
  705. </xs:complexType>
  706. </xs:element>
  707. <xs:element name="Poisk" msprop:Generator_TableClassName="PoiskDataTable" msprop:Generator_TableVarName="tablePoisk" msprop:Generator_TablePropName="Poisk" msprop:Generator_RowDeletingName="PoiskRowDeleting" msprop:Generator_RowChangingName="PoiskRowChanging" msprop:Generator_RowEvHandlerName="PoiskRowChangeEventHandler" msprop:Generator_RowDeletedName="PoiskRowDeleted" msprop:Generator_UserTableName="Poisk" msprop:Generator_RowChangedName="PoiskRowChanged" msprop:Generator_RowEvArgName="PoiskRowChangeEvent" msprop:Generator_RowClassName="PoiskRow">
  708. <xs:complexType>
  709. <xs:sequence>
  710. <xs:element name="Kod_x0020_avto" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnKod_avto" msprop:Generator_ColumnPropNameInRow="Kod_avto" msprop:Generator_ColumnPropNameInTable="Kod_avtoColumn" msprop:Generator_UserColumnName="Kod avto" type="xs:int" />
  711. <xs:element name="Model_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnModel_avto" msprop:Generator_ColumnPropNameInRow="Model_avto" msprop:Generator_ColumnPropNameInTable="Model_avtoColumn" msprop:Generator_UserColumnName="Model avto">
  712. <xs:simpleType>
  713. <xs:restriction base="xs:string">
  714. <xs:maxLength value="50" />
  715. </xs:restriction>
  716. </xs:simpleType>
  717. </xs:element>
  718. <xs:element name="Cvet_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnCvet_avto" msprop:Generator_ColumnPropNameInRow="Cvet_avto" msprop:Generator_ColumnPropNameInTable="Cvet_avtoColumn" msprop:Generator_UserColumnName="Cvet avto">
  719. <xs:simpleType>
  720. <xs:restriction base="xs:string">
  721. <xs:maxLength value="50" />
  722. </xs:restriction>
  723. </xs:simpleType>
  724. </xs:element>
  725. <xs:element name="God_x0020_vipyska_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGod_vipyska_avto" msprop:Generator_ColumnPropNameInRow="God_vipyska_avto" msprop:Generator_ColumnPropNameInTable="God_vipyska_avtoColumn" msprop:Generator_UserColumnName="God vipyska avto">
  726. <xs:simpleType>
  727. <xs:restriction base="xs:string">
  728. <xs:maxLength value="50" />
  729. </xs:restriction>
  730. </xs:simpleType>
  731. </xs:element>
  732. <xs:element name="Gos_x0020_nomer_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnGos_nomer_avto" msprop:Generator_ColumnPropNameInRow="Gos_nomer_avto" msprop:Generator_ColumnPropNameInTable="Gos_nomer_avtoColumn" msprop:Generator_UserColumnName="Gos nomer avto">
  733. <xs:simpleType>
  734. <xs:restriction base="xs:string">
  735. <xs:maxLength value="50" />
  736. </xs:restriction>
  737. </xs:simpleType>
  738. </xs:element>
  739. <xs:element name="strahovaya_x0020_stoimost_x0020_avto" msprop:Generator_ColumnVarNameInTable="columnstrahovaya_stoimost_avto" msprop:Generator_ColumnPropNameInRow="strahovaya_stoimost_avto" msprop:Generator_ColumnPropNameInTable="strahovaya_stoimost_avtoColumn" msprop:Generator_UserColumnName="strahovaya stoimost avto" type="xs:decimal" />
  740. <xs:element name="Kod_x0020_strahovki" msprop:Generator_ColumnVarNameInTable="columnKod_strahovki" msprop:Generator_ColumnPropNameInRow="Kod_strahovki" msprop:Generator_ColumnPropNameInTable="Kod_strahovkiColumn" msprop:Generator_UserColumnName="Kod strahovki" type="xs:int" minOccurs="0" />
  741. </xs:sequence>
  742. </xs:complexType>
  743. </xs:element>
  744. </xs:choice>
  745. </xs:complexType>
  746. <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  747. <xs:selector xpath=".//mstns:Avto" />
  748. <xs:field xpath="mstns:Kod_x0020_avto" />
  749. </xs:unique>
  750. <xs:unique name="Klient_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  751. <xs:selector xpath=".//mstns:Klient" />
  752. <xs:field xpath="mstns:Kod_x0020_klienta" />
  753. </xs:unique>
  754. <xs:unique name="Prokat_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  755. <xs:selector xpath=".//mstns:Prokat" />
  756. <xs:field xpath="mstns:Kod_x0020_prokata" />
  757. </xs:unique>
  758. <xs:unique name="Strahovka_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  759. <xs:selector xpath=".//mstns:Strahovka" />
  760. <xs:field xpath="mstns:Kod_x0020_strahovki" />
  761. </xs:unique>
  762. <xs:unique name="Poisk_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  763. <xs:selector xpath=".//mstns:Poisk" />
  764. <xs:field xpath="mstns:Kod_x0020_avto" />
  765. </xs:unique>
  766. </xs:element>
  767. <xs:annotation>
  768. <xs:appinfo>
  769. <msdata:Relationship name="FK_Avto_Strahovka" msdata:parent="Strahovka" msdata:child="Avto" msdata:parentkey="Kod_x0020_strahovki" msdata:childkey="Kod_x0020_strahovki" msprop:Generator_UserChildTable="Avto" msprop:Generator_ChildPropName="GetAvtoRows" msprop:Generator_UserRelationName="FK_Avto_Strahovka" msprop:Generator_RelationVarName="relationFK_Avto_Strahovka" msprop:Generator_UserParentTable="Strahovka" msprop:Generator_ParentPropName="StrahovkaRow" />
  770. <msdata:Relationship name="FK_Prokat_Avto" msdata:parent="Avto" msdata:child="Prokat" msdata:parentkey="Kod_x0020_avto" msdata:childkey="Kod_x0020_avto" msprop:Generator_UserChildTable="Prokat" msprop:Generator_ChildPropName="GetProkatRows" msprop:Generator_UserRelationName="FK_Prokat_Avto" msprop:Generator_ParentPropName="AvtoRow" msprop:Generator_RelationVarName="relationFK_Prokat_Avto" msprop:Generator_UserParentTable="Avto" />
  771. <msdata:Relationship name="FK_Prokat_Klient" msdata:parent="Klient" msdata:child="Prokat" msdata:parentkey="Kod_x0020_klienta" msdata:childkey="Kod_x0020_klienta" msprop:Generator_UserChildTable="Prokat" msprop:Generator_ChildPropName="GetProkatRows" msprop:Generator_UserRelationName="FK_Prokat_Klient" msprop:Generator_ParentPropName="KlientRow" msprop:Generator_RelationVarName="relationFK_Prokat_Klient" msprop:Generator_UserParentTable="Klient" />
  772. </xs:appinfo>
  773. </xs:annotation>
  774. </xs:schema>