DigitalWorld_08/digital_world_8DataSet1.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="digital_world_8DataSet1" targetNamespace="http://tempuri.org/digital_world_8DataSet1.xsd" xmlns:mstns="http://tempuri.org/digital_world_8DataSet1.xsd" xmlns="http://tempuri.org/digital_world_8DataSet1.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="digital_world_8ConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="digital_world_8ConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Digital_World_08.Properties.Settings.GlobalReference.Default.digital_world_8ConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ComponentsTableAdapter" GeneratorDataComponentClassName="ComponentsTableAdapter" Name="Components" UserDataComponentName="ComponentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.Components" 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].[Components] WHERE (([id] = @Original_id) AND ((@IsNull_Id_единицы_измерения = 1 AND [Id единицы измерения] IS NULL) OR ([Id единицы измерения] = @Original_Id_единицы_измерения)) 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="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" 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="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="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].[Components] ([Название], [Id единицы измерения], [Тип_материала], [Цена], [количество]) VALUES (@Название, @Id_единицы_измерения, @Тип_материала, @Цена, @количество);
SELECT id, Название, [Id единицы измерения], Тип_материала, Цена, количество FROM Components WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <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="Int32" Direction="Input" ParameterName="@Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" 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="Int32" Direction="Input" ParameterName="@Цена" Precision="0" ProviderType="Int" 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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Название, [Id единицы измерения], Тип_материала, Цена, количество FROM dbo.Components</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Components] SET [Название] = @Название, [Id единицы измерения] = @Id_единицы_измерения, [Тип_материала] = @Тип_материала, [Цена] = @Цена, [количество] = @количество WHERE (([id] = @Original_id) AND ((@IsNull_Id_единицы_измерения = 1 AND [Id единицы измерения] IS NULL) OR ([Id единицы измерения] = @Original_Id_единицы_измерения)) 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 id, Название, [Id единицы измерения], Тип_материала, Цена, количество FROM Components WHERE (id = @id)</CommandText>
                    <Parameters>
                      <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="Int32" Direction="Input" ParameterName="@Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" 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="Int32" Direction="Input" ParameterName="@Цена" Precision="0" ProviderType="Int" 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="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" 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="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="Int32" Direction="Input" ParameterName="@Original_количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="количество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="digital_world_8.dbo.Components" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Название" DataSetColumn="Название" />
              <Mapping SourceColumn="Id единицы измерения" DataSetColumn="Id единицы измерения" />
              <Mapping SourceColumn="Тип_материала" DataSetColumn="Тип_материала" />
              <Mapping SourceColumn="Цена" DataSetColumn="Цена" />
              <Mapping SourceColumn="количество" DataSetColumn="количество" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="computer_assemblyTableAdapter" GeneratorDataComponentClassName="computer_assemblyTableAdapter" Name="computer_assembly" UserDataComponentName="computer_assemblyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.computer_assembly" 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 [computer_assembly] WHERE (((@IsNull_Видеокарта = 1 AND [Видеокарта] IS NULL) OR ([Видеокарта] = @Original_Видеокарта)) AND ((@IsNull_Материнская_плата = 1 AND [Материнская плата] IS NULL) OR ([Материнская плата] = @Original_Материнская_плата)) AND ((@IsNull_Процессор = 1 AND [Процессор] IS NULL) OR ([Процессор] = @Original_Процессор)) AND ((@p3 = 1 AND [Оперативная память] IS NULL) OR ([Оперативная память] = @p2)) 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 ((@IsNull_Система_охлаждения = 1 AND [Система охлаждения] IS NULL) OR ([Система охлаждения] = @Original_Система_охлаждения)) AND ((@IsNull_Блок_питания = 1 AND [Блок питания] IS NULL) OR ([Блок питания] = @Original_Блок_питания)) AND ((@IsNull_SSD = 1 AND [SSD] IS NULL) OR ([SSD] = @Original_SSD)) AND ((@IsNull_Итоговая_цена = 1 AND [Итоговая цена] IS NULL) OR ([Итоговая цена] = @Original_Итоговая_цена)) AND ([Номер сборки] = @Original_Номер_сборки))</CommandText>
                    <Parameters>
                      <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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оперативная память" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" 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="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_SSD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SSD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SSD" 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="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 [computer_assembly] ([Видеокарта], [Материнская плата], [Процессор], [Оперативная память], [Оперативная_память], [Жетский диск], [Куллер], [Система охлаждения], [Блок питания], [SSD], [Итоговая цена]) VALUES (@Видеокарта, @Материнская_плата, @Процессор, @p1, @Оперативная_память, @Жетский_диск, @Куллер, @Система_охлаждения, @Блок_питания, @SSD, @Итоговая_цена);
SELECT Видеокарта, [Материнская плата], Процессор, [Оперативная память], Оперативная_память, [Жетский диск], Куллер, [Система охлаждения], [Блок питания], SSD, [Итоговая цена], [Номер сборки] FROM computer_assembly WHERE ([Номер сборки] = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <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="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" 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="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="@SSD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SSD" 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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Видеокарта, [Материнская плата], Процессор, [Оперативная память], Оперативная_память, [Жетский диск], Куллер, [Система охлаждения], [Блок питания], SSD, [Итоговая цена], [Номер сборки] FROM computer_assembly</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [computer_assembly] SET [Видеокарта] = @Видеокарта, [Материнская плата] = @Материнская_плата, [Процессор] = @Процессор, [Оперативная память] = @p1, [Оперативная_память] = @Оперативная_память, [Жетский диск] = @Жетский_диск, [Куллер] = @Куллер, [Система охлаждения] = @Система_охлаждения, [Блок питания] = @Блок_питания, [SSD] = @SSD, [Итоговая цена] = @Итоговая_цена WHERE (((@IsNull_Видеокарта = 1 AND [Видеокарта] IS NULL) OR ([Видеокарта] = @Original_Видеокарта)) AND ((@IsNull_Материнская_плата = 1 AND [Материнская плата] IS NULL) OR ([Материнская плата] = @Original_Материнская_плата)) AND ((@IsNull_Процессор = 1 AND [Процессор] IS NULL) OR ([Процессор] = @Original_Процессор)) AND ((@p3 = 1 AND [Оперативная память] IS NULL) OR ([Оперативная память] = @p2)) 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 ((@IsNull_Система_охлаждения = 1 AND [Система охлаждения] IS NULL) OR ([Система охлаждения] = @Original_Система_охлаждения)) AND ((@IsNull_Блок_питания = 1 AND [Блок питания] IS NULL) OR ([Блок питания] = @Original_Блок_питания)) AND ((@IsNull_SSD = 1 AND [SSD] IS NULL) OR ([SSD] = @Original_SSD)) AND ((@IsNull_Итоговая_цена = 1 AND [Итоговая цена] IS NULL) OR ([Итоговая цена] = @Original_Итоговая_цена)) AND ([Номер сборки] = @Original_Номер_сборки));
SELECT Видеокарта, [Материнская плата], Процессор, [Оперативная память], Оперативная_память, [Жетский диск], Куллер, [Система охлаждения], [Блок питания], SSD, [Итоговая цена], [Номер сборки] FROM computer_assembly WHERE ([Номер сборки] = @Номер_сборки)</CommandText>
                    <Parameters>
                      <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="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" 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="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="@SSD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SSD" 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="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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оперативная память" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" 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="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_SSD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SSD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SSD" 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="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="digital_world_8.dbo.computer_assembly" 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="Куллер" />
              <Mapping SourceColumn="Система охлаждения" DataSetColumn="Система охлаждения" />
              <Mapping SourceColumn="Блок питания" DataSetColumn="Блок питания" />
              <Mapping SourceColumn="SSD" DataSetColumn="SSD" />
              <Mapping SourceColumn="Номер сборки" DataSetColumn="Номер сборки" />
              <Mapping SourceColumn="Итоговая цена" DataSetColumn="Итоговая цена" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrderTableAdapter" GeneratorDataComponentClassName="OrderTableAdapter" Name="Order" UserDataComponentName="OrderTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.[Order]" 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 [Order] WHERE (([Id_заказа] = @Original_Id_заказа) AND ((@IsNull_Номер_заказа = 1 AND [Номер заказа] IS NULL) OR ([Номер заказа] = @Original_Номер_заказа)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)) AND ((@IsNull_id_статуса = 1 AND [id статуса] IS NULL) OR ([id статуса] = @Original_id_статуса)) AND ((@IsNull_Номер_сборки = 1 AND [Номер сборки] IS NULL) OR ([Номер сборки] = @Original_Номер_сборки)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id_заказа" 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="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" 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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Order] ([Номер заказа], [Дата], [id статуса], [Номер сборки]) VALUES (@Номер_заказа, @Дата, @id_статуса, @Номер_сборки);
SELECT Id_заказа, [Номер заказа], Дата, [id статуса], [Номер сборки] FROM [Order] WHERE (Id_заказа = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <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="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" 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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id_заказа, [Номер заказа], Дата, [id статуса], [Номер сборки] FROM [Order]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Order] SET [Номер заказа] = @Номер_заказа, [Дата] = @Дата, [id статуса] = @id_статуса, [Номер сборки] = @Номер_сборки WHERE (([Id_заказа] = @Original_Id_заказа) AND ((@IsNull_Номер_заказа = 1 AND [Номер заказа] IS NULL) OR ([Номер заказа] = @Original_Номер_заказа)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)) AND ((@IsNull_id_статуса = 1 AND [id статуса] IS NULL) OR ([id статуса] = @Original_id_статуса)) AND ((@IsNull_Номер_сборки = 1 AND [Номер сборки] IS NULL) OR ([Номер сборки] = @Original_Номер_сборки)));
SELECT Id_заказа, [Номер заказа], Дата, [id статуса], [Номер сборки] FROM [Order] WHERE (Id_заказа = @Id_заказа)</CommandText>
                    <Parameters>
                      <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="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" 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="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id_заказа" 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="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" 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="false" AutogeneratedName="Id_заказа" ColumnName="Id_заказа" DataSourceName="digital_world_8.dbo.[Order]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id_заказа" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id_заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id_заказа" DataSetColumn="Id_заказа" />
              <Mapping SourceColumn="Номер заказа" DataSetColumn="Номер заказа" />
              <Mapping SourceColumn="Дата" DataSetColumn="Дата" />
              <Mapping SourceColumn="id статуса" DataSetColumn="id статуса" />
              <Mapping SourceColumn="Номер сборки" DataSetColumn="Номер сборки" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="order_by_clientsTableAdapter" GeneratorDataComponentClassName="order_by_clientsTableAdapter" Name="order_by_clients" UserDataComponentName="order_by_clientsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.order_by_clients" 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].[order_by_clients] WHERE (([Номер заказа] = @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="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" />
                      <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="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[order_by_clients] ([Пожелания], [Дата]) VALUES (@Пожелания, @Дата);
SELECT [Номер заказа], Пожелания, Дата FROM order_by_clients WHERE ([Номер заказа] = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <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="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Номер заказа], Пожелания, Дата FROM dbo.order_by_clients</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[order_by_clients] SET [Пожелания] = @Пожелания, [Дата] = @Дата WHERE (([Номер заказа] = @Original_Номер_заказа) AND ((@IsNull_Пожелания = 1 AND [Пожелания] IS NULL) OR ([Пожелания] = @Original_Пожелания)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)));
SELECT [Номер заказа], Пожелания, Дата FROM order_by_clients WHERE ([Номер заказа] = @Номер_заказа)</CommandText>
                    <Parameters>
                      <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="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" 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="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="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Номер_заказа" ColumnName="Номер заказа" DataSourceName="digital_world_8.dbo.order_by_clients" 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="Дата" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Order_statusTableAdapter" GeneratorDataComponentClassName="Order_statusTableAdapter" Name="Order_status" UserDataComponentName="Order_statusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.Order_status" 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].[Order_status] WHERE (([id] = @Original_id) AND ((@IsNull_Название_статуса = 1 AND [Название статуса] IS NULL) OR ([Название статуса] = @Original_Название_статуса)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" 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].[Order_status] ([Название статуса]) VALUES (@Название_статуса);
SELECT id, [Название статуса] FROM Order_status WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <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 id, [Название статуса] FROM dbo.Order_status</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Order_status] SET [Название статуса] = @Название_статуса WHERE (([id] = @Original_id) AND ((@IsNull_Название_статуса = 1 AND [Название статуса] IS NULL) OR ([Название статуса] = @Original_Название_статуса)));
SELECT id, [Название статуса] FROM Order_status WHERE (id = @id)</CommandText>
                    <Parameters>
                      <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="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" 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="id" ColumnName="id" DataSourceName="digital_world_8.dbo.Order_status" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Название статуса" DataSetColumn="Название статуса" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="providerTableAdapter" GeneratorDataComponentClassName="providerTableAdapter" Name="provider" UserDataComponentName="providerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.provider" 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].[provider] WHERE (([id] = @Original_id) AND ((@IsNull_название = 1 AND [название] IS NULL) OR ([название] = @Original_название)) AND ((@IsNull_Страна_производитель = 1 AND [Страна производитель] IS NULL) OR ([Страна производитель] = @Original_Страна_производитель)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" 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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[provider] ([id], [название], [Страна производитель]) VALUES (@id, @название, @Страна_производитель);
SELECT id, название, [Страна производитель] FROM provider WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" 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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, название, [Страна производитель] FROM dbo.provider</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[provider] SET [id] = @id, [название] = @название, [Страна производитель] = @Страна_производитель WHERE (([id] = @Original_id) AND ((@IsNull_название = 1 AND [название] IS NULL) OR ([название] = @Original_название)) AND ((@IsNull_Страна_производитель = 1 AND [Страна производитель] IS NULL) OR ([Страна производитель] = @Original_Страна_производитель)));
SELECT id, название, [Страна производитель] FROM provider WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" 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="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" 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" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="название" DataSetColumn="название" />
              <Mapping SourceColumn="Страна производитель" DataSetColumn="Страна производитель" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.Role" 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].[Role] WHERE (([Id] = @Original_Id) AND ((@IsNull_Название_роли = 1 AND [Название роли] IS NULL) OR ([Название роли] = @Original_Название_роли)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" 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].[Role] ([Id], [Название роли]) VALUES (@Id, @Название_роли);
SELECT Id, [Название роли] FROM Role WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" 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 Id, [Название роли] FROM dbo.Role</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Role] SET [Id] = @Id, [Название роли] = @Название_роли WHERE (([Id] = @Original_Id) AND ((@IsNull_Название_роли = 1 AND [Название роли] IS NULL) OR ([Название роли] = @Original_Название_роли)));
SELECT Id, [Название роли] FROM Role WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" 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="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" 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="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Название роли" DataSetColumn="Название роли" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="unit_of_measurementTableAdapter" GeneratorDataComponentClassName="unit_of_measurementTableAdapter" Name="unit_of_measurement" UserDataComponentName="unit_of_measurementTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.unit_of_measurement" 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].[unit_of_measurement] WHERE (([id] = @Original_id) AND ((@IsNull_название = 1 AND [название] IS NULL) OR ([название] = @Original_название)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" 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].[unit_of_measurement] ([название]) VALUES (@название);
SELECT id, название FROM unit_of_measurement WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <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 id, название FROM dbo.unit_of_measurement</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[unit_of_measurement] SET [название] = @название WHERE (([id] = @Original_id) AND ((@IsNull_название = 1 AND [название] IS NULL) OR ([название] = @Original_название)));
SELECT id, название FROM unit_of_measurement WHERE (id = @id)</CommandText>
                    <Parameters>
                      <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="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" 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="id" ColumnName="id" DataSourceName="digital_world_8.dbo.unit_of_measurement" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="название" DataSetColumn="название" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.Users" 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].[Users] WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Users] ([Id], [Username], [Password], [Role]) VALUES (@Id, @Username, @Password, @Role);
SELECT Id, Username, Password, Role FROM Users WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Username, Password, Role FROM dbo.Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Users] SET [Id] = @Id, [Username] = @Username, [Password] = @Password, [Role] = @Role WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)));
SELECT Id, Username, Password, Role FROM Users WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Postavka_materialTableAdapter" GeneratorDataComponentClassName="Postavka_materialTableAdapter" Name="Postavka_material" UserDataComponentName="Postavka_materialTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="digital_world_8ConnectionString1 (Settings)" DbObjectName="digital_world_8.dbo.Postavka_material" 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].[Postavka_material] WHERE (([id] = @Original_id) AND ((@IsNull_id_производителя = 1 AND [id производителя] IS NULL) OR ([id производителя] = @Original_id_производителя)) 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 ((@IsNull_Количество = 1 AND [Количество] IS NULL) OR ([Количество] = @Original_Количество)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_производителя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id производителя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_производителя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id производителя" 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="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" 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="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].[Postavka_material] ([id производителя], [Дата], [Название], [Тип материала], [Количество]) VALUES (@id_производителя, @Дата, @Название, @Тип_материала, @Количество);
SELECT id, [id производителя], Дата, Название, [Тип материала], Количество FROM Postavka_material WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_производителя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id производителя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" 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="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 id, [id производителя], Дата, Название, [Тип материала], Количество FROM dbo.Postavka_material</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Postavka_material] SET [id производителя] = @id_производителя, [Дата] = @Дата, [Название] = @Название, [Тип материала] = @Тип_материала, [Количество] = @Количество WHERE (([id] = @Original_id) AND ((@IsNull_id_производителя = 1 AND [id производителя] IS NULL) OR ([id производителя] = @Original_id_производителя)) 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 ((@IsNull_Количество = 1 AND [Количество] IS NULL) OR ([Количество] = @Original_Количество)));
SELECT id, [id производителя], Дата, Название, [Тип материала], Количество FROM Postavka_material WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_производителя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id производителя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" 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="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_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_производителя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id производителя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_производителя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id производителя" 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="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" 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="Int32" Direction="Input" ParameterName="@Original_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="digital_world_8.dbo.Postavka_material" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="id производителя" DataSetColumn="id производителя" />
              <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="digital_world_8DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="digital_world_8DataSet1" msprop:Generator_UserDSName="digital_world_8DataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Components" msprop:Generator_TableClassName="ComponentsDataTable" msprop:Generator_TableVarName="tableComponents" msprop:Generator_TablePropName="Components" msprop:Generator_RowDeletingName="ComponentsRowDeleting" msprop:Generator_RowChangingName="ComponentsRowChanging" msprop:Generator_RowEvHandlerName="ComponentsRowChangeEventHandler" msprop:Generator_RowDeletedName="ComponentsRowDeleted" msprop:Generator_UserTableName="Components" msprop:Generator_RowChangedName="ComponentsRowChanged" msprop:Generator_RowEvArgName="ComponentsRowChangeEvent" msprop:Generator_RowClassName="ComponentsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <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="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Id_x0020_единицы_x0020_измерения" msprop:Generator_ColumnVarNameInTable="columnId_единицы_измерения" msprop:Generator_ColumnPropNameInRow="Id_единицы_измерения" msprop:Generator_ColumnPropNameInTable="Id_единицы_измеренияColumn" msprop:Generator_UserColumnName="Id единицы измерения" type="xs:int" 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="Цена" type="xs:int" minOccurs="0" />
              <xs:element name="количество" msprop:Generator_ColumnVarNameInTable="columnколичество" msprop:Generator_ColumnPropNameInRow="количество" msprop:Generator_ColumnPropNameInTable="количествоColumn" msprop:Generator_UserColumnName="количество" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="computer_assembly" msprop:Generator_TableClassName="computer_assemblyDataTable" msprop:Generator_TableVarName="tablecomputer_assembly" msprop:Generator_TablePropName="computer_assembly" msprop:Generator_RowDeletingName="computer_assemblyRowDeleting" msprop:Generator_RowChangingName="computer_assemblyRowChanging" msprop:Generator_RowEvHandlerName="computer_assemblyRowChangeEventHandler" msprop:Generator_RowDeletedName="computer_assemblyRowDeleted" msprop:Generator_UserTableName="computer_assembly" msprop:Generator_RowChangedName="computer_assemblyRowChanged" msprop:Generator_RowEvArgName="computer_assemblyRowChangeEvent" msprop:Generator_RowClassName="computer_assemblyRow">
          <xs:complexType>
            <xs:sequence>
              <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="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Материнская_x0020_плата" 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="150" />
                  </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="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Оперативная_x0020_память" 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="150" />
                  </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="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Жетский_x0020_диск" 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="150" />
                  </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="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Система_x0020_охлаждения" 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="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Блок_x0020_питания" 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="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SSD" msprop:Generator_ColumnVarNameInTable="columnSSD" msprop:Generator_ColumnPropNameInRow="SSD" msprop:Generator_ColumnPropNameInTable="SSDColumn" msprop:Generator_UserColumnName="SSD" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Номер_x0020_сборки" 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="Итоговая_x0020_цена" msprop:Generator_ColumnVarNameInTable="columnИтоговая_цена" msprop:Generator_ColumnPropNameInRow="Итоговая_цена" msprop:Generator_ColumnPropNameInTable="Итоговая_ценаColumn" msprop:Generator_UserColumnName="Итоговая цена" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Order" msprop:Generator_TableClassName="OrderDataTable" msprop:Generator_TableVarName="tableOrder" msprop:Generator_TablePropName="Order" msprop:Generator_RowDeletingName="OrderRowDeleting" msprop:Generator_RowChangingName="OrderRowChanging" msprop:Generator_RowEvHandlerName="OrderRowChangeEventHandler" msprop:Generator_RowDeletedName="OrderRowDeleted" msprop:Generator_UserTableName="Order" msprop:Generator_RowChangedName="OrderRowChanged" msprop:Generator_RowEvArgName="OrderRowChangeEvent" msprop:Generator_RowClassName="OrderRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id_заказа" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId_заказа" msprop:Generator_ColumnPropNameInRow="Id_заказа" msprop:Generator_ColumnPropNameInTable="Id_заказаColumn" msprop:Generator_UserColumnName="Id_заказа" type="xs:int" />
              <xs:element name="Номер_x0020_заказа" 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:dateTime" minOccurs="0" />
              <xs:element name="id_x0020_статуса" msprop:Generator_ColumnVarNameInTable="columnid_статуса" msprop:Generator_ColumnPropNameInRow="id_статуса" msprop:Generator_ColumnPropNameInTable="id_статусаColumn" msprop:Generator_UserColumnName="id статуса" type="xs:int" minOccurs="0" />
              <xs:element name="Номер_x0020_сборки" msprop:Generator_ColumnVarNameInTable="columnНомер_сборки" msprop:Generator_ColumnPropNameInRow="Номер_сборки" msprop:Generator_ColumnPropNameInTable="Номер_сборкиColumn" msprop:Generator_UserColumnName="Номер сборки" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="order_by_clients" msprop:Generator_TableClassName="order_by_clientsDataTable" msprop:Generator_TableVarName="tableorder_by_clients" msprop:Generator_TablePropName="order_by_clients" msprop:Generator_RowDeletingName="order_by_clientsRowDeleting" msprop:Generator_RowChangingName="order_by_clientsRowChanging" msprop:Generator_RowEvHandlerName="order_by_clientsRowChangeEventHandler" msprop:Generator_RowDeletedName="order_by_clientsRowDeleted" msprop:Generator_UserTableName="order_by_clients" msprop:Generator_RowChangedName="order_by_clientsRowChanged" msprop:Generator_RowEvArgName="order_by_clientsRowChangeEvent" msprop:Generator_RowClassName="order_by_clientsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Номер_x0020_заказа" 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="Пожелания" 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:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Order_status" msprop:Generator_TableClassName="Order_statusDataTable" msprop:Generator_TableVarName="tableOrder_status" msprop:Generator_TablePropName="Order_status" msprop:Generator_RowDeletingName="Order_statusRowDeleting" msprop:Generator_RowChangingName="Order_statusRowChanging" msprop:Generator_RowEvHandlerName="Order_statusRowChangeEventHandler" msprop:Generator_RowDeletedName="Order_statusRowDeleted" msprop:Generator_UserTableName="Order_status" msprop:Generator_RowChangedName="Order_statusRowChanged" msprop:Generator_RowEvArgName="Order_statusRowChangeEvent" msprop:Generator_RowClassName="Order_statusRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="Название_x0020_статуса" 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="provider" msprop:Generator_TableClassName="providerDataTable" msprop:Generator_TableVarName="tableprovider" msprop:Generator_TablePropName="provider" msprop:Generator_RowDeletingName="providerRowDeleting" msprop:Generator_RowChangingName="providerRowChanging" msprop:Generator_RowEvHandlerName="providerRowChangeEventHandler" msprop:Generator_RowDeletedName="providerRowDeleted" msprop:Generator_UserTableName="provider" msprop:Generator_RowChangedName="providerRowChanged" msprop:Generator_RowEvArgName="providerRowChangeEvent" msprop:Generator_RowClassName="providerRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <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="Страна_x0020_производитель" 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="Role" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_TableVarName="tableRole" msprop:Generator_TablePropName="Role" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_UserTableName="Role" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_RowEvArgName="RoleRowChangeEvent" msprop:Generator_RowClassName="RoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Название_x0020_роли" 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="unit_of_measurement" msprop:Generator_TableClassName="unit_of_measurementDataTable" msprop:Generator_TableVarName="tableunit_of_measurement" msprop:Generator_TablePropName="unit_of_measurement" msprop:Generator_RowDeletingName="unit_of_measurementRowDeleting" msprop:Generator_RowChangingName="unit_of_measurementRowChanging" msprop:Generator_RowEvHandlerName="unit_of_measurementRowChangeEventHandler" msprop:Generator_RowDeletedName="unit_of_measurementRowDeleted" msprop:Generator_UserTableName="unit_of_measurement" msprop:Generator_RowChangedName="unit_of_measurementRowChanged" msprop:Generator_RowEvArgName="unit_of_measurementRowChangeEvent" msprop:Generator_RowClassName="unit_of_measurementRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <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="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowClassName="UsersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_UserColumnName="Username" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Role" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_UserColumnName="Role" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Postavka_material" msprop:Generator_TableClassName="Postavka_materialDataTable" msprop:Generator_TableVarName="tablePostavka_material" msprop:Generator_TablePropName="Postavka_material" msprop:Generator_RowDeletingName="Postavka_materialRowDeleting" msprop:Generator_RowChangingName="Postavka_materialRowChanging" msprop:Generator_RowEvHandlerName="Postavka_materialRowChangeEventHandler" msprop:Generator_RowDeletedName="Postavka_materialRowDeleted" msprop:Generator_UserTableName="Postavka_material" msprop:Generator_RowChangedName="Postavka_materialRowChanged" msprop:Generator_RowEvArgName="Postavka_materialRowChangeEvent" msprop:Generator_RowClassName="Postavka_materialRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="id_x0020_производителя" msprop:Generator_ColumnVarNameInTable="columnid_производителя" msprop:Generator_ColumnPropNameInRow="id_производителя" msprop:Generator_ColumnPropNameInTable="id_производителяColumn" msprop:Generator_UserColumnName="id производителя" type="xs:int" minOccurs="0" />
              <xs:element name="Дата" msprop:Generator_ColumnVarNameInTable="columnДата" msprop:Generator_ColumnPropNameInRow="Дата" msprop:Generator_ColumnPropNameInTable="ДатаColumn" msprop:Generator_UserColumnName="Дата" type="xs:dateTime" 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="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Тип_x0020_материала" 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="150" />
                  </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:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Components" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="computer_assembly_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:computer_assembly" />
      <xs:field xpath="mstns:Номер_x0020_сборки" />
    </xs:unique>
    <xs:unique name="Order_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Order" />
      <xs:field xpath="mstns:Id_заказа" />
    </xs:unique>
    <xs:unique name="order_by_clients_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:order_by_clients" />
      <xs:field xpath="mstns:Номер_x0020_заказа" />
    </xs:unique>
    <xs:unique name="Order_status_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Order_status" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="provider_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:provider" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Role_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Role" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="unit_of_measurement_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:unit_of_measurement" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Postavka_material_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Postavka_material" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Components_unit_of_measurement" msdata:parent="unit_of_measurement" msdata:child="Components" msdata:parentkey="id" msdata:childkey="Id_x0020_единицы_x0020_измерения" msprop:Generator_UserChildTable="Components" msprop:Generator_ChildPropName="GetComponentsRows" msprop:Generator_UserRelationName="FK_Components_unit_of_measurement" msprop:Generator_RelationVarName="relationFK_Components_unit_of_measurement" msprop:Generator_UserParentTable="unit_of_measurement" msprop:Generator_ParentPropName="unit_of_measurementRow" />
      <msdata:Relationship name="FK_Order_order_by_clients" msdata:parent="order_by_clients" msdata:child="Order" msdata:parentkey="Номер_x0020_заказа" msdata:childkey="Номер_x0020_заказа" msprop:Generator_UserChildTable="Order" msprop:Generator_ChildPropName="GetOrderRows" msprop:Generator_UserRelationName="FK_Order_order_by_clients" msprop:Generator_RelationVarName="relationFK_Order_order_by_clients" msprop:Generator_UserParentTable="order_by_clients" msprop:Generator_ParentPropName="order_by_clientsRow" />
      <msdata:Relationship name="FK_Order_Order_status" msdata:parent="Order_status" msdata:child="Order" msdata:parentkey="id" msdata:childkey="id_x0020_статуса" msprop:Generator_UserChildTable="Order" msprop:Generator_ChildPropName="GetOrderRows" msprop:Generator_UserRelationName="FK_Order_Order_status" msprop:Generator_RelationVarName="relationFK_Order_Order_status" msprop:Generator_UserParentTable="Order_status" msprop:Generator_ParentPropName="Order_statusRow" />
      <msdata:Relationship name="FK_Users_Role" msdata:parent="Role" msdata:child="Users" msdata:parentkey="Id" msdata:childkey="Role" msprop:Generator_UserChildTable="Users" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_UserRelationName="FK_Users_Role" msprop:Generator_ParentPropName="RoleRow" msprop:Generator_RelationVarName="relationFK_Users_Role" msprop:Generator_UserParentTable="Role" />
      <msdata:Relationship name="FK_Order_computer_assembly" msdata:parent="computer_assembly" msdata:child="Order" msdata:parentkey="Номер_x0020_сборки" msdata:childkey="Номер_x0020_сборки" msprop:Generator_UserChildTable="Order" msprop:Generator_ChildPropName="GetOrderRows" msprop:Generator_UserRelationName="FK_Order_computer_assembly" msprop:Generator_RelationVarName="relationFK_Order_computer_assembly" msprop:Generator_UserParentTable="computer_assembly" msprop:Generator_ParentPropName="computer_assemblyRow" />
      <msdata:Relationship name="FK_Postavka_material_provider" msdata:parent="provider" msdata:child="Postavka_material" msdata:parentkey="id" msdata:childkey="id_x0020_производителя" msprop:Generator_UserChildTable="Postavka_material" msprop:Generator_ChildPropName="GetPostavka_materialRows" msprop:Generator_UserRelationName="FK_Postavka_material_provider" msprop:Generator_ParentPropName="providerRow" msprop:Generator_RelationVarName="relationFK_Postavka_material_provider" msprop:Generator_UserParentTable="provider" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>