EAS BOS F7控件过滤（含表头和表体）

来源：互联网发布：哪里买狗靠谱知乎编辑：程序博客网时间：2024/05/16 07:29

1: 单据头F7的过滤.

/** *  * @Title: initEntry  * @Description: TODO(初始化分录信息)  * @return void 返回类型  * @throws */ private void initF7() { try { //初始化物料LSCilentUtils.initTreeMaterialF7(prmtMaterial, NewExceptionBillUI.this);} catch (Exception e) {e.printStackTrace();}//单据类型的过滤String sql=" select fid from T_SCM_BillType where fname_l2 in ('采购入库单','生产入库单','其他入库单','调拨入库单','领料出库单','销售出库单','调拨出库单','其他出库单') ";String billids="";try {IRowSet rs = SQLExecutorFactory.getRemoteInstance(sql).executeSQL();while(rs.next()){billids+=""+rs.getString("fid")+",";}if(!"".equals(billids)){billids = billids.substring(0, billids.length()-1);EntityViewInfo entityView = new EntityViewInfo();FilterInfo filter = new FilterInfo();filter.getFilterItems().add(new FilterItemInfo("id",billids,CompareType.INCLUDE));entityView.setFilter(filter);prmtBillType.setEntityViewInfo(entityView);}} catch (BOSException e) {e.printStackTrace();}catch (SQLException e) {e.printStackTrace();}}

2：分录F7的过滤

/** *  * @Title: initEntry  * @Description: TODO(初始化分录F7信息)  * @return void 返回类型  * @throws */ private void initF7() { if(Constant.JSLYCOMPANYID.equals(puInfo.getId().toString())){String userids = "";BasicDataMoveAuditMoveAuditorCollection conn =  bInfo.getMoveAuditor();for(int i=0;i<conn.size();i++){BasicDataMoveAuditMoveAuditorInfo beinfo = conn.get(i);userids += beinfo.getAuditor().getId().toString()+",";}/**  人员过滤   **/if(!StringUtils.isEmpty(userids)){final KDBizPromptBox kdtEntrys_moveAuditor_PromptBox = new KDBizPromptBox();kdtEntrys_moveAuditor_PromptBox.setQueryInfo("com.kingdee.eas.base.permission.app.F7AllUserQuery");userids = userids.substring(0, userids.length()-1);EntityViewInfo ev = new EntityViewInfo();FilterInfo filter = new FilterInfo();filter.getFilterItems().add(new FilterItemInfo("id",userids,CompareType.INCLUDE));ev.setFilter(filter);kdtEntrys_moveAuditor_PromptBox.setEntityViewInfo(ev);KDTDefaultCellEditor kdtEntrys_moveAuditor_CellEditor = new KDTDefaultCellEditor(kdtEntrys_moveAuditor_PromptBox);this.kdtEntrys.getColumn("moveAuditor").setEditor(kdtEntrys_moveAuditor_CellEditor);ObjectValueRender kdtEntrys_moveAuditor_OVR = new ObjectValueRender();kdtEntrys_moveAuditor_OVR.setFormat(new BizDataFormat("$name$"));this.kdtEntrys.getColumn("moveAuditor").setRenderer(kdtEntrys_moveAuditor_OVR);}}}

0 0