GaydukDemo/WindowsFormsApp3/_12gkDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="_12gkDataSet" targetNamespace="http://tempuri.org/_12gkDataSet.xsd" xmlns:mstns="http://tempuri.org/_12gkDataSet.xsd" xmlns="http://tempuri.org/_12gkDataSet.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="_12gkConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="_12gkConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WindowsFormsApp3.Properties.Settings.GlobalReference.Default._12gkConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrderTableAdapter" GeneratorDataComponentClassName="OrderTableAdapter" Name="Order" UserDataComponentName="OrderTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="_12gkConnectionString (Settings)" DbObjectName="[12gk].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 (([OrderID] = @Original_OrderID) AND ([OrderDeliveryDate] = @Original_OrderDeliveryDate))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_OrderDeliveryDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDeliveryDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Order] ([OrderStatus], [OrderDeliveryDate], [OrderPickupPoint]) VALUES (@OrderStatus, @OrderDeliveryDate, @OrderPickupPoint);
SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint FROM [Order] WHERE (OrderID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OrderStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OrderStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@OrderDeliveryDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDeliveryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OrderPickupPoint" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OrderPickupPoint" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint FROM dbo.[Order]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Order] SET [OrderStatus] = @OrderStatus, [OrderDeliveryDate] = @OrderDeliveryDate, [OrderPickupPoint] = @OrderPickupPoint WHERE (([OrderID] = @Original_OrderID) AND ([OrderDeliveryDate] = @Original_OrderDeliveryDate));
SELECT OrderID, OrderStatus, OrderDeliveryDate, OrderPickupPoint FROM [Order] WHERE (OrderID = @OrderID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OrderStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OrderStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@OrderDeliveryDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDeliveryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OrderPickupPoint" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OrderPickupPoint" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_OrderDeliveryDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDeliveryDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="OrderID" ColumnName="OrderID" DataSourceName="[12gk].dbo.[Order]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@OrderID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrderID" DataSetColumn="OrderID" />
              <Mapping SourceColumn="OrderStatus" DataSetColumn="OrderStatus" />
              <Mapping SourceColumn="OrderDeliveryDate" DataSetColumn="OrderDeliveryDate" />
              <Mapping SourceColumn="OrderPickupPoint" DataSetColumn="OrderPickupPoint" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrdersProduktsTableAdapter" GeneratorDataComponentClassName="OrdersProduktsTableAdapter" Name="OrdersProdukts" UserDataComponentName="OrdersProduktsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="_12gkConnectionString (Settings)" DbObjectName="[12gk].dbo.OrdersProdukts" 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].[OrdersProdukts] WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductArticleNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductArticleNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[OrdersProdukts] ([ProductArticleNumber]) VALUES (@ProductArticleNumber);
SELECT OrderID, ProductArticleNumber FROM OrdersProdukts WHERE (OrderID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductArticleNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductArticleNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT OrderID, ProductArticleNumber FROM dbo.OrdersProdukts</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[OrdersProdukts] SET [ProductArticleNumber] = @ProductArticleNumber WHERE (([OrderID] = @Original_OrderID) AND ([ProductArticleNumber] = @Original_ProductArticleNumber));
SELECT OrderID, ProductArticleNumber FROM OrdersProdukts WHERE (OrderID = @OrderID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductArticleNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductArticleNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductArticleNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductArticleNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="OrderID" ColumnName="OrderID" DataSourceName="[12gk].dbo.OrdersProdukts" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@OrderID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrderID" DataSetColumn="OrderID" />
              <Mapping SourceColumn="ProductArticleNumber" DataSetColumn="ProductArticleNumber" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProdyktTableAdapter" GeneratorDataComponentClassName="ProdyktTableAdapter" Name="Prodykt" UserDataComponentName="ProdyktTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="_12gkConnectionString (Settings)" DbObjectName="[12gk].dbo.Prodykt" 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].[Prodykt] WHERE (([ArticleNumber] = @Original_ArticleNumber) AND ((@IsNull_Prais = 1 AND [Prais] IS NULL) OR ([Prais] = @Original_Prais)) 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_OrderID = 1 AND [OrderID] IS NULL) OR ([OrderID] = @Original_OrderID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ArticleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArticleNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prais" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prais" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Prais" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Prais" 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="String" Direction="Input" ParameterName="@Original_Поставщик" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Поставщик" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Действующая_Скидка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Действующая_Скидка" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Действующая_Скидка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Действующая_Скидка" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Количество_на_складе" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество_на_складе" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество_на_складе" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество_на_складе" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Prodykt] ([ArticleNumber], [Name], [Description], [Category], [Photo], [Manufacturer], [Prais], [Единица_измерения], [Размер_макс_скидки], [Поставщик], [Действующая_Скидка], [Количество_на_складе], [Ctatys], [OrderID]) VALUES (@ArticleNumber, @Name, @Description, @Category, @Photo, @Manufacturer, @Prais, @Единица_измерения, @Размер_макс_скидки, @Поставщик, @Действующая_Скидка, @Количество_на_складе, @Ctatys, @OrderID);
SELECT ArticleNumber, Name, Description, Category, Photo, Manufacturer, Prais, Единица_измерения, Размер_макс_скидки, Поставщик, Действующая_Скидка, Количество_на_складе, Ctatys, OrderID FROM Prodykt WHERE (ArticleNumber = @ArticleNumber)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArticleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArticleNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Category" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Manufacturer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Prais" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Prais" 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="String" Direction="Input" ParameterName="@Поставщик" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Поставщик" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Действующая_Скидка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Действующая_Скидка" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество_на_складе" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество_на_складе" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ctatys" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ctatys" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ArticleNumber, Name, Description, Category, Photo, Manufacturer, Prais, Единица_измерения, Размер_макс_скидки, Поставщик, Действующая_Скидка, Количество_на_складе, Ctatys, OrderID FROM dbo.Prodykt</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Prodykt] SET [ArticleNumber] = @ArticleNumber, [Name] = @Name, [Description] = @Description, [Category] = @Category, [Photo] = @Photo, [Manufacturer] = @Manufacturer, [Prais] = @Prais, [Единица_измерения] = @Единица_измерения, [Размер_макс_скидки] = @Размер_макс_скидки, [Поставщик] = @Поставщик, [Действующая_Скидка] = @Действующая_Скидка, [Количество_на_складе] = @Количество_на_складе, [Ctatys] = @Ctatys, [OrderID] = @OrderID WHERE (([ArticleNumber] = @Original_ArticleNumber) AND ((@IsNull_Prais = 1 AND [Prais] IS NULL) OR ([Prais] = @Original_Prais)) 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_OrderID = 1 AND [OrderID] IS NULL) OR ([OrderID] = @Original_OrderID)));
SELECT ArticleNumber, Name, Description, Category, Photo, Manufacturer, Prais, Единица_измерения, Размер_макс_скидки, Поставщик, Действующая_Скидка, Количество_на_складе, Ctatys, OrderID FROM Prodykt WHERE (ArticleNumber = @ArticleNumber)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArticleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArticleNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Category" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Manufacturer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Prais" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Prais" 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="String" Direction="Input" ParameterName="@Поставщик" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Поставщик" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Действующая_Скидка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Действующая_Скидка" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество_на_складе" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество_на_складе" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ctatys" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ctatys" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ArticleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArticleNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prais" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prais" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Prais" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Prais" 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="String" Direction="Input" ParameterName="@Original_Поставщик" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Поставщик" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Действующая_Скидка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Действующая_Скидка" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Действующая_Скидка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Действующая_Скидка" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Количество_на_складе" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество_на_складе" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество_на_складе" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество_на_складе" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleNumber" DataSetColumn="ArticleNumber" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Category" DataSetColumn="Category" />
              <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
              <Mapping SourceColumn="Manufacturer" DataSetColumn="Manufacturer" />
              <Mapping SourceColumn="Prais" DataSetColumn="Prais" />
              <Mapping SourceColumn="Единица_измерения" DataSetColumn="Единица_измерения" />
              <Mapping SourceColumn="Размер_макс_скидки" DataSetColumn="Размер_макс_скидки" />
              <Mapping SourceColumn="Поставщик" DataSetColumn="Поставщик" />
              <Mapping SourceColumn="Действующая_Скидка" DataSetColumn="Действующая_Скидка" />
              <Mapping SourceColumn="Количество_на_складе" DataSetColumn="Количество_на_складе" />
              <Mapping SourceColumn="Ctatys" DataSetColumn="Ctatys" />
              <Mapping SourceColumn="OrderID" DataSetColumn="OrderID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="_12gkConnectionString (Settings)" DbObjectName="[12gk].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 (([RoleID] = @Original_RoleID) AND ([RoleName] = @Original_RoleName))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Role] ([RoleName]) VALUES (@RoleName);
SELECT RoleID, RoleName FROM Role WHERE (RoleID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT RoleID, RoleName FROM dbo.Role</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Role] SET [RoleName] = @RoleName WHERE (([RoleID] = @Original_RoleID) AND ([RoleName] = @Original_RoleName));
SELECT RoleID, RoleName FROM Role WHERE (RoleID = @RoleID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="RoleID" ColumnName="RoleID" DataSourceName="[12gk].dbo.Role" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RoleID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RoleID" DataSetColumn="RoleID" />
              <Mapping SourceColumn="RoleName" DataSetColumn="RoleName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Users1TableAdapter" GeneratorDataComponentClassName="Users1TableAdapter" Name="Users1" UserDataComponentName="Users1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="_12gkConnectionString (Settings)" DbObjectName="[12gk].dbo.Users1" 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].[Users1] WHERE (([id] = @Original_id) AND ((@IsNull_familia = 1 AND [familia] IS NULL) OR ([familia] = @Original_familia)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_othestvo = 1 AND [othestvo] IS NULL) OR ([othestvo] = @Original_othestvo)) AND ((@IsNull_pole = 1 AND [pole] IS NULL) OR ([pole] = @Original_pole)))</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_familia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="familia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_familia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_othestvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="othestvo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_othestvo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="othestvo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pole" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pole" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Users1] ([familia], [name], [othestvo], [login], [pasword], [pole]) VALUES (@familia, @name, @othestvo, @login, @pasword, @pole);
SELECT id, familia, name, othestvo, login, pasword, pole FROM Users1 WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@familia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@othestvo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="othestvo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pasword" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pasword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@pole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pole" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, familia, name, othestvo, login, pasword, pole FROM dbo.Users1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Users1] SET [familia] = @familia, [name] = @name, [othestvo] = @othestvo, [login] = @login, [pasword] = @pasword, [pole] = @pole WHERE (([id] = @Original_id) AND ((@IsNull_familia = 1 AND [familia] IS NULL) OR ([familia] = @Original_familia)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_othestvo = 1 AND [othestvo] IS NULL) OR ([othestvo] = @Original_othestvo)) AND ((@IsNull_pole = 1 AND [pole] IS NULL) OR ([pole] = @Original_pole)));
SELECT id, familia, name, othestvo, login, pasword, pole FROM Users1 WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@familia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@othestvo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="othestvo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pasword" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pasword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@pole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pole" 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_familia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="familia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_familia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_othestvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="othestvo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_othestvo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="othestvo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pole" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="[12gk].dbo.Users1" 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="familia" DataSetColumn="familia" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="othestvo" DataSetColumn="othestvo" />
              <Mapping SourceColumn="login" DataSetColumn="login" />
              <Mapping SourceColumn="pasword" DataSetColumn="pasword" />
              <Mapping SourceColumn="pole" DataSetColumn="pole" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ZakazTableAdapter" GeneratorDataComponentClassName="ZakazTableAdapter" Name="Zakaz" UserDataComponentName="ZakazTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="_12gkConnectionString (Settings)" DbObjectName="[12gk].dbo.Zakaz" 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].[Zakaz] WHERE (([id] = @Original_id) AND ((@IsNull_data = 1 AND [data] IS NULL) OR ([data] = @Original_data)) AND ((@IsNull_dadaDostavki = 1 AND [dadaDostavki] IS NULL) OR ([dadaDostavki] = @Original_dadaDostavki)) AND ((@IsNull_Punkt = 1 AND [Punkt] IS NULL) OR ([Punkt] = @Original_Punkt)) AND ((@IsNull_Klient = 1 AND [Klient] IS NULL) OR ([Klient] = @Original_Klient)) AND ((@IsNull_KodPoluhatil = 1 AND [KodPoluhatil] IS NULL) OR ([KodPoluhatil] = @Original_KodPoluhatil)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)))</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_data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_data" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dadaDostavki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dadaDostavki" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dadaDostavki" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dadaDostavki" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Punkt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Punkt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Klient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Klient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Klient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Klient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KodPoluhatil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KodPoluhatil" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KodPoluhatil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KodPoluhatil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Zakaz] ([data], [dadaDostavki], [Punkt], [Klient], [KodPoluhatil], [Status]) VALUES (@data, @dadaDostavki, @Punkt, @Klient, @KodPoluhatil, @Status);
SELECT id, data, dadaDostavki, Punkt, Klient, KodPoluhatil, Status FROM Zakaz WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@data" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dadaDostavki" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dadaDostavki" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Punkt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Klient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Klient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KodPoluhatil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KodPoluhatil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, data, dadaDostavki, Punkt, Klient, KodPoluhatil, Status FROM dbo.Zakaz</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Zakaz] SET [data] = @data, [dadaDostavki] = @dadaDostavki, [Punkt] = @Punkt, [Klient] = @Klient, [KodPoluhatil] = @KodPoluhatil, [Status] = @Status WHERE (([id] = @Original_id) AND ((@IsNull_data = 1 AND [data] IS NULL) OR ([data] = @Original_data)) AND ((@IsNull_dadaDostavki = 1 AND [dadaDostavki] IS NULL) OR ([dadaDostavki] = @Original_dadaDostavki)) AND ((@IsNull_Punkt = 1 AND [Punkt] IS NULL) OR ([Punkt] = @Original_Punkt)) AND ((@IsNull_Klient = 1 AND [Klient] IS NULL) OR ([Klient] = @Original_Klient)) AND ((@IsNull_KodPoluhatil = 1 AND [KodPoluhatil] IS NULL) OR ([KodPoluhatil] = @Original_KodPoluhatil)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)));
SELECT id, data, dadaDostavki, Punkt, Klient, KodPoluhatil, Status FROM Zakaz WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@data" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dadaDostavki" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dadaDostavki" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Punkt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Klient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Klient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KodPoluhatil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KodPoluhatil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" 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_data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_data" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dadaDostavki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dadaDostavki" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dadaDostavki" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dadaDostavki" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Punkt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Punkt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Klient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Klient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Klient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Klient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KodPoluhatil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KodPoluhatil" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KodPoluhatil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KodPoluhatil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="[12gk].dbo.Zakaz" 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="data" DataSetColumn="data" />
              <Mapping SourceColumn="dadaDostavki" DataSetColumn="dadaDostavki" />
              <Mapping SourceColumn="Punkt" DataSetColumn="Punkt" />
              <Mapping SourceColumn="Klient" DataSetColumn="Klient" />
              <Mapping SourceColumn="KodPoluhatil" DataSetColumn="KodPoluhatil" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ZakazTovaraTableAdapter" GeneratorDataComponentClassName="ZakazTovaraTableAdapter" Name="ZakazTovara" UserDataComponentName="ZakazTovaraTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="_12gkConnectionString (Settings)" DbObjectName="[12gk].dbo.ZakazTovara" 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].[ZakazTovara] WHERE (([id] = @Original_id) AND ((@IsNull_nomerZakaz = 1 AND [nomerZakaz] IS NULL) OR ([nomerZakaz] = @Original_nomerZakaz)) AND ((@IsNull_nameTovar = 1 AND [nameTovar] IS NULL) OR ([nameTovar] = @Original_nameTovar)) AND ((@IsNull_kolichestvo = 1 AND [kolichestvo] IS NULL) OR ([kolichestvo] = @Original_kolichestvo)) AND ((@IsNull_id_punkt = 1 AND [id_punkt] IS NULL) OR ([id_punkt] = @Original_id_punkt)))</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_nomerZakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomerZakaz" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nomerZakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomerZakaz" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nameTovar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nameTovar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nameTovar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nameTovar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kolichestvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kolichestvo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_kolichestvo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="kolichestvo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_punkt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_punkt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ZakazTovara] ([nomerZakaz], [nameTovar], [kolichestvo], [id_punkt]) VALUES (@nomerZakaz, @nameTovar, @kolichestvo, @id_punkt);
SELECT id, nomerZakaz, nameTovar, kolichestvo, id_punkt FROM ZakazTovara WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nomerZakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomerZakaz" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nameTovar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nameTovar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@kolichestvo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="kolichestvo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_punkt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, nomerZakaz, nameTovar, kolichestvo, id_punkt FROM dbo.ZakazTovara</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ZakazTovara] SET [nomerZakaz] = @nomerZakaz, [nameTovar] = @nameTovar, [kolichestvo] = @kolichestvo, [id_punkt] = @id_punkt WHERE (([id] = @Original_id) AND ((@IsNull_nomerZakaz = 1 AND [nomerZakaz] IS NULL) OR ([nomerZakaz] = @Original_nomerZakaz)) AND ((@IsNull_nameTovar = 1 AND [nameTovar] IS NULL) OR ([nameTovar] = @Original_nameTovar)) AND ((@IsNull_kolichestvo = 1 AND [kolichestvo] IS NULL) OR ([kolichestvo] = @Original_kolichestvo)) AND ((@IsNull_id_punkt = 1 AND [id_punkt] IS NULL) OR ([id_punkt] = @Original_id_punkt)));
SELECT id, nomerZakaz, nameTovar, kolichestvo, id_punkt FROM ZakazTovara WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nomerZakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomerZakaz" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@nameTovar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nameTovar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@kolichestvo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="kolichestvo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_punkt" 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_nomerZakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomerZakaz" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nomerZakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomerZakaz" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nameTovar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nameTovar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_nameTovar" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="nameTovar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kolichestvo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kolichestvo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_kolichestvo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="kolichestvo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_punkt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_punkt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_punkt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="[12gk].dbo.ZakazTovara" 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="nomerZakaz" DataSetColumn="nomerZakaz" />
              <Mapping SourceColumn="nameTovar" DataSetColumn="nameTovar" />
              <Mapping SourceColumn="kolichestvo" DataSetColumn="kolichestvo" />
              <Mapping SourceColumn="id_punkt" DataSetColumn="id_punkt" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ПунктВыдачиTableAdapter" GeneratorDataComponentClassName="ПунктВыдачиTableAdapter" Name="ПунктВыдачи" UserDataComponentName="ПунктВыдачиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="_12gkConnectionString (Settings)" DbObjectName="[12gk].dbo.ПунктВыдачи" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ПунктВыдачи] WHERE (([id] = @Original_id) AND ([Идентификатор] = @Original_Идентификатор) AND ([Город] = @Original_Город) AND ([Улица] = @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_Идентификатор" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Идентификатор" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Город" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Город" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Улица" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Улица" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дом" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дом" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Дом" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дом" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ПунктВыдачи] ([Идентификатор], [Город], [Улица], [Дом]) VALUES (@Идентификатор, @Город, @Улица, @Дом);
SELECT id, Идентификатор, Город, Улица, Дом FROM ПунктВыдачи WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Идентификатор" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Идентификатор" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Город" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Город" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Улица" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Улица" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Дом" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дом" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Идентификатор, Город, Улица, Дом FROM dbo.ПунктВыдачи</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ПунктВыдачи] SET [Идентификатор] = @Идентификатор, [Город] = @Город, [Улица] = @Улица, [Дом] = @Дом WHERE (([id] = @Original_id) AND ([Идентификатор] = @Original_Идентификатор) AND ([Город] = @Original_Город) AND ([Улица] = @Original_Улица) AND ((@IsNull_Дом = 1 AND [Дом] IS NULL) OR ([Дом] = @Original_Дом)));
SELECT id, Идентификатор, Город, Улица, Дом FROM ПунктВыдачи WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Идентификатор" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Идентификатор" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Город" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Город" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Улица" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Улица" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Дом" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дом" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Идентификатор" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Идентификатор" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Город" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Город" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Улица" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Улица" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дом" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дом" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Дом" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дом" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="[12gk].dbo.ПунктВыдачи" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Идентификатор" DataSetColumn="Идентификатор" />
              <Mapping SourceColumn="Город" DataSetColumn="Город" />
              <Mapping SourceColumn="Улица" DataSetColumn="Улица" />
              <Mapping SourceColumn="Дом" DataSetColumn="Дом" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="_12gkDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="_12gkDataSet" msprop:Generator_UserDSName="_12gkDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Order" msprop:Generator_TableClassName="OrderDataTable" msprop:Generator_TableVarName="tableOrder" msprop:Generator_TablePropName="Order" msprop:Generator_RowDeletingName="OrderRowDeleting" msprop:Generator_RowChangingName="OrderRowChanging" msprop:Generator_RowEvHandlerName="OrderRowChangeEventHandler" msprop:Generator_RowDeletedName="OrderRowDeleted" msprop:Generator_UserTableName="Order" msprop:Generator_RowChangedName="OrderRowChanged" msprop:Generator_RowEvArgName="OrderRowChangeEvent" msprop:Generator_RowClassName="OrderRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnOrderID" msprop:Generator_ColumnPropNameInRow="OrderID" msprop:Generator_ColumnPropNameInTable="OrderIDColumn" msprop:Generator_UserColumnName="OrderID" type="xs:int" />
              <xs:element name="OrderStatus" msprop:Generator_ColumnVarNameInTable="columnOrderStatus" msprop:Generator_ColumnPropNameInRow="OrderStatus" msprop:Generator_ColumnPropNameInTable="OrderStatusColumn" msprop:Generator_UserColumnName="OrderStatus">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderDeliveryDate" msprop:Generator_ColumnVarNameInTable="columnOrderDeliveryDate" msprop:Generator_ColumnPropNameInRow="OrderDeliveryDate" msprop:Generator_ColumnPropNameInTable="OrderDeliveryDateColumn" msprop:Generator_UserColumnName="OrderDeliveryDate" type="xs:dateTime" />
              <xs:element name="OrderPickupPoint" msprop:Generator_ColumnVarNameInTable="columnOrderPickupPoint" msprop:Generator_ColumnPropNameInRow="OrderPickupPoint" msprop:Generator_ColumnPropNameInTable="OrderPickupPointColumn" msprop:Generator_UserColumnName="OrderPickupPoint">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OrdersProdukts" msprop:Generator_TableClassName="OrdersProduktsDataTable" msprop:Generator_TableVarName="tableOrdersProdukts" msprop:Generator_TablePropName="OrdersProdukts" msprop:Generator_RowDeletingName="OrdersProduktsRowDeleting" msprop:Generator_RowChangingName="OrdersProduktsRowChanging" msprop:Generator_RowEvHandlerName="OrdersProduktsRowChangeEventHandler" msprop:Generator_RowDeletedName="OrdersProduktsRowDeleted" msprop:Generator_UserTableName="OrdersProdukts" msprop:Generator_RowChangedName="OrdersProduktsRowChanged" msprop:Generator_RowEvArgName="OrdersProduktsRowChangeEvent" msprop:Generator_RowClassName="OrdersProduktsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnOrderID" msprop:Generator_ColumnPropNameInRow="OrderID" msprop:Generator_ColumnPropNameInTable="OrderIDColumn" msprop:Generator_UserColumnName="OrderID" type="xs:int" />
              <xs:element name="ProductArticleNumber" msprop:Generator_ColumnVarNameInTable="columnProductArticleNumber" msprop:Generator_ColumnPropNameInRow="ProductArticleNumber" msprop:Generator_ColumnPropNameInTable="ProductArticleNumberColumn" msprop:Generator_UserColumnName="ProductArticleNumber" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Prodykt" msprop:Generator_TableClassName="ProdyktDataTable" msprop:Generator_TableVarName="tableProdykt" msprop:Generator_TablePropName="Prodykt" msprop:Generator_RowDeletingName="ProdyktRowDeleting" msprop:Generator_RowChangingName="ProdyktRowChanging" msprop:Generator_RowEvHandlerName="ProdyktRowChangeEventHandler" msprop:Generator_RowDeletedName="ProdyktRowDeleted" msprop:Generator_UserTableName="Prodykt" msprop:Generator_RowChangedName="ProdyktRowChanged" msprop:Generator_RowEvArgName="ProdyktRowChangeEvent" msprop:Generator_RowClassName="ProdyktRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleNumber" msprop:Generator_ColumnVarNameInTable="columnArticleNumber" msprop:Generator_ColumnPropNameInRow="ArticleNumber" msprop:Generator_ColumnPropNameInTable="ArticleNumberColumn" msprop:Generator_UserColumnName="ArticleNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Category" msprop:Generator_ColumnVarNameInTable="columnCategory" msprop:Generator_ColumnPropNameInRow="Category" msprop:Generator_ColumnPropNameInTable="CategoryColumn" msprop:Generator_UserColumnName="Category" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Photo" msprop:Generator_ColumnVarNameInTable="columnPhoto" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_UserColumnName="Photo" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Manufacturer" msprop:Generator_ColumnVarNameInTable="columnManufacturer" msprop:Generator_ColumnPropNameInRow="Manufacturer" msprop:Generator_ColumnPropNameInTable="ManufacturerColumn" msprop:Generator_UserColumnName="Manufacturer" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prais" msprop:Generator_ColumnVarNameInTable="columnPrais" msprop:Generator_ColumnPropNameInRow="Prais" msprop:Generator_ColumnPropNameInTable="PraisColumn" msprop:Generator_UserColumnName="Prais" type="xs:decimal" minOccurs="0" />
              <xs:element name="Единица_измерения" msprop:Generator_ColumnVarNameInTable="columnЕдиница_измерения" msprop:Generator_ColumnPropNameInRow="Единица_измерения" msprop:Generator_ColumnPropNameInTable="Единица_измеренияColumn" msprop:Generator_UserColumnName="Единица_измерения" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Размер_макс_скидки" msprop:Generator_ColumnVarNameInTable="columnРазмер_макс_скидки" msprop:Generator_ColumnPropNameInRow="Размер_макс_скидки" msprop:Generator_ColumnPropNameInTable="Размер_макс_скидкиColumn" msprop:Generator_UserColumnName="Размер_макс_скидки" type="xs:int" minOccurs="0" />
              <xs:element name="Поставщик" msprop:Generator_ColumnVarNameInTable="columnПоставщик" msprop:Generator_ColumnPropNameInRow="Поставщик" msprop:Generator_ColumnPropNameInTable="ПоставщикColumn" msprop:Generator_UserColumnName="Поставщик" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Действующая_Скидка" msprop:Generator_ColumnVarNameInTable="columnДействующая_Скидка" msprop:Generator_ColumnPropNameInRow="Действующая_Скидка" msprop:Generator_ColumnPropNameInTable="Действующая_СкидкаColumn" msprop:Generator_UserColumnName="Действующая_Скидка" type="xs:int" minOccurs="0" />
              <xs:element name="Количество_на_складе" msprop:Generator_ColumnVarNameInTable="columnКоличество_на_складе" msprop:Generator_ColumnPropNameInRow="Количество_на_складе" msprop:Generator_ColumnPropNameInTable="Количество_на_складеColumn" msprop:Generator_UserColumnName="Количество_на_складе" type="xs:int" minOccurs="0" />
              <xs:element name="Ctatys" msprop:Generator_ColumnVarNameInTable="columnCtatys" msprop:Generator_ColumnPropNameInRow="Ctatys" msprop:Generator_ColumnPropNameInTable="CtatysColumn" msprop:Generator_UserColumnName="Ctatys" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderID" msprop:Generator_ColumnVarNameInTable="columnOrderID" msprop:Generator_ColumnPropNameInRow="OrderID" msprop:Generator_ColumnPropNameInTable="OrderIDColumn" msprop:Generator_UserColumnName="OrderID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Role" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_TableVarName="tableRole" msprop:Generator_TablePropName="Role" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_UserTableName="Role" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_RowEvArgName="RoleRowChangeEvent" msprop:Generator_RowClassName="RoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RoleID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnRoleID" msprop:Generator_ColumnPropNameInRow="RoleID" msprop:Generator_ColumnPropNameInTable="RoleIDColumn" msprop:Generator_UserColumnName="RoleID" type="xs:int" />
              <xs:element name="RoleName" msprop:Generator_ColumnVarNameInTable="columnRoleName" msprop:Generator_ColumnPropNameInRow="RoleName" msprop:Generator_ColumnPropNameInTable="RoleNameColumn" msprop:Generator_UserColumnName="RoleName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users1" msprop:Generator_TableClassName="Users1DataTable" msprop:Generator_TableVarName="tableUsers1" msprop:Generator_TablePropName="Users1" msprop:Generator_RowDeletingName="Users1RowDeleting" msprop:Generator_RowChangingName="Users1RowChanging" msprop:Generator_RowEvHandlerName="Users1RowChangeEventHandler" msprop:Generator_RowDeletedName="Users1RowDeleted" msprop:Generator_UserTableName="Users1" msprop:Generator_RowChangedName="Users1RowChanged" msprop:Generator_RowEvArgName="Users1RowChangeEvent" msprop:Generator_RowClassName="Users1Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="familia" msprop:Generator_ColumnVarNameInTable="columnfamilia" msprop:Generator_ColumnPropNameInRow="familia" msprop:Generator_ColumnPropNameInTable="familiaColumn" msprop:Generator_UserColumnName="familia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="othestvo" msprop:Generator_ColumnVarNameInTable="columnothestvo" msprop:Generator_ColumnPropNameInRow="othestvo" msprop:Generator_ColumnPropNameInTable="othestvoColumn" msprop:Generator_UserColumnName="othestvo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="login" msprop:Generator_ColumnVarNameInTable="columnlogin" msprop:Generator_ColumnPropNameInRow="login" msprop:Generator_ColumnPropNameInTable="loginColumn" msprop:Generator_UserColumnName="login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pasword" msprop:Generator_ColumnVarNameInTable="columnpasword" msprop:Generator_ColumnPropNameInRow="pasword" msprop:Generator_ColumnPropNameInTable="paswordColumn" msprop:Generator_UserColumnName="pasword" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pole" msprop:Generator_ColumnVarNameInTable="columnpole" msprop:Generator_ColumnPropNameInRow="pole" msprop:Generator_ColumnPropNameInTable="poleColumn" msprop:Generator_UserColumnName="pole" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Zakaz" msprop:Generator_TableClassName="ZakazDataTable" msprop:Generator_TableVarName="tableZakaz" msprop:Generator_TablePropName="Zakaz" msprop:Generator_RowDeletingName="ZakazRowDeleting" msprop:Generator_RowChangingName="ZakazRowChanging" msprop:Generator_RowEvHandlerName="ZakazRowChangeEventHandler" msprop:Generator_RowDeletedName="ZakazRowDeleted" msprop:Generator_UserTableName="Zakaz" msprop:Generator_RowChangedName="ZakazRowChanged" msprop:Generator_RowEvArgName="ZakazRowChangeEvent" msprop:Generator_RowClassName="ZakazRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="data" msprop:Generator_ColumnVarNameInTable="columndata" msprop:Generator_ColumnPropNameInRow="data" msprop:Generator_ColumnPropNameInTable="dataColumn" msprop:Generator_UserColumnName="data" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dadaDostavki" msprop:Generator_ColumnVarNameInTable="columndadaDostavki" msprop:Generator_ColumnPropNameInRow="dadaDostavki" msprop:Generator_ColumnPropNameInTable="dadaDostavkiColumn" msprop:Generator_UserColumnName="dadaDostavki" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Punkt" msprop:Generator_ColumnVarNameInTable="columnPunkt" msprop:Generator_ColumnPropNameInRow="Punkt" msprop:Generator_ColumnPropNameInTable="PunktColumn" msprop:Generator_UserColumnName="Punkt" type="xs:int" minOccurs="0" />
              <xs:element name="Klient" msprop:Generator_ColumnVarNameInTable="columnKlient" msprop:Generator_ColumnPropNameInRow="Klient" msprop:Generator_ColumnPropNameInTable="KlientColumn" msprop:Generator_UserColumnName="Klient" type="xs:int" minOccurs="0" />
              <xs:element name="KodPoluhatil" msprop:Generator_ColumnVarNameInTable="columnKodPoluhatil" msprop:Generator_ColumnPropNameInRow="KodPoluhatil" msprop:Generator_ColumnPropNameInTable="KodPoluhatilColumn" msprop:Generator_UserColumnName="KodPoluhatil" type="xs:int" minOccurs="0" />
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ZakazTovara" msprop:Generator_TableClassName="ZakazTovaraDataTable" msprop:Generator_TableVarName="tableZakazTovara" msprop:Generator_TablePropName="ZakazTovara" msprop:Generator_RowDeletingName="ZakazTovaraRowDeleting" msprop:Generator_RowChangingName="ZakazTovaraRowChanging" msprop:Generator_RowEvHandlerName="ZakazTovaraRowChangeEventHandler" msprop:Generator_RowDeletedName="ZakazTovaraRowDeleted" msprop:Generator_UserTableName="ZakazTovara" msprop:Generator_RowChangedName="ZakazTovaraRowChanged" msprop:Generator_RowEvArgName="ZakazTovaraRowChangeEvent" msprop:Generator_RowClassName="ZakazTovaraRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="nomerZakaz" msprop:Generator_ColumnVarNameInTable="columnnomerZakaz" msprop:Generator_ColumnPropNameInRow="nomerZakaz" msprop:Generator_ColumnPropNameInTable="nomerZakazColumn" msprop:Generator_UserColumnName="nomerZakaz" type="xs:int" minOccurs="0" />
              <xs:element name="nameTovar" msprop:Generator_ColumnVarNameInTable="columnnameTovar" msprop:Generator_ColumnPropNameInRow="nameTovar" msprop:Generator_ColumnPropNameInTable="nameTovarColumn" msprop:Generator_UserColumnName="nameTovar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="kolichestvo" msprop:Generator_ColumnVarNameInTable="columnkolichestvo" msprop:Generator_ColumnPropNameInRow="kolichestvo" msprop:Generator_ColumnPropNameInTable="kolichestvoColumn" msprop:Generator_UserColumnName="kolichestvo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id_punkt" msprop:Generator_ColumnVarNameInTable="columnid_punkt" msprop:Generator_ColumnPropNameInRow="id_punkt" msprop:Generator_ColumnPropNameInTable="id_punktColumn" msprop:Generator_UserColumnName="id_punkt" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ПунктВыдачи" msprop:Generator_TableClassName="ПунктВыдачиDataTable" msprop:Generator_TableVarName="tableПунктВыдачи" msprop:Generator_TablePropName="ПунктВыдачи" msprop:Generator_RowDeletingName="ПунктВыдачиRowDeleting" msprop:Generator_RowChangingName="ПунктВыдачиRowChanging" msprop:Generator_RowEvHandlerName="ПунктВыдачиRowChangeEventHandler" msprop:Generator_RowDeletedName="ПунктВыдачиRowDeleted" msprop:Generator_UserTableName="ПунктВыдачи" msprop:Generator_RowChangedName="ПунктВыдачиRowChanged" msprop:Generator_RowEvArgName="ПунктВыдачиRowChangeEvent" msprop:Generator_RowClassName="ПунктВыдачиRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="Идентификатор" msprop:Generator_ColumnVarNameInTable="columnИдентификатор" msprop:Generator_ColumnPropNameInRow="Идентификатор" msprop:Generator_ColumnPropNameInTable="ИдентификаторColumn" msprop:Generator_UserColumnName="Идентификатор" type="xs:int" />
              <xs:element name="Город" msprop:Generator_ColumnVarNameInTable="columnГород" msprop:Generator_ColumnPropNameInRow="Город" msprop:Generator_ColumnPropNameInTable="ГородColumn" msprop:Generator_UserColumnName="Город">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Улица" msprop:Generator_ColumnVarNameInTable="columnУлица" msprop:Generator_ColumnPropNameInRow="Улица" msprop:Generator_ColumnPropNameInTable="УлицаColumn" msprop:Generator_UserColumnName="Улица">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Дом" msprop:Generator_ColumnVarNameInTable="columnДом" msprop:Generator_ColumnPropNameInRow="Дом" msprop:Generator_ColumnPropNameInTable="ДомColumn" msprop:Generator_UserColumnName="Дом" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Order" />
      <xs:field xpath="mstns:OrderID" />
    </xs:unique>
    <xs:unique name="OrdersProdukts_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OrdersProdukts" />
      <xs:field xpath="mstns:OrderID" />
    </xs:unique>
    <xs:unique name="Prodykt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Prodykt" />
      <xs:field xpath="mstns:ArticleNumber" />
    </xs:unique>
    <xs:unique name="Role_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Role" />
      <xs:field xpath="mstns:RoleID" />
    </xs:unique>
    <xs:unique name="Users1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users1" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Zakaz_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Zakaz" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="ZakazTovara_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ZakazTovara" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="ПунктВыдачи_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ПунктВыдачи" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_OrdersProdukts_Order" msdata:parent="Order" msdata:child="OrdersProdukts" msdata:parentkey="OrderID" msdata:childkey="OrderID" msprop:Generator_UserChildTable="OrdersProdukts" msprop:Generator_ChildPropName="GetOrdersProduktsRows" msprop:Generator_UserRelationName="FK_OrdersProdukts_Order" msprop:Generator_ParentPropName="OrderRow" msprop:Generator_RelationVarName="relationFK_OrdersProdukts_Order" msprop:Generator_UserParentTable="Order" />
      <msdata:Relationship name="FK_Prodykt_OrdersProdukts" msdata:parent="OrdersProdukts" msdata:child="Prodykt" msdata:parentkey="OrderID" msdata:childkey="OrderID" msprop:Generator_UserChildTable="Prodykt" msprop:Generator_ChildPropName="GetProdyktRows" msprop:Generator_UserRelationName="FK_Prodykt_OrdersProdukts" msprop:Generator_ParentPropName="OrdersProduktsRow" msprop:Generator_RelationVarName="relationFK_Prodykt_OrdersProdukts" msprop:Generator_UserParentTable="OrdersProdukts" />
      <msdata:Relationship name="FK_Role_Users1" msdata:parent="Users1" msdata:child="Role" msdata:parentkey="id" msdata:childkey="RoleID" msprop:Generator_UserChildTable="Role" msprop:Generator_ChildPropName="GetRoleRows" msprop:Generator_UserRelationName="FK_Role_Users1" msprop:Generator_RelationVarName="relationFK_Role_Users1" msprop:Generator_UserParentTable="Users1" msprop:Generator_ParentPropName="Users1Row" />
      <msdata:Relationship name="FK_ZakazTovara_Zakaz" msdata:parent="Zakaz" msdata:child="ZakazTovara" msdata:parentkey="id" msdata:childkey="nomerZakaz" msprop:Generator_UserChildTable="ZakazTovara" msprop:Generator_ChildPropName="GetZakazTovaraRows" msprop:Generator_UserRelationName="FK_ZakazTovara_Zakaz" msprop:Generator_ParentPropName="ZakazRow" msprop:Generator_RelationVarName="relationFK_ZakazTovara_Zakaz" msprop:Generator_UserParentTable="Zakaz" />
      <msdata:Relationship name="FK_ZakazTovara_ПунктВыдачи" msdata:parent="ПунктВыдачи" msdata:child="ZakazTovara" msdata:parentkey="id" msdata:childkey="id_punkt" msprop:Generator_UserChildTable="ZakazTovara" msprop:Generator_ChildPropName="GetZakazTovaraRows" msprop:Generator_UserRelationName="FK_ZakazTovara_ПунктВыдачи" msprop:Generator_RelationVarName="relationFK_ZakazTovara_ПунктВыдачи" msprop:Generator_UserParentTable="ПунктВыдачи" msprop:Generator_ParentPropName="ПунктВыдачиRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>