public IReportBuilder WithReportTitleBand(Dictionary <string, string> properties, double height = 0.0)
{
ReportTitleBand = new StiReportTitleBand(MakeRectangle(0, 0, 0, height));
Page.Components.Add(ReportTitleBand);
var y = 0.0;
foreach (var itm in properties)
{
var stiText = _textBuilder.New($"<b>{itm.Key}: </b>{itm.Value}").WithPosition(0, y).WithSize(ContentWidth)
.WithBorder(StiBorderSides.None).WithWordWrap(true).WithDockStyle(StiDockStyle.Top).Then();
ReportTitleBand.Components.Add(stiText);
y += 0.2;
}
ReportTitleBand.Height = y;
ReportTitleBand.BeforePrintEvent = new StiBeforePrintEvent("Xdec=Xdec+1;");
ReportTitleBand.AfterPrintEvent = new StiAfterPrintEvent("Xdec=Xdec+1;");
var xdec = _textBuilder.New("{Xdec}").WithPosition(0.2, 0.2).WithSize(2).WithAlign(StiTextHorAlignment.Center)
.WithFont(FontStyle.Bold, 15).Then();
ReportTitleBand.Components.Add(xdec);
return(this);
}
private void ReadReportTitleBand(XmlNode node, StiPage page)
{
StiReportTitleBand band = new StiReportTitleBand();
page.Components.Add(band);
ReadBand(node, band);
}
private void ReadReportHeaderBand(XtraReportBase xtraReport, ReportHeaderBand xtraBand, StiPage page)
{
StiBand band = null;
if (detailLevel == 0)
{
band = new StiReportTitleBand();
}
else
{
band = new StiHeaderBand();
(band as StiHeaderBand).PrintOnAllPages = false;
}
page.Components.Add(band);
ReadBand(xtraBand, band);
}
private void InitializeComponent()
{
FN_GetSalesOrderHeaderPurchaseTotal = new FN_GetSalesOrderHeaderPurchaseTotalDataSource();
NeedsCompiling = false;
Text18_Sum1 = new StiSumDecimalFunctionService();
Text18_Sum2 = new StiSumDecimalFunctionService();
Text17_Sum = new StiSumDecimalFunctionService();
Text16_Sum = new StiSumDecimalFunctionService();
Text7_Sum1 = new StiSumDecimalFunctionService();
Text7_Sum2 = new StiSumDecimalFunctionService();
Text6_Sum = new StiSumDecimalFunctionService();
Text5_Sum = new StiSumDecimalFunctionService();
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "Rpt Sales Order Header Purchase Total";
ReportAuthor = "Programmer.GE";
//
// ReportChanged
//
ReportChanged = new DateTime(2010, 2, 25, 21, 32, 48, 718);
//
// ReportCreated
//
ReportCreated = new DateTime(2009, 8, 6, 21, 34, 3, 0);
ReportDescription = "მოგების ჟურნალი (დაჯგუფებული)";
ReportFile = "D:\\My Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Sales\\Rpt" +
"SalesOrderHeaderPurchaseTotal.mrt";
ReportGuid = "f49a941abd3949d8932cb0fdd662bc9e";
ReportName = "RptSalesOrderHeaderPurchaseTotal";
ReportUnit = StiReportUnitType.Centimeters;
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.Guid = "5bf063ac2d254cd28a26e54f9ff09381";
Page1.Name = "Page1";
Page1.PageHeight = 29.7;
Page1.PageWidth = 21;
Page1.PaperSize = PaperKind.A4;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitleBand1
//
ReportTitleBand1 = new StiReportTitleBand();
ReportTitleBand1.ClientRectangle = new RectangleD(0, 0.4, 19, 0.8);
ReportTitleBand1.Name = "ReportTitleBand1";
ReportTitleBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
ReportTitleBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text1
//
Text1 = new StiText();
Text1.ClientRectangle = new RectangleD(0, 0, 19, 0.8);
Text1.HorAlignment = StiTextHorAlignment.Center;
Text1.Name = "Text1";
Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue);
Text1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text1.Brush = new StiSolidBrush(Color.Transparent);
Text1.Font = new Font("BPG Glaho Arial", 12F, FontStyle.Bold);
Text1.Guid = null;
Text1.Interaction = null;
Text1.Margins = new StiMargins(0, 0, 0, 0);
Text1.TextBrush = new StiSolidBrush(Color.Black);
Text1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
ReportTitleBand1.Guid = null;
ReportTitleBand1.Interaction = null;
//
// HeaderBand1
//
HeaderBand1 = new StiHeaderBand();
HeaderBand1.ClientRectangle = new RectangleD(0, 2, 19, 0.6);
HeaderBand1.Name = "HeaderBand1";
HeaderBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text8
//
Text8 = new StiText();
Text8.ClientRectangle = new RectangleD(0, 0, 5.8, 0.6);
Text8.HorAlignment = StiTextHorAlignment.Center;
Text8.Name = "Text8";
Text8.GetValue += new StiGetValueEventHandler(Text8__GetValue);
Text8.VertAlignment = StiVertAlignment.Center;
Text8.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text8.Brush = new StiSolidBrush(Color.Transparent);
Text8.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text8.Guid = null;
Text8.Interaction = null;
Text8.Margins = new StiMargins(0, 0, 0, 0);
Text8.TextBrush = new StiSolidBrush(Color.Black);
Text8.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text9
//
Text9 = new StiText();
Text9.ClientRectangle = new RectangleD(5.8, 0, 2, 0.6);
Text9.Guid = "f024598007b642c9b6f61c05578288bd";
Text9.HorAlignment = StiTextHorAlignment.Center;
Text9.Name = "Text9";
Text9.GetValue += new StiGetValueEventHandler(Text9__GetValue);
Text9.VertAlignment = StiVertAlignment.Center;
Text9.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text9.Brush = new StiSolidBrush(Color.Transparent);
Text9.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text9.Interaction = null;
Text9.Margins = new StiMargins(0, 0, 0, 0);
Text9.TextBrush = new StiSolidBrush(Color.Black);
Text9.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text10
//
Text10 = new StiText();
Text10.ClientRectangle = new RectangleD(7.8, 0, 2.4, 0.6);
Text10.Guid = "39898374932e4457b57d3316a524f5cb";
Text10.HorAlignment = StiTextHorAlignment.Center;
Text10.Name = "Text10";
Text10.GetValue += new StiGetValueEventHandler(Text10__GetValue);
Text10.VertAlignment = StiVertAlignment.Center;
Text10.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text10.Brush = new StiSolidBrush(Color.Transparent);
Text10.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text10.Interaction = null;
Text10.Margins = new StiMargins(0, 0, 0, 0);
Text10.TextBrush = new StiSolidBrush(Color.Black);
Text10.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text11
//
Text11 = new StiText();
Text11.ClientRectangle = new RectangleD(10.2, 0, 2.4, 0.6);
Text11.Guid = "95bb7db1a7624bec9498d8c9787dc960";
Text11.HorAlignment = StiTextHorAlignment.Center;
Text11.Name = "Text11";
Text11.GetValue += new StiGetValueEventHandler(Text11__GetValue);
Text11.VertAlignment = StiVertAlignment.Center;
Text11.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text11.Brush = new StiSolidBrush(Color.Transparent);
Text11.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text11.Interaction = null;
Text11.Margins = new StiMargins(0, 0, 0, 0);
Text11.TextBrush = new StiSolidBrush(Color.Black);
Text11.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text12
//
Text12 = new StiText();
Text12.ClientRectangle = new RectangleD(7.8, 0, 2.4, 0.6);
Text12.Guid = "07044fbd4db348d8a3ea69548d8d1c72";
Text12.HorAlignment = StiTextHorAlignment.Center;
Text12.Name = "Text12";
Text12.GetValue += new StiGetValueEventHandler(Text12__GetValue);
Text12.VertAlignment = StiVertAlignment.Center;
Text12.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text12.Brush = new StiSolidBrush(Color.Transparent);
Text12.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text12.Interaction = null;
Text12.Margins = new StiMargins(0, 0, 0, 0);
Text12.TextBrush = new StiSolidBrush(Color.Black);
Text12.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text13
//
Text13 = new StiText();
Text13.ClientRectangle = new RectangleD(10.2, 0, 2.4, 0.6);
Text13.Guid = "0974ed75540740f4af139745ad771e08";
Text13.HorAlignment = StiTextHorAlignment.Center;
Text13.Name = "Text13";
Text13.GetValue += new StiGetValueEventHandler(Text13__GetValue);
Text13.VertAlignment = StiVertAlignment.Center;
Text13.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text13.Brush = new StiSolidBrush(Color.Transparent);
Text13.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text13.Interaction = null;
Text13.Margins = new StiMargins(0, 0, 0, 0);
Text13.TextBrush = new StiSolidBrush(Color.Black);
Text13.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text14
//
Text14 = new StiText();
Text14.ClientRectangle = new RectangleD(12.6, 0, 2.4, 0.6);
Text14.Guid = "f11d8ef223974cbeb4dd9d4055d584bc";
Text14.HorAlignment = StiTextHorAlignment.Center;
Text14.Name = "Text14";
Text14.GetValue += new StiGetValueEventHandler(Text14__GetValue);
Text14.VertAlignment = StiVertAlignment.Center;
Text14.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text14.Brush = new StiSolidBrush(Color.Transparent);
Text14.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text14.Interaction = null;
Text14.Margins = new StiMargins(0, 0, 0, 0);
Text14.TextBrush = new StiSolidBrush(Color.Black);
Text14.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text15
//
Text15 = new StiText();
Text15.ClientRectangle = new RectangleD(15, 0, 4, 0.6);
Text15.Guid = "bbef06e2a66d48beb97e857e1eedbaec";
Text15.HorAlignment = StiTextHorAlignment.Center;
Text15.Name = "Text15";
Text15.GetValue += new StiGetValueEventHandler(Text15__GetValue);
Text15.VertAlignment = StiVertAlignment.Center;
Text15.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text15.Brush = new StiSolidBrush(Color.Transparent);
Text15.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text15.Interaction = null;
Text15.Margins = new StiMargins(0, 0, 0, 0);
Text15.TextBrush = new StiSolidBrush(Color.Black);
Text15.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
HeaderBand1.Guid = null;
HeaderBand1.Interaction = null;
//
// GroupHeaderBand2
//
GroupHeaderBand2 = new StiGroupHeaderBand();
GroupHeaderBand2.ClientRectangle = new RectangleD(0, 3.4, 19, 0.6);
GroupHeaderBand2.GetValue += new StiValueEventHandler(GroupHeaderBand2__GetValue);
GroupHeaderBand2.Guid = "d82d03aa1689442db9088bdf4fbd6f74";
GroupHeaderBand2.Name = "GroupHeaderBand2";
GroupHeaderBand2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
GroupHeaderBand2.Brush = new StiSolidBrush(Color.Transparent);
//
// Text2
//
Text2 = new StiText();
Text2.ClientRectangle = new RectangleD(0, 0, 5.8, 0.6);
Text2.Guid = "b4b9c81160034475a70f8e58952c143c";
Text2.Name = "Text2";
Text2.GetValue += new StiGetValueEventHandler(Text2__GetValue);
Text2.VertAlignment = StiVertAlignment.Center;
Text2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text2.Brush = new StiSolidBrush(Color.Transparent);
Text2.Font = new Font("BPG Glaho Arial", 10F);
Text2.Interaction = null;
Text2.Margins = new StiMargins(0, 0, 0, 0);
Text2.TextBrush = new StiSolidBrush(Color.Black);
Text2.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text3
//
Text3 = new StiText();
Text3.ClientRectangle = new RectangleD(5.8, 0, 2, 0.6);
Text3.Guid = "edcd73415b85450bacde997ae60d04b4";
Text3.HorAlignment = StiTextHorAlignment.Center;
Text3.Name = "Text3";
Text3.GetValue += new StiGetValueEventHandler(Text3__GetValue);
Text3.VertAlignment = StiVertAlignment.Center;
Text3.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text3.Brush = new StiSolidBrush(Color.Transparent);
Text3.Font = new Font("BPG Glaho Arial", 10F);
Text3.Interaction = null;
Text3.Margins = new StiMargins(0, 0, 0, 0);
Text3.TextBrush = new StiSolidBrush(Color.Black);
Text3.TextFormat = new StiDateFormatService("d", " ");
Text3.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text4
//
Text4 = new StiText();
Text4.ClientRectangle = new RectangleD(15, 0, 4, 0.6);
Text4.Name = "Text4";
Text4.GetValue += new StiGetValueEventHandler(Text4__GetValue);
Text4.VertAlignment = StiVertAlignment.Center;
Text4.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text4.Brush = new StiSolidBrush(Color.Transparent);
Text4.Font = new Font("BPG Glaho Arial", 10F);
Text4.Guid = null;
Text4.Interaction = null;
Text4.Margins = new StiMargins(0, 0, 0, 0);
Text4.TextBrush = new StiSolidBrush(Color.Black);
Text4.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text5
//
Text5 = new StiText();
Text5.ClientRectangle = new RectangleD(7.8, 0, 2.4, 0.6);
Text5.HorAlignment = StiTextHorAlignment.Right;
Text5.Name = "Text5";
//
// Text5_Sum
//
Text5.GetValue += new StiGetValueEventHandler(Text5__GetValue);
Text5.VertAlignment = StiVertAlignment.Center;
Text5.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text5.Brush = new StiSolidBrush(Color.Transparent);
Text5.Font = new Font("BPG Glaho Arial", 10F);
Text5.Guid = null;
Text5.Interaction = null;
Text5.Margins = new StiMargins(0, 0, 0, 0);
Text5.TextBrush = new StiSolidBrush(Color.Black);
Text5.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text5.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text6
//
Text6 = new StiText();
Text6.ClientRectangle = new RectangleD(10.2, 0, 2.4, 0.6);
Text6.Guid = "1f0c8f611f96466a9776c640bd6c1ba7";
Text6.HorAlignment = StiTextHorAlignment.Right;
Text6.Name = "Text6";
//
// Text6_Sum
//
Text6.GetValue += new StiGetValueEventHandler(Text6__GetValue);
Text6.VertAlignment = StiVertAlignment.Center;
Text6.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text6.Brush = new StiSolidBrush(Color.Transparent);
Text6.Font = new Font("BPG Glaho Arial", 10F);
Text6.Interaction = null;
Text6.Margins = new StiMargins(0, 0, 0, 0);
Text6.TextBrush = new StiSolidBrush(Color.Black);
Text6.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text6.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text7
//
Text7 = new StiText();
Text7.ClientRectangle = new RectangleD(12.6, 0, 2.4, 0.6);
Text7.Guid = "e1d414bc48834ba0ae5c02772f452d98";
Text7.HorAlignment = StiTextHorAlignment.Right;
Text7.Name = "Text7";
//
// Text7_Sum1
//
//
// Text7_Sum2
//
Text7.GetValue += new StiGetValueEventHandler(Text7__GetValue);
Text7.VertAlignment = StiVertAlignment.Center;
Text7.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text7.Brush = new StiSolidBrush(Color.Transparent);
Text7.Font = new Font("BPG Glaho Arial", 10F);
Text7.Interaction = null;
Text7.Margins = new StiMargins(0, 0, 0, 0);
Text7.TextBrush = new StiSolidBrush(Color.Black);
Text7.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text7.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
GroupHeaderBand2.Interaction = null;
//
// DataFN_GetSalesOrderHeaderPurchaseTotal
//
DataFN_GetSalesOrderHeaderPurchaseTotal = new StiDataBand();
DataFN_GetSalesOrderHeaderPurchaseTotal.CalcInvisible = true;
DataFN_GetSalesOrderHeaderPurchaseTotal.ClientRectangle = new RectangleD(0, 4.8, 19, 0.8);
DataFN_GetSalesOrderHeaderPurchaseTotal.DataSourceName = "FN_GetSalesOrderHeaderPurchaseTotal";
DataFN_GetSalesOrderHeaderPurchaseTotal.Enabled = false;
DataFN_GetSalesOrderHeaderPurchaseTotal.Name = "DataFN_GetSalesOrderHeaderPurchaseTotal";
DataFN_GetSalesOrderHeaderPurchaseTotal.Sort = new[] {
"ASC",
"OrderDate",
"ASC",
"BranchName",
"ASC",
"PaymentMethodName"
};
DataFN_GetSalesOrderHeaderPurchaseTotal.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataFN_GetSalesOrderHeaderPurchaseTotal.Brush = new StiSolidBrush(Color.Transparent);
DataFN_GetSalesOrderHeaderPurchaseTotal.DataRelationName = null;
DataFN_GetSalesOrderHeaderPurchaseTotal.Guid = null;
DataFN_GetSalesOrderHeaderPurchaseTotal.Interaction = null;
DataFN_GetSalesOrderHeaderPurchaseTotal.MasterComponent = null;
//
// FooterBand1
//
FooterBand1 = new StiFooterBand();
FooterBand1.ClientRectangle = new RectangleD(0, 6.4, 19, 0.6);
FooterBand1.Name = "FooterBand1";
FooterBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
FooterBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text16
//
Text16 = new StiText();
Text16.ClientRectangle = new RectangleD(7.8, 0, 2.4, 0.6);
Text16.HorAlignment = StiTextHorAlignment.Right;
Text16.Name = "Text16";
//
// Text16_Sum
//
Text16.GetValue += new StiGetValueEventHandler(Text16__GetValue);
Text16.VertAlignment = StiVertAlignment.Center;
Text16.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text16.Brush = new StiSolidBrush(Color.Transparent);
Text16.Font = new Font("BPG Glaho Arial", 10F);
Text16.Guid = null;
Text16.Interaction = null;
Text16.Margins = new StiMargins(0, 0, 0, 0);
Text16.TextBrush = new StiSolidBrush(Color.Black);
Text16.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text16.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text17
//
Text17 = new StiText();
Text17.ClientRectangle = new RectangleD(10.2, 0, 2.4, 0.6);
Text17.Guid = "f2dd3d749ca7442996cf2f1d37916060";
Text17.HorAlignment = StiTextHorAlignment.Right;
Text17.Name = "Text17";
//
// Text17_Sum
//
Text17.GetValue += new StiGetValueEventHandler(Text17__GetValue);
Text17.VertAlignment = StiVertAlignment.Center;
Text17.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text17.Brush = new StiSolidBrush(Color.Transparent);
Text17.Font = new Font("BPG Glaho Arial", 10F);
Text17.Interaction = null;
Text17.Margins = new StiMargins(0, 0, 0, 0);
Text17.TextBrush = new StiSolidBrush(Color.Black);
Text17.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text17.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text18
//
Text18 = new StiText();
Text18.ClientRectangle = new RectangleD(12.6, 0, 2.4, 0.6);
Text18.Guid = "5c8ac7b53c0e4fb8a58a0269915321bf";
Text18.HorAlignment = StiTextHorAlignment.Right;
Text18.Name = "Text18";
//
// Text18_Sum1
//
//
// Text18_Sum2
//
Text18.GetValue += new StiGetValueEventHandler(Text18__GetValue);
Text18.VertAlignment = StiVertAlignment.Center;
Text18.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text18.Brush = new StiSolidBrush(Color.Transparent);
Text18.Font = new Font("BPG Glaho Arial", 10F);
Text18.Interaction = null;
Text18.Margins = new StiMargins(0, 0, 0, 0);
Text18.TextBrush = new StiSolidBrush(Color.Black);
Text18.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text18.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
FooterBand1.Guid = null;
FooterBand1.Interaction = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(1, 1, 1, 1);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
RptSalesOrderHeaderPurchaseTotal_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptSalesOrderHeaderPurchaseTotal_PrinterSettings;
Page1.Page = Page1;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
ReportTitleBand1.Page = Page1;
ReportTitleBand1.Parent = Page1;
Text1.Page = Page1;
Text1.Parent = ReportTitleBand1;
HeaderBand1.Page = Page1;
HeaderBand1.Parent = Page1;
Text8.Page = Page1;
Text8.Parent = HeaderBand1;
Text9.Page = Page1;
Text9.Parent = HeaderBand1;
Text10.Page = Page1;
Text10.Parent = HeaderBand1;
Text11.Page = Page1;
Text11.Parent = HeaderBand1;
Text12.Page = Page1;
Text12.Parent = HeaderBand1;
Text13.Page = Page1;
Text13.Parent = HeaderBand1;
Text14.Page = Page1;
Text14.Parent = HeaderBand1;
Text15.Page = Page1;
Text15.Parent = HeaderBand1;
GroupHeaderBand2.Page = Page1;
GroupHeaderBand2.Parent = Page1;
Text2.Page = Page1;
Text2.Parent = GroupHeaderBand2;
Text3.Page = Page1;
Text3.Parent = GroupHeaderBand2;
Text4.Page = Page1;
Text4.Parent = GroupHeaderBand2;
Text5.Page = Page1;
Text5.Parent = GroupHeaderBand2;
Text6.Page = Page1;
Text6.Parent = GroupHeaderBand2;
Text7.Page = Page1;
Text7.Parent = GroupHeaderBand2;
DataFN_GetSalesOrderHeaderPurchaseTotal.Page = Page1;
DataFN_GetSalesOrderHeaderPurchaseTotal.Parent = Page1;
FooterBand1.Page = Page1;
FooterBand1.Parent = Page1;
Text16.Page = Page1;
Text16.Parent = FooterBand1;
Text17.Page = Page1;
Text17.Parent = FooterBand1;
Text18.Page = Page1;
Text18.Parent = FooterBand1;
GroupHeaderBand2.BeginRender += new EventHandler(GroupHeaderBand2__BeginRender);
GroupHeaderBand2.EndRender += new EventHandler(GroupHeaderBand2__EndRender);
DataFN_GetSalesOrderHeaderPurchaseTotal.BeginRender += new EventHandler(DataFN_GetSalesOrderHeaderPurchaseTotal__BeginRender);
DataFN_GetSalesOrderHeaderPurchaseTotal.EndRender += new EventHandler(DataFN_GetSalesOrderHeaderPurchaseTotal__EndRender);
GroupHeaderBand2.Rendering += new EventHandler(GroupHeaderBand2__Rendering);
DataFN_GetSalesOrderHeaderPurchaseTotal.Rendering += new EventHandler(DataFN_GetSalesOrderHeaderPurchaseTotal__Rendering);
AggregateFunctions = new object[] {
Text5_Sum,
Text6_Sum,
Text7_Sum1,
Text7_Sum2,
Text16_Sum,
Text17_Sum,
Text18_Sum1,
Text18_Sum2
};
//
// Add to ReportTitleBand1.Components
//
ReportTitleBand1.Components.Clear();
ReportTitleBand1.Components.AddRange(new StiComponent[] {
Text1
});
//
// Add to HeaderBand1.Components
//
HeaderBand1.Components.Clear();
HeaderBand1.Components.AddRange(new StiComponent[] {
Text8,
Text9,
Text10,
Text11,
Text12,
Text13,
Text14,
Text15
});
//
// Add to GroupHeaderBand2.Components
//
GroupHeaderBand2.Components.Clear();
GroupHeaderBand2.Components.AddRange(new StiComponent[] {
Text2,
Text3,
Text4,
Text5,
Text6,
Text7
});
//
// Add to FooterBand1.Components
//
FooterBand1.Components.Clear();
FooterBand1.Components.AddRange(new StiComponent[] {
Text16,
Text17,
Text18
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
ReportTitleBand1,
HeaderBand1,
GroupHeaderBand2,
DataFN_GetSalesOrderHeaderPurchaseTotal,
FooterBand1
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
FN_GetSalesOrderHeaderPurchaseTotal.Columns.AddRange(new[] {
new StiDataColumn("SalesOrderID", "SalesOrderID", "SalesOrderID", typeof(int)),
new StiDataColumn("BranchID", "BranchID", "BranchID", typeof(int)),
new StiDataColumn("BranchName", "BranchName", "BranchName", typeof(string)),
new StiDataColumn("OrderDate", "OrderDate", "OrderDate", typeof(DateTime)),
new StiDataColumn("SalesSubTotal", "SalesSubTotal", "SalesSubTotal", typeof(decimal)),
new StiDataColumn("SalesTaxAmt", "SalesTaxAmt", "SalesTaxAmt", typeof(decimal)),
new StiDataColumn("SalesFreight", "SalesFreight", "SalesFreight", typeof(decimal)),
new StiDataColumn("SalesTotalDue", "SalesTotalDue", "SalesTotalDue", typeof(decimal)),
new StiDataColumn("PurchaseSubTotal", "PurchaseSubTotal", "PurchaseSubTotal", typeof(decimal)),
new StiDataColumn("PurchaseTaxAmt", "PurchaseTaxAmt", "PurchaseTaxAmt", typeof(decimal)),
new StiDataColumn("CurrencyCode", "CurrencyCode", "CurrencyCode", typeof(string)),
new StiDataColumn("PaymentMethodName", "PaymentMethodName", "PaymentMethodName", typeof(string)),
new StiDataColumn("Status", "Status", "Status", typeof(byte))
});
DataSources.Add(FN_GetSalesOrderHeaderPurchaseTotal);
}
private void InitializeComponent()
{
VW_SalesOrderHeader = new VW_SalesOrderHeaderDataSource();
Dictionary.Variables.Add(new StiVariable("", "MyCompanyName", "MyCompanyName", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyTaxCode", "MyCompanyTaxCode", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyDirectorName", "MyCompanyDirectorName", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryCode", "MyCompanyCountryCode", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryName", "MyCompanyCountryName", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCity", "MyCompanyCity", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyPostalCode", "MyCompanyPostalCode", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyAddress", "MyCompanyAddress", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyPhone", "MyCompanyPhone", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyFax", "MyCompanyFax", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankName", "MyCompanyBankName", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankCode", "MyCompanyBankCode", typeof(string), "", false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankAccountNumber", "MyCompanyBankAccountNumber", typeof(string), "", false, false));
NeedsCompiling = false;
Text1_Sum = new StiSumDecimalFunctionService();
FooterText1_Count = new StiCountFunctionService();
// Variables init
// Variables init
MyCompanyName = "";
MyCompanyTaxCode = "";
MyCompanyDirectorName = "";
MyCompanyCountryCode = "";
MyCompanyCountryName = "";
MyCompanyCity = "";
MyCompanyPostalCode = "";
MyCompanyAddress = "";
MyCompanyPhone = "";
MyCompanyFax = "";
MyCompanyBankName = "";
MyCompanyBankCode = "";
MyCompanyBankAccountNumber = "";
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "Rpt Sales Order Header";
ReportAuthor = "Programmer.GE";
//
// ReportChanged
//
ReportChanged = new DateTime(2009, 6, 17, 11, 6, 30, 0);
//
// ReportCreated
//
ReportCreated = new DateTime(2009, 2, 8, 17, 26, 28, 0);
ReportDescription = "გაყიდვების რეპორტი";
ReportGuid = "2f64cd76b33a4817bb677636d7597eee";
ReportName = "RptSalesOrderHeader";
ReportUnit = StiReportUnitType.Centimeters;
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.Guid = "08a406f7186b4a67b5f7a96a78aa664a";
Page1.Name = "Page1";
Page1.PageHeight = 29.7;
Page1.PageWidth = 21;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitle
//
ReportTitle = new StiReportTitleBand();
ReportTitle.ClientRectangle = new RectangleD(0, 0.4, 19, 0.8);
ReportTitle.Name = "ReportTitle";
ReportTitle.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
ReportTitle.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitleText
//
ReportTitleText = new StiText();
ReportTitleText.ClientRectangle = new RectangleD(0, 0, 19, 0.8);
ReportTitleText.HorAlignment = StiTextHorAlignment.Center;
ReportTitleText.Name = "ReportTitleText";
ReportTitleText.GetValue += new StiGetValueEventHandler(ReportTitleText__GetValue);
ReportTitleText.Type = StiSystemTextType.Expression;
ReportTitleText.VertAlignment = StiVertAlignment.Center;
ReportTitleText.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
ReportTitleText.Brush = new StiSolidBrush(Color.Transparent);
ReportTitleText.Font = new Font("BPG Glaho Arial", 12F, FontStyle.Bold);
ReportTitleText.Guid = null;
ReportTitleText.Interaction = null;
ReportTitleText.Margins = new StiMargins(0, 0, 0, 0);
ReportTitleText.TextBrush = new StiSolidBrush(Color.Black);
ReportTitleText.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
ReportTitle.Guid = null;
ReportTitle.Interaction = null;
//
// Header
//
Header = new StiHeaderBand();
Header.ClientRectangle = new RectangleD(0, 2, 19, 0.8);
Header.Name = "Header";
Header.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Header.Brush = new StiSolidBrush(Color.Transparent);
//
// HeaderText1
//
HeaderText1 = new StiText();
HeaderText1.CanGrow = true;
HeaderText1.ClientRectangle = new RectangleD(0, 0, 2.8, 0.8);
HeaderText1.HorAlignment = StiTextHorAlignment.Center;
HeaderText1.Name = "HeaderText1";
HeaderText1.GetValue += new StiGetValueEventHandler(HeaderText1__GetValue);
HeaderText1.Type = StiSystemTextType.Expression;
HeaderText1.VertAlignment = StiVertAlignment.Center;
HeaderText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText1.Brush = new StiSolidBrush(Color.Transparent);
HeaderText1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText1.Guid = null;
HeaderText1.Interaction = null;
HeaderText1.Margins = new StiMargins(0, 0, 0, 0);
HeaderText1.TextBrush = new StiSolidBrush(Color.Black);
HeaderText1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText2
//
HeaderText2 = new StiText();
HeaderText2.CanGrow = true;
HeaderText2.ClientRectangle = new RectangleD(2.8, 0, 2, 0.8);
HeaderText2.HorAlignment = StiTextHorAlignment.Center;
HeaderText2.Name = "HeaderText2";
HeaderText2.GetValue += new StiGetValueEventHandler(HeaderText2__GetValue);
HeaderText2.Type = StiSystemTextType.Expression;
HeaderText2.VertAlignment = StiVertAlignment.Center;
HeaderText2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText2.Brush = new StiSolidBrush(Color.Transparent);
HeaderText2.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText2.Guid = null;
HeaderText2.Interaction = null;
HeaderText2.Margins = new StiMargins(0, 0, 0, 0);
HeaderText2.TextBrush = new StiSolidBrush(Color.Black);
HeaderText2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText3
//
HeaderText3 = new StiText();
HeaderText3.CanGrow = true;
HeaderText3.ClientRectangle = new RectangleD(4.8, 0, 6.4, 0.8);
HeaderText3.HorAlignment = StiTextHorAlignment.Center;
HeaderText3.Name = "HeaderText3";
HeaderText3.GetValue += new StiGetValueEventHandler(HeaderText3__GetValue);
HeaderText3.Type = StiSystemTextType.Expression;
HeaderText3.VertAlignment = StiVertAlignment.Center;
HeaderText3.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText3.Brush = new StiSolidBrush(Color.Transparent);
HeaderText3.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText3.Guid = null;
HeaderText3.Interaction = null;
HeaderText3.Margins = new StiMargins(0, 0, 0, 0);
HeaderText3.TextBrush = new StiSolidBrush(Color.Black);
HeaderText3.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText4
//
HeaderText4 = new StiText();
HeaderText4.CanGrow = true;
HeaderText4.ClientRectangle = new RectangleD(11.2, 0, 2.8, 0.8);
HeaderText4.HorAlignment = StiTextHorAlignment.Center;
HeaderText4.Name = "HeaderText4";
HeaderText4.GetValue += new StiGetValueEventHandler(HeaderText4__GetValue);
HeaderText4.Type = StiSystemTextType.Expression;
HeaderText4.VertAlignment = StiVertAlignment.Center;
HeaderText4.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText4.Brush = new StiSolidBrush(Color.Transparent);
HeaderText4.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText4.Guid = null;
HeaderText4.Interaction = null;
HeaderText4.Margins = new StiMargins(0, 0, 0, 0);
HeaderText4.TextBrush = new StiSolidBrush(Color.Black);
HeaderText4.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText5
//
HeaderText5 = new StiText();
HeaderText5.CanGrow = true;
HeaderText5.ClientRectangle = new RectangleD(14, 0, 1.6, 0.8);
HeaderText5.HorAlignment = StiTextHorAlignment.Center;
HeaderText5.Name = "HeaderText5";
HeaderText5.GetValue += new StiGetValueEventHandler(HeaderText5__GetValue);
HeaderText5.Type = StiSystemTextType.Expression;
HeaderText5.VertAlignment = StiVertAlignment.Center;
HeaderText5.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText5.Brush = new StiSolidBrush(Color.Transparent);
HeaderText5.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText5.Guid = null;
HeaderText5.Interaction = null;
HeaderText5.Margins = new StiMargins(0, 0, 0, 0);
HeaderText5.TextBrush = new StiSolidBrush(Color.Black);
HeaderText5.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText6
//
HeaderText6 = new StiText();
HeaderText6.CanGrow = true;
HeaderText6.ClientRectangle = new RectangleD(15.6, 0, 3.4, 0.8);
HeaderText6.HorAlignment = StiTextHorAlignment.Center;
HeaderText6.Name = "HeaderText6";
HeaderText6.GetValue += new StiGetValueEventHandler(HeaderText6__GetValue);
HeaderText6.Type = StiSystemTextType.Expression;
HeaderText6.VertAlignment = StiVertAlignment.Center;
HeaderText6.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderText6.Brush = new StiSolidBrush(Color.Transparent);
HeaderText6.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText6.Guid = null;
HeaderText6.Interaction = null;
HeaderText6.Margins = new StiMargins(0, 0, 0, 0);
HeaderText6.TextBrush = new StiSolidBrush(Color.Black);
HeaderText6.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
Header.Guid = null;
Header.Interaction = null;
//
// GroupHeader0
//
GroupHeader0 = new StiGroupHeaderBand();
GroupHeader0.ClientRectangle = new RectangleD(0, 3.6, 19, 0.8);
GroupHeader0.GetValue += new StiValueEventHandler(GroupHeader0__GetValue);
GroupHeader0.Name = "GroupHeader0";
GroupHeader0.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
GroupHeader0.Brush = new StiSolidBrush(Color.Transparent);
//
// GroupHeaderText0
//
GroupHeaderText0 = new StiText();
GroupHeaderText0.CanGrow = true;
GroupHeaderText0.ClientRectangle = new RectangleD(0, 0, 19, 0.8);
GroupHeaderText0.Name = "GroupHeaderText0";
GroupHeaderText0.GetValue += new StiGetValueEventHandler(GroupHeaderText0__GetValue);
GroupHeaderText0.VertAlignment = StiVertAlignment.Center;
GroupHeaderText0.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
GroupHeaderText0.Brush = new StiSolidBrush(Color.Transparent);
GroupHeaderText0.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
GroupHeaderText0.Guid = null;
GroupHeaderText0.Interaction = null;
GroupHeaderText0.Margins = new StiMargins(0, 0, 0, 0);
GroupHeaderText0.TextBrush = new StiSolidBrush(Color.Black);
GroupHeaderText0.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
GroupHeader0.Guid = null;
GroupHeader0.Interaction = null;
//
// Data
//
Data = new StiDataBand();
Data.ClientRectangle = new RectangleD(0, 5.2, 19, 0.6);
Data.DataSourceName = "VW_SalesOrderHeader";
Data.Name = "Data";
Data.Sort = new[] {
"ASC",
"BranchName",
"ASC",
"OrderDate"
};
Data.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Data.Brush = new StiSolidBrush(Color.Transparent);
//
// DataText1
//
DataText1 = new StiText();
DataText1.ClientRectangle = new RectangleD(0, 0, 2.2, 0.6);
DataText1.Name = "DataText1";
DataText1.GetValue += new StiGetValueEventHandler(DataText1__GetValue);
DataText1.VertAlignment = StiVertAlignment.Center;
DataText1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText1.Brush = new StiSolidBrush(Color.Transparent);
DataText1.Font = new Font("BPG Glaho Arial", 10F);
DataText1.Guid = null;
DataText1.Interaction = null;
DataText1.Margins = new StiMargins(0, 0, 0, 0);
DataText1.TextBrush = new StiSolidBrush(Color.Black);
DataText1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText2
//
DataText2 = new StiText();
DataText2.ClientRectangle = new RectangleD(2.2, 0, 3.2, 0.6);
DataText2.Name = "DataText2";
DataText2.GetValue += new StiGetValueEventHandler(DataText2__GetValue);
DataText2.VertAlignment = StiVertAlignment.Center;
DataText2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText2.Brush = new StiSolidBrush(Color.Transparent);
DataText2.Font = new Font("BPG Glaho Arial", 10F);
DataText2.Guid = null;
DataText2.Interaction = null;
DataText2.Margins = new StiMargins(0, 0, 0, 0);
DataText2.TextBrush = new StiSolidBrush(Color.Black);
DataText2.TextFormat = new StiCustomFormatService("G");
DataText2.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText3
//
DataText3 = new StiText();
DataText3.ClientRectangle = new RectangleD(5.4, 0, 5.8, 0.6);
DataText3.Name = "DataText3";
DataText3.GetValue += new StiGetValueEventHandler(DataText3__GetValue);
DataText3.Type = StiSystemTextType.Expression;
DataText3.VertAlignment = StiVertAlignment.Center;
DataText3.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText3.Brush = new StiSolidBrush(Color.Transparent);
DataText3.Font = new Font("BPG Glaho Arial", 10F);
DataText3.Guid = null;
DataText3.Interaction = null;
DataText3.Margins = new StiMargins(0, 0, 0, 0);
DataText3.TextBrush = new StiSolidBrush(Color.Black);
DataText3.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText4
//
DataText4 = new StiText();
DataText4.ClientRectangle = new RectangleD(11.2, 0, 2.8, 0.6);
DataText4.HorAlignment = StiTextHorAlignment.Right;
DataText4.Name = "DataText4";
DataText4.GetValue += new StiGetValueEventHandler(DataText4__GetValue);
DataText4.VertAlignment = StiVertAlignment.Center;
DataText4.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText4.Brush = new StiSolidBrush(Color.Transparent);
DataText4.Font = new Font("BPG Glaho Arial", 10F);
DataText4.Guid = null;
DataText4.Interaction = null;
DataText4.Margins = new StiMargins(0, 0, 0, 0);
DataText4.TextBrush = new StiSolidBrush(Color.Black);
DataText4.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
DataText4.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText5
//
DataText5 = new StiText();
DataText5.ClientRectangle = new RectangleD(14, 0, 1.6, 0.6);
DataText5.HorAlignment = StiTextHorAlignment.Center;
DataText5.Name = "DataText5";
DataText5.GetValue += new StiGetValueEventHandler(DataText5__GetValue);
DataText5.VertAlignment = StiVertAlignment.Center;
DataText5.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText5.Brush = new StiSolidBrush(Color.Transparent);
DataText5.Font = new Font("BPG Glaho Arial", 10F);
DataText5.Guid = null;
DataText5.Interaction = null;
DataText5.Margins = new StiMargins(0, 0, 0, 0);
DataText5.TextBrush = new StiSolidBrush(Color.Black);
DataText5.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText6
//
DataText6 = new StiText();
DataText6.ClientRectangle = new RectangleD(15.6, 0, 3.4, 0.6);
DataText6.Name = "DataText6";
DataText6.GetValue += new StiGetValueEventHandler(DataText6__GetValue);
DataText6.VertAlignment = StiVertAlignment.Center;
DataText6.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataText6.Brush = new StiSolidBrush(Color.Transparent);
DataText6.Font = new Font("BPG Glaho Arial", 10F);
DataText6.Guid = null;
DataText6.Interaction = null;
DataText6.Margins = new StiMargins(0, 0, 0, 0);
DataText6.TextBrush = new StiSolidBrush(Color.Black);
DataText6.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
Data.Guid = null;
Data.Interaction = null;
Data.MasterComponent = null;
//
// GroupFooter0
//
GroupFooter0 = new StiGroupFooterBand();
GroupFooter0.ClientRectangle = new RectangleD(0, 6.6, 19, 0.4);
GroupFooter0.Name = "GroupFooter0";
GroupFooter0.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
GroupFooter0.Brush = new StiSolidBrush(Color.Transparent);
GroupFooter0.Guid = null;
GroupFooter0.Interaction = null;
//
// Footer
//
Footer = new StiFooterBand();
Footer.ClientRectangle = new RectangleD(0, 7.8, 19, 0.6);
Footer.Name = "Footer";
Footer.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Footer.Brush = new StiSolidBrush(Color.Transparent);
//
// FooterText1
//
FooterText1 = new StiText();
FooterText1.CanGrow = true;
FooterText1.ClientRectangle = new RectangleD(0, 0, 2.2, 0.6);
FooterText1.HorAlignment = StiTextHorAlignment.Center;
FooterText1.Name = "FooterText1";
//
// FooterText1_Count
//
FooterText1.GetValue += new StiGetValueEventHandler(FooterText1__GetValue);
FooterText1.Type = StiSystemTextType.Expression;
FooterText1.VertAlignment = StiVertAlignment.Center;
FooterText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
FooterText1.Brush = new StiSolidBrush(Color.Transparent);
FooterText1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
FooterText1.Guid = null;
FooterText1.Interaction = null;
FooterText1.Margins = new StiMargins(0, 0, 0, 0);
FooterText1.TextBrush = new StiSolidBrush(Color.Black);
FooterText1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text1
//
Text1 = new StiText();
Text1.ClientRectangle = new RectangleD(11.2, 0, 2.8, 0.6);
Text1.HorAlignment = StiTextHorAlignment.Right;
Text1.Name = "Text1";
//
// Text1_Sum
//
Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue);
Text1.Type = StiSystemTextType.Totals;
Text1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text1.Brush = new StiSolidBrush(Color.Transparent);
Text1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
Text1.Guid = null;
Text1.Interaction = null;
Text1.Margins = new StiMargins(0, 0, 0, 0);
Text1.TextBrush = new StiSolidBrush(Color.Black);
Text1.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, true, " ");
Text1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
Footer.Guid = null;
Footer.Interaction = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(1, 1, 1, 1);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
RptSalesOrderHeader_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptSalesOrderHeader_PrinterSettings;
Page1.Page = Page1;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
ReportTitle.Page = Page1;
ReportTitle.Parent = Page1;
ReportTitleText.Page = Page1;
ReportTitleText.Parent = ReportTitle;
Header.Page = Page1;
Header.Parent = Page1;
HeaderText1.Page = Page1;
HeaderText1.Parent = Header;
HeaderText2.Page = Page1;
HeaderText2.Parent = Header;
HeaderText3.Page = Page1;
HeaderText3.Parent = Header;
HeaderText4.Page = Page1;
HeaderText4.Parent = Header;
HeaderText5.Page = Page1;
HeaderText5.Parent = Header;
HeaderText6.Page = Page1;
HeaderText6.Parent = Header;
GroupHeader0.Page = Page1;
GroupHeader0.Parent = Page1;
GroupHeaderText0.Page = Page1;
GroupHeaderText0.Parent = GroupHeader0;
Data.Page = Page1;
Data.Parent = Page1;
DataText1.Page = Page1;
DataText1.Parent = Data;
DataText2.Page = Page1;
DataText2.Parent = Data;
DataText3.Page = Page1;
DataText3.Parent = Data;
DataText4.Page = Page1;
DataText4.Parent = Data;
DataText5.Page = Page1;
DataText5.Parent = Data;
DataText6.Page = Page1;
DataText6.Parent = Data;
GroupFooter0.Page = Page1;
GroupFooter0.Parent = Page1;
Footer.Page = Page1;
Footer.Parent = Page1;
FooterText1.Page = Page1;
FooterText1.Parent = Footer;
Text1.Page = Page1;
Text1.Parent = Footer;
Data.BeginRender += new EventHandler(Data__BeginRender);
Data.EndRender += new EventHandler(Data__EndRender);
Data.Rendering += new EventHandler(Data__Rendering);
AggregateFunctions = new object[] {
FooterText1_Count,
Text1_Sum
};
//
// Add to ReportTitle.Components
//
ReportTitle.Components.Clear();
ReportTitle.Components.AddRange(new StiComponent[] {
ReportTitleText
});
//
// Add to Header.Components
//
Header.Components.Clear();
Header.Components.AddRange(new StiComponent[] {
HeaderText1,
HeaderText2,
HeaderText3,
HeaderText4,
HeaderText5,
HeaderText6
});
//
// Add to GroupHeader0.Components
//
GroupHeader0.Components.Clear();
GroupHeader0.Components.AddRange(new StiComponent[] {
GroupHeaderText0
});
//
// Add to Data.Components
//
Data.Components.Clear();
Data.Components.AddRange(new StiComponent[] {
DataText1,
DataText2,
DataText3,
DataText4,
DataText5,
DataText6
});
//
// Add to Footer.Components
//
Footer.Components.Clear();
Footer.Components.AddRange(new StiComponent[] {
FooterText1,
Text1
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
ReportTitle,
Header,
GroupHeader0,
Data,
GroupFooter0,
Footer
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
VW_SalesOrderHeader.Columns.AddRange(new[] {
new StiDataColumn("SalesOrderID", "SalesOrderID", "SalesOrderID", typeof(int)),
new StiDataColumn("BranchID", "BranchID", "BranchID", typeof(int)),
new StiDataColumn("BranchName", "BranchName", "BranchName", typeof(string)),
new StiDataColumn("OrderDate", "OrderDate", "OrderDate", typeof(DateTime)),
new StiDataColumn("OverheadNumber", "OverheadNumber", "OverheadNumber", typeof(string)),
new StiDataColumn("CustomerID", "CustomerID", "CustomerID", typeof(int)),
new StiDataColumn("CustomerName", "CustomerName", "CustomerName", typeof(string)),
new StiDataColumn("SubTotal", "SubTotal", "SubTotal", typeof(decimal)),
new StiDataColumn("TaxAmt", "TaxAmt", "TaxAmt", typeof(decimal)),
new StiDataColumn("Freight", "Freight", "Freight", typeof(decimal)),
new StiDataColumn("TotalDue", "TotalDue", "TotalDue", typeof(decimal)),
new StiDataColumn("CurrencyCode", "CurrencyCode", "CurrencyCode", typeof(string)),
new StiDataColumn("CurrencyRateID", "CurrencyRateID", "CurrencyRateID", typeof(int)),
new StiDataColumn("PaymentMethodID", "PaymentMethodID", "PaymentMethodID", typeof(int)),
new StiDataColumn("PaymentMethodName", "PaymentMethodName", "PaymentMethodName", typeof(string)),
new StiDataColumn("RevisionNumber", "RevisionNumber", "RevisionNumber", typeof(byte)),
new StiDataColumn("Status", "Status", "Status", typeof(byte)),
new StiDataColumn("ModifiedUserID", "ModifiedUserID", "ModifiedUserID", typeof(int)),
new StiDataColumn("Modifier", "Modifier", "Modifier", typeof(string)),
new StiDataColumn("ModifiedDate", "ModifiedDate", "ModifiedDate", typeof(DateTime)),
new StiDataColumn("ApproverUserID", "ApproverUserID", "ApproverUserID", typeof(int)),
new StiDataColumn("Approver", "Approver", "Approver", typeof(string))
});
DataSources.Add(VW_SalesOrderHeader);
}
private void ShowReport()
{
StiReport report = new StiReport();
float columnsWidth = 0;
DataTable table = new DataTable("ReportData");
for (int i = 0; i < dgvList.Columns.Count; i++)
{
table.Columns.Add(dgvList.Columns[i].Name, dgvList.Columns[i].ValueType);
columnsWidth += dgvList.Columns[i].Width;
}
for (int i = 0; i < dgvList.Rows.Count; i++)
{
DataRow row = table.NewRow();
for (int j = 0; j < dgvList.Columns.Count; j++)
{
row[dgvList.Columns[j].Name] = dgvList[j, i].Value;
}
table.Rows.Add(row);
}
report.RegData(table);
report.Dictionary.Synchronize();
StiPage page = report.Pages[0];
StiReportTitleBand titleBand = new StiReportTitleBand();
titleBand.Height = 1.0;
titleBand.Name = "TitleBand";
page.Components.Add(titleBand);
StiText titleText = new StiText(new RectangleD(0, 0, page.Width, 1));
titleText.Name = "TitleText";
titleText.Text = Text + " " + pickPlan.Value.ToShortDateString();
titleText.Width = page.Width;
titleText.HorAlignment = StiTextHorAlignment.Center;
titleText.Font = new Font("Arial", 10);
titleBand.Components.Add(titleText);
//Create HeaderBand
StiHeaderBand headerBand = new StiHeaderBand();
headerBand.Height = 0.5;
headerBand.Name = "HeaderBand";
page.Components.Add(headerBand);
float bandWidth = (float)page.Width;
float multiplier = bandWidth / columnsWidth;
float previousWidth = 0;
//Create text on header
for (int i = 0; i < dgvList.Columns.Count; i++)
{
StiText headerText = new StiText(new RectangleD(previousWidth, 0, dgvList.Columns[i].Width * multiplier, 0.5));
headerText.Text = dgvList.Columns[i].HeaderText;
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText" + i.ToString();
headerText.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid);
headerText.Brush = new StiSolidBrush(Color.LightGreen);
headerBand.Components.Add(headerText);
previousWidth += dgvList.Columns[i].Width * multiplier;
}
//Create Databand
StiDataBand dataBand = new StiDataBand();
dataBand.DataSourceName = "ReportData";
dataBand.Height = 0.5;
dataBand.Name = "DataBand";
page.Components.Add(dataBand);
previousWidth = 0;
//Create text
for (int i = 0; i < dgvList.Columns.Count; i++)
{
RectangleD rectangle = new RectangleD(previousWidth, 0, dgvList.Columns[i].Width * multiplier, 1);
StiText dataText = new StiText(rectangle);
dataText.Format = dgvList.Columns[i].DefaultCellStyle.Format;
dataText.Text = "{ReportData." + dgvList.Columns[i].Name + "}";
dataText.Name = "DataText" + i.ToString();
dataText.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid);
dataBand.Components.Add(dataText);
previousWidth += dgvList.Columns[i].Width * multiplier;
}
//Create FooterBand
StiFooterBand footerBand = new StiFooterBand();
footerBand.Height = 0.5;
footerBand.Name = "FooterBand";
page.Components.Add(footerBand);
//Create text on footer
StiText footerText = new StiText(new RectangleD(0, 0, 5, 0.5));
footerText.Text = "Всего - {Count()} строк";
footerText.HorAlignment = StiTextHorAlignment.Right;
footerText.Name = "FooterText";
footerText.Brush = new StiSolidBrush(Color.LightGreen);
footerBand.Components.Add(footerText);
report.Save("D:\\report.mrt");
report.Show();
}
private void InitializeComponent()
{
VW_Country = new VW_CountryDataSource();
NeedsCompiling = false;
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "Rpt Country";
//
// ReportChanged
//
ReportChanged = new DateTime(2009, 2, 7, 14, 30, 56, 0);
//
// ReportCreated
//
ReportCreated = new DateTime(2008, 9, 2, 21, 7, 22, 0);
ReportFile = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Dictionary\\RptCountry.mrt";
ReportGuid = "af5c1e936cdf4e129cbdeae2455e3cea";
ReportName = "RptCountry";
ReportUnit = StiReportUnitType.Centimeters;
ReportVersion = "2008.2.300";
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.ColumnGaps = 1;
Page1.Columns = 2;
Page1.ColumnWidth = 9;
Page1.Guid = "cace94e76442472aa8acc7b42034809c";
Page1.Name = "Page1";
Page1.PageHeight = 29.7;
Page1.PageWidth = 21;
Page1.PaperSize = PaperKind.A4;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitle
//
ReportTitle = new StiReportTitleBand();
ReportTitle.ClientRectangle = new RectangleD(0, 0.4, 9, 0.8);
ReportTitle.Name = "ReportTitle";
ReportTitle.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
ReportTitle.Brush = new StiSolidBrush(Color.Transparent);
//
// ReportTitleText
//
ReportTitleText = new StiText();
ReportTitleText.ClientRectangle = new RectangleD(0, 0, 19, 0.8);
ReportTitleText.HorAlignment = StiTextHorAlignment.Center;
ReportTitleText.Name = "ReportTitleText";
ReportTitleText.GetValue += new StiGetValueEventHandler(ReportTitleText__GetValue);
ReportTitleText.Type = StiSystemTextType.Expression;
ReportTitleText.VertAlignment = StiVertAlignment.Center;
ReportTitleText.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
ReportTitleText.Brush = new StiSolidBrush(Color.Transparent);
ReportTitleText.Font = new Font("BPG Glaho Arial", 12F, FontStyle.Bold);
ReportTitleText.Guid = null;
ReportTitleText.Indicator = null;
ReportTitleText.Interaction = null;
ReportTitleText.Margins = new StiMargins(0, 0, 0, 0);
ReportTitleText.TextBrush = new StiSolidBrush(Color.Black);
ReportTitleText.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
ReportTitle.Guid = null;
ReportTitle.Interaction = null;
//
// Header
//
Header = new StiHeaderBand();
Header.ClientRectangle = new RectangleD(0, 2, 9, 0.8);
Header.Name = "Header";
Header.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
Header.Brush = new StiSolidBrush(Color.Transparent);
//
// HeaderText1
//
HeaderText1 = new StiText();
HeaderText1.ClientRectangle = new RectangleD(0, 0, 2, 0.8);
HeaderText1.Name = "HeaderText1";
HeaderText1.GetValue += new StiGetValueEventHandler(HeaderText1__GetValue);
HeaderText1.Type = StiSystemTextType.Expression;
HeaderText1.VertAlignment = StiVertAlignment.Center;
HeaderText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
HeaderText1.Brush = new StiSolidBrush(Color.Transparent);
HeaderText1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText1.Guid = null;
HeaderText1.Indicator = null;
HeaderText1.Interaction = null;
HeaderText1.Margins = new StiMargins(0, 0, 0, 0);
HeaderText1.TextBrush = new StiSolidBrush(Color.Black);
HeaderText1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderText2
//
HeaderText2 = new StiText();
HeaderText2.ClientRectangle = new RectangleD(2, 0, 7, 0.8);
HeaderText2.Name = "HeaderText2";
HeaderText2.GetValue += new StiGetValueEventHandler(HeaderText2__GetValue);
HeaderText2.Type = StiSystemTextType.Expression;
HeaderText2.VertAlignment = StiVertAlignment.Center;
HeaderText2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
HeaderText2.Brush = new StiSolidBrush(Color.Transparent);
HeaderText2.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold);
HeaderText2.Guid = null;
HeaderText2.Indicator = null;
HeaderText2.Interaction = null;
HeaderText2.Margins = new StiMargins(0, 0, 0, 0);
HeaderText2.TextBrush = new StiSolidBrush(Color.Black);
HeaderText2.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
Header.Guid = null;
Header.Interaction = null;
//
// DataVW_Country
//
DataVW_Country = new StiDataBand();
DataVW_Country.ClientRectangle = new RectangleD(0, 3.6, 9, 0.6);
DataVW_Country.DataSourceName = "VW_Country";
DataVW_Country.Name = "DataVW_Country";
DataVW_Country.Sort = new[] {
"ASC",
"CountryCode"
};
DataVW_Country.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
DataVW_Country.Brush = new StiSolidBrush(Color.Transparent);
DataVW_Country.BusinessObjectGuid = null;
//
// DataText1
//
DataText1 = new StiText();
DataText1.ClientRectangle = new RectangleD(0, 0, 2, 0.6);
DataText1.GrowToHeight = true;
DataText1.Name = "DataText1";
DataText1.GetValue += new StiGetValueEventHandler(DataText1__GetValue);
DataText1.Type = StiSystemTextType.Expression;
DataText1.VertAlignment = StiVertAlignment.Center;
DataText1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
DataText1.Brush = new StiSolidBrush(Color.Transparent);
DataText1.Font = new Font("BPG Glaho Arial", 10F);
DataText1.Guid = null;
DataText1.Indicator = null;
DataText1.Interaction = null;
DataText1.Margins = new StiMargins(0, 0, 0, 0);
DataText1.TextBrush = new StiSolidBrush(Color.Black);
DataText1.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataText2
//
DataText2 = new StiText();
DataText2.CanGrow = true;
DataText2.ClientRectangle = new RectangleD(2, 0, 7, 0.6);
DataText2.Name = "DataText2";
DataText2.GetValue += new StiGetValueEventHandler(DataText2__GetValue);
DataText2.Type = StiSystemTextType.Expression;
DataText2.VertAlignment = StiVertAlignment.Center;
DataText2.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
DataText2.Brush = new StiSolidBrush(Color.Transparent);
DataText2.Font = new Font("BPG Glaho Arial", 10F);
DataText2.Guid = null;
DataText2.Indicator = null;
DataText2.Interaction = null;
DataText2.Margins = new StiMargins(0, 0, 0, 0);
DataText2.TextBrush = new StiSolidBrush(Color.Black);
DataText2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
DataVW_Country.Guid = null;
DataVW_Country.Interaction = null;
DataVW_Country.MasterComponent = null;
//
// Footer
//
Footer = new StiFooterBand();
Footer.ClientRectangle = new RectangleD(0, 5, 9, 0.6);
Footer.Name = "Footer";
Footer.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black), false);
Footer.Brush = new StiSolidBrush(Color.Transparent);
Footer.Guid = null;
Footer.Interaction = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(1, 1, 1, 1);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
RptCountry_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptCountry_PrinterSettings;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
ReportTitle.Page = Page1;
ReportTitle.Parent = Page1;
ReportTitleText.Page = Page1;
ReportTitleText.Parent = ReportTitle;
Header.Page = Page1;
Header.Parent = Page1;
HeaderText1.Page = Page1;
HeaderText1.Parent = Header;
HeaderText2.Page = Page1;
HeaderText2.Parent = Header;
DataVW_Country.Page = Page1;
DataVW_Country.Parent = Page1;
DataText1.Page = Page1;
DataText1.Parent = DataVW_Country;
DataText2.Page = Page1;
DataText2.Parent = DataVW_Country;
Footer.Page = Page1;
Footer.Parent = Page1;
//
// Add to ReportTitle.Components
//
ReportTitle.Components.Clear();
ReportTitle.Components.AddRange(new StiComponent[] {
ReportTitleText
});
//
// Add to Header.Components
//
Header.Components.Clear();
Header.Components.AddRange(new StiComponent[] {
HeaderText1,
HeaderText2
});
//
// Add to DataVW_Country.Components
//
DataVW_Country.Components.Clear();
DataVW_Country.Components.AddRange(new StiComponent[] {
DataText1,
DataText2
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
ReportTitle,
Header,
DataVW_Country,
Footer
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
VW_Country.Columns.AddRange(new[] {
new StiDataColumn("Approver", "Approver", "Approver", typeof(string)),
new StiDataColumn("ApproverUserID", "ApproverUserID", "ApproverUserID", typeof(int)),
new StiDataColumn("CountryCode", "CountryCode", "CountryCode", typeof(string)),
new StiDataColumn("ModifiedDate", "ModifiedDate", "ModifiedDate", typeof(DateTime)),
new StiDataColumn("ModifiedUserID", "ModifiedUserID", "ModifiedUserID", typeof(int)),
new StiDataColumn("Modifier", "Modifier", "Modifier", typeof(string)),
new StiDataColumn("Name", "Name", "Name", typeof(string)),
new StiDataColumn("Status", "Status", "Status", typeof(byte))
});
DataSources.Add(VW_Country);
}
private void CreateReport(DataTable table, DataGridView dgv, string title, string subtitle)
{
StiReport report = new StiReport();
StiDataTableSource sourceTable = new StiDataTableSource("DS", "DS", "DS");
report.Dictionary.DataSources.Add(sourceTable);
report.RegData("DS", "DS", table);
sourceTable.SynchronizeColumns();
StiPage page = report.Pages.Items[0];
page.Orientation = StiPageOrientation.Landscape;
double pageW = page.Width;
double pageH = page.Height;
//============заголовок
StiText headerReport = new StiText(new RectangleD(new PointD(0, 0), new SizeD(pageW, 0.6)),
"Заголовок1");
headerReport.Font = new Font("Arial", 10, FontStyle.Bold);
headerReport.HorAlignment = StiTextHorAlignment.Center;
headerReport.Text = "История обработок";
StiText subtitleReport = new StiText(new RectangleD(new PointD(0, 0.6), new SizeD(pageW, 0.4)),
"Подзаголовок1");
subtitleReport.Font = new Font("Arial", 10, FontStyle.Regular);
subtitleReport.HorAlignment = StiTextHorAlignment.Center;
subtitleReport.Text = subtitle;
PointD BrandLoc = new PointD(0, 0.4);
//хедер рапорта
StiReportTitleBand headerPage = new StiReportTitleBand(new RectangleD(BrandLoc, new SizeD(pageW, 1.2)));
page.Components.Add(headerPage);
headerPage.Components.Add(headerReport);
headerPage.Components.Add(subtitleReport);
//хедер таблицы
BrandLoc = new PointD(0, 1.2);
StiHeaderBand headerTable = new StiHeaderBand(new RectangleD(BrandLoc, new SizeD(pageW, 0.6)));
page.Components.Add(headerTable);
//область данных
PointD BrandDataLoc = new PointD(0, 1.8);
StiDataBand BrandData = new StiDataBand(new RectangleD(BrandDataLoc, new SizeD(pageW, 0.4)));
page.Components.Add(BrandData);
BrandData.DataSourceName = "DS";
StiPageFooterBand FooterBand = new StiPageFooterBand();
page.Components.Add(FooterBand);
FooterBand.Height = 0.6;
StiText FooterNameTxt = new StiText(new RectangleD(0, 0, pageW, 0.6));
FooterNameTxt.Text = title;
FooterNameTxt.ShrinkFontToFit = true;
FooterNameTxt.HorAlignment = StiTextHorAlignment.Right;
FooterNameTxt.ShrinkFontToFitMinimumSize = 8;
StiText FooterTxt = new StiText(new RectangleD(0, 0, 1, 0.6));
FooterTxt.Text = "Лист {PageNumber}";
FooterTxt.ShrinkFontToFit = true;
FooterTxt.ShrinkFontToFitMinimumSize = 8;
FooterBand.Components.Add(FooterNameTxt);
FooterBand.Components.Add(FooterTxt);
StiText TimeText = new StiText(new RectangleD(-0.2, -0.4, 3, 0.6));
TimeText.Text = "{Time}";
TimeText.ShrinkFontToFit = true;
TimeText.ShrinkFontToFitMinimumSize = 8;
page.Components.Add(TimeText);
double numWidth = .5;
double Wkoef = pageW / GetColumnWidth(table, dgv);
double prevX = 0; //numWidth;
//StiText headerNum = new StiText(new RectangleD(BrandLoc.X, 0, numWidth, 0.4));
//headerNum.Border.Side = StiBorderSides.All;
//headerNum.Border.Size = 1.5;
//headerNum.Text = "N п/п";
//headerNum.Font = new Font("Arial", 8, FontStyle.Bold);
//headerNum.HorAlignment = StiTextHorAlignment.Center;
//headerNum.ShrinkFontToFit = true;
//headerNum.ShrinkFontToFitMinimumSize = 8;
//headerTable.Components.Add(headerNum);
//StiText dataNum = new StiText(new RectangleD(BrandLoc.X, 0, numWidth, 0.4));
//dataNum.Border.Side = StiBorderSides.All;
//dataNum.ShrinkFontToFit = true;
//dataNum.ShrinkFontToFitMinimumSize = 8;
//dataNum.Text = "{Line}";
//dataNum.HorAlignment = StiTextHorAlignment.Right;
//dataNum.Font = new Font("Arial", 8, FontStyle.Regular);
//BrandData.Components.Add(dataNum);
foreach (DataColumn column in table.Columns) //добалвляем в область заголовка и в область данных
{
string colName = column.ColumnName;
DataGridViewColumn dgvColumn = dgv.Columns[colName];
StiText headerTXT = new StiText(new RectangleD(BrandLoc.X + prevX, 0,
dgvColumn.Width * Wkoef, 0.4));
headerTXT.Border.Side = StiBorderSides.All;
headerTXT.Border.Size = 1.5;
headerTXT.Text = dgvColumn.HeaderText;
headerTXT.Font = new Font("Arial", 8, FontStyle.Bold);
headerTXT.HorAlignment = StiTextHorAlignment.Center;
headerTXT.ShrinkFontToFit = true;
headerTXT.ShrinkFontToFitMinimumSize = 8;
headerTable.Components.Add(headerTXT);
StiText dataTXT = new StiText(new RectangleD(BrandLoc.X + prevX, 0,
dgvColumn.Width * Wkoef, 0.4));
dataTXT.Border.Side = StiBorderSides.All;
dataTXT.ShrinkFontToFit = true;
dataTXT.ShrinkFontToFitMinimumSize = 8;
dataTXT.Font = new Font("Arial", 8, FontStyle.Regular);
if (column.DataType == typeof(bool))
{
dataTXT.Text = "{IIF(DS." + colName + ", \"+\", \"\")}";
}
else
{
dataTXT.Text = "{DS." + colName + "}";
}
if (column.DataType == typeof(DateTime))
{
string dateFormat = "dd.MM.yyyy HH:mm";
dataTXT.TextFormat = new StiDateFormatService(dateFormat, "");
}
if (column.DataType == typeof(double))
{
dataTXT.TextFormat = new StiNumberFormatService(1, ".", 1, ",", 3, true, true, " ");
}
switch (dgvColumn.DefaultCellStyle.Alignment)
{
case DataGridViewContentAlignment.BottomCenter:
case DataGridViewContentAlignment.MiddleCenter:
case DataGridViewContentAlignment.TopCenter:
dataTXT.HorAlignment = StiTextHorAlignment.Center;
break;
case DataGridViewContentAlignment.BottomLeft:
case DataGridViewContentAlignment.MiddleLeft:
case DataGridViewContentAlignment.TopLeft:
dataTXT.HorAlignment = StiTextHorAlignment.Left;
break;
case DataGridViewContentAlignment.BottomRight:
case DataGridViewContentAlignment.MiddleRight:
case DataGridViewContentAlignment.TopRight:
dataTXT.HorAlignment = StiTextHorAlignment.Right;
break;
}
BrandData.Components.Add(dataTXT);
prevX += dgvColumn.Width * Wkoef;
}
report.Show();
}
internal static void AddStitexts(StiText headerText, StiText dataText, ref StiReportTitleBand titleBand, ref StiDataBand dataBand, ref double x, double width)
{
titleBand.Components.Add(headerText);
dataBand.Components.Add(dataText);
x = (double) (x + width);
}
public static StiReport GenerateReportFromDataTable(System.Data.DataTable dataTable, string reportHeader, StiPageOrientation orientation)
{
if ((dataTable == null) || (dataTable.Rows.get_Count() == 0))
{
throw new System.ApplicationException("Не сформирован входящий набор данных.");
}
StiReport report = new StiReport();
report.RegData("data", (System.Data.DataTable) dataTable);
report.Dictionary.Synchronize();
report.Dictionary.DataSources[0].Name = "data";
report.Dictionary.DataSources[0].Alias = "data";
StiReportTitleBand titleBand = new StiReportTitleBand {
Height = 2.0,
Name = "TitleBand"
};
StiText component = new StiText(new RectangleD(0.0, 0.0, 30.0, 1.0), reportHeader) {
DockStyle = StiDockStyle.Top,
HorAlignment = StiTextHorAlignment.Center,
Name = "TextHeader",
Font = (System.Drawing.Font) new System.Drawing.Font("Arial", 12f, System.Drawing.FontStyle.Regular),
Editable = true
};
titleBand.Components.Add(component);
StiDataBand dataBand = new StiDataBand {
DataSourceName = "data",
Height = 1.0,
Name = "DataBand"
};
double x = 0.0;
double y = 0.0;
double height = 1.0;
System.Data.DataView view = new System.Data.DataView(dataTable);
view.set_Sort("OrderColumn");
int num4 = 0;
foreach (System.Data.DataRow row in view.ToTable("OutputTable").Rows)
{
if (System.Convert.ToBoolean(row.get_Item("PrintColumn")))
{
double width = System.Convert.ToDouble(row.get_Item("WidthColumn"));
component = CreateHeaderStiText("TextHeader" + ((int) num4), row.get_Item("HeaderColumn").ToString(), x, 1.0, width, 1.0);
StiText dataText = CreateDataStiText("TextData" + ((int) num4), row.get_Item("DataColumn").ToString(), System.Convert.ToBoolean(row.get_Item("AlignColumn")), x, y, width, height);
AddStitexts(component, dataText, ref titleBand, ref dataBand, ref x, width);
}
num4 = (int) (num4 + 1);
}
report.Pages[0].Components.Add(titleBand);
report.Pages[0].Components.Add(dataBand);
report.Pages[0].Orientation = orientation;
report.Pages[0].Margins = new StiMargins(0.5, 0.5, 0.5, 0.5);
return report;
}
static StiReport MakeReport(DBGrid grid, ReportCreateParam param)
{
JMXSchema schema = grid.Schema;
DataTable dt = grid.BaseTable;
double top = 0;
float fontSize = param.FontSize;
string tableName = TableAliasDefault;;
StiReport report = new StiReport
{
ScriptLanguage = StiReportLanguageType.CSharp,
ReportName = schema.Name
};
//report.RegData(tableName, dt);
report.RegData(tableName, grid.GetBindingSource());
report.Dictionary.Synchronize();
report.Dictionary.DataSources[0].Name = tableName;
report.Dictionary.DataSources[0].Alias = tableName;
StiPage page = report.Pages.Items[0];
page.Margins.Left = 1;
page.Margins.Right = 1;
page.AlignToGrid();
//ReportTitle
bool titleOnPage = param.TitleOnPage;
StiReportTitleBand titleBand = new StiReportTitleBand
{
Height = 0.5f,
CanGrow = true,
Name = "TitleBand"
};
page.Components.Add(titleBand);
//Period
bool period = param.Period;
if (period)
{
StiText periodText = new StiText(new RectangleD(0, 0, page.Width, 0.5f));
periodText.Text.Value = rth.Za();
periodText.HorAlignment = StiTextHorAlignment.Right;
periodText.Name = "periodText";
periodText.Border.Side = StiBorderSides.None;
//periodText.DockStyle = StiDockStyle.Right;
periodText.Font = new Font(grid.Font.FontFamily.Name, fontSize, FontStyle.Bold);
titleBand.Components.Add(periodText);
top += periodText.Height;
}
//Title
StiText titleText = new StiText(new RectangleD(0, period ? 0.5f : 0, page.Width, 1f));
titleText.Text.Value = grid.Schema.Name;
titleText.HorAlignment = StiTextHorAlignment.Center;
titleText.Name = "titleText";
titleText.Border.Side = StiBorderSides.None;
titleText.Font = new Font(grid.Font.FontFamily.Name, 12f, FontStyle.Bold);
titleText.WordWrap = true;
titleText.CanGrow = true;
titleBand.Components.Add(titleText);
top += titleText.Height;
//Create HeaderBand
StiBand headBand;
StiHeaderBand headerBand = new StiHeaderBand
{
Height = 0.5f,
Name = "HeaderBand"
};
if (titleOnPage)
{
page.Components.Add(headerBand);
headBand = headerBand;
}
else
{
headBand = titleBand;
}
//Create Databand
StiDataBand dataBand = new StiDataBand
{
DataSourceName = tableName,
Height = 0.5f,
Name = "DataBand"
};
page.Components.Add(dataBand);
//Create FooterBand
StiFooterBand footerBand = new StiFooterBand
{
Height = 0.5f,
CanGrow = true,
Name = "FooterBand",
CanBreak = false
};
page.Components.Add(footerBand);
Double pos = 0;
int nameIndex = 1;
int i = 0;
bool multiLine = param.MultiLine;
int border = param.Border;
bool totals = false;
List <StiText> footerList = new List <StiText>();
foreach (DataGridViewColumn column in grid.Columns)
{
bool visible = (column.Visible && column.Width > 1);
if (visible)
{
Double columnWidth = StiAlignValue.AlignToMinGrid(column.Width / 33, 0.03, true);
//Create text on header
StiText headerText = new StiText(new RectangleD(pos, titleOnPage ? 0: top, columnWidth, 0.5f));
headerText.Text.Value = column.HeaderText;
headerText.HorAlignment = StiTextHorAlignment.Center;
headerText.Name = "HeaderText" + nameIndex.ToString();
if (border == 0)
{
headerText.Border.Side = StiBorderSides.Top | StiBorderSides.Bottom;
}
else
{
headerText.Border.Side = StiBorderSides.All;
}
headerText.CanGrow = true;
headerText.GrowToHeight = true;
headerText.WordWrap = multiLine;
headerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, fontSize);
headBand.Components.Add(headerText);
MacroType tt = DBGridBase.GetMacroType(schema.Attributes[i].DataType);
string format = column.DefaultCellStyle.Format;
if (string.IsNullOrEmpty(format) && tt == MacroType.date)
{
format = vbo.DateFormat;
}
StiTextHorAlignment horAlign;
switch (column.DefaultCellStyle.Alignment)
{
case DataGridViewContentAlignment.MiddleRight:
horAlign = StiTextHorAlignment.Right;
break;
case DataGridViewContentAlignment.MiddleLeft:
horAlign = StiTextHorAlignment.Left;
break;
default:
horAlign = StiTextHorAlignment.Center;
break;
}
//Create text on Data Band
StiText dataText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f));
string field = tableName + "." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.ReplaceSymbols(column.DataPropertyName);
if (AccntFormat.ValidFormat(format))
{
dataText.Text.Value = "{Substring(" + field + ",0,5)+" + "-".Qt() +
"+Substring(" + field + ",5,3)+" + "-".Qt() +
"+Substring(" + field + ",8,1)+" + "-".Qt() +
"+Substring(" + field + ",9,4)+" + "-".Qt() +
"+Substring(" + field + ",13,7)" + "}";
}
else
{
dataText.Text.Value = "{" + field + "}";
}
dataText.Name = "DataText" + nameIndex.ToString();
dataText.CanGrow = true;
dataText.GrowToHeight = true;
dataText.WordWrap = multiLine;
dataText.HorAlignment = horAlign;
//dataText.VertAlignment = StiVertAlignment.Center;
if (border == 0)
{
dataText.Border.Side = StiBorderSides.None;
}
else if (border == 1)
{
dataText.Border.Side = StiBorderSides.Bottom;
}
else
{
dataText.Border.Side = StiBorderSides.All;
}
if (grid.RowsDefaultCellStyle.Font == null)
{
dataText.Font = new Font(grid.Font.FontFamily.Name, fontSize);
}
else
{
dataText.Font = new Font(grid.RowsDefaultCellStyle.Font.FontFamily.Name, fontSize);
}
dataText.TextFormat = ParseFormat(format);
if (tt == MacroType.num)
{
dataText.ExcelValue.Value = "{" + field + "}";
}
dataBand.Components.Add(dataText);
//Create text on footer
string summary = schema.Attributes[i].Agregate.ToLower();
if (summary == "sum")
{
summary = "Sum(" + field + ")";
}
else if (summary == "rcnt")
{
summary = "Count()";
}
else if (summary == "ave")
{
summary = "Avg(" + field + ")";
}
else if (summary == "min")
{
summary = "Min(" + field + ")";
}
else if (summary == "max")
{
summary = "Max(" + field + ")";
}
else
{
summary = string.Empty;
}
bool summaryEmpty = string.IsNullOrEmpty(summary);
int footerIndex = i;
//if (!string.IsNullOrEmpty(grid.FooterText(footerIndex)))
if (!summaryEmpty)
{
totals = true;
}
StiText footerText = new StiText(new RectangleD(pos, 0, columnWidth, 0.5f));
if (footerIndex == 0 && summaryEmpty)
{
footerText.Text.Value = grid.FooterCaption;
}
else if (footerIndex == 0)
{
footerText.Text.Value = "{" + (grid.FooterCaption + vbo.vbTab).Qt() + "+" + summary + "}";
}
else if (!summaryEmpty)
{
footerText.Text.Value = "{" + summary + "}";
footerText.ExcelValue.Value = "{" + summary + "}";
}
else
{
footerText.Text.Value = grid.FooterText(footerIndex);
}
footerText.Name = "FooterText" + nameIndex.ToString();
if (border == 0)
{
footerText.Border.Side = StiBorderSides.Top | StiBorderSides.Bottom;
}
else
{
footerText.Border.Side = StiBorderSides.All;
}
if (!summaryEmpty && summary != "Count()")
{
footerText.TextFormat = (StiFormatService)dataText.TextFormat.Clone();
}
footerText.HorAlignment = horAlign;
//footerText.VertAlignment = StiVertAlignment.Center;
footerText.Font = new Font(grid.Font.FontFamily.Name, fontSize);
footerList.Add(footerText);
pos += columnWidth;
nameIndex++;
}
i++;
}
if (totals)
{
footerBand.Components.AddRange(footerList.ToArray());
}
if ((pos - page.Width) < 1.6f)
{
page.Margins.Right = 0;
page.Margins.Left /= 2;
}
else if (pos > page.Width)
{
page.Orientation = StiPageOrientation.Landscape;
titleText.Width = page.Width;
if (period)
{
titleBand.Components[titleBand.Components.IndexOf("periodText")].Width = page.Width;
}
if (pos > page.Width)
{
page.Margins.Right = 0;
page.Margins.Left /= 2;
}
if (pos > page.Width)
{
page.Width = pos;
}
}
if (param.Sign)
{
footerList.Clear();
//StiText footerText = new StiText(new RectangleD(0, 0.5f, page.Width, 0.5f));
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(0, 1f, page.Width / 2, 0.5f));
//footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("President") + ", " + vbo.Qt("") + ")}";
//footerText.HorAlignment = StiTextHorAlignment.Right;
//footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10);
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(page.Width / 2, 1f, page.Width / 4, 0.5f));
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(page.Width * 3 / 4, 1f, page.Width / 4, 0.5f));
//footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("PresidentName") + ", " + vbo.Qt("") + ")}";
//footerText.HorAlignment = StiTextHorAlignment.Left;
//footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10);
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(0, 1.5f, page.Width, 0.5f));
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(0, 2f, page.Width / 2, 0.5f));
//footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("ChifAccount") + ", " + vbo.Qt("") + ")}";
//footerText.HorAlignment = StiTextHorAlignment.Right;
//footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10);
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(page.Width / 2, 2f, page.Width / 4, 0.5f));
//footerList.Add(footerText);
//footerText = new StiText(new RectangleD(page.Width * 3 / 4, 2f, page.Width / 4, 0.5f));
//footerText.Text.Value = "{CSetup.Setup.Properties(" + vbo.Qt("ChifAccountName") + ", " + vbo.Qt("") + ")}";
//footerText.HorAlignment = StiTextHorAlignment.Left;
//footerText.Font = new Font(grid.ColumnHeadersDefaultCellStyle.Font.FontFamily.Name, 10);
//footerList.Add(footerText);
//footerBand.Height = 2.5f;
//footerBand.Components.AddRange(footerList.ToArray());
}
return(report);
}
