524 lines
81 KiB
XML
524 lines
81 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="Make3DbTestDataSet" targetNamespace="http://tempuri.org/Make3DbTestDataSet.xsd" xmlns:mstns="http://tempuri.org/Make3DbTestDataSet.xsd" xmlns="http://tempuri.org/Make3DbTestDataSet.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 ConnectionStringObject="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Downloads\Proekty\DotMatrix\Make3\Make3\bin\Debug\Make3DbTest.mdf;Integrated Security=True;Connect Timeout=30" IsAppSettingsProperty="false" Modifier="Assembly" Name="Make3DbTest.mdf" ParameterPrefix="@" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ColorProfilesTableAdapter" GeneratorDataComponentClassName="ColorProfilesTableAdapter" Name="ColorProfiles" UserDataComponentName="ColorProfilesTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Make3DbTest.mdf" DbObjectName="dbo.ColorProfiles" 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].[ColorProfiles] WHERE (([Id] = @Original_Id) AND ([ProfileName] = @Original_ProfileName) AND ([ArcWidth] = @Original_ArcWidth) AND ([LayerId] = @Original_LayerId))</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_ProfileName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProfileName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ArcWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LayerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LayerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[ColorProfiles] ([ProfileName], [TraceProfile], [KeyPoints], [ArcWidth], [LayerId]) VALUES (@ProfileName, @TraceProfile, @KeyPoints, @ArcWidth, @LayerId);
|
|
SELECT Id, ProfileName, TraceProfile, KeyPoints, ArcWidth, LayerId FROM ColorProfiles WHERE (Id = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProfileName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProfileName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TraceProfile" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="TraceProfile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KeyPoints" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="KeyPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ArcWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LayerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LayerId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT Id, ProfileName, TraceProfile, KeyPoints, ArcWidth, LayerId FROM dbo.ColorProfiles</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[ColorProfiles] SET [ProfileName] = @ProfileName, [TraceProfile] = @TraceProfile, [KeyPoints] = @KeyPoints, [ArcWidth] = @ArcWidth, [LayerId] = @LayerId WHERE (([Id] = @Original_Id) AND ([ProfileName] = @Original_ProfileName) AND ([ArcWidth] = @Original_ArcWidth) AND ([LayerId] = @Original_LayerId));
|
|
SELECT Id, ProfileName, TraceProfile, KeyPoints, ArcWidth, LayerId FROM ColorProfiles WHERE (Id = @Id)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProfileName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProfileName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TraceProfile" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="TraceProfile" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@KeyPoints" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="KeyPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ArcWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LayerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LayerId" 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_ProfileName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProfileName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ArcWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LayerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LayerId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[C:\DOWNLOADS\PROEKTY\DOTMATRIX\MAKE3\MAKE3\BIN\DEBUG\MAKE3DBTEST.MDF].dbo.ColorProfiles" 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="ProfileName" DataSetColumn="ProfileName" />
|
|
<Mapping SourceColumn="TraceProfile" DataSetColumn="TraceProfile" />
|
|
<Mapping SourceColumn="KeyPoints" DataSetColumn="KeyPoints" />
|
|
<Mapping SourceColumn="ArcWidth" DataSetColumn="ArcWidth" />
|
|
<Mapping SourceColumn="LayerId" DataSetColumn="LayerId" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LayersTableAdapter" GeneratorDataComponentClassName="LayersTableAdapter" Name="Layers" UserDataComponentName="LayersTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Make3DbTest.mdf" DbObjectName="dbo.Layers" 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].[Layers] WHERE (([Id] = @Original_Id) AND ([Order] = @Original_Order) AND ([LayerName] = @Original_LayerName) AND ([TechnologyName] = @Original_TechnologyName) AND ([OpticalSchema] = @Original_OpticalSchema) AND ([ProjectId] = @Original_ProjectId) AND ([TechnologyId] = @Original_TechnologyId) AND ([ArcWidth] = @Original_ArcWidth) AND ([RadiusMax] = @Original_RadiusMax) AND ([Step] = @Original_Step) AND ((@IsNull_FullMask = 1 AND [FullMask] IS NULL) OR ([FullMask] = @Original_FullMask)) AND ((@IsNull_TileMask = 1 AND [TileMask] IS NULL) OR ([TileMask] = @Original_TileMask)))</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_Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LayerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LayerName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TechnologyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnologyName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_OpticalSchema" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OpticalSchema" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProjectId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TechnologyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TechnologyId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ArcWidth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_RadiusMax" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RadiusMax" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Step" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Step" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FullMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullMask" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FullMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullMask" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TileMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TileMask" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TileMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TileMask" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Layers] ([Order], [LayerName], [TechnologyName], [OpticalSchema], [ProjectId], [TechnologyId], [ArcWidth], [RadiusMax], [Step], [SourceFilePath], [AnglesFilePath], [FullMask], [TileMask]) VALUES (@Order, @LayerName, @TechnologyName, @OpticalSchema, @ProjectId, @TechnologyId, @ArcWidth, @RadiusMax, @Step, @SourceFilePath, @AnglesFilePath, @FullMask, @TileMask);
|
|
SELECT Id, [Order], LayerName, TechnologyName, OpticalSchema, ProjectId, TechnologyId, ArcWidth, RadiusMax, Step, SourceFilePath, AnglesFilePath, FullMask, TileMask FROM Layers WHERE (Id = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LayerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LayerName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TechnologyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnologyName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OpticalSchema" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OpticalSchema" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TechnologyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TechnologyId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ArcWidth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@RadiusMax" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RadiusMax" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Step" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Step" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SourceFilePath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SourceFilePath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnglesFilePath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnglesFilePath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FullMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullMask" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TileMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TileMask" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT Id, [Order], LayerName, TechnologyName, OpticalSchema, ProjectId, TechnologyId, ArcWidth, RadiusMax, Step, SourceFilePath, AnglesFilePath, FullMask, TileMask FROM dbo.Layers</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Layers] SET [Order] = @Order, [LayerName] = @LayerName, [TechnologyName] = @TechnologyName, [OpticalSchema] = @OpticalSchema, [ProjectId] = @ProjectId, [TechnologyId] = @TechnologyId, [ArcWidth] = @ArcWidth, [RadiusMax] = @RadiusMax, [Step] = @Step, [SourceFilePath] = @SourceFilePath, [AnglesFilePath] = @AnglesFilePath, [FullMask] = @FullMask, [TileMask] = @TileMask WHERE (([Id] = @Original_Id) AND ([Order] = @Original_Order) AND ([LayerName] = @Original_LayerName) AND ([TechnologyName] = @Original_TechnologyName) AND ([OpticalSchema] = @Original_OpticalSchema) AND ([ProjectId] = @Original_ProjectId) AND ([TechnologyId] = @Original_TechnologyId) AND ([ArcWidth] = @Original_ArcWidth) AND ([RadiusMax] = @Original_RadiusMax) AND ([Step] = @Original_Step) AND ((@IsNull_FullMask = 1 AND [FullMask] IS NULL) OR ([FullMask] = @Original_FullMask)) AND ((@IsNull_TileMask = 1 AND [TileMask] IS NULL) OR ([TileMask] = @Original_TileMask)));
|
|
SELECT Id, [Order], LayerName, TechnologyName, OpticalSchema, ProjectId, TechnologyId, ArcWidth, RadiusMax, Step, SourceFilePath, AnglesFilePath, FullMask, TileMask FROM Layers WHERE (Id = @Id)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LayerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LayerName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TechnologyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnologyName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OpticalSchema" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OpticalSchema" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TechnologyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TechnologyId" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ArcWidth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@RadiusMax" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RadiusMax" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Step" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Step" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SourceFilePath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SourceFilePath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnglesFilePath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnglesFilePath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FullMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullMask" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TileMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TileMask" 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_Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LayerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LayerName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TechnologyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnologyName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_OpticalSchema" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OpticalSchema" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProjectId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TechnologyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TechnologyId" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ArcWidth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_RadiusMax" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="RadiusMax" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Step" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Step" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FullMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullMask" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FullMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FullMask" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TileMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TileMask" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TileMask" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TileMask" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[C:\DOWNLOADS\PROEKTY\DOTMATRIX\MAKE3\MAKE3\BIN\DEBUG\MAKE3DBTEST.MDF].dbo.Layers" 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="Order" DataSetColumn="Order" />
|
|
<Mapping SourceColumn="LayerName" DataSetColumn="LayerName" />
|
|
<Mapping SourceColumn="TechnologyName" DataSetColumn="TechnologyName" />
|
|
<Mapping SourceColumn="OpticalSchema" DataSetColumn="OpticalSchema" />
|
|
<Mapping SourceColumn="ProjectId" DataSetColumn="ProjectId" />
|
|
<Mapping SourceColumn="TechnologyId" DataSetColumn="TechnologyId" />
|
|
<Mapping SourceColumn="ArcWidth" DataSetColumn="ArcWidth" />
|
|
<Mapping SourceColumn="RadiusMax" DataSetColumn="RadiusMax" />
|
|
<Mapping SourceColumn="Step" DataSetColumn="Step" />
|
|
<Mapping SourceColumn="SourceFilePath" DataSetColumn="SourceFilePath" />
|
|
<Mapping SourceColumn="AnglesFilePath" DataSetColumn="AnglesFilePath" />
|
|
<Mapping SourceColumn="FullMask" DataSetColumn="FullMask" />
|
|
<Mapping SourceColumn="TileMask" DataSetColumn="TileMask" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProjectsTableAdapter" GeneratorDataComponentClassName="ProjectsTableAdapter" Name="Projects" UserDataComponentName="ProjectsTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Make3DbTest.mdf" DbObjectName="dbo.Projects" 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].[Projects] WHERE (([Id] = @Original_Id) AND ([ProjectName] = @Original_ProjectName) AND ([Created] = @Original_Created) AND ([LastUpdated] = @Original_LastUpdated) AND ([HologramWidth] = @Original_HologramWidth) AND ([HologramHeight] = @Original_HologramHeight) AND ([FrameWidth] = @Original_FrameWidth) AND ([FrameHeight] = @Original_FrameHeight) AND ([FrameResolutionX] = @Original_FrameResolutionX) AND ([FrameResolutionY] = @Original_FrameResolutionY) AND ([GrayRangeHigh] = @Original_GrayRangeHigh) AND ([GrayRangeLow] = @Original_GrayRangeLow))</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_ProjectName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProjectName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Created" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Created" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastUpdated" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_HologramWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="HologramWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_HologramHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="HologramHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_FrameWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FrameWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_FrameHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FrameHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FrameResolutionX" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrameResolutionX" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FrameResolutionY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrameResolutionY" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GrayRangeHigh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GrayRangeHigh" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GrayRangeLow" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GrayRangeLow" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Projects] ([ProjectName], [OutPath], [Created], [LastUpdated], [HologramWidth], [HologramHeight], [FrameWidth], [FrameHeight], [FrameResolutionX], [FrameResolutionY], [GrayRangeHigh], [GrayRangeLow]) VALUES (@ProjectName, @OutPath, @Created, @LastUpdated, @HologramWidth, @HologramHeight, @FrameWidth, @FrameHeight, @FrameResolutionX, @FrameResolutionY, @GrayRangeHigh, @GrayRangeLow);
|
|
SELECT Id, ProjectName, OutPath, Created, LastUpdated, HologramWidth, HologramHeight, FrameWidth, FrameHeight, FrameResolutionX, FrameResolutionY, GrayRangeHigh, GrayRangeLow FROM Projects WHERE (Id = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProjectName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OutPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OutPath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Created" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Created" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastUpdated" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@HologramWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="HologramWidth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@HologramHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="HologramHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@FrameWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FrameWidth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@FrameHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FrameHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FrameResolutionX" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrameResolutionX" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FrameResolutionY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrameResolutionY" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GrayRangeHigh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GrayRangeHigh" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GrayRangeLow" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GrayRangeLow" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT Id, ProjectName, OutPath, Created, LastUpdated, HologramWidth, HologramHeight, FrameWidth, FrameHeight, FrameResolutionX, FrameResolutionY, GrayRangeHigh, GrayRangeLow FROM dbo.Projects</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Projects] SET [ProjectName] = @ProjectName, [OutPath] = @OutPath, [Created] = @Created, [LastUpdated] = @LastUpdated, [HologramWidth] = @HologramWidth, [HologramHeight] = @HologramHeight, [FrameWidth] = @FrameWidth, [FrameHeight] = @FrameHeight, [FrameResolutionX] = @FrameResolutionX, [FrameResolutionY] = @FrameResolutionY, [GrayRangeHigh] = @GrayRangeHigh, [GrayRangeLow] = @GrayRangeLow WHERE (([Id] = @Original_Id) AND ([ProjectName] = @Original_ProjectName) AND ([Created] = @Original_Created) AND ([LastUpdated] = @Original_LastUpdated) AND ([HologramWidth] = @Original_HologramWidth) AND ([HologramHeight] = @Original_HologramHeight) AND ([FrameWidth] = @Original_FrameWidth) AND ([FrameHeight] = @Original_FrameHeight) AND ([FrameResolutionX] = @Original_FrameResolutionX) AND ([FrameResolutionY] = @Original_FrameResolutionY) AND ([GrayRangeHigh] = @Original_GrayRangeHigh) AND ([GrayRangeLow] = @Original_GrayRangeLow));
|
|
SELECT Id, ProjectName, OutPath, Created, LastUpdated, HologramWidth, HologramHeight, FrameWidth, FrameHeight, FrameResolutionX, FrameResolutionY, GrayRangeHigh, GrayRangeLow FROM Projects WHERE (Id = @Id)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProjectName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OutPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OutPath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Created" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Created" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastUpdated" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@HologramWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="HologramWidth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@HologramHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="HologramHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@FrameWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FrameWidth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@FrameHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FrameHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FrameResolutionX" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrameResolutionX" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FrameResolutionY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrameResolutionY" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GrayRangeHigh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GrayRangeHigh" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GrayRangeLow" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GrayRangeLow" 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_ProjectName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProjectName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Created" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Created" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastUpdated" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_HologramWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="HologramWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_HologramHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="HologramHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_FrameWidth" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FrameWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_FrameHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="FrameHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FrameResolutionX" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrameResolutionX" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FrameResolutionY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FrameResolutionY" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GrayRangeHigh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GrayRangeHigh" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GrayRangeLow" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GrayRangeLow" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[C:\DOWNLOADS\PROEKTY\DOTMATRIX\MAKE3\MAKE3\BIN\DEBUG\MAKE3DBTEST.MDF].dbo.Projects" 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="ProjectName" DataSetColumn="ProjectName" />
|
|
<Mapping SourceColumn="OutPath" DataSetColumn="OutPath" />
|
|
<Mapping SourceColumn="Created" DataSetColumn="Created" />
|
|
<Mapping SourceColumn="LastUpdated" DataSetColumn="LastUpdated" />
|
|
<Mapping SourceColumn="HologramWidth" DataSetColumn="HologramWidth" />
|
|
<Mapping SourceColumn="HologramHeight" DataSetColumn="HologramHeight" />
|
|
<Mapping SourceColumn="FrameWidth" DataSetColumn="FrameWidth" />
|
|
<Mapping SourceColumn="FrameHeight" DataSetColumn="FrameHeight" />
|
|
<Mapping SourceColumn="FrameResolutionX" DataSetColumn="FrameResolutionX" />
|
|
<Mapping SourceColumn="FrameResolutionY" DataSetColumn="FrameResolutionY" />
|
|
<Mapping SourceColumn="GrayRangeHigh" DataSetColumn="GrayRangeHigh" />
|
|
<Mapping SourceColumn="GrayRangeLow" DataSetColumn="GrayRangeLow" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TechnologyTableAdapter" GeneratorDataComponentClassName="TechnologyTableAdapter" Name="Technology" UserDataComponentName="TechnologyTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="Make3DbTest.mdf" DbObjectName="dbo.Technology" 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].[Technology] WHERE (([Id] = @Original_Id) AND ([TechnologyName] = @Original_TechnologyName) AND ([Step] = @Original_Step) AND ([Radius] = @Original_Radius) AND ([ArcWidth] = @Original_ArcWidth))</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_TechnologyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnologyName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Step" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Step" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Radius" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Radius" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ArcWidth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [dbo].[Technology] ([TechnologyName], [ImagePath], [AnglesPath], [Step], [Radius], [ArcWidth]) VALUES (@TechnologyName, @ImagePath, @AnglesPath, @Step, @Radius, @ArcWidth);
|
|
SELECT Id, TechnologyName, ImagePath, AnglesPath, Step, Radius, ArcWidth FROM Technology WHERE (Id = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TechnologyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnologyName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ImagePath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ImagePath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnglesPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnglesPath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Step" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Step" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Radius" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Radius" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ArcWidth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT Id, TechnologyName, ImagePath, AnglesPath, Step, Radius, ArcWidth FROM dbo.Technology</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [dbo].[Technology] SET [TechnologyName] = @TechnologyName, [ImagePath] = @ImagePath, [AnglesPath] = @AnglesPath, [Step] = @Step, [Radius] = @Radius, [ArcWidth] = @ArcWidth WHERE (([Id] = @Original_Id) AND ([TechnologyName] = @Original_TechnologyName) AND ([Step] = @Original_Step) AND ([Radius] = @Original_Radius) AND ([ArcWidth] = @Original_ArcWidth));
|
|
SELECT Id, TechnologyName, ImagePath, AnglesPath, Step, Radius, ArcWidth FROM Technology WHERE (Id = @Id)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TechnologyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnologyName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ImagePath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ImagePath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AnglesPath" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AnglesPath" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Step" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Step" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Radius" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Radius" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ArcWidth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArcWidth" 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_TechnologyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TechnologyName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Step" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Step" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Radius" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Radius" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ArcWidth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArcWidth" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[C:\DOWNLOADS\PROEKTY\DOTMATRIX\MAKE3\MAKE3\BIN\DEBUG\MAKE3DBTEST.MDF].dbo.Technology" 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="TechnologyName" DataSetColumn="TechnologyName" />
|
|
<Mapping SourceColumn="ImagePath" DataSetColumn="ImagePath" />
|
|
<Mapping SourceColumn="AnglesPath" DataSetColumn="AnglesPath" />
|
|
<Mapping SourceColumn="Step" DataSetColumn="Step" />
|
|
<Mapping SourceColumn="Radius" DataSetColumn="Radius" />
|
|
<Mapping SourceColumn="ArcWidth" DataSetColumn="ArcWidth" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="Make3DbTestDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Make3DbTestDataSet" msprop:Generator_UserDSName="Make3DbTestDataSet">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="ColorProfiles" msprop:Generator_TableClassName="ColorProfilesDataTable" msprop:Generator_TableVarName="tableColorProfiles" msprop:Generator_TablePropName="ColorProfiles" msprop:Generator_RowDeletingName="ColorProfilesRowDeleting" msprop:Generator_RowChangingName="ColorProfilesRowChanging" msprop:Generator_RowEvHandlerName="ColorProfilesRowChangeEventHandler" msprop:Generator_RowDeletedName="ColorProfilesRowDeleted" msprop:Generator_UserTableName="ColorProfiles" msprop:Generator_RowChangedName="ColorProfilesRowChanged" msprop:Generator_RowEvArgName="ColorProfilesRowChangeEvent" msprop:Generator_RowClassName="ColorProfilesRow">
|
|
<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="ProfileName" msprop:Generator_ColumnVarNameInTable="columnProfileName" msprop:Generator_ColumnPropNameInRow="ProfileName" msprop:Generator_ColumnPropNameInTable="ProfileNameColumn" msprop:Generator_UserColumnName="ProfileName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TraceProfile" msprop:Generator_ColumnVarNameInTable="columnTraceProfile" msprop:Generator_ColumnPropNameInRow="TraceProfile" msprop:Generator_ColumnPropNameInTable="TraceProfileColumn" msprop:Generator_UserColumnName="TraceProfile">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="KeyPoints" msprop:Generator_ColumnVarNameInTable="columnKeyPoints" msprop:Generator_ColumnPropNameInRow="KeyPoints" msprop:Generator_ColumnPropNameInTable="KeyPointsColumn" msprop:Generator_UserColumnName="KeyPoints">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ArcWidth" msprop:Generator_ColumnVarNameInTable="columnArcWidth" msprop:Generator_ColumnPropNameInRow="ArcWidth" msprop:Generator_ColumnPropNameInTable="ArcWidthColumn" msprop:Generator_UserColumnName="ArcWidth" type="xs:double" />
|
|
<xs:element name="LayerId" msprop:Generator_ColumnVarNameInTable="columnLayerId" msprop:Generator_ColumnPropNameInRow="LayerId" msprop:Generator_ColumnPropNameInTable="LayerIdColumn" msprop:Generator_UserColumnName="LayerId" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Layers" msprop:Generator_TableClassName="LayersDataTable" msprop:Generator_TableVarName="tableLayers" msprop:Generator_TablePropName="Layers" msprop:Generator_RowDeletingName="LayersRowDeleting" msprop:Generator_RowChangingName="LayersRowChanging" msprop:Generator_RowEvHandlerName="LayersRowChangeEventHandler" msprop:Generator_RowDeletedName="LayersRowDeleted" msprop:Generator_UserTableName="Layers" msprop:Generator_RowChangedName="LayersRowChanged" msprop:Generator_RowEvArgName="LayersRowChangeEvent" msprop:Generator_RowClassName="LayersRow">
|
|
<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="Order" msprop:Generator_ColumnVarNameInTable="columnOrder" msprop:Generator_ColumnPropNameInRow="Order" msprop:Generator_ColumnPropNameInTable="OrderColumn" msprop:Generator_UserColumnName="Order" type="xs:int" />
|
|
<xs:element name="LayerName" msprop:Generator_ColumnVarNameInTable="columnLayerName" msprop:Generator_ColumnPropNameInRow="LayerName" msprop:Generator_ColumnPropNameInTable="LayerNameColumn" msprop:Generator_UserColumnName="LayerName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TechnologyName" msprop:Generator_ColumnVarNameInTable="columnTechnologyName" msprop:Generator_ColumnPropNameInRow="TechnologyName" msprop:Generator_ColumnPropNameInTable="TechnologyNameColumn" msprop:Generator_UserColumnName="TechnologyName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OpticalSchema" msprop:Generator_ColumnVarNameInTable="columnOpticalSchema" msprop:Generator_ColumnPropNameInRow="OpticalSchema" msprop:Generator_ColumnPropNameInTable="OpticalSchemaColumn" msprop:Generator_UserColumnName="OpticalSchema">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ProjectId" msprop:Generator_ColumnVarNameInTable="columnProjectId" msprop:Generator_ColumnPropNameInRow="ProjectId" msprop:Generator_ColumnPropNameInTable="ProjectIdColumn" msprop:Generator_UserColumnName="ProjectId" type="xs:int" />
|
|
<xs:element name="TechnologyId" msprop:Generator_ColumnVarNameInTable="columnTechnologyId" msprop:Generator_ColumnPropNameInRow="TechnologyId" msprop:Generator_ColumnPropNameInTable="TechnologyIdColumn" msprop:Generator_UserColumnName="TechnologyId" type="xs:int" />
|
|
<xs:element name="ArcWidth" msprop:Generator_ColumnVarNameInTable="columnArcWidth" msprop:Generator_ColumnPropNameInRow="ArcWidth" msprop:Generator_ColumnPropNameInTable="ArcWidthColumn" msprop:Generator_UserColumnName="ArcWidth" type="xs:int" />
|
|
<xs:element name="RadiusMax" msprop:Generator_ColumnVarNameInTable="columnRadiusMax" msprop:Generator_ColumnPropNameInRow="RadiusMax" msprop:Generator_ColumnPropNameInTable="RadiusMaxColumn" msprop:Generator_UserColumnName="RadiusMax" type="xs:double" />
|
|
<xs:element name="Step" msprop:Generator_ColumnVarNameInTable="columnStep" msprop:Generator_ColumnPropNameInRow="Step" msprop:Generator_ColumnPropNameInTable="StepColumn" msprop:Generator_UserColumnName="Step" type="xs:double" />
|
|
<xs:element name="SourceFilePath" msprop:Generator_ColumnVarNameInTable="columnSourceFilePath" msprop:Generator_ColumnPropNameInRow="SourceFilePath" msprop:Generator_ColumnPropNameInTable="SourceFilePathColumn" msprop:Generator_UserColumnName="SourceFilePath">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AnglesFilePath" msprop:Generator_ColumnVarNameInTable="columnAnglesFilePath" msprop:Generator_ColumnPropNameInRow="AnglesFilePath" msprop:Generator_ColumnPropNameInTable="AnglesFilePathColumn" msprop:Generator_UserColumnName="AnglesFilePath">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FullMask" msprop:Generator_ColumnVarNameInTable="columnFullMask" msprop:Generator_ColumnPropNameInRow="FullMask" msprop:Generator_ColumnPropNameInTable="FullMaskColumn" msprop:Generator_UserColumnName="FullMask" type="xs:int" minOccurs="0" />
|
|
<xs:element name="TileMask" msprop:Generator_ColumnVarNameInTable="columnTileMask" msprop:Generator_ColumnPropNameInRow="TileMask" msprop:Generator_ColumnPropNameInTable="TileMaskColumn" msprop:Generator_UserColumnName="TileMask" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Projects" msprop:Generator_TableClassName="ProjectsDataTable" msprop:Generator_TableVarName="tableProjects" msprop:Generator_TablePropName="Projects" msprop:Generator_RowDeletingName="ProjectsRowDeleting" msprop:Generator_RowChangingName="ProjectsRowChanging" msprop:Generator_RowEvHandlerName="ProjectsRowChangeEventHandler" msprop:Generator_RowDeletedName="ProjectsRowDeleted" msprop:Generator_UserTableName="Projects" msprop:Generator_RowChangedName="ProjectsRowChanged" msprop:Generator_RowEvArgName="ProjectsRowChangeEvent" msprop:Generator_RowClassName="ProjectsRow">
|
|
<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="ProjectName" msprop:Generator_ColumnVarNameInTable="columnProjectName" msprop:Generator_ColumnPropNameInRow="ProjectName" msprop:Generator_ColumnPropNameInTable="ProjectNameColumn" msprop:Generator_UserColumnName="ProjectName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OutPath" msprop:Generator_ColumnVarNameInTable="columnOutPath" msprop:Generator_ColumnPropNameInRow="OutPath" msprop:Generator_ColumnPropNameInTable="OutPathColumn" msprop:Generator_UserColumnName="OutPath">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Created" msprop:Generator_ColumnVarNameInTable="columnCreated" msprop:Generator_ColumnPropNameInRow="Created" msprop:Generator_ColumnPropNameInTable="CreatedColumn" msprop:Generator_UserColumnName="Created" type="xs:dateTime" />
|
|
<xs:element name="LastUpdated" msprop:Generator_ColumnVarNameInTable="columnLastUpdated" msprop:Generator_ColumnPropNameInRow="LastUpdated" msprop:Generator_ColumnPropNameInTable="LastUpdatedColumn" msprop:Generator_UserColumnName="LastUpdated" type="xs:dateTime" />
|
|
<xs:element name="HologramWidth" msprop:Generator_ColumnVarNameInTable="columnHologramWidth" msprop:Generator_ColumnPropNameInRow="HologramWidth" msprop:Generator_ColumnPropNameInTable="HologramWidthColumn" msprop:Generator_UserColumnName="HologramWidth" type="xs:double" />
|
|
<xs:element name="HologramHeight" msprop:Generator_ColumnVarNameInTable="columnHologramHeight" msprop:Generator_ColumnPropNameInRow="HologramHeight" msprop:Generator_ColumnPropNameInTable="HologramHeightColumn" msprop:Generator_UserColumnName="HologramHeight" type="xs:double" />
|
|
<xs:element name="FrameWidth" msprop:Generator_ColumnVarNameInTable="columnFrameWidth" msprop:Generator_ColumnPropNameInRow="FrameWidth" msprop:Generator_ColumnPropNameInTable="FrameWidthColumn" msprop:Generator_UserColumnName="FrameWidth" type="xs:double" />
|
|
<xs:element name="FrameHeight" msprop:Generator_ColumnVarNameInTable="columnFrameHeight" msprop:Generator_ColumnPropNameInRow="FrameHeight" msprop:Generator_ColumnPropNameInTable="FrameHeightColumn" msprop:Generator_UserColumnName="FrameHeight" type="xs:double" />
|
|
<xs:element name="FrameResolutionX" msprop:Generator_ColumnVarNameInTable="columnFrameResolutionX" msprop:Generator_ColumnPropNameInRow="FrameResolutionX" msprop:Generator_ColumnPropNameInTable="FrameResolutionXColumn" msprop:Generator_UserColumnName="FrameResolutionX" type="xs:int" />
|
|
<xs:element name="FrameResolutionY" msprop:Generator_ColumnVarNameInTable="columnFrameResolutionY" msprop:Generator_ColumnPropNameInRow="FrameResolutionY" msprop:Generator_ColumnPropNameInTable="FrameResolutionYColumn" msprop:Generator_UserColumnName="FrameResolutionY" type="xs:int" />
|
|
<xs:element name="GrayRangeHigh" msprop:Generator_ColumnVarNameInTable="columnGrayRangeHigh" msprop:Generator_ColumnPropNameInRow="GrayRangeHigh" msprop:Generator_ColumnPropNameInTable="GrayRangeHighColumn" msprop:Generator_UserColumnName="GrayRangeHigh" type="xs:int" />
|
|
<xs:element name="GrayRangeLow" msprop:Generator_ColumnVarNameInTable="columnGrayRangeLow" msprop:Generator_ColumnPropNameInRow="GrayRangeLow" msprop:Generator_ColumnPropNameInTable="GrayRangeLowColumn" msprop:Generator_UserColumnName="GrayRangeLow" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Technology" msprop:Generator_TableClassName="TechnologyDataTable" msprop:Generator_TableVarName="tableTechnology" msprop:Generator_TablePropName="Technology" msprop:Generator_RowDeletingName="TechnologyRowDeleting" msprop:Generator_RowChangingName="TechnologyRowChanging" msprop:Generator_RowEvHandlerName="TechnologyRowChangeEventHandler" msprop:Generator_RowDeletedName="TechnologyRowDeleted" msprop:Generator_UserTableName="Technology" msprop:Generator_RowChangedName="TechnologyRowChanged" msprop:Generator_RowEvArgName="TechnologyRowChangeEvent" msprop:Generator_RowClassName="TechnologyRow">
|
|
<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="TechnologyName" msprop:Generator_ColumnVarNameInTable="columnTechnologyName" msprop:Generator_ColumnPropNameInRow="TechnologyName" msprop:Generator_ColumnPropNameInTable="TechnologyNameColumn" msprop:Generator_UserColumnName="TechnologyName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ImagePath" msprop:Generator_ColumnVarNameInTable="columnImagePath" msprop:Generator_ColumnPropNameInRow="ImagePath" msprop:Generator_ColumnPropNameInTable="ImagePathColumn" msprop:Generator_UserColumnName="ImagePath">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AnglesPath" msprop:Generator_ColumnVarNameInTable="columnAnglesPath" msprop:Generator_ColumnPropNameInRow="AnglesPath" msprop:Generator_ColumnPropNameInTable="AnglesPathColumn" msprop:Generator_UserColumnName="AnglesPath">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Step" msprop:Generator_ColumnVarNameInTable="columnStep" msprop:Generator_ColumnPropNameInRow="Step" msprop:Generator_ColumnPropNameInTable="StepColumn" msprop:Generator_UserColumnName="Step" type="xs:double" />
|
|
<xs:element name="Radius" msprop:Generator_ColumnVarNameInTable="columnRadius" msprop:Generator_ColumnPropNameInRow="Radius" msprop:Generator_ColumnPropNameInTable="RadiusColumn" msprop:Generator_UserColumnName="Radius" type="xs:double" />
|
|
<xs:element name="ArcWidth" msprop:Generator_ColumnVarNameInTable="columnArcWidth" msprop:Generator_ColumnPropNameInRow="ArcWidth" msprop:Generator_ColumnPropNameInTable="ArcWidthColumn" msprop:Generator_UserColumnName="ArcWidth" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ColorProfiles" />
|
|
<xs:field xpath="mstns:Id" />
|
|
</xs:unique>
|
|
<xs:unique name="Layers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Layers" />
|
|
<xs:field xpath="mstns:Id" />
|
|
</xs:unique>
|
|
<xs:unique name="Projects_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Projects" />
|
|
<xs:field xpath="mstns:Id" />
|
|
</xs:unique>
|
|
<xs:unique name="Technology_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Technology" />
|
|
<xs:field xpath="mstns:Id" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK__ColorProf__Layer__64CCF2AE" msdata:parent="Layers" msdata:child="ColorProfiles" msdata:parentkey="Id" msdata:childkey="LayerId" msprop:Generator_UserChildTable="ColorProfiles" msprop:Generator_ChildPropName="GetColorProfilesRows" msprop:Generator_UserRelationName="FK__ColorProf__Layer__64CCF2AE" msprop:Generator_RelationVarName="relationFK__ColorProf__Layer__64CCF2AE" msprop:Generator_UserParentTable="Layers" msprop:Generator_ParentPropName="LayersRow" />
|
|
<msdata:Relationship name="FK__Layers__ProjectI__65C116E7" msdata:parent="Projects" msdata:child="Layers" msdata:parentkey="Id" msdata:childkey="ProjectId" msprop:Generator_UserChildTable="Layers" msprop:Generator_ChildPropName="GetLayersRows" msprop:Generator_UserRelationName="FK__Layers__ProjectI__65C116E7" msprop:Generator_RelationVarName="relationFK__Layers__ProjectI__65C116E7" msprop:Generator_UserParentTable="Projects" msprop:Generator_ParentPropName="ProjectsRow" />
|
|
<msdata:Relationship name="FK__Technology__Id__66B53B20" msdata:parent="Layers" msdata:child="Technology" msdata:parentkey="Id" msdata:childkey="Id" msprop:Generator_UserChildTable="Technology" msprop:Generator_ChildPropName="GetTechnologyRows" msprop:Generator_UserRelationName="FK__Technology__Id__66B53B20" msprop:Generator_ParentPropName="LayersRow" msprop:Generator_RelationVarName="relationFK__Technology__Id__66B53B20" msprop:Generator_UserParentTable="Layers" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |