Esempio n. 1
0
        private void ReadGroupHeaderBand(XtraReportBase xtraReport, GroupHeaderBand xtraBand, StiPage page)
        {
            StiGroupHeaderBand band = new StiGroupHeaderBand();

            page.Components.Add(band);

            ReadBand(xtraBand, band);
        }
Esempio n. 2
0
        private void ReadGroupHeaderBand(XmlNode node, StiPage page)
        {
            StiGroupHeaderBand band = new StiGroupHeaderBand();

            page.Components.Add(band);

            ReadBand(node, band);

            string condition = ReadString(node, "Condition", band.Name);

            band.Condition.Value = condition;
        }
Esempio n. 3
0
        public IReportBuilder WithGroupHeaderBand(string expression, List <string> groupTitles = null, double height = 0.2)
        {
            CurrentGroupHeader = new StiGroupHeaderBand(MakeRectangle(0, 0, 0, height))
            {
                Condition = { Value = expression }
            };
            Page.Components.Add(CurrentGroupHeader);

            var spaces = "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
            var titles = string.Join(spaces, groupTitles);

            var stiText = _textBuilder.New(titles).WithSize(ContentWidth, height).WithFont(FontStyle.Bold)
                          .WithBorder(StiBorderSides.None).WithWordWrap(true).WithVAlign(StiVertAlignment.Bottom).Then();

            CurrentGroupHeader.Components.Add(stiText);
            return(this);
        }
 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);
 }
Esempio n. 5
0
 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);
 }
