MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/钢管实验管理/comm.cs

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

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
   public  class comm
    {

        /// <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 (Infragistics.Win.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.lims.data.pipe.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[] GetPlineCodeWithOther(string[] arr1, OpeBase ob)
        {
            List<string> arr =  new List<string>();
            DataTable dt = ServerHelper.GetData("com.steering.lims.data.pipe.FrmComm.getPlineCode", new Object[] { arr1 }, ob);
           

            if (dt != null && dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    arr.Add(dt.Rows[i][0].ToString());
                }
            }
            else
            {

            }

            if (arr1.Contains("002001001"))
            {
                arr.Add("002001001");
            }

            if (arr1.Contains("002001004"))
            {
                arr.Add("100101");
            }

            if (arr1.Contains("002002"))
            {
                arr.Add("100102");
            }


            if (arr1.Contains("002001005"))
            {
                arr.Add("100103");
            }

            return arr.ToArray();

        }

        /// <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.lims.data.pipe.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[] InitDropPlinePowerW(UltraComboEditor ugc, string[] validDataPurviewIds, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.lims.data.pipe.FrmComm.getPlineCodeW", new object[] { validDataPurviewIds }, 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;
            }
        }

        public static string[] InitDropPlinePower(string processCode, UltraComboEditor ugc, string[] validDataPurviewIds, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.lims.data.pipe.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,string[] unSizeColumns=null)
        {
            try
            {
                ultraGrid.DataBind();

                foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns )
                    {
                        if (unSizeColumns==null || !unSizeColumns.Contains(column.Key))
                          column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                    }
                }

                ultraGrid.Refresh();
            }
            catch { }
        }

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

                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, IncludHeader);
                    }
                }

                ultraGrid.Refresh();
            }
            catch { }
        }

        /// <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>
        /// 得到服务器时间
        /// </summary>
        public static DateTime GetSeverTime(OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.lims.data.pipe.FrmComm.GetSeverTime", new object[] { }, ob);
            return DateTime.Parse(dt.Rows[0][0].ToString());
        }
    }
}