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);
}
}