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