protected void grid_AutoFilterCellEditorCreate(object sender, ASPxGridViewEditorCreateEventArgs e) { if (!IsCustomColumnFiltering(e.Column)) { return; } ComboBoxProperties combo = new ComboBoxProperties(); combo.Items.Add("Show All", ShowAllFilterId); if (Equals(e.Column, grid.Columns["Quantity"])) { for (int i = 0; i < 130 / IntStep; i++) { combo.Items.Add(string.Format("From {0} to {1}", i * IntStep, (i + 1) * IntStep - 1), i); } } if (Equals(e.Column, grid.Columns["UnitPrice"])) { for (int i = 0; i < 300 / DecimalStep; i++) { combo.Items.Add(string.Format("Less than {0:c}", (i + 1) * DecimalStep), i); } } if (Equals(e.Column, grid.Columns["CompanyName"])) { for (int i = 0; i <= 26 / SymbolStep; i++) { char[] values = GetSymbolValue(i); combo.Items.Add(string.Format("From {0} to {1}", values[0], values[1]), i); } } e.EditorProperties = combo; }
protected void ASPxGridView1_AutoFilterCellEditorCreate(object sender, DevExpress.Web.ASPxGridViewEditorCreateEventArgs e) { if (e.Column.FieldName != "Month") { return; } ComboBoxProperties comboBoxProp = new ComboBoxProperties(); e.EditorProperties = comboBoxProp; }
protected void grid_AutoFilterCellEditorCreate(object sender, ASPxGridViewEditorCreateEventArgs e) { if (e.Column.FieldName != "Value") { return; } ComboBoxProperties combo = new ComboBoxProperties(); combo.EnableCallbackMode = true; combo.CallbackPageSize = 10; combo.IncrementalFilteringMode = IncrementalFilteringMode.Contains; e.EditorProperties = combo; }
private ComboBox BuildComboBox(object data, BuildContext bc) { ComboBoxProperties properties = DataNodeWrapper.GetNodeAttributes(data).To <ComboBoxProperties>(); JSObject[] children = DataNodeWrapper.GetNodeChildren(data); Menu menu = null; MenuLauncherControlProperties launcherProperties = DataNodeWrapper.GetNodeAttributes(data).To <MenuLauncherControlProperties>(); Dictionary <string, string> menuItems = null; if (!Utility.IsTrue(launcherProperties.PopulateDynamically)) { // Since PopulateDynamically is not true, we pass in "false" for LazyInit menu = BuildMenu(children[0], bc, false); // Parse XML subtree to build MenuItem list for auto-complete menuItems = new Dictionary <string, string>(); JSObject[] sections = DataNodeWrapper.GetNodeChildren(children[0]); int l = sections.Length; for (int i = 0; i < l; i++) { // Get children of the MenuSection node JSObject[] sectionChildren = DataNodeWrapper.GetNodeChildren(sections[i]); // Get children of the Controls node within the MenuSection // There should only be 1 Controls node within the MenuSection subtree JSObject[] items = DataNodeWrapper.GetNodeChildren(sectionChildren[0]); int m = items.Length; for (int j = 0; j < m; j++) { string labeltext = DataNodeWrapper.GetAttribute(items[j], DataNodeWrapper.LABELTEXT); string menuitemid = DataNodeWrapper.GetAttribute(items[j], DataNodeWrapper.MENUITEMID); menuItems[labeltext] = menuitemid; } } } ComboBox fscb = new ComboBox(Root, properties.Id, properties, menu); fscb.MenuItems = menuItems; return(fscb); }
EditPropertiesBase CreateComboBoxProperties(object value) { bool v = value != null && (bool)value; var props = new ComboBoxProperties(); props.ValueType = typeof(bool); props.Items.Add(new ListEditItem("Need alert", true) { Selected = v }); props.Items.Add(new ListEditItem("Is's ok", false) { Selected = !v }); return(props); }
protected void grid_AutoFilterCellEditorCreate(object sender, ASPxGridViewEditorCreateEventArgs e) { ASPxGridView grid = sender as ASPxGridView; if (e.Column.FieldName != "CategoryName") { return; } ComboBoxProperties combo = new ComboBoxProperties(); string command = string.Format("SELECT DISTINCT [{0}] FROM [CategoriesFilter]", e.Column.FieldName); AccessDataSource ds = new AccessDataSource(AccessDataSource1.DataFile, command); DataView dv = ds.Select(DataSourceSelectArguments.Empty) as DataView; combo.Items.Add(ShowAllFilterId); for (int i = 0; i < dv.Count; i++) { combo.Items.Add(dv[i][0].ToString()); } e.EditorProperties = combo; }
private void ComponentsCombo_LostFocus(object sender, RoutedEventArgs e) { ComboBoxProperties comboboxproperties = new ComboBoxProperties(); for (int i = 0; i < comboboxproperties.Products.Count; i++) { if (ProductsCombo.SelectedItem == null) { ComponentsCombo.IsEnabled = false; } else { if (comboboxproperties.Products[i] == ProductsCombo.SelectedItem) { ComponentsCombo.IsEnabled = false; } else { ComponentsCombo.IsEnabled = true; } } } }
public static ComboBoxProperties InitColumnLookupEdit(ComboBoxProperties cboProperty, STGridColumnsInfo objGridColumnInfo) { string sTGridColumnRepository = objGridColumnInfo.STGridColumnRepository; if (string.IsNullOrEmpty(sTGridColumnRepository)) { //GMCDbUtil.GetPrimaryTableWhichForeignColumnReferenceTo(objGridColumnInfo.STGridColumnTableName, objGridColumnInfo.STGridColumnName); } string lookupQueryColumn = GetLookupQueryColumn(objGridColumnInfo); TryToInitLookupTable(sTGridColumnRepository, lookupQueryColumn); if (!GMCWebApp.LookupTables.ContainsKey(sTGridColumnRepository)) { return(null); } DataView dvLookupTable = new DataView(); string strPrimaryRepostory = GMCDbUtil.GetTablePrimaryColumn(sTGridColumnRepository); if (GMCDbUtil.IsForeignKey(sTGridColumnRepository, objGridColumnInfo.STGridColumnRepoDsplMem)) { string primaryTableWhichForeignColumnReferenceTo = GMCDbUtil.GetPrimaryTableWhichForeignColumnReferenceTo(sTGridColumnRepository, objGridColumnInfo.STGridColumnRepoDsplMem); if (!string.IsNullOrEmpty(primaryTableWhichForeignColumnReferenceTo)) { string str7 = GMCWebApp.GetLookupQueryColumn(primaryTableWhichForeignColumnReferenceTo); if (string.IsNullOrEmpty(str7)) { str7 = "*"; } else { str7 = str7.Replace(",", ",b."); } string strQuery = string.Format("SELECT a.{0},b.{5}\r\n FROM {1} a\r\n INNER JOIN {2} b ON a.{3} = b.{4}", new object[] { strPrimaryRepostory, sTGridColumnRepository, primaryTableWhichForeignColumnReferenceTo, objGridColumnInfo.STGridColumnRepoDsplMem, GMCDbUtil.GetTablePrimaryColumn(primaryTableWhichForeignColumnReferenceTo), str7 }); DataSet dataSet = BusinessControllerFactory.GetBusinessController(sTGridColumnRepository + "Controller").GetDataSet(strQuery); if ((dataSet != null) && (dataSet.Tables.Count > 0)) { string strLookupTableName = sTGridColumnRepository + "_" + primaryTableWhichForeignColumnReferenceTo; dvLookupTable = dataSet.Tables[0].DefaultView; if (!GMCWebApp.LookupTables.ContainsKey(strLookupTableName)) { GMCWebApp.LookupTables.Add(strLookupTableName, dataSet.Tables[0]); } else { GMCWebApp.LookupTables[strLookupTableName] = dataSet.Tables[0]; } } } } else { dvLookupTable = GMCWebApp.LookupTables[sTGridColumnRepository].DefaultView; } string sTGridColumnRepoDsplMem = objGridColumnInfo.STGridColumnRepoDsplMem; if (!dvLookupTable.Table.Columns.Contains(sTGridColumnRepoDsplMem)) { sTGridColumnRepoDsplMem = ""; } if (string.IsNullOrEmpty(sTGridColumnRepoDsplMem)) { sTGridColumnRepoDsplMem = strPrimaryRepostory.Substring(0, strPrimaryRepostory.Length - 2) + "No"; } if (GMCDbUtil.IsForeignKey(sTGridColumnRepository, objGridColumnInfo.STGridColumnRepoDsplMem)) { string str13 = GMCDbUtil.GetPrimaryTableWhichForeignColumnReferenceTo(sTGridColumnRepository, objGridColumnInfo.STGridColumnRepoDsplMem); if (string.IsNullOrEmpty(objGridColumnInfo.STGridColumnRepoCol1)) { sTGridColumnRepoDsplMem = str13.Substring(0, str13.Length - 1) + "No"; } else { sTGridColumnRepoDsplMem = objGridColumnInfo.STGridColumnRepoCol1; } } if (cboProperty == null) { cboProperty = new ComboBoxProperties(); } DataTable dtLookupTable = dvLookupTable.ToTable(false, strPrimaryRepostory, sTGridColumnRepoDsplMem); cboProperty.DataSource = dtLookupTable.DefaultView; cboProperty.TextField = sTGridColumnRepoDsplMem; cboProperty.ValueField = strPrimaryRepostory; cboProperty.ValueType = GMCDbUtil.GetCSharpVariableType(objGridColumnInfo.STGridColumnTableName, objGridColumnInfo.STGridColumnName); cboProperty.DropDownStyle = DropDownStyle.DropDownList; if (string.IsNullOrEmpty(objGridColumnInfo.STGridColumnRepoCol1)) { ListBoxColumn column = new ListBoxColumn(sTGridColumnRepoDsplMem); if (sTGridColumnRepoDsplMem.EndsWith("No")) { column.Caption = "Mã số"; column.Width = 50; } else if (sTGridColumnRepoDsplMem.EndsWith("Name")) { column.Caption = "Tên"; column.Width = 200; } cboProperty.Columns.AddColumn(dtLookupTable, column); if (!GMCDbUtil.IsForeignKey(sTGridColumnRepository, objGridColumnInfo.STGridColumnRepoDsplMem)) { ListBoxColumn column1 = new ListBoxColumn(); if (sTGridColumnRepoDsplMem.EndsWith("No")) { column1.FieldName = sTGridColumnRepoDsplMem.Substring(0, sTGridColumnRepoDsplMem.Length - 2) + "Name"; column1.Caption = GMCWebApp.GetControlText("Tên"); column1.Width = 200; } else if (sTGridColumnRepoDsplMem.EndsWith("Name")) { column1.FieldName = sTGridColumnRepoDsplMem.Substring(0, sTGridColumnRepoDsplMem.Length - 4) + "No"; column1.Caption = GMCWebApp.GetControlText("Mã số"); column1.Width = 50; } cboProperty.Columns.AddColumn(dtLookupTable, column1); } } else { ListBoxColumn info6 = new ListBoxColumn { FieldName = objGridColumnInfo.STGridColumnRepoCol1, Caption = GMCWebApp.GetControlText(objGridColumnInfo.STGridColumnRepoCol1Caption), Width = 100 }; cboProperty.Columns.AddColumn(dtLookupTable, info6); if (!string.IsNullOrEmpty(objGridColumnInfo.STGridColumnRepoCol2)) { ListBoxColumn info7 = new ListBoxColumn { FieldName = objGridColumnInfo.STGridColumnRepoCol2, Caption = GMCWebApp.GetControlText(objGridColumnInfo.STGridColumnRepoCol2Caption), Width = 100, }; cboProperty.Columns.AddColumn(dtLookupTable, info7); } if (!string.IsNullOrEmpty(objGridColumnInfo.STGridColumnRepoCol3)) { ListBoxColumn info8 = new ListBoxColumn { FieldName = objGridColumnInfo.STGridColumnRepoCol3, Caption = GMCWebApp.GetControlText(objGridColumnInfo.STGridColumnRepoCol3Caption), Width = 100 }; cboProperty.Columns.AddColumn(dtLookupTable, info8); } if (!string.IsNullOrEmpty(objGridColumnInfo.STGridColumnRepoCol4)) { ListBoxColumn info9 = new ListBoxColumn { FieldName = objGridColumnInfo.STGridColumnRepoCol4, Caption = GMCWebApp.GetControlText(objGridColumnInfo.STGridColumnRepoCol4Caption), Width = 100 }; cboProperty.Columns.AddColumn(dtLookupTable, info9); } if (!string.IsNullOrEmpty(objGridColumnInfo.STGridColumnRepoCol5)) { ListBoxColumn info10 = new ListBoxColumn { FieldName = objGridColumnInfo.STGridColumnRepoCol5, Caption = GMCWebApp.GetControlText(objGridColumnInfo.STGridColumnRepoCol5Caption), Width = 100 }; cboProperty.Columns.AddColumn(dtLookupTable, info10); } } if (!string.IsNullOrEmpty(objGridColumnInfo.STGridColumnRepoDsplMem)) { int idx = cboProperty.Columns.Cast <ListBoxColumn>().ToList().FindIndex(x => x.FieldName.Equals(objGridColumnInfo.STGridColumnRepoDsplMem)); if (idx != -1) { cboProperty.TextFormatString = "{" + idx.ToString() + "}"; } } return(cboProperty); }
public static void BindComboBoxToEnum(ComboBoxProperties prop, Type enumType) { prop.ValueType = enumType; PopulateComboBoxItems(prop.Items, enumType); }