Demo/MarketDataSet.xsd - master - DaNN26/sql-utility-manager

Demo/MarketDataSet.xsd
845 строк125 KB
DaNN
Добавьте файлы проекта.
25 май 2026, 17:03
25 май 2026, 17:039efb65a
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="MarketDataSet" targetNamespace="http://tempuri.org/MarketDataSet.xsd" xmlns:mstns="http://tempuri.org/MarketDataSet.xsd" xmlns="http://tempuri.org/MarketDataSet.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="MarketConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MarketConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Demo.Properties.Settings.GlobalReference.Default.MarketConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="categoryTableAdapter" GeneratorDataComponentClassName="categoryTableAdapter" Name="category" UserDataComponentName="categoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketConnectionString (Settings)" DbObjectName="Market.dbo.category" 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].[category] WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)))</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_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[category] ([id], [title]) VALUES (@id, @title);
SELECT id, title FROM category WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, title FROM dbo.category</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[category] SET [id] = @id, [title] = @title WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)));
SELECT id, title FROM category WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" 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_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="orderTableAdapter" GeneratorDataComponentClassName="orderTableAdapter" Name="order" UserDataComponentName="orderTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketConnectionString (Settings)" DbObjectName="Market.dbo.[order]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[order] WHERE (([Номер_заказа] = @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 ([id_пользователя] = @Original_id_пользователя) AND ((@IsNull_Код_для_получения = 1 AND [Код_для_получения] IS NULL) OR ([Код_для_получения] = @Original_Код_для_получения)) AND ((@IsNull_Статус_заказа = 1 AND [Статус_заказа] IS NULL) OR ([Статус_заказа] = @Original_Статус_заказа)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Артикул_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Артикул_заказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_заказа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_заказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Дата_заказа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_доставки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_доставки" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_доставки" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_доставки" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="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="" 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="Int16" Direction="Input" ParameterName="@Original_Код_для_получения" Precision="0" ProviderType="SmallInt" 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].[order] ([Артикул_заказа], [Дата_заказа], [Дата_доставки], [id_пункта_выдачи], [id_пользователя], [Код_для_получения], [Статус_заказа]) VALUES (@Артикул_заказа, @Дата_заказа, @Дата_доставки, @id_пункта_выдачи, @id_пользователя, @Код_для_получения, @Статус_заказа);
SELECT Номер_заказа, Артикул_заказа, Дата_заказа, Дата_доставки, id_пункта_выдачи, id_пользователя, Код_для_получения, Статус_заказа FROM [order] WHERE (Номер_заказа = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_заказа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Дата_заказа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_доставки" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_доставки" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_пункта_выдачи" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_пункта_выдачи" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_пользователя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_пользователя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Код_для_получения" Precision="0" ProviderType="SmallInt" 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_пункта_выдачи, id_пользователя, Код_для_получения, Статус_заказа FROM dbo.[order]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[order] SET [Артикул_заказа] = @Артикул_заказа, [Дата_заказа] = @Дата_заказа, [Дата_доставки] = @Дата_доставки, [id_пункта_выдачи] = @id_пункта_выдачи, [id_пользователя] = @id_пользователя, [Код_для_получения] = @Код_для_получения, [Статус_заказа] = @Статус_заказа WHERE (([Номер_заказа] = @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 ([id_пользователя] = @Original_id_пользователя) AND ((@IsNull_Код_для_получения = 1 AND [Код_для_получения] IS NULL) OR ([Код_для_получения] = @Original_Код_для_получения)) AND ((@IsNull_Статус_заказа = 1 AND [Статус_заказа] IS NULL) OR ([Статус_заказа] = @Original_Статус_заказа)));
SELECT Номер_заказа, Артикул_заказа, Дата_заказа, Дата_доставки, id_пункта_выдачи, id_пользователя, Код_для_получения, Статус_заказа FROM [order] WHERE (Номер_заказа = @Номер_заказа)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул_заказа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Дата_заказа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_доставки" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_доставки" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_пункта_выдачи" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_пункта_выдачи" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_пользователя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_пользователя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Код_для_получения" Precision="0" ProviderType="SmallInt" 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_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Артикул_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Артикул_заказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул_заказа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_заказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Дата_заказа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_доставки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_доставки" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_доставки" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_доставки" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="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="" 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="Int16" Direction="Input" ParameterName="@Original_Код_для_получения" Precision="0" ProviderType="SmallInt" 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="Номер_заказа" ColumnName="Номер_заказа" DataSourceName="Market.dbo.[order]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Номер_заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Номер_заказа" DataSetColumn="Номер_заказа" />
              <Mapping SourceColumn="Артикул_заказа" DataSetColumn="Артикул_заказа" />
              <Mapping SourceColumn="Дата_заказа" DataSetColumn="Дата_заказа" />
              <Mapping SourceColumn="Дата_доставки" DataSetColumn="Дата_доставки" />
              <Mapping SourceColumn="id_пункта_выдачи" DataSetColumn="id_пункта_выдачи" />
              <Mapping SourceColumn="id_пользователя" DataSetColumn="id_пользователя" />
              <Mapping SourceColumn="Код_для_получения" DataSetColumn="Код_для_получения" />
              <Mapping SourceColumn="Статус_заказа" DataSetColumn="Статус_заказа" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="pickup_pointTableAdapter" GeneratorDataComponentClassName="pickup_pointTableAdapter" Name="pickup_point" UserDataComponentName="pickup_pointTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketConnectionString (Settings)" DbObjectName="Market.dbo.pickup_point" 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].[pickup_point] WHERE (([id] = @Original_id) AND ([index] = @Original_index) AND ([city] = @Original_city) AND ([street] = @Original_street) AND ((@IsNull_house = 1 AND [house] IS NULL) OR ([house] = @Original_house)))</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="Int32" Direction="Input" ParameterName="@Original_index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="street" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_house" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="house" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_house" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="house" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[pickup_point] ([index], [city], [street], [house]) VALUES (@index, @city, @street, @house);
SELECT id, [index], city, street, house FROM pickup_point WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@city" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@house" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="house" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, [index], city, street, house FROM dbo.pickup_point</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[pickup_point] SET [index] = @index, [city] = @city, [street] = @street, [house] = @house WHERE (([id] = @Original_id) AND ([index] = @Original_index) AND ([city] = @Original_city) AND ([street] = @Original_street) AND ((@IsNull_house = 1 AND [house] IS NULL) OR ([house] = @Original_house)));
SELECT id, [index], city, street, house FROM pickup_point WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@city" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@house" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="house" 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="Int32" Direction="Input" ParameterName="@Original_index" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="index" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="street" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_house" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="house" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_house" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="house" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="Market.dbo.pickup_point" 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="index" DataSetColumn="index" />
              <Mapping SourceColumn="city" DataSetColumn="city" />
              <Mapping SourceColumn="street" DataSetColumn="street" />
              <Mapping SourceColumn="house" DataSetColumn="house" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="producerTableAdapter" GeneratorDataComponentClassName="producerTableAdapter" Name="producer" UserDataComponentName="producerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketConnectionString (Settings)" DbObjectName="Market.dbo.producer" 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].[producer] WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)))</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_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[producer] ([id], [title]) VALUES (@id, @title);
