1762 lines
236 KiB
XML
1762 lines
236 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DD_ECMAdmin" targetNamespace="http://tempuri.org/DD_ECMAdmin.xsd" xmlns:mstns="http://tempuri.org/DD_ECMAdmin.xsd" xmlns="http://tempuri.org/DD_ECMAdmin.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="MySettings" AppSettingsPropertyName="DD_DMSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DD_DMSConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DD_Record_Organizer.My.MySettings.GlobalReference.Default.DD_DMSConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBPMO_FORM_CONSTRUCTORTableAdapter" GeneratorDataComponentClassName="TBPMO_FORM_CONSTRUCTORTableAdapter" Name="TBPMO_FORM_CONSTRUCTOR" UserDataComponentName="TBPMO_FORM_CONSTRUCTORTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" 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 TBPMO_FORM_CONSTRUCTOR
|
|
WHERE (GUID = @Original_GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_GUID" ColumnName="GUID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>INSERT INTO TBPMO_FORM_CONSTRUCTOR
|
|
(FORM_TITLE, SEQUENCE_MENU, ADDED_WHO, MENU_IMG, SHORT_TITLE, LANGUAGE, NODE_NAVIGATION)
|
|
VALUES (@FORM_TITLE,@SEQUENCE_MENU,@ADDED_WHO,@MENU_IMG,@SHORT_TITLE,@LANGUAGE,@NODE_NAVIGATION);
|
|
SELECT GUID, FORM_TITLE, SEQUENCE_MENU, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN, MENU_IMG, SHORT_TITLE FROM TBPMO_FORM_CONSTRUCTOR WHERE (GUID = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="FORM_TITLE" ColumnName="FORM_TITLE" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@FORM_TITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="FORM_TITLE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SEQUENCE_MENU" ColumnName="SEQUENCE_MENU" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SEQUENCE_MENU" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SEQUENCE_MENU" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="ADDED_WHO" ColumnName="ADDED_WHO" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="MENU_IMG" ColumnName="MENU_IMG" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varbinary(MAX)" DbType="Binary" Direction="Input" ParameterName="@MENU_IMG" Precision="0" ProviderType="VarBinary" Scale="0" Size="2147483647" SourceColumn="MENU_IMG" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="SHORT_TITLE" ColumnName="SHORT_TITLE" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@SHORT_TITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="SHORT_TITLE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="LANGUAGE" ColumnName="LANGUAGE" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varchar(5)" DbType="AnsiString" Direction="Input" ParameterName="@LANGUAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumn="LANGUAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="NODE_NAVIGATION" ColumnName="NODE_NAVIGATION" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@NODE_NAVIGATION" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="NODE_NAVIGATION" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT GUID, dbo.FNPMO_GETOBJECTCAPTION(@LANGUAGE, 'CONSTR_MENUE' + CONVERT(VARCHAR(5), GUID), @SCREEN_ID) AS FORM_TITLE, SEQUENCE_MENU, ADDED_WHO, ADDED_WHEN, CHANGED_WHO,
|
|
CHANGED_WHEN, MENU_IMG, SHORT_TITLE, LANGUAGE, NODE_NAVIGATION
|
|
FROM TBPMO_FORM_CONSTRUCTOR</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="LANGUAGE" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@LANGUAGE" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SCREEN_ID" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SCREEN_ID" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>UPDATE TBPMO_FORM_CONSTRUCTOR
|
|
SET FORM_TITLE = @FORM_TITLE, SEQUENCE_MENU = @SEQUENCE_MENU, CHANGED_WHO = @CHANGED_WHO, MENU_IMG = @MENU_IMG, SHORT_TITLE = @SHORT_TITLE, LANGUAGE = @LANGUAGE,
|
|
NODE_NAVIGATION = @NODE_NAVIGATION
|
|
WHERE (GUID = @Original_GUID);
|
|
SELECT GUID, FORM_TITLE, SEQUENCE_MENU, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN, MENU_IMG, SHORT_TITLE FROM TBPMO_FORM_CONSTRUCTOR WHERE (GUID = @GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="FORM_TITLE" ColumnName="FORM_TITLE" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@FORM_TITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="FORM_TITLE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SEQUENCE_MENU" ColumnName="SEQUENCE_MENU" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SEQUENCE_MENU" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SEQUENCE_MENU" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="CHANGED_WHO" ColumnName="CHANGED_WHO" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="MENU_IMG" ColumnName="MENU_IMG" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varbinary(MAX)" DbType="Binary" Direction="Input" ParameterName="@MENU_IMG" Precision="0" ProviderType="VarBinary" Scale="0" Size="2147483647" SourceColumn="MENU_IMG" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="SHORT_TITLE" ColumnName="SHORT_TITLE" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@SHORT_TITLE" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="SHORT_TITLE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="LANGUAGE" ColumnName="LANGUAGE" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="varchar(5)" DbType="AnsiString" Direction="Input" ParameterName="@LANGUAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumn="LANGUAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="NODE_NAVIGATION" ColumnName="NODE_NAVIGATION" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@NODE_NAVIGATION" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="NODE_NAVIGATION" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_GUID" ColumnName="GUID" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="GUID" ColumnName="GUID" DataSourceName="DD_ECM.dbo.TBPMO_FORM_CONSTRUCTOR" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="FORM_TITLE" DataSetColumn="FORM_TITLE" />
|
|
<Mapping SourceColumn="SEQUENCE_MENU" DataSetColumn="SEQUENCE_MENU" />
|
|
<Mapping SourceColumn="ADDED_WHO" DataSetColumn="ADDED_WHO" />
|
|
<Mapping SourceColumn="ADDED_WHEN" DataSetColumn="ADDED_WHEN" />
|
|
<Mapping SourceColumn="CHANGED_WHO" DataSetColumn="CHANGED_WHO" />
|
|
<Mapping SourceColumn="CHANGED_WHEN" DataSetColumn="CHANGED_WHEN" />
|
|
<Mapping SourceColumn="MENU_IMG" DataSetColumn="MENU_IMG" />
|
|
<Mapping SourceColumn="SHORT_TITLE" DataSetColumn="SHORT_TITLE" />
|
|
<Mapping SourceColumn="LANGUAGE" DataSetColumn="LANGUAGE" />
|
|
<Mapping SourceColumn="NODE_NAVIGATION" DataSetColumn="NODE_NAVIGATION" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBPMO_FORM_CONSTRUCTOR_DETAILTableAdapter" GeneratorDataComponentClassName="TBPMO_FORM_CONSTRUCTOR_DETAILTableAdapter" Name="TBPMO_FORM_CONSTRUCTOR_DETAIL" UserDataComponentName="TBPMO_FORM_CONSTRUCTOR_DETAILTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" 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 TBPMO_FORM_CONSTRUCTOR_DETAIL
|
|
WHERE (GUID = @Original_GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_GUID" ColumnName="GUID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>INSERT INTO TBPMO_FORM_CONSTRUCTOR_DETAIL
|
|
(CONSTRUCT_ID, FORM_ID, PARENT_ID, LEVEL1_SELECT, SEQUENCE, SQL_SELECT_EBENE1, SQL_SELECT_EBENE2, ADDED_WHO, COLUMN_NAME1, COLUMN_NAME2, CONTROL_DOCTYPE_MATCH,
|
|
SQL_RIGHT_READ_AND_VIEW_ONLY, SQL_RIGHT_WINDREAM_VIEW)
|
|
VALUES (@CONSTRUCT_ID,@FORM_ID,@PARENT_ID,@LEVEL1_SELECT,@SEQUENCE,@SQL_SELECT_EBENE1,@SQL_SELECT_EBENE2,@ADDED_WHO,@COLUMN_NAME1,@COLUMN_NAME2,@CONTROL_DOCTYPE_MATCH,@SQL_RIGHT_READ_AND_VIEW_ONLY,@SQL_RIGHT_WINDREAM_VIEW);
|
|
SELECT GUID, CONSTRUCT_ID, FORM_ID, PARENT_ID, LEVEL1_SELECT, SEQUENCE, SQL_SELECT_EBENE1, SQL_SELECT_EBENE2, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN, COLUMN_NAME1, COLUMN_NAME2 FROM TBPMO_FORM_CONSTRUCTOR_DETAIL WHERE (GUID = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CONSTRUCT_ID" ColumnName="CONSTRUCT_ID" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CONSTRUCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CONSTRUCT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="FORM_ID" ColumnName="FORM_ID" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@FORM_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="PARENT_ID" ColumnName="PARENT_ID" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PARENT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PARENT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="LEVEL1_SELECT" ColumnName="LEVEL1_SELECT" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@LEVEL1_SELECT" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="LEVEL1_SELECT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SEQUENCE" ColumnName="SEQUENCE" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SEQUENCE" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SQL_SELECT_EBENE1" ColumnName="SQL_SELECT_EBENE1" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(4000)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_SELECT_EBENE1" Precision="0" ProviderType="VarChar" Scale="0" Size="4000" SourceColumn="SQL_SELECT_EBENE1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SQL_SELECT_EBENE2" ColumnName="SQL_SELECT_EBENE2" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(4000)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_SELECT_EBENE2" Precision="0" ProviderType="VarChar" Scale="0" Size="4000" SourceColumn="SQL_SELECT_EBENE2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="ADDED_WHO" ColumnName="ADDED_WHO" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="COLUMN_NAME1" ColumnName="COLUMN_NAME1" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@COLUMN_NAME1" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="COLUMN_NAME1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="COLUMN_NAME2" ColumnName="COLUMN_NAME2" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@COLUMN_NAME2" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="COLUMN_NAME2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CONTROL_DOCTYPE_MATCH" ColumnName="CONTROL_DOCTYPE_MATCH" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CONTROL_DOCTYPE_MATCH" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CONTROL_DOCTYPE_MATCH" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SQL_RIGHT_READ_AND_VIEW_ONLY" ColumnName="SQL_RIGHT_READ_AND_VIEW_ONLY" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(5000)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_RIGHT_READ_AND_VIEW_ONLY" Precision="0" ProviderType="VarChar" Scale="0" Size="5000" SourceColumn="SQL_RIGHT_READ_AND_VIEW_ONLY" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SQL_RIGHT_WINDREAM_VIEW" ColumnName="SQL_RIGHT_WINDREAM_VIEW" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(5000)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_RIGHT_WINDREAM_VIEW" Precision="0" ProviderType="VarChar" Scale="0" Size="5000" SourceColumn="SQL_RIGHT_WINDREAM_VIEW" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT GUID, CONSTRUCT_ID, FORM_ID, PARENT_ID, LEVEL1_SELECT, SEQUENCE, SQL_SELECT_EBENE1, SQL_SELECT_EBENE2, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN, COLUMN_NAME1,
|
|
COLUMN_NAME2, LOAD_DIRECT, SQL_QUICK_VIEW, CONTROL_DOCTYPE_MATCH, SQL_RIGHT_READ_AND_VIEW_ONLY, SQL_RIGHT_WINDREAM_VIEW, ADD_RECORDS
|
|
FROM TBPMO_FORM_CONSTRUCTOR_DETAIL
|
|
WHERE (GUID = @ID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="GUID" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>UPDATE TBPMO_FORM_CONSTRUCTOR_DETAIL
|
|
SET CONSTRUCT_ID = @CONSTRUCT_ID, FORM_ID = @FORM_ID, PARENT_ID = @PARENT_ID, LEVEL1_SELECT = @LEVEL1_SELECT, SEQUENCE = @SEQUENCE, SQL_SELECT_EBENE1 = @SQL_SELECT_EBENE1,
|
|
SQL_SELECT_EBENE2 = @SQL_SELECT_EBENE2, CHANGED_WHO = @CHANGED_WHO, COLUMN_NAME1 = @COLUMN_NAME1, COLUMN_NAME2 = @COLUMN_NAME2, LOAD_DIRECT = @LOAD_DIRECT,
|
|
CONTROL_DOCTYPE_MATCH = @CONTROL_DOCTYPE_MATCH, SQL_RIGHT_READ_AND_VIEW_ONLY = @SQL_RIGHT_READ_AND_VIEW_ONLY, SQL_RIGHT_WINDREAM_VIEW = @SQL_RIGHT_WINDREAM_VIEW,
|
|
ADD_RECORDS = @ADD_RECORDS
|
|
WHERE (GUID = @Original_GUID);
|
|
SELECT GUID, CONSTRUCT_ID, FORM_ID, PARENT_ID, LEVEL1_SELECT, SEQUENCE, SQL_SELECT_EBENE1, SQL_SELECT_EBENE2, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN, COLUMN_NAME1, COLUMN_NAME2 FROM TBPMO_FORM_CONSTRUCTOR_DETAIL WHERE (GUID = @GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CONSTRUCT_ID" ColumnName="CONSTRUCT_ID" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CONSTRUCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CONSTRUCT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="FORM_ID" ColumnName="FORM_ID" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@FORM_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="PARENT_ID" ColumnName="PARENT_ID" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PARENT_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PARENT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="LEVEL1_SELECT" ColumnName="LEVEL1_SELECT" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@LEVEL1_SELECT" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="LEVEL1_SELECT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SEQUENCE" ColumnName="SEQUENCE" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SEQUENCE" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SQL_SELECT_EBENE1" ColumnName="SQL_SELECT_EBENE1" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(4000)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_SELECT_EBENE1" Precision="0" ProviderType="VarChar" Scale="0" Size="4000" SourceColumn="SQL_SELECT_EBENE1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SQL_SELECT_EBENE2" ColumnName="SQL_SELECT_EBENE2" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(4000)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_SELECT_EBENE2" Precision="0" ProviderType="VarChar" Scale="0" Size="4000" SourceColumn="SQL_SELECT_EBENE2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="CHANGED_WHO" ColumnName="CHANGED_WHO" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="COLUMN_NAME1" ColumnName="COLUMN_NAME1" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@COLUMN_NAME1" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="COLUMN_NAME1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="COLUMN_NAME2" ColumnName="COLUMN_NAME2" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@COLUMN_NAME2" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="COLUMN_NAME2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="LOAD_DIRECT" ColumnName="LOAD_DIRECT" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@LOAD_DIRECT" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="LOAD_DIRECT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CONTROL_DOCTYPE_MATCH" ColumnName="CONTROL_DOCTYPE_MATCH" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CONTROL_DOCTYPE_MATCH" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CONTROL_DOCTYPE_MATCH" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SQL_RIGHT_READ_AND_VIEW_ONLY" ColumnName="SQL_RIGHT_READ_AND_VIEW_ONLY" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(5000)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_RIGHT_READ_AND_VIEW_ONLY" Precision="0" ProviderType="VarChar" Scale="0" Size="5000" SourceColumn="SQL_RIGHT_READ_AND_VIEW_ONLY" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SQL_RIGHT_WINDREAM_VIEW" ColumnName="SQL_RIGHT_WINDREAM_VIEW" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="varchar(5000)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_RIGHT_WINDREAM_VIEW" Precision="0" ProviderType="VarChar" Scale="0" Size="5000" SourceColumn="SQL_RIGHT_WINDREAM_VIEW" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="ADD_RECORDS" ColumnName="ADD_RECORDS" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@ADD_RECORDS" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="ADD_RECORDS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_GUID" ColumnName="GUID" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="GUID" ColumnName="GUID" DataSourceName="DD_ECM_TEST.dbo.TBPMO_FORM_CONSTRUCTOR_DETAIL" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="CONSTRUCT_ID" DataSetColumn="CONSTRUCT_ID" />
|
|
<Mapping SourceColumn="FORM_ID" DataSetColumn="FORM_ID" />
|
|
<Mapping SourceColumn="PARENT_ID" DataSetColumn="PARENT_ID" />
|
|
<Mapping SourceColumn="LEVEL1_SELECT" DataSetColumn="LEVEL1_SELECT" />
|
|
<Mapping SourceColumn="SEQUENCE" DataSetColumn="SEQUENCE" />
|
|
<Mapping SourceColumn="SQL_SELECT_EBENE1" DataSetColumn="SQL_SELECT_EBENE1" />
|
|
<Mapping SourceColumn="SQL_SELECT_EBENE2" DataSetColumn="SQL_SELECT_EBENE2" />
|
|
<Mapping SourceColumn="ADDED_WHO" DataSetColumn="ADDED_WHO" />
|
|
<Mapping SourceColumn="ADDED_WHEN" DataSetColumn="ADDED_WHEN" />
|
|
<Mapping SourceColumn="CHANGED_WHO" DataSetColumn="CHANGED_WHO" />
|
|
<Mapping SourceColumn="CHANGED_WHEN" DataSetColumn="CHANGED_WHEN" />
|
|
<Mapping SourceColumn="COLUMN_NAME1" DataSetColumn="COLUMN_NAME1" />
|
|
<Mapping SourceColumn="COLUMN_NAME2" DataSetColumn="COLUMN_NAME2" />
|
|
<Mapping SourceColumn="LOAD_DIRECT" DataSetColumn="LOAD_DIRECT" />
|
|
<Mapping SourceColumn="SQL_QUICK_VIEW" DataSetColumn="SQL_QUICK_VIEW" />
|
|
<Mapping SourceColumn="CONTROL_DOCTYPE_MATCH" DataSetColumn="CONTROL_DOCTYPE_MATCH" />
|
|
<Mapping SourceColumn="SQL_RIGHT_READ_AND_VIEW_ONLY" DataSetColumn="SQL_RIGHT_READ_AND_VIEW_ONLY" />
|
|
<Mapping SourceColumn="SQL_RIGHT_WINDREAM_VIEW" DataSetColumn="SQL_RIGHT_WINDREAM_VIEW" />
|
|
<Mapping SourceColumn="ADD_RECORDS" DataSetColumn="ADD_RECORDS" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBDD_CONNECTIONTableAdapter" GeneratorDataComponentClassName="TBDD_CONNECTIONTableAdapter" Name="TBDD_CONNECTION" UserDataComponentName="TBDD_CONNECTIONTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM.dbo.TBDD_CONNECTION" 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="true">
|
|
<CommandText>DELETE FROM TBDD_CONNECTION
|
|
WHERE (GUID = @Original_GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_GUID" ColumnName="GUID" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>INSERT INTO TBDD_CONNECTION
|
|
(BEZEICHNUNG, SQL_PROVIDER, SERVER, DATENBANK, USERNAME, PASSWORD, BEMERKUNG, AKTIV, ERSTELLTWER)
|
|
VALUES (@BEZEICHNUNG,@SQL_PROVIDER,@SERVER,@DATENBANK,@USERNAME,@PASSWORD,@BEMERKUNG,@AKTIV,@ERSTELLTWER);
|
|
SELECT GUID, BEZEICHNUNG, SQL_PROVIDER, SERVER, DATENBANK, USERNAME, PASSWORD, BEMERKUNG, AKTIV, ERSTELLTWER, ERSTELLTWANN, GEANDERTWER, GEAENDERTWANN FROM TBDD_CONNECTION WHERE (GUID = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="BEZEICHNUNG" ColumnName="BEZEICHNUNG" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@BEZEICHNUNG" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="BEZEICHNUNG" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="SQL_PROVIDER" ColumnName="SQL_PROVIDER" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_PROVIDER" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="SQL_PROVIDER" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="SERVER" ColumnName="SERVER" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@SERVER" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="SERVER" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="DATENBANK" ColumnName="DATENBANK" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@DATENBANK" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="DATENBANK" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="USERNAME" ColumnName="USERNAME" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@USERNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="USERNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="PASSWORD" ColumnName="PASSWORD" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@PASSWORD" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="PASSWORD" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="BEMERKUNG" ColumnName="BEMERKUNG" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(400)" DbType="AnsiString" Direction="Input" ParameterName="@BEMERKUNG" Precision="0" ProviderType="VarChar" Scale="0" Size="400" SourceColumn="BEMERKUNG" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="AKTIV" ColumnName="AKTIV" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@AKTIV" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="AKTIV" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="ERSTELLTWER" ColumnName="ERSTELLTWER" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@ERSTELLTWER" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="ERSTELLTWER" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT TBDD_CONNECTION.*
|
|
FROM TBDD_CONNECTION</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>UPDATE TBDD_CONNECTION
|
|
SET BEZEICHNUNG = @BEZEICHNUNG, SQL_PROVIDER = @SQL_PROVIDER, SERVER = @SERVER, DATENBANK = @DATENBANK, USERNAME = @USERNAME, PASSWORD = @PASSWORD,
|
|
BEMERKUNG = @BEMERKUNG, AKTIV = @AKTIV, GEANDERTWER = @GEANDERTWER
|
|
WHERE (GUID = @Original_GUID);
|
|
SELECT GUID, BEZEICHNUNG, SQL_PROVIDER, SERVER, DATENBANK, USERNAME, PASSWORD, BEMERKUNG, AKTIV, ERSTELLTWER, ERSTELLTWANN, GEANDERTWER, GEAENDERTWANN FROM TBDD_CONNECTION WHERE (GUID = @GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="BEZEICHNUNG" ColumnName="BEZEICHNUNG" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@BEZEICHNUNG" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="BEZEICHNUNG" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="SQL_PROVIDER" ColumnName="SQL_PROVIDER" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@SQL_PROVIDER" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="SQL_PROVIDER" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="SERVER" ColumnName="SERVER" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@SERVER" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="SERVER" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="DATENBANK" ColumnName="DATENBANK" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@DATENBANK" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="DATENBANK" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="USERNAME" ColumnName="USERNAME" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@USERNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="USERNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="PASSWORD" ColumnName="PASSWORD" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@PASSWORD" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="PASSWORD" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="BEMERKUNG" ColumnName="BEMERKUNG" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(400)" DbType="AnsiString" Direction="Input" ParameterName="@BEMERKUNG" Precision="0" ProviderType="VarChar" Scale="0" Size="400" SourceColumn="BEMERKUNG" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="AKTIV" ColumnName="AKTIV" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@AKTIV" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="AKTIV" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="GEANDERTWER" ColumnName="GEANDERTWER" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@GEANDERTWER" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="GEANDERTWER" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_GUID" ColumnName="GUID" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="GUID" ColumnName="GUID" DataSourceName="DD_ECM.dbo.TBDD_CONNECTION" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@GUID" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="BEZEICHNUNG" DataSetColumn="BEZEICHNUNG" />
|
|
<Mapping SourceColumn="SQL_PROVIDER" DataSetColumn="SQL_PROVIDER" />
|
|
<Mapping SourceColumn="SERVER" DataSetColumn="SERVER" />
|
|
<Mapping SourceColumn="DATENBANK" DataSetColumn="DATENBANK" />
|
|
<Mapping SourceColumn="USERNAME" DataSetColumn="USERNAME" />
|
|
<Mapping SourceColumn="PASSWORD" DataSetColumn="PASSWORD" />
|
|
<Mapping SourceColumn="BEMERKUNG" DataSetColumn="BEMERKUNG" />
|
|
<Mapping SourceColumn="AKTIV" DataSetColumn="AKTIV" />
|
|
<Mapping SourceColumn="ERSTELLTWER" DataSetColumn="ERSTELLTWER" />
|
|
<Mapping SourceColumn="ERSTELLTWANN" DataSetColumn="ERSTELLTWANN" />
|
|
<Mapping SourceColumn="GEANDERTWER" DataSetColumn="GEANDERTWER" />
|
|
<Mapping SourceColumn="GEAENDERTWANN" DataSetColumn="GEAENDERTWANN" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VWTEMPQUICKVIEWTableAdapter" GeneratorDataComponentClassName="VWTEMPQUICKVIEWTableAdapter" Name="VWTEMPQUICKVIEW" UserDataComponentName="VWTEMPQUICKVIEWTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM.dbo.VWTEMPQUICKVIEW" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT [Record-ID], Aktenzeichen, [Wiedergabe der Marke (Bild)], [Tag der Eintragung im Register], Aktenzustand
|
|
FROM VWTEMPQUICKVIEW</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Record-ID" DataSetColumn="Record-ID" />
|
|
<Mapping SourceColumn="Aktenzeichen" DataSetColumn="Aktenzeichen" />
|
|
<Mapping SourceColumn="Wiedergabe der Marke (Bild)" DataSetColumn="Wiedergabe der Marke (Bild)" />
|
|
<Mapping SourceColumn="Tag der Eintragung im Register" DataSetColumn="Tag der Eintragung im Register" />
|
|
<Mapping SourceColumn="Aktenzustand" DataSetColumn="Aktenzustand" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBWH_ENTITIESTableAdapter" GeneratorDataComponentClassName="TBWH_ENTITIESTableAdapter" Name="TBWH_ENTITIES" UserDataComponentName="TBWH_ENTITIESTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT T.GUID, T1.FORM_TITLE, dbo.FNPMO_GETOBJECTCAPTION(@LANGUAGE, 'FORMVIEW_TITLE' + CONVERT(VARCHAR(5), T1.GUID), @SCREEN) AS 'CAPTION'
|
|
FROM TBPMO_FORM AS T INNER JOIN
|
|
TBPMO_FORM_VIEW AS T1 ON T.GUID = T1.FORM_ID
|
|
WHERE (T.GUID IN
|
|
(SELECT DISTINCT ENTITY_ID
|
|
FROM TBPMO_CLIENT_ENTITY
|
|
WHERE (CLIENT_ID IN
|
|
(SELECT CLIENT_ID
|
|
FROM TBDD_CLIENT_USER
|
|
WHERE (USER_ID = @USER_ID)))))
|
|
ORDER BY 'CAPTION'</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="LANGUAGE" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@LANGUAGE" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SCREEN" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SCREEN" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="USER_ID" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@USER_ID" Precision="0" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="FORM_TITLE" DataSetColumn="FORM_TITLE" />
|
|
<Mapping SourceColumn="CAPTION" DataSetColumn="CAPTION" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBWH_USER_GROUPSTableAdapter" GeneratorDataComponentClassName="TBWH_USER_GROUPSTableAdapter" Name="TBWH_USER_GROUPS" UserDataComponentName="TBWH_USER_GROUPSTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM.dbo.TBDD_USER_GROUPS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT GUID, NAME
|
|
FROM TBDD_USER_GROUPS
|
|
ORDER BY NAME</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="NAME" DataSetColumn="NAME" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBPMO_SAP_FUBATableAdapter" GeneratorDataComponentClassName="TBPMO_SAP_FUBATableAdapter" Name="TBPMO_SAP_FUBA" UserDataComponentName="TBPMO_SAP_FUBATableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM.dbo.TBPMO_SAP_FUBA" 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 TBPMO_SAP_FUBA
|
|
WHERE (GUID = @Original_GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_GUID" ColumnName="GUID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>INSERT INTO TBPMO_SAP_FUBA
|
|
(NAME, COMMENT, TableName, Host, SystemNumber, UserName, Password, Client, Language, TempTableName, ACTIVE, ADDED_WHO, WHERE_CLAUSE, Method, FuBa_SplitCharacter)
|
|
VALUES (@NAME,@COMMENT,@TableName,@Host,@SystemNumber,@UserName,@Password,@Client,@Language,@TempTableName,@ACTIVE,@ADDED_WHO,@WHERE_CLAUSE,@Method,@FuBa_SplitCharacter);
|
|
SELECT GUID, NAME, COMMENT, TableName, Host, SystemNumber, UserName, Password, Client, Language, TempTableName, ACTIVE, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN FROM TBPMO_SAP_FUBA WHERE (GUID = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="NAME" ColumnName="NAME" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="COMMENT" ColumnName="COMMENT" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(500)" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumn="COMMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="TableName" ColumnName="TableName" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@TableName" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="TableName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Host" ColumnName="Host" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Host" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Host" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SystemNumber" ColumnName="SystemNumber" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@SystemNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="SystemNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="UserName" ColumnName="UserName" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Password" ColumnName="Password" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Client" ColumnName="Client" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Client" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Client" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Language" ColumnName="Language" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Language" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="TempTableName" ColumnName="TempTableName" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@TempTableName" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="TempTableName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="ACTIVE" ColumnName="ACTIVE" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="ACTIVE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="ADDED_WHO" ColumnName="ADDED_WHO" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="WHERE_CLAUSE" ColumnName="WHERE_CLAUSE" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(500)" DbType="AnsiString" Direction="Input" ParameterName="@WHERE_CLAUSE" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumn="WHERE_CLAUSE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Method" ColumnName="Method" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Method" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Method" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="FuBa_SplitCharacter" ColumnName="FuBa_SplitCharacter" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(1)" DbType="AnsiString" Direction="Input" ParameterName="@FuBa_SplitCharacter" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumn="FuBa_SplitCharacter" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT GUID, NAME, COMMENT, TableName, Host, SystemNumber, UserName, Password, Client, Language, TempTableName, WHERE_CLAUSE, ACTIVE, ADDED_WHO, ADDED_WHEN, CHANGED_WHO,
|
|
CHANGED_WHEN, Method, FuBa_SplitCharacter
|
|
FROM TBPMO_SAP_FUBA</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>UPDATE TBPMO_SAP_FUBA
|
|
SET NAME = @NAME, COMMENT = @COMMENT, TableName = @TableName, Host = @Host, SystemNumber = @SystemNumber, UserName = @UserName, Password = @Password, Client = @Client,
|
|
Language = @Language, TempTableName = @TempTableName, ACTIVE = @ACTIVE, CHANGED_WHO = @CHANGED_WHO, WHERE_CLAUSE = @WHERE_CLAUSE, Method = @Method,
|
|
FuBa_SplitCharacter = @FuBa_SplitCharacter
|
|
WHERE (GUID = @Original_GUID);
|
|
SELECT GUID, NAME, COMMENT, TableName, Host, SystemNumber, UserName, Password, Client, Language, TempTableName, ACTIVE, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN FROM TBPMO_SAP_FUBA WHERE (GUID = @GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="NAME" ColumnName="NAME" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="COMMENT" ColumnName="COMMENT" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(500)" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumn="COMMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="TableName" ColumnName="TableName" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@TableName" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="TableName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Host" ColumnName="Host" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Host" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Host" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="SystemNumber" ColumnName="SystemNumber" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@SystemNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="SystemNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="UserName" ColumnName="UserName" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Password" ColumnName="Password" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Client" ColumnName="Client" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Client" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Client" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Language" ColumnName="Language" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Language" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="TempTableName" ColumnName="TempTableName" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@TempTableName" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="TempTableName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="ACTIVE" ColumnName="ACTIVE" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="ACTIVE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="CHANGED_WHO" ColumnName="CHANGED_WHO" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="WHERE_CLAUSE" ColumnName="WHERE_CLAUSE" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(500)" DbType="AnsiString" Direction="Input" ParameterName="@WHERE_CLAUSE" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumn="WHERE_CLAUSE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Method" ColumnName="Method" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Method" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Method" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="FuBa_SplitCharacter" ColumnName="FuBa_SplitCharacter" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="varchar(1)" DbType="AnsiString" Direction="Input" ParameterName="@FuBa_SplitCharacter" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumn="FuBa_SplitCharacter" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Original_GUID" ColumnName="GUID" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="GUID" ColumnName="GUID" DataSourceName="DD_ECM.dbo.TBPMO_SAP_FUBA" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="NAME" DataSetColumn="NAME" />
|
|
<Mapping SourceColumn="COMMENT" DataSetColumn="COMMENT" />
|
|
<Mapping SourceColumn="TableName" DataSetColumn="TableName" />
|
|
<Mapping SourceColumn="Host" DataSetColumn="Host" />
|
|
<Mapping SourceColumn="SystemNumber" DataSetColumn="SystemNumber" />
|
|
<Mapping SourceColumn="UserName" DataSetColumn="UserName" />
|
|
<Mapping SourceColumn="Password" DataSetColumn="Password" />
|
|
<Mapping SourceColumn="Client" DataSetColumn="Client" />
|
|
<Mapping SourceColumn="Language" DataSetColumn="Language" />
|
|
<Mapping SourceColumn="TempTableName" DataSetColumn="TempTableName" />
|
|
<Mapping SourceColumn="ACTIVE" DataSetColumn="ACTIVE" />
|
|
<Mapping SourceColumn="ADDED_WHO" DataSetColumn="ADDED_WHO" />
|
|
<Mapping SourceColumn="ADDED_WHEN" DataSetColumn="ADDED_WHEN" />
|
|
<Mapping SourceColumn="CHANGED_WHO" DataSetColumn="CHANGED_WHO" />
|
|
<Mapping SourceColumn="CHANGED_WHEN" DataSetColumn="CHANGED_WHEN" />
|
|
<Mapping SourceColumn="WHERE_CLAUSE" DataSetColumn="WHERE_CLAUSE" />
|
|
<Mapping SourceColumn="Method" DataSetColumn="Method" />
|
|
<Mapping SourceColumn="FuBa_SplitCharacter" DataSetColumn="FuBa_SplitCharacter" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="USER_RIGHTSTableAdapter" GeneratorDataComponentClassName="USER_RIGHTSTableAdapter" Name="USER_RIGHTS" UserDataComponentName="USER_RIGHTSTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT T.GUID, dbo.FNPMO_GETOBJECTCAPTION(@LANGUAGE, 'FORMVIEW_TITLE' + CONVERT(VARCHAR(5), T3.GUID), 1) AS FORM_TITLE, T1.USERNAME, T1.NAME, T1.PRENAME, T.EDIT_REC, T.ADD_REC,
|
|
T.DELETE_REC, T.ADD_DOC, T.READ_ONLY_DOC, T.DELETE_DOC, T.FILES_VISIBLE, T.ADDED_WHEN, T.CHANGED_WHEN
|
|
FROM TBPMO_RIGHT_USER AS T INNER JOIN
|
|
TBDD_USER AS T1 ON T.USER_ID = T1.GUID INNER JOIN
|
|
TBPMO_FORM AS T2 ON T.ENTITY_ID = T2.GUID INNER JOIN
|
|
TBPMO_FORM_VIEW AS T3 ON T2.GUID = T3.FORM_ID
|
|
WHERE (T2.GUID = @ENTITY_ID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="LANGUAGE" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@LANGUAGE" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="ENTITY_ID" ColumnName="GUID" DataSourceName="DD_ECM_RENOLIT.dbo.TBPMO_FORM" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ENTITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="FORM_TITLE" DataSetColumn="FORM_TITLE" />
|
|
<Mapping SourceColumn="USERNAME" DataSetColumn="USERNAME" />
|
|
<Mapping SourceColumn="NAME" DataSetColumn="NAME" />
|
|
<Mapping SourceColumn="PRENAME" DataSetColumn="PRENAME" />
|
|
<Mapping SourceColumn="EDIT_REC" DataSetColumn="EDIT_REC" />
|
|
<Mapping SourceColumn="ADD_REC" DataSetColumn="ADD_REC" />
|
|
<Mapping SourceColumn="DELETE_REC" DataSetColumn="DELETE_REC" />
|
|
<Mapping SourceColumn="ADD_DOC" DataSetColumn="ADD_DOC" />
|
|
<Mapping SourceColumn="READ_ONLY_DOC" DataSetColumn="READ_ONLY_DOC" />
|
|
<Mapping SourceColumn="DELETE_DOC" DataSetColumn="DELETE_DOC" />
|
|
<Mapping SourceColumn="FILES_VISIBLE" DataSetColumn="FILES_VISIBLE" />
|
|
<Mapping SourceColumn="ADDED_WHEN" DataSetColumn="ADDED_WHEN" />
|
|
<Mapping SourceColumn="CHANGED_WHEN" DataSetColumn="CHANGED_WHEN" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGTableAdapter" GeneratorDataComponentClassName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGTableAdapter" Name="TBPMO_DOCSEARCH_RESULTLIST_CONFIG" UserDataComponentName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM_RENOLIT.dbo.TBPMO_DOCSEARCH_RESULTLIST_CONFIG" 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 [TBPMO_DOCSEARCH_RESULTLIST_CONFIG] WHERE ([GUID] = @Original_GUID) AND ([ENTITY_ID] = @Original_ENTITY_ID) AND ([LANGUAGE] = @Original_LANGUAGE) AND ([COLUMN_VIEW] = @Original_COLUMN_VIEW) AND ([HEADER_CAPTION] = @Original_HEADER_CAPTION) AND ([WIDTH] = @Original_WIDTH) AND ([TYPE_ID] = @Original_TYPE_ID) AND ([ADDED_WHO] = @Original_ADDED_WHO) AND (@IsNull_ADDED_WHEN = 1 AND [ADDED_WHEN] IS NULL) OR ([ADDED_WHEN] = @Original_ADDED_WHEN)) AND (@IsNull_CHANGED_WHO = 1 AND [CHANGED_WHO] IS NULL) OR ([CHANGED_WHO] = @Original_CHANGED_WHO)) AND (@IsNull_CHANGED_WHEN = 1 AND [CHANGED_WHEN] IS NULL) OR ([CHANGED_WHEN] = @Original_CHANGED_WHEN)) AND ([VISIBLE] = @Original_VISIBLE) AND ([EDITABLE] = @Original_EDITABLE) AND ([CONFIG_COLUMNS] = @Original_CONFIG_COLUMNS) AND ([SEQUENCE] = @Original_SEQUENCE))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ENTITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ENTITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LANGUAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LANGUAGE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COLUMN_VIEW" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COLUMN_VIEW" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HEADER_CAPTION" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HEADER_CAPTION" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WIDTH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WIDTH" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_TYPE_ID" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TYPE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADDED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_VISIBLE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="VISIBLE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EDITABLE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EDITABLE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CONFIG_COLUMNS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CONFIG_COLUMNS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SEQUENCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [TBPMO_DOCSEARCH_RESULTLIST_CONFIG] ([ENTITY_ID], [LANGUAGE], [COLUMN_VIEW], [HEADER_CAPTION], [WIDTH], [TYPE_ID], [ADDED_WHO], [ADDED_WHEN], [CHANGED_WHO], [CHANGED_WHEN], [VISIBLE], [EDITABLE], [CONFIG_COLUMNS], [SEQUENCE]) VALUES (@ENTITY_ID, @LANGUAGE, @COLUMN_VIEW, @HEADER_CAPTION, @WIDTH, @TYPE_ID, @ADDED_WHO, @ADDED_WHEN, @CHANGED_WHO, @CHANGED_WHEN, @VISIBLE, @EDITABLE, @CONFIG_COLUMNS, @SEQUENCE);
|
|
SELECT GUID, ENTITY_ID, LANGUAGE, COLUMN_VIEW, HEADER_CAPTION, WIDTH, TYPE_ID, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN, VISIBLE, EDITABLE, CONFIG_COLUMNS, SEQUENCE FROM TBPMO_DOCSEARCH_RESULTLIST_CONFIG WHERE (GUID = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ENTITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ENTITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LANGUAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LANGUAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COLUMN_VIEW" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COLUMN_VIEW" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HEADER_CAPTION" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HEADER_CAPTION" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@WIDTH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WIDTH" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@TYPE_ID" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TYPE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@VISIBLE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="VISIBLE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EDITABLE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EDITABLE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CONFIG_COLUMNS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CONFIG_COLUMNS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SEQUENCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT TBPMO_DOCSEARCH_RESULTLIST_CONFIG.*
|
|
FROM TBPMO_DOCSEARCH_RESULTLIST_CONFIG</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [TBPMO_DOCSEARCH_RESULTLIST_CONFIG] SET [ENTITY_ID] = @ENTITY_ID, [LANGUAGE] = @LANGUAGE, [COLUMN_VIEW] = @COLUMN_VIEW, [HEADER_CAPTION] = @HEADER_CAPTION, [WIDTH] = @WIDTH, [TYPE_ID] = @TYPE_ID, [ADDED_WHO] = @ADDED_WHO, [ADDED_WHEN] = @ADDED_WHEN, [CHANGED_WHO] = @CHANGED_WHO, [CHANGED_WHEN] = @CHANGED_WHEN, [VISIBLE] = @VISIBLE, [EDITABLE] = @EDITABLE, [CONFIG_COLUMNS] = @CONFIG_COLUMNS, [SEQUENCE] = @SEQUENCE WHERE ([GUID] = @Original_GUID) AND ([ENTITY_ID] = @Original_ENTITY_ID) AND ([LANGUAGE] = @Original_LANGUAGE) AND ([COLUMN_VIEW] = @Original_COLUMN_VIEW) AND ([HEADER_CAPTION] = @Original_HEADER_CAPTION) AND ([WIDTH] = @Original_WIDTH) AND ([TYPE_ID] = @Original_TYPE_ID) AND ([ADDED_WHO] = @Original_ADDED_WHO) AND (@IsNull_ADDED_WHEN = 1 AND [ADDED_WHEN] IS NULL) OR ([ADDED_WHEN] = @Original_ADDED_WHEN)) AND (@IsNull_CHANGED_WHO = 1 AND [CHANGED_WHO] IS NULL) OR ([CHANGED_WHO] = @Original_CHANGED_WHO)) AND (@IsNull_CHANGED_WHEN = 1 AND [CHANGED_WHEN] IS NULL) OR ([CHANGED_WHEN] = @Original_CHANGED_WHEN)) AND ([VISIBLE] = @Original_VISIBLE) AND ([EDITABLE] = @Original_EDITABLE) AND ([CONFIG_COLUMNS] = @Original_CONFIG_COLUMNS) AND ([SEQUENCE] = @Original_SEQUENCE));
|
|
SELECT GUID, ENTITY_ID, LANGUAGE, COLUMN_VIEW, HEADER_CAPTION, WIDTH, TYPE_ID, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN, VISIBLE, EDITABLE, CONFIG_COLUMNS, SEQUENCE FROM TBPMO_DOCSEARCH_RESULTLIST_CONFIG WHERE (GUID = @GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ENTITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ENTITY_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LANGUAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LANGUAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COLUMN_VIEW" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COLUMN_VIEW" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HEADER_CAPTION" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HEADER_CAPTION" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@WIDTH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WIDTH" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@TYPE_ID" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TYPE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@VISIBLE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="VISIBLE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EDITABLE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EDITABLE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CONFIG_COLUMNS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CONFIG_COLUMNS" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SEQUENCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ENTITY_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ENTITY_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LANGUAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LANGUAGE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COLUMN_VIEW" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COLUMN_VIEW" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HEADER_CAPTION" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HEADER_CAPTION" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WIDTH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WIDTH" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_TYPE_ID" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="TYPE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADDED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_VISIBLE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="VISIBLE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EDITABLE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EDITABLE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CONFIG_COLUMNS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CONFIG_COLUMNS" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SEQUENCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="GUID" ColumnName="GUID" DataSourceName="DD_ECM_RENOLIT.dbo.TBPMO_DOCSEARCH_RESULTLIST_CONFIG" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="ENTITY_ID" DataSetColumn="ENTITY_ID" />
|
|
<Mapping SourceColumn="LANGUAGE" DataSetColumn="LANGUAGE" />
|
|
<Mapping SourceColumn="COLUMN_VIEW" DataSetColumn="COLUMN_VIEW" />
|
|
<Mapping SourceColumn="HEADER_CAPTION" DataSetColumn="HEADER_CAPTION" />
|
|
<Mapping SourceColumn="WIDTH" DataSetColumn="WIDTH" />
|
|
<Mapping SourceColumn="TYPE_ID" DataSetColumn="TYPE_ID" />
|
|
<Mapping SourceColumn="ADDED_WHO" DataSetColumn="ADDED_WHO" />
|
|
<Mapping SourceColumn="ADDED_WHEN" DataSetColumn="ADDED_WHEN" />
|
|
<Mapping SourceColumn="CHANGED_WHO" DataSetColumn="CHANGED_WHO" />
|
|
<Mapping SourceColumn="CHANGED_WHEN" DataSetColumn="CHANGED_WHEN" />
|
|
<Mapping SourceColumn="VISIBLE" DataSetColumn="VISIBLE" />
|
|
<Mapping SourceColumn="EDITABLE" DataSetColumn="EDITABLE" />
|
|
<Mapping SourceColumn="CONFIG_COLUMNS" DataSetColumn="CONFIG_COLUMNS" />
|
|
<Mapping SourceColumn="SEQUENCE" DataSetColumn="SEQUENCE" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VWDD_LOGIN_USER_HISTORYTableAdapter" GeneratorDataComponentClassName="VWDD_LOGIN_USER_HISTORYTableAdapter" Name="VWDD_LOGIN_USER_HISTORY" UserDataComponentName="VWDD_LOGIN_USER_HISTORYTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM_RENOLIT.dbo.VWDD_LOGIN_USER_HISTORY" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT GUID, MODULE, USERNAME, NAME, PRENAME, USER_ID, CLIENT_ID, CLIENT_NAME, LOGIN, LOGOUT, VERSION_CLIENT, MACHINE_NAME
|
|
FROM VWDD_LOGIN_USER_HISTORY
|
|
WHERE (MODULE = 'Record-Organizer')
|
|
ORDER BY GUID DESC</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="MODULE" DataSetColumn="MODULE" />
|
|
<Mapping SourceColumn="USERNAME" DataSetColumn="USERNAME" />
|
|
<Mapping SourceColumn="NAME" DataSetColumn="NAME" />
|
|
<Mapping SourceColumn="PRENAME" DataSetColumn="PRENAME" />
|
|
<Mapping SourceColumn="USER_ID" DataSetColumn="USER_ID" />
|
|
<Mapping SourceColumn="CLIENT_ID" DataSetColumn="CLIENT_ID" />
|
|
<Mapping SourceColumn="CLIENT_NAME" DataSetColumn="CLIENT_NAME" />
|
|
<Mapping SourceColumn="LOGIN" DataSetColumn="LOGIN" />
|
|
<Mapping SourceColumn="LOGOUT" DataSetColumn="LOGOUT" />
|
|
<Mapping SourceColumn="VERSION_CLIENT" DataSetColumn="VERSION_CLIENT" />
|
|
<Mapping SourceColumn="MACHINE_NAME" DataSetColumn="MACHINE_NAME" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDTableAdapter" GeneratorDataComponentClassName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDTableAdapter" Name="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_ID" UserDataComponentName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT CONVERT(TINYINT, 1) AS ID, 'TextBox' AS Name
|
|
UNION
|
|
SELECT CONVERT(TINYINT, 2) AS ID, 'CheckBox' AS Name
|
|
UNION
|
|
SELECT CONVERT(TINYINT, 3) AS ID, 'ComboBox' AS Name
|
|
UNION
|
|
SELECT CONVERT(TINYINT, 4) AS ID, 'DatePicker' AS Name
|
|
FROM TBPMO_DOCSEARCH_RESULTLIST_CONFIG</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Name" DataSetColumn="Name" />
|
|
<Mapping SourceColumn="ID" DataSetColumn="ID" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBPMO_LOG_ESSENTIALSTableAdapter" GeneratorDataComponentClassName="TBPMO_LOG_ESSENTIALSTableAdapter" Name="TBPMO_LOG_ESSENTIALS" UserDataComponentName="TBPMO_LOG_ESSENTIALSTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM_RENOLIT.dbo.TBPMO_LOG_ESSENTIALS" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM [TBPMO_LOG_ESSENTIALS] WHERE ([GUID] = @Original_GUID))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [TBPMO_LOG_ESSENTIALS] ([REFERENCE_KEY], [REFERENCE_STRING], [COMMENT], [ADDED_WHO], [ADDED_WHEN]) VALUES (@REFERENCE_KEY, @REFERENCE_STRING, @COMMENT, @ADDED_WHO, @ADDED_WHEN);
|
|
SELECT CONVERT (BIT, 0) AS Selection, GUID, REFERENCE_KEY, REFERENCE_STRING, COMMENT, ADDED_WHO, ADDED_WHEN FROM TBPMO_LOG_ESSENTIALS WHERE (GUID = SCOPE_IDENTITY()) ORDER BY GUID DESC</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@REFERENCE_KEY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REFERENCE_KEY" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REFERENCE_STRING" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFERENCE_STRING" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT CONVERT(BIT, 0) AS Selection, GUID, REFERENCE_KEY, REFERENCE_STRING, COMMENT, ADDED_WHO, ADDED_WHEN
|
|
FROM TBPMO_LOG_ESSENTIALS
|
|
ORDER BY GUID DESC</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [TBPMO_LOG_ESSENTIALS] SET [REFERENCE_KEY] = @REFERENCE_KEY, [REFERENCE_STRING] = @REFERENCE_STRING, [COMMENT] = @COMMENT, [ADDED_WHO] = @ADDED_WHO, [ADDED_WHEN] = @ADDED_WHEN WHERE ([GUID] = @Original_GUID));
|
|
SELECT CONVERT (BIT, 0) AS Selection, GUID, REFERENCE_KEY, REFERENCE_STRING, COMMENT, ADDED_WHO, ADDED_WHEN FROM TBPMO_LOG_ESSENTIALS WHERE (GUID = @GUID) ORDER BY GUID DESC</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@REFERENCE_KEY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REFERENCE_KEY" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REFERENCE_STRING" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFERENCE_STRING" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="GUID" ColumnName="GUID" DataSourceName="DD_ECM_RENOLIT.dbo.TBPMO_LOG_ESSENTIALS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="REFERENCE_KEY" DataSetColumn="REFERENCE_KEY" />
|
|
<Mapping SourceColumn="REFERENCE_STRING" DataSetColumn="REFERENCE_STRING" />
|
|
<Mapping SourceColumn="COMMENT" DataSetColumn="COMMENT" />
|
|
<Mapping SourceColumn="ADDED_WHO" DataSetColumn="ADDED_WHO" />
|
|
<Mapping SourceColumn="ADDED_WHEN" DataSetColumn="ADDED_WHEN" />
|
|
<Mapping SourceColumn="Selection" DataSetColumn="Selection" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBPMO_DOCRESULT_DROPDOWN_ITEMSTableAdapter" GeneratorDataComponentClassName="TBPMO_DOCRESULT_DROPDOWN_ITEMSTableAdapter" Name="TBPMO_DOCRESULT_DROPDOWN_ITEMS" UserDataComponentName="TBPMO_DOCRESULT_DROPDOWN_ITEMSTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM_RENOLIT.dbo.TBPMO_DOCRESULT_DROPDOWN_ITEMS" 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 [TBPMO_DOCRESULT_DROPDOWN_ITEMS] WHERE ([GUID] = @Original_GUID) AND ([CONFIG_ID] = @Original_CONFIG_ID) AND ([VALUE] = @Original_VALUE) AND ([SEQUENCE] = @Original_SEQUENCE) AND ([DEFAULT] = @Original_DEFAULT) AND ([COLOR] = @Original_COLOR) AND ([ADDED_WHO] = @Original_ADDED_WHO) AND (@IsNull_ADDED_WHEN = 1 AND [ADDED_WHEN] IS NULL) OR ([ADDED_WHEN] = @Original_ADDED_WHEN)) AND (@IsNull_CHANGED_WHO = 1 AND [CHANGED_WHO] IS NULL) OR ([CHANGED_WHO] = @Original_CHANGED_WHO)) AND (@IsNull_CHANGED_WHEN = 1 AND [CHANGED_WHEN] IS NULL) OR ([CHANGED_WHEN] = @Original_CHANGED_WHEN)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CONFIG_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CONFIG_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VALUE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_SEQUENCE" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DEFAULT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DEFAULT" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COLOR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COLOR" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADDED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [TBPMO_DOCRESULT_DROPDOWN_ITEMS] ([CONFIG_ID], [VALUE], [SEQUENCE], [DEFAULT], [COLOR], [ADDED_WHO], [ADDED_WHEN], [CHANGED_WHO], [CHANGED_WHEN]) VALUES (@CONFIG_ID, @VALUE, @SEQUENCE, @DEFAULT, @COLOR, @ADDED_WHO, @ADDED_WHEN, @CHANGED_WHO, @CHANGED_WHEN);
|
|
SELECT GUID, CONFIG_ID, VALUE, SEQUENCE, [DEFAULT], COLOR, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN FROM TBPMO_DOCRESULT_DROPDOWN_ITEMS WHERE (GUID = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CONFIG_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CONFIG_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VALUE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@SEQUENCE" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DEFAULT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DEFAULT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COLOR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COLOR" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT GUID, CONFIG_ID, VALUE, SEQUENCE, [DEFAULT], COLOR, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN
|
|
FROM TBPMO_DOCRESULT_DROPDOWN_ITEMS
|
|
WHERE (CONFIG_ID = @CONFIG_ID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="CONFIG_ID" ColumnName="CONFIG_ID" DataSourceName="DD_ECM_RENOLIT.dbo.TBPMO_DOCRESULT_DROPDOWN_ITEMS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CONFIG_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CONFIG_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [TBPMO_DOCRESULT_DROPDOWN_ITEMS] SET [CONFIG_ID] = @CONFIG_ID, [VALUE] = @VALUE, [SEQUENCE] = @SEQUENCE, [DEFAULT] = @DEFAULT, [COLOR] = @COLOR, [ADDED_WHO] = @ADDED_WHO, [ADDED_WHEN] = @ADDED_WHEN, [CHANGED_WHO] = @CHANGED_WHO, [CHANGED_WHEN] = @CHANGED_WHEN WHERE ([GUID] = @Original_GUID) AND ([CONFIG_ID] = @Original_CONFIG_ID) AND ([VALUE] = @Original_VALUE) AND ([SEQUENCE] = @Original_SEQUENCE) AND ([DEFAULT] = @Original_DEFAULT) AND ([COLOR] = @Original_COLOR) AND ([ADDED_WHO] = @Original_ADDED_WHO) AND (@IsNull_ADDED_WHEN = 1 AND [ADDED_WHEN] IS NULL) OR ([ADDED_WHEN] = @Original_ADDED_WHEN)) AND (@IsNull_CHANGED_WHO = 1 AND [CHANGED_WHO] IS NULL) OR ([CHANGED_WHO] = @Original_CHANGED_WHO)) AND (@IsNull_CHANGED_WHEN = 1 AND [CHANGED_WHEN] IS NULL) OR ([CHANGED_WHEN] = @Original_CHANGED_WHEN)));
|
|
SELECT GUID, CONFIG_ID, VALUE, SEQUENCE, [DEFAULT], COLOR, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN FROM TBPMO_DOCRESULT_DROPDOWN_ITEMS WHERE (GUID = @GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CONFIG_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CONFIG_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VALUE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@SEQUENCE" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DEFAULT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DEFAULT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COLOR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COLOR" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CONFIG_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CONFIG_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VALUE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_SEQUENCE" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="SEQUENCE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DEFAULT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DEFAULT" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COLOR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COLOR" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADDED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="GUID" ColumnName="GUID" DataSourceName="DD_ECM_RENOLIT.dbo.TBPMO_DOCRESULT_DROPDOWN_ITEMS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="CONFIG_ID" DataSetColumn="CONFIG_ID" />
|
|
<Mapping SourceColumn="VALUE" DataSetColumn="VALUE" />
|
|
<Mapping SourceColumn="SEQUENCE" DataSetColumn="SEQUENCE" />
|
|
<Mapping SourceColumn="DEFAULT" DataSetColumn="DEFAULT" />
|
|
<Mapping SourceColumn="COLOR" DataSetColumn="COLOR" />
|
|
<Mapping SourceColumn="ADDED_WHO" DataSetColumn="ADDED_WHO" />
|
|
<Mapping SourceColumn="ADDED_WHEN" DataSetColumn="ADDED_WHEN" />
|
|
<Mapping SourceColumn="CHANGED_WHO" DataSetColumn="CHANGED_WHO" />
|
|
<Mapping SourceColumn="CHANGED_WHEN" DataSetColumn="CHANGED_WHEN" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TBDD_GROUPSTableAdapter" GeneratorDataComponentClassName="TBDD_GROUPSTableAdapter" Name="TBDD_GROUPS" UserDataComponentName="TBDD_GROUPSTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM_RENOLIT.dbo.TBDD_GROUPS" 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 [TBDD_GROUPS] WHERE ([GUID] = @Original_GUID) AND (@IsNull_NAME = 1 AND [NAME] IS NULL) OR ([NAME] = @Original_NAME)) AND ([ECM_FK_ID] = @Original_ECM_FK_ID) AND ([AD_SYNC] = @Original_AD_SYNC) AND ([INTERNAL] = @Original_INTERNAL) AND ([ACTIVE] = @Original_ACTIVE) AND (@IsNull_COMMENT = 1 AND [COMMENT] IS NULL) OR ([COMMENT] = @Original_COMMENT)) AND (@IsNull_ADDED_WHO = 1 AND [ADDED_WHO] IS NULL) OR ([ADDED_WHO] = @Original_ADDED_WHO)) AND (@IsNull_ADDED_WHEN = 1 AND [ADDED_WHEN] IS NULL) OR ([ADDED_WHEN] = @Original_ADDED_WHEN)) AND (@IsNull_CHANGED_WHO = 1 AND [CHANGED_WHO] IS NULL) OR ([CHANGED_WHO] = @Original_CHANGED_WHO)) AND (@IsNull_CHANGED_WHEN = 1 AND [CHANGED_WHEN] IS NULL) OR ([CHANGED_WHEN] = @Original_CHANGED_WHEN)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ECM_FK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ECM_FK_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AD_SYNC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AD_SYNC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_INTERNAL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="INTERNAL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACTIVE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COMMENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COMMENT" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COMMENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADDED_WHO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADDED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [TBDD_GROUPS] ([NAME], [ECM_FK_ID], [AD_SYNC], [INTERNAL], [ACTIVE], [COMMENT], [ADDED_WHO], [ADDED_WHEN], [CHANGED_WHO], [CHANGED_WHEN]) VALUES (@NAME, @ECM_FK_ID, @AD_SYNC, @INTERNAL, @ACTIVE, @COMMENT, @ADDED_WHO, @ADDED_WHEN, @CHANGED_WHO, @CHANGED_WHEN);
|
|
SELECT GUID, NAME, ECM_FK_ID, AD_SYNC, INTERNAL, ACTIVE, COMMENT, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN FROM TBDD_GROUPS WHERE (GUID = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ECM_FK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ECM_FK_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AD_SYNC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AD_SYNC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@INTERNAL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="INTERNAL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACTIVE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT GUID, NAME, ECM_FK_ID, AD_SYNC, INTERNAL, ACTIVE, COMMENT, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN
|
|
FROM TBDD_GROUPS</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [TBDD_GROUPS] SET [NAME] = @NAME, [ECM_FK_ID] = @ECM_FK_ID, [AD_SYNC] = @AD_SYNC, [INTERNAL] = @INTERNAL, [ACTIVE] = @ACTIVE, [COMMENT] = @COMMENT, [ADDED_WHO] = @ADDED_WHO, [ADDED_WHEN] = @ADDED_WHEN, [CHANGED_WHO] = @CHANGED_WHO, [CHANGED_WHEN] = @CHANGED_WHEN WHERE ([GUID] = @Original_GUID) AND (@IsNull_NAME = 1 AND [NAME] IS NULL) OR ([NAME] = @Original_NAME)) AND ([ECM_FK_ID] = @Original_ECM_FK_ID) AND ([AD_SYNC] = @Original_AD_SYNC) AND ([INTERNAL] = @Original_INTERNAL) AND ([ACTIVE] = @Original_ACTIVE) AND (@IsNull_COMMENT = 1 AND [COMMENT] IS NULL) OR ([COMMENT] = @Original_COMMENT)) AND (@IsNull_ADDED_WHO = 1 AND [ADDED_WHO] IS NULL) OR ([ADDED_WHO] = @Original_ADDED_WHO)) AND (@IsNull_ADDED_WHEN = 1 AND [ADDED_WHEN] IS NULL) OR ([ADDED_WHEN] = @Original_ADDED_WHEN)) AND (@IsNull_CHANGED_WHO = 1 AND [CHANGED_WHO] IS NULL) OR ([CHANGED_WHO] = @Original_CHANGED_WHO)) AND (@IsNull_CHANGED_WHEN = 1 AND [CHANGED_WHEN] IS NULL) OR ([CHANGED_WHEN] = @Original_CHANGED_WHEN)));
|
|
SELECT GUID, NAME, ECM_FK_ID, AD_SYNC, INTERNAL, ACTIVE, COMMENT, ADDED_WHO, ADDED_WHEN, CHANGED_WHO, CHANGED_WHEN FROM TBDD_GROUPS WHERE (GUID = @GUID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ECM_FK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ECM_FK_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AD_SYNC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AD_SYNC" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@INTERNAL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="INTERNAL" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACTIVE" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@COMMENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ECM_FK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ECM_FK_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AD_SYNC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AD_SYNC" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_INTERNAL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="INTERNAL" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ACTIVE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ACTIVE" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COMMENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="COMMENT" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_COMMENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COMMENT" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADDED_WHO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ADDED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADDED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADDED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ADDED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ADDED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHANGED_WHO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHANGED_WHO" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHANGED_WHEN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CHANGED_WHEN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CHANGED_WHEN" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="GUID" ColumnName="GUID" DataSourceName="DD_ECM_RENOLIT.dbo.TBDD_GROUPS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GUID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GUID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GUID" DataSetColumn="GUID" />
|
|
<Mapping SourceColumn="NAME" DataSetColumn="NAME" />
|
|
<Mapping SourceColumn="ECM_FK_ID" DataSetColumn="ECM_FK_ID" />
|
|
<Mapping SourceColumn="AD_SYNC" DataSetColumn="AD_SYNC" />
|
|
<Mapping SourceColumn="INTERNAL" DataSetColumn="INTERNAL" />
|
|
<Mapping SourceColumn="ACTIVE" DataSetColumn="ACTIVE" />
|
|
<Mapping SourceColumn="COMMENT" DataSetColumn="COMMENT" />
|
|
<Mapping SourceColumn="ADDED_WHO" DataSetColumn="ADDED_WHO" />
|
|
<Mapping SourceColumn="ADDED_WHEN" DataSetColumn="ADDED_WHEN" />
|
|
<Mapping SourceColumn="CHANGED_WHO" DataSetColumn="CHANGED_WHO" />
|
|
<Mapping SourceColumn="CHANGED_WHEN" DataSetColumn="CHANGED_WHEN" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VWPMO_RIGHT_GROUPTableAdapter" GeneratorDataComponentClassName="VWPMO_RIGHT_GROUPTableAdapter" Name="VWPMO_RIGHT_GROUP" UserDataComponentName="VWPMO_RIGHT_GROUPTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DD_DMSConnectionString (MySettings)" DbObjectName="DD_ECM.dbo.VWPMO_RIGHT_GROUP" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT * FROM VWPMO_RIGHT_GROUP</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="ID" DataSetColumn="ID" />
|
|
<Mapping SourceColumn="ENTITY_ID" DataSetColumn="ENTITY_ID" />
|
|
<Mapping SourceColumn="ENTITY_NAME" DataSetColumn="ENTITY_NAME" />
|
|
<Mapping SourceColumn="GROUP_ID" DataSetColumn="GROUP_ID" />
|
|
<Mapping SourceColumn="GROUP_NAME" DataSetColumn="GROUP_NAME" />
|
|
<Mapping SourceColumn="EDIT_REC" DataSetColumn="EDIT_REC" />
|
|
<Mapping SourceColumn="ADD_REC" DataSetColumn="ADD_REC" />
|
|
<Mapping SourceColumn="DELETE_REC" DataSetColumn="DELETE_REC" />
|
|
<Mapping SourceColumn="ADD_DOC" DataSetColumn="ADD_DOC" />
|
|
<Mapping SourceColumn="VIEW_DOC" DataSetColumn="VIEW_DOC" />
|
|
<Mapping SourceColumn="DELETE_DOC" DataSetColumn="DELETE_DOC" />
|
|
<Mapping SourceColumn="ADDED_WHO" DataSetColumn="ADDED_WHO" />
|
|
<Mapping SourceColumn="ADDED_WHEN" DataSetColumn="ADDED_WHEN" />
|
|
<Mapping SourceColumn="CHANGED_WHO" DataSetColumn="CHANGED_WHO" />
|
|
<Mapping SourceColumn="CHANGED_WHEN" DataSetColumn="CHANGED_WHEN" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DD_ECMAdmin" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DD_ECMAdmin" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DD_ECMAdmin">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="TBPMO_FORM_CONSTRUCTOR" msprop:Generator_RowClassName="TBPMO_FORM_CONSTRUCTORRow" msprop:Generator_RowEvHandlerName="TBPMO_FORM_CONSTRUCTORRowChangeEventHandler" msprop:Generator_RowDeletedName="TBPMO_FORM_CONSTRUCTORRowDeleted" msprop:Generator_RowDeletingName="TBPMO_FORM_CONSTRUCTORRowDeleting" msprop:Generator_RowEvArgName="TBPMO_FORM_CONSTRUCTORRowChangeEvent" msprop:Generator_TablePropName="TBPMO_FORM_CONSTRUCTOR" msprop:Generator_RowChangedName="TBPMO_FORM_CONSTRUCTORRowChanged" msprop:Generator_UserTableName="TBPMO_FORM_CONSTRUCTOR" msprop:Generator_RowChangingName="TBPMO_FORM_CONSTRUCTORRowChanging" msprop:Generator_TableClassName="TBPMO_FORM_CONSTRUCTORDataTable" msprop:Generator_TableVarName="tableTBPMO_FORM_CONSTRUCTOR">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="FORM_TITLE" msprop:Generator_UserColumnName="FORM_TITLE" msprop:Generator_ColumnPropNameInTable="FORM_TITLEColumn" msprop:Generator_ColumnPropNameInRow="FORM_TITLE" msprop:Generator_ColumnVarNameInTable="columnFORM_TITLE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SEQUENCE_MENU" msprop:Generator_UserColumnName="SEQUENCE_MENU" msprop:Generator_ColumnPropNameInTable="SEQUENCE_MENUColumn" msprop:Generator_ColumnPropNameInRow="SEQUENCE_MENU" msprop:Generator_ColumnVarNameInTable="columnSEQUENCE_MENU" type="xs:int" />
|
|
<xs:element name="ADDED_WHO" msprop:Generator_UserColumnName="ADDED_WHO" msprop:Generator_ColumnPropNameInTable="ADDED_WHOColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHO" msprop:Generator_ColumnVarNameInTable="columnADDED_WHO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHEN" msprop:Generator_UserColumnName="ADDED_WHEN" msprop:Generator_ColumnPropNameInTable="ADDED_WHENColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHEN" msprop:Generator_ColumnVarNameInTable="columnADDED_WHEN" type="xs:dateTime" />
|
|
<xs:element name="CHANGED_WHO" msprop:Generator_UserColumnName="CHANGED_WHO" msprop:Generator_ColumnPropNameInTable="CHANGED_WHOColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHO" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CHANGED_WHEN" msprop:Generator_UserColumnName="CHANGED_WHEN" msprop:Generator_ColumnPropNameInTable="CHANGED_WHENColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHEN" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="MENU_IMG" msprop:Generator_UserColumnName="MENU_IMG" msprop:Generator_ColumnPropNameInTable="MENU_IMGColumn" msprop:Generator_ColumnPropNameInRow="MENU_IMG" msprop:Generator_ColumnVarNameInTable="columnMENU_IMG" type="xs:base64Binary" minOccurs="0" />
|
|
<xs:element name="SHORT_TITLE" msprop:Generator_UserColumnName="SHORT_TITLE" msprop:Generator_ColumnPropNameInTable="SHORT_TITLEColumn" msprop:Generator_ColumnPropNameInRow="SHORT_TITLE" msprop:Generator_ColumnVarNameInTable="columnSHORT_TITLE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="LANGUAGE" msprop:Generator_UserColumnName="LANGUAGE" msprop:Generator_ColumnPropNameInTable="LANGUAGEColumn" msprop:Generator_ColumnPropNameInRow="LANGUAGE" msprop:Generator_ColumnVarNameInTable="columnLANGUAGE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NODE_NAVIGATION" msprop:Generator_UserColumnName="NODE_NAVIGATION" msprop:Generator_ColumnPropNameInTable="NODE_NAVIGATIONColumn" msprop:Generator_ColumnPropNameInRow="NODE_NAVIGATION" msprop:Generator_ColumnVarNameInTable="columnNODE_NAVIGATION" type="xs:boolean" default="true" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBPMO_FORM_CONSTRUCTOR_DETAIL" msprop:Generator_RowClassName="TBPMO_FORM_CONSTRUCTOR_DETAILRow" msprop:Generator_RowEvHandlerName="TBPMO_FORM_CONSTRUCTOR_DETAILRowChangeEventHandler" msprop:Generator_RowDeletedName="TBPMO_FORM_CONSTRUCTOR_DETAILRowDeleted" msprop:Generator_RowDeletingName="TBPMO_FORM_CONSTRUCTOR_DETAILRowDeleting" msprop:Generator_RowEvArgName="TBPMO_FORM_CONSTRUCTOR_DETAILRowChangeEvent" msprop:Generator_TablePropName="TBPMO_FORM_CONSTRUCTOR_DETAIL" msprop:Generator_RowChangedName="TBPMO_FORM_CONSTRUCTOR_DETAILRowChanged" msprop:Generator_UserTableName="TBPMO_FORM_CONSTRUCTOR_DETAIL" msprop:Generator_RowChangingName="TBPMO_FORM_CONSTRUCTOR_DETAILRowChanging" msprop:Generator_TableClassName="TBPMO_FORM_CONSTRUCTOR_DETAILDataTable" msprop:Generator_TableVarName="tableTBPMO_FORM_CONSTRUCTOR_DETAIL">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="CONSTRUCT_ID" msprop:Generator_UserColumnName="CONSTRUCT_ID" msprop:Generator_ColumnPropNameInTable="CONSTRUCT_IDColumn" msprop:Generator_ColumnPropNameInRow="CONSTRUCT_ID" msprop:Generator_ColumnVarNameInTable="columnCONSTRUCT_ID" type="xs:int" />
|
|
<xs:element name="FORM_ID" msprop:Generator_UserColumnName="FORM_ID" msprop:Generator_ColumnPropNameInTable="FORM_IDColumn" msprop:Generator_ColumnPropNameInRow="FORM_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_ID" type="xs:int" />
|
|
<xs:element name="PARENT_ID" msprop:Generator_UserColumnName="PARENT_ID" msprop:Generator_ColumnPropNameInTable="PARENT_IDColumn" msprop:Generator_ColumnPropNameInRow="PARENT_ID" msprop:Generator_ColumnVarNameInTable="columnPARENT_ID" type="xs:int" />
|
|
<xs:element name="LEVEL1_SELECT" msprop:Generator_UserColumnName="LEVEL1_SELECT" msprop:Generator_ColumnPropNameInTable="LEVEL1_SELECTColumn" msprop:Generator_ColumnPropNameInRow="LEVEL1_SELECT" msprop:Generator_ColumnVarNameInTable="columnLEVEL1_SELECT" type="xs:boolean" />
|
|
<xs:element name="SEQUENCE" msprop:Generator_UserColumnName="SEQUENCE" msprop:Generator_ColumnPropNameInTable="SEQUENCEColumn" msprop:Generator_ColumnPropNameInRow="SEQUENCE" msprop:Generator_ColumnVarNameInTable="columnSEQUENCE" type="xs:int" />
|
|
<xs:element name="SQL_SELECT_EBENE1" msprop:Generator_UserColumnName="SQL_SELECT_EBENE1" msprop:Generator_ColumnPropNameInTable="SQL_SELECT_EBENE1Column" msprop:Generator_ColumnPropNameInRow="SQL_SELECT_EBENE1" msprop:Generator_ColumnVarNameInTable="columnSQL_SELECT_EBENE1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4000" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SQL_SELECT_EBENE2" msprop:Generator_UserColumnName="SQL_SELECT_EBENE2" msprop:Generator_ColumnPropNameInTable="SQL_SELECT_EBENE2Column" msprop:Generator_ColumnPropNameInRow="SQL_SELECT_EBENE2" msprop:Generator_ColumnVarNameInTable="columnSQL_SELECT_EBENE2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="4000" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHO" msprop:Generator_UserColumnName="ADDED_WHO" msprop:Generator_ColumnPropNameInTable="ADDED_WHOColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHO" msprop:Generator_ColumnVarNameInTable="columnADDED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHEN" msprop:Generator_UserColumnName="ADDED_WHEN" msprop:Generator_ColumnPropNameInTable="ADDED_WHENColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHEN" msprop:Generator_ColumnVarNameInTable="columnADDED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CHANGED_WHO" msprop:Generator_UserColumnName="CHANGED_WHO" msprop:Generator_ColumnPropNameInTable="CHANGED_WHOColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHO" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CHANGED_WHEN" msprop:Generator_UserColumnName="CHANGED_WHEN" msprop:Generator_ColumnPropNameInTable="CHANGED_WHENColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHEN" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="COLUMN_NAME1" msprop:Generator_UserColumnName="COLUMN_NAME1" msprop:Generator_ColumnPropNameInTable="COLUMN_NAME1Column" msprop:Generator_ColumnPropNameInRow="COLUMN_NAME1" msprop:Generator_ColumnVarNameInTable="columnCOLUMN_NAME1">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COLUMN_NAME2" msprop:Generator_UserColumnName="COLUMN_NAME2" msprop:Generator_ColumnPropNameInTable="COLUMN_NAME2Column" msprop:Generator_ColumnPropNameInRow="COLUMN_NAME2" msprop:Generator_ColumnVarNameInTable="columnCOLUMN_NAME2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="LOAD_DIRECT" msprop:Generator_UserColumnName="LOAD_DIRECT" msprop:Generator_ColumnPropNameInTable="LOAD_DIRECTColumn" msprop:Generator_ColumnPropNameInRow="LOAD_DIRECT" msprop:Generator_ColumnVarNameInTable="columnLOAD_DIRECT" type="xs:boolean" />
|
|
<xs:element name="SQL_QUICK_VIEW" msprop:Generator_UserColumnName="SQL_QUICK_VIEW" msprop:Generator_ColumnPropNameInTable="SQL_QUICK_VIEWColumn" msprop:Generator_ColumnPropNameInRow="SQL_QUICK_VIEW" msprop:Generator_ColumnVarNameInTable="columnSQL_QUICK_VIEW">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CONTROL_DOCTYPE_MATCH" msprop:Generator_UserColumnName="CONTROL_DOCTYPE_MATCH" msprop:Generator_ColumnPropNameInTable="CONTROL_DOCTYPE_MATCHColumn" msprop:Generator_ColumnPropNameInRow="CONTROL_DOCTYPE_MATCH" msprop:Generator_ColumnVarNameInTable="columnCONTROL_DOCTYPE_MATCH" type="xs:int" default="0" />
|
|
<xs:element name="SQL_RIGHT_READ_AND_VIEW_ONLY" msprop:Generator_UserColumnName="SQL_RIGHT_READ_AND_VIEW_ONLY" msprop:Generator_ColumnPropNameInTable="SQL_RIGHT_READ_AND_VIEW_ONLYColumn" msprop:Generator_ColumnPropNameInRow="SQL_RIGHT_READ_AND_VIEW_ONLY" msprop:Generator_ColumnVarNameInTable="columnSQL_RIGHT_READ_AND_VIEW_ONLY">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5000" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SQL_RIGHT_WINDREAM_VIEW" msprop:Generator_UserColumnName="SQL_RIGHT_WINDREAM_VIEW" msprop:Generator_ColumnPropNameInTable="SQL_RIGHT_WINDREAM_VIEWColumn" msprop:Generator_ColumnPropNameInRow="SQL_RIGHT_WINDREAM_VIEW" msprop:Generator_ColumnVarNameInTable="columnSQL_RIGHT_WINDREAM_VIEW">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5000" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADD_RECORDS" msprop:Generator_UserColumnName="ADD_RECORDS" msprop:Generator_ColumnPropNameInTable="ADD_RECORDSColumn" msprop:Generator_ColumnPropNameInRow="ADD_RECORDS" msprop:Generator_ColumnVarNameInTable="columnADD_RECORDS" type="xs:boolean" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBDD_CONNECTION" msprop:Generator_RowEvHandlerName="TBDD_CONNECTIONRowChangeEventHandler" msprop:Generator_RowDeletedName="TBDD_CONNECTIONRowDeleted" msprop:Generator_RowDeletingName="TBDD_CONNECTIONRowDeleting" msprop:Generator_RowEvArgName="TBDD_CONNECTIONRowChangeEvent" msprop:Generator_TablePropName="TBDD_CONNECTION" msprop:Generator_RowChangedName="TBDD_CONNECTIONRowChanged" msprop:Generator_UserTableName="TBDD_CONNECTION" msprop:Generator_RowChangingName="TBDD_CONNECTIONRowChanging" msprop:Generator_RowClassName="TBDD_CONNECTIONRow" msprop:Generator_TableClassName="TBDD_CONNECTIONDataTable" msprop:Generator_TableVarName="tableTBDD_CONNECTION">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:short" />
|
|
<xs:element name="BEZEICHNUNG" msprop:Generator_UserColumnName="BEZEICHNUNG" msprop:Generator_ColumnPropNameInTable="BEZEICHNUNGColumn" msprop:Generator_ColumnPropNameInRow="BEZEICHNUNG" msprop:Generator_ColumnVarNameInTable="columnBEZEICHNUNG" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SQL_PROVIDER" msprop:Generator_UserColumnName="SQL_PROVIDER" msprop:Generator_ColumnPropNameInTable="SQL_PROVIDERColumn" msprop:Generator_ColumnPropNameInRow="SQL_PROVIDER" msprop:Generator_ColumnVarNameInTable="columnSQL_PROVIDER" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SERVER" msprop:Generator_UserColumnName="SERVER" msprop:Generator_ColumnPropNameInTable="SERVERColumn" msprop:Generator_ColumnPropNameInRow="SERVER" msprop:Generator_ColumnVarNameInTable="columnSERVER" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="150" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DATENBANK" msprop:Generator_UserColumnName="DATENBANK" msprop:Generator_ColumnPropNameInTable="DATENBANKColumn" msprop:Generator_ColumnPropNameInRow="DATENBANK" msprop:Generator_ColumnVarNameInTable="columnDATENBANK" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="USERNAME" msprop:Generator_UserColumnName="USERNAME" msprop:Generator_ColumnPropNameInTable="USERNAMEColumn" msprop:Generator_ColumnPropNameInRow="USERNAME" msprop:Generator_ColumnVarNameInTable="columnUSERNAME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PASSWORD" msprop:Generator_UserColumnName="PASSWORD" msprop:Generator_ColumnPropNameInTable="PASSWORDColumn" msprop:Generator_ColumnPropNameInRow="PASSWORD" msprop:Generator_ColumnVarNameInTable="columnPASSWORD" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="BEMERKUNG" msprop:Generator_UserColumnName="BEMERKUNG" msprop:Generator_ColumnPropNameInTable="BEMERKUNGColumn" msprop:Generator_ColumnPropNameInRow="BEMERKUNG" msprop:Generator_ColumnVarNameInTable="columnBEMERKUNG" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="400" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AKTIV" msprop:Generator_UserColumnName="AKTIV" msprop:Generator_ColumnPropNameInTable="AKTIVColumn" msprop:Generator_ColumnPropNameInRow="AKTIV" msprop:Generator_ColumnVarNameInTable="columnAKTIV" type="xs:boolean" default="true" />
|
|
<xs:element name="ERSTELLTWER" msprop:Generator_UserColumnName="ERSTELLTWER" msprop:Generator_ColumnPropNameInTable="ERSTELLTWERColumn" msprop:Generator_ColumnPropNameInRow="ERSTELLTWER" msprop:Generator_ColumnVarNameInTable="columnERSTELLTWER">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ERSTELLTWANN" msprop:Generator_UserColumnName="ERSTELLTWANN" msprop:Generator_ColumnPropNameInTable="ERSTELLTWANNColumn" msprop:Generator_ColumnPropNameInRow="ERSTELLTWANN" msprop:Generator_ColumnVarNameInTable="columnERSTELLTWANN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="GEANDERTWER" msprop:Generator_UserColumnName="GEANDERTWER" msprop:Generator_ColumnPropNameInTable="GEANDERTWERColumn" msprop:Generator_ColumnPropNameInRow="GEANDERTWER" msprop:Generator_ColumnVarNameInTable="columnGEANDERTWER" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="GEAENDERTWANN" msprop:Generator_UserColumnName="GEAENDERTWANN" msprop:Generator_ColumnPropNameInTable="GEAENDERTWANNColumn" msprop:Generator_ColumnPropNameInRow="GEAENDERTWANN" msprop:Generator_ColumnVarNameInTable="columnGEAENDERTWANN" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="DT_VORSCHAU" msprop:Generator_RowClassName="DT_VORSCHAURow" msprop:Generator_RowEvHandlerName="DT_VORSCHAURowChangeEventHandler" msprop:Generator_RowDeletedName="DT_VORSCHAURowDeleted" msprop:Generator_RowDeletingName="DT_VORSCHAURowDeleting" msprop:Generator_RowEvArgName="DT_VORSCHAURowChangeEvent" msprop:Generator_TablePropName="DT_VORSCHAU" msprop:Generator_RowChangedName="DT_VORSCHAURowChanged" msprop:Generator_UserTableName="DT_VORSCHAU" msprop:Generator_RowChangingName="DT_VORSCHAURowChanging" msprop:Generator_TableClassName="DT_VORSCHAUDataTable" msprop:Generator_TableVarName="tableDT_VORSCHAU">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="VALUE" msprop:Generator_UserColumnName="VALUE" msprop:Generator_ColumnPropNameInTable="VALUEColumn" msprop:Generator_ColumnPropNameInRow="VALUE" msprop:Generator_ColumnVarNameInTable="columnVALUE" type="xs:string" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="VWTEMPQUICKVIEW" msprop:Generator_RowEvHandlerName="VWTEMPQUICKVIEWRowChangeEventHandler" msprop:Generator_RowDeletedName="VWTEMPQUICKVIEWRowDeleted" msprop:Generator_RowDeletingName="VWTEMPQUICKVIEWRowDeleting" msprop:Generator_RowEvArgName="VWTEMPQUICKVIEWRowChangeEvent" msprop:Generator_TablePropName="VWTEMPQUICKVIEW" msprop:Generator_RowChangedName="VWTEMPQUICKVIEWRowChanged" msprop:Generator_UserTableName="VWTEMPQUICKVIEW" msprop:Generator_RowChangingName="VWTEMPQUICKVIEWRowChanging" msprop:Generator_RowClassName="VWTEMPQUICKVIEWRow" msprop:Generator_TableClassName="VWTEMPQUICKVIEWDataTable" msprop:Generator_TableVarName="tableVWTEMPQUICKVIEW">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Record-ID" msprop:Generator_UserColumnName="Record-ID" msprop:Generator_ColumnPropNameInTable="_Record_IDColumn" msprop:Generator_ColumnPropNameInRow="_Record_ID" msprop:Generator_ColumnVarNameInTable="_columnRecord_ID" type="xs:int" />
|
|
<xs:element name="Aktenzeichen" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Aktenzeichen" msprop:Generator_ColumnPropNameInTable="AktenzeichenColumn" msprop:Generator_ColumnPropNameInRow="Aktenzeichen" msprop:Generator_ColumnVarNameInTable="columnAktenzeichen" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Wiedergabe_x0020_der_x0020_Marke_x0020__x0028_Bild_x0029_" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Wiedergabe der Marke (Bild)" msprop:Generator_ColumnPropNameInTable="_Wiedergabe_der_Marke__Bild_Column" msprop:Generator_ColumnPropNameInRow="_Wiedergabe_der_Marke__Bild_" msprop:Generator_ColumnVarNameInTable="_columnWiedergabe_der_Marke__Bild_" type="xs:base64Binary" minOccurs="0" />
|
|
<xs:element name="Tag_x0020_der_x0020_Eintragung_x0020_im_x0020_Register" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Tag der Eintragung im Register" msprop:Generator_ColumnPropNameInTable="Tag_der_Eintragung_im_RegisterColumn" msprop:Generator_ColumnPropNameInRow="Tag_der_Eintragung_im_Register" msprop:Generator_ColumnVarNameInTable="columnTag_der_Eintragung_im_Register" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Aktenzustand" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Aktenzustand" msprop:Generator_ColumnPropNameInTable="AktenzustandColumn" msprop:Generator_ColumnPropNameInRow="Aktenzustand" msprop:Generator_ColumnVarNameInTable="columnAktenzustand" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBAD_Users" msprop:Generator_RowClassName="TBAD_UsersRow" msprop:Generator_RowEvHandlerName="TBAD_UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="TBAD_UsersRowDeleted" msprop:Generator_RowDeletingName="TBAD_UsersRowDeleting" msprop:Generator_RowEvArgName="TBAD_UsersRowChangeEvent" msprop:Generator_TablePropName="TBAD_Users" msprop:Generator_RowChangedName="TBAD_UsersRowChanged" msprop:Generator_UserTableName="TBAD_Users" msprop:Generator_RowChangingName="TBAD_UsersRowChanging" msprop:Generator_TableClassName="TBAD_UsersDataTable" msprop:Generator_TableVarName="tableTBAD_Users">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Select" msprop:Generator_UserColumnName="Select" msprop:Generator_ColumnPropNameInTable="SelectColumn" msprop:Generator_ColumnPropNameInRow="_Select" msprop:Generator_ColumnVarNameInTable="columnSelect" type="xs:boolean" default="false" minOccurs="0" />
|
|
<xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Prename" msprop:Generator_UserColumnName="Prename" msprop:Generator_ColumnPropNameInTable="PrenameColumn" msprop:Generator_ColumnPropNameInRow="Prename" msprop:Generator_ColumnVarNameInTable="columnPrename" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Surname" msprop:Generator_UserColumnName="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_ColumnVarNameInTable="columnSurname" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" type="xs:string" minOccurs="0" />
|
|
<xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:short" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBWH_ENTITIES" msprop:Generator_RowEvHandlerName="TBWH_ENTITIESRowChangeEventHandler" msprop:Generator_RowDeletedName="TBWH_ENTITIESRowDeleted" msprop:Generator_RowDeletingName="TBWH_ENTITIESRowDeleting" msprop:Generator_RowEvArgName="TBWH_ENTITIESRowChangeEvent" msprop:Generator_TablePropName="TBWH_ENTITIES" msprop:Generator_RowChangedName="TBWH_ENTITIESRowChanged" msprop:Generator_UserTableName="TBWH_ENTITIES" msprop:Generator_RowChangingName="TBWH_ENTITIESRowChanging" msprop:Generator_RowClassName="TBWH_ENTITIESRow" msprop:Generator_TableClassName="TBWH_ENTITIESDataTable" msprop:Generator_TableVarName="tableTBWH_ENTITIES">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="FORM_TITLE" msprop:Generator_UserColumnName="FORM_TITLE" msprop:Generator_ColumnPropNameInTable="FORM_TITLEColumn" msprop:Generator_ColumnPropNameInRow="FORM_TITLE" msprop:Generator_ColumnVarNameInTable="columnFORM_TITLE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CAPTION" msdata:ReadOnly="true" msprop:Generator_UserColumnName="CAPTION" msprop:Generator_ColumnPropNameInTable="CAPTIONColumn" msprop:Generator_ColumnPropNameInRow="CAPTION" msprop:Generator_ColumnVarNameInTable="columnCAPTION" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBWH_USER_GROUPS" msprop:Generator_RowEvHandlerName="TBWH_USER_GROUPSRowChangeEventHandler" msprop:Generator_RowDeletedName="TBWH_USER_GROUPSRowDeleted" msprop:Generator_RowDeletingName="TBWH_USER_GROUPSRowDeleting" msprop:Generator_RowEvArgName="TBWH_USER_GROUPSRowChangeEvent" msprop:Generator_TablePropName="TBWH_USER_GROUPS" msprop:Generator_RowChangedName="TBWH_USER_GROUPSRowChanged" msprop:Generator_UserTableName="TBWH_USER_GROUPS" msprop:Generator_RowChangingName="TBWH_USER_GROUPSRowChanging" msprop:Generator_RowClassName="TBWH_USER_GROUPSRow" msprop:Generator_TableClassName="TBWH_USER_GROUPSDataTable" msprop:Generator_TableVarName="tableTBWH_USER_GROUPS">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="NAME" msprop:Generator_UserColumnName="NAME" msprop:Generator_ColumnPropNameInTable="NAMEColumn" msprop:Generator_ColumnPropNameInRow="NAME" msprop:Generator_ColumnVarNameInTable="columnNAME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBWH_Users1" msprop:Generator_RowEvHandlerName="TBWH_Users1RowChangeEventHandler" msprop:Generator_RowDeletedName="TBWH_Users1RowDeleted" msprop:Generator_RowDeletingName="TBWH_Users1RowDeleting" msprop:Generator_RowEvArgName="TBWH_Users1RowChangeEvent" msprop:Generator_TablePropName="TBWH_Users1" msprop:Generator_RowChangedName="TBWH_Users1RowChanged" msprop:Generator_UserTableName="TBWH_Users1" msprop:Generator_RowChangingName="TBWH_Users1RowChanging" msprop:Generator_RowClassName="TBWH_Users1Row" msprop:Generator_TableClassName="TBWH_Users1DataTable" msprop:Generator_TableVarName="tableTBWH_Users1">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Select" msprop:Generator_UserColumnName="Select" msprop:Generator_ColumnPropNameInTable="SelectColumn" msprop:Generator_ColumnPropNameInRow="_Select" msprop:Generator_ColumnVarNameInTable="columnSelect" type="xs:boolean" default="false" minOccurs="0" />
|
|
<xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Prename" msprop:Generator_UserColumnName="Prename" msprop:Generator_ColumnPropNameInTable="PrenameColumn" msprop:Generator_ColumnPropNameInRow="Prename" msprop:Generator_ColumnVarNameInTable="columnPrename" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Surname" msprop:Generator_UserColumnName="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_ColumnVarNameInTable="columnSurname" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" type="xs:string" minOccurs="0" />
|
|
<xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:short" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBWH_Users2" msprop:Generator_RowClassName="TBWH_Users2Row" msprop:Generator_RowEvHandlerName="TBWH_Users2RowChangeEventHandler" msprop:Generator_RowDeletedName="TBWH_Users2RowDeleted" msprop:Generator_RowDeletingName="TBWH_Users2RowDeleting" msprop:Generator_RowEvArgName="TBWH_Users2RowChangeEvent" msprop:Generator_TablePropName="TBWH_Users2" msprop:Generator_RowChangedName="TBWH_Users2RowChanged" msprop:Generator_UserTableName="TBWH_Users2" msprop:Generator_RowChangingName="TBWH_Users2RowChanging" msprop:Generator_TableClassName="TBWH_Users2DataTable" msprop:Generator_TableVarName="tableTBWH_Users2">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Select" msprop:Generator_UserColumnName="Select" msprop:Generator_ColumnPropNameInTable="SelectColumn" msprop:Generator_ColumnPropNameInRow="_Select" msprop:Generator_ColumnVarNameInTable="columnSelect" type="xs:boolean" default="false" minOccurs="0" />
|
|
<xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Prename" msprop:Generator_UserColumnName="Prename" msprop:Generator_ColumnPropNameInTable="PrenameColumn" msprop:Generator_ColumnPropNameInRow="Prename" msprop:Generator_ColumnVarNameInTable="columnPrename" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Surname" msprop:Generator_UserColumnName="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_ColumnVarNameInTable="columnSurname" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" type="xs:string" minOccurs="0" />
|
|
<xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:short" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBPMO_SAP_FUBA" msprop:Generator_RowClassName="TBPMO_SAP_FUBARow" msprop:Generator_RowEvHandlerName="TBPMO_SAP_FUBARowChangeEventHandler" msprop:Generator_RowDeletedName="TBPMO_SAP_FUBARowDeleted" msprop:Generator_RowDeletingName="TBPMO_SAP_FUBARowDeleting" msprop:Generator_RowEvArgName="TBPMO_SAP_FUBARowChangeEvent" msprop:Generator_TablePropName="TBPMO_SAP_FUBA" msprop:Generator_RowChangedName="TBPMO_SAP_FUBARowChanged" msprop:Generator_UserTableName="TBPMO_SAP_FUBA" msprop:Generator_RowChangingName="TBPMO_SAP_FUBARowChanging" msprop:Generator_TableClassName="TBPMO_SAP_FUBADataTable" msprop:Generator_TableVarName="tableTBPMO_SAP_FUBA">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="NAME" msprop:Generator_UserColumnName="NAME" msprop:Generator_ColumnPropNameInTable="NAMEColumn" msprop:Generator_ColumnPropNameInRow="NAME" msprop:Generator_ColumnVarNameInTable="columnNAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COMMENT" msprop:Generator_UserColumnName="COMMENT" msprop:Generator_ColumnPropNameInTable="COMMENTColumn" msprop:Generator_ColumnPropNameInRow="COMMENT" msprop:Generator_ColumnVarNameInTable="columnCOMMENT" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TableName" msprop:Generator_UserColumnName="TableName" msprop:Generator_ColumnPropNameInTable="TableNameColumn" msprop:Generator_ColumnPropNameInRow="TableName" msprop:Generator_ColumnVarNameInTable="columnTableName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Host" msprop:Generator_UserColumnName="Host" msprop:Generator_ColumnPropNameInTable="HostColumn" msprop:Generator_ColumnPropNameInRow="Host" msprop:Generator_ColumnVarNameInTable="columnHost">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SystemNumber" msprop:Generator_UserColumnName="SystemNumber" msprop:Generator_ColumnPropNameInTable="SystemNumberColumn" msprop:Generator_ColumnPropNameInRow="SystemNumber" msprop:Generator_ColumnVarNameInTable="columnSystemNumber">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UserName" msprop:Generator_UserColumnName="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Password" msprop:Generator_UserColumnName="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnVarNameInTable="columnPassword">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Client" msprop:Generator_UserColumnName="Client" msprop:Generator_ColumnPropNameInTable="ClientColumn" msprop:Generator_ColumnPropNameInRow="Client" msprop:Generator_ColumnVarNameInTable="columnClient">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Language" msprop:Generator_UserColumnName="Language" msprop:Generator_ColumnPropNameInTable="LanguageColumn" msprop:Generator_ColumnPropNameInRow="Language" msprop:Generator_ColumnVarNameInTable="columnLanguage">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="TempTableName" msprop:Generator_UserColumnName="TempTableName" msprop:Generator_ColumnPropNameInTable="TempTableNameColumn" msprop:Generator_ColumnPropNameInRow="TempTableName" msprop:Generator_ColumnVarNameInTable="columnTempTableName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ACTIVE" msprop:Generator_UserColumnName="ACTIVE" msprop:Generator_ColumnPropNameInTable="ACTIVEColumn" msprop:Generator_ColumnPropNameInRow="ACTIVE" msprop:Generator_ColumnVarNameInTable="columnACTIVE" type="xs:boolean" default="false" />
|
|
<xs:element name="ADDED_WHO" msprop:Generator_UserColumnName="ADDED_WHO" msprop:Generator_ColumnPropNameInTable="ADDED_WHOColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHO" msprop:Generator_ColumnVarNameInTable="columnADDED_WHO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHEN" msprop:Generator_UserColumnName="ADDED_WHEN" msprop:Generator_ColumnPropNameInTable="ADDED_WHENColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHEN" msprop:Generator_ColumnVarNameInTable="columnADDED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CHANGED_WHO" msprop:Generator_UserColumnName="CHANGED_WHO" msprop:Generator_ColumnPropNameInTable="CHANGED_WHOColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHO" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CHANGED_WHEN" msprop:Generator_UserColumnName="CHANGED_WHEN" msprop:Generator_ColumnPropNameInTable="CHANGED_WHENColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHEN" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="WHERE_CLAUSE" msprop:Generator_UserColumnName="WHERE_CLAUSE" msprop:Generator_ColumnPropNameInTable="WHERE_CLAUSEColumn" msprop:Generator_ColumnPropNameInRow="WHERE_CLAUSE" msprop:Generator_ColumnVarNameInTable="columnWHERE_CLAUSE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Method" msprop:Generator_UserColumnName="Method" msprop:Generator_ColumnPropNameInTable="MethodColumn" msprop:Generator_ColumnPropNameInRow="Method" msprop:Generator_ColumnVarNameInTable="columnMethod" default="TABLE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FuBa_SplitCharacter" msprop:Generator_UserColumnName="FuBa_SplitCharacter" msprop:Generator_ColumnPropNameInTable="FuBa_SplitCharacterColumn" msprop:Generator_ColumnPropNameInRow="FuBa_SplitCharacter" msprop:Generator_ColumnVarNameInTable="columnFuBa_SplitCharacter" default=";">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="USER_RIGHTS" msprop:Generator_RowEvHandlerName="USER_RIGHTSRowChangeEventHandler" msprop:Generator_RowDeletedName="USER_RIGHTSRowDeleted" msprop:Generator_RowDeletingName="USER_RIGHTSRowDeleting" msprop:Generator_RowEvArgName="USER_RIGHTSRowChangeEvent" msprop:Generator_TablePropName="USER_RIGHTS" msprop:Generator_RowChangedName="USER_RIGHTSRowChanged" msprop:Generator_UserTableName="USER_RIGHTS" msprop:Generator_RowChangingName="USER_RIGHTSRowChanging" msprop:Generator_RowClassName="USER_RIGHTSRow" msprop:Generator_TableClassName="USER_RIGHTSDataTable" msprop:Generator_TableVarName="tableUSER_RIGHTS">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="FORM_TITLE" msdata:ReadOnly="true" msprop:Generator_UserColumnName="FORM_TITLE" msprop:Generator_ColumnPropNameInTable="FORM_TITLEColumn" msprop:Generator_ColumnPropNameInRow="FORM_TITLE" msprop:Generator_ColumnVarNameInTable="columnFORM_TITLE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="USERNAME" msprop:Generator_UserColumnName="USERNAME" msprop:Generator_ColumnPropNameInTable="USERNAMEColumn" msprop:Generator_ColumnPropNameInRow="USERNAME" msprop:Generator_ColumnVarNameInTable="columnUSERNAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NAME" msprop:Generator_UserColumnName="NAME" msprop:Generator_ColumnPropNameInTable="NAMEColumn" msprop:Generator_ColumnPropNameInRow="NAME" msprop:Generator_ColumnVarNameInTable="columnNAME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PRENAME" msprop:Generator_UserColumnName="PRENAME" msprop:Generator_ColumnPropNameInTable="PRENAMEColumn" msprop:Generator_ColumnPropNameInRow="PRENAME" msprop:Generator_ColumnVarNameInTable="columnPRENAME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="EDIT_REC" msprop:Generator_UserColumnName="EDIT_REC" msprop:Generator_ColumnPropNameInTable="EDIT_RECColumn" msprop:Generator_ColumnPropNameInRow="EDIT_REC" msprop:Generator_ColumnVarNameInTable="columnEDIT_REC" type="xs:boolean" />
|
|
<xs:element name="ADD_REC" msprop:Generator_UserColumnName="ADD_REC" msprop:Generator_ColumnPropNameInTable="ADD_RECColumn" msprop:Generator_ColumnPropNameInRow="ADD_REC" msprop:Generator_ColumnVarNameInTable="columnADD_REC" type="xs:boolean" />
|
|
<xs:element name="DELETE_REC" msprop:Generator_UserColumnName="DELETE_REC" msprop:Generator_ColumnPropNameInTable="DELETE_RECColumn" msprop:Generator_ColumnPropNameInRow="DELETE_REC" msprop:Generator_ColumnVarNameInTable="columnDELETE_REC" type="xs:boolean" />
|
|
<xs:element name="ADD_DOC" msprop:Generator_UserColumnName="ADD_DOC" msprop:Generator_ColumnPropNameInTable="ADD_DOCColumn" msprop:Generator_ColumnPropNameInRow="ADD_DOC" msprop:Generator_ColumnVarNameInTable="columnADD_DOC" type="xs:boolean" />
|
|
<xs:element name="READ_ONLY_DOC" msprop:Generator_UserColumnName="READ_ONLY_DOC" msprop:Generator_ColumnPropNameInTable="READ_ONLY_DOCColumn" msprop:Generator_ColumnPropNameInRow="READ_ONLY_DOC" msprop:Generator_ColumnVarNameInTable="columnREAD_ONLY_DOC" type="xs:boolean" />
|
|
<xs:element name="DELETE_DOC" msprop:Generator_UserColumnName="DELETE_DOC" msprop:Generator_ColumnPropNameInTable="DELETE_DOCColumn" msprop:Generator_ColumnPropNameInRow="DELETE_DOC" msprop:Generator_ColumnVarNameInTable="columnDELETE_DOC" type="xs:boolean" />
|
|
<xs:element name="FILES_VISIBLE" msprop:Generator_UserColumnName="FILES_VISIBLE" msprop:Generator_ColumnPropNameInTable="FILES_VISIBLEColumn" msprop:Generator_ColumnPropNameInRow="FILES_VISIBLE" msprop:Generator_ColumnVarNameInTable="columnFILES_VISIBLE" type="xs:boolean" />
|
|
<xs:element name="ADDED_WHEN" msprop:Generator_UserColumnName="ADDED_WHEN" msprop:Generator_ColumnPropNameInTable="ADDED_WHENColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHEN" msprop:Generator_ColumnVarNameInTable="columnADDED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CHANGED_WHEN" msprop:Generator_UserColumnName="CHANGED_WHEN" msprop:Generator_ColumnPropNameInTable="CHANGED_WHENColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHEN" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBPMO_DOCSEARCH_RESULTLIST_CONFIG" msprop:Generator_RowEvHandlerName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGRowChangeEventHandler" msprop:Generator_RowDeletedName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGRowDeleted" msprop:Generator_RowDeletingName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGRowDeleting" msprop:Generator_RowEvArgName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGRowChangeEvent" msprop:Generator_TablePropName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG" msprop:Generator_RowChangedName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGRowChanged" msprop:Generator_UserTableName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG" msprop:Generator_RowChangingName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGRowChanging" msprop:Generator_RowClassName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGRow" msprop:Generator_TableClassName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGDataTable" msprop:Generator_TableVarName="tableTBPMO_DOCSEARCH_RESULTLIST_CONFIG">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="ENTITY_ID" msprop:Generator_UserColumnName="ENTITY_ID" msprop:Generator_ColumnPropNameInTable="ENTITY_IDColumn" msprop:Generator_ColumnPropNameInRow="ENTITY_ID" msprop:Generator_ColumnVarNameInTable="columnENTITY_ID" type="xs:int" />
|
|
<xs:element name="LANGUAGE" msprop:Generator_UserColumnName="LANGUAGE" msprop:Generator_ColumnPropNameInTable="LANGUAGEColumn" msprop:Generator_ColumnPropNameInRow="LANGUAGE" msprop:Generator_ColumnVarNameInTable="columnLANGUAGE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="5" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COLUMN_VIEW" msprop:Generator_UserColumnName="COLUMN_VIEW" msprop:Generator_ColumnPropNameInTable="COLUMN_VIEWColumn" msprop:Generator_ColumnPropNameInRow="COLUMN_VIEW" msprop:Generator_ColumnVarNameInTable="columnCOLUMN_VIEW">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="HEADER_CAPTION" msprop:Generator_UserColumnName="HEADER_CAPTION" msprop:Generator_ColumnPropNameInTable="HEADER_CAPTIONColumn" msprop:Generator_ColumnPropNameInRow="HEADER_CAPTION" msprop:Generator_ColumnVarNameInTable="columnHEADER_CAPTION">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="WIDTH" msprop:Generator_UserColumnName="WIDTH" msprop:Generator_ColumnPropNameInTable="WIDTHColumn" msprop:Generator_ColumnPropNameInRow="WIDTH" msprop:Generator_ColumnVarNameInTable="columnWIDTH" type="xs:int" />
|
|
<xs:element name="TYPE_ID" msprop:Generator_UserColumnName="TYPE_ID" msprop:Generator_ColumnPropNameInTable="TYPE_IDColumn" msprop:Generator_ColumnPropNameInRow="TYPE_ID" msprop:Generator_ColumnVarNameInTable="columnTYPE_ID" type="xs:unsignedByte" />
|
|
<xs:element name="ADDED_WHO" msprop:Generator_UserColumnName="ADDED_WHO" msprop:Generator_ColumnPropNameInTable="ADDED_WHOColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHO" msprop:Generator_ColumnVarNameInTable="columnADDED_WHO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHEN" msprop:Generator_UserColumnName="ADDED_WHEN" msprop:Generator_ColumnPropNameInTable="ADDED_WHENColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHEN" msprop:Generator_ColumnVarNameInTable="columnADDED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CHANGED_WHO" msprop:Generator_UserColumnName="CHANGED_WHO" msprop:Generator_ColumnPropNameInTable="CHANGED_WHOColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHO" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CHANGED_WHEN" msprop:Generator_UserColumnName="CHANGED_WHEN" msprop:Generator_ColumnPropNameInTable="CHANGED_WHENColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHEN" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="VISIBLE" msprop:Generator_UserColumnName="VISIBLE" msprop:Generator_ColumnPropNameInTable="VISIBLEColumn" msprop:Generator_ColumnPropNameInRow="VISIBLE" msprop:Generator_ColumnVarNameInTable="columnVISIBLE" type="xs:boolean" />
|
|
<xs:element name="EDITABLE" msprop:Generator_UserColumnName="EDITABLE" msprop:Generator_ColumnPropNameInTable="EDITABLEColumn" msprop:Generator_ColumnPropNameInRow="EDITABLE" msprop:Generator_ColumnVarNameInTable="columnEDITABLE" type="xs:boolean" />
|
|
<xs:element name="CONFIG_COLUMNS" msprop:Generator_UserColumnName="CONFIG_COLUMNS" msprop:Generator_ColumnPropNameInTable="CONFIG_COLUMNSColumn" msprop:Generator_ColumnPropNameInRow="CONFIG_COLUMNS" msprop:Generator_ColumnVarNameInTable="columnCONFIG_COLUMNS" type="xs:boolean" />
|
|
<xs:element name="SEQUENCE" msprop:Generator_UserColumnName="SEQUENCE" msprop:Generator_ColumnPropNameInTable="SEQUENCEColumn" msprop:Generator_ColumnPropNameInRow="SEQUENCE" msprop:Generator_ColumnVarNameInTable="columnSEQUENCE" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="VWDD_LOGIN_USER_HISTORY" msprop:Generator_RowClassName="VWDD_LOGIN_USER_HISTORYRow" msprop:Generator_RowEvHandlerName="VWDD_LOGIN_USER_HISTORYRowChangeEventHandler" msprop:Generator_RowDeletedName="VWDD_LOGIN_USER_HISTORYRowDeleted" msprop:Generator_RowDeletingName="VWDD_LOGIN_USER_HISTORYRowDeleting" msprop:Generator_RowEvArgName="VWDD_LOGIN_USER_HISTORYRowChangeEvent" msprop:Generator_TablePropName="VWDD_LOGIN_USER_HISTORY" msprop:Generator_RowChangedName="VWDD_LOGIN_USER_HISTORYRowChanged" msprop:Generator_UserTableName="VWDD_LOGIN_USER_HISTORY" msprop:Generator_RowChangingName="VWDD_LOGIN_USER_HISTORYRowChanging" msprop:Generator_TableClassName="VWDD_LOGIN_USER_HISTORYDataTable" msprop:Generator_TableVarName="tableVWDD_LOGIN_USER_HISTORY">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="MODULE" msprop:Generator_UserColumnName="MODULE" msprop:Generator_ColumnPropNameInTable="MODULEColumn" msprop:Generator_ColumnPropNameInRow="_MODULE" msprop:Generator_ColumnVarNameInTable="columnMODULE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="USERNAME" msprop:Generator_UserColumnName="USERNAME" msprop:Generator_ColumnPropNameInTable="USERNAMEColumn" msprop:Generator_ColumnPropNameInRow="USERNAME" msprop:Generator_ColumnVarNameInTable="columnUSERNAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NAME" msprop:Generator_UserColumnName="NAME" msprop:Generator_ColumnPropNameInTable="NAMEColumn" msprop:Generator_ColumnPropNameInRow="NAME" msprop:Generator_ColumnVarNameInTable="columnNAME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PRENAME" msprop:Generator_UserColumnName="PRENAME" msprop:Generator_ColumnPropNameInTable="PRENAMEColumn" msprop:Generator_ColumnPropNameInRow="PRENAME" msprop:Generator_ColumnVarNameInTable="columnPRENAME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="USER_ID" msprop:Generator_UserColumnName="USER_ID" msprop:Generator_ColumnPropNameInTable="USER_IDColumn" msprop:Generator_ColumnPropNameInRow="USER_ID" msprop:Generator_ColumnVarNameInTable="columnUSER_ID" type="xs:int" />
|
|
<xs:element name="CLIENT_ID" msprop:Generator_UserColumnName="CLIENT_ID" msprop:Generator_ColumnPropNameInTable="CLIENT_IDColumn" msprop:Generator_ColumnPropNameInRow="CLIENT_ID" msprop:Generator_ColumnVarNameInTable="columnCLIENT_ID" type="xs:int" />
|
|
<xs:element name="CLIENT_NAME" msprop:Generator_UserColumnName="CLIENT_NAME" msprop:Generator_ColumnPropNameInTable="CLIENT_NAMEColumn" msprop:Generator_ColumnPropNameInRow="CLIENT_NAME" msprop:Generator_ColumnVarNameInTable="columnCLIENT_NAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="LOGIN" msprop:Generator_UserColumnName="LOGIN" msprop:Generator_ColumnPropNameInTable="LOGINColumn" msprop:Generator_ColumnPropNameInRow="LOGIN" msprop:Generator_ColumnVarNameInTable="columnLOGIN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="LOGOUT" msprop:Generator_UserColumnName="LOGOUT" msprop:Generator_ColumnPropNameInTable="LOGOUTColumn" msprop:Generator_ColumnPropNameInRow="LOGOUT" msprop:Generator_ColumnVarNameInTable="columnLOGOUT" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="VERSION_CLIENT" msprop:Generator_UserColumnName="VERSION_CLIENT" msprop:Generator_ColumnPropNameInTable="VERSION_CLIENTColumn" msprop:Generator_ColumnPropNameInRow="VERSION_CLIENT" msprop:Generator_ColumnVarNameInTable="columnVERSION_CLIENT" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="MACHINE_NAME" msprop:Generator_UserColumnName="MACHINE_NAME" msprop:Generator_ColumnPropNameInTable="MACHINE_NAMEColumn" msprop:Generator_ColumnPropNameInRow="MACHINE_NAME" msprop:Generator_ColumnVarNameInTable="columnMACHINE_NAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_ID" msprop:Generator_RowEvHandlerName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDRowChangeEventHandler" msprop:Generator_RowDeletedName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDRowDeleted" msprop:Generator_RowDeletingName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDRowDeleting" msprop:Generator_RowEvArgName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDRowChangeEvent" msprop:Generator_TablePropName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_ID" msprop:Generator_RowChangedName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDRowChanged" msprop:Generator_UserTableName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_ID" msprop:Generator_RowChangingName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDRowChanging" msprop:Generator_RowClassName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDRow" msprop:Generator_TableClassName="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_IDDataTable" msprop:Generator_TableVarName="tableTBPMO_DOCSEARCH_RESULTLIST_CONFIG_TYPE_ID">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Name" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:unsignedByte" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBPMO_LOG_ESSENTIALS" msprop:Generator_RowEvHandlerName="TBPMO_LOG_ESSENTIALSRowChangeEventHandler" msprop:Generator_RowDeletedName="TBPMO_LOG_ESSENTIALSRowDeleted" msprop:Generator_RowDeletingName="TBPMO_LOG_ESSENTIALSRowDeleting" msprop:Generator_RowEvArgName="TBPMO_LOG_ESSENTIALSRowChangeEvent" msprop:Generator_TablePropName="TBPMO_LOG_ESSENTIALS" msprop:Generator_RowChangedName="TBPMO_LOG_ESSENTIALSRowChanged" msprop:Generator_UserTableName="TBPMO_LOG_ESSENTIALS" msprop:Generator_RowChangingName="TBPMO_LOG_ESSENTIALSRowChanging" msprop:Generator_RowClassName="TBPMO_LOG_ESSENTIALSRow" msprop:Generator_TableClassName="TBPMO_LOG_ESSENTIALSDataTable" msprop:Generator_TableVarName="tableTBPMO_LOG_ESSENTIALS">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="REFERENCE_KEY" msprop:Generator_UserColumnName="REFERENCE_KEY" msprop:Generator_ColumnPropNameInTable="REFERENCE_KEYColumn" msprop:Generator_ColumnPropNameInRow="REFERENCE_KEY" msprop:Generator_ColumnVarNameInTable="columnREFERENCE_KEY" type="xs:int" />
|
|
<xs:element name="REFERENCE_STRING" msprop:Generator_UserColumnName="REFERENCE_STRING" msprop:Generator_ColumnPropNameInTable="REFERENCE_STRINGColumn" msprop:Generator_ColumnPropNameInRow="REFERENCE_STRING" msprop:Generator_ColumnVarNameInTable="columnREFERENCE_STRING">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="COMMENT" msprop:Generator_UserColumnName="COMMENT" msprop:Generator_ColumnPropNameInTable="COMMENTColumn" msprop:Generator_ColumnPropNameInRow="COMMENT" msprop:Generator_ColumnVarNameInTable="columnCOMMENT">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHO" msprop:Generator_UserColumnName="ADDED_WHO" msprop:Generator_ColumnPropNameInTable="ADDED_WHOColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHO" msprop:Generator_ColumnVarNameInTable="columnADDED_WHO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHEN" msprop:Generator_UserColumnName="ADDED_WHEN" msprop:Generator_ColumnPropNameInTable="ADDED_WHENColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHEN" msprop:Generator_ColumnVarNameInTable="columnADDED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Selection" msprop:Generator_UserColumnName="Selection" msprop:Generator_ColumnPropNameInTable="SelectionColumn" msprop:Generator_ColumnPropNameInRow="Selection" msprop:Generator_ColumnVarNameInTable="columnSelection" type="xs:boolean" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBPMO_DOCRESULT_DROPDOWN_ITEMS" msprop:Generator_RowClassName="TBPMO_DOCRESULT_DROPDOWN_ITEMSRow" msprop:Generator_RowEvHandlerName="TBPMO_DOCRESULT_DROPDOWN_ITEMSRowChangeEventHandler" msprop:Generator_RowDeletedName="TBPMO_DOCRESULT_DROPDOWN_ITEMSRowDeleted" msprop:Generator_RowDeletingName="TBPMO_DOCRESULT_DROPDOWN_ITEMSRowDeleting" msprop:Generator_RowEvArgName="TBPMO_DOCRESULT_DROPDOWN_ITEMSRowChangeEvent" msprop:Generator_TablePropName="TBPMO_DOCRESULT_DROPDOWN_ITEMS" msprop:Generator_RowChangedName="TBPMO_DOCRESULT_DROPDOWN_ITEMSRowChanged" msprop:Generator_UserTableName="TBPMO_DOCRESULT_DROPDOWN_ITEMS" msprop:Generator_RowChangingName="TBPMO_DOCRESULT_DROPDOWN_ITEMSRowChanging" msprop:Generator_TableClassName="TBPMO_DOCRESULT_DROPDOWN_ITEMSDataTable" msprop:Generator_TableVarName="tableTBPMO_DOCRESULT_DROPDOWN_ITEMS">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="CONFIG_ID" msprop:Generator_UserColumnName="CONFIG_ID" msprop:Generator_ColumnPropNameInTable="CONFIG_IDColumn" msprop:Generator_ColumnPropNameInRow="CONFIG_ID" msprop:Generator_ColumnVarNameInTable="columnCONFIG_ID" type="xs:int" />
|
|
<xs:element name="VALUE" msprop:Generator_UserColumnName="VALUE" msprop:Generator_ColumnPropNameInTable="VALUEColumn" msprop:Generator_ColumnPropNameInRow="VALUE" msprop:Generator_ColumnVarNameInTable="columnVALUE">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SEQUENCE" msprop:Generator_UserColumnName="SEQUENCE" msprop:Generator_ColumnPropNameInTable="SEQUENCEColumn" msprop:Generator_ColumnPropNameInRow="SEQUENCE" msprop:Generator_ColumnVarNameInTable="columnSEQUENCE" type="xs:unsignedByte" />
|
|
<xs:element name="DEFAULT" msprop:Generator_UserColumnName="DEFAULT" msprop:Generator_ColumnPropNameInTable="DEFAULTColumn" msprop:Generator_ColumnPropNameInRow="_DEFAULT" msprop:Generator_ColumnVarNameInTable="columnDEFAULT" type="xs:boolean" />
|
|
<xs:element name="COLOR" msprop:Generator_UserColumnName="COLOR" msprop:Generator_ColumnPropNameInTable="COLORColumn" msprop:Generator_ColumnPropNameInRow="COLOR" msprop:Generator_ColumnVarNameInTable="columnCOLOR">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHO" msprop:Generator_UserColumnName="ADDED_WHO" msprop:Generator_ColumnPropNameInTable="ADDED_WHOColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHO" msprop:Generator_ColumnVarNameInTable="columnADDED_WHO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHEN" msprop:Generator_UserColumnName="ADDED_WHEN" msprop:Generator_ColumnPropNameInTable="ADDED_WHENColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHEN" msprop:Generator_ColumnVarNameInTable="columnADDED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CHANGED_WHO" msprop:Generator_UserColumnName="CHANGED_WHO" msprop:Generator_ColumnPropNameInTable="CHANGED_WHOColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHO" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CHANGED_WHEN" msprop:Generator_UserColumnName="CHANGED_WHEN" msprop:Generator_ColumnPropNameInTable="CHANGED_WHENColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHEN" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="TBDD_GROUPS" msprop:Generator_RowEvHandlerName="TBDD_GROUPSRowChangeEventHandler" msprop:Generator_RowDeletedName="TBDD_GROUPSRowDeleted" msprop:Generator_RowDeletingName="TBDD_GROUPSRowDeleting" msprop:Generator_RowEvArgName="TBDD_GROUPSRowChangeEvent" msprop:Generator_TablePropName="TBDD_GROUPS" msprop:Generator_RowChangedName="TBDD_GROUPSRowChanged" msprop:Generator_UserTableName="TBDD_GROUPS" msprop:Generator_RowChangingName="TBDD_GROUPSRowChanging" msprop:Generator_RowClassName="TBDD_GROUPSRow" msprop:Generator_TableClassName="TBDD_GROUPSDataTable" msprop:Generator_TableVarName="tableTBDD_GROUPS">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GUID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="GUID" msprop:Generator_ColumnPropNameInTable="GUIDColumn" msprop:Generator_ColumnPropNameInRow="GUID" msprop:Generator_ColumnVarNameInTable="columnGUID" type="xs:int" />
|
|
<xs:element name="NAME" msprop:Generator_UserColumnName="NAME" msprop:Generator_ColumnPropNameInTable="NAMEColumn" msprop:Generator_ColumnPropNameInRow="NAME" msprop:Generator_ColumnVarNameInTable="columnNAME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ECM_FK_ID" msprop:Generator_UserColumnName="ECM_FK_ID" msprop:Generator_ColumnPropNameInTable="ECM_FK_IDColumn" msprop:Generator_ColumnPropNameInRow="ECM_FK_ID" msprop:Generator_ColumnVarNameInTable="columnECM_FK_ID" type="xs:int" />
|
|
<xs:element name="AD_SYNC" msprop:Generator_UserColumnName="AD_SYNC" msprop:Generator_ColumnPropNameInTable="AD_SYNCColumn" msprop:Generator_ColumnPropNameInRow="AD_SYNC" msprop:Generator_ColumnVarNameInTable="columnAD_SYNC" type="xs:boolean" />
|
|
<xs:element name="INTERNAL" msprop:Generator_UserColumnName="INTERNAL" msprop:Generator_ColumnPropNameInTable="INTERNALColumn" msprop:Generator_ColumnPropNameInRow="INTERNAL" msprop:Generator_ColumnVarNameInTable="columnINTERNAL" type="xs:boolean" />
|
|
<xs:element name="ACTIVE" msprop:Generator_UserColumnName="ACTIVE" msprop:Generator_ColumnPropNameInTable="ACTIVEColumn" msprop:Generator_ColumnPropNameInRow="ACTIVE" msprop:Generator_ColumnVarNameInTable="columnACTIVE" type="xs:boolean" />
|
|
<xs:element name="COMMENT" msprop:Generator_UserColumnName="COMMENT" msprop:Generator_ColumnPropNameInTable="COMMENTColumn" msprop:Generator_ColumnPropNameInRow="COMMENT" msprop:Generator_ColumnVarNameInTable="columnCOMMENT" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="200" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHO" msprop:Generator_UserColumnName="ADDED_WHO" msprop:Generator_ColumnPropNameInTable="ADDED_WHOColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHO" msprop:Generator_ColumnVarNameInTable="columnADDED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHEN" msprop:Generator_UserColumnName="ADDED_WHEN" msprop:Generator_ColumnPropNameInTable="ADDED_WHENColumn" msprop:Generator_ColumnPropNameInRow="ADDED_WHEN" msprop:Generator_ColumnVarNameInTable="columnADDED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CHANGED_WHO" msprop:Generator_UserColumnName="CHANGED_WHO" msprop:Generator_ColumnPropNameInTable="CHANGED_WHOColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHO" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CHANGED_WHEN" msprop:Generator_UserColumnName="CHANGED_WHEN" msprop:Generator_ColumnPropNameInTable="CHANGED_WHENColumn" msprop:Generator_ColumnPropNameInRow="CHANGED_WHEN" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="VWPMO_RIGHT_GROUP" msprop:Generator_RowEvHandlerName="VWPMO_RIGHT_GROUPRowChangeEventHandler" msprop:Generator_RowDeletedName="VWPMO_RIGHT_GROUPRowDeleted" msprop:Generator_RowDeletingName="VWPMO_RIGHT_GROUPRowDeleting" msprop:Generator_RowEvArgName="VWPMO_RIGHT_GROUPRowChangeEvent" msprop:Generator_TablePropName="VWPMO_RIGHT_GROUP" msprop:Generator_RowChangedName="VWPMO_RIGHT_GROUPRowChanged" msprop:Generator_RowChangingName="VWPMO_RIGHT_GROUPRowChanging" msprop:Generator_TableClassName="VWPMO_RIGHT_GROUPDataTable" msprop:Generator_RowClassName="VWPMO_RIGHT_GROUPRow" msprop:Generator_TableVarName="tableVWPMO_RIGHT_GROUP" msprop:Generator_UserTableName="VWPMO_RIGHT_GROUP">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_UserColumnName="ID" type="xs:int" />
|
|
<xs:element name="ENTITY_ID" msprop:Generator_ColumnPropNameInRow="ENTITY_ID" msprop:Generator_ColumnPropNameInTable="ENTITY_IDColumn" msprop:Generator_ColumnVarNameInTable="columnENTITY_ID" msprop:Generator_UserColumnName="ENTITY_ID" type="xs:int" />
|
|
<xs:element name="ENTITY_NAME" msprop:Generator_ColumnPropNameInRow="ENTITY_NAME" msprop:Generator_ColumnPropNameInTable="ENTITY_NAMEColumn" msprop:Generator_ColumnVarNameInTable="columnENTITY_NAME" msprop:Generator_UserColumnName="ENTITY_NAME">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="GROUP_ID" msprop:Generator_ColumnPropNameInRow="GROUP_ID" msprop:Generator_ColumnPropNameInTable="GROUP_IDColumn" msprop:Generator_ColumnVarNameInTable="columnGROUP_ID" msprop:Generator_UserColumnName="GROUP_ID" type="xs:int" />
|
|
<xs:element name="GROUP_NAME" msprop:Generator_ColumnPropNameInRow="GROUP_NAME" msprop:Generator_ColumnPropNameInTable="GROUP_NAMEColumn" msprop:Generator_ColumnVarNameInTable="columnGROUP_NAME" msprop:Generator_UserColumnName="GROUP_NAME" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="EDIT_REC" msprop:Generator_ColumnPropNameInRow="EDIT_REC" msprop:Generator_ColumnPropNameInTable="EDIT_RECColumn" msprop:Generator_ColumnVarNameInTable="columnEDIT_REC" msprop:Generator_UserColumnName="EDIT_REC" type="xs:boolean" />
|
|
<xs:element name="ADD_REC" msprop:Generator_ColumnPropNameInRow="ADD_REC" msprop:Generator_ColumnPropNameInTable="ADD_RECColumn" msprop:Generator_ColumnVarNameInTable="columnADD_REC" msprop:Generator_UserColumnName="ADD_REC" type="xs:boolean" />
|
|
<xs:element name="DELETE_REC" msprop:Generator_ColumnPropNameInRow="DELETE_REC" msprop:Generator_ColumnPropNameInTable="DELETE_RECColumn" msprop:Generator_ColumnVarNameInTable="columnDELETE_REC" msprop:Generator_UserColumnName="DELETE_REC" type="xs:boolean" />
|
|
<xs:element name="ADD_DOC" msprop:Generator_ColumnPropNameInRow="ADD_DOC" msprop:Generator_ColumnPropNameInTable="ADD_DOCColumn" msprop:Generator_ColumnVarNameInTable="columnADD_DOC" msprop:Generator_UserColumnName="ADD_DOC" type="xs:boolean" />
|
|
<xs:element name="VIEW_DOC" msprop:Generator_ColumnPropNameInRow="VIEW_DOC" msprop:Generator_ColumnPropNameInTable="VIEW_DOCColumn" msprop:Generator_ColumnVarNameInTable="columnVIEW_DOC" msprop:Generator_UserColumnName="VIEW_DOC" type="xs:boolean" />
|
|
<xs:element name="DELETE_DOC" msprop:Generator_ColumnPropNameInRow="DELETE_DOC" msprop:Generator_ColumnPropNameInTable="DELETE_DOCColumn" msprop:Generator_ColumnVarNameInTable="columnDELETE_DOC" msprop:Generator_UserColumnName="DELETE_DOC" type="xs:boolean" />
|
|
<xs:element name="ADDED_WHO" msprop:Generator_ColumnPropNameInRow="ADDED_WHO" msprop:Generator_ColumnPropNameInTable="ADDED_WHOColumn" msprop:Generator_ColumnVarNameInTable="columnADDED_WHO" msprop:Generator_UserColumnName="ADDED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ADDED_WHEN" msprop:Generator_ColumnPropNameInRow="ADDED_WHEN" msprop:Generator_ColumnPropNameInTable="ADDED_WHENColumn" msprop:Generator_ColumnVarNameInTable="columnADDED_WHEN" msprop:Generator_UserColumnName="ADDED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CHANGED_WHO" msprop:Generator_ColumnPropNameInRow="CHANGED_WHO" msprop:Generator_ColumnPropNameInTable="CHANGED_WHOColumn" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHO" msprop:Generator_UserColumnName="CHANGED_WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CHANGED_WHEN" msprop:Generator_ColumnPropNameInRow="CHANGED_WHEN" msprop:Generator_ColumnPropNameInTable="CHANGED_WHENColumn" msprop:Generator_ColumnVarNameInTable="columnCHANGED_WHEN" msprop:Generator_UserColumnName="CHANGED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBPMO_FORM_CONSTRUCTOR" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="TBPMO_FORM_CONSTRUCTOR_DETAIL_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBPMO_FORM_CONSTRUCTOR_DETAIL" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="TBDD_CONNECTION_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBDD_CONNECTION" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="VWTEMPQUICKVIEW_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:VWTEMPQUICKVIEW" />
|
|
<xs:field xpath="mstns:Record-ID" />
|
|
</xs:unique>
|
|
<xs:unique name="TBWH_ENTITIES_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBWH_ENTITIES" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="TBWH_USER_GROUPS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBWH_USER_GROUPS" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="TBPMO_SAP_FUBA_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBPMO_SAP_FUBA" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="USER_RIGHTS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:USER_RIGHTS" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="TBPMO_DOCSEARCH_RESULTLIST_CONFIG_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBPMO_DOCSEARCH_RESULTLIST_CONFIG" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="TBPMO_LOG_ESSENTIALS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBPMO_LOG_ESSENTIALS" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="TBPMO_DOCRESULT_DROPDOWN_ITEMS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBPMO_DOCRESULT_DROPDOWN_ITEMS" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="TBDD_GROUPS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:TBDD_GROUPS" />
|
|
<xs:field xpath="mstns:GUID" />
|
|
</xs:unique>
|
|
<xs:unique name="VWPMO_RIGHT_GROUP_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:VWPMO_RIGHT_GROUP" />
|
|
<xs:field xpath="mstns:ID" />
|
|
<xs:field xpath="mstns:ENTITY_ID" />
|
|
<xs:field xpath="mstns:GROUP_ID" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="FK_TBPMO_FORM_CONSTRUCTOR_DETAIL_CONSTRUCT_ID" msdata:parent="TBPMO_FORM_CONSTRUCTOR" msdata:child="TBPMO_FORM_CONSTRUCTOR_DETAIL" msdata:parentkey="GUID" msdata:childkey="CONSTRUCT_ID" msprop:Generator_UserParentTable="TBPMO_FORM_CONSTRUCTOR" msprop:Generator_UserChildTable="TBPMO_FORM_CONSTRUCTOR_DETAIL" msprop:Generator_RelationVarName="relationFK_TBPMO_FORM_CONSTRUCTOR_DETAIL_CONSTRUCT_ID" msprop:Generator_ChildPropName="GetTBPMO_FORM_CONSTRUCTOR_DETAILRows" msprop:Generator_UserRelationName="FK_TBPMO_FORM_CONSTRUCTOR_DETAIL_CONSTRUCT_ID" msprop:Generator_ParentPropName="TBPMO_FORM_CONSTRUCTORRow" />
|
|
<msdata:Relationship name="FK_TBPMO_DOCRESULT_DROPDOWN_ITEMSCONFIG_ID" msdata:parent="TBPMO_DOCSEARCH_RESULTLIST_CONFIG" msdata:child="TBPMO_DOCRESULT_DROPDOWN_ITEMS" msdata:parentkey="GUID" msdata:childkey="CONFIG_ID" msprop:Generator_UserParentTable="TBPMO_DOCSEARCH_RESULTLIST_CONFIG" msprop:Generator_UserChildTable="TBPMO_DOCRESULT_DROPDOWN_ITEMS" msprop:Generator_RelationVarName="relationFK_TBPMO_DOCRESULT_DROPDOWN_ITEMSCONFIG_ID" msprop:Generator_ChildPropName="GetTBPMO_DOCRESULT_DROPDOWN_ITEMSRows" msprop:Generator_UserRelationName="FK_TBPMO_DOCRESULT_DROPDOWN_ITEMSCONFIG_ID" msprop:Generator_ParentPropName="TBPMO_DOCSEARCH_RESULTLIST_CONFIGRow" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |