public static byte[] RenderMachineReport(SQLLib sql, List <string> MachineIDs, DateTime?From, DateTime?To, ReportingFlagsPaper ReportingPaper, string Output = "PDF")
{
byte[] ReportFile = GetReportPaperData(sql, "COMPUTERREPORT", Resources.Computer_Report);
ReportBook RepBook = new ReportBook();
foreach (string MachineID in MachineIDs)
{
Dictionary <string, object> Params = new Dictionary <string, object>();
Params.Add("MachineID", MachineID);
Params.Add("From", From);
Params.Add("To", To);
Params.Add("ReportingPaper", (int)ReportingPaper);
RepBook.ReportSources.Add(RenderReportData(ReportFile, Params));
}
InstanceReportSource instance = new InstanceReportSource();
instance.ReportDocument = RepBook;
ReportProcessor reportprocessor = new ReportProcessor();
RenderingResult result = reportprocessor.RenderReport(Output, instance, null);
return(result.DocumentBytes);
}
public async Task <ILoadedReport> LoadAsync(Guid competitionId, int classificationWeight, int categoryLength, int?differenceDistance, Guid[] distanceIdentifiers,
bool groupByDistanceCombinations, OptionalReportColumns optionalColumns)
{
var book = new ReportBook();
using (var workflow = racesWorkflowFactory())
{
var competition = await workflow.Competitions.Include(c => c.Venue).Include(c => c.ReportTemplate.Logos).FirstOrDefaultAsync(c => c.Id == competitionId);
if (competition == null)
{
return(null);
}
var distances = await workflow.Distances.Include(d => d.Combinations).Where(d => d.CompetitionId == competitionId && distanceIdentifiers.Contains(d.Id))
.OrderBy(d => d.Number).ToArrayAsync();
book.DocumentName = string.Format(Resources.ClassificationTitle, competition.Name,
groupByDistanceCombinations
? Resources.DistanceCombinations
: string.Join("-", distances.Select(d => d.Value)));
var selectorSets = new List <IRaceSelector[]>();
if (groupByDistanceCombinations)
{
var distanceCombinations = distances.SelectMany(d => d.Combinations).Distinct();
selectorSets.Add(distanceCombinations.Select(dc => (IRaceSelector) new RaceDistanceCombinationSelector(dc)).ToArray());
}
else
{
selectorSets.Add(new IRaceSelector[] { new RaceDistancesSelector(distances) });
}
foreach (var selectors in selectorSets.CartesianProduct().Select(p => p.ToArray()))
{
var classifications = await workflow.GetClassificationAsync(competitionId, classificationWeight, categoryLength, differenceDistance, selectors);
foreach (var classification in classifications)
{
if (classification.Distances.Count == 0)
{
continue;
}
var filters = selectors.Select(s => s.ToString());
if (classification.Category != string.Empty)
{
filters = filters.Concat(new[] { classification.Category });
}
var report = CreateReport(classification, differenceDistance, optionalColumns);
report.SetParameters(competition);
report.ReportParameters.Add("Filters", ReportParameterType.String, string.Join(" ", filters));
book.Reports.Add(report);
}
}
}
return(book.Reports.Count != 0 ? new TelerikLoadedReport(book) : null);
}
public async Task <ILoadedReport> LoadAsync(Guid competitionId, OptionalReportColumns optionalColumns)
{
var book = new ReportBook();
using (var context = contextFactory())
{
var competition = await context.Competitions.FirstOrDefaultAsync(c => c.Id == competitionId);
if (competition == null)
{
throw new CompetitionNotFoundException();
}
book.DocumentName = string.Format(Resources.FillInTitle, competition.Name);
foreach (var distance in await context.Distances.Where(d => d.CompetitionId == competitionId).OrderBy(d => d.Number).ToListAsync())
{
var calculator = calculatorManager.Get(distance.Discipline);
var length = calculator.Length(distance);
var report = await DrawFillInReportLoader.LoadAsync(context, competitionId, distance.Id, length, optionalColumns);
var drawReport = report as IPairsDrawReport;
if (drawReport?.Pairs.Count() == 0)
{
continue;
}
book.Reports.Add(report);
}
}
return(new TelerikLoadedReport(book));
}
protected void btnExport_Click(object sender, EventArgs e)
{
if (!DatosOk())
{
return;
}
int id_instalacion = -1;
if (instalacion != null)
{
id_instalacion = instalacion.InstalacionId;
}
string directorio = MapPath("/") + "\\Repo";
string nombreFichero = String.Format("ACT{0:0000000}_{1:0000}.pdf", id_instalacion, usuario.UsuarioId);
string fichero = String.Format("{0}\\{1}", directorio, nombreFichero);
ReportProcessor reportProcessor = new ReportProcessor();
RenderingResult renderingResult = null;
string nombre = "";
switch (informe)
{
case "RptActa":
Plantilla plantilla = CntLainsaSci.GetPlantilla(1, ctx); // la primera plantilla es la de acta.
string numeroAutorizado = ConfigurationManager.AppSettings["NumeroAutorizado"];
string contenido = String.Format(plantilla.Contenido, numeroAutorizado, tecnicoResponsable.Nombre, actaNumero, fechaActa);
ReportBook reportBook = new ReportBook();
RptCartaActa rptCartaActa = new RptCartaActa(contenido);
reportBook.Reports.Add(rptCartaActa);
if (instalacion != null)
{
RptInformeActa rptInformeActa = new RptInformeActa(instalacion, observaciones, actaNumero, fechaActa, tecnicoResponsable.Nombre, ctx);
reportBook.Reports.Add(rptInformeActa);
}
else
{
RptInformeActaEmpresa rptInformeActaEmpresa = new RptInformeActaEmpresa(emp, observaciones, actaNumero, fechaActa, tecnicoResponsable.Nombre, ctx);
reportBook.Reports.Add(rptInformeActaEmpresa);
}
renderingResult = reportProcessor.RenderReport("PDF", reportBook, null);
break;
}
FileStream fs = new FileStream(fichero, FileMode.Create);
fs.Write(renderingResult.DocumentBytes, 0, renderingResult.DocumentBytes.Length);
fs.Close();
// abrir como documento sobre el repositorio
nombre = txtActaNumero.Text + "_" + DateTime.Now.ToShortDateString();
string url = String.Format("DocumentoView.aspx?FileName={0}&InstalacionId={1}&Nombre={2}&EmpresaId={3}", nombreFichero, id_instalacion, nombre, emp.EmpresaId);
string jCommand = String.Format("parent.openOutSide('{0}', 'DocumentoView');", url);
RadAjaxManager1.ResponseScripts.Add(jCommand);
//string url = String.Format("VisorInforme.aspx?Informe=RptInformeActaEmpresas&prueba=arg&emp={0}",emp.EmpresaId);
//string jCommand = String.Format("parent.openOutSide('{0}','{1}');", url, "VisorInforme");
//RadAjaxManager1.ResponseScripts.Add(jCommand);
}
public async Task <ILoadedReport> LoadAsync(Guid competitionId, OptionalReportColumns optionalColumns)
{
var book = new ReportBook();
using (var context = contextFactory())
{
var competition = await context.Competitions.FirstOrDefaultAsync(c => c.Id == competitionId);
if (competition == null)
{
throw new CompetitionNotFoundException();
}
book.DocumentName = string.Format(Resources.DrawTitle, competition.Name);
foreach (var distance in await context.Distances.Where(d => d.CompetitionId == competitionId).OrderBy(d => d.Number).ToListAsync())
{
Report report = null;
switch (distance.Discipline)
{
case "SpeedSkating.LongTrack.PairsDistance.Individual":
report = await DrawReportLoader <DrawReport> .LoadAsync(context, competitionId, distance.Id, optionalColumns);
break;
case "SpeedSkating.LongTrack.PairsDistance.TeamPursuit":
case "SpeedSkating.LongTrack.PairsDistance.TeamSprint":
report = await DrawReportLoader <TeamDrawReport> .LoadAsync(context, competitionId, distance.Id, optionalColumns);
break;
case "SpeedSkating.LongTrack.MassStartDistance":
report = await MassStartDrawReportLoader.LoadAsync(context, competitionId, distance.Id, optionalColumns);
break;
}
var pairsDrawReport = report as IPairsDrawReport;
if (pairsDrawReport?.Pairs.Count() == 0)
{
continue;
}
book.Reports.Add(report);
}
}
if (book.Reports.Count == 0)
{
return(null);
}
return(new TelerikLoadedReport(book));
}
/// <summary>
/// Устанавливает истоники вложенных отчетов для книги.
/// </summary>
/// <param name="context"></param>
/// <param name="parentReportOid"></param>
/// <param name="book"></param>
void SetReportBookSorces(ReportDbContext context, Guid parentReportOid, ref ReportBook book)
{
var oldSources = book.ReportSources.ToArray();
book.ReportSources.Clear();
int count = oldSources.Count();
for (int i = 0; i < count; i++)
{
book.ReportSources.Add(GetSubReportSorce(context, oldSources[i], parentReportOid));
}
}
private void FormShapeLibrary_Load(object sender, EventArgs e)
{
_book = GeneralRep.ActiveBook;
GeneralRep.Application.CommandBars.OnUpdate += OnShapeChange;
OnShapeChange();
LoadShape();
//var menu = new ContextMenuStrip();
//var item = menu.Items.Add("Выбрать цвет");
//item.Click += SelectColor;
//ShapeFormula.ContextMenuStrip = menu;
}
public void AddReportBook()
{
RestoreDate();
var ReportBookRepository = new ReportBookRepository(mockContext.Object);
ReportBook reportBook = new ReportBook();
ReportBookRepository.Add(reportBook);
Assert.IsNotNull(_ReportBooks.Where(s => reportBook.Id == s.Id).FirstOrDefault());
Assert.AreEqual(ReportBookRepository.Get(reportBook.Id).Id, reportBook.Id);
}
public void GetReportBookById()
{
RestoreDate();
var ReportBookRepository = new ReportBookRepository(mockContext.Object);
ReportBook reportBook = new ReportBook();
ReportBookRepository.Add(reportBook);
Assert.IsNotNull(_ReportBooks.FirstOrDefault());
Assert.IsNotNull(ReportBookRepository.Get(reportBook.Id));
}
public async Task <ILoadedReport> LoadAsync(Guid competitionId, OptionalReportColumns optionalColumns)
{
var book = new ReportBook();
using (var workflow = workflowFactory())
{
var competition = await workflow.Competitions.Include(c => c.Venue).Include(c => c.ReportTemplate.Logos).FirstOrDefaultAsync(c => c.Id == competitionId);
if (competition == null)
{
throw new CompetitionNotFoundException();
}
book.DocumentName = string.Format(Resources.CompetitorGroupTitle, competition.Name);
ICompetitorGroupComparer comparer;
switch (optionalColumns)
{
case OptionalReportColumns.HomeVenueCode:
comparer = HomeVenueComparer.Default;
break;
case OptionalReportColumns.NationalityCode:
comparer = NationalityComparer.Default;
break;
case OptionalReportColumns.ClubShortName:
comparer = ClubComparer.Default;
break;
default:
comparer = LicenseKeyComparer.Default;
break;
}
var races = new List <RankedRace>();
foreach (var distance in await workflow.Distances.Where(d => d.CompetitionId == competitionId).OrderBy(d => d.Number).ToListAsync())
{
var distanceResult = await workflow.GetDistanceResultAsync(distance);
races.AddRange(distanceResult);
}
var groups = races.GroupBy(r => r.Race.Competitor, comparer.Group, comparer).SortAndRank().Where(g => g.TotalPoints > 0).ToList();
book.Reports.Add(CreateRankingReport(competition, groups));
}
return(new TelerikLoadedReport(book));
}
public void DeleteReportBook()
{
RestoreDate();
var ReportBookRepository = new ReportBookRepository(mockContext.Object);
ReportBook reportBook = new ReportBook();
ReportBookRepository.Add(reportBook);
ReportBookRepository.Remove(reportBook);
Assert.IsNull(_ReportBooks.Where(s => reportBook.Id == s.Id).FirstOrDefault());
}
protected void btnPreview_Click(object sender, EventArgs e)
{
if (dtpStartDate.SelectedDate > dtpEndDate.SelectedDate || dtpStartDate.SelectedDate > DateTime.Now)
{
return;
}
if (dtpEndDate.SelectedDate.ToString().Trim() == string.Empty)
{
return;
}
if ((dtpStartDate.SelectedDate.ToString().Trim() == string.Empty))
{
dtpStartDate.SelectedDate = dtpStartDate.MinDate;
}
//Load All Valid Kas
KasQuery kasQ = new KasQuery("a");
PeriodeAnggaranQuery paQ = new PeriodeAnggaranQuery("b");
kasQ.InnerJoin(paQ).On(kasQ.PeriodeId == paQ.Id);
kasQ.Select(kasQ.KaCode, kasQ.KaName);
paQ.Where(paQ.IsClosed == false);
KasCollection kasC = new KasCollection();
kasC.Load(kasQ);
ReportBook rb = new ReportBook();
foreach (Kas k in kasC)
{
TransQuery tQ = new TransQuery("c");
tQ.Select(tQ.TransNumber, tQ.TransDate, tQ.Descript, tQ.DebitAmount, tQ.CreditAmount);
tQ.Where(tQ.TransDate >= dtpStartDate.SelectedDate, tQ.TransDate <= dtpEndDate.SelectedDate, tQ.KasId == k.KaCode);
TransCollection tColl = new TransCollection();
tColl.Load(tQ);
if (tColl.Count > 0)
{
RSCM_BKU_web.Report.LaporanKasBank report1 = new RSCM_BKU_web.Report.LaporanKasBank();
report1.ReportParameters[0].Value = k.KaName;
report1.ReportParameters[1].Value = dtpStartDate.SelectedDate;
report1.ReportParameters[2].Value = dtpEndDate.SelectedDate;
report1.DataSource = tColl;
rb.Reports.Add(report1);
}
}
//ReportViewer1.Report = rb;
//ReportViewer1.RefreshReport();
}
public async Task <ILoadedReport> LoadAsync(Guid competitionId, OptionalReportColumns optionalColumns)
{
var book = new ReportBook();
using (var workflow = workflowFactory())
{
var competition = await workflow.Competitions.FirstOrDefaultAsync(c => c.Id == competitionId);
if (competition == null)
{
throw new CompetitionNotFoundException();
}
book.DocumentName = string.Format(Resources.ResultTitle, competition.Name);
foreach (var distance in await workflow.Distances.Where(d => d.CompetitionId == competitionId).OrderBy(d => d.Number).ToListAsync())
{
if (distance.Discipline.StartsWith("SpeedSkating.LongTrack.PairsDistance"))
{
var result = await DistanceResultReportLoader.LoadAsync(workflow, competitionId, distance.Id, optionalColumns);
if (result.Races.Count() == 0)
{
continue;
}
book.Reports.Add(result);
var details = await DistanceDetailedResultReportLoader.LoadAsync(workflow, competitionId, distance.Id, expertManager, optionalColumns);
book.Reports.Add(details);
}
else if (distance.Discipline.StartsWith("SpeedSkating.LongTrack.MassStartDistance"))
{
var result = await MassStartDistanceResultReportLoader.LoadAsync(workflow, competitionId, distance.Id, optionalColumns);
if (result.Races.Count() == 0)
{
continue;
}
book.Reports.Add(result);
}
}
}
return(new TelerikLoadedReport(book));
}
public ActionResult Index(Guid id, ReportBookViewModel reportBookVM)
{
Teacher teacher = _teacherService.GetTeacher(_accountService.GetAccount(User.Identity.Name));
Facultative facultative = teacher.MyFacultatives.Where(s => s.Id == id).FirstOrDefault();
if (facultative == null)
{
RedirectToAction("Index", "Message", new { type = "Error", Message = "Dont find facultative" });
}
facultative = _teacherService.GetFacultative(new Facultative()
{
Id = id
});
reportBookVM.Elective = facultative;
ReportBook reportBook = _teacherService.CreateReportBook(facultative.Name, facultative);
if (Request.HttpMethod == "POST")
{
if (ModelState.IsValid)
{
if (reportBook.Reports.Count > 0)
{
reportBook.Reports.Clear();
}
foreach (var item in reportBookVM.Reports)
{
facultative.Status = FacultativeStatus.Finished;
_teacherService.AddReport(reportBook, new Report(facultative.Audience.Where(s => s.Id == item.Id).FirstOrDefault(), item.Mark));
}
_teacherService.ChangeStateEntity(facultative);
_teacherService.ChangeStateEntity(reportBook);
return(RedirectToAction("Index", "TeacherFacultative", new { id = id }));
}
}
_teacherService.ChangeStateEntity(reportBook);
return(View(reportBookVM));
}
public async Task <ILoadedReport> LoadAsync(string licenseIssuerId, string discipline, string distanceDiscipline, int[][] distanceValues, TimeSpan?toTime,
decimal?maxPoints, int?count, IEnumerable <IHistoricalTimeSelector[]> selectorSets, OptionalReportColumns optionalColumns, int?classificationWeight)
{
if (distanceValues == null)
{
throw new ArgumentNullException(nameof(distanceValues));
}
var book = new ReportBook();
var i = 1;
using (var workflow = personTimesWorkflowFactory())
foreach (var distances in distanceValues)
{
foreach (var selectors in selectorSets.CartesianProduct().Select(p => p.ToArray()))
{
Report report = null;
if (distances.Length == 1)
{
var people = await workflow.GetRankingAsync(licenseIssuerId, discipline, distanceDiscipline, distances[0], toTime, count, selectors);
report = CreateTimeReport(distances[0], people, optionalColumns);
}
else if (distances.Length > 1)
{
var people = await workflow.GetRankingAsync(licenseIssuerId, discipline, distanceDiscipline, distances, classificationWeight, maxPoints, count, selectors);
report = CreatePointsReport(distances, people, optionalColumns);
}
if (report == null)
{
continue;
}
report.ReportParameters.Add("Filters", ReportParameterType.String, string.Join(", ", (IEnumerable <IHistoricalTimeSelector>)selectors));
report.DocumentName = string.Join("_", selectors.Select(s => s.ToShortString()));
book.Reports.Add(report);
i++;
}
}
return(book.Reports.Count != 0 ? new TelerikLoadedReport(book) : null);
}
public async Task <ILoadedReport> LoadAsync(Guid competitionId, OptionalReportColumns optionalColumns)
{
var book = new ReportBook();
using (var workflow = workflowFactory())
{
var competition = await workflow.Competitions.FirstOrDefaultAsync(c => c.Id == competitionId);
if (competition == null)
{
throw new CompetitionNotFoundException();
}
book.DocumentName = string.Format(Resources.CompetitorListTitle, competition.Name);
var combinations = await workflow.Combinations(competitionId).OrderBy(dc => dc.Number).ToListAsync();
foreach (var combination in combinations)
{
var query = workflow.Competitors(competitionId, combination.Id).Select(c => c.Competitor);
var people = await query.OfType <PersonCompetitor>().CountAsync();
if (people > 0)
{
var report = await CompetitorListReportLoaderBase <CompetitorListReport, PersonCompetitor> .LoadAsync(workflow, competitionId, combination.Id, optionalColumns);
book.Reports.Add(report);
}
var teams = await query.OfType <TeamCompetitor>().CountAsync();
if (teams > 0)
{
var report = await CompetitorListReportLoaderBase <TeamCompetitorListReport, TeamCompetitor> .LoadAsync(workflow, competitionId, combination.Id, optionalColumns);
book.Reports.Add(report);
}
}
}
return(new TelerikLoadedReport(book));
}
protected void btnPreview_Click(object sender, EventArgs e)
{
if (dtpStartDate.SelectedDate > dtpEndDate.SelectedDate || dtpStartDate.SelectedDate > DateTime.Now)
return;
if (dtpEndDate.SelectedDate.ToString().Trim() == string.Empty)
return;
if ((dtpStartDate.SelectedDate.ToString().Trim() == string.Empty))
dtpStartDate.SelectedDate = dtpStartDate.MinDate;
//Load All Valid Kas
KasQuery kasQ = new KasQuery("a");
PeriodeAnggaranQuery paQ = new PeriodeAnggaranQuery("b");
kasQ.InnerJoin(paQ).On(kasQ.PeriodeId == paQ.Id);
kasQ.Select(kasQ.KaCode, kasQ.KaName);
paQ.Where(paQ.IsClosed == false);
KasCollection kasC = new KasCollection();
kasC.Load(kasQ);
ReportBook rb = new ReportBook();
foreach (Kas k in kasC)
{
TransQuery tQ = new TransQuery("c");
tQ.Select(tQ.TransNumber, tQ.TransDate, tQ.Descript, tQ.DebitAmount, tQ.CreditAmount);
tQ.Where(tQ.TransDate >= dtpStartDate.SelectedDate, tQ.TransDate <= dtpEndDate.SelectedDate,tQ.KasId == k.KaCode);
TransCollection tColl = new TransCollection();
tColl.Load(tQ);
if (tColl.Count > 0)
{
RSCM_BKU_web.Report.LaporanKasBank report1 = new RSCM_BKU_web.Report.LaporanKasBank();
report1.ReportParameters[0].Value = k.KaName;
report1.ReportParameters[1].Value = dtpStartDate.SelectedDate;
report1.ReportParameters[2].Value = dtpEndDate.SelectedDate;
report1.DataSource = tColl;
rb.Reports.Add(report1);
}
}
//ReportViewer1.Report = rb;
//ReportViewer1.RefreshReport();
}
protected void GerarRelatorio()
{
if (m_oSumario.ObterSumario(Convert.ToInt32(UtSessao.Sessao["Id058"])))
{
Rpt.Report.DocumentName = "Sumário Alta";
Rpt.m_iId058 = Convert.ToInt32(UtSessao.Sessao["Id058"]);
Rpt.m_sIdade = UtSessao.Sessao["IDADEPACIENTE"].ToString() + " ano(s)";
Rpt.m_sLeitoAndar = UtSessao.Sessao["LEITO"].ToString();
Rpt.m_sNascimento = UtSessao.Sessao["DATANASCIMENTO"].ToString();
Rpt.m_sNome = UtSessao.Sessao["PACIENTE"].ToString();
Rpt.m_sSexo = UtSessao.Sessao["SEXOPACIENTE"].ToString();
Rpt.m_sRegistro = UtSessao.Sessao["Registro"].ToString();
Rpt.m_sHospital = UtSessao.Sessao["UNIDADE"].ToString();
Rpt.m_sDtInternacao = UtSessao.Sessao["ENTRADA"].ToString();
m_dDtInte = UtSessao.Sessao["ENTRADA"].ToString();
m_dDtAlta = UtSessao.Sessao["SAIDA"].ToString();
if (m_dDtAlta == "NÃO INFORMADA")
{
Rpt.m_sDtAlta = m_oSumario.DATA_ALTA.ToString().Trim();
CalculaDiasInternados(m_oSumario.DATA_ALTA.ToString().Trim());
}
else
{
Rpt.m_sDtAlta = m_dDtAlta;
CalculaDiasInternados(m_oSumario.DATA_ALTA.ToString().Trim());
}
Rpt.m_sDiasInternados = m_sDiasInternados;
Rpt.m_sMotivoAdmissao = m_oSumario.MOTIVO_ADMISSAO;
Rpt.m_sAlergia = m_oSumario.ALERGIA_MEDICAMENTO;
Rpt.m_sAlergiaQuais = m_oSumario.ALERGIA_MEDICAMENTO_QUAL;
Rpt.m_sAlergiaTipo = m_oSumario.ALERGIA_MEDICAMENTO_TIPO;
Rpt.m_sHistoriaExameFisico = m_oSumario.HISTORIA_EXAME_FISICO;
Rpt.m_sCondicaoPaciente = m_oSumario.CONDICAO_PACIENTE_ALTA;
Rpt.m_sDestinoPacienteAlta = m_oSumario.DESTINO_PACIENTE_ALTA;
Rpt.m_sHemoTransfusao = m_oSumario.HEMOTRANSFUSAO;
Rpt.m_sHemoReacao = m_oSumario.REACAO_HEMOTRANSFUSAO;
Rpt.m_sHemoTipo = m_oSumario.TIPO_REACAO_HEMOTRANSFUSAO;
Rpt.m_sMedicacoes = m_oSumario.MEDICACAO_ADMISSAO;
Rpt.m_sColonizacao = m_oSumario.COLONIZACAO_MDR;
Rpt.m_sColonizacaoDescricao = m_oSumario.DESCRICAO_MDR;
Rpt.PageSettings.Landscape = false;
Rpt.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
Rpt.PageSettings.Margins.Bottom = Telerik.Reporting.Drawing.Unit.Cm(1);
Rpt.PageSettings.Margins.Top = Telerik.Reporting.Drawing.Unit.Cm(1);
Rpt.PageSettings.Margins.Left = Telerik.Reporting.Drawing.Unit.Cm(1);
Rpt.PageSettings.Margins.Right = Telerik.Reporting.Drawing.Unit.Cm(1);
Rpt.ProcessarRelatorio();
//Receituário
RptA.m_iId058 = Convert.ToInt32(UtSessao.Sessao["Id058"]);
//RptA.PageSettings.Landscape = false;
//RptA.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
//RptA.PageSettings.Margins.Bottom = Telerik.Reporting.Drawing.Unit.Cm(1);
//RptA.PageSettings.Margins.Top = Telerik.Reporting.Drawing.Unit.Cm(1);
//RptA.PageSettings.Margins.Left = Telerik.Reporting.Drawing.Unit.Cm(1);
//RptA.PageSettings.Margins.Right = Telerik.Reporting.Drawing.Unit.Cm(1);
RptA.m_sIdade = UtSessao.Sessao["IDADEPACIENTE"].ToString() + " ano(s)";
RptA.m_sLeitoAndar = UtSessao.Sessao["LEITO"].ToString();
RptA.m_sNascimento = UtSessao.Sessao["DATANASCIMENTO"].ToString();
RptA.m_sNome = UtSessao.Sessao["PACIENTE"].ToString();
RptA.m_sSexo = UtSessao.Sessao["SEXOPACIENTE"].ToString();
RptA.m_sRegistro = UtSessao.Sessao["Registro"].ToString();
RptA.m_sHospital = UtSessao.Sessao["UNIDADE"].ToString();
RptA.m_sDtInternacao = UtSessao.Sessao["ENTRADA"].ToString();
m_dDtAlta = UtSessao.Sessao["SAIDA"].ToString();
if (m_dDtAlta == "NÃO INFORMADA")
{
RptA.m_sDtAlta = m_oSumario.DATA_ALTA.ToString().Trim();
CalculaDiasInternados(m_oSumario.DATA_ALTA.ToString().Trim());
}
else
{
RptA.m_sDtAlta = m_dDtAlta;
CalculaDiasInternados(m_oSumario.DATA_ALTA.ToString().Trim());
}
if (m_oSumario.CRM_MEDICO_RECEITUARIO != null)
{
m_oSumario.ObterMedicoDW(m_oSumario.CRM_MEDICO_RECEITUARIO.Trim(), " ");
RptA.m_sCRM = m_oSumario.CRM_MEDICO_RECEITUARIO.Trim();
}
if (m_oSumario.MEDICO_RECEITUARIO != null)
{
RptA.m_sMedico = m_oSumario.MEDICO_RECEITUARIO;
}
else
{
RptA.m_sMedico = " ";
RptA.m_sCRM = " ";
}
RptA.m_sDiasInternados = m_sDiasInternados;
RptA.ProcessarRelatorio();
ReportBook RptBook = new ReportBook();
RptBook.DocumentName = "SumarioAlta";
RptBook.Reports.Add(Rpt);
RptBook.Reports[0].PageNumberingStyle = PageNumberingStyle.Restart;
if (RptA.SemRegistro)
{
RptBook.Reports.Add(RptA);
//RptBook.Reports[1].PageNumberingStyle = PageNumberingStyle.Restart;
}
//RptBook.Reports[0].PageNumberingStyle = PageNumberingStyle.Restart;
//if (RptA.SemRegistro)
//{
// RptBook.Reports[1].PageNumberingStyle = PageNumberingStyle.Restart;
//}
ViewRptSumario.Report = RptBook;
}
}
private void FormLinksList_Load(object sender, EventArgs e)
{
_book = GeneralRep.ActiveBook;
}
protected void Page_Init(object sender, EventArgs e)
{
// it gets an appropiate context (LainsaSciCTX -> web.config)
ctx = new LainsaSci("LainsaSciCTX");
// verify if a Usuario is logged
usuario = CntWinWeb.IsSomeoneLogged(this, ctx);
if (usuario == null)
{
Response.Redirect("Default.aspx");
}
else
{
Session["UsuarioId"] = usuario.UsuarioId;
}
if (Request.QueryString["Informe"] != null)
{
informe = Request.QueryString["Informe"];
switch (informe)
{
case "RptInventario":
RptInventario rptInventario = new RptInventario();
this.Title = "Inventario por instalacion";
if (usuario.Empresa != null)
{
rptInventario.ReportParameters["Empresa"].Value = usuario.Empresa.EmpresaId;
rptInventario.ReportParameters["Empresa"].Visible = false;
}
ReportViewer1.Report = rptInventario;
break;
case "RptIncidenciaEmpresa":
RptIncidenciaEmpresa rptIncidenciaEmpresa = new RptIncidenciaEmpresa();
this.Title = "Incidencias por empresa";
if (usuario.Empresa != null)
{
rptIncidenciaEmpresa.ReportParameters["Empresa"].Value = usuario.Empresa.EmpresaId;
rptIncidenciaEmpresa.ReportParameters["Empresa"].Visible = false;
}
ReportViewer1.Report = rptIncidenciaEmpresa;
break;
}
}
if (Request.QueryString["Observaciones"] != null)
{
observaciones = Request.QueryString["Observaciones"];
}
if (Request.QueryString["FechaActa"] != null)
{
fechaActa = DateTime.Parse(Request.QueryString["FechaActa"]);
}
if (Request.QueryString["ActaNumero"] != null)
{
actaNumero = Request.QueryString["ActaNumero"];
}
if (Request.QueryString["TecnicoResponsable"] != null)
{
Usuario usu = CntLainsaSci.GetUsuario(int.Parse(Request.QueryString["TecnicoResponsable"]), ctx);
tecnicoResponsable = usu.Nombre;
}
if (Request.QueryString["InstalacionId"] != null)
{
instalacion = CntLainsaSci.GetInstalacion(int.Parse(Request.QueryString["InstalacionId"]), ctx);
if (instalacion == null)
{
empresa = CntLainsaSci.GetEmpresa(int.Parse(Request.QueryString["EmpresaId"]), ctx);
}
if (instalacion != null || empresa != null)
{
switch (informe)
{
case "RptActa":
// este informe es especial y en realidad es un book
Plantilla plantilla = CntLainsaSci.GetPlantilla(1, ctx); // la primera plantilla es la de acta.
string numeroAutorizado = ConfigurationManager.AppSettings["NumeroAutorizado"];
string contenido = String.Format(plantilla.Contenido, numeroAutorizado, tecnicoResponsable, actaNumero, fechaActa);
ReportBook reportBook = new ReportBook();
RptCartaActa rptCartaActa = new RptCartaActa(contenido);
reportBook.Reports.Add(rptCartaActa);
if (instalacion != null)
{
RptInformeActa rptInformeActa = new RptInformeActa(instalacion, observaciones, actaNumero, fechaActa, tecnicoResponsable, ctx);
reportBook.Reports.Add(rptInformeActa);
}
else
{
RptInformeActaEmpresa rptInformeActaEmpresa = new RptInformeActaEmpresa(empresa, observaciones, actaNumero, fechaActa, tecnicoResponsable, ctx);
reportBook.Reports.Add(rptInformeActaEmpresa);
}
ReportViewer1.Report = reportBook;
break;
}
}
}
else if (Request.QueryString["ProgramaId"] != null)
{
programa = CntLainsaSci.GetPrograma(int.Parse(Request.QueryString["ProgramaId"]), ctx);
if (programa != null)
{
switch (informe)
{
case "RptPrograma2":
RptPrograma2 rptPrograma2 = new RptPrograma2(programa.ProgramaId, ctx);
ReportViewer1.Report = rptPrograma2;
break;
case "RptRevisionFormulario":
RptRevisionFormulario rptRF = new RptRevisionFormulario(programa, ctx);
ReportViewer1.Report = rptRF;
break;
case "RptInformePlanta":
RptInformePlanta rptIP = new RptInformePlanta(programa, ctx);
ReportViewer1.Report = rptIP;
break;
}
}
newRecord = false;
}
else if (Request.QueryString["EmpresaId"] != null)
{
empresa = CntLainsaSci.GetEmpresa(int.Parse(Request.QueryString["EmpresaId"]), ctx);
if (empresa != null)
{
desdeFecha = DateTime.Parse(Request.QueryString["DesdeFecha"]);
hastaFecha = DateTime.Parse(Request.QueryString["HastaFecha"]);
switch (informe)
{
case "RptResumenEmpresaInstalacion":
RptResumenEmpresaInstalacion rpt = new RptResumenEmpresaInstalacion(desdeFecha, hastaFecha, empresa.EmpresaId, int.Parse(Request.QueryString["InstId"]), ctx);
ReportViewer1.Report = rpt;
break;
case "RptFacturableEmpresaInstalacion":
RptFacturableEmpresaInstalacion rpt2 = new RptFacturableEmpresaInstalacion(desdeFecha, hastaFecha, empresa.EmpresaId, int.Parse(Request.QueryString["InstId"]), ctx);
ReportViewer1.Report = rpt2;
break;
case "RptResumenEmpresaTipoDispositivo":
RptResumenEmpresaTipoDispositivo rptT = new RptResumenEmpresaTipoDispositivo(desdeFecha, hastaFecha, empresa.EmpresaId, int.Parse(Request.QueryString["TipoDispId"]), ctx);
ReportViewer1.Report = rptT;
break;
case "RptFacturableEmpresaTipoDispositivo":
RptFacturableEmpresaTipoDispositivo rptT2 = new RptFacturableEmpresaTipoDispositivo(desdeFecha, hastaFecha, empresa.EmpresaId, int.Parse(Request.QueryString["TipoDispId"]), ctx);
ReportViewer1.Report = rptT2;
break;
case "RptResumenEmpresa":
RptResumenEmpresa rptE = new RptResumenEmpresa(desdeFecha, hastaFecha, empresa.EmpresaId, int.Parse(Request.QueryString["InstId"]), int.Parse(Request.QueryString["TipoDispId"]), ctx);
ReportViewer1.Report = rptE;
break;
case "RptFacturableEmpresa":
RptFacturableEmpresa rptE2 = new RptFacturableEmpresa(desdeFecha, hastaFecha, empresa.EmpresaId, int.Parse(Request.QueryString["InstId"]), int.Parse(Request.QueryString["TipoDispId"]), ctx);
ReportViewer1.Report = rptE2;
break;
}
}
}
else if (Request.QueryString["Filtro"] != null)
{
List <string> filtro = (List <string>)Session["Filtro"];
string consulta = "";
switch (informe)
{
case "RptConsultaRevision":
if (Request.QueryString["mode"].ToString() == "G")
{
RptConsultaRevisionGeneral cr = new RptConsultaRevisionGeneral(filtro);
ReportViewer1.Report = cr;
}
break;
case "RptConsultaDispositivos":
consulta = "Consulta dispositivos. ";
if (Session["Consulta"] != null)
{
consulta += (string)Session["Consulta"];
}
this.Title = consulta;
if (Request.QueryString["mode"].ToString() == "D")
{
RptConsultaDispositivos cd = new RptConsultaDispositivos(filtro, consulta);
ReportViewer1.Report = cd;
}
else
{
RptConsultaDispositivosGeneral cd = new RptConsultaDispositivosGeneral(filtro, consulta);
ReportViewer1.Report = cd;
}
break;
case "RptInfConsultaRevision":
IList <Revision> lr = new List <Revision>();
foreach (string rid in filtro)
{
lr.Add(CntLainsaSci.GetRevision(int.Parse(rid), ctx));
}
consulta = "Consulta revisiones";
if (Session["Consulta"] != null)
{
consulta = (string)Session["Consulta"];
}
this.Title = consulta;
RptInfConsultaRevision icr = new RptInfConsultaRevision(lr, consulta);
ReportViewer1.Report = icr;
break;
}
}
// control de skin
if (Session["Skin"] != null)
{
RadSkinManager1.Skin = Session["Skin"].ToString();
}
}
public Window_ReportViewer(ReportBook reportBook)
{
InitializeComponent();
isBook = true;
instanceReportSource.ReportDocument = reportBook;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var reportBook = new ReportBook();
var reportType = Convert.ToInt32(Request["reportType"]);
var idParameters = Request["id"].Split(',');
InstanceReportSource reportSource = new InstanceReportSource();
switch (reportType)
{
case (int)CConstValue.Report.InvoiceStudent:
case (int)CConstValue.Report.InvoiceAgency:
foreach (var id in idParameters)
{
reportBook.Reports.Add(new RInvoice(reportType, CurrentUserId, Convert.ToInt32(id)));
}
// lump sum invoice
if (reportBook.Reports.Count > 1)
{
reportBook.Reports.Add(new RInvoiceLumpSum(reportType, CurrentUserId, Request["id"]));
}
break;
case (int)CConstValue.Report.PaymentStudent:
case (int)CConstValue.Report.PaymentAgency:
var paymentReport = new RPayment(reportType, CurrentUserId, Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(paymentReport);
break;
case (int)CConstValue.Report.DetailPaymentStudent:
case (int)CConstValue.Report.DetailPaymentAgency:
var payment = new CPayment().Get(Convert.ToInt32(idParameters[0]));
var detailPaymentReport = new RPayment(reportType, CurrentUserId, payment.InvoiceId, Request["id"]);
reportBook.Reports.Add(detailPaymentReport);
break;
// Schools
case (int)CConstValue.Report.LetterOfAcceptance:
var letterOfAcceptance = new RLetterOfAcceptance(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(letterOfAcceptance);
break;
case (int)CConstValue.Report.LetterOfAcceptanceInTable:
var letterOfAcceptanceInTable = new RLetterOfAcceptanceInTable(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(letterOfAcceptanceInTable);
break;
case (int)CConstValue.Report.StudentContract:
var letterOfAcceptanceInTable2 = new RLetterOfAcceptanceInTable(Convert.ToInt32(Request["id"]));
var refundPolicy = new RRefundPolicy(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(letterOfAcceptanceInTable2);
reportBook.Reports.Add(refundPolicy);
break;
case (int)CConstValue.Report.OrientationForm:
var orientationForm = new ROrientationForm(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(orientationForm);
break;
case (int)CConstValue.Report.ConfirmationOfCompletionLetter:
var confirmationOfCompletionLetter = new RConfirmationOfCompletionLetter(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(confirmationOfCompletionLetter);
break;
case (int)CConstValue.Report.ConfirmationOfEnrollment:
var confirmationOfEnrollment = new RConfirmationOfEnrollment(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(confirmationOfEnrollment);
break;
// Academy
case (int)CConstValue.Report.Certification:
var certification = new RCertification(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(certification);
break;
case (int)CConstValue.Report.ClassSummary:
var classSummary = new RClassSummary(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(classSummary);
break;
case (int)CConstValue.Report.StartingStudents:
var startingStudents = new RStartingStudents(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(startingStudents);
break;
case (int)CConstValue.Report.CompletedGraduatesStudents:
var completedGraduatesStudents = new RCompletedGraduatesStudents(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(completedGraduatesStudents);
break;
case (int)CConstValue.Report.AttendanceSheet:
var attendanceSheet = new RAttendanceSheet(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(attendanceSheet);
break;
}
reportSource.ReportDocument = reportBook;
ReportViewer1.ReportSource = reportSource;
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
if (ddlDCNo.SelectedValue != "0")
{
ArrayList objList = new ArrayList();
ReportBook reportBook = new ReportBook();
int countCon = 0;
for (int i = 0; i < 1; i++)
{
if (ckbSpunCertificate.Checked)
{
reportBook.Reports.Add(new rptSpunCertificate());
(reportBook.Reports[countCon] as rptSpunCertificate).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
// objList.Add("ckbSpun");
}
if (ckbCommercialInvoice.Checked)
{
reportBook.Reports.Add(new rptCommercialInvoice());
(reportBook.Reports[countCon] as rptCommercialInvoice).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
//objList.Add("ckbCommercialInvoice");
}
if (ckbPreshipmentInspectionCertificate.Checked)
{
reportBook.Reports.Add(new rptPreShipmentInspectionCertificate());
(reportBook.Reports[countCon] as rptPreShipmentInspectionCertificate).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
//continue;
//objList.Add("ckbPreshipmentInspectionCertificate");
}
if (ckbDeliveryChallan.Checked)
{
reportBook.Reports.Add(new rptDeliveryChallanTruckReceipt());
(reportBook.Reports[countCon] as rptDeliveryChallanTruckReceipt).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
//continue;
//objList.Add("ckbDeliveryChallan");
}
if (ckbBeneficiaryCertificate.Checked)
{
reportBook.Reports.Add(new rptBeneficiarysCertificate());
(reportBook.Reports[countCon] as rptBeneficiarysCertificate).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
//continue;
//objList.Add("ckbBeneficiaryCertificate");
}
if (ckbBillOfExchange.Checked)
{
reportBook.Reports.Add(new rptBillOfExchange1());
(reportBook.Reports[countCon] as rptBillOfExchange1).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
//continue;
//objList.Add("ckbBillOfExchange");
}
if (ckbBillOfExchange.Checked)
{
reportBook.Reports.Add(new rptBillOfExchange2());
(reportBook.Reports[countCon] as rptBillOfExchange2).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
}
if (chkCertificateOfOrigin.Checked)
{
reportBook.Reports.Add(new rptCertificateOfOrigin());
(reportBook.Reports[countCon] as rptCertificateOfOrigin).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
//continue;
//objList.Add("chkCertificateOfOrigin");
}
if (ckbConcernCertificate.Checked)
{
reportBook.Reports.Add(new rptConcernCertificate());
(reportBook.Reports[countCon] as rptConcernCertificate).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
//continue;
//objList.Add("chkCertificateOfOrigin");
}
if (ckbBankForwarding.Checked)
{
reportBook.Reports.Add(new rptBankForwarding());
(reportBook.Reports[countCon] as rptBankForwarding).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
//continue;
//objList.Add("chkCertificateOfOrigin");
}
if (ckbPakingList.Checked)
{
reportBook.Reports.Add(new rptPackingList());
(reportBook.Reports[countCon] as rptPackingList).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
// continue;
// objList.Add("ckbPakingList");
}
if (ckbPakingListGWNW.Checked)
{
reportBook.Reports.Add(new rptPackingListGWNW());
(reportBook.Reports[countCon] as rptPackingListGWNW).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
// continue;
// objList.Add("ckbPakingList");
}
if (ckbForwardingLetter.Checked)
{
reportBook.Reports.Add(new rptForwardingLetter());
(reportBook.Reports[countCon] as rptForwardingLetter).pramDCID = Convert.ToInt16(ddlDCNo.SelectedValue);
countCon++;
// continue;
// objList.Add("ckbPakingList");
}
}
var reportSource = new InstanceReportSource();
reportSource.ReportDocument = reportBook;
ReportViewer1.ReportSource = reportSource;
ReportViewer1.RefreshReport();
}
}
private void ImprimirXLS(ArrayList ALValorParametrosInternos, Type instance, ArrayList ALValorParametrosConsignacion, Type instance2)
{
try
{
//Reporte de Facturas vigentes
Telerik.Reporting.Report report1 = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
report1.ReportParameters[i].AllowNull = true;
report1.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
report1.ReportParameters[23].Value = 1;
report1.ReportParameters[16].Value = 63;
report1.ReportParameters[1].Value = "Pendiente por facturar";
//Reporte de Facturas vencidas
Telerik.Reporting.Report reportPXFVEN = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
if (i == 23)
{
reportPXFVEN.ReportParameters[i].AllowNull = true;
reportPXFVEN.ReportParameters[i].Value = 0;
}
else
{
reportPXFVEN.ReportParameters[i].AllowNull = true;
reportPXFVEN.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
}
reportPXFVEN.ReportParameters[23].Value = 0;
reportPXFVEN.ReportParameters[16].Value = 63;
reportPXFVEN.ReportParameters[1].Value = "Pendiente por facturar";
//Reporte de prueba Vigente
Telerik.Reporting.Report PruebaVIG = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
PruebaVIG.ReportParameters[i].AllowNull = true;
PruebaVIG.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
PruebaVIG.ReportParameters[16].Value = 64;
PruebaVIG.ReportParameters[1].Value = "Prueba";
PruebaVIG.ReportParameters[23].Value = 0; //vigente
//Reporte de prueba Vencidas
Telerik.Reporting.Report PruebaVEN = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
PruebaVEN.ReportParameters[i].AllowNull = true;
PruebaVEN.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
PruebaVEN.ReportParameters[16].Value = 64;
PruebaVEN.ReportParameters[1].Value = "Prueba";
PruebaVEN.ReportParameters[23].Value = 1; //Vencida
//Reporte de No conformes Vigente
Telerik.Reporting.Report NCVIG = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
NCVIG.ReportParameters[i].AllowNull = true;
NCVIG.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
NCVIG.ReportParameters[16].Value = 65;
NCVIG.ReportParameters[1].Value = "Producto no conforme";
NCVIG.ReportParameters[23].Value = 0; //vigente
//Reporte de No Conforme Vencidas
Telerik.Reporting.Report NCVEN = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
NCVEN.ReportParameters[i].AllowNull = true;
NCVEN.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
NCVEN.ReportParameters[16].Value = 65;
NCVEN.ReportParameters[1].Value = "Producto no conforme";
NCVEN.ReportParameters[23].Value = 1; //Vencida
//Reporte de prueba Vigente
Telerik.Reporting.Report RepConsignacion = (Telerik.Reporting.Report)Activator.CreateInstance(instance2);
for (int i = 0; i <= ALValorParametrosConsignacion.Count - 1; i++)
{
RepConsignacion.ReportParameters[i].AllowNull = true;
RepConsignacion.ReportParameters[i].Value = ALValorParametrosConsignacion[i];
}
var reportBook = new ReportBook();
reportBook.Reports.Add(report1);
reportBook.Reports.Add(reportPXFVEN);
reportBook.Reports.Add(PruebaVIG);
reportBook.Reports.Add(PruebaVEN);
reportBook.Reports.Add(NCVIG);
reportBook.Reports.Add(NCVEN);
reportBook.Reports.Add(RepConsignacion);
reportBook.Reports[0].DocumentName = "PXF_VENCIDA";
reportBook.Reports[1].DocumentName = "PXF_VIGENTE";
reportBook.Reports[3].DocumentName = "PRUEBA VENCIDA";
reportBook.Reports[2].DocumentName = "PRUEBA VIGENTE";
reportBook.Reports[5].DocumentName = "NC VENCIDA";
reportBook.Reports[4].DocumentName = "NC VIGENTE";
reportBook.Reports[6].DocumentName = "Consignacion";
ReportProcessor reportProcessor = new ReportProcessor();
RenderingResult result = reportProcessor.RenderReport("XLS", reportBook, null);
string ruta = Server.MapPath("Reportes") + "\\" + ALValorParametrosConsignacion[2] + instance.Name + ".xls";
if (File.Exists(ruta))
{
File.Delete(ruta);
}
FileStream fs = new FileStream(ruta, FileMode.Create);
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
fs.Flush();
fs.Close();
// RAM1.ResponseScripts.Add("startDownload('" + instance.Name + ".xls');");
RadAjaxManager1.ResponseScripts.Add("startDownload('" + ALValorParametrosConsignacion[2] + instance.Name + ".xls');");
//Telerik.Reporting.Report report1 = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
//for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
//{
// report1.ReportParameters[i].AllowNull = true;
// report1.ReportParameters[i].Value = ALValorParametrosInternos[i];
//}
//ReportProcessor reportProcessor = new ReportProcessor();
//RenderingResult result = reportProcessor.RenderReport("XLS", report1, null);
//string ruta = Server.MapPath("Reportes") + "\\" + instance.Name + ".xls";
//if (File.Exists(ruta))
// File.Delete(ruta);
//FileStream fs = new FileStream(ruta, FileMode.Create);
//fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
//fs.Flush();
//fs.Close();
//RadAjaxManager1.ResponseScripts.Add("startDownload('" + instance.Name + ".xls');");
}
catch (Exception ex)
{
throw ex;
}
}
