/**
* 사용전검사 기자재 조회
*
* @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);
}