Lab2/ИсследованияБиоматериалаDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ИсследованияБиоматериалаDataSet" targetNamespace="http://tempuri.org/ИсследованияБиоматериалаDataSet.xsd" xmlns:mstns="http://tempuri.org/ИсследованияБиоматериалаDataSet.xsd" xmlns="http://tempuri.org/ИсследованияБиоматериалаDataSet.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="ИсследованияБиоматериалаConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ИсследованияБиоматериалаConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Laboratoria.Properties.Settings.GlobalReference.Default.ИсследованияБиоматериалаConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="services — копияTableAdapter" GeneratorDataComponentClassName="services___копияTableAdapter" Name="services — копия" UserDataComponentName="services — копияTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.[services — копия]" 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].[services — копия] WHERE (([Code] = @Original_Code) AND ([Service] = @Original_Service) AND ([Price] = @Original_Price))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Service" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Service" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[services — копия] ([Code], [Service], [Price]) VALUES (@Code, @Service, @Price);
SELECT Code, Service, Price FROM [services — копия] WHERE (Code = @Code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Service" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Service" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code, Service, Price FROM dbo.[services — копия]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[services — копия] SET [Code] = @Code, [Service] = @Service, [Price] = @Price WHERE (([Code] = @Original_Code) AND ([Service] = @Original_Service) AND ([Price] = @Original_Price));
SELECT Code, Service, Price FROM [services — копия] WHERE (Code = @Code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Service" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Service" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Service" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Service" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Service" DataSetColumn="Service" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="users — копияTableAdapter" GeneratorDataComponentClassName="users___копияTableAdapter" Name="users — копия" UserDataComponentName="users — копияTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.[users — копия]" 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].[users — копия] WHERE (([id] = @Original_id) AND ([name] = @Original_name) AND ([login] = @Original_login) AND ([password] = @Original_password) AND ([ip] = @Original_ip) AND ([lastenter] = @Original_lastenter) AND ([services] = @Original_services) AND ([type] = @Original_type))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ip" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_lastenter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="lastenter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_services" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="services" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[users — копия] ([id], [name], [login], [password], [ip], [lastenter], [services], [type]) VALUES (@id, @name, @login, @password, @ip, @lastenter, @services, @type);
SELECT id, name, login, password, ip, lastenter, services, type FROM [users — копия] WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ip" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@lastenter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="lastenter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@services" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="services" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, name, login, password, ip, lastenter, services, type FROM dbo.[users — копия]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[users — копия] SET [id] = @id, [name] = @name, [login] = @login, [password] = @password, [ip] = @ip, [lastenter] = @lastenter, [services] = @services, [type] = @type WHERE (([id] = @Original_id) AND ([name] = @Original_name) AND ([login] = @Original_login) AND ([password] = @Original_password) AND ([ip] = @Original_ip) AND ([lastenter] = @Original_lastenter) AND ([services] = @Original_services) AND ([type] = @Original_type));
SELECT id, name, login, password, ip, lastenter, services, type FROM [users — копия] WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ip" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@lastenter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="lastenter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@services" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="services" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ip" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_lastenter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="lastenter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_services" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="services" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="login" DataSetColumn="login" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="ip" DataSetColumn="ip" />
              <Mapping SourceColumn="lastenter" DataSetColumn="lastenter" />
              <Mapping SourceColumn="services" DataSetColumn="services" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="АдминистраторTableAdapter" GeneratorDataComponentClassName="АдминистраторTableAdapter" Name="Администратор" UserDataComponentName="АдминистраторTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.Администратор" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Администратор] WHERE (([ID_Администратора] = @Original_ID_Администратора) AND ((@IsNull_Логин = 1 AND [Логин] IS NULL) OR ([Логин] = @Original_Логин)) AND ((@IsNull_Пароль = 1 AND [Пароль] IS NULL) OR ([Пароль] = @Original_Пароль)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Администратора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Администратора" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Логин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Администратор] ([ID_Администратора], [Логин], [Пароль]) VALUES (@ID_Администратора, @Логин, @Пароль);
SELECT ID_Администратора, Логин, Пароль FROM Администратор WHERE (ID_Администратора = @ID_Администратора)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Администратора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Администратора" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Администратора, Логин, Пароль FROM dbo.Администратор</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Администратор] SET [ID_Администратора] = @ID_Администратора, [Логин] = @Логин, [Пароль] = @Пароль WHERE (([ID_Администратора] = @Original_ID_Администратора) AND ((@IsNull_Логин = 1 AND [Логин] IS NULL) OR ([Логин] = @Original_Логин)) AND ((@IsNull_Пароль = 1 AND [Пароль] IS NULL) OR ([Пароль] = @Original_Пароль)));
SELECT ID_Администратора, Логин, Пароль FROM Администратор WHERE (ID_Администратора = @ID_Администратора)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Администратора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Администратора" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Администратора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Администратора" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Логин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Администратора" DataSetColumn="ID_Администратора" />
              <Mapping SourceColumn="Логин" DataSetColumn="Логин" />
              <Mapping SourceColumn="Пароль" DataSetColumn="Пароль" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="АнализаторTableAdapter" GeneratorDataComponentClassName="АнализаторTableAdapter" Name="Анализатор" UserDataComponentName="АнализаторTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.Анализатор" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Анализатор] WHERE (([ID_Анализатора] = @Original_ID_Анализатора))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Анализатор] ([ID_Анализатора]) VALUES (@ID_Анализатора);
SELECT ID_Анализатора FROM Анализатор WHERE (ID_Анализатора = @ID_Анализатора)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Анализатора FROM dbo.Анализатор</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Анализатор] SET [ID_Анализатора] = @ID_Анализатора WHERE (([ID_Анализатора] = @Original_ID_Анализатора));
SELECT ID_Анализатора FROM Анализатор WHERE (ID_Анализатора = @ID_Анализатора)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Анализатора" DataSetColumn="ID_Анализатора" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="БухгалтерTableAdapter" GeneratorDataComponentClassName="БухгалтерTableAdapter" Name="Бухгалтер" UserDataComponentName="БухгалтерTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.Бухгалтер" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Бухгалтер] WHERE (([ID_Бухгалтера] = @Original_ID_Бухгалтера) AND ([ID_Услуги] = @Original_ID_Услуги))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Бухгалтера" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Бухгалтер] ([ID_Бухгалтера], [ID_Услуги]) VALUES (@ID_Бухгалтера, @ID_Услуги);
SELECT ID_Бухгалтера, ID_Услуги FROM Бухгалтер WHERE (ID_Бухгалтера = @ID_Бухгалтера)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Бухгалтера" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Бухгалтера, ID_Услуги FROM dbo.Бухгалтер</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Бухгалтер] SET [ID_Бухгалтера] = @ID_Бухгалтера, [ID_Услуги] = @ID_Услуги WHERE (([ID_Бухгалтера] = @Original_ID_Бухгалтера) AND ([ID_Услуги] = @Original_ID_Услуги));
SELECT ID_Бухгалтера, ID_Услуги FROM Бухгалтер WHERE (ID_Бухгалтера = @ID_Бухгалтера)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Бухгалтера" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Бухгалтера" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Бухгалтера" DataSetColumn="ID_Бухгалтера" />
              <Mapping SourceColumn="ID_Услуги" DataSetColumn="ID_Услуги" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ДанныеПациентовTableAdapter" GeneratorDataComponentClassName="ДанныеПациентовTableAdapter" Name="ДанныеПациентов" UserDataComponentName="ДанныеПациентовTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.ДанныеПациентов" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ДанныеПациентов] WHERE (([ID_Пациент] = @Original_ID_Пациент) AND ((@IsNull_логин = 1 AND [логин] IS NULL) OR ([логин] = @Original_логин)) AND ((@IsNull_пароль = 1 AND [пароль] IS NULL) OR ([пароль] = @Original_пароль)) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 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 ((@p3 = 1 AND [e-mail] IS NULL) OR ([e-mail] = @p2)) AND ((@IsNull_НомерСтраховогоПолиса = 1 AND [НомерСтраховогоПолиса] IS NULL) OR ([НомерСтраховогоПолиса] = @Original_НомерСтраховогоПолиса)) AND ((@IsNull_ТипСтраховогоПолиса = 1 AND [ТипСтраховогоПолиса] IS NULL) OR ([ТипСтраховогоПолиса] = @Original_ТипСтраховогоПолиса)) AND ((@IsNull_ID_Компании = 1 AND [ID_Компании] IS NULL) OR ([ID_Компании] = @Original_ID_Компании)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Пациент" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_логин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="логин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ДатаРождения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ДатаРождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_СерияИНомер_паспорта" 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="@p3" 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="@p2" 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_ID_Компании" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ДанныеПациентов] ([ID_Пациент], [логин], [пароль], [Фамилия], [Имя], [Отчество], [ДатаРождения], [СерияИНомер_паспорта], [Телефон], [e-mail], [НомерСтраховогоПолиса], [ТипСтраховогоПолиса], [ID_Компании]) VALUES (@ID_Пациент, @логин, @пароль, @Фамилия, @Имя, @Отчество, @ДатаРождения, @СерияИНомер_паспорта, @Телефон, @p1, @НомерСтраховогоПолиса, @ТипСтраховогоПолиса, @ID_Компании);
SELECT ID_Пациент, логин, пароль, Фамилия, Имя, Отчество, ДатаРождения, СерияИНомер_паспорта, Телефон, [e-mail], НомерСтраховогоПолиса, ТипСтраховогоПолиса, ID_Компании FROM ДанныеПациентов WHERE (ID_Пациент = @ID_Пациент)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Пациент" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ДатаРождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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="@p1" 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="Int64" Direction="Input" ParameterName="@ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Пациент, логин, пароль, Фамилия, Имя, Отчество, ДатаРождения, СерияИНомер_паспорта, Телефон, [e-mail], НомерСтраховогоПолиса, ТипСтраховогоПолиса, ID_Компании FROM dbo.ДанныеПациентов</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ДанныеПациентов] SET [ID_Пациент] = @ID_Пациент, [логин] = @логин, [пароль] = @пароль, [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество, [ДатаРождения] = @ДатаРождения, [СерияИНомер_паспорта] = @СерияИНомер_паспорта, [Телефон] = @Телефон, [e-mail] = @p1, [НомерСтраховогоПолиса] = @НомерСтраховогоПолиса, [ТипСтраховогоПолиса] = @ТипСтраховогоПолиса, [ID_Компании] = @ID_Компании WHERE (([ID_Пациент] = @Original_ID_Пациент) AND ((@IsNull_логин = 1 AND [логин] IS NULL) OR ([логин] = @Original_логин)) AND ((@IsNull_пароль = 1 AND [пароль] IS NULL) OR ([пароль] = @Original_пароль)) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 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 ((@p3 = 1 AND [e-mail] IS NULL) OR ([e-mail] = @p2)) AND ((@IsNull_НомерСтраховогоПолиса = 1 AND [НомерСтраховогоПолиса] IS NULL) OR ([НомерСтраховогоПолиса] = @Original_НомерСтраховогоПолиса)) AND ((@IsNull_ТипСтраховогоПолиса = 1 AND [ТипСтраховогоПолиса] IS NULL) OR ([ТипСтраховогоПолиса] = @Original_ТипСтраховогоПолиса)) AND ((@IsNull_ID_Компании = 1 AND [ID_Компании] IS NULL) OR ([ID_Компании] = @Original_ID_Компании)));
SELECT ID_Пациент, логин, пароль, Фамилия, Имя, Отчество, ДатаРождения, СерияИНомер_паспорта, Телефон, [e-mail], НомерСтраховогоПолиса, ТипСтраховогоПолиса, ID_Компании FROM ДанныеПациентов WHERE (ID_Пациент = @ID_Пациент)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Пациент" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ДатаРождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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="@p1" 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="Int64" Direction="Input" ParameterName="@ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Пациент" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_логин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="логин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ДатаРождения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ДатаРождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаРождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_СерияИНомер_паспорта" 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="@p3" 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="@p2" 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_ID_Компании" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Пациент" DataSetColumn="ID_Пациент" />
              <Mapping SourceColumn="логин" DataSetColumn="логин" />
              <Mapping SourceColumn="пароль" DataSetColumn="пароль" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <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="ID_Компании" DataSetColumn="ID_Компании" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ЗаказTableAdapter" GeneratorDataComponentClassName="ЗаказTableAdapter" Name="Заказ" UserDataComponentName="ЗаказTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.Заказ" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Заказ] WHERE (([ID_Заказа] = @Original_ID_Заказа) AND ((@IsNull_ДатаСоздания = 1 AND [ДатаСоздания] IS NULL) OR ([ДатаСоздания] = @Original_ДатаСоздания)) AND ((@IsNull_СтатусЗаказа = 1 AND [СтатусЗаказа] IS NULL) OR ([СтатусЗаказа] = @Original_СтатусЗаказа)) AND ((@IsNull_СтатусУслуги = 1 AND [СтатусУслуги] IS NULL) OR ([СтатусУслуги] = @Original_СтатусУслуги)) AND ((@IsNull_ВремяВыполнения = 1 AND [ВремяВыполнения] IS NULL) OR ([ВремяВыполнения] = @Original_ВремяВыполнения)) AND ((@IsNull_ID_Счета = 1 AND [ID_Счета] IS NULL) OR ([ID_Счета] = @Original_ID_Счета)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Заказа" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ДатаСоздания" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ДатаСоздания" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ДатаСоздания" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаСоздания" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_СтатусЗаказа" Precision="0" ProviderType="NChar" 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="StringFixedLength" Direction="Input" ParameterName="@Original_СтатусУслуги" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="СтатусУслуги" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ВремяВыполнения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ВремяВыполнения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ВремяВыполнения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ВремяВыполнения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Счета" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Счета" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Заказ] ([ID_Заказа], [ДатаСоздания], [СтатусЗаказа], [СтатусУслуги], [ВремяВыполнения], [ID_Счета]) VALUES (@ID_Заказа, @ДатаСоздания, @СтатусЗаказа, @СтатусУслуги, @ВремяВыполнения, @ID_Счета);
SELECT ID_Заказа, ДатаСоздания, СтатусЗаказа, СтатусУслуги, ВремяВыполнения, ID_Счета FROM Заказ WHERE (ID_Заказа = @ID_Заказа)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Заказа" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ДатаСоздания" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаСоздания" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@СтатусЗаказа" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@СтатусУслуги" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="СтатусУслуги" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="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="Int64" Direction="Input" ParameterName="@ID_Счета" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Заказа, ДатаСоздания, СтатусЗаказа, СтатусУслуги, ВремяВыполнения, ID_Счета FROM dbo.Заказ</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Заказ] SET [ID_Заказа] = @ID_Заказа, [ДатаСоздания] = @ДатаСоздания, [СтатусЗаказа] = @СтатусЗаказа, [СтатусУслуги] = @СтатусУслуги, [ВремяВыполнения] = @ВремяВыполнения, [ID_Счета] = @ID_Счета WHERE (([ID_Заказа] = @Original_ID_Заказа) AND ((@IsNull_ДатаСоздания = 1 AND [ДатаСоздания] IS NULL) OR ([ДатаСоздания] = @Original_ДатаСоздания)) AND ((@IsNull_СтатусЗаказа = 1 AND [СтатусЗаказа] IS NULL) OR ([СтатусЗаказа] = @Original_СтатусЗаказа)) AND ((@IsNull_СтатусУслуги = 1 AND [СтатусУслуги] IS NULL) OR ([СтатусУслуги] = @Original_СтатусУслуги)) AND ((@IsNull_ВремяВыполнения = 1 AND [ВремяВыполнения] IS NULL) OR ([ВремяВыполнения] = @Original_ВремяВыполнения)) AND ((@IsNull_ID_Счета = 1 AND [ID_Счета] IS NULL) OR ([ID_Счета] = @Original_ID_Счета)));
SELECT ID_Заказа, ДатаСоздания, СтатусЗаказа, СтатусУслуги, ВремяВыполнения, ID_Счета FROM Заказ WHERE (ID_Заказа = @ID_Заказа)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Заказа" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ДатаСоздания" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаСоздания" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@СтатусЗаказа" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@СтатусУслуги" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="СтатусУслуги" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="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="Int64" Direction="Input" ParameterName="@ID_Счета" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Заказа" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ДатаСоздания" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ДатаСоздания" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ДатаСоздания" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаСоздания" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_СтатусЗаказа" Precision="0" ProviderType="NChar" 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="StringFixedLength" Direction="Input" ParameterName="@Original_СтатусУслуги" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="СтатусУслуги" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ВремяВыполнения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ВремяВыполнения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ВремяВыполнения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ВремяВыполнения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Счета" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Счета" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Заказа" DataSetColumn="ID_Заказа" />
              <Mapping SourceColumn="ДатаСоздания" DataSetColumn="ДатаСоздания" />
              <Mapping SourceColumn="СтатусЗаказа" DataSetColumn="СтатусЗаказа" />
              <Mapping SourceColumn="СтатусУслуги" DataSetColumn="СтатусУслуги" />
              <Mapping SourceColumn="ВремяВыполнения" DataSetColumn="ВремяВыполнения" />
              <Mapping SourceColumn="ID_Счета" DataSetColumn="ID_Счета" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ЛаборантTableAdapter" GeneratorDataComponentClassName="ЛаборантTableAdapter" Name="Лаборант" UserDataComponentName="ЛаборантTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.Лаборант" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Лаборант] WHERE (([ID_Лаборанта] = @Original_ID_Лаборанта) AND ((@IsNull_Логин = 1 AND [Логин] IS NULL) OR ([Логин] = @Original_Логин)) AND ((@IsNull_Пароль = 1 AND [Пароль] IS NULL) OR ([Пароль] = @Original_Пароль)) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_ПоследняяДатаИВремяВхода = 1 AND [ПоследняяДатаИВремяВхода] IS NULL) OR ([ПоследняяДатаИВремяВхода] = @Original_ПоследняяДатаИВремяВхода)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Лаборанта" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Логин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ПоследняяДатаИВремяВхода" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ПоследняяДатаИВремяВхода" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ПоследняяДатаИВремяВхода" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ПоследняяДатаИВремяВхода" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Лаборант] ([ID_Лаборанта], [Логин], [Пароль], [Фамилия], [Имя], [Отчество], [ПоследняяДатаИВремяВхода]) VALUES (@ID_Лаборанта, @Логин, @Пароль, @Фамилия, @Имя, @Отчество, @ПоследняяДатаИВремяВхода);
SELECT ID_Лаборанта, Логин, Пароль, Фамилия, Имя, Отчество, ПоследняяДатаИВремяВхода FROM Лаборант WHERE (ID_Лаборанта = @ID_Лаборанта)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Лаборанта" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ПоследняяДатаИВремяВхода" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ПоследняяДатаИВремяВхода" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Лаборанта, Логин, Пароль, Фамилия, Имя, Отчество, ПоследняяДатаИВремяВхода FROM dbo.Лаборант</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Лаборант] SET [ID_Лаборанта] = @ID_Лаборанта, [Логин] = @Логин, [Пароль] = @Пароль, [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество, [ПоследняяДатаИВремяВхода] = @ПоследняяДатаИВремяВхода WHERE (([ID_Лаборанта] = @Original_ID_Лаборанта) AND ((@IsNull_Логин = 1 AND [Логин] IS NULL) OR ([Логин] = @Original_Логин)) AND ((@IsNull_Пароль = 1 AND [Пароль] IS NULL) OR ([Пароль] = @Original_Пароль)) AND ((@IsNull_Фамилия = 1 AND [Фамилия] IS NULL) OR ([Фамилия] = @Original_Фамилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_ПоследняяДатаИВремяВхода = 1 AND [ПоследняяДатаИВремяВхода] IS NULL) OR ([ПоследняяДатаИВремяВхода] = @Original_ПоследняяДатаИВремяВхода)));
SELECT ID_Лаборанта, Логин, Пароль, Фамилия, Имя, Отчество, ПоследняяДатаИВремяВхода FROM Лаборант WHERE (ID_Лаборанта = @ID_Лаборанта)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Лаборанта" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ПоследняяДатаИВремяВхода" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ПоследняяДатаИВремяВхода" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Лаборанта" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Логин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Логин" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Логин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фамилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ПоследняяДатаИВремяВхода" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ПоследняяДатаИВремяВхода" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ПоследняяДатаИВремяВхода" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ПоследняяДатаИВремяВхода" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Лаборанта" DataSetColumn="ID_Лаборанта" />
              <Mapping SourceColumn="Логин" DataSetColumn="Логин" />
              <Mapping SourceColumn="Пароль" DataSetColumn="Пароль" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="ПоследняяДатаИВремяВхода" DataSetColumn="ПоследняяДатаИВремяВхода" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ОказанныеУслугиTableAdapter" GeneratorDataComponentClassName="ОказанныеУслугиTableAdapter" Name="ОказанныеУслуги" UserDataComponentName="ОказанныеУслугиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.ОказанныеУслуги" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ОказанныеУслуги] WHERE (([ID_ОказанныхУслуг] = @Original_ID_ОказанныхУслуг) AND ((@IsNull_ID_Услуги = 1 AND [ID_Услуги] IS NULL) OR ([ID_Услуги] = @Original_ID_Услуги)) AND ((@IsNull_ID_Заказа = 1 AND [ID_Заказа] IS NULL) OR ([ID_Заказа] = @Original_ID_Заказа)) AND ((@IsNull_ID_Лаборанта = 1 AND [ID_Лаборанта] IS NULL) OR ([ID_Лаборанта] = @Original_ID_Лаборанта)) AND ((@IsNull_ID_Анализатора = 1 AND [ID_Анализатора] IS NULL) OR ([ID_Анализатора] = @Original_ID_Анализатора)) AND ((@IsNull_ID_Пациент = 1 AND [ID_Пациент] IS NULL) OR ([ID_Пациент] = @Original_ID_Пациент)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_ОказанныхУслуг" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Услуги" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Заказа" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Лаборанта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Лаборанта" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Анализатора" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Пациент" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Пациент" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ОказанныеУслуги] ([ID_ОказанныхУслуг], [ID_Услуги], [ID_Заказа], [ID_Лаборанта], [ID_Анализатора], [ID_Пациент]) VALUES (@ID_ОказанныхУслуг, @ID_Услуги, @ID_Заказа, @ID_Лаборанта, @ID_Анализатора, @ID_Пациент);
SELECT ID_ОказанныхУслуг, ID_Услуги, ID_Заказа, ID_Лаборанта, ID_Анализатора, ID_Пациент FROM ОказанныеУслуги WHERE (ID_ОказанныхУслуг = @ID_ОказанныхУслуг)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_ОказанныхУслуг" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Заказа" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Лаборанта" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Пациент" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_ОказанныхУслуг, ID_Услуги, ID_Заказа, ID_Лаборанта, ID_Анализатора, ID_Пациент FROM dbo.ОказанныеУслуги</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ОказанныеУслуги] SET [ID_ОказанныхУслуг] = @ID_ОказанныхУслуг, [ID_Услуги] = @ID_Услуги, [ID_Заказа] = @ID_Заказа, [ID_Лаборанта] = @ID_Лаборанта, [ID_Анализатора] = @ID_Анализатора, [ID_Пациент] = @ID_Пациент WHERE (([ID_ОказанныхУслуг] = @Original_ID_ОказанныхУслуг) AND ((@IsNull_ID_Услуги = 1 AND [ID_Услуги] IS NULL) OR ([ID_Услуги] = @Original_ID_Услуги)) AND ((@IsNull_ID_Заказа = 1 AND [ID_Заказа] IS NULL) OR ([ID_Заказа] = @Original_ID_Заказа)) AND ((@IsNull_ID_Лаборанта = 1 AND [ID_Лаборанта] IS NULL) OR ([ID_Лаборанта] = @Original_ID_Лаборанта)) AND ((@IsNull_ID_Анализатора = 1 AND [ID_Анализатора] IS NULL) OR ([ID_Анализатора] = @Original_ID_Анализатора)) AND ((@IsNull_ID_Пациент = 1 AND [ID_Пациент] IS NULL) OR ([ID_Пациент] = @Original_ID_Пациент)));
SELECT ID_ОказанныхУслуг, ID_Услуги, ID_Заказа, ID_Лаборанта, ID_Анализатора, ID_Пациент FROM ОказанныеУслуги WHERE (ID_ОказанныхУслуг = @ID_ОказанныхУслуг)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_ОказанныхУслуг" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Заказа" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Лаборанта" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Пациент" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_ОказанныхУслуг" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Услуги" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Заказа" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Лаборанта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Лаборанта" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Лаборанта" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Анализатора" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Пациент" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Пациент" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Пациент" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_ОказанныхУслуг" DataSetColumn="ID_ОказанныхУслуг" />
              <Mapping SourceColumn="ID_Услуги" DataSetColumn="ID_Услуги" />
              <Mapping SourceColumn="ID_Заказа" DataSetColumn="ID_Заказа" />
              <Mapping SourceColumn="ID_Лаборанта" DataSetColumn="ID_Лаборанта" />
              <Mapping SourceColumn="ID_Анализатора" DataSetColumn="ID_Анализатора" />
              <Mapping SourceColumn="ID_Пациент" DataSetColumn="ID_Пациент" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="РаботаАнализатораTableAdapter" GeneratorDataComponentClassName="РаботаАнализатораTableAdapter" Name="РаботаАнализатора" UserDataComponentName="РаботаАнализатораTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.РаботаАнализатора" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[РаботаАнализатора] WHERE (([ID_РаботАнализатора] = @Original_ID_РаботАнализатора) AND ((@IsNull_ID_Анализатора = 1 AND [ID_Анализатора] IS NULL) OR ([ID_Анализатора] = @Original_ID_Анализатора)) AND ((@IsNull_ID_ОказанныхУслуг = 1 AND [ID_ОказанныхУслуг] IS NULL) OR ([ID_ОказанныхУслуг] = @Original_ID_ОказанныхУслуг)) AND ((@IsNull_ДатаИВремяПоступленияЗаказа = 1 AND [ДатаИВремяПоступленияЗаказа] IS NULL) OR ([ДатаИВремяПоступленияЗаказа] = @Original_ДатаИВремяПоступленияЗаказа)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_РаботАнализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_РаботАнализатора" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Анализатора" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_ОказанныхУслуг" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_ОказанныхУслуг" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ДатаИВремяПоступленияЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ДатаИВремяПоступленияЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ДатаИВремяПоступленияЗаказа" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ДатаИВремяПоступленияЗаказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[РаботаАнализатора] ([ID_РаботАнализатора], [ID_Анализатора], [ID_ОказанныхУслуг], [ДатаИВремяПоступленияЗаказа]) VALUES (@ID_РаботАнализатора, @ID_Анализатора, @ID_ОказанныхУслуг, @ДатаИВремяПоступленияЗаказа);
SELECT ID_РаботАнализатора, ID_Анализатора, ID_ОказанныхУслуг, ДатаИВремяПоступленияЗаказа FROM РаботаАнализатора WHERE (ID_РаботАнализатора = @ID_РаботАнализатора)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_РаботАнализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_РаботАнализатора" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_ОказанныхУслуг" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ДатаИВремяПоступленияЗаказа" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ДатаИВремяПоступленияЗаказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_РаботАнализатора, ID_Анализатора, ID_ОказанныхУслуг, ДатаИВремяПоступленияЗаказа FROM dbo.РаботаАнализатора</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[РаботаАнализатора] SET [ID_РаботАнализатора] = @ID_РаботАнализатора, [ID_Анализатора] = @ID_Анализатора, [ID_ОказанныхУслуг] = @ID_ОказанныхУслуг, [ДатаИВремяПоступленияЗаказа] = @ДатаИВремяПоступленияЗаказа WHERE (([ID_РаботАнализатора] = @Original_ID_РаботАнализатора) AND ((@IsNull_ID_Анализатора = 1 AND [ID_Анализатора] IS NULL) OR ([ID_Анализатора] = @Original_ID_Анализатора)) AND ((@IsNull_ID_ОказанныхУслуг = 1 AND [ID_ОказанныхУслуг] IS NULL) OR ([ID_ОказанныхУслуг] = @Original_ID_ОказанныхУслуг)) AND ((@IsNull_ДатаИВремяПоступленияЗаказа = 1 AND [ДатаИВремяПоступленияЗаказа] IS NULL) OR ([ДатаИВремяПоступленияЗаказа] = @Original_ДатаИВремяПоступленияЗаказа)));
SELECT ID_РаботАнализатора, ID_Анализатора, ID_ОказанныхУслуг, ДатаИВремяПоступленияЗаказа FROM РаботаАнализатора WHERE (ID_РаботАнализатора = @ID_РаботАнализатора)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_РаботАнализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_РаботАнализатора" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_ОказанныхУслуг" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ДатаИВремяПоступленияЗаказа" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ДатаИВремяПоступленияЗаказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_РаботАнализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_РаботАнализатора" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Анализатора" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Анализатора" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Анализатора" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_ОказанныхУслуг" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_ОказанныхУслуг" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_ОказанныхУслуг" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ДатаИВремяПоступленияЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ДатаИВремяПоступленияЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ДатаИВремяПоступленияЗаказа" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ДатаИВремяПоступленияЗаказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_РаботАнализатора" DataSetColumn="ID_РаботАнализатора" />
              <Mapping SourceColumn="ID_Анализатора" DataSetColumn="ID_Анализатора" />
              <Mapping SourceColumn="ID_ОказанныхУслуг" DataSetColumn="ID_ОказанныхУслуг" />
              <Mapping SourceColumn="ДатаИВремяПоступленияЗаказа" DataSetColumn="ДатаИВремяПоступленияЗаказа" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="СтраховаяКомпанияTableAdapter" GeneratorDataComponentClassName="СтраховаяКомпанияTableAdapter" Name="СтраховаяКомпания" UserDataComponentName="СтраховаяКомпанияTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.СтраховаяКомпания" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[СтраховаяКомпания] WHERE (([ID_Компании] = @Original_ID_Компании) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)) AND ((@IsNull_Адрес = 1 AND [Адрес] IS NULL) OR ([Адрес] = @Original_Адрес)) AND ((@IsNull_ИНН = 1 AND [ИНН] IS NULL) OR ([ИНН] = @Original_ИНН)) AND ((@IsNull_PC = 1 AND [PC] IS NULL) OR ([PC] = @Original_PC)) AND ((@IsNull_БИК = 1 AND [БИК] IS NULL) OR ([БИК] = @Original_БИК)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Адрес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ИНН" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ИНН" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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_PC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_БИК" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="БИК" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_БИК" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="БИК" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[СтраховаяКомпания] ([ID_Компании], [Название], [Адрес], [ИНН], [PC], [БИК]) VALUES (@ID_Компании, @Название, @Адрес, @ИНН, @PC, @БИК);
SELECT ID_Компании, Название, Адрес, ИНН, PC, БИК FROM СтраховаяКомпания WHERE (ID_Компании = @ID_Компании)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ИНН" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ИНН" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@БИК" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="БИК" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Компании, Название, Адрес, ИНН, PC, БИК FROM dbo.СтраховаяКомпания</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[СтраховаяКомпания] SET [ID_Компании] = @ID_Компании, [Название] = @Название, [Адрес] = @Адрес, [ИНН] = @ИНН, [PC] = @PC, [БИК] = @БИК WHERE (([ID_Компании] = @Original_ID_Компании) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)) AND ((@IsNull_Адрес = 1 AND [Адрес] IS NULL) OR ([Адрес] = @Original_Адрес)) AND ((@IsNull_ИНН = 1 AND [ИНН] IS NULL) OR ([ИНН] = @Original_ИНН)) AND ((@IsNull_PC = 1 AND [PC] IS NULL) OR ([PC] = @Original_PC)) AND ((@IsNull_БИК = 1 AND [БИК] IS NULL) OR ([БИК] = @Original_БИК)));
SELECT ID_Компании, Название, Адрес, ИНН, PC, БИК FROM СтраховаяКомпания WHERE (ID_Компании = @ID_Компании)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ИНН" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ИНН" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PC" 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="Int64" Direction="Input" ParameterName="@Original_ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Адрес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ИНН" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ИНН" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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_PC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PC" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_БИК" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="БИК" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_БИК" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="БИК" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Компании" DataSetColumn="ID_Компании" />
              <Mapping SourceColumn="Название" DataSetColumn="Название" />
              <Mapping SourceColumn="Адрес" DataSetColumn="Адрес" />
              <Mapping SourceColumn="ИНН" DataSetColumn="ИНН" />
              <Mapping SourceColumn="PC" DataSetColumn="PC" />
              <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="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.Счета" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Счета] WHERE (([ID_Счета] = @Original_ID_Счета) AND ((@IsNull_ID_Бухгалтера = 1 AND [ID_Бухгалтера] IS NULL) OR ([ID_Бухгалтера] = @Original_ID_Бухгалтера)) AND ((@IsNull_ID_Компании = 1 AND [ID_Компании] IS NULL) OR ([ID_Компании] = @Original_ID_Компании)) AND ((@IsNull_Сумма = 1 AND [Сумма] IS NULL) OR ([Сумма] = @Original_Сумма)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Счета" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Бухгалтера" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Бухгалтера" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Компании" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Сумма" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Сумма" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Сумма" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Сумма" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Счета] ([ID_Счета], [ID_Бухгалтера], [ID_Компании], [Сумма]) VALUES (@ID_Счета, @ID_Бухгалтера, @ID_Компании, @Сумма);
SELECT ID_Счета, ID_Бухгалтера, ID_Компании, Сумма FROM Счета WHERE (ID_Счета = @ID_Счета)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Счета" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Бухгалтера" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Сумма" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Сумма" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Счета, ID_Бухгалтера, ID_Компании, Сумма FROM dbo.Счета</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Счета] SET [ID_Счета] = @ID_Счета, [ID_Бухгалтера] = @ID_Бухгалтера, [ID_Компании] = @ID_Компании, [Сумма] = @Сумма WHERE (([ID_Счета] = @Original_ID_Счета) AND ((@IsNull_ID_Бухгалтера = 1 AND [ID_Бухгалтера] IS NULL) OR ([ID_Бухгалтера] = @Original_ID_Бухгалтера)) AND ((@IsNull_ID_Компании = 1 AND [ID_Компании] IS NULL) OR ([ID_Компании] = @Original_ID_Компании)) AND ((@IsNull_Сумма = 1 AND [Сумма] IS NULL) OR ([Сумма] = @Original_Сумма)));
SELECT ID_Счета, ID_Бухгалтера, ID_Компании, Сумма FROM Счета WHERE (ID_Счета = @ID_Счета)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Счета" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Бухгалтера" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Сумма" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Сумма" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Счета" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Счета" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Бухгалтера" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Бухгалтера" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Бухгалтера" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Компании" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Компании" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Компании" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Сумма" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Сумма" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Сумма" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Сумма" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Счета" DataSetColumn="ID_Счета" />
              <Mapping SourceColumn="ID_Бухгалтера" DataSetColumn="ID_Бухгалтера" />
              <Mapping SourceColumn="ID_Компании" DataSetColumn="ID_Компании" />
              <Mapping SourceColumn="Сумма" DataSetColumn="Сумма" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="УслугиЛабораторииTableAdapter" GeneratorDataComponentClassName="УслугиЛабораторииTableAdapter" Name="УслугиЛаборатории" UserDataComponentName="УслугиЛабораторииTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.dbo.УслугиЛаборатории" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[УслугиЛаборатории] WHERE (([ID_Услуги] = @Original_ID_Услуги) AND ((@IsNull_Наименование = 1 AND [Наименование] IS NULL) OR ([Наименование] = @Original_Наименование)) AND ((@IsNull_Стоимость = 1 AND [Стоимость] IS NULL) OR ([Стоимость] = @Original_Стоимость)) AND ((@IsNull_СрокВыполнения = 1 AND [СрокВыполнения] IS NULL) OR ([СрокВыполнения] = @Original_СрокВыполнения)) AND ((@IsNull_СреднееОтклонение = 1 AND [СреднееОтклонение] IS NULL) OR ([СреднееОтклонение] = @Original_СреднееОтклонение)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Наименование" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Стоимость" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Стоимость" Precision="0" ProviderType="Money" 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="Currency" Direction="Input" ParameterName="@Original_СреднееОтклонение" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="СреднееОтклонение" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[УслугиЛаборатории] ([ID_Услуги], [Наименование], [Стоимость], [СрокВыполнения], [СреднееОтклонение]) VALUES (@ID_Услуги, @Наименование, @Стоимость, @СрокВыполнения, @СреднееОтклонение);
SELECT ID_Услуги, Наименование, Стоимость, СрокВыполнения, СреднееОтклонение FROM УслугиЛаборатории WHERE (ID_Услуги = @ID_Услуги)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Стоимость" Precision="0" ProviderType="Money" 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="Currency" Direction="Input" ParameterName="@СреднееОтклонение" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="СреднееОтклонение" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Услуги, Наименование, Стоимость, СрокВыполнения, СреднееОтклонение FROM dbo.УслугиЛаборатории</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[УслугиЛаборатории] SET [ID_Услуги] = @ID_Услуги, [Наименование] = @Наименование, [Стоимость] = @Стоимость, [СрокВыполнения] = @СрокВыполнения, [СреднееОтклонение] = @СреднееОтклонение WHERE (([ID_Услуги] = @Original_ID_Услуги) AND ((@IsNull_Наименование = 1 AND [Наименование] IS NULL) OR ([Наименование] = @Original_Наименование)) AND ((@IsNull_Стоимость = 1 AND [Стоимость] IS NULL) OR ([Стоимость] = @Original_Стоимость)) AND ((@IsNull_СрокВыполнения = 1 AND [СрокВыполнения] IS NULL) OR ([СрокВыполнения] = @Original_СрокВыполнения)) AND ((@IsNull_СреднееОтклонение = 1 AND [СреднееОтклонение] IS NULL) OR ([СреднееОтклонение] = @Original_СреднееОтклонение)));
SELECT ID_Услуги, Наименование, Стоимость, СрокВыполнения, СреднееОтклонение FROM УслугиЛаборатории WHERE (ID_Услуги = @ID_Услуги)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Стоимость" Precision="0" ProviderType="Money" 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="Currency" Direction="Input" ParameterName="@СреднееОтклонение" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="СреднееОтклонение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_Услуги" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_Услуги" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Наименование" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Стоимость" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Стоимость" Precision="0" ProviderType="Money" 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="Currency" Direction="Input" ParameterName="@Original_СреднееОтклонение" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="СреднееОтклонение" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Услуги" DataSetColumn="ID_Услуги" />
              <Mapping SourceColumn="Наименование" DataSetColumn="Наименование" />
              <Mapping SourceColumn="Стоимость" DataSetColumn="Стоимость" />
              <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="ИсследованияБиоматериалаConnectionString (Settings)" DbObjectName="ИсследованияБиоматериала.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 ID_Пациент, Фамилия, Имя, ДатаРождения, ID_Компании, ID_Лаборанта, ID_Услуги, ID_Заказа FROM dbo.отчёт</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Пациент" DataSetColumn="ID_Пациент" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="ДатаРождения" DataSetColumn="ДатаРождения" />
              <Mapping SourceColumn="ID_Компании" DataSetColumn="ID_Компании" />
              <Mapping SourceColumn="ID_Лаборанта" DataSetColumn="ID_Лаборанта" />
              <Mapping SourceColumn="ID_Услуги" DataSetColumn="ID_Услуги" />
              <Mapping SourceColumn="ID_Заказа" DataSetColumn="ID_Заказа" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ИсследованияБиоматериалаDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ИсследованияБиоматериалаDataSet" msprop:Generator_UserDSName="ИсследованияБиоматериалаDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="services_x0020__x2014__x0020_копия" msprop:Generator_TableClassName="_services___копияDataTable" msprop:Generator_TableVarName="_tableservices___копия" msprop:Generator_TablePropName="_services___копия" msprop:Generator_RowDeletingName="_services___копияRowDeleting" msprop:Generator_RowChangingName="_services___копияRowChanging" msprop:Generator_RowEvHandlerName="_services___копияRowChangeEventHandler" msprop:Generator_RowDeletedName="_services___копияRowDeleted" msprop:Generator_UserTableName="services — копия" msprop:Generator_RowChangedName="_services___копияRowChanged" msprop:Generator_RowEvArgName="_services___копияRowChangeEvent" msprop:Generator_RowClassName="_services___копияRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" msprop:Generator_UserColumnName="Code" type="xs:long" />
              <xs:element name="Service" msprop:Generator_ColumnVarNameInTable="columnService" msprop:Generator_ColumnPropNameInRow="Service" msprop:Generator_ColumnPropNameInTable="ServiceColumn" msprop:Generator_UserColumnName="Service">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price">
                <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="users_x0020__x2014__x0020_копия" msprop:Generator_TableClassName="_users___копияDataTable" msprop:Generator_TableVarName="_tableusers___копия" msprop:Generator_TablePropName="_users___копия" msprop:Generator_RowDeletingName="_users___копияRowDeleting" msprop:Generator_RowChangingName="_users___копияRowChanging" msprop:Generator_RowEvHandlerName="_users___копияRowChangeEventHandler" msprop:Generator_RowDeletedName="_users___копияRowDeleted" msprop:Generator_UserTableName="users — копия" msprop:Generator_RowChangedName="_users___копияRowChanged" msprop:Generator_RowEvArgName="_users___копияRowChangeEvent" msprop:Generator_RowClassName="_users___копияRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="login" msprop:Generator_ColumnVarNameInTable="columnlogin" msprop:Generator_ColumnPropNameInRow="login" msprop:Generator_ColumnPropNameInTable="loginColumn" msprop:Generator_UserColumnName="login">
                <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">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ip" msprop:Generator_ColumnVarNameInTable="columnip" msprop:Generator_ColumnPropNameInRow="ip" msprop:Generator_ColumnPropNameInTable="ipColumn" msprop:Generator_UserColumnName="ip">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lastenter" msprop:Generator_ColumnVarNameInTable="columnlastenter" msprop:Generator_ColumnPropNameInRow="lastenter" msprop:Generator_ColumnPropNameInTable="lastenterColumn" msprop:Generator_UserColumnName="lastenter">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="services" msprop:Generator_ColumnVarNameInTable="columnservices" msprop:Generator_ColumnPropNameInRow="services" msprop:Generator_ColumnPropNameInTable="servicesColumn" msprop:Generator_UserColumnName="services">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Администратор" msprop:Generator_TableClassName="АдминистраторDataTable" msprop:Generator_TableVarName="tableАдминистратор" msprop:Generator_TablePropName="Администратор" msprop:Generator_RowDeletingName="АдминистраторRowDeleting" msprop:Generator_RowChangingName="АдминистраторRowChanging" msprop:Generator_RowEvHandlerName="АдминистраторRowChangeEventHandler" msprop:Generator_RowDeletedName="АдминистраторRowDeleted" msprop:Generator_UserTableName="Администратор" msprop:Generator_RowChangedName="АдминистраторRowChanged" msprop:Generator_RowEvArgName="АдминистраторRowChangeEvent" msprop:Generator_RowClassName="АдминистраторRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Администратора" msprop:Generator_ColumnVarNameInTable="columnID_Администратора" msprop:Generator_ColumnPropNameInRow="ID_Администратора" msprop:Generator_ColumnPropNameInTable="ID_АдминистратораColumn" msprop:Generator_UserColumnName="ID_Администратора" type="xs:long" />
              <xs:element name="Логин" msprop:Generator_ColumnVarNameInTable="columnЛогин" msprop:Generator_ColumnPropNameInRow="Логин" msprop:Generator_ColumnPropNameInTable="ЛогинColumn" msprop:Generator_UserColumnName="Логин" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Пароль" msprop:Generator_ColumnVarNameInTable="columnПароль" msprop:Generator_ColumnPropNameInRow="Пароль" msprop:Generator_ColumnPropNameInTable="ПарольColumn" msprop:Generator_UserColumnName="Пароль" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Анализатор" msprop:Generator_TableClassName="АнализаторDataTable" msprop:Generator_TableVarName="tableАнализатор" msprop:Generator_TablePropName="Анализатор" msprop:Generator_RowDeletingName="АнализаторRowDeleting" msprop:Generator_RowChangingName="АнализаторRowChanging" msprop:Generator_RowEvHandlerName="АнализаторRowChangeEventHandler" msprop:Generator_RowDeletedName="АнализаторRowDeleted" msprop:Generator_UserTableName="Анализатор" msprop:Generator_RowChangedName="АнализаторRowChanged" msprop:Generator_RowEvArgName="АнализаторRowChangeEvent" msprop:Generator_RowClassName="АнализаторRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Анализатора" msprop:Generator_ColumnVarNameInTable="columnID_Анализатора" msprop:Generator_ColumnPropNameInRow="ID_Анализатора" msprop:Generator_ColumnPropNameInTable="ID_АнализатораColumn" msprop:Generator_UserColumnName="ID_Анализатора" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Бухгалтер" msprop:Generator_TableClassName="БухгалтерDataTable" msprop:Generator_TableVarName="tableБухгалтер" msprop:Generator_TablePropName="Бухгалтер" msprop:Generator_RowDeletingName="БухгалтерRowDeleting" msprop:Generator_RowChangingName="БухгалтерRowChanging" msprop:Generator_RowEvHandlerName="БухгалтерRowChangeEventHandler" msprop:Generator_RowDeletedName="БухгалтерRowDeleted" msprop:Generator_UserTableName="Бухгалтер" msprop:Generator_RowChangedName="БухгалтерRowChanged" msprop:Generator_RowEvArgName="БухгалтерRowChangeEvent" msprop:Generator_RowClassName="БухгалтерRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Бухгалтера" msprop:Generator_ColumnVarNameInTable="columnID_Бухгалтера" msprop:Generator_ColumnPropNameInRow="ID_Бухгалтера" msprop:Generator_ColumnPropNameInTable="ID_БухгалтераColumn" msprop:Generator_UserColumnName="ID_Бухгалтера" type="xs:long" />
              <xs:element name="ID_Услуги" msprop:Generator_ColumnVarNameInTable="columnID_Услуги" msprop:Generator_ColumnPropNameInRow="ID_Услуги" msprop:Generator_ColumnPropNameInTable="ID_УслугиColumn" msprop:Generator_UserColumnName="ID_Услуги" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ДанныеПациентов" msprop:Generator_TableClassName="ДанныеПациентовDataTable" msprop:Generator_TableVarName="tableДанныеПациентов" msprop:Generator_TablePropName="ДанныеПациентов" msprop:Generator_RowDeletingName="ДанныеПациентовRowDeleting" msprop:Generator_RowChangingName="ДанныеПациентовRowChanging" msprop:Generator_RowEvHandlerName="ДанныеПациентовRowChangeEventHandler" msprop:Generator_RowDeletedName="ДанныеПациентовRowDeleted" msprop:Generator_UserTableName="ДанныеПациентов" msprop:Generator_RowChangedName="ДанныеПациентовRowChanged" msprop:Generator_RowEvArgName="ДанныеПациентовRowChangeEvent" msprop:Generator_RowClassName="ДанныеПациентовRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Пациент" msprop:Generator_ColumnVarNameInTable="columnID_Пациент" msprop:Generator_ColumnPropNameInRow="ID_Пациент" msprop:Generator_ColumnPropNameInTable="ID_ПациентColumn" msprop:Generator_UserColumnName="ID_Пациент" type="xs:long" />
              <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:dateTime" 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="11" />
                  </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="ID_Компании" msprop:Generator_ColumnVarNameInTable="columnID_Компании" msprop:Generator_ColumnPropNameInRow="ID_Компании" msprop:Generator_ColumnPropNameInTable="ID_КомпанииColumn" msprop:Generator_UserColumnName="ID_Компании" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Заказ" msprop:Generator_TableClassName="ЗаказDataTable" msprop:Generator_TableVarName="tableЗаказ" msprop:Generator_TablePropName="Заказ" msprop:Generator_RowDeletingName="ЗаказRowDeleting" msprop:Generator_RowChangingName="ЗаказRowChanging" msprop:Generator_RowEvHandlerName="ЗаказRowChangeEventHandler" msprop:Generator_RowDeletedName="ЗаказRowDeleted" msprop:Generator_UserTableName="Заказ" msprop:Generator_RowChangedName="ЗаказRowChanged" msprop:Generator_RowEvArgName="ЗаказRowChangeEvent" msprop:Generator_RowClassName="ЗаказRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Заказа" msprop:Generator_ColumnVarNameInTable="columnID_Заказа" msprop:Generator_ColumnPropNameInRow="ID_Заказа" msprop:Generator_ColumnPropNameInTable="ID_ЗаказаColumn" msprop:Generator_UserColumnName="ID_Заказа" type="xs:long" />
              <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="СтатусЗаказа" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </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="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ВремяВыполнения" msprop:Generator_ColumnVarNameInTable="columnВремяВыполнения" msprop:Generator_ColumnPropNameInRow="ВремяВыполнения" msprop:Generator_ColumnPropNameInTable="ВремяВыполненияColumn" msprop:Generator_UserColumnName="ВремяВыполнения" type="xs:int" minOccurs="0" />
              <xs:element name="ID_Счета" msprop:Generator_ColumnVarNameInTable="columnID_Счета" msprop:Generator_ColumnPropNameInRow="ID_Счета" msprop:Generator_ColumnPropNameInTable="ID_СчетаColumn" msprop:Generator_UserColumnName="ID_Счета" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Лаборант" msprop:Generator_TableClassName="ЛаборантDataTable" msprop:Generator_TableVarName="tableЛаборант" msprop:Generator_TablePropName="Лаборант" msprop:Generator_RowDeletingName="ЛаборантRowDeleting" msprop:Generator_RowChangingName="ЛаборантRowChanging" msprop:Generator_RowEvHandlerName="ЛаборантRowChangeEventHandler" msprop:Generator_RowDeletedName="ЛаборантRowDeleted" msprop:Generator_UserTableName="Лаборант" msprop:Generator_RowChangedName="ЛаборантRowChanged" msprop:Generator_RowEvArgName="ЛаборантRowChangeEvent" msprop:Generator_RowClassName="ЛаборантRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Лаборанта" msprop:Generator_ColumnVarNameInTable="columnID_Лаборанта" msprop:Generator_ColumnPropNameInRow="ID_Лаборанта" msprop:Generator_ColumnPropNameInTable="ID_ЛаборантаColumn" msprop:Generator_UserColumnName="ID_Лаборанта" type="xs:long" />
              <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:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ОказанныеУслуги" msprop:Generator_TableClassName="ОказанныеУслугиDataTable" msprop:Generator_TableVarName="tableОказанныеУслуги" msprop:Generator_TablePropName="ОказанныеУслуги" msprop:Generator_RowDeletingName="ОказанныеУслугиRowDeleting" msprop:Generator_RowChangingName="ОказанныеУслугиRowChanging" msprop:Generator_RowEvHandlerName="ОказанныеУслугиRowChangeEventHandler" msprop:Generator_RowDeletedName="ОказанныеУслугиRowDeleted" msprop:Generator_UserTableName="ОказанныеУслуги" msprop:Generator_RowChangedName="ОказанныеУслугиRowChanged" msprop:Generator_RowEvArgName="ОказанныеУслугиRowChangeEvent" msprop:Generator_RowClassName="ОказанныеУслугиRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_ОказанныхУслуг" msprop:Generator_ColumnVarNameInTable="columnID_ОказанныхУслуг" msprop:Generator_ColumnPropNameInRow="ID_ОказанныхУслуг" msprop:Generator_ColumnPropNameInTable="ID_ОказанныхУслугColumn" msprop:Generator_UserColumnName="ID_ОказанныхУслуг" type="xs:long" />
              <xs:element name="ID_Услуги" msprop:Generator_ColumnVarNameInTable="columnID_Услуги" msprop:Generator_ColumnPropNameInRow="ID_Услуги" msprop:Generator_ColumnPropNameInTable="ID_УслугиColumn" msprop:Generator_UserColumnName="ID_Услуги" type="xs:long" minOccurs="0" />
              <xs:element name="ID_Заказа" msprop:Generator_ColumnVarNameInTable="columnID_Заказа" msprop:Generator_ColumnPropNameInRow="ID_Заказа" msprop:Generator_ColumnPropNameInTable="ID_ЗаказаColumn" msprop:Generator_UserColumnName="ID_Заказа" type="xs:long" minOccurs="0" />
              <xs:element name="ID_Лаборанта" msprop:Generator_ColumnVarNameInTable="columnID_Лаборанта" msprop:Generator_ColumnPropNameInRow="ID_Лаборанта" msprop:Generator_ColumnPropNameInTable="ID_ЛаборантаColumn" msprop:Generator_UserColumnName="ID_Лаборанта" type="xs:long" minOccurs="0" />
              <xs:element name="ID_Анализатора" msprop:Generator_ColumnVarNameInTable="columnID_Анализатора" msprop:Generator_ColumnPropNameInRow="ID_Анализатора" msprop:Generator_ColumnPropNameInTable="ID_АнализатораColumn" msprop:Generator_UserColumnName="ID_Анализатора" type="xs:long" minOccurs="0" />
              <xs:element name="ID_Пациент" msprop:Generator_ColumnVarNameInTable="columnID_Пациент" msprop:Generator_ColumnPropNameInRow="ID_Пациент" msprop:Generator_ColumnPropNameInTable="ID_ПациентColumn" msprop:Generator_UserColumnName="ID_Пациент" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="РаботаАнализатора" msprop:Generator_TableClassName="РаботаАнализатораDataTable" msprop:Generator_TableVarName="tableРаботаАнализатора" msprop:Generator_TablePropName="РаботаАнализатора" msprop:Generator_RowDeletingName="РаботаАнализатораRowDeleting" msprop:Generator_RowChangingName="РаботаАнализатораRowChanging" msprop:Generator_RowEvHandlerName="РаботаАнализатораRowChangeEventHandler" msprop:Generator_RowDeletedName="РаботаАнализатораRowDeleted" msprop:Generator_UserTableName="РаботаАнализатора" msprop:Generator_RowChangedName="РаботаАнализатораRowChanged" msprop:Generator_RowEvArgName="РаботаАнализатораRowChangeEvent" msprop:Generator_RowClassName="РаботаАнализатораRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_РаботАнализатора" msprop:Generator_ColumnVarNameInTable="columnID_РаботАнализатора" msprop:Generator_ColumnPropNameInRow="ID_РаботАнализатора" msprop:Generator_ColumnPropNameInTable="ID_РаботАнализатораColumn" msprop:Generator_UserColumnName="ID_РаботАнализатора" type="xs:long" />
              <xs:element name="ID_Анализатора" msprop:Generator_ColumnVarNameInTable="columnID_Анализатора" msprop:Generator_ColumnPropNameInRow="ID_Анализатора" msprop:Generator_ColumnPropNameInTable="ID_АнализатораColumn" msprop:Generator_UserColumnName="ID_Анализатора" type="xs:long" minOccurs="0" />
              <xs:element name="ID_ОказанныхУслуг" msprop:Generator_ColumnVarNameInTable="columnID_ОказанныхУслуг" msprop:Generator_ColumnPropNameInRow="ID_ОказанныхУслуг" msprop:Generator_ColumnPropNameInTable="ID_ОказанныхУслугColumn" msprop:Generator_UserColumnName="ID_ОказанныхУслуг" type="xs:long" minOccurs="0" />
              <xs:element name="ДатаИВремяПоступленияЗаказа" msprop:Generator_ColumnVarNameInTable="columnДатаИВремяПоступленияЗаказа" msprop:Generator_ColumnPropNameInRow="ДатаИВремяПоступленияЗаказа" msprop:Generator_ColumnPropNameInTable="ДатаИВремяПоступленияЗаказаColumn" msprop:Generator_UserColumnName="ДатаИВремяПоступленияЗаказа" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="СтраховаяКомпания" msprop:Generator_TableClassName="СтраховаяКомпанияDataTable" msprop:Generator_TableVarName="tableСтраховаяКомпания" msprop:Generator_TablePropName="СтраховаяКомпания" msprop:Generator_RowDeletingName="СтраховаяКомпанияRowDeleting" msprop:Generator_RowChangingName="СтраховаяКомпанияRowChanging" msprop:Generator_RowEvHandlerName="СтраховаяКомпанияRowChangeEventHandler" msprop:Generator_RowDeletedName="СтраховаяКомпанияRowDeleted" msprop:Generator_UserTableName="СтраховаяКомпания" msprop:Generator_RowChangedName="СтраховаяКомпанияRowChanged" msprop:Generator_RowEvArgName="СтраховаяКомпанияRowChangeEvent" msprop:Generator_RowClassName="СтраховаяКомпанияRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Компании" msprop:Generator_ColumnVarNameInTable="columnID_Компании" msprop:Generator_ColumnPropNameInRow="ID_Компании" msprop:Generator_ColumnPropNameInTable="ID_КомпанииColumn" msprop:Generator_UserColumnName="ID_Компании" type="xs:long" />
              <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:element name="PC" msprop:Generator_ColumnVarNameInTable="columnPC" msprop:Generator_ColumnPropNameInRow="PC" msprop:Generator_ColumnPropNameInTable="PCColumn" msprop:Generator_UserColumnName="PC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="БИК" msprop:Generator_ColumnVarNameInTable="columnБИК" msprop:Generator_ColumnPropNameInRow="БИК" msprop:Generator_ColumnPropNameInTable="БИКColumn" msprop:Generator_UserColumnName="БИК" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Счета" msprop:Generator_TableClassName="СчетаDataTable" msprop:Generator_TableVarName="tableСчета" msprop:Generator_TablePropName="Счета" msprop:Generator_RowDeletingName="СчетаRowDeleting" msprop:Generator_RowChangingName="СчетаRowChanging" msprop:Generator_RowEvHandlerName="СчетаRowChangeEventHandler" msprop:Generator_RowDeletedName="СчетаRowDeleted" msprop:Generator_UserTableName="Счета" msprop:Generator_RowChangedName="СчетаRowChanged" msprop:Generator_RowEvArgName="СчетаRowChangeEvent" msprop:Generator_RowClassName="СчетаRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Счета" msprop:Generator_ColumnVarNameInTable="columnID_Счета" msprop:Generator_ColumnPropNameInRow="ID_Счета" msprop:Generator_ColumnPropNameInTable="ID_СчетаColumn" msprop:Generator_UserColumnName="ID_Счета" type="xs:long" />
              <xs:element name="ID_Бухгалтера" msprop:Generator_ColumnVarNameInTable="columnID_Бухгалтера" msprop:Generator_ColumnPropNameInRow="ID_Бухгалтера" msprop:Generator_ColumnPropNameInTable="ID_БухгалтераColumn" msprop:Generator_UserColumnName="ID_Бухгалтера" type="xs:long" minOccurs="0" />
              <xs:element name="ID_Компании" msprop:Generator_ColumnVarNameInTable="columnID_Компании" msprop:Generator_ColumnPropNameInRow="ID_Компании" msprop:Generator_ColumnPropNameInTable="ID_КомпанииColumn" msprop:Generator_UserColumnName="ID_Компании" type="xs:long" minOccurs="0" />
              <xs:element name="Сумма" msprop:Generator_ColumnVarNameInTable="columnСумма" msprop:Generator_ColumnPropNameInRow="Сумма" msprop:Generator_ColumnPropNameInTable="СуммаColumn" msprop:Generator_UserColumnName="Сумма" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="УслугиЛаборатории" msprop:Generator_TableClassName="УслугиЛабораторииDataTable" msprop:Generator_TableVarName="tableУслугиЛаборатории" msprop:Generator_TablePropName="УслугиЛаборатории" msprop:Generator_RowDeletingName="УслугиЛабораторииRowDeleting" msprop:Generator_RowChangingName="УслугиЛабораторииRowChanging" msprop:Generator_RowEvHandlerName="УслугиЛабораторииRowChangeEventHandler" msprop:Generator_RowDeletedName="УслугиЛабораторииRowDeleted" msprop:Generator_UserTableName="УслугиЛаборатории" msprop:Generator_RowChangedName="УслугиЛабораторииRowChanged" msprop:Generator_RowEvArgName="УслугиЛабораторииRowChangeEvent" msprop:Generator_RowClassName="УслугиЛабораторииRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Услуги" msprop:Generator_ColumnVarNameInTable="columnID_Услуги" msprop:Generator_ColumnPropNameInRow="ID_Услуги" msprop:Generator_ColumnPropNameInTable="ID_УслугиColumn" msprop:Generator_UserColumnName="ID_Услуги" type="xs:long" />
              <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:decimal" minOccurs="0" />
              <xs:element name="СрокВыполнения" msprop:Generator_ColumnVarNameInTable="columnСрокВыполнения" msprop:Generator_ColumnPropNameInRow="СрокВыполнения" msprop:Generator_ColumnPropNameInTable="СрокВыполненияColumn" msprop:Generator_UserColumnName="СрокВыполнения" type="xs:dateTime" minOccurs="0" />
              <xs:element name="СреднееОтклонение" msprop:Generator_ColumnVarNameInTable="columnСреднееОтклонение" msprop:Generator_ColumnPropNameInRow="СреднееОтклонение" msprop:Generator_ColumnPropNameInTable="СреднееОтклонениеColumn" msprop:Generator_UserColumnName="СреднееОтклонение" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="отчёт" msprop:Generator_TableClassName="отчётDataTable" msprop:Generator_TableVarName="tableотчёт" msprop:Generator_TablePropName="отчёт" msprop:Generator_RowDeletingName="отчётRowDeleting" msprop:Generator_RowChangingName="отчётRowChanging" msprop:Generator_RowEvHandlerName="отчётRowChangeEventHandler" msprop:Generator_RowDeletedName="отчётRowDeleted" msprop:Generator_UserTableName="отчёт" msprop:Generator_RowChangedName="отчётRowChanged" msprop:Generator_RowEvArgName="отчётRowChangeEvent" msprop:Generator_RowClassName="отчётRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Пациент" msprop:Generator_ColumnVarNameInTable="columnID_Пациент" msprop:Generator_ColumnPropNameInRow="ID_Пациент" msprop:Generator_ColumnPropNameInTable="ID_ПациентColumn" msprop:Generator_UserColumnName="ID_Пациент" type="xs:long" />
              <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:dateTime" minOccurs="0" />
              <xs:element name="ID_Компании" msprop:Generator_ColumnVarNameInTable="columnID_Компании" msprop:Generator_ColumnPropNameInRow="ID_Компании" msprop:Generator_ColumnPropNameInTable="ID_КомпанииColumn" msprop:Generator_UserColumnName="ID_Компании" type="xs:long" minOccurs="0" />
              <xs:element name="ID_Лаборанта" msprop:Generator_ColumnVarNameInTable="columnID_Лаборанта" msprop:Generator_ColumnPropNameInRow="ID_Лаборанта" msprop:Generator_ColumnPropNameInTable="ID_ЛаборантаColumn" msprop:Generator_UserColumnName="ID_Лаборанта" type="xs:long" />
              <xs:element name="ID_Услуги" msprop:Generator_ColumnVarNameInTable="columnID_Услуги" msprop:Generator_ColumnPropNameInRow="ID_Услуги" msprop:Generator_ColumnPropNameInTable="ID_УслугиColumn" msprop:Generator_UserColumnName="ID_Услуги" type="xs:long" minOccurs="0" />
              <xs:element name="ID_Заказа" msprop:Generator_ColumnVarNameInTable="columnID_Заказа" msprop:Generator_ColumnPropNameInRow="ID_Заказа" msprop:Generator_ColumnPropNameInTable="ID_ЗаказаColumn" msprop:Generator_UserColumnName="ID_Заказа" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:services_x0020__x2014__x0020_копия" />
      <xs:field xpath="mstns:Code" />
    </xs:unique>
    <xs:unique name="users_x0020__x2014__x0020_копия_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:users_x0020__x2014__x0020_копия" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Администратор_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Администратор" />
      <xs:field xpath="mstns:ID_Администратора" />
    </xs:unique>
    <xs:unique name="Анализатор_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Анализатор" />
      <xs:field xpath="mstns:ID_Анализатора" />
    </xs:unique>
    <xs:unique name="Бухгалтер_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Бухгалтер" />
      <xs:field xpath="mstns:ID_Бухгалтера" />
    </xs:unique>
    <xs:unique name="ДанныеПациентов_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ДанныеПациентов" />
      <xs:field xpath="mstns:ID_Пациент" />
    </xs:unique>
    <xs:unique name="Заказ_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Заказ" />
      <xs:field xpath="mstns:ID_Заказа" />
    </xs:unique>
    <xs:unique name="Лаборант_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Лаборант" />
      <xs:field xpath="mstns:ID_Лаборанта" />
    </xs:unique>
    <xs:unique name="ОказанныеУслуги_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ОказанныеУслуги" />
      <xs:field xpath="mstns:ID_ОказанныхУслуг" />
    </xs:unique>
    <xs:unique name="РаботаАнализатора_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:РаботаАнализатора" />
      <xs:field xpath="mstns:ID_РаботАнализатора" />
    </xs:unique>
    <xs:unique name="СтраховаяКомпания_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:СтраховаяКомпания" />
      <xs:field xpath="mstns:ID_Компании" />
    </xs:unique>
    <xs:unique name="Счета_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Счета" />
      <xs:field xpath="mstns:ID_Счета" />
    </xs:unique>
    <xs:unique name="УслугиЛаборатории_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:УслугиЛаборатории" />
      <xs:field xpath="mstns:ID_Услуги" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Бухгалтер_УслугиЛаборатории" msdata:parent="УслугиЛаборатории" msdata:child="Бухгалтер" msdata:parentkey="ID_Услуги" msdata:childkey="ID_Услуги" msprop:Generator_UserChildTable="Бухгалтер" msprop:Generator_ChildPropName="GetБухгалтерRows" msprop:Generator_UserRelationName="FK_Бухгалтер_УслугиЛаборатории" msprop:Generator_RelationVarName="relationFK_Бухгалтер_УслугиЛаборатории" msprop:Generator_UserParentTable="УслугиЛаборатории" msprop:Generator_ParentPropName="УслугиЛабораторииRow" />
      <msdata:Relationship name="FK_ДанныеПациентов_СтраховаяКомпания" msdata:parent="СтраховаяКомпания" msdata:child="ДанныеПациентов" msdata:parentkey="ID_Компании" msdata:childkey="ID_Компании" msprop:Generator_UserChildTable="ДанныеПациентов" msprop:Generator_ChildPropName="GetДанныеПациентовRows" msprop:Generator_UserRelationName="FK_ДанныеПациентов_СтраховаяКомпания" msprop:Generator_RelationVarName="relationFK_ДанныеПациентов_СтраховаяКомпания" msprop:Generator_UserParentTable="СтраховаяКомпания" msprop:Generator_ParentPropName="СтраховаяКомпанияRow" />
      <msdata:Relationship name="FK_Заказ_Счета" msdata:parent="Счета" msdata:child="Заказ" msdata:parentkey="ID_Счета" msdata:childkey="ID_Счета" msprop:Generator_UserChildTable="Заказ" msprop:Generator_ChildPropName="GetЗаказRows" msprop:Generator_UserRelationName="FK_Заказ_Счета" msprop:Generator_RelationVarName="relationFK_Заказ_Счета" msprop:Generator_UserParentTable="Счета" msprop:Generator_ParentPropName="СчетаRow" />
      <msdata:Relationship name="FK_ОказанныеУслуги_Анализатор" msdata:parent="Анализатор" msdata:child="ОказанныеУслуги" msdata:parentkey="ID_Анализатора" msdata:childkey="ID_Анализатора" msprop:Generator_UserChildTable="ОказанныеУслуги" msprop:Generator_ChildPropName="GetОказанныеУслугиRows" msprop:Generator_UserRelationName="FK_ОказанныеУслуги_Анализатор" msprop:Generator_ParentPropName="АнализаторRow" msprop:Generator_RelationVarName="relationFK_ОказанныеУслуги_Анализатор" msprop:Generator_UserParentTable="Анализатор" />
      <msdata:Relationship name="FK_ОказанныеУслуги_ДанныеПациентов" msdata:parent="ДанныеПациентов" msdata:child="ОказанныеУслуги" msdata:parentkey="ID_Пациент" msdata:childkey="ID_Пациент" msprop:Generator_UserChildTable="ОказанныеУслуги" msprop:Generator_ChildPropName="GetОказанныеУслугиRows" msprop:Generator_UserRelationName="FK_ОказанныеУслуги_ДанныеПациентов" msprop:Generator_ParentPropName="ДанныеПациентовRow" msprop:Generator_RelationVarName="relationFK_ОказанныеУслуги_ДанныеПациентов" msprop:Generator_UserParentTable="ДанныеПациентов" />
      <msdata:Relationship name="FK_ОказанныеУслуги_Заказ" msdata:parent="Заказ" msdata:child="ОказанныеУслуги" msdata:parentkey="ID_Заказа" msdata:childkey="ID_Заказа" msprop:Generator_UserChildTable="ОказанныеУслуги" msprop:Generator_ChildPropName="GetОказанныеУслугиRows" msprop:Generator_UserRelationName="FK_ОказанныеУслуги_Заказ" msprop:Generator_ParentPropName="ЗаказRow" msprop:Generator_RelationVarName="relationFK_ОказанныеУслуги_Заказ" msprop:Generator_UserParentTable="Заказ" />
      <msdata:Relationship name="FK_ОказанныеУслуги_Лаборант" msdata:parent="Лаборант" msdata:child="ОказанныеУслуги" msdata:parentkey="ID_Лаборанта" msdata:childkey="ID_Лаборанта" msprop:Generator_UserChildTable="ОказанныеУслуги" msprop:Generator_ChildPropName="GetОказанныеУслугиRows" msprop:Generator_UserRelationName="FK_ОказанныеУслуги_Лаборант" msprop:Generator_ParentPropName="ЛаборантRow" msprop:Generator_RelationVarName="relationFK_ОказанныеУслуги_Лаборант" msprop:Generator_UserParentTable="Лаборант" />
      <msdata:Relationship name="FK_ОказанныеУслуги_УслугиЛаборатории" msdata:parent="УслугиЛаборатории" msdata:child="ОказанныеУслуги" msdata:parentkey="ID_Услуги" msdata:childkey="ID_Услуги" msprop:Generator_UserChildTable="ОказанныеУслуги" msprop:Generator_ChildPropName="GetОказанныеУслугиRows" msprop:Generator_UserRelationName="FK_ОказанныеУслуги_УслугиЛаборатории" msprop:Generator_RelationVarName="relationFK_ОказанныеУслуги_УслугиЛаборатории" msprop:Generator_UserParentTable="УслугиЛаборатории" msprop:Generator_ParentPropName="УслугиЛабораторииRow" />
      <msdata:Relationship name="FK_РаботаАнализатора_Анализатор" msdata:parent="Анализатор" msdata:child="РаботаАнализатора" msdata:parentkey="ID_Анализатора" msdata:childkey="ID_Анализатора" msprop:Generator_UserChildTable="РаботаАнализатора" msprop:Generator_ChildPropName="GetРаботаАнализатораRows" msprop:Generator_UserRelationName="FK_РаботаАнализатора_Анализатор" msprop:Generator_ParentPropName="АнализаторRow" msprop:Generator_RelationVarName="relationFK_РаботаАнализатора_Анализатор" msprop:Generator_UserParentTable="Анализатор" />
      <msdata:Relationship name="FK_РаботаАнализатора_ОказанныеУслуги" msdata:parent="ОказанныеУслуги" msdata:child="РаботаАнализатора" msdata:parentkey="ID_ОказанныхУслуг" msdata:childkey="ID_ОказанныхУслуг" msprop:Generator_UserChildTable="РаботаАнализатора" msprop:Generator_ChildPropName="GetРаботаАнализатораRows" msprop:Generator_UserRelationName="FK_РаботаАнализатора_ОказанныеУслуги" msprop:Generator_ParentPropName="ОказанныеУслугиRow" msprop:Generator_RelationVarName="relationFK_РаботаАнализатора_ОказанныеУслуги" msprop:Generator_UserParentTable="ОказанныеУслуги" />
      <msdata:Relationship name="FK_Счета_Бухгалтер" msdata:parent="Бухгалтер" msdata:child="Счета" msdata:parentkey="ID_Бухгалтера" msdata:childkey="ID_Бухгалтера" msprop:Generator_UserChildTable="Счета" msprop:Generator_ChildPropName="GetСчетаRows" msprop:Generator_UserRelationName="FK_Счета_Бухгалтер" msprop:Generator_ParentPropName="БухгалтерRow" msprop:Generator_RelationVarName="relationFK_Счета_Бухгалтер" msprop:Generator_UserParentTable="Бухгалтер" />
      <msdata:Relationship name="FK_Счета_СтраховаяКомпания" msdata:parent="СтраховаяКомпания" msdata:child="Счета" msdata:parentkey="ID_Компании" msdata:childkey="ID_Компании" msprop:Generator_UserChildTable="Счета" msprop:Generator_ChildPropName="GetСчетаRows" msprop:Generator_UserRelationName="FK_Счета_СтраховаяКомпания" msprop:Generator_ParentPropName="СтраховаяКомпанияRow" msprop:Generator_RelationVarName="relationFK_Счета_СтраховаяКомпания" msprop:Generator_UserParentTable="СтраховаяКомпания" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>