/// <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(); SupplierContactCollection source; if (OrderBy == null || OrderBy.Length == 0) { OrderBy = TextField; } if (WhereClause.Length > 0) { source = SupplierContact.LoadCollection(WhereClause, OrderBy, true); } else { source = SupplierContact.LoadCollection(OrderBy, true); } Common.ComboList sourceList = new Common.ComboList(); if (BlankLine) { sourceList.Add(new Common.ComboItem(BlankLineText, Guid.Empty)); } foreach (SupplierContact item in source) { bool filter = false; if (ParentFilter.Trim() != String.Empty) { filter = true; if (item.SupplierId != Guid.Empty) { filter = IgnorThis(item, ParentFilter); } } if (!(filter)) { string code = GetFormatedText(item, TextField, TextFormatString); sourceList.Add(new Common.ComboItem(code, item.ContactId)); } } ddList.DataSource = sourceList; ddList.DisplayMember = "Code"; ddList.ValueMember = "Id"; if (ddList.Items.Count > 0) { ddList.SelectedIndex = 0; } }
private static string GetFormatedText(SupplierContact target, string [] textField, string textFormatString) { for (int i = 0; i < textField.Length; i++) { PropertyInfo pi = target.GetType().GetProperty(textField[i]); textFormatString = textFormatString.Replace("{" + i.ToString() + "}", pi != null ? pi.GetValue(target, null).ToString() : string.Empty); } return(textFormatString); }
/// <summary> /// Loads a collection of SupplierContact objects from the database. /// </summary> /// <returns>A collection containing all of the SupplierContact objects in the database.</returns> public static SupplierContactCollection LoadCollection(string spName, SqlParameter[] parms) { SupplierContactCollection result = new SupplierContactCollection(); using (SqlDataReader reader = SqlHelper.Default.ExecuteReader(spName, parms)) { while (reader.Read()) { SupplierContact tmp = new SupplierContact(); tmp.LoadFromReader(reader); result.Add(tmp); } } return(result); }
/// <summary> /// Loads a SupplierContact object from the database using the given ContactId /// </summary> /// <param name="contactId">The primary key value</param> /// <returns>A SupplierContact object</returns> public static SupplierContact Load(Guid contactId) { SqlParameter[] parameterValues = new SqlParameter[] { new SqlParameter("@ContactId", contactId) }; using (SqlDataReader reader = SqlHelper.Default.ExecuteReader("spSupplierContact_SelRec", parameterValues)) { if (reader.Read()) { SupplierContact result = new SupplierContact(); result.LoadFromReader(reader); return(result); } else { return(null); } } }
/// <summary> /// Loads a SupplierContact object from the database using the given where clause /// </summary> /// <param name="whereClause">The filter expression for the query</param> /// <returns>A SupplierContact object</returns> public static SupplierContact LoadWhere(string whereClause) { SqlParameter[] parameterValues = new SqlParameter[] { new SqlParameter("@WhereClause", whereClause) }; using (SqlDataReader reader = SqlHelper.Default.ExecuteReader("spSupplierContact_SelAll", parameterValues)) { if (reader.Read()) { SupplierContact result = new SupplierContact(); result.LoadFromReader(reader); return(result); } else { return(null); } } }
private static bool IgnorThis(SupplierContact target, string parentFilter) { bool result = true; parentFilter = parentFilter.Replace(" ", ""); // remove spaces parentFilter = parentFilter.Replace("'", ""); // remove ' string [] parsed = parentFilter.Split('='); // parse if (target.SupplierId == Guid.Empty) { PropertyInfo pi = target.GetType().GetProperty(parsed[0]); string filterField = (string)pi.GetValue(target, null); if (filterField.ToLower() == parsed[1].ToLower()) { result = false; } } else { SupplierContact parentTemplate = SupplierContact.Load(target.SupplierId); result = IgnorThis(parentTemplate, parentFilter); } return(result); }