hongtaiyang/websrc/com/kingdee/eas/hr/perf/handler/AreaBaseConfig.java

package com.kingdee.eas.hr.perf.handler;

import com.google.common.collect.Sets;
import com.kingdee.bos.BOSException;
import com.kingdee.bos.Context;
import com.kingdee.eas.util.app.DbUtil;
import com.kingdee.jdbc.rowset.IRowSet;

import java.sql.SQLException;
import java.util.Set;

/**
 * description: AreaBaseUtil <br>
 * date: 2025/10/17 18:34 <br>
 * author: lhbj <br>
 * version: 1.0 <br>
 *
 */
public class AreaBaseConfig {
    public final static String AREABASE ="HbulTDUkQBSS5kI9V4xZfIqoXbM=";

    public static Set<String> getAreaBases(Context ctx) throws BOSException, SQLException {
        Set<String> areaBases = Sets.newHashSet();
        String sqlAreaBase = "select fid from T_EVA_EvaluFormAreaBase where fid =? or FRELATEDAREAID=?";
        IRowSet rs = DbUtil.executeQuery(ctx,sqlAreaBase,new Object[]{AreaBaseConfig.AREABASE,AreaBaseConfig.AREABASE});
        while (rs.next()){
            String fid = rs.getString("fid");
            areaBases.add(fid);
        }
        return areaBases;
    }
    public static Set<String> getAreaBases(Context ctx,String AREABASE) throws BOSException, SQLException {
        Set<String> areaBases = Sets.newHashSet();
        String sqlAreaBase = "select fid from T_EVA_EvaluFormAreaBase where fid =? or FRELATEDAREAID=?";
        IRowSet rs = DbUtil.executeQuery(ctx,sqlAreaBase,new Object[]{AREABASE,AREABASE});
        while (rs.next()){
            String fid = rs.getString("fid");
            areaBases.add(fid);
        }
        return areaBases;
    }
}