SELECT id, title FROM producer WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, title FROM dbo.producer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[producer] SET [id] = @id, [title] = @title WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)));
SELECT id, title FROM producer WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" 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_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="productTableAdapter" GeneratorDataComponentClassName="productTableAdapter" Name="product" UserDataComponentName="productTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketConnectionString (Settings)" DbObjectName="Market.dbo.product" 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].[product] WHERE (([Артикул] = @Original_Артикул) AND ((@IsNull_Наименование_товара = 1 AND [Наименование_товара] IS NULL) OR ([Наименование_товара] = @Original_Наименование_товара)) AND ((@IsNull_Единица_измерения = 1 AND [Единица_измерения] IS NULL) OR ([Единица_измерения] = @Original_Единица_измерения)) AND ((@IsNull_Цена = 1 AND [Цена] IS NULL) OR ([Цена] = @Original_Цена)) AND ((@IsNull_Поставщик = 1 AND [Поставщик] IS NULL) OR ([Поставщик] = @Original_Поставщик)) AND ((@IsNull_Производитель = 1 AND [Производитель] IS NULL) OR ([Производитель] = @Original_Производитель)) AND ((@IsNull_Категория_товара = 1 AND [Категория_товара] IS NULL) OR ([Категория_товара] = @Original_Категория_товара)) AND ((@IsNull_Действующая_скидка = 1 AND [Действующая_скидка] IS NULL) OR ([Действующая_скидка] = @Original_Действующая_скидка)) AND ((@IsNull_Кол_во_на_складе = 1 AND [Кол_во_на_складе] IS NULL) OR ([Кол_во_на_складе] = @Original_Кол_во_на_складе)) AND ((@IsNull_Описание_товара = 1 AND [Описание_товара] IS NULL) OR ([Описание_товара] = @Original_Описание_товара)) AND ((@IsNull_Фото = 1 AND [Фото] IS NULL) OR ([Фото] = @Original_Фото)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Наименование_товара" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Наименование_товара" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование_товара" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование_товара" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Единица_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Единица_измерения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Единица_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Единица_измерения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Цена" Precision="18" ProviderType="Decimal" 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="Byte" Direction="Input" ParameterName="@Original_Действующая_скидка" Precision="0" ProviderType="TinyInt" 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="Byte" Direction="Input" ParameterName="@Original_Кол_во_на_складе" Precision="0" ProviderType="TinyInt" 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].[product] ([Артикул], [Наименование_товара], [Единица_измерения], [Цена], [Поставщик], [Производитель], [Категория_товара], [Действующая_скидка], [Кол_во_на_складе], [Описание_товара], [Фото]) VALUES (@Артикул, @Наименование_товара, @Единица_измерения, @Цена, @Поставщик, @Производитель, @Категория_товара, @Действующая_скидка, @Кол_во_на_складе, @Описание_товара, @Фото);
SELECT Артикул, Наименование_товара, Единица_измерения, Цена, Поставщик, Производитель, Категория_товара, Действующая_скидка, Кол_во_на_складе, Описание_товара, Фото FROM product WHERE (Артикул = @Артикул)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование_товара" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование_товара" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Единица_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Единица_измерения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Цена" Precision="18" ProviderType="Decimal" 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="Byte" Direction="Input" ParameterName="@Действующая_скидка" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Действующая_скидка" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Кол_во_на_складе" Precision="0" ProviderType="TinyInt" 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 Артикул, Наименование_товара, Единица_измерения, Цена, Поставщик, Производитель, Категория_товара, Действующая_скидка, Кол_во_на_складе, Описание_товара, Фото FROM dbo.product</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[product] SET [Артикул] = @Артикул, [Наименование_товара] = @Наименование_товара, [Единица_измерения] = @Единица_измерения, [Цена] = @Цена, [Поставщик] = @Поставщик, [Производитель] = @Производитель, [Категория_товара] = @Категория_товара, [Действующая_скидка] = @Действующая_скидка, [Кол_во_на_складе] = @Кол_во_на_складе, [Описание_товара] = @Описание_товара, [Фото] = @Фото WHERE (([Артикул] = @Original_Артикул) AND ((@IsNull_Наименование_товара = 1 AND [Наименование_товара] IS NULL) OR ([Наименование_товара] = @Original_Наименование_товара)) AND ((@IsNull_Единица_измерения = 1 AND [Единица_измерения] IS NULL) OR ([Единица_измерения] = @Original_Единица_измерения)) AND ((@IsNull_Цена = 1 AND [Цена] IS NULL) OR ([Цена] = @Original_Цена)) AND ((@IsNull_Поставщик = 1 AND [Поставщик] IS NULL) OR ([Поставщик] = @Original_Поставщик)) AND ((@IsNull_Производитель = 1 AND [Производитель] IS NULL) OR ([Производитель] = @Original_Производитель)) AND ((@IsNull_Категория_товара = 1 AND [Категория_товара] IS NULL) OR ([Категория_товара] = @Original_Категория_товара)) AND ((@IsNull_Действующая_скидка = 1 AND [Действующая_скидка] IS NULL) OR ([Действующая_скидка] = @Original_Действующая_скидка)) AND ((@IsNull_Кол_во_на_складе = 1 AND [Кол_во_на_складе] IS NULL) OR ([Кол_во_на_складе] = @Original_Кол_во_на_складе)) AND ((@IsNull_Описание_товара = 1 AND [Описание_товара] IS NULL) OR ([Описание_товара] = @Original_Описание_товара)) AND ((@IsNull_Фото = 1 AND [Фото] IS NULL) OR ([Фото] = @Original_Фото)));
SELECT Артикул, Наименование_товара, Единица_измерения, Цена, Поставщик, Производитель, Категория_товара, Действующая_скидка, Кол_во_на_складе, Описание_товара, Фото FROM product WHERE (Артикул = @Артикул)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование_товара" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование_товара" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Единица_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Единица_измерения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Цена" Precision="18" ProviderType="Decimal" 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="Byte" Direction="Input" ParameterName="@Действующая_скидка" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Действующая_скидка" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Кол_во_на_складе" Precision="0" ProviderType="TinyInt" 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="String" Direction="Input" ParameterName="@Original_Артикул" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Артикул" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Наименование_товара" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Наименование_товара" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование_товара" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование_товара" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Единица_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Единица_измерения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Единица_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Единица_измерения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="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="Decimal" Direction="Input" ParameterName="@Original_Цена" Precision="18" ProviderType="Decimal" 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="Byte" Direction="Input" ParameterName="@Original_Действующая_скидка" Precision="0" ProviderType="TinyInt" 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="Byte" Direction="Input" ParameterName="@Original_Кол_во_на_складе" Precision="0" ProviderType="TinyInt" 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>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Артикул" DataSetColumn="Артикул" />
              <Mapping SourceColumn="Наименование_товара" DataSetColumn="Наименование_товара" />
              <Mapping SourceColumn="Единица_измерения" DataSetColumn="Единица_измерения" />
              <Mapping SourceColumn="Цена" DataSetColumn="Цена" />
              <Mapping SourceColumn="Поставщик" DataSetColumn="Поставщик" />
              <Mapping SourceColumn="Производитель" DataSetColumn="Производитель" />
              <Mapping SourceColumn="Категория_товара" DataSetColumn="Категория_товара" />
              <Mapping SourceColumn="Действующая_скидка" DataSetColumn="Действующая_скидка" />
              <Mapping SourceColumn="Кол_во_на_складе" DataSetColumn="Кол_во_на_складе" />
              <Mapping SourceColumn="Описание_товара" DataSetColumn="Описание_товара" />
              <Mapping SourceColumn="Фото" DataSetColumn="Фото" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="roleTableAdapter" GeneratorDataComponentClassName="roleTableAdapter" Name="role" UserDataComponentName="roleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketConnectionString (Settings)" DbObjectName="Market.dbo.role" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[role] WHERE (([id] = @Original_id) AND ([title] = @Original_title))</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_title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[role] ([id], [title]) VALUES (@id, @title);
