<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="com.biz_nis.cmn.CommonMethod" %>
<%@ page import="com.biz_nis.nw_prstus.nw_list.NetworkListDAO" %>
<%@ page import="com.biz_nis.nw_prstus.nw_list.NetworkListDTO" %>
<%@ page import="org.apache.log4j.Logger" %>
<%
Logger l_oLogger = Logger.getLogger( "" );
request.setCharacterEncoding("UTF-8");
if("".equals(CommonMethod.nullChk( (String)session.getAttribute("mbr_id") ))
&& "".equals(CommonMethod.nullChk( (String)session.getAttribute("mbr_pwd") ))) {
out.println("");
}
//변수 선언부
NetworkListDAO l_oNetworkListDAO = null;
NetworkListDTO l_oNetworkListDTO = null;
boolean l_bSuccess = false;
try {
l_oNetworkListDAO = new NetworkListDAO();
l_oNetworkListDTO = new NetworkListDTO();
int p_nCurPage = CommonMethod.intNullChk(request.getParameter("cur_page"));
int p_nListSize = CommonMethod.intNullChk(request.getParameter("list_size"));
String p_sSlct_flag = CommonMethod.nullChk(request.getParameter("slct_flag"));
String p_sSrch_text = CommonMethod.nullChk(request.getParameter("srch_text"));
String p_sSrch_fr_dt = CommonMethod.nullChk(request.getParameter("srch_fr_dt"));
String p_sSrch_to_dt = CommonMethod.nullChk(request.getParameter("srch_to_dt"));
String p_sSlct_idstry = CommonMethod.nullChk(request.getParameter("slct_idstry"));
String p_sSlct_entp = CommonMethod.nullChk(request.getParameter("slct_entp"));
String p_sSlct_jobcl = CommonMethod.nullChk(request.getParameter("slct_jobcl"));
String p_sFlag = CommonMethod.nullChk( request.getParameter("flag") );
String p_sNet_seq = CommonMethod.nullChk(request.getParameter("net_seq"));
String p_sNet_mbr_id = CommonMethod.nullChk( request.getParameter("net_mbr_id") );
String p_sNet_idstry = CommonMethod.nullChk( request.getParameter("net_idstry") );
String p_sNet_dstic = CommonMethod.nullChk( request.getParameter("net_dstic") );
int p_nNet_entp_id = CommonMethod.intNullChk( request.getParameter("net_entp_id") );
String p_sNet_user_nm = CommonMethod.nullChk( request.getParameter("net_user_nm") );
String p_sNet_jobcl = CommonMethod.nullChk( request.getParameter("net_jobcl") );
int p_nNet_age = CommonMethod.intNullChk( request.getParameter("net_age") );
String p_sNet_tel01 = CommonMethod.nullChk( request.getParameter("net_tel01") );
String p_sNet_tel02 = CommonMethod.nullChk( request.getParameter("net_tel02") );
String p_sNet_tel03 = CommonMethod.nullChk( request.getParameter("net_tel03") );
String p_sNet_relshp = CommonMethod.nullChk( request.getParameter("net_relshp") );
String p_sNet_resn = CommonMethod.nullChk( request.getParameter("net_resn") );
String p_sNet_rmark = CommonMethod.convertWEBtoDB( CommonMethod.nullChk( request.getParameter("net_rmark") ) );
int p_nNet_a = CommonMethod.intNullChk( request.getParameter("net_a") );
int p_nNet_b = CommonMethod.intNullChk( request.getParameter("net_b") );
int p_nNet_c = CommonMethod.intNullChk( request.getParameter("net_c") );
int p_nNet_d = CommonMethod.intNullChk( request.getParameter("net_d") );
int p_nNet_e = CommonMethod.intNullChk( request.getParameter("net_e") );
int p_nNet_f = CommonMethod.intNullChk( request.getParameter("net_f") );
int p_nNet_g = CommonMethod.intNullChk( request.getParameter("net_g") );
double l_dNet_total = Math.pow(p_nNet_a, 2)+p_nNet_b+p_nNet_c+p_nNet_d+p_nNet_e+p_nNet_f+Math.pow(p_nNet_g, 2);
String l_sNet_total = String.valueOf( Math.round(l_dNet_total) );
int l_nNet_total = Integer.parseInt( l_sNet_total );
l_oNetworkListDTO.setNet_seq( p_sNet_seq );
l_oNetworkListDTO.setNet_mbr_id( p_sNet_mbr_id );
l_oNetworkListDTO.setNet_idstry( p_sNet_idstry );
l_oNetworkListDTO.setNet_dstic( p_sNet_dstic );
l_oNetworkListDTO.setNet_entp_id( p_nNet_entp_id );
l_oNetworkListDTO.setNet_user_nm( p_sNet_user_nm );
l_oNetworkListDTO.setNet_jobcl( p_sNet_jobcl );
l_oNetworkListDTO.setNet_age( p_nNet_age );
if (!p_sNet_tel01.equals("") && !p_sNet_tel02.equals("") && !p_sNet_tel03.equals("")) {
l_oNetworkListDTO.setNet_tel01( p_sNet_tel01 );
l_oNetworkListDTO.setNet_tel02( p_sNet_tel02 );
l_oNetworkListDTO.setNet_tel03( p_sNet_tel03 );
} else {
l_oNetworkListDTO.setNet_tel01( "" );
l_oNetworkListDTO.setNet_tel02( "" );
l_oNetworkListDTO.setNet_tel03( "" );
}
l_oNetworkListDTO.setNet_relshp( p_sNet_relshp );
l_oNetworkListDTO.setNet_resn( p_sNet_resn );
l_oNetworkListDTO.setNet_rmark( p_sNet_rmark );
l_oNetworkListDTO.setNet_a( p_nNet_a );
l_oNetworkListDTO.setNet_b( p_nNet_b );
l_oNetworkListDTO.setNet_c( p_nNet_c );
l_oNetworkListDTO.setNet_d( p_nNet_d );
l_oNetworkListDTO.setNet_e( p_nNet_e );
l_oNetworkListDTO.setNet_f( p_nNet_f );
l_oNetworkListDTO.setNet_g( p_nNet_g );
l_oNetworkListDTO.setNet_total( l_nNet_total );
// Insert
if (("I").equals(p_sFlag)) {
l_bSuccess = l_oNetworkListDAO.insert( l_oNetworkListDTO );
if (l_bSuccess) {
%>
<%
} else {
%>
<%
}
}
// update
else if (("U").equals(p_sFlag)) {
l_bSuccess = l_oNetworkListDAO.update( l_oNetworkListDTO );
if (l_bSuccess) {
%>
<%
} else {
%>
<%
}
}
// detete
else if (("D").equals(p_sFlag)) {
l_bSuccess = l_oNetworkListDAO.delete( p_sNet_seq );
if (l_bSuccess) {
%>
<%
} else {
%>
<%
}
}
} catch( Exception e ) {
l_oLogger.debug( e.toString() );
} finally {}
%>