/* * 查询批次下的所有学习中心 * * @see * net.cedu.biz.enrollment.BranchEnrollQuotaBiz#findBranchEnrollQuotaByBId * (int) */ public List<BranchEnrollQuota> findBranchEnrollQuotaByBId(int batchId) throws Exception { List<BranchEnrollQuota> branchenrollquotalst = null; PageParame p = new PageParame(); String hqlparam = ""; List<Object> list = new ArrayList<Object>(); if (batchId != 0) { hqlparam += " and batchId =" + Constants.PLACEHOLDER; list.add(batchId); } hqlparam += " and deleteFlag=" + Constants.PLACEHOLDER; list.add(Constants.DELETE_FALSE); p.setHqlConditionExpression(hqlparam); p.setValues(list.toArray()); Long[] branchenrollquotaids = branchenrollquotaDao.getIDs(p); if (branchenrollquotaids != null && branchenrollquotaids.length != 0) { branchenrollquotalst = new ArrayList<BranchEnrollQuota>(); for (int i = 0; i < branchenrollquotaids.length; i++) { BranchEnrollQuota beq = this.findBranchEnrollQuotaById(Integer.valueOf(branchenrollquotaids[i].toString())); BranchEnrollQuota branchenrollquota = beq; Branch branch = branchBiz.findBranchById(branchenrollquota.getBranchId()); if (branch != null) { branchenrollquota.setBranchName(branch.getName()); } branchenrollquotalst.add(branchenrollquota); } } return branchenrollquotalst; }
/* * 查询学习中心指标按批次和中心Id * * @see net.cedu.biz.enrollment.BranchEnrollQuotaBiz# * findBranchEnrollQuotaByBtachIdAndBranchId(int, int) */ public BranchEnrollQuota findBranchEnrollQuotaByBtachIdAndBranchId(int batchId, int branchId) throws Exception { BranchEnrollQuota beq = null; PageParame p = new PageParame(); String hqlparam = ""; List<Object> list = new ArrayList<Object>(); if (batchId != 0) { hqlparam += " and batchId=" + Constants.PLACEHOLDER; list.add(batchId); } if (branchId != 0) { hqlparam += " and branchId=" + Constants.PLACEHOLDER; list.add(branchId); } hqlparam += " and deleteFlag="; list.add(Constants.DELETE_FALSE); p.setHqlConditionExpression(hqlparam); p.setValues(list.toArray()); Long[] branchenrollquotaids = branchenrollquotaDao.getIDs(p); if (branchenrollquotaids != null && branchenrollquotaids.length != 0) { for (int i = 0; i < branchenrollquotaids.length; i++) { // 修改人董溟浩,原作者循环取最后一个,逻辑有问题,所以改为跳过之前的直接取最后一个 if (i == branchenrollquotaids.length - 1) { beq = new BranchEnrollQuota(); beq = this.findBranchEnrollQuotaById(Integer.valueOf(branchenrollquotaids[i].toString())); GlobalEnrollBatch globalenrollbatch = globalenrollbatchBiz.findGlobalEnrollBatchById(beq.getBatchId()); if (globalenrollbatch != null) { beq.setBatchName(globalenrollbatch.getBatch()); } Branch branch = branchBiz.findBranchById(beq.getBranchId()); if (branch != null) { beq.setBranchName(branch.getName()); } } } } return beq; }