YNU_JEUS/app_home/himed/webapps/ast/bodyresurbasebankweb/js/SMAEI00100.js

/*
  
      인체자원은행 엑셀저장 (SMAEI00100.xrw - JScript )

      - Version :
          1)  : Ver.1.00.01
 */


/************************************************************************************************************************/
/**
 * @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();
		                      
					tfexcel.activatesheet(1);
		                      
					var sheetName;
					var nResult;
					for( var i = 0; i  < sheetArrayLen; i++ ) 
		                      {
		                      		sheetName = sheetArray[i].split("|")[1];		                      		
						nResult = tfexcel.addsheet(i+1, sheetName);	
						
						if( nResult < 0 ) {
								messageBox(sheetName + " 저장을", "E009");
								// alert(sheetName + " 오류발생");
								return;
						}
						 tfexcel.loadCSV("C:\\Temp\\tmp_TFExcel_" + i + ".xls");
		                      }
		                      
		                      tfexcel.loadCSV("C:\\Temp\\tmp_TFExcel.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;
				}
/************************************************************************************************************************/