Factory/SewingFactoryMURDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SewingFactoryMURDataSet" targetNamespace="http://tempuri.org/SewingFactoryMURDataSet.xsd" xmlns:mstns="http://tempuri.org/SewingFactoryMURDataSet.xsd" xmlns="http://tempuri.org/SewingFactoryMURDataSet.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="SewingFactoryMURConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SewingFactoryMURConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.СУБД_Фабрика.Properties.Settings.GlobalReference.Default.SewingFactoryMURConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClothTableAdapter" GeneratorDataComponentClassName="ClothTableAdapter" Name="Cloth" UserDataComponentName="ClothTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SewingFactoryMURConnectionString (Settings)" DbObjectName="SewingFactoryMUR.dbo.Cloth" 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].[Cloth] WHERE (([IDCloth] = @Original_IDCloth) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Color = 1 AND [Color] IS NULL) OR ([Color] = @Original_Color)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Photo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cloth] ([Title], [Color], [Width], [Length], [Comment], [Photo]) VALUES (@Title, @Color, @Width, @Length, @Comment, @Photo);
SELECT IDCloth, Title, Color, Width, Length, Comment, Photo FROM Cloth WHERE (IDCloth = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDCloth, Title, Color, Width, Length, Comment, Photo FROM dbo.Cloth</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cloth] SET [Title] = @Title, [Color] = @Color, [Width] = @Width, [Length] = @Length, [Comment] = @Comment, [Photo] = @Photo WHERE (([IDCloth] = @Original_IDCloth) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Color = 1 AND [Color] IS NULL) OR ([Color] = @Original_Color)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo)));
SELECT IDCloth, Title, Color, Width, Length, Comment, Photo FROM Cloth WHERE (IDCloth = @IDCloth)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Photo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDCloth" ColumnName="IDCloth" DataSourceName="SewingFactoryMUR.dbo.Cloth" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDCloth" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDCloth" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCloth" DataSetColumn="IDCloth" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
              <Mapping SourceColumn="Length" DataSetColumn="Length" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FurnituraTableAdapter" GeneratorDataComponentClassName="FurnituraTableAdapter" Name="Furnitura" UserDataComponentName="FurnituraTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SewingFactoryMURConnectionString (Settings)" DbObjectName="SewingFactoryMUR.dbo.Furnitura" 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].[Furnitura] WHERE (([idfur] = @Original_idfur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_photo = 1 AND [photo] IS NULL) OR ([photo] = @Original_photo)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idfur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_namefur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_photo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_countfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="countfur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_countfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="countfur" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Furnitura] ([namefur], [photo], [countfur]) VALUES (@namefur, @photo, @countfur);
SELECT idfur, namefur, photo, countfur FROM Furnitura WHERE (idfur = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@countfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="countfur" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idfur, namefur, photo, countfur FROM dbo.Furnitura</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Furnitura] SET [namefur] = @namefur, [photo] = @photo, [countfur] = @countfur WHERE (([idfur] = @Original_idfur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_photo = 1 AND [photo] IS NULL) OR ([photo] = @Original_photo)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur)));
SELECT idfur, namefur, photo, countfur FROM Furnitura WHERE (idfur = @idfur)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@countfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="countfur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idfur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_namefur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_photo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_countfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="countfur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_countfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="countfur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idfur" ColumnName="idfur" DataSourceName="SewingFactoryMUR.dbo.Furnitura" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idfur" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idfur" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idfur" DataSetColumn="idfur" />
              <Mapping SourceColumn="namefur" DataSetColumn="namefur" />
              <Mapping SourceColumn="photo" DataSetColumn="photo" />
              <Mapping SourceColumn="countfur" DataSetColumn="countfur" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IzdeliaTableAdapter" GeneratorDataComponentClassName="IzdeliaTableAdapter" Name="Izdelia" UserDataComponentName="IzdeliaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SewingFactoryMURConnectionString (Settings)" DbObjectName="SewingFactoryMUR.dbo.Izdelia" 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].[Izdelia] WHERE (([IDIzd] = @Original_IDIzd) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Lenght = 1 AND [Lenght] IS NULL) OR ([Lenght] = @Original_Lenght)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Izdelia] ([Title], [Lenght], [Width]) VALUES (@Title, @Lenght, @Width);
SELECT IDIzd, Title, Lenght, Width FROM Izdelia WHERE (IDIzd = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDIzd, Title, Lenght, Width FROM dbo.Izdelia</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Izdelia] SET [Title] = @Title, [Lenght] = @Lenght, [Width] = @Width WHERE (([IDIzd] = @Original_IDIzd) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Lenght = 1 AND [Lenght] IS NULL) OR ([Lenght] = @Original_Lenght)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)));
SELECT IDIzd, Title, Lenght, Width FROM Izdelia WHERE (IDIzd = @IDIzd)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDIzd" ColumnName="IDIzd" DataSourceName="SewingFactoryMUR.dbo.Izdelia" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDIzd" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDIzd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDIzd" DataSetColumn="IDIzd" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Lenght" DataSetColumn="Lenght" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrdersTableAdapter" GeneratorDataComponentClassName="OrdersTableAdapter" Name="Orders" UserDataComponentName="OrdersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SewingFactoryMURConnectionString (Settings)" DbObjectName="SewingFactoryMUR.dbo.Orders" 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].[Orders] WHERE (([IDOrder] = @Original_IDOrder) AND ((@IsNull_IDIzd = 1 AND [IDIzd] IS NULL) OR ([IDIzd] = @Original_IDIzd)) AND ((@IsNull_IDZak = 1 AND [IDZak] IS NULL) OR ([IDZak] = @Original_IDZak)) AND ((@IsNull_IDMen = 1 AND [IDMen] IS NULL) OR ([IDMen] = @Original_IDMen)) AND ((@IsNull_IDCloth = 1 AND [IDCloth] IS NULL) OR ([IDCloth] = @Original_IDCloth)) AND ((@IsNull_IDFur = 1 AND [IDFur] IS NULL) OR ([IDFur] = @Original_IDFur)) AND ((@IsNull_CountFur = 1 AND [CountFur] IS NULL) OR ([CountFur] = @Original_CountFur)) AND ((@IsNull_CountIzd = 1 AND [CountIzd] IS NULL) OR ([CountIzd] = @Original_CountIzd)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDOrder" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIzd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDZak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDZak" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDZak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDZak" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDMen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDMen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDMen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDMen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCloth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Orders] ([IDIzd], [IDZak], [IDMen], [IDCloth], [IDFur], [CountFur], [CountIzd]) VALUES (@IDIzd, @IDZak, @IDMen, @IDCloth, @IDFur, @CountFur, @CountIzd);
SELECT IDOrder, IDIzd, IDZak, IDMen, IDCloth, IDFur, CountFur, CountIzd FROM Orders WHERE (IDOrder = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIzd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDZak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDZak" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDMen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDMen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCloth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDOrder, IDIzd, IDZak, IDMen, IDCloth, IDFur, CountFur, CountIzd FROM dbo.Orders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Orders] SET [IDIzd] = @IDIzd, [IDZak] = @IDZak, [IDMen] = @IDMen, [IDCloth] = @IDCloth, [IDFur] = @IDFur, [CountFur] = @CountFur, [CountIzd] = @CountIzd WHERE (([IDOrder] = @Original_IDOrder) AND ((@IsNull_IDIzd = 1 AND [IDIzd] IS NULL) OR ([IDIzd] = @Original_IDIzd)) AND ((@IsNull_IDZak = 1 AND [IDZak] IS NULL) OR ([IDZak] = @Original_IDZak)) AND ((@IsNull_IDMen = 1 AND [IDMen] IS NULL) OR ([IDMen] = @Original_IDMen)) AND ((@IsNull_IDCloth = 1 AND [IDCloth] IS NULL) OR ([IDCloth] = @Original_IDCloth)) AND ((@IsNull_IDFur = 1 AND [IDFur] IS NULL) OR ([IDFur] = @Original_IDFur)) AND ((@IsNull_CountFur = 1 AND [CountFur] IS NULL) OR ([CountFur] = @Original_CountFur)) AND ((@IsNull_CountIzd = 1 AND [CountIzd] IS NULL) OR ([CountIzd] = @Original_CountIzd)));
SELECT IDOrder, IDIzd, IDZak, IDMen, IDCloth, IDFur, CountFur, CountIzd FROM Orders WHERE (IDOrder = @IDOrder)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIzd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDZak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDZak" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDMen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDMen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCloth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDOrder" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIzd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDZak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDZak" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDZak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDZak" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDMen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDMen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDMen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDMen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCloth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDOrder" ColumnName="IDOrder" DataSourceName="SewingFactoryMUR.dbo.Orders" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDOrder" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDOrder" DataSetColumn="IDOrder" />
              <Mapping SourceColumn="IDIzd" DataSetColumn="IDIzd" />
              <Mapping SourceColumn="IDZak" DataSetColumn="IDZak" />
              <Mapping SourceColumn="IDMen" DataSetColumn="IDMen" />
              <Mapping SourceColumn="IDCloth" DataSetColumn="IDCloth" />
              <Mapping SourceColumn="IDFur" DataSetColumn="IDFur" />
              <Mapping SourceColumn="CountFur" DataSetColumn="CountFur" />
              <Mapping SourceColumn="CountIzd" DataSetColumn="CountIzd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RolesTableAdapter" GeneratorDataComponentClassName="RolesTableAdapter" Name="Roles" UserDataComponentName="RolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SewingFactoryMURConnectionString (Settings)" DbObjectName="SewingFactoryMUR.dbo.Roles" 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].[Roles] WHERE (([IDRole] = @Original_IDRole) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Roles] ([Role]) VALUES (@Role);
SELECT IDRole, Role FROM Roles WHERE (IDRole = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDRole, Role FROM dbo.Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Roles] SET [Role] = @Role WHERE (([IDRole] = @Original_IDRole) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)));
SELECT IDRole, Role FROM Roles WHERE (IDRole = @IDRole)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDRole" ColumnName="IDRole" DataSourceName="SewingFactoryMUR.dbo.Roles" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDRole" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDRole" DataSetColumn="IDRole" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SewingFactoryMURConnectionString (Settings)" DbObjectName="SewingFactoryMUR.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 (([IDUser] = @Original_IDUser) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Pass = 1 AND [Pass] IS NULL) OR ([Pass] = @Original_Pass)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)) AND ((@IsNull_Fam = 1 AND [Fam] IS NULL) OR ([Fam] = @Original_Fam)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Otch = 1 AND [Otch] IS NULL) OR ([Otch] = @Original_Otch)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pass" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Otch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Otch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Otch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Otch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Users] ([Login], [Pass], [Role], [Fam], [Name], [Otch], [Phone]) VALUES (@Login, @Pass, @Role, @Fam, @Name, @Otch, @Phone);
SELECT IDUser, Login, Pass, Role, Fam, Name, Otch, Phone FROM Users WHERE (IDUser = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Otch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Otch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDUser, Login, Pass, Role, Fam, Name, Otch, Phone FROM dbo.Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Users] SET [Login] = @Login, [Pass] = @Pass, [Role] = @Role, [Fam] = @Fam, [Name] = @Name, [Otch] = @Otch, [Phone] = @Phone WHERE (([IDUser] = @Original_IDUser) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Pass = 1 AND [Pass] IS NULL) OR ([Pass] = @Original_Pass)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)) AND ((@IsNull_Fam = 1 AND [Fam] IS NULL) OR ([Fam] = @Original_Fam)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Otch = 1 AND [Otch] IS NULL) OR ([Otch] = @Original_Otch)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)));
SELECT IDUser, Login, Pass, Role, Fam, Name, Otch, Phone FROM Users WHERE (IDUser = @IDUser)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Otch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Otch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pass" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pass" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Otch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Otch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Otch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Otch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDUser" ColumnName="IDUser" DataSourceName="SewingFactoryMUR.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDUser" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDUser" DataSetColumn="IDUser" />
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Pass" DataSetColumn="Pass" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
              <Mapping SourceColumn="Fam" DataSetColumn="Fam" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Otch" DataSetColumn="Otch" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SewingFactoryMURDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="SewingFactoryMURDataSet" msprop:Generator_DataSetName="SewingFactoryMURDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cloth" msprop:Generator_RowEvHandlerName="ClothRowChangeEventHandler" msprop:Generator_RowDeletedName="ClothRowDeleted" msprop:Generator_RowDeletingName="ClothRowDeleting" msprop:Generator_RowEvArgName="ClothRowChangeEvent" msprop:Generator_TablePropName="Cloth" msprop:Generator_RowChangedName="ClothRowChanged" msprop:Generator_RowChangingName="ClothRowChanging" msprop:Generator_TableClassName="ClothDataTable" msprop:Generator_RowClassName="ClothRow" msprop:Generator_TableVarName="tableCloth" msprop:Generator_UserTableName="Cloth">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCloth" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDCloth" msprop:Generator_ColumnPropNameInTable="IDClothColumn" msprop:Generator_ColumnVarNameInTable="columnIDCloth" msprop:Generator_UserColumnName="IDCloth" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_UserColumnName="Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Color" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_UserColumnName="Color" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Width" msprop:Generator_ColumnPropNameInRow="Width" msprop:Generator_ColumnPropNameInTable="WidthColumn" msprop:Generator_ColumnVarNameInTable="columnWidth" msprop:Generator_UserColumnName="Width" type="xs:int" minOccurs="0" />
              <xs:element name="Length" msprop:Generator_ColumnPropNameInRow="Length" msprop:Generator_ColumnPropNameInTable="LengthColumn" msprop:Generator_ColumnVarNameInTable="columnLength" msprop:Generator_UserColumnName="Length" type="xs:int" minOccurs="0" />
              <xs:element name="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Photo" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_ColumnVarNameInTable="columnPhoto" msprop:Generator_UserColumnName="Photo" 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="Furnitura" msprop:Generator_RowEvHandlerName="FurnituraRowChangeEventHandler" msprop:Generator_RowDeletedName="FurnituraRowDeleted" msprop:Generator_RowDeletingName="FurnituraRowDeleting" msprop:Generator_RowEvArgName="FurnituraRowChangeEvent" msprop:Generator_TablePropName="Furnitura" msprop:Generator_RowChangedName="FurnituraRowChanged" msprop:Generator_RowChangingName="FurnituraRowChanging" msprop:Generator_TableClassName="FurnituraDataTable" msprop:Generator_RowClassName="FurnituraRow" msprop:Generator_TableVarName="tableFurnitura" msprop:Generator_UserTableName="Furnitura">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idfur" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="idfur" msprop:Generator_ColumnPropNameInTable="idfurColumn" msprop:Generator_ColumnVarNameInTable="columnidfur" msprop:Generator_UserColumnName="idfur" type="xs:int" />
              <xs:element name="namefur" msprop:Generator_ColumnPropNameInRow="namefur" msprop:Generator_ColumnPropNameInTable="namefurColumn" msprop:Generator_ColumnVarNameInTable="columnnamefur" msprop:Generator_UserColumnName="namefur" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="photo" msprop:Generator_ColumnPropNameInRow="photo" msprop:Generator_ColumnPropNameInTable="photoColumn" msprop:Generator_ColumnVarNameInTable="columnphoto" msprop:Generator_UserColumnName="photo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="countfur" msprop:Generator_ColumnPropNameInRow="countfur" msprop:Generator_ColumnPropNameInTable="countfurColumn" msprop:Generator_ColumnVarNameInTable="columncountfur" msprop:Generator_UserColumnName="countfur" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Izdelia" msprop:Generator_RowEvHandlerName="IzdeliaRowChangeEventHandler" msprop:Generator_RowDeletedName="IzdeliaRowDeleted" msprop:Generator_RowDeletingName="IzdeliaRowDeleting" msprop:Generator_RowEvArgName="IzdeliaRowChangeEvent" msprop:Generator_TablePropName="Izdelia" msprop:Generator_RowChangedName="IzdeliaRowChanged" msprop:Generator_RowChangingName="IzdeliaRowChanging" msprop:Generator_TableClassName="IzdeliaDataTable" msprop:Generator_RowClassName="IzdeliaRow" msprop:Generator_TableVarName="tableIzdelia" msprop:Generator_UserTableName="Izdelia">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDIzd" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDIzd" msprop:Generator_ColumnPropNameInTable="IDIzdColumn" msprop:Generator_ColumnVarNameInTable="columnIDIzd" msprop:Generator_UserColumnName="IDIzd" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_UserColumnName="Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Lenght" msprop:Generator_ColumnPropNameInRow="Lenght" msprop:Generator_ColumnPropNameInTable="LenghtColumn" msprop:Generator_ColumnVarNameInTable="columnLenght" msprop:Generator_UserColumnName="Lenght" type="xs:int" minOccurs="0" />
              <xs:element name="Width" msprop:Generator_ColumnPropNameInRow="Width" msprop:Generator_ColumnPropNameInTable="WidthColumn" msprop:Generator_ColumnVarNameInTable="columnWidth" msprop:Generator_UserColumnName="Width" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Orders" msprop:Generator_RowEvHandlerName="OrdersRowChangeEventHandler" msprop:Generator_RowDeletedName="OrdersRowDeleted" msprop:Generator_RowDeletingName="OrdersRowDeleting" msprop:Generator_RowEvArgName="OrdersRowChangeEvent" msprop:Generator_TablePropName="Orders" msprop:Generator_RowChangedName="OrdersRowChanged" msprop:Generator_RowChangingName="OrdersRowChanging" msprop:Generator_TableClassName="OrdersDataTable" msprop:Generator_RowClassName="OrdersRow" msprop:Generator_TableVarName="tableOrders" msprop:Generator_UserTableName="Orders">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDOrder" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDOrder" msprop:Generator_ColumnPropNameInTable="IDOrderColumn" msprop:Generator_ColumnVarNameInTable="columnIDOrder" msprop:Generator_UserColumnName="IDOrder" type="xs:int" />
              <xs:element name="IDIzd" msprop:Generator_ColumnPropNameInRow="IDIzd" msprop:Generator_ColumnPropNameInTable="IDIzdColumn" msprop:Generator_ColumnVarNameInTable="columnIDIzd" msprop:Generator_UserColumnName="IDIzd" type="xs:int" minOccurs="0" />
              <xs:element name="IDZak" msprop:Generator_ColumnPropNameInRow="IDZak" msprop:Generator_ColumnPropNameInTable="IDZakColumn" msprop:Generator_ColumnVarNameInTable="columnIDZak" msprop:Generator_UserColumnName="IDZak" type="xs:int" minOccurs="0" />
              <xs:element name="IDMen" msprop:Generator_ColumnPropNameInRow="IDMen" msprop:Generator_ColumnPropNameInTable="IDMenColumn" msprop:Generator_ColumnVarNameInTable="columnIDMen" msprop:Generator_UserColumnName="IDMen" type="xs:int" minOccurs="0" />
              <xs:element name="IDCloth" msprop:Generator_ColumnPropNameInRow="IDCloth" msprop:Generator_ColumnPropNameInTable="IDClothColumn" msprop:Generator_ColumnVarNameInTable="columnIDCloth" msprop:Generator_UserColumnName="IDCloth" type="xs:int" minOccurs="0" />
              <xs:element name="IDFur" msprop:Generator_ColumnPropNameInRow="IDFur" msprop:Generator_ColumnPropNameInTable="IDFurColumn" msprop:Generator_ColumnVarNameInTable="columnIDFur" msprop:Generator_UserColumnName="IDFur" type="xs:int" minOccurs="0" />
              <xs:element name="CountFur" msprop:Generator_ColumnPropNameInRow="CountFur" msprop:Generator_ColumnPropNameInTable="CountFurColumn" msprop:Generator_ColumnVarNameInTable="columnCountFur" msprop:Generator_UserColumnName="CountFur" type="xs:int" minOccurs="0" />
              <xs:element name="CountIzd" msprop:Generator_ColumnPropNameInRow="CountIzd" msprop:Generator_ColumnPropNameInTable="CountIzdColumn" msprop:Generator_ColumnVarNameInTable="columnCountIzd" msprop:Generator_UserColumnName="CountIzd" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Roles" msprop:Generator_RowEvHandlerName="RolesRowChangeEventHandler" msprop:Generator_RowDeletedName="RolesRowDeleted" msprop:Generator_RowDeletingName="RolesRowDeleting" msprop:Generator_RowEvArgName="RolesRowChangeEvent" msprop:Generator_TablePropName="Roles" msprop:Generator_RowChangedName="RolesRowChanged" msprop:Generator_RowChangingName="RolesRowChanging" msprop:Generator_TableClassName="RolesDataTable" msprop:Generator_RowClassName="RolesRow" msprop:Generator_TableVarName="tableRoles" msprop:Generator_UserTableName="Roles">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDRole" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDRole" msprop:Generator_ColumnPropNameInTable="IDRoleColumn" msprop:Generator_ColumnVarNameInTable="columnIDRole" msprop:Generator_UserColumnName="IDRole" type="xs:int" />
              <xs:element name="Role" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_UserColumnName="Role" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_TablePropName="Users" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_RowClassName="UsersRow" msprop:Generator_TableVarName="tableUsers" msprop:Generator_UserTableName="Users">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDUser" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDUser" msprop:Generator_ColumnPropNameInTable="IDUserColumn" msprop:Generator_ColumnVarNameInTable="columnIDUser" msprop:Generator_UserColumnName="IDUser" type="xs:int" />
              <xs:element name="Login" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_UserColumnName="Login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnPropNameInTable="PassColumn" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_UserColumnName="Pass" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Role" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_UserColumnName="Role" type="xs:int" minOccurs="0" />
              <xs:element name="Fam" msprop:Generator_ColumnPropNameInRow="Fam" msprop:Generator_ColumnPropNameInTable="FamColumn" msprop:Generator_ColumnVarNameInTable="columnFam" msprop:Generator_UserColumnName="Fam" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Otch" msprop:Generator_ColumnPropNameInRow="Otch" msprop:Generator_ColumnPropNameInTable="OtchColumn" msprop:Generator_ColumnVarNameInTable="columnOtch" msprop:Generator_UserColumnName="Otch" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cloth" />
      <xs:field xpath="mstns:IDCloth" />
    </xs:unique>
    <xs:unique name="Furnitura_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Furnitura" />
      <xs:field xpath="mstns:idfur" />
    </xs:unique>
    <xs:unique name="Izdelia_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Izdelia" />
      <xs:field xpath="mstns:IDIzd" />
    </xs:unique>
    <xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Orders" />
      <xs:field xpath="mstns:IDOrder" />
    </xs:unique>
    <xs:unique name="Roles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Roles" />
      <xs:field xpath="mstns:IDRole" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:IDUser" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Orders_Cloth" msdata:parent="Cloth" msdata:child="Orders" msdata:parentkey="IDCloth" msdata:childkey="IDCloth" msprop:Generator_UserParentTable="Cloth" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Cloth" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="ClothRow" msprop:Generator_UserRelationName="FK_Orders_Cloth" />
      <msdata:Relationship name="FK_Orders_Furnitura" msdata:parent="Furnitura" msdata:child="Orders" msdata:parentkey="idfur" msdata:childkey="IDFur" msprop:Generator_UserParentTable="Furnitura" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Furnitura" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="FurnituraRow" msprop:Generator_UserRelationName="FK_Orders_Furnitura" />
      <msdata:Relationship name="FK_Orders_Izdelia" msdata:parent="Izdelia" msdata:child="Orders" msdata:parentkey="IDIzd" msdata:childkey="IDIzd" msprop:Generator_UserParentTable="Izdelia" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Izdelia" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="IzdeliaRow" msprop:Generator_UserRelationName="FK_Orders_Izdelia" />
      <msdata:Relationship name="FK_Orders_Users" msdata:parent="Users" msdata:child="Orders" msdata:parentkey="IDUser" msdata:childkey="IDZak" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Users" msprop:Generator_UserRelationName="FK_Orders_Users" msprop:Generator_ChildPropName="GetOrdersRowsByFK_Orders_Users" msprop:Generator_ParentPropName="UsersRowByFK_Orders_Users" />
      <msdata:Relationship name="FK_Orders_Users1" msdata:parent="Users" msdata:child="Orders" msdata:parentkey="IDUser" msdata:childkey="IDMen" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Users1" msprop:Generator_UserRelationName="FK_Orders_Users1" msprop:Generator_ChildPropName="GetOrdersRowsByFK_Orders_Users1" msprop:Generator_ParentPropName="UsersRowByFK_Orders_Users1" />
      <msdata:Relationship name="FK_Users_Roles" msdata:parent="Roles" msdata:child="Users" msdata:parentkey="IDRole" msdata:childkey="Role" msprop:Generator_UserParentTable="Roles" msprop:Generator_UserChildTable="Users" msprop:Generator_RelationVarName="relationFK_Users_Roles" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_ParentPropName="RolesRow" msprop:Generator_UserRelationName="FK_Users_Roles" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>