public DbFilterFieldCollection FetchAll() { DbFilterFieldCollection coll = new DbFilterFieldCollection(); Query qry = new Query(DbFilterField.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
protected void get_filters() { DbFilterFieldCollection _filter = new DbFilterFieldCollection().Load(); DataTable _dt = (DataTable)_filter.ToDataTable(); for (Int32 ix = 0; ix <= _dt.Rows.Count - 1; ix++) { DevExpress.Web.ASPxEditors.FilterControlColumn _col = new DevExpress.Web.ASPxEditors.FilterControlColumn(); _col.DisplayName = _dt.Rows[ix]["filter_caption"].ToString(); _col.PropertyName = _dt.Rows[ix]["field_name"].ToString(); _col.ColumnType = get_column_type(_dt.Rows[ix]["column_type"].ToString()); this.advancedFilter.Columns.Add(_col); } }
public DbFilterFieldCollection FetchBySourceForm(string sourceform) { //string _src = wwi_security.DecryptString(sourceform, "publiship"); DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("applies_to", sourceform).Where("is_active", true).OrderByAsc("sort_order").Load(); return coll; }
public DbFilterFieldCollection FetchByContainers() { DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("applies_to", "container").Load(); return coll; }
public DbFilterFieldCollection FetchByDeliveries() { DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("applies_to", "delivery").Load(); return coll; }
public DbFilterFieldCollection FetchByActiveAdvance() { DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("applies_to", "advance").Where("is_active", true).OrderByAsc("sort_order").Load(); return coll; }
public DbFilterFieldCollection FetchByActiveAnonymous() { DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("is_quick_filter", true).Where("applies_to", "shipment").Where("login_required", false).OrderByAsc("sort_order").Load(); return coll; }
public DbFilterFieldCollection FetchByQuery(Query qry) { DbFilterFieldCollection coll = new DbFilterFieldCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public DbFilterFieldCollection FetchByID(object FilterFieldId) { DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("filter_field_ID", FilterFieldId).Load(); return coll; }