123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774 |
- <?xml version="1.0" encoding="utf-8"?>
- <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">
- <xs:annotation>
- <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
- <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
- <Connections>
- <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" />
- </Connections>
- <Tables>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AvtoTableAdapter" GeneratorDataComponentClassName="AvtoTableAdapter" Name="Avto" UserDataComponentName="AvtoTableAdapter">
- <MainSource>
- <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">
- <DeleteCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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);
- 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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT [Kod avto], [Model avto], [Cvet avto], [God vipyska avto], [Gos nomer avto], [strahovaya stoimost avto], [Kod strahovki] FROM dbo.Avto</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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)));
- 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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="Kod avto" DataSetColumn="Kod avto" />
- <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
- <Mapping SourceColumn="Cvet avto" DataSetColumn="Cvet avto" />
- <Mapping SourceColumn="God vipyska avto" DataSetColumn="God vipyska avto" />
- <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
- <Mapping SourceColumn="strahovaya stoimost avto" DataSetColumn="strahovaya stoimost avto" />
- <Mapping SourceColumn="Kod strahovki" DataSetColumn="Kod strahovki" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="KlientTableAdapter" GeneratorDataComponentClassName="KlientTableAdapter" Name="Klient" UserDataComponentName="KlientTableAdapter">
- <MainSource>
- <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">
- <DeleteCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[Klient] ([FIO klienta], [Seria pasporta], [Nomer pasporta]) VALUES (@FIO_klienta, @Seria_pasporta, @Nomer_pasporta);
- SELECT [Kod klienta], [FIO klienta], [Seria pasporta], [Nomer pasporta] FROM Klient WHERE ([Kod klienta] = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT [Kod klienta], [FIO klienta], [Seria pasporta], [Nomer pasporta] FROM dbo.Klient</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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));
- SELECT [Kod klienta], [FIO klienta], [Seria pasporta], [Nomer pasporta] FROM Klient WHERE ([Kod klienta] = @Kod_klienta)</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="Kod klienta" DataSetColumn="Kod klienta" />
- <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
- <Mapping SourceColumn="Seria pasporta" DataSetColumn="Seria pasporta" />
- <Mapping SourceColumn="Nomer pasporta" DataSetColumn="Nomer pasporta" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProkatTableAdapter" GeneratorDataComponentClassName="ProkatTableAdapter" Name="Prokat" UserDataComponentName="ProkatTableAdapter">
- <MainSource>
- <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">
- <DeleteCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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);
- 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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT [Kod prokata], [Stoimost odnogo dnya prokata], [Data nachala prokata], [Kolichestvo dnei prokata], [Kod klienta], [Kod avto] FROM dbo.Prokat</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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));
- 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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="Kod prokata" DataSetColumn="Kod prokata" />
- <Mapping SourceColumn="Stoimost odnogo dnya prokata" DataSetColumn="Stoimost odnogo dnya prokata" />
- <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
- <Mapping SourceColumn="Kolichestvo dnei prokata" DataSetColumn="Kolichestvo dnei prokata" />
- <Mapping SourceColumn="Kod klienta" DataSetColumn="Kod klienta" />
- <Mapping SourceColumn="Kod avto" DataSetColumn="Kod avto" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StrahovkaTableAdapter" GeneratorDataComponentClassName="StrahovkaTableAdapter" Name="Strahovka" UserDataComponentName="StrahovkaTableAdapter">
- <MainSource>
- <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">
- <DeleteCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>DELETE FROM [dbo].[Strahovka] WHERE (([Kod strahovki] = @Original_Kod_strahovki) AND ([Strahovoi vznos] = @Original_Strahovoi_vznos))</CommandText>
- <Parameters>
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[Strahovka] ([Strahovoi vznos]) VALUES (@Strahovoi_vznos);
- SELECT [Kod strahovki], [Strahovoi vznos] FROM Strahovka WHERE ([Kod strahovki] = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <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" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT [Kod strahovki], [Strahovoi vznos] FROM dbo.Strahovka</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[Strahovka] SET [Strahovoi vznos] = @Strahovoi_vznos WHERE (([Kod strahovki] = @Original_Kod_strahovki) AND ([Strahovoi vznos] = @Original_Strahovoi_vznos));
- SELECT [Kod strahovki], [Strahovoi vznos] FROM Strahovka WHERE ([Kod strahovki] = @Kod_strahovki)</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="Kod strahovki" DataSetColumn="Kod strahovki" />
- <Mapping SourceColumn="Strahovoi vznos" DataSetColumn="Strahovoi vznos" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ПредставлениеПрокатTableAdapter" GeneratorDataComponentClassName="ПредставлениеПрокатTableAdapter" Name="ПредставлениеПрокат" UserDataComponentName="ПредставлениеПрокатTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
- <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
- <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
- <Mapping SourceColumn="Seria pasporta" DataSetColumn="Seria pasporta" />
- <Mapping SourceColumn="Nomer pasporta" DataSetColumn="Nomer pasporta" />
- <Mapping SourceColumn="Stoimost odnogo dnya prokata" DataSetColumn="Stoimost odnogo dnya prokata" />
- <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
- <Mapping SourceColumn="Kolichestvo dnei prokata" DataSetColumn="Kolichestvo dnei prokata" />
- <Mapping SourceColumn="Дата окончания проката" DataSetColumn="Дата окончания проката" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOLTableAdapter" GeneratorDataComponentClassName="LOLTableAdapter" Name="LOL" UserDataComponentName="LOLTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
- <CommandText>dbo.LOL</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
- <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
- <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
- <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOL123TableAdapter" GeneratorDataComponentClassName="LOL123TableAdapter" Name="LOL123" UserDataComponentName="LOL123TableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
- <CommandText>dbo.LOL123</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
- <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
- <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
- <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOL1234TableAdapter" GeneratorDataComponentClassName="LOL1234TableAdapter" Name="LOL1234" UserDataComponentName="LOL1234TableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
- <CommandText>dbo.LOL1234</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
- <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
- <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
- <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOL12345TableAdapter" GeneratorDataComponentClassName="LOL12345TableAdapter" Name="LOL12345" UserDataComponentName="LOL12345TableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
- <CommandText>dbo.LOL12345</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO klienta" DataSetColumn="FIO klienta" />
- <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
- <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
- <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LOL123456TableAdapter" GeneratorDataComponentClassName="LOL123456TableAdapter" Name="LOL123456" UserDataComponentName="LOL123456TableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
- <CommandText>dbo.LOL123456</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
- <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
- <Mapping SourceColumn="Data nachala prokata" DataSetColumn="Data nachala prokata" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PoiskTableAdapter" GeneratorDataComponentClassName="PoiskTableAdapter" Name="Poisk" UserDataComponentName="PoiskTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
- <CommandText>dbo.Poisk</CommandText>
- <Parameters>
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="Kod avto" DataSetColumn="Kod avto" />
- <Mapping SourceColumn="Model avto" DataSetColumn="Model avto" />
- <Mapping SourceColumn="Cvet avto" DataSetColumn="Cvet avto" />
- <Mapping SourceColumn="God vipyska avto" DataSetColumn="God vipyska avto" />
- <Mapping SourceColumn="Gos nomer avto" DataSetColumn="Gos nomer avto" />
- <Mapping SourceColumn="strahovaya stoimost avto" DataSetColumn="strahovaya stoimost avto" />
- <Mapping SourceColumn="Kod strahovki" DataSetColumn="Kod strahovki" />
- </Mappings>
- <Sources />
- </TableAdapter>
- </Tables>
- <Sources />
- </DataSource>
- </xs:appinfo>
- </xs:annotation>
- <xs:element name="Prokatavto06DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Prokatavto06DataSet" msprop:Generator_UserDSName="Prokatavto06DataSet">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <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">
- <xs:complexType>
- <xs:sequence>
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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" />
- <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" />
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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" />
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Дата_x0020_окончания_x0020_проката" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnДата_окончания_проката" msprop:Generator_ColumnPropNameInRow="Дата_окончания_проката" msprop:Generator_ColumnPropNameInTable="Дата_окончания_прокатаColumn" msprop:Generator_UserColumnName="Дата окончания проката" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="13" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:complexType>
- <xs:unique name="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Avto" />
- <xs:field xpath="mstns:Kod_x0020_avto" />
- </xs:unique>
- <xs:unique name="Klient_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Klient" />
- <xs:field xpath="mstns:Kod_x0020_klienta" />
- </xs:unique>
- <xs:unique name="Prokat_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Prokat" />
- <xs:field xpath="mstns:Kod_x0020_prokata" />
- </xs:unique>
- <xs:unique name="Strahovka_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Strahovka" />
- <xs:field xpath="mstns:Kod_x0020_strahovki" />
- </xs:unique>
- <xs:unique name="Poisk_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Poisk" />
- <xs:field xpath="mstns:Kod_x0020_avto" />
- </xs:unique>
- </xs:element>
- <xs:annotation>
- <xs:appinfo>
- <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" />
- <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" />
- <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" />
- </xs:appinfo>
- </xs:annotation>
- </xs:schema>
|