private void CoFAS_DevExpressManager__OnButtonPressed(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
DataRow dr = null;
string strFTP_PATH = "";
string tempFolderPath = "";
switch (e.Button.Caption.ToString())
{
case "TOOL_DOCUMENT_VIEW_MAIN_BTN":
dr = _gdMAIN_VIEW.GetFocusedDataRow();
if (dr == null) return;
strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pFTP_PATH, "FILE_DATA", dr["DOCUMENT_TYPE"].ToString());
tempFolderPath = System.IO.Path.GetTempPath() + dr["DOCUMENT_FILE_NAME"].ToString();
CoFAS_FTPManager.FTPFileView(strFTP_PATH, dr["DOCUMENT_FILE_NAME"].ToString(), _pFTP_ID, _pFTP_PW, tempFolderPath);
break;
case "TOOL_DOCUMENT_VIEW_SUB_BTN":
dr = _gdSUB_VIEW.GetFocusedDataRow();
if (dr == null) return;
strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pFTP_PATH, "FILE_DATA", dr["DOCUMENT_TYPE"].ToString());
tempFolderPath = System.IO.Path.GetTempPath() + dr["DOCUMENT_FILE_NAME"].ToString();
CoFAS_FTPManager.FTPFileView(strFTP_PATH, dr["DOCUMENT_FILE_NAME"].ToString(), _pFTP_ID, _pFTP_PW, tempFolderPath);
break;
}
}
//도면
private void labelControl1_Click(object sender, EventArgs e)
{
if (_dtList != null)
{
_dtList.Rows.Clear();
}
_pPOPWorkResult_T50Entity = new POPWorkResult_T50Entity();
_pPOPWorkResult_T50Entity.PART_CODE = _part_code;
DataTable dt = MS_DBClass.USP_POP_FILE(_part_code);
MemoryStream _ms = new MemoryStream();
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0][5] != null)
{
_ms = new MemoryStream((byte[])dt.Rows[0][5]);
_pdfViewer.LoadDocument(_ms);
}
else
{
//No Image
string strFTP_PATH = string.Format(@"{0}{1}/%2F/{2}/{3}/", _pFTP_PATH, "ITEM", "ITEM_IMAGE", "ProductInformationRegister");
var stream = CoFAS_FTPManager.FTPImage(strFTP_PATH, "Noimage.pdf", _pFTP_ID, _pFTP_PW);
_ms = new MemoryStream();
byte[] buffer = new byte[16 * 1024];
int read;
while ((read = stream.Read(buffer, 0, buffer.Length)) > 0)
{
_ms.Write(buffer, 0, read);
}
_pdfViewer.LoadDocument(_ms);
}
}
else
{
//No Image
string strFTP_PATH = string.Format(@"{0}{1}/%2F/{2}/{3}/", _pFTP_PATH, "ITEM", "ITEM_IMAGE", "ProductInformationRegister");
var stream = CoFAS_FTPManager.FTPImage(strFTP_PATH, "Noimage.pdf", _pFTP_ID, _pFTP_PW);
_ms = new MemoryStream();
byte[] buffer = new byte[16 * 1024];
int read;
while ((read = stream.Read(buffer, 0, buffer.Length)) > 0)
{
_ms.Write(buffer, 0, read);
}
_pdfViewer.LoadDocument(_ms);
}
//getImage(Image_nm);
}
private void File_Delete()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
_pMenuInfoRegisterEntity.CRUD = "U";
_pMenuInfoRegisterEntity.MENU_CODE = _gdSUB_VIEW.GetFocusedRowCellValue("MENU_CODE").ToString();
_pMenuInfoRegisterEntity.TEMPLETE_SEQ = _gdSUB_VIEW.GetFocusedRowCellValue("TEMPLETE_SEQ").ToString();
_pMenuInfoRegisterEntity.TEMPLETE_NAME = _gdSUB_VIEW.GetFocusedRowCellValue("TEMPLETE_NAME").ToString();
_pMenuInfoRegisterEntity.TEMPLETE_FILE_NAME = "";
_pMenuInfoRegisterEntity.REMARK = _gdSUB_VIEW.GetFocusedRowCellValue("REMARK").ToString();
_pMenuInfoRegisterEntity.USE_YN = _gdSUB_VIEW.GetFocusedRowCellValue("USE_YN").ToString();
_pMenuInfoRegisterEntity.TEMPLETE_BEFROE_FILE_NAME = _gdSUB_VIEW.GetFocusedRowCellValue("TEMPLETE_BEFROE_FILE_NAME").ToString();
isError = new MenuInfoRegisterBusiness().MenuInfoRegister_Info_Delete(_pMenuInfoRegisterEntity);
string strFTP_PATH = "";
if (isError)
{
//오류 발생.
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_DELETE_ERROR);
}
else
{
//정상 처리
strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pMenuInfoRegisterEntity.FTP_IP_PORT, "PROGRAM_VIEW", _pMenuInfoRegisterEntity.MENU_CODE);
string qFileName = _pMenuInfoRegisterEntity.TEMPLETE_BEFROE_FILE_NAME;
string qPath = strFTP_PATH;
CoFAS_FTPManager.FTPDelete(qFileName, qPath, _pFTP_ID, _pFTP_PW);
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_DELETE);
_pMenuInfoRegisterEntity.CRUD = "R";
_pMenuInfoRegisterEntity.MENU_CODE = _luMENU_CODE.Text.ToString();
SubDetailFind_DisplayData();
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void File_Download()
{
try
{
string strFTP_PATH = "";
if (_pucPartDocumentListPopup_T02Entity.CRUD == "")
{
_dtList.Rows.Clear();
}
if (_gdSUB_VIEW.FocusedValue.ToString() == "")
{
return;
}
//_pucPartDocumentListPopup_T02Entity.FILE_NAME_2 = _gdSUB_VIEW.FocusedValue.ToString();
_pucPartDocumentListPopup_T02Entity.FILE_NAME_2 = _gdSUB_VIEW.GetRowCellValue(_gdSUB_VIEW.FocusedRowHandle, "FILE_NAME_2").ToString();
_pucPartDocumentListPopup_T02Entity.FILE_NAME_1 = _gdSUB_VIEW.GetRowCellValue(_gdSUB_VIEW.FocusedRowHandle, "FILE_NAME_1").ToString();
_pucPartDocumentListPopup_T02Entity.EXTENSION = _gdSUB_VIEW.GetRowCellValue(_gdSUB_VIEW.FocusedRowHandle, "EXTENSION").ToString();
string strFILE_NAME_2 = _gdSUB_VIEW.GetRowCellValue(_gdSUB_VIEW.FocusedRowHandle, "FILE_NAME_2").ToString();
//ftp에서 local로 다운로드
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.InitialDirectory = @"C:\";
saveFile.Filter = "ALL(*.*)|*.*";
saveFile.FileName = _pucPartDocumentListPopup_T02Entity.FILE_NAME_1;
strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pucPartDocumentListPopup_T02Entity.FTP_PATH, "FILE_DATA", _luDOCUMENT_TYPE.GetValue().ToString());
if (saveFile.ShowDialog() == DialogResult.OK)
{
string _pDOWNLOAD_PATH = saveFile.FileName + _pucPartDocumentListPopup_T02Entity.EXTENSION;// _pucPartDocumentListPopup_T02Entity.FILE_NAME_2;// saveFile.FileName;
;
CoFAS_FTPManager.FTPDownLoad2(strFTP_PATH, strFILE_NAME_2, _pFTP_ID, _pFTP_PW, _pDOWNLOAD_PATH, false);
//DisplayMessage("선택한 파일이 지정한 폴더(" + _pFTP_DOWNLOAD_PATH + ")에 저장되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE + "(path:" + _pDOWNLOAD_PATH + ")");
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void getImage(string filename)
{
if (filename == "")
{
string strFTP_PATH = string.Format(@"{0}{1}/%2F/{2}/{3}/", _pFTP_PATH, "ITEM", "ITEM_IMAGE", "ProductInformationRegister");
var stream = CoFAS_FTPManager.FTPImage(strFTP_PATH, "Noimage.pdf", _pFTP_ID, _pFTP_PW);
MemoryStream _ms = new MemoryStream();
byte[] buffer = new byte[16 * 1024];
int read;
while ((read = stream.Read(buffer, 0, buffer.Length)) > 0)
{
_ms.Write(buffer, 0, read);
}
_pdfViewer.LoadDocument(_ms);
}
else
{
//pdf 일경우
if (filename.Contains(".pdf"))
{
if (filename.IndexOf("*NoSave*") > -1 || filename.Trim().Length < 4)
{
CoFAS_DevExpressManager.ShowInformationMessage("저장하지 않아서 볼 수 없습니다.");
}
else
{
string strFTP_PATH = string.Format(@"{0}{1}/%2F/{2}/", _pFTP_PATH, "FILE_DATA", "CD050005");
var stream = CoFAS_FTPManager.FTPImage(strFTP_PATH, filename, _pFTP_ID, _pFTP_PW);
//해당 이미지가 ftp서버에 없을때.
if (stream == null)
{
stream = CoFAS_FTPManager.FTPImage(strFTP_PATH, "Noimage.pdf", _pFTP_ID, _pFTP_PW);
}
MemoryStream _ms = new MemoryStream();
byte[] buffer = new byte[16 * 1024];
int read;
while ((read = stream.Read(buffer, 0, buffer.Length)) > 0)
{
_ms.Write(buffer, 0, read);
}
_pdfViewer.LoadDocument(_ms);
}
}
}
}
private void Dashboard_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strFTP_PATH = "";
strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_IP_PORT, "USER", "PROGRAM_VIEW", _pWINDOW_NAME);
Dashboard dashboard = new Dashboard();
//FTP의 엑셀 파일 control에 바인딩
using (Stream responseStream = CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, _pXMLFile, _pFTP_ID, _pFTP_PW))
{
if (responseStream != null)
{
dashboard.LoadFromXml(responseStream); //xml 파일 로드
}
}
dashboard.ConfigureDataConnection += DashboardViewer_ConfigureDataConnection;
// xml의 parameter 설정
dashboard.Parameters[0].Value = _pLANGUAGE_TYPE;
dashboard.Parameters[1].Value = DateTime.Parse(_luORDER_DATE.FromDateTime.ToString()).ToString("yyyyMMdd");
dashboard.Parameters[2].Value = DateTime.Parse(_luORDER_DATE.ToDateTime.ToString()).ToString("yyyyMMdd");
// Title 설정
dashboard.Title.Visible = false;
dashboardViewer.Dashboard = dashboard;
dashboardViewer.Refresh();
DisplayMessage(_pMSG_SEARCH);
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void File_Download()
{
try
{
string strFTP_PATH = "";
if (_pMenuInfoRegisterEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if (_gdSUB_VIEW.FocusedValue.ToString() == "")
{
return;
}
_pMenuInfoRegisterEntity.TEMPLETE_FILE_NAME = _gdSUB_VIEW.FocusedValue.ToString();
//ftp에서 local로 다운로드
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.InitialDirectory = @"C:\";
saveFile.Filter = "ALL(*.*)|*.*";
saveFile.FileName = _pMenuInfoRegisterEntity.TEMPLETE_FILE_NAME;
strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pMenuInfoRegisterEntity.FTP_IP_PORT, "PROGRAM_VIEW", _luMENU_CODE.Text.ToString());
if (saveFile.ShowDialog() == DialogResult.OK)
{
string _pDOWNLOAD_PATH = saveFile.FileName;
CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, (saveFile.FileName.ToString().Split('\\')).Last(), _pFTP_ID, _pFTP_PW, _pDOWNLOAD_PATH, false);
//DisplayMessage("선택한 파일이 지정한 폴더(" + _pFTP_DOWNLOAD_PATH + ")에 저장되었습니다.");
DisplayMessage(_pMSG_SAVE + "(path:" + _pDOWNLOAD_PATH + ")");
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
// 추가 이벤트 생성
#region ○ 메인 그리드 로우 선택 이벤트 생성 - _gdMAIN_VIEW_RowCellClick(object sender, RowCellClickEventArgs e)
private void _gdMAIN_VIEW_RowCellClick(object sender, RowCellClickEventArgs e)
{
try
{
GridView gv = sender as GridView;
CoFAS_ControlManager.Controls_Binding(gv, false, this);
//FTP에서 파일명에 맞는 엑셀 파일 가져오기
string strFILE_NAME = "";
strFILE_NAME = gv.GetFocusedRowCellValue("FILE_NAME").ToString(); //추가
PASS_PARENT_USE_TYPE = gv.GetFocusedRowCellValue("USE_TYPE").ToString();
switch (PASS_PARENT_USE_TYPE)
{
case "PRINT":
strPARENT_FTP_PATH = string.Format(@"{0}{1}/", PASS_PARENT_FTP_PATH, "ORDER_FORM");
break;
case "VIEW":
strPARENT_FTP_PATH = string.Format(@"{0}{1}/", PASS_PARENT_FTP_PATH, "PROGRAM_VIEW");
break;
}
using (Stream responseStream = CoFAS_FTPManager.FTPFileBinding(strPARENT_FTP_PATH, strFILE_NAME, PASS_PARENT_FTP_ID, PASS_PARENT_FTP_PW))
{
if (responseStream != null)
{
_sdMAIN.LoadDocument(responseStream, enFileFormat.Xlsx);
}
else
{
_sdMAIN.ClearSheet();
}
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
}
private void _btSAVE_SHEET_Click(object sender, EventArgs e) //추가
{
try
{
GridView gv = sender as GridView;
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strFTP_PATH = "";
string strFILE_NAME = "";
if (strFILE_NAME == "")
{
CoFAS_DevExpressManager.ShowInformationMessage("저장할 엑셀 항목이 없습니다.");
}
else
{
switch (gv.GetFocusedRowCellValue("USE_TYPE").ToString())
{
case "PRINT":
strFTP_PATH = string.Format(@"{0}{1}/", strPARENT_FTP_PATH, "ORDER_FORM");
break;
case "VIEW":
strFTP_PATH = string.Format(@"{0}{1}/", strPARENT_FTP_PATH, "PROGRAM_VIEW");
break;
}
byte[] data = _sdMAIN.SaveDocument(enFileFormat.Xlsx); //uc 기능확인 필요
CoFAS_FTPManager.FTPUpload_CheckDFile(strFILE_NAME, strPARENT_FTP_ID, strPARENT_FTP_PW, strFTP_PATH, data);
CoFAS_DevExpressManager.ShowInformationMessage("저장되었습니다.");
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void label1_Paint(object sender, PaintEventArgs e)
{
if (i < 1)
{
i++;
if (CoFAS_DevExpressManager.ShowQuestionMessage("저장하시겠습니까?") == DialogResult.Yes)
{
if (strFILE_NAME != "")
{
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.InitialDirectory = @"C:\";
saveFile.Filter = "Excel.XLSX(*.xlsx) | *.xls | ALL(*.*) | *.*";
saveFile.FileName = strFILE_NAME;
switch (strUSE_TYPE)
{
case "PRINT":
strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pFTP_PATH, "ORDER_FORM", "MaterialOrderRegister_T03");
break;
case "VIEW":
strFTP_PATH = string.Format(@"{0}{1}/", _pFTP_PATH, "PROGRAM_VIEW");
break;
}
if (saveFile.ShowDialog() == DialogResult.OK)
{
_pFTP_DOWNLOAD_PATH = saveFile.FileName;
CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW, _pFTP_DOWNLOAD_PATH);
this.Dispose();
}
}
else
{
MessageBox.Show("선택된 파일이 없습니다!");
}
}
}
}
public void SetExcel()
{
_pProductionResultState_T50Entity.WINDOW_NAME = this.Name;
string strUSE_TYPE = "";
string strFILE_NAME = "";
string strFTP_PATH = "";
_dtList = new ProductionResultState_T50Business().Sheet_Info_Sheet(_pProductionResultState_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;
if (!File.Exists(curfile))
{
CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW, curfile, false);
}
spreadsheetControl1.LoadDocument(curfile);
}
private void Dashboard_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strFTP_PATH = "";
string sfilename = "";
_dtList = new ProductBadMonthStatusBusiness().ProductBadMonthStatus_Info_Filename(_pProductBadMonthStatusEntity); //Entity에 WINDOW_NAME 추가
if (_dtList == null)
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
return;
}
if (_dtList.Rows.Count == 0)
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_NO_SELECT_FILEFORM);
return;
}
for (int i = 0; i < _dtList.Rows.Count; i++)
{
string menu_no = _dtList.Rows[i]["menu_no"].ToString();
string dsp_sort = _dtList.Rows[i]["dsp_sort"].ToString();
string curfile = Application.StartupPath + "\\Template\\" + _dtList.Rows[i][2].ToString();
sfilename = _dtList.Rows[i][2].ToString();
}
strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_IP_PORT, "USER", "PROGRAM_VIEW", _pProductBadMonthStatusEntity.WINDOW_NAME);
//CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, (saveFile.FileName.ToString().Split('\\')).Last(), _pFTP_ID, _pFTP_PW, strLOCAL_PATH);
Dashboard dashboard = new Dashboard();
//FTP의 엑셀 파일 control에 바인딩
using (Stream responseStream = CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, sfilename, _pFTP_ID, _pFTP_PW))
{
if (responseStream != null)
{
dashboard.LoadFromXml(responseStream); //xml 파일 로드
}
}
dashboard.ConfigureDataConnection += DashboardViewer_ConfigureDataConnection;
//dashboard.LoadFromXml(curfile); //xml 파일 로드
// xml의 parameter 설정
dashboard.Parameters[0].Value = _luT_PLAN_DATE.DateTime.ToString("yyyy");//_luT_PLAN_DATE.FromDateTime.ToString().Substring(0, 10).Replace("-", "");
// Title 설정
dashboard.Title.Visible = false;
dashboardViewer.Dashboard = dashboard;
dashboardViewer.Refresh();
//DisplayMessage("조회 되었습니다.");
DisplayMessage(_pMSG_SEARCH);
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
// _gdSUB_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void Dashboard_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strFTP_PATH = "";
string sfilename = "";
_dtList = new MaterialOutStatusBusiness().MaterialOutStatus_Info_Filename(_pMaterialOutStatusEntity); //Entity에 WINDOW_NAME 추가
for (int i = 0; i < _dtList.Rows.Count; i++)
{
string menu_no = _dtList.Rows[i]["menu_no"].ToString();
string dsp_sort = _dtList.Rows[i]["dsp_sort"].ToString();
string curfile = Application.StartupPath + "\\Template\\" + _dtList.Rows[i][2].ToString();
sfilename = _dtList.Rows[i][2].ToString();
}
strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_IP_PORT, "USER", "PROGRAM_VIEW", _pMaterialOutStatusEntity.WINDOW_NAME);
Dashboard dashboard = new Dashboard();
//FTP의 엑셀 파일 control에 바인딩
using (Stream responseStream = CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, sfilename, _pFTP_ID, _pFTP_PW))
{
if (responseStream != null)
{
dashboard.LoadFromXml(responseStream); //xml 파일 로드
}
}
dashboard.ConfigureDataConnection += DashboardViewer_ConfigureDataConnection;
//dashboard.LoadFromXml(curfile); //xml 파일 로드
// xml의 parameter 설정
dashboard.Parameters[0].Value = _pMaterialOutStatusEntity.CRUD;
dashboard.Parameters[1].Value = DateTime.Parse(_luTORDER_DATE.FromDateTime.ToString()).ToString("yyyyMMdd"); //_luTORDER_DATE.FromDateTime.ToString().Substring(0, 10).Replace("-", "");
dashboard.Parameters[2].Value = DateTime.Parse(_luTORDER_DATE.ToDateTime.ToString()).ToString("yyyyMMdd"); //_luTORDER_DATE.ToDateTime.ToString().Substring(0, 10).Replace("-", "");
dashboard.Parameters[3].Value = _luTINOUT_ID.Text;
dashboard.Parameters[4].Value = _luTPART.CodeText;
dashboard.Parameters[5].Value = _luTPART.NameText;
dashboard.Parameters[6].Value = _luTVEND.CodeText;
dashboard.Parameters[7].Value = _luTVEND.NameText.ToString();
dashboard.Parameters[8].Value = _pMaterialOutStatusEntity.LANGUAGE_TYPE;
// Title 설정
dashboard.Title.Visible = false;
dashboardViewer.Dashboard = dashboard;
dashboardViewer.Refresh();
//DisplayMessage("조회 되었습니다.");
DisplayMessage(_pMSG_SEARCH);
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
// _gdSUB_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void Dashboard_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strFTP_PATH = "";
string sfilename = "";
_dtList = new SensorDataSearchBusiness().SensorDataSearch_Info_Filename(_pSensorDataSearchEntity); //Entity에 WINDOW_NAME 추가
if (_dtList == null)
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
return;
}
if (_dtList.Rows.Count == 0)
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_NO_SELECT_FILEFORM);
return;
}
for (int i = 0; i < _dtList.Rows.Count; i++)
{
string menu_no = _dtList.Rows[i]["menu_no"].ToString();
string dsp_sort = _dtList.Rows[i]["dsp_sort"].ToString();
string curfile = Application.StartupPath + "\\Template\\" + _dtList.Rows[i][2].ToString();
sfilename = _dtList.Rows[i][2].ToString();
//if (!File.Exists(curfile)) // 같은 것이 있으면, 폴더에서 해당 파일명을 불러와서 DashboardViewer.DashboardSource에 띄우기 / 없으면, 폴더에 다운
//{
// // Template 폴더에 다운로드
// _obList = new SensorDataSearchBusiness().Templete_Download(_pSensorDataSearchEntity, menu_no, dsp_sort);
// byte[] xmlfile = (byte[])_obList;
// using (Stream file = File.OpenWrite(curfile))
// {
// file.Write(xmlfile, 0, xmlfile.Length);
// }
//}
}
strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_IP_PORT, "USER", "PROGRAM_VIEW", _pSensorDataSearchEntity.WINDOW_NAME);
//CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, (saveFile.FileName.ToString().Split('\\')).Last(), _pFTP_ID, _pFTP_PW, strLOCAL_PATH);
Dashboard dashboard = new Dashboard();
//FTP의 엑셀 파일 control에 바인딩
using (Stream responseStream = CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, sfilename, _pFTP_ID, _pFTP_PW))
{
if (responseStream != null)
{
dashboard.LoadFromXml(responseStream); //xml 파일 로드
}
}
dashboard.ConfigureDataConnection += DashboardViewer_ConfigureDataConnection;
//dashboard.LoadFromXml(curfile); //xml 파일 로드
if (!_pFirstYN)
{
// xml의 parameter 설정
//dashboard.Parameters[0].Value = _pSensorDataSearchEntity.RESOURCE_CODE;
dashboard.Parameters[0].Value = _pSensorDataSearchEntity.RESOURCE_CODE;
dashboard.Parameters[1].Value = DateTime.Parse(_luT_DATE.FromDateTime.ToString()).ToString("yyyyMMdd");
dashboard.Parameters[2].Value = DateTime.Parse(_luT_DATE.ToDateTime.ToString()).ToString("yyyyMMdd");
dashboard.Parameters[3].Value = _pSensorDataSearchEntity.INTERVAL;
// Title 설정
dashboard.Title.Visible = false;
dashboardViewer.Dashboard = dashboard;
dashboardViewer.Refresh();
//DisplayMessage("조회 되었습니다.");
DisplayMessage(_pMSG_SEARCH);
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
// _gdSUB_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void File_Delete()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
//GridView gv = _gdMAIN_VIEW as GridView;
bool isError = false;
//if (gv.GetFocusedValue() != null)
//{
_pucPartDocumentListPopup_T02Entity.CRUD = "U";
_pucPartDocumentListPopup_T02Entity.DOCUMENT_ID = _gdSUB_VIEW.GetFocusedRowCellValue("DOCUMENT_ID").ToString();
_pucPartDocumentListPopup_T02Entity.DOCUMENT_TYPE = _luDOCUMENT_TYPE.GetValue().ToString();
_pucPartDocumentListPopup_T02Entity.PART_CODE = _gdSUB_VIEW.GetFocusedRowCellValue("PART_CODE").ToString();
_pucPartDocumentListPopup_T02Entity.SEQ = _gdSUB_VIEW.GetFocusedRowCellValue("SEQ").ToString();
_pucPartDocumentListPopup_T02Entity.FILE_NAME_1 = ""; //_gdSUB_VIEW.GetFocusedRowCellValue("FILE_NAME_1").ToString();
_pucPartDocumentListPopup_T02Entity.FILE_NAME_2 = ""; //_gdSUB_VIEW.GetFocusedRowCellValue("FILE_NAME_2").ToString();
_pucPartDocumentListPopup_T02Entity.EXTENSION = ""; //_gdSUB_VIEW.GetFocusedRowCellValue("EXTENSION").ToString();
_pucPartDocumentListPopup_T02Entity.USE_YN = _gdSUB_VIEW.GetFocusedRowCellValue("USE_YN").ToString();
_pucPartDocumentListPopup_T02Entity.REMARK = _gdSUB_VIEW.GetFocusedRowCellValue("REMARK").ToString();
//}
isError = new ucPartDocumentListPopup_T02Business().Document_File_Delete(_pucPartDocumentListPopup_T02Entity);
string strFTP_PATH = "";
if (isError)
{
//오류 발생.
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_DELETE_ERROR);
}
else
{
//정상 처리
strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pucPartDocumentListPopup_T02Entity.FTP_PATH, "FILE_DATA", _luDOCUMENT_TYPE.GetValue().ToString());
string qFileName = _pucPartDocumentListPopup_T02Entity.FILE_NAME_2;
string qPath = strFTP_PATH;
CoFAS_FTPManager.FTPDelete(qFileName, qPath, _pFTP_ID, _pFTP_PW);
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_DELETE);
_pucPartDocumentListPopup_T02Entity.CRUD = "R";
_pucPartDocumentListPopup_T02Entity.DOCUMENT_TYPE = _luDOCUMENT_TYPE.Text.ToString();
//_pucPartDocumentListPopup_T02Entity.DOCUMENT_NAME = _luDOCUMENT_NAME.Text.ToString();
//_pucPartDocumentListPopup_T02Entity.DOCUMENT_VER = _luDOCUMENT_VER.Text.ToString();
_pucPartDocumentListPopup_T02Entity.USE_YN = _luUSE_YN.GetValue();
SubFind_DisplayData();
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnEvent(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
//ButtonEdit btnedit = sender as ButtonEdit;
//GridView g = null;
////string _sFCode = string.Empty;
////string _sFName = string.Empty;
////string _sResultCode = string.Empty;
////string _sResultName = string.Empty;
//if (btnedit != null)
//{
// var gridControl = btnedit.Parent as DevExpress.XtraGrid.GridControl;
// if (gridControl == null)
// return;
// var gridView = gridControl.FocusedView as DevExpress.XtraGrid.Views.Grid.GridView;
// g = gridView;
// if (gridView == null)
// return;
// var dataRow = gridView.GetFocusedDataRow();
// if (dataRow == null)
// return;
//}
switch (e.Button.Caption.ToString())
{
case "VIEW_BUTTON": //해당 그리드에 필드명 // 2개 이상 그리드의 버튼 항목들은 버튼 타입에 필드 명칭이 모두 다르게 설정 되어야됨.
//_sFCode = g.GetFocusedRowCellValue("PART_CODE").ToString();
//_sFName = g.GetFocusedRowCellValue("PART_NAME").ToString();
//_gdSUB_VIEW.GetFocusedRowCellValue("DOCUMENT_ID").ToString();
try
{
//string strFTP_PATH = "";
//if (_pucPartDocumentListPopup_T02Entity.CRUD == "")
// _dtList.Rows.Clear();
////if (_gdSUB_VIEW.GetFocusedRowCellValue("DOCUMENT_ID").ToString() == "" || _gdSUB_VIEW.GetFocusedRowCellValue("DOCUMENT_ID") == null)
//// return;
//////if (_gdSUB_VIEW.GetRowCellValue(_gdSUB_VIEW.FocusedRowHandle, "FILE_NAME_2").ToString() == "")
////// return;
DataRow dr = _gdSUB_VIEW.GetFocusedDataRow();
string strFILE_NAME_2 = "";
if (dr["FILE_NAME_2"] != null)
{
strFILE_NAME_2 = dr["FILE_NAME_2"].ToString(); // _gdSUB_VIEW.GetRowCellValue(_gdSUB_VIEW.FocusedRowHandle, "FILE_NAME_2").ToString();
}
else
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_VIEW_DOCUMENT_ERROR);
}
string strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pucPartDocumentListPopup_T02Entity.FTP_PATH, "FILE_DATA", _luDOCUMENT_TYPE.GetValue().ToString());
string strEXTENSION = dr["EXTENSION"].ToString();
if (strEXTENSION == ".pdf")
{
CORE.UserForm.frmPdfView.CORP_CDDE = _pCORP_CODE;
CORE.UserForm.frmPdfView.USER_CODE = _pUSER_CODE;
CORE.UserForm.frmPdfView.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
//CORE.UserForm.frmPdfView.FONT_TYPE = _pFONT_SETTING;
var fst = CoFAS_FTPManager.FTPImage(strFTP_PATH, strFILE_NAME_2, _pFTP_ID, _pFTP_PW);
MemoryStream _ms = new MemoryStream();
byte[] buffer = new byte[16 * 1024];
int read;
while ((read = fst.Read(buffer, 0, buffer.Length)) > 0)
{
_ms.Write(buffer, 0, read);
}
CORE.UserForm.frmPdfView.MS = _ms;
CORE.UserForm.frmPdfView xfrmPdfView = new CORE.UserForm.frmPdfView(); //유저컨트롤러 설정 부분
xfrmPdfView.ShowDialog();
}
else
{
CORE.UserForm.frmImageView.CORP_CDDE = _pCORP_CODE;
CORE.UserForm.frmImageView.USER_CODE = _pUSER_CODE;
CORE.UserForm.frmImageView.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
//CORE.UserForm.frmImageView.FONT_TYPE = _pFONT_SETTING;
CORE.UserForm.frmImageView.IMAGE_DATA = Image.FromStream(CoFAS_FTPManager.FTPImage(strFTP_PATH, strFILE_NAME_2, _pFTP_ID, _pFTP_PW));
CORE.UserForm.frmImageView xfrmImageView = new CORE.UserForm.frmImageView(); //유저컨트롤러 설정 부분
xfrmImageView.ShowDialog();
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
break;
}
}
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);
}
}
private void SheetFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strFTP_PATH = "";
string strUSE_TYPE = "";
string strFILE_NAME = "";
_pEquipmentHistoryEntity.CRUD = "R";
//조회할거 프로시져
_dtList = new EquipmentHistoryBusiness().Sheet_Info_Sheet(_pEquipmentHistoryEntity); //엑셀 시트 조회하기
//엑셀서식관리 되면 다시 설정하기
strUSE_TYPE = _dtList.Rows[0]["USE_TYPE"].ToString();
strFILE_NAME = _dtList.Rows[0]["FILE_NAME"].ToString();
/*
strUSE_TYPE = "VIEW";
strFILE_NAME = "RawMaterialInspectRegister_Sample_v1.xlsx";
*/
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);
// 일반 컨트롤 일때 : DocumentFormat.Xls // UC일때, enFileFormat.Xls
IWorkbook workbook = _sdMAIN.Document;
Worksheet sheet_0 = workbook.Worksheets[0];
// Worksheet sheet_2 = workbook.Worksheets[2];
// Range rg = sheet_2.Range["J2:J3"];//판정유무
// sheet_0.CustomCellInplaceEditors.Add(sheet_0.Range["B28"], CustomCellInplaceEditorType.ComboBox, ValueObject.FromRange(rg));
// sheet_0.CustomCellInplaceEditors.Add(sheet_0.Range["H11:H22"], CustomCellInplaceEditorType.ComboBox, ValueObject.FromRange(rg));
// Range rg2 = sheet_2.Range["K2:K3"];//승인여부
try
{
}
catch
{
}
}
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);
}
}
private void SheetFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strFTP_PATH = "";
string strUSE_TYPE = "";
string strFILE_NAME = "";
_dtList = new SampleExcelBindingBusiness().Sheet_Info_Sheet(_pSampleExcelBindingEntity); //엑셀 시트 조회하기
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}/", _pFTP_PATH, "ORDER_FORM");
break;
case "VIEW":
strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_PATH, "USER", "PROGRAM_VIEW", _pWINDOW_NAME);
break;
}
if (_dtList != null)
{
using (Stream responseStream = CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW))
{
if (responseStream != null)
{
_sdMAIN.LoadDocument(responseStream, enFileFormat.Xlsx);
//_sdMAIN.LoadDocument((byte[])_ojList, DocumentFormat.Xlsx); // 일반 컨트롤 일때 : DocumentFormat.Xls // UC일때, enFileFormat.Xls
}
else
{
_sdMAIN.ClearSheet();
}
}
}
else
{
CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다.");
}
//_ojList = new ProcessMaterialStockStatusBusiness().Sheet_Info_Sheet(_pProcessMaterialStockStatusEntity);
//if (_ojList != null)
//{
// _sdMAIN.LoadDocument((byte[])_ojList, DocumentFormat.Xlsx); // 일반 컨트롤 일때 : DocumentFormat.Xls // UC일때, enFileFormat.Xls
//}
//else
//{
// CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다.");
//}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
// public static event OnDoubleClickEventHandler _OnDoubleClick; //그리드 로우 마우스 선택으로 값 넘길경우 필수
// public delegate void OnDoubleClickEventHandler(object sender, EventArgs e); //그리드 로우 마우스 선택으로 값 넘길경우 필수
#region 작업지시서 신규 저장
private void SheetFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
//_sdMAIN = new CORE.BaseControls.ucSpreadSheetControl();
// _sdMAIN.Options.Behavior.ShowPopupMenu = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;
string strFTP_PATH = "";
string strUSE_TYPE = "";
string strFILE_NAME = "";
_pucWorkOrderDocRegPopupEntity.CRUD = "R";
_pucWorkOrderDocRegPopupEntity.WINDOW_NAME = _pWINDOW_NAME;
//조회할거 프로시져
_dtList = new ucWorkOrderDocRegPopupBusiness().Sheet_Info_Sheet(_pucWorkOrderDocRegPopupEntity); //엑셀 시트 조회하기
//엑셀서식관리 되면 다시 설정하기
//제조 : 0 ( PT040001)
if (_pucWorkOrderDocRegPopupEntity.PROCESS_CODE_MST == "PT040001" || _pucWorkOrderDocRegPopupEntity.PROCESS_CODE_MST == "PC01")
// if (_pucWorkOrderDocRegPopupEntity.PROCESS_CODE_MST == "PC01")
{
strUSE_TYPE = _dtList.Rows[0]["USE_TYPE"].ToString();
strFILE_NAME = _dtList.Rows[0]["FILE_NAME"].ToString();
}
else
{
strUSE_TYPE = _dtList.Rows[1]["USE_TYPE"].ToString();
strFILE_NAME = _dtList.Rows[1]["FILE_NAME"].ToString();
}
//포장 : 1
_pFILE_NAME = strFILE_NAME;
string[] tmp = strFILE_NAME.Split('.');
_pFile_Attr = tmp[tmp.Length - 1];
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[] tmp2;
if (_pucWorkOrderDocRegPopupEntity.FILE_NAME != "")
{
//확장자 자르기
tmp = _pucWorkOrderDocRegPopupEntity.FILE_NAME.Split('.');
_pFile_Attr = tmp[tmp.Length - 1];
//파일명 자르기
tmp2 = _pucWorkOrderDocRegPopupEntity.FILE_NAME.Split('/');
strFTP_PATH = string.Format(@"{0}{1}/", _pFTP_PATH, "PRODUCTION");
strFILE_NAME = tmp2[tmp2.Length - 1];
_luFILE_NAME.Text = strFILE_NAME;
}
// 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 (Stream responseStream = CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW))
{
if (responseStream != null)
{
// _sdMAIN.LoadDocument(responseStream, DocumentFormat.Xlsx);
//_sdMAIN.LoadDocument(responseStream, enFileFormat.Xlsx);
_sdMAIN.LoadDocument(responseStream, DocumentFormat.Xlsx);
try
{
_sdMAIN.CellBeginEdit -= _sdMAIN_CellBeginEdit;
_sdMAIN.CellBeginEdit += _sdMAIN_CellBeginEdit;
// _sdMAIN.PopupMenuShowing -= _sdMAIN_PopupMenuShowing;
// _sdMAIN.PopupMenuShowing += _sdMAIN_PopupMenuShowing;
}
catch
{
_sdMAIN.CellBeginEdit += _sdMAIN_CellBeginEdit;
// _sdMAIN.PopupMenuShowing += _sdMAIN_PopupMenuShowing;
}
}
else
{
//_sdMAIN.ClearSheet();
_sdMAIN.CloseCellEditor(CellEditorEnterValueMode.Default);
_sdMAIN.CreateNewDocument();
// _sdMAIN.ClearSheet();
}
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void Dashboard_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strFTP_PATH = "";
string sfilename = "";
_dtList = new Facility_Utilization_StatusBusiness().Facility_Utilization_Status_Info_Filename(_pFacility_Utilization_StatusEntity); //Entity에 WINDOW_NAME 추가
if (_dtList == null)
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
return;
}
if (_dtList.Rows.Count == 0)
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_NO_SELECT_FILEFORM);
return;
}
for (int i = 0; i < _dtList.Rows.Count; i++)
{
string menu_no = _dtList.Rows[i]["menu_no"].ToString();
string dsp_sort = _dtList.Rows[i]["dsp_sort"].ToString();
string curfile = Application.StartupPath + "\\Template\\" + _dtList.Rows[i][2].ToString();
sfilename = _dtList.Rows[i][2].ToString();
}
strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_IP_PORT, "USER", "PROGRAM_VIEW", _pFacility_Utilization_StatusEntity.WINDOW_NAME);
//CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, (saveFile.FileName.ToString().Split('\\')).Last(), _pFTP_ID, _pFTP_PW, strLOCAL_PATH);
Dashboard dashboard = new Dashboard();
//FTP의 엑셀 파일 control에 바인딩
using (Stream responseStream = CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, sfilename, _pFTP_ID, _pFTP_PW))
{
if (responseStream != null)
{
dashboard.LoadFromXml(responseStream); //xml 파일 로드
}
}
dashboard.ConfigureDataConnection += DashboardViewer_ConfigureDataConnection;
//dashboard.LoadFromXml(curfile); //xml 파일 로드
// if(dashboard.Parameters.Count==10)
// {
// xml의 parameter 설정
dashboard.Parameters[0].Value = _luT_START_DATE.DateTime.Year.ToString();//_luT_ORDER_DATE.FromDateTime.ToString().Substring(0, 10).Replace("-", "");
//dashboard.Parameters[1].Value = _luT_START_DATE.DateTime.Month.ToString().PadLeft(2,'0');//_luT_ORDER_DATE.ToDateTime.ToString().Substring(0, 10).Replace("-", "");
//}
//else
//{
// dashboard.Parameters[0].Value = _pJobResultRegisterEntity.CRUD;
// dashboard.Parameters[1].Value = DateTime.Parse(_luT_ORDER_DATE.FromDateTime.ToString()).ToString("yyyyMMdd");//_luT_ORDER_DATE.FromDateTime.ToString().Substring(0, 10).Replace("-", "");
// dashboard.Parameters[2].Value = DateTime.Parse(_luT_ORDER_DATE.ToDateTime.ToString()).ToString("yyyyMMdd");//_luT_ORDER_DATE.ToDateTime.ToString().Substring(0, 10).Replace("-", "");
// dashboard.Parameters[3].Value = _luT_PART.CodeText;
// dashboard.Parameters[4].Value = _luT_PART.NameText;
// dashboard.Parameters[5].Value = ""; // 공정번호 필요시에 추가.
// dashboard.Parameters[6].Value = ""; // 공정번호 필요시에 추가.
// dashboard.Parameters[7].Value = "PC010001"; // 공정명 필요시에 추가.
// dashboard.Parameters[8].Value = "PC010002";
// dashboard.Parameters[9].Value = "";
// dashboard.Parameters[10].Value = _pLANGUAGE_TYPE;
// dashboard.Parameters[11].Value = ""; ;
//}
// Title 설정
dashboard.Title.Visible = false;
dashboardViewer.Dashboard = dashboard;
dashboardViewer.Refresh();
//DisplayMessage("조회 되었습니다.");
DisplayMessage(_pMSG_SEARCH);
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
// _gdSUB_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void btnCmd_Click(object pSender, EventArgs pEventArgs)
{
TreeListMultiSelection selectedNodes = treeList1.Selection;
SimpleButton pCmd = pSender as SimpleButton;
int Acitve_Row = 0;
string sCls = pCmd.Name.Substring(6, 2);
switch (sCls)
{
case "10":
treeList1.MoveFirst();
break;
case "20":
treeList1.MovePrev();
break;
case "30":
_pPART_CODE = selectedNodes[0].GetValue(treeList1.Columns[0]).ToString();
_pPOPProductBOMEntity.PART_CODE = _pPART_CODE;
_pPART_NAME = selectedNodes[0].GetValue(treeList1.Columns[1]).ToString();
_pPOPProductBOMEntity.PART_NAME = _pPART_NAME;
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new POPProductBOMCommonBusiness().POPProductBOM_Image_Info(_pPOPProductBOMEntity);
if (_pPOPProductBOMEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pPOPProductBOMEntity.CRUD == ""))
{
string Image_nm2 = _dtList.Rows[0]["file2"].ToString();
Image_nm = _dtList.Rows[0]["file1"].ToString();
string document_type = _dtList.Rows[0]["Document_type"].ToString();
if (Image_nm.Contains(".pdf"))
{
if (Image_nm.IndexOf("*NoSave*") > -1 || Image_nm.Trim().Length < 4)
{
//CoFAS_DevExpressManager.ShowInformationMessage("저장하지 않아서 볼 수 없습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_NOT_DISPLAY_NOT_SAVE);
}
else
{
MemoryStream STR = null;
string strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pFTP_PATH, "FILE_DATA", document_type);
var stream = CoFAS_FTPManager.FTPImage(strFTP_PATH, Image_nm2, _pFTP_ID, _pFTP_PW);
MemoryStream _ms = new MemoryStream();
byte[] buffer = new byte[16 * 1024];
int read;
while ((read = stream.Read(buffer, 0, buffer.Length)) > 0)
{
_ms.Write(buffer, 0, read);
}
frmPdfView_bumah.CORP_CDDE = _pCORP_CODE;
frmPdfView_bumah.USER_CODE = _pUSER_CODE;
frmPdfView_bumah.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
frmPdfView_bumah.FONT_TYPE = _pFONT_SETTING;
frmPdfView_bumah.MS = _ms;
frmPdfView_bumah xfrmImageView = new frmPdfView_bumah(); //유저컨트롤러 설정 부분
xfrmImageView.ShowDialog();
xfrmImageView.Dispose();
}
}
else
{
if (Image_nm2.IndexOf(" * NoSave*") > -1 || Image_nm2.Trim().Length < 4)
{
//CoFAS_DevExpressManager.ShowInformationMessage("저장하지 않아서 볼 수 없습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_NOT_DISPLAY_NOT_SAVE);
}
else
{
string strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pFTP_PATH, "FILE_DATA", document_type);
frmImageView_buma.CORP_CDDE = _pCORP_CODE;
frmImageView_buma.USER_CODE = _pUSER_CODE;
frmImageView_buma.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
frmImageView_buma.FONT_TYPE = _pFONT_SETTING;
frmImageView_buma.IMAGE_DATA = Image.FromStream(CoFAS_FTPManager.FTPImage(strFTP_PATH, Image_nm2, _pFTP_ID, _pFTP_PW));
frmImageView_buma xfrmImageView = new POP.frmImageView_buma(Image_nm2, _pPART_NAME); //유저컨트롤러 설정 부분
xfrmImageView.ShowDialog();
xfrmImageView.Dispose();
}
}
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
break;
case "40":
treeList1.MoveNext();
break;
case "50":
treeList1.MoveLast();
break;
default: break;
}
}
