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
{
///
/// ComboBox数据处理类
///
public class ComboBoxHelper
{
///
/// 初始化Combox数据
///
/// ComboBox控件
/// DataSet数据源
public static void FillComboxItems(ComboBox cmbx, DataSet dset)
{
if (dset != null && dset.Tables.Count > 0)
{
FillComboxItems(cmbx, dset.Tables[0], "");
}
}
///
/// 初始化Combox数据,加入数据筛选
///
/// ComboBox控件
/// DataSet数据源
/// RowFilter条件
public static void FillComboxItems(ComboBox cmbx, DataSet dset, string filterCondition)
{
if (dset != null && dset.Tables.Count > 0)
{
FillComboxItems(cmbx, dset.Tables[0], filterCondition);
}
}
///
/// 初始化Combox数据,加入数据筛选
///
/// ComboBox控件
/// DataTable
public static void FillComboxItems(ComboBox cmbx, DataTable dt)
{
FillComboxItems(cmbx, dt, "");
}
///
/// 初始化Combox数据,加入数据筛选
///
/// ComboBox控件
/// DataTable
/// RowFilter条件
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";
}
}
///
/// 初始化UltraCombo数据
///
/// ultraComboEditor控件
/// DataSet数据源
public static void FillUltraComboItems(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataSet dset)
{
if (dset != null && dset.Tables.Count > 0)
{
FillUltraComboItems(ulcme, dset.Tables[0], "");
}
}
///
/// 初始化UltraComboEditor数据
///
///
///
public static void FillUltraComboItems(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataTable dt)
{
FillUltraComboItems(ulcme, dt, "");
}
///
/// 初始化UltraCombo数据,加入数据筛选
///
/// ultraComboEditor控件
/// DataSet数据源
/// RowFilter条件
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);
}
}
///
/// 初始化UltraCombo数据,加入数据筛选
///
/// ultraComboEditor控件
/// DataTable
/// RowFilter条件
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());
}
}
///
/// 初始化UltraCombo数据,并添加“空”
///
/// ultraComboEditor控件
/// DataTable数据源
public static void FillUlcmItemsAddEmpty(Infragistics.Win.UltraWinEditors.UltraComboEditor ulcme, DataTable dt)
{
ulcme.Items.Add("", "");
FillUltraComboItems(ulcme, dt); ;
}
///
/// 初始化UltraCombo数据,并添加“空”;加入数据筛选
///
/// ultraComboEditor控件
/// DataTable数据源
/// RowFilter条件
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;
}
}
}
}