while(rs.next()){
PMSheetData objData = new PMSheetData();
objData.fabid = StringUtil.nvl( rs.getString("FABID") );
objData.eqid = rs.getInt("EQID");
objData.eqcode = StringUtil.nvl( rs.getString("EQCODE") );
objData.eqtype = StringUtil.nvl( rs.getString("eqtype") );
objData.eqmn = StringUtil.nvl( rs.getString("eqmn") );
objData.version = rs.getInt("version");
objData.sheetdate = StringUtil.nvl( rs.getString("SHEETDATE") );
objData.reguserid = StringUtil.nvl( rs.getString("REGUSERID") );
objData.regusername = StringUtil.nvl( rs.getString("REGUSERNAME") );
objData.regdate = StringUtil.nvl( rs.getString("REGDATE") );
objData.plandate = StringUtil.nvl( rs.getString("PLANDATE") );
objList.addElement(objData);
}
}
catch (SQLException se)
{
se.printStackTrace();
throw new MidasException("PMSheetDAO.getPmSheetApproval()", se);
}
catch (Exception e)
{
e.printStackTrace();
throw new MidasException("PMSheetDAO.getPmSheetApproval()", e);
}
finally
{
try
{
//=======================================================
// PrepareStatement, Record Set 초기화.
//=======================================================
if(rs!=null) { rs.close(); rs = null; }
if(pstmt != null) { pstmt.close(); pstmt = null; }
}
catch (SQLException se)
{
se.printStackTrace();
}
}
return objList;
}
/**
* 장비코드 콤보리스트 조
*
* @param objConn
* @return
* @throws Exception
*/
public static Vector getEqcodeList(Connection objConn
, String selectedfabid
, String selectedeqtype
, String selectedeqmodel ) throws Exception {
PreparedStatement pstmt = null;
ResultSet rs = null;
Vector objList = new Vector();
try
{
//-------------------------------------------------------
// Query 생성. 데이터를 가져온다.
//--------------------------------------------------------
StringBuffer strQry = new StringBuffer();
strQry.append(" SELECT distinct a.EQCODE \n");
strQry.append(" FROM MIDAS_EQUIPMENT a \n");
strQry.append(" , MIDAS_PMSHEET_BODY b \n");
strQry.append(" WHERE a.AREAID = '분석' \n");
strQry.append(" AND A.EQMN = B.EQMN \n");
strQry.append(" AND B.ISTREND = 'Y' \n");
strQry.append(" AND (? is null or a.FABID = ?) \n");
strQry.append(" AND (? is null or a.EQCODE LIKE '_").append(selectedeqtype).append("___') \n");
strQry.append(" AND (? is null or a.EQMN = ?) \n");
// Object[] bind = new Object[] {
// selectedfabid
// ,selectedfabid
// ,selectedeqtype
// ,selectedeqmodel
// ,selectedeqmodel
// };
//
// System.out.println("================== 장비코드 콤보리스트 조회 ====================");
// System.out.println(SqlUtil.generateSqlQuery(objConn, strQry.toString(), bind));
// System.out.println("==========================================================");
pstmt = objConn.prepareStatement(strQry.toString());
pstmt.setString(1, selectedfabid);
pstmt.setString(2, selectedfabid);
pstmt.setString(3, selectedeqtype);
pstmt.setString(4, selectedeqmodel);
pstmt.setString(5, selectedeqmodel);
//-------------------------------------------------------
// Query 실행.
//-------------------------------------------------------
rs = pstmt.executeQuery();
while(rs.next()){
PMSheetData objData = new PMSheetData();
objData.eqcode = rs.getString("EQCODE");
objList.addElement(objData);
}
}
catch (SQLException se)
{
se.printStackTrace();
throw new MidasException("PMSheetDAO.getEqcodeList()", se);
}
catch (Exception e)
{
e.printStackTrace();
throw new MidasException("PMSheetDAO.getEqcodeList()", e);
}
finally
{
try
{
//=======================================================
// PrepareStatement, Record Set 초기화.
//=======================================================
if(rs!=null) { rs.close(); rs = null; }
if(pstmt != null) { pstmt.close(); pstmt = null; }
}
catch (SQLException se)
{
se.printStackTrace();
}
}
return objList;
}
}
