Solutions Monkey: EP Tips-n-Tricks - Data Sets / Data Sources

[Blog bot]

Источник: http://blogs.msdn.com/solutions/arch...a-sources.aspx
==============
Happy New Year !!!

Data Sets

Init

For checking arguments passed from managed code or context and adding ranges/ modifying query.

if (element.args().dataset() == tablenum(EPPriceCalc))

{

epPriceCalc = element.args().record();

custTable = CustTable::find(epPriceCalc.AccountNum);

priceTransferParmId = epPriceCalc.ParmId;

}



Pack/UnPack

Persisting values of in-memory variables between postbacks

public container pack()

{

return [#CurrentVersion, #CurrentList] + [super()];

}

public boolean unpack(container _pack)

{

Integer version = conpeek(_pack,1);

container base;

boolean ret;



switch (version)

{

case #CurrentVersion : [version, #currentList, base] = _pack;

ret = super(base);

break;

default: super(_pack);

}



return ret;



}

Other Methods

Also common methods that could be called from Managed code or from other methods in the Data sources could be added at the DataSet level.

Args

Get external arguments through the args objects

Checking for RecordContext

public void init()

{

;



super();

EPPersonalize::find(curuserid());

if (element.args() && element.args().dataset() == tablenum(EmplTable))

{

callerEmplTable = element.args().record();

emplId = callerEmplTable.EmplId;

}



}

Passing parameters from Managed code to X++ in dataset

protected<SPAN style="mso-bidi-language: TA"> void Page_Init(object sender, EventArgs e)
{
this.AxDataSource1.CreatingDataSetRun += new EventHandler(AxDataSource1_CreatingDataSetRun);
}

Set the param value to the event arugments

void AxDataSource1_CreatingDataSetRun(object sender, CreatingDataSetRunEventArgs e)

{

e.DataSetRunArgs.parm = "4000";

}



In AOT override or add method in the data set and use element.args().parm() to received the paramter

public void executeQuery()
{

QueryBuildRange custRange;
;
custRange = SysQuery::findOrCreateRange(this.query().dataSourceNo(1), fieldnum(CustTable, AccountNum));
custRange.value(element.args().parm());
super();

}

You can also pass an Enum. For example

void AxDataSource1_CreatingDataSetRun(object sender, CreatingDataSetRunEventArgs e)
{
e.DataSetRunArgs.parmEnumType = EnumMetadata.EnumNum(this.AxSession, "EPFormAction");
e.DataSetRunArgs.parmEnum(2);
}



public void init()
{
super();

if (element.args().parmEnumType() == enumnum(EPFormAction) && element.args().parmEnum() == EPFormAction::CreateMode)
{
//do somethign here

}
}



Data Sources

Set the below properties at the individual datasources.

InsertAtEnd : No

InsertIfEmpty : No



Also set Allow* properties on the Data source appropriately.

Init

Adding ranges



public void init()

{

super();



qbrName = this.query().dataSourceTable(tablenum(InventDimCombination)).addRange(fieldnum(InventDimCombination,Name));

qbrName.status(RangeStatus::Hidden);



qbrItem = this.query().dataSourceTable(tablenum(InventDimCombination)).addRange(fieldnum(InventDimCombination,ItemId));

qbrItem.status(RangeStatus::Hidden);

}



Setting temporary table mode

public void init()

{

super();

//BP Deviation documented

salesTable.setTmp();

}

InitValue

Initializing values

public void initValue()

{

super();



// Is form called with a record

if (element.args() && element.args().record())

{

callerRecord = element.args().record();

// Init opportunity from lead record

if (callerRecord.TableId == tablenum(smmLeadTable))

{

smmCreateEntity::initFromCommon(callerRecord, smmOpportunityTable);

info(DirParty::toolTip(smmOpportunityTable));

}

}

}

ValidateWrite

For validation that are specific to the dataset. ( common table level validation could be at the table level)

public boolean validateWrite()

{

#VendRequest

boolean ret;



ret = super();



if (ret && !VendTable::find(vendrequest.AccountNum))

ret = checkFailed(strfmt("@SYS301682",vendrequest.AccountNum));



if (ret && element.args().managedContentItemName() == #VendRequestStatusChangeAddEdit &&

DirPerson::find(vendRequest.ContactParty) == null)

ret = checkFailed(strfmt("@SYS301683",vendrequest.ContactParty));



return ret;

}

Write

For updating tables not in the data set and reread

public void write()

{



if (purchLine.RecId)

{

purchLine.InventDimId = InventDim::findOrCreate(inventDim).InventDimId;

purchLine_ds.setCurrentInventDim();



mapLines.insert(purchLine.RecId, purchLine);

}

super();

}

.datasetlookup

For Customizing field lookup. This does not appear in the override method list. But you should be able to manually create this method which will act as override.

void dataSetLookup(SysDataSetLookup sysDataSetLookup)

{

List list;

Query query;



args = new Args();

list = new List(Types::String);

list.addEnd(fieldstr(ProjTable, ProjId));

list.addEnd(fieldstr(ProjTable, Name));

list.addEnd(fieldstr(ProjTable, Status));

sysDataSetLookup.parmLookupFields(list);

sysDataSetLookup.parmSelectField('ProjId');



// Call query

query = projTimeSheet_ds.getProjectIDQuery();



// Pass the query to SysDataSetLookup so it result is rendered in the lookup page.

sysDataSetLookup.parmQuery(query);

}

.modified

public void modified()

{

super();



purchLine.modifyItemDim(inventDim,

fieldnum(InventDim,ConfigId),

InventTable::itemProductDimensionGroup(purchLine.ItemId));

purchLine_ds.setCurrent();

}

AXDataSourceControl

Make sure only one AXDataSourceControl has Role property set to Provider ( or ProviderConsumer) in your user control. If the user control contains other user control then across all these , only one datasourcecontrol should play the provider role.

Always set EnableViewState and PersistState to True( This is the default. Don’t change it)

AXGridView

1. DataKeyNames must point to a one (or set) of unique fields int the DataSetView.

2. If the user control is playing the Provider Role ( a propert on the AX user control webpart) , then at least one AXDataSourceControl should have the Role property set to Provider or ProviderConsumer and the ProviderView is set.

AXForm

1. Make Sure DataKeyNames set correctly.

2. When Fields are selected for AXGroup using the boundfield designer, sometime the selectedfields are updated to the markup. (Known bug). Update the markup directly and add the boundfields.

3. If the same Axform control is used for different modes than use the EPFormAction parameter set on the WebContent and switch to the right mode

4. Set the DataMember to _Current

5. UpdateOnPostBack is generally set to False. If you need to access the field values entered in the control before the record is persisted in a postback, then set it to true. For example if you want to change the lookup of a second control based on the value entered on the first control, then you would need to set this property.

6. If you are using the Form for Edit operation set AutoGenerateEditButton to true.



protected void Page_Init(object sender, EventArgs e)

{



this.SetupMode();

}

private void SetupMode()

{

switch (this.FormMode)

{

case ApplicationProxy.EPFormAction.EditMode:

if (this.PageDefinition != null)

{

this.PageDefinition.pageTitle = Labels.GetLabel("@SYS131104");

}

this.formVendRequestProfileEdit.DefaultMode = DetailsViewMode.Edit;

this.formVendRequestProfileEdit.AutoGenerateEditButton = true;

break;



default:

this.formVendRequestProfileEdit.DefaultMode = DetailsViewMode.ReadOnly;

break;

}

}

8. Derive from AxBaseUserControl if the AxForm control requires RecordContext and should not display any data when there is no record Context.



protected override bool RequiresExternalContext

{

get

{

if (this.FormAction == AppProxy.EPFormAction.CreateMode)

{

return false;

}

else

{

return true;

}

}

}



9. Some useful code generally used in AXForm controls

//Web part private

AxBaseWebPart _baseWebpart = null;



//Webpart

AxBaseWebPart BaseWebpart

{

get

{

//return the basewebpart if it is not null

if (this._baseWebpart != null)

return this._baseWebpart;

//get the webpart if basewebpart is null

this._baseWebpart = AxBaseWebPart.GetWebpart(this);

return this._baseWebpart;

}

}

//Web part managed content item for the page

Proxy.WebManagedContentItem ContentItem

{

get

{

//get the managed content item from the webpart

return this.BaseWebpart == null ? null : this.BaseWebpart.WebManagedContentItem;

}

}

private Boolean IsCustomer()

{

bool isCustomerBool = false;

if (ApplicationProxy.EP.isCustomer(AxSession.AxaptaAdapter))

{

isCustomerBool = true;



}

return isCustomerBool;

}

static AxBoundField GetField(DataControlFieldCollection fields, string name)

{

foreach (DataControlField field in fields)

{

AxBoundField boundField = field as AxBoundField;

if (boundField != null && String.Compare(boundField.DataField, name, true) == 0)

{

return boundField;

}

}

return null;

}





==============
Источник: http://blogs.msdn.com/solutions/arch...a-sources.aspx