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);
}
}
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;
}