Esempio n. 6
0
        protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport)
        {
            //DataSet ds;
            vw_invr410       invr410Model;
            StringBuilder    sbSql   = null;
            string           sqlBody = "";
            DataTable        dtIlaTb;
            List <QueryInfo> queryInfoList;
            QueryInfo        queryModel;
            string           strQueryRange, strWhere;
            StringBuilder    sbQuerySingle = null;

            List <SqlParameter> sqlParmList;
            List <Master>       resultList = null;

            try
            {
                invr410Model  = DrMaster.ToItem <vw_invr410>();
                resultList    = new List <Master>();
                queryInfoList = new List <QueryInfo>();
                #region range 處理
                if (!GlobalFn.varIsNull(invr410Model.ila03))
                {
                    queryModel            = new QueryInfo();
                    queryModel.TableName  = "ila_tb";
                    queryModel.ColumnName = "ila03";
                    queryModel.ColumnType = TabMaster.DtSource.Columns["ila03"].DataType.Name;
                    queryModel.Value      = invr410Model.ila03;
                    queryInfoList.Add(queryModel);
                }
                if (!GlobalFn.varIsNull(invr410Model.ila04))
                {
                    queryModel            = new QueryInfo();
                    queryModel.TableName  = "ila_tb";
                    queryModel.ColumnName = "ila04";
                    queryModel.ColumnType = TabMaster.DtSource.Columns["ila04"].DataType.Name;
                    queryModel.Value      = invr410Model.ila04;
                    queryInfoList.Add(queryModel);
                }
                if (!GlobalFn.varIsNull(invr410Model.ila05))
                {
                    queryModel            = new QueryInfo();
                    queryModel.TableName  = "ila_tb";
                    queryModel.ColumnName = "ila05";
                    queryModel.ColumnType = TabMaster.DtSource.Columns["ila05"].DataType.Name;
                    queryModel.Value      = invr410Model.ila05;
                    queryInfoList.Add(queryModel);
                }
                sqlParmList   = new List <SqlParameter>();
                strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList);
                #endregion

                #region single 處理
                sbQuerySingle = new StringBuilder();
                if (!GlobalFn.varIsNull(invr410Model.ila02_s))
                {
                    sbQuerySingle.AppendLine("AND ila02>=@ila02_s");
                    sqlParmList.Add(new SqlParameter("@ila02_s", invr410Model.ila02_s));
                }
                if (!GlobalFn.varIsNull(invr410Model.ila02_e))
                {
                    sbQuerySingle.AppendLine("AND ila02<=@ila02_e");
                    sqlParmList.Add(new SqlParameter("@ila02_e", invr410Model.ila02_e));
                }

                if (invr410Model.conf_yn != "0")
                {
                    if (invr410Model.conf_yn == "1")
                    {
                        sbQuerySingle.AppendLine("AND ilaconf = 'Y'");
                    }
                    if (invr410Model.conf_yn == "2")
                    {
                        sbQuerySingle.AppendLine("AND ilaconf = 'N'");
                    }
                }

                if (invr410Model.close_yn != "0")
                {
                    if (invr410Model.close_yn == "1")//未結案
                    {
                        sbQuerySingle.AppendLine("AND (ilb05-ilb15) >0 ");
                    }
                    if (invr410Model.close_yn == "2")//已結案
                    {
                        sbQuerySingle.AppendLine("AND (ilb05-ilb15) <=0  ");
                    }
                }
                #endregion

                strWhere = strQueryRange + " " + sbQuerySingle.ToString();
                var strSecurity = WfGetSecurityString();        //取得權限字串
                if (!GlobalFn.varIsNull(strSecurity))
                {
                    strWhere += strSecurity;
                }

                //取得單頭
                sqlBody = @"
                              SELECT 
                                ila01,ila02,ila03,sca03 as ila03_c ,
                                ilb02,ila04,bec02 AS ila04_c,ila05,beb03 AS ila05_c,
                                ilb03,ilb04,ilb05,'' as ilb05_str,ilb06,
                                bej03,ilb11,
                                ilb15,'' as ilb15_str,
                                ilb16
                              FROM ila_tb
                                    LEFT JOIN ilb_tb ON ila01=ilb01
                                    LEFT JOIN sca_tb ON ila03=sca01
                                    LEFT JOIN bec_tb ON ila04=bec01
                                    LEFT JOIN beb_tb ON ila05=beb01
                                    LEFT JOIN bej_tb ON ilb06=bej01
                              WHERE ilaconf='Y'
                                AND ilb01 IS NOT NULL
                                ";

                dtIlaTb           = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere), sqlParmList.ToArray());
                dtIlaTb.TableName = "Master";
                if (dtIlaTb != null)
                {
                    resultList.AddRange(dtIlaTb.ToList <Master>());
                }

                if (resultList == null || resultList.Count == 0)
                {
                    WfShowErrorMsg("查無資料,請重新過濾條件!");
                    return(false);
                }

                foreach (Master masterModel in resultList)
                {
                    //數量處理
                    masterModel.ilb05_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.ilb05); //數量
                    masterModel.ilb15_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.ilb15); //數量
                }

                pReport.RegData("master", resultList);
                pReport.CacheAllData = true;
                //處理排序--這裡利用group來達到
                StiGroupHeaderBand stiGroupHeaderBand1 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand1"];
                switch (invr410Model.order_by)
                {
                case "1":    //1.依出庫日期
                    stiGroupHeaderBand1.Condition.Value = "{Master.ila02}";
                    break;

                case "2":    //2.依客戶
                    stiGroupHeaderBand1.Condition.Value = "{Master.ila03}";
                    break;

                case "3":    //3.依部門
                    stiGroupHeaderBand1.Condition.Value = "{Master.ila05}";
                    break;

                case "4":    //4.依業務
                    stiGroupHeaderBand1.Condition.Value = "{Master.ila04}";
                    break;

                case "5":    //4.依出庫倉
                    stiGroupHeaderBand1.Condition.Value = "{Master.ila11}";
                    break;
                }
                //處理跳頁

                StiDataBand dataBand1 = (StiDataBand)pReport.GetComponents()["DataBand1"];
                if (invr410Model.jump_yn.ToUpper() == "Y")
                {
                    dataBand1.NewPageAfter    = true;
                    dataBand1.ResetPageNumber = true;
                }
                else
                {
                    dataBand1.NewPageAfter    = false;
                    dataBand1.ResetPageNumber = false;
                }

                pReport.Compile();
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 7
0
        protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport)
        {
            //DataSet ds;
            vw_stpr410       stpr410Model;
            StringBuilder    sbSql = null;
            string           sqlBody = "";
            DataTable        dtSgaTb, dtShaTb;
            List <QueryInfo> queryInfoList;
            QueryInfo        queryModel;
            string           strQueryRange, strWhere;
            StringBuilder    sbQuerySingle = null;

            List <SqlParameter> sqlParmList;
            List <MasterA>      resultList = null;

            try
            {
                stpr410Model = DrMaster.ToItem <vw_stpr410>();
                resultList   = new List <MasterA>();
                #region 處理銷售
                if (stpr410Model.sale_type == "0" || stpr410Model.sale_type == "1")
                {
                    queryInfoList = new List <QueryInfo>();
                    #region range 處理
                    if (!GlobalFn.varIsNull(stpr410Model.sga03))
                    {
                        queryModel            = new QueryInfo();
                        queryModel.TableName  = "sga_tb";
                        queryModel.ColumnName = "sga03";
                        queryModel.ColumnType = TabMaster.DtSource.Columns["sga03"].DataType.Name;
                        queryModel.Value      = stpr410Model.sga03;
                        queryInfoList.Add(queryModel);
                    }
                    if (!GlobalFn.varIsNull(stpr410Model.sga04))
                    {
                        queryModel            = new QueryInfo();
                        queryModel.TableName  = "sga_tb";
                        queryModel.ColumnName = "sga04";
                        queryModel.ColumnType = TabMaster.DtSource.Columns["sga04"].DataType.Name;
                        queryModel.Value      = stpr410Model.sga04;
                        queryInfoList.Add(queryModel);
                    }
                    if (!GlobalFn.varIsNull(stpr410Model.sga05))
                    {
                        queryModel            = new QueryInfo();
                        queryModel.TableName  = "sga_tb";
                        queryModel.ColumnName = "sga05";
                        queryModel.ColumnType = TabMaster.DtSource.Columns["sga05"].DataType.Name;
                        queryModel.Value      = stpr410Model.sga05;
                        queryInfoList.Add(queryModel);
                    }
                    sqlParmList   = new List <SqlParameter>();
                    strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList);
                    #endregion

                    #region single 處理
                    sbQuerySingle = new StringBuilder();
                    if (!GlobalFn.varIsNull(stpr410Model.sga02_s))
                    {
                        sbQuerySingle.AppendLine("AND sga02>=@sga02_s");
                        sqlParmList.Add(new SqlParameter("@sga02_s", stpr410Model.sga02_s));
                    }
                    if (!GlobalFn.varIsNull(stpr410Model.sga02_e))
                    {
                        sbQuerySingle.AppendLine("AND sga02<=@sga02_e");
                        sqlParmList.Add(new SqlParameter("@sga02_e", stpr410Model.sga02_e));
                    }

                    if (stpr410Model.confirm_type == "1")
                    {
                        sbQuerySingle.AppendLine("AND sgaconf ='Y'");
                    }
                    else if (stpr410Model.confirm_type == "2")
                    {
                        sbQuerySingle.AppendLine("AND ISNULL(sgaconf,'') <>'Y'");
                    }
                    #endregion

                    strWhere = strQueryRange + " " + sbQuerySingle.ToString();
                    var strSecurity = WfGetSecurityString();        //取得權限字串
                    if (!GlobalFn.varIsNull(strSecurity))
                    {
                        strWhere += strSecurity;
                    }

                    //取得單頭
                    sqlBody = @"
                              SELECT 
                                '銷貨' AS sale_type,
                                sga01,sga02,sga03,sca03 as sga03_c ,
                                sgb02,sga04,bec02 AS sga04_c,sga05,beb03 AS sga05_c,
                                sga10,sga21,
                                sgb03,sgb04,sgb05,'' as sgb05_str,sgb06,
                                bej03,
                                0.0 as price,'' as price_string,
                                sgb10,'' as sgb10_string,
                                sgb10t,'' as sgb10t_string,
                                sgb16
                              FROM sga_tb
                                    LEFT JOIN sgb_tb ON sga01=sgb01
                                    LEFT JOIN sca_tb ON sga03=sca01
                                    LEFT JOIN bec_tb ON sga04=bec01
                                    LEFT JOIN beb_tb ON sga05=beb01
                                    LEFT JOIN bej_tb ON sgb06=bej01
                              WHERE  sgb01 IS NOT NULL
                                ";

                    dtSgaTb           = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere), sqlParmList.ToArray());
                    dtSgaTb.TableName = "Master";
                    if (dtSgaTb != null)
                    {
                        resultList.AddRange(dtSgaTb.ToList <YR.ERP.DAL.YRModel.Reports.Stp.Stpr410.MasterA>());
                    }
                }
                #endregion

                #region 處理退貨/折讓
                if (stpr410Model.sale_type == "0" || stpr410Model.sale_type == "2")
                {
                    queryInfoList = new List <QueryInfo>();
                    #region range 處理
                    if (!GlobalFn.varIsNull(stpr410Model.sga03))
                    {
                        queryModel            = new QueryInfo();
                        queryModel.TableName  = "sha_tb";
                        queryModel.ColumnName = "sha03";
                        queryModel.ColumnType = TabMaster.DtSource.Columns["sga03"].DataType.Name;
                        queryModel.Value      = stpr410Model.sga03;
                        queryInfoList.Add(queryModel);
                    }
                    if (!GlobalFn.varIsNull(stpr410Model.sga04))
                    {
                        queryModel            = new QueryInfo();
                        queryModel.TableName  = "sha_tb";
                        queryModel.ColumnName = "sha04";
                        queryModel.ColumnType = TabMaster.DtSource.Columns["sga04"].DataType.Name;
                        queryModel.Value      = stpr410Model.sga04;
                        queryInfoList.Add(queryModel);
                    }
                    if (!GlobalFn.varIsNull(stpr410Model.sga05))
                    {
                        queryModel            = new QueryInfo();
                        queryModel.TableName  = "sha_tb";
                        queryModel.ColumnName = "sha05";
                        queryModel.ColumnType = TabMaster.DtSource.Columns["sga05"].DataType.Name;
                        queryModel.Value      = stpr410Model.sga05;
                        queryInfoList.Add(queryModel);
                    }
                    sqlParmList   = new List <SqlParameter>();
                    strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList);
                    #endregion

                    #region single 處理
                    sbQuerySingle = new StringBuilder();
                    if (!GlobalFn.varIsNull(stpr410Model.sga02_s))
                    {
                        sbQuerySingle.AppendLine("AND sha02>=@sha02_s");
                        sqlParmList.Add(new SqlParameter("@sha02_s", stpr410Model.sga02_s));
                    }
                    if (!GlobalFn.varIsNull(stpr410Model.sga02_e))
                    {
                        sbQuerySingle.AppendLine("AND sha02<=@sha02_e");
                        sqlParmList.Add(new SqlParameter("@sha02_e", stpr410Model.sga02_e));
                    }

                    if (stpr410Model.confirm_type == "1")
                    {
                        sbQuerySingle.AppendLine("AND shaconf ='Y'");
                    }
                    else if (stpr410Model.confirm_type == "2")
                    {
                        sbQuerySingle.AppendLine("AND ISNULL(shaconf,'') <>'Y'");
                    }
                    #endregion

                    strWhere = strQueryRange + " " + sbQuerySingle.ToString();
                    var strSecurity = WfGetSecurityString();        //取得權限字串
                    if (!GlobalFn.varIsNull(strSecurity))
                    {
                        strWhere += strSecurity;
                    }

                    //取得單頭
                    sqlBody = @"
                              SELECT 
                                CASE WHEN shb17='1' THEN '銷退' ELSE '折讓' END AS sale_type,
                                sha01 AS sga01,sha02 AS sga02,sha03 AS sga03,sca03 as sga03_c ,
                                shb02 AS sgb02,sha04 AS sga04,bec02 AS sga04_c,sha05 AS sga05,beb03 AS sga05_c,
                                sha10 AS sga10,shb19 AS sga21,
                                shb03 AS sgb03,shb04 AS sgb04,shb05 AS sgb05,'' as sgb05_str,shb06 AS sgb06,
                                bej03,
                                0.0 as price,'' as price_string,
                                -1*shb10 AS sgb10,'' as sgb10_string,
                                -1*shb10t AS sgb10t,'' as sgb10t_string,
                                shb16 AS sgb16
                              FROM sha_tb
                                    LEFT JOIN shb_tb ON sha01=shb01
                                    LEFT JOIN sca_tb ON sha03=sca01
                                    LEFT JOIN bec_tb ON sha04=bec01
                                    LEFT JOIN beb_tb ON sha05=beb01
                                    LEFT JOIN bej_tb ON shb06=bej01
                              WHERE  shb01 IS NOT NULL
                                ";

                    dtSgaTb           = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere), sqlParmList.ToArray());
                    dtSgaTb.TableName = "Master";
                    if (dtSgaTb != null)
                    {
                        resultList.AddRange(dtSgaTb.ToList <YR.ERP.DAL.YRModel.Reports.Stp.Stpr410.MasterA>());
                    }
                }
                #endregion

                if (resultList == null || resultList.Count == 0)
                {
                    WfShowErrorMsg("查無資料,請重新過濾條件!");
                    return(false);
                }

                foreach (MasterA masterModel in resultList)
                {
                    var bekModel = BoBas.OfGetBekModel(masterModel.sga10);
                    //處理單價
                    if (masterModel.sgb05 > 0)
                    {
                        masterModel.price = Math.Round((masterModel.sgb10 / masterModel.sgb05), Convert.ToInt16(bekModel.bek03), MidpointRounding.AwayFromZero);
                    }
                    else
                    {
                        masterModel.price = masterModel.sgb10;
                    }

                    masterModel.price_string  = string.Format("{0:N" + bekModel.bek03 + "}", masterModel.price);
                    masterModel.sgb10_string  = string.Format("{0:N" + bekModel.bek04 + "}", masterModel.sgb10);
                    masterModel.sgb10t_string = string.Format("{0:N" + bekModel.bek04 + "}", masterModel.sgb10t);
                    //數量處理
                    masterModel.sgb05_str = string.Format("{0:N" + masterModel.bej03 + "}", masterModel.sgb05);//數量
                }

                pReport.RegData("master", resultList);
                pReport.CacheAllData = true;
                //處理排序--這裡利用group來達到

                StiGroupHeaderBand stiGroupHeaderBand1 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand1"];
                StiDataBand        StiDataBand1        = (StiDataBand)pReport.GetComponents()["DataBand1"];
                switch (stpr410Model.order_by)
                {
                case "1":    //1.依出庫日期
                    stiGroupHeaderBand1.Condition.Value = "{Master.sga02}";
                    StiDataBand1.Sort = new string[6] {
                        "ASC",
                        "sga02",
                        "ASC",
                        "sga01",
                        "ASC",
                        "sgb02",
                    };
                    break;

                case "2":    //2.依客戶
                    stiGroupHeaderBand1.Condition.Value = "{Master.sga03}";
                    StiDataBand1.Sort = new string[6] {
                        "ASC",
                        "sga03",
                        "ASC",
                        "sga01",
                        "ASC",
                        "sgb02",
                    };
                    break;

                case "3":    //3.依部門
                    stiGroupHeaderBand1.Condition.Value = "{Master.sga05}";
                    StiDataBand1.Sort = new string[6] {
                        "ASC",
                        "sga05",
                        "ASC",
                        "sga01",
                        "ASC",
                        "sgb02",
                    };
                    break;

                case "4":    //4.依業務
                    stiGroupHeaderBand1.Condition.Value = "{Master.sga04}";
                    StiDataBand1.Sort = new string[6] {
                        "ASC",
                        "sga04",
                        "ASC",
                        "sga01",
                        "ASC",
                        "sgb02",
                    };
                    break;
                }
                //處理跳頁
                StiGroupFooterBand footerBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"];
                if (stpr410Model.jump_yn.ToUpper() == "Y")
                {
                    footerBand1.NewPageAfter    = true;
                    footerBand1.ResetPageNumber = true;
                }
                else
                {
                    footerBand1.NewPageAfter    = false;
                    footerBand1.ResetPageNumber = false;
                }

                pReport.Compile();
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 8
0
        protected override bool WfExecReport(Stimulsoft.Report.StiReport pReport)
        {
            vw_glar311       glar311Model;
            StringBuilder    sbSql      = null;
            string           sqlBody    = "";
            string           sqlOrderBy = "";
            DataTable        dtMaster;
            List <Master>    masterList;
            List <QueryInfo> queryInfoList;
            QueryInfo        queryModel;
            string           strQueryRange, strWhere;
            StringBuilder    sbQuerySingle = null;

            List <SqlParameter> sqlParmList;

            try
            {
                glar311Model = DrMaster.ToItem <vw_glar311>();

                queryInfoList = new List <QueryInfo>();
                #region range 處理
                if (!GlobalFn.varIsNull(glar311Model.gfa01))
                {
                    queryModel            = new QueryInfo();
                    queryModel.TableName  = "gfa_tb";
                    queryModel.ColumnName = "gfa01";
                    queryModel.ColumnType = TabMaster.DtSource.Columns["gfa01"].DataType.Name;
                    queryModel.Value      = glar311Model.gfa01;
                    queryInfoList.Add(queryModel);
                }
                sqlParmList   = new List <SqlParameter>();
                strQueryRange = BoMaster.WfGetQueryString(queryInfoList, out sqlParmList);
                #endregion

                #region single 處理
                sbQuerySingle = new StringBuilder();
                if (!GlobalFn.varIsNull(glar311Model.gfa02_s))
                {
                    sbQuerySingle.AppendLine("AND gfa02>=@gfa02_s");
                    sqlParmList.Add(new SqlParameter("@gfa02_s", glar311Model.gfa02_s));
                }
                if (!GlobalFn.varIsNull(glar311Model.gfa02_e))
                {
                    sbQuerySingle.AppendLine("AND gfa02<=@gfa02_e");
                    sqlParmList.Add(new SqlParameter("@gfa02_e", glar311Model.gfa02_e));
                }

                //過帳否
                if (glar311Model.gfapost == "1")
                {
                    sbQuerySingle.AppendLine("AND gfapost='N'");
                }
                else if (glar311Model.gfapost == "2")
                {
                    sbQuerySingle.AppendLine("AND gfapost='Y'");
                }

                //有效否
                if (glar311Model.gfaconf == "1")
                {
                    sbQuerySingle.AppendLine("AND gfaconf <>'X' ");
                }
                else if (glar311Model.gfaconf == "2")
                {
                    sbQuerySingle.AppendLine("AND gfapost='X' ");
                }
                #endregion

                strWhere = strQueryRange + " " + sbQuerySingle.ToString();
                var strSecurity = WfGetSecurityString();        //取得權限字串
                if (!GlobalFn.varIsNull(strSecurity))
                {
                    strWhere += strSecurity;
                }

                //取得單頭
                sqlBody = @"SELECT 
	                            gfa01,gfa02,gfa03,gfa04,gfa05,
	                            gfa06,gfa07,gfa08,gfa09,
	                            gfaprno,gfaconf,gfacond,gfaconu,
	                            gfapost,gfaposd,gfaposu,
                                gfacreu,gfacred,
                                gac02 as gfa01_c,
	                            gfb02,gfb03,gfb04,gfb05,
	                            gfb06,gfb07,gfb08,gfb09,gfb10,
	                            gba02 AS gfb03_c,
	                            beb03 AS gfb05_c,
	                            bek04,
	                            gba05
                            FROM gfa_tb                                
                                LEFT JOIN gfb_tb ON gfa01=gfb01
	                            LEFT JOIN baa_tb ON 1=1	
	                            LEFT JOIN gac_tb ON substring(gfa01,1,baa06)=gac01
	                            LEFT JOIN gba_tb ON gfb03=gba01
	                            LEFT JOIN bek_tb ON gfb08=bek01
	                            LEFT JOIN beb_tb ON gfb05=beb01
                            WHERE 1=1       
                           ";
                #region 排序處理
                if (!GlobalFn.varIsNull(glar311Model.order1))
                {
                    switch (glar311Model.order1)
                    {
                    case "1":
                        sqlOrderBy = "ORDER BY gfa01";
                        break;

                    case "2":
                        sqlOrderBy = "ORDER BY gfa02";
                        break;

                    case "3":
                        sqlOrderBy = "ORDER BY gfb03";
                        break;

                    case "4":
                        sqlOrderBy = "ORDER BY gfb05";
                        break;

                    case "5":
                        sqlOrderBy = "ORDER BY gfb02";
                        break;

                    case "6":
                        sqlOrderBy = "ORDER BY gfa06";
                        break;
                    }
                }
                if (!GlobalFn.varIsNull(glar311Model.order2))
                {
                    if (GlobalFn.varIsNull(sqlOrderBy))
                    {
                        switch (glar311Model.order2)
                        {
                        case "1":
                            sqlOrderBy = "ORDER BY gfa01";
                            break;

                        case "2":
                            sqlOrderBy = "ORDER BY gfa02";
                            break;

                        case "3":
                            sqlOrderBy = "ORDER BY gfb03";
                            break;

                        case "4":
                            sqlOrderBy = "ORDER BY gfb05";
                            break;

                        case "5":
                            sqlOrderBy = "ORDER BY gfb02";
                            break;

                        case "6":
                            sqlOrderBy = "ORDER BY gfa06";
                            break;
                        }
                    }
                    else
                    {
                        switch (glar311Model.order2)
                        {
                        case "1":
                            sqlOrderBy += ",gfa01";
                            break;

                        case "2":
                            sqlOrderBy += ",gfa02";
                            break;

                        case "3":
                            sqlOrderBy += ",gfb03";
                            break;

                        case "4":
                            sqlOrderBy += ",gfb05";
                            break;

                        case "5":
                            sqlOrderBy += ",gfb02";
                            break;

                        case "6":
                            sqlOrderBy += ",gfa06";
                            break;
                        }
                    }
                }
                if (!GlobalFn.varIsNull(glar311Model.order3))
                {
                    if (GlobalFn.varIsNull(sqlOrderBy))
                    {
                        switch (glar311Model.order3)
                        {
                        case "1":
                            sqlOrderBy = "ORDER BY gfa01";
                            break;

                        case "2":
                            sqlOrderBy = "ORDER BY gfa02";
                            break;

                        case "3":
                            sqlOrderBy = "ORDER BY gfb03";
                            break;

                        case "4":
                            sqlOrderBy = "ORDER BY gfb05";
                            break;

                        case "5":
                            sqlOrderBy = "ORDER BY gfb02";
                            break;

                        case "6":
                            sqlOrderBy = "ORDER BY gfa06";
                            break;
                        }
                    }
                    else
                    {
                        switch (glar311Model.order3)
                        {
                        case "1":
                            sqlOrderBy += ",gfa01";
                            break;

                        case "2":
                            sqlOrderBy += ",gfa02";
                            break;

                        case "3":
                            sqlOrderBy += ",gfb03";
                            break;

                        case "4":
                            sqlOrderBy += ",gfb05";
                            break;

                        case "5":
                            sqlOrderBy += ",gfb02";
                            break;

                        case "6":
                            sqlOrderBy += ",gfa06";
                            break;
                        }
                    }
                }
                #endregion

                dtMaster           = BoMaster.OfGetDataTable(string.Concat(sqlBody, strWhere, sqlOrderBy), sqlParmList.ToArray());
                dtMaster.TableName = "Master";

                if (dtMaster == null || dtMaster.Rows.Count == 0)
                {
                    WfShowErrorMsg("查無資料,請重新過濾條件!");
                    return(false);
                }
                masterList = dtMaster.ToList <Master>(true);
                //取得本幣資料
                var baaModel = BoBas.OfGetBaaModel();
                if (baaModel == null)
                {
                    WfShowErrorMsg("未設定基本參數,請先設定!");
                    return(false);
                }
                var baa04      = baaModel.baa04;
                var bekUsModel = BoBas.OfGetBekModel(baa04);
                if (bekUsModel == null)
                {
                    WfShowErrorMsg("查無本幣資料,請先設定!");
                    return(false);
                }
                masterList = dtMaster.ToList <Master>(true);

                foreach (Master masterModel in masterList)
                {
                    if (masterModel.gfb06 == "1")
                    {
                        masterModel.gfb07d     = masterModel.gfb07;
                        masterModel.gfb07d_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfb07);
                        masterModel.gfb10d     = masterModel.gfb10;
                        masterModel.gfb10d_str = string.Format("{0:N" + masterModel.bek04 + "}", masterModel.gfb10);
                    }
                    else
                    {
                        masterModel.gfb07c     = masterModel.gfb07;
                        masterModel.gfb07c_str = string.Format("{0:N" + bekUsModel.bek04 + "}", masterModel.gfb07);
                        masterModel.gfb10c     = masterModel.gfb10;
                        masterModel.gfb10c_str = string.Format("{0:N" + masterModel.bek04 + "}", masterModel.gfb10);
                    }
                }

                pReport.RegData("Master", masterList);
                pReport.CacheAllData = true;

                #region 列印選項處理
                StiGroupHeaderBand headerBand1 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand1"];
                StiGroupFooterBand footerBand1 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand1"];
                StiGroupHeaderBand headerBand2 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand2"];
                StiGroupFooterBand footerBand2 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand2"];
                StiGroupHeaderBand headerBand3 = (StiGroupHeaderBand)pReport.GetComponents()["GroupHeaderBand3"];
                StiGroupFooterBand footerBand3 = (StiGroupFooterBand)pReport.GetComponents()["GroupFooterBand3"];
                if (!GlobalFn.varIsNull(glar311Model.order1) &&
                    (glar311Model.order1_jump_yn == "Y" || glar311Model.order1_sum_yn == "Y"))
                {
                    switch (glar311Model.order1)
                    {
                    case "1":
                        headerBand1.Condition.Value = "{Master.gfa01}";
                        break;

                    case "2":
                        headerBand1.Condition.Value = "{Master.gfa02}";
                        break;

                    case "3":
                        headerBand1.Condition.Value = "{Master.gfb03}";
                        break;

                    case "4":
                        headerBand1.Condition.Value = "{Master.gfb05}";
                        break;

                    case "5":
                        headerBand1.Condition.Value = "{Master.gfb02}";
                        break;

                    case "6":
                        headerBand1.Condition.Value = "{Master.gfa06}";
                        break;
                    }

                    //處理跳頁
                    if (glar311Model.order1_jump_yn == "Y")
                    {
                        headerBand1.NewPageBefore   = true;
                        headerBand1.ResetPageNumber = true;
                    }
                    else
                    {
                        headerBand1.NewPageBefore   = false;
                        headerBand1.ResetPageNumber = false;
                    }
                    //處理小計
                    if (glar311Model.order1_sum_yn.ToUpper() != "Y")
                    {
                        footerBand1.Enabled = false;
                    }
                }
                else
                {
                    footerBand1.Enabled = false;
                }

                if (!GlobalFn.varIsNull(glar311Model.order2) &&
                    (glar311Model.order2_jump_yn == "Y" || glar311Model.order2_sum_yn == "Y"))
                {
                    switch (glar311Model.order2)
                    {
                    case "1":
                        headerBand2.Condition.Value = "{Master.gfa01}";
                        break;

                    case "2":
                        headerBand2.Condition.Value = "{Master.gfa02}";
                        break;

                    case "3":
                        headerBand2.Condition.Value = "{Master.gfb03}";
                        break;

                    case "4":
                        headerBand2.Condition.Value = "{Master.gfb05}";
                        break;

                    case "5":
                        headerBand2.Condition.Value = "{Master.gfb02}";
                        break;

                    case "6":
                        headerBand2.Condition.Value = "{Master.gfa06}";
                        break;
                    }

                    //處理跳頁
                    if (glar311Model.order2_jump_yn.ToUpper() == "Y")
                    {
                        headerBand2.NewPageBefore   = true;
                        headerBand2.ResetPageNumber = true;
                    }
                    else
                    {
                        headerBand2.NewPageBefore   = false;
                        headerBand2.ResetPageNumber = false;
                    }
                    //處理小計
                    if (glar311Model.order2_sum_yn.ToUpper() != "Y")
                    {
                        footerBand2.Enabled = false;
                    }
                }
                else
                {
                    footerBand2.Enabled = false;
                }

                if (!GlobalFn.varIsNull(glar311Model.order3) &&
                    (glar311Model.order3_jump_yn == "Y" || glar311Model.order3_sum_yn == "Y"))
                {
                    switch (glar311Model.order3)
                    {
                    case "1":
                        headerBand3.Condition.Value = "{Master.gfa01}";
                        break;

                    case "2":
                        headerBand3.Condition.Value = "{Master.gfa02}";
                        break;

                    case "3":
                        headerBand3.Condition.Value = "{Master.gfb03}";
                        break;

                    case "4":
                        headerBand3.Condition.Value = "{Master.gfb05}";
                        break;

                    case "5":
                        headerBand3.Condition.Value = "{Master.gfb02}";
                        break;

                    case "6":
                        headerBand3.Condition.Value = "{Master.gfa06}";
                        break;
                    }

                    //處理跳頁
                    if (glar311Model.order3_jump_yn.ToUpper() == "Y")
                    {
                        headerBand3.NewPageBefore   = true;
                        headerBand3.ResetPageNumber = true;
                    }
                    else
                    {
                        headerBand3.NewPageBefore   = false;
                        headerBand3.ResetPageNumber = false;
                    }
                    //處理小計
                    if (glar311Model.order3_sum_yn.ToUpper() != "Y")
                    {
                        footerBand3.Enabled = false;
                    }
                }
                else
                {
                    footerBand3.Enabled = false;
                }
                #endregion
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }