XinYu_LG2MES/ClientSolution/Core.Mes.Client.Common/lgCommon/UltraGridMgt.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Diagnostics;
using System.Data;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinGrid.ExcelExport;
using System.Runtime.InteropServices;
using CoreFS.CA06;
using Infragistics.Win;
using System.Collections;
using System.Drawing;
using Infragistics.Win.UltraWinEditors;
using System.Xml;
using System.Data.OleDb;

namespace Core.Mes.Client.Common
{
    /// <summary>
    /// UltraGrid 管理类
    /// </summary>
    public class UltraGridMgt
    {
        /// <summary>
        /// 设置UltraGrid 列只读
        /// </summary>
        /// <param name="ultGrid"></param>
        public static void SetUltraGridColumnsReadOnly(ref UltraGrid ultGrid)
        {
            try
            {
                foreach (UltraGridBand band in ultGrid.DisplayLayout.Bands)
                {
                    foreach (UltraGridColumn column in band.Columns)
                    {                       
                        column.CellActivation = Activation.ActivateOnly;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }


        public static void proc_Statics(ref UltraGrid ultraGrid, ArrayList alistColumns, bool clearExists, string strFormat)
        {
            try
            {
                if (alistColumns == null)
                {
                    return;
                }

                UltraGridBand band = ultraGrid.DisplayLayout.Bands[0];
                if (clearExists)
                    band.Summaries.Clear();

                SummarySettings summary = null;

                UltraGridColumn cl = null;
                foreach (UltraGridColumn column in ultraGrid.DisplayLayout.Bands[0].Columns)
                {
                    
                        if (column.RowLayoutColumnInfo.OriginX == 0)
                        {
                            cl = column;
                            break;
                        }
                  
                }

                if (cl == null)
                    cl = ultraGrid.DisplayLayout.Bands[0].Columns[0];
                         

                summary = band.Summaries.Add(SummaryType.Count, cl);
                summary.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;
                summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                summary.DisplayFormat = "合计：";

                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
                summary.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
                summary.Appearance.FontData.Bold = DefaultableBoolean.True;

                if (string.IsNullOrEmpty(strFormat.Trim()))
                {
                    strFormat = " {0:############0.00}";
                }
                for (int i = 0; i < alistColumns.Count; i++)
                {
                    try
                    {
                        summary = band.Summaries.Add(SummaryType.Sum, band.Columns[alistColumns[i].ToString()]);
                        summary.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;
                        summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                        summary.DisplayFormat = strFormat;

                        summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
                        summary.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
                        summary.Appearance.FontData.Bold = DefaultableBoolean.True;
                        summary.Appearance.ForeColor = Color.DarkBlue;
                        summary.Appearance.BackColor = Color.White;
                    }
                    catch { }
                }

                band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;
            }
            catch (Exception ex){ }
        }



        public static void proc_Statics_Avg2(ref UltraGrid ultraGrid, ArrayList alistColumns, bool clearExists, ArrayList alistFormat)
        {
            try
            {
                if (alistColumns == null)
                {
                    return;
                }

                UltraGridBand band = ultraGrid.DisplayLayout.Bands[0];
                if (clearExists)
                    band.Summaries.Clear();

                SummarySettings summary = null;

                UltraGridColumn cl = null;
                foreach (UltraGridColumn column in ultraGrid.DisplayLayout.Bands[0].Columns)
                {
                   
                        if (column.RowLayoutColumnInfo.OriginX == 0)
                        {
                            cl = column;
                            break;
                        }
                  
                }

                if (cl == null)
                    cl = ultraGrid.DisplayLayout.Bands[0].Columns[0];

                summary = band.Summaries.Add(SummaryType.Count, cl);
                summary.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;
                summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                summary.DisplayFormat = "平均：";

                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
                summary.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
                summary.Appearance.FontData.Bold = DefaultableBoolean.True;

                string strFormat = "";

                for (int i = 0; i < alistColumns.Count; i++)
                {
                    try
                    {
                        try
                        {
                            strFormat = alistFormat[i].ToString();
                        }
                        catch
                        {
                            strFormat = " {0:############0.00}";
                        }

                        summary = band.Summaries.Add(SummaryType.Average, band.Columns[alistColumns[i].ToString()]);
                        summary.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;
                        summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                        summary.DisplayFormat = strFormat;

                        summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
                        summary.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
                        summary.Appearance.FontData.Bold = DefaultableBoolean.True;
                        summary.Appearance.ForeColor = Color.DarkBlue;
                        summary.Appearance.BackColor = Color.White;
                    }
                    catch { }
                }

                band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;
            }
            catch { }
        }


        public static void SetGridRowFilter(ref UltraGrid ultGrid, bool bAllowFilter)
        {
            try
            {
                if (bAllowFilter)
                {
                    ultGrid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
                }
                else
                {
                    ultGrid.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
                    ultGrid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
                }
            }
            catch { }
        }
    }
}