Пример #1
0
  /**
   * 사용전검사 기자재 조회
   *
   * @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);
  }
Пример #2
0
  /**
   * 사용전검사 조회
   *
   * @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);
  }
Пример #3
0
  /**
   * 사용전검사 메모 조회
   *
   * @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);
  }