|
发表于 2017-11-14 11:21:10
|
显示全部楼层
action中code代码
/**
*获取资料员(得到的机构Id是以','隔开的)
* @param concept 概念名称
* @param activity 环节名称()
* @param ognIds 多个机构ID
* @return List<OrgUnit>
*/
public static List<OrgUnit> queryogn(String concept ,String activity,String ognIds){
List<String> result = new ArrayList<String>();
if(ognIds!=null){
String[] arr=ognIds.split(",");
for(String str:arr){
String query = "select t1.OGNID from config_BizOgn t1 JOIN config_BizType t " +
" ON t1.BizTypeId = t.fid JOIN config_BizDocumenter T2" +
" ON t1.fid = T2.BizOgnId and t.concept =? and t1.activity=? and
t1.ognId=? ";
List<Object> params = new ArrayList<Object>();
params.add(concept);
params.add(activity);
params.add(str);
Table table = SQL.select(query, params, "/CONFIG/Documenter/data", null);
Iterator<Row> it = table.iterator();
while (it.hasNext()){
Row r = it.next();
result.add(r.getString("OGNID"));
}
}
}
List<OrgUnit> persions = OrgUtils.findOrgUnitsByID(result);
//List<OrgUnit> persions = OrgUtils.findSubordinations(result, '', '', true);
// List<OrgUnit> persions = OrgUtils.findPersonMembersInOrg(result, true);
return persions;
} |
|