Cacher is the code snippet organizer for pro developers

//获取当前机构 当前人员
               String curOrg = moduleUtil.getParamValue(CURORG);
               String curMan = moduleUtil.getParamValue(CURMAN);
               
               //创建一个flag
               Integer flag = 1;//1表示本人不能看到 2表示本人能看到
               String denomination = moduleUtil.getParamValue(DENOMINATION);
              //先判断目标机构的金库主任包不包括本人
               String qryClrMan="select su.NO " + 
               		"from SYS_USER su left join SYS_USER_POST sup on su.NO = sup.USER_NO " + 
               		"  left join SYS_ORG so on su.ORG_NO = so.NO " + 
               		"where so.NO = ? and sup.POST_NO = 'GWXX0003'";
               sqlParas = new ArrayList<SQLPara>();
               sqlParas.add(new SQLPara("NO",Types.VARCHAR,clrCenterNo));
               CachedRowSet clrManResult = DbOperate.executeQueryByParamName(qryClrMan, sqlParas, conn, logger);
               JSONArray clrManList = new JSONArray();
               while(clrManResult.next()) {
            	   clrManList.add(clrManResult.getString("NO"));
               }
               if(clrManList.size()>0) {
            	   for(int i=0;i<clrManList.size();i++) {
                	   if(clrManList.get(i).equals(curMan)) {
                		   flag = 2;
                	   }
                   }
               }
               if(flag == 1) {
                   moduleUtil.setParamObjValue(RETMSG, "");
                   moduleUtil.setParamObjValue(RETCODE, "00000");
            	   return "ok";
               }