private void PrintOutput_Data() { try { Stream responseStream = null; responseStream = CORE.Function.CoFAS_FTPManager.FTPFileBinding("db2.coever.co.kr:8500/USER/PROGRAM_VIEW/frmMainPrinter/", "frmMainPrinterReport.xlsx", "ftpadmin", "Ftp89897788!#%"); spreadsheetControl1.LoadDocument(responseStream); wb = spreadsheetControl1.Document; if (wb.MailMergeDataSource == null) { return; } Object dsTemp = wb.MailMergeDataSource; ParametersCollection para = wb.MailMergeParameters; para["v_option1"].Value = ""; // KEY값 para["v_option2"].Value = ""; // 사용여부 para["v_option3"].Value = ""; // 사용자 para["v_option4"].Value = textBox1.Text == "" ? gridView1.GetRowCellValue(0, "PONO").ToString() : textBox1.Text; //첫 데이터 발행 para["v_option5"].Value = falg_print; IList <IWorkbook> result = wb.GenerateMailMergeDocuments(); using (MemoryStream resultStream = new MemoryStream()) { result[0].SaveDocument(resultStream, DocumentFormat.OpenXml); wb.LoadDocument(resultStream); wb.Worksheets[0].ActiveView.Zoom = 20; // 엑셀 시트 Size 조정 // Create an object containing printer settings. PrinterSettings printerSettings = new PrinterSettings(); // Define the printer to use. printerSettings.PrinterName = "frmMainPrinterReport"; printerSettings.PrintToFile = true; printerSettings.PrintFileName = "frmMainPrinterReport.xlsx"; // Specify that the first three pages should be printed. printerSettings.PrintRange = PrintRange.SomePages; printerSettings.FromPage = 1; printerSettings.ToPage = 3; // Set the number of copies to print. printerSettings.Copies = 1; // Print the document using the specified printer settings. spreadsheetControl1.Print();// .Print(printerSettings); Message_Log("발행", true, true); } } catch (Exception ex) { Message_Log("[PrintOutput_Data] :" + ex.ToString(), true, true); // tmrWorkOrder.Change(10000, 10000); } }
private void Form_SearchButtonClicked(object pSender, EventArgs pEventArgs) { try { Stream responseStream = null; string strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_IP_PORT, "USER", "PROGRAM_VIEW", _pWINDOW_NAME); responseStream = CORE.Function.CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, "Sample_Base3.xlsx", _pFTP_ID, _pFTP_PW); spreadsheetControl1.LoadDocument(responseStream); wb = spreadsheetControl1.Document; if (wb.MailMergeDataSource == null) { return; } Object dsTemp = wb.MailMergeDataSource; ParametersCollection para = wb.MailMergeParameters; para["From_Date"].Value = _luT_DATE.FromDateTime.ToString("yyyyMMdd"); para["To_Date"].Value = _luT_DATE.ToDateTime.ToString("yyyyMMdd"); para["Part_Name"].Value = ""; para["Process_Name"].Value = ""; IList <IWorkbook> result = wb.GenerateMailMergeDocuments(); using (MemoryStream resultStream = new MemoryStream()) { result[0].SaveDocument(resultStream, DocumentFormat.OpenXml); wb.LoadDocument(resultStream); worksheet = wb.Worksheets[0]; worksheet.ActiveView.Zoom = 50; } //spreadsheetCommandBarButtonItem133.PerformClick(); //Worksheet ws = wb.Worksheets[spreadsheetControl1.ActiveSheet.Name]; //Range rg = ws.Range["E1:E100"]; //ws.CustomCellInplaceEditors.Add(rg, CustomCellInplaceEditorType.ComboBox, ValueObject.FromRange(ws.Range["A1:A100"])); } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } catch (Exception ex) { CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT); //CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", ex.Message.ToString(), ex.TargetSite.ToString())); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void Form_SearchButtonClicked(object pSender, EventArgs pEventArgs) { try { if (wb == null) { return; } if (wb.MailMergeDataSource == null) { return; } Object dsTemp = wb.MailMergeDataSource; ParametersCollection para = wb.MailMergeParameters; //para["v_option1"].Value = textEdit1.Text == null ? "" : textEdit1.Text; para["v_crud"].Value = "R"; para["v_date_from"].Value = DateTime.Parse(_luTPRODUCTION_ORDER_DATE.FromDateTime.ToString()).ToString("yyyyMMdd") == null ? "" : DateTime.Parse(_luTPRODUCTION_ORDER_DATE.FromDateTime.ToString()).ToString("yyyyMMdd"); para["v_date_to"].Value = DateTime.Parse(_luTPRODUCTION_ORDER_DATE.ToDateTime.ToString()).ToString("yyyyMMdd") == null ? "" : DateTime.Parse(_luTPRODUCTION_ORDER_DATE.ToDateTime.ToString()).ToString("yyyyMMdd"); //para["v_crud"].Value = "R"; //para["v_date_from"].Value = "20180701" == null ? "" : "20180801"; //para["v_date_to"].Value = "20180830" == null ? "" : "20180830"; IList <IWorkbook> result = wb.GenerateMailMergeDocuments(); using (MemoryStream resultStream = new MemoryStream()) { result[0].SaveDocument(resultStream, DocumentFormat.OpenXml); wb.LoadDocument(resultStream); } //spreadsheetCommandBarButtonItem133.PerformClick(); //Worksheet ws = wb.Worksheets[spreadsheetControl1.ActiveSheet.Name]; //Range rg = ws.Range["E1:E100"]; //ws.CustomCellInplaceEditors.Add(rg, CustomCellInplaceEditorType.ComboBox, ValueObject.FromRange(ws.Range["A1:A100"])); } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } catch (Exception ex) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", ex.Message.ToString(), ex.TargetSite.ToString())); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
// DB 처리 #region ○ 메인조회 - MainFind_DisplayData() private void MainFind_DisplayData() { try { Stream responseStream = null; string strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_IP_PORT, "USER", "PROGRAM_VIEW", _pWINDOW_NAME); responseStream = CORE.Function.CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, "LotManagementReport1.xlsx", _pFTP_ID, _pFTP_PW); spreadsheetControl1.LoadDocument(responseStream); wb = spreadsheetControl1.Document; if (wb.MailMergeDataSource == null) { return; } Object dsTemp = wb.MailMergeDataSource; ParametersCollection para = wb.MailMergeParameters; para["v_option1"].Value = _luTORDER_DATE.FromDateTime.ToString("yyyyMMdd"); para["v_option2"].Value = _luTORDER_DATE.ToDateTime.ToString("yyyyMMdd"); IList <IWorkbook> result = wb.GenerateMailMergeDocuments(); using (MemoryStream resultStream = new MemoryStream()) { result[0].SaveDocument(resultStream, DocumentFormat.OpenXml); wb.LoadDocument(resultStream); worksheet = wb.Worksheets[0]; worksheet.ActiveView.Zoom = 50; } } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } finally { //_gdMAIN_VIEW.BestFitColumns(); CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); Stream responseStream = null; responseStream = CORE.Function.CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW); spreadsheetControl1.LoadDocument(responseStream); wb = spreadsheetControl1.Document; if (wb.MailMergeDataSource == null) { return; } Object dsTemp = wb.MailMergeDataSource; ParametersCollection para = wb.MailMergeParameters; para["v_option1"].Value = ARRAY_CODE[0].ToString(); // R para["v_option2"].Value = ARRAY_CODE[1].ToString(); // _pINOUT_CODE_LIST IList <IWorkbook> result = wb.GenerateMailMergeDocuments(); using (MemoryStream resultStream = new MemoryStream()) { result[0].SaveDocument(resultStream, DocumentFormat.OpenXml); wb.LoadDocument(resultStream); } } 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 MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); Stream responseStream = null; if (ARRAY_CODE[0].ToString().Equals("OutsourcingInfoRegister")) { responseStream = CORE.Function.CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW); } else if (ARRAY_CODE[0].ToString().Equals("WorkResultRegister_T06")) { responseStream = CORE.Function.CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW); } else if (ARRAY_CODE[0].ToString().Equals("WorkResultRegister_T05")) { responseStream = CORE.Function.CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW); } else if (ARRAY_CODE[0].ToString().Equals("WorkResultRegister_T08")) { responseStream = CORE.Function.CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW); } spreadsheetControl1.LoadDocument(responseStream); wb = spreadsheetControl1.Document; if (wb.MailMergeDataSource == null) { return; } Object dsTemp = wb.MailMergeDataSource; ParametersCollection para = wb.MailMergeParameters; para["v_option1"].Value = ARRAY_CODE[1].ToString(); // KEY값 para["v_option2"].Value = ARRAY_CODE[2].ToString(); // 사용여부 para["v_option3"].Value = USER_CODE; // 사용자 para["v_option4"].Value = ARRAY_CODE[3].ToString(); // 페이징 행수 기준 para["v_option5"].Value = ARRAY_CODE[4].ToString(); // 시작번호 IList <IWorkbook> result = wb.GenerateMailMergeDocuments(); using (MemoryStream resultStream = new MemoryStream()) { result[0].SaveDocument(resultStream, DocumentFormat.OpenXml); wb.LoadDocument(resultStream); } } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } catch (Exception ex) { CoFAS_DevExpressManager.ShowErrorMessage("Exception :" + ex.ToString()); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); Stream responseStream = null; responseStream = CORE.Function.CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW); spreadsheetControl1.LoadDocument(responseStream); wb = spreadsheetControl1.Document; if (wb.MailMergeDataSource == null) { return; } /* * switch (DBManager.PrimaryDBManagerType) * { * case DBManagerType.MySql: * wb.MailMergeDataSource = new DevExpress.DataAccess.Sql.SqlDataSource(new MySqlConnectionParameters(DBManager.InitDatabaseServer, DBManager.InitDatabaseName, DBManager.InitDatabaseID, DBManager.InitDatabasePass, 3306)); * break; * case DBManagerType.SQLServer: * wb.MailMergeDataSource = new MsSqlConnectionParameters(); * break; * } */ Object dsTemp = wb.MailMergeDataSource; ParametersCollection para = wb.MailMergeParameters; para["v_option1"].Value = ARRAY_CODE[1].ToString(); // KEY값 para["v_option2"].Value = ARRAY_CODE[2].ToString(); // 사용여부 para["v_option3"].Value = USER_CODE; // 사용자 para["v_option4"].Value = ARRAY_CODE[3].ToString(); // 페이징 행수 기준 para["v_option5"].Value = ARRAY_CODE[4].ToString(); // 시작번호 IList <IWorkbook> result = wb.GenerateMailMergeDocuments(); using (MemoryStream resultStream = new MemoryStream()) { result[0].SaveDocument(resultStream, DocumentFormat.OpenXml); wb.LoadDocument(resultStream); } } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } catch (Exception ex) { CoFAS_DevExpressManager.ShowErrorMessage("Exception :" + ex.ToString()); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void barButtonItem1_ItemClick(object sender, ItemClickEventArgs e) { IWorkbook workbook = spreadsheetControl.Document; IList <IWorkbook> workbooks = workbook.GenerateMailMergeDocuments(); }