<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="LEBSesDataSet" targetNamespace="http://tempuri.org/LEBSesDataSet.xsd" xmlns:mstns="http://tempuri.org/LEBSesDataSet.xsd" xmlns="http://tempuri.org/LEBSesDataSet.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="LEBSesConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="LEBSesConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.LebedenkoHranitel.Properties.Settings.GlobalReference.Default.LEBSesConnectionString" 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="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.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 [Сотрудники] WHERE (((@IsNull_ФИО = 1 AND [ФИО] IS NULL) OR ([ФИО] = @Original_ФИО)) AND ((@IsNull_Подразделение = 1 AND [Подразделение] IS NULL) OR ([Подразделение] = @Original_Подразделение)) AND ((@IsNull_Отдел = 1 AND [Отдел] IS NULL) OR ([Отдел] = @Original_Отдел)) AND ([Код_сотрудника] = @Original_Код_сотрудника) AND ((@IsNull_Срок_По = 1 AND [Срок_По] IS NULL) OR ([Срок_По] = @Original_Срок_По)) AND ((@IsNull_Срок_С = 1 AND [Срок_С] IS NULL) OR ([Срок_С] = @Original_Срок_С)) AND ((@IsNull_ФИО_Клиента = 1 AND [ФИО_Клиента] IS NULL) OR ([ФИО_Клиента] = @Original_ФИО_Клиента)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ФИО" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ФИО" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ФИО" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ФИО" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Подразделение" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Подразделение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отдел" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отдел" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отдел" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отдел" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код_сотрудника" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код_сотрудника" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="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="Date" Direction="Input" ParameterName="@Original_Срок_С" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Срок_С" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ФИО_Клиента" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ФИО_Клиента" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ФИО_Клиента" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ФИО_Клиента" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Сотрудники] ([ФИО], [Подразделение], [Код_сотрудника], [Срок_По], [Срок_С], [ФИО_Клиента]) VALUES (@ФИО, @Подразделение, @Код_сотрудника, @Срок_По, @Срок_С, @ФИО_Клиента)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ФИО" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ФИО" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Подразделение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Код_сотрудника" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код_сотрудника" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Срок_По" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Срок_По" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Срок_С" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Срок_С" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ФИО_Клиента" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ФИО_Клиента" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ФИО, Подразделение, Код_сотрудника, Срок_По, Срок_С, ФИО_Клиента FROM Сотрудники</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Сотрудники] SET [ФИО] = @ФИО, [Подразделение] = @Подразделение, [Отдел] = @Отдел, [Код_сотрудника] = @Код_сотрудника, [Срок_По] = @Срок_По, [Срок_С] = @Срок_С, [ФИО_Клиента] = @ФИО_Клиента WHERE (((@IsNull_ФИО = 1 AND [ФИО] IS NULL) OR ([ФИО] = @Original_ФИО)) AND ((@IsNull_Подразделение = 1 AND [Подразделение] IS NULL) OR ([Подразделение] = @Original_Подразделение)) AND ((@IsNull_Отдел = 1 AND [Отдел] IS NULL) OR ([Отдел] = @Original_Отдел)) AND ([Код_сотрудника] = @Original_Код_сотрудника) AND ((@IsNull_Срок_По = 1 AND [Срок_По] IS NULL) OR ([Срок_По] = @Original_Срок_По)) AND ((@IsNull_Срок_С = 1 AND [Срок_С] IS NULL) OR ([Срок_С] = @Original_Срок_С)) AND ((@IsNull_ФИО_Клиента = 1 AND [ФИО_Клиента] IS NULL) OR ([ФИО_Клиента] = @Original_ФИО_Клиента)));
SELECT ФИО, Подразделение, Отдел, Код_сотрудника, Срок_По, Срок_С, ФИО_Клиента FROM Сотрудники WHERE (Код_сотрудника = @Код_сотрудника)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ФИО" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ФИО" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Подразделение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отдел" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отдел" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Код_сотрудника" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код_сотрудника" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Срок_По" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Срок_По" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Срок_С" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Срок_С" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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="@IsNull_ФИО" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ФИО" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ФИО" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ФИО" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Подразделение" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Подразделение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отдел" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отдел" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отдел" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отдел" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код_сотрудника" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код_сотрудника" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="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="Date" Direction="Input" ParameterName="@Original_Срок_С" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Срок_С" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ФИО_Клиента" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ФИО_Клиента" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ФИО_Клиента" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ФИО_Клиента" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ФИО" DataSetColumn="ФИО" />
              <Mapping SourceColumn="Подразделение" DataSetColumn="Подразделение" />
              <Mapping SourceColumn="Код_сотрудника" DataSetColumn="Код_сотрудника" />
              <Mapping SourceColumn="ФИО_Клиента" DataSetColumn="ФИО_Клиента" />
              <Mapping SourceColumn="Срок_С" DataSetColumn="Срок_С" />
              <Mapping SourceColumn="Срок_По" DataSetColumn="Срок_По" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LoginDepartmentTableAdapter" GeneratorDataComponentClassName="LoginDepartmentTableAdapter" Name="LoginDepartment" UserDataComponentName="LoginDepartmentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.dbo.LoginDepartment" 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].[LoginDepartment] ([Login], [Password]) VALUES (@Login, @Password)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Login, Password FROM dbo.LoginDepartment</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LoginGuardTableAdapter" GeneratorDataComponentClassName="LoginGuardTableAdapter" Name="LoginGuard" UserDataComponentName="LoginGuardTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.dbo.LoginGuard" 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].[LoginGuard] ([Login], [Password]) VALUES (@Login, @Password)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Login, Password FROM dbo.LoginGuard</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.dbo.Role" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Role] ([Role]) VALUES (@Role)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Role FROM dbo.Role</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LoginGeneralTableAdapter" GeneratorDataComponentClassName="LoginGeneralTableAdapter" Name="LoginGeneral" UserDataComponentName="LoginGeneralTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.dbo.LoginGeneral" 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].[LoginGeneral] ([Login], [Password]) VALUES (@Login, @Password)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Login, Password FROM dbo.LoginGeneral</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LoginUserTableAdapter" GeneratorDataComponentClassName="LoginUserTableAdapter" Name="LoginUser" UserDataComponentName="LoginUserTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.dbo.LoginUser" 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].[LoginUser] ([Login], [Password]) VALUES (@Login, @Password)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Login, Password FROM dbo.LoginUser</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Личное ПосещениеTableAdapter" GeneratorDataComponentClassName="Личное_ПосещениеTableAdapter" Name="Личное Посещение" UserDataComponentName="Личное ПосещениеTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.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 [Личное Посещение] WHERE (((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Номер_телефона = 1 AND [Номер_телефона] IS NULL) OR ([Номер_телефона] = @Original_Номер_телефона)) AND ((@IsNull_E_mail = 1 AND [E_mail] IS NULL) OR ([E_mail] = @Original_E_mail)) AND ((@IsNull_Дата_рождения = 1 AND [Дата_рождения] IS NULL) OR ([Дата_рождения] = @Original_Дата_рождения)) AND ((@IsNull_Серия = 1 AND [Серия] IS NULL) OR ([Серия] = @Original_Серия)) AND ((@IsNull_Номер = 1 AND [Номер] IS NULL) OR ([Номер] = @Original_Номер)) AND ((@IsNull_Логин = 1 AND [Логин] IS NULL) OR ([Логин] = @Original_Логин)) AND ((@IsNull_Пароль = 1 AND [Пароль] IS NULL) OR ([Пароль] = @Original_Пароль)) AND ((@IsNull_Назначение = 1 AND [Назначение] IS NULL) OR ([Назначение] = @Original_Назначение)) AND ((@IsNull_Цель = 1 AND [Цель] IS NULL) OR ([Цель] = @Original_Цель)) AND ((@IsNull_Подразделение = 1 AND [Подразделение] IS NULL) OR ([Подразделение] = @Original_Подразделение)) AND ((@IsNull_Статус = 1 AND [Статус] IS NULL) OR ([Статус] = @Original_Статус)) AND ([Код] = @Original_Код))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@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_E_mail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_E_mail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_рождения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Дата_рождения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Серия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Серия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Серия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Серия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Номер" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Номер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Номер" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Логин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Назначение" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Назначение" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Назначение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Назначение" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цель" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цель" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цель" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цель" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Подразделение" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Подразделение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Статус" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Статус" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Статус" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Статус" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Личное Посещение] ([Фамилия], [Имя], [Отчество], [Номер_телефона], [E_mail], [Дата_рождения], [Серия], [Номер], [Логин], [Пароль], [Назначение], [Цель], [Подразделение], [Статус]) VALUES (@Фамилия, @Имя, @Отчество, @Номер_телефона, @E_mail, @Дата_рождения, @Серия, @Номер, @Логин, @Пароль, @Назначение, @Цель, @Подразделение, @Статус);
SELECT Фамилия, Имя, Отчество, Номер_телефона, E_mail, Дата_рождения, Серия, Номер, Логин, Пароль, Назначение, Цель, Подразделение, Статус, Код FROM [Личное Посещение] WHERE (Код = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Номер_телефона" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Номер_телефона" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Дата_рождения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Серия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Серия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Номер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Номер" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Назначение" 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="Boolean" Direction="Input" ParameterName="@Статус" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Статус" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Фамилия, Имя, Отчество, Номер_телефона, E_mail, Дата_рождения, Серия, Номер, Логин, Пароль, Назначение, Цель, Подразделение, Статус, Код FROM [Личное Посещение]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Личное Посещение] SET [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество, [Номер_телефона] = @Номер_телефона, [E_mail] = @E_mail, [Дата_рождения] = @Дата_рождения, [Серия] = @Серия, [Номер] = @Номер, [Логин] = @Логин, [Пароль] = @Пароль, [Назначение] = @Назначение, [Цель] = @Цель, [Подразделение] = @Подразделение, [Статус] = @Статус WHERE (((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Номер_телефона = 1 AND [Номер_телефона] IS NULL) OR ([Номер_телефона] = @Original_Номер_телефона)) AND ((@IsNull_E_mail = 1 AND [E_mail] IS NULL) OR ([E_mail] = @Original_E_mail)) AND ((@IsNull_Дата_рождения = 1 AND [Дата_рождения] IS NULL) OR ([Дата_рождения] = @Original_Дата_рождения)) AND ((@IsNull_Серия = 1 AND [Серия] IS NULL) OR ([Серия] = @Original_Серия)) AND ((@IsNull_Номер = 1 AND [Номер] IS NULL) OR ([Номер] = @Original_Номер)) AND ((@IsNull_Логин = 1 AND [Логин] IS NULL) OR ([Логин] = @Original_Логин)) AND ((@IsNull_Пароль = 1 AND [Пароль] IS NULL) OR ([Пароль] = @Original_Пароль)) AND ((@IsNull_Назначение = 1 AND [Назначение] IS NULL) OR ([Назначение] = @Original_Назначение)) AND ((@IsNull_Цель = 1 AND [Цель] IS NULL) OR ([Цель] = @Original_Цель)) AND ((@IsNull_Подразделение = 1 AND [Подразделение] IS NULL) OR ([Подразделение] = @Original_Подразделение)) AND ((@IsNull_Статус = 1 AND [Статус] IS NULL) OR ([Статус] = @Original_Статус)) AND ([Код] = @Original_Код));
SELECT Фамилия, Имя, Отчество, Номер_телефона, E_mail, Дата_рождения, Серия, Номер, Логин, Пароль, Назначение, Цель, Подразделение, Статус, Код FROM [Личное Посещение] WHERE (Код = @Код)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Номер_телефона" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Номер_телефона" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Дата_рождения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Серия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Серия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Номер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Номер" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Назначение" 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="Boolean" Direction="Input" ParameterName="@Статус" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Статус" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@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_E_mail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_E_mail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_рождения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Дата_рождения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Серия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Серия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Серия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Серия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Номер" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Номер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Номер" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Логин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Назначение" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Назначение" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Назначение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Назначение" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цель" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цель" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Цель" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Цель" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Подразделение" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Подразделение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Статус" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Статус" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Статус" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Статус" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Код" ColumnName="Код" DataSourceName="LEBSes.dbo.[Личное Посещение]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Код" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Номер_телефона" DataSetColumn="Номер_телефона" />
              <Mapping SourceColumn="E_mail" DataSetColumn="E_mail" />
              <Mapping SourceColumn="Дата_рождения" DataSetColumn="Дата_рождения" />
              <Mapping SourceColumn="Серия" DataSetColumn="Серия" />
              <Mapping SourceColumn="Номер" DataSetColumn="Номер" />
              <Mapping SourceColumn="Логин" DataSetColumn="Логин" />
              <Mapping SourceColumn="Пароль" DataSetColumn="Пароль" />
              <Mapping SourceColumn="Назначение" DataSetColumn="Назначение" />
              <Mapping SourceColumn="Цель" DataSetColumn="Цель" />
              <Mapping SourceColumn="Подразделение" DataSetColumn="Подразделение" />
              <Mapping SourceColumn="Статус" DataSetColumn="Статус" />
              <Mapping SourceColumn="Код" DataSetColumn="Код" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.dbo.[Личное Посещение]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Фамилия, Имя, Отчество, Номер_телефона, E_mail, Дата_рождения, Серия, Номер, Логин, Пароль, Назначение, Цель, Подразделение, Статус, Код FROM [Личное Посещение]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE</CommandText>
                    <Parameters />
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ПодразделениеTableAdapter" GeneratorDataComponentClassName="ПодразделениеTableAdapter" Name="Подразделение" UserDataComponentName="ПодразделениеTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.dbo.Подразделение" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ФИО, Подразделение FROM dbo.Подразделение</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <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="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.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 [Групповое] ([Фамилия], [Имя], [Отчество], [Номер_телефона], [E_mail], [Дата_рождения], [Серия], [Номер], [Группа], [Назначение], [Подразделение], [Статус], [Цель]) VALUES (@Фамилия, @Имя, @Отчество, @Номер_телефона, @E_mail, @Дата_рождения, @Серия, @Номер, @Группа, @Назначение, @Подразделение, @Статус, @Цель)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Номер_телефона" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Номер_телефона" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Дата_рождения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Серия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Серия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Номер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Номер" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Группа" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Группа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Назначение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Назначение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Подразделение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Статус" Precision="0" ProviderType="Bit" 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 Фамилия, Имя, Отчество, Номер_телефона, E_mail, Дата_рождения, Серия, Номер, Группа, Назначение, Подразделение, Статус, Цель FROM Групповое</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Номер_телефона" DataSetColumn="Номер_телефона" />
              <Mapping SourceColumn="E_mail" DataSetColumn="E_mail" />
              <Mapping SourceColumn="Дата_рождения" DataSetColumn="Дата_рождения" />
              <Mapping SourceColumn="Серия" DataSetColumn="Серия" />
              <Mapping SourceColumn="Номер" DataSetColumn="Номер" />
              <Mapping SourceColumn="Группа" DataSetColumn="Группа" />
              <Mapping SourceColumn="Назначение" DataSetColumn="Назначение" />
              <Mapping SourceColumn="Цель" DataSetColumn="Цель" />
              <Mapping SourceColumn="Подразделение" DataSetColumn="Подразделение" />
              <Mapping SourceColumn="Статус" DataSetColumn="Статус" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Список_СотрудниковTableAdapter" GeneratorDataComponentClassName="Список_СотрудниковTableAdapter" Name="Список_Сотрудников" UserDataComponentName="Список_СотрудниковTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.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 [Список_Сотрудников] ([Фамилия], [Имя], [Отчество], [Подразделение], [Отдел], [Код_сотрудника]) VALUES (@Фамилия, @Имя, @Отчество, @Подразделение, @Отдел, @Код_сотрудника)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Подразделение" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Подразделение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отдел" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отдел" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Код_сотрудника" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код_сотрудника" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Фамилия, Имя, Отчество, Подразделение, Отдел, Код_сотрудника FROM Список_Сотрудников</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Подразделение" DataSetColumn="Подразделение" />
              <Mapping SourceColumn="Отдел" DataSetColumn="Отдел" />
              <Mapping SourceColumn="Код_сотрудника" DataSetColumn="Код_сотрудника" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ПодрФИоTableAdapter" GeneratorDataComponentClassName="ПодрФИоTableAdapter" Name="ПодрФИо" UserDataComponentName="ПодрФИоTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.dbo.ПодрФИо" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Фамилия, Подразделение FROM dbo.ПодрФИо</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <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="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.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].[Цель] ([Тип]) VALUES (@Тип)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Тип" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Тип" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Тип FROM dbo.Цель</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <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="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.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].[Подразделения] ([Подразделения]) VALUES (@Подразделения)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Подразделения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Подразделения" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Подразделения FROM dbo.Подразделения</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <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="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.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 (([Код] = @Original_Код) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Дата_Рождения = 1 AND [Дата_Рождения] IS NULL) OR ([Дата_Рождения] = @Original_Дата_Рождения)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" 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].[Пользователи] ([Фамилия], [Имя], [Отчество], [Email], [Дата_Рождения]) VALUES (@Фамилия, @Имя, @Отчество, @Email, @Дата_Рождения);
SELECT Код, Фамилия, Имя, Отчество, Email, Дата_Рождения FROM Пользователи WHERE (Код = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" 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 Код, Фамилия, Имя, Отчество, Email, Дата_Рождения FROM dbo.Пользователи</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Пользователи] SET [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество, [Email] = @Email, [Дата_Рождения] = @Дата_Рождения WHERE (([Код] = @Original_Код) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Дата_Рождения = 1 AND [Дата_Рождения] IS NULL) OR ([Дата_Рождения] = @Original_Дата_Рождения)));
SELECT Код, Фамилия, Имя, Отчество, Email, Дата_Рождения FROM Пользователи WHERE (Код = @Код)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Дата_Рождения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_Рождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_Рождения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_Рождения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Дата_Рождения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Дата_Рождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Код" ColumnName="Код" DataSourceName="LEBSes.dbo.Пользователи" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Код" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Код" DataSetColumn="Код" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <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="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.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 [Черный_Список] WHERE (([Код] = @Original_Код) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Черный_Список = 1 AND [Черный_Список] IS NULL) OR ([Черный_Список] = @Original_Черный_Список)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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="Boolean" Direction="Input" ParameterName="@Original_Черный_Список" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Черный_Список" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Черный_Список] ([Фамилия], [Имя], [Отчество], [Черный_Список]) VALUES (@Фамилия, @Имя, @Отчество, @Черный_Список);
SELECT Код, Фамилия, Имя, Отчество, Черный_Список FROM Черный_Список WHERE (Код = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Черный_Список" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Черный_Список" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Код, Фамилия, Имя, Отчество, Черный_Список FROM Черный_Список</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Черный_Список] SET [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество, [Черный_Список] = @Черный_Список WHERE (([Код] = @Original_Код) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Черный_Список = 1 AND [Черный_Список] IS NULL) OR ([Черный_Список] = @Original_Черный_Список)));
SELECT Код, Фамилия, Имя, Отчество, Черный_Список FROM Черный_Список WHERE (Код = @Код)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Черный_Список" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Черный_Список" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Код" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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="Boolean" Direction="Input" ParameterName="@Original_Черный_Список" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Черный_Список" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Код" ColumnName="Код" DataSourceName="LEBSes.dbo.Черный_Список" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Код" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Код" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Код" DataSetColumn="Код" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Черный_Список" DataSetColumn="Черный_Список" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ЧСПользTableAdapter" GeneratorDataComponentClassName="ЧСПользTableAdapter" Name="ЧСПольз" UserDataComponentName="ЧСПользTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.dbo.ЧСПольз" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Черный_Список, Фамилия, Имя, Отчество FROM dbo.ЧСПольз</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Черный_Список" DataSetColumn="Черный_Список" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ФотоTableAdapter" GeneratorDataComponentClassName="ФотоTableAdapter" Name="Фото" UserDataComponentName="ФотоTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LEBSesConnectionString (Settings)" DbObjectName="LEBSes.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].[Фото] ([Фото]) VALUES (@Фото)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Фото" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Фото" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Фото FROM dbo.Фото</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Фото" DataSetColumn="Фото" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="LEBSesDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="LEBSesDataSet" msprop:Generator_UserDSName="LEBSesDataSet">
    <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="ФИО" 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="Код_сотрудника" type="xs:int" />
              <xs:element name="ФИО_Клиента" msprop:Generator_ColumnVarNameInTable="columnФИО_Клиента" msprop:Generator_ColumnPropNameInRow="ФИО_Клиента" msprop:Generator_ColumnPropNameInTable="ФИО_КлиентаColumn" msprop:Generator_UserColumnName="ФИО_Клиента" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Срок_С" msprop:Generator_ColumnVarNameInTable="columnСрок_С" msprop:Generator_ColumnPropNameInRow="Срок_С" msprop:Generator_ColumnPropNameInTable="Срок_СColumn" msprop:Generator_UserColumnName="Срок_С" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Срок_По" msprop:Generator_ColumnVarNameInTable="columnСрок_По" msprop:Generator_ColumnPropNameInRow="Срок_По" msprop:Generator_ColumnPropNameInTable="Срок_ПоColumn" msprop:Generator_UserColumnName="Срок_По" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LoginDepartment" msprop:Generator_TableClassName="LoginDepartmentDataTable" msprop:Generator_TableVarName="tableLoginDepartment" msprop:Generator_RowChangedName="LoginDepartmentRowChanged" msprop:Generator_TablePropName="LoginDepartment" msprop:Generator_RowDeletingName="LoginDepartmentRowDeleting" msprop:Generator_RowChangingName="LoginDepartmentRowChanging" msprop:Generator_RowEvHandlerName="LoginDepartmentRowChangeEventHandler" msprop:Generator_RowDeletedName="LoginDepartmentRowDeleted" msprop:Generator_RowClassName="LoginDepartmentRow" msprop:Generator_UserTableName="LoginDepartment" msprop:Generator_RowEvArgName="LoginDepartmentRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_UserColumnName="Login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LoginGuard" msprop:Generator_TableClassName="LoginGuardDataTable" msprop:Generator_TableVarName="tableLoginGuard" msprop:Generator_RowChangedName="LoginGuardRowChanged" msprop:Generator_TablePropName="LoginGuard" msprop:Generator_RowDeletingName="LoginGuardRowDeleting" msprop:Generator_RowChangingName="LoginGuardRowChanging" msprop:Generator_RowEvHandlerName="LoginGuardRowChangeEventHandler" msprop:Generator_RowDeletedName="LoginGuardRowDeleted" msprop:Generator_RowClassName="LoginGuardRow" msprop:Generator_UserTableName="LoginGuard" msprop:Generator_RowEvArgName="LoginGuardRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_UserColumnName="Login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Role" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_TableVarName="tableRole" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_TablePropName="Role" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_RowClassName="RoleRow" msprop:Generator_UserTableName="Role" msprop:Generator_RowEvArgName="RoleRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Role" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_UserColumnName="Role" 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="LoginGeneral" msprop:Generator_TableClassName="LoginGeneralDataTable" msprop:Generator_TableVarName="tableLoginGeneral" msprop:Generator_TablePropName="LoginGeneral" msprop:Generator_RowDeletingName="LoginGeneralRowDeleting" msprop:Generator_RowChangingName="LoginGeneralRowChanging" msprop:Generator_RowEvHandlerName="LoginGeneralRowChangeEventHandler" msprop:Generator_RowDeletedName="LoginGeneralRowDeleted" msprop:Generator_UserTableName="LoginGeneral" msprop:Generator_RowChangedName="LoginGeneralRowChanged" msprop:Generator_RowEvArgName="LoginGeneralRowChangeEvent" msprop:Generator_RowClassName="LoginGeneralRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_UserColumnName="Login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LoginUser" msprop:Generator_TableClassName="LoginUserDataTable" msprop:Generator_TableVarName="tableLoginUser" msprop:Generator_TablePropName="LoginUser" msprop:Generator_RowDeletingName="LoginUserRowDeleting" msprop:Generator_RowChangingName="LoginUserRowChanging" msprop:Generator_RowEvHandlerName="LoginUserRowChangeEventHandler" msprop:Generator_RowDeletedName="LoginUserRowDeleted" msprop:Generator_UserTableName="LoginUser" msprop:Generator_RowChangedName="LoginUserRowChanged" msprop:Generator_RowEvArgName="LoginUserRowChangeEvent" msprop:Generator_RowClassName="LoginUserRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_UserColumnName="Login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Личное_x0020_Посещение" msprop:Generator_TableClassName="Личное_ПосещениеDataTable" msprop:Generator_TableVarName="tableЛичное_Посещение" msprop:Generator_RowChangedName="Личное_ПосещениеRowChanged" msprop:Generator_TablePropName="Личное_Посещение" msprop:Generator_RowDeletingName="Личное_ПосещениеRowDeleting" msprop:Generator_RowChangingName="Личное_ПосещениеRowChanging" msprop:Generator_RowEvHandlerName="Личное_ПосещениеRowChangeEventHandler" msprop:Generator_RowDeletedName="Личное_ПосещениеRowDeleted" msprop:Generator_RowClassName="Личное_ПосещениеRow" msprop:Generator_UserTableName="Личное Посещение" msprop:Generator_RowEvArgName="Личное_ПосещениеRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_UserColumnName="Фамилия" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="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="Номер_телефона" 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="E_mail" msprop:Generator_ColumnVarNameInTable="columnE_mail" msprop:Generator_ColumnPropNameInRow="E_mail" msprop:Generator_ColumnPropNameInTable="E_mailColumn" msprop:Generator_UserColumnName="E_mail" 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="Номер" 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="Назначение" 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="Статус" msprop:Generator_ColumnVarNameInTable="columnСтатус" msprop:Generator_ColumnPropNameInRow="Статус" msprop:Generator_ColumnPropNameInTable="СтатусColumn" msprop:Generator_UserColumnName="Статус" type="xs:boolean" minOccurs="0" />
              <xs:element name="Код" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnКод" msprop:Generator_ColumnPropNameInRow="Код" msprop:Generator_ColumnPropNameInTable="КодColumn" msprop:Generator_UserColumnName="Код" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Подразделение" msprop:Generator_TableClassName="ПодразделениеDataTable" msprop:Generator_TableVarName="tableПодразделение" msprop:Generator_RowChangedName="ПодразделениеRowChanged" msprop:Generator_TablePropName="Подразделение" msprop:Generator_RowDeletingName="ПодразделениеRowDeleting" msprop:Generator_RowChangingName="ПодразделениеRowChanging" msprop:Generator_RowEvHandlerName="ПодразделениеRowChangeEventHandler" msprop:Generator_RowDeletedName="ПодразделениеRowDeleted" msprop:Generator_RowClassName="ПодразделениеRow" msprop:Generator_UserTableName="Подразделение" msprop:Generator_RowEvArgName="ПодразделениеRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ФИО" msprop:Generator_ColumnVarNameInTable="columnФИО" msprop:Generator_ColumnPropNameInRow="ФИО" msprop:Generator_ColumnPropNameInTable="ФИОColumn" msprop:Generator_UserColumnName="ФИО" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="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="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_UserColumnName="Фамилия">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_UserColumnName="Имя">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Отчество" msprop:Generator_ColumnVarNameInTable="columnОтчество" msprop:Generator_ColumnPropNameInRow="Отчество" msprop:Generator_ColumnPropNameInTable="ОтчествоColumn" msprop:Generator_UserColumnName="Отчество">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Номер_телефона" msprop:Generator_ColumnVarNameInTable="columnНомер_телефона" msprop:Generator_ColumnPropNameInRow="Номер_телефона" msprop:Generator_ColumnPropNameInTable="Номер_телефонаColumn" msprop:Generator_UserColumnName="Номер_телефона">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E_mail" msprop:Generator_ColumnVarNameInTable="columnE_mail" msprop:Generator_ColumnPropNameInRow="E_mail" msprop:Generator_ColumnPropNameInTable="E_mailColumn" msprop:Generator_UserColumnName="E_mail">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Дата_рождения" msprop:Generator_ColumnVarNameInTable="columnДата_рождения" msprop:Generator_ColumnPropNameInRow="Дата_рождения" msprop:Generator_ColumnPropNameInTable="Дата_рожденияColumn" msprop:Generator_UserColumnName="Дата_рождения">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Серия" msprop:Generator_ColumnVarNameInTable="columnСерия" msprop:Generator_ColumnPropNameInRow="Серия" msprop:Generator_ColumnPropNameInTable="СерияColumn" msprop:Generator_UserColumnName="Серия">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Номер" msprop:Generator_ColumnVarNameInTable="columnНомер" msprop:Generator_ColumnPropNameInRow="Номер" msprop:Generator_ColumnPropNameInTable="НомерColumn" msprop:Generator_UserColumnName="Номер">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Группа" msprop:Generator_ColumnVarNameInTable="columnГруппа" msprop:Generator_ColumnPropNameInRow="Группа" msprop:Generator_ColumnPropNameInTable="ГруппаColumn" msprop:Generator_UserColumnName="Группа">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Назначение" msprop:Generator_ColumnVarNameInTable="columnНазначение" msprop:Generator_ColumnPropNameInRow="Назначение" msprop:Generator_ColumnPropNameInTable="НазначениеColumn" msprop:Generator_UserColumnName="Назначение">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Цель" msprop:Generator_ColumnVarNameInTable="columnЦель" msprop:Generator_ColumnPropNameInRow="Цель" msprop:Generator_ColumnPropNameInTable="ЦельColumn" msprop:Generator_UserColumnName="Цель" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Подразделение" msprop:Generator_ColumnVarNameInTable="columnПодразделение" msprop:Generator_ColumnPropNameInRow="Подразделение" msprop:Generator_ColumnPropNameInTable="ПодразделениеColumn" msprop:Generator_UserColumnName="Подразделение" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="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:boolean" 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="Фамилия" 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="Подразделение" 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="Код_сотрудника" 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="Фамилия" 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="Тип" 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_RowChangedName="ПодразделенияRowChanged" msprop:Generator_TablePropName="Подразделения" msprop:Generator_RowDeletingName="ПодразделенияRowDeleting" msprop:Generator_RowChangingName="ПодразделенияRowChanging" msprop:Generator_RowEvHandlerName="ПодразделенияRowChangeEventHandler" msprop:Generator_RowDeletedName="ПодразделенияRowDeleted" msprop:Generator_RowClassName="ПодразделенияRow" msprop:Generator_UserTableName="Подразделения" msprop:Generator_RowEvArgName="ПодразделенияRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Подразделения" msprop:Generator_ColumnVarNameInTable="columnПодразделения" msprop:Generator_ColumnPropNameInRow="Подразделения" msprop:Generator_ColumnPropNameInTable="ПодразделенияColumn" msprop:Generator_UserColumnName="Подразделения" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="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="Код" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnКод" msprop:Generator_ColumnPropNameInRow="Код" msprop:Generator_ColumnPropNameInTable="КодColumn" msprop:Generator_UserColumnName="Код" type="xs:int" />
              <xs:element name="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_UserColumnName="Фамилия" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_UserColumnName="Имя" 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="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" 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="Код" msprop:Generator_ColumnVarNameInTable="columnКод" msprop:Generator_ColumnPropNameInRow="Код" msprop:Generator_ColumnPropNameInTable="КодColumn" msprop:Generator_UserColumnName="Код" type="xs:int" />
              <xs:element name="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_UserColumnName="Фамилия" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_UserColumnName="Имя" 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="Черный_Список" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ЧСПольз" msprop:Generator_TableClassName="ЧСПользDataTable" msprop:Generator_TableVarName="tableЧСПольз" msprop:Generator_RowChangedName="ЧСПользRowChanged" msprop:Generator_TablePropName="ЧСПольз" msprop:Generator_RowDeletingName="ЧСПользRowDeleting" msprop:Generator_RowChangingName="ЧСПользRowChanging" msprop:Generator_RowEvHandlerName="ЧСПользRowChangeEventHandler" msprop:Generator_RowDeletedName="ЧСПользRowDeleted" msprop:Generator_RowClassName="ЧСПользRow" msprop:Generator_UserTableName="ЧСПольз" msprop:Generator_RowEvArgName="ЧСПользRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Черный_Список" msprop:Generator_ColumnVarNameInTable="columnЧерный_Список" msprop:Generator_ColumnPropNameInRow="Черный_Список" msprop:Generator_ColumnPropNameInTable="Черный_СписокColumn" msprop:Generator_UserColumnName="Черный_Список" type="xs:boolean" minOccurs="0" />
              <xs:element name="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_UserColumnName="Фамилия" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_UserColumnName="Имя" 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="Фото" msprop:Generator_ColumnVarNameInTable="columnФото" msprop:Generator_ColumnPropNameInRow="Фото" msprop:Generator_ColumnPropNameInTable="ФотоColumn" msprop:Generator_UserColumnName="Фото" type="xs:base64Binary" minOccurs="0" />
            </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:Код_сотрудника" />
    </xs:unique>
    <xs:unique name="Личное_x0020_Посещение_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Личное_x0020_Посещение" />
      <xs:field xpath="mstns:Код" />
    </xs:unique>
    <xs:unique name="Пользователи_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Пользователи" />
      <xs:field xpath="mstns:Код" />
    </xs:unique>
    <xs:unique name="Черный_Список_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Черный_Список" />
      <xs:field xpath="mstns:Код" />
    </xs:unique>
  </xs:element>
</xs:schema>