YNU_JEUS/app_home/himed/webapps/emr/dialroomweb/js/SMMND02000.js

/*
  
      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;
				}
/************************************************************************************************************************/