EAS BOS 分录 F7 过滤 动态 级联 详细使用

之前写了一篇 EAS BOS F7 过滤 动态 级联 详细使用 现在再介绍一下分录 F7的动态使用；

1、新建一张业务单据，存在两个F7控件，基本库位属于仓库，只有选择了仓库才，能确定库位。发布业务单元，如下：

2、打开JAVA视图，找到EDITUI JAVA文件，新增方法

　　a)首先为仓库添加过滤，prmtwarehouse为仓库F7,并添加监听事件。分录与表头还是有区别的，但代码大同小异；

　　区别在于分录的F7并不像表头一样是个单独的控件，而是属于表格的一列。所以先拿到设置一个F7然后，将F7绑定到指定列就可以了。

	private void initF7() {
		final KDBizPromptBox kdtEntrys_warehouse_PromptBox = new KDBizPromptBox();
		kdtEntrys_warehouse_PromptBox
				.setQueryInfo("com.kingdee.eas.basedata.scm.im.inv.app.F7AllWarehouseQuery");
		kdtEntrys_warehouse_PromptBox.setVisible(true);
		kdtEntrys_warehouse_PromptBox.setEditable(true);
		kdtEntrys_warehouse_PromptBox.setDisplayFormat("$number$");
		kdtEntrys_warehouse_PromptBox.setEditFormat("$number$");
		kdtEntrys_warehouse_PromptBox.setCommitFormat("$number$");

		EntityViewInfo entityView = new EntityViewInfo();
		FilterInfo filter = new FilterInfo();
		filter.getFilterItems().add(
				new FilterItemInfo("storageOrg.id", "FQgAAAAABmLM567U",
						CompareType.EQUALS));
		entityView.setFilter(filter);
		kdtEntrys_warehouse_PromptBox.setEntityViewInfo(entityView);

		KDTDefaultCellEditor kdtEntrys_warehouse_CellEditor = new KDTDefaultCellEditor(
				kdtEntrys_warehouse_PromptBox);
		this.kdtEntrys.getColumn("warehouse").setEditor(
				kdtEntrys_warehouse_CellEditor);
		ObjectValueRender kdtEntrys_warehouse_OVR = new ObjectValueRender();
		kdtEntrys_warehouse_OVR.setFormat(new BizDataFormat("$name$"));
		this.kdtEntrys.getColumn("warehouse").setRenderer(
				kdtEntrys_warehouse_OVR);

		kdtEntrys.addKDTEditListener(new KDTEditAdapter() {
			public void editStopped(KDTEditEvent e) {
				try {
					kdtEntrys_Changed(e.getRowIndex(), e.getColIndex());
				} catch (Exception exc) {
					handUIException(exc);
				}
			}
		});
		
	}

　　

　　b)为库位添加过滤，prmtlocationhouse为库位F7；当前添加的F7过滤，与仓库并无太大相关，只是在新打开单据时做的F7初始化。这是一个表格列级的初始化。

private void locationhouseF7(String warehouseid) {
		final KDBizPromptBox kdtEntrys_locationhouse_PromptBox = new KDBizPromptBox();
		kdtEntrys_locationhouse_PromptBox
				.setQueryInfo("com.kingdee.eas.basedata.scm.im.inv.app.F7LocationQuery");
		kdtEntrys_locationhouse_PromptBox.setVisible(true);
		kdtEntrys_locationhouse_PromptBox.setEditable(true);
		kdtEntrys_locationhouse_PromptBox.setDisplayFormat("$number$");
		kdtEntrys_locationhouse_PromptBox.setEditFormat("$number$");
		kdtEntrys_locationhouse_PromptBox.setCommitFormat("$number$");

		EntityViewInfo entityView = new EntityViewInfo();
		FilterInfo filter = new FilterInfo();
		filter.getFilterItems().add(
				new FilterItemInfo("WAREHOUSE.id", warehouseid,
						CompareType.EQUALS));
		entityView.setFilter(filter);
		kdtEntrys_locationhouse_PromptBox.setEntityViewInfo(entityView);

		KDTDefaultCellEditor kdtEntrys_locationhouse_CellEditor = new KDTDefaultCellEditor(
				kdtEntrys_locationhouse_PromptBox);
		this.kdtEntrys.getColumn("locationhouse").setEditor(
				kdtEntrys_locationhouse_CellEditor);
		ObjectValueRender kdtEntrys_locationhouse_OVR = new ObjectValueRender();
		kdtEntrys_locationhouse_OVR.setFormat(new BizDataFormat("$name$"));
		this.kdtEntrys.getColumn("locationhouse").setRenderer(
				kdtEntrys_locationhouse_OVR);

	}

　　c)新增仓库F7更新事件方法，并为库位添加单元格级F7过滤

private void locationhouseCellF7(int rowIndex, Object object) {
		String warehouseid = null;
		if (object != null) {
			warehouseid = ((WarehouseInfo) object).getId().toString();
		}
		final KDBizPromptBox kdtEntrys_locationhouse_PromptBox = new KDBizPromptBox();
		kdtEntrys_locationhouse_PromptBox
				.setQueryInfo("com.kingdee.eas.basedata.scm.im.inv.app.F7LocationQuery");
		kdtEntrys_locationhouse_PromptBox.setVisible(true);
		kdtEntrys_locationhouse_PromptBox.setEditable(true);
		kdtEntrys_locationhouse_PromptBox.setDisplayFormat("$number$");
		kdtEntrys_locationhouse_PromptBox.setEditFormat("$number$");
		kdtEntrys_locationhouse_PromptBox.setCommitFormat("$number$");

		EntityViewInfo entityView = new EntityViewInfo();
		FilterInfo filter = new FilterInfo();
		filter.getFilterItems().add(
				new FilterItemInfo("WAREHOUSE.id", warehouseid,
						CompareType.EQUALS));
		entityView.setFilter(filter);
		kdtEntrys_locationhouse_PromptBox.setEntityViewInfo(entityView);
		try {
			LocationCollection local = LocationFactory.getRemoteInstance()
					.getLocationCollection(entityView);

			if (local.size() > 0) {
				// kdtEntrys_locationhouse_PromptBox.setRequired(true);
				this.kdtEntrys.getCell(rowIndex, "locationhouse").setValue(
						local.get(0));
				this.kdtEntrys.getCell(rowIndex, "locationhouse")
						.getFormattedStyleAttributes().setBackground(
								new Color(252, 251, 223));
			} else {
				// kdtEntrys_locationhouse_PromptBox.setRequired(false);
				this.kdtEntrys.getCell(rowIndex, "locationhouse")
						.getFormattedStyleAttributes().setBackground(
								new Color(252, 255, 255));
			}
		} catch (BOSException e1) {
			e1.printStackTrace();
		}

		KDTDefaultCellEditor kdtEntrys_locationhouse_CellEditor = new KDTDefaultCellEditor(
				kdtEntrys_locationhouse_PromptBox);
		this.kdtEntrys.getCell(rowIndex, "locationhouse").setEditor(
				kdtEntrys_locationhouse_CellEditor);

	}

//更新事件
public void kdtEntrys_Changed(int rowIndex, int colIndex) throws Exception {
		if ("warehouse"
				.equalsIgnoreCase(kdtEntrys.getColumn(colIndex).getKey())) {
			locationhouseCellF7(rowIndex, this.kdtEntrys.getCell(rowIndex,
					colIndex).getValue());
		}
	}

　　d)重写beforeStoreFields(ActionEvent e)方法进行必输项验证 ，同样也可以使用重写verifyInput(ActionEvent e)的方法；

/**
	 * 分录必输项检查
	 */
	@Override
	protected void beforeStoreFields(ActionEvent arg0) throws Exception {
		for (int i = 0, n = kdtEntrys.getRowCount(); i < n; i++) {
			if (kdtEntrys.getCell(i, "locationhouse").getStyleAttributes()
					.getBackground().equals(new Color(252, 251, 223))
					&& com.kingdee.bos.ui.face.UIRuleUtil.isNull(kdtEntrys
							.getCell(i, "locationhouse").getValue())) {
				throw new com.kingdee.eas.common.EASBizException(
						com.kingdee.eas.common.EASBizException.CHECKBLANK,
						new Object[] { "库位" });
			}
		}
		super.beforeStoreFields(arg0);
	}

　　e)分录单元格级的F7并不会在打开单据时触发。这样会影响我们的级联，所以要想办法让它执行，如下：

　　在loadFields()方法中，执行一下单元格级F7。loadFields()在执行将数据加载到界面UI控件。load是用来加载界面信息，只执行一次。在执行保存时，不会再次触发。所以使用loadFields()；

public void loadFields() {
		super.loadFields();
		for (int i = 0, n = kdtEntrys.getRowCount(); i < n; i++) {
			locationhouseCellF7(i, this.kdtEntrys.getCell(i, "warehouse")
					.getValue());
		}
	}

　　f)在构造方法中调用我们写的方法

public F7EntryFilterEditUI() throws Exception {
		super();
		initF7();
                locationhouseF7(null);          
	}

　3、完成后，刷新启动服务，即可实现F7动态级联，并实现动态改必输校验。

PS:以上功能有个难点未实现,就是分录单元格设置必输项。如果是表头设置 .setRequired(true) 就可以了，但如果是分录，并没有这个方法，研究多时，不得法；

本实例，只是为单元格添加了一个底色。如有同行知道如何设置，请评论，感激不尽。

转载于:https://www.cnblogs.com/simple-point/p/9310053.html