/// <summary> /// Only support the ComboBox control from WinForm/Visual WebGUI /// </summary> /// <param name="ddList">the ComboBox control from WinForm/Visual WebGUI</param> /// <param name="TextField">e.g. new string[]{"FieldName1", "FieldName2", ...}</param> /// <param name="TextFormatString">e.g. "{0} - {1}"</param> /// <param name="SwitchLocale">Can be localized, if the FieldName has locale suffix, e.g. '_chs'</param> /// <param name="BlankLine">add blank label text to ComboBox or not</param> /// <param name="BlankLineText">the blank label text</param> /// <param name="ParentFilter">e.g. "ForeignFieldName = 'value'"</param> /// <param name="WhereClause">Where Clause for SQL Statement. e.g. "FieldName = 'SomeCondition'"</param> /// <param name="OrderBy">Sorting order, string array, e.g. {"FieldName1", "FiledName2"}</param> public static void LoadCombo(ref ComboBox ddList, string [] TextField, string TextFormatString, bool SwitchLocale, bool BlankLine, string BlankLineText, string ParentFilter, string WhereClause, string[] OrderBy) { if (SwitchLocale) { TextField = GetSwitchLocale(TextField); } ddList.Items.Clear(); SmartTag4WorkplaceCollection source; if (OrderBy == null || OrderBy.Length == 0) { OrderBy = TextField; } if (WhereClause.Length > 0) { source = SmartTag4Workplace.LoadCollection(WhereClause, OrderBy, true); } else { source = SmartTag4Workplace.LoadCollection(OrderBy, true); } Common.ComboList sourceList = new Common.ComboList(); if (BlankLine) { sourceList.Add(new Common.ComboItem(BlankLineText, Guid.Empty)); } foreach (SmartTag4Workplace item in source) { bool filter = false; if (ParentFilter.Trim() != String.Empty) { filter = IgnorThis(item, ParentFilter); } if (!(filter)) { string code = GetFormatedText(item, TextField, TextFormatString); sourceList.Add(new Common.ComboItem(code, item.TagId)); } } ddList.DataSource = sourceList; ddList.DisplayMember = "Code"; ddList.ValueMember = "Id"; if (ddList.Items.Count > 0) { ddList.SelectedIndex = 0; } }