protected void Page_Load(object sender, EventArgs e)
{
MetodosPontoFrequencia.Frequencia Freq = new MetodosPontoFrequencia.Frequencia();
MetodosPontoFrequencia.DataSetPontoFrequencia ds = new DataSetPontoFrequencia();
MetodosPontoFrequencia.PreencheTabela pt = new MetodosPontoFrequencia.PreencheTabela();
Freq.HorasDias(7, 688, 2014, ds, 4, 7);
Stimulsoft.Report.StiReport Report = new Stimulsoft.Report.StiReport();
//Stimulsoft.Report.Web.StiWebDesigner st1 = new Stimulsoft.Report.Web.StiWebDesigner();
Report.Load(Server.MapPath(@"~/Relatorio/RPT/ReportTesteFeito.mrt"));
Report.RegData("DatasetPontoFrequencia", ds);
Report.Render();
MemoryStream memStream = new MemoryStream();
Stimulsoft.Report.Export.StiPdfExportService Export = new Stimulsoft.Report.Export.StiPdfExportService();
Export.ExportPdf(Report, memStream, Stimulsoft.Report.StiPagesRange.All, 100, 100, false, false, true, true, "", "", Stimulsoft.Report.Export.StiUserAccessPrivileges.All, Stimulsoft.Report.Export.StiPdfEncryptionKeyLength.Bit128, false);
//HttpContext.Current.Response.ClearContent();
//HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.BinaryWrite(memStream.ToArray());
//HttpContext.Current.Response.Flush();
//HttpContext.Current.Response.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
MetodosPontoFrequencia.Frequencia Freq = new MetodosPontoFrequencia.Frequencia();
DataSetPontoFrequencia ds = new DataSetPontoFrequencia();
MetodosPontoFrequencia.PreencheTabela pt = new MetodosPontoFrequencia.PreencheTabela();
Freq.HorasDias(7, 688, 2014, ds, 4, 7);
Stimulsoft.Report.StiReport Report = new Stimulsoft.Report.StiReport();
//Stimulsoft.Report.Web.StiWebDesigner st1 = new Stimulsoft.Report.Web.StiWebDesigner();
Report.Load(Server.MapPath(@"~/Relatorio/RPT/rptFolhaFrequencia.mrt"));
Report.RegData("DatasetPontoFrequencia", ds);
Report.Render();
System.IO.MemoryStream memStream = new System.IO.MemoryStream();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.AddHeader("Teste.pdf", "");
Stimulsoft.Report.Export.StiPdfExportService Export = new Stimulsoft.Report.Export.StiPdfExportService();
Export.ExportPdf(Report, memStream, Stimulsoft.Report.StiPagesRange.All, 100, 100, false, false, true, true, "", "", Stimulsoft.Report.Export.StiUserAccessPrivileges.All, Stimulsoft.Report.Export.StiPdfEncryptionKeyLength.Bit40, false);
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "inline; filename=Teste.pdf");
Response.BinaryWrite(memStream.ToArray());
//Stimulsoft.Report.Web.StiReportResponse.ResponseAs(this,
//st1.Design(Report);
}
protected void SetandoRel()
{
//Report da stimulsoft
Stimulsoft.Report.StiReport Report = new Stimulsoft.Report.StiReport();
//Stimulsoft.Report.Web.StiWebDesigner st1 = new Stimulsoft.Report.Web.StiWebDesigner();
if (Convert.ToString(Request.QueryString["Rel"]) == "frmZuxa")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/EspelhoPonto.mrt"));
Report.Compile();
Report["DiasMes"] = TotalDiasMes.ToString();
Report["DiasCumpridos"] = TotalDiasCumprido.ToString();
Report["TotalHorasMes"] = TotalHoraMes.ToString();
Report["HorasCumpridas"] = HorasCumpridas.ToString();
}
Report.RegData("DatasetPontoFrequencia", ds);
Report.Render();
System.IO.MemoryStream memStream = new System.IO.MemoryStream();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.AddHeader("Pontoweb.pdf", "");
Stimulsoft.Report.Export.StiPdfExportService Export = new Stimulsoft.Report.Export.StiPdfExportService();
Export.ExportPdf(Report, memStream, Stimulsoft.Report.StiPagesRange.All, 100, 100, false, false, true, true,
"", "", Stimulsoft.Report.Export.StiUserAccessPrivileges.All, Stimulsoft.Report.Export.StiPdfEncryptionKeyLength.Bit40, false);
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "inline; filename=Pontoweb.pdf");
Response.BinaryWrite(memStream.ToArray());
}
protected void SetandoRel()
{
//Report da stimulsoft
Stimulsoft.Report.StiReport Report = new Stimulsoft.Report.StiReport();
//Stimulsoft.Report.Web.StiWebDesigner st1 = new Stimulsoft.Report.Web.StiWebDesigner();
if (Convert.ToString(Request.QueryString["Rel"]) == "frmZurel")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/folhafrequencia.mrt"));
Report.Compile();
Report["DiasMes"] = TotalDiasMes.ToString();
Report["DiasCumpridos"] = TotalDiasCumprido.ToString();
Report["TotalHorasMes"] = TotalHoraMes.ToString();
Report["HorasCumpridas"] = HorasCumpridas;
Report["HorasRealizadas"] = HorasRealizadas;
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmZuxa")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/EspelhoPonto.mrt"));
Report.Compile();
Report["DiasMes"] = TotalDiasMes.ToString();
Report["DiasCumpridos"] = TotalDiasCumprido.ToString();
Report["TotalHorasMes"] = TotalHoraMes.ToString();
Report["HorasCumpridas"] = HorasCumpridas.ToString();
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmsitu")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/situacaousuario.mrt"));
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmbco")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/totalhorasdiarias.mrt"));
Report.Compile();
//Report["Teste"] = 932;
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmbcoHoraMes")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/bancoHoraMes.mrt"));
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmRelacDia")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/relacaopontoDia.mrt"));
Report.Compile();
Report["DTInicio"] = INICIO;
Report["DTFim"] = FIM;
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmLocalRegistro")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/LocalRegistro.mrt"));
Report.Compile();
Report["DTInicio"] = INICIO;
Report["DTFim"] = FIM;
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmMotivoFalta")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/RelacaoMotivoFalta.mrt"));
Report.Compile();
Report["DTInicio"] = INICIO;
Report["DTFim"] = FIM;
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmfca")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/FichaCadastral.mrt"));
Report.Compile();
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmfi")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/FichaCadastral.mrt"));
Report.Compile();
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmdesc")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/RelRelacaoRegistroPeriodo.mrt"));
Report.Compile();
Report["DTInicio"] = INICIO;
Report["DTFim"] = FIM;
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmfaltaInjust")
{
if (RelUtilizado == 0)
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/RelDataInjustificada.mrt"));
}
else
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/RelRegistroAusente.mrt"));
}
//o Outro Aqui
Report.Compile();
Report["DTInicio"] = INICIO;
Report["DTFim"] = FIM;
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmAuditRel")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/RelatorioAuditoriaJustificativa.mrt"));
Report.Compile();
Report["DTInicio"] = INICIO;
Report["DTFim"] = FIM;
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmLogMaqRel")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/AuditoriaGeralDasConexoes.mrt"));
Report.Compile();
}
else if (Convert.ToString(Request.QueryString["Rel"]) == "frmInfoMaqRel")
{
Report.Load(Server.MapPath(@"~/Relatorio/STF/InformacoesMaquinasColetorLocal.mrt"));
Report.Compile();
}
Report.RegData("DatasetPontoFrequencia", ds);
Report.Render();
System.IO.MemoryStream memStream = new System.IO.MemoryStream();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.AddHeader("Pontoweb.pdf", "");
Stimulsoft.Report.Export.StiPdfExportService Export = new Stimulsoft.Report.Export.StiPdfExportService();
Export.ExportPdf(Report, memStream, Stimulsoft.Report.StiPagesRange.All, 100, 100, false, false, true, true,
"", "", Stimulsoft.Report.Export.StiUserAccessPrivileges.All, Stimulsoft.Report.Export.StiPdfEncryptionKeyLength.Bit40, false);
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "inline; filename=Pontoweb.pdf");
Response.BinaryWrite(memStream.ToArray());
}
