private void desglose_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'reportes_dataSet.materiales_modulos' table. You can move, or remove it, as needed. this.materiales_modulosTableAdapter.Fill(this.reportes_dataSet.materiales_modulos); string display_n = string.Empty; if (constants.nombre_cotizacion != string.Empty) { display_n = " - " + constants.nombre_cotizacion; } //----------> if (constants.nombre_proyecto != string.Empty) { display_n = display_n + " - " + constants.nombre_proyecto; } //----------> if (titulo != string.Empty) { display_n = display_n + " - " + titulo; } //----------> reportViewer1.LocalReport.DisplayName = "Desglose" + display_n; reportViewer1.LocalReport.SetParameters(new ReportParameter("header", constants.getExternalImage("header"))); reportViewer1.LocalReport.SetParameters(new ReportParameter("cliente", constants.nombre_cotizacion == "" ? "n/a" : constants.nombre_cotizacion)); reportViewer1.LocalReport.SetParameters(new ReportParameter("proyecto", constants.nombre_proyecto == "" ? "n/a" : constants.nombre_proyecto)); reportViewer1.LocalReport.SetParameters(new ReportParameter("folio", constants.folio_abierto.ToString())); reportViewer1.LocalReport.SetParameters(new ReportParameter("factor", "x" + factor)); reportViewer1.LocalReport.SetParameters(new ReportParameter("titulo", titulo)); ReportPageSettings ps = reportViewer1.LocalReport.GetDefaultPageSettings(); this.reportViewer1.ParentForm.Width = ps.PaperSize.Width; this.reportViewer1.RefreshReport(); }
/// <summary> /// Initializes a new instance of the <see cref="ReportPrintDocument"/> class. /// </summary> /// <param name="report">The <see cref="Report"/> to print.</param> private ReportPrintDocument(Report report) { _rendered = false; _pageSettings = report.GetDefaultPageSettings(); _deviceInfo = CreateEmfDeviceInfo(); _pages = new List <Stream>(); }
private void print_inventarios_Load(object sender, EventArgs e) { if (peps == "Salidas") { this.Text = constants.org_name.ToUpper() + " - " + peps; reportViewer1.LocalReport.ReportEmbeddedResource = "cristales_pva.inventarios_salidas.rdlc"; this.salidas_tBindingSource.DataSource = Table; } else if (peps == "Entradas") { this.Text = constants.org_name.ToUpper() + " - " + peps; reportViewer1.LocalReport.ReportEmbeddedResource = "cristales_pva.inventarios_entradas.rdlc"; this.entradas_tBindingSource.DataSource = Table; } else { this.Text = constants.org_name.ToUpper() + " - Existencias"; this.inventarios_tBindingSource.DataSource = Table; } reportViewer1.LocalReport.DisplayName = this.Text; //-----------------------------------------------------------------------------------------------------------> reportViewer1.LocalReport.SetParameters(new ReportParameter("Image", constants.getExternalImage("header"))); reportViewer1.LocalReport.SetParameters(new ReportParameter("lista", lista)); reportViewer1.LocalReport.SetParameters(new ReportParameter("tienda", tienda)); reportViewer1.LocalReport.SetParameters(new ReportParameter("periodo", periodo)); reportViewer1.ZoomMode = ZoomMode.PageWidth; ReportPageSettings ps = reportViewer1.LocalReport.GetDefaultPageSettings(); this.reportViewer1.ParentForm.Width = ps.PaperSize.Width; this.reportViewer1.RefreshReport(); }
private void Historial_registros_Load(object sender, EventArgs e) { resetReport(new cotizaciones_local()); this.datos_reporteTableAdapter.Fill(this.reportes_dataSet.datos_reporte); reportViewer1.LocalReport.SetParameters(new ReportParameter("Image", constants.getExternalImage("header"))); ReportPageSettings ps = reportViewer1.LocalReport.GetDefaultPageSettings(); this.reportViewer1.ParentForm.Width = ps.PaperSize.Width; this.reportViewer1.RefreshReport(); }
/// <summary> /// Get the report settings /// </summary> /// <param name="printDoc">PrintDocument object</param> private void GetReportPrintSettings(ref PrintDocument printDoc) { ReportPageSettings rps = Report.LocalReport.GetDefaultPageSettings(); _pageSettings.PaperSize = rps.PaperSize; _pageSettings.Margins = rps.Margins; printDoc.DefaultPageSettings.Margins = rps.Margins; printDoc.DefaultPageSettings.PaperSize = rps.PaperSize; }
public static void PrintToPrinter(this LocalReport report) { m_pageSettings = new PageSettings(); ReportPageSettings reportPageSettings = report.GetDefaultPageSettings(); m_pageSettings.PaperSize = reportPageSettings.PaperSize; m_pageSettings.Margins = reportPageSettings.Margins; Export(report); }
private void analiticas_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'reportes_dataSet.datos_reporte' table. You can move, or remove it, as needed. this.datos_reporteTableAdapter.Fill(this.reportes_dataSet.datos_reporte); // TODO: This line of code loads data into the 'reportes_dataSet.articulos_reporte' table. You can move, or remove it, as needed. this.articulos_reporteTableAdapter.Fill(this.reportes_dataSet.articulos_reporte); ReportPageSettings ps = reportViewer1.LocalReport.GetDefaultPageSettings(); this.reportViewer1.ParentForm.Width = ps.PaperSize.Width; this.reportViewer1.RefreshReport(); }
private AutoPrintCls(Report report) { // Set the page settings to the default defined in the report ReportPageSettings reportPageSettings = report.GetDefaultPageSettings(); // The page settings object will use the default printer unless // PageSettings.PrinterSettings is changed. This assumes there // is a default printer. m_pageSettings = new PageSettings(); m_pageSettings.PaperSize = reportPageSettings.PaperSize; m_pageSettings.Margins = reportPageSettings.Margins; }
private void FrmViewChequeDetailsLoad(object sender, EventArgs e) { ReportPageSettings rptPageSettings = RptChequeDetails.LocalReport.GetDefaultPageSettings(); if (RptChequeDetails.ParentForm.Width > rptPageSettings.PaperSize.Width) { int vPad = (RptChequeDetails.ParentForm.Width - rptPageSettings.PaperSize.Width) / 2; RptChequeDetails.Padding = new Padding(vPad - 20, 1, vPad - 20, 1); } this.proc_ReportTableAdapter.Fill(this.chequeMaintananceDBdsReport.Proc_Report); RptChequeDetails.RefreshReport(); }
public void prt_원장조회(DataTable dt, string sDay1, string sDay2, string sCust, string sCondition) { lblMsg.Visible = true; Application.DoEvents(); try { if (dt != null && dt.Rows.Count > 0) { ////for (int kk = 0; kk < dt.Rows.Count; kk++) ////{ //// //if (dt매출매출항목.Rows[kk]["규격"].ToString().Length > 10) //// //{ //// // dt매출매출항목.Rows[kk]["규격"] = dt매출매출항목.Rows[kk]["규격"].ToString().Substring(0, 9) + "..."; //// //} ////} this.reportViewer1.Reset(); this.reportViewer1.LocalReport.DisplayName = "원장조회" + "_" + sDay1 + "_" + sDay2; this.reportViewer1.LocalReport.ReportPath = "Reports\\rpt원장조회.rdlc"; ReportDataSource ds = new ReportDataSource("DataSet1", dt); this.reportViewer1.LocalReport.DataSources.Add(ds); ReportParameterCollection rptParams = new ReportParameterCollection(); rptParams.Add(new ReportParameter("p제목", "원장 조회")); rptParams.Add(new ReportParameter("p검색조건", sCondition)); this.reportViewer1.LocalReport.SetParameters(rptParams); ReportPageSettings rpg = reportViewer1.LocalReport.GetDefaultPageSettings(); System.Drawing.Printing.PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.PaperSize = rpg.PaperSize; pg.Margins = rpg.Margins; pg.Landscape = false; // false = 세로, true = 가로 reportViewer1.SetPageSettings(pg); this.reportViewer1.RefreshReport(); this.reportViewer1.SetDisplayMode(DisplayMode.PrintLayout); this.reportViewer1.ZoomMode = ZoomMode.PageWidth; } } catch (Exception ex) { wnLog.writeLog(wnLog.LOG_ERROR, ex.Message + " - " + ex.ToString()); MessageBox.Show("시스템에 문제가 있습니다."); this.Hide(); } lblMsg.Visible = false; }
public void RefreshReport() { ReportPageSettings rptPageSettings = RptChequeDetails.LocalReport.GetDefaultPageSettings(); if (RptChequeDetails.ParentForm.Width > rptPageSettings.PaperSize.Width) { int vPad = (RptChequeDetails.ParentForm.Width - rptPageSettings.PaperSize.Width) / 2; RptChequeDetails.Padding = new Padding(vPad - 20, 1, vPad - 20, 1); } RptChequeDetails.ZoomMode = ZoomMode.FullPage; this.proc_ReportTableAdapter.Fill(this.chequeMaintananceDBdsReport.Proc_Report); RptChequeDetails.RefreshReport(); }
private ReportPrintDocument(Report report, bool isLanscape) { // Set the page settings to the default defined in the report ReportPageSettings reportPageSettings = report.GetDefaultPageSettings(); // The page settings object will use the default printer unless // PageSettings.PrinterSettings is changed. This assumes there // is a default printer. m_pageSettings = new PageSettings(); m_pageSettings.PaperSize = reportPageSettings.PaperSize; m_pageSettings.Margins = reportPageSettings.Margins; m_pageSettings.Landscape = isLanscape; }
private ReportDirect(Report report) { // Set the page settings to the default defined in the report ReportPageSettings reportPageSettings = report.GetDefaultPageSettings(); // The page settings object will use the default printer unless // PageSettings.PrinterSettings is changed. This assumes there // is a default printer. m_pageSettings = new PageSettings(); //System.Windows.MessageBox.Show(reportPageSettings.PaperSize.PaperName); m_pageSettings.PaperSize = reportPageSettings.PaperSize; m_pageSettings.Margins = reportPageSettings.Margins; }
public void prt_원자재재고현황(DataTable dt, string sDay1, string sCondition) { lblMsg.Visible = true; Application.DoEvents(); try { if (dt != null && dt.Rows.Count > 0) { if (sCondition == "원자재재고현황") { this.reportViewer1.Reset(); this.reportViewer1.LocalReport.DisplayName = "원자재재고현황"; this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + "\\Reports\\rpt원자재재고현황.rdlc"; ReportDataSource ds = new ReportDataSource("DataSet1", dt); this.reportViewer1.LocalReport.DataSources.Add(ds); ReportParameterCollection rptParams = new ReportParameterCollection(); rptParams.Add(new ReportParameter("p제목", "원자재재고현황")); //rptParams.Add(new ReportParameter("p견적구분", "아래와 같이 견적합니다.")); rptParams.Add(new ReportParameter("p검색조건", "검색일자 : " + sDay1)); this.reportViewer1.LocalReport.SetParameters(rptParams); } ReportPageSettings rpg = reportViewer1.LocalReport.GetDefaultPageSettings(); System.Drawing.Printing.PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.PaperSize = rpg.PaperSize; pg.Margins = rpg.Margins; pg.Landscape = false; // false = 세로, true = 가로 reportViewer1.SetPageSettings(pg); this.reportViewer1.RefreshReport(); this.reportViewer1.SetDisplayMode(DisplayMode.PrintLayout); this.reportViewer1.ZoomMode = ZoomMode.PageWidth; } } catch (Exception ex) { wnLog.writeLog(wnLog.LOG_ERROR, ex.Message + " - " + ex.ToString()); MessageBox.Show("시스템에 문제가 있습니다."); this.Hide(); } lblMsg.Visible = false; }
public static string GetDeviceInfoFromReport(LocalReport rpt, string uiCulture, string format) { string strMargins; string orientation; //Render overwrites margins defined in RDLC; capture margins in RDLC ReportPageSettings pageSettings = rpt.GetDefaultPageSettings(); strMargins = String.Concat((Convert.ToDouble(pageSettings.Margins.Top) / 40.0).ToString(), ",", (Convert.ToDouble(pageSettings.Margins.Left) / 40.0).ToString(), ",", (Convert.ToDouble(pageSettings.Margins.Bottom) / 40.0).ToString(), ",", (Convert.ToDouble(pageSettings.Margins.Right) / 40.0).ToString()); //Capture report orientation orientation = pageSettings.IsLandscape ? "landscape" : "portrait"; return(GetDeviceInfo(uiCulture, format, strMargins, orientation)); }
/// <summary> /// /// </summary> /// <param name="localReport"></param> public ReportPrintDocument(LocalReport localReport) { // Set the page settings to the default defined in the report ReportPageSettings reportPageSettings = localReport.GetDefaultPageSettings(); // The page settings object will use the default printer unless // PageSettings.PrinterSettings is changed. This assumes there // is a default printer. m_pageSettings = new PageSettings(); m_pageSettings.PaperSize = reportPageSettings.PaperSize; m_pageSettings.Margins = reportPageSettings.Margins; RenderAllLocalReportPages(localReport); }
private ReportPrintDocument(Report report) { // Set the page settings to the default defined in the report ReportPageSettings reportPageSettings = report.GetDefaultPageSettings(); // The page settings object will use the default printer unless // PageSettings.PrinterSettings is changed. This assumes there // is a default printer. _mPageSettings = new PageSettings { Landscape = true, PaperSize = reportPageSettings.PaperSize, Margins = reportPageSettings.Margins }; }
private void Export(LocalReport report) { report.EnableExternalImages = true; ReportPageSettings rps = report.GetDefaultPageSettings(); ps = rps.PaperSize; ms = rps.Margins; isLandscape = rps.IsLandscape; Width = ps.Width; Height = ps.Height; if (rps.IsLandscape) { Width = ps.Height; Height = ps.Width; } int totalPages = 1; Warning[] warnings; string deviceInfo; do { this.Dispose(); m_streams = new List <Stream>(); deviceInfo = @"<DeviceInfo> <OutputFormat>EMF</OutputFormat> <PageWidth>" + Width / 100.00 + "in</PageWidth>" + "<PageHeight>" + Height / 100.00 + "in</PageHeight>" + "<MarginTop>" + ms.Top / 100.00 + "in</MarginTop>" + "<MarginLeft>" + ms.Left / 100.00 + "in</MarginLeft>" + "<MarginRight>" + ms.Right / 100.00 + "in</MarginRight>" + "<MarginBottom>" + ms.Bottom / 100.00 + "in</MarginBottom>" + "</DeviceInfo>"; report.Render("Image", deviceInfo, CreateStream, out warnings); foreach (Stream stream in m_streams) { stream.Position = 0; } totalPages = m_streams.Count; if (totalPages > 1) { Height += 29; } }while (totalPages > 1); }
public void prt_HACCP점검표(DataTable dt, DataTable dt2, string sDate, string sNum, string sCondition) { try { if (dt != null && dt.Rows.Count > 0) { this.reportViewer1.Reset(); this.reportViewer1.LocalReport.DisplayName = "중요관리점(CCP) 검증 점검표" + "_" + sDate + "_" + sNum; this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + "\\Reports\\rptHACCP점검표.rdlc"; ReportDataSource ds = new ReportDataSource("DataSet1", dt); //this.reportViewer1.LocalReport.DataSources.Add(ds); ds = new ReportDataSource("DataSet1", dt2); this.reportViewer1.LocalReport.DataSources.Add(ds); ReportParameterCollection rptParams = new ReportParameterCollection(); //rptParams.Add(new ReportParameter("p제목", "발주현황표")); this.reportViewer1.LocalReport.SetParameters(rptParams); } ReportPageSettings rpg = reportViewer1.LocalReport.GetDefaultPageSettings(); System.Drawing.Printing.PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.PaperSize = rpg.PaperSize; pg.Margins = rpg.Margins; pg.Landscape = false; // false = 세로, true = 가로 //var setup = reportViewer1.GetPageSettings(); //setup.PaperSize.Width = 900; //setup.PaperSize.Height = 600; //setup.Landscape = false; //setup.Margins.Left = 27; reportViewer1.SetPageSettings(pg);//pg this.reportViewer1.RefreshReport(); this.reportViewer1.SetDisplayMode(DisplayMode.PrintLayout); this.reportViewer1.ZoomMode = ZoomMode.PageWidth; } catch (Exception e) { wnLog.writeLog(wnLog.LOG_ERROR, e.Message + " - " + e.ToString()); MessageBox.Show("시스템에 문제가 있습니다."); this.Hide(); } }
private void PrintPreview_Load(object sender, EventArgs e) { try { ReportDataSource datasource = null; ReportDataSource data = null; ReportDataSource datatable = null; con = new Connect(); DataTable dt = new DataTable(); dt = GetDataBill(printid); DataTable dsCustomers = GetData(printid); DataTable table = GetDataTable(printid); datatable = new ReportDataSource("DataSet3", table); datasource = new ReportDataSource("DataSet1", dsCustomers); data = new ReportDataSource("DataSet2", dt); //this.reportViewer2.LocalReport.ReportPath="R_Bill.rdlc"; this.reportViewer2.LocalReport.DataSources.Clear(); this.reportViewer2.LocalReport.DataSources.Add(datasource); this.reportViewer2.LocalReport.DataSources.Add(data); this.reportViewer2.LocalReport.DataSources.Add(datatable); PageSettings pg = new PageSettings(); pg.Landscape = false; pg.Margins.Top = 15; pg.Margins.Bottom = 0; pg.Margins.Left = 15; pg.Margins.Right = 0; PaperSize size = new PaperSize("A5", 583, 827); size.RawKind = (int)PaperKind.A5; pg.PaperSize = size; this.reportViewer2.SetPageSettings(pg); this.reportViewer2.RefreshReport(); ReportPageSettings rst = reportViewer2.LocalReport.GetDefaultPageSettings(); //if (reportViewer2.ParentForm.Width > rst.PaperSize.Width) //{ // int vPad = (reportViewer1.ParentForm.Width - rst.PaperSize.Width) / 2; // reportViewer2.Padding = new Padding(vPad - 20, 1, vPad - 20, 1); //} } catch (Exception ex) { throw ex; } }
private ReportPrintDocument_Landscape(Report report) { // Set the page settings to the default defined in the report ReportPageSettings reportPageSettings = report.GetDefaultPageSettings(); // The page settings object will use the default printer unless // PageSettings.PrinterSettings is changed. This assumes there // is a default printer. m_pageSettings = new PageSettings(); m_pageSettings.PaperSize = new System.Drawing.Printing.PaperSize("A4", 1169, 827); m_pageSettings.PaperSize.RawKind = (int)System.Drawing.Printing.PaperKind.A4; m_pageSettings.Landscape = true; // reportPageSettings.PrinterSettings(m_pageSettings); }
//public int distinctTop; //public int distinctButtom; //public int distinctLeft; //public int distinctRight; public ReportPrintDocument(ServerReport serverReport, int distinctLeft, int distinctRight, int distinctTop, int distinctButtom) { // Set the page settings to the default defined in the report ReportPageSettings reportPageSettings = serverReport.GetDefaultPageSettings(); // The page settings object will use the default printer unless // PageSettings.PrinterSettings is changed. This assumes there // is a default printer. m_pageSettings = new PageSettings(); //m_pageSettings.PaperSize = reportPageSettings.PaperSize; m_pageSettings.PaperSize = new PaperSize("custom", reportPageSettings.PaperSize.Height, reportPageSettings.PaperSize.Width); //m_pageSettings.Margins = reportPageSettings.Margins; m_pageSettings.Margins = new Margins(distinctLeft, distinctRight, distinctTop, distinctButtom); //reportPageSettings.Margins; RenderAllServerReportPages(serverReport); // MessageBox.Show(distinctTop.ToString()+","+ distinctButtom.ToString()+","+distinctLeft.ToString()+","+distinctRight.ToString()+","); }
private void FillPages(bool landscape) { //PaperSize paper_size = ctlReportViewer.LocalReport.GetDefaultPageSettings().PaperSize; //string deviceInfo = // "<DeviceInfo>" + // "<OutputFormat>EMF</OutputFormat>" + // ((landscape) ? "<PageWidth>297mm</PageWidth><PageHeight>210mm</PageHeight>" : "<PageWidth>210mm</PageWidth><PageHeight>297mm</PageHeight>") + // "<MarginTop>0mm</MarginTop>" + // "<MarginLeft>0mm</MarginLeft>" + // "<MarginRight>0mm</MarginRight>" + // "<MarginBottom>10mm</MarginBottom>" + // "</DeviceInfo>"; ReportPageSettings set = ctlReportViewer.LocalReport.GetDefaultPageSettings(); //MarginsConverter conv = new MarginsConverter(); //string temp = conv.ConvertToInvariantString(set.Margins); string deviceInfo = "<DeviceInfo>" + "<OutputFormat>EMF</OutputFormat>" + ((landscape) ? "<PageWidth>297mm</PageWidth><PageHeight>210mm</PageHeight>" : "<PageWidth>210mm</PageWidth><PageHeight>297mm</PageHeight>") + "<MarginTop>" + Common.PropValueDecimal2String(set.Margins.Top / 3.937) + "mm</MarginTop>" + "<MarginLeft>" + Common.PropValueDecimal2String(set.Margins.Left / 3.937) + "mm</MarginLeft>" + "<MarginRight>" + Common.PropValueDecimal2String(set.Margins.Right / 3.937) + "mm</MarginRight>" + "<MarginBottom>" + Common.PropValueDecimal2String(set.Margins.Bottom / 3.937) + "mm</MarginBottom>" + "</DeviceInfo>"; Warning[] warnings; _pages = new List <Stream>(); if (ctlReportViewer.ProcessingMode == ProcessingMode.Local) { ctlReportViewer.LocalReport.Render("Image", deviceInfo, CreateStream, out warnings); } foreach (Stream stream in _pages) { stream.Position = 0; } _printdoc.PrintPage += new PrintPageEventHandler(PrintPage); //_printdoc.DefaultPageSettings.Landscape = (paper_size.Width > 850); }
private void FormReportView_Load(object sender, EventArgs e) { this.Text = this.FormCaption; LocalReport l = repView.LocalReport; l.DisplayName = this.ReportDisplayName; // hide the ReportViewer toolbar. this.repView.ShowToolBar = false; this.repView.DocumentMapCollapsed = true; btnDocumentMap.Checked = !this.repView.DocumentMapCollapsed; btnLayout.Checked = false; btnFind.Enabled = false; btnFindNext.Enabled = false; totalPages = this.repView.LocalReport.GetTotalPages() + 1; this.repView.CurrentPage = 1; displayCurrentPage(); reportPageSettings = repView.LocalReport.GetDefaultPageSettings(); pageSetupDialog = new PageSetupDialog(); pageSetupDialog.PrinterSettings = new PrinterSettings(); pageSettings = new PageSettings(pageSetupDialog.PrinterSettings); pageSetupDialog.PageSettings = new PageSettings(); pageSetupDialog.PageSettings = pageSettings; pageSetupDialog.PageSettings.Margins = repView.LocalReport.GetDefaultPageSettings().Margins; pageSetupDialog.PageSettings.PaperSize = repView.LocalReport.GetDefaultPageSettings().PaperSize; setupZoomCombo(); this.repView.RefreshReport(); }
public void prt_매입처원장(DataTable adoPrt2, DataGridView dgv, string strDay1, string strDay2, string strCondition) { DataTable adoPrt = GetDataTableFromDGV(dgv); try { if (adoPrt != null && adoPrt.Rows.Count > 0) { this.reportViewer1.Reset(); this.reportViewer1.LocalReport.DisplayName = "매출처 원장"; this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + "\\Reports\\rpt매출처원장.rdlc"; adoPrt.Columns["NO"].ColumnName = "전표분류"; adoPrt.Columns["BUY_DATE"].ColumnName = "일자명칭"; adoPrt.Columns["BUY_CD"].ColumnName = "전표번호"; adoPrt.Columns["INPUT_GUBUN"].ColumnName = "구분명칭"; adoPrt.Columns["PRODUCT_NM"].ColumnName = "상품명"; adoPrt.Columns["TOTAL_AMT"].ColumnName = "박스수량"; adoPrt.Columns["TOTAL_PRICE"].ColumnName = "박스단가"; adoPrt.Columns["TOTAL_MONEY"].ColumnName = "금액"; adoPrt.Columns["TOTAL_TAX_MONEY"].ColumnName = "부가세액"; adoPrt.Columns["GIVE_MONEY"].ColumnName = "수금액"; adoPrt.Columns["TOTAL_GIVE_MONEY"].ColumnName = "지급액"; adoPrt.Columns["DC_MONEY"].ColumnName = "할인액"; adoPrt.Columns["BALANCE"].ColumnName = "잔고"; adoPrt.Columns.Add("서비스박스"); adoPrt.Columns.Add("서비스낱개"); adoPrt.Columns.Add("낱개단가"); adoPrt.Columns.Add("총수량"); adoPrt.Columns.Add("낱개수량"); adoPrt.Columns.Add("중간수량"); adoPrt.Columns.Add("규격"); adoPrt.Columns.Add("정렬구분"); adoPrt.Columns.Add("일자"); for (int i = 0; i < adoPrt.Rows.Count; i++) { adoPrt.Rows[i]["서비스박스"] = "0"; adoPrt.Rows[i]["서비스낱개"] = "0"; adoPrt.Rows[i]["낱개단가"] = "0"; adoPrt.Rows[i]["박스단가"] = ""; adoPrt.Rows[i]["총수량"] = "0"; adoPrt.Rows[i]["낱개수량"] = "0"; adoPrt.Rows[i]["중간수량"] = "0"; adoPrt.Rows[i]["규격"] = "0"; adoPrt.Rows[i]["정렬구분"] = "0"; adoPrt.Rows[i]["일자"] = "0"; } ReportDataSource ds = new ReportDataSource("DataSet1", adoPrt); //this.reportViewer1.LocalReport.DataSources.Add(ds); this.reportViewer1.LocalReport.DataSources.Add(ds); ReportParameterCollection rptParams = new ReportParameterCollection(); rptParams.Add(new ReportParameter("p제목", adoPrt2.Rows[0]["CUST_NM"].ToString() + ".거래원장")); rptParams.Add(new ReportParameter("p검색기간", strDay1 + " ~ " + strDay2)); rptParams.Add(new ReportParameter("p담당사원", "담당사원 : " + adoPrt2.Rows[0]["CUST_MANAGER"].ToString())); rptParams.Add(new ReportParameter("p거래처명", adoPrt2.Rows[0]["CUST_NM"].ToString())); rptParams.Add(new ReportParameter("p거래처코드", adoPrt2.Rows[0]["CUST_CD"].ToString())); rptParams.Add(new ReportParameter("p거래처사업자번호", adoPrt2.Rows[0]["SAUP_NO"].ToString())); rptParams.Add(new ReportParameter("p거래처전화번호", adoPrt2.Rows[0]["CUST_COMP_PHONE"].ToString())); rptParams.Add(new ReportParameter("p거래처주소", adoPrt2.Rows[0]["ADDR"].ToString())); rptParams.Add(new ReportParameter("p거래처대표자명", adoPrt2.Rows[0]["OWNER"].ToString())); //rptParams.Add(new ReportParameter("p제목", "발주현황표")); this.reportViewer1.LocalReport.SetParameters(rptParams); } ReportPageSettings rpg = reportViewer1.LocalReport.GetDefaultPageSettings(); System.Drawing.Printing.PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.PaperSize = rpg.PaperSize; pg.Margins = rpg.Margins; pg.Landscape = true; // false = 세로, true = 가로 var setup = reportViewer1.GetPageSettings(); setup.PaperSize.Width = 1600; setup.PaperSize.Height = 1200; setup.Landscape = false; setup.Margins.Left = 27; reportViewer1.SetPageSettings(pg);//pg this.reportViewer1.RefreshReport(); this.reportViewer1.SetDisplayMode(DisplayMode.PrintLayout); this.reportViewer1.ZoomMode = ZoomMode.PageWidth; } catch (Exception e) { wnLog.writeLog(wnLog.LOG_ERROR, e.Message + " - " + e.ToString()); MessageBox.Show("시스템에 문제가 있습니다."); MessageBox.Show(e.Message + " - " + e.ToString()); this.Hide(); } }
public void prt_원장현황(DataTable dt, DataGridView dgv, string sDay1, string sDay2, string sCondition, string title) { lblMsg.Visible = true; Application.DoEvents(); try { DataTable adoPrt = GetDataTableFromDGV(dgv); if (adoPrt != null && adoPrt.Rows.Count > 0) { adoPrt.Columns.Add("제품코드"); adoPrt.Columns["PRODUCT_NM"].ColumnName = "제품명"; adoPrt.Columns.Add("원부재료코드"); adoPrt.Columns["LABEL_NM"].ColumnName = "원부재료명"; adoPrt.Columns.Add("규격"); adoPrt.Columns.Add("단위코드"); adoPrt.Columns["UNIT_NM"].ColumnName = "단위명"; adoPrt.Columns["OUTPUT_LOT"].ColumnName = "제조번호"; adoPrt.Columns.Add("제조번호S"); adoPrt.Columns["INPUT_AMT"].ColumnName = "입고량"; adoPrt.Columns["OUTPUT_AMT"].ColumnName = "출고량"; adoPrt.Columns["BALSTOCK"].ColumnName = "HEATNO"; adoPrt.Columns["no"].ColumnName = "no"; adoPrt.Columns.Add("출고일자"); adoPrt.Columns.Add("바코드"); adoPrt.Columns.Add("투입량"); adoPrt.Columns.Add("거래처코드"); adoPrt.Columns.Add("거래처명"); adoPrt.Columns["INPUT_DATE"].ColumnName = "입고일자"; adoPrt.Columns["INPUT_CD"].ColumnName = "입고번호"; adoPrt.Columns["SEQ"].ColumnName = "입고순번"; adoPrt.Columns.Add("구분코드"); adoPrt.Columns["INPUT_GUBUN"].ColumnName = "구분명"; adoPrt.Columns.Add("수량"); adoPrt.Columns.Add("금액"); adoPrt.Columns["CHUGJONG_NM"].ColumnName = "축종"; adoPrt.Columns["CLASS_NM"].ColumnName = "부위"; adoPrt.Columns.Add("등급"); adoPrt.Columns["COUNTRY_NM"].ColumnName = "원산지"; adoPrt.Columns.Add("유형"); adoPrt.Columns["FROZEN_GUBUN"].ColumnName = "보관구분"; adoPrt.Columns["UNION_CD"].ColumnName = "개체번호"; for (int i = 0; i < adoPrt.Rows.Count; i++) { adoPrt.Rows[i]["제품코드"] = "0"; adoPrt.Rows[i]["원부재료코드"] = "0"; adoPrt.Rows[i]["규격"] = "0"; adoPrt.Rows[i]["단위코드"] = "0"; adoPrt.Rows[i]["출고일자"] = "0"; adoPrt.Rows[i]["바코드"] = "0"; adoPrt.Rows[i]["투입량"] = "0"; adoPrt.Rows[i]["거래처코드"] = "0"; adoPrt.Rows[i]["거래처명"] = "0"; adoPrt.Rows[i]["구분코드"] = "0"; adoPrt.Rows[i]["수량"] = "0"; adoPrt.Rows[i]["금액"] = "0"; adoPrt.Rows[i]["등급"] = "0"; adoPrt.Rows[i]["유형"] = "0"; } } if (adoPrt != null && adoPrt.Rows.Count > 0) { string TitleTemp = sCondition; if (title != null && !title.Equals("")) { TitleTemp = title + "." + TitleTemp; } if (sCondition == "원자재원장현황") { this.reportViewer1.Reset(); this.reportViewer1.LocalReport.DisplayName = "원자재원장현황"; this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + "\\Reports\\rpt원장현황.rdlc"; ReportDataSource ds = new ReportDataSource("DataSet1", adoPrt); this.reportViewer1.LocalReport.DataSources.Add(ds); ReportParameterCollection rptParams = new ReportParameterCollection(); rptParams.Add(new ReportParameter("p제목", TitleTemp)); //rptParams.Add(new ReportParameter("p견적구분", "아래와 같이 견적합니다.")); rptParams.Add(new ReportParameter("p검색조건", "검색일자 : " + sDay1 + " ~ " + sDay2)); this.reportViewer1.LocalReport.SetParameters(rptParams); } else if (sCondition == "제품원장현황") { this.reportViewer1.Reset(); this.reportViewer1.LocalReport.DisplayName = "제품원장현황"; this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + "\\Reports\\rpt원장현황.rdlc"; ReportDataSource ds = new ReportDataSource("DataSet1", adoPrt); this.reportViewer1.LocalReport.DataSources.Add(ds); ReportParameterCollection rptParams = new ReportParameterCollection(); rptParams.Add(new ReportParameter("p제목", TitleTemp)); //rptParams.Add(new ReportParameter("p견적구분", "아래와 같이 견적합니다.")); rptParams.Add(new ReportParameter("p검색조건", "검색일자 : " + sDay1 + " ~ " + sDay2)); this.reportViewer1.LocalReport.SetParameters(rptParams); } ReportPageSettings rpg = reportViewer1.LocalReport.GetDefaultPageSettings(); System.Drawing.Printing.PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.PaperSize = rpg.PaperSize; pg.Margins = rpg.Margins; pg.Landscape = true; // false = 세로, true = 가로 //var setup = reportViewer1.GetPageSettings(); //setup.PaperSize.Width = 1600; //setup.PaperSize.Height = 1200; //setup.Landscape = false; //setup.Margins.Left = 200; reportViewer1.SetPageSettings(pg);//pg this.reportViewer1.RefreshReport(); this.reportViewer1.SetDisplayMode(DisplayMode.PrintLayout); this.reportViewer1.ZoomMode = ZoomMode.PageWidth; } } catch (Exception ex) { wnLog.writeLog(wnLog.LOG_ERROR, ex.Message + " - " + ex.ToString()); MessageBox.Show("시스템에 문제가 있습니다."); this.Hide(); } lblMsg.Visible = false; }
/// <summary> /// Print Report to specificed printer. /// </summary> /// <param name="rptViewer">The instance of Report Viewer Control.</param> /// <param name="printerName">The target printer name.</param> /// <param name="fromPage">-1 for print all</param> /// <param name="toPage">-1 for print all</param> /// <param name="noOfCopies">The Number of Copies.</param> /// <returns>Returns instance of RdlcPrintResult.</returns> public static RdlcPrintResult PrintTo(this ReportViewer rptViewer, string printerName, int fromPage = -1, int toPage = -1, short noOfCopies = 1) { RdlcPrintResult result = new RdlcPrintResult(); result.Success = false; if (string.IsNullOrWhiteSpace(printerName)) { result.Message = "No printer selected."; RdlcMessageService.Instance.SendMessage(result.Message); return(result); } if (null == rptViewer.LocalReport || null == rptViewer.LocalReport.DataSources || rptViewer.LocalReport.DataSources.Count <= 0) { result.Message = "Report is not loaded or report has no data."; RdlcMessageService.Instance.SendMessage(result.Message); return(result); } LocalReportRenderer prt = null; try { LocalReport lr = rptViewer.LocalReport; ReportPageSettings settings = lr.GetDefaultPageSettings(); if (null == settings) { result.Message = "Cannot get page settings."; RdlcMessageService.Instance.SendMessage(result.Message); return(result); } #region Assign page setting LocalReportPageSettings pageSettings = new LocalReportPageSettings(); if (!settings.IsLandscape) { pageSettings.PageHeight = Convert.ToDouble( (double)settings.PaperSize.Height / (double)100); pageSettings.PageWidth = Convert.ToDouble( (double)settings.PaperSize.Width / (double)100); } else { pageSettings.PageHeight = Convert.ToDouble( (double)settings.PaperSize.Width / (double)100); pageSettings.PageWidth = Convert.ToDouble( (double)settings.PaperSize.Height / (double)100); } pageSettings.MarginLeft = Convert.ToDouble( (double)settings.Margins.Left / (double)100); pageSettings.MarginRight = Convert.ToDouble( (double)settings.Margins.Right / (double)100); pageSettings.MarginTop = Convert.ToDouble( (double)settings.Margins.Top / (double)100); pageSettings.MarginBottom = Convert.ToDouble( (double)settings.Margins.Bottom / (double)100); //pageSettings.MarginLeft = 0; //pageSettings.MarginRight = 0; //pageSettings.MarginTop = 0; //pageSettings.MarginBottom = 0; pageSettings.Landscape = settings.IsLandscape; pageSettings.FromPage = fromPage; pageSettings.ToPage = toPage; #if WYSIWYG // Read Screen Resolution int dx, dy; System.Drawing.Graphics g = rptViewer.CreateGraphics(); try { dx = Convert.ToInt32(g.DpiX); dy = Convert.ToInt32(g.DpiY); } finally { g.Dispose(); } pageSettings.DpiX = dx; pageSettings.DpiY = dy; // Create dialog and re read resolution. System.Windows.Forms.PrintDialog pd = new System.Windows.Forms.PrintDialog(); pd.PrinterSettings.PrinterName = printerName; System.Drawing.Printing.PrinterSettings ps = pd.PrinterSettings; pageSettings.PrintDpiX = ps.DefaultPageSettings.PrinterResolution.X; pageSettings.PrintDpiY = ps.DefaultPageSettings.PrinterResolution.Y; #endif #endregion prt = new LocalReportRenderer(); prt.Print(lr, printerName, pageSettings, noOfCopies); result.Success = true; result.Message = "Print Success."; RdlcMessageService.Instance.SendMessage(result.Message); } catch (Exception ex) { result.Message = ex.ToString(); } finally { if (null != prt) { prt.Dispose(); } prt = null; } return(result); }
/// <summary> /// Print RDLC File /// </summary> /// <returns></returns> public bool Print() { this.pageIndex = 0; this.pageStreams.Clear(); ReportPageSettings rps = this.localReport.GetDefaultPageSettings(); float pageWidth = 0f; float pageHeight = 0f; float marginTop = rps.Margins.Top / 100f; float marginLeft = rps.Margins.Left / 100f; float marginRight = rps.Margins.Right / 100f; float marginBottom = rps.Margins.Bottom / 100f; bool landscape = false; if (rps.PaperSize.Width > rps.PaperSize.Height) { pageWidth = rps.PaperSize.Width / 100f; pageHeight = rps.PaperSize.Height / 100f; landscape = false; } else { pageWidth = rps.PaperSize.Height / 100f; pageHeight = rps.PaperSize.Width / 100f; landscape = true; } string ImageDeviceInfo = string.Format(@"<DeviceInfo> <OutputFormat>EMF</OutputFormat> <PageWidth>{0}in</PageWidth> <PageHeight>{1}in</PageHeight> <MarginTop>{2}in</MarginTop> <MarginLeft>{3}in</MarginLeft> <MarginRight>{4}in</MarginRight> <MarginBottom>{5}in</MarginBottom> </DeviceInfo>", pageWidth, pageHeight, marginTop, marginLeft, marginRight, marginBottom); Warning[] warnings = null; try { this.localReport.Render("Image", ImageDeviceInfo, CreatePrintPageStream, out warnings); } catch (Exception ex) { MessageBox.Show(ex.Message); } if (warnings != null && warnings.Length > 0) { string warnMsg = string.Empty; foreach (Warning warning in warnings) { warnMsg += string.Format("WarningCode: {0} WarningMessage: {1}\r\n", warning.Code, warning.Message); } throw new Exception(warnMsg); } if (this.pageStreams == null || this.pageStreams.Count == 0) { return(false); } try { PageSetupDialog psd = new PageSetupDialog(); PrinterSettings printset = new PrinterSettings(); XmlDocument doc = new XmlDocument(); string xmlFile = AppDomain.CurrentDomain.BaseDirectory + "BugsBox.Pharmacy.AppClient.printSet.xml"; doc.Load(xmlFile); string s = System.Environment.CurrentDirectory; XmlNodeList nodelist = doc.SelectNodes("/printsets/pageset"); int wt = Convert.ToInt16(nodelist[0].Attributes["width"].Value); int ht = Convert.ToInt16(nodelist[1].Attributes["height"].Value); PaperSize pse = new PaperSize("Custom", wt, ht); PageSettings pageset = new PageSettings(); int Bottom = Convert.ToInt16(nodelist[2].Attributes["top"].Value); int Top = Convert.ToInt16(nodelist[3].Attributes["left"].Value); int Left = Convert.ToInt16(nodelist[4].Attributes["right"].Value); int Right = Convert.ToInt16(nodelist[5].Attributes["bottom"].Value); Margins margin = new Margins(Left, Right, Top, Bottom); pageset.Margins = margin; pageset.PaperSize = pse; printset.DefaultPageSettings.PaperSize = pse; psd.PrinterSettings = printset; psd.PageSettings = pageset; psd.PageSettings.PaperSize = pse; this.printDocument.PrinterSettings = psd.PrinterSettings; this.printPreview.Document = this.printDocument; this.printPreview.ShowDialog(); //使用image输出到文件后,可能会改变应用程序默认路径,所以。。。。。。。。 if (System.Environment.CurrentDirectory != s) { System.Environment.CurrentDirectory = s; } } catch (Exception ex) { MessageBox.Show("打印配置文件丢失,请检查!\n" + ex.Message); } return(true); }
/// <summary> /// Load Report. /// </summary> /// <param name="rptViewer">The instance of Report Viewer Control.</param> /// <param name="reportSource">The instance of RdlcReportModel.</param> public static void LoadReport(this ReportViewer rptViewer, RdlcReportModel reportSource) { RdlcMessageService.Instance.SendMessage("Begin Load Report."); rptViewer.ProcessingMode = ProcessingMode.Local; LocalReport lr = rptViewer.LocalReport; if (null != reportSource && null != reportSource.Definition && null != reportSource.Definition.RdlcInstance && null != reportSource.DataSources) { RdlcMessageService.Instance.SendMessage("Begin Load Report Definition."); // Load Rdlc file lr.LoadReportDefinition(reportSource.Definition.RdlcInstance); RdlcMessageService.Instance.SendMessage("Clear Report Data source."); // Clear all datasource before assign new one. lr.DataSources.Clear(); if (reportSource.DataSources.Count > 0) { // Set all data source. foreach (var dataSource in reportSource.DataSources) { if (null == dataSource.Items) { continue; } RdlcMessageService.Instance .SendMessage("Add New Report Data source - " + dataSource.Name); lr.DataSources.Add(new ReportDataSource( dataSource.Name, dataSource.Items)); } } else { RdlcMessageService.Instance .SendMessage("No New Report Data source."); } if (lr.DataSources.Count > 0 && null != reportSource.Parameters && reportSource.Parameters.Count > 0) { foreach (RdlcReportParameter para in reportSource.Parameters) { if (null == para || string.IsNullOrWhiteSpace(para.Name)) { continue; } try { RdlcMessageService.Instance .SendMessage("Set Report parameter - " + para.Name); lr.SetValue(para.Name, para.Value); } catch (Exception) { } } } else { RdlcMessageService.Instance .SendMessage("No Report parameter assigned."); } if (lr.DataSources.Count > 0) { RdlcMessageService.Instance .SendMessage("Set Report Page setting from Printer page setting."); // Read Setting and set to report viewer ReportPageSettings rdlcPageSettings = lr.GetDefaultPageSettings(); System.Drawing.Printing.PageSettings pageSettings = new System.Drawing.Printing.PageSettings(); pageSettings.PaperSize = rdlcPageSettings.PaperSize; pageSettings.Landscape = rdlcPageSettings.IsLandscape; pageSettings.Margins = rdlcPageSettings.Margins; rptViewer.SetPageSettings(pageSettings); // refresh rptViewer.LocalReport.Refresh(); } else { RdlcMessageService.Instance .SendMessage("No Report data source so cannot set report page setting."); } } rptViewer.RefreshReport(); // Set display mode to print layout. rptViewer.SetDisplayMode(DisplayMode.PrintLayout); if (null != reportSource && null != reportSource.Definition && null != reportSource.Definition.RdlcInstance) { try { reportSource.Definition.Dispose(); } catch { } } }