private void SheetFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _sdMAIN = new SpreadsheetControl(); _sdMAIN.Options.Behavior.ShowPopupMenu = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled; string strFTP_PATH = ""; string strUSE_TYPE = ""; string strFILE_NAME = ""; _pucWorkOrderInfoPopup_T50Entity.WINDOW_NAME = this.Name.ToString(); _pucWorkOrderInfoPopup_T50Entity.CRUD = "R"; //조회할거 프로시져 _dtList = new ucWorkOrderInfoPopup_T50Business().Sheet_Info_Sheet(_pucWorkOrderInfoPopup_T50Entity); //엑셀 시트 조회하기 //엑셀서식관리 되면 다시 설정하기 strUSE_TYPE = _dtList.Rows[0]["USE_TYPE"].ToString(); strFILE_NAME = _dtList.Rows[0]["FILE_NAME"].ToString(); switch (strUSE_TYPE) { case "PRINT": strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pFTP_PATH, "ORDER_FORM", _pWINDOW_NAME); break; case "VIEW": strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_PATH, "USER", "PROGRAM_VIEW", _pWINDOW_NAME); break; case "REGIT": strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_PATH, "USER", "PROGRAM_VIEW", _pWINDOW_NAME); break; } string curfile = Application.StartupPath + "\\Template\\" + strFILE_NAME; // 같은 것이 있으면, 폴더에서 해당 파일명을 불러와서 SpreadSheet에 띄우기 / 없으면, 폴더에 다운 if (!File.Exists(curfile)) { CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW, curfile, false); } //using (FileStream file = File.OpenWrite(curfile)) using (Stream file = File.Open(curfile, FileMode.Open)) { if (file != null) { _sdMAIN.LoadDocument(file, DocumentFormat.Xlsx); } else { _sdMAIN.CloseCellEditor(CellEditorEnterValueMode.Default); _sdMAIN.CreateNewDocument(); } } } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager)); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }