MES_Client/TGMES/Core.StlMes.Client.Mcp/Common/BaseHelper.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinMaskedEdit;
using Infragistics.Win;
using System.Collections;
using System.Text.RegularExpressions;
using System.ComponentModel;
using System.Runtime.CompilerServices;
using System.Windows.Forms;

namespace Core.StlMes.Client.Mcp.BaseMethod
{
    public class BaseHelper
    {
        /// <summary>
        /// 仓库数据权限(用于报表)
        /// </summary>
        /// <param name="customInfo">页面配制信息(自定义参数)</param>
        /// <param name="validDataPurviewIds">用户数据权限</param>
        /// <returns>可查看仓库组成的字符串</returns>
        public static string[] WarehousePermissionsStore1(String[] validDataPurviewIds, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.CollarLibrary.FrmCollarOutBound.getWarehousePermissionsStore", new object[] { validDataPurviewIds }, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                string[] storages = new string[dt.Rows.Count];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    storages[i] = dt.Rows[i]["STORAGE_NO"].ToString();
                }
                return storages;
            }
            else
            {
                return new string[1] { "" };
            }
        }

        /// <summary>
        /// 通过科室查找对应的部门
        /// </summary>
        /// <param name="sectionName">科室ID</param>
        /// <param name="ob"></param>
        /// <returns>部门名称</returns>
        public static string GetDepartBySectionId1(string sectionId, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.CollarLibrary.FrmCollarOutBound.getDeptBySection", new object[] { sectionId }, ob);
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0]["DEPARTNAME"].ToString();
            }
            else
            {
                return "";
            }
        }

        /// <summary>
        /// 通过科室查找对应的部门
        /// </summary>
        /// <param name="sectionName">科室ID</param>
        /// <param name="ob"></param>
        /// <returns>部门ID</returns>
        public static string GetDepartIdBySectionId1(string sectionId, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.CollarLibrary.FrmCollarOutBound.getDeptBySection", new object[] { sectionId }, ob);
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0]["DEPARTID"].ToString();
            }
            else
            {
                return "";
            }
        }
        

        public static string[] SetData(string methodId, object[] param, OpeBase ob)
        {
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = methodId.Substring(0, methodId.LastIndexOf("."));
            ccp.MethodName = methodId.Substring(methodId.LastIndexOf(".") + 1);
            ccp.ServerParams = param;
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode == -1)
            {
                return null;
            }
            else
            {
                string[] strArray = new string[2];
                strArray[0] = ccp.ReturnObject.ToString();
                strArray[1] = ccp.ReturnInfo;
                return strArray;
            }
        }

        /// <summary>
        /// 设置Grid统计格式
        /// 
        /// </summary>
        /// <param name="Arrsumtype"></param>统计格式集合
        /// <param name="HeadeVale"></param>显示格式
        /// <param name="ColumName"></param>列名
        /// <param name="band"></param>
        /// <param name="areas"></param>位置
        public static void SetupSummaryHeade(string[] Arrsumtype, string[] HeadeVale, string[] ColumName, UltraGridBand band, SummaryDisplayAreas areas)
        {
            if (HeadeVale.Length != Arrsumtype.Length && Arrsumtype.Length != ColumName.Length)
            {
                return;
            }
            SummaryType sumType; ;
            for (int i = 0; i < HeadeVale.Length; i++)
            {
                //SummaryType.Count 统计 Average平均值 Maximum最大值 Minimum 最小值  Sum 求和
                if (Arrsumtype[i] == "Count")
                {
                    sumType = SummaryType.Count;
                }
                else if (Arrsumtype[i] == "Maximum")
                {
                    sumType = SummaryType.Maximum;
                }
                else if (Arrsumtype[i] == "Minimum")
                {
                    sumType = SummaryType.Minimum;
                }
                else
                {
                    sumType = SummaryType.Sum;
                }
                if (band.Columns.Exists(ColumName[i]))
                {
                    SummarySettings summary = band.Summaries.Add(sumType, band.Columns[ColumName[i]]);
                    summary.SummaryDisplayArea = areas;
                    summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                    summary.DisplayFormat = HeadeVale[i];
                    summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
                    summary.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
                    //summary.Appearance.ForeColor = Color.Black;
                    //summary.Appearance.BackColor = Color.FromArgb(248, 253, 180);
                }
            }
            Infragistics.Win.Appearance appearance21 = new Infragistics.Win.Appearance();
            Infragistics.Win.Appearance appearance20 = new Infragistics.Win.Appearance();
            appearance20.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192)))));
            band.Override.SummaryFooterAppearance = appearance20;
            appearance21.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192)))));
            appearance21.TextHAlignAsString = "Right";
            band.Override.SummaryValueAppearance = appearance21;
        }
        /// <summary>
        /// 查询选择记录
        /// </summary>
        /// <typeparam name="T">类名</typeparam>
        /// <param name="ug">Grid</param>
        /// <param name="columns">列</param>
        /// <param name="value">对应值</param>
        /// <returns></returns>
        public static ArrayList GetRows<T>(UltraGrid ug, string columns, string value)
        {
            try { ug.UpdateData(); }
            catch (Exception) { return null; }
            IQueryable<UltraGridRow> chcRows = ug.Rows.AsQueryable().Where(a => a.GetValue(columns) == value);
            if (chcRows == null || chcRows.Count() == 0)
            {
                return null;
            }
            ArrayList list = new ArrayList();
            foreach (UltraGridRow ugr in chcRows)
            {
                T t = (T)ugr.ListObject;
                list.Add(t);
            }
            return list;
        }

        /// <summary>
        /// 控制行
        /// </summary>
        /// <param name="row"></param>
        public static void ControlCellEdit(UltraGridRow row)
        {
            foreach (UltraGridCell cell in row.Cells)
            {
                if (cell.Column.CellAppearance.BackColor == Color.FromArgb(255, 255, 128))
                {
                    if (row.Cells["CHC"].Value.ToString() == "True")
                    {
                        cell.Activation = Activation.AllowEdit;
                    }
                    else
                    {
                        cell.Activation = Activation.ActivateOnly;
                    }
                }
                else
                {
                    if (!cell.Column.Key.Equals("CHC"))
                    {
                        cell.Activation = Activation.ActivateOnly;
                    }
                }
            }
        }

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

        }

        /// <summary>
        /// UltraGrid可读(主从结构)
        /// </summary>
        /// <param name="ugr"></param>
        /// <param name="keys"></param>
        public static void setColumnReadOnly(UltraGrid ugr, string[] keys)
        {
            keys.ToArray();
            foreach (UltraGridColumn ugc in ugr.DisplayLayout.Bands[0].Columns)
            {
                if (!keys.Contains(ugc.Key))
                {
                    ugc.CellActivation = Activation.ActivateOnly;
                }
            }
            foreach (UltraGridColumn ugc in ugr.DisplayLayout.Bands[1].Columns)
            {
                if (!keys.Contains(ugc.Key))
                {
                    ugc.CellActivation = Activation.ActivateOnly;
                }
            }
        }

        /// <summary>
        /// 设置列背景颜色
        /// </summary>
        /// <param name="ugr">UltraGrid</param>
        /// <param name="columns">列数组</param>
        public static void setColumnBackColor(UltraGrid ugr, String[] columns)
        {
            for (int i = 0; i < columns.Length; i++)
            {
                ugr.DisplayLayout.Bands[0].Columns[columns[i]].CellAppearance.BackColor = Color.FromArgb(255, 255, 128);
            }
        }


        /// <summary>
        /// 设置列字段显示位置在右
        /// </summary>
        /// <param name="ug">UltraGrid</param>
        /// <param name="columnsKeys">要设置的列</param>
        public static void InitCellPosition(UltraGrid ug, string[] columnsKeys)
        {
            if (columnsKeys == null || columnsKeys.Length == 0)
            {
                return;
            }
            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">UltraGrid从表</param>
        /// <param name="columnsKeys">要设置的列</param>
        public static void InitCellPositionC(UltraGrid ug, string[] columnsKeys)
        {
            columnsKeys.ToArray();
            foreach (UltraGridColumn ugc in ug.DisplayLayout.Bands[1].Columns)
            {
                if (columnsKeys.Contains(ugc.Key.ToString()))
                {
                    ugc.CellAppearance.TextHAlign = Infragistics.Win.HAlign.Right;
                }

            }
        }

        /// <summary>
        /// 列求和
        /// </summary>
        /// <param name="ug">UltraGrid</param>
        /// <param name="columnKeys">列数组</param>
        public static void GridColumnSum(UltraGrid ug, string[] columnKeys, string[] descritions)
        {
            if (columnKeys.Length == 0 || descritions.Length != columnKeys.Length)
            {
                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}" + descritions[i];
                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
            }
        }

        /// <summary>
        ///  列求和
        /// </summary>
        /// <param name="ug"></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:N3}";
                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
            }
        }/// <summary>
        /// 列求和
        /// </summary>
        /// <param name="ug">UltraGrid</param>
        /// <param name="columnKeys">列数组（支）</param>
        public static void GridColumnCount(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:N0}";
                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
            }
        }

        /// <summary>
        /// 设置UltraGrid行颜色
        /// </summary>
        /// <param name="ug">UltraGrid</param>
        /// <param name="columnKeys">列</param>
        /// <param name="values">值</param>
        /// <param name="color">颜色</param>
        public static void SetUltraGridRowColor(UltraGrid ug, string[] columnKeys, string[] values, Color color)
        {
            if (ug.Rows.Count == 0 || columnKeys.Length == 0 || values.Length == 0 || color == null || values.Length != columnKeys.Length)
            {
                return;
            }
            foreach (UltraGridRow ugr in ug.Rows)
            {
                Boolean flag = true;
                for (int i = 0; i < columnKeys.Length; i++)
                {
                    if (!ugr.Cells[columnKeys[i]].Value.ToString().Equals(values[i]))
                    {
                        flag = false;
                    }

                }
                if (flag)
                {
                    ugr.Appearance.BackColor = color;
                }
            }
        }

        /// <summary>
        /// 合并单元格
        /// </summary>
        /// <param name="ug"></param>
        /// <param name="columnKeys"></param>
        public static void MergedCell(UltraGrid ug, string[] columnKeys)
        {
            if (columnKeys.Length == 0)
            {
                return;
            }
            ug.DisplayLayout.Override.MergedCellStyle = MergedCellStyle.Never;
            for (int i = 0; i < columnKeys.Length; i++)
            {
                ug.DisplayLayout.Bands[0].Columns[columnKeys[i]].MergedCellStyle = MergedCellStyle.Always;
            }
        }

        /// <summary>
        /// 设置ULTRAGIRD列的颜色
        /// </summary>
        /// <param name="ug">ultragrid</param>
        /// <param name="arr">列Key</param>
        /// <param name="color">颜色</param>
        public static void setUltraGridColumnColor(UltraGrid ug, string[] arr, Color color)
        {
            if (arr == null || arr.Length == 0 || ug == null)
            {
                return;
            }
            arr.ToArray();
            foreach (UltraGridColumn ugc in ug.DisplayLayout.Bands[0].Columns)
            {
                if (arr.Contains(ugc.Key.ToString()))
                {
                    ugc.CellAppearance.BackColor = color;

                }
            }
        }

        /// <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 setUltraGridColumnBits(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}-nn,nnn,nnn";

                }
            }
        }


        /// <summary>
        /// 列绑定下拉框
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="column">列名</param>
        /// <param name="column">行</param>
        public static void BindColumn(UltraComboEditor uce, string column, UltraGridBand ugb)
        {
            ugb.Columns[column].EditorComponent = uce;
            ugb.Columns[column].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
        }

        /// <summary>
        /// 初始化下拉框
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="methodID">方法名</param>
        /// <param name="showValue">显示值</param>
        /// <param name="hiddenValue">隐藏值</param>
        /// <param name="isNull">是否增加空行</param>
        /// <param name="ob">OB对象</param>
        public static void NitializeDropDownBox(UltraComboEditor uce, string methodID, string showValue, string hiddenValue, Boolean isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData(methodID, new Object[] { }, ob);
            if (dt != null && dt.Rows.Count > 0 && isNull)
            {
                DataRow dr = dt.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    dr[i] = "";
                }
                dt.Rows.InsertAt(dr, 0);
            }
            uce.DataSource = dt;
            uce.DisplayMember = showValue;
            uce.ValueMember = hiddenValue;
            ClsBaseInfo.SetComboItemHeight(uce);
        }


        /// <summary>
        /// 初始化下拉框
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="methodID">方法名</param>
        /// <param name="methodID">参数</param>
        /// <param name="showValue">显示值</param>
        /// <param name="hiddenValue">隐藏值</param>
        /// <param name="isNull">是否增加空行</param>
        /// <param name="ob">OB对象</param>
        public static void NitializeDropDownBox(UltraComboEditor uce, string methodID, Object[] param, string showValue, string hiddenValue, Boolean isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData(methodID, param, ob);
            if (dt != null && dt.Rows.Count > 0 && isNull)
            {
                DataRow dr = dt.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    dr[i] = "";
                }
                dt.Rows.InsertAt(dr, 0);
            }
            uce.DropDownListWidth = -1;
            uce.DropDownStyle = DropDownStyle.DropDownList;
            uce.DataSource = dt;
            uce.DisplayMember = showValue;
            uce.ValueMember = hiddenValue;
            ClsBaseInfo.SetComboItemHeight(uce);
        }








        private Object setObjectByDataRow(Object obj, DataRow dr)
        {
            System.Reflection.PropertyInfo[] properties = obj.GetType().GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public);
            foreach (System.Reflection.PropertyInfo item in properties)
            {
                string name = item.Name;
                string value = item.GetValue(obj, null).ToString();
                for (int i = 0; i < dr.Table.Columns.Count; i++)
                {
                    if (dr.Table.Columns[i].ColumnName.ToString().Equals(name))
                    {
                        item.SetValue(obj, dr[i].ToString(), null);
                    }
                }
            }
            return obj;
        }

        private Object setObjectByDataTable(Object obj, DataTable dt)
        {
            System.Reflection.PropertyInfo[] properties = obj.GetType().GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public);
            foreach (System.Reflection.PropertyInfo item in properties)
            {
                string name = item.Name;
                string value = item.GetValue(obj, null).ToString();
                foreach (DataRow dr in dt.Rows)
                {
                    {
                        if (dr[0].ToString().Equals(name))
                            item.SetValue(obj, dr[1].ToString(), null);
                    }
                }
            }
            return obj;
        }

        /// <summary>
        /// 禁止排序
        /// </summary>
        /// <param name="ugr"></param>
        public static void ForbidSort(UltraGrid ugr)
        {
            foreach (UltraGridColumn ugc in ugr.DisplayLayout.Bands[0].Columns)
            {
                ugc.SortIndicator = SortIndicator.Disabled;
            }
        }
        /// <summary>
        /// 用于初始化F1功能加字段问题
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="frm"></param>
        /// <param name="ug"></param>
        public static void SetGridColunmName<T>(FrmBase frm, UltraGrid ug)
        {
            System.Threading.Thread.Sleep(3000);
            if (!frm.IsDisposed)
            {
                EntityHelper.ShowGridCaption<T>(ug.DisplayLayout.Bands[0]);
            }
        }

        /// <summary>
        /// 设置列居中
        /// </summary>
        /// <param name="ug"></param>
        /// <param name="columnsKeys"></param>
        public static void InitCellPositionMiddle(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.Center;
                }

            }
        }

        /// <summary>
        /// 激活行选中
        /// </summary>
        /// <param name="ug"></param>
        public static void SetRowChecked(UltraGrid ug)
        {
            foreach (UltraGridRow ugr in ug.Rows)
            {
                if (ugr.Activated)
                {
                    ugr.Cells["CHC"].Value = true;
                }
                else
                {
                    ugr.Cells["CHC"].Value = false;
                }
            }
        }

        /// <summary>
        /// 初始化下拉框（增强型）
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="methodId">请求的服务</param>
        /// <param name="valueMember">值成员</param>
        /// <param name="textMember">显示成员</param>
        /// <param name="ob">ob对象</param>
        /// <param name="isEmpty">是否添加空行</param>
        public static void InitComboEditorNew(UltraComboEditor uce, string methodId, string valueMember, string textMember, OpeBase ob, bool isEmpty)
        {
            InitComboEditor(uce, methodId, valueMember, ob, isEmpty);
            uce.DisplayMember = textMember;
        }

        /// <summary>
        /// 初始化下拉框
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="methodId">请求的服务</param>
        /// <param name="valueMember">值成员</param>
        /// <param name="ob">ob对象</param>
        /// <param name="isEmpty">是否有空行</param>
        public static void InitComboEditor(UltraComboEditor uce, string methodId, string valueMember, OpeBase ob, bool isEmpty)
        {
            DataTable dt = ServerHelper.GetData(methodId, null, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (isEmpty)
                {
                    Object[] obj = new Object[] { "", "" };
                    DataRow dr = dt.NewRow();
                    dr.ItemArray = obj;
                    dt.Rows.InsertAt(dr, 0);
                }
                uce.DataSource = dt;
                uce.ValueMember = valueMember;
                SetComboItemHeight(uce);
            }
        }
        /// <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>
        /// 将下拉框绑定到GRID列
        /// </summary>
        /// <param name="uce">下拉框（已经初始化完成）</param>
        /// <param name="ColumnName">列名</param>
        /// <param name="con">空间集合（每次只需填入this.Controls）</param>
        /// <param name="ug">GRID</param>
        /// <param name="i">GRID的第几层结构</param>
        public static void BindColumn(UltraComboEditor uce, string ColumnName, System.Windows.Forms.Control.ControlCollection con, UltraGrid ug, int i)
        {
            con.Add(uce);
            uce.Visible = false;
            ug.DisplayLayout.Bands[i].Columns[ColumnName].EditorComponent = uce;
            ug.DisplayLayout.Bands[i].Columns[ColumnName].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDown;
            SetComboItemHeight(uce);
        }

        ///接箍编辑区显示支数
        public static string piecesJg(string woidId,string[] plinCode,OpeBase ob)
        {
            string piece = "";
            try
            {
                DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.BaseHelper.doQueryPiece", new Object[] { woidId,plinCode }, ob);
                {
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        piece = dt.Rows[0]["FAIL"].ToString();
                    }
                }
                return piece;
            }
            catch (Exception ex)
            {
                return ex.ToString();
            }
            
        }

        /// <summary>
        ///  设置Grid可拖拽行, 设置拖拽前提条件,拖拽后的操作
        /// </summary>
        /// <param name="ug">待设置的Grid</param>
        /// <param name="action">拖拽后需要实现的业务</param>
        public static void SetGridDragDropRows(UltraGrid ug, Action<SelectedRowsCollection, int> action, Cursor myCursor)
        {
            ug.AllowDrop = true;
            ug.SelectionDrag += (sender, args) => { if (ug.Selected.Rows.Count > 0)  ug.DoDragDrop(ug.Selected.Rows, DragDropEffects.Move); };
            ug.GiveFeedback += (sender, args) =>
            {
                //Cursor myCursor = new Cursor();
                //ug.Cursor = Cursors.Hand;
                args.UseDefaultCursors = false;
                ug.Cursor = myCursor;

            };

            ug.DragOver += (sender, args) =>
            {
                args.Effect = DragDropEffects.Move;
                UltraGrid grid = sender as UltraGrid;
                Point pointInGridCoords = grid.PointToClient(new Point(args.X, args.Y + 10));

                UIElement uieOver = ug.DisplayLayout.UIElement.ElementFromPoint(ug.PointToClient(new Point(args.X, args.Y + 10)));
                if (uieOver != null)
                {
                    UltraGridRow ugrOver = uieOver.GetContext(typeof(UltraGridRow), true) as UltraGridRow;
                    if (ugrOver != null) ug.ActiveRow = ugrOver;
                }

                if (pointInGridCoords.Y < 30)
                    // 当拖动行到当前视图顶端,滑轮自动向上滚动.
                    ug.ActiveRowScrollRegion.Scroll(RowScrollAction.LineUp);
                else if (pointInGridCoords.Y > grid.Height - 30)
                    // 当拖动行到当前视图尾端,滑轮自动向下滚动.
                    ug.ActiveRowScrollRegion.Scroll(RowScrollAction.LineDown);
            };
            ug.DragDrop += (sender, args) =>
            {
                ug.Cursor = Cursors.Default;

                UIElement uieOver = ug.DisplayLayout.UIElement.ElementFromPoint(ug.PointToClient(new Point(args.X, args.Y + 10)));
                UltraGridRow ugrOver = uieOver.GetContext(typeof(UltraGridRow), true) as UltraGridRow;
                if (ugrOver != null)
                {


                    var dropIndex = ugrOver.HasParent() ? ugrOver.ParentRow.Index : ugrOver.Index;

                    SelectedRowsCollection SelRows = args.Data.GetData(typeof(SelectedRowsCollection)) as SelectedRowsCollection;

                    if (action != null)
                    {
                        action(SelRows, dropIndex);
                    }
                    else
                    {
                        foreach (UltraGridRow aRow in SelRows)
                        {
                            ug.Rows.Move(aRow, dropIndex);
                        }
                    }

                }

            };

        }

        /// <summary>
        /// 合并单元格统计
        /// </summary>
        public static void SetGroupBySum(UltraGrid ug, string[] columnKeys, string groupBy)
        {
            if (columnKeys.Length == 0)
            {
                return;
            }
            for (int i = 0; i < columnKeys.Length; i++)
            {
                SummarySettings summary = ug.DisplayLayout.Bands[0].Summaries.Add(
                               columnKeys[i],
                               SummaryType.Custom,
                               new StringSummaryCalculator(groupBy),     // Custom summary calculator
                               ug.DisplayLayout.Bands[0].Columns[columnKeys[i]],
                               SummaryPosition.UseSummaryPositionColumn, null);
                summary.DisplayFormat = "{0:N3}";
                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
            }
        }
    }
    class StringSummaryCalculator : ICustomSummaryCalculator
    {
        private string _summaryText = "";
        private string groupby = "";

        internal StringSummaryCalculator(string GroupBy)
        {
            groupby = GroupBy;
        }

        public void AggregateCustomSummary(SummarySettings summarySettings, UltraGridRow row)
        {
        }
        public void BeginCustomSummary(SummarySettings summarySettings, RowsCollection rowCollection)
        {


            string key = summarySettings.Key;

            var list = rowCollection.GroupBy(p => p.Cells[groupby].Value.ToString()).Select(p => p.LastOrDefault()).ToList();
            _summaryText = list.Sum(p => double.Parse(p.Cells[key].Value.ToString())).ToString();
        }
        public object EndCustomSummary(SummarySettings summarySettings, RowsCollection rowCollection)
        {
            return this._summaryText;
        }
    }

}