Exportfile for AOT version 1.0 or later
Formatversion: 1
***Element: FTM
; Axapta Menu Item: AccessRecordList_maz, выгружен Пятница 05.12.2003
; --------------------------------------------------------------------------------
MENUFUNCTIONVERSION 1
MENUFUNCTION #AccessRecordList_maz
Type: 1
PROPERTIES
Name #AccessRecordList_maz
Label #@SYS58093
HelpText #
Class #Form
Object #AccessRecordList_maz
Parameters #
EnumTypeParameter #
EnumParameter #
RunOn #Called from
FeatureKey #
NeededAccessLevel #View
MultiSelect #No
Web #
WebAccess #All
WebSecureTransaction #No
WebPage #
ENDPROPERTIES
ENDMENUFUNCTION
***Element: DBT
; Axapta Table : AccessRecordList_maz unloaded at Пятница 05.12.2003
; --------------------------------------------------------------------------------
TABLEVERSION 1
TABLE #AccessRecordList_maz
PROPERTIES
Name #AccessRecordList_maz
Label #@SYS58093
FormRef #
TitleField1 #refTableID
TitleField2 #refFieldID
Temporary #No
FeatureKey #
MaxAccessMode #Delete
CacheLookup #EntireTable
CreateRecIdIndex #No
SaveDataPerCompany #Yes
TableGroup #Miscellaneous
PrimaryIndex #GroupTableFieldIdx
ClusterIndex #
ModifiedDate #Yes
ModifiedTime #Yes
ModifiedBy #Yes
ModifiedTransactionId #No
CreatedDate #Yes
CreatedTime #Yes
CreatedBy #Yes
CreatedTransactionID #No
ENDPROPERTIES
FIELDS
FIELD #refTableID
INT
PROPERTIES
Type #Integer
Name #refTableID
Label #
HelpText #
GroupPrompt #
SaveContents #Yes
Mandatory #No
AllowEditOnCreate #No
AllowEdit #No
Visible #Yes
FeatureKey #
Table #AccessRecordList_maz
AliasFor #
ExtendedDataType
ARRAY
#tableId
#
ENDARRAY
FieldUpdate #Absolute
ENDPROPERTIES
FIELD #refFieldID
INT
PROPERTIES
Type #Integer
Name #refFieldID
Label #
HelpText #
GroupPrompt #
SaveContents #Yes
Mandatory #No
AllowEditOnCreate #No
AllowEdit #No
Visible #Yes
FeatureKey #
Table #AccessRecordList_maz
AliasFor #
ExtendedDataType
ARRAY
#fieldId
#
ENDARRAY
FieldUpdate #Absolute
ENDPROPERTIES
FIELD #groupID
STRING
PROPERTIES
Type #String
Name #groupID
Label #
HelpText #
GroupPrompt #
SaveContents #Yes
Mandatory #No
AllowEditOnCreate #Yes
AllowEdit #Yes
Visible #Yes
FeatureKey #
Table #AccessRecordList_maz
AliasFor #
ExtendedDataType
ARRAY
#userGroupId
#
ENDARRAY
StringSize #10
Adjustment #Left
ENDPROPERTIES
FIELD #RangeValue
STRING
PROPERTIES
Type #String
Name #RangeValue
Label #
HelpText #
GroupPrompt #
SaveContents #Yes
Mandatory #No
AllowEditOnCreate #Yes
AllowEdit #Yes
Visible #Yes
FeatureKey #
Table #AccessRecordList_maz
AliasFor #
ExtendedDataType
ARRAY
#Range
#
ENDARRAY
StringSize #250
Adjustment #Left
ENDPROPERTIES
FIELD #RangeStatus
ENUM
PROPERTIES
Type #Enum
Name #RangeStatus
Label #
HelpText #
GroupPrompt #
SaveContents #Yes
Mandatory #No
AllowEditOnCreate #Yes
AllowEdit #Yes
Visible #Yes
FeatureKey #
Table #AccessRecordList_maz
AliasFor #
ExtendedDataType
ARRAY
#
#
ENDARRAY
EnumType #RangeStatus
ENDPROPERTIES
FIELD #userID
STRING
PROPERTIES
Type #String
Name #userID
Label #
HelpText #
GroupPrompt #
SaveContents #Yes
Mandatory #No
AllowEditOnCreate #Yes
AllowEdit #Yes
Visible #Yes
FeatureKey #
Table #AccessRecordList_maz
AliasFor #
ExtendedDataType
ARRAY
#userId
#
ENDARRAY
StringSize #5
Adjustment #Left
ENDPROPERTIES
ENDFIELDS
GROUPS
GROUP #AutoReport
GROUPFIELDS
ENDGROUPFIELDS
ENDGROUP
GROUP #AutoLookup
GROUPFIELDS
ENDGROUPFIELDS
ENDGROUP
GROUP #@SYS1046
GROUPFIELDS
#RangeValue
#RangeStatus
ENDGROUPFIELDS
ENDGROUP
GROUP #@SYS5711
GROUPFIELDS
#refTableID
#refFieldID
#groupID
#userID
ENDGROUPFIELDS
ENDGROUP
GROUP #@SYS8498
GROUPFIELDS
#refFieldID
#fieldName
#getFieldLabel
ENDGROUPFIELDS
ENDGROUP
GROUP #@SYS8868
GROUPFIELDS
#refTableID
#tablename
#getTableLabel
ENDGROUPFIELDS
ENDGROUP
GROUP #@SYS9039
GROUPFIELDS
#tablename
#fieldName
#groupID
#userID
#RangeValue
#RangeStatus
ENDGROUPFIELDS
ENDGROUP
ENDGROUPS
INDICES
#GroupTableFieldIdx
PROPERTIES
Name #GroupTableFieldIdx
AllowDuplicates #No
Enabled #Yes
FeatureKey #
ENDPROPERTIES
INDEXFIELDS
#refTableID
#refFieldID
#groupID
#userID
ENDINDEXFIELDS
ENDINDICES
REFERENCES
ENDREFERENCES
DELETEACTIONS
ENDDELETEACTIONS
METHODS
Version: 3
SOURCE #caption
#public str caption()
#{
# str ret;
#
# ret = strfmt('%1: %2, %3: %4',"@SYS11906",this.getTableLabel(),"@SYS8498",this.getFieldLabel());
#
# Return ret;
#}
ENDSOURCE
SOURCE #fieldName
#edit FieldName fieldName(boolean set, FieldName name)
#{
# if (set)
# {
# this.refFieldId = fieldName2Id(this.refTableId, name);
# }
#
# return fieldId2Name(this.refTableId, this.refFieldId);
#}
ENDSOURCE
SOURCE #getFieldLabel
#display FieldLabel getFieldLabel(fieldId _fieldId = this.refFieldID,
# tableId _tableId = this.refTableID)
#{
# SysDictField sysDictField;
# ;
# sysDictField = new SysDictField(_tableId, _fieldId);
#
# if (sysDictField)
# {
# return sysDictField.label();
# }
#
# return fieldId2Name(_tableId, _fieldId);
#}
ENDSOURCE
SOURCE #getTableLabel
#display TableLabel getTableLabel(tableId _tableId = this.refTableID)
#{
# SysDictTable sysDictTable;
# ;
# sysDictTable = new SysDictTable(_tableId);
#
# if (sysDictTable)
# {
# return sysDictTable.label();
# }
#
# return tableId2Name(_tableId);
#}
ENDSOURCE
SOURCE #tablename
#edit TableName tablename(boolean set = false, TableName name= '')
#{
# if (set)
# {
# this.refTableId = tableName2Id(name);
# }
#
# return tableId2Name(this.refTableId);
#}
ENDSOURCE
SOURCE #updateQuery
#// Этот метод можно вызывать из любой формы, отчета или собственного query
#// Вызывать лучше из метода init в Query после добавления своих критериев.
#// Этот метод удобнее вызывать, если query уже выделен в отдельную переменную.
#//
#// Типичный вызов из init'а выглядит седующим образом
#// public void init()
#// {
#// super();
#//
#// //+SMAZ, 02.03.31, фильтр записей
#// AccessRecordList_maz::updateQuery(this.query());
#// //-SMAZ
#//}
#static boolean updateQuery(Query query)
#{
# TmpSysQuery tmpSysQuery;
# AccessRecordList_maz accessRecordList;
# UserGroupList userGroupList;
# UserID userID = curuserid();
#
# QueryBuildDataSource dataSource;
# QueryBuildRange queryRange;
# DictTable dictTable;
# int dataSourceCount;
# int dataSourceNo;
# int fieldNo;
# int rangeCount;
#
# str value;
# boolean found;
# boolean ret;
#
#;
# dataSourceCount = query.dataSourceCount();
#
# // Заполняем список таблиц и полей
# for( dataSourceNo = 1; dataSourceNo <= dataSourceCount; ++dataSourceNo )
# {
# dataSource = query.dataSourceNo(dataSourceNo);
# tmpSysQuery.Table_Id = dataSource.table();
# tmpSysQuery.insert();
# }
# // Заполнили
#
# while select accessRecordList
# index hint GroupTableFieldIdx
# join userGroupList
# where userGroupList.userId == userID
# && ( userGroupList.groupId == accessRecordList.groupID
# || userGroupList.userId == accessRecordList.userID
# )
# join TmpSysQuery
# where accessRecordList.refTableID == tmpSysQuery.Table_Id
# {
# if( !accessRecordList.RangeValue )
# continue; // Пустые критерии не обрабатываем
#
# for( dataSourceNo = 1; dataSourceNo <= dataSourceCount; ++dataSourceNo )
# {
# dataSource = query.dataSourceNo(dataSourceNo);
# if( accessRecordList.refTableID != dataSource.table() ) continue;
#
# found = false;
# rangeCount = dataSource.rangeCount();
# for( fieldNo = 1; fieldNo <= rangeCount; ++fieldNo )
# {
# queryRange = dataSource.range(fieldNo);
# if(
# queryRange.field() != accessRecordList.refFieldID
# || queryRange.status() != accessRecordList.RangeStatus
# )
# continue;
#
# // Нашли критерий. Добавляем наш фильтр во все критерии по этому полю.
# value = queryRange.value();
# if( value )
# { // критерий уже задан. Добавляем свой
# queryRange.value(value+','+accessRecordList.RangeValue);
# }
# else
# { // Критерий задан. Но он пустой. Странно. Но продолжаем
# queryRange.value(accessRecordList.RangeValue);
# }
# found = true; // Нашли критерий по этому полю. И даже обработали его.
# ret = true;
# }
#
# if( !found )
# {
# // Если критерия по данному полю в датасорсе не было
# queryRange = dataSource.addRange(accessRecordList.refFieldID);
# queryRange.value(accessRecordList.RangeValue);
# queryRange.status(accessRecordList.RangeStatus);
# ret = true;
# }
# }
# }
# return ret;
#}
ENDSOURCE
ENDMETHODS
ENDTABLE
***Element: FRM
; Axapta Forms unloaded at Пятница 05.12.2003
; --------------------------------------------------------------------------------
FRMVERSION 5
FORM #AccessRecordList_maz
PROPERTIES
Name #AccessRecordList_maz
ENDPROPERTIES
METHODS
Version: 3
SOURCE #classDeclaration
#public class FormRun extends ObjectRun
#{
#}
ENDSOURCE
SOURCE #lookupFieldID
#void lookupFieldID()
#{
# int fieldID;
# ;
#
# fieldID = pickField(AccessRecordList_maz.refTableID);
# if( !fieldID ) return; // ввод отменен
#
# AccessRecordList_maz.refFieldId = fieldID;
# AccessRecordList_maz_ds.refresh();
#}
ENDSOURCE
ENDMETHODS
OBJECTBANK
DATASOURCE
OBJECTPOOL
PROPERTIES
Name #AccessRecordList_maz
Table #AccessRecordList_maz
Index #
Company #
CounterField #
AllowCheck #Yes
AllowEdit #Yes
AllowCreate #Yes
AllowDelete #Yes
StartPosition #First
AutoSearch #Yes
AutoNotify #Yes
AutoQuery #Yes
OnlyFetchActive #No
JoinSource #
LinkType #Delayed
DelayActive #Yes
InsertAtEnd #Yes
InsertIfEmpty #Yes
ENDPROPERTIES
FIELDLIST
ENDFIELDLIST
ENDOBJECTPOOL
ENDDATASOURCE
ENDOBJECTBANK
JOINS
ENDJOINS
DESIGN
PROPERTIES
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
Visible #Yes
Caption #@SYS58093
TitleDatasource #AccessRecordList_maz
Frame #Standard
WindowResize #Dynamic
WindowType #Standard
SaveSize #No
AlwaysOnTop #No
HideToolbar #No
setCompany #Yes
ColorScheme #Default
CssClass #
ShowWebHelp #Default
BackgroundColor #Button face (3D)
ImageName #
ImageResource #0
Imagemode #Normal (preserve pict. attributes)
Mode #Watch
SubmitMethod #Auto
SupportReload #No
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #AccessRecordList_maz
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
ENDPROPERTIES
CONTAINER
CONTROL TAB
PROPERTIES
Name #Tab
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Column width
Height #Column height
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
ColorScheme #Default
BackgroundColor #Button face (3D)
BackStyle #Opaque
Tabs #0
Tab #1
ShowTabs #Yes
TabPlacement #top
TabLayout #One line
SelectControl #Yes
DataSource #
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #2
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #No
TabAutoChange #Yes
ENDPROPERTIES
CONTAINER
CONTROL TABPAGE
PROPERTIES
Name #Overview
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Column width
Height #Column height
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
ColorScheme #Default
BackgroundColor #Button face (3D)
BackStyle #Opaque
Caption #@SYS9039
DataSource #
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
TabAutoChange #No
ENDPROPERTIES
CONTAINER
CONTROL GRID
PROPERTIES
Name #Grid
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Column width
Height #Column height
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
ColorScheme #Default
BackgroundColor #Window background
TopMargin #0
BottomMargin #0
LeftMargin #0
RightMargin #0
MultiSelect #Yes
VisibleCols #Auto
VisibleRows #Auto
ShowColLabels #Yes
ShowRowLabels #Yes
HighlightActive #Yes
ActiveBackColor #Highlight background
ActiveForeColor #Highlight text
DataSource #AccessRecordList_maz
DataGroup #@SYS9039
AutoDataGroup #No
ENDPROPERTIES
CONTAINER
CONTROL STRINGEDIT
PROPERTIES
Name #tablename
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
LookupButton #Auto
ReplaceOnLookup #Yes
SearchAfterInput #Auto
LimitText #Auto
DisplayLength #Auto
DisplayHeight #Auto
Border #Auto
Text #
PasswordStyle #No
Alignment #Auto
ChangeCase #Auto
MultiLine #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #
ArrayIndex #0
DataMethod #tablename
ENDPROPERTIES
ENDCONTROL
CONTROL STRINGEDIT
PROPERTIES
Name #fieldName
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
LookupButton #Always
ReplaceOnLookup #Yes
SearchAfterInput #Auto
LimitText #Auto
DisplayLength #Auto
DisplayHeight #Auto
Border #Auto
Text #
PasswordStyle #No
Alignment #Auto
ChangeCase #Auto
MultiLine #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #
ArrayIndex #0
DataMethod #fieldName
ENDPROPERTIES
METHODS
Version: 3
SOURCE #lookup
#public void lookup()
#{
# element.lookupFieldID();
#}
#
ENDSOURCE
ENDMETHODS
ENDCONTROL
CONTROL STRINGEDIT
PROPERTIES
Name #groupID
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
LookupButton #Auto
ReplaceOnLookup #Yes
SearchAfterInput #Auto
LimitText #Auto
DisplayLength #Auto
DisplayHeight #Auto
Border #Auto
Text #
PasswordStyle #No
Alignment #Auto
ChangeCase #Auto
MultiLine #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #groupID
ArrayIndex #0
ENDPROPERTIES
ENDCONTROL
CONTROL STRINGEDIT
PROPERTIES
Name #userID
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
LookupButton #Auto
ReplaceOnLookup #Yes
SearchAfterInput #Auto
LimitText #Auto
DisplayLength #Auto
DisplayHeight #Auto
Border #Auto
Text #
PasswordStyle #No
Alignment #Auto
ChangeCase #Auto
MultiLine #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #userID
ArrayIndex #0
ENDPROPERTIES
ENDCONTROL
CONTROL STRINGEDIT
PROPERTIES
Name #RangeValue
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
LookupButton #Always
ReplaceOnLookup #No
SearchAfterInput #Auto
LimitText #Auto
DisplayLength #Auto
DisplayHeight #Auto
Border #Auto
Text #
PasswordStyle #No
Alignment #Auto
ChangeCase #Auto
MultiLine #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #RangeValue
ArrayIndex #0
ENDPROPERTIES
METHODS
Version: 3
SOURCE #lookup
#public void lookup()
#{
# TmpSysQuery tmpSysQuery;
# Query query;
#
# //super();
#;
# tmpSysQuery.Table_Id = AccessRecordList_maz.refTableId;
# tmpSysQuery.Field_Id = AccessRecordList_maz.refFieldID;
# tmpSysQuery.insert();
#
# SysLookup::lookupRange(this, tmpSysQuery.RecId, tmpSysQuery, query);
#}
ENDSOURCE
ENDMETHODS
ENDCONTROL
CONTROL COMBOBOX
PROPERTIES
Name #RangeStatus
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
Selection #0
DisplayLength #Auto
HideFirstEntry #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #RangeStatus
ArrayIndex #0
Border #Auto
ComboType #Standard
AppendNew #No
ENDPROPERTIES
ENDCONTROL
ENDCONTAINER
ENDCONTROL
CONTROL GROUP
PROPERTIES
Name #Group
AutoDeclaration #No
Visible #Yes
AllowEdit #No
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
FrameType #Auto
FramePosition #Outside
Caption #
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Button face (3D)
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #2
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
DataGroup #
AutoDataGroup #No
ENDPROPERTIES
CONTAINER
CONTROL GROUP
PROPERTIES
Name #Таблица1
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
FrameType #Auto
FramePosition #Outside
Caption #
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Button face (3D)
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #AccessRecordList_maz
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
DataGroup #@SYS8868
AutoDataGroup #Yes
ENDPROPERTIES
CONTAINER
ENDCONTAINER
ENDCONTROL
CONTROL GROUP
PROPERTIES
Name #Поля1
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
FrameType #Auto
FramePosition #Outside
Caption #
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Button face (3D)
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #AccessRecordList_maz
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
DataGroup #@SYS8498
AutoDataGroup #Yes
ENDPROPERTIES
CONTAINER
ENDCONTAINER
ENDCONTROL
ENDCONTAINER
ENDCONTROL
ENDCONTAINER
ENDCONTROL
CONTROL TABPAGE
PROPERTIES
Name #General
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Column width
Height #Column height
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
ColorScheme #Default
BackgroundColor #Button face (3D)
BackStyle #Opaque
Caption #@SYS2952
DataSource #
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #2
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
TabAutoChange #No
ENDPROPERTIES
CONTAINER
CONTROL GROUP
PROPERTIES
Name #Group1
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
FrameType #None
FramePosition #Outside
Caption #
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Button face (3D)
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
DataGroup #
AutoDataGroup #No
ENDPROPERTIES
CONTAINER
CONTROL GROUP
PROPERTIES
Name #Идентификация
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
FrameType #Auto
FramePosition #Outside
Caption #
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Button face (3D)
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #AccessRecordList_maz
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
DataGroup #@SYS5711
AutoDataGroup #Yes
ENDPROPERTIES
CONTAINER
ENDCONTAINER
ENDCONTROL
CONTROL GROUP
PROPERTIES
Name #Критерий
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
FrameType #Auto
FramePosition #Outside
Caption #
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Button face (3D)
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #AccessRecordList_maz
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
DataGroup #@SYS1046
AutoDataGroup #No
ENDPROPERTIES
CONTAINER
CONTROL STRINGEDIT
PROPERTIES
Name #RangeValue
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
LookupButton #Always
ReplaceOnLookup #Yes
SearchAfterInput #Auto
LimitText #Auto
DisplayLength #Auto
DisplayHeight #Auto
Border #Auto
Text #
PasswordStyle #No
Alignment #Auto
ChangeCase #Auto
MultiLine #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #RangeValue
ArrayIndex #0
ENDPROPERTIES
METHODS
Version: 3
SOURCE #lookup
#public void lookup()
#{
# TmpSysQuery tmpSysQuery;
# Query query;
#
# //super();
#;
# tmpSysQuery.Table_Id = AccessRecordList_maz.refTableId;
# tmpSysQuery.Field_Id = AccessRecordList_maz.refFieldID;
# tmpSysQuery.insert();
#
# SysLookup::lookupRange(this, tmpSysQuery.RecId, tmpSysQuery, query);
#}
ENDSOURCE
ENDMETHODS
ENDCONTROL
CONTROL COMBOBOX
PROPERTIES
Name #RangeStatus
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
Selection #0
DisplayLength #Auto
HideFirstEntry #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #RangeStatus
ArrayIndex #0
Border #Auto
ComboType #Standard
AppendNew #No
ENDPROPERTIES
ENDCONTROL
ENDCONTAINER
ENDCONTROL
ENDCONTAINER
ENDCONTROL
CONTROL GROUP
PROPERTIES
Name #Group2
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
FrameType #None
FramePosition #Outside
Caption #
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Button face (3D)
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
DataGroup #
AutoDataGroup #No
ENDPROPERTIES
CONTAINER
CONTROL GROUP
PROPERTIES
Name #Таблица
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
FrameType #Auto
FramePosition #Outside
Caption #
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Button face (3D)
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #AccessRecordList_maz
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
DataGroup #@SYS8868
AutoDataGroup #Yes
ENDPROPERTIES
CONTAINER
ENDCONTAINER
ENDCONTROL
CONTROL GROUP
PROPERTIES
Name #Поля
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #No
HelpText #
FeatureKey #
DragDrop #None
FrameType #Auto
FramePosition #Outside
Caption #
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Button face (3D)
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
DataSource #AccessRecordList_maz
TopMargin #Auto
BottomMargin #Auto
LeftMargin #Auto
RightMargin #Auto
ArrangeWhen #Default
ArrangeMethod #Vertical
Columns #1
Columnspace #Auto
ArrangeGuide
ARRAY INDEX Columns
#0
ENDARRAY
HideIfEmpty #Yes
AlignChildren #Yes
AlignChild #Yes
DataGroup #@SYS8498
AutoDataGroup #No
ENDPROPERTIES
CONTAINER
CONTROL INTEDIT
PROPERTIES
Name #refFieldID
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
LookupButton #Auto
ReplaceOnLookup #Yes
SearchAfterInput #Auto
LimitText #Auto
DisplayLength #Auto
DisplayHeight #Auto
Border #Auto
Value #0
Alignment #Auto
SignDisplay #Auto
RotateSign #Auto
ShowZero #Auto
DisplaceNegative #Auto
AllowNegative #Auto
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #refFieldID
ArrayIndex #0
ENDPROPERTIES
ENDCONTROL
CONTROL STRINGEDIT
PROPERTIES
Name #fieldName
AutoDeclaration #No
Visible #Yes
AllowEdit #Yes
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
LookupButton #Always
ReplaceOnLookup #Yes
SearchAfterInput #Auto
LimitText #Auto
DisplayLength #Auto
DisplayHeight #Auto
Border #Auto
Text #
PasswordStyle #No
Alignment #Auto
ChangeCase #Auto
MultiLine #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #
ArrayIndex #0
DataMethod #fieldName
ENDPROPERTIES
METHODS
Version: 3
SOURCE #lookup
#public void lookup()
#{
# element.lookupFieldID();
#}
#
ENDSOURCE
ENDMETHODS
ENDCONTROL
CONTROL STRINGEDIT
PROPERTIES
Name #getFieldLabel
AutoDeclaration #No
Visible #Yes
AllowEdit #No
Left #Auto (left)
Top #Auto
Width #Auto
Height #Auto
VerticalSpacing #Auto
Enabled #Yes
Skip #No
AlignControl #Yes
HelpText #
FeatureKey #
DragDrop #None
LookupButton #Auto
ReplaceOnLookup #Yes
SearchAfterInput #Auto
LimitText #Auto
DisplayLength #Auto
DisplayHeight #Auto
Border #Auto
Text #
PasswordStyle #No
Alignment #Auto
ChangeCase #Auto
MultiLine #No
ColorScheme #Default
BackStyle #Opaque
BackgroundColor #Window background
ForegroundColor #Window text
Font #
FontSize #0
Italic #No
Underline #No
Bold #Default
CharacterSet #0
LabelForegroundColor #Window text
ShowLabel #Yes
Label #
LabelFont #
LabelFontSize #0
LabelItalic #No
LabelUnderline #No
LabelBold #Default
LabelCharacterSet #0
LabelWidth #Auto
LabelHeight #Auto
LabelPosition #Left
LabelAlignment #Right
DataSource #AccessRecordList_maz
DataField #
ArrayIndex #0
DataMethod #getFieldLabel
ENDPROPERTIES
ENDCONTROL
ENDCONTAINER
ENDCONTROL
ENDCONTAINER
ENDCONTROL
ENDCONTAINER
ENDCONTROL
ENDCONTAINER
ENDCONTROL
ENDCONTAINER
ENDDESIGN
ENDFORM
***Element: DOA
#APPLDOC:\\Forms\AccessRecordList_maz
[XRNAME PATH="APPLDOC:\\Forms\AccessRecordList_maz"]
В этом окне можно просмотреть и установить доступность на зписей различных таблиц. Для группы пользователей или для конкретного пользователя Вы можете указать . Он применяется сразу при открытии формы. С помощью поля можно запретить или разрешить пользователю изменять диапазон при фильтрации записей.
Совет:
Работать с доступом будет удобнее, если в поле устанавливать значения, которые надо разрешить. Т.е. определять допустимые значения. Не стоит указывать запрещяемые значения.
Например, вы хотите указать, что пользователям отдела продаж можно работать со складами Склад-1, Склад-2, Продаж и все склады брака. Для этого надо найти (или создать) строку и указать следующие значения:
|
|
|
|
| Склады |
Склад |
Продаж |
Склад-1, Склад-2, Продаж, Брак* |
Если вы хотите, чтобы пользователеь мог удалить этот диапазон и просмотреть все склады, то укажите в поле значение OPEN. Если вы хотите, чтобы пользователь не смог изменить заданный вами диапазон и никогда не смог просмотреть другие склады, то укажите в поле значение HIDDEN.
Внимание:
Если заданные вами критерии не работают, это значит, что программисты не активизировали в нужных Вам формах механизм доступа к записям. Попросите программистов активизировать контроль доступа в ваших формах.
Программистам:
Для того, чтобы активизировать контроль доступа в формах, необходимо в конце Init-метода нужного DataSource'а вставить одну строчку.
AccessRecordList_maz::updateQuery(this.query());
По вопросам обращайтесь к разработчикам.
ENDDOC
***Element: PRN
; Axapta Project : mazAccessRecord unloaded at Пятница 05.12.2003
; --------------------------------------------------------------------------------
PROJECTVERSION 1
PROJECT #mazAccessRecord
SHARED
SOURCE #mazAccessRecord
#Formatversion: 1
#'mazAccessRecord' 695,82,372,575
#Projectformat: 0
#FTM 1'AccessRecordList_maz'
#{
#}
#DBT'AccessRecordList_maz'
#{
#}
#FRM'AccessRecordList_maz'
#{
#}
#DOC APPLDOC 5 'AccessRecordList_maz'
#{
#}
#
ENDSOURCE
ENDPROJECT
***Element: END