CAFEIS20231117/CHER_KAFEDataSet.xsd

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