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;
}
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;
}
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);
}
private void SampleReport_DataSourceDemanded(object sender, EventArgs e)
{
// Get the selected report columns.
var columns = this.Parameters["ReportColumns"].Value as string[];
this.tblHeader.BeginInit();
this.tblDetail.BeginInit();
this.trHeader.Cells.Clear();
this.trDetail.Cells.Clear();
// Create a table header cell and table body cell for each selected column.
foreach (string column in columns)
{
string description = _reportColumns.Single(lookupValue => lookupValue.Value.Equals(column)).Description;
// Assign a column description to the table header cell.
var headerCell = new XRTableCell();
headerCell.Text = description;
this.trHeader.Cells.Add(headerCell);
// Bind the table body cell to the column.
var bodyCell = new XRTableCell();
bodyCell.ExpressionBindings.Add(new ExpressionBinding("Text", "[" + column + "]"));
this.trDetail.Cells.Add(bodyCell);
}
this.tblHeader.EndInit();
this.tblDetail.EndInit();
}
private XRTableRow SetValues(object obj)
{
var row = new XRTableRow();
Type type = obj.GetType();
var properties = type.GetProperties();
foreach (var item in properties)
{
var cell = new XRTableCell()
{
TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter
};
if (item.PropertyType == typeof(DateTime))
{
cell.Text = ((DateTime)item.GetValue(obj)).ToString("dd/MM/yyyy");
}
else
{
cell.Text = item.GetValue(obj).ToString();
}
row.Cells.Add(cell);
}
return(row);
}
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);
}
/// <summary>
/// Prepara una celda que indica el estatus de la unidad de un día del mes
/// </summary>
/// <param name="cell">Celda a inicializar</param>
/// <param name="weight">Tamaño de la celda</param>
/// <param name="dayOfMonth">Día del mes</param>
/// <param name="month">Mes en curso</param>
/// <param name="year">Año en curso</param>
/// <param name="monthDays">Total de días del mes</param>
private void InitializeDataCell(XRTableCell cell, double weight, int dayOfMonth, int month, int year, int monthDays)
{
CalculatedField calculatedField = new CalculatedField();
calculatedField.DataMember = "Modelo";
calculatedField.Name = String.Format("TotalRentados_{0}", dayOfMonth);
calculatedField.FieldType = DevExpress.XtraReports.UI.FieldType.Int32;
calculatedField.Scripts.OnGetValue = String.Format("TotalRentados_GetValue{0}", dayOfMonth);
this.CalculatedFields.Add(calculatedField);
StringBuilder sb = new StringBuilder();
sb.AppendLine();
sb.AppendLine(String.Format(@"private void TotalRentados_GetValue{0}(object sender, DevExpress.XtraReports.UI.GetValueEventArgs e)", dayOfMonth));
sb.AppendLine("{");
sb.AppendLine("\tthis.CurrentReport.TotalRentados_GetValue(sender, e);");
sb.AppendLine("}");
this.ScriptsSource += sb.ToString();
cell.Name = String.Format("xrtDataCell{0}", dayOfMonth);
cell.WidthF = (float)weight;
cell.Tag = dayOfMonth;
if (new DateTime(year, month, dayOfMonth).DayOfWeek == DayOfWeek.Sunday && (cell.BackColor == Color.Transparent && cell.Parent.BackColor == Color.Transparent))
{
cell.BackColor = Color.LightGray;
}
cell.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, String.Format("Modelo.{0}", calculatedField.Name))
});
}
private void txtBHYT_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
XRTableCell txt = (XRTableCell)sender;
Boolean HV_BHYT_MIENPHI = clsChangeType.change_bool((GetCurrentColumnValue("HV_BHYT_MIENPHI")));
txt.Text = HV_BHYT_MIENPHI ? "Có" : "Không";
}
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);
}
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);
}
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 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);
}
/// <summary>
/// 打印 实物券 / 预付 使用情况
/// </summary>
private void xrTableCell16_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
XRTableCell cell = sender as XRTableCell;
if (cell == null)
{
return;
}
int index = (int)(this._skuIndex - 1);
if (index >= this.dataSource.ReportDetails.Count)
{
return;
}
SODetailReportEntity detail = this.dataSource.ReportDetails[index];
int phy_count = this.dataSource.GetAttrCountBySku(ConvertUtil.ToInt(detail.MaterialCode), 2).Count; // 实物券
int pay_count = this.dataSource.GetAttrCountBySku(ConvertUtil.ToInt(detail.MaterialCode), 4).Sum(u => ConvertUtil.ToInt(u.Num)); // 预付
if (phy_count == 0 && pay_count == 0)
{
cell.Text = string.Empty;
}
else
{
cell.Text = string.Format("{0}\r\n{1}", phy_count, pay_count);
}
}
private void xrTableCellSupervisor_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
XRTableCell cell = sender as XRTableCell;
if (string.IsNullOrEmpty(cell.Text))
{
cell.Text = "";
return;
}
BusinessLogicLayer.Entity.PPM.RequestWithdraw withdraw = new BusinessLogicLayer.Entity.PPM.RequestWithdraw(Convert.ToInt32(cell.Text));
if (!withdraw.CreatedBy.HasValue || withdraw.CreatedBy.Value == 0)
{
cell.Text = Supervisor;
}
else
{
BusinessLogicLayer.Entity.Persons.Person p = new BusinessLogicLayer.Entity.Persons.Person(withdraw.CreatedBy.Value);
if (p.HasObject)
{
cell.Text = p.DisplayName;
}
else
{
cell.Text = Supervisor;
}
}
}
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);
}
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);
}
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);
}
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;
}
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 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);
}
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);
}
/// <summary>
/// Prepara una celda que indica el número del día del mes
/// </summary>
/// <param name="cell">Celda a inicializar</param>
/// <param name="weight">Tamaño de la celda</param>
/// <param name="year">Año</param>
/// <param name="paintBackground">Determina si se pintara el fondo de la celda</param>
private void InitializeHeaderModels(XRTableCell cell, double weight, int year, bool paintBackground)
{
cell.Name = String.Format("xrtHeaderYear_{0}", year);
cell.WidthF = (float)weight;
cell.Text = String.Empty;
cell.Borders = BorderSide.None;
}
public XRBaoCaoNhapHang(BaoCaoNhapHang bc)
{
InitializeComponent();
xlNgayLap.Text = bc.ThoiGian;
xlNhanVien.Text = StaticVariables.nhanVien.TenNhanVien;
if (bc.ChiTietBaoCao != null)
{
int cellsInRow = 7;
int rowsCount = bc.ChiTietBaoCao.Rows.Count;
//do cao cua mot o trong table
float rowHeight = 20f;
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();
if (j == 0)
{
//them so thu tu
cell.Text = i.ToString();
}
else
cell.Text = bc.ChiTietBaoCao.Rows[i].ItemArray[j - 1].ToString();
//chinh lai kich thuoc cua moi o
switch (j)
{
case 0:
cell.WidthF = 30;
break;
case 1:
cell.WidthF = 110;
break;
case 2:
cell.WidthF = 115;
break;
case 3:
cell.WidthF = 200;
break;
case 4:
cell.WidthF = 190;
break;
case 5:
cell.WidthF = 60;
break;
case 6:
cell.WidthF = 90;
cell.Text = ((DateTime)bc.ChiTietBaoCao.Rows[i].ItemArray[j - 1]).ToString("MM/dd/yyyy");
break;
}
row.Cells.Add(cell);
}
xtDanhSachMatHang.Rows.Add(row);
}
}
}
/// <summary>
/// Prepara una celda que indica el número del día del mes
/// </summary>
/// <param name="cell">Celda a inicializar</param>
/// <param name="weight">Tamaño de la celda</param>
/// <param name="dayOfMonth">Día del mes</param>
/// <param name="monthDays">Total de días del mes</param>
private void InitializeHeaderCell(XRTableCell cell, double weight, int dayOfMonth, int monthDays)
{
cell.Name = String.Format("xrtHeaderDayCell{0}", dayOfMonth);
cell.WidthF = (float)weight;
cell.Text = dayOfMonth.ToString();
cell.BackColor = this.xrLTotalFlota.BackColor;
cell.ForeColor = xrlDiasXUnidad.ForeColor;
}
private void PrintManualFillCell(object sender, PrintEventArgs args)
{
XRTableCell cell = (XRTableCell)sender;
ProcessDayCell(cell);
cell.Text = String.Empty;
}
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;
}
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;
}
private void gc_Employee_BeforePrint(object sender, PrintEventArgs e)
{
XRTableCell cell = sender as XRTableCell;
if (cell.Text.Length > 15)
{
cell.Text = cell.Text.Replace(' ', '\n');
}
}
private void xrTableCell9_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
XRTableCell cell = (XRTableCell)sender;
cell.Text = "";
if (this.GetCurrentColumnValue("QID") != null)
{
// cell.Text = DataAccess.DaDDD.GetValue<string>("SendDtl", "ID", " CustomerID = '" + this.GetCurrentColumnValue("QID").ToString() + "' ");
}
}
/// <summary>
/// Prepara una celda que indica el número del día del mes
/// </summary>
/// <param name="cell">Celda a inicializar</param>
/// <param name="weight">Tamaño de la celda</param>
/// <param name="dayOfMonth">Día del mes</param>
/// <param name="monthDays">Total de días del mes</param>
private void InitializePorcentajeTotal(XRTableCell cell, double weight, int dayOfMonth, int monthDays)
{
cell.Name = String.Format("xrtPorcentajeTotalDay{0}", dayOfMonth);
cell.WidthF = (float)weight;
cell.Text = "";
if (CalcularDomingo(Anio.Value, Mes.Value, dayOfMonth))
{
cell.BackColor = Color.DarkGray;
}
}
/// <summary>
/// 打印[序号]
/// </summary>
private void tcMaterialIndex_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
XRTableCell cell = sender as XRTableCell;
if (cell == null)
{
return;
}
cell.Text = ConvertUtil.ToString(++this._skuIndex);
}
public XRLapHoaDonThanhToanNhapHang(HoaDonNhapHang hd)
{
InitializeComponent();
xlNgayGiaoHang.Text = hd.NgayGiaoHang;
xlNhaCungCap.Text = hd.NhaCungCap;
xlHoTenNhanVien.Text = hd.TenNhanVien;
xlNguoiLap.Text = hd.TenNhanVien;
DateTime ngaylap = Convert.ToDateTime(hd.NgayGiaoHang);
xlNgayLap.Text = "Ngày " + ngaylap.Day + " Tháng " + ngaylap.Month + " Năm " + ngaylap.Year;
xlTongTien.Text = "Tổng Tiền: " + hd.TongTien + " VND";
if (hd.DanhSachSanPham != null)
{
int cellsInRow = 4;
int rowsCount = hd.DanhSachSanPham.Rows.Count;
//do cao cua mot o trong table
float rowHeight = 20f;
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();
if (j == 0)
{
//them so thu tu
cell.Text = " " + i.ToString();
}
else
cell.Text = " " + hd.DanhSachSanPham.Rows[i].ItemArray[j - 1].ToString();
//chinh lai kich thuoc cua moi o
switch (j)
{
case 0:
cell.WidthF = 65;
break;
case 1:
cell.WidthF = 270;
break;
case 2:
cell.WidthF = 60;
break;
case 3:
cell.WidthF = 155;
cell.Text += " VND";
break;
}
row.Cells.Add(cell);
}
xtDanhSachMatHang.Rows.Add(row);
}
}
}
private void PrintSummaryCell(object sender, PrintEventArgs args)
{
XRTableCell cell = (XRTableCell)sender;
EmployeePlanningWeek employeeWeek = GetCurrentRow();
if (employeeWeek == null)
{
return;
}
switch ((string)cell.Tag)
{
case PrintoutConst.ContractWorkingHours:
cell.Text = DateTimeHelper.IntTimeToStr(employeeWeek.ContractHoursPerWeek);
break;
case PrintoutConst.AvailableHolidays:
cell.Text = DateTimeHelper.DecimalTimeToStr(0);
break;
case PrintoutConst.PlannedWorkingHours:
cell.Text = DateTimeHelper.IntTimeToStr(employeeWeek.CountWeeklyPlanningWorkingHours);
break;
case PrintoutConst.AdditionalWorkingHours:
{
if (employeeWeek.AllIn)
{
cell.Text = "--:--";
}
else
{
cell.Text = DateTimeHelper.IntTimeToStr(employeeWeek.CountWeeklyAdditionalCharges);
}
}
break;
case PrintoutConst.PlusMinusHours:
cell.Text = DateTimeHelper.IntTimeToStr(employeeWeek.CountWeeklyPlusMinusHours);
break;
case PrintoutConst.BalanceHours:
{
if (employeeWeek.AllIn)
{
cell.Text = "--:--";
}
else
{
cell.Text = DateTimeHelper.IntTimeToStr(employeeWeek.Saldo);
}
}
break;
}
}
private static void InsertPageNo(XRTable table)
{
var row = new XRTableRow();
var cell = new XRTableCell();
cell.Controls.Add(new XRPageInfo {
Font = StdFont9, Format = "Page {0} of {1}", WidthF = table.WidthF, TextAlignment = TextAlignment.MiddleRight
});
row.Cells.Add(cell);
table.Rows.Add(row);
}
public void BindStaticCells(XRTableCell gcEmployee, XRTableCell gcOldHolidays, XRTableCell gcNewHolidays,
XRTableCell gcSpareExc, XRTableCell gcSpareInc, XRTableCell gcAvailable, XRTableCell gcUsed)
{
gcEmployee.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.EmployeeName));
gcOldHolidays.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.OldHoliday, m_Format));
gcNewHolidays.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.NewHoliday, m_Format));
gcSpareExc.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.SpareExc, m_Format));
gcSpareInc.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.SpareInc, m_Format));
gcAvailable.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.AvailableHolidays, m_Format));
gcUsed.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.UsedHolidays, m_Format));
}
public void BindStaticCells(XRTableCell gcEmployee, XRTableCell gcOldHolidays, XRTableCell gcNewHolidays,
XRTableCell gcSpareExc, XRTableCell gcSpareInc, XRTableCell gcAvailable, XRTableCell gcUsed)
{
gcEmployee.DataBindings.Add(new XRBinding(PC.Text, m_Table,PC.EmployeeName));
gcOldHolidays.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.OldHoliday, m_Format));
gcNewHolidays.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.NewHoliday, m_Format));
gcSpareExc.DataBindings.Add (new XRBinding(PC.Text, m_Table, PC.SpareExc, m_Format));
gcSpareInc.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.SpareInc, m_Format));
gcAvailable.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.AvailableHolidays, m_Format));
gcUsed.DataBindings.Add(new XRBinding(PC.Text, m_Table, PC.UsedHolidays, m_Format));
}
/// <summary>
/// 設置報表底下說明
/// </summary>
/// <param name="memo"></param>
public void SetMemoInPageFooter(string memo)
{
XRTable xrTableFooter = new XRTable();
XRTableRow xrTableRowMemo = new XRTableRow();
XRTableCell xrTableCellMemo = new XRTableCell();
xrTableCellMemo.Text = memo;
xrTableRowMemo.Cells.Add(xrTableCellMemo);
xrTableFooter.Rows.Add(xrTableRowMemo);
Bands[BandKind.PageFooter].Controls.Add(xrTableFooter);
}
public static XRTableCell AddCell(this XRTableRow row, double weight, string text)
{
var newCell = new XRTableCell
{
Text = text,
Weight = weight,
};
row.Cells.Add(newCell);
return(newCell);
}
private void weekDataCell_BeforePrint(object sender, PrintEventArgs e)
{
XRTableCell cell = sender as XRTableCell;
if (!(cell.Tag == null || cell.Tag.Equals(string.Empty)))
{
string text; Color color;
m_Data.ParseTag(cell.Tag, out text, out color);
cell.Text = text;//.Replace(',', '/');
cell.BackColor = color;
}
}
public XRBaoCaoTonKho(BaoCaoTonKho bc)
{
InitializeComponent();
xlNgayLap.Text = bc.ThoiGian;
xlNhanVien.Text = StaticVariables.nhanVien.TenNhanVien;
if (bc.DanhSachSanPham != null)
{
int cellsInRow = 5;
int rowsCount = bc.DanhSachSanPham.Rows.Count;
//do cao cua mot o trong table
float rowHeight = 20f;
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();
if (j == 0)
{
//them so thu tu
cell.Text = " " + i.ToString();
}
else
cell.Text = " " + bc.DanhSachSanPham.Rows[i].ItemArray[j - 1].ToString();
//chinh lai kich thuoc cua moi o
switch (j)
{
case 0:
cell.WidthF = 35;
break;
case 1:
cell.WidthF = 120;
break;
case 2:
cell.WidthF = 250;
break;
case 3:
cell.WidthF = 240;
break;
case 4:
cell.WidthF = 85;
break;
}
row.Cells.Add(cell);
}
xtDanhSachMatHang.Rows.Add(row);
}
}
}
public static void tran1(XRTableCell ngay2, XRPageInfo xrPageInfo2)
{
if (Language == LanguageEnum.Vietnam)
{
ngay2.Text = "Ngày " + DateTime.Now.Day + ", Tháng " + DateTime.Now.Month + ", Năm " + DateTime.Now.Year;
xrPageInfo2.Format = "Trang {0}/{1}";
}
else
{
ngay2.Text = "ວັນທີ່ " + DateTime.Now.Day + ", ເດືອນ " + DateTime.Now.Month + ", ປີ " + DateTime.Now.Year;
xrPageInfo2.Format = "ໜ້າທີ {0}/{1}";
}
}
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);
}
private void ShowReservationInvoice()
{
xrReservation reservationInvoiceReport = new xrReservation();
if (Request.QueryString["ReservationID"] == null || Request.QueryString["ReservationID"] == string.Empty)
{
return;
}
ResMan.Reservation reservation = new ResMan.Reservation();
reservation.ReservationId = Convert.ToInt64(Request.QueryString["ReservationID"].ToString());
reservation = reservation.Select();
reservationInvoiceReport.xrCellInvoiceNo.Text = "Invoice No - INV" + reservation.ReservationId.ToString();
reservationInvoiceReport.xrCellInvoiceDate.Text = "Invoice Date - " + DateTime.Now.ToString();
reservationInvoiceReport.xrCellReservationCode.Text = "Code - " + reservation.ReservationCode;
reservationInvoiceReport.xrCellReservationDate.Text = "Booking Date - " + reservation.BookingDate.ToString();
StringBuilder sbCustomer = new StringBuilder();
sbCustomer.Append(reservation.CustomerName + Environment.NewLine);
sbCustomer.Append(reservation.BillingAddressLine1 + Environment.NewLine);
sbCustomer.Append(reservation.BillingAddressLine2 + Environment.NewLine);
sbCustomer.Append(reservation.BillingCity + ", ");
sbCustomer.Append(reservation.BillingPostCode + Environment.NewLine);
sbCustomer.Append(reservation.BillingState + ", " + reservation.CountryName);
reservationInvoiceReport.xrCellCustomer.Text = sbCustomer.ToString();
Company company = new Company();
company.CompanyId = SessionHandler.CurrentCompanyId;
company = company.Select();
if (company.CompanyLogo != null)
{
reservationInvoiceReport.xrPbLogo.Image = (Bitmap)((new ImageConverter()).ConvertFrom(company.CompanyLogo)); ;
}
reservationInvoiceReport.xrCellCompanyName.Text = company.CompanyName;
StringBuilder sbCompany = new StringBuilder();
sbCompany.Append(company.CompanyAddress + Environment.NewLine);
sbCompany.Append(company.CompanyCity + Environment.NewLine);
sbCompany.Append(company.CompanyEmail + Environment.NewLine);
sbCompany.Append("Tel - " + company.CompanyTelephone + Environment.NewLine);
sbCompany.Append("Fax - " + company.CompanyFax);
reservationInvoiceReport.xrCellCompnayAddress.Text = sbCompany.ToString();
DataSet dsRoomInfo = new DataSet();
dsRoomInfo = reservation.ReservationRoomDataSet;
//// Room info section
if (dsRoomInfo != null && dsRoomInfo.Tables.Count > 0 && dsRoomInfo.Tables[0] != null && dsRoomInfo.Tables[0].Rows.Count > 0)
{
decimal roomInfoTotal;
roomInfoTotal = 0;
for (int i = 0; i <= dsRoomInfo.Tables[0].Rows.Count - 1; i++)
{
if (i == 0)
{
reservationInvoiceReport.xrCellCustomerName.Text = dsRoomInfo.Tables[0].Rows[i]["Sharers"] != null ? dsRoomInfo.Tables[0].Rows[i]["Sharers"].ToString() : string.Empty;
reservationInvoiceReport.xrCellCheckIn.Text = dsRoomInfo.Tables[0].Rows[i]["CheckInDate"] != null ? Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckInDate"].ToString()).ToShortDateString() : string.Empty;
reservationInvoiceReport.xrCellCheckOut.Text = dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"] != null ? Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"].ToString()).ToShortDateString() : string.Empty;
reservationInvoiceReport.xrCellRoom.Text = dsRoomInfo.Tables[0].Rows[i]["RoomName"] != null ? dsRoomInfo.Tables[0].Rows[i]["RoomName"].ToString() : string.Empty;
reservationInvoiceReport.xrCellRate.Text = dsRoomInfo.Tables[0].Rows[i]["Rate"] != null ? dsRoomInfo.Tables[0].Rows[i]["Rate"].ToString() : string.Empty;
reservationInvoiceReport.xrCellNights.Text = dsRoomInfo.Tables[0].Rows[i]["Days"] != null ? dsRoomInfo.Tables[0].Rows[i]["Days"].ToString() : string.Empty;
reservationInvoiceReport.xrCellAmount.Text = dsRoomInfo.Tables[0].Rows[i]["Amount"] != null ? dsRoomInfo.Tables[0].Rows[i]["Amount"].ToString() : string.Empty;
roomInfoTotal = Convert.ToDecimal(reservationInvoiceReport.xrCellAmount.Text);
}
else
{
XRTableCell cell1 = new XRTableCell();
XRTableCell cell2 = new XRTableCell();
XRTableCell cell3 = new XRTableCell();
XRTableCell cell4 = new XRTableCell();
XRTableCell cell5 = new XRTableCell();
XRTableCell cell6 = new XRTableCell();
XRTableCell cell7 = new XRTableCell();
cell1.Text = dsRoomInfo.Tables[0].Rows[i]["Sharers"] != null ? dsRoomInfo.Tables[0].Rows[i]["Sharers"].ToString() : string.Empty;
cell2.Text = dsRoomInfo.Tables[0].Rows[i]["CheckInDate"] != null ? Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckInDate"].ToString()).ToShortDateString() : string.Empty;
cell3.Text = dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"] != null ? Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"].ToString()).ToShortDateString() : string.Empty;
cell4.Text = dsRoomInfo.Tables[0].Rows[i]["RoomName"] != null ? dsRoomInfo.Tables[0].Rows[i]["RoomName"].ToString() : string.Empty;
cell5.Text = dsRoomInfo.Tables[0].Rows[i]["Rate"] != null ? dsRoomInfo.Tables[0].Rows[i]["Rate"].ToString() : string.Empty;
cell6.Text = dsRoomInfo.Tables[0].Rows[i]["Days"] != null ? dsRoomInfo.Tables[0].Rows[i]["Days"].ToString() : string.Empty;
cell7.Text = dsRoomInfo.Tables[0].Rows[i]["Amount"] != null ? dsRoomInfo.Tables[0].Rows[i]["Amount"].ToString() : string.Empty;
roomInfoTotal = roomInfoTotal + Convert.ToDecimal(cell7.Text);
XRTableRow dataRow = new XRTableRow();
dataRow.Cells.Add(cell1);
dataRow.Cells.Add(cell2);
dataRow.Cells.Add(cell3);
dataRow.Cells.Add(cell4);
dataRow.Cells.Add(cell5);
dataRow.Cells.Add(cell6);
dataRow.Cells.Add(cell7);
cell1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF;
cell2.WidthF = reservationInvoiceReport.xrCellCheckIn.WidthF;
cell3.WidthF = reservationInvoiceReport.xrCellCheckOut.WidthF;
cell4.WidthF = reservationInvoiceReport.xrCellRoom.WidthF;
cell5.WidthF = reservationInvoiceReport.xrCellRate.WidthF;
cell6.WidthF = reservationInvoiceReport.xrCellNights.WidthF;
cell7.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cell1.TextAlignment = reservationInvoiceReport.xrCellCustomerName.TextAlignment;
cell7.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(dataRow);
}
}
//// Add total row
XRTableCell cellFooter1 = new XRTableCell();
XRTableCell cellFooter2 = new XRTableCell();
cellFooter1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellFooter2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
XRTableRow tableRowFooter = new XRTableRow();
cellFooter1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cellFooter2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cellFooter1.Text = "Room Total";
cellFooter1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cellFooter2.Text = roomInfoTotal.ToString();
cellFooter2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
tableRowFooter.Cells.Add(cellFooter1);
tableRowFooter.Cells.Add(cellFooter2);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowFooter);
XRTableCell blankCell = new XRTableCell();
blankCell.Text = " ";
blankCell.BackColor = System.Drawing.Color.LightGray;
XRTableRow blankRow = new XRTableRow();
blankRow.Cells.Add(blankCell);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(blankRow);
}
//// Additional Service section
DataSet dsAdditionalService = new DataSet();
dsAdditionalService = reservation.ReservationAdditionalServiceDataSet;
if (dsAdditionalService != null && dsAdditionalService.Tables.Count > 0 && dsAdditionalService.Tables[0] != null && dsAdditionalService.Tables[0].Rows.Count > 0)
{
XRTableCell cell1 = new XRTableCell();
XRTableCell cell2 = new XRTableCell();
XRTableCell cell3 = new XRTableCell();
cell1.Text = "Service Type";
cell2.Text = "Note";
cell3.Text = "Amount";
cell1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF;
cell2.WidthF = reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cell3.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cell1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cell2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cell3.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
XRTableRow headerRow = new XRTableRow();
headerRow.Cells.Add(cell1);
headerRow.Cells.Add(cell2);
headerRow.Cells.Add(cell3);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(headerRow);
decimal serviceTotal;
serviceTotal = 0;
for (int i = 0; i <= dsAdditionalService.Tables[0].Rows.Count - 1; i++)
{
XRTableCell dataCell1 = new XRTableCell();
XRTableCell dataCell2 = new XRTableCell();
XRTableCell dataCell3 = new XRTableCell();
dataCell1.Text = dsAdditionalService.Tables[0].Rows[i]["ServiceName"] != null ? dsAdditionalService.Tables[0].Rows[i]["ServiceName"].ToString() : string.Empty;
dataCell2.Text = dsAdditionalService.Tables[0].Rows[i]["Note"] != null ? dsAdditionalService.Tables[0].Rows[i]["Note"].ToString() : string.Empty;
dataCell3.Text = dsAdditionalService.Tables[0].Rows[i]["Amount"] != null ? dsAdditionalService.Tables[0].Rows[i]["Amount"].ToString() : string.Empty;
serviceTotal = serviceTotal + Convert.ToDecimal(dataCell3.Text);
dataCell1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF;
dataCell2.WidthF = reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
dataCell3.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
dataCell3.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
XRTableRow dataRow = new XRTableRow();
dataRow.Cells.Add(dataCell1);
dataRow.Cells.Add(dataCell2);
dataRow.Cells.Add(dataCell3);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(dataRow);
}
XRTableCell cellFooter1 = new XRTableCell();
XRTableCell cellFooter2 = new XRTableCell();
cellFooter1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellFooter2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
XRTableRow tableRowFooter = new XRTableRow();
cellFooter1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cellFooter2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cellFooter1.Text = "Service Total";
cellFooter1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cellFooter2.Text = serviceTotal.ToString();
cellFooter2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
tableRowFooter.Cells.Add(cellFooter1);
tableRowFooter.Cells.Add(cellFooter2);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowFooter);
XRTableCell blankCell1 = new XRTableCell();
blankCell1.Text = " ";
blankCell1.BackColor = System.Drawing.Color.LightGray;
XRTableRow blankRow1 = new XRTableRow();
blankRow1.Cells.Add(blankCell1);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(blankRow1);
}
//// Display Net Total
XRTableRow tableRowNetTotal = new XRTableRow();
XRTableCell cellNetTotal1 = new XRTableCell();
XRTableCell cellNetTotal2 = new XRTableCell();
cellNetTotal1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellNetTotal2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellNetTotal1.Text = "Net Total";
cellNetTotal2.Text = reservation.NetTotal.ToString();
cellNetTotal1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cellNetTotal2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cellNetTotal1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cellNetTotal2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
tableRowNetTotal.Cells.Add(cellNetTotal1);
tableRowNetTotal.Cells.Add(cellNetTotal2);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowNetTotal);
//// Display Discount
XRTableRow tableRowDiscount = new XRTableRow();
XRTableCell cellDiscount1 = new XRTableCell();
XRTableCell cellDiscount2 = new XRTableCell();
cellDiscount1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellDiscount2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellDiscount1.Text = "Discount";
cellDiscount2.Text = reservation.Discount.ToString();
cellDiscount1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cellDiscount2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cellDiscount1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cellDiscount2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
tableRowDiscount.Cells.Add(cellDiscount1);
tableRowDiscount.Cells.Add(cellDiscount2);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowDiscount);
//// Display Tax Amount
XRTableRow tableRowTaxType = new XRTableRow();
XRTableCell cellTaxType1 = new XRTableCell();
XRTableCell cellTaxType2 = new XRTableCell();
cellTaxType1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellTaxType2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellTaxType1.Text = "Tax Amount";
cellTaxType2.Text = reservation.TaxAmount.ToString();
cellTaxType1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cellTaxType2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cellTaxType1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cellTaxType2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
tableRowTaxType.Cells.Add(cellTaxType1);
tableRowTaxType.Cells.Add(cellTaxType2);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowTaxType);
//// Display Total
XRTableRow tableRowTotal = new XRTableRow();
XRTableCell cellTotal1 = new XRTableCell();
XRTableCell cellTotal2 = new XRTableCell();
cellTotal1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellTotal2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellTotal1.Text = "Total";
cellTotal2.Text = reservation.Total.ToString();
cellTotal1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cellTotal2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cellTotal1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cellTotal2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
tableRowTotal.Cells.Add(cellTotal1);
tableRowTotal.Cells.Add(cellTotal2);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowTotal);
//// Display Paid Amount
XRTableRow tableRowPaidAmount = new XRTableRow();
XRTableCell cellPaidAmount1 = new XRTableCell();
XRTableCell cellPaidAmount2 = new XRTableCell();
cellPaidAmount1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellPaidAmount2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellPaidAmount1.Text = "Paid Amount";
cellPaidAmount2.Text = reservation.PaidAmount.ToString();
cellPaidAmount1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cellPaidAmount2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cellPaidAmount1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cellPaidAmount2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
tableRowPaidAmount.Cells.Add(cellPaidAmount1);
tableRowPaidAmount.Cells.Add(cellPaidAmount2);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowPaidAmount);
//// Display Balance
XRTableRow tableRowBalance = new XRTableRow();
XRTableCell cellBalance1 = new XRTableCell();
XRTableCell cellBalance2 = new XRTableCell();
cellBalance1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellBalance2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellBalance1.Text = "Balance";
cellBalance2.Text = reservation.Balance.ToString();
cellBalance1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cellBalance2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cellBalance1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cellBalance2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
tableRowBalance.Cells.Add(cellBalance1);
tableRowBalance.Cells.Add(cellBalance2);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowBalance);
//// Payment section
DataSet dsPaymentSection = new DataSet();
dsPaymentSection = reservation.ReservationPaymentDataSet;
if (dsPaymentSection != null && dsPaymentSection.Tables.Count > 0 && dsPaymentSection.Tables[0] != null && dsPaymentSection.Tables[0].Rows.Count > 0)
{
XRTableCell blankCell = new XRTableCell();
blankCell.Text = " ";
blankCell.BackColor = System.Drawing.Color.LightGray;
XRTableRow blankRow = new XRTableRow();
blankRow.Cells.Add(blankCell);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(blankRow);
XRTableCell cell1 = new XRTableCell();
XRTableCell cell2 = new XRTableCell();
XRTableCell cell3 = new XRTableCell();
XRTableCell cell4 = new XRTableCell();
XRTableCell cell5 = new XRTableCell();
XRTableCell cell6 = new XRTableCell();
cell1.Text = "Type";
cell2.Text = "Payment Date";
cell3.Text = "Card Type";
cell4.Text = "Card No";
cell5.Text = "Name on Card";
cell6.Text = "Amount";
cell1.WidthF = 110;
cell2.WidthF = 126;
cell3.WidthF = 99;
cell4.WidthF = 161;
cell5.WidthF = 168;
cell6.WidthF = 117;
cell1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cell2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cell3.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cell4.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cell5.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cell6.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
XRTableRow headerRow = new XRTableRow();
headerRow.Cells.Add(cell1);
headerRow.Cells.Add(cell2);
headerRow.Cells.Add(cell3);
headerRow.Cells.Add(cell4);
headerRow.Cells.Add(cell5);
headerRow.Cells.Add(cell6);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(headerRow);
decimal paymentTotal;
paymentTotal = 0;
for (int i = 0; i <= dsPaymentSection.Tables[0].Rows.Count - 1; i++)
{
XRTableCell dataCell1 = new XRTableCell();
XRTableCell dataCell2 = new XRTableCell();
XRTableCell dataCell3 = new XRTableCell();
XRTableCell dataCell4 = new XRTableCell();
XRTableCell dataCell5 = new XRTableCell();
XRTableCell dataCell6 = new XRTableCell();
dataCell1.Text = dsPaymentSection.Tables[0].Rows[i]["PaymentTypeName"] != null ? dsPaymentSection.Tables[0].Rows[i]["PaymentTypeName"].ToString() : string.Empty;
dataCell2.Text = dsPaymentSection.Tables[0].Rows[i]["PaymentDate"] != null ? Convert.ToDateTime(dsPaymentSection.Tables[0].Rows[i]["PaymentDate"].ToString()).ToShortDateString() : string.Empty;
dataCell3.Text = dsPaymentSection.Tables[0].Rows[i]["Name"] != null ? dsPaymentSection.Tables[0].Rows[i]["Name"].ToString() : string.Empty;
dataCell4.Text = dsPaymentSection.Tables[0].Rows[i]["CCNo"] != null ? dsPaymentSection.Tables[0].Rows[i]["CCNo"].ToString() : string.Empty;
dataCell5.Text = dsPaymentSection.Tables[0].Rows[i]["CCNameOnCard"] != null ? dsPaymentSection.Tables[0].Rows[i]["CCNameOnCard"].ToString() : string.Empty;
dataCell6.Text = dsPaymentSection.Tables[0].Rows[i]["Amount"] != null ? dsPaymentSection.Tables[0].Rows[i]["Amount"].ToString() : string.Empty;
paymentTotal = paymentTotal + Convert.ToDecimal(dataCell6.Text);
dataCell1.WidthF = 110;
dataCell2.WidthF = 126;
dataCell3.WidthF = 99;
dataCell4.WidthF = 161;
dataCell5.WidthF = 168;
dataCell6.WidthF = 117;
dataCell6.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
XRTableRow dataRow = new XRTableRow();
dataRow.Cells.Add(dataCell1);
dataRow.Cells.Add(dataCell2);
dataRow.Cells.Add(dataCell3);
dataRow.Cells.Add(dataCell4);
dataRow.Cells.Add(dataCell5);
dataRow.Cells.Add(dataCell6);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(dataRow);
}
XRTableCell cellFooter1 = new XRTableCell();
XRTableCell cellFooter2 = new XRTableCell();
cellFooter1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
cellFooter2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
XRTableRow tableRowFooter = new XRTableRow();
cellFooter1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF;
cellFooter2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF;
cellFooter1.Text = "Total";
cellFooter1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cellFooter2.Text = paymentTotal.ToString();
cellFooter2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment;
tableRowFooter.Cells.Add(cellFooter1);
tableRowFooter.Cells.Add(cellFooter2);
reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowFooter);
}
rvReportViewer.Report = reservationInvoiceReport;
}
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;
}
/*
private IStampeService getStampeService()
{
return _stampeService ?? (_stampeService = ResolveComponent<IStampeService>());
}
*/
#endregion Service
#region Helper Methods
private void setBorder(ReportRataSoggettoDTO itemReport, XRTableCell cell, List<IGrouping<string, ReportRataSoggettoDTO>> dataSource, int indexItem, int idPartecipantePrecedente)
{
var skip = false;
if (itemReport.TipoNominativo == "PROP")
{
try
{
if (dataSource.Count > indexItem + 1)
{
var nextNominativo = dataSource[indexItem + 1].OrderBy(item => itemReport.NumeroRata).FirstOrDefault();
if (nextNominativo != null && itemReport.IdSoggettoCondominio != nextNominativo.IdSoggettoCondominio)
skip = true;
}
}
catch (Exception ex)
{
_log.ErrorFormat("Errore nell'impostazione del border - {0} - azienda:{1}", ex, Utility.GetMethodDescription(), Security.Login.Instance.CurrentLogin().Azienda);
throw;
}
}
if (!skip)
{
if (_impostazioniReport.BorderInsideGroup && (itemReport.TipoNominativo == "PROP" || itemReport.IdSoggettoCondominio == idPartecipantePrecedente))
setCellBorder(cell, dataSource.Count, indexItem, itemReport.IdSoggettoCondominio == idPartecipantePrecedente);
}
}
void setCellBorder(XRTableCell cell, int count, int index, bool partecipanteRipetuto = false)
{
if (count == 1)
cell.Borders = BorderSide.Top | BorderSide.Bottom | BorderSide.Left | BorderSide.Right;
else
{
if (partecipanteRipetuto)
{
if (index == 0)
cell.Borders = BorderSide.Left | BorderSide.Right | BorderSide.Top;
else
cell.Borders = BorderSide.Left | BorderSide.Right | BorderSide.Bottom;
}
else
{
if (index == 0)
cell.Borders = BorderSide.Left | BorderSide.Right | BorderSide.Top;
else if (index < count - 1)
cell.Borders = BorderSide.Left | BorderSide.Right;
else
cell.Borders = BorderSide.Left | BorderSide.Right | BorderSide.Bottom;
}
}
}
/*
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 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 void PrintPlannedDayCell(XRTableCell cell)
{
XRPanel panel = ReportPainter.GetPanelControl(cell);
panel.Width = cell.Width;
panel.Dock = XRDockStyle.Fill;
panel.Controls.Clear();
EmployeeDay employeeDay = null;
EmployeeWeekView employeeWeek = GetCurrentWeekView();
StoreDay storeDay = _recordingContext.StoreDays[(DateTime)cell.Tag];
if (employeeWeek != null && storeDay != null && employeeWeek.PlanningWeek != null)
{
employeeDay = employeeWeek.PlanningWeek.GetDay(storeDay.Date);
}
ReportPainter.ApplyEmployeeDayStyle(cell, storeDay, employeeDay, StoreToWorldID, _recordingContext);
ReportPainter.PrintDayCellValues(panel, employeeDay, _recordingContext);
}
/// <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>
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();
}
public virtual void BindDynamicCell(XRTableCell cell, int factor)
{
cell.DataBindings.Add(new XRBinding(PC.Tag, m_Table, PC.DynName(factor)));
}
/// <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();
}
public void BindData()
{
DataSource = new List<PrtOrder>{ Prt.PrtOrder};
this.xrRecvOprUser.DataBindings.Add("Text", Prt.PrtOrder, "RecvOprUser");
this.xrPrdNo.DataBindings.Add("Text", Prt.PrtOrder, "PrdNo");
this.xrReceiverName.DataBindings.Add("Text", Prt.PrtOrder, "ReceiverName");
this.xrCreateDate.DataBindings.Add("Text", Prt.PrtOrder, "Created");
this.xrProDelDate.DataBindings.Add("Text", Prt.PrtOrder, "ProDelDate");
this.xrOuterIid.DataBindings.Add("Text", Prt.PrtOrder, "OuterIid");
this.xrOuterSkuId.DataBindings.Add("Text", Prt.PrtOrder, "OuterSkuId");
this.xrSurface.DataBindings.Add("Text", Prt.PrtOrder, "Surface");
this.xrDirection.DataBindings.Add("Text", Prt.PrtOrder, "Direction");
this.xrColor.DataBindings.Add("Text", Prt.PrtOrder, "Color");
this.xrNum.DataBindings.Add("Text", Prt.PrtOrder, "Num");
this.xrRemark.DataBindings.Add("Text", Prt.PrtOrder, "Remark");
var totalrows=xrTable.Rows.Count;
if (totalrows > 5) {
for (int i = 0; i < totalrows - 5; i++) {
xrTable.Rows.RemoveAt(5);
}
}
if (Prt.Detail.Count > 0) {
int rows = Prt.Detail.Count % 2 > 0 ? Prt.Detail.Count / 2 + 1 : Prt.Detail.Count / 2;
var rs = new List<XRTableRow>();
for (int i = 0; i < rows; i++) {
XRTableRow row = new XRTableRow();
row.HeightF = 40;
rs.Add(row);
}
for (int i = 0; i < Prt.Detail.Count; i++) {
int rowidx = i / 2;
var cellidx = i % 2;
float cellwidth = 0f;
switch (cellidx) {
case 0:
XRTableCell cell = new XRTableCell();
cellwidth = 94.99f;
cell.WidthF = cellwidth;
cell.Text = Prt.Detail[i].ProceName;
rs[rowidx].Cells.Add(cell);
cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cell.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top;
cell = new XRTableCell();
cell.Text = Prt.Detail[i].ProceUser;
if (Prt.Detail.Count % 2 == 1 && rowidx == rs.Count - 1) {
cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cell.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top
| DevExpress.XtraPrinting.BorderSide.Right;
cellwidth = 705.01f;
} else {
cellwidth = 305.01f;
cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cell.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top;
}
cell.WidthF = cellwidth;
//cell.Text = Prt.Detail[i].ProceName;
rs[rowidx].Cells.Add(cell);
break;
case 1:
XRTableCell cell1 = new XRTableCell();
cellwidth = 138.07f;
cell1.WidthF = cellwidth;
cell1.Text = Prt.Detail[i].ProceName;
rs[rowidx].Cells.Add(cell1);
cell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cell1.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top;
cell1 = new XRTableCell();
cellwidth = 261.93f;
cell1.WidthF = cellwidth;
cell1.Text = Prt.Detail[i].ProceUser;
rs[rowidx].Cells.Add(cell1);
cell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cell1.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top
| DevExpress.XtraPrinting.BorderSide.Right;
break;
}
}
xrTable.Rows.AddRange(rs.ToArray());
rs = new List<XRTableRow>();
for (int i = 0; i < rows; i++) {
XRTableRow row = new XRTableRow();
row.HeightF = 40;
rs.Add(row);
}
for (int i = 0; i < Prt.Detail.Count; i++) {
int rowidx = i / 2;
var cellidx = i % 2;
float cellwidth = 0f;
switch (cellidx) {
case 0:
XRTableCell cell = new XRTableCell();
cellwidth = 94.99f;
cell.WidthF = cellwidth;
cell.Text = Prt.Detail[i].ProceName;
rs[rowidx].Cells.Add(cell);
cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
if (rowidx == rs.Count - 1) {
cell.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom;
} else {
cell.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top;
}
cell.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Dash;
cell = new XRTableCell();
cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
if (Prt.Detail.Count % 2 == 1 && rowidx == rs.Count - 1) {
cell.Borders = DevExpress.XtraPrinting.BorderSide.All;
cellwidth = 705.01f;
} else {
cellwidth = 305.01f;
cell.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top;
}
if (rowidx == rs.Count - 1) {
cell.Borders = cell.Borders | DevExpress.XtraPrinting.BorderSide.Bottom;
} else {
cell.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top;
}
cell.WidthF = cellwidth;
cell.Text = Prt.PrtOrder.PrdNo;
rs[rowidx].Cells.Add(cell);
cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
cell.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Dash;
break;
case 1:
XRTableCell cell1 = new XRTableCell();
cellwidth = 138.07f;
cell1.WidthF = cellwidth;
cell1.Text = Prt.Detail[i].ProceName;
rs[rowidx].Cells.Add(cell1);
cell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
if (rowidx == rs.Count - 1) {
cell1.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom;
} else {
cell1.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top;
}
cell1.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Dash;
cell1 = new XRTableCell();
cellwidth = 261.93f;
cell1.WidthF = cellwidth;
cell1.Text = Prt.PrtOrder.PrdNo;
rs[rowidx].Cells.Add(cell1);
cell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
if (rowidx == rs.Count - 1) {
cell1.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Bottom
| DevExpress.XtraPrinting.BorderSide.Right;
} else {
cell1.Borders = DevExpress.XtraPrinting.BorderSide.Left
| DevExpress.XtraPrinting.BorderSide.Top
| DevExpress.XtraPrinting.BorderSide.Right;
}
cell1.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Dash;
break;
}
}
xrTable.Rows.AddRange(rs.ToArray());
}
}
/// <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();
}
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);
}
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 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;
}
/// <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();
}
private void PrintDataCell(XRTableCell cell)
{
XRPanel panel = ReportPainter.GetPanelControl(cell);
panel.Dock = XRDockStyle.Fill;
panel.Controls.Clear();
EmployeePlanningDay planningDay = ProcessDayCell(cell);
if(planningDay.HasLongAbsence)
{
string s = _planningContext.GetLongTimeAbbreviation(planningDay.LongAbsenceId);
if(!String.IsNullOrEmpty(s))
{
XRLabel label = ReportPainter.AddLabelLine(panel, s, Color.Black, 0, false);
label.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
int? color = _planningContext.GetLongTimeAbsenceColor(planningDay.LongAbsenceId);
if (color.HasValue)
{
label.BackColor = Color.FromArgb(color.Value);
cell.BackColor = Color.FromArgb(color.Value);
}
//cell.Text = s;
//cell.ForeColor = Color.White;
//cell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
}
return;
} else
{
cell.ForeColor = Color.Black;
}
int y = 0;
foreach(__TimeRange range in GetDayTimes(planningDay))
{
XRLabel label = ReportPainter.AddLabelLine(panel, range.AsTimeString, String.IsNullOrEmpty(range.AbsenceCode) ? Color.Black : range.BeginColor, y, false);
y = y + label.Height + 1;
}
}