MES_Client/TGMES/Core.StlMes.Client.Mcp.Control/Common/comm.cs

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

namespace Core.StlMes.Client.Mcp.Control.Common
{
   public  class commHelper
    {

        /// <summary>
        /// 绑定combobox
        /// </summary>
        /// <param name="cmbx">控件名</param>
        /// <param name="dset">数据源ds</param>
        /// <param name="strVal">值</param>
        /// <param name="strName">显示名</param>
        /// <param name="filCondition">筛选条件</param>
        /// <param name="tips">是否新增</param>
        /// <param name="addItem">新增itemName</param>
        public static void FilComboboxAdd(UltraComboEditor cmbx, DataTable dt, string strVal, string strName, string filCondition, Boolean tips, String addItemName, String addItemValue)
        {
            if (dt.Columns.Count > 1)
            {
                DataView dvw = dt.DefaultView;
                //dvw.RowFilter = filCondition;
                ArrayList aryTmp = new ArrayList();
                if (tips == true)
                {
                    aryTmp.Add(new ValueListItem(addItemValue, addItemName));
                }
                for (int i = 0; i < dvw.Count; i++)
                {
                    aryTmp.Add(new ValueListItem(dvw[i][strVal].ToString(), dvw[i][strName].ToString()));
                }
                cmbx.DataSource = aryTmp;
                cmbx.DisplayMember = "DisplayText";
                cmbx.ValueMember = "DataValue";
            }
        }

        /// <summary>
        /// 激活输入当前值行数据
        /// </summary>
        /// <param name="ug">ultragrid</param>
        /// <param name="strColumn">列名</param>
        /// <param name="strKey">列值</param>
        public static string doActiveSelRow(UltraGrid ug, string strColumn, string strKey)
        {
            try
            {
                if (strKey != "")
                {
                    foreach (UltraGridRow row in ug.Rows)
                    {
                        if (row.Cells[strColumn].Text.ToString() == strKey)
                        {
                            row.Activated = true;
                            if (row.ChildBands != null)
                                row.Expanded = true;
                        }
                    }
                }
                return "";
            }
            catch (Exception ex)
            {
                return ex.ToString();
            }
        }

        /// <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;
                }
            }
        }

        /// <summary>
        /// 获取产线
        /// </summary>
        /// <param name="arr1"></param>
        /// <returns></returns>
        public static string[] GetPlineCode(string[] arr1,OpeBase ob)
        {
            string[] arr = null;
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmComm.getPlineCode", new Object[] { arr1 }, 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;
            }
            else
            {
                return new string[1] { "" };
            }

        }

        /// <summary>
        /// 获取产线
        /// </summary>
        /// <param name="arr1"></param>
        /// <returns></returns>
        public static string[] GetPlineCode(string[] arr1,string ProcessCode, OpeBase ob)
        {
            string[] arr = null;
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmComm.getPlineCode", new Object[] { arr1, ProcessCode }, 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;
            }
            else
            {
                return new string[1] { "" };
            }

        }

        public static string[] InitDropPlinePower(string processCode, UltraComboEditor ugc, string[] validDataPurviewIds, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmComm.getPlineCode", new object[] {validDataPurviewIds, processCode }, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                ugc.DataSource = dt;
                ugc.ValueMember = "PLINE_CODE";
                ugc.DisplayMember = "PLINE_NAME";
                string[] plineArr = new string[dt.Rows.Count];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    plineArr[i] = dt.Rows[i]["PLINE_CODE"].ToString();
                }
                return plineArr;
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// 刷新Grid数据并根据数据调整Grid列宽
        /// </summary>
        /// <param name="ultraGrid">需要处理的Grid</param>
        public static void RefreshAndAutoSize(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid,int Band=-1)
        {
            try
            {
                
               
                ultraGrid.DataBind();
 ultraGrid.UpdateData();
 ultraGrid.Refresh();

                if (Band > 0)
                {
                    foreach (
                        Infragistics.Win.UltraWinGrid.UltraGridColumn column in
                        ultraGrid.DisplayLayout.Bands[Band].Columns)
                    {
                        column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand, true);
                    }
                }
                else
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
                    {
                        foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns)
                        {
                            column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand,
                                true);
                        }
                    }
                }

                ultraGrid.Refresh();
            }
            catch { }
        }

        /// <summary>
        /// 刷新Grid数据并根据数据调整Grid列宽
        /// </summary>
        /// <param name="ultraGrid">需要处理的Grid</param>
        /// <param name="cols">不需要调整列宽的列</param>
        public static void RefreshAndAutoSizeExceptColumns(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid, params string[] columns)
        {
            try
            {
                ultraGrid.DataBind();
                foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns)
                    {
                        if (columns != null && columns.Contains(column.Key))
                        {
                            continue;
                        }
                        column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                    }
                }
                ultraGrid.Refresh();
            }
            catch { }
        }

        /// <summary>
        /// UltraGrid可读(非主从结构)
        /// </summary>
        /// <param name="ugr">UltraGrid</param>
        /// <param name="keys">可编辑列</param>
        public static void setOtherColumnReadOnly(UltraGrid ugr, string[] keys, int BandInt=0)
        {
            if (keys == null || keys.Length == 0)
            {
                foreach (UltraGridColumn ugc in ugr.DisplayLayout.Bands[BandInt].Columns)
                {
                    ugc.CellActivation = Activation.ActivateOnly;
                }
            }
            else
            {
                keys.ToArray();
                foreach (UltraGridColumn ugc in ugr.DisplayLayout.Bands[BandInt].Columns)
                {
                    if (!keys.Contains(ugc.Key))
                    {
                        ugc.CellActivation = Activation.ActivateOnly;
                    }
                }
            }

        }
    }
}