568 lines
57 KiB
XML
568 lines
57 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="ROMasterDataSet" targetNamespace="http://tempuri.org/ROMasterDataSet.xsd" xmlns:mstns="http://tempuri.org/ROMasterDataSet.xsd" xmlns="http://tempuri.org/ROMasterDataSet.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="ROMasterConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="ROMasterConnectionString (Settings)" PropertyReference="ApplicationSettings.WestinghouseROImport.Properties.Settings.GlobalReference.Default.ROMasterConnectionString" Provider="System.Data.OleDb">
|
|
</Connection>
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RO000002TableAdapter" GeneratorDataComponentClassName="RO000002TableAdapter" Name="RO000002" UserDataComponentName="RO000002TableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ROMasterConnectionString (Settings)" DbObjectName="RO000002" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>DELETE FROM RO000002
|
|
WHERE (RecID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="RecID" DataSourceName="" DataTypeServer="DbType.StringFixedLength(8)" DbType="String" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="8" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>INSERT INTO `RO000002` (`RecID`, `RecType`, `ParentID`, `AccPageID`, `ModDateTime`, `Info`) VALUES (?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Info" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Info" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>SELECT RecID, RecType, ParentID, AccPageID, ModDateTime, Info
|
|
FROM RO000002
|
|
ORDER BY RecID</CommandText>
|
|
<Parameters>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="True">
|
|
<CommandText>UPDATE RO000002
|
|
SET RecType = ?, ParentID = ?, AccPageID = ?, ModDateTime = ?, Info = ?
|
|
WHERE (RecID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="RecType" DataSourceName="RO000002" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="ParentID" DataSourceName="RO000002" DataTypeServer="DbType.StringFixedLength(8)" DbType="String" Direction="Input" ParameterName="ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="8" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="AccPageID" DataSourceName="RO000002" DataTypeServer="DbType.StringFixedLength(32)" DbType="String" Direction="Input" ParameterName="AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="32" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="Param4" ColumnName="ModDateTime" DataSourceName="RO000002" DataTypeServer="DbType.StringFixedLength(14)" DbType="String" Direction="Input" ParameterName="ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="14" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="Param5" ColumnName="Info" DataSourceName="RO000002" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Info" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Info" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="Param6" ColumnName="RecID" DataSourceName="RO000002" DataTypeServer="DbType.StringFixedLength(8)" DbType="String" Direction="Input" ParameterName="Original_RecID" Precision="0" ProviderType="WChar" Scale="0" Size="8" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="RecID" DataSetColumn="RecID" />
|
|
<Mapping SourceColumn="RecType" DataSetColumn="RecType" />
|
|
<Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
|
|
<Mapping SourceColumn="AccPageID" DataSetColumn="AccPageID" />
|
|
<Mapping SourceColumn="ModDateTime" DataSetColumn="ModDateTime" />
|
|
<Mapping SourceColumn="Info" DataSetColumn="Info" />
|
|
</Mappings>
|
|
<Sources>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RO000003TableAdapter" GeneratorDataComponentClassName="RO000003TableAdapter" Name="RO000003" UserDataComponentName="RO000003TableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ROMasterConnectionString (Settings)" DbObjectName="RO000003" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>DELETE FROM RO000003
|
|
WHERE (RecID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="RecID" DataSourceName="" DataTypeServer="DbType.StringFixedLength(8)" DbType="String" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="8" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>INSERT INTO `RO000003` (`RecID`, `RecType`, `ParentID`, `AccPageID`, `ModDateTime`, `Info`) VALUES (?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Info" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Info" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>SELECT RecID, RecType, ParentID, AccPageID, ModDateTime, Info
|
|
FROM RO000003
|
|
ORDER BY RecID</CommandText>
|
|
<Parameters>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>UPDATE `RO000003` SET `RecID` = ?, `RecType` = ?, `ParentID` = ?, `AccPageID` = ?, `ModDateTime` = ?, `Info` = ? WHERE ((`RecID` = ?) AND ((? = 1 AND `RecType` IS NULL) OR (`RecType` = ?)) AND ((? = 1 AND `ParentID` IS NULL) OR (`ParentID` = ?)) AND ((? = 1 AND `AccPageID` IS NULL) OR (`AccPageID` = ?)) AND ((? = 1 AND `ModDateTime` IS NULL) OR (`ModDateTime` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Info" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Info" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ParentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AccPageID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ModDateTime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="RecID" DataSetColumn="RecID" />
|
|
<Mapping SourceColumn="RecType" DataSetColumn="RecType" />
|
|
<Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
|
|
<Mapping SourceColumn="AccPageID" DataSetColumn="AccPageID" />
|
|
<Mapping SourceColumn="ModDateTime" DataSetColumn="ModDateTime" />
|
|
<Mapping SourceColumn="Info" DataSetColumn="Info" />
|
|
</Mappings>
|
|
<Sources>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RO000004TableAdapter" GeneratorDataComponentClassName="RO000004TableAdapter" Name="RO000004" UserDataComponentName="RO000004TableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ROMasterConnectionString (Settings)" DbObjectName="RO000004" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>DELETE FROM RO000004
|
|
WHERE (RecID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="RecID" DataSourceName="" DataTypeServer="DbType.StringFixedLength(8)" DbType="String" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="8" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>INSERT INTO `RO000004` (`RecID`, `RecType`, `ParentID`, `AccPageID`, `ModDateTime`, `Info`) VALUES (?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Info" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Info" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>SELECT RecID, RecType, ParentID, AccPageID, ModDateTime, Info
|
|
FROM RO000004
|
|
ORDER BY RecID</CommandText>
|
|
<Parameters>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>UPDATE `RO000004` SET `RecID` = ?, `RecType` = ?, `ParentID` = ?, `AccPageID` = ?, `ModDateTime` = ?, `Info` = ? WHERE ((`RecID` = ?) AND ((? = 1 AND `RecType` IS NULL) OR (`RecType` = ?)) AND ((? = 1 AND `ParentID` IS NULL) OR (`ParentID` = ?)) AND ((? = 1 AND `AccPageID` IS NULL) OR (`AccPageID` = ?)) AND ((? = 1 AND `ModDateTime` IS NULL) OR (`ModDateTime` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Info" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Info" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ParentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AccPageID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ModDateTime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="RecID" DataSetColumn="RecID" />
|
|
<Mapping SourceColumn="RecType" DataSetColumn="RecType" />
|
|
<Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
|
|
<Mapping SourceColumn="AccPageID" DataSetColumn="AccPageID" />
|
|
<Mapping SourceColumn="ModDateTime" DataSetColumn="ModDateTime" />
|
|
<Mapping SourceColumn="Info" DataSetColumn="Info" />
|
|
</Mappings>
|
|
<Sources>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ROMASTERTableAdapter" GeneratorDataComponentClassName="ROMASTERTableAdapter" Name="ROMASTER" UserDataComponentName="ROMASTERTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ROMasterConnectionString (Settings)" DbObjectName="ROMASTER" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>DELETE FROM `ROMASTER` WHERE ((`RecID` = ?) AND ((? = 1 AND `RecType` IS NULL) OR (`RecType` = ?)) AND ((? = 1 AND `ParentID` IS NULL) OR (`ParentID` = ?)) AND ((? = 1 AND `AccPageID` IS NULL) OR (`AccPageID` = ?)) AND ((? = 1 AND `ModDateTime` IS NULL) OR (`ModDateTime` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ParentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AccPageID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ModDateTime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>INSERT INTO `ROMASTER` (`RecID`, `RecType`, `ParentID`, `AccPageID`, `ModDateTime`, `Info`) VALUES (?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Info" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Info" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>SELECT RecID, RecType, ParentID, AccPageID, ModDateTime, Info FROM ROMASTER</CommandText>
|
|
<Parameters>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="False">
|
|
<CommandText>UPDATE `ROMASTER` SET `RecID` = ?, `RecType` = ?, `ParentID` = ?, `AccPageID` = ?, `ModDateTime` = ?, `Info` = ? WHERE ((`RecID` = ?) AND ((? = 1 AND `RecType` IS NULL) OR (`RecType` = ?)) AND ((? = 1 AND `ParentID` IS NULL) OR (`ParentID` = ?)) AND ((? = 1 AND `AccPageID` IS NULL) OR (`AccPageID` = ?)) AND ((? = 1 AND `ModDateTime` IS NULL) OR (`ModDateTime` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Info" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Info" SourceColumnNullMapping="False" SourceVersion="Current">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_RecID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="RecID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RecType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RecType" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ParentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ParentID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AccPageID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_AccPageID" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="AccPageID" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ModDateTime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="True" SourceVersion="Original">
|
|
</Parameter>
|
|
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ModDateTime" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="ModDateTime" SourceColumnNullMapping="False" SourceVersion="Original">
|
|
</Parameter>
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="RecID" DataSetColumn="RecID" />
|
|
<Mapping SourceColumn="RecType" DataSetColumn="RecType" />
|
|
<Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
|
|
<Mapping SourceColumn="AccPageID" DataSetColumn="AccPageID" />
|
|
<Mapping SourceColumn="ModDateTime" DataSetColumn="ModDateTime" />
|
|
<Mapping SourceColumn="Info" DataSetColumn="Info" />
|
|
</Mappings>
|
|
<Sources>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources>
|
|
</Sources>
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="ROMasterDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ROMasterDataSet" msprop:Generator_DataSetName="ROMasterDataSet">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="RO000002" msprop:Generator_UserTableName="RO000002" msprop:Generator_RowDeletedName="RO000002RowDeleted" msprop:Generator_RowChangedName="RO000002RowChanged" msprop:Generator_RowClassName="RO000002Row" msprop:Generator_RowChangingName="RO000002RowChanging" msprop:Generator_RowEvArgName="RO000002RowChangeEvent" msprop:Generator_RowEvHandlerName="RO000002RowChangeEventHandler" msprop:Generator_TableClassName="RO000002DataTable" msprop:Generator_TableVarName="tableRO000002" msprop:Generator_RowDeletingName="RO000002RowDeleting" msprop:Generator_TablePropName="RO000002">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="RecID" msprop:Generator_UserColumnName="RecID" msprop:Generator_ColumnPropNameInRow="RecID" msprop:Generator_ColumnVarNameInTable="columnRecID" msprop:Generator_ColumnPropNameInTable="RecIDColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RecType" msprop:Generator_UserColumnName="RecType" msprop:Generator_ColumnPropNameInRow="RecType" msprop:Generator_ColumnVarNameInTable="columnRecType" msprop:Generator_ColumnPropNameInTable="RecTypeColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="ParentID" msprop:Generator_UserColumnName="ParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AccPageID" msprop:Generator_UserColumnName="AccPageID" msprop:Generator_ColumnPropNameInRow="AccPageID" msprop:Generator_ColumnVarNameInTable="columnAccPageID" msprop:Generator_ColumnPropNameInTable="AccPageIDColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="32" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ModDateTime" msprop:Generator_UserColumnName="ModDateTime" msprop:Generator_ColumnPropNameInRow="ModDateTime" msprop:Generator_ColumnVarNameInTable="columnModDateTime" msprop:Generator_ColumnPropNameInTable="ModDateTimeColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="14" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Info" msprop:Generator_UserColumnName="Info" msprop:Generator_ColumnPropNameInRow="Info" msprop:Generator_ColumnVarNameInTable="columnInfo" msprop:Generator_ColumnPropNameInTable="InfoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="RO000003" msprop:Generator_UserTableName="RO000003" msprop:Generator_RowDeletedName="RO000003RowDeleted" msprop:Generator_RowChangedName="RO000003RowChanged" msprop:Generator_RowClassName="RO000003Row" msprop:Generator_RowChangingName="RO000003RowChanging" msprop:Generator_RowEvArgName="RO000003RowChangeEvent" msprop:Generator_RowEvHandlerName="RO000003RowChangeEventHandler" msprop:Generator_TableClassName="RO000003DataTable" msprop:Generator_TableVarName="tableRO000003" msprop:Generator_RowDeletingName="RO000003RowDeleting" msprop:Generator_TablePropName="RO000003">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="RecID" msprop:Generator_UserColumnName="RecID" msprop:Generator_ColumnPropNameInRow="RecID" msprop:Generator_ColumnVarNameInTable="columnRecID" msprop:Generator_ColumnPropNameInTable="RecIDColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RecType" msprop:Generator_UserColumnName="RecType" msprop:Generator_ColumnPropNameInRow="RecType" msprop:Generator_ColumnVarNameInTable="columnRecType" msprop:Generator_ColumnPropNameInTable="RecTypeColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="ParentID" msprop:Generator_UserColumnName="ParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AccPageID" msprop:Generator_UserColumnName="AccPageID" msprop:Generator_ColumnPropNameInRow="AccPageID" msprop:Generator_ColumnVarNameInTable="columnAccPageID" msprop:Generator_ColumnPropNameInTable="AccPageIDColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="32" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ModDateTime" msprop:Generator_UserColumnName="ModDateTime" msprop:Generator_ColumnPropNameInRow="ModDateTime" msprop:Generator_ColumnVarNameInTable="columnModDateTime" msprop:Generator_ColumnPropNameInTable="ModDateTimeColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="14" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Info" msprop:Generator_UserColumnName="Info" msprop:Generator_ColumnPropNameInRow="Info" msprop:Generator_ColumnVarNameInTable="columnInfo" msprop:Generator_ColumnPropNameInTable="InfoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="RO000004" msprop:Generator_UserTableName="RO000004" msprop:Generator_RowDeletedName="RO000004RowDeleted" msprop:Generator_RowChangedName="RO000004RowChanged" msprop:Generator_RowClassName="RO000004Row" msprop:Generator_RowChangingName="RO000004RowChanging" msprop:Generator_RowEvArgName="RO000004RowChangeEvent" msprop:Generator_RowEvHandlerName="RO000004RowChangeEventHandler" msprop:Generator_TableClassName="RO000004DataTable" msprop:Generator_TableVarName="tableRO000004" msprop:Generator_RowDeletingName="RO000004RowDeleting" msprop:Generator_TablePropName="RO000004">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="RecID" msprop:Generator_UserColumnName="RecID" msprop:Generator_ColumnPropNameInRow="RecID" msprop:Generator_ColumnVarNameInTable="columnRecID" msprop:Generator_ColumnPropNameInTable="RecIDColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RecType" msprop:Generator_UserColumnName="RecType" msprop:Generator_ColumnPropNameInRow="RecType" msprop:Generator_ColumnVarNameInTable="columnRecType" msprop:Generator_ColumnPropNameInTable="RecTypeColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="ParentID" msprop:Generator_UserColumnName="ParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AccPageID" msprop:Generator_UserColumnName="AccPageID" msprop:Generator_ColumnPropNameInRow="AccPageID" msprop:Generator_ColumnVarNameInTable="columnAccPageID" msprop:Generator_ColumnPropNameInTable="AccPageIDColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="32" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ModDateTime" msprop:Generator_UserColumnName="ModDateTime" msprop:Generator_ColumnPropNameInRow="ModDateTime" msprop:Generator_ColumnVarNameInTable="columnModDateTime" msprop:Generator_ColumnPropNameInTable="ModDateTimeColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="14" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Info" msprop:Generator_UserColumnName="Info" msprop:Generator_ColumnPropNameInRow="Info" msprop:Generator_ColumnVarNameInTable="columnInfo" msprop:Generator_ColumnPropNameInTable="InfoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="ROMASTER" msprop:Generator_UserTableName="ROMASTER" msprop:Generator_RowDeletedName="ROMASTERRowDeleted" msprop:Generator_RowChangedName="ROMASTERRowChanged" msprop:Generator_RowClassName="ROMASTERRow" msprop:Generator_RowChangingName="ROMASTERRowChanging" msprop:Generator_RowEvArgName="ROMASTERRowChangeEvent" msprop:Generator_RowEvHandlerName="ROMASTERRowChangeEventHandler" msprop:Generator_TableClassName="ROMASTERDataTable" msprop:Generator_TableVarName="tableROMASTER" msprop:Generator_RowDeletingName="ROMASTERRowDeleting" msprop:Generator_TablePropName="ROMASTER">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="RecID" msprop:Generator_UserColumnName="RecID" msprop:Generator_ColumnPropNameInRow="RecID" msprop:Generator_ColumnVarNameInTable="columnRecID" msprop:Generator_ColumnPropNameInTable="RecIDColumn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RecType" msprop:Generator_UserColumnName="RecType" msprop:Generator_ColumnPropNameInRow="RecType" msprop:Generator_ColumnVarNameInTable="columnRecType" msprop:Generator_ColumnPropNameInTable="RecTypeColumn" type="xs:int" minOccurs="0" />
|
|
<xs:element name="ParentID" msprop:Generator_UserColumnName="ParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AccPageID" msprop:Generator_UserColumnName="AccPageID" msprop:Generator_ColumnPropNameInRow="AccPageID" msprop:Generator_ColumnVarNameInTable="columnAccPageID" msprop:Generator_ColumnPropNameInTable="AccPageIDColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="32" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ModDateTime" msprop:Generator_UserColumnName="ModDateTime" msprop:Generator_ColumnPropNameInRow="ModDateTime" msprop:Generator_ColumnVarNameInTable="columnModDateTime" msprop:Generator_ColumnPropNameInTable="ModDateTimeColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="14" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Info" msprop:Generator_UserColumnName="Info" msprop:Generator_ColumnPropNameInRow="Info" msprop:Generator_ColumnVarNameInTable="columnInfo" msprop:Generator_ColumnPropNameInTable="InfoColumn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:RO000002" />
|
|
<xs:field xpath="mstns:RecID" />
|
|
</xs:unique>
|
|
<xs:unique name="RO000003_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:RO000003" />
|
|
<xs:field xpath="mstns:RecID" />
|
|
</xs:unique>
|
|
<xs:unique name="RO000004_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:RO000004" />
|
|
<xs:field xpath="mstns:RecID" />
|
|
</xs:unique>
|
|
<xs:unique name="ROMASTER_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ROMASTER" />
|
|
<xs:field xpath="mstns:RecID" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |