Savelev_Shevchenko_pr2DataSet1.xsd 191 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <xs:schema id="Savelev_Shevchenko_pr2DataSet1" targetNamespace="http://tempuri.org/Savelev_Shevchenko_pr2DataSet1.xsd" xmlns:mstns="http://tempuri.org/Savelev_Shevchenko_pr2DataSet1.xsd" xmlns="http://tempuri.org/Savelev_Shevchenko_pr2DataSet1.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. <xs:annotation>
  4. <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
  5. <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6. <Connections>
  7. <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Savelev_Shevchenko_pr2ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Savelev_Shevchenko_pr2ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SavelevShevchenkoStudents.Properties.Settings.GlobalReference.Default.Savelev_Shevchenko_pr2ConnectionString" Provider="System.Data.SqlClient" />
  8. </Connections>
  9. <Tables>
  10. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OcenkaTableAdapter" GeneratorDataComponentClassName="OcenkaTableAdapter" Name="Ocenka" UserDataComponentName="OcenkaTableAdapter">
  11. <MainSource>
  12. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.Ocenka" 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. <DeleteCommand>
  14. <DbCommand CommandType="Text" ModifiedByUser="false">
  15. <CommandText>DELETE FROM [dbo].[Ocenka] WHERE (([ID_studenta] = @Original_ID_studenta) AND ((@IsNull_Data_ikzamena1 = 1 AND [Data_ikzamena1] IS NULL) OR ([Data_ikzamena1] = @Original_Data_ikzamena1)) AND ((@IsNull_ID_predmeta1 = 1 AND [ID_predmeta1] IS NULL) OR ([ID_predmeta1] = @Original_ID_predmeta1)) AND ((@IsNull_Ocenka1 = 1 AND [Ocenka1] IS NULL) OR ([Ocenka1] = @Original_Ocenka1)) AND ((@IsNull_Data_ikzamena2 = 1 AND [Data_ikzamena2] IS NULL) OR ([Data_ikzamena2] = @Original_Data_ikzamena2)) AND ((@IsNull_ID_predmeta2 = 1 AND [ID_predmeta2] IS NULL) OR ([ID_predmeta2] = @Original_ID_predmeta2)) AND ((@IsNull_Ocenka2 = 1 AND [Ocenka2] IS NULL) OR ([Ocenka2] = @Original_Ocenka2)) AND ((@IsNull_Data_ikzamena3 = 1 AND [Data_ikzamena3] IS NULL) OR ([Data_ikzamena3] = @Original_Data_ikzamena3)) AND ((@IsNull_ID_predmeta3 = 1 AND [ID_predmeta3] IS NULL) OR ([ID_predmeta3] = @Original_ID_predmeta3)) AND ((@IsNull_Ocenka3 = 1 AND [Ocenka3] IS NULL) OR ([Ocenka3] = @Original_Ocenka3)) AND ((@IsNull_Srednii_ball = 1 AND [Srednii_ball] IS NULL) OR ([Srednii_ball] = @Original_Srednii_ball)))</CommandText>
  16. <Parameters>
  17. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_studenta" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_studenta" SourceColumnNullMapping="false" SourceVersion="Original" />
  18. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_ikzamena1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_ikzamena1" SourceColumnNullMapping="true" SourceVersion="Original" />
  19. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_ikzamena1" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena1" SourceColumnNullMapping="false" SourceVersion="Original" />
  20. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_predmeta1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_predmeta1" SourceColumnNullMapping="true" SourceVersion="Original" />
  21. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_predmeta1" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta1" SourceColumnNullMapping="false" SourceVersion="Original" />
  22. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ocenka1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ocenka1" SourceColumnNullMapping="true" SourceVersion="Original" />
  23. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Ocenka1" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka1" SourceColumnNullMapping="false" SourceVersion="Original" />
  24. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_ikzamena2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_ikzamena2" SourceColumnNullMapping="true" SourceVersion="Original" />
  25. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_ikzamena2" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena2" SourceColumnNullMapping="false" SourceVersion="Original" />
  26. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_predmeta2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_predmeta2" SourceColumnNullMapping="true" SourceVersion="Original" />
  27. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_predmeta2" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta2" SourceColumnNullMapping="false" SourceVersion="Original" />
  28. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ocenka2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ocenka2" SourceColumnNullMapping="true" SourceVersion="Original" />
  29. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Ocenka2" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka2" SourceColumnNullMapping="false" SourceVersion="Original" />
  30. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_ikzamena3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_ikzamena3" SourceColumnNullMapping="true" SourceVersion="Original" />
  31. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_ikzamena3" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena3" SourceColumnNullMapping="false" SourceVersion="Original" />
  32. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_predmeta3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_predmeta3" SourceColumnNullMapping="true" SourceVersion="Original" />
  33. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_predmeta3" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta3" SourceColumnNullMapping="false" SourceVersion="Original" />
  34. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ocenka3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ocenka3" SourceColumnNullMapping="true" SourceVersion="Original" />
  35. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Ocenka3" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka3" SourceColumnNullMapping="false" SourceVersion="Original" />
  36. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Srednii_ball" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Srednii_ball" SourceColumnNullMapping="true" SourceVersion="Original" />
  37. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_Srednii_ball" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="Srednii_ball" SourceColumnNullMapping="false" SourceVersion="Original" />
  38. </Parameters>
  39. </DbCommand>
  40. </DeleteCommand>
  41. <InsertCommand>
  42. <DbCommand CommandType="Text" ModifiedByUser="false">
  43. <CommandText>INSERT INTO [dbo].[Ocenka] ([Data_ikzamena1], [ID_predmeta1], [Ocenka1], [Data_ikzamena2], [ID_predmeta2], [Ocenka2], [Data_ikzamena3], [ID_predmeta3], [Ocenka3], [Srednii_ball]) VALUES (@Data_ikzamena1, @ID_predmeta1, @Ocenka1, @Data_ikzamena2, @ID_predmeta2, @Ocenka2, @Data_ikzamena3, @ID_predmeta3, @Ocenka3, @Srednii_ball);
  44. SELECT ID_studenta, Data_ikzamena1, ID_predmeta1, Ocenka1, Data_ikzamena2, ID_predmeta2, Ocenka2, Data_ikzamena3, ID_predmeta3, Ocenka3, Srednii_ball FROM Ocenka WHERE (ID_studenta = SCOPE_IDENTITY())</CommandText>
  45. <Parameters>
  46. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_ikzamena1" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena1" SourceColumnNullMapping="false" SourceVersion="Current" />
  47. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_predmeta1" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta1" SourceColumnNullMapping="false" SourceVersion="Current" />
  48. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Ocenka1" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka1" SourceColumnNullMapping="false" SourceVersion="Current" />
  49. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_ikzamena2" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena2" SourceColumnNullMapping="false" SourceVersion="Current" />
  50. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_predmeta2" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta2" SourceColumnNullMapping="false" SourceVersion="Current" />
  51. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Ocenka2" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka2" SourceColumnNullMapping="false" SourceVersion="Current" />
  52. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_ikzamena3" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena3" SourceColumnNullMapping="false" SourceVersion="Current" />
  53. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_predmeta3" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta3" SourceColumnNullMapping="false" SourceVersion="Current" />
  54. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Ocenka3" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka3" SourceColumnNullMapping="false" SourceVersion="Current" />
  55. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Srednii_ball" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="Srednii_ball" SourceColumnNullMapping="false" SourceVersion="Current" />
  56. </Parameters>
  57. </DbCommand>
  58. </InsertCommand>
  59. <SelectCommand>
  60. <DbCommand CommandType="Text" ModifiedByUser="false">
  61. <CommandText>SELECT ID_studenta, Data_ikzamena1, ID_predmeta1, Ocenka1, Data_ikzamena2, ID_predmeta2, Ocenka2, Data_ikzamena3, ID_predmeta3, Ocenka3, Srednii_ball FROM dbo.Ocenka</CommandText>
  62. <Parameters />
  63. </DbCommand>
  64. </SelectCommand>
  65. <UpdateCommand>
  66. <DbCommand CommandType="Text" ModifiedByUser="false">
  67. <CommandText>UPDATE [dbo].[Ocenka] SET [Data_ikzamena1] = @Data_ikzamena1, [ID_predmeta1] = @ID_predmeta1, [Ocenka1] = @Ocenka1, [Data_ikzamena2] = @Data_ikzamena2, [ID_predmeta2] = @ID_predmeta2, [Ocenka2] = @Ocenka2, [Data_ikzamena3] = @Data_ikzamena3, [ID_predmeta3] = @ID_predmeta3, [Ocenka3] = @Ocenka3, [Srednii_ball] = @Srednii_ball WHERE (([ID_studenta] = @Original_ID_studenta) AND ((@IsNull_Data_ikzamena1 = 1 AND [Data_ikzamena1] IS NULL) OR ([Data_ikzamena1] = @Original_Data_ikzamena1)) AND ((@IsNull_ID_predmeta1 = 1 AND [ID_predmeta1] IS NULL) OR ([ID_predmeta1] = @Original_ID_predmeta1)) AND ((@IsNull_Ocenka1 = 1 AND [Ocenka1] IS NULL) OR ([Ocenka1] = @Original_Ocenka1)) AND ((@IsNull_Data_ikzamena2 = 1 AND [Data_ikzamena2] IS NULL) OR ([Data_ikzamena2] = @Original_Data_ikzamena2)) AND ((@IsNull_ID_predmeta2 = 1 AND [ID_predmeta2] IS NULL) OR ([ID_predmeta2] = @Original_ID_predmeta2)) AND ((@IsNull_Ocenka2 = 1 AND [Ocenka2] IS NULL) OR ([Ocenka2] = @Original_Ocenka2)) AND ((@IsNull_Data_ikzamena3 = 1 AND [Data_ikzamena3] IS NULL) OR ([Data_ikzamena3] = @Original_Data_ikzamena3)) AND ((@IsNull_ID_predmeta3 = 1 AND [ID_predmeta3] IS NULL) OR ([ID_predmeta3] = @Original_ID_predmeta3)) AND ((@IsNull_Ocenka3 = 1 AND [Ocenka3] IS NULL) OR ([Ocenka3] = @Original_Ocenka3)) AND ((@IsNull_Srednii_ball = 1 AND [Srednii_ball] IS NULL) OR ([Srednii_ball] = @Original_Srednii_ball)));
  68. SELECT ID_studenta, Data_ikzamena1, ID_predmeta1, Ocenka1, Data_ikzamena2, ID_predmeta2, Ocenka2, Data_ikzamena3, ID_predmeta3, Ocenka3, Srednii_ball FROM Ocenka WHERE (ID_studenta = @ID_studenta)</CommandText>
  69. <Parameters>
  70. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_ikzamena1" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena1" SourceColumnNullMapping="false" SourceVersion="Current" />
  71. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_predmeta1" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta1" SourceColumnNullMapping="false" SourceVersion="Current" />
  72. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Ocenka1" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka1" SourceColumnNullMapping="false" SourceVersion="Current" />
  73. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_ikzamena2" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena2" SourceColumnNullMapping="false" SourceVersion="Current" />
  74. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_predmeta2" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta2" SourceColumnNullMapping="false" SourceVersion="Current" />
  75. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Ocenka2" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka2" SourceColumnNullMapping="false" SourceVersion="Current" />
  76. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_ikzamena3" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena3" SourceColumnNullMapping="false" SourceVersion="Current" />
  77. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_predmeta3" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta3" SourceColumnNullMapping="false" SourceVersion="Current" />
  78. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Ocenka3" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka3" SourceColumnNullMapping="false" SourceVersion="Current" />
  79. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Srednii_ball" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="Srednii_ball" SourceColumnNullMapping="false" SourceVersion="Current" />
  80. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_studenta" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_studenta" SourceColumnNullMapping="false" SourceVersion="Original" />
  81. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_ikzamena1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_ikzamena1" SourceColumnNullMapping="true" SourceVersion="Original" />
  82. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_ikzamena1" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena1" SourceColumnNullMapping="false" SourceVersion="Original" />
  83. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_predmeta1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_predmeta1" SourceColumnNullMapping="true" SourceVersion="Original" />
  84. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_predmeta1" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta1" SourceColumnNullMapping="false" SourceVersion="Original" />
  85. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ocenka1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ocenka1" SourceColumnNullMapping="true" SourceVersion="Original" />
  86. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Ocenka1" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka1" SourceColumnNullMapping="false" SourceVersion="Original" />
  87. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_ikzamena2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_ikzamena2" SourceColumnNullMapping="true" SourceVersion="Original" />
  88. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_ikzamena2" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena2" SourceColumnNullMapping="false" SourceVersion="Original" />
  89. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_predmeta2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_predmeta2" SourceColumnNullMapping="true" SourceVersion="Original" />
  90. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_predmeta2" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta2" SourceColumnNullMapping="false" SourceVersion="Original" />
  91. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ocenka2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ocenka2" SourceColumnNullMapping="true" SourceVersion="Original" />
  92. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Ocenka2" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka2" SourceColumnNullMapping="false" SourceVersion="Original" />
  93. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_ikzamena3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_ikzamena3" SourceColumnNullMapping="true" SourceVersion="Original" />
  94. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_ikzamena3" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_ikzamena3" SourceColumnNullMapping="false" SourceVersion="Original" />
  95. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_predmeta3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_predmeta3" SourceColumnNullMapping="true" SourceVersion="Original" />
  96. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_predmeta3" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_predmeta3" SourceColumnNullMapping="false" SourceVersion="Original" />
  97. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ocenka3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ocenka3" SourceColumnNullMapping="true" SourceVersion="Original" />
  98. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Ocenka3" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Ocenka3" SourceColumnNullMapping="false" SourceVersion="Original" />
  99. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Srednii_ball" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Srednii_ball" SourceColumnNullMapping="true" SourceVersion="Original" />
  100. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_Srednii_ball" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="Srednii_ball" SourceColumnNullMapping="false" SourceVersion="Original" />
  101. <Parameter AllowDbNull="false" AutogeneratedName="ID_studenta" ColumnName="ID_studenta" DataSourceName="Savelev_Shevchenko_pr2.dbo.Ocenka" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@ID_studenta" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="ID_studenta" SourceColumnNullMapping="false" SourceVersion="Current" />
  102. </Parameters>
  103. </DbCommand>
  104. </UpdateCommand>
  105. </DbSource>
  106. </MainSource>
  107. <Mappings>
  108. <Mapping SourceColumn="ID_studenta" DataSetColumn="ID_studenta" />
  109. <Mapping SourceColumn="Data_ikzamena1" DataSetColumn="Data_ikzamena1" />
  110. <Mapping SourceColumn="ID_predmeta1" DataSetColumn="ID_predmeta1" />
  111. <Mapping SourceColumn="Ocenka1" DataSetColumn="Ocenka1" />
  112. <Mapping SourceColumn="Data_ikzamena2" DataSetColumn="Data_ikzamena2" />
  113. <Mapping SourceColumn="ID_predmeta2" DataSetColumn="ID_predmeta2" />
  114. <Mapping SourceColumn="Ocenka2" DataSetColumn="Ocenka2" />
  115. <Mapping SourceColumn="Data_ikzamena3" DataSetColumn="Data_ikzamena3" />
  116. <Mapping SourceColumn="ID_predmeta3" DataSetColumn="ID_predmeta3" />
  117. <Mapping SourceColumn="Ocenka3" DataSetColumn="Ocenka3" />
  118. <Mapping SourceColumn="Srednii_ball" DataSetColumn="Srednii_ball" />
  119. </Mappings>
  120. <Sources />
  121. </TableAdapter>
  122. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PredmetTableAdapter" GeneratorDataComponentClassName="PredmetTableAdapter" Name="Predmet" UserDataComponentName="PredmetTableAdapter">
  123. <MainSource>
  124. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.Predmet" 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">
  125. <DeleteCommand>
  126. <DbCommand CommandType="Text" ModifiedByUser="false">
  127. <CommandText>DELETE FROM [dbo].[Predmet] WHERE (([ID_predmeta] = @Original_ID_predmeta) AND ((@IsNull_Nazvanie_predmeta = 1 AND [Nazvanie_predmeta] IS NULL) OR ([Nazvanie_predmeta] = @Original_Nazvanie_predmeta)))</CommandText>
  128. <Parameters>
  129. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_predmeta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_predmeta" SourceColumnNullMapping="false" SourceVersion="Original" />
  130. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nazvanie_predmeta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nazvanie_predmeta" SourceColumnNullMapping="true" SourceVersion="Original" />
  131. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazvanie_predmeta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie_predmeta" SourceColumnNullMapping="false" SourceVersion="Original" />
  132. </Parameters>
  133. </DbCommand>
  134. </DeleteCommand>
  135. <InsertCommand>
  136. <DbCommand CommandType="Text" ModifiedByUser="false">
  137. <CommandText>INSERT INTO [dbo].[Predmet] ([Nazvanie_predmeta], [Opisanie_predmeta]) VALUES (@Nazvanie_predmeta, @Opisanie_predmeta);
  138. SELECT ID_predmeta, Nazvanie_predmeta, Opisanie_predmeta FROM Predmet WHERE (ID_predmeta = SCOPE_IDENTITY())</CommandText>
  139. <Parameters>
  140. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie_predmeta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie_predmeta" SourceColumnNullMapping="false" SourceVersion="Current" />
  141. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Opisanie_predmeta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Opisanie_predmeta" SourceColumnNullMapping="false" SourceVersion="Current" />
  142. </Parameters>
  143. </DbCommand>
  144. </InsertCommand>
  145. <SelectCommand>
  146. <DbCommand CommandType="Text" ModifiedByUser="false">
  147. <CommandText>SELECT ID_predmeta, Nazvanie_predmeta, Opisanie_predmeta FROM dbo.Predmet</CommandText>
  148. <Parameters />
  149. </DbCommand>
  150. </SelectCommand>
  151. <UpdateCommand>
  152. <DbCommand CommandType="Text" ModifiedByUser="false">
  153. <CommandText>UPDATE [dbo].[Predmet] SET [Nazvanie_predmeta] = @Nazvanie_predmeta, [Opisanie_predmeta] = @Opisanie_predmeta WHERE (([ID_predmeta] = @Original_ID_predmeta) AND ((@IsNull_Nazvanie_predmeta = 1 AND [Nazvanie_predmeta] IS NULL) OR ([Nazvanie_predmeta] = @Original_Nazvanie_predmeta)));
  154. SELECT ID_predmeta, Nazvanie_predmeta, Opisanie_predmeta FROM Predmet WHERE (ID_predmeta = @ID_predmeta)</CommandText>
  155. <Parameters>
  156. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie_predmeta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie_predmeta" SourceColumnNullMapping="false" SourceVersion="Current" />
  157. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Opisanie_predmeta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Opisanie_predmeta" SourceColumnNullMapping="false" SourceVersion="Current" />
  158. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_predmeta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_predmeta" SourceColumnNullMapping="false" SourceVersion="Original" />
  159. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nazvanie_predmeta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nazvanie_predmeta" SourceColumnNullMapping="true" SourceVersion="Original" />
  160. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazvanie_predmeta" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie_predmeta" SourceColumnNullMapping="false" SourceVersion="Original" />
  161. <Parameter AllowDbNull="false" AutogeneratedName="ID_predmeta" ColumnName="ID_predmeta" DataSourceName="Savelev_Shevchenko_pr2.dbo.Predmet" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_predmeta" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_predmeta" SourceColumnNullMapping="false" SourceVersion="Current" />
  162. </Parameters>
  163. </DbCommand>
  164. </UpdateCommand>
  165. </DbSource>
  166. </MainSource>
  167. <Mappings>
  168. <Mapping SourceColumn="ID_predmeta" DataSetColumn="ID_predmeta" />
  169. <Mapping SourceColumn="Nazvanie_predmeta" DataSetColumn="Nazvanie_predmeta" />
  170. <Mapping SourceColumn="Opisanie_predmeta" DataSetColumn="Opisanie_predmeta" />
  171. </Mappings>
  172. <Sources />
  173. </TableAdapter>
  174. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SpecialnostTableAdapter" GeneratorDataComponentClassName="SpecialnostTableAdapter" Name="Specialnost" UserDataComponentName="SpecialnostTableAdapter">
  175. <MainSource>
  176. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.Specialnost" 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">
  177. <DeleteCommand>
  178. <DbCommand CommandType="Text" ModifiedByUser="false">
  179. <CommandText>DELETE FROM [dbo].[Specialnost] WHERE (([ID_specialnosti] = @Original_ID_specialnosti) AND ((@IsNull_Nazvanie_specialnosti = 1 AND [Nazvanie_specialnosti] IS NULL) OR ([Nazvanie_specialnosti] = @Original_Nazvanie_specialnosti)))</CommandText>
  180. <Parameters>
  181. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_specialnosti" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_specialnosti" SourceColumnNullMapping="false" SourceVersion="Original" />
  182. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nazvanie_specialnosti" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nazvanie_specialnosti" SourceColumnNullMapping="true" SourceVersion="Original" />
  183. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazvanie_specialnosti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie_specialnosti" SourceColumnNullMapping="false" SourceVersion="Original" />
  184. </Parameters>
  185. </DbCommand>
  186. </DeleteCommand>
  187. <InsertCommand>
  188. <DbCommand CommandType="Text" ModifiedByUser="false">
  189. <CommandText>INSERT INTO [dbo].[Specialnost] ([Nazvanie_specialnosti], [Opisanie_specialnosti]) VALUES (@Nazvanie_specialnosti, @Opisanie_specialnosti);
  190. SELECT ID_specialnosti, Nazvanie_specialnosti, Opisanie_specialnosti FROM Specialnost WHERE (ID_specialnosti = SCOPE_IDENTITY())</CommandText>
  191. <Parameters>
  192. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie_specialnosti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie_specialnosti" SourceColumnNullMapping="false" SourceVersion="Current" />
  193. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Opisanie_specialnosti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Opisanie_specialnosti" SourceColumnNullMapping="false" SourceVersion="Current" />
  194. </Parameters>
  195. </DbCommand>
  196. </InsertCommand>
  197. <SelectCommand>
  198. <DbCommand CommandType="Text" ModifiedByUser="false">
  199. <CommandText>SELECT ID_specialnosti, Nazvanie_specialnosti, Opisanie_specialnosti FROM dbo.Specialnost</CommandText>
  200. <Parameters />
  201. </DbCommand>
  202. </SelectCommand>
  203. <UpdateCommand>
  204. <DbCommand CommandType="Text" ModifiedByUser="false">
  205. <CommandText>UPDATE [dbo].[Specialnost] SET [Nazvanie_specialnosti] = @Nazvanie_specialnosti, [Opisanie_specialnosti] = @Opisanie_specialnosti WHERE (([ID_specialnosti] = @Original_ID_specialnosti) AND ((@IsNull_Nazvanie_specialnosti = 1 AND [Nazvanie_specialnosti] IS NULL) OR ([Nazvanie_specialnosti] = @Original_Nazvanie_specialnosti)));
  206. SELECT ID_specialnosti, Nazvanie_specialnosti, Opisanie_specialnosti FROM Specialnost WHERE (ID_specialnosti = @ID_specialnosti)</CommandText>
  207. <Parameters>
  208. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie_specialnosti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie_specialnosti" SourceColumnNullMapping="false" SourceVersion="Current" />
  209. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Opisanie_specialnosti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Opisanie_specialnosti" SourceColumnNullMapping="false" SourceVersion="Current" />
  210. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_specialnosti" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_specialnosti" SourceColumnNullMapping="false" SourceVersion="Original" />
  211. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nazvanie_specialnosti" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nazvanie_specialnosti" SourceColumnNullMapping="true" SourceVersion="Original" />
  212. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nazvanie_specialnosti" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie_specialnosti" SourceColumnNullMapping="false" SourceVersion="Original" />
  213. <Parameter AllowDbNull="false" AutogeneratedName="ID_specialnosti" ColumnName="ID_specialnosti" DataSourceName="Savelev_Shevchenko_pr2.dbo.Specialnost" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@ID_specialnosti" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="ID_specialnosti" SourceColumnNullMapping="false" SourceVersion="Current" />
  214. </Parameters>
  215. </DbCommand>
  216. </UpdateCommand>
  217. </DbSource>
  218. </MainSource>
  219. <Mappings>
  220. <Mapping SourceColumn="ID_specialnosti" DataSetColumn="ID_specialnosti" />
  221. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  222. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  223. </Mappings>
  224. <Sources />
  225. </TableAdapter>
  226. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StudentTableAdapter" GeneratorDataComponentClassName="StudentTableAdapter" Name="Student" UserDataComponentName="StudentTableAdapter">
  227. <MainSource>
  228. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.Student" 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">
  229. <DeleteCommand>
  230. <DbCommand CommandType="Text" ModifiedByUser="false">
  231. <CommandText>DELETE FROM [dbo].[Student] WHERE (([ID_studenta] = @Original_ID_studenta) AND ((@IsNull_FIO = 1 AND [FIO] IS NULL) OR ([FIO] = @Original_FIO)) AND ([pol] = @Original_pol) AND ((@IsNull_Data_pojdeniya = 1 AND [Data_pojdeniya] IS NULL) OR ([Data_pojdeniya] = @Original_Data_pojdeniya)) AND ((@IsNull_roditeli = 1 AND [roditeli] IS NULL) OR ([roditeli] = @Original_roditeli)) AND ((@IsNull_telephone = 1 AND [telephone] IS NULL) OR ([telephone] = @Original_telephone)) AND ((@IsNull_Nomer_zachetki = 1 AND [Nomer_zachetki] IS NULL) OR ([Nomer_zachetki] = @Original_Nomer_zachetki)) AND ((@IsNull_Data_postypleniya = 1 AND [Data_postypleniya] IS NULL) OR ([Data_postypleniya] = @Original_Data_postypleniya)) AND ((@IsNull_Gryppa = 1 AND [Gryppa] IS NULL) OR ([Gryppa] = @Original_Gryppa)) AND ((@IsNull_Kypc = 1 AND [Kypc] IS NULL) OR ([Kypc] = @Original_Kypc)) AND ((@IsNull_ID_sresialnostu = 1 AND [ID_sresialnostu] IS NULL) OR ([ID_sresialnostu] = @Original_ID_sresialnostu)) AND ((@p3 = 1 AND [ochnay forma obycheniya]]] IS NULL) OR ([ochnay forma obycheniya]]] = @p2)))</CommandText>
  232. <Parameters>
  233. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_studenta" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_studenta" SourceColumnNullMapping="false" SourceVersion="Original" />
  234. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FIO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="true" SourceVersion="Original" />
  235. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FIO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Original" />
  236. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pol" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pol" SourceColumnNullMapping="false" SourceVersion="Original" />
  237. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_pojdeniya" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_pojdeniya" SourceColumnNullMapping="true" SourceVersion="Original" />
  238. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_pojdeniya" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_pojdeniya" SourceColumnNullMapping="false" SourceVersion="Original" />
  239. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_roditeli" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="roditeli" SourceColumnNullMapping="true" SourceVersion="Original" />
  240. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_roditeli" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="roditeli" SourceColumnNullMapping="false" SourceVersion="Original" />
  241. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telephone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telephone" SourceColumnNullMapping="true" SourceVersion="Original" />
  242. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telephone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telephone" SourceColumnNullMapping="false" SourceVersion="Original" />
  243. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nomer_zachetki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nomer_zachetki" SourceColumnNullMapping="true" SourceVersion="Original" />
  244. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Nomer_zachetki" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Nomer_zachetki" SourceColumnNullMapping="false" SourceVersion="Original" />
  245. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_postypleniya" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_postypleniya" SourceColumnNullMapping="true" SourceVersion="Original" />
  246. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_postypleniya" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_postypleniya" SourceColumnNullMapping="false" SourceVersion="Original" />
  247. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gryppa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gryppa" SourceColumnNullMapping="true" SourceVersion="Original" />
  248. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gryppa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gryppa" SourceColumnNullMapping="false" SourceVersion="Original" />
  249. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kypc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kypc" SourceColumnNullMapping="true" SourceVersion="Original" />
  250. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Kypc" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Kypc" SourceColumnNullMapping="false" SourceVersion="Original" />
  251. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_sresialnostu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_sresialnostu" SourceColumnNullMapping="true" SourceVersion="Original" />
  252. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_sresialnostu" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_sresialnostu" SourceColumnNullMapping="false" SourceVersion="Original" />
  253. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ochnay forma obycheniya]" SourceColumnNullMapping="true" SourceVersion="Original" />
  254. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ochnay forma obycheniya]" SourceColumnNullMapping="false" SourceVersion="Original" />
  255. </Parameters>
  256. </DbCommand>
  257. </DeleteCommand>
  258. <InsertCommand>
  259. <DbCommand CommandType="Text" ModifiedByUser="false">
  260. <CommandText>INSERT INTO [dbo].[Student] ([ID_studenta], [FIO], [pol], [Data_pojdeniya], [roditeli], [adres], [telephone], [Pasportnie_dannie], [Nomer_zachetki], [Data_postypleniya], [Gryppa], [Kypc], [ID_sresialnostu], [ochnay forma obycheniya]]]) VALUES (@ID_studenta, @FIO, @pol, @Data_pojdeniya, @roditeli, @adres, @telephone, @Pasportnie_dannie, @Nomer_zachetki, @Data_postypleniya, @Gryppa, @Kypc, @ID_sresialnostu, @p1);
  261. SELECT ID_studenta, FIO, pol, Data_pojdeniya, roditeli, adres, telephone, Pasportnie_dannie, Nomer_zachetki, Data_postypleniya, Gryppa, Kypc, ID_sresialnostu, [ochnay forma obycheniya]]] FROM Student WHERE (ID_studenta = @ID_studenta)</CommandText>
  262. <Parameters>
  263. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_studenta" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_studenta" SourceColumnNullMapping="false" SourceVersion="Current" />
  264. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FIO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Current" />
  265. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pol" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pol" SourceColumnNullMapping="false" SourceVersion="Current" />
  266. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_pojdeniya" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_pojdeniya" SourceColumnNullMapping="false" SourceVersion="Current" />
  267. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@roditeli" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="roditeli" SourceColumnNullMapping="false" SourceVersion="Current" />
  268. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@adres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="false" SourceVersion="Current" />
  269. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telephone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telephone" SourceColumnNullMapping="false" SourceVersion="Current" />
  270. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pasportnie_dannie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pasportnie_dannie" SourceColumnNullMapping="false" SourceVersion="Current" />
  271. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Nomer_zachetki" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Nomer_zachetki" SourceColumnNullMapping="false" SourceVersion="Current" />
  272. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_postypleniya" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_postypleniya" SourceColumnNullMapping="false" SourceVersion="Current" />
  273. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gryppa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gryppa" SourceColumnNullMapping="false" SourceVersion="Current" />
  274. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Kypc" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Kypc" SourceColumnNullMapping="false" SourceVersion="Current" />
  275. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_sresialnostu" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_sresialnostu" SourceColumnNullMapping="false" SourceVersion="Current" />
  276. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ochnay forma obycheniya]" SourceColumnNullMapping="false" SourceVersion="Current" />
  277. </Parameters>
  278. </DbCommand>
  279. </InsertCommand>
  280. <SelectCommand>
  281. <DbCommand CommandType="Text" ModifiedByUser="false">
  282. <CommandText>SELECT ID_studenta, FIO, pol, Data_pojdeniya, roditeli, adres, telephone, Pasportnie_dannie, Nomer_zachetki, Data_postypleniya, Gryppa, Kypc, ID_sresialnostu, [ochnay forma obycheniya]]] FROM dbo.Student</CommandText>
  283. <Parameters />
  284. </DbCommand>
  285. </SelectCommand>
  286. <UpdateCommand>
  287. <DbCommand CommandType="Text" ModifiedByUser="false">
  288. <CommandText>UPDATE [dbo].[Student] SET [ID_studenta] = @ID_studenta, [FIO] = @FIO, [pol] = @pol, [Data_pojdeniya] = @Data_pojdeniya, [roditeli] = @roditeli, [adres] = @adres, [telephone] = @telephone, [Pasportnie_dannie] = @Pasportnie_dannie, [Nomer_zachetki] = @Nomer_zachetki, [Data_postypleniya] = @Data_postypleniya, [Gryppa] = @Gryppa, [Kypc] = @Kypc, [ID_sresialnostu] = @ID_sresialnostu, [ochnay forma obycheniya]]] = @p1 WHERE (([ID_studenta] = @Original_ID_studenta) AND ((@IsNull_FIO = 1 AND [FIO] IS NULL) OR ([FIO] = @Original_FIO)) AND ([pol] = @Original_pol) AND ((@IsNull_Data_pojdeniya = 1 AND [Data_pojdeniya] IS NULL) OR ([Data_pojdeniya] = @Original_Data_pojdeniya)) AND ((@IsNull_roditeli = 1 AND [roditeli] IS NULL) OR ([roditeli] = @Original_roditeli)) AND ((@IsNull_telephone = 1 AND [telephone] IS NULL) OR ([telephone] = @Original_telephone)) AND ((@IsNull_Nomer_zachetki = 1 AND [Nomer_zachetki] IS NULL) OR ([Nomer_zachetki] = @Original_Nomer_zachetki)) AND ((@IsNull_Data_postypleniya = 1 AND [Data_postypleniya] IS NULL) OR ([Data_postypleniya] = @Original_Data_postypleniya)) AND ((@IsNull_Gryppa = 1 AND [Gryppa] IS NULL) OR ([Gryppa] = @Original_Gryppa)) AND ((@IsNull_Kypc = 1 AND [Kypc] IS NULL) OR ([Kypc] = @Original_Kypc)) AND ((@IsNull_ID_sresialnostu = 1 AND [ID_sresialnostu] IS NULL) OR ([ID_sresialnostu] = @Original_ID_sresialnostu)) AND ((@p3 = 1 AND [ochnay forma obycheniya]]] IS NULL) OR ([ochnay forma obycheniya]]] = @p2)));
  289. SELECT ID_studenta, FIO, pol, Data_pojdeniya, roditeli, adres, telephone, Pasportnie_dannie, Nomer_zachetki, Data_postypleniya, Gryppa, Kypc, ID_sresialnostu, [ochnay forma obycheniya]]] FROM Student WHERE (ID_studenta = @ID_studenta)</CommandText>
  290. <Parameters>
  291. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_studenta" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_studenta" SourceColumnNullMapping="false" SourceVersion="Current" />
  292. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FIO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Current" />
  293. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pol" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pol" SourceColumnNullMapping="false" SourceVersion="Current" />
  294. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_pojdeniya" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_pojdeniya" SourceColumnNullMapping="false" SourceVersion="Current" />
  295. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@roditeli" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="roditeli" SourceColumnNullMapping="false" SourceVersion="Current" />
  296. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@adres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="false" SourceVersion="Current" />
  297. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telephone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telephone" SourceColumnNullMapping="false" SourceVersion="Current" />
  298. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Pasportnie_dannie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pasportnie_dannie" SourceColumnNullMapping="false" SourceVersion="Current" />
  299. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Nomer_zachetki" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Nomer_zachetki" SourceColumnNullMapping="false" SourceVersion="Current" />
  300. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Data_postypleniya" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_postypleniya" SourceColumnNullMapping="false" SourceVersion="Current" />
  301. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gryppa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gryppa" SourceColumnNullMapping="false" SourceVersion="Current" />
  302. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Kypc" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Kypc" SourceColumnNullMapping="false" SourceVersion="Current" />
  303. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ID_sresialnostu" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_sresialnostu" SourceColumnNullMapping="false" SourceVersion="Current" />
  304. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ochnay forma obycheniya]" SourceColumnNullMapping="false" SourceVersion="Current" />
  305. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_studenta" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_studenta" SourceColumnNullMapping="false" SourceVersion="Original" />
  306. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FIO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="true" SourceVersion="Original" />
  307. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FIO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Original" />
  308. <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pol" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pol" SourceColumnNullMapping="false" SourceVersion="Original" />
  309. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_pojdeniya" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_pojdeniya" SourceColumnNullMapping="true" SourceVersion="Original" />
  310. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_pojdeniya" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_pojdeniya" SourceColumnNullMapping="false" SourceVersion="Original" />
  311. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_roditeli" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="roditeli" SourceColumnNullMapping="true" SourceVersion="Original" />
  312. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_roditeli" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="roditeli" SourceColumnNullMapping="false" SourceVersion="Original" />
  313. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telephone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telephone" SourceColumnNullMapping="true" SourceVersion="Original" />
  314. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telephone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telephone" SourceColumnNullMapping="false" SourceVersion="Original" />
  315. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nomer_zachetki" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nomer_zachetki" SourceColumnNullMapping="true" SourceVersion="Original" />
  316. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Nomer_zachetki" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="Nomer_zachetki" SourceColumnNullMapping="false" SourceVersion="Original" />
  317. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_postypleniya" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data_postypleniya" SourceColumnNullMapping="true" SourceVersion="Original" />
  318. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Data_postypleniya" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Data_postypleniya" SourceColumnNullMapping="false" SourceVersion="Original" />
  319. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gryppa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gryppa" SourceColumnNullMapping="true" SourceVersion="Original" />
  320. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gryppa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gryppa" SourceColumnNullMapping="false" SourceVersion="Original" />
  321. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kypc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kypc" SourceColumnNullMapping="true" SourceVersion="Original" />
  322. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Kypc" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Kypc" SourceColumnNullMapping="false" SourceVersion="Original" />
  323. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_sresialnostu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_sresialnostu" SourceColumnNullMapping="true" SourceVersion="Original" />
  324. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID_sresialnostu" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ID_sresialnostu" SourceColumnNullMapping="false" SourceVersion="Original" />
  325. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ochnay forma obycheniya]" SourceColumnNullMapping="true" SourceVersion="Original" />
  326. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ochnay forma obycheniya]" SourceColumnNullMapping="false" SourceVersion="Original" />
  327. </Parameters>
  328. </DbCommand>
  329. </UpdateCommand>
  330. </DbSource>
  331. </MainSource>
  332. <Mappings>
  333. <Mapping SourceColumn="ID_studenta" DataSetColumn="ID_studenta" />
  334. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  335. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  336. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  337. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  338. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  339. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  340. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  341. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  342. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  343. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  344. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  345. <Mapping SourceColumn="ID_sresialnostu" DataSetColumn="ID_sresialnostu" />
  346. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  347. </Mappings>
  348. <Sources />
  349. </TableAdapter>
  350. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="View_1TableAdapter" GeneratorDataComponentClassName="View_1TableAdapter" Name="View_1" UserDataComponentName="View_1TableAdapter">
  351. <MainSource>
  352. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.View_1" 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">
  353. <SelectCommand>
  354. <DbCommand CommandType="Text" ModifiedByUser="false">
  355. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki FROM dbo.View_1</CommandText>
  356. <Parameters />
  357. </DbCommand>
  358. </SelectCommand>
  359. </DbSource>
  360. </MainSource>
  361. <Mappings>
  362. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  363. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  364. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  365. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  366. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  367. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  368. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  369. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  370. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  371. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  372. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  373. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  374. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  375. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  376. </Mappings>
  377. <Sources />
  378. </TableAdapter>
  379. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Запрос Студент+специальностьTableAdapter" GeneratorDataComponentClassName="Запрос_Студент_специальностьTableAdapter" Name="Запрос Студент+специальность" UserDataComponentName="Запрос Студент+специальностьTableAdapter">
  380. <MainSource>
  381. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[Запрос Студент+специальность]" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
  382. <SelectCommand>
  383. <DbCommand CommandType="Text" ModifiedByUser="false">
  384. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Nomer_zachetki, Data_postypleniya, telephone, Pasportnie_dannie, adres, roditeli, Data_pojdeniya, Nazvanie_specialnosti, Opisanie_specialnosti FROM dbo.[Запрос Студент+специальность]</CommandText>
  385. <Parameters />
  386. </DbCommand>
  387. </SelectCommand>
  388. </DbSource>
  389. </MainSource>
  390. <Mappings>
  391. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  392. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  393. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  394. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  395. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  396. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  397. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  398. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  399. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  400. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  401. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  402. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  403. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  404. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  405. </Mappings>
  406. <Sources />
  407. </TableAdapter>
  408. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Запрос студенты+оценкиTableAdapter" GeneratorDataComponentClassName="Запрос_студенты_оценкиTableAdapter" Name="Запрос студенты+оценки" UserDataComponentName="Запрос студенты+оценкиTableAdapter">
  409. <MainSource>
  410. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[Запрос студенты+оценки]" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
  411. <SelectCommand>
  412. <DbCommand CommandType="Text" ModifiedByUser="false">
  413. <CommandText>SELECT FIO, Data_ikzamena1, Ocenka1, Data_ikzamena2, Ocenka2, Data_ikzamena3, Ocenka3, Srednii_ball, Nazvanie_predmeta, Expr1, Expr2 FROM dbo.[Запрос студенты+оценки]</CommandText>
  414. <Parameters />
  415. </DbCommand>
  416. </SelectCommand>
  417. </DbSource>
  418. </MainSource>
  419. <Mappings>
  420. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  421. <Mapping SourceColumn="Data_ikzamena1" DataSetColumn="Data_ikzamena1" />
  422. <Mapping SourceColumn="Ocenka1" DataSetColumn="Ocenka1" />
  423. <Mapping SourceColumn="Data_ikzamena2" DataSetColumn="Data_ikzamena2" />
  424. <Mapping SourceColumn="Ocenka2" DataSetColumn="Ocenka2" />
  425. <Mapping SourceColumn="Data_ikzamena3" DataSetColumn="Data_ikzamena3" />
  426. <Mapping SourceColumn="Ocenka3" DataSetColumn="Ocenka3" />
  427. <Mapping SourceColumn="Srednii_ball" DataSetColumn="Srednii_ball" />
  428. <Mapping SourceColumn="Nazvanie_predmeta" DataSetColumn="Nazvanie_predmeta" />
  429. <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
  430. <Mapping SourceColumn="Expr2" DataSetColumn="Expr2" />
  431. </Mappings>
  432. <Sources />
  433. </TableAdapter>
  434. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр BYTableAdapter" GeneratorDataComponentClassName="Фильтр_BYTableAdapter" Name="Фильтр BY" UserDataComponentName="Фильтр BYTableAdapter">
  435. <MainSource>
  436. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[Фильтр BY]" 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">
  437. <SelectCommand>
  438. <DbCommand CommandType="Text" ModifiedByUser="false">
  439. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр BY]</CommandText>
  440. <Parameters />
  441. </DbCommand>
  442. </SelectCommand>
  443. </DbSource>
  444. </MainSource>
  445. <Mappings>
  446. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  447. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  448. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  449. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  450. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  451. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  452. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  453. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  454. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  455. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  456. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  457. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  458. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  459. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  460. <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
  461. </Mappings>
  462. <Sources />
  463. </TableAdapter>
  464. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр MOTableAdapter" GeneratorDataComponentClassName="Фильтр_MOTableAdapter" Name="Фильтр MO" UserDataComponentName="Фильтр MOTableAdapter">
  465. <MainSource>
  466. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[Фильтр MO]" 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">
  467. <SelectCommand>
  468. <DbCommand CommandType="Text" ModifiedByUser="false">
  469. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр MO]</CommandText>
  470. <Parameters />
  471. </DbCommand>
  472. </SelectCommand>
  473. </DbSource>
  474. </MainSource>
  475. <Mappings>
  476. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  477. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  478. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  479. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  480. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  481. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  482. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  483. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  484. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  485. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  486. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  487. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  488. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  489. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  490. <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
  491. </Mappings>
  492. <Sources />
  493. </TableAdapter>
  494. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр PITableAdapter" GeneratorDataComponentClassName="Фильтр_PITableAdapter" Name="Фильтр PI" UserDataComponentName="Фильтр PITableAdapter">
  495. <MainSource>
  496. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[Фильтр PI]" 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">
  497. <SelectCommand>
  498. <DbCommand CommandType="Text" ModifiedByUser="false">
  499. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, telephone, Data_postypleniya, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki FROM dbo.[Фильтр PI]</CommandText>
  500. <Parameters />
  501. </DbCommand>
  502. </SelectCommand>
  503. </DbSource>
  504. </MainSource>
  505. <Mappings>
  506. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  507. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  508. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  509. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  510. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  511. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  512. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  513. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  514. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  515. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  516. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  517. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  518. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  519. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  520. </Mappings>
  521. <Sources />
  522. </TableAdapter>
  523. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр STTableAdapter" GeneratorDataComponentClassName="Фильтр_STTableAdapter" Name="Фильтр ST" UserDataComponentName="Фильтр STTableAdapter">
  524. <MainSource>
  525. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[Фильтр ST]" 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">
  526. <SelectCommand>
  527. <DbCommand CommandType="Text" ModifiedByUser="false">
  528. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, Nazvanie_specialnosti, roditeli, Nomer_zachetki, Opisanie_specialnosti FROM dbo.[Фильтр ST]</CommandText>
  529. <Parameters />
  530. </DbCommand>
  531. </SelectCommand>
  532. </DbSource>
  533. </MainSource>
  534. <Mappings>
  535. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  536. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  537. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  538. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  539. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  540. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  541. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  542. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  543. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  544. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  545. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  546. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  547. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  548. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  549. </Mappings>
  550. <Sources />
  551. </TableAdapter>
  552. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр матьTableAdapter" GeneratorDataComponentClassName="Фильтр_матьTableAdapter" Name="Фильтр мать" UserDataComponentName="Фильтр матьTableAdapter">
  553. <MainSource>
  554. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[Фильтр мать]" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
  555. <SelectCommand>
  556. <DbCommand CommandType="Text" ModifiedByUser="false">
  557. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр мать]</CommandText>
  558. <Parameters />
  559. </DbCommand>
  560. </SelectCommand>
  561. </DbSource>
  562. </MainSource>
  563. <Mappings>
  564. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  565. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  566. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  567. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  568. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  569. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  570. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  571. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  572. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  573. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  574. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  575. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  576. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  577. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  578. <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
  579. </Mappings>
  580. <Sources />
  581. </TableAdapter>
  582. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="фильтр ММTableAdapter" GeneratorDataComponentClassName="фильтр_ММTableAdapter" Name="фильтр ММ" UserDataComponentName="фильтр ММTableAdapter">
  583. <MainSource>
  584. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[фильтр ММ]" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
  585. <SelectCommand>
  586. <DbCommand CommandType="Text" ModifiedByUser="false">
  587. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki FROM dbo.[фильтр ММ]</CommandText>
  588. <Parameters />
  589. </DbCommand>
  590. </SelectCommand>
  591. </DbSource>
  592. </MainSource>
  593. <Mappings>
  594. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  595. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  596. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  597. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  598. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  599. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  600. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  601. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  602. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  603. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  604. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  605. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  606. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  607. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  608. </Mappings>
  609. <Sources />
  610. </TableAdapter>
  611. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр отецTableAdapter" GeneratorDataComponentClassName="Фильтр_отецTableAdapter" Name="Фильтр отец" UserDataComponentName="Фильтр отецTableAdapter">
  612. <MainSource>
  613. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[Фильтр отец]" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
  614. <SelectCommand>
  615. <DbCommand CommandType="Text" ModifiedByUser="false">
  616. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр отец]</CommandText>
  617. <Parameters />
  618. </DbCommand>
  619. </SelectCommand>
  620. </DbSource>
  621. </MainSource>
  622. <Mappings>
  623. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  624. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  625. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  626. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  627. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  628. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  629. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  630. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  631. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  632. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  633. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  634. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  635. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  636. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  637. <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
  638. </Mappings>
  639. <Sources />
  640. </TableAdapter>
  641. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр отец и матьTableAdapter" GeneratorDataComponentClassName="Фильтр_отец_и_матьTableAdapter" Name="Фильтр отец и мать" UserDataComponentName="Фильтр отец и матьTableAdapter">
  642. <MainSource>
  643. <DbSource ConnectionRef="Savelev_Shevchenko_pr2ConnectionString (Settings)" DbObjectName="Savelev_Shevchenko_pr2.dbo.[Фильтр отец и мать]" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
  644. <SelectCommand>
  645. <DbCommand CommandType="Text" ModifiedByUser="false">
  646. <CommandText>SELECT FIO, pol, [ochnay forma obycheniya]]], Kypc, Gryppa, Data_postypleniya, telephone, Pasportnie_dannie, adres, Data_pojdeniya, roditeli, Nazvanie_specialnosti, Opisanie_specialnosti, Nomer_zachetki, Expr1 FROM dbo.[Фильтр отец и мать]</CommandText>
  647. <Parameters />
  648. </DbCommand>
  649. </SelectCommand>
  650. </DbSource>
  651. </MainSource>
  652. <Mappings>
  653. <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
  654. <Mapping SourceColumn="pol" DataSetColumn="pol" />
  655. <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
  656. <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
  657. <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
  658. <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
  659. <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
  660. <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
  661. <Mapping SourceColumn="adres" DataSetColumn="adres" />
  662. <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
  663. <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
  664. <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
  665. <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
  666. <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
  667. <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
  668. </Mappings>
  669. <Sources />
  670. </TableAdapter>
  671. </Tables>
  672. <Sources />
  673. </DataSource>
  674. </xs:appinfo>
  675. </xs:annotation>
  676. <xs:element name="Savelev_Shevchenko_pr2DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Savelev_Shevchenko_pr2DataSet1" msprop:Generator_UserDSName="Savelev_Shevchenko_pr2DataSet1">
  677. <xs:complexType>
  678. <xs:choice minOccurs="0" maxOccurs="unbounded">
  679. <xs:element name="Ocenka" msprop:Generator_TableClassName="OcenkaDataTable" msprop:Generator_TableVarName="tableOcenka" msprop:Generator_TablePropName="Ocenka" msprop:Generator_RowDeletingName="OcenkaRowDeleting" msprop:Generator_RowChangingName="OcenkaRowChanging" msprop:Generator_RowEvHandlerName="OcenkaRowChangeEventHandler" msprop:Generator_RowDeletedName="OcenkaRowDeleted" msprop:Generator_UserTableName="Ocenka" msprop:Generator_RowChangedName="OcenkaRowChanged" msprop:Generator_RowEvArgName="OcenkaRowChangeEvent" msprop:Generator_RowClassName="OcenkaRow">
  680. <xs:complexType>
  681. <xs:sequence>
  682. <xs:element name="ID_studenta" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_studenta" msprop:Generator_ColumnPropNameInRow="ID_studenta" msprop:Generator_ColumnPropNameInTable="ID_studentaColumn" msprop:Generator_UserColumnName="ID_studenta" type="xs:long" />
  683. <xs:element name="Data_ikzamena1" msprop:Generator_ColumnVarNameInTable="columnData_ikzamena1" msprop:Generator_ColumnPropNameInRow="Data_ikzamena1" msprop:Generator_ColumnPropNameInTable="Data_ikzamena1Column" msprop:Generator_UserColumnName="Data_ikzamena1" type="xs:dateTime" minOccurs="0" />
  684. <xs:element name="ID_predmeta1" msprop:Generator_ColumnVarNameInTable="columnID_predmeta1" msprop:Generator_ColumnPropNameInRow="ID_predmeta1" msprop:Generator_ColumnPropNameInTable="ID_predmeta1Column" msprop:Generator_UserColumnName="ID_predmeta1" type="xs:long" minOccurs="0" />
  685. <xs:element name="Ocenka1" msprop:Generator_ColumnVarNameInTable="columnOcenka1" msprop:Generator_ColumnPropNameInRow="Ocenka1" msprop:Generator_ColumnPropNameInTable="Ocenka1Column" msprop:Generator_UserColumnName="Ocenka1" type="xs:unsignedByte" minOccurs="0" />
  686. <xs:element name="Data_ikzamena2" msprop:Generator_ColumnVarNameInTable="columnData_ikzamena2" msprop:Generator_ColumnPropNameInRow="Data_ikzamena2" msprop:Generator_ColumnPropNameInTable="Data_ikzamena2Column" msprop:Generator_UserColumnName="Data_ikzamena2" type="xs:dateTime" minOccurs="0" />
  687. <xs:element name="ID_predmeta2" msprop:Generator_ColumnVarNameInTable="columnID_predmeta2" msprop:Generator_ColumnPropNameInRow="ID_predmeta2" msprop:Generator_ColumnPropNameInTable="ID_predmeta2Column" msprop:Generator_UserColumnName="ID_predmeta2" type="xs:long" minOccurs="0" />
  688. <xs:element name="Ocenka2" msprop:Generator_ColumnVarNameInTable="columnOcenka2" msprop:Generator_ColumnPropNameInRow="Ocenka2" msprop:Generator_ColumnPropNameInTable="Ocenka2Column" msprop:Generator_UserColumnName="Ocenka2" type="xs:unsignedByte" minOccurs="0" />
  689. <xs:element name="Data_ikzamena3" msprop:Generator_ColumnVarNameInTable="columnData_ikzamena3" msprop:Generator_ColumnPropNameInRow="Data_ikzamena3" msprop:Generator_ColumnPropNameInTable="Data_ikzamena3Column" msprop:Generator_UserColumnName="Data_ikzamena3" type="xs:dateTime" minOccurs="0" />
  690. <xs:element name="ID_predmeta3" msprop:Generator_ColumnVarNameInTable="columnID_predmeta3" msprop:Generator_ColumnPropNameInRow="ID_predmeta3" msprop:Generator_ColumnPropNameInTable="ID_predmeta3Column" msprop:Generator_UserColumnName="ID_predmeta3" type="xs:long" minOccurs="0" />
  691. <xs:element name="Ocenka3" msprop:Generator_ColumnVarNameInTable="columnOcenka3" msprop:Generator_ColumnPropNameInRow="Ocenka3" msprop:Generator_ColumnPropNameInTable="Ocenka3Column" msprop:Generator_UserColumnName="Ocenka3" type="xs:unsignedByte" minOccurs="0" />
  692. <xs:element name="Srednii_ball" msprop:Generator_ColumnVarNameInTable="columnSrednii_ball" msprop:Generator_ColumnPropNameInRow="Srednii_ball" msprop:Generator_ColumnPropNameInTable="Srednii_ballColumn" msprop:Generator_UserColumnName="Srednii_ball" type="xs:float" minOccurs="0" />
  693. </xs:sequence>
  694. </xs:complexType>
  695. </xs:element>
  696. <xs:element name="Predmet" msprop:Generator_TableClassName="PredmetDataTable" msprop:Generator_TableVarName="tablePredmet" msprop:Generator_TablePropName="Predmet" msprop:Generator_RowDeletingName="PredmetRowDeleting" msprop:Generator_RowChangingName="PredmetRowChanging" msprop:Generator_RowEvHandlerName="PredmetRowChangeEventHandler" msprop:Generator_RowDeletedName="PredmetRowDeleted" msprop:Generator_UserTableName="Predmet" msprop:Generator_RowChangedName="PredmetRowChanged" msprop:Generator_RowEvArgName="PredmetRowChangeEvent" msprop:Generator_RowClassName="PredmetRow">
  697. <xs:complexType>
  698. <xs:sequence>
  699. <xs:element name="ID_predmeta" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_predmeta" msprop:Generator_ColumnPropNameInRow="ID_predmeta" msprop:Generator_ColumnPropNameInTable="ID_predmetaColumn" msprop:Generator_UserColumnName="ID_predmeta" type="xs:int" />
  700. <xs:element name="Nazvanie_predmeta" msprop:Generator_ColumnVarNameInTable="columnNazvanie_predmeta" msprop:Generator_ColumnPropNameInRow="Nazvanie_predmeta" msprop:Generator_ColumnPropNameInTable="Nazvanie_predmetaColumn" msprop:Generator_UserColumnName="Nazvanie_predmeta" minOccurs="0">
  701. <xs:simpleType>
  702. <xs:restriction base="xs:string">
  703. <xs:maxLength value="90" />
  704. </xs:restriction>
  705. </xs:simpleType>
  706. </xs:element>
  707. <xs:element name="Opisanie_predmeta" msprop:Generator_ColumnVarNameInTable="columnOpisanie_predmeta" msprop:Generator_ColumnPropNameInRow="Opisanie_predmeta" msprop:Generator_ColumnPropNameInTable="Opisanie_predmetaColumn" msprop:Generator_UserColumnName="Opisanie_predmeta" minOccurs="0">
  708. <xs:simpleType>
  709. <xs:restriction base="xs:string">
  710. <xs:maxLength value="2147483647" />
  711. </xs:restriction>
  712. </xs:simpleType>
  713. </xs:element>
  714. </xs:sequence>
  715. </xs:complexType>
  716. </xs:element>
  717. <xs:element name="Specialnost" msprop:Generator_TableClassName="SpecialnostDataTable" msprop:Generator_TableVarName="tableSpecialnost" msprop:Generator_TablePropName="Specialnost" msprop:Generator_RowDeletingName="SpecialnostRowDeleting" msprop:Generator_RowChangingName="SpecialnostRowChanging" msprop:Generator_RowEvHandlerName="SpecialnostRowChangeEventHandler" msprop:Generator_RowDeletedName="SpecialnostRowDeleted" msprop:Generator_UserTableName="Specialnost" msprop:Generator_RowChangedName="SpecialnostRowChanged" msprop:Generator_RowEvArgName="SpecialnostRowChangeEvent" msprop:Generator_RowClassName="SpecialnostRow">
  718. <xs:complexType>
  719. <xs:sequence>
  720. <xs:element name="ID_specialnosti" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_specialnosti" msprop:Generator_ColumnPropNameInRow="ID_specialnosti" msprop:Generator_ColumnPropNameInTable="ID_specialnostiColumn" msprop:Generator_UserColumnName="ID_specialnosti" type="xs:long" />
  721. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  722. <xs:simpleType>
  723. <xs:restriction base="xs:string">
  724. <xs:maxLength value="20" />
  725. </xs:restriction>
  726. </xs:simpleType>
  727. </xs:element>
  728. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  729. <xs:simpleType>
  730. <xs:restriction base="xs:string">
  731. <xs:maxLength value="2147483647" />
  732. </xs:restriction>
  733. </xs:simpleType>
  734. </xs:element>
  735. </xs:sequence>
  736. </xs:complexType>
  737. </xs:element>
  738. <xs:element name="Student" msprop:Generator_TableClassName="StudentDataTable" msprop:Generator_TableVarName="tableStudent" msprop:Generator_TablePropName="Student" msprop:Generator_RowDeletingName="StudentRowDeleting" msprop:Generator_RowChangingName="StudentRowChanging" msprop:Generator_RowEvHandlerName="StudentRowChangeEventHandler" msprop:Generator_RowDeletedName="StudentRowDeleted" msprop:Generator_UserTableName="Student" msprop:Generator_RowChangedName="StudentRowChanged" msprop:Generator_RowEvArgName="StudentRowChangeEvent" msprop:Generator_RowClassName="StudentRow">
  739. <xs:complexType>
  740. <xs:sequence>
  741. <xs:element name="ID_studenta" msprop:Generator_ColumnVarNameInTable="columnID_studenta" msprop:Generator_ColumnPropNameInRow="ID_studenta" msprop:Generator_ColumnPropNameInTable="ID_studentaColumn" msprop:Generator_UserColumnName="ID_studenta" type="xs:long" />
  742. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  743. <xs:simpleType>
  744. <xs:restriction base="xs:string">
  745. <xs:maxLength value="50" />
  746. </xs:restriction>
  747. </xs:simpleType>
  748. </xs:element>
  749. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  750. <xs:simpleType>
  751. <xs:restriction base="xs:string">
  752. <xs:maxLength value="20" />
  753. </xs:restriction>
  754. </xs:simpleType>
  755. </xs:element>
  756. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  757. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  758. <xs:simpleType>
  759. <xs:restriction base="xs:string">
  760. <xs:maxLength value="50" />
  761. </xs:restriction>
  762. </xs:simpleType>
  763. </xs:element>
  764. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  765. <xs:simpleType>
  766. <xs:restriction base="xs:string">
  767. <xs:maxLength value="2147483647" />
  768. </xs:restriction>
  769. </xs:simpleType>
  770. </xs:element>
  771. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  772. <xs:simpleType>
  773. <xs:restriction base="xs:string">
  774. <xs:maxLength value="15" />
  775. </xs:restriction>
  776. </xs:simpleType>
  777. </xs:element>
  778. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  779. <xs:simpleType>
  780. <xs:restriction base="xs:string">
  781. <xs:maxLength value="2147483647" />
  782. </xs:restriction>
  783. </xs:simpleType>
  784. </xs:element>
  785. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  786. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  787. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  788. <xs:simpleType>
  789. <xs:restriction base="xs:string">
  790. <xs:maxLength value="20" />
  791. </xs:restriction>
  792. </xs:simpleType>
  793. </xs:element>
  794. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  795. <xs:element name="ID_sresialnostu" msprop:Generator_ColumnVarNameInTable="columnID_sresialnostu" msprop:Generator_ColumnPropNameInRow="ID_sresialnostu" msprop:Generator_ColumnPropNameInTable="ID_sresialnostuColumn" msprop:Generator_UserColumnName="ID_sresialnostu" type="xs:long" minOccurs="0" />
  796. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  797. </xs:sequence>
  798. </xs:complexType>
  799. </xs:element>
  800. <xs:element name="View_1" msprop:Generator_TableClassName="View_1DataTable" msprop:Generator_TableVarName="tableView_1" msprop:Generator_TablePropName="View_1" msprop:Generator_RowDeletingName="View_1RowDeleting" msprop:Generator_RowChangingName="View_1RowChanging" msprop:Generator_RowEvHandlerName="View_1RowChangeEventHandler" msprop:Generator_RowDeletedName="View_1RowDeleted" msprop:Generator_UserTableName="View_1" msprop:Generator_RowChangedName="View_1RowChanged" msprop:Generator_RowEvArgName="View_1RowChangeEvent" msprop:Generator_RowClassName="View_1Row">
  801. <xs:complexType>
  802. <xs:sequence>
  803. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  804. <xs:simpleType>
  805. <xs:restriction base="xs:string">
  806. <xs:maxLength value="50" />
  807. </xs:restriction>
  808. </xs:simpleType>
  809. </xs:element>
  810. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  811. <xs:simpleType>
  812. <xs:restriction base="xs:string">
  813. <xs:maxLength value="20" />
  814. </xs:restriction>
  815. </xs:simpleType>
  816. </xs:element>
  817. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  818. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  819. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  820. <xs:simpleType>
  821. <xs:restriction base="xs:string">
  822. <xs:maxLength value="20" />
  823. </xs:restriction>
  824. </xs:simpleType>
  825. </xs:element>
  826. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  827. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  828. <xs:simpleType>
  829. <xs:restriction base="xs:string">
  830. <xs:maxLength value="15" />
  831. </xs:restriction>
  832. </xs:simpleType>
  833. </xs:element>
  834. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  835. <xs:simpleType>
  836. <xs:restriction base="xs:string">
  837. <xs:maxLength value="2147483647" />
  838. </xs:restriction>
  839. </xs:simpleType>
  840. </xs:element>
  841. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  842. <xs:simpleType>
  843. <xs:restriction base="xs:string">
  844. <xs:maxLength value="2147483647" />
  845. </xs:restriction>
  846. </xs:simpleType>
  847. </xs:element>
  848. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  849. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  850. <xs:simpleType>
  851. <xs:restriction base="xs:string">
  852. <xs:maxLength value="50" />
  853. </xs:restriction>
  854. </xs:simpleType>
  855. </xs:element>
  856. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  857. <xs:simpleType>
  858. <xs:restriction base="xs:string">
  859. <xs:maxLength value="20" />
  860. </xs:restriction>
  861. </xs:simpleType>
  862. </xs:element>
  863. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  864. <xs:simpleType>
  865. <xs:restriction base="xs:string">
  866. <xs:maxLength value="2147483647" />
  867. </xs:restriction>
  868. </xs:simpleType>
  869. </xs:element>
  870. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  871. </xs:sequence>
  872. </xs:complexType>
  873. </xs:element>
  874. <xs:element name="Запрос_x0020_Студент_x002B_специальность" msprop:Generator_TableClassName="_Запрос_Студент_специальностьDataTable" msprop:Generator_TableVarName="_tableЗапрос_Студент_специальность" msprop:Generator_TablePropName="_Запрос_Студент_специальность" msprop:Generator_RowDeletingName="_Запрос_Студент_специальностьRowDeleting" msprop:Generator_RowChangingName="_Запрос_Студент_специальностьRowChanging" msprop:Generator_RowEvHandlerName="_Запрос_Студент_специальностьRowChangeEventHandler" msprop:Generator_RowDeletedName="_Запрос_Студент_специальностьRowDeleted" msprop:Generator_UserTableName="Запрос Студент+специальность" msprop:Generator_RowChangedName="_Запрос_Студент_специальностьRowChanged" msprop:Generator_RowEvArgName="_Запрос_Студент_специальностьRowChangeEvent" msprop:Generator_RowClassName="_Запрос_Студент_специальностьRow">
  875. <xs:complexType>
  876. <xs:sequence>
  877. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  878. <xs:simpleType>
  879. <xs:restriction base="xs:string">
  880. <xs:maxLength value="50" />
  881. </xs:restriction>
  882. </xs:simpleType>
  883. </xs:element>
  884. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  885. <xs:simpleType>
  886. <xs:restriction base="xs:string">
  887. <xs:maxLength value="20" />
  888. </xs:restriction>
  889. </xs:simpleType>
  890. </xs:element>
  891. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  892. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  893. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  894. <xs:simpleType>
  895. <xs:restriction base="xs:string">
  896. <xs:maxLength value="20" />
  897. </xs:restriction>
  898. </xs:simpleType>
  899. </xs:element>
  900. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  901. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  902. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  903. <xs:simpleType>
  904. <xs:restriction base="xs:string">
  905. <xs:maxLength value="15" />
  906. </xs:restriction>
  907. </xs:simpleType>
  908. </xs:element>
  909. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  910. <xs:simpleType>
  911. <xs:restriction base="xs:string">
  912. <xs:maxLength value="2147483647" />
  913. </xs:restriction>
  914. </xs:simpleType>
  915. </xs:element>
  916. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  917. <xs:simpleType>
  918. <xs:restriction base="xs:string">
  919. <xs:maxLength value="2147483647" />
  920. </xs:restriction>
  921. </xs:simpleType>
  922. </xs:element>
  923. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  924. <xs:simpleType>
  925. <xs:restriction base="xs:string">
  926. <xs:maxLength value="50" />
  927. </xs:restriction>
  928. </xs:simpleType>
  929. </xs:element>
  930. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  931. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  932. <xs:simpleType>
  933. <xs:restriction base="xs:string">
  934. <xs:maxLength value="20" />
  935. </xs:restriction>
  936. </xs:simpleType>
  937. </xs:element>
  938. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  939. <xs:simpleType>
  940. <xs:restriction base="xs:string">
  941. <xs:maxLength value="2147483647" />
  942. </xs:restriction>
  943. </xs:simpleType>
  944. </xs:element>
  945. </xs:sequence>
  946. </xs:complexType>
  947. </xs:element>
  948. <xs:element name="Запрос_x0020_студенты_x002B_оценки" msprop:Generator_TableClassName="_Запрос_студенты_оценкиDataTable" msprop:Generator_TableVarName="_tableЗапрос_студенты_оценки" msprop:Generator_TablePropName="_Запрос_студенты_оценки" msprop:Generator_RowDeletingName="_Запрос_студенты_оценкиRowDeleting" msprop:Generator_RowChangingName="_Запрос_студенты_оценкиRowChanging" msprop:Generator_RowEvHandlerName="_Запрос_студенты_оценкиRowChangeEventHandler" msprop:Generator_RowDeletedName="_Запрос_студенты_оценкиRowDeleted" msprop:Generator_UserTableName="Запрос студенты+оценки" msprop:Generator_RowChangedName="_Запрос_студенты_оценкиRowChanged" msprop:Generator_RowEvArgName="_Запрос_студенты_оценкиRowChangeEvent" msprop:Generator_RowClassName="_Запрос_студенты_оценкиRow">
  949. <xs:complexType>
  950. <xs:sequence>
  951. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  952. <xs:simpleType>
  953. <xs:restriction base="xs:string">
  954. <xs:maxLength value="50" />
  955. </xs:restriction>
  956. </xs:simpleType>
  957. </xs:element>
  958. <xs:element name="Data_ikzamena1" msprop:Generator_ColumnVarNameInTable="columnData_ikzamena1" msprop:Generator_ColumnPropNameInRow="Data_ikzamena1" msprop:Generator_ColumnPropNameInTable="Data_ikzamena1Column" msprop:Generator_UserColumnName="Data_ikzamena1" type="xs:dateTime" minOccurs="0" />
  959. <xs:element name="Ocenka1" msprop:Generator_ColumnVarNameInTable="columnOcenka1" msprop:Generator_ColumnPropNameInRow="Ocenka1" msprop:Generator_ColumnPropNameInTable="Ocenka1Column" msprop:Generator_UserColumnName="Ocenka1" type="xs:unsignedByte" minOccurs="0" />
  960. <xs:element name="Data_ikzamena2" msprop:Generator_ColumnVarNameInTable="columnData_ikzamena2" msprop:Generator_ColumnPropNameInRow="Data_ikzamena2" msprop:Generator_ColumnPropNameInTable="Data_ikzamena2Column" msprop:Generator_UserColumnName="Data_ikzamena2" type="xs:dateTime" minOccurs="0" />
  961. <xs:element name="Ocenka2" msprop:Generator_ColumnVarNameInTable="columnOcenka2" msprop:Generator_ColumnPropNameInRow="Ocenka2" msprop:Generator_ColumnPropNameInTable="Ocenka2Column" msprop:Generator_UserColumnName="Ocenka2" type="xs:unsignedByte" minOccurs="0" />
  962. <xs:element name="Data_ikzamena3" msprop:Generator_ColumnVarNameInTable="columnData_ikzamena3" msprop:Generator_ColumnPropNameInRow="Data_ikzamena3" msprop:Generator_ColumnPropNameInTable="Data_ikzamena3Column" msprop:Generator_UserColumnName="Data_ikzamena3" type="xs:dateTime" minOccurs="0" />
  963. <xs:element name="Ocenka3" msprop:Generator_ColumnVarNameInTable="columnOcenka3" msprop:Generator_ColumnPropNameInRow="Ocenka3" msprop:Generator_ColumnPropNameInTable="Ocenka3Column" msprop:Generator_UserColumnName="Ocenka3" type="xs:unsignedByte" minOccurs="0" />
  964. <xs:element name="Srednii_ball" msprop:Generator_ColumnVarNameInTable="columnSrednii_ball" msprop:Generator_ColumnPropNameInRow="Srednii_ball" msprop:Generator_ColumnPropNameInTable="Srednii_ballColumn" msprop:Generator_UserColumnName="Srednii_ball" type="xs:float" minOccurs="0" />
  965. <xs:element name="Nazvanie_predmeta" msprop:Generator_ColumnVarNameInTable="columnNazvanie_predmeta" msprop:Generator_ColumnPropNameInRow="Nazvanie_predmeta" msprop:Generator_ColumnPropNameInTable="Nazvanie_predmetaColumn" msprop:Generator_UserColumnName="Nazvanie_predmeta" minOccurs="0">
  966. <xs:simpleType>
  967. <xs:restriction base="xs:string">
  968. <xs:maxLength value="90" />
  969. </xs:restriction>
  970. </xs:simpleType>
  971. </xs:element>
  972. <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
  973. <xs:simpleType>
  974. <xs:restriction base="xs:string">
  975. <xs:maxLength value="90" />
  976. </xs:restriction>
  977. </xs:simpleType>
  978. </xs:element>
  979. <xs:element name="Expr2" msprop:Generator_ColumnVarNameInTable="columnExpr2" msprop:Generator_ColumnPropNameInRow="Expr2" msprop:Generator_ColumnPropNameInTable="Expr2Column" msprop:Generator_UserColumnName="Expr2" minOccurs="0">
  980. <xs:simpleType>
  981. <xs:restriction base="xs:string">
  982. <xs:maxLength value="90" />
  983. </xs:restriction>
  984. </xs:simpleType>
  985. </xs:element>
  986. </xs:sequence>
  987. </xs:complexType>
  988. </xs:element>
  989. <xs:element name="Фильтр_x0020_BY" msprop:Generator_TableClassName="Фильтр_BYDataTable" msprop:Generator_TableVarName="tableФильтр_BY" msprop:Generator_TablePropName="Фильтр_BY" msprop:Generator_RowDeletingName="Фильтр_BYRowDeleting" msprop:Generator_RowChangingName="Фильтр_BYRowChanging" msprop:Generator_RowEvHandlerName="Фильтр_BYRowChangeEventHandler" msprop:Generator_RowDeletedName="Фильтр_BYRowDeleted" msprop:Generator_UserTableName="Фильтр BY" msprop:Generator_RowChangedName="Фильтр_BYRowChanged" msprop:Generator_RowEvArgName="Фильтр_BYRowChangeEvent" msprop:Generator_RowClassName="Фильтр_BYRow">
  990. <xs:complexType>
  991. <xs:sequence>
  992. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  993. <xs:simpleType>
  994. <xs:restriction base="xs:string">
  995. <xs:maxLength value="50" />
  996. </xs:restriction>
  997. </xs:simpleType>
  998. </xs:element>
  999. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  1000. <xs:simpleType>
  1001. <xs:restriction base="xs:string">
  1002. <xs:maxLength value="20" />
  1003. </xs:restriction>
  1004. </xs:simpleType>
  1005. </xs:element>
  1006. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  1007. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  1008. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  1009. <xs:simpleType>
  1010. <xs:restriction base="xs:string">
  1011. <xs:maxLength value="20" />
  1012. </xs:restriction>
  1013. </xs:simpleType>
  1014. </xs:element>
  1015. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  1016. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  1017. <xs:simpleType>
  1018. <xs:restriction base="xs:string">
  1019. <xs:maxLength value="15" />
  1020. </xs:restriction>
  1021. </xs:simpleType>
  1022. </xs:element>
  1023. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  1024. <xs:simpleType>
  1025. <xs:restriction base="xs:string">
  1026. <xs:maxLength value="2147483647" />
  1027. </xs:restriction>
  1028. </xs:simpleType>
  1029. </xs:element>
  1030. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  1031. <xs:simpleType>
  1032. <xs:restriction base="xs:string">
  1033. <xs:maxLength value="2147483647" />
  1034. </xs:restriction>
  1035. </xs:simpleType>
  1036. </xs:element>
  1037. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  1038. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  1039. <xs:simpleType>
  1040. <xs:restriction base="xs:string">
  1041. <xs:maxLength value="50" />
  1042. </xs:restriction>
  1043. </xs:simpleType>
  1044. </xs:element>
  1045. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  1046. <xs:simpleType>
  1047. <xs:restriction base="xs:string">
  1048. <xs:maxLength value="20" />
  1049. </xs:restriction>
  1050. </xs:simpleType>
  1051. </xs:element>
  1052. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  1053. <xs:simpleType>
  1054. <xs:restriction base="xs:string">
  1055. <xs:maxLength value="2147483647" />
  1056. </xs:restriction>
  1057. </xs:simpleType>
  1058. </xs:element>
  1059. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  1060. <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
  1061. <xs:simpleType>
  1062. <xs:restriction base="xs:string">
  1063. <xs:maxLength value="20" />
  1064. </xs:restriction>
  1065. </xs:simpleType>
  1066. </xs:element>
  1067. </xs:sequence>
  1068. </xs:complexType>
  1069. </xs:element>
  1070. <xs:element name="Фильтр_x0020_MO" msprop:Generator_TableClassName="Фильтр_MODataTable" msprop:Generator_TableVarName="tableФильтр_MO" msprop:Generator_TablePropName="Фильтр_MO" msprop:Generator_RowDeletingName="Фильтр_MORowDeleting" msprop:Generator_RowChangingName="Фильтр_MORowChanging" msprop:Generator_RowEvHandlerName="Фильтр_MORowChangeEventHandler" msprop:Generator_RowDeletedName="Фильтр_MORowDeleted" msprop:Generator_UserTableName="Фильтр MO" msprop:Generator_RowChangedName="Фильтр_MORowChanged" msprop:Generator_RowEvArgName="Фильтр_MORowChangeEvent" msprop:Generator_RowClassName="Фильтр_MORow">
  1071. <xs:complexType>
  1072. <xs:sequence>
  1073. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  1074. <xs:simpleType>
  1075. <xs:restriction base="xs:string">
  1076. <xs:maxLength value="50" />
  1077. </xs:restriction>
  1078. </xs:simpleType>
  1079. </xs:element>
  1080. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  1081. <xs:simpleType>
  1082. <xs:restriction base="xs:string">
  1083. <xs:maxLength value="20" />
  1084. </xs:restriction>
  1085. </xs:simpleType>
  1086. </xs:element>
  1087. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  1088. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  1089. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  1090. <xs:simpleType>
  1091. <xs:restriction base="xs:string">
  1092. <xs:maxLength value="20" />
  1093. </xs:restriction>
  1094. </xs:simpleType>
  1095. </xs:element>
  1096. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  1097. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  1098. <xs:simpleType>
  1099. <xs:restriction base="xs:string">
  1100. <xs:maxLength value="15" />
  1101. </xs:restriction>
  1102. </xs:simpleType>
  1103. </xs:element>
  1104. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  1105. <xs:simpleType>
  1106. <xs:restriction base="xs:string">
  1107. <xs:maxLength value="2147483647" />
  1108. </xs:restriction>
  1109. </xs:simpleType>
  1110. </xs:element>
  1111. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  1112. <xs:simpleType>
  1113. <xs:restriction base="xs:string">
  1114. <xs:maxLength value="2147483647" />
  1115. </xs:restriction>
  1116. </xs:simpleType>
  1117. </xs:element>
  1118. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  1119. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  1120. <xs:simpleType>
  1121. <xs:restriction base="xs:string">
  1122. <xs:maxLength value="50" />
  1123. </xs:restriction>
  1124. </xs:simpleType>
  1125. </xs:element>
  1126. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  1127. <xs:simpleType>
  1128. <xs:restriction base="xs:string">
  1129. <xs:maxLength value="20" />
  1130. </xs:restriction>
  1131. </xs:simpleType>
  1132. </xs:element>
  1133. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  1134. <xs:simpleType>
  1135. <xs:restriction base="xs:string">
  1136. <xs:maxLength value="2147483647" />
  1137. </xs:restriction>
  1138. </xs:simpleType>
  1139. </xs:element>
  1140. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  1141. <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
  1142. <xs:simpleType>
  1143. <xs:restriction base="xs:string">
  1144. <xs:maxLength value="20" />
  1145. </xs:restriction>
  1146. </xs:simpleType>
  1147. </xs:element>
  1148. </xs:sequence>
  1149. </xs:complexType>
  1150. </xs:element>
  1151. <xs:element name="Фильтр_x0020_PI" msprop:Generator_TableClassName="Фильтр_PIDataTable" msprop:Generator_TableVarName="tableФильтр_PI" msprop:Generator_TablePropName="Фильтр_PI" msprop:Generator_RowDeletingName="Фильтр_PIRowDeleting" msprop:Generator_RowChangingName="Фильтр_PIRowChanging" msprop:Generator_RowEvHandlerName="Фильтр_PIRowChangeEventHandler" msprop:Generator_RowDeletedName="Фильтр_PIRowDeleted" msprop:Generator_UserTableName="Фильтр PI" msprop:Generator_RowChangedName="Фильтр_PIRowChanged" msprop:Generator_RowEvArgName="Фильтр_PIRowChangeEvent" msprop:Generator_RowClassName="Фильтр_PIRow">
  1152. <xs:complexType>
  1153. <xs:sequence>
  1154. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  1155. <xs:simpleType>
  1156. <xs:restriction base="xs:string">
  1157. <xs:maxLength value="50" />
  1158. </xs:restriction>
  1159. </xs:simpleType>
  1160. </xs:element>
  1161. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  1162. <xs:simpleType>
  1163. <xs:restriction base="xs:string">
  1164. <xs:maxLength value="20" />
  1165. </xs:restriction>
  1166. </xs:simpleType>
  1167. </xs:element>
  1168. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  1169. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  1170. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  1171. <xs:simpleType>
  1172. <xs:restriction base="xs:string">
  1173. <xs:maxLength value="20" />
  1174. </xs:restriction>
  1175. </xs:simpleType>
  1176. </xs:element>
  1177. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  1178. <xs:simpleType>
  1179. <xs:restriction base="xs:string">
  1180. <xs:maxLength value="15" />
  1181. </xs:restriction>
  1182. </xs:simpleType>
  1183. </xs:element>
  1184. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  1185. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  1186. <xs:simpleType>
  1187. <xs:restriction base="xs:string">
  1188. <xs:maxLength value="2147483647" />
  1189. </xs:restriction>
  1190. </xs:simpleType>
  1191. </xs:element>
  1192. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  1193. <xs:simpleType>
  1194. <xs:restriction base="xs:string">
  1195. <xs:maxLength value="2147483647" />
  1196. </xs:restriction>
  1197. </xs:simpleType>
  1198. </xs:element>
  1199. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  1200. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  1201. <xs:simpleType>
  1202. <xs:restriction base="xs:string">
  1203. <xs:maxLength value="50" />
  1204. </xs:restriction>
  1205. </xs:simpleType>
  1206. </xs:element>
  1207. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  1208. <xs:simpleType>
  1209. <xs:restriction base="xs:string">
  1210. <xs:maxLength value="20" />
  1211. </xs:restriction>
  1212. </xs:simpleType>
  1213. </xs:element>
  1214. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  1215. <xs:simpleType>
  1216. <xs:restriction base="xs:string">
  1217. <xs:maxLength value="2147483647" />
  1218. </xs:restriction>
  1219. </xs:simpleType>
  1220. </xs:element>
  1221. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  1222. </xs:sequence>
  1223. </xs:complexType>
  1224. </xs:element>
  1225. <xs:element name="Фильтр_x0020_ST" msprop:Generator_TableClassName="Фильтр_STDataTable" msprop:Generator_TableVarName="tableФильтр_ST" msprop:Generator_TablePropName="Фильтр_ST" msprop:Generator_RowDeletingName="Фильтр_STRowDeleting" msprop:Generator_RowChangingName="Фильтр_STRowChanging" msprop:Generator_RowEvHandlerName="Фильтр_STRowChangeEventHandler" msprop:Generator_RowDeletedName="Фильтр_STRowDeleted" msprop:Generator_UserTableName="Фильтр ST" msprop:Generator_RowChangedName="Фильтр_STRowChanged" msprop:Generator_RowEvArgName="Фильтр_STRowChangeEvent" msprop:Generator_RowClassName="Фильтр_STRow">
  1226. <xs:complexType>
  1227. <xs:sequence>
  1228. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  1229. <xs:simpleType>
  1230. <xs:restriction base="xs:string">
  1231. <xs:maxLength value="50" />
  1232. </xs:restriction>
  1233. </xs:simpleType>
  1234. </xs:element>
  1235. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  1236. <xs:simpleType>
  1237. <xs:restriction base="xs:string">
  1238. <xs:maxLength value="20" />
  1239. </xs:restriction>
  1240. </xs:simpleType>
  1241. </xs:element>
  1242. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  1243. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  1244. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  1245. <xs:simpleType>
  1246. <xs:restriction base="xs:string">
  1247. <xs:maxLength value="20" />
  1248. </xs:restriction>
  1249. </xs:simpleType>
  1250. </xs:element>
  1251. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  1252. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  1253. <xs:simpleType>
  1254. <xs:restriction base="xs:string">
  1255. <xs:maxLength value="15" />
  1256. </xs:restriction>
  1257. </xs:simpleType>
  1258. </xs:element>
  1259. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  1260. <xs:simpleType>
  1261. <xs:restriction base="xs:string">
  1262. <xs:maxLength value="2147483647" />
  1263. </xs:restriction>
  1264. </xs:simpleType>
  1265. </xs:element>
  1266. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  1267. <xs:simpleType>
  1268. <xs:restriction base="xs:string">
  1269. <xs:maxLength value="2147483647" />
  1270. </xs:restriction>
  1271. </xs:simpleType>
  1272. </xs:element>
  1273. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  1274. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  1275. <xs:simpleType>
  1276. <xs:restriction base="xs:string">
  1277. <xs:maxLength value="20" />
  1278. </xs:restriction>
  1279. </xs:simpleType>
  1280. </xs:element>
  1281. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  1282. <xs:simpleType>
  1283. <xs:restriction base="xs:string">
  1284. <xs:maxLength value="50" />
  1285. </xs:restriction>
  1286. </xs:simpleType>
  1287. </xs:element>
  1288. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  1289. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  1290. <xs:simpleType>
  1291. <xs:restriction base="xs:string">
  1292. <xs:maxLength value="2147483647" />
  1293. </xs:restriction>
  1294. </xs:simpleType>
  1295. </xs:element>
  1296. </xs:sequence>
  1297. </xs:complexType>
  1298. </xs:element>
  1299. <xs:element name="Фильтр_x0020_мать" msprop:Generator_TableClassName="Фильтр_матьDataTable" msprop:Generator_TableVarName="tableФильтр_мать" msprop:Generator_TablePropName="Фильтр_мать" msprop:Generator_RowDeletingName="Фильтр_матьRowDeleting" msprop:Generator_RowChangingName="Фильтр_матьRowChanging" msprop:Generator_RowEvHandlerName="Фильтр_матьRowChangeEventHandler" msprop:Generator_RowDeletedName="Фильтр_матьRowDeleted" msprop:Generator_UserTableName="Фильтр мать" msprop:Generator_RowChangedName="Фильтр_матьRowChanged" msprop:Generator_RowEvArgName="Фильтр_матьRowChangeEvent" msprop:Generator_RowClassName="Фильтр_матьRow">
  1300. <xs:complexType>
  1301. <xs:sequence>
  1302. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  1303. <xs:simpleType>
  1304. <xs:restriction base="xs:string">
  1305. <xs:maxLength value="50" />
  1306. </xs:restriction>
  1307. </xs:simpleType>
  1308. </xs:element>
  1309. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  1310. <xs:simpleType>
  1311. <xs:restriction base="xs:string">
  1312. <xs:maxLength value="20" />
  1313. </xs:restriction>
  1314. </xs:simpleType>
  1315. </xs:element>
  1316. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  1317. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  1318. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  1319. <xs:simpleType>
  1320. <xs:restriction base="xs:string">
  1321. <xs:maxLength value="20" />
  1322. </xs:restriction>
  1323. </xs:simpleType>
  1324. </xs:element>
  1325. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  1326. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  1327. <xs:simpleType>
  1328. <xs:restriction base="xs:string">
  1329. <xs:maxLength value="15" />
  1330. </xs:restriction>
  1331. </xs:simpleType>
  1332. </xs:element>
  1333. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  1334. <xs:simpleType>
  1335. <xs:restriction base="xs:string">
  1336. <xs:maxLength value="2147483647" />
  1337. </xs:restriction>
  1338. </xs:simpleType>
  1339. </xs:element>
  1340. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  1341. <xs:simpleType>
  1342. <xs:restriction base="xs:string">
  1343. <xs:maxLength value="2147483647" />
  1344. </xs:restriction>
  1345. </xs:simpleType>
  1346. </xs:element>
  1347. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  1348. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  1349. <xs:simpleType>
  1350. <xs:restriction base="xs:string">
  1351. <xs:maxLength value="50" />
  1352. </xs:restriction>
  1353. </xs:simpleType>
  1354. </xs:element>
  1355. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  1356. <xs:simpleType>
  1357. <xs:restriction base="xs:string">
  1358. <xs:maxLength value="20" />
  1359. </xs:restriction>
  1360. </xs:simpleType>
  1361. </xs:element>
  1362. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  1363. <xs:simpleType>
  1364. <xs:restriction base="xs:string">
  1365. <xs:maxLength value="2147483647" />
  1366. </xs:restriction>
  1367. </xs:simpleType>
  1368. </xs:element>
  1369. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  1370. <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
  1371. <xs:simpleType>
  1372. <xs:restriction base="xs:string">
  1373. <xs:maxLength value="50" />
  1374. </xs:restriction>
  1375. </xs:simpleType>
  1376. </xs:element>
  1377. </xs:sequence>
  1378. </xs:complexType>
  1379. </xs:element>
  1380. <xs:element name="фильтр_x0020_ММ" msprop:Generator_TableClassName="фильтр_ММDataTable" msprop:Generator_TableVarName="tableфильтр_ММ" msprop:Generator_TablePropName="фильтр_ММ" msprop:Generator_RowDeletingName="фильтр_ММRowDeleting" msprop:Generator_RowChangingName="фильтр_ММRowChanging" msprop:Generator_RowEvHandlerName="фильтр_ММRowChangeEventHandler" msprop:Generator_RowDeletedName="фильтр_ММRowDeleted" msprop:Generator_UserTableName="фильтр ММ" msprop:Generator_RowChangedName="фильтр_ММRowChanged" msprop:Generator_RowEvArgName="фильтр_ММRowChangeEvent" msprop:Generator_RowClassName="фильтр_ММRow">
  1381. <xs:complexType>
  1382. <xs:sequence>
  1383. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  1384. <xs:simpleType>
  1385. <xs:restriction base="xs:string">
  1386. <xs:maxLength value="50" />
  1387. </xs:restriction>
  1388. </xs:simpleType>
  1389. </xs:element>
  1390. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  1391. <xs:simpleType>
  1392. <xs:restriction base="xs:string">
  1393. <xs:maxLength value="20" />
  1394. </xs:restriction>
  1395. </xs:simpleType>
  1396. </xs:element>
  1397. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  1398. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  1399. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  1400. <xs:simpleType>
  1401. <xs:restriction base="xs:string">
  1402. <xs:maxLength value="20" />
  1403. </xs:restriction>
  1404. </xs:simpleType>
  1405. </xs:element>
  1406. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  1407. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  1408. <xs:simpleType>
  1409. <xs:restriction base="xs:string">
  1410. <xs:maxLength value="15" />
  1411. </xs:restriction>
  1412. </xs:simpleType>
  1413. </xs:element>
  1414. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  1415. <xs:simpleType>
  1416. <xs:restriction base="xs:string">
  1417. <xs:maxLength value="2147483647" />
  1418. </xs:restriction>
  1419. </xs:simpleType>
  1420. </xs:element>
  1421. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  1422. <xs:simpleType>
  1423. <xs:restriction base="xs:string">
  1424. <xs:maxLength value="2147483647" />
  1425. </xs:restriction>
  1426. </xs:simpleType>
  1427. </xs:element>
  1428. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  1429. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  1430. <xs:simpleType>
  1431. <xs:restriction base="xs:string">
  1432. <xs:maxLength value="50" />
  1433. </xs:restriction>
  1434. </xs:simpleType>
  1435. </xs:element>
  1436. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  1437. <xs:simpleType>
  1438. <xs:restriction base="xs:string">
  1439. <xs:maxLength value="20" />
  1440. </xs:restriction>
  1441. </xs:simpleType>
  1442. </xs:element>
  1443. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  1444. <xs:simpleType>
  1445. <xs:restriction base="xs:string">
  1446. <xs:maxLength value="2147483647" />
  1447. </xs:restriction>
  1448. </xs:simpleType>
  1449. </xs:element>
  1450. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  1451. </xs:sequence>
  1452. </xs:complexType>
  1453. </xs:element>
  1454. <xs:element name="Фильтр_x0020_отец" msprop:Generator_TableClassName="Фильтр_отецDataTable" msprop:Generator_TableVarName="tableФильтр_отец" msprop:Generator_TablePropName="Фильтр_отец" msprop:Generator_RowDeletingName="Фильтр_отецRowDeleting" msprop:Generator_RowChangingName="Фильтр_отецRowChanging" msprop:Generator_RowEvHandlerName="Фильтр_отецRowChangeEventHandler" msprop:Generator_RowDeletedName="Фильтр_отецRowDeleted" msprop:Generator_UserTableName="Фильтр отец" msprop:Generator_RowChangedName="Фильтр_отецRowChanged" msprop:Generator_RowEvArgName="Фильтр_отецRowChangeEvent" msprop:Generator_RowClassName="Фильтр_отецRow">
  1455. <xs:complexType>
  1456. <xs:sequence>
  1457. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  1458. <xs:simpleType>
  1459. <xs:restriction base="xs:string">
  1460. <xs:maxLength value="50" />
  1461. </xs:restriction>
  1462. </xs:simpleType>
  1463. </xs:element>
  1464. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  1465. <xs:simpleType>
  1466. <xs:restriction base="xs:string">
  1467. <xs:maxLength value="20" />
  1468. </xs:restriction>
  1469. </xs:simpleType>
  1470. </xs:element>
  1471. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  1472. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  1473. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  1474. <xs:simpleType>
  1475. <xs:restriction base="xs:string">
  1476. <xs:maxLength value="20" />
  1477. </xs:restriction>
  1478. </xs:simpleType>
  1479. </xs:element>
  1480. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  1481. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  1482. <xs:simpleType>
  1483. <xs:restriction base="xs:string">
  1484. <xs:maxLength value="15" />
  1485. </xs:restriction>
  1486. </xs:simpleType>
  1487. </xs:element>
  1488. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  1489. <xs:simpleType>
  1490. <xs:restriction base="xs:string">
  1491. <xs:maxLength value="2147483647" />
  1492. </xs:restriction>
  1493. </xs:simpleType>
  1494. </xs:element>
  1495. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  1496. <xs:simpleType>
  1497. <xs:restriction base="xs:string">
  1498. <xs:maxLength value="2147483647" />
  1499. </xs:restriction>
  1500. </xs:simpleType>
  1501. </xs:element>
  1502. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  1503. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  1504. <xs:simpleType>
  1505. <xs:restriction base="xs:string">
  1506. <xs:maxLength value="50" />
  1507. </xs:restriction>
  1508. </xs:simpleType>
  1509. </xs:element>
  1510. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  1511. <xs:simpleType>
  1512. <xs:restriction base="xs:string">
  1513. <xs:maxLength value="20" />
  1514. </xs:restriction>
  1515. </xs:simpleType>
  1516. </xs:element>
  1517. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  1518. <xs:simpleType>
  1519. <xs:restriction base="xs:string">
  1520. <xs:maxLength value="2147483647" />
  1521. </xs:restriction>
  1522. </xs:simpleType>
  1523. </xs:element>
  1524. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  1525. <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
  1526. <xs:simpleType>
  1527. <xs:restriction base="xs:string">
  1528. <xs:maxLength value="50" />
  1529. </xs:restriction>
  1530. </xs:simpleType>
  1531. </xs:element>
  1532. </xs:sequence>
  1533. </xs:complexType>
  1534. </xs:element>
  1535. <xs:element name="Фильтр_x0020_отец_x0020_и_x0020_мать" msprop:Generator_TableClassName="Фильтр_отец_и_матьDataTable" msprop:Generator_TableVarName="tableФильтр_отец_и_мать" msprop:Generator_TablePropName="Фильтр_отец_и_мать" msprop:Generator_RowDeletingName="Фильтр_отец_и_матьRowDeleting" msprop:Generator_RowChangingName="Фильтр_отец_и_матьRowChanging" msprop:Generator_RowEvHandlerName="Фильтр_отец_и_матьRowChangeEventHandler" msprop:Generator_RowDeletedName="Фильтр_отец_и_матьRowDeleted" msprop:Generator_UserTableName="Фильтр отец и мать" msprop:Generator_RowChangedName="Фильтр_отец_и_матьRowChanged" msprop:Generator_RowEvArgName="Фильтр_отец_и_матьRowChangeEvent" msprop:Generator_RowClassName="Фильтр_отец_и_матьRow">
  1536. <xs:complexType>
  1537. <xs:sequence>
  1538. <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
  1539. <xs:simpleType>
  1540. <xs:restriction base="xs:string">
  1541. <xs:maxLength value="50" />
  1542. </xs:restriction>
  1543. </xs:simpleType>
  1544. </xs:element>
  1545. <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
  1546. <xs:simpleType>
  1547. <xs:restriction base="xs:string">
  1548. <xs:maxLength value="20" />
  1549. </xs:restriction>
  1550. </xs:simpleType>
  1551. </xs:element>
  1552. <xs:element name="ochnay_x0020_forma_x0020_obycheniya_x005D_" msprop:Generator_ColumnVarNameInTable="_columnochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInRow="_ochnay_forma_obycheniya_" msprop:Generator_ColumnPropNameInTable="_ochnay_forma_obycheniya_Column" msprop:Generator_UserColumnName="ochnay forma obycheniya]" type="xs:boolean" minOccurs="0" />
  1553. <xs:element name="Kypc" msprop:Generator_ColumnVarNameInTable="columnKypc" msprop:Generator_ColumnPropNameInRow="Kypc" msprop:Generator_ColumnPropNameInTable="KypcColumn" msprop:Generator_UserColumnName="Kypc" type="xs:unsignedByte" minOccurs="0" />
  1554. <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
  1555. <xs:simpleType>
  1556. <xs:restriction base="xs:string">
  1557. <xs:maxLength value="20" />
  1558. </xs:restriction>
  1559. </xs:simpleType>
  1560. </xs:element>
  1561. <xs:element name="Data_postypleniya" msprop:Generator_ColumnVarNameInTable="columnData_postypleniya" msprop:Generator_ColumnPropNameInRow="Data_postypleniya" msprop:Generator_ColumnPropNameInTable="Data_postypleniyaColumn" msprop:Generator_UserColumnName="Data_postypleniya" type="xs:dateTime" minOccurs="0" />
  1562. <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
  1563. <xs:simpleType>
  1564. <xs:restriction base="xs:string">
  1565. <xs:maxLength value="15" />
  1566. </xs:restriction>
  1567. </xs:simpleType>
  1568. </xs:element>
  1569. <xs:element name="Pasportnie_dannie" msprop:Generator_ColumnVarNameInTable="columnPasportnie_dannie" msprop:Generator_ColumnPropNameInRow="Pasportnie_dannie" msprop:Generator_ColumnPropNameInTable="Pasportnie_dannieColumn" msprop:Generator_UserColumnName="Pasportnie_dannie" minOccurs="0">
  1570. <xs:simpleType>
  1571. <xs:restriction base="xs:string">
  1572. <xs:maxLength value="2147483647" />
  1573. </xs:restriction>
  1574. </xs:simpleType>
  1575. </xs:element>
  1576. <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
  1577. <xs:simpleType>
  1578. <xs:restriction base="xs:string">
  1579. <xs:maxLength value="2147483647" />
  1580. </xs:restriction>
  1581. </xs:simpleType>
  1582. </xs:element>
  1583. <xs:element name="Data_pojdeniya" msprop:Generator_ColumnVarNameInTable="columnData_pojdeniya" msprop:Generator_ColumnPropNameInRow="Data_pojdeniya" msprop:Generator_ColumnPropNameInTable="Data_pojdeniyaColumn" msprop:Generator_UserColumnName="Data_pojdeniya" type="xs:dateTime" minOccurs="0" />
  1584. <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
  1585. <xs:simpleType>
  1586. <xs:restriction base="xs:string">
  1587. <xs:maxLength value="50" />
  1588. </xs:restriction>
  1589. </xs:simpleType>
  1590. </xs:element>
  1591. <xs:element name="Nazvanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnNazvanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Nazvanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Nazvanie_specialnostiColumn" msprop:Generator_UserColumnName="Nazvanie_specialnosti" minOccurs="0">
  1592. <xs:simpleType>
  1593. <xs:restriction base="xs:string">
  1594. <xs:maxLength value="20" />
  1595. </xs:restriction>
  1596. </xs:simpleType>
  1597. </xs:element>
  1598. <xs:element name="Opisanie_specialnosti" msprop:Generator_ColumnVarNameInTable="columnOpisanie_specialnosti" msprop:Generator_ColumnPropNameInRow="Opisanie_specialnosti" msprop:Generator_ColumnPropNameInTable="Opisanie_specialnostiColumn" msprop:Generator_UserColumnName="Opisanie_specialnosti" minOccurs="0">
  1599. <xs:simpleType>
  1600. <xs:restriction base="xs:string">
  1601. <xs:maxLength value="2147483647" />
  1602. </xs:restriction>
  1603. </xs:simpleType>
  1604. </xs:element>
  1605. <xs:element name="Nomer_zachetki" msprop:Generator_ColumnVarNameInTable="columnNomer_zachetki" msprop:Generator_ColumnPropNameInRow="Nomer_zachetki" msprop:Generator_ColumnPropNameInTable="Nomer_zachetkiColumn" msprop:Generator_UserColumnName="Nomer_zachetki" type="xs:long" minOccurs="0" />
  1606. <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
  1607. <xs:simpleType>
  1608. <xs:restriction base="xs:string">
  1609. <xs:maxLength value="50" />
  1610. </xs:restriction>
  1611. </xs:simpleType>
  1612. </xs:element>
  1613. </xs:sequence>
  1614. </xs:complexType>
  1615. </xs:element>
  1616. </xs:choice>
  1617. </xs:complexType>
  1618. <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  1619. <xs:selector xpath=".//mstns:Ocenka" />
  1620. <xs:field xpath="mstns:ID_studenta" />
  1621. </xs:unique>
  1622. <xs:unique name="Predmet_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  1623. <xs:selector xpath=".//mstns:Predmet" />
  1624. <xs:field xpath="mstns:ID_predmeta" />
  1625. </xs:unique>
  1626. <xs:unique name="Specialnost_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  1627. <xs:selector xpath=".//mstns:Specialnost" />
  1628. <xs:field xpath="mstns:ID_specialnosti" />
  1629. </xs:unique>
  1630. <xs:unique name="Student_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  1631. <xs:selector xpath=".//mstns:Student" />
  1632. <xs:field xpath="mstns:ID_studenta" />
  1633. </xs:unique>
  1634. </xs:element>
  1635. <xs:annotation>
  1636. <xs:appinfo>
  1637. <msdata:Relationship name="FK_Ocenka_Student" msdata:parent="Student" msdata:child="Ocenka" msdata:parentkey="ID_studenta" msdata:childkey="ID_studenta" msprop:Generator_UserChildTable="Ocenka" msprop:Generator_ChildPropName="GetOcenkaRows" msprop:Generator_UserRelationName="FK_Ocenka_Student" msprop:Generator_RelationVarName="relationFK_Ocenka_Student" msprop:Generator_UserParentTable="Student" msprop:Generator_ParentPropName="StudentRow" />
  1638. <msdata:Relationship name="FK_Student_Specialnost" msdata:parent="Specialnost" msdata:child="Student" msdata:parentkey="ID_specialnosti" msdata:childkey="ID_sresialnostu" msprop:Generator_UserChildTable="Student" msprop:Generator_ChildPropName="GetStudentRows" msprop:Generator_UserRelationName="FK_Student_Specialnost" msprop:Generator_ParentPropName="SpecialnostRow" msprop:Generator_RelationVarName="relationFK_Student_Specialnost" msprop:Generator_UserParentTable="Specialnost" />
  1639. </xs:appinfo>
  1640. </xs:annotation>
  1641. </xs:schema>