private byte[] InternalGenerateReport(string reportFile, Dictionary <string, string> parameters) { FastReport.Report report = new FastReport.Report(); report.Load(Path.Combine("Reports", reportFile)); if (string.IsNullOrWhiteSpace(_appSettings.ConnectionString)) { throw new NotSupportedException("Connectionstring não informada"); } report.Dictionary.Connections[0].ConnectionString = _appSettings.ConnectionString; //report.SetParameterValue("initialDate", "2019-01-01"); //report.SetParameterValue("finalDate", "2019-01-07"); foreach (var parameter in parameters) { report.SetParameterValue(parameter.Key, parameter.Value); } report.Prepare(); // report.Parameters[0].Value = 143; //report.Refresh(); PDFSimpleExport export = new PDFSimpleExport(); using (MemoryStream ms = new MemoryStream()) { report.Export(export, ms); ms.Flush(); return(ms.ToArray()); } }
public ActionResult getReport(string from, string to, string prod) { string lang = Session["T_LANG"].ToString(); DataTable dt = repository.getReport(lang, from, to, prod); dt.TableName = "R12016"; //dt.WriteXmlSchema(Server.MapPath("~/Report/xml/R12016.xml")); //return View(); using (var Report = new FastReport.Report()) { Report.Report.Load(Server.MapPath("~/Report/Report/R12016.frx")); Report.Report.RegisterData(dt, "R12016"); Report.Report.Prepare(); using (var strm = new MemoryStream()) { var pdfExport = new PDFExport(); Report.Export(pdfExport, strm); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(strm.ToArray()); Response.End(); } ViewBag.WebReport = Report; } return(View()); }
public static void GenereteReport(ReportParams reportParams) { if (reportParams == null) { throw new ArgumentNullException($"{nameof(reportParams)} cannot be null."); } // create report instance using (FastReport.Report report = new FastReport.Report()) { // load the existing report report.Load(reportParams.FrxPath); // register datasource's if (reportParams.DataSource != null) { foreach (var pair in reportParams.DataSource) { report.RegisterData(pair.Value, pair.Key); } } if (reportParams.Parameters != null) { foreach (var pair in reportParams.Parameters) { report.SetParameterValue(pair.Key, pair.Value); } } // prepare the report report.Prepare(); ExportBase export = null; switch (reportParams.OutputType) { case 0: // export to html export = new HTMLExport(); (export as HTMLExport).Format = HTMLExportFormat.HTML; break; case 1: export = new ImageExport(); (export as ImageExport).ImageFormat = ImageExportFormat.Png; break; default: throw new ArgumentException($"O parametro {reportParams.OutputType} é inválido"); } report.Export(export, reportParams.OutStream); } reportParams.OutStream.Position = 0; }
//getDate public ActionResult getReport(string fromDate, string toDate) { var site = Session["T_SITE_CODE"].ToString(); string lang = Session["T_LANG"].ToString(); DataTable dtInfor = repository.GetInforData(site, lang); DataTable dtDetails = repository.GetDetails(site, fromDate, toDate); //DataTable dtUnitInfo = repository.GetR12215CollectedUnit(site, entryDate); dtInfor.TableName = "R12260Infor"; dtDetails.TableName = "R12260Details"; // dtUnitInfo.TableName = "R12215UnitInfo"; DataSet dSet = new DataSet(); dSet.Tables.Add(dtInfor); dSet.Tables.Add(dtDetails); // dSet.Tables.Add(dtUnitInfo); // dSet.WriteXmlSchema(Server.MapPath("~/Report/xml/R12260.xml")); // return View(); using (var webReport = new FastReport.Report()) { webReport.Report.Load(Server.MapPath("~/Report/Report/R12260.frx")); //webReport.Report.Load(Server.MapPath("~/Report/Report/R12260_Test.frx")); webReport.RegisterData(dtInfor, "R12260Infor"); webReport.RegisterData(dtDetails, "R12260Details"); webReport.Report.SetParameterValue("FromDate", fromDate); webReport.Report.SetParameterValue("ToDate", toDate); // webReport.RegisterData(dtUnitInfo, "R12215UnitInfo"); webReport.Report.Prepare(); using (var report = new MemoryStream()) { var pdfExport = new PDFExport(); webReport.Export(pdfExport, report); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(report.ToArray()); Response.End(); } ViewBag.ReportR12215 = webReport; } return(View()); }
public ActionResult getR12065_Report(string patno) { // string siteCode = Session["T_SITE_CODE"].ToString(); DataTable dt = repository.getR12065_Report(patno); dt.TableName = "R12065"; //dt_1.TableName = "R12302_xmatchHistory"; //T12302_Site_.TableName = "R12302_Site"; // DataSet ds = new DataSet(); // ds.Tables.Add(dt); // ds.Tables.Add(dt_1); //ds.Tables.Add(T12302_Site_); //foreach (DataTable V in dt.Rows) //{ //} //----------- for barcode start----------------- dt.Columns.Add("Pat_BarCode", typeof(Bitmap)); Image myimg = Code128Rendering.MakeBarcodeImage(dt.Rows[0]["T_UNIT_NO"].ToString(), int.Parse("2"), true); dt.Rows[0]["Pat_BarCode"] = myimg; //----------- for barcode end----------------- //dt.WriteXmlSchema(Server.MapPath("~/Report/xml/R12065.xml")); // return View(); using (var Report = new FastReport.Report()) { Report.Report.Load(Server.MapPath("~/Report/Report/R12065.frx")); System.Data.DataSet dataSet = new System.Data.DataSet(); Report.Report.RegisterData(dt, "R12065"); //Report.Report.RegisterData(dt_1, "R12302_xmatchHistory"); // Report.Report.RegisterData(T12302_Site_, "R12302_Site"); Report.Report.Prepare(); using (var strm = new MemoryStream()) { var pdfExport = new PDFExport(); Report.Export(pdfExport, strm); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(strm.ToArray()); Response.End(); } ViewBag.WebReport = Report; } return(View()); }
public ActionResult UNIT_Report_R12219(string entryDate) { int site = Convert.ToInt32(Session["T_SITE_CODE"].ToString()); string lang = Session["T_LANG"].ToString(); DataTable dtSite = repository_R12215.GetR12215SiteCode(site, lang); DataTable dtSummery = repository_R12215.GetR12215Summery(entryDate, site, entryDate); DataTable dtUnitInfo = repository_R12215.GetR12215CollectedUnit(site, entryDate); dtSite.TableName = "R12215Site"; dtSummery.TableName = "R12215Summery"; dtUnitInfo.TableName = "R12215UnitInfo"; DataSet dSet = new DataSet(); dSet.Tables.Add(dtSite); dSet.Tables.Add(dtSummery); dSet.Tables.Add(dtUnitInfo); //dSet.WriteXmlSchema(Server.MapPath("~/Report/xml/R12215.xml")); using (var webReport = new FastReport.Report()) { webReport.Report.Load(Server.MapPath("~/Report/Report/R12215.frx")); webReport.RegisterData(dtSite, "R12215Site"); webReport.RegisterData(dtSummery, "R12215Summery"); webReport.RegisterData(dtUnitInfo, "R12215UnitInfo"); webReport.Report.Prepare(); using (var report = new MemoryStream()) { var pdfExport = new PDFExport(); webReport.Export(pdfExport, report); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(report.ToArray()); Response.End(); } ViewBag.ReportR12215 = webReport; } return(View()); }
//------------------------------------Report---------------------------- public ActionResult getR12046_Report(string reqno) { string site = Session["T_SITE_CODE"].ToString(); string lang = Session["T_LANG"].ToString(); DataTable dt_site = repository.GetSite(site); DataTable dt_xMatch = repository.getR12046_xMatch(reqno, site, lang); DataTable dt_issue = repository.getR12046_Issue(reqno, site, lang); dt_site.TableName = "R12046_Site"; dt_xMatch.TableName = "R12046"; dt_issue.TableName = "R12046i"; DataSet ds = new DataSet(); ds.Tables.Add(dt_site); ds.Tables.Add(dt_xMatch); ds.Tables.Add(dt_issue); //ds.WriteXmlSchema(Server.MapPath("~/Report/xml/R12046.xml")); using (var webReport = new FastReport.Report()) { webReport.Report.Load(Server.MapPath("~/Report/Report/R12046.frx")); webReport.Report.RegisterData(dt_site, "R12046_Site"); webReport.Report.RegisterData(dt_xMatch, "R12046"); webReport.Report.RegisterData(dt_issue, "R12046i"); webReport.Report.Prepare(); using (var Report = new MemoryStream()) { var pdfExport = new PDFExport(); webReport.Export(pdfExport, Report); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(Report.ToArray()); Response.End(); } ViewBag.WebReport = webReport; } return(View()); }
public ActionResult GetReport(string donTiFrom, string donTiTo, string siteCode, string bloodGrp, string product) { var dtT12025 = repository.GetReport(Session["T_LANG"].ToString(), donTiFrom, donTiTo, siteCode, bloodGrp, product); dtT12025.TableName = "T12025"; //----------- for barcode start----------------- // dtT12025.Columns.Add("Pat_BarCode", typeof(Bitmap)); // Image myimg = Code128Rendering.MakeBarcodeImage(dtT12204.Rows[0]["T_BAG_BARCODE"].ToString(), int.Parse("2"), true); // dtT12025.Rows[0]["Pat_BarCode"] = myimg; //----------- for barcode end----------------- // dtT12204.Columns.Add("Time", typeof(string)); //dtT12204.Rows[0]["Time"] = Session["Hou_Min"].ToString(); // dtT12025.WriteXmlSchema(Server.MapPath("~/Report/xml/T12025.xml")); // return View(); using (var webReport = new FastReport.Report()) { webReport.Report.Load(Server.MapPath("~/Report/Report/R12025.frx")); System.Data.DataSet dataSet = new System.Data.DataSet(); webReport.Report.RegisterData(dtT12025, "T12025"); webReport.Report.Prepare(); using (var Report = new MemoryStream()) { // var excelExport = new Excel2007Export(); // webReport.Report.Export(excelExport, strm); // var pdfExport = new PDFExport(); // webReport.Report.Export(pdfExport, strm); // Response.ClearContent(); // Response.ClearHeaders(); // Response.Buffer = true; //// Response.ContentType = "Application/vnd.ms-excel"; // Response.ContentType = "Application/PDF"; // Response.BinaryWrite(strm.ToArray()); // Response.End(); var pdfExport = new PDFExport(); webReport.Export(pdfExport, Report); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(Report.ToArray()); Response.End(); } ViewBag.WebReport = webReport; } return(View()); }
public ActionResult TAT_Report_R12219(string dateFrom) { //string lang = Session["T_LANG"].ToString(); //dt.TableName = "R12006"; string site = Session["T_SITE_CODE"].ToString(); string lang = Session["T_LANG"].ToString(); //DataTable dt = repository.getReport(lang, patNo); DataTable dtReportInfo = repository.GetReportInfo(); DataTable dtReportData = repository.GetReportData(); dtReportInfo.TableName = "Table1"; dtReportData.TableName = "Table2"; DataSet ds = new DataSet(); ds.DataSetName = "R12219"; ds.Tables.Add(dtReportInfo); ds.Tables.Add(dtReportData); //ds.WriteXmlSchema(Server.MapPath("~/Report/xml/R12219.xml")); using (var webReport = new FastReport.Report()) { webReport.Report.Load(Server.MapPath("~/Report/Report/R12219.frx")); webReport.Report.RegisterData(dtReportInfo, "Table1"); webReport.Report.RegisterData(dtReportData, "Table2"); webReport.Report.Prepare(); using (var report = new MemoryStream()) { var pdfExport = new PDFExport(); webReport.Export(pdfExport, report); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(report.ToArray()); Response.End(); } ViewBag.WebReport = webReport; } return(View()); }
//getR12036A_Report public ActionResult getR12012_Report(string reqno) { string site = Session["T_SITE_CODE"].ToString(); string lang = Session["T_LANG"].ToString(); DataTable dt = repository.getR12012_Report(reqno, site, lang); DataTable dt_site = repository.GetSite(site); dt.TableName = "R12012"; dt_site.TableName = "R12012_site"; DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.Tables.Add(dt_site); //ds.WriteXmlSchema(Server.MapPath("~/Report/xml/R12012.xml")); using (var webReport = new FastReport.Report()) { webReport.Report.Load(Server.MapPath("~/Report/Report/R12012.frx")); webReport.Report.RegisterData(dt, "R12012"); webReport.Report.RegisterData(dt_site, "R12012_site"); var HijriDTFI = new CultureInfo("ar-SA", false).DateTimeFormat; HijriDTFI.Calendar = new HijriCalendar(); webReport.SetParameterValue("RequestDate_H", Convert.ToDateTime(dt.Rows[0]["T_REQUEST_DATE"].ToString()).ToString("dd/MM/yyyy", HijriDTFI)); webReport.Report.Prepare(); using (var Report = new MemoryStream()) { var pdfExport = new PDFExport(); webReport.Export(pdfExport, Report); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(Report.ToArray()); Response.End(); } ViewBag.WebReport = webReport; } return(View()); }
public ActionResult getReportxmatch(string patno) { string siteCode = Session["T_SITE_CODE"].ToString(); DataTable dt = repository.getPatInfo(patno); DataTable dt_1 = repository.geHistoryData(patno, siteCode); DataTable T12302_Site_ = repository.GetSite(siteCode); dt.TableName = "R12302_xmatchinfo"; dt_1.TableName = "R12302_xmatchHistory"; T12302_Site_.TableName = "R12302_Site"; DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.Tables.Add(dt_1); ds.Tables.Add(T12302_Site_); //ds.WriteXmlSchema(Server.MapPath("~/Report/xml/R12302xmatch.xml")); //return View(); using (var Report = new FastReport.Report()) { Report.Report.Load(Server.MapPath("~/Report/Report/R12049.frx")); Report.Report.RegisterData(dt, "R12302_xmatchinfo"); Report.Report.RegisterData(dt_1, "R12302_xmatchHistory"); Report.Report.RegisterData(T12302_Site_, "R12302_Site"); Report.Report.Prepare(); using (var strm = new MemoryStream()) { var pdfExport = new PDFExport(); Report.Export(pdfExport, strm); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(strm.ToArray()); Response.End(); } ViewBag.WebReport = Report; } return(View()); }
public static void Print(DataSet dsData, string frxPath, string path) { FastReport.Report report = new FastReport.Report(); report.RegisterData(dsData); using (FileStream fs = new FileStream(frxPath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite)) { report.Load(fs); } report.Prepare(); PDFExport export = new PDFExport(); export.SetReport(report); export.Compressed = true; export.Background = false; export.PrintOptimized = false; export.OpenAfterExport = false; export.EmbeddingFonts = true; report.Export(export, path); report.Dispose(); }
public ActionResult GRAPH_Report_R12219(string dateFrom) { //string lang = Session["T_LANG"].ToString(); //DataTable dt = repository.getReport(lang, nationalId); //dt.TableName = "R12006"; string site = Session["T_SITE_CODE"].ToString(); string lang = Session["T_LANG"].ToString(); //DataTable dt = repository.getReport(lang, patNo); //DataTable dtSite = repository.GetR12006Site(site); //DataTable dtProfile = repository.GetR12006PatProfile(lang, patNo); //DataTable dtAgreement = repository.GetR12006Agreement(lang, patNo); //DataTable dtConfirmation = repository.GetR12006Confirmation(lang); //dt.TableName = "R12006_Ques"; //dtSite.TableName = "R12006_Site"; //dtProfile.TableName = "R12006_Profile"; //dtAgreement.TableName = "R12006_Agreement"; ////dtConfirmation.TableName = "R12006_Confirmation"; //DataSet ds = new DataSet(); //ds.Tables.Add(dt); //ds.Tables.Add(dtSite); //ds.Tables.Add(dtProfile); //ds.Tables.Add(dtAgreement); ////ds.Tables.Add(dtConfirmation); ////ds.WriteXmlSchema(Server.MapPath("~/Report/xml/R12251A.xml")); using (var webReport = new FastReport.Report()) { webReport.Report.Load(Server.MapPath("~/Report/Report/R12219.frx")); //webReport.Report.RegisterData(dtSite, "R12006_Site"); //webReport.Report.RegisterData(dt, "R12006_Ques"); //webReport.Report.RegisterData(dtProfile, "R12006_Profile"); //webReport.Report.RegisterData(dtAgreement, "R12006_Agreement"); //webReport.Report.RegisterData(dtConfirmation, "R12006_Confirmation"); webReport.Report.Prepare(); using (var report = new MemoryStream()) { var pdfExport = new PDFExport(); webReport.Export(pdfExport, report); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(report.ToArray()); Response.End(); } ViewBag.WebReport = webReport; } return(View()); }
public static string GetReportString(string reportFilePath, string dataSetName, IEnumerable <object> data, string exportFormat) { FastReport.Report report = new FastReport.Report(); string result = string.Empty; if (FileHelper.IsExistFile(reportFilePath)) { try { report.Load(reportFilePath); // Download the report report.RegisterData(data, dataSetName); // Register data in the report } catch { //var log = LogFactory.GetLogger("FastReportHelper"); //log.Error(ex.Message); return(result); } using (MemoryStream stream = new MemoryStream()) { if (exportFormat.Equals("pdf", StringComparison.InvariantCultureIgnoreCase)) { //FastReport.Export.Pdf.PDFExport pdf = new FastReport.Export.Pdf.PDFExport { // Producer = "", // AllowPrint=true, // AllowModify=true, // PrintScaling=true, // RichTextQuality=100, // Compressed=false //}; //report.Export(pdf, stream); //FileHelper.CreateFile("\\log\\PDF" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".jpg", stream.ToArray()); } else if (exportFormat.Equals("Jpeg", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport { ImageFormat = FastReport.Export.Image.ImageExportFormat.Jpeg, SeparateFiles = false, JpegQuality = 100 }; report.Prepare(); report.Export(image, stream); FileHelper.CreateFile("\\log\\JPG" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".jpg", stream.ToArray()); //foreach (var item in image.GeneratedFiles) //{ // var temp = item; // var log = LogFactory.GetLogger("FastReportHelper"); // log.Info(temp); //} //return report.SaveToStringBase64(); } else if (exportFormat.Equals("Bmp", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport { ImageFormat = FastReport.Export.Image.ImageExportFormat.Bmp }; report.Prepare(); report.Export(image, stream); } else if (exportFormat.Equals("Gif", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport { ImageFormat = FastReport.Export.Image.ImageExportFormat.Gif }; report.Prepare(); report.Export(image, stream); } else if (exportFormat.Equals("Png", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport { ImageFormat = FastReport.Export.Image.ImageExportFormat.Png, SeparateFiles = false }; report.Prepare(); report.Export(image, stream); } else if (exportFormat.Equals("Tiff", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport { ImageFormat = FastReport.Export.Image.ImageExportFormat.Tiff }; report.Prepare(); report.Export(image, stream); } else if (exportFormat.Equals("html", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Html.HTMLExport image = new FastReport.Export.Html.HTMLExport { EnableMargins = false, Pictures = true, EmbedPictures = true, ImageFormat = ImageFormat.Png }; report.Prepare(); report.Export(image, stream); return(System.Text.Encoding.UTF8.GetString(stream.ToArray())); } result = Convert.ToBase64String(stream.ToArray()); } } else { //var log = LogFactory.GetLogger("FastReportHelper"); //log.Error(reportFilePath + ",目录不存在!"); } return(result); }
public static Stream GetReportStream(string reportFilePath, string dataSetName, DataSet data, string exportFormat) { FastReport.Report report = new FastReport.Report(); MemoryStream result = new MemoryStream(); if (FileHelper.IsExistFile(reportFilePath)) { try { report.Load(reportFilePath); // Download the report report.RegisterData(data, dataSetName); // Register data in the report } catch { //var log = LogFactory.GetLogger("FastReportHelper"); return(result); } using (MemoryStream stream = new MemoryStream()) { if (exportFormat.Equals("pdf", StringComparison.InvariantCultureIgnoreCase)) { //FastReport.Export.Pdf.PDFExport pdf = new FastReport.Export.Pdf.PDFExport(); //report.Export(pdf, stream); } else if (exportFormat.Equals("Jpeg", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport(); image.ImageFormat = FastReport.Export.Image.ImageExportFormat.Jpeg; report.Export(image, stream); } else if (exportFormat.Equals("Bmp", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport(); image.ImageFormat = FastReport.Export.Image.ImageExportFormat.Bmp; report.Export(image, stream); } else if (exportFormat.Equals("Gif", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport(); image.ImageFormat = FastReport.Export.Image.ImageExportFormat.Gif; report.Export(image, stream); } else if (exportFormat.Equals("Png", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport(); image.ImageFormat = FastReport.Export.Image.ImageExportFormat.Png; report.Export(image, stream); } else if (exportFormat.Equals("Tiff", StringComparison.InvariantCultureIgnoreCase)) { FastReport.Export.Image.ImageExport image = new FastReport.Export.Image.ImageExport { ImageFormat = FastReport.Export.Image.ImageExportFormat.Tiff }; report.Export(image, stream); } result = stream; } } else { //var log = LogFactory.GetLogger("FastReportHelper"); //log.Error(reportFilePath + ",目录不存在!"); } return(result); }
/// <summary> /// 导出 /// </summary> private void btnExport_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtCompanyCode.Text)) { MessageBox.Show("请选择公司。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (string.IsNullOrEmpty(txtFilePath.Text)) { MessageBox.Show("请选择保存路径。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } BaseCompanyTable companyTable = bCompany.GetModel(txtCompanyCode.Text.Trim()); BllOrderHeaderTable orderTable = bOrderH.GetModel(_slipNumber); BaseCustomerTable customerTable = bCustomer.GetModel(orderTable.ENDER_CUSTOMER_CODE); report.Preview = previewControl1; DataTable dt = new DataTable(); dt.TableName = "ds"; dt.Columns.Add("i", System.Type.GetType("System.Decimal")); dt.Columns.Add("SPEC", System.Type.GetType("System.String")); dt.Columns.Add("QUANTITY", System.Type.GetType("System.Decimal")); dt.Columns.Add("PRICE", System.Type.GetType("System.Decimal")); dt.Columns.Add("DISCOUNT", System.Type.GetType("System.Decimal")); dt.Columns.Add("AMOUNT", System.Type.GetType("System.Decimal")); dt.Columns.Add("MATERIAL", System.Type.GetType("System.String")); dt.Columns.Add("MEMO", System.Type.GetType("System.String")); dt.Columns.Add("DESCRIPTION", System.Type.GetType("System.String")); dt.Columns.Add("DESCRIPTION1", System.Type.GetType("System.String")); int j = 1; foreach (BllOrderLineTable lineModel in orderTable.Items) { if (lineModel.PRICE_DISCOUNT.ToString().Equals("0.00")) { object[] rows = { j++, lineModel.SPEC, lineModel.QUANTITY, lineModel.PRICE, null, lineModel.AMOUNT, lineModel.METERIAL, lineModel.MEMO, lineModel.DESCRIPTION, lineModel.DESCRIPTION1 }; dt.Rows.Add(rows); } else { object[] rows = { j++, lineModel.SPEC, lineModel.QUANTITY, lineModel.PRICE, 0 - lineModel.PRICE_DISCOUNT, lineModel.AMOUNT, lineModel.METERIAL, lineModel.MEMO, lineModel.DESCRIPTION, lineModel.DESCRIPTION1 }; dt.Rows.Add(rows); } } DataSet ds = new DataSet(); ds.Tables.Add(dt); string fileName = ""; string amountName = ""; if (CConstant.LANGUAGE_CN.Equals(cboLanguage.SelectedValue)) { fileName = @"Reports\Proforma_Invoice.frx"; amountName = NumberConvert.NumberToEnglish(CConvert.ToString(orderTable.AMOUNT_INCLUDED_TAX), false); } else if (CConstant.LANGUAGE_EN.Equals(cboLanguage.SelectedValue)) { fileName = @"Reports\Order_EN.frx"; amountName = NumberConvert.NumberToEnglish(CConvert.ToString(orderTable.AMOUNT_INCLUDED_TAX), false); } try { if (File.Exists(fileName)) { report.Load(fileName); report.SetParameterValue("CompanyName", companyTable.NAME); report.SetParameterValue("EnglishCompanyName", companyTable.NAME_ENGLISH); report.SetParameterValue("CompanyTel", companyTable.PHONE_NUMBER); report.SetParameterValue("CompanyFax", companyTable.FAX_NUMBER); report.SetParameterValue("CompanyAddress", companyTable.ADDRESS_MIDDLE); report.SetParameterValue("CompanyUrl", companyTable.URL); report.SetParameterValue("CompanyEmail", companyTable.EMAIL); report.SetParameterValue("SlipNumber", _slipNumber); report.SetParameterValue("SlipDate", CConvert.ToDateTime(orderTable.SLIP_DATE).ToString("yyyy/MM/dd")); report.SetParameterValue("Currency", orderTable.CURRENCY_NAME); report.SetParameterValue("CustomerName", customerTable.NAME); int COUNT = 0; foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["DISCOUNT"].ToString() != "") { COUNT++; } } if (COUNT > 0) { report.SetParameterValue("DISCOUNT", "Discount"); } if (customerTable.PHONE_NUMBER.ToString() != "") { report.SetParameterValue("CustomerTel", "Tel:" + customerTable.PHONE_NUMBER); } if (customerTable.FAX_NUMBER.ToString() != "") { report.SetParameterValue("CustomerFax", "Fax:" + customerTable.FAX_NUMBER); } if (customerTable.ADDRESS_FIRST.ToString() != "") { report.SetParameterValue("CustomerAddress", "Address:" + customerTable.ADDRESS_FIRST); } report.SetParameterValue("CustomerMessage", txtMessage.Text); report.SetParameterValue("DeliveryTerms", orderTable.DELIVERY_TERMS); report.SetParameterValue("PaymentTerms", orderTable.PAYMENT_TERMS); if (orderTable.DISCOUNT_RATE > 0) { report.SetParameterValue("DiscountRate", "-" + orderTable.DISCOUNT_RATE + "%"); report.SetParameterValue("DiscountAmount", orderTable.AMOUNT_INCLUDED_TAX); } report.SetParameterValue("AmountName", amountName); report.SetParameterValue("FullNameEn", txtBankEn.Text); report.SetParameterValue("DetailEn", rtxtDetail.Text); if (companyTable.COMPANY_PICTURE != null) { MemoryStream ms = new MemoryStream((byte[])companyTable.COMPANY_PICTURE); Image image = Image.FromStream(ms); ((FastReport.PictureObject)report.FindObject("CompanyPicture")).Image = image; } if (companyTable.LOGO != null) { MemoryStream ms1 = new MemoryStream((byte[])companyTable.LOGO); Image image1 = Image.FromStream(ms1); ((FastReport.PictureObject)report.FindObject("Logo")).Image = image1; } report.RegisterData(ds); report.Prepare(); if (fileName.Equals(@"Reports\Proforma_Invoice.frx")) { report.Export(new FastReport.Export.Pdf.PDFExport(), this.txtFilePath.Text + "\\Proforma_Invoice" + _slipNumber + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf"); } else { report.Export(new FastReport.Export.Pdf.PDFExport(), this.txtFilePath.Text + "\\Order_" + _slipNumber + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf"); } MessageBox.Show("导出成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } catch (Exception ex) { Logger.Error("", ex); } }
public HttpResponseMessage PostReport(JObject JsonRequest) { int status = 0; string error = ""; try { String className = "FastReport." + JsonRequest["ClassName"].ToString(); string rootPath = System.Environment.CurrentDirectory; string outputPath = Path.Combine(rootPath, "output.pdf"); //FastReport.Report report = new FastReport.Report(); //string filename = @"C:\Users\lipan\Desktop\report3.frx"; //report.Load(filename); FastReport.Report report = (FastReport.Report)Activator.CreateInstance(System.Type.GetType(className)); DataSet data = new DataSet(); DataTable table = new DataTable(); int num = 0; foreach (var item in JsonRequest) { if (item.Key.StartsWith("ClassName")) { continue; } if (item.Key.StartsWith("Signature")) { DataTable dt = new DataTable(); dt.TableName = item.Key; dt.Columns.Add(item.Key, typeof(byte[])); WebClient wc = new WebClient(); byte[] bytes; if (item.Value.ToString() == "") { //此处留空时处理; bytes = wc.DownloadData(Path.Combine(rootPath, "EmptySignature.PNG")); } else { bytes = wc.DownloadData(item.Value.ToString()); } MemoryStream msIMG = new MemoryStream(bytes); Image img = System.Drawing.Image.FromStream(msIMG); //Image img = Image.FromFile(folderPath + item.Key + ".PNG"); DataRow row = dt.NewRow(); MemoryStream ms = new MemoryStream(); img.Save(ms, System.Drawing.Imaging.ImageFormat.Gif); row[item.Key] = ms.ToArray(); dt.Rows.Add(row); data.Tables.Add(dt); continue; } table = CSVHelper.ConvertJsonToDatatable(JsonRequest.ToString(), num); table.TableName = item.Key; data.Tables.Add(table); num++; } report.RegisterData(data); int tableNum = data.Tables.Count; for (int i = 0; i < tableNum; i++) { report.GetDataSource(data.Tables[i].TableName).Enabled = true; } report.Prepare(); FastReport.Export.Pdf.PDFExport export = new FastReport.Export.Pdf.PDFExport(); report.Export(export, outputPath); System.Diagnostics.Process.Start(outputPath); } catch (Exception e) { status = -1; error = e.ToString(); } String returnValue = JsonConvert.SerializeObject(new { status = status.ToString(), error = error }); return(ResultToJson.toJson(returnValue)); }
public ActionResult getReportbloodGroup(string from, string to, string prod) { string siteCode = Session["T_SITE_CODE"].ToString(); DataTable T12302_ = repository.GetReport(siteCode); DataTable T12302_PatInf_ = repository.GetPatInf(); DataTable T12302_Site_ = repository.GetSite(siteCode); T12302_.TableName = "R12302"; T12302_PatInf_.TableName = "R12302_PatInf"; T12302_Site_.TableName = "R12302_Site"; DataSet ds = new DataSet(); ds.Tables.Add(T12302_); ds.Tables.Add(T12302_PatInf_); ds.Tables.Add(T12302_Site_); // dtT12302.TableName = "T12302"; //----------- for barcode start----------------- // dtT12025.Columns.Add("Pat_BarCode", typeof(Bitmap)); // Image myimg = Code128Rendering.MakeBarcodeImage(dtT12204.Rows[0]["T_BAG_BARCODE"].ToString(), int.Parse("2"), true); // dtT12025.Rows[0]["Pat_BarCode"] = myimg; //----------- for barcode end----------------- // dtT12204.Columns.Add("Time", typeof(string)); //dtT12204.Rows[0]["Time"] = Session["Hou_Min"].ToString(); // ds.WriteXmlSchema(Server.MapPath("~/Report/xml/T12050.xml")); // return View(); using (var webReport = new FastReport.Report()) { webReport.Report.Load(Server.MapPath("~/Report/Report/R12050.frx")); webReport.Report.RegisterData(T12302_, "R12302"); webReport.Report.RegisterData(T12302_PatInf_, "R12302_PatInf"); webReport.Report.RegisterData(T12302_Site_, "R12302_Site"); // System.Data.DataSet dataSet = new System.Data.DataSet(); //webReport.Report.RegisterData(dtT12302, "T12302"); webReport.Report.Prepare(); using (var Report = new MemoryStream()) { // var excelExport = new Excel2007Export(); // webReport.Report.Export(excelExport, strm); // var pdfExport = new PDFExport(); // webReport.Report.Export(pdfExport, strm); // Response.ClearContent(); // Response.ClearHeaders(); // Response.Buffer = true; //// Response.ContentType = "Application/vnd.ms-excel"; // Response.ContentType = "Application/PDF"; // Response.BinaryWrite(strm.ToArray()); // Response.End(); var pdfExport = new PDFExport(); webReport.Export(pdfExport, Report); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = "Application/PDF"; Response.BinaryWrite(Report.ToArray()); Response.End(); } ViewBag.WebReport = webReport; } return(View()); }