%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="com.biz_nis.cmn.CommonMethod" %>
<%@ page import="com.biz_nis.cmn.OrellyUpload" %>
<%@ 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" %>
<%@ page import="java.io.File" %>
<%@ page import="java.io.IOException" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.HashMap" %>
<%@ page import="java.util.Hashtable" %>
<%@ page import="jxl.*" %>
<%!
public ArrayList getFileToArrayList(String FilePath)
{
ArrayList result = new ArrayList();
ArrayList headData = new ArrayList();
try
{
int columnCount = 0;
Workbook workbook = Workbook.getWorkbook(new File(FilePath));
Sheet sheet = workbook.getSheet(0);
for(int j=0; j
<%
Logger l_oLogger = Logger.getLogger( "" );
request.setCharacterEncoding("UTF-8");
String l_sUploadPath = "";
int l_nLimitSize = 0;
int resultCnt = 0;
String accessPath = "";
String accessName = "";
ArrayList rowData = new ArrayList();
boolean l_bSuccess = false;
NetworkListDAO l_oNetworkListDAO = null;
NetworkListDTO l_oNetworkListDTO = null;
try {
l_oNetworkListDAO = new NetworkListDAO();
l_oNetworkListDTO = new NetworkListDTO();
l_sUploadPath = CommonMethod.getMessage("globals_config","EXCEL_LOG_UPLOAD_DIR");
l_nLimitSize = Integer.parseInt(CommonMethod.getMessage("globals_config","EXCEL_LOG_FILE_SIZE")) * 1024 * 1024 ;
String l_sSavePath = l_sUploadPath+"/";
File ori_realpath_dir = new File(l_sSavePath);
if(!ori_realpath_dir.exists()) ori_realpath_dir.mkdirs();
//MultipartRequest request 받음
OrellyUpload multi = new OrellyUpload(request, l_sSavePath, l_nLimitSize, "UTF-8");
String state = CommonMethod.nullChk( multi.getParameter("STATE") );
String titleExist = CommonMethod.nullChk( multi.getParameter("TITLE_EXIST") );
boolean fileTypeResult = multi.limitExtension();
if(!fileTypeResult){
ArrayList fileHashList = multi.upLoadFile();
int fileHashListCount = fileHashList.size();
for(int i=0; i 0) {
int j = 0;
cInfo.put("net_idstry" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_dstic" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_entp_id" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_mbr_id" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_user_nm" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_jobcl" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_a" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_age" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_tel01" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_tel02" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_tel03" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_relshp" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_b" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_c" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_d" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_e" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_f" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_g" ,CommonMethod.nullChk((String)vInfo.get(j++)));
int p_nNet_entp_id = CommonMethod.intNullChk( cInfo.get("net_entp_id") );
int p_nNet_age = CommonMethod.intNullChk( cInfo.get("net_age") );
int p_nNet_a = CommonMethod.intNullChk( cInfo.get("net_a") );
int p_nNet_b = CommonMethod.intNullChk( cInfo.get("net_b") );
int p_nNet_c = CommonMethod.intNullChk( cInfo.get("net_c") );
int p_nNet_d = CommonMethod.intNullChk( cInfo.get("net_d") );
int p_nNet_e = CommonMethod.intNullChk( cInfo.get("net_e") );
int p_nNet_f = CommonMethod.intNullChk( cInfo.get("net_f") );
int p_nNet_g = CommonMethod.intNullChk( cInfo.get("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 );
cInfo.put("net_total" ,CommonMethod.setZeroZero(l_nNet_total));
cInfo.put("net_resn" ,CommonMethod.nullChk((String)vInfo.get(j++)));
cInfo.put("net_rmark" ,CommonMethod.nullChk((String)vInfo.get(j++)));
l_oNetworkListDTO.setNet_mbr_id( (String)cInfo.get("net_mbr_id") );
l_oNetworkListDTO.setNet_idstry( (String)cInfo.get("net_idstry") );
l_oNetworkListDTO.setNet_dstic( (String)cInfo.get("net_dstic") );
l_oNetworkListDTO.setNet_entp_id( p_nNet_entp_id );
l_oNetworkListDTO.setNet_user_nm( (String)cInfo.get("net_user_nm") );
l_oNetworkListDTO.setNet_jobcl( (String)cInfo.get("net_jobcl") );
l_oNetworkListDTO.setNet_age( p_nNet_age );
if (!cInfo.get("net_tel01").equals("") && !cInfo.get("net_tel02").equals("") && !cInfo.get("net_tel03").equals("")) {
l_oNetworkListDTO.setNet_tel01( (String)cInfo.get("net_tel01") );
l_oNetworkListDTO.setNet_tel02( (String)cInfo.get("net_tel02") );
l_oNetworkListDTO.setNet_tel03( (String)cInfo.get("net_tel03") );
} else {
l_oNetworkListDTO.setNet_tel01( "" );
l_oNetworkListDTO.setNet_tel02( "" );
l_oNetworkListDTO.setNet_tel03( "" );
}
l_oNetworkListDTO.setNet_relshp( (String)cInfo.get("net_relshp") );
l_oNetworkListDTO.setNet_resn( (String)cInfo.get("net_resn") );
l_oNetworkListDTO.setNet_rmark( (String)cInfo.get("net_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_g );
l_oNetworkListDTO.setNet_g( p_nNet_g );
l_oNetworkListDTO.setNet_total( l_nNet_total );
if(cInfo != null) { //입력부분
l_bSuccess = l_oNetworkListDAO.excelInsert( l_oNetworkListDTO );
}
}
cInfo = null;
} //End of For-clause
if (l_bSuccess) {
%>
<%
} else {
%>
<%
}
} catch( Exception e ) {
l_oLogger.error( "### Error : " + e.toString() );
} finally {}
%>