MES_Client/TGMES/Core.Mes.Client.Comm/Control/ComboBoxHelper.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.Mes.Client.Comm.Control
{
    /// <summary>
    /// ComboBox数据处理类
    /// </summary>
    public class ComboBoxHelper
    {
        /// <summary>
        /// 初始化Combox数据
        /// </summary>
        /// <param name="cmbx">ComboBox控件</param>
        /// <param name="dset">DataSet数据源</param>
        public static void FillComboxItems(ComboBox cmbx, DataSet dset)
        {
            if (dset != null && dset.Tables.Count > 0)
            {
                FillComboxItems(cmbx, dset.Tables[0], "");
            }
        }

        /// <summary>
        /// 初始化Combox数据,加入数据筛选
        /// </summary>
        /// <param name="cmbx">ComboBox控件</param>
        /// <param name="dset">DataSet数据源</param>
        /// <param name="filterCondition">RowFilter条件</param>
        public static void FillComboxItems(ComboBox cmbx, DataSet dset, string filterCondition)
        {
            if (dset != null && dset.Tables.Count > 0)
            {
                FillComboxItems(cmbx, dset.Tables[0], filterCondition);
            }
        }

        /// <summary>
        /// 初始化Combox数据,加入数据筛选
        /// </summary>
        /// <param name="cmbx">ComboBox控件</param>
        /// <param name="dt">DataTable</param>
        public static void FillComboxItems(ComboBox cmbx, DataTable dt)
        {
            FillComboxItems(cmbx, dt, "");
        }

        /// <summary>
        /// 初始化Combox数据,加入数据筛选
        /// </summary>
        /// <param name="cmbx">ComboBox控件</param>
        /// <param name="dt">DataTable</param>
        /// <param name="filterCondition">RowFilter条件</param>
        public static void FillComboxItems(ComboBox cmbx, DataTable dt, string filterCondition)
        {
            if (dt != null && dt.Rows.Count > 0)
            {
                DataView dvw = dt.DefaultView;
                dvw.RowFilter = filterCondition;
                ArrayList aryTmp = new ArrayList();
                for (int i = 0; i < dvw.Count; i++)
                {
                    aryTmp.Add(new ValueListItem(dvw[i][0].ToString(), dvw[i][1].ToString()));
                }
                cmbx.DataSource = aryTmp;
                cmbx.DisplayMember = "Name";
                cmbx.ValueMember = "ID";
            }
        }

        /// <summary>
        /// 初始化UltraCombo数据
        /// </summary>
        /// <param name="ulcme">ultraComboEditor控件</param>
        /// <param name="dset">DataSet数据源</param>
        public static void FillUltraComboItems(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataSet dset)
        {
            if (dset != null && dset.Tables.Count > 0)
            {
                FillUltraComboItems(ulcme, dset.Tables[0], "");
            }
        }

        /// <summary>
        /// 初始化UltraComboEditor数据
        /// </summary>
        /// <param name="ulcme"></param>
        /// <param name="dt"></param>
        public static void FillUltraComboItems(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataTable dt)
        {
            FillUltraComboItems(ulcme, dt, "");
        }

        /// <summary>
        /// 初始化UltraCombo数据,加入数据筛选
        /// </summary>
        /// <param name="ulcme">ultraComboEditor控件</param>
        /// <param name="dset">DataSet数据源</param>
        /// <param name="filterCondition">RowFilter条件</param>
        public static void FillUltraComboItems(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataSet dset, string filterCondition)
        {
            if (dset != null && dset.Tables.Count > 0)
            {
                FillUltraComboItems(ulcme, dset.Tables[0], filterCondition);
            }
        }

        /// <summary>
        /// 初始化UltraCombo数据,加入数据筛选
        /// </summary>
        /// <param name="ulcme">ultraComboEditor控件</param>
        /// <param name="dt">DataTable</param>
        /// <param name="filterCondition">RowFilter条件</param>
        public static void FillUltraComboItems(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataTable dt, string filterCondition)
        {
            if (dt != null && dt.Rows.Count > 0)
            {
                DataView dvw = dt.DefaultView;
                dvw.RowFilter = filterCondition;
                for (int i = 0; i < dvw.Count; i++)
                    ulcme.Items.Add(dvw[i][0].ToString(), dvw[i][1].ToString());
            }
        }

        /// <summary>
        /// 初始化UltraCombo数据,并添加“空”
        /// </summary>
        /// <param name="ulcme">ultraComboEditor控件</param>
        /// <param name="dt">DataTable数据源</param>
        public static void FillUlcmItemsAddEmpty(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataTable dt)
        {
            ulcme.Items.Add("", "");
            FillUltraComboItems(ulcme, dt); ;
        }

        /// <summary>
        /// 初始化UltraCombo数据,并添加“空”;加入数据筛选
        /// </summary>
        /// <param name="ulcme">ultraComboEditor控件</param>
        /// <param name="dt">DataTable数据源</param>
        /// <param name="filterCondition">RowFilter条件</param>
        public static void FillUlcmItemsAddEmpty(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataTable dt, string filterCondition)
        {
            ulcme.Items.Add("", "");
            FillUltraComboItems(ulcme, dt, filterCondition);
        }

        class ValueListItem
        {
            string _id = "";
            string _name = "";

            public string ID
            {
                get { return _id; }
                set { _id = value; }
            }

            public string Name
            {
                get { return _name; }
                set { _name = value; }
            }

            public ValueListItem(string sID, string sName)
            {
                _id = sID;
                _name = sName;
            }

            public override string ToString()
            {
                return _name;
            }
        }
    }
}