物料多条件过滤

	//配方编码只显示自制品 （物料财务页签），类别只显示原材料
		this.prmtmaterialCoding.setCommitFormat("$name$;$number$");
		this.prmtmaterialCoding.setQueryInfo("com.kingdee.eas.basedata.master.material.app.F7MaterialFIQuery");
		SysContext ctx = SysContext.getSysContext();
		EntityViewInfo material = new EntityViewInfo();
		FilterInfo materialfilterInfo = new FilterInfo();
		materialfilterInfo
				.getFilterItems()
				.add(
						new FilterItemInfo(
								"id",
								"  select  FMATERIALID  from    T_BD_MaterialCompanyInfo where FCalculateType=2  and  Fcompanyid='"+ctx.getCurrentFIUnit( ).getId().toString()+"'  and   FMATERIALID  in ( select  FMATERIALID  from T_BD_MaterialGroupDetial where FMATERIALGROUPSTANDARDID='dR8lnQEPEADgAAWKwKgSxZeb4R8='  and  FMATERIALGROUPID   in ( select    FID  from T_BD_MaterialGroup   where FPARENTID='10YAAAAARc3Hn8BC')  )   ",  
								CompareType.INNER));
		//过滤只显示当前公司组织
		materialfilterInfo
		.getFilterItems()
		.add(
				new FilterItemInfo( "orgUnit.id",ctx.getCurrentFIUnit( ).getId().toString(), CompareType.EQUALS));
		materialfilterInfo.setMaskString("#0  AND #1   ");
		material.setFilter(materialfilterInfo);
		this.prmtmaterialCoding.setEntityViewInfo(material);