MES_Client/TGMES/Core.StlMes.Client.YdmPipeReport/Tool/BaseHelper.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using Core.Mes.Client.Comm.Server;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinMaskedEdit;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win;
using System.Text.RegularExpressions;

namespace Core.StlMes.Client.YdmPipeReport.Tool
{
    public class BaseHelper
    {
        /// <summary>
        /// 设置列字段显示位置在右
        /// </summary>
        /// <param name="ug">UltraGrid</param>
        /// <param name="columnsKeys">要设置的列</param>
        public static void InitCellPosition(UltraGrid ug, string[] columnsKeys)
        {
            columnsKeys.ToArray();
            foreach (UltraGridColumn ugc in ug.DisplayLayout.Bands[0].Columns)
            {
                if (columnsKeys.Contains(ugc.Key.ToString()))
                {
                    ugc.CellAppearance.TextHAlign = Infragistics.Win.HAlign.Right;
                }

            }
        }
        /// <summary>
        /// 设置列显示位数
        /// </summary>
        /// <param name="ug"></param>
        /// <param name="arr"></param>
        public static void setUltraGridColumnMaxInput(UltraGrid ug, string[] arr)
        {
            if (ug == null || arr == null || arr.Length == 0)
            {
                return;
            }
            arr.ToArray();
            foreach (UltraGridColumn ugc in ug.DisplayLayout.Bands[0].Columns)
            {
                if (arr.Contains(ugc.Key.ToString()))
                {
                    ugc.MaskDisplayMode = MaskMode.IncludeLiterals;
                    ugc.MaskInput = "{LOC}n,nnn,nnn.nnn";

                }
            }
        }
        /// <summary>
        /// 设置列显示位数
        /// </summary>
        /// <param name="ug"></param>
        /// <param name="arr"></param>
        public static void setUltraGridColumnCountInput(UltraGrid ug, string[] arr)
        {
            if (ug == null || arr == null || arr.Length == 0)
            {
                return;
            }
            arr.ToArray();
            foreach (UltraGridColumn ugc in ug.DisplayLayout.Bands[0].Columns)
            {
                if (arr.Contains(ugc.Key.ToString()))
                {
                    ugc.MaskDisplayMode = MaskMode.IncludeLiterals;
                    ugc.MaskInput = "{LOC}nnn,nnn,nnn";

                }
            }
        }
        /// <summary>
        /// 列求和
        /// </summary>
        /// <param name="ug">UltraGrid</param>
        /// <param name="columnKeys">列数组</param>
        public static void GridColumnSum(UltraGrid ug, string[] columnKeys)
        {
            if (columnKeys.Length == 0)
            {
                return;
            }
            for (int i = 0; i < columnKeys.Length; i++)
            {
                SummarySettings summary = ug.DisplayLayout.Bands[0].Summaries.Add(SummaryType.Sum, ug.DisplayLayout.Bands[0].Columns[columnKeys[i]], SummaryPosition.UseSummaryPositionColumn);
                summary.DisplayFormat = "{0}";
                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
            }
        }
        /// <summary>
        /// 列求和重量
        /// </summary>
        /// <param name="ug">UltraGrid</param>
        /// <param name="columnKeys">列数组(重量)</param>
        public static void GridColumnWeghit(UltraGrid ug, string[] columnKeys)
        {
            if (columnKeys.Length == 0)
            {
                return;
            }
            for (int i = 0; i < columnKeys.Length; i++)
            {
                SummarySettings summary = ug.DisplayLayout.Bands[0].Summaries.Add(SummaryType.Sum, ug.DisplayLayout.Bands[0].Columns[columnKeys[i]], SummaryPosition.UseSummaryPositionColumn);
                summary.DisplayFormat = "{0:N3}";
                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
            }
        }
        /// <summary>
        /// UltraGrid可读
        /// </summary>
        /// <param name="ugr">UltraGrid</param>
        /// <param name="keys">可编辑列</param>
        public static void setOtherColumnReadOnly(UltraGrid ugr, string[] keys)
        {
            keys.ToArray();
            foreach (UltraGridColumn ugc in ugr.DisplayLayout.Bands[0].Columns)
            {
                if (!keys.Contains(ugc.Key))
                {
                    ugc.CellActivation = Activation.ActivateOnly;
                }


            }
        }

        /// <summary>
        /// 销售组织权限
        /// </summary>
        /// <param name="validDataPurviewIds">数据权限</param>
        /// <param name="ob"></param>
        /// <returns>字符串数组</returns>
        public static string[] InitPermissions(string[] validDataPurviewIds, OpeBase ob)
        {
            string[] arr = null;
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.WarehousePermissions.getSalgPermissions", new object[] { validDataPurviewIds }, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                arr = new string[dt.Rows.Count];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    arr[i] = dt.Rows[i][0].ToString();
                }
            }
            return arr;
        }

        /// <summary>
        /// 设置UltraComboEditor中的中文和非中文统一高度。
        /// </summary>
        /// <param name="cmb"></param>
        public static void SetComboItemHeight(UltraComboEditor cmb)
        {
            foreach (ValueListItem item in cmb.Items)
            {
                if (Regex.IsMatch(item.DisplayText, @"[\u4e00-\u9fa5]+"))
                {
                    item.Appearance.FontData.SizeInPoints = 9.0F;
                }
                else
                {
                    item.Appearance.FontData.SizeInPoints = 10.5F;
                }
            }
        }

    }
}