Esempio n. 1
0
        public ReportViewer(InstanceReportSource instanceReportSource)
        {
            InitializeComponent();

            // Insert code required on object creation below this point.
            ReportHost.ReportSource = instanceReportSource;
        }
Esempio n. 2
0
 public void LoadReport(Report report)
 {
     var mainReport = new MainReport
                          {
                              CompanyInformationDS = {DataSource = new MiraculousMethods().GetCompanyInformation()},
                              ReportHoster = {ReportSource = report}
                          };
     var instanceReportSource = new InstanceReportSource {ReportDocument = mainReport};
     var reportViewer = new ReportViewer { ReportHost = { ReportSource = instanceReportSource } };
     reportViewer.ShowDialog();
 }
Esempio n. 3
0
        private byte[] GenerateReportByteArray(FaxGenerator.Report1 report)
        {
            InstanceReportSource instanceReportSource = new InstanceReportSource();

            instanceReportSource.ReportDocument = report;

            ReportProcessor reportProcessor = new ReportProcessor();
            RenderingResult result          = reportProcessor.RenderReport("PDF", instanceReportSource, null);

            //reportToExport.Dispose();

            return(result.DocumentBytes);
        }
Esempio n. 4
0
        private void btnPrint_Click(object sender, EventArgs e)
        {
            //Check if there is at least one rincian

            //Check nota sequence

            //Check nilai surat jalan vs nilai uang setoran

            //Others info connected to this transaction
            //Print Selected Transaction
            //Print
            DialogResult res = MessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
                                               , MessageBoxButtons.OKCancel
                                               , MessageBoxIcon.Question);

            if (res == System.Windows.Forms.DialogResult.OK)
            {
                PrinterSettings printerSettings;
                ReportProcessor reportProcessor;

                rptLaporanPenj rpt = new rptLaporanPenj();
                rpt.ReportParameters["user"].Value     = NBConfig.ValidUserName;
                rpt.ReportParameters["lappenid"].Value = lappenid_;
                //rpt.ReportParameters["custtypetoid"].Value = custtypetoid;

                IReportDocument iRpt = (IReportDocument)rpt;
                //// PrinterSettings
                printerSettings = new PrinterSettings();
                try
                {
                    InstanceReportSource reportSource = new InstanceReportSource();
                    reportSource.ReportDocument = iRpt;

                    reportProcessor = new ReportProcessor();
                    reportProcessor.PrintReport(reportSource, printerSettings);
                    using (sinarekDataSetTableAdapters.lappenTableAdapter tbl = new sinarekDataSetTableAdapters.lappenTableAdapter())
                    {
                        tbl.UpdateLapPenj(NBConfig.ValidUserName
                                          , 1
                                          , 1
                                          , int.Parse(lappenid_));
                    }
                    SetFormPrinted();
                }
                catch (Exception ex)
                {
                    helper.ErrorMessage(ex.Message);
                }
            }
        }
        public static InstanceReportSource GetPeakUsage()
        {
            //Query Database
            ProcessedPeaksList searchResults   = new ProcessedPeaksList();
            PeakUsageReport    peakUsageReport = new PeakUsageReport();

            peakUsageReport.DataSource = searchResults.processedPeaks;

            InstanceReportSource IRS = new InstanceReportSource();

            IRS.ReportDocument = peakUsageReport;

            return(IRS);
        }
        public DeliveryReportBook()
        {
            var deliverySlipReportSource = new InstanceReportSource {
                ReportDocument = new DeliverySlip()
            };

            this.ReportSources.Add(deliverySlipReportSource);

            var deliveryListReportSource = new InstanceReportSource {
                ReportDocument = new DeliveryList()
            };

            this.ReportSources.Add(deliveryListReportSource);
        }
Esempio n. 7
0
        private void btnPrint_Click(object sender, EventArgs e)
        {
            string iLappenID = radGridView3.SelectedRows[0].Cells["lappenID"].Value.ToString();
            //Print
            DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
                                                  , MessageBoxButtons.OKCancel
                                                  , RadMessageIcon.Question
                                                  , MessageBoxDefaultButton.Button2);

            if (res == System.Windows.Forms.DialogResult.OK)
            {
                PrinterSettings printerSettings;
                ReportProcessor reportProcessor;

                rptLaporanUJ rpt = new rptLaporanUJ();
                rpt.ReportParameters["user"].Value     = NBConfig.ValidUserName;
                rpt.ReportParameters["lappenid"].Value = iLappenID;
                rpt.ReportParameters["logid"].Value    = radGridView3.SelectedRows[0].Cells["logID"].Value.ToString();

                IReportDocument iRpt = (IReportDocument)rpt;

                iRpt.DocumentName = radGridView3.SelectedRows[0].Cells["NOSJ"].Value.ToString() + " "
                                    + radGridView3.SelectedRows[0].Cells["SalesName"].Value.ToString();
                //// PrinterSettings
                printerSettings = new PrinterSettings();
                try
                {
                    InstanceReportSource reportSource = new InstanceReportSource();
                    reportSource.ReportDocument = iRpt;

                    reportProcessor = new ReportProcessor();

                    reportProcessor.PrintReport(reportSource, printerSettings);
                    using (sinarekDataSetTableAdapters.lappenTableAdapter tbl = new sinarekDataSetTableAdapters.lappenTableAdapter())
                    {
                        tbl.UpdateLapPenj(NBConfig.ValidUserName
                                          , 1
                                          , 1, int.Parse(iLappenID));
                    }
                    helper.PrintLog(this.GetType().Name, rpt.Name, "Print:" + iLappenID);
                    this.vlappenTableAdapter.FillByTanggal(this.sinarekDataSet.vlappen, dtpTanggalLaporan.Value, "UJ");
                }
                catch (Exception ex)
                {
                    helper.SysLog(this.GetType().Name, this.Text, ex.Message);
                    //helper.ErrorMessage(ex.Message);
                }
            }
        }
Esempio n. 8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        InstanceReportSource RS = new InstanceReportSource();
        var Disbursement        = new RDisbursement();

        //  payout.ReportParameters.Add("CreditMemoType", ReportParameterType.String, "CP");

        Disbursement.ReportParameters.Add("AgingStart", ReportParameterType.Integer, 1);

        //payout.ReportParameters.Add("AgingEnd", ReportParameterType.Integer, 30);

        RS.ReportDocument = Disbursement;

        RV_Disbursement.ReportSource = RS;
    }
Esempio n. 9
0
        public ReportSource Resolve(string reportName)
        {
            var objectDataSource = new ObjectDataSource();

            objectDataSource.DataSource = GetData();

            var report = new Report1();

            report.DataSource = objectDataSource;// you can use also GetData() directly since it is a List

            var reportSource = new InstanceReportSource();

            reportSource.ReportDocument = report;

            return(reportSource);
        }
Esempio n. 10
0
        private void btnPrintSales_Click(object sender, EventArgs e)
        {
            //Print
            DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
                                                  , MessageBoxButtons.OKCancel
                                                  , RadMessageIcon.Question
                                                  , MessageBoxDefaultButton.Button2);

            if (res == System.Windows.Forms.DialogResult.OK)
            {
                PrinterSettings printerSettings;
                ReportProcessor reportProcessor;

                rptLaporanPenjSales rpt = new rptLaporanPenjSales();
                rpt.ReportParameters["user"].Value      = NBConfig.ValidUserName;
                rpt.ReportParameters["salesname"].Value = lblSales.Text;
                rpt.ReportParameters["tanggal"].Value   = dtpTanggal.Value;

                IReportDocument iRpt = (IReportDocument)rpt;

                //iRpt.DocumentName = radGridView1.SelectedRows[0].Cells["NOSJ"].Value.ToString() + " "
                //                    + radGridView1.SelectedRows[0].Cells["SalesName"].Value.ToString();
                //// PrinterSettings
                printerSettings = new PrinterSettings();
                try
                {
                    InstanceReportSource reportSource = new InstanceReportSource();
                    reportSource.ReportDocument = iRpt;
                    reportProcessor             = new ReportProcessor();
                    reportProcessor.PrintReport(reportSource, printerSettings);
                    //SavedToPDF(iRpt, @"C:\Users\VINA\Documents\Laporan Penjualan");
                    using (sinarekDataSetTableAdapters.lappenTableAdapter tbl = new sinarekDataSetTableAdapters.lappenTableAdapter())
                    {
                        tbl.UpdatePrintedSales(NBConfig.ValidUserName
                                               , 1
                                               , dtpTanggal.Value
                                               , lblSales.Text);
                    }
                    helper.PrintLog(this.GetType().Name, rpt.Name, "PrintSales:" + lblSales.Text + "," + dtpTanggal.Value.ToString("dd MMM yy"));
                    this.vlappenTableAdapter.FillByTanggal(this.sinarekDataSet.vlappen, dtpTanggal.Value, "Penjualan");
                }
                catch (Exception ex)
                {
                    helper.ErrorMessage(ex.Message);
                }
            }
        }
Esempio n. 11
0
        public async Task <string> CreateToxicologyAccessionReport(ReportCaseData dataSource, string templateName)
        {
            int seriesCount    = dataSource.PreviousHistoryChartData.Select(x => x.Name).Distinct().Count();
            int xAxisDataCount = dataSource.PreviousHistoryChartData.Select(x => x.DateCollected).Distinct().Count();

            //dataSource.ChartData = await this.GenerateChartImageFromXlsxFile("", "", dataSource.PreviousHistoryExcelChartData, seriesCount, xAxisDataCount);
            Console.Write(dataSource.ToString());
            Console.WriteLine(templateName);
            //string templateName = "ToxicologyAccessionCaseReport";
            string filePath = System.Configuration.ConfigurationManager.AppSettings["ReportTemplateLocation"].ToString() + "\\" + templateName + ".trdx";

            XmlReaderSettings settings = new XmlReaderSettings();

            settings.IgnoreWhitespace = true;

            Telerik.Reporting.Report report = null;

            using (XmlReader xmlReader = XmlReader.Create(filePath, settings))
            {
                ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
                report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
            }

            report.DataSource = dataSource;


            ReportProcessor      reportProcessor      = new ReportProcessor();
            InstanceReportSource instanceReportSource = new InstanceReportSource();

            instanceReportSource.ReportDocument = report;
            RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);

            //var reportLocation = ConfigurationManager.AppSettings["ReportTempLocation"];
            //string reportName = templateName+"_" + Guid.NewGuid().ToString() + "_" + DateTime.Now.ToString("yyyyMMdd_HH_mm_ss") + ".pdf";
            //string reportDestination = Path.Combine(reportLocation, reportName);

            //using (FileStream fs = new FileStream(reportDestination, FileMode.Create))
            //{
            //    fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
            //}
            //string reportUrl = dataSource.ServerUrl + "/" + reportName;
            ////byte[] bytes = result.DocumentBytes;
            //string response = Convert.ToBase64String(bytes);

            return(Convert.ToBase64String(result.DocumentBytes));
        }
Esempio n. 12
0
        private void btnPrint_Click(object sender, EventArgs e)
        {
            DialogResult res = MessageBox.Show("Print Laporan Perhitungan Stock. Siap kan kertas di printer."
                                               , "Print Laporan Perhitungan Stock"
                                               , MessageBoxButtons.OKCancel
                                               , MessageBoxIcon.Question
                                               , MessageBoxDefaultButton.Button2
                                               , MessageBoxOptions.DefaultDesktopOnly);

            if (res == System.Windows.Forms.DialogResult.OK)
            {
                rptSisaBarang gj = new rptSisaBarang();
                gj.ReportParameters["tanggal"].Value = dtpTanggal.Value;
                gj.ReportParameters["tipeid"].Value  = rddTipe.SelectedValue;
                gj.ReportParameters["User"].Value    = NBConfig.ValidUserName;
                IReportDocument report1 = (IReportDocument)gj;
                ////set parameters when necessary

                //// PrinterSettings
                PrinterSettings printerSettings = new PrinterSettings();
                //// Adjust the printer settings if necessary...
                try
                {
                    InstanceReportSource reportSource = new InstanceReportSource();
                    reportSource.ReportDocument = report1;

                    // Print the report using the printer settings.
                    ReportProcessor reportProcessor = new ReportProcessor();
                    reportProcessor.PrintReport(reportSource, printerSettings);

                    //print log
                    helper.PrintLog(this.Text, gj.Name, "tanggal:" + dtpTanggal.Value.ToString() +
                                    ",tipeid:" + rddTipe.SelectedValue.ToString());

                    //Process Stock Data Akhir
                    //TODO: For Tipe 1 keep data for BSJ & BJ
                    //TODO: For the rest only keep record with stock with parentid = -1
                }
                catch (Exception ex)
                {
                    helper.ErrorMessage("Ada masalah untuk print laporan stock. Segera hubungi administrator");
                    helper.SysLog(this.GetType().Name, this.Text, "ERROR : " + ex.Message + " : " + ex.StackTrace);
                }
            }
        }
        protected void DesplegarReporte(DateTime fecha1, DateTime fecha2)
        {
            ReporteExameneFechas reporte = new ReporteExameneFechas();

            Telerik.Reporting.ObjectDataSource ds = new Telerik.Reporting.ObjectDataSource();

            MuestraLaboratorioBll muestras = new MuestraLaboratorioBll();

            ds.DataSource = muestras.GetReportMonth(fecha1, fecha2);

            reporte.DataSource = ds;

            InstanceReportSource fuente = new InstanceReportSource();

            fuente.ReportDocument = reporte;

            examenesXFechas.ReportSource = fuente;
        }
Esempio n. 14
0
        /// <summary>
        /// uses telerik reporting tool and writes data to either pdf or excel file according to selected report format from UI
        /// </summary>
        /// <param name="reportToExport">object of the class which prepares report</param>
        /// <param name="reportFormat">either pdf or excel format</param>
        /// <param name="varianceReportPath">html to excel template file path</param>
        /// <param name="baseFileName"></param>
        /// <param name="currentDateTime"></param>
        /// <returns></returns>
        public static string CreateFileUsingTelerik(IReportDocument reportToExport, Enums.DownloadFileType reportFormat, string varianceReportPath, string baseFileName, string currentDateTime)
        {
            var instanceReportSource = new InstanceReportSource {
                ReportDocument = reportToExport
            };
            var result = new ReportProcessor().RenderReport(reportFormat.ToString(), instanceReportSource, null);


            string fileName = string.Format("{0}{1}.{2}", baseFileName, currentDateTime, result.Extension);

            string filePath = Path.Combine(varianceReportPath, fileName);

            using (var fs = new FileStream(filePath, FileMode.Create))
            {
                fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
            }
            return(fileName);
        }
Esempio n. 15
0
        private void GemMaterialsReport()
        {
            if (this.SelectedTemplate != null)
            {
                Report report = new MaterialsReport();
                var    source = new ObjectDataSource();
                source.DataSource = typeof(MainViewModel);
                source.DataMember = "GetDataSourceReport";
                report.DataSource = source;
                var reportSource = new InstanceReportSource()
                {
                    ReportDocument = report
                };

                var reportWindow = new I_ReportViewer(this.SelectedTemplate.Name + " Materials Report", reportSource, false, false, true);
                reportWindow.ShowDialog();
            }
        }
Esempio n. 16
0
        private void btnPrintNama_Click(object sender, EventArgs e)
        {
            if (rddMember.SelectedValue != null)
            {
                DialogResult res = MessageBox.Show("Print Slip Gaji Untuk " + rddMember.Text + ". Siap kan kertas di printer."
                                                   , "Print Slip Gaji Per Nama"
                                                   , MessageBoxButtons.OKCancel
                                                   , MessageBoxIcon.Question
                                                   , MessageBoxDefaultButton.Button2
                                                   , MessageBoxOptions.DefaultDesktopOnly);

                if (res == System.Windows.Forms.DialogResult.OK)
                {
                    //Print Slip Gaji
                    rptGajiMingguanNama gj = new rptGajiMingguanNama();
                    gj.ReportParameters["GMID"].Value     = rddGajiMingguan.SelectedValue;
                    gj.ReportParameters["User"].Value     = NBConfig.ValidUserName;
                    gj.ReportParameters["memberid"].Value = rddMember.SelectedValue;
                    IReportDocument report1 = (IReportDocument)gj;
                    ////set parameters when necessary

                    //// PrinterSettings
                    PrinterSettings printerSettings = new PrinterSettings();
                    //// Adjust the printer settings if necessary...
                    InstanceReportSource reportSource = new InstanceReportSource();
                    reportSource.ReportDocument = report1;
                    // Print the report using the printer settings.
                    ReportProcessor reportProcessor = new ReportProcessor();
                    reportProcessor.PrintReport(reportSource, printerSettings);

                    //process printed
                    if (!NBConfig.GetGBIDPrintedStaff())
                    {
                        using (sinarekDataSetTableAdapters.gajibulananTableAdapter gb = new sinarekDataSetTableAdapters.gajibulananTableAdapter())
                        {
                            gb.UpdatePrintedStaff(NBConfig.ValidUserName, NBConfig.IGBID);
                        }
                        SetPrintedForms();
                        helper.NotifMessage("Data Gaji telah terkunci dan tidak dapat di ubah lagi.");
                    }
                }
            }
        }
Esempio n. 17
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //try
            //{
            //    CheckShamsiDateFunctions();
            //}
            //catch (Exception ex)
            //{

            //}


            int id;

            id = Page.Request.QueryString[0].ToSafeInt();

            Report report = new ReportShareDiv();

            Telerik.Reporting.SqlDataSource sqlDataSource = new Telerik.Reporting.SqlDataSource();
            sqlDataSource.ConnectionString = "Tarin";
            sqlDataSource.SelectCommand    =
                " SELECT  Members.Name, Members.Code, Members.Type, Members.ShareAmount, Members.ShareCount, Members.HasPriority, ShareDivisionDetails.MemberId, ShareDivisionDetails.ShareAmount AS SharedAmount, "
                + " ShareDivisionDetails.ShareDivisionId, ShareDivisions.Type AS Expr2, ShareDivisions.Amount As TotalProfit, ShareDivisions.InsertDateTime,dbo.shamsidate(ShareDivisions.InsertDateTime) as [Date]"
                + " FROM            Members INNER JOIN"
                + " ShareDivisionDetails ON Members.Id = ShareDivisionDetails.MemberId INNER JOIN"
                + "  ShareDivisions ON ShareDivisionDetails.ShareDivisionId = ShareDivisions.Id"
                + $" where ShareDivisions.Id ={id} order by cast(Members.Code as bigint)";

            sqlDataSource.Parameters.Add("@id", System.Data.DbType.Int32, id);
            report.DataSource = sqlDataSource;

            InstanceReportSource reportSource = new InstanceReportSource();

            reportSource.ReportDocument = report;

            ReportViewer1.ReportSource = reportSource;

            var table1 = report.Items.Find("table1", true)[0];

            ((table1 as Telerik.Reporting.Table).DataSource as Telerik.Reporting.SqlDataSource).Parameters[0].Value = id;

            ReportViewer1.RefreshReport();
        }
Esempio n. 18
0
        private void btnPrint_Click(object sender, EventArgs e)
        {
            ////On Printing Surat Jalan Make sure after printing surat jalan has been updated too
            ////printed so the next time surat jalan is printing COPY is appended to the title.
            DialogResult res = MessageBox.Show("Print Laporan Stock. Siap kan kertas di printer."
                                               , "Print Laporan Stock"
                                               , MessageBoxButtons.OKCancel
                                               , MessageBoxIcon.Question
                                               , MessageBoxDefaultButton.Button2
                                               , MessageBoxOptions.DefaultDesktopOnly);

            if (res == System.Windows.Forms.DialogResult.OK)
            {
                rptSisaBarang gj = new rptSisaBarang();
                gj.ReportParameters["tanggal"].Value = dtpTanggal.Value;
                gj.ReportParameters["tipeid"].Value  = rddTipe.SelectedValue;
                gj.ReportParameters["User"].Value    = NBConfig.ValidUserName;
                IReportDocument report1 = (IReportDocument)gj;
                ////set parameters when necessary

                //// PrinterSettings
                PrinterSettings printerSettings = new PrinterSettings();
                //// Adjust the printer settings if necessary...
                try
                {
                    InstanceReportSource reportSource = new InstanceReportSource();
                    reportSource.ReportDocument = report1;

                    // Print the report using the printer settings.
                    ReportProcessor reportProcessor = new ReportProcessor();
                    reportProcessor.PrintReport(reportSource, printerSettings);

                    //print log
                    helper.PrintLog(this.Text, gj.Name, "tanggal:" + dtpTanggal.Value.ToString() +
                                    ",tipeid:" + rddTipe.SelectedValue.ToString());
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Ada masalah untuk print laporan stock. Segera hubungi administrator", "SMS - Error Notification");
                }
            }
        }
Esempio n. 19
0
        /// <summary>
        /// Save Report to a file to a specified location
        /// </summary>
        /// <param name="rptDoc"></param>
        /// <param name="Location"></param>
        internal static void SavedToEXCEL(IReportDocument rptDoc, string Location)
        {
            ReportProcessor      reportProcessor = new ReportProcessor();
            InstanceReportSource reportSource    = new InstanceReportSource();

            reportSource.ReportDocument = rptDoc;
            string    rptName = string.Empty;
            Hashtable htbl    = new Hashtable();

            //set any deviceInfo settings if necessary
            System.Collections.Hashtable deviceInfo             = new System.Collections.Hashtable();
            Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("XLS", reportSource, deviceInfo);
            string fileName = result.DocumentName + "." + result.Extension;
            string filePath = System.IO.Path.Combine(Location, fileName);

            using (System.IO.FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create))
            {
                fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
            }
        }
Esempio n. 20
0
        private void generateReport()
        {
            var trafficAreaIDs = string.Join(",", cblTrafficAreas.Items.Cast <ListItem>().Where(i => i.Selected).Select(i => i.Value));
            var jobStateIDs    = string.Join(",", cblJobStates.Items.Cast <ListItem>().Where(i => i.Selected).Select(i => i.Value));

            var typeName   = "Orchestrator.Reports.rptRunOverview, Orchestrator.Reports";
            var reportType = Type.GetType(typeName);
            var report     = (IReportDocument)Activator.CreateInstance(reportType);

            report.ReportParameters.ElementAt(0).Value = dteStartDate.SelectedDate.Value.Date;
            report.ReportParameters.ElementAt(1).Value = dteEndDate.SelectedDate.Value.Date.AddDays(1);
            report.ReportParameters.ElementAt(2).Value = trafficAreaIDs;
            report.ReportParameters.ElementAt(3).Value = jobStateIDs;

            var reportSource = new InstanceReportSource {
                ReportDocument = report
            };

            this.rptvRunOverview.ReportSource = reportSource;
        }
Esempio n. 21
0
        public static ReportSource RenderReportData(byte[] ReportBinaryData, Dictionary <string, object> Parameters)
        {
            ReportPackager pack = new ReportPackager();

            Telerik.Reporting.Report doc = pack.Unpackage(new MemoryStream(ReportBinaryData));

            InstanceReportSource instance = new InstanceReportSource();

            instance.ReportDocument = doc;

            if (Parameters != null)
            {
                foreach (KeyValuePair <string, object> kvp in Parameters)
                {
                    instance.Parameters.Add(new Telerik.Reporting.Parameter(kvp.Key, kvp.Value));
                }
            }

            return(instance);
        }
Esempio n. 22
0
        private void btnTotalRincian_Click(object sender, EventArgs e)
        {
            DialogResult res = MessageBox.Show("Print Laporan Rincian Total Gaji. Siap kan kertas di printer."
                                               , "Print Laporan Rincian Total Gaji"
                                               , MessageBoxButtons.OKCancel
                                               , MessageBoxIcon.Question
                                               , MessageBoxDefaultButton.Button2
                                               , MessageBoxOptions.DefaultDesktopOnly);

            if (res == System.Windows.Forms.DialogResult.OK)
            {
                //Print Rincian Summary Gaji
                rptGajiTotal gj = new rptGajiTotal();
                gj.ReportParameters[0].Value      = NBConfig.IGMID;
                gj.ReportParameters["user"].Value = NBConfig.ValidUserName;
                IReportDocument report1 = (IReportDocument)gj;
                ////set parameters when necessary

                //// PrinterSettings
                PrinterSettings printerSettings = new PrinterSettings();
                //// Adjust the printer settings if necessary...
                InstanceReportSource reportSource = new InstanceReportSource();
                reportSource.ReportDocument = report1;
                // Print the report using the printer settings.
                ReportProcessor reportProcessor = new ReportProcessor();
                reportProcessor.PrintReport(reportSource, printerSettings);

                //process printed
                if (!NBConfig.GetGMIDPrinted())
                {
                    using (sinarekDataSetTableAdapters.gajimingguanTableAdapter gm = new sinarekDataSetTableAdapters.gajimingguanTableAdapter())
                    {
                        gm.UpdatePrinted(NBConfig.ValidUserName, NBConfig.IGMID);
                    }
                    SetPrintedForms();
                    MessageBox.Show("Data Gaji telah terkunci dan tidak dapat di ubah lagi.");
                }
            }
        }
Esempio n. 23
0
        public async Task <string> CreateToxLabOrderRequisitionReport(ToxLabOrderReportData dataSource, string templateName = "ToxLabOrderRequisitionReport.trdx")
        {
            string filePath = System.Configuration.ConfigurationManager.AppSettings["ReportTemplateLocation"].ToString() + "\\" + templateName;

            XmlReaderSettings settings = new XmlReaderSettings();

            settings.IgnoreWhitespace = true;

            Telerik.Reporting.Report report = null;

            using (XmlReader xmlReader = XmlReader.Create(filePath, settings))
            {
                ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
                report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
            }

            report.DataSource = dataSource;


            ReportProcessor      reportProcessor      = new ReportProcessor();
            InstanceReportSource instanceReportSource = new InstanceReportSource();

            instanceReportSource.ReportDocument = report;
            RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);

            //var reportLocation = ConfigurationManager.AppSettings["ReportTempLocation"];
            //string reportName = dataSource.Id + "_ToxLabOrderRequisition_" + Guid.NewGuid().ToString() + "_" + DateTime.Now.ToString("yyyyMMdd_HH_mm_ss") + ".pdf";
            //string reportDestination = Path.Combine(dataSource.FolderPath, reportName);

            //using (FileStream fs = new FileStream(reportDestination, FileMode.Create))
            //{
            //    fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
            //}
            //string reportUrl = dataSource.ServerUrl + "/" + reportName;
            //byte[] bytes = result.DocumentBytes;
            //string response = Convert.ToBase64String(bytes);

            return(Convert.ToBase64String(result.DocumentBytes));
        }
Esempio n. 24
0
        public async Task <string> GenerateExtractionReport(string template, ExtractionData dataSource)
        {
            //Reference:http://www.telerik.com/forums/programmatically-use-of-trdp-report
            //sample reports:C:\Program Files (x86)\Telerik\Reporting R1 2017\Report Designer\Examples


            string filePath = System.Configuration.ConfigurationManager.AppSettings["ReportTempLocation"].ToString() + "\\" + Guid.NewGuid().ToString() + "_" + DateTime.Now.ToString("yyyyMMdd_HH_mm_ss") + ".trdx";

            XmlReaderSettings settings = new XmlReaderSettings();

            settings.IgnoreWhitespace = true;

            Telerik.Reporting.Report report = null;

            byte[] templateBytes = Convert.FromBase64String(template);
            File.WriteAllBytes(filePath, templateBytes);

            using (XmlReader xmlReader = XmlReader.Create(filePath, settings))
            {
                ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
                report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
            }
            //ReportPackager reportPackager = new ReportPackager();
            //using (var sourceStream = System.IO.File.OpenRead(@"C:\Users\Razz\Documents\Visual Studio 2015\Projects\SampleReports\src\SampleReports\Templates\Report1.trdp"))
            //{
            //    report = (Telerik.Reporting.Report)reportPackager.UnpackageDocument(sourceStream);
            //}

            report.DataSource = dataSource;


            ReportProcessor      reportProcessor      = new ReportProcessor();
            InstanceReportSource instanceReportSource = new InstanceReportSource();

            instanceReportSource.ReportDocument = report;
            RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);

            return(Convert.ToBase64String(result.DocumentBytes));
        }
Esempio n. 25
0
        public PrintView(List <Test> lstT)
        {
            if (lstT.Count > 0)
            {
                InitializeComponent();
                this.rpvNav.CommandBarElement.Rows[0].Strips[0].ItemsLayout.Children[0].Visibility = Telerik.WinControls.ElementVisibility.Collapsed;
                CommandBarButton btn = new CommandBarButton();
                btn.Click      += new EventHandler(btn_Click);
                btn.DrawText    = false;
                btn.Image       = (System.Drawing.Image)Properties.Resources.save;
                btn.ToolTipText = "Save PDF to a specified location";
                this.rpvNav.CommandBarElement.Rows[0].Strips[0].Items.Insert(0, btn);

                BatchReport          report      = new BatchReport();
                InstanceReportSource rptInstance = new InstanceReportSource();
                rptInstance.ReportDocument = report;

                Test t = new Test();
                t.PrepRun = lstT[0].PrepRun;
                t.DueDate = lstT.Where(te => te.DueDate != null).Select(te => te.DueDate).Min();

                report.DataSource      = t;
                report.DocumentMapText = "Prep Benchsheet";


                Telerik.Reporting.Table tableItem = report.Items.Find("table1", true)[0] as Telerik.Reporting.Table;
                tableItem.DataSource = lstT;

                //Render pdf
                Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
                System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();
                deviceInfo["FontEmbedding"] = "None";
                result = reportProcessor.RenderReport("PDF", rptInstance, deviceInfo);
                MemoryStream msPDF = new MemoryStream(result.DocumentBytes);
                rpvMain.ViewerMode = FixedDocumentViewerMode.TextSelection;
                rpvMain.LoadDocument(msPDF);
                //msPDF.Dispose();
            }
        }
        public static Stream GetReportStream(IReportDocument report, string filename, out Exception exception, string format)
        {
            try
            {
                ReportProcessor      reportProcessor      = new ReportProcessor();
                InstanceReportSource instanceReportSource = new InstanceReportSource();

                instanceReportSource.ReportDocument = report;

                RenderingResult renderingResult = reportProcessor.RenderReport(format.ToUpper(), instanceReportSource, null);


                MemoryStream stream = new MemoryStream(renderingResult.DocumentBytes, 0, renderingResult.DocumentBytes.Length);

                exception = null;
                return(stream);
            }
            catch (Exception ex)
            {
                exception = ex;
                return(null);
            }
        }
Esempio n. 27
0
        private void btnPrintNama_Click(object sender, EventArgs e)
        {
            DialogResult res = MessageBox.Show("Print Slip THR. Siap kan kertas di printer."
                                               , "Print Slip THR"
                                               , MessageBoxButtons.OKCancel
                                               , MessageBoxIcon.Question
                                               , MessageBoxDefaultButton.Button2
                                               , MessageBoxOptions.DefaultDesktopOnly);

            if (res == System.Windows.Forms.DialogResult.OK)
            {
                //Print Slip Gaji
                rptGajiTHRNama gj = new rptGajiTHRNama();
                gj.ReportParameters["templateid"].Value       = (chkBayarOleh.Checked ? -2 : -1);
                gj.ReportParameters["tipepembayaranid"].Value = 4;
                gj.ReportParameters["User"].Value             = NBConfig.ValidUserName;
                gj.ReportParameters["memberid"].Value         = rddMember.SelectedValue;
                int tahun = 0;
                if (dtpTahun.Value == null)
                {
                    dtpTahun.Value = DateTime.Now;
                }
                tahun = dtpTahun.Value.Year;
                gj.ReportParameters["tahun"].Value = tahun;
                IReportDocument report1 = (IReportDocument)gj;
                ////set parameters when necessary

                //// PrinterSettings
                PrinterSettings printerSettings = new PrinterSettings();
                //// Adjust the printer settings if necessary...
                InstanceReportSource reportSource = new InstanceReportSource();
                reportSource.ReportDocument = report1;
                // Print the report using the printer settings.
                ReportProcessor reportProcessor = new ReportProcessor();
                reportProcessor.PrintReport(reportSource, printerSettings);
            }
        }
Esempio n. 28
0
        public static bool SaveReport(IReportDocument report, string filename, out Exception exception, string format)
        {
            try
            {
                ReportProcessor      reportProcessor      = new ReportProcessor();
                InstanceReportSource instanceReportSource = new InstanceReportSource();

                instanceReportSource.ReportDocument = report;

                RenderingResult renderingResult = reportProcessor.RenderReport(format.ToUpper(), instanceReportSource, null);
                filename = filename.Replace('\n', ' ');
                using (FileStream fs = new FileStream(filename, FileMode.Create))
                {
                    fs.Write(renderingResult.DocumentBytes, 0, renderingResult.DocumentBytes.Length);
                }
                exception = null;
                return(true);
            }
            catch (Exception ex)
            {
                exception = ex;
                return(false);
            }
        }
Esempio n. 29
0
        public void ExportToPDF(Report reportToExport)
        {
            var reportProcessor      = new Telerik.Reporting.Processing.ReportProcessor();
            var instanceReportSource = new InstanceReportSource();

            instanceReportSource.ReportDocument = reportToExport;
            var result = reportProcessor.RenderReport("PDF", instanceReportSource, null);

            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.ContentType = result.MimeType;
            HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.Private);
            HttpContext.Current.Response.Expires = -1;
            HttpContext.Current.Response.Buffer  = true;

            /* Uncomment to handle the file as attachment
             * Response.AddHeader("Content-Disposition",
             *              string.Format("{0};FileName=\"{1}\"",
             *                              "attachment",
             *                              fileName));
             */

            HttpContext.Current.Response.BinaryWrite(result.DocumentBytes);
            HttpContext.Current.Response.End();
        }
Esempio n. 30
0
        [HttpGet("{reportId}")] //Get /api/design/report/1234567
        public async Task Report(string reportId)
        {
#if !APPBOXPRO
            throw new NotSupportedException();
#else
            //设置当前用户会话
            RuntimeContext.Current.CurrentSession = HttpContext.Session.LoadWebSession();
            //判断权限
            if (!(RuntimeContext.Current.CurrentSession is IDeveloperSession developerSession))
            {
                throw new Exception("Must login as a Developer");
            }
            var desighHub = developerSession.GetDesignHub();
            if (desighHub == null)
            {
                throw new Exception("Cannot get DesignContext");
            }
            //TODO: 以下代码与OpenReportModel重复,待优化
            var modelNode = desighHub.DesignTree.FindModelNode(ModelType.Report, ulong.Parse(reportId));
            if (modelNode == null)
            {
                throw new Exception($"Cannot find report model: {reportId}");
            }

            //TODO:直接加载字节流
            string json = null;
            if (modelNode.IsCheckoutByMe)
            {
                json = await StagedService.LoadReportCodeAsync(modelNode.Model.Id);
            }
            if (json == null)
            {
                json = await Store.ModelStore.LoadReportCodeAsync(modelNode.Model.Id);
            }

            var report = Parse(json);

            // //根据推/拉模式获取或生成预览数据源, TODO:暂全部生成测试数据
            foreach (var ds in report.DataSources)
            {
                var ods = (ObjectDataSource)ds;
                ods.DataSource = MakePreviewData(ods, 10);
            }

            //输出为pdf
            HttpContext.Response.ContentType = "application/pdf";
            var rs = new InstanceReportSource {
                ReportDocument = report
            };
            var deviceInfo = new Hashtable()
            {
                { "OutputFormat", "emf" },
                { "ProcessItemActions", false },
                { "WriteClientAction", false }
            };
            var renderContext = new Reporting.Processing.RenderingContext()
            {
                { "ReportDocumentState", null }
            };
            var processingReports = new Reporting.Processing.ReportProcessor()
                                    .ProcessReport(rs, deviceInfo, renderContext);
            var res = Reporting.Processing.ReportProcessor.RenderReport("IMAGE", processingReports,
                                                                        deviceInfo, renderContext);
            await HttpContext.Response.Body.WriteAsync(res.DocumentBytes);
#endif
        }
Esempio n. 31
0
        public ReportRecord CreateCoaReport(Sample sample, Identification identification)
        {
            ReportRecord rc = new ReportRecord();
            DateTime reportDate = DateTime.Now;

            // Update Timepoint Data
            List<SampleTest> testsNotOnReport = new List<SampleTest>();

            CoaReportModel reportData = new CoaReportModel();

            try
            {
                /*
                using (DbConnection = new MsSqlPersistence(DbConnectionSettings, true))
                {
                    if (DbConnection.IsConnected())
                    {
                        using (DbCommand)
                        {
                            // GET User
                            using (UserDAO userDao = new UserDAO())
                                reportData.User = userDao.GetUser(ref dbConnection, ref dbCommand, identification.UserId);
                            foreach (SampleTest test in sample.SampleTests)
                            {
                                List<TimePoint> timpointsNotOnReport = new List<TimePoint>();
                                //var isOnReport = Convert.ToBoolean(test.TimePoints.Count(x => x.IsOnReport == true));
                                //if (!isOnReport)
                                    //testsNotOnReport.Add(test);
                                /*foreach (TimePoint timePoint in test.TimePoints)
                                {
                                    if (!timePoint.IsOnReport)
                                        timpointsNotOnReport.Add(timePoint);
                                    if (timePoint.ReportDate.IsNull())
                                        timePoint.ReportDate = reportDate;
                                    if ((timePoint.ReportBy == 0 || timePoint.ReportBy.IsNull()) && timePoint.IsOnReport)
                                    {
                                        timePoint.ReportBy = identification.UserId;
                                        timePoint.ReportedByUser = reportData.User.FullName;
                                    }
                                    UpdateOrderSampleTestTimePointReportData(ref dbConnection, ref dbCommand, (int)timePoint.Id, timePoint.IsOnReport, timePoint.ReportDate, timePoint.ReportBy);

                                    if (test.CatalogItem.AnalyteId.IsNotNull() && test.CatalogItem.AnalyteId > 0)
                                    {
                                        timePoint.ResultDetail.ExpectedAmount = sample.SampleAnalytes.FirstOrDefault(a => a.AnalyteId == test.AnalyteId).Amount;
                                        timePoint.ResultDetail.ExpectedUnits = sample.SampleAnalytes.FirstOrDefault(a => a.AnalyteId == test.AnalyteId).AmountUOM;
                                    }
                                }
                                foreach (TimePoint removeTimePoint in timpointsNotOnReport)
                                {
                                    //test.TimePoints.Remove(removeTimePoint);
                                }
                            }
                        }
                    }
                    else
                    {
                        throw new Exception("Unable to Connect");
                    }
                }
            }
            catch
            {
                throw;
            }

            foreach (SampleTest onTest in testsNotOnReport)
                sample.SampleTests.Remove(onTest);

            // Create Report
            try
            {
                string customerSql = @"
                                    select customers.id, customers.customer_name, customers.accountingid, customers.termid,
                                    terms.value as terms, customers.credit_check , customers.web_client, customers.sales_rep_id,
                                    (users.firstname + ' ' + users.lastname) as modifieduser,
                                    (users2.firstname + ' ' + users2.lastname) as createduser,
                                    customers.modified_by, customers.modified_date, customers.created_by,
                                    customers.created_date, salesrep.firstname, salesrep.lastname
                                    from customers
                                    LEFT JOIN [User] as users ON customers.modified_by = users.UserID
                                    LEFT JOIN [User] as users2 ON customers.created_by = users2.UserID
                                    LEFT JOIN list.terms as terms ON customers.termid = terms.termid
                                    LEFT JOIN [User] as salesrep ON customers.sales_rep_id = salesrep.UserID
                                    LEFT JOIN orders ON orders.parentid = customers.id
                                    where orders.id = ";

                // Get Customer for Sample
                using (ClientDAO dao = new ClientDAO())
                    reportData.Customer = dao.GetClient(0);

                string getOrderNotesSql = @"
                                    SELECT orders_notes.id, orders_notes.parentid,orders_notes.txt,orders_notes.is_show_on_report,
                                    orders_notes.html, orders_notes.linked_type, orders_notes.linked_id, orders_notes.isnotify,
                                    (users.firstname + ' ' + users.lastname) as modifieduser,
                                    orders_notes.modified_by, orders_notes.modified_date, orders_notes.created_by,
                                    orders_notes.created_date, (users2.firstname + ' ' + users2.lastname) as createduser
                                    FROM orders_notes
                                    LEFT JOIN  [User] as users ON orders_notes.modified_by = users.UserID
                                    LEFT JOIN  [User] as users2 ON orders_notes.created_by = users2.UserID
                                    WHERE parentid = @ID AND orders_notes.delete_date IS NULL
                                    AND orders_notes.linked_id = 0
                                    AND orders_notes.linked_type = '" + EnumNoteLink.None.ToString() + @"'
                                    AND orders_notes.is_show_on_report = 1  ";

                //reportData.ReportNotes = GetSampleNotes(sample.ARLNumber.Value, identification, getOrderNotesSql);

                string getSampleNotesSql = @"
                                    SELECT orders_notes.id, orders_notes.parentid,orders_notes.txt,orders_notes.is_show_on_report,
                                    orders_notes.html, orders_notes.linked_type, orders_notes.linked_id, orders_notes.isnotify,
                                    (users.firstname + ' ' + users.lastname) as modifieduser,
                                    orders_notes.modified_by, orders_notes.modified_date, orders_notes.created_by,
                                    orders_notes.created_date, (users2.firstname + ' ' + users2.lastname) as createduser
                                    FROM orders_notes
                                    LEFT JOIN  [User] as users ON orders_notes.modified_by = users.UserID
                                    LEFT JOIN  [User] as users2 ON orders_notes.created_by = users2.UserID
                                    WHERE parentid = @ID AND orders_notes.delete_date IS NULL
                                    AND orders_notes.linked_id = " + sample.ARLNumber.Value +
                                           @" AND orders_notes.linked_type = '" + EnumNoteLink.Sample.ToString() + @"'
                                    AND orders_notes.is_show_on_report = 1  ";

                foreach (SampleTest test in sample.SampleTests)
                {
                    string getTestNotesSql = @"
                                        SELECT orders_notes.id, orders_notes.parentid,orders_notes.txt,orders_notes.is_show_on_report,
                                        orders_notes.html, orders_notes.linked_type, orders_notes.linked_id, orders_notes.isnotify,
                                        (users.firstname + ' ' + users.lastname) as modifieduser,
                                        orders_notes.modified_by, orders_notes.modified_date, orders_notes.created_by,
                                        orders_notes.created_date, (users2.firstname + ' ' + users2.lastname) as createduser
                                        FROM orders_notes
                                        LEFT JOIN  [User] as users ON orders_notes.modified_by = users.UserID
                                        LEFT JOIN  [User] as users2 ON orders_notes.created_by = users2.UserID
                                        WHERE parentid = @ID AND orders_notes.delete_date IS NULL
                                        AND orders_notes.linked_id = " + test.SampleTestId.Value +
                                             @" AND orders_notes.linked_type = '" + EnumNoteLink.Test.ToString() + @"'
                                        AND orders_notes.is_show_on_report = 1  ";

                    //test.ReportNotes = GetSampleNotes(test.ARLNumber.Value, identification, getTestNotesSql);
                }
                */
                reportData.Sample = sample;

                if (!string.IsNullOrWhiteSpace(reportData.User.Signature.Signature))
                    reportData.Signature = Image.FromStream(new MemoryStream(Convert.FromBase64String(Security.AesDecrypt(reportData.User.Signature.Signature, AppVars.dbSettings.BaseKey))));

                Reports.Coa report = new Reports.Coa();
                //report.ReportData = reportData;
                ReportProcessor reportProcessor = new ReportProcessor();
                InstanceReportSource instanceReportSource = new InstanceReportSource();
                instanceReportSource.ReportDocument = report;
                RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);

                Byte[] pdfReport = result.DocumentBytes;

                rc.ReferenceId = sample.ARLNumber;
                rc.DepartmentId = sample.SampleTests[0].DepartmentId;
                rc.CreatedBy = identification.UserId;
                rc.CreatedDate = DateTime.Now;
                rc.ReportData = pdfReport;
                rc.ReportType = "PDF";
                rc.ReportName = "Certificate of Analysis";
                rc.SubjectLine = "Result ARL #" + sample.ARLNumber.ToString() + " Lot: " + sample.LotNumber.ToString() + " Drug: " + sample.Description.ToString();
                rc.Id = SaveReport(rc);
            }
            catch
            {
                throw;
            }
            return rc;
        }
Esempio n. 32
0
        private void SaveNewItem()
        {
            short  StatusID = 4;
            string iLogID   = string.Empty;
            string mobil    = string.Empty
            , sopir         = string.Empty
            , keterangan    = null;
            int kernetid    = -1
            , sopirid       = -1
            , mobilid       = -1
            , kotaid        = -1
            , salesid       = -1
            , custid        = -1
            , custtypeid    = -1
            , transtypeid   = -1;
            int paid        = 0;

            transtypeid = int.Parse(rddTipe.SelectedValue.ToString());
            custtypeid  = int.Parse(rddPel.Tag.ToString());
            kotaid      = int.Parse(rddTujuan.SelectedValue.ToString());
            salesid     = int.Parse(rddSales.SelectedValue.ToString());

            if (chkAntar.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
            {
                sopirid  = int.Parse(rddSopir.SelectedValue.ToString());
                mobilid  = int.Parse(rddMobil.SelectedValue.ToString());
                kernetid = int.Parse(rddKernet.SelectedValue.ToString());
            }
            else
            {
                sopir = txtSopir.Text;
                mobil = txtMobil.Text;
            }

            switch (rddTipe.Text.ToLower())
            {
            case "pelanggan":
            case "staff":
            case "pegawai":
            case "satpam":
            case "campuran":
                custid = int.Parse(rddPel.SelectedValue.ToString());
                break;

            case "sales":
                custid = int.Parse(rddSales.SelectedValue.ToString());
                break;

            case "contoh":
                break;
            }
            using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
            {
                //Always Create with status created
                iLogID = tbl.pInsertLogProd(tanggalDateTimePicker.Value
                                            , 0
                                            , kernetid
                                            , sopirid
                                            , mobilid
                                            , kotaid
                                            , salesid
                                            , mobil
                                            , sopir
                                            , keterangan
                                            , custid
                                            , custtypeid
                                            , transtypeid
                                            , NBConfig.ValidUserName
                                            , StatusID, paid, 0).ToString();
            }

            foreach (GridViewRowInfo item in radGridView1.Rows)
            {
                using (sinarekDataSetTableAdapters.logdetailTableAdapter tbl = new sinarekDataSetTableAdapters.logdetailTableAdapter())
                {
                    tbl.pInsertLogDetail(int.Parse(iLogID)
                                         , int.Parse(item.Cells["productid"].Value.ToString())
                                         , decimal.Parse(item.Cells["quantity"].Value.ToString())
                                         , transtypeid
                                         , int.Parse(item.Cells["custtypeid"].Value.ToString())
                                         , 1
                                         , item.Cells["keterangan"].Value.ToString()
                                         , NBConfig.ValidUserName);
                }
            }

            RadMessageBox.Show("Data sudah terinput.", "SMS");

            //Print
            DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
                                                  , MessageBoxButtons.OKCancel
                                                  , RadMessageIcon.Question
                                                  , MessageBoxDefaultButton.Button1);

            if (res == System.Windows.Forms.DialogResult.OK)
            {
                PrinterSettings printerSettings;
                ReportProcessor reportProcessor;

                rptSJ rpt = new rptSJ();
                rpt.ReportParameters["user"].Value  = NBConfig.ValidUserName;
                rpt.ReportParameters["logid"].Value = iLogID;
                //rpt.ReportParameters["custtypetoid"].Value = rddTipe.SelectedValue;

                IReportDocument iRpt = (IReportDocument)rpt;
                //// PrinterSettings
                printerSettings = new PrinterSettings();
                //// Adjust the printer settings if necessary...
                InstanceReportSource reportSource = new InstanceReportSource();
                reportSource.ReportDocument = iRpt;
                // Print the report using the printer settings.
                reportProcessor = new ReportProcessor();
                reportProcessor.PrintReport(reportSource, printerSettings);

                using (sinarekDataSetTableAdapters.logproductTableAdapter tbl = new sinarekDataSetTableAdapters.logproductTableAdapter())
                {
                    tbl.UpdatePrinted(NBConfig.ValidUserName, long.Parse(iLogID));
                }
                helper.PrintLog(this.GetType().Name, rpt.Name, this.Text + ":LogID-" + iLogID);
            }
            else
            {
                MessageBox.Show("Surat Jalan ini dapat dilihat di daftar surat jalan yg belum di print.");
            }
        }
Esempio n. 33
0
        private void btnSimpan_Click(object sender, EventArgs e)
        {
            if (ValidateFields())
            {
                string UJID;
                //Create UJ
                using (sinarekDataSetTableAdapters.uangjalanTableAdapter tbl = new sinarekDataSetTableAdapters.uangjalanTableAdapter())
                {
                    UJID = tbl.pInsertUangJalan(-2
                                                , "DALAM KOTA"
                                                , "KAS"
                                                , rddNama.Text
                                                , rddMobil.Text
                                                , txtKeterangan.Text
                                                , -1
                                                , decimal.Parse(txtJumlah.Text)
                                                , 0, NBConfig.ValidUserName).ToString();
                }
                //Print
                DialogResult res = RadMessageBox.Show("Siapkan kertas untuk print.", "SMS - Verification"
                                                      , MessageBoxButtons.OKCancel
                                                      , RadMessageIcon.Question
                                                      , MessageBoxDefaultButton.Button2);
                if (res == System.Windows.Forms.DialogResult.OK)
                {
                    PrinterSettings printerSettings;
                    ReportProcessor reportProcessor;

                    rptUJ rpt = new rptUJ();
                    rpt.ReportParameters["user"].Value = NBConfig.ValidUserName;
                    rpt.ReportParameters["UJid"].Value = UJID;

                    IReportDocument iRpt = (IReportDocument)rpt;

                    iRpt.DocumentName = "UJ_" + rddNama.Text + "_"
                                        + rddMobil.Text;
                    //// PrinterSettings
                    printerSettings = new PrinterSettings();
                    try
                    {
                        InstanceReportSource reportSource = new InstanceReportSource();
                        reportSource.ReportDocument = iRpt;
                        reportProcessor             = new ReportProcessor();

                        reportProcessor.PrintReport(reportSource, printerSettings);
                        using (sinarekDataSetTableAdapters.uangjalanTableAdapter tbl = new sinarekDataSetTableAdapters.uangjalanTableAdapter())
                        {
                            tbl.UpdatePrinted(1
                                              , NBConfig.ValidUserName
                                              , int.Parse(UJID));
                        }
                        helper.PrintLog(this.GetType().Name, rpt.Name, "Print:" + UJID);
                    }
                    catch (Exception ex)
                    {
                        helper.SysLog(this.GetType().Name, this.Text, ex.Message);
                        helper.ErrorMessage(ex.Message);
                    }
                }
                this.Close();
            }
        }