private void exportPDF(string ID = null) { reportItem.PaperKind = System.Drawing.Printing.PaperKind.Letter; reportItem.Margins.Bottom = 0; reportItem.PrintingSystem.ShowPrintStatusDialog = false; reportItem.PrintingSystem.ShowMarginsWarning = false; using (var printTool = new DevExpress.XtraReports.UI.ReportPrintTool(reportItem)) { printTool.Report.CreateDocument(false); // <- ADD THIS LINE printTool.PrintingSystem.ExportToPdf(Application.StartupPath + "\\Report\\" + id.ToString() + "_Export.pdf"); } }
public override bool PerformPrintPreview() { Current_Id_Checkin = cvBar_Rent_CheckIn.GetFocusedRowCellValue("Id_Checkin"); if (Current_Id_Checkin == null) { GoobizFrame.Windows.Forms.UserMessage.Show("SYS_EMPTY_COLLECTION", new string[] { "danh sách đặt phòng" }); return(false); } if ("" + lookUpEdit_RentLevel.EditValue == "") { GoobizFrame.Windows.Forms.UserMessage.Show("SYS_EMPTY_COLLECTION", new string[] { labelControl19.Text }); return(false); } dsbar_Rent_Checkin = objBarService.GetBar_Rent_Checkin_ById4Print(Current_Id_Checkin, lookUpEdit_RentLevel.EditValue, DateTime.Now).ToDataSet(); Ecm.Bar.DataSets.dsHdbanhang_Chitiet dsrHdbanhang_Chitiet = new Ecm.Bar.DataSets.dsHdbanhang_Chitiet(); Ecm.Bar.Reports.rptHdbanhang_Hotel rptHdbanhang = new Ecm.Bar.Reports.rptHdbanhang_Hotel(); GoobizFrame.Windows.Forms.FrmPrintPreview frmPrintPreview = new GoobizFrame.Windows.Forms.FrmPrintPreview(); frmPrintPreview.Report = rptHdbanhang; int i = 1; foreach (DataRow dr in dsbar_Rent_Checkin.Tables[0].Rows) { if (dr.RowState != DataRowState.Deleted) { DataRow drnew = dsrHdbanhang_Chitiet.Tables[0].NewRow(); foreach (DataColumn dc in dsbar_Rent_Checkin.Tables[0].Columns) { try { if (drnew.Table.Columns.Contains(dc.ColumnName)) { drnew[dc.ColumnName] = dr[dc.ColumnName]; } } catch (Exception ex) { GoobizFrame.Windows.TrayMessage.TrayMessage.Status = new GoobizFrame.Windows.TrayMessage.TrayMessageInfo(MessageBoxIcon.Asterisk, ex.Message, ex.ToString()); continue; } } drnew["Ten_Hanghoa"] = dr["Ten_Hanghoa"]; // gridLookUp_Hanghoa_Ban_Chitiet.GetDisplayText(dr["Id_Hanghoa_Ban"]); drnew["Dongia_Ban"] = dr["Dongia"]; drnew["Thanhtien"] = dr["Thanhtien"]; drnew["per_dongia"] = dr["Per_Dongia"]; drnew["Stt"] = i++; dsrHdbanhang_Chitiet.Tables[0].Rows.Add(drnew); } } //add parameter values rptHdbanhang.tbc_Ngay.Text = "" + dtNgay_Chungtu.Text; rptHdbanhang.tbcSochungtu.Text = "" + txtSo_Chungtu.Text; rptHdbanhang.lblNhansu_Bill.Text = lookUpEdit_Nhansu_Ctu.Text; rptHdbanhang.lblKhachhang.Text = lookUpEdit_Khachhang.Text; DataSet dsOrder_Chitiet; decimal thanhtien_order = 0; foreach (DataRow row in dsrHdbanhang_Chitiet.Tables["Hdbanhang_Chitiet"].Rows) { dsOrder_Chitiet = objBarService.Get_Bar_Rent_Checkin_table_Hanghoa_By_Checkin_Table_4Print(row["Id_Bar_Rent_Checkin_Table"]).ToDataSet(); foreach (DataRow dtr in dsOrder_Chitiet.Tables[0].Rows) { dsrHdbanhang_Chitiet.Tables["Order_Chitiet"].ImportRow(dtr); } thanhtien_order += Convert.ToDecimal("0" + dsOrder_Chitiet.Tables[0].Compute("Sum(Thanhtien)", "")); } decimal thanhtien = Convert.ToDecimal("0" + dsbar_Rent_Checkin.Tables[0].Compute("Sum(thanhtien)", "")); thanhtien += thanhtien_order; var da_thanhtoan = objBarService.Get_Bar_Rent_Checkin_Dathanhtoan_ById_Checkin(Current_Id_Checkin); thanhtien -= Convert.ToDecimal("0" + da_thanhtoan); rptHdbanhang.PageSize = new Size(800, 1400 + 100 * Convert.ToInt32(dsrHdbanhang_Chitiet.Tables[0].Rows.Count)); //Trừ tiền cọc if (Convert.ToDecimal("0" + da_thanhtoan) > 0) { decimal Thanhtien_TG = Convert.ToDecimal("0" + dsrHdbanhang_Chitiet.Tables[0].Rows[dsrHdbanhang_Chitiet.Tables[0].Rows.Count - 1]["Thanhtien_TG"]); Thanhtien_TG -= Convert.ToDecimal(da_thanhtoan); dsrHdbanhang_Chitiet.Tables[0].Rows[dsrHdbanhang_Chitiet.Tables[0].Rows.Count - 1]["Thanhtien_TG"] = Thanhtien_TG; rptHdbanhang.xrTable_Tien_Booking.Visible = true; rptHdbanhang.lblTien_Booking.Text = string.Format("{0:#,#}", da_thanhtoan); } else { rptHdbanhang.xrTable6.Location = new System.Drawing.Point(21, 42); rptHdbanhang.xrTable4.Location = new System.Drawing.Point(21, 135); } decimal thanhtien_order_per_room = 0; foreach (DataRow row in dsrHdbanhang_Chitiet.Tables["Hdbanhang_Chitiet"].Rows) { thanhtien_order_per_room = Convert.ToDecimal("0" + dsrHdbanhang_Chitiet.Tables["Order_Chitiet"].Compute("Sum(Thanhtien)", "Id_Bar_Rent_Checkin_Table = " + row["Id_Bar_Rent_Checkin_Table"])); row["Total_Per_Room"] = Convert.ToDecimal("0" + row["Thanhtien"]) + thanhtien_order_per_room; } rptHdbanhang.DataSource = dsrHdbanhang_Chitiet; #region Set he so ctrinh - logo, ten cty using (DataSet dsHeso_Chuongtrinh = objMasterService.Get_Rex_Dm_Heso_Chuongtrinh_Collection3().ToDataSet()) { DataSet dsCompany_Paras = new DataSet(); dsCompany_Paras.Tables.Add("Company_Paras"); dsCompany_Paras.Tables[0].Columns.Add("CompanyName", typeof(string)); dsCompany_Paras.Tables[0].Columns.Add("CompanyAddress", typeof(string)); dsCompany_Paras.Tables[0].Columns.Add("CompanyLogo", typeof(byte[])); byte[] imageData = Convert.FromBase64String("" + dsHeso_Chuongtrinh.Tables[0].Select(string.Format("Ma_Heso_Chuongtrinh='{0}'", "CompanyLogo"))[0]["Heso"]); dsCompany_Paras.Tables[0].Rows.Add(new object[] { dsHeso_Chuongtrinh.Tables[0].Select(string.Format("Ma_Heso_Chuongtrinh='{0}'", "CompanyName"))[0]["Heso"] , dsHeso_Chuongtrinh.Tables[0].Select(string.Format("Ma_Heso_Chuongtrinh='{0}'", "CompanyAddress"))[0]["Heso"] , imageData }); rptHdbanhang.xrc_CompanyName.DataBindings.Add( new DevExpress.XtraReports.UI.XRBinding("Text", dsCompany_Paras, dsCompany_Paras.Tables[0].TableName + ".CompanyName")); rptHdbanhang.xrc_CompanyAddress.DataBindings.Add( new DevExpress.XtraReports.UI.XRBinding("Text", dsCompany_Paras, dsCompany_Paras.Tables[0].TableName + ".CompanyAddress")); rptHdbanhang.xrPic_Logo.DataBindings.Add( new DevExpress.XtraReports.UI.XRBinding("Image", dsCompany_Paras, dsCompany_Paras.Tables[0].TableName + ".CompanyLogo")); } #endregion rptHdbanhang.lblTongcong.Text = String.Format("{0:n0}", Convert.ToDouble(thanhtien)); string str = GoobizFrame.Windows.HelperClasses.ReadNumber.ChangeNum2VNStr((double)thanhtien, " đồng."); str = str.Substring(0, 1).ToUpper() + str.Substring(1).ToLower(); rptHdbanhang.tbcThanhtien_Bangchu.Text = str; rptHdbanhang.tbc_Ngay_Batdau.Text = dtNgay_Batdau.Text; rptHdbanhang.tbc_Ngay_Ketthuc.Text = dtNgay_Ketthuc.Text; if (Convert.ToDecimal("" + dsbar_Rent_Checkin.Tables[0].Rows[0]["Per_Dongia"]) == 0) { rptHdbanhang.xrTableRow_Giamgia.Visible = false; //xrTable5 } rptHdbanhang.CreateDocument(); GoobizFrame.Windows.Forms.ReportOptions oReportOptions = GoobizFrame.Windows.Forms.ReportOptions.GetReportOptions(rptHdbanhang); if (Convert.ToBoolean(oReportOptions.PrintPreview)) { frmPrintPreview.Text = "" + oReportOptions.Caption; frmPrintPreview.printControl1.PrintingSystem = rptHdbanhang.PrintingSystem; frmPrintPreview.MdiParent = this.MdiParent; frmPrintPreview.Text = this.Text + "(Xem trang in)"; frmPrintPreview.Show(); frmPrintPreview.Activate(); } else { var ReportPrintTool = new DevExpress.XtraReports.UI.ReportPrintTool(rptHdbanhang); ReportPrintTool.Print(); } return(base.PerformPrintPreview()); }
void SetPrintToolsVisible(XtraReport rpt) { DevExpress.XtraReports.UI.ReportPrintTool mRptPrintTool = new DevExpress.XtraReports.UI.ReportPrintTool(rpt);//这条语句少了。 DevExpress.XtraPrinting.PrintingSystemBase mPSB = mRptPrintTool.PrintingSystem; mPSB.SetCommandVisibility(new DevExpress.XtraPrinting.PrintingSystemCommand[] { DevExpress.XtraPrinting.PrintingSystemCommand.Background , DevExpress.XtraPrinting.PrintingSystemCommand.ClosePreview , DevExpress.XtraPrinting.PrintingSystemCommand.Customize , DevExpress.XtraPrinting.PrintingSystemCommand.DocumentMap , DevExpress.XtraPrinting.PrintingSystemCommand.File , DevExpress.XtraPrinting.PrintingSystemCommand.FillBackground , DevExpress.XtraPrinting.PrintingSystemCommand.Open , DevExpress.XtraPrinting.PrintingSystemCommand.PageSetup , DevExpress.XtraPrinting.PrintingSystemCommand.Print , DevExpress.XtraPrinting.PrintingSystemCommand.PrintDirect , DevExpress.XtraPrinting.PrintingSystemCommand.Save, DevExpress.XtraPrinting.PrintingSystemCommand.Watermark, DevExpress.XtraPrinting.PrintingSystemCommand.ExportCsv, DevExpress.XtraPrinting.PrintingSystemCommand.ExportFile, DevExpress.XtraPrinting.PrintingSystemCommand.ExportGraphic, DevExpress.XtraPrinting.PrintingSystemCommand.ExportHtm, DevExpress.XtraPrinting.PrintingSystemCommand.ExportMht, DevExpress.XtraPrinting.PrintingSystemCommand.ExportPdf, DevExpress.XtraPrinting.PrintingSystemCommand.ExportRtf, DevExpress.XtraPrinting.PrintingSystemCommand.ExportTxt, DevExpress.XtraPrinting.PrintingSystemCommand.ExportXls, DevExpress.XtraPrinting.PrintingSystemCommand.ExportXlsx, DevExpress.XtraPrinting.PrintingSystemCommand.ExportXps, DevExpress.XtraPrinting.PrintingSystemCommand.SendCsv, DevExpress.XtraPrinting.PrintingSystemCommand.SendFile, DevExpress.XtraPrinting.PrintingSystemCommand.SendGraphic, DevExpress.XtraPrinting.PrintingSystemCommand.SendMht, DevExpress.XtraPrinting.PrintingSystemCommand.SendPdf, DevExpress.XtraPrinting.PrintingSystemCommand.SendRtf, DevExpress.XtraPrinting.PrintingSystemCommand.SendTxt, DevExpress.XtraPrinting.PrintingSystemCommand.SendXls, DevExpress.XtraPrinting.PrintingSystemCommand.SendXlsx, DevExpress.XtraPrinting.PrintingSystemCommand.SendXps, DevExpress.XtraPrinting.PrintingSystemCommand.SubmitParameters }, DevExpress.XtraPrinting.CommandVisibility.None); }