protected void btnImprimir_Click(object sender, EventArgs e) { string Ciclo = this.ddlCiclo.SelectedValue; int Zona = int.Parse(this.ddlZonas.SelectedValue); int PlantelID = int.Parse(this.ddlPlanteles.SelectedValue); byte Turno = byte.Parse(this.ddlTurnos.SelectedValue); int Estatus = int.Parse(ddlEstatus.SelectedValue); string NomPlantel = this.ddlPlanteles.SelectedItem.Text; db = new DBEscolarDataContext(); var res = (from A in db.vwRPTEstadisticaPreInscritos011s where A.Ciclo == Ciclo && A.Zona == Zona && A.PlantelID == PlantelID && A.Turno == (Turno == 0 ? A.Turno : Turno) && A.Estatus == (Estatus == -1 ? A.Estatus : Estatus) orderby A.Zona, A.Plantel, A.Turno, A.Nombre select A).ToList(); this.lblMensaje.Visible = res.Count() == 0; if (res.Count() == 0) return; ReportDocument rptDoc = new ReportDocument(); rptDoc.Load(Server.MapPath("../Reportes/rptEstPre01.rpt")); rptDoc.SetDataSource(res); rptDoc.SetParameterValue("NomPlantel", NomPlantel); MemoryStream stream = (MemoryStream)rptDoc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); rptDoc.Close(); rptDoc.Dispose(); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "inline; filename=Alumnos.xls"); Response.BinaryWrite(stream.ToArray()); Response.End(); stream.Close(); stream.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { try { DataTable _dtCabeceraOper = null; DataTable _dtDetalleOper = null; _dtCabeceraOper = (DataTable)Session["dtCabeceraOperacion"]; _dtDetalleOper = CopiarDT(g_dtDetOperacion); _dtDetalleOper = CambiarMonedaDetOperacion(_dtDetalleOper); if (_dtDetalleOper != null && _dtCabeceraOper != null) { if (_dtDetalleOper.Rows.Count != 0) { ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("rpt/crFactura.rpt")); rpt.FileName = Server.MapPath("rpt/crFactura.rpt"); rpt.SetDataSource(_dtCabeceraOper); rpt.Subreports[0].SetDataSource(_dtDetalleOper); CrystalReportViewer1.ReportSource = rpt; CrystalReportViewer1.ReuseParameterValuesOnRefresh = true; // bloque de código donde exportamos el reporte a pdf directamente using (var mStream = (MemoryStream)rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)) { Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(mStream.ToArray()); } Response.End(); } } } catch (Exception ex) { throw ex; } }
protected void CriaPDF() { Hashtable hash = (Hashtable)Session["HashSolicitacoes"]; DSCabecalhoSolicitacaoAmbulatorial cabecalho = new DSCabecalhoSolicitacaoAmbulatorial(); cabecalho.Tables.Add((DataTable)hash["cabecalho"]); DSRelatorioSolicitacaoAmbulatorial conteudo = new DSRelatorioSolicitacaoAmbulatorial(); conteudo.Tables.Add((DataTable)hash["corpo"]); Session.Remove("HashSolicitacoes"); ReportDocument repDoc = new ReportDocument(); repDoc.Load(Server.MapPath("RelatoriosCrystal/CrystalReportViewer_SolicitacaoAmbulatorial.rpt")); repDoc.SetDataSource(conteudo.Tables[1]); repDoc.Subreports["CrystalReportViewer_CabecalhoSolicitacaoAmbulatorial.rpt"].SetDataSource(cabecalho.Tables[1]); System.IO.Stream s = repDoc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/octet-stream"; Response.AddHeader("content-disposition", "attachment; filename=RelatorioSolicitacaoAmbulatorial.pdf"); Response.AddHeader("content-length", ((System.IO.MemoryStream)s).ToArray().Length.ToString()); Response.BinaryWrite(((System.IO.MemoryStream)s).ToArray()); Response.End(); //Response.Flush(); //Response.Close(); }
protected void Page_Load(object sender, EventArgs e) { String qs = Request.QueryString.Get("bid"); Response.Write("Query String = " + qs); SqlConnection sql = new SqlConnection(); sql.ConnectionString = "Data Source=(local);Initial Catalog=Hotel;Integrated Security=True"; sql.Open(); ReportDocument rpd = new ReportDocument(); rpd.Load(Server.MapPath("itcreport.rpt")); rpd.SetDatabaseLogon("sa", "ak"); rpd.SetParameterValue(0, qs); CrystalReportViewer1.ReportSource = rpd; //to convert report in pdf format MemoryStream ostream = new MemoryStream(); Response.Clear(); Response.Buffer = true; ostream = (MemoryStream)rpd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rpd.Close(); rpd.Dispose(); Response.ContentType = "application/pdf"; Response.BinaryWrite(ostream.ToArray()); ostream.Flush(); ostream.Close(); ostream.Dispose(); }
private void DivSchedule() { string strExportFile = null; strExportFile = Session["Report"].ToString(); ReportDocument crReportDocument = default(ReportDocument); crReportDocument = new ReportDocument(); crReportDocument.Load(Server.MapPath(Session["Report"].ToString())); CSBC.Components.Season.ClsSchedules oData = new CSBC.Components.Season.ClsSchedules(); //Pass the populated dataset to the report crReportDocument.SetDataSource(oData.GetGames(1, 1, Convert.ToInt32(Session["ScheduleNo"]), Convert.ToInt32(Session["TeamNbr"]), Session["ScheduleDesc"].ToString(), Session["TeamName"].ToString())); crReportDocument.SetParameterValue("SeasonDesc", Session["SeasonDesc"]); crReportDocument.SetParameterValue("CompanyName", Session["CompanyName"]); crReportDocument.SetParameterValue("TeamName", Session["TeamName"]); crReportDocument.SetParameterValue("Division", Session["ScheduleDesc"]); System.IO.MemoryStream s = (MemoryStream) crReportDocument.ExportToStream(ExportFormatType.PortableDocFormat); var _with1 = HttpContext.Current.Response; _with1.ClearContent(); _with1.ClearHeaders(); _with1.ContentType = "application/pdf"; _with1.AddHeader("Content-Disposition", "inline; filename=" + strExportFile); _with1.BinaryWrite(s.ToArray()); _with1.End(); //CrystalReportViewer1.ReportSource = crReportDocument crReportDocument = null; oData = null; }
public ActionResult ExportReport() { List<Investment> allInvestment = new List<Investment>(); using (efarmingEntities dc = new efarmingEntities()) { allInvestment = dc.Investments.ToList(); } ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "rpt_InvestmentList.rpt")); rd.SetDataSource(allInvestment); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return File(stream, "application/pdf", "InvestmentList.pdf"); } catch (Exception) { throw; } }
private void bindReport() { if (Convert.ToString(Session[Global.SESSION_KEY_CULTURE]) == "ar-AE") { dt = RL.PrintMaterListEnglish(); } else { dt = RL.PrintMaterListEnglish(); } if (dt.Rows.Count > 0) { ReportDocument report = new ReportDocument(); report.Load(Server.MapPath("..//..//Reports//PrintAllMatter.rpt")); report.SetDataSource(dt); // report.Refresh(); //CrystalReportViewer1.ReportSource = report; MemoryStream oStream = new MemoryStream(); // using System.IO oStream = (MemoryStream)report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(oStream.ToArray()); Response.End(); } }
/// <summary> /// Erzeugt aus einer CrystalReportsDatei oder einem PDF einen PDF Stream und sendet ihn an den Client /// </summary> /// <param name="pin_ReportVorlage">Pfad der Vorlage</param> /// <param name="pin_ReportAuswahl">reportspezifische Daten</param> /// <returns>Stream der ein PDF enthält</returns> public Stream ErzeugeReport(string pin_ReportVorlage, string pin_ReportAuswahl) { if (pin_ReportVorlage.Substring(pin_ReportVorlage.LastIndexOf(".") + 1) == "pdf") { // Umwandeln des PDF Vordrucks in einen Stream FileStream Report = new FileStream(Directory.GetCurrentDirectory() + pin_ReportVorlage, System.IO.FileMode.Open, System.IO.FileAccess.Read); byte[] Buffer = new byte[(int)Report.Length]; Report.Read(Buffer, 0, (int)Report.Length); Report.Close(); // Versenden der Daten als MemoryStream System.Windows.Forms.MessageBox.Show("Schicke Raus !!"); return new MemoryStream(Buffer, 0, Buffer.Length); } else { // Erstellen eines Reports ReportDocument Report = new ReportDocument(); // Lade Reportvorlage Report.Load(Directory.GetCurrentDirectory() + pin_ReportVorlage); // Besondere SELECT Anfrage auf den Datensatz anwenden if (pin_ReportAuswahl != String.Empty) Report.DataDefinition.RecordSelectionFormula = pin_ReportAuswahl; // muss als Stream übertragen werden, da ReportDocuments nicht Serializable sind return Report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); } }
private void CriaPDF() { Hashtable hashtable = (Hashtable)Session["HashAgendaMontadaPublicada"]; DSCabecalhoAgendaMontadaPublicada cabecalho = new DSCabecalhoAgendaMontadaPublicada(); cabecalho.Tables.Add((DataTable)hashtable["cabecalho"]); DSRelatorioAgendaMontadaPublicada dados = new DSRelatorioAgendaMontadaPublicada(); dados.Tables.Add((DataTable)hashtable["dados"]); ReportDocument repDoc = new ReportDocument(); repDoc.Load(Server.MapPath("RelatoriosCrystal/CrystalReportViewer_AgendaMontadaPublicada.rpt")); repDoc.SetDataSource(dados.Tables[1]); repDoc.Subreports["CrystalReportViewer_CabecalhoAgendaMontadaPublicada.rpt"].SetDataSource(cabecalho.Tables[1]); System.IO.Stream s = repDoc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "applicattion/octect-stream"; Response.AddHeader("Content-Disposition", "attachment;filename=RelatorioDeAgendasMontadasPublicadas.pdf"); Response.AddHeader("Content-Length", s.Length.ToString()); Response.BinaryWrite(((System.IO.MemoryStream)s).ToArray()); Response.End(); Session.Remove("HashAgendaMontadaPublicada"); }
protected void CriaPDF() { Hashtable hash = (Hashtable)Session["HashVagasDisponivel"]; //CrystalReportViewer_AgendaPrestador.DisplayToolbar = true; //CrystalReportViewer_AgendaPrestador.EnableDatabaseLogonPrompt = false; DSRelatorioVagasDisponivel conteudo = new DSRelatorioVagasDisponivel(); conteudo.Tables.Add((DataTable)hash["corpo"]); ReportDocument repDoc = new ReportDocument(); repDoc.Load(Server.MapPath("RelatoriosCrystal/CrystalReportViewer_VagasDisponivel.rpt")); repDoc.SetDataSource(conteudo.Tables[1]); //repDoc.Database.Tables["CabecalhoAgendaPrestador"].SetDataSource((DataTable)hash["cabecalho"]); //repDoc.Database.Tables["RelatorioAgendaPrestador"].SetDataSource((DataTable)hash["corpo"]); System.IO.Stream s = repDoc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "applicattion/octect-stream"; Response.AddHeader("Content-Disposition", "attachment;filename=RelatorioVagasDisponivel.pdf"); Response.AddHeader("Content-Length", s.Length.ToString()); Response.BinaryWrite(((System.IO.MemoryStream)s).ToArray()); Response.End(); }
public virtual System.IO.Stream GetStreamReporte(ExportFormatType Formato) { ReportDocument reportDocument = new ReportDocument(); string path = Path.Combine(Path.Combine(Path.GetDirectoryName(System.AppDomain.CurrentDomain.BaseDirectory), "Reportes\\"), ClaseReporte.ResourceName); reportDocument.Load(path); reportDocument.SetDataSource(GetDatosReporte()); return reportDocument.ExportToStream(Formato); }
/// <summary> /// Diese Funktion lädt alle Systemereignisse. /// <returns name="pout_Systemereignisse">Menge aller Systemereignisse die bisher geworfen wurde.</returns> /// </summary> public System.IO.Stream ErzeugeEtb() { // Erstellen eines Reports ReportDocument pout_Report = new ReportDocument(); // Lade Reportvorlage pout_Report.Load(System.IO.Directory.GetCurrentDirectory() + @"\ReportVorlagen\ETB.rpt"); Console.WriteLine(System.IO.Directory.GetCurrentDirectory()); // muss als Stream übertragen werden, da ReportDocuments nicht Serializable sind return pout_Report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); }
private void Imprimir(int AlumnoID) { DBEscolarDataContext db = new DBEscolarDataContext(); var Pago = (from P in db.vwRPTPagosEncabezados join D in db.vwRPTPagosDetalles on P.PagoID equals D.PagoID where P.AlumnoID == AlumnoID && P.Ciclo == Utils.CicloActual && (P.Estatus != 0) && D.Clave == "A01" select P).FirstOrDefault(); if (Pago == null) { this.lblMensaje.Text = "No se ha encontrado la ficha de pago.<br />Nota: Para poder generar la Ficha de Pago, debes de estar validado."; return; } else if (Pago.Estatus == 3) { Alumno Alumno = (from A in db.Alumnos where A.AlumnoID == AlumnoID select A).FirstOrDefault(); this.lblMensaje.Text = "Felicidades. Tú ficha ha sido pagada y ya te encuentras inscrito con matrícula: " + Alumno.Matricula; return; } var Detalle = (from D in db.vwRPTPagosDetalles where D.PagoID == Pago.PagoID select D).ToList(); //Actualiza el estatus del pago a 2:Impreso db.spEXEPagosCambiaEstatus(AlumnoID, Pago.PagoID, 2, Utils.CicloActual); ArrayList col = new ArrayList(); col.Add(Pago); ReportDocument rptDoc = new ReportDocument(); rptDoc.Load(Server.MapPath("Reportes/rptFichaDePago.rpt")); //set dataset to the report viewer. rptDoc.SetDataSource(col); rptDoc.Subreports["Detalle"].SetDataSource(Detalle); rptDoc.Subreports["Detalle2"].SetDataSource(Detalle); MemoryStream stream = (MemoryStream)rptDoc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptDoc.Close(); rptDoc.Dispose(); Response.Clear(); Response.ContentType = @"Application/pdf"; Response.AddHeader("Content-Disposition", "inline; filename=FichaDePago.pdf"); Response.AddHeader("content-length", stream.Length.ToString()); Response.BinaryWrite(stream.ToArray()); Response.Flush(); stream.Close(); stream.Dispose(); }
//Relatório de LISTA DE DESPESAS .PDF (Crystal Report) - Funcionando mas vem sem parâmetors ainda 24/11/2015. public ActionResult GenerateReport() { ReportDocument rd = new ReportDocument(); //(Crystal Report) rd.Load(Path.Combine(Server.MapPath("../Reports/CrystalReportDespesas.rpt"))); ViewBag.ListDespesas = db.DespesasEmps.ToList(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream (CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return File(stream, "application/pdf", "ListaDespesas.pdf"); }
// Revenue - Expense - TaxExpense - Divident = NetEarnings public ActionResult ReportIncomeStatement(int period, int yearPeriod) { var company = _companyService.GetQueryable().FirstOrDefault(); Closing closing = _closingService.GetObjectByPeriodAndYear(period, yearPeriod); if (closing == null) { return(Content(Constant.ErrorPage.ClosingNotFound)); } ValidComb Revenue = _validCombService.FindOrCreateObjectByAccountAndClosing(_accountService.GetObjectByLegacyCode(Constant.AccountLegacyCode.Revenue).Id, closing.Id); ValidComb COGS = _validCombService.FindOrCreateObjectByAccountAndClosing(_accountService.GetObjectByLegacyCode(Constant.AccountLegacyCode.COGS).Id, closing.Id); // TODO decimal OperationalExpensesAmount = 0, InterestEarningAmount = 0, DepreciationAmount = 0, AmortizationAmount = 0, TaxAmount = 0, DividentAmount = 0; ModelIncomeStatement model = new ModelIncomeStatement() { CompanyName = company.Name, BeginningDate = closing.BeginningPeriod.Date, EndDate = closing.EndDatePeriod.Date, Revenue = Revenue.Amount, COGS = COGS.Amount, OperationalExpenses = OperationalExpensesAmount, InterestEarning = InterestEarningAmount, Depreciation = DepreciationAmount, Amortization = AmortizationAmount, Tax = TaxAmount, Divident = DividentAmount }; List <ModelIncomeStatement> list = new List <ModelIncomeStatement>(); list.Add(model); var rd = new ReportDocument(); //Loading Report rd.Load(Server.MapPath("~/") + "Reports/Finance/IncomeStatement.rpt"); // Setting report data source rd.SetDataSource(list); var stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return(File(stream, "application/pdf")); }
public ActionResult printreceipt(int?id) { if (Session["empName"] != null) { string name = Session["empName"].ToString(); var emp2 = _db.Employee.Where(d => d.employeeName == name).FirstOrDefault(); var _allowAll = _db.HowCanAcess.Where(s => s.employeeID == emp2.id).FirstOrDefault(); ReportDocument rd = new ReportDocument(); var infoes = _db.Info.FirstOrDefault(); rd.Load(Path.Combine(Server.MapPath("~/Report/test2.rpt"))); var emp = _db.Employee.Where(f => f.id == id).FirstOrDefault(); rd.SetDataSource(_db.feeses.Where(f => f.NumberOfCase == id).Select(p => new { id = p.ID, // Employee = _db.Employee.Where(f => f.id.ToString() == p.Employee).Select(f => f.employeeName).FirstOrDefault(), NumberOfCase = p.NumberOfCase, DateofRevice = p.DateofRevice, clientID_ID = p.clientID, recived = p.recived, notes = p.notes, EmployeeName = p.EmployeeName, money = _db.Cases.Where(f => f.id == p.NumberOfCase).Select(f => f.money).FirstOrDefault(), //info data img = infoes.Img.Replace(@"~\", ""), description = infoes.description, Number = infoes.Number, PlaceName = infoes.PlaceName, }).ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "aaplication/pdf", "اتعاب القضيه.pdf")); } return(RedirectToAction("HavntAccess", "Employees")); }
public FileResult ViewPDF(int?id) { Stream stream = null; var nombreArchivo = ""; ReportDocument reportDocument = new ReportDocument(); byte[] pdfByte = null; try { EPRTA_MOVIMIENTO solicitud = unitOfWork.MovimientoRepository.GetById(id); EntitiesProveduria db = new EntitiesProveduria(); SqlConnectionStringBuilder builderVenta = new SqlConnectionStringBuilder(db.Database.Connection.ConnectionString); SP_REQUISICION_BODEGATableAdapter tableAdapter = new SP_REQUISICION_BODEGATableAdapter(); object objetos = new object(); DataTable dataTable = tableAdapter.GetData(id, out objetos); String pathReport = Path.Combine(HttpRuntime.AppDomainAppPath, "Reports\\Cr_Requisicion_Bodega.rpt"); reportDocument.Load(pathReport); reportDocument.SetDataSource(dataTable); reportDocument.SetDatabaseLogon(builderVenta.UserID, builderVenta.Password); stream = reportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); pdfByte = ReadFully(stream); nombreArchivo = "REQUISICION DE BODEGA "; Response.AddHeader("content-disposition", "inline; title='';" + "filename=" + nombreArchivo + ".pdf"); } catch (Exception ex) { logger.Error(ex, ex.Message); } finally { if (reportDocument != null) { if (reportDocument.IsLoaded) { reportDocument.Close(); reportDocument.Dispose(); } } } return(File(pdfByte, MediaTypeNames.Application.Pdf)); }
public CrystalReportResult(string reportPath, object dataSet,List<ReportParameter> paramList,string type="pdf") { ReportDocument reportDocument = new ReportDocument(); reportDocument.Load(reportPath); reportDocument.SetDataSource(dataSet); foreach (var item in paramList) { reportDocument.SetParameterValue(item.Name, item.Value); } #region extra //ParameterValues currentParameterValues = new ParameterValues(); //ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); //ParameterFieldDefinitions parameterFieldDefinitions = reportDocument.DataDefinition.ParameterFields; //ParameterFieldDefinition parameterFieldDefinition; //foreach (var param in paramList) //{ // if (param.Value != null) // { // if (param.IsInteger) // var value = Int64.Parse(param.Value); // else if (param.IsDateTime) // parameterDiscreteValue.Value = DateTime.Parse(param.Value); // else if (param.IsBoolean) // parameterDiscreteValue.Value = bool.Parse(param.Value); // else // parameterDiscreteValue.Value = param.Value; // } // else // { // parameterDiscreteValue.Value = DBNull.Value; // } // currentParameterValues.Add(parameterDiscreteValue); // parameterFieldDefinition = parameterFieldDefinitions[param.Name]; // parameterFieldDefinition.ApplyCurrentValues(currentParameterValues); //} #endregion _contentBytes = StreamToBytes(reportDocument.ExportToStream(GetFormatType(type))); }
public ActionResult Export() { var query = entities.statements.Select(s => s.Acnumber).FirstOrDefault(); string pwd = GeneratePassword(query); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports/CrystalReport2.rpt"))); rd.SetDataSource(entities.statements.Select(s => new { Id = s.Id, TransactionDate = s.TransactionDate, CustomerName = s.CustomerName, CardNumber = s.CardNumber, imagePath = s.imagePath, PostedDate = s.PostedDate, DescriptionOfTransactions = s.DescriptionOfTransactions, TransactionsAmount = s.TransactionsAmount, BilledAmount = s.BilledAmount, DRCR = s.DRCR, }).ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); // stream.Seek(0, SeekOrigin.Begin); Stream t_Output; using (Stream t_Input = stream) //using (Stream t_Output = new FileStream(Server.MapPath(".") + "\\test_encrypted.pdf", FileMode.Create, FileAccess.Write, FileShare.None)) using (t_Output = new FileStream("C:\\img\\" + "test_encrypted.pdf", FileMode.Create, FileAccess.Write, FileShare.None)) { iTextSharp.text.pdf.PdfReader t_Reader = new iTextSharp.text.pdf.PdfReader(t_Input); iTextSharp.text.pdf.PdfEncryptor.Encrypt(t_Reader, t_Output, true, pwd, pwd, iTextSharp.text.pdf.PdfWriter.ALLOW_PRINTING); } //return File("C:\\img\\" + "test_encrypted.pdf", "application/pdf", "ListStatement.pdf"); return(View()); }
public ActionResult PrintExpenses() { if (Session["empName"] != null) { string name = Session["empName"].ToString(); var emp2 = _db.Employee.Where(d => d.employeeName == name).FirstOrDefault(); var _allowAll = _db.HowCanAcess.Where(s => s.employeeID == emp2.id).FirstOrDefault(); if (_allowAll.Staticis == true) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Report/expensesReport.rpt"))); var infoes = _db.Info.FirstOrDefault(); rd.SetDataSource(_db.Expenses.Select(p => new { id = p.id, Expensestype = _db.Expensestypes.Where(f => f.id.ToString() == p.Expensestype).Select(f => f.catogery).FirstOrDefault(), office = _db.Offices.Where(f => f.Id.ToString() == p.office).Select(f => f.OfficeName).FirstOrDefault(), date = p.date, values = p.values, Comment = p.Comment, //info data img = infoes.Img.Replace(@"~\", ""), description = infoes.description, Number = infoes.Number, PlaceName = infoes.PlaceName, }).ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "aaplication/pdf", "سجل المصروفات.pdf")); } } return(RedirectToAction("HavntAccess", "Employees")); }
public ActionResult Info() { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports/"), "Information.rpt")); var Info = (from d in db.Departments join e in db.Employees on d.DepartmentId equals e.DepartmentId select new { e.EmployeeName, d.DepartmentName, e.JoinDate, e.Grade }).ToList(); rd.SetDataSource(Info); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "Info.pdf")); }
public ActionResult IndexPDF() { var allclients = db.Clients.ToList(); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "Client Index.rpt")); rd.SetDataSource(allclients); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "Client Index.pdf")); }
//Report generation public ActionResult ExportAttendanceListing() { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Report/Attendance/Attendance.rpt"))); rd.SetDataSource(inventorymgtEntities.attendance_emp.ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream str = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); str.Seek(0, SeekOrigin.Begin); String savedFileName = string.Format("AttendanceListing_{0}", DateTime.Now); return(File(str, "application/pdf", savedFileName)); }
public ActionResult ExportOrderListing() { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports/OrderListingReport.rpt"))); rd.SetDataSource(db.Orders.ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream str = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); str.Seek(0, SeekOrigin.Begin); string savedFilename = string.Format("OrderListing_{0}", DateTime.Now + ".pdf"); return(File(str, "application/pdf", savedFilename)); }
//REPORTE CON YASUO MANCO TROLL AFK CON LA LIBRERIA CRYSTAL REPORT PARA VISUAL STUDIO public ActionResult ExportacionLista() { ReportDocument reporteNormal = new ReportDocument(); reporteNormal.Load(Path.Combine(Server.MapPath("~/MisReportes/OrdenLista.rpt"))); reporteNormal.SetDataSource(db.Orden.ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream ReportTodos = reporteNormal.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); ReportTodos.Seek(0, SeekOrigin.Begin); string guardararchivo = string.Format("OrdenLista_{0}", DateTime.Now); return(File(ReportTodos, "appication/pdf", guardararchivo)); }
public ActionResult ReporteTareas() { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reportes/Viewers/"), "TareasReport.rpt")); rd.SetDataSource(ObjTarea.TareasReporte()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "TareasReporte.pdf")); }
protected void Page_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = BUS.SqlDataAccessHelper.ExecuteQuery("spReportDoanhThu"); ReportDocument rptDoc = new ReportDocument(); // load report rptDoc.Load(Server.MapPath("ReportDoanhThu.rpt")); // fill data rptDoc.SetDataSource(dt); MemoryStream oStream = (MemoryStream)rptDoc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(oStream.ToArray()); Response.End(); }
public ActionResult AllReport() { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Report/"), "CrystalReportTeacher.rpt")); rd.SetDataSource(db.tblTeachers.ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "Teacher.pdf")); }
protected void btnPrint_Click(object sender, EventArgs e) { System.IO.MemoryStream stream1 = new System.IO.MemoryStream(); string Path = ""; if (RbtStatistics.Checked == true) { Path = Server.MapPath("~/Report/Followuptobedone-satistics.rpt"); } else { Path = Server.MapPath("~/Report/Followuptobedone_Detail.rpt"); } myReportDocument.Load(Path); myReportDocument.SetParameterValue("@flag", ChkDate.Checked == true ? 1 : 0); myReportDocument.SetParameterValue("@fromdate", ChkDate.Checked == false ? DateTime.Now :Report(txtFromDate.Text)); myReportDocument.SetParameterValue("@todate", ChkDate.Checked == false ? DateTime.Now : Report(txtToDate.Text)); myReportDocument.SetParameterValue("@groupcode", ddlCountry.SelectedValue); myReportDocument.SetParameterValue("@empid", ddlemp.SelectedValue); myReportDocument.SetParameterValue("@callerstatus", ddlStudentStatus.SelectedValue); //myReportDocument.SetParameterValue("@SemID", drpSemester.SelectedValue); myReportDocument.SetDatabaseLogon("software", "DelFirMENA$idea"); CrystalReportViewer1.ReportSource = myReportDocument; CrystalReportViewer1.DataBind(); CrystalReportViewer1.HasExportButton = true; CrystalReportViewer1.HasPrintButton = true; CrystalReportViewer1.HasSearchButton = true; CrystalReportViewer1.HasToggleGroupTreeButton = false; System.IO.Stream oStream = null; byte[] byteArray = null; oStream = myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.BinaryWrite(byteArray); Response.Flush(); Response.Close(); myReportDocument.Close(); myReportDocument.Dispose(); }
public ActionResult Report(RequestIssue requestıssue, FormCollection formcollection) { ReportDocument rptH = new ReportDocument(); rptH.FileName = Server.MapPath("~/RDLC/SurveyReport.rpt"); rptH.Refresh(); //rptH.Load(); var value = new ParameterDiscreteValue(); var requests_ = db.RequestIssues.AsNoTracking().Include(p => p.Locations).Include(p => p.Personnels).Include(p => p.CorporateAccounts); int x_index = 0; foreach (int req_ in requests_.Select(i => i.RequestIssueID).ToList()) { value.Value = req_; rptH.ParameterFields["RequestIDs"].CurrentValues.Add(value); x_index++; } if (x_index == 0) { return(RedirectToAction("Index", new { custommerr = "Belirttiğiniz Kriterlere Uygun Kayıt(lar) Bulunamadı" })); } // rptH.SetDataSource([datatable]); var cd = new System.Net.Mime.ContentDisposition { // for example foo.bak FileName = "rapor_klimasanHelpDeskAnketler.pdf", // always prompt the user for downloading, set to true if you want // the browser to try to show the file inline Inline = false, }; Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.AppendHeader("Content-Disposition", cd.ToString()); return(File(stream, "application/pdf")); }
public ActionResult GenerateReport(DateTime FromDate, DateTime ToDate) { var fromDate = FromDate; var toDate = ToDate; var AllApplicants = new HumanResource.Reports.ApplicantsList.ApplicantDataSet(); var lstAllApplicants = db.HRApplicants.Where(p => p.DateAdded >= fromDate && p.DateAdded <= toDate) .ToList(); foreach (var pat in lstAllApplicants) { var app = db.HRFileInformations.FirstOrDefault(p => p.ApplicantId != null); AllApplicants.Applicant.AddApplicantRow(pat.ApplicantId, pat.FirstName + "" + pat.Surname, app.DateOfApplication.ToString(), pat.Mobile, pat.Email, pat.NationalId, app.PositionAppliedFor ); } ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Areas/HumanResource/Reports/ApplicantsList/ApplicantReport.rpt"))); rd.SetDataSource(AllApplicants); rd.Subreports["RptReportHeader.rpt"].SetDataSource(CrystalReports.HeaderAndFooterForReports.GetAllReportHeader()); rd.SetParameterValue("fromDate", FromDate); rd.SetParameterValue("toDate", ToDate); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); string fileName = "Applicants List" + DateTime.Today + ".pdf"; return(File(stream, "application/pdf", fileName)); }
public ActionResult PrintReport(int id) { if (Session["empName"] != null) { string name = Session["empName"].ToString(); var emp2 = _db.Employee.Where(d => d.employeeName == name).FirstOrDefault(); var _allowAll = _db.HowCanAcess.Where(s => s.employeeID == emp2.id).FirstOrDefault(); if (_allowAll.Staticis == true) { ReportDocument rd = new ReportDocument(); var infoes = _db.Info.FirstOrDefault(); rd.Load(Path.Combine(Server.MapPath("~/Report/CrystalReport1.rpt"))); var emp = _db.Employee.Where(f => f.id == id).FirstOrDefault(); rd.SetDataSource(_db.Salaries.Where(f => f.Employee == id.ToString()).Select(p => new { id = p.id, Employee = _db.Employee.Where(f => f.id.ToString() == p.Employee).Select(f => f.employeeName).FirstOrDefault(), empSupplyer = p.empSupplyer, salary = p.salary, month = _db.Month.Where(f => f.id.ToString() == p.month).Select(f => f.months).FirstOrDefault(), OfficeName = _db.Offices.Where(f => f.Id.ToString() == emp.OfficeName).Select(f => f.OfficeName).FirstOrDefault(), Date = p.Date, jobs = _db.Jobs.Where(f => f.id.ToString() == emp.jobs).Select(f => f.jobs), //info data img = infoes.Img.Replace(@"~\", ""), Expr3 = infoes.description, Number = infoes.Number, PlaceName = infoes.PlaceName, }).ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "aaplication/pdf", "حسابات الموظفين.pdf")); } } return(RedirectToAction("HavntAccess", "Employees")); }
public HttpResponseMessage ExportReport(Users user) { string EmailTosend = WebUtility.UrlDecode(user.Email); List <Users> model = new List <Users>(); var data = cX.tbl_Registration; var rd = new ReportDocument(); foreach (var details in data) { Users obj = new Users(); obj.Email = details.Email; obj.FirstName = details.FirstName; obj.LastName = details.LastName; model.Add(obj); } rd.Load(Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~/Reports"), "UserRegistration.rpt")); rd.SetDataSource(model); using (var stream = rd.ExportToStream(ExportFormatType.PortableDocFormat)) { SmtpClient smtp = new SmtpClient { Port = 587, UseDefaultCredentials = true, Host = "smtp.gmail.com", DeliveryMethod = SmtpDeliveryMethod.Network, EnableSsl = true }; smtp.UseDefaultCredentials = false; // to use google smtp to send out the report, update the credential below smtp.Credentials = new NetworkCredential("*****@*****.**", "password"); var message = new System.Net.Mail.MailMessage("*****@*****.**", EmailTosend, "User Registration Details", "Hi Please check your Mail and find the attachement."); message.Attachments.Add(new Attachment(stream, "UsersRegistration.pdf")); smtp.Send(message); } var Message = string.Format("Report Created and sended to your Mail."); HttpResponseMessage response1 = Request.CreateResponse(HttpStatusCode.OK, Message); return(response1); }
// GET: InBaoCaoHS public ActionResult InDanhSachHSTheoLop(string malop, string manamhoc) { string a = Session["malopin"].ToString(); string b = Session["manamin"].ToString(); var pl = db.Tbl_PhanLop.Where(x => x.maNamHoc == b && x.maLop == a).ToList(); foreach (var item in pl) { Tbl_InDanhSachHS inpc = new Tbl_InDanhSachHS(); inpc.idPhanLop = item.idPhanLop; inpc.maLop = item.maLop; inpc.hoTenHS = item.Tbl_HocSinh.hoTen; inpc.maNamHoc = item.maNamHoc; inpc.tenLop = item.Tbl_LopHoc.tenLop; inpc.tenNamHoc = item.Tbl_NamHoc.tenNamHoc; inpc.ngaySinh = Convert.ToDateTime(item.Tbl_HocSinh.ngaySinh); inpc.soDTNha = item.Tbl_HocSinh.soDTNha; inpc.diaChi = item.Tbl_HocSinh.diaChi; inpc.gioiTinh = item.Tbl_HocSinh.gioiTinh; db.Tbl_InDanhSachHS.Add(inpc); db.SaveChanges(); } ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports/InDanhSachHS.rpt"))); rd.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); foreach (var item in pl) { var dss = db.Tbl_InDanhSachHS.ToList().Where(x => x.maLop == a && x.maNamHoc == b).FirstOrDefault(); db.Tbl_InDanhSachHS.Remove(dss); db.SaveChanges(); } return(File(stream, "application/pdf", "InDanhSachHS.pdf")); }
private void GetReportDocument(ReportDocument pReportClientDocument, ReportBase objReportBase) { LSReportCrystal _LSReportCrystal = new LSReportCrystal(); _LSReportCrystal.reportBase = objReportBase; pReportClientDocument = _LSReportCrystal.GenerateReport(); foreach (Section oSection in pReportClientDocument.ReportDefinition.Sections) { foreach (ReportObject obj in oSection.ReportObjects) { FieldObject field; field = pReportClientDocument.ReportDefinition.ReportObjects[obj.Name] as FieldObject; if (field != null) { Font oFon1 = new Font("Arial Narrow", field.Font.Size - 1F); Font oFon2 = new Font("Arial", field.Font.Size - 1F); if (oFon1 != null) { field.ApplyFont(oFon1); } else if (oFon2 != null) { field.ApplyFont(oFon2); } } } } Stream oStream = null; byte[] byteArray = null; oStream = pReportClientDocument.ExportToStream(ExportFormatType.PortableDocFormat); byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.BinaryWrite(byteArray); Response.Flush(); Response.Close(); }
public ActionResult GenerateEmployeesHistoryReport(DateTime FromDate, DateTime ToDate) { var fromDate = FromDate; var toDate = ToDate; var Employee = new HumanResource.Reports.EmployeeHistory.DatasetEmployee(); var lstEmployeesHistory = db.HRStaffWorkExperiences.Where(p => p.DateAdded >= fromDate && p.DateAdded <= toDate) .ToList(); foreach (var emp in lstEmployeesHistory) { var his = db.HRFileDetails.FirstOrDefault(p => p.StaffId != null); Employee.Employee.AddEmployeeRow(emp.StaffId, his.FirstName + "" + his.OtherNames, emp.Employer, emp.BeginDate.ToString(), emp.EndDate.ToString(), emp.Position, emp.Salary.ToString(), his.InterviewDate.ToString(), his.HireDate.ToString(), his.Designation, his.JobGroup, his.JobGrade); } ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Areas/HumanResource/Reports/EmployeeHistory/EmployeeReport.rpt"))); rd.SetDataSource(Employee); rd.Subreports["RptReportHeader.rpt"].SetDataSource(CrystalReports.HeaderAndFooterForReports.GetAllReportHeader()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); string fileName = "Applicants List" + DateTime.Today + ".pdf"; return(File(stream, "application/pdf", fileName)); }
protected void BtnLoad_Click(object sender, EventArgs e) { string Path = ""; if (RbtStudent.Checked == true) { Path = Server.MapPath("ENROLLMENTFORM.rpt"); Path = Path.Substring(0, Path.LastIndexOf('\\')); Path = Path.Substring(0, Path.LastIndexOf('\\')); Path = Path + "\\Reports\\ENROLLMENTFORM.rpt"; myReportDocument.Load(Path); myReportDocument.SetParameterValue("@LinkId", txtStudentId.Text); myReportDocument.SetDatabaseLogon("software", "DelFirMENA$idea"); } else { Path = Server.MapPath("EmployeeProfile.rpt"); Path = Path.Substring(0, Path.LastIndexOf('\\')); Path = Path.Substring(0, Path.LastIndexOf('\\')); Path = Path + "\\Reports\\EmployeeProfile.rpt"; myReportDocument.Load(Path); myReportDocument.SetParameterValue("@Personid", TxtStaffFacID.Text); myReportDocument.SetDatabaseLogon("software", "DelFirMENA$idea"); } TxtStaffFacID.Text = ""; txtStudentName.Text = ""; txtStudentId.Text = ""; System.IO.Stream oStream = null; byte[] byteArray = null; oStream = myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.BinaryWrite(byteArray); Response.Flush(); Response.Close(); myReportDocument.Close(); myReportDocument.Dispose(); }
public ActionResult PrintAdvise(string merchantid, DateTime startdate, DateTime enddate) { if (HttpContext.Session["UID"] != null) { using (SqlConnection consql = new SqlConnection(ConfigurationManager.ConnectionStrings["MerchantServiceDB"].ConnectionString)) { consql.Open(); SqlCommand cmd = new SqlCommand("sp_rp_load_advise", consql); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@merchantid", merchantid); cmd.Parameters.AddWithValue("@startdate", startdate.Date); cmd.Parameters.AddWithValue("@enddate", enddate.Date); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable REPDT = new DataTable(); da.Fill(REPDT); consql.Close(); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/ReportFiles"), "rp_PaymentAdvise.rpt")); rd.SetDataSource(REPDT); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); rd.Clone(); rd.Dispose(); return(File(stream, "application/pdf", merchantid + "_" + enddate.Date.ToString("yyyyMMdd") + ".pdf")); } } else { return(RedirectToAction("Index", "Portal")); } }
public HttpResponseMessage GetDealerListReport() { EasyBillingEntities db = new EasyBillingEntities(); object _null = null; var mrchnt = _null; var dlr = (from i in db.Dealers select new { i.Address, i.Dealer_code, i.Email, i.Name, i.Phone_number, i.State_Name, i.Token_number, i.Marchent_Token_number }).ToList(); foreach (var dlrsngle in dlr) { mrchnt = (from i in db.Marchent_Accounts select new { Token_number = i.Token_number, GSTIN_Number = i.GSTIN_Number, State_Name = i.State_Name }).Where(u => u.Token_number == dlrsngle.Marchent_Token_number).Distinct().ToList(); } ReportDocument rpt = new ReportDocument(); rpt.Load(Path.Combine(HostingEnvironment.MapPath("~/Reports and dataset/All Reports"), "DealerReport.rpt")); rpt.Database.Tables[0].SetDataSource(dlr); rpt.Database.Tables[1].SetDataSource(mrchnt); Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); var response = new HttpResponseMessage(HttpStatusCode.OK); response.Content = new StreamContent(s); response.Content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/pdf"); return(response); }
public ActionResult ReportSales(DateTime startDate, DateTime endDate) { var company = _companyService.GetQueryable().FirstOrDefault(); var q = _cashSalesInvoiceService.GetQueryable().Include("CashBank").Include("Warehouse").Where(x => x.IsPaid && x.SalesDate >= startDate && x.SalesDate <= endDate); var query = (from model in q select new { StartDate = startDate, EndDate = endDate, model.Code, model.Description, model.SalesDate, ConfirmationDate = model.ConfirmationDate.Value, DueDate = model.DueDate.Value, model.Discount, model.Tax, model.Allowance, model.CoGS, model.Total, CashBank = model.CashBank.Name, Warehouse = model.Warehouse.Name, CompanyName = company.Name, CompanyAddress = company.Address, CompanyContactNo = company.ContactNo }).ToList(); var rd = new ReportDocument(); if (!query.Any()) { return(Content("")); } //Loading Report rd.Load(Server.MapPath("~/") + "Reports/General/Sales.rpt"); // Setting report data source rd.SetDataSource(query); var stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return(File(stream, "application/pdf")); }
public static Stream Exec(MaintenanceList.TransportDataTable datatable, int language, int year, string companyName, string companyAddress, string fileName, string user) { try { ReportDocument report; string strPath; strPath = HttpContext.Current.Request.MapPath("~/FileRpt/TransportMaintenance/TransportMaintenanceList.rpt"); report = new ReportDocument(); report.Load(strPath); report.Database.Tables[0].SetDataSource((DataTable)datatable); // set parameter currentDate if (language == 1) { report.SetParameterValue("currentDate", "Ngày " + DateTime.Now.Day + " tháng " + DateTime.Now.Month + " năm " + DateTime.Now.Year); } else if (language == 2) { report.SetParameterValue("currentDate", DateTime.Now.ToString("MMMM dd, yyyy")); } else { report.SetParameterValue("currentDate", DateTime.Now.Year + "年" + DateTime.Now.Month + "月" + DateTime.Now.Day + "日"); } report.SetParameterValue("year", year); // set datatable images var path = HttpContext.Current.Request.MapPath("~/Images/" + fileName); report.SetParameterValue("companyName", companyName ?? ""); report.SetParameterValue("companyAddress", companyAddress ?? ""); report.SetParameterValue("imageUrl", path); report.SetParameterValue("user", user); Stream stream = report.ExportToStream(ExportFormatType.PortableDocFormat); report.Close(); report.Dispose(); GC.Collect(); return(stream); } catch (NullReferenceException) { throw new NullReferenceException(); } }
public ActionResult InPhanCongLopTheoNam() { string a = (TempData["maphancong"]).ToString(); var pc = db.Tbl_PhanCong.Where(x => x.maNamHoc == a).ToList(); foreach (var item in pc) { Tbl_InPhanCong inpc = new Tbl_InPhanCong(); inpc.maGV = item.maGV; inpc.Idphancong = item.Idphancong; inpc.maLop = item.maLop; inpc.maLoai = item.maLoai; inpc.maNamHoc = item.maNamHoc; inpc.tenLop = item.Tbl_LopHoc.tenLop; inpc.tenNamHoc = item.Tbl_NamHoc.tenNamHoc; inpc.hoTen = item.Tbl_GiaoVien.hoTen; inpc.ngayBatDau = Convert.ToInt32(item.maNamHoc); inpc.ngayKetThuc = inpc.ngayBatDau + 1; db.Tbl_InPhanCong.Add(inpc); db.SaveChanges(); } ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports/PhanCong.rpt"))); rd.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); foreach (var item in pc) { var ab = db.Tbl_InPhanCong.Where(x => x.maNamHoc == a && x.Idphancong == item.Idphancong).FirstOrDefault(); db.Tbl_InPhanCong.Remove(ab); db.SaveChanges(); } return(File(stream, "application/pdf", "PhanCong.pdf")); }
// GET: /Teacher/ public ActionResult TWCList() { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/CrystalReports"), "TeacherWithCourseReport.rpt")); rd.Database.Tables[0].SetDataSource(db.AspNetUsers.Select(a => new { Id = a.Id, FirstName = a.FirstName + " " + a.LastName }).ToList()); rd.Database.Tables[1].SetDataSource(db.SectionCourses.Select(sc => new{ Id = sc.Id, CourseId = sc.CourseId, TeacherId = sc.TeacherId }).ToList()); rd.Database.Tables[2].SetDataSource(db.Courses.Select(sc => new{ Id = sc.Id, Title = sc.Title, Class = sc.Lookup1.Values }).ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "TWCList.pdf")); }
public ActionResult ReportSalesReturnInvoice(int Id) { var company = _companyService.GetQueryable().FirstOrDefault(); //var cashSalesReturnInvoice = _cashSalesInvoiceService.GetObjectById(Id); var q = _cashSalesReturnDetailService.GetQueryableObjectsByCashSalesReturnId(Id).Include("CashSalesReturn").Include("CashSalesInvoiceDetail").Include("CashSalesInvoice").Include("Item").Include("UoM"); string user = AuthenticationModel.GetUserName(); var query = (from model in q select new { SKU = model.CashSalesInvoiceDetail.Item.Sku, Name = model.CashSalesInvoiceDetail.Item.Name, UoM = model.CashSalesInvoiceDetail.Item.UoM.Name, Quantity = model.Quantity, Price = model.CashSalesInvoiceDetail.IsManualPriceAssignment ? model.CashSalesInvoiceDetail.AssignedPrice : model.CashSalesInvoiceDetail.Item.SellingPrice, Amount = model, Discount = model.CashSalesInvoiceDetail.Discount, GlobalDiscount = model.CashSalesInvoiceDetail.CashSalesInvoice.Discount, Tax = model.CashSalesInvoiceDetail.CashSalesInvoice.Tax, Allowance = model.CashSalesReturn.Allowance, Code = model.CashSalesReturn.Code, SalesCode = model.CashSalesInvoiceDetail.CashSalesInvoice.Code, Date = model.CashSalesReturn.ConfirmationDate.Value, contact = "", CompanyName = company.Name, CompanyAddress = company.Address, CompanyContactNo = company.ContactNo, User = user, Description = model.CashSalesReturn.Description, }).ToList(); var rd = new ReportDocument(); //Loading Report rd.Load(Server.MapPath("~/") + "Reports/General/SalesReturnInvoice.rpt"); // Setting report data source rd.SetDataSource(query); var stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return(File(stream, "application/pdf")); }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["dtTrialBalanceReport"] != null) //&& reportType > 0) { // string financialPeriodName = Shared.GetFinancialPeriodName(); DataTable dt = (DataTable)Session["dtTrialBalanceReport"]; string rptFullPath = Server.MapPath("rptTrialBalance.rpt"); ReportDocument rpt = new ReportDocument(); rpt.Load(rptFullPath); rpt.SetDataSource(dt); TextObject txtTitle2 = (TextObject)rpt.ReportDefinition.ReportObjects["txtFinancialPeriodName"]; txtTitle2.Text = "2011"; rpt.Refresh(); MemoryStream memStream = (MemoryStream)rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(memStream.ToArray()); Response.End(); memStream.Dispose(); } else Response.Redirect("TrialBalance.aspx", false); } catch (Exception ex) { Response.Write(ex.Message); } finally { Session.Remove("dtTrialBalanceReport"); } }
public ActionResult Index(QuoteAndOrderReportViewModel model) { //if (!model.fromDate.HasValue) model.fromDate = DateTime.Now.Date; List <quote> allqu = new List <quote>(); allqu = db.quotes.Where(s => s.Quote_Date == model.fromDate).ToList(); PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(quote)); DataTable table = new DataTable(); foreach (PropertyDescriptor prop in properties) { table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType); } foreach (quote item in allqu) { DataRow row = table.NewRow(); foreach (PropertyDescriptor prop in properties) { row[prop.Name] = prop.GetValue(item) ?? DBNull.Value; } table.Rows.Add(row); } ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reporting"), "QuoteAndOrderReport.rpt")); rd.SetDataSource(table); rd.ReadRecords(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "QuoteAndOrderReport.pdf")); }
public ActionResult ExportReport(int?id) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "PagoImprimir.rpt")); var tbpago = db.UDP_Vent_tbPago_Imprimir(id).ToList(); var todo = (from p in tbpago where p.pago_Id == id select new { pago_FechaElaboracion = p.pago_FechaElaboracion, pago_Id = p.pago_Id, fact_Id = p.fact_Id, fact_Codigo = p.fact_Codigo, clte_Identificacion = p.clte_Identificacion, clte_Nombres = p.clte_Nombres, tpa_Descripcion = p.tpa_Descripcion, pago_SaldoAnterior = (Decimal)p.pago_SaldoAnterior, pago_TotalPago = (Decimal)p.pago_TotalPago, pago_MontoEfectivo = (Decimal)p.pago_MontoEfectivo, pago_TotalCambio = (Decimal)p.pago_TotalCambio, pago_Emisor = p.pago_Emisor, pago_Titular = p.pago_Titular }).ToList(); rd.SetDataSource(todo); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); //stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf")); } catch { throw; } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["vwCashRecieptsReport"] != null) { DataTable dt = (DataTable)Session["vwCashRecieptsReport"]; dt.Rows[0]["AmountText"] = new NumberToWords.NumberToWords().GetAmountWord(decimal.Parse(dt.Rows[0]["Credit"].ToString()), NumberToWords.NumberToWords.ValueTypes.Money); string rptFullPath = Server.MapPath("rptCashReciepts.rpt"); ReportDocument rpt = new ReportDocument(); rpt.Load(rptFullPath); rpt.SetDataSource(dt); rpt.Refresh(); MemoryStream memStream = (MemoryStream)rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(memStream.ToArray()); Response.End(); memStream.Dispose(); } else Response.Redirect("Payments.aspx", false); } catch (Exception ex) { Response.Write(ex.Message); } finally { Session.Remove("vwCashRecieptsReport"); } }
public virtual string GetReporteHtml() { ReportDocument reportDocument = new ReportDocument(); string path = Path.Combine(Path.Combine(Path.GetDirectoryName(System.AppDomain.CurrentDomain.BaseDirectory), "Reportes\\"), ClaseReporte.ResourceName); reportDocument.Load(path); reportDocument.SetDataSource(GetDatosReporte()); string str = ""; using (System.IO.Stream stream = reportDocument.ExportToStream(ExportFormatType.HTML32)) { byte[] bytes = new byte[stream.Length]; stream.Position = 0; stream.Read(bytes, 0, (int)stream.Length); StreamReader sr = new StreamReader(stream); str = System.Text.Encoding.UTF8.GetString(bytes); } return str; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt; String sql = "Select * FROM tableAttendance"; SqlCommand com = new SqlCommand(sql, conn); conn.Open(); SqlDataAdapter da = new SqlDataAdapter(com); dt = new DataTable("dt"); da.Fill(dt); ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("crystalreportforattendance.rpt")); rpt.SetDatabaseLogon("sa", "yugioh", @"JOP-PC\SQLEXPRESS", "ISAttandaceManagementSystem"); rpt.SetDataSource(dt); crvattendance.ReportSource = rpt; MemoryStream oStream; oStream = (MemoryStream) rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); //rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Appointment"); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(oStream.ToArray()); Response.End(); rpt.Export(); conn.Close(); conn.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["dtAccountBalance"] != null) //&& reportType > 0) { DataTable dt = (DataTable)Session["dtAccountBalance"]; string rptFullPath = Server.MapPath("rptAccountsBalances.rpt"); ReportDocument rpt = new ReportDocument(); rpt.Load(rptFullPath); rpt.SetDataSource(dt); rpt.Refresh(); MemoryStream memStream = (MemoryStream)rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(memStream.ToArray()); Response.End(); memStream.Dispose(); } else Response.Redirect("AccountBalance.aspx", false); } catch (Exception ex) { Response.Write(ex.Message); } finally { Session.Remove("dtAccountBalance"); } }
private void PrintPDF() { ReportDocument rpt_doc = new ReportDocument(); DataSet ds = new DataSet(); StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("select requisition_id,package_no,package_name,part_no,part_name_e part_name,part_spec,require_qty,decode(released_qty,null,require_qty,released_qty) release_qty,"); sqlstr.Append("issued_qty issue_qty,project_id,rowstate,po_no,contract_no from jp_pkg_requisition_v"); sqlstr.Append(string.Format(" where requisition_id in ({0})",GetSeqIdWhereStr())); OleDbConnection conn = new OleDbConnection(DBHelper.OleConnectionString); OleDbCommand cmd = new OleDbCommand(); OleDbDataAdapter da = new OleDbDataAdapter(cmd); cmd.Connection = conn; cmd.CommandText = sqlstr.ToString(); da.Fill(ds); rpt_doc.Load(Request.PhysicalApplicationPath + "\\UI\\Report\\CryPkgXd.rpt"); rpt_doc.SetDataSource(ds.Tables[0]); //rpt_doc.SetParameterValue("CYjz", objJjd.CyDoc); //rpt_doc.PrintOptions.PaperOrientation = PaperOrientation.; rpt_doc.PrintOptions.PaperSize = PaperSize.PaperA4; using (MemoryStream fp = (MemoryStream)(rpt_doc.ExportToStream(ExportFormatType.PortableDocFormat))) { Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(fp.ToArray()); fp.Close(); Response.End(); } }
public ActionResult ExportUsersList() { AMSEntities ae = new AMSEntities(); User uu = ae.Users.Where(e => e.MembershipUserID == WebSecurity.CurrentUserId).Single(); List<User> users = ae.Users.Where(e => e.CompanyID == uu.CompanyID).ToList(); var d =(from s in users select new { UserTitle = s.UserTitle ?? null, UserFirstName = s.UserFirstName ?? null, UserLastName = s.UserLastName ?? null, UserEmail = s.UserEmail ?? null, UserPhone = s.UserPhone ?? null, }).ToList(); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "MyUsers.rpt")); rd.SetDataSource(d); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return File(stream, "application/pdf", "MyusersList.pdf"); } catch (Exception e) { throw; } }
protected void Button_Imprimir_Click(object sender, EventArgs e) { if (!(String.IsNullOrEmpty(HiddenField_ID_CONTRATO.Value))) { registroContrato _registroContrato = new registroContrato(Session["idEmpresa"].ToString(), Session["USU_LOG"].ToString()); DataTable tablaInfoContrato = _registroContrato.ObtenerInfoParaImprimirContrato(Convert.ToDecimal(HiddenField_ID_CONTRATO.Value)); NumToLetra numToLetra = new NumToLetra(); string salario_en_letras = numToLetra.Convertir(Convert.ToDecimal(TextBox_Salario.Text).ToString(), true); if(tablaInfoContrato.Rows.Count <= 0) { if(_registroContrato.MensajeError != null) { Informar(Panel_FONDO_MENSAJE, Image_MENSAJE_POPUP, Panel_MENSAJES, Label_MENSAJE, "No se encontró información para generar el contrato.", Proceso.Error); } else { Informar(Panel_FONDO_MENSAJE, Image_MENSAJE_POPUP, Panel_MENSAJES, Label_MENSAJE, _registroContrato.MensajeError, Proceso.Error); } } else { String uspReporte = ""; String nombreReporte = ""; string nombre_empresa = null; string nit_empresa = null; string telefono_empresa = null; string direccion_empresa = null; if (Session["idEmpresa"].ToString() == "1") { nombre_empresa = tabla.VAR_NOMBRE_SERTEMPO; nit_empresa = tabla.VAR_NIT_SERTEMPO; telefono_empresa = tabla.VAR_TELEFONO_SERTEMPO; direccion_empresa = tabla.VAR_DOMICILIO_SERTEMPO; } else { if (Session["idEmpresa"].ToString() == "3") { nombre_empresa = tabla.VAR_NOMBRE_EYS; nit_empresa = tabla.VAR_NIT_EYS; telefono_empresa = tabla.VAR_TELEFONO_EYS; direccion_empresa = tabla.VAR_DOMICILIO_EYS; } } DataRow filaInfoContrato = tablaInfoContrato.Rows[0]; if (RadioButton_PRACTICANTE_UNI.Checked) { uspReporte = "RPT_CONTRATACION_CONTRATO_APRENDIZ_UNIVERSITARIO"; nombreReporte = "RPT_CONTRATACION_CONTRATO_APRENDIZ_UNIVERSITARIO.rpt"; uspReporte += " '" + Session["idEmpresa"].ToString() + "'" + ", '" + nombre_empresa + "'" + ", '" + nit_empresa + "'" + ", '" + telefono_empresa + "'" + ", '" + direccion_empresa + "'" + ", '" + TextBox_contrato_aprendiz_universitario_representante_legal.Text + "'" + ", '" + TextBox_contrato_aprendiz_universitario_numero_identificacion.Text + "'" + ", '" + TextBox_contrato_aprendiz_universitario_nombre_institucion.Text + "'" + ", '" + TextBox_contrato_aprendiz_universitario_nit_institucion.Text + "'" + ", '" + TextBox_contrato_aprendiz_universitario_especialidad_aprendiz.Text + "'" + ", '" + filaInfoContrato["ID_EMPLEADO"].ToString() + "'" ; } else if ((RadioButton_SENA_ELECTIVO.Checked) || (RadioButton_SENA_PRODUCTIVO.Checked)) { uspReporte = "RPT_CONTRATACION_CONTRATO_APRENDIZ_SENA"; nombreReporte = "RPT_CONTRATACION_CONTRATO_APRENDIZ_SENA.rpt"; uspReporte += " '" + Session["idEmpresa"].ToString() + "'" + ", '" + nombre_empresa + "'" + ", '" + nit_empresa + "'" + ", '" + telefono_empresa + "'" + ", '" + direccion_empresa + "'" + ", '" + TextBox_contrato_aprendiz_sena_representante_legal.Text + "'" + ", '" + TextBox_contrato_aprendiz_sena_cargo_r_l.Text + "'" + ", '" + TextBox_contrato_aprendiz_sena_numero_documento_r_l.Text + "'" + ", '" + TextBox_contrato_aprendiz_sena_especialidad_aprendiz.Text + "'" + ", '" + TextBox_contrato_aprendiz_sena_curso_aprendiz.Text + "'" + ", '" + TextBox_contrato_aprendiz_nombre_institucion.Text + "'" + ", '" + TextBox_contrato_aprendiz_nit_institucion.Text + "'" + ", '" + TextBox_contrato_aprendiz_centro_formacion.Text + "'" + ", '" + TextBox_contrato_aprendiz_meses_duracion.Text + "'" + ", '" + TextBox_contrato_aprendiz_fecha_inicio.Text + "'" + ", '" + TextBox_contrato_aprendiz_fecha_final.Text + "'" + ", '" + filaInfoContrato["ID_EMPLEADO"].ToString() + "'" ; } else if (DropDownList_Clase_contrato.SelectedValue == ClaseContrato.I.ToString()) { uspReporte = "RPT_CONTRATACION_CONTRATO_INDEFINIDO"; nombreReporte = "RPT_CONTRATACION_CONTRATO_INDEFINIDO.rpt"; uspReporte += " '" + Session["idEmpresa"].ToString() + "'" + ", '" + nombre_empresa + "'" + ", '" + nit_empresa + "'" + ", '" + TextBox_contrato_indefinido_identificacion_empleador.Text + "'" + ", '" + TextBox_contrato_indefinido_nombre_empleador.Text + "'" + ", '" + TextBox_contrato_indefinido_ciudad_domicilio_empleador.Text + "'" + ", '" + telefono_empresa + "'" + ", '" + direccion_empresa + "'" + ", '" + salario_en_letras + "'" + ", '" + filaInfoContrato["ID_EMPLEADO"].ToString() + "'" ; } else { if (DropDownList_Clase_contrato.SelectedValue == ClaseContrato.L_C_C_D_A.ToString()) { } else { if (DropDownList_Clase_contrato.SelectedValue == ClaseContrato.L_S_C_D_A.ToString()) { } else { if (DropDownList_Clase_contrato.SelectedValue == ClaseContrato.O_L.ToString()) { if (DropDownList_FORMA_IMPRESION_CONTRATO.SelectedValue == "COMPLETO") { ImprimirContratoO_L_COMPLETO(filaInfoContrato); } else { if (DropDownList_FORMA_IMPRESION_CONTRATO.SelectedValue == "PREIMPRESO") { uspReporte = "usp_con_reg_contratos_ObtenerInfo_para_imprimir_contrato " + filaInfoContrato["REGISTRO_CONTRATO"].ToString(); nombreReporte = "RPT_CONTRATACION_OBRA_LABOR_PREIMPRESO.rpt "; } } } else { if (DropDownList_Clase_contrato.SelectedValue == ClaseContrato.T_F.ToString()) { } else { if (DropDownList_Clase_contrato.SelectedValue == ClaseContrato.IN.ToString()) { uspReporte = "RPT_CONTRATACION_CONTRATO_INTEGRAL"; nombreReporte = "RPT_CONTRATACION_CONTRATO_INTEGRAL.rpt"; uspReporte += " '" + Session["idEmpresa"].ToString() + "'" + ", '" + nombre_empresa + "'" + ", '" + direccion_empresa + "'" + ", '" + TextBox_contrato_integral_porcentaje_parafiscales.Text + "'" + ", '" + TextBox_contrato_integral_porcentaje_prestacional.Text + "'" + ", '" + filaInfoContrato["ID_EMPLEADO"].ToString() + "'"; } } } } } } String cadenaDeConeccion = ""; if (Session["idEmpresa"].ToString() == "1") { cadenaDeConeccion = ConfigurationManager.ConnectionStrings["siser"].ConnectionString; } else { cadenaDeConeccion = ConfigurationManager.ConnectionStrings["sister"].ConnectionString; } SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(cadenaDeConeccion); String user = builder.UserID; string pass = builder.Password; String server = builder.DataSource; String db = builder.InitialCatalog; SqlConnection conn = new SqlConnection(cadenaDeConeccion); try { using (SqlCommand comando = new SqlCommand(uspReporte, conn)) { using (SqlDataAdapter adaptador = new SqlDataAdapter(comando)) { DataSet ds = new DataSet(); adaptador.Fill(ds); reporte = new ReportDocument(); reporte.Load(Server.MapPath("~/Reportes/Contratacion/" + nombreReporte)); reporte.SetDataSource(ds.Tables[0]); reporte.DataSourceConnections[0].SetConnection(server, db, user, pass); using (var mStream = (MemoryStream)reporte.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)) { Response.AddHeader("Content-Disposition", "attachment;FileName=RPT_PDF.pdf"); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(mStream.ToArray()); } Response.End(); } } } catch (Exception ex) { Informar(Panel_FONDO_MENSAJE, Image_MENSAJE_POPUP, Panel_MENSAJES, Label_MENSAJE, ex.Message, Proceso.Error); } finally { if (conn.State != ConnectionState.Closed) conn.Close(); conn.Dispose(); } } } else { Informar(Panel_FONDO_MENSAJE, Image_MENSAJE_POPUP, Panel_MENSAJES, Label_MENSAJE, "El contrato no ha sido guardado. Debe diligenciar todos los datos de contrato y luego Guardarlos, para poder imprimir el correspondiente documento.", Proceso.Advertencia); } }
public ActionResult Report(RequestIssue requestıssue, FormCollection formcollection) { ReportDocument rptH = new ReportDocument(); rptH.FileName = Server.MapPath("~/RDLC/SurveyReport.rpt"); rptH.Refresh(); //rptH.Load(); var value = new ParameterDiscreteValue(); var requests_ = db.RequestIssues.AsNoTracking().Include(p => p.Locations).Include(p => p.Personnels).Include(p => p.CorporateAccounts); int x_index = 0; foreach (int req_ in requests_.Select(i => i.RequestIssueID).ToList()) { value.Value = req_; rptH.ParameterFields["RequestIDs"].CurrentValues.Add(value); x_index++; } if (x_index == 0) { return RedirectToAction("Index", new { custommerr = "Belirttiğiniz Kriterlere Uygun Kayıt(lar) Bulunamadı" }); } // rptH.SetDataSource([datatable]); var cd = new System.Net.Mime.ContentDisposition { // for example foo.bak FileName = "rapor_klimasanHelpDeskAnketler.pdf", // always prompt the user for downloading, set to true if you want // the browser to try to show the file inline Inline = false, }; Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.AppendHeader("Content-Disposition", cd.ToString()); return File(stream, "application/pdf"); }
protected void GetReports() { // Session["PRINTALL"] = null; string fType = "PD"; string fDate = (string)Session["FD"]; string tDate = (string)Session["TD"]; string BType = (string)Session["BILLTYPE"]; string shpType = (string)Session["shpType"]; string pName = (string)Session["pname"]; string sqlStmts = ""; ReportDocument rptDoc = new ReportDocument(); if (BType == "SB") { ImpexCube.Billing.XSD.printall ds = new ImpexCube.Billing.XSD.printall(); // .xsd file name DataTable dt = new DataTable(); dt.TableName = "Crystal Report Example"; sqlStmts = "exec spBillsAll '" + pName + "','" + BType + "','" + shpType + "','" + fDate + "','" + tDate + "'"; ReportDocument rptObject = new ReportDocument(); DataSet dataSetName = new DataSet(); dsTableName = new string[1]; dsTableName[0] = "spBillsAll"; ConnectionReports.FillDataSet(sqlStmts, dataSetName, dsTableName); dt = dataSetName.Tables[0]; ds.Tables[0].Merge(dt); //rptDoc.Load(@"E:\RAJESH\Live Application\Delhi And Chennai Billing Application\ImpexCube\ImpexCube\Billing\CryInvoice.rpt"); rptDoc.Load(@"C:\inetpub\wwwroot\pub impexcryst\Billing\CryInvoice.rpt"); rptDoc.SetDataSource(ds); MemoryStream oStream; // using System.IO oStream = (MemoryStream) rptDoc.ExportToStream( CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(oStream.ToArray()); Response.End(); //CrystalReportViewer1.ReportSource = rptDoc; //string[] a = new string[2]; //ConnectionReports.ShowReportWithParameter(rptDoc, ds, a,fType); } else { ImpexCube.Billing.XSD.dsdebit ds = new ImpexCube.Billing.XSD.dsdebit(); // .xsd file name DataTable dt = new DataTable(); dt.TableName = "Crystal Report Example"; sqlStmts = "exec spDBBillsAll '" + pName + "','" + BType + "','" + shpType + "','" + fDate + "','" + tDate + "'"; ReportDocument rptObject = new ReportDocument(); DataSet dataSetName = new DataSet(); dsTableName = new string[1]; dsTableName[0] = "spDBBillsAll"; ConnectionReports.FillDataSet(sqlStmts, dataSetName, dsTableName); dt = dataSetName.Tables[0]; ds.Tables[0].Merge(dt); // rptDoc.Load(Server.MapPath("CryDebitNote.rpt")); rptDoc.Load(@"C:\inetpub\wwwroot\pub impexcryst\Billing\CryDebitNote.rpt"); rptDoc.SetDataSource(ds); MemoryStream oStream; // using System.IO oStream = (MemoryStream) rptDoc.ExportToStream( CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(oStream.ToArray()); Response.End(); //CrystalReportViewer1.ReportSource = rptDoc; //string[] a = new string[2]; //ConnectionReports.ShowReportWithParameter(rptDoc, ds,a, fType); } }
public pdfToCrystalReport(ReportDocument rpt) { _contentBytes = StreamToBytes(rpt.ExportToStream(ExportFormatType.PortableDocFormat)); }
/// <summary> /// 利用 CrystalReport 匯出 PDF 或是 EXCEL /// </summary> /// <param name="s_FileName">檔名</param> /// <param name="s_rptFilePath">rpt檔的路徑</param> /// <param name="dt_Source">要列印的資料</param> /// <param name="e_Type">PDF or EXCEL</param> private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, ExportFormatType e_Type) { ReportDocument report = new ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); System.IO.Stream stream = report.ExportToStream(e_Type); byte[] bytes = new byte[stream.Length]; stream.Read(bytes, 0, bytes.Length); stream.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//檔名 if (e_Type == ExportFormatType.Excel) { Response.ContentType = "application/vnd.ms-excel"; } else if (e_Type == ExportFormatType.PortableDocFormat) { Response.ContentType = "application/pdf"; } Response.OutputStream.Write(bytes, 0, bytes.Length); Response.Flush(); Response.Close(); report.Close(); }
//protected Boolean CheckAccessAble() //{ // if (m_perimission_array[(int)Authentication.FUN_INTERFACE.wzxqjh_jjd_report][0] == '1') return true; // return false; //} private void PrintPDF() { ReportDocument rpt_doc = new ReportDocument(); DataSet ds = new DataSet(); StringBuilder sqlstr = new StringBuilder(); //sqlstr.Append("select a.jjd_no,a.requisition_id req_id,a.rowstate,a.remark,a.package_no,a.part_no,b.part_name part_name,"); //sqlstr.Append("b.part_name_e part_name_e,gen_part_package_api.get_package_name(package_no) package_name,"); //sqlstr.Append("gen_part_package_item_api.get_unit(package_no,part_no) part_unit,gen_part_package_item_api.get_part_spec(package_no,part_no) part_spec,"); //sqlstr.Append("zh_qty,xh_qty,finish_time,rowversion,project_id proj_id from jp_pkg_jjd_line a,jp_pkg_requisition b where a.requisition_id=b.requisition_id"); sqlstr.Append(@"select a.jjd_no,a.requisition_id req_id,a.rowstate,a.remark,a.package_no,a.part_no, b.part_name part_name, b.part_name_e part_name_e, b.package_name package_name, b.part_unit part_unit, b.part_spec part_spec, b.released_qty xq_qty,a.zh_qty, a.xh_qty, a.finish_time, a.rowversion,a.project_id proj_id from jp_pkg_jjd_line a, jp_pkg_requisition_v b where a.requisition_id = b.requisition_id"); sqlstr.Append(string.Format(" and a.jjd_no ='{0}' order by a.part_no", m_jjd_no)); OleDbConnection conn = new OleDbConnection(DBHelper.OleConnectionString); OleDbCommand cmd = new OleDbCommand(); OleDbDataAdapter da = new OleDbDataAdapter(cmd); //DeliveryVoucher dvchr = (DeliveryVoucher)Session["delivery_voucher"]; PkgJjd objJjd = new PkgJjd(m_jjd_no); //sqlstr.Append(" and requisition_id in ("); //for (int i = 0; i < dvchr.DeliveryItems.Count; i++) //{ // if (i == dvchr.DeliveryItems.Count - 1) // { // sqlstr.Append(string.Format("'{0}'", dvchr.DeliveryItems[i].ToString())); // } // else // { // sqlstr.Append(string.Format("'{0}',", dvchr.DeliveryItems[i].ToString())); // } //} //sqlstr.Append(" )"); cmd.Connection = conn; cmd.CommandText = sqlstr.ToString(); da.Fill(ds); rpt_doc.Load(Request.PhysicalApplicationPath + "\\UI\\Report\\CrysPkgJjd.rpt"); rpt_doc.SetDataSource(ds.Tables[0]); //dvchr.SetDeliveryVoucherNo(); rpt_doc.SetParameterValue("jjd_no", m_jjd_no); //rpt_doc.SetParameterValue("kuwei", ""); rpt_doc.SetParameterValue("place", objJjd.PlaceName); rpt_doc.SetParameterValue("receiver", objJjd.ReceiptPerson); rpt_doc.SetParameterValue("recieve_date", objJjd.ReceiptDate); rpt_doc.SetParameterValue("receiver_contact", objJjd.ReceiptContract); rpt_doc.SetParameterValue("ZHd", objJjd.ZhPlace); rpt_doc.SetParameterValue("ZHr", objJjd.ZhPerson); rpt_doc.SetParameterValue("ZHdh", objJjd.ZhContract); rpt_doc.SetParameterValue("ZHArrTime", objJjd.ZhArrTime); rpt_doc.SetParameterValue("XQbm", objJjd.XQDept); rpt_doc.SetParameterValue("XQlxr", objJjd.XQPerson); rpt_doc.SetParameterValue("XQdh", objJjd.XQContract); rpt_doc.SetParameterValue("CYgs", objJjd.CyCompany); rpt_doc.SetParameterValue("CYr", objJjd.CyPerson); rpt_doc.SetParameterValue("CYdh", objJjd.CyContract); rpt_doc.SetParameterValue("CYpz", objJjd.CycCarNo); rpt_doc.SetParameterValue("CYjz", objJjd.CyDoc); rpt_doc.PrintOptions.PaperOrientation = PaperOrientation.Landscape; rpt_doc.PrintOptions.PaperSize = PaperSize.PaperA4; using (MemoryStream fp = (MemoryStream)(rpt_doc.ExportToStream(ExportFormatType.PortableDocFormat))) { Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(fp.ToArray()); fp.Close(); Response.End(); } rpt_doc.Close(); rpt_doc.Dispose(); }
protected void CriaPDF() { Hashtable hash = (Hashtable)Session["HashProducaoMedicoRegulador"]; DSCabecalhoProducaoMedicoRegulador cabecalho = new DSCabecalhoProducaoMedicoRegulador(); cabecalho.Tables.Add((DataTable)hash["cabecalho"]); DSRelatorioProducaoMedicoRegulador conteudo = new DSRelatorioProducaoMedicoRegulador(); conteudo.Tables.Add((DataTable)hash["corpo"]); ReportDocument repDoc = new ReportDocument(); repDoc.Load(Server.MapPath("RelatoriosCrystal/CrystalReportViewer_RelatorioProducaoMedicoRegulador.rpt")); repDoc.SetDataSource(conteudo.Tables[1]); repDoc.Subreports["CrystalReportViewer_CabecalhoProducaoMedicoRegulador.rpt"].SetDataSource(cabecalho.Tables[1]); //repDoc.Database.Tables["CabecalhoAgendaPrestador"].SetDataSource((DataTable)hash["cabecalho"]); //repDoc.Database.Tables["RelatorioAgendaPrestador"].SetDataSource((DataTable)hash["corpo"]); System.IO.Stream s = repDoc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "applicattion/octect-stream"; Response.AddHeader("Content-Disposition", "attachment;filename=RelatorioProducaoMedicosReguladores.pdf"); Response.AddHeader("Content-Length", s.Length.ToString()); Response.BinaryWrite(((System.IO.MemoryStream)s).ToArray()); Response.End(); }