public void GivenReportBExistsWithSubreportReportC()
        {
            _reportB = new XtraReportWithSubReportInDetailReport();
            var band = (DetailReportBand)_reportB.Bands[BandKind.DetailReport];
            band.DataMember = "DogToys";
            _containerWithReportCInside = (XRSubreport)band.Bands[BandKind.Detail].Controls[0];

            _reportC = new XtraReport();
        }
        /// <summary>
        /// Evento que se ejecuta cuando se va a visualizar el subreporte de un elemento
        /// </summary>
        /// <param name="sender">Objeto que genero el evento</param>
        /// <param name="e">Argumentos asociados al evento</param>
        private void mantenimientoRealizadoContraProgramadoTotalesElementoRPT_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            XRSubreport subReport = ((XRSubreport)sender);

            if (subReport.ReportSource == null)
            {
                return;
            }

            subReport.ReportSource.DataSource = this.DataSource;
        }
Example #3
0
        /// <summary>
        /// Evento que se ejecuta antes de pintar la grafica de rendimiento de unidad
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void srReporteRendimientoCamion_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            var unidadId = this.GetCurrentColumnValue <int>("UnidadID");

            XRSubreport reporteMeses = sender as XRSubreport;
            ReporteRendimientoUnidadGraficaRPT subGlobalReport = reporteMeses.ReportSource as ReporteRendimientoUnidadGraficaRPT;

            subGlobalReport.SetFilter(unidadId);
            //ReporteRendimientoUnidadGraficaRPT subGlobalReport = this.srReporteRendimientoCamion.ReportSource as ReporteRendimientoUnidadGraficaRPT;
            //subGlobalReport.BindToDataSource();
        }
Example #4
0
        /// <summary>
        /// Evento que se ejecuta cuando se va a visualizar el subreporte de acumulados por modelo
        /// </summary>
        /// <param name="sender">Objeto que genero el evento</param>
        /// <param name="e">Argumentos asociados al evento</param>
        private void xrSubRptRentados_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            XRSubreport subReport = sender as XRSubreport;

            if (subReport.ReportSource == null)
            {
                return;
            }

            subReport.ReportSource.DataSource = this.DataSource;
        }
Example #5
0
        private static MyReportBase ConvertReportSourceToMyReportBaseIfNeeded(XRSubreport subreportContainer)
        {
            var subreportAsMyReportbase = subreportContainer.ReportSource as MyReportBase;

            if (subreportAsMyReportbase == null)
            {
                subreportAsMyReportbase         = subreportContainer.ReportSource.ConvertReportToMyReportBase();
                subreportContainer.ReportSource = subreportAsMyReportbase;
            }

            return(subreportAsMyReportbase);
        }
Example #6
0
    private MemoryStream PrintWh_invoice(string refN, string refType, string userId)
    {
        string     user = HttpContext.Current.User.Identity.Name;
        XtraReport rpt  = new XtraReport();

        rpt.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice.repx"));


        string    strsql  = string.Format(@"exec proc_PrintInvoice_wh '{0}','{1}','{2}','{3}','{4}'", refN, "", refType, userId, "");
        DataSet   ds_temp = ConnectSql.GetDataSet(strsql);
        DataTable Mast    = ds_temp.Tables[0].Copy();

        Mast.TableName = "Mast";
        DataTable Detail = ds_temp.Tables[1].Copy();

        Detail.TableName = "Detail";
        DataTable Detail2 = new DataTable();

        if (ds_temp.Tables.Count > 2)
        {
            Detail2           = ds_temp.Tables[2].Copy();
            Detail2.TableName = "Detail";
        }


        if (Detail.Rows.Count > 0)
        {
            DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Inv = rpt.Report.Bands["GroupFooter_Wine"] as DevExpress.XtraReports.UI.GroupFooterBand;
            DevExpress.XtraReports.UI.XRSubreport     subReport_Inv   = new XRSubreport();
            subReport_Inv.Name = "GroupFooter_Wine1";
            groupFooter_Inv.Controls.Add(subReport_Inv);
            XtraReport rpt_Inv = new XtraReport();
            rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice_1.repx"));
            subReport_Inv.ReportSource = rpt_Inv;
            rpt_Inv.DataSource         = Detail;
        }
        if (Detail2.Rows.Count > 0)
        {
            DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Inv = rpt.Report.Bands["GroupFooter_Other"] as DevExpress.XtraReports.UI.GroupFooterBand;
            DevExpress.XtraReports.UI.XRSubreport     subReport_Inv   = new XRSubreport();
            subReport_Inv.Name = "GroupFooter_Other1";
            groupFooter_Inv.Controls.Add(subReport_Inv);
            XtraReport rpt_Inv = new XtraReport();
            rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice_2.repx"));
            subReport_Inv.ReportSource = rpt_Inv;
            rpt_Inv.DataSource         = Detail2;
        }

        rpt.DataSource = Mast;
        System.IO.MemoryStream str = new MemoryStream();
        rpt.ExportToPdf(str);
        return(str);
    }
        private static MyReportBase ConvertReportSourceToMyReportBaseIfNeeded(XRSubreport subreportContainer)
        {
            var subreportAsMyReportbase = subreportContainer.ReportSource as MyReportBase;

            if (subreportAsMyReportbase == null)
            {
                subreportAsMyReportbase = subreportContainer.ReportSource.ConvertReportToMyReportBase();
                subreportContainer.ReportSource = subreportAsMyReportbase;
            }

            return subreportAsMyReportbase;
        }
Example #8
0
 private void xrSubreport1_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
 {
     try
     {
         XRSubreport xrSubReport         = (XRSubreport)sender;
         XCAJ_Rpt004_ingresos_Rpt subRep = xrSubReport.ReportSource as XCAJ_Rpt004_ingresos_Rpt;
         subRep.p_IdConciliacion.Value = Convert.ToDecimal(P_IdConcilacionCaja.Value);
     }
     catch (Exception)
     {
         throw;
     }
 }
        /// <summary>
        /// Evento que se ejecuta antes de visualizar el subreporte de la grafica de sistemas revisados
        /// </summary>
        /// <param name="sender">Objeto que genero el evento</param>
        /// <param name="e">Argumentos relacionados con el evento</param>
        private void Subreporte_Grafica_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            XRSubreport subreporte = sender as XRSubreport;

            if (subreporte.ReportSource == null)
            {
                return;
            }
            subreporte.ReportSource.DataSource = this.DataSource;
            var ordenServicioID = this.GetCurrentColumnValue <Int32>("OrdenServicioID");

            subreporte.ReportSource.FilterString = String.Format("[OrdenServicioID] = {0}", ordenServicioID).ToString();
        }
Example #10
0
        private void xrSubreport1_BeforePrint_1(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            XRSubreport reporteUnidades = sender as XRSubreport;

            if (reporteUnidades.ReportSource == null)
            {
                return;
            }
            reporteUnidades.ReportSource.DataSource = this.DataSource;
            var areaID = this.GetCurrentColumnValue <Int32>("AreaID");

            reporteUnidades.ReportSource.FilterString = String.Format("[AreaID] = {0}", areaID).ToString();
        }
        /*
        public static void PassDatasourceToSubreports(XtraReport report)
        {
            var subreports = report.FindAllSubreports();

            foreach (var subreportContainer in subreports)
                PassDatasourceToSubreport(subreportContainer);
        }

        #region Helper Methods

        private static void PassDatasourceToSubreport(XRSubreport subreportContainer)
        {
            subreportContainer.BeforePrint += (sender, e) =>
            {
                var subreportContainer = (XRSubreport)sender;
                SetDataSourceOnSubreport(subreportContainer);
            };
        }
        */
        public static object SetDataSourceOnSubreport(XRSubreport subreport)
        {
            var datasource = subreport.Band.GetDataSource();

            // Good code below!
            if (datasource != null)
            {
                var report = subreport.ReportSource;

                report.SetReportDataSource(datasource);
            }

            return datasource;
        }
 public override string[] GetStandardUrls(ITypeDescriptorContext context)
 {
     if (context != null && context.Instance is XRSubreport)
     {
         XRSubreport xrSubreport = context.Instance as XRSubreport;
         if (xrSubreport.RootReport !=
             null && xrSubreport.RootReport.Extensions.TryGetValue("StorageID", out storageID))
         {
             List <string> result = GetUrlsCore(CanPassId);
             return(result.ToArray());
         }
     }
     return(GetUrls());
 }
Example #13
0
        /// <summary>
        /// Evento que se ejecuta para llamar al Reporte por Sucursal
        /// </summary>
        private void ReporteSucursal_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            XRSubreport reporteSucursal = sender as XRSubreport;

            if (reporteSucursal.ReportSource == null)
            {
                return;
            }
            reporteSucursal.ReportSource.DataSource = this.DataSource;

            var sucursalId = this.GetCurrentColumnValue <int>("SucursalID");

            reporteSucursal.ReportSource.FilterString = String.Format("[SucursalID] = {0}", sucursalId);
        }
Example #14
0
/*
 *      public static void PassDatasourceToSubreports(XtraReport report)
 *      {
 *          var subreports = report.FindAllSubreports();
 *
 *          foreach (var subreportContainer in subreports)
 *              PassDatasourceToSubreport(subreportContainer);
 *      }
 *
 #region Helper Methods
 *
 *      private static void PassDatasourceToSubreport(XRSubreport subreportContainer)
 *      {
 *          subreportContainer.BeforePrint += (sender, e) =>
 *          {
 *              var subreportContainer = (XRSubreport)sender;
 *              SetDataSourceOnSubreport(subreportContainer);
 *          };
 *      }
 */

        public static object SetDataSourceOnSubreport(XRSubreport subreport)
        {
            var datasource = subreport.Band.GetDataSource();

            // Good code below!
            if (datasource != null)
            {
                var report = subreport.ReportSource;

                report.SetReportDataSource(datasource);
            }

            return(datasource);
        }
Example #15
0
        /// <summary>
        /// Evento ejecutado antes de que se imprima cada subReporte
        /// </summary>
        private void xrsrpUnidad_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            XRSubreport reporteModelo = sender as XRSubreport;

            if (reporteModelo.ReportSource == null)
            {
                return;
            }
            reporteModelo.ReportSource.DataSource = this.DataSource;

            var modeloId = this.GetCurrentColumnValue <int>("ModeloID");

            reporteModelo.ReportSource.FilterString = String.Format("[ModeloID] = {0}", modeloId);
        }
        /// <summary>
        /// Evento Ejecutado antes de la impresion del subreporte de datos de rendimiento
        /// </summary>
        private void xrSubreport1_BeforePrint(object sender, PrintEventArgs e)
        {
            var unidadId = this.GetCurrentColumnValue <int>("UnidadID");

            XRSubreport reporteMeses = sender as XRSubreport;

            if (reporteMeses.ReportSource == null)
            {
                return;
            }

            reporteMeses.ReportSource.DataSource   = this.DataSource;
            reporteMeses.ReportSource.FilterString = String.Format("[UnidadID] = {0}", unidadId);
        }
        /// <summary>
        /// Método ejecutado antes de imprimir cada sección del subreporte
        /// </summary>
        private void sbrptFlotaTotalElemento_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            XRSubreport subReport = ((XRSubreport)sender);

            if (subReport.ReportSource == null)
            {
                return;
            }

            subReport.ReportSource.DataSource = this.DataSource;
            int sucursalID = this.GetCurrentColumnValue <int>("SucursalID");

            subReport.ReportSource.FilterString = String.Format("[SucursalID] = {0}", sucursalID);
        }
        /// <summary>
        /// Evento que se ejecuta cuando se va a visualizar el subreporte qde un elemento de agrupamiento de equipos por sucursales
        /// </summary>
        /// <param name="sender">Objeto que genero el evento</param>
        /// <param name="e">Argumentos asociados al evento</param>
        private void flotaActivaRDSucursalElementoRPT_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            XRSubreport subReport = ((XRSubreport)sender);

            if (subReport.ReportSource == null)
            {
                return;
            }

            subReport.ReportSource.DataSource = this.DataSource;
            int modeloID   = this.GetCurrentColumnValue <int>("ModeloID");
            int sucursalID = this.GetCurrentColumnValue <int>("SucursalID");

            subReport.ReportSource.FilterString = String.Format("[ModeloID] = {0} And [BranchID] = {1}", modeloID, sucursalID);
        }
        public static int SetRootHashCodeOnSubreport(XRSubreport subreportContainer)
        {
            var myReportBase = subreportContainer.NavigateToMyReportBase();
            var hashcode = myReportBase.RootHashCode;

            if(hashcode == 0)
                throw new Exception("Report did not have a root hashcode.");

            var subreportAsMyReportbase = ConvertReportSourceToMyReportBaseIfNeeded(subreportContainer);

            if (subreportAsMyReportbase != null)
                subreportAsMyReportbase.RootHashCode = hashcode;

            return hashcode;
        }
        void ICommandHandler.HandleCommand(ReportCommand command, object[] args)
        {
            XRDesignPanel panel = mdiController.ActiveDesignPanel;

            XRSubreport subreport = (XRSubreport)args[0];

            if (subreport.ReportSource == null && String.IsNullOrEmpty(subreport.ReportSourceUrl))
            {
                subreport.ReportSource = CreateReport();
            }

            IWindowsService windowsSvc = panel.GetService(typeof(IWindowsService)) as IWindowsService;

            windowsSvc.EditSubreport(subreport);
            subreport.ReportSource = null;
        }
Example #21
0
        private void xrsEquiposSemestre2_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            string      unidadID         = GetCurrentColumnValue <string>("UnidadID");
            XRSubreport reporteSemestre2 = sender as XRSubreport;

            if (reporteSemestre2.ReportSource == null)
            {
                return;
            }

            var reporte = reporteSemestre2.ReportSource as ReporteMantenimientosRealizadosAliadosRPT;

            reporte.anioCurso = this.anioCurso;
            reporte.semestre  = 2;

            reporteSemestre2.ReportSource.DataSource   = this.DataSource;
            reporteSemestre2.ReportSource.FilterString = String.Format("[UnidadID] = {0}", unidadID);
        }
Example #22
0
 private void SubReport_SaldoFinal_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
 {
     try
     {
         XRSubreport            xrSubReport = (XRSubreport)sender;
         XBAN_Rpt007_saldos_rpt subRep      = xrSubReport.ReportSource as XBAN_Rpt007_saldos_rpt;
         subRep.set_parametros("FINAL", lstInfo_saldos);
     }
     catch (Exception ex)
     {
         Log_Error_bus.Log_Error(ex.ToString());
         Core.Erp.Info.Log_Exception.LoggingManager.Logger.Log(Core.Erp.Info.Log_Exception.LoggingCategory.Error, ex.Message);
         throw new Core.Erp.Info.Log_Exception.DalException(string.Format("", "SubReport_SaldoFinal_BeforePrint", ex.Message), ex)
               {
                   EntityType = typeof(XBAN_Rpt007_rpt)
               };
     }
 }
Example #23
0
        void ReduceControlSize(XRSubreport subreport, int level)
        {
            XtraReport report = subreport.ReportSource;

            report.PaperKind = System.Drawing.Printing.PaperKind.Custom;
            report.PageWidth = (int)(PrintingSystem.PageSettings.UsablePageSize.Width - subreport.LocationF.X * (level - 1) + report.Margins.Right);
            subreport.WidthF = report.PageWidth;
            foreach (Band band in report.Bands)
            {
                foreach (XRControl control in band.Controls)
                {
                    if (control is XRTable)
                    {
                        (control as XRTable).WidthF = subreport.SizeF.Width;
                    }
                }
            }
        }
        public void Should_convert_subreport_to_myReportBase()
        {
            var report             = new XtraReport();
            var detailBand         = new DetailBand();
            var subReportContainer = new XRSubreport {
                ReportSource = new XtraReport()
            };

            report.Bands.Add(detailBand);
            detailBand.Controls.Add(subReportContainer);


            var controller = new XRReportController(report);
            var newReport  = controller.Print(p => p.ExportToMemory());

            var newContainer = (XRSubreport)newReport.Bands[0].Controls[0];

            newContainer.ReportSource.GetType().Should().Be(typeof(MyReportBase));
        }
Example #25
0
        public static int SetRootHashCodeOnSubreport(XRSubreport subreportContainer)
        {
            var myReportBase = subreportContainer.NavigateToMyReportBase();
            var hashcode     = myReportBase.RootHashCode;

            if (hashcode == 0)
            {
                throw new Exception("Report did not have a root hashcode.");
            }

            var subreportAsMyReportbase = ConvertReportSourceToMyReportBaseIfNeeded(subreportContainer);

            if (subreportAsMyReportbase != null)
            {
                subreportAsMyReportbase.RootHashCode = hashcode;
            }

            return(hashcode);
        }
Example #26
0
        public XRSubreport SetReport(PianoRatealeSinglePage report, BandKind band)
        {
            var subreport = new XRSubreport
            {
                ReportSource = report.GetReport(),
                LocationF = new PointF(0, _location + .01f)
            };
            _report.Bands[band].Controls.Add(subreport);

            _location += report.GetTotalHeight();

            if (band == BandKind.Detail && _location > 0 && _pagesStartOnNewPage)
            {
                var pageBreak = new XRPageBreak();
                _report.Bands[band].Controls.Add(pageBreak);
                pageBreak.LocationF = new PointF(0, _location + .01f);
            }
            return subreport;
        }
Example #27
0
        /// <summary>
        /// Evento ejecutado para llamar a los subreportes con los filtros
        /// </summary>
        private void sbrptElementoDetail_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            XRSubreport reporteSucursal = sender as XRSubreport;

            if (reporteSucursal.ReportSource == null)
            {
                return;
            }
            reporteSucursal.ReportSource.DataSource = this.DataSource;

            var mes = this.GetCurrentColumnValue <int>("Mes");

            if (UsarSucursal.Value)
            {
                var sucursalId = this.GetCurrentColumnValue <int>("SucursalID");

                reporteSucursal.ReportSource.FilterString = String.Format("[Mes] = {0} AND [SucursalID] = {1}", mes, sucursalId);
            }
        }
Example #28
0
        /// <summary>
        /// Evento ejecutado enviar el dataset a los subreportes
        /// </summary>
        private void sbrptTotalesMes_BeforePrint(object sender, PrintEventArgs e)
        {
            XRSubreport reporteSucursal = sender as XRSubreport;

            if (reporteSucursal.ReportSource == null)
            {
                return;
            }
            reporteSucursal.ReportSource.DataSource = this.DataSource;

            var mes = UsarSucursal.Value == true?this.GetCurrentColumnValue <int>("Mes") : Mes.Value;

            if (UsarSucursal.Value)
            {
                var sucursalId = this.GetCurrentColumnValue <int>("SucursalID");
                RentaDiariaGeneralSucursalModeloRPT report = this.sbrptTotalesMes.ReportSource as RentaDiariaGeneralSucursalModeloRPT;
                report.SetFilter(sucursalId, mes);
                reporteSucursal.ReportSource.FilterString = String.Format("[Mes] = {0} AND [SucursalID] = {1}", mes, sucursalId);
            }
        }
Example #29
0
        public void MergeReports(IList<XtraReport> reports)
        {
            var location = 0f;
            foreach (var xtraReport in reports)
            {
                location += .01f;
                var subreport = new XRSubreport
                {
                    ReportSource = xtraReport,
                    LocationF = new PointF(0, location + .01f)
                };
                _detailBand.Controls.Add(subreport);
                location = subreport.LocationF.Y + subreport.HeightF;

                location += .01f;
                var pageBreak = new XRPageBreak { LocationF = new PointF(0, location + 1f), WidthF = 100f };
                _detailBand.Controls.Add(pageBreak);
                location = pageBreak.LocationF.Y + pageBreak.HeightF;
            }
        }
Example #30
0
        private void xrSubreport1_BeforePrint_2(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
            {
                connect.Open();

                _command = new SqlCommand("doIGRReport", connect)
                {
                    CommandType = CommandType.StoredProcedure
                };

                _command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Summary";

                _command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = GetCurrentColumnValue("BatchCode");

                using (System.Data.DataSet ds = new System.Data.DataSet())
                {
                    ds.Clear();
                    adp = new SqlDataAdapter(_command);
                    adp.Fill(ds);
                    connect.Close();

                    if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00")
                    {
                        XRSubreport xrSubReport = (XRSubreport)sender;

                        XtraRepSubSummary subrep = xrSubReport.ReportSource as XtraRepSubSummary;

                        subrep.DataSource = ds.Tables[1];

                        subrep.DataMember = "table";

                        subrep.Parameters["parameter1"].Value = GetCurrentColumnValue("BatchCode");
                    }
                    else
                    {
                        return;
                    }
                }
            }
        }
Example #31
0
        /// <summary>
        /// 報表套用模板
        /// </summary>
        /// <param name="detailReport">報表</param>
        /// <param name="mainReport">模板報表</param>
        /// <returns></returns>
        public XtraReport CreateCompositeReport(XtraReport detailReport, XtraReport mainReport)
        {
            // Create a subreport.
            XRSubreport subreport = new XRSubreport();

            mainReport.Margins = detailReport.Margins;
            // Create a detail band and add it to the main report.

            DetailBand detailBand = (DetailBand)mainReport.Bands[BandKind.Detail];

            mainReport.Bands.Add(detailBand);

            // Set the subreport's location.
            subreport.Location = new System.Drawing.Point(mainReport.FindControl("PageHeader", true).Width, mainReport.FindControl("PageHeader", true).Height);

            // 設定報表
            subreport.ReportSource = detailReport;

            // Add the subreport to the detail band.
            detailBand.Controls.Add(subreport);
            return(mainReport);
        }
        private void CreateDetailReportBasedOnSubreport(XtraReport report)
        {
            //Create a Subreport
            XRSubreport subreport  = new XRSubreport();
            DetailBand  detailBand = report.Bands[BandKind.Detail] as DetailBand;

            detailBand.Controls.Add(subreport);

            subreport.LocationF = new PointF(0, detailBand.HeightF);
            subreport.WidthF    = report.PageWidth - report.Margins.Right - report.Margins.Left;
            //Create a detail Report
            XtraReport detailReport = new XtraReport()
            {
                DataSource = report.DataSource, DataMember = "Orders"
            };

            InitStyles(detailReport);

            subreport.ReportSource = detailReport;
            //Create bands
            CreateReportHeader(detailReport, "Orders", Color.Gold, 16);

            NwindDataSet ds = report.DataSource as NwindDataSet;

            CreateDetailBand(detailReport, ds.Orders, "Orders", Color.Transparent, true);

            //Add a parameter for filtering
            Parameter param = new Parameter()
            {
                Name = "custID", Type = typeof(string), Visible = false, Value = string.Empty
            };

            detailReport.Parameters.Add(param);
            detailReport.FilterString = "[CustomerID]==?custID";

            //Handle the Subreport.BeforePrint event for filtering details dynamically
            subreport.BeforePrint += subreport_BeforePrint;
        }
        public void Handler_wireup_should_be_predicatable()
        {
            var myBase = new MyReportBase();
            var detailBand = new DetailBand();
            var container = new XRSubreport();
            var subReport = new MyReportBase();

            container.ReportSource = subReport;
            detailBand.Controls.Add(container);
            myBase.Bands.Add(detailBand);

            myBase.DataSource = new[]
                                    {
                                        new object(),
                                        new object(),
                                        new object(),
                                        new object()
                                    };

            var controller = new DataSourceTrackingController(myBase, (s, ds) => _counter++);
            controller.Print(r => r.ExportToMemory());
            _counter.Should().Be(4);
        }
        public void Should_pass_root_hashcode()
        {
            var view = new XtraReport {DataSource = new[] {new object(), new object()}};

            var detailBand = new DetailBand();
            var container = new XRSubreport();
            var subReport = new MyReportBase();

            container.ReportSource = subReport;
            detailBand.Controls.Add(container);
            view.Bands.Add(detailBand);

            IReportController myController = new XRReportController(view);
            Action<XtraReport> printAction = r => r.ExportToMemory();
            var newView = myController.Print(printAction);

            var subReportsHashcode =
                ((MyReportBase) ((XRSubreport) newView.Bands[BandKind.Detail].Controls[0]).ReportSource).RootHashCode;

            newView.RootHashCode.Should().NotBe(0);

            subReportsHashcode.Should().Be(newView.RootHashCode);
        }
Example #35
0
        public static Tuple <MyReportBase, XRSubreport, MyReportBase, IDesignerContext> GetParentAndNestedSubreport()
        {
            var factory = new ReportFactory();

            // Parent Report
            var parentReport = factory.GetNewReport("parentReport");

            // Subreport
            var subreport = factory.GetNewReport("subreport");

            // Order-Details Band
            var detailReport = new DetailReportBand()
            {
                DataMember = "Order_Details"
            };
            var detailBand = new DetailBand();

            parentReport.Bands.Add(detailReport);
            detailReport.Bands.Add(detailBand);

            // Insert Subreport into Subreport Container... for Runtime Testing
            var subreportContainer = new XRSubreport()
            {
                ReportSource = subreport
            };

            detailBand.Controls.Add(subreportContainer);

            // Datasource MUST be set AFTER the Detail Band has been added!!  Otherwise detailband gets empty object[] as its datasource
            var designContext = TestHelper.CreateDesignerContext();

            parentReport.ChangeDesignTimeDatasource(TestHelper.NorthwindDataSource, designContext);
            Assert.IsNotNull(parentReport.DataSource);

            return(new Tuple <MyReportBase, XRSubreport, MyReportBase, IDesignerContext>(parentReport, subreportContainer, subreport, designContext));
        }
        public XtraReport CreateCompositeReport(XtraReport detailReport)
        {
            // Create a report.
            XtraReport mainReport = new XtraReport();

            // Create a Subreport.
            XRSubreport subreport = new XRSubreport();

            // Create a detail band and add it to the main report.
            DetailBand detailBand = new DetailBand();

            mainReport.Bands.Add(detailBand);

            // Set the subreport's location.
            subreport.Location = new Point(110, 100);

            // Specify a detail report as a report source for the subreport.
            subreport.ReportSource = detailReport;

            // Add the subreport to the detail band.
            detailBand.Controls.Add(subreport);

            return(mainReport);
        }
Example #37
0
        public anexo4(string id)
        {
            InitializeComponent();

            PointF point = new PointF(0, 115);

            bdanexoDataSet.expedienteDataTable exp = expedienteTableAdapter1.ExpedienteById(Convert.ToInt16(id));
            int idexpediente = ((bdanexoDataSet.expedienteRow)exp.Rows[0]).Id;

            bdanexoDataSet.usuarioDataTable item = usuarioTableAdapter1.UsuarioById(((bdanexoDataSet.expedienteRow)exp.Rows[0]).idusuario);

            xrtempresa.Text = "ALIMATIC";
            xrtusuario.Text = ((bdanexoDataSet.usuarioRow)item.Rows[0]).usuario;
            xrtarea.Text = ((bdanexoDataSet.usuarioRow)item.Rows[0]).area;
            xrtfecha.Text = DateTime.Today.ToShortDateString();

            //Obtencion del Equipo si existe.
            bdanexoDataSet.equipoDataTable equipo = equipoTableAdapter1.GetEquipoByUsuario(idexpediente);
            if (equipo.Count > 0)
            {
                xrtinventario.Text = ((bdanexoDataSet.equipoRow)equipo.Rows[0]).noinventario;
                xrtobservaciones.Text = ((bdanexoDataSet.equipoRow)equipo.Rows[0]).observaciones;
                xrtequipo.Text = ((bdanexoDataSet.equipoRow)equipo.Rows[0]).nombre;
                xrtdominiored.Text = ((bdanexoDataSet.equipoRow)equipo.Rows[0]).dominiored;
                xrtserie.Text = ((bdanexoDataSet.equipoRow)equipo.Rows[0]).noserie;
            }

            //Obtencion del Configuracion si existe.
            bdanexoDataSet.configuracionDataTable configuaracion = configuracionTableAdapter1.GetConfiguracionByUsuario(idexpediente);
            if (configuaracion.Count > 0)
            {
                XRSubreport xrsubrepor = new XRSubreport();
                xrsubrepor.ReportSource = new configReport(((bdanexoDataSet.configuracionRow)configuaracion.Rows[0]).placabase,
                ((bdanexoDataSet.configuracionRow)configuaracion.Rows[0]).procesador,
                ((bdanexoDataSet.configuracionRow)configuaracion.Rows[0]).noserieplaca,
                ((bdanexoDataSet.configuracionRow)configuaracion.Rows[0]).cantidad,
                ((bdanexoDataSet.configuracionRow)configuaracion.Rows[0]).memoria,
                ((bdanexoDataSet.configuracionRow)configuaracion.Rows[0]).tarjetared,
                ((bdanexoDataSet.configuracionRow)configuaracion.Rows[0]).tarjetasonido,
                ((bdanexoDataSet.configuracionRow)configuaracion.Rows[0]).tarjetagrafica,
                ((bdanexoDataSet.configuracionRow)configuaracion.Rows[0]).velocidad);

                Detail.Controls.Add(xrsubrepor);
                xrsubrepor.Visible = true;
                xrsubrepor.LocationF = point;

                xrsubrepor.SizeF = new SizeF(624, 172.01F);
                point.Y += 172.01F;
            }
            //Obtencion de los accesorios si existe.
            bdanexoDataSet.accesoriosDataTable accesorios = accesoriosTableAdapter1.GetAccesoriosByUsuario(idexpediente);
            if (accesorios.Count > 0)
            {
                XRSubreport xrsubrepor = new XRSubreport();
                xrsubrepor.ReportSource = new accesoriosReport(((bdanexoDataSet.accesoriosRow)accesorios.Rows[0]).mouse, ((bdanexoDataSet.accesoriosRow)accesorios.Rows[0]).bocinas,
                    ((bdanexoDataSet.accesoriosRow)accesorios.Rows[0]).teclado);
                Detail.Controls.Add(xrsubrepor);
                xrsubrepor.LocationF = point;

                xrsubrepor.Visible = true;
                xrsubrepor.SizeF = new SizeF(624, 122.3F);
                point.Y += 122.3F;
            }

            //Obtencion de los cd/dvd si existe.
            //Obtencion de los discoduro si existe.
            //Obtencion de los disquete si existe.

            bdanexoDataSet.disqueteDataTable disquete = disqueteTableAdapter1.GetDisqueteByUsuario(idexpediente);
            bdanexoDataSet.discoduroDataTable discoduro = discoduroTableAdapter1.GetDiscoDuroByUsuario(idexpediente);
            bdanexoDataSet.cdroomDataTable cddvd = cdroomTableAdapter1.GetDVDByUsuario(idexpediente);

            if (disquete.Count > 0 || discoduro.Count > 0 || cddvd.Count > 0)
            {
                almacenamientoReport almacReport = new almacenamientoReport();

                if (disquete.Count > 0)
                {
                    almacReport.nombreDisquete = ((bdanexoDataSet.disqueteRow)disquete.Rows[0]).nombre;
                    almacReport.noseriedisquete = ((bdanexoDataSet.disqueteRow)disquete.Rows[0]).noserie;
                }

                if (cddvd.Count > 0)
                {
                    almacReport.nombreCdDvd = ((bdanexoDataSet.cdroomRow)cddvd.Rows[0]).nombre;
                    almacReport.noserieCdDvd = ((bdanexoDataSet.cdroomRow)cddvd.Rows[0]).noserie;
                }

                if (discoduro.Count > 0)
                {
                    List<DiscoDuro> list = new List<DiscoDuro>();
                    foreach (var discoitem in discoduro.Rows)
                    {
                        DiscoDuro dd = new DiscoDuro();
                        dd.descripcion = ((bdanexoDataSet.discoduroRow)discoduro.Rows[0]).descripcion;
                        dd.capacidad = ((bdanexoDataSet.discoduroRow)discoduro.Rows[0]).capacidad;
                        dd.noserie = ((bdanexoDataSet.discoduroRow)discoduro.Rows[0]).noserie;
                        dd.estado = ((bdanexoDataSet.discoduroRow)discoduro.Rows[0]).estado;
                        list.Add(dd);
                    }
                    almacReport.discosduros = list;

                    XRSubreport xrsubrepor = new XRSubreport();
                    xrsubrepor.ReportSource = almacReport;
                    Detail.Controls.Add(xrsubrepor);
                    xrsubrepor.LocationF = point;

                    xrsubrepor.Visible = true;
                    xrsubrepor.SizeF = new SizeF(624, 188.14F);
                    point.Y += 188.14F;
                }
                //Obtencion de los escanner si existe.
                bdanexoDataSet.escannerDataTable escanner = escannerTableAdapter1.GetScannerByUsuario(idexpediente);
                if (escanner.Count > 0)
                {

                    XRSubreport xrsubrepor = new XRSubreport();
                    xrsubrepor.ReportSource = new escanerReport(((bdanexoDataSet.escannerRow)escanner.Rows[0]).marca, ((bdanexoDataSet.escannerRow)escanner.Rows[0]).modelo,
                       ((bdanexoDataSet.escannerRow)escanner.Rows[0]).noserie, ((bdanexoDataSet.escannerRow)escanner.Rows[0]).noinventario);
                    Detail.Controls.Add(xrsubrepor);
                    xrsubrepor.LocationF = point;

                    xrsubrepor.Visible = true;
                    xrsubrepor.SizeF = new SizeF(624, 80.72F);
                    point.Y += 80.72F;
                }

                //Obtencion de los fax si existe.
                bdanexoDataSet.faxDataTable fax = faxTableAdapter1.GetFaxByUsuario(idexpediente);
                if (fax.Count > 0)
                {
                    XRSubreport xrsubrepor = new XRSubreport();
                    xrsubrepor.ReportSource = new faxReport(((bdanexoDataSet.faxRow)fax.Rows[0]).marca,
                    ((bdanexoDataSet.faxRow)fax.Rows[0]).modelo, ((bdanexoDataSet.faxRow)fax.Rows[0]).noinventario, ((bdanexoDataSet.faxRow)fax.Rows[0]).noserie);
                    Detail.Controls.Add(xrsubrepor);
                    xrsubrepor.LocationF = point;

                    xrsubrepor.Visible = true;
                    xrsubrepor.SizeF = new SizeF(624, 80.72F);
                    point.Y += 80.72F;
                }

                //Obtencion de los impresora si existe.
                bdanexoDataSet.impresoraDataTable impresora = impresoraTableAdapter1.GetImpresoraByUsuario(idexpediente);
                if (impresora.Count > 0)
                {
                    XRSubreport xrsubrepor = new XRSubreport();
                    xrsubrepor.ReportSource = new impresoraReport(((bdanexoDataSet.impresoraRow)impresora.Rows[0]).modelo,
                        ((bdanexoDataSet.impresoraRow)impresora.Rows[0]).noserie, ((bdanexoDataSet.impresoraRow)impresora.Rows[0]).noinventario,
                        ((bdanexoDataSet.impresoraRow)impresora.Rows[0]).marca);
                    Detail.Controls.Add(xrsubrepor);
                    xrsubrepor.LocationF = point;

                    xrsubrepor.Visible = true;
                    xrsubrepor.SizeF = new SizeF(624, 80.72F);
                    point.Y += 80.72F;
                }

                //Obtencion de los monitor si existe.
                bdanexoDataSet.monitorDataTable monitor = monitorTableAdapter1.GetMonitorByUsuario(idexpediente);
                if (monitor.Count > 0)
                {
                    XRSubreport xrsubrepor = new XRSubreport();
                    xrsubrepor.ReportSource = new monitorReport(((bdanexoDataSet.monitorRow)monitor.Rows[0]).modelo, ((bdanexoDataSet.monitorRow)monitor.Rows[0]).noserie,
                        ((bdanexoDataSet.monitorRow)monitor.Rows[0]).noinventario, ((bdanexoDataSet.monitorRow)monitor.Rows[0]).marca);
                    Detail.Controls.Add(xrsubrepor);
                    xrsubrepor.LocationF = point;

                    xrsubrepor.Visible = true;
                    xrsubrepor.SizeF = new SizeF(624, 80.72F);
                    point.Y += 80.72F;
                }

                //Obtencion de los ups si existe.
                bdanexoDataSet.upsDataTable ups = upsTableAdapter1.GetUpsByUsuario(idexpediente);
                if (ups.Count > 0)
                {
                    XRSubreport xrsubrepor = new XRSubreport();
                    xrsubrepor.ReportSource = new upsReport(((bdanexoDataSet.upsRow)ups.Rows[0]).modelo, ((bdanexoDataSet.upsRow)ups.Rows[0]).noserie,
                        ((bdanexoDataSet.upsRow)ups.Rows[0]).noinventario, ((bdanexoDataSet.upsRow)ups.Rows[0]).marca);
                    Detail.Controls.Add(xrsubrepor);
                    xrsubrepor.LocationF = point;

                    xrsubrepor.Visible = true;
                    xrsubrepor.SizeF = new SizeF(624, 80.72F);
                    point.Y += 80.72F;
                }

                //Obtencion de los switch si existe.
                bdanexoDataSet.switchDataTable swt = switchTableAdapter1.GetSwitchByUsuario(idexpediente);
                if (swt.Count > 0)
                {
                    XRSubreport xrsubrepor = new XRSubreport();
                    xrsubrepor.ReportSource = new SwReport(((bdanexoDataSet.switchRow)swt.Rows[0]).modelo, ((bdanexoDataSet.switchRow)swt.Rows[0]).noserie,
                        ((bdanexoDataSet.switchRow)swt.Rows[0]).noinventario, ((bdanexoDataSet.switchRow)swt.Rows[0]).marca);
                    Detail.Controls.Add(xrsubrepor);
                    xrsubrepor.LocationF = point;

                    xrsubrepor.Visible = true;
                    xrsubrepor.SizeF = new SizeF(624, 80.72F);
                    point.Y += 80.72F;
                }

                //Obtencion de los fotocopiadora si existe.
                bdanexoDataSet.fotocopiadoraDataTable ft = fotocopiadoraTableAdapter1.GetFotocopiadoraByUsuario(idexpediente);
                if (ft.Count > 0)
                {
                    XRSubreport xrsubrepor = new XRSubreport();
                    xrsubrepor.ReportSource = new fotocopiadoraReport(((bdanexoDataSet.fotocopiadoraRow)ft.Rows[0]).modelo, ((bdanexoDataSet.fotocopiadoraRow)ft.Rows[0]).noserie,
                        ((bdanexoDataSet.fotocopiadoraRow)ft.Rows[0]).noinventario, ((bdanexoDataSet.fotocopiadoraRow)ft.Rows[0]).marca);
                    Detail.Controls.Add(xrsubrepor);
                    xrsubrepor.LocationF = point;

                    xrsubrepor.Visible = true;
                    xrsubrepor.SizeF = new SizeF(624, 80.72F);
                    point.Y += 80.72F;
                }

                XRLabel label1 = new XRLabel();
                label1.Text = "Elaborado por: ";
                Detail.Controls.Add(label1);
                label1.Visible = true;
                point.Y += 15;
                label1.LocationF = point;

                XRLine line1 = new XRLine();
                line1.LineWidth = 1;
                line1.SizeF = new System.Drawing.SizeF(358, 23);
                line1.Visible = true;
                PointF pontLine = new PointF();
                pontLine.X = point.X + 90;
                pontLine.Y = point.Y;
                line1.LocationF = pontLine;
                Detail.Controls.Add(line1);

                XRLabel label2 = new XRLabel();
                label2.Text = "Firma: ";
                Detail.Controls.Add(label2);
                label2.Visible = true;
                point.Y += 23;
                label2.LocationF = point;

                XRLine line2 = new XRLine();
                line2.LineWidth = 1;
                line2.SizeF = new System.Drawing.SizeF(358, 23);
                line2.Visible = true;
                Detail.Controls.Add(line2);
                pontLine.Y = point.Y;
                line2.LocationF = pontLine;

                XRLabel label3 = new XRLabel();
                label3.Text = "Usuario: ";
                Detail.Controls.Add(label3);
                label3.Visible = true;
                point.Y += 23;
                label3.LocationF = point;

                XRLine line3 = new XRLine();
                line3.LineWidth = 1;
                line3.SizeF = new System.Drawing.SizeF(358, 23);
                line3.Visible = true;
                Detail.Controls.Add(line3);
                pontLine.Y = point.Y;
                line3.LocationF = pontLine;

            }
        }
Example #38
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     string resourceFileName = "rptBanHang.resx";
         DevExpress.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
         DevExpress.XtraReports.UI.XRSummary xrSummary2 = new DevExpress.XtraReports.UI.XRSummary();
         DevExpress.XtraReports.UI.XRSummary xrSummary3 = new DevExpress.XtraReports.UI.XRSummary();
         DevExpress.XtraPrinting.BarCode.QRCodeGenerator qrCodeGenerator1 = new DevExpress.XtraPrinting.BarCode.QRCodeGenerator();
         this.Detail = new DevExpress.XtraReports.UI.DetailBand();
         this.xrTable2 = new DevExpress.XtraReports.UI.XRTable();
         this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell();
         this.colHangHoa = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell30 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell31 = new DevExpress.XtraReports.UI.XRTableCell();
         this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
         this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
         this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand();
         this.xrTable4 = new DevExpress.XtraReports.UI.XRTable();
         this.xrTableRow4 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell19 = new DevExpress.XtraReports.UI.XRTableCell();
         this.header = new DevExpress.XtraReports.UI.XRSubreport();
         this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel();
         this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel();
         this.xrLabel17 = new DevExpress.XtraReports.UI.XRLabel();
         this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand();
         this.xrTable7 = new DevExpress.XtraReports.UI.XRTable();
         this.xrTableRow8 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell23 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell25 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell24 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableRow9 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell26 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell27 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
         this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell21 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
         this.formattingRule1 = new DevExpress.XtraReports.UI.FormattingRule();
         this.dsBaoCaoBanHang1 = new dsBaoCaoBanHang();
         this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand();
         this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel();
         this.xrTable3 = new DevExpress.XtraReports.UI.XRTable();
         this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrSum = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell22 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell28 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell29 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableRow7 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell32 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell33 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableRow10 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell();
         this.sdfsdfsdf = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrDiscount01 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableRow11 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell48 = new DevExpress.XtraReports.UI.XRTableCell();
         this.thanhtienafterdis01 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTable6 = new DevExpress.XtraReports.UI.XRTable();
         this.xrTableRow6 = new DevExpress.XtraReports.UI.XRTableRow();
         this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell();
         this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell();
         this.lbchu = new DevExpress.XtraReports.UI.XRLabel();
         this.xrLine1 = new DevExpress.XtraReports.UI.XRLine();
         this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox();
         this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel();
         this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel();
         this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
         this.xrBarCode1 = new DevExpress.XtraReports.UI.XRBarCode();
         this.pTongTien = new DevExpress.XtraReports.UI.CalculatedField();
         this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand();
         this.sale_InvoiceToPrintTableAdapter1 = new dsBaoCaoBanHangTableAdapters.sale_InvoiceToPrintTableAdapter();
         this.Thanhtien = new DevExpress.XtraReports.UI.CalculatedField();
         this.percentDiscount1 = new DevExpress.XtraReports.UI.CalculatedField();
         this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand();
         this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel();
         this.xrPictureBox4 = new DevExpress.XtraReports.UI.XRPictureBox();
         this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel();
         this.xrPictureBox5 = new DevExpress.XtraReports.UI.XRPictureBox();
         this.xrTableCell34 = new DevExpress.XtraReports.UI.XRTableCell();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).BeginInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable7)).BeginInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
         ((System.ComponentModel.ISupportInitialize)(this.dsBaoCaoBanHang1)).BeginInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable6)).BeginInit();
         ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
         //
         // Detail
         //
         this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrTable2});
         this.Detail.Font = new System.Drawing.Font("Times New Roman", 9F);
         this.Detail.HeightF = 30F;
         this.Detail.Name = "Detail";
         this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
         this.Detail.StylePriority.UseFont = false;
         this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
         //
         // xrTable2
         //
         this.xrTable2.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
         this.xrTable2.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTable2.BorderWidth = 1F;
         this.xrTable2.Font = new System.Drawing.Font("MS Reference Sans Serif", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
         this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
         this.xrTable2.Name = "xrTable2";
         this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 5, 5, 100F);
         this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow2});
         this.xrTable2.SizeF = new System.Drawing.SizeF(748.96F, 30F);
         this.xrTable2.StylePriority.UseBorderDashStyle = false;
         this.xrTable2.StylePriority.UseBorders = false;
         this.xrTable2.StylePriority.UseBorderWidth = false;
         this.xrTable2.StylePriority.UseFont = false;
         this.xrTable2.StylePriority.UsePadding = false;
         this.xrTable2.StylePriority.UseTextAlignment = false;
         this.xrTable2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
         //
         // xrTableRow2
         //
         this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell7,
         this.colHangHoa,
         this.xrTableCell11,
         this.xrTableCell30,
         this.xrTableCell31});
         this.xrTableRow2.Name = "xrTableRow2";
         this.xrTableRow2.Weight = 1D;
         //
         // xrTableCell7
         //
         this.xrTableCell7.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell7.Name = "xrTableCell7";
         this.xrTableCell7.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
         this.xrTableCell7.StylePriority.UseBorders = false;
         this.xrTableCell7.StylePriority.UsePadding = false;
         this.xrTableCell7.StylePriority.UseTextAlignment = false;
         this.xrTableCell7.Text = "STT";
         this.xrTableCell7.Weight = 0.36458328247070315D;
         this.xrTableCell7.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell7_BeforePrint);
         //
         // colHangHoa
         //
         this.colHangHoa.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.colHangHoa.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.productname")});
         this.colHangHoa.Name = "colHangHoa";
         this.colHangHoa.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 100F);
         this.colHangHoa.StylePriority.UseBorders = false;
         this.colHangHoa.StylePriority.UsePadding = false;
         this.colHangHoa.StylePriority.UseTextAlignment = false;
         this.colHangHoa.Text = "colHangHoa";
         this.colHangHoa.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
         this.colHangHoa.Weight = 4.052847185033353D;
         //
         // xrTableCell11
         //
         this.xrTableCell11.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.CurrentPrice", "{0:n0}")});
         this.xrTableCell11.Name = "xrTableCell11";
         this.xrTableCell11.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 100F);
         this.xrTableCell11.StylePriority.UseBorders = false;
         this.xrTableCell11.StylePriority.UsePadding = false;
         this.xrTableCell11.StylePriority.UseTextAlignment = false;
         xrSummary1.FormatString = "{0:0.00 VND}";
         this.xrTableCell11.Summary = xrSummary1;
         this.xrTableCell11.Text = "xrTableCell11";
         this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrTableCell11.Weight = 0.99829627768477114D;
         //
         // xrTableCell30
         //
         this.xrTableCell30.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell30.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.Quantity", "{0:n0}")});
         this.xrTableCell30.Name = "xrTableCell30";
         this.xrTableCell30.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
         this.xrTableCell30.StylePriority.UseBorders = false;
         this.xrTableCell30.StylePriority.UsePadding = false;
         this.xrTableCell30.StylePriority.UseTextAlignment = false;
         this.xrTableCell30.Text = "xrTableCell30";
         this.xrTableCell30.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrTableCell30.Weight = 0.782191345631486D;
         //
         // xrTableCell31
         //
         this.xrTableCell31.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell31.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.Total", "{0:n0}")});
         this.xrTableCell31.Name = "xrTableCell31";
         this.xrTableCell31.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
         this.xrTableCell31.StylePriority.UseBorders = false;
         this.xrTableCell31.StylePriority.UsePadding = false;
         this.xrTableCell31.StylePriority.UseTextAlignment = false;
         this.xrTableCell31.Text = "xrTableCell31";
         this.xrTableCell31.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrTableCell31.Weight = 0.97617918250893376D;
         //
         // TopMargin
         //
         this.TopMargin.HeightF = 0F;
         this.TopMargin.Name = "TopMargin";
         this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
         this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
         //
         // BottomMargin
         //
         this.BottomMargin.HeightF = 14F;
         this.BottomMargin.Name = "BottomMargin";
         this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
         this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
         //
         // PageHeader
         //
         this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrTable4});
         this.PageHeader.HeightF = 25F;
         this.PageHeader.Name = "PageHeader";
         this.PageHeader.PrintOn = DevExpress.XtraReports.UI.PrintOnPages.NotWithReportHeader;
         //
         // xrTable4
         //
         this.xrTable4.BackColor = System.Drawing.Color.Snow;
         this.xrTable4.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrTable4.BorderWidth = 1F;
         this.xrTable4.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
         this.xrTable4.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
         this.xrTable4.Name = "xrTable4";
         this.xrTable4.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow4});
         this.xrTable4.SizeF = new System.Drawing.SizeF(748.96F, 25F);
         this.xrTable4.StylePriority.UseBackColor = false;
         this.xrTable4.StylePriority.UseBorders = false;
         this.xrTable4.StylePriority.UseBorderWidth = false;
         this.xrTable4.StylePriority.UseFont = false;
         this.xrTable4.StylePriority.UseTextAlignment = false;
         this.xrTable4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
         //
         // xrTableRow4
         //
         this.xrTableRow4.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell3,
         this.xrTableCell13,
         this.xrTableCell14,
         this.xrTableCell16,
         this.xrTableCell19});
         this.xrTableRow4.Name = "xrTableRow4";
         this.xrTableRow4.Weight = 1D;
         //
         // xrTableCell3
         //
         this.xrTableCell3.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell3.Name = "xrTableCell3";
         this.xrTableCell3.StylePriority.UseBorders = false;
         this.xrTableCell3.StylePriority.UseTextAlignment = false;
         this.xrTableCell3.Text = "STT";
         this.xrTableCell3.Weight = 0.36560020791428305D;
         //
         // xrTableCell13
         //
         this.xrTableCell13.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell13.Name = "xrTableCell13";
         this.xrTableCell13.StylePriority.UseBorders = false;
         this.xrTableCell13.Text = "Tên Hàng Hoá";
         this.xrTableCell13.Weight = 4.0641524463652621D;
         //
         // xrTableCell14
         //
         this.xrTableCell14.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell14.Name = "xrTableCell14";
         this.xrTableCell14.StylePriority.UseBorders = false;
         this.xrTableCell14.Text = "Đơn giá";
         this.xrTableCell14.Weight = 1.0010809425008556D;
         //
         // xrTableCell16
         //
         this.xrTableCell16.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell16.Multiline = true;
         this.xrTableCell16.Name = "xrTableCell16";
         this.xrTableCell16.StylePriority.UseBorders = false;
         this.xrTableCell16.StylePriority.UseTextAlignment = false;
         this.xrTableCell16.Text = "Số lượng\r\n";
         this.xrTableCell16.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
         this.xrTableCell16.Weight = 0.78437319053638133D;
         //
         // xrTableCell19
         //
         this.xrTableCell19.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell19.Name = "xrTableCell19";
         this.xrTableCell19.StylePriority.UseBorders = false;
         this.xrTableCell19.Text = "Thành tiền";
         this.xrTableCell19.Weight = 0.97890222513473879D;
         //
         // header
         //
         this.header.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
         this.header.Name = "header";
         this.header.SizeF = new System.Drawing.SizeF(750F, 29.625F);
         //
         // xrLabel10
         //
         this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.InvoiceNo", "Mã đơn : {0}")});
         this.xrLabel10.Font = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Italic);
         this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(1.04173F, 75.54163F);
         this.xrLabel10.Name = "xrLabel10";
         this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.xrLabel10.SizeF = new System.Drawing.SizeF(738.9999F, 26.41667F);
         this.xrLabel10.StylePriority.UseFont = false;
         this.xrLabel10.StylePriority.UseTextAlignment = false;
         this.xrLabel10.Text = "xrLabel10";
         this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
         //
         // xrLabel13
         //
         this.xrLabel13.Font = new System.Drawing.Font("Verdana", 18F, System.Drawing.FontStyle.Bold);
         this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(1.04173F, 32.74995F);
         this.xrLabel13.Name = "xrLabel13";
         this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.xrLabel13.SizeF = new System.Drawing.SizeF(748.9583F, 42.79168F);
         this.xrLabel13.StylePriority.UseFont = false;
         this.xrLabel13.StylePriority.UseTextAlignment = false;
         this.xrLabel13.Text = "HOÁ ĐƠN BÁN HÀNG";
         this.xrLabel13.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
         //
         // xrLabel17
         //
         this.xrLabel17.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
         this.xrLabel17.LocationFloat = new DevExpress.Utils.PointFloat(1.04173F, 173.75F);
         this.xrLabel17.Name = "xrLabel17";
         this.xrLabel17.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.xrLabel17.SizeF = new System.Drawing.SizeF(69.79163F, 16F);
         this.xrLabel17.StylePriority.UseFont = false;
         this.xrLabel17.Text = "Ghi chú: ";
         //
         // GroupHeader2
         //
         this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
         new DevExpress.XtraReports.UI.GroupField("TenKhachHang", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)});
         this.GroupHeader2.HeightF = 0F;
         this.GroupHeader2.Name = "GroupHeader2";
         //
         // xrTable7
         //
         this.xrTable7.Font = new System.Drawing.Font("Verdana", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
         this.xrTable7.LocationFloat = new DevExpress.Utils.PointFloat(7.249959F, 101.9583F);
         this.xrTable7.Name = "xrTable7";
         this.xrTable7.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 4, 4, 100F);
         this.xrTable7.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow8,
         this.xrTableRow9});
         this.xrTable7.SizeF = new System.Drawing.SizeF(741.7084F, 54.75F);
         this.xrTable7.StylePriority.UseFont = false;
         this.xrTable7.StylePriority.UsePadding = false;
         this.xrTable7.StylePriority.UseTextAlignment = false;
         this.xrTable7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
         //
         // xrTableRow8
         //
         this.xrTableRow8.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell6,
         this.xrTableCell23,
         this.xrTableCell20,
         this.xrTableCell18,
         this.xrTableCell25,
         this.xrTableCell24});
         this.xrTableRow8.Name = "xrTableRow8";
         this.xrTableRow8.Weight = 1D;
         //
         // xrTableCell6
         //
         this.xrTableCell6.Font = new System.Drawing.Font("Verdana", 10F, System.Drawing.FontStyle.Bold);
         this.xrTableCell6.Name = "xrTableCell6";
         this.xrTableCell6.StylePriority.UseFont = false;
         this.xrTableCell6.StylePriority.UseTextAlignment = false;
         this.xrTableCell6.Text = "Khách hàng: ";
         this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
         this.xrTableCell6.Weight = 1.0520836686849815D;
         //
         // xrTableCell23
         //
         this.xrTableCell23.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.Customer")});
         this.xrTableCell23.Font = new System.Drawing.Font("Verdana", 10F);
         this.xrTableCell23.Name = "xrTableCell23";
         this.xrTableCell23.StylePriority.UseFont = false;
         this.xrTableCell23.Text = "xrTableCell23";
         this.xrTableCell23.Weight = 2.5880258821406894D;
         //
         // xrTableCell20
         //
         this.xrTableCell20.Font = new System.Drawing.Font("Verdana", 10F, System.Drawing.FontStyle.Bold);
         this.xrTableCell20.Name = "xrTableCell20";
         this.xrTableCell20.StylePriority.UseFont = false;
         this.xrTableCell20.Text = "Ngày :";
         this.xrTableCell20.Weight = 0.5894757719221223D;
         //
         // xrTableCell18
         //
         this.xrTableCell18.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.CurrentDate", "{0:dd/MM/yyyy}")});
         this.xrTableCell18.Font = new System.Drawing.Font("Verdana", 10F);
         this.xrTableCell18.Name = "xrTableCell18";
         this.xrTableCell18.StylePriority.UseFont = false;
         this.xrTableCell18.Weight = 1.0417734816221154D;
         //
         // xrTableCell25
         //
         this.xrTableCell25.Font = new System.Drawing.Font("Verdana", 10F, System.Drawing.FontStyle.Bold);
         this.xrTableCell25.Name = "xrTableCell25";
         this.xrTableCell25.StylePriority.UseFont = false;
         this.xrTableCell25.StylePriority.UseTextAlignment = false;
         this.xrTableCell25.Text = "Điện thoại:";
         this.xrTableCell25.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
         this.xrTableCell25.Weight = 0.90503245148400147D;
         //
         // xrTableCell24
         //
         this.xrTableCell24.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.Phone")});
         this.xrTableCell24.Font = new System.Drawing.Font("Verdana", 10F);
         this.xrTableCell24.Name = "xrTableCell24";
         this.xrTableCell24.StylePriority.UseFont = false;
         this.xrTableCell24.Text = "xrTableCell24";
         this.xrTableCell24.Weight = 1.2406931607105067D;
         //
         // xrTableRow9
         //
         this.xrTableRow9.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell26,
         this.xrTableCell27});
         this.xrTableRow9.Name = "xrTableRow9";
         this.xrTableRow9.Weight = 1D;
         //
         // xrTableCell26
         //
         this.xrTableCell26.Font = new System.Drawing.Font("Verdana", 10F, System.Drawing.FontStyle.Bold);
         this.xrTableCell26.Name = "xrTableCell26";
         this.xrTableCell26.StylePriority.UseFont = false;
         this.xrTableCell26.Text = "Địa chỉ : ";
         this.xrTableCell26.Weight = 0.73958367866282337D;
         //
         // xrTableCell27
         //
         this.xrTableCell27.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.CustomerAddress")});
         this.xrTableCell27.Font = new System.Drawing.Font("Verdana", 10F);
         this.xrTableCell27.Multiline = true;
         this.xrTableCell27.Name = "xrTableCell27";
         this.xrTableCell27.StylePriority.UseFont = false;
         this.xrTableCell27.Weight = 6.6775007379015943D;
         //
         // xrTable1
         //
         this.xrTable1.BackColor = System.Drawing.Color.Snow;
         this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrTable1.BorderWidth = 1F;
         this.xrTable1.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
         this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 183.4722F);
         this.xrTable1.Name = "xrTable1";
         this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow1});
         this.xrTable1.SizeF = new System.Drawing.SizeF(748.9583F, 25F);
         this.xrTable1.StylePriority.UseBackColor = false;
         this.xrTable1.StylePriority.UseBorders = false;
         this.xrTable1.StylePriority.UseBorderWidth = false;
         this.xrTable1.StylePriority.UseFont = false;
         this.xrTable1.StylePriority.UseTextAlignment = false;
         this.xrTable1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
         //
         // xrTableRow1
         //
         this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell1,
         this.xrTableCell2,
         this.xrTableCell4,
         this.xrTableCell21,
         this.xrTableCell5});
         this.xrTableRow1.Name = "xrTableRow1";
         this.xrTableRow1.Weight = 1D;
         //
         // xrTableCell1
         //
         this.xrTableCell1.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell1.Name = "xrTableCell1";
         this.xrTableCell1.StylePriority.UseBorders = false;
         this.xrTableCell1.StylePriority.UseTextAlignment = false;
         this.xrTableCell1.Text = "STT";
         this.xrTableCell1.Weight = 0.36560020791428305D;
         //
         // xrTableCell2
         //
         this.xrTableCell2.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell2.Name = "xrTableCell2";
         this.xrTableCell2.StylePriority.UseBorders = false;
         this.xrTableCell2.Text = "Tên Hàng Hoá";
         this.xrTableCell2.Weight = 4.0641554790407382D;
         //
         // xrTableCell4
         //
         this.xrTableCell4.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell4.Name = "xrTableCell4";
         this.xrTableCell4.StylePriority.UseBorders = false;
         this.xrTableCell4.Text = "Đơn giá";
         this.xrTableCell4.Weight = 1.0011300565736081D;
         //
         // xrTableCell21
         //
         this.xrTableCell21.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell21.Multiline = true;
         this.xrTableCell21.Name = "xrTableCell21";
         this.xrTableCell21.StylePriority.UseBorders = false;
         this.xrTableCell21.StylePriority.UseTextAlignment = false;
         this.xrTableCell21.Text = "Số lượng\r\n";
         this.xrTableCell21.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
         this.xrTableCell21.Weight = 0.78432104378815293D;
         //
         // xrTableCell5
         //
         this.xrTableCell5.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTableCell5.Name = "xrTableCell5";
         this.xrTableCell5.StylePriority.UseBorders = false;
         this.xrTableCell5.Text = "Thành tiền";
         this.xrTableCell5.Weight = 0.97895618222477876D;
         //
         // formattingRule1
         //
         this.formattingRule1.DataMember = null;
         //
         //
         //
         this.formattingRule1.Formatting.BackColor = System.Drawing.Color.Gray;
         this.formattingRule1.Formatting.Padding = new DevExpress.XtraPrinting.PaddingInfo(50, 50, 50, 50, 100F);
         this.formattingRule1.Name = "formattingRule1";
         //
         // dsBaoCaoBanHang1
         //
         this.dsBaoCaoBanHang1.DataSetName = "dsBaoCaoBanHang";
         this.dsBaoCaoBanHang1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
         //
         // GroupFooter1
         //
         this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrLabel4,
         this.xrTable3,
         this.xrTable6,
         this.xrLabel17});
         this.GroupFooter1.HeightF = 192.4583F;
         this.GroupFooter1.Name = "GroupFooter1";
         //
         // xrLabel4
         //
         this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.Notes")});
         this.xrLabel4.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Italic);
         this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(70.83334F, 173.75F);
         this.xrLabel4.Name = "xrLabel4";
         this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.xrLabel4.SizeF = new System.Drawing.SizeF(329.0094F, 16F);
         this.xrLabel4.StylePriority.UseFont = false;
         //
         // xrTable3
         //
         this.xrTable3.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
         this.xrTable3.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
         this.xrTable3.BorderWidth = 1F;
         this.xrTable3.Font = new System.Drawing.Font("Verdana", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
         this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
         this.xrTable3.Name = "xrTable3";
         this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow3,
         this.xrTableRow5,
         this.xrTableRow7,
         this.xrTableRow10,
         this.xrTableRow11});
         this.xrTable3.SizeF = new System.Drawing.SizeF(749F, 124.1666F);
         this.xrTable3.StylePriority.UseBorderDashStyle = false;
         this.xrTable3.StylePriority.UseBorders = false;
         this.xrTable3.StylePriority.UseBorderWidth = false;
         this.xrTable3.StylePriority.UseFont = false;
         this.xrTable3.StylePriority.UseTextAlignment = false;
         this.xrTable3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
         //
         // xrTableRow3
         //
         this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell12,
         this.xrTableCell10,
         this.xrSum});
         this.xrTableRow3.Name = "xrTableRow3";
         this.xrTableRow3.Weight = 1D;
         //
         // xrTableCell12
         //
         this.xrTableCell12.Borders = DevExpress.XtraPrinting.BorderSide.None;
         this.xrTableCell12.Name = "xrTableCell12";
         this.xrTableCell12.StylePriority.UseBorders = false;
         this.xrTableCell12.Weight = 4.6116583633422845D;
         //
         // xrTableCell10
         //
         this.xrTableCell10.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrTableCell10.Font = new System.Drawing.Font("Arial", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.xrTableCell10.Name = "xrTableCell10";
         this.xrTableCell10.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
         this.xrTableCell10.StylePriority.UseBorders = false;
         this.xrTableCell10.StylePriority.UseFont = false;
         this.xrTableCell10.StylePriority.UsePadding = false;
         this.xrTableCell10.StylePriority.UseTextAlignment = false;
         this.xrTableCell10.Text = "Tổng cộng";
         this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrTableCell10.Weight = 1.4052649307250975D;
         //
         // xrSum
         //
         this.xrSum.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrSum.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.FinalTotal", "{0:n0}")});
         this.xrSum.Font = new System.Drawing.Font("Verdana", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.xrSum.Name = "xrSum";
         this.xrSum.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 8, 0, 0, 100F);
         this.xrSum.StylePriority.UseBorders = false;
         this.xrSum.StylePriority.UseFont = false;
         this.xrSum.StylePriority.UsePadding = false;
         this.xrSum.StylePriority.UseTextAlignment = false;
         xrSummary2.FormatString = "{0:n0}";
         this.xrSum.Summary = xrSummary2;
         this.xrSum.Text = "xrSum";
         this.xrSum.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrSum.Weight = 1.4730767059326171D;
         //
         // xrTableRow5
         //
         this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell22,
         this.xrTableCell28,
         this.xrTableCell29});
         this.xrTableRow5.Name = "xrTableRow5";
         this.xrTableRow5.Weight = 1D;
         //
         // xrTableCell22
         //
         this.xrTableCell22.Borders = DevExpress.XtraPrinting.BorderSide.None;
         this.xrTableCell22.Name = "xrTableCell22";
         this.xrTableCell22.StylePriority.UseBorders = false;
         this.xrTableCell22.Weight = 4.6116583633422845D;
         //
         // xrTableCell28
         //
         this.xrTableCell28.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrTableCell28.Font = new System.Drawing.Font("Arial", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.xrTableCell28.Name = "xrTableCell28";
         this.xrTableCell28.StylePriority.UseBorders = false;
         this.xrTableCell28.StylePriority.UseFont = false;
         this.xrTableCell28.StylePriority.UseTextAlignment = false;
         this.xrTableCell28.Text = "Chiết khấu 1";
         this.xrTableCell28.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrTableCell28.Weight = 1.4052649307250975D;
         //
         // xrTableCell29
         //
         this.xrTableCell29.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrTableCell29.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.Discount", "{0:n0}")});
         this.xrTableCell29.Font = new System.Drawing.Font("Verdana", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.xrTableCell29.Name = "xrTableCell29";
         this.xrTableCell29.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 8, 0, 0, 100F);
         this.xrTableCell29.StylePriority.UseBorders = false;
         this.xrTableCell29.StylePriority.UseFont = false;
         this.xrTableCell29.StylePriority.UsePadding = false;
         this.xrTableCell29.StylePriority.UseTextAlignment = false;
         this.xrTableCell29.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrTableCell29.Weight = 1.4730767059326171D;
         //
         // xrTableRow7
         //
         this.xrTableRow7.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell32,
         this.xrTableCell33,
         this.xrTableCell34});
         this.xrTableRow7.Name = "xrTableRow7";
         this.xrTableRow7.Weight = 1D;
         //
         // xrTableCell32
         //
         this.xrTableCell32.Borders = DevExpress.XtraPrinting.BorderSide.None;
         this.xrTableCell32.Name = "xrTableCell32";
         this.xrTableCell32.StylePriority.UseBorders = false;
         this.xrTableCell32.Weight = 4.6116583633422845D;
         //
         // xrTableCell33
         //
         this.xrTableCell33.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrTableCell33.Font = new System.Drawing.Font("Arial", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.xrTableCell33.Name = "xrTableCell33";
         this.xrTableCell33.StylePriority.UseBorders = false;
         this.xrTableCell33.StylePriority.UseFont = false;
         this.xrTableCell33.StylePriority.UseTextAlignment = false;
         this.xrTableCell33.Text = "Chiết khấu 2";
         this.xrTableCell33.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrTableCell33.Weight = 1.4052649307250975D;
         //
         // xrTableRow10
         //
         this.xrTableRow10.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell15,
         this.sdfsdfsdf,
         this.xrDiscount01});
         this.xrTableRow10.Name = "xrTableRow10";
         this.xrTableRow10.Weight = 1D;
         //
         // xrTableCell15
         //
         this.xrTableCell15.Borders = DevExpress.XtraPrinting.BorderSide.None;
         this.xrTableCell15.Name = "xrTableCell15";
         this.xrTableCell15.StylePriority.UseBorders = false;
         this.xrTableCell15.Weight = 4.6116586875915528D;
         //
         // sdfsdfsdf
         //
         this.sdfsdfsdf.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.sdfsdfsdf.Font = new System.Drawing.Font("Arial", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.sdfsdfsdf.Multiline = true;
         this.sdfsdfsdf.Name = "sdfsdfsdf";
         this.sdfsdfsdf.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
         this.sdfsdfsdf.StylePriority.UseBorders = false;
         this.sdfsdfsdf.StylePriority.UseFont = false;
         this.sdfsdfsdf.StylePriority.UsePadding = false;
         this.sdfsdfsdf.StylePriority.UseTextAlignment = false;
         this.sdfsdfsdf.Text = "Phí giao hàng\r\n";
         this.sdfsdfsdf.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.sdfsdfsdf.Weight = 1.4052652549743652D;
         //
         // xrDiscount01
         //
         this.xrDiscount01.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrDiscount01.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.ShipFees", "{0:n0}")});
         this.xrDiscount01.Font = new System.Drawing.Font("Verdana", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.xrDiscount01.Name = "xrDiscount01";
         this.xrDiscount01.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 8, 0, 0, 100F);
         this.xrDiscount01.StylePriority.UseBorders = false;
         this.xrDiscount01.StylePriority.UseFont = false;
         this.xrDiscount01.StylePriority.UsePadding = false;
         this.xrDiscount01.StylePriority.UseTextAlignment = false;
         this.xrDiscount01.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrDiscount01.Weight = 1.473076057434082D;
         //
         // xrTableRow11
         //
         this.xrTableRow11.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell17,
         this.xrTableCell48,
         this.thanhtienafterdis01});
         this.xrTableRow11.Name = "xrTableRow11";
         this.xrTableRow11.Weight = 1D;
         //
         // xrTableCell17
         //
         this.xrTableCell17.Borders = DevExpress.XtraPrinting.BorderSide.None;
         this.xrTableCell17.Name = "xrTableCell17";
         this.xrTableCell17.StylePriority.UseBorders = false;
         this.xrTableCell17.Weight = 4.6116583824157713D;
         //
         // xrTableCell48
         //
         this.xrTableCell48.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrTableCell48.Font = new System.Drawing.Font("Arial", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.xrTableCell48.Name = "xrTableCell48";
         this.xrTableCell48.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
         this.xrTableCell48.StylePriority.UseBorders = false;
         this.xrTableCell48.StylePriority.UseFont = false;
         this.xrTableCell48.StylePriority.UsePadding = false;
         this.xrTableCell48.StylePriority.UseTextAlignment = false;
         this.xrTableCell48.Text = "Thành tiền";
         this.xrTableCell48.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrTableCell48.Weight = 1.4052649497985839D;
         //
         // thanhtienafterdis01
         //
         this.thanhtienafterdis01.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.thanhtienafterdis01.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.Payment", "{0:n0}")});
         this.thanhtienafterdis01.Font = new System.Drawing.Font("Verdana", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.thanhtienafterdis01.Name = "thanhtienafterdis01";
         this.thanhtienafterdis01.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 8, 0, 0, 100F);
         this.thanhtienafterdis01.StylePriority.UseBorders = false;
         this.thanhtienafterdis01.StylePriority.UseFont = false;
         this.thanhtienafterdis01.StylePriority.UsePadding = false;
         this.thanhtienafterdis01.StylePriority.UseTextAlignment = false;
         this.thanhtienafterdis01.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.thanhtienafterdis01.Weight = 1.4730766677856444D;
         this.thanhtienafterdis01.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.thanhtienafterdis01_BeforePrint);
         //
         // xrTable6
         //
         this.xrTable6.Borders = DevExpress.XtraPrinting.BorderSide.None;
         this.xrTable6.Font = new System.Drawing.Font("Times New Roman", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
         this.xrTable6.LocationFloat = new DevExpress.Utils.PointFloat(0F, 137.6666F);
         this.xrTable6.Name = "xrTable6";
         this.xrTable6.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow6});
         this.xrTable6.SizeF = new System.Drawing.SizeF(750F, 20F);
         this.xrTable6.StylePriority.UseBorders = false;
         this.xrTable6.StylePriority.UseFont = false;
         this.xrTable6.StylePriority.UseTextAlignment = false;
         this.xrTable6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
         //
         // xrTableRow6
         //
         this.xrTableRow6.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell8,
         this.xrTableCell9});
         this.xrTableRow6.Name = "xrTableRow6";
         this.xrTableRow6.Weight = 1D;
         //
         // xrTableCell8
         //
         this.xrTableCell8.Font = new System.Drawing.Font("Arial", 12F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.xrTableCell8.Name = "xrTableCell8";
         this.xrTableCell8.StylePriority.UseFont = false;
         this.xrTableCell8.StylePriority.UseTextAlignment = false;
         this.xrTableCell8.Text = "Tổng tiền (bằng chữ):";
         this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
         this.xrTableCell8.Weight = 1.4999997049967446D;
         //
         // xrTableCell9
         //
         this.xrTableCell9.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.lbchu});
         this.xrTableCell9.Font = new System.Drawing.Font("Times New Roman", 9F);
         this.xrTableCell9.Name = "xrTableCell9";
         this.xrTableCell9.StylePriority.UseFont = false;
         this.xrTableCell9.StylePriority.UseTextAlignment = false;
         xrSummary3.FormatString = "{0:0.00 VND}";
         this.xrTableCell9.Summary = xrSummary3;
         this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
         this.xrTableCell9.Weight = 5.0000002950032547D;
         //
         // lbchu
         //
         this.lbchu.Font = new System.Drawing.Font("Arial", 12F);
         this.lbchu.LocationFloat = new DevExpress.Utils.PointFloat(2.499835F, 0F);
         this.lbchu.Name = "lbchu";
         this.lbchu.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.lbchu.SizeF = new System.Drawing.SizeF(573.4233F, 20F);
         this.lbchu.StylePriority.UseFont = false;
         this.lbchu.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.lbchu_BeforePrint);
         //
         // xrLine1
         //
         this.xrLine1.BorderWidth = 5F;
         this.xrLine1.LineStyle = System.Drawing.Drawing2D.DashStyle.Dash;
         this.xrLine1.LineWidth = 2;
         this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 3.000005F);
         this.xrLine1.Name = "xrLine1";
         this.xrLine1.SizeF = new System.Drawing.SizeF(750.0001F, 11.54169F);
         this.xrLine1.StylePriority.UseBorderWidth = false;
         //
         // xrPictureBox1
         //
         this.xrPictureBox1.ImageUrl = "~\\img\\logohdk.png";
         this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(239.5835F, 24.54169F);
         this.xrPictureBox1.Name = "xrPictureBox1";
         this.xrPictureBox1.SizeF = new System.Drawing.SizeF(171.875F, 61.49998F);
         this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
         //
         // xrLabel5
         //
         this.xrLabel5.Font = new System.Drawing.Font("Verdana", 10F, System.Drawing.FontStyle.Italic);
         this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(239.5835F, 115.2917F);
         this.xrLabel5.Name = "xrLabel5";
         this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.xrLabel5.SizeF = new System.Drawing.SizeF(480.514F, 31.33333F);
         this.xrLabel5.StylePriority.UseFont = false;
         this.xrLabel5.StylePriority.UseTextAlignment = false;
         this.xrLabel5.Text = "Mã giảm giá bên có thời hạn từ 01-05-2015 đến ngày 30-05-2015.";
         this.xrLabel5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
         //
         // xrLabel3
         //
         this.xrLabel3.Font = new System.Drawing.Font("Verdana", 10F);
         this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(239.5835F, 86.04166F);
         this.xrLabel3.Name = "xrLabel3";
         this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.xrLabel3.SizeF = new System.Drawing.SizeF(480.514F, 18.83333F);
         this.xrLabel3.StylePriority.UseFont = false;
         this.xrLabel3.StylePriority.UseTextAlignment = false;
         this.xrLabel3.Text = "TẶNG BẠN MÃ GIẢM GIÁ 10% CHO LẦN MUA HÀNG TIẾP THEO";
         this.xrLabel3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
         //
         // xrLabel1
         //
         this.xrLabel1.Font = new System.Drawing.Font("Times New Roman", 22F, System.Drawing.FontStyle.Bold);
         this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(419.7918F, 36.20841F);
         this.xrLabel1.Name = "xrLabel1";
         this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.xrLabel1.SizeF = new System.Drawing.SizeF(240.6251F, 36.37494F);
         this.xrLabel1.StylePriority.UseFont = false;
         this.xrLabel1.StylePriority.UseTextAlignment = false;
         this.xrLabel1.Text = "CẢM ƠN BẠN !";
         this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
         //
         // xrBarCode1
         //
         this.xrBarCode1.AutoModule = true;
         this.xrBarCode1.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.DashDotDot;
         this.xrBarCode1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
         | DevExpress.XtraPrinting.BorderSide.Right)
         | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrBarCode1.Font = new System.Drawing.Font("Microsoft YaHei", 16F, System.Drawing.FontStyle.Bold);
         this.xrBarCode1.ForeColor = System.Drawing.SystemColors.ActiveCaptionText;
         this.xrBarCode1.FormattingRules.Add(this.formattingRule1);
         this.xrBarCode1.LocationFloat = new DevExpress.Utils.PointFloat(23.95846F, 24.54169F);
         this.xrBarCode1.Module = 8F;
         this.xrBarCode1.Name = "xrBarCode1";
         this.xrBarCode1.Padding = new DevExpress.XtraPrinting.PaddingInfo(20, 10, 20, 10, 100F);
         this.xrBarCode1.SizeF = new System.Drawing.SizeF(196.8751F, 215.7501F);
         this.xrBarCode1.StylePriority.UseBorderDashStyle = false;
         this.xrBarCode1.StylePriority.UseBorders = false;
         this.xrBarCode1.StylePriority.UseFont = false;
         this.xrBarCode1.StylePriority.UseForeColor = false;
         this.xrBarCode1.StylePriority.UsePadding = false;
         this.xrBarCode1.StylePriority.UseTextAlignment = false;
         qrCodeGenerator1.ErrorCorrectionLevel = DevExpress.XtraPrinting.BarCode.QRCodeErrorCorrectionLevel.M;
         qrCodeGenerator1.Version = DevExpress.XtraPrinting.BarCode.QRCodeVersion.Version1;
         this.xrBarCode1.Symbology = qrCodeGenerator1;
         this.xrBarCode1.Text = "GGHKBD";
         this.xrBarCode1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
         //
         // pTongTien
         //
         this.pTongTien.Expression = "[TongTien]+[Thue]+[ShipFees]-[GiamGia]";
         this.pTongTien.Name = "pTongTien";
         //
         // ReportHeader
         //
         this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.header,
         this.xrLabel10,
         this.xrLabel13,
         this.xrTable7,
         this.xrTable1});
         this.ReportHeader.HeightF = 208.4722F;
         this.ReportHeader.Name = "ReportHeader";
         //
         // sale_InvoiceToPrintTableAdapter1
         //
         this.sale_InvoiceToPrintTableAdapter1.ClearBeforeFill = true;
         //
         // Thanhtien
         //
         this.Thanhtien.Expression = "[sale_InvoiceToPrint.FinalTotal] - [sale_InvoiceToPrint.ShipFees]";
         this.Thanhtien.Name = "Thanhtien";
         //
         // percentDiscount1
         //
         this.percentDiscount1.Expression = "[sale_InvoiceToPrint.ShipFees]/[sale_InvoiceToPrint.FinalTotal]*100";
         this.percentDiscount1.Name = "percentDiscount1";
         //
         // PageFooter
         //
         this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrLabel11,
         this.xrPictureBox4,
         this.xrLabel2,
         this.xrPictureBox5,
         this.xrLine1,
         this.xrBarCode1,
         this.xrPictureBox1,
         this.xrLabel1,
         this.xrLabel3,
         this.xrLabel5});
         this.PageFooter.HeightF = 245.8333F;
         this.PageFooter.Name = "PageFooter";
         //
         // xrLabel11
         //
         this.xrLabel11.Font = new System.Drawing.Font("Tahoma", 11F, System.Drawing.FontStyle.Underline);
         this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(279.4574F, 182.3125F);
         this.xrLabel11.Name = "xrLabel11";
         this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.xrLabel11.SizeF = new System.Drawing.SizeF(181.7084F, 23F);
         this.xrLabel11.StylePriority.UseFont = false;
         this.xrLabel11.StylePriority.UseTextAlignment = false;
         this.xrLabel11.Text = "www.hongdiepkhang.com";
         this.xrLabel11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
         //
         // xrPictureBox4
         //
         this.xrPictureBox4.ImageUrl = "~\\images\\icon-webapp.png";
         this.xrPictureBox4.LocationFloat = new DevExpress.Utils.PointFloat(254.4574F, 181.3125F);
         this.xrPictureBox4.Name = "xrPictureBox4";
         this.xrPictureBox4.SizeF = new System.Drawing.SizeF(24F, 24F);
         this.xrPictureBox4.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
         //
         // xrLabel2
         //
         this.xrLabel2.Font = new System.Drawing.Font("Arial", 11F, System.Drawing.FontStyle.Underline);
         this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(495.0408F, 182.3125F);
         this.xrLabel2.Name = "xrLabel2";
         this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
         this.xrLabel2.SizeF = new System.Drawing.SizeF(211.515F, 23F);
         this.xrLabel2.StylePriority.UseFont = false;
         this.xrLabel2.StylePriority.UseTextAlignment = false;
         this.xrLabel2.Text = "facebook.com/hongdiepkhang";
         this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
         //
         // xrPictureBox5
         //
         this.xrPictureBox5.ImageUrl = "~\\images\\circle-social_facebook_outline_stroke-128.png";
         this.xrPictureBox5.LocationFloat = new DevExpress.Utils.PointFloat(468.0409F, 180.3125F);
         this.xrPictureBox5.Name = "xrPictureBox5";
         this.xrPictureBox5.SizeF = new System.Drawing.SizeF(24F, 24F);
         this.xrPictureBox5.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
         //
         // xrTableCell34
         //
         this.xrTableCell34.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom)));
         this.xrTableCell34.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.Discount2", "{0:n0}")});
         this.xrTableCell34.Font = new System.Drawing.Font("Verdana", 10F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
         this.xrTableCell34.Name = "xrTableCell34";
         this.xrTableCell34.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 8, 0, 0, 100F);
         this.xrTableCell34.StylePriority.UseBorders = false;
         this.xrTableCell34.StylePriority.UseFont = false;
         this.xrTableCell34.StylePriority.UsePadding = false;
         this.xrTableCell34.StylePriority.UseTextAlignment = false;
         this.xrTableCell34.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
         this.xrTableCell34.Weight = 1.4730767059326171D;
         //
         // rptBanHang
         //
         this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
         this.Detail,
         this.TopMargin,
         this.BottomMargin,
         this.PageHeader,
         this.GroupHeader2,
         this.GroupFooter1,
         this.ReportHeader,
         this.PageFooter});
         this.CalculatedFields.AddRange(new DevExpress.XtraReports.UI.CalculatedField[] {
         this.pTongTien,
         this.Thanhtien,
         this.percentDiscount1});
         this.DataAdapter = this.sale_InvoiceToPrintTableAdapter1;
         this.DataMember = "sale_InvoiceToPrint";
         this.DataSource = this.dsBaoCaoBanHang1;
         this.FormattingRuleSheet.AddRange(new DevExpress.XtraReports.UI.FormattingRule[] {
         this.formattingRule1});
         this.Margins = new System.Drawing.Printing.Margins(49, 51, 0, 14);
         this.Version = "14.1";
         ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).EndInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable7)).EndInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
         ((System.ComponentModel.ISupportInitialize)(this.dsBaoCaoBanHang1)).EndInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit();
         ((System.ComponentModel.ISupportInitialize)(this.xrTable6)).EndInit();
         ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
        public void GivenTheDetailReportBandContainsASubreportInItsHeaderBand(string location)
        {
            Band band;
            switch (location.ToUpper())
            {
                case "HEADER":  
                    band = new ReportHeaderBand();
                    break;
                case "FOOTER":
                    band = new ReportFooterBand();
                    break;
                case "DETAIL":
                    band = new DetailBand();
                    break;
                default:
                    throw new NotImplementedException();
            }

            
            _xrSubreportContainer = new XRSubreport();
            band.Controls.Add(_xrSubreportContainer);
            _detailReport.Bands.Add(band);
        }
        private List<XRControl> VisitSubreportPlaceholderChildren(XRSubreport placeholder)
        {
/*        // Subreport
        XtraReport subreport = placeholder.ReportSource;
        Visit(subreport);

        // Return empty collection
        return new List<XRControl>();*/
            return new List<XRControl>();
        }
Example #41
0
    private MemoryStream PrintWh_doc(string refN, string refType, string userId)
    {
        System.IO.MemoryStream str = new MemoryStream();
        string     user            = HttpContext.Current.User.Identity.Name;
        XtraReport rpt             = new XtraReport();
        string     path            = SafeValue.SafeString(ConnectSql.ExecuteScalar(string.Format("select path from sys_rpt where name='{0}'", refType)));

        if (path.Length == 0)
        {
            return(str);
        }
        //rpt.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\po.repx"));
        rpt.LoadLayout(Server.MapPath(path));

        string    strsql  = string.Format(@"exec proc_PrintWh_Po '{0}','{1}','{2}','{3}','{4}'", refN, "", refType, userId, "");
        DataSet   ds_temp = ConnectSql.GetDataSet(strsql);
        DataTable Mast    = ds_temp.Tables[0].Copy();

        Mast.TableName = "Mast";
        DataTable Detail = ds_temp.Tables[1].Copy();

        Detail.TableName = "Detail";
        DataTable Detail2 = new DataTable();

        if (ds_temp.Tables.Count > 2)
        {
            Detail2           = ds_temp.Tables[2].Copy();
            Detail2.TableName = "Detail";
        }



        if (Detail.Rows.Count > 0)
        {
            DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Inv = rpt.Report.Bands["GroupFooter_Wine"] as DevExpress.XtraReports.UI.GroupFooterBand;
            DevExpress.XtraReports.UI.XRSubreport     subReport_Inv   = new XRSubreport();
            subReport_Inv.Name = "GroupFooter_Wine1";
            groupFooter_Inv.Controls.Add(subReport_Inv);
            XtraReport rpt_Inv = new XtraReport();
            if (refType == "wh_putaway" || refType == "wh_picking")
            {
                rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\Picking_1.repx"));
            }
            else if (refType == "wh_doout")
            {
                rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\do_1.repx"));
            }
            else
            {
                rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice_1.repx"));
            }
            subReport_Inv.ReportSource = rpt_Inv;
            rpt_Inv.DataSource         = Detail;
        }
        if (Detail2.Rows.Count > 0)
        {
            DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Inv = rpt.Report.Bands["GroupFooter_Other"] as DevExpress.XtraReports.UI.GroupFooterBand;
            DevExpress.XtraReports.UI.XRSubreport     subReport_Inv   = new XRSubreport();
            subReport_Inv.Name = "GroupFooter_Other1";
            groupFooter_Inv.Controls.Add(subReport_Inv);
            XtraReport rpt_Inv = new XtraReport();
            if (refType == "wh_putaway" || refType == "wh_picking")
            {
                rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\Picking_2.repx"));
            }
            else if (refType == "wh_doout")
            {
                rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\do_2.repx"));
            }
            else
            {
                rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice_2.repx"));
            }
            subReport_Inv.ReportSource = rpt_Inv;
            rpt_Inv.DataSource         = Detail2;
        }

        rpt.DataSource = Mast;
        rpt.ExportToPdf(str);
        return(str);
    }
 public void GivenReportAExistsWithSubreportReportB()
 {
     _reportA = new XtraReportWithSubReportInDetailReport();
     var band = (DetailReportBand)_reportA.Bands[BandKind.DetailReport];
     _containerwithReportBinside = (XRSubreport)band.Bands[BandKind.Detail].Controls[0];
 }
Example #43
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     DevExpress.DataAccess.Sql.StoredProcQuery      storedProcQuery1 = new DevExpress.DataAccess.Sql.StoredProcQuery();
     System.ComponentModel.ComponentResourceManager resources        = new System.ComponentModel.ComponentResourceManager(typeof(EmployeeDocument));
     DevExpress.DataAccess.Sql.StoredProcQuery      storedProcQuery2 = new DevExpress.DataAccess.Sql.StoredProcQuery();
     DevExpress.DataAccess.Sql.QueryParameter       queryParameter1  = new DevExpress.DataAccess.Sql.QueryParameter();
     DevExpress.DataAccess.Sql.StoredProcQuery      storedProcQuery3 = new DevExpress.DataAccess.Sql.StoredProcQuery();
     this.Detail           = new DevExpress.XtraReports.UI.DetailBand();
     this.TopMargin        = new DevExpress.XtraReports.UI.TopMarginBand();
     this.BottomMargin     = new DevExpress.XtraReports.UI.BottomMarginBand();
     this.ReportHeader     = new DevExpress.XtraReports.UI.ReportHeaderBand();
     this.xrPictureBox8    = new DevExpress.XtraReports.UI.XRPictureBox();
     this.xrLabel1         = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel5         = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel4         = new DevExpress.XtraReports.UI.XRLabel();
     this.PageFooter       = new DevExpress.XtraReports.UI.PageFooterBand();
     this.xrPageInfo3      = new DevExpress.XtraReports.UI.XRPageInfo();
     this.xrPageInfo2      = new DevExpress.XtraReports.UI.XRPageInfo();
     this.Odding           = new DevExpress.XtraReports.UI.XRControlStyle();
     this.GroupCaption3    = new DevExpress.XtraReports.UI.XRControlStyle();
     this.xrControlStyle1  = new DevExpress.XtraReports.UI.XRControlStyle();
     this.Title            = new DevExpress.XtraReports.UI.XRControlStyle();
     this.xrControlStyle4  = new DevExpress.XtraReports.UI.XRControlStyle();
     this.xrControlStyle2  = new DevExpress.XtraReports.UI.XRControlStyle();
     this.tbl_header_style = new DevExpress.XtraReports.UI.XRControlStyle();
     this.tbl_even_detail  = new DevExpress.XtraReports.UI.XRControlStyle();
     this.tbl_odd_detail   = new DevExpress.XtraReports.UI.XRControlStyle();
     this.sqlDataSource1   = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
     this.xrTable2         = new DevExpress.XtraReports.UI.XRTable();
     this.xrTableRow2      = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrTableCell6     = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell11    = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell7     = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell8     = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell9     = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell10    = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTable1         = new DevExpress.XtraReports.UI.XRTable();
     this.xrTableRow1      = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrTableCell1     = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell2     = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell3     = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell4     = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell5     = new DevExpress.XtraReports.UI.XRTableCell();
     this.HasExDate        = new DevExpress.XtraReports.UI.CalculatedField();
     this.sqlDataSource2   = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
     this.GroupHeader1     = new DevExpress.XtraReports.UI.GroupHeaderBand();
     this.xrLabel3         = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel2         = new DevExpress.XtraReports.UI.XRLabel();
     this.GroupHeader2     = new DevExpress.XtraReports.UI.GroupHeaderBand();
     this.GroupFooter1     = new DevExpress.XtraReports.UI.GroupFooterBand();
     this.GroupHeader3     = new DevExpress.XtraReports.UI.GroupHeaderBand();
     this.sqlDataSource3   = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
     this.xrSubreport1     = new DevExpress.XtraReports.UI.XRSubreport();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // Detail
     //
     this.Detail.Dpi           = 254F;
     this.Detail.HeightF       = 1.763889F;
     this.Detail.Name          = "Detail";
     this.Detail.Padding       = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
     this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
     //
     // TopMargin
     //
     this.TopMargin.Dpi           = 254F;
     this.TopMargin.HeightF       = 14F;
     this.TopMargin.Name          = "TopMargin";
     this.TopMargin.Padding       = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
     this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
     //
     // BottomMargin
     //
     this.BottomMargin.Dpi           = 254F;
     this.BottomMargin.HeightF       = 18F;
     this.BottomMargin.Name          = "BottomMargin";
     this.BottomMargin.Padding       = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
     this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
     //
     // ReportHeader
     //
     this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrPictureBox8,
         this.xrLabel1,
         this.xrLabel5,
         this.xrLabel4
     });
     this.ReportHeader.Dpi     = 254F;
     this.ReportHeader.HeightF = 305F;
     this.ReportHeader.Name    = "ReportHeader";
     //
     // xrPictureBox8
     //
     this.xrPictureBox8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Image", null, "GetCompanyLogo.file_stream")
     });
     this.xrPictureBox8.Dpi           = 254F;
     this.xrPictureBox8.LocationFloat = new DevExpress.Utils.PointFloat(25.4F, 0F);
     this.xrPictureBox8.Name          = "xrPictureBox8";
     this.xrPictureBox8.SizeF         = new System.Drawing.SizeF(363.3611F, 284.9463F);
     this.xrPictureBox8.Sizing        = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
     //
     // xrLabel1
     //
     this.xrLabel1.BorderColor   = System.Drawing.Color.Transparent;
     this.xrLabel1.Dpi           = 254F;
     this.xrLabel1.Font          = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrLabel1.ForeColor     = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(128)))));
     this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(2339.26F, 21.16667F);
     this.xrLabel1.Name          = "xrLabel1";
     this.xrLabel1.Padding       = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F);
     this.xrLabel1.SizeF         = new System.Drawing.SizeF(502.6323F, 91.66478F);
     this.xrLabel1.StylePriority.UseBorderColor   = false;
     this.xrLabel1.StylePriority.UseFont          = false;
     this.xrLabel1.StylePriority.UseForeColor     = false;
     this.xrLabel1.StylePriority.UseTextAlignment = false;
     this.xrLabel1.Text          = "شركة العين للتوزيع";
     this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     //
     // xrLabel5
     //
     this.xrLabel5.BorderColor   = System.Drawing.Color.Transparent;
     this.xrLabel5.Dpi           = 254F;
     this.xrLabel5.Font          = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrLabel5.ForeColor     = System.Drawing.Color.FromArgb(((int)(((byte)(169)))), ((int)(((byte)(169)))), ((int)(((byte)(169)))));
     this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(2421.503F, 112.8315F);
     this.xrLabel5.Multiline     = true;
     this.xrLabel5.Name          = "xrLabel5";
     this.xrLabel5.Padding       = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F);
     this.xrLabel5.SizeF         = new System.Drawing.SizeF(448.6116F, 70.63511F);
     this.xrLabel5.StylePriority.UseBorderColor   = false;
     this.xrLabel5.StylePriority.UseFont          = false;
     this.xrLabel5.StylePriority.UseForeColor     = false;
     this.xrLabel5.StylePriority.UseTextAlignment = false;
     this.xrLabel5.Text          = "منطقة العين - الدمام السعودية";
     this.xrLabel5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // xrLabel4
     //
     this.xrLabel4.BorderColor   = System.Drawing.Color.Transparent;
     this.xrLabel4.Dpi           = 254F;
     this.xrLabel4.Font          = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrLabel4.ForeColor     = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(128)))));
     this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(1180.839F, 143.5808F);
     this.xrLabel4.Name          = "xrLabel4";
     this.xrLabel4.Padding       = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F);
     this.xrLabel4.SizeF         = new System.Drawing.SizeF(1178.278F, 161.0023F);
     this.xrLabel4.StylePriority.UseBorderColor   = false;
     this.xrLabel4.StylePriority.UseFont          = false;
     this.xrLabel4.StylePriority.UseForeColor     = false;
     this.xrLabel4.StylePriority.UseTextAlignment = false;
     this.xrLabel4.Text          = "بيانات مرفقات الموظفين";
     this.xrLabel4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // PageFooter
     //
     this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrPageInfo3,
         this.xrPageInfo2
     });
     this.PageFooter.Dpi     = 254F;
     this.PageFooter.HeightF = 73.2367F;
     this.PageFooter.Name    = "PageFooter";
     //
     // xrPageInfo3
     //
     this.xrPageInfo3.Dpi                            = 254F;
     this.xrPageInfo3.Font                           = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrPageInfo3.Format                         = "صفحة {0} من {1}";
     this.xrPageInfo3.LocationFloat                  = new DevExpress.Utils.PointFloat(2687.375F, 0F);
     this.xrPageInfo3.Name                           = "xrPageInfo3";
     this.xrPageInfo3.Padding                        = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F);
     this.xrPageInfo3.SizeF                          = new System.Drawing.SizeF(254.0002F, 58.42F);
     this.xrPageInfo3.StylePriority.UseFont          = false;
     this.xrPageInfo3.StylePriority.UseTextAlignment = false;
     this.xrPageInfo3.TextAlignment                  = DevExpress.XtraPrinting.TextAlignment.TopRight;
     //
     // xrPageInfo2
     //
     this.xrPageInfo2.Dpi                            = 254F;
     this.xrPageInfo2.Font                           = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrPageInfo2.Format                         = "{0:yyyy-MM-dd h:mm tt}";
     this.xrPageInfo2.LocationFloat                  = new DevExpress.Utils.PointFloat(24.99999F, 0F);
     this.xrPageInfo2.Name                           = "xrPageInfo2";
     this.xrPageInfo2.Padding                        = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F);
     this.xrPageInfo2.PageInfo                       = DevExpress.XtraPrinting.PageInfo.DateTime;
     this.xrPageInfo2.SizeF                          = new System.Drawing.SizeF(664.6505F, 58.42F);
     this.xrPageInfo2.StylePriority.UseFont          = false;
     this.xrPageInfo2.StylePriority.UseTextAlignment = false;
     this.xrPageInfo2.TextAlignment                  = DevExpress.XtraPrinting.TextAlignment.TopLeft;
     //
     // Odding
     //
     this.Odding.BackColor       = System.Drawing.Color.FromArgb(((int)(((byte)(220)))), ((int)(((byte)(220)))), ((int)(((byte)(220)))));
     this.Odding.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
     this.Odding.Borders         = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                                                                           | DevExpress.XtraPrinting.BorderSide.Right)
                                                                          | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.Odding.Name    = "Odding";
     this.Odding.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
     //
     // GroupCaption3
     //
     this.GroupCaption3.BackColor     = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(128)))));
     this.GroupCaption3.BorderColor   = System.Drawing.Color.White;
     this.GroupCaption3.Borders       = DevExpress.XtraPrinting.BorderSide.Bottom;
     this.GroupCaption3.BorderWidth   = 2F;
     this.GroupCaption3.Font          = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
     this.GroupCaption3.ForeColor     = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))));
     this.GroupCaption3.Name          = "GroupCaption3";
     this.GroupCaption3.Padding       = new DevExpress.XtraPrinting.PaddingInfo(15, 5, 0, 0, 254F);
     this.GroupCaption3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     //
     // xrControlStyle1
     //
     this.xrControlStyle1.BackColor       = System.Drawing.Color.FromArgb(((int)(((byte)(220)))), ((int)(((byte)(220)))), ((int)(((byte)(220)))));
     this.xrControlStyle1.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
     this.xrControlStyle1.Borders         = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                                                                                    | DevExpress.XtraPrinting.BorderSide.Right)
                                                                                   | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrControlStyle1.Name    = "xrControlStyle1";
     this.xrControlStyle1.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
     //
     // Title
     //
     this.Title.BackColor   = System.Drawing.Color.Transparent;
     this.Title.BorderColor = System.Drawing.Color.Black;
     this.Title.Borders     = DevExpress.XtraPrinting.BorderSide.None;
     this.Title.BorderWidth = 1F;
     this.Title.Font        = new System.Drawing.Font("Tahoma", 14F);
     this.Title.ForeColor   = System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(75)))), ((int)(((byte)(75)))));
     this.Title.Name        = "Title";
     //
     // xrControlStyle4
     //
     this.xrControlStyle4.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
     this.xrControlStyle4.Borders         = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                                                                                    | DevExpress.XtraPrinting.BorderSide.Right)
                                                                                   | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrControlStyle4.Name    = "xrControlStyle4";
     this.xrControlStyle4.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
     //
     // xrControlStyle2
     //
     this.xrControlStyle2.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
     this.xrControlStyle2.Borders         = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                                                                                    | DevExpress.XtraPrinting.BorderSide.Right)
                                                                                   | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrControlStyle2.Name    = "xrControlStyle2";
     this.xrControlStyle2.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
     //
     // tbl_header_style
     //
     this.tbl_header_style.BackColor       = System.Drawing.Color.Silver;
     this.tbl_header_style.BorderColor     = System.Drawing.Color.Black;
     this.tbl_header_style.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
     this.tbl_header_style.Borders         = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                                                                                     | DevExpress.XtraPrinting.BorderSide.Right)
                                                                                    | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.tbl_header_style.Font          = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.tbl_header_style.ForeColor     = System.Drawing.Color.Black;
     this.tbl_header_style.Name          = "tbl_header_style";
     this.tbl_header_style.Padding       = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 5, 5, 254F);
     this.tbl_header_style.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // tbl_even_detail
     //
     this.tbl_even_detail.BackColor       = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
     this.tbl_even_detail.BorderColor     = System.Drawing.Color.Black;
     this.tbl_even_detail.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
     this.tbl_even_detail.Borders         = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                                                                                    | DevExpress.XtraPrinting.BorderSide.Right)
                                                                                   | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.tbl_even_detail.Font          = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.tbl_even_detail.ForeColor     = System.Drawing.Color.Black;
     this.tbl_even_detail.Name          = "tbl_even_detail";
     this.tbl_even_detail.Padding       = new DevExpress.XtraPrinting.PaddingInfo(3, 3, 3, 3, 254F);
     this.tbl_even_detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // tbl_odd_detail
     //
     this.tbl_odd_detail.BackColor       = System.Drawing.Color.White;
     this.tbl_odd_detail.BorderColor     = System.Drawing.Color.Black;
     this.tbl_odd_detail.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
     this.tbl_odd_detail.Borders         = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                                                                                   | DevExpress.XtraPrinting.BorderSide.Right)
                                                                                  | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.tbl_odd_detail.Font          = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.tbl_odd_detail.ForeColor     = System.Drawing.Color.Black;
     this.tbl_odd_detail.Name          = "tbl_odd_detail";
     this.tbl_odd_detail.Padding       = new DevExpress.XtraPrinting.PaddingInfo(3, 3, 3, 3, 254F);
     this.tbl_odd_detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // sqlDataSource1
     //
     this.sqlDataSource1.ConnectionName = "HrContext";
     this.sqlDataSource1.Name           = "sqlDataSource1";
     storedProcQuery1.Name           = "EmployeeDocuments";
     storedProcQuery1.StoredProcName = "EmployeeDocuments";
     this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         storedProcQuery1
     });
     this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
     //
     // xrTable2
     //
     this.xrTable2.Dpi           = 254F;
     this.xrTable2.Font          = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(329.417F, 0F);
     this.xrTable2.Name          = "xrTable2";
     this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow2
     });
     this.xrTable2.SizeF = new System.Drawing.SizeF(2630.583F, 63.5F);
     this.xrTable2.StylePriority.UseFont = false;
     //
     // xrTableRow2
     //
     this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell6,
         this.xrTableCell11,
         this.xrTableCell7,
         this.xrTableCell8,
         this.xrTableCell9,
         this.xrTableCell10
     });
     this.xrTableRow2.Dpi    = 254F;
     this.xrTableRow2.Name   = "xrTableRow2";
     this.xrTableRow2.Weight = 0.5679012345679012D;
     //
     // xrTableCell6
     //
     this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_EmployeeDocumentReport.EndDate", "{0:yyyy-MM-dd}")
     });
     this.xrTableCell6.Dpi  = 254F;
     this.xrTableCell6.Name = "xrTableCell6";
     this.xrTableCell6.StylePriority.UseTextAlignment = false;
     this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     this.xrTableCell6.Weight        = 0.058898504773092768D;
     //
     // xrTableCell11
     //
     this.xrTableCell11.Dpi  = 254F;
     this.xrTableCell11.Name = "xrTableCell11";
     this.xrTableCell11.StylePriority.UseTextAlignment = false;
     this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     this.xrTableCell11.Weight        = 0.0583797479597113D;
     //
     // xrTableCell7
     //
     this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_EmployeeDocumentReport.StartDate", "{0:yyyy-MM-dd}")
     });
     this.xrTableCell7.Dpi           = 254F;
     this.xrTableCell7.EvenStyleName = "tbl_odd_detail";
     this.xrTableCell7.Name          = "xrTableCell7";
     this.xrTableCell7.OddStyleName  = "tbl_even_detail";
     this.xrTableCell7.StylePriority.UseTextAlignment = false;
     this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     this.xrTableCell7.Weight        = 0.072820293199522115D;
     //
     // xrTableCell8
     //
     this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_EmployeeDocumentReport.DocReqOpt")
     });
     this.xrTableCell8.Dpi           = 254F;
     this.xrTableCell8.EvenStyleName = "tbl_odd_detail";
     this.xrTableCell8.Name          = "xrTableCell8";
     this.xrTableCell8.OddStyleName  = "tbl_even_detail";
     this.xrTableCell8.StylePriority.UseTextAlignment = false;
     this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     this.xrTableCell8.Weight        = 0.15029585798816569D;
     //
     // xrTableCell9
     //
     this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_EmployeeDocumentReport.DocType")
     });
     this.xrTableCell9.Dpi           = 254F;
     this.xrTableCell9.EvenStyleName = "tbl_odd_detail";
     this.xrTableCell9.Name          = "xrTableCell9";
     this.xrTableCell9.OddStyleName  = "tbl_even_detail";
     this.xrTableCell9.StylePriority.UseTextAlignment = false;
     this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     this.xrTableCell9.Weight        = 0.15029585798816569D;
     //
     // xrTableCell10
     //
     this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_EmployeeDocumentReport.docTypeName")
     });
     this.xrTableCell10.Dpi           = 254F;
     this.xrTableCell10.EvenStyleName = "tbl_odd_detail";
     this.xrTableCell10.Name          = "xrTableCell10";
     this.xrTableCell10.OddStyleName  = "tbl_even_detail";
     this.xrTableCell10.StylePriority.UseTextAlignment = false;
     this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     this.xrTableCell10.Weight        = 0.15029585798816569D;
     //
     // xrTable1
     //
     this.xrTable1.Borders       = DevExpress.XtraPrinting.BorderSide.None;
     this.xrTable1.Dpi           = 254F;
     this.xrTable1.Font          = new System.Drawing.Font("Frutiger LT Arabic 55 Roman", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(329.417F, 0F);
     this.xrTable1.Name          = "xrTable1";
     this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow1
     });
     this.xrTable1.SizeF     = new System.Drawing.SizeF(2630.583F, 63.5F);
     this.xrTable1.StyleName = "tbl_header_style";
     this.xrTable1.StylePriority.UseBorders = false;
     this.xrTable1.StylePriority.UseFont    = false;
     //
     // xrTableRow1
     //
     this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell1,
         this.xrTableCell2,
         this.xrTableCell3,
         this.xrTableCell4,
         this.xrTableCell5
     });
     this.xrTableRow1.Dpi    = 254F;
     this.xrTableRow1.Name   = "xrTableRow1";
     this.xrTableRow1.Weight = 0.5679012345679012D;
     //
     // xrTableCell1
     //
     this.xrTableCell1.Borders = DevExpress.XtraPrinting.BorderSide.None;
     this.xrTableCell1.Dpi     = 254F;
     this.xrTableCell1.Name    = "xrTableCell1";
     this.xrTableCell1.StylePriority.UseBorders       = false;
     this.xrTableCell1.StylePriority.UseTextAlignment = false;
     this.xrTableCell1.Text          = "تاريخ الانتهاء";
     this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell1.Weight        = 0.12219295708371847D;
     //
     // xrTableCell2
     //
     this.xrTableCell2.Dpi  = 254F;
     this.xrTableCell2.Name = "xrTableCell2";
     this.xrTableCell2.StylePriority.UseTextAlignment = false;
     this.xrTableCell2.Text          = "تاريخ الاصدار";
     this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell2.Weight        = 0.0758719550880966D;
     //
     // xrTableCell3
     //
     this.xrTableCell3.Dpi  = 254F;
     this.xrTableCell3.Name = "xrTableCell3";
     this.xrTableCell3.StylePriority.UseTextAlignment = false;
     this.xrTableCell3.Text          = "درجة إلزامية الوثيقة";
     this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell3.Weight        = 0.15659421787239322D;
     //
     // xrTableCell4
     //
     this.xrTableCell4.Dpi  = 254F;
     this.xrTableCell4.Name = "xrTableCell4";
     this.xrTableCell4.StylePriority.UseTextAlignment = false;
     this.xrTableCell4.Text          = "نوع الوثيقة";
     this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell4.Weight        = 0.1628925777566208D;
     //
     // xrTableCell5
     //
     this.xrTableCell5.Dpi  = 254F;
     this.xrTableCell5.Name = "xrTableCell5";
     this.xrTableCell5.StylePriority.UseTextAlignment = false;
     this.xrTableCell5.Text          = "اسم الوثيقة";
     this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell5.Weight        = 0.15029585798816569D;
     //
     // HasExDate
     //
     this.HasExDate.DataMember = "EmployeeDocuments";
     this.HasExDate.Expression = "Iif([HasExpiryDate]=true,\'لها تاريخ انتهاء\',\'ليس لها تاريخ انتهاء\')";
     this.HasExDate.Name       = "HasExDate";
     //
     // sqlDataSource2
     //
     this.sqlDataSource2.ConnectionName = "HrContext";
     this.sqlDataSource2.Name           = "sqlDataSource2";
     storedProcQuery2.Name     = "sp_GetRequiredPaper";
     queryParameter1.Name      = "@jobId";
     queryParameter1.Type      = typeof(int);
     queryParameter1.ValueInfo = "0";
     storedProcQuery2.Parameters.Add(queryParameter1);
     storedProcQuery2.StoredProcName = "sp_GetRequiredPaper";
     this.sqlDataSource2.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         storedProcQuery2
     });
     this.sqlDataSource2.ResultSchemaSerializable = resources.GetString("sqlDataSource2.ResultSchemaSerializable");
     //
     // GroupHeader1
     //
     this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrLabel3,
         this.xrLabel2
     });
     this.GroupHeader1.Dpi = 254F;
     this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
         new DevExpress.XtraReports.UI.GroupField("EmpName", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
     });
     this.GroupHeader1.HeightF = 58.42F;
     this.GroupHeader1.Level   = 2;
     this.GroupHeader1.Name    = "GroupHeader1";
     //
     // xrLabel3
     //
     this.xrLabel3.BackColor = System.Drawing.Color.WhiteSmoke;
     this.xrLabel3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_EmployeeDocumentReport.JobName")
     });
     this.xrLabel3.Dpi           = 254F;
     this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(197.1254F, 0F);
     this.xrLabel3.Name          = "xrLabel3";
     this.xrLabel3.Padding       = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F);
     this.xrLabel3.SizeF         = new System.Drawing.SizeF(2396.652F, 58.42F);
     this.xrLabel3.StylePriority.UseBackColor     = false;
     this.xrLabel3.StylePriority.UseTextAlignment = false;
     this.xrLabel3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     //
     // xrLabel2
     //
     this.xrLabel2.BackColor = System.Drawing.Color.LightGray;
     this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sp_EmployeeDocumentReport.EmpName")
     });
     this.xrLabel2.Dpi           = 254F;
     this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(2593.778F, 0F);
     this.xrLabel2.Name          = "xrLabel2";
     this.xrLabel2.Padding       = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F);
     this.xrLabel2.SizeF         = new System.Drawing.SizeF(366.2224F, 58.42F);
     this.xrLabel2.StylePriority.UseBackColor     = false;
     this.xrLabel2.StylePriority.UseTextAlignment = false;
     this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     //
     // GroupHeader2
     //
     this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrTable2
     });
     this.GroupHeader2.Dpi = 254F;
     this.GroupHeader2.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
         new DevExpress.XtraReports.UI.GroupField("docTypeName", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
     });
     this.GroupHeader2.HeightF = 63.5F;
     this.GroupHeader2.Name    = "GroupHeader2";
     //
     // GroupFooter1
     //
     this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrSubreport1
     });
     this.GroupFooter1.Dpi     = 254F;
     this.GroupFooter1.HeightF = 143.8628F;
     this.GroupFooter1.Level   = 1;
     this.GroupFooter1.Name    = "GroupFooter1";
     //
     // GroupHeader3
     //
     this.GroupHeader3.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrTable1
     });
     this.GroupHeader3.Dpi     = 254F;
     this.GroupHeader3.HeightF = 63.5F;
     this.GroupHeader3.Level   = 1;
     this.GroupHeader3.Name    = "GroupHeader3";
     //
     // sqlDataSource3
     //
     this.sqlDataSource3.ConnectionName = "HrContext";
     this.sqlDataSource3.Name           = "sqlDataSource3";
     storedProcQuery3.Name           = "sp_EmployeeDocumentReport";
     storedProcQuery3.StoredProcName = "sp_EmployeeDocumentReport";
     this.sqlDataSource3.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         storedProcQuery3
     });
     this.sqlDataSource3.ResultSchemaSerializable = resources.GetString("sqlDataSource3.ResultSchemaSerializable");
     //
     // xrSubreport1
     //
     this.xrSubreport1.Dpi           = 254F;
     this.xrSubreport1.LocationFloat = new DevExpress.Utils.PointFloat(197.1249F, 0F);
     this.xrSubreport1.Name          = "xrSubreport1";
     this.xrSubreport1.ParameterBindings.Add(new DevExpress.XtraReports.UI.ParameterBinding("CompanyId", null, "sp_EmployeeDocumentReport.CompanyId"));
     this.xrSubreport1.ParameterBindings.Add(new DevExpress.XtraReports.UI.ParameterBinding("EmpId", null, "sp_EmployeeDocumentReport.EmpId"));
     this.xrSubreport1.ParameterBindings.Add(new DevExpress.XtraReports.UI.ParameterBinding("Nationality", null, "sp_EmployeeDocumentReport.nationalityId"));
     this.xrSubreport1.ParameterBindings.Add(new DevExpress.XtraReports.UI.ParameterBinding("Gender", null, "sp_EmployeeDocumentReport.Gender"));
     this.xrSubreport1.ParameterBindings.Add(new DevExpress.XtraReports.UI.ParameterBinding("Culture", null, "sp_EmployeeDocumentReport.Gender"));
     this.xrSubreport1.ReportSource = new Sub();
     this.xrSubreport1.SizeF        = new System.Drawing.SizeF(2762.875F, 138.5711F);
     //
     // EmployeeDocument
     //
     this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
         this.Detail,
         this.TopMargin,
         this.BottomMargin,
         this.ReportHeader,
         this.PageFooter,
         this.GroupHeader1,
         this.GroupHeader2,
         this.GroupFooter1,
         this.GroupHeader3
     });
     this.Bookmark = "الهيكل التوظيفى";
     this.CalculatedFields.AddRange(new DevExpress.XtraReports.UI.CalculatedField[] {
         this.HasExDate
     });
     this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
         this.sqlDataSource1,
         this.sqlDataSource2,
         this.sqlDataSource3
     });
     this.DataMember   = "sp_EmployeeDocumentReport";
     this.DataSource   = this.sqlDataSource3;
     this.Dpi          = 254F;
     this.Landscape    = true;
     this.Margins      = new System.Drawing.Printing.Margins(0, 10, 14, 18);
     this.PageHeight   = 2100;
     this.PageWidth    = 2970;
     this.PaperKind    = System.Drawing.Printing.PaperKind.A4;
     this.ReportUnit   = DevExpress.XtraReports.UI.ReportUnit.TenthsOfAMillimeter;
     this.SnapGridSize = 25F;
     this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] {
         this.Odding,
         this.GroupCaption3,
         this.xrControlStyle1,
         this.Title,
         this.xrControlStyle4,
         this.xrControlStyle2,
         this.tbl_header_style,
         this.tbl_even_detail,
         this.tbl_odd_detail
     });
     this.Version = "17.1";
     ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
        public void GivenTheXRSubreportContainerExistsInTheParentReportBand(string location)
        {
            const string nameToUse = "SubReportContainer";

            Band band;
            switch (location.ToUpper())
            {
                case "HEADER":
                    band = new ReportHeaderBand();
                    _getContainerFunc = r => (XRSubreport)r.Bands[BandKind.ReportHeader].Controls[nameToUse];
                    break;
                case "FOOTER":
                    band = new ReportFooterBand();
                    _getContainerFunc = r => (XRSubreport) r.Bands[BandKind.ReportFooter].Controls[nameToUse];
                    break;
                case "DETAIL":
                    band = new DetailBand();
                    _getContainerFunc = r => (XRSubreport) r.Bands[BandKind.Detail].Controls[nameToUse];
                    break;
                default:
                    throw new NotImplementedException();
            }

            _parentReport.Bands.Add(band);
            _xrSubreportContainer = new XRSubreport {Name = nameToUse};
            band.Controls.Add(_xrSubreportContainer);
        }
        public void WhenTheReportEngineRuns()
        {
            _newParentReport = _controller.Print(r => r.ExportToMemory());

            _newSubReportContainer = _getContainerFunc(_newParentReport);
        }
        private float addSubReport(IList<ReportRiepilogoContoEconomicoDTO> dataSource, ReportRiepilogoContoEconomicoDTO risultatoEsercizio, string caption, float location, bool columnBreak)
        {
            var reportDare = new RiepilogoContoEconomico(dataSource, risultatoEsercizio, _condominio, _esercizio, _dataIniziale, _dataFinale, _impostazioneReportDTO, caption, true, _reportKey);

            var subreport = new XRSubreport
            {
                ReportSource = reportDare.GetReport(),
                LocationF = new PointF(0, location + .01f)
            };
            _detailBand.Controls.Add(subreport);

            location += reportDare.GetTotalHeight();

            if (columnBreak)
            {
                location = location + .01f;
                var pageBreak = new XRPageBreak();
                _detailBand.Controls.Add(pageBreak);
                pageBreak.LocationF = new PointF(0, location);
            }

            return location;
        }
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     string resourceFileName = "rptMultiInvoicesToPrint.resx";
     DevExpress.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
     DevExpress.XtraReports.UI.XRSummary xrSummary2 = new DevExpress.XtraReports.UI.XRSummary();
     DevExpress.XtraReports.UI.XRSummary xrSummary3 = new DevExpress.XtraReports.UI.XRSummary();
     this.Detail = new DevExpress.XtraReports.UI.DetailBand();
     this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrTable7 = new DevExpress.XtraReports.UI.XRTable();
     this.xrTableRow8 = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell23 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell25 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell24 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell19 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableRow9 = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrTableCell26 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell27 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell28 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell29 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
     this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell22 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell21 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
     this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
     this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
     this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand();
     this.header = new DevExpress.XtraReports.UI.XRSubreport();
     this.xrTable2 = new DevExpress.XtraReports.UI.XRTable();
     this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrOrderNum = new DevExpress.XtraReports.UI.XRTableCell();
     this.colHangHoa = new DevExpress.XtraReports.UI.XRTableCell();
     this.colDonVi = new DevExpress.XtraReports.UI.XRTableCell();
     this.colSoLuong = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell30 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell31 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrTable3 = new DevExpress.XtraReports.UI.XRTable();
     this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrSum = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableRow4 = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrPercent = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrDiscount = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrTableCell32 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell36 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell34 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrPayment = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrLabel20 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel17 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrTable6 = new DevExpress.XtraReports.UI.XRTable();
     this.xrTableRow6 = new DevExpress.XtraReports.UI.XRTableRow();
     this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell();
     this.lbchu = new DevExpress.XtraReports.UI.XRLabel();
     this.GroupFooter2 = new DevExpress.XtraReports.UI.GroupFooterBand();
     this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrPageBreak1 = new DevExpress.XtraReports.UI.XRPageBreak();
     this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel();
     this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel();
     this.dsMultiInvoicesToPrint1 = new dsMultiInvoicesToPrint();
     this.DetailReport = new DevExpress.XtraReports.UI.DetailReportBand();
     this.Detail1 = new DevExpress.XtraReports.UI.DetailBand();
     this.GroupHeader2 = new DevExpress.XtraReports.UI.GroupHeaderBand();
     this.GroupFooter3 = new DevExpress.XtraReports.UI.GroupFooterBand();
     this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell();
     this.xrTableCell35 = new DevExpress.XtraReports.UI.XRTableCell();
     this.invoicesSelectByWhereTableAdapter1 = new dsMultiInvoicesToPrintTableAdapters.InvoicesSelectByWhereTableAdapter();
     this.productsInInvoicesSelectByWhereTableAdapter1 = new dsMultiInvoicesToPrintTableAdapters.ProductsInInvoicesSelectByWhereTableAdapter();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable7)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable6)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsMultiInvoicesToPrint1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // Detail
     //
     this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrLabel10,
         this.xrLabel13,
         this.xrTable7,
         this.header});
     this.Detail.HeightF = 106.2084F;
     this.Detail.Name = "Detail";
     this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
     this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
     //
     // xrLabel10
     //
     this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoiceNo", "Số: {0}")});
     this.xrLabel10.Font = new System.Drawing.Font("Times New Roman", 9F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
     this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(2.041523F, 27.50006F);
     this.xrLabel10.Name = "xrLabel10";
     this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel10.SizeF = new System.Drawing.SizeF(738.9999F, 16F);
     this.xrLabel10.StylePriority.UseFont = false;
     this.xrLabel10.StylePriority.UseTextAlignment = false;
     this.xrLabel10.Text = "xrLabel10";
     this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
     //
     // xrLabel13
     //
     this.xrLabel13.Font = new System.Drawing.Font("Times New Roman", 12.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(0.9580771F, 43.50004F);
     this.xrLabel13.Name = "xrLabel13";
     this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel13.SizeF = new System.Drawing.SizeF(746.9168F, 20F);
     this.xrLabel13.StylePriority.UseFont = false;
     this.xrLabel13.StylePriority.UseTextAlignment = false;
     this.xrLabel13.Text = "HOÁ ĐƠN BÁN HÀNG";
     this.xrLabel13.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // xrTable7
     //
     this.xrTable7.Font = new System.Drawing.Font("Times New Roman", 9F);
     this.xrTable7.LocationFloat = new DevExpress.Utils.PointFloat(9.999903F, 70.20839F);
     this.xrTable7.Name = "xrTable7";
     this.xrTable7.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow8,
         this.xrTableRow9});
     this.xrTable7.SizeF = new System.Drawing.SizeF(731.7083F, 36F);
     this.xrTable7.StylePriority.UseFont = false;
     this.xrTable7.StylePriority.UseTextAlignment = false;
     this.xrTable7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     //
     // xrTableRow8
     //
     this.xrTableRow8.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell6,
         this.xrTableCell23,
         this.xrTableCell25,
         this.xrTableCell24,
         this.xrTableCell7,
         this.xrTableCell19});
     this.xrTableRow8.Name = "xrTableRow8";
     this.xrTableRow8.Weight = 1D;
     //
     // xrTableCell6
     //
     this.xrTableCell6.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrTableCell6.Name = "xrTableCell6";
     this.xrTableCell6.StylePriority.UseFont = false;
     this.xrTableCell6.StylePriority.UseTextAlignment = false;
     this.xrTableCell6.Text = "Khách hàng: ";
     this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     this.xrTableCell6.Weight = 0.76041707714783124D;
     //
     // xrTableCell23
     //
     this.xrTableCell23.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.Customer")});
     this.xrTableCell23.Name = "xrTableCell23";
     this.xrTableCell23.Text = "xrTableCell23";
     this.xrTableCell23.Weight = 1.6354165423495146D;
     //
     // xrTableCell25
     //
     this.xrTableCell25.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrTableCell25.Name = "xrTableCell25";
     this.xrTableCell25.StylePriority.UseFont = false;
     this.xrTableCell25.StylePriority.UseTextAlignment = false;
     this.xrTableCell25.Text = "Điện thoại:";
     this.xrTableCell25.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     this.xrTableCell25.Weight = 0.62583404093619488D;
     //
     // xrTableCell24
     //
     this.xrTableCell24.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.Phone")});
     this.xrTableCell24.Name = "xrTableCell24";
     this.xrTableCell24.Text = "xrTableCell24";
     this.xrTableCell24.Weight = 1.1164577939005926D;
     //
     // xrTableCell7
     //
     this.xrTableCell7.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrTableCell7.Name = "xrTableCell7";
     this.xrTableCell7.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 0, 0, 0, 100F);
     this.xrTableCell7.StylePriority.UseFont = false;
     this.xrTableCell7.StylePriority.UsePadding = false;
     this.xrTableCell7.Text = "Địa chỉ: ";
     this.xrTableCell7.Weight = 0.51395781087784642D;
     //
     // xrTableCell19
     //
     this.xrTableCell19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.CustomerAddress")});
     this.xrTableCell19.Name = "xrTableCell19";
     this.xrTableCell19.Text = "xrTableCell19";
     this.xrTableCell19.Weight = 2.6649996045159052D;
     //
     // xrTableRow9
     //
     this.xrTableRow9.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell26,
         this.xrTableCell27,
         this.xrTableCell28,
         this.xrTableCell29});
     this.xrTableRow9.Name = "xrTableRow9";
     this.xrTableRow9.Weight = 1D;
     //
     // xrTableCell26
     //
     this.xrTableCell26.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrTableCell26.Name = "xrTableCell26";
     this.xrTableCell26.StylePriority.UseFont = false;
     this.xrTableCell26.Text = "Địa chỉ: ";
     this.xrTableCell26.Weight = 0.76041707714783124D;
     //
     // xrTableCell27
     //
     this.xrTableCell27.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.DeliveryAddress")});
     this.xrTableCell27.Name = "xrTableCell27";
     this.xrTableCell27.Text = "xrTableCell27";
     this.xrTableCell27.Weight = 3.377708655696229D;
     //
     // xrTableCell28
     //
     this.xrTableCell28.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrTableCell28.Name = "xrTableCell28";
     this.xrTableCell28.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 0, 0, 0, 100F);
     this.xrTableCell28.StylePriority.UseFont = false;
     this.xrTableCell28.StylePriority.UsePadding = false;
     this.xrTableCell28.Text = "Ngày: ";
     this.xrTableCell28.Weight = 0.51395721385922755D;
     //
     // xrTableCell29
     //
     this.xrTableCell29.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.CurrentDate", "{0:dd/MM/yyyy}")});
     this.xrTableCell29.Name = "xrTableCell29";
     this.xrTableCell29.Text = "xrTableCell29";
     this.xrTableCell29.Weight = 2.664999923024598D;
     //
     // xrTable1
     //
     this.xrTable1.BackColor = System.Drawing.Color.Snow;
     this.xrTable1.BorderColor = System.Drawing.Color.Black;
     this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                 | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTable1.BorderWidth = 1;
     this.xrTable1.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
     this.xrTable1.Name = "xrTable1";
     this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow1});
     this.xrTable1.SizeF = new System.Drawing.SizeF(749.5835F, 25F);
     this.xrTable1.StylePriority.UseBackColor = false;
     this.xrTable1.StylePriority.UseBorderColor = false;
     this.xrTable1.StylePriority.UseBorders = false;
     this.xrTable1.StylePriority.UseBorderWidth = false;
     this.xrTable1.StylePriority.UseFont = false;
     this.xrTable1.StylePriority.UseTextAlignment = false;
     this.xrTable1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // xrTableRow1
     //
     this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell1,
         this.xrTableCell2,
         this.xrTableCell22,
         this.xrTableCell3,
         this.xrTableCell4,
         this.xrTableCell21,
         this.xrTableCell20,
         this.xrTableCell17,
         this.xrTableCell5});
     this.xrTableRow1.Name = "xrTableRow1";
     this.xrTableRow1.Weight = 1D;
     //
     // xrTableCell1
     //
     this.xrTableCell1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                 | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTableCell1.Name = "xrTableCell1";
     this.xrTableCell1.StylePriority.UseBorders = false;
     this.xrTableCell1.StylePriority.UseTextAlignment = false;
     this.xrTableCell1.Text = "STT";
     this.xrTableCell1.Weight = 0.36560024648643036D;
     //
     // xrTableCell2
     //
     this.xrTableCell2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                 | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTableCell2.Name = "xrTableCell2";
     this.xrTableCell2.StylePriority.UseBorders = false;
     this.xrTableCell2.Text = "Tên Hàng Hoá";
     this.xrTableCell2.Weight = 2.3565548083905545D;
     //
     // xrTableCell22
     //
     this.xrTableCell22.Name = "xrTableCell22";
     this.xrTableCell22.Text = "Trọng lượng";
     this.xrTableCell22.Weight = 0.78342919997407734D;
     //
     // xrTableCell3
     //
     this.xrTableCell3.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                 | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTableCell3.Name = "xrTableCell3";
     this.xrTableCell3.StylePriority.UseBorders = false;
     this.xrTableCell3.Text = "ĐVT";
     this.xrTableCell3.Weight = 0.47005750662449247D;
     //
     // xrTableCell4
     //
     this.xrTableCell4.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                 | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTableCell4.Name = "xrTableCell4";
     this.xrTableCell4.StylePriority.UseBorders = false;
     this.xrTableCell4.Text = "Đơn giá bán";
     this.xrTableCell4.Weight = 0.78969598039839828D;
     //
     // xrTableCell21
     //
     this.xrTableCell21.Name = "xrTableCell21";
     this.xrTableCell21.StylePriority.UseTextAlignment = false;
     this.xrTableCell21.Text = "Số lượng bán";
     this.xrTableCell21.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     this.xrTableCell21.Weight = 0.85288598746242816D;
     //
     // xrTableCell20
     //
     this.xrTableCell20.Name = "xrTableCell20";
     this.xrTableCell20.Text = "Tặng";
     this.xrTableCell20.Weight = 0.44682014695324773D;
     //
     // xrTableCell5
     //
     this.xrTableCell5.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                 | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTableCell5.Name = "xrTableCell5";
     this.xrTableCell5.StylePriority.UseBorders = false;
     this.xrTableCell5.Text = "Thành tiền";
     this.xrTableCell5.Weight = 1.0048792922737211D;
     //
     // TopMargin
     //
     this.TopMargin.HeightF = 20F;
     this.TopMargin.Name = "TopMargin";
     this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
     this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
     //
     // BottomMargin
     //
     this.BottomMargin.HeightF = 0F;
     this.BottomMargin.Name = "BottomMargin";
     this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
     this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
     //
     // PageHeader
     //
     this.PageHeader.HeightF = 5.625057F;
     this.PageHeader.Name = "PageHeader";
     //
     // header
     //
     this.header.LocationFloat = new DevExpress.Utils.PointFloat(2.041523F, 0F);
     this.header.Name = "header";
     this.header.SizeF = new System.Drawing.SizeF(748.9584F, 27.50006F);
     //
     // xrTable2
     //
     this.xrTable2.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
     this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTable2.BorderWidth = 1;
     this.xrTable2.Font = new System.Drawing.Font("Times New Roman", 9F);
     this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
     this.xrTable2.Name = "xrTable2";
     this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow2});
     this.xrTable2.SizeF = new System.Drawing.SizeF(749.5835F, 20F);
     this.xrTable2.StylePriority.UseBorderDashStyle = false;
     this.xrTable2.StylePriority.UseBorders = false;
     this.xrTable2.StylePriority.UseBorderWidth = false;
     this.xrTable2.StylePriority.UseFont = false;
     this.xrTable2.StylePriority.UseTextAlignment = false;
     this.xrTable2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // xrTableRow2
     //
     this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrOrderNum,
         this.colHangHoa,
         this.colDonVi,
         this.colSoLuong,
         this.xrTableCell11,
         this.xrTableCell30,
         this.xrTableCell12,
         this.xrTableCell35,
         this.xrTableCell31});
     this.xrTableRow2.Name = "xrTableRow2";
     this.xrTableRow2.Weight = 1D;
     //
     // xrOrderNum
     //
     this.xrOrderNum.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrOrderNum.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.RowIn" +
                 "dex")});
     this.xrOrderNum.Name = "xrOrderNum";
     this.xrOrderNum.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
     this.xrOrderNum.StylePriority.UseBorders = false;
     this.xrOrderNum.StylePriority.UsePadding = false;
     this.xrOrderNum.StylePriority.UseTextAlignment = false;
     this.xrOrderNum.Text = "xrOrderNum";
     this.xrOrderNum.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrOrderNum.Weight = 0.36458328247070315D;
     //
     // colHangHoa
     //
     this.colHangHoa.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.colHangHoa.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.produ" +
                 "ctname")});
     this.colHangHoa.Name = "colHangHoa";
     this.colHangHoa.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 100F);
     this.colHangHoa.StylePriority.UseBorders = false;
     this.colHangHoa.StylePriority.UsePadding = false;
     this.colHangHoa.StylePriority.UseTextAlignment = false;
     this.colHangHoa.Text = "colHangHoa";
     this.colHangHoa.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     this.colHangHoa.Weight = 2.3499999233670534D;
     //
     // colDonVi
     //
     this.colDonVi.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.colDonVi.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.Style" +
                 "")});
     this.colDonVi.Name = "colDonVi";
     this.colDonVi.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 100F);
     this.colDonVi.StylePriority.UseBorders = false;
     this.colDonVi.StylePriority.UsePadding = false;
     this.colDonVi.Text = "colDonVi";
     this.colDonVi.Weight = 0.78125038790315038D;
     //
     // colSoLuong
     //
     this.colSoLuong.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.colSoLuong.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.Unit")});
     this.colSoLuong.Name = "colSoLuong";
     this.colSoLuong.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 100F);
     this.colSoLuong.StylePriority.UseBorders = false;
     this.colSoLuong.StylePriority.UsePadding = false;
     this.colSoLuong.Text = "colSoLuong";
     this.colSoLuong.Weight = 0.46875033858450066D;
     //
     // xrTableCell11
     //
     this.xrTableCell11.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.Curre" +
                 "ntPrice", "{0:n0}")});
     this.xrTableCell11.Name = "xrTableCell11";
     this.xrTableCell11.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 100F);
     this.xrTableCell11.StylePriority.UseBorders = false;
     this.xrTableCell11.StylePriority.UsePadding = false;
     this.xrTableCell11.StylePriority.UseTextAlignment = false;
     xrSummary1.FormatString = "{0:0.00 VND}";
     this.xrTableCell11.Summary = xrSummary1;
     this.xrTableCell11.Text = "xrTableCell11";
     this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell11.Weight = 0.78749918670705688D;
     //
     // xrTableCell30
     //
     this.xrTableCell30.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.Quant" +
                 "ity", "{0:n0}")});
     this.xrTableCell30.Name = "xrTableCell30";
     this.xrTableCell30.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
     this.xrTableCell30.StylePriority.UsePadding = false;
     this.xrTableCell30.StylePriority.UseTextAlignment = false;
     this.xrTableCell30.Text = "xrTableCell30";
     this.xrTableCell30.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell30.Weight = 0.85051490427718135D;
     //
     // xrTableCell12
     //
     this.xrTableCell12.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.Bonus" +
                 "", "{0:n0}")});
     this.xrTableCell12.Name = "xrTableCell12";
     this.xrTableCell12.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
     this.xrTableCell12.StylePriority.UseBorders = false;
     this.xrTableCell12.StylePriority.UsePadding = false;
     this.xrTableCell12.StylePriority.UseTextAlignment = false;
     this.xrTableCell12.Text = "xrTableCell12";
     this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell12.Weight = 0.4455766067495005D;
     //
     // xrTableCell31
     //
     this.xrTableCell31.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.Total" +
                 "", "{0:n0}")});
     this.xrTableCell31.Name = "xrTableCell31";
     this.xrTableCell31.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
     this.xrTableCell31.StylePriority.UsePadding = false;
     this.xrTableCell31.StylePriority.UseTextAlignment = false;
     this.xrTableCell31.Text = "[InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.Total]";
     this.xrTableCell31.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell31.Weight = 1.0020843341075598D;
     //
     // xrLabel4
     //
     this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.Notes")});
     this.xrLabel4.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Italic);
     this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(9.041818F, 111.7916F);
     this.xrLabel4.Name = "xrLabel4";
     this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel4.SizeF = new System.Drawing.SizeF(578.4171F, 16F);
     this.xrLabel4.StylePriority.UseFont = false;
     this.xrLabel4.Text = "xrLabel4";
     //
     // xrTable3
     //
     this.xrTable3.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid;
     this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTable3.BorderWidth = 1;
     this.xrTable3.Font = new System.Drawing.Font("Times New Roman", 9F);
     this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
     this.xrTable3.Name = "xrTable3";
     this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow3,
         this.xrTableRow4,
         this.xrTableRow5});
     this.xrTable3.SizeF = new System.Drawing.SizeF(749.5835F, 60F);
     this.xrTable3.StylePriority.UseBorderDashStyle = false;
     this.xrTable3.StylePriority.UseBorders = false;
     this.xrTable3.StylePriority.UseBorderWidth = false;
     this.xrTable3.StylePriority.UseFont = false;
     this.xrTable3.StylePriority.UseTextAlignment = false;
     this.xrTable3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // xrTableRow3
     //
     this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell14,
         this.xrTableCell10,
         this.xrSum});
     this.xrTableRow3.Name = "xrTableRow3";
     this.xrTableRow3.Weight = 1D;
     //
     // xrTableCell14
     //
     this.xrTableCell14.Name = "xrTableCell14";
     this.xrTableCell14.Weight = 5.6337398317540881D;
     //
     // xrTableCell10
     //
     this.xrTableCell10.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right)
                 | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.xrTableCell10.Name = "xrTableCell10";
     this.xrTableCell10.StylePriority.UseBorders = false;
     this.xrTableCell10.StylePriority.UseTextAlignment = false;
     this.xrTableCell10.Weight = 0.89610777590259483D;
     //
     // xrSum
     //
     this.xrSum.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.FinalTotal", "{0:n0}")});
     this.xrSum.Font = new System.Drawing.Font("Times New Roman", 9F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
     this.xrSum.Name = "xrSum";
     this.xrSum.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
     this.xrSum.StylePriority.UseFont = false;
     this.xrSum.StylePriority.UsePadding = false;
     this.xrSum.StylePriority.UseTextAlignment = false;
     xrSummary2.FormatString = "{0:n0}";
     this.xrSum.Summary = xrSummary2;
     this.xrSum.Text = "xrSum";
     this.xrSum.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrSum.Weight = 1.0076542233980046D;
     //
     // xrTableRow4
     //
     this.xrTableRow4.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell18,
         this.xrPercent,
         this.xrTableCell13,
         this.xrDiscount});
     this.xrTableRow4.Name = "xrTableRow4";
     this.xrTableRow4.Weight = 1D;
     //
     // xrTableCell18
     //
     this.xrTableCell18.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrTableCell18.Name = "xrTableCell18";
     this.xrTableCell18.StylePriority.UseFont = false;
     this.xrTableCell18.Text = "Chiết khấu:";
     this.xrTableCell18.Weight = 4.7784974502941386D;
     //
     // xrPercent
     //
     this.xrPercent.Font = new System.Drawing.Font("Times New Roman", 9F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
     this.xrPercent.Name = "xrPercent";
     this.xrPercent.StylePriority.UseFont = false;
     this.xrPercent.StylePriority.UseTextAlignment = false;
     this.xrPercent.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrPercent.Weight = 0.855243157122188D;
     this.xrPercent.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrPercent_BeforePrint);
     //
     // xrTableCell13
     //
     this.xrTableCell13.Name = "xrTableCell13";
     this.xrTableCell13.Weight = 0.89610592194689409D;
     //
     // xrDiscount
     //
     this.xrDiscount.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.Discount", "{0:n0}")});
     this.xrDiscount.Font = new System.Drawing.Font("Times New Roman", 9F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
     this.xrDiscount.Name = "xrDiscount";
     this.xrDiscount.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
     this.xrDiscount.StylePriority.UseFont = false;
     this.xrDiscount.StylePriority.UsePadding = false;
     this.xrDiscount.StylePriority.UseTextAlignment = false;
     this.xrDiscount.Text = "xrDiscount";
     this.xrDiscount.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrDiscount.Weight = 1.0076553016914669D;
     //
     // xrTableRow5
     //
     this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell32,
         this.xrTableCell36,
         this.xrTableCell34,
         this.xrPayment});
     this.xrTableRow5.Name = "xrTableRow5";
     this.xrTableRow5.Weight = 1D;
     //
     // xrTableCell32
     //
     this.xrTableCell32.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrTableCell32.Name = "xrTableCell32";
     this.xrTableCell32.StylePriority.UseFont = false;
     this.xrTableCell32.Text = "Số tiền phải thanh toán:";
     this.xrTableCell32.Weight = 4.7784974502941386D;
     //
     // xrTableCell36
     //
     this.xrTableCell36.Name = "xrTableCell36";
     this.xrTableCell36.Weight = 0.85524315712218835D;
     //
     // xrTableCell34
     //
     this.xrTableCell34.Name = "xrTableCell34";
     this.xrTableCell34.Weight = 0.89610592533963673D;
     //
     // xrPayment
     //
     this.xrPayment.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.Payment", "{0:n0}")});
     this.xrPayment.Font = new System.Drawing.Font("Times New Roman", 9F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
     this.xrPayment.Name = "xrPayment";
     this.xrPayment.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
     this.xrPayment.StylePriority.UseFont = false;
     this.xrPayment.StylePriority.UsePadding = false;
     this.xrPayment.StylePriority.UseTextAlignment = false;
     this.xrPayment.Text = "[InvoicesSelectByWhere.Payment]";
     this.xrPayment.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrPayment.Weight = 1.0076552982987241D;
     //
     // xrLabel20
     //
     this.xrLabel20.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrLabel20.LocationFloat = new DevExpress.Utils.PointFloat(592.0837F, 132.7916F);
     this.xrLabel20.Name = "xrLabel20";
     this.xrLabel20.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel20.SizeF = new System.Drawing.SizeF(130F, 16F);
     this.xrLabel20.StylePriority.UseFont = false;
     this.xrLabel20.StylePriority.UseTextAlignment = false;
     this.xrLabel20.Text = "Nhân viên bán hàng";
     this.xrLabel20.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // xrLabel17
     //
     this.xrLabel17.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrLabel17.LocationFloat = new DevExpress.Utils.PointFloat(8.208816F, 91.79157F);
     this.xrLabel17.Name = "xrLabel17";
     this.xrLabel17.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel17.SizeF = new System.Drawing.SizeF(64.58333F, 16.00001F);
     this.xrLabel17.StylePriority.UseFont = false;
     this.xrLabel17.Text = "Ghi chú: ";
     //
     // xrLabel5
     //
     this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.Seller")});
     this.xrLabel5.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(592.0837F, 192.5001F);
     this.xrLabel5.Name = "xrLabel5";
     this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel5.SizeF = new System.Drawing.SizeF(130F, 16.00002F);
     this.xrLabel5.StylePriority.UseFont = false;
     this.xrLabel5.StylePriority.UseTextAlignment = false;
     this.xrLabel5.Text = "xrLabel5";
     this.xrLabel5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // xrLabel3
     //
     this.xrLabel3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.SellerPhone")});
     this.xrLabel3.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(593.0836F, 208.5001F);
     this.xrLabel3.Name = "xrLabel3";
     this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel3.SizeF = new System.Drawing.SizeF(129.0001F, 16F);
     this.xrLabel3.StylePriority.UseFont = false;
     this.xrLabel3.StylePriority.UseTextAlignment = false;
     this.xrLabel3.Text = "xrLabel3";
     this.xrLabel3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // xrTable6
     //
     this.xrTable6.Borders = DevExpress.XtraPrinting.BorderSide.None;
     this.xrTable6.Font = new System.Drawing.Font("Times New Roman", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrTable6.LocationFloat = new DevExpress.Utils.PointFloat(0F, 60.00001F);
     this.xrTable6.Name = "xrTable6";
     this.xrTable6.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
         this.xrTableRow6});
     this.xrTable6.SizeF = new System.Drawing.SizeF(750F, 20F);
     this.xrTable6.StylePriority.UseBorders = false;
     this.xrTable6.StylePriority.UseFont = false;
     this.xrTable6.StylePriority.UseTextAlignment = false;
     this.xrTable6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // xrTableRow6
     //
     this.xrTableRow6.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
         this.xrTableCell8,
         this.xrTableCell9});
     this.xrTableRow6.Name = "xrTableRow6";
     this.xrTableRow6.Weight = 1D;
     //
     // xrTableCell8
     //
     this.xrTableCell8.Font = new System.Drawing.Font("Times New Roman", 9F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
     this.xrTableCell8.Name = "xrTableCell8";
     this.xrTableCell8.StylePriority.UseFont = false;
     this.xrTableCell8.StylePriority.UseTextAlignment = false;
     this.xrTableCell8.Text = "Tổng tiền (bằng chữ):";
     this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     this.xrTableCell8.Weight = 1.0847216847737626D;
     //
     // xrTableCell9
     //
     this.xrTableCell9.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.lbchu});
     this.xrTableCell9.Font = new System.Drawing.Font("Times New Roman", 9F);
     this.xrTableCell9.Name = "xrTableCell9";
     this.xrTableCell9.StylePriority.UseFont = false;
     this.xrTableCell9.StylePriority.UseTextAlignment = false;
     xrSummary3.FormatString = "{0:0.00 VND}";
     this.xrTableCell9.Summary = xrSummary3;
     this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     this.xrTableCell9.Weight = 5.4152783152262369D;
     //
     // lbchu
     //
     this.lbchu.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
     this.lbchu.Name = "lbchu";
     this.lbchu.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.lbchu.SizeF = new System.Drawing.SizeF(623.7981F, 20F);
     this.lbchu.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.lbchu_BeforePrint);
     //
     // GroupFooter2
     //
     this.GroupFooter2.HeightF = 20.45835F;
     this.GroupFooter2.Name = "GroupFooter2";
     //
     // xrLabel6
     //
     this.xrLabel6.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(312.1668F, 132.7916F);
     this.xrLabel6.Name = "xrLabel6";
     this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel6.SizeF = new System.Drawing.SizeF(130F, 16F);
     this.xrLabel6.StylePriority.UseFont = false;
     this.xrLabel6.StylePriority.UseTextAlignment = false;
     this.xrLabel6.Text = "Nhân viên giao hàng";
     this.xrLabel6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // xrLabel8
     //
     this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.DeliverPhone")});
     this.xrLabel8.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(312.1668F, 208.5001F);
     this.xrLabel8.Name = "xrLabel8";
     this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel8.SizeF = new System.Drawing.SizeF(130F, 16F);
     this.xrLabel8.StylePriority.UseFont = false;
     this.xrLabel8.StylePriority.UseTextAlignment = false;
     this.xrLabel8.Text = "xrLabel8";
     this.xrLabel8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // xrLabel7
     //
     this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "sale_InvoiceToPrint.Deliver")});
     this.xrLabel7.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(312.1668F, 192.5001F);
     this.xrLabel7.Name = "xrLabel7";
     this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel7.SizeF = new System.Drawing.SizeF(130F, 16F);
     this.xrLabel7.StylePriority.UseFont = false;
     this.xrLabel7.StylePriority.UseTextAlignment = false;
     this.xrLabel7.Text = "xrLabel7";
     this.xrLabel7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // xrLabel1
     //
     this.xrLabel1.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Italic);
     this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(72.79218F, 91.79156F);
     this.xrLabel1.Name = "xrLabel1";
     this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel1.SizeF = new System.Drawing.SizeF(514.6667F, 16F);
     this.xrLabel1.StylePriority.UseFont = false;
     this.xrLabel1.Text = "- Vui lòng kiểm tra kỹ hàng trước khi nhận. Nhân viên bán hàng không được nhận ti" +
         "ền và hàng hóa.";
     //
     // xrPageBreak1
     //
     this.xrPageBreak1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 238F);
     this.xrPageBreak1.Name = "xrPageBreak1";
     //
     // xrLabel9
     //
     this.xrLabel9.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(86.0417F, 132.7916F);
     this.xrLabel9.Name = "xrLabel9";
     this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel9.SizeF = new System.Drawing.SizeF(130F, 16F);
     this.xrLabel9.StylePriority.UseFont = false;
     this.xrLabel9.StylePriority.UseTextAlignment = false;
     this.xrLabel9.Text = "Khách hàng";
     this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // xrLabel11
     //
     this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.Customer")});
     this.xrLabel11.Font = new System.Drawing.Font("Times New Roman", 9F, System.Drawing.FontStyle.Bold);
     this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(86.0417F, 208.5001F);
     this.xrLabel11.Name = "xrLabel11";
     this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel11.SizeF = new System.Drawing.SizeF(130F, 16F);
     this.xrLabel11.StylePriority.UseFont = false;
     this.xrLabel11.StylePriority.UseTextAlignment = false;
     this.xrLabel11.Text = "xrLabel11";
     this.xrLabel11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
     //
     // dsMultiInvoicesToPrint1
     //
     this.dsMultiInvoicesToPrint1.DataSetName = "dsMultiInvoicesToPrint";
     this.dsMultiInvoicesToPrint1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     //
     // DetailReport
     //
     this.DetailReport.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
         this.Detail1,
         this.GroupHeader2,
         this.GroupFooter3});
     this.DetailReport.DataMember = "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere";
     this.DetailReport.DataSource = this.dsMultiInvoicesToPrint1;
     this.DetailReport.Level = 0;
     this.DetailReport.Name = "DetailReport";
     //
     // Detail1
     //
     this.Detail1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrTable2});
     this.Detail1.HeightF = 20F;
     this.Detail1.Name = "Detail1";
     //
     // GroupHeader2
     //
     this.GroupHeader2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrTable1});
     this.GroupHeader2.HeightF = 25F;
     this.GroupHeader2.Name = "GroupHeader2";
     //
     // GroupFooter3
     //
     this.GroupFooter3.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrTable6,
         this.xrLabel17,
         this.xrLabel4,
         this.xrTable3,
         this.xrLabel20,
         this.xrLabel3,
         this.xrLabel5,
         this.xrPageBreak1,
         this.xrLabel1,
         this.xrLabel7,
         this.xrLabel8,
         this.xrLabel6,
         this.xrLabel9,
         this.xrLabel11});
     this.GroupFooter3.HeightF = 250F;
     this.GroupFooter3.Name = "GroupFooter3";
     //
     // xrTableCell17
     //
     this.xrTableCell17.Name = "xrTableCell17";
     this.xrTableCell17.Text = "CK(%)";
     this.xrTableCell17.Weight = 0.44682014695324773D;
     //
     // xrTableCell35
     //
     this.xrTableCell35.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
         new DevExpress.XtraReports.UI.XRBinding("Text", null, "InvoicesSelectByWhere.InvoicesSelectByWhere_ProductsInInvoicesSelectByWhere.Disco" +
                 "unt", "{0:n2}")});
     this.xrTableCell35.Name = "xrTableCell35";
     this.xrTableCell35.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 5, 0, 0, 100F);
     this.xrTableCell35.StylePriority.UsePadding = false;
     this.xrTableCell35.StylePriority.UseTextAlignment = false;
     this.xrTableCell35.Text = "xrTableCell35";
     this.xrTableCell35.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     this.xrTableCell35.Weight = 0.4455766067495005D;
     //
     // invoicesSelectByWhereTableAdapter1
     //
     this.invoicesSelectByWhereTableAdapter1.ClearBeforeFill = true;
     //
     // productsInInvoicesSelectByWhereTableAdapter1
     //
     this.productsInInvoicesSelectByWhereTableAdapter1.ClearBeforeFill = true;
     //
     // rptMultiInvoicesToPrint
     //
     this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
         this.Detail,
         this.TopMargin,
         this.BottomMargin,
         this.PageHeader,
         this.GroupFooter2,
         this.DetailReport});
     this.DataAdapter = this.productsInInvoicesSelectByWhereTableAdapter1;
     this.DataMember = "InvoicesSelectByWhere";
     this.DataSource = this.dsMultiInvoicesToPrint1;
     this.Margins = new System.Drawing.Printing.Margins(49, 50, 20, 0);
     this.Version = "11.1";
     ((System.ComponentModel.ISupportInitialize)(this.xrTable7)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.xrTable6)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsMultiInvoicesToPrint1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
        public void Should_fire_actions_against_item_in_subreport()
        {
            var report = new XtraReport();
            var detailBand = new DetailBand();
            report.Bands.Add(detailBand);


            var subreport = new XtraReport();
            var container = new XRSubreport {ReportSource = subreport, Name = "container"};
            detailBand.Controls.Add(container);
            

            var subReportBand = new DetailBand();
            subreport.Bands.Add(subReportBand);
            subReportBand.Controls.Add(new XRLine {Name = "line"});

            var facade =
                new ReportControlActionFacade(ReportControlAction<XRLine>.WithNoPredicate(l => l.ForeColor = Color.Blue));

            var report2 = new ReportController(new EventAggregator(), report, facade).Print(r => r.ExportToMemory());

            var newSubreport =
                ((XRSubreport) report2.Bands[0].Controls[0]).ReportSource;

            ((XRLine) newSubreport.Bands[0].Controls[0]).ForeColor.Should().Be(Color.Blue);

        }
        public void Should_convert_subreport_to_gc_xtra_report()
        {
            var report = new XtraReport();
            var detailBand = new DetailBand();
            var subReportContainer = new XRSubreport { ReportSource = new XtraReport() };
            report.Bands.Add(detailBand);
            detailBand.Controls.Add(subReportContainer);


            var controller = new ReportController(new EventAggregator(), report);
            var newReport = controller.Print(p => p.ExportToMemory());

            var newContainer = (XRSubreport)newReport.Bands[0].Controls[0];
            newContainer.ReportSource.GetType().Should().Be(typeof(gcXtraReport));
        }
        public void Handler_wireup_should_be_predicatable()
        {
            var counter = 0;

            var subReport = new XtraReport();
            var container = new XRSubreport { ReportSource = subReport };

            var detailBand = new DetailBand();
            detailBand.Controls.Add(container);

            var report = new XtraReport();
            report.Bands.Add(detailBand);

            report.DataSource = new[]
                                    {
                                        new object(),
                                        new object(),
                                        new object(),
                                        new object()
                                    };


            var controller = new DataSourceTrackingController(new EventAggregator(), report, (s, ds) => counter++);
            controller.Print(r => r.ExportToMemory());
            counter.Should().Be(4);
        }