public static void SetDatasetParameter(DBDataset Dataset, string ParameterName, object ParamValue)
{
SelectQuery sq = Dataset.SelectQuery;
sq.Parameters[ParameterName].Value = ParamValue;
}
public static void EnableDatasetFilter(DBDataset Dataset, string FilterName, bool Enabled)
{
SelectQuery sq = Dataset.SelectQuery;
sq.get_Items(0).Filters[FilterName].IsEnabled = Enabled;
}
public static void SetDatasetFieldOrdering(DBDataset Dataset, String FieldName,
OrderTypeEnum OrderType, int Position)
{
if (Dataset.SelectQuery.Columns[FieldName] != null) {
Dataset.SelectQuery.Columns[FieldName].OrderType = OrderType;
Dataset.SelectQuery.Columns[FieldName].OrderPosition = Position;
}
}
public static void ApplyDatasetFilter(DBDataset Dataset, string FilterName, object ParamValue, bool Enabled)
{
EnableDatasetFilter(Dataset, FilterName, Enabled);
SetDatasetParameter(Dataset, FilterName, ParamValue);
}
