MES_Client/TGMES/Core.StlMes.Client.BuyBillet/Common Cls/CommonMethod.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;

using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinEditors;
//using Infragistics.Win.UltraWinGrid.ExcelExport;
using Core.Mes.Client.Comm;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using System.Text.RegularExpressions;
using Infragistics.Win.UltraWinMaskedEdit;

namespace Core.StlMes.Client.BuyBillet
{
    public class CommonMethod
    {
        public static void SetStaticsInfoSum(ref UltraGrid myGrid1, ArrayList alistColumns, bool clearExists)
        {
            try
            {
                UltraGridBand band = myGrid1.DisplayLayout.Bands[0];
                if (clearExists)
                    band.Summaries.Clear();
                band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;

               

                for (int i = 0; i < alistColumns.Count; i++)
                {
                    try
                    {
                        //if (alistColumns[i].ToString() == "GTLRATEYLG")
                        //{
                        //    SummarySettings summary1 = band.Summaries.Add("GTLRATEYLG", SummaryType.Formula, band.Columns["GTLRATEYLG"]);
                        //    band.Summaries["GTLRATEYLG"].Formula = "sum([FGSTYLG])*100/sum( [MATERIALOUTYLG])";
                        //    //summary1.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;
                        //    //summary1.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                        //    summary1.DisplayFormat = "{0:N2}"+"%";
                        //    summary1.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
                        //    summary1.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
                        //    summary1.Appearance.FontData.Bold = DefaultableBoolean.True;
                        //    summary1.Lines = 3;
                        //    continue;
                        //}
                            SummarySettings summary = band.Summaries.Add(SummaryType.Sum, band.Columns[alistColumns[i].ToString()]);
                            summary.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;
                            summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                            if (alistColumns[i].ToString().Contains("COUNT"))
                            {
                                summary.DisplayFormat = "{0:N0}";
                            }
                            else
                            {
                                summary.DisplayFormat = "{0:N2}";
                            }
                            summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
                            summary.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
                            summary.Appearance.FontData.Bold = DefaultableBoolean.True;
                            summary.Lines = 3;
 
                    }
                    catch { }
                }
                //band.Summaries.Add("Summary1", SummaryType.Count, band.Columns["GTLRATEYLG"]);
                //band.Summaries["Summary1"].Formula ="sum([FGSTYLG])*100/sum([MATERIALOUTYLG])";

            }
            catch { }
        }

        public static void SetGridSumArea(Infragistics.Win.UltraWinGrid.UltraGridBase Grid)
        {
            try
            {
                //Grid.DisplayLayout.GroupByBox.Hidden
                if (Grid.Rows.Count == 0)
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in Grid.DisplayLayout.Bands)
                    {
                        foreach (Infragistics.Win.UltraWinGrid.SummarySettings sum in band.Summaries)
                        {
                            sum.SummaryDisplayArea = Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.None;
                        }
                    }
                }
                else
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in Grid.DisplayLayout.Bands)
                    {
                        foreach (Infragistics.Win.UltraWinGrid.SummarySettings sum in band.Summaries)
                        {
                            if (Grid.DisplayLayout.GroupByBox.Hidden)
                            {
                                sum.SummaryDisplayArea = Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.Top;
                            }
                            else
                            {
                                sum.SummaryDisplayArea = ((Infragistics.Win.UltraWinGrid.SummaryDisplayAreas)((Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.Top | Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.InGroupByRows | Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.GroupByRowsFooter)));
                            }
                        }
                    }
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        public static void SetStaticsInfoCustomization(ref UltraGrid myGrid1,string column1,string column2,string column3,string column4)
        {
            UltraGridBand band = myGrid1.DisplayLayout.Bands[0];

            band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;

            // Add the OrderTotals custom summary.
            SummarySettings summary = band.Summaries.Add(
                Guid.NewGuid().ToString(),					// Give an identifier (key) for this summary
                SummaryType.Custom,				// Summary type is custom
                new OrderTotalsSummary(column1,column2,column3),		// Our custom summary calculator
                band.Columns[column4],		// Column being summarized. Just use Unit Price column.
                SummaryPosition.Left,			// Position the summary on the left of summary footer
                null							// Since SummaryPosition is Left, pass in null
                );
            summary.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;
            summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
            summary.DisplayFormat = "{0:N0}";
            summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
            summary.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
            summary.Appearance.FontData.Bold = DefaultableBoolean.True;
            summary.Lines = 3;
        }
    }
}