Sereshka/Lyakhov_Bilet10DataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Lyakhov_Bilet10DataSet" targetNamespace="http://tempuri.org/Lyakhov_Bilet10DataSet.xsd" xmlns:mstns="http://tempuri.org/Lyakhov_Bilet10DataSet.xsd" xmlns="http://tempuri.org/Lyakhov_Bilet10DataSet.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="Lyakhov_Bilet10ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Lyakhov_Bilet10ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Lyakhov_Bilet10.Properties.Settings.GlobalReference.Default.Lyakhov_Bilet10ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ЗаказTableAdapter" GeneratorDataComponentClassName="ЗаказTableAdapter" Name="Заказ" UserDataComponentName="ЗаказTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Lyakhov_Bilet10ConnectionString (Settings)" DbObjectName="Lyakhov_Bilet10.dbo.Заказ" 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].[Заказ] WHERE (([ID_Zakaza] = @Original_ID_Zakaza) AND ([Kolichestvo] = @Original_Kolichestvo) AND ([ID_Tovara] = @Original_ID_Tovara) AND ([ID_Klienta] = @Original_ID_Klienta))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Zakaza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakaza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kolichestvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kolichestvo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Заказ] ([Kolichestvo], [ID_Tovara], [ID_Klienta]) VALUES (@Kolichestvo, @ID_Tovara, @ID_Klienta);
SELECT ID_Zakaza, Kolichestvo, ID_Tovara, ID_Klienta FROM Заказ WHERE (ID_Zakaza = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Kolichestvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kolichestvo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Zakaza, Kolichestvo, ID_Tovara, ID_Klienta FROM dbo.Заказ</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Заказ] SET [Kolichestvo] = @Kolichestvo, [ID_Tovara] = @ID_Tovara, [ID_Klienta] = @ID_Klienta WHERE (([ID_Zakaza] = @Original_ID_Zakaza) AND ([Kolichestvo] = @Original_Kolichestvo) AND ([ID_Tovara] = @Original_ID_Tovara) AND ([ID_Klienta] = @Original_ID_Klienta));
SELECT ID_Zakaza, Kolichestvo, ID_Tovara, ID_Klienta FROM Заказ WHERE (ID_Zakaza = @ID_Zakaza)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Kolichestvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kolichestvo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Zakaza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakaza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kolichestvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kolichestvo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Zakaza" ColumnName="ID_Zakaza" DataSourceName="Lyakhov_Bilet10.dbo.Заказ" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Zakaza" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Zakaza" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Zakaza" DataSetColumn="ID_Zakaza" />
              <Mapping SourceColumn="Kolichestvo" DataSetColumn="Kolichestvo" />
              <Mapping SourceColumn="ID_Tovara" DataSetColumn="ID_Tovara" />
              <Mapping SourceColumn="ID_Klienta" DataSetColumn="ID_Klienta" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="История продажиTableAdapter" GeneratorDataComponentClassName="История_продажиTableAdapter" Name="История продажи" UserDataComponentName="История продажиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Lyakhov_Bilet10ConnectionString (Settings)" DbObjectName="Lyakhov_Bilet10.dbo.[История продажи]" 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].[История продажи] WHERE (([ID_Istorii] = @Original_ID_Istorii) AND ([Nazvanie] = @Original_Nazvanie) AND ([Data_Prodaji] = @Original_Data_Prodaji) AND ([ID_Tovara] = @Original_ID_Tovara))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Istorii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Istorii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_Prodaji" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_Prodaji" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[История продажи] ([Nazvanie], [Data_Prodaji], [ID_Tovara]) VALUES (@Nazvanie, @Data_Prodaji, @ID_Tovara);
SELECT ID_Istorii, Nazvanie, Data_Prodaji, ID_Tovara FROM [История продажи] WHERE (ID_Istorii = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_Prodaji" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_Prodaji" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Istorii, Nazvanie, Data_Prodaji, ID_Tovara FROM dbo.[История продажи]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[История продажи] SET [Nazvanie] = @Nazvanie, [Data_Prodaji] = @Data_Prodaji, [ID_Tovara] = @ID_Tovara WHERE (([ID_Istorii] = @Original_ID_Istorii) AND ([Nazvanie] = @Original_Nazvanie) AND ([Data_Prodaji] = @Original_Data_Prodaji) AND ([ID_Tovara] = @Original_ID_Tovara));
SELECT ID_Istorii, Nazvanie, Data_Prodaji, ID_Tovara FROM [История продажи] WHERE (ID_Istorii = @ID_Istorii)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_Prodaji" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_Prodaji" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Istorii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Istorii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_Prodaji" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_Prodaji" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Istorii" ColumnName="ID_Istorii" DataSourceName="Lyakhov_Bilet10.dbo.[История продажи]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Istorii" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Istorii" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Istorii" DataSetColumn="ID_Istorii" />
              <Mapping SourceColumn="Nazvanie" DataSetColumn="Nazvanie" />
              <Mapping SourceColumn="Data_Prodaji" DataSetColumn="Data_Prodaji" />
              <Mapping SourceColumn="ID_Tovara" DataSetColumn="ID_Tovara" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="КлиентыTableAdapter" GeneratorDataComponentClassName="КлиентыTableAdapter" Name="Клиенты" UserDataComponentName="КлиентыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Lyakhov_Bilet10ConnectionString (Settings)" DbObjectName="Lyakhov_Bilet10.dbo.Клиенты" 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].[Клиенты] WHERE (([ID_Klienta] = @Original_ID_Klienta) AND ([FIO] = @Original_FIO) AND ([Telepfone] = @Original_Telepfone) AND ((@IsNull_ID_Zakaza = 1 AND [ID_Zakaza] IS NULL) OR ([ID_Zakaza] = @Original_ID_Zakaza)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FIO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Telepfone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telepfone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Zakaza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakaza" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Zakaza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakaza" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Клиенты] ([FIO], [Telepfone], [ID_Zakaza]) VALUES (@FIO, @Telepfone, @ID_Zakaza);
SELECT ID_Klienta, FIO, Telepfone, ID_Zakaza FROM Клиенты WHERE (ID_Klienta = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FIO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Telepfone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telepfone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Zakaza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakaza" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Klienta, FIO, Telepfone, ID_Zakaza FROM dbo.Клиенты</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Клиенты] SET [FIO] = @FIO, [Telepfone] = @Telepfone, [ID_Zakaza] = @ID_Zakaza WHERE (([ID_Klienta] = @Original_ID_Klienta) AND ([FIO] = @Original_FIO) AND ([Telepfone] = @Original_Telepfone) AND ((@IsNull_ID_Zakaza = 1 AND [ID_Zakaza] IS NULL) OR ([ID_Zakaza] = @Original_ID_Zakaza)));
SELECT ID_Klienta, FIO, Telepfone, ID_Zakaza FROM Клиенты WHERE (ID_Klienta = @ID_Klienta)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FIO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Telepfone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telepfone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Zakaza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakaza" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FIO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Telepfone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telepfone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Zakaza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakaza" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Zakaza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakaza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Klienta" ColumnName="ID_Klienta" DataSourceName="Lyakhov_Bilet10.dbo.Клиенты" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Klienta" DataSetColumn="ID_Klienta" />
              <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
              <Mapping SourceColumn="Telepfone" DataSetColumn="Telepfone" />
              <Mapping SourceColumn="ID_Zakaza" DataSetColumn="ID_Zakaza" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ТоварыTableAdapter" GeneratorDataComponentClassName="ТоварыTableAdapter" Name="Товары" UserDataComponentName="ТоварыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Lyakhov_Bilet10ConnectionString (Settings)" DbObjectName="Lyakhov_Bilet10.dbo.Товары" 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].[Товары] WHERE (([ID_Tovara] = @Original_ID_Tovara) AND ([Nazvanie] = @Original_Nazvanie) AND ([Cena] = @Original_Cena) AND ([ID_Klienta] = @Original_ID_Klienta))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Cena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Cena" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Товары] ([Nazvanie], [Cena], [ID_Klienta]) VALUES (@Nazvanie, @Cena, @ID_Klienta);
SELECT ID_Tovara, Nazvanie, Cena, ID_Klienta FROM Товары WHERE (ID_Tovara = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Cena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Cena" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Tovara, Nazvanie, Cena, ID_Klienta FROM dbo.Товары</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Товары] SET [Nazvanie] = @Nazvanie, [Cena] = @Cena, [ID_Klienta] = @ID_Klienta WHERE (([ID_Tovara] = @Original_ID_Tovara) AND ([Nazvanie] = @Original_Nazvanie) AND ([Cena] = @Original_Cena) AND ([ID_Klienta] = @Original_ID_Klienta));
SELECT ID_Tovara, Nazvanie, Cena, ID_Klienta FROM Товары WHERE (ID_Tovara = @ID_Tovara)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Cena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Cena" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Cena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Cena" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Klienta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Klienta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Tovara" ColumnName="ID_Tovara" DataSourceName="Lyakhov_Bilet10.dbo.Товары" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Tovara" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Tovara" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Tovara" DataSetColumn="ID_Tovara" />
              <Mapping SourceColumn="Nazvanie" DataSetColumn="Nazvanie" />
              <Mapping SourceColumn="Cena" DataSetColumn="Cena" />
              <Mapping SourceColumn="ID_Klienta" DataSetColumn="ID_Klienta" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Lyakhov_Bilet10ConnectionString (Settings)" DbObjectName="Lyakhov_Bilet10.dbo.Товары" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Tovara, Nazvanie, Cena, ID_Klienta FROM dbo.Товары</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="View_1TableAdapter" GeneratorDataComponentClassName="View_1TableAdapter" Name="View_1" UserDataComponentName="View_1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Lyakhov_Bilet10ConnectionString (Settings)" DbObjectName="Lyakhov_Bilet10.dbo.View_1" 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 Дата, Название FROM dbo.View_1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Дата" DataSetColumn="Дата" />
              <Mapping SourceColumn="Название" DataSetColumn="Название" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Lyakhov_Bilet10DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Lyakhov_Bilet10DataSet" msprop:Generator_UserDSName="Lyakhov_Bilet10DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <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="ID_Zakaza" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Zakaza" msprop:Generator_ColumnPropNameInRow="ID_Zakaza" msprop:Generator_ColumnPropNameInTable="ID_ZakazaColumn" msprop:Generator_UserColumnName="ID_Zakaza" type="xs:int" />
              <xs:element name="Kolichestvo" msprop:Generator_ColumnVarNameInTable="columnKolichestvo" msprop:Generator_ColumnPropNameInRow="Kolichestvo" msprop:Generator_ColumnPropNameInTable="KolichestvoColumn" msprop:Generator_UserColumnName="Kolichestvo" type="xs:int" />
              <xs:element name="ID_Tovara" msprop:Generator_ColumnVarNameInTable="columnID_Tovara" msprop:Generator_ColumnPropNameInRow="ID_Tovara" msprop:Generator_ColumnPropNameInTable="ID_TovaraColumn" msprop:Generator_UserColumnName="ID_Tovara" type="xs:int" />
              <xs:element name="ID_Klienta" msprop:Generator_ColumnVarNameInTable="columnID_Klienta" msprop:Generator_ColumnPropNameInRow="ID_Klienta" msprop:Generator_ColumnPropNameInTable="ID_KlientaColumn" msprop:Generator_UserColumnName="ID_Klienta" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="История_x0020_продажи" 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="ID_Istorii" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Istorii" msprop:Generator_ColumnPropNameInRow="ID_Istorii" msprop:Generator_ColumnPropNameInTable="ID_IstoriiColumn" msprop:Generator_UserColumnName="ID_Istorii" type="xs:int" />
              <xs:element name="Nazvanie" msprop:Generator_ColumnVarNameInTable="columnNazvanie" msprop:Generator_ColumnPropNameInRow="Nazvanie" msprop:Generator_ColumnPropNameInTable="NazvanieColumn" msprop:Generator_UserColumnName="Nazvanie">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Data_Prodaji" msprop:Generator_ColumnVarNameInTable="columnData_Prodaji" msprop:Generator_ColumnPropNameInRow="Data_Prodaji" msprop:Generator_ColumnPropNameInTable="Data_ProdajiColumn" msprop:Generator_UserColumnName="Data_Prodaji" type="xs:dateTime" />
              <xs:element name="ID_Tovara" msprop:Generator_ColumnVarNameInTable="columnID_Tovara" msprop:Generator_ColumnPropNameInRow="ID_Tovara" msprop:Generator_ColumnPropNameInTable="ID_TovaraColumn" msprop:Generator_UserColumnName="ID_Tovara" type="xs:int" />
            </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="ID_Klienta" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Klienta" msprop:Generator_ColumnPropNameInRow="ID_Klienta" msprop:Generator_ColumnPropNameInTable="ID_KlientaColumn" msprop:Generator_UserColumnName="ID_Klienta" type="xs:int" />
              <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telepfone" msprop:Generator_ColumnVarNameInTable="columnTelepfone" msprop:Generator_ColumnPropNameInRow="Telepfone" msprop:Generator_ColumnPropNameInTable="TelepfoneColumn" msprop:Generator_UserColumnName="Telepfone">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_Zakaza" msprop:Generator_ColumnVarNameInTable="columnID_Zakaza" msprop:Generator_ColumnPropNameInRow="ID_Zakaza" msprop:Generator_ColumnPropNameInTable="ID_ZakazaColumn" msprop:Generator_UserColumnName="ID_Zakaza" type="xs:int" minOccurs="0" />
            </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="ID_Tovara" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_Tovara" msprop:Generator_ColumnPropNameInRow="ID_Tovara" msprop:Generator_ColumnPropNameInTable="ID_TovaraColumn" msprop:Generator_UserColumnName="ID_Tovara" type="xs:int" />
              <xs:element name="Nazvanie" msprop:Generator_ColumnVarNameInTable="columnNazvanie" msprop:Generator_ColumnPropNameInRow="Nazvanie" msprop:Generator_ColumnPropNameInTable="NazvanieColumn" msprop:Generator_UserColumnName="Nazvanie">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cena" msprop:Generator_ColumnVarNameInTable="columnCena" msprop:Generator_ColumnPropNameInRow="Cena" msprop:Generator_ColumnPropNameInTable="CenaColumn" msprop:Generator_UserColumnName="Cena" type="xs:decimal" />
              <xs:element name="ID_Klienta" msprop:Generator_ColumnVarNameInTable="columnID_Klienta" msprop:Generator_ColumnPropNameInRow="ID_Klienta" msprop:Generator_ColumnPropNameInTable="ID_KlientaColumn" msprop:Generator_UserColumnName="ID_Klienta" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="View_1" msprop:Generator_TableClassName="View_1DataTable" msprop:Generator_TableVarName="tableView_1" msprop:Generator_TablePropName="View_1" msprop:Generator_RowDeletingName="View_1RowDeleting" msprop:Generator_RowChangingName="View_1RowChanging" msprop:Generator_RowEvHandlerName="View_1RowChangeEventHandler" msprop:Generator_RowDeletedName="View_1RowDeleted" msprop:Generator_UserTableName="View_1" msprop:Generator_RowChangedName="View_1RowChanged" msprop:Generator_RowEvArgName="View_1RowChangeEvent" msprop:Generator_RowClassName="View_1Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Дата" msprop:Generator_ColumnVarNameInTable="columnДата" msprop:Generator_ColumnPropNameInRow="Дата" msprop:Generator_ColumnPropNameInTable="ДатаColumn" msprop:Generator_UserColumnName="Дата" type="xs:dateTime" />
              <xs:element name="Название" msprop:Generator_ColumnVarNameInTable="columnНазвание" msprop:Generator_ColumnPropNameInRow="Название" msprop:Generator_ColumnPropNameInTable="НазваниеColumn" msprop:Generator_UserColumnName="Название">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Заказ" />
      <xs:field xpath="mstns:ID_Zakaza" />
    </xs:unique>
    <xs:unique name="История_x0020_продажи_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:История_x0020_продажи" />
      <xs:field xpath="mstns:ID_Istorii" />
    </xs:unique>
    <xs:unique name="Клиенты_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Клиенты" />
      <xs:field xpath="mstns:ID_Klienta" />
    </xs:unique>
    <xs:unique name="Товары_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Товары" />
      <xs:field xpath="mstns:ID_Tovara" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Заказ_Клиенты" msdata:parent="Клиенты" msdata:child="Заказ" msdata:parentkey="ID_Klienta" msdata:childkey="ID_Klienta" msprop:Generator_UserChildTable="Заказ" msprop:Generator_ChildPropName="GetЗаказRows" msprop:Generator_UserRelationName="FK_Заказ_Клиенты" msprop:Generator_RelationVarName="relationFK_Заказ_Клиенты" msprop:Generator_UserParentTable="Клиенты" msprop:Generator_ParentPropName="КлиентыRow" />
      <msdata:Relationship name="FK_Заказ_Товары" msdata:parent="Товары" msdata:child="Заказ" msdata:parentkey="ID_Tovara" msdata:childkey="ID_Tovara" msprop:Generator_UserChildTable="Заказ" msprop:Generator_ChildPropName="GetЗаказRows" msprop:Generator_UserRelationName="FK_Заказ_Товары" msprop:Generator_RelationVarName="relationFK_Заказ_Товары" msprop:Generator_UserParentTable="Товары" msprop:Generator_ParentPropName="ТоварыRow" />
      <msdata:Relationship name="FK_История_x0020_продажи_Товары" msdata:parent="Товары" msdata:child="История_x0020_продажи" msdata:parentkey="ID_Tovara" msdata:childkey="ID_Tovara" msprop:Generator_UserChildTable="История продажи" msprop:Generator_ChildPropName="GetИстория_продажиRows" msprop:Generator_UserRelationName="FK_История продажи_Товары" msprop:Generator_RelationVarName="relationFK_История_продажи_Товары" msprop:Generator_UserParentTable="Товары" msprop:Generator_ParentPropName="ТоварыRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>