protected void Page_Load(object sender, EventArgs e) { conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["kmcConnectionString"].ToString(); conn.Open(); DataSet ds = new DataSet(); string qry = "select * from userinfo where Username = '******'"; sda = new SqlDataAdapter(qry, conn); sda.Fill(ds, "user"); rpt.Load(Server.MapPath("~/CrystalReport.rpt")); rpt.FileName = Server.MapPath("~/CrystalReport.rpt"); crv.DisplayToolbar = true; crv.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None; crv.Zoom(100); crv.HasExportButton = false; crv.HasPrintButton = true; crv.HasToggleGroupTreeButton = false; crv.HasToggleParameterPanelButton = false; crv.HasZoomFactorList = false; crv.HasCrystalLogo = false; crv.Font.Size = 8; crv.GroupTreeStyle.Font.Size = 8; crv.GroupTreeStyle.ShowLines = false; crv.ToolbarStyle.Width = Unit.Parse("2046px"); rpt.SetDataSource(ds); crv.ReportSource = rpt; filepath = Server.MapPath("~/" + "test.pdf"); rpt.ExportToDisk(ExportFormatType.PortableDocFormat, filepath); //rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "PersonDetails"); //pdfcontroller(); conn.Close(); }
private void Reporte1() { string NameFile = "Empleados_lista"; int n = 1; string filePath = @"C:/Users/mfhernandezl/Downloads/" + NameFile + ".pdf"; ReportDocument crystalReport = new ReportDocument(); crystalReport.Load(Server.MapPath("/Reports/PersonInfo.rpt")); bdPersonal dsPersona = ReadAll(); crystalReport.SetDataSource(dsPersona); CrystalReportViewer1.ReportSource = crystalReport; CrystalReportViewer1.Visible = true; CrystalReportViewer1.RefreshReport(); if (!File.Exists(filePath)) { crystalReport.ExportToDisk(ExportFormatType.PortableDocFormat, filePath); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.WriteFile(filePath); } else { NameFile += "(" + n++ + ")"; filePath = @"C:/Users/mfhernandezl/Downloads/" + NameFile + ".pdf"; crystalReport.ExportToDisk(ExportFormatType.PortableDocFormat, filePath); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.WriteFile(filePath); } }
protected void imgbtnPresupuesto_click(object sender, EventArgs e) { //Parametros del store procedure string strID = Cookies.GetCookie("cookieEditarOrdenEstimacion").Value; FirmasReportes oFirmas = FirmasReportesBusiness.ObtenerFirmasReportesPorModulo("Reportes"); string strReviso = oFirmas.FirmaReviso; //1. Configurar la conexión y el tipo de comando SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["OSEF"].ConnectionString); try { using (var comando = new SqlCommand("web_spS_ObtenerREstimacion", conn)) { using (var adaptador = new SqlDataAdapter(comando)) { DataTable dt = new DataTable(); adaptador.SelectCommand.CommandType = CommandType.StoredProcedure; adaptador.SelectCommand.Parameters.Add(@"IDMovimiento", SqlDbType.Int).Value = Convert.ToInt32(strID); adaptador.Fill(dt); var reporteEstimaciones = new ReportDocument(); reporteEstimaciones.Load(Server.MapPath("reportess/rPresupuesto.rpt")); reporteEstimaciones.SetDataSource(dt); reporteEstimaciones.SetParameterValue("reviso", strReviso); string strDireccion = Server.MapPath(" ") + "\\reportess\\Estimaciones\\" + strID; //2. Validar si existe el directorio donde se guardaran if (Directory.Exists(strDireccion)) { reporteEstimaciones.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath("reportess/Estimaciones/" + strID + "/rPresupuesto " + strID + ".pdf")); ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var popup=window.open('reportess/Estimaciones/" + strID + "/rPresupuesto " + strID + ".pdf',null,'height=700,width=660');popup.focus();", true); // reporteFotos.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "rFotos " + strID); } else { Directory.CreateDirectory(strDireccion); reporteEstimaciones.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath("reportess/Estimaciones/" + strID + "/rPresupuesto " + strID + ".pdf")); ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var popup=window.open('reportess/Estimaciones/" + strID + "/rPresupuesto " + strID + ".pdf',null,'height=700,width=660');popup.focus();", true); } } // end using adaptador } // end using comando } catch (Exception ex) { ex.Message.ToString(); } finally { if (conn.State != ConnectionState.Closed) { conn.Close(); } conn.Dispose(); } }
/// <summary> /// Method IsEmptyReport checks to see if report pulls data or not. This would tell us weather we needed send an email or not. /// Users requested to send email with attached empty report regardless of the existence of data. /// </summary> /// <param name="report"></param> /// <param name="p_ReportDocument"></param> /// <returns></returns> private bool ExportReport(CRPT report, ReportDocument p_ReportDocument) { try { string outputDir = ConfigurationManager.AppSettings["OutputPath"].ToString() + report.OutputPath + "\\" + DateTime.Now.ToString("yyyy_MM_dd"); string fname = GetGroupLevelFileName(report); string strReportExportNamePath = outputDir + "\\" + fname; bool IsRFPT = SetParameterValues(report, p_ReportDocument); if (IsRFPT) { // if (IsEmptyReport(p_ReportDocument)) return false; try { if (!Directory.Exists(outputDir)) { Directory.CreateDirectory(outputDir); } if (report.IsPdf()) { p_ReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, strReportExportNamePath); } else { p_ReportDocument.ExportToDisk(ExportFormatType.Excel, strReportExportNamePath); } SendMail(strReportExportNamePath, report.Recipients, "Generated Report Attached.", "FreestyleConnect Report"); } catch (Exception e) { VMALogger.Log(LogLevel.Error, Environment.NewLine + "Report Name: " + report.ReportName + "Export error message: " + e.Message); return(false); } } else { VMALogger.Log(LogLevel.Error, Environment.NewLine + "Report Name: " + report.ReportName + "Export Parameters not found"); return(false); } } catch (Exception ex) { VMALogger.Log(LogLevel.Error, Environment.NewLine + "Set Parameter Error: " + report.ReportName + " Error Message: " + ex.Message); return(false); } return(true); }
private void VentaTotalxCTC() { string ctc = string.Empty; desde = Convert.ToDateTime(Page.Request["desde"]); hasta = Convert.ToDateTime(Page.Request["hasta"]); ctc = Page.Request["ctc"]; parametros.Add(desde); parametros.Add(hasta); parametros.Add(ctc); ds.tVentaTotalCTC.Merge(conReportes.VentaTotalxCTC(parametros)); CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new ReportDocument(); rpt.FileName = Server.MapPath("~/RPT/VentaTotalxCTC.rpt"); rpt.Load(rpt.FileName, OpenReportMethod.OpenReportByDefault); rpt.SetDataSource(ds); crviewer.ReportSource = rpt; //rpt.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "ajdsfaklj"); rpt.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath("files/asdf.pdf")); //ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var popup=window.open('files/asdf.pdf');popup.focus();", true); ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var hidden = open('files/asdf.pdf', 'NewWindow', 'top=25,left=300,width=800, height=600,status=yes,resizable=yes,scrollbars=yes');", true); //hidden = open('files/asdf.pdf', 'NewWindow', 'top=25,left=300,width=800, height=600,status=yes,resizable=yes,scrollbars=yes'); }
private void ExportReport(ParamReport paramReport) { var conInfo = new ConnectionInfo { ServerName = _builder.DataSource, DatabaseName = _builder.InitialCatalog, UserID = _builder.UserID, Password = _builder.Password }; using (var rd = new ReportDocument()) { rd.Load(Path.Combine(Server.MapPath("~/Reports"), paramReport.ReportName)); rd.DataSourceConnections[0] .SetConnection(conInfo.ServerName, conInfo.DatabaseName, conInfo.UserID, conInfo.Password); if (paramReport.Parameters.Any()) { foreach (var param in paramReport.Parameters) { rd.SetParameterValue(param.Key, param.Value); } } var formatType = GetExportFormatType(paramReport); var path = Path.Combine(Server.MapPath("~/Reports/tmp"), GetFileExt(paramReport)); rd.ExportToDisk(formatType, path); } }
public JsonResult GenerateDetailReport(LP_Inv_Report objrprtparam) { try { objLP_Inventory_BLL = new LP_Inventory_BLL(objrprtparam); DataTable dt = objLP_Inventory_BLL.GetInventoryReport().Tables[0]; //List<Customer> allCustomer = new List<Customer>(); //allCustomer = context.Customers.ToList(); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "InventoryReport.rpt")); rd.SetDataSource(dt); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Path.Combine(Server.MapPath("~/Reports"), "InventoryReport.Pdf")); //stream.Seek(0, SeekOrigin.Begin); //return File(stream, "application/pdf", "CustomerList.pdf"); return(Json(new { data = "/Reports/InventoryReport.Pdf", success = true, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { data = "/Reports/InventoryReport.Pdf", success = true, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet)); } }
public string GenerateReport(int ReturnID, string ReportPath) { ReportDocument rptDoc = null; System.IO.MemoryStream objStr = null; try { string Path = "~/Reports/rptCustomerRegistrationBank.rpt"; rptDoc = new ReportDocument(); rptDoc.Load(Server.MapPath(Path)); rptDoc.SetParameterValue("@customerId", ReturnID); rptDoc.SetParameterValue("@BankID", ddlBank.SelectedValue); objStr = (System.IO.MemoryStream)rptDoc.ExportToStream(ExportFormatType.PortableDocFormat); rptDoc.ExportToDisk(ExportFormatType.PortableDocFormat, ReportPath); return(ReportPath); } catch (Exception ex) { Response.Write(ex.Message); return(string.Empty); } finally { } }
/// <summary> /// PDFファイル作成(各請求書毎) /// </summary> public void PrintOutPDF() { if (this.targetReportDocument == null) { throw new ReportException(CommonConst.ErrReportObjectNotReady, new NullReferenceException()); } try { DirectoryInfo dir = new DirectoryInfo(basedir); if (!dir.Exists) { dir.Create(); } string filepath = string.Format(basedir + @"\wk_{0:D5}.pdf", this.printfiles.Count); this.printfiles.Add(filepath); targetReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, filepath); targetReportDocument.Close(); targetReportDocument.Dispose(); targetReportDocument = null; } catch (Exception ex) { throw ex; } }
public void Sentmail_supplier(int PONO, int sup) { ReportDocument document = new ReportDocument(); string str = base.Server.MapPath("rptsv/"); Merchandising merchandising = new Merchandising(); string val = this._bll.get_Informationdataset("select cCmpName from Smt_Company where Display_AS_Header=1").Tables[0].Rows[0]["cCmpName"].ToString(); new System.Data.DataTable().TableName = "PO_Printing"; System.Data.DataTable table = this.blInventory.get_InformationdataTable("Sp_Smt_POPrinting " + ((int)PONO)); //merchandising.Tables.get_Item("PO_Printing").Merge(table); merchandising.Tables["PO_Printing"].Merge(table); document.Load(base.Server.MapPath("Report_Merchandising/CrystalReport2.rpt")); document.SetDataSource((System.Data.DataSet)merchandising); document.SetParameterValue("cCmpName", val); System.IO.MemoryStream stream1 = (System.IO.MemoryStream)document.ExportToStream(ExportFormatType.PortableDocFormat); base.Response.Clear(); ContentType type = new ContentType(); base.Response.Buffer = true; type.MediaType = ("application/pdf"); string fileName = str + ((int)PONO) + ".pdf"; document.ExportToDisk(ExportFormatType.PortableDocFormat, fileName); this.execmail(this.Session["Uid"].ToString(), PONO, sup, base.Server.MapPath("rptsv/") + ((int)PONO) + ".pdf"); if (System.IO.File.Exists(fileName)) { System.IO.File.Delete(fileName); } }
public int ExportToFile(string rptfile, string outfiletype, DataSet tables, string outfilename, ref string error) { int success = 0; try { ReportDocument rd = new ReportDocument(); if (tables.Tables.Count == 1) { success = Load(rptfile, tables.Tables[0], ref rd, ref error); } else { success = Load(rptfile, tables, ref rd, ref error); } if (success == 0) { string extention = ""; ExportFormatType type = GetExportType(outfiletype, ref extention); rd.ExportToDisk(type, outfilename); rd.Dispose(); } } catch (Exception ex) { success = 23; error = ex.Message; } return(success); }
protected void Page_Load(object Sender, EventArgs e) { ds = new DataSet(); reporte = new ReportDocument(); if (Session["facs"] != null) { if (Request.QueryString["tipo"] == "C") { Utils.MostrarAlerta(Response, "Se ha creado la factura de cliente con prefijo " + Request.QueryString["pre"] + " y número " + Request.QueryString["num"] + ""); try { Imprimir.ImprimirRPT(Response, Request.QueryString["pre"], Convert.ToInt32(Request.QueryString["num"]), true); } catch { lb.Text += "Error al generar la impresión. Detalles : " + formatoRecibo.Mensajes + "<br>"; } } else if (Request.QueryString["tipo"] == "P") { DBFunctions.Request(ds, IncludeSchema.NO, Armar_Select_Pro() + ";" + "SELECT MNIT.mnit_nit,CEMP.cemp_nombre,CEMP.cemp_direccion,MNIT.mnit_telefono,TREG.treg_nombre CONCAT''CONCAT 'Nº 'CONCAT' 'CONCAT CEMP.cemp_numeregiiva CONCAT' 'CONCAT 'de 'CONCAT''CONCAT CAST(CEMP.cemp_regiiva AS char(10)),MNIT.mnit_web,PCIU.pciu_nombre FROM dbxschema.mnit MNIT,dbxschema.cempresa CEMP,dbxschema.tregimeniva TREG,dbxschema.pciudad PCIU WHERE MNIT.mnit_nit=CEMP.mnit_nit AND CEMP.cemp_indiregiiva=TREG.treg_regiiva AND PCIU.pciu_codigo=CEMP.cemp_ciudad;" + "SELECT 'Numeración autorizada por la DIAN Resolución Nº ' CONCAT pdoc_numeresofact CONCAT ' Fecha ' CONCAT CAST(pdoc_fechresofact AS char(10)) CONCAT ' Rango con prefijo ' CONCAT pdoc_codigo CONCAT ' Nº ' CONCAT CAST(pdoc_numeinic AS char(10)) CONCAT ' al Nº ' CONCAT CAST(pdoc_numefina AS char(10)) FROM dbxschema.pdocumento WHERE pdoc_codigo='" + (((ArrayList)Session["facs"])[0].ToString().Split('-'))[0].ToString() + "'"); Sacar_Letras(); ds.WriteXmlSchema(Path.Combine(Request.PhysicalApplicationPath, "schemas/Finanzas.Cartera.Finanzas.Cartera.rpte_ImpCauAutoPro.xsd")); reporte.Load(Path.Combine(Request.PhysicalApplicationPath, "rpt/Finanzas.Cartera.rpte_ImpCauAutoPro.rpt")); reporte.SetDataSource(ds); visor.ReportSource = reporte; visor.DataBind(); reporte.ExportToDisk(ExportFormatType.WordForWindows, Path.Combine(Request.PhysicalApplicationPath, "rptgen/Finanzas.Cartera.rpte_ImpCauAutoPro.doc")); } } }
public void Exportar(string key) { try { ReportDocument objRpt = new ReportDocument(); DataSet ds = (DataSet)this.GetDataReport(key); string reportPath = "C:\\Reportes\\CRTejTicket_rpt.rpt"; objRpt.Load(reportPath); ExportOptions crExportOptions = new ExportOptions(); objRpt.SetDataSource(ds.Tables[0]); SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.InitialDirectory = Environment.SpecialFolder.MyDocuments.ToString(); saveFileDialog.Filter = "Document (*.pdf)|*.PDF"; saveFileDialog.FilterIndex = 1; saveFileDialog.FileName = "Etiqueta.pdf"; if (saveFileDialog.ShowDialog() == DialogResult.OK) { objRpt.ExportToDisk(ExportFormatType.PortableDocFormat, saveFileDialog.FileName); ; } crExportOptions = objRpt.ExportOptions; objRpt.Export(); } catch (Exception ex) { ex.ToString(); } }
private void CustomerTransactionReportForm_Load(object sender, EventArgs e) { ReportDocument cryRpt; using (Devart.Data.SQLite.SQLiteConnection myConn = new Devart.Data.SQLite.SQLiteConnection(myConfig.connstr)) { using (SQLiteCommand myCmd = new SQLiteCommand(sqlcmd, myConn)) { myConn.Open(); using (SQLiteDataReader myReader = myCmd.ExecuteReader()) { dataSet2.customer_trans.Load(myReader); myConn.Close(); } } } this.customerTableAdapter1.Fill(this.dataSet2.customer); this.configurationTableAdapter1.Fill(this.dataSet2.configuration); CustomerTransactionReport rpt = new CustomerTransactionReport(); rpt.SetDataSource(this.dataSet2); cryRpt = new ReportDocument(); cryRpt.Load(rpt.FileName.ToString()); cryRpt.SetDataSource(this.dataSet2); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, ReportFolder.reportFolderName + @"\CustomerTransactions.pdf"); }
protected void download_Click(object sender, EventArgs e) { LinkButton lnk = (LinkButton)sender; string PO = lnk.CommandArgument.ToString(); using (var context = new YETIEntities()) { ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(Server.MapPath("~/Reports/RWO.rpt")); cryRpt.SetDataSource(context.cqf_workOrder.Where(w => w.fs_workOrder == PO).ToList()); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.RefreshReport(); cryRpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Server.MapPath("~/Reports/RWO.pdf")); cqf_logActividad log = new cqf_logActividad(); log.fdt_fecha = DateTime.Now; log.fi_idUsuario = int.Parse(Session["UserID"].ToString()); log.fs_actividad = "Download Report Work Order:" + PO; context.cqf_logActividad.Add(log); context.SaveChanges(); } }
private void CreateReport(ICollection source, string reportName) { try { var rd = new ReportDocument(); rd.Load("Reports\\" + reportName + ".rpt"); rd.SetDataSource(source); var saveFileDlg = new SaveFileDialog { FileName = reportName, DefaultExt = ".pdf", Filter = "Pdf documents (.pdf)|*.pdf", InitialDirectory = Environment.CurrentDirectory }; if (saveFileDlg.ShowDialog() == true) { rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, saveFileDlg.FileName); } } catch (Exception ex) { CustomMessage.Show(ex.Message, this); } }
protected void Page_Load(object sender, EventArgs e) { DataValidation dv = new DataValidation(); string sPath = dv.CurrentDir(true); string sFN = sPath + "pdfs//AgentStockPrices.pdf"; ReportDocument r = new ReportDocument(); try { string sRpt = "AgentStockPrices.rpt"; r.Load(System.AppDomain.CurrentDomain.BaseDirectory + sRpt); sFN = "C:\\MGMQuotation\\pdfs\\AgentStockPrices.rpt"; r.ExportToDisk(ExportFormatType.PortableDocFormat, sFN); System.Web.HttpContext.Current.Response.ClearContent(); System.Web.HttpContext.Current.Response.ClearHeaders(); System.Web.HttpContext.Current.Response.ContentType = "application/pdf"; System.Web.HttpContext.Current.Response.WriteFile(sFN); } catch (Exception ex) { Response.Write("Exception occurred: " + ex + "."); } finally { r.Dispose(); } }
private void cmdExcel_Click(object sender, EventArgs e) { string sFileName = ""; try { var SaveFileDlg = new SaveFileDialog(); SaveFileDlg.Title = "VietBaJC-->Save to Excel file"; SaveFileDlg.Filter = "Excel files|*.XLS"; if (SaveFileDlg.ShowDialog() == DialogResult.OK) { sFileName = SaveFileDlg.FileName; if (sFileName.Contains(".XLS")) { } else { sFileName += ".XLS"; } Text = "Đang lưu dữ liệu ra file: " + sFileName; RptDoc.ExportToDisk(ExportFormatType.Excel, sFileName); Text = "In dữ liệu"; if ( Utility.AcceptQuestion( "Đã xuất dữ liệu thành công ra file Excel ở đường dẫn: " + sFileName + Constants.vbCrLf + "Bạn có muốn mở file Excel ra xem không?", "Thông báo", true)) { Process.Start(sFileName); } } } catch (Exception ex) { } }
private void GenerateInvoice() { string path = @"C:\PS Supermarket\Bills\" + txtinvoiceno.Text + ".pdf"; if (!Directory.Exists(@"C:\PS Supermarket\Bills")) { Directory.CreateDirectory(@"C:\PS Supermarket\Bills"); } ReportDocument rep = new ReportDocument(); rep.Load(@"C:\PS Supermarket\Invoice.rpt"); db.CrystalReportServer(rep); rep.SetParameterValue("InvoiceNo", txtinvoiceno.Text); if (File.Exists(path)) { File.Delete(path); } rep.ExportToDisk(ExportFormatType.PortableDocFormat, path); DialogResult open = MessageBox.Show("Do you want to Open the Invoice?", "Open Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (open == DialogResult.Yes) { Process.Start(path); } }
// POST api/crystalreports public HttpResponseMessage Post([FromBody] ReportInfo report) { try { var reportName = report.ReportName; var tenantName = report.TenantName; var crystalReportFileInfo = ObtainReportDefinition(reportName, tenantName); ReportDocument doc = new ReportDocument(); doc.Load(crystalReportFileInfo.localFileInfo); var tempFile = Path.GetTempFileName(); //Export to PDF on temp file doc.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, tempFile); var resName = GetReportOutputName(report); var url = new StorageAbstraction().Save(resName, tempFile); var responseMessage = new ReportOutputResponse() { Url = url }; var response = Request.CreateResponse(responseMessage); return(response); } catch (Exception ex) { Trace.WriteLine("Error! " + ex.Message + "--" + ex.StackTrace); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
private void button1_Click(object sender, EventArgs e) { try { ReportDocument rd; rd = new ReportDocument(); rd.Load(@"C:\Users\PLABON\Documents\Visual Studio 2013\Projects\SalesAndInventorySystem\SalesAndInventorySystemUI\Report\a.rpt"); List<PersonType> company = companyGateway.GetCompanies(); var companyX = company.Select(x => new {x.ID, x.Name}); rd.SetDataSource(companyX); crystalReportViewer1.ReportSource = rd; crystalReportViewer1.Refresh(); int a = 10; if (File.Exists(@"D:\" + "AAAA" + a +".pdf")) File.Delete(@"D:\" + a++ + ".pdf"); rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, @"D:\" + a + ".pdf"); } catch (Exception) { throw; } }
public void Sm_Em_L(int PONO, string Supplieremail, string supname) { this._bll.get_InformationdataTable("select Email from Smt_Users where cUserName='******'").Rows[0]["Email"].ToString(); ReportDocument document = new ReportDocument(); string str = base.Server.MapPath("rptsv/"); Merchandising merchandising = new Merchandising(); string val = this._bll.get_Informationdataset("select cCmpName from Smt_Company where Display_AS_Header=1").Tables[0].Rows[0]["cCmpName"].ToString(); new System.Data.DataTable().TableName = ("PO_Printing"); System.Data.DataTable table2 = this.blInventory.get_InformationdataTable("Sp_Smt_POPrinting " + ((int)PONO)); merchandising.Tables["PO_Printing"].Merge(table2); document.Load(base.Server.MapPath("Report_Merchandising/CrystalReport2.rpt")); document.SetDataSource((System.Data.DataSet)merchandising); document.SetParameterValue("cCmpName", val); System.IO.MemoryStream stream1 = (System.IO.MemoryStream)document.ExportToStream(ExportFormatType.PortableDocFormat); base.Response.Clear(); ContentType type = new ContentType(); base.Response.Buffer = true; type.MediaType = ("application/pdf"); string fileName = string.Concat((object[])new object[] { str, supname, "_", ((int)PONO), ".pdf" }); if (System.IO.File.Exists(fileName)) { System.IO.File.Delete(fileName); } document.ExportToDisk(ExportFormatType.PortableDocFormat, fileName); }
private void materialFlatButton1_Click(object sender, EventArgs e) { this.Cursor = Cursors.WaitCursor; try { path = @"C:\PS Supermarket\Sales Report.pdf"; ReportDocument rep = new ReportDocument(); rep.Load(@"C:\PS Supermarket\Sales Report.rpt"); db.CrystalReportServer(rep); rep.SetParameterValue("From", txtfrom.Text); rep.SetParameterValue("To", txtto.Text); rep.SetParameterValue("CustomerID", txtcustomer.Text); if (File.Exists(path)) { File.Delete(path); } rep.ExportToDisk(ExportFormatType.PortableDocFormat, path); Process.Start(path); this.Cursor = Cursors.Default; } catch (Exception ex) { this.Cursor = Cursors.Default; MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private static void LoadReportTest() { var rpt = new ReportDocument(); var reportFilename = @"Reports\SimpleReport.rpt"; rpt.Load(reportFilename); if (rpt.IsLoaded) { if (rpt.HasSavedData) { rpt.Refresh(); } Console.WriteLine("Report was loaded."); rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, "SimpleReport.pdf"); } rpt.Close(); rpt.Dispose(); System.Diagnostics.Process.Start("SimpleReport.pdf"); }
public void GenerateBuilty() { string type = TempData["Type"].ToString(); var ReportData = (DataSet)TempData["ReportData"]; ReportDocument rd = new ReportDocument(); if (type == "Company") { rd.Load(Path.Combine(Server.MapPath("~/Reports/FactoryBuilty.rpt"))); } else if (type == "Factory") { rd.Load(Path.Combine(Server.MapPath("~/Reports/FactoryBuilty.rpt"))); } rd.SetDataSource(ReportData); Response.Clear(); string filepath = Server.MapPath("~/" + "Builty.rpt"); rd.ExportToDisk(ExportFormatType.PortableDocFormat, filepath); FileInfo fileinfo = new FileInfo(filepath); Response.AddHeader("Content-Disposition", "inline;filenam=Builty.pdf"); Response.ContentType = "application/pdf"; Response.WriteFile(fileinfo.FullName); }
private static void LoadReportWithParameterTest() { var jednostkaId = 3; var osobaId = 1; var rpt = new ReportDocument(); rpt.Load(@"Reports\ReportWithParameter.rpt"); if (rpt.IsLoaded) { // Logowanie do bazy danych // rpt.SetDatabaseLogon("user", "password"); // Przekazanie parametru rpt.SetParameterValue("Jednostka", jednostkaId); rpt.SetParameterValue("Osoba", osobaId); if (rpt.HasSavedData) { rpt.Refresh(); } rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, "ReportWithParameter.pdf"); } rpt.Close(); rpt.Dispose(); System.Diagnostics.Process.Start("ReportWithParameter.pdf"); }
private byte[] ExportPDF(ReportDocument rpt) { string fileName = System.IO.Path.GetTempFileName(); CrystalDecisions.Shared.ExportFormatType exp = ExportFormatType.PortableDocFormat; rpt.ExportToDisk(exp, fileName); byte[] myData; using (var fs = new FileStream(fileName, FileMode.Open, FileAccess.Read)) { myData = new byte[Convert.ToInt32(fs.Length - 1) + 1]; fs.Read(myData, 0, Convert.ToInt32(fs.Length)); fs.Close(); } try { System.IO.File.Delete(fileName); } catch (Exception) { // fixme: data cleanup } return(myData); }
private static void AddImageToReportTest() { var rpt = new ReportDocument(); var path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location); var filename = path + @"\Images\sulmar.png"; rpt.Load(@"Reports\SimpleReport.rpt"); var doc = rpt.ReportClientDocument; var section = doc.ReportDefController.ReportDefinition.ReportHeaderArea.Sections[0]; var picture = doc.ReportDefController.ReportObjectController.ImportPicture(filename, section, 1, 1); rpt.SaveAs(@"Reports\AddImageReport.rpt"); rpt.ExportToDisk(ExportFormatType.PortableDocFormat, "AddImageReport.pdf"); rpt.Close(); rpt.Dispose(); System.Diagnostics.Process.Start("AddImageReport.pdf"); }
private static void LoadReportParameterMultiTest() { var rpt = new ReportDocument(); rpt.Load(@"Reports\ReportWithParameterMulti.rpt"); var departments = new ParameterValues(); departments.AddValue(1); departments.AddValue(3); departments.AddValue(4); var p1 = new ParameterDiscreteValue { Value = 5 }; departments.Add(p1); rpt.SetParameterValue("Jednostki", departments); rpt.ExportToDisk(ExportFormatType.PortableDocFormat, "ReportWithParameterMulti.pdf"); rpt.Close(); rpt.Dispose(); System.Diagnostics.Process.Start("ReportWithParameterMulti.pdf"); }
public string PrintExpense(long Id) { ReportDocument rd = new ReportDocument(); Guid id1 = Guid.NewGuid(); var pdfName = "Expense" + id1 + ".pdf"; string strRptPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + "Expense" + ".rpt"; string strPdfPath = System.Web.HttpContext.Current.Server.MapPath("~/") + "Reports\\" + pdfName; rd.Load(strRptPath); rd.Refresh(); string connectionString = ConfigurationManager.ConnectionStrings["EAharaDB"].ConnectionString; SqlConnectionStringBuilder SConn = new SqlConnectionStringBuilder(connectionString); rd.DataSourceConnections[0].SetConnection( SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password); foreach (ReportDocument srd in rd.Subreports) { srd.DataSourceConnections[0].SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password); } rd.SetParameterValue(0, Id); System.IO.File.Delete(strPdfPath); // rd.PrintOptions.PaperSize = PaperSize.PaperA5; rd.ExportToDisk(ExportFormatType.PortableDocFormat, strPdfPath); return(pdfName); }
private static void SetLocationTest() { var connectionInfo = new ConnectionInfo { ServerName = @"DESKTOP-KT89MMD\SQLEXPRESS", DatabaseName = "CrystalReportsDb", IntegratedSecurity = true, // UserID = "", // Password = "", }; var rpt = new ReportDocument(); rpt.Load(@"Reports\ReportForPeriod.rpt"); if (rpt.IsLoaded) { foreach (CrystalDecisions.CrystalReports.Engine.Table table in rpt.Database.Tables) { TableLogOnInfo logOnInfo = table.LogOnInfo; logOnInfo.ConnectionInfo = connectionInfo; table.ApplyLogOnInfo(logOnInfo); Console.WriteLine($"{table.Name}"); } rpt.ExportToDisk(ExportFormatType.CrystalReport, "SetLocationTest.rpt"); //System.Diagnostics.Process.Start("SetLocationTest.pdf"); } }
private static void LoadAndExportReportTest() { var rpt = new ReportDocument(); rpt.Load(@"Reports\JedenWierszArtykulParagraf.rpt"); if (rpt.IsLoaded) { Console.WriteLine("Report was loaded."); if (rpt.HasSavedData) { rpt.Refresh(); } rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, "report.pdf"); System.Diagnostics.Process.Start("report.pdf"); } rpt.Close(); rpt.Dispose(); }
private void materialFlatButton1_Click(object sender, EventArgs e) { try { ReportDocument rep = new ReportDocument(); string path = @"C:\PS Supermarket\Bank Transactions.pdf"; rep.Load(@"C:\PS Supermarket\Bank Transactions.rpt"); db.CrystalReportServer(rep); rep.SetParameterValue("From", txtfrom.Text); rep.SetParameterValue("To", txtto.Text); rep.SetParameterValue("Type", type); rep.SetParameterValue("Bank", txtbankidentity.Text); if (File.Exists(path)) { File.Delete(path); } rep.ExportToDisk(ExportFormatType.PortableDocFormat, path); Process.Start(path); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
protected void Button7_Click1(object sender, EventArgs e) { ReportDocument reporte = new ReportDocument(); reporte.Load(@"C:\Users\Jorge\Documents\Visual Studio 2013\WebSites\Quetzal\Reporte3.rpt"); ExportFormatType tipo = ExportFormatType.PortableDocFormat; reporte.ExportToDisk(tipo, @"C:\Users\Jorge\EmpleadosSuc.pdf"); }
protected void btnAceptar_Click(object sender, EventArgs e) { DateTime desde = new DateTime(); DateTime hasta = new DateTime(); //desde = Convert.ToDateTime(pMetodos.ConvertmmddyyyyToyyyymmdd(dpDesde.Text)); //hasta = Convert.ToDateTime(pMetodos.ConvertmmddyyyyToyyyymmdd(dpHasta.Text)); desde = Convert.ToDateTime(pMetodos.ConvertddmmyyyyToyyyymmdd(dpDesde.Text)); hasta = Convert.ToDateTime(pMetodos.ConvertddmmyyyyToyyyymmdd(dpHasta.Text)); string ctc = ddlCTC.SelectedValue; string url = "CrystalViewer.aspx?reporte=VentaTotalxCTCxCliente&ctc=" + ctc + "&desde=" + pMetodos.ConvertddmmyyyyToyyyymmdd(dpDesde.Text) + "&hasta=" + pMetodos.ConvertddmmyyyyToyyyymmdd(dpHasta.Text) +"&cliente=" + ddlClientes.SelectedValue; //ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "OpenPopUp('" + url + "');", true); ArrayList parametros = new ArrayList(); dsReportes ds = new dsReportes(); parametros.Add(desde); parametros.Add(hasta); parametros.Add(ddlClientes.SelectedValue); parametros.Add(ctc); ds.tVentaTotalCTCxCliente.Merge(conReportes.VentaTotalxCTCxCliente(parametros)); CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new ReportDocument(); rpt.FileName = Server.MapPath("~/RPT/VentaTotalxCTCxCliente.rpt"); rpt.Load(rpt.FileName, OpenReportMethod.OpenReportByDefault); rpt.SetDataSource(ds); crviewer.ReportSource = rpt; //rpt.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "ajdsfaklj"); string fileName = ddlCTC.SelectedItem.Text + "xCliente"; rpt.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath("files/" + fileName + ".pdf")); ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "desactivarSpinner();", true); ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var hidden = open('files/" + fileName + ".pdf', 'NewWindow', 'top=25,left=300,width=800, height=600,status=yes,resizable=yes,scrollbars=yes');", true); /*DataTable dt = conReportes.VentaTotalxCTCxCliente(parametros); gvListadoReporte.DataSource = dt; gvListadoReporte.DataBind(); Chart1.Visible = true; string[] x = new string[dt.Rows.Count]; int[] y = new int[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { x[i] = dt.Rows[i][0].ToString(); y[i] = Convert.ToInt32(dt.Rows[i][1]); } Chart1.Series[0].Points.DataBindXY(x, y); Chart1.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Bar;// SeriesChartType.Pie; Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true; */ }
public static bool exportReport(int type, ReportDocument repd) { SaveFileDialog f = new SaveFileDialog(); bool result = false; switch (type) { case 1: f.Filter = "Word file(*.doc)|*.doc"; if (f.ShowDialog() == DialogResult.OK) { repd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, f.FileName); result = true; } break; case 2: f.Filter = "Pdf file(*.pdf)|*.pdf"; if (f.ShowDialog() == DialogResult.OK) { repd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, f.FileName); result = true; } break; case 3: f.Filter = "Excel file(*.xls)|*.xls"; if (f.ShowDialog() == DialogResult.OK) { repd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, f.FileName); result = true; } break; default: MessageBox.Show("Không chọn đúng loại."); break; } return result; }
/// <summary> /// Сохранить отчет /// </summary> /// <param name="path">Путь к папке, куда надо сохранить отчет</param> /// <param name="reportFileName">Имя отчета</param> /// <param name="reportFileExtension">Расширение отчета</param> public void SaveReportFile(string path, string reportFileName, string reportFileExtension) { CheckDataSource(); var pathToFile = Path.Combine(path, reportFileName + "." + reportFileExtension); ReportDocument report = new ReportDocument(); string pathToReportTemplate = Path.Combine(PATH_TO_REPORTS_TEMPLATES, _reportTemplateName + ".rpt"); report.Load(pathToReportTemplate); report.SetDataSource(_dataSource as DataSet); report.ExportToDisk(GetExportFormatType(reportFileExtension), pathToFile); }
private void ATBReportForm_Load(object sender, EventArgs e) { ReportDocument cryRpt; this.debtors_summaryTableAdapter1.Fill(this.dataSet21.debtors_summary); this.customerTableAdapter1.Fill(this.dataSet21.customer); ATBReport rpt = new ATBReport(); rpt.SetDataSource(this.dataSet21); rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape; cryRpt = new ReportDocument(); cryRpt.Load(rpt.FileName.ToString()); cryRpt.SetDataSource(dataSet21); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, ReportFolder.reportFolderName + @"\AgedTrialBalance.pdf"); }
private void StatementReportForm_Load(object sender, EventArgs e) { ReportDocument cryRpt; this.customer_transTableAdapter1.FillBy1(this.dataSet2.customer_trans); this.customerTableAdapter1.Fill(this.dataSet2.customer); this.configurationTableAdapter1.Fill(this.dataSet2.configuration); this.debtors_summaryTableAdapter1.Fill(this.dataSet2.debtors_summary); StatementsReport rpt = new StatementsReport(); rpt.SetDataSource(this.dataSet2); cryRpt = new ReportDocument(); cryRpt.Load(rpt.FileName.ToString()); cryRpt.SetDataSource(dataSet2); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, ReportFolder.reportFolderName + @"\Statements.pdf"); }
private void SalesProdReportForm_Load(object sender, EventArgs e) { this.configurationTableAdapter.Fill(this.dataSet2.configuration); runCreateSummaryTable(); ReportDocument cryRpt; productSalesReportTableAdapter.Fill(this.dataSet2.ProductSalesReport); SalesProdReport rpt = new SalesProdReport(); rpt.SetDataSource(dataSet2); cryRpt = new ReportDocument(); cryRpt.Load(rpt.FileName.ToString()); cryRpt.SetDataSource(dataSet2); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, ReportFolder.reportFolderName + @"\ProductSalesDetails.pdf"); }
public string VietBaoCao() { ReportDocument rd = new ReportDocument(); if (Loaibaocao == "Thống kê chi") { string path = Directory.GetCurrentDirectory() + @"\Thống kê chi"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } try { rd.Load(Directory.GetCurrentDirectory()+ @"\CrystalReportThongKeDoanhThu.rpt"); rd.SetDataSource(DALThongKeDoanhThu.ListSachChi(Tungay, Denngay)); path = path + @"\" + Mota + ".pdf"; rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path); return path; } catch { return path = ""; } } else { string path = Directory.GetCurrentDirectory() + @"\Thống kê thu"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } try { rd.Load(Directory.GetCurrentDirectory() + @"\REPORT\CrystalReportThongKeThu.rpt"); rd.SetDataSource(DALThongKeDoanhThu.ListSachthu(Tungay, Denngay)); path = path + @"\" + Mota + ".pdf"; rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path); return path; } catch { return path = ""; } } }
private void SalesSummaryReportForm_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'dataSet2.ProductSalesSummary' table. You can move, or remove it, as needed. // DataSet2 dataSet2 = new DataSet2(); // Vectra.DataSet2TableAdapters.configurationTableAdapter configurationTableAdapter1 = new Vectra.DataSet2TableAdapters.configurationTableAdapter(); // Vectra.DataSet2TableAdapters.ProductSalesSummaryTableAdapter ProductSalesSummaryTableAdapter1 = new Vectra.DataSet2TableAdapters.ProductSalesSummaryTableAdapter(); runCreateSummaryTable(); ReportDocument cryRpt; configurationTableAdapter1.Fill(this.dataSet2.configuration); productSalesSummaryTableAdapter.Fill(this.dataSet2.ProductSalesSummary); SalesSummaryReport rpt = new SalesSummaryReport(); rpt.SetDataSource(dataSet2); cryRpt = new ReportDocument(); cryRpt.Load(rpt.FileName.ToString()); cryRpt.SetDataSource(dataSet2); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, ReportFolder.reportFolderName + @"\ProductSalesSummary.pdf"); }
private void ReceiptAndAdjReportForm_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'dataSet2.PaymentAdjustRpt' table. You can move, or remove it, as needed. this.paymentAdjustRptTableAdapter.Fill(this.dataSet2.PaymentAdjustRpt); // TODO: This line of code loads data into the 'dataSet2.configuration' table. You can move, or remove it, as needed. this.configurationTableAdapter.Fill(this.dataSet2.configuration); this.configurationTableAdapter.Fill(this.dataSet2.configuration); runCreateSummaryTable(); ReportDocument cryRpt; this.paymentAdjustRptTableAdapter.Fill(this.dataSet2.PaymentAdjustRpt); ReceiptAndAdjReport rpt = new ReceiptAndAdjReport(); rpt.SetDataSource(dataSet2); cryRpt = new ReportDocument(); cryRpt.Load(rpt.FileName.ToString()); cryRpt.SetDataSource(dataSet2); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, ReportFolder.reportFolderName + @"\ReceiptAndAdjustments.pdf"); }
public string VietBaoCao() { ReportDocument rd = new ReportDocument(); string path = Directory.GetCurrentDirectory() + @"\Thống kê tồn kho"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } try { rd.Load(Directory.GetCurrentDirectory() + @"\REPORT\CrystalReportThongKeTonKho.rpt"); rd.SetDataSource(DALThongKeTonKho.ThongKe(Tungay, Denngay)); path = path + @"\" + Mota + ".pdf"; rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path); return path; } catch { return path = ""; } }
public string ThongKeSachBan() { ReportDocument rd = new ReportDocument(); string path = Directory.GetCurrentDirectory() + @"\Thống kê sách bán được"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } try { rd.Load(Directory.GetCurrentDirectory() + @"\REPORT\CrystalReportThongKeBanDuoc.rpt"); rd.SetDataSource(DALThongKeSachBanDuoc.ThongKe(Madaily, Tungay, Denngay)); path = path + @"\" + Motafile + ".pdf"; rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path); return path; } catch { return path = ""; } }
protected void btnfile_Click(object sender, EventArgs e) { string s, m, w; DateTime frd, td; CultureInfo cf = new CultureInfo("hi-IN"); frd = Convert.ToDateTime(txtfd.Text, cf); td = Convert.ToDateTime(txttd.Text, cf); w = txtwc.Text; m = txtsc.Text; //s = "{{CDOSU.SOC}= '" + m + "' and {CR.WCC}='" + w + "'} and {{cr.regdt}>=#" + frd + "# and {cr.regdt}<=#" + td + "#}"; s = "{CDOSU.SOC}= '" + m + "' and {CR.WCC}='" + w + "' and {CR.REGDT}>=#" + frd + "# and {CR.REGDT}<=#" + td + "#"; ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("statusWise.rpt")); rpt.FileName = Server.MapPath("statusWise.rpt"); rpt.SetParameterValue("statuscd", m); rpt.SetParameterValue("wardcode", w); rpt.SetParameterValue("From", frd); rpt.SetParameterValue("To", td); rpt.RecordSelectionFormula = s; rpt.SetDatabaseLogon("scott", "tiger", "ora9i", ""); rpt.ExportToDisk(ExportFormatType.WordForWindows, "C:/crmsrpts/EIS.doc"); }
public static void btnPrint_OnClickStep( IRNReportDetails form, EventArgs args) { // TODO: Complete business rule implementation IAttachment attachment = null; string pluginid = string.Empty; Sage.Entity.Interfaces.IRNReport parentEntity = form.CurrentEntity as Sage.Entity.Interfaces.IRNReport; if (ReportsHelper.GetPluginId("RNReport:Irnreport", out pluginid)) { WebReportingClass reporting = new WebReportingClass(); Sage.Platform.Data.IDataService datasvc = MySlx.Data.CurrentConnection; Sage.Entity.Interfaces.IUser user = MySlx.Security.CurrentSalesLogixUser; string tempPath = Rules.GetTempAttachmentPath(); string ConnectionString = datasvc.GetConnectionString(); string report = reporting.GenerateReport(ConnectionString,datasvc.Server,DatabaseServer.dsMSSQL,tempPath,false,false,"RNREPORT.RNREPORTID", "", pluginid, "", "", "", "SELECT RNREPORT.RNREPORTID FROM RNREPORT", string.Format("(RNREPORT.RNREPORTID = '{0}')", parentEntity.Id), user.Id.ToString(), user.UserName.ToString()); ReportDocument doc = new ReportDocument(); report = string.Format("{0}run\\{1}", tempPath, report); doc.Load(report); string filename = string.Format("{0}\\{1}_v{2}.pdf", Rules.GetAttachmentPath(), parentEntity.ReferenceNumber.Replace(" ", "_"), 1); doc.ExportToDisk(ExportFormatType.PortableDocFormat,filename); doc.Close(); attachment = Sage.Platform.EntityFactory.Create<IAttachment>(); attachment.Description = string.Format("{0} v{1}", parentEntity.ReferenceNumber, 1); attachment.InsertFileAttachment(filename); attachment.RNREPORTID =Convert.ToString(parentEntity.Id); attachment.Save(); System.IO.File.Delete(report); } }
private void btSendConfirm_Click(object sender, EventArgs e) { try { MySqlDataReader rdr = null; string email = ""; string contact = ""; string qry = "select co.contact_email, co.contact_name from customer c inner join contact co on co.owner_id = c.id where c.id = '" + cbCustomer.Text + "' and co.contact_name = '" + cbContact.Text + "';"; rdr = MysqlInterface.DoQuery(qry); while (rdr.Read()) { if (!rdr.IsDBNull(0)) email = rdr.GetString(0); if (!rdr.IsDBNull(1)) contact = rdr.GetString(1); } string orderid = tbOrderId.Text; ReportDocument cryRpt = new ReportDocument(); string dir = System.IO.Directory.GetCurrentDirectory(); dir = "Confirmation.rpt"; cryRpt.Load(dir); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = orderid; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["orderid"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, "confirmations//confirmation-" + orderid + ".pdf"); Outlook.Application outlookApp = new Outlook.Application(); Outlook.MailItem mailItem = (Outlook.MailItem)outlookApp.CreateItem(Outlook.OlItemType.olMailItem); string directory = Directory.GetCurrentDirectory(); orderid = tbOrderId.Text; string po = tbCustPO.Text; directory = directory + "\\confirmations\\confirmation-" + orderid + ".pdf"; mailItem.Attachments.Add(directory); mailItem.Subject = "Pinnacle Glass Doors - Confirmation# " + orderid + " - PO# " + po; mailItem.To = email; string name = contact; if (contact != "") { int pos = name.IndexOf(' '); if (pos != -1) name = name.Substring(0, pos); } mailItem.Body = "Hi " + name + ",\n\n" + "Attached is a confirmation of your purchase order " + po + "." + "\n\nThank You,\n\n" + Globals.USER_NAME; mailItem.Importance = Outlook.OlImportance.olImportanceNormal; try { mailItem.Display(true); } catch (Exception) { } //crystalReportViewer1.ReportSource = cryRpt; //crystalReportViewer1.RefreshReport(); } catch (LogOnException) { MessageBox.Show("Incorrect Logon Parameters. Check your user name and password."); } catch (DataSourceException) { MessageBox.Show("An error has occurred while connecting to the database."); } catch (EngineException ex) { MessageBox.Show(ex.Message); } }
private void SendPO() { try { MySqlDataReader rdr = null; string email = ""; string contact = ""; string qry = "select c.email, c.contact from vendor c where c.ID = '" + cbVendor.Text + "';"; rdr = MysqlInterface.DoQuery(qry); while (rdr.Read()) { email = rdr.GetString(0); contact = rdr.GetString(1); } string orderid = tbOrderId.Text; ReportDocument cryRpt = new ReportDocument(); string dir = System.IO.Directory.GetCurrentDirectory(); dir = "PurchaseOrder.rpt"; cryRpt.Load(dir); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = orderid; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["order_id"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, "pos//po-" + orderid + ".pdf"); Outlook.Application outlookApp = new Outlook.Application(); Outlook.MailItem mailItem = (Outlook.MailItem)outlookApp.CreateItem(Outlook.OlItemType.olMailItem); string directory = System.IO.Directory.GetCurrentDirectory(); orderid = tbOrderId.Text; directory = directory + "\\pos\\po-" + orderid + ".pdf"; mailItem.Attachments.Add(directory); mailItem.Subject = "Pinnacle Glass Doors - Purchase Order# " + orderid; mailItem.To = email; string name = contact; if (contact != "") { int pos = name.IndexOf(' '); if (pos != -1) name = name.Substring(0, pos); } mailItem.Body = "Hi " + name + ",\n\n" + "Please see the attached purchase order. Please confirm pricing and ship date." + "\n\nThank You,\n\n" + Globals.USER_NAME; mailItem.Importance = Outlook.OlImportance.olImportanceNormal; mailItem.Display(true); } catch (LogOnException) { MessageBox.Show("Incorrect Logon Parameters. Check your user name and password."); } catch (DataSourceException) { MessageBox.Show("An error has occurred while connecting to the database."); } catch (EngineException ex) { MessageBox.Show(ex.Message); } }
private void btSendQuote_Click(object sender, EventArgs e) { try { MySqlDataReader rdr = null; string email = ""; string contact = ""; string qry = "select c.email, c.contact from customer c where c.ID = '" + cbCustomer.Text + "';"; rdr = MysqlInterface.DoQuery(qry); while (rdr.Read()) { email = rdr.GetString(0); contact = rdr.GetString(1); } string orderid = tbOrderId.Text; ReportDocument cryRpt = new ReportDocument(); string dir = System.IO.Directory.GetCurrentDirectory(); dir = "Quote.rpt"; cryRpt.Load(dir); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = orderid; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["orderid"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, "quotations//quote-" + orderid + ".pdf"); Outlook.Application outlookApp = new Outlook.Application(); Outlook.MailItem mailItem = (Outlook.MailItem)outlookApp.CreateItem(Outlook.OlItemType.olMailItem); string directory = Directory.GetCurrentDirectory(); orderid = tbOrderId.Text; directory = directory + "\\quotations\\quote-" + orderid + ".pdf"; mailItem.Attachments.Add(directory); mailItem.Subject = "Pinnacle Glass Doors - Quote# " + orderid; mailItem.To = email; string name = contact; if (contact != "") { int pos = name.IndexOf(' '); if (pos != -1) name = name.Substring(0, pos); } mailItem.Body = "Hi " + name + ",\n\n" + "Here is the quote you requested. Please let me know if you would like to proceed with the order" + "\n\nThank You,\n\n" + Globals.USER_NAME; mailItem.Importance = Outlook.OlImportance.olImportanceNormal; mailItem.Display(true); //crystalReportViewer1.ReportSource = cryRpt; //crystalReportViewer1.RefreshReport(); } catch (LogOnException) { MessageBox.Show("Incorrect Logon Parameters. Check your user name and password."); } catch (DataSourceException) { MessageBox.Show("An error has occurred while connecting to the database."); } catch (EngineException ex) { MessageBox.Show(ex.Message); } }
protected string rutaAnexo(String incorporacionID, String consultoraID) { string nombre = "C:\\Reportes\\solicitud_de_credito_" + DateFormatter.getTimestamp(DateTime.Now) + ".pdf"; String db_databaseName = connectionBL.getDataBaseName(); String db_serverName = connectionBL.getServerName(); String db_userID = connectionBL.getUserID(); String db_password = connectionBL.getPassword(); ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("../CrystalReports/rcSolicitudCredito.rpt")); rpt.SetDatabaseLogon("", "", ".", db_databaseName); rpt.SetParameterValue("@incorporacionID", Convert.ToInt32(incorporacionID)); rpt.ExportToDisk(ExportFormatType.PortableDocFormat, nombre); return nombre; }
public static PayslipDocument ExportStaffPayslip(int payslip, string company) { string path = Properties.Settings.Default.ExportPath; string cString = Properties.Settings.Default.DB; SqlConnection objCon = new SqlConnection(cString); SqlCommand objCmd = null; SqlDataAdapter objAdapter = null; DataSet ds = null; PayslipDocument meta = new PayslipDocument(); try { objCon.Open(); objCmd = new SqlCommand("GetStaffPayslip", objCon); objCmd.CommandType = CommandType.StoredProcedure; objCmd.Parameters.Add("@PayslipID", SqlDbType.Int).Value = payslip; objCmd.Parameters.Add("@Company", SqlDbType.VarChar, 12).Value = company; // Create a SqlDataAdapter. objAdapter = new SqlDataAdapter(); objAdapter.SelectCommand = objCmd; ds = new DataSet("PaySlip"); objAdapter.Fill(ds); objCon.Close(); ds.Tables[0].TableName = "FUNC_DP"; ds.Tables[1].TableName = "FUNC_VENC"; ds.Tables[2].TableName = "Recibos"; ds.Tables[3].TableName = "RecibosDetalhes"; ds.Tables[4].TableName = "Seguros"; ds.Tables[5].TableName = "SegurancaSocial"; if (path[path.Length - 1] != '\\') path += "\\GRH\\"; else path += "GRH\\"; path += ds.Tables[2].Rows[0].ItemArray[1] + "-" + Convert.ToString(ds.Tables[2].Rows[0].ItemArray[2]).PadLeft(2, '0') + "\\"; if (!Directory.Exists(path)) Directory.CreateDirectory(path); meta.NIF = ds.Tables["FUNC_DP"].Rows[0].ItemArray[1].ToString(); meta.RecordID = Convert.ToInt32(ds.Tables["Recibos"].Rows[0].ItemArray[5]); meta.Date = new DateTime(Convert.ToInt32(ds.Tables["Recibos"].Rows[0].ItemArray[1]), Convert.ToInt32(ds.Tables["Recibos"].Rows[0].ItemArray[2]), 1); meta.Description = ds.Tables["Recibos"].Rows[0].ItemArray[1].ToString() + '/' + ds.Tables["Recibos"].Rows[0].ItemArray[2].ToString().PadLeft(2, '0') + ' ' + ds.Tables["Recibos"].Rows[0].ItemArray[3].ToString(); meta.SystemName = "GRH"; meta.MetaPath = path + payslip + ".xml"; meta.DocumentPath = path + payslip + ".pdf"; if (File.Exists(meta.MetaPath)) File.Delete(meta.MetaPath); if (File.Exists(meta.DocumentPath)) File.Delete(meta.DocumentPath); using (ReportDocument cryRpt = new ReportDocument()) { cryRpt.Load(Properties.Settings.Default.PayslipStaff); // Show corporate image cryRpt.ReportDefinition.ReportObjects["Picture1"].ObjectFormat.EnableSuppress = false; cryRpt.ReportDefinition.ReportObjects["Text1"].ObjectFormat.EnableSuppress = false; cryRpt.ReportDefinition.ReportObjects["Text19"].ObjectFormat.EnableSuppress = false; // set the data source of the report cryRpt.SetDataSource(ds); cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, meta.DocumentPath); } meta.SaveMetadata(meta.MetaPath); return meta; } finally { if (ds != null) ds.Dispose(); if (objAdapter != null) objAdapter.Dispose(); if (objCmd != null) objCmd.Dispose(); if (objCon != null) { if(objCon.State != ConnectionState.Closed) objCon.Close(); objCon.Dispose(); } } }
public string ExportReportToPDF(string reportName) { string pdfFile = string.Empty; if (reportName.Equals(string.Empty)) { Log("ExportReportToPDF - Param [reportName] must have a value."); } else { ReportDocument reportDocument = new ReportDocument(); try { reportDocument.Load(Settings.LocalReportFolder + reportName); SetCrystalReportLogon(reportDocument); pdfFile = GetNewPDFFileName(); if (HasParameterSetNameArg) CreateParameterCollection(reportDocument.ParameterFields); reportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, pdfFile); } catch (Exception ex) { Log(ex.ToString()); } finally { reportDocument.Dispose(); } } return pdfFile; }
protected string rutaAnexoReingreso(int reingresoID) { ConnectionBL connectionBL = new ConnectionBL(); string nombre = "C:\\Reportes\\Reingreso_" + DateFormatter.getTimestamp(DateTime.Now) + ".pdf"; String db_databaseName = connectionBL.getDataBaseName(); String db_serverName = connectionBL.getServerName(); String db_userID = connectionBL.getUserID(); String db_password = connectionBL.getPassword(); ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("../CrystalReports/crReingreso.rpt")); rpt.SetDatabaseLogon("", "", ".", db_databaseName); rpt.SetParameterValue("@reingresoID", reingresoID); rpt.ExportToDisk(ExportFormatType.PortableDocFormat, nombre); return nombre; }
public string GenerateInvoice(int id) { string exportFilePath = null; #region Get System Parameters string Comp_68_Title = this._db.recsys_system_parameter.Where(sp => sp.name == "company_eng_name_68").Select(sp => sp.value).FirstOrDefault(); string Comp_28_Title = this._db.recsys_system_parameter.Where(sp => sp.name == "company_eng_name_28").Select(sp => sp.value).FirstOrDefault(); string Comp_68_CTitle = this._db.recsys_system_parameter.Where(sp => sp.name == "company_chi_name_68").Select(sp => sp.value).FirstOrDefault(); string Comp_28_CTitle = this._db.recsys_system_parameter.Where(sp => sp.name == "company_chi_name_28").Select(sp => sp.value).FirstOrDefault(); string Comp_Address = this._db.recsys_system_parameter.Where(sp => sp.name == "company_eng_address").Select(sp => sp.value).FirstOrDefault(); string Comp_CAddress = this._db.recsys_system_parameter.Where(sp => sp.name == "company_chi_address").Select(sp => sp.value).FirstOrDefault(); string Comp_Tel = this._db.recsys_system_parameter.Where(sp => sp.name == "company_tel").Select(sp => sp.value).FirstOrDefault(); string Comp_Fax = this._db.recsys_system_parameter.Where(sp => sp.name == "company_fax").Select(sp => sp.value).FirstOrDefault(); string Comp_Hotline = this._db.recsys_system_parameter.Where(sp => sp.name == "company_service_hotline").Select(sp => sp.value).FirstOrDefault(); string Comp_Subsidiary = "(A wholly-owned subsidiary of Yau Lee Holding Limited)"; #endregion Get System Parameters #region Get Quotation double? quotationItemAmountTotal = (from qi in this._db.recsys_quotation_items join r in this._db.recsys_relate on qi.id equals r.id2 where r.table1 == "quotation" && r.table2 == "quotation_items" && r.id1 == id && qi.price != null select qi.price).Sum(); var quotationItems = (from q in this._db.recsys_quotation join rc in this._db.recsys_relate_customers on q.customer_id equals rc.id into subrc from rc2 in subrc.DefaultIfEmpty() join qi in (from r in this._db.recsys_relate join qi in this._db.recsys_quotation_items on r.id2 equals qi.id into subqi from qi2 in subqi.DefaultIfEmpty() where r.table1 == "quotation" && r.table2 == "quotation_items" && r.id1 == id select new { q_id = r.id1, nSequence = qi2.nSequence, id = qi2.id, code = qi2.code, detail = qi2.detail, detail2 = qi2.detail2, price = qi2.price }) on q.id equals qi.q_id where q.id == id select new { center = rc2.center, tender_number = q.tender_number, minor_work = q.minor_work, invoice = q.invoice, invoice_date = q.invoice_date, dummy_date = q.dummy_date, dummy = q.dummy, initial = q.initial, customer_name = rc2.name, address1 = rc2.address1, address2 = rc2.address2, contact = rc2.contact, email = rc2.email, tel1 = rc2.tel1, tel2 = rc2.tel2, fax1 = rc2.fax1, fax2 = rc2.fax2, sequence = qi.nSequence, detail = q.lang == 1 ? qi.detail : qi.detail2, price = qi.price.HasValue ? qi.price.Value : 0, lang = q.lang }).ToList(); ArrayList rptSource = new ArrayList(); foreach (var quotationItem in quotationItems) { InvoiceCrystalReportModel model = new InvoiceCrystalReportModel { Comp_Title = quotationItem.center == "28" ? Comp_28_Title : Comp_68_Title, Comp_CTitle = quotationItem.center == "28" ? Comp_28_CTitle : Comp_68_CTitle, Comp_Address = Comp_Address, Comp_CAddress = Comp_CAddress, Comp_Tel = ": " + Comp_Tel, Comp_Fax = ": " + Comp_Fax, Comp_Hotline = ": " + Comp_Hotline, Comp_Subsidiary = Comp_Subsidiary, invoice_no = string.Format("{0}{1}", quotationItem.dummy == 1 ? "INV-Q" + id : quotationItem.invoice, (string.IsNullOrEmpty(quotationItem.minor_work) ? string.Empty : " /E" + quotationItem.minor_work)), nSeq = quotationItem.sequence.HasValue ? quotationItem.sequence.Value.ToString().PadLeft(2, '0') : string.Empty, invoice_date = quotationItem.invoice_date.HasValue ? quotationItem.invoice_date.Value.ToString("dd-MMM-yy", CultureInfo.CreateSpecificCulture("en-US")) : string.Empty, dummy_date = quotationItem.dummy_date.HasValue ? quotationItem.dummy_date.Value.ToString("dd-MMM-yy", CultureInfo.CreateSpecificCulture("en-US")) : string.Empty, customer_name = quotationItem.customer_name, address1 = quotationItem.address1, address2 = quotationItem.address2 + (string.IsNullOrEmpty(quotationItem.tender_number) ? string.Empty : " (" + quotationItem.tender_number + ")"), contact = quotationItem.contact, tel1 = string.IsNullOrEmpty(quotationItem.tel1) ? string.IsNullOrEmpty(quotationItem.tel2) ? string.Empty : quotationItem.tel2 : string.IsNullOrEmpty(quotationItem.tel2) ? quotationItem.tel1 : quotationItem.tel1 + " / " + quotationItem.tel2, fax1 = string.IsNullOrEmpty(quotationItem.fax1) ? string.IsNullOrEmpty(quotationItem.fax2) ? string.Empty : quotationItem.fax2 : string.IsNullOrEmpty(quotationItem.fax2) ? quotationItem.fax1 : quotationItem.fax1 + " / " + quotationItem.fax2, detail = quotationItem.detail, price = quotationItem.price, price_total = quotationItemAmountTotal.HasValue ? quotationItemAmountTotal.Value : 0, email = quotationItem.email, initial = quotationItem.initial, lang = quotationItem.lang }; rptSource.Add(model); } #endregion Get Quotation if (quotationItems != null && quotationItems.Count() > 0) { ReportDocument rd = new ReportDocument(); try { string strRptPath = Server.MapPath("~/Report/Invoice.rpt"); string shareDriveRootFolderPath = ConfigurationManager.AppSettings["ShareRootFolderPath"].ToString(); string invoiceTempFolder = shareDriveRootFolderPath + @"\Invoice\Temp\"; if (!Directory.Exists(invoiceTempFolder)) { Directory.CreateDirectory(invoiceTempFolder); } exportFilePath = invoiceTempFolder + Guid.NewGuid() + ".pdf"; rd.Load(strRptPath); rd.SetDataSource(rptSource); //Stream stream = rd.ExportToStream(ExportFormatType.PortableDocFormat); rd.ExportToDisk(ExportFormatType.PortableDocFormat, exportFilePath); } catch { exportFilePath = null; } finally { rd.Dispose(); } } return exportFilePath; }
protected void ddlTerm_SelectedIndexChanged(object sender, EventArgs e) { if (ddlGrade.SelectedIndex == 0) { lblError.ForeColor = Color.Red; lblError.Text = "Please Select Grade"; } else if (ddlClass.SelectedIndex == 0) { lblError.ForeColor = Color.Red; lblError.Text = "Please Select Class"; } else if (ddlStudentName.SelectedIndex == 0) { lblError.ForeColor = Color.Red; lblError.Text = "Please Select Student"; } else if (ddlTerm.SelectedIndex == 0) { lblError.ForeColor = Color.Red; lblError.Text = "Please Select Term"; } else { lblError.Text = ""; //if error Fixed remove error Messege ParameterDiscreteValue crtparamDiscValue; ParameterField crtParamField; ParameterFields crtParamFields; crtparamDiscValue = new ParameterDiscreteValue(); crtParamField = new ParameterField(); crtParamFields = new ParameterFields(); crtparamDiscValue.Value = adNo; crtParamField.ParameterFieldName = "adno"; crtParamField.CurrentValues.Add(crtparamDiscValue); crtParamFields.Add(crtParamField); crtparamDiscValue.Value = ddlGrade.SelectedIndex; crtParamField.ParameterFieldName = "grade"; crtParamField.CurrentValues.Add(crtparamDiscValue); crtParamFields.Add(crtParamField); crtparamDiscValue.Value = ddlTerm.SelectedIndex; crtParamField.ParameterFieldName = "term"; crtParamField.CurrentValues.Add(crtparamDiscValue); crtParamFields.Add(crtParamField); crtparamDiscValue.Value = ddlClass.SelectedValue; crtParamField.ParameterFieldName = "class"; crtParamField.CurrentValues.Add(crtparamDiscValue); crtParamFields.Add(crtParamField); crvReportViewer.ParameterFieldInfo = crtParamFields; //Create report document ReportDocument crystalReport = new ReportDocument(); //Load crystal report made in design view crystalReport.Load(Server.MapPath("Reports/NewStudentAcaPerf.rpt")); //Set DataBase Login Info crystalReport.SetDatabaseLogon("root", "123", @"localhost", "nsis"); //Provide parameter values crystalReport.SetParameterValue("adno", adNo); crystalReport.SetParameterValue("grade", ddlGrade.SelectedIndex); crystalReport.SetParameterValue("term", ddlTerm.SelectedIndex); crystalReport.SetParameterValue("class", ddlClass.SelectedIndex); crystalReport.SetParameterValue("padno", adNo); crystalReport.SetParameterValue("pgrade", ddlGrade.SelectedIndex); crystalReport.SetParameterValue("pterm", ddlTerm.SelectedIndex); crystalReport.SetParameterValue("pclass", ddlClass.SelectedValue); crystalReport.SetParameterValue("mgrade", ddlGrade.SelectedIndex); crystalReport.SetParameterValue("mterm", ddlTerm.SelectedIndex); crystalReport.SetParameterValue("mclass", ddlClass.SelectedValue); //Guid.NewGuid().ToString() string filename = System.IO.Path.GetTempPath() + adNo + ".pdf"; crystalReport.ExportToDisk(ExportFormatType.PortableDocFormat, filename); crvReportViewer.ReportSource = crystalReport; } }
private void btnGuardar_Click(object sender, EventArgs e) { string cliente = txtCliente.Text; if(cliente.Equals("")) { MessageBox.Show("Falta datos del Cliente", "Mensaje de advertencia"); } else { for (int count = 0; count < dataGridViewFactura.Rows.Count; count++) { string codigo = (string)dataGridViewFactura.Rows[count].Cells["columnProducto"].Value; contador = contador + 1; } if(contador >=1) { Console.Write("contador es " + contador); if (consumidorF == true) { txtCliente.Text = ""; txtRUC.Text = ""; txtDireccion.Text = ""; txtTelefono.Text = ""; dataGridViewProducto.ClearSelection(); dataGridViewFactura.Rows.Clear(); txtSubTotal.Text = ""; txtIva.Text = ""; txtTotal.Text = ""; rbFactura.Enabled = false; rbConsumidorFinal.Enabled = false; rbCodigo.Enabled = false; rbProducto.Enabled = false; txtBusqueda.Enabled = false; dataGridViewProducto.Enabled = false; btnGuardar.Enabled = false; btnAgregarProducto.Enabled = false; txtCantidad.Enabled = false; txtEmpleado.Text = Login.ROL; consumidorF = false; } else { contador = 0; // es una factura ced = txtRUC.Text; numFactura = num; Console.Write("num fact "+numFactura); cedEmpleado = MetodosBD.retornaCedulaEmpleado(txtEmpleado.Text); subT = Convert.ToDouble(txtSubTotal.Text); I = Convert.ToDouble(txtIva.Text); T = Convert.ToDouble(txtTotal.Text); string cod=""; string prod=""; int cant =0; double precio=0; double total=0; MetodosBD.InsertarFacturaC(numFactura, ced, cedEmpleado, fechaActual, subT, I, T, false); for (int count = 0; count < dataGridViewFactura.Rows.Count; count++) { cod = (string)dataGridViewFactura.Rows[count].Cells["columnProducto"].Value; prod= MetodosBD.buscarCodigoProducto(cod); cant = (int)dataGridViewFactura.Rows[count].Cells["columnCantidad"].Value; precio = (double)dataGridViewFactura.Rows[count].Cells["columnPrecioUnit"].Value; total = (double)dataGridViewFactura.Rows[count].Cells["columnTotal"].Value; MetodosBD.InsertarDetalleFactura(numFactura, prod, cant, precio, total); } string n = lblNumFact.Text; // aqui obtengo el numero de factura FormFacturaC form = new FormFacturaC(); ReportDocument oRep = new ReportDocument(); ParameterField pf = new ParameterField(); ParameterFields pfs = new ParameterFields(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pf.Name = "@numFact"; pdv.Value = n; pf.CurrentValues.Add(pdv); pfs.Add(pf); form.crystalReportViewer1.ParameterFieldInfo = pfs; oRep.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteFacturaCliente2.rpt"); oRep.ExportToDisk(ExportFormatType.PortableDocFormat, @"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\Facturas\Factura Nro."+ n +".pdf"); form.crystalReportViewer1.ReportSource = oRep; form.Show(); txtCliente.Text = ""; txtRUC.Text = ""; txtDireccion.Text = ""; txtTelefono.Text = ""; lblNumFact.Text = ""; dataGridViewProducto.ClearSelection(); dataGridViewFactura.Rows.Clear(); txtSubTotal.Text = ""; txtIva.Text = ""; txtTotal.Text = ""; rbFactura.Enabled = false; rbConsumidorFinal.Enabled = false; rbCodigo.Enabled = false; rbProducto.Enabled = false; txtBusqueda.Enabled = false; dataGridViewProducto.Enabled = false; btnGuardar.Enabled = false; btnAgregarProducto.Enabled = false; txtCantidad.Enabled = false; txtEmpleado.Text = Login.ROL; consumidorF = false; urlEnvio = "C:\\Users\\Usuario\\Documents\\GitHub\\ProyectoProgramacion5\\Facturas\\Factura Nro." + n + ".pdf"; //creamos nuestro objeto de la clase que hicimos email = MetodosBD.buscarEmailCliente(txtRUC.Text); btnEnviar.Enabled = true; EnviarMail oMail = new EnviarMail(); bool resultado = oMail.enviarCorreo("Gracias por comprar Att. Code Enterprise ", "Facturacion", email, urlEnvio); if (resultado) { MessageBox.Show("Mensaje enviado"); } else { MessageBox.Show("Mensaje no enviado"); } } } else { MessageBox.Show("Falta datos de Productos", "Mensaje de advertencia"); } } }
protected string rutaAnexoSeguimiento(String ConsultoraCodigo) { ConnectionBL connectionBL = new ConnectionBL(); string nombre = "C:\\Reportes\\Seguimiento_" + DateFormatter.getTimestamp(DateTime.Now) + ".pdf"; String db_databaseName = connectionBL.getDataBaseName(); String db_serverName = connectionBL.getServerName(); String db_userID = connectionBL.getUserID(); String db_password = connectionBL.getPassword(); ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("../CrystalReports/crSeguimiento.rpt")); rpt.SetDatabaseLogon("", "", ".", db_databaseName); rpt.SetParameterValue("@ConsultoraCodigo", Convert.ToInt32(ConsultoraCodigo)); rpt.ExportToDisk(ExportFormatType.PortableDocFormat, nombre); return nombre; }
protected void imgbtnVistaPreviaReporteVolumetrias_Click(object sender, EventArgs e) { //Parametros del store procedure string strID = Cookies.GetCookie("cookieEditarVolumetria").Value; string strPreciario = Cookies.GetCookie("cookiePreciario").Value; string path = AppDomain.CurrentDomain.BaseDirectory; //1. Configurar la conexión y el tipo de comando SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["OSEF"].ConnectionString); try { using (var comando = new SqlCommand("web_spS_ObtenerCambiosPreciarioPorVolumetria", conn)) { using (var adaptador = new SqlDataAdapter(comando)) { DataTable dt = new DataTable(); adaptador.SelectCommand.CommandType = CommandType.StoredProcedure; adaptador.SelectCommand.Parameters.Add(@"idpreciario", SqlDbType.NVarChar).Value = strPreciario; adaptador.SelectCommand.Parameters.Add(@"Volumetria", SqlDbType.Int).Value = Convert.ToInt32(strID); adaptador.Fill(dt); var reporte = new ReportDocument(); reporte.Load(Server.MapPath("reportess/CPreciarioV.rpt")); reporte.SetDataSource(dt); reporte.SetParameterValue("path", path); reporte.SetParameterValue("pathlogo", path + "\\images\\clientes\\"); reporte.SetParameterValue("pathlogopro", path + "\\images\\proveedores\\"); string strDireccion = Server.MapPath(" ") + "\\reportess\\Volumetrias\\" + strID; //2. Validar si existe el directorio donde se guardaran if (Directory.Exists(strDireccion)) { reporte.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath("reportess/Volumetrias/" + strID + "/Volumetria " + strID + ".pdf")); ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var popup=window.open('reportess/Volumetrias/" + strID + "/Volumetria " + strID + ".pdf',null,'height=700,width=660');popup.focus();", true); // reporte.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "Resumen de OC: "); } else { Directory.CreateDirectory(strDireccion); reporte.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath("reportess/Volumetrias/" + strID + "/Volumetria " + strID + ".pdf")); ClientScript.RegisterStartupScript(this.Page.GetType(), "popupOpener", "var popup=window.open('reportess/Volumetrias/" + strID + "/Volumetria " + strID + ".pdf',null,'height=700,width=660');popup.focus();", true); } reporte.Dispose(); reporte.Close(); } // end using adaptador } // end using comando } catch (Exception ex) { ex.Message.ToString(); } finally { if (conn.State != ConnectionState.Closed) conn.Close(); conn.Dispose(); } }