|
本帖最后由 17682333900 于 2017-10-30 14:09 编辑
- public static String ygFindManagerFID(String concept, String relation, String id, Integer managerLevel, String dataModel) {
- HashMap map = new HashMap();
- map.put("fID", id);
- Table table = KSQL.select("select "+concept+"."+relation+" from "+concept+" "+concept+" where "+concept+"=:fID", map, dataModel, null);
- if(table.size()>0){
- Row row = table.iterator().next();
- String orgID = row.getString(relation);
- if(orgID==null){
- return null;
- }
- map.put("orgID", orgID);
- table = KSQL.select("select SA_OPPerson.* from SA_OPPerson SA_OPPerson where SA_OPPerson=:orgID", map, "/system/data", null);
- if(table.size()==0){
- return null;
- }
- row = table.iterator().next();
- String code = row.getString("sCode");
-
- List binds = new ArrayList();
- binds.add(code);
- String managerID = null;
- table = SQL.select("select * from AP_ORG_Employee where fCode=?", binds, "/OA/common/data");
- if(table.size()>0){
- row = table.iterator().next();
- if(managerLevel==null||managerLevel==1){
- managerID = row.getString("fZG1ID");
- }else if(managerLevel==2){
- managerID = row.getString("fZG2ID");
- }else if(managerLevel==3){
- managerID = row.getString("fZG3ID");
- }else if(managerLevel==4){
- managerID = row.getString("fZG4ID");
- }else if(managerLevel==5){
- managerID = row.getString("fFGFZRID");
- }
- if(managerID!=null){
- return managerID;
- }
- }
- }
- return "";
- }
- }
复制代码
这是一个判断 发起流程的人是否是部门主管 ,如果是主管就直接结束流程的一个函数,帮忙看看哪里错了
|
|