bos常用数据的查询方法

来源：互联网发布：运动软件哪个好编辑：程序博客网时间：2024/05/18 00:14

/*根据某个SQL语句查询一个实体数据集*/

String sql = "select number, entries.id,entries.newDay,entries.newHour where id = '"
+ id + "'";
LeaveBillCollection c = LeaveBillFactory.getRemoteInstance().getLeaveBillCollection(sql);

/*根据一个实体id,获取这个实体对象*/

ObjectUuidPK PK=new ObjectUuidPK(row.getString("Type.id"));

IIndustry iIndustry=IndustryFactory.getRemoteInstance();
IndustryInfo industryInfo=(IndustryInfo) iIndustry.getValue(PK);

/*查询某个Query的数据*/

//先构建一个Query:com.kingdee.eas.gzw.basedata.app.CentralCorpobyOrgQuery

IMetaDataPK queryPK = new MetaDataPK("com.kingdee.eas.gzw.basedata.app.CentralCorpobyOrgQuery");
IQueryExecutor queryExcutor = QueryExecutorFactory.getRemoteInstance(queryPK);

//设置过滤条件

queryExcutor.setObjectView(viewInfo);
//查询出所有满足条件的集合;

IRowSet rows=queryExcutor.executeQuery();

/*下面的方法仅限于客户端的实体所对应的Edit界面*/

LeaveBillInfo leaveBillInfo= (LeaveBillInfo) this.getBizInterface().getValue("select leaveBill.id where id = '" + id + "'").get("leaveBill");