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 InitializeComponent() { SP_GetRequestHeader = new SP_GetRequestHeaderDataSource(); SP_GetRequestDetail = new SP_GetRequestDetailDataSource(); ParentSP_GetRequestHeader = new StiDataRelation("SP_GetRequestHeader_SP_GetRequestDetail", "SP_GetRequestHeader", "SP_GetRequestHeader", SP_GetRequestHeader, SP_GetRequestDetail, new[] { "RequestID" }, new[] { "RequestID" }); 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 = "RptRequestDetail"; ReportAuthor = "Programmer.GE"; // // ReportChanged // ReportChanged = new DateTime(2010, 4, 30, 19, 58, 27, 845); // // ReportCreated // ReportCreated = new DateTime(2010, 3, 4, 16, 2, 4, 0); ReportDescription = "პროდუქციის შეკვეთა"; ReportFile = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Product" + "ion\\RptRequestDetail.mrt"; ReportGuid = "39889ce012f240ecbc7962a86ff663a7"; ReportName = "RptRequestDetail"; ReportUnit = StiReportUnitType.Centimeters; ScriptLanguage = StiReportLanguageType.CSharp; // // Page1 // Page1 = new StiPage(); Page1.Guid = "5d26ae79894e4dcebbc2212ba7686670"; 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); // // DataSP_GetRequestHeader // DataSP_GetRequestHeader = new StiDataBand(); DataSP_GetRequestHeader.ClientRectangle = new RectangleD(0, 0.4, 19, 0.6); DataSP_GetRequestHeader.DataSourceName = "SP_GetRequestHeader"; DataSP_GetRequestHeader.Name = "DataSP_GetRequestHeader"; DataSP_GetRequestHeader.Sort = new String[0]; DataSP_GetRequestHeader.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataSP_GetRequestHeader.Brush = new StiSolidBrush(Color.Transparent); DataSP_GetRequestHeader.BusinessObjectGuid = null; // // Text2 // Text2 = new StiText(); Text2.ClientRectangle = new RectangleD(0, 0, 19, 0.6); Text2.HorAlignment = StiTextHorAlignment.Center; Text2.Name = "Text2"; Text2.GetValue += new StiGetValueEventHandler(Text2__GetValue); Text2.VertAlignment = StiVertAlignment.Center; Text2.Border = new StiBorder(StiBorderSides.None, 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.Guid = null; 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); DataSP_GetRequestHeader.Guid = null; DataSP_GetRequestHeader.Interaction = null; DataSP_GetRequestHeader.MasterComponent = null; // // HeaderSP_GetRequestDetail // HeaderSP_GetRequestDetail = new StiHeaderBand(); HeaderSP_GetRequestDetail.ClientRectangle = new RectangleD(0, 1.8, 19, 0.6); HeaderSP_GetRequestDetail.Name = "HeaderSP_GetRequestDetail"; HeaderSP_GetRequestDetail.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderSP_GetRequestDetail.Brush = new StiSolidBrush(Color.Transparent); // // HeaderSP_GetRequestDetail_OrdinalNumber // HeaderSP_GetRequestDetail_OrdinalNumber = new StiText(); HeaderSP_GetRequestDetail_OrdinalNumber.ClientRectangle = new RectangleD(0, 0, 0.8, 0.6); HeaderSP_GetRequestDetail_OrdinalNumber.HorAlignment = StiTextHorAlignment.Center; HeaderSP_GetRequestDetail_OrdinalNumber.Name = "HeaderSP_GetRequestDetail_OrdinalNumber"; HeaderSP_GetRequestDetail_OrdinalNumber.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_OrdinalNumber__GetValue); HeaderSP_GetRequestDetail_OrdinalNumber.VertAlignment = StiVertAlignment.Center; HeaderSP_GetRequestDetail_OrdinalNumber.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderSP_GetRequestDetail_OrdinalNumber.Brush = new StiSolidBrush(Color.Transparent); HeaderSP_GetRequestDetail_OrdinalNumber.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderSP_GetRequestDetail_OrdinalNumber.Guid = null; HeaderSP_GetRequestDetail_OrdinalNumber.Interaction = null; HeaderSP_GetRequestDetail_OrdinalNumber.Margins = new StiMargins(0, 0, 0, 0); HeaderSP_GetRequestDetail_OrdinalNumber.TextBrush = new StiSolidBrush(Color.Black); HeaderSP_GetRequestDetail_OrdinalNumber.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderSP_GetRequestDetail_MedicamentName // HeaderSP_GetRequestDetail_MedicamentName = new StiText(); HeaderSP_GetRequestDetail_MedicamentName.ClientRectangle = new RectangleD(0.8, 0, 6, 0.6); HeaderSP_GetRequestDetail_MedicamentName.HorAlignment = StiTextHorAlignment.Center; HeaderSP_GetRequestDetail_MedicamentName.Name = "HeaderSP_GetRequestDetail_MedicamentName"; HeaderSP_GetRequestDetail_MedicamentName.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_MedicamentName__GetValue); HeaderSP_GetRequestDetail_MedicamentName.VertAlignment = StiVertAlignment.Center; HeaderSP_GetRequestDetail_MedicamentName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderSP_GetRequestDetail_MedicamentName.Brush = new StiSolidBrush(Color.Transparent); HeaderSP_GetRequestDetail_MedicamentName.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderSP_GetRequestDetail_MedicamentName.Guid = null; HeaderSP_GetRequestDetail_MedicamentName.Interaction = null; HeaderSP_GetRequestDetail_MedicamentName.Margins = new StiMargins(0, 0, 0, 0); HeaderSP_GetRequestDetail_MedicamentName.TextBrush = new StiSolidBrush(Color.Black); HeaderSP_GetRequestDetail_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderSP_GetRequestDetail_RequestQty // HeaderSP_GetRequestDetail_RequestQty = new StiText(); HeaderSP_GetRequestDetail_RequestQty.ClientRectangle = new RectangleD(6.8, 0, 1.4, 0.6); HeaderSP_GetRequestDetail_RequestQty.HorAlignment = StiTextHorAlignment.Center; HeaderSP_GetRequestDetail_RequestQty.Name = "HeaderSP_GetRequestDetail_RequestQty"; HeaderSP_GetRequestDetail_RequestQty.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_RequestQty__GetValue); HeaderSP_GetRequestDetail_RequestQty.VertAlignment = StiVertAlignment.Center; HeaderSP_GetRequestDetail_RequestQty.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderSP_GetRequestDetail_RequestQty.Brush = new StiSolidBrush(Color.Transparent); HeaderSP_GetRequestDetail_RequestQty.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderSP_GetRequestDetail_RequestQty.Guid = null; HeaderSP_GetRequestDetail_RequestQty.Interaction = null; HeaderSP_GetRequestDetail_RequestQty.Margins = new StiMargins(0, 0, 0, 0); HeaderSP_GetRequestDetail_RequestQty.TextBrush = new StiSolidBrush(Color.Black); HeaderSP_GetRequestDetail_RequestQty.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderSP_GetRequestDetail_CountryName1 // HeaderSP_GetRequestDetail_CountryName1 = new StiText(); HeaderSP_GetRequestDetail_CountryName1.ClientRectangle = new RectangleD(8.2, 0, 2.8, 0.6); HeaderSP_GetRequestDetail_CountryName1.HorAlignment = StiTextHorAlignment.Center; HeaderSP_GetRequestDetail_CountryName1.Name = "HeaderSP_GetRequestDetail_CountryName1"; HeaderSP_GetRequestDetail_CountryName1.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_CountryName1__GetValue); HeaderSP_GetRequestDetail_CountryName1.VertAlignment = StiVertAlignment.Center; HeaderSP_GetRequestDetail_CountryName1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderSP_GetRequestDetail_CountryName1.Brush = new StiSolidBrush(Color.Transparent); HeaderSP_GetRequestDetail_CountryName1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderSP_GetRequestDetail_CountryName1.Guid = null; HeaderSP_GetRequestDetail_CountryName1.Interaction = null; HeaderSP_GetRequestDetail_CountryName1.Margins = new StiMargins(0, 0, 0, 0); HeaderSP_GetRequestDetail_CountryName1.TextBrush = new StiSolidBrush(Color.Black); HeaderSP_GetRequestDetail_CountryName1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderSP_GetRequestDetail_CountryName2 // HeaderSP_GetRequestDetail_CountryName2 = new StiText(); HeaderSP_GetRequestDetail_CountryName2.ClientRectangle = new RectangleD(11, 0, 2.8, 0.6); HeaderSP_GetRequestDetail_CountryName2.HorAlignment = StiTextHorAlignment.Center; HeaderSP_GetRequestDetail_CountryName2.Name = "HeaderSP_GetRequestDetail_CountryName2"; HeaderSP_GetRequestDetail_CountryName2.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_CountryName2__GetValue); HeaderSP_GetRequestDetail_CountryName2.VertAlignment = StiVertAlignment.Center; HeaderSP_GetRequestDetail_CountryName2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderSP_GetRequestDetail_CountryName2.Brush = new StiSolidBrush(Color.Transparent); HeaderSP_GetRequestDetail_CountryName2.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderSP_GetRequestDetail_CountryName2.Guid = null; HeaderSP_GetRequestDetail_CountryName2.Interaction = null; HeaderSP_GetRequestDetail_CountryName2.Margins = new StiMargins(0, 0, 0, 0); HeaderSP_GetRequestDetail_CountryName2.TextBrush = new StiSolidBrush(Color.Black); HeaderSP_GetRequestDetail_CountryName2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderSP_GetRequestDetail_BrandName1 // HeaderSP_GetRequestDetail_BrandName1 = new StiText(); HeaderSP_GetRequestDetail_BrandName1.ClientRectangle = new RectangleD(13.8, 0, 2.6, 0.6); HeaderSP_GetRequestDetail_BrandName1.HorAlignment = StiTextHorAlignment.Center; HeaderSP_GetRequestDetail_BrandName1.Name = "HeaderSP_GetRequestDetail_BrandName1"; HeaderSP_GetRequestDetail_BrandName1.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_BrandName1__GetValue); HeaderSP_GetRequestDetail_BrandName1.VertAlignment = StiVertAlignment.Center; HeaderSP_GetRequestDetail_BrandName1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderSP_GetRequestDetail_BrandName1.Brush = new StiSolidBrush(Color.Transparent); HeaderSP_GetRequestDetail_BrandName1.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderSP_GetRequestDetail_BrandName1.Guid = null; HeaderSP_GetRequestDetail_BrandName1.Interaction = null; HeaderSP_GetRequestDetail_BrandName1.Margins = new StiMargins(0, 0, 0, 0); HeaderSP_GetRequestDetail_BrandName1.TextBrush = new StiSolidBrush(Color.Black); HeaderSP_GetRequestDetail_BrandName1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderSP_GetRequestDetail_BrandName2 // HeaderSP_GetRequestDetail_BrandName2 = new StiText(); HeaderSP_GetRequestDetail_BrandName2.ClientRectangle = new RectangleD(16.4, 0, 2.6, 0.6); HeaderSP_GetRequestDetail_BrandName2.HorAlignment = StiTextHorAlignment.Center; HeaderSP_GetRequestDetail_BrandName2.Name = "HeaderSP_GetRequestDetail_BrandName2"; HeaderSP_GetRequestDetail_BrandName2.GetValue += new StiGetValueEventHandler(HeaderSP_GetRequestDetail_BrandName2__GetValue); HeaderSP_GetRequestDetail_BrandName2.VertAlignment = StiVertAlignment.Center; HeaderSP_GetRequestDetail_BrandName2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderSP_GetRequestDetail_BrandName2.Brush = new StiSolidBrush(Color.Transparent); HeaderSP_GetRequestDetail_BrandName2.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderSP_GetRequestDetail_BrandName2.Guid = null; HeaderSP_GetRequestDetail_BrandName2.Interaction = null; HeaderSP_GetRequestDetail_BrandName2.Margins = new StiMargins(0, 0, 0, 0); HeaderSP_GetRequestDetail_BrandName2.TextBrush = new StiSolidBrush(Color.Black); HeaderSP_GetRequestDetail_BrandName2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); HeaderSP_GetRequestDetail.Guid = null; HeaderSP_GetRequestDetail.Interaction = null; // // DataSP_GetRequestDetail // DataSP_GetRequestDetail = new StiDataBand(); DataSP_GetRequestDetail.ClientRectangle = new RectangleD(0, 3.2, 19, 0.6); DataSP_GetRequestDetail.DataRelationName = "SP_GetRequestHeader_SP_GetRequestDetail"; DataSP_GetRequestDetail.DataSourceName = "SP_GetRequestDetail"; DataSP_GetRequestDetail.Name = "DataSP_GetRequestDetail"; DataSP_GetRequestDetail.Sort = new[] { "ASC", "OrdinalNumber" }; DataSP_GetRequestDetail.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataSP_GetRequestDetail.Brush = new StiSolidBrush(Color.Transparent); DataSP_GetRequestDetail.BusinessObjectGuid = null; // // DataSP_GetRequestDetail_MedicamentName // DataSP_GetRequestDetail_MedicamentName = new StiText(); DataSP_GetRequestDetail_MedicamentName.CanGrow = true; DataSP_GetRequestDetail_MedicamentName.ClientRectangle = new RectangleD(0.8, 0, 6, 0.6); DataSP_GetRequestDetail_MedicamentName.GrowToHeight = true; DataSP_GetRequestDetail_MedicamentName.Name = "DataSP_GetRequestDetail_MedicamentName"; DataSP_GetRequestDetail_MedicamentName.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_MedicamentName__GetValue); DataSP_GetRequestDetail_MedicamentName.VertAlignment = StiVertAlignment.Center; DataSP_GetRequestDetail_MedicamentName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataSP_GetRequestDetail_MedicamentName.Brush = new StiSolidBrush(Color.Transparent); DataSP_GetRequestDetail_MedicamentName.Font = new Font("BPG Glaho Arial", 8F); DataSP_GetRequestDetail_MedicamentName.Guid = null; DataSP_GetRequestDetail_MedicamentName.Interaction = null; DataSP_GetRequestDetail_MedicamentName.Margins = new StiMargins(0, 0, 0, 0); DataSP_GetRequestDetail_MedicamentName.TextBrush = new StiSolidBrush(Color.Black); DataSP_GetRequestDetail_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataSP_GetRequestDetail_OrdinalNumber // DataSP_GetRequestDetail_OrdinalNumber = new StiText(); DataSP_GetRequestDetail_OrdinalNumber.CanGrow = true; DataSP_GetRequestDetail_OrdinalNumber.ClientRectangle = new RectangleD(0, 0, 0.8, 0.6); DataSP_GetRequestDetail_OrdinalNumber.GrowToHeight = true; DataSP_GetRequestDetail_OrdinalNumber.Name = "DataSP_GetRequestDetail_OrdinalNumber"; DataSP_GetRequestDetail_OrdinalNumber.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_OrdinalNumber__GetValue); DataSP_GetRequestDetail_OrdinalNumber.VertAlignment = StiVertAlignment.Center; DataSP_GetRequestDetail_OrdinalNumber.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataSP_GetRequestDetail_OrdinalNumber.Brush = new StiSolidBrush(Color.Transparent); DataSP_GetRequestDetail_OrdinalNumber.Font = new Font("BPG Glaho Arial", 8F); DataSP_GetRequestDetail_OrdinalNumber.Guid = null; DataSP_GetRequestDetail_OrdinalNumber.Interaction = null; DataSP_GetRequestDetail_OrdinalNumber.Margins = new StiMargins(0, 0, 0, 0); DataSP_GetRequestDetail_OrdinalNumber.TextBrush = new StiSolidBrush(Color.Black); DataSP_GetRequestDetail_OrdinalNumber.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataSP_GetRequestDetail_RequestQty // DataSP_GetRequestDetail_RequestQty = new StiText(); DataSP_GetRequestDetail_RequestQty.CanGrow = true; DataSP_GetRequestDetail_RequestQty.ClientRectangle = new RectangleD(6.8, 0, 1.4, 0.6); DataSP_GetRequestDetail_RequestQty.GrowToHeight = true; DataSP_GetRequestDetail_RequestQty.HorAlignment = StiTextHorAlignment.Right; DataSP_GetRequestDetail_RequestQty.Name = "DataSP_GetRequestDetail_RequestQty"; DataSP_GetRequestDetail_RequestQty.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_RequestQty__GetValue); DataSP_GetRequestDetail_RequestQty.VertAlignment = StiVertAlignment.Center; DataSP_GetRequestDetail_RequestQty.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataSP_GetRequestDetail_RequestQty.Brush = new StiSolidBrush(Color.Transparent); DataSP_GetRequestDetail_RequestQty.Font = new Font("BPG Glaho Arial", 8F); DataSP_GetRequestDetail_RequestQty.Guid = null; DataSP_GetRequestDetail_RequestQty.Interaction = null; DataSP_GetRequestDetail_RequestQty.Margins = new StiMargins(0, 0, 0, 0); DataSP_GetRequestDetail_RequestQty.TextBrush = new StiSolidBrush(Color.Black); DataSP_GetRequestDetail_RequestQty.TextFormat = new StiNumberFormatService(1, ",", 4, " ", 3, true, false, " "); DataSP_GetRequestDetail_RequestQty.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataSP_GetRequestDetail_CountryName1 // DataSP_GetRequestDetail_CountryName1 = new StiText(); DataSP_GetRequestDetail_CountryName1.CanGrow = true; DataSP_GetRequestDetail_CountryName1.ClientRectangle = new RectangleD(8.2, 0, 2.8, 0.6); DataSP_GetRequestDetail_CountryName1.GrowToHeight = true; DataSP_GetRequestDetail_CountryName1.Name = "DataSP_GetRequestDetail_CountryName1"; DataSP_GetRequestDetail_CountryName1.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_CountryName1__GetValue); DataSP_GetRequestDetail_CountryName1.VertAlignment = StiVertAlignment.Center; DataSP_GetRequestDetail_CountryName1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataSP_GetRequestDetail_CountryName1.Brush = new StiSolidBrush(Color.Transparent); DataSP_GetRequestDetail_CountryName1.Font = new Font("BPG Glaho Arial", 8F); DataSP_GetRequestDetail_CountryName1.Guid = null; DataSP_GetRequestDetail_CountryName1.Interaction = null; DataSP_GetRequestDetail_CountryName1.Margins = new StiMargins(0, 0, 0, 0); DataSP_GetRequestDetail_CountryName1.TextBrush = new StiSolidBrush(Color.Black); DataSP_GetRequestDetail_CountryName1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataSP_GetRequestDetail_CountryName2 // DataSP_GetRequestDetail_CountryName2 = new StiText(); DataSP_GetRequestDetail_CountryName2.CanGrow = true; DataSP_GetRequestDetail_CountryName2.ClientRectangle = new RectangleD(11, 0, 2.8, 0.6); DataSP_GetRequestDetail_CountryName2.GrowToHeight = true; DataSP_GetRequestDetail_CountryName2.Name = "DataSP_GetRequestDetail_CountryName2"; DataSP_GetRequestDetail_CountryName2.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_CountryName2__GetValue); DataSP_GetRequestDetail_CountryName2.VertAlignment = StiVertAlignment.Center; DataSP_GetRequestDetail_CountryName2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataSP_GetRequestDetail_CountryName2.Brush = new StiSolidBrush(Color.Transparent); DataSP_GetRequestDetail_CountryName2.Font = new Font("BPG Glaho Arial", 8F); DataSP_GetRequestDetail_CountryName2.Guid = null; DataSP_GetRequestDetail_CountryName2.Interaction = null; DataSP_GetRequestDetail_CountryName2.Margins = new StiMargins(0, 0, 0, 0); DataSP_GetRequestDetail_CountryName2.TextBrush = new StiSolidBrush(Color.Black); DataSP_GetRequestDetail_CountryName2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataSP_GetRequestDetail_BrandName1 // DataSP_GetRequestDetail_BrandName1 = new StiText(); DataSP_GetRequestDetail_BrandName1.CanGrow = true; DataSP_GetRequestDetail_BrandName1.ClientRectangle = new RectangleD(13.8, 0, 2.6, 0.6); DataSP_GetRequestDetail_BrandName1.Name = "DataSP_GetRequestDetail_BrandName1"; DataSP_GetRequestDetail_BrandName1.GetValue += new StiGetValueEventHandler(DataSP_GetRequestDetail_BrandName1__GetValue); DataSP_GetRequestDetail_BrandName1.VertAlignment = StiVertAlignment.Center; DataSP_GetRequestDetail_BrandName1.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataSP_GetRequestDetail_BrandName1.Brush = new StiSolidBrush(Color.Transparent); DataSP_GetRequestDetail_BrandName1.Font = new Font("BPG Glaho Arial", 8F); DataSP_GetRequestDetail_BrandName1.Guid = null; DataSP_GetRequestDetail_BrandName1.Interaction = null; DataSP_GetRequestDetail_BrandName1.Margins = new StiMargins(0, 0, 0, 0); DataSP_GetRequestDetail_BrandName1.TextBrush = new StiSolidBrush(Color.Black); DataSP_GetRequestDetail_BrandName1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataSP_GetRequestDetail_BrandName2 // DataSP_GetRequestDetail_BrandName2 = new StiText(); DataSP_GetRequestDetail_BrandName2.CanGrow = true; DataSP_GetRequestDetail_BrandName2.ClientRectangle = new RectangleD(16.4, 0, 2.6, 0.6); DataSP_GetRequestDetail_BrandName2.GrowToHeight = true; DataSP_GetRequestDetail_BrandName2.Name = "DataSP_GetRequestDetail_BrandName2"; DataSP_GetRequestDetail_BrandName2.VertAlignment = StiVertAlignment.Center; DataSP_GetRequestDetail_BrandName2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataSP_GetRequestDetail_BrandName2.Brush = new StiSolidBrush(Color.Transparent); DataSP_GetRequestDetail_BrandName2.Font = new Font("BPG Glaho Arial", 8F); DataSP_GetRequestDetail_BrandName2.Guid = null; DataSP_GetRequestDetail_BrandName2.Interaction = null; DataSP_GetRequestDetail_BrandName2.Margins = new StiMargins(0, 0, 0, 0); DataSP_GetRequestDetail_BrandName2.TextBrush = new StiSolidBrush(Color.Black); DataSP_GetRequestDetail_BrandName2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); DataSP_GetRequestDetail.Guid = null; DataSP_GetRequestDetail.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)); RptRequestDetail_PrinterSettings = new StiPrinterSettings(); PrinterSettings = RptRequestDetail_PrinterSettings; Page1.Report = this; Page1.Watermark = Page1_Watermark; DataSP_GetRequestHeader.Page = Page1; DataSP_GetRequestHeader.Parent = Page1; Text2.Page = Page1; Text2.Parent = DataSP_GetRequestHeader; HeaderSP_GetRequestDetail.Page = Page1; HeaderSP_GetRequestDetail.Parent = Page1; HeaderSP_GetRequestDetail_OrdinalNumber.Page = Page1; HeaderSP_GetRequestDetail_OrdinalNumber.Parent = HeaderSP_GetRequestDetail; HeaderSP_GetRequestDetail_MedicamentName.Page = Page1; HeaderSP_GetRequestDetail_MedicamentName.Parent = HeaderSP_GetRequestDetail; HeaderSP_GetRequestDetail_RequestQty.Page = Page1; HeaderSP_GetRequestDetail_RequestQty.Parent = HeaderSP_GetRequestDetail; HeaderSP_GetRequestDetail_CountryName1.Page = Page1; HeaderSP_GetRequestDetail_CountryName1.Parent = HeaderSP_GetRequestDetail; HeaderSP_GetRequestDetail_CountryName2.Page = Page1; HeaderSP_GetRequestDetail_CountryName2.Parent = HeaderSP_GetRequestDetail; HeaderSP_GetRequestDetail_BrandName1.Page = Page1; HeaderSP_GetRequestDetail_BrandName1.Parent = HeaderSP_GetRequestDetail; HeaderSP_GetRequestDetail_BrandName2.Page = Page1; HeaderSP_GetRequestDetail_BrandName2.Parent = HeaderSP_GetRequestDetail; DataSP_GetRequestDetail.MasterComponent = DataSP_GetRequestHeader; DataSP_GetRequestDetail.Page = Page1; DataSP_GetRequestDetail.Parent = Page1; DataSP_GetRequestDetail_MedicamentName.Page = Page1; DataSP_GetRequestDetail_MedicamentName.Parent = DataSP_GetRequestDetail; DataSP_GetRequestDetail_OrdinalNumber.Page = Page1; DataSP_GetRequestDetail_OrdinalNumber.Parent = DataSP_GetRequestDetail; DataSP_GetRequestDetail_RequestQty.Page = Page1; DataSP_GetRequestDetail_RequestQty.Parent = DataSP_GetRequestDetail; DataSP_GetRequestDetail_CountryName1.Page = Page1; DataSP_GetRequestDetail_CountryName1.Parent = DataSP_GetRequestDetail; DataSP_GetRequestDetail_CountryName2.Page = Page1; DataSP_GetRequestDetail_CountryName2.Parent = DataSP_GetRequestDetail; DataSP_GetRequestDetail_BrandName1.Page = Page1; DataSP_GetRequestDetail_BrandName1.Parent = DataSP_GetRequestDetail; DataSP_GetRequestDetail_BrandName2.Page = Page1; DataSP_GetRequestDetail_BrandName2.Parent = DataSP_GetRequestDetail; // // Add to DataSP_GetRequestHeader.Components // DataSP_GetRequestHeader.Components.Clear(); DataSP_GetRequestHeader.Components.AddRange(new StiComponent[] { Text2 }); // // Add to HeaderSP_GetRequestDetail.Components // HeaderSP_GetRequestDetail.Components.Clear(); HeaderSP_GetRequestDetail.Components.AddRange(new StiComponent[] { HeaderSP_GetRequestDetail_OrdinalNumber, HeaderSP_GetRequestDetail_MedicamentName, HeaderSP_GetRequestDetail_RequestQty, HeaderSP_GetRequestDetail_CountryName1, HeaderSP_GetRequestDetail_CountryName2, HeaderSP_GetRequestDetail_BrandName1, HeaderSP_GetRequestDetail_BrandName2 }); // // Add to DataSP_GetRequestDetail.Components // DataSP_GetRequestDetail.Components.Clear(); DataSP_GetRequestDetail.Components.AddRange(new StiComponent[] { DataSP_GetRequestDetail_MedicamentName, DataSP_GetRequestDetail_OrdinalNumber, DataSP_GetRequestDetail_RequestQty, DataSP_GetRequestDetail_CountryName1, DataSP_GetRequestDetail_CountryName2, DataSP_GetRequestDetail_BrandName1, DataSP_GetRequestDetail_BrandName2 }); // // Add to Page1.Components // Page1.Components.Clear(); Page1.Components.AddRange(new StiComponent[] { DataSP_GetRequestHeader, HeaderSP_GetRequestDetail, DataSP_GetRequestDetail }); // // Add to Pages // Pages.Clear(); Pages.AddRange(new[] { Page1 }); Dictionary.Relations.Add(ParentSP_GetRequestHeader); SP_GetRequestDetail.Columns.AddRange(new[] { new StiDataColumn("RequestID", "RequestID", "RequestID", typeof(int)), new StiDataColumn("RequestDetailID", "RequestDetailID", "RequestDetailID", typeof(int)), new StiDataColumn("MedicamentID", "MedicamentID", "MedicamentID", typeof(int)), new StiDataColumn("MedicamentName", "MedicamentName", "MedicamentName", typeof(string)), new StiDataColumn("RequestQty", "RequestQty", "RequestQty", typeof(decimal)), new StiDataColumn("CountryCode1", "CountryCode1", "CountryCode1", typeof(string)), new StiDataColumn("CountryName1", "CountryName1", "CountryName1", typeof(string)), new StiDataColumn("CountryCode2", "CountryCode2", "CountryCode2", typeof(string)), new StiDataColumn("CountryName2", "CountryName2", "CountryName2", typeof(string)), new StiDataColumn("BrandID", "BrandID", "BrandID", typeof(int)), new StiDataColumn("BrandName", "BrandName", "BrandName", typeof(string)), new StiDataColumn("OrdinalNumber", "OrdinalNumber", "OrdinalNumber", typeof(short)), new StiDataColumn("Action", "Action", "Action", typeof(int)) }); DataSources.Add(SP_GetRequestDetail); SP_GetRequestHeader.Columns.AddRange(new[] { new StiDataColumn("RequestID", "RequestID", "RequestID", typeof(int)), new StiDataColumn("BranchID", "BranchID", "BranchID", typeof(int)), new StiDataColumn("BranchName", "BranchName", "BranchName", typeof(string)), new StiDataColumn("RequestDate", "RequestDate", "RequestDate", typeof(DateTime)), new StiDataColumn("Status", "Status", "Status", typeof(byte)), new StiDataColumn("ModifierID", "ModifierID", "ModifierID", typeof(int)), new StiDataColumn("Modifier", "Modifier", "Modifier", typeof(string)), new StiDataColumn("ModifiedDate", "ModifiedDate", "ModifiedDate", typeof(DateTime)), new StiDataColumn("ApproverID", "ApproverID", "ApproverID", typeof(int)), new StiDataColumn("Approver", "Approver", "Approver", typeof(string)) }); DataSources.Add(SP_GetRequestHeader); }
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 InitializeComponent() { T_Detail = new T_DetailDataSource(); Dictionary.Variables.Add(new StiVariable("", "MyCompanyName", "MyCompanyName", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyTaxCode", "MyCompanyTaxCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyDirectorName", "MyCompanyDirectorName", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryCode", "MyCompanyCountryCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryName", "MyCompanyCountryName", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyCity", "MyCompanyCity", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyPostalCode", "MyCompanyPostalCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyAddress", "MyCompanyAddress", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyPhone", "MyCompanyPhone", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyFax", "MyCompanyFax", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankName", "MyCompanyBankName", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankCode", "MyCompanyBankCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankAccountNumber", "MyCompanyBankAccountNumber", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyVATPayerFlag", "MyCompanyVATPayerFlag", "", typeof(bool), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyCode", "MyCompanyConditionalUnitCurrencyCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyDefaultTradingCurrencyCode", "MyCompanyDefaultTradingCurrencyCode", "", typeof(string), "", false, false, false)); Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyRate", "MyCompanyConditionalUnitCurrencyRate", "", typeof(decimal), "", false, false, false)); NeedsCompiling = false; // Variables init // Variables init MyCompanyName = ""; MyCompanyTaxCode = ""; MyCompanyDirectorName = ""; MyCompanyCountryCode = ""; MyCompanyCountryName = ""; MyCompanyCity = ""; MyCompanyPostalCode = ""; MyCompanyAddress = ""; MyCompanyPhone = ""; MyCompanyFax = ""; MyCompanyBankName = ""; MyCompanyBankCode = ""; MyCompanyBankAccountNumber = ""; MyCompanyVATPayerFlag = false; MyCompanyConditionalUnitCurrencyCode = ""; MyCompanyDefaultTradingCurrencyCode = ""; MyCompanyConditionalUnitCurrencyRate = 0m; 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 Produc Location Price"; ReportAuthor = "Programmer.GE"; // // ReportChanged // ReportChanged = new DateTime(2011, 6, 12, 21, 55, 48, 0); // // ReportCreated // ReportCreated = new DateTime(2009, 6, 28, 22, 3, 23, 0); ReportDescription = "პრაისი"; ReportFile = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Product" + "ion\\RptProducLocationPrice.mrt"; ReportGuid = "e242476ffaeb44b39344532841ed84f0"; ReportName = "RptProducLocationPrice"; ReportUnit = StiReportUnitType.Centimeters; ReportVersion = "2010.3.900"; ScriptLanguage = StiReportLanguageType.CSharp; // // Page1 // Page1 = new StiPage(); Page1.Columns = 2; Page1.Guid = "0edad2017ef5402da56612e0faa7a32a"; 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); // // PageHeaderBand1 // PageHeaderBand1 = new StiPageHeaderBand(); PageHeaderBand1.ClientRectangle = new RectangleD(0, 0.4, 20, 2.2); PageHeaderBand1.Name = "PageHeaderBand1"; PageHeaderBand1.PrintOn = StiPrintOnType.OnlyFirstPage; PageHeaderBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); PageHeaderBand1.Brush = new StiSolidBrush(Color.Transparent); // // Text4 // Text4 = new StiText(); Text4.ClientRectangle = new RectangleD(2.4, 0, 7.6, 2); Text4.Name = "Text4"; Text4.GetValue += new StiGetValueEventHandler(Text4__GetValue); Text4.VertAlignment = StiVertAlignment.Center; Text4.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Text4.Brush = new StiSolidBrush(Color.Transparent); Text4.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); 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); // // Image1 // Image1 = new StiImage(); Image1.AspectRatio = true; Image1.ClientRectangle = new RectangleD(0, 0, 2, 2); Image1.Guid = "b4725dd4d92a41f5a0f373916b5b430e"; Image1.HorAlignment = StiHorAlignment.Center; Image1.Name = "Image1"; Image1.Stretch = true; Image1.VertAlignment = StiVertAlignment.Center; Image1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Image1.Brush = new StiSolidBrush(Color.Transparent); Image1.Image = null; Image1.Interaction = null; PageHeaderBand1.Guid = null; PageHeaderBand1.Interaction = null; // // PageFooterBand1 // PageFooterBand1 = new StiPageFooterBand(); PageFooterBand1.ClientRectangle = new RectangleD(0, 28.1, 20, 0.6); PageFooterBand1.Name = "PageFooterBand1"; PageFooterBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); PageFooterBand1.Brush = new StiSolidBrush(Color.Transparent); // // Text3 // Text3 = new StiText(); Text3.ClientRectangle = new RectangleD(0, 0, 19, 0.6); Text3.HorAlignment = StiTextHorAlignment.Center; Text3.Name = "Text3"; Text3.GetValue += new StiGetValueEventHandler(Text3__GetValue); Text3.VertAlignment = StiVertAlignment.Center; Text3.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Text3.Brush = new StiSolidBrush(Color.Transparent); Text3.Font = new Font("Arial", 8F); Text3.Guid = null; Text3.Interaction = null; Text3.Margins = new StiMargins(0, 0, 0, 0); Text3.TextBrush = new StiSolidBrush(Color.Black); Text3.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); PageFooterBand1.Guid = null; PageFooterBand1.Interaction = null; // // HeaderVW_ProductLocation // HeaderVW_ProductLocation = new StiHeaderBand(); HeaderVW_ProductLocation.ClientRectangle = new RectangleD(0, 3.4, 10, 0.6); HeaderVW_ProductLocation.Name = "HeaderVW_ProductLocation"; HeaderVW_ProductLocation.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_ProductLocation.Brush = new StiSolidBrush(Color.Transparent); // // HeaderVW_ProductLocation_MedicamentName // HeaderVW_ProductLocation_MedicamentName = new StiText(); HeaderVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6); HeaderVW_ProductLocation_MedicamentName.HorAlignment = StiTextHorAlignment.Center; HeaderVW_ProductLocation_MedicamentName.Name = "HeaderVW_ProductLocation_MedicamentName"; HeaderVW_ProductLocation_MedicamentName.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_MedicamentName__GetValue); HeaderVW_ProductLocation_MedicamentName.VertAlignment = StiVertAlignment.Center; HeaderVW_ProductLocation_MedicamentName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_ProductLocation_MedicamentName.Brush = new StiSolidBrush(Color.Gainsboro); HeaderVW_ProductLocation_MedicamentName.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); HeaderVW_ProductLocation_MedicamentName.Guid = null; HeaderVW_ProductLocation_MedicamentName.Interaction = null; HeaderVW_ProductLocation_MedicamentName.Margins = new StiMargins(0, 0, 0, 0); HeaderVW_ProductLocation_MedicamentName.TextBrush = new StiSolidBrush(Color.Black); HeaderVW_ProductLocation_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderVW_ProductLocation_CountryName // HeaderVW_ProductLocation_CountryName = new StiText(); HeaderVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6); HeaderVW_ProductLocation_CountryName.HorAlignment = StiTextHorAlignment.Center; HeaderVW_ProductLocation_CountryName.Name = "HeaderVW_ProductLocation_CountryName"; HeaderVW_ProductLocation_CountryName.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_CountryName__GetValue); HeaderVW_ProductLocation_CountryName.VertAlignment = StiVertAlignment.Center; HeaderVW_ProductLocation_CountryName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_ProductLocation_CountryName.Brush = new StiSolidBrush(Color.Gainsboro); HeaderVW_ProductLocation_CountryName.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); HeaderVW_ProductLocation_CountryName.Guid = null; HeaderVW_ProductLocation_CountryName.Interaction = null; HeaderVW_ProductLocation_CountryName.Margins = new StiMargins(0, 0, 0, 0); HeaderVW_ProductLocation_CountryName.TextBrush = new StiSolidBrush(Color.Black); HeaderVW_ProductLocation_CountryName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // HeaderVW_ProductLocation_ListPrice // HeaderVW_ProductLocation_ListPrice = new StiText(); HeaderVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6); HeaderVW_ProductLocation_ListPrice.HorAlignment = StiTextHorAlignment.Center; HeaderVW_ProductLocation_ListPrice.Name = "HeaderVW_ProductLocation_ListPrice"; HeaderVW_ProductLocation_ListPrice.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_ListPrice__GetValue); HeaderVW_ProductLocation_ListPrice.VertAlignment = StiVertAlignment.Center; HeaderVW_ProductLocation_ListPrice.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_ProductLocation_ListPrice.Brush = new StiSolidBrush(Color.Gainsboro); HeaderVW_ProductLocation_ListPrice.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); HeaderVW_ProductLocation_ListPrice.Guid = null; HeaderVW_ProductLocation_ListPrice.Interaction = null; HeaderVW_ProductLocation_ListPrice.Margins = new StiMargins(0, 0, 0, 0); HeaderVW_ProductLocation_ListPrice.TextBrush = new StiSolidBrush(Color.Black); HeaderVW_ProductLocation_ListPrice.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // Text2 // Text2 = new StiText(); Text2.ClientRectangle = new RectangleD(7.4, 0, 1.6, 0.6); Text2.Guid = "b2ee6a7204874db4bc1e2bae90edc3a9"; Text2.HorAlignment = StiTextHorAlignment.Center; Text2.Name = "Text2"; Text2.GetValue += new StiGetValueEventHandler(Text2__GetValue); Text2.Type = StiSystemTextType.Expression; 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.Gainsboro); Text2.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold); Text2.Interaction = null; Text2.Margins = new StiMargins(0, 0, 0, 0); Text2.TextBrush = new StiSolidBrush(Color.Black); Text2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); HeaderVW_ProductLocation.Guid = null; HeaderVW_ProductLocation.Interaction = null; // // DataVW_ProductLocation // DataVW_ProductLocation = new StiDataBand(); DataVW_ProductLocation.ClientRectangle = new RectangleD(0, 4.8, 10, 0.6); DataVW_ProductLocation.DataSourceName = "T_Detail"; DataVW_ProductLocation.Name = "DataVW_ProductLocation"; DataVW_ProductLocation.Sort = new[] { "ASC", "ProductName" }; DataVW_ProductLocation.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_ProductLocation.Brush = new StiSolidBrush(Color.Transparent); DataVW_ProductLocation.BusinessObjectGuid = null; // // DataVW_ProductLocation_MedicamentName // DataVW_ProductLocation_MedicamentName = new StiText(); DataVW_ProductLocation_MedicamentName.CanGrow = true; DataVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6); DataVW_ProductLocation_MedicamentName.Name = "DataVW_ProductLocation_MedicamentName"; DataVW_ProductLocation_MedicamentName.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_MedicamentName__GetValue); DataVW_ProductLocation_MedicamentName.VertAlignment = StiVertAlignment.Center; DataVW_ProductLocation_MedicamentName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_ProductLocation_MedicamentName.Brush = new StiSolidBrush(Color.Transparent); DataVW_ProductLocation_MedicamentName.Font = new Font("BPG Glaho Arial", 6F); DataVW_ProductLocation_MedicamentName.Guid = null; DataVW_ProductLocation_MedicamentName.Interaction = null; DataVW_ProductLocation_MedicamentName.Margins = new StiMargins(0, 0, 0, 0); DataVW_ProductLocation_MedicamentName.TextBrush = new StiSolidBrush(Color.Black); DataVW_ProductLocation_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataVW_ProductLocation_CountryName // DataVW_ProductLocation_CountryName = new StiText(); DataVW_ProductLocation_CountryName.CanGrow = true; DataVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6); DataVW_ProductLocation_CountryName.HorAlignment = StiTextHorAlignment.Right; DataVW_ProductLocation_CountryName.Name = "DataVW_ProductLocation_CountryName"; DataVW_ProductLocation_CountryName.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_CountryName__GetValue); DataVW_ProductLocation_CountryName.VertAlignment = StiVertAlignment.Center; DataVW_ProductLocation_CountryName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_ProductLocation_CountryName.Brush = new StiSolidBrush(Color.Transparent); DataVW_ProductLocation_CountryName.Font = new Font("BPG Glaho Arial", 6F); DataVW_ProductLocation_CountryName.Guid = null; DataVW_ProductLocation_CountryName.Interaction = null; DataVW_ProductLocation_CountryName.Margins = new StiMargins(0, 0, 0, 0); DataVW_ProductLocation_CountryName.TextBrush = new StiSolidBrush(Color.Black); DataVW_ProductLocation_CountryName.TextFormat = new StiPercentageFormatService(0, 0, ",", 4, " ", 3, "%", true, false, " "); DataVW_ProductLocation_CountryName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // DataVW_ProductLocation_ListPrice // DataVW_ProductLocation_ListPrice = new StiText(); DataVW_ProductLocation_ListPrice.CanGrow = true; DataVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6); DataVW_ProductLocation_ListPrice.HorAlignment = StiTextHorAlignment.Right; DataVW_ProductLocation_ListPrice.Name = "DataVW_ProductLocation_ListPrice"; DataVW_ProductLocation_ListPrice.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_ListPrice__GetValue); DataVW_ProductLocation_ListPrice.VertAlignment = StiVertAlignment.Center; DataVW_ProductLocation_ListPrice.Border = new StiBorder(StiBorderSides.Right, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_ProductLocation_ListPrice.Brush = new StiSolidBrush(Color.Transparent); DataVW_ProductLocation_ListPrice.Font = new Font("BPG Glaho Arial", 6F); DataVW_ProductLocation_ListPrice.Guid = null; DataVW_ProductLocation_ListPrice.Interaction = null; DataVW_ProductLocation_ListPrice.Margins = new StiMargins(0, 0, 0, 0); DataVW_ProductLocation_ListPrice.TextBrush = new StiSolidBrush(Color.Black); DataVW_ProductLocation_ListPrice.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, false, " "); DataVW_ProductLocation_ListPrice.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // Text1 // Text1 = new StiText(); Text1.CanGrow = true; Text1.ClientRectangle = new RectangleD(7.4, 0, 1.6, 0.6); Text1.Guid = "5cfcbb441d534f4ba95c949ddd2c6da5"; Text1.HorAlignment = StiTextHorAlignment.Right; Text1.Name = "Text1"; Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue); Text1.Type = StiSystemTextType.DataColumn; Text1.VertAlignment = StiVertAlignment.Center; 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", 6F); Text1.Interaction = null; Text1.Margins = new StiMargins(0, 0, 0, 0); Text1.TextBrush = new StiSolidBrush(Color.Black); Text1.TextFormat = new StiPercentageFormatService(0, 0, ",", 2, " ", 3, "%", true, true, " "); Text1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); DataVW_ProductLocation.DataRelationName = null; DataVW_ProductLocation.Guid = null; DataVW_ProductLocation.Interaction = null; DataVW_ProductLocation.MasterComponent = null; Page1.ExcelSheetValue = null; Page1.Interaction = null; Page1.Margins = new StiMargins(0.5, 0.5, 0.5, 0.5); 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)); Page1.Rendering += new EventHandler(Page1_Rendering); RptProducLocationPrice_PrinterSettings = new StiPrinterSettings(); PrinterSettings = RptProducLocationPrice_PrinterSettings; Page1.Report = this; Page1.Watermark = Page1_Watermark; PageHeaderBand1.Page = Page1; PageHeaderBand1.Parent = Page1; Text4.Page = Page1; Text4.Parent = PageHeaderBand1; Image1.Page = Page1; Image1.Parent = PageHeaderBand1; PageFooterBand1.Page = Page1; PageFooterBand1.Parent = Page1; Text3.Page = Page1; Text3.Parent = PageFooterBand1; HeaderVW_ProductLocation.Page = Page1; HeaderVW_ProductLocation.Parent = Page1; HeaderVW_ProductLocation_MedicamentName.Page = Page1; HeaderVW_ProductLocation_MedicamentName.Parent = HeaderVW_ProductLocation; HeaderVW_ProductLocation_CountryName.Page = Page1; HeaderVW_ProductLocation_CountryName.Parent = HeaderVW_ProductLocation; HeaderVW_ProductLocation_ListPrice.Page = Page1; HeaderVW_ProductLocation_ListPrice.Parent = HeaderVW_ProductLocation; Text2.Page = Page1; Text2.Parent = HeaderVW_ProductLocation; DataVW_ProductLocation.Page = Page1; DataVW_ProductLocation.Parent = Page1; DataVW_ProductLocation_MedicamentName.Page = Page1; DataVW_ProductLocation_MedicamentName.Parent = DataVW_ProductLocation; DataVW_ProductLocation_CountryName.Page = Page1; DataVW_ProductLocation_CountryName.Parent = DataVW_ProductLocation; DataVW_ProductLocation_ListPrice.Page = Page1; DataVW_ProductLocation_ListPrice.Parent = DataVW_ProductLocation; Text1.Page = Page1; Text1.Parent = DataVW_ProductLocation; EndRender += new EventHandler(RptProducLocationPriceWordsToEnd__EndRender); // // Add to PageHeaderBand1.Components // PageHeaderBand1.Components.Clear(); PageHeaderBand1.Components.AddRange(new StiComponent[] { Text4, Image1 }); // // Add to PageFooterBand1.Components // PageFooterBand1.Components.Clear(); PageFooterBand1.Components.AddRange(new StiComponent[] { Text3 }); // // Add to HeaderVW_ProductLocation.Components // HeaderVW_ProductLocation.Components.Clear(); HeaderVW_ProductLocation.Components.AddRange(new StiComponent[] { HeaderVW_ProductLocation_MedicamentName, HeaderVW_ProductLocation_CountryName, HeaderVW_ProductLocation_ListPrice, Text2 }); // // Add to DataVW_ProductLocation.Components // DataVW_ProductLocation.Components.Clear(); DataVW_ProductLocation.Components.AddRange(new StiComponent[] { DataVW_ProductLocation_MedicamentName, DataVW_ProductLocation_CountryName, DataVW_ProductLocation_ListPrice, Text1 }); // // Add to Page1.Components // Page1.Components.Clear(); Page1.Components.AddRange(new StiComponent[] { PageHeaderBand1, PageFooterBand1, HeaderVW_ProductLocation, DataVW_ProductLocation }); // // Add to Pages // Pages.Clear(); Pages.AddRange(new[] { Page1 }); T_Detail.Columns.AddRange(new[] { new StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)), new StiDataColumn("ProductName", "ProductName", "ProductName", typeof(string)), new StiDataColumn("CountryName", "CountryName", "CountryName", typeof(string)), new StiDataColumn("Serie", "Serie", "Serie", typeof(string)), new StiDataColumn("UnitPrice", "UnitPrice", "UnitPrice", typeof(decimal)), new StiDataColumn("Discount", "Discount", "Discount", typeof(decimal)) }); DataSources.Add(T_Detail); }
private void InitializeComponent() { VW_Product = new VW_ProductDataSource(); 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 Product Bar Code"; // // ReportChanged // ReportChanged = new DateTime(2009, 6, 8, 10, 23, 13, 687); // // ReportCreated // ReportCreated = new DateTime(2009, 3, 24, 21, 40, 37, 0); ReportGuid = "17d6a2b4761540d58d5510314b329565"; ReportName = "RptProductBarCode"; ReportUnit = StiReportUnitType.Centimeters; ScriptLanguage = StiReportLanguageType.CSharp; // // Page1 // Page1 = new StiPage(); Page1.Columns = 2; Page1.Guid = "53d0355db4644f9d9ba6c964bafb28f0"; Page1.Name = "Page1"; Page1.Orientation = StiPageOrientation.Landscape; Page1.PageHeight = 21; Page1.PageWidth = 29.7; Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); Page1.Brush = new StiSolidBrush(Color.Transparent); // // HeaderVW_Product // HeaderVW_Product = new StiHeaderBand(); HeaderVW_Product.ClientRectangle = new RectangleD(0, 0.4, 13.85, 0.8); HeaderVW_Product.Name = "HeaderVW_Product"; HeaderVW_Product.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_Product.Brush = new StiSolidBrush(Color.Transparent); // // HeaderVW_Product_MedicamentName // HeaderVW_Product_MedicamentName = new StiText(); HeaderVW_Product_MedicamentName.ClientRectangle = new RectangleD(0, 0, 6.8, 0.8); HeaderVW_Product_MedicamentName.Name = "HeaderVW_Product_MedicamentName"; HeaderVW_Product_MedicamentName.GetValue += new StiGetValueEventHandler(HeaderVW_Product_MedicamentName__GetValue); HeaderVW_Product_MedicamentName.Type = StiSystemTextType.Expression; HeaderVW_Product_MedicamentName.VertAlignment = StiVertAlignment.Center; HeaderVW_Product_MedicamentName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); HeaderVW_Product_MedicamentName.Brush = new StiSolidBrush(Color.Transparent); HeaderVW_Product_MedicamentName.Font = new Font("BPG Glaho Arial", 10F, FontStyle.Bold); HeaderVW_Product_MedicamentName.Guid = null; HeaderVW_Product_MedicamentName.Interaction = null; HeaderVW_Product_MedicamentName.Margins = new StiMargins(0, 0, 0, 0); HeaderVW_Product_MedicamentName.TextBrush = new StiSolidBrush(Color.Black); HeaderVW_Product_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None); // // Text1 // Text1 = new StiText(); Text1.ClientRectangle = new RectangleD(6.8, 0, 7, 0.8); Text1.Name = "Text1"; Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue); Text1.Type = StiSystemTextType.Expression; Text1.VertAlignment = StiVertAlignment.Center; 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.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); HeaderVW_Product.Guid = null; HeaderVW_Product.Interaction = null; // // DataVW_Product // DataVW_Product = new StiDataBand(); DataVW_Product.ClientRectangle = new RectangleD(0, 2, 13.85, 2); DataVW_Product.DataSourceName = "VW_Product"; DataVW_Product.Name = "DataVW_Product"; DataVW_Product.Sort = new String[0]; DataVW_Product.Border = new StiBorder(StiBorderSides.All, Color.Black, 0.5, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_Product.Brush = new StiSolidBrush(Color.Transparent); // // DataVW_Product_ProductID // DataVW_Product_ProductID = new StiText(); DataVW_Product_ProductID.CanGrow = true; DataVW_Product_ProductID.ClientRectangle = new RectangleD(0, 0, 6.6, 2); DataVW_Product_ProductID.GrowToHeight = true; DataVW_Product_ProductID.Name = "DataVW_Product_ProductID"; DataVW_Product_ProductID.GetValue += new StiGetValueEventHandler(DataVW_Product_ProductID__GetValue); DataVW_Product_ProductID.Type = StiSystemTextType.Expression; DataVW_Product_ProductID.VertAlignment = StiVertAlignment.Center; DataVW_Product_ProductID.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); DataVW_Product_ProductID.Brush = new StiSolidBrush(Color.Transparent); DataVW_Product_ProductID.Font = new Font("BPG Glaho Arial", 8F); DataVW_Product_ProductID.Guid = null; DataVW_Product_ProductID.Interaction = null; DataVW_Product_ProductID.Margins = new StiMargins(0, 0, 0, 0); DataVW_Product_ProductID.TextBrush = new StiSolidBrush(Color.Black); DataVW_Product_ProductID.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None); // // BarCode1 // BarCode1 = new StiBarCode(); BarCode1.BackColor = Color.White; BarCode1.ClientRectangle = new RectangleD(6.8, 0, 7, 2); BarCode1.GetBarCode += new StiValueEventHandler(BarCode1__GetBarCode); BarCode1.ForeColor = Color.Black; BarCode1.Name = "BarCode1"; BarCode1.VertAlignment = StiVertAlignment.Center; BarCode1.BarCodeType = new StiEAN128aBarCodeType(13F, 1F); BarCode1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Dot, false, 4, new StiSolidBrush(Color.Black)); BarCode1.Font = new Font("Arial", 8F, FontStyle.Bold, GraphicsUnit.Pixel); BarCode1.Guid = null; BarCode1.Interaction = null; DataVW_Product.Guid = null; DataVW_Product.Interaction = null; DataVW_Product.MasterComponent = null; // // FooterVW_Product // FooterVW_Product = new StiFooterBand(); FooterVW_Product.ClientRectangle = new RectangleD(0, 4.8, 13.85, 0.8); FooterVW_Product.Name = "FooterVW_Product"; FooterVW_Product.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black)); FooterVW_Product.Brush = new StiSolidBrush(Color.Transparent); FooterVW_Product.Guid = null; FooterVW_Product.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)); RptProductBarCode_PrinterSettings = new StiPrinterSettings(); PrinterSettings = RptProductBarCode_PrinterSettings; Page1.Page = Page1; Page1.Report = this; Page1.Watermark = Page1_Watermark; HeaderVW_Product.Page = Page1; HeaderVW_Product.Parent = Page1; HeaderVW_Product_MedicamentName.Page = Page1; HeaderVW_Product_MedicamentName.Parent = HeaderVW_Product; Text1.Page = Page1; Text1.Parent = HeaderVW_Product; DataVW_Product.Page = Page1; DataVW_Product.Parent = Page1; DataVW_Product_ProductID.Page = Page1; DataVW_Product_ProductID.Parent = DataVW_Product; BarCode1.Page = Page1; BarCode1.Parent = DataVW_Product; FooterVW_Product.Page = Page1; FooterVW_Product.Parent = Page1; // // Add to HeaderVW_Product.Components // HeaderVW_Product.Components.Clear(); HeaderVW_Product.Components.AddRange(new StiComponent[] { HeaderVW_Product_MedicamentName, Text1 }); // // Add to DataVW_Product.Components // DataVW_Product.Components.Clear(); DataVW_Product.Components.AddRange(new StiComponent[] { DataVW_Product_ProductID, BarCode1 }); // // Add to Page1.Components // Page1.Components.Clear(); Page1.Components.AddRange(new StiComponent[] { HeaderVW_Product, DataVW_Product, FooterVW_Product }); // // Add to Pages // Pages.Clear(); Pages.AddRange(new[] { Page1 }); VW_Product.Columns.AddRange(new[] { new StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)), new StiDataColumn("PurchaseOrderDetailID", "PurchaseOrderDetailID", "PurchaseOrderDetailID", typeof(Guid)), new StiDataColumn("MedicamentCategoryID", "MedicamentCategoryID", "MedicamentCategoryID", typeof(int)), new StiDataColumn("MedicamentCategoryName", "MedicamentCategoryName", "MedicamentCategoryName", typeof(string)), new StiDataColumn("MedicamentSubcategoryID", "MedicamentSubcategoryID", "MedicamentSubcategoryID", typeof(int)), new StiDataColumn("MedicamentSubcategoryName", "MedicamentSubcategoryName", "MedicamentSubcategoryName", typeof(string)), new StiDataColumn("MedicamentID", "MedicamentID", "MedicamentID", typeof(int)), new StiDataColumn("MedicamentName", "MedicamentName", "MedicamentName", typeof(string)), new StiDataColumn("Serie", "Serie", "Serie", typeof(string)), new StiDataColumn("PurchaseUnitPriceCU", "PurchaseUnitPriceCU", "PurchaseUnitPriceCU", typeof(decimal)), new StiDataColumn("SaleUnitPriceCU", "SaleUnitPriceCU", "SaleUnitPriceCU", typeof(decimal)), new StiDataColumn("Quantity", "Quantity", "Quantity", typeof(decimal)), new StiDataColumn("UnitsInStock", "UnitsInStock", "UnitsInStock", typeof(decimal)), new StiDataColumn("FinishedGoodsFlag", "FinishedGoodsFlag", "FinishedGoodsFlag", typeof(bool)), new StiDataColumn("SafetyStockLevel", "SafetyStockLevel", "SafetyStockLevel", typeof(short)), new StiDataColumn("ValidDate", "ValidDate", "ValidDate", typeof(DateTime)), new StiDataColumn("Color", "Color", "Color", typeof(string)), new StiDataColumn("CountryCode", "CountryCode", "CountryCode", typeof(string)), new StiDataColumn("CountryName", "CountryName", "CountryName", typeof(string)), new StiDataColumn("Size", "Size", "Size", typeof(string)), new StiDataColumn("SizeUnitMeasureCode", "SizeUnitMeasureCode", "SizeUnitMeasureCode", typeof(string)), new StiDataColumn("Weight", "Weight", "Weight", typeof(decimal)), new StiDataColumn("WeightUnitMeasureCode", "WeightUnitMeasureCode", "WeightUnitMeasureCode", typeof(string)), new StiDataColumn("Class", "Class", "Class", typeof(string)), new StiDataColumn("Style", "Style", "Style", typeof(string)), new StiDataColumn("SellStartDate", "SellStartDate", "SellStartDate", typeof(DateTime)), new StiDataColumn("SellEndDate", "SellEndDate", "SellEndDate", typeof(DateTime)), new StiDataColumn("DiscontinuedDate", "DiscontinuedDate", "DiscontinuedDate", typeof(DateTime)), 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("PurchaseUnitPrice", "PurchaseUnitPrice", "PurchaseUnitPrice", typeof(decimal)), new StiDataColumn("SaleUnitPrice", "SaleUnitPrice", "SaleUnitPrice", typeof(decimal)), new StiDataColumn("Action", "Action", "Action", typeof(int)) }); DataSources.Add(VW_Product); }