Lyahov_Tkani/lyahov_TkaniDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="lyahov_TkaniDataSet" targetNamespace="http://tempuri.org/lyahov_TkaniDataSet.xsd" xmlns:mstns="http://tempuri.org/lyahov_TkaniDataSet.xsd" xmlns="http://tempuri.org/lyahov_TkaniDataSet.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="lyahov_TkaniConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="lyahov_TkaniConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.lyahov_tkani.Properties.Settings.GlobalReference.Default.lyahov_TkaniConnectionString" 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="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Номер] = @Original_Номер) AND ([Этап_выполнения] = @Original_Этап_выполнения) AND ([Заказчик] = @Original_Заказчик) AND ((@IsNull_Менеджер = 1 AND [Менеджер] IS NULL) OR ([Менеджер] = @Original_Менеджер)) AND ([Дата] = @Original_Дата) AND ((@IsNull_Стоимость = 1 AND [Стоимость] IS NULL) OR ([Стоимость] = @Original_Стоимость)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Номер" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Этап_выполнения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Этап_выполнения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Заказчик" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Заказчик" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Менеджер" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Менеджер" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Менеджер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Менеджер" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Стоимость" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Стоимость" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Стоимость" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Заказ] ([Этап_выполнения], [Заказчик], [Менеджер], [Дата], [Стоимость]) VALUES (@Этап_выполнения, @Заказчик, @Менеджер, @Дата, @Стоимость);
SELECT Номер, Этап_выполнения, Заказчик, Менеджер, Дата, Стоимость FROM Заказ WHERE (Номер = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Этап_выполнения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Этап_выполнения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Заказчик" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Заказчик" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Менеджер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Менеджер" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Стоимость" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Стоимость" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Номер, Этап_выполнения, Заказчик, Менеджер, Дата, Стоимость FROM dbo.Заказ</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Заказ] SET [Этап_выполнения] = @Этап_выполнения, [Заказчик] = @Заказчик, [Менеджер] = @Менеджер, [Дата] = @Дата, [Стоимость] = @Стоимость WHERE (([Номер] = @Original_Номер) AND ([Этап_выполнения] = @Original_Этап_выполнения) AND ([Заказчик] = @Original_Заказчик) AND ((@IsNull_Менеджер = 1 AND [Менеджер] IS NULL) OR ([Менеджер] = @Original_Менеджер)) AND ([Дата] = @Original_Дата) AND ((@IsNull_Стоимость = 1 AND [Стоимость] IS NULL) OR ([Стоимость] = @Original_Стоимость)));
SELECT Номер, Этап_выполнения, Заказчик, Менеджер, Дата, Стоимость FROM Заказ WHERE (Номер = @Номер)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Этап_выполнения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Этап_выполнения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Заказчик" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Заказчик" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Менеджер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Менеджер" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Стоимость" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Стоимость" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Номер" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Этап_выполнения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Этап_выполнения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Заказчик" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Заказчик" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Менеджер" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Менеджер" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Менеджер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Менеджер" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Стоимость" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Стоимость" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Стоимость" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Номер" ColumnName="Номер" DataSourceName="lyahov_Tkani.dbo.Заказ" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Номер" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Номер" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Номер" DataSetColumn="Номер" />
              <Mapping SourceColumn="Этап_выполнения" DataSetColumn="Этап_выполнения" />
              <Mapping SourceColumn="Заказчик" DataSetColumn="Заказчик" />
              <Mapping SourceColumn="Менеджер" DataSetColumn="Менеджер" />
              <Mapping SourceColumn="Дата" DataSetColumn="Дата" />
              <Mapping SourceColumn="Стоимость" DataSetColumn="Стоимость" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Заказанные изделияTableAdapter" GeneratorDataComponentClassName="Заказанные_изделияTableAdapter" Name="Заказанные изделия" UserDataComponentName="Заказанные изделияTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Номер_заказа] = @Original_Номер_заказа) AND ([Артикул_изделия] = @Original_Артикул_изделия) AND ([Количество] = @Original_Количество))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_изделия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Заказанные изделия] ([Номер_заказа], [Артикул_изделия], [Количество]) VALUES (@Номер_заказа, @Артикул_изделия, @Количество);
SELECT Номер_заказа, Артикул_изделия, Количество FROM [Заказанные изделия] WHERE (Артикул_изделия = @Артикул_изделия) AND (Номер_заказа = @Номер_заказа)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер_заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_изделия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Номер_заказа, Артикул_изделия, Количество FROM dbo.[Заказанные изделия]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Заказанные изделия] SET [Номер_заказа] = @Номер_заказа, [Артикул_изделия] = @Артикул_изделия, [Количество] = @Количество WHERE (([Номер_заказа] = @Original_Номер_заказа) AND ([Артикул_изделия] = @Original_Артикул_изделия) AND ([Количество] = @Original_Количество));
SELECT Номер_заказа, Артикул_изделия, Количество FROM [Заказанные изделия] WHERE (Артикул_изделия = @Артикул_изделия) AND (Номер_заказа = @Номер_заказа)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер_заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_изделия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_изделия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Номер_заказа" DataSetColumn="Номер_заказа" />
              <Mapping SourceColumn="Артикул_изделия" DataSetColumn="Артикул_изделия" />
              <Mapping SourceColumn="Количество" DataSetColumn="Количество" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ИзделиеTableAdapter" GeneratorDataComponentClassName="ИзделиеTableAdapter" Name="Изделие" UserDataComponentName="ИзделиеTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Артикул] = @Original_Артикул) AND ([Наименование] = @Original_Наименование) AND ([Ширина] = @Original_Ширина) AND ([Длина] = @Original_Длина) AND ((@IsNull_Комментарий = 1 AND [Комментарий] IS NULL) OR ([Комментарий] = @Original_Комментарий)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Комментарий" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Комментарий" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Комментарий" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Комментарий" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Изделие] ([Артикул], [Наименование], [Ширина], [Длина], [Изображение], [Комментарий]) VALUES (@Артикул, @Наименование, @Ширина, @Длина, @Изображение, @Комментарий);
SELECT Артикул, Наименование, Ширина, Длина, Изображение, Комментарий FROM Изделие WHERE (Артикул = @Артикул)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Изображение" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Комментарий" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Комментарий" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Артикул, Наименование, Ширина, Длина, Изображение, Комментарий FROM dbo.Изделие</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Изделие] SET [Артикул] = @Артикул, [Наименование] = @Наименование, [Ширина] = @Ширина, [Длина] = @Длина, [Изображение] = @Изображение, [Комментарий] = @Комментарий WHERE (([Артикул] = @Original_Артикул) AND ([Наименование] = @Original_Наименование) AND ([Ширина] = @Original_Ширина) AND ([Длина] = @Original_Длина) AND ((@IsNull_Комментарий = 1 AND [Комментарий] IS NULL) OR ([Комментарий] = @Original_Комментарий)));
SELECT Артикул, Наименование, Ширина, Длина, Изображение, Комментарий FROM Изделие WHERE (Артикул = @Артикул)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Изображение" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Комментарий" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Комментарий" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Комментарий" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Комментарий" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Комментарий" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Комментарий" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Артикул" DataSetColumn="Артикул" />
              <Mapping SourceColumn="Наименование" DataSetColumn="Наименование" />
              <Mapping SourceColumn="Ширина" DataSetColumn="Ширина" />
              <Mapping SourceColumn="Длина" DataSetColumn="Длина" />
              <Mapping SourceColumn="Изображение" DataSetColumn="Изображение" />
              <Mapping SourceColumn="Комментарий" DataSetColumn="Комментарий" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ПользовательTableAdapter" GeneratorDataComponentClassName="ПользовательTableAdapter" Name="Пользователь" UserDataComponentName="ПользовательTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Логин] = @Original_Логин) AND ([Пароль] = @Original_Пароль) AND ([Роль] = @Original_Роль) AND ((@IsNull_Наименование = 1 AND [Наименование] IS NULL) OR ([Наименование] = @Original_Наименование)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Роль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Наименование" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Пользователь] ([Логин], [Пароль], [Роль], [Наименование]) VALUES (@Логин, @Пароль, @Роль, @Наименование);
SELECT Логин, Пароль, Роль, Наименование FROM Пользователь WHERE (Логин = @Логин)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Роль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Логин, Пароль, Роль, Наименование FROM dbo.Пользователь</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Пользователь] SET [Логин] = @Логин, [Пароль] = @Пароль, [Роль] = @Роль, [Наименование] = @Наименование WHERE (([Логин] = @Original_Логин) AND ([Пароль] = @Original_Пароль) AND ([Роль] = @Original_Роль) AND ((@IsNull_Наименование = 1 AND [Наименование] IS NULL) OR ([Наименование] = @Original_Наименование)));
SELECT Логин, Пароль, Роль, Наименование FROM Пользователь WHERE (Логин = @Логин)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Роль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Роль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Наименование" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Логин" DataSetColumn="Логин" />
              <Mapping SourceColumn="Пароль" DataSetColumn="Пароль" />
              <Mapping SourceColumn="Роль" DataSetColumn="Роль" />
              <Mapping SourceColumn="Наименование" DataSetColumn="Наименование" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Склад тканиTableAdapter" GeneratorDataComponentClassName="Склад_тканиTableAdapter" Name="Склад ткани" UserDataComponentName="Склад тканиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Рулон] = @Original_Рулон) AND ([Артикул_ткани] = @Original_Артикул_ткани) AND ([Ширина] = @Original_Ширина) AND ([Длина] = @Original_Длина))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Рулон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Рулон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_ткани" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_ткани" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Склад ткани] ([Рулон], [Артикул_ткани], [Ширина], [Длина]) VALUES (@Рулон, @Артикул_ткани, @Ширина, @Длина);
SELECT Рулон, Артикул_ткани, Ширина, Длина FROM [Склад ткани] WHERE (Артикул_ткани = @Артикул_ткани) AND (Рулон = @Рулон)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Рулон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Рулон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_ткани" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_ткани" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Рулон, Артикул_ткани, Ширина, Длина FROM dbo.[Склад ткани]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Склад ткани] SET [Рулон] = @Рулон, [Артикул_ткани] = @Артикул_ткани, [Ширина] = @Ширина, [Длина] = @Длина WHERE (([Рулон] = @Original_Рулон) AND ([Артикул_ткани] = @Original_Артикул_ткани) AND ([Ширина] = @Original_Ширина) AND ([Длина] = @Original_Длина));
SELECT Рулон, Артикул_ткани, Ширина, Длина FROM [Склад ткани] WHERE (Артикул_ткани = @Артикул_ткани) AND (Рулон = @Рулон)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Рулон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Рулон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_ткани" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_ткани" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Рулон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Рулон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_ткани" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_ткани" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Рулон" DataSetColumn="Рулон" />
              <Mapping SourceColumn="Артикул_ткани" DataSetColumn="Артикул_ткани" />
              <Mapping SourceColumn="Ширина" DataSetColumn="Ширина" />
              <Mapping SourceColumn="Длина" DataSetColumn="Длина" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Склад фурнитурыTableAdapter" GeneratorDataComponentClassName="Склад_фурнитурыTableAdapter" Name="Склад фурнитуры" UserDataComponentName="Склад фурнитурыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Партия] = @Original_Партия) AND ([Артикул_фурнитуры] = @Original_Артикул_фурнитуры) AND ([Количество] = @Original_Количество))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Партия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Партия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_фурнитуры" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_фурнитуры" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Склад фурнитуры] ([Партия], [Артикул_фурнитуры], [Количество]) VALUES (@Партия, @Артикул_фурнитуры, @Количество);
SELECT Партия, Артикул_фурнитуры, Количество FROM [Склад фурнитуры] WHERE (Артикул_фурнитуры = @Артикул_фурнитуры) AND (Партия = @Партия)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Партия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Партия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_фурнитуры" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_фурнитуры" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Партия, Артикул_фурнитуры, Количество FROM dbo.[Склад фурнитуры]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Склад фурнитуры] SET [Партия] = @Партия, [Артикул_фурнитуры] = @Артикул_фурнитуры, [Количество] = @Количество WHERE (([Партия] = @Original_Партия) AND ([Артикул_фурнитуры] = @Original_Артикул_фурнитуры) AND ([Количество] = @Original_Количество));
SELECT Партия, Артикул_фурнитуры, Количество FROM [Склад фурнитуры] WHERE (Артикул_фурнитуры = @Артикул_фурнитуры) AND (Партия = @Партия)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Партия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Партия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_фурнитуры" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_фурнитуры" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Партия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Партия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_фурнитуры" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_фурнитуры" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Партия" DataSetColumn="Партия" />
              <Mapping SourceColumn="Артикул_фурнитуры" DataSetColumn="Артикул_фурнитуры" />
              <Mapping SourceColumn="Количество" DataSetColumn="Количество" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Ткани изделияTableAdapter" GeneratorDataComponentClassName="Ткани_изделияTableAdapter" Name="Ткани изделия" UserDataComponentName="Ткани изделияTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Артикул_ткани] = @Original_Артикул_ткани) AND ([Артикул_изделия] = @Original_Артикул_изделия))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_ткани" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_ткани" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_изделия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Ткани изделия] ([Артикул_ткани], [Артикул_изделия]) VALUES (@Артикул_ткани, @Артикул_изделия);