SELECT id, title FROM role WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, title FROM dbo.role</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[role] SET [id] = @id, [title] = @title WHERE (([id] = @Original_id) AND ([title] = @Original_title));
SELECT id, title FROM role WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" 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_title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="supplierTableAdapter" GeneratorDataComponentClassName="supplierTableAdapter" Name="supplier" UserDataComponentName="supplierTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketConnectionString (Settings)" DbObjectName="Market.dbo.supplier" 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].[supplier] WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)))</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_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[supplier] ([id], [title]) VALUES (@id, @title);
SELECT id, title FROM supplier WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, title FROM dbo.supplier</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[supplier] SET [id] = @id, [title] = @title WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)));
SELECT id, title FROM supplier WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" 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_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="unitTableAdapter" GeneratorDataComponentClassName="unitTableAdapter" Name="unit" UserDataComponentName="unitTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketConnectionString (Settings)" DbObjectName="Market.dbo.unit" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[unit] WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)))</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_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[unit] ([id], [title]) VALUES (@id, @title);
SELECT id, title FROM unit WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, title FROM dbo.unit</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[unit] SET [id] = @id, [title] = @title WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)));
SELECT id, title FROM unit WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" 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_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="userTableAdapter" GeneratorDataComponentClassName="userTableAdapter" Name="user" UserDataComponentName="userTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MarketConnectionString (Settings)" DbObjectName="Market.dbo.[user]" 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].[user] WHERE (([id] = @Original_id) AND ([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="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].[user] ([id_роли], [ФИО], [Логин], [Пароль]) VALUES (@id_роли, @ФИО, @Логин, @Пароль);
SELECT id, id_роли, ФИО, Логин, Пароль FROM [user] WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_роли" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_роли" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ФИО" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ФИО" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="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, id_роли, ФИО, Логин, Пароль FROM dbo.[user]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[user] SET [id_роли] = @id_роли, [ФИО] = @ФИО, [Логин] = @Логин, [Пароль] = @Пароль WHERE (([id] = @Original_id) AND ([id_роли] = @Original_id_роли) AND ((@IsNull_ФИО = 1 AND [ФИО] IS NULL) OR ([ФИО] = @Original_ФИО)) AND ((@IsNull_Логин = 1 AND [Логин] IS NULL) OR ([Логин] = @Original_Логин)) AND ((@IsNull_Пароль = 1 AND [Пароль] IS NULL) OR ([Пароль] = @Original_Пароль)));
SELECT id, id_роли, ФИО, Логин, Пароль FROM [user] WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_роли" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_роли" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ФИО" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ФИО" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="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="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="Market.dbo.[user]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="id_роли" DataSetColumn="id_роли" />
              <Mapping SourceColumn="ФИО" DataSetColumn="ФИО" />
              <Mapping SourceColumn="Логин" DataSetColumn="Логин" />
              <Mapping SourceColumn="Пароль" DataSetColumn="Пароль" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="MarketDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="MarketDataSet" msprop:Generator_DataSetName="MarketDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="category" msprop:Generator_RowEvHandlerName="categoryRowChangeEventHandler" msprop:Generator_RowDeletedName="categoryRowDeleted" msprop:Generator_RowDeletingName="categoryRowDeleting" msprop:Generator_RowEvArgName="categoryRowChangeEvent" msprop:Generator_TablePropName="category" msprop:Generator_RowChangedName="categoryRowChanged" msprop:Generator_RowChangingName="categoryRowChanging" msprop:Generator_TableClassName="categoryDataTable" msprop:Generator_RowClassName="categoryRow" msprop:Generator_TableVarName="tablecategory" msprop:Generator_UserTableName="category">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="title" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_UserColumnName="title" 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="order" msprop:Generator_RowEvHandlerName="orderRowChangeEventHandler" msprop:Generator_RowDeletedName="orderRowDeleted" msprop:Generator_RowDeletingName="orderRowDeleting" msprop:Generator_RowEvArgName="orderRowChangeEvent" msprop:Generator_TablePropName="order" msprop:Generator_RowChangedName="orderRowChanged" msprop:Generator_RowChangingName="orderRowChanging" msprop:Generator_TableClassName="orderDataTable" msprop:Generator_RowClassName="orderRow" msprop:Generator_TableVarName="tableorder" msprop:Generator_UserTableName="order">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Номер_заказа" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="Номер_заказа" msprop:Generator_ColumnPropNameInTable="Номер_заказаColumn" msprop:Generator_ColumnVarNameInTable="columnНомер_заказа" msprop:Generator_UserColumnName="Номер_заказа" type="xs:int" />
              <xs:element name="Артикул_заказа" msprop:Generator_ColumnPropNameInRow="Артикул_заказа" msprop:Generator_ColumnPropNameInTable="Артикул_заказаColumn" msprop:Generator_ColumnVarNameInTable="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_ColumnPropNameInRow="Дата_заказа" msprop:Generator_ColumnPropNameInTable="Дата_заказаColumn" msprop:Generator_ColumnVarNameInTable="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_ColumnPropNameInRow="Дата_доставки" msprop:Generator_ColumnPropNameInTable="Дата_доставкиColumn" msprop:Generator_ColumnVarNameInTable="columnДата_доставки" msprop:Generator_UserColumnName="Дата_доставки" type="xs:dateTime" minOccurs="0" />
              <xs:element name="id_пункта_выдачи" msprop:Generator_ColumnPropNameInRow="id_пункта_выдачи" msprop:Generator_ColumnPropNameInTable="id_пункта_выдачиColumn" msprop:Generator_ColumnVarNameInTable="columnid_пункта_выдачи" msprop:Generator_UserColumnName="id_пункта_выдачи" type="xs:int" minOccurs="0" />
              <xs:element name="id_пользователя" msprop:Generator_ColumnPropNameInRow="id_пользователя" msprop:Generator_ColumnPropNameInTable="id_пользователяColumn" msprop:Generator_ColumnVarNameInTable="columnid_пользователя" msprop:Generator_UserColumnName="id_пользователя" type="xs:int" />
              <xs:element name="Код_для_получения" msprop:Generator_ColumnPropNameInRow="Код_для_получения" msprop:Generator_ColumnPropNameInTable="Код_для_полученияColumn" msprop:Generator_ColumnVarNameInTable="columnКод_для_получения" msprop:Generator_UserColumnName="Код_для_получения" type="xs:short" minOccurs="0" />
              <xs:element name="Статус_заказа" msprop:Generator_ColumnPropNameInRow="Статус_заказа" msprop:Generator_ColumnPropNameInTable="Статус_заказаColumn" msprop:Generator_ColumnVarNameInTable="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="pickup_point" msprop:Generator_RowEvHandlerName="pickup_pointRowChangeEventHandler" msprop:Generator_RowDeletedName="pickup_pointRowDeleted" msprop:Generator_RowDeletingName="pickup_pointRowDeleting" msprop:Generator_RowEvArgName="pickup_pointRowChangeEvent" msprop:Generator_TablePropName="pickup_point" msprop:Generator_RowChangedName="pickup_pointRowChanged" msprop:Generator_RowChangingName="pickup_pointRowChanging" msprop:Generator_TableClassName="pickup_pointDataTable" msprop:Generator_RowClassName="pickup_pointRow" msprop:Generator_TableVarName="tablepickup_point" msprop:Generator_UserTableName="pickup_point">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="index" msprop:Generator_ColumnPropNameInRow="index" msprop:Generator_ColumnPropNameInTable="indexColumn" msprop:Generator_ColumnVarNameInTable="columnindex" msprop:Generator_UserColumnName="index" type="xs:int" />
              <xs:element name="city" msprop:Generator_ColumnPropNameInRow="city" msprop:Generator_ColumnPropNameInTable="cityColumn" msprop:Generator_ColumnVarNameInTable="columncity" msprop:Generator_UserColumnName="city">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="street" msprop:Generator_ColumnPropNameInRow="street" msprop:Generator_ColumnPropNameInTable="streetColumn" msprop:Generator_ColumnVarNameInTable="columnstreet" msprop:Generator_UserColumnName="street">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="house" msprop:Generator_ColumnPropNameInRow="house" msprop:Generator_ColumnPropNameInTable="houseColumn" msprop:Generator_ColumnVarNameInTable="columnhouse" msprop:Generator_UserColumnName="house" type="xs:unsignedByte" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="producer" msprop:Generator_RowEvHandlerName="producerRowChangeEventHandler" msprop:Generator_RowDeletedName="producerRowDeleted" msprop:Generator_RowDeletingName="producerRowDeleting" msprop:Generator_RowEvArgName="producerRowChangeEvent" msprop:Generator_TablePropName="producer" msprop:Generator_RowChangedName="producerRowChanged" msprop:Generator_RowChangingName="producerRowChanging" msprop:Generator_TableClassName="producerDataTable" msprop:Generator_RowClassName="producerRow" msprop:Generator_TableVarName="tableproducer" msprop:Generator_UserTableName="producer">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="title" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_UserColumnName="title" 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="product" msprop:Generator_RowEvHandlerName="productRowChangeEventHandler" msprop:Generator_RowDeletedName="productRowDeleted" msprop:Generator_RowDeletingName="productRowDeleting" msprop:Generator_RowEvArgName="productRowChangeEvent" msprop:Generator_TablePropName="product" msprop:Generator_RowChangedName="productRowChanged" msprop:Generator_RowChangingName="productRowChanging" msprop:Generator_TableClassName="productDataTable" msprop:Generator_RowClassName="productRow" msprop:Generator_TableVarName="tableproduct" msprop:Generator_UserTableName="product">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Артикул" msprop:Generator_ColumnPropNameInRow="Артикул" msprop:Generator_ColumnPropNameInTable="АртикулColumn" msprop:Generator_ColumnVarNameInTable="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_ColumnPropNameInRow="Наименование_товара" msprop:Generator_ColumnPropNameInTable="Наименование_товараColumn" msprop:Generator_ColumnVarNameInTable="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_ColumnPropNameInRow="Единица_измерения" msprop:Generator_ColumnPropNameInTable="Единица_измеренияColumn" msprop:Generator_ColumnVarNameInTable="columnЕдиница_измерения" msprop:Generator_UserColumnName="Единица_измерения" type="xs:int" minOccurs="0" />
              <xs:element name="Цена" msprop:Generator_ColumnPropNameInRow="Цена" msprop:Generator_ColumnPropNameInTable="ЦенаColumn" msprop:Generator_ColumnVarNameInTable="columnЦена" msprop:Generator_UserColumnName="Цена" type="xs:decimal" minOccurs="0" />
              <xs:element name="Поставщик" msprop:Generator_ColumnPropNameInRow="Поставщик" msprop:Generator_ColumnPropNameInTable="ПоставщикColumn" msprop:Generator_ColumnVarNameInTable="columnПоставщик" msprop:Generator_UserColumnName="Поставщик" type="xs:int" minOccurs="0" />
              <xs:element name="Производитель" msprop:Generator_ColumnPropNameInRow="Производитель" msprop:Generator_ColumnPropNameInTable="ПроизводительColumn" msprop:Generator_ColumnVarNameInTable="columnПроизводитель" msprop:Generator_UserColumnName="Производитель" type="xs:int" minOccurs="0" />
              <xs:element name="Категория_товара" msprop:Generator_ColumnPropNameInRow="Категория_товара" msprop:Generator_ColumnPropNameInTable="Категория_товараColumn" msprop:Generator_ColumnVarNameInTable="columnКатегория_товара" msprop:Generator_UserColumnName="Категория_товара" type="xs:int" minOccurs="0" />
              <xs:element name="Действующая_скидка" msprop:Generator_ColumnPropNameInRow="Действующая_скидка" msprop:Generator_ColumnPropNameInTable="Действующая_скидкаColumn" msprop:Generator_ColumnVarNameInTable="columnДействующая_скидка" msprop:Generator_UserColumnName="Действующая_скидка" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Кол_во_на_складе" msprop:Generator_ColumnPropNameInRow="Кол_во_на_складе" msprop:Generator_ColumnPropNameInTable="Кол_во_на_складеColumn" msprop:Generator_ColumnVarNameInTable="columnКол_во_на_складе" msprop:Generator_UserColumnName="Кол_во_на_складе" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Описание_товара" msprop:Generator_ColumnPropNameInRow="Описание_товара" msprop:Generator_ColumnPropNameInTable="Описание_товараColumn" msprop:Generator_ColumnVarNameInTable="columnОписание_товара" msprop:Generator_UserColumnName="Описание_товара" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Фото" msprop:Generator_ColumnPropNameInRow="Фото" msprop:Generator_ColumnPropNameInTable="ФотоColumn" msprop:Generator_ColumnVarNameInTable="columnФото" msprop:Generator_UserColumnName="Фото" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="role" msprop:Generator_RowEvHandlerName="roleRowChangeEventHandler" msprop:Generator_RowDeletedName="roleRowDeleted" msprop:Generator_RowDeletingName="roleRowDeleting" msprop:Generator_RowEvArgName="roleRowChangeEvent" msprop:Generator_TablePropName="role" msprop:Generator_RowChangedName="roleRowChanged" msprop:Generator_RowChangingName="roleRowChanging" msprop:Generator_TableClassName="roleDataTable" msprop:Generator_RowClassName="roleRow" msprop:Generator_TableVarName="tablerole" msprop:Generator_UserTableName="role">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="title" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_UserColumnName="title">
                <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="supplier" msprop:Generator_RowEvHandlerName="supplierRowChangeEventHandler" msprop:Generator_RowDeletedName="supplierRowDeleted" msprop:Generator_RowDeletingName="supplierRowDeleting" msprop:Generator_RowEvArgName="supplierRowChangeEvent" msprop:Generator_TablePropName="supplier" msprop:Generator_RowChangedName="supplierRowChanged" msprop:Generator_RowChangingName="supplierRowChanging" msprop:Generator_TableClassName="supplierDataTable" msprop:Generator_RowClassName="supplierRow" msprop:Generator_TableVarName="tablesupplier" msprop:Generator_UserTableName="supplier">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="title" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_UserColumnName="title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="unit" msprop:Generator_RowEvHandlerName="unitRowChangeEventHandler" msprop:Generator_RowDeletedName="unitRowDeleted" msprop:Generator_RowDeletingName="unitRowDeleting" msprop:Generator_RowEvArgName="unitRowChangeEvent" msprop:Generator_TablePropName="unit" msprop:Generator_RowChangedName="unitRowChanged" msprop:Generator_RowChangingName="unitRowChanging" msprop:Generator_TableClassName="unitDataTable" msprop:Generator_RowClassName="unitRow" msprop:Generator_TableVarName="tableunit" msprop:Generator_UserTableName="unit">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="title" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_UserColumnName="title" 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="user" msprop:Generator_RowEvHandlerName="userRowChangeEventHandler" msprop:Generator_RowDeletedName="userRowDeleted" msprop:Generator_RowDeletingName="userRowDeleting" msprop:Generator_RowEvArgName="userRowChangeEvent" msprop:Generator_TablePropName="user" msprop:Generator_RowChangedName="userRowChanged" msprop:Generator_RowChangingName="userRowChanging" msprop:Generator_TableClassName="userDataTable" msprop:Generator_RowClassName="userRow" msprop:Generator_TableVarName="tableuser" msprop:Generator_UserTableName="user">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="id_роли" msprop:Generator_ColumnPropNameInRow="id_роли" msprop:Generator_ColumnPropNameInTable="id_ролиColumn" msprop:Generator_ColumnVarNameInTable="columnid_роли" msprop:Generator_UserColumnName="id_роли" type="xs:int" />
              <xs:element name="ФИО" msprop:Generator_ColumnPropNameInRow="ФИО" msprop:Generator_ColumnPropNameInTable="ФИОColumn" msprop:Generator_ColumnVarNameInTable="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_ColumnPropNameInRow="Логин" msprop:Generator_ColumnPropNameInTable="ЛогинColumn" msprop:Generator_ColumnVarNameInTable="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_ColumnPropNameInRow="Пароль" msprop:Generator_ColumnPropNameInTable="ПарольColumn" msprop:Generator_ColumnVarNameInTable="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:category" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="order_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:order" />
      <xs:field xpath="mstns:Номер_заказа" />
    </xs:unique>
    <xs:unique name="pickup_point_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:pickup_point" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="producer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:producer" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:product" />
      <xs:field xpath="mstns:Артикул" />
    </xs:unique>
    <xs:unique name="role_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:role" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="supplier_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:supplier" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="unit_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:unit" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="user_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:user" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_order_pickup_point" msdata:parent="pickup_point" msdata:child="order" msdata:parentkey="id" msdata:childkey="id_пункта_выдачи" msprop:Generator_UserParentTable="pickup_point" msprop:Generator_UserChildTable="order" msprop:Generator_RelationVarName="relationFK_order_pickup_point" msprop:Generator_UserRelationName="FK_order_pickup_point" msprop:Generator_ChildPropName="GetorderRows" msprop:Generator_ParentPropName="pickup_pointRow" />
      <msdata:Relationship name="FK_order_user" msdata:parent="user" msdata:child="order" msdata:parentkey="id" msdata:childkey="id_пользователя" msprop:Generator_UserParentTable="user" msprop:Generator_UserChildTable="order" msprop:Generator_RelationVarName="relationFK_order_user" msprop:Generator_UserRelationName="FK_order_user" msprop:Generator_ChildPropName="GetorderRows" msprop:Generator_ParentPropName="userRow" />
      <msdata:Relationship name="FK_product_category" msdata:parent="category" msdata:child="product" msdata:parentkey="id" msdata:childkey="Категория_товара" msprop:Generator_UserParentTable="category" msprop:Generator_UserChildTable="product" msprop:Generator_RelationVarName="relationFK_product_category" msprop:Generator_ChildPropName="GetproductRows" msprop:Generator_ParentPropName="categoryRow" msprop:Generator_UserRelationName="FK_product_category" />
      <msdata:Relationship name="FK_product_producer" msdata:parent="producer" msdata:child="product" msdata:parentkey="id" msdata:childkey="Производитель" msprop:Generator_UserParentTable="producer" msprop:Generator_UserChildTable="product" msprop:Generator_RelationVarName="relationFK_product_producer" msprop:Generator_ChildPropName="GetproductRows" msprop:Generator_ParentPropName="producerRow" msprop:Generator_UserRelationName="FK_product_producer" />
      <msdata:Relationship name="FK_product_supplier" msdata:parent="supplier" msdata:child="product" msdata:parentkey="id" msdata:childkey="Поставщик" msprop:Generator_UserParentTable="supplier" msprop:Generator_UserChildTable="product" msprop:Generator_RelationVarName="relationFK_product_supplier" msprop:Generator_UserRelationName="FK_product_supplier" msprop:Generator_ChildPropName="GetproductRows" msprop:Generator_ParentPropName="supplierRow" />
      <msdata:Relationship name="FK_product_unit" msdata:parent="unit" msdata:child="product" msdata:parentkey="id" msdata:childkey="Единица_измерения" msprop:Generator_UserParentTable="unit" msprop:Generator_UserChildTable="product" msprop:Generator_RelationVarName="relationFK_product_unit" msprop:Generator_UserRelationName="FK_product_unit" msprop:Generator_ChildPropName="GetproductRows" msprop:Generator_ParentPropName="unitRow" />
      <msdata:Relationship name="FK_user_role" msdata:parent="role" msdata:child="user" msdata:parentkey="id" msdata:childkey="id_роли" msprop:Generator_UserParentTable="role" msprop:Generator_UserChildTable="user" msprop:Generator_RelationVarName="relationFK_user_role" msprop:Generator_ChildPropName="GetuserRows" msprop:Generator_ParentPropName="roleRow" msprop:Generator_UserRelationName="FK_user_role" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>