随笔- 491 文章- 1 评论- 36 阅读- 145万

核心方法

 OAAdvancedTableBean table = (OAAdvancedTableBean)webBean.findChildRecursive("TimeEntryTbl");     
 OAMessageChoiceBean elePoplist = (OAMessageChoiceBean)table.findChildRecursive("ElementSelect");     
 elePoplist.setListVOBoundContainerColumn(0, table, "EmployeeGroupName");     
 elePoplist.setListVOBoundContainerColumn(1, table, "PeriodEndDate");     
 elePoplist.setListVOBoundContainerColumn(2, table, "AssignmentId");     
 elePoplist.setPickListCacheEnabled(false);

问题扩展。

在页面中有添加新一行的操作，如何使添加的新一行中的poplist的值集跟着当前行的LOV返回的值变化而变化。

核心思路：

在MessageChoice中绑定poplist取值来源的时候不要使用dependent poplist，而是使用View Instance。

有些关联list是需要上下文限制的，如省市选择，甚至还是在table中。2个poplist通过pvo实例化，在根据事件，刷新VO是不行的，因为是多行，而且局部事件是早于poplist数值获取的，这样也没办法加限制条件。【摘自oraclearea51 的Sudhakar Mani文章】

视图定义

控件设置

代码控制

ProcessRequest

ProcessFormRequest

//视图定义
CountryVO
select Meaning ,LookupCode from fnd_lookup_values_vl where lookup_type='CHOLA_COUNTRY'
StateVO
select Meaning ,LookupCode from fnd_lookup_values_vl where lookup_type='CHOLA_State' and tag= :1

//控件设置
ID Country
Picklist View Definition:chola.oracle.apps.fnd.poplist.server.CountryVO
Picklist View Instance :CountryVO1
Picklist Display Attribute:Meaning
Picklist Value Attribute:LookupCode
ActionType - fireParialAction
Event - country

ID State
Picklist View Definition:chola.oracle.apps.fnd.poplist.server.StateVO
Picklist View Instance :StateVO1
Picklist Display Attribute:Meaning
Picklist Value Attribute:LookupCode
ActionType - fireParialAction

//代码控制
//processRequest

OAAdvanceTableBean advTable = (OAAdvanceTableBean)webBean.findChildRecursive("ResultAdvTable");
OAMessageChoiceBean statePoplist = (OAMessageChoiceBean)advTable.findChildRecursive("State");
statePoplist.setListVOBoundContainerColumn(0,advTable,"Country");

//processFormRequest

if("country".equals(pageContext.getParameter(OAWebBeanConstants.EVENT_PARAM))){
    am.invokeMethod(initStateVOQuery);
}

//AM

public void statePoplist(){
    StateVOImpl vo = (StateVOImpl) getStateVO1();
    if(vo==null){
        MessageToken[] errorTokens= {new MessageToken("OBJECT_NAME","CountryVO1")};
        throw new OAException("AK","FWK_TBX_OBJECT_NOT_FOUND",errorTokens);
    }
    vo.executeQuery();
}