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