SELECT Артикул_ткани, Артикул_изделия FROM [Ткани изделия] WHERE (Артикул_изделия = @Артикул_изделия) AND (Артикул_ткани = @Артикул_ткани)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_ткани" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_ткани" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_изделия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Артикул_ткани, Артикул_изделия FROM dbo.[Ткани изделия]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Ткани изделия] SET [Артикул_ткани] = @Артикул_ткани, [Артикул_изделия] = @Артикул_изделия WHERE (([Артикул_ткани] = @Original_Артикул_ткани) AND ([Артикул_изделия] = @Original_Артикул_изделия));
SELECT Артикул_ткани, Артикул_изделия FROM [Ткани изделия] WHERE (Артикул_изделия = @Артикул_изделия) AND (Артикул_ткани = @Артикул_ткани)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_ткани" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_ткани" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_изделия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_ткани" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_ткани" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_изделия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Артикул_ткани" DataSetColumn="Артикул_ткани" />
              <Mapping SourceColumn="Артикул_изделия" DataSetColumn="Артикул_изделия" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ТканьTableAdapter" GeneratorDataComponentClassName="ТканьTableAdapter" Name="Ткань" UserDataComponentName="ТканьTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Артикул] = @Original_Артикул) AND ([Наименование] = @Original_Наименование) AND ((@IsNull_Цвет = 1 AND [Цвет] IS NULL) OR ([Цвет] = @Original_Цвет)) AND ((@IsNull_Состав = 1 AND [Состав] IS NULL) OR ([Состав] = @Original_Состав)) AND ([Ширина] = @Original_Ширина) AND ([Длина] = @Original_Длина) AND ([Цена] = @Original_Цена))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цвет" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цвет" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цвет" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цвет" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Состав" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Состав" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Состав" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Состав" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Ткань] ([Артикул], [Наименование], [Цвет], [Рисунок], [Изображение], [Состав], [Ширина], [Длина], [Цена]) VALUES (@Артикул, @Наименование, @Цвет, @Рисунок, @Изображение, @Состав, @Ширина, @Длина, @Цена);
SELECT Артикул, Наименование, Цвет, Рисунок, Изображение, Состав, Ширина, Длина, Цена FROM Ткань WHERE (Артикул = @Артикул)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Цвет" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цвет" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Рисунок" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Рисунок" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Изображение" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Состав" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Состав" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Артикул, Наименование, Цвет, Рисунок, Изображение, Состав, Ширина, Длина, Цена FROM dbo.Ткань</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Ткань] SET [Артикул] = @Артикул, [Наименование] = @Наименование, [Цвет] = @Цвет, [Рисунок] = @Рисунок, [Изображение] = @Изображение, [Состав] = @Состав, [Ширина] = @Ширина, [Длина] = @Длина, [Цена] = @Цена WHERE (([Артикул] = @Original_Артикул) AND ([Наименование] = @Original_Наименование) AND ((@IsNull_Цвет = 1 AND [Цвет] IS NULL) OR ([Цвет] = @Original_Цвет)) AND ((@IsNull_Состав = 1 AND [Состав] IS NULL) OR ([Состав] = @Original_Состав)) AND ([Ширина] = @Original_Ширина) AND ([Длина] = @Original_Длина) AND ([Цена] = @Original_Цена));
SELECT Артикул, Наименование, Цвет, Рисунок, Изображение, Состав, Ширина, Длина, Цена FROM Ткань WHERE (Артикул = @Артикул)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Цвет" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цвет" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Рисунок" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Рисунок" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Изображение" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Состав" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Состав" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цвет" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цвет" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цвет" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цвет" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Состав" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Состав" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Состав" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Состав" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Артикул" DataSetColumn="Артикул" />
              <Mapping SourceColumn="Наименование" DataSetColumn="Наименование" />
              <Mapping SourceColumn="Цвет" DataSetColumn="Цвет" />
              <Mapping SourceColumn="Рисунок" DataSetColumn="Рисунок" />
              <Mapping SourceColumn="Изображение" DataSetColumn="Изображение" />
              <Mapping SourceColumn="Состав" DataSetColumn="Состав" />
              <Mapping SourceColumn="Ширина" DataSetColumn="Ширина" />
              <Mapping SourceColumn="Длина" DataSetColumn="Длина" />
              <Mapping SourceColumn="Цена" DataSetColumn="Цена" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ФурнитураTableAdapter" GeneratorDataComponentClassName="ФурнитураTableAdapter" Name="Фурнитура" UserDataComponentName="ФурнитураTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Артикул] = @Original_Артикул) AND ([Наименование] = @Original_Наименование) AND ([Тип] = @Original_Тип) AND ([Ширина] = @Original_Ширина) AND ((@IsNull_Длина = 1 AND [Длина] IS NULL) OR ([Длина] = @Original_Длина)) AND ((@IsNull_Вес = 1 AND [Вес] IS NULL) OR ([Вес] = @Original_Вес)) AND ((@IsNull_Цена = 1 AND [Цена] IS NULL) OR ([Цена] = @Original_Цена)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Тип" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Тип" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Длина" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Вес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Вес" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Вес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Вес" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Фурнитура] ([Артикул], [Наименование], [Тип], [Ширина], [Длина], [Вес], [Изображение], [Цена]) VALUES (@Артикул, @Наименование, @Тип, @Ширина, @Длина, @Вес, @Изображение, @Цена);
SELECT Артикул, Наименование, Тип, Ширина, Длина, Вес, Изображение, Цена FROM Фурнитура WHERE (Артикул = @Артикул)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Тип" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Тип" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Вес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Вес" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Изображение" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Артикул, Наименование, Тип, Ширина, Длина, Вес, Изображение, Цена FROM dbo.Фурнитура</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Фурнитура] SET [Артикул] = @Артикул, [Наименование] = @Наименование, [Тип] = @Тип, [Ширина] = @Ширина, [Длина] = @Длина, [Вес] = @Вес, [Изображение] = @Изображение, [Цена] = @Цена WHERE (([Артикул] = @Original_Артикул) AND ([Наименование] = @Original_Наименование) AND ([Тип] = @Original_Тип) AND ([Ширина] = @Original_Ширина) AND ((@IsNull_Длина = 1 AND [Длина] IS NULL) OR ([Длина] = @Original_Длина)) AND ((@IsNull_Вес = 1 AND [Вес] IS NULL) OR ([Вес] = @Original_Вес)) AND ((@IsNull_Цена = 1 AND [Цена] IS NULL) OR ([Цена] = @Original_Цена)));
SELECT Артикул, Наименование, Тип, Ширина, Длина, Вес, Изображение, Цена FROM Фурнитура WHERE (Артикул = @Артикул)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Тип" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Тип" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Вес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Вес" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Изображение" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Тип" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Тип" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Длина" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Вес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Вес" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Вес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Вес" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Артикул" DataSetColumn="Артикул" />
              <Mapping SourceColumn="Наименование" DataSetColumn="Наименование" />
              <Mapping SourceColumn="Тип" DataSetColumn="Тип" />
              <Mapping SourceColumn="Ширина" DataSetColumn="Ширина" />
              <Mapping SourceColumn="Длина" DataSetColumn="Длина" />
              <Mapping SourceColumn="Вес" DataSetColumn="Вес" />
              <Mapping SourceColumn="Изображение" DataSetColumn="Изображение" />
              <Mapping SourceColumn="Цена" DataSetColumn="Цена" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фурнитура изделияTableAdapter" GeneratorDataComponentClassName="Фурнитура_изделияTableAdapter" Name="Фурнитура изделия" UserDataComponentName="Фурнитура изделияTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lyahov_TkaniConnectionString (Settings)" DbObjectName="lyahov_Tkani.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 (([Артикул_фурнитуры] = @Original_Артикул_фурнитуры) AND ([Артикул_изделия] = @Original_Артикул_изделия) AND ([Размещение] = @Original_Размещение) AND ((@IsNull_Ширина = 1 AND [Ширина] IS NULL) OR ([Ширина] = @Original_Ширина)) AND ((@IsNull_Длина = 1 AND [Длина] IS NULL) OR ([Длина] = @Original_Длина)) AND ((@IsNull_Поворот = 1 AND [Поворот] IS NULL) OR ([Поворот] = @Original_Поворот)) AND ([Количество] = @Original_Количество))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_фурнитуры" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_фурнитуры" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Артикул_изделия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Размещение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Размещение" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ширина" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Длина" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Поворот" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Поворот" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Поворот" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Поворот" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Фурнитура изделия] ([Артикул_фурнитуры], [Размещение], [Ширина], [Длина], [Поворот], [Количество]) VALUES (@Артикул_фурнитуры, @Размещение, @Ширина, @Длина, @Поворот, @Количество);
SELECT Артикул_фурнитуры, Артикул_изделия, Размещение, Ширина, Длина, Поворот, Количество FROM [Фурнитура изделия] WHERE (Артикул_изделия = SCOPE_IDENTITY()) AND (Артикул_фурнитуры = @Артикул_фурнитуры)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_фурнитуры" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_фурнитуры" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Размещение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Размещение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Поворот" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Поворот" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Артикул_фурнитуры, Артикул_изделия, Размещение, Ширина, Длина, Поворот, Количество FROM dbo.[Фурнитура изделия]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Фурнитура изделия] SET [Артикул_фурнитуры] = @Артикул_фурнитуры, [Размещение] = @Размещение, [Ширина] = @Ширина, [Длина] = @Длина, [Поворот] = @Поворот, [Количество] = @Количество WHERE (([Артикул_фурнитуры] = @Original_Артикул_фурнитуры) AND ([Артикул_изделия] = @Original_Артикул_изделия) AND ([Размещение] = @Original_Размещение) AND ((@IsNull_Ширина = 1 AND [Ширина] IS NULL) OR ([Ширина] = @Original_Ширина)) AND ((@IsNull_Длина = 1 AND [Длина] IS NULL) OR ([Длина] = @Original_Длина)) AND ((@IsNull_Поворот = 1 AND [Поворот] IS NULL) OR ([Поворот] = @Original_Поворот)) AND ([Количество] = @Original_Количество));
SELECT Артикул_фурнитуры, Артикул_изделия, Размещение, Ширина, Длина, Поворот, Количество FROM [Фурнитура изделия] WHERE (Артикул_изделия = @Артикул_изделия) AND (Артикул_фурнитуры = @Артикул_фурнитуры)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_фурнитуры" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_фурнитуры" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Размещение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Размещение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Поворот" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Поворот" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_фурнитуры" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_фурнитуры" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Артикул_изделия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Размещение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Размещение" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ширина" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ширина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ширина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Длина" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Длина" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Длина" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Поворот" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Поворот" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Поворот" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Поворот" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Артикул_изделия" ColumnName="Артикул_изделия" DataSourceName="lyahov_Tkani.dbo.[Фурнитура изделия]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Артикул_изделия" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Артикул_изделия" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Артикул_фурнитуры" DataSetColumn="Артикул_фурнитуры" />
              <Mapping SourceColumn="Артикул_изделия" DataSetColumn="Артикул_изделия" />
              <Mapping SourceColumn="Размещение" DataSetColumn="Размещение" />
              <Mapping SourceColumn="Ширина" DataSetColumn="Ширина" />
              <Mapping SourceColumn="Длина" DataSetColumn="Длина" />
              <Mapping SourceColumn="Поворот" DataSetColumn="Поворот" />
              <Mapping SourceColumn="Количество" DataSetColumn="Количество" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="lyahov_TkaniDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="lyahov_TkaniDataSet" msprop:Generator_UserDSName="lyahov_TkaniDataSet">
    <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="Номер" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnНомер" msprop:Generator_ColumnPropNameInRow="Номер" msprop:Generator_ColumnPropNameInTable="НомерColumn" msprop:Generator_UserColumnName="Номер" type="xs:int" />
              <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: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:element name="Менеджер" 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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <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="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Стоимость" msprop:Generator_ColumnVarNameInTable="columnСтоимость" msprop:Generator_ColumnPropNameInRow="Стоимость" msprop:Generator_ColumnPropNameInTable="СтоимостьColumn" msprop:Generator_UserColumnName="Стоимость" type="xs:decimal" minOccurs="0" />
            </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="Номер_заказа" msprop:Generator_ColumnVarNameInTable="columnНомер_заказа" msprop:Generator_ColumnPropNameInRow="Номер_заказа" msprop:Generator_ColumnPropNameInTable="Номер_заказаColumn" msprop:Generator_UserColumnName="Номер_заказа" type="xs:int" />
              <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:element name="Количество" msprop:Generator_ColumnVarNameInTable="columnКоличество" msprop:Generator_ColumnPropNameInRow="Количество" msprop:Generator_ColumnPropNameInTable="КоличествоColumn" msprop:Generator_UserColumnName="Количество" 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="Артикул" 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: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: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: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:element name="Изображение" msprop:Generator_ColumnVarNameInTable="columnИзображение" msprop:Generator_ColumnPropNameInRow="Изображение" msprop:Generator_ColumnPropNameInTable="ИзображениеColumn" msprop:Generator_UserColumnName="Изображение" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Комментарий" 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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </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="Логин" 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: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: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:element name="Наименование" 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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </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="Рулон" msprop:Generator_ColumnVarNameInTable="columnРулон" msprop:Generator_ColumnPropNameInRow="Рулон" msprop:Generator_ColumnPropNameInTable="РулонColumn" msprop:Generator_UserColumnName="Рулон" type="xs:int" />
              <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: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: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: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="Партия" msprop:Generator_ColumnVarNameInTable="columnПартия" msprop:Generator_ColumnPropNameInRow="Партия" msprop:Generator_ColumnPropNameInTable="ПартияColumn" msprop:Generator_UserColumnName="Партия" type="xs:int" />
              <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:element name="Количество" msprop:Generator_ColumnVarNameInTable="columnКоличество" msprop:Generator_ColumnPropNameInRow="Количество" msprop:Generator_ColumnPropNameInTable="КоличествоColumn" msprop:Generator_UserColumnName="Количество" 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="Артикул_ткани" 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: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: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="Артикул" 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: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:element name="Цвет" 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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Рисунок" msprop:Generator_ColumnVarNameInTable="columnРисунок" msprop:Generator_ColumnPropNameInRow="Рисунок" msprop:Generator_ColumnPropNameInTable="РисунокColumn" msprop:Generator_UserColumnName="Рисунок" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Изображение" msprop:Generator_ColumnVarNameInTable="columnИзображение" msprop:Generator_ColumnPropNameInRow="Изображение" msprop:Generator_ColumnPropNameInTable="ИзображениеColumn" msprop:Generator_UserColumnName="Изображение" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Состав" 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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <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: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: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: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="Артикул" 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: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: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: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:element name="Длина" 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="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Вес" msprop:Generator_ColumnVarNameInTable="columnВес" msprop:Generator_ColumnPropNameInRow="Вес" msprop:Generator_ColumnPropNameInTable="ВесColumn" msprop:Generator_UserColumnName="Вес" type="xs:int" minOccurs="0" />
              <xs:element name="Изображение" msprop:Generator_ColumnVarNameInTable="columnИзображение" msprop:Generator_ColumnPropNameInRow="Изображение" msprop:Generator_ColumnPropNameInTable="ИзображениеColumn" msprop:Generator_UserColumnName="Изображение" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Цена" 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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </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="Артикул_фурнитуры" 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:element name="Артикул_изделия" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnАртикул_изделия" msprop:Generator_ColumnPropNameInRow="Артикул_изделия" msprop:Generator_ColumnPropNameInTable="Артикул_изделияColumn" msprop:Generator_UserColumnName="Артикул_изделия" type="xs:int" />
              <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:element name="Ширина" 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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Длина" 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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Поворот" 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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Количество" msprop:Generator_ColumnVarNameInTable="columnКоличество" msprop:Generator_ColumnPropNameInRow="Количество" msprop:Generator_ColumnPropNameInTable="КоличествоColumn" msprop:Generator_UserColumnName="Количество" type="xs:int" />
            </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:Номер" />
    </xs:unique>
    <xs:unique name="Заказанные_x0020_изделия_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Заказанные_x0020_изделия" />
      <xs:field xpath="mstns:Номер_заказа" />
      <xs:field xpath="mstns:Артикул_изделия" />
    </xs:unique>
    <xs:unique name="Изделие_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Изделие" />
      <xs:field xpath="mstns:Артикул" />
    </xs:unique>
    <xs:unique name="Пользователь_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Пользователь" />
      <xs:field xpath="mstns:Логин" />
    </xs:unique>
    <xs:unique name="Склад_x0020_ткани_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Склад_x0020_ткани" />
      <xs:field xpath="mstns:Рулон" />
      <xs:field xpath="mstns:Артикул_ткани" />
    </xs:unique>
    <xs:unique name="Склад_x0020_фурнитуры_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Склад_x0020_фурнитуры" />
      <xs:field xpath="mstns:Партия" />
      <xs:field xpath="mstns:Артикул_фурнитуры" />
    </xs:unique>
    <xs:unique name="Ткани_x0020_изделия_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Ткани_x0020_изделия" />
      <xs:field xpath="mstns:Артикул_ткани" />
      <xs:field xpath="mstns:Артикул_изделия" />
    </xs:unique>
    <xs:unique name="Ткань_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Ткань" />
      <xs:field xpath="mstns:Артикул" />
    </xs:unique>
    <xs:unique name="Фурнитура_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Фурнитура" />
      <xs:field xpath="mstns:Артикул" />
    </xs:unique>
    <xs:unique name="Фурнитура_x0020_изделия_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Фурнитура_x0020_изделия" />
      <xs:field xpath="mstns:Артикул_фурнитуры" />
      <xs:field xpath="mstns:Артикул_изделия" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Заказ_Пользователь" msdata:parent="Пользователь" msdata:child="Заказ" msdata:parentkey="Логин" msdata:childkey="Заказчик" msprop:Generator_UserChildTable="Заказ" msprop:Generator_ChildPropName="GetЗаказRowsByFK_Заказ_Пользователь" msprop:Generator_UserRelationName="FK_Заказ_Пользователь" msprop:Generator_RelationVarName="relationFK_Заказ_Пользователь" msprop:Generator_UserParentTable="Пользователь" msprop:Generator_ParentPropName="ПользовательRowByFK_Заказ_Пользователь" />
      <msdata:Relationship name="FK_Заказ_Пользователь1" msdata:parent="Пользователь" msdata:child="Заказ" msdata:parentkey="Логин" msdata:childkey="Менеджер" msprop:Generator_UserChildTable="Заказ" msprop:Generator_ChildPropName="GetЗаказRowsByFK_Заказ_Пользователь1" msprop:Generator_UserRelationName="FK_Заказ_Пользователь1" msprop:Generator_RelationVarName="relationFK_Заказ_Пользователь1" msprop:Generator_UserParentTable="Пользователь" msprop:Generator_ParentPropName="ПользовательRowByFK_Заказ_Пользователь1" />
      <msdata:Relationship name="FK_Заказанные_x0020_изделия_Заказ" msdata:parent="Заказ" msdata:child="Заказанные_x0020_изделия" msdata:parentkey="Номер" msdata:childkey="Номер_заказа" msprop:Generator_UserChildTable="Заказанные изделия" msprop:Generator_ChildPropName="GetЗаказанные_изделияRows" msprop:Generator_UserRelationName="FK_Заказанные изделия_Заказ" msprop:Generator_ParentPropName="ЗаказRow" msprop:Generator_RelationVarName="relationFK_Заказанные_изделия_Заказ" msprop:Generator_UserParentTable="Заказ" />
      <msdata:Relationship name="FK_Заказанные_x0020_изделия_Изделие" msdata:parent="Изделие" msdata:child="Заказанные_x0020_изделия" msdata:parentkey="Артикул" msdata:childkey="Артикул_изделия" 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="Артикул" msdata:childkey="Артикул_ткани" 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="Артикул" msdata:childkey="Артикул_фурнитуры" 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="Артикул" msdata:childkey="Артикул_изделия" msprop:Generator_UserChildTable="Ткани изделия" msprop:Generator_ChildPropName="GetТкани_изделияRows" msprop:Generator_UserRelationName="FK_Ткани изделия_Изделие" msprop:Generator_ParentPropName="ИзделиеRow" msprop:Generator_RelationVarName="relationFK_Ткани_изделия_Изделие" msprop:Generator_UserParentTable="Изделие" />
      <msdata:Relationship name="FK_Ткани_x0020_изделия_Ткань" msdata:parent="Ткань" msdata:child="Ткани_x0020_изделия" msdata:parentkey="Артикул" msdata:childkey="Артикул_ткани" 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="Артикул" msdata:childkey="Артикул_фурнитуры" msprop:Generator_UserChildTable="Фурнитура изделия" msprop:Generator_ChildPropName="GetФурнитура_изделияRows" msprop:Generator_UserRelationName="FK_Фурнитура изделия_Изделие" msprop:Generator_ParentPropName="ИзделиеRow" msprop:Generator_RelationVarName="relationFK_Фурнитура_изделия_Изделие" msprop:Generator_UserParentTable="Изделие" />
      <msdata:Relationship name="FK_Фурнитура_x0020_изделия_Фурнитура" msdata:parent="Фурнитура" msdata:child="Фурнитура_x0020_изделия" msdata:parentkey="Артикул" msdata:childkey="Артикул_фурнитуры" msprop:Generator_UserChildTable="Фурнитура изделия" msprop:Generator_ChildPropName="GetФурнитура_изделияRows" msprop:Generator_UserRelationName="FK_Фурнитура изделия_Фурнитура" msprop:Generator_ParentPropName="ФурнитураRow" msprop:Generator_RelationVarName="relationFK_Фурнитура_изделия_Фурнитура" msprop:Generator_UserParentTable="Фурнитура" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>