123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474 |
- /*
-
- HD 업무현황 (SMMND02000.xrw - JScript )
- - Version :
- 1) : Ver.1.00.01
- */
- //**전역변수**//
-
- /**
- * @group :
- * @ver : 2007.07.11
- * @by : 김진아
- * @---------------------------------------------------
- * @type : function
- * @access : public
- * @desc : 화면 초기화
- * @param :
- * @return :
- * @---------------------------------------------------
- */
- function fDone(){
-
- var currentDate = getCurrentDate(); // 현재일자
- var sCurrentDate = new Date();
-
- model.setValue("/root/main/condition/srchtodd" , currentDate); // 현재일자
- model.setValue("/root/main/condition/srchfromdd", (sCurrentDate.getAddDate(-1, "M")).getDateFormat()); // 한 달 이전 일자
- model.refresh();
- fSrchBizPresCond(); // 업무현황 조회
- }
-
- /**
- * @group :
- * @ver : 2007.08.13
- * @by : 김진아
- * @---------------------------------------------------
- * @type : function
- * @access : public
- * @desc : 업무현황 조회
- * @param :
- * @return :
- * @---------------------------------------------------
- */
- function fSrchBizPresCond(){
- var TmpPath = "/root/tmp/tmpbizprescondlist/tmpbizprescondinfo"; // (Tmp)
-
- var bizPresCondPath = "/root/main/bizprescondstatslist/bizprescondstatsinfo"; // 업무현황통계
-
- var patPresCondHDPath = "/root/main/patprescondstatslist/patprescondstatsinfo[1]"; // 환자현황통계 (HD)
- var patPresCondPDPath = "/root/main/patprescondstatslist/patprescondstatsinfo[2]"; // 환자현황통계 (PD)
- var patPresCondSumPath = "/root/main/patprescondstatslist/patprescondstatsinfo[3]"; // 환자현황통계 (Total)
-
- var HDStatsPath = "/root/main/hdstatslist/hdstatsinfo"; // 혈액투석 현황통계
- var PDStatsPath = "/root/main/pdstatslist/pdstatsinfo"; // 복막투석 현황통계
- var PDBizStatsPath = "/root/main/pdbizstatslist/pdbizstatsinfo"; // 복막투석업무 현황통계
-
- model.removenode ("/root/send");
- model.makeNode ("/root/send");
- model.makeValue ("/root/send/reqdata/srchfromdd", model.getValue("/root/main/condition/srchfromdd"));
- model.makeValue ("/root/send/reqdata/srchtodd" , model.getValue("/root/main/condition/srchtodd") );
- model.removeNodeset("/root/tmp/tmpbizprescondlist");
- submit("TRMND02001");
-
- //** 조회된 값 설정 **//
-
- //* 업무 현황통계 *//
- // 입원
- model.setValue(bizPresCondPath + "[1]/hdbizprescnt" , model.getValue(TmpPath + "/hdinbizprescnt"));
- model.setValue(bizPresCondPath + "[1]/pdbizprescnt" , model.getValue(TmpPath + "/pdinbizprescnt"));
- model.setValue(bizPresCondPath + "[1]/hpbizprescnt" , model.getValue(TmpPath + "/hpinbizprescnt"));
- model.setValue(bizPresCondPath + "[1]/hdfbizprescnt" , model.getValue(TmpPath + "/hdfinbizprescnt"));
- //2011.07.28 by kya SLED 항목추가
- model.setValue(bizPresCondPath + "[1]/sledbizprescnt" , model.getValue(TmpPath + "/sledinbizprescnt"));
- //2012.02.13 by kya CRRT 항목추가
- model.setValue(bizPresCondPath + "[1]/crrtbizprescnt" , model.getValue(TmpPath + "/crrtinbizprescnt"));
- model.setValue(bizPresCondPath + "[1]/totalbizprescnt", model.getValue(TmpPath + "/totalinbizprescnt"));
-
- // 중환자실
- model.setValue(bizPresCondPath + "[2]/hdbizprescnt" , model.getValue(TmpPath + "/hdicubizprescnt"));
- model.setValue(bizPresCondPath + "[2]/pdbizprescnt" , model.getValue(TmpPath + "/pdicubizprescnt"));
- model.setValue(bizPresCondPath + "[2]/hpbizprescnt" , model.getValue(TmpPath + "/hpicubizprescnt"));
- model.setValue(bizPresCondPath + "[2]/hdfbizprescnt" , model.getValue(TmpPath + "/hdficubizprescnt"));
- //2011.07.28 by kya SLED 항목추가
- model.setValue(bizPresCondPath + "[2]/sledbizprescnt" , model.getValue(TmpPath + "/sledicubizprescnt"));
- //2012.02.13 by kya CRRT 항목추가
- model.setValue(bizPresCondPath + "[2]/crrtbizprescnt" , model.getValue(TmpPath + "/crrticubizprescnt"));
- model.setValue(bizPresCondPath + "[2]/totalbizprescnt", model.getValue(TmpPath + "/totalicubizprescnt"));
-
- // 외래
- model.setValue(bizPresCondPath + "[3]/hdbizprescnt" , model.getValue(TmpPath + "/hdoutbizprescnt"));
- model.setValue(bizPresCondPath + "[3]/pdbizprescnt" , model.getValue(TmpPath + "/pdoutbizprescnt"));
- model.setValue(bizPresCondPath + "[3]/hpbizprescnt" , model.getValue(TmpPath + "/hpoutbizprescnt"));
- model.setValue(bizPresCondPath + "[3]/hdfbizprescnt" , model.getValue(TmpPath + "/hdfoutbizprescnt"));
- //2011.07.28 by kya SLED 항목추가
- model.setValue(bizPresCondPath + "[3]/sledbizprescnt" , model.getValue(TmpPath + "/sledoutbizprescnt"));
- //2012.02.13 by kya CRRT 항목추가
- model.setValue(bizPresCondPath + "[3]/crrtbizprescnt" , model.getValue(TmpPath + "/crrtoutbizprescnt"));
- model.setValue(bizPresCondPath + "[3]/totalbizprescnt", model.getValue(TmpPath + "/totaloutbizprescnt"));
-
- // 응급실
- model.setValue(bizPresCondPath + "[4]/hdbizprescnt" , model.getValue(TmpPath + "/hderbizprescnt"));
- model.setValue(bizPresCondPath + "[4]/pdbizprescnt" , model.getValue(TmpPath + "/pderbizprescnt"));
- model.setValue(bizPresCondPath + "[4]/hpbizprescnt" , model.getValue(TmpPath + "/hperbizprescnt"));
- model.setValue(bizPresCondPath + "[4]/hdfbizprescnt" , model.getValue(TmpPath + "/hdferbizprescnt"));
- //2011.07.28 by kya SLED 항목추가
- model.setValue(bizPresCondPath + "[4]/sledbizprescnt" , model.getValue(TmpPath + "/slederbizprescnt"));
- //2012.02.13 by kya CRRT 항목추가
- model.setValue(bizPresCondPath + "[4]/crrtbizprescnt" , model.getValue(TmpPath + "/crrterbizprescnt"));
- model.setValue(bizPresCondPath + "[4]/totalbizprescnt", model.getValue(TmpPath + "/totalerbizprescnt"));
-
- // Total
- model.setValue(bizPresCondPath + "[5]/hdbizprescnt" , parseInt(model.getValue(TmpPath + "/hdinbizprescnt" ))
- + parseInt(model.getValue(TmpPath + "/hdicubizprescnt"))
- + parseInt(model.getValue(TmpPath + "/hdoutbizprescnt"))
- + parseInt(model.getValue(TmpPath + "/hderbizprescnt" )));
- model.setValue(bizPresCondPath + "[5]/pdbizprescnt" , parseInt(model.getValue(TmpPath + "/pdinbizprescnt" ))
- + parseInt(model.getValue(TmpPath + "/pdicubizprescnt"))
- + parseInt(model.getValue(TmpPath + "/pdoutbizprescnt"))
- + parseInt(model.getValue(TmpPath + "/pderbizprescnt" )));
- model.setValue(bizPresCondPath + "[5]/hpbizprescnt" , parseInt(model.getValue(TmpPath + "/hpinbizprescnt" ))
- + parseInt(model.getValue(TmpPath + "/hpicubizprescnt"))
- + parseInt(model.getValue(TmpPath + "/hpoutbizprescnt"))
- + parseInt(model.getValue(TmpPath + "/hperbizprescnt" )));
- model.setValue(bizPresCondPath + "[5]/hdfbizprescnt" , parseInt(model.getValue(TmpPath + "/hdfinbizprescnt" ))
- + parseInt(model.getValue(TmpPath + "/hdficubizprescnt"))
- + parseInt(model.getValue(TmpPath + "/hdfoutbizprescnt"))
- + parseInt(model.getValue(TmpPath + "/hdferbizprescnt" )));
- //추가 2011.07.28 by kya
- model.setValue(bizPresCondPath + "[5]/sledbizprescnt" , parseInt(model.getValue(TmpPath + "/sledinbizprescnt" ))
- + parseInt(model.getValue(TmpPath + "/sledicubizprescnt"))
- + parseInt(model.getValue(TmpPath + "/sledoutbizprescnt"))
- + parseInt(model.getValue(TmpPath + "/slederbizprescnt" )));
- //추가 2012.02.13 by kya
- model.setValue(bizPresCondPath + "[5]/crrtbizprescnt" , parseInt(model.getValue(TmpPath + "/crrtinbizprescnt" ))
- + parseInt(model.getValue(TmpPath + "/crrticubizprescnt"))
- + parseInt(model.getValue(TmpPath + "/crrtoutbizprescnt"))
- + parseInt(model.getValue(TmpPath + "/crrterbizprescnt" )));
- model.setValue(bizPresCondPath + "[5]/totalbizprescnt", parseInt(model.getValue(TmpPath + "/totalinbizprescnt" ))
- + parseInt(model.getValue(TmpPath + "/totalicubizprescnt"))
- + parseInt(model.getValue(TmpPath + "/totaloutbizprescnt"))
- + parseInt(model.getValue(TmpPath + "/totalerbizprescnt" )));
-
- //* 환자현황통계 *//
- // 신환 수
- model.setValue(patPresCondHDPath + "/fnexamcnt", model.getValue(TmpPath + "/hdfnexamcnt"));
- model.setValue(patPresCondPDPath + "/fnexamcnt", model.getValue(TmpPath + "/pdfnexamcnt"));
- model.setValue(patPresCondSumPath + "/fnexamcnt", model.getValue(TmpPath + "/totalfnexamcnt"));
-
- // 상담건수
- model.setValue(patPresCondHDPath + "/cnstcnt", model.getValue(TmpPath + "/hdcnstcnt"));
- model.setValue(patPresCondPDPath + "/cnstcnt", model.getValue(TmpPath + "/pdcnstcnt"));
- model.setValue(patPresCondSumPath + "/cnstcnt", model.getValue(TmpPath + "/totalcnstcnt"));
- // 처방교육건수
- model.setValue(patPresCondHDPath + "/prcpeduccnt", model.getValue(TmpPath + "/hdprcpeduccnt"));
- model.setValue(patPresCondPDPath + "/prcpeduccnt", model.getValue(TmpPath + "/pdprcpeduccnt"));
- model.setValue(patPresCondSumPath + "/prcpeduccnt", model.getValue(TmpPath + "/totalprcpeduccnt"));
-
- // 기록교육건수
- model.setValue(patPresCondHDPath + "/receduccnt", model.getValue(TmpPath + "/hdreceduccnt"));
- model.setValue(patPresCondPDPath + "/receduccnt", model.getValue(TmpPath + "/pdreceduccnt"));
- model.setValue(patPresCondSumPath + "/receduccnt", model.getValue(TmpPath + "/totalreceduccnt"));
-
- // 원인별 ARF건수
- model.setValue(patPresCondHDPath + "/causecnt1", model.getValue(TmpPath + "/hdcausecnt1"));
- model.setValue(patPresCondPDPath + "/causecnt1", model.getValue(TmpPath + "/pdcausecnt1"));
- model.setValue(patPresCondSumPath + "/causecnt1", model.getValue(TmpPath + "/totalcausecnt1"));
- // 원인별 CRF건수
- model.setValue(patPresCondHDPath + "/causecnt2", model.getValue(TmpPath + "/hdcausecnt2"));
- model.setValue(patPresCondPDPath + "/causecnt2", model.getValue(TmpPath + "/pdcausecnt2"));
- model.setValue(patPresCondSumPath + "/causecnt2", model.getValue(TmpPath + "/totalcausecnt2"));
- // 보험
- model.setValue(patPresCondHDPath + "/healinsucnt", model.getValue(TmpPath + "/hdhealinsucnt"));
- model.setValue(patPresCondPDPath + "/healinsucnt", model.getValue(TmpPath + "/pdhealinsucnt"));
- model.setValue(patPresCondSumPath + "/healinsucnt", model.getValue(TmpPath + "/totalhealinsucnt"));
-
- // 보호 1종
- model.setValue(patPresCondHDPath + "/proc1kindinsucnt", model.getValue(TmpPath + "/hdproc1kindinsucnt"));
- model.setValue(patPresCondPDPath + "/proc1kindinsucnt", model.getValue(TmpPath + "/pdproc1kindinsucnt"));
- model.setValue(patPresCondSumPath + "/proc1kindinsucnt", model.getValue(TmpPath + "/totalproc1kindinsucnt"));
-
- // 보호 2종
- model.setValue(patPresCondHDPath + "/proc2kindinsucnt", model.getValue(TmpPath + "/hdproc2kindinsucnt"));
- model.setValue(patPresCondPDPath + "/proc2kindinsucnt", model.getValue(TmpPath + "/pdproc2kindinsucnt"));
- model.setValue(patPresCondSumPath + "/proc2kindinsucnt", model.getValue(TmpPath + "/totalproc2kindinsucnt"));
- // 산재
- model.setValue(patPresCondHDPath + "/inducsinsucnt", model.getValue(TmpPath + "/hdinducsinsucnt"));
- model.setValue(patPresCondPDPath + "/inducsinsucnt", model.getValue(TmpPath + "/pdinducsinsucnt"));
- model.setValue(patPresCondSumPath + "/inducsinsucnt", model.getValue(TmpPath + "/totalinducsinsucnt"));
- // 기타
- model.setValue(patPresCondHDPath + "/etcinsucnt", model.getValue(TmpPath + "/hdetcinsucnt"));
- model.setValue(patPresCondPDPath + "/etcinsucnt", model.getValue(TmpPath + "/pdetcinsucnt"));
- model.setValue(patPresCondSumPath + "/etcinsucnt", model.getValue(TmpPath + "/totaletcinsucnt"));
-
- // 전원
- model.setValue(patPresCondHDPath + "/chnghospcnt", model.getValue(TmpPath + "/hdchnghospcnt"));
- model.setValue(patPresCondPDPath + "/chnghospcnt", model.getValue(TmpPath + "/pdchnghospcnt"));
- model.setValue(patPresCondSumPath + "/chnghospcnt", model.getValue(TmpPath + "/totalchnghospcnt"));
-
- // 사망
- model.setValue(patPresCondHDPath + "/dethcnt", model.getValue(TmpPath + "/hddethcnt"));
- model.setValue(patPresCondPDPath + "/dethcnt", model.getValue(TmpPath + "/pddethcnt"));
- model.setValue(patPresCondSumPath + "/dethcnt", model.getValue(TmpPath + "/totaldethcnt"));
- // 신장이식
- model.setValue(patPresCondHDPath + "/bdhttrnptcnt", model.getValue(TmpPath + "/hdbdhttrnptcnt"));
- model.setValue(patPresCondPDPath + "/bdhttrnptcnt", model.getValue(TmpPath + "/pdbdhttrnptcnt"));
- model.setValue(patPresCondSumPath + "/bdhttrnptcnt", model.getValue(TmpPath + "/totalbdhttrnptcnt"));
-
- // 전환
- model.setValue(patPresCondHDPath + "/cvrtcnt", model.getValue(TmpPath + "/hdcvrtcnt"));
- model.setValue(patPresCondPDPath + "/cvrtcnt", model.getValue(TmpPath + "/pdcvrtcnt"));
- model.setValue(patPresCondSumPath + "/cvrtcnt", model.getValue(TmpPath + "/totalcvrtcnt"));
- //* 종류별 현황통계 *//
- // 혈액투석
- model.setValue(HDStatsPath + "[1]/patcnt", model.getValue(TmpPath + "/hdavfcount" ));
- model.setValue(HDStatsPath + "[2]/patcnt", model.getValue(TmpPath + "/hdavgcount" ));
- model.setValue(HDStatsPath + "[3]/patcnt", model.getValue(TmpPath + "/hdpermccount" ));
- model.setValue(HDStatsPath + "[4]/patcnt", model.getValue(TmpPath + "/hdjvccount" ));
- model.setValue(HDStatsPath + "[5]/patcnt", model.getValue(TmpPath + "/hdfvccount" ));
- model.setValue(HDStatsPath + "[6]/patcnt", model.getValue(TmpPath + "/hdsvccount" ));
- model.setValue(HDStatsPath + "[7]/patcnt", model.getValue(TmpPath + "/hdetccount" ));
- model.setValue(HDStatsPath + "[8]/patcnt", parseInt(model.getValue(TmpPath + "/hdavfcount" ))
- + parseInt(model.getValue(TmpPath + "/hdavgcount" ))
- + parseInt(model.getValue(TmpPath + "/hdpermccount"))
- + parseInt(model.getValue(TmpPath + "/hdjvccount" ))
- + parseInt(model.getValue(TmpPath + "/hdfvccount" ))
- + parseInt(model.getValue(TmpPath + "/hdsvccount" ))
- + parseInt(model.getValue(TmpPath + "/hdetccount" )));
-
- // 복막투석
- model.setValue(PDStatsPath + "[1]/patcnt", model.getValue(TmpPath + "/pdcapdcount" ));
- model.setValue(PDStatsPath + "[2]/patcnt", model.getValue(TmpPath + "/pdapdcount" ));
- model.setValue(PDStatsPath + "[3]/patcnt", model.getValue(TmpPath + "/pdipdcount" ));
- model.setValue(PDStatsPath + "[4]/patcnt", model.getValue(TmpPath + "/pdnpdcount" ));
- model.setValue(PDStatsPath + "[5]/patcnt", model.getValue(TmpPath + "/pdccpdcount" ));
- model.setValue(PDStatsPath + "[6]/patcnt", parseInt(model.getValue(TmpPath + "/pdcapdcount"))
- + parseInt(model.getValue(TmpPath + "/pdapdcount "))
- + parseInt(model.getValue(TmpPath + "/pdipdcount "))
- + parseInt(model.getValue(TmpPath + "/pdnpdcount "))
- + parseInt(model.getValue(TmpPath + "/pdccpdcount")));
-
- // 복막투석업무
- model.setValue(PDBizStatsPath + "[1]/cnt", model.getValue(TmpPath + "/catefixcount" ));
- model.setValue(PDBizStatsPath + "[2]/cnt", model.getValue(TmpPath + "/dinfcount" ));
- model.setValue(PDBizStatsPath + "[3]/cnt", model.getValue(TmpPath + "/pipecount" ));
- model.setValue(PDBizStatsPath + "[4]/cnt", model.getValue(TmpPath + "/edemacnfmcount" ));
- model.setValue(PDBizStatsPath + "[5]/cnt", model.getValue(TmpPath + "/tsetexchcount" ));
- model.setValue(PDBizStatsPath + "[6]/cnt", model.getValue(TmpPath + "/dialblodcount" ));
- model.setValue(PDBizStatsPath + "[7]/cnt", parseInt(model.getValue(TmpPath + "/catefixcount" ))
- + parseInt(model.getValue(TmpPath + "/dinfcount" ))
- + parseInt(model.getValue(TmpPath + "/pipecount" ))
- + parseInt(model.getValue(TmpPath + "/edemacnfmcount"))
- + parseInt(model.getValue(TmpPath + "/tsetexchcount" ))
- + parseInt(model.getValue(TmpPath + "/dialblodcount" )));
- }
- /************************************************************************************************************************/
- /**
- * @group :
- * @ver :
- * @by : 김기용
- * @---------------------------------------------------
- * @type : function
- * @access : public
- * @desc : 그리드 별 엑셀저장
- * @param :
- * @return :
- * @---------------------------------------------------
- */
- function saveExcelAll() {
-
- var paramLen = saveExcelAll.arguments.length;
-
- // 마지막 인자가 Boolean일 경우 처리
- var extendsCaptionBool;
- if( typeof(saveExcelAll.arguments[paramLen - 1]) == "boolean" ) {
- extendsCaptionBool = saveExcelAll.arguments[paramLen - 1];
- paramLen = paramLen - 1;
- }
- else{
- extendsCaptionBool = false;
- }
-
- var tmpParamArray = new Array();
- if( extendsCaptionBool ) {
- for( var i = 0; i < paramLen; i++ ) {
- tmpParamArray[i] = saveExcelAll.arguments[i];
- }
- saveExcelAllWithCaption(tmpParamArray);
- }
- else{
- for( var i = 0; i < paramLen; i++ ) {
- tmpParamArray[i] = saveExcelAll.arguments[i];
- }
- saveExcelAllWithNotCaption(tmpParamArray);
- }
- }
-
- function saveExcelAllWithCaption( sheetArray ) {
-
- // alert(gridCaptionArray);
-
- var fileName = window.fileDialog("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
-
- if( fileName == "" )
- return;
-
- // var sheetArray = new Array("grd_bizprescondstats|업무현황", "grd_patprescondstats|환자현황", "grd_hdstatsinfo|혈액투석현황", "grd_pdstatsinfo|복막투석현황", "grd_pdbizstatsinfo|복막투석업무현황");
- var sheetArrayLen = sheetArray.length;
-
- var gridId;
- var gridObj;
- for( var i = 0; i < sheetArray.length; i++ ) {
-
- gridId = sheetArray[i].split("|")[0];
- gridObj = document.all.item(gridId);
- // saveText() 함수는 Caption저장이 불가능 하여 SaveExcel()을 이용한다.
- gridObj.saveExcel("C:\\Temp\\tmp_TFExcel_" + i +".xls");
- }
-
- // excel application 실행함
- tfexcel.launchnewinstance(0);
-
- //실행된 excel application에서 새로운 workbook을 생성
- tfexcel.createworkbook();
-
- /* 문제있는 로직 주석처리 2013.06.13 손병은
-
- tfexcel.activatesheet(1);
-
-
- var sheetName;
- var nResult;
- for( var i = 0; i < sheetArrayLen; i++ )
- {
- sheetName = sheetArray[i].split("|")[1];
-
- if( i > 1 ) {
- nResult = tfexcel.activatesheet(i+1);
- tfexcel.sheetname(i+1) = sheetName;
- }
- else {
- nResult = tfexcel.addsheet(i+1, sheetName);
- }
- if( nResult < 0 ) {
- messageBox(sheetName + " 저장을", "E009");
- // alert(sheetName + " 오류발생");
- return;
- }
- tfexcel.loadCSV("C:\\Temp\\tmp_TFExcel_" + i + ".xls");
- }
-
- */
-
- var sheetName;
- var nResult;
- for( var i = 0; i < sheetArrayLen; i++ )
- {
- sheetName = sheetArray[i].split("|")[1];
-
- if( i > 0 ) {
- nResult = tfexcel.addsheet(i+1, sheetName);
- }else{
-
- nResult = tfexcel.activatesheet(i+1);
- }
- tfexcel.sheetname(i+1) = sheetName;
-
- if( nResult < 0 ) {
- messageBox(sheetName + " 저장을", "E009");
- // alert(sheetName + " 오류발생");
- return;
- }
- tfexcel.loadCSV("C:\\Temp\\tmp_TFExcel_" + i + ".xls");
- }
-
- //workbook을 저장.
- tfexcel.save(fileName);
-
- //excel application을 종료. excel application 생성 후 반드시 close해야함.
- tfexcel.close();
-
- var fso = new ActiveXObject("Scripting.FileSystemObject");
- for( var i = 0; i < sheetArrayLen; i++ ) {
- fso.DeleteFile("C:\\Temp\\tmp_TFExcel_" + i + ".xls");
- }
-
- var rmsg = messageBox("저장된 Excel을", "Q004");
- // var rmsg = window.alert("저장된 Excel을 실행하시겠습니까?", "알림", 36);
- if( rmsg == 6 )
- window.exec("excel.exe", '\"' + fileName + '\"');
- }
-
- function saveExcelAllWithNotCaption( sheetArray ) {
-
- // alert(gridCaptionArray);
-
- var fileName = window.fileDialog("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
-
- if( fileName == "" )
- return;
- // excel application 실행함
- tfexcel.launchnewinstance(0);
-
- // 실행된 excel application에서 새로운 workbook을 생성
- tfexcel.createworkbook();
-
- // var sheetArray = new Array("grd_bizprescondstats|업무현황", "grd_patprescondstats|환자현황", "grd_hdstatsinfo|혈액투석현황", "grd_pdstatsinfo|복막투석현황", "grd_pdbizstatsinfo|복막투석업무현황");
- var sheetArrayLen = sheetArray.length;
- var gridId;
- var gridObj;
- var sheetName;
- var nResult;
-
- for( var i = 0; i < sheetArrayLen; i++ ) {
-
- gridId = sheetArray[i].split("|")[0];
- gridObj = document.all.item(gridId);
- sheetName = sheetArray[i].split("|")[1];
-
- if( i > 1 ) {
- nResult = tfexcel.activatesheet(i+1);
- tfexcel.sheetname(i+1) = sheetName;
- }
- else {
- nResult = tfexcel.addsheet(i+1, sheetName);
- }
- if( nResult < 0 ) {
- messageBox(sheetName + " 저장을", "E009");
- // alert(sheetName + " 오류발생");
- return;
- }
- gridObj.saveText("C:\\Temp\\tmp_TFExcel.csv", "\n", ",", '\:', true);
- tfexcel.loadCSV("C:\\Temp\\tmp_TFExcel.csv");
- }
-
- //workbook을 저장.
- tfexcel.save(fileName);
-
- //excel application을 종료. excel application 생성 후 반드시 close해야함.
- tfexcel.close();
-
- // CSV File 삭제
- var fso = new ActiveXObject("Scripting.FileSystemObject");
- fso.DeleteFile("C:\\Temp\\tmp_TFExcel.csv");
-
- var rmsg = messageBox("저장된 Excel을", "Q004");
- // var rmsg = window.alert("저장된 Excel을 실행하시겠습니까?", "알림", 36);
- if( rmsg == 6 )
- window.exec("excel.exe", '\"' + fileName + '\"');
- }
- function createTFExcel(tfExcelID, parentObj) {
- if( parentObj == null )
- parentObj = body;
- var tfExcelObj = parentObj.createChild("xforms:object", "id:" + tfExcelID + "; clsid:{fe8d1001-6a9d-424d-ae2a-301493bb12da}; left:100px; top:100px; width:100px; height:100px; ");
- return tfExcelObj;
- }
- /************************************************************************************************************************/
|