123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641 |
- <?xml version="1.0" encoding="utf-8"?>
- <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">
- <xs:annotation>
- <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
- <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
- <Connections>
- <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="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" />
- </Connections>
- <Tables>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OcenkaTableAdapter" GeneratorDataComponentClassName="OcenkaTableAdapter" Name="Ocenka" UserDataComponentName="OcenkaTableAdapter">
- <MainSource>
- <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">
- <DeleteCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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);
- 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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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)));
- 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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID_studenta" DataSetColumn="ID_studenta" />
- <Mapping SourceColumn="Data_ikzamena1" DataSetColumn="Data_ikzamena1" />
- <Mapping SourceColumn="ID_predmeta1" DataSetColumn="ID_predmeta1" />
- <Mapping SourceColumn="Ocenka1" DataSetColumn="Ocenka1" />
- <Mapping SourceColumn="Data_ikzamena2" DataSetColumn="Data_ikzamena2" />
- <Mapping SourceColumn="ID_predmeta2" DataSetColumn="ID_predmeta2" />
- <Mapping SourceColumn="Ocenka2" DataSetColumn="Ocenka2" />
- <Mapping SourceColumn="Data_ikzamena3" DataSetColumn="Data_ikzamena3" />
- <Mapping SourceColumn="ID_predmeta3" DataSetColumn="ID_predmeta3" />
- <Mapping SourceColumn="Ocenka3" DataSetColumn="Ocenka3" />
- <Mapping SourceColumn="Srednii_ball" DataSetColumn="Srednii_ball" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PredmetTableAdapter" GeneratorDataComponentClassName="PredmetTableAdapter" Name="Predmet" UserDataComponentName="PredmetTableAdapter">
- <MainSource>
- <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">
- <DeleteCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[Predmet] ([Nazvanie_predmeta], [Opisanie_predmeta]) VALUES (@Nazvanie_predmeta, @Opisanie_predmeta);
- SELECT ID_predmeta, Nazvanie_predmeta, Opisanie_predmeta FROM Predmet WHERE (ID_predmeta = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID_predmeta, Nazvanie_predmeta, Opisanie_predmeta FROM dbo.Predmet</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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)));
- SELECT ID_predmeta, Nazvanie_predmeta, Opisanie_predmeta FROM Predmet WHERE (ID_predmeta = @ID_predmeta)</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID_predmeta" DataSetColumn="ID_predmeta" />
- <Mapping SourceColumn="Nazvanie_predmeta" DataSetColumn="Nazvanie_predmeta" />
- <Mapping SourceColumn="Opisanie_predmeta" DataSetColumn="Opisanie_predmeta" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SpecialnostTableAdapter" GeneratorDataComponentClassName="SpecialnostTableAdapter" Name="Specialnost" UserDataComponentName="SpecialnostTableAdapter">
- <MainSource>
- <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">
- <DeleteCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[Specialnost] ([Nazvanie_specialnosti], [Opisanie_specialnosti]) VALUES (@Nazvanie_specialnosti, @Opisanie_specialnosti);
- SELECT ID_specialnosti, Nazvanie_specialnosti, Opisanie_specialnosti FROM Specialnost WHERE (ID_specialnosti = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID_specialnosti, Nazvanie_specialnosti, Opisanie_specialnosti FROM dbo.Specialnost</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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)));
- SELECT ID_specialnosti, Nazvanie_specialnosti, Opisanie_specialnosti FROM Specialnost WHERE (ID_specialnosti = @ID_specialnosti)</CommandText>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID_specialnosti" DataSetColumn="ID_specialnosti" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StudentTableAdapter" GeneratorDataComponentClassName="StudentTableAdapter" Name="Student" UserDataComponentName="StudentTableAdapter">
- <MainSource>
- <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">
- <DeleteCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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);
- 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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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)));
- 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>
- <Parameters>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID_studenta" DataSetColumn="ID_studenta" />
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="ID_sresialnostu" DataSetColumn="ID_sresialnostu" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="View_1TableAdapter" GeneratorDataComponentClassName="View_1TableAdapter" Name="View_1" UserDataComponentName="View_1TableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Запрос Студент+специальностьTableAdapter" GeneratorDataComponentClassName="Запрос_Студент_специальностьTableAdapter" Name="Запрос Студент+специальность" UserDataComponentName="Запрос Студент+специальностьTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Запрос студенты+оценкиTableAdapter" GeneratorDataComponentClassName="Запрос_студенты_оценкиTableAdapter" Name="Запрос студенты+оценки" UserDataComponentName="Запрос студенты+оценкиTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT FIO, Data_ikzamena1, Ocenka1, Data_ikzamena2, Ocenka2, Data_ikzamena3, Ocenka3, Srednii_ball, Nazvanie_predmeta, Expr1, Expr2 FROM dbo.[Запрос студенты+оценки]</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="Data_ikzamena1" DataSetColumn="Data_ikzamena1" />
- <Mapping SourceColumn="Ocenka1" DataSetColumn="Ocenka1" />
- <Mapping SourceColumn="Data_ikzamena2" DataSetColumn="Data_ikzamena2" />
- <Mapping SourceColumn="Ocenka2" DataSetColumn="Ocenka2" />
- <Mapping SourceColumn="Data_ikzamena3" DataSetColumn="Data_ikzamena3" />
- <Mapping SourceColumn="Ocenka3" DataSetColumn="Ocenka3" />
- <Mapping SourceColumn="Srednii_ball" DataSetColumn="Srednii_ball" />
- <Mapping SourceColumn="Nazvanie_predmeta" DataSetColumn="Nazvanie_predmeta" />
- <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
- <Mapping SourceColumn="Expr2" DataSetColumn="Expr2" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр BYTableAdapter" GeneratorDataComponentClassName="Фильтр_BYTableAdapter" Name="Фильтр BY" UserDataComponentName="Фильтр BYTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр MOTableAdapter" GeneratorDataComponentClassName="Фильтр_MOTableAdapter" Name="Фильтр MO" UserDataComponentName="Фильтр MOTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр PITableAdapter" GeneratorDataComponentClassName="Фильтр_PITableAdapter" Name="Фильтр PI" UserDataComponentName="Фильтр PITableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр STTableAdapter" GeneratorDataComponentClassName="Фильтр_STTableAdapter" Name="Фильтр ST" UserDataComponentName="Фильтр STTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр матьTableAdapter" GeneratorDataComponentClassName="Фильтр_матьTableAdapter" Name="Фильтр мать" UserDataComponentName="Фильтр матьTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="фильтр ММTableAdapter" GeneratorDataComponentClassName="фильтр_ММTableAdapter" Name="фильтр ММ" UserDataComponentName="фильтр ММTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр отецTableAdapter" GeneratorDataComponentClassName="Фильтр_отецTableAdapter" Name="Фильтр отец" UserDataComponentName="Фильтр отецTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Фильтр отец и матьTableAdapter" GeneratorDataComponentClassName="Фильтр_отец_и_матьTableAdapter" Name="Фильтр отец и мать" UserDataComponentName="Фильтр отец и матьTableAdapter">
- <MainSource>
- <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">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <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>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
- <Mapping SourceColumn="pol" DataSetColumn="pol" />
- <Mapping SourceColumn="ochnay forma obycheniya]" DataSetColumn="ochnay forma obycheniya]" />
- <Mapping SourceColumn="Kypc" DataSetColumn="Kypc" />
- <Mapping SourceColumn="Gryppa" DataSetColumn="Gryppa" />
- <Mapping SourceColumn="Data_postypleniya" DataSetColumn="Data_postypleniya" />
- <Mapping SourceColumn="telephone" DataSetColumn="telephone" />
- <Mapping SourceColumn="Pasportnie_dannie" DataSetColumn="Pasportnie_dannie" />
- <Mapping SourceColumn="adres" DataSetColumn="adres" />
- <Mapping SourceColumn="Data_pojdeniya" DataSetColumn="Data_pojdeniya" />
- <Mapping SourceColumn="roditeli" DataSetColumn="roditeli" />
- <Mapping SourceColumn="Nazvanie_specialnosti" DataSetColumn="Nazvanie_specialnosti" />
- <Mapping SourceColumn="Opisanie_specialnosti" DataSetColumn="Opisanie_specialnosti" />
- <Mapping SourceColumn="Nomer_zachetki" DataSetColumn="Nomer_zachetki" />
- <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
- </Mappings>
- <Sources />
- </TableAdapter>
- </Tables>
- <Sources />
- </DataSource>
- </xs:appinfo>
- </xs:annotation>
- <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">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <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">
- <xs:complexType>
- <xs:sequence>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="90" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <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" />
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="90" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="90" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Expr2" msprop:Generator_ColumnVarNameInTable="columnExpr2" msprop:Generator_ColumnPropNameInRow="Expr2" msprop:Generator_ColumnPropNameInTable="Expr2Column" msprop:Generator_UserColumnName="Expr2" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="90" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="Фильтр_x0020_мать" msprop:Generator_TableClassName="Фильтр_матьDataTable" msprop:Generator_TableVarName="tableФильтр_мать" msprop:Generator_TablePropName="Фильтр_мать" msprop:Generator_RowDeletingName="Фильтр_матьRowDeleting" msprop:Generator_RowChangingName="Фильтр_матьRowChanging" msprop:Generator_RowEvHandlerName="Фильтр_матьRowChangeEventHandler" msprop:Generator_RowDeletedName="Фильтр_матьRowDeleted" msprop:Generator_UserTableName="Фильтр мать" msprop:Generator_RowChangedName="Фильтр_матьRowChanged" msprop:Generator_RowEvArgName="Фильтр_матьRowChangeEvent" msprop:Generator_RowClassName="Фильтр_матьRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="фильтр_x0020_ММ" msprop:Generator_TableClassName="фильтр_ММDataTable" msprop:Generator_TableVarName="tableфильтр_ММ" msprop:Generator_TablePropName="фильтр_ММ" msprop:Generator_RowDeletingName="фильтр_ММRowDeleting" msprop:Generator_RowChangingName="фильтр_ММRowChanging" msprop:Generator_RowEvHandlerName="фильтр_ММRowChangeEventHandler" msprop:Generator_RowDeletedName="фильтр_ММRowDeleted" msprop:Generator_UserTableName="фильтр ММ" msprop:Generator_RowChangedName="фильтр_ММRowChanged" msprop:Generator_RowEvArgName="фильтр_ММRowChangeEvent" msprop:Generator_RowClassName="фильтр_ММRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <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">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="Фильтр_x0020_отец_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">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="pol" msprop:Generator_ColumnVarNameInTable="columnpol" msprop:Generator_ColumnPropNameInRow="pol" msprop:Generator_ColumnPropNameInTable="polColumn" msprop:Generator_UserColumnName="pol">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <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" />
- <xs:element name="Gryppa" msprop:Generator_ColumnVarNameInTable="columnGryppa" msprop:Generator_ColumnPropNameInRow="Gryppa" msprop:Generator_ColumnPropNameInTable="GryppaColumn" msprop:Generator_UserColumnName="Gryppa" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="telephone" msprop:Generator_ColumnVarNameInTable="columntelephone" msprop:Generator_ColumnPropNameInRow="telephone" msprop:Generator_ColumnPropNameInTable="telephoneColumn" msprop:Generator_UserColumnName="telephone" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="15" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="roditeli" msprop:Generator_ColumnVarNameInTable="columnroditeli" msprop:Generator_ColumnPropNameInRow="roditeli" msprop:Generator_ColumnPropNameInTable="roditeliColumn" msprop:Generator_UserColumnName="roditeli" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <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" />
- <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:complexType>
- <xs:unique name="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Ocenka" />
- <xs:field xpath="mstns:ID_studenta" />
- </xs:unique>
- <xs:unique name="Predmet_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Predmet" />
- <xs:field xpath="mstns:ID_predmeta" />
- </xs:unique>
- <xs:unique name="Specialnost_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Specialnost" />
- <xs:field xpath="mstns:ID_specialnosti" />
- </xs:unique>
- <xs:unique name="Student_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Student" />
- <xs:field xpath="mstns:ID_studenta" />
- </xs:unique>
- </xs:element>
- <xs:annotation>
- <xs:appinfo>
- <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" />
- <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" />
- </xs:appinfo>
- </xs:annotation>
- </xs:schema>
|