/** * 保存中继站的日计划填写信息 * * @param planId String 中继站日计划编号 * @param planPatrolResultBean PlanPatrolResultBean 中继站填写信息 * @return String 返回执行动作状态编号 * @throws Exception */ public String insertPlanPatrolResult(String planId, PlanPatrolResultBean planPatrolResultBean) throws Exception { super.setBaseDao(new PlanPatrolResultDayDAO()); PlanPatrolResultDay planPatrolResult = new PlanPatrolResultDay(); if (super.queryExistById(planPatrolResultBean.getTid(), PlanPatrolResultDay.class)) { planPatrolResult = (PlanPatrolResultDay) super.baseDao.load(planPatrolResultBean.getTid(), PlanPatrolResultDay.class); Date createDate = planPatrolResult.getCreateDate(); BeanUtil.objectCopy(planPatrolResultBean, planPatrolResult); planPatrolResult.setCreateDate(createDate); Object object = super.baseDao.update(planPatrolResult); if (object != null) { return ExecuteCode.SUCCESS_CODE; } } else { BeanUtil.objectCopy(planPatrolResultBean, planPatrolResult); planPatrolResult.setTid(ora.getSeq("PLAN_PATROL_RESULT_DAY", 18)); planPatrolResult.setCreateDate(new Date()); Object object = super.baseDao.insert(planPatrolResult); if (object != null) { return ExecuteCode.SUCCESS_CODE; } } return ExecuteCode.FAIL_CODE; }
/** * 获取单位单位下所有巡检人员的计划模板 * * @param deptid * @return */ public List getPatrolStencilList(String deptid) { /* 取得所有巡检员信息*/ String hql = "from PatrolMan where parentid=:deptid and state is NULL"; // List patrollist = new ArrayList(); Session session = bdao.getSession(); Transaction tx = null; try { PatrolManBean pmb = null; tx = session.beginTransaction(); Query query = session.createQuery(hql); query.setParameter("deptid", deptid); // query.setParameter("state", "1"); Iterator it = query.iterate(); while (it.hasNext()) { pmb = new PatrolManBean(); PatrolMan pm = (PatrolMan) it.next(); logger.info("巡检组名" + pm.getPatrolName()); BeanUtil.objectCopy(pm, pmb); String hql_stencil = "from StencilTask where patrolid=:patrolid"; Query query_st = session.createQuery(hql_stencil); query_st.setParameter("patrolid", pm.getPatrolID()); Iterator it_st = query_st.iterate(); while (it_st.hasNext()) { StencilTaskBean stencil = new StencilTaskBean(); StencilTask st = (StencilTask) it_st.next(); BeanUtil.objectCopy(st, stencil); pmb.getTemp().add(stencil); } patrollist.add(pmb); } return patrollist; } catch (Exception e) { logger.error(e); e.printStackTrace(); return null; } }
/** * 根据日计划编号和中继站编号读取中继站填写信息 * * @param stationId String 中继站编号 * @param planId String 日计划编号 * @return PlanPatrolResultBean 返回中继站填写信息 * @throws Exception */ public PlanPatrolResultBean viewPlanStationResult(String stationId, String planId) throws Exception { super.setBaseDao(new PlanPatrolResultDayDAO()); PlanPatrolResultBean planPatrolResultBean = new PlanPatrolResultBean(); String condition = " and repeater_station_id='" + stationId + "' and plan_id='" + planId + "' "; PlanPatrolResultDay planPatrolResult = (PlanPatrolResultDay) super.baseDao.find("PlanPatrolResultDay", condition); if (planPatrolResult != null) { BeanUtil.objectCopy(planPatrolResult, planPatrolResultBean); return planPatrolResultBean; } else { return null; } }