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