/** * 사용전검사 기자재 조회 * * @param request * @param form * @throws Exception */ private void loadEquipData(HttpServletRequest request, UseBeforeParam pm) throws Exception { ReportDAO rDAO = new ReportDAO(); ReportEntity eEntity = null; String RECV_NUM = pm.getScRecv_num(); String SIDO_CODE = user.getSIDO_CODE(); String SIGUNGU_CODE = user.getSIGUNGU_CODE(); StringBuffer sbSQL = new StringBuffer(); sbSQL.append(" SELECT \n"); sbSQL.append(" RECV_NUM, SIDO_CODE, SIGUNGU_CODE ,CIV_RECV_NUM , \n"); sbSQL.append(" TYPE_PROC_NO_CA,TYPE_PROC_NM_CA,FREQUENCY_SCOPE_CA,WIRE_TYPE_CA, \n"); sbSQL.append(" TYPE_PROC_NO_MA,TYPE_PROC_NM_MA,FREQUENCY_SCOPE_MA,WIRE_TYPE_MA, \n"); sbSQL.append( " TYPE_PROC_NO_SMA ,TYPE_PROC_NM_SMA,FREQUENCY_SCOPE_SMA, WIRE_TYPE_SMA,INS_DT,'U' AS EQU_CMD \n"); sbSQL.append(" FROM PT_UB_EQUIPMENT \n"); sbSQL.append(" WHERE RECV_NUM = ? \n"); sbSQL.append(" AND SIDO_CODE = ? \n"); sbSQL.append(" AND SIGUNGU_CODE = ? \n"); rDAO.setValue(1, RECV_NUM); rDAO.setValue(2, SIDO_CODE); rDAO.setValue(3, SIGUNGU_CODE); eEntity = rDAO.select(sbSQL.toString()); request.setAttribute("eEntity", eEntity); }
/** * 사용전검사 조회 * * @param request * @param form * @throws Exception */ private void loadList(HttpServletRequest request, UseBeforeParam pm) throws Exception { ReportDAO rDAO = new ReportDAO(); ReportEntity rEntity = null; // String scRECV_NUM = request.getParameter("scRECV_NUM"); String scRECV_NUM = pm.getScRecv_num(); String SIDO_CODE = user.getSIDO_CODE(); // request.getParameter("SIDO_CODE"); String SIGUNGU_CODE = user.getSIGUNGU_CODE(); // request.getParameter("SIGUNGU_CODE"); String selectSQL = " SELECT UU.*, CC.CODE_NAME, SM.SERVER_ADDR, SM.SEND_SYS_ID,SM.RECV_SYS_ID, SM.SERVER_YN" + " FROM PT_UB_USEBEFORE UU LEFT JOIN PT_COM_CODE CC ON CC.CODE = UU.USE AND CC.P_CODE = 'BLDDIV' " + " LEFT JOIN PT_S_SYSVAR_MASTER SM ON SM.SIGUNGU_CODE = UU.SIGUNGU_CODE \n"; String whereSQL = "WHERE UU.RECV_NUM = '" + scRECV_NUM + "' \n" + " AND UU.SIDO_CODE = '" + SIDO_CODE + "' \n" + " AND UU.SIGUNGU_CODE = '" + SIGUNGU_CODE + "' "; rEntity = rDAO.select(selectSQL + whereSQL); /** **** 검색조건 초기값 ********** */ request.setAttribute("pm", pm); request.setAttribute("rEntity", rEntity); }
/** * 사용전검사 메모 조회 * * @param request * @param form * @throws Exception */ private void loadMemoList(HttpServletRequest request, UseBeforeParam pm) throws Exception { ReportDAO rDAO = new ReportDAO(); ReportEntity rEntity = null; // String scRECV_NUM = request.getParameter("scRECV_NUM"); String scRECV_NUM = pm.getScRecv_num(); String SIDO_CODE = user.getSIDO_CODE(); String SIGUNGU_CODE = user.getSIGUNGU_CODE(); String selectSQL = " SELECT SEQ, MEMO_DT, WRT_TIME, MEMO_CONT, WRT_NAME, INS_DT FROM PT_UB_MEMO \n"; String whereSQL = "WHERE RECV_NUM = '" + scRECV_NUM + "' \n" + " AND SIDO_CODE = '" + SIDO_CODE + "' \n" + " AND SIGUNGU_CODE = '" + SIGUNGU_CODE + "' "; rEntity = rDAO.select(selectSQL + whereSQL); /** **** 검색조건 초기값 ********** */ request.setAttribute("pm", pm); request.setAttribute("mEntity", rEntity); }