コード例 #1
0
        /// <summary>
        /// 列印報表
        /// </summary>
        /// <returns></returns>
        public IActionResult Print()
        {
            var dt = new DataTable();

            string mintype   = "10";
            int    extension = 0;

            //報表模板位置 NetCoreMVCERP\wwwroot\Reports\Report1.rdlc
            var path = $"{_webHostEnvironment.WebRootPath}\\reports\\Report11.rdlc";

            //匯入變數資料
            Dictionary <string, string> parameters = new Dictionary <string, string>();

            parameters.Add("rp1", "公司");
            parameters.Add("rp2", "員工資料");
            parameters.Add("t1", "編號");
            parameters.Add("t2", "名稱");
            parameters.Add("t3", "年資");
            parameters.Add("t4", "薪水");
            AspNetCore.Reporting.LocalReport local = new AspNetCore.Reporting.LocalReport(path);

            local.AddDataSource("DataSet1", employees);


            System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
            var result = local.Execute(RenderType.Pdf, extension, parameters, mintype);

            //return result;
            return(File(result.MainStream, "application/pdf"));
        }
コード例 #2
0
ファイル: ReportService.cs プロジェクト: jorge2606/VRBack
        public ServiceResult <byte[]> ReportPrintAsync(Guid solicitationId)
        {
            var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "VR_REPORT.rdl");
            var files        = new FileInfo(newDirectory);

            var notif = new ServiceResult <byte[]>();

            if (!files.Exists)
            {
                notif.AddError("Error", "El Reporte no fue encontrado.");
                return(notif);
            }
            var rv    = new reportingNameSpace.LocalReport(newDirectory);
            var solic = _solicitationSubsidyService.GetByIdSubsidy(solicitationId).Response;

            if (solic == null)
            {
                notif.AddError("Error", "La solicitud no existe");
                return(notif);
            }
            var destiny     = _destinyService.Get_DestiniesProcedure(solicitationId).Response;
            var images      = _solicitationSubsidyService.SolicitationApprovedBySupervisorId(solicitationId, solic.UserId).Response;
            var totalLetter = _context.GetLetterNumberTotalSolicitationAsync(destiny.Sum(x => x.Amount).ToString("F").Replace(",", "."), ".");

            rv.AddDataSource("SolicitationDTODataSet", new List <FindByIdSolicitationSubsidyDto>()
            {
                solic
            });
            rv.AddDataSource("UserDataSet", new List <UserDto>()
            {
                solic.User
            });
            rv.AddDataSource("Destination", destiny);
            rv.AddDataSource("SignSupervisorImage", new List <UrlSignHolograph>()
            {
                images
            });
            rv.AddDataSource("DestinationDataSet", solic.Destinies);
            rv.AddDataSource("ExpenditureDataSet", solic.Expenditures);
            rv.AddDataSource("Common", new List <ReportDto>()
            {
                new ReportDto()
                {
                    TodayDate   = DateTime.Today.ToString("d"),
                    TotalLetter = totalLetter.FirstOrDefault() == null ? "" : totalLetter.FirstOrDefault().LetterNumber
                }
            });
            System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);

            var result = rv.Execute(reportingNameSpace.RenderType.Pdf);

            return(new ServiceResult <byte[]>(result.MainStream));
        }
コード例 #3
0
ファイル: ReportService.cs プロジェクト: jorge2606/VRBack
        public ServiceResult <byte[]> PrintReportCommission(Guid solicitationId)
        {
            var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "Informe_de_comision_de_servicio.rdl");
            var files        = new FileInfo(newDirectory);

            var notif = new ServiceResult <byte[]>();

            if (!files.Exists)
            {
                notif.AddError("Error", "El Reporte no fue encontrado.");
                return(notif);
            }

            var solic = _solicitationSubsidyService.GetByIdSubsidy(solicitationId).Response;

            if (solic == null)
            {
                notif.AddError("Error", "La solicitud no existe.");
                return(notif);
            }

            var rv           = new reportingNameSpace.LocalReport(newDirectory);
            var iscommission = solic.IsCommission == null ? true : false;

            if (!iscommission)
            {
                rv.AddDataSource("solicitationDataSet", new List <FindByIdSolicitationSubsidyDto>()
                {
                    solic
                });
            }
            else
            {
                var commisionList = _context.SolicitationSubsidies.Where(v => v.RandomKey == solic.RandomKey)
                                    .ToList();
                rv.AddDataSource("solicitationDataSet", commisionList);
            }

            rv.AddDataSource("DestinationDataSet", new List <DestinyFromSolicitationSubsidyFindByIdDto>(solic.Destinies));
            rv.AddDataSource("UsersDataSet", new List <UserDto>()
            {
                solic.User
            });
            rv.AddDataSource("ObservationList", new List <ObservationDto>(solic.Observations));

            System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
            var result = rv.Execute(reportingNameSpace.RenderType.Pdf);

            return(new ServiceResult <byte[]>(result.MainStream));
        }
コード例 #4
0
ファイル: ReportService.cs プロジェクト: jorge2606/VRBack
        public ServiceResult <byte[]> PrintReportSolicitationSubsidyByOrganism(Guid organismId)
        {
            var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "SolicitationSubsidyByOrganism.rdl");
            var files        = new FileInfo(newDirectory);

            var notif = new ServiceResult <byte[]>();

            if (!files.Exists)
            {
                notif.AddError("Error", "El Reporte no fue encontrado.");
                return(notif);
            }
            var rv             = new reportingNameSpace.LocalReport(newDirectory);
            var organismResult = _context.Organisms.FirstOrDefault(x => x.Id == organismId);

            var solicitation = _context.Report_SolicitationByOrganism(organismId);


            if (solicitation.Count() > 0)
            {
                rv.AddDataSource("ReportSolicitationByUser", new List <SolicitationSubsidyByOrganism>(solicitation));
            }
            else
            {
                rv.AddDataSource("ReportSolicitationByUser", new List <SolicitationSubsidyByOrganism>());
            }
            rv.AddDataSource("OrganismDataSet", new List <Organism>()
            {
                organismResult
            });
            rv.AddDataSource("CommonDataSet", new List <ReportDto>()
            {
                new ReportDto()
                {
                    TodayDate = DateTime.Today.ToShortDateString()
                }
            });
            System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
            var result = rv.Execute(reportingNameSpace.RenderType.Pdf);

            return(new ServiceResult <byte[]>(result.MainStream));
        }
コード例 #5
0
ファイル: ReportService.cs プロジェクト: jorge2606/VRBack
        public ServiceResult <byte[]> ExpenditureProcedure()
        {
            var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "Expenditures.rdl");
            var files        = new FileInfo(newDirectory);

            var notif = new ServiceResult <byte[]>();

            if (!files.Exists)
            {
                notif.AddError("Error", "El Reporte no fue encontrado.");
                return(notif);
            }
            var rv = new reportingNameSpace.LocalReport(newDirectory);

            var solicitation = _context.ExpenditureProcedure();

            if (solicitation.Count() > 0)
            {
                rv.AddDataSource("ExpenditureDataSet", new List <ExpenditureProcedureDto>(solicitation));
            }
            else
            {
                rv.AddDataSource("ExpenditureDataSet", new List <ExpenditureProcedureDto>());
            }
            rv.AddDataSource("CommonDataSet", new List <ReportDto>()
            {
                new ReportDto()
                {
                    TodayDate = DateTime.Today.ToShortDateString()
                }
            });
            System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
            var result = rv.Execute(reportingNameSpace.RenderType.Pdf);

            return(new ServiceResult <byte[]>(result.MainStream));
        }
コード例 #6
0
ファイル: ReportService.cs プロジェクト: jorge2606/VRBack
        public ServiceResult <byte[]> PrintReport_SolicitationByDestiniesAndDates(ReportByDestiniesAndDatesDto reportByDestiniesAndDates)
        {
            var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "SolicitationSubsidyByDestinationAndDate.rdl");
            var files        = new FileInfo(newDirectory);

            var notif = new ServiceResult <byte[]>();

            if (!files.Exists)
            {
                notif.AddError("Error", "El Reporte no fue encontrado.");
                return(notif);
            }

            reportByDestiniesAndDates.CityId     = reportByDestiniesAndDates.CityId.Equals(Guid.Empty) ? null : reportByDestiniesAndDates.CityId;
            reportByDestiniesAndDates.CountryId  = reportByDestiniesAndDates.CountryId.Equals(Guid.Empty) ? null : reportByDestiniesAndDates.CountryId;
            reportByDestiniesAndDates.ProvinceId = reportByDestiniesAndDates.ProvinceId.Equals(Guid.Empty) ? null : reportByDestiniesAndDates.ProvinceId;
            reportByDestiniesAndDates.StartDate  = new DateDto()
            {
                Day   = reportByDestiniesAndDates.StartDateDay,
                Month = reportByDestiniesAndDates.StartDateMonth,
                Year  = reportByDestiniesAndDates.StartDateYear
            };
            reportByDestiniesAndDates.EndDate = new DateDto()
            {
                Day   = reportByDestiniesAndDates.EndDay,
                Month = reportByDestiniesAndDates.EndMonth,
                Year  = reportByDestiniesAndDates.EndYear
            };

            var      rv        = new reportingNameSpace.LocalReport(newDirectory);
            DateTime?startDate = null;
            DateTime?endDate   = null;

            if (reportByDestiniesAndDates.StartDate != null &&
                !reportByDestiniesAndDates.StartDate.Day.Equals(0) &&
                !reportByDestiniesAndDates.StartDate.Month.Equals(0) &&
                !reportByDestiniesAndDates.StartDate.Year.Equals(0))
            {
                startDate = reportByDestiniesAndDates.StartDate.ToDateTime();
            }

            if (reportByDestiniesAndDates.EndDate != null &&
                !reportByDestiniesAndDates.EndDate.Day.Equals(0) &&
                !reportByDestiniesAndDates.EndDate.Month.Equals(0) &&
                !reportByDestiniesAndDates.EndDate.Year.Equals(0))
            {
                endDate = reportByDestiniesAndDates.EndDate.ToDateTime();
            }
            var solicitation = _context.Report_SolicitationByDestiniesAndDates(
                startDate,
                endDate,
                reportByDestiniesAndDates.CountryId,
                reportByDestiniesAndDates.CityId,
                reportByDestiniesAndDates.ProvinceId
                );


            if (solicitation.Count() > 0)
            {
                rv.AddDataSource("ReportSolicitationByUser", new List <SolicitationSubsidyByOrganism>(solicitation));
            }
            else
            {
                rv.AddDataSource("ReportSolicitationByUser", new List <SolicitationSubsidyByOrganism>());
            }
            rv.AddDataSource("CommonDataSet", new List <ReportDto>()
            {
                new ReportDto()
                {
                    TodayDate = DateTime.Today.ToShortDateString()
                }
            });
            System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
            var result = rv.Execute(reportingNameSpace.RenderType.Pdf);

            return(new ServiceResult <byte[]>(result.MainStream));
        }
コード例 #7
0
ファイル: ReportService.cs プロジェクト: jorge2606/VRBack
        public ServiceResult <byte[]> PrintAccountFor(Guid solicitationId)
        {
            var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "Rendición.rdl");
            var files        = new FileInfo(newDirectory);

            var notif = new ServiceResult <byte[]>();

            if (!files.Exists)
            {
                notif.AddError("Error", "El Reporte no fue encontrado.");
                return(notif);
            }
            var solic = _solicitationSubsidyService.GetByIdSubsidy(solicitationId).Response;

            if (solic == null)
            {
                notif.AddError("Error", "La solicitud no existe.");
                return(notif);
            }
            var rv = new reportingNameSpace.LocalReport(newDirectory);

            rv.AddDataSource("SolicitationDataset", new List <FindByIdSolicitationSubsidyDto>()
            {
                solic
            });
            rv.AddDataSource("UserDataSet", new List <UserDto>()
            {
                solic.User
            });
            rv.AddDataSource("SolicitationStateDataSet", new List <SolicitationStateDto>()
            {
                solic.SolicitationStates.FirstOrDefault(x => x.FileNumber != null)
            });
            rv.AddDataSource("OrganismDataSet", new List <OrganismBaseDto>()
            {
                new OrganismBaseDto()
                {
                    Name = _context.Distributions.FirstOrDefault(x => x.Id == solic.User.DistributionId).Name
                }
            });
            rv.AddDataSource("DestinationDataSet", solic.Destinies);
            solic.Expenditures.Add(new ExpenditureFromSolicitationSubsidyByIdDto()
            {
                SupportingDateTime  = new Nullable <DateTime>(),
                OrderNumber         = new Nullable <int>(),
                Description         = solic.Motive,
                AccountedForAmount  = new Nullable <decimal>(),
                ExpenditureTypeName = ""
            });
            rv.AddDataSource("ExpenditureDataSet", solic.Expenditures);
            var adv = solic.Destinies.Sum(x => x.Days * x.PercentageCodeLiquidation * x.AdvanceCategory) +
                      solic.Expenditures.Where(x => x.IsRequested).Sum(j => j.Amount);
            var supp = solic.Destinies.Sum(x => x.DaysPay * x.PercentageCodeLiquidation * x.AdvanceCategory) +
                       solic.Expenditures.Sum(j => j.AccountedForAmount ?? 0);

            var newCommon = new ReportDto()
            {
                Advance                = adv,
                SupportingPresent      = supp,
                Total                  = adv - supp,
                LegalRulingDescription = solic.LegalRulingDescription == null ? "" : solic.LegalRulingDescription
            };

            newCommon.TotalBool();
            var secondCommon = new ReportDto()
            {
                Advance           = adv,
                SupportingPresent = supp,
                Total             = adv - supp
            };

            rv.AddDataSource("CommonDataSet", new List <ReportDto>()
            {
                newCommon,
                secondCommon
            });

            var result1     = _iApproveOfAuthorityThatOrderCommissionsService.GetApproved(solic.Id);
            var listApprove = new VerificationCommissionDto();

            listApprove.SetValues(result1.Response);
            rv.AddDataSource("VerificationCommissionDataSet", new List <VerificationCommissionDto>()
            {
                listApprove
            });

            rv.AddDataSource("ObservationList", new List <ObservationDto>(solic.Observations));
            System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);

            var result = rv.Execute(reportingNameSpace.RenderType.Pdf);

            return(new ServiceResult <byte[]>(result.MainStream));
        }