1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453 |
- <?xml version="1.0" encoding="utf-8"?>
- <xs:schema id="TestWSR4DataSet" targetNamespace="http://tempuri.org/TestWSR4DataSet.xsd" xmlns:mstns="http://tempuri.org/TestWSR4DataSet.xsd" xmlns="http://tempuri.org/TestWSR4DataSet.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="TestWSR4ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TestWSR4ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TestWSR4.Properties.Settings.GlobalReference.Default.TestWSR4ConnectionString" Provider="System.Data.SqlClient" />
- </Connections>
- <Tables>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AgentTableAdapter" GeneratorDataComponentClassName="AgentTableAdapter" Name="Agent" UserDataComponentName="AgentTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.Agent" 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].[Agent] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([AgentTypeID] = @Original_AgentTypeID) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ([INN] = @Original_INN) AND ((@IsNull_KPP = 1 AND [KPP] IS NULL) OR ([KPP] = @Original_KPP)) AND ((@IsNull_DirectorName = 1 AND [DirectorName] IS NULL) OR ([DirectorName] = @Original_DirectorName)) AND ([Phone] = @Original_Phone) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Logo = 1 AND [Logo] IS NULL) OR ([Logo] = @Original_Logo)) AND ([Priority] = @Original_Priority))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AgentTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KPP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KPP" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_KPP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KPP" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DirectorName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DirectorName" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DirectorName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DirectorName" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Logo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Logo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[Agent] ([Title], [AgentTypeID], [Address], [INN], [KPP], [DirectorName], [Phone], [Email], [Logo], [Priority]) VALUES (@Title, @AgentTypeID, @Address, @INN, @KPP, @DirectorName, @Phone, @Email, @Logo, @Priority);
- SELECT ID, Title, AgentTypeID, Address, INN, KPP, DirectorName, Phone, Email, Logo, Priority FROM Agent WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KPP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KPP" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DirectorName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DirectorName" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Logo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Title, AgentTypeID, Address, INN, KPP, DirectorName, Phone, Email, Logo, Priority FROM dbo.Agent</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[Agent] SET [Title] = @Title, [AgentTypeID] = @AgentTypeID, [Address] = @Address, [INN] = @INN, [KPP] = @KPP, [DirectorName] = @DirectorName, [Phone] = @Phone, [Email] = @Email, [Logo] = @Logo, [Priority] = @Priority WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([AgentTypeID] = @Original_AgentTypeID) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ([INN] = @Original_INN) AND ((@IsNull_KPP = 1 AND [KPP] IS NULL) OR ([KPP] = @Original_KPP)) AND ((@IsNull_DirectorName = 1 AND [DirectorName] IS NULL) OR ([DirectorName] = @Original_DirectorName)) AND ([Phone] = @Original_Phone) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Logo = 1 AND [Logo] IS NULL) OR ([Logo] = @Original_Logo)) AND ([Priority] = @Original_Priority));
- SELECT ID, Title, AgentTypeID, Address, INN, KPP, DirectorName, Phone, Email, Logo, Priority FROM Agent WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KPP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KPP" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DirectorName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DirectorName" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Logo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AgentTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KPP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KPP" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_KPP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="KPP" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DirectorName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DirectorName" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DirectorName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DirectorName" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Logo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Logo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.Agent" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Title" DataSetColumn="Title" />
- <Mapping SourceColumn="AgentTypeID" DataSetColumn="AgentTypeID" />
- <Mapping SourceColumn="Address" DataSetColumn="Address" />
- <Mapping SourceColumn="INN" DataSetColumn="INN" />
- <Mapping SourceColumn="KPP" DataSetColumn="KPP" />
- <Mapping SourceColumn="DirectorName" DataSetColumn="DirectorName" />
- <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
- <Mapping SourceColumn="Email" DataSetColumn="Email" />
- <Mapping SourceColumn="Logo" DataSetColumn="Logo" />
- <Mapping SourceColumn="Priority" DataSetColumn="Priority" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AgentPriorityHistoryTableAdapter" GeneratorDataComponentClassName="AgentPriorityHistoryTableAdapter" Name="AgentPriorityHistory" UserDataComponentName="AgentPriorityHistoryTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.AgentPriorityHistory" 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].[AgentPriorityHistory] WHERE (([ID] = @Original_ID) AND ([AgentID] = @Original_AgentID) AND ([ChangeDate] = @Original_ChangeDate) AND ([PriorityValue] = @Original_PriorityValue))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PriorityValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PriorityValue" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[AgentPriorityHistory] ([AgentID], [ChangeDate], [PriorityValue]) VALUES (@AgentID, @ChangeDate, @PriorityValue);
- SELECT ID, AgentID, ChangeDate, PriorityValue FROM AgentPriorityHistory WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PriorityValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PriorityValue" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, AgentID, ChangeDate, PriorityValue FROM dbo.AgentPriorityHistory</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[AgentPriorityHistory] SET [AgentID] = @AgentID, [ChangeDate] = @ChangeDate, [PriorityValue] = @PriorityValue WHERE (([ID] = @Original_ID) AND ([AgentID] = @Original_AgentID) AND ([ChangeDate] = @Original_ChangeDate) AND ([PriorityValue] = @Original_PriorityValue));
- SELECT ID, AgentID, ChangeDate, PriorityValue FROM AgentPriorityHistory WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PriorityValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PriorityValue" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PriorityValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PriorityValue" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.AgentPriorityHistory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="AgentID" DataSetColumn="AgentID" />
- <Mapping SourceColumn="ChangeDate" DataSetColumn="ChangeDate" />
- <Mapping SourceColumn="PriorityValue" DataSetColumn="PriorityValue" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AgentTypeTableAdapter" GeneratorDataComponentClassName="AgentTypeTableAdapter" Name="AgentType" UserDataComponentName="AgentTypeTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.AgentType" 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].[AgentType] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[AgentType] ([Title], [Image]) VALUES (@Title, @Image);
- SELECT ID, Title, Image FROM AgentType WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Title, Image FROM dbo.AgentType</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[AgentType] SET [Title] = @Title, [Image] = @Image WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)));
- SELECT ID, Title, Image FROM AgentType WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.AgentType" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Title" DataSetColumn="Title" />
- <Mapping SourceColumn="Image" DataSetColumn="Image" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MaterialTableAdapter" GeneratorDataComponentClassName="MaterialTableAdapter" Name="Material" UserDataComponentName="MaterialTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.Material" 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].[Material] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([CountInPack] = @Original_CountInPack) AND ([Unit] = @Original_Unit) AND ((@IsNull_CountInStock = 1 AND [CountInStock] IS NULL) OR ([CountInStock] = @Original_CountInStock)) AND ([MinCount] = @Original_MinCount) AND ([Cost] = @Original_Cost) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)) AND ([MaterialTypeID] = @Original_MaterialTypeID))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountInPack" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountInPack" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountInStock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountInStock" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CountInStock" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CountInStock" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_MinCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MinCount" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cost" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaterialTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[Material] ([Title], [CountInPack], [Unit], [CountInStock], [MinCount], [Description], [Cost], [Image], [MaterialTypeID]) VALUES (@Title, @CountInPack, @Unit, @CountInStock, @MinCount, @Description, @Cost, @Image, @MaterialTypeID);
- SELECT ID, Title, CountInPack, Unit, CountInStock, MinCount, Description, Cost, Image, MaterialTypeID FROM Material WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountInPack" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountInPack" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CountInStock" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CountInStock" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@MinCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MinCount" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaterialTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Title, CountInPack, Unit, CountInStock, MinCount, Description, Cost, Image, MaterialTypeID FROM dbo.Material</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[Material] SET [Title] = @Title, [CountInPack] = @CountInPack, [Unit] = @Unit, [CountInStock] = @CountInStock, [MinCount] = @MinCount, [Description] = @Description, [Cost] = @Cost, [Image] = @Image, [MaterialTypeID] = @MaterialTypeID WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([CountInPack] = @Original_CountInPack) AND ([Unit] = @Original_Unit) AND ((@IsNull_CountInStock = 1 AND [CountInStock] IS NULL) OR ([CountInStock] = @Original_CountInStock)) AND ([MinCount] = @Original_MinCount) AND ([Cost] = @Original_Cost) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)) AND ([MaterialTypeID] = @Original_MaterialTypeID));
- SELECT ID, Title, CountInPack, Unit, CountInStock, MinCount, Description, Cost, Image, MaterialTypeID FROM Material WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountInPack" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountInPack" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CountInStock" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CountInStock" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@MinCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MinCount" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaterialTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountInPack" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountInPack" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountInStock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountInStock" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CountInStock" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CountInStock" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_MinCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MinCount" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cost" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaterialTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.Material" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Title" DataSetColumn="Title" />
- <Mapping SourceColumn="CountInPack" DataSetColumn="CountInPack" />
- <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
- <Mapping SourceColumn="CountInStock" DataSetColumn="CountInStock" />
- <Mapping SourceColumn="MinCount" DataSetColumn="MinCount" />
- <Mapping SourceColumn="Description" DataSetColumn="Description" />
- <Mapping SourceColumn="Cost" DataSetColumn="Cost" />
- <Mapping SourceColumn="Image" DataSetColumn="Image" />
- <Mapping SourceColumn="MaterialTypeID" DataSetColumn="MaterialTypeID" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MaterialCountHistoryTableAdapter" GeneratorDataComponentClassName="MaterialCountHistoryTableAdapter" Name="MaterialCountHistory" UserDataComponentName="MaterialCountHistoryTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.MaterialCountHistory" 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].[MaterialCountHistory] WHERE (([ID] = @Original_ID) AND ([MaterialID] = @Original_MaterialID) AND ([ChangeDate] = @Original_ChangeDate) AND ([CountValue] = @Original_CountValue))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CountValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CountValue" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[MaterialCountHistory] ([MaterialID], [ChangeDate], [CountValue]) VALUES (@MaterialID, @ChangeDate, @CountValue);
- SELECT ID, MaterialID, ChangeDate, CountValue FROM MaterialCountHistory WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CountValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CountValue" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, MaterialID, ChangeDate, CountValue FROM dbo.MaterialCountHistory</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[MaterialCountHistory] SET [MaterialID] = @MaterialID, [ChangeDate] = @ChangeDate, [CountValue] = @CountValue WHERE (([ID] = @Original_ID) AND ([MaterialID] = @Original_MaterialID) AND ([ChangeDate] = @Original_ChangeDate) AND ([CountValue] = @Original_CountValue));
- SELECT ID, MaterialID, ChangeDate, CountValue FROM MaterialCountHistory WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CountValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CountValue" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CountValue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CountValue" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.MaterialCountHistory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="MaterialID" DataSetColumn="MaterialID" />
- <Mapping SourceColumn="ChangeDate" DataSetColumn="ChangeDate" />
- <Mapping SourceColumn="CountValue" DataSetColumn="CountValue" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MaterialSupplierTableAdapter" GeneratorDataComponentClassName="MaterialSupplierTableAdapter" Name="MaterialSupplier" UserDataComponentName="MaterialSupplierTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.MaterialSupplier" 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].[MaterialSupplier] WHERE (([MaterialID] = @Original_MaterialID) AND ([SupplierID] = @Original_SupplierID))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SupplierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[MaterialSupplier] ([MaterialID], [SupplierID]) VALUES (@MaterialID, @SupplierID);
- SELECT MaterialID, SupplierID FROM MaterialSupplier WHERE (MaterialID = @MaterialID) AND (SupplierID = @SupplierID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SupplierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT MaterialID, SupplierID FROM dbo.MaterialSupplier</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[MaterialSupplier] SET [MaterialID] = @MaterialID, [SupplierID] = @SupplierID WHERE (([MaterialID] = @Original_MaterialID) AND ([SupplierID] = @Original_SupplierID));
- SELECT MaterialID, SupplierID FROM MaterialSupplier WHERE (MaterialID = @MaterialID) AND (SupplierID = @SupplierID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SupplierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SupplierID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="MaterialID" DataSetColumn="MaterialID" />
- <Mapping SourceColumn="SupplierID" DataSetColumn="SupplierID" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MaterialTypeTableAdapter" GeneratorDataComponentClassName="MaterialTypeTableAdapter" Name="MaterialType" UserDataComponentName="MaterialTypeTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.MaterialType" 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].[MaterialType] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_DefectedPercent = 1 AND [DefectedPercent] IS NULL) OR ([DefectedPercent] = @Original_DefectedPercent)))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DefectedPercent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DefectedPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[MaterialType] ([Title], [DefectedPercent]) VALUES (@Title, @DefectedPercent);
- SELECT ID, Title, DefectedPercent FROM MaterialType WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DefectedPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Title, DefectedPercent FROM dbo.MaterialType</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[MaterialType] SET [Title] = @Title, [DefectedPercent] = @DefectedPercent WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_DefectedPercent = 1 AND [DefectedPercent] IS NULL) OR ([DefectedPercent] = @Original_DefectedPercent)));
- SELECT ID, Title, DefectedPercent FROM MaterialType WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DefectedPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DefectedPercent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DefectedPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.MaterialType" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Title" DataSetColumn="Title" />
- <Mapping SourceColumn="DefectedPercent" DataSetColumn="DefectedPercent" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductTableAdapter" GeneratorDataComponentClassName="ProductTableAdapter" Name="Product" UserDataComponentName="ProductTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.Product" 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].[Product] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_ProductTypeID = 1 AND [ProductTypeID] IS NULL) OR ([ProductTypeID] = @Original_ProductTypeID)) AND ([ArticleNumber] = @Original_ArticleNumber) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)) AND ((@IsNull_ProductionPersonCount = 1 AND [ProductionPersonCount] IS NULL) OR ([ProductionPersonCount] = @Original_ProductionPersonCount)) AND ((@IsNull_ProductionWorkshopNumber = 1 AND [ProductionWorkshopNumber] IS NULL) OR ([ProductionWorkshopNumber] = @Original_ProductionWorkshopNumber)) AND ([MinCostForAgent] = @Original_MinCostForAgent))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ArticleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArticleNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductionPersonCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionPersonCount" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductionPersonCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionPersonCount" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductionWorkshopNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionWorkshopNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductionWorkshopNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionWorkshopNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_MinCostForAgent" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MinCostForAgent" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[Product] ([Title], [ProductTypeID], [ArticleNumber], [Description], [Image], [ProductionPersonCount], [ProductionWorkshopNumber], [MinCostForAgent]) VALUES (@Title, @ProductTypeID, @ArticleNumber, @Description, @Image, @ProductionPersonCount, @ProductionWorkshopNumber, @MinCostForAgent);
- SELECT ID, Title, ProductTypeID, ArticleNumber, Description, Image, ProductionPersonCount, ProductionWorkshopNumber, MinCostForAgent FROM Product WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArticleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArticleNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductionPersonCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionPersonCount" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductionWorkshopNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionWorkshopNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MinCostForAgent" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MinCostForAgent" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Title, ProductTypeID, ArticleNumber, Description, Image, ProductionPersonCount, ProductionWorkshopNumber, MinCostForAgent FROM dbo.Product</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[Product] SET [Title] = @Title, [ProductTypeID] = @ProductTypeID, [ArticleNumber] = @ArticleNumber, [Description] = @Description, [Image] = @Image, [ProductionPersonCount] = @ProductionPersonCount, [ProductionWorkshopNumber] = @ProductionWorkshopNumber, [MinCostForAgent] = @MinCostForAgent WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_ProductTypeID = 1 AND [ProductTypeID] IS NULL) OR ([ProductTypeID] = @Original_ProductTypeID)) AND ([ArticleNumber] = @Original_ArticleNumber) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)) AND ((@IsNull_ProductionPersonCount = 1 AND [ProductionPersonCount] IS NULL) OR ([ProductionPersonCount] = @Original_ProductionPersonCount)) AND ((@IsNull_ProductionWorkshopNumber = 1 AND [ProductionWorkshopNumber] IS NULL) OR ([ProductionWorkshopNumber] = @Original_ProductionWorkshopNumber)) AND ([MinCostForAgent] = @Original_MinCostForAgent));
- SELECT ID, Title, ProductTypeID, ArticleNumber, Description, Image, ProductionPersonCount, ProductionWorkshopNumber, MinCostForAgent FROM Product WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ArticleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArticleNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductionPersonCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionPersonCount" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductionWorkshopNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionWorkshopNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MinCostForAgent" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MinCostForAgent" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ArticleNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ArticleNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductionPersonCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionPersonCount" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductionPersonCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionPersonCount" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductionWorkshopNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionWorkshopNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductionWorkshopNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductionWorkshopNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_MinCostForAgent" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MinCostForAgent" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.Product" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Title" DataSetColumn="Title" />
- <Mapping SourceColumn="ProductTypeID" DataSetColumn="ProductTypeID" />
- <Mapping SourceColumn="ArticleNumber" DataSetColumn="ArticleNumber" />
- <Mapping SourceColumn="Description" DataSetColumn="Description" />
- <Mapping SourceColumn="Image" DataSetColumn="Image" />
- <Mapping SourceColumn="ProductionPersonCount" DataSetColumn="ProductionPersonCount" />
- <Mapping SourceColumn="ProductionWorkshopNumber" DataSetColumn="ProductionWorkshopNumber" />
- <Mapping SourceColumn="MinCostForAgent" DataSetColumn="MinCostForAgent" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductCostHistoryTableAdapter" GeneratorDataComponentClassName="ProductCostHistoryTableAdapter" Name="ProductCostHistory" UserDataComponentName="ProductCostHistoryTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.ProductCostHistory" 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].[ProductCostHistory] WHERE (([ID] = @Original_ID) AND ([ProductID] = @Original_ProductID) AND ([ChangeDate] = @Original_ChangeDate) AND ([CostValue] = @Original_CostValue))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CostValue" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostValue" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[ProductCostHistory] ([ProductID], [ChangeDate], [CostValue]) VALUES (@ProductID, @ChangeDate, @CostValue);
- SELECT ID, ProductID, ChangeDate, CostValue FROM ProductCostHistory WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostValue" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostValue" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, ProductID, ChangeDate, CostValue FROM dbo.ProductCostHistory</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[ProductCostHistory] SET [ProductID] = @ProductID, [ChangeDate] = @ChangeDate, [CostValue] = @CostValue WHERE (([ID] = @Original_ID) AND ([ProductID] = @Original_ProductID) AND ([ChangeDate] = @Original_ChangeDate) AND ([CostValue] = @Original_CostValue));
- SELECT ID, ProductID, ChangeDate, CostValue FROM ProductCostHistory WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostValue" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostValue" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ChangeDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ChangeDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CostValue" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="CostValue" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.ProductCostHistory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
- <Mapping SourceColumn="ChangeDate" DataSetColumn="ChangeDate" />
- <Mapping SourceColumn="CostValue" DataSetColumn="CostValue" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductMaterialTableAdapter" GeneratorDataComponentClassName="ProductMaterialTableAdapter" Name="ProductMaterial" UserDataComponentName="ProductMaterialTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.ProductMaterial" 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].[ProductMaterial] WHERE (([ProductID] = @Original_ProductID) AND ([MaterialID] = @Original_MaterialID) AND ((@IsNull_Count = 1 AND [Count] IS NULL) OR ([Count] = @Original_Count)))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Count" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[ProductMaterial] ([ProductID], [MaterialID], [Count]) VALUES (@ProductID, @MaterialID, @Count);
- SELECT ProductID, MaterialID, Count FROM ProductMaterial WHERE (MaterialID = @MaterialID) AND (ProductID = @ProductID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ProductID, MaterialID, Count FROM dbo.ProductMaterial</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[ProductMaterial] SET [ProductID] = @ProductID, [MaterialID] = @MaterialID, [Count] = @Count WHERE (([ProductID] = @Original_ProductID) AND ([MaterialID] = @Original_MaterialID) AND ((@IsNull_Count = 1 AND [Count] IS NULL) OR ([Count] = @Original_Count)));
- SELECT ProductID, MaterialID, Count FROM ProductMaterial WHERE (MaterialID = @MaterialID) AND (ProductID = @ProductID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MaterialID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaterialID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Count" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
- <Mapping SourceColumn="MaterialID" DataSetColumn="MaterialID" />
- <Mapping SourceColumn="Count" DataSetColumn="Count" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductSaleTableAdapter" GeneratorDataComponentClassName="ProductSaleTableAdapter" Name="ProductSale" UserDataComponentName="ProductSaleTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.ProductSale" 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].[ProductSale] WHERE (([ID] = @Original_ID) AND ([AgentID] = @Original_AgentID) AND ([ProductID] = @Original_ProductID) AND ([SaleDate] = @Original_SaleDate) AND ([ProductCount] = @Original_ProductCount))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_SaleDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SaleDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCount" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[ProductSale] ([AgentID], [ProductID], [SaleDate], [ProductCount]) VALUES (@AgentID, @ProductID, @SaleDate, @ProductCount);
- SELECT ID, AgentID, ProductID, SaleDate, ProductCount FROM ProductSale WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@SaleDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SaleDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCount" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, AgentID, ProductID, SaleDate, ProductCount FROM dbo.ProductSale</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[ProductSale] SET [AgentID] = @AgentID, [ProductID] = @ProductID, [SaleDate] = @SaleDate, [ProductCount] = @ProductCount WHERE (([ID] = @Original_ID) AND ([AgentID] = @Original_AgentID) AND ([ProductID] = @Original_ProductID) AND ([SaleDate] = @Original_SaleDate) AND ([ProductCount] = @Original_ProductCount));
- SELECT ID, AgentID, ProductID, SaleDate, ProductCount FROM ProductSale WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@SaleDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SaleDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCount" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_SaleDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="SaleDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductCount" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.ProductSale" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="AgentID" DataSetColumn="AgentID" />
- <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
- <Mapping SourceColumn="SaleDate" DataSetColumn="SaleDate" />
- <Mapping SourceColumn="ProductCount" DataSetColumn="ProductCount" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductTypeTableAdapter" GeneratorDataComponentClassName="ProductTypeTableAdapter" Name="ProductType" UserDataComponentName="ProductTypeTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.ProductType" 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].[ProductType] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_DefectedPercent = 1 AND [DefectedPercent] IS NULL) OR ([DefectedPercent] = @Original_DefectedPercent)))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DefectedPercent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DefectedPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[ProductType] ([Title], [DefectedPercent]) VALUES (@Title, @DefectedPercent);
- SELECT ID, Title, DefectedPercent FROM ProductType WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DefectedPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Title, DefectedPercent FROM dbo.ProductType</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[ProductType] SET [Title] = @Title, [DefectedPercent] = @DefectedPercent WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_DefectedPercent = 1 AND [DefectedPercent] IS NULL) OR ([DefectedPercent] = @Original_DefectedPercent)));
- SELECT ID, Title, DefectedPercent FROM ProductType WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DefectedPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DefectedPercent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DefectedPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectedPercent" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.ProductType" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Title" DataSetColumn="Title" />
- <Mapping SourceColumn="DefectedPercent" DataSetColumn="DefectedPercent" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ShopTableAdapter" GeneratorDataComponentClassName="ShopTableAdapter" Name="Shop" UserDataComponentName="ShopTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.Shop" 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].[Shop] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ([AgentID] = @Original_AgentID))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[Shop] ([Title], [Address], [AgentID]) VALUES (@Title, @Address, @AgentID);
- SELECT ID, Title, Address, AgentID FROM Shop WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Title, Address, AgentID FROM dbo.Shop</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[Shop] SET [Title] = @Title, [Address] = @Address, [AgentID] = @AgentID WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ([AgentID] = @Original_AgentID));
- SELECT ID, Title, Address, AgentID FROM Shop WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AgentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AgentID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.Shop" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Title" DataSetColumn="Title" />
- <Mapping SourceColumn="Address" DataSetColumn="Address" />
- <Mapping SourceColumn="AgentID" DataSetColumn="AgentID" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierTableAdapter" GeneratorDataComponentClassName="SupplierTableAdapter" Name="Supplier" UserDataComponentName="SupplierTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.Supplier" 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].[Supplier] WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([INN] = @Original_INN) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_QualityRating = 1 AND [QualityRating] IS NULL) OR ([QualityRating] = @Original_QualityRating)) AND ((@IsNull_SupplierType = 1 AND [SupplierType] IS NULL) OR ([SupplierType] = @Original_SupplierType)))</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QualityRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityRating" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QualityRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityRating" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SupplierType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierType" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SupplierType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SupplierType" SourceColumnNullMapping="false" SourceVersion="Original" />
- </Parameters>
- </DbCommand>
- </DeleteCommand>
- <InsertCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>INSERT INTO [dbo].[Supplier] ([Title], [INN], [StartDate], [QualityRating], [SupplierType]) VALUES (@Title, @INN, @StartDate, @QualityRating, @SupplierType);
- SELECT ID, Title, INN, StartDate, QualityRating, SupplierType FROM Supplier WHERE (ID = SCOPE_IDENTITY())</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QualityRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityRating" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SupplierType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SupplierType" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Title, INN, StartDate, QualityRating, SupplierType FROM dbo.Supplier</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- <UpdateCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>UPDATE [dbo].[Supplier] SET [Title] = @Title, [INN] = @INN, [StartDate] = @StartDate, [QualityRating] = @QualityRating, [SupplierType] = @SupplierType WHERE (([ID] = @Original_ID) AND ([Title] = @Original_Title) AND ([INN] = @Original_INN) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_QualityRating = 1 AND [QualityRating] IS NULL) OR ([QualityRating] = @Original_QualityRating)) AND ((@IsNull_SupplierType = 1 AND [SupplierType] IS NULL) OR ([SupplierType] = @Original_SupplierType)));
- SELECT ID, Title, INN, StartDate, QualityRating, SupplierType FROM Supplier WHERE (ID = @ID)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QualityRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityRating" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SupplierType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SupplierType" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QualityRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityRating" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QualityRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QualityRating" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SupplierType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SupplierType" SourceColumnNullMapping="true" SourceVersion="Original" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SupplierType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SupplierType" SourceColumnNullMapping="false" SourceVersion="Original" />
- <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="TestWSR4.dbo.Supplier" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </UpdateCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Title" DataSetColumn="Title" />
- <Mapping SourceColumn="INN" DataSetColumn="INN" />
- <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
- <Mapping SourceColumn="QualityRating" DataSetColumn="QualityRating" />
- <Mapping SourceColumn="SupplierType" DataSetColumn="SupplierType" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ItogSumProductTableAdapter" GeneratorDataComponentClassName="ItogSumProductTableAdapter" Name="ItogSumProduct" UserDataComponentName="ItogSumProductTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.ItogSumProduct" 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 Product, Cost, ID FROM dbo.ItogSumProduct</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="Product" DataSetColumn="Product" />
- <Mapping SourceColumn="Cost" DataSetColumn="Cost" />
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsPredTableAdapter" GeneratorDataComponentClassName="ProductsPredTableAdapter" Name="ProductsPred" UserDataComponentName="ProductsPredTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.ProductsPred" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Title, Type, Cost, ArticleNumber, ProductionPersonCount, ProductionWorkshopNumber, MinCostForAgent FROM dbo.ProductsPred</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Title" DataSetColumn="Title" />
- <Mapping SourceColumn="Type" DataSetColumn="Type" />
- <Mapping SourceColumn="Cost" DataSetColumn="Cost" />
- <Mapping SourceColumn="ArticleNumber" DataSetColumn="ArticleNumber" />
- <Mapping SourceColumn="ProductionPersonCount" DataSetColumn="ProductionPersonCount" />
- <Mapping SourceColumn="ProductionWorkshopNumber" DataSetColumn="ProductionWorkshopNumber" />
- <Mapping SourceColumn="MinCostForAgent" DataSetColumn="MinCostForAgent" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProizvProductTableAdapter" GeneratorDataComponentClassName="ProizvProductTableAdapter" Name="ProizvProduct" UserDataComponentName="ProizvProductTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="TestWSR4ConnectionString (Settings)" DbObjectName="TestWSR4.dbo.ProizvProduct" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT ID, Product, Material, Count, Cost, Proizv FROM dbo.ProizvProduct</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID" DataSetColumn="ID" />
- <Mapping SourceColumn="Product" DataSetColumn="Product" />
- <Mapping SourceColumn="Material" DataSetColumn="Material" />
- <Mapping SourceColumn="Count" DataSetColumn="Count" />
- <Mapping SourceColumn="Cost" DataSetColumn="Cost" />
- <Mapping SourceColumn="Proizv" DataSetColumn="Proizv" />
- </Mappings>
- <Sources />
- </TableAdapter>
- </Tables>
- <Sources />
- </DataSource>
- </xs:appinfo>
- </xs:annotation>
- <xs:element name="TestWSR4DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="TestWSR4DataSet" msprop:Generator_UserDSName="TestWSR4DataSet">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <xs:element name="Agent" msprop:Generator_TableClassName="AgentDataTable" msprop:Generator_TableVarName="tableAgent" msprop:Generator_TablePropName="Agent" msprop:Generator_RowDeletingName="AgentRowDeleting" msprop:Generator_RowChangingName="AgentRowChanging" msprop:Generator_RowEvHandlerName="AgentRowChangeEventHandler" msprop:Generator_RowDeletedName="AgentRowDeleted" msprop:Generator_UserTableName="Agent" msprop:Generator_RowChangedName="AgentRowChanged" msprop:Generator_RowEvArgName="AgentRowChangeEvent" msprop:Generator_RowClassName="AgentRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="150" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="AgentTypeID" msprop:Generator_ColumnVarNameInTable="columnAgentTypeID" msprop:Generator_ColumnPropNameInRow="AgentTypeID" msprop:Generator_ColumnPropNameInTable="AgentTypeIDColumn" msprop:Generator_UserColumnName="AgentTypeID" type="xs:int" />
- <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="300" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="INN" msprop:Generator_ColumnVarNameInTable="columnINN" msprop:Generator_ColumnPropNameInRow="INN" msprop:Generator_ColumnPropNameInTable="INNColumn" msprop:Generator_UserColumnName="INN">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="12" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="KPP" msprop:Generator_ColumnVarNameInTable="columnKPP" msprop:Generator_ColumnPropNameInRow="KPP" msprop:Generator_ColumnPropNameInTable="KPPColumn" msprop:Generator_UserColumnName="KPP" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="9" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="DirectorName" msprop:Generator_ColumnVarNameInTable="columnDirectorName" msprop:Generator_ColumnPropNameInRow="DirectorName" msprop:Generator_ColumnPropNameInTable="DirectorNameColumn" msprop:Generator_UserColumnName="DirectorName" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="20" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="255" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Logo" msprop:Generator_ColumnVarNameInTable="columnLogo" msprop:Generator_ColumnPropNameInRow="Logo" msprop:Generator_ColumnPropNameInTable="LogoColumn" msprop:Generator_UserColumnName="Logo" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" msprop:Generator_UserColumnName="Priority" type="xs:int" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="AgentPriorityHistory" msprop:Generator_TableClassName="AgentPriorityHistoryDataTable" msprop:Generator_TableVarName="tableAgentPriorityHistory" msprop:Generator_TablePropName="AgentPriorityHistory" msprop:Generator_RowDeletingName="AgentPriorityHistoryRowDeleting" msprop:Generator_RowChangingName="AgentPriorityHistoryRowChanging" msprop:Generator_RowEvHandlerName="AgentPriorityHistoryRowChangeEventHandler" msprop:Generator_RowDeletedName="AgentPriorityHistoryRowDeleted" msprop:Generator_UserTableName="AgentPriorityHistory" msprop:Generator_RowChangedName="AgentPriorityHistoryRowChanged" msprop:Generator_RowEvArgName="AgentPriorityHistoryRowChangeEvent" msprop:Generator_RowClassName="AgentPriorityHistoryRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="AgentID" msprop:Generator_ColumnVarNameInTable="columnAgentID" msprop:Generator_ColumnPropNameInRow="AgentID" msprop:Generator_ColumnPropNameInTable="AgentIDColumn" msprop:Generator_UserColumnName="AgentID" type="xs:int" />
- <xs:element name="ChangeDate" msprop:Generator_ColumnVarNameInTable="columnChangeDate" msprop:Generator_ColumnPropNameInRow="ChangeDate" msprop:Generator_ColumnPropNameInTable="ChangeDateColumn" msprop:Generator_UserColumnName="ChangeDate" type="xs:dateTime" />
- <xs:element name="PriorityValue" msprop:Generator_ColumnVarNameInTable="columnPriorityValue" msprop:Generator_ColumnPropNameInRow="PriorityValue" msprop:Generator_ColumnPropNameInTable="PriorityValueColumn" msprop:Generator_UserColumnName="PriorityValue" type="xs:int" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="AgentType" msprop:Generator_TableClassName="AgentTypeDataTable" msprop:Generator_TableVarName="tableAgentType" msprop:Generator_TablePropName="AgentType" msprop:Generator_RowDeletingName="AgentTypeRowDeleting" msprop:Generator_RowChangingName="AgentTypeRowChanging" msprop:Generator_RowEvHandlerName="AgentTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="AgentTypeRowDeleted" msprop:Generator_UserTableName="AgentType" msprop:Generator_RowChangedName="AgentTypeRowChanged" msprop:Generator_RowEvArgName="AgentTypeRowChangeEvent" msprop:Generator_RowClassName="AgentTypeRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="Material" msprop:Generator_TableClassName="MaterialDataTable" msprop:Generator_TableVarName="tableMaterial" msprop:Generator_TablePropName="Material" msprop:Generator_RowDeletingName="MaterialRowDeleting" msprop:Generator_RowChangingName="MaterialRowChanging" msprop:Generator_RowEvHandlerName="MaterialRowChangeEventHandler" msprop:Generator_RowDeletedName="MaterialRowDeleted" msprop:Generator_UserTableName="Material" msprop:Generator_RowChangedName="MaterialRowChanged" msprop:Generator_RowEvArgName="MaterialRowChangeEvent" msprop:Generator_RowClassName="MaterialRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="CountInPack" msprop:Generator_ColumnVarNameInTable="columnCountInPack" msprop:Generator_ColumnPropNameInRow="CountInPack" msprop:Generator_ColumnPropNameInTable="CountInPackColumn" msprop:Generator_UserColumnName="CountInPack" type="xs:int" />
- <xs:element name="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn" msprop:Generator_UserColumnName="Unit">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="10" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="CountInStock" msprop:Generator_ColumnVarNameInTable="columnCountInStock" msprop:Generator_ColumnPropNameInRow="CountInStock" msprop:Generator_ColumnPropNameInTable="CountInStockColumn" msprop:Generator_UserColumnName="CountInStock" type="xs:double" minOccurs="0" />
- <xs:element name="MinCount" msprop:Generator_ColumnVarNameInTable="columnMinCount" msprop:Generator_ColumnPropNameInRow="MinCount" msprop:Generator_ColumnPropNameInTable="MinCountColumn" msprop:Generator_UserColumnName="MinCount" type="xs:double" />
- <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Cost" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_UserColumnName="Cost" type="xs:decimal" />
- <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="MaterialTypeID" msprop:Generator_ColumnVarNameInTable="columnMaterialTypeID" msprop:Generator_ColumnPropNameInRow="MaterialTypeID" msprop:Generator_ColumnPropNameInTable="MaterialTypeIDColumn" msprop:Generator_UserColumnName="MaterialTypeID" type="xs:int" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="MaterialCountHistory" msprop:Generator_TableClassName="MaterialCountHistoryDataTable" msprop:Generator_TableVarName="tableMaterialCountHistory" msprop:Generator_TablePropName="MaterialCountHistory" msprop:Generator_RowDeletingName="MaterialCountHistoryRowDeleting" msprop:Generator_RowChangingName="MaterialCountHistoryRowChanging" msprop:Generator_RowEvHandlerName="MaterialCountHistoryRowChangeEventHandler" msprop:Generator_RowDeletedName="MaterialCountHistoryRowDeleted" msprop:Generator_UserTableName="MaterialCountHistory" msprop:Generator_RowChangedName="MaterialCountHistoryRowChanged" msprop:Generator_RowEvArgName="MaterialCountHistoryRowChangeEvent" msprop:Generator_RowClassName="MaterialCountHistoryRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="MaterialID" msprop:Generator_ColumnVarNameInTable="columnMaterialID" msprop:Generator_ColumnPropNameInRow="MaterialID" msprop:Generator_ColumnPropNameInTable="MaterialIDColumn" msprop:Generator_UserColumnName="MaterialID" type="xs:int" />
- <xs:element name="ChangeDate" msprop:Generator_ColumnVarNameInTable="columnChangeDate" msprop:Generator_ColumnPropNameInRow="ChangeDate" msprop:Generator_ColumnPropNameInTable="ChangeDateColumn" msprop:Generator_UserColumnName="ChangeDate" type="xs:dateTime" />
- <xs:element name="CountValue" msprop:Generator_ColumnVarNameInTable="columnCountValue" msprop:Generator_ColumnPropNameInRow="CountValue" msprop:Generator_ColumnPropNameInTable="CountValueColumn" msprop:Generator_UserColumnName="CountValue" type="xs:double" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="MaterialSupplier" msprop:Generator_TableClassName="MaterialSupplierDataTable" msprop:Generator_TableVarName="tableMaterialSupplier" msprop:Generator_TablePropName="MaterialSupplier" msprop:Generator_RowDeletingName="MaterialSupplierRowDeleting" msprop:Generator_RowChangingName="MaterialSupplierRowChanging" msprop:Generator_RowEvHandlerName="MaterialSupplierRowChangeEventHandler" msprop:Generator_RowDeletedName="MaterialSupplierRowDeleted" msprop:Generator_UserTableName="MaterialSupplier" msprop:Generator_RowChangedName="MaterialSupplierRowChanged" msprop:Generator_RowEvArgName="MaterialSupplierRowChangeEvent" msprop:Generator_RowClassName="MaterialSupplierRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="MaterialID" msprop:Generator_ColumnVarNameInTable="columnMaterialID" msprop:Generator_ColumnPropNameInRow="MaterialID" msprop:Generator_ColumnPropNameInTable="MaterialIDColumn" msprop:Generator_UserColumnName="MaterialID" type="xs:int" />
- <xs:element name="SupplierID" msprop:Generator_ColumnVarNameInTable="columnSupplierID" msprop:Generator_ColumnPropNameInRow="SupplierID" msprop:Generator_ColumnPropNameInTable="SupplierIDColumn" msprop:Generator_UserColumnName="SupplierID" type="xs:int" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="MaterialType" msprop:Generator_TableClassName="MaterialTypeDataTable" msprop:Generator_TableVarName="tableMaterialType" msprop:Generator_TablePropName="MaterialType" msprop:Generator_RowDeletingName="MaterialTypeRowDeleting" msprop:Generator_RowChangingName="MaterialTypeRowChanging" msprop:Generator_RowEvHandlerName="MaterialTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="MaterialTypeRowDeleted" msprop:Generator_UserTableName="MaterialType" msprop:Generator_RowChangedName="MaterialTypeRowChanged" msprop:Generator_RowEvArgName="MaterialTypeRowChangeEvent" msprop:Generator_RowClassName="MaterialTypeRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="DefectedPercent" msprop:Generator_ColumnVarNameInTable="columnDefectedPercent" msprop:Generator_ColumnPropNameInRow="DefectedPercent" msprop:Generator_ColumnPropNameInTable="DefectedPercentColumn" msprop:Generator_UserColumnName="DefectedPercent" type="xs:double" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="Product" msprop:Generator_TableClassName="ProductDataTable" msprop:Generator_TableVarName="tableProduct" msprop:Generator_TablePropName="Product" msprop:Generator_RowDeletingName="ProductRowDeleting" msprop:Generator_RowChangingName="ProductRowChanging" msprop:Generator_RowEvHandlerName="ProductRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductRowDeleted" msprop:Generator_UserTableName="Product" msprop:Generator_RowChangedName="ProductRowChanged" msprop:Generator_RowEvArgName="ProductRowChangeEvent" msprop:Generator_RowClassName="ProductRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="ProductTypeID" msprop:Generator_ColumnVarNameInTable="columnProductTypeID" msprop:Generator_ColumnPropNameInRow="ProductTypeID" msprop:Generator_ColumnPropNameInTable="ProductTypeIDColumn" msprop:Generator_UserColumnName="ProductTypeID" type="xs:int" minOccurs="0" />
- <xs:element name="ArticleNumber" msprop:Generator_ColumnVarNameInTable="columnArticleNumber" msprop:Generator_ColumnPropNameInRow="ArticleNumber" msprop:Generator_ColumnPropNameInTable="ArticleNumberColumn" msprop:Generator_UserColumnName="ArticleNumber">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="10" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="2147483647" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="ProductionPersonCount" msprop:Generator_ColumnVarNameInTable="columnProductionPersonCount" msprop:Generator_ColumnPropNameInRow="ProductionPersonCount" msprop:Generator_ColumnPropNameInTable="ProductionPersonCountColumn" msprop:Generator_UserColumnName="ProductionPersonCount" type="xs:int" minOccurs="0" />
- <xs:element name="ProductionWorkshopNumber" msprop:Generator_ColumnVarNameInTable="columnProductionWorkshopNumber" msprop:Generator_ColumnPropNameInRow="ProductionWorkshopNumber" msprop:Generator_ColumnPropNameInTable="ProductionWorkshopNumberColumn" msprop:Generator_UserColumnName="ProductionWorkshopNumber" type="xs:int" minOccurs="0" />
- <xs:element name="MinCostForAgent" msprop:Generator_ColumnVarNameInTable="columnMinCostForAgent" msprop:Generator_ColumnPropNameInRow="MinCostForAgent" msprop:Generator_ColumnPropNameInTable="MinCostForAgentColumn" msprop:Generator_UserColumnName="MinCostForAgent" type="xs:decimal" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="ProductCostHistory" msprop:Generator_TableClassName="ProductCostHistoryDataTable" msprop:Generator_TableVarName="tableProductCostHistory" msprop:Generator_TablePropName="ProductCostHistory" msprop:Generator_RowDeletingName="ProductCostHistoryRowDeleting" msprop:Generator_RowChangingName="ProductCostHistoryRowChanging" msprop:Generator_RowEvHandlerName="ProductCostHistoryRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductCostHistoryRowDeleted" msprop:Generator_UserTableName="ProductCostHistory" msprop:Generator_RowChangedName="ProductCostHistoryRowChanged" msprop:Generator_RowEvArgName="ProductCostHistoryRowChangeEvent" msprop:Generator_RowClassName="ProductCostHistoryRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
- <xs:element name="ChangeDate" msprop:Generator_ColumnVarNameInTable="columnChangeDate" msprop:Generator_ColumnPropNameInRow="ChangeDate" msprop:Generator_ColumnPropNameInTable="ChangeDateColumn" msprop:Generator_UserColumnName="ChangeDate" type="xs:dateTime" />
- <xs:element name="CostValue" msprop:Generator_ColumnVarNameInTable="columnCostValue" msprop:Generator_ColumnPropNameInRow="CostValue" msprop:Generator_ColumnPropNameInTable="CostValueColumn" msprop:Generator_UserColumnName="CostValue" type="xs:decimal" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="ProductMaterial" msprop:Generator_TableClassName="ProductMaterialDataTable" msprop:Generator_TableVarName="tableProductMaterial" msprop:Generator_TablePropName="ProductMaterial" msprop:Generator_RowDeletingName="ProductMaterialRowDeleting" msprop:Generator_RowChangingName="ProductMaterialRowChanging" msprop:Generator_RowEvHandlerName="ProductMaterialRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductMaterialRowDeleted" msprop:Generator_UserTableName="ProductMaterial" msprop:Generator_RowChangedName="ProductMaterialRowChanged" msprop:Generator_RowEvArgName="ProductMaterialRowChangeEvent" msprop:Generator_RowClassName="ProductMaterialRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
- <xs:element name="MaterialID" msprop:Generator_ColumnVarNameInTable="columnMaterialID" msprop:Generator_ColumnPropNameInRow="MaterialID" msprop:Generator_ColumnPropNameInTable="MaterialIDColumn" msprop:Generator_UserColumnName="MaterialID" type="xs:int" />
- <xs:element name="Count" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" msprop:Generator_UserColumnName="Count" type="xs:double" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="ProductSale" msprop:Generator_TableClassName="ProductSaleDataTable" msprop:Generator_TableVarName="tableProductSale" msprop:Generator_TablePropName="ProductSale" msprop:Generator_RowDeletingName="ProductSaleRowDeleting" msprop:Generator_RowChangingName="ProductSaleRowChanging" msprop:Generator_RowEvHandlerName="ProductSaleRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductSaleRowDeleted" msprop:Generator_UserTableName="ProductSale" msprop:Generator_RowChangedName="ProductSaleRowChanged" msprop:Generator_RowEvArgName="ProductSaleRowChangeEvent" msprop:Generator_RowClassName="ProductSaleRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="AgentID" msprop:Generator_ColumnVarNameInTable="columnAgentID" msprop:Generator_ColumnPropNameInRow="AgentID" msprop:Generator_ColumnPropNameInTable="AgentIDColumn" msprop:Generator_UserColumnName="AgentID" type="xs:int" />
- <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
- <xs:element name="SaleDate" msprop:Generator_ColumnVarNameInTable="columnSaleDate" msprop:Generator_ColumnPropNameInRow="SaleDate" msprop:Generator_ColumnPropNameInTable="SaleDateColumn" msprop:Generator_UserColumnName="SaleDate" type="xs:dateTime" />
- <xs:element name="ProductCount" msprop:Generator_ColumnVarNameInTable="columnProductCount" msprop:Generator_ColumnPropNameInRow="ProductCount" msprop:Generator_ColumnPropNameInTable="ProductCountColumn" msprop:Generator_UserColumnName="ProductCount" type="xs:int" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="ProductType" msprop:Generator_TableClassName="ProductTypeDataTable" msprop:Generator_TableVarName="tableProductType" msprop:Generator_TablePropName="ProductType" msprop:Generator_RowDeletingName="ProductTypeRowDeleting" msprop:Generator_RowChangingName="ProductTypeRowChanging" msprop:Generator_RowEvHandlerName="ProductTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductTypeRowDeleted" msprop:Generator_UserTableName="ProductType" msprop:Generator_RowChangedName="ProductTypeRowChanged" msprop:Generator_RowEvArgName="ProductTypeRowChangeEvent" msprop:Generator_RowClassName="ProductTypeRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="DefectedPercent" msprop:Generator_ColumnVarNameInTable="columnDefectedPercent" msprop:Generator_ColumnPropNameInRow="DefectedPercent" msprop:Generator_ColumnPropNameInTable="DefectedPercentColumn" msprop:Generator_UserColumnName="DefectedPercent" type="xs:double" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="Shop" msprop:Generator_TableClassName="ShopDataTable" msprop:Generator_TableVarName="tableShop" msprop:Generator_TablePropName="Shop" msprop:Generator_RowDeletingName="ShopRowDeleting" msprop:Generator_RowChangingName="ShopRowChanging" msprop:Generator_RowEvHandlerName="ShopRowChangeEventHandler" msprop:Generator_RowDeletedName="ShopRowDeleted" msprop:Generator_UserTableName="Shop" msprop:Generator_RowChangedName="ShopRowChanged" msprop:Generator_RowEvArgName="ShopRowChangeEvent" msprop:Generator_RowClassName="ShopRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="150" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="300" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="AgentID" msprop:Generator_ColumnVarNameInTable="columnAgentID" msprop:Generator_ColumnPropNameInRow="AgentID" msprop:Generator_ColumnPropNameInTable="AgentIDColumn" msprop:Generator_UserColumnName="AgentID" type="xs:int" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="Supplier" msprop:Generator_TableClassName="SupplierDataTable" msprop:Generator_TableVarName="tableSupplier" msprop:Generator_TablePropName="Supplier" msprop:Generator_RowDeletingName="SupplierRowDeleting" msprop:Generator_RowChangingName="SupplierRowChanging" msprop:Generator_RowEvHandlerName="SupplierRowChangeEventHandler" msprop:Generator_RowDeletedName="SupplierRowDeleted" msprop:Generator_UserTableName="Supplier" msprop:Generator_RowChangedName="SupplierRowChanged" msprop:Generator_RowEvArgName="SupplierRowChangeEvent" msprop:Generator_RowClassName="SupplierRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="150" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="INN" msprop:Generator_ColumnVarNameInTable="columnINN" msprop:Generator_ColumnPropNameInRow="INN" msprop:Generator_ColumnPropNameInTable="INNColumn" msprop:Generator_UserColumnName="INN">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="12" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" type="xs:dateTime" />
- <xs:element name="QualityRating" msprop:Generator_ColumnVarNameInTable="columnQualityRating" msprop:Generator_ColumnPropNameInRow="QualityRating" msprop:Generator_ColumnPropNameInTable="QualityRatingColumn" msprop:Generator_UserColumnName="QualityRating" type="xs:int" minOccurs="0" />
- <xs:element name="SupplierType" msprop:Generator_ColumnVarNameInTable="columnSupplierType" msprop:Generator_ColumnPropNameInRow="SupplierType" msprop:Generator_ColumnPropNameInTable="SupplierTypeColumn" msprop:Generator_UserColumnName="SupplierType" 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="ItogSumProduct" msprop:Generator_TableClassName="ItogSumProductDataTable" msprop:Generator_TableVarName="tableItogSumProduct" msprop:Generator_TablePropName="ItogSumProduct" msprop:Generator_RowDeletingName="ItogSumProductRowDeleting" msprop:Generator_RowChangingName="ItogSumProductRowChanging" msprop:Generator_RowEvHandlerName="ItogSumProductRowChangeEventHandler" msprop:Generator_RowDeletedName="ItogSumProductRowDeleted" msprop:Generator_UserTableName="ItogSumProduct" msprop:Generator_RowChangedName="ItogSumProductRowChanged" msprop:Generator_RowEvArgName="ItogSumProductRowChangeEvent" msprop:Generator_RowClassName="ItogSumProductRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="Product" msprop:Generator_ColumnVarNameInTable="columnProduct" msprop:Generator_ColumnPropNameInRow="Product" msprop:Generator_ColumnPropNameInTable="ProductColumn" msprop:Generator_UserColumnName="Product">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Cost" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_UserColumnName="Cost" type="xs:double" minOccurs="0" />
- <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="ProductsPred" msprop:Generator_TableClassName="ProductsPredDataTable" msprop:Generator_TableVarName="tableProductsPred" msprop:Generator_TablePropName="ProductsPred" msprop:Generator_RowDeletingName="ProductsPredRowDeleting" msprop:Generator_RowChangingName="ProductsPredRowChanging" msprop:Generator_RowEvHandlerName="ProductsPredRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductsPredRowDeleted" msprop:Generator_UserTableName="ProductsPred" msprop:Generator_RowChangedName="ProductsPredRowChanged" msprop:Generator_RowEvArgName="ProductsPredRowChangeEvent" msprop:Generator_RowClassName="ProductsPredRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Cost" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_UserColumnName="Cost" type="xs:double" minOccurs="0" />
- <xs:element name="ArticleNumber" msprop:Generator_ColumnVarNameInTable="columnArticleNumber" msprop:Generator_ColumnPropNameInRow="ArticleNumber" msprop:Generator_ColumnPropNameInTable="ArticleNumberColumn" msprop:Generator_UserColumnName="ArticleNumber">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="10" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="ProductionPersonCount" msprop:Generator_ColumnVarNameInTable="columnProductionPersonCount" msprop:Generator_ColumnPropNameInRow="ProductionPersonCount" msprop:Generator_ColumnPropNameInTable="ProductionPersonCountColumn" msprop:Generator_UserColumnName="ProductionPersonCount" type="xs:int" minOccurs="0" />
- <xs:element name="ProductionWorkshopNumber" msprop:Generator_ColumnVarNameInTable="columnProductionWorkshopNumber" msprop:Generator_ColumnPropNameInRow="ProductionWorkshopNumber" msprop:Generator_ColumnPropNameInTable="ProductionWorkshopNumberColumn" msprop:Generator_UserColumnName="ProductionWorkshopNumber" type="xs:int" minOccurs="0" />
- <xs:element name="MinCostForAgent" msprop:Generator_ColumnVarNameInTable="columnMinCostForAgent" msprop:Generator_ColumnPropNameInRow="MinCostForAgent" msprop:Generator_ColumnPropNameInTable="MinCostForAgentColumn" msprop:Generator_UserColumnName="MinCostForAgent" type="xs:decimal" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="ProizvProduct" msprop:Generator_TableClassName="ProizvProductDataTable" msprop:Generator_TableVarName="tableProizvProduct" msprop:Generator_TablePropName="ProizvProduct" msprop:Generator_RowDeletingName="ProizvProductRowDeleting" msprop:Generator_RowChangingName="ProizvProductRowChanging" msprop:Generator_RowEvHandlerName="ProizvProductRowChangeEventHandler" msprop:Generator_RowDeletedName="ProizvProductRowDeleted" msprop:Generator_UserTableName="ProizvProduct" msprop:Generator_RowChangedName="ProizvProductRowChanged" msprop:Generator_RowEvArgName="ProizvProductRowChangeEvent" msprop:Generator_RowClassName="ProizvProductRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
- <xs:element name="Product" msprop:Generator_ColumnVarNameInTable="columnProduct" msprop:Generator_ColumnPropNameInRow="Product" msprop:Generator_ColumnPropNameInTable="ProductColumn" msprop:Generator_UserColumnName="Product">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Material" msprop:Generator_ColumnVarNameInTable="columnMaterial" msprop:Generator_ColumnPropNameInRow="Material" msprop:Generator_ColumnPropNameInTable="MaterialColumn" msprop:Generator_UserColumnName="Material">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="100" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Count" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" msprop:Generator_UserColumnName="Count" type="xs:double" minOccurs="0" />
- <xs:element name="Cost" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_UserColumnName="Cost" type="xs:decimal" />
- <xs:element name="Proizv" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnProizv" msprop:Generator_ColumnPropNameInRow="Proizv" msprop:Generator_ColumnPropNameInTable="ProizvColumn" msprop:Generator_UserColumnName="Proizv" type="xs:double" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:complexType>
- <xs:unique name="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Agent" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="AgentPriorityHistory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:AgentPriorityHistory" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="AgentType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:AgentType" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="Material_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Material" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="MaterialCountHistory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:MaterialCountHistory" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="MaterialSupplier_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:MaterialSupplier" />
- <xs:field xpath="mstns:MaterialID" />
- <xs:field xpath="mstns:SupplierID" />
- </xs:unique>
- <xs:unique name="MaterialType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:MaterialType" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Product" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="ProductCostHistory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:ProductCostHistory" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="ProductMaterial_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:ProductMaterial" />
- <xs:field xpath="mstns:ProductID" />
- <xs:field xpath="mstns:MaterialID" />
- </xs:unique>
- <xs:unique name="ProductSale_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:ProductSale" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="ProductType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:ProductType" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="Shop_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Shop" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="Supplier_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:Supplier" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="ItogSumProduct_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:ItogSumProduct" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="ProductsPred_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:ProductsPred" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- <xs:unique name="ProizvProduct_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:ProizvProduct" />
- <xs:field xpath="mstns:ID" />
- </xs:unique>
- </xs:element>
- <xs:annotation>
- <xs:appinfo>
- <msdata:Relationship name="FK_Agent_AgentType" msdata:parent="AgentType" msdata:child="Agent" msdata:parentkey="ID" msdata:childkey="AgentTypeID" msprop:Generator_UserChildTable="Agent" msprop:Generator_ChildPropName="GetAgentRows" msprop:Generator_UserRelationName="FK_Agent_AgentType" msprop:Generator_RelationVarName="relationFK_Agent_AgentType" msprop:Generator_UserParentTable="AgentType" msprop:Generator_ParentPropName="AgentTypeRow" />
- <msdata:Relationship name="FK_AgentPriorityHistory_Agent" msdata:parent="Agent" msdata:child="AgentPriorityHistory" msdata:parentkey="ID" msdata:childkey="AgentID" msprop:Generator_UserChildTable="AgentPriorityHistory" msprop:Generator_ChildPropName="GetAgentPriorityHistoryRows" msprop:Generator_UserRelationName="FK_AgentPriorityHistory_Agent" msprop:Generator_ParentPropName="AgentRow" msprop:Generator_RelationVarName="relationFK_AgentPriorityHistory_Agent" msprop:Generator_UserParentTable="Agent" />
- <msdata:Relationship name="FK_Material_MaterialType" msdata:parent="MaterialType" msdata:child="Material" msdata:parentkey="ID" msdata:childkey="MaterialTypeID" msprop:Generator_UserChildTable="Material" msprop:Generator_ChildPropName="GetMaterialRows" msprop:Generator_UserRelationName="FK_Material_MaterialType" msprop:Generator_RelationVarName="relationFK_Material_MaterialType" msprop:Generator_UserParentTable="MaterialType" msprop:Generator_ParentPropName="MaterialTypeRow" />
- <msdata:Relationship name="FK_MaterialCountHistory_Material" msdata:parent="Material" msdata:child="MaterialCountHistory" msdata:parentkey="ID" msdata:childkey="MaterialID" msprop:Generator_UserChildTable="MaterialCountHistory" msprop:Generator_ChildPropName="GetMaterialCountHistoryRows" msprop:Generator_UserRelationName="FK_MaterialCountHistory_Material" msprop:Generator_ParentPropName="MaterialRow" msprop:Generator_RelationVarName="relationFK_MaterialCountHistory_Material" msprop:Generator_UserParentTable="Material" />
- <msdata:Relationship name="FK_MaterialSupplier_Material" msdata:parent="Material" msdata:child="MaterialSupplier" msdata:parentkey="ID" msdata:childkey="MaterialID" msprop:Generator_UserChildTable="MaterialSupplier" msprop:Generator_ChildPropName="GetMaterialSupplierRows" msprop:Generator_UserRelationName="FK_MaterialSupplier_Material" msprop:Generator_ParentPropName="MaterialRow" msprop:Generator_RelationVarName="relationFK_MaterialSupplier_Material" msprop:Generator_UserParentTable="Material" />
- <msdata:Relationship name="FK_MaterialSupplier_Supplier" msdata:parent="Supplier" msdata:child="MaterialSupplier" msdata:parentkey="ID" msdata:childkey="SupplierID" msprop:Generator_UserChildTable="MaterialSupplier" msprop:Generator_ChildPropName="GetMaterialSupplierRows" msprop:Generator_UserRelationName="FK_MaterialSupplier_Supplier" msprop:Generator_RelationVarName="relationFK_MaterialSupplier_Supplier" msprop:Generator_UserParentTable="Supplier" msprop:Generator_ParentPropName="SupplierRow" />
- <msdata:Relationship name="FK_Product_ProductType" msdata:parent="ProductType" msdata:child="Product" msdata:parentkey="ID" msdata:childkey="ProductTypeID" msprop:Generator_UserChildTable="Product" msprop:Generator_ChildPropName="GetProductRows" msprop:Generator_UserRelationName="FK_Product_ProductType" msprop:Generator_RelationVarName="relationFK_Product_ProductType" msprop:Generator_UserParentTable="ProductType" msprop:Generator_ParentPropName="ProductTypeRow" />
- <msdata:Relationship name="FK_ProductCostHistory_Product" msdata:parent="Product" msdata:child="ProductCostHistory" msdata:parentkey="ID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="ProductCostHistory" msprop:Generator_ChildPropName="GetProductCostHistoryRows" msprop:Generator_UserRelationName="FK_ProductCostHistory_Product" msprop:Generator_ParentPropName="ProductRow" msprop:Generator_RelationVarName="relationFK_ProductCostHistory_Product" msprop:Generator_UserParentTable="Product" />
- <msdata:Relationship name="FK_ProductMaterial_Material" msdata:parent="Material" msdata:child="ProductMaterial" msdata:parentkey="ID" msdata:childkey="MaterialID" msprop:Generator_UserChildTable="ProductMaterial" msprop:Generator_ChildPropName="GetProductMaterialRows" msprop:Generator_UserRelationName="FK_ProductMaterial_Material" msprop:Generator_ParentPropName="MaterialRow" msprop:Generator_RelationVarName="relationFK_ProductMaterial_Material" msprop:Generator_UserParentTable="Material" />
- <msdata:Relationship name="FK_ProductMaterial_Product" msdata:parent="Product" msdata:child="ProductMaterial" msdata:parentkey="ID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="ProductMaterial" msprop:Generator_ChildPropName="GetProductMaterialRows" msprop:Generator_UserRelationName="FK_ProductMaterial_Product" msprop:Generator_ParentPropName="ProductRow" msprop:Generator_RelationVarName="relationFK_ProductMaterial_Product" msprop:Generator_UserParentTable="Product" />
- <msdata:Relationship name="FK_ProductSale_Agent" msdata:parent="Agent" msdata:child="ProductSale" msdata:parentkey="ID" msdata:childkey="AgentID" msprop:Generator_UserChildTable="ProductSale" msprop:Generator_ChildPropName="GetProductSaleRows" msprop:Generator_UserRelationName="FK_ProductSale_Agent" msprop:Generator_ParentPropName="AgentRow" msprop:Generator_RelationVarName="relationFK_ProductSale_Agent" msprop:Generator_UserParentTable="Agent" />
- <msdata:Relationship name="FK_ProductSale_Product" msdata:parent="Product" msdata:child="ProductSale" msdata:parentkey="ID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="ProductSale" msprop:Generator_ChildPropName="GetProductSaleRows" msprop:Generator_UserRelationName="FK_ProductSale_Product" msprop:Generator_ParentPropName="ProductRow" msprop:Generator_RelationVarName="relationFK_ProductSale_Product" msprop:Generator_UserParentTable="Product" />
- <msdata:Relationship name="FK_Shop_Agent" msdata:parent="Agent" msdata:child="Shop" msdata:parentkey="ID" msdata:childkey="AgentID" msprop:Generator_UserChildTable="Shop" msprop:Generator_ChildPropName="GetShopRows" msprop:Generator_UserRelationName="FK_Shop_Agent" msprop:Generator_ParentPropName="AgentRow" msprop:Generator_RelationVarName="relationFK_Shop_Agent" msprop:Generator_UserParentTable="Agent" />
- </xs:appinfo>
- </xs:annotation>
- </xs:schema>
|