Kezdőlap Felfedezés Súgó
Regisztráció Bejelentkezés
badretdinov_roman
/
DigitalWorld_08
1
0
Másolás 0
Fájlok Problémák 0 Beolvasztási kérések 0 Wiki
Branch: application
Branch-ok Tag-ek
DigitalWorld...
/
digital_world_8DataSet.xsd

digital_world_8DataSet.xsd 162 KB
Állandó hivatkozás Előzmények Nyers

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113 
  1. <?xml version="1.0" encoding="utf-8"?>
    2. 

  2. <xs:schema id="digital_world_8DataSet" targetNamespace="http://tempuri.org/digital_world_8DataSet.xsd" xmlns:mstns="http://tempuri.org/digital_world_8DataSet.xsd" xmlns="http://tempuri.org/digital_world_8DataSet.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">
    3. 

  3.   <xs:annotation>
    4. 

  4.     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
    5. 

  5.       <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
    6. 

  6.         <Connections>
    7. 

  7.           <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="digital_world_8ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="digital_world_8ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Digital_World_08.Properties.Settings.GlobalReference.Default.digital_world_8ConnectionString" Provider="System.Data.SqlClient" />
    8. 

  8.         </Connections>
    9. 

  9.         <Tables>
    10. 

  10.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ComponentsTableAdapter" GeneratorDataComponentClassName="ComponentsTableAdapter" Name="Components" UserDataComponentName="ComponentsTableAdapter">
    11. 

  11.             <MainSource>
    12. 

  12.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.Components" 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">
    13. 

  13.                 <DeleteCommand>
    14. 

  14.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    15. 

  15.                     <CommandText>DELETE FROM [dbo].[Components] WHERE (([id] = @Original_id) AND ((@IsNull_Id_единицы_измерения = 1 AND [Id единицы измерения] IS NULL) OR ([Id единицы измерения] = @Original_Id_единицы_измерения)) AND ((@IsNull_Тип_материала = 1 AND [Тип_материала] IS NULL) OR ([Тип_материала] = @Original_Тип_материала)) AND ((@IsNull_Цена = 1 AND [Цена] IS NULL) OR ([Цена] = @Original_Цена)) AND ((@IsNull_количество = 1 AND [количество] IS NULL) OR ([количество] = @Original_количество)))</CommandText>
    16. 

  16.                     <Parameters>
    17. 

  17.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    18. 

  18.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" SourceColumnNullMapping="true" SourceVersion="Original" />
    19. 

  19.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" SourceColumnNullMapping="false" SourceVersion="Original" />
    20. 

  20.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Тип_материала" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Тип_материала" SourceColumnNullMapping="true" SourceVersion="Original" />
    21. 

  21.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Тип_материала" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Тип_материала" SourceColumnNullMapping="false" SourceVersion="Original" />
    22. 

  22.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="true" SourceVersion="Original" />
    23. 

  23.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Original" />
    24. 

  24.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="количество" SourceColumnNullMapping="true" SourceVersion="Original" />
    25. 

  25.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="количество" SourceColumnNullMapping="false" SourceVersion="Original" />
    26. 

  26.                     </Parameters>
    27. 

  27.                   </DbCommand>
    28. 

  28.                 </DeleteCommand>
    29. 

  29.                 <InsertCommand>
    30. 

  30.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    31. 

  31.                     <CommandText>INSERT INTO [dbo].[Components] ([Название], [Id единицы измерения], [Тип_материала], [Цена], [количество]) VALUES (@Название, @Id_единицы_измерения, @Тип_материала, @Цена, @количество);
    32. 

  32. SELECT id, Название, [Id единицы измерения], Тип_материала, Цена, количество FROM Components WHERE (id = SCOPE_IDENTITY())</CommandText>
    33. 

  33.                     <Parameters>
    34. 

  34.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
    35. 

  35.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" SourceColumnNullMapping="false" SourceVersion="Current" />
    36. 

  36.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Тип_материала" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Тип_материала" SourceColumnNullMapping="false" SourceVersion="Current" />
    37. 

  37.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Current" />
    38. 

  38.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="количество" SourceColumnNullMapping="false" SourceVersion="Current" />
    39. 

  39.                     </Parameters>
    40. 

  40.                   </DbCommand>
    41. 

  41.                 </InsertCommand>
    42. 

  42.                 <SelectCommand>
    43. 

  43.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    44. 

  44.                     <CommandText>SELECT id, Название, [Id единицы измерения], Тип_материала, Цена, количество FROM dbo.Components</CommandText>
    45. 

  45.                     <Parameters />
    46. 

  46.                   </DbCommand>
    47. 

  47.                 </SelectCommand>
    48. 

  48.                 <UpdateCommand>
    49. 

  49.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    50. 

  50.                     <CommandText>UPDATE [dbo].[Components] SET [Название] = @Название, [Id единицы измерения] = @Id_единицы_измерения, [Тип_материала] = @Тип_материала, [Цена] = @Цена, [количество] = @количество WHERE (([id] = @Original_id) AND ((@IsNull_Id_единицы_измерения = 1 AND [Id единицы измерения] IS NULL) OR ([Id единицы измерения] = @Original_Id_единицы_измерения)) AND ((@IsNull_Тип_материала = 1 AND [Тип_материала] IS NULL) OR ([Тип_материала] = @Original_Тип_материала)) AND ((@IsNull_Цена = 1 AND [Цена] IS NULL) OR ([Цена] = @Original_Цена)) AND ((@IsNull_количество = 1 AND [количество] IS NULL) OR ([количество] = @Original_количество)));
    51. 

  51. SELECT id, Название, [Id единицы измерения], Тип_материала, Цена, количество FROM Components WHERE (id = @id)</CommandText>
    52. 

  52.                     <Parameters>
    53. 

  53.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
    54. 

  54.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" SourceColumnNullMapping="false" SourceVersion="Current" />
    55. 

  55.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Тип_материала" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Тип_материала" SourceColumnNullMapping="false" SourceVersion="Current" />
    56. 

  56.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Current" />
    57. 

  57.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="количество" SourceColumnNullMapping="false" SourceVersion="Current" />
    58. 

  58.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    59. 

  59.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" SourceColumnNullMapping="true" SourceVersion="Original" />
    60. 

  60.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_единицы_измерения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id единицы измерения" SourceColumnNullMapping="false" SourceVersion="Original" />
    61. 

  61.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Тип_материала" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Тип_материала" SourceColumnNullMapping="true" SourceVersion="Original" />
    62. 

  62.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Тип_материала" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Тип_материала" SourceColumnNullMapping="false" SourceVersion="Original" />
    63. 

  63.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="true" SourceVersion="Original" />
    64. 

  64.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Цена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Цена" SourceColumnNullMapping="false" SourceVersion="Original" />
    65. 

  65.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="количество" SourceColumnNullMapping="true" SourceVersion="Original" />
    66. 

  66.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="количество" SourceColumnNullMapping="false" SourceVersion="Original" />
    67. 

  67.                       <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="digital_world_8.dbo.Components" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
    68. 

  68.                     </Parameters>
    69. 

  69.                   </DbCommand>
    70. 

  70.                 </UpdateCommand>
    71. 

  71.               </DbSource>
    72. 

  72.             </MainSource>
    73. 

  73.             <Mappings>
    74. 

  74.               <Mapping SourceColumn="id" DataSetColumn="id" />
    75. 

  75.               <Mapping SourceColumn="Название" DataSetColumn="Название" />
    76. 

  76.               <Mapping SourceColumn="Id единицы измерения" DataSetColumn="Id единицы измерения" />
    77. 

  77.               <Mapping SourceColumn="Тип_материала" DataSetColumn="Тип_материала" />
    78. 

  78.               <Mapping SourceColumn="Цена" DataSetColumn="Цена" />
    79. 

  79.               <Mapping SourceColumn="количество" DataSetColumn="количество" />
    80. 

  80.             </Mappings>
    81. 

  81.             <Sources />
    82. 

  82.           </TableAdapter>
    83. 

  83.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="computer_assemblyTableAdapter" GeneratorDataComponentClassName="computer_assemblyTableAdapter" Name="computer_assembly" UserDataComponentName="computer_assemblyTableAdapter">
    84. 

  84.             <MainSource>
    85. 

  85.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.computer_assembly" 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">
    86. 

  86.                 <DeleteCommand>
    87. 

  87.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    88. 

  88.                     <CommandText>DELETE FROM [dbo].[computer_assembly] WHERE (([id сборки] = @Original_id_сборки) AND ((@IsNull_Id_компонентов = 1 AND [Id компонентов] IS NULL) OR ([Id компонентов] = @Original_Id_компонентов)) AND ((@IsNull_Количество = 1 AND [Количество] IS NULL) OR ([Количество] = @Original_Количество)) AND ((@IsNull_Видеокарта = 1 AND [Видеокарта] IS NULL) OR ([Видеокарта] = @Original_Видеокарта)) AND ((@IsNull_Материнская_плата = 1 AND [Материнская плата] IS NULL) OR ([Материнская плата] = @Original_Материнская_плата)) AND ((@IsNull_Процессор = 1 AND [Процессор] IS NULL) OR ([Процессор] = @Original_Процессор)) AND ((@p3 = 1 AND [Оперативная память] IS NULL) OR ([Оперативная память] = @p2)) AND ((@IsNull_Оперативная_память = 1 AND [Оперативная_память] IS NULL) OR ([Оперативная_память] = @Original_Оперативная_память)) AND ((@IsNull_Жетский_диск = 1 AND [Жетский диск] IS NULL) OR ([Жетский диск] = @Original_Жетский_диск)) AND ((@IsNull_Куллер = 1 AND [Куллер] IS NULL) OR ([Куллер] = @Original_Куллер)) AND ((@IsNull_Система_охлаждения = 1 AND [Система охлаждения] IS NULL) OR ([Система охлаждения] = @Original_Система_охлаждения)) AND ((@IsNull_Блок_питания = 1 AND [Блок питания] IS NULL) OR ([Блок питания] = @Original_Блок_питания)) AND ((@IsNull_SSD = 1 AND [SSD] IS NULL) OR ([SSD] = @Original_SSD)))</CommandText>
    89. 

  89.                     <Parameters>
    90. 

  90.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id сборки" SourceColumnNullMapping="false" SourceVersion="Original" />
    91. 

  91.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="true" SourceVersion="Original" />
    92. 

  92.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="false" SourceVersion="Original" />
    93. 

  93.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="true" SourceVersion="Original" />
    94. 

  94.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Original" />
    95. 

  95.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Видеокарта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Видеокарта" SourceColumnNullMapping="true" SourceVersion="Original" />
    96. 

  96.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Видеокарта" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Видеокарта" SourceColumnNullMapping="false" SourceVersion="Original" />
    97. 

  97.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Материнская_плата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Материнская плата" SourceColumnNullMapping="true" SourceVersion="Original" />
    98. 

  98.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Материнская_плата" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Материнская плата" SourceColumnNullMapping="false" SourceVersion="Original" />
    99. 

  99.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Процессор" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Процессор" SourceColumnNullMapping="true" SourceVersion="Original" />
    100. 

  100.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Процессор" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Процессор" SourceColumnNullMapping="false" SourceVersion="Original" />
    101. 

  101.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оперативная память" SourceColumnNullMapping="true" SourceVersion="Original" />
    102. 

  102.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Оперативная память" SourceColumnNullMapping="false" SourceVersion="Original" />
    103. 

  103.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Оперативная_память" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оперативная_память" SourceColumnNullMapping="true" SourceVersion="Original" />
    104. 

  104.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Оперативная_память" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Оперативная_память" SourceColumnNullMapping="false" SourceVersion="Original" />
    105. 

  105.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Жетский_диск" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Жетский диск" SourceColumnNullMapping="true" SourceVersion="Original" />
    106. 

  106.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Жетский_диск" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Жетский диск" SourceColumnNullMapping="false" SourceVersion="Original" />
    107. 

  107.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Куллер" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Куллер" SourceColumnNullMapping="true" SourceVersion="Original" />
    108. 

  108.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Куллер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Куллер" SourceColumnNullMapping="false" SourceVersion="Original" />
    109. 

  109.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Система_охлаждения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Система охлаждения" SourceColumnNullMapping="true" SourceVersion="Original" />
    110. 

  110.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Система_охлаждения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Система охлаждения" SourceColumnNullMapping="false" SourceVersion="Original" />
    111. 

  111.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Блок_питания" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Блок питания" SourceColumnNullMapping="true" SourceVersion="Original" />
    112. 

  112.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Блок_питания" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Блок питания" SourceColumnNullMapping="false" SourceVersion="Original" />
    113. 

  113.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SSD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSD" SourceColumnNullMapping="true" SourceVersion="Original" />
    114. 

  114.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SSD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SSD" SourceColumnNullMapping="false" SourceVersion="Original" />
    115. 

  115.                     </Parameters>
    116. 

  116.                   </DbCommand>
    117. 

  117.                 </DeleteCommand>
    118. 

  118.                 <InsertCommand>
    119. 

  119.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    120. 

  120.                     <CommandText>INSERT INTO [dbo].[computer_assembly] ([Id компонентов], [Количество], [Видеокарта], [Материнская плата], [Процессор], [Оперативная память], [Оперативная_память], [Жетский диск], [Куллер], [Система охлаждения], [Блок питания], [SSD]) VALUES (@Id_компонентов, @Количество, @Видеокарта, @Материнская_плата, @Процессор, @p1, @Оперативная_память, @Жетский_диск, @Куллер, @Система_охлаждения, @Блок_питания, @SSD);
    121. 

  121. SELECT [id сборки], [Id компонентов], Количество, Видеокарта, [Материнская плата], Процессор, [Оперативная память], Оперативная_память, [Жетский диск], Куллер, [Система охлаждения], [Блок питания], SSD FROM computer_assembly WHERE ([id сборки] = SCOPE_IDENTITY())</CommandText>
    122. 

  122.                     <Parameters>
    123. 

  123.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="false" SourceVersion="Current" />
    124. 

  124.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Current" />
    125. 

  125.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Видеокарта" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Видеокарта" SourceColumnNullMapping="false" SourceVersion="Current" />
    126. 

  126.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Материнская_плата" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Материнская плата" SourceColumnNullMapping="false" SourceVersion="Current" />
    127. 

  127.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Процессор" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Процессор" SourceColumnNullMapping="false" SourceVersion="Current" />
    128. 

  128.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Оперативная память" SourceColumnNullMapping="false" SourceVersion="Current" />
    129. 

  129.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Оперативная_память" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Оперативная_память" SourceColumnNullMapping="false" SourceVersion="Current" />
    130. 

  130.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Жетский_диск" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Жетский диск" SourceColumnNullMapping="false" SourceVersion="Current" />
    131. 

  131.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Куллер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Куллер" SourceColumnNullMapping="false" SourceVersion="Current" />
    132. 

  132.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Система_охлаждения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Система охлаждения" SourceColumnNullMapping="false" SourceVersion="Current" />
    133. 

  133.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Блок_питания" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Блок питания" SourceColumnNullMapping="false" SourceVersion="Current" />
    134. 

  134.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SSD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SSD" SourceColumnNullMapping="false" SourceVersion="Current" />
    135. 

  135.                     </Parameters>
    136. 

  136.                   </DbCommand>
    137. 

  137.                 </InsertCommand>
    138. 

  138.                 <SelectCommand>
    139. 

  139.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    140. 

  140.                     <CommandText>SELECT [id сборки], [Id компонентов], Количество, Видеокарта, [Материнская плата], Процессор, [Оперативная память], Оперативная_память, [Жетский диск], Куллер, [Система охлаждения], [Блок питания], SSD FROM dbo.computer_assembly</CommandText>
    141. 

  141.                     <Parameters />
    142. 

  142.                   </DbCommand>
    143. 

  143.                 </SelectCommand>
    144. 

  144.                 <UpdateCommand>
    145. 

  145.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    146. 

  146.                     <CommandText>UPDATE [dbo].[computer_assembly] SET [Id компонентов] = @Id_компонентов, [Количество] = @Количество, [Видеокарта] = @Видеокарта, [Материнская плата] = @Материнская_плата, [Процессор] = @Процессор, [Оперативная память] = @p1, [Оперативная_память] = @Оперативная_память, [Жетский диск] = @Жетский_диск, [Куллер] = @Куллер, [Система охлаждения] = @Система_охлаждения, [Блок питания] = @Блок_питания, [SSD] = @SSD WHERE (([id сборки] = @Original_id_сборки) AND ((@IsNull_Id_компонентов = 1 AND [Id компонентов] IS NULL) OR ([Id компонентов] = @Original_Id_компонентов)) AND ((@IsNull_Количество = 1 AND [Количество] IS NULL) OR ([Количество] = @Original_Количество)) AND ((@IsNull_Видеокарта = 1 AND [Видеокарта] IS NULL) OR ([Видеокарта] = @Original_Видеокарта)) AND ((@IsNull_Материнская_плата = 1 AND [Материнская плата] IS NULL) OR ([Материнская плата] = @Original_Материнская_плата)) AND ((@IsNull_Процессор = 1 AND [Процессор] IS NULL) OR ([Процессор] = @Original_Процессор)) AND ((@p3 = 1 AND [Оперативная память] IS NULL) OR ([Оперативная память] = @p2)) AND ((@IsNull_Оперативная_память = 1 AND [Оперативная_память] IS NULL) OR ([Оперативная_память] = @Original_Оперативная_память)) AND ((@IsNull_Жетский_диск = 1 AND [Жетский диск] IS NULL) OR ([Жетский диск] = @Original_Жетский_диск)) AND ((@IsNull_Куллер = 1 AND [Куллер] IS NULL) OR ([Куллер] = @Original_Куллер)) AND ((@IsNull_Система_охлаждения = 1 AND [Система охлаждения] IS NULL) OR ([Система охлаждения] = @Original_Система_охлаждения)) AND ((@IsNull_Блок_питания = 1 AND [Блок питания] IS NULL) OR ([Блок питания] = @Original_Блок_питания)) AND ((@IsNull_SSD = 1 AND [SSD] IS NULL) OR ([SSD] = @Original_SSD)));
    147. 

  147. SELECT [id сборки], [Id компонентов], Количество, Видеокарта, [Материнская плата], Процессор, [Оперативная память], Оперативная_память, [Жетский диск], Куллер, [Система охлаждения], [Блок питания], SSD FROM computer_assembly WHERE ([id сборки] = @id_сборки)</CommandText>
    148. 

  148.                     <Parameters>
    149. 

  149.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="false" SourceVersion="Current" />
    150. 

  150.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Current" />
    151. 

  151.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Видеокарта" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Видеокарта" SourceColumnNullMapping="false" SourceVersion="Current" />
    152. 

  152.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Материнская_плата" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Материнская плата" SourceColumnNullMapping="false" SourceVersion="Current" />
    153. 

  153.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Процессор" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Процессор" SourceColumnNullMapping="false" SourceVersion="Current" />
    154. 

  154.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Оперативная память" SourceColumnNullMapping="false" SourceVersion="Current" />
    155. 

  155.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Оперативная_память" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Оперативная_память" SourceColumnNullMapping="false" SourceVersion="Current" />
    156. 

  156.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Жетский_диск" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Жетский диск" SourceColumnNullMapping="false" SourceVersion="Current" />
    157. 

  157.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Куллер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Куллер" SourceColumnNullMapping="false" SourceVersion="Current" />
    158. 

  158.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Система_охлаждения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Система охлаждения" SourceColumnNullMapping="false" SourceVersion="Current" />
    159. 

  159.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Блок_питания" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Блок питания" SourceColumnNullMapping="false" SourceVersion="Current" />
    160. 

  160.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SSD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SSD" SourceColumnNullMapping="false" SourceVersion="Current" />
    161. 

  161.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id сборки" SourceColumnNullMapping="false" SourceVersion="Original" />
    162. 

  162.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="true" SourceVersion="Original" />
    163. 

  163.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="false" SourceVersion="Original" />
    164. 

  164.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="true" SourceVersion="Original" />
    165. 

  165.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Количество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Количество" SourceColumnNullMapping="false" SourceVersion="Original" />
    166. 

  166.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Видеокарта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Видеокарта" SourceColumnNullMapping="true" SourceVersion="Original" />
    167. 

  167.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Видеокарта" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Видеокарта" SourceColumnNullMapping="false" SourceVersion="Original" />
    168. 

  168.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Материнская_плата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Материнская плата" SourceColumnNullMapping="true" SourceVersion="Original" />
    169. 

  169.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Материнская_плата" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Материнская плата" SourceColumnNullMapping="false" SourceVersion="Original" />
    170. 

  170.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Процессор" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Процессор" SourceColumnNullMapping="true" SourceVersion="Original" />
    171. 

  171.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Процессор" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Процессор" SourceColumnNullMapping="false" SourceVersion="Original" />
    172. 

  172.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оперативная память" SourceColumnNullMapping="true" SourceVersion="Original" />
    173. 

  173.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Оперативная память" SourceColumnNullMapping="false" SourceVersion="Original" />
    174. 

  174.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Оперативная_память" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Оперативная_память" SourceColumnNullMapping="true" SourceVersion="Original" />
    175. 

  175.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Оперативная_память" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Оперативная_память" SourceColumnNullMapping="false" SourceVersion="Original" />
    176. 

  176.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Жетский_диск" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Жетский диск" SourceColumnNullMapping="true" SourceVersion="Original" />
    177. 

  177.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Жетский_диск" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Жетский диск" SourceColumnNullMapping="false" SourceVersion="Original" />
    178. 

  178.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Куллер" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Куллер" SourceColumnNullMapping="true" SourceVersion="Original" />
    179. 

  179.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Куллер" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Куллер" SourceColumnNullMapping="false" SourceVersion="Original" />
    180. 

  180.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Система_охлаждения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Система охлаждения" SourceColumnNullMapping="true" SourceVersion="Original" />
    181. 

  181.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Система_охлаждения" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Система охлаждения" SourceColumnNullMapping="false" SourceVersion="Original" />
    182. 

  182.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Блок_питания" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Блок питания" SourceColumnNullMapping="true" SourceVersion="Original" />
    183. 

  183.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Блок_питания" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Блок питания" SourceColumnNullMapping="false" SourceVersion="Original" />
    184. 

  184.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SSD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SSD" SourceColumnNullMapping="true" SourceVersion="Original" />
    185. 

  185.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SSD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SSD" SourceColumnNullMapping="false" SourceVersion="Original" />
    186. 

  186.                       <Parameter AllowDbNull="false" AutogeneratedName="id_сборки" ColumnName="id сборки" DataSourceName="digital_world_8.dbo.computer_assembly" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_сборки" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id сборки" SourceColumnNullMapping="false" SourceVersion="Current" />
    187. 

  187.                     </Parameters>
    188. 

  188.                   </DbCommand>
    189. 

  189.                 </UpdateCommand>
    190. 

  190.               </DbSource>
    191. 

  191.             </MainSource>
    192. 

  192.             <Mappings>
    193. 

  193.               <Mapping SourceColumn="id сборки" DataSetColumn="id сборки" />
    194. 

  194.               <Mapping SourceColumn="Id компонентов" DataSetColumn="Id компонентов" />
    195. 

  195.               <Mapping SourceColumn="Количество" DataSetColumn="Количество" />
    196. 

  196.               <Mapping SourceColumn="Видеокарта" DataSetColumn="Видеокарта" />
    197. 

  197.               <Mapping SourceColumn="Материнская плата" DataSetColumn="Материнская плата" />
    198. 

  198.               <Mapping SourceColumn="Процессор" DataSetColumn="Процессор" />
    199. 

  199.               <Mapping SourceColumn="Оперативная память" DataSetColumn="Оперативная память" />
    200. 

  200.               <Mapping SourceColumn="Оперативная_память" DataSetColumn="Оперативная_память" />
    201. 

  201.               <Mapping SourceColumn="Жетский диск" DataSetColumn="Жетский диск" />
    202. 

  202.               <Mapping SourceColumn="Куллер" DataSetColumn="Куллер" />
    203. 

  203.               <Mapping SourceColumn="Система охлаждения" DataSetColumn="Система охлаждения" />
    204. 

  204.               <Mapping SourceColumn="Блок питания" DataSetColumn="Блок питания" />
    205. 

  205.               <Mapping SourceColumn="SSD" DataSetColumn="SSD" />
    206. 

  206.             </Mappings>
    207. 

  207.             <Sources />
    208. 

  208.           </TableAdapter>
    209. 

  209.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrderTableAdapter" GeneratorDataComponentClassName="OrderTableAdapter" Name="Order" UserDataComponentName="OrderTableAdapter">
    210. 

  210.             <MainSource>
    211. 

  211.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.[Order]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    212. 

  212.                 <DeleteCommand>
    213. 

  213.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    214. 

  214.                     <CommandText>DELETE FROM [dbo].[Order] WHERE (([Id_заказа] = @Original_Id_заказа) AND ((@IsNull_Номер_заказа = 1 AND [Номер заказа] IS NULL) OR ([Номер заказа] = @Original_Номер_заказа)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)) AND ((@IsNull_id_сборки = 1 AND [id сборки] IS NULL) OR ([id сборки] = @Original_id_сборки)) AND ((@IsNull_id_статуса = 1 AND [id статуса] IS NULL) OR ([id статуса] = @Original_id_статуса)))</CommandText>
    215. 

  215.                     <Parameters>
    216. 

  216.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
    217. 

  217.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер заказа" SourceColumnNullMapping="true" SourceVersion="Original" />
    218. 

  218.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
    219. 

  219.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="true" SourceVersion="Original" />
    220. 

  220.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
    221. 

  221.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id сборки" SourceColumnNullMapping="true" SourceVersion="Original" />
    222. 

  222.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id сборки" SourceColumnNullMapping="false" SourceVersion="Original" />
    223. 

  223.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" SourceColumnNullMapping="true" SourceVersion="Original" />
    224. 

  224.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" SourceColumnNullMapping="false" SourceVersion="Original" />
    225. 

  225.                     </Parameters>
    226. 

  226.                   </DbCommand>
    227. 

  227.                 </DeleteCommand>
    228. 

  228.                 <InsertCommand>
    229. 

  229.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    230. 

  230.                     <CommandText>INSERT INTO [dbo].[Order] ([Номер заказа], [Дата], [id сборки], [id статуса]) VALUES (@Номер_заказа, @Дата, @id_сборки, @id_статуса);
    231. 

  231. SELECT Id_заказа, [Номер заказа], Дата, [id сборки], [id статуса] FROM [Order] WHERE (Id_заказа = SCOPE_IDENTITY())</CommandText>
    232. 

  232.                     <Parameters>
    233. 

  233.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
    234. 

  234.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
    235. 

  235.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id сборки" SourceColumnNullMapping="false" SourceVersion="Current" />
    236. 

  236.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" SourceColumnNullMapping="false" SourceVersion="Current" />
    237. 

  237.                     </Parameters>
    238. 

  238.                   </DbCommand>
    239. 

  239.                 </InsertCommand>
    240. 

  240.                 <SelectCommand>
    241. 

  241.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    242. 

  242.                     <CommandText>SELECT Id_заказа, [Номер заказа], Дата, [id сборки], [id статуса] FROM dbo.[Order]</CommandText>
    243. 

  243.                     <Parameters />
    244. 

  244.                   </DbCommand>
    245. 

  245.                 </SelectCommand>
    246. 

  246.                 <UpdateCommand>
    247. 

  247.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    248. 

  248.                     <CommandText>UPDATE [dbo].[Order] SET [Номер заказа] = @Номер_заказа, [Дата] = @Дата, [id сборки] = @id_сборки, [id статуса] = @id_статуса WHERE (([Id_заказа] = @Original_Id_заказа) AND ((@IsNull_Номер_заказа = 1 AND [Номер заказа] IS NULL) OR ([Номер заказа] = @Original_Номер_заказа)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)) AND ((@IsNull_id_сборки = 1 AND [id сборки] IS NULL) OR ([id сборки] = @Original_id_сборки)) AND ((@IsNull_id_статуса = 1 AND [id статуса] IS NULL) OR ([id статуса] = @Original_id_статуса)));
    249. 

  249. SELECT Id_заказа, [Номер заказа], Дата, [id сборки], [id статуса] FROM [Order] WHERE (Id_заказа = @Id_заказа)</CommandText>
    250. 

  250.                     <Parameters>
    251. 

  251.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
    252. 

  252.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
    253. 

  253.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id сборки" SourceColumnNullMapping="false" SourceVersion="Current" />
    254. 

  254.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" SourceColumnNullMapping="false" SourceVersion="Current" />
    255. 

  255.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id_заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
    256. 

  256.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер заказа" SourceColumnNullMapping="true" SourceVersion="Original" />
    257. 

  257.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
    258. 

  258.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="true" SourceVersion="Original" />
    259. 

  259.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
    260. 

  260.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id сборки" SourceColumnNullMapping="true" SourceVersion="Original" />
    261. 

  261.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_сборки" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id сборки" SourceColumnNullMapping="false" SourceVersion="Original" />
    262. 

  262.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" SourceColumnNullMapping="true" SourceVersion="Original" />
    263. 

  263.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id статуса" SourceColumnNullMapping="false" SourceVersion="Original" />
    264. 

  264.                       <Parameter AllowDbNull="false" AutogeneratedName="Id_заказа" ColumnName="Id_заказа" DataSourceName="digital_world_8.dbo.[Order]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id_заказа" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id_заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
    265. 

  265.                     </Parameters>
    266. 

  266.                   </DbCommand>
    267. 

  267.                 </UpdateCommand>
    268. 

  268.               </DbSource>
    269. 

  269.             </MainSource>
    270. 

  270.             <Mappings>
    271. 

  271.               <Mapping SourceColumn="Id_заказа" DataSetColumn="Id_заказа" />
    272. 

  272.               <Mapping SourceColumn="Номер заказа" DataSetColumn="Номер заказа" />
    273. 

  273.               <Mapping SourceColumn="Дата" DataSetColumn="Дата" />
    274. 

  274.               <Mapping SourceColumn="id сборки" DataSetColumn="id сборки" />
    275. 

  275.               <Mapping SourceColumn="id статуса" DataSetColumn="id статуса" />
    276. 

  276.             </Mappings>
    277. 

  277.             <Sources />
    278. 

  278.           </TableAdapter>
    279. 

  279.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="order_by_clientsTableAdapter" GeneratorDataComponentClassName="order_by_clientsTableAdapter" Name="order_by_clients" UserDataComponentName="order_by_clientsTableAdapter">
    280. 

  280.             <MainSource>
    281. 

  281.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.order_by_clients" 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">
    282. 

  282.                 <DeleteCommand>
    283. 

  283.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    284. 

  284.                     <CommandText>DELETE FROM [dbo].[order_by_clients] WHERE (([Номер заказа] = @Original_Номер_заказа) AND ((@IsNull_Пожелания = 1 AND [Пожелания] IS NULL) OR ([Пожелания] = @Original_Пожелания)))</CommandText>
    285. 

  285.                     <Parameters>
    286. 

  286.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
    287. 

  287.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пожелания" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пожелания" SourceColumnNullMapping="true" SourceVersion="Original" />
    288. 

  288.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пожелания" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пожелания" SourceColumnNullMapping="false" SourceVersion="Original" />
    289. 

  289.                     </Parameters>
    290. 

  290.                   </DbCommand>
    291. 

  291.                 </DeleteCommand>
    292. 

  292.                 <InsertCommand>
    293. 

  293.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    294. 

  294.                     <CommandText>INSERT INTO [dbo].[order_by_clients] ([Пожелания]) VALUES (@Пожелания);
    295. 

  295. SELECT [Номер заказа], Пожелания FROM order_by_clients WHERE ([Номер заказа] = SCOPE_IDENTITY())</CommandText>
    296. 

  296.                     <Parameters>
    297. 

  297.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пожелания" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пожелания" SourceColumnNullMapping="false" SourceVersion="Current" />
    298. 

  298.                     </Parameters>
    299. 

  299.                   </DbCommand>
    300. 

  300.                 </InsertCommand>
    301. 

  301.                 <SelectCommand>
    302. 

  302.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    303. 

  303.                     <CommandText>SELECT [Номер заказа], Пожелания FROM dbo.order_by_clients</CommandText>
    304. 

  304.                     <Parameters />
    305. 

  305.                   </DbCommand>
    306. 

  306.                 </SelectCommand>
    307. 

  307.                 <UpdateCommand>
    308. 

  308.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    309. 

  309.                     <CommandText>UPDATE [dbo].[order_by_clients] SET [Пожелания] = @Пожелания WHERE (([Номер заказа] = @Original_Номер_заказа) AND ((@IsNull_Пожелания = 1 AND [Пожелания] IS NULL) OR ([Пожелания] = @Original_Пожелания)));
    310. 

  310. SELECT [Номер заказа], Пожелания FROM order_by_clients WHERE ([Номер заказа] = @Номер_заказа)</CommandText>
    311. 

  311.                     <Parameters>
    312. 

  312.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Пожелания" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пожелания" SourceColumnNullMapping="false" SourceVersion="Current" />
    313. 

  313.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Номер заказа" SourceColumnNullMapping="false" SourceVersion="Original" />
    314. 

  314.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пожелания" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пожелания" SourceColumnNullMapping="true" SourceVersion="Original" />
    315. 

  315.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Пожелания" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Пожелания" SourceColumnNullMapping="false" SourceVersion="Original" />
    316. 

  316.                       <Parameter AllowDbNull="false" AutogeneratedName="Номер_заказа" ColumnName="Номер заказа" DataSourceName="digital_world_8.dbo.order_by_clients" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Номер_заказа" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Номер заказа" SourceColumnNullMapping="false" SourceVersion="Current" />
    317. 

  317.                     </Parameters>
    318. 

  318.                   </DbCommand>
    319. 

  319.                 </UpdateCommand>
    320. 

  320.               </DbSource>
    321. 

  321.             </MainSource>
    322. 

  322.             <Mappings>
    323. 

  323.               <Mapping SourceColumn="Номер заказа" DataSetColumn="Номер заказа" />
    324. 

  324.               <Mapping SourceColumn="Пожелания" DataSetColumn="Пожелания" />
    325. 

  325.             </Mappings>
    326. 

  326.             <Sources />
    327. 

  327.           </TableAdapter>
    328. 

  328.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Order_statusTableAdapter" GeneratorDataComponentClassName="Order_statusTableAdapter" Name="Order_status" UserDataComponentName="Order_statusTableAdapter">
    329. 

  329.             <MainSource>
    330. 

  330.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.Order_status" 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">
    331. 

  331.                 <DeleteCommand>
    332. 

  332.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    333. 

  333.                     <CommandText>DELETE FROM [dbo].[Order_status] WHERE (([id] = @Original_id) AND ((@IsNull_Название_статуса = 1 AND [Название статуса] IS NULL) OR ([Название статуса] = @Original_Название_статуса)))</CommandText>
    334. 

  334.                     <Parameters>
    335. 

  335.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    336. 

  336.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название статуса" SourceColumnNullMapping="true" SourceVersion="Original" />
    337. 

  337.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название_статуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название статуса" SourceColumnNullMapping="false" SourceVersion="Original" />
    338. 

  338.                     </Parameters>
    339. 

  339.                   </DbCommand>
    340. 

  340.                 </DeleteCommand>
    341. 

  341.                 <InsertCommand>
    342. 

  342.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    343. 

  343.                     <CommandText>INSERT INTO [dbo].[Order_status] ([Название статуса]) VALUES (@Название_статуса);
    344. 

  344. SELECT id, [Название статуса] FROM Order_status WHERE (id = SCOPE_IDENTITY())</CommandText>
    345. 

  345.                     <Parameters>
    346. 

  346.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название_статуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название статуса" SourceColumnNullMapping="false" SourceVersion="Current" />
    347. 

  347.                     </Parameters>
    348. 

  348.                   </DbCommand>
    349. 

  349.                 </InsertCommand>
    350. 

  350.                 <SelectCommand>
    351. 

  351.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    352. 

  352.                     <CommandText>SELECT id, [Название статуса] FROM dbo.Order_status</CommandText>
    353. 

  353.                     <Parameters />
    354. 

  354.                   </DbCommand>
    355. 

  355.                 </SelectCommand>
    356. 

  356.                 <UpdateCommand>
    357. 

  357.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    358. 

  358.                     <CommandText>UPDATE [dbo].[Order_status] SET [Название статуса] = @Название_статуса WHERE (([id] = @Original_id) AND ((@IsNull_Название_статуса = 1 AND [Название статуса] IS NULL) OR ([Название статуса] = @Original_Название_статуса)));
    359. 

  359. SELECT id, [Название статуса] FROM Order_status WHERE (id = @id)</CommandText>
    360. 

  360.                     <Parameters>
    361. 

  361.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название_статуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название статуса" SourceColumnNullMapping="false" SourceVersion="Current" />
    362. 

  362.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    363. 

  363.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название_статуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название статуса" SourceColumnNullMapping="true" SourceVersion="Original" />
    364. 

  364.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название_статуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название статуса" SourceColumnNullMapping="false" SourceVersion="Original" />
    365. 

  365.                       <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="digital_world_8.dbo.Order_status" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
    366. 

  366.                     </Parameters>
    367. 

  367.                   </DbCommand>
    368. 

  368.                 </UpdateCommand>
    369. 

  369.               </DbSource>
    370. 

  370.             </MainSource>
    371. 

  371.             <Mappings>
    372. 

  372.               <Mapping SourceColumn="id" DataSetColumn="id" />
    373. 

  373.               <Mapping SourceColumn="Название статуса" DataSetColumn="Название статуса" />
    374. 

  374.             </Mappings>
    375. 

  375.             <Sources />
    376. 

  376.           </TableAdapter>
    377. 

  377.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="providerTableAdapter" GeneratorDataComponentClassName="providerTableAdapter" Name="provider" UserDataComponentName="providerTableAdapter">
    378. 

  378.             <MainSource>
    379. 

  379.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.provider" 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">
    380. 

  380.                 <DeleteCommand>
    381. 

  381.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    382. 

  382.                     <CommandText>DELETE FROM [dbo].[provider] WHERE (([id] = @Original_id) AND ((@IsNull_название = 1 AND [название] IS NULL) OR ([название] = @Original_название)) AND ((@IsNull_Страна_производитель = 1 AND [Страна производитель] IS NULL) OR ([Страна производитель] = @Original_Страна_производитель)))</CommandText>
    383. 

  383.                     <Parameters>
    384. 

  384.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    385. 

  385.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="true" SourceVersion="Original" />
    386. 

  386.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="false" SourceVersion="Original" />
    387. 

  387.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Страна_производитель" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Страна производитель" SourceColumnNullMapping="true" SourceVersion="Original" />
    388. 

  388.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Страна_производитель" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Страна производитель" SourceColumnNullMapping="false" SourceVersion="Original" />
    389. 

  389.                     </Parameters>
    390. 

  390.                   </DbCommand>
    391. 

  391.                 </DeleteCommand>
    392. 

  392.                 <InsertCommand>
    393. 

  393.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    394. 

  394.                     <CommandText>INSERT INTO [dbo].[provider] ([id], [название], [Страна производитель]) VALUES (@id, @название, @Страна_производитель);
    395. 

  395. SELECT id, название, [Страна производитель] FROM provider WHERE (id = @id)</CommandText>
    396. 

  396.                     <Parameters>
    397. 

  397.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
    398. 

  398.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="false" SourceVersion="Current" />
    399. 

  399.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Страна_производитель" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Страна производитель" SourceColumnNullMapping="false" SourceVersion="Current" />
    400. 

  400.                     </Parameters>
    401. 

  401.                   </DbCommand>
    402. 

  402.                 </InsertCommand>
    403. 

  403.                 <SelectCommand>
    404. 

  404.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    405. 

  405.                     <CommandText>SELECT id, название, [Страна производитель] FROM dbo.provider</CommandText>
    406. 

  406.                     <Parameters />
    407. 

  407.                   </DbCommand>
    408. 

  408.                 </SelectCommand>
    409. 

  409.                 <UpdateCommand>
    410. 

  410.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    411. 

  411.                     <CommandText>UPDATE [dbo].[provider] SET [id] = @id, [название] = @название, [Страна производитель] = @Страна_производитель WHERE (([id] = @Original_id) AND ((@IsNull_название = 1 AND [название] IS NULL) OR ([название] = @Original_название)) AND ((@IsNull_Страна_производитель = 1 AND [Страна производитель] IS NULL) OR ([Страна производитель] = @Original_Страна_производитель)));
    412. 

  412. SELECT id, название, [Страна производитель] FROM provider WHERE (id = @id)</CommandText>
    413. 

  413.                     <Parameters>
    414. 

  414.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
    415. 

  415.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="false" SourceVersion="Current" />
    416. 

  416.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Страна_производитель" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Страна производитель" SourceColumnNullMapping="false" SourceVersion="Current" />
    417. 

  417.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    418. 

  418.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="true" SourceVersion="Original" />
    419. 

  419.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="false" SourceVersion="Original" />
    420. 

  420.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Страна_производитель" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Страна производитель" SourceColumnNullMapping="true" SourceVersion="Original" />
    421. 

  421.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Страна_производитель" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Страна производитель" SourceColumnNullMapping="false" SourceVersion="Original" />
    422. 

  422.                     </Parameters>
    423. 

  423.                   </DbCommand>
    424. 

  424.                 </UpdateCommand>
    425. 

  425.               </DbSource>
    426. 

  426.             </MainSource>
    427. 

  427.             <Mappings>
    428. 

  428.               <Mapping SourceColumn="id" DataSetColumn="id" />
    429. 

  429.               <Mapping SourceColumn="название" DataSetColumn="название" />
    430. 

  430.               <Mapping SourceColumn="Страна производитель" DataSetColumn="Страна производитель" />
    431. 

  431.             </Mappings>
    432. 

  432.             <Sources />
    433. 

  433.           </TableAdapter>
    434. 

  434.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="receipt_of_goodsTableAdapter" GeneratorDataComponentClassName="receipt_of_goodsTableAdapter" Name="receipt_of_goods" UserDataComponentName="receipt_of_goodsTableAdapter">
    435. 

  435.             <MainSource>
    436. 

  436.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.receipt_of_goods" 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">
    437. 

  437.                 <DeleteCommand>
    438. 

  438.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    439. 

  439.                     <CommandText>DELETE FROM [dbo].[receipt_of_goods] WHERE (([id] = @Original_id) AND ((@IsNull_id_поставщика = 1 AND [id поставщика] IS NULL) OR ([id поставщика] = @Original_id_поставщика)) AND ((@IsNull_Id_компонентов = 1 AND [Id компонентов] IS NULL) OR ([Id компонентов] = @Original_Id_компонентов)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)))</CommandText>
    440. 

  440.                     <Parameters>
    441. 

  441.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    442. 

  442.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_поставщика" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id поставщика" SourceColumnNullMapping="true" SourceVersion="Original" />
    443. 

  443.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_поставщика" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id поставщика" SourceColumnNullMapping="false" SourceVersion="Original" />
    444. 

  444.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="true" SourceVersion="Original" />
    445. 

  445.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="false" SourceVersion="Original" />
    446. 

  446.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="true" SourceVersion="Original" />
    447. 

  447.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
    448. 

  448.                     </Parameters>
    449. 

  449.                   </DbCommand>
    450. 

  450.                 </DeleteCommand>
    451. 

  451.                 <InsertCommand>
    452. 

  452.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    453. 

  453.                     <CommandText>INSERT INTO [dbo].[receipt_of_goods] ([id поставщика], [Id компонентов], [Дата]) VALUES (@id_поставщика, @Id_компонентов, @Дата);
    454. 

  454. SELECT id, [id поставщика], [Id компонентов], Дата FROM receipt_of_goods WHERE (id = SCOPE_IDENTITY())</CommandText>
    455. 

  455.                     <Parameters>
    456. 

  456.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_поставщика" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id поставщика" SourceColumnNullMapping="false" SourceVersion="Current" />
    457. 

  457.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="false" SourceVersion="Current" />
    458. 

  458.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
    459. 

  459.                     </Parameters>
    460. 

  460.                   </DbCommand>
    461. 

  461.                 </InsertCommand>
    462. 

  462.                 <SelectCommand>
    463. 

  463.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    464. 

  464.                     <CommandText>SELECT id, [id поставщика], [Id компонентов], Дата FROM dbo.receipt_of_goods</CommandText>
    465. 

  465.                     <Parameters />
    466. 

  466.                   </DbCommand>
    467. 

  467.                 </SelectCommand>
    468. 

  468.                 <UpdateCommand>
    469. 

  469.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    470. 

  470.                     <CommandText>UPDATE [dbo].[receipt_of_goods] SET [id поставщика] = @id_поставщика, [Id компонентов] = @Id_компонентов, [Дата] = @Дата WHERE (([id] = @Original_id) AND ((@IsNull_id_поставщика = 1 AND [id поставщика] IS NULL) OR ([id поставщика] = @Original_id_поставщика)) AND ((@IsNull_Id_компонентов = 1 AND [Id компонентов] IS NULL) OR ([Id компонентов] = @Original_Id_компонентов)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)));
    471. 

  471. SELECT id, [id поставщика], [Id компонентов], Дата FROM receipt_of_goods WHERE (id = @id)</CommandText>
    472. 

  472.                     <Parameters>
    473. 

  473.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_поставщика" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id поставщика" SourceColumnNullMapping="false" SourceVersion="Current" />
    474. 

  474.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="false" SourceVersion="Current" />
    475. 

  475.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
    476. 

  476.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    477. 

  477.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_поставщика" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id поставщика" SourceColumnNullMapping="true" SourceVersion="Original" />
    478. 

  478.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_поставщика" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id поставщика" SourceColumnNullMapping="false" SourceVersion="Original" />
    479. 

  479.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="true" SourceVersion="Original" />
    480. 

  480.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_компонентов" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id компонентов" SourceColumnNullMapping="false" SourceVersion="Original" />
    481. 

  481.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="true" SourceVersion="Original" />
    482. 

  482.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
    483. 

  483.                       <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="digital_world_8.dbo.receipt_of_goods" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
    484. 

  484.                     </Parameters>
    485. 

  485.                   </DbCommand>
    486. 

  486.                 </UpdateCommand>
    487. 

  487.               </DbSource>
    488. 

  488.             </MainSource>
    489. 

  489.             <Mappings>
    490. 

  490.               <Mapping SourceColumn="id" DataSetColumn="id" />
    491. 

  491.               <Mapping SourceColumn="id поставщика" DataSetColumn="id поставщика" />
    492. 

  492.               <Mapping SourceColumn="Id компонентов" DataSetColumn="Id компонентов" />
    493. 

  493.               <Mapping SourceColumn="Дата" DataSetColumn="Дата" />
    494. 

  494.             </Mappings>
    495. 

  495.             <Sources />
    496. 

  496.           </TableAdapter>
    497. 

  497.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter">
    498. 

  498.             <MainSource>
    499. 

  499.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.Role" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    500. 

  500.                 <DeleteCommand>
    501. 

  501.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    502. 

  502.                     <CommandText>DELETE FROM [dbo].[Role] WHERE (([Id] = @Original_Id) AND ((@IsNull_Название_роли = 1 AND [Название роли] IS NULL) OR ([Название роли] = @Original_Название_роли)))</CommandText>
    503. 

  503.                     <Parameters>
    504. 

  504.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
    505. 

  505.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название_роли" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название роли" SourceColumnNullMapping="true" SourceVersion="Original" />
    506. 

  506.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название_роли" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название роли" SourceColumnNullMapping="false" SourceVersion="Original" />
    507. 

  507.                     </Parameters>
    508. 

  508.                   </DbCommand>
    509. 

  509.                 </DeleteCommand>
    510. 

  510.                 <InsertCommand>
    511. 

  511.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    512. 

  512.                     <CommandText>INSERT INTO [dbo].[Role] ([Id], [Название роли]) VALUES (@Id, @Название_роли);
    513. 

  513. SELECT Id, [Название роли] FROM Role WHERE (Id = @Id)</CommandText>
    514. 

  514.                     <Parameters>
    515. 

  515.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
    516. 

  516.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название_роли" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название роли" SourceColumnNullMapping="false" SourceVersion="Current" />
    517. 

  517.                     </Parameters>
    518. 

  518.                   </DbCommand>
    519. 

  519.                 </InsertCommand>
    520. 

  520.                 <SelectCommand>
    521. 

  521.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    522. 

  522.                     <CommandText>SELECT Id, [Название роли] FROM dbo.Role</CommandText>
    523. 

  523.                     <Parameters />
    524. 

  524.                   </DbCommand>
    525. 

  525.                 </SelectCommand>
    526. 

  526.                 <UpdateCommand>
    527. 

  527.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    528. 

  528.                     <CommandText>UPDATE [dbo].[Role] SET [Id] = @Id, [Название роли] = @Название_роли WHERE (([Id] = @Original_Id) AND ((@IsNull_Название_роли = 1 AND [Название роли] IS NULL) OR ([Название роли] = @Original_Название_роли)));
    529. 

  529. SELECT Id, [Название роли] FROM Role WHERE (Id = @Id)</CommandText>
    530. 

  530.                     <Parameters>
    531. 

  531.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
    532. 

  532.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название_роли" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название роли" SourceColumnNullMapping="false" SourceVersion="Current" />
    533. 

  533.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
    534. 

  534.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название_роли" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название роли" SourceColumnNullMapping="true" SourceVersion="Original" />
    535. 

  535.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название_роли" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название роли" SourceColumnNullMapping="false" SourceVersion="Original" />
    536. 

  536.                     </Parameters>
    537. 

  537.                   </DbCommand>
    538. 

  538.                 </UpdateCommand>
    539. 

  539.               </DbSource>
    540. 

  540.             </MainSource>
    541. 

  541.             <Mappings>
    542. 

  542.               <Mapping SourceColumn="Id" DataSetColumn="Id" />
    543. 

  543.               <Mapping SourceColumn="Название роли" DataSetColumn="Название роли" />
    544. 

  544.             </Mappings>
    545. 

  545.             <Sources />
    546. 

  546.           </TableAdapter>
    547. 

  547.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="unit_of_measurementTableAdapter" GeneratorDataComponentClassName="unit_of_measurementTableAdapter" Name="unit_of_measurement" UserDataComponentName="unit_of_measurementTableAdapter">
    548. 

  548.             <MainSource>
    549. 

  549.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.unit_of_measurement" 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">
    550. 

  550.                 <DeleteCommand>
    551. 

  551.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    552. 

  552.                     <CommandText>DELETE FROM [dbo].[unit_of_measurement] WHERE (([id] = @Original_id) AND ((@IsNull_название = 1 AND [название] IS NULL) OR ([название] = @Original_название)))</CommandText>
    553. 

  553.                     <Parameters>
    554. 

  554.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    555. 

  555.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="true" SourceVersion="Original" />
    556. 

  556.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="false" SourceVersion="Original" />
    557. 

  557.                     </Parameters>
    558. 

  558.                   </DbCommand>
    559. 

  559.                 </DeleteCommand>
    560. 

  560.                 <InsertCommand>
    561. 

  561.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    562. 

  562.                     <CommandText>INSERT INTO [dbo].[unit_of_measurement] ([название]) VALUES (@название);
    563. 

  563. SELECT id, название FROM unit_of_measurement WHERE (id = SCOPE_IDENTITY())</CommandText>
    564. 

  564.                     <Parameters>
    565. 

  565.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="false" SourceVersion="Current" />
    566. 

  566.                     </Parameters>
    567. 

  567.                   </DbCommand>
    568. 

  568.                 </InsertCommand>
    569. 

  569.                 <SelectCommand>
    570. 

  570.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    571. 

  571.                     <CommandText>SELECT id, название FROM dbo.unit_of_measurement</CommandText>
    572. 

  572.                     <Parameters />
    573. 

  573.                   </DbCommand>
    574. 

  574.                 </SelectCommand>
    575. 

  575.                 <UpdateCommand>
    576. 

  576.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    577. 

  577.                     <CommandText>UPDATE [dbo].[unit_of_measurement] SET [название] = @название WHERE (([id] = @Original_id) AND ((@IsNull_название = 1 AND [название] IS NULL) OR ([название] = @Original_название)));
    578. 

  578. SELECT id, название FROM unit_of_measurement WHERE (id = @id)</CommandText>
    579. 

  579.                     <Parameters>
    580. 

  580.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="false" SourceVersion="Current" />
    581. 

  581.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
    582. 

  582.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="true" SourceVersion="Original" />
    583. 

  583.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="название" SourceColumnNullMapping="false" SourceVersion="Original" />
    584. 

  584.                       <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="digital_world_8.dbo.unit_of_measurement" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
    585. 

  585.                     </Parameters>
    586. 

  586.                   </DbCommand>
    587. 

  587.                 </UpdateCommand>
    588. 

  588.               </DbSource>
    589. 

  589.             </MainSource>
    590. 

  590.             <Mappings>
    591. 

  591.               <Mapping SourceColumn="id" DataSetColumn="id" />
    592. 

  592.               <Mapping SourceColumn="название" DataSetColumn="название" />
    593. 

  593.             </Mappings>
    594. 

  594.             <Sources />
    595. 

  595.           </TableAdapter>
    596. 

  596.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
    597. 

  597.             <MainSource>
    598. 

  598.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.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">
    599. 

  599.                 <DeleteCommand>
    600. 

  600.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    601. 

  601.                     <CommandText>DELETE FROM [dbo].[Users] WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)))</CommandText>
    602. 

  602.                     <Parameters>
    603. 

  603.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
    604. 

  604.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="true" SourceVersion="Original" />
    605. 

  605.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
    606. 

  606.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
    607. 

  607.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
    608. 

  608.                       <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" />
    609. 

  609.                       <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" />
    610. 

  610.                     </Parameters>
    611. 

  611.                   </DbCommand>
    612. 

  612.                 </DeleteCommand>
    613. 

  613.                 <InsertCommand>
    614. 

  614.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    615. 

  615.                     <CommandText>INSERT INTO [dbo].[Users] ([Id], [Username], [Password], [Role]) VALUES (@Id, @Username, @Password, @Role);
    616. 

  616. SELECT Id, Username, Password, Role FROM Users WHERE (Id = @Id)</CommandText>
    617. 

  617.                     <Parameters>
    618. 

  618.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
    619. 

  619.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
    620. 

  620.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
    621. 

  621.                       <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" />
    622. 

  622.                     </Parameters>
    623. 

  623.                   </DbCommand>
    624. 

  624.                 </InsertCommand>
    625. 

  625.                 <SelectCommand>
    626. 

  626.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    627. 

  627.                     <CommandText>SELECT Id, Username, Password, Role FROM dbo.Users</CommandText>
    628. 

  628.                     <Parameters />
    629. 

  629.                   </DbCommand>
    630. 

  630.                 </SelectCommand>
    631. 

  631.                 <UpdateCommand>
    632. 

  632.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    633. 

  633.                     <CommandText>UPDATE [dbo].[Users] SET [Id] = @Id, [Username] = @Username, [Password] = @Password, [Role] = @Role WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)));
    634. 

  634. SELECT Id, Username, Password, Role FROM Users WHERE (Id = @Id)</CommandText>
    635. 

  635.                     <Parameters>
    636. 

  636.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
    637. 

  637.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
    638. 

  638.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
    639. 

  639.                       <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" />
    640. 

  640.                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
    641. 

  641.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="true" SourceVersion="Original" />
    642. 

  642.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
    643. 

  643.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
    644. 

  644.                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
    645. 

  645.                       <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" />
    646. 

  646.                       <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" />
    647. 

  647.                     </Parameters>
    648. 

  648.                   </DbCommand>
    649. 

  649.                 </UpdateCommand>
    650. 

  650.               </DbSource>
    651. 

  651.             </MainSource>
    652. 

  652.             <Mappings>
    653. 

  653.               <Mapping SourceColumn="Id" DataSetColumn="Id" />
    654. 

  654.               <Mapping SourceColumn="Username" DataSetColumn="Username" />
    655. 

  655.               <Mapping SourceColumn="Password" DataSetColumn="Password" />
    656. 

  656.               <Mapping SourceColumn="Role" DataSetColumn="Role" />
    657. 

  657.             </Mappings>
    658. 

  658.             <Sources />
    659. 

  659.           </TableAdapter>
    660. 

  660.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PostavkaTableAdapter" GeneratorDataComponentClassName="PostavkaTableAdapter" Name="Postavka" UserDataComponentName="PostavkaTableAdapter">
    661. 

  661.             <MainSource>
    662. 

  662.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.Postavka" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    663. 

  663.                 <SelectCommand>
    664. 

  664.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    665. 

  665.                     <CommandText>SELECT Дата, [Наименование поставщика], [Название материала], Тип_материала, количество, [Единица измерения] FROM dbo.Postavka</CommandText>
    666. 

  666.                     <Parameters />
    667. 

  667.                   </DbCommand>
    668. 

  668.                 </SelectCommand>
    669. 

  669.               </DbSource>
    670. 

  670.             </MainSource>
    671. 

  671.             <Mappings>
    672. 

  672.               <Mapping SourceColumn="Дата" DataSetColumn="Дата" />
    673. 

  673.               <Mapping SourceColumn="Наименование поставщика" DataSetColumn="Наименование поставщика" />
    674. 

  674.               <Mapping SourceColumn="Название материала" DataSetColumn="Название материала" />
    675. 

  675.               <Mapping SourceColumn="Тип_материала" DataSetColumn="Тип_материала" />
    676. 

  676.               <Mapping SourceColumn="количество" DataSetColumn="количество" />
    677. 

  677.               <Mapping SourceColumn="Единица измерения" DataSetColumn="Единица измерения" />
    678. 

  678.             </Mappings>
    679. 

  679.             <Sources />
    680. 

  680.           </TableAdapter>
    681. 

  681.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ZakazTableAdapter" GeneratorDataComponentClassName="ZakazTableAdapter" Name="Zakaz" UserDataComponentName="ZakazTableAdapter">
    682. 

  682.             <MainSource>
    683. 

  683.               <DbSource ConnectionRef="digital_world_8ConnectionString (Settings)" DbObjectName="digital_world_8.dbo.Zakaz" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
    684. 

  684.                 <SelectCommand>
    685. 

  685.                   <DbCommand CommandType="Text" ModifiedByUser="false">
    686. 

  686.                     <CommandText>SELECT [Номер заказа], [Название статуса], Видеокарта, [Материнская плата], Процессор, [Оперативная память], Оперативная_память, [Жетский диск], Куллер, [Система охлаждения], [Блок питания], SSD FROM dbo.Zakaz</CommandText>
    687. 

  687.                     <Parameters />
    688. 

  688.                   </DbCommand>
    689. 

  689.                 </SelectCommand>
    690. 

  690.               </DbSource>
    691. 

  691.             </MainSource>
    692. 

  692.             <Mappings>
    693. 

  693.               <Mapping SourceColumn="Номер заказа" DataSetColumn="Номер заказа" />
    694. 

  694.               <Mapping SourceColumn="Название статуса" DataSetColumn="Название статуса" />
    695. 

  695.               <Mapping SourceColumn="Видеокарта" DataSetColumn="Видеокарта" />
    696. 

  696.               <Mapping SourceColumn="Материнская плата" DataSetColumn="Материнская плата" />
    697. 

  697.               <Mapping SourceColumn="Процессор" DataSetColumn="Процессор" />
    698. 

  698.               <Mapping SourceColumn="Оперативная память" DataSetColumn="Оперативная память" />
    699. 

  699.               <Mapping SourceColumn="Оперативная_память" DataSetColumn="Оперативная_память" />
    700. 

  700.               <Mapping SourceColumn="Жетский диск" DataSetColumn="Жетский диск" />
    701. 

  701.               <Mapping SourceColumn="Куллер" DataSetColumn="Куллер" />
    702. 

  702.               <Mapping SourceColumn="Система охлаждения" DataSetColumn="Система охлаждения" />
    703. 

  703.               <Mapping SourceColumn="Блок питания" DataSetColumn="Блок питания" />
    704. 

  704.               <Mapping SourceColumn="SSD" DataSetColumn="SSD" />
    705. 

  705.             </Mappings>
    706. 

  706.             <Sources />
    707. 

  707.           </TableAdapter>
    708. 

  708.         </Tables>
    709. 

  709.         <Sources />
    710. 

  710.       </DataSource>
    711. 

  711.     </xs:appinfo>
    712. 

  712.   </xs:annotation>
    713. 

  713.   <xs:element name="digital_world_8DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="digital_world_8DataSet" msprop:Generator_DataSetName="digital_world_8DataSet">
    714. 

  714.     <xs:complexType>
    715. 

  715.       <xs:choice minOccurs="0" maxOccurs="unbounded">
    716. 

  716.         <xs:element name="Components" msprop:Generator_RowEvHandlerName="ComponentsRowChangeEventHandler" msprop:Generator_RowDeletedName="ComponentsRowDeleted" msprop:Generator_RowDeletingName="ComponentsRowDeleting" msprop:Generator_RowEvArgName="ComponentsRowChangeEvent" msprop:Generator_TablePropName="Components" msprop:Generator_RowChangedName="ComponentsRowChanged" msprop:Generator_RowChangingName="ComponentsRowChanging" msprop:Generator_TableClassName="ComponentsDataTable" msprop:Generator_RowClassName="ComponentsRow" msprop:Generator_TableVarName="tableComponents" msprop:Generator_UserTableName="Components">
    717. 

  717.           <xs:complexType>
    718. 

  718.             <xs:sequence>
    719. 

  719.               <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
    720. 

  720.               <xs:element name="Название" msprop:Generator_ColumnPropNameInRow="Название" msprop:Generator_ColumnPropNameInTable="НазваниеColumn" msprop:Generator_ColumnVarNameInTable="columnНазвание" msprop:Generator_UserColumnName="Название" minOccurs="0">
    721. 

  721.                 <xs:simpleType>
    722. 

  722.                   <xs:restriction base="xs:string">
    723. 

  723.                     <xs:maxLength value="2147483647" />
    724. 

  724.                   </xs:restriction>
    725. 

  725.                 </xs:simpleType>
    726. 

  726.               </xs:element>
    727. 

  727.               <xs:element name="Id_x0020_единицы_x0020_измерения" msprop:Generator_ColumnPropNameInRow="Id_единицы_измерения" msprop:Generator_ColumnPropNameInTable="Id_единицы_измеренияColumn" msprop:Generator_ColumnVarNameInTable="columnId_единицы_измерения" msprop:Generator_UserColumnName="Id единицы измерения" type="xs:int" minOccurs="0" />
    728. 

  728.               <xs:element name="Тип_материала" msprop:Generator_ColumnPropNameInRow="Тип_материала" msprop:Generator_ColumnPropNameInTable="Тип_материалаColumn" msprop:Generator_ColumnVarNameInTable="columnТип_материала" msprop:Generator_UserColumnName="Тип_материала" minOccurs="0">
    729. 

  729.                 <xs:simpleType>
    730. 

  730.                   <xs:restriction base="xs:string">
    731. 

  731.                     <xs:maxLength value="50" />
    732. 

  732.                   </xs:restriction>
    733. 

  733.                 </xs:simpleType>
    734. 

  734.               </xs:element>
    735. 

  735.               <xs:element name="Цена" msprop:Generator_ColumnPropNameInRow="Цена" msprop:Generator_ColumnPropNameInTable="ЦенаColumn" msprop:Generator_ColumnVarNameInTable="columnЦена" msprop:Generator_UserColumnName="Цена" type="xs:int" minOccurs="0" />
    736. 

  736.               <xs:element name="количество" msprop:Generator_ColumnPropNameInRow="количество" msprop:Generator_ColumnPropNameInTable="количествоColumn" msprop:Generator_ColumnVarNameInTable="columnколичество" msprop:Generator_UserColumnName="количество" type="xs:int" minOccurs="0" />
    737. 

  737.             </xs:sequence>
    738. 

  738.           </xs:complexType>
    739. 

  739.         </xs:element>
    740. 

  740.         <xs:element name="computer_assembly" msprop:Generator_RowEvHandlerName="computer_assemblyRowChangeEventHandler" msprop:Generator_RowDeletedName="computer_assemblyRowDeleted" msprop:Generator_RowDeletingName="computer_assemblyRowDeleting" msprop:Generator_RowEvArgName="computer_assemblyRowChangeEvent" msprop:Generator_TablePropName="computer_assembly" msprop:Generator_RowChangedName="computer_assemblyRowChanged" msprop:Generator_RowChangingName="computer_assemblyRowChanging" msprop:Generator_TableClassName="computer_assemblyDataTable" msprop:Generator_RowClassName="computer_assemblyRow" msprop:Generator_TableVarName="tablecomputer_assembly" msprop:Generator_UserTableName="computer_assembly">
    741. 

  741.           <xs:complexType>
    742. 

  742.             <xs:sequence>
    743. 

  743.               <xs:element name="id_x0020_сборки" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id_сборки" msprop:Generator_ColumnPropNameInTable="id_сборкиColumn" msprop:Generator_ColumnVarNameInTable="columnid_сборки" msprop:Generator_UserColumnName="id сборки" type="xs:int" />
    744. 

  744.               <xs:element name="Id_x0020_компонентов" msprop:Generator_ColumnPropNameInRow="Id_компонентов" msprop:Generator_ColumnPropNameInTable="Id_компонентовColumn" msprop:Generator_ColumnVarNameInTable="columnId_компонентов" msprop:Generator_UserColumnName="Id компонентов" type="xs:int" minOccurs="0" />
    745. 

  745.               <xs:element name="Количество" msprop:Generator_ColumnPropNameInRow="Количество" msprop:Generator_ColumnPropNameInTable="КоличествоColumn" msprop:Generator_ColumnVarNameInTable="columnКоличество" msprop:Generator_UserColumnName="Количество" type="xs:int" minOccurs="0" />
    746. 

  746.               <xs:element name="Видеокарта" msprop:Generator_ColumnPropNameInRow="Видеокарта" msprop:Generator_ColumnPropNameInTable="ВидеокартаColumn" msprop:Generator_ColumnVarNameInTable="columnВидеокарта" msprop:Generator_UserColumnName="Видеокарта" minOccurs="0">
    747. 

  747.                 <xs:simpleType>
    748. 

  748.                   <xs:restriction base="xs:string">
    749. 

  749.                     <xs:maxLength value="150" />
    750. 

  750.                   </xs:restriction>
    751. 

  751.                 </xs:simpleType>
    752. 

  752.               </xs:element>
    753. 

  753.               <xs:element name="Материнская_x0020_плата" msprop:Generator_ColumnPropNameInRow="Материнская_плата" msprop:Generator_ColumnPropNameInTable="Материнская_платаColumn" msprop:Generator_ColumnVarNameInTable="columnМатеринская_плата" msprop:Generator_UserColumnName="Материнская плата" minOccurs="0">
    754. 

  754.                 <xs:simpleType>
    755. 

  755.                   <xs:restriction base="xs:string">
    756. 

  756.                     <xs:maxLength value="150" />
    757. 

  757.                   </xs:restriction>
    758. 

  758.                 </xs:simpleType>
    759. 

  759.               </xs:element>
    760. 

  760.               <xs:element name="Процессор" msprop:Generator_ColumnPropNameInRow="Процессор" msprop:Generator_ColumnPropNameInTable="ПроцессорColumn" msprop:Generator_ColumnVarNameInTable="columnПроцессор" msprop:Generator_UserColumnName="Процессор" minOccurs="0">
    761. 

  761.                 <xs:simpleType>
    762. 

  762.                   <xs:restriction base="xs:string">
    763. 

  763.                     <xs:maxLength value="150" />
    764. 

  764.                   </xs:restriction>
    765. 

  765.                 </xs:simpleType>
    766. 

  766.               </xs:element>
    767. 

  767.               <xs:element name="Оперативная_x0020_память" msprop:Generator_ColumnPropNameInRow="Оперативная_память" msprop:Generator_ColumnPropNameInTable="Оперативная_памятьColumn" msprop:Generator_ColumnVarNameInTable="columnОперативная_память" msprop:Generator_UserColumnName="Оперативная память" minOccurs="0">
    768. 

  768.                 <xs:simpleType>
    769. 

  769.                   <xs:restriction base="xs:string">
    770. 

  770.                     <xs:maxLength value="150" />
    771. 

  771.                   </xs:restriction>
    772. 

  772.                 </xs:simpleType>
    773. 

  773.               </xs:element>
    774. 

  774.               <xs:element name="Оперативная_память" msprop:Generator_ColumnPropNameInRow="_Оперативная_память" msprop:Generator_ColumnPropNameInTable="_Оперативная_памятьColumn" msprop:Generator_ColumnVarNameInTable="_columnОперативная_память" msprop:Generator_UserColumnName="Оперативная_память" minOccurs="0">
    775. 

  775.                 <xs:simpleType>
    776. 

  776.                   <xs:restriction base="xs:string">
    777. 

  777.                     <xs:maxLength value="150" />
    778. 

  778.                   </xs:restriction>
    779. 

  779.                 </xs:simpleType>
    780. 

  780.               </xs:element>
    781. 

  781.               <xs:element name="Жетский_x0020_диск" msprop:Generator_ColumnPropNameInRow="Жетский_диск" msprop:Generator_ColumnPropNameInTable="Жетский_дискColumn" msprop:Generator_ColumnVarNameInTable="columnЖетский_диск" msprop:Generator_UserColumnName="Жетский диск" minOccurs="0">
    782. 

  782.                 <xs:simpleType>
    783. 

  783.                   <xs:restriction base="xs:string">
    784. 

  784.                     <xs:maxLength value="150" />
    785. 

  785.                   </xs:restriction>
    786. 

  786.                 </xs:simpleType>
    787. 

  787.               </xs:element>
    788. 

  788.               <xs:element name="Куллер" msprop:Generator_ColumnPropNameInRow="Куллер" msprop:Generator_ColumnPropNameInTable="КуллерColumn" msprop:Generator_ColumnVarNameInTable="columnКуллер" msprop:Generator_UserColumnName="Куллер" minOccurs="0">
    789. 

  789.                 <xs:simpleType>
    790. 

  790.                   <xs:restriction base="xs:string">
    791. 

  791.                     <xs:maxLength value="150" />
    792. 

  792.                   </xs:restriction>
    793. 

  793.                 </xs:simpleType>
    794. 

  794.               </xs:element>
    795. 

  795.               <xs:element name="Система_x0020_охлаждения" msprop:Generator_ColumnPropNameInRow="Система_охлаждения" msprop:Generator_ColumnPropNameInTable="Система_охлажденияColumn" msprop:Generator_ColumnVarNameInTable="columnСистема_охлаждения" msprop:Generator_UserColumnName="Система охлаждения" minOccurs="0">
    796. 

  796.                 <xs:simpleType>
    797. 

  797.                   <xs:restriction base="xs:string">
    798. 

  798.                     <xs:maxLength value="150" />
    799. 

  799.                   </xs:restriction>
    800. 

  800.                 </xs:simpleType>
    801. 

  801.               </xs:element>
    802. 

  802.               <xs:element name="Блок_x0020_питания" msprop:Generator_ColumnPropNameInRow="Блок_питания" msprop:Generator_ColumnPropNameInTable="Блок_питанияColumn" msprop:Generator_ColumnVarNameInTable="columnБлок_питания" msprop:Generator_UserColumnName="Блок питания" minOccurs="0">
    803. 

  803.                 <xs:simpleType>
    804. 

  804.                   <xs:restriction base="xs:string">
    805. 

  805.                     <xs:maxLength value="150" />
    806. 

  806.                   </xs:restriction>
    807. 

  807.                 </xs:simpleType>
    808. 

  808.               </xs:element>
    809. 

  809.               <xs:element name="SSD" msprop:Generator_ColumnPropNameInRow="SSD" msprop:Generator_ColumnPropNameInTable="SSDColumn" msprop:Generator_ColumnVarNameInTable="columnSSD" msprop:Generator_UserColumnName="SSD" minOccurs="0">
    810. 

  810.                 <xs:simpleType>
    811. 

  811.                   <xs:restriction base="xs:string">
    812. 

  812.                     <xs:maxLength value="150" />
    813. 

  813.                   </xs:restriction>
    814. 

  814.                 </xs:simpleType>
    815. 

  815.               </xs:element>
    816. 

  816.             </xs:sequence>
    817. 

  817.           </xs:complexType>
    818. 

  818.         </xs:element>
    819. 

  819.         <xs:element name="Order" msprop:Generator_RowEvHandlerName="OrderRowChangeEventHandler" msprop:Generator_RowDeletedName="OrderRowDeleted" msprop:Generator_RowDeletingName="OrderRowDeleting" msprop:Generator_RowEvArgName="OrderRowChangeEvent" msprop:Generator_TablePropName="Order" msprop:Generator_RowChangedName="OrderRowChanged" msprop:Generator_RowChangingName="OrderRowChanging" msprop:Generator_TableClassName="OrderDataTable" msprop:Generator_RowClassName="OrderRow" msprop:Generator_TableVarName="tableOrder" msprop:Generator_UserTableName="Order">
    820. 

  820.           <xs:complexType>
    821. 

  821.             <xs:sequence>
    822. 

  822.               <xs:element name="Id_заказа" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="Id_заказа" msprop:Generator_ColumnPropNameInTable="Id_заказаColumn" msprop:Generator_ColumnVarNameInTable="columnId_заказа" msprop:Generator_UserColumnName="Id_заказа" type="xs:int" />
    823. 

  823.               <xs:element name="Номер_x0020_заказа" msprop:Generator_ColumnPropNameInRow="Номер_заказа" msprop:Generator_ColumnPropNameInTable="Номер_заказаColumn" msprop:Generator_ColumnVarNameInTable="columnНомер_заказа" msprop:Generator_UserColumnName="Номер заказа" type="xs:int" minOccurs="0" />
    824. 

  824.               <xs:element name="Дата" msprop:Generator_ColumnPropNameInRow="Дата" msprop:Generator_ColumnPropNameInTable="ДатаColumn" msprop:Generator_ColumnVarNameInTable="columnДата" msprop:Generator_UserColumnName="Дата" type="xs:dateTime" minOccurs="0" />
    825. 

  825.               <xs:element name="id_x0020_сборки" msprop:Generator_ColumnPropNameInRow="id_сборки" msprop:Generator_ColumnPropNameInTable="id_сборкиColumn" msprop:Generator_ColumnVarNameInTable="columnid_сборки" msprop:Generator_UserColumnName="id сборки" type="xs:int" minOccurs="0" />
    826. 

  826.               <xs:element name="id_x0020_статуса" msprop:Generator_ColumnPropNameInRow="id_статуса" msprop:Generator_ColumnPropNameInTable="id_статусаColumn" msprop:Generator_ColumnVarNameInTable="columnid_статуса" msprop:Generator_UserColumnName="id статуса" type="xs:int" minOccurs="0" />
    827. 

  827.             </xs:sequence>
    828. 

  828.           </xs:complexType>
    829. 

  829.         </xs:element>
    830. 

  830.         <xs:element name="order_by_clients" msprop:Generator_RowEvHandlerName="order_by_clientsRowChangeEventHandler" msprop:Generator_RowDeletedName="order_by_clientsRowDeleted" msprop:Generator_RowDeletingName="order_by_clientsRowDeleting" msprop:Generator_RowEvArgName="order_by_clientsRowChangeEvent" msprop:Generator_TablePropName="order_by_clients" msprop:Generator_RowChangedName="order_by_clientsRowChanged" msprop:Generator_RowChangingName="order_by_clientsRowChanging" msprop:Generator_TableClassName="order_by_clientsDataTable" msprop:Generator_RowClassName="order_by_clientsRow" msprop:Generator_TableVarName="tableorder_by_clients" msprop:Generator_UserTableName="order_by_clients">
    831. 

  831.           <xs:complexType>
    832. 

  832.             <xs:sequence>
    833. 

  833.               <xs:element name="Номер_x0020_заказа" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="Номер_заказа" msprop:Generator_ColumnPropNameInTable="Номер_заказаColumn" msprop:Generator_ColumnVarNameInTable="columnНомер_заказа" msprop:Generator_UserColumnName="Номер заказа" type="xs:int" />
    834. 

  834.               <xs:element name="Пожелания" msprop:Generator_ColumnPropNameInRow="Пожелания" msprop:Generator_ColumnPropNameInTable="ПожеланияColumn" msprop:Generator_ColumnVarNameInTable="columnПожелания" msprop:Generator_UserColumnName="Пожелания" minOccurs="0">
    835. 

  835.                 <xs:simpleType>
    836. 

  836.                   <xs:restriction base="xs:string">
    837. 

  837.                     <xs:maxLength value="50" />
    838. 

  838.                   </xs:restriction>
    839. 

  839.                 </xs:simpleType>
    840. 

  840.               </xs:element>
    841. 

  841.             </xs:sequence>
    842. 

  842.           </xs:complexType>
    843. 

  843.         </xs:element>
    844. 

  844.         <xs:element name="Order_status" msprop:Generator_RowEvHandlerName="Order_statusRowChangeEventHandler" msprop:Generator_RowDeletedName="Order_statusRowDeleted" msprop:Generator_RowDeletingName="Order_statusRowDeleting" msprop:Generator_RowEvArgName="Order_statusRowChangeEvent" msprop:Generator_TablePropName="Order_status" msprop:Generator_RowChangedName="Order_statusRowChanged" msprop:Generator_RowChangingName="Order_statusRowChanging" msprop:Generator_TableClassName="Order_statusDataTable" msprop:Generator_RowClassName="Order_statusRow" msprop:Generator_TableVarName="tableOrder_status" msprop:Generator_UserTableName="Order_status">
    845. 

  845.           <xs:complexType>
    846. 

  846.             <xs:sequence>
    847. 

  847.               <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
    848. 

  848.               <xs:element name="Название_x0020_статуса" msprop:Generator_ColumnPropNameInRow="Название_статуса" msprop:Generator_ColumnPropNameInTable="Название_статусаColumn" msprop:Generator_ColumnVarNameInTable="columnНазвание_статуса" msprop:Generator_UserColumnName="Название статуса" minOccurs="0">
    849. 

  849.                 <xs:simpleType>
    850. 

  850.                   <xs:restriction base="xs:string">
    851. 

  851.                     <xs:maxLength value="50" />
    852. 

  852.                   </xs:restriction>
    853. 

  853.                 </xs:simpleType>
    854. 

  854.               </xs:element>
    855. 

  855.             </xs:sequence>
    856. 

  856.           </xs:complexType>
    857. 

  857.         </xs:element>
    858. 

  858.         <xs:element name="provider" msprop:Generator_RowEvHandlerName="providerRowChangeEventHandler" msprop:Generator_RowDeletedName="providerRowDeleted" msprop:Generator_RowDeletingName="providerRowDeleting" msprop:Generator_RowEvArgName="providerRowChangeEvent" msprop:Generator_TablePropName="provider" msprop:Generator_RowChangedName="providerRowChanged" msprop:Generator_RowChangingName="providerRowChanging" msprop:Generator_TableClassName="providerDataTable" msprop:Generator_RowClassName="providerRow" msprop:Generator_TableVarName="tableprovider" msprop:Generator_UserTableName="provider">
    859. 

  859.           <xs:complexType>
    860. 

  860.             <xs:sequence>
    861. 

  861.               <xs:element name="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
    862. 

  862.               <xs:element name="название" msprop:Generator_ColumnPropNameInRow="название" msprop:Generator_ColumnPropNameInTable="названиеColumn" msprop:Generator_ColumnVarNameInTable="columnназвание" msprop:Generator_UserColumnName="название" minOccurs="0">
    863. 

  863.                 <xs:simpleType>
    864. 

  864.                   <xs:restriction base="xs:string">
    865. 

  865.                     <xs:maxLength value="50" />
    866. 

  866.                   </xs:restriction>
    867. 

  867.                 </xs:simpleType>
    868. 

  868.               </xs:element>
    869. 

  869.               <xs:element name="Страна_x0020_производитель" msprop:Generator_ColumnPropNameInRow="Страна_производитель" msprop:Generator_ColumnPropNameInTable="Страна_производительColumn" msprop:Generator_ColumnVarNameInTable="columnСтрана_производитель" msprop:Generator_UserColumnName="Страна производитель" minOccurs="0">
    870. 

  870.                 <xs:simpleType>
    871. 

  871.                   <xs:restriction base="xs:string">
    872. 

  872.                     <xs:maxLength value="50" />
    873. 

  873.                   </xs:restriction>
    874. 

  874.                 </xs:simpleType>
    875. 

  875.               </xs:element>
    876. 

  876.             </xs:sequence>
    877. 

  877.           </xs:complexType>
    878. 

  878.         </xs:element>
    879. 

  879.         <xs:element name="receipt_of_goods" msprop:Generator_RowEvHandlerName="receipt_of_goodsRowChangeEventHandler" msprop:Generator_RowDeletedName="receipt_of_goodsRowDeleted" msprop:Generator_RowDeletingName="receipt_of_goodsRowDeleting" msprop:Generator_RowEvArgName="receipt_of_goodsRowChangeEvent" msprop:Generator_TablePropName="receipt_of_goods" msprop:Generator_RowChangedName="receipt_of_goodsRowChanged" msprop:Generator_RowChangingName="receipt_of_goodsRowChanging" msprop:Generator_TableClassName="receipt_of_goodsDataTable" msprop:Generator_RowClassName="receipt_of_goodsRow" msprop:Generator_TableVarName="tablereceipt_of_goods" msprop:Generator_UserTableName="receipt_of_goods">
    880. 

  880.           <xs:complexType>
    881. 

  881.             <xs:sequence>
    882. 

  882.               <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
    883. 

  883.               <xs:element name="id_x0020_поставщика" msprop:Generator_ColumnPropNameInRow="id_поставщика" msprop:Generator_ColumnPropNameInTable="id_поставщикаColumn" msprop:Generator_ColumnVarNameInTable="columnid_поставщика" msprop:Generator_UserColumnName="id поставщика" type="xs:int" minOccurs="0" />
    884. 

  884.               <xs:element name="Id_x0020_компонентов" msprop:Generator_ColumnPropNameInRow="Id_компонентов" msprop:Generator_ColumnPropNameInTable="Id_компонентовColumn" msprop:Generator_ColumnVarNameInTable="columnId_компонентов" msprop:Generator_UserColumnName="Id компонентов" type="xs:int" minOccurs="0" />
    885. 

  885.               <xs:element name="Дата" msprop:Generator_ColumnPropNameInRow="Дата" msprop:Generator_ColumnPropNameInTable="ДатаColumn" msprop:Generator_ColumnVarNameInTable="columnДата" msprop:Generator_UserColumnName="Дата" type="xs:dateTime" minOccurs="0" />
    886. 

  886.             </xs:sequence>
    887. 

  887.           </xs:complexType>
    888. 

  888.         </xs:element>
    889. 

  889.         <xs:element name="Role" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_RowEvArgName="RoleRowChangeEvent" msprop:Generator_TablePropName="Role" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_RowClassName="RoleRow" msprop:Generator_TableVarName="tableRole" msprop:Generator_UserTableName="Role">
    890. 

  890.           <xs:complexType>
    891. 

  891.             <xs:sequence>
    892. 

  892.               <xs:element name="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_UserColumnName="Id" type="xs:int" />
    893. 

  893.               <xs:element name="Название_x0020_роли" msprop:Generator_ColumnPropNameInRow="Название_роли" msprop:Generator_ColumnPropNameInTable="Название_ролиColumn" msprop:Generator_ColumnVarNameInTable="columnНазвание_роли" msprop:Generator_UserColumnName="Название роли" minOccurs="0">
    894. 

  894.                 <xs:simpleType>
    895. 

  895.                   <xs:restriction base="xs:string">
    896. 

  896.                     <xs:maxLength value="50" />
    897. 

  897.                   </xs:restriction>
    898. 

  898.                 </xs:simpleType>
    899. 

  899.               </xs:element>
    900. 

  900.             </xs:sequence>
    901. 

  901.           </xs:complexType>
    902. 

  902.         </xs:element>
    903. 

  903.         <xs:element name="unit_of_measurement" msprop:Generator_RowEvHandlerName="unit_of_measurementRowChangeEventHandler" msprop:Generator_RowDeletedName="unit_of_measurementRowDeleted" msprop:Generator_RowDeletingName="unit_of_measurementRowDeleting" msprop:Generator_RowEvArgName="unit_of_measurementRowChangeEvent" msprop:Generator_TablePropName="unit_of_measurement" msprop:Generator_RowChangedName="unit_of_measurementRowChanged" msprop:Generator_RowChangingName="unit_of_measurementRowChanging" msprop:Generator_TableClassName="unit_of_measurementDataTable" msprop:Generator_RowClassName="unit_of_measurementRow" msprop:Generator_TableVarName="tableunit_of_measurement" msprop:Generator_UserTableName="unit_of_measurement">
    904. 

  904.           <xs:complexType>
    905. 

  905.             <xs:sequence>
    906. 

  906.               <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_UserColumnName="id" type="xs:int" />
    907. 

  907.               <xs:element name="название" msprop:Generator_ColumnPropNameInRow="название" msprop:Generator_ColumnPropNameInTable="названиеColumn" msprop:Generator_ColumnVarNameInTable="columnназвание" msprop:Generator_UserColumnName="название" minOccurs="0">
    908. 

  908.                 <xs:simpleType>
    909. 

  909.                   <xs:restriction base="xs:string">
    910. 

  910.                     <xs:maxLength value="50" />
    911. 

  911.                   </xs:restriction>
    912. 

  912.                 </xs:simpleType>
    913. 

  913.               </xs:element>
    914. 

  914.             </xs:sequence>
    915. 

  915.           </xs:complexType>
    916. 

  916.         </xs:element>
    917. 

  917.         <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">
    918. 

  918.           <xs:complexType>
    919. 

  919.             <xs:sequence>
    920. 

  920.               <xs:element name="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_UserColumnName="Id" type="xs:int" />
    921. 

  921.               <xs:element name="Username" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_UserColumnName="Username" minOccurs="0">
    922. 

  922.                 <xs:simpleType>
    923. 

  923.                   <xs:restriction base="xs:string">
    924. 

  924.                     <xs:maxLength value="50" />
    925. 

  925.                   </xs:restriction>
    926. 

  926.                 </xs:simpleType>
    927. 

  927.               </xs:element>
    928. 

  928.               <xs:element name="Password" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_UserColumnName="Password" minOccurs="0">
    929. 

  929.                 <xs:simpleType>
    930. 

  930.                   <xs:restriction base="xs:string">
    931. 

  931.                     <xs:maxLength value="50" />
    932. 

  932.                   </xs:restriction>
    933. 

  933.                 </xs:simpleType>
    934. 

  934.               </xs:element>
    935. 

  935.               <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" />
    936. 

  936.             </xs:sequence>
    937. 

  937.           </xs:complexType>
    938. 

  938.         </xs:element>
    939. 

  939.         <xs:element name="Postavka" msprop:Generator_RowEvHandlerName="PostavkaRowChangeEventHandler" msprop:Generator_RowDeletedName="PostavkaRowDeleted" msprop:Generator_RowDeletingName="PostavkaRowDeleting" msprop:Generator_RowEvArgName="PostavkaRowChangeEvent" msprop:Generator_TablePropName="Postavka" msprop:Generator_RowChangedName="PostavkaRowChanged" msprop:Generator_RowChangingName="PostavkaRowChanging" msprop:Generator_TableClassName="PostavkaDataTable" msprop:Generator_RowClassName="PostavkaRow" msprop:Generator_TableVarName="tablePostavka" msprop:Generator_UserTableName="Postavka">
    940. 

  940.           <xs:complexType>
    941. 

  941.             <xs:sequence>
    942. 

  942.               <xs:element name="Дата" msprop:Generator_ColumnPropNameInRow="Дата" msprop:Generator_ColumnPropNameInTable="ДатаColumn" msprop:Generator_ColumnVarNameInTable="columnДата" msprop:Generator_UserColumnName="Дата" type="xs:dateTime" minOccurs="0" />
    943. 

  943.               <xs:element name="Наименование_x0020_поставщика" msprop:Generator_ColumnPropNameInRow="Наименование_поставщика" msprop:Generator_ColumnPropNameInTable="Наименование_поставщикаColumn" msprop:Generator_ColumnVarNameInTable="columnНаименование_поставщика" msprop:Generator_UserColumnName="Наименование поставщика" minOccurs="0">
    944. 

  944.                 <xs:simpleType>
    945. 

  945.                   <xs:restriction base="xs:string">
    946. 

  946.                     <xs:maxLength value="50" />
    947. 

  947.                   </xs:restriction>
    948. 

  948.                 </xs:simpleType>
    949. 

  949.               </xs:element>
    950. 

  950.               <xs:element name="Название_x0020_материала" msprop:Generator_ColumnPropNameInRow="Название_материала" msprop:Generator_ColumnPropNameInTable="Название_материалаColumn" msprop:Generator_ColumnVarNameInTable="columnНазвание_материала" msprop:Generator_UserColumnName="Название материала" minOccurs="0">
    951. 

  951.                 <xs:simpleType>
    952. 

  952.                   <xs:restriction base="xs:string">
    953. 

  953.                     <xs:maxLength value="2147483647" />
    954. 

  954.                   </xs:restriction>
    955. 

  955.                 </xs:simpleType>
    956. 

  956.               </xs:element>
    957. 

  957.               <xs:element name="Тип_материала" msprop:Generator_ColumnPropNameInRow="Тип_материала" msprop:Generator_ColumnPropNameInTable="Тип_материалаColumn" msprop:Generator_ColumnVarNameInTable="columnТип_материала" msprop:Generator_UserColumnName="Тип_материала" minOccurs="0">
    958. 

  958.                 <xs:simpleType>
    959. 

  959.                   <xs:restriction base="xs:string">
    960. 

  960.                     <xs:maxLength value="50" />
    961. 

  961.                   </xs:restriction>
    962. 

  962.                 </xs:simpleType>
    963. 

  963.               </xs:element>
    964. 

  964.               <xs:element name="количество" msprop:Generator_ColumnPropNameInRow="количество" msprop:Generator_ColumnPropNameInTable="количествоColumn" msprop:Generator_ColumnVarNameInTable="columnколичество" msprop:Generator_UserColumnName="количество" type="xs:int" minOccurs="0" />
    965. 

  965.               <xs:element name="Единица_x0020_измерения" msprop:Generator_ColumnPropNameInRow="Единица_измерения" msprop:Generator_ColumnPropNameInTable="Единица_измеренияColumn" msprop:Generator_ColumnVarNameInTable="columnЕдиница_измерения" msprop:Generator_UserColumnName="Единица измерения" minOccurs="0">
    966. 

  966.                 <xs:simpleType>
    967. 

  967.                   <xs:restriction base="xs:string">
    968. 

  968.                     <xs:maxLength value="50" />
    969. 

  969.                   </xs:restriction>
    970. 

  970.                 </xs:simpleType>
    971. 

  971.               </xs:element>
    972. 

  972.             </xs:sequence>
    973. 

  973.           </xs:complexType>
    974. 

  974.         </xs:element>
    975. 

  975.         <xs:element name="Zakaz" msprop:Generator_RowEvHandlerName="ZakazRowChangeEventHandler" msprop:Generator_RowDeletedName="ZakazRowDeleted" msprop:Generator_RowDeletingName="ZakazRowDeleting" msprop:Generator_RowEvArgName="ZakazRowChangeEvent" msprop:Generator_TablePropName="Zakaz" msprop:Generator_RowChangedName="ZakazRowChanged" msprop:Generator_RowChangingName="ZakazRowChanging" msprop:Generator_TableClassName="ZakazDataTable" msprop:Generator_RowClassName="ZakazRow" msprop:Generator_TableVarName="tableZakaz" msprop:Generator_UserTableName="Zakaz">
    976. 

  976.           <xs:complexType>
    977. 

  977.             <xs:sequence>
    978. 

  978.               <xs:element name="Номер_x0020_заказа" msprop:Generator_ColumnPropNameInRow="Номер_заказа" msprop:Generator_ColumnPropNameInTable="Номер_заказаColumn" msprop:Generator_ColumnVarNameInTable="columnНомер_заказа" msprop:Generator_UserColumnName="Номер заказа" type="xs:int" minOccurs="0" />
    979. 

  979.               <xs:element name="Название_x0020_статуса" msprop:Generator_ColumnPropNameInRow="Название_статуса" msprop:Generator_ColumnPropNameInTable="Название_статусаColumn" msprop:Generator_ColumnVarNameInTable="columnНазвание_статуса" msprop:Generator_UserColumnName="Название статуса" minOccurs="0">
    980. 

  980.                 <xs:simpleType>
    981. 

  981.                   <xs:restriction base="xs:string">
    982. 

  982.                     <xs:maxLength value="50" />
    983. 

  983.                   </xs:restriction>
    984. 

  984.                 </xs:simpleType>
    985. 

  985.               </xs:element>
    986. 

  986.               <xs:element name="Видеокарта" msprop:Generator_ColumnPropNameInRow="Видеокарта" msprop:Generator_ColumnPropNameInTable="ВидеокартаColumn" msprop:Generator_ColumnVarNameInTable="columnВидеокарта" msprop:Generator_UserColumnName="Видеокарта" minOccurs="0">
    987. 

  987.                 <xs:simpleType>
    988. 

  988.                   <xs:restriction base="xs:string">
    989. 

  989.                     <xs:maxLength value="150" />
    990. 

  990.                   </xs:restriction>
    991. 

  991.                 </xs:simpleType>
    992. 

  992.               </xs:element>
    993. 

  993.               <xs:element name="Материнская_x0020_плата" msprop:Generator_ColumnPropNameInRow="Материнская_плата" msprop:Generator_ColumnPropNameInTable="Материнская_платаColumn" msprop:Generator_ColumnVarNameInTable="columnМатеринская_плата" msprop:Generator_UserColumnName="Материнская плата" minOccurs="0">
    994. 

  994.                 <xs:simpleType>
    995. 

  995.                   <xs:restriction base="xs:string">
    996. 

  996.                     <xs:maxLength value="150" />
    997. 

  997.                   </xs:restriction>
    998. 

  998.                 </xs:simpleType>
    999. 

  999.               </xs:element>
    1000. 

  1000.               <xs:element name="Процессор" msprop:Generator_ColumnPropNameInRow="Процессор" msprop:Generator_ColumnPropNameInTable="ПроцессорColumn" msprop:Generator_ColumnVarNameInTable="columnПроцессор" msprop:Generator_UserColumnName="Процессор" minOccurs="0">
    1001. 

  1001.                 <xs:simpleType>
    1002. 

  1002.                   <xs:restriction base="xs:string">
    1003. 

  1003.                     <xs:maxLength value="150" />
    1004. 

  1004.                   </xs:restriction>
    1005. 

  1005.                 </xs:simpleType>
    1006. 

  1006.               </xs:element>
    1007. 

  1007.               <xs:element name="Оперативная_x0020_память" msprop:Generator_ColumnPropNameInRow="Оперативная_память" msprop:Generator_ColumnPropNameInTable="Оперативная_памятьColumn" msprop:Generator_ColumnVarNameInTable="columnОперативная_память" msprop:Generator_UserColumnName="Оперативная память" minOccurs="0">
    1008. 

  1008.                 <xs:simpleType>
    1009. 

  1009.                   <xs:restriction base="xs:string">
    1010. 

  1010.                     <xs:maxLength value="150" />
    1011. 

  1011.                   </xs:restriction>
    1012. 

  1012.                 </xs:simpleType>
    1013. 

  1013.               </xs:element>
    1014. 

  1014.               <xs:element name="Оперативная_память" msprop:Generator_ColumnPropNameInRow="_Оперативная_память" msprop:Generator_ColumnPropNameInTable="_Оперативная_памятьColumn" msprop:Generator_ColumnVarNameInTable="_columnОперативная_память" msprop:Generator_UserColumnName="Оперативная_память" minOccurs="0">
    1015. 

  1015.                 <xs:simpleType>
    1016. 

  1016.                   <xs:restriction base="xs:string">
    1017. 

  1017.                     <xs:maxLength value="150" />
    1018. 

  1018.                   </xs:restriction>
    1019. 

  1019.                 </xs:simpleType>
    1020. 

  1020.               </xs:element>
    1021. 

  1021.               <xs:element name="Жетский_x0020_диск" msprop:Generator_ColumnPropNameInRow="Жетский_диск" msprop:Generator_ColumnPropNameInTable="Жетский_дискColumn" msprop:Generator_ColumnVarNameInTable="columnЖетский_диск" msprop:Generator_UserColumnName="Жетский диск" minOccurs="0">
    1022. 

  1022.                 <xs:simpleType>
    1023. 

  1023.                   <xs:restriction base="xs:string">
    1024. 

  1024.                     <xs:maxLength value="150" />
    1025. 

  1025.                   </xs:restriction>
    1026. 

  1026.                 </xs:simpleType>
    1027. 

  1027.               </xs:element>
    1028. 

  1028.               <xs:element name="Куллер" msprop:Generator_ColumnPropNameInRow="Куллер" msprop:Generator_ColumnPropNameInTable="КуллерColumn" msprop:Generator_ColumnVarNameInTable="columnКуллер" msprop:Generator_UserColumnName="Куллер" minOccurs="0">
    1029. 

  1029.                 <xs:simpleType>
    1030. 

  1030.                   <xs:restriction base="xs:string">
    1031. 

  1031.                     <xs:maxLength value="150" />
    1032. 

  1032.                   </xs:restriction>
    1033. 

  1033.                 </xs:simpleType>
    1034. 

  1034.               </xs:element>
    1035. 

  1035.               <xs:element name="Система_x0020_охлаждения" msprop:Generator_ColumnPropNameInRow="Система_охлаждения" msprop:Generator_ColumnPropNameInTable="Система_охлажденияColumn" msprop:Generator_ColumnVarNameInTable="columnСистема_охлаждения" msprop:Generator_UserColumnName="Система охлаждения" minOccurs="0">
    1036. 

  1036.                 <xs:simpleType>
    1037. 

  1037.                   <xs:restriction base="xs:string">
    1038. 

  1038.                     <xs:maxLength value="150" />
    1039. 

  1039.                   </xs:restriction>
    1040. 

  1040.                 </xs:simpleType>
    1041. 

  1041.               </xs:element>
    1042. 

  1042.               <xs:element name="Блок_x0020_питания" msprop:Generator_ColumnPropNameInRow="Блок_питания" msprop:Generator_ColumnPropNameInTable="Блок_питанияColumn" msprop:Generator_ColumnVarNameInTable="columnБлок_питания" msprop:Generator_UserColumnName="Блок питания" minOccurs="0">
    1043. 

  1043.                 <xs:simpleType>
    1044. 

  1044.                   <xs:restriction base="xs:string">
    1045. 

  1045.                     <xs:maxLength value="150" />
    1046. 

  1046.                   </xs:restriction>
    1047. 

  1047.                 </xs:simpleType>
    1048. 

  1048.               </xs:element>
    1049. 

  1049.               <xs:element name="SSD" msprop:Generator_ColumnPropNameInRow="SSD" msprop:Generator_ColumnPropNameInTable="SSDColumn" msprop:Generator_ColumnVarNameInTable="columnSSD" msprop:Generator_UserColumnName="SSD" minOccurs="0">
    1050. 

  1050.                 <xs:simpleType>
    1051. 

  1051.                   <xs:restriction base="xs:string">
    1052. 

  1052.                     <xs:maxLength value="150" />
    1053. 

  1053.                   </xs:restriction>
    1054. 

  1054.                 </xs:simpleType>
    1055. 

  1055.               </xs:element>
    1056. 

  1056.             </xs:sequence>
    1057. 

  1057.           </xs:complexType>
    1058. 

  1058.         </xs:element>
    1059. 

  1059.       </xs:choice>
    1060. 

  1060.     </xs:complexType>
    1061. 

  1061.     <xs:unique name="Constraint1" msdata:PrimaryKey="true">
    1062. 

  1062.       <xs:selector xpath=".//mstns:Components" />
    1063. 

  1063.       <xs:field xpath="mstns:id" />
    1064. 

  1064.     </xs:unique>
    1065. 

  1065.     <xs:unique name="computer_assembly_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    1066. 

  1066.       <xs:selector xpath=".//mstns:computer_assembly" />
    1067. 

  1067.       <xs:field xpath="mstns:id_x0020_сборки" />
    1068. 

  1068.     </xs:unique>
    1069. 

  1069.     <xs:unique name="Order_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    1070. 

  1070.       <xs:selector xpath=".//mstns:Order" />
    1071. 

  1071.       <xs:field xpath="mstns:Id_заказа" />
    1072. 

  1072.     </xs:unique>
    1073. 

  1073.     <xs:unique name="order_by_clients_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    1074. 

  1074.       <xs:selector xpath=".//mstns:order_by_clients" />
    1075. 

  1075.       <xs:field xpath="mstns:Номер_x0020_заказа" />
    1076. 

  1076.     </xs:unique>
    1077. 

  1077.     <xs:unique name="Order_status_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    1078. 

  1078.       <xs:selector xpath=".//mstns:Order_status" />
    1079. 

  1079.       <xs:field xpath="mstns:id" />
    1080. 

  1080.     </xs:unique>
    1081. 

  1081.     <xs:unique name="provider_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    1082. 

  1082.       <xs:selector xpath=".//mstns:provider" />
    1083. 

  1083.       <xs:field xpath="mstns:id" />
    1084. 

  1084.     </xs:unique>
    1085. 

  1085.     <xs:unique name="receipt_of_goods_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    1086. 

  1086.       <xs:selector xpath=".//mstns:receipt_of_goods" />
    1087. 

  1087.       <xs:field xpath="mstns:id" />
    1088. 

  1088.     </xs:unique>
    1089. 

  1089.     <xs:unique name="Role_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    1090. 

  1090.       <xs:selector xpath=".//mstns:Role" />
    1091. 

  1091.       <xs:field xpath="mstns:Id" />
    1092. 

  1092.     </xs:unique>
    1093. 

  1093.     <xs:unique name="unit_of_measurement_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    1094. 

  1094.       <xs:selector xpath=".//mstns:unit_of_measurement" />
    1095. 

  1095.       <xs:field xpath="mstns:id" />
    1096. 

  1096.     </xs:unique>
    1097. 

  1097.     <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    1098. 

  1098.       <xs:selector xpath=".//mstns:Users" />
    1099. 

  1099.       <xs:field xpath="mstns:Id" />
    1100. 

  1100.     </xs:unique>
    1101. 

  1101.   </xs:element>
    1102. 

  1102.   <xs:annotation>
    1103. 

  1103.     <xs:appinfo>
    1104. 

  1104.       <msdata:Relationship name="FK_Components_unit_of_measurement" msdata:parent="unit_of_measurement" msdata:child="Components" msdata:parentkey="id" msdata:childkey="Id_x0020_единицы_x0020_измерения" msprop:Generator_UserParentTable="unit_of_measurement" msprop:Generator_UserChildTable="Components" msprop:Generator_RelationVarName="relationFK_Components_unit_of_measurement" msprop:Generator_UserRelationName="FK_Components_unit_of_measurement" msprop:Generator_ChildPropName="GetComponentsRows" msprop:Generator_ParentPropName="unit_of_measurementRow" />
    1105. 

  1105.       <msdata:Relationship name="FK_Order_computer_assembly" msdata:parent="computer_assembly" msdata:child="Order" msdata:parentkey="id_x0020_сборки" msdata:childkey="id_x0020_сборки" msprop:Generator_UserParentTable="computer_assembly" msprop:Generator_UserChildTable="Order" msprop:Generator_RelationVarName="relationFK_Order_computer_assembly" msprop:Generator_ChildPropName="GetOrderRows" msprop:Generator_ParentPropName="computer_assemblyRow" msprop:Generator_UserRelationName="FK_Order_computer_assembly" />
    1106. 

  1106.       <msdata:Relationship name="FK_Order_order_by_clients" msdata:parent="order_by_clients" msdata:child="Order" msdata:parentkey="Номер_x0020_заказа" msdata:childkey="Номер_x0020_заказа" msprop:Generator_UserParentTable="order_by_clients" msprop:Generator_UserChildTable="Order" msprop:Generator_RelationVarName="relationFK_Order_order_by_clients" msprop:Generator_UserRelationName="FK_Order_order_by_clients" msprop:Generator_ChildPropName="GetOrderRows" msprop:Generator_ParentPropName="order_by_clientsRow" />
    1107. 

  1107.       <msdata:Relationship name="FK_Order_Order_status" msdata:parent="Order_status" msdata:child="Order" msdata:parentkey="id" msdata:childkey="id_x0020_статуса" msprop:Generator_UserParentTable="Order_status" msprop:Generator_UserChildTable="Order" msprop:Generator_RelationVarName="relationFK_Order_Order_status" msprop:Generator_UserRelationName="FK_Order_Order_status" msprop:Generator_ChildPropName="GetOrderRows" msprop:Generator_ParentPropName="Order_statusRow" />
    1108. 

  1108.       <msdata:Relationship name="FK_receipt_of_goods_Components" msdata:parent="Components" msdata:child="receipt_of_goods" msdata:parentkey="id" msdata:childkey="Id_x0020_компонентов" msprop:Generator_UserParentTable="Components" msprop:Generator_UserChildTable="receipt_of_goods" msprop:Generator_RelationVarName="relationFK_receipt_of_goods_Components" msprop:Generator_ChildPropName="Getreceipt_of_goodsRows" msprop:Generator_ParentPropName="ComponentsRow" msprop:Generator_UserRelationName="FK_receipt_of_goods_Components" />
    1109. 

  1109.       <msdata:Relationship name="FK_receipt_of_goods_provider" msdata:parent="provider" msdata:child="receipt_of_goods" msdata:parentkey="id" msdata:childkey="id_x0020_поставщика" msprop:Generator_UserParentTable="provider" msprop:Generator_UserChildTable="receipt_of_goods" msprop:Generator_RelationVarName="relationFK_receipt_of_goods_provider" msprop:Generator_ChildPropName="Getreceipt_of_goodsRows" msprop:Generator_ParentPropName="providerRow" msprop:Generator_UserRelationName="FK_receipt_of_goods_provider" />
    1110. 

  1110.       <msdata:Relationship name="FK_Users_Role" msdata:parent="Role" msdata:child="Users" msdata:parentkey="Id" msdata:childkey="Role" msprop:Generator_UserParentTable="Role" msprop:Generator_UserChildTable="Users" msprop:Generator_RelationVarName="relationFK_Users_Role" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_ParentPropName="RoleRow" msprop:Generator_UserRelationName="FK_Users_Role" />
    1111. 

  1111.     </xs:appinfo>
    1112. 

  1112.   </xs:annotation>
    1113. 

  1113. </xs:schema>
    1114.