public override XRTable GetXRTable(System.Data.DataSet ds) { cellWidth = GetCellWidth(perList, ReportColCnt - 1); XRTable MyTable = new XRTable(); MyTable.SuspendLayout(); MyTable.Width = Width; XRTableRow MyTableRow = new XRTableRow(); MyTableRow.SuspendLayout(); MyTableRow.Width = Width; //������줺�e for (int b = 0; b < ReportColCnt; b++) { if (b != NonShow) { int CellWidth = 0; if (b > NonShow) CellWidth = cellWidth[b - 1]; else CellWidth = cellWidth[b]; XRTableCell MyTableCell = new XRTableCell(); MyTableCell.SuspendLayout(); MyTableCell.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", ds, ds.Relations[0].ParentTable.TableName + "." + ds.Relations[0].RelationName + "." + ds.Relations[0].ChildTable.Columns[b].ColumnName, "")}); MyTableCell.Width = CellWidth; MyTableCell.PerformLayout(); MyTableRow.Cells.Add(MyTableCell); } } MyTable.Borders = DevExpress.XtraPrinting.BorderSide.Bottom; MyTable.Dock = DevExpress.XtraReports.UI.XRDockStyle.Fill; MyTable.Font = new System.Drawing.Font("�з���", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204))); MyTable.Location = new System.Drawing.Point(0, 0); MyTable.ParentStyleUsing.UseBorders = false; MyTable.ParentStyleUsing.UseFont = false; MyTableRow.PerformLayout(); MyTable.Rows.AddRange(new XRTableRow[] { MyTableRow }); MyTable.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; //MyTableRow.EvenStyleName = "EvenStyle"; //MyTableRow.OddStyleName = "OddStyle"; MyTableRow.StyleName = "OddStyle"; MyTable.PerformLayout(); return MyTable; }
private void DisposeTable(XRTable _XRTable) { if (!Object.Equals(xrTable_PhuTungKemTheo, null)) { for (int i = 0; i < _XRTable.Rows.Count; i++) { for (int j = 0; j < _XRTable.Rows[i].Cells.Count; j++) { _XRTable.Rows[i].Cells[j].Dispose(); } _XRTable.Rows[i].Dispose(); } _XRTable.Rows.Clear(); _XRTable.Dispose(); } }
public override XRTable GetXRTable(System.Data.DataSet ds) { int CellWidth = Width / (TitleCnt - 1); XRTable MyTable = new XRTable(); MyTable.SuspendLayout(); MyTable.Width = Width; XRTableRow MyTableRow = new XRTableRow(); MyTableRow.SuspendLayout(); MyTableRow.Width = Width; // ���J�ƭ� XRTableCell MyTableCell = new XRTableCell(); MyTableCell.SuspendLayout(); MyTableCell.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", ds, ds.Tables[myTable.tblDevice.ToString()].Columns[myColumn.Devicename.ToString()].ColumnName, "")}); MyTableCell.Width = CellWidth; MyTableCell.PerformLayout(); MyTableRow.Cells.Add(MyTableCell); MyTable.Borders = DevExpress.XtraPrinting.BorderSide.Bottom; MyTable.Dock = DevExpress.XtraReports.UI.XRDockStyle.Fill; MyTable.Font = new System.Drawing.Font("�з���", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204))); MyTable.Location = new System.Drawing.Point(0, 0); MyTable.ParentStyleUsing.UseBorders = false; MyTable.ParentStyleUsing.UseFont = false; MyTableRow.PerformLayout(); MyTable.Rows.AddRange(new XRTableRow[] { MyTableRow }); MyTable.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; //MyTableRow.EvenStyleName = "EvenStyle"; //MyTableRow.OddStyleName = "OddStyle"; MyTableRow.StyleName = "MasterStyle"; MyTable.PerformLayout(); return MyTable; }
public void Fill(ReportHelper.TableReport report) { var o = (AssayReportViewModel)_r; var cacheKey = string.Format("{0}-{1}", o.ProjectID, o.ReportName); var ds = CacheHelper.AddToCache<DataSet>(() => { return AssayService.ReportAssaysResult(o); }, cacheKey, CacheHelper.DefaultTimeout); report.DataSource = ds; report.Parameters["ParameterProjectID"].Value = o.ProjectID; report.Parameters["ParameterUserName"].Value = o.ReportExecutedByUserName; var tr1 = new XRTableRow { Name = "tr1" }; tr1.Cells.AddRange((from k in ds.Tables[0].Columns.Cast<DataColumn>() select new XRTableCell { Name = k.ColumnName, Text = k.ColumnName }).ToArray()); var h = new XRTable { Name = "h", LocationF = new DevExpress.Utils.PointFloat(0F, 0F), SizeF = new System.Drawing.SizeF(600.0000F, 25F), KeepTogether = true }; h.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { tr1 }); report.Bands["Detail"].Controls.Add(h); var tr2 = new XRTableRow { Name = "tr2" }; tr2.Cells.AddRange((from k in ds.Tables[0].Columns.Cast<DataColumn>() select new XRTableCell { Name = string.Format("{0}_data", k.ColumnName), Text = string.Format("[{0}]",k.ColumnName) }).ToArray()); var t = new XRTable { Name = "t", LocationF = new DevExpress.Utils.PointFloat(0F, 0F), SizeF = new System.Drawing.SizeF(600.0000F, 25F), KeepTogether= true }; t.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { tr2 }); ((DetailReportBand)report.Bands["DetailReport"]).Bands["DetailBand"].Controls.Add(t); }
void InitDetailsAndPageHeader(ASPxGridView aspxGridView1) { ReadOnlyCollection<GridViewDataColumn> groupedColumns = aspxGridView1.GetGroupedColumns(); int pagewidth = (report.PageWidth - (report.Margins.Left + report.Margins.Right)) - groupedColumns.Count * subGroupOffset; List<ColumnInfo> columns = GetColumnsInfo(aspxGridView1, pagewidth); CustomizeColumnsCollection(report, new ColumnsCreationEventArgs(pagewidth) { ColumnsInfo = columns }); report.Bands.Add(new DetailBand() { HeightF = bandHeight }); report.Bands.Add(new PageHeaderBand() { HeightF = bandHeight }); XRTable headerTable = new XRTable(); XRTableRow row = new XRTableRow(); XRTable detailTable = new XRTable(); XRTableRow row2 = new XRTableRow(); for (int i = 0; i < columns.Count; i++) { if (columns[i].IsVisible) { XRTableCell cell = new XRTableCell(); cell.Width = columns[i].ColumnWidth; cell.Text = columns[i].FieldName; row.Cells.Add(cell); XRTableCell cell2 = new XRTableCell(); cell2.Width = columns[i].ColumnWidth; ControlCustomizationEventArgs cc = new ControlCustomizationEventArgs() { FieldName = columns[i].FieldName, IsModified = false, Owner = cell2 }; CustomizeColumn(report, cc); if (cc.IsModified == false) cell2.DataBindings.Add("Text", null, columns[i].FieldName); detailsInfo.Add(columns[i].GridViewColumn, cell2); row2.Cells.Add(cell2); } } headerTable.Rows.Add(row); headerTable.Width = pagewidth; headerTable.LocationF = new PointF(groupedColumns.Count * subGroupOffset, 0); headerTable.Borders = BorderSide.Bottom; detailTable.Rows.Add(row2); detailTable.LocationF = new PointF(groupedColumns.Count * subGroupOffset, 0); detailTable.Width = pagewidth; report.Bands[BandKind.PageHeader].Controls.Add(headerTable); report.Bands[BandKind.Detail].Controls.Add(detailTable); }
public XRTable EncabezadoMesesXRTable() { int lnColumasDinamicas = (1 + Math.Abs((Convert.ToDateTime(FechaInicial.Value).Month - Convert.ToDateTime(FechaFinal.Value).Month) + 12 * (Convert.ToDateTime(FechaInicial.Value).Year - Convert.ToDateTime(FechaFinal.Value).Year))); int lnFilasDinamicas = 2; float lfAlturaFila = 22; XRTable loTabladetalle = new XRTable(); loTabladetalle.Borders = DevExpress.XtraPrinting.BorderSide.None; loTabladetalle.BeginInit(); for (int lnFila = 1; lnFila < lnFilasDinamicas; lnFila++) { XRTableRow row = new XRTableRow(); row.HeightF = lfAlturaFila; for (int lnColumna = 1; lnColumna < lnColumasDinamicas + 1; lnColumna++) { XRTableCell cell = new XRTableCell(); cell.Width = 120; cell.Text = Convert.ToDateTime(FechaInicial.Value).AddMonths(lnColumna - 1).ToString("MMMM", CultureInfo.CreateSpecificCulture("es-MX")).ToUpper().Substring(0, 3) + ". " + Convert.ToDateTime(FechaInicial.Value).Year; cell.Name = "xrAgrupadoMeses" + lnColumna; cell.StylePriority.UseTextAlignment = false; cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; row.Cells.Add(cell); } loTabladetalle.Rows.Add(row); } loTabladetalle.BeforePrint += new PrintEventHandler(EncabezadoMesesXRTable_BeforePrint); loTabladetalle.AdjustSize(); loTabladetalle.EndInit(); return(loTabladetalle); }
public XRTable CreateXRTable() { // Create an empty table and set its size. XRTable table = new XRTable(); table.Size = new Size(300, 100); // Start table initialization. table.BeginInit(); // Enable table borders to see its boundaries. table.BorderWidth = 2; table.Borders = DevExpress.XtraPrinting.BorderSide.All; // Create a table row. XRTableRow row = new XRTableRow(); // Create two table cells. XRTableCell cell0 = new XRTableCell(); XRTableCell cell1 = new XRTableCell(); // Construct the table. row.Cells.Add(cell0); row.Cells.Add(cell1); table.Rows.Add(row); // Finish table initialization. table.EndInit(); return(table); }
public XRTable CreateXRTable(DataTable dt) { int cellsInRow = 3; int rowsCount = 3; float rowHeight = 25f; XRTable table = new XRTable(); table.Borders = DevExpress.XtraPrinting.BorderSide.All; table.BeginInit(); for (int i = 0; i < rowsCount; i++) { XRTableRow row = new XRTableRow(); row.HeightF = rowHeight; for (int j = 0; j < dt.Rows.Count; j++) { XRTableCell cell = new XRTableCell(); if (j == 1) { cell.Text = @"tên cán bộ"; } cell.Text = dt.Rows[0][j].ToString(); row.Cells.Add(cell); table.Rows.Add(row); } } table.BeforePrint += new PrintEventHandler(table_BeforePrint); //.AdjustSize(); table.EndInit(); return(table); }
private void AdjustIcons(XRTable table) { var previousScore = "0"; for (var row = table.Rows.Count - 1; row >= 0; row--) { var score = table.Rows[row].Cells[ScoreColumn].Text; XRPictureBox pb = null; foreach (var control in table.Rows[row].Cells[ChangeColumn].Controls) { if (control.GetType() == typeof(XRPictureBox)) { pb = ((XRPictureBox)control); } } if (pb == null) { continue; } if (pb.ImageUrl == "/Images/change_up_16x12px.png" && GetScore(previousScore) >= GetScore(score)) { pb.ImageUrl = "/Images/change_up_dots_16x12px.png"; } else if (pb.ImageUrl == "/Images/change_down_16x12px.png" && GetScore(previousScore) <= GetScore(score)) { pb.ImageUrl = "/Images/change_down_dots_16x12px.png"; } else if (pb.ImageUrl == "/Images/no_change_16x12px.png" && GetScore(previousScore) != GetScore(score)) { pb.ImageUrl = "/Images/no_change_dots_16x12px.png"; } previousScore = score; } }
// The following code makes the table span to the entire page width. void table_BeforePrint(object sender, PrintEventArgs e) { XRTable table = ((XRTable)sender); table.LocationF = new DevExpress.Utils.PointFloat(0F, 0F); table.WidthF = this.PageWidth - this.Margins.Left - this.Margins.Right; }
private void xrTable5_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { XRTable table = sender as XRTable; if (table == null) { return; } int completion = (int)this.GetCurrentColumnValue("Completion"); switch (completion) { case 0: SetCellsColor(table, backCellColor, backCellColor); break; case 100: SetCellsColor(table, foreCellColor, foreCellColor); break; default: SetCellsColor(table, foreCellColor, backCellColor); table.Rows[0].Cells[0].WidthF = table.WidthF * ((float)completion / 100); break; } }
public static XRTable CreatePageHeaderTable(List <structColumn> ListColumns, int pageWidth, int colWidth, Boolean HaveColumnGroup, int GroupColumnLength) { try { XRTable XRTable_PageHeader = new XRTable(); XRTableRow XRTableRow_PageHeader = new XRTableRow(); if (HaveColumnGroup) { XRTableCell XRTableCell_Cell = new XRTableCell(); XRTableCell_Cell.Width = GroupColumnLength; XRTableCell_Cell.Text = "Nhóm"; XRTableRow_PageHeader.Cells.Add(XRTableCell_Cell); } for (int i = 0; i < ListColumns.Count; i++) { XRTableCell XRTableCell_Cell = new XRTableCell(); XRTableCell_Cell.Width = (int)colWidth; XRTableCell_Cell.Text = ListColumns[i].Caption; XRTableRow_PageHeader.Cells.Add(XRTableCell_Cell); } XRTable_PageHeader.Rows.Add(XRTableRow_PageHeader); XRTable_PageHeader.Width = pageWidth; XRTable_PageHeader.Name = "XRTable_PageHeader"; return(XRTable_PageHeader); } catch { } return(null); }
private void AddContent(DataTable table) { XRTable dynamicTable = XRTable.CreateTable( new Rectangle(0, 0, TableWidth, 20), 1, 0); dynamicTable.Width = TableWidth; dynamicTable.Rows.FirstRow.Width = TableWidth; dynamicTable.Borders = DevExpress.XtraPrinting.BorderSide.All; dynamicTable.BorderWidth = 1; int i = 0; dynamicTable.BeginInit(); foreach (DataColumn dc in table.Columns) { XRTableCell cell = new XRTableCell(); XRBinding binding = new XRBinding("Text", table, table.Columns[i].ColumnName); cell.DataBindings.Add(binding); cell.CanGrow = false; cell.Width = 100; cell.Text = dc.ColumnName; dynamicTable.Rows.FirstRow.Cells.Add(cell); i++; } dynamicTable.Font = new Font("Verdana", 8F); dynamicTable.EndInit(); Detail.HeightF = 20f; Detail.Controls.Add(dynamicTable); }
private void addTable(XRTable tableHeader, XRTable tableDetail, string tableName) { DetailReportBand DetailReportBand1 = new DevExpress.XtraReports.UI.DetailReportBand(); DetailReportBand1.Level = level; GroupHeaderBand GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { tableHeader }); GroupHeader1.Height = 20; GroupHeader1.Name = "GroupHeader" + level.ToString(); GroupHeader1.RepeatEveryPage = true; DetailBand Detail1 = new DevExpress.XtraReports.UI.DetailBand(); Detail1.Height = 20; Detail1.PageBreak = PageBreak.AfterBand; Detail1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { tableDetail }); DetailReportBand1.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { GroupHeader1, Detail1 }); _report.Bands.Add(DetailReportBand1); }
public XRTable CreateXRTable() { int cellsInRow = 3; int rowsCount = 31; float rowHeight = 100f; XRTable table = new XRTable(); table.Borders = DevExpress.XtraPrinting.BorderSide.All; table.BeginInit(); for (int i = 0; i < rowsCount; i++) { XRTableRow row = new XRTableRow(); row.HeightF = rowHeight; for (int j = 0; j < cellsInRow; j++) { XRTableCell cell = new XRTableCell(); row.Cells.Add(cell); } table.Rows.Add(row); } table.BeforePrint += new PrintEventHandler(table_BeforePrint); table.EndInit(); return table; }
private void InitializeContainer() { var table = new XRTable { AnchorHorizontal = HorizontalAnchorStyles.Both, BoundsF = new RectangleF(0F, this.ContainerBand.GetMinPossibleTopPosition(), this.RootReport.GetBandWidth(), 0F), CanGrow = true, CanShrink = true, ForeColor = ReportConstants.Colors.ColumnHeader, BackColor = Color.Transparent, BorderColor = ReportConstants.Colors.Border, Borders = BorderSide.Bottom, BorderWidth = 0.5F, BorderDashStyle = BorderDashStyle.Solid, Padding = new PaddingInfo(2, 2, 1, 1), Font = new Font(FontFamily.GenericSansSerif, 0.09F, FontStyle.Regular, GraphicsUnit.Inch), TextAlignment = TextAlignment.BottomLeft, }; this.ContainerControl = new XRTableRow { Weight = 1D, }; table.Rows.Add(this.ContainerControl); this.ContainerBand.Controls.Add(table); }
private void printHeader(Dictionary <string, string> parameters) { if (parameters.Count == 0) { return; } XRTable table = new XRTable(); table.BeginInit(); table.LocationF = new PointF(0, 0); int count = 0; XRTableRow row = new XRTableRow(); foreach (KeyValuePair <string, string> item in parameters) { XRTableCell cell = new XRTableCell(); cell.Text = item.Key; cell.BackColor = Color.Gray; cell.ForeColor = Color.White; XRTableCell valueCell = new XRTableCell(); valueCell.Text = item.Value; row.Cells.Add(cell); row.Cells.Add(valueCell); count++; if (count % 4 == 0) { table.Rows.Add(row); row = new XRTableRow(); } } if (count % 4 != 0) { for (int i = 0; i < (4 - (count % 4)) * 2; i++) { XRTableCell cell = new XRTableCell(); row.Cells.Add(cell); } table.Rows.Add(row); } table.BeforePrint += new PrintEventHandler(table_BeforePrint); table.AdjustSize(); table.EndInit(); this.PageHeader.Controls.Add(table); }
/// <summary> /// Para insertar una cantidad determinada de filas vacias a una columna y poder llenar /// una pagina. /// <Author>Amilkar Ferrá</Author> /// </summary> /// <param name="aTable"></param> /// <param name="aNumberOfRows"></param> public void AddEmptyRowsToTable(XRTable aTable, int aNumberOfRows) { for (int i = 0; i < aNumberOfRows; i++) { aTable.Rows.Add(new XRTableRow()); } }
public void InitTables(ArrayList columns) { int colCount = columns.Count; int pagewidth = (PageWidth - (Margins.Left + Margins.Right)); int colWidth = pagewidth / colCount; XRTable table = new XRTable(); XRTableRow row = new XRTableRow(); XRTable table2 = new XRTable(); XRTableRow row2 = new XRTableRow(); for (int i = 0; i < colCount; i++) { XRTableCell cell = new XRTableCell(); cell.Width = (int)colWidth; cell.Text = columns[i].ToString(); row.Cells.Add(cell); XRTableCell cell2 = new XRTableCell(); cell2.Width = (int)colWidth; cell2.DataBindings.Add("Text", null, columns[i].ToString()); row2.Cells.Add(cell2); } table.Rows.Add(row); table.Width = pagewidth; table.Borders = BorderSide.Bottom; table2.Rows.Add(row2); table2.Width = pagewidth; Bands[BandKind.PageHeader].Controls.Add(table); Bands[BandKind.Detail].Controls.Add(table2); }
public void Should_fire_actions_on_table_members() { var transformColor = Color.Blue; var action = new ReportControlAction<XRControl>(c => true, c => c.BackColor = transformColor); var table = new XRTable(); var row = new XRTableRow(); var cell = new XRTableCell(); row.Cells.Add(cell); table.Rows.Add(row); var report = new XtraReport(); report.Bands.Add(new DetailBand()); report.Bands[0].Controls.Add(table); //var subscriber = XRRuntimeSubscriber.SubscribeWithActions(action); var reportb = new ReportController(new EventAggregator(), report, new ReportControlActionFacade(action)).Print(r => r.ExportToMemory()); var tableB = (XRTable)reportb.Bands[0].Controls[0]; var rowB = tableB.Rows[0]; var cellb = rowB.Cells[0]; Assert.AreEqual(transformColor, cellb.BackColor); }
private void DesignPanel_ComponentAdded(object sender, System.ComponentModel.Design.ComponentEventArgs e) { PageHeaderBand headerBand; host = (IDesignerHost)designer.DesignRibbonForm.DesignMdiController.ActiveDesignPanel.Report.Site.GetService(typeof(IDesignerHost)); if (!(e.Component is XRLabel) && !(e.Component is XRTable)) { return; } if (e.Component is XRLabel) { XRLabel label = e.Component as XRLabel; if (label.ExpressionBindings.Count == 0) { return; } if (label.Parent is XRTableRow) { return; } headerBand = CreatePageHeaderBand(designer.Report); XRLabel newLabel = CopyLabel(label, headerBand); headerBand.Controls.Add(newLabel); DesignToolHelper.AddToContainer(host, newLabel); } if (e.Component is XRTable) { headerBand = CreatePageHeaderBand(designer.Report); XRTableRow sourceRow = (e.Component as XRTable).Rows[0]; XRTable headerTable = CreateTable(sourceRow, headerBand.HeightF); headerBand.Controls.Add(headerTable); DesignToolHelper.AddToContainer(host, headerTable); } }
public void Assign(XtraReport report, XRTable captionTable, XRTable dataTable) { DetachEvents(); _report = report; _captionTable = captionTable; SetCaptions(); _dataTable = dataTable; WireUpEvents(); // if(ManualFill && ! ManualFillOnly) { XRTableRow dataRow = _dataTable.Rows.FirstRow; _dataTable.InsertRowBelow(dataRow); XRTableRow manualFillRow = _dataTable.Rows[1]; // set tags for cells 1 - 7 (days of week, first cell is name) for(int idx = 0; idx < manualFillRow.Cells.Count; idx++) { if (idx>0 && idx<=7) { manualFillRow.Cells[idx].Tag = dataRow.Cells[idx].Tag; manualFillRow.Cells[idx].BeforePrint += PrintManualFillCell; } manualFillRow.Cells[idx].Borders = dataRow.Cells[idx].Borders; manualFillRow.Cells[idx].Font = dataRow.Cells[idx].Font; } if(!HideSums) { manualFillRow.Cells[8].BackColor = Color.Black; } } }
public static XRTable GetHeaderTable(List <string> fields, float tableSize) { var table = new XRTable(); table.BeginInit(); table.LocationF = new DevExpress.Utils.PointFloat(0F, 0F); table.Borders = DevExpress.XtraPrinting.BorderSide.All; var tableRow = new XRTableRow(); float cellSize = tableSize / fields.Count; foreach (var field in fields) { var cell = new XRTableCell() { Text = field, WidthF = cellSize, BackColor = System.Drawing.Color.Gray }; tableRow.Cells.Add(cell); } table.Rows.Add(tableRow); table.AdjustSize(); table.EndInit(); return(table); }
public static void Localize(XRControl control) { if (control == null) { return; } if (!String.IsNullOrEmpty(control.Name)) { control.Text = GetLocalizeWord(control.Name); } // if (control is XRTable) { XRTable table = control as XRTable; for (int rowIdx = 0; rowIdx < table.Rows.Count; rowIdx++) { foreach (XRTableCell cell in table.Rows[rowIdx].Cells) { cell.Text = GetLocalizeWord(cell.Name); } } } else if (control is Subreport) { Localize(control); } else { for (int i = 0; i < control.Controls.Count; ++i) { Localize(control.Controls[i]); } } }
public static XRTable GetTableBoundToData(List <string> fields, float tableSize) { var table = new XRTable(); table.BeginInit(); table.LocationF = new DevExpress.Utils.PointFloat(0F, 0F); table.Borders = DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom; var tableRow = new XRTableRow(); float cellSize = tableSize / fields.Count; foreach (var field in fields) { var cell = new XRTableCell() { Text = field, WidthF = cellSize }; cell.ExpressionBindings.Add(new ExpressionBinding("Text", $"[{field}]")); tableRow.Cells.Add(cell); } table.Rows.Add(tableRow); table.AdjustSize(); table.EndInit(); return(table); }
public static void AddTablesToReport(XtraReport report) { List <string> fields = new List <string>() { "CompanyName", "ContactName", "Phone", "City" }; XRTable headerTable = GetHeaderTable(fields, report.PageWidth - report.Margins.Left - report.Margins.Right); XRTable table = GetTableBoundToData(fields, report.PageWidth - report.Margins.Left - report.Margins.Right); DetailBand detailBand = report.Bands.GetBandByType(typeof(DetailBand)) as DetailBand; PageHeaderBand pageHeaderBand = report.Bands.GetBandByType(typeof(PageHeaderBand)) as PageHeaderBand; pageHeaderBand.Controls.Add(headerTable); detailBand.Controls.Add(table); pageHeaderBand.HeightF = headerTable.HeightF; detailBand.HeightF = table.HeightF; }
public void Assign(XtraReport report, XRTable captionTable, XRTable dataTable) { DetachEvents(); _report = report; _captionTable = captionTable; SetCaptions(); _dataTable = dataTable; WireUpEvents(); // if (ManualFill && !ManualFillOnly) { XRTableRow dataRow = _dataTable.Rows.FirstRow; _dataTable.InsertRowBelow(dataRow); XRTableRow manualFillRow = _dataTable.Rows[1]; // set tags for cells 1 - 7 (days of week, first cell is name) for (int idx = 0; idx < manualFillRow.Cells.Count; idx++) { if (idx > 0 && idx <= 7) { manualFillRow.Cells[idx].Tag = dataRow.Cells[idx].Tag; manualFillRow.Cells[idx].BeforePrint += PrintManualFillCell; } manualFillRow.Cells[idx].Borders = dataRow.Cells[idx].Borders; manualFillRow.Cells[idx].Font = dataRow.Cells[idx].Font; } if (!HideSums) { manualFillRow.Cells[8].BackColor = Color.Black; } } }
public XRTable CreateXRTable() { int cellsInRow = 3; int rowsCount = 3; float rowHeight = 25f; XRTable table = new XRTable(); table.Borders = DevExpress.XtraPrinting.BorderSide.All; table.BeginInit(); for (int i = 0; i < rowsCount; i++) { XRTableRow row = new XRTableRow(); row.HeightF = rowHeight; for (int j = 0; j < cellsInRow; j++) { XRTableCell cell = new XRTableCell(); row.Cells.Add(cell); } table.Rows.Add(row); } table.BeforePrint += new PrintEventHandler(table_BeforePrint); table.AdjustSize(); table.EndInit(); return(table); }
void Detail_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { var schedule = (Schedule_Report)GetCurrentRow(); XRTable table = new XRTable() { SizeF = new System.Drawing.SizeF(xrPanel2.WidthF, 25F) }; table.BeginInit(); XRTableRow row = new XRTableRow(); row.KeepTogether = false; foreach (var shift in schedule.ShiftPlans) { XRTableCell cell = new XRTableCell { WidthF = xrPanel2.WidthF / schedule.ShiftPlans.Count }; row.Cells.Add(cell); CreateShiftPlanTables(cell, shift, ShiftPlan_Report.GetTrackedResources(shift).ToList()); } table.Rows.Add(row); table.EndInit(); xrPanel2.KeepTogether = false; xrPanel2.Controls.Clear(); xrPanel2.Controls.Add(table); }
private void CreateShiftPlanTables(XRControl parent, ShiftPlan_Report shiftPlan, IList <TrackedResource> trackedResources) { const float margin = 4F; const float tableHeight = 25F; const float offset = tableHeight + margin; float top = margin; float tableWidth = parent.WidthF - (margin * 2); bool isFutureDate = shiftPlan.Date.Date > DateTime.Now.Date; parent.Controls.Clear(); XRTable table = null; bool summaryView = false; var res = Boolean.TryParse(Parameters["SummaryView"].Value.ToString(), out summaryView); // task rows... if (shiftPlan.Tasks.Count > 0) { foreach (var task in shiftPlan.Tasks.Where(task => !summaryView || task.Important)) { XRPanel panel = new XRPanel { WidthF = tableWidth, HeightF = 25F, TopF = top, LeftF = margin, CanGrow = true }; panel.Controls.Add(CreateTasksTable(task, tableWidth)); parent.Controls.Add(panel); top += offset; } } }
public void DataxrCrossTabChange() { string projectnostring = ProjectNOxrLabel.Text.Split('-')[1] + '-' + ProjectNOxrLabel.Text.Split('-')[2]; var costoffer = SQLMethod.Count_Costofferform(projectnostring); var grammar = $"USE [PurchaseProcessSystemDB] Select ProjectName as '名稱',ProjectUnit as '單位',ProjectAmount as '數量',Remark as '備註' FROM Costofferform Where ProjectCode = '{projectnostring}'"; DataTable dataTable = SQLMethod.OutPutTable(grammar); // Create a table and add it to the detail band. XRTable xRTable = new XRTable(); Detail.Controls.Add(xRTable); int numRows = dataTable.Rows.Count; int numCols = dataTable.Columns.Count; xRTable.BeginInit(); for (int i = 0; i < numRows; i++) { XRTableRow xRTableRow = new XRTableRow(); xRTable.Rows.Add(xRTableRow); for (int j = 0; j < numCols; j++) { XRTableCell xRTableCell = new XRTableCell(); xRTable.Rows[i].Cells.Add(xRTableCell); xRTableCell.Text = dataTable.Rows[i][j].ToString(); } } xRTable.HeightF = 38 * numRows; xRTable.WidthF = 777; xRTable.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; xRTable.Borders = DevExpress.XtraPrinting.BorderSide.All; xRTable.EndInit(); }
private XRTable AddQuestionResponse(PatientsWithSpecificResponseDataObject data, int questionCount, PatientsWithSpecificResponseData source) { var cellFont = new Font("Times New Roman", 12F); var tdBlank = new XRTableCell { Text = " ", Multiline = true, CanGrow = true, SizeF = new Size(500, 60), Font = cellFont }; var cellFontBold = new Font("Times New Roman", 12F, FontStyle.Bold); var tb = new XRTable { Tag = "TableBreak", CanGrow = true, WidthF = 880 }; var trHeader = new XRTableRow(); var trData = new XRTableRow(); var trBlankTop = new XRTableRow { HeightF = 60, CanGrow = true }; trBlankTop.Cells.Add(tdBlank); trBlankTop.Cells.Add(tdBlank); tb.Rows.Add(trBlankTop); var tdQuestionNumber = new XRTableCell { Text = source.HeaderQuestion + " " + questionCount, SizeF = new Size(500, 25), Font = cellFontBold }; trHeader.Cells.Add(tdQuestionNumber); var tdSpecificResponseHeader = new XRTableCell { Text = source.HeaderSpecificResponseValue, SizeF = new Size(380, 25), Font = cellFontBold }; trHeader.Cells.Add(tdSpecificResponseHeader); tb.Rows.Add(trHeader); var tdQuestion = new XRTableCell { Text = data.Question, Multiline = true, CanGrow = true, SizeF = new Size(500, 25), Font = cellFont }; trData.Cells.Add(tdQuestion); var tdResponse = new XRTableCell { Text = GetResponsesForHeader(source, data.ItemDefinitionCode), Multiline = true, CanGrow = true, SizeF = new Size(380, 25), Font = cellFont }; trData.Cells.Add(tdResponse); tb.Rows.Add(trData); var trBlankBottom = new XRTableRow { HeightF = 60, CanGrow = true }; trBlankBottom.Cells.Add(tdBlank); trBlankBottom.Cells.Add(tdBlank); tb.Rows.Add(trBlankBottom); return(tb); }
private void Fill(List <CTSLXuat> model, XRTable table) { foreach (var item in model) { var row = SetValues(item); table.Rows.Add(row); } }
void tbl_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { XRTable table = ((XRTable)sender); table.LocationF = new DevExpress.Utils.PointFloat(0F, 0F); table.WidthF = ((sender as XRTable).Report as XtraReport).PageWidth - ((sender as XRTable).Report as XtraReport).Margins.Left - ((sender as XRTable).Report as XtraReport).Margins.Right; }
public override XRTable GetHandler(ArrayList arrList) { XRTable MyTable = new XRTable(); XRTableRow MyTableRow = new XRTableRow(); MyTable.SuspendLayout(); MyTable.Width = Width; cellWidth = GetCellWidth(perList, ReportColCnt); for (int a = 0; a < TitleCnt; a++) { MyTableRow = new XRTableRow(); string[] ReportTitle; MyTableRow.SuspendLayout(); MyTableRow.Width = Width; for (int i = 0; i < ReportColCnt; i++) { int CellWidth = cellWidth[i]; // �ŧi�Ωw�q MyTableCell ���榡 XRTableCell MyTableCell = new XRTableCell(); MyTableCell.SuspendLayout(); string text = arrList[i].ToString(); ReportTitle = text.ToString().Split(','); //MyTableCell.Name = arrList[i].ToString().Substring(0, arrList[i].ToString().IndexOf(",")); //MyTableCell.Text = arrList[i].ToString().Substring(arrList[i].ToString().IndexOf(",") + 1); MyTableCell.Text = ReportTitle[a].ToString(); MyTableCell.Width = CellWidth; MyTableCell.PerformLayout(); MyTableRow.Cells.Add(MyTableCell); } MyTableRow.PerformLayout(); MyTable.Rows.AddRange(new XRTableRow[] { MyTableRow }); } MyTable.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(201)), ((System.Byte)(214)), ((System.Byte)(237))); //MyTable.BorderColor = System.Drawing.Color.FromArgb(((System.Byte)(175)), ((System.Byte)(190)), ((System.Byte)(216))); //MyTable.Borders = DevExpress.XtraPrinting.BorderSide.All; MyTable.Dock = DevExpress.XtraReports.UI.XRDockStyle.Fill; MyTable.Font = new System.Drawing.Font("�з���", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204))); MyTable.Location = new System.Drawing.Point(0, 0); MyTable.ParentStyleUsing.UseBorders = false; MyTable.ParentStyleUsing.UseFont = false; MyTable.Rows.AddRange(new XRTableRow[] { MyTableRow }); //MyTable.Size = new System.Drawing.Size(this.PageWidth - 40, this.ph.Height); MyTable.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; MyTableRow.EvenStyleName = "EvenStyle"; MyTableRow.OddStyleName = "OddStyle"; MyTable.PerformLayout(); return MyTable; }
public void buildDynamicReport(DataSet ds, PageHeaderBand PageHeader, DetailBand Detail) { // create a table to display header XRTable tableHeader = new XRTable(); tableHeader.BeginInit(); tableHeader.Width = (this.PageWidth - (this.Margins.Left + this.Margins.Right)); XRTableRow headerRow = new XRTableRow(); tableHeader.Rows.Add(headerRow); XRTable tableDetail = new XRTable(); tableDetail.BeginInit(); tableDetail.Width = (this.PageWidth - (this.Margins.Left + this.Margins.Right)); XRTable tableDetail2 = new XRTable(); tableDetail2.BeginInit(); tableDetail.Height = 20; tableDetail.Width = (this.PageWidth - (this.Margins.Left + this.Margins.Right)); XRTableRow detailRow = new XRTableRow(); // add detailRow into tableDetails tableDetail.Rows.Add(detailRow); // loop table headercell and table detailCell int i = 0; for (i = 0; i < ds.Tables[1].Rows.Count; i++) { XRTableCell headerCell = new XRTableCell(); headerCell.Width = Int32.Parse(ds.Tables[1].Rows[i][5].ToString()); headerCell.Text = ds.Tables[1].Rows[i][3].ToString(); headerCell.StyleName = ds.Tables[1].Rows[i]["style"].ToString(); XRTableCell detailCell = new XRTableCell(); detailCell.StyleName = ds.Tables[1].Rows[i]["style"].ToString(); detailCell.DataBindings.Add("Text", null, ds.Tables[1].Rows[i]["fieldname"].ToString()); if (i == 0) { headerCell.Borders = BorderSide.Left | BorderSide.Top | BorderSide.Bottom; detailCell.Borders = BorderSide.Left | BorderSide.Top | BorderSide.Bottom; } else { headerCell.Borders = BorderSide.All; detailCell.Borders = BorderSide.All; } headerRow.Cells.Add(headerCell); detailRow.Cells.Add(detailCell); } tableDetail.EndInit(); tableHeader.EndInit(); PageHeader.Controls.Add(tableHeader); Detail.Controls.Add(tableDetail); //this.DataSource = ds; }
private void InsertSafetySlogan(XRTable table) { var row = new XRTableRow(); row.Cells.Add(new XRTableCell { BackColor = ColorTranslator.FromHtml("#002776"), ForeColor = Color.White, Padding = new PaddingInfo(0, 0, 5, 5), Borders = BorderSide.None, Text = GetSafetySlogan(), TextAlignment = TextAlignment.MiddleCenter, Font = StdFont13Bold }); table.Rows.Add(row); }
static void InitDetailsBasedonXRTableRepeatingRowHeader(XtraReport rep, ReportGeneratorType kind, int columnWidth) { Font font = new Font("Tahoma", 9.75f); DataTable dataTable = ((DataSet)rep.DataSource).Tables[0]; int processedPage = 0; int usablePageWidth = rep.PageWidth - (rep.Margins.Left + rep.Margins.Right); List <int> columnsWidth = null; if (kind == ReportGeneratorType.FixedColumnWidth) { columnsWidth = DefineColumnsWidth(columnWidth, dataTable.Columns.Count); } else { columnsWidth = GetColumnsBestFitWidth(dataTable, font); } XRTable tableHeader = null; XRTable tableDetail = null; InitNewTableInstancesAt(rep, font, out tableHeader, out tableDetail, new PointF(0, 0)); tableHeader.BeginInit(); tableDetail.BeginInit(); int i = 1; AddCellsToTables(tableHeader, tableDetail, dataTable.Columns[0], columnsWidth[0], true); int remainingSpace = usablePageWidth - columnsWidth[0]; do { if (columnsWidth[i] > remainingSpace) { processedPage++; tableHeader.WidthF = usablePageWidth - remainingSpace; tableDetail.WidthF = usablePageWidth - remainingSpace; tableHeader.EndInit(); tableDetail.EndInit(); InitNewTableInstancesAt(rep, font, out tableHeader, out tableDetail, new PointF(usablePageWidth * processedPage, 0)); tableHeader.BeginInit(); tableDetail.BeginInit(); AddCellsToTables(tableHeader, tableDetail, dataTable.Columns[0], columnsWidth[0], true); remainingSpace = usablePageWidth - columnsWidth[0]; } else { AddCellsToTables(tableHeader, tableDetail, dataTable.Columns[i], columnsWidth[i], false); remainingSpace -= columnsWidth[i]; i++; } }while(i < columnsWidth.Count); tableHeader.WidthF = usablePageWidth - remainingSpace; tableDetail.WidthF = usablePageWidth - remainingSpace; tableHeader.EndInit(); tableDetail.EndInit(); }
protected XRTable CreatePageHeader(XRTable table, bool includeSafetySlogan = true) { table.WidthF = PageWidth - Margins.Left - Margins.Right; table.Rows.Clear(); if (includeSafetySlogan && !string.IsNullOrEmpty(GetSafetySlogan())) { InsertSafetySlogan(table); } return(table); }
/// <summary> /// Para insertar una cantidad determinada de filas vacias a una columna y poder llenar /// una pagina. /// <Author>Amilkar Ferrá</Author> /// </summary> /// <param name="aTable"></param> /// <param name="aNumberOfRows"></param> public void AddEmptyRowsToTable(XRTable aTable, int aNumberOfRows) { for (int i = 0; i < aNumberOfRows; i++) { aTable.Rows.Add(new XRTableRow() { Height = 20, BorderWidth = 1, Borders = BorderSide.All }); } }
public void InitTables(GridView ip_grv) { ArrayList columnALCaption = new ArrayList(); ArrayList columnAL = new ArrayList(); for (int i = 0; i < ip_grv.Columns.Count; i++) if (ip_grv.Columns[i].Visible && ip_grv.Columns[i].GroupIndex < 0) { columnAL.Add(ip_grv.Columns[i].FieldName); columnALCaption.Add(ip_grv.Columns[i].Caption); } int colCount = columnAL.Count; int pagewidth = (PageWidth - (Margins.Left + Margins.Right) - (m_count_group_col + 1) * 20); int colWidth = pagewidth / colCount; XRTable table = new XRTable(); XRTableRow row = new XRTableRow(); XRTable table2 = new XRTable(); XRTableRow row2 = new XRTableRow(); for (int i = 0; i < colCount; i++) { XRTableCell cell = new XRTableCell(); cell.Width = (int)colWidth; cell.Text = columnALCaption[i].ToString(); row.Cells.Add(cell); XRTableCell cell2 = new XRTableCell(); cell2.Width = (int)colWidth; cell2.DataBindings.Add("Text", null, columnAL[i].ToString()); row2.Cells.Add(cell2); } table.Rows.Add(row); table.Width = pagewidth - (m_count_group_col + 1) * 20; table.Borders = BorderSide.Bottom; table.BackColor = Color.Maroon; table.ForeColor = Color.White; table.StylePriority.UseFont = true; table.Font = new Font(table.Font.FontFamily, 12, FontStyle.Bold); table.Location = new Point(0 + (m_count_group_col + 1) * 20, 0); row2.CanShrink = true; table2.Rows.Add(row2); table2.Width = pagewidth - (m_count_group_col + 1) * 20; table2.Location = new Point(0 + (m_count_group_col + 1) * 20, 0); Bands["PageHeader"].Controls.Add(table); Bands["Detail"].Controls.Add(table2); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> public void InitializeComponent() { string resourceFileName = "OgrenciSinifListesi.resx"; System.Resources.ResourceManager resources = global::Resources.OgrenciSinifListesi.ResourceManager; this.components = new System.ComponentModel.Container(); DevExpress.DataAccess.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo3 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo3 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo4 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo4 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo1 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo1 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo2 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo3 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo4 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo5 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo6 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo7 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo4 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo8 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo9 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo5 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo10 = new DevExpress.DataAccess.Sql.ColumnInfo(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.FieldCaption = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle(); this.DataField = new DevExpress.XtraReports.UI.XRControlStyle(); this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand(); this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand(); 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.sharedImageCollection1 = new DevExpress.Utils.SharedImageCollection(this.components); this.cat_id = new DevExpress.XtraReports.Parameters.Parameter(); this.dersid = new DevExpress.XtraReports.Parameters.Parameter(); this.formattingRule1 = new DevExpress.XtraReports.UI.FormattingRule(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.sharedImageCollection1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.sharedImageCollection1.ImageSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "Tu_SinavConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "CustomSqlQuery"; relationColumnInfo1.NestedKeyColumn = "ogr_no"; relationColumnInfo1.ParentKeyColumn = "ogr_no"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1}); relationInfo1.NestedTable = "Ogrenci"; relationInfo1.ParentTable = "ogr_sinav_derslik"; relationColumnInfo2.NestedKeyColumn = "Sinav_id"; relationColumnInfo2.ParentKeyColumn = "Sinav_id"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2}); relationInfo2.NestedTable = "Sinavlar"; relationInfo2.ParentTable = "ogr_sinav_derslik"; relationColumnInfo3.NestedKeyColumn = "ders_id"; relationColumnInfo3.ParentKeyColumn = "ders_id"; relationInfo3.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo3}); relationInfo3.NestedTable = "Dersler"; relationInfo3.ParentTable = "Sinavlar"; relationColumnInfo4.NestedKeyColumn = "derslik_id"; relationColumnInfo4.ParentKeyColumn = "derslik_id"; relationInfo4.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo4}); relationInfo4.NestedTable = "Derslik"; relationInfo4.ParentTable = "ogr_sinav_derslik"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2, relationInfo3, relationInfo4}); tableInfo1.Name = "ogr_sinav_derslik"; columnInfo1.Name = "ogr_no"; columnInfo2.Name = "Sinav_id"; columnInfo3.Name = "derslik_id"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3}); tableInfo2.Name = "Ogrenci"; columnInfo4.Name = "ogr_adi"; columnInfo5.Name = "ogr_soyadi"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo4, columnInfo5}); tableInfo3.Name = "Sinavlar"; columnInfo6.Name = "ders_id"; columnInfo7.Name = "tarih"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo6, columnInfo7}); tableInfo4.Name = "Dersler"; columnInfo8.Alias = "Dersler_ders_id"; columnInfo8.Name = "ders_id"; columnInfo9.Name = "ders_adi"; tableInfo4.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo8, columnInfo9}); tableInfo5.Name = "Derslik"; columnInfo10.Name = "derslik_adi"; tableInfo5.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo10}); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3, tableInfo4, tableInfo5}); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1}); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2}); this.Detail.HeightF = 24.93844F; this.Detail.MultiColumn.ColumnSpacing = 10F; this.Detail.MultiColumn.ColumnWidth = 355F; this.Detail.MultiColumn.Layout = DevExpress.XtraPrinting.ColumnLayout.AcrossThenDown; this.Detail.MultiColumn.Mode = DevExpress.XtraReports.UI.MultiColumnMode.UseColumnCount; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.StyleName = "DataField"; this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.BackColor = System.Drawing.Color.Transparent; this.xrTable2.BorderColor = System.Drawing.Color.Gainsboro; this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Times New Roman", 12F); this.xrTable2.ForeColor = System.Drawing.Color.Black; this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 2, 2, 100F); this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2}); this.xrTable2.SizeF = new System.Drawing.SizeF(737.5F, 24.39223F); this.xrTable2.StylePriority.UseBackColor = false; this.xrTable2.StylePriority.UseBorderColor = false; this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; this.xrTable2.StylePriority.UseForeColor = false; this.xrTable2.StylePriority.UsePadding = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell5, this.xrTableCell6, this.xrTableCell7, this.xrTableCell8}); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1D; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.ogr_no")}); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Weight = 1D; // // xrTableCell6 // this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.ogr_adi")}); this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Text = "xrTableCell6"; this.xrTableCell6.Weight = 1D; // // xrTableCell7 // this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.ogr_soyadi")}); this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.Text = "xrTableCell7"; this.xrTableCell7.Weight = 1D; // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.derslik_adi")}); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.Weight = 1D; // // 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("Times New Roman", 20F, System.Drawing.FontStyle.Bold); this.Title.ForeColor = System.Drawing.Color.Maroon; this.Title.Name = "Title"; // // FieldCaption // this.FieldCaption.BackColor = System.Drawing.Color.Transparent; this.FieldCaption.BorderColor = System.Drawing.Color.Black; this.FieldCaption.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold); this.FieldCaption.ForeColor = System.Drawing.Color.Maroon; this.FieldCaption.Name = "FieldCaption"; // // PageInfo // this.PageInfo.BackColor = System.Drawing.Color.Transparent; this.PageInfo.BorderColor = System.Drawing.Color.Black; this.PageInfo.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); this.PageInfo.ForeColor = System.Drawing.Color.Black; this.PageInfo.Name = "PageInfo"; // // DataField // this.DataField.BackColor = System.Drawing.Color.Transparent; this.DataField.BorderColor = System.Drawing.Color.Black; this.DataField.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 10F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // topMarginBand1 // this.topMarginBand1.HeightF = 0F; this.topMarginBand1.Name = "topMarginBand1"; // // bottomMarginBand1 // this.bottomMarginBand1.HeightF = 0F; this.bottomMarginBand1.Name = "bottomMarginBand1"; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1}); this.ReportHeader.HeightF = 27.41666F; this.ReportHeader.Name = "ReportHeader"; // // xrLabel1 // this.xrLabel1.BorderColor = System.Drawing.Color.DarkGray; this.xrLabel1.BorderWidth = 14F; this.xrLabel1.Font = new System.Drawing.Font("Times New Roman", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(162))); this.xrLabel1.ForeColor = System.Drawing.Color.Black; this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(253.125F, 26.41666F); this.xrLabel1.StylePriority.UseBorderColor = false; this.xrLabel1.StylePriority.UseBorderWidth = false; this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.StylePriority.UseForeColor = false; this.xrLabel1.Text = "Öğrenci Sınıf Listesi"; // // PageHeader // this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1}); this.PageHeader.HeightF = 33.37498F; this.PageHeader.Name = "PageHeader"; // // xrTable1 // this.xrTable1.BackColor = System.Drawing.Color.SlateGray; this.xrTable1.BorderColor = System.Drawing.Color.Gainsboro; this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Times New Roman", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(162))); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 5, 5, 100F); this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1}); this.xrTable1.SizeF = new System.Drawing.SizeF(737.5F, 32.29167F); this.xrTable1.StylePriority.UseBackColor = false; this.xrTable1.StylePriority.UseBorderColor = false; this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; this.xrTable1.StylePriority.UsePadding = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell1, this.xrTableCell2, this.xrTableCell3, this.xrTableCell4}); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1D; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "Öğrenci Numarası"; this.xrTableCell1.Weight = 1D; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "Öğrenci Adi"; this.xrTableCell2.Weight = 1D; // // xrTableCell3 // this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.Text = "Öğrenci Soyadı"; this.xrTableCell3.Weight = 1D; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "Derslik"; this.xrTableCell4.Weight = 1D; // // sharedImageCollection1 // // // // this.sharedImageCollection1.ImageSource.ImageStream = ((DevExpress.Utils.ImageCollectionStreamer)(resources.GetObject("sharedImageCollection1.ImageSource.ImageStream"))); this.sharedImageCollection1.ParentControl = null; // // cat_id // this.cat_id.Description = "categoryid"; this.cat_id.Name = "cat_id"; this.cat_id.Type = typeof(int); this.cat_id.ValueInfo = "1"; this.cat_id.Visible = false; // // dersid // this.dersid.Description = "dersid"; this.dersid.Name = "dersid"; this.dersid.Type = typeof(int); this.dersid.ValueInfo = "0"; this.dersid.Visible = false; // // formattingRule1 // this.formattingRule1.Name = "formattingRule1"; // // XtraReport1 // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.topMarginBand1, this.bottomMarginBand1, this.ReportHeader, this.PageHeader}); this.ComponentStorage.Add(this.sqlDataSource1); this.DataMember = "CustomSqlQuery"; this.DataSource = this.sqlDataSource1; this.FilterString = "[Sinav_id] = ?dersid"; this.FormattingRuleSheet.AddRange(new DevExpress.XtraReports.UI.FormattingRule[] { this.formattingRule1}); this.Margins = new System.Drawing.Printing.Margins(65, 0, 0, 0); this.PageHeight = 1169; this.PageWidth = 827; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.cat_id, this.dersid}); this.ReportPrintOptions.DetailCountOnEmptyDataSource = 12; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField}); this.Version = "14.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.sharedImageCollection1.ImageSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.sharedImageCollection1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "SinifListesi.resx"; System.Resources.ResourceManager resources = global::Resources.SinifListesi.ResourceManager; DevExpress.DataAccess.Sql.CustomSqlQuery customSqlQuery1 = new DevExpress.DataAccess.Sql.CustomSqlQuery(); DevExpress.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel(); 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.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel(); this.xrTable3 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.FieldCaption = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle(); this.DataField = new DevExpress.XtraReports.UI.XRControlStyle(); this.sinav_id = new DevExpress.XtraReports.Parameters.Parameter(); this.derslikid = new DevExpress.XtraReports.Parameters.Parameter(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "Tu_SinavConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; customSqlQuery1.Name = "ogr_sinav_derslik"; customSqlQuery1.Sql = resources.GetString("customSqlQuery1.Sql"); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { customSqlQuery1}); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // Detail // this.Detail.Borders = DevExpress.XtraPrinting.BorderSide.None; this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel11, this.xrLabel10, this.xrTable1, this.xrLabel13}); this.Detail.HeightF = 23.75F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.StylePriority.UseBorders = false; this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrLabel11 // this.xrLabel11.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel11.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel11.SizeF = new System.Drawing.SizeF(64.06253F, 23.75F); this.xrLabel11.StylePriority.UseBorders = false; this.xrLabel11.StylePriority.UseFont = false; xrSummary1.FormatString = "{0:}"; xrSummary1.Func = DevExpress.XtraReports.UI.SummaryFunc.RecordNumber; xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Report; this.xrLabel11.Summary = xrSummary1; // // xrLabel10 // this.xrLabel10.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel10.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(518.1033F, 0F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel10.SizeF = new System.Drawing.SizeF(131.8967F, 23.75F); this.xrLabel10.StylePriority.UseBorders = false; this.xrLabel10.StylePriority.UseFont = false; // // xrTable1 // this.xrTable1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrTable1.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(75F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1}); this.xrTable1.SizeF = new System.Drawing.SizeF(443.1033F, 23.75F); 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.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1D; // // xrTableCell1 // this.xrTableCell1.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrTableCell1.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ogr_sinav_derslik.ogr_no")}); this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.StylePriority.UseBorderDashStyle = false; this.xrTableCell1.StylePriority.UseBorders = false; this.xrTableCell1.Text = " xrTableCell1"; this.xrTableCell1.Weight = 0.75994065325908811D; // // xrTableCell2 // this.xrTableCell2.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ogr_sinav_derslik.ogr_adi")}); this.xrTableCell2.Multiline = true; this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.xrTableCell2.StylePriority.UseBorders = false; this.xrTableCell2.StylePriority.UsePadding = false; this.xrTableCell2.Text = " xrTableCell2"; this.xrTableCell2.Weight = 1.0306610344403175D; // // xrTableCell3 // this.xrTableCell3.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ogr_sinav_derslik.ogr_soyadi")}); this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.StylePriority.UseBorders = false; this.xrTableCell3.Text = " xrTableCell3"; this.xrTableCell3.Weight = 0.92589477536983389D; // // xrLabel13 // this.xrLabel13.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel13.Font = new System.Drawing.Font("Times New Roman", 9.75F); this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(64.0625F, 0F); this.xrLabel13.Multiline = true; this.xrLabel13.Name = "xrLabel13"; this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel13.SizeF = new System.Drawing.SizeF(10.93748F, 23.75F); this.xrLabel13.StylePriority.UseBorders = false; this.xrLabel13.StylePriority.UseFont = false; this.xrLabel13.Text = "\r\n"; // // TopMargin // this.TopMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel9, this.xrLabel8, this.xrLabel7, this.xrLabel6, this.xrLabel5, this.xrLabel4, this.xrLabel3, this.xrLabel2, this.xrLabel1}); this.TopMargin.HeightF = 83F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrLabel9 // this.xrLabel9.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(0F, 50.24999F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(120.8333F, 16.75F); this.xrLabel9.StylePriority.UseBorders = false; this.xrLabel9.Text = "Sınav Tarih / Saat :"; // // xrLabel8 // this.xrLabel8.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(0F, 33.5F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(75F, 16.74999F); this.xrLabel8.StylePriority.UseBorders = false; this.xrLabel8.Text = "Sınav Türü:"; // // xrLabel7 // this.xrLabel7.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(0F, 16.75F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(75F, 16.75F); this.xrLabel7.StylePriority.UseBorders = false; this.xrLabel7.Text = "Ders Adı:"; // // xrLabel6 // this.xrLabel6.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(75F, 16.75F); this.xrLabel6.StylePriority.UseBorders = false; this.xrLabel6.Text = "Bölüm Adı:"; // // xrLabel5 // this.xrLabel5.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ogr_sinav_derslik.sinav_saati")}); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(195.2141F, 50.24999F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(146.1054F, 16.75F); this.xrLabel5.StylePriority.UseBorders = false; // // xrLabel4 // this.xrLabel4.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ogr_sinav_derslik.tarih")}); this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(120.8333F, 50.24999F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(74.38071F, 16.75F); this.xrLabel4.StylePriority.UseBorders = false; // // xrLabel3 // this.xrLabel3.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ogr_sinav_derslik.ders_adi")}); this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(75F, 16.75F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(485.0694F, 16.75F); this.xrLabel3.StylePriority.UseBorders = false; // // xrLabel2 // this.xrLabel2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ogr_sinav_derslik.sinav_tur")}); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(75F, 33.5F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(100F, 16.74999F); this.xrLabel2.StylePriority.UseBorders = false; // // xrLabel1 // this.xrLabel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ogr_sinav_derslik.bolum_adi")}); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(75F, 0F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(485.0694F, 16.75F); this.xrLabel1.StylePriority.UseBorders = false; // // BottomMargin // this.BottomMargin.Borders = DevExpress.XtraPrinting.BorderSide.None; this.BottomMargin.HeightF = 10.62501F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.StylePriority.UseBorders = false; this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel12, this.xrTable3}); this.reportHeaderBand1.HeightF = 25.00003F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel12 // this.xrLabel12.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel12.SizeF = new System.Drawing.SizeF(64.06253F, 25.00003F); this.xrLabel12.StylePriority.UseBorders = false; this.xrLabel12.Text = "Sıra No"; // // xrTable3 // this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(64.06253F, 0F); this.xrTable3.Name = "xrTable3"; this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow3}); this.xrTable3.SizeF = new System.Drawing.SizeF(585.9374F, 25.00001F); this.xrTable3.StylePriority.UseBorders = false; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell4, this.xrTableCell5, this.xrTableCell7, this.xrTableCell8}); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1D; // // xrTableCell4 // this.xrTableCell4.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.StylePriority.UseBorders = false; this.xrTableCell4.Text = " Öğrenci No"; this.xrTableCell4.Weight = 0.76618290343549933D; // // xrTableCell5 // this.xrTableCell5.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.StylePriority.UseBorders = false; this.xrTableCell5.Text = " Öğrenci Adı"; this.xrTableCell5.Weight = 0.94315419211474694D; // // xrTableCell7 // this.xrTableCell7.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.StylePriority.UseBorders = false; this.xrTableCell7.Text = " Öğrenci Soyadı"; this.xrTableCell7.Weight = 0.94315465469699966D; // // xrTableCell8 // this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.Text = " İmza"; this.xrTableCell8.Weight = 0.77053532448251061D; // // 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("Times New Roman", 20F, System.Drawing.FontStyle.Bold); this.Title.ForeColor = System.Drawing.Color.Maroon; this.Title.Name = "Title"; // // FieldCaption // this.FieldCaption.BackColor = System.Drawing.Color.Transparent; this.FieldCaption.BorderColor = System.Drawing.Color.Black; this.FieldCaption.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold); this.FieldCaption.ForeColor = System.Drawing.Color.Maroon; this.FieldCaption.Name = "FieldCaption"; // // PageInfo // this.PageInfo.BackColor = System.Drawing.Color.Transparent; this.PageInfo.BorderColor = System.Drawing.Color.Black; this.PageInfo.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); this.PageInfo.ForeColor = System.Drawing.Color.Black; this.PageInfo.Name = "PageInfo"; // // DataField // this.DataField.BackColor = System.Drawing.Color.Transparent; this.DataField.BorderColor = System.Drawing.Color.Black; this.DataField.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 10F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // sinav_id // this.sinav_id.Description = "sinav_id"; this.sinav_id.Name = "sinav_id"; this.sinav_id.Type = typeof(int); this.sinav_id.ValueInfo = "1"; this.sinav_id.Visible = false; // // derslikid // this.derslikid.Description = "derslikid"; dynamicListLookUpSettings1.DataAdapter = null; dynamicListLookUpSettings1.DataMember = "ogr_sinav_derslik"; dynamicListLookUpSettings1.DataSource = this.sqlDataSource1; dynamicListLookUpSettings1.DisplayMember = "derslik_id"; dynamicListLookUpSettings1.FilterString = null; dynamicListLookUpSettings1.ValueMember = "derslik_id"; this.derslikid.LookUpSettings = dynamicListLookUpSettings1; this.derslikid.Name = "derslikid"; this.derslikid.Type = typeof(int); this.derslikid.ValueInfo = "0"; this.derslikid.Visible = false; // // SinifListesi // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.reportHeaderBand1}); this.ComponentStorage.Add(this.sqlDataSource1); this.DataMember = "ogr_sinav_derslik"; this.DataSource = this.sqlDataSource1; this.ExportOptions.Image.ExportMode = DevExpress.XtraPrinting.ImageExportMode.DifferentFiles; this.ExportOptions.Image.Format = System.Drawing.Imaging.ImageFormat.Wmf; this.FilterString = "[derslik_id] = ?derslikid And [Sinav_id] = ?sinav_id"; this.Margins = new System.Drawing.Printing.Margins(100, 100, 83, 11); this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.sinav_id, this.derslikid}); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField}); this.Version = "14.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <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(); }
/* void table_Draw(object sender, DrawEventArgs e) { // Set the value to be added to the width of the table's border. var dx = GraphicsUnitConverter.Convert(5, GraphicsUnit.Pixel, e.UniGraphics.PageUnit); // Get the object's current bounds and increase them. var rect = e.Bounds; rect.Inflate(dx / 2, dx / 2); // Store the old clip region. var oldBounds = e.UniGraphics.ClipBounds; // Set the new clip region and draw the borders' rectangle. e.UniGraphics.ClipBounds = rect; e.UniGraphics.DrawRectangle(new Pen(Brushes.Black, dx), rect); // Restore the old clip region. e.UniGraphics.ClipBounds = oldBounds; } */ private void addRowTotale(XRTable table, int? id, TipoTotale tipoTotale, string descrizione = null) { // ================================ // Creazione tabella // ================================ if(descrizione == null) table.BeginInit(); var totaleRow = new XRTableRow { Width = table.Width }; if (!string.IsNullOrEmpty(_impostazioniReport.BorderColor)) totaleRow.BorderColor = ColorTranslator.FromHtml(_impostazioniReport.BorderColor); if (_impostazioniReport.TotaleRowHeight != null) totaleRow.HeightF = _impostazioniReport.TotaleRowHeight.Value; table.Rows.Add(totaleRow); var totaleFont = GetFont(_impostazioniReport.FontName, _impostazioniReport.FontSize, getFontStyle(_impostazioniReport.FontStyle)); if (!string.IsNullOrEmpty(_impostazioniReport.TotaleFontStyle) && !string.IsNullOrEmpty(_impostazioniReport.TotaleFontName) && _impostazioniReport.TotaleFontSize != null) totaleFont = GetFont(_impostazioniReport.TotaleFontName, _impostazioniReport.TotaleFontSize.Value, getFontStyle(_impostazioniReport.TotaleFontStyle)); const TextAlignment footerAlignment = TextAlignment.MiddleRight; var dataSource = _dataSource; var labelPrompt = "Totale Generale"; if (tipoTotale == TipoTotale.Stabile) { dataSource = _dataSource.Where(item => item.IdStabile == id).ToList(); var dataSourceLabel = dataSource.FirstOrDefault(); if(dataSourceLabel != null) labelPrompt = dataSourceLabel.DescrizioneStabile; } else if (tipoTotale == TipoTotale.Scala) { dataSource = _dataSource.Where(item => item.IdGruppoStabile == id).ToList(); var dataSourceLabel = dataSource.FirstOrDefault(); if (dataSourceLabel != null) labelPrompt = dataSourceLabel.DescrizioneGruppoStabile; } else if (tipoTotale == TipoTotale.Nominativo) { dataSource = _dataSource.Where(item => item.IdPersona == id).ToList(); labelPrompt = "Totale nominativo"; if (!string.IsNullOrEmpty(descrizione)) labelPrompt = $"Totale {descrizione}"; } else if (tipoTotale == TipoTotale.SenzaArrotondamenti) { dataSource = _dataSource.Where(item => item.OrdineUnitaImmobiliare != int.MaxValue).ToList(); labelPrompt = "Totale senza arrotondamenti"; } var columns = _ripartoHelper.GetColumnList(_report, null, _parameters, _numeroPagina, _parameters.StampaMillesimi.GetValueOrDefault()); var cellPrompt = new XRTableCell(); totaleRow.Cells.Add(cellPrompt); cellPrompt.Text = labelPrompt; cellPrompt.TextAlignment = footerAlignment; cellPrompt.Padding = getPaddingInfo(); cellPrompt.WidthF = _ripartoHelper.GetColumnWidth(columns, ColumnTypeEnum.OrdineUnita) + _ripartoHelper.GetColumnWidth(columns, ColumnTypeEnum.Nominativo) + _ripartoHelper.GetColumnWidth(columns, ColumnTypeEnum.ProprietaConduzione) + _ripartoHelper.GetColumnWidth(columns, ColumnTypeEnum.Interno) + _ripartoHelper.GetColumnWidth(columns, ColumnTypeEnum.Piano) + _ripartoHelper.GetColumnWidth(columns, ColumnTypeEnum.TipoUnita) + _ripartoHelper.GetColumnWidth(columns, ColumnTypeEnum.Subalterno); cellPrompt.BackColor = ColorTranslator.FromHtml(_impostazioniReport.TotaleBackColor); cellPrompt.Font = totaleFont; foreach (var tableColumn in columns.Where(item => item.ColumnType == ColumnTypeEnum.Conto)) { if (!tableColumn.Hidden && (_numeroPagina == null || tableColumn.PrintPage == _numeroPagina)) { var cell = new XRTableCell { BackColor = ColorTranslator.FromHtml(_impostazioniReport.TotaleBackColor), Font = totaleFont, WidthF = tableColumn.Width, CanGrow = true }; if (_parameters.StampaMillesimi.GetValueOrDefault() && !tableColumn.HideMillesimi) { var tableMillesimi = new XRTable { Borders = BorderSide.None }; var row = new XRTableRow(); tableMillesimi.BeginInit(); // Cell MILLESIMO // ------------- var cellMillesimo = new XRTableCell { BackColor = ColorTranslator.FromHtml(_impostazioniReport.TotaleBackColor), Font = totaleFont, WidthF = tableColumn.Width }; var millesimo = dataSource.Where(item => item.OrdineConto == tableColumn.Order).Sum(item => item.Millesimi).GetValueOrDefault(); if (millesimo != 0) cellMillesimo.Text = (millesimo * 1000).ToString("#0,000"); cellMillesimo.Borders = BorderSide.Right; cellMillesimo.TextAlignment = TextAlignment.MiddleRight; cellMillesimo.Padding = getPaddingInfo(); row.Cells.Add(cellMillesimo); // Cell IMPORTO // ------------- var cellImporto = new XRTableCell { Borders = BorderSide.None, BackColor = ColorTranslator.FromHtml(_impostazioniReport.TotaleBackColor), Font = totaleFont, WidthF = tableColumn.Width }; var importo = dataSource.Where(item => item.OrdineConto == tableColumn.Order).Sum(item => item.Importo.GetValueOrDefault()); if (importo != 0) cellImporto.Text = importo.ToString("c"); cellImporto.TextAlignment = TextAlignment.MiddleRight; cellImporto.Padding = getPaddingInfo(); row.Cells.Add(cellImporto); // Add ROW // ------------- tableMillesimi.Rows.Add(row); cell.Text = string.Empty; cell.Padding = new PaddingInfo(0, 0, 0, 0); cellMillesimo.WidthF = tableColumn.WidthMillesimi.GetValueOrDefault(); cellImporto.WidthF = tableColumn.Width; cell.WidthF = tableColumn.Width + tableColumn.WidthMillesimi.GetValueOrDefault(); tableMillesimi.Width = cell.Width; cell.Controls.Add(tableMillesimi); tableMillesimi.AdjustSize(); tableMillesimi.EndInit(); } else { cell.TextAlignment = TextAlignment.MiddleRight; cell.Padding = getPaddingInfo(); decimal importo; if(tableColumn.Order != 9997) importo = dataSource.Where(item => item.OrdineConto == tableColumn.Order).Sum(item => item.Importo.GetValueOrDefault()); else { importo = dataSource.Where(item => item.OrdineConto == 9994).Sum(item => item.Importo.GetValueOrDefault()) + dataSource.Where(item => item.OrdineConto == 9993).Sum(item => item.Importo.GetValueOrDefault()); } if (importo != 0) cell.Text = importo.ToString("c"); } totaleRow.Cells.Add(cell); } } if (descrizione == null) { table.AdjustSize(); table.EndInit(); } }
/* void table_Draw(object sender, DrawEventArgs e) { // Set the value to be added to the width of the table's border. var dx = GraphicsUnitConverter.Convert(5, GraphicsUnit.Pixel, e.UniGraphics.PageUnit); // Get the object's current bounds and increase them. var rect = e.Bounds; rect.Inflate(dx / 2, dx / 2); // Store the old clip region. var oldBounds = e.UniGraphics.ClipBounds; // Set the new clip region and draw the borders' rectangle. e.UniGraphics.ClipBounds = rect; e.UniGraphics.DrawRectangle(new Pen(Brushes.Black, dx), rect); // Restore the old clip region. e.UniGraphics.ClipBounds = oldBounds; } */ private void addRowTotale(XRTable table, int? id, TipoTotale tipoTotale, string descrizione = null) { // ================================ // Creazione tabella // ================================ if(descrizione == null) table.BeginInit(); var totaleRow = new XRTableRow { Width = table.Width }; if (!string.IsNullOrEmpty(_impostazioniReport.BorderColor)) totaleRow.BorderColor = ColorTranslator.FromHtml(_impostazioniReport.BorderColor); if (_impostazioniReport.TotaleRowHeight != null) totaleRow.HeightF = _impostazioniReport.TotaleRowHeight.Value; table.Rows.Add(totaleRow); var totaleFont = GetFont(_impostazioniReport.FontName, _impostazioniReport.FontSize, getFontStyle(_impostazioniReport.FontStyle)); if (!string.IsNullOrEmpty(_impostazioniReport.TotaleFontStyle) && !string.IsNullOrEmpty(_impostazioniReport.TotaleFontName) && _impostazioniReport.TotaleFontSize != null) totaleFont = GetFont(_impostazioniReport.TotaleFontName, _impostazioniReport.TotaleFontSize.Value, getFontStyle(_impostazioniReport.TotaleFontStyle)); const TextAlignment footerAlignment = TextAlignment.MiddleRight; var dataSource = _dataSource; var labelPrompt = "Totale Generale"; if (tipoTotale == TipoTotale.Stabile) { dataSource = _dataSource.Where(item => item.IdStabile == id).ToList(); var dataSourceLabel = dataSource.FirstOrDefault(); if(dataSourceLabel != null) labelPrompt = dataSourceLabel.DescrizioneStabile; } else if (tipoTotale == TipoTotale.Scala) { dataSource = _dataSource.Where(item => item.IdGruppoStabile == id).ToList(); var dataSourceLabel = dataSource.FirstOrDefault(); if (dataSourceLabel != null) labelPrompt = dataSourceLabel.DescrizioneGruppoStabile; } else if (tipoTotale == TipoTotale.Nominativo) { dataSource = _dataSource.Where(item => item.IdPersona == id).ToList(); labelPrompt = "Totale nominativo"; if (!string.IsNullOrEmpty(descrizione)) labelPrompt = string.Format("Totale {0}", descrizione); } else if (tipoTotale == TipoTotale.SenzaArrotondamenti) { dataSource = _dataSource.Where(item => item.OrdineUnitaImmobiliare != int.MaxValue).ToList(); labelPrompt = "Totale senza arrotondamenti"; } var columns = _pianoRatealeHelper.GetColumnList(_report, null, _parameters, _numeroPagina); var cellPrompt = new XRTableCell(); totaleRow.Cells.Add(cellPrompt); cellPrompt.Text = labelPrompt; cellPrompt.TextAlignment = footerAlignment; cellPrompt.Padding = getPaddingInfo(); cellPrompt.WidthF = _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.OrdineUnita) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.Nominativo) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.ProprietaConduzione) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.Interno) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.Piano) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.TipoUnita) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.Subalterno); cellPrompt.BackColor = ColorTranslator.FromHtml(_impostazioniReport.TotaleBackColor); cellPrompt.Font = totaleFont; foreach (var tableColumn in columns.Where(item => item.ColumnType == ColumnTypeEnum.Conto)) { if (!tableColumn.Hidden && (_numeroPagina == null || tableColumn.PrintPage == _numeroPagina)) { var cell = new XRTableCell { BackColor = ColorTranslator.FromHtml(_impostazioniReport.TotaleBackColor), Font = totaleFont, WidthF = tableColumn.Width, CanGrow = true }; cell.TextAlignment = TextAlignment.MiddleRight; cell.Padding = getPaddingInfo(); var importo = dataSource.Where(item => item.NumeroRata == tableColumn.Order).Sum(item => item.Importo); if (importo != 0) cell.Text = importo.ToString("c"); totaleRow.Cells.Add(cell); } } if (descrizione == null) { table.AdjustSize(); table.EndInit(); } }
private XRTable createDetailTable(IEnumerable<ReportRataSoggettoDTO> dataSource, float locationY) { // ================================ // Creazione tabella // ================================ var table = new XRTable { Borders = BorderSide.All, BorderWidth = 1f, BorderColor = Color.LightGray, LocationF = new PointFloat(10F, locationY) }; if (!string.IsNullOrEmpty(_impostazioniReport.BorderColor)) table.BorderColor = ColorTranslator.FromHtml(_impostazioniReport.BorderColor); table.BeginInit(); var columns = _pianoRatealeHelper.GetColumnList(_report, null, _parameters, _numeroPagina); // ------------------------------------------------------ // Raggruppamento per unità immobiliare // ------------------------------------------------------ IList<IGrouping<int, ReportRataSoggettoDTO>> dataSourceByUnitaImmobiliare = !_parameters.TotalePerPersona ? dataSource.OrderBy(item => item.OrdineUnitaImmobiliare).ThenByDescending(item => item.TipoNominativo).GroupBy(item => item.IdUnitaImmobiliare).ToList() : dataSource.OrderBy(item => item.Nominativo).ThenByDescending(item => item.TipoNominativo).GroupBy(item => item.IdPersona).ToList(); var nominativoPrecedente = string.Empty; var idPersonaPrecedente = 0; foreach (var dataSourceUnitaImmobiliare in dataSourceByUnitaImmobiliare) { // ------------------------------------------------------ // Raggruppamento Proprietario/Conduttore // ------------------------------------------------------ var indexNominativo = 0; var idSoggettoCondominioPrecedente = 0; var dataSourceByNominativo = dataSourceUnitaImmobiliare.GroupBy(item => item.IdSoggettoCondominio.ToString(CultureInfo.InvariantCulture).PadLeft(5, '0')).ToList(); foreach (var dataSourceNominativo in dataSourceByNominativo) { var itemNominativo = dataSourceNominativo.OrderBy(item => item.NumeroRata).FirstOrDefault(); if (itemNominativo != null) { var isArrotondamenti = itemNominativo.OrdineUnitaImmobiliare == int.MaxValue; if (_parameters.TotalePerPersona && idPersonaPrecedente > 0 && idPersonaPrecedente != itemNominativo.IdPersona) { addRowTotale(table, idPersonaPrecedente, TipoTotale.Nominativo, nominativoPrecedente); indexNominativo = 0; } nominativoPrecedente = itemNominativo.Nominativo; idPersonaPrecedente = itemNominativo.IdPersona; var detailRow = new XRTableRow { Width = table.Width }; if (_impostazioniReport.RowHeight != null) detailRow.HeightF = _impostazioniReport.RowHeight.Value; if (_impostazioniReport.ArrotondamentiRowHeight != null) detailRow.HeightF = _impostazioniReport.ArrotondamentiRowHeight.Value; table.Rows.Add(detailRow); foreach (var tableColumn in columns) { if (!tableColumn.Hidden && (!isArrotondamenti || tableColumn.ColumnType == ColumnTypeEnum.Nominativo || tableColumn.ColumnType == ColumnTypeEnum.Conto) && (tableColumn.Order != 9997 || _numeroPagina == null || tableColumn.PrintPage == _numeroPagina)) { var cell = new XRTableCell(); if (!_impostazioniReport.BorderInsideGroup) setCellBorder(cell, dataSourceByNominativo.Count, indexNominativo); cell.WidthF = tableColumn.Width; cell.Font = GetFont(tableColumn.FontName, tableColumn.FontSize, getFontStyle(tableColumn.FontStyle)); if (isArrotondamenti) { var arrotondamentiFont = GetFont(tableColumn.FontName, tableColumn.FontSize, getFontStyle(tableColumn.FontStyle)); if (!string.IsNullOrEmpty(_impostazioniReport.TotaleFontStyle) && !string.IsNullOrEmpty(_impostazioniReport.ArrotondamentiFontName) && _impostazioniReport.ArrotondamentiFontSize != null) { var fontSize = _impostazioniReport.ArrotondamentiFontSize.Value; if (Math.Abs(fontSize) < _pianoRatealeHelper.GetTolerance()) fontSize = 8; arrotondamentiFont = GetFont(_impostazioniReport.ArrotondamentiFontName, fontSize, getFontStyle(_impostazioniReport.ArrotondamentiFontStyle)); } cell.Font = arrotondamentiFont; } if (tableColumn.ColumnType == ColumnTypeEnum.OrdineUnita) { if (indexNominativo == 0 || _impostazioniReport.OrdineUnitaAllRows) { cell.Text = itemNominativo.OrdineUnitaImmobiliare.ToString(CultureInfo.InvariantCulture); cell.TextAlignment = TextAlignment.MiddleRight; cell.Padding = getPaddingInfo(); } if (_impostazioniReport.BorderInsideGroup) setCellBorder(cell, dataSourceByNominativo.Count, indexNominativo); } if (tableColumn.ColumnType == ColumnTypeEnum.Nominativo) { if ((!_parameters.TotalePerPersona && itemNominativo.IdSoggettoCondominio != idSoggettoCondominioPrecedente) || _parameters.TotalePerPersona || isArrotondamenti) cell.Text = itemNominativo.Nominativo; cell.TextAlignment = TextAlignment.MiddleLeft; if (itemNominativo.OrdineUnitaImmobiliare == int.MaxValue) { cell.TextAlignment = TextAlignment.MiddleRight; cell.WidthF = _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.OrdineUnita) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.Nominativo) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.ProprietaConduzione) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.Interno) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.Piano) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.TipoUnita) + _pianoRatealeHelper.GetColumnWidth(columns, ColumnTypeEnum.Subalterno); } cell.Padding = getPaddingInfo(); } if (itemNominativo.OrdineUnitaImmobiliare != int.MaxValue) { if (tableColumn.ColumnType == ColumnTypeEnum.TipoUnita) { if (itemNominativo.IdSoggettoCondominio != idSoggettoCondominioPrecedente) cell.Text = itemNominativo.TipoUnitaImmobiliare; cell.TextAlignment = TextAlignment.MiddleLeft; cell.Padding = getPaddingInfo(); } if (tableColumn.ColumnType == ColumnTypeEnum.Subalterno) { if (itemNominativo.IdSoggettoCondominio != idSoggettoCondominioPrecedente) cell.Text = itemNominativo.SubalternoUnitaImmobiliare; cell.TextAlignment = TextAlignment.MiddleLeft; cell.Padding = getPaddingInfo(); } if (tableColumn.ColumnType == ColumnTypeEnum.Interno) { if (itemNominativo.IdSoggettoCondominio != idSoggettoCondominioPrecedente) cell.Text = itemNominativo.InternoUnitaImmobiliare; cell.TextAlignment = TextAlignment.MiddleLeft; cell.Padding = getPaddingInfo(); } if (tableColumn.ColumnType == ColumnTypeEnum.Piano) { if (itemNominativo.IdSoggettoCondominio != idSoggettoCondominioPrecedente) cell.Text = itemNominativo.PianoUnitaImmobiliare; cell.TextAlignment = TextAlignment.MiddleRight; cell.Padding = getPaddingInfo(); } if (tableColumn.ColumnType == ColumnTypeEnum.ProprietaConduzione) { cell.Text = itemNominativo.TipoNominativo.Substring(0, 1).ToUpper(); cell.TextAlignment = TextAlignment.MiddleLeft; cell.Padding = getPaddingInfo(); } } if (tableColumn.ColumnType == ColumnTypeEnum.Conto) { cell.TextAlignment = TextAlignment.MiddleRight; cell.Padding = getPaddingInfo(); var importo = dataSourceNominativo.Where(item => item.NumeroRata == tableColumn.Order).Sum(item => item.Importo); if (importo != 0) cell.Text = importo.ToString("c"); } detailRow.Cells.Add(cell); } } idSoggettoCondominioPrecedente = itemNominativo.IdSoggettoCondominio; } indexNominativo++; } } // Ultimo totale if (_parameters.TotalePerPersona && idPersonaPrecedente > 0) addRowTotale(table, idPersonaPrecedente, TipoTotale.Nominativo, nominativoPrecedente); table.BeforePrint += tableDetailBeforePrint; table.AdjustSize(); table.EndInit(); return table; }
public static XRTable CreateLastSUMTable(XtraReport _XtraReport, List<structColumn> ListColumns, int pageWidth, int colWidth, Boolean HaveGroup, int GroupColumnLength) { if (ListColumns.Where(item => item.IsNumber == true).ToList().Count > 0) { XRTable XRTable_Sum = new XRTable(); XRTableRow XRTableRow_Sum = new XRTableRow(); if (HaveGroup && GroupColumnLength > 0) { XRTableCell XRTableCell_CellFirst = new XRTableCell(); XRTableCell_CellFirst.Width = GroupColumnLength; XRTableCell_CellFirst.Text = ""; XRTableRow_Sum.Cells.Add(XRTableCell_CellFirst); } for (int i = 0; i < ListColumns.Count; i++) { XRTableCell XRTableCell_Cell = new XRTableCell(); XRTableCell_Cell.Width = (int)colWidth; if (ListColumns[i].IsNumber) { XRTableCell_Cell.DataBindings.Add("Text", _XtraReport.DataSource, ListColumns[i].FieldName); XRTableCell_Cell.Summary.IgnoreNullValues = true; XRTableCell_Cell.Summary.Func = SummaryFunc.Sum; XRTableCell_Cell.Summary.Running = SummaryRunning.Report; XRTableCell_Cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; } else { XRTableCell_Cell.Text = ""; } XRTableRow_Sum.Cells.Add(XRTableCell_Cell); } XRTable_Sum.Rows.Add(XRTableRow_Sum); //XRTable_Sum.Width = pageWidth; //XRTable_Sum.LocationF = new DevExpress.Utils.PointFloat(0F, 0F); return XRTable_Sum; } return null; }
public static XRTable CreatePageHeaderTable(List<structColumn> ListColumns, int pageWidth, int colWidth, Boolean HaveColumnGroup, int GroupColumnLength) { try { XRTable XRTable_PageHeader = new XRTable(); XRTableRow XRTableRow_PageHeader = new XRTableRow(); if (HaveColumnGroup) { XRTableCell XRTableCell_Cell = new XRTableCell(); XRTableCell_Cell.Width = GroupColumnLength; XRTableCell_Cell.Text = "Nhóm"; XRTableRow_PageHeader.Cells.Add(XRTableCell_Cell); } for (int i = 0; i < ListColumns.Count; i++) { XRTableCell XRTableCell_Cell = new XRTableCell(); XRTableCell_Cell.Width = (int)colWidth; XRTableCell_Cell.Text = ListColumns[i].Caption; XRTableRow_PageHeader.Cells.Add(XRTableCell_Cell); } XRTable_PageHeader.Rows.Add(XRTableRow_PageHeader); XRTable_PageHeader.Width = pageWidth; XRTable_PageHeader.Name = "XRTable_PageHeader"; return XRTable_PageHeader; } catch { } return null; }
private XRTable createHeaderTable() { // ================================ // Creazione tabella // ================================ var table = new XRTable { Borders = BorderSide.Top | BorderSide.Left | BorderSide.Right, BorderWidth = 1f, BorderColor = Color.LightGray }; if (!string.IsNullOrEmpty(_impostazioniReport.BorderColor)) table.BorderColor = ColorTranslator.FromHtml(_impostazioniReport.BorderColor); table.BeginInit(); addRowHeader(table); table.BeforePrint += tableHeaderBeforePrint; table.AdjustSize(); table.EndInit(); return table; }
private void addRowHeader(XRTable table) { // ================================ // Header Row // ================================ var headerRow = new XRTableRow(); headerRow.Borders = BorderSide.All; if (_impostazioniReport.HeaderRowHeight != null) headerRow.HeightF = _impostazioniReport.HeaderRowHeight.Value; var headerFont = GetFont(_impostazioniReport.FontName, _impostazioniReport.FontSize, getFontStyle(_impostazioniReport.FontStyle)); if (!string.IsNullOrEmpty(_impostazioniReport.HeaderFontStyle) && !string.IsNullOrEmpty(_impostazioniReport.HeaderFontName) && _impostazioniReport.HeaderFontSize != null) headerFont = GetFont(_impostazioniReport.HeaderFontName, _impostazioniReport.HeaderFontSize.Value, getFontStyle(_impostazioniReport.HeaderFontStyle)); var headerAlignment = TextAlignment.TopCenter; if (_impostazioniReport.HeaderAlignment != null) headerAlignment = GetTextAlignment(_impostazioniReport.HeaderAlignment); var columns = _pianoRatealeHelper.GetColumnList(_report, null, _parameters, _numeroPagina); foreach (var tableColumn in columns) { if (!tableColumn.Hidden && (tableColumn.Order != 9997 || _numeroPagina == null || tableColumn.PrintPage == _numeroPagina)) { var cell = new XRTableCell { Font = headerFont, Text = tableColumn.Description, TextAlignment = headerAlignment, WidthF = tableColumn.Width }; if (tableColumn.ColumnType == ColumnTypeEnum.Conto) cell.BackColor = ColorTranslator.FromHtml(_impostazioniReport.HeaderBackColor); cell.Padding = getPaddingInfo(); headerRow.Cells.Add(cell); } } table.Rows.Add(headerRow); }
private void InitializeComponent() { this.dtl = new DevExpress.XtraReports.UI.DetailBand(); 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.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableRow4 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableRow6 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.ph = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xlblReportHeader = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrPageInfo = new DevExpress.XtraReports.UI.XRPageInfo(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.xlblTimeRange = new DevExpress.XtraReports.UI.XRLabel(); this.xlblMemo = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // dtl // this.dtl.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1}); this.dtl.Font = new System.Drawing.Font("標楷體", 9.75F); this.dtl.Height = 744; this.dtl.Name = "dtl"; this.dtl.ParentStyleUsing.UseFont = false; // // xrTable1 // this.xrTable1.BorderColor = System.Drawing.SystemColors.WindowText; this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Location = new System.Drawing.Point(17, 17); this.xrTable1.Name = "xrTable1"; this.xrTable1.ParentStyleUsing.UseBackColor = false; this.xrTable1.ParentStyleUsing.UseBorderColor = false; this.xrTable1.ParentStyleUsing.UseBorders = false; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1, this.xrTableRow2, this.xrTableRow3, this.xrTableRow4, this.xrTableRow6, this.xrTableRow5}); this.xrTable1.Size = new System.Drawing.Size(758, 727); // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell1, this.xrTableCell2}); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Size = new System.Drawing.Size(758, 30); // // xrTableCell1 // this.xrTableCell1.Font = new System.Drawing.Font("標楷體", 12F); this.xrTableCell1.Location = new System.Drawing.Point(0, 0); this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.ParentStyleUsing.UseFont = false; this.xrTableCell1.Size = new System.Drawing.Size(379, 30); this.xrTableCell1.Text = "日期:"; // // xrTableCell2 // this.xrTableCell2.Font = new System.Drawing.Font("標楷體", 12F); this.xrTableCell2.Location = new System.Drawing.Point(379, 0); this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.ParentStyleUsing.UseFont = false; this.xrTableCell2.Size = new System.Drawing.Size(379, 30); this.xrTableCell2.Text = "時間:"; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell3}); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Size = new System.Drawing.Size(758, 63); // // xrTableCell3 // this.xrTableCell3.Font = new System.Drawing.Font("標楷體", 12F); this.xrTableCell3.Location = new System.Drawing.Point(0, 0); this.xrTableCell3.Multiline = true; this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.ParentStyleUsing.UseFont = false; this.xrTableCell3.Size = new System.Drawing.Size(758, 63); this.xrTableCell3.Text = "播報內容:\r\n1.事故"; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell5}); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Size = new System.Drawing.Size(758, 84); // // xrTableCell5 // this.xrTableCell5.Font = new System.Drawing.Font("標楷體", 12F); this.xrTableCell5.Location = new System.Drawing.Point(0, 0); this.xrTableCell5.Multiline = true; this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.ParentStyleUsing.UseFont = false; this.xrTableCell5.Size = new System.Drawing.Size(758, 84); this.xrTableCell5.Text = "\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n"; // // xrTableRow4 // this.xrTableRow4.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell4}); this.xrTableRow4.Name = "xrTableRow4"; this.xrTableRow4.Size = new System.Drawing.Size(758, 398); // // xrTableCell4 // this.xrTableCell4.Font = new System.Drawing.Font("標楷體", 12F); this.xrTableCell4.Location = new System.Drawing.Point(0, 0); this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.ParentStyleUsing.UseFont = false; this.xrTableCell4.Size = new System.Drawing.Size(758, 300); this.xrTableCell4.Text = "3.施工(國道1號 國道3號 國道4號 國道6號)"; // // xrTableRow6 // this.xrTableRow6.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell7}); this.xrTableRow6.Name = "xrTableRow6"; this.xrTableRow6.Size = new System.Drawing.Size(758, 76); // // xrTableCell7 // this.xrTableCell7.Font = new System.Drawing.Font("標楷體", 12F); this.xrTableCell7.Location = new System.Drawing.Point(0, 0); this.xrTableCell7.Multiline = true; this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.ParentStyleUsing.UseFont = false; this.xrTableCell7.Size = new System.Drawing.Size(758, 76); this.xrTableCell7.Text = "4.其他相關宣導\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n"; // // xrTableRow5 // this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell6}); this.xrTableRow5.Name = "xrTableRow5"; this.xrTableRow5.Size = new System.Drawing.Size(758, 76); // // xrTableCell6 // this.xrTableCell6.Font = new System.Drawing.Font("標楷體", 12F); this.xrTableCell6.Location = new System.Drawing.Point(0, 0); this.xrTableCell6.Multiline = true; this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.ParentStyleUsing.UseFont = false; this.xrTableCell6.Size = new System.Drawing.Size(758, 76); this.xrTableCell6.Text = "以上路況 資訊,由高速公路局中區工程處交控中心提供,祝您行車平安。"; // // ph // this.ph.Font = new System.Drawing.Font("標楷體", 9.75F); this.ph.Height = 0; this.ph.Name = "ph"; this.ph.ParentStyleUsing.UseFont = false; // // xlblReportHeader // this.xlblReportHeader.BackColor = System.Drawing.Color.Empty; this.xlblReportHeader.BorderColor = System.Drawing.SystemColors.Control; this.xlblReportHeader.Font = new System.Drawing.Font("標楷體", 20.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xlblReportHeader.ForeColor = System.Drawing.SystemColors.Desktop; this.xlblReportHeader.Location = new System.Drawing.Point(83, 42); this.xlblReportHeader.Name = "xlblReportHeader"; this.xlblReportHeader.ParentStyleUsing.UseBackColor = false; this.xlblReportHeader.ParentStyleUsing.UseBorderColor = false; this.xlblReportHeader.ParentStyleUsing.UseFont = false; this.xlblReportHeader.ParentStyleUsing.UseForeColor = false; this.xlblReportHeader.Size = new System.Drawing.Size(659, 33); this.xlblReportHeader.Text = "交通部台灣區國道高速公路中區工程處交控中心"; this.xlblReportHeader.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel1 // this.xrLabel1.Font = new System.Drawing.Font("標楷體", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel1.ForeColor = System.Drawing.SystemColors.Desktop; this.xrLabel1.Location = new System.Drawing.Point(967, 108); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.ParentStyleUsing.UseFont = false; this.xrLabel1.ParentStyleUsing.UseForeColor = false; this.xrLabel1.Size = new System.Drawing.Size(108, 25); this.xrLabel1.Text = "頁次:"; this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // xrPageInfo // this.xrPageInfo.Font = new System.Drawing.Font("標楷體", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrPageInfo.ForeColor = System.Drawing.SystemColors.Desktop; this.xrPageInfo.Location = new System.Drawing.Point(1075, 108); this.xrPageInfo.Name = "xrPageInfo"; this.xrPageInfo.ParentStyleUsing.UseFont = false; this.xrPageInfo.ParentStyleUsing.UseForeColor = false; this.xrPageInfo.Size = new System.Drawing.Size(50, 25); this.xrPageInfo.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // TopMargin // this.TopMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xlblTimeRange, this.xrPageInfo, this.xrLabel1, this.xlblMemo, this.xlblReportHeader}); this.TopMargin.Font = new System.Drawing.Font("標楷體", 9.75F); this.TopMargin.Height = 142; this.TopMargin.Name = "TopMargin"; this.TopMargin.ParentStyleUsing.UseFont = false; // // xlblTimeRange // this.xlblTimeRange.Font = new System.Drawing.Font("標楷體", 14F); this.xlblTimeRange.ForeColor = System.Drawing.SystemColors.Desktop; this.xlblTimeRange.Location = new System.Drawing.Point(175, 92); this.xlblTimeRange.Name = "xlblTimeRange"; this.xlblTimeRange.ParentStyleUsing.UseFont = false; this.xlblTimeRange.ParentStyleUsing.UseForeColor = false; this.xlblTimeRange.Size = new System.Drawing.Size(408, 25); this.xlblTimeRange.Text = " 每日定時路況簡報新聞稿草稿"; this.xlblTimeRange.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // xlblMemo // this.xlblMemo.Font = new System.Drawing.Font("標楷體", 9.75F); this.xlblMemo.ForeColor = System.Drawing.SystemColors.Desktop; this.xlblMemo.Location = new System.Drawing.Point(967, 83); this.xlblMemo.Name = "xlblMemo"; this.xlblMemo.ParentStyleUsing.UseFont = false; this.xlblMemo.ParentStyleUsing.UseForeColor = false; this.xlblMemo.Size = new System.Drawing.Size(158, 25); this.xlblMemo.Text = "中區-RPT_DATA_06"; this.xlblMemo.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // clsNewsPaper // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.dtl, this.ph, this.TopMargin}); this.Margins = new System.Drawing.Printing.Margins(20, 20, 142, 75); this.PageHeight = 1169; this.PageWidth = 827; this.PaperKind = System.Drawing.Printing.PaperKind.A4; ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
private XRTable createRiepilogoTable(decimal importo, float locationY) { // ================================ // Creazione tabella // ================================ var marginTop = 30; if (_impostazioniReport.RiepilogoTopMargin != null) marginTop = _impostazioniReport.RiepilogoTopMargin.Value; var fontRiepilogo = GetFont(_impostazioniReport.FontName, _impostazioniReport.FontSize, FontStyle.Bold); if(!string.IsNullOrEmpty(_impostazioniReport.RiepilogoFontName) && _impostazioniReport.RiepilogoFontSize != null) fontRiepilogo = GetFont(_impostazioniReport.RiepilogoFontName, _impostazioniReport.RiepilogoFontSize.Value, getFontStyle(_impostazioniReport.RiepilogoFontStyle)); var fontImportoRiepilogo = (Font)fontRiepilogo.Clone(); if (!string.IsNullOrEmpty(_impostazioniReport.ImportoRiepilogoFontName) && _impostazioniReport.ImportoRiepilogoFontSize != null) fontImportoRiepilogo = GetFont(_impostazioniReport.ImportoRiepilogoFontName, _impostazioniReport.ImportoRiepilogoFontSize.Value, getFontStyle(_impostazioniReport.ImportoRiepilogoFontStyle)); var table = new XRTable { Borders = BorderSide.None, LocationF = new PointFloat(10F, locationY + marginTop), Font = fontRiepilogo, Width = 800 }; table.BeginInit(); //if (_parameters.TipoRendiconto == TipoRendiconto.Consuntivo) //{ // var row = new XRTableRow(); // table.Rows.Add(row); // var cellPrompt = new XRTableCell // { // Text = "Saldo Attuale: ", // Font = fontRiepilogo, // TextAlignment = TextAlignment.MiddleLeft, // Padding = new PaddingInfo(5,5,5,5), // Borders = BorderSide.Bottom | BorderSide.Left | BorderSide.Top // }; // if (!string.IsNullOrEmpty(_impostazioniReport.RiepilogoText)) // cellPrompt.Text = _impostazioniReport.RiepilogoText; // row.Cells.Add(cellPrompt); // var cellValue = new XRTableCell // { // Text = importo.ToString("C"), // Font = fontImportoRiepilogo, // TextAlignment = TextAlignment.MiddleRight, // Padding = new PaddingInfo(5, 5, 5, 5), // Borders = BorderSide.Bottom | BorderSide.Right | BorderSide.Top // }; // row.Cells.Add(cellValue); //} table.AdjustSize(); table.EndInit(); return table; }
private void Build() { this.PaperKind = PaperKind.A4; try { var query = _reportData[0].Values.Keys.First(); xrLabel2.Text = query.content.StartsWith("@") ? "Паспорт" : query.form.name; } catch { } var headerTable = new XRTable { Borders = BorderSide.Left | BorderSide.Right, BorderColor = Color.FromArgb(245, 245, 245), Font = new Font("Segoe UI", 9), BackColor = Color.FromArgb(37, 116, 169), ForeColor = Color.FromArgb(245, 245, 245), LocationF = new PointFloat(0F, 0F), WidthF = this.PageWidth - this.Margins.Left - this.Margins.Right }; var headerRow = new XRTableRow { HeightF = 64 }; var fstCell = new XRTableCell { Text = "Образовательная орг.", TextAlignment = TextAlignment.MiddleCenter }; headerRow.Cells.Add(fstCell); foreach (var pair in _reportData[0].Values) //шапка таблицы с заголовками запросов { var cell = new XRTableCell(); cell.Text = pair.Key.title; cell.TextAlignment = TextAlignment.MiddleCenter; headerRow.Cells.Add(cell); } headerTable.Rows.Add(headerRow); if (headerTable.Rows.FirstRow.Cells[0].WidthF <= 100) { this.Landscape = true; headerTable.WidthF = this.PageWidth - Margins.Left - Margins.Right; } this.PageHeader.Controls.Add(headerTable); var table = new XRTable { Borders = BorderSide.All, ForeColor = Color.FromArgb(59, 59, 59), BorderColor = Color.FromArgb(37, 116, 169), LocationF = new PointFloat(0F, 0F), WidthF = this.PageWidth - this.Margins.Left - this.Margins.Right }; table.BeginInit(); var summaryRow = new XRTableRow { BackColor = Color.FromArgb(37, 116, 169), ForeColor = Color.FromArgb(245, 245, 245), Font = new Font("Segoe UI", 9) }; var sumFstCell = new XRTableCell { Text = "Итого", TextAlignment = TextAlignment.MiddleLeft }; summaryRow.Cells.Add(sumFstCell); for (var i = 0; i < _reportData[0].Values.Count; i++) //считается итого { var sum = 0; for (var j = 0; j < _reportData.Count; j++) { var arr = new object[_reportData[j].Values.Values.Count]; _reportData[j].Values.Values.CopyTo(arr, 0); var strVal = (string)arr[i]; int intVal; sum += Int32.TryParse(strVal, out intVal) ? intVal : 0; } var cell = new XRTableCell { Text = sum.ToString(), TextAlignment = TextAlignment.MiddleCenter }; summaryRow.Cells.Add(cell); } var grouped = _reportData.GroupBy(t => t.GroupHead); foreach (var group in grouped) { if (!string.IsNullOrEmpty(group.Key)) { var groupRow = new XRTableRow() { HeightF = 32 }; var cell = new XRTableCell { Text = group.Key, TextAlignment = TextAlignment.MiddleCenter }; groupRow.Cells.Add(cell); table.Rows.Add(groupRow); } foreach (var data in group) { var row = new XRTableRow { HeightF = 32 }; var cell1 = new XRTableCell { Text = data.Head, TextAlignment = TextAlignment.MiddleLeft }; row.Cells.Add(cell1); foreach (var pair in data.Values) { var cell3 = new XRTableCell { Text = (string)pair.Value, TextAlignment = TextAlignment.MiddleCenter }; row.Cells.Add(cell3); } table.Rows.Add(row); } } table.Rows.Add(summaryRow); table.EndInit(); this.Detail.Controls.Add(table); }
private float getLocation(XRTable table) { var locationY = 0f; if (table != null) { table.AdjustSize(); locationY = table.HeightF + table.Location.Y; } //foreach (var xrPageBreak in pageBreaks) //{ // if (xrPageBreak.Location.Y > locationY) // locationY = xrPageBreak.Location.Y; //} return locationY + .01f; }
private List<XRControl> VisitTableChildren(XRTable table) { // XRTableRows return table.Rows.Cast<XRControl>().ToList(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "StepReport.resx"; this.components = new System.ComponentModel.Container(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.tblActs = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell1 = 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.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.srcActs = new System.Windows.Forms.BindingSource(this.components); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell22 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell19 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell23 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell24 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell25 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell26 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell21 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell27 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTable5 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow6 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell45 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell46 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell47 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell48 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell49 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell50 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell51 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell52 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell53 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell54 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell55 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell56 = new DevExpress.XtraReports.UI.XRTableCell(); this.DetailReport = new DevExpress.XtraReports.UI.DetailReportBand(); this.detailSteps = new DevExpress.XtraReports.UI.DetailBand(); this.tblSteps = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell32 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrTable3 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow4 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell31 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell28 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell29 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell30 = new DevExpress.XtraReports.UI.XRTableCell(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrTable4 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell33 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell34 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell35 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell36 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell37 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell38 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell39 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell40 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell41 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell42 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell43 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell44 = new DevExpress.XtraReports.UI.XRTableCell(); ((System.ComponentModel.ISupportInitialize)(this.tblActs)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.srcActs)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.tblSteps)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.tblActs}); this.Detail.HeightF = 15F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; this.Detail.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.Detail_BeforePrint); // // tblActs // this.tblActs.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.tblActs.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.tblActs.Name = "tblActs"; this.tblActs.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1}); this.tblActs.SizeF = new System.Drawing.SizeF(1069F, 15F); this.tblActs.StylePriority.UseBorders = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell14, this.xrTableCell15, this.xrTableCell1, this.xrTableCell7, this.xrTableCell8, this.xrTableCell9, this.xrTableCell2, this.xrTableCell10, this.xrTableCell3, this.xrTableCell12, this.xrTableCell13, this.xrTableCell11}); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1D; // // xrTableCell14 // this.xrTableCell14.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "MeteringDate", "{0:dd.MM.yyyy}")}); this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.StylePriority.UseBorders = false; this.xrTableCell14.StylePriority.UseTextAlignment = false; this.xrTableCell14.Text = "xrTableCell14"; this.xrTableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell14.Weight = 0.091450357298137608D; // // xrTableCell15 // this.xrTableCell15.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "StateName")}); this.xrTableCell15.Name = "xrTableCell15"; this.xrTableCell15.StylePriority.UseBorders = false; this.xrTableCell15.StylePriority.UseTextAlignment = false; this.xrTableCell15.Text = "xrTableCell15"; this.xrTableCell15.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell15.Weight = 0.10669208251214116D; // // xrTableCell1 // this.xrTableCell1.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "EmployeeName")}); this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.StylePriority.UseBorders = false; this.xrTableCell1.StylePriority.UseTextAlignment = false; this.xrTableCell1.Text = "xrTableCell1"; this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; this.xrTableCell1.Weight = 0.27435106813559013D; // // xrTableCell7 // this.xrTableCell7.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "UnitName")}); this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.StylePriority.UseBorders = false; this.xrTableCell7.StylePriority.UseTextAlignment = false; this.xrTableCell7.Text = "xrTableCell7"; this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; this.xrTableCell7.Weight = 0.18290071309274597D; // // xrTableCell8 // this.xrTableCell8.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Address")}); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.StylePriority.UseBorders = false; this.xrTableCell8.StylePriority.UseTextAlignment = false; this.xrTableCell8.Text = "xrTableCell8"; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; this.xrTableCell8.Weight = 0.22862589249357956D; // // xrTableCell9 // this.xrTableCell9.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomerName")}); this.xrTableCell9.Font = new System.Drawing.Font("Times New Roman", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.StylePriority.UseBorders = false; this.xrTableCell9.StylePriority.UseFont = false; this.xrTableCell9.StylePriority.UseTextAlignment = false; this.xrTableCell9.Text = "xrTableCell9"; this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; this.xrTableCell9.Weight = 0.18290070970980582D; // // xrTableCell2 // this.xrTableCell2.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomerPhone")}); this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.StylePriority.UseBorders = false; this.xrTableCell2.StylePriority.UseTextAlignment = false; this.xrTableCell2.Text = "xrTableCell2"; this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell2.Weight = 0.10669207988096552D; // // xrTableCell10 // this.xrTableCell10.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "AreaAmount")}); this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.StylePriority.UseBorders = false; this.xrTableCell10.StylePriority.UseTextAlignment = false; this.xrTableCell10.Text = "xrTableCell10"; this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell10.Weight = 0.076208630856557685D; // // xrTableCell3 // this.xrTableCell3.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ActAmount")}); this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.StylePriority.UseBorders = false; this.xrTableCell3.StylePriority.UseTextAlignment = false; this.xrTableCell3.Text = "xrTableCell3"; this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell3.Weight = 0.076208628889134711D; // // xrTableCell12 // this.xrTableCell12.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CategoryName")}); this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.StylePriority.UseBorders = false; this.xrTableCell12.StylePriority.UseTextAlignment = false; this.xrTableCell12.Text = "xrTableCell12"; this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell12.Weight = 0.10669208419765233D; // // xrTableCell13 // this.xrTableCell13.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ActDate", "{0:dd.MM.yyyy}")}); this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.StylePriority.UseBorders = false; this.xrTableCell13.StylePriority.UseTextAlignment = false; this.xrTableCell13.Text = "xrTableCell13"; this.xrTableCell13.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell13.Weight = 0.091450355559682034D; // // xrTableCell11 // this.xrTableCell11.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "ActNum")}); this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.StylePriority.UseBorders = false; this.xrTableCell11.StylePriority.UseTextAlignment = false; this.xrTableCell11.Text = "xrTableCell11"; this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell11.Weight = 0.10516790311461627D; // // TopMargin // this.TopMargin.HeightF = 51F; 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 = 50F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // srcActs // this.srcActs.DataSource = typeof(Kayflow.Reports.ActCollection); // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1, this.xrTable5}); this.ReportHeader.HeightF = 43.25F; this.ReportHeader.Name = "ReportHeader"; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right))); this.xrTable1.Font = new System.Drawing.Font("Times New Roman", 8F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(3.178914E-05F, 0F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow3}); this.xrTable1.SizeF = new System.Drawing.SizeF(1069F, 27.49999F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; this.xrTable1.StylePriority.UseTextAlignment = false; this.xrTable1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell22, this.xrTableCell19, this.xrTableCell23, this.xrTableCell16, this.xrTableCell24, this.xrTableCell20, this.xrTableCell25, this.xrTableCell17, this.xrTableCell26, this.xrTableCell21, this.xrTableCell27, this.xrTableCell18}); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1D; // // xrTableCell22 // this.xrTableCell22.Multiline = true; this.xrTableCell22.Name = "xrTableCell22"; this.xrTableCell22.StylePriority.UseTextAlignment = false; this.xrTableCell22.Text = "Дата\r\nзаміру"; this.xrTableCell22.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell22.Weight = 0.16838166867604984D; // // xrTableCell19 // this.xrTableCell19.Name = "xrTableCell19"; this.xrTableCell19.Text = "Статус"; this.xrTableCell19.Weight = 0.19644527952731267D; // // xrTableCell23 // this.xrTableCell23.Name = "xrTableCell23"; this.xrTableCell23.Text = "Працівник"; this.xrTableCell23.Weight = 0.50514498818578624D; // // xrTableCell16 // this.xrTableCell16.Name = "xrTableCell16"; this.xrTableCell16.Text = "Населений пункт"; this.xrTableCell16.Weight = 0.336763323078209D; // // xrTableCell24 // this.xrTableCell24.Name = "xrTableCell24"; this.xrTableCell24.Text = "Адреса"; this.xrTableCell24.Weight = 0.42095415563199762D; // // xrTableCell20 // this.xrTableCell20.Name = "xrTableCell20"; this.xrTableCell20.Text = "Замовник"; this.xrTableCell20.Weight = 0.33676332307820905D; // // xrTableCell25 // this.xrTableCell25.Name = "xrTableCell25"; this.xrTableCell25.Text = "№ телефону"; this.xrTableCell25.Weight = 0.19644527952731264D; // // xrTableCell17 // this.xrTableCell17.Font = new System.Drawing.Font("Times New Roman", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell17.Multiline = true; this.xrTableCell17.Name = "xrTableCell17"; this.xrTableCell17.StylePriority.UseFont = false; this.xrTableCell17.Text = "К-сть\r\n ділянок"; this.xrTableCell17.Weight = 0.14031805247207801D; // // xrTableCell26 // this.xrTableCell26.Multiline = true; this.xrTableCell26.Name = "xrTableCell26"; this.xrTableCell26.Text = "К-сть\r\nактів"; this.xrTableCell26.Weight = 0.14031805247207793D; // // xrTableCell21 // this.xrTableCell21.Name = "xrTableCell21"; this.xrTableCell21.Text = "Категорія"; this.xrTableCell21.Weight = 0.19644527952731267D; // // xrTableCell27 // this.xrTableCell27.Multiline = true; this.xrTableCell27.Name = "xrTableCell27"; this.xrTableCell27.Text = "Дата\r\nдоговору"; this.xrTableCell27.Weight = 0.16838166867604984D; // // xrTableCell18 // this.xrTableCell18.Name = "xrTableCell18"; this.xrTableCell18.Text = "№ договору"; this.xrTableCell18.Weight = 0.19363892914760436D; // // xrTable5 // this.xrTable5.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable5.Font = new System.Drawing.Font("Times New Roman", 8F, System.Drawing.FontStyle.Bold); this.xrTable5.LocationFloat = new DevExpress.Utils.PointFloat(0F, 28.25F); this.xrTable5.Name = "xrTable5"; this.xrTable5.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow6}); this.xrTable5.SizeF = new System.Drawing.SizeF(1069F, 15F); this.xrTable5.StylePriority.UseBorders = false; this.xrTable5.StylePriority.UseFont = false; this.xrTable5.StylePriority.UseTextAlignment = false; this.xrTable5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrTableRow6 // this.xrTableRow6.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell45, this.xrTableCell46, this.xrTableCell47, this.xrTableCell48, this.xrTableCell49, this.xrTableCell50, this.xrTableCell51, this.xrTableCell52, this.xrTableCell53, this.xrTableCell54, this.xrTableCell55, this.xrTableCell56}); this.xrTableRow6.Name = "xrTableRow6"; this.xrTableRow6.Weight = 1D; // // xrTableCell45 // this.xrTableCell45.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell45.Multiline = true; this.xrTableCell45.Name = "xrTableCell45"; this.xrTableCell45.StylePriority.UseBorders = false; this.xrTableCell45.StylePriority.UseTextAlignment = false; this.xrTableCell45.Text = "1"; this.xrTableCell45.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell45.Weight = 0.16838166867604984D; // // xrTableCell46 // this.xrTableCell46.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell46.Name = "xrTableCell46"; this.xrTableCell46.StylePriority.UseBorders = false; this.xrTableCell46.Text = "2"; this.xrTableCell46.Weight = 0.19644527952731267D; // // xrTableCell47 // this.xrTableCell47.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell47.Name = "xrTableCell47"; this.xrTableCell47.StylePriority.UseBorders = false; this.xrTableCell47.Text = "3"; this.xrTableCell47.Weight = 0.50514498818578624D; // // xrTableCell48 // this.xrTableCell48.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell48.Name = "xrTableCell48"; this.xrTableCell48.StylePriority.UseBorders = false; this.xrTableCell48.Text = "4"; this.xrTableCell48.Weight = 0.336763323078209D; // // xrTableCell49 // this.xrTableCell49.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell49.Name = "xrTableCell49"; this.xrTableCell49.StylePriority.UseBorders = false; this.xrTableCell49.Text = "5"; this.xrTableCell49.Weight = 0.42095415563199762D; // // xrTableCell50 // this.xrTableCell50.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell50.Name = "xrTableCell50"; this.xrTableCell50.StylePriority.UseBorders = false; this.xrTableCell50.Text = "6"; this.xrTableCell50.Weight = 0.33676332307820905D; // // xrTableCell51 // this.xrTableCell51.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell51.Name = "xrTableCell51"; this.xrTableCell51.StylePriority.UseBorders = false; this.xrTableCell51.Text = "7"; this.xrTableCell51.Weight = 0.19644527952731264D; // // xrTableCell52 // this.xrTableCell52.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell52.Font = new System.Drawing.Font("Times New Roman", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell52.Multiline = true; this.xrTableCell52.Name = "xrTableCell52"; this.xrTableCell52.StylePriority.UseBorders = false; this.xrTableCell52.StylePriority.UseFont = false; this.xrTableCell52.Text = "8"; this.xrTableCell52.Weight = 0.14031805247207801D; // // xrTableCell53 // this.xrTableCell53.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell53.Multiline = true; this.xrTableCell53.Name = "xrTableCell53"; this.xrTableCell53.StylePriority.UseBorders = false; this.xrTableCell53.Text = "9"; this.xrTableCell53.Weight = 0.14031805247207793D; // // xrTableCell54 // this.xrTableCell54.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell54.Name = "xrTableCell54"; this.xrTableCell54.StylePriority.UseBorders = false; this.xrTableCell54.Text = "10"; this.xrTableCell54.Weight = 0.19644527952731267D; // // xrTableCell55 // this.xrTableCell55.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell55.Multiline = true; this.xrTableCell55.Name = "xrTableCell55"; this.xrTableCell55.StylePriority.UseBorders = false; this.xrTableCell55.Text = "11"; this.xrTableCell55.Weight = 0.16838166867604984D; // // xrTableCell56 // this.xrTableCell56.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell56.Name = "xrTableCell56"; this.xrTableCell56.StylePriority.UseBorders = false; this.xrTableCell56.Text = "12"; this.xrTableCell56.Weight = 0.19363892914760436D; // // DetailReport // this.DetailReport.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.detailSteps, this.GroupHeader1, this.GroupFooter1}); this.DetailReport.DataMember = "Steps"; this.DetailReport.DataSource = this.srcActs; this.DetailReport.Level = 0; this.DetailReport.Name = "DetailReport"; // // detailSteps // this.detailSteps.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.tblSteps}); this.detailSteps.HeightF = 15F; this.detailSteps.KeepTogether = true; this.detailSteps.Name = "detailSteps"; this.detailSteps.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.detailSteps_BeforePrint); // // tblSteps // this.tblSteps.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.tblSteps.Font = new System.Drawing.Font("Times New Roman", 8F); this.tblSteps.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.tblSteps.Name = "tblSteps"; this.tblSteps.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2}); this.tblSteps.SizeF = new System.Drawing.SizeF(430F, 15F); this.tblSteps.StylePriority.UseBorders = false; this.tblSteps.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell32, this.xrTableCell4, this.xrTableCell5, this.xrTableCell6}); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1D; // // xrTableCell32 // this.xrTableCell32.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell32.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Steps.OrdNum")}); this.xrTableCell32.Name = "xrTableCell32"; this.xrTableCell32.StylePriority.UseBorders = false; this.xrTableCell32.StylePriority.UseTextAlignment = false; this.xrTableCell32.Text = "xrTableCell32"; this.xrTableCell32.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell32.Weight = 0.18575856007409755D; // // xrTableCell4 // this.xrTableCell4.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Steps.ActionName")}); this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.StylePriority.UseBorders = false; this.xrTableCell4.StylePriority.UseTextAlignment = false; this.xrTableCell4.Text = "xrTableCell4"; this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; this.xrTableCell4.Weight = 0.650154799860234D; // // xrTableCell5 // this.xrTableCell5.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Steps.Delivered", "{0:dd.MM.yyyy}")}); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.StylePriority.UseBorders = false; this.xrTableCell5.StylePriority.UseTextAlignment = false; this.xrTableCell5.Text = "xrTableCell5"; this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell5.Weight = 0.24767801857585131D; // // xrTableCell6 // this.xrTableCell6.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Steps.Received", "{0:dd.MM.yyyy}")}); this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.StylePriority.UseBorders = false; this.xrTableCell6.StylePriority.UseTextAlignment = false; this.xrTableCell6.Text = "xrTableCell6"; this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell6.Weight = 0.24767801857585131D; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable3}); this.GroupHeader1.HeightF = 15F; this.GroupHeader1.Name = "GroupHeader1"; this.GroupHeader1.RepeatEveryPage = true; // // xrTable3 // this.xrTable3.BackColor = System.Drawing.Color.Gainsboro; this.xrTable3.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable3.Font = new System.Drawing.Font("Times New Roman", 8F, System.Drawing.FontStyle.Bold); this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable3.Name = "xrTable3"; this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow4}); this.xrTable3.SizeF = new System.Drawing.SizeF(430F, 15F); this.xrTable3.StylePriority.UseBackColor = false; this.xrTable3.StylePriority.UseBorders = false; this.xrTable3.StylePriority.UseFont = false; this.xrTable3.StylePriority.UseTextAlignment = false; this.xrTable3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrTableRow4 // this.xrTableRow4.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell31, this.xrTableCell28, this.xrTableCell29, this.xrTableCell30}); this.xrTableRow4.Name = "xrTableRow4"; this.xrTableRow4.Weight = 1D; // // xrTableCell31 // this.xrTableCell31.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell31.Name = "xrTableCell31"; this.xrTableCell31.StylePriority.UseBorders = false; this.xrTableCell31.Text = "№ п/п"; this.xrTableCell31.Weight = 0.59999996430703428D; // // xrTableCell28 // this.xrTableCell28.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell28.Name = "xrTableCell28"; this.xrTableCell28.StylePriority.UseBorders = false; this.xrTableCell28.Text = "Назва етапу"; this.xrTableCell28.Weight = 2.0999996549191584D; // // xrTableCell29 // this.xrTableCell29.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell29.Name = "xrTableCell29"; this.xrTableCell29.StylePriority.UseBorders = false; this.xrTableCell29.Text = "Передали"; this.xrTableCell29.Weight = 0.80000030517577592D; // // xrTableCell30 // this.xrTableCell30.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell30.Name = "xrTableCell30"; this.xrTableCell30.StylePriority.UseBorders = false; this.xrTableCell30.Text = "Отримали"; this.xrTableCell30.Weight = 0.80000030517577592D; // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable4}); this.GroupFooter1.GroupUnion = DevExpress.XtraReports.UI.GroupFooterUnion.WithLastDetail; this.GroupFooter1.HeightF = 15F; this.GroupFooter1.Name = "GroupFooter1"; this.GroupFooter1.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.GroupFooter1_BeforePrint); // // xrTable4 // this.xrTable4.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable4.Font = new System.Drawing.Font("Times New Roman", 8F, System.Drawing.FontStyle.Bold); this.xrTable4.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable4.Name = "xrTable4"; this.xrTable4.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow5}); this.xrTable4.SizeF = new System.Drawing.SizeF(1069F, 15F); this.xrTable4.StylePriority.UseBorders = false; this.xrTable4.StylePriority.UseFont = false; this.xrTable4.StylePriority.UseTextAlignment = false; this.xrTable4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrTableRow5 // this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell33, this.xrTableCell34, this.xrTableCell35, this.xrTableCell36, this.xrTableCell37, this.xrTableCell38, this.xrTableCell39, this.xrTableCell40, this.xrTableCell41, this.xrTableCell42, this.xrTableCell43, this.xrTableCell44}); this.xrTableRow5.Name = "xrTableRow5"; this.xrTableRow5.Weight = 1D; // // xrTableCell33 // this.xrTableCell33.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell33.Multiline = true; this.xrTableCell33.Name = "xrTableCell33"; this.xrTableCell33.StylePriority.UseBorders = false; this.xrTableCell33.StylePriority.UseTextAlignment = false; this.xrTableCell33.Text = "1"; this.xrTableCell33.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell33.Weight = 0.16838166867604984D; // // xrTableCell34 // this.xrTableCell34.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell34.Name = "xrTableCell34"; this.xrTableCell34.StylePriority.UseBorders = false; this.xrTableCell34.Text = "2"; this.xrTableCell34.Weight = 0.19644527952731267D; // // xrTableCell35 // this.xrTableCell35.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell35.Name = "xrTableCell35"; this.xrTableCell35.StylePriority.UseBorders = false; this.xrTableCell35.Text = "3"; this.xrTableCell35.Weight = 0.50514498818578624D; // // xrTableCell36 // this.xrTableCell36.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell36.Name = "xrTableCell36"; this.xrTableCell36.StylePriority.UseBorders = false; this.xrTableCell36.Text = "4"; this.xrTableCell36.Weight = 0.336763323078209D; // // xrTableCell37 // this.xrTableCell37.Name = "xrTableCell37"; this.xrTableCell37.Text = "5"; this.xrTableCell37.Weight = 0.42095415563199762D; // // xrTableCell38 // this.xrTableCell38.Name = "xrTableCell38"; this.xrTableCell38.Text = "6"; this.xrTableCell38.Weight = 0.33676332307820905D; // // xrTableCell39 // this.xrTableCell39.Name = "xrTableCell39"; this.xrTableCell39.Text = "7"; this.xrTableCell39.Weight = 0.19644527952731264D; // // xrTableCell40 // this.xrTableCell40.Font = new System.Drawing.Font("Times New Roman", 8F, System.Drawing.FontStyle.Bold); this.xrTableCell40.Multiline = true; this.xrTableCell40.Name = "xrTableCell40"; this.xrTableCell40.StylePriority.UseFont = false; this.xrTableCell40.Text = "8"; this.xrTableCell40.Weight = 0.14031805247207801D; // // xrTableCell41 // this.xrTableCell41.Multiline = true; this.xrTableCell41.Name = "xrTableCell41"; this.xrTableCell41.Text = "9"; this.xrTableCell41.Weight = 0.14031805247207793D; // // xrTableCell42 // this.xrTableCell42.Name = "xrTableCell42"; this.xrTableCell42.Text = "10"; this.xrTableCell42.Weight = 0.19644527952731267D; // // xrTableCell43 // this.xrTableCell43.Multiline = true; this.xrTableCell43.Name = "xrTableCell43"; this.xrTableCell43.Text = "11"; this.xrTableCell43.Weight = 0.16838166867604984D; // // xrTableCell44 // this.xrTableCell44.Name = "xrTableCell44"; this.xrTableCell44.Text = "12"; this.xrTableCell44.Weight = 0.19363892914760436D; // // StepReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.ReportHeader, this.DetailReport}); this.DataSource = this.srcActs; this.Font = new System.Drawing.Font("Times New Roman", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Landscape = true; this.Margins = new System.Drawing.Printing.Margins(50, 50, 51, 50); this.PageHeight = 827; this.PageWidth = 1169; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.Version = "15.1"; ((System.ComponentModel.ISupportInitialize)(this.tblActs)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.srcActs)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.tblSteps)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
private void addRowHeader(XRTable table) { // ================================ // Header Row // ================================ var headerRow = new XRTableRow(); if(!_parameters.StampaMillesimi.GetValueOrDefault()) headerRow.Borders = BorderSide.All; if (_impostazioniReport.HeaderRowHeight != null) headerRow.HeightF = _impostazioniReport.HeaderRowHeight.Value; var headerFont = GetFont(_impostazioniReport.FontName, _impostazioniReport.FontSize, getFontStyle(_impostazioniReport.FontStyle)); if (!string.IsNullOrEmpty(_impostazioniReport.HeaderFontStyle) && !string.IsNullOrEmpty(_impostazioniReport.HeaderFontName) && _impostazioniReport.HeaderFontSize != null) headerFont = GetFont(_impostazioniReport.HeaderFontName, _impostazioniReport.HeaderFontSize.Value, getFontStyle(_impostazioniReport.HeaderFontStyle)); var headerAlignment = TextAlignment.TopCenter; if (_impostazioniReport.HeaderAlignment != null) headerAlignment = GetTextAlignment(_impostazioniReport.HeaderAlignment); var columns = _ripartoHelper.GetColumnList(_report, null, _parameters, _numeroPagina, _parameters.StampaMillesimi.GetValueOrDefault()); foreach (var tableColumn in columns) { if (!tableColumn.Hidden && (tableColumn.Order != 9997 || _numeroPagina == null || tableColumn.PrintPage == _numeroPagina)) { var cell = new XRTableCell { Font = headerFont, Text = tableColumn.Description, TextAlignment = headerAlignment, WidthF = tableColumn.Width }; if (tableColumn.ColumnType == ColumnTypeEnum.Conto) cell.BackColor = ColorTranslator.FromHtml(_impostazioniReport.HeaderBackColor); if (_parameters.StampaMillesimi.GetValueOrDefault() && !tableColumn.HideMillesimi) { var tableMillesimi = new XRTable {Borders = BorderSide.None}; tableMillesimi.BeginInit(); _tablesMillesimi.Add(tableMillesimi); var row1 = new XRTableRow {HeightF = headerRow.HeightF}; var cell1 = new XRTableCell { Text = cell.Text, Borders = BorderSide.Bottom, TextAlignment = headerAlignment, Padding = getPaddingInfo(), CanGrow = true, WordWrap = true }; cell1.BeforePrint += cell1_BeforePrint; row1.Cells.Add(cell1); tableMillesimi.Rows.Add(row1); var row2 = new XRTableRow {HeightF = headerRow.HeightF }; // Cell MILLESIMO // -------------------- var cellMillesimo = new XRTableCell { Text = tableColumn.DescriptionMillesimi, TextAlignment = headerAlignment, Borders = BorderSide.Right, Padding = getPaddingInfo() }; row2.Cells.Add(cellMillesimo); // Cell IMPORTO // -------------------- var cellImporto = new XRTableCell { Borders = BorderSide.Right, Text = tableColumn.DescriptionImporto, TextAlignment = headerAlignment, Padding = getPaddingInfo() }; row2.Cells.Add(cellImporto); // Add ROW // -------------------- tableMillesimi.Rows.Add(row2); cell.Text = string.Empty; cell.Padding = new PaddingInfo(0, 0, 0, 0); cellMillesimo.WidthF = tableColumn.WidthMillesimi.GetValueOrDefault(); cellImporto.WidthF = tableColumn.Width; cell.WidthF = tableColumn.Width + tableColumn.WidthMillesimi.GetValueOrDefault(); cell1.Width = cell.Width; cell1.BackColor = cell.BackColor; cellImporto.BackColor = cell.BackColor; cellMillesimo.BackColor = cell.BackColor; tableMillesimi.Width = cell.Width; cell.Controls.Add(tableMillesimi); tableMillesimi.AdjustSize(); tableMillesimi.EndInit(); } else cell.Padding = getPaddingInfo(); headerRow.Cells.Add(cell); } } table.Rows.Add(headerRow); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "XRPrintInvoice.resx"; DevExpress.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.GrandTotal = new DevExpress.XtraReports.Parameters.Parameter(); this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.lblDuplicate = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.SPName = new DevExpress.XtraReports.Parameters.Parameter(); this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel(); this.CustomerName = new DevExpress.XtraReports.Parameters.Parameter(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.CustomerCode = new DevExpress.XtraReports.Parameters.Parameter(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.PaymentType = new DevExpress.XtraReports.Parameters.Parameter(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.InvDate = new DevExpress.XtraReports.Parameters.Parameter(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.InvoiceNumber = new DevExpress.XtraReports.Parameters.Parameter(); this.InvoiceId = new DevExpress.XtraReports.Parameters.Parameter(); this.AmmountDue = new DevExpress.XtraReports.Parameters.Parameter(); this.DueAmmount = new DevExpress.XtraReports.Parameters.Parameter(); this.ReportFooter = new DevExpress.XtraReports.UI.ReportFooterBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel17 = new DevExpress.XtraReports.UI.XRLabel(); this.TotalPaid = new DevExpress.XtraReports.Parameters.Parameter(); this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrControlStyle1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.dsPrintInvoice1 = new DsPrintInvoice(); this.SPCode = new DevExpress.XtraReports.Parameters.Parameter(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.lblNote = new DevExpress.XtraReports.UI.XRLabel(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand(); this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsPrintInvoice1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2}); this.Detail.Dpi = 254F; this.Detail.HeightF = 61F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.BorderColor = System.Drawing.Color.Transparent; this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Dpi = 254F; this.xrTable2.Font = new System.Drawing.Font("Times New Roman", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(5F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2}); this.xrTable2.SizeF = new System.Drawing.SizeF(2238F, 61F); this.xrTable2.StylePriority.UseBorderColor = false; this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell4, this.xrTableCell5, this.xrTableCell6, this.xrTableCell10, this.xrTableCell12}); this.xrTableRow2.Dpi = 254F; this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1; // // xrTableCell4 // this.xrTableCell4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "vw_Invoice_Detail_Sel_Report.ItemCode")}); this.xrTableCell4.Dpi = 254F; this.xrTableCell4.Font = new System.Drawing.Font("Times New Roman", 11.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrTableCell4.StylePriority.UseFont = false; this.xrTableCell4.StylePriority.UseTextAlignment = false; this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.BottomLeft; this.xrTableCell4.Weight = 0.083109919571045576; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "vw_Invoice_Detail_Sel_Report.ItemDescription")}); this.xrTableCell5.Dpi = 254F; this.xrTableCell5.Font = new System.Drawing.Font("Times New Roman", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrTableCell5.StylePriority.UseFont = false; this.xrTableCell5.StylePriority.UseTextAlignment = false; this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.BottomLeft; this.xrTableCell5.Weight = 0.57327971403038425; // // xrTableCell6 // this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "vw_Invoice_Detail_Sel_Report.Quantity")}); this.xrTableCell6.Dpi = 254F; this.xrTableCell6.Font = new System.Drawing.Font("Times New Roman", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrTableCell6.StylePriority.UseFont = false; this.xrTableCell6.StylePriority.UseTextAlignment = false; this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.BottomLeft; this.xrTableCell6.Weight = 0.055406613047363718; // // xrTableCell10 // this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "vw_Invoice_Detail_Sel_Report.Price", "{0:0.00}")}); this.xrTableCell10.Dpi = 254F; this.xrTableCell10.Font = new System.Drawing.Font("Times New Roman", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrTableCell10.StylePriority.UseFont = false; this.xrTableCell10.StylePriority.UseTextAlignment = false; this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.BottomRight; this.xrTableCell10.Weight = 0.13717605004468275; // // xrTableCell12 // this.xrTableCell12.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTableCell12.CanShrink = true; this.xrTableCell12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "vw_Invoice_Detail_Sel_Report.TotalPrice", "{0:0.00}")}); this.xrTableCell12.Dpi = 254F; this.xrTableCell12.Font = new System.Drawing.Font("Times New Roman", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrTableCell12.StylePriority.UseBorders = false; this.xrTableCell12.StylePriority.UseFont = false; this.xrTableCell12.StylePriority.UseTextAlignment = false; this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.BottomRight; this.xrTableCell12.Weight = 0.15102770330652368; // // GrandTotal // this.GrandTotal.Name = "GrandTotal"; this.GrandTotal.Type = typeof(decimal); this.GrandTotal.Value = 0; // // PageHeader // this.PageHeader.Dpi = 254F; this.PageHeader.HeightF = 0F; this.PageHeader.Name = "PageHeader"; this.PageHeader.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); this.PageHeader.StylePriority.UseTextAlignment = false; this.PageHeader.TextAlignment = DevExpress.XtraPrinting.TextAlignment.BottomLeft; // // xrTableCell9 // this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "vw_Invoice_Sel_Report.Has Line Item.Quantity")}); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrTableCell9.Weight = 0; // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "vw_Invoice_Sel_Report.Has Line Item.Price")}); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrTableCell8.Weight = 0; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.lblDuplicate, this.xrLabel8, this.xrLabel11, this.xrLabel7, this.xrLabel6, this.xrLabel5, this.xrLabel4}); this.ReportHeader.Dpi = 254F; this.ReportHeader.HeightF = 638F; this.ReportHeader.Name = "ReportHeader"; // // lblDuplicate // this.lblDuplicate.BackColor = System.Drawing.Color.Transparent; this.lblDuplicate.Dpi = 254F; this.lblDuplicate.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F); this.lblDuplicate.LocationFloat = new DevExpress.Utils.PointFloat(1270F, 445F); this.lblDuplicate.Name = "lblDuplicate"; this.lblDuplicate.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.lblDuplicate.SizeF = new System.Drawing.SizeF(297.9999F, 58.41995F); this.lblDuplicate.StylePriority.UseBackColor = false; this.lblDuplicate.StylePriority.UseFont = false; this.lblDuplicate.Text = "DUPLICATE"; this.lblDuplicate.Visible = false; // // xrLabel8 // this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.SPName, "Text", "")}); this.xrLabel8.Dpi = 254F; this.xrLabel8.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(1270F, 339F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel8.SizeF = new System.Drawing.SizeF(254F, 64F); this.xrLabel8.StylePriority.UseFont = false; this.xrLabel8.Text = "xrLabel8"; // // SPName // this.SPName.Name = "SPName"; this.SPName.Value = ""; // // xrLabel11 // this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.CustomerName, "Text", "")}); this.xrLabel11.Dpi = 254F; this.xrLabel11.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(100F, 234F); this.xrLabel11.Multiline = true; this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel11.SizeF = new System.Drawing.SizeF(339F, 64F); this.xrLabel11.StylePriority.UseFont = false; this.xrLabel11.Text = "xrLabel11"; // // CustomerName // this.CustomerName.Name = "CustomerName"; this.CustomerName.Value = ""; // // xrLabel7 // this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.CustomerCode, "Text", "")}); this.xrLabel7.Dpi = 254F; this.xrLabel7.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(100F, 444F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel7.SizeF = new System.Drawing.SizeF(254F, 64F); this.xrLabel7.StylePriority.UseFont = false; this.xrLabel7.Text = "xrLabel7"; // // CustomerCode // this.CustomerCode.Name = "CustomerCode"; this.CustomerCode.Value = ""; // // xrLabel6 // this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.PaymentType, "Text", "")}); this.xrLabel6.Dpi = 254F; this.xrLabel6.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(1935F, 445F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel6.SizeF = new System.Drawing.SizeF(254F, 64F); this.xrLabel6.StylePriority.UseFont = false; this.xrLabel6.Text = "xrLabel6"; // // PaymentType // this.PaymentType.Name = "PaymentType"; this.PaymentType.Value = ""; // // xrLabel5 // this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.InvDate, "Text", "{0:dd-MMM-yyyy}")}); this.xrLabel5.Dpi = 254F; this.xrLabel5.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(1935F, 234F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel5.SizeF = new System.Drawing.SizeF(347F, 64F); this.xrLabel5.StylePriority.UseFont = false; xrSummary1.FormatString = "dd/MMM/yyyy{0}"; this.xrLabel5.Summary = xrSummary1; this.xrLabel5.Text = "xrLabel5"; // // InvDate // this.InvDate.Name = "InvDate"; this.InvDate.Type = typeof(System.DateTime); this.InvDate.Value = new System.DateTime(((long)(0))); // // xrLabel4 // this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.InvoiceNumber, "Text", "")}); this.xrLabel4.Dpi = 254F; this.xrLabel4.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(1935F, 339F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel4.SizeF = new System.Drawing.SizeF(361F, 64F); this.xrLabel4.StylePriority.UseFont = false; this.xrLabel4.Text = "xrLabel4"; // // InvoiceNumber // this.InvoiceNumber.Name = "InvoiceNumber"; this.InvoiceNumber.Value = ""; // // InvoiceId // this.InvoiceId.Name = "InvoiceId"; this.InvoiceId.Type = typeof(int); this.InvoiceId.Value = 0; // // AmmountDue // this.AmmountDue.Name = "AmmountDue"; this.AmmountDue.Type = typeof(decimal); this.AmmountDue.Value = 0; // // DueAmmount // this.DueAmmount.Name = "DueAmmount"; this.DueAmmount.Type = typeof(decimal); this.DueAmmount.Value = 0; // // ReportFooter // this.ReportFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel3, this.xrLabel14, this.xrLabel17, this.xrLabel12, this.xrLabel2}); this.ReportFooter.Dpi = 254F; this.ReportFooter.HeightF = 274F; this.ReportFooter.Name = "ReportFooter"; this.ReportFooter.PrintAtBottom = true; // // xrLabel1 // this.xrLabel1.Dpi = 254F; this.xrLabel1.Font = new System.Drawing.Font("Microsoft Sans Serif", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(1569F, 130F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel1.SizeF = new System.Drawing.SizeF(294F, 63F); this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.Text = "Amount"; // // xrLabel3 // this.xrLabel3.Dpi = 254F; this.xrLabel3.Font = new System.Drawing.Font("Microsoft Sans Serif", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(1469F, 66F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel3.SizeF = new System.Drawing.SizeF(397F, 58F); this.xrLabel3.StylePriority.UseFont = false; this.xrLabel3.Text = "Recieved Amount"; // // xrLabel14 // this.xrLabel14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.DueAmmount, "Text", "")}); this.xrLabel14.Dpi = 254F; this.xrLabel14.Font = new System.Drawing.Font("Microsoft Sans Serif", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel14.ForeColor = System.Drawing.Color.Maroon; this.xrLabel14.LocationFloat = new DevExpress.Utils.PointFloat(1900F, 133F); this.xrLabel14.Name = "xrLabel14"; this.xrLabel14.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel14.SizeF = new System.Drawing.SizeF(346F, 64F); this.xrLabel14.StylePriority.UseFont = false; this.xrLabel14.StylePriority.UseForeColor = false; this.xrLabel14.StylePriority.UseTextAlignment = false; this.xrLabel14.Text = "xrLabel14"; this.xrLabel14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // xrLabel17 // this.xrLabel17.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.TotalPaid, "Text", "")}); this.xrLabel17.Dpi = 254F; this.xrLabel17.Font = new System.Drawing.Font("Microsoft Sans Serif", 13F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel17.LocationFloat = new DevExpress.Utils.PointFloat(1900F, 67F); this.xrLabel17.Name = "xrLabel17"; this.xrLabel17.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel17.SizeF = new System.Drawing.SizeF(346F, 64F); this.xrLabel17.StylePriority.UseFont = false; this.xrLabel17.StylePriority.UseTextAlignment = false; this.xrLabel17.Text = "xrLabel17"; this.xrLabel17.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // TotalPaid // this.TotalPaid.Name = "TotalPaid"; this.TotalPaid.Type = typeof(decimal); this.TotalPaid.Value = 0; // // xrLabel12 // this.xrLabel12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding(this.GrandTotal, "Text", "")}); this.xrLabel12.Dpi = 254F; this.xrLabel12.Font = new System.Drawing.Font("Microsoft Sans Serif", 13F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(1900F, 210F); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel12.SizeF = new System.Drawing.SizeF(346F, 64F); this.xrLabel12.StylePriority.UseFont = false; this.xrLabel12.StylePriority.UseTextAlignment = false; this.xrLabel12.Text = "xrLabel12"; this.xrLabel12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // xrLabel2 // this.xrLabel2.Dpi = 254F; this.xrLabel2.Font = new System.Drawing.Font("Microsoft Sans Serif", 13F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(1468F, 130F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel2.SizeF = new System.Drawing.SizeF(100F, 63F); this.xrLabel2.StylePriority.UseFont = false; this.xrLabel2.Text = "Due"; // // xrControlStyle1 // this.xrControlStyle1.BorderColor = System.Drawing.SystemColors.Desktop; 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"; // // dsPrintInvoice1 // this.dsPrintInvoice1.DataSetName = "DsPrintInvoice"; this.dsPrintInvoice1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // SPCode // this.SPCode.Name = "SPCode"; this.SPCode.Value = ""; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.lblNote, this.xrPageInfo1}); this.PageFooter.Dpi = 254F; this.PageFooter.HeightF = 65.00002F; this.PageFooter.Name = "PageFooter"; this.PageFooter.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F); this.PageFooter.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // lblNote // this.lblNote.Dpi = 254F; this.lblNote.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.lblNote.LocationFloat = new DevExpress.Utils.PointFloat(0F, 5.579924F); this.lblNote.Name = "lblNote"; this.lblNote.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.lblNote.SizeF = new System.Drawing.SizeF(1246.188F, 58.42F); this.lblNote.StylePriority.UseFont = false; this.lblNote.Text = "Cash returns are not accepted. This invoice should be submitted for any returns."; // // xrPageInfo1 // this.xrPageInfo1.Dpi = 254F; this.xrPageInfo1.Font = new System.Drawing.Font("Times New Roman", 11F); this.xrPageInfo1.Format = "Page {0} of {1}"; this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(1989F, 0F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrPageInfo1.SizeF = new System.Drawing.SizeF(254F, 64F); this.xrPageInfo1.StylePriority.UseFont = false; // // topMarginBand1 // this.topMarginBand1.Dpi = 254F; this.topMarginBand1.HeightF = 5F; this.topMarginBand1.Name = "topMarginBand1"; // // bottomMarginBand1 // this.bottomMarginBand1.Dpi = 254F; this.bottomMarginBand1.HeightF = 5F; this.bottomMarginBand1.Name = "bottomMarginBand1"; // // XRPrintInvoice // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.PageHeader, this.ReportHeader, this.ReportFooter, this.PageFooter, this.topMarginBand1, this.bottomMarginBand1}); this.DataMember = "vw_Invoice_Detail_Sel_Report"; this.DataSource = this.dsPrintInvoice1; this.Dpi = 254F; this.Margins = new System.Drawing.Printing.Margins(5, 5, 5, 5); this.PageHeight = 2000; this.PageWidth = 2317; this.PaperKind = System.Drawing.Printing.PaperKind.Custom; this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.InvoiceId, this.InvoiceNumber, this.InvDate, this.CustomerCode, this.CustomerName, this.GrandTotal, this.AmmountDue, this.PaymentType, this.DueAmmount, this.TotalPaid, this.SPCode, this.SPName}); this.ReportUnit = DevExpress.XtraReports.UI.ReportUnit.TenthsOfAMillimeter; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.xrControlStyle1}); this.Version = "11.1"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsPrintInvoice1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { string resourceFileName = "XtraReport05.resx"; this.dsTEFollowUp1 = new dsTEFollowUp(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow4 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell22 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell21 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTable6 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow13 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell39 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell25 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell40 = 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.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.lblSchool = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableRow5 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell23 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell24 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell26 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.ReportFooter = new DevExpress.XtraReports.UI.ReportFooterBand(); this.cdtblhedeTableAdapter1 = new dsTEFollowUpTableAdapters.cdtblhedeTableAdapter(); this.xRep05TableAdapter1 = new dsTEFollowUpTableAdapters.XRep05TableAdapter(); ((System.ComponentModel.ISupportInitialize)(this.dsTEFollowUp1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable6)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // dsTEFollowUp1 // this.dsTEFollowUp1.DataSetName = "dsTEFollowUp"; this.dsTEFollowUp1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2}); this.Detail.HeightF = 50F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.StylePriority.UseTextAlignment = false; this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow4}); this.xrTable2.SizeF = new System.Drawing.SizeF(900F, 50F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseFont = false; this.xrTable2.StylePriority.UseTextAlignment = false; this.xrTable2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrTableRow4 // this.xrTableRow4.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell10, this.xrTableCell22, this.xrTableCell20, this.xrTableCell16, this.xrTableCell18, this.xrTableCell21, this.xrTableCell11}); this.xrTableRow4.Name = "xrTableRow4"; this.xrTableRow4.Weight = 1D; // // xrTableCell10 // this.xrTableCell10.CanGrow = false; this.xrTableCell10.CanShrink = true; this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "XRep05.trremark")}); this.xrTableCell10.Multiline = true; this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.StylePriority.UseTextAlignment = false; this.xrTableCell10.Text = "xrTableCell10"; this.xrTableCell10.Weight = 0.92361152648925782D; // // xrTableCell22 // this.xrTableCell22.CanGrow = false; this.xrTableCell22.CanShrink = true; this.xrTableCell22.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "XRep05.mostahdfeen")}); this.xrTableCell22.Multiline = true; this.xrTableCell22.Name = "xrTableCell22"; this.xrTableCell22.StylePriority.UseTextAlignment = false; this.xrTableCell22.Text = "xrTableCell22"; this.xrTableCell22.Weight = 0.40972208658854165D; // // xrTableCell20 // this.xrTableCell20.CanGrow = false; this.xrTableCell20.CanShrink = true; this.xrTableCell20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "XRep05.todate", "{0:d/M/yyyy}")}); this.xrTableCell20.Multiline = true; this.xrTableCell20.Name = "xrTableCell20"; this.xrTableCell20.StylePriority.UseTextAlignment = false; this.xrTableCell20.Text = "xrTableCell20"; this.xrTableCell20.Weight = 0.33333361307779946D; // // xrTableCell16 // this.xrTableCell16.CanGrow = false; this.xrTableCell16.CanShrink = true; this.xrTableCell16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "XRep05.fromdate", "{0:d/M/yyyy}")}); this.xrTableCell16.Multiline = true; this.xrTableCell16.Name = "xrTableCell16"; this.xrTableCell16.StylePriority.UseTextAlignment = false; this.xrTableCell16.Text = "xrTableCell16"; this.xrTableCell16.Weight = 0.33333333333333326D; // // xrTableCell18 // this.xrTableCell18.CanGrow = false; this.xrTableCell18.CanShrink = true; this.xrTableCell18.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "XRep05.trainhours")}); this.xrTableCell18.Multiline = true; this.xrTableCell18.Name = "xrTableCell18"; this.xrTableCell18.StylePriority.UseTextAlignment = false; this.xrTableCell18.Text = "xrTableCell18"; this.xrTableCell18.Weight = 0.26388895670572915D; // // xrTableCell21 // this.xrTableCell21.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "XRep05.traindates")}); this.xrTableCell21.Name = "xrTableCell21"; this.xrTableCell21.StylePriority.UseTextAlignment = false; this.xrTableCell21.Text = "xrTableCell21"; this.xrTableCell21.Weight = 0.24305501302083338D; // // xrTableCell11 // this.xrTableCell11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "XRep05.trainingname")}); this.xrTableCell11.Name = "xrTableCell11"; this.xrTableCell11.StylePriority.UseTextAlignment = false; this.xrTableCell11.Text = "xrTableCell11"; this.xrTableCell11.Weight = 0.49305547078450523D; // // xrTable6 // this.xrTable6.BackColor = System.Drawing.Color.Gray; this.xrTable6.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable6.Font = new System.Drawing.Font("Times New Roman", 12F, System.Drawing.FontStyle.Bold); this.xrTable6.ForeColor = System.Drawing.Color.White; this.xrTable6.LocationFloat = new DevExpress.Utils.PointFloat(0.0001271566F, 145.2083F); this.xrTable6.Name = "xrTable6"; this.xrTable6.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow13}); this.xrTable6.SizeF = new System.Drawing.SizeF(899.9999F, 24.99999F); this.xrTable6.StylePriority.UseBackColor = false; this.xrTable6.StylePriority.UseBorders = false; this.xrTable6.StylePriority.UseFont = false; this.xrTable6.StylePriority.UseForeColor = false; this.xrTable6.StylePriority.UseTextAlignment = false; this.xrTable6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrTableRow13 // this.xrTableRow13.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell39, this.xrTableCell14, this.xrTableCell12, this.xrTableCell13, this.xrTableCell25, this.xrTableCell40, this.xrTableCell31}); this.xrTableRow13.Name = "xrTableRow13"; this.xrTableRow13.Weight = 1D; // // xrTableCell39 // this.xrTableCell39.Name = "xrTableCell39"; this.xrTableCell39.Text = "ملاحظات"; this.xrTableCell39.Weight = 0.92361126931419923D; // // xrTableCell14 // this.xrTableCell14.Name = "xrTableCell14"; this.xrTableCell14.Text = "المستهدفين"; this.xrTableCell14.Weight = 0.40972224519010836D; // // xrTableCell12 // this.xrTableCell12.Name = "xrTableCell12"; this.xrTableCell12.Text = "الي تاريخ"; this.xrTableCell12.Weight = 0.33333337984873657D; // // xrTableCell13 // this.xrTableCell13.Name = "xrTableCell13"; this.xrTableCell13.StylePriority.UseTextAlignment = false; this.xrTableCell13.Text = "من تاريخ"; this.xrTableCell13.Weight = 0.33333337984873668D; // // xrTableCell25 // this.xrTableCell25.Name = "xrTableCell25"; this.xrTableCell25.Text = "عدد الساعات"; this.xrTableCell25.Weight = 0.26388898108647546D; // // xrTableCell40 // this.xrTableCell40.Name = "xrTableCell40"; this.xrTableCell40.Text = "عدد الايام"; this.xrTableCell40.Weight = 0.24305525791493837D; // // xrTableCell31 // this.xrTableCell31.Name = "xrTableCell31"; this.xrTableCell31.Text = "الخطة التدريبية"; this.xrTableCell31.Weight = 0.49305548679680539D; // // TopMargin // this.TopMargin.HeightF = 19F; 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 = 62.5F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.StylePriority.UseTextAlignment = false; this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1, this.xrTable6}); this.ReportHeader.HeightF = 170.2083F; this.ReportHeader.Name = "ReportHeader"; // // xrTable1 // this.xrTable1.Font = new System.Drawing.Font("Times New Roman", 12F); 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.xrTableRow3, this.xrTableRow5, this.xrTableRow2}); this.xrTable1.SizeF = new System.Drawing.SizeF(900F, 133.3333F); this.xrTable1.StylePriority.UseFont = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.lblSchool, this.xrTableCell2, this.xrTableCell3}); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1D; // // lblSchool // this.lblSchool.Name = "lblSchool"; this.lblSchool.StylePriority.UseTextAlignment = false; this.lblSchool.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; this.lblSchool.Weight = 1D; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Weight = 1D; // // xrTableCell3 // this.xrTableCell3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "cdtblhede.dawla")}); this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.StylePriority.UseTextAlignment = false; this.xrTableCell3.Text = "xrTableCell3"; this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.xrTableCell3.Weight = 1D; // // xrTableRow3 // this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell7, this.xrTableCell8, this.xrTableCell9}); this.xrTableRow3.Name = "xrTableRow3"; this.xrTableRow3.Weight = 1D; // // xrTableCell7 // this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "cdtblhede.dept")}); this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.StylePriority.UseTextAlignment = false; this.xrTableCell7.Text = "xrTableCell7"; this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; this.xrTableCell7.Weight = 1D; // // xrTableCell8 // this.xrTableCell8.Font = new System.Drawing.Font("Times New Roman", 14F); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.StylePriority.UseFont = false; this.xrTableCell8.StylePriority.UseTextAlignment = false; this.xrTableCell8.Text = "الخطة التدريبية"; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrTableCell8.Weight = 1D; // // xrTableCell9 // this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "cdtblhede.wezara")}); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.StylePriority.UseTextAlignment = false; this.xrTableCell9.Text = "xrTableCell9"; this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.xrTableCell9.Weight = 1D; // // xrTableRow5 // this.xrTableRow5.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell23, this.xrTableCell24, this.xrTableCell26}); this.xrTableRow5.Name = "xrTableRow5"; this.xrTableRow5.Weight = 1D; // // xrTableCell23 // this.xrTableCell23.Name = "xrTableCell23"; this.xrTableCell23.Weight = 1D; // // xrTableCell24 // this.xrTableCell24.Name = "xrTableCell24"; this.xrTableCell24.Weight = 1D; // // xrTableCell26 // this.xrTableCell26.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "cdtblhede.edara")}); this.xrTableCell26.Name = "xrTableCell26"; this.xrTableCell26.Text = "xrTableCell26"; this.xrTableCell26.Weight = 1D; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell4, this.xrTableCell5, this.xrTableCell6}); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1D; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.StylePriority.UseTextAlignment = false; this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; this.xrTableCell4.Weight = 1D; // // xrTableCell5 // this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Weight = 1D; // // xrTableCell6 // this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.StylePriority.UseTextAlignment = false; this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.xrTableCell6.Weight = 1D; // // ReportFooter // this.ReportFooter.HeightF = 32.29167F; this.ReportFooter.Name = "ReportFooter"; // // cdtblhedeTableAdapter1 // this.cdtblhedeTableAdapter1.ClearBeforeFill = true; // // xRep05TableAdapter1 // this.xRep05TableAdapter1.ClearBeforeFill = true; // // XtraReport05 // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.ReportHeader, this.ReportFooter}); this.DataMember = "XRep05"; this.DataSource = this.dsTEFollowUp1; this.Landscape = true; this.Margins = new System.Drawing.Printing.Margins(100, 100, 19, 62); this.PageHeight = 850; this.PageWidth = 1100; this.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.Version = "12.2"; this.DataSourceDemanded += new System.EventHandler<System.EventArgs>(this.XtraReport01_DataSourceDemanded); ((System.ComponentModel.ISupportInitialize)(this.dsTEFollowUp1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable6)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }