KazarinDE_03/KazarinDE/KazarinDE_03DataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="KazarinDE_03DataSet" targetNamespace="http://tempuri.org/KazarinDE_03DataSet.xsd" xmlns:mstns="http://tempuri.org/KazarinDE_03DataSet.xsd" xmlns="http://tempuri.org/KazarinDE_03DataSet.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="KazarinDE_03ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="KazarinDE_03ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KazarinDE.Properties.Settings.GlobalReference.Default.KazarinDE_03ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ЕдиницыИзмеренияTableAdapter" GeneratorDataComponentClassName="ЕдиницыИзмеренияTableAdapter" Name="ЕдиницыИзмерения" UserDataComponentName="ЕдиницыИзмеренияTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.ЕдиницыИзмерения" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ЕдиницыИзмерения] WHERE (([ID_ЕдиницИзмерения] = @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].[ЕдиницыИзмерения] ([Название]) VALUES (@Название);
SELECT ID_ЕдиницИзмерения, Название FROM ЕдиницыИзмерения 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.ЕдиницыИзмерения</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ЕдиницыИзмерения] SET [Название] = @Название WHERE (([ID_ЕдиницИзмерения] = @Original_ID_ЕдиницИзмерения) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)));
SELECT ID_ЕдиницИзмерения, Название FROM ЕдиницыИзмерения 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="KazarinDE_03.dbo.ЕдиницыИзмерения" 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="ЗаказыTableAdapter" GeneratorDataComponentClassName="ЗаказыTableAdapter" Name="Заказы" UserDataComponentName="ЗаказыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.Заказы" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Заказы] WHERE (([ID_Заказа] = @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_Примечание)) AND ((@IsNull_ID_Клиента = 1 AND [ID_Клиента] IS NULL) OR ([ID_Клиента] = @Original_ID_Клиента)) AND ((@IsNull_ID_Сотрудника = 1 AND [ID_Сотрудника] IS NULL) OR ([ID_Сотрудника] = @Original_ID_Сотрудника)) AND ((@IsNull_ID_Сборки = 1 AND [ID_Сборки] IS NULL) OR ([ID_Сборки] = @Original_ID_Сборки)))</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_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Примечание" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Примечание" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Примечание" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Примечание" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <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_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_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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Заказы] ([НомерЗаказа], [ДатаЗаказа], [СтатусЗаказа], [Примечание], [ID_Клиента], [ID_Сотрудника], [ID_Сборки]) VALUES (@НомерЗаказа, @ДатаЗаказа, @СтатусЗаказа, @Примечание, @ID_Клиента, @ID_Сотрудника, @ID_Сборки);
SELECT ID_Заказа, НомерЗаказа, ДатаЗаказа, СтатусЗаказа, Примечание, ID_Клиента, ID_Сотрудника, ID_Сборки FROM Заказы 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="@СтатусЗаказа" Precision="0" ProviderType="Int" 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="@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="@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="@ID_Сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Сборки" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Заказа, НомерЗаказа, ДатаЗаказа, СтатусЗаказа, Примечание, ID_Клиента, ID_Сотрудника, ID_Сборки FROM dbo.Заказы</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Заказы] SET [НомерЗаказа] = @НомерЗаказа, [ДатаЗаказа] = @ДатаЗаказа, [СтатусЗаказа] = @СтатусЗаказа, [Примечание] = @Примечание, [ID_Клиента] = @ID_Клиента, [ID_Сотрудника] = @ID_Сотрудника, [ID_Сборки] = @ID_Сборки WHERE (([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_Примечание)) AND ((@IsNull_ID_Клиента = 1 AND [ID_Клиента] IS NULL) OR ([ID_Клиента] = @Original_ID_Клиента)) AND ((@IsNull_ID_Сотрудника = 1 AND [ID_Сотрудника] IS NULL) OR ([ID_Сотрудника] = @Original_ID_Сотрудника)) AND ((@IsNull_ID_Сборки = 1 AND [ID_Сборки] IS NULL) OR ([ID_Сборки] = @Original_ID_Сборки)));
SELECT ID_Заказа, НомерЗаказа, ДатаЗаказа, СтатусЗаказа, Примечание, ID_Клиента, ID_Сотрудника, ID_Сборки FROM Заказы 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="@СтатусЗаказа" Precision="0" ProviderType="Int" 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="@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="@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="@ID_Сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Сборки" 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_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Примечание" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Примечание" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Примечание" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Примечание" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <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_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_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="false" AutogeneratedName="ID_Заказа" ColumnName="ID_Заказа" DataSourceName="KazarinDE_03.dbo.Заказы" 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="СтатусЗаказа" DataSetColumn="СтатусЗаказа" />
              <Mapping SourceColumn="Примечание" DataSetColumn="Примечание" />
              <Mapping SourceColumn="ID_Клиента" DataSetColumn="ID_Клиента" />
              <Mapping SourceColumn="ID_Сотрудника" DataSetColumn="ID_Сотрудника" />
              <Mapping SourceColumn="ID_Сборки" DataSetColumn="ID_Сборки" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="КлиентыTableAdapter" GeneratorDataComponentClassName="КлиентыTableAdapter" Name="Клиенты" UserDataComponentName="КлиентыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.Клиенты" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Клиенты] WHERE (([ID_Клиента] = @Original_ID_Клиента) AND ([Имя] = @Original_Имя) AND ([Фамилия] = @Original_Фамилия) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Телефон = 1 AND [Телефон] IS NULL) OR ([Телефон] = @Original_Телефон)) AND ((@IsNull_Адрес = 1 AND [Адрес] IS NULL) OR ([Адрес] = @Original_Адрес)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Клиента" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Клиента" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="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].[Клиенты] ([Имя], [Фамилия], [Отчество], [Телефон], [Адрес]) VALUES (@Имя, @Фамилия, @Отчество, @Телефон, @Адрес);
SELECT ID_Клиента, Имя, Фамилия, Отчество, Телефон, Адрес FROM Клиенты WHERE (ID_Клиента = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="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.Клиенты</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Клиенты] SET [Имя] = @Имя, [Фамилия] = @Фамилия, [Отчество] = @Отчество, [Телефон] = @Телефон, [Адрес] = @Адрес WHERE (([ID_Клиента] = @Original_ID_Клиента) AND ([Имя] = @Original_Имя) AND ([Фамилия] = @Original_Фамилия) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Телефон = 1 AND [Телефон] IS NULL) OR ([Телефон] = @Original_Телефон)) AND ((@IsNull_Адрес = 1 AND [Адрес] IS NULL) OR ([Адрес] = @Original_Адрес)));
SELECT ID_Клиента, Имя, Фамилия, Отчество, Телефон, Адрес FROM Клиенты WHERE (ID_Клиента = @ID_Клиента)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Клиента" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Клиента" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Телефон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Адрес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Клиента" ColumnName="ID_Клиента" DataSourceName="KazarinDE_03.dbo.Клиенты" 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="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Телефон" DataSetColumn="Телефон" />
              <Mapping SourceColumn="Адрес" DataSetColumn="Адрес" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="КомплектующиеTableAdapter" GeneratorDataComponentClassName="КомплектующиеTableAdapter" Name="Комплектующие" UserDataComponentName="КомплектующиеTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.Комплектующие" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Комплектующие] WHERE (([ID_Комплектующего] = @Original_ID_Комплектующего) AND ([Название] = @Original_Название) AND ([Тип] = @Original_Тип) AND ((@IsNull_Поставщик = 1 AND [Поставщик] IS NULL) OR ([Поставщик] = @Original_Поставщик)) AND ((@IsNull_КоличествоНаСкладе = 1 AND [КоличествоНаСкладе] IS NULL) OR ([КоличествоНаСкладе] = @Original_КоличествоНаСкладе)) AND ((@IsNull_ЕдиницыИзмерения = 1 AND [ЕдиницыИзмерения] IS NULL) OR ([ЕдиницыИзмерения] = @Original_ЕдиницыИзмерения)) AND ((@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="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Тип" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Тип" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ЕдиницыИзмерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЕдиницыИзмерения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ЕдиницыИзмерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЕдиницыИзмерения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Комплектующие] ([Название], [Тип], [Поставщик], [КоличествоНаСкладе], [ЕдиницыИзмерения], [Цена]) VALUES (@Название, @Тип, @Поставщик, @КоличествоНаСкладе, @ЕдиницыИзмерения, @Цена);
SELECT ID_Комплектующего, Название, Тип, Поставщик, КоличествоНаСкладе, ЕдиницыИзмерения, Цена FROM Комплектующие WHERE (ID_Комплектующего = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="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="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="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.Комплектующие</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Комплектующие] SET [Название] = @Название, [Тип] = @Тип, [Поставщик] = @Поставщик, [КоличествоНаСкладе] = @КоличествоНаСкладе, [ЕдиницыИзмерения] = @ЕдиницыИзмерения, [Цена] = @Цена WHERE (([ID_Комплектующего] = @Original_ID_Комплектующего) AND ([Название] = @Original_Название) AND ([Тип] = @Original_Тип) AND ((@IsNull_Поставщик = 1 AND [Поставщик] IS NULL) OR ([Поставщик] = @Original_Поставщик)) AND ((@IsNull_КоличествоНаСкладе = 1 AND [КоличествоНаСкладе] IS NULL) OR ([КоличествоНаСкладе] = @Original_КоличествоНаСкладе)) AND ((@IsNull_ЕдиницыИзмерения = 1 AND [ЕдиницыИзмерения] IS NULL) OR ([ЕдиницыИзмерения] = @Original_ЕдиницыИзмерения)) AND ((@IsNull_Цена = 1 AND [Цена] IS NULL) OR ([Цена] = @Original_Цена)));
SELECT ID_Комплектующего, Название, Тип, Поставщик, КоличествоНаСкладе, ЕдиницыИзмерения, Цена FROM Комплектующие WHERE (ID_Комплектующего = @ID_Комплектующего)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="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="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="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="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Тип" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Тип" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ЕдиницыИзмерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЕдиницыИзмерения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ЕдиницыИзмерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЕдиницыИзмерения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цена" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Комплектующего" ColumnName="ID_Комплектующего" DataSourceName="KazarinDE_03.dbo.Комплектующие" 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="Поставщик" DataSetColumn="Поставщик" />
              <Mapping SourceColumn="КоличествоНаСкладе" DataSetColumn="КоличествоНаСкладе" />
              <Mapping SourceColumn="ЕдиницыИзмерения" DataSetColumn="ЕдиницыИзмерения" />
              <Mapping SourceColumn="Цена" DataSetColumn="Цена" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="КомпьютерыTableAdapter" GeneratorDataComponentClassName="КомпьютерыTableAdapter" Name="Компьютеры" UserDataComponentName="КомпьютерыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.Компьютеры" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Компьютеры] WHERE (([ID_ПК] = @Original_ID_ПК))</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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Компьютеры] ([Модель]) VALUES (@Модель);
SELECT ID_ПК, Модель FROM Компьютеры 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.Компьютеры</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Компьютеры] SET [Модель] = @Модель WHERE (([ID_ПК] = @Original_ID_ПК));
SELECT ID_ПК, Модель FROM Компьютеры 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="false" AutogeneratedName="ID_ПК" ColumnName="ID_ПК" DataSourceName="KazarinDE_03.dbo.Компьютеры" 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="ОписаниеСборкиTableAdapter" GeneratorDataComponentClassName="ОписаниеСборкиTableAdapter" Name="ОписаниеСборки" UserDataComponentName="ОписаниеСборкиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.ОписаниеСборки" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ОписаниеСборки] ([ID_ПК], [ID_Комплектующего]) VALUES (@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="Int32" Direction="Input" ParameterName="@ID_Комплектующего" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Комплектующего" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_ПК, ID_Комплектующего FROM dbo.ОписаниеСборки</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_ПК" DataSetColumn="ID_ПК" />
              <Mapping SourceColumn="ID_Комплектующего" DataSetColumn="ID_Комплектующего" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ПоставщикиTableAdapter" GeneratorDataComponentClassName="ПоставщикиTableAdapter" Name="Поставщики" UserDataComponentName="ПоставщикиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.Поставщики" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Поставщики] WHERE (([ID_Поставщика] = @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_Наименование" 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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Поставщики] ([Наименование], [Телефон], [Адрес]) VALUES (@Наименование, @Телефон, @Адрес);
SELECT ID_Поставщика, Наименование, Телефон, Адрес FROM Поставщики 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="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.Поставщики</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Поставщики] SET [Наименование] = @Наименование, [Телефон] = @Телефон, [Адрес] = @Адрес WHERE (([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_Поставщика, Наименование, Телефон, Адрес FROM Поставщики 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="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" />
                      <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="KazarinDE_03.dbo.Поставщики" 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="Адрес" DataSetColumn="Адрес" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="РолиTableAdapter" GeneratorDataComponentClassName="РолиTableAdapter" Name="Роли" UserDataComponentName="РолиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.Роли" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Роли] WHERE (([ID_Роли] = @Original_ID_Роли) AND ([Название] = @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="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Роли] ([Название]) VALUES (@Название);
SELECT ID_Роли, Название FROM Роли WHERE (ID_Роли = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Роли, Название FROM dbo.Роли</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Роли] SET [Название] = @Название WHERE (([ID_Роли] = @Original_ID_Роли) AND ([Название] = @Original_Название));
SELECT ID_Роли, Название FROM Роли WHERE (ID_Роли = @ID_Роли)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Роли" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Роли" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Роли" ColumnName="ID_Роли" DataSourceName="KazarinDE_03.dbo.Роли" 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="СборкаTableAdapter" GeneratorDataComponentClassName="СборкаTableAdapter" Name="Сборка" UserDataComponentName="СборкаTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.Сборка" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Сборка] WHERE (([ID_Сборки] = @Original_ID_Сборки) AND ((@IsNull_ID_ПК = 1 AND [ID_ПК] IS NULL) OR ([ID_ПК] = @Original_ID_ПК)) AND ((@IsNull_ID_Мастера = 1 AND [ID_Мастера] IS NULL) OR ([ID_Мастера] = @Original_ID_Мастера)))</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_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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Сборка] ([ID_ПК], [ID_Мастера]) VALUES (@ID_ПК, @ID_Мастера);
SELECT ID_Сборки, ID_ПК, ID_Мастера FROM Сборка 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="Int32" Direction="Input" ParameterName="@ID_Мастера" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Мастера" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Сборки, ID_ПК, ID_Мастера FROM dbo.Сборка</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Сборка] SET [ID_ПК] = @ID_ПК, [ID_Мастера] = @ID_Мастера WHERE (([ID_Сборки] = @Original_ID_Сборки) AND ((@IsNull_ID_ПК = 1 AND [ID_ПК] IS NULL) OR ([ID_ПК] = @Original_ID_ПК)) AND ((@IsNull_ID_Мастера = 1 AND [ID_Мастера] IS NULL) OR ([ID_Мастера] = @Original_ID_Мастера)));
SELECT ID_Сборки, ID_ПК, ID_Мастера FROM Сборка 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="Int32" Direction="Input" ParameterName="@ID_Мастера" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Мастера" 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_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="false" AutogeneratedName="ID_Сборки" ColumnName="ID_Сборки" DataSourceName="KazarinDE_03.dbo.Сборка" 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="ID_Мастера" DataSetColumn="ID_Мастера" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="СотрудникиTableAdapter" GeneratorDataComponentClassName="СотрудникиTableAdapter" Name="Сотрудники" UserDataComponentName="СотрудникиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.Сотрудники" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Сотрудники] WHERE (([ID] = @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 ([Роль] = @Original_Роль) AND ([ДатаРождения] = @Original_ДатаРождения) AND ([Телефон] = @Original_Телефон) AND ([Адрес] = @Original_Адрес) AND ([Username] = @Original_Username) AND ([Password] = @Original_Password))</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" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Роль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ДатаРождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Сотрудники] ([Имя], [Фамилия], [Отчество], [Роль], [ДатаРождения], [Телефон], [Адрес], [Username], [Password]) VALUES (@Имя, @Фамилия, @Отчество, @Роль, @ДатаРождения, @Телефон, @Адрес, @Username, @Password);
SELECT ID, Имя, Фамилия, Отчество, Роль, ДатаРождения, Телефон, Адрес, Username, Password FROM Сотрудники 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="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Роль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ДатаРождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Имя, Фамилия, Отчество, Роль, ДатаРождения, Телефон, Адрес, Username, Password FROM dbo.Сотрудники</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Сотрудники] SET [Имя] = @Имя, [Фамилия] = @Фамилия, [Отчество] = @Отчество, [Роль] = @Роль, [ДатаРождения] = @ДатаРождения, [Телефон] = @Телефон, [Адрес] = @Адрес, [Username] = @Username, [Password] = @Password WHERE (([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 ([Роль] = @Original_Роль) AND ([ДатаРождения] = @Original_ДатаРождения) AND ([Телефон] = @Original_Телефон) AND ([Адрес] = @Original_Адрес) AND ([Username] = @Original_Username) AND ([Password] = @Original_Password));
SELECT ID, Имя, Фамилия, Отчество, Роль, ДатаРождения, Телефон, Адрес, Username, Password FROM Сотрудники 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="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Роль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ДатаРождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" 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" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Роль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Роль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ДатаРождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" 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="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="KazarinDE_03.dbo.Сотрудники" 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="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Роль" DataSetColumn="Роль" />
              <Mapping SourceColumn="ДатаРождения" DataSetColumn="ДатаРождения" />
              <Mapping SourceColumn="Телефон" DataSetColumn="Телефон" />
              <Mapping SourceColumn="Адрес" DataSetColumn="Адрес" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="СтатусыЗаказаTableAdapter" GeneratorDataComponentClassName="СтатусыЗаказаTableAdapter" Name="СтатусыЗаказа" UserDataComponentName="СтатусыЗаказаTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.СтатусыЗаказа" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[СтатусыЗаказа] WHERE (([ID_Статуса] = @Original_ID_Статуса) AND ([Название] = @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="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[СтатусыЗаказа] ([Название]) VALUES (@Название);
SELECT ID_Статуса, Название FROM СтатусыЗаказа WHERE (ID_Статуса = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Статуса, Название FROM dbo.СтатусыЗаказа</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[СтатусыЗаказа] SET [Название] = @Название WHERE (([ID_Статуса] = @Original_ID_Статуса) AND ([Название] = @Original_Название));
SELECT ID_Статуса, Название FROM СтатусыЗаказа WHERE (ID_Статуса = @ID_Статуса)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Статуса" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Статуса" ColumnName="ID_Статуса" DataSourceName="KazarinDE_03.dbo.СтатусыЗаказа" 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="ТипыКомплектующихTableAdapter" GeneratorDataComponentClassName="ТипыКомплектующихTableAdapter" Name="ТипыКомплектующих" UserDataComponentName="ТипыКомплектующихTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinDE_03ConnectionString (Settings)" DbObjectName="KazarinDE_03.dbo.ТипыКомплектующих" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ТипыКомплектующих] WHERE (([ID_Типа] = @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].[ТипыКомплектующих] ([Название]) VALUES (@Название);
SELECT ID_Типа, Название FROM ТипыКомплектующих 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.ТипыКомплектующих</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ТипыКомплектующих] SET [Название] = @Название WHERE (([ID_Типа] = @Original_ID_Типа) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)));
SELECT ID_Типа, Название FROM ТипыКомплектующих 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="KazarinDE_03.dbo.ТипыКомплектующих" 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>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="KazarinDE_03DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="KazarinDE_03DataSet" msprop:Generator_UserDSName="KazarinDE_03DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ЕдиницыИзмерения" msprop:Generator_TableClassName="ЕдиницыИзмеренияDataTable" msprop:Generator_TableVarName="tableЕдиницыИзмерения" msprop:Generator_TablePropName="ЕдиницыИзмерения" msprop:Generator_RowDeletingName="ЕдиницыИзмеренияRowDeleting" msprop:Generator_RowChangingName="ЕдиницыИзмеренияRowChanging" msprop:Generator_RowEvHandlerName="ЕдиницыИзмеренияRowChangeEventHandler" msprop:Generator_RowDeletedName="ЕдиницыИзмеренияRowDeleted" msprop:Generator_UserTableName="ЕдиницыИзмерения" msprop:Generator_RowChangedName="ЕдиницыИзмеренияRowChanged" msprop:Generator_RowEvArgName="ЕдиницыИзмеренияRowChangeEvent" msprop:Generator_RowClassName="ЕдиницыИзмеренияRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_ЕдиницИзмерения" 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="Название" msprop:Generator_ColumnVarNameInTable="columnНазвание" msprop:Generator_ColumnPropNameInRow="Название" msprop:Generator_ColumnPropNameInTable="НазваниеColumn" msprop:Generator_UserColumnName="Название" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Заказы" msprop:Generator_TableClassName="ЗаказыDataTable" msprop:Generator_TableVarName="tableЗаказы" msprop:Generator_TablePropName="Заказы" msprop:Generator_RowDeletingName="ЗаказыRowDeleting" msprop:Generator_RowChangingName="ЗаказыRowChanging" msprop:Generator_RowEvHandlerName="ЗаказыRowChangeEventHandler" msprop:Generator_RowDeletedName="ЗаказыRowDeleted" msprop:Generator_UserTableName="Заказы" msprop:Generator_RowChangedName="ЗаказыRowChanged" msprop:Generator_RowEvArgName="ЗаказыRowChangeEvent" msprop:Generator_RowClassName="ЗаказыRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="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="НомерЗаказа" 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="СтатусЗаказа" 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="Примечание" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_Клиента" 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="ID_Сотрудника" 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="ID_Сборки" msprop:Generator_ColumnVarNameInTable="columnID_Сборки" msprop:Generator_ColumnPropNameInRow="ID_Сборки" msprop:Generator_ColumnPropNameInTable="ID_СборкиColumn" msprop:Generator_UserColumnName="ID_Сборки" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Клиенты" msprop:Generator_TableClassName="КлиентыDataTable" msprop:Generator_TableVarName="tableКлиенты" msprop:Generator_TablePropName="Клиенты" msprop:Generator_RowDeletingName="КлиентыRowDeleting" msprop:Generator_RowChangingName="КлиентыRowChanging" msprop:Generator_RowEvHandlerName="КлиентыRowChangeEventHandler" msprop:Generator_RowDeletedName="КлиентыRowDeleted" msprop:Generator_UserTableName="Клиенты" msprop:Generator_RowChangedName="КлиентыRowChanged" msprop:Generator_RowEvArgName="КлиентыRowChangeEvent" msprop:Generator_RowClassName="КлиентыRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Клиента" 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="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_UserColumnName="Имя">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_UserColumnName="Фамилия">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Отчество" msprop:Generator_ColumnVarNameInTable="columnОтчество" msprop:Generator_ColumnPropNameInRow="Отчество" msprop:Generator_ColumnPropNameInTable="ОтчествоColumn" msprop:Generator_UserColumnName="Отчество" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Телефон" msprop:Generator_ColumnVarNameInTable="columnТелефон" msprop:Generator_ColumnPropNameInRow="Телефон" msprop:Generator_ColumnPropNameInTable="ТелефонColumn" msprop:Generator_UserColumnName="Телефон" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </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="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Комплектующие" msprop:Generator_TableClassName="КомплектующиеDataTable" msprop:Generator_TableVarName="tableКомплектующие" msprop:Generator_TablePropName="Комплектующие" msprop:Generator_RowDeletingName="КомплектующиеRowDeleting" msprop:Generator_RowChangingName="КомплектующиеRowChanging" msprop:Generator_RowEvHandlerName="КомплектующиеRowChangeEventHandler" msprop:Generator_RowDeletedName="КомплектующиеRowDeleted" msprop:Generator_UserTableName="Комплектующие" msprop:Generator_RowChangedName="КомплектующиеRowChanged" msprop:Generator_RowEvArgName="КомплектующиеRowChangeEvent" msprop:Generator_RowClassName="КомплектующиеRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="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="Название" msprop:Generator_ColumnVarNameInTable="columnНазвание" msprop:Generator_ColumnPropNameInRow="Название" msprop:Generator_ColumnPropNameInTable="НазваниеColumn" msprop:Generator_UserColumnName="Название">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Тип" msprop:Generator_ColumnVarNameInTable="columnТип" msprop:Generator_ColumnPropNameInRow="Тип" msprop:Generator_ColumnPropNameInTable="ТипColumn" msprop:Generator_UserColumnName="Тип" type="xs:int" />
              <xs: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: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="Цена" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Компьютеры" msprop:Generator_TableClassName="КомпьютерыDataTable" msprop:Generator_TableVarName="tableКомпьютеры" msprop:Generator_TablePropName="Компьютеры" msprop:Generator_RowDeletingName="КомпьютерыRowDeleting" msprop:Generator_RowChangingName="КомпьютерыRowChanging" msprop:Generator_RowEvHandlerName="КомпьютерыRowChangeEventHandler" msprop:Generator_RowDeletedName="КомпьютерыRowDeleted" msprop:Generator_UserTableName="Компьютеры" msprop:Generator_RowChangedName="КомпьютерыRowChanged" msprop:Generator_RowEvArgName="КомпьютерыRowChangeEvent" msprop:Generator_RowClassName="КомпьютерыRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="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="Модель" 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:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ОписаниеСборки" msprop:Generator_TableClassName="ОписаниеСборкиDataTable" msprop:Generator_TableVarName="tableОписаниеСборки" msprop:Generator_TablePropName="ОписаниеСборки" msprop:Generator_RowDeletingName="ОписаниеСборкиRowDeleting" msprop:Generator_RowChangingName="ОписаниеСборкиRowChanging" msprop:Generator_RowEvHandlerName="ОписаниеСборкиRowChangeEventHandler" msprop:Generator_RowDeletedName="ОписаниеСборкиRowDeleted" msprop:Generator_UserTableName="ОписаниеСборки" msprop:Generator_RowChangedName="ОписаниеСборкиRowChanged" msprop:Generator_RowEvArgName="ОписаниеСборкиRowChangeEvent" msprop:Generator_RowClassName="ОписаниеСборкиRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_ПК" 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="ID_Комплектующего" msprop:Generator_ColumnVarNameInTable="columnID_Комплектующего" msprop:Generator_ColumnPropNameInRow="ID_Комплектующего" msprop:Generator_ColumnPropNameInTable="ID_КомплектующегоColumn" msprop:Generator_UserColumnName="ID_Комплектующего" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Поставщики" msprop:Generator_TableClassName="ПоставщикиDataTable" msprop:Generator_TableVarName="tableПоставщики" msprop:Generator_TablePropName="Поставщики" msprop:Generator_RowDeletingName="ПоставщикиRowDeleting" msprop:Generator_RowChangingName="ПоставщикиRowChanging" msprop:Generator_RowEvHandlerName="ПоставщикиRowChangeEventHandler" msprop:Generator_RowDeletedName="ПоставщикиRowDeleted" msprop:Generator_UserTableName="Поставщики" msprop:Generator_RowChangedName="ПоставщикиRowChanged" msprop:Generator_RowEvArgName="ПоставщикиRowChangeEvent" msprop:Generator_RowClassName="ПоставщикиRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Поставщика" 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="Наименование" msprop:Generator_ColumnVarNameInTable="columnНаименование" msprop:Generator_ColumnPropNameInRow="Наименование" msprop:Generator_ColumnPropNameInTable="НаименованиеColumn" msprop:Generator_UserColumnName="Наименование" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Телефон" msprop:Generator_ColumnVarNameInTable="columnТелефон" msprop:Generator_ColumnPropNameInRow="Телефон" msprop:Generator_ColumnPropNameInTable="ТелефонColumn" msprop:Generator_UserColumnName="Телефон" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Адрес" msprop:Generator_ColumnVarNameInTable="columnАдрес" msprop:Generator_ColumnPropNameInRow="Адрес" msprop:Generator_ColumnPropNameInTable="АдресColumn" msprop:Generator_UserColumnName="Адрес" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Роли" msprop:Generator_TableClassName="РолиDataTable" msprop:Generator_TableVarName="tableРоли" msprop:Generator_TablePropName="Роли" msprop:Generator_RowDeletingName="РолиRowDeleting" msprop:Generator_RowChangingName="РолиRowChanging" msprop:Generator_RowEvHandlerName="РолиRowChangeEventHandler" msprop:Generator_RowDeletedName="РолиRowDeleted" msprop:Generator_UserTableName="Роли" msprop:Generator_RowChangedName="РолиRowChanged" msprop:Generator_RowEvArgName="РолиRowChangeEvent" msprop:Generator_RowClassName="РолиRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Роли" 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="Название" msprop:Generator_ColumnVarNameInTable="columnНазвание" msprop:Generator_ColumnPropNameInRow="Название" msprop:Generator_ColumnPropNameInTable="НазваниеColumn" msprop:Generator_UserColumnName="Название">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Сборка" msprop:Generator_TableClassName="СборкаDataTable" msprop:Generator_TableVarName="tableСборка" msprop:Generator_TablePropName="Сборка" msprop:Generator_RowDeletingName="СборкаRowDeleting" msprop:Generator_RowChangingName="СборкаRowChanging" msprop:Generator_RowEvHandlerName="СборкаRowChangeEventHandler" msprop:Generator_RowDeletedName="СборкаRowDeleted" msprop:Generator_UserTableName="Сборка" msprop:Generator_RowChangedName="СборкаRowChanged" msprop:Generator_RowEvArgName="СборкаRowChangeEvent" msprop:Generator_RowClassName="СборкаRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="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="ID_ПК" 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="ID_Мастера" msprop:Generator_ColumnVarNameInTable="columnID_Мастера" msprop:Generator_ColumnPropNameInRow="ID_Мастера" msprop:Generator_ColumnPropNameInTable="ID_МастераColumn" msprop:Generator_UserColumnName="ID_Мастера" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Сотрудники" msprop:Generator_TableClassName="СотрудникиDataTable" msprop:Generator_TableVarName="tableСотрудники" msprop:Generator_TablePropName="Сотрудники" msprop:Generator_RowDeletingName="СотрудникиRowDeleting" msprop:Generator_RowChangingName="СотрудникиRowChanging" msprop:Generator_RowEvHandlerName="СотрудникиRowChangeEventHandler" msprop:Generator_RowDeletedName="СотрудникиRowDeleted" msprop:Generator_UserTableName="Сотрудники" msprop:Generator_RowChangedName="СотрудникиRowChanged" msprop:Generator_RowEvArgName="СотрудникиRowChangeEvent" msprop:Generator_RowClassName="СотрудникиRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" 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="20" />
                  </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="20" />
                  </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="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Роль" msprop:Generator_ColumnVarNameInTable="columnРоль" msprop:Generator_ColumnPropNameInRow="Роль" msprop:Generator_ColumnPropNameInTable="РольColumn" msprop:Generator_UserColumnName="Роль" type="xs:int" />
              <xs:element name="ДатаРождения" msprop:Generator_ColumnVarNameInTable="columnДатаРождения" msprop:Generator_ColumnPropNameInRow="ДатаРождения" msprop:Generator_ColumnPropNameInTable="ДатаРожденияColumn" msprop:Generator_UserColumnName="ДатаРождения" type="xs:dateTime" />
              <xs:element name="Телефон" msprop:Generator_ColumnVarNameInTable="columnТелефон" msprop:Generator_ColumnPropNameInRow="Телефон" msprop:Generator_ColumnPropNameInTable="ТелефонColumn" msprop:Generator_UserColumnName="Телефон">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Адрес" msprop:Generator_ColumnVarNameInTable="columnАдрес" msprop:Generator_ColumnPropNameInRow="Адрес" msprop:Generator_ColumnPropNameInTable="АдресColumn" msprop:Generator_UserColumnName="Адрес">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_UserColumnName="Username">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </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">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="СтатусыЗаказа" msprop:Generator_TableClassName="СтатусыЗаказаDataTable" msprop:Generator_TableVarName="tableСтатусыЗаказа" msprop:Generator_TablePropName="СтатусыЗаказа" msprop:Generator_RowDeletingName="СтатусыЗаказаRowDeleting" msprop:Generator_RowChangingName="СтатусыЗаказаRowChanging" msprop:Generator_RowEvHandlerName="СтатусыЗаказаRowChangeEventHandler" msprop:Generator_RowDeletedName="СтатусыЗаказаRowDeleted" msprop:Generator_UserTableName="СтатусыЗаказа" msprop:Generator_RowChangedName="СтатусыЗаказаRowChanged" msprop:Generator_RowEvArgName="СтатусыЗаказаRowChangeEvent" msprop:Generator_RowClassName="СтатусыЗаказаRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="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="Название" msprop:Generator_ColumnVarNameInTable="columnНазвание" msprop:Generator_ColumnPropNameInRow="Название" msprop:Generator_ColumnPropNameInTable="НазваниеColumn" msprop:Generator_UserColumnName="Название">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ТипыКомплектующих" msprop:Generator_TableClassName="ТипыКомплектующихDataTable" msprop:Generator_TableVarName="tableТипыКомплектующих" msprop:Generator_TablePropName="ТипыКомплектующих" msprop:Generator_RowDeletingName="ТипыКомплектующихRowDeleting" msprop:Generator_RowChangingName="ТипыКомплектующихRowChanging" msprop:Generator_RowEvHandlerName="ТипыКомплектующихRowChangeEventHandler" msprop:Generator_RowDeletedName="ТипыКомплектующихRowDeleted" msprop:Generator_UserTableName="ТипыКомплектующих" msprop:Generator_RowChangedName="ТипыКомплектующихRowChanged" msprop:Generator_RowEvArgName="ТипыКомплектующихRowChangeEvent" msprop:Generator_RowClassName="ТипыКомплектующихRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Типа" 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="Название" 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:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ЕдиницыИзмерения" />
      <xs:field xpath="mstns:ID_ЕдиницИзмерения" />
    </xs:unique>
    <xs:unique name="Заказы_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Заказы" />
      <xs:field xpath="mstns:ID_Заказа" />
    </xs:unique>
    <xs:unique name="Клиенты_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Клиенты" />
      <xs:field xpath="mstns:ID_Клиента" />
    </xs:unique>
    <xs:unique name="Комплектующие_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Комплектующие" />
      <xs:field xpath="mstns:ID_Комплектующего" />
    </xs:unique>
    <xs:unique name="Компьютеры_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Компьютеры" />
      <xs:field xpath="mstns:ID_ПК" />
    </xs:unique>
    <xs:unique name="Поставщики_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Поставщики" />
      <xs:field xpath="mstns:ID_Поставщика" />
    </xs:unique>
    <xs:unique name="Роли_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Роли" />
      <xs:field xpath="mstns:ID_Роли" />
    </xs:unique>
    <xs:unique name="Сборка_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Сборка" />
      <xs:field xpath="mstns:ID_Сборки" />
    </xs:unique>
    <xs:unique name="Сотрудники_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Сотрудники" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="СтатусыЗаказа_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:СтатусыЗаказа" />
      <xs:field xpath="mstns:ID_Статуса" />
    </xs:unique>
    <xs:unique name="ТипыКомплектующих_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ТипыКомплектующих" />
      <xs:field xpath="mstns:ID_Типа" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Заказы_Клиенты" msdata:parent="Клиенты" msdata:child="Заказы" msdata:parentkey="ID_Клиента" msdata:childkey="ID_Клиента" msprop:Generator_UserChildTable="Заказы" msprop:Generator_ChildPropName="GetЗаказыRows" msprop:Generator_UserRelationName="FK_Заказы_Клиенты" msprop:Generator_RelationVarName="relationFK_Заказы_Клиенты" msprop:Generator_UserParentTable="Клиенты" msprop:Generator_ParentPropName="КлиентыRow" />
      <msdata:Relationship name="FK_Заказы_Сборка" msdata:parent="Сборка" msdata:child="Заказы" msdata:parentkey="ID_Сборки" msdata:childkey="ID_Сборки" msprop:Generator_UserChildTable="Заказы" msprop:Generator_ChildPropName="GetЗаказыRows" msprop:Generator_UserRelationName="FK_Заказы_Сборка" msprop:Generator_RelationVarName="relationFK_Заказы_Сборка" msprop:Generator_UserParentTable="Сборка" msprop:Generator_ParentPropName="СборкаRow" />
      <msdata:Relationship name="FK_Заказы_Сотрудники" msdata:parent="Сотрудники" msdata:child="Заказы" msdata:parentkey="ID" msdata:childkey="ID_Сотрудника" msprop:Generator_UserChildTable="Заказы" msprop:Generator_ChildPropName="GetЗаказыRows" msprop:Generator_UserRelationName="FK_Заказы_Сотрудники" msprop:Generator_RelationVarName="relationFK_Заказы_Сотрудники" msprop:Generator_UserParentTable="Сотрудники" msprop:Generator_ParentPropName="СотрудникиRow" />
      <msdata:Relationship name="FK_Заказы_СтатусыЗаказа" msdata:parent="СтатусыЗаказа" msdata:child="Заказы" msdata:parentkey="ID_Статуса" msdata:childkey="СтатусЗаказа" msprop:Generator_UserChildTable="Заказы" msprop:Generator_ChildPropName="GetЗаказыRows" msprop:Generator_UserRelationName="FK_Заказы_СтатусыЗаказа" msprop:Generator_RelationVarName="relationFK_Заказы_СтатусыЗаказа" msprop:Generator_UserParentTable="СтатусыЗаказа" msprop:Generator_ParentPropName="СтатусыЗаказаRow" />
      <msdata:Relationship name="FK_Комплектующие_ЕдиницыИзмерения" msdata:parent="ЕдиницыИзмерения" msdata:child="Комплектующие" msdata:parentkey="ID_ЕдиницИзмерения" msdata:childkey="ЕдиницыИзмерения" msprop:Generator_UserChildTable="Комплектующие" msprop:Generator_ChildPropName="GetКомплектующиеRows" msprop:Generator_UserRelationName="FK_Комплектующие_ЕдиницыИзмерения" msprop:Generator_ParentPropName="ЕдиницыИзмеренияRow" msprop:Generator_RelationVarName="relationFK_Комплектующие_ЕдиницыИзмерения" msprop:Generator_UserParentTable="ЕдиницыИзмерения" />
      <msdata:Relationship name="FK_Комплектующие_Поставщики" msdata:parent="Поставщики" msdata:child="Комплектующие" msdata:parentkey="ID_Поставщика" msdata:childkey="Поставщик" msprop:Generator_UserChildTable="Комплектующие" msprop:Generator_ChildPropName="GetКомплектующиеRows" msprop:Generator_UserRelationName="FK_Комплектующие_Поставщики" msprop:Generator_RelationVarName="relationFK_Комплектующие_Поставщики" msprop:Generator_UserParentTable="Поставщики" msprop:Generator_ParentPropName="ПоставщикиRow" />
      <msdata:Relationship name="FK_Комплектующие_ТипыКомплектующих" msdata:parent="ТипыКомплектующих" msdata:child="Комплектующие" msdata:parentkey="ID_Типа" msdata:childkey="Тип" msprop:Generator_UserChildTable="Комплектующие" msprop:Generator_ChildPropName="GetКомплектующиеRows" msprop:Generator_UserRelationName="FK_Комплектующие_ТипыКомплектующих" msprop:Generator_RelationVarName="relationFK_Комплектующие_ТипыКомплектующих" msprop:Generator_UserParentTable="ТипыКомплектующих" msprop:Generator_ParentPropName="ТипыКомплектующихRow" />
      <msdata:Relationship name="FK_ОписаниеСборки_Комплектующие" msdata:parent="Комплектующие" msdata:child="ОписаниеСборки" msdata:parentkey="ID_Комплектующего" msdata:childkey="ID_Комплектующего" msprop:Generator_UserChildTable="ОписаниеСборки" msprop:Generator_ChildPropName="GetОписаниеСборкиRows" msprop:Generator_UserRelationName="FK_ОписаниеСборки_Комплектующие" msprop:Generator_ParentPropName="КомплектующиеRow" msprop:Generator_RelationVarName="relationFK_ОписаниеСборки_Комплектующие" msprop:Generator_UserParentTable="Комплектующие" />
      <msdata:Relationship name="FK_ОписаниеСборки_Компьютеры" msdata:parent="Компьютеры" msdata:child="ОписаниеСборки" msdata:parentkey="ID_ПК" msdata:childkey="ID_ПК" msprop:Generator_UserChildTable="ОписаниеСборки" msprop:Generator_ChildPropName="GetОписаниеСборкиRows" msprop:Generator_UserRelationName="FK_ОписаниеСборки_Компьютеры" msprop:Generator_ParentPropName="КомпьютерыRow" msprop:Generator_RelationVarName="relationFK_ОписаниеСборки_Компьютеры" msprop:Generator_UserParentTable="Компьютеры" />
      <msdata:Relationship name="FK_Сборка_Компьютеры" msdata:parent="Компьютеры" msdata:child="Сборка" msdata:parentkey="ID_ПК" msdata:childkey="ID_ПК" msprop:Generator_UserChildTable="Сборка" msprop:Generator_ChildPropName="GetСборкаRows" msprop:Generator_UserRelationName="FK_Сборка_Компьютеры" msprop:Generator_ParentPropName="КомпьютерыRow" msprop:Generator_RelationVarName="relationFK_Сборка_Компьютеры" msprop:Generator_UserParentTable="Компьютеры" />
      <msdata:Relationship name="FK_Сборка_Сотрудники" msdata:parent="Сотрудники" msdata:child="Сборка" msdata:parentkey="ID" msdata:childkey="ID_Мастера" msprop:Generator_UserChildTable="Сборка" msprop:Generator_ChildPropName="GetСборкаRows" msprop:Generator_UserRelationName="FK_Сборка_Сотрудники" msprop:Generator_RelationVarName="relationFK_Сборка_Сотрудники" msprop:Generator_UserParentTable="Сотрудники" msprop:Generator_ParentPropName="СотрудникиRow" />
      <msdata:Relationship name="FK_Сотрудники_Роли" msdata:parent="Роли" msdata:child="Сотрудники" msdata:parentkey="ID_Роли" msdata:childkey="Роль" msprop:Generator_UserChildTable="Сотрудники" msprop:Generator_ChildPropName="GetСотрудникиRows" msprop:Generator_UserRelationName="FK_Сотрудники_Роли" msprop:Generator_ParentPropName="РолиRow" msprop:Generator_RelationVarName="relationFK_Сотрудники_Роли" msprop:Generator_UserParentTable="Роли" